Closed kgjenkins closed 4 years ago
Official values are listed in the "Categories" spreadsheet, which is used to generate the table of contents. Any non-matching values found in a service record will be logged to the javascript console.
The Spanish sheet still needs some cleanup.
Console now reports the record id for each error found.
English is good, Spanish needs more cleanup.
The site now drives everything from the English categories/subcategories in the combined english/spanish "services" sheet.
Like categories, some of the subcategories appear in slightly different forms. These should be normalized, with consistent capitalization. Here's a list of the each subcategory and the number of times it appears:
Adult Education: 6 Adult education: 80 Adult literacy: 1 Affordable Housing: 1 Affordable housing: 35 Alcohol/drug abuse treatment: 1 Alcohol/drug addiction services: 1 Alcohol/drug addiction treatment: 28 Career Education: 3 Career advice: 57 Career education: 48 Career services: 2 Career training: 16 Child care: 12 Childcare: 7 Citizenship education: 2 Citizenship preparation: 19 Clases for adults: 1 Classes for adults: 1 Clothing: 54 Dental: 41 Domestic Violence: 3 Domestic violence: 41 ESL: 124 ESL, Adult education: 1 ESL, Citizenship preparation, Career education: 1 ESL: Adult education: 3 Education: 1 Education assistance: 1 Educational Support: 1 Educational initiatives: 8 Educational support: 8 Emergency Shelter: 5 Emergency assistance: 1 Emergency financial aid: 16 Emergency financial assistance: 6 Emergency shelter: 21 Empowerment: 14 Family law: 58 Farm visits: 18 Farm visits (inspections): 2 Farm visits (pesticide training: 1 Financial education: 2 Food: 171 Food pantry: 2 General Medicine: 3 General health: 12 General medicine: 62 General medicine, Women's medicine, Dental, Farm visits: 1 General medicine: Women's health: 1 Health Accessibility: 5 Health access: 8 Health accessibility: 30 Home improvements: 20 Homeownership: 11 Housing improvements: 33 Housing improvements, Homeownership: 1 Immigration: 14 Immigration Law: 2 Immigration law: 50 Immigration law (deportation and removal, citizenship and naturalization): 1 Job search assistance: 110 Job search assistance: Training: 1 Labor Rights: 2 Labor disputes: 14 Labor rights: 2 Leadership support: 2 Legal advocacy: 3 Legislative advocacy: 4 Legislative initiatives: 1 Medicine: 10 Mental health: 10 No direct services to farmworkers: 1 Other law: 76 Other necessities: 2 Other needs: 27 Other needs: Affordable housing: 1 Parent support: 1 Parenting Support: 1 Parenting classes: 3 Parenting education: 1 Parenting support: 51 Personal finances: 7 Primary care: 1 Professional training: 1 Programs for children: 2 Programs for kids: 114 Programs for kids, Educational support: 1 Psychological assistance: 2 Psychological services: 3 Psychological support: 50 Psychological support: Farm visits: 1 Specialist medicine: 5 Specialty medicine: 20 Training: 86 Training, Programs for kids: 1 Training: Career advice: 1 Transportation: 6 Utility Assistance: 1 Utility assistance: 33 Victim Services: 1 Victim services: 12 Victim support: 4 Victims services: 1 Women's health: 48 Women's medicine: 7 Women’s health: 2 Worker rights: 2 Youth empowerment: 2 emergency shelter: 1 heat stress): 1 job search assistance: 1 legislative initiatives: 1 programs for kids: 2 victim services: 1
Some of these are the same as an existing category -- I'm not sure if we really need the subcategory in those cases.