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

Chapter 11. SQL/MM – A Basis for Cross-platform, Inter-operable, and Reusable SQL

While Oracle's SDO_GEOMETRY type is very widely used, even by the open source community, which promotes the virtues of standards conformance and compliance, many in the geospatial industry still criticize Oracle's SDO_GEOMETRY for its lack of perceived standards compliance. Whether this criticism is based on ignorance or maleficence, SDO_GEOMETRY is standards compliant in its storage, geometry description, and with some functions, but its API is not fully compliant.

However, SDO_GEOMETRY is not the whole story. Oracle also provides an ST_GEOMETRY object type, which is an implementation that is based on the ISO 13249-3, Information Technology – Database Language Spatial ...

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