Select to view content in your preferred language

Trouble with converting a table to xy coordinates

653
5
01-29-2026 01:14 PM
Labels (1)
ChristianDeSimone
Emerging Contributor

I have a table with data such as zip code, state, city, street address, etc. This table is a downloaded csv from member data for an organization I work for. I am trying to convert the zip codes I have in the table into xy coordinates that way I can see where on a map each of the points of data is located. Whenever I try to convert the table into xy coordinates it says I need to create a locator. I then go to creating a locator and it says the data I have "does not contain geometry". Whenever I try to create geometry for my dataset it does not show up as an option to select as an input feature, nor does it come up when I browse the computer.  How do I make it so the table I have shows up as an option to select as an input feature to then do the other steps.

Am I going about the process the right way for turning a table I have into xy coordinates for the zip codes? I don't want to create xy coordinates for the street addresses as a level of privacy, I understand that would be more accurate of a point.  

0 Kudos
5 Replies
Neal_t_k
MVP Regular Contributor

Why not just join your csv to an exiting zip code polygon layer,  something like this:  https://www.arcgis.com/home/item.html?id=5f31109b46d541da86119bd4cf213848

You could then export the matching results, then you don't have worry about geocoding your CSV.

ChristianDeSimone
Emerging Contributor

thank you, I'll try this right now.

0 Kudos
VenkataKondepati
Frequent Contributor

The tutorial below will help you to geocode your addresses.

Tutorial: Geocode a table of addresses—ArcGIS Pro | Documentation
Geocode Addresses (Geocoding)—ArcGIS Pro | Documentation

Basically, you need add the csv file to ArcGIS pro -> Geocode table. You can follow the steps from the documentation above. You can select address fields.

Regards,
Venkat
Book a meeting with me:Get on a Call
Follow me on: LinkedIn

If this response helps or is the solution to your post, please consider marking it as a solution
ChristianDeSimone
Emerging Contributor

thank you Venkat, I'll try this asap.

BobBooth1
Esri Regular Contributor

Instead of creating XY coordinates, try:

1. Add the CSV table to ArcGIS Pro

2. In the Contents pane, right-click the table and click Geocode Table.

Geocode_table_1.png

3 .Step through the wizard:

4. Choose the ArcGIS World Geocoding Service (this will consume credits at a rate of 40cr/1000 addresses).

5. Specify one field (the zipcode field).

6. Specify US locations.

7. Specify the type of locations (Address, Postal, Populated places).

Geocode_table_3.png

Check the credit use and run the tool.

You should get back points - one feature per row, at the zipcode centroid.

Geocode_table_4.png

 

If you don't want to use the default locator, you can build your own, but you need a feature class of the zipcode points or polygons to build the locator against.

 

 

0 Kudos