Spatial Solutions Architect and Database Expert
Andy Versal is a reader of this website. He recently modified my SDO2GEOJSON function. Andy supplied me with the fixes which now appear in the original article describing that function. In return he has provided me with a copy of his function that converts GeoJSON to Sdo_Geometry. Thanks to Andy Versal for this function.
UPDATE: This function is now a part of the Oracle Object implementation. The Travelling Salesman is a well known problem in graph theory: The Travelling Salesman Problem describes a salesman who must travel between N cities. The order in which he does so is something he does not care about, as long as he visitsRead More
UPDATE The original functions have been modified and deployed via my Oracle Object code. They original code is no longer available. My COordinate GeOmetry (COGO) package has been around for a long time. What I had not done was use the power of this package to construct polygons (2003) or linestrings (2002) from a startingRead More
This article describes a function that can be used to returns a compass point From a whole circle bearing (0-360)
The CENTROID package that I make available for free exposes a function for generating centroids of polygon (or area) objects. Here is the function: If you call the function with its defaults, the p_method parameter will be 1. For this value, the code determines the X ordinate extent of the polygon’s MBR, and selects theRead More
It is amazing what one finds inside an Oracle database! When writing pl/sql code I often have need to print out formatted strings. I have often wanted Oracle to have an equivalent to the C sprintf or Java format functions. Well, just the other day I discovered: See Format Message You will note from theRead More
A reader asked me for some help constructing and querying oriented points a few months back. The functions I created for him were one to create an oriented point from an normal point and a supplied whole circle bearing (0-360 degrees); the other was one that, given an oriented point, computed what they orientation angleRead More
In Developing Some Ideas For The Compression/Decompression Of Sdo_Geometry Objects, I Had Cause To Create Two PL/SQL Functions called Geocompress and Geodecompress. I Have Not Done This For A While And Slapped Myself When I Ran Into something I Should Have Known Would Arise, as I have seen it before, and because it is documentedRead More
At the business I am currently contracted to to provide database modeling, data quality analysis, PLSQL development and spatial expertise, an application was having problems querying a WFS server (MapGuide, using FDO to access an Oracle 11gR2 database) with a WFS filter using a very large polygon. (All the issues seem to be with gettingRead More
——————————————————————————————- NOTICE (2020): All packages have been moved to my new SPDBA website ——————————————————————————————- ——————————————————————————————- UPDATE (21 Mar 2018): ——————————————————————————————- I have just released a new version of my GEOM etc PLSQL Package objects. The changes include a re-write of the AFFINE package. Conditional compilation has been removed which means any XE installations have nowRead More