About this Dataset

Removed Or Replaced Barriers

Fish passage barriers include both natural and artificial obstructions that either block or impede fish passage or have the potential to block or impede fish passage. Barriers must be channel spanning across waters of the state of Oregon.
Organization: State of Oregon
Last updated: 2025-08-02T18:40:53.711406
Tags: anadromous, blockages, culverts, dams, fish, habitat, native-migratory-fish, odfw, oregon, passage, salmon, steelhead

Tables

Table 1

@usgov.state_of_oregon_removed_or_replaced_barriers.table_1

150.44 kB
925 rows
40 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "fpbftrid" BIGINT,
  "fpblong" DOUBLE,
  "fpblat" DOUBLE,
  "fpbrevdt" BIGINT,
  "fpboftrid" VARCHAR,
  "fpbonm" VARCHAR,
  "fpbositeid" VARCHAR,
  "fpblocmd" VARCHAR,
  "fpblocaccu" BIGINT,
  "fpblocdt" DOUBLE,
  "fpbftrty" VARCHAR,
  "fpbftrnm" VARCHAR,
  "fpbrmvdt" BIGINT,
  "fpbmltftr" VARCHAR,
  "fpbfpassta" VARCHAR,
  "fpbstaevdt" VARCHAR,
  "fpbstaevmd" VARCHAR,
  "fpbfysta" VARCHAR,
  "fpbstrnm" VARCHAR,
  "fpbrdnm" VARCHAR,
  "fpbftrsty" VARCHAR,
  "fpbheight" DOUBLE,
  "fpblength" DOUBLE,
  "fpbwidth" DOUBLE,
  "fpbslope" DOUBLE,
  "fpbdrop" DOUBLE,
  "fpboryr" DOUBLE,
  "fpbmoddt" VARCHAR,
  "fpbmodty" VARCHAR,
  "fpbmoddesc" VARCHAR,
  "fpbown" VARCHAR,
  "fpblown" VARCHAR,
  "fpbfyty" VARCHAR,
  "fpbcomment" VARCHAR,
  "oweb_status" DOUBLE,
  "oweb_userid" DOUBLE,
  "prioritygroup" VARCHAR
);