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).
Table 20-1 lists the coordinate system transformation subprograms.
Table 20-1 Subprograms for Coordinate System Transformation
| Subprogram | Description |
|---|---|
|
Adds a preference for an operation between a source coordinate system and a target coordinate system. |
|
|
Converts a three-dimensional SRID value into a two-dimensional SRID value. |
|
|
Converts a NADCON (North American Datum Conversion) grid in ASCII format to an Oracle Spatial and Graph XML representation. |
|
|
Converts an NTv2 (National Transformation Version 2) grid in ASCII format to an Oracle Spatial and Graph XML representation. |
|
|
Converts an Oracle Spatial and Graph XML representation of a NADCON (North American Datum Conversion) grid to NADCON ASCII format. |
|
|
Converts an Oracle Spatial and Graph XML representation of an NTv2 (National Transformation Version 2) grid to NTv2 ASCII format. |
|
|
Creates a concatenated operation. |
|
|
Creates a basic set of EPSG rules to be applied in certain transformations. |
|
|
Creates a concatenated operation, associating it with a transformation plan and making it preferred either systemwide or for a specified use case. |
|
|
Deletes the basic set of EPSG rules to be applied in certain transformations. |
|
|
Deletes a concatenated operation. |
|
|
Returns the query chain, based on the system rule set, to be used in transformations from one coordinate reference system to another coordinate reference system. |
|
|
Returns the default chain of SRID values in transformations from one coordinate reference system to another coordinate reference system. |
|
|
Returns the SRID values of geodetic (geographic) coordinate reference systems that have the same well-known text (WKT) numeric values as the coordinate reference system with the specified reference SRID value. |
|
|
Returns the SRID values of projected coordinate reference systems that have the same well-known text (WKT) numeric values as the coordinate reference system with the specified reference SRID value. |
|
|
Finds an SRID value for a coordinate system that matches information that you specify. |
|
|
Converts a well-known text string from the Open Geospatial Consortium simple feature format without the |
|
|
Converts a point represented in U.S. National Grid format to a spatial point geometry object. |
|
|
Gets the version number of the EPSG dataset used by Spatial and Graph. |
|
|
Converts a three-dimensional (or more dimensions) geometry into a two-dimensional geometry. |
|
|
Converts a two-dimensional geometry into a three-dimensional geometry. |
|
|
Returns the Oracle Spatial and Graph SRID values corresponding to the specified EPSG SRID value. |
|
|
Returns the EPSG SRID value corresponding to the specified Oracle Spatial and Graph SRID value. |
|
|
Revokes a preference for an operation between a source coordinate system and a target coordinate system. |
|
|
Converts a well-known text string from the Open Geospatial Consortium simple feature format that includes the |
|
|
Transforms a geometry representation using a coordinate system (specified by SRID or name). |
|
|
Transforms an entire layer of geometries (that is, all geometries in a specified column in a table). |
|
|
Updates the well-known text (WKT) description for all EPSG coordinate reference systems. |
|
|
Updates the well-known text (WKT) description for the EPSG coordinate reference system associated with a specified SRID. |
|
|
Updates the well-known text (WKT) description for all EPSG coordinate reference systems associated with a specified datum. |
|
|
Updates the well-known text (WKT) description for all EPSG coordinate reference systems associated with a specified ellipsoid. |
|
|
Updates the well-known text (WKT) description for all EPSG coordinate reference systems associated with a specified coordinate transformation operation. |
|
|
Updates the well-known text (WKT) description for all EPSG coordinate reference systems associated with a specified coordinate transformation operation and parameter for transformation operations. |
|
|
Updates the well-known text (WKT) description for all EPSG coordinate reference systems associated with a specified prime meridian. |
|
|
Validates the well-known text (WKT) description associated with a specified SRID. |
The rest of this chapter provides reference information on the subprograms, listed in alphabetical order.