About this Dataset

Strategic Measure Right Of Way Obstructions

This dataset provides data describing Public Works Department responses to 311 calls regarding obstructions of the City right of way. The data comes from the department's Maximo work order management system. Each row represents one 311 Customer Service Request (CSR).

View more details and insights related to this data set on the story page: https://data.austintexas.gov/stories/s/Percentage-of-infrastructure-classified-as-poor-or/smwq-cx27/
Organization: City of Austin
Last updated: 2021-08-07T11:09:56.676062
Tags: city-of-austin, infrastructure, infrastructure-maintenance, mobility, sd23, transportation

Tables

Table 1

@usgov.city_of_austin_strategic_measure_right_of_way_obstructions.table_1

1.27 MB
15,847 rows
17 columns

CREATE TABLE table_1 (
  "work_order_id" VARCHAR,
  "description" VARCHAR,
  "status" VARCHAR,
  "work_group" VARCHAR,
  "program" VARCHAR,
  "report_date" VARCHAR,
  "service_address" VARCHAR,
  "completion_date" VARCHAR,
  "duration_hours" DOUBLE  -- Duration (hours),
  "failure_class" VARCHAR,
  "problem" VARCHAR,
  "service_request_id" VARCHAR,
  "work_order_priority" BIGINT,
  "council_district" DOUBLE,
  "fiscal_year" VARCHAR,
  "valid_duration" BIGINT,
  "meets_standard" BIGINT
);