Asked by:
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
- Moved by Tom Phillips Friday, November 2, 2018 12:03 PM Spatial data question
Wednesday, October 31, 2018 10:38 PM
All replies
-
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 MSDNFSF@microsoft.comThursday, November 1, 2018 3:27 AM -
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
- Proposed as answer by Emily FeiMicrosoft contingent staff Monday, November 5, 2018 1:00 AM
Friday, November 2, 2018 5:52 AM -
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 MSDNFSF@microsoft.com- Proposed as answer by Emily FeiMicrosoft contingent staff Monday, November 5, 2018 1:00 AM
Friday, November 2, 2018 6:48 AM -
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
Thursday, December 5, 2019 3:04 PM