Mapping Longitude and Latitude to US state

Question

Is there any database (Gov data or private) or web service that map Longitude and Latitude to US state?

I have the specific Longitude and Latitude of a location and would want to identify the state that this location is in. Then repeat this for thousands and millions of records.

If you have access to a GIS a spatial join to the US Census states layer would work. The layer is publicly available on the census website. — Kingfisher, Apr 06 '16 at 15:59
If you want to use a public webservice http://wiki.openstreetmap.org/wiki/Nominatim#Reverse_Geocoding — Lennert De Feyter, Dec 26 '17 at 10:48

score 2 · Answer 1 · edited Jul 22 '19 at 20:09

2

Download the state boundary shapefiles from US Census bureau.

Load the polygon shapefiles into SQL using Shape2SQL.

If you don't already have a geography column on your points table, add it.

Do a spatial join using code similar to this.

edited Jul 22 '19 at 20:09

Glorfindel

1,096
2
9
14

answered Apr 06 '16 at 16:01

Kirk Kuykendall

25,787
8
65
153

Mapping Longitude and Latitude to US state

1 Answers1