simd2006_access_domain_rank¶
Scottish Government SIMD 2006 access to services domain rank, unweighted, 1 = most deprived; copied exactly as published, may end in .5
What the access domain measures (indicators in the Scottish Government's SIMD 2020v2 glossary; earlier editions' indicators differ in detail):
- Average drive time to a petrol station in minutes (
GAccPetrol, time (minutes); SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition) - Average drive time to a GP surgery in minutes (
GAccDTGP, time (minutes); SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition) - Average drive time to a post office in minutes (
GAccDTPost, time (minutes); SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition) - Average drive time to a primary school in minutes (
GAccDTPsch, time (minutes); SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition) - Average drive time to a secondary school in minutes (
GAccDTSsch, time (minutes); SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition) - Average drive time to a retail centre in minutes (
GAccDTRet, time (minutes); SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition) - Public transport travel time to a GP surgery in minutes (
GAccPTGP, time (minutes); SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition) - Public transport travel time to a post office in minutes (
GAccPTPost, time (minutes); SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition) - Public transport travel time to a retail centre in minutes (
GAccPTRet, time (minutes); SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition) - Percentage of premises without access to superfast broadband (at least 30Mb/s download speed) (
GAccBrdbnd, percentage; SIMD 2020v2 glossary: a 2020v2 example, not verified for this edition)
| Table | Type | Nullable | Category | In the CSV export | SQL Server type |
|---|---|---|---|---|---|
history table (postcode_simd_history, SPD) |
rank | no | Scottish Government SIMD | yes | decimal(6,1) |
main table (postcode_simd, SSPL) |
rank | no | Scottish Government SIMD | yes | decimal(6,1) |
Provenance (the same in both tables)¶
Each table runs its own copy of the table-level checks, named .history. and .main..
Where it comes from
| Input | Field | Condition | Reaches the row by |
|---|---|---|---|
data.gov.uk/SG_SIMD_2006/SG_SIMD_2006.dbf (pinned, SHA256 2730fae78d66…) |
gaccrank |
DataZone2001Code = datazone |
Scope: the row itself.
What was done to it: copied. The domain rank copied exactly as published; it may end in .5 where zones tie. (code: simd_ingest/core/govscot.py: read_gov_edition)
How it is checked (what each check tests; whether a build passed it is in that build's manifest.json["checks"])
source.hash.data.gov.uk/SG_SIMD_2006/SG_SIMD_2006.dbf: the pinned file's SHA256 equals the registry's: the bytes are exactly the ones reviewedgovscot.2006.columns_present: every declared shapefile column is in the filegovscot.2006.key_unique: each data zone appears once in the shapefile tablejoin.<table>.gov.2006.every_record_matched: every record found its data zone in the edition: no empty cellreadback.<table>.attached_values: every attached value in the saved file is looked up again from the sources and equalgovscot.2006.access_domain.present: the declared domain rank column is in the filegovscot.2006.access_domain.complete: every zone has a domain rankgovscot.2006.access_domain.half_units: every domain rank is a whole multiple of 0.5govscot.2006.access_domain.range: every domain rank is between 1 and the number of zonesjoin.<table>.domain_ranks_half_units: every joined domain rank is a whole multiple of 0.5
Why: simd-domain-ranks