Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/1439/4/f4b1df4f4544ba0d015690c923bf9868 | Name: | chemistry_limno | Description: | The water chemistry observations in this file represent samples from a single day collected from the upper waters or epilimnion at a primary site representing each lake. Each row is identified by a unique sample_id that represents an individual chemical parameter (parameter_id) for a single sampling event (eventid_epi), lagoslakeid, cluster_id, and sample_date. In addition to the parameter_id and parameter_value, we also include the LAGOS-assigned censorcode and detection limit value where available. | Number of Records: | 3511020 | Number of Columns: | 16 |
| Table Structure |
---|
Object Name: | chemistry_limno.csv | Size: | 450060577 bytes | Authentication: | 593daf1c5c1c797aa4f8402187b6a123
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | | | | | | | | | | | | | | | | |
---|
Column Name: | eventid_epi
| lagoslakeid
| sample_date
| sample_id
| parameter_id
| parameter_name
| parameter_value
| parameter_detectionlimit_value
| censorcode
| sample_depth_m
| source_sample_type
| cluster_id
| cluster_lat_dd
| cluster_lon_dd
| source_id
| source_sample_siteid
| Definition: | unique key indicating a sampling event according to lake x sampling date | unique lake identifier developed by LAGOS US | date, as YYYY-MM-DD, when the lake was sampled by the source program; from the WQP field ActivityStartDate, the calendar date on which the field activity is started. | LIMNO assigned key assigned to each unique water chemistry observation as it is downloaded from the WQP; consists of the abbreviation of the state in the individual pull from the WQP and a sequential number separated by a dash. | LIMNO assigned unique parameter identification number | LIMNO assigned parameter short name | measurement reported by the source converted to the LIMNO designated standard unit for the parameter | detection limit reported by the source converted to the LIMNO designated standard unit for the parameter | LIMNO assigned code indicating if the observation was not censored (NC) or censored (LE=less than or equal to) | depth at which the sample was taken; if depth was inferred a sample depth of 0 was assigned. | flag indicating whether the sample depth was inferred, specified, or unknown or whether the sample was collected as a depth integrated sample. | unique identifier of the sample sites grouped into a co-located cluster; consists of the lagoslakeid, underscore, alphabetical cluster identifier. | latitude of the central point of the site cluster | longitude of the central point of the site cluster | WQP variable OrganizationIdentifier, a unique identifier of the data source of the observation. | WQP variable MonitoringLocationIdentifier, designator used to describe the unique name, number, or code assigned to identify the monitoring location. | Storage Type: | float
| float
| string
| string
| float
| string
| float
| float
| string
| float
| string
| string
| float
| float
| string
| string
| Measurement Type: | ratio | ratio | nominal | nominal | ratio | nominal | ratio | ratio | nominal | ratio | nominal | nominal | ratio | ratio | nominal | nominal | Measurement Values Domain: | Unit | dimensionless | Type | natural | Min | 1 | Max | 1050693 |
| Unit | dimensionless | Type | natural | Min | 2 | Max | 483387 |
| Definition | date, as YYYY-MM-DD, when the lake was sampled by the source program; from the WQP field ActivityStartDate, the calendar date on which the field activity is started. |
| Definition | LIMNO assigned key assigned to each unique water chemistry observation as it is downloaded from the WQP; consists of the abbreviation of the state in the individual pull from the WQP and a sequential number separated by a dash. |
| Unit | dimensionless | Type | natural | Min | 1 | Max | 53 |
| Definition | LIMNO assigned parameter short name |
| Unit | dimensionless | Type | real | Min | -340 | Max | 434000 |
| Unit | dimensionless | Type | real | Min | -0.067 | Max | 499900 |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | LE1 | Definition | parameter_value less than or equal to the parameter_detectionlimit_value, detection limit value provided; qualifier and or comments provided | Source | |
| Code Definition | Code | LE2 | Definition | parameter_value less than or equal to the parameter_detectionlimit_value, detection limit value provided; qualifier and or comments missing | Source | |
| Code Definition | Code | LE5 | Definition | parameter_value is missing; detection limit present | Source | |
| Code Definition | Code | LE6 | Definition | parameter_value equals 0; detection limit value missing and neither qualifier nor comments provided | Source | |
| Code Definition | Code | NC1 | Definition | parameter_value greater than the parameter_detectionlimit_value, detection limit value provided; qualifier and or comments provided | Source | |
| Code Definition | Code | NC2 | Definition | parameter_value greater than the parameter_detectionlimit_value, detection limit value provided; neither qualifier or comments provided | Source | |
| Code Definition | Code | NC3 | Definition | parameter_detectionlimit_value is missing; qualifier and or comments are provided | Source | |
| Code Definition | Code | NC4 | Definition | parameter_detectionlimit_value is missing; neither qualifier or comments provided | Source | |
|
|
| Unit | meter | Type | real | Min | 0 | Max | 14.9352 |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | INFERRED | Definition | sample depth were inferred from sample methods (e.g., grab, bucket, etc) | Source | |
| Code Definition | Code | INTEGRATED | Definition | sample depth defined from a water column integrated sample | Source | |
| Code Definition | Code | SPECIFIED | Definition | sample depth specified in the WQP data | Source | |
|
|
| Definition | unique identifier of the sample sites grouped into a co-located cluster; consists of the lagoslakeid, underscore, alphabetical cluster identifier. |
| Unit | degree | Type | real | Min | 25.192067 | Max | 49.361667 |
| Unit | degree | Type | real | Min | -124.653833 | Max | -67.1397 |
| Definition | WQP variable OrganizationIdentifier, a unique identifier of the data source of the observation. |
| Definition | WQP variable MonitoringLocationIdentifier, designator used to describe the unique name, number, or code assigned to identify the monitoring location. |
| Missing Value Code: | | | | | | | | | | | | | | | | | Accuracy Report: | | | | | | | | | | | | | | | | | Accuracy Assessment: | | | | | | | | | | | | | | | | | Coverage: | | | | | | | | | | | | | | | | | Methods: | | | | | | | | | | | | | | | | |
|
Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/1439/4/fdc599cf0501e13423e19860a503fff3 | Name: | sourcedata_limno | Description: | This file contains the source data corresponding to each observation in chemistry_limno linked via the unique sample_id. Included are the original units and values, source organization identifiers, legacy site identifiers, methods, sample qualifiers, and source sample site identifiers as described in the original data download. The table provides the LIMNO assigned conversion factors applied to harmonize values and detection limits. | Number of Records: | 3511020 | Number of Columns: | 26 |
| Table Structure |
---|
Object Name: | sourcedata_limno.csv | Size: | 992536436 bytes | Authentication: | 58132c6ee0ae6998981afbc4c131808f
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
Column Name: | lagoslakeid
| sample_id
| parameter_id
| source_id
| source_name
| source_activityorg_name
| source_sample_siteid
| source_activityid
| source_comments
| source_parameter_name
| source_parameter_value
| source_parameter_unit
| source_value_qualifiercode
| parameter_conversionfactor
| source_detectionlimit_value
| source_detectionlimit_unit
| parameter_detectionlimit_conversionfactor
| source_detectionlimit_condition
| source_detectionlimit_type
| source_labmethod_usgspcode
| source_labmethod_description
| source_labmethod_id
| source_labmethod_name
| source_labmethod_qualifier
| source_samplesite_lat_dd
| source_samplesite_lon_dd
| Definition: | unique lake identifier developed by LAGOS US | LIMNO assigned key assigned to each unique water chemistry observation as it is downloaded from the WQP; consists of the abbreviation of the state being downloaded from the WQP and a sequential number separated by a dash. | LIMNO assigned unique parameter identification number | WQP variable OrganizationIdentifier, a unique identifier of the data source of the observation. | WQP variable OrganizationFormalName, the legal designator, i.e. formal name, of an organization. | WQP variable ActivityConductingOrganizationText, name of the Organization conducting an activity. | WQP variable MonitoringLocationIdentifier, designator used to describe the unique name, number, or code assigned to identify the monitoring location. | WQP variable ActivityIdentifier, designator that uniquely identifies an activity within an organization. | source comments formed by concatenated WQP variables ActivityCommentText,ResultCommentText, free text with general comments concerning the result.; ResultLaboratoryCommentText, remarks which further describe the laboratory procedures which produced the result; MeasureQualifierCode, a code used to identify any qualifying issues that affect the results; ResultDetectionConditionText, the textual descriptor of a result. | WQP variable CharacteristicName, the object, property, or substance which is evaluated or enumerated by either a direct field measurement, a direct field observation, or by laboratory analysis of material collected in the field. | WQP variable ResultMeasureValue, the reportable measure of the result for the chemical, microbiological or other characteristic being analyzed; some values are preceeded by a less than symbol. | WQP variable ResultMeasure.MeasureUnitCode, the code that represents the unit for measuring the parameter. | WQP variable MeasureQualifierCode, code used to identify any qualifying issues that affect the results. | LIMNO assigned factor used to convert source parameter value to harmonized LIMNO units | WQP variable DetectionQuantitationLimitMeasure.MeasureValue, constituent concentration that, when processed through the complete method, produces a signal that is statistically different from a blank. | WQP variable DetectionQuantitationLimitMeasure.MeasureUnitCode, the code that represents the unit for measuring the item. | LIMNO assigned factor used to convert the source detection limit to harmonized LIMNO units | WQP variable ResultDetectionConditionText, the textual descriptor of a result. | WQP variable DetectionQuantitationLimitTypeName, text describing the type of detection or quantitation level used in the analysis of a characteristic. | WQP variable USGSPCode, 5-digit number used in the US Geological Survey computerized data system, National Water Information System (NWIS), to uniquely identify a specific constituent. | WQP variable MethodDescriptionText, a brief summary that provides general information about the method. | concatenated WQP variables ResultAnalyticalMethod.MethodIdentifierContext, Identifies the source or data system that created or defined the identifier; ResultAnalyticalMethod.MethodIdentifier, the identification number or code assigned by the method publisher. | WQP variable ResultAnalyticalMethod.MethodName, the title that appears on the method from the method publisher. | lab or field method information provided by the source on whether chlorophyll concentrations were corrected or uncorrected for pheophytin; if not specified this variable equals unknown | WQP variable LatitudeMeasure, latitude coordinates of the sample site, NAD83, in decimal degrees | WQP variable LongitudeMeasure, latitude coordinates of the sample site, NAD83, in decimal degrees | Storage Type: | float
| string
| float
| string
| string
| string
| string
| string
| string
| string
| string
| string
| string
| float
| float
| string
| float
| string
| string
| float
| string
| string
| string
| string
| float
| float
| Measurement Type: | ratio | nominal | ratio | nominal | nominal | nominal | nominal | nominal | nominal | nominal | nominal | nominal | nominal | ratio | ratio | nominal | ratio | nominal | nominal | ratio | nominal | nominal | nominal | nominal | ratio | ratio | Measurement Values Domain: | Unit | dimensionless | Type | natural | Min | 2 | Max | 483387 |
| Definition | LIMNO assigned key assigned to each unique water chemistry observation as it is downloaded from the WQP; consists of the abbreviation of the state being downloaded from the WQP and a sequential number separated by a dash. |
| Unit | dimensionless | Type | natural | Min | 1 | Max | 53 |
| Definition | WQP variable OrganizationIdentifier, a unique identifier of the data source of the observation. |
| Definition | WQP variable OrganizationFormalName, the legal designator, i.e. formal name, of an organization. |
| Definition | WQP variable ActivityConductingOrganizationText, name of the Organization conducting an activity. |
| Definition | WQP variable MonitoringLocationIdentifier, designator used to describe the unique name, number, or code assigned to identify the monitoring location. |
| Definition | WQP variable ActivityIdentifier, designator that uniquely identifies an activity within an organization. |
| Definition | source comments formed by concatenated WQP variables ActivityCommentText,ResultCommentText, free text with general comments concerning the result.; ResultLaboratoryCommentText, remarks which further describe the laboratory procedures which produced the result; MeasureQualifierCode, a code used to identify any qualifying issues that affect the results; ResultDetectionConditionText, the textual descriptor of a result. |
| Definition | WQP variable CharacteristicName, the object, property, or substance which is evaluated or enumerated by either a direct field measurement, a direct field observation, or by laboratory analysis of material collected in the field. |
| Definition | WQP variable ResultMeasureValue, the reportable measure of the result for the chemical, microbiological or other characteristic being analyzed; some values are preceeded by a less than symbol. |
| Definition | WQP variable ResultMeasure.MeasureUnitCode, the code that represents the unit for measuring the parameter. |
| Definition | WQP variable MeasureQualifierCode, code used to identify any qualifying issues that affect the results. |
| Unit | dimensionless | Type | real | Min | 0.001 | Max | 1e+06 |
| Unit | dimensionless | Type | real | Min | -0.067 | Max | 4000 |
| Definition | WQP variable DetectionQuantitationLimitMeasure.MeasureUnitCode, the code that represents the unit for measuring the item. |
| Unit | dimensionless | Type | real | Min | 0.001 | Max | 1e+06 |
| Definition | WQP variable ResultDetectionConditionText, the textual descriptor of a result. |
| Definition | WQP variable DetectionQuantitationLimitTypeName, text describing the type of detection or quantitation level used in the analysis of a characteristic. |
| Unit | dimensionless | Type | natural | Min | 76 | Max | 99872 |
| Definition | WQP variable MethodDescriptionText, a brief summary that provides general information about the method. |
| Definition | concatenated WQP variables ResultAnalyticalMethod.MethodIdentifierContext, Identifies the source or data system that created or defined the identifier; ResultAnalyticalMethod.MethodIdentifier, the identification number or code assigned by the method publisher. |
| Definition | WQP variable ResultAnalyticalMethod.MethodName, the title that appears on the method from the method publisher. |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | corrected | Definition | values for chlorophyll a were corrected for phaophytin | Source | |
| Code Definition | Code | DL | Definition | values were at detection limit | Source | |
| Code Definition | Code | uncorrected | Definition | values for chlorophyll a were not corrected for phaophytin | Source | |
| Code Definition | Code | unknown | Definition | unknown if chlorophyll a values were corrected | Source | |
|
|
| Unit | dimensionless | Type | real | Min | 25.19206679 | Max | 49.361667 |
| Unit | dimensionless | Type | real | Min | -124.6538333 | Max | -67.1397 |
| Missing Value Code: | | | | | | | | | | | | | | | | | | | | | | | | | | | Accuracy Report: | | | | | | | | | | | | | | | | | | | | | | | | | | | Accuracy Assessment: | | | | | | | | | | | | | | | | | | | | | | | | | | | Coverage: | | | | | | | | | | | | | | | | | | | | | | | | | | | Methods: | | | | | | | | | | | | | | | | | | | | | | | | | | |
|
Data Table | Data: | https://pasta-s.lternet.edu/package/data/eml/edi/1439/4/824b259acddce3ebf5cb63aa5484127e | Name: | cluster_information_limno | Description: | Unique site clusters were derived for each lake from sample site locations provided by the data sources. Individual sites were grouped into clusters of sites within 200 meters of each other. This data table provides the source_sample_siteid and location coordinates; cluster membership; mean and maximum inter-site distance of sites within the cluster; and cluster central coordinates. | Number of Records: | 3511020 | Number of Columns: | 13 |
| Table Structure |
---|
Object Name: | cluster_information_limno.csv | Size: | 435239814 bytes | Authentication: | 6afdc626972624d41cac68abdc0bccb2
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \n |
Orientation: | column |
Simple Delimited: |
Field Delimiter: | , |
Quote Character: | " |
|
|
|
|
Table Column Descriptions |
---|
| | | | | | | | | | | | | | | |
---|
Column Name: | lagoslakeid
| cluster_id
| cluster_lat_dd
| cluster_lon_dd
| source_sample_siteid
| source_samplesite_lat_dd
| source_samplesite_lon_dd
| lake_waterarea_ha
| lake_states
| lake_namelagos
| cluster_meandistance_m
| cluster_maxdistance_m
| cluster_sitedistance_m
| Definition: | unique lake identifier developed by LAGOS US | LIMNO assigned identification code for each cluster of sites within a lake | latitude of the center of the site cluster | longitude of the center of the site cluster | WQP variable MonitoringLocationIdentifier, designator used to describe the unique name, number, or code assigned to identify the monitoring location. | WQP variable LatitudeMeasure, latitude coordinates of the sample site, NAD83, in decimal degrees | WQP variable LongitudeMeasure, latitude coordinates of the sample site, NAD83, in decimal degrees | surface area of lake waterbody polygon from NHD comprised of open water; islands are excluded | two-letter postal abbreviations of all states intersecting the focal lake polygon | lake name from a combination of data sources; examples are GNIS, WQP, etc. | mean distance between sites within the cluster | maximum distance between sites within the cluster | distance between site and the cluster center | Storage Type: | float
| string
| float
| float
| string
| float
| float
| float
| string
| string
| float
| float
| float
| Measurement Type: | ratio | nominal | ratio | ratio | nominal | ratio | ratio | ratio | nominal | nominal | ratio | ratio | ratio | Measurement Values Domain: | Unit | dimensionless | Type | natural | Min | 2 | Max | 483387 |
| Definition | LIMNO assigned identification code for each cluster of sites within a lake |
| Unit | degree | Type | real | Min | 25.192067 | Max | 49.361667 |
| Unit | degree | Type | real | Min | -124.653833 | Max | -67.1397 |
| Definition | WQP variable MonitoringLocationIdentifier, designator used to describe the unique name, number, or code assigned to identify the monitoring location. |
| Unit | degree | Type | real | Min | 25.19206679 | Max | 49.361667 |
| Unit | degree | Type | real | Min | -124.6538333 | Max | -67.1397 |
| Unit | hectare | Type | real | Min | 1.002 | Max | 165032.18 |
| Definition | two-letter postal abbreviations of all states intersecting the focal lake polygon |
| Definition | lake name from a combination of data sources; examples are GNIS, WQP, etc. |
| Unit | meter | Type | real | Min | 0 | Max | 101.823138317342 |
| Unit | meter | Type | natural | Min | 200 | Max | 200 |
| Unit | meter | Type | real | Min | 0 | Max | 161.795572189044 |
| Missing Value Code: | | | | | | | | | | | | | | Accuracy Report: | | | | | | | | | | | | | | Accuracy Assessment: | | | | | | | | | | | | | | Coverage: | | | | | | | | | | | | | | Methods: | | | | | | | | | | | | | |
|
Non-Categorized Data Resource
Non-Categorized Data ResourceName: | Supplementary files.zip | Entity Type: | unknown | Description: | Supplementary files containing allsites_alldepths data, wqp conversion file, and R scripts used to create LAGOS-US LIMNO. | | Physical Structure Description: | Object Name: | Supplementary files.zip | Size: | 420103663 bytes | Authentication: | e452bb2c08091bf98a9686465f23b37d
Calculated By MD5 | Externally Defined Format: |
Format Name: | application/zip |
|
| Data: | https://pasta-s.lternet.edu/package/data/eml/edi/1439/4/205c2c37646f980e5e77790b86f4a38a |
Non-Categorized Data ResourceName: | data_dictionary_limno.csv | Entity Type: | unknown | Description: | Data dictionary - defines the columns within each data and metadata table (dictionary_type = table_dictionary) and provides information on data type, missing values, precision and units. | | Physical Structure Description: | Object Name: | data_dictionary_limno.csv | Size: | 14553 bytes | Authentication: | d8465702e41a85f664601da5e7b04341
Calculated By MD5 | Externally Defined Format: | |
| Data: | https://pasta-s.lternet.edu/package/data/eml/edi/1439/4/0df262e8b73f9443b1bb626c012c3342 |
Non-Categorized Data ResourceName: | parameter_description_limno.csv | Entity Type: | unknown | Description: | Parameter description - table provides additional information on each parameter, including units, upper and lower limits for inclusion, the set of WQP characteristic names queried to assemble values for the parameter. Parameters are grouped into themes which the user can use to select related parameters from the data table for analysis. | | Physical Structure Description: | Object Name: | parameter_description_limno.csv | Size: | 7471 bytes | Authentication: | b156841f07fc4727b0b1805e7d7a801d
Calculated By MD5 | Externally Defined Format: | |
| Data: | https://pasta-s.lternet.edu/package/data/eml/edi/1439/4/e6b757d6411a54a88896a2fa9ad63ae5 |
Non-Categorized Data ResourceName: | domain_dictionary_limno.csv | Entity Type: | unknown | Description: | Domain dictionary - defines the domains for variables classified as factors. An example is the censorcode, which has 8 values depending on the availability of detection limit information. | | Physical Structure Description: | Object Name: | domain_dictionary_limno.csv | Size: | 4487 bytes | Authentication: | 1a575e85f313558ce5bfb587e0d996b1
Calculated By MD5 | Externally Defined Format: | |
| Data: | https://pasta-s.lternet.edu/package/data/eml/edi/1439/4/b3032918b1c5ccda8d4ee424be56862a |
|