MOEO facility sub groups

[mgraber]

Previous classification used a mixture of a lookup and SQL case statements to map program_name to facsubgrp. Which approach should we take in the refactored code?

[mgraber]

All combinations of program_name and the first element in service_taxonomy

program_name	split_part
Youth Recreational Services/Youth Athletic Leagues	["recreational services"]
Family Justice Center	["emergency preparedness and response"
Community Based Programs	["conflict resolution/mediation"
Court Based Programs	["case management"
Child Advocacy Center	["client evaluation/assessment"
Victim Services, Domestic Violence	["clinical counseling"]
NYC Business Solutions
Drop-In Centers
Shelter Intake
Family Justice Center	["citizenship assistance"
Alternative To Detention	["academic supports"
Article 10 Petition Parental Representation	["legal representation"]
Teen Rapp	["academic engagement"
YouthPathways
Victim Services, Domestic Violence	["clinical counseling"
Parent Support Program
PEAK Centers
ICM Plus
Hate Crimes Prevention	["outreach"
Court Advocacy Services	["legal services"
Crime Victims Services	["restitution collections"]
Anti-gun Violence Initiative	["legal services"]
Trial-Level Indigent Defense Representation	["legal representation"]
Youth Recreational Services/Youth Athletic Leagues	["athletic leagues"]
Workforce 1 Career Centers
Works Plus
Homebase Homelessness Prevention
Next STEPS
Crime Victims Services	["client evaluation/assessment"
CareerCompass
Discharge and Reentry Services	["discharge/re-entry"
Food Pantry/Meal Services	["unspecified"]
Teen Rapp	["counseling"
Anti-gun Violence Initiative	["outreach"
Mediation Services	["conflict resolution/mediation"
Discharge and Reentry Services	["discharge/re-entry"]
CareerAdvance
Appellate Indigent Criminal Defense	["legal representation"]
Customized Assistance Services (CAS)	["advocacy"
Justice Plus
Intake Medical Services
Customized Assistance Services (CAS)	["needs assessment"]
Legal Services
Community Based Programs	["civic engagement"
AIM
Adult Protective Services	["case management"
Jobs Plus
COVID19 Programs
Arches
Adolescent IMPACT
Neighborhood Employment Services
Employment Focused Services
Family Justice Center	["legal representation"
Adult Outreach Service
Job Services
Customized Assistance Services (CAS)
Family Justice Center	["children's room in service location"
Adult Protective Services
Rapid Re-Housing
Crime Victims Services	["case management"
Home Care/Attendant/Maker and Housekeeping Services
Homebase Homelessness Prevention	["preventive services"]
Alternative To Incarceration	["alternative justice management"]
Food Pantry/Meal Services	["food services"
Youth Recreational Services/Youth Athletic Leagues	["recreational services"
Mobile Adolescent Therapy
NeON Arts
Court Based Programs	["alternative justice management"]
Victim Services, Domestic Violence	["community advocacy"]
Community Based Programs	["case management"

[AmandaDoyle]

Attached is the latest version of the moeo dataset before they changed the schema. I don't see the fields factype or facsubgrp so I'm not sure how those came into play. There is another source for facsubgrp beyond the mapping between program_name and facsubgrp because CHEMICAL DEPENDENCY is a facsubgrp value for example. Can you map the origin of the factype or facsubgrp in the moeo_socialservicesiteloactions source dataset?

moeo_socialservicesitelocations_2019_11_12 (1).csv.zip

Regardless, we'll reach out to MOEO to ask how we should map the new fields to factype and facsubsgroup, and confirm that we should still be removing some records from the MOEO data since other sources are more reliable.

[mgraber]

@AmandaDoyle facsubgrp and facdomain didn't come from source data originally. They were mapped from a separate lookup table, using program_name, with what looks like patches added on in code.

[AmandaDoyle]

Got feedback from MOEO Use the 'program_name' to assign facility type and map to a facility subgroup. The service_taxonomy column is not required for the agencies.

So next steps are to map 'program_name' to facility type, and then remap 'program_name' to a facility subgroup, which I'm happy to help with by either doing a first pass or looking at something that's in progress

[AmandaDoyle]

MOEO_FacDB_program_name_to_facsubgroup_MOEO_edits.xlsx

Final program name to FacSubgroup classification attached