About this Dataset

BLM OR Non Native Arc Hub

FISH_NON_NATIVE_ARC: This feature class is used to determine whether a particular non-native fish species is present in a stream, which can affect protection buffer widths in land management plans and activities. The data comes primarily from the Hydro Update Project, and is from actual observations or from modeled fish presence. While each district carried out their determinations in various ways, generally verification means that the fish biologist or other trained specialist was able to see the fish at the stream.
Organization: Department of the Interior
Last updated: 2024-02-09T04:46:38.899607
Tags: biota, fishbearing, fisheries, geospatial, hydrology, inlandwaters, management, non-native-fish, oregon, streams, washington, water, watercourses, wildlife

Tables

Table 1

@usgov.doi_gov_blm_or_non_native_arc_hub.table_1

2.84 MB
29,782 rows
19 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,
  "fmeasure" DOUBLE,
  "tmeasure" DOUBLE,
  "eventoffset" BIGINT,
  "permanent_identifier" VARCHAR,
  "globalid" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);