An overview of SQL functions used with ST_Geometry types
Last modified July 10, 2009
Print all topics in : "SQL functions reference"
This topic was updated for 9.3.1.
Structured Query Language (SQL) is a standardized language used to select and manipulate data stored in a database management system (DBMS).
This book contains topics for each of the functions implemented with the ST_Geometry spatial type in an ArcSDE geodatabase in Oracle or PostgreSQL. These functions are stored in the schema of the sde user and provide operations that work on and return information about geometries.
The function topics are structured as follows:
NOTE: The samples in this section do not build spatial indexes on the tables created. If you want to create a spatial index, see Creating spatial indexes on tables with an ST_Geometry column for instructions.
NOTE: The 0 SRID is present in ArcSDE geodatabases in Oracle beginning with ArcGIS 9.3.
|ST_Aggr_ConvexHull (Oracle only)|
|ST_Aggr_Intersection (Oracle only)|
|ST_Aggr_Union (Oracle only)|
|ST_Curve (Oracle only)|
|ST_Entity (Oracle only)|
|ST_EnvIntersects (Oracle only)|
|ST_Equalsrs (PostgreSQL only)|
|ST_GeomCollFromShape (PostgreSQL only)|
|ST_GeomCollFromWKB (PostgreSQL only)|
|ST_GeomFromShape (PostgreSQL only)|
|ST_GeomFromText (Oracle only)|
|ST_GeoSize (PostgreSQL only)|
|ST_Is3d (Oracle only)|
|ST_IsMeasured (Oracle only)|
|ST_LineFromShape (PostgreSQL only)|
|ST_LineFromText (Oracle only)|
|ST_MLineFromShape (PostgreSQL only)|
|ST_MLineFromText (Oracle only)|
|ST_MPointFromShape (PostgreSQL only)|
|ST_MpointFromText (Oracle only)|
|ST_MpolyFromText (Oracle only)|
|ST_MultiCurve (Oracle only)|
|ST_MultiSurface (Oracle only)|
|ST_PointFromShape (PostgreSQL only)|
|ST_PointFromText (Oracle only)|
|ST_PolyFromShape (PostgreSQL only)|
|ST_PolyFromText (Oracle only)|
|ST_Surface (Oracle only)|
|ST_Transform (Oracle only)|