——————————————————————————————- 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
Today (25th February 2015) I uploaded the following changes to the following packages: 1. TESSELATE Reduce complexity of package interface. Removed all Quad_Tree Initialise procedures (Quad_Tree functions internally initialise). All SPACE_KEY functions removed: package now only supports morton key generation. Added new ST_TileGeometry functions that provide greater options for tiling (or generating a regular gridRead More
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
I have been emailed by someone who is using ESRI’s sde.st_geometry in preference to Oracle’s SDO_GEOMETRY or ST_GEOMETRY for their spatial data storage in Oracle, wanting a version of my CENTROID pl/sql package that would allow for its use with ESRI’s spatial data type. This is what I was asked: First off love your blog,Read More
Changes to the CENTROID and TESSELATE packages, as well as a modification of the Windows install.cmd tool (improved error handling) and the method used to test for an XE database required a new upload of the two affected zip files holding the relevant packages and tools.
My original CENTROID package’s sdo_centroid() functions, when supplied with a multilinestring sdo_geometry, would “explode” the multilinestring into its component linestrings and calculate the centroid (mid-point) of the largest linestring. Some users have asked for the centroid package to return the centroid (midpoint) of the whole multilinestring. While the LINEAR package can do this, I haveRead More
It has been a while (GeoRaptor took all my free/spare time) but I have uploaded a new version of the existing free PL/SQL packages to my website. The changes include: Slow migration away from old Types eg VectorSetType to new types T_Vectors that are shared with other packages not in this zip file (GEOPROCESS, LINEAR,Read More
I have just uploaded a radically revised and improved VB6 code for accessing Oracle Spatial or Locator. In revising the code I came to appreciated something the Catholic priest who married my wife and I once said to me: “True scholarship requires leisure”. I have had the lesiure to revise the code and am horrifiedRead More
The following is an introduction to the PL/SQL packages downloadable from this site. The following is an example of how the GF ( G eometry F actory) package was used to implement the rounding of the vertices of an Sdo_Geometry object to the tolerances specified in the DIMINFO structure of a USER_SDO_GEOM_METADATA entry. New users of OracleRead More