topic Re: Zip code data in csv join to shapefile (state county boarder) in ArcGIS Pro Questions

Zip code data in csv join to shapefile (state county boarder)

chagithebear — Wed, 27 Jul 2022 18:46:56 GMT

Hi everyone. I wondered if ArcGIS Pro could populate a CSV file filled with data like zip codes and other variables by joining a shapefile (more specifically, a state county border). I believe this be accomplished with geocoding and selecting by location to appear on the map/county shapefile.

Please correct me if I am wrong and I greatly welcome any tips or suggestions! Thank you!

Elissa

Re: Zip code data in csv join to shapefile (state county boarder)

AdrianaAbramovich — Wed, 27 Jul 2022 18:58:22 GMT

Elissa, you could convert the feature class or shapefile into an excel file.
Steps:

1. Geoprocessing tool, select convert table to excel.
2. Right-click on the shapefile and convert it to excel.
3. If it is a service, clip the zip codes to the boundary of your county or city, then procede with the conversion from table to excel.
Happy to help. Adriana

Re: Zip code data in csv join to shapefile (state county boarder)

chagithebear — Wed, 27 Jul 2022 19:26:46 GMT

Thank you Adriana,

Can you explain the logic behind this method? Why would I need to convert the shapefile into an excel file to populate the data csv file?