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.
Simon Greener
Creating linestring geometries from a table of ordinates (Oracle)
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
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.
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.
Visualising the Topological Relations of LineStrings
This post generates and visualizes all the topological relationships possible between two linestrings.
Object Implementation of Oracle SDO_LRS
This article describes how to repackage the functionality in the SDO_LRS package via an PL/SQL object to provide a cleaner neater API.
Split Oracle Sdo_Geometry Linestring at a Known Point using SDO_LRS and PL/SQL (2)
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.
GeoRaptor: Direct Display of SDO_GEOMETRY / WKT text objects
This article shows how to use GeoRaptor’s Jump to Geometry functionality to conduct “one off” mapping of SDO_GEOMETRY and EWKT/WKT text objects. PostGIS is shown as a source for EWKT showing how to integrate development across multiple databases.