About this Dataset

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

Tables

Table 1

@usgov.state_of_oregon_priority_barriers.table_1

195.69 kB
622 rows
82 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "fpbftrid" BIGINT,
  "fpblong" DOUBLE,
  "fpblat" DOUBLE,
  "fpbsiteid" BIGINT,
  "fpbrevdt" BIGINT,
  "fpboftrid" VARCHAR,
  "fpbonm" VARCHAR,
  "fpbositeid" VARCHAR,
  "fpblocmd" VARCHAR,
  "fpblocaccu" BIGINT,
  "fpblocdt" DOUBLE,
  "fpbftrty" VARCHAR,
  "fpbftrnm" VARCHAR,
  "fpbrmvdt" DOUBLE,
  "fpbmltftr" VARCHAR,
  "fpbfpassta" VARCHAR,
  "fpbstaevdt" DOUBLE,
  "fpbstaevmd" VARCHAR,
  "fpbfysta" VARCHAR,
  "fpbfycrit" VARCHAR,
  "fpbcrddesc" VARCHAR,
  "permanent_identifier" VARCHAR,
  "reachcode" DOUBLE,
  "measure" DOUBLE,
  "eventdate" TIMESTAMP,
  "reachsmdate" TIMESTAMP,
  "reachresolution" DOUBLE,
  "fpbstrnm" VARCHAR,
  "fpbrdid" VARCHAR,
  "fpbrdmile" DOUBLE,
  "fpbrdnm" VARCHAR,
  "fpbloconm" VARCHAR,
  "fpbftrsty" VARCHAR,
  "fpbftrnmsr" VARCHAR,
  "fpbheight" DOUBLE,
  "fpblength" DOUBLE,
  "fpbwidth" DOUBLE,
  "fpbslope" DOUBLE,
  "fpbdrop" DOUBLE,
  "fpboryr" DOUBLE,
  "fpbmoddt" DOUBLE,
  "fpbmodty" VARCHAR,
  "fpbmoddesc" VARCHAR,
  "fpbdesonm" VARCHAR,
  "fpbown" VARCHAR,
  "fpblown" VARCHAR,
  "fpboperate" VARCHAR,
  "fpbfyown" VARCHAR,
  "fpbownty" VARCHAR,
  "fpblownty" VARCHAR,
  "fpbownonm" VARCHAR,
  "fpbfyty" VARCHAR,
  "fpbfysty" VARCHAR,
  "fpbfyoryr" DOUBLE,
  "fpbfpasonm" VARCHAR,
  "fpblocmdd" VARCHAR,
  "fpbftrtyd" VARCHAR,
  "fpbftrstyd" VARCHAR,
  "fpbevmdfad" VARCHAR,
  "fpbevmdpad" VARCHAR,
  "fpbfytyd" VARCHAR,
  "fpbowntyd" VARCHAR,
  "fpblowntyd" VARCHAR,
  "fpbcomment" VARCHAR,
  "prioritygroup" VARCHAR,
  "odfw_fishdistrict" VARCHAR,
  "subbasin" VARCHAR,
  "species" VARCHAR,
  "tescore" BIGINT,
  "habitatquantityscore" BIGINT,
  "nmfspeciesno" BIGINT,
  "habitatquality" BIGINT,
  "autoup" BIGINT,
  "autodown" BIGINT,
  "passagelevel" BIGINT,
  "coldwateraccess" DOUBLE,
  "thermalsuitabilitychange" DOUBLE,
  "f2025_score" BIGINT,
  "owner" VARCHAR
);