Fast contour lines using plain PostGIS
There’s a bunch of different ways to generate contour lines [1] from scatter data, each of them based on different interpolation algorithms. Like KNN [2], ID...
Recent Posts
Some little known PostgreSQL/PostGIS tips & tricks
0. What’s this and what’s not
QuadGrid: fast spatial data generalization for the best LoD
Last years have seen the rise of data sources with IoT, AoT, mobile devices, beacons, etc. The study of this data can be quite profitable, but there are laws...
Using PostGIS for isovists calculation
First of all, what is an isovist? It’s simply the same as a viewshed… and what the heck is a viewshed? Let’s go to the Wikipedia:
Dymanically find loops in a tracks dataset
To write te article Spies in the sky, the authors needed a multi-step analysis, explained here