About this Dataset

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 (SMD) of the City of Austin Transportation and Public Works (TPW) 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
Organization: City of Austin
Last updated: 2021-08-13T17:06:32.148236
Tags: atd, austin-transportation-department, markings, pavement, roadways

Tables

Table 1

@usgov.city_of_austin_roadway_markings_work_orders.table_1

861.25 kB
9,310 rows
23 columns

CREATE TABLE table_1 (
  "id" VARCHAR,
  "created_date" VARCHAR,
  "modified_date" VARCHAR,
  "work_order_id" VARCHAR,
  "work_type" VARCHAR,
  "work_subtype" VARCHAR,
  "requester" VARCHAR,
  "work_groups_required" VARCHAR,
  "requester_work_order_id" VARCHAR,
  "location_name" VARCHAR,
  "on_hold_date" VARCHAR,
  "remove_hold_date" VARCHAR,
  "completed_date" VARCHAR,
  "work_order_status" VARCHAR,
  "street_bridge_completed_date" VARCHAR  -- Street & Bridge Completed Date,
  "task_order_number" VARCHAR,
  "funding_number" VARCHAR,
  "priority" VARCHAR,
  "service_request_number" VARCHAR,
  "street_segment_ids" VARCHAR,
  "road_class" VARCHAR,
  "total_segment_miles" DOUBLE,
  "safety_device_maintenance" VARCHAR
);