We are working in Oracle Database 11g. There is a table with sdo_geomerty column(representing a line) which contains the following :

RSID,       LT,      LF,      GEOM
584908,     30,      34,      [MDSYS.SDO_GEOMETRY] 
1312994,     1,      9,       [MDSYS.SDO_GEOMETRY]

In the column of geom is the MDSYS.SDO_ORDINATE_ARRAY there are more than 2 points with known coordinates, so we can say that is a curve too.
For the 2 records above, we want to compute the coordinates for the points placing at the even and odd intervals correspondingly.

To be clear, for the first record we want the point coordinates in 30,32,34.
For the second record we want the point coordinates in 1,3,5,7,9.
The start and end of each line is known as we can extract the first and last pair of coordinates from geometry column.
I am looking for a program logic (I am working on these languages C#, Python, pL SQL) that combines the Pythagorean theorem and the relations between Polar and Rectangular Coordinates to find the coordinates at even intervals when the edges of the line are even and odd numbers correspondingly.
These numbers are street road numbers and the lines depict the road network.

Visit http://math.ucsd.edu/~wgarner/math4c/textbook/chapter9/polar_coordinates.htm

I have good knowledge on plsql.

1 Answer 1


If I understand correctly, it looks like you need something similar to dynamic segmentation. I have written a small series of posts on this a while back. Have a look at Part 2 and Part 3 to see if they help.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.