December 13, 2000

1
December 13, 2000
2
STORETwww.epa.gov/storet
Ambient Water Quality and Biological Data
3
STORET

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

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

• Features
• Data of Documented Quality
• Graphical User Interface
• Data Standards
• Implementation
• Scaleable
• Locally Owned EPA Maintained
• Public Read-Only Warehouse

6
Monitoring Activities

• Samples
• Routine
• Field Replicate
• Depletion Replicate
• Created from Sample
• Integrated Time Series
• Integrated Flow Proportioned
• Integrated Horizontal Profile
• Integrated Vertical Profile

7
Monitoring Activities

• Field Measurement/Observations
• Replicate Measurement
• Habitat Evaluation
• Observation
• Measurement

8
ORACLE/STORET Environment
STORET v1.1 GUI Application
ORACLE Instance
STORET Spatial Schema
STORET Schema
STORET 1 Schema
SDE and Oracle Spatial (Warehouse Only)
STORET v1.1 Reports
23 STORET Reference Tables
3 Shared 90 Data Tables
9
STORET Data Flow
FIELD DATA
LOCAL FILES
REFORMAT
BATCH UPDATE
STORET LOCAL COPY
LOCAL REF TABLES
KEYBOARD
STORET CENTRAL WAREHOUSE
Internet Queries
ORACLE EXPORT
MIRROR COPY
10
Relation to NHD

• Spatially enabled warehouse (Legacy and soon to
  be Modernized versions)
• Spatial Data QA checks to be preformed
• Automated reach address creation for all stations
• Addresses to be stored in WATERS/RAD
• QA of station addresses is the responsibility of
  the data owners!

11
STORET WEB www.epa.gov/storet

• Data query and downloads available
• Stations to be added to Enviromapper for display
  and query
• Possibility of WEB-based reach address editing
  for data owners
• Network based navigation and station selection