![]() |
|
![]() |
| You could be right, but I think it's a little beside the point.
The challenge illustrated in the blog post is that it's practically impossible to build a really accurate address dataset since the real world is messy for the reasons you listed. Just like falsehoods programmers believe about names [1], you shouldn't put much faith in anything that claims to normalize addresses either. As other commenters have said in the replies, my situation is not uncommon in Europe. As they say, 'the map is not the territory.' [1]: https://www.kalzumeus.com/2010/06/17/falsehoods-programmers-... |
![]() |
| Costa Rica doesn’t have numbers on the buildings, and many streets lack street signs, if not names. You’ll have addresses like “50 meters north of the old church” or “behind the banana stand.”¹ |
![]() |
| That doesn't surprise me, same thing in Germany. However having multiple buildings with the same house number (without distinguishing letters) sounds like the much worse oversight here |
![]() |
| Would not the opposite be true? If you have to write your name out just so the mail can find you, you are less anonymous than if you just have a number that gets mail directly to your mailbox. |
![]() |
| > but it does sound like someone had the opportunity to keep reality sane here
What is "sane" about reality? People want a place to live, they don't care about government databases. |
![]() |
| The BAN provide fields `long` and `lat` which are WGS84, and also `x` and `y` which are coordinates expressed in "the appropriate local CRS" (without much elaboration on what that would be). |
![]() |
| Very cool. Nice effort by France.
For a while I played around with that kind of data here in Belgium, it's not easy to get it all standardized and "usable". |
![]() |
| The answer to anecdote 2 is probably that if the seller chooses to skip validation measures on the transaction, then they become liable in the event the transaction is deemed fraudulent. |
![]() |
| This might help explain in-part the discrepancy. Perplexity.ai[1] also says 8,200 German postal codes. I set Claude 3.5 Sonnet in the LLM settings on Perplexity but it looks like it might use a ChatGPT model for the initial search of sources? At least we can see what it is sourcing to fetch the value of 8,200. Interestingly, asking Claude 3.5 Sonnet directly at claude.ai returned 16,000.[2]
1. https://www.perplexity.ai/search/how-many-german-postal-code... 2. "There are approximately 16,000 postal codes (Postleitzahlen) in Germany. These five-digit codes cover all areas of the country, including cities, towns, and rural regions. To break it down a bit further: 1. The first digit represents one of 10 postal regions. 2. The second digit typically represents a sub-region within that area. 3. The last three digits identify specific delivery areas or post offices. It's worth noting that the exact number can fluctuate slightly over time due to administrative changes, urban development, or postal service reorganization. However, 16,000 is a good approximation for the total number of German postal codes. Would you like more information about how the German postal code system works or its history?" |
![]() |
| I think that it's often easier to verify an answer than to find an answer with nothing to go on, so perhaps not entirely garbage but certainly not reliable. |
![]() |
| the problem with UK privatization is the same as with California PG&E ... it's private in name, but the incentives are all bad.
there was (is) no point for optimization on costs as the profit was a fixed percentage (so it ended up quite the opposite) instead of a price cap. (ideally the cap would be a simple formula based on input prices, to at least make the lobbying transparent. sure, this also has a built in profit percentage, but the important difference is that the profit is not fixed, so the private company is incentivized to push the costs down.) see https://www.noahpinion.blog/p/energy-bell-the-sketch-of-an-i... |
![]() |
| Hence why a house number and postcode constitutes a complete address in the UK, we’ve sort of already got What Three Words with “a number and 5-7 characters” - not quite as catchy though |
![]() |
| We needed an ambulance off road in the middle of Richmond Park where a postcode would also not help. We didn't have WTW either, which they asked for and would have helped immensely. |
![]() |
| Centimetre, and after the next big earthquake are all numbers off, sometimes even by several meters. Now what you do? New addresses for all, or wrong numbers to new buildings? |
![]() |
| > Now what you do?
When the ambulance arrives wave your hands and say "over here!". So they can do the "last several meters" of navigation by homing on your visual presence. |
![]() |
| Lat/long coordinates and metres are actually linked quite closely: the metre was originally defined as "the arc from equator to North pole is defined as 10,000 km". That is, 90 degrees is 10,000 km. |
![]() |
| You can put Ireland at the top of the list, one postcode for every address, every house has one, every apartment has one, every building has one, even some old ruins have one. |
![]() |
| Case in point, going to a funeral the post code for the crematorium was for a 2km stretch of road, and going by foot I realised my folly and so had to run to make it time. |
![]() |
| For what it's worth in the Netherlands you have about 1 postal code per 21 addresses. Typically one code is a street or the even/odd half of the street. |
![]() |
| Article 1 of Protocol 1 of the ECHR covers exactly this, so the Supreme Court (and ECtHR if it came to that) would probably find in favour of Royal Mail if this were to be done without compensation. |
![]() |
| No, I'm pretty sure this one was incompetence. It came at the same time that the government was going all-in with open data in other areas, and this was a really stupid omission. |
![]() |
| Maybe they can use the TV detector vans used for TV license enforcement to collect the data, if they're already surveilling every single building in the country on a daily basis! |
![]() |
| Every property already has a UPRN (unique property reference number). If you go on a council website and find a recent planning application it will be linked with this UPRN in the council's database. If I ever want to find a postcode I go to the find a planning application map and look it up there. I've not checked this in England, but it's definitely the case in Scotland. e.g. here's a random example; the entry for St Mungo's Cathedral in Glasgow:
https://publicaccess.glasgow.gov.uk/online-applications/case... |
![]() |
| There's certainly been distrust/mild distain for the govt in Scotland, Wales, and The North since Reagan's gender-swap, Thatcher, for broadly similar reasons Reagan is maligned |
![]() |
| True, but it's specifically the modern UK government - with its penchant for outsourcing jobs to ministers mates and bloated contractors - whose competency at large scale projects I dread. |
![]() |
| so modify the law to deprive an owner of their legal property which was given to them by the law?
Not sure that's a precedent I'd want set in a common-law country, and not sure that would hold up to judicial review under common law. The government made a bone-headed mistake when they included the postal data as an asset in the sale. The solution is for them to admit their mistake and pay for it. It's fiat money anyway, so it doesn't really cost anything. Having them abuse their government power to cover up their mistake is not an approach I endorse. Not that this hasn't happened before, think postal scandal or yesterday's comments on the Hawke and Curacoa https://news.ycombinator.com/item?id=41285275 |
![]() |
| The postcode-to-coordinate data is now freely available as "CodePoint Open"
So there's already data for people who want to know postcode AB10 1JL corresponds to the area around 57.14677,-2.09873 The PAF is a more detailed data source, as seen in https://www.royalmail.com/find-a-postcode which can tell you that AB10 1JL specifically covers the addresses 102-104, Union Street, Aberdeen 82, Union Street, Aberdeen Timpson Shoe Repairs Ltd, 86 Union Street, Aberdeen Smart Mobile, 88 Union Street, Aberdeen 92 Union Street, Aberdeen 98 Union Street, Aberdeen The PAF is useful if you want to provide a "quick address entry" option on your website - and to validate address data. But if you just want postcode-to-location conversion, that info is already available. |
![]() |
| This creates a very special Dutch thing —- my neighborhood had the roads on the map before the map itself was updated to show landmass instead of the body of water. |
![]() |
| Postcode data is already freely available. You can even get coordinates of where the properties are. What is lacking is the actual addresses within a postcode. |
![]() |
| I’d expect a modern government to design something as clear and well regarded as the GDS stuff in the U.K.
I’d expect a corporation like ibm etc to design the total mess we see with any large project |
![]() |
| Well, how many buildings, and of what sort, varies enormously, but yes it won't be a whole town or region.
Most of my street is a single post code. Once upon a time it was a street of single family dwellings, so that's maybe a 3-4 dozen homes, but this is a city suburb so densification means some of those homes were modified and cut up to form flats, one large family home becomes six smaller homes - and some were purchased, knocked down and replaced by buildings which don't look out of place but aren't what they were before. I live in a purpose built four storey block, but it's designed to look superficially like a big house, the bottom floor is below street level (it faces out over the hill), the top has only loft-style windows at the front like somebody did a loft conversion. It's all still one postcode though, so I share a code with maybe 100+ households. Recoding is disruptive and it's not really worth it, so they mostly don't do it. Remember for actually delivering the post the postcode is just a convenient human readable part of an address, the machines (with occasional human help) turn any arbitrary address into a unique destination code, and then that's literally barcoded (albeit not in a code you're used to from like UPC etc.) onto the post. So for the Royal Mail the postcodes not being as descriptive as they were fifty years ago isn't a big problem. Take some mail you've received, preferably over several days and study the outsides carefully. Two fluorescent orange bar codes have been jet printed onto the mail during sorting. The upper code is "just" a temporary unique ID, every piece of mail in the sorting system is issued a code, when they run out they start over, this helps with debugging and statistics. The lower case is in some sense the successor to the postcode, it'll be identical for every item delivered to the same address and distinct for other addresses. In fact it's encoding the "Delivery Point" which is what PAF handles, the location to which the Royal Mail employee delivers mail. https://en.wikipedia.org/wiki/RM4SCC The use of these "real" postcodes also enables the Royal Mail to more readily accede to impractical "vanity" postcode requests. If the rich people in this part of Dirt Town think they ought to have postcodes from the adjacent and posh sounding Upper Niceton, RM can allow that, because in reality their teams are working from the purely numeric code which will still treat all these new "Upper Niceton" homes as being where they actually are, in Dirt Town. |
![]() |
| There is a middle ground and some common patterns that can help.
The address field names are fairly standardized[0] and Google has an open dataset (used by Chrome and Android) describing which countries need which fields[1]. I have an older PHP library[2] and a newer Go library[3] that build upon this, while crowdsourcing fixes (since Google hasn't updated their dataset in a while). The Go library allows me to serve all address formats and state lists in a single HTTP request, which can then power a very fast JS widget. [0] Initially by the OASIS eXtensible Address Language (xAL) which trickled down into everything from maps to HTML5 autocomplete. [1] https://chromium-i18n.appspot.com/ssl-address |
![]() |
| This doesn't seem correct:
It seems to be talking about the National Statistics Postcode Lookup UK, which is officially published here: https://www.data.gov.uk/dataset/7ec10db7-c8f4-4a40-8d82-8921...It's been there from at least 2017, which is when I first came across it. There are later version of the data set online too: https://open-geography-portalx-ons.hub.arcgis.com/datasets/o... The license: https://www.ons.gov.uk/methodology/geography/licences
If the article is talking about a different postcode address file though, then the above doesn't apply. ;) |
![]() |
| How would crowdsourcing solve this problem?
> Oh, and it wouldn’t even be legally allowed to include, er, postcodes, as they are specifically owned by Royal Mail |
![]() |
| I can't find any good information post-privatisation, but at least before 2013 the postcodes themselves were copyrighted by Royal Mail (likely Crown Copyright as with government data). There were attempts to enforce this in 2009[0]. I suspect the copyright is now owned by Royal Mail Group Ltd.
That aside, a practical issue is that Royal Mail still retains the rights to _allocate_ new postcodes for any new properties. Yet another failure of this particular privatisation. [0]: https://www.techdirt.com/2009/10/06/uk-royal-mail-uses-copyr... |
![]() |
| great article, this demonstrates just how bad the civil service & politicians are when it comes to negotiating contracts with private investors… or trade deals, or brexit if it comes to that |
![]() |
| Recent history teaches that the Post Office should be the last company on earth to be anywhere near creating a nationally important IT system. Their technology team have been useless for decades. |
On top of the database they have provided an interface to view the data, interfaces for towns and cities to keep the data up-to-date, free APIs to search addresses and performing geocoding or reverse geocoding (https://adresse.data.gouv.fr/api-doc/adresse) and the data is openly licensed and available to download.
Feeding the BAN has been enforced by law, localities are required to put together and upload their "Base Adresse Locale" (Local Address Database)
The original data was obtained from multiple sources, including "La Poste", the French Royal Mail equivalent, and OpenStreetMap !