PRIMEM is in second not in degree ! ?
385386May 5 2003 — edited May 6 2003in column WKTEXT, table MDSYS.CS_SRS
when your local meridian is not Greenwich, if you put the PRIMEN in degree, you will have bad result,
for example all French Lambert projections give bad results
select SDO_CS.TRANSFORM(mdsys.sdo_geometry(2001,41014,mdsys.sdo_point_type(600000,2200000,NULL),NULL,NULL), 8192) from dual;
give:
SDO_GEOMETRY(2001, 8192, SDO_POINT_TYPE(54.0263204, 46.7997975, NULL), NULL, NULL)
but if you copy the value of projection #41014 replacing PRIMEM of Paris from 2.337229167 to 0.000649230324167 results are goods
insert into mdsys.cs_srs values (
'French Lambert II Carto OK',1000100,41014,'Oracle',
'PROJCS["French Lambert II Carto OK",
GEOGCS [ "NTF (Paris meridian)",
DATUM ["NTF (Paris meridian)",
SPHEROID ["Clarke 1880 (IGN)", 6378249.200000, 293.466021]],
PRIMEM [ "Paris", 0.000649230324167],
UNIT ["Decimal Degree", 0.01745329251994330]],
PROJECTION ["Lambert Conformal Conic"],
PARAMETER ["Standard_Parallel_1", 45.898919],
PARAMETER ["Standard_Parallel_2", 47.696015],
PARAMETER ["Latitude_Of_Origin", 46.800000],
PARAMETER ["False_Easting", 600000.0],
PARAMETER ["False_Northing", 2200000.0],
UNIT ["Meter", 1.0]]',
NULL);
select SDO_CS.TRANSFORM(mdsys.sdo_geometry(2001,1000100,mdsys.sdo_point_type(600000,2200000,NULL),NULL,NULL),
8192) from dual;
give:
SDO_GEOMETRY(2001, 8192, SDO_POINT_TYPE(2.33653361, 46.7999488, NULL), NULL, NULL)
can anyone confirm this ?