Introduction

1. Introduction • Implementing TimeSeries Applications in ArcGIS using the ArcGIS Hydro Data Model Michael J. Blongewicz GIS Analyst Water Resource Software Department DHI Water & Environment Hørsholm, Denmark mjb@dhi.dk

2. Outline • Implementing TimeSeries Applications in ArcGIS using the ArcGIS Hydro Data Model • ArcGIS Development at DHI • DHI Water Resource Data Model • Using TimeSeries in Water Resources • The Connection to TimeSeries • Difficulties Dealing with TimeSeries • DHI TimeSeries Package • TimeSeries in a GeoDatabase • Mean Area Rainfall application • Demonstration

3. ArcGIS Development at DHI • ArcGIS Development is focused in three areas • GIS and Model Integration through a common data structure • Extending the GeoDataModel with Class Behaviors • Developing MIKE INFO Components software independent

4. ArcGIS Development at DHI • GIS and Model Integration DHI Numeric Models DHI GIS Software PFS data files Textfile Shapefile Shapefile DFS data files Import / Export

5. ArcGIS Development at DHI • A Common Data Structure DHI Numeric Models DHI GIS Software Shapefile PFS data files DHI Data Model DFS data files

6. Water Resources Data Model ArcGIS Hydro Data Model ArcGIS GeoDatabase ArcGIS Development at DHI • Extend the ArcGIS Hydro Data Model

7. Water Resources Data Model ArcGIS Development at DHI • GIS and Model Integration at the data level DHI GIS Software DHI Numeric Models PFS data files DFS data files

8. Water Resources Data Model Urban Marine ArcGIS Development at DHI • A Common Data Structure throughout DHI DHI GIS Software DHI Numeric Models

9. Water Resources Urban Marine DHI Data Model ArcGIS Development at DHI • A DHI Data Model DHI GIS Software DHI Numeric Models

10. Catchment Analysis Data Load Network Editor CrossSection Editor TimeSeries Tools Surface Interpolation Scenario Manager Model Setups Calculators ArcGIS Development at DHI • MIKE INFO Components MIKE 11 GIS MIKE Basin Flood Watch DHI Water Resource Data Model MIKE INFO Class Behaviors MIKE SHE GeoEditor MIKE 11

11. DHI Water Resource Data Model • Extending the ArcGIS Hydro Data Model

12. DHI Water Resource Data Model • The COM-ification of MIKE

13. TimeSeries FeatureID TSTypeID TSDateTime TSValue TSDesc DHI Water Resource Data Model • Support for Model SetUps

14. DHIMonitoringPoint DHIBranchFeatures DHICatchments DHINodes MIKE11Model ModelSetUpID Sim11FileLocation FForecastFileLocation BNDFileLocation HDFileLocation RRFileLocation WQFileLocation ADFileLocation DHIModel SetUp FloodWatchModel DHIModelTypeID DHIModelType Name WarmUpPeriod ForecastPeriod TimeOfForecastOffset DHI Water Resource Data Model • Support for Model SetUps * * * * 1 * * * * *

15. Using TimeSeries in Water Resource • TimeSeries is everything • Or Everything could be a TimeSeries • Databases can store either a constant or a TimeSeries • Standard Applications • Statistics - accumulative • Double Mass Curves - comparing two TimeSeries • Rating Curves - correlation between discharge and water level • Duration Curves - what % of time in TimeSeries is over a given value • Strength of GIS is to map the results across a area • Combining different parameters Rainfall of an area over a long period of time Average Actual Evaporation The Runoff of the area Equals Minus

16. FeatureID TSTypeID TSDateTime TSValue 12 1 24 05 99 12 00 00 2.13 12 1 24 05 99 12 30 00 0.13 12 1 24 05 99 13 00 00 0.00 12 1 24 05 99 13 30 00 0.54 12 1 24 05 99 14 00 00 1.17 10 1 24 05 99 12 00 00 1.98 10 1 24 05 99 12 30 00 0.11 10 1 24 05 99 13 00 00 0.00 10 1 24 05 99 13 30 00 1.01 10 1 24 05 99 14 00 00 2.01 Storing TimeSeries in a GDB • Rows and Columns

17. FeatureID TSType TSFile 12 1 12 1 12 1 12 1 12 1 10 1 10 1 10 1 10 1 10 1 Storing TimeSeries in a GDB • BLOBs 99Rainfall.dfs0

18. Storing TimeSeries in a GDB • by Reference FeatureID TSType TSFile C:\DHI\MIKEBASIN_2001\Sampledata\TSData\e.dfs0 12 1 C:\DHI\MIKEBASIN_2001\Sampledata\TSData\r.dfs0 12 1 C:\DHI\MIKEBASIN_2001\Sampledata\TSData\q.dfs0 12 1 C:\DHI\MIKEBASIN_2001\Sampledata\TSData\s.dfs0 12 1 C:\DHI\MIKEBASIN_2001\Sampledata\TSData\a.dfs0 12 1 C:\DHI\MIKEBASIN_2001\Sampledata\TSData\j.dfs0 10 1 C:\DHI\MIKEBASIN_2001\Sampledata\TSData\k.dfs0 10 1 C:\DHI\MIKEBASIN_2001\Sampledata\TSData\p.dfs0 10 1 C:\DHI\MIKEBASIN_2001\Sampledata\TSData\x.dfs0 10 1 C:\DHI\MIKEBASIN_2001\Sampledata\TSData\z.dfs0 10 1

19. Difficulties dealing with TimeSeries • Inconsistencies and Irregularities • TimeSeries Analysis is easy if all parts are equal • Same Time Step • Same Start and End Dates • Same representation of values (instantaneous vs. accumulative) • No gaps in the data • Problems in performing analysis • Double Mass Curves - comparing of 2 time series • Consequently we require additional tools • Synchronization • Gap filling • Missing values

20. DHI TimeSeries Package • TimeSeries Package Architecture

21. DHI TimeSeries Package • TimeSeries Package Diagram

22. DHI TimeSeries Package • TimeSeries Package Functionality • Time Type • Undefined • Equidistant Time • Equidistant Calendar • Non Equidistant Time • Non Equidistant Calendar

23. Average TimeSeries are calculated for each point for the given period of time Apply the weights for a weighted TimeSeries for each catchment Calculate mean annual rainfall for all stations in the catchment Thiessen Polygons determine the weights of each station Mean Area Rainfall Application • Introduction

24. Mean Area Rainfall Applicaiton • Demonstration