About this Dataset

Bar Ditch

Bar Ditch - A bar ditch is a man-made, open drainage-way into which excess surface water or groundwater drained from land, storm water runoff, or floodwaters flow either continuously or intermittently. It differs from a ditch in that it is typically less than 18 inches deep and contains driveway culverts of insignificant size (6" - 12"). A single line feature represents the entire line of ditch/culvert representing the bar ditch.This data has been collected as part of a larger project by the City of Austin's Watershed Protection and Development Review Department to inventory its drainage infrastructure and create a GIS to store this information. The project includes an internal team developing a GIS based on record documents and an external team locating ground level appurtenances using GPS field collection units. The data in this data set represents the former.
Organization: City of Austin
Last updated: 2022-08-12T21:36:45.331212
Tags: agoltosocrata, drainage, storm-sewer, stormwater, watershed, wpd

Tables

Table 1

@usgov.city_of_austin_bar_ditch.table_1

107.36 kB
387 rows
41 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "enabled" BIGINT,
  "drainage_id" BIGINT,
  "jtx_jobid" BIGINT,
  "comments" VARCHAR,
  "up_node_id" BIGINT,
  "dn_node_id" BIGINT,
  "up_node_type" VARCHAR,
  "dn_node_type" VARCHAR,
  "created_by" VARCHAR,
  "created_date" VARCHAR,
  "modified_by" VARCHAR,
  "modified_date" VARCHAR,
  "checked_by" VARCHAR,
  "watershed" VARCHAR,
  "map_index" VARCHAR,
  "mapsco" VARCHAR,
  "date_built" VARCHAR,
  "year_built" DOUBLE,
  "year_source" VARCHAR,
  "year_abandoned" DOUBLE,
  "location_source" VARCHAR,
  "place_id" BIGINT,
  "dimen_source" VARCHAR,
  "up_elev_source" VARCHAR,
  "dn_elev_source" VARCHAR,
  "up_invert" DOUBLE,
  "dn_invert" DOUBLE,
  "slope" DOUBLE,
  "slope_est" VARCHAR,
  "length" DOUBLE,
  "ownership" VARCHAR,
  "maintenance" VARCHAR,
  "globalid" VARCHAR,
  "edit_status" VARCHAR,
  "fme_date" VARCHAR,
  "status" VARCHAR,
  "observation" BIGINT,
  "modeled" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);