| ... |
| Returns a geometry from a Clob in WKT format. |
| {code:SQL}ST_GeomFromText(text){code} |
| {code:SQL}ST_GeomFromText(text [, srid]){code} |
| |
| text is a clob. Return value is a geometry. |
| text is a clob, srid is an optional integer. Return value is a geometry. |
| h2. ST_GeomFromWKB/ST_GeomFromBinary |
| ... |
| Returns a geometry from a blob in WKB format. |
| {code:SQL}ST_GeomFromWKB(bin){code} |
| {code:SQL}ST_GeomFromWKB(bin [, srid]){code} |
| |
| bin is a blob. Return value is a geometry. |
| bin is a blob, srid is an optional integer. Return value is a geometry. |
| |
| h2. ST_GeomFromGeoJSON Returns a geometry from a Clob in GeoJSON format. {code:SQL}ST_GeomFromGeoJson(text [, srid]){code} text is a clob, srid is an optional integer. Return value is a geometry. h2. ST_GeomFromGML Returns a geometry from a Clob in GML format. {code:SQL}ST_GeomFromGML(text [, srid]){code} text is a clob, srid is an optional integer. Return value is a geometry. |
| h2. ST_AsText |
| ... |
| geom is a geometry. Return value is a blob. |
| h2. ST_AsGeoJSON {code:SQL}ST_GeomAsGeoJSON(geom){code} geom is a geometry. Return value is clob. h2. ST_AsGML {code:SQL}ST_GeomAsGML(geom){code} geom is a geometry. Return value is clob. |
| h1. Relationship Functions |
| ... |
Spatial functions provide functionality for working with geospatial data. Teiid relies on the JTS Topology Suite to provide partial support for the OpenGIS Simple Features Specification For SQL Revision 1.1. Please refer to the specification for more details about particular functions.
Returns a geometry from a Clob in WKT format.
ST_GeomFromText(text [, srid])
text is a clob, srid is an optional integer. Return value is a geometry.
Returns a geometry from a blob in WKB format.
ST_GeomFromWKB(bin [, srid])
bin is a blob, srid is an optional integer. Return value is a geometry.
Returns a geometry from a Clob in GeoJSON format.
ST_GeomFromGeoJson(text [, srid])
text is a clob, srid is an optional integer. Return value is a geometry.
Returns a geometry from a Clob in GML format.
ST_GeomFromGML(text [, srid])
text is a clob, srid is an optional integer. Return value is a geometry.
ST_GeomAsText(geom)
geom is a geometry. Return value is clob.
ST_GeomAsBinary(geom)
geom is a geometry. Return value is a blob.
ST_GeomAsGeoJSON(geom)
geom is a geometry. Return value is clob.
ST_GeomAsGML(geom)
geom is a geometry. Return value is clob.
Returns true if geom1 contains geom2 contains another.
ST_CONTAINS(geom1, geom2)
geom1, geom2 are geometries. Return value is a boolean.
Returns true if the geometries cross.
ST_CROSSES(geom1, geom2)
geom1, geom2 are geometries. Return value is a boolean.
Returns true if the geometries are disjoint.
ST_DISJOINT(geom1, geom2)
geom1, geom2 are geometries. Return value is a boolean.
Returns the distance between two geometries.
ST_DISTANCE(geom1, geom2)
geom1, geom2 are geometries. Return value is a double.
Returns true if the geometries intersect.
ST_INTERSECT(geom1, geom2)
geom1, geom2 are geometries. Return value is a boolean.
Returns true if the geometries overlap.
ST_OVERLAPS(geom1, geom2)
geom1, geom2 are geometries. Return value is a boolean.
Returns true if the geometries touch.
ST_TOUCHES(geom1, geom2)
geom1, geom2 are geometries. Return value is a boolean.
Returns the SRID for the geometry.
ST_SRID(geom)
geom is a geometry. Return value is an integer. A 0 value rather than null will be returned for an unknown SRID on a non-null geometry.
Set the SRID for the given geometry.
ST_SetSRID(geom, srid)
geom is a geometry. srid is an integer. Return value is a geometry. Only the SRID metadata of the geometry is modified.