On 12/03/2011 11:59, Matthew Somerville wrote:
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.
Thanks, that means I can at least give my MySQL table meaningful column names :-)
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
OK, that looks useful, I will take a look and see what I can dig out. Mark -- http://mark.goodge.co.uk http://www.ratemysupermarket.com _______________________________________________ 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
