22 SDO_CS Package (Coordinate System Transformation)

The MDSYS.SDO_CS package contains subprograms for working with coordinate systems.

You can perform explicit coordinate transformations on a single geometry or an entire layer of geometries (that is, all geometries in a specified column in a table).

To use the subprograms in this chapter, you must understand the conceptual information about coordinate systems in Coordinate System and Coordinate Systems (Spatial Reference Systems).

The rest of this chapter provides reference information on the subprograms, listed in alphabetical order.

• SDO_CS.ADD_PREFERENCE_FOR_OP
  
• SDO_CS.CONVERT_3D_SRID_TO_2D
  
• SDO_CS.CONVERT_NADCON_TO_XML
  
• SDO_CS.CONVERT_NTV2_TO_XML
  
• SDO_CS.CONVERT_XML_TO_NADCON
  
• SDO_CS.CONVERT_XML_TO_NTV2
  
• SDO_CS.CREATE_CONCATENATED_OP
  
• SDO_CS.CREATE_OBVIOUS_EPSG_RULES
  
• SDO_CS.CREATE_PREF_CONCATENATED_OP
  
• SDO_CS.DELETE_ALL_EPSG_RULES
  
• SDO_CS.DELETE_OP
  
• SDO_CS.DETERMINE_CHAIN
  
• SDO_CS.DETERMINE_DEFAULT_CHAIN
  
• SDO_CS.FIND_GEOG_CRS
  
• SDO_CS.FIND_PROJ_CRS
  
• SDO_CS.FIND_SRID
  
• SDO_CS.FROM_GEOHASH
  
• SDO_CS.FROM_OGC_SIMPLEFEATURE_SRS
  
• SDO_CS.FROM_USNG
  
• SDO_CS.GENERATE_SCRIPT_FROM_SRID
  
• SDO_CS.GET_EPSG_DATA_VERSION
  
• SDO_CS.GET_GEOHASH_CELL_HEIGHT
  
• SDO_CS.GET_GEOHASH_CELL_WIDTH
  
• SDO_CS.INSERT_SRID
  
• SDO_CS.LOAD_EPSG_MATRIX
  
• SDO_CS.MAKE_2D
  
• SDO_CS.MAKE_3D
  
• SDO_CS.MAP_EPSG_SRID_TO_ORACLE
  
• SDO_CS.MAP_ORACLE_SRID_TO_EPSG
  
• SDO_CS.REVOKE_PREFERENCE_FOR_OP
  
• SDO_CS.TO_GEOHASH
  
• SDO_CS.TO_OGC_SIMPLEFEATURE_SRS
  
• SDO_CS.TO_USNG
  
• SDO_CS.TRANSFORM
  
• SDO_CS.TRANSFORM_LAYER
  
• SDO_CS.UPDATE_WKTS_FOR_ALL_EPSG_CRS
  
• SDO_CS.UPDATE_WKTS_FOR_EPSG_CRS
  
• SDO_CS.UPDATE_WKTS_FOR_EPSG_DATUM
  
• SDO_CS.UPDATE_WKTS_FOR_EPSG_ELLIPS
  
• SDO_CS.UPDATE_WKTS_FOR_EPSG_OP
  
• SDO_CS.UPDATE_WKTS_FOR_EPSG_PARAM
  
• SDO_CS.UPDATE_WKTS_FOR_EPSG_PM
  
• SDO_CS.VALIDATE_EPSG_MATRIX
  
• SDO_CS.VALIDATE_WKT