NETWORK
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.
Month: July 2020
TOOLS
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
KML
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
COGO
The CoOrdinate GeOmetry package contains a bunch of functions related to handling curves, circles, bearings and distances.
GEOM
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
LINEAR (LRS)
UPDATED: This package of functions underwent a revamp in early July 2012. In that revamp: ST_Locate_Point was overhauled to correctly handle both distance based segmentation of 2D lines as well as Measured geometries (p_value_Type parameter now fully handled). ST prefixes added to public functions._ T_Vector Type enhanced ST_GetVector renamed to ST_Vectorize Bugs fixed in ST_SplitRead More
SDO_ERROR
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
CENTROID
Required Types Package Header. This package can be downloaded via the download page.
Building Lines into Polygons in Oracle Locator / Spatial
The Spatial Companion For Oracle (SC4O) package uses the JTS Topology Suite’s (JTS) geoprocessing/overlay functions to implement free union, intersection, difference and XOR functions for Oracle Locator. SC4O also includes a function called: This function is a wrapper over the JTS’s Polygonizer() class. In essence, this function takes a collection of linestrings/multilinestrings and tries toRead More
Free Union, Intersection, Xor and Difference Functions for Oracle Locator – Part 1
Both the OGC and SQL3/MM Spatial standards for Simple Features include four standard geoprocessing operations as part of the basic type. Here is an extract from the OpenGIS’s Simple Features Specification for SQL, Revision1.1: 2.1.1.3 Methods that support Spatial Analysis … Intersection(anotherGeometry:Geometry):Geometry – Returns a geometry that represents the point set intersection of this GeometryRead More