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.
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.
thank you, I'll try this right now.
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.
thank you Venkat, I'll try this asap.
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.