Combined NRSA Benthic Macroinvertebrate Indices And Landscape Data For Random Forest Analysis.
U.S. Environmental Protection Agency
@usgov.epa_gov_combined_nrsa_benthic_macroinvertebrate_indice_d2bb50ea
U.S. Environmental Protection Agency
@usgov.epa_gov_combined_nrsa_benthic_macroinvertebrate_indice_d2bb50ea
Combined benthic macroinvertebrate indices and landscape data used in random forest analysis. Data is from the 2008/2009 National Rivers and Streams Assessment. All data and meta data are also available on the US EPA NARS website. Citation information for this dataset can be found in Data.gov's References section.
Organization: U.S. Environmental Protection Agency
Last updated: 2023-08-26T19:41:43.848682
Tags: benthic-macroinvertebrate-index, landscape-data, random-forest-analysis
CREATE TABLE combinednrsa0809 (
"uid" BIGINT,
"site_id_x" VARCHAR,
"bent_mmi_cond" VARCHAR,
"mmi_bent" DOUBLE,
"visit_no_x" BIGINT,
"aggr_eco9_2015" VARCHAR,
"strahlerorder" VARCHAR,
"chirdom1pind" DOUBLE,
"chirdom3pind" DOUBLE,
"chirdom5pind" DOUBLE,
"dom1pind" DOUBLE,
"dom3pind" DOUBLE,
"dom5pind" DOUBLE,
"ept_ntax" BIGINT,
"ept_pind" DOUBLE,
"ept_ptax" DOUBLE,
"lrbs_use" DOUBLE,
"l_xfc_nat" DOUBLE,
"l_xcmgw" DOUBLE,
"w1_hall" DOUBLE,
"maflowu" DOUBLE,
"maflowv" DOUBLE,
"nhdwat_nadp2009_mean_nh4" DOUBLE,
"nhdwat_nadp2009_mean_no3" DOUBLE,
"nhdwat_nadp2009_mean_so4" DOUBLE,
"nhdwat_nadp2009_mean_totaln" DOUBLE,
"nhdwat_elev" DOUBLE,
"nhdwat_slope" DOUBLE,
"nhdwat_pct_canopy" DOUBLE,
"nhdwat_pct_imperv" DOUBLE,
"nhdwat_popdenkm" DOUBLE,
"rdden" DOUBLE,
"nhdwat_pct_sand" DOUBLE,
"tmax_ann" DOUBLE,
"tmin_ann" DOUBLE,
"wsarea_nars" DOUBLE,
"pct_ag" DOUBLE,
"pct_urb" DOUBLE,
"pct_for" DOUBLE,
"pct_wet" DOUBLE,
"pct_shrub_grass" DOUBLE
);Anyone who has the link will be able to view this.