Name: UTILITIESCOMMUNICATION Stormwater Control
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

UTILITIESCOMMUNICATION Stormwater Control

Stormwater Controls
Organization: City of Austin
Last updated: 2022-12-23T08:54:09.547570
Tags: agoltosocrata, bmp, development, flood, pond, runoff, treatment, water-quality

Tables

Table 1

@usgov.city_of_austin_stormwater_ponds_07cce.table_1

9.94 MB
11,388 rows
67 columns

CREATE TABLE table_1 (
  "case_number" VARCHAR,
  "checked_by" VARCHAR,
  "control_area_acres" DOUBLE,
  "control_depth" DOUBLE,
  "control_type" VARCHAR,
  "control_volume" DOUBLE,
  "council_district" DOUBLE,
  "created_by" VARCHAR,
  "data_status" VARCHAR,
  "document_number" VARCHAR,
  "drainage_area_acres" DOUBLE,
  "drainage_id" BIGINT,
  "field_operations_zone" BIGINT,
  "gis_comments" VARCHAR,
  "globalid" VARCHAR,
  "index_200" VARCHAR,
  "inspection_responsibility" VARCHAR,
  "jurisdiction_label" VARCHAR,
  "legacy_site_id" VARCHAR,
  "link_id" DOUBLE,
  "maintenance_responsibility" VARCHAR,
  "mapsco_page_index" VARCHAR,
  "maximo_creation_state" BIGINT,
  "maximo_criticality" DOUBLE,
  "maximo_site_id" VARCHAR,
  "modified_by" VARCHAR,
  "objectid" BIGINT,
  "operating_permit_number" VARCHAR,
  "ordinance_reference" VARCHAR,
  "place_id" DOUBLE,
  "program" BIGINT,
  "project_name" VARCHAR,
  "recharge_zone" VARCHAR,
  "runoff_capture_depth" VARCHAR,
  "sedimentation_type" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "status" VARCHAR,
  "street_address" VARCHAR,
  "watershed_name" VARCHAR,
  "watershed_regulation_area" VARCHAR,
  "regional_detention_control" VARCHAR,
  "maximo_rowstamp" DOUBLE,
  "the_geom" VARCHAR,
  "review_accepted_date" VARCHAR,
  "bccp_participation" VARCHAR,
  "date_built" VARCHAR,
  "water_quality_control" VARCHAR,
  "created_date" VARCHAR,
  "flood_control" VARCHAR,
  "subsurface_control" VARCHAR,
  "regional_wq_control" VARCHAR,
  "maximo_risk" VARCHAR,
  "maximo_asset_number" BIGINT,
  "fme_date" VARCHAR,
  "tceq_dam" VARCHAR,
  "maximo_condition" DOUBLE,
  "pilot_channel" VARCHAR,
  "maximo_location_id" DOUBLE,
  "mechanical_pump" VARCHAR,
  "modified_date" VARCHAR,
  "q_design_100yr_event" VARCHAR,
  "q_design_10yr_event" VARCHAR,
  "q_design_25yr_event" VARCHAR,
  "veg_maint_responsibility" VARCHAR,
  "q_design_2yr_event" VARCHAR,
  "access_address" VARCHAR
);