Street Signs And Roadway Markings Reimbursements by US Government | Transportation and Logistics

About this Dataset

Street Signs And Roadway Markings Reimbursements

This data captures intradepartmental reimbursements for street sign and roadway markings work from October 2019 to present. 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

City of Austin Open Data Terms of Use
https://data.austintexas.gov/stories/s/ranj-cccq
Organization: City of Austin
Last updated: 2021-08-13T17:06:51.618183
Tags: atd, austin-transportation-department, marking, pavement-marking, reimbursement, roadways, signs, street, traffic, work-orders

Tables

Table 1

@usgov.city_of_austin_street_signs_and_roadway_markings_reimbursements.table_1

233.83 KB
2201 rows
35 columns


CREATE TABLE table_1 (
  "id" VARCHAR,
  "reimbursement_id" BIGINT,
  "materials" DOUBLE,
  "city_of_austin_labor" DOUBLE,
  "contract_labor" DOUBLE,
  "invoice_amount" DOUBLE,
  "bond" BOOLEAN,
  "submitted_to_division_manager_approval" VARCHAR,
  "processed_by_finance" VARCHAR,
  "disassociated_from_work_order" VARCHAR,
  "signs_work_order" VARCHAR,
  "markings_work_order" VARCHAR,
  "work_order_id" VARCHAR,
  "requester_id" VARCHAR,
  "work_order_status" VARCHAR,
  "work_type" VARCHAR,
  "location" VARCHAR,
  "cip" VARCHAR,
  "tk" VARCHAR,
  "fdu" VARCHAR,
  "reimbursable" VARCHAR,
  "too_small" BOOLEAN,
  "reimbursable_status" VARCHAR,
  "invoice_date" TIMESTAMP,
  "submitted_for_smd_review" TIMESTAMP,
  "contract_labor_vendor" VARCHAR,
  "contract_labor_invoice_no_and_date" VARCHAR,
  "labor_invoice_date" TIMESTAMP,
  "sent_to_requester_date" TIMESTAMP,
  "approval_status" VARCHAR,
  "finance_approval_status" VARCHAR,
  "invoice_approved_date" TIMESTAMP,
  "date_sent_to_finance" TIMESTAMP,
  "journal_voucher_number" VARCHAR,
  "comments" VARCHAR
);