[Talk-GB] Quarterly Project: Addresses and Postcodes
Robert Whittaker (OSM lists)
robert.whittaker+osm at gmail.com
Thu Oct 19 18:46:04 UTC 2017
On 19 October 2017 at 13:38, Ed Loach <edloach at gmail.com> wrote:
>> For anyone else reading, we're talking about
> When I drilled down a bit I found an NG column with a * in it, e.g.
> In this instance I think the 4 CO13 3 codes are PO Boxes but fall just below your threshold of 5 but am wondering if NG is non-geographic?
Yes, "NG" is non-geographic. Royal Mail publish a list of
non-geographic sectors every six months, which I've parsed and
imported into my tool. I've now added a note under the table to
You would have been right about the 5 threshold, but actually there
are other units in different sectors that are located at the same
delivery office, which would have pushed it over. The problem was
actually a bug in my code, that meant that sectors with no units under
the threshold didn't get reported properly. That should now be fixed.
(Although I should probably look to make it automatically discount all
postcodes in sectors flagged as Non-Geographic, rather than using the
threshold for them -- but that will need a bit more SQL magic to
More information about the Talk-GB