Spatial Solutions Architect and Database Expert
Oracle 12c must be at least 6 months away. Here is a posting by spatialPhil on what may be in 12c for spatial practitioners. The real news in this posting is: Oracle Locator ‘beefed’ up The entire SDO_GEOM package will now be available in Locator (rather than previously where some of the more powerful functionsRead More
It is not uncommon to want to construct BEFORE INSERT row level triggers that detect and process changes to SDO_GEOMETRY columns and assign other column values. However, the rules that govern the comparison of objects such as numbers, dates, strings etc do not apply to complex objects such as SDO_GEOMETRY. As such, to correctly detectRead More
Over on the Oracle Technology Spatial Forum this question was asked: I want to store duplicate geometry intentionally, will it have any problems ?? Because same data comes from different sources and going to be big database system. (The article is here ) Here is my answer repackaged for this blog. The questioner’s question canRead More
I wrote an article on Gridding a PostGIS Geometry object a while back. I had cause, recently, to use a variation on this for the generation of an array of point objects for a geometry polygon, so I wrote a version that also allows for the generation of a grid of polygons or points dependingRead More
My CENTROID package has been downloaded thousands of times and, except from some initial problems appears to have performed flawlessly. Until now! The thing about spatial data is that, once you think you understand its intricacies it bites you for being so stupid! A user contacted me to let me know some use cases thatRead More