I've been reading Pro Spatial with SQL Server 2012. It discusses the various spatial-reference systems (SRS) that can be used when defining a coordinate system. According to the book, Google uses WGS 84.
Prior to my exposure the SQL Server's functionality (i.e. Geography data type), I've used the Haversine formula to calculate distances between two lat/lng pairs. I'm assuming that it (the Haversine function) makes some assumptions about the Earth's geoid (perhaps the great-circle distance), which suggests that it is using a particular SRS. Is this correct? Could one make use of other SRS (at least ones that use lat/lng pairs) with the function just by changing the great-circle distance?
أكثر...
Prior to my exposure the SQL Server's functionality (i.e. Geography data type), I've used the Haversine formula to calculate distances between two lat/lng pairs. I'm assuming that it (the Haversine function) makes some assumptions about the Earth's geoid (perhaps the great-circle distance), which suggests that it is using a particular SRS. Is this correct? Could one make use of other SRS (at least ones that use lat/lng pairs) with the function just by changing the great-circle distance?
أكثر...