OptimoRoute
optimoroute
Year: 2024
Functions to Convert Native PostgreSQL geometric types to PostGIS
A set of functions that enable the conversion of the native PostgreSQL geometric types to PostGIS geometry objects.
Converting PostgreSQL Native Geometric Types to PostGIS
Introduction I comes as a surprise to some that PostgreSQL has it own native geometric type system. The geometric types are documented here but the list includes: point – Point on a plane – (x,y) lseg – Finite line segment – ((x1,y1),(x2,y2)) box – Rectangular box – ((x1,y1),(x2,y2)) path – Closed path (similar to polygon)Read More
Fitting Bezier Polygon to Points
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. The original implementation is Smooth a 2D polyline through a set of points by interpolation (Catmull-Rom) or approximation (Chaikin).. First off, we do a Chaikin smoothing (method 1) of aRead More