Danish Water Supply Areas and their links to water production facilities: an open-access data set

Authors

  • Jörg Schullehner Geological Survey of Denmark and Greenland, Aarhus, Denmark. Department of Public Health, Environment, Occupation and Health, Aarhus University, Aarhus, Denmark. Danish Big Data Centre for Environment and Health (BERTHA), Aarhus University, Aarhus, Denmark. https://orcid.org/0000-0002-1153-6885

DOI:

https://doi.org/10.34194/geusb.v49.8319

Keywords:

drinking water, monitoring, exposure assessment, epidemiology, Denmark

Abstract

This data set establishes the missing link between drinking-water quality monitoring data at the water production facility level in the Danish national geodatabase Jupiter and supply areas. Water Supply Areas (WSAs) were collected at municipality level, digitised and linked to the waterworks they are supplied by. Infrastructural changes between 1978 and 2019 were taken into account by allowing WSA polygons to change over time. The number of active WSAs decreased from 3172 in 1978 to 2602 in 2019. The data set consists of longitudinal WSA polygons and a table linking WSAs to the water production facility identification in the Jupiter database, allowing the estimation of current and historical drinking-water quality across Denmark. In combination with the Danish Address Register and the Civil Registration System, this data set allows exposure assessments of drinking-water quality at high spatiotemporal resolution for the entire Danish population. Therefore, this data set is an essential part of studying health effects of drinking-water quality in epidemiological research in Denmark.

Downloads

Download data is not yet available.

References

CIRRAU. 2022: Data documentation – geocodes. https://cirrau.au.dk/data-resources/data-documentation (accessed April 2022)

Coffman, V.R. et al. 2021: Prenatal exposure to nitrate from drinking water and markers of fetal growth restriction: a population-based study of nearly one million Danish-born children. Environmental Health Perspectives 129 (2), 027002. https://doi.org/10.1289/EHP7331

Ebdrup, N.H. et al. 2022: Nitrate in drinking water and time to pregnancy or medically assisted reproduction in women and men: a nationwide cohort study in the Danish national birth cohort. Clinical Epidemiology 14, 475–487. https://doi.org/10.2147/CLEP.S354926

ESRI. 2015: ArcGIS 10.4. Redlands, CA. Environmental Systems Research Institute, Inc. https://www.esri.com

European Council. 1998: Council Directive 98/83/EC of 3 November 1998 on the quality of water intended for human consumption. https://eur-lex.europa.eu/legal-content/EN/ALL/?uri=CELEX%3A31998L0083 (accessed May 2022)

GEUS. 2022: National boringsdatabase (Jupiter). Geological Survey of Denmark and Greenland. https://www.geus.dk/produkter-ydelser-og-faciliteter/data-og-kort/national-boringsdatabase-jupiter (accessed May 2022)

Hansen, M. & Pjetursson, B. 2011: Free, online Danish shallow geological data. Geological Survey of Denmark and Greenland Bulletin 23, 53–56. https://doi.org/10.34194/geusb.v23.4842

Ministry of Environment of Denmark. 2021: Bekendtgørelse om vandkvalitet og tilsyn med vandforsyningsanlæg, BEK nr 2361 af 26/11/2021 (Drikkevandsbekendtgørelsen).

Ministry of Environment of Denmark. 2022: Drikkevand. https://mst.dk/natur-vand/vand-i-hverdagen/drikkevand (accessed April 2022)

QGIS.org. 2022: QGIS Geographical Information System. QGIS Association. http://www.qgis.org

Ramsay, L., Petersen, M.M., Hansen, B., Schullehner, J., van der Wens, P., Voutchkova, D. & Kristiansen, S.M. 2021: Drinking water criteria for arsenic in high-income, low-dose countries: the effect of legislation on public health. Environmental Science & Technology 55, 3483–3493. https://doi.org/10.1021/acs.est.0c03974

R Core Team. 2020: R: A language and environment for statistical computing. R Foundation for Statistical Computing, Vienna, Austria. https://www.R-project.org/

Richter F., Kloster, S., Wodschow, K., Hansen, B., Schullehner, J., Kristiansen, S.M., Petersen, M.M., Strandberg-Larsen, K. & Ersbøll, A.K. 2022: Maternal exposure to arsenic in drinking water and risk of congenital heart disease in the offspring. Environment International 160, 107051. https://doi.org/10.1016/j.envint.2021.107051

Schullehner, J. & Hansen, B. 2014: Nitrate exposure from drinking water in Denmark over the last 35 years. Environmental Research Letters 9, 095001, 9 pp. https://doi.org/10.1088/1748-9326/9/9/095001

Schullehner, J., Hansen, B., Thygesen, M., Pedersen, C.B. & Sigsgaard, T. 2018: Nitrate in drinking water and colorectal cancer risk: A nationwide population-based cohort study. International Journal of Cancer 143, 73–79. https://doi.org/10.1002/ijc.31306

Schullehner, J., Jensen, N.L., Thygesen, M., Hansen, B. & Sigsgaard, T. 2017: Drinking water nitrate estimation at household-level in Danish population-based long-term epidemiologic studies. Journal of Geochemical Exploration 183, 178–186. https://doi.org/10.1016/j.gexplo.2017.03.006

Schullehner, J., Paksarian, D., Hansen, B., Thygesen, M., Kristiansen, S.M., Dalsgaard, S., Sigsgaard, T. & Pedersen, C.B. 2019: Lithium in drinking water associated with adverse mental health effects. Schizophrenia Research 210, 313–315. https://doi.org/10.1016/j.schres.2019.06.016

Schullehner, J., Thygesen, M., Kristiansen, S.M., Hansen, B., Pedersen, C.B. & Dalsgaard, S. 2020: Exposure to manganese in drinking water during childhood and association with attention-deficit hyperactivity disorder: a nationwide cohort study. Environmental Health Perspectives 128(9), 097004. https://doi.org/10.1289/EHP6391

SDFE. 2022: The Danish Address Register. Agency for Data Supply and Efficiency. https://eng.sdfe.dk/products-and-services/the-danish-address-register (accessed May 2022)

Skaarup, C., Wodschow, K., Voutchkova, D.D., Schullehner, J., Raaschou-Nielsen, O., Andersen, H.R., Hansen, B. & Ersbøll, A.K. 2022: Geographical Distribution and pattern of pesticides in Danish drinking water 2002–2018: reducing data complexity. International Journal of Environmental Research and Public Health 19(2), 823. https://doi.org/10.3390/ijerph19020823

Stayner, L.T. et al. 2021: Exposure to nitrate from drinking water and the risk of childhood cancer in Denmark. Environment International 155, 106613. https://doi.org/10.1016/j.envint.2021.106613

Stayner, L.T. et al. 2022: Nitrate in drinking water and risk of birth defects: findings from a cohort study of over one million births in Denmark. The Lancet Regional Health – Europe 14. 100286. https://doi.org/10.1016/j.lanepe.2021.100286

Theisen, C.F., Wodschow, K., Hansen, B., Schullehner, J., Gislason, G., Ersbøll, B.K. & Ersbøll, A.K. 2022: Drinking water magnesium and cardiovascular mortality: a cohort study in Denmark, 2005–2016. Environment International 164, 107277. https://doi.org/10.1016/j.envint.2022.107277

Thomsen, A.M.L., Ramlau-Hansen, C.H., Schullehner, J., Ebdrup, N.H., Liew, Z., Coffman, V., Stayner, L., Hansen, B. & Olsen, J. 2021: Prenatal nitrosatable prescription drug intake, drinking water nitrate, and the risk of stillbirth: a register- and population-based cohort of Danish pregnancies, 1997–2017. Environmental Health 20, 118. https://doi.org/10.1186/s12940-021-00805-z

Thygesen, L.C., Daasnes, C., Thaulow, I. & Bronnum-Hansen, H. 2011: Introduction to Danish (nationwide) registers on health and social issues: Structure, access, legislation, and archiving. Scandinavian Journal of Public Health 39, 12–16. https://doi.org/10.1177/1403494811399956

Thygesen, M., Schullehner, J., Hansen, B., Sigsgaard, T., Voutchkova, D.D., Kristiansen, S.M., Pedersen, C.B. & Dalsgaard, S. 2021: Trace elements in drinking water and the incidence of attention-deficit hyperactivity disorder. Journal of Trace Elements in Medicine and Biology 68, 126828. https://doi.org/10.1016/j.jtemb.2021.126828

Voutchkova, D., Schullehner, J., Knudsen, N., Jørgensen, L., Ersbøll, A., Kristiansen, S. & Hansen, B. 2015: Exposure to selected geogenic trace elements (I, Li, and Sr) from drinking water in Denmark. Geosciences 5, 45–66. https://doi.org/10.3390/geosciences5010045

Voutchkova, D.D., Schullehner, J., Skaarup, C., Wodschow, K., Ersbøll, A.K. & Hansen, B. 2021: Estimating pesticides in public drinking water at the household level in Denmark. GEUS Bulletin 47, 6090. https://doi.org/10.34194/geusb.v47.6090

Wodschow, K., Hansen, B., Schullehner, J. & Ersbøll, A.K. 2018: Stability of major geogenic cations in drinking water-an issue of public health importance: a Danish study, 1980-2017. International Journal of Environmental Research and Public Health 15(9), 1212. https://doi.org/10.3390/ijerph15061212

Wodschow, K., Villanueva, C.M., Larsen, M.L., Gislason, G., Schullehner, J., Hansen, B. & Ersbøll, A.K. 2021: Association between magnesium in drinking water and atrial fibrillation incidence: a nationwide population-based cohort study, 2002–2015. Environmental Health 20, 126. https://doi.org/10.1186/s12940-021-00813-z

Published

28-06-2022

How to Cite

Schullehner, J. (2022). Danish Water Supply Areas and their links to water production facilities: an open-access data set. GEUS Bulletin, 49. https://doi.org/10.34194/geusb.v49.8319

Issue

Section

DATA ARTICLE | SHORT

Most read articles by the same author(s)