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.


1 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.