Thursday, December 30, 2021

Land Registry November 2021

My server is churning through the latest Land Registry data (for November 2021) and the top level figures are now available on my website. Prices continue upwards although at a slower pace, the number of sales are still subdued after the end of the Stamp Duty holiday

Thursday, December 23, 2021

Update to .NET Coordinates

I've released a new version of .NET Coordinates to add support for the Irish Transverse Mercator coordinate system. This was introduced 20 years ago to replace the Irish National Grid and I only heard of it about a week ago... I've also made some changes under the hood to make adding new coordinate systems easier in future so if your favourite isn't available, let me know.

Monday, December 13, 2021

Distance to sea improvements

I've been showing some love to the Distance to Sea page. I've improved the precision of the coastline I'm using for the calculation, although it's still not super accurate since it would be really slow to load. I've also improved the algorithm used to calculate the distance so it should give more sensible results. I've also made a few other minor tweaks that should make it easier to use.

Friday, November 26, 2021

Land Registry data for October 2021

I've uploaded the latest Land Registry data to my website. It's been a few months since the end of the Stamp Duty holiday and it's now clear the number of sales has fallen quite dramatically since then. Prices are still increasing but at a slower rate than previously.

Friday, November 12, 2021

Constituency MPs

I've updated my constituency data to include the MP and their party. I've also improved the KML to use markers representing each party


Wednesday, November 10, 2021

Bus stops

Everybody loves buses, right? So everybody must also love bus stops. A while ago someone asked about adding the nearest bus stop to the postcode data alongside the nearest train station and I've since imported the NapTan bus stop data into my database. Nearest bus stops can now be seen when viewing individual postcodes, train stations and football stadiums.

What I haven't done is add the nearest bus stop to the postcodes data. I'm wondering if that's actually a useful thing to include since a bus stop a little further away may have more regular services or the buses may go in a more useful direction. But if anyone does want this data or wants other bus stop related data, let me know

Saturday, October 23, 2021

Welsh counties

I've added Welsh preserved counties to the counties data. If anybody knows of any KML files of the boundaries of these counties, I'd be interested in reusing the data

Saturday, October 09, 2021

Find postcodes improvement

A minor update to the find postcodes page, you can now enter a latitude/longitude rather than clicking on the map

Find postcodes (doogal.co.uk) 

Monday, October 04, 2021

Land Registry data for Aug 2021

A bit later than usual this month due to packing my daughter off to university, but the Land Registry data for August is now being uploaded to my website. Covid and the end of the Stamp Duty holiday continue to make it difficult to draw any conclusions from the data

Sunday, September 26, 2021

NUTS / ITL data now available

NUTS is yet another way of dividing countries into smaller subdivisions. It's been renamed to ITL since Brexit, although the defined areas currently remain the same.

I've added level 2 and level 3 data to the main postcode CSV downloads (NUTS level 1 data was already available as the Region column). If you'd like it available in any other formats, let me know.

UK Postcodes (doogal.co.uk)

Monday, September 20, 2021

Loading and saving shapes

I've made a little improvement to the shape generator page so you can load and save multiple collections of shapes. That means I can now use it for what I want to use it for!

Map shapes generator (doogal.co.uk)

Sunday, September 19, 2021

Updated built up areas CSV download

The CSV download for built up areas now includes population, households and county data

Built up areas (doogal.co.uk)

Population and households data is still from 2011 unfortunately, 2021 census data has not been released yet

Friday, September 17, 2021

Wednesday, September 01, 2021

The cycle lane to hell

It started with me noticing I wasn't far from the top of the leaderboard for number of roads covered in Claygate on Wandrer. Then came the realisation that the only way to top that leaderboard was to ride along some of the A3. A bit of a search of Google Maps showed what appeared to be a cycle lane


So somebody at some point thought it was a sensible idea to ride on the A3 at the Esher junction. And to be fair, it didn't look too bad, other than the laughably narrow cycle lane on the slip road. Although the traffic is fairly fast moving at that point, there's a hard shoulder, which I'm guessing is where cyclists who want to live are meant to ride. But the hard shoulder disappears when the road merges with the Kingston bypass and you can't exit onto that road. You also can't exit at the next junction, by which point the A3 has turned into a nasty, busy, suburban thoroughfare. It's only after passing that junction and avoiding the traffic coming on via the slip road that you can actually exit onto a local road. 

I've searched up and down the road on Street View trying to find the officially sanctioned route for cyclists but I can find no further signs for cyclists. Did they just forget to finish this bit of infrastructure or was the planner actively trying to kill people?

I did figure out a couple of possible ways to escape the A3 before it gets too unpleasant. There's a tunnel under the A3 with a path into Claygate. That does involve negotiating a barbed wire fence but is otherwise OK. 


The two times I've been down that path the tunnel has been flooded so you may not have much luck if you need to get through it.

The other option would be to hop over onto the Kingston bypass via what looks like an unofficial junction drivers have created when they've realised they can't get there via a road. That involves negotiating the cars merging from the Kingston bypass and then probably stopping to get onto the grass, but probably OK if there's not much traffic

Saturday, August 28, 2021

Find postcodes improvement

I've made a small modification to the Find Postcodes page so you can now upload a KML file and see the shapes within it rather than having to upload and draw your own shape around it. Let me know if there any problems with it

Friday, August 27, 2021

Latest Land Registry data

I'm in the process of uploading the latest Land Registry data to my site for July 2021. Although the sales data won't be complete yet, the effect of the end of the Stamp Duty holiday for higher value properties already appears to be visible in sale prices, with a noticable increase in prices in June and a big reduction in July

Sunday, August 22, 2021

Friday, August 20, 2021

Strava route viewer now using new maps

The Strava route viewer is now using the same maps as the segment explorer. Again hopefully I've not broken anything other than IE support


Wednesday, August 18, 2021

Strava segment explorer with new maps

I’ve updated my Strava segment explorer page to use different maps. These maps include more tracks and paths and also show contour lines to give you more of an idea of the gradient you’ll be facing. Other than that, it should work just the same as before. Of course I may have introduced a bug or two so let me know if you have any problems. Unfortunately I can no longer support Internet Explorer with these maps.

Sunday, August 01, 2021

Finding roads in a polygon

I’ve made some improvements to the Find Places page. Support for roads is now better since it displays the actual path of the road, rather than just the centre point. So if you question is ‘what are the roads in this polygon?’, you can now find the answer.

Friday, July 30, 2021

Tuesday, June 01, 2021

Land Registry sales data for April 2021

Another month, another drop of property data. And another month showing a big increase in property prices. You can find the data here. Whether intentional or not, the Stamp Duty holiday has caused a house price boom.

Saturday, May 22, 2021

Saturday, May 01, 2021

Land Registry data for March 2021

I’ve uploaded the latest house price data from the Land Registry to my website. It seems the Stamp Duty holiday, put in place to save the housing market during the pandemic, has actually caused something of a house price boom. Time will tell what happens at the end of the holiday.

Tuesday, April 06, 2021

House price data for February 2021

I’ve uploaded the latest house price data for England and Wales from the Land Registry to my website. We’re still in the middle of a pandemic but house prices continue to defy gravity, almost certainly due to the stamp duty holiday. That is due to end in June so we’ll see what happens after that

Saturday, February 27, 2021

Sunday, February 21, 2021

Updated UK postcode data

I’ve updated the UK postcode data on my website to use the February 2021 ONS release. It’s passed my usual sanity checks but if you see anything amiss, let me know.

Friday, January 29, 2021

Land Registry property data for December 2020

I’ve uploaded the latest property data for England and Wales to my website. I’ve also made some changes to the charts so they hopefully give a clearer picture of trends in sales and prices. I think the most striking thing I see is that the number of sales over the last year have dropped to levels last seen in the days after the global financial crash. But unlike those days, this hasn’t had the same effect on prices which have continued to rise. I guess that’s down to the removal of stamp duty, so it will be interesting to see what happens when that ends.