About this Dataset

Street Sign Work Orders

This dataset contains records of work completed and in-progress work from June 2018 to present for the purpose of installing and maintaining street signs in the City of Austin full purpose jurisdiction. This work is managed by the Signs & Markings division of the City of Austin Transportation and Public Works Department.

You may also be interested in these related datasets, which can be joined together using the work order ID columns:

Signs and Markings Time Logs: https://data.austintexas.gov/dataset/Work-Order-Signs-Markings-Time-Logs/qvth-gwdv
Organization: City of Austin
Last updated: 2021-08-13T17:05:34.899563
Tags: austin-transportation-department, mobility, signs, traffic, transportation, work-orders

Tables

Table 1

@usgov.city_of_austin_street_sign_work_orders_03e05.table_1

4.38 MB
47,337 rows
15 columns

CREATE TABLE table_1 (
  "id" VARCHAR,
  "created_date" VARCHAR,
  "modified_date" VARCHAR,
  "work_order_id" VARCHAR,
  "requester" VARCHAR,
  "on_hold_date" VARCHAR,
  "completed_date" VARCHAR,
  "funding_number" VARCHAR,
  "task_order_number" VARCHAR,
  "work_order_status" VARCHAR,
  "requester_work_order_id" VARCHAR,
  "service_request_number" VARCHAR,
  "work_area" VARCHAR,
  "location_name" VARCHAR,
  "location" VARCHAR
);