Create an API view of contractor work orders

[amenity]

Karo notes 2022/07/14:

SMB API Views page Private view Notes / model here

[dianamartin]

Steps

SMB Tracker Pages>API Views (Private)

• [x] Create a table view of "contractors table"
• [x] Add all fields that stakeholder needs
• [ ] Check with stakeholders on which fields that need to be created - [ ] Export all fields to share with Andrew - [ ] Ask Andrew to create new feature layer that match the same fields Moving the latter two into a new issue. -Karo 7/20/22

[KaroEngstrom]

M 7/18/22

• Chatted with Christina - will discuss fields later this afternoon
• builder side
• user page

[KaroEngstrom]

• include contractor work order AND contractor work log

• Don't include ATD representative details:

  • ATD Owner Rep name
  • ATD Owner Rep signature
  • Contractor Signature
  • Phone
  • Knack back office stuff

DO include :

• Street Segment ID (street_segments>Segment ID)
• Road Class (street_segments> ROAD_CLASS)
• Sum Segment Miles (SUM_SEGMENT_MILES)

NOTE: For the previously existing markings work orders item, John C. had done a workaround to get Road Class (RNC) from another set. From this same set, he had summed up linear miles to get an estimate of the long-line striping that has been completed.

• [x] Added STREET_SEGMENT_IDS connection field to contractor work order object (modeled after the same field in Work Orders Markings) - [ ] Add Road Class (this shows up in the CSV export of the existing work orders markings table but I cannot find the field on the builder side to look at as a model) - [ ] Add Sum Segment Miles (see note above)

[dianamartin]

Add these fields to API

• Work Group Category
• GIS QA
• Street Segments

[KaroEngstrom]

W 7/20/22

• [x] Added GIA QA, and Street Segments to the new table (bottom of the page here)
• [x] Added Work Groups field