O'Reilly logo

Applying and Extending Oracle Spatial by Siva Ravada, Simon Gerard Greener

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix A. Table Comparing Simple Feature Access/SQL and SQL/MM–Spatial

This appendix provides a comparison of SFA-SQL 1.2 (http://portal.opengeospatial.org/files/?artifact_id=25354) and SQL/MM-Spatial (ISO 13249-3, Information technology - Database languages - SQL Multimedia and Application Packages - Part 3: Spatial) by reproducing Table B 1 from Annex B of SFA-SQL 1.2 Part 2:

 

SQL with geometry type

ISO/IEC 13249-3:2003 (SQL/MM-Spatial)

Description

Geometry types

Point

ST_Point

The type ST_PolyhedralSurface is currently not in SQL/MM, but will be proposed as a result of this document

 

Curve

ST_Curve

 
 

Linestring

ST_LinestringST_Circularstring ST_CompoundCurve

 
 

Surface

ST_Surface ST_CurvePolygon

 
 

Polygon

ST_Polygon ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required