Hi everyone! I'm excited to join the ESRI community. My question has to do with linking latitude/longitude to county in the US.

503
2
Jump to solution
10-12-2016 04:25 PM
MattCutler
New Contributor

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

0 Kudos
1 Solution

Accepted Solutions
forestknutsen1
MVP Regular Contributor

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

View solution in original post

2 Replies
DarrenWiens2
MVP Honored Contributor

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.

forestknutsen1
MVP Regular Contributor

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