About this Dataset

Datasets To Develop And Validate The Genus-level, Trait-based Multimetric Diatom Indices For Assessing The Ecological Condition Of River And Stream Across The Conterminous United States

Data is from National Aquatic Resource Surveys.

This dataset is associated with the following publication:
Riato, L., R. Hill, A. Herlihy, D. Peck, P. Kaufmann, J. Stoddard, and S. Paulsen. Genus-level, trait-based multimetric diatom indices for assessing the ecological condition of river and stream across the conterminous United States.. ECOLOGICAL INDICATORS. Elsevier Science Ltd, New York, NY, USA, 141: 109131, (2022).
Organization: U.S. Environmental Protection Agency
Last updated: 2024-06-09T14:27:16.874216
Tags: diatoms, ecological-assessment, genus-taxonomy, national-rivers-and-streams-assessment, taxonomic-inconsistency, traits

Tables

NRSA 2008–2009 Diatom Dataset

@usgov.epa_gov_datasets_to_develop_and_validate_the_genus_lev_fcd8d854.nrsa_2008_2009_diatom_dataset

1.58 MB
2,292 rows
1,527 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 Brevipes Var. Intermedia,
  "achnanthes_coarctata" BIGINT,
  "achnanthes_curtissima" BIGINT,
  "achnanthes_exigua_var_elliptica" BIGINT  -- Achnanthes Exigua Var. Elliptica,
  "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 Minutissima Var. Jackii,
  "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 NLS EAM,
  "achnanthes_sp_1_nrsa_lr" BIGINT  -- Achnanthes Sp. 1 NRSA LR,
  "achnanthes_stolida" BIGINT,
  "achnanthes_subhudsonis_var_kraeuselii" BIGINT  -- Achnanthes Subhudsonis Var. Kraeuselii,
  "achnanthes_submarina" BIGINT,
  "achnanthes_subrostrata_var_appalachiana" BIGINT  -- Achnanthes Subrostrata Var. Appalachiana,
  "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 Exiguum Var. Constrictum,
  "achnanthidium_exilis" BIGINT,
  "achnanthidium_kranzii" BIGINT,
  "achnanthidium_latecephalum" BIGINT,
  "achnanthidium_macrocephalum" BIGINT,
  "achnanthidium_minutissimum" BIGINT,
  "achnanthidium_minutissimum_var_gracillima" BIGINT  -- Achnanthidium Minutissimum Var. Gracillima,
  "achnanthidium_pyrenaicum" BIGINT,
  "achnanthidium_rivulare" BIGINT,
  "achnanthidium_rosenstockii" BIGINT,
  "achnanthidium_saprophilum" BIGINT,
  "achnanthidium_semiapertum" BIGINT,
  "achnanthidium_sp_4_nawqa_eam" BIGINT  -- Achnanthidium Sp. 4 NAWQA EAM,
  "achnanthidium_sp_5_nawqa_eam" BIGINT  -- Achnanthidium Sp. 5 NAWQA EAM,
  "achnanthidium_thienemannii" BIGINT,
  "actinella_punctata" BIGINT,
  "actinocyclus_normanii" BIGINT,
  "actinocyclus_normanii_fo_subsalsus" BIGINT  -- Actinocyclus Normanii Fo. Subsalsus,
  "adlafia" BIGINT,
  "adlafia_bryophila" BIGINT,
  "adlafia_minuscula" BIGINT,
  "adlafia_minuscula_var_muralis" BIGINT  -- Adlafia Minuscula Var. Muralis,
  "adlafia_multnomahii" BIGINT,
  "adlafia_sp_1_nawqa_eam" BIGINT  -- Adlafia Sp. 1 NAWQA EAM,
  "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 Sp. 1 ANS WRC,
  "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  -- Anomoeoneis Sphaerophora Fo. Costata,
  "astartiella_bahusiensis" BIGINT,
  "asterionella_formosa" BIGINT
);