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

Moving/shifting lines parallel to the original object

A common requirement for spatial data processing is to move a linear object parallel to itself. Examples include the desire to create a linestring that is parallel to the boundary of a land parcel, as is the case with rights of carriageway, often defined as being 10ft from an existing boundary. Similarly, one often hears of the need to create a line parallel to an existing road centerline; perhaps to define the boundaries of the road reserve or to present linear data graphically adjacent to the existing data.

Shifting a line sideways – ST_LineShift

A common and simple solution for moving a line parallel to itself is to extract the first and last vertex in a linestring, compute a single offset ...

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