Spatial Solutions Architect and Database Expert
A version of my Scale function for SQL Server Spatial and Oracle Spatial is available for MySQL. Function Declaration Function Testing If you think this is of use to you, make a donation and I will release the code to you along with any other MySQL functions I have created.
A version of my Rotate function for SQL Server Spatial and Oracle Spatial is available for MySQL. Function Declaration Function Testing If you think this is of use to you, make a donation and I will release the code to you along with any other MySQL functions I have created.
A version of my Move functions for SQL Server Spatial and Oracle Spatial is available. Function Declaration Function Testing If you think this is of use to you, make a donation and I will release the code to you along with any other MySQL functions I have created.
This article shows how to use range querying against cumulative length to filter/select LineString segments
We all make mistakes. I made a good one this month. I had to modify (DDL) a very, very large table to change the size of existing columns. I didn’t think that this would cause me any problems, and so I didn’t drop any indexes. Was I ever wrong! Checking why it was taking soRead More
Oracle allows single part and multipart geometry objects to existing in a single SDO_GEOMETRY column. For example, a polygon and a multipolygon. This is because the SDO_GEOMETRY object type is singly inherited. (This also means that a single column can also hold geometries from different geometry types eg points, lines and polygons: common in CADRead More
Here is a function that takes a any polygon whose elements are defined by an optimized rectangle and converts all elements to 5 vertex polygons. Polygon may be multi; may have non-optimized rectangle components. Does NOT process geometries with compound elements. Now let’s test the function: Results are as follows: DESCRIPTION VALIDORIGINALGEOM VGEOM POLY SingleRead More
The populate CENTROID package has been modified. It now allows the caller of the CENTROID_A function to invoke Y ordinate seeding. This is what it looks like. I hope this enhancement is of use to someone.
I demonstrated in this article the usefulness of having a vectorising function in one’s spatial database kitbag (there are Vectorize functions in my CENTROID and GEOM packages – in particular the Vectorize function is vital to the implementation of the algorithm in my CENTROID.ST_CENTROID function). So, I have also added one to my SQL ServerRead More
The following training courses have been developed and are available for on-site training using customer data: SQL Server Spatial Basic SQL Server Spatial Intermediate Oracle Locator and Spatial Oracle Location and Spatial Intermediate The courses can be delivered through GIS College or by contacting me directly. Courses for PostGIS and MySQL are being developed andRead More