Development of a knowledge base to support the consideration of groundwater protection in land-use planning
Tóm tắt
Groundwater is an essential resource for water supply, but it is vulnerable to the potential impacts of contaminant emissions from human activities. It is widely recognized that the effects of human activities on groundwater quality and quantity can be mitigated, in large part, by appropriate land-use planning because it plays a central role in groundwater protection and conservation. However, groundwater-related issues are not commonly considered in the land-use decision-making process. The main objective of this paper was to develop a decision-support system (DSS) to fill the gap between groundwater resources management, territorial development and the land-use institutional framework. To achieve this objective, it was necessary to establish a dialogue with decision makers to identify their needs. Then, by linking human activities and their related contaminants and impacts, it was possible to identify land-use planning actions that could support groundwater protection. This research resulted in a tool named “Base de connaissances—aménagement du territoire et eau souterraine” (BC-ATES) [Knowledge base—Land-use planning and groundwater]. This tool was tested using Microsoft Access. It includes all the information identified as relevant by land-use planners in the decision process regarding groundwater needs.
Tài liệu tham khảo
Akoka J, Comyn-Wattiau I (2001) Conception des bases de données relationnelles [Designing relational databases]. Vuibert informatique, Paris
Aller L, Bennett T, Lehr JH, Petty R, Hackett G (1987) DRASTIC: a standardized system for evaluating ground water pollution potential using hydrogeologic settings. National Water Well Association, Dublin
Armstrong MP (1990) Database integration for knowledge based groundwater quality assessment. Comput Environ Urban Syst 14:187–201. doi:10.1016/0198-9715(90)90008-H
Audet-Gagnon F, Roy M, Ballard J-M, Carrier M-A (2013) Protocole pour la préparation du Livrable 23—Indice de densité d’activités anthropiques. (Programme d’acquisition de connaissances sur les eaux souterraines du Québec) [Protocol for the preparation of Deliverable 23—Density index of anthropogenic activities. (Québec’s regional groundwater resources assessment program)]. Université du Québec en Abitibi-Témiscaminque (UQAT) en collaboration avec l’Institut national de la recherche scientifique, Centre—Eau Terre Environnement (INRS-ETE)
Caron S, Cerutti J, Marleau Donais F, Vallières L (2016) Eau souterraine: une planification à la source de la protection [Groundwater: land-use planning at the source of its protection]. Dissertation, Université Laval
Changming L, Jingjie Y, Kendy E (2001) Groundwater exploitation and its impact on the environment in the North China Plain. Water Int 26:265–272. doi:10.1080/02508060108686913
Codd EF (1970) A relational model of data for large shared data banks. Commun ACM 13:377–387. doi:10.1145/362384.362685
Collin ML, Melloul AJ (2001) Combined land-use and environmental factors for sustainable groundwater management. Urban Water 3:229–237. doi:10.1016/S1462-0758(01)00049-8
Conacher AJ (1994) The integration of land-use planning and management with environmental impact assessment: some Australian and Canadian perspectives. Impact Assess 12:347–372. doi:10.1080/07349165.1994.9725874
Connolly TM, Begg CE (2005) Systèmes de bases de données: approche pratique de la conception, de l’implémentation et de l’administration [Database Systems: A Practical Approach to Design, Implementation and Administration]. Éditions Reynald Goulet, Repentigny
Custodio E (2002) Aquifer overexploitation: what does it mean? Hydrogeol J 10:254–277. doi:10.1007/s10040-002-0188-6
Driedger SM, Mazur C, Mistry B (2014) The evolution of blame and trust: an examination of a Canadian drinking water contamination event. J Risk Res 17:837–854. doi:10.1080/13669877.2013.816335
European Union, European Commission, Directorate-General for the Environment (2008) Protection des eaux souterraines en Europe: la nouvelle directive sur les eaux souterraines: une consolidation du cadre réglementaire de l’UE [Groundwater protection in Europe: the new groundwater directive: consolidation of the EU’s regulatory framework]
Favennec J-P (1998) Raffinage du pétrole (Le) [Oil refining]. Tome 5. Exploitation et gestion de la raffinerie. Editions TECHNIP
Foster SS (2001) The interdependence of groundwater and urbanisation in rapidly developing cities. Urban Water 3:185–192. doi:10.1016/S1462-0758(01)00043-7
Foster S, Cherlet J (2014) The links between land use and groundwater—Governance provisions and management strategies to secure a “sustainable harvest.” Global Water Partnership
Gabillaud J (2009) Oracle 11g: SQL, PL/SQL, SQL*Plus. Editions ENI
Gleeson T, VanderSteen J, Sophocleous MA et al (2010) Groundwater sustainability strategies. Nat Geosci 3:378–379. doi:10.1038/ngeo881
Granato GE, Smith KP (2002) Robowell—providing accurate and current water-level and water-quality data in real time for protecting ground-water resources: US Geological Survey Fact Sheet FS-053-02:6. In: USGS. https://pubs.usgs.gov/fs/fs05302/robo.htm. Accessed 4 May 2016
Haase D (2009) Effects of urbanisation on the water balance—a long-term trajectory. Environ Impact Assess Rev 29:211–219. doi:10.1016/j.eiar.2009.01.002
Hayashi T, Tokunaga T, Aichi M et al (2009) Effects of human activities and urbanization on groundwater environments: an example from the aquifer system of Tokyo and the surrounding area. Sci Total Environ 407:3165–3172. doi:10.1016/j.scitotenv.2008.07.012
Hrudey SE, Huck PM, Payment P et al (2002) Walkerton: lessons learned in comparison with waterborne outbreaks in the developed world. J Environ Eng Sci 1:397–407. doi:10.1139/s02-031
Lavoie R (2013) Stratégies pour faciliter l’intégration de l’eau souterraine dans la prise de décision en aménagement du territoire [Strategies to facilitate the integration of groundwater in land-use planning decision-making]. Dissertation, Université Laval
Lefebvre R, Ballard J-M, Carrier M-A et al (2015) Portrait des ressources en eau souterraine en Chaudière-Appalaches, Québec, Canada [A Portrait of groundwater resources in Chaudière-Appalaches, Québec, Canada]. Projet réalisé conjointement par l’Institut national de la recherche scientifique (INRS), l’Institut de recherche et développement en agroenvironnement (IRDA) et le Regroupement des organismes de bassins versants de la Chaudière-Appalaches (OBV-CA) dans le cadre du Programme d’acquisition de connaissances sur les eaux souterraines (PACES), Rapport final INRS R-1580, soumis au MDDELCC en mars 2015
Lerner DN, Harris B (2009) The relationship between land use and groundwater resources and quality. Land Use Policy 26:S265–S273. doi:10.1016/j.landusepol.2009.09.005
Livernois J (2002) The economic costs of the Walkerton water crisis. Ministère du procureur général, Toronto
Maupin MA, Kenny JF, Hutson SS et al (2014) Estimated use of water in the United States in 2010. U.S. Geological Survey, Reston
Ministère des Affaires municipales et de l’Occupation du territoire (MAMROT) (2010a) Manuel d’évaluation foncière du Québec [Québec’s property assessment manual] (MEFQ). In: Ministère des Affaires municipales et de l’Occupation du territoire. http://www.mamrot.gouv.qc.ca/evaluation-fonciere/manuel-devaluation-fonciere-du-quebec/edition-modernisee-depuis-2010/. Accessed 9 Aug 2016
Ministère des Affaires municipales et de l’Occupation du territoire (2010b) Codes d’utilisation des biens-fonds [The land-use code]. In: Ministère des Affaires municipales et de l’Occupation du territoire. http://www.mamrot.gouv.qc.ca/evaluation-fonciere/manuel-devaluation-fonciere-du-quebec/codes-dutilisation-des-biens-fonds/. Accessed 9 Aug 2016
Ministère des Affaires municipales et de l’Occupation du territoire (MAMROT) (2016) Répertoire des municipalités: No. 12—Chaudière-Appalaches [Directory of municipalities: No. 12—Chaudière-Appalaches]. In: Ministère des Affaires municipales et de l’Occupation du territoire. http://www.mamrot.gouv.qc.ca/repertoire-des-municipalites/fiche/region/12/. Accessed 13 Jun 2016
Ministère du Développement Durable, de l’Environnement et de la Lutte contre les Changements Climatiques (2015) Programme d’acquisition de connaissances sur les eaux souterraines (PACES) [Regional groundwater resources assessment program]. In: MDDELCC. http://www.mddelcc.gouv.qc.ca/eau/souterraines/programmes/acquisition-connaissance.htm#premier. Accessed 6 Mar 2016
Mullen J, Vladi N, Mills AJ (2006) Making sense of the Walkerton crisis. Cult Organ 12:207–220. doi:10.1080/14759550600865933
Nguyen DH, Meier A (2006) Introduction pratique aux bases de données relationnelles [Practical introduction to relational databases]. Springer-Verlag, Paris
O’Connor DR (2002) Report of the Walkerton inquiry. Ontario Ministry of the Attorney General, Ontario
Onodera S, Saito M, Sawano M et al (2008) Effects of intensive urbanization on the intrusion of shallow groundwater into deep groundwater: examples from Bangkok and Jakarta. Sci Total Environ 404:401–410. doi:10.1016/j.scitotenv.2008.08.003
Ponniah P (2003) Database design and development: an essential guide for IT professionals. John Wiley & Sons Inc, Hoboken
Réseau Québecois sur les Eaux Souterraines (RQES) (2012) Qu’est-ce-que les PACES? [What are the PACES?]. In: RQES. http://rqes-gries.ca/fr/archives-et-documents/rapports-memoires-et-cartes/260-quest-ce-que-les-paces.html. Accessed 27 May 2016
Réseau Québecois sur les Eaux Souterraines (RQES) (2016) La stratégie de transfert et d’échange de connaissances sur les eaux souterraines [The Groundwater Knowledge Transfer and Exchange Strategy]. In: rqes. http://rqes.ca/strategie-de-transfert-dechange-de-connaissances-eaux-souterraines/. Accessed 19 Jan 2017
Scanlon BR, Reedy RC, Stonestrom DA et al (2005) Impact of land use and land cover change on groundwater recharge and quality in the southwestern US. Glob Change Biol 11:1577–1593. doi:10.1111/j.1365-2486.2005.01026.x
Services Québec (2015) Chaudière-Appalaches (12)—Portail Québec. In: Portail Québec. http://www.gouv.qc.ca/FR/LeQuebec/Pages/ChaudiereAppalaches.aspx. Accessed 13 Jun 2016
Tang Z, Engel BA, Pijanowski BC, Lim KJ (2005) Forecasting land use change and its environmental impact at a watershed scale. J Environ Manag 76:35–45. doi:10.1016/j.jenvman.2005.01.006
Trabelsi R, Zaïri M, Smida H, Ben Dhia H (2005) Salinisation des nappes côtières: cas de la nappe nord du Sahel de Sfax, Tunisie [Salinization of coastal aquifers: case of the northern Sahel of Sfax, Tunisia]. Comptes Rendus Geosci 337:515–524. doi:10.1016/j.crte.2005.01.010
US EPA (2013) Our built and natural environments: a technical review of the interactions between land use, transportation, and environmental quality, 2nd edn. United States Environmental Protection Agency - Office of Sustainable Communities, Washington
Vicente KJ, Christoffersen K (2006) The Walkerton E. coli outbreak: a test of Rasmussen’s framework for risk management in a dynamic society. Theor Issues Ergon Sci 7:93–112. doi:10.1080/14639220500078153
Vrba J, Aldwell CR, Alfoldi L et al (1991) Integrated land-use planning and groundwater protection in rural areas: a comparative study of planning and management methodologies. UNESCO, Paris
Welling L, Thomson L (2009) PHP et MySQL [PHP and MySQL]. Pearson Education France
Zektser IS, Everett LG, International Hydrological Program (2004) Groundwater resources of the world and their use. UNESCO, Paris