SQL Server Support for the new Australian GDA2020 Datum

Question

We currently utilise SQL Server 2016 to store and manipulate masses of spatial data for our Local Government entity, and have found that SQL Server 2016 does not recognise the 'new' Australian spatial geometry of GDA2020.

Will there either be a SQL Server version or patch be available to be compatible with the new datum?

Tony Jordan

GIS Coordinator

Mount Barker District Council

South Australia

Answer 1

Hi Tony Jordan,

 

Based on my test, the Australian Geodetic Datum 2020 is not supported in the latest SQL Server version(SQL Server 2019).

 

Here is the list for all the spatial reference systems with "Australian Geodetic Datum" supported by SQL Server 2019.

 

select spatial_reference_id, authority_name, well_known_text  from sys.spatial_reference_systems where
well_known_text like '%Australian Geodetic Datum%'

/**Results

spatial_reference_id authority_name                                                                                                                  
well_known_text

----------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

4202                 EPSG                                                                                                                            
GEOGCS["AGD66", DATUM["Australian Geodetic Datum
1966", ELLIPSOID["Australian National Spheroid", 6378160,
298.25]], PRIMEM["Greenwich", 0], UNIT["Degree",
0.0174532925199433]]

4203                 EPSG                                                                                                                            
GEOGCS["AGD84", DATUM["Australian Geodetic Datum
1984", ELLIPSOID["Australian National Spheroid", 6378160,
298.25]], PRIMEM["Greenwich", 0], UNIT["Degree",
0.0174532925199433]]

*/

 

Best Regards,

Emily

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 2

Hi Emily,

Thanks for your reply. We currently use the datum Geocentric Datum of Australia 94 (GDA94) (not to be confused with AGD Australian Geodetic Datum) within the SQL Server 2016, and so I tried your query using the Geocentric Datum of Australia text and the below was returned. Maybe try rerunning the query in SQL Server 2019 as you did and see if same as below... Please let me know how you have gone with this test.

spatial_reference_id authority_name well_known_text
4283 EPSG GEOGCS["GDA94", DATUM["Geocentric Datum of Australia 1994", ELLIPSOID["GRS 1980", 6378137, 298.257222101]], PRIMEM["Greenwich", 0], UNIT["Degree", 0.0174532925199433]]
4939 EPSG GEOGCS["GDA94", DATUM["Geocentric Datum of Australia 1994", ELLIPSOID["GRS 1980", 6378137, 298.257222101]], PRIMEM["Greenwich", 0], UNIT["Degree", 0.0174532925199433]]

Regards,

Tony Jordan

Answer 3

Hi Tony Jordan,

 

In SQL Server 2019, it returns same results like your test in SQL Server 2016.

 

 

select well_known_text  from sys.spatial_reference_systems where
well_known_text like '%Geocentric Datum of Australia %'

select @@VERSION

/**Results
well_known_text
--------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------
GEOGCS["GDA94", DATUM["Geocentric Datum of Australia 1994", ELLIPSOID["GRS 1980", 6378137, 298.257222101]], 
PRIMEM["Greenwich", 0], UNIT["Degree", 0.0174532925199433]]

GEOGCS["GDA94", DATUM["Geocentric Datum of Australia 1994", ELLIPSOID["GRS 1980", 6378137, 298.257222101]], 
PRIMEM["Greenwich", 0], UNIT["Degree", 0.0174532925199433]]

----------------------------------------------------------------------------------------------------------
Microsoft SQL Server vNext (CTP2.0) - 15.0.1000.34 (X64) 
	Sep 18 2018 02:32:04 
	Copyright (C) 2018 Microsoft Corporation
	Developer Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 17134: )
*/

  

Best Regards,

Emily

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 4

Hi Tony,

support for GDA2020 has been added to SQL Server version 2014 and newer - SRIDs 7843 and 7844.

It's also available in Azure SQL Database.

Please check this article for more information about cumulative updates for specific version of SQL Server:

https://support.microsoft.com/en-us/help/4506023/fix-geocentric-datum-of-australia-2020-is-added-to-sql-server-2014-201

Best,

Mladen