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.
This article recommends using the GEOMETRY_COLUMNS metadata table to control access to feature tables and their geometry properties for qGIS.
This article shows how to remove duplicate vertices/point in SQL Server Spatial geometry objects.
This post generates and visualizes all the topological relationships possible between two linestrings.
This article describes how to repackage the functionality in the SDO_LRS package via an PL/SQL object to provide a cleaner neater API.
This article shows how to construct a function that allows any linestring to be split by any point using a collection of SDO_LRS procedures and functions.
This article describes how to split a linestring or a multilinestring using PL/SQL at a known point.