The Basin of Mexico Hydrogeological Database (BMHDB): Implementation, queries and interaction with open source software
Integrated Water Management at the Basin level is a concept that 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...
Uložené v:
| Vydané v: | Environmental modelling & software : with environment data news Ročník 23; číslo 10; s. 1271 - 1279 |
|---|---|
| Hlavní autori: | , |
| Médium: | Journal Article |
| Jazyk: | English |
| Vydavateľské údaje: |
Elsevier Ltd
01.10.2008
|
| Predmet: | |
| ISSN: | 1364-8152 |
| On-line prístup: | Získať plný text |
| Tagy: |
Pridať tag
Žiadne tagy, Buďte prvý, kto otaguje tento záznam!
|
| Abstract | Integrated Water Management at the Basin level is a concept that 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 in different formats. 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 Basin's aquifer system as its main water supply source. However, a regional hydrogeological database in this area does not exist which is why the use of both a Relational Database Management System (RDMBS) and a Geographic Information System (GIS) is proposed in order to improve regional data management in the study area. Data stored in this new database, the Basin of Mexico Hydrogeological Database (BMHDB) comprise data on climatological, borehole and run-off 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 the BMHDB. The structure of the BMHDB allows easy maintenance and updating, representing a valuable tool for the development of regional studies. |
|---|---|
| AbstractList | Integrated Water Management at the Basin level is a concept that 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 in different formats. 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 Basin's aquifer system as its main water supply source. However, a regional hydrogeological database in this area does not exist which is why the use of both a Relational Database Management System (RDMBS) and a Geographic Information System (GIS) is proposed in order to improve regional data management in the study area. Data stored in this new database, the Basin of Mexico Hydrogeological Database (BMHDB) comprise data on climatological, borehole and run-off 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 the BMHDB. The structure of the BMHDB allows easy maintenance and updating, representing a valuable tool for the development of regional studies. |
| Author | Carrera-Hernández, J.J. Gaskin, S.J. |
| Author_xml | – sequence: 1 givenname: J.J. surname: Carrera-Hernández fullname: Carrera-Hernández, J.J. email: jaime.carrera@ipicyt.edu.mx organization: McGill University, Department of Civil Engineering and Applied Mechanics, 817 Sherbrooke Street West, Montreal, QC H3A 2K6, Canada – sequence: 2 givenname: S.J. surname: Gaskin fullname: Gaskin, S.J. email: susan.gaskin@mcgill.ca organization: McGill University, Department of Civil Engineering and Applied Mechanics, 817 Sherbrooke Street West, Montreal, QC H3A 2K6, Canada |
| BookMark | eNqFUbtOAzEQdAESz09AcoVAIofte_mgQIRXIgXRQG0tzhocXexgOwT-njtCRZNmd6WdWc3O7JEt5x0ScsRZxhmvzmcZus_oTcoEYzJjImNcbJFdnlfFQPJS7JC9GGeMsW4udsnq-R3pEKJ11Bv6iF9Wezr6ngb_hr71b1ZDS28hwStEpCfDx9Ht8PSCjueLFufoEiTr3Rn9WGKwGCm4KbUuYQDdL-jKpnfqF-ho9MugkfbSVhDwgGwbaCMe_vV98nJ_93wzGkyeHsY315OBzmueBtI0WnCtZck0MijzKue6QCk51EZWkndFMKgMlrLGwggwDdSvpij796sm3yfH67uL4DuRMam5jRrbFhz6ZVR5XrG8qeuNQMGashS_wHIN1MHHGNCoRbBzCN-KM9VnoGbqLwPVi1BMqC6Djnf5j6ft2r4UwLYb2VdrNnZmfVoMKmqLTuPUBtRJTb3dcOEHAtircA |
| CitedBy_id | crossref_primary_10_1007_s10040_010_0653_6 crossref_primary_10_1016_j_cageo_2018_10_012 crossref_primary_10_1038_s41597_020_0511_x crossref_primary_10_1007_s12665_012_1898_2 crossref_primary_10_1016_j_envsoft_2023_105916 crossref_primary_10_1016_j_apgeochem_2023_105834 crossref_primary_10_1080_02626667_2025_2534192 crossref_primary_10_1007_s10814_010_9045_7 crossref_primary_10_1016_j_cageo_2014_04_013 crossref_primary_10_1007_s11069_015_1894_4 crossref_primary_10_1080_15732479_2012_757789 crossref_primary_10_1007_s10040_015_1363_x crossref_primary_10_1007_s12145_018_0351_9 crossref_primary_10_1007_s40710_025_00758_2 crossref_primary_10_1016_j_rse_2021_112474 crossref_primary_10_1016_j_jhydrol_2008_02_012 crossref_primary_10_3390_jmse8030186 |
| ContentType | Journal Article |
| Copyright | 2008 Elsevier Ltd |
| Copyright_xml | – notice: 2008 Elsevier Ltd |
| DBID | AAYXX CITATION 7QH 7TG 7UA C1K F1W H97 KL. L.G 7SC 8FD FR3 JQ2 KR7 L7M L~C L~D |
| DOI | 10.1016/j.envsoft.2008.02.012 |
| DatabaseName | CrossRef Aqualine Meteorological & Geoastrophysical Abstracts Water Resources Abstracts Environmental Sciences and Pollution Management ASFA: Aquatic Sciences and Fisheries Abstracts Aquatic Science & Fisheries Abstracts (ASFA) 3: Aquatic Pollution & Environmental Quality Meteorological & Geoastrophysical Abstracts - Academic Aquatic Science & Fisheries Abstracts (ASFA) Professional Computer and Information Systems Abstracts Technology Research Database Engineering Research Database ProQuest Computer Science Collection Civil Engineering Abstracts Advanced Technologies Database with Aerospace Computer and Information Systems Abstracts Academic Computer and Information Systems Abstracts Professional |
| DatabaseTitle | CrossRef Aquatic Science & Fisheries Abstracts (ASFA) Professional Meteorological & Geoastrophysical Abstracts ASFA: Aquatic Sciences and Fisheries Abstracts Aqualine Meteorological & Geoastrophysical Abstracts - Academic Aquatic Science & Fisheries Abstracts (ASFA) 3: Aquatic Pollution & Environmental Quality Water Resources Abstracts Environmental Sciences and Pollution Management Civil Engineering Abstracts Technology Research Database Computer and Information Systems Abstracts – Academic ProQuest Computer Science Collection Computer and Information Systems Abstracts Engineering Research Database Advanced Technologies Database with Aerospace Computer and Information Systems Abstracts Professional |
| DatabaseTitleList | Civil Engineering Abstracts Aquatic Science & Fisheries Abstracts (ASFA) Professional |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Engineering Ecology Computer Science Environmental Sciences |
| EndPage | 1279 |
| ExternalDocumentID | 10_1016_j_envsoft_2008_02_012 S1364815208000418 |
| GeographicLocations | Mexico Mexico, Distrito Federal, Mexico City |
| GeographicLocations_xml | – name: Mexico – name: Mexico, Distrito Federal, Mexico City |
| GroupedDBID | --K --M -~X .DC .~1 0R~ 1B1 1RT 1~. 1~5 29G 4.4 457 4G. 53G 5GY 5VS 7-5 71M 8P~ AABNK AACTN AAEDT AAEDW AAHBH AAIKJ AAKOC AALRI AAOAW AAQFI AAQXK AAXKI AAXUO AAYFN AAYOK ABBOA ABFNM ABFYP ABJNI ABLST ABMAC ABXDB ACDAQ ACGFS ACIWK ACNNM ACRLP ACZNC ADBBV ADEZE ADJOM ADMUD AEBSH AEKER AENEX AFJKZ AFKWA AFRAH AFTJW AFXIZ AGHFR AGUBO AGYEJ AHEUO AHZHX AIALX AIEXJ AIKHN AITUG AJOXV AKIFW AKRWK ALMA_UNASSIGNED_HOLDINGS AMFUW AMRAJ AOUOD ASPBG AVWKF AXJTR AZFZN BKOJK BLECG BLXMC CS3 DU5 EBS EFJIC EJD EO8 EO9 EP2 EP3 FDB FEDTE FGOYB FIRID FNPLU FYGXN G-Q GBLVA GBOLZ HVGLF HZ~ IHE J1W KCYFY KOM M41 MO0 N9A O-L O9- OAUVE OZT P-8 P-9 P2P PC. Q38 R2- RIG ROL RPZ SDF SDG SDP SES SEW SPC SPCBC SSJ SSV SSZ T5K UHS ~02 ~G- 9DU AATTM AAYWO AAYXX ABWVN ACLOT ACRPL ACVFH ADCNI ADNMO AEIPS AEUPX AFPUW AGQPQ AIGII AIIUN AKBMS AKYEP ANKPU APXCP CITATION EFKBS EFLBG ~HD 7QH 7TG 7UA C1K F1W H97 KL. L.G 7SC 8FD FR3 JQ2 KR7 L7M L~C L~D |
| ID | FETCH-LOGICAL-c371t-8f9c21cc850ce0a53631c4e881a7f8681f8620a6fe587e4f2af9a7bf452008693 |
| ISICitedReferencesCount | 17 |
| ISICitedReferencesURI | http://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=Summon&SrcAuth=ProQuest&DestLinkType=CitingArticles&DestApp=WOS_CPL&KeyUT=000257620800006&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| ISSN | 1364-8152 |
| IngestDate | Sat Sep 27 21:07:23 EDT 2025 Tue Oct 07 09:40:59 EDT 2025 Sat Nov 29 02:36:10 EST 2025 Tue Nov 18 20:41:44 EST 2025 Thu Nov 14 02:16:24 EST 2024 |
| IsPeerReviewed | true |
| IsScholarly | true |
| Issue | 10 |
| Keywords | GIS Groundwater management Open source software Mexico City Spatial database |
| Language | English |
| License | https://www.elsevier.com/tdm/userlicense/1.0 |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-c371t-8f9c21cc850ce0a53631c4e881a7f8681f8620a6fe587e4f2af9a7bf452008693 |
| Notes | ObjectType-Article-1 SourceType-Scholarly Journals-1 ObjectType-Feature-2 content type line 23 ObjectType-Article-2 ObjectType-Feature-1 |
| PQID | 20955277 |
| PQPubID | 23462 |
| PageCount | 9 |
| ParticipantIDs | proquest_miscellaneous_33603977 proquest_miscellaneous_20955277 crossref_primary_10_1016_j_envsoft_2008_02_012 crossref_citationtrail_10_1016_j_envsoft_2008_02_012 elsevier_sciencedirect_doi_10_1016_j_envsoft_2008_02_012 |
| PublicationCentury | 2000 |
| PublicationDate | 2008-10-01 |
| PublicationDateYYYYMMDD | 2008-10-01 |
| PublicationDate_xml | – month: 10 year: 2008 text: 2008-10-01 day: 01 |
| PublicationDecade | 2000 |
| PublicationTitle | Environmental modelling & software : with environment data news |
| PublicationYear | 2008 |
| Publisher | Elsevier Ltd |
| Publisher_xml | – name: Elsevier Ltd |
| References | Carrera-Hernández, Gaskin (bib3) 2006; 32 Edmunds, Carrillo-Rivera, Cardona (bib6) 2002; 254 Ortega, Farvolden (bib12) 1989; 110 Birkle, Torres-Rodriguez, González-Partida (bib1) 1998; 6 Carrera-Hernández, Gaskin (bib5) 2007; 336 UNCED (bib15) 1992 Pebesma (bib13) 2004; 30 ICWE (bib7) 1992 NRC (bib11) 1995 IMTA (bib8) 1990 Bivand (bib2) 2000; 26 Carrera-Hernández, Gaskin (bib4) 2007; 15 IMTA (bib9) 1995 R Development Core Team (bib14) 2005 |
| References_xml | – volume: 26 start-page: 1043 year: 2000 end-page: 1052 ident: bib2 article-title: Using the R statistical data analysis language on GRASS 5.0 GIS database files publication-title: Computers and Geosciences – volume: 336 start-page: 231 year: 2007 end-page: 249 ident: bib5 article-title: Spatio temporal analysis of daily precipitation and temperature in the Basin of Mexico publication-title: Journal of Hydrology – year: 1990 ident: bib8 article-title: Extractor Rápido de Información Climatológica (ERIC) – year: 1995 ident: bib9 article-title: Banco Nacional de Datos de Aguas Superficiales (BANDAS) – volume: 254 start-page: 1 year: 2002 end-page: 24 ident: bib6 article-title: Geochemical evolution of groundwater beneath Mexico City publication-title: Journal of Hydrology – volume: 32 start-page: 339 year: 2006 end-page: 351 ident: bib3 article-title: The groundwater modeling tool for GRASS (GMTG): open source groundwater flow modeling publication-title: Computers and Geosciences – year: 1995 ident: bib11 article-title: Mexico City's Water Supply: Improving the Outlook for Sustainability – volume: 110 start-page: 271 year: 1989 end-page: 294 ident: bib12 article-title: Computer analysis of regional groundwater flow and boundary conditions in the basin of Mexico publication-title: Journal of Hydrology – year: 2005 ident: bib14 article-title: R: a Language and Environment for Statistical Computing – year: 1992 ident: bib15 article-title: United Nations Conference on Environment and Development – volume: 15 start-page: 1577 year: 2007 end-page: 1590 ident: bib4 article-title: The Basin of Mexico aquifer system: regional groundwater level dynamics and database development publication-title: Hydrogeology Journal – year: 1992 ident: bib7 article-title: International Conference of Water and Environment – volume: 30 start-page: 683 year: 2004 end-page: 691 ident: bib13 article-title: Multivariable geostatistics in S: the gstat package publication-title: Computers and Geosciences – volume: 6 start-page: 500 year: 1998 end-page: 517 ident: bib1 article-title: The water balance for the Basin of the Valley of Mexico and implications for future water consumption publication-title: Hydrogeology Journal |
| SSID | ssj0001524 |
| Score | 1.9887967 |
| Snippet | Integrated Water Management at the Basin level is a concept that was introduced in the 1990s and is a goal in every national and local water management plan.... |
| SourceID | proquest crossref elsevier |
| SourceType | Aggregation Database Enrichment Source Index Database Publisher |
| StartPage | 1271 |
| SubjectTerms | Freshwater GIS Groundwater management Mexico City Open source software Spatial database |
| Title | The Basin of Mexico Hydrogeological Database (BMHDB): Implementation, queries and interaction with open source software |
| URI | https://dx.doi.org/10.1016/j.envsoft.2008.02.012 https://www.proquest.com/docview/20955277 https://www.proquest.com/docview/33603977 |
| Volume | 23 |
| WOSCitedRecordID | wos000257620800006&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| journalDatabaseRights | – providerCode: PRVESC databaseName: Elsevier SD Freedom Collection Journals 2021 issn: 1364-8152 databaseCode: AIEXJ dateStart: 19970101 customDbUrl: isFulltext: true dateEnd: 99991231 titleUrlDefault: https://www.sciencedirect.com omitProxy: false ssIdentifier: ssj0001524 providerName: Elsevier |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV1bb9MwFLbKBhI8cClMjKsfQAKVlNi52byto6hU2oS0IfUtch0HbSrplHZb98v4exzf0nbaNEDixUksO3F0vpxzfHIuCL1hSvAUeG8AmwcRxLwYB2Miy0BQOhYxGSsiC1NsItvfZ6MR_9Zq_fKxMGeTrKrYYsFP_iupoQ-IrUNn_4LczU2hA86B6NAC2aH9Y8L3xOzI6IF7agGk7gwuinr6Qy0ZnZgLLb-0ftnbG3zuvaVc2wZMruCfLhzJ8CMQG3oz7ZI06XBlW1vc2G916a2ONf_DoZyfi3rNs6i_jKLTQSq66M7EmibSZryxSZi7rcTcdbTjamdV49_VLsW1CAaqrszPfeKN38PusNt4EYmZKy924Hu9RYM1vnHOzOZDbZZ-TZozR2kcMJKssW4bquwhGq4wYkJtZRcn1OGSXykwrO3iuAuvqN_bOdfSbuicu9dzcR_oVehFaD07jAm7hTZplnBgp5s7X_ujYaMEwBhbT9mtehk89vHKh12nFl1SEIzWc_gQ3XfbFbxjYfYItVTVRg98KRDsJEMb3emb7OcXbXRvJcNlG22tQcCPnz1G5wBTbGCKpyW2MMWXYIo9TPE7A9L3n_A6QD9gB08M8MQr8MQaUFjDE1t4Yg-3J-j7l_7h7iBwRUACGWVkHrCSS0qkZEkoVSiSKI2IjBVjRGQlSxmBhoYiLVXCMhWXVJRcZOMy1vnEWMqjLbRRTSv1FOFEyZAVSSxSXsSFLITIYHNBiVBcKpaKbRR7GuTSZcjXhVomuXeFPM4d6Vz1VpoD6bZRt5l2YlPE3DSBeQLnTs-1-msOqLxp6msPiBzkgP65Jyo1PZ3BIK6TKWbXj4iiNNTbvWf__vjn6O7yg32BNub1qXqJbsuz-dGsfuW-gd8Lren7 |
| linkProvider | Elsevier |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=The+Basin+of+Mexico+Hydrogeological+Database+%28BMHDB%29%3A+Implementation%2C+queries+and+interaction+with+open+source+software&rft.jtitle=Environmental+modelling+%26+software+%3A+with+environment+data+news&rft.au=Carrera-Hern%C3%A1ndez%2C+J.J.&rft.au=Gaskin%2C+S.J.&rft.date=2008-10-01&rft.pub=Elsevier+Ltd&rft.issn=1364-8152&rft.volume=23&rft.issue=10&rft.spage=1271&rft.epage=1279&rft_id=info:doi/10.1016%2Fj.envsoft.2008.02.012&rft.externalDocID=S1364815208000418 |
| thumbnail_l | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=1364-8152&client=summon |
| thumbnail_m | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=1364-8152&client=summon |
| thumbnail_s | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=1364-8152&client=summon |