# Robin Wilson A remote-sensing PhD student talking about interesting things... This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## New site for my John Snow Cholera Map data DevFeed: [New site for my John Snow Cholera Map data]() Original publisher: [Read original article]() Author: Robin Wilson Published: 2026-09-10T12:13:16Z Content type: release Language: en Sources: [Robin Wilson]() Topics: [data](), [GeoJSON](), [CSV](), [Website]() Tags: [academic](), [blog](), [csv](), [data](), [formats](), [gis](), [map](), [website]() ### AI overview The author announces a new website hosting digitized data from John Snow's cholera map. The site provides downloads in GeoPackage, GeoJSON, Shapefile, and CSV formats, and older blog posts now redirect to it. ### Source excerpt I've finally crossed something off my todo list, after putting it off for years. I've created a new site to host the data from John Snow's cholera map that I digitised back in 2012. Previously the data was only available from posts on this blog (specifically this original post and a follow-up), and it wasn't [...] ## How to fix a weird pandas and pyarrow issue with BirdNetPi DevFeed: [How to fix a weird pandas and pyarrow issue with BirdNetPi]() Original publisher: [Read original article]() Author: Robin Wilson Published: 2026-08-27T17:57:36Z Content type: tutorial Language: en Sources: [Robin Wilson]() Topics: [Python](), [Raspberry Pi](), [pandas]() Tags: [how-to](), [pandas](), [programming](), [python](), [raspberry-pi]() ### AI overview A troubleshooting guide for BirdNetPi explains that immediate Python crashes and missing Streamlit visualizations can be caused by the pyarrow package. The author uses import profiling to identify pyarrow as the package present immediately before the crash and recommends trying its removal. ### Source excerpt Summary: If you get Python crashing immediately in BirdNetPi, try uninstalling the pyarrow Python package. I've got a BirdNetPi set up at home. This is a bit of software that runs on a Raspberry Pi and listens on a microphone (I've mounted mine on the outside of an upstairs window, using a 3D printed mount/cover [...] ## Some recent, and not so recent, talks and activities DevFeed: [Some recent, and not so recent, talks and activities]() Original publisher: [Read original article]() Author: Robin Wilson Published: 2026-08-22T15:51:12Z Content type: article Language: en Sources: [Robin Wilson]() Topics: [geospatial](), [Database](), [Web](), [Cloud]() Tags: [2025](), [academic](), [cloud](), [computing](), [conference](), [geospatial](), [gis](), [programming](), [python](), [qgis](), [remote-sensing](), [server](), [talks](), [uk]() ### AI overview A personal account of recent and past talks and activities, including an accepted FOSS4G UK 2026 talk and a recap of a FOSS4G UK 2025 workshop on generating live vector tiles from PostGIS with pg_tileserv. ### Source excerpt There has been a long gap between posts (again!), and a lot of the stuff that I'm going to talk about in this post is fairly old too. Oh well, life keeps getting in the way of blogging. Anyway, I've recently submitted a talk for the FOSS4G UK 2026 conference in Leeds in October, and [...] ## How to bypass SSL for PROJ reprojection DevFeed: [How to bypass SSL for PROJ reprojection]() Original publisher: [Read original article]() Author: Robin Wilson Published: 2026-03-23T16:23:36Z Content type: tutorial Language: en Sources: [Robin Wilson]() Topics: [Geographic Information System](), [Security](), [SSL](), [import](), [Linux](), [osx](), [Windows]() Tags: [academic](), [command](), [computing](), [gis](), [how-to](), [import](), [linux](), [osx](), [remote-sensing](), [security](), [ssl](), [windows]() ### AI overview This tutorial explains how to temporarily disable SSL verification for PROJ during coordinate reprojection when self-signed or misconfigured certificates cause downloads of conversion data to fail. It notes the security trade-off and points to setting a PROJ environment variable. ### Source excerpt A friend was using GDAL's ogr2ogr command to import some data to PostGIS recently, and as part of the import they were doing a reprojection of the data. They got the following error: PROJ: Cannot open https://cdn.proj.org/uk_os_OSTN15_NTv2_OSGBtoETRS.tif: schannel: the certificate or certificate chain is based on an untrusted root They've had various SSL errors on [...] ## Pharmacy late-night opening hours analysis featured in the Financial Times DevFeed: [Pharmacy late-night opening hours analysis featured in the Financial Times]() Original publisher: [Read original article]() Author: Robin Wilson Published: 2026-02-04T14:10:37Z Content type: article Language: en Sources: [Robin Wilson]() Topics: [Data analysis](), [geospatial](), [Geographic Information System](), [Python](), [pandas]() Tags: [academic](), [analysis](), [article](), [data](), [data-analysis](), [geospatial](), [gis](), [pandas](), [python]() ### AI overview The article describes an analysis of NHS data on community pharmacy opening hours in England. It reports that the number of pharmacies open past 9pm on weekdays fell by approximately 95% between 2022 and 2025, leaving large areas without late-night pharmacy access. The analysis used Python, pandas, geospatial tools and mapping libraries, and was featured in the Financial Times. ### Source excerpt Some data analysis I've done has been featured in the Financial Times today - see this article (the link may not work any more unless you have a FT subscription - sorry). The brief story is that I had terrible back pain over Christmas, and spoke to an out-of-hours GP on the phone who prescribed [...] ## How to fix osm2pgrouting error 'relation "\_\_waysXXXX" does not exist' and speed up the import DevFeed: [How to fix osm2pgrouting error 'relation "\_\_waysXXXX" does not exist' and speed up the import]() Original publisher: [Read original article]() Author: Robin Wilson Published: 2026-01-31T10:33:00Z Content type: tutorial Language: en Sources: [Robin Wilson]() Topics: [import](), [Database](), [Command-line interface](), [Cloud]() Tags: [cloud](), [command-line](), [database](), [error](), [gis](), [how-to](), [import](), [postgres](), [speed]() ### AI overview A practical guide to fixing an osm2pgrouting error involving a missing __waysXXXX relation while importing OpenStreetMap data into PostGIS. It explains that increasing the command's chunk-size parameter can prevent crashes and reduce the import time to about 45 minutes, while requiring substantial RAM. ### Source excerpt I don't seem to have time or energy for long posts these days, but here's another quick post which might save you some time and frustration. Recently, I've been trying to import OpenStreetMap data into a PostGIS database to use with pgRouting. I wanted to import data for the whole of England - which has [...] ## Today I Learned - in 2024 and 2025 DevFeed: [Today I Learned - in 2024 and 2025]() Original publisher: [Read original article]() Author: Robin Wilson Published: 2026-01-08T10:50:55Z Content type: article Language: en Sources: [Robin Wilson]() Topics: [Discord]() Tags: [aircraft](), [discord](), [engineering](), [linux](), [short-interesting-things](), [til](), [uk]() ### AI overview A collection of the author's "Today I Learned" posts from 2024 and 2025, originally shared in a Discord channel. The entries cover topics including atomic numbers, cancer treatment, gun tracing, the Manhattan Project, display technology, RAM security, libraries, Linux, the UK National Lottery, Volkswagen sausage, police aircraft, evacuation aprons, and Irish population history. ### Source excerpt A Discord server I use has a channel called #til, standing for Today I Learned. It's a place to post interesting or surprising things you recently learned. I took my posts to that channel from the last couple of years, tidied them up and have listed them below. Hopefully you'll find something interesting there: TIL [...]