Test & Review TPW Work Orders Dataflow

[Charlie-Henry]

https://github.com/cityofaustin/atd-data-tech/issues/16656

TPW Test workspace: TPW Work Orders

• Check if it's still updating
  • [x] Roadway Markings
    • Last modified record 06/12 AKA yesterday
  • [x] Roadway Markings (contractor)
    • Last modified record 06/11 AKA 2 days ago
  • [ ] Street & Bridge Ops
    • Last change date is 06/07 AKA last Friday?
  • [x] Street Signs
    • Last modified record is 06/12 AKA yesterday
  • [x] Traffic Signals
    • Last modified record is 06/12 AKA yesterday
• Check if you can connect in TPW Test
  • [x] Roadway Markings
  • [x] Roadway Markings (contractor)
  • [x] Street & Bridge Ops
  • [x] Street Signs
  • [x] Traffic Signals
• Check out some data and see if it looks ok?
  • [ ] Roadway Markings
  • [x] Roadway Markings (contractor)
  • [x] Street & Bridge Ops
  • [ ] Street Signs
  • [ ] Traffic Signals
• Suggest some changes if we need any
  • See comment below
• Push to production if you think we're good to go, I might need to edit the credentials after?

[susannegov]

Some changes

Roadway Markings

• The following columns need to change from Text to date/time
  • remove_hold_date

    Street Signs

• Remove sign_location.coordinates as it is a blank column

  Traffic Signals

• The following columns need to change from Text to date/time
  • created_date
  • submitted_date
  • modified_date
  • closed_date
• There are 8 @computed_region columns in the Traffic Signals and I don't know what they are.
• location.coordinates.0 Data category should be set to Longitude and renamed x-coordinate longitude
• location.coordinates.1 Data category should be set to Latitude and renamed y-coordinate latitude

[susannegov]

@Charlie-Henry see above for changes needed