Baselight
Sign In

Nutrient Explorer Application Default Datasets From LAGOS-NE And National Nutrient Inventories

U.S. Environmental Protection Agency

@usgov.epa_gov_nutrient_explorer_application_default_datasets_4c6da922

Loading...
Loading...

About this Dataset

Nutrient Explorer Application Default Datasets From LAGOS-NE And National Nutrient Inventories

This dataset contains the default data provided with the Nutrient Explorer Downloadable application (SI: https://cfpub.epa.gov/si/si_public_record_Report.cfm?Lab=CPHEA&dirEntryId=358039), which is used for testing out the features and capabilities of the app. The dataset is based off of LAGOS-NE, lake total nitrogen and total phosphorus concentration data from lakes in the Northeast United States and is combined with a number of explanatory variables such as geology, land use, climate, nutrient inputs, and lake characteristics. Portions of this dataset are inaccessible because: The *.RData format is not allowed to be uploaded on ScienceHub (see above response). They can be accessed through the following means: The *.RData files can be accessed when the user downloaded the NutrientExplorer application zip files on the ScienceInventory link: https://cfpub.epa.gov/si/si_public_record_Report.cfm?Lab=CPHEA&dirEntryId=358039.
The user need to have RStudio installed to open the application and be able to use the RData files. Format: Some of the data files associated with the Nutrient Explorer application are in the *.RData format, which can not be uploaded to ScienceHub. These files include hydrologic unit (HU8) watershed shapefiles and some datasets similar to the *.csv files uploaded here containing variables used for testing out the application's features.

This dataset is associated with the following publication:
Pennino, M., M. Fry, R. Sabo, and J. Carleton. Nutrient Explorer: An analytical framework to visualize and investigate drivers of surface water quality. ENVIRONMENTAL MODELLING & SOFTWARE. Elsevier Science, New York, NY, 170: 105853, (2023).
Organization: U.S. Environmental Protection Agency
Last updated: 2024-05-25T12:31:33.325755
Tags: lake-water-quality, multilinear-regression, nitrogen-and-co-pollutants, phosphorus, random-forest-modeling

Tables

HUC8–2007 7 Average MaxDepth

@usgov.epa_gov_nutrient_explorer_application_default_datasets_4c6da922.huc8_2007_7_average_maxdepth
  • 747.52 kB
  • 511 rows
  • 129 columns
Loading... 
CREATE TABLE huc8_2007_7_average_maxdepth (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "huc8" BIGINT,
  "iws_ha" DOUBLE,
  "elevation" VARCHAR,
  "lake_area_ha" VARCHAR,
  "lake_perim_meters" VARCHAR,
  "iws_slope_mean" DOUBLE,
  "iws_roaddensity_density_mperha" DOUBLE,
  "iws_canopy2001_mean" DOUBLE,
  "iws_damdensity_pointsperha" DOUBLE,
  "hu2" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "nlcd_pct_0" DOUBLE,
  "nlcd_pct_11" DOUBLE,
  "nlcd_pct_31" DOUBLE,
  "nlcd_pct_52" DOUBLE,
  "nlcd_pct_71" DOUBLE,
  "nlcd_pct_developed" DOUBLE,
  "nlcd_pct_forest" DOUBLE,
  "nlcd_pct_farm" DOUBLE,
  "nlcd_pct_wetlands" DOUBLE,
  "p_crop_removal_1" VARCHAR,
  "p_f_fertilizer_1" VARCHAR,
  "legacy_p_1" VARCHAR,
  "p_livestock_waste_1" VARCHAR,
  "p_nf_fertilizer_1" VARCHAR,
  "p_deposition_1" VARCHAR,
  "p_human_waste_kg_1" VARCHAR,
  "p_kg_ww_1" VARCHAR,
  "recovered_p_1" VARCHAR,
  "p_ag_surplus_1" VARCHAR,
  "napi_1" VARCHAR,
  "p_ag_inputs_1" VARCHAR,
  "p_anthro_inputs_1" VARCHAR,
  "n_cbnf_1" DOUBLE,
  "n_crop_n_rem_1" DOUBLE,
  "n_fert_farm_1" DOUBLE,
  "n_fert_urban_1" VARCHAR,
  "n_forest_fire_1" DOUBLE,
  "human_n_demand_1" DOUBLE,
  "n_human_waste_1" DOUBLE,
  "n_imp_balance_1" DOUBLE,
  "n_livestock_waste_1" DOUBLE,
  "n_manure_recov_1" DOUBLE,
  "n_rock_1" DOUBLE,
  "n_total_deposition_1" DOUBLE,
  "n_total_nbnf_1" DOUBLE,
  "n_ag_surplus_1" DOUBLE,
  "nani_1" VARCHAR,
  "n_ag_inputs_1" DOUBLE,
  "n_anthro_inputs_1" VARCHAR,
  "aerosolsize_aqua_lag3" VARCHAR,
  "aerosolsize_aqua_lag2" VARCHAR,
  "aerosolsize_aqua_lag1" VARCHAR,
  "aerosolsize_aqua" VARCHAR,
  "aerosolsize_aqua_yrmean" VARCHAR,
  "aerosolsize_terra_lag3" VARCHAR,
  "aerosolsize_terra_lag2" VARCHAR,
  "aerosolsize_terra_lag1" VARCHAR,
  "aerosolsize_terra" VARCHAR,
  "aerosolsize_terra_yrmean" VARCHAR,
  "aod_aqua_lag3" VARCHAR,
  "aod_aqua_lag2" VARCHAR,
  "aod_aqua_lag1" VARCHAR,
  "aod_aqua" VARCHAR,
  "aod_aqua_yrmean" VARCHAR,
  "aod_terra_lag3" VARCHAR,
  "aod_terra_lag2" VARCHAR,
  "aod_terra_lag1" VARCHAR,
  "aod_terra" VARCHAR,
  "aod_terra_yrmean" VARCHAR,
  "snow_lag3" VARCHAR,
  "snow_lag2" VARCHAR,
  "snow_lag1" VARCHAR,
  "snow" VARCHAR,
  "snow_yrmean" VARCHAR,
  "fire_lag3" VARCHAR,
  "fire_lag2" VARCHAR,
  "fire_lag1" VARCHAR,
  "fire" VARCHAR,
  "fire_yrmean" VARCHAR,
  "lst_lag3" VARCHAR,
  "lst_lag2" VARCHAR,
  "lst_lag1" VARCHAR,
  "lst" VARCHAR,
  "lst_yrmean" VARCHAR,
  "lstanomaly_lag3" VARCHAR,
  "lstanomaly_lag2" VARCHAR,
  "lstanomaly_lag1" VARCHAR,
  "lstanomaly" VARCHAR,
  "lstanomaly_yrmean" VARCHAR,
  "precip_lag3" VARCHAR,
  "precip_lag2" VARCHAR,
  "precip_lag1" VARCHAR,
  "precip" VARCHAR,
  "precip_yrmean" VARCHAR,
  "tmax_lag3" VARCHAR,
  "tmax_lag2" VARCHAR,
  "tmax_lag1" VARCHAR
);

HUC8–2007 7 Average MaxDepth2

@usgov.epa_gov_nutrient_explorer_application_default_datasets_4c6da922.huc8_2007_7_average_maxdepth2
  • 690.77 kB
  • 511 rows
  • 130 columns
Loading... 
CREATE TABLE huc8_2007_7_average_maxdepth2 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "huc8" BIGINT,
  "iws_ha" DOUBLE,
  "elevation" VARCHAR,
  "lake_area_ha" VARCHAR,
  "lake_perim_meters" VARCHAR,
  "iws_slope_mean" DOUBLE,
  "iws_roaddensity_density_mperha" DOUBLE,
  "iws_canopy2001_mean" DOUBLE,
  "iws_damdensity_pointsperha" DOUBLE,
  "hu2" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "nlcd_pct_0" DOUBLE,
  "nlcd_pct_11" DOUBLE,
  "nlcd_pct_31" DOUBLE,
  "nlcd_pct_52" DOUBLE,
  "nlcd_pct_71" DOUBLE,
  "nlcd_pct_developed" DOUBLE,
  "nlcd_pct_forest" DOUBLE,
  "nlcd_pct_farm" DOUBLE,
  "nlcd_pct_wetlands" DOUBLE,
  "p_crop_removal_1" VARCHAR,
  "p_f_fertilizer_1" VARCHAR,
  "legacy_p_1" VARCHAR,
  "p_livestock_waste_1" VARCHAR,
  "p_nf_fertilizer_1" VARCHAR,
  "p_deposition_1" VARCHAR,
  "p_human_waste_kg_1" VARCHAR,
  "p_kg_ww_1" VARCHAR,
  "recovered_p_1" VARCHAR,
  "p_ag_surplus_1" VARCHAR,
  "napi_1" VARCHAR,
  "p_ag_inputs_1" VARCHAR,
  "p_anthro_inputs_1" VARCHAR,
  "n_cbnf_1" DOUBLE,
  "n_crop_n_rem_1" DOUBLE,
  "n_fert_farm_1" DOUBLE,
  "n_fert_urban_1" VARCHAR,
  "n_forest_fire_1" DOUBLE,
  "human_n_demand_1" DOUBLE,
  "n_human_waste_1" DOUBLE,
  "n_imp_balance_1" DOUBLE,
  "n_livestock_waste_1" DOUBLE,
  "n_manure_recov_1" DOUBLE,
  "n_rock_1" DOUBLE,
  "n_total_deposition_1" DOUBLE,
  "n_total_nbnf_1" DOUBLE,
  "n_ag_surplus_1" DOUBLE,
  "nani_1" VARCHAR,
  "n_ag_inputs_1" DOUBLE,
  "n_anthro_inputs_1" VARCHAR,
  "aerosolsize_aqua_lag3" VARCHAR,
  "aerosolsize_aqua_lag2" VARCHAR,
  "aerosolsize_aqua_lag1" VARCHAR,
  "aerosolsize_aqua" VARCHAR,
  "aerosolsize_aqua_yrmean" VARCHAR,
  "aerosolsize_terra_lag3" VARCHAR,
  "aerosolsize_terra_lag2" VARCHAR,
  "aerosolsize_terra_lag1" VARCHAR,
  "aerosolsize_terra" VARCHAR,
  "aerosolsize_terra_yrmean" VARCHAR,
  "aod_aqua_lag3" VARCHAR,
  "aod_aqua_lag2" VARCHAR,
  "aod_aqua_lag1" VARCHAR,
  "aod_aqua" VARCHAR,
  "aod_aqua_yrmean" VARCHAR,
  "aod_terra_lag3" VARCHAR,
  "aod_terra_lag2" VARCHAR,
  "aod_terra_lag1" VARCHAR,
  "aod_terra" VARCHAR,
  "aod_terra_yrmean" VARCHAR,
  "snow_lag3" VARCHAR,
  "snow_lag2" VARCHAR,
  "snow_lag1" VARCHAR,
  "snow" VARCHAR,
  "snow_yrmean" VARCHAR,
  "fire_lag3" VARCHAR,
  "fire_lag2" VARCHAR,
  "fire_lag1" VARCHAR,
  "fire" VARCHAR,
  "fire_yrmean" VARCHAR,
  "lst_lag3" VARCHAR,
  "lst_lag2" VARCHAR,
  "lst_lag1" VARCHAR,
  "lst" VARCHAR,
  "lst_yrmean" VARCHAR,
  "lstanomaly_lag3" VARCHAR,
  "lstanomaly_lag2" VARCHAR,
  "lstanomaly_lag1" VARCHAR,
  "lstanomaly" VARCHAR,
  "lstanomaly_yrmean" VARCHAR,
  "precip_lag3" VARCHAR,
  "precip_lag2" VARCHAR,
  "precip_lag1" VARCHAR,
  "precip" VARCHAR,
  "precip_yrmean" VARCHAR,
  "tmax_lag3" VARCHAR,
  "tmax_lag2" VARCHAR,
  "tmax_lag1" VARCHAR
);

LAGOS Data 5000Rows

@usgov.epa_gov_nutrient_explorer_application_default_datasets_4c6da922.lagos_data_5000rows
  • 2.13 MB
  • 4,999 rows
  • 314 columns
Loading... 
CREATE TABLE lagos_data_5000rows (
  "name" VARCHAR,
  "lagos_lake_id" BIGINT,
  "hu8zoneid" VARCHAR,
  "hu8" BIGINT,
  "hu2" BIGINT,
  "programname" VARCHAR,
  "programtype" VARCHAR,
  "iws_zoneid" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "date" TIMESTAMP,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "iws_ha" DOUBLE,
  "iws_perimkm" DOUBLE,
  "iws_lakeareaha" DOUBLE,
  "iws_pct_in_usa" DOUBLE,
  "elevation" DOUBLE,
  "lake_area_ha" DOUBLE,
  "lake_perim_meters" DOUBLE,
  "meandepth" VARCHAR,
  "maxdepth" VARCHAR,
  "tn" VARCHAR,
  "logtn" VARCHAR,
  "tn_qual" VARCHAR,
  "tn_censorcode" VARCHAR,
  "tn_detectionlimit" VARCHAR,
  "tn_labmethodname" VARCHAR,
  "tp" VARCHAR,
  "logtp" VARCHAR,
  "tp_qual" VARCHAR,
  "tp_censorcode" VARCHAR,
  "tp_detectionlimit" VARCHAR,
  "tp_labmethodname" VARCHAR,
  "chla" VARCHAR,
  "chla_qual" VARCHAR,
  "chla_censorcode" VARCHAR,
  "chla_detectionlimit" VARCHAR,
  "chla_labmethodname" VARCHAR,
  "chla_methodinfo" VARCHAR,
  "colora" VARCHAR,
  "colora_qual" VARCHAR,
  "colora_censorcode" VARCHAR,
  "colora_detectionlimit" VARCHAR,
  "colora_labmethodname" VARCHAR,
  "colort" VARCHAR,
  "colort_qual" VARCHAR,
  "colort_censorcode" VARCHAR,
  "colort_detectionlimit" VARCHAR,
  "colort_labmethodname" VARCHAR,
  "dkn" VARCHAR,
  "dkn_qual" VARCHAR,
  "dkn_censorcode" VARCHAR,
  "dkn_detectionlimit" VARCHAR,
  "dkn_labmethodname" VARCHAR,
  "doc" VARCHAR,
  "doc_qual" VARCHAR,
  "doc_censorcode" VARCHAR,
  "doc_detectionlimit" VARCHAR,
  "doc_labmethodname" VARCHAR,
  "nh4" VARCHAR,
  "nh4_qual" VARCHAR,
  "nh4_censorcode" VARCHAR,
  "nh4_detectionlimit" VARCHAR,
  "nh4_labmethodname" VARCHAR,
  "nh4_methodinfo" VARCHAR,
  "no2" VARCHAR,
  "no2_qual" VARCHAR,
  "no2_censorcode" VARCHAR,
  "no2_detectionlimit" VARCHAR,
  "no2_labmethodname" VARCHAR,
  "no2no3" VARCHAR,
  "no2no3_qual" VARCHAR,
  "no2no3_censorcode" VARCHAR,
  "no2no3_detectionlimit" VARCHAR,
  "no2no3_labmethodname" VARCHAR,
  "srp" VARCHAR,
  "srp_qual" VARCHAR,
  "srp_censorcode" VARCHAR,
  "srp_detectionlimit" VARCHAR,
  "srp_labmethodname" VARCHAR,
  "tdn" VARCHAR,
  "tdn_qual" VARCHAR,
  "tdn_censorcode" VARCHAR,
  "tdn_detectionlimit" VARCHAR,
  "tdn_labmethodname" VARCHAR,
  "tdp" VARCHAR,
  "tdp_qual" VARCHAR,
  "tdp_censorcode" VARCHAR,
  "tdp_detectionlimit" VARCHAR,
  "tdp_labmethodname" VARCHAR,
  "tkn" VARCHAR,
  "tkn_qual" VARCHAR,
  "tkn_censorcode" VARCHAR,
  "tkn_detectionlimit" VARCHAR,
  "tkn_labmethodname" VARCHAR,
  "toc" VARCHAR,
  "toc_qual" VARCHAR,
  "toc_censorcode" VARCHAR
);

Share link

Anyone who has the link will be able to view this.