SEO: New category pages. New child taxonomies workbook

[adambard1]

Here is a workbook exported from Airtable where the export of services at 20240807 received updated child (and in some cases, parent) taxonomies.
The new child taxonomies are in the columns on each workbook "Final Child Taxonomy'
We did this as various services appeared to be suboptimally/incorrectly categorized, and we wanted to prepare for the new category pages we are implementing.

Thinking ahead to enabling AI to identify nuance, having the ability to tag services with more than one taxonomy appears important, e.g., the Immigration and legal services referenced below, or Laundry and shower services under the Personal Care category.

Note (in reference to the new category pages):

1. The "Health no child" tab contains

• For the https://yourpeer.nyc/mental-health page, filter column I for: text contains "mental-health"

2. The "Other no child" tab contains

• For the https://yourpeer.nyc/legal-services page, filter column J Final Child Taxonomies for: text contains "legal"
• NOTE: Many Immigration Services are legal services. Without a way to indicate both taxonomies, to enable more people to find legal services, we should use that category and retain the service name as "Immigration services," or some form thereof.
• For the https://yourpeer.nyc/employment-training page, filter for: text contains "employment" or "job"

3. The "Other wchild" tab contains Advocates/Legal services. Filter for: text contains "legal"

NOTE: there is no "Health wchild" tab, as it was not possible to create child taxonomies under Health.

[adambard1]

For issue #239

[shakilhossain1]

There are 29 Employment services now.
and 126 Mental health services
and 83 for the legal services.

here is the pr link for the migration.
and pr for the frontend.

[adambard1]

@shakilhossain1 I just wanted to check that the title tags and meta descriptions are in place

Legal Services - https://yourpeer.nyc/legal-services
Title Tag: Free Legal Services & Aid for Unhoused People in NYC | YourPeer
Meta Description: Free legal services for unhoused individuals, including help with housing, evictions, immigration, and other aid throughout NYC.

Mental Health - https://yourpeer.nyc/health-care/mental-health
Title Tag: Mental Health Services for the Unhoused in NYC | YourPeer
Meta Description: Discover free and low-cost mental health services in NYC for unhoused people, offering compassionate care and support.

Employment yourpeer.nyc/employment-training
Title Tag: Employment & Job Training Programs for Unhoused People NYC | YouPeer
Meta Description: Find employment programs, job training, and other resources to help you secure work that supports your well-being.

[adambard1]

Looking at the test deplyment. Looks good, there are sevearl services to recategorize so we may need to do another migration.
Only issue we've seen is one Job Readiness service that is showing as duplicated in the list view when clicking the Employment filter pill.
It does not show as duplicated if the employment filter pill is selected and I search for the location.
It does show as duplicated if the employment filter pill is not selected and I search for the location,

The Service Details page show it duplicated if clicking through from the list with duplication in it.

Regular list view

Searching with filter pill on

Searching without filter pill on

[adambard1]

@jbeard4 QA is done. There's one issue on one service (as above), correct urls (e.g., /employment-training), title tags, and metadata to add. Should we ask for a thumbs up from SEO before this is deployed to prod?

[jbeard4]

We can use these queries to cross-check that we do not have services with multiple taxonomies:

			select count(1), service_id from service_taxonomy 
			group by service_id
			having count(1) > 1

select s.id, s.name, t.name from service_taxonomy st
inner join taxonomies t on t.id = st.taxonomy_id
inner join services s on st.service_id = s.id
where service_id in (
	select service_id from 
		(
			select count(1), service_id from service_taxonomy 
			group by service_id
			having count(1) > 1
		) 
) order by service_id