1 Reply Latest reply on Nov 9, 2012 11:28 PM by Simon Greener

    Create point geometry off Line string


      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