BLM Natl AIM Lotic Indicators Hub
Department of the Interior
@usgov.doi_gov_blm_natl_aim_lotic_indicators_hub_5d150
Department of the Interior
@usgov.doi_gov_blm_natl_aim_lotic_indicators_hub_5d150
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: 2025-09-25T03:01:35.503266
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
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
);
Anyone who has the link will be able to view this.