Spatial Functions

Page edited by Steven Hawkins


Changes (4)

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

text is a clob. Return value is a geometry.

h2. ST_GeomFromWKB/ST_GeomFromBinary
...
{code:SQL}ST_GeomFromWKB(bin){code}

bin is a blob. Return value is a geometry.

h2. ST_AsText
...
{code:SQL}ST_GeomAsBinary(geom){code}

geom is a geometry. Return value is a blob.

h1. Relationship Functions
...

h2. ST_SRID

Returns the SRID for the geometry.

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

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.

h2. ST_SetSRID

Set the SRID for the given geometry.

{code:SQL}ST_SetSRID(geom, srid){code}

geom is a geometry. srid is an integer. Return value is a geometry. Only the SRID metadata of the geometry is modified.

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

ST_GeomFromWKB/ST_GeomFromBinary

Returns a geometry from a blob in WKB format.

ST_GeomFromWKB(bin)

bin is a blob. Return value is a 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 a blob.

Relationship Functions

ST_CONTAINS

ST_CROSSES

ST_DISJOINT

ST_DISTANCE

ST_INTERSECTS

ST_OVERLAPS

ST_TOUCHES

Misc. Functions

ST_SRID

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.

ST_SetSRID

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.

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