About this Dataset

MS4 Storm Sewer Outfalls

The dataset contains locations and attributes of the MS4 outfalls created as part of the Federal MS4 Permit. GPS outfall locations were captured by DC Water, then DC WASA in 2004-2006. A database provided by WASA identified outfalls, drainage structures, and MS4 outfall locations. The data was verified in conjunction between DOEE and DC Water.
Organization: District of Columbia
Last updated: 2024-04-30T17:47:58.748152
Tags: dc, district-of-columbia, doee, drainage-area, environment, ms4, sewer-outfall, stormwater, washington-dc, water

Tables

Table 1

@usgov.district_of_columbia_ms4_storm_sewer_outfalls.table_1

112.81 kB
573 rows
38 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "outfall_id" DOUBLE,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "land_use" VARCHAR,
  "susceptibility" VARCHAR,
  "overall_priority" VARCHAR,
  "watershed" VARCHAR,
  "receiving_waterbody" VARCHAR,
  "road_intersection_1" VARCHAR,
  "road_intersection_2" VARCHAR,
  "prox_road" VARCHAR,
  "landmarks" VARCHAR,
  "outfall_shape" VARCHAR,
  "type_material" VARCHAR,
  "size" VARCHAR,
  "date" TIMESTAMP,
  "air_temp" VARCHAR,
  "weather" VARCHAR,
  "outfall_condition" VARCHAR,
  "flow" DOUBLE,
  "turbidity" VARCHAR,
  "odor" VARCHAR,
  "visual_other" VARCHAR,
  "chlorine" VARCHAR,
  "notes" VARCHAR,
  "image" VARCHAR,
  "fieldinvestigator" VARCHAR,
  "last_inspected_date" VARCHAR,
  "inspectors" VARCHAR,
  "dcw_f_id" VARCHAR,
  "assettag" VARCHAR,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "created" VARCHAR,
  "edited" VARCHAR,
  "objectid" BIGINT
);