Documentation

Here’s a package with a few functions for getting the start/end point of an sdo_geometry. This package should be dropped and moved in to the LINEAR or GEOM packages. Until then, here is the header.

This package mainly contains utility programs that can do things like: Create SDO_GEOM_METADATA records from scratch; Discover SRID; Discover Dimensions in sdo_geometry column; Discover Geometry/Spatial Type (for use in spatial indexing); Discover minimum tolerance of an sdo_geometry column; Analyse vertices; Run a battery of sdo_geometry tests to check sdo_geometry data integrity (including fixing); This canRead More

I have a package that will allow you to convert a single geometry into KML or create a whole KML document from a recordset containing many geometries. It doesn’t do a whole lot, but it has been of interest to some users out there who have improved the original work. Here is an example ofRead More

The CoOrdinate GeOmetry package contains a bunch of functions related to handling curves, circles, bearings and distances.

The GEOM package contains a generic collection of algorithms that work on SDO_GEOMETRY objects. This package needs many TYPES to exist and also depends on other packages such as GF, CONSTANTS etc. If you are interested in this package it is best to download the complete collection of packages and have a good look atRead More

I have written a PL/SQL package called SDO_ERROR that could be used to visualise geometry errors (specifically validate_geometry_with_context) and elements Additionally it focuses mainly on projected (not long/lat) data, so if you use with geodetic data do so at your own risk. Required Data Types Packaged Header The source code, which is still under activeRead More

Required Types Package Header. This package can be downloaded via the download page.