Compliance with spatial standards

SQL Anywhere spatial complies with the following standards:

  • International Organization for Standardization (ISO)   SQL Anywhere geometries conform to the ISO standards for defining spatial user-types, routines, schemas, and for processing spatial data. SQL Anywhere conforms to the specific recommendations made by the International Standard ISO/IEC 13249-3:2006. See [external link] http://www.iso.org/iso/catalogue_detail.htm?csnumber=38651.

  • Open Geospatial Consortium (OGC) Geometry Model   SQL Anywhere geometries conform to the OGC OpenGIS Implementation Specification for Geographic information - Simple feature access - Part 2: SQL option version 1.2.0 (OGC 06-104r3). See [external link] http://www.opengeospatial.org/standards/sfs.

    SQL Anywhere uses the standards recommended by the OGC to ensure that spatial information can be shared between different vendors and applications.

    To ensure compatibility with SQL Anywhere spatial geometries, it is recommended that you adhere to the standards specified by the OGC.

  • SQL Multimedia (SQL/MM)   SQL Anywhere follows the SQL/MM standard, and uses the prefix ST_ for all method and function names.

    SQL/MM is an international standard that defines how to store, retrieve, and process spatial data using SQL. Spatial data type hierarchies such as ST_Geometry are one of the methods used to retrieve spatial data. The ST_Geometry hierarchy includes a number of subtypes such as ST_Point, ST_Curve, and ST_Polygon. With the SQL/MM standard, every spatial value included in a query must be defined in the same spatial reference system.