This article demonstrates the effect wrong ring orientation has on the processing of a geography object and shows how to fix such orientation.
This article shows how scale is affected when calculating distances along the Lambert Conformal Conic Projection by comparing distances computed on the projection against those calculated along a geographic projection.
Back in 2005 I wrote two article on LiDAR. These articles are: Killer Data – Part 1 Killer Data – Part 2 Enjoy.
This article shows how to create a delaunay triangulation (mesh) from various inputs in SQL Server Spatial, and compute the 3D (slope) area.
This article shows how to create linestring and mutlilinestring SQL Server geometry objects from a from table of ordinates.
Introduction (This article is about Oracle Spatial.) It is quite a common thing to have ordinates held as separate columns within a table as in the following CTE example. How does one create linestrings and multilinestrings from this data? First things first: A linestring A linestring can be created by serialising the separate x, yRead More
In this article a quad tree tesselation is used to define how to partition a table of based on its spatial data (geographic points) in SQL Server. The recursive spatial partitioning uses the spatial content to influence each grid cell size.
This article presents a method for identifying and removing spikes in SQL Server Spatial linestrings and polygon rings. Spikes are common when processing GPS observations.
This article outlines why the storage formats used for geometry data by database spatial APIs are irrelevant: what is important is logical access.
This articles describes how to compute the cumulative length of a single linestring, or the total tonnage that crosses a set road segments.