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
Hi Tom --
I'm very interested in whatever you may find. I've taken a different approach to these kinds of projects. For various projects previously, I've batch geocoded addresses using the free geocoder provided by the US Census Bureau (https://www.census.gov/geo/maps-data/data/geocoder.html), then have either used publicly available lookup tables (census tract/block to City District in NYC) or -- at your suggestion -- have used QGIS to join an imported list/table with GIS geo-shapes to query Miami-Dade County districts and similar datasets.
Currently (still) in development, is a Service Interceptor that will geocode addresses using Google's Maps API (which is included as part of the non-profit Google Grant) whenever an address is added or updated. We can then send that geocoded lat/long to any of the publicly available GIS datasets (typically available from your county or city). The Service Interceptor will facilitate those lookups and then write back lat/long to the [geo_location] field in [T_ADDRESS] and the data we're interested in to specific keywords/attributes. I'm hoping to have that ready to demo by TLCC 2019 and happily share.
DGomez
In what language did you code your geocoder of Tessitura Data?
Are you willing to share?