Designing a Query Tool for Time Series Data in ArcGIS Hydro Data Model

1
Designing a Query Tool for Time Series Data in
ArcGIS Hydro Data Model

• By
• Reem Jihan Zoun

2
Outline

• Time Series in ArcHydro
• Populating Time Series Table
• Scope for a Load Data Tool
• Query Data Tool Purpose and Design
• Conclusion and Future Work

3
What is Time Series Data?

• Data values that have time component to it or
  are continuous in time are Time Series Data.
• Example of Time Series Data important in
  hydrology
• Years rainfall
• Stream flow
• Evaporation
• Water level in a stream

4
Time Series in ArcGIS Hydro Data Model

• Time Series Component in ArcGIS Hydro Data model
  (ArcHydro) was intended to allow for the storage,
  access, display and analysis of Time Series data.
  
• It consists of two object classes and one
  relationship. 
• They are stored in the Time Series and 
  TSTypeInfo geodatabase table.
• The relationship exists between the TimeSeries
  and TSTypeInfo object classes.

5
Populating TimeSeries Table

• In order to populate the TimeSeries Table for
  the purpose of this exercise, time series data
  were loaded manually  which comprised the
  following three step process
• Get Data from USGS website
• Formatting the Dataset in MicroSoft Excel
• Import of Data to  Time Series table in MsAccess

6
Step 1 Get Data from USGS website
7
Real Time Data for Victoria Gaging Station (USGS
table format)
8
Step 2 Formatting the Dataset in Excel

• HydroID for Victoria station is 500001 which is
  assigned in the FeatureID field.
• Values for both Gage Height and Stream flow data
  types go to TSValue field.
• TSTypeID value of 101 was assigned to Gage Height
  and 102 was assigned to Stream Flow.

9
Step 3 Copy Data to  Time Series table in
MsAccess

• The TimeSeries table was opened in MS Access to
  copy data from the formatted Excel spreadsheet.
• The tables looked like this after loading data

10
Scope for a Load Data Tool

• The manual process of loading limited amount of
  data to the TimeSeries table is quite tedious.
• As the size of the dataset will increase, it
  would be virtually impossible to retrieve these
  data manually. 
• Creation of a tool for loading data to the
  TimeSeries table will  make the process
  substantially easier.
• There is an existing tool to retrieve stream flow
  data from USGS website named NWIS.
• The NWIS tool specifies the station number and
  then submits request for data set on the USGS
  website. All this happens in the background and
  we dont even have to open the website.

11
Purpose of the Query Tool

• All the time series data is stored in one large
  file regardless of feature type and the type of
  data stored in it
• Three variables Feature Classes, Data Types
  Time Period

The objective of the query tool is to display
any particular subset of the database for Feature
Class, Data Type and Time Period defined by the
user.
12
Relationship Used for Design of Query Tool
13
Design of Query Data Tool
14
User Interface for Query Data Tool
15
Conclusion and Future Work

• Query Data tool will have a very important role
  in fulfilling the purpose of Time Series
  Component specially in terms of access, display
  and analysis.
• At present the Query Data tool has user
  interfaces created with ArcMap and Visual Basic
  but it doesnt have any functionality.
• Important future work is to write code for the
  Query Data Tool.

16
Acknowledgement

• Dr. Maidment for getting me in to the exciting
  world of Tools and Visual Basic.
• Tim Whiteaker
• Venkatesh Merwade
• The CRWR crew, its always fun to work there!!

17
Questions?