Every zone-level score of one spatial unit, across all metrics

The long-form reader that feeds zone_score_delta(): one row per (zone, metric) for the zones of fld — Program Areas by default — in one release's sdm.duckdb. Schema-adaptive like pra_score_delta() (value in v1–v7, val in v8+) and pinnable to a zone set the same way, so a v6 database (no zone_set_key column) and a v9 database can be read with one call each and compared with zone_score_delta().

Usage

zone_scores(con, fld = "programarea_key", zone_set_key = NULL, label = "db")

Arguments

con

a DBI connection to a release's sdm.duckdb

fld

zone field to read (default "programarea_key")

zone_set_key

optional {zone_type}_{YYYY-MM} to pin the spatial unit; errors if a connection carries the column but not that value

label

version label for error messages (default "db")

Value

a tibble of zone_key, metric_key, score