CRWR

Arc Hydro Online Support System

Center for Research in Water Resources

University of Texas at Austin

ESRI
Arc Hydro Implementation
8) Applying The Database Schema

As already mentioned, there are two Arc Hydro database designs that you can apply to your project. The simplified version (a.k.a. Framework) and the Full version. The application of one or the other pretty much depends on the amount of information that your have gathered for your project. Thus, if you only have available the basic digital maps for your project the Framework is a good preliminary choice that you may upgrade later on. But if you have an abundant number of layer available that comply with the Arc Hydro data model design you might be in good shape to apply the full version of the model. The simplified structure of the model is shown below for quick reference. Refer to the Arc Hydro book for details on both versions of the model. Arc Hydro GIS for Water Resources, David R. Maidment, Editor, ESRI Press, 2002

Simplified Data Model: (FrameworkWithTimeSeriesSchema)

If it is decided to apply the simplified data model then use one of the Frameworks (with or without time series), otherwise apply the full model. The current names for each of these database schemas are:

  • ArcHydroFrameworkSchema, Simplified data model version without time series

  • FrameworkWithTimeSeriesSchema,  Simplified data model version with time series

  • ArcHydroSchema, Full version of the data model

From ArcCatalog apply the selected SCHEMA to your geodatabase to create all the necessary ArcHydro standard fields.

In ArcMap open the attribute table of the HydroEdge feature class and assign a value of 1 or 2 to the EdgeType field based on the following criteria:

If Edge is a Flowline Assign EdgeType = 1

If Edge is a Shoreline Assign EdgeType = 2 (you may not have shorelines at all in your project)

Add the TSType table  created by the Schema to ArcMap and open it. Start the edit session to populate the TSType table with the following fields according with the properties of your data. In order to populate the TSType table your geodatabase should already be formatted with the Arc Hydro Data Model (using the database schema) to get the proper domains for each field inside the TSType table.

  • ObjectID = 1

  • >TSTypeID = 3 (For radar precipitation, same as defined in TimeSeries table)

  • Variable = NEXRAD Rainfall (A general description of your time series data)

  • Units = Inches (The units of your time series variable)

  • IsRegular = True (For regular time steps)

  • TSInterval = 15Minute (The time step)

  • DataType = Average (The type of measurement)

  • Origin = Recorded (The form in which the variable was obtained)

Below there is an example TSType table.

 

Go onto next phase


©2003 Center for Research in Water Resources