SEM_APIS.GETV$GEOMETRYVAL

Format

SEM_APIS.GETV$GEOMETRYVAL(
     value_type    IN VARCHAR2, 
     vname_prefix  IN VARCHAR2, 
     vname_suffix  IN VARCHAR2, 
     literal_type  IN VARCHAR2, 
     language_type IN VARCHAR2, 
     long_value    IN CLOB, 
     srid          IN NUMBER, 
     ) RETURN SDO_GEOMETRY;

Description

Returns an SDO_GEOMETRY object in the spatial reference system identified by an input SRID for ogc:wktLiteral or ogc:gmlLiteral typed literals, and returns a null value for all other RDF terms.

Parameters

value_type: Type of the RDF term.
vname_prefix: Prefix value of the RDF term.
vname_suffix: Suffix value of the RDF term.
literal_type: Literal type of the RDF term.
language_type: Language type of the RDF term.
long_value: CLOB value for long literals.
srid: Target coordinate system (spatial reference system) identifier for the SDO_GEOMETRY object to be returned.

Usage Notes

ogc:wktLiteral and ogc:gmlLiteral values encode spatial reference system information in the literal value itself (referred to as the source SRID).

If the srid parameter value (the target SRID) is different from the source SRID, the newly created SDO_GEOMETRY object is transformed to the target SRID before it is returned.

This operation can be expensive in terms of performance.

For information about the SDO_GEOMETRY type (including SRID values), see Oracle Spatial Developer's Guide.

Examples

The following example returns SDO_GEOMETRY values in the WGS84 (Longitude, Latitude) spatial reference system (SRID 8307) for all geometry literals in the RDF_VALUE$ table:

SELECT SEM_APIS.GETV$GEOMETRYVAL(value_type, vname_prefix, vname_suffix, 
  literal_type, language_type, long_value, 8307) 
  FROM RDF_VALUE$;