Council Data Project: Infrastructure-as-code for civic transparency and accessibility
summary
An open-source deployable stack provides a complete site for council videos, searchable transcripts, agendas and vote records by spinning up a generated repo that provisions Firebase storage, Google Cloud Speech-to-Text, a Postgres-like index, and a React frontend via infrastructure-as-code. ETL pipelines run on Prefect, infra is codified with Pulumi, CI and scheduled jobs use GitHub Actions, cookiecutter templates produce forkable deployments (King County, Portland) that already serve timestamped transcripts and working search.
AI-written summary · about
chapters (23)
- 0:00Intro
- 1:38What is CDP
- 2:48How CDP works
- 4:57CDP features
- 6:04Who am I
- 7:01Key aspects of the project
- 7:41Core ideas
- 8:34Python
- 10:00Summary
- 10:38Deployment System
- 11:47Cookie Cutter
- 15:37Why Infrastructureascode
- 16:10Core Infrastructure
- 17:24Cloud Platform
- 17:57Plumi
- 18:31Prefect
- 18:54GitHub Actions
- 21:21GitHub Pages
- 21:40Bump to Version
- 24:41CDP Backend
- 25:02Commits
- 25:23Conclusion
- 26:07Outro
related talks
19mCoding in a Cyclone: open-source and the public sector in the birthplace of R
13mThe Civic Commons: Code Sharing Between Cities
32mFreeing software with governance, for public administrations
35mDesigning for Impact in Civic Data Science
01h 09mMaking Government 2.0 a Reality: A Citizen's Guide to Essential Reforms
18mDigital Public Infrastructure - Government Clouds based on Open Source
06mHow Open Data is Making ...
01h 07mFireside chat: Digital Public Infrastructure