Using Oracle 19c.
How can we define a user-defined projected CRS (documentation section 6.9.2 "Creating a Projected CRS") for this kind of WKT:
PROJCS["DE1200_WGS84",
GEOGCS["GCS_WGS_1984",
DATUM["D_WGS_1984",
SPHEROID["WGS84",6378137.0,298.257223563]],
PRIMEM["Greenwich",0.0],
UNIT["Degree",0.0174532925199433]],
PROJECTION["Stereographic_North_Pole"],
PARAMETER["False_Easting",543196.835217764],
PARAMETER["False_Northing",3622588.861931],
PARAMETER["Central_Meridian",10.0],
PARAMETER["Standard_Parallel_1",60.0],
UNIT["Meter",1.0]]
We want to import our data using this custom CRS and then perform SDO_GEOR.Reproject into SRID 4326.
We tried COORD_OP_METHOD_ID = 9810 Polar Stereographic (variant A) using a "Scale_Factor" (PARAMETER_ID=8805), which delivers a nearly accurate result after re-projection.
Another attempt was COORD_OP_METHOD_ID = 9829 Polar Stereographic (variant B) with "Standard_Parallel" being 60 (PARAMETER_ID=8832), but then the re-projection appears shifted into the south.
Can someone give us a clue on that type of polar stereographic projection?