This might sound even worse to you - but what are you thoughts on adding the street UPRN to the nearest node on the street, and the street way? That would allow for the alignment benefits of the nodes (they tend to be well aligned at junctions) and add the UPRN to the related way itself.

I've come across the "all nodes on a road" approach when looking at looking at UPRNs that were in OSM multiple times - I've left them as they were, though I agree that's an odd approach.

I don't have hugely strong feelings between the two other approaches - the wiki seems to suggest both possibilities - "UPRNs being on multiple sections of the road OR at a single point on the road.". That said, in some cases (at junctions) it isn't always clear which road is linked to which UPRN without checking against the linked USRN.

Hi, there seem to be a few different approaches to street UPRNs (adding them to the way, to all the nodes in the way, or to a single node). I've tried to add them to a node close to the location of the UPRN (normally the end of the road, but occasionally in the middle). This probably requires some more discussion elsewhere, but my thinking was this was the simplest way of getting them in, then USRNs might get added at some later point to the way itself (or maybe a relation of ways.

This really interesting (if you can excuse my enthusiasm). It seems that that UPRN was at the end of the road, but has then been moved. I added it manually when it was at the junction between "Huntington Road" and "Brandsby Grove". It seems to be located there now, in the latest data I have. I don't record changes between the releases, and only the latest version is online, so I can't look back to see this over time. I notice that some sites show it at the other end of the road, showing a snapshot at some point.

I've seen UPRNs migrate as buildings are constructed, and the UPRN moved to the exact location, but not UPRNs that appear to relate to roads move.

I've now updated the casing in Bexhill and the database for any other updates.

Good spot, the PROPPER() function in Excel isn't quite cleaver enough to that. I'll update my database to correctly case prepositions, and separately, update the existing ones.

That's a good spot, I'd not quite understood that the substreet and parentstreet replaced street. I'll avoid adding streets where they are present.

I do mean to document the process, and turn the tools I have into a JOSM plugin - so that other people can do the same. I've not got there yet though.

Hi, they're sourced from the ONS Open Data and OS Open Data (with additional safety checks, and manual adjustments). The OS data allows a UPRN to be found in areas with well aligned buildings, and the ONS data then provides a postcode for these. Both are licensed under the Open Government Licence (OGL).

Hi, the names were added in a much earlier changes by someone else about 15 years ago, so I'm not sure how they were arrived at, but thanks for fixing them.

Hi Kits,

I've found that UPRNs do sometimes get assigned to parcels of land (especially council owned land, but it seems to depend on the council), but in this case I think you're right and the UPRN is for the bus stop. I've added the bus stop in, moved the UPRN to it, and looked over some other ones in the area around it.

I hadn't intended to create any new residential areas - I think I've managed to trigger a bug in a JOSM plugin that's modified them when splitting buildings (it crashed a couple of times whilst editing). Thanks for putting it right.

Good spot - that was a copy and paste error. It's now fixed.

I have a few tools to help adding UPRNs (which I do mean to make generally available at some point - if my small server can cope). I start with a custom tile layer layer in JOSM with UPRN points to check they match up to buildings, then a script in JOSM to conservatively match items in the current viewport to UPRNs. I have a mapcss theme to show items with a UPRN to see the impact. I then add less obvious items (mostly street UPRNs and UPRNs linked to large areas) by hand. I then check back to the original tile layer, to see what may be missing.

Thanks Paul - that was a good spot. I've seen rows of houses that were demolished years ago, and new ones built in their place, with both sets of UPRNs still on Open UPRN. I'm not sure if they are retained indefinitely, but it does seem like they may be.

Thank you - I think you're right - that was the tag combination I was looking for. I've updated the tagging.

Not quite sure what happened there - but that was a good spot. Thank you for fixing them.

Good spot - that's now fixed

Hi,

Water pipelines tend to have the least visible infrastructure, and don't have something at every crossing, but things to look out for would be manholes and their concrete surrounds at the side of the road (or in a nearby field). There may be short concrete marker posts, which will indicate the details of the pipe, but they tend to only be around manholes and not at each road crossing.

Phil

I think you’re right about the imagery offset. I’ve moved a few points in the immediate vicinity that were aligned with no offset to Bing, including the service road you added opposite, so that they are all offset, rather than being half and half. Hopefully it is now consistent again.