The Basin of Mexico Hydrogeological Database: Implementation, Queries and Interaction with Open Source Software

Carrera-Hernandez, J.J. (2007). The Basin of Mexico Hydrogeological Database: Implementation, Queries and Interaction with Open Source Software. IIASA Interim Report. IIASA, Laxenburg, Austria: IR-07-018

Preview

Text IR-07-018.pdf Download (2MB) | Preview

Abstract

Integrated Water Management at the Basin level concept was introduced in the 1990s, and is a goal in every national and local water management plan. Unfortunately this goal has not been achieved mainly due to a lack of both tools and data management, as data must be gathered from different sources, and converted from diverse formats into a consistent database. Compounding this problem is the fact that in some regions different water agencies are in charge of water supply as is the case in the Basin of Mexico, in which Mexico City and its Metropolitan Zone are located. The inhabitants of the Basin of Mexico, which comprises five different political entities and in which different agencies are in charge of water supply rely on the Basins aquifer system as its main water supply source.

No regional hydrogeological database in this area however exists therefore a Relational Database Management System was developed, and its use with a Geographic Information System is proposed in order to improve regional data management in the study area. Data stored in this new database (called the Basin of Mexico Hydrogeological Database) comprises data on climatological, borehole and runoff variables, readily providing information for the development of hydrogeological models. A simple example is used to show how geostatistical analysis can be done using the data directly from this database. The structure of the database supports easy maintenance and updating, representing a valuable tool for the development of regional studies.

Actions (login required)

View Item