Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/22a1c209f19f303271ddab8aaa70402d Name: Carp lakes water chemistry data, 2018-2020 Description: The data table contains the summer water column total phosphorus, soluble reactive phosphorus, total nitrogen, nitrate, suspended solids, chlorophyll-a, and phycocyanin concentrations as well as Secchi depth for 8 lakes in northwest Iowa, USA. These data were compiled from research conducted by the Iowa State University Limnology Laboratory and two Iowa DNR monitoring programs, the Ambient Lakes and Shallow Lakes Monitoring Programs. These data were compiled and QAQC-ed by Ellen Albright and Grace Wilkinson. Number of Records: 283 Number of Columns: 29
Table StructureObject Name: 1_Carp_WQ_2018-2020.csv Size: 34130 byte Authentication: 87daa3edbc4fa90685d2c770e00143da
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions year sample_id zoop_id program lake_name lake_id depth doy year_frac secchi_m secchi_flag tss_mgL tss_flag vss_mgL vss_flag iss_mgL iss_flag tp_ugL tp_flag srp_ugL srp_flag tn_mgL tn_flag nox_mgL nox_flag chl_ugL chl_flag phyco_ugL phyco_flag Column Name: year sample_id zoop_id program lake_name lake_id depth doy year_frac secchi_m secchi_flag tss_mgL tss_flag vss_mgL vss_flag iss_mgL iss_flag tp_ugL tp_flag srp_ugL srp_flag tn_mgL tn_flag nox_mgL nox_flag chl_ugL chl_flag phyco_ugL phyco_flag Definition: Sampling year (2018, 2019, 2020) Unique sample identifier for the ISU Limnology Lab database Sample identifier for corresponding zooplankton tow taken on the sample sampling day Monitoring project responsible for data collection Lake name Unique lake identifier for the ISU Limnology Lab database Identifier for water depth at which samples were collected Julian day of year when water samples were collected Sampling date given as the fraction of the year Secchi depth Data flag for Secchi depth Total suspended solids concentration Data flag for total suspended solids Volatile suspended solids concentration Data flag for volatile suspended solids Involatile suspended solids concentration Data flag for involatile suspended solids Concentration of total phosphorus Data flag for total phosphorus Concentration of soluble reactive phosphorus Data flag for soluble reactive phosphorus Total nitrogen concentration Data flag for total nitrogen Nitrate concentration Data flag for nitrate Chlorophyll-a concentration Data flag for chlorophyll-a Phycocyanin concentration Data flag for phycocyanin Storage Type: dateTime string string string string string string float float float string float string float string float string float string float string float string float string float string float string Measurement Type: dateTime nominal nominal nominal nominal nominal nominal ratio ratio ratio nominal ratio nominal ratio nominal ratio nominal ratio nominal ratio nominal ratio nominal ratio nominal ratio nominal ratio nominal Measurement Values Domain: Definition Unique sample identifier for the ISU Limnology Lab database
Definition Sample identifier for corresponding zooplankton tow taken on the sample sampling day
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code ALM Definition Ambient Lakes Monitoring Program (Iowa DNR) Source
Code Definition Code Carp Definition Intensive monitoring by Iowa State University Limnology Lab, lakes with incentivized carp harvest Source
Code Definition Code ShallowLakes Definition Iowa DNR monitoring for shallow waters Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Blue Definition Blue Lake Source
Code Definition Code Center Definition Center Lake Source
Code Definition Code Five Island Definition Five Island Lake Source
Code Definition Code North Twin Definition North Twin Lake Source
Code Definition Code Silver Definition Silver Lake (Dickinson County) Source
Code Definition Code South Twin Definition South Twin Lake Source
Code Definition Code Storm Definition Storm Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 12 Definition Blue Lake Source
Code Definition Code 19 Definition Center Lake Source
Code Definition Code 36 Definition Five Island Lake Source
Code Definition Code 90 Definition North Twin Lake Source
Code Definition Code 105 Definition Silver Lake (Dickinson County) Source
Code Definition Code 113 Definition Storm Lake Source
Code Definition Code 406 Definition South Twin Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Epi Definition (epilimnion) grab sample from the mixed surface layer, 0.25 from the water surface Source
Code Definition Code Hypo Definition (hypolimnion) Van Dorn sample from 0.5 meters above the sediment-water interface Source
Unit Julian Day of Year Type integer
Unit Fraction of year Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code nan Definition No data flag Source
Code Definition Code m Definition No sample collected Source
Unit milligramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code nan Definition No data flag Source
Code Definition Code a Definition concentration below instrument detection limit, value set to zero Source
Code Definition Code m Definition no sample collected Source
Unit milligramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code nan Definition No data flag Source
Code Definition Code a Definition concentration below instrument detection limit, value set to zero Source
Code Definition Code m Definition no sample collected Source
Unit milligramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code nan Definition No data flag Source
Code Definition Code a Definition concentration below instrument detection limit, value set to zero Source
Code Definition Code m Definition no sample collected Source
Unit microgramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code nan Definition No data flag Source
Code Definition Code m Definition No sample collected Source
Unit microgramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code nan Definition No data flag Source
Code Definition Code a Definition concentration below instrument detection limit, value set to zero Source
Unit milligramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code nan Definition No data flag Source
Code Definition Code a Definition concentration below instrument detection limit, value set to zero Source
Code Definition Code m Definition no sample collected Source
Unit milligramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code nan Definition No data flag Source
Code Definition Code a Definition concentration below instrument detection limit, value set to detection limit Source
Code Definition Code m Definition no sample collected Source
Unit microgramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code nan Definition No data flag Source
Code Definition Code a Definition concentration below instrument detection limit, value set to detection limit Source
Code Definition Code m Definition no sample collected Source
Unit microgramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code nan Definition No data flag Source
Code Definition Code a Definition concentration below instrument detection limit, value set to detection limit Source
Code Definition Code m Definition no sample collected Source
Missing Value Code: Code NA Expl Measurement was not taken
Code NA Expl Measurement was not taken
Code NA Expl Measurement was not taken
Code NA Expl Measurement was not taken
Code NA Expl Measurement was not taken
Code NA Expl Measurement was not taken
Code NA Expl Measurement was not taken
Code NA Expl Measurement was not taken
Code NA Expl Measurement was not taken
Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/d6409ac14a7f593e71911bf863ea7414 Name: Carp lakes high frequency temperature profiles, 2018-2019 Description: The data table contains high frequency water temperature measurements from several discrete depths throught the water column of the deep site of 6 study lakes (Center, Five Island, North Twin, Silver, South Twin, and Swan Lakes) in order to capture thermal stratification and mixing events during the sumemrs of 2018 and 2019. These data were compiled and QAQC-ed by Ellen Albright. Number of Records: 273930 Number of Columns: 8
Table StructureObject Name: 2_Carp_Temp_2018-19.csv Size: 17307540 byte Authentication: 6053e55ebfc7bc03616db1e043af5ed3
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions year lake_name lake_id datetime doy doy_frac depth_m temp_c Column Name: year lake_name lake_id datetime doy doy_frac depth_m temp_c Definition: Sampling year (2018, 2019) Lake name Unique lake identifier for the ISU Limnology Lab database Date and timestamp when temperature sensor took a measurement. HOBO Pendant temperature logger. Julian day of year when temperature sensor took a measurement Fractional Julian day of year (to show time of day) when temperature sensor took a measurement Water depth where temperature sensor was placed (distance from water surface to sensor) Water temperature Storage Type: dateTime string string dateTime float float float float Measurement Type: dateTime nominal nominal dateTime ratio ratio ratio ratio Measurement Values Domain: +/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Center Definition Center Lake Source
Code Definition Code Five Island Definition Five Island Lake Source
Code Definition Code North Twin Definition North Twin Lake Source
Code Definition Code Silver Definition Silver Lake (Dickinson County) Source
Code Definition Code South Twin Definition South Twin Lake Source
Code Definition Code Swan Definition Swan Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 19 Definition Center Lake Source
Code Definition Code 36 Definition Five Island Lake Source
Code Definition Code 90 Definition North Twin Lake Source
Code Definition Code 105 Definition Silver Lake (Dickinson County) Source
Code Definition Code 114 Definition Swan Lake Source
Code Definition Code 406 Definition South Twin Lake Source
Format YYYY-MM-DD hh:mm:ss Precision
Unit Julian Day of Year Type integer
Unit Julian Day of Year, fractional Type real
Missing Value Code: Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/4b434a0505041a550de19b039065a4be Name: Carp lakes high frequency dissolved oxygen data, 2018-2019 Description: The data table contains high frequency dissolved oxygen concentrations and water temperature measurements from surface and bottom waters at the deep sites of 4 study lakes (Center, Five Island, North Twin, and South Twin Lakes) during the summers of 2018 and 2019. These data were compiled and QAQC-ed by Ellen Albright. Number of Records: 45923 Number of Columns: 9
Table StructureObject Name: 3_Carp_DO_2018-19.csv Size: 3187858 byte Authentication: d581e5277533c60d653882348a8fd890
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions year lake_name lake_id depth_m datetime doy doy_frac DO_mgL temp_c Column Name: year lake_name lake_id depth_m datetime doy doy_frac DO_mgL temp_c Definition: Sampling year (2018, 2019) Lake name Unique lake identifier for the ISU Limnology Lab database Water depth where dissolved oxygen sensor was placed (distance from water surface to sensor). A value of 0 indicates a sensor placed just below the lake surface. Date and timestamp when temperature sensor took a measurement. HOBO Pendant temperature logger. Julian day of year when temperature sensor took a measurement Fractional Julian day of year (to show time of day) when temperature sensor took a measurement Dissolved oxygen concentration Water temperature Storage Type: dateTime string string float dateTime float float float float Measurement Type: dateTime nominal nominal ratio dateTime ratio ratio ratio ratio Measurement Values Domain: +/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Center Definition Center Lake Source
Code Definition Code Five Island Definition Five Island Lake Source
Code Definition Code North Twin Definition North Twin Lake Source
Code Definition Code South Twin Definition South Twin Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 19 Definition Center Lake Source
Code Definition Code 36 Definition Five Island Lake Source
Code Definition Code 90 Definition North Twin Lake Source
Code Definition Code 406 Definition South Twin Lake Source
Format YYYY-MM-DD hh:mm:ss Precision
Unit Julian Day of Year Type integer
Unit Julian Day of Year, fractional Type real
Unit milligramPerLiter Type real
Missing Value Code: Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/685bd952f497089978db7dec2a6a9ca7 Name: South Twin Lake high frequency water quality data, 2018-2019 Description: The data table contains high frequency measurements of chlorophyll-a, phycocyanin, and dissolved oxygen concentrations; dissolved oxygen saturation, water temperature, pH, specific conductivity, and total dissolved solids in the surface waters of South Twin Lake during the summers of 2018 and 2019. These data were compiled and QAQC-ed by Ellen Albright and Robert Johnson. Number of Records: 18221 Number of Columns: 14
Table StructureObject Name: 4_Carp_SouthTwin_EXO_2018-19.csv Size: 1785875 byte Authentication: 781be0fe6da683d818d06abec9122d46
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions year lake_name lake_id datetime doy doy_frac chla_ugL phyco_ugL DO_sat DO_mgL temp_c ph SpCond_uScm tds_mgL Column Name: year lake_name lake_id datetime doy doy_frac chla_ugL phyco_ugL DO_sat DO_mgL temp_c ph SpCond_uScm tds_mgL Definition: Sampling year (2018, 2019) Lake name Unique lake identifier for the ISU Limnology Lab database Date and timestamp when temperature sensor took a measurement. HOBO Pendant temperature logger. Julian day of year when temperature sensor took a measurement Fractional Julian day of year (to show time of day) when temperature sensor took a measurement Chlorophyll-a pigment concentration, calculated from relative fluorescence units Phycocyanin pigment concentration, calculated from relative fluorescence units Optical dissolved oxygen saturation Optical dissolved oxygen concentration Water temperature pH Specific conductivity Total dissolved solids concentration Storage Type: dateTime string string dateTime float float float float float float float float float float Measurement Type: dateTime nominal nominal dateTime ratio ratio ratio ratio ratio ratio ratio ratio ratio ratio Measurement Values Domain: +/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code South Twin Definition South Twin Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 406 Definition South Twin Lake Source
Format YYYY-MM-DD hh:mm:ss Precision
Unit Julian Day of Year Type integer
Unit Julian Day of Year, fractional Type real
Unit microgramPerLiter Type real
Unit microgramPerLiter Type real
Unit milligramPerLiter Type real
Unit micro Siemens Type real
Unit milligramPerLiter Type real
Missing Value Code: Code NA Expl Measurement was not taken
Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/8f3b631f30c4ea55ef9af85b638e4701 Name: Swan Lake high frequency water quality data, 2018 Description: The data table contains high frequency measurements of chlorophyll-a, phycocyanin, and dissolved oxygen concentrations; dissolved oxygen saturation, water temperature, pH, specific conductivity, and total dissolved solids in the surface waters of Swan Lake during the summer of 2018. These data were compiled and QAQC-ed by Ellen Albright. Number of Records: 12727 Number of Columns: 14
Table StructureObject Name: 5_Carp_Swan_EXO_2018.csv Size: 1247024 byte Authentication: 8f3cfb4c735edeaf560777239d2f27e1
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions year lake_name lake_id datetime doy doy_frac chla_ugL phyco_ugL DO_sat DO_mgL temp_c ph SpCond_uScm tds_mgL Column Name: year lake_name lake_id datetime doy doy_frac chla_ugL phyco_ugL DO_sat DO_mgL temp_c ph SpCond_uScm tds_mgL Definition: Sampling year (2018, 2019) Lake name Unique lake identifier for the ISU Limnology Lab database Date and timestamp when temperature sensor took a measurement. HOBO Pendant temperature logger. Julian day of year when temperature sensor took a measurement Fractional Julian day of year (to show time of day) when temperature sensor took a measurement Chlorophyll-a pigment concentration, calculated from relative fluorescence units Phycocyanin pigment concentration, calculated from relative fluorescence units Optical dissolved oxygen saturation Optical dissolved oxygen concentration Water temperature pH Specific conductivity Total dissolved solids concentration Storage Type: dateTime string string dateTime float float float float float float float float float float Measurement Type: dateTime nominal nominal dateTime ratio ratio ratio ratio ratio ratio ratio ratio ratio ratio Measurement Values Domain: +/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Swan Lake Definition Swan Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 114 Definition Swan Lake Source
Format YYYY-MM-DD hh:mm:ss Precision
Unit Julian Day of Year Type integer
Unit Julian Day of Year, fractional Type real
Unit microgramPerLiter Type real
Unit microgramPerLiter Type real
Unit milligramPerLiter Type real
Unit micro Siemens Type real
Unit milligramPerLiter Type real
Missing Value Code: Code NA Expl Measurement was not taken
Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/2d33dabae2ab23b17127953cb6fbf2b3 Name: Carp lakes zooplankton community composition and biomass data, 2018-2020 Description: The data table details zooplankton community composition and biomass concentrations for 7 study lakes (Blue, Center, Five Island, North Twin, Silver, Storm, and South Twin Lakes). Zooplankton were sampled at the deepest point of each lake throughout the summers of 2018-2020. Organisms were identified to genus for cladocerans and rotiers, order for copepods, and class for ostracods. These data were compiled from research conducted by the Iowa State University Limnology Laboratory and the IDNR Ambient Lakes Monitoring Program. These data were compiled and QAQC-ed by Tyler Butts. Number of Records: 5047 Number of Columns: 9
Table StructureObject Name: 6_Carp_Zoop_2018-20.csv Size: 308549 byte Authentication: 3486f68cbed90d406e0e40e323e46736
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions sample_id year program lake_name lake_id doy group taxon biomass_ugL Column Name: sample_id year program lake_name lake_id doy group taxon biomass_ugL Definition: Unique sample identifier for the ISU Limnology Lab database Sampling year (2018, 2019, 2020) Monitoring project responsible for data collection Lake name Unique lake identifier for the ISU Limnology Lab database Julian day of year when water samples were collected Functional grouping of zooplankton taxa Zooplankton taxonomic grouping. Zooplankton were identified to genus for cladocerans and rotiers, order for copepods, and class for ostracods. Biomass concentration of each zooplankton taxon found in the sample. Storage Type: string dateTime string string string float string string float Measurement Type: nominal dateTime nominal nominal nominal ratio nominal nominal ratio Measurement Values Domain: Definition Unique sample identifier for the ISU Limnology Lab database
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code ALM Definition Ambient Lakes Monitoring Program (Iowa DNR) Source
Code Definition Code Carp Definition Intensive Monitoring by ISU Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Blue Definition Blue Lake Source
Code Definition Code Center Definition Center Lake Source
Code Definition Code Five Island Definition Five Island Lake Source
Code Definition Code North Twin Definition North Twin Lake Source
Code Definition Code Silver Definition Silver Lake (Dickinson County) Source
Code Definition Code South Twin Definition South Twin Lake Source
Code Definition Code Storm Definition Storm Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 12 Definition Blue Lake Source
Code Definition Code 19 Definition Center Lake Source
Code Definition Code 36 Definition Five Island Lake Source
Code Definition Code 90 Definition North Twin Lake Source
Code Definition Code 105 Definition Silver Lake (Dickinson County) Source
Code Definition Code 113 Definition Storm Lake Source
Code Definition Code 406 Definition South Twin Lake Source
Unit Julian Day of Year Type integer
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Calanoid Definition order of copepods Source
Code Definition Code Cladocera Definition super order of small crustaceans that include Bosmina, Daphnia, Chydorus, Ceriodaphnia, among others Source
Code Definition Code Cyclopoid Definition order of copepods Source
Code Definition Code Nauplii Definition early life stage copepod Source
Code Definition Code Rotifer Definition any member of the phylum rotifera Source
Definition Zooplankton taxonomic grouping. Zooplankton were identified to genus for cladocerans and rotiers, order for copepods, and class for ostracods.
Unit microgramPerLiter Type real
Missing Value Code: Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/dec0ddb7cdade3e1b0b16301c6fb6170 Name: Carp lakes benthic macroinvertebrate community composition and density data, 2018-2020 Description: The data table details benthic macroinvertebrate community composition and density for 7 study lakes (Blue, Center, Five Island, North Twin, Silver, Storm, and South Twin Lakes). Macroinvertebrates were sampled at 10 sites across each lake in the summers of 2018-2020. Organisms were identified to either family or order. These data were compiled and QAQC-ed by Tyler Butts. Number of Records: 389 Number of Columns: 12
Table StructureObject Name: 7_Carp_Macroinverts_2018-20.csv Size: 30320 byte Authentication: c11a9ba0e6e4d3eafcb98b693f34f61f
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions sample_id year lake_name lake_id doy site_id taxa count sample_area_m2 gear combined_sites density_count_m2 Column Name: sample_id year lake_name lake_id doy site_id taxa count sample_area_m2 gear combined_sites density_count_m2 Definition: Unique sample identifier for the ISU Limnology Lab database Sampling year (2018, 2019, 2020) Lake name Unique lake identifier for the ISU Limnology Lab database Julian day of year when water samples were collected Unique site identifier within each lake Macroinvertebrate identification down to family or order Number of individuals identified Area of Ekman (0.023) or Ponar (0.052) dredge. Combined samples include the sum of sample area Sampling equipment used to collect macroinvertebrates Number of sites within each lake that were combined into one sampling bucket and collated into one single sample for analysis Number of organisms (count) per square meter (m2) Storage Type: string dateTime string string float string string float float string float float Measurement Type: nominal dateTime nominal nominal ratio nominal nominal ratio ratio nominal ratio ratio Measurement Values Domain: Definition Unique sample identifier for the ISU Limnology Lab database
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Blue Definition Blue Lake Source
Code Definition Code Center Definition Center Lake Source
Code Definition Code Five Island Definition Five Island Lake Source
Code Definition Code North Twin Definition North Twin Lake Source
Code Definition Code Silver Definition Silver Lake (Dickinson County) Source
Code Definition Code South Twin Definition South Twin Lake Source
Code Definition Code Storm Definition Storm Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 12 Definition Blue Lake Source
Code Definition Code 19 Definition Center Lake Source
Code Definition Code 36 Definition Five Island Lake Source
Code Definition Code 90 Definition North Twin Lake Source
Code Definition Code 105 Definition Silver Lake (Dickinson County) Source
Code Definition Code 113 Definition Storm Lake Source
Code Definition Code 406 Definition South Twin Lake Source
Unit Julian Day of Year Type integer
Definition Unique site identifier within each lake
Definition Macroinvertebrate identification down to family or order
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Ekman Definition Ekman dredge Source
Code Definition Code Ponar Definition Ponar dredge Source
Unit Count per square meter Type real
Missing Value Code: Code NA Expl Multiples sites were not combined into one sample bucket
Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/0b1faf7aa6ac227b86debd1b656f1a4d Name: Carp lakes macrophyte community composition and spatial coverage, 2018-2020 Description: The data table details macrophyte community composition and spatial coverage for 6 study lakes (Center, Five Island, North Twin, Silver, Storm, and South Twin Lakes). Macrophytes were sampled along 15-25 transects per lake in the summers of 2018-2020. Organisms were identified to either genus or species. These data were hand-entered and QAQC-ed by Ellen Albright. Number of Records: 1700 Number of Columns: 27
Table StructureObject Name: 8_Carp_Macrophytes_2018-20.csv Size: 153948 byte Authentication: c1a9537b62f3a847782393844581b21a
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions year lake_name lake_id transect transect_id lat long depth_m substrate rake_total species_richness emergent_richness submersed_richness floating_richness typha_angustifolia sagittaria_latifolia schenoplectus_tabernaemontani sparganium_spp ceratophyllum_demersum chara_spp najas_flexilis potamogeton_crispus potamogeton foliosus potamogeton_nodosus stuckenia_pectinata lemna_spp persicaria_amphibia Column Name: year lake_name lake_id transect transect_id lat long depth_m substrate rake_total species_richness emergent_richness submersed_richness floating_richness typha_angustifolia sagittaria_latifolia schenoplectus_tabernaemontani sparganium_spp ceratophyllum_demersum chara_spp najas_flexilis potamogeton_crispus potamogeton_foliosus potamogeton_nodosus stuckenia_pectinata lemna_spp persicaria_amphibia Definition: Sampling year (2018, 2019, 2020) Lake name Unique lake identifier for the ISU Limnology Lab database Lake-level transect identifier. The total number of transects varies by lake based on surface area: Center (n=15), Five Island (n=25), North Twin (n=20), Silver (n=25), Storm (n=25), South Twin (n=25) Unique transect identifier for ISU Limnology Lab database Latitude value for the coordinates of the beginning of the transect Longitude value for the coordinates of the beginning of the transect Water depth at which the macrophyte sample was collected using a rake pull Qualitative estimate of substrate composition at the sampling site, based on how firm the lakebed felt against the sampling rake Qualitative assessment of macrophyte biomass at the sampling site based on visual assessments of emergent vegetation within 2 meters of the boat and sampling with a two-sided rake, lowered to the lake bottom to collect submersed and floating-leaf macrophytes from an approximately 0.4 m2 area. Total number of macrophyte species encountered at the sampling site, either visual observation with 2 m of the boat or from a rake sample Total number of emergent growth form macrophyte species encountered at the sampling site Total number of submersed growth form macrophyte species encountered at the sampling site Total number of floating-leaf growth form macrophyte species encountered at the sampling site Presence or absence of emergent macrophyte Typha angustifolia (narrowleaf cattail) Presence or absence of emergent macrophyte Sagittaria latifolia (broadleaf arrowhead) Presence or absence of emergent macrophyte Schenoplectus tabernaemontain (softstem bulrush) Presence or absence of emergent macrophyte Sparganium spp. (bur-reed, identified to genus) Presence or absence of submersed macrophyte Ceratophyllum demersum (coontain) Presence or absence of submersed macroalgae Chara spp. (muskgrass, identified to genus) Presence or absence of submersed macrophyte Najas flexilis (waternymph) Presence or absence of submersed macrophyte Potamogeton crispus (curly-leaf pondweed) Presence or absence of submersed macrophyte Potamogeton foliosus (leafy pondweed) Presence or absence of submersed macrophyte Potamogeton nodosus (long-leaf pondweed) Presence or absence of submersed macrophyte Stuckenia pectinata (Sago pondweed) Presence or absence of floating macrophyte Lemna Spp. (duckweed, identified to genus) Presence or absence of floating macrophyte Persicaria amphibia. (water smartweed) Storage Type: dateTime string string string string float float float string string float float float float string string string string string string string string string string string string string Measurement Type: dateTime nominal nominal nominal nominal ratio ratio ratio nominal nominal ratio ratio ratio ratio nominal nominal nominal nominal nominal nominal nominal nominal nominal nominal nominal nominal nominal Measurement Values Domain: +/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Center Definition Center Lake Source
Code Definition Code Five Island Definition Five Island Lake Source
Code Definition Code North Twin Definition North Twin Lake Source
Code Definition Code Silver Definition Silver Lake (Dickinson County) Source
Code Definition Code South Twin Definition South Twin Lake Source
Code Definition Code Storm Definition Storm Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 12 Definition Blue Lake Source
Code Definition Code 19 Definition Center Lake Source
Code Definition Code 36 Definition Five Island Lake Source
Code Definition Code 90 Definition North Twin Lake Source
Code Definition Code 105 Definition Silver Lake (Dickinson County) Source
Code Definition Code 113 Definition Storm Lake Source
Code Definition Code 406 Definition South Twin Lake Source
Definition Lake-level transect identifier. The total number of transects varies by lake based on surface area: Center (n=15), Five Island (n=25), North Twin (n=20), Silver (n=25), Storm (n=25), South Twin (n=25)
Definition Unique transect identifier for ISU Limnology Lab database
Unit Decimal degree Type real
Unit Decimal degree Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Muck Definition very soft substrate Source
Code Definition Code Rock Definition firm substrate, but couldn’t feel significant cobble against the rake Source
Code Definition Code Sand Definition hard substrate, could feel rocks Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition No plants on the sampling rake or in sight of the boat (within 2 m) Source
Code Definition Code 1 Definition a few plants on the rake or visible within 2 m of the boat Source
Code Definition Code 2 Definition enough plants to fill the rake but leave the tines visible Source
Code Definition Code 3 Definition enough plants to completely fill the rake leaving no part of the metal rake head visible Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
Missing Value Code: Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/5822172a665573c27386e3849753f1fb Name: Summary of carp lakes macrophyte species richness and community assembly, 2018-2020 Description: The data table provides a lake-level summary of macrophyte species richness and community composition for each year of sampling (2018-2020) for 6 study lakes (Center, Five Island, North Twin, Silver, Storm, and South Twin Lakes). These data were summarized by Ellen Albright. Number of Records: 18 Number of Columns: 21
Table StructureObject Name: 9_Carp_Macrophytes_2018-20_Summary.csv Size: 1388 byte Authentication: eaa8b84aa5531e5a55b8eb8c5ef5997e
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions year lake_name lake_id species_richness emergent_richness submersed_richness floating_richness max_depth_m typha_angustifolia sagittaria_latifolia schenoplectus_tabernaemontani sparganium_spp ceratophyllum_demersum chara_spp najas_flexilis potamogeton_crispus potamogeton foliosus potamogeton_nodosus stuckenia_pectinata lemna_spp persicaria_amphibia Column Name: year lake_name lake_id species_richness emergent_richness submersed_richness floating_richness max_depth_m typha_angustifolia sagittaria_latifolia schenoplectus_tabernaemontani sparganium_spp ceratophyllum_demersum chara_spp najas_flexilis potamogeton_crispus potamogeton_foliosus potamogeton_nodosus stuckenia_pectinata Lemna_spp persicaria_amphibia Definition: Sampling year (2018, 2019, 2020) Lake name Unique lake identifier for the ISU Limnology Lab database Total number of macrophyte species found in the study lake for the given sampling year Total number of emergent growth form macrophyte species found in the study lake for the given sampling year Total number of submersed growth form macrophyte species found in the study lake for the given sampling year Total number of floating-leaf growth form macrophyte species found in the study lake for the given sampling year Maximum water depth of macrophyte colonization Presence or absence of emergent macrophyte Typha angustifolia (narrowleaf cattail) Presence or absence of emergent macrophyte Sagittaria latifolia (broadleaf arrowhead) Presence or absence of emergent macrophyte Schenoplectus tabernaemontain (softstem bulrush) Presence or absence of emergent macrophyte Sparganium spp. (bur-reed, identified to genus) Presence or absence of submersed macrophyte Ceratophyllum demersum (coontain) Presence or absence of submersed macroalgae Chara spp. (muskgrass, identified to genus) Presence or absence of submersed macrophyte Najas flexilis (waternymph) Presence or absence of submersed macrophyte Potamogeton crispus (curly-leaf pondweed) Presence or absence of submersed macrophyte Potamogeton foliosus (leafy pondweed) Presence or absence of submersed macrophyte Potamogeton nodosus (long-leaf pondweed) Presence or absence of submersed macrophyte Stuckenia pectinata (Sago pondweed) Presence or absence of floating macrophyte Lemna Spp. (duckweed, identified to genus) Presence or absence of floating macrophyte Persicaria amphibia. (water smartweed) Storage Type: dateTime string string float float float float float string string string string string string string string string string string string string Measurement Type: dateTime nominal nominal ratio ratio ratio ratio ratio nominal nominal nominal nominal nominal nominal nominal nominal nominal nominal nominal nominal nominal Measurement Values Domain: +/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Center Definition Center Lake Source
Code Definition Code Five Island Definition Five Island Lake Source
Code Definition Code North Twin Definition North Twin Lake Source
Code Definition Code Silver Definition Silver Lake (Dickinson County) Source
Code Definition Code South Twin Definition South Twin Lake Source
Code Definition Code Storm Definition Storm Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 12 Definition Blue Lake Source
Code Definition Code 19 Definition Center Lake Source
Code Definition Code 36 Definition Five Island Lake Source
Code Definition Code 90 Definition North Twin Lake Source
Code Definition Code 105 Definition Silver Lake (Dickinson County) Source
Code Definition Code 113 Definition Storm Lake Source
Code Definition Code 406 Definition South Twin Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 0 Definition Species absent at sampling site Source
Code Definition Code 1 Definition Species present at sampling site Source
Missing Value Code: Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/4816f31d34d1e91da65321dbba86d6d0 Name: Raw sediment core incubation data, 2019 Description: This data table contains the raw data for sediment core incubation experiments for North and South Twin Lakes and Swan Lake, during the summer of 2019. Sediments were incubated under both oxic and anoxic conditions, and change in phosphorus in the overlying water was monitored over 5 days. These data were hand-entered and QAQC-ed by Ellen Albright. This data table is meant to be used for further calculations. Number of Records: 160 Number of Columns: 30
Table StructureObject Name: 10_Carp_Incubation_2019_RAW.csv Size: 29880 byte Authentication: 5fc60ea4bf097995afb222a04e944f3a
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions sample_id year lake_name lake_id month doy_lake site_id lat long zone water_depth_m hypo_DO_mgL thermal_str hypo_pH do_treatment core_id core_unique sediment_sa_m2 water_height_m doy_inc total_time_h pH temp_c SRP_ugL_1 SRP_ugL_2 TP_ugL_1 TP_ugL_2 vol_replace_L replace_SRP_ugL replace_TP_ugL Column Name: sample_id year lake_name lake_id month doy_lake site_id lat long zone water_depth_m hypo_DO_mgL thermal_str hypo_pH do_treatment core_id core_unique sediment_sa_m2 water_height_m doy_inc total_time_h pH temp_c SRP_ugL_1 SRP_ugL_2 TP_ugL_1 TP_ugL_2 vol_replace_L replace_SRP_ugL replace_TP_ugL Definition: Unique sample identifier for the ISU Limnology Lab database Sampling year (2019) Waterbody from which sediment cores were collected Unique lake identifier for the ISU Limnology Lab database Sampling month Julian day of year when sediment cores were collected from each lake Sampling site within the lake Latitude value for the coordinates of the sampling site Longitude value for the coordinates of the sampling site Horizonal zone within each lake from which cores were collected Water depth at the sampling site at the time of sediment core collection Dissolved oxygen concentration in the bottom waters at the sampling site at the time of sediment core collection Description of water column thermal structure at the sampling site at the time of sediment core collection pH in the bottom waters at the sampling site at the time of sediment core collection Dissolved oxygen treatment applied to the incubating core Unique identifier for each core included in each experiment Unique identifier for each core and each incubation event. Needed for calculation of daily sediment phosphorus release rate in r. Surface area of the sediment within the incubation core sleeve water column height (water overlying sediment core) Julian day of year when the incubation water samples were collected from the core Time since the start of the sediment core incubation for each water sample collection Water column pH in incubating core Water column temperature water column soluble reactive phosphorus concentration water column soluble reactive phosphorus concentration, lab duplicate water column total phosphorus concentration water column total phosphorus concentration, lab duplicate volume of replacement water used to compensate for daily incubation water sampling soluble reactive phosphorus concentration in the replacement water total phosphorus concentration in the replacement water Storage Type: string dateTime string string string float string float float string float float string float string string string float float float float float float float float float float float float float Measurement Type: nominal dateTime nominal nominal nominal ratio nominal ratio ratio nominal ratio ratio nominal ratio nominal nominal nominal ratio ratio ratio ratio ratio ratio ratio ratio ratio ratio ratio ratio ratio Measurement Values Domain: Definition Unique sample identifier for the ISU Limnology Lab database
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code North Twin Definition North Twin Lake Source
Code Definition Code South Twin Definition South Twin Lake Source
Code Definition Code Swan Definition Swan Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 90 Definition North Twin Lake Source
Code Definition Code 114 Definition Swan Lake Source
Code Definition Code 406 Definition South Twin Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code July Definition July Source
Code Definition Code June Definition June Source
Unit Julian Day of Year Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 1 Definition North or South Twin Lake, Deep Site Source
Code Definition Code 3 Definition Swan Lake, Most Shallow Littoral Site Source
Code Definition Code 6 Definition Swan Lake, Littoral Site Source
Code Definition Code 7 Definition South Twin Lake, Littoral Site Source
Code Definition Code 10 Definition Swan Lake, Deep Site Source
Unit Decimal degree Type real
Unit Decimal degree Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Littoral Definition more shallow, nearshore areas Source
Code Definition Code Profundal Definition the deep site of the lake Source
Unit milligramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Mixed Definition no thermocline was observed, the water column was isothermal Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Anoxic Definition no oxygen present in water overlying sediment, achieved by bubbling water with N2 gas Source
Code Definition Code Oxic Definition water above sediment core aerated with air mixture to keep oxygen present Source
Definition Unique identifier for each core included in each experiment
Definition Unique identifier for each core and each incubation event. Needed for calculation of daily sediment phosphorus release rate in r.
Unit Julian Day of Year Type integer
Unit microgramPerLiter Type real
Unit microgramPerLiter Type real
Unit microgramPerLiter Type real
Unit microgramPerLiter Type real
Unit microgramPerLiter Type real
Unit microgramPerLiter Type real
Missing Value Code: Code NA Expl No replacement water added to core
Code NA Expl No replacement water added to core
Code NA Expl No replacement water added to core
Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/7070ebe4ad0abc839141da9dc1bf972c Name: Clean and calculated sediment core incubation data, 2019 Description: This data table contains the output of the cleaning script to calculate daily sediment phosphorus flux rates for sediment core incubation experiments for North and South Twin Lakes and Swan Lake, during the summer of 2019, under oxic and anoxic conditions. These data were calculated by Ellen Albright. Number of Records: 160 Number of Columns: 23
Table StructureObject Name: 11_Carp_Incubation_2019_CALC.csv Size: 23322 byte Authentication: 9be80ecb88226459c00c246f5b06a7eb
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions sample_id year lake_name lake_id month doy_lake site_id lat long zone water_depth_m hypo_DO_mgL thermal_str hypo_pH do_treatment core_id core_unique doy_inc total_time_h pH temp_c PrrTP PrrSRP Column Name: sample_id year lake_name lake_id month doy_lake site_id lat long zone water_depth_m hypo_DO_mgL thermal_str hypo_pH do_treatment core_id core_unique doy_inc total_time_h pH temp_c PrrTP PrrSRP Definition: Unique sample identifier for the ISU Limnology Lab database Sampling year (2019) Waterbody from which sediment cores were collected Unique lake identifier for the ISU Limnology Lab database Sampling month Julian day of year when sediment cores were collected from each lake Sampling site within the lake Latitude value for the coordinates of the sampling site Longitude value for the coordinates of the sampling site Horizonal zone within each lake from which cores were collected Water depth at the sampling site at the time of sediment core collection Dissolved oxygen concentration in the bottom waters at the sampling site at the time of sediment core collection Description of water column thermal structure at the sampling site at the time of sediment core collection pH in the bottom waters at the sampling site at the time of sediment core collection Dissolved oxygen treatment applied to the incubating core Unique identifier for each core included in each experiment Unique identifier for each core and each incubation event. Needed for calculation of daily sediment phosphorus release rate in r. Julian day of year when the incubation water samples were collected from the core Time since the start of the sediment core incubation for each water sample collection Water column pH in incubating core Water column temperature Daily areal sediment P flux rate – total phosphorus Daily areal sediment P flux rate – soluble reactive phosphorus Storage Type: string dateTime string string string float string float float string float float string float string string string float float float float float float Measurement Type: nominal dateTime nominal nominal nominal ratio nominal ratio ratio nominal ratio ratio nominal ratio nominal nominal nominal ratio ratio ratio ratio ratio ratio Measurement Values Domain: Definition Unique sample identifier for the ISU Limnology Lab database
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code North Twin Definition North Twin Lake Source
Code Definition Code South Twin Definition South Twin Lake Source
Code Definition Code Swan Definition Swan Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 90 Definition North Twin Lake Source
Code Definition Code 114 Definition Swan Lake Source
Code Definition Code 406 Definition South Twin Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code July Definition July Source
Code Definition Code June Definition June Source
Unit Julian Day of Year Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 1 Definition North or South Twin Lake, Deep Site Source
Code Definition Code 3 Definition Swan Lake, Most Shallow Littoral Site Source
Code Definition Code 6 Definition Swan Lake, Littoral Site Source
Code Definition Code 7 Definition South Twin Lake, Littoral Site Source
Code Definition Code 10 Definition Swan Lake, Deep Site Source
Unit Decimal degree Type real
Unit Decimal degree Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Littoral Definition more shallow, nearshore areas Source
Code Definition Code Profundal Definition the deep site of the lake Source
Unit milligramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Mixed Definition no thermocline was observed, the water column was isothermal Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Anoxic Definition no oxygen present in water overlying sediment, achieved by bubbling water with N2 gas Source
Code Definition Code Oxic Definition water above sediment core aerated with air mixture to keep oxygen present Source
Definition Unique identifier for each core included in each experiment
Definition Unique identifier for each core and each incubation event. Needed for calculation of daily sediment phosphorus release rate in r.
Unit Julian Day of Year Type integer
Unit milligramPerMeterSquaredPerDay Type real
Unit milligramPerMeterSquaredPerDay Type real
Missing Value Code: Code NA Expl P flux rate cannot be calculated for incubation day 1
Code NA Expl P flux rate cannot be calculated for incubation day 1
Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/2cafa1ad0435da618f9d390ec2aa24a8 Name: Summary of calculated sediment phosphorus flux rates, 2019 Description: This data table contains the output of the cleaning script to calculate the average daily sediment phosphorus flux rates for sediment core incubation experiments for North and South Twin Lakes and Swan Lake, during the summer of 2019, under oxic and anoxic conditions. Values were averaged across temporal replicates for each unique sediment core over the course of each incubation experiment. These data were calculated by Ellen Albright. Number of Records: 32 Number of Columns: 19
Table StructureObject Name: 12_Carp_Incubation_2019_SUMMARY.csv Size: 4212 byte Authentication: 0bce27c65b447d315aaaccd8efa62a5a
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions year lake_name lake_id month doy_lake site_id lat long zone water_depth_m hypo_DO_mgL thermal_str hypo_pH do_treatment core_unique mean_pH mean_temp_c mean_PrrTP mean_PrrSRP Column Name: year lake_name lake_id month doy_lake site_id lat long zone water_depth_m hypo_DO_mgL thermal_str hypo_pH do_treatment core_unique mean_pH mean_temp_c mean_PrrTP mean_PrrSRP Definition: Sampling year (2019) Waterbody from which sediment cores were collected Unique lake identifier for the ISU Limnology Lab database Sampling month Julian day of year when sediment cores were collected from each lake Sampling site within the lake Latitude value for the coordinates of the sampling site Longitude value for the coordinates of the sampling site Horizonal zone within each lake from which cores were collected Water depth at the sampling site at the time of sediment core collection Dissolved oxygen concentration in the bottom waters at the sampling site at the time of sediment core collection Description of water column thermal structure at the sampling site at the time of sediment core collection pH in the bottom waters at the sampling site at the time of sediment core collection Dissolved oxygen treatment applied to the incubating core Unique identifier for each core and each incubation event. Needed for calculation of daily sediment phosphorus release rate in r. Water column pH in incubating core. Average value over entire incubation period. Water column temperature. Average value over entire incubation period. Average daily areal sediment P flux rate over the course of the incubation – total phosphorus Average daily areal sediment P flux rate over the course of the incubation – soluble reactive phosphorus Storage Type: dateTime string string string float string float float string float float string float string string float float float float Measurement Type: dateTime nominal nominal nominal ratio nominal ratio ratio nominal ratio ratio nominal ratio nominal nominal ratio ratio ratio ratio Measurement Values Domain: +/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code North Twin Definition North Twin Lake Source
Code Definition Code South Twin Definition South Twin Lake Source
Code Definition Code Swan Definition Swan Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 90 Definition North Twin Lake Source
Code Definition Code 114 Definition Swan Lake Source
Code Definition Code 406 Definition South Twin Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code July Definition July Source
Code Definition Code June Definition June Source
Unit Julian Day of Year Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 1 Definition North or South Twin Lake, Deep Site Source
Code Definition Code 3 Definition Swan Lake, Most Shallow Littoral Site Source
Code Definition Code 6 Definition Swan Lake, Littoral Site Source
Code Definition Code 7 Definition South Twin Lake, Littoral Site Source
Code Definition Code 10 Definition Swan Lake, Deep Site Source
Unit Decimal degree Type real
Unit Decimal degree Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Littoral Definition more shallow, nearshore areas Source
Code Definition Code Profundal Definition the deep site of the lake Source
Unit milligramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Mixed Definition no thermocline was observed, the water column was isothermal Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Anoxic Definition no oxygen present in water overlying sediment, achieved by bubbling water with N2 gas Source
Code Definition Code Oxic Definition water above sediment core aerated with air mixture to keep oxygen present Source
Definition Unique identifier for each core and each incubation event. Needed for calculation of daily sediment phosphorus release rate in r.
Unit milligramPerMeterSquaredPerDay Type real
Unit milligramPerMeterSquaredPerDay Type real
Missing Value Code: Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/d41ee70dfd3f9005d9ba0ec4e60d57fa Name: Raw equilibrium phosphorus concentration assay results, 2018 Description: This data table contains the raw data from equilibrium phosphorus concentration (EPC) assays from July of 2018 for 7 study lakes (Center, Five Island, North Twin, Silver, Storm, South Twin, and Swan Lakes). These data were hand-entered and QAQC-ed by Ellen Albright. This data table is meant to be used for further calculations. Number of Records: 77 Number of Columns: 11
Table StructureObject Name: 13_Carp_EPC_2018_RAW.csv Size: 5269 byte Authentication: ce75db5a26023b8ab9dd0346b199b66c
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions sample_id year lake_name lake_id initial_SRP_ugL initial_SRP_mgL solution_vol_L sed_wet_g MC_frac final_SRP_ugL final_SRP_mgL Column Name: sample_id year lake_name lake_id initial_SRP_ugL initial_SRP_mgL solution_vol_L sed_wet_g MC_frac final_SRP_ugL final_SRP_mgL Definition: Unique sample identifier based on lake name and initial SRP concentration for the assay Sampling year (2018) Waterbody from which sediments were collected for the EPC assay Unique lake identifier for the ISU Limnology Lab database Initial concentration of soluble reactive phosphorus (SRP) in the treatment solution Initial concentration of SRP in the treatment solution Volume of treatment solution used Mass of fresh (wet) sediment used for the assay Sediment moisture content, as a fraction of 1. Final concentration of SRP in the supernatant after the sediment pellet shook in the treatment solution overnight Final concentration of SRP in the supernatant after the sediment pellet shook in the treatment solution overnight Storage Type: string dateTime string string float float float float float float float Measurement Type: nominal dateTime nominal nominal ratio ratio ratio ratio ratio ratio ratio Measurement Values Domain: Definition Unique sample identifier based on lake name and initial SRP concentration for the assay
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Center Definition Center Lake Source
Code Definition Code Five Island Definition Five Island Lake Source
Code Definition Code North Twin Definition North Twin Lake Source
Code Definition Code Silver Definition Silver Lake (Dickinson County) Source
Code Definition Code South Twin Definition South Twin Lake Source
Code Definition Code Storm Definition Storm Lake Source
Code Definition Code Swan Definition Swan Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 19 Definition Center Lake Source
Code Definition Code 36 Definition Five Island Lake Source
Code Definition Code 90 Definition North Twin Lake Source
Code Definition Code 105 Definition Silver Lake (Dickinson County) Source
Code Definition Code 113 Definition Storm Lake Source
Code Definition Code 114 Definition Swan Lake Source
Code Definition Code 406 Definition South Twin Lake Source
Unit microgramPerLiter Type integer
Unit milligramPerLiter Type real
Unit microgramPerLiter Type real
Unit milligramPerLiter Type real
Missing Value Code: Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Table StructureObject Name: 14_Carp_EPC_2018_CALC.csv Size: 261 byte Authentication: dad63d261e834ee734eb2973b54dab91
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions year lake_name lake_id EPC_mgL EPC_ugL EPC_flag Column Name: year lake_name lake_id EPC_mgL EPC_ugL EPC_flag Definition: Sampling year (2018) Waterbody from which sediments were collected for the EPC assay Unique lake identifier for the ISU Limnology Lab database Equilibrium phosphorus concentration Equilibrium phosphorus concentration Data flag for equilibrium phosphorus concentration values Storage Type: dateTime string string float float string Measurement Type: dateTime nominal nominal ratio ratio nominal Measurement Values Domain: +/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Center Definition Center Lake Source
Code Definition Code Five Island Definition Five Island Lake Source
Code Definition Code North Twin Definition North Twin Lake Source
Code Definition Code Silver Definition Silver Lake (Dickinson County) Source
Code Definition Code South Twin Definition South Twin Lake Source
Code Definition Code Storm Definition Storm Lake Source
Code Definition Code Swan Definition Swan Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 19 Definition Center Lake Source
Code Definition Code 36 Definition Five Island Lake Source
Code Definition Code 90 Definition North Twin Lake Source
Code Definition Code 105 Definition Silver Lake (Dickinson County) Source
Code Definition Code 113 Definition Storm Lake Source
Code Definition Code 114 Definition Swan Lake Source
Code Definition Code 406 Definition South Twin Lake Source
Unit milligramPerLiter Type real
Unit microgramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code nan Definition No data flag Source
Code Definition Code f Definition the x-intercept of the linear regression was negative, meaning that EPC could not be calculated and the assay had failed Source
Code Definition Code r Definition 2-3 points were removed from the raw data to improve the fit of the linear regression used to determine the EPC value Source
Missing Value Code: Code NA Expl EPC could not be calculated
Code NA Expl EPC could not be calculated
Accuracy Report: Accuracy Assessment: Coverage: Methods:
Data Table Data: https://pasta-s.lternet.edu/package/data/eml/edi/1251/2/2514979a9050b4b08f27cefa04b25df7 Name: Suspended solids data from tiered sediment traps, 2018-2019 Description: This data table contains total, volatile, and involatile suspended solids concentrations collected in tiered sediment traps in 7 study lakes (Center, Five Island, North Twin, Silver, Storm, South Twin, and Swan Lakes) in the summers of 2018 and 2019. Differences between top and bottom traps can be used to quanitfy sedimentation fluxes and sediment resuspension fluxes. These data were hand-entered and QAQC-ed by Ellen Albright. Number of Records: 212 Number of Columns: 23
Table StructureObject Name: 15_Carp_Sedimentation_2018-19.csv Size: 27389 byte Authentication: 00bc0bb6bd58be42bb7024e71d0f7dd7
Calculated By MD5 Text Format:
Number of Header Lines: 1
Record Delimiter: \r\n
Orientation: column
Simple Delimited:
Field Delimiter: ,
Quote Character: "
Table Column Descriptions year lake_name lake_id lat long site_type site_id water_depth_m trap_position trap_depth_m month doy duration_d area_m2 volume_L filter_g volume_filtered_mL dry_wt_g ash_wt_g TSS_mgL ISS_mgL VSS_mgL data_flag Column Name: year lake_name lake_id lat long site_type site_id water_depth_m trap_position trap_depth_m month doy duration_d area_m2 volume_L filter_g volume_filtered_mL dry_wt_g ash_wt_g TSS_mgL ISS_mgL VSS_mgL data_flag Definition: Sampling year (2018) Waterbody from which sediments were collected for the EPC assay Unique lake identifier for the ISU Limnology Lab database Latitude value for the coordinates where sediment trap was deployed Longitude value for the coordinates where sediment trap was deployed Description of location within the lake where the sediment trap was placed Unique identifier for site within the lake where sediment traps were deployed Water depth at the site where the sediment trap was placed Vertical position of individual sediment traps in the water column. Each sediment trap site had traps near the surface and the bottom The water depth of the individual sediment trap (distance from water surface to trap) Month when sediment traps were deployed Julian day of year when sediment traps were retrieved from each lake Duration of time that sediment traps were left in each lake The depositional area within the sediment trap over which settling particles were collected. Volume of water collected within sediment trap Weight of filter used for suspended solids filtering Volume of water filtered for suspended solids analysis Weight of filter and dried suspended solids sample Weight of filter and ashed suspended solids sample Total suspended solids (TSS) concentration within the sediment trap at the end of the deployment. TSS = (dry_wt_g – filter_g) / volume_filtered_mL * 1,000,000 Involatile suspended solids (ISS) concentration within the sediment trap at the end of the deployment ISS = (ash_wt_g – filter_g) / volume_filtered_mL * 1,000,000 Volatile suspended solids (VSS) concentration within the sediment trap at the end of the deployment VSS = (dry_wt_g – ash_wt_g) / volume_filtered_mL * 1,000,000 Data flag to indicate whether a corresponding sediment trap was lost in the field or if there was a laboratory error Storage Type: dateTime string string float float string string float string float string float float float float float float float float float float float string Measurement Type: dateTime nominal nominal ratio ratio nominal nominal ratio nominal ratio nominal ratio ratio ratio ratio ratio ratio ratio ratio ratio ratio ratio nominal Measurement Values Domain: +/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Center Definition Center Lake Source
Code Definition Code Five Island Definition Five Island Lake Source
Code Definition Code North Twin Definition North Twin Lake Source
Code Definition Code Silver Definition Silver Lake (Dickinson County) Source
Code Definition Code South Twin Definition South Twin Lake Source
Code Definition Code Storm Definition Storm Lake Source
Code Definition Code Swan Definition Swan Lake Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code 19 Definition Center Lake Source
Code Definition Code 36 Definition Five Island Lake Source
Code Definition Code 90 Definition North Twin Lake Source
Code Definition Code 105 Definition Silver Lake (Dickinson County) Source
Code Definition Code 113 Definition Storm Lake Source
Code Definition Code 114 Definition Swan Lake Source
Code Definition Code 406 Definition South Twin Lake Source
Unit Decimal degree Type real
Unit Decimal degree Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code deep Definition deepest site in the lake Source
Code Definition Code littoral Definition more shallow sampling sites Source
Definition Unique identifier for site within the lake where sediment traps were deployed
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code Bottom Definition sediment trap located closer to the bottom of the lake Source
Code Definition Code Top Definition sediment trap located closer to the water surface Source
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code July Definition July Source
Code Definition Code June Definition June Source
Code Definition Code May Definition May Source
Unit Julian Day of Year Type integer
Unit milliliter Type integer
Unit milligramPerLiter Type real
Unit milligramPerLiter Type real
Unit milligramPerLiter Type real
+/- Allowed Values and DefinitionsEnumerated Domain Code Definition Code nan Definition No data flag Source
Code Definition Code M Definition This sediment trap sample is missing a corresponding top or bottom sample because it was lost in the field Source
Code Definition Code V Definition TSS, VSS, or ISS value could not be computed because the sample mass on the filter was less than the original mass of the filter Source
Missing Value Code: Code NA Expl Missing sediment trap
Code NA Expl Missing sediment trap
Code NA Expl Missing sediment trap
Accuracy Report: Accuracy Assessment: Coverage: Methods:
Non-Categorized Data Resource Non-Categorized Data Resource Non-Categorized Data Resource