Environmental Data Initiative logo
EDI Staging Environment

Data Package Metadata   View Summary

Weather and hydrological data formatted to ODM 1.1 for North Temperate Lakes, archived from ClimDB/HydroDB (1869 to 2020)

General Information
Data Package:
Local Identifier:edi.727.2
Title:Weather and hydrological data formatted to ODM 1.1 for North Temperate Lakes, archived from ClimDB/HydroDB (1869 to 2020)
Alternate Identifier:DOI PLACE HOLDER
Abstract:

The National Science Foundation's Long-Term Ecological Research (LTER) program and many U.S. Forest Service Experimental Research Stations collect and maintain extensive, long-term ecological databases including streamflow and meteorological measurements. These databases have been widely used in intersite comparisons, modeling studies, and land management-related studies. Intersite research was facilitated by a centralized database called Climate and Hydrology Database Projects (CLIMDB/HYDRODB), initiated in 1998. The database was actively maintained until approximately 2015, and received contributions from 45 contributing LTER and USFS sites. In 2018, it was decided that a more modern system aligned with a broader community would be more appropriate for this type of data. The system maintained by the Consortium of Universities for the Advancement of Hydrologic Science (CUAHSI) was chosen.

This data package contains data contributed by the site North Temperate Lakes (NTL) to ClimDBHydroDB, which has been reformatted to the Observations Data Model (ODM) 1.1 model for contribution to the CUAHSI system. This package contains the six data tables required for upload to CUAHSI. Data are available for 11 station(s): (1) Noble F. Lee Municipal airport north of Minocqua (1989,2016), (2) ALLEQUASH CREEK AT CTH M NR BOULDER JUNCTION, WI (USGS) (1991,2020), (3) NORTH CREEK @ TROUT LAKE NR BOULDER JUNCTION, WI (USGS) (1991,2020), (4) PHEASANT BRANCH AT MIDDLETON, WI (USGS) (1974,2020), (5) SPRING HARBOR STORM SEWER AT MADISON, WI (USGS) (1976,2020), (6) STEVENSON CREEK AT CTH M NR BOULDER JUNCTION, WI (USGS) (1991,2020), (7) TROUT RIVER @ TROUT LAKE NR BOULDER JUNCTION, WI (USGS) (1991,2020), (8) YAHARA RIVER AT WINDSOR, WI (USGS) (1976,2020), (9) Madison raw climate data (1869,2002), (10) Madison adjusted climate data (1869,2016), (11) MINOCQUA (1978,2016).

Publication Date:2021-04-19

Time Period
Begin:
1869-01-01
End:
2020-07-31

People and Organizations
Contact:Stephenson, Aaron (UnivofWisconsin.680NParkSt) [  email ]
Contact:Gries, Corinna (UW-CenterforLimnology) [  email ]
Creator:North Temperate Lakes LTER
Creator:Stanley, Emily 
Associate:Benson, Barbara 
Associate:Balsiger, Dave 
Associate:Stanley, Emily 

Data Entities
Data Table Name:
Variables
Description:
Variable definitions
Data Table Name:
DataValue
Description:
Values and variable names in long format
Data Table Name:
QualityControlLevels
Description:
Quality control levels
Data Table Name:
Sites
Description:
Site description and lat longs
Data Table Name:
Methods
Description:
Methods
Data Table Name:
Sources
Description:
Research project providing these data
Detailed Metadata

Data Entities

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/727/2/03df896fc71cd516fdcf44aa699c4933
Name:Variables
Description:Variable definitions
Number of Records:22
Number of Columns:11

Table Structure
Object Name:NTL_Variables.csv
Size:2066 bytes
Authentication:dcb58a13243b60ff4cfe052730c7e3f3 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\r\n
Orientation:column
Simple Delimited:
Field Delimiter:,

Table Column Descriptions
 
Column Name:VariableCode  
VariableName  
VariableUnitsName  
DataType  
SampleMedium  
ValueType  
IsRegular  
TimeSupport  
TimeUnitsName  
GeneralCategory  
NoDataValue  
Definition:User or organization-defined code to describe the variable. If for example, you are measuring streamflow, you may name this SF.Full text name of the variable that was measured, observed, modeled, etc. Example: Streamflow. Choose from the Variable Name controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=VariableNameCV&id=1157579162The name of units of the data values associated with a variable. Example: degree. Choose from the Units controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=Units&id=1125579048The recorded value over the time interval being sampled. Example: average. Choose from the DataType controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=DataTypeCV&id=789577851The medium in which the sample or observation was taken or made. Example: Surface water. Choose from the SampleMedium controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=SampleMediumCV&id=821577965Text value indicating what type of data value is being recorded. Example: Field Observation. Choose from the ValueType controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=ValueTypeCV&id=1141579105Value indicates whether the data values are from a regularly sampled time series. Choose TRUE or FALSE.Numerical value that indicates the time support (or temporal footprint) of the data values. 0 is used to indicate data values that are instantaneous. Other values indicate the time over which the data values are implicitly or explicitly averaged or aggregated. The Timesupport goes along with TimeUnitsName if IsRegularlyMeasured = TRUE.The name of units of the time support. If TimeSupport is 0, indicating an instantaneous observation, a unit needs to still be given for completeness, although it is somewhat arbitrary. Choose from the Units controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=Units&id=1125579048General category of data. Example: Hydrology. Choose from the GeneralCategory controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=GeneralCategoryCV&id=805577908Numeric value used to encode no data values for this variable. When formatting the Data Values table, use this number to indicate no data value was measured.
Storage Type:string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
Measurement Type:nominalnominalnominalnominalnominalnominalnominalnominalnominalnominalnominal
Measurement Values Domain:
DefinitionUser or organization-defined code to describe the variable. If for example, you are measuring streamflow, you may name this SF.
DefinitionFull text name of the variable that was measured, observed, modeled, etc. Example: Streamflow. Choose from the Variable Name controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=VariableNameCV&id=1157579162
DefinitionThe name of units of the data values associated with a variable. Example: degree. Choose from the Units controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=Units&id=1125579048
DefinitionThe recorded value over the time interval being sampled. Example: average. Choose from the DataType controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=DataTypeCV&id=789577851
DefinitionThe medium in which the sample or observation was taken or made. Example: Surface water. Choose from the SampleMedium controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=SampleMediumCV&id=821577965
DefinitionText value indicating what type of data value is being recorded. Example: Field Observation. Choose from the ValueType controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=ValueTypeCV&id=1141579105
DefinitionValue indicates whether the data values are from a regularly sampled time series. Choose TRUE or FALSE.
DefinitionNumerical value that indicates the time support (or temporal footprint) of the data values. 0 is used to indicate data values that are instantaneous. Other values indicate the time over which the data values are implicitly or explicitly averaged or aggregated. The Timesupport goes along with TimeUnitsName if IsRegularlyMeasured = TRUE.
DefinitionThe name of units of the time support. If TimeSupport is 0, indicating an instantaneous observation, a unit needs to still be given for completeness, although it is somewhat arbitrary. Choose from the Units controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=Units&id=1125579048
DefinitionGeneral category of data. Example: Hydrology. Choose from the GeneralCategory controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=GeneralCategoryCV&id=805577908
DefinitionNumeric value used to encode no data values for this variable. When formatting the Data Values table, use this number to indicate no data value was measured.
Missing Value Code:                      
Accuracy Report:                      
Accuracy Assessment:                      
Coverage:                      
Methods:                      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/727/2/c7859cb58bee902dc86f1742665ff96f
Name:DataValue
Description:Values and variable names in long format
Number of Records:777603
Number of Columns:9

Table Structure
Object Name:NTL_DataValues.csv
Size:46382712 bytes
Authentication:6bcf495b567390bab7333cae0c68539d Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
Orientation:column
Simple Delimited:
Field Delimiter:,

Table Column Descriptions
 
Column Name:DataValue  
LocalDateTime  
UTCOffset  
DateTimeUTC  
SiteCode  
VariableCode  
MethodCode  
SourceCode  
QualityControlLevelCode  
Definition:The numeric value of the observation. For Categorical variables, a number is stored here. The Variables table has DataType as Categorical and the Categories table maps from the DataValue onto Category Description.Local date and time at which the data value was observed. Represented in an implementation specific format.Offset in hours from UTC time of the corresponding LocalDateTime value.Universal UTC date and time at which the data value was observed. Represented in an implementation specific format.Code used by organization that collects the data to identify the site.Code used by the organization that collects the data to identify the variable.Code used by the organization that collects the data to identify the Method, which is defined in the Methods table.Code used by the organization that collects the data to identify the source, which is defined in the Sources table.Code which identifies the level of quality control that the value has been subjected to. This references the QualityControlLevels table.
Storage Type:float  
date  
float  
date  
string  
string  
string  
string  
string  
Measurement Type:ratiodateTimeratiodateTimenominalnominalnominalnominalnominal
Measurement Values Domain:
Unitdimensionless
Typereal
Min-44.44 
Max44174.29 
FormatYYYY-MM-DD hh:mm:ss
Precision
UnitnominalHour
Typenatural
FormatYYYY-MM-DD hh:mm:ss
Precision
DefinitionCode used by organization that collects the data to identify the site.
DefinitionCode used by the organization that collects the data to identify the variable.
DefinitionCode used by the organization that collects the data to identify the Method, which is defined in the Methods table.
DefinitionCode used by the organization that collects the data to identify the source, which is defined in the Sources table.
DefinitionCode which identifies the level of quality control that the value has been subjected to. This references the QualityControlLevels table.
Missing Value Code:                  
Accuracy Report:                  
Accuracy Assessment:                  
Coverage:                  
Methods:                  

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/727/2/063ba612a9d136c60f58f7bbf05b754b
Name:QualityControlLevels
Description:Quality control levels
Number of Records:6
Number of Columns:3

Table Structure
Object Name:NTL_QualityControlLevels.csv
Size:1627 bytes
Authentication:ba3a5cdd6844ffe91e5125364c3599ce Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\r\n
Orientation:column
Simple Delimited:
Field Delimiter:,

Table Column Descriptions
 
Column Name:QualityControlLevelCode  
Definition  
Explanation  
Definition:Code used to identify the level of quality control to which data values have been subjected.Definition of Quality Control LevelExplanation of Quality Control Level
Storage Type:string  
string  
string  
Measurement Type:nominalnominalnominal
Measurement Values Domain:
DefinitionCode used to identify the level of quality control to which data values have been subjected.
DefinitionDefinition of Quality Control Level
DefinitionExplanation of Quality Control Level
Missing Value Code:      
Accuracy Report:      
Accuracy Assessment:      
Coverage:      
Methods:      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/727/2/3faa64303d5f5bcd043bb88f6768e603
Name:Sites
Description:Site description and lat longs
Number of Records:11
Number of Columns:7

Table Structure
Object Name:NTL_Sites.csv
Size:848 bytes
Authentication:f5c3d241438e4ec712c032c56cf830c4 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\r\n
Orientation:column
Simple Delimited:
Field Delimiter:,

Table Column Descriptions
 
Column Name:SiteCode  
SiteName  
Latitude  
Longitude  
LatLongDatumSRSName  
SiteType  
Comments  
Definition:User or organization-defined code that collects the data to identify the site.Full name of the sampling site.Latitude in decimal degrees.Longitude in decimal degrees. East positive, West negative.Full text name of the spatial reference system of the latitude and longitude coordinates in the SpatialReferences table. This should be from the SpatialReferences controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=SpatialReferences&id=869578136The type of site. This should be from the SiteType controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=SiteTypeCV&id=853578079Comments related to the site.
Storage Type:string  
string  
float  
float  
string  
string  
string  
Measurement Type:nominalnominalratiorationominalnominalnominal
Measurement Values Domain:
DefinitionUser or organization-defined code that collects the data to identify the site.
DefinitionFull name of the sampling site.
Unitdegree
Typenatural
Min46 
Max46 
Unitdegree
Typereal
Min-89.7 
Max-89.7 
DefinitionFull text name of the spatial reference system of the latitude and longitude coordinates in the SpatialReferences table. This should be from the SpatialReferences controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=SpatialReferences&id=869578136
DefinitionThe type of site. This should be from the SiteType controlled vocabulary: http://his.cuahsi.org/mastercvreg/edit_cv11.aspx?tbl=SiteTypeCV&id=853578079
DefinitionComments related to the site.
Missing Value Code:              
Accuracy Report:              
Accuracy Assessment:              
Coverage:              
Methods:              

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/727/2/20c51b5f4e9aeb5334c90ff072e6f928
Name:Methods
Description:Methods
Number of Records:20
Number of Columns:3

Table Structure
Object Name:NTL_Methods.csv
Size:788 bytes
Authentication:44eb55766a805720be8fdb4e69bcf5bf Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\r\n
Orientation:column
Simple Delimited:
Field Delimiter:,

Table Column Descriptions
 
Column Name:MethodCode  
MethodDescription  
MethodLink  
Definition:User or organization-defined code that collects the data to identify the method used for measurementText description of each method.Link to additional reference material on the method.
Storage Type:string  
string  
string  
Measurement Type:nominalnominalnominal
Measurement Values Domain:
DefinitionUser or organization-defined code that collects the data to identify the method used for measurement
DefinitionText description of each method.
DefinitionLink to additional reference material on the method.
Missing Value Code:      
Accuracy Report:      
Accuracy Assessment:      
Coverage:      
Methods:      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/727/2/fb61758d0f0fda4ba867c3d5a46c16a7
Name:Sources
Description:Research project providing these data
Number of Records:1
Number of Columns:7

Table Structure
Object Name:NTL_Sources.csv
Size:246 bytes
Authentication:754bc0babd6c4b5d7a5659eb37368a39 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\r\n
Orientation:column
Simple Delimited:
Field Delimiter:,

Table Column Descriptions
 
Column Name:SourceCode  
Organization  
SourceDescription  
SourceLink  
ContactName  
Email  
Citation  
Definition:Code used to identify the organization that created the dataName of the organization that collected the data. This should be the agency or organization that collected the data, even if it came out of a database consolidated from many sources.Full text description of the source of the data.Link that can be pointed at the original data file and/or associated metadata stored in the digital library or URL of data source.Name of the contact person for the data sourceEmail address for the contact personText string that give the citation to be used when the data from each source are reference
Storage Type:string  
string  
string  
string  
string  
string  
string  
Measurement Type:nominalnominalnominalnominalnominalnominalnominal
Measurement Values Domain:
DefinitionCode used to identify the organization that created the data
DefinitionName of the organization that collected the data. This should be the agency or organization that collected the data, even if it came out of a database consolidated from many sources.
DefinitionFull text description of the source of the data.
DefinitionLink that can be pointed at the original data file and/or associated metadata stored in the digital library or URL of data source.
DefinitionName of the contact person for the data source
DefinitionEmail address for the contact person
DefinitionText string that give the citation to be used when the data from each source are reference
Missing Value Code:              
Accuracy Report:              
Accuracy Assessment:              
Coverage:              
Methods:              

Data Package Usage Rights

This data package is released to the \"public domain\" under Creative Commons CC0 1.0 \"No Rights Reserved\" (see: https://creativecommons.org/publicdomain/zero/1.0/). It is considered professional etiquette to provide attribution of the original work if this data package is shared in whole or by individual components. A generic citation is provided for this data package on the website https://portal.edirepository.org (herein \"website\") in the summary metadata page. Communication (and collaboration) with the creators of this data package is recommended to prevent duplicate research or publication. This data package (and its components) is made available \"as is\" and with no warranty of accuracy or fitness for use. The creators of this data package and the website shall not be liable for any damages resulting from misinterpretation or misuse of the data package or its components. Periodic updates of this data package may be available from the website. Thank you.

Keywords

By Thesaurus:
(No thesaurus)LTER ClimDB/HydroDB, North Temperate Lakes, Observations Data Model (ODM) 1.1, Temperature dew point, Discharge, Global radiation, Precipitation, Relative humidity, Soil water content, Soil temperature, Snow depth, Air temperature, Vapor pressure, Surface water temperature, Wind speed

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

Methods and protocols used in the collection of this data package
Description:

The data were extracted from the ClimDB/HydroDB database with SQL statements and converted into tables conforming to Observations Data Model (ODM) 1.1. Export and EML creation scripts can be found at https://github.com/lter/Clim-HydroDB-2.0. Appropriate text metadata (not available from ClimDB/HydroDB) was added, including abstract, these extraction methods, keywords, and geographic coverage (if missing from ClimDB/HydroDB).

People and Organizations

Publishers:
Organization:Environmental Data Initiative
Email Address:
info@environmentaldatainitiative.org
Web Address:
https://environmentaldatainitiative.org
Creators:
Individual: North Temperate Lakes LTER
Individual: Emily Stanley
Email Address:
ehstanley@wisc.edu
Contacts:
Individual: Aaron Stephenson
Organization:UnivofWisconsin.680NParkSt
Email Address:
ajstephenson@wisc.edu
Individual: Corinna Gries
Organization:UW-CenterforLimnology
Email Address:
cgries@wisc.edu
Associated Parties:
Individual: Barbara Benson
Email Address:
bjbenson@facstaff.wisc.edu
Role:Associated Party
Individual: Dave Balsiger
Email Address:
dbalsiger@wisc.edu
Role:Associated Party
Individual: Emily Stanley
Email Address:
ehstanley@wisc.edu
Role:Principal Investigator

Temporal, Geographic and Taxonomic Coverage

Temporal, Geographic and/or Taxonomic information that applies to all data in this dataset:

Time Period
Begin:
1869-01-01
End:
2020-07-31
Sampling Site: 
Description:NTL
Site Coordinates:
Longitude (degree): -89.7Latitude (degree): 46

Project

Maintenance

Maintenance:
Description:completed
Frequency:
Other Metadata

Copyright 2024 Environmental Data Initiative. This material is based upon work supported by the National Science Foundation under grants #2223103 and #2223104. Any opinions, findings, conclusions, or recommendations expressed in the material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation. Please contact us with questions, comments, or for technical assistance regarding this web site or the Environmental Data Initiative. Please read our privacy policy to know what information we collect about you and to understand your privacy rights.

EDI is a collaboration between the University of New Mexico and the University of Wisconsin – Madison, Center for Limnology:

UNM logo UW-M logo