Introduction The ordinates stored in an geometry objects, across all spatial data types do not have any rounding applied to their values. This is one aspect of data management that is seldom considered by most practitioners. Other articles in this website deal with how to round their values. This article is about a related topic”Read More
In some situations Quadrilateral polygon geometries in SQL Server Spatial can affect processing results. The best example of this is the identification of CircularStrings in polygon geometries. If quadrilateral objects are not identified, they end up being incorrectly converted. This function helps identify such polygon objects.
SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions: STAddPoint STUpdatePoint STDeletePoint These functions are not a part of either the SQL or OGC standards. In fact neither provide an API for the SQL editing of geometry objects. If one wishes to do so, one must programRead More
The following article results from customers downloading the free source code (eg for Oracle SDO_GEOMETRY) on this site without fully understanding that the code is not for ESRI’s ST_GEOMETRY spatial type and then requesting changes to the source code to support that foreign type. So, to be clear, all of the source code, products andRead More
Folks, I have ported some of my spatial functions to MySQL. The best way to see what is available is to peruse the Documentation I will release short articles on how to use each one as I get time. Please let me know if you are interested in accessing these functions, or you have ideasRead More
A version of my (ordinate) Round 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.
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
This article describes a function that can be used to returns a compass point From a whole circle bearing (0-360)
——————————————————————————————- 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
I have published a number of times and implementation of functions what would extract a specific point from any geometry object. These appear in my LINEAR PL/SQL package and the T_GEOMETRY object that was published as part of the PACT book I wrote with Dr Siva Ravada. When working for a customer recently I hadRead More