About this Dataset

Fish Passage Barriers By Passage Status

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:45:59.043624
Tags: anadromous, blockages, culverts, dams, fish, habitat, native-migratory-fish, odfw, oregon, passage, salmon, steelhead

Tables

Table 1

@usgov.state_of_oregon_fish_passage_barriers_by_passage_status.table_1

4.07 MB
45,279 rows
39 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" VARCHAR,
  "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,
  "fpbfyty" VARCHAR,
  "fpbcomment" VARCHAR,
  "oweb_status" DOUBLE,
  "oweb_userid" DOUBLE,
  "prioritygroup" VARCHAR
);