Get a list of zipcodes form the city name in the Designer

[radhikasood1112]

Hi,

I have the State names and from that I want to get the list of the Zipcodes in the given state.

Can someone please help?

Thank you,

[MarqueeCrew]

@radhikasood1112 ,

The translation of ZIP codes (by State) is a product file that is sold and not generally free.  Even as a $ product, the ZIP table spans States.  It isn't 1:1.  But there is hope.  The US Census creates ZIP Code Tabulation Areas that are approximate.  For free, it is what you get.

https://www2.census.gov/geo/tiger/TIGER2021/ZCTA520/tl_2021_us_zcta520.zip

You can extract the data (get rid of the spatial objects) and create a cross-reference file.  The State field may be a numeric 2 byte (FIPS code).  If it is, you'll need to translate the code (e.g. 06 = CA).

Cheers,

Mark