Has anyone worked how to do geospatial queries in SQL Server? In particular, I'm interested in Geo Joins between point data (addresses). A Geo Polygons. (Counties and the Like)
The idea is to be able to do a join where you can tell by Lat and Lon if a particular address is in a particular county, or school district, or political jurisdiction.
Anyone having info please reach out. I'd like to learn from you. We have a reporting situation that could really benefit from such an approach.
Thanks.
--Tom
I would like to hear more about this also. Thx!