<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Hi list,</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Just to give you some sort of local authority perspective on this. UPRNs are assigned to local authority in 'blocks', i.e. we are given a big range of them to use. These are given to us by GeoPlace, who are in charge of coordinating all the changes from local
authorities LLPGs (Local Land and Property Gazetteer) and merging them into a national dataset. There is no hard and fast rule on how UPRNs should be assigned to a property. Generally, when a new development happens they will be assigned sequentially from
the block of UPRNs they have, but not necessarily. When a new property is built it may be in the middle of a bunch of UPRNs that were created years ago, so the sequential numbering goes out of the window.</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
UPRNs are often assigned before a building is built, so it can be very useful for finding plans for new builds. From my experience they are generally placed in the middle of a building footprint from OS MasterMap, but not always as sometimes there is no footprint
available or they have not been recently updated. Same with flats, generally all the individual 'seeds' are plonked on top of each other, but occasionally they are spread out.</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
As for their use, to us they are utterly vital and allow us to link datasets together from different departments and different organisations and know we are looking at the same thing. The opening up of the UPRN should allow better open data sharing, but I haven't
delved into this much yet, its probably going to take time before we see the benefits.</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
For the OSM community, for now the use might be limited to what you've already done, i.e. identifying and verifying buildings, not sure what else you might be able to do beyond that without the actual address information, but I'm always amazed by the community's
ingenuity. </div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
GeoPlace have a decent FAQ section on UPRNs and USRNs - <a href="https://www.geoplace.co.uk/power-of-place/faqs">https://www.geoplace.co.uk/power-of-place/faqs</a> - As well as a limited address/UPRN finder - <a href="https://www.findmyaddress.co.uk/search">https://www.findmyaddress.co.uk/search</a> -
(goes without saying that you shouldn't use data from that address finder in OSM!)</div>
<div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I hope that helps. Admittedly I'm just a developer and not involved in the day to day of UPRN and address creation. Bear in mind that each authority probably has slightly different ways of doing things, so what's true for Dorset might not be true for everyone
else. If you have questions about data in your own area, look up your local District or County Councils LLPG officer and they will probably be able to help.</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thanks,</div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div></div>
<div></div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size: 12pt; font-family: Calibri, Helvetica, sans-serif; color: rgb(0, 0, 0);">
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0"></p>
<p style="text-align: start; font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px; background-color: rgb(255, 255, 255);">
<b><span style="margin: 0px; font-family: Arial, sans-serif; color: black;">Rob Quincey - GIS Developer at Dorset Council</span></b></p>
<div style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0"></div>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0"><br>
</p>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Peter Neale via Talk-GB <talk-gb@openstreetmap.org><br>
<b>Sent:</b> 03 July 2020 09:15<br>
<b>To:</b> talk-gb <talk-gb@openstreetmap.org>; Nick <nick@foresters.org><br>
<b>Subject:</b> Re: [Talk-GB] UPRN Locations Map</font>
<div> </div>
</div>
<div>
<div class="x_ydp13a19995yahoo-style-wrap" style="font-family:times new roman,new york,times,serif; font-size:16px">
<div>
<div dir="ltr">Hi Nick,</div>
<div dir="ltr"><br>
</div>
<div dir="ltr">Thanks for that.</div>
<div dir="ltr"><br>
</div>
<div dir="ltr">I regret that my VBA and Python are about as good as my Swahili and Martian. (i.e. NOT)</div>
<div dir="ltr"><br>
</div>
<div dir="ltr">Many years ago, I did a bit (sic) of coding in Basic, Fortran and Algol (look them up in the history books) and I used Prolog for my AI project in 1984, but since then, I've been gradually relegated to management.</div>
<div dir="ltr"><br>
</div>
<div dir="ltr">However, I am sure that there are others in this community, who will be much better placed than I am to use the code that you have so kindly provided.</div>
<div><br>
</div>
<div class="x_ydp13a19995signature">
<div style="font-family:new times,serif; font-size:16px">
<div>Regards,</div>
<div dir="ltr">Peter</div>
<div dir="ltr"><br>
</div>
</div>
</div>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div id="x_ydpf5385941yahoo_quoted_4042836208" class="x_ydpf5385941yahoo_quoted">
<div style="font-family:'Helvetica Neue',Helvetica,Arial,sans-serif; font-size:13px; color:#26282a">
<div>On Thursday, 2 July 2020, 23:19:06 BST, Nick <nick@foresters.org> wrote: </div>
<div><br>
</div>
<div><br>
</div>
<div>
<div id="x_ydpf5385941yiv9375948325">
<div>
<p>Hi Peter</p>
<p>re: "I am still not clear how best to use the data available" - I have written a simple bit of VBA that enables address data to be retrieved for a given UPRN (I attach the VBA used in a form for Excel) - this only works for Scotland but may be available
elsewhere. Using the concept you can use Python (a friend has done some preliminary work) or similar. This is not elegant but is perhaps a first step in enabling a whole lot of development?<br clear="none">
</p>
<p>Cheers</p>
<p>Nick</p>
<p><br clear="none">
</p>
<div class="x_ydpf5385941yiv9375948325yqt7712791057" id="x_ydpf5385941yiv9375948325yqtfd18833">
<div class="x_ydpf5385941yiv9375948325moz-cite-prefix">On 02/07/2020 18:38, Peter Neale via Talk-GB wrote:<br clear="none">
</div>
<blockquote type="cite"></blockquote>
</div>
</div>
<div class="x_ydpf5385941yiv9375948325yqt7712791057" id="x_ydpf5385941yiv9375948325yqtfd91359">
<div>
<div class="x_ydpf5385941yiv9375948325ydp4750192dyahoo-style-wrap" style="font-family:times new roman,new york,times,serif; font-size:16px">
<div>
<div dir="ltr">Hi Robert,</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">Many thanks for producing that map.</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">I was able to look at my street and see a blue pin in each of the building outlines that I had mapped from aerial imagery, so that gave me a warm, smug feeling :)</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr"><span><span style="color:rgb(0,0,0); font-family:times new roman,new york,times,serif; font-size:16px">I too noticed some not-yet-there properties in a nearby development that had UPRNs assigned - Not a problem really (IMHO). There is also one
allocated to a pond near me; I didn't know that was "addressable"!</span></span><br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">However, I am still not clear how best to use the data available, if you can't use it to look up the address of the property. Similarly, I am not sure how a data consumer could use the data, if we laboriously edited every property in OSM to
include a "ref:GB:UPRN=" tag (or similar; other tags are available.....).</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">Sorry not to be able to contribute something more useful... :(</div>
<div dir="ltr"><br clear="none">
</div>
<div class="x_ydpf5385941yiv9375948325ydp4750192dsignature">
<div style="font-family:new times,serif; font-size:16px">
<div>Regards,</div>
<div dir="ltr">Peter</div>
<div dir="ltr"><br clear="none">
</div>
</div>
</div>
</div>
<div><br clear="none">
</div>
<div><br clear="none">
</div>
</div>
<div class="x_ydpf5385941yiv9375948325ydpa840b070yahoo_quoted" id="x_ydpf5385941yiv9375948325ydpa840b070yahoo_quoted_4551544703">
<div style="font-family:'Helvetica Neue',Helvetica,Arial,sans-serif; font-size:13px; color:#26282a">
<div>On Thursday, 2 July 2020, 17:40:51 BST, Robert Whittaker (OSM lists) <a shape="rect" class="x_ydpf5385941yiv9375948325moz-txt-link-rfc2396E" href="mailto:robert.whittaker+osm@gmail.com" rel="nofollow" target="_blank">
<robert.whittaker+osm@gmail.com></a> wrote: </div>
<div><br clear="none">
</div>
<div><br clear="none">
</div>
<div>
<div dir="ltr">I'm not completely sure if/how we can best make use of the new OS<br clear="none">
</div>
<div dir="ltr">OpenData (UPRNs, USRNs and related links) in OpenStreetMap, but as a<br clear="none">
</div>
<div dir="ltr">first step I've set up a quick slippy map with the UPRN locations<br clear="none">
</div>
<div dir="ltr">shown:<br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr"><a shape="rect" href="https://osm.mathmos.net/addresses/uprn/ " rel="nofollow" target="_blank">https://osm.mathmos.net/addresses/uprn/
</a>(zoom in to level 16 to show the data)<br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">The UPRN dataset literally just contains the UPRN number and its<br clear="none">
</div>
<div dir="ltr">coordinates (both OS National Grid and WGS lat/lon). There are some<br clear="none">
</div>
<div dir="ltr">additional linking datasets that link these ids to other ids (e.g.<br clear="none">
</div>
<div dir="ltr">USRNs, TOIDs). But no address information is available directly. (You<br clear="none">
</div>
<div dir="ltr">may be able to get street names by matching to OS Open Roads via TOIDs<br clear="none">
</div>
<div dir="ltr">though. Coupled with Code-Point Open, you might be able to assign<br clear="none">
</div>
<div dir="ltr">quite a few postcodes in cases where there's only one unit for a whole<br clear="none">
</div>
<div dir="ltr">street.)<br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">The UPRN data has already helped me find a mapping error I made<br clear="none">
</div>
<div dir="ltr">locally though -- it looks like I'd accidentally missed drawing a<br clear="none">
</div>
<div dir="ltr">house outline from aerial imagery, and also classified a large garage<br clear="none">
</div>
<div dir="ltr">a few doors down as a house. The two errors cancelled out when the<br clear="none">
</div>
<div dir="ltr">houses were numbered sequentially, so I didn't notice until now. Today<br clear="none">
</div>
<div dir="ltr">though I spotted a UPRN marker over some blank space on the map, and<br clear="none">
</div>
<div dir="ltr">no marker over the mapped house that's probably a garage.<br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">Now a few initial thoughts on the data that I've explored so far:<br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">I believe that the UPRNs are assigned by local authorities, so<br clear="none">
</div>
<div dir="ltr">conventions may vary from place to place. I don't know who actually<br clear="none">
</div>
<div dir="ltr">assigns the coordinates (authority or OS). Looking at those for rows<br clear="none">
</div>
<div dir="ltr">of houses around me, they don't seem to have been automatically given<br clear="none">
</div>
<div dir="ltr">coordinates from the house footprint, it looks more like someone<br clear="none">
</div>
<div dir="ltr">manually clicking on a map.<br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">The UPRN dataset should include all addressable properties. It is also<br clear="none">
</div>
<div dir="ltr">ahead of reality in some places, as it includes locations for houses<br clear="none">
</div>
<div dir="ltr">on a new development near me that have yet to be built yet. For blocks<br clear="none">
</div>
<div dir="ltr">of apartments/flats, the UPRN nodes may all have the same coordinates<br clear="none">
</div>
<div dir="ltr">or may be displaced from each other, possibly in an artificial manner.<br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">Other objects also appear to have UPRNs. Likely things I've noticed so<br clear="none">
</div>
<div dir="ltr">far include: car parks, post boxes, telephone boxes (even after<br clear="none">
</div>
<div dir="ltr">they've been removed), electricity sub-stations, roads and recorded<br clear="none">
</div>
<div dir="ltr">footpaths (the UPRN locations seem to be at one end of the street, so<br clear="none">
</div>
<div dir="ltr">usually lie at a junction), recreation grounds / play areas,<br clear="none">
</div>
<div dir="ltr">floodlight poles (around sports pitches), and allotments. There's no<br clear="none">
</div>
<div dir="ltr">information about the object type in the UPRN data unfortunately.<br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">Anyway, I hope some of this is useful / interesting. I hope to be on<br clear="none">
</div>
<div dir="ltr">the OSMUK call on Saturday to discuss things further. Best wishes,<br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">Robert.<br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">-- <br clear="none">
</div>
<div dir="ltr">Robert Whittaker<br clear="none">
</div>
<div dir="ltr"><a shape="rect" href="https://osm.mathmos.net/" rel="nofollow" target="_blank">https://osm.mathmos.net/</a><br clear="none">
</div>
<div dir="ltr"><br clear="none">
</div>
<div dir="ltr">_______________________________________________<br clear="none">
</div>
<div dir="ltr">Talk-GB mailing list<br clear="none">
</div>
<div dir="ltr"><a shape="rect" href="mailto:Talk-GB@openstreetmap.org" rel="nofollow" target="_blank">Talk-GB@openstreetmap.org</a><br clear="none">
</div>
<div dir="ltr"><a shape="rect" href="https://lists.openstreetmap.org/listinfo/talk-gb" rel="nofollow" target="_blank">https://lists.openstreetmap.org/listinfo/talk-gb</a><br clear="none">
</div>
</div>
</div>
</div>
<br clear="none">
<fieldset class="x_ydpf5385941yiv9375948325mimeAttachmentHeader"></fieldset>
<pre class="x_ydpf5385941yiv9375948325moz-quote-pre">_______________________________________________
Talk-GB mailing list
<a shape="rect" class="x_ydpf5385941yiv9375948325moz-txt-link-abbreviated" href="mailto:Talk-GB@openstreetmap.org" rel="nofollow" target="_blank">Talk-GB@openstreetmap.org</a>
<a shape="rect" class="x_ydpf5385941yiv9375948325moz-txt-link-freetext" href="https://lists.openstreetmap.org/listinfo/talk-gb" rel="nofollow" target="_blank">https://lists.openstreetmap.org/listinfo/talk-gb</a>
</pre>
</div>
</div>
</div>
<div class="x_ydpf5385941yqt7712791057" id="x_ydpf5385941yqtfd87628">_______________________________________________<br clear="none">
Talk-GB mailing list<br clear="none">
<a shape="rect" href="mailto:Talk-GB@openstreetmap.org" rel="nofollow" target="_blank">Talk-GB@openstreetmap.org</a><br clear="none">
<a shape="rect" href="https://lists.openstreetmap.org/listinfo/talk-gb" rel="nofollow" target="_blank">https://lists.openstreetmap.org/listinfo/talk-gb</a><br clear="none">
</div>
</div>
</div>
</div>
</div>
This e-mail and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed. It may contain unclassified but sensitive or protectively marked material and should be handled accordingly. Unless you are
the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All traffic may be subject to recording and/or
monitoring in accordance with relevant legislation. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Dorset Council. Dorset Council does not accept
service of documents by fax or other electronic means. Virus checking: Whilst all reasonable steps have been taken to ensure that this electronic communication and its attachments whether encoded, encrypted or otherwise supplied are free from computer viruses,
Dorset Council accepts no liability in respect of any loss, cost, damage or expense suffered as a result of accessing this message or any of its attachments. For information on how Dorset Council processes your information, please see www.dorsetcouncil.gov.uk/416433
</body>
</html>