Category "oracle-spatial"

Multi-part geometries: Get line & part number when extracting parts (via SDO_UTIL.EXTRACT_ALL)

I have multi-part SDO_GEOMETRIES in Oracle 18c. I can extract the parts as individual rows using the SDO_UTIL.EXTRACT_ALL() function: with cte as ( --Each part

Custom aggregate function to collapse vertices to SDO_GEOMETRY

I have multi-part polyline vertices stored as individual rows in an Oracle 18c table. ASSET_ID PART_NUM VERTEX_NUM X Y M --------

Treat Oracle subtype as supertype

I have a query that uses Oracle's MDSYS.ST_GEOMETRY type (link): select mdsys.st_point(1, 2, 26917) from dual Output: [MDSYS.ST_POINT] The query outp