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.

Answer 1

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.