Distributing Iowa

1
Distributing Iowas Water Quality Data Using
STORET and ArcIMS
Joost KorpelIowa Department of Natural Resources
2

• Iowa Water Monitoring Program
• wqm.igsb.uiowa.edu
• Iowa STORET Data
• wqm.igsb.uiowa.edu/iastoret
• Iowa Water Monitoring Atlas
• igsims.igsb.uiowa.edu/website/water_monitoring

3
Goals for Iowa STORET

• One-stop shopping location for all the states
  water monitoring data.
• Simplified Web Retrieval
• Customized for Iowas users
• Basic online analytic capability.
• Query by analyte and value range
• Basic online graphing
• Basic GIS spatial analysis
• Export results for use with industry standard
  software
• Pipe Delimeted
• Xml
• Must be compatible with National STORET

4
Data Warehousing with MS SQL

• Why Warehouse with MS SQL?
• Warehouse for faster retrieval
• Existing SQL server in DMZ
• Leverage MS expertise of in-house staff
• Allow a variety of applications to access data
  directly without compromising data integrity
  (authorized staff only)
• IIS Web Retrieval
• ArcIMS
• ArcView
• Access
• Excel
• Restrict Oracle server access to data owners and
  approved applications.
• STORET Application
• SIM2

5
Migrating STORET Tables to MS SQL
6
(No Transcript)
7
(No Transcript)
8

9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23

• Iowa Water Monitoring Program
• wqm.igsb.uiowa.edu
• Iowa STORET Data
• wqm.igsb.uiowa.edu/iastoret
• Iowa Water Monitoring Atlas
• igsims.igsb.uiowa.edu/website/water_monitoring

24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
(No Transcript)
32
(No Transcript)
33
Questions?Joost KorpelIowa Deparment of
Natural ResourcesIowa Geological SurveyPhone
319-335-4019Email Jkorpel_at_igsb.uiowa.edu