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 |
|---|---|---|---|---|
| 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. |
| Service Request Number | sr_number | sr_number | Text | The 311 service request number related to this work order. |
| Work Subtype | work_sub_type | work_sub_type | Text | Additional detail about the type of work completed. |
| Requester | requester | requester | Text | The type of requester who submitted the 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 |
| 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. |
| Remove Hold Date | remove_hold_date | remove_hold_date | Calendar date | The datetime the work order had the hold removed. |
| Created Date | created_date | created_date | Calendar date | The datetime the work order record was created. |
| Modified Date | modified_date | modified_date | Calendar date | The datetime the work order record was last modified. |
| Work Order Status | work_order_status | work_order_status | Text | The status of the work order. |
| Requester Work Order ID | requester_work_order_id | requester_work_order_id | Text | The requesters work order ID. |
| 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. |
| ID | id | id | Text | The unique record ID in the source database (Knack). |
| Task Order Number | task_order_number | task_order_number | Text | The task order number |
| Road Class | road_class | road_class | Text | The list of road class codes |
| Street Segment IDs | segment_id | segment_id | Text | The list of street segments associated with this work order |
| Total Segment Miles | sum_segment_miles | sum_segment_miles | Number | The total length in miles of all street segment associated with this work order |
| Location Name | location_name | location_name | Text | The location of the work order. |
| On Hold Date | on_hold_date | on_hold_date | Calendar date | The datetime the work order was on-hold. |