On 11/03/2011 10:14, Mark Goodge wrote:
On http://parlvid.mysociety.org:81/os/ there is a download for the
National Statistics Postcode Database (NSPD) Open dataset. This is a
plain csv file with no header line. Can anyone enlighten me as to what
the columns represent?
The User Guide can be downloaded from:
http://www.ons.gov.uk/about-statistics/geography/products/geog-products-postcode/nspd/
which contains full details in Annex B.
In summary (it's given in a comment in the import code but should really
be somewhere else too, sorry):
Postcode (7), Postcode (8), Postcode (sp), Start date, End date, County,
council, ward, usertype, Easting, Northing, quality, SHA, Pan SHA,
country, GOR, Stats region, Parliamentary constituency, Euro region,
TEC/LEC, Travel to Work area, Primary Care Org, NUTS, 1991 census ED,
1991 census ED, ED indicator, Pre-July 2006 SHA, LEA, Pre 2002 Health
Authority, 1991 ward code, 1991 ward code, 1998 ward code, 2005 stats
ward, OA code, OA indicator, CAS ward, National Park, SOA (Lower),
Datazone, SOA (Middle), Urban/rural (EW), Urban/rural (S), Urban/rural
(NI), Intermediate (S), SOA (NI), OA classification, Pre October 2006 PCO.
Is there a lookup table available to map codes in this dataset to
whatever they mean?
If the areas are ones in mapit (e.g. wards), then you can look them up
there. Other lists of codes can also be found on the ONS site, although
they appear to be the old codes (ONS changed all their codes at the
start of this year) e.g.
http://www.ons.gov.uk/about-statistics/geography/products/geog-products-area/snac/index.html
http://www.ons.gov.uk/about-statistics/geography/products/geog-products-area/names-codes/index.html
http://www.ons.gov.uk/about-statistics/geography/products/geog-products-area/lookups/index.html
It looks like you have to ask for a URL to get the current Code History
Database that has all codes in it. OS have a mapping of some old->new
codes here:
http://www.ordnancesurvey.co.uk/oswebsite/products/boundaryline/techinfo.html
ATB,
Matthew
_______________________________________________
developers-public mailing list
[email protected]
https://secure.mysociety.org/admin/lists/mailman/listinfo/developers-public
Unsubscribe:
https://secure.mysociety.org/admin/lists/mailman/options/developers-public/archive%40mail-archive.com
