I will be converting the derived Lat/Long to Geography fields in SQL Server 2008 R2, can you tell me what SRID the Geocoder control uses to generate the Lat/Long Values?
Thanks. bob
I will be converting the derived Lat/Long to Geography fields in SQL Server 2008 R2, can you tell me what SRID the Geocoder control uses to generate the Lat/Long Values?
Thanks. bob
Hi Bob,
The Geocoder Index was created from data in the Geodetic projection using WGS 84, so the output data would be Lat/Long with an EPSG number of 4326.
Thank you. It seems that most data is from this projection, but you have to be sure if you plug it into SQL Server or the geography:: functions don’t work.
bob
That’s true. So you are converting the GeoCoder data from plain dbf to SQL Server, and create your GeoCoder SqlPlugin consuming data from there? I hope everything goes well.