Skip to main content
SpringerLink
Log in

Data integration and standardization in cross-border hydrogeological studies: a novel approach to hydrostratigraphic model development

  • Original Article
  • Published:
Environmental Geology

Abstract

Data integration—or the merging of multiple source data sets—is central to hydrogeological studies. In cross-border situations, data heterogeneities are the source of most integration problems. Semantic integration of the subsurface geological terms is undertaken for the Abbotsford–Sumas aquifer, a cross-border (trans-national) aquifer, which is equally shared by British Columbia (Canada) and Washington State (US). Subsurface information is largely derived from water well information submitted to the respective governments. Use of this information is constrained due to inconsistent use of geological terms in water well reports. Lack of standardized methodology resulted in 6,000 unique geological descriptions for the aquifer alone. Semantic standardization of geological descriptions progressed from database interpretation to domain expert interpretation. Despite the poor quality of water well information, trends were observed that facilitated the development of a hydrostratigraphic model that honors the generalized early conceptual models of the aquifer, but provides a much higher degree of resolution in the stratigraphy necessary for groundwater flow modeling. The standardization protocols introduced support the model creation despite the constraint of poor quality data.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6

Similar content being viewed by others

References

  • Ahlqvist O (2003) Rough and fuzzy geographical data integration. Int J Geogr Inf Sci 17(3):223–234

    Article  Google Scholar 

  • Ahlqvist O (2004) A parameterized representation of uncertain conceptual spaces. Trans GIS 8:493–514

    Article  Google Scholar 

  • Ahlqvist O (2005) Using semantic similarity metrics to uncover category and land cover change. In: Rodriguez MA (ed) GeoS 2005, vol LNCS 3799. Springer, Heidelberg, pp 107–119

  • Armstrong JE (1981) Post-Vashon Wisconsin glaciation, Fraser Lowland, British Columbia. Geological Survey Bulletin 322, Geological Survey of Canada, Ottawa

  • Armstrong JE, Crandell DR, Easterbrook DJ, Noble JB (1965) Late Pleistocene stratigraphy and chronology in Southwestern British Columbia and Northwestern Washington. Geol Soc Am Bull 76:321–330

    Article  Google Scholar 

  • Bishr Y (1998) Overcoming the semantic and other barriers to GIS interoperability. Int J Geogr Inf Sci 12(4):299–314

    Article  Google Scholar 

  • Brigham Young University (2002) Groundwater modeling system (GMS) Version 4.0

  • Cameron VJ (1989) The Late Quaternary geomorphic history of the Sumas Valley. MSc, Department of Geography, Simon Fraser University, Burnaby, 154 pp

  • Clague JJ (1994) Quaternary stratigraphy and history of south-costal British Columbia. In: Monger JWH (ed) Geology and geologic hazards of Vancouver Region. Southwestern British Columbia, Geological Survey of Canada, pp 181–192

  • Cox SE, Khale SC (1999) Hydrogeology, ground-water quality, and sources of nitrate in Lowland glacial aquifers of Whatcom County, Washington, and British Columbia, Canada. In: US Geological Survey Water-Resources Investigations Report, US Geological Survey

  • Deshpande A (2004) Data interoperability across borders: a case study of the Abbotsford–Sumas aquifer (BC/ Washington State). MSc, Department of Geography, Simon Fraser University, Burnaby, p 137

  • Easterbrook DJ (1969) Pleistocene chronology of the Puget Lowland and San Juan Islands, Washington. Geol Soc Am Bull 80:2273–2286

    Article  Google Scholar 

  • Easterbook DJ (1976) Geologic map of western Whatcom County, Washington. United States Geological Survey Miscellaneous Investigations Series, Map I-854-B, 1:62500

  • ESRI (2004) ArcGIS 8.13 user manual and documentation. Environmental Systems Research Institute (ESRI)

  • Fonseca FT, Egenhofer M J, Davis Jr CA, Borges KAV (2000) Ontologies and knowledge sharing in urban GIS. Comput Environ Urban Syst 24:251–271

    Article  Google Scholar 

  • Gibbons TD, Culhane T (1994) Basin study of Johnson Creek, Whatcom County hydraulic continuity investigations. In: Part 2, open file technical report OFTR 94–01. Washington State Department of Ecology, USA

  • Golder Associates Inc (1995) Blaine ground water management program. Golder Associates, Canada

  • Halstead EC (1986) Ground water supply—Fraser Lowland, British Columbia. In: NHRI Paper No.26, IWD Scientific Series No.145. National Hydrology Research Institute, Saskatoon

  • Kashyap V, Sheth A (1996) Semantic and schematic similarities between database objects: a context-based approach. VLDB J 5:276–304

    Article  Google Scholar 

  • Jones MA (1999) Geologic framework for the Puget sound aquifer system, Washington State and British Columbia. Professional paper 1424–C, US Geological Survey, Reston, Virginia

  • Kahle SC (1991) Hydrostratigraphy and groundwater flow in the Sumas Area, Whatcom County, Washington. MSc Western Washington University, Bellingham

  • Kim W, Seo J (1991) Classifying schematic and data heterogeneities in multidatabase systems. IEEE 24(12):12–18

    Google Scholar 

  • Kohut AP (1987) Groundwater supply capability Abbotsford Upland. BC Ministry of Environment and Parks, Water Management Branch, Victoria

  • Kottam CA (1999) The open GIS consortium and progress towards interoperability in GIS. In: Egenhofer M, Goodchild M, Fegeas R, Kottam C (eds) Interoperating geographic information systems. Kluwer Academic, Boston, pp 39–54

  • LeRoy LW (ed) (1955) Subsurface geologic methods, 2nd edn. Colorado School of Mines, Golden, p 1156

  • Mitchell R, Babcock S, Stasney D, Nanus L, Gelinas S, Boeser S, Matthews R, Vandersypen J (2000) Abbotsford–Sumas aquifer monitoring project, final report. Geology Department, Western Washington University

  • Piteau & Associates (1991) Hydrogeological assessment of Aldergrove aquifer, Aldergrove, BC. Report for the Corporation of the Township of Langley

  • Piteau & Associates (2002) 2001 annual water quality monitoring report, Jackman sanitary landfill, WMB Permit No PR-1841. Township of Langley File 4720–L01

  • Ricketts BD (1999) The Fraser Lowland hydrogeology project: an overview. open file D3828. Geological Survey of Canada, Vancouver

  • Ricketts BD, Jackson LE Jr (1994) An overview of the Vancouver–Fraser valley hydrogeology project, Southern British Columbia. Cordilleran and Pacific margin—current research. Geological Survey of Canada, Vancour, pp 201–206

  • Ricketts BD, Liebscher H (1994) The geological framework of groundwater in the Greater Vancouver area. In: Monger JWH (ed) Geology and geological hazards of the Vancouver region, Southwestern British Columbia. Geol Surv Canada Bull 481:287–298

  • Russell HAJ, Brennand TA, Logan C, Sharpe DR (1998) Standardization and assessment of geological descriptions from water well records: Greater Toronto and Oak Ridges Moraine Areas, Southern Ontario. Current Research 1998–E. Geological Survey of Canada, Ottawa

  • Schuurman N (2002) Flexible standardization: making interoperability accessible to agencies with limited resources. Cartogr Geogr Inf Sci 29(4):343–353

    Article  Google Scholar 

  • Scibek J, Allen DM (2006) Comparing the responses of two high permeability, unconfined aquifers to predicted climate change. Glob Planet Change 50:50–62

    Article  Google Scholar 

  • Scibek J, Allen DM (2005) Numerical groundwater flow model of the Abbotsford–Sumas aquifer, Central Fraser Lowland of BC, Canada, and Washington State, US. Report prepared for Environment Canada, Vancouver, p 203

  • Sheth A, Larson JA (1990) Federated database systems for managing distributed, heterogeneous, and autonomous databases. ACM Comput Surv 22(3):183–236

    Article  Google Scholar 

  • Stock K, Pullar D (1999) Identifying semantically similar elements in heterogeneous spatial databases using predicate logic. In: Vckovski A, Brassel K, Schek H (eds) Interoperating geographic information systems, second international conference, INTEROP’99 Zurich, Switzerland, 1999. Springer, Heidelberg, pp 231–252

    Google Scholar 

  • Tearpock DJ, Bischke RE (2002) Applied subsurface geological mapping with stuctural methods, 2nd edn. Prentice Hall, NJ, p 822

    Google Scholar 

  • Tooley J, Erickson D (1996) Nooksack watershed surficial aquifer characterization. Washington State Department of Ecology, Ecology Report, pp 96–311

  • Vckovski A (1998) Special issue: interoperability in GIS (Guest Editorial). Int J Geogr Inf Sci 12(4):297–298

    Article  Google Scholar 

  • Vckovski A (1999) Interoperability and spatial information theory. In: Egenhofer M, Goodchild M, Fegeas R, Kottman C (eds) Interoperating geographic information systems. Kluwer Academic, Boston, pp 31–37

    Google Scholar 

  • Visser U, Stuckenschmidt H, Schuster G, Vogele T (2002) Ontologies for geographic information processing. Comput Geosci 28:103–117

    Article  Google Scholar 

  • Walker JD, Cohen HA (2006) Geoscience handbook: AGI data sheets, 4th edn. American Geological Institute, p 310

  • Waterloo Hydrogeologic Inc (2000) Visual MODFLOW v 3.0: user manual. Waterloo Hydrogeologic Inc, Waterloo

Download references

Author information

Authors and Affiliations

  1. Department of Earth Sciences, Simon Fraser University Burnaby, British Columbia, Canada, V5A 1S6

    Diana M. Allen & Jacek Scibek

  2. Department of Geography, Simon Fraser University Burnaby, British Columbia, Canada, V5A 1S6

    Nadine Schuurman & Aparna Deshpande

Authors
  1. Diana M. Allen
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Nadine Schuurman
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Aparna Deshpande
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Jacek Scibek
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Diana M. Allen.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Allen, D.M., Schuurman, N., Deshpande, A. et al. Data integration and standardization in cross-border hydrogeological studies: a novel approach to hydrostratigraphic model development. Environ Geol 53, 1441–1453 (2008). https://doi.org/10.1007/s00254-007-0753-3

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s00254-007-0753-3

Keywords

Search

Navigation