Spatial Solutions Architect and Database Expert
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
As a part of my last article on tracking down and correcting ORA-13011 errors when using SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT() , I showed how to update the diminfo structure associated with a table’s geometry column in its USER_SDO_GEOM_METADATA entry. Here was the code in that article. Now, that code is pretty neat, but it has in it aRead More
I was sent a request for help the other day from some I know overseas: Do you know the true meaning and impact of ‘ORA-13011 value is out of range’? I have a dataset with a lot of very (almost impossible) precise data coming from Bentley microstation. And we have a ‘businessrule’ that the defaultRead More
I gave a talk last year entitled Automated Layer Management – Experiences At Mid Coast Water which was about mapping the area that would be affected by a mains pipe bursting in either a sewer or water network. (Yes it was a not very exciting title.) The mapping was all done in 2D as OracleRead More