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

Buffering one side of a linestring – ST_OneSidedBuffer

Two practical uses of ST_Parallel occur which are not difficult to create. The first is the ability to use the parallel line generated on one side of a line with the original line to create a square buffer on that side. This is done by:

  • Taking the original linestring (or each linestring in a multiline string in turn) and creating a parallel line to the left or right
  • If a parallel line is generated on the left, then reverse that line (SDO_UTIL.Reverse_Linestring) to ensure the correct vertex rotation of the polygon outer ring that is generated
  • Append the reversed parallel line to the original line
  • To close the polygon ring, add the first vertex of the original line on to the appended line
  • Changing ...

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