Fixing Geography Ring Orientation
This article demonstrates the effect wrong ring orientation has on the processing of a geography object and shows how to fix such orientation.
SQL Server Spatial
Category to group SQL Server Spatial General posts.
Delaunay Triangulation Function for TSQL and SQL Server Spatial
This article shows how to create a delaunay triangulation (mesh) from various inputs in SQL Server Spatial, and compute the 3D (slope) area.
Creating linestring geometries from a table of ordinates (SQL Server)
This article shows how to create linestring and mutlilinestring SQL Server geometry objects from a from table of ordinates.
Partition Spatial Data using SQL Server
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.
Removing Spikes in SQL Server Spatial Linestrings
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.
How to calculate cumulative length of a linestring, or the truck tonnage that accumulates across a set of roads
This articles describes how to compute the cumulative length of a single linestring, or the total tonnage that crosses a set road segments.
qGIS, GEOMETRY_COLUMNS and SQL Server Spatial
This article recommends using the GEOMETRY_COLUMNS metadata table to control access to feature tables and their geometry properties for qGIS.
Removing Duplicate Vertices in SQL Server Spatial
This article shows how to remove duplicate vertices/point in SQL Server Spatial geometry objects.
Geometry object size when exchanging of WKT/WKB encoded geometries.
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
Geometry Validity and Method Access
This article demonstrates how an invalid polygon (and linestring) are handled by the different database spatial APIs with correction in TSQL.