Here as some test on data other than just polygons. Union of two points These are two representations of the same thing. Now if we replace SDO_GEOM.RELATE with SC4O.ST_RELATE we do not get equals. The reason for this is that the SDO_Geometry to JTS Geometry converter supplied by GeoTools does not handle the sdo_elem_info_array –Read More
In this blog we will execute the four overlay types on two simple rectangular polygons. In addition, I have not tested “real world” polygon data using multiple projections. I am just showing what is possible. Here is the SQL that I use to create two test polygon geometries. Here are what they look like. HereRead More
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
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
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.