BLM Natl AIM Lotic Indicators Hub by US Government | Healthcare

About this Dataset

BLM Natl AIM Lotic Indicators Hub

This feature class includes monitoring data collected nationally to understand the status, condition, and trend of resources on BLM lands. Data are collected in accordance with the BLM Assessment, Inventory, and Monitoring (AIM) Strategy. The AIM Strategy specifies a probabilistic sampling design, standard core indicators and methods, electronic data capture and management, and integration with remote sensing. Attributes include the BLM aquatic core indicators: pH, conductivity, temperature, pool depth, length, frequency, streambed particles sizes, bank stability and cover, floodplain connectivity, large woody debris, macroinvertebrate biological integrity, ocular estimates of vegetative type, cover, and structure and canopy cover. In addition, the contingent indicators of total nitrogen and phosphorous, turbidity, bank angle, thalweg depth profile and quantitative vegetation estimates (see the Data Structure and Attribute Information section for exact details on attributes). Data were collected and managed by BLM Field Offices, BLM Districts, and/or affiliated field crews with support from the BLM National Operations Center. Data are stored in a centralized database (BLM AIM Lotic Database) at the BLM National Operations Center.
Organization: Department of the Interior
Last updated: 2024-02-09T04:55:58.902367
Tags: aim, aim_ak, aim_az, aim_ca, aim_co, aim_id, aim_mtda, aim_natl, aim_nm, aim_nv, aim_orwa, aim_policy, aim_protocol, aim_tool, aim_ut, aim_wy, alaska, aquadat, aquatic, aquatics, arizona, biota, blm, boundaries, bug-lab, california, colorado, doi, endangered, environment, fish, geomorphology, geoscientificinformation, geospatial, grsg, health, hydrology, idaho, inlandwaters, lakes, landscape-monitoring-framework, lotic, macroinvertebrates, monitoring, monitoring-methods, montana, national, national-resources-inventory, nevada, new-mexico, oregon, projects, reach, riparian, rivers, science, streams, utah, utah-state-university, washington, water-quality, western-rivers-and-streams-assessment, wildlife, wyoming

Tables

Table 1

@usgov.doi_gov_blm_natl_aim_lotic_indicators_hub.table_1

1.51 MB
5903 rows
103 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "project" VARCHAR,
  "blm_adminstate" VARCHAR,
  "district" VARCHAR,
  "fieldoffice" VARCHAR,
  "evaluationid" VARCHAR,
  "pointid" VARCHAR,
  "streamname" VARCHAR,
  "fieldevaldate" VARCHAR,
  "sampledmidlatitude" DOUBLE,
  "sampledmidlongitude" DOUBLE,
  "bottomreachlatitude" DOUBLE,
  "bottomreachlongitude" DOUBLE,
  "topreachlatitude" DOUBLE,
  "topreachlongitude" DOUBLE,
  "protocolreachlength" DOUBLE,
  "protocoltype" VARCHAR,
  "protocolversion" VARCHAR,
  "fieldstatus" VARCHAR,
  "pointselectiontype" VARCHAR,
  "originaldesign" VARCHAR,
  "originalstratum" VARCHAR,
  "streamorder" BIGINT,
  "ecoregionstreamsize" VARCHAR,
  "pctoverheadcover" DOUBLE,
  "pctbankoverheadcover" DOUBLE,
  "vegcomplexity" DOUBLE,
  "vegcomplexitywoody" DOUBLE,
  "vegcomplexityunderstoryground" DOUBLE,
  "pctnoxiouswoodyspecies" DOUBLE,
  "pctnativewoodyspecies" DOUBLE,
  "pctnoxiousherbspecies" DOUBLE,
  "pctsedgerushspecies" DOUBLE,
  "pctequisetumspecies" DOUBLE,
  "invasiveinvertspecies" VARCHAR,
  "observedinvertrichness" DOUBLE,
  "expectedinvertrichness" DOUBLE,
  "oe_macroinvertebrate" DOUBLE,
  "mmi_macroinvertebrate" DOUBLE,
  "oe_mmi_modelused" VARCHAR,
  "oe_mmi_modelapplicability" VARCHAR,
  "macroinvertebratecount" DOUBLE,
  "totalnitrogen" DOUBLE,
  "totalphosphorous" DOUBLE,
  "specificconductance" DOUBLE,
  "ph" DOUBLE,
  "instanttemp" DOUBLE,
  "augtempavg" DOUBLE,
  "turbidityavg" DOUBLE,
  "poolcount" DOUBLE,
  "pctpools" DOUBLE,
  "poolfreq" DOUBLE,
  "respooldepthavg" DOUBLE,
  "lgwoodinchancount" DOUBLE,
  "lgwoodinchanfreq" DOUBLE,
  "lgwoodinchanvol" DOUBLE,
  "lgwoodabovechancount" DOUBLE,
  "lgwoodabovechanfreq" DOUBLE,
  "lgwoodabovechanvol" DOUBLE,
  "pctfineslessthan2mm" DOUBLE,
  "pctfineslessthan6mm" DOUBLE,
  "d16" DOUBLE,
  "d84" DOUBLE,
  "d50" DOUBLE,
  "geometricmeanparticlediam" DOUBLE,
  "pctpooltailfineslessthan2mm" DOUBLE,
  "pctpooltailfineslessthan6mm" DOUBLE,
  "pctbankcoveredmim" DOUBLE,
  "pctbankstable" DOUBLE,
  "pctbankcoveredstablemim" DOUBLE,
  "pctbankcoveredold" DOUBLE,
  "pctbankcoveredstableold" DOUBLE,
  "bankfullheightavg" DOUBLE,
  "benchheightavg" DOUBLE,
  "bankfulldepthavg" DOUBLE,
  "benchdepthavg" DOUBLE,
  "channelincision" DOUBLE,
  "floodplainconnectivity" DOUBLE,
  "instreamhabitatcomplexity" DOUBLE,
  "bankangleavg" DOUBLE,
  "pctbanksundercut" DOUBLE,
  "thalwegdepthcv" DOUBLE,
  "thalwegdepthavg" DOUBLE,
  "pctdry" DOUBLE,
  "bankfullwidthavg" DOUBLE,
  "wettedwidthavg" DOUBLE,
  "wettedwidthwithbaravg" DOUBLE,
  "entrenchmentriffle1" DOUBLE,
  "entrenchmentriffle2" DOUBLE,
  "pctslope" DOUBLE,
  "sinuosity" DOUBLE,
  "humaninfluence" VARCHAR,
  "beaverflowmod" VARCHAR,
  "beaversigns" VARCHAR,
  "waterwithdrawals" VARCHAR,
  "sidechannels" VARCHAR,
  "coresubset" VARCHAR,
  "supplementals" VARCHAR,
  "greenlinevegcomposition" VARCHAR,
  "evaluationid_old" VARCHAR
);