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.
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 […]
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 […]
This week Ofcom released the data sitting behind their recent broadband study. The dataset contains over 1.5m postcodes from across Britain, summarizing the local broadband experience. So what the Ofcom broadband data tells us? The file is far too big to play win in Excel but when loaded into a spatial database it becomes a […]
There are some fantastic tools out there for detailed design of fibre networks from companies like Comsof and IT Simplicity but they are sometimes overkill when all you want to gauge is if fibre is even the right technology to consider or if a project is worth going to the extra level of detail. However, there […]
I’ve recently needed to find a way to break a large dataset of points into manageable clusters, ideally within a Postgres database so this post looks at methods of clustering spatial data. I’ve not found anything in PostGIS, although would love to be proved wrong, so I looked to the R statistical language and to using […]
One of the more common mapping questions I get asked is about predicting VDSL speeds – who might benefit from an upgrade to Fibre to the Cabinet (FttC) and who might be caught in what might be called the “NGA but not superfast” trap where premises are connected to an upgraded cabinet but don’t really benefit […]