Hi all,
I'm checking the accuracy of coordinate transformation in a 10G database. For now I am primarily concern is the conversion from WGS84 to to the Dutch National Grid / Rijksdriehoeksstelsel (RD).
I have some official test data (RDNAPTRANS 2004) provided by the Dutch Cadastre:
-----------------------------------------------------------------------------------------------------------------
From ETRS89 to RD/NAP
Name ETRS89 RD/NAP
latitude (°) longitude (°) h (m) x (m) y (m) NAP (m)
Texel 53.1607530501 4.8247619722 42.8702 117380.1200 575040.3400 1.0000
-----------------------------------------------------------------------------------------------------------------
The full version is found here: http://www.vanvelden.org/static/rdnaptrans2004.txt
I believe the following query should return the correct results for the first coordinate:
-----------------------------------------------------------------------------------------------------------------
SELECT rdv.x, rdv.y, rdv.z
FROM TABLE(sdo_util.getvertices(
SDO_CS.TRANSFORM(
sdo_geometry(2001, 8307, sdo_point_type(4.8247619722, 53.1607530501, 42.8702), NULL, NULL)
,90112)
)
) rdv;
-----------------------------------------------------------------------------------------------------------------
The results are however not as expected, the X and Y differ several meters from the testdata.
-----------------------------------------------------------
rdv.x, rdv.y, rdv.z
117378,750427859 575044,404854452 42,8702
-----------------------------------------------------------
What am I doing wrong? Are the SRIDs wrong, or does the altitude value cause a problem? I have tried several transformation tools, and those give result as expected.