I have a densify function for my PL/SQL (Package and Object) code. A SQL Server Spatial version exists as follows: Description This function add vertices to an existing vertex-to-vertex described (m)linestring or (m)polygon sdo_geometry. New vertices are added in such a way as to maintain existing vertices, that is, no existing vertices are removed. DensificationRead More
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
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
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
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
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
Oracle Spatial has, for many versions, made available an implementation of the OpenGIS SFS type hierarchy. Today I will show how to use this type hierarchy do extract points from an SDO_GEOMETRY. The first example extracts the first and last point from a linestring constructed from Well Known Text. The second example finds the firstRead More
I love working with the PostGIS API. It is a deep and wide river to swim in. But sometime having read, researched, experimented, and not found the right solution one can be forced to roll one’s own so to speak to get the job done. For the problem below, if someone can point out aRead More
This article is about applying spatial and host database processing to solving a specific, and real, customer requirement: to visualise a communications pit and its contents on a map as a concept called a “Butterfly”. The solution uses logical connectivity within the data model to create spatial objects on the fly from minimal hard geometryRead More
Over the past 13 years I have made available on my website code samples, packages, installers, jar files etc that presented the results of thousands of hours of algorithm design and implementation. This work has been made available via blog articles and free code available via free download. The blogging will continue, as will theRead More