This discussion is archived
1 Reply Latest reply: Nov 9, 2012 3:28 PM by Simon Greener RSS

Create point geometry off Line string

user12035460 Newbie
Currently Being Moderated

I am new in using the oracle spatial functions. I need some help in trying to generate point geomteries off a line string.
E.g. I have a line string say is a mile long; I need to dynseg this line string at regular intervals say 1/100th of a mile (52 feet accuracy) and extract the point geometries.
Basically for a mile long line string, I need 10 point geomteries at equal distances (.01 mile apart). How can I achieve this? Do we have any geomtery functions that does this dyn seg?
Any help is appreciated.

This is an e.g of a line string in my table.
Route: SFRAIR00270**C
Begin_log:     15.21
End-log:     15.42
SD_GEOM: 2002, 41104, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(NUMBER(1, 2, 1)), MDSYS.SDO_ORDINATE_ARRAY(NUMBER(545906.05083, 229998.885452, 545888.2, 230082.23, 545838.54, 230335.43))


Edited by: user12035460 on Nov 9, 2012 12:35 PM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points