Facilities DB bed/pop ratios update

Project description

We plan to update DCP's Bed/Population Ratios by adding capacity data back to Facilities DB.

Background

Capital Planning has been tasked with updating DCP's Bed/Population Ratios, which measure the concentration of residential facilities like jails, nursing homes, foster homes, treatment centers, etc. in a community. The ratios are meant to be considered by agencies when performing fair share analyses for the siting of new residential facilities.

The Bed/Pop ratios were last updated in 2015. The previous version of the FacDB product, known as the Selected Facilities and Program Sites database contained capacity/beds information as a key input for the ratio updates.

Going forward, we'll be updating the ratios annually to meet Charter requirements.

Requirements

• Pull the data sources for the relevant facility types so we can know what datasets don't have capacity information
• Request and review new source data
• ...

No files, tests, or entry points are named. Start by identifying the relevant facility types and their current source datasets, then review which sources provide capacity information. Done should include the reviewed source data and a documented understanding of which datasets still lack capacity fields.