Environmental Data Initiative logo
EDI Staging Environment

Data Package Metadata   View Summary

Weather and hydrological data formatted to ODM 1.1 for Santa Barbara Coastal, archived from ClimDB/HydroDB (1927 to 2020)

General Information
Data Package:
Local Identifier:edi.729.1
Title:Weather and hydrological data formatted to ODM 1.1 for Santa Barbara Coastal, archived from ClimDB/HydroDB (1927 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 Santa Barbara Coastal (SBC) 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 58 station(s): (1) NEWHALL 5 NW (1997,2003), (2) NEWHALL S FC32CE (1949,2001), (3) OJAI (1948,2003), (4) OXNARD (1948,2002), (5) OXNARD WSFO (1998,2003), (6) PIRU 2 ESE (1959,2003), (7) SANDBERG (1948,2003), (8) SANTA BARBARA (1927,2003), (9) SANTA BARBARA MUNICIPAL AP (1941,2003), (10) SANTA PAULA (1948,2003), (11) SAUGUS POWER PLANT 1 (1948,2003), (12) VENTURA (1948,2003), (13) SANTA CLARA RIVER AT MONTALVO CA (USGS) (1927,2004), (14) VENTURA R NR VENTURA (USGS) (1929,2020), (15) VENTURA R NR VENTURA+ DIV. CA (USGS) (1932,2007), (16) CARPINTERIA C NR CARPINTERIA CA (USGS) (1941,2020), (17) MISSION C A RNP A SANTA BARBARA CA (USGS) (1983,2020), (18) MISSION C NR MISSION ST NR SANTA BARBARA CA (USGS) (1970,2020), (19) ARROYO BURRO A SANTA BARBARA CA (USGS) (1970,1993), (20) MARIA YGNACIO C A UNIV DR NR GOLETA CA (USGS) (1970,2020), (21) ATASCADERO C NR GOLETA CA (USGS) (1941,2020), (22) SAN JOSE C NR GOLETA CA (USGS) (1941,2020), (23) SAN JOSE C A GOLETA CA (USGS) (1970,2000), (24) TECOLOTITO C NR GOLETA CA (USGS) (1970,1991), (25) GAVIOTA C NR GAVIOTA CA (USGS) (1966,1986), (26) SAN PEDRO C A GOLETA CA (1970,2020), (27) Arroyo Burro Creek at Cliff Drive, (28) Bell Canyon Creek at Winchester Canyon Rd, (29) Gaviota Creek at Hwy 101 South Rest Stop, (30) Arroyo Hondo Creek at Hwy 101 Bridge, Upstream Side, (31) Mission Creek at Montecito St, (32) Refugio Creek at Hwy 101, (33) Rattlesnake Creek at Las Canoas Rd, (34) Arroyo Burro Creek at Cliff Drive (2001,2011), (35) Bell Canyon Creek at Winchester Canyon Rd (2004,2011), (36) Gaviota Creek at Hwy 101 South Rest Stop (2001,2010), (37) Arroyo Hondo Creek at Hwy 101 Bridge, Upstream Side (2001,2011), (38) Mission Creek at Montecito St (2001,2011), (39) Refugio Creek at Hwy 101 (2001,2011), (40) Rattlesnake Creek at Las Canoas Rd (2001,2011), (41) Carpinteria at Veddars Ranch, (42) Carpinteria at Veddars Ranch (2002,2009), (43) El Capitan at State Beach, (44) El Capitan at State Beach (2004,2010), (45) Gaviota at Las Cruces School, (46) Gaviota at Las Cruces School (2002,2010), (47) Arroyo Hondo at East Avocado Orchard, (48) Arroyo Hondo at East Avocado Orchard (2002,2010), (49) Arroyo Hondo at Upper Outlaw Trail, (50) Arroyo Hondo at Upper Outlaw Trail (2002,2010), (51) Refugio at State Park, (52) Refugio at State Park (2004,2010), (53) Refugio at Lower Aguacitos Ranch, (54) Refugio at Lower Aguacitos Ranch (2002,2010), (55) Refugio at Upper Aguacitos Ranch, (56) Refugio at Upper Aguacitos Ranch (2002,2010), (57) Refugio at Rancho La Scherpa, (58) Refugio at Rancho La Scherpa (2002,2010).

Publication Date:2021-02-16

Time Period
Begin:
1927-10-01
End:
2020-08-01

People and Organizations
Contact:Beighley, Ed (MarineScienceInstitute,UniversityofCalifornia) [  email ]
Contact:O'Brien, Margaret (SBC-LTERDataManagementMarineScienceInstituteUCSB) [  email ]
Creator:O'Brien, Margaret (SBC-LTERDataManagementMarineScienceInstituteUCSB)
Associate:Luan, Wei-Yee 

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/729/1/03df896fc71cd516fdcf44aa699c4933
Name:Variables
Description:Variable definitions
Number of Records:22
Number of Columns:11

Table Structure
Object Name:SBC_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/729/1/c7859cb58bee902dc86f1742665ff96f
Name:DataValue
Description:Values and variable names in long format
Number of Records:996076
Number of Columns:9

Table Structure
Object Name:SBC_DataValues.csv
Size:77697974 bytes
Authentication:54b957d5f11b42e8ac812bff9a7547e6 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: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-18.7 
Max2613645.2 
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/729/1/063ba612a9d136c60f58f7bbf05b754b
Name:QualityControlLevels
Description:Quality control levels
Number of Records:6
Number of Columns:3

Table Structure
Object Name:SBC_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/729/1/3faa64303d5f5bcd043bb88f6768e603
Name:Sites
Description:Site description and lat longs
Number of Records:58
Number of Columns:7

Table Structure
Object Name:SBC_Sites.csv
Size:3623 bytes
Authentication:842e7dd2b5672f279ab691287b4a63b8 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\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
Typereal
Min34.4125 
Max34.4125 
Unitdegree
Typereal
Min-119.842 
Max-119.842 
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/729/1/20c51b5f4e9aeb5334c90ff072e6f928
Name:Methods
Description:Methods
Number of Records:20
Number of Columns:3

Table Structure
Object Name:SBC_M.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/729/1/fb61758d0f0fda4ba867c3d5a46c16a7
Name:Sources
Description:Research project providing these data
Number of Records:1
Number of Columns:7

Table Structure
Object Name:SBC_Sources.csv
Size:231 bytes
Authentication:6b5c61a0fddfc33edc024839cd1df927 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 information is released under the Creative Commons license - Attribution - CC BY (https://creativecommons.org/licenses/by/4.0/). The consumer of these data (\"Data User\" herein) is required to cite it appropriately in any publication that results from its use. The Data User should realize that these data may be actively used by others for ongoing research and that coordination may be necessary to prevent duplicate publication. The Data User is urged to contact the authors of these data if any questions about methodology or results occur. Where appropriate, the Data User is encouraged to consider collaboration or co-authorship with the authors. The Data User should realize that misinterpretation of data may occur if used out of context of the original study. While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed. All data are made available \"as is.\" The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data. Thank you.

Keywords

By Thesaurus:
(No thesaurus)LTER ClimDB/HydroDB, Santa Barbara Coastal, Observations Data Model (ODM) 1.1, Atmospheric pressure, Temperature dew point, Discharge, Precipitation, Relative humidity, Soil temperature, Air temperature, Wind direction, Surface water temperature

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: Margaret O'Brien
Organization:SBC-LTERDataManagementMarineScienceInstituteUCSB
Email Address:
mob@msi.ucsb.edu
Contacts:
Individual: Ed Beighley
Organization:MarineScienceInstitute,UniversityofCalifornia
Email Address:
beighley@icess.ucsb.edu
Individual: Margaret O'Brien
Organization:SBC-LTERDataManagementMarineScienceInstituteUCSB
Email Address:
mob@msi.ucsb.edu
Associated Parties:
Individual: Wei-Yee Luan
Email Address:
luan@lifesci.ucsb.edu
Role:Associated Party

Temporal, Geographic and Taxonomic Coverage

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

Time Period
Begin:
1927-10-01
End:
2020-08-01
Sampling Site: 
Description:SBC
Site Coordinates:
Longitude (degree): -119.842Latitude (degree): 34.4125

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