urbanrural2007_2008_status¶
null where the 2007-2008 codes are present; otherwise outside_polygons, ambiguous_polygons or po_box
| Table | Type | Nullable | Category | In the CSV export | SQL Server type |
|---|---|---|---|---|---|
history table (postcode_simd_history, SPD) |
string | yes | Urban Rural Classification, placed | yes | nvarchar(200) |
Provenance in the history table (postcode_simd_history, SPD)¶
Where it comes from
| Input | Field | Condition | Reaches the row by |
|---|---|---|---|
SPD/spd_postcodeindex_cut_26_2_csv/SmallUser.csv (pinned, SHA256 fc82f1091ac1…) |
GridReferenceEasting, GridReferenceNorthing |
the life's own grid reference | the row itself |
SPD/spd_postcodeindex_cut_26_2_csv/LargeUser.csv (pinned, SHA256 dcb060cbce01…) |
GridReferenceEasting, GridReferenceNorthing |
the life's own grid reference | the row itself |
spd_user_type, a derived column of the same row |
spd_user_type |
with LinkedSmallUserPostcode, identifies a PO box | the row itself |
SPD/spd_postcodeindex_cut_26_2_csv/LargeUser.csv (pinned, SHA256 dcb060cbce01…) |
LinkedSmallUserPostcode |
NO LINKP marks a PO box, whose grid reference is the sorting office: its codes are cleared and its status is po_box | the row itself |
data.gov.uk/SG_UrbanRural_2007_2008/SG_UrbanRural_2007_2008.shp (pinned, SHA256 305899304c3c…) |
polygon geometry |
the polygon containing the point | the row itself |
data.gov.uk/SG_UrbanRural_2007_2008/SG_UrbanRural_2007_2008.shx (pinned, SHA256 4872b17b3a5e…) |
geometry index |
locates each polygon in the .shp | the row itself |
data.gov.uk/SG_UrbanRural_2007_2008/SG_UrbanRural_2007_2008.prj (pinned, SHA256 d97d27668037…) |
coordinate reference system |
British National Grid, the grid reference's system | the row itself |
Scope: the row itself.
What was done to it: placed. Why the version has no code: outside_polygons (the point is in no polygon), ambiguous_polygons (on an edge between two classes) or po_box (a large user linked NO LINKP); null when it has one. (code: simd_ingest/core/rurality.py: classify, place, attach_rurality, is_po_box)
How it is checked (what each check tests; whether a build passed it is in that build's manifest.json["checks"])
rurality.2007-2008.columns_present: the shapefile carries the declared 6-fold and 8-fold columnsrurality.2007-2008.polygons: the shapefile has the declared number of polygonsrurality.2007-2008.reference_system: the shapefile is in British National Gridrurality.2007-2008.folds_nest: the 6-fold is exactly the official collapse of the 8-foldrurality.points_present: the records to place carry grid referencesreadback.history.rurality_values: every point is placed again from the saved file's grid references and equal
Why: rurality-by-version, nullable-integers-and-never-blank-text, rurality-early-versions-confirmed