An overview of SQL functions used with ST_Geometry types |
|
Release 9.3 |
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.
For the IBM Functional References for ST_Geometry, see chapter 8, "SQL Functions," of the IBM Informix Spatial DataBlade Module User's Guide and chapters 22, "Spatial functions: Categories and uses," and 23, "Spatial functions: Syntax and parameters," in the IBM DB2 Spatial Extender and Geodetic Extender User's Guide and Reference.NOTE: The 0 SRID is present in ArcSDE geodatabases in Oracle beginning with ArcGIS 9.3.
If you decide to use a different SRID value already present in your database to do these samples, you must change the examples' coordinates to reflect the spatial reference of your SRID value. If you want to add a spatial reference to the ST_SPATIAL_REFERENCES or sde_spatial_references table using SQL, see Creating spatial references using SQL.