urbanrural2007_2008_6fold¶
Scottish Government Urban Rural Classification 2007-2008, 6-fold, placed from this record's own grid reference; null where urbanrural2007_2008_status says why
| Table | Type | Nullable | Category | In the CSV export | SQL Server type |
|---|---|---|---|---|---|
history table (postcode_simd_history, SPD) |
int8 | yes | Urban Rural Classification, placed | yes | tinyint |
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 |
data.gov.uk/SG_UrbanRural_2007_2008/SG_UrbanRural_2007_2008.dbf (pinned, SHA256 f3ae67b9356d…) |
UR6FOLD |
the class of the polygon found | the row itself |
Scope: the row itself.
What was done to it: placed. The class of the polygon containing the life's grid reference, by point in polygon; cleared for a PO box (a large user whose LinkedSmallUserPostcode is NO LINKP). Shares the placement algorithm and its gate; there is no direct comparison with NRS codes for this version. (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