Spatial Data Transformation (Doc ID 2971756.1)

Last updated on JULY 20, 2024

Applies to:

Goal

How to move spatial data in one SRID i.e.
 moving data from table A

 having a SHAPE value like MDSYS.SDO_GEOMETRY(3302,4269, ....

 with metadata like

((, -180, 180, 0.001), (, -90, 90, 0.001), (M, -100, 53587.091175, 0.001), ) 4269

To table B with a geometry having user_sdo_geom_metadata dim_info & srid values like
 ((X, -180, 180, 5E-6), (Y, -90, 90, 5E-6), (Z, 0, 214748.3647, 5E-7), ) 4326

Is using sdo_cs.transform sufficient, or is there something else that should be done to accommodate the different dim_info?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.