A quick post today to talk about a couple of PostGIS functions I learnt recently. I had a CSV file that contained well-known binary (WKB) representations of geometries, stored as hexadecimal strings. I imported the CSV into a PostGIS database, and wanted to convert these to be proper PostGIS geometries. I initially went for the […]
It’s been a while since I posted here – I kind of lost momentum over the summer (which is a busy time with a school-aged child) and never really picked it up again. Anyway, I wanted to write a quick post to tell people that I won two awards at the British Cartographic Society awards […]
Summary: I’ve created a demo web app where you can search an aerial photo of Southampton, UK using text queries such as "roundabout", "tennis court" or "ship". It uses vector embeddings to do this – which I explain in this blog post. In this post I’m going to try and explain a bit more about […]
I’m interested to find out who is reading my blog. Following the lead of Jamie Tanna who was in turn copying Terence Eden (both of whose blogs I read), I’d like to ask people who read this to drop me an email or leave a comment on this post if you read this blog and […]
For months now I’ve been collecting a load of links saying that I’ll get round to blogging them "soon". Well, I’m currently babysitting for a friend’s daughter (who is sleeping peacefully upstairs), so I’ve finally found time to write them up. So, here are a load of links – a lot of them are geospatial- […]
I’ve been informed that this method is no longer working, and I haven’t had time to try and update it to work again. I’m leaving this here for historical value, and in case anyone can adapt the method to make it work. Microsoft Planetary Computer is a wonderful archive of geospatial datasets (primarily raster images […]
Another new-ish package that I’ve never got around to writing about on my blog is offline_folium. It has a somewhat niche use-case, but it seems like a few people have found it useful. In brief, it allows you to use the folium package for creating interactive maps from Python, but without an internet connection. Folium […]
I realised recently that I’d never actually blogged about my pyAURN package – so it’s about time that I did. When doing some freelance work on air quality a while back, I wanted an easy way to access UK air quality from the Automatic Urban and Rural Network (AURN). Unfortunately, there isn’t a nice API […]
Recently I was interviewed on the Geomob podcast. You can listen on the Geomob site or using the embedded player below: In the episode I talk about the British Placename Mapper and its inspiration, how I built it, and what might come next. I also cover some of my other geospatial projects including the Free […]
Just a quick post here to say that I’ve added a new Projects page to my freelance website. I realised I didn’t have anywhere online that I could point people to that had links to all of the ‘non-work’ (maybe that should be ‘non-paid’) projects I’ve made. These projects include my Free GIS Data site, […]