Articles

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

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.