Datum Transformations

In my last post on SQL Server Spatial Datums I discussed the SRID setting, and what it relates to in terms of standard mapping datums, but I mentioned that SQL Server is not a GIS and does not have a facility to perform coordinate transformations between datums, so it is important to execute spatial operations on data sets that relate to the same datum.

In this post I will discuss transforming data sets from one datum to another, and focus more specifically on the change of the Australian datum from the Australian Geodetic Datum (AGD) to the Geocentric Datum of Australia (GDA).

SQL Server Spatial Datums

As part of my investigation of spatial indexes in SQL Server, I performed some analysis on some spatial data sets, so during the import of my spatial data I had to consider the datum for my data, so I thought I would devote this blog post to a dicussion about datums and spatial reference systems in SQL Server.

Spatial Index Tuning Scripts

I have posted some of the scripts I used when performing the analysis for my previous post on Spatial Index Tuning in SQL Server