In my article on the creation and use of a space keys for the spatial sorting of spatial data, I show how to implement a Morton key for PostgreSQL/PostGIS pl/pgSQL. The function is as follows: Now, let’s test it with some simple SQL: Results I hope this is of use to someone.
Disclaimer What follows is a personal opinion based on experience. While many statements appear critical of the people who create and administer spatial metadata in Australia and overseas that is not my intention: we all do what we can do given time, staff constraints and education and training background. Some assertions may appear to beRead More
I gave a presentation on some work I did last year for a customer on providing a sophisticated spatial/textual search capability against over 700 tables of spatial data stored in SQL Server 2008 Spatial. The searching combined Spatial and Free Text index based searching. The basic idea is that the main thing in static spatialRead More
Recently I was contacted about the fact that my free PL/SQL packages could not compile on 11gR2 due to changes in the MDSYS.VERTEX_TYPE structure. This structure has given me lots of grief over the years. At 9i the structure only had four elements: X, Y, Z and W. But at 10g, the ID element wasRead More
I was asked if I would enhance my pl/sql Rotate function so that it handles oriented points. (Note: Oracle’s sdo_util.getVertices() does not support the oriented point.) After a bit of coding and modification of GeoRaptor so that I can visualise the result, I have finally finished the code and uploading it to my website. TheRead More
One of the fathers of the Australian Spatial Industry, Professor Pieter Roelof Zwart (University of Tasmania), lost his battle with cancer on 3rd April 2010. He was 68 years of age. A burial service was held in Hobart on Friday 9th April 2010 at 3pm and was very well attended. Here is the order ofRead More
The following series of blog articles by Rob van Wijk are an excellent resource and should be read by those reading this article. Sven commented on my article about Materialized Views containing SDO_GEOMETRY data. He still had some issues so he pointed me to a posting he had made on the Oracle Spatial OTN forum.Read More
This month, January 2009, I was interviewed by Kat Mackintosh, an Australian working for Nestoria in London. Nestoria are currently in the process of expanding their real estate portal into Australia. The interview was mainly concerned with my involvement in a real estate web mapping system in 1997. It also covered my involvement with theRead More
I received a comment the other day from a user of my PL/SQL packages about how he had extracted the GEOM.isCompound() function from the GEOM package, and re-written it in pure PL/SQL getting rid of the SQL pivot that that I use. That’s the sort of behaviour I encourage. The user’s comment was this: ThisRead More
There is a Lambert Conformal Conic projection used by Computer Aided Dispatch (CAD) in Victoria, Australia that is called BEST VicGrid. It is not available as part of the standard Oracle install (most Australian projections in are provided to Oracle by Michael Stoke’s Navigate company in Sydney), and so has to be created. Here isRead More