topic Converting City or Zip Code Data to Coordinates in Geoprocessing Questions

Converting City or Zip Code Data to Coordinates

JamesStewart-Moore1 — Mon, 08 Apr 2019 16:50:56 GMT

I am wondering if anyone is aware of a tool/method to convert city data or zip code data into coordinated, either will suffice. I have a .csv file with approximately 750k rows of data that include "city" and "zipcode" fields. I would like to be able to find a way to associate each row with coordinates, so that I can display it.. other than looking up coordinates from Google 750k times.

Thank You!

Re: Converting City or Zip Code Data to Coordinates

JoeBorgione — Mon, 08 Apr 2019 16:55:36 GMT

What is your area of interest? Can you get a feature class of the cities and or zip codes? For example, where I work we have all the City Polygons and all the Zip codes as polygons in feature classes: for me at least, I can extract the xy centroid of each.

If you have the reference data, life is so much easier!

Re: Converting City or Zip Code Data to Coordinates

JamesStewart-Moore1 — Mon, 08 Apr 2019 21:00:20 GMT

The file contains data from across the United States, including HI and AK, so the data would need to contain city/zip info for all 50 states.

This might be a good place to start, though. Thanks!

Re: Converting City or Zip Code Data to Coordinates

JoeBorgione — Mon, 08 Apr 2019 22:02:29 GMT

Check the ESRI Living Atlas in AGOL: they have zipcodes and states...

Re: Converting City or Zip Code Data to Coordinates

PavanYadav — Tue, 09 Apr 2019 17:53:19 GMT

You can geocode your table. See this tutorial: https://pro.arcgis.com/en/pro-app/help/data/geocoding/tutorial-geocode-a-table-of-addresses.htm

Note, you can geocode in ArcGIS Online or ArcGIS Pro (ArcMap) but if you're using Esri World Geocoding Service, you will charged with credits.

If you don't want to spend Esri Credits, you can create your own Locator using publicly available data e.g. from data.gov. Zip Codes - ZipCodes - Data.gov. See this help document on how to build a locator: https://pro.arcgis.com/en/pro-app/help/data/geocoding/create-a-locator.htm

Re: Converting City or Zip Code Data to Coordinates

CatherineHall678 — Fri, 17 May 2024 15:26:09 GMT

This is great thank you, I am geocoding w/o cities and just zipcode so I'll make sure to post how this goes.

Also the zipcdoes -Data,gov no longer works.

Re: Converting City or Zip Code Data to Coordinates

CatherineHall678 — Fri, 17 May 2024 16:59:56 GMT

I found this site. Customer only gave me Zipcode in excel format and had to find data to enrich with to start geocoding. This site also has other available formats for download. All Postal Code - All countries (Geonames) — Data hub (opendatasoft.com)