Tested edition · Anonymous download
Parks adopted budgets
Public budget source rows, account totals, reviewed property matches and incomplete district subtotals.
Edition 2026-11-06-ec377ccf8492 · Verified 2026-11-06
Download and reproduce
Complete files, definitions, source references, example code and expected results.
Download ZIP · 0.44 MBSHA-256: 4b09dd88697fadda4c6b98e4d3e8037d3d559fb96c83fb23911d4d8f67b93b1b
Questions you can investigate
- How do adopted expense categories reconcile to bureau controls?
- What backlog and named-account budget evidence exists for a property?
Coverage and dates
FY2024–25, FY2025–26 and FY2026–27 adopted snapshots; later amendments not applied.
- 2026-09-16 source workbook archived
- FY2024-25/FY2026-27 adopted budgets
Public files retrieved 2026-11-06. Verification checks the package; it does not refresh the observations.
What this cannot establish
- Adopted budget authority is not actual spending or full annual service cost.
- Most expense-category dollars are unallocated to individual properties.
- District subtotals cannot rank total spending or equity; blanks are unknown, not zero.
Unsupported: How much did the City actually spend at each park?
Join without double counting
- accounts: unique (fiscal_year, account_id); park-budgets: unique (fiscal_year, property_id).
- account-property-crosswalk.account is unique; many accounts may map to one parent property. Aggregate before joining.
- Select one fiscal year before joining property_id to backlog propertyId; unmatched amounts stay unallocated.
Source and reuse
Portland Parks Atlas; City of Portland Budget Office
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.