{"id":108,"date":"2022-07-14T16:37:49","date_gmt":"2022-07-14T16:37:49","guid":{"rendered":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/?post_type=part&p=108"},"modified":"2022-07-15T03:17:58","modified_gmt":"2022-07-15T03:17:58","slug":"availability-of-well-record-databases","status":"publish","type":"part","link":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/part\/availability-of-well-record-databases\/","title":{"raw":"4 Availability of Well Record Databases","rendered":"4 Availability of Well Record Databases"},"content":{"raw":"
\r\n

Given that the requirement for well contractors to submit well construction reports has been standard practice in many countries now for decades, and about 45 percent of the world\u2019s population resides in rural areas (United Nations, 2019) where domestic wells are the preferred water supply source, it is estimated that there could be up to 100-million water well records archived worldwide. Access to water well records, however, is highly variable, ranging from hard copy reports that were filed or scanned, to digital data that can be readily shared over the internet. About 39 million digital, water well records were compiled from 40 countries or territories in a global study of the sensitivity of groundwater wells to water level declines over the period of 1950 to 2015 (Figure 4; Jasechko and Perrone, 2021). In some countries, national level well record datasets are available (Table 2) while in other countries the data is published by subnational governments.<\/p>\r\n

\"Map<\/p>\r\n

Figure <\/strong>4<\/strong> -<\/strong> Compiled water well records for a study of the sensitivity of groundwater wells to water level declines from 1950 to 2015. Only partial data coverages were available for the United States, Argentina, Bolivia and Germany (after Jasechko and Perrone, 2021).<\/p>\r\n

<\/a>Table<\/strong> 2<\/strong> -<\/strong> Selected water well databases that provide publicly available, digital, harmonized (i.e., disparate file formats brought into one cohesive data set) or country-scale views of water well data.<\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Country<\/strong><\/td>\r\nData Source<\/strong><\/td>\r\n<\/tr>\r\n
Tanzania, Malawi, Mozambique, Zimbabwe, Botswana, South Africa, Lesotho, Swaziland, Namibia, Madagascar<\/td>\r\nSouthern African Development Community (SADC) Groundwater Information Portal<\/a><\/td>\r\n<\/tr>\r\n
Australia<\/td>\r\nNational Groundwater Information System<\/a><\/td>\r\n<\/tr>\r\n
Brazil<\/td>\r\nSIAGAS Groundwater Information System<\/a><\/td>\r\n<\/tr>\r\n
Cambodia<\/td>\r\nThe Online Well Database of Cambodia<\/a><\/td>\r\n<\/tr>\r\n
Canada<\/td>\r\nGroundwater Information Network (GIN)<\/a><\/td>\r\n<\/tr>\r\n
Denmark<\/td>\r\nNational Well Database (JUPITER)<\/a><\/td>\r\n<\/tr>\r\n
Germany<\/td>\r\nBorehole Map of Germany<\/a><\/td>\r\n<\/tr>\r\n
Norway<\/td>\r\nNational Groundwater Database (GRANADA)<\/a><\/td>\r\n<\/tr>\r\n
Spain<\/td>\r\nInstitute of Mining and Geology of Spain \u2013 Water Points Database<\/a><\/td>\r\n<\/tr>\r\n
United Kingdom<\/td>\r\nGeoIndex Onshore \u2013 Water Wells<\/a><\/td>\r\n<\/tr>\r\n
Uruguay<\/td>\r\nMining Geological Viewer \u2013 Well Data<\/a><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n

Over the past several decades, many jurisdictions around the world have moved to an open data, internet distribution model for well record databases, where well record data is freely available and offered for download in multiple formats (e.g., database, text, web map service, EsriTM<\/sup> shapefile\/geodatabase, Google EarthTM<\/sup> data files). Although the availability of online well record information is growing quickly, privacy concerns in some jurisdictions continue to restrict opportunities for open sharing of this information.<\/p>\r\n

The inter-operability of these datasets, however, is limited, which can be an important consideration for the overall hydrogeological assessment of a management area, especially one that crosses political borders. Challenges with respect to the discovery of, and access to, harmonized datasets are largely related to the distributed custodianship (e.g., subnational) and heterogeneity of well record information (Brodaric et al., 2018). Approaches to resolve these challenges include standardizing the terminology of hydrogeologic data recorded on well logs at a national level (e.g., Australia\u2019s National Aquifer Framework<\/span><\/a>) or the translation of well record data from different data providers into a common language (e.g., Borehole Map of Germany<\/span><\/a> or Canada\u2019s Groundwater Information Network<\/span><\/a>). More information about Canada\u2019s approach to harmonizing data from various sources is provided in <\/a>Box <\/span><\/a>2<\/span><\/a>. The Southern African Development Community (SADC) Groundwater Management Institute (GMI) commissioned the development of a Groundwater Information Portal<\/span><\/a>\u2014developed and maintained by the International Groundwater Resources Assessment Centre\u2014for accessing harmonized groundwater information in southern African countries, including water well records (Figure 5).<\/p>\r\n

\"Screenshot<\/p>\r\n

Figure <\/strong>5<\/strong> -<\/strong> Screenshot of the SADC Groundwater Information Portal showing the location of borehole records for various southern African countries.<\/p>\r\n

These new models of data distribution have also permitted the development of new tools and widgets for the visualization and analysis of well record data, including the dynamic generation of graphic logs of well completion and stratigraphy information (Figure 6).<\/p>\r\n

\"Screenshot<\/p>\r\n

Figure <\/strong>6<\/strong> -<\/strong> Screenshot of the tool for visualizing well record stratigraphy information as part of Canada\u2019s Geographic Information Network (GIN, 2020). Data for the selected record is from the Alberta Ministry of Environment and Parks, provided by GIN.<\/p>\r\n\r\n<\/div>","rendered":"

\n

Given that the requirement for well contractors to submit well construction reports has been standard practice in many countries now for decades, and about 45 percent of the world\u2019s population resides in rural areas (United Nations, 2019) where domestic wells are the preferred water supply source, it is estimated that there could be up to 100-million water well records archived worldwide. Access to water well records, however, is highly variable, ranging from hard copy reports that were filed or scanned, to digital data that can be readily shared over the internet. About 39 million digital, water well records were compiled from 40 countries or territories in a global study of the sensitivity of groundwater wells to water level declines over the period of 1950 to 2015 (Figure 4; Jasechko and Perrone, 2021). In some countries, national level well record datasets are available (Table 2) while in other countries the data is published by subnational governments.<\/p>\n

\"Map<\/p>\n

Figure <\/strong>4<\/strong> –<\/strong> Compiled water well records for a study of the sensitivity of groundwater wells to water level declines from 1950 to 2015. Only partial data coverages were available for the United States, Argentina, Bolivia and Germany (after Jasechko and Perrone, 2021).<\/p>\n

<\/a>Table<\/strong> 2<\/strong> –<\/strong> Selected water well databases that provide publicly available, digital, harmonized (i.e., disparate file formats brought into one cohesive data set) or country-scale views of water well data.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Country<\/strong><\/td>\nData Source<\/strong><\/td>\n<\/tr>\n
Tanzania, Malawi, Mozambique, Zimbabwe, Botswana, South Africa, Lesotho, Swaziland, Namibia, Madagascar<\/td>\nSouthern African Development Community (SADC) Groundwater Information Portal<\/a><\/td>\n<\/tr>\n
Australia<\/td>\nNational Groundwater Information System<\/a><\/td>\n<\/tr>\n
Brazil<\/td>\nSIAGAS Groundwater Information System<\/a><\/td>\n<\/tr>\n
Cambodia<\/td>\nThe Online Well Database of Cambodia<\/a><\/td>\n<\/tr>\n
Canada<\/td>\nGroundwater Information Network (GIN)<\/a><\/td>\n<\/tr>\n
Denmark<\/td>\nNational Well Database (JUPITER)<\/a><\/td>\n<\/tr>\n
Germany<\/td>\nBorehole Map of Germany<\/a><\/td>\n<\/tr>\n
Norway<\/td>\nNational Groundwater Database (GRANADA)<\/a><\/td>\n<\/tr>\n
Spain<\/td>\nInstitute of Mining and Geology of Spain \u2013 Water Points Database<\/a><\/td>\n<\/tr>\n
United Kingdom<\/td>\nGeoIndex Onshore \u2013 Water Wells<\/a><\/td>\n<\/tr>\n
Uruguay<\/td>\nMining Geological Viewer \u2013 Well Data<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Over the past several decades, many jurisdictions around the world have moved to an open data, internet distribution model for well record databases, where well record data is freely available and offered for download in multiple formats (e.g., database, text, web map service, EsriTM<\/sup> shapefile\/geodatabase, Google EarthTM<\/sup> data files). Although the availability of online well record information is growing quickly, privacy concerns in some jurisdictions continue to restrict opportunities for open sharing of this information.<\/p>\n

The inter-operability of these datasets, however, is limited, which can be an important consideration for the overall hydrogeological assessment of a management area, especially one that crosses political borders. Challenges with respect to the discovery of, and access to, harmonized datasets are largely related to the distributed custodianship (e.g., subnational) and heterogeneity of well record information (Brodaric et al., 2018). Approaches to resolve these challenges include standardizing the terminology of hydrogeologic data recorded on well logs at a national level (e.g., Australia\u2019s National Aquifer Framework<\/span><\/a>) or the translation of well record data from different data providers into a common language (e.g., Borehole Map of Germany<\/span><\/a> or Canada\u2019s Groundwater Information Network<\/span><\/a>). More information about Canada\u2019s approach to harmonizing data from various sources is provided in <\/a>Box <\/span><\/a>2<\/span><\/a>. The Southern African Development Community (SADC) Groundwater Management Institute (GMI) commissioned the development of a Groundwater Information Portal<\/span><\/a>\u2014developed and maintained by the International Groundwater Resources Assessment Centre\u2014for accessing harmonized groundwater information in southern African countries, including water well records (Figure 5).<\/p>\n

\"Screenshot<\/p>\n

Figure <\/strong>5<\/strong> –<\/strong> Screenshot of the SADC Groundwater Information Portal showing the location of borehole records for various southern African countries.<\/p>\n

These new models of data distribution have also permitted the development of new tools and widgets for the visualization and analysis of well record data, including the dynamic generation of graphic logs of well completion and stratigraphy information (Figure 6).<\/p>\n

\"Screenshot<\/p>\n

Figure <\/strong>6<\/strong> –<\/strong> Screenshot of the tool for visualizing well record stratigraphy information as part of Canada\u2019s Geographic Information Network (GIN, 2020). Data for the selected record is from the Alberta Ministry of Environment and Parks, provided by GIN.<\/p>\n<\/div>\n","protected":false},"parent":0,"menu_order":4,"template":"","meta":{"pb_part_invisible":false,"pb_part_invisible_string":""},"contributor":[],"license":[],"class_list":["post-108","part","type-part","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/wp-json\/pressbooks\/v2\/parts\/108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/wp-json\/pressbooks\/v2\/parts"}],"about":[{"href":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/wp-json\/wp\/v2\/types\/part"}],"version-history":[{"count":8,"href":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/wp-json\/pressbooks\/v2\/parts\/108\/revisions"}],"predecessor-version":[{"id":227,"href":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/wp-json\/pressbooks\/v2\/parts\/108\/revisions\/227"}],"wp:attachment":[{"href":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/wp-json\/wp\/v2\/media?parent=108"}],"wp:term":[{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/wp-json\/wp\/v2\/contributor?post=108"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/wp-json\/wp\/v2\/license?post=108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}