A year or so ago I wrote a blog on how to cluster points of geographical data from within an SQL database. It was a working solution but inelegant and a bit clunky so I’ve finally got around to tidying it up and turning it into a proper function. PostgreSQL and PostGIS don’t have built-in clustering functions […]
As a bit of Friday fun I’ve re-run my 3D model on parts of Lancashire to see what the landscape looks like when you have B4RN Towers alongside the low-rise living of ordinary broadband users.
Its long been a problem that Local Authorities have published broadband maps of their publicly-funded roll-out programmes but made looking up the data really quite hard. While a householder can usually find their own area quite quickly an operator considering investing in a wider area often finds it very much harder, sometimes resorting to manually entering postcodes one […]
Following on from my articles on bringing Charles Booths maps up to date and visualising Ofcom’s broadband speed data, I’ve been looking at other ways to create webmaps that explore data visually. A feature of QGIS that I’ve overlooked for too long is the threejs plugin; it creates interactive 3d webmaps in minutes and is able […]
Following on from the Charles Booth article, I thought I’d put together another short piece again using feely available open data from Ofcom and the OS combined with Opensource tools. Late last year Ofcom published the detailed dataset that sits behind their annual broadband speed survey. There are any number of ways of studying the […]
Charles Booth was a nineteenth century social researcher who produced fantastically detailed maps of London that described poverty levels right down to individual properties. Recently, the BBC have been re-running the Secret History of our Streets using his maps as the backdrop to a number of London communities, looking at what shaped the areas and how they changed. This got me […]
Just recently I finally got around to trying the fairly new raster support in PostGIS 2 and above; this allows you to store raster maps in a geographically enabled Postgres database alongside the more commonplace vector maps. Although it could be used for storing background maps, raster support is especially useful for managing elevation data […]