Spatial Solutions Architect and Database Expert
Source Code The source code for the T_GEOMETRY object which was released with my book “Applying and Extending Oracle Spatial” (co-authored with Dr Siva Ravada) is incorrect. The zip file code for chapters 6,7,8, 10 and 11 is draft code from an earlier stage of the book’s production. The final code (which include the vitallyRead More
In my book (co-authored with Dr Siva Ravada) I provide those who purchase it with a number of Oracle Objects that are a re-write of a lot of the packages I have made available on this website over the years. Those object types include new material besides the re-writes and bug fixes. The object typesRead More
Folks, On Sunday 30th September 2013 a book I designed and then co-wrote with Dr Siva Ravada (Director Development, Oracle Spatial) was released by PACKT publishing. The book is called Applying and Extending Oracle Spatial. The book is also available at Amazon A lot of the ideas I have expressed on this website over theRead More
I found this article very useful, I hope you do too. The Google Maps / Bing Maps Spherical Mercator Projection
Someone contacted me about having to change all the tolerances in their user_sdo_geom_metadata due to a need to change each sdo_tolerance value from 0.005 (1cm) to 0.0005 (1mm) meters. I hope this helps someone out there…
The ST_PolygonBuilder function in the Spatial Companion for Oracle (SC4O) package provides a mechanism via which linestring can be compiled into polygons. I have given some simple examples in a post I made a few years ago. I will now give a much more complex example that I wrote in response to a request onRead More
I was asked the other day if I could help derive the direction from a selected land parcel to its neighbouring parcels (request slightly modified): Below is a screenshot showing an example of what I mean. I need to get the directions of parcel no (12) , it should give me (15) as north, (14)Read More
Someone downloaded my Spatial Companion for Oracle (SC4O) package the other day, then asked asked the following question(s): I have to calculate the intersection between two regions on a map. Each region is represented in the db as a >column in different tables. For now I have two columns of polygons one with 1500 entriesRead More
UPDATE The book has been published If any of my readers are wondering why I have been so quiet of late, here are the reasons. GeoRaptor Firstly I have been working on a new GeoRaptor release. That release was made a few weeks ago (12th February 2013). A lot of time and effort went intoRead More
A question from a user: It seems as though the system calculates extents that are HUGELY larger than the actual geometry. I have found by putting a label on it that you sill see a tiny blob then using the windowed zoom I can then start showing the links and eventual remove the label. Idea’sRead More