Category to group Oracle Server and Locator posts.
A customer presented me with an interesting problem. For some reason, a geodetic polygon object (4283) had been created within their database. (Probably an external application that supports circular arcs in geodetic polygons – SQL Server 2012 does.) The problem then was that the polygon needed to be transformed (projected) to a planar SRID. ValidatingRead More
While at my current contract employer, two functions were required to handle the conversion of DIMINFO SDO_LB/SDO_UB ranges to optimised rectangles (SDO_GEOMETRY) and the reverse. Note: GeoRaptor provides such capability for selected DIMINFO objects or to convert a map extent to its equivalent DIMINFO structure. The functions, written in PL/SQL are: ST_Diminfo2Rectangle ST_Geom2Diminfo The definitionRead 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
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
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