Roadway Markings Jobs
This dataset contains records of work completed and in-progress work from June 2018 to present for the purpose of tracking the installation and maintenance of roadway markings across the City of Austin. The Jobs dataset is separated into four categories: Long Line, Short Line, Specialty Markings, and Raised Pavement Markings.
Long Line: Work group responsible for installing and maintaining lane lines, double yellow centerlines, bike lane lines, and turn bay.
Short Line: Work group responsible for installing and maintaining crosswalks, school zone lines, and stop lines.
Specialty Markings: Work group responsible for installing and maintaining arrows, words, bike symbols, pedestrian symbols, railroad crossings, yield triangles, parking stalls/Ls/Ts, green pads, and speed hump markings.
Raised Pavement Markings: Work group responsible for installing and maintaining delineators, raised pavement markings (RPMs), and concrete domes.
This work is managed by the Signs & Markings Division of the City of Austin Transportation Department.
You may also be interested in these related datasets, which can be joined together using the work order ID columns:
Road Markings Work Orders: https://data.austintexas.gov/Transportation-and-Mobility/Roadway-Markings-Work-Orders/nyhn-669r
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
|Name||Socrata field name||Column name in ||Data type||Description|
|Work Type||work_type||work_type||Text||The type of work|
|Requester||requestor||requestor||Text||The type of requester who submitted the work order|
|Created Date||created_date||created_date||Calendar date||The datetime the time log record was created|
|Work Order ID||atd_work_order_id||atd_work_order_id||Text||The work order ID|
|Location Name||location_name||location_name||Text||The location name of the work order|
|ID||id||id||Text||The unique record ID in the source database (Knack).|
|Completed Date||completed_date||completed_date||Text||The date the work was completed|
|Modified Date||modified_date||modified_date||Calendar date||The datetime the time log record was last modified|
|Work Order Status||work_order_status||work_order_status||Text||The status of the work order|
|Job Status||job_status||job_status||Text||The status of the job|
|Job ID||atd_sam_job_id||atd_sam_job_id||Text||The roadway markings Job ID|
|Workgroup||workgroup||workgroup||Text||The workgroup who did work at this work order|