1 of 6

DCP Data Jam

Colocating facilities for vulnerable populations

Table 5: How can DCP and other City agencies use FacDB to inform the co-location of compatible facilities?

2 of 6

Wrangling the What

Grouping FacDB by FacType + FacGroup + Agency

  • “Public” “K-12 Schools” “(DEP)” account for 37% of all facilities.
  • “Pre-school” “Childcare” “(DOHMH)” accounts for 22% of all facilities.
  • “Non-public” “K-12 Schools” “(NYSED)” account for 14% of all facilities
  • “All Age” “CAMPS” “(DOHMH)” account for 8.5% of all facilities

These 4 groups combined account for ~82% of all facilities

3 of 6

Map

Visualizes FacDB data through <FacType2 + FacGroup> where FacType2 = SPLIT(FacType,” - “,2)

4 of 6

Strategies for co-location

  • Spatial compatibility (distance and local geography)
    • Grouping facilities by distance. (3,6 blocks away, a subway stop away etc.)
    • Grouping facilities by local geographies (NTA, CD, BG, CT etc.)
  • (City<>State) Agency compatibility
    • Grouping City and State facilities to encourage service pollination.
  • Service compatibility
    • Colocating facilities based on Frequently occuring city services - perhaps matching with 311 service vocabulary?
  • Citizen interaction compatibility
    • Grouping facilities based on the frequency of citizen interaction.
    • Consider a histogram of a citizen’s interaction with gov. facilities. - IDNYC, DMV, SNAP etc. (more interactions) vs Paratransit (fewer interactions)

​

​

5 of 6

New data

Adding lease expirations to prioritize co-location decision making.

​

​

Collaborative mapping and crowd-sourcing tags from the community.

6 of 6

Other recommendations

A geo-crosswalk for FacDB

A geo-crosswalk is a relationship file that establishes the hierarchical connection between each census tabulation block and all higher level geographic entities.

LatLong >>> BlockGroup >>> CensusTract >>>NTA>>> CDs >> Police Precincts / Hospital service areas /NYPD precincts /DSNY areas.

Source: LEHD Origin-Destination Employment Statistics (LODES) Dataset Structure Format Version 7.0

​