About this Dataset

Waterbody Classifications

This data set provides the water quality classifications of New York State's lakes, rivers, streams and ponds, collectively referred to as waterbodies. All water bodies in the state are provided a water quality classification based on existing, or expected best usage, of each waterbody or waterbody segment. Under New York State's Environmental Conservation Law (ECL), Title 5 of Article 15, certain waters of the state are protected on the basis of their classification. Streams and small waterbodies located in the course of a stream that are designated as C (T) or higher (i.e., C (TS), B, or A) are collectively referred to as "protected streams."
Organization: State of New York
Last updated: 2020-11-12T03:59:38.511406
Tags: water-quality-classifications

Tables

Table 1

@usgov.state_of_new_york_waterbody_classifications.table_1

189.79 kB
4,769 rows
9 columns

CREATE TABLE table_1 (
  "waterbody_type" VARCHAR,
  "segment_id" VARCHAR,
  "waterbody_index_number_win" VARCHAR  -- Waterbody Index Number (WIN),
  "name" VARCHAR,
  "description" VARCHAR,
  "basin" VARCHAR,
  "segment_miles" DOUBLE,
  "n_6nycrr_chapter_x_part" BIGINT  -- 6NYCRR Chapter X Part,
  "water_quality_class" VARCHAR
);