About this Dataset

BLM OR Fish Resident Poly Hub

FISH_RESIDENT_POLY: Water bodies under BLM management that contain Resident Fish – fish that do not migrate out to the ocean but remain in freshwater.
Organization: Department of the Interior
Last updated: 2024-02-09T04:49:13.091786
Tags: biota, boundaries, fishbearing, fisheries, geospatial, hydrology, inlandwaters, management, oregon, resident-fish-species, streams, washington, water, watercourses, wildlife

Tables

Table 1

@usgov.doi_gov_blm_or_fish_resident_poly_hub.table_1

34.84 kB
203 rows
17 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "species_cd" VARCHAR,
  "presence_cd" VARCHAR,
  "obs_dt" VARCHAR,
  "fish_method" VARCHAR,
  "ext_presence_cd" VARCHAR,
  "ext_source" VARCHAR,
  "ext_obs_dt" VARCHAR,
  "comments" VARCHAR,
  "eventdate" VARCHAR,
  "reachcode" BIGINT,
  "reachsmdate" VARCHAR,
  "reachresolution" BIGINT,
  "permanent_identifier" VARCHAR,
  "globalid" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);