Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Line geometry

650828Feb 25 2009 — edited Feb 26 2009

Hi,

I have a table of locations (lat/long) and I want to represent them as a line string geometry.

I've found line string constructing examples that hard code the info and ordinate arrays like:

SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1,2,1), SDO_ORDINATE_ARRAY(3,2, 4,6, 6,4, 14,7) )

but my question is how do I create the geometry using the table values I have? Or to put it another way, how do I incorporate an SQL query into SDO_GEOMETRY to populate the info and ordinate arrays?

PostGIS has a function ST_MAKELINE that does exactly this, does Oracle have an equivalent function?

Any help appreciated,
Dave

Edited by: Dave Judge on Feb 25, 2009 9:09 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2009

Added on Feb 25 2009

#database-key-features, #spatial

4 comments

814 views