About this Dataset

Datasets To Evaluate The Effects Of Reducing The Standard Count Size On Multimetric Diatom Indices Of Ecological Condition For U.S. Rivers And Streams

The National Rivers and Stream Assessment 2008-2009 and 2013-2014 diatom datasets and associated site information.

This dataset is associated with the following publication:
Riato, L., J. Stoddard, A. Herlihy, and K. Blocksom. Reduced count size can provide a robust and more efficient diatom assessment of environmental conditions. Journal of Applied Ecology. Blackwell Publishing, Malden, MA, USA, 61(9): 2308-2320, (2024).
Organization: U.S. Environmental Protection Agency
Last updated: 2025-02-12T02:44:34.820890
Tags: diatom-valve-counting, ecological-assessment, genus-taxonomy, methodology-optimization, national-rivers-and-streams-assessment, reduction-in-counted-valves, traits

Tables

NRSA 2008–2009 Diatom Dataset

@usgov.epa_gov_datasets_to_evaluate_the_effects_of_reducing_t_4437d64e.nrsa_2008_2009_diatom_dataset

1.51 MB
2292 rows
1527 columns


CREATE TABLE nrsa_2008_2009_diatom_dataset (
  "uid" BIGINT,
  "achnanthes" BIGINT,
  "achnanthes_acares" BIGINT,
  "achnanthes_amoena" BIGINT,
  "achnanthes_brevipes" BIGINT,
  "achnanthes_brevipes_var_intermedia" BIGINT,
  "achnanthes_coarctata" BIGINT,
  "achnanthes_curtissima" BIGINT,
  "achnanthes_exigua_var_elliptica" BIGINT,
  "achnanthes_gracillima" BIGINT,
  "achnanthes_harveyi" BIGINT,
  "achnanthes_hintzii" BIGINT,
  "achnanthes_imperfecta" BIGINT,
  "achnanthes_inflata" BIGINT,
  "achnanthes_johncarteri" BIGINT,
  "achnanthes_kriegeri" BIGINT,
  "achnanthes_lemmermannii" BIGINT,
  "achnanthes_minuscula" BIGINT,
  "achnanthes_minutissima_var_jackii" BIGINT,
  "achnanthes_nitidiformis" BIGINT,
  "achnanthes_nodosa" BIGINT,
  "achnanthes_rechtensis" BIGINT,
  "achnanthes_reimeri" BIGINT,
  "achnanthes_reversa" BIGINT,
  "achnanthes_ricula" BIGINT,
  "achnanthes_sp_1_nls_eam" BIGINT,
  "achnanthes_sp_1_nrsa_lr" BIGINT,
  "achnanthes_stolida" BIGINT,
  "achnanthes_subhudsonis_var_kraeuselii" BIGINT,
  "achnanthes_submarina" BIGINT,
  "achnanthes_subrostrata_var_appalachiana" BIGINT,
  "achnanthes_thermalis" BIGINT,
  "achnanthidium" BIGINT,
  "achnanthidium_affine" BIGINT,
  "achnanthidium_alpestre" BIGINT,
  "achnanthidium_altergracillima" BIGINT,
  "achnanthidium_atomus" BIGINT,
  "achnanthidium_caledonicum" BIGINT,
  "achnanthidium_catenatum" BIGINT,
  "achnanthidium_crassum" BIGINT,
  "achnanthidium_deflexum" BIGINT,
  "achnanthidium_eutrophilum" BIGINT,
  "achnanthidium_exiguum" BIGINT,
  "achnanthidium_exiguum_var_constrictum" BIGINT,
  "achnanthidium_exilis" BIGINT,
  "achnanthidium_kranzii" BIGINT,
  "achnanthidium_latecephalum" BIGINT,
  "achnanthidium_macrocephalum" BIGINT,
  "achnanthidium_minutissimum" BIGINT,
  "achnanthidium_minutissimum_var_gracillima" BIGINT,
  "achnanthidium_pyrenaicum" BIGINT,
  "achnanthidium_rivulare" BIGINT,
  "achnanthidium_rosenstockii" BIGINT,
  "achnanthidium_saprophilum" BIGINT,
  "achnanthidium_semiapertum" BIGINT,
  "achnanthidium_sp_4_nawqa_eam" BIGINT,
  "achnanthidium_sp_5_nawqa_eam" BIGINT,
  "achnanthidium_thienemannii" BIGINT,
  "actinella_punctata" BIGINT,
  "actinocyclus_normanii" BIGINT,
  "actinocyclus_normanii_fo_subsalsus" BIGINT,
  "adlafia" BIGINT,
  "adlafia_bryophila" BIGINT,
  "adlafia_minuscula" BIGINT,
  "adlafia_minuscula_var_muralis" BIGINT,
  "adlafia_multnomahii" BIGINT,
  "adlafia_sp_1_nawqa_eam" BIGINT,
  "adlafia_suchlandtii" BIGINT,
  "amphipleura_pellucida" BIGINT,
  "amphora" BIGINT,
  "amphora_aequalis" BIGINT,
  "amphora_archibaldii" BIGINT,
  "amphora_coffeaeformis" BIGINT,
  "amphora_commutata" BIGINT,
  "amphora_copulata" BIGINT,
  "amphora_cymbamphora" BIGINT,
  "amphora_delicatissima" BIGINT,
  "amphora_fogediana" BIGINT,
  "amphora_holsatica" BIGINT,
  "amphora_inariensis" BIGINT,
  "amphora_laevissima" BIGINT,
  "amphora_montana" BIGINT,
  "amphora_normanii" BIGINT,
  "amphora_ocellata" BIGINT,
  "amphora_ovalis" BIGINT,
  "amphora_pediculus" BIGINT,
  "amphora_sabiniana" BIGINT,
  "amphora_sp_1_ans_wrc" BIGINT,
  "amphora_sublaevis" BIGINT,
  "amphora_thumensis" BIGINT,
  "amphora_turgida" BIGINT,
  "amphora_veneta" BIGINT,
  "aneumastus_apiculatus" BIGINT,
  "aneumastus_minor" BIGINT,
  "aneumastus_tuscula" BIGINT,
  "anomoeoneis_follis" BIGINT,
  "anomoeoneis_sphaerophora" BIGINT,
  "anomoeoneis_sphaerophora_fo_costata" BIGINT,
  "astartiella_bahusiensis" BIGINT,
  "asterionella_formosa" BIGINT
);

NRSA 2013–2014 Diatom Dataset

@usgov.epa_gov_datasets_to_evaluate_the_effects_of_reducing_t_4437d64e.nrsa_2013_2014_diatom_dataset

1.58 MB
1935 rows
1673 columns


CREATE TABLE nrsa_2013_2014_diatom_dataset (
  "uid" BIGINT,
  "achnanthes_acares" BIGINT,
  "achnanthes_brevipes" BIGINT,
  "achnanthes_brevipes_var_intermedia" BIGINT,
  "achnanthes_cf_trinodis" BIGINT,
  "achnanthes_coarctata" BIGINT,
  "achnanthes_curvirostrum" BIGINT,
  "achnanthes_elata" BIGINT,
  "achnanthes_exigua_var_elliptica" BIGINT,
  "achnanthes_inflata" BIGINT,
  "achnanthes_lanceolata_var_lanceolatoides" BIGINT,
  "achnanthes_minuscula" BIGINT,
  "achnanthes_minutissima_var_robusta" BIGINT,
  "achnanthes_reversa" BIGINT,
  "achnanthes_ricula" BIGINT,
  "achnanthes_sp_1" BIGINT,
  "achnanthes_spp" BIGINT,
  "achnanthes_stolida" BIGINT,
  "achnanthes_subhudsonis_var_kraeuselii" BIGINT,
  "achnanthes_submarina" BIGINT,
  "achnanthes_subrostrata_var_appalachiana" BIGINT,
  "achnanthes_tenera" BIGINT,
  "achnanthes_thermalis" BIGINT,
  "achnanthes_trinodis" BIGINT,
  "achnanthes_tumescens" BIGINT,
  "achnanthidium_affine" BIGINT,
  "achnanthidium_alpestre" BIGINT,
  "achnanthidium_altergracillima" BIGINT,
  "achnanthidium_atomus" BIGINT,
  "achnanthidium_caledonicum" BIGINT,
  "achnanthidium_catenatum" BIGINT,
  "achnanthidium_cf_gracillimum" BIGINT,
  "achnanthidium_cf_latecephalum" BIGINT,
  "achnanthidium_cf_minutissimum" BIGINT,
  "achnanthidium_crassum" BIGINT,
  "achnanthidium_deflexum" BIGINT,
  "achnanthidium_druartii" BIGINT,
  "achnanthidium_duthiei" BIGINT,
  "achnanthidium_eutrophilum" BIGINT,
  "achnanthidium_exiguum" BIGINT,
  "achnanthidium_exiguum_var_constrictum" BIGINT,
  "achnanthidium_exiguum_var_heterovalvum" BIGINT,
  "achnanthidium_exilis" BIGINT,
  "achnanthidium_gracillimum" BIGINT,
  "achnanthidium_jackii" BIGINT,
  "achnanthidium_kranzii" BIGINT,
  "achnanthidium_kriegeri" BIGINT,
  "achnanthidium_latecephalum" BIGINT,
  "achnanthidium_macrocephalum" BIGINT,
  "achnanthidium_microcephalum" BIGINT,
  "achnanthidium_minutissimum" BIGINT,
  "achnanthidium_minutissimum_fo_inconspicuum" BIGINT,
  "achnanthidium_pyrenaicum" BIGINT,
  "achnanthidium_reimeri" BIGINT,
  "achnanthidium_rivulare" BIGINT,
  "achnanthidium_saprophilum" BIGINT,
  "achnanthidium_semiapertum" BIGINT,
  "achnanthidium_sp" BIGINT,
  "achnanthidium_sp_1" BIGINT,
  "achnanthidium_sp_1_nrsa2_jah" BIGINT,
  "achnanthidium_sp_5_nawqa_eam" BIGINT,
  "achnanthidium_spp" BIGINT,
  "achnanthidium_strictum" BIGINT,
  "achnanthidium_subsalsa" BIGINT,
  "achnanthidium_thienemannii" BIGINT,
  "actinella_punctata" BIGINT,
  "actinella_sp_1" BIGINT,
  "actinocyclus_normanii" BIGINT,
  "actinocyclus_normanii_fo_subsalsus" BIGINT,
  "actinocyclus_subtilis" BIGINT,
  "actinoptychus_senarius" BIGINT,
  "adlafia_aquaeductae" BIGINT,
  "adlafia_bryophila" BIGINT,
  "adlafia_minuscula" BIGINT,
  "adlafia_minuscula_var_muralis" BIGINT,
  "adlafia_multnomahii" BIGINT,
  "adlafia_sp" BIGINT,
  "adlafia_suchlandtii" BIGINT,
  "amphipleura_pellucida" BIGINT,
  "amphora_aequalis" BIGINT,
  "amphora_angusta" BIGINT,
  "amphora_archibaldii" BIGINT,
  "amphora_birugula" BIGINT,
  "amphora_copulata" BIGINT,
  "amphora_cymbamphora" BIGINT,
  "amphora_delicatissima" BIGINT,
  "amphora_exigua" BIGINT,
  "amphora_fogediana" BIGINT,
  "amphora_inariensis" BIGINT,
  "amphora_laevissima" BIGINT,
  "amphora_minutissima" BIGINT,
  "amphora_ocellata" BIGINT,
  "amphora_ovalis" BIGINT,
  "amphora_pediculus" BIGINT,
  "amphora_sp" BIGINT,
  "amphora_sp_1" BIGINT,
  "amphora_sp_1_ans_wrc" BIGINT,
  "amphora_sp_2" BIGINT,
  "amphora_spp" BIGINT,
  "amphora_sulcata" BIGINT
);

Site Info 2008–2014

@usgov.epa_gov_datasets_to_evaluate_the_effects_of_reducing_t_4437d64e.site_info_2008_2014

166.44 KB
4598 rows
10 columns


CREATE TABLE site_info_2008_2014 (
  "site_id" VARCHAR,
  "visit_no" DOUBLE,
  "year" DOUBLE,
  "ecowsa9_2015" VARCHAR,
  "comid" DOUBLE,
  "uid" DOUBLE,
  "state" VARCHAR,
  "valxsite" VARCHAR,
  "lat_dd83" DOUBLE,
  "lon_dd83" DOUBLE
);