Straws in the Wind Blog Articles
• Silence is Golden?
• National Broadband Network, Spatial Data & Processing
• Industry Best Practice?
• Spatial Database Independence
• 2011 Oracle Spatial Excellence Award for Education and Research
• Tiling Very Large Rasters
• Cloud Computing GIS and Standards (OGC/ISO)
• Usefulness of Spatial Metadata as a Foundation for an Australian data.gov and other uses
• Vale Professor Pieter Roelof Zwart 1941-2010
• Interview by Nestoria on Real Estate Mapping
• Mapping surface area of a ruptured pipe in Oracle Spatial
• FOSS4G 2009 Sydney Presentation
• GIS software and Database Primary Keys
• To Constrain or Not to Constrain: There should be NO Question
• The Shapefile 2.0 Manifesto
• Maps of War Website
• Talk on Open GeoData in Australia
• Boarder and District Spatial Information Group Presentation on Spatial Datbases
• Presentations given by myself at the Australian Oracle Spatial Forum, Sydney, Thursday 28th August 2008
• The Sad State of SQL Spatial Standards - Take 2
• Radius Studio and ESRI (Part 2)
• The Sad State of GIS SQL Standards
• Microsoft to release their own spatial capability for SQL Server
• Radius Studio and FDO
• SpatialWare 4.9 Released
• First Radius Studio Certified Practitioner
• Image Catalog Tool - How To Videos
• Latest article published on Directions Magazine
• Image Catalog / GeoRaster Management Tools
• ESRI Ireland - Many Thanks
• PL/SQL Packages for Oracle Sdo_Geometry
• Professor Hanan Samet
• ADF and Spatial
• Bouquets and Brickbats
• Geomatics Degrees, Space Curves and Oracle Spatial
• Non-Persistent Types
• Feature Data Objects - Either/Or?
• A Thank You
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.