Water Management Information System for the Rio Grande/Bravo Basin
Updated: August 2005
Table of Contents
3.1. COLLECTION OF THE GEO-SPATIAL DATA FROM ORIGINAL SOURCES
3.2. DEVELOPMENT OF THE GEOSPATIAL DATABASE
3.3. CLIPPING OR MERGING
THE DATA SETS DEPENDING ON THEIR ORIGINAL EXTENT
3.4. CREATING THE FEATURE
DATASETS IN THE GEODATABASE
3.5. OBTAINING TIME SERIES
DATA FOR THE BASIN
3.6. IMPORTING TIME SERIES
INTO THE GEODATABASE
3.7. APPLYING REGIONAL HYDROID’S
3.8. WRAPHYDRO DATA MODEL SCHEMA
3.9. APPLYING THE
WRAPHYDRO TOOLS
3.10. RASTER-NETWORK REGIONALIZATION PROCESS
3.11. Exchange of Temporal Information
3.12. INSTALLING THE DSS HYDRO TOOLBAR DLL
3.13. DSS Hydro Toolbar Description (After you have installed the DLL in
ArcMap)
4. WATER QUALITY DATA MODEL
(WQDM) IN GIS FOR THE RIO GRANDE/BRAVO BASIN
4.2. Developing the schema
of the Water Quality Data Model (WQDM)
4.3. Spatial reference
information
4.4. Entity and attribute
information
4.4.1. Feature Class:
HydroEdge
4.4.2. Feature Class:
Monitoring Point
4.4.3. Feature Class:
Waterbody
4.4.4. Feature Class:
Watershed
4.4.5. Feature Class:
HydroJunction
4.4.10. Agency responsible table
4.4.11. Topology and
relationships among the feature classes
4.5.2. Creating Monitoring
Points
4.5.3. Creating the
SnapControlPoint feature class
4.5.4. Creating
HydroJunctions
4.5.5. Creating a geometric
network
4.5.6. Discrepancy of the
hydrologic data
Because
integrated management of a river basin requires the development of models that
are used for many purposes, e.g., to assess risks and possible mitigation of
droughts and floods, manage water rights, assess water quality, and simply to
understand the hydrology of the basin, the development of a geodatabase from
which models can access the various data needed to describe the systems being modeled
is fundamental. In other words, a
database from which models read input data and to which they write output
data. In order for this concept to be
useful and widely applicable, however, it must have a standard design. The
recently developed ArcHydro data model facilitates the organization of data
according to the “basin” principle and allows access to hydrologic information
by models. The development of a basin-scale relational database using the
ArcHydro schema and implemented in a Geographic Information System (GIS) is one
of the contributions of this research. The Rio Grande/Bravo basin is the case
study area for this research. This geodatabase represents the first major
attempt to establish a more complete understanding of the basin as a whole, including
spatial and temporal information from the
Raster
tools represent a convenient means of analyzing watersheds from Digital
Elevation Models (DEM), as well as calculating mean watershed values based on
raster datasets describing parameter variations in space. These tools are
effective when the number of grid cells in the analysis is not too great (e.g.,
less than 50 million cells). Difficulties in processing raster datasets over
large regions are studied in this research. One of the most important
contributions of this research is the application of a Raster-Network
Regionalization technique, which utilizes raster-based analysis at the
subregional scale in an efficient manner and combines the resulting subregional
vector datasets into a regional database. Also, this methodology verifies the
validity of dividing a basin into subregions for processing without
compromising on the accuracy of the determined parameter values. This technique
could also be applied at a local level when high resolution data, such as LIDAR
data, area available. These data are so dense they typically preclude raster
analysis over a relatively small area.
Another
important contribution of this research is focused on implementing a robust
structure for handling huge temporal data sets related to monitoring points
such as hydrometric and climatic stations, reservoir inlets and outlets, water
rights, etc. For the
Since
ArcHydro was designed to store hydrologic GIS data in a manner conducive to
data export for model use, a toolset is proposed to exchange temporal
information between the Geodatabase and the Hydrologic Engineering Center Data
Storage System (HEC-DSS).
The Rio Grande/Bravo is a transboundary water source
shared by the
In addition, some decisions about water management are
only partially supported, causing alterations in the global ecosystem. For this reason it is necessary to improve
the administration and management of water in this watershed. This will require assessment of water
availability and how to manage it appropriately for agriculture, industry and
other services, also taking into account ecosystem preservation.
Recent drought conditions have increased tensions over
water sharing in this basin. Several
areas of conflict and possible negotiated remedies have been identified, but
there is a lack of data available to use in analysis of alternative solutions
to these problems.
The development of a
watershed-scale database for the Rio Grande/Bravo basin is fundamental. Minute
308 of the International Boundary Waters Commission (IBWC),
In part of this
research project, the Center for Research in Water Resources (CRWR) of the
University of Texas at Austin, the Texas Commission on Environmental Quality
(TCEQ), the Mexican Institute of Water Technology (IMTA), and the National
Water Commission (CNA) of Mexico have cooperated to develop the relational
database containing geographic, hydrologic, hydraulic and related data for the
basin, as shown in figure 1. This geospatial database was created using the
ArcHydro data model schema for the entire Rio Grande/Bravo basin.
Fig. 1 Relational
integration of thematic layers (Maidment, 2002)

The
The
The river collects rain, snowmelt
and spring water from an area about 557,722 square kilometers including closed
basins. The whole basin includes three states on the
Fig. 2 Political
division of the Rio Grande/Bravo basin

The basin is divided in two sub basins, the
A part of the Rio Grande basin lies within North
America’s largest desert, the Chihuahua Desert.
The Rio Grande/Bravo basin is considered an arid to semi-arid
region, dominated by agriculture and with limited supplies of both surface and
groundwater. Average rainfall in the basin ranges from 200 – 900 millimeters
with the highest values in the upper basin of the Rio Conchos (Patino et al,
2004). The Rio Conchos enters to the Rio Grande/Bravo near Presidio,
Fig. 3 The
primary tributaries in the Rio Grande/Bravo basin

Hydrological
information was obtained from Mexican and
Errors were
found in some of the hydrological information such as incorrect positions of
some monitoring and control points, disconnected river reaches, incorrect location
of some water bodies, etc. Part of the original information is shown in Figure 4.
This information had to be edited in order to fix these errors.
The Mexican
agencies usually use the Geographic Coordinate System and Lambert projection to
create their geographic information. The Albers equal area projection was
proposed for this project in order to preserve the areas. The Datum chosen was
the NAD Datum 1983; the Geographic Coordinate System corresponds to the
GCS_North_American_1983, while the
Table 1 Summary of the original data collected for the
Rio Grande/Bravo basin
|
Political
boundaries (States included in the |
Available |
Available |
|
Basin
Delineation. Source: USGS-HUC for the Cuencas and
Sub-Cuencas from IMTA and UACJ for the Mexican side (1:250K) |
Available |
Available |
|
Hydrography (Stream
network). Source: USGS for |
Available |
Available |
|
Water
Bodies and dam locations. Source: USGS- HUC’S for the IMTA, CNA,
INEGI, and UACJ for the Mexican side (1:250K) |
Available |
Available |
|
Monitoring
point’s location. Source: USGS, TCEQ, and IBWC for the |
Available |
Available |
|
Historical
hydrometric information (time series). Sources: National Water Information
System (NWIS) and the IBWC for the |
Available |
Available |
|
Climatologic
information (time series). Sources: USGS and PRISM for the IMTA and CNA
for the Mexican side. This information is included in the ERIC System (230
climatic stations on the Mexican side operating until 2002.) |
Available |
Available |
|
Digital
Elevation Model (DEM). Source (Seamless format): USGS for the |
Available |
Available |
|
Control Points (Include water rights, return
flow points, diversions, etc) This information was obtained from the TCEQ on the |
Available |
Available |
Fig. 4 Cuencas, Sub Cuencas and original
hydrography of the

The development of a watershed-scale database is
fundamental to analyzing water resource management problems in the basin. Even
though separate research efforts have been carried out on each side of the
river, there has not been an integral database that includes data from both
sides of the Rio Grande/Bravo basin. As in many watersheds, knowledge and
information available about the Lower Rio Grande/Bravo basin is fragmented,
disjointed, incomplete, and sometimes inaccurate. Integrated management of a
river basin requires the development of models that are used for many purposes,
e.g., to assess risks and possible mitigation of droughts and floods, manage
water rights, assess water quality, and simply to understand the hydrology of
the basin. For this purpose a database
is needed from which models can access the various data needed to describe the
systems being modeled (figure 5). In
other words, a database from which models read input data and to which they
write output data. In order for this
concept to work, however, it must have a standard design. The recently developed ArcHydro data model
facilitates access to hydrologic information by models (Maidment, 2002).
Fig. 5 Hydrologic
Information System (Maidment, 2002)

Creating the ArcHydro geospatial database for the
entire Rio Grande/Rio Bravo basin represents the first major attempt to
establish a more complete understanding of the basin as a whole, using both
Mexican and
Fig. 6 ArcHydro
data model for water resources
In constructing the geodatabase for the Rio
Grande/Bravo basin, data distributed on a national or state level had to be
clipped; while data distributed at a county or Hydrologic Cataloging Unit
level, had to be merged into a single and larger data set. Because the original
DEM for
Fig. 7 Clipped DEMs for the basin including a 10 Km
buffer

This step included the processing the available
information into the ArcHydro Rio Grande/Bravo geodatabase. Several feature
datasets were created that include feature classes related to each type of
information. When working with huge basins like the Rio Grande/Bravo basin, the
computer processor is not be able to handle the large raster datasets. This is handled
by dividing the basin into sub-regions and processing the rasters individually
for each region. The values obtained for each sub basin can be cascaded
downstream to get the final parameters for control points for the entire
basin. For this reason, the whole basin
was divided into 9 hydrological subregions on the
Fig. 8 Hydrological
subregions of the Rio Grande/Bravo basin

Climatic and hydrological time series data were collected
and imported from the BANDAS, ERIC (On the Mexican side), and NWIS (on the
Fig. 9 Control
Points identified in the Rio Grande/Bravo basin

The
ArcGIS format is applied to all the time series data in order to include and
relate them to the monitoring and control points in the geodatabase. The Time
Series standard format of the ArcHydro schema was changed, adding one more
table called TSGroup that contains information related to the agency from which
the data is derived. Two tables describing the agencies and variables included
in the Geodatabase are shown below.
Table 2. Variables
Included in the Geodatabase

Table 3. Agencies Participating to Create the
Geodatabase

Users
can select a specific monitoring point within the geodatabase and several
relationships have been established for it, so they can identify the agencies
from which the temporal data was derived, as well as the type of variable. The
Rio Conchos runoff to the Rio Grande/Bravo is shown in the table 4
Table 4.
Monthly Runoff at the Gage Station


Also, a time series viewer was applied in order to
plot the behavior of the temporal information (figure 10). The information
related to runoff from the Rio Conchos to the Rio Grande/Bravo is shown below;
where you can see the total discharge to the
Fig. 10.
Monthly Runoff Volume from the

A unique ten-digit identification number called the Regional
HydroID was assigned to every feature class according to the following classification:
![]()
The
first digit (from left to right) indicates the hydrological region. Region 13
on the
Table 5 Regional HydroID for the

A particular application of the ArcHydro data schema called
WRAPHydro was applied to each of the Rio Grande/Bravo hydrological subregions
in order to create the necessary fields required by the Water Right Analysis
Package (WRAP) model (Wurbs, 2001). The WRAPHydro data model was derived from
the ArcHydro model and is tailored specifically for the WRAP project developed
jointly with the TCEQ (Gopalan, 2002). It is shown in figure 11. The WRAP is a
hydrological simulation model for evaluating existing water right permits,
permit approvals for new water rights, and overall water management in
Fig. 11. WRAPHydro
Data Model.


All of the fields created by the WRAPHydro schema were
populated using the WRAPHydro tools developed at the CRWR (Whiteaker, 2004). These
tools consist of a set of public domain utilities developed on top of the ArcHydro
data model. The tools are accessed
through the WRAPHydro toolbar, where they are grouped by functions into two
menus and five buttons (Figure 12). The purpose of this toolkit is to process
GIS data in order to calculate parameters used by WRAP and tabulated for each
ControlPoint including: average curve number, average annual precipitation, total
upstream drainage area, and next downstream ControlPoint
Fig. 12. WRAPHydro
Toolbar.

For each hydrological subregion, the HUCs or
SubCuencas that make up the subregion were selected, including a 10 Km buffer
around the HUCs called the BufferWatershed feature class. All the streams that
lie within each subregion plus buffer were selected and exported to create the WRAP-Flowline
feature class. After this step, a digital elevation model (DEM) of the buffered
area was clipped and processed using the ArcHydro Terrain Analysis tool. The catchments
for each stream segment (WRAPCatchments) of the WRAP-Flowline class were created
with the WRAPHydro Delineate Watershed tool. The DrainID of the delineated
catchments was populated by the HydroIDs of the WRAP-Flowline segment draining
to it. In order to create a geometric river network (the HydroNetwork), the
hydrography information had to be checked. Every stream must be connected and
the flow direction assigned correctly. The HydroNetwork is an essential part of
this data model, created from edges (WRAPFlowlines) and the control points. The
topological connections of the edges and control points in a geometric network
enables tracing of water movement upstream and downstream through streams,
rivers, and water bodies. Relationships built from the control points connect
drainage areas and point features such as diversion points to the HydroNetwork.
This HydroNetwork allows calculation of the distance between any two points on
a flow path. A new feature class called WRAPEdge was created using the HydroNetwork
selecting all streams lying in the hydrological subregion. In order to find the
total drainage area for each control point, it is necessary to determine the
incremental watersheds that contribute to each junction, then their value is
accumulated moving downstream. Watershed drainage area, average curve number
and average precipitation were calculated for each delineated watershed using
the WRAPHydro tools. The Once the incremental values for the drainage area,
curve number and precipitation were determined for each watershed, these values
were consolidated to add in the effects of all the area contributing to each
junction.
Figure 13 shows the result of comparing the SubCuencas
of the Rio Conchos basin defined by the Instituto Nacional de Estadistica,
Geografia e Informatica of Mexico (INEGI)--represented by a continuous line--and
the watershed defined by the WRAPHydro Tools--represented by polygons.The
connectivity among control points is shown in figure 14. The SubCuencas were
defined using a 1:250K scale topographic map, while the watersheds were
calculated from a 1:100K scale WRAPEdge (from a digitized map) and a DEM grid
size of 30 m. The points represent the related water rights, gage stations, and
return flow control points.
Fig. 13.

The research presented in this project introduces a
Raster-Network Regionalization Technique, which allows a large region to be
divided into hydrological distinct subregions where raster analyses may be
performed in a feasible manner. A summation of raster values over watersheds
can be easily determined using the watersheds as distinct zones which define
the area of analysis for the zonal statistics tool in ArcGIS. This tool
calculates statistics such as mean, sum, max, and min for each zone by reading
the values of cells within each zone and performing the necessary statistical
operations. Thus, with this approach, accumulated grids whose cell values are
influenced by all upstream cells are no longer needed. The only cells of a
watershed that an analyst is interested in are the cells that lie directly over
that watershed (Whiteaker, 2004).
Once attribute values have been determined for
watersheds, these values can be transferred to outlet junctions, and then
consolidated throughout the stream network in the vector domain. The watersheds
become the basic processing unit with basin-wide coverage, while the raster
coverage can be reduced to each individual watershed’s extent. Thus, watersheds
effectively replace grid cells as the “units” of analysis.
This allows a basin or region to be divided into
hydrologically distinct subregions, in which the necessary raster analyses
takes place. The smaller size of the subregions permits faster raster
processing, while results from raster analysis are stored on vector watersheds
to be accumulated at the basin level. The Consolidation and Accumulation
options from the WRAPHydro tools are then used to accumulate watershed
parameters across the entire basin.
With the Raster-Network Regionalization technique, the
weight of processing is changed from the raster side to the vector side,
resulting in several benefits due to reduced processing time, since much of the
processing occurs in the vector domain rather that in the raster domain. Data
storage requirements are reduced, since accumulation grids no longer need to be
created. Also, the remaining grids can be split into hydrological distinct
regions defined by one or more watersheds. This allows for faster processing on
the raster side, more modular data storage, and less raster reprocessing effort
if data in a given watershed changes. Even the largest basin can now be
processed with high-resolution raster data too.
The technique has been successfully applied to the
binational Rio Grande/Bravo basin, which has a contributing area of over
468,000 square kilometers and is divided in 16 hydrological subregions as it is
shown in figure 1(9 on the U.S. side and 7 on the Mexican side). The results
from the raster analysis of each subregion are merged on the vector side for
determining the total drainage area flowing toward a specific control point, as
well as its corresponding average precipitation, average curve number, and length
downstream parameters.
Figure 15 shows the control points and main rivers in
the portion of the Rio Grande/Bravo basin from El Paso/Cd. Juarez through the
Fig. 15. Control
Points and

Fig. 16. Connectivity in the Rio Grande/Bravo
basin

A
schematic network diagram for the whole basin is shown in figure 17. This
schematic network is a simplification of the HydroNetwork that consists of
separate point and line feature classes called Schematic-Node and Schematic-Link,
respectively. The schematic network is an abstract representation of the
elements to which hydrologic or water management models can be applied, and it
provides a simplified view of the connectivity of the river network and the
control points. This kind of network is useful as a visual check to make sure
that the hydrologic elements needed for a model are correctly linked in the
landscape (Maidment, 2002)
Fig. 17. Schematic Network of the Rio
Grande/Bravo basin

A tool called DSS Hydro tool for
transferring around two million of historical records from an ArcHydro geodatabase
into a HEC-DSS file and back to a geodatabase is being developed in this
research for using with USACE HEC models. This tool consists of a set of public
domain utilities developed in Visual Basic. The DSS Hydro toolbar operates in
the ArcGIS ArcMap environment, and is comprised of four commands to transfer
the temporal information (Figure 18). This tool utilizes an object library and
objects classes within the geodatabase structure called DSS Time Series Catalog
(DSSTSCatalog) that contains all relevant records and descriptors to
automatically transfer the time series (Teasley et al, 2004)

The original ArcHydro Time Series
framework must be modified to create automatically the DSSTSCatalog table
inside the ArcHydro structure when the ArcHydro schema is applied to a
geodatabase. This table contains all necessary fields that are used as the
descriptors to create the HEC-DSS files (figure 19).
Figure 21 Modified ArcHydro Time Series
Framework

The DSSTSCatalog is populated
automatically in a geodatabase using the “Writing DSS Catalog into the
geodatabase” option included in the DSS Hydro toolbar, based on the temporal
information contained in the time series table of the geodatabase. The
DSSTSCatalog is the object class table within the geodatabase that contains the
information related to the DSS data and its pathname, and represents the key
step in transforming a time series from a geodatabase into the HEC-DSS format.
The DSS pathname consists of six parts in the following format:
/A/B/C/D/E/F/
Where
A - Group name for the data such as a
watershed name, study name or any identifier which allows the records to be
recognized as belonging to a group.
B – The location identifier for the
data. The location identifier may be a site name or organization ID such as a
USGS gage ID or the HydroID of the monitoring point.
C - The parameter of the data such as
flow, precipitation, storage, evaporation, etc.
D - the start date of the time
series, and
E - The time interval for regular
data or the block length for irregular interval data.
F - An optional descriptor that can
be used for additional information about the data.
Once the DSSTSCatalog is created, the
time series is transferred from the geodatabase to the HEC-DSS format using the
“Transferring Time Series from GDB to HEC-DSS” option of the DSS Hydro toolbar,
in order to create the HEC-DSS files that will be used for simulation purposes.
After the simulation has been completed in any HEC models, is necessary to
transfer back the time series results from the HEC-DSS files to the
geodatabase. The “Transfer HEC-DSS Time Series to GDB” option of the DSS Hydro
toolbar is used to perform this task. There are two options for exchanging
temporal information; one of them uses a filter for transferring time series
just related to one specific point, whereas another one is used to transfer all
records contained in the HEC-DSS files (Figure 21).
Figure 21 Time series transfer between the
geodatabase and the HEC-DSS

·
Open ArcMap
·
Go to the Customize option in the Toolbars option.

Click the “Add from file” button and select the
“DSSTSBridge_Jan05.DLL” from your folder where you have the dll

Activate the “HEC-DSS TIME SERIES
TOOLBAR” option…..and now you should have the DSS Toolbar in your ArcMap
document


1.
Writing HEC-DSS Catalog
into the geodatabase: This option allows populating automatically the DSSTSType
table, which was created previously by the ArcHydro schema. This function takes
the temporal information from the Time Series and the TSType tables included in
the ArcHydro geodatabase. The TSType table must have the next structure in
order to be able to transfer the temporal information.

2.
Transferring Time
Series from GDB to HEC-DSS: This function transfers all temporal information
contained in the ArcHydro Time Series table into a HEC-DSS file. The DSSTSType
is the key table to make this transferring.

3.
Transfer HEC-DSS Time
Series to the GDB without Filter. This option transfers ALL temporal
information from the HEC-DSS files to the GDB.

4.
Transfer HEC-DSS Time
Series to the GDB WITH filter. This option transfers JUST THE INFO RELATED TO
ONE SPECIFIC POINT from the HEC-DSS files to the GDB.

Choose the HEC-DSS file from where
you want to transfer the information. Select the HydroID of the Monitoring
Point in the “Input B Part (Site ID)” box. This ID must be the same as appears
in the B Part of the HEC-DSS table. Select the number variable appearing in the
A Part of the HEC-DSS file (Number 6 in this example). Select the Variable Type
that should be the same appearing in the C Part of the HEC-DSS file (VOLUME-MONTHLY).
Select the time interval units, and type the HEC-DSS A Part (6 for this
example, and it must be the same value as appears in the A Part of the HEC-DSS
table). Finally select the target geodatabase where you want to store this
temporal information.
Development of a Water Quality Data
Model (WQDM) based on a framework developed in Visio 2000 and exported as a
schema in mdb file. This data model will be implemented following criteria and
parameters from the International Boundary Water Commission (IBWC), Texas
Commission on Environmental Quality (TCEQ), United States Geological Survey
(USGS), Environmental Protection Agency (EPA), Mexican National Water
Commission (CAN), and the Mexican Natural Resources and Environmental Secretary
(SEMARNAT). This georeferenced database will include spatial and temporal
information, and would be implemented in a Geographic Information System
(ArcGIS) following the ArcHydro data model structure developed at the Center
for Research in Water Resources of the
Data regarding to the water quality
control points and its corresponding historical information on the American
side was collected from the International Boundary Water Commission. This info
is classified in two parts; one of them is included in the ‘IBWC Water Bulletins
(http://www.ibwc.state.gov/EMD/Water_Bulletins/Water_Bulletins.htm)” and
the other one is part of the “Texas Clean River Project (http://www.ibwc.state.gov/CRP/monstats.htm)”.
The Clean River Project (CRP) is being achieved among several agencies such as
IBWC and TCEQ. All original data is included in excel spreadsheets and cover
info since 1990 – 2000 in the most cases. The rivers are classified by the TCEQ
with a specific segment ID, which will be preserved in the Water Quality Data
Model (WQDM). These river segments are reported as a shapefile in the TCEQ
website (http://www.tnrcc.state.tx.us/gis/ourmaps.html).
The waterbodies included in the WQDM will be gathered from the TCEQ for the
American side, preserving its classification criteria. The river segments,
water quality control points and waterbodies information on the Mexican side of
the basin will be collected from the CNA or SEMARNAT agencies.
A water quality framework is being
created in Visio 2000 to have the Rio Grande Water Quality UML file. This
framework follows the ArcHydro data Model philosophy, but some changes are
being made to the attribute tables of the feature classes, in order to met
criteria and parameters required by the TCEQ, EPA, USGS, IBWC, CILA, and CNA.


Once the Water Quality Data Model UML has been created, it
must be exported as mdb file to create the schema, which will be applied to a
relational geodatabase in ArcCatalog.

Projected Coordinate System:
NAD_1983_Albers
Projection: Albers
False_Easting:
1000000.00000000
False_Northing:
1000000.00000000
Central_Meridian:
-103.00000000
Standard_Parallel_1:
27.41666667
Standard_Parallel_2:
34.91666667
Latitude_Of_Origin:
31.16666667
Linear Unit: Meter (1.000000)
Geographic Coordinate System:
GCS_North_American_1983
Datum: D_North_American_1983
Prime Meridian: 0
This feature class depicts the official TCEQ Stream
Segments for the State of
a.
Attribute: HydroID. This is the unique 10 digit
identification number assigned by the CRWR. This ID will be used to establish
the topology in the geometric network. The HydroID for this element would be
assigned as described below:
![]()
The first digit indicates
the country where the element is located. It was defined the number 1 for the
segments located on the
b.
Attribute:
HydroCode. This
is the public identification number assigned by the TCEQ, USGS, EPA, IBWC, or
CNA.
c.
Attribute:
ReachCode. This
field is added to store the ReachFile from the EPA
d.
Attribute: Name. The name of the classified or
unclassified segment as it appears in the Texas Surface Water Quality Standards
on the
e.
Attribute: LengthKm.
This field
indicates the river segment length in Km
f.
Attribute: LengthDown. This field indicates the distance of
the river segment to the outlet of the Rio Grande/Bravo basin, usually
calculated in kilometers based on the HydroEdge attribute LengthKm.
g.
Attribute: FlowDir. This field indicates flow direction
of each river segment
h.
Attribute:
Agency_ID. This
is a unique digit identification number as it appears in the TCEQ, EPA, IBWC,
CILA, CNA, SEMARNAT, etc., databases for every river segment. This ID is
usually the same as the HydroCode attribute
i.
Attribute: SegmentClass. Classified: River Segments or water bodies that
are protected by site-specific criteria as outlined in the TCEQ Surface Water
Quality Standards. Unclassified: Smaller water bodies that do not have
site-specific water quality standards assigned to them, but instead are
protected by general standards that apply to all surface water in the state.
j.
Attribute: SegmentType. Freshwater Stream: Inland waters which exhibit no
measurable elevation changes due to normal tides. Tidal Stream:
Descriptive of coastal waters which are subject to the ebb and flow of tides.
For purposes of standards applicability, tidal waters are considered to be
saltwater. Classified tidal waters include all bays and estuaries with a
segment number that begins with 1323xx for the
k.
Attribute: Location.
Verbal
description indicating where the stream segment or water body begins and ends.
l.
Attribute: Basin. This field describes the name of the
basin. Rio Grande/Bravo basin is the official name within the WQDM
m.
Attribute: Region. This field describes the region where
the stream segment is located, according to the TCEQ classification on the
n.
Attribute: Impaired_Status.
Single-character
field indicating whether or not the water body was impaired in the 2000 Surface
Water Quality Standards effective on
o.
Attribute:
AgencImpairCode. A one-digit numeric code from the agency indicating why the water body is
listed as impaired. This attribute will be related with the Impaired_Code_Table
through the CRWR_ImpairedCode attribute.
p.
Attribute:
CRWR_ImpairedCode. A small integer related to the impaired code from the agency. There will
be established a relationship between this attribute and the
Impaired_Code_Table to describe why the river segment or waterbody is
considered as impaired.
A relationship will be established
between a river segment and its corresponding water quality monitoring station
(Identified as a Monitoring Point within the geodatabase). Another relationship
will be established between the river segments (HydroEdge) and the
HydroJunction feature class. The HydroJunction is a virtual point representing
a monitoring point in the geometric network.
This feature class shows all surface
water quality monitoring being conducted by the TCEQ or under TCEQ contract for
Fiscal Year 2005 on the
It indicates a unique
feature identifier in the Water Quality Data Model assigned at the CRWR. This
ID becomes the key to establish many relationships between the monitoring point
and some elements included in the WQDM. The HydroID for this element would be
assigned as described below:
![]()
The first digit indicates the country where the element is
located. It was defined the number 1 for the water quality points located on
the
This feature class will include the
water bodies, impaired or not, located on the Rio Grande/Bravo basin on both
sides of the basin. Waterbodies are all the significant ponds, lakes, and bays
in the water system. The American waterbodies will be gathered from the USGS,
EPA, and TCEQ, while the CAN and SEMARNAT will provide the waterbodies
information on the Mexican side.
This feature class will include
information related to the drainage areas contributing flow from the land
surface to the water system. The watershed information on the Mexican side is
collected from the CNA and SEMARNAT, while this is being collected from EPA and
TCEQ on the American side. The EPA manages water pollution using Total Maximum
Daily Loads (TMDL) defined on watersheds draining to selected river segments or
waterbodies, a different watershed layout than that used by the National
Weather Service on the
This feature class includes a set of
junctions located at the end of the river segments and at other strategic
locations on the flow network. Usually the Monitoring Points, which preserve
their original position, are represented by the HydroJunction on the flow
network. HydroEdges and HydroJunctions are topologically connected in an ArcGIS
geometric network, called the HydroNetwork and included as the backbone of the
WQDM. Since HydroJuctions area topologically linked to the river segments
(HydroEdges) in the geometric network, the combination of this network and the
other relationships means that the classes in the WQDM framework are connected
into an integrated data structure.
The inclusion time series data in the WQDM is not only to create a complete water quality data model for using the GIS environment, but also to build a relational database that would be accessible to many water quality models that operate separately of the GIS. The temporal information is captured and stored in a variety formats by each entity, so it is fundamental to have a standard design to manage large historical data sets. The original ArcHydro time series framework for the surface water is being modified to have a large container in GIS that allows storing many variables related to the water quality data that include millions of records. Under this concept, user may acquire, store, or deliver an entire water quality data set, including time series data files from water quality stations, as well as the geographic element associated to it.
This table describes the entity that
manages and publishes some information. In this table users can identify from
where the information comes, using a unique identifier for each agency. A
relationship is established between the temporal information in the time series
table and the Monitoring Point feature class using the FeatureID as the key.
The TSType table contains an index of
the types of time series data stored in the time series table. A relationship
is established between the TSType table and the Time Series table using the TSTypeID
as the key.
This table is associated with the
HydroEdge and WaterBody feature classes within the WQDM to indicate which river
segments are impaired. The impaired code table contains fields to describe
which pollutants are responsible for the failure of river segments to meet
water quality standards.
This table describes which entity is
in charge of the water quality stations. A relationship is established between
the Agency responsible table and the Monitoring Point feature class using the
AgenResp_Code attribute as the key.
A geometric network called
HydroNetwork is created to establish the topology among the elements within the
WQDM. This HydroNetwork becomes the backbone of the WQDM structure, created
from the river segments (HydroEdges) and the water quality monitoring stations
(HydroJunctions). The topological connection of its HydroEdges and
HydroJunctions in the WQDM enables tracing of water movement upstream and
downstream through streams and waterbodies. Relationships built from the
HydroJunctions connect drainage areas, waterbodies and any point features such
as water quality stations or wastewater treatment plants to the HydroNetwork.
Each relationship has a multiplicity, and all the relationships implemented are
one-to-many. One-to-many multiplicity means that one HydroJunction may be
associated with one or more features in the related class. For example, two
HydroEdges (river segments) may drain into a single HydroJunction on a river
network
The original river segments
(including the waterbodies) on the
Figure 22 Flowline resolution in the Rio Grande/Bravo
basin

Water quality stations, wastewater
treatment plants, and other important control points are being included into
the WQDB as a feature class called Monitoring Points. The water quality
stations on the
Because more than two monitoring
points could be represented for just one HydroJunction in the geometric
network, it is necessary to have one more feature class called
SnapControlPoint. The SnapControlPoint is a point feature class that represents
all monitoring points with all the features snapped to the right location on
the network. The HydroCode is the unique identifier to establish the relationship
between the SnapControlPoint and the Monitoring Point feature class. The main
purpose of this feature class is to exchange information about water quality
parameters between the HydroJunctions participating in the geometric network
and the monitoring points, which maintain their original position.
Since more than one monitoring point
can exist at the same location, it is fundamental to have one point on the
geometric network representing all of them. These points participating directly
in the network are known as HydroJunctions in the ArcHydro jargon. The HydroID
is the key to establish the relationship between the HydroJunctions and the
monitoring points. This unique value will be assigned to the JunctionID value
of the all monitoring points that are representing, so two or more monitoring
points could have the same JunctionID.
A geometric network is crated using
the SnapControlPoint and HydroEdge feature classes. All points in the
SnapControlPoint feature class are snapped 500 m to the HydroEdge element. In
order to avoid dividing the river segments into several parts, this geometric
network is built as a complex edge,
Also, the historical information
related to the monitoring points is included in the time series table within
the WQDM.
Figure 23 Comparison
between RF1 and NHD river network

Figure 24
River network comparisons among NHD, RF1, and DEM versions

·
There are some inconsistencies in the hydrography of the
upper basin. Figure 25 shows the comparison of the river network from RF1 and
the NHD, after the last one was edited.
Figure 25
Comparison between the RF1 and fixed NHD stream network
A binational geodatabase was created
that includes a relational database containing hydrologic, hydraulic and
related data for the Rio Grande/Bravo basin. This geodatabase was development
using the ArcHydro data model framework, and is being made available to Mexican
and
One of the main purposes of this research
is to develop and apply an operational method for the automated
parameterization of large basins. There
are a number of potential advantages to using automated digital terrain
analysis techniques to derive parameters and variables for hydrologic models.
The principle advantage is the speed and reproducibility with which the
parameterization task can be accomplished. The development of a Raster-Network
Regionalization technique for large basins utilizing raster-based analysis at
the subregional scale in an efficient method is one of the most important
contributions of this research. This methodology allows large regions to be
divided into hydrological distinct subregions where raster analyses may be
performed in a feasible manner. The results from each subregion are stored as
attributes on vector data. The vector data are then merged, and appropriate
values accumulated to obtain hydrologic parameter values for points of interest
along the stream network, such as the drainage area, average Curve Number,
average precipitation, and distanced from monitoring points to the basin
outlet. The results from each subregion are stored as attributes on vector
data. This technique uses the vector stream network as the pillar for the
integration of subregions into a single region. The ArcGIS Hydro Data model is
used to provide attributes with which to establish connectivity, as well as
tools to perform the attribute accumulation. Also, this methodology helped to
verify the validity of dividing a basin for processing without compromising on
the accuracy of the parameter values determined. The Raster-Network
Regionalization technique could also be applied at a local level when high
resolution data, such as LIDAR data, area available. These data are so dense
they typically preclude raster analysis over a relatively small area. In
conclusion, this technique takes advantage to using automated digital terrain
analysis technique to parameterize watershed over a range of scales. This can
only be done rapidly and systematically using automated methods.
The Raster-Network Regionalization
technique has been successfully applied for the binational Rio Grande/Bravo
basin, which has a contributing area of over 468,000 km2 using high-resolution
DEM. The drainage area for each control point is determined using the proposed
technique and compared to reported stream gage contributing areas from the U.S.
Geological Survey (USGS) and the National Water Commission (CNA) of
Non-contributing drainage areas such
as depressions where the runoff is trapped were not considered in the Rio
Grande/Bravo basin analysis.
A powerful conclusion from this
research is that regional HydroID assignment is critical to the success of
regionalization. The HydroID enables the connection between features in the
landscape, including the connection of watersheds to outlet junctions, as well
as the connection of junctions with next downstream junction. Also, it allows
the integration of subregions into regions, through the update of the
NextDownID in the most downstream junction in each region.
The main difference in processing
watershed parameters using any traditional method and the Raster Network
Regionalization technique proposed in this research is that in the traditional
methods, raster data are used both for determining the local values as well as
upstream accumulated values of the watershed parameters, whereas the technique
applied in this research uses a combination of raster and vector data to find
these parameters. The local areas are derived from raster and all the other
values are determined in a vector environment.
The time series component of the Arc
Hydro Data Model is being improved to more efficiently store and manage large
numbers of time series records using a common data schema. One more table
called TSGroup that contains information related to the agency from which the
data is derived is added to the original ArcHydro structure. By this way, users
will be able to select a specific monitoring point within the geodatabase and
several relationships have been established for it, so they can identify the
sources from which the temporal data were derived, as well as the type of
variable. This new time series format is more robust and can handle more than
five million records distributed in many variable types. This new framework is
being applied to the Rio Grande/Bravo basin geodatabase to improve the
management of temporal information gathered from
A GIS toolset called DSS Hydro tool is being developed in this research. This will be used to transfer historical records from the Rio Grande/Bravo basin geodatabase into HEC-DSS files for using with USACE HEC models. This tool consists of a set of public domain utilities comprised of four commands that operates in the ArcGIS ArcMap environment.
BIBLIOGRAPHY
Al-Sabhan, W., Mulligan, M., Blckburn, G.A. “A real-time
hydrological model for flood prediction using GIS and the WWW.” Computers, Environment and Urban Systems, Vol. 27, (2003) pp. 9-32
Abrahart, R. J., et al.
"MEDRUSH - Spatial and Temporal River-basin Modelling at Scales Commensurate
with Global Environmental Change." In K. Kovar and H. P. Nachtnebel
(eds.), Application of Geographic
Information Systems in Hydrology and Water Resources Management (pp.
47-54). Proceedings of the HydroGIS '96
Conference,
Eaton, D. J., and Hurlbut, D. “Challenge in the Binational
Management of Water Resources in the Rio Grande/Rio Bravo.”
ESRI. “FAQ: What is the maximum size a grid can be?” Article
14575 (2005)
Figurski, Melissa J. GIS
Algorithms for Large Watersheds with Non-contributing Areas. Thesis.
The
Garbrecht, J, Martz, LW. “TOPAZ
v 3.1: and automated digital landscape analysis tool for topographic
evaluation, drainage identification, watershed segmentation and subcatchment
parameterization.” TOPAZ User Manual, Report #2-00 Grazinglands Research
Laboratory, USDA, Agricultural Research Service, El Reno, OK; (2000) 143
Funke, R., Schumann, A.,
Schultz, G.A. “Regionalization of parameters in mesoscale hydrological models.”
International Association of Hydrological Science Publication n 254
(1999), 171-179
Goodall, J., Maidment, D., and
Sorenson, J. “Representation
of spatial and temporal data in ArcGIS.” AWRA GIS and Water Resources III
Conference, (2004)
Gopalan, Hema. “WRAPHydro Data Model: Finding Input Parameters
for the Water Rights Analysis Package.” Thesis.
The
Hudgens, Bradley T., and David R.
Maidment. “Geospatial Data in Water Availability Modeling.” Thesis. The
International Boundary Water Commission (IBWC). “Convention
between the
Jenson, S.K., Domingue, J.O., “Extracting topographic
structure from digital elevation data for geographical information system
analysis.” Photogrammetric Engineering and Remote Sensing 54 (1988),
1593-1600
Kite, GW. “Scaling of input data for macroscale hydrologic
modeling.” Water Resources Research 31 (1995) 2769-2781
Lacroix, M.P., Martz, L.W., Kite, G.W., and Garbrecht, J. “Using
digital terrain analysis modeling techniques for the parameterization of a
hydrologic model.” Environmental Modeling & Software 17 (2002)
127-136
Maidment, David R. “Arc Hydro: GIS for Water Resources.”
Mason, David. An
Analysis of a Methodology for Generating Watershed Parameters using GIS. Thesis.
The
Patino, C.,
http://www.crwr.utexas.edu/gis/gishydro04/time/Rio_Grande-Bravo_Basin.htm
Patino, C.,
Patino, C.,
SCERP (
SCERP (
Spence, C.,
Streit, Ulrich, and Hans Kleeberg. "GIS-based Regionalization in
Hydrology: German Priority Programme on
Spatial Transfer of Hydrological Information." In K. Kovar and H. P.
Nachtnebel (eds.), Application of Geographic Information Systems in
Hydrology and Water Resources Management (pp. 485-491). Proceedings of the HydroGIS '96 Conference,
Teasley, R. L.,
The alliance for the Rio Grande Heritage, Forest Guardians,
Rio Grande Restoration, Defender of Wildlife, The Land and Water Fund of the
Rockies, Amigos Bravos. “Diverting the
http://www.fguardians.org/reports/mrgcdreportoverdiversions.html
The
Encyclopedia of Water in the West 2002. “
Tribe, A. “Automated recognition of valley lines, drainage
networks from grid digital elevation models: a review, a new method.” Journal
of Hydrology 139 (1992) 263-293
US Department of State. “Utilization of waters of the
Whiteaker, Tim. Geographically Integrated Hydrologic
Modeling Systems. Thesis. The
Wurbs, R. A. "Reference and Users Manual for the
Water Rights Analysis Package (WRAP)."
Texas Water Resources Institute, Jul. 2001.