About this Dataset

Roadway Markings Contractor Work Orders

This dataset contains records of in-progress and work completed from June 2021 to present for the purpose of tracking the installation and maintenance of roadway markings by contractors in the City of Austin full purpose jurisdiction. This work is managed by the Signs and Markings Division of the City of Austin Transportation and Public Works Department. The records are managed in a work management system tracker.

You may also be interested in this related dataset to in-house work:

Roadway Markings Work Orders: https://data.austintexas.gov/Transportation-and-Mobility/Roadway-Markings-Work-Orders/nyhn-669r
Organization: City of Austin
Last updated: 2022-09-02T18:31:01.048710
Tags: contractor, mobility, pavement-markings, roadway-markings, signs-and-markings, smd, tpw, transportation-and-public-works, work-orders

Tables

Table 1

@usgov.city_of_austin_roadway_markings_contractor_work_orders.table_1

365.84 kB
4,136 rows
31 columns

CREATE TABLE table_1 (
  "work_order_id" BIGINT,
  "created_date" VARCHAR,
  "modified_date" VARCHAR,
  "parent_wo" DOUBLE,
  "parent_wo_field" DOUBLE,
  "work_authorization_number" BIGINT,
  "assigned_contractor" VARCHAR,
  "assigned_to" VARCHAR,
  "gis_id" VARCHAR,
  "instruction_comments" VARCHAR,
  "follow_up_instructions" VARCHAR,
  "from_street" VARCHAR,
  "to_street" VARCHAR,
  "street_display_name" VARCHAR,
  "area" VARCHAR,
  "work_order_status" VARCHAR,
  "issued_date" VARCHAR,
  "contractor_submitted_date" VARCHAR,
  "contractor_submitted_by" VARCHAR,
  "count_attachments" BIGINT,
  "count_comments" BIGINT,
  "count_inspections" BIGINT,
  "count_work_log" BIGINT,
  "work_status" VARCHAR,
  "primary_parent_wo" DOUBLE,
  "record_id" VARCHAR,
  "gis_qa" BOOLEAN,
  "street_segment_ids" VARCHAR,
  "work_groups" VARCHAR,
  "road_class" VARCHAR,
  "sum_segment_miles" DOUBLE
);