Details -
I have a spreadsheet containing latitude and longitude for survey respondents' household/place of residence.
I want an indicator of county of residence and would like to know how best to use ArcGIS to link their lat/long coordinates to the county they live in. Thank you!
Cheers!
Matt
Solved! Go to Solution.
One way to do this would be a spatial join.
First get some data for counties
Cartographic Boundary Shapefiles - Counties - Geography - U.S. Census Bureau
Add your sheet to ArcGIS and make points from lat long
How To: Import XY data tables to ArcMap and convert the data to a shapefile
Use Spatial Join—Help | ArcGIS for Desktop to add the county info to the points
Done
Do you have a polygon feature class for counties? If so, convert your spreadsheet to a shapefile (or other feature class), and Spatial Join those points to the counties. If not, I believe you're looking at a geocoding problem, about which others on here can lend more expertise than I can.
One way to do this would be a spatial join.
First get some data for counties
Cartographic Boundary Shapefiles - Counties - Geography - U.S. Census Bureau
Add your sheet to ArcGIS and make points from lat long
How To: Import XY data tables to ArcMap and convert the data to a shapefile
Use Spatial Join—Help | ArcGIS for Desktop to add the county info to the points
Done