About this Dataset

Data For "Ecological Condition Of Mountain Lakes In The Conterminous US And Vulnerability To Human Development"

Tabular data associated with the article "Ecological condition of mountain lakes in the conterminous United States and vulnerability to human development". All tabular data for lake, catchment, and watershed characteristics and population condition estimates are included.

This dataset is associated with the following publication:
Handler, A., M. Weber, M. Dumelle, L. Jansen, J. Carleton, B. Schaeffer, S. Paulsen, T. Barnum, A. Rea, A. Neale, and J. Compton. Ecological condition of mountain lakes in the conterminous United States and vulnerability to human development. ECOLOGICAL INDICATORS. Elsevier Science Ltd, New York, NY, USA, 173: 113402, (2025).
Organization: U.S. Environmental Protection Agency
Last updated: 2025-03-13T15:04:14.520543
Tags: condition, framework, lake, mountain, nitrogen-and-co-pollutants

Tables

MtnLakes ExampleMtnLakes

@usgov.epa_gov_data_for_ecological_condition_of_mountain_lake_57058801.mtnlakes_examplemtnlakes

5.04 kB
19 rows
5 columns

CREATE TABLE mtnlakes_examplemtnlakes (
  "name" VARCHAR,
  "state" VARCHAR,
  "range" VARCHAR,
  "pct_mtn_area" BIGINT,
  "citation" VARCHAR
);

MtnLakes ExampleMtnLakesMetadata

@usgov.epa_gov_data_for_ecological_condition_of_mountain_lake_57058801.mtnlakes_examplemtnlakesmetadata

4.15 kB
5 rows
5 columns

CREATE TABLE mtnlakes_examplemtnlakesmetadata (
  "variable" VARCHAR,
  "description" VARCHAR,
  "type" VARCHAR,
  "values" VARCHAR,
  "units" VARCHAR
);

MtnLakes PopEst 5PctMtn

@usgov.epa_gov_data_for_ecological_condition_of_mountain_lake_57058801.mtnlakes_popest_5pctmtn

27.28 kB
216 rows
15 columns

CREATE TABLE mtnlakes_popest_5pctmtn (
  "type" VARCHAR,
  "subpopulation" VARCHAR,
  "indicator" VARCHAR,
  "category" VARCHAR,
  "nresp" BIGINT,
  "estimate_p" DOUBLE,
  "stderror_p" DOUBLE,
  "marginoferror_p" DOUBLE,
  "lcb95pct_p" DOUBLE,
  "ucb95pct_p" DOUBLE,
  "estimate_u" DOUBLE,
  "stderror_u" DOUBLE,
  "marginoferror_u" DOUBLE,
  "lcb95pct_u" DOUBLE,
  "ucb95pct_u" DOUBLE
);

MtnLakes PopEst Metadata

@usgov.epa_gov_data_for_ecological_condition_of_mountain_lake_57058801.mtnlakes_popest_metadata

5.25 kB
15 rows
5 columns

CREATE TABLE mtnlakes_popest_metadata (
  "variable" VARCHAR,
  "description" VARCHAR,
  "type" VARCHAR,
  "values" VARCHAR,
  "units" VARCHAR
);

MtnLakes PopEst PercentTest

@usgov.epa_gov_data_for_ecological_condition_of_mountain_lake_57058801.mtnlakes_popest_percenttest

60.6 kB
675 rows
15 columns

CREATE TABLE mtnlakes_popest_percenttest (
  "type" VARCHAR,
  "subpopulation" VARCHAR,
  "indicator" VARCHAR,
  "category" VARCHAR,
  "nresp" BIGINT,
  "estimate_p" DOUBLE,
  "stderror_p" DOUBLE,
  "marginoferror_p" DOUBLE,
  "lcb95pct_p" DOUBLE,
  "ucb95pct_p" DOUBLE,
  "estimate_u" DOUBLE,
  "stderror_u" DOUBLE,
  "marginoferror_u" DOUBLE,
  "lcb95pct_u" DOUBLE,
  "ucb95pct_u" DOUBLE
);

MtnLakes SampledLakesMetadata

@usgov.epa_gov_data_for_ecological_condition_of_mountain_lake_57058801.mtnlakes_sampledlakesmetadata

6.71 kB
65 rows
5 columns

CREATE TABLE mtnlakes_sampledlakesmetadata (
  "variable" VARCHAR,
  "description" VARCHAR,
  "type" VARCHAR,
  "values" VARCHAR,
  "units" VARCHAR
);