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

Coordinate system transformation techniques

As we have seen in the first section of this chapter, it is very common to do coordinate system transformations as part of the data loading process. Many of the external data loading tools provide these transformations, but sometimes it is convenient and more efficient to do these transformations in the database. Oracle Spatial provides two distinct methods for doing coordinate system transformations. The SDO_CS.TRANSFORM function works on one row at a time to transform a geometry, while the SDO_CS.TRANSFORM_LAYER function works on a whole table of data and transforms all the geometries in a column of the table. Both methods support different use cases: the transform function is mainly used in dynamic ...

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