About this Dataset

BLM OR Hydrography Publication Flowline Fish Arc Hub

HYD_PUB_FLOWLINE_FISH: This dataset contains flowline features from the US Geologic Survey (USGS) High Resolution National Hydrography Dataset (NHD). NHD Flowline features are linear depictions of streams and centerlines of rivers. Additional attributes have been added from the Bureau of Land Management (BLM) hydrography event data. This dataset represents flowline features that have species-specific fish distribution information. This dataset will be refreshed as-needed to reflect updates to the NHD and Bureau of Land Management (BLM) hydrography event data.
Organization: Department of the Interior
Last updated: 2024-02-09T04:55:33.355429
Tags: adt, aquatic-data-and-tools, area, arims, biota, california, fish, fisheries, geospatial, hydrology, idaho, inlandwaters, management, nevada, nhd, ocean, oregon, pacific-northwest, pnw, rapids, riparian, rivers, streams, washington, water, watercourses, wildlife

Tables

Table 1

@usgov.doi_gov_blm_or_hydrography_publication_flowline_fish_arc_hub.table_1

21.02 MB
377,926 rows
224 columns

CREATE TABLE table_1 (
  "objectid" DOUBLE,
  "reachcode" VARCHAR,
  "fmeasure" VARCHAR,
  "tmeasure" DOUBLE,
  "permanent_identifier" VARCHAR,
  "ftype" DOUBLE,
  "fcode" DOUBLE,
  "gnis_id" DOUBLE,
  "gnis_name" VARCHAR,
  "local_name" VARCHAR,
  "nhd_flow" VARCHAR,
  "planflow" VARCHAR,
  "fishbearing" VARCHAR,
  "strm_continuity" VARCHAR,
  "streamorder" VARCHAR,
  "strm_ver_dt" VARCHAR,
  "wbarea_permanent_identifier" VARCHAR,
  "ftr_organization" VARCHAR,
  "ftr_source_interp" VARCHAR,
  "ftr_source_dt" VARCHAR,
  "pub_date" VARCHAR,
  "subbasin" DOUBLE,
  "acme_an" VARCHAR,
  "acme_an_dt" VARCHAR,
  "entr_an" VARCHAR,
  "entr_an_dt" VARCHAR,
  "ongo_an" VARCHAR,
  "ongo_an_dt" VARCHAR,
  "onke_an" VARCHAR,
  "onke_an_dt" VARCHAR,
  "onki_an" VARCHAR,
  "onki_an_dt" VARCHAR,
  "onmyk_an" VARCHAR,
  "onmyk_an_dt" VARCHAR,
  "onmyl_an" VARCHAR,
  "onmyl_an_dt" VARCHAR,
  "onne_an" VARCHAR,
  "onne_an_dt" VARCHAR,
  "onnec_an" VARCHAR,
  "onnec_an_dt" VARCHAR,
  "ontsm_an" VARCHAR,
  "ontsm_an_dt" VARCHAR,
  "ontsn_an" VARCHAR,
  "ontsn_an_dt" VARCHAR,
  "ontso_an" VARCHAR,
  "ontso_an_dt" VARCHAR,
  "thpa_an" VARCHAR,
  "thpa_an_dt" VARCHAR,
  "acal_re" VARCHAR,
  "acal_re_dt" VARCHAR,
  "actr_re" VARCHAR,
  "actr_re_dt" VARCHAR,
  "caca_re" VARCHAR,
  "caca_re_dt" VARCHAR,
  "caco_re" VARCHAR,
  "caco_re_dt" VARCHAR,
  "cama_re" VARCHAR,
  "cama_re_dt" VARCHAR,
  "caoclaa_re" VARCHAR,
  "caoclaa_re_dt" VARCHAR,
  "capl_re" VARCHAR,
  "capl_re_dt" VARCHAR,
  "cari_re" VARCHAR,
  "cari_re_dt" VARCHAR,
  "carisspa_re" VARCHAR,
  "carisspa_re_dt" VARCHAR,
  "casn_re" VARCHAR,
  "casn_re_dt" VARCHAR,
  "cata_re" VARCHAR,
  "cata_re_dt" VARCHAR,
  "cawa_re" VARCHAR,
  "cawa_re_dt" VARCHAR,
  "chbr_re" VARCHAR,
  "chbr_re_dt" VARCHAR,
  "coal_re" VARCHAR,
  "coal_re_dt" VARCHAR,
  "coas_re" VARCHAR,
  "coas_re_dt" VARCHAR,
  "coba_re" VARCHAR,
  "coba_re_dt" VARCHAR,
  "cobaa_re" VARCHAR,
  "cobaa_re_dt" VARCHAR,
  "coco2_re" VARCHAR,
  "coco2_re_dt" VARCHAR,
  "cogu_re" VARCHAR,
  "cogu_re_dt" VARCHAR,
  "cope_re" VARCHAR,
  "cope_re_dt" VARCHAR,
  "copi_re" VARCHAR,
  "copi_re_dt" VARCHAR,
  "copr_re" VARCHAR,
  "copr_re_dt" VARCHAR,
  "corh_re" VARCHAR,
  "corh_re_dt" VARCHAR,
  "cospp_re" VARCHAR,
  "cospp_re_dt" VARCHAR,
  "cote_re" VARCHAR,
  "cote_re_dt" VARCHAR,
  "delu_re" VARCHAR,
  "delu_re_dt" VARCHAR
);