Roadway Markings Work Orders
This dataset contains records of in-progress and work completed from June 2018 to present for the purpose of tracking the installation and maintenance of roadway markings in the City of Austin full purpose jurisdiction. This work is managed by the Signs & Markings Division of the City of Austin Transportation Department.
The records are managed in a work management system tracker and the dataset is automatically updated twice per day.
You may also be interested in these related datasets, which can be joined together using the work order ID columns:
Road Markings Jobs: https://data.austintexas.gov/dataset/Work-Order-Markings-Jobs/vey3-7n3x
Signs and Markings Time Logs: https://data.austintexas.gov/dataset/Work-Order-Signs-Markings-Time-Logs/qvth-gwdv
Signs and Markings Reimbursements: https://data.austintexas.gov/dataset/Signs-and-Markings-Reimbursement-Tracking/pma8-yy5k
Division website: http://www.austintexas.gov/department/signs-markings
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| ID | id | id | Text | The unique record ID in the source database (Knack). |
| On Hold Date | on_hold_date | on_hold_date | Calendar date | The datetime the work order was on-hold. |
| Work Order ID | atd_work_order_id | atd_work_order_id | Text | The work order ID |
| Work Groups Required | work_groups_required | work_groups_required | Text | The list of workgroups who did work at this work order. |
| Requester Work Order ID | requester_work_order_id | requester_work_order_id | Text | The requesters work order ID. |
| Location Name | location_name | location_name | Text | The location of the work order. |
| Remove Hold Date | remove_hold_date | remove_hold_date | Calendar date | The datetime the work order had the hold removed. |
| Task Order Number | task_order_number | task_order_number | Text | The task order number |
| Priority | priority | priority | Text | The priority of work order. This is set by requesters. |
| Work Type | work_type | work_type | Text | The type of work. Default is Markings. |
| Work Order Status | work_order_status | work_order_status | Text | The status of the work order. |
| Street Segment IDs | segment_id | segment_id | Text | The list of street segments associated with this work order |
| Work Subtype | work_sub_type | work_sub_type | Text | Additional detail about the type of work completed. |
| Modified Date | modified_date | modified_date | Calendar date | The datetime the work order record was last modified. |
| Total Segment Miles | sum_segment_miles | sum_segment_miles | Number | The total length in miles of all street segment associated with this work order |
| Service Request Number | sr_number | sr_number | Text | The 311 service request number related to this work order. |
| Funding Number | funding_number | funding_number | Text | The funding number. |
| Completed Date | completed_date | completed_date | Calendar date | The date the work was completed |
| Requester | requester | requester | Text | The type of requester who submitted the work order. |
| Created Date | created_date | created_date | Calendar date | The datetime the work order record was created. |
| Road Class | road_class | road_class | Text | The list of road class codes |
| Street & Bridge Completed Date | sbo_completed_date | sbo_completed_date | Calendar date | The datetime Street and Bridge (SBO) from Austin Public Works department completed work. |