Tested edition · Anonymous download
Parks backlog priorities
Open repair and improvement items, published bureau scores, property summaries and dated closure-risk references.
Edition 2026-11-06-a4a6a4ebbed7 · Verified 2026-11-06
Download and reproduce
Complete files, definitions, source references, example code and expected results.
Download ZIP · 0.16 MBSHA-256: d354fa99e91920946e29ead40c120ccb930d1d94db818cd8cd9611403e5d1305
Questions you can investigate
- Which items share the highest published scores?
- Which properties have matched closure-risk items?
Coverage and dates
Published open backlog items; not all repair needs or funded projects.
- 2026-10-12 backlog extract
- 2025-01 closure-risk briefing
- 2023-11 historical estimates
Public files retrieved 2026-11-06. Verification checks the package; it does not refresh the observations.
What this cannot establish
- Bureau scores are not a funding ranking; Lab bands and flags are interpretations.
- Historical estimates are 2023 proposals, not current repair costs.
- Property matches and January 2025 flags do not establish current closure status.
Unsupported: What would each repair cost today?
Join without double counting
- backlog-priorities.propertyId → backlog-priority-properties.propertyId is many-to-one; item id is unique.
- Closure-risk references have multiple asset families per property; never join them to money rows without aggregation.
- For budgets, group item rows by propertyId first, then join to parks-budgets.property_id for ONE fiscal_year. Preserve unmatched/systemwide locations.
Source and reuse
Portland Parks Atlas; Portland Parks & Recreation
CC BY 4.0 for Lab compilations; underlying records and editorial material retain their source terms. See package license and publisher documentation.
Cite this edition, its manifest and the original source dates. The files remain reproducible when a newer edition is selected.