Question

I m trying to import some Shapefile mapping data into Sql2008. Before I do that, I need to convert it to WGS84 / SRID 4326, because all my existing data is in this format.

This is the source file info:

GEOGCS["GCS_GDA_1994",DATUM["D_GDA_1994",
    SPHEROID["GRS_1980",6378137,298.257222101]],
    PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]]

I ve tried googling for this and haven t had too much luck. Secondly, I ve tried to check the spatial_reference_systems table and I can t see it in there.

eg. SELECT * from sys.spatial_reference_systems

So, can anyone help me? I can t covert it to SRID 4326 if i don t know it s current SRID.

UPDATE 1

I found this page which explains the tech specs of GDA 1994 .. but doesn t hint at any SRID number... ???

UPDATE 2

This search result page also has some interesting results. From here, if you click on the SR-ORG:6643: Australia Albers Equal Area Conic link, it explains that datum .. and it s pretty much identical to the one I m searching for. This means the SRID is 6643.

So is that the answer?

Answer 1

Using FME as my reference, this (GDA94) maps to EPSG:4283, which means that you need to use SRID 4283 (assuming that you re using EPSG-compliant SRID values)

Answer 2

Using this link GDA94 can be mapped to SRID = 4283 covering the Australian continent. If one knows, for example, that it is Western Australia it may be better to use SRID = 28350 and preserve greater accuracy.

UPDATE 1

UPDATE 2

友情链接