Category "oracle-spatial"

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