{"id":122,"date":"2022-07-14T16:40:45","date_gmt":"2022-07-14T16:40:45","guid":{"rendered":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/?post_type=part&p=122"},"modified":"2022-07-15T03:20:36","modified_gmt":"2022-07-15T03:20:36","slug":"best-practices-for-water-well-record-management","status":"publish","type":"part","link":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/part\/best-practices-for-water-well-record-management\/","title":{"raw":"7 Best Practices for Water Well Record Management","rendered":"7 Best Practices for Water Well Record Management"},"content":{"raw":"
\r\n

Following best management practices for managing well records directly contributes to the advancement of safe drinking water and the protection of groundwater resources. The collection of good quality well record data can also have ancillary benefits, such as the use of this data as a research tool for understanding opportunities, hazards and threats to aquifers. While there is no universally accepted standard, the previous section on the shortcomings of well record databases is useful in formulating an idealized scenario for well record data management. Four overarching objectives, and associated recommended system components for achieving these objectives, are outlined in Table 3.<\/p>\r\n

Table <\/strong>3<\/strong> -<\/strong> Key objectives for well record management to support drinking water and groundwater management program goals and recommended system components to achieve the objectives.<\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Objective<\/strong><\/td>\r\nRecommended System Component<\/strong><\/td>\r\n<\/tr>\r\n
Water well record data is effectively captured<\/strong><\/td>\r\n\r\n

\u2022 Mandatory submission of well record data to a centralized authority by water well contractors as a legislated requirement<\/p>\r\n

\u2022 Well records are required for all types of water wells (e.g., public, domestic, agricultural, industrial)<\/p>\r\n

\u2022 Regulatory tools and resources are used to ensure compliance with mandatory well record submission requirements, including outreach, training, inspection and enforcement activities<\/p>\r\n<\/td>\r\n<\/tr>\r\n

High quality, useful, accurate information is captured in water well record forms and databases<\/strong><\/td>\r\n\r\n

\u2022 Well record forms are designed to achieve compromise between the amount of data collected by well contractors and the utility\/importance of these data (e.g., emphasis should be on critical well construction information and especially useful data such as accurate water level measurements and yield estimates)<\/p>\r\n

\u2022 Submitted well record data is complete (i.e., all fields have been filled out)<\/p>\r\n

\u2022 Well locations are recorded in the field using GPS or equivalent<\/p>\r\n

\u2022 Unique well identifier label is physically affixed to each water well and is referenced to the well record<\/p>\r\n

\u2022 Minimum standards are established for geological training for water well contractors so that they are collecting reasonably good quality water level and yield information and so that lithological descriptions are useful for geological interpretation<\/p>\r\n

\u2022 Where applicable, well screen details (e.g., screen depth) are adequately captured on the well record so that the aquifer(s) supplying the water well can be identified and related to the well information<\/p>\r\n

\u2022 Field measurement of simple water quality parameters are recorded, such as electrical conductivity<\/a><\/p>\r\n

\u2022 Pump installation details are recorded (could be separate form) and related to the well record<\/p>\r\n

\u2022 Consistent standards are established for geological nomenclature for use by water well contractors at regional scales, and preferably a unified nomenclature adopted at national and even international scales<\/p>\r\n

\u2022 Rigorous quality-assurance\/quality-control review of submitted well records is conducted to ensure high quality data is captured in well record databases<\/p>\r\n

\u2022 Following a change in status of a water well (e.g., decommissioning, modification), the updated status is related to the original record so that current well status information can be accessed<\/p>\r\n<\/td>\r\n<\/tr>\r\n

Water well record publication is timely<\/strong><\/td>\r\n\r\n

\u2022 The data management system allows for online submission of well record forms, including user-friendly phone applications, to reduce labor intensive manual well record data entry and to improve timeliness of well record submission by contractors<\/p>\r\n

\u2022 The system allows for the timely review and publication of a well record following water well construction and the submission of the associated record (e.g., days to months)<\/p>\r\n<\/td>\r\n<\/tr>\r\n

Water well record data is findable and accessible in various formats<\/strong><\/td>\r\n\r\n

\u2022 Well record data is easily found on the internet and is publicly available<\/p>\r\n

\u2022 Well record data is distributed in various open file formats, including printable reports for well owner's records<\/p>\r\n

\u2022 Various options are available for searching of well records, including a map interface<\/p>\r\n

\u2022 Graphical viewers or widgets are available to enhance the communication of well record information<\/p>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n

A regulatory framework for the mandatory submission of well records is the most critical component of a successful well record management system. Where the regulatory framework is absent or inadequate, it can require a significant level of effort to create new legislation. For any jurisdiction looking to strengthen the regulatory framework, or make other improvements to well record management systems, it is important to provide evidence-based linkages between well record best management practices and the goals of drinking water and groundwater management programs, such as drinking water safety and groundwater protection.<\/p>\r\n

Barriers to achieving the four key objectives presented in Table 3 are often related to resource constraints. For example, auditing and enforcement of well construction activities in relation to the completion of good quality well records may consume significant resources, especially if compliance mechanisms are not easy to implement. Data entry and review processes can also be extremely resource intensive, depending on the design of the data collection system. The design and implementation of an efficient system for the collection, review, and publication of well record data, however, usually requires the adoption of an advanced data management solution, with suitable information technology infrastructure. These types of solutions can be expensive to acquire, implement and maintain, although over the long-term they offer cost efficiencies and improved data quality. They also offer significant opportunities for automated data validation, standardization (e.g., online drop-down lists to constrain geological descriptions to standard nomenclature), and analytics. An idealized information flow of well record data is presented in Figure 8.<\/p>\r\n

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

Figure <\/strong>8<\/strong> -<\/strong> Ideal information flow for well records from data collection in the field to publication over the internet.<\/p>\r\n

Another barrier to achieving some of the objectives outlined in Table 3 includes the requirement for the development of standards and training for well contractors and data managers. Training programs can help achieve minimum standards for identifying lithological types and improve the quality of the data contained in well record databases. Recognizing that water well contractors are not geoscientists, a compromise is required to ensure that well record data is high quality and supports drinking water and groundwater management program goals without causing undue burden on water well contractors. There is no international standard available, and in most cases standards and training programs related to well record management must be developed by local governments administering the program, where resources can be limited. Groundwater associations (e.g., the National Groundwater Association in the United States) can have an important role in working with governments to develop and deliver consistent training standards.<\/p>\r\n

A productive working relationship between government\/regulatory bodies and water well contractors (often represented by an industry association) is an important aspect of the success of any well record management system, as it requires cooperation and investment from both parties. Where the quality of well record data is limited by the capacity of well contractors to purchase critical equipment, such as water level, flow or specific conductance meters, government support (e.g., subsidies) can be impactful. For example, the Province of Nova Scotia provided GPS units to all well drillers in 2004 to improve the spatial referencing of well record data. The Nova Scotia Well Logs Database now contains GPS locations for about 20 percent of all well records in the database.<\/p>\r\n

Although the recommended best management practices are difficult for most jurisdictions to implement, they may be useful in providing a road map for incremental improvement. For jurisdictions that would like to start collecting well records but have limited capacity, the most important elements of a well record management program is the collection and digitization of a well record form (ideally under a mandatory regulatory framework), completed in the field by a well construction contractor, recording basic information about the water well, including a unique well identifier, the location, the driller, the owner, the depth and the static water level. To build long-term support for the collection of this data, it is critical that the database is made publicly available in a searchable digital format (e.g., simple database or spreadsheet and ideally on maps) so that it may be used by a diverse range of clients.<\/p>\r\n\r\n<\/div>","rendered":"

\n

Following best management practices for managing well records directly contributes to the advancement of safe drinking water and the protection of groundwater resources. The collection of good quality well record data can also have ancillary benefits, such as the use of this data as a research tool for understanding opportunities, hazards and threats to aquifers. While there is no universally accepted standard, the previous section on the shortcomings of well record databases is useful in formulating an idealized scenario for well record data management. Four overarching objectives, and associated recommended system components for achieving these objectives, are outlined in Table 3.<\/p>\n

Table <\/strong>3<\/strong> –<\/strong> Key objectives for well record management to support drinking water and groundwater management program goals and recommended system components to achieve the objectives.<\/p>\n\n\n\n\n\n\n\n
Objective<\/strong><\/td>\nRecommended System Component<\/strong><\/td>\n<\/tr>\n
Water well record data is effectively captured<\/strong><\/td>\n\n

\u2022 Mandatory submission of well record data to a centralized authority by water well contractors as a legislated requirement<\/p>\n

\u2022 Well records are required for all types of water wells (e.g., public, domestic, agricultural, industrial)<\/p>\n

\u2022 Regulatory tools and resources are used to ensure compliance with mandatory well record submission requirements, including outreach, training, inspection and enforcement activities<\/p>\n<\/td>\n<\/tr>\n

High quality, useful, accurate information is captured in water well record forms and databases<\/strong><\/td>\n\n

\u2022 Well record forms are designed to achieve compromise between the amount of data collected by well contractors and the utility\/importance of these data (e.g., emphasis should be on critical well construction information and especially useful data such as accurate water level measurements and yield estimates)<\/p>\n

\u2022 Submitted well record data is complete (i.e., all fields have been filled out)<\/p>\n

\u2022 Well locations are recorded in the field using GPS or equivalent<\/p>\n

\u2022 Unique well identifier label is physically affixed to each water well and is referenced to the well record<\/p>\n

\u2022 Minimum standards are established for geological training for water well contractors so that they are collecting reasonably good quality water level and yield information and so that lithological descriptions are useful for geological interpretation<\/p>\n

\u2022 Where applicable, well screen details (e.g., screen depth) are adequately captured on the well record so that the aquifer(s) supplying the water well can be identified and related to the well information<\/p>\n

\u2022 Field measurement of simple water quality parameters are recorded, such as electrical conductivity<\/a><\/p>\n

\u2022 Pump installation details are recorded (could be separate form) and related to the well record<\/p>\n

\u2022 Consistent standards are established for geological nomenclature for use by water well contractors at regional scales, and preferably a unified nomenclature adopted at national and even international scales<\/p>\n

\u2022 Rigorous quality-assurance\/quality-control review of submitted well records is conducted to ensure high quality data is captured in well record databases<\/p>\n

\u2022 Following a change in status of a water well (e.g., decommissioning, modification), the updated status is related to the original record so that current well status information can be accessed<\/p>\n<\/td>\n<\/tr>\n

Water well record publication is timely<\/strong><\/td>\n\n

\u2022 The data management system allows for online submission of well record forms, including user-friendly phone applications, to reduce labor intensive manual well record data entry and to improve timeliness of well record submission by contractors<\/p>\n

\u2022 The system allows for the timely review and publication of a well record following water well construction and the submission of the associated record (e.g., days to months)<\/p>\n<\/td>\n<\/tr>\n

Water well record data is findable and accessible in various formats<\/strong><\/td>\n\n

\u2022 Well record data is easily found on the internet and is publicly available<\/p>\n

\u2022 Well record data is distributed in various open file formats, including printable reports for well owner’s records<\/p>\n

\u2022 Various options are available for searching of well records, including a map interface<\/p>\n

\u2022 Graphical viewers or widgets are available to enhance the communication of well record information<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

A regulatory framework for the mandatory submission of well records is the most critical component of a successful well record management system. Where the regulatory framework is absent or inadequate, it can require a significant level of effort to create new legislation. For any jurisdiction looking to strengthen the regulatory framework, or make other improvements to well record management systems, it is important to provide evidence-based linkages between well record best management practices and the goals of drinking water and groundwater management programs, such as drinking water safety and groundwater protection.<\/p>\n

Barriers to achieving the four key objectives presented in Table 3 are often related to resource constraints. For example, auditing and enforcement of well construction activities in relation to the completion of good quality well records may consume significant resources, especially if compliance mechanisms are not easy to implement. Data entry and review processes can also be extremely resource intensive, depending on the design of the data collection system. The design and implementation of an efficient system for the collection, review, and publication of well record data, however, usually requires the adoption of an advanced data management solution, with suitable information technology infrastructure. These types of solutions can be expensive to acquire, implement and maintain, although over the long-term they offer cost efficiencies and improved data quality. They also offer significant opportunities for automated data validation, standardization (e.g., online drop-down lists to constrain geological descriptions to standard nomenclature), and analytics. An idealized information flow of well record data is presented in Figure 8.<\/p>\n

\"Figure<\/p>\n

Figure <\/strong>8<\/strong> –<\/strong> Ideal information flow for well records from data collection in the field to publication over the internet.<\/p>\n

Another barrier to achieving some of the objectives outlined in Table 3 includes the requirement for the development of standards and training for well contractors and data managers. Training programs can help achieve minimum standards for identifying lithological types and improve the quality of the data contained in well record databases. Recognizing that water well contractors are not geoscientists, a compromise is required to ensure that well record data is high quality and supports drinking water and groundwater management program goals without causing undue burden on water well contractors. There is no international standard available, and in most cases standards and training programs related to well record management must be developed by local governments administering the program, where resources can be limited. Groundwater associations (e.g., the National Groundwater Association in the United States) can have an important role in working with governments to develop and deliver consistent training standards.<\/p>\n

A productive working relationship between government\/regulatory bodies and water well contractors (often represented by an industry association) is an important aspect of the success of any well record management system, as it requires cooperation and investment from both parties. Where the quality of well record data is limited by the capacity of well contractors to purchase critical equipment, such as water level, flow or specific conductance meters, government support (e.g., subsidies) can be impactful. For example, the Province of Nova Scotia provided GPS units to all well drillers in 2004 to improve the spatial referencing of well record data. The Nova Scotia Well Logs Database now contains GPS locations for about 20 percent of all well records in the database.<\/p>\n

Although the recommended best management practices are difficult for most jurisdictions to implement, they may be useful in providing a road map for incremental improvement. For jurisdictions that would like to start collecting well records but have limited capacity, the most important elements of a well record management program is the collection and digitization of a well record form (ideally under a mandatory regulatory framework), completed in the field by a well construction contractor, recording basic information about the water well, including a unique well identifier, the location, the driller, the owner, the depth and the static water level. To build long-term support for the collection of this data, it is critical that the database is made publicly available in a searchable digital format (e.g., simple database or spreadsheet and ideally on maps) so that it may be used by a diverse range of clients.<\/p>\n<\/div>\n","protected":false},"parent":0,"menu_order":7,"template":"","meta":{"pb_part_invisible":false,"pb_part_invisible_string":""},"contributor":[],"license":[],"class_list":["post-122","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\/122","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":11,"href":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/wp-json\/pressbooks\/v2\/parts\/122\/revisions"}],"predecessor-version":[{"id":280,"href":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/wp-json\/pressbooks\/v2\/parts\/122\/revisions\/280"}],"wp:attachment":[{"href":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/wp-json\/wp\/v2\/media?parent=122"}],"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=122"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/books.gw-project.org\/water-well-record-databases-and-their-uses\/wp-json\/wp\/v2\/license?post=122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}