none
SQL Server Support for the new Australian GDA2020 Datum RRS feed

  • 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.com

    Thursday, 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

    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

    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