Facilities DB bed/pop ratios update

[damonmcc]

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
• ...

[damonmcc]

(from sprint planning on 12/18) to request missing data from agencies soon, we should:

• list source data for specified facility types
• compile a list that links to the latest source data file
• note if that source data has capacity information

[damonmcc]

this Excel sheet in Sharepoint has a list of some of the FacDB sources and details on whether they have capacity information. Only 1 out of 9 does.

will touch base soon on how to request that agencies add/provide capacity data

[damonmcc]

(from sprint planning on 1/16/24)

Capital Planning is working on getting the source data

[damonmcc]

regarding source data

Based on DCP's response to the Comptroller Office's audit of Fair Share compliance (link), we planned to use Census Bureau decennial population data to update beds-to-population ratios.