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!

Idea: SDO_UTIL.TO_GEOJSON() - Support LRS geometries

User_1871May 13 2022

I have a query that produces a LRS geometry (19c Live SQL):

select  
 SDO_LRS.CONVERT_TO_LRS_GEOM(sdo_geometry('LINESTRING(1 2,3 4)')) as shape
from
 dual

I want to convert that LRS to GeoJSON:

select  
 SDO_UTIL.TO_GEOJSON(SDO_LRS.CONVERT_TO_LRS_GEOM(sdo_geometry('LINESTRING(1 2,3 4)'))) as shape
from
 dual

But I get an error:

ORA-13199: LRS is not supported

Could the SDO_UTIL.TO_GEOJSON() function be enhanced so that it supports LRS geometries?
And SDO_UTIL.FROM_GEOJSON() too?

Added on May 13 2022

#database-key-features, #spatial

8 comments

589 views

1 mention