Centreville Flooding & Sewage Overflow Survey Dashboard data analysis & visualization consultant | 2022 | created in partnership with Barclay Kingel | Equity Legal Services & Metropolitan St. Louis Equal Housing & Opportunity Council
For more than 20 years, residents of the City of Centreville have experienced flooding and sewage overflows in their homes. In order to gain insight into this shared experience of residents, in the Summer and Fall of 2021, canvassers went door to door, talking with residents about their experiences.
Canvassers asked residents a handful of questions.
- How long have you lived here? Do you own your home?
- When was the last time your home flooded? For how many years have you experienced flooding?
- When was the last time you had sewage overflow into your home? For how many years have you experienced sewage overflows?
The group of canvassers knocked the majority of doors in Centreville, totalling 1,438. From those doors, 4,369 people were canvassed. 609 surveys were completed by people who own their homes. The dashboard below visualizes their responses.
View dashboard in Tableau Public.
Caitlin and Barclay created two custom Tableau dashboards. The first dashboard, with identifyable data removed, visualizes the survey responses on a map of Centreville. It is published in formats and locations accessible to residents who took the survey and to active coalition members. The organizations embeded the dashboard on the Equity Legal Services and Flooded and Forgotten websites and dedicated space to findings and a print version of the map in their Community Report. The second dashboard, with survey responses connected their addresses,was created for internal use by the organizations. They are meant to inform further analysis and advocacy.
For this project, Caitlin held the role of project manager and advised on metrics and presentation of data. Barclay managed the data and dashboard build.