Spatial Functions

Page edited by Steven Hawkins


Changes (6)

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

text is a clob. Return value is xml. geometry.

h2. ST_GeomFromWKB/ST_GeomFromBinary

Returns a geometry from a blob in WKB format.

{code:SQL}ST_GeomFromWKB(bin){code}

bin is a blob. Return value is geometry.

h2. ST_AsText

{code:SQL}ST_GeomAsText(geom){code}

geom is a geometry. Return value is clob.

h2. ST_AsBinary

{code:SQL}ST_GeomAsBinary(geom){code}

geom is a geometry. Return value is blob.

h1. Relationship Functions

...

h2. ST_TOUCHES

h1. Misc. Functions

h2. ST_SRID

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 geometry.

ST_GeomFromWKB/ST_GeomFromBinary

Returns a geometry from a blob in WKB format.

ST_GeomFromWKB(bin)

bin is a blob. Return value is geometry.

ST_AsText

ST_GeomAsText(geom)

geom is a geometry. Return value is clob.

ST_AsBinary

ST_GeomAsBinary(geom)

geom is a geometry. Return value is blob.

Relationship Functions

ST_CONTAINS

ST_CROSSES

ST_DISJOINT

ST_DISTANCE

ST_INTERSECTS

ST_OVERLAPS

ST_TOUCHES

Misc. Functions

ST_SRID

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