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

SQL Anywhere 12.0.1 » UltraLite - Database Management and Reference » UltraLite database tasks and features » UltraLite support for spatial data


Compliance with spatial standards

UltraLite spatial support complies with the following standards:

  • International Organization for Standardization (ISO)   UltraLite geometries conform to the ISO standards for defining spatial user-types, routines, schemas, and for processing spatial data. UltraLite conforms to the specific recommendations made by the International Standard ISO/IEC 13249-3:2006. See [external link]

  • Open Geospatial Consortium (OGC) Geometry Model   UltraLite 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]

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

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

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

    SQL/MM is an international standard that defines how to store, retrieve, and process spatial data using SQL. Spatial type hierarchies such as ST_Geometry are one of the functions 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.