Spatial Solutions Architect and Database Expert
Previously I wrote about a function that converted the segments of a (Multi)LineString into a COGO XML document that contains all the instructions (bearing, distances, move deltaZ etc) to create a (Multi)LineString. Today I present a function that does the reverse: takes the COGO XML and creates the (Multi)LineString. The instructions are provided to theRead More
Andy Versal is a reader of this website. He recently modified my SDO2GEOJSON function. Andy supplied me with the fixes which now appear in the original article describing that function. In return he has provided me with a copy of his function that converts GeoJSON to Sdo_Geometry. Thanks to Andy Versal for this function.
Oracle Spatial does not read or write 3D Well-known text (WKT); nor does it read/write measures. Oracle’s SDO_Geometry implementation only supports the OGC Simple Features 1.1 specification which is 2D only. What I have done is expose the Jaspa/JTS implementation of methods more 3D+ aware to PL/SQL and therefore SQL via my Spatial Companion forRead More