Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (19)
- All (400)
- Biography (1)
- Blog (45)
- Business Requirements (1)
- Commentary (1)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- GPS (1)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- LiDAR (1)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (4)
- Open Source (18)
- Oracle Spatial and Locator (193)
- Partitioning (1)
- PostGIS (34)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (35)
- Space Curves (9)
- Spatial Database Functions (107)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (91)
- Standards (3)
- Stored Procedure (15)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
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.
18 April, 2022
No Comments
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.
18 April, 2022
No Comments
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.
13 April, 2022
No Comments
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.
7 April, 2022
No Comments
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.
22 March, 2022
No Comments
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.
3 November, 2021
No Comments
Removing Duplicate Vertices in SQL Server Spatial
This article shows how to remove duplicate vertices/point in SQL Server Spatial geometry objects.
23 October, 2021
No Comments
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
12 December, 2020
No Comments
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.
6 December, 2020
No Comments
Linear Referencing System (LRS) Functions for TSQL
This articles logically steps through all the functions in a complete package of Linear Referencing functions that I have written for TSQL. The article both demonstrates the power of SQL Server Spatial but what can be done with TSQL.
6 December, 2020
No Comments