Go to content Go to navigation and search


Free Software Download

Download Code, Packages and Installers

Object Documentation

Package Documentation

Spatial Companion For Oracle (SC4O)


    New versions of LINEAR, CENTROID and GEOM etc packages
    TESSELATE and CENTROID package updates
    Applying and Extending Oracle Spatial: Source Code Problem
    CENTROID package use with ESRI's sde.st_geometry
    Changes to CENTROID and TESSELATE packages
    CENTROID Package now returns centroid of multi-linestring
    New versions of PL/SQL packages uploaded
    New Release of Free PL/SQL Packages
    New version of PL/SQL packages released
    New Version PL/SQL Spatial packages released
    New PL/SQL Package Upload
    PL/SQL Spatial Types and Packages
    Update to PL/SQL Packages
    New PL/SQL Packages
    VB6 Oracle Spatial or Locator OO4O code
    Spatial PL/SQL Packages by Example
    Catalog Registry Tool
    Image Catalog Tool
    Oracle Spatial PL/SQL and VB6 Source Code



RSS / Atom

Email me


Creative Commons License
All Blog Articles, Data Models and Free Source Code by Simon Greener, The SpatialDB Advisor is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.

New PL/SQL Packages

Tuesday January 09 2007 at 04:48

I have just uploaded a whole bunch of changes to my PL/SQL packages for processing Oracle Spatial and Locator data.

The most important aspects of the changes are:

  1. I have introduced a new TOOLS package that includes a Metadata Analysis capability (see MetadataAnalyser procedure). This capability can examine the spatial data held in a table/column and create from scratch or update/validate an existing SDO_GEOM_METADATA record. This includes discovery of sdo_tolerance, SRID and data extents (3D data is supported).
  2. The old independent ShapeCheck routine is now integrated into the TOOLS package but is now called GeometryCheck.
  3. A new Vertex Analysis function is included in the TOOLS package that will help a GIS Administrator keep track of the complexity of data over time.

All these functions write output into a new set of metadata tables that are created in the schema where the PL/SQL packages are stored (normally CODESYS).

Finally, I have constructed a set of test/example spatial tables that can be used for testing your PL/SQL functions. The test_*.sql code uses this data when testing the installation of the packages.

I hope you find these packages useful. If you do, or don’t, please let me know.

January 2007

Creative Commons License

post this at del.icio.uspost this at Diggpost this at Technoratipost this at Redditpost this at Farkpost this at Yahoo! my webpost this at Windows Livepost this at Google Bookmarkspost this to Twitter