Managing Water Quality Data

1
Managing Water Quality Data

• A GIS Project for CE394K
• by
• Dharhas Pothina

2
Outline

• Issues in Data Management
• Time Series Schema
• Building a GeoDatabase
• Conclusions
• Future Work

3
Managing Locations Projects

• Ability to manage active sites and plan for new
  deployments
• Store data in a common georeferenced format

4
Variety of Data Formatsand types of Observations
5
CUAHSI Database Schema
6
Requirements

• CUAHSI
• Flexible format
• Multiple Types of Observations / Units
• Data from multiple sources
• Georeferencing needed for analysis

• TWDB
• Limited set of observation types
• Only data collected in TWDB projects
• Georeferencing needed for analysis management
• Ease of use

7
Ways to Store Time Series Data
Multicolumn

• Multicolumn
• Matches equipment data formats
• Easier to implement

• Atomic
• Very flexible
• Easily expandable for new data sources
• More complicated

• Atomic

8
Conclusions

• CUAHSI Schema is well suited for storing data
  from differing sources.
• Needs some tweaks to store data useful for
  management of field equipment.
• Complicated to implement without support from
  database programmers

9
Building the GeoDatabase

• Decide locations for monitoring sites
• Manage equipment
• Plan field visits
• Easy import of field notes/data

10
Kieth Lake Salt Bayou
11
Process
12
Not very useful
GeoDB Size 350MB
13
(No Transcript)
14
Import GPS data
15
After much gnashing of teeth
16
(No Transcript)
17
(No Transcript)
18
Future Work

• Finish report on suitability of schema for TWDB
• Implement modified schema as a TWDB network
  database.
• Develop software to load/extract data from
  database
• Upload archived TWDB data into database
• Develop scripts to use data within ArcGIS for
  management
• Work out how to avoid duplicates when using merge
  in model builder

Acknowledgements Jeff Horsburgh David Tarboton
David Maidment
19
Questions?