Go to content Go to navigation and search


Straws in the Wind Blog Articles



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.

PL/SQL Packages for Oracle Sdo_Geometry

Saturday July 29 2006 at 09:35

I have spent quite a bit of time at night over the past few weeks re-writing the fundamental Sdo_Geometry access PL/SQL package so that it draws from the experiences gained when I wrote a read-only access Class in VB6 that used Oracle Objects For OLE (OO4O).

I converted the basic “Factory” components of the VB6 access Class to PL/SQL and got it to work. I have re-written all my old utility classes (an extensive MBR class, an GEOM utility class containing Sdo_Geometry extraction, rotation, densification, para-centroid, vectorisation components) such that they use the new GF (Geometry Factory) package. I am very pleased with the results.

Before I release the code on this site (I am thinking about using Wiki technology to do this), I am working on adding some Sdo_Geometry creation methods to the GF class. I am also finalising the implementation of augmented WKT methods based on AutoDesk’s Feature Data Objects ADF. (OGC WKT does not support 3D and 4D coordinated Sdo_Geometries.)

I hope to release this code by hosting it on this site sometime next week. If you want a copy and it is not hosted on this site soon, email me by clicking on the Contact link on this site.

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