austintexas-gov/roadway-markings-jobs-vey3-7n3x
Icon for Socrata external plugin
 
Readme
Updated 20 hours ago
Indexed 3 hours ago

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:

Division website: http://www.austintexas.gov/department/signs-markings

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Work Typework_typework_typeTextThe type of work
RequesterrequestorrequestorTextThe type of requester who submitted the work order
Created Datecreated_datecreated_dateCalendar dateThe datetime the time log record was created
Work Order IDatd_work_order_idatd_work_order_idTextThe work order ID
Location Namelocation_namelocation_nameTextThe location name of the work order
IDididTextThe unique record ID in the source database (Knack).
Completed Datecompleted_datecompleted_dateTextThe date the work was completed
Modified Datemodified_datemodified_dateCalendar dateThe datetime the time log record was last modified
Work Order Statuswork_order_statuswork_order_statusTextThe status of the work order
Job Statusjob_statusjob_statusTextThe status of the job
Job IDatd_sam_job_idatd_sam_job_idTextThe roadway markings Job ID
WorkgroupworkgroupworkgroupTextThe workgroup who did work at this work order
 
Preview
  • roadway_markings_jobs
     
Upstream Metadata