joeldnOct 25

This week I released a package which uses the ASSIGN API in notebooks and pipelines to standardise, quality assure, and de-identify UK address data. Mainly aimed at public servants, it can be used by commercial operators with delegated public sector geospatial mapping agreement cover. #uprn

https://joeldn.srht.site/assign-uprn

joeldnJun 9, 2025
map of #UPRN in Britain, https://osdatahub.os.uk/downloads/open/OpenUPRN - would be nice to have syntax highlighting in mastodon
```python
df = pd.read_csv('osopenuprn_202505.csv')
cvs = ds.Canvas(plot_width=500, plot_height=800)
agg = cvs.points(df, 'LONGITUDE', 'LATITUDE')
img = ds.tf.shade(agg, cmap=colorcet.fire, how='log')
```
joeldnJun 5, 2025
#duckdb makes sideways histograms with monospace fonts! In this example it happily visualised 41.2 million #UPRN values from ordnance survey open data https://osdatahub.os.uk/downloads/open/OpenUPRN taken together, the centre of gravity in the GB property ecosystem seems to be Metroland and the M1 / A1 / M40 motorway corridors into NW London. This band of longitude is shared with sizeable encampments in the Humber estuary, and latitude with Swansea, Cardiff, Oxford, NE London, and Essex sprawl.
joeldnJun 1, 2025

📍place-encoder - some notes and a toy mnemonic encoder/decoder made following geoplace conference ; where efforts to drive data standards such as #UPRN are galvanised.

https://joeldn.srht.site/site/post/mnemonic-place-encoder.html

📍 mnemonic-place-encoder

Show threadSK53Sep 11, 2023

@jez Ah, never mind. @twitter.com@owenboswarva has plenty of other #UPRN stories.

Surely makes sense to link them to UPRNs, but I do suspect that with new builds UPRNs are confusable too (e.g., the Mill Hill development where all the postcodes were changed after people had moved in).
Presume the DB is IMS as that's what British Gas used back in the 1990s.

We were due to get meters replaced at end of August, but too far apart for a regular installation: obviously no info on meter location.

SK53Sep 11, 2023

The wonder of Unique Property Reference Numbers (#UPRN): https://www.theguardian.com/money/2023/sep/11/the-great-meter-mix-up-are-you-paying-for-your-neighbours-gas

Not exactly working as intended.

The great meter mix-up: are you paying for your neighbour’s gas?

Database errors mean customers have been getting huge demands from firms that don’t even supply them

The Guardian
SK53Sep 6, 2023

Looking at ONS UPRN assignment to postcodes in inner city Coventry (postcode sector CV2 4) and noticing a few errors anomalies:

1. a few UPRNs well outside the basic area of the sector (all appear to be historical)
2. misplaced UPRNs, such as this one for 44 Roman Road (UPRN 100070694394)

#UPRN #OfficeofNationalStatistics #PostCodes

Dragons8mycatSep 6, 2023
Interesting happenings with the #VOA and the humble #UPRN
https://www.ukauthority.com/articles/standardisation-and-uprns-in-property-valuations/
Standardisation and UPRNs in property valuations | UKAuthority

UKAuthority