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 gave a rather manic presentation (Open Source, Oracle and PostGIS) at the FOSS4G 2009 Conference at Darling Harbour in Sydney, Australia, on Thursday October 22nd. The presentation was a little risqué a times (anyone offended please accept my apologies: I seem to become a different person when I present) and, I suspect, its message was somewhat hidden by the volume of slides and the speed of presentation.
This short note is an attempt to clarify what I was trying to do.
Oracle Spatial and PostgreSQL’s PostGIS are two of the most mature implementations of a spatial type system for their relevant host databases. One is open source, the other proprietary. Yet open source software supports both products with some open source products finding aspects of Oracle’s implementation of standards problematic.
PostGIS’s function set for its basic spatial type is far more extensive than Oracle’s. As each release is made, PostgreSQL/PostGIS increases in strength with EnterpriseDB aiming to do the impossible, which is to hide the differences between Oracle and PostgreSQL in order to convert businesses from Oracle to PostgreSQL.
In my working career I have rarely seen, on a customer’s servers, only ONE DB product. The geospatial professional thus has to learn to work with all databases that support a spatial type: you can’t demand the removal of one or other of the databases! You have to learn to work with both.
In order to improve open source software support for Oracle, and to help the geospatial professional manage both databases at the one site, the talk I gave tried to provide:
Once these were described I hoped that the audience would be aware of the issues when migrating between the databases. It was also intended to show how to minimise the amount of code that would need to be rewritten when deploying a custom function on both databases.
The talk was not meant to be a promotion of Oracle. Rather it was meant to foster improved access by open source software (eg ogr2ogr) and to help when called upon to manage both Oracle Spatial and PostGIS installations.