Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Spatial Data Support » Using spatial data » Introduction to spatial data » SQL Anywhere support for spatial data


Supported spatial data types and their hierarchy

SQL Anywhere follows the SQL Multimedia (SQL/MM) standard for storing and accessing geospatial data. A key component of this standard is the use of the ST_Geometry type hierarchy to define how geospatial data is created. Within the hierarchy, the prefix ST is used for all data types (also referred to as classes or types).

When a column is identified as a specific type, the values of the type and its subtypes can be stored in the column. For example, a column identified as ST_GeomCollection can also store the ST_MultiPoint, ST_MultiSurface, ST_MultiCurve, ST_MultiPolygon, and ST_MultiLineString values.

The following diagram illustrates the hierarchy of the ST_Geometry data types and their subtypes:

Diagram of all supported spatial types in hierarchical form

The types on the left are supertypes (or base types) for the subtypes (or derived types) on the right.

 Descriptions of supported spatial data types
 Object-oriented properties of spatial data types
 See also

Supported spatial predicates