1 / 20

Nov 8, 2001

STORET For Managers. Nov 8, 2001. STORET. Ambient Water Quality and Biological Data. Clients. Citizen Volunteers Watershed Managers State Environmental & Health Organizations Other Federal Agencies, USGS etc. STORET. Who Organization What Characteristic (Chemical, Taxa, Physical)

camelia
Download Presentation

Nov 8, 2001

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. STORET For Managers Nov 8, 2001

  2. STORET Ambient Water Quality and Biological Data

  3. Clients • Citizen Volunteers • Watershed Managers • State Environmental & Health Organizations • Other Federal Agencies, USGS etc.

  4. STORET • Who Organization • What Characteristic (Chemical, Taxa, Physical) • Where Station • When Date • Why Project Description • How Collection Procedure, Collection Equipment Specs., Container/Preservation, Sample Preparation, Analytical Procedure.

  5. STORETMirrors the Business of Monitoring Organization Sampling Stations Projects Trips Data Loggers Operating Periods Station Visits Monitoring Activities Results 5

  6. Stations STORET Organization • Organization Information • Cooperating Organizations • Preferences and Defaults • Addresses, Physical & Electronic • Operating Programs • Active People/Roles Sampling Trips Projects • Basic Trip/Cruise Info • Projects Supported • Sampling Stations Visited • QC Samples Used • Trip Sampling Activity Summary • Monitoring Activity to Project Assignments • Project Description • Sampling Stations Used • People involved • Programs Supported • Cooperation Orgs involved Monitoring Activities & Results • Basic Station Info • Lat/Long • State County • RF1/ RF3 • HUC, NRSC • Indian Land Interest • Permanent Grid/ Transect Info • Special Station Info, Well, Facility, Spring, Great Lakes, Ocean, Estuary • Basic Activity Information • Collection Procedure & Equipment • Container & Preservation Used • Actual Location & Activity Depth • Person Responsible • Characteristics & Results

  7. STORET v1.2 • Features • Data of Documented Quality • Graphical User Interface • Data Standards for Data Sharing • Implementation • Scaleable - Watershed to National • Locally Owned and Operated • EPA Maintained • Public Read-Only EPA Data Warehouse

  8. Standards • Methyl tertiary butyl ether • 2-Methoxy-2-methylpropane • Methyl-t-butyl ether • MTBE Are these the same?

  9. Monitoring Activities • Field Measurement/Observations • Replicate Measurement • Habitat Evaluation • Observation • Measurement Samples • Routine • Field Replicate • Depletion Replicate • Created from Sample • Composite- with Parents • Sample from Sample • Composite- W/O Parents • Integrated Time Series • Integrated Flow Proportioned • Integrated Horizontal Profile • Integrated Vertical Profile

  10. Sampling Profiles • Sample Medium • Air • Bottom Sediment • Soil • Water • Biological • Individual • Subject Taxa • Tissue • Subject Taxa • Bio- Part • Species Abundance • Aquatic Vegetation • Terrestrial Plants • Benthic Macroinverts • Birds • Reptiles • Amphibians • Bacteria/Viral • Phytoplankton/Zooplankton • Fish/Nekton Medium Intent Community

  11. National Architecture Client A

  12. National Architecture Client B Client A

  13. National Architecture Client B Client A Client C

  14. EPA Data Warehouse National Architecture Client B Client A Client C Public

  15. ORACLE/STORET Environment ORACLE Instance STORET v1.2 GUI Application STORET Schema STORET 1 Schema STORET v1.2 Reports 23 STORET Reference Tables 3 Shared & 90 Data Tables

  16. STORETPreparation the A, B, C’s • Fill out “Preferences and Defaults” for your Organization. • Enter “Station” descriptions and locations. • Enter “Project” descriptions for your Organization. • Assign Stations to appropriate Projects. • Create “Trips” (depending on your Organization’s QC sample strategy) to organize your data, and assign Projects and their Stations to the appropriate Trips. • Create Station Visits and enter monitoring data.

  17. Security Oracle • Schema Level • Table Level STORET Application • Organization Level • Read, Read/Write • Result Level • Preliminary/Final

  18. Data Base Integrity Data base integrity is enforced by the STORET GUI Application!

  19. STORET v1.2Package STORET v1.2 CD-ROM • Installation for complete Stand-alone • Installation for Client • Installation for Server • Installation for Reports Activation Disk • Installation of your unique Organization codes into the data base.

  20. STORET Data Migration Old STORET STORET Legacy Data Center New STORET

More Related