Distributing Iowa - PowerPoint PPT Presentation

1 / 33
About This Presentation
Title:

Distributing Iowa

Description:

Distributing Iowa s Water Quality Data Using STORET and ArcIMS Joost Korpel Iowa Department of Natural Resources Iowa Water Monitoring Program: wqm.igsb.uiowa.edu ... – PowerPoint PPT presentation

Number of Views:89
Avg rating:3.0/5.0
Slides: 34
Provided by: JoostK
Learn more at: https://www.epa.gov
Category:

less

Transcript and Presenter's Notes

Title: 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
Write a Comment
User Comments (0)
About PowerShow.com