SDO_CS.TRANSFORM_LAYER( table_in IN VARCHAR2, column_in IN VARCHAR2, table_out IN VARCHAR2, to_srid IN NUMBER);
SDO_CS.TRANSFORM_LAYER( table_in IN VARCHAR2, column_in IN VARCHAR2, table_out IN VARCHAR2, use_plan IN TFM_PLAN);
SDO_CS.TRANSFORM_LAYER( table_in IN VARCHAR2, column_in IN VARCHAR2, table_out IN VARCHAR2, use_case IN VARCHAR2, to_srid IN NUMBER);
Transforms an entire layer of geometries (that is, all geometries in a specified column in a table).
Table containing the layer (
column_in) whose geometries are to be transformed.
table_in that contains the geometries to be transformed.
Table that will be created and that will contain the results of the transformation. See the Usage Notes for information about the format of this table.
The SRID of the coordinate system to be used for the transformation.
to_srid must be a value in the SRID column of the SDO_COORD_REF_SYS table (described in SDO_COORD_REF_SYS Table).
Transformation plan. The TFM_PLAN object type is explained in TFM_PLAN Object Type.
Name of the use case whose transformation rules are to be applied in performing the transformation. Use cases are explained in EPSG Model and Spatial and Graph.
Transformation can be done only between two different georeferenced coordinate systems or between two different local coordinate systems.
An exception is raised if any of the following occurs:
table_in does not exist, or
column_in does not exist in the table.
The geometries in
column_in have a null or invalid SDO_SRID value.
table_out already exists.
to_srid is invalid.
table_out table is created by the procedure and is filled with one row for each transformed geometry. This table has the columns shown in Table 20-2.
Table 20-2 Table to Hold Transformed Layer
|Column Name||Data Type||Description|
Oracle ROWID (row address identifier). For more information about the ROWID data type, see Oracle Database SQL Language Reference.
Geometry object with coordinate values in the specified (
The following example transforms the geometries in the
shape column in the COLA_MARKETS_CS table to a representation that uses SRID value 8199. The transformed geometries are stored in the newly created table named COLA_MARKETS_CS_8199. (This example uses the definitions from the example in Example of Coordinate System Transformation.)
-- Transform the entire SHAPE layer and put results in the table -- named cola_markets_cs_8199, which the procedure will create. CALL SDO_CS.TRANSFORM_LAYER('COLA_MARKETS_CS','SHAPE','COLA_MARKETS_CS_8199',8199);
The example in Example of Coordinate System Transformation includes a display of the geometry object coordinates in both tables (COLA_MARKETS_CS and COLA_MARKETS_CS_8199).