2020 March Update - Master Issue

[SPTKL]

doe_lcgms (new data)

current script runs need to double check (we removed the time dimension for sca_bluebook), there's no data_as_of column anymore 1839 records previously, 2423 records currently, need deduplication

table_name = 'sca_bluebook'
df = importer(table_name,
            sql=f'select org_id, bldg_id, org_target_cap as target_capacity 
                      from {table_name}.latest')

previously, we used sca enrollment capacity on Opendata update: using sca enrollment capacity on opendata, we get 2530 records

nysdoh_nursinghomes #290

(data changed, bed type to abbreviations) --> need factype and facsubgrp

ADHCPSLOTSAV, Adult Day Health Care Slots Available BIBEDSAV, Behavioral Intervention Beds Available DIALYSISDEN, Dialysis Station Dens NHBEDSAV, Nursing Home Beds Available PEDBEDSAV, Pediatric Beds Available PEDVENTCAP, Pediatrics Ventilator Beds SCATTERBEDSAV, Scatter Ventilator Beds Available TBIBEDSAV, Traumatic Brain Injury Beds Available VENTBEDSAV, Ventilator Beds Available

foodbankny_foodbank #291

• no longer include SNAP centers
• records counts went from 755 to 441
• only food pantry, senior center and soup kitchen are included (kosher center no longer included)
• foodbankny is using google map as their geocoder, we have really 98.2% geocoding success rate.

  hra_centers #292

• new categories (OCSS, CASA)
• data scraped from google map link
• record counts decreased from 87 to 73
• on NYC Opendata, hra has
• job centers
• food stamp centers
• community health centers
• medicaid offices
• also based on observation, HRA is using google map as their main geocoder for their locations. google map automatically computes coordinates for each address they input on their maps, we have really 98.63% geocoding success rate.

[github-actions[bot]]

Stale issue message