The Spatial Database Advisor

Introduction I haven’t been posting much over the past few years: a new job has seen to that given I have only time out of work left to me to post.

(I’ve referred to the issues around use of geography vs geometry data types in articles elsewhere on this website.)

This is an interesting introductory article on something I have been involved with a number of times.

A previous article outlined how to convert the native PostgreSQL geometric types to PostGIS.

Introduction I comes as a surprise to some that PostgreSQL has it own native geometric type system.

A colleague asked if I could implement the fitting of a 2D linestring to a set of points using a bezier approximation returning a polygon.

Introduction SQL Server Spatial’s geography data type requires a specific ring orientation for its polygons.

Lambert Conformal Conic 2 Standard Parallels This projection is commonly used around the world.

Back in 2005 I wrote two article on LiDAR.

Previously I have written an article on creating a function that implements a Delaunay triangulation for PostGIS.