Name: USGS West Virginia Streamgages May 2023
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

USGS West Virginia Streamgages May 2023

The US Geological Survey has over 10,000 streamgages (metal devices that measure rivers and waterways) around the United States. There are 196 of them in West Virginia as of May 17, 2023.

A new version of this dataset is HERE and is updated weekly.

This dataset has the following for all of the streamgages in West Virginia:

the agency monitoring them (usually USGS)
monitoring location ID number
name of monitoring location
latitude
longitude
lat/long type
county
hydrologic unit
drainage area (square miles)
datum of gage (AKA elevation)

USGS periodically adds streamgages throughout the United States. This dataset has all West Virginia streamgages as of May 17, 2023.

Photo by Jackalope West on Unsplash.

Tables

Usgs Streamgages Wv 20230518

@kaggle.protobioengineering_usgs_west_virginia_streamgages_may_2023.usgs_streamgages_wv_20230518

21.62 kB
196 rows
12 columns

CREATE TABLE usgs_streamgages_wv_20230518 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "agency" VARCHAR,
  "location_id" BIGINT,
  "name" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "lat_long_type" VARCHAR,
  "county" VARCHAR,
  "hydrologic_unit" DOUBLE,
  "drainage_area" DOUBLE,
  "datum_of_gage" DOUBLE,
  "datum_type" VARCHAR
);