Dataset: Dam Facilities

About this Dataset

Dam Facilities

Large dams are defined by a dam height >= 10 feet and storage of >= 9.2 acre feet. These larger dams are within the juristiction of Oregon Water Resource Department. Large dams that are not managed by OWRD are considered "Non-Fee Dams" (apply_fee = 'NO')
Organization: State of Oregon
Last updated: 2025-03-08T03:39:26.185097
Tags: dams, oregon

Tables

Table 1

@usgov.state_of_oregon_dam_facilities_58a1a.table_1

178.16 KB
1222 rows
34 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "nidid" VARCHAR,
  "dam_name" VARCHAR,
  "dam_height" DOUBLE,
  "hazard" VARCHAR,
  "river" VARCHAR,
  "file_nbr" VARCHAR,
  "township" DOUBLE,
  "range" DOUBLE,
  "sctn" DOUBLE,
  "remarks" VARCHAR,
  "permit_char" VARCHAR,
  "county_code" VARCHAR,
  "source_agency" VARCHAR,
  "owner_name" VARCHAR,
  "apply_fee" BIGINT,
  "exempt_category" VARCHAR,
  "nearest_city_distance" DOUBLE,
  "wm_district" BIGINT,
  "next_inspection" DOUBLE,
  "basin_nbr" DOUBLE,
  "permit_nbr" DOUBLE,
  "location" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "inspection_date" VARCHAR,
  "is_active_dam" BIGINT,
  "statutory_dam" BIGINT,
  "max_storage" DOUBLE,
  "normal_storage" DOUBLE,
  "nid_storage" DOUBLE,
  "inspection_date_int" DOUBLE
);