Address Twins: One man’s search for the shortest distance between two homes with the same address

Another popular street name. Image: Getty.

If you lived in a house with the address ’5 Station Road’, it probably wouldn’t surprise you if you learned that there was another house somewhere in the country which also had the address ’5 Station Road’. There are, after all, over 2000 streets named ’Station Road’ in the UK.

But the fact that you sometimes get streets quite close together with the same name can be confusing. In London, there’s a sign on the platform at Abbey Road DLR station telling tourists, via the medium of appalling puns, that if they’re looking for the Abbey Road made famous by the Beatles, they are, in fact, in the wrong place. The Beatles’ Abbey Road is 12.5km away from the Abbey Road DLR station.

I found myself wondering what the shortest distance was between two Address Twins – houses with the same number and the same street-name.

Unfortunately, I can’t find a publicly-available list of every house in the UK – Royal Mail have house address data, but you have to pay a minimum of £399 to licence it. But I do have an Ordnance Survey list of every street in the UK, so my plan was to find every pair of streets with the same name, calculate the distance between them, sort them from nearest to furthest, and then go down the list looking on Google Streetview until I found two houses with the same number. Easy.

So: I removed uniquely-named streets, and calculated the distance between any two streets with the same name. And I found that there were pairs of streets which were only a few metres apart. When I had a look on a map, I discovered that this appeared to be because if a street had a spur coming off it, that spur was sometimes listed as a separate street.

I also discovered that there were streets which had been fairly long in the past, but something had happened to split the street in two (like they built a park, or a school in the middle of it), and now the two ends of the street were listed as two different streets. Obviously, in neither of these cases would there be any house-numbers in common, so I needed to get rid of them.

I thought about just discarding any pairs of streets that were closer than a certain distance. Maybe 1km? Just to check, I had a look at a few random address-pairs around the 1 kilometre boundary, when I found this…

Image: Ordnance Survey/Google Street view/author provided.

Two streets with the same name, less than a kilometre apart, with at least one house-number in common! Blimey!

Um. So instead of discarding everything under a kilometre, I could actually discard everything over a kilometre. That meant a huge reduction in the amount of data.

This still left a lot of data though, and no way I could think of to procedurally remove the spur streets or split streets mentioned above, so I went through the data by hand.

It took ages.

This, by the way, showed up loads of errors in the Ordnance Survey data. The OS manage a vast amount of data and errors are bound to appear. If an error is of a type which is unlikely to be spotted during ‘normal’ usage of the data, it might never be found until some weirdo comes along, uses the data in an unorthodox way, and finds all the hidden flaws.

When I made my town & street name search apps, I’d already found dozens of errors in the OS data, but now I found loads more – especially duplicated streets. In one case, they had seven streets named Church Meadows within metres of each other. They turned out to all be the same street. Seven streets gives twenty-one pairs of streets – all erroneous. Aaaarrrgh!

The results

Yes! The bit you actually care about!

When I first wrote this blog post, I had here a top five of closest Address Twins, but for reasons I’ll get to later I’ve reduced it to just number one. The distance is front-door to front-door as measured with Google Earth’s ‘ruler’, rounded to the nearest five metres.

Image: Streetmap.co.uk.

2 George Street BB5 0HD, and 2 George Street BB5 0ET, both in Accrington, Lancashire, are only 235 metres apart.

Yes, that’s right. These twins are less than a sixth of a mile apart. When I set out to find the closest twins, I thought they might perhaps be around a mile and a half apart, which would itself be quite silly. But 235 metres is definitely in the “What were they thinking?” category.

Image: author provided.

It’s possible to stand at a point midway between the two houses where you can see both of them without moving. Sadly, you can’t quite see one house from the other.

But wait…

So, I was happy with that result. I wrote up this blog post, and I even visited the houses in Accrington and took some photos, while I was there for an exhibition.


But…

Before I posted this, I discovered that HM Land Registry make available data on their website about property sales in England and Wales. You can download all standard and additional price paid data transactions received at HM Land Registry from 1 January 1995 to the most current monthly data. So I got a copy to have a nosey.

I noticed that, amongst other things, the data contained the house number, street name, and postcode of almost every house that had been sold since 1995.

Now obviously this is not a complete list of every house in the UK, but because it was the nearest thing I’d found to a list of individual houses, I was intrigued as to whether it might show up any additional insights into the nearest address-twins.

Obviously there was a lot of data, and no geographic data which I could use directly to calculate distances between houses. So I generated a list of every pair of houses which had the same number and street name, and had different postcodes, but where the postcodes only differed by the last letter – because I guessed that very close address twins were likely to have very similar postcodes. The data was incomplete anyway, so I was just doing this out of curiosity.

And then, while checking out random house pairs, I found this…

Image: Streetmap.co.uk.

Um…

Oh.

I realised that one of my fundamental assumptions had been incorrect. I assumed that you couldn’t get two houses close together with the same number on the same street. Clearly you could. Those two houses are only about 130 metres apart.

Bugger.

So all the work I’d done up to this point was for nothing.

*quiet sobbing*

So now I had a choice. All the Ordnance Survey data was no longer useful. If I wanted to continue with the Land Registry data, then it would mean a lot more processing, because there was more data to start with, and none of it had any position data. Also, even if I found the closest address twins, I’d have no way of knowing if they were genuinely the closest in real life, because the data wasn’t a complete list of every house – as well as not including Scotland, it’s possible that there were entire streets where no house had been sold in the last 20 years. 

The Sunk Cost Fallacy

The Misconception: You make rational decisions based on the future value of objects, investments and experiences.

The Truth: Your decisions are tainted by the emotional investments you accumulate, and the more you invest in something the harder it becomes to abandon it. 

So… on we go then.

I removed duplicate addresses (if a house was sold twice, it appeared in the list twice, etc.). Then I removed flats (because they all share an address and just screw up the results). Then I found every pair of address twins. Then I grouped all the pairs by street. Then I geolocated the postcodes of every pair of streets. Then I calculated the distances and sorted the list by nearest to furthest.

This all took ages.

The resulting list still needed work because of a few factors. Firstly, the original file contained legacy data, so if a house changed postcode for some reason, it might be listed under both postcodes. Secondly, it appears that sometimes new-build houses are sold before they’ve had a postcode assigned, so the first time they’re sold they use a random nearby postcode – which means that, again, the same house might appear under two different postcodes.

And thirdly, some of the postcode geolocation data was wrong, because of course it was.

My enthusiasm was starting to flag by this point, so I thought that the first thing I’d do was to find the two nearest address twins which were in completely different postcode areas to each other. This involved processing much less data, and at least I’d have a result of some description – which would hopefully be an incentive to find the ultimate result.

The results (part 2)

What I didn’t expect was that almost immediately I’d find the ultimate result.

The holy grail.

Yes! The big one.

Image: author provided.

See these two houses? They’re both number 443 Manchester Road.

The one on the left is in Bolton; the one on the right is in Salford, both in Greater Manchester. They’re literally next door to each other.

Image: Streetmap.co.uk.

I cannot get over how ridiculous a situation this is. It’s possible to live in a house where your next-door neighbour on the same street has the same house number as you.

I spoke to a chap who lived on the other side of the road (who, quite rightly, wanted to know why I was taking photos of people’s houses). Apparently they’ve been trying for ages to get the two councils to put up signage to clarify the situation. You can see in the photo the sign on the Salford side which says “Manchester Road, Clifton”, but without a corresponding sign on the Bolton side, or maybe arrows to indicate that “Clifton” refers to the area to the right of the sign, it doesn’t really help.

So, the answer to the question “What’s the shortest distance between two houses with the same number and the same street-name?” is “no distance at all”.

PS…

You may have noticed that all the houses I’ve mentioned are in the North of England – particularly the North-West. This seems to be a trend. Of all the many twin-streets I looked at which I haven’t mentioned here, I’d say that at least 80 per cent of them were in the North, particularly the North-West. I’m not sure why this is.

My guess is that people used to have very localised lives, and it didn’t matter that lots of streets had the same names. The reason this situation remains in the North-West, I’m guessing, is that compared to other areas of the country, very little regeneration has taken place since then.

PPS…

It’s unlikely you’re thinking of actually visiting these houses, but I was nerdy enough to do so, so you might also, in which case remember that these are private houses. Don’t hassle the people who live there. Try not to look like you’re planning a robbery. You know, just be sensible about it.

This article originally appeared on Paul Plowman’s personal blog, and appears here with his permission.

Want more of this stuff? Follow CityMetric on Twitter or Facebook

 
 
 
 

You’ve heard of trainspotters and planespotters. Now meet Britain’s growing army of busspotters

Some busspotters in action. Image: Damian Potter.

In the summer of 2014, with too much time on my hands and too little to do, I found myself in the middle of an incredibly active, 200+ person Facebook group. How I ended up here (record scratch, freeze frame) is a little too convoluted and stupid to explain – but what I found was a world that I a) could not have imagined nor b) had any clue even existed.

The group I tumbled into was what I now understand to be a very, very small example of a “busspotting” group – that is, a Facebook group full of dedicated bus enthusiasts which exists to share pictures of buses they see on the road. This group had members from all over the country, with a concentration on northern buses, and was predominantly filled with young, white men.

What I expected to see was a range over relatively interesting buses, holding some significance or another, that were tough to find in your average day-to-day life. This was, largely, not the case. What fascinated me was that the vast majority of the group was not focused on unique buses, new buses, historically significant buses, and so on – but simply on the average bus and or bus route you might take just to get around your city.

What was even more bizarre to me was that people from across the country were meeting up in small towns (Morpeth, Livingston, Stevenage) to take seemingly mundane bus rides to other equally small places (Washington, Gloucester, Grimsby). The busspotters would travel hours on end to meet at these locations simply to ride this bus, often for three or four hours, and experience a bus route they’d never been on before or one that they just particularly enjoyed.

Ooooh. Image: Damian Potter.

After a couple of weeks of silently watching and one semi-ironic post, I left the group. And, for the next three years, I gave barely a thought to bus enthusiasm, as no busspotter group/page/person crossed my path. Unlike similar enthusiasms like planespotting and trainspotting, it didn’t seem to me that busspotting had any significant following.

But, as is the way of these things, a weird thread on Twitter three summers later sparked my memory of my short time in this group. I wanted to see what busspotting was actually and about and if, in fact, it was still a thing.

So I spoke to Damian Potter, an admin on several popular busspotting groups, about what it’s like to be deep into the busspotting scene.

“I used to sit upstairs on double decker buses and 'drive' them, including the pedal movements!” Damian announced right off the bat, speaking of his childhood. “I've been driving coaches at home and abroad since I passed my PCV test in 1994. I've been driving for Transdev Harrogate and District Travel since 1998.”

Damian, as you might have gathered, has been a busspotter since his early youth. Now, at the age of 50, he manages four different busspotting Facebook groupsm, mostly based around the Harrogate area (Transdev Enthusiasts, The Harrogate Bus Company, iTransport Worldwide and Spotting Bus and Coach Spotters). Some of them have over a thousand members.

He also participates in busspotting IRL, travelling around the country participating in busspotting meet-ups and events and co-organising trips along different bus routes. When I asked him what busspotting was to him, he explained that it can manifest in different ways: some people focus on makes of bus and routes, other focus on particular bus companies (National Express is particularly popular). Of course, bus enthusiasm is not solely a British phenomenon, but busspotters can certainly be found in practically every corner of the UK.

“People tend to think that spotters hang around bus stations furtively, with a camera and some curly cheese sandwiches, but this isn't really the case,” Damian continued. That said, he also mentioned some particularly hardcore bus nuts who have been known to trespass on company premises to be the first to snap a picture of a new bus.

“They really do produce some brilliant pictures, though,” he added.


Although much of busspotting culture happens online, predominantly on Facebook, groups often have what are called ‘running days’ which involve meet ups having to do with particular routes. Damian mentioned one particularly popular day following the London Routemaster buses that happen periodically. Not only do these routes draw in enthusiasts, he noted, but also draw huge numbers of tourists who want to claim they’ve ridden on the original London buses.

“I reckon the general public miss the old Routemaster buses. There is only one 'heritage' route in London which still uses Routemaster buses and that's the 15 service between Trafalgar Square and Tower Hill.”

Despite this widespread interest in buses and bus history, though, busspotters often find themselves treated as the lesser of the motor enthusiasts. This became clear to me almost immediately when speaking to Damian, and continued to strike me throughout our conversation; without my saying anything sarcastic, malicious, or snarky, he became instantly defensive of his fellow enthusiasts and of his hobby.

When I asked him why he felt this immediate need to defend busspotting, he explained that people often ridicule busspotters and bus enthusiasm generally, arguing that bus drivers are the most common attackers. “However,” he noted, “if I bring a load of pictures into the canteen they're the first to crowd around to see bus pictures...”

Aaah. Image: Damian Potter.

Despite being perceived as an often-mocked hobby, bus enthusiasm is expanding rapidly, Damien claims. “The bus enthusiast culture is growing, with younger generations getting more involved.” Drawing in new, younger enthusiasts has become easier thanks to social media, as has creating real personal connections. Social media has made it easier for bus enthusiasm to not just stay afloat, but actually thrive over the last several years.

It’s so widespread, in fact, that a national competition is held every year in Blackpool to mark Bus Driver of the Year (Damian himself came in 34th out of 155 back in 2002). This event draws in everyone from the bus world – drivers, manufacturers, tour companies, and enthusiasts alike. Here is one of the many places where great friendships are forged and busspotters who’ve only known each other online can finally meet face-to-face. “Personally I have made some great friends through Facebook,” Damian told me. “I have even stayed over at a friend's house in London a couple of times.”

Busspotting may be less well-known than motor enthusiasms like planespotting and trainspotting, but that very well could change. Thanks to active social media groups and regular in-person meet-ups, people have been able to use busspotting forums as not only a way to find lifelong friends, but also spend more of their free time exploring their hobby with the people they’ve met through these groups and pages who share their enthusiasm. For all the flack it may receive, the future of busspotting looks bright.

Want more of this stuff? Follow CityMetric on Twitter or Facebook.