About this Dataset

BLM OR Fish Passage Barriers Point Hub

FPB_PUB_PT: The Fish Passage Barrier (FPB) dataset represents basic information about existing and potential human-caused barriers to fish passage in watercourses, e.g., dams, culverts, bridges, tide gates, and weirs. In addition to basic information about barriers, the dataset provides general passage status.
Organization: Department of the Interior
Last updated: 2024-02-09T04:58:33.556963
Tags: disturbance, fish-pasage-barrier, fpb, geospatial, hydrology, inlandwaters, management, oregon, transportation, wildlife

Tables

Table 1

@usgov.doi_gov_blm_or_fish_passage_barriers_point_hub.table_1

756.36 kB
4,586 rows
68 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "strct_guid" VARCHAR,
  "reason" VARCHAR,
  "blm_org_cd" VARCHAR,
  "classifier" VARCHAR,
  "current_cd" VARCHAR,
  "famskey" VARCHAR,
  "ftr_id" DOUBLE,
  "long" DOUBLE,
  "lat" DOUBLE,
  "site_id" DOUBLE,
  "revision_date" VARCHAR,
  "originator_ftr_id" VARCHAR,
  "originator_name" VARCHAR,
  "owner_site_id" VARCHAR,
  "loc_method" VARCHAR,
  "loc_accuracy" DOUBLE,
  "loc_date" VARCHAR,
  "feature_type" VARCHAR,
  "feature_name" VARCHAR,
  "removed_date" VARCHAR,
  "multiple_features" VARCHAR  -- Multiple Features?,
  "passage_status" VARCHAR,
  "status_eval_date" VARCHAR,
  "status_eval_mthd" VARCHAR,
  "fishway_status" VARCHAR,
  "fishway_passage" VARCHAR  -- Fishway Passage?,
  "coord_desc" VARCHAR,
  "nhd_reach_code" DOUBLE,
  "stream_name" VARCHAR,
  "road_id" VARCHAR,
  "road_mile" DOUBLE,
  "road_name" VARCHAR,
  "loc_src_originator" VARCHAR,
  "ftr_sub_type" VARCHAR,
  "ftr_name_src" VARCHAR,
  "height" DOUBLE,
  "length" DOUBLE,
  "width" DOUBLE,
  "slope" DOUBLE,
  "drop" DOUBLE,
  "origin_year" DOUBLE,
  "mod_date" DOUBLE,
  "mod_type" VARCHAR,
  "mod_desc" VARCHAR,
  "desc_src_originator_name" VARCHAR,
  "barrier_owner" VARCHAR,
  "land_owner" VARCHAR,
  "operator" VARCHAR,
  "fishway_owner" VARCHAR,
  "owner_type" VARCHAR,
  "landowner_type" VARCHAR,
  "ownership_originator_name" VARCHAR,
  "fishway_type" VARCHAR,
  "fishway_sub_type" VARCHAR,
  "fishway_origin_year" DOUBLE,
  "fish_pass_data_source" VARCHAR,
  "loc_method_desc" VARCHAR,
  "ftr_type_desc" VARCHAR,
  "ftr_sub_type_desc" VARCHAR,
  "status_full_eval_mth_desc" VARCHAR,
  "status_partial_eval_mth_desc" VARCHAR,
  "fishway_type_desc" VARCHAR,
  "owner_type_desc" VARCHAR,
  "landowner_type_desc" VARCHAR,
  "comment" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);