About this Dataset

Stream Gages

The Water Resources Department operates more than 200 stream and reservoir gages throughout the state. More than 160 of these gages are operated as near real-time. These gages transmit stream data once an hour. The data is received and downloaded to the Department’s database where it is processed and updated on the web page every hour. In addition, information from another 225 gages operated by the USGS and other agencies is also shared on the Department’s website.
Organization: State of Oregon
Last updated: 2024-02-09T16:03:37.737439
Tags: environment, hydrography, stream-gage

Tables

Table 1

@usgov.state_of_oregon_stream_gages_73508.table_1

346.54 kB
2,682 rows
67 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "lkp_gaging_station_id" BIGINT,
  "station_nbr" VARCHAR,
  "station_name" VARCHAR,
  "station_status" VARCHAR,
  "streamflow_type" VARCHAR,
  "source_type" VARCHAR,
  "streamcode" VARCHAR,
  "longitude_dec" DOUBLE,
  "latitude_dec" DOUBLE,
  "county_name" VARCHAR,
  "state_name" VARCHAR,
  "owrd_region" VARCHAR,
  "wm_district" DOUBLE,
  "hydrologic_unit_code" DOUBLE,
  "meridian" VARCHAR,
  "township" DOUBLE,
  "township_char" VARCHAR,
  "range" DOUBLE,
  "range_char" VARCHAR,
  "sctn" DOUBLE,
  "qtr160" VARCHAR,
  "qtr40" VARCHAR,
  "elevation" DOUBLE,
  "elevation_datum" DOUBLE,
  "current_operation_mode" VARCHAR,
  "most_recent_operator" VARCHAR,
  "cooperators" VARCHAR,
  "published_area" DOUBLE,
  "owrd_area" DOUBLE,
  "ws_characteristic" BIGINT,
  "flood_region" DOUBLE,
  "basin_name" VARCHAR,
  "streamflow_type_name" VARCHAR,
  "source_type_name" VARCHAR,
  "station_status_name" VARCHAR,
  "current_operation_mode_name" VARCHAR,
  "period_of_record_start_date" TIMESTAMP,
  "period_of_record_end_date" TIMESTAMP,
  "nbr_of_complete_water_years" BIGINT,
  "nbr_of_peak_flow_values" BIGINT,
  "peak_flow_record_start_wy" DOUBLE,
  "peak_flow_record_end_wy" DOUBLE,
  "near_real_time_web_link" VARCHAR,
  "near_real_time_processing" DOUBLE,
  "daily_processing" DOUBLE,
  "stage_instantaneous_available" DOUBLE,
  "flow_instantaneous_available" DOUBLE,
  "mean_daily_flow_available" DOUBLE,
  "measured_flow_available" DOUBLE,
  "volume_midnight_available" DOUBLE,
  "stage_midnight_available" DOUBLE,
  "mean_daily_volume_available" DOUBLE,
  "mean_daily_stage_available" DOUBLE,
  "rating_curve_available" DOUBLE,
  "water_temp_instantaneous_avail" DOUBLE,
  "water_temp_measurement_avail" DOUBLE,
  "water_temp_mean_available" DOUBLE,
  "water_temp_max_available" DOUBLE,
  "water_temp_min_available" DOUBLE,
  "air_temp_instantaneous_avail" DOUBLE,
  "air_temp_mean_available" DOUBLE,
  "air_temp_max_available" DOUBLE,
  "air_temp_min_available" DOUBLE,
  "precipitation_available" DOUBLE
);