storet and the water quality exchange status update dwane young owow/awpd/mb april 26, 2007
TRANSCRIPT
STORET and the Water STORET and the Water Quality Exchange Status Quality Exchange Status
UpdateUpdateDwane Young OWOW/AWPD/MBDwane Young OWOW/AWPD/MB
April 26, 2007April 26, 2007
What is WQX?What is WQX? Water Quality Exchange (WQX) Version 1.0 is a Water Quality Exchange (WQX) Version 1.0 is a
new system that facilitates the submission of new system that facilitates the submission of water quality and related environmental water quality and related environmental monitoring data between EPA and its partners monitoring data between EPA and its partners over the internet over the internet
WQX Version 1.0 uses web technology and a WQX Version 1.0 uses web technology and a common defined template (the WQX schema) to common defined template (the WQX schema) to flow physical, chemical and fish tissue data from flow physical, chemical and fish tissue data from an EPA data partner’s own database to the an EPA data partner’s own database to the existing STORET Warehouse existing STORET Warehouse
EPA’s Vision for WQXEPA’s Vision for WQX An integration of water monitoring data to An integration of water monitoring data to
improve national decisionsimprove national decisions Water quality data management and Water quality data management and
maintenance at the state level, data sharing maintenance at the state level, data sharing and synthesis at the national level and synthesis at the national level
A standard data sharing template (schema) A standard data sharing template (schema) that multiple data partners can publish to that multiple data partners can publish to (States, Tribes, USGS, others)(States, Tribes, USGS, others)
WQX StatusWQX Status
WQX went on-line on February 15th, WQX went on-line on February 15th, 2007, and is ready to receive data2007, and is ready to receive data
WI and Yurok Tribe have successfully WI and Yurok Tribe have successfully submitted data to WQXsubmitted data to WQX
A number of states and tribes participated A number of states and tribes participated in the testing and are close to submittal: in the testing and are close to submittal: NH, MI,TX, MA, OR, Saint Regis Mohawk NH, MI,TX, MA, OR, Saint Regis Mohawk
Tribe, Wind River Consortium of TribesTribe, Wind River Consortium of Tribes
WQX ScheduleWQX Schedule WQX Version 1.0 data flow in production (Feb 07)WQX Version 1.0 data flow in production (Feb 07)
Physical, chemical, microbiological, and fish tissue data onlyPhysical, chemical, microbiological, and fish tissue data only
Add Biological/Habitat data to schemaAdd Biological/Habitat data to schema
Begin Bio/Habitat WQX pilot (Early 07)Begin Bio/Habitat WQX pilot (Early 07)
Finalize WQX Bio/Habitat Schema (Jan 08)Finalize WQX Bio/Habitat Schema (Jan 08)
Bio/Habitat WQX in production (May 08)Bio/Habitat WQX in production (May 08)
Develop Web tool for XML GenerationDevelop Web tool for XML Generation
Tool available for Phys/Chem data (Feb 08)Tool available for Phys/Chem data (Feb 08)
Final tool, including Bio/Habitat (Jul 08)Final tool, including Bio/Habitat (Jul 08)
Biological and Habitat DataBiological and Habitat Data
Currently determining data elements for Currently determining data elements for exchange of Biological and Habitat dataexchange of Biological and Habitat data
Using core elements from STORET and Using core elements from STORET and EDAS (Ecological Data Application EDAS (Ecological Data Application Systems) to model tracking of Biological Systems) to model tracking of Biological and Habitat conditionand Habitat condition
Will be involving EPA Regions and States Will be involving EPA Regions and States this year in determining the final schemathis year in determining the final schema
Core Biological ComponentsCore Biological Components
Organization
Project
SamplingDesignTypeCode
ProjectMonitoringLocationWeighting
LocationStratumName
LocationWeightingFactorMeasure -MeasureValue -MeasureUnitCode
LocationStatusCode
ReferenceLocationIndicator
CommentText
ProjectIdentifier
MonitoringLocationIdentifier
LocationCategoryCode
•Support Probabilistic Designs
•Station Weights
•Stratum
•Identify Reference Sites
Core Biological Components Core Biological Components (cont.)(cont.)
Organization
ActivityDescription
ActivityIntentText
BiologicalActivityDescription
AssemblageSampledName
SampleDescription
TotalSampleWeightMeasure -MeasureValue -MeasureUnitCode
SubjectTaxonomicName
UnidentifiedSpeciesIdentifer
Result
NetTowInformation
ElectrofishingInformation
TotalEnergizedTimeMeasure -MeasureValue -MeasureUnitCode
PassCount
ReachWidthMeasure -MeasureValue -MeasureUnitCode
ReachLengthMeasure -MeasureValue -MeasureUnitCode
BoatSpeedMeasure -MeasureValue -MeasureUnitCode
FishedDistanceMeasure -MeasureValue -MeasureUnitCode
Activity
•Support multiple varieties of Biological Data
•Population Census
•Frequency Distributions
•Group Summary
•Etc.
Core Biological Components Core Biological Components (cont.)(cont.)
ResultResultDescription
BiologicalIndividualIdentifier
CharacteristicNameContext
UnidentifiedSpeciesIdentifer
SubjectTaxonomicName
FrequencyClassInformation
FrequencyClassDescriptorCode
FrequencyClassDescriptorUnitCode
LowerClassBoundNumeric
UpperClassBoundNumeric
UserDefinedCharacteristicInformation
CharacteristicResultScaleText
CharacteristicDescriptionText
Activity
ActivityMetric
MetricNameContext
MetricName
MetricValueNumeric
MetricScoreNumeric
FormulaDescriptionText
MetricScaleText
Core Biological Components Core Biological Components (cont.)(cont.)
•Support Biological Metrics
•Store multiple indicies and the metrics define them for a given site
•Capture the Index and Metric ‘Scale’
ActivityIndex
IndexNameContext
IndexName
IndexScoreNumeric
IndexScaleText
Schedule for Distributed STORET Schedule for Distributed STORET
SIM 2.0.2 Release (May 2006)SIM 2.0.2 Release (May 2006)
Transition from STORET distributed Transition from STORET distributed database system to new WQX submission database system to new WQX submission system (2007-2008)system (2007-2008)
No longer accept STORET data exports No longer accept STORET data exports (Sept 2009)(Sept 2009)
STORET Warehouse UpdatesSTORET Warehouse Updates
The National STORET Data Warehouse The National STORET Data Warehouse enhancements for improved data enhancements for improved data accessibilityaccessibility New Watershed Summary – Available NowNew Watershed Summary – Available Now New Web Services – Available Summer 2007New Web Services – Available Summer 2007
Please visit the STORET website for more Please visit the STORET website for more information : www.epa.gov/storetinformation : www.epa.gov/storet
Question/CommentsQuestion/Comments
Contact:Contact: The STORET Team: The STORET Team: [email protected]@epa.gov 1-800-424-9067 1-800-424-9067
Or Visit: Or Visit: www.epa.gov/storetwww.epa.gov/storet www.epa.gov/storet/wqx.htmlwww.epa.gov/storet/wqx.html http://www.exchangenetwork.nethttp://www.exchangenetwork.net