View allAll Photos Tagged postgres
morphology study of Scotland's airports. Ordered by bounding box area.
QGIS 2.18.13, Postgres/PostGIS, Python.
row 2 looks spookily like cuneiform and early hieroglyphs (and Stornoway airport, 3rd from left in second row) looks like a head :-)
visualising the size of Scottish islands, by placing them side-by-side.
using a mixture of postgres/postgis, qgis and osm2pgsql.
used a postgis query to align the islands so that their centroids were all in the same place, then offset each successive island 20km east of its predecessor.
used data copyright OpenStreetMap and contributors. Polygons were based on admin_level='6', then split from multipart to singlepart. This made sure that Mull (for example) fragmented into lots of individual Islands so that I could isolate the "mainland" of Mull from the countless other islands just off its coast.