lineup-equipment-taxonomy

Public task · Field Engineering

← Field Engineering

Classify a lineup-planning app's equipment types by the taxonomy workbook into standard bucket and discipline group columns, backfilled by migration and set on import, and group the lineup editor's Available equipment list by them.

Version
Category
Engineering
Model configurations
1
Attempts
8
Public trials
84 passed
Median runtime
54m 47s

Instruction

The **Available equipment** list in the lineup editor's sidebar is grouped by
equipment family, which is not how the planning team thinks about gear. They
want it grouped by our equipment taxonomy: first **Standard / House /
Non-Standard**, then **Electrical / Mechanical / Structural / Other** under
each.

I now have the mapping: `attachments/Equipment Taxonomy.xlsx` (the
`Equipment Taxonomy` sheet lists each equipment type specification with its
`Standard?` bucket and its `Category`).

The taxonomy belongs as columns on the `equipment_types` table, not in app
code. Equipment types already in the database get classified when the
migration runs, and anything the ingest brings in, through any of its import
commands, gets classified as it is imported. That includes the services API,
which ships as its own image built from `services/` alone.

The lineups equipment metadata API should return each equipment type's
classification as `standardBucket` and `disciplineGroup`, and the sidebar
should just group on the API response, with no normalization or fallback
logic of its own. Equipment the mapping doesn't cover still shows in the
list, under **Unknown**.

One more thing: on the final leaf rows, clicking the row should add it to the
block, instead of only the + button.

## Environment

PostgreSQL on localhost:5432 and the local database endpoint the app's
driver uses are running when you start, and the dev env files point at the
dev database.

Public trials

Results by model

Model · harnessMean rewardRange± SEAttempts
Frontier model ACursor CLI50.0%0% – 100%18.9 pp8