About this Dataset

Strategic Measure Vegetation Maintenance (M.E.6)

This dataset provides data describing Public Works Department responses to 311 calls requesting maintenance of trees and vegetation within 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/Number-and-percent-of-customer-service-requests-fo/4edc-yq5y/
Organization: City of Austin
Last updated: 2021-08-07T11:22:51.577072
Tags: city-of-austin, green-infrastructure, infrastructure, infrastructure-maintenance, mobility, sd23, transportation, vegetation, vegetation-management

Tables

Table 1

@usgov.city_of_austin_strategic_measure_vegetation_maintenance_m_e_6.table_1

1.35 MB
17,000 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
);