Spatial Functions

Page edited by Steven Hawkins


Changes (2)

Spatial functions provide functionality for working with [geospatial|http://www.opengeospatial.org/] data.

h1. Conversion Functions

h2. ST_GeomFromText

Returns a geometry from a Clob in WKT format.

{code:SQL}ST_GeomFromText(text){code}

text is a clob. Return value is xml.

h2. ST_GeomFromBinary
h2. ST_AsText
h2. ST_AsBinary

h1. Relationship Functions

h2. ST_CONTAINS
h2. ST_CROSSES
h2. ST_DISJOINT
h2. ST_DISTANCE
h2. ST_INTERSECTS
h2. ST_OVERLAPS
h2. ST_TOUCHES

Full Content

Spatial functions provide functionality for working with geospatial data.

Conversion Functions

ST_GeomFromText

Returns a geometry from a Clob in WKT format.

ST_GeomFromText(text)

text is a clob. Return value is xml.

ST_GeomFromBinary

ST_AsText

ST_AsBinary

Relationship Functions

ST_CONTAINS

ST_CROSSES

ST_DISJOINT

ST_DISTANCE

ST_INTERSECTS

ST_OVERLAPS

ST_TOUCHES

Stop watching space | Change email notification preferences
View Online | View Changes | Add Comment