Trouble with converting a table to xy coordinates

Question

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.

BobBooth1 · Answer

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.

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).

Check the credit use and run the tool.

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

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.

ChristianDeSimone · Answer

thank you Venkat, I'll try this asap.

ChristianDeSimone · Answer

thank you, I'll try this right now.