About this Dataset

Street Signs And Roadway Markings Work Order Time Logs

This dataset relates work completed for the purpose of installing and maintaining roadway markings and street signs across the City of Austin. Each row records time spent by one or more technicians who completed the work order. 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
Road Markings Jobs: https://data.austintexas.gov/dataset/Work-Order-Markings-Jobs/vey3-7n3x
Signs Work Orders: https://data.austintexas.gov/dataset/Work-Order-Signs/ivss-na93
Signs and Markings Reimbursements: https://data.austintexas.gov/dataset/Signs-and-Markings-Reimbursement-Tracking/pma8-yy5k
Organization: City of Austin
Last updated: 2021-08-13T17:07:09.213936

Tables

Table 1

@usgov.city_of_austin_street_signs_and_roadway_markings_work__7652b36f.table_1

3.58 MB
60,753 rows
13 columns

CREATE TABLE table_1 (
  "id" VARCHAR,
  "work_log_id" BIGINT,
  "work_order_id" VARCHAR,
  "markings_job_id" VARCHAR,
  "work_order_status" VARCHAR,
  "markings_job_status" VARCHAR,
  "date_work" VARCHAR,
  "created_date" VARCHAR,
  "modified_date" VARCHAR,
  "location_name" VARCHAR,
  "work_type" VARCHAR,
  "count_of_technicians" BIGINT,
  "total_minutes_worked" DOUBLE
);