WATER MANAGEMENT INFORMATION SYSTEM FOR THE
RIO GRANDE/BRAVO BASIN
By Carlos Patino, Daene C. McKinney & David R. Maidment
CRWR - UT
The Center for Research in Water
Resources (CRWR) of the
The Rio Grande/Bravo is a
transboundary water source shared by the
In addition, some decisions about water management are only partially supported, causing with it 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/Rio Bravo basin is
fundamental. Minute 308 of the International Boundary Waters Commission (IBWC),
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 American side (

Fig. 1. 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 as an arid and 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. The Rio Conchos enters to the Rio Grande/Bravo near Presidio,

Figure 2. The primary
tributaries in the Rio Grande/Bravo basin
DEVELOPMENT OF THE GEOSPATIAL
DATABASE IN ArcGIS
The development of a
watershed-scale database is fundamental. Even though separate research efforts
have been carried out on each side of the river, there is not an integral
database that includes 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. 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
ArcHydro data model has recently been developed and released to facilitate
access to hydrologic information by models (Maidment, 2002). It is expected to
become an industry standard for hydrologic applications of GIS and models.
Geographic Information Systems
(GIS) is a general-purpose technology for handling geographic data in digital
form. Its abilities include: preprocessing data into a form suitable for
analysis, supporting spatial analysis and modeling directly, and post
processing results (Goodchild, 1993). GIS offers a
spatial representation of water resource systems. A GIS can bring spatial dimensions
into the traditional water resource database, and it has the ability to present
an integrated view of the world. This is accomplished by combining various
social, economic and environmental factors related to spatial entities of a
water resources problem and making them available for use in a decision-making
process (Csillag, 1996).
The first step in our effort is
to create a geospatial database using the ArcHydro data model for the entire
Rio Grande/Rio Bravo basin that represents the first major attempt to establish
a more complete understanding of the basin as a whole, using both Mexican and
The
recent developments related to the relational geodatabase construction are
described in this section, considering the original sources and the application
of a specific schema called WRAPHydro to the collected information. The WRAP
Hydro data model has been derived from the Arc Hydro model and is tailored
specifically for the Water Rights Analysis Package (WRAP) project developed
jointly with the TCEQ. This data model is structured to suit the needs of the
WRAP parameter processing. The WRAP is a hydrological simulation model to
evaluate, existing water right permits, permit approvals for new water rights,
and overall water management in
Hydrological information was
obtained from Mexican and
Several errors were found in the
hydrological information such as wrong positions of some control points,
disconnection in the river network, wrong location of some water bodies, etc.
Part of the original information is shown in Figure 3. This information had to
be edited using ArcMap 8.3, in order to fix these errors.
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 American side (1:100K) Cuencas and Sub-Cuencas from IMTA and UACJ for the Mexican side
(1:250K) |
Available |
Available |
|
Hydrography (Stream network to create
HydroEdge) Source: USGS for |
Available |
Available |
|
Water Bodies and dam locations Source: USGS- HUC’S for the American side (1: 100K) Source: IMTA, CNA, and UACJ (1:250K) |
Available |
Available |
|
Monitoring points location Source: USGS for the American side IMTA and CAN for the Mexican side as hydrometric and climatic
stations. |
Available |
Available |
|
Historical hydrometric information (time
series) Sources: National Water Information System for the American side
(1940 – 2000) IMTA for the Mexican side. This information was obtained from the
BANDAS System that includes 67 hydrometric stations located in the Rio
Grande/Bravo basin |
Available |
Available |
|
Climatologic information (time series) Sources: USGS and PRISM for
the American side 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 American side. Resolution: 30 m of cell size; Source on the Mexican side: INEGI. Cell size: 104 m |
Available |
Available |
|
Control Points (Include water rights, return
flow points, diversions, etc) This information was obtained from the TCEQ on the American side;
and from the CNA for the Mexican side. This information was available as a
shapefile in ArcView 3.2 |
Available |
Available |

Figure 3. Cuencas, Sub Cuencas and original
hydrography of the
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 corresponded
to the GCS_North_American_1983, while the
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

Figure 4. 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 the feature classes related
to each type of information. When working with huge basins like the Rio
Grande/Bravo basin, the computer processor might not be able to handle the large
datasets, especially the raster processing part. This is dealt with by dividing
the basin into sub regions and processing grids individually for each region. The
values obtained for each sub basin can be cascaded downstream to get the final
parameters for the control points for the entire basin. For this reason, the whole basin was divided
into 9 hydrological subregions on the U.S. side, according to the USGS
classification, and 7 hydrological subregions on the Mexican side, in order to
apply the ArcHydro tools subregion by subregion (Figure 5). These seven sub
basins substituted to the Cuencas and sub Cuencas identified on

Figure 5. Rio Grande/Bravo basin including HUCs on the American side; as well as Cuencas
and
SubCuencas on the Mexican side
Temporal climatic and hydrological data were selected and imported from the BANDAS, ERIC, and NWIS systems corresponding to monitoring points located in the Rio Grande/Bravo basin. Average annual precipitation was obtained from 230 climatic stations located on the Mexican side (Figure 6 & 7).
|
Figure 6. Climatic stations on the Mexican side |
Figure 7. Hydrometric stations on the whole basin |
The ArcGIS format is applied to all temporal data obtained in the last step in order to include and relate the time series 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 contain information related to the Agency from where data is coming. 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

You can select a specific monitoring point within the geodatabase and several relationships have been established to it, so you can identify the agencies from where the temporal data was gotten, as well as the type of variable. The Rio Conchos runoff to the Rio Grande/Bravo is shown below



Also, a time series viewer was applied in order to plot the behavior of the temporal information. The information related to runoff from the Rio Conchos to the Rio Grande/Bravo is shown below, where you can see the total water amount discharge to the Rio Grande identified by the HydroID 1040700007. The regional HydroIDs 2020100051 and 2010100005 correspond to the discharge to the Rio Grande from Mexico and the USA respectively.

A particular schema was applied to every hydrological subregion in order to create all necessary fields that were populated by the WRAPHydro tools. The feature classes and fields those are required for the WRAP process are retained, those that are not are removed and some others that do not exist in the ArcHydro Framework and are required by the WRAP process are added. The WRAP Hydro tools consist of a set of public domain utilities developed on top of the Arc Hydro data model. They operate in the ArcGIS ArcMap environment. Some of the functions require the Spatial Analyst extension.
Arc Hydro is a water resources data model that defines attributes, relationships, and connectivity between hydrologic features in a GIS database. Many of the terms and concepts used by the WRAP Hydro tools stem from Arc Hydro (Maidment, 2002). For more information on Arc Hydro, see the Arc Hydro Online Support System at http://www.crwr.utexas.edu/giswr/hydro/ArcHOSS/index.cfm.
The WRAP Hydro tools operate
using a certain database design. This design should be in place before using
the WRAP Hydro tools. The tools are accessed through the WRAP Hydro tools
toolbar, where they are grouped by functions into two menus and five buttons.
The purpose of this toolkit is to process GIS data in order to calculate
parameters used by the Water Rights Analysis Package (WRAP). These parameters are tabulated for each
ControlPoint and include: Average curve number, Average annual precipitation, Total
upstream drainage area, and Next downstream ControlPoint
A unique identification number
called Regional HydroID was assigned to every feature class (River Network and
Control Points mainly for the WRAPHydro process) that includes ten digits
according to the next classification:
![]()
The first digit (from left to
right) describes the hydrological region. The region 13 on the American side
was identified with the number 1, and the number 2 identified the region 24 on the
Mexican side. The second 2 digits describe the Hydrologic SubRegion. The basin
is divided in 9 subregions on the American side and 7 subregions for the
Mexican side. The next two digits correspond to the feature class. The value 01
was assigned for the ControlPoint feature class, while the value 02 was
assigned for the WRAPEdge (River network). WaterBody was identified as 03 and Watershed
was identified as 04; and so on. The last five digits describe the feature
number, with a maximum of 99999 values. The Regional HydroID for the Rio
Conchos basin is shown in the table 2 as an example.
Table
2. Regional HydroID assigned to the Rio Conchos
basin. The Mexican original code is preserved as reference

The HUCs that make up the corresponding
hydrological subregion were selected, including a 10 Km buffer around the HUCs called
a BufferWatershed. All the Hydro Edges that lie within this buffer were
selected and exported in order to create the WRAP Flowline feature class. After
this step, the DEM to the buffered area was clipped and processed it using
Terrain processing tool in Arc Hydro Toolset. The delineation of catchments for
each stream segment of WRAP Flowline was made using the Delineate Watershed
tool in WRAP Hydro toolset. This feature class was called WRAPCatchment. The
DrainID of the delineated catchments was populated by the HydroIDs of the WRAP
Flowline segment it is draining to. In order to create the HydroNetwork, the
relief of the hydrography information had to be checked. Every stream should be
connected and the flow direction assigned correctly. The river network must be
edited to establish the appropriate connections among the rivers assigning the
correct flow direction to them. The hydro network is an essential part of this
data model, created from edges and the control points. The topological
connections of its HydroEdges 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 hydro network. This
hydro network allows knowing the distance between any two points on a flow
path.
Figure 8 describes the comparison between the SubCuencas at the Rio Conchos basin defined by INEGI (continuously line) and the WRAPWatershed defined by the WRAPHydro Tools (polygons), as well as the connectivity among control points. The SubCuencas were defined using a topographic map 1:250K, while the WRAPWatershed feature considered a WRAPEdge 1:100K (from a digitalized map) and a DEM resolution of 30 m close to the border, and 90 m for the rest of the Rio Conchos sub basin. The points represent the related water rights and return flow control points.
Figure 9 shows the schematic network diagram for the whole basin. This schematic network is a simplification of the hydro network that consists of separate point and line feature classes called SchematicNode and SchematicLink, respectively. The schematic network is an abstract representation of the elements to which the hydrologic models are applied, and it provides a simplified view of the connectivity of the river network and the control points. This kind of networks are useful as a visual check to make sure that the hydrologic elements needed for a model are correctly linked in the landscape (Maidment, 2002)
|
Figure 8. Hydro network of the Rio Conchos basin |
Figure 9. Schematic
network of the Rio Grande/Bravo basin |
A binational geodatabase was
created that includes a relational database containing hydrologic, hydraulic
and related data for the Rio Grande/Bravo basin. This geodatabase will be made
available to Mexican and
This research project was funded
by the Texas Commission on Environmental Quality. I would like also to express
my appreciation to the Mexican National Council for Science and Technology, who
is supporting my PhD program at the
Csillag, F., 1996. Variation on hierarchies: toward linking and integrating structures. In: Goodchild, M.F. et al (Eds.), GIS and Environmental Modeling: Progress and Research Issues. GIS World Publication, Fort Collins, CO, pp. 433-437
Goodchild, M.F.,
1993. Data models and data quality: problems and prospects. In: Goodchild, M. F., Parks, B.O., Steyaert, L.T., (Eds.),
Environmental Modeling with GIS.
Tate, Diane E., 2002. Bringing Technology to the Table: Computer
Modeling, Dispute Resolution, and the
Maidment, D. R., 2002. Arc Hydro: GIS for Water Resources. ESRI Press
Two ArcHydro training courses have been offered, one in English and one in Spanish, to the Texas Commission on Environmental Quality (TCEQ) and Mexican National Water Commission (CNA). You can have the lecture notes in the link shown below:
ftp://ftp.crwr.utexas.edu/pub/outgoing/PATINOC/CD_CursoArcHydro_2004/
ftp://ftp.crwr.utexas.edu/pub/outgoing/PATINOC/WRAPHydro_TrainingCourse/