wqx biological and habitat data effort
DESCRIPTION
WQX Biological and Habitat Data Effort. STORET/WQX Users Conference Austin, TX November 28, 2007. WQX Biological and Habitat Data. WQX Version 1.0 data flow in production (Feb 07) Physical, chemical, microbiological, and fish tissue data only Add Biological/Habitat data to schema - PowerPoint PPT PresentationTRANSCRIPT
WQX Biological and Habitat Data Effort
STORET/WQX Users Conference
Austin, TX
November 28, 2007
WQX Biological and Habitat Data
• WQX Version 1.0 data flow in production (Feb 07)
– Physical, chemical, microbiological, and fish tissue data only
• Add Biological/Habitat data to schema
– Begin Bio/Habitat WQX pilot (Early 07)
– Finalize WQX Bio/Habitat Schema (Jan 08)
– Bio/Habitat WQX in production (May 08)
Determining Bio and Habitat Elements
• As a starting point, used core elements from STORET and EDAS (Ecological Data Application Systems) to put together data elements
• No ESAR data standard for biological or habitat monitoring exists– Toxicity/Population/Community Water Quality
Data Elements not fully adopted as standard– Work moving forward on Habitat data
standard
Bio/Habitat Issues
• Introduced the starting data elements to a pilot group
• Pilot group involved states, tribes, academics, and other groups such as USGS
• Pilot group discussed and addressed a list of issues around the starting data elements– Examples:
• How to best model Index and Metric information • Adding in context/citation information
Draft WQX v2.0 Schema
BiologicalResultDescription
FrequencyClassInformation
TaxonomicDetails
Organization
Project
MonitoringLocation
Activity
ActivityGroup
ActivityDescription
ActivityLocation
SampleDescription
AttachedBinaryObject
Result
BiologicalActivityDescription
NetInformation
ElectrofishingInformation
ResultDescription
Attached Binary Object
ResultAnalyticalMethod
Result Lab Info
ProjectMonitoringLocationWeighting
ActivityMetric
BiologicalHabitatIndex
WellInformation
Station WeightsProject
SamplingDesignTypeCode
ProjectMonitoringLocationWeighting
LocationStratumName
LocationWeightingFactorMeasure -MeasureValue -MeasureUnitCode
LocationStatusName
ReferenceLocationTypeCode
ReferenceLocationStartDate
MonitoringLocationIdentifier
LocationCategoryName
ReferenceLocationEndDate
ReferenceLocationCitation **
CommentText
•Support Probabilistic Designs
•Station Weights
•Stratum
•Identify Reference Sites
Organization
Wells
MonitoringLocation
HorizontalAccuracyMeasure -MeasureValue -MeasureUnitCode
WellInformation
FormationTypeText
AquiferName
WellTypeText
WellHoleDepthMeasure -MeasureValue -MeasureUnitCode
Organization
Support Well Information •Well data associated with monitoring location
Biological Sampling Activities
BiologicalActivityDescription
AssemblageSampledName
ToxicityTestType
NetInformation
NetSurfaceAreaMeasure -MeasureValue -MeasureUnitCode
NetMeshSizeMeasure -MeasureValue -MeasureUnitCode
NetTypeName
BoatSpeedMeasure -MeasureValue -MeasureUnitCode
CurrentSpeedMeasure -MeasureValue -MeasureUnitCode
FishedDistanceMeasure -MeasureValue -MeasureUnitCode
PassCount
ElectrofishingInformation
TotalEnergizedTimeMeasure -MeasureValue -MeasureUnitCode
PassCount
ReachWidthMeasure -MeasureValue -MeasureUnitCode
ReachLengthMeasure -MeasureValue -MeasureUnitCode
Activity
Organization
Biological Activity Information•Net capture type activities•Electro fishing activities•Toxicity testing activities
Index and Metric
Activity
Organization
Biological Descriptions
Result
Next Steps
• Looking for additional feedback this week
• Plan to solicit final feedback from pilot group and others
• Will be finalizing schema by January 2008
• Will be rolling into the production version of WQX v2.0 by May 2008
More information
• www.epa.gov/storet/wqx_bio_pilot.html
• Contact Information:– Kristen Gunthardt, [email protected]– The STORET Team, [email protected]