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.

Update to PL/SQL Packages

Thursday February 15 2007 at 03:09

Today I uploaded some changes to my Oracle Spatial and Locator PL/SQL packages and types source code which is available as a free download from this site.

The changes include:

  • A new TO_KML() function in the GEOM package (I thought of calling it GEOMETRY2KML or TO_KMLGEOMETRY but decided against it).

This allows for the conversion of any geodetic sdo_geometry object to be converted into KML via GML. It does so not via XSLT but rather by hacking the GML produced by the SDO_UTIL.TO_GMLGEOMETRY() function. It is not meant to be a complete or totally flexible method for converting sdo_geometry to KML but to give an indication of what is possible. This function could be used in a trigger with the UTL_SMTP package to email a KML description of a geometry to someone with Google Earth as a quick visualisation/check of a geometry. Or it could be used inside an Application Express form or report for downloading or visualisating a batch of sdo_geometries.

  • Some additional test data has been constructed;
  • Some minor improvements in TOOLS.GeometryCheck;
  • Changes to some of the test functions.


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