The Frontage Problem: Creating references from land parcel street frontage boundary to point in street

This article demonstrates the power of database-based spatial processing. The business requirement is to determine, dynamically, the side of a land parcel that faces the street (could be single 2 point straight line to something more complex), and then determine the clockface direction from either ends of the frontage or the middle, to a object in the roads reserve (eg telecommunications pit).

Read More »

ST_Densify for Object PLSQL

The Java Topology Suite (JTS) has a linestring densifier function that is available in my Spatial Companion for Oracle (SC4O) solution. See here for documentation.

Read More »

New versions of LINEAR, CENTROID and GEOM etc packages

——————————————————————————————- NOTICE (2020): All packages have been moved to my new SPDBA website ——————————————————————————————- ——————————————————————————————- UPDATE (21 Mar 2018): ——————————————————————————————- I have just released a

Read More »