Re: [Talk-GB] UPRN Locations Map

2020-09-26 Thread Nick
That is a good point and if the councils agree to publish under OGL, 
that would be ideal. Perhaps need to consider what data should be 
requested as a standard submission? For example, apart from the UPRN 
related data (i.e. whether parent/child, historic, provisional) the 
request could perhaps justifiably ask for a list of council land and 
property with addresses?


On 26/09/2020 14:27, Lester Caine wrote:

On 26/09/2020 13:46, David Woolley wrote:
OS are in a funny position, in that they are in the public sector, 
but are expected to be self funding. To the extent that they succeed 
in the latter, they don't owe a duty to the taxpayer.


But since the vast majority of the UPRN data is actually collected and 
managed by the relevant councils, the question is do they have the 
right to restrict access when it is council taxes that pay for the 
management of that data and not OS! SHOULD we perhaps be asking the 
various councils for direct access to the raw data under the open data 
umbrella?




___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-09-26 Thread Lester Caine

On 26/09/2020 13:46, David Woolley wrote:
OS are in a funny position, in that they are in the public sector, but 
are expected to be self funding.  To the extent that they succeed in the 
latter, they don't owe a duty to the taxpayer.


But since the vast majority of the UPRN data is actually collected and 
managed by the relevant councils, the question is do they have the right 
to restrict access when it is council taxes that pay for the management 
of that data and not OS! SHOULD we perhaps be asking the various 
councils for direct access to the raw data under the open data umbrella?


--
Lester Caine - G8HFL
-
Contact - https://lsces.uk/wiki/Contact
L.S.Caine Electronic Services - https://lsces.uk
Model Engineers Digital Workshop - https://medw.uk
Rainbow Digital Media - https://rainbowdigitalmedia.uk

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-09-26 Thread David Woolley

On 26/09/2020 13:06, Russ Garrett wrote:

There is no legal obligation for FoI responses to be openly licensed.
The point of FoI is to make information available for inspection, but
not (necessarily) for reuse.


To expand on that.

Larger UK companies tend to be very intellectual property based, so 
making information freely available is never going to be a government 
objective.


The actual objective will be more towards open government; ensuring that 
decisions, and the information behind them are open to scrutiny.  A 
secondary purpose is probably to try to ensure that the taxpayers have 
the results of work paid for from their taxes.


OS are in a funny position, in that they are in the public sector, but 
are expected to be self funding.  To the extent that they succeed in the 
latter, they don't owe a duty to the taxpayer.


Although FoI is often used as a tactic for obtaining information for 
republication, as the response points out, that republication isn't 
actually authorised by the FoIA; the information is provided for the 
personal use of the requestor.


___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-09-26 Thread Edward Bainton
Are there grounds to appeal that decision?

I don't know for sure, but I would have thought the point of FOI is to make
info generally accessible.

If payment allows you to do nothing useful with the data because it's
wrapped in restrictive licence conditions (which I'm sure it would be),
then it's not "accessible" in the relevant sense.

On Sat, 26 Sep 2020, 11:29 Nick,  wrote:

> The update on the FOIA request
> https://www.whatdotheyknow.com/request/lists_of_historic_and_parent_upr
> is worth a read!! Makes you wonder at the value of releasing open data that
> has limited value to the public?
> On 01/08/2020 20:24, Nick wrote:
>
> As a follow up, Robert Whittaker also submitted an FOI asking for "... a
> list of all UPRNs that are classified as 'historic', and a separate list of
> all those classified as a 'parent' ". the logicto me was that this
> would help users of Open Data to then filter these out. The response that
> this was "exempt from disclosure under section 21 of the FOIA" - if you
> are interested follow the link to
> https://www.whatdotheyknow.com/request/lists_of_historic_and_parent_upr
>
> I was also interested regarding the details of the batch allocation to
> each custodian. So apart from the commercial value, this is unlikely to be
> published as apparently this might be misleading due to the randomness of
> the data and likely to be out of date quickly.
>
> So much for the potential for collaboration with the various authorities.
> On 06/07/2020 15:10, Nick wrote:
>
> Hi Jez
>
> To clarify, what I did was to find a 'suspicious' UPRN (two pins on one
> building with different address details). I then looked up the address on
> an online system (e.g. OneScotlandGazetteer or the local authority online
> Planning system) to check the details (UPRN and address). That allowed me
> to have details, which in this instance I then checked property sites (e.g.
> ESPC) to verify the 'likely' error.
>
> If you want more details of the example, let me know and I can put a bit
> more detail together.
>
> Cheers
>
> Nick
> On 06/07/2020 12:34, Jez Nicholson wrote:
>
> Sorry, i mean 'findmyaddress'.
>
> Also, from this Twitter thread
> https://twitter.com/jnicho02/status/1279821108783579139?s=20 I note that
> some streets have a UPRN. Existing services filter them out.
>
> On Mon, 6 Jul 2020, 12:29 Jez Nicholson,  wrote:
>
>> Do you mean that you looked up the UPRN on findmystreet and it's
>> supposedly in a different location to the latlon in the file?
>>
>> On Mon, 6 Jul 2020, 12:26 Nick,  wrote:
>>
>>> So I have just started with my crude system and already found one UPRN
>>> that looks as if it is in the wrong location (wrong postcode 6BT > 6ST ~
>>> and wrong county). If I am correct, then this demonstrates the value of
>>> opening up data to more 'eyes'. Not sure how we could collate all lists
>>> of anomalies to demonstrate this to government.
>>>
>>> On 06/07/2020 12:09, Nick wrote:
>>> > I went for the crude approach as my computer is not that powerful, so
>>> > I split the CSV into chunks and imported batches into QGIS with
>>> > county/postcode boundaries as my interest is trying to understand how
>>> > the UPRNs have been batched. Not elegant but means that I now can
>>> > focus on our area and identify those UPRNs that are most useful to me
>>> > for plotting missing rural properties. I can then write a script to
>>> > only give me those UPRNs of interest. As I say, crude but useful to me
>>> > as I can now start to match addresses to UPRN when I add properties.
>>> >
>>> > On 05/07/2020 20:56, Kai Michael Poppe - OSM wrote:
>>> >> On 05.07.2020 18:45, Kai Michael Poppe - OSM wrote:
>>> >>> On 05.07.2020 17:51, Andy Mabbett wrote:
>>>  Naive question - can that be added as a layer in JOSM? If so, how?
>>> >>> I'll have to check whether I can manage that anyway with the new
>>> server
>>> >>> now. Will come back to this.
>>> >> Meh. 3 hours in, every possible lead I had didn't bring me closer to
>>> >> setting up the UPRN data in the same way.
>>> >>
>>> >> Having 6 GiB of GeoPackage or 2 GiB of MySQL data doesn't make working
>>> >> with the data any easier.
>>> >>
>>> >> I will look out for help from the GeoServer people during the week,
>>> >> watch this space :)
>>> >>
>>> >> K
>>> >>
>>> >> ___
>>> >> Talk-GB mailing list
>>> >> Talk-GB@openstreetmap.org
>>> >> https://lists.openstreetmap.org/listinfo/talk-gb
>>> >
>>> > ___
>>> > Talk-GB mailing list
>>> > Talk-GB@openstreetmap.org
>>> > https://lists.openstreetmap.org/listinfo/talk-gb
>>>
>>> ___
>>> Talk-GB mailing list
>>> Talk-GB@openstreetmap.org
>>> https://lists.openstreetmap.org/listinfo/talk-gb
>>>
>>
> ___
> Talk-GB mailing 
> listTalk-GB@openstreetmap.orghttps://lists.openstreetmap.org/listinfo/talk-gb
>
>
> 

Re: [Talk-GB] UPRN Locations Map

2020-09-26 Thread Nick
The update on the FOIA request 
https://www.whatdotheyknow.com/request/lists_of_historic_and_parent_upr 
is worth a read!! Makes you wonder at the value of releasing open data 
that has limited value to the public?


On 01/08/2020 20:24, Nick wrote:


As a follow up, Robert Whittaker also submitted an FOI asking for "... 
a list of all UPRNs that are classified as 'historic', and a separate 
list of all those classified as a 'parent' ". the logicto me was 
that this would help users of Open Data to then filter these out. The 
response that this was "exempt from disclosure under section 21 of the 
FOIA" - if you are interested follow the link to 
https://www.whatdotheyknow.com/request/lists_of_historic_and_parent_upr


I was also interested regarding the details of the batch allocation to 
each custodian. So apart from the commercial value, this is unlikely 
to be published as apparently this might be misleading due to the 
randomness of the data and likely to be out of date quickly.


So much for the potential for collaboration with the various authorities.

On 06/07/2020 15:10, Nick wrote:


Hi Jez

To clarify, what I did was to find a 'suspicious' UPRN (two pins on 
one building with different address details). I then looked up the 
address on an online system (e.g. OneScotlandGazetteer or the local 
authority online Planning system) to check the details (UPRN and 
address). That allowed me to have details, which in this instance I 
then checked property sites (e.g. ESPC) to verify the 'likely' error.


If you want more details of the example, let me know and I can put a 
bit more detail together.


Cheers

Nick

On 06/07/2020 12:34, Jez Nicholson wrote:

Sorry, i mean 'findmyaddress'.

Also, from this Twitter thread 
https://twitter.com/jnicho02/status/1279821108783579139?s=20 I note 
that some streets have a UPRN. Existing services filter them out.


On Mon, 6 Jul 2020, 12:29 Jez Nicholson, > wrote:


Do you mean that you looked up the UPRN on findmystreet and it's
supposedly in a different location to the latlon in the file?

On Mon, 6 Jul 2020, 12:26 Nick, mailto:n...@foresters.org>> wrote:

So I have just started with my crude system and already
found one UPRN
that looks as if it is in the wrong location (wrong postcode
6BT > 6ST ~
and wrong county). If I am correct, then this demonstrates
the value of
opening up data to more 'eyes'. Not sure how we could
collate all lists
of anomalies to demonstrate this to government.

On 06/07/2020 12:09, Nick wrote:
> I went for the crude approach as my computer is not that
powerful, so
> I split the CSV into chunks and imported batches into QGIS
with
> county/postcode boundaries as my interest is trying to
understand how
> the UPRNs have been batched. Not elegant but means that I
now can
> focus on our area and identify those UPRNs that are most
useful to me
> for plotting missing rural properties. I can then write a
script to
> only give me those UPRNs of interest. As I say, crude but
useful to me
> as I can now start to match addresses to UPRN when I add
properties.
>
> On 05/07/2020 20:56, Kai Michael Poppe - OSM wrote:
>> On 05.07.2020 18:45, Kai Michael Poppe - OSM wrote:
>>> On 05.07.2020 17:51, Andy Mabbett wrote:
 Naive question - can that be added as a layer in JOSM?
If so, how?
>>> I'll have to check whether I can manage that anyway with
the new server
>>> now. Will come back to this.
>> Meh. 3 hours in, every possible lead I had didn't bring
me closer to
>> setting up the UPRN data in the same way.
>>
>> Having 6 GiB of GeoPackage or 2 GiB of MySQL data doesn't
make working
>> with the data any easier.
>>
>> I will look out for help from the GeoServer people during
the week,
>> watch this space :)
>>
>> K
>>
>> ___
>> Talk-GB mailing list
>> Talk-GB@openstreetmap.org 
>> https://lists.openstreetmap.org/listinfo/talk-gb
>
> ___
> Talk-GB mailing list
> Talk-GB@openstreetmap.org 
> https://lists.openstreetmap.org/listinfo/talk-gb

___
Talk-GB mailing list
Talk-GB@openstreetmap.org 
https://lists.openstreetmap.org/listinfo/talk-gb



___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb



Re: [Talk-GB] UPRN Locations Map

2020-08-02 Thread Mark Goodge



On 02/08/2020 11:58, Jez Nicholson wrote:
My initial thought was also "conspiracy!". Licence problem is more 
likely, or perhaps they were concerned that someone might poll the URL 
with every available UPRN.


I'm certain that it's been done to prevent people using the EA site as a 
means of looking up an address from a UPRN. That's the only plausible 
explanation for a change which both makes the site more complex from an 
operator point of view (instead of a single database lookup, it now 
needs to do several to identify the property from the postcode and 
sequence ID) and less useful from a user perspective (because you can no 
longer bookmark and share a link to a specific property).


If it is a licence issue, then that's going to have ramifications beyond 
the EA. A lot of local authorities use the UPRN in the URL for 
property-related information. For example, if you live in Cambridge, you 
can check when your bins will be emptied by appending the UPRN to the page:


https://www.cambridge.gov.uk/check-when-your-bin-will-be-emptied#id=24173390

and if you live in Worcestershire, you can check lots of useful stuff 
about your property:


http://e-services.worcestershire.gov.uk/MyLocalArea/MyLocalAreaResults.aspx?uprn=100120673306

It seems to me that this is precisely how the UPRN should be used by 
government and other organisations. To quote Matt Hancock from when he 
was the secretary of state for DCMS:


"The UPRN is the jewel at the heart of the addressing system. It links 
address data across a diverse range of systems and services facilitating 
greater accuracy and immediate data sharing"


and the government's own statement on open UPRNs states that

"Users need property and street information with identifiers that remain 
the same over time and are easy to exchange between systems."


and

"Systems, services and applications that store or publish data sets 
containing property and street information must use the UPRN and USRN 
identifiers."


https://www.gov.uk/government/publications/open-standards-for-government/identifying-property-and-street-information

So it seems to me that there should be no licensing issues with using 
the UPRN as a unique identifier in a public URL. If anything, the 
requirement to use UPRNs in any published dataset seems to pretty much 
make it the simplest means of compliance.


(I appreciate that this is going a bit off topic for OSM, so I think 
I'll leave it there unless there's anything else directly 
mapping-related, but it's worth noting that this change has already been 
mentioned on social media and I suspect it's an issue which will gain 
more traction over time).


Mark

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-08-02 Thread Nick

Hi Jez

You can limit the number of requests to a specific URL (or set of URLs) 
by IP address - so polling "every available UPRN" would not be an issue 
(e.g. can limit the number of requests from a given IP over a given time 
period).


Cheers

Nick

On 02/08/2020 11:58, Jez Nicholson wrote:

My initial thought was also "conspiracy!". Licence problem is more 
likely, or perhaps they were concerned that someone might poll the URL 
with every available UPRN.


On Sun, 2 Aug 2020, 11:38 Nick, > wrote:

I have no problem with licencing but the UPRN and related data is
managed by Authority custodians - do they not retain ownership of that 
data?


If the authorities sell it to OS, then should this be raised with The Rt
Hon Alok Sharma MP (he owns 100% of the shares of OS)?

N.B. there are some aspects to address data that is subject to other IP
rights but the remainder. is surely of public interest and value.

On 02/08/2020 10:34, Russ Garrett wrote:
> On Sun, 2 Aug 2020 at 10:20, Andy Mabbett > wrote:

>> Do you have a plausible hypothesis to explain the removal of UPRNs
>> from the flood warning pages, that also gives us a reason to trust the
>> organisation that enacted that change?
> It's almost certainly because some lawyer or other spotted that it's a
> violation of the PSGA (formerly PSMA) license under which the
> AddressBase data is made available to the Environment Agency.
>
> 
https://www.ordnancesurvey.co.uk/documents/licensing/psga-member-licence.pdf

>
> There's no conspiracy here beyond OS zealously protecting its data, as
> it always has done.
>

___
Talk-GB mailing list
Talk-GB@openstreetmap.org 
https://lists.openstreetmap.org/listinfo/t 



___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-08-02 Thread Andy Mabbett
On Sun, 2 Aug 2020 at 11:58, Jez Nicholson  wrote:

>>> the Environment Agency flood risk website no longer
>>> allows you to link directly to a property by UPRN

> perhaps they were concerned that someone might poll the URL with every 
> available UPRN.

If that were the case, I'm confident the government web team have the
knowledge and wherewithal to apply rate limiting.

-- 
Andy Mabbett
@pigsonthewing
http://pigsonthewing.org.uk

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-08-02 Thread Jez Nicholson
My initial thought was also "conspiracy!". Licence problem is more likely,
or perhaps they were concerned that someone might poll the URL with every
available UPRN.

On Sun, 2 Aug 2020, 11:38 Nick,  wrote:

> I have no problem with licencing but the UPRN and related data is
> managed by Authority custodians - do they not retain ownership of that
> data?
>
> If the authorities sell it to OS, then should this be raised with The Rt
> Hon Alok Sharma MP (he owns 100% of the shares of OS)?
>
> N.B. there are some aspects to address data that is subject to other IP
> rights but the remainder. is surely of public interest and value.
>
> On 02/08/2020 10:34, Russ Garrett wrote:
> > On Sun, 2 Aug 2020 at 10:20, Andy Mabbett 
> wrote:
> >> Do you have a plausible hypothesis to explain the removal of UPRNs
> >> from the flood warning pages, that also gives us a reason to trust the
> >> organisation that enacted that change?
> > It's almost certainly because some lawyer or other spotted that it's a
> > violation of the PSGA (formerly PSMA) license under which the
> > AddressBase data is made available to the Environment Agency.
> >
> >
> https://www.ordnancesurvey.co.uk/documents/licensing/psga-member-licence.pdf
> >
> > There's no conspiracy here beyond OS zealously protecting its data, as
> > it always has done.
> >
>
> ___
> Talk-GB mailing list
> Talk-GB@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-gb
>
___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-08-02 Thread Nick
I have no problem with licencing but the UPRN and related data is 
managed by Authority custodians - do they not retain ownership of that data?


If the authorities sell it to OS, then should this be raised with The Rt 
Hon Alok Sharma MP (he owns 100% of the shares of OS)?


N.B. there are some aspects to address data that is subject to other IP 
rights but the remainder. is surely of public interest and value.


On 02/08/2020 10:34, Russ Garrett wrote:

On Sun, 2 Aug 2020 at 10:20, Andy Mabbett  wrote:

Do you have a plausible hypothesis to explain the removal of UPRNs
from the flood warning pages, that also gives us a reason to trust the
organisation that enacted that change?

It's almost certainly because some lawyer or other spotted that it's a
violation of the PSGA (formerly PSMA) license under which the
AddressBase data is made available to the Environment Agency.

https://www.ordnancesurvey.co.uk/documents/licensing/psga-member-licence.pdf

There's no conspiracy here beyond OS zealously protecting its data, as
it always has done.



___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-08-02 Thread Russ Garrett
On Sun, 2 Aug 2020 at 10:20, Andy Mabbett  wrote:
> Do you have a plausible hypothesis to explain the removal of UPRNs
> from the flood warning pages, that also gives us a reason to trust the
> organisation that enacted that change?

It's almost certainly because some lawyer or other spotted that it's a
violation of the PSGA (formerly PSMA) license under which the
AddressBase data is made available to the Environment Agency.

https://www.ordnancesurvey.co.uk/documents/licensing/psga-member-licence.pdf

There's no conspiracy here beyond OS zealously protecting its data, as
it always has done.

-- 
Russ Garrett
r...@garrett.co.uk

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-08-02 Thread Andy Mabbett
On Sun, 2 Aug 2020 at 09:41, Nick  wrote:

> On 01/08/2020 21:19, Mark Goodge wrote:

> > I'm pretty certain this is deliberate, in order to stop people using
> > their site as a way to look up addresses from a UPRN. And I suspect
> > it's part of the same attempts by GeoPlace to deliberately minimise
> > the utility of the Open UPRN database.

> the current situation regarding openness leads
> to speculation and as Mark so clearly states to "deliberately minimise
> the utility of the Open UPRN database" - the risk is that this sort of
> speculation leads to a lack of trust

Do you have a plausible hypothesis to explain the removal of UPRNs
from the flood warning pages, that also gives us a reason to trust the
organisation that enacted that change?

-- 
Andy Mabbett
@pigsonthewing
http://pigsonthewing.org.uk

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-08-02 Thread Nick
Personally, I don't think that classifying UPRNs (e.g. historic, parent, 
non-addressable etc.) nor publishing dynamically the allocations to the 
custodians of batches of UPRNs would detract from the commercial value 
derived by Ordnance Survey (OS). I fully understand that as a limited 
company, OS is perhaps less motivated to collaborate with the public. 
However, public bodies such as the Environment Agency surely have a 
broader responsibility to the public?


Why I get on my high horse about this is the knowledge that UPRNs and 
related data have errors but perhaps even more tragically, the lack of 
openness can lead to direct impact to people's lives. I also realise 
that the OSM Foundation is a non-profit organisation whose purpose is to 
support the OSM project - my reading is that this is technical rather 
than political. I also re-read Owen Boswarva's blog 
https://www.owenboswarva.com/blog/post-addr1.htm and end up feeling that 
the publishing of Open Data is a bit like the comment "When information 
is missing, we speculate about what the government might be hiding, or 
fill in the gaps with anecdotes." 
[https://www.theguardian.com/commentisfree/2020/apr/02/government-publish-data-coronavirus-deaths]


I therefore believe that the current situation regarding openness leads 
to speculation and as Mark so clearly states to "deliberately minimise 
the utility of the Open UPRN database" - the risk is that this sort of 
speculation leads to a lack of trust


On 01/08/2020 21:19, Mark Goodge wrote:



On 01/08/2020 20:24, Nick wrote:
As a follow up, Robert Whittaker also submitted an FOI asking for 
"... a list of all UPRNs that are classified as 'historic', and a 
separate list of all those classified as a 'parent' ". the 
logicto me was that this would help users of Open Data to then filter 
these out. The response that this was "exempt from disclosure under 
section 21 of the FOIA" - if you are interested follow the link to 
https://www.whatdotheyknow.com/request/lists_of_historic_and_parent_upr


In another move, the Environment Agency flood risk website no longer 
allows you to link directly to a property by UPRN. You used to be able 
to construct a link in this format:


https://flood-warning-information.service.gov.uk/long-term-flood-risk/risk?address=[uprn] 



But that no longer works. Now, you have to search by postcode, and 
when you select an address the site then sets a cookie which 
determines which property details you will be shown. And, checking the 
source of the postcode page, it no longer has the UPRN as a variable 
for each property. Instead, it's a simple sequential number. For 
example, if there are ten properties in a postcode, then the variables 
will be numbered 0 to 9.


I'm pretty certain this is deliberate, in order to stop people using 
their site as a way to look up addresses from a UPRN. And I suspect 
it's part of the same attempts by GeoPlace to deliberately minimise 
the utility of the Open UPRN database.


Mark

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-08-01 Thread Mark Goodge



On 01/08/2020 20:24, Nick wrote:
As a follow up, Robert Whittaker also submitted an FOI asking for "... a 
list of all UPRNs that are classified as 'historic', and a separate list 
of all those classified as a 'parent' ". the logicto me was that 
this would help users of Open Data to then filter these out. The 
response that this was "exempt from disclosure under section 21 of the 
FOIA" - if you are interested follow the link to 
https://www.whatdotheyknow.com/request/lists_of_historic_and_parent_upr


In another move, the Environment Agency flood risk website no longer 
allows you to link directly to a property by UPRN. You used to be able 
to construct a link in this format:


https://flood-warning-information.service.gov.uk/long-term-flood-risk/risk?address=[uprn]

But that no longer works. Now, you have to search by postcode, and when 
you select an address the site then sets a cookie which determines which 
property details you will be shown. And, checking the source of the 
postcode page, it no longer has the UPRN as a variable for each 
property. Instead, it's a simple sequential number. For example, if 
there are ten properties in a postcode, then the variables will be 
numbered 0 to 9.


I'm pretty certain this is deliberate, in order to stop people using 
their site as a way to look up addresses from a UPRN. And I suspect it's 
part of the same attempts by GeoPlace to deliberately minimise the 
utility of the Open UPRN database.


Mark

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-08-01 Thread Nick
As a follow up, Robert Whittaker also submitted an FOI asking for "... a 
list of all UPRNs that are classified as 'historic', and a separate list 
of all those classified as a 'parent' ". the logicto me was that 
this would help users of Open Data to then filter these out. The 
response that this was "exempt from disclosure under section 21 of the 
FOIA" - if you are interested follow the link to 
https://www.whatdotheyknow.com/request/lists_of_historic_and_parent_upr


I was also interested regarding the details of the batch allocation to 
each custodian. So apart from the commercial value, this is unlikely to 
be published as apparently this might be misleading due to the 
randomness of the data and likely to be out of date quickly.


So much for the potential for collaboration with the various authorities.

On 06/07/2020 15:10, Nick wrote:


Hi Jez

To clarify, what I did was to find a 'suspicious' UPRN (two pins on 
one building with different address details). I then looked up the 
address on an online system (e.g. OneScotlandGazetteer or the local 
authority online Planning system) to check the details (UPRN and 
address). That allowed me to have details, which in this instance I 
then checked property sites (e.g. ESPC) to verify the 'likely' error.


If you want more details of the example, let me know and I can put a 
bit more detail together.


Cheers

Nick

On 06/07/2020 12:34, Jez Nicholson wrote:

Sorry, i mean 'findmyaddress'.

Also, from this Twitter thread 
https://twitter.com/jnicho02/status/1279821108783579139?s=20 I note 
that some streets have a UPRN. Existing services filter them out.


On Mon, 6 Jul 2020, 12:29 Jez Nicholson, > wrote:


Do you mean that you looked up the UPRN on findmystreet and it's
supposedly in a different location to the latlon in the file?

On Mon, 6 Jul 2020, 12:26 Nick, mailto:n...@foresters.org>> wrote:

So I have just started with my crude system and already found
one UPRN
that looks as if it is in the wrong location (wrong postcode
6BT > 6ST ~
and wrong county). If I am correct, then this demonstrates
the value of
opening up data to more 'eyes'. Not sure how we could collate
all lists
of anomalies to demonstrate this to government.

On 06/07/2020 12:09, Nick wrote:
> I went for the crude approach as my computer is not that
powerful, so
> I split the CSV into chunks and imported batches into QGIS
with
> county/postcode boundaries as my interest is trying to
understand how
> the UPRNs have been batched. Not elegant but means that I
now can
> focus on our area and identify those UPRNs that are most
useful to me
> for plotting missing rural properties. I can then write a
script to
> only give me those UPRNs of interest. As I say, crude but
useful to me
> as I can now start to match addresses to UPRN when I add
properties.
>
> On 05/07/2020 20:56, Kai Michael Poppe - OSM wrote:
>> On 05.07.2020 18:45, Kai Michael Poppe - OSM wrote:
>>> On 05.07.2020 17:51, Andy Mabbett wrote:
 Naive question - can that be added as a layer in JOSM?
If so, how?
>>> I'll have to check whether I can manage that anyway with
the new server
>>> now. Will come back to this.
>> Meh. 3 hours in, every possible lead I had didn't bring me
closer to
>> setting up the UPRN data in the same way.
>>
>> Having 6 GiB of GeoPackage or 2 GiB of MySQL data doesn't
make working
>> with the data any easier.
>>
>> I will look out for help from the GeoServer people during
the week,
>> watch this space :)
>>
>> K
>>
>> ___
>> Talk-GB mailing list
>> Talk-GB@openstreetmap.org 
>> https://lists.openstreetmap.org/listinfo/talk-gb
>
> ___
> Talk-GB mailing list
> Talk-GB@openstreetmap.org 
> https://lists.openstreetmap.org/listinfo/talk-gb

___
Talk-GB mailing list
Talk-GB@openstreetmap.org 
https://lists.openstreetmap.org/listinfo/talk-gb



___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb
___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-07-06 Thread Paul via Talk-GB
On Sunday, 5 July 2020 18:42:43 BST Mark Goodge wrote:
> On 05/07/2020 18:35, Robert Skedgell wrote:
> > On 05/07/2020 17:58, Mark Goodge wrote:
> >> Just out of interest, is there any simple way to export data from
> >> GeoPackage (eg, to GML or GeoJSON) via the command line on Linux? I've
> >> tried ogr2ogr, but that doesn't seem to recognise GeoPackage as a
> >> source. I can do it manually by loading it into QGIS desktop and then
> >> exporting it, but I'd prefer something I can automate.
> > 
> > This worked for me to import a copy of the USRN GeoPackage file into my
> > local OSM database:
> > 
> > ogr2ogr -f PGDump -s_srs EPSG:27700 -t_srs EPSG:3857 \
> > osopenusrn_202007.sql osopenusrn_202007.gpkg
> > 
> > Is it possible that your installation of GDAL doesn't include support
> > for the GPKG vector driver?
> 
> Yes, I get the error
> 
> Unable to open datasource `osopenusrn_202007.gpkg' with the following
> drivers
> 
> followed by a list of drivers, and GPGK isn't one of them. But GDAL
> seems to be up to date, so I'm not sure how to add it.
> 
> Mark

You may have been caught by the current heavy development affecting GDAL and 
PROJ  in the spatial field. 

The LTS releases of various linuxes are significantly behind on this, and the 
projects that use GDAL and PROJ as upstream are catching up slowly. There are 
major changes.

My Ubuntu bionic (due for upgrade to Focal shortly) claims to have a current 
GDAL - using an ubuntigis unstable repo, but that's behind as well - I'm on 
GDAL 3.04 while upstream is 3.11.

Paul Bivand




___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-07-06 Thread Mark Goodge



On 05/07/2020 18:42, I wrote:



On 05/07/2020 18:35, Robert Skedgell wrote:


Is it possible that your installation of GDAL doesn't include support
for the GPKG vector driver?


Yes, I get the error

Unable to open datasource `osopenusrn_202007.gpkg' with the following 
drivers


Just as a follow-up note, I tried it with a fresh install of GDAL on a 
different server and it works fine. So there clearly was something odd 
about the version I'd originally used. But that's immaterial now, 
fortunately.


Mark

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] UPRN Locations Map

2020-07-06 Thread ndrw

On 02/07/2020 17:38, Robert Whittaker (OSM lists) wrote:

I'm not completely sure if/how we can best make use of the new OS
OpenData (UPRNs, USRNs and related links) in OpenStreetMap, but as a
first step I've set up a quick slippy map with the UPRN locations
shown:

https://osm.mathmos.net/addresses/uprn/ (zoom in to level 16 to show the data)


I've been reading about the geopackage file format used for encoding 
UPRN and USRN data and played with the databases a bit. Below is a 
summary of what I've learned.


Geopackage files are really sqlite databases with a gpgk extension. The 
extension can be downloaded from 
https://bitbucket.org/luciad/libgpkg/src/default/ and compiled. The 
extension is needed for accessing geometry values (blobs), a similar 
concept to the one used by the mod_spatialite extension but not 
compatible with it.


The gpgk_contents table serves as a main entry point specifying the name 
of the table containing data, last change date, spatial extents along 
with a spatial reference system (here EPSG27700/OSGB1936).


Gpgk_geometry_columns specifies names of the table+column holding 
geometric data, their types, their spatial reference system, z 
(elevation) and m (measure) values. The latter two are not used in these 
files.


Gpkg_spatial_ref_sys provides definitions of WGS84 and OSGB1936 
reference systems, only the latter is used by the data tables.


Gpkg_tile_matrix and gpkg_tile_matrix_set tables are empty, no 
pre-generated tiles.


Tables with names starting with rtree_ are spatial indices for geometric 
data. This is defined by an extension to GeoPackage 
(http://www.geopackage.org/spec120/#extension_rtree) - I haven't tried 
using this feature yet.


1. UPRN file

This file contains UPRNs and their locations (Point) in the 
osopenuprn_address table. In addition to the GEOM field containing point 
coordinates it duplicates the coordinates in separate fields in both 
OSGB1936 and WGS84 formats. So, if necessary, this file can be used 
without the pgkg extension. Unfortunately, despite fancy packaging it is 
still "a proprietary number+coordinates" data format, so, unless there 
are additional open data available specifying the meaning of each UPRN, 
UPRNs are (IMHO) only useful as a reference.


Script for accessing contents of the geopackage file:

#!/bin/sh
sqlite3 -batch -echo osopenuprn_202006.gpkg