UNCOVERING TRENDS OF E. COLI TRANSPORT IN PRIVATE DRINKING WATER WELLS: AN ONTARIO CASE-STUDY
Notice bibliographique
Résumé
Millions of Canadians rely on private groundwater wells to access drinking water, which presents many challenges including a lack of government regulations, and limited resources for maintenance, monitoring, management, and protection. These challenges result in an increased risk of acute gastrointestinal illness in private well users. The goal of this work is to improve the understanding of drivers of E. coli fate and transport in groundwater using a data-driven approach to better inform well owners and policy makers. Specifically, the objectives include: exploratory analysis of the physical and human drivers of private well contamination; advancing the understanding of the relationships between land use-land cover and E. coli presence in wells; assessment of rainfall intermittency patterns as a driver of contamination, as an alternative to standard lag times; and, the development of data-driven explanatory models for E. coli contamination in private wells that move towards a novel coupled-systems approach. This research utilizes a large dataset with 795,023 contamination observations, 253,136 unique wells, and over 33 variables (i.e., microbiological, hydrogeological, well characteristic, meteorological, geographical, and testing behaviour) across Ontario, Canada between 2010 and 2017. Data used includes the Well Water Information Database, Well Water Information System, Daymet, Provincial Digital Elevation Model, Ontario Land Cover Compilation, Southern Ontario Land Resource Information System, and Roads Network. Data analysis methods range from univariate and bivariate analyses to supervised and unsupervised machine learning techniques, including regression, clustering, and classification. This work has contributed important understandings of the relationships between E. coli contamination and well and aquifer characteristics, seasonality, weather, and human behaviour. Specifically, increased well depth reduced, but did not eliminate, likelihood of contamination; wells completed in consolidated material increased likelihood of contamination; the most significant driver of contamination was identified as land use - land cover, which was categorized into four classes of E. coli contamination potential for wells, ranging from very high to low; latitude was found to drive seasonality and consequent weather patterns, leading to the creation of geographically-based seasonal models; liquid water (i.e., rainfall, snow melt) was a key driver of contamination, where increased water generally increased presence of E.coli while causing decreasing prevalence; time of year, not habit, drove user testing, generally peaking in July; and, a surrogate measure of well user stewardship was identified as driving time to closest drop-off location. Further, this work has contributed methodological advancements in identifying drivers of groundwater contamination including: utilizing literature confidence ratings alongside regression analyses to supply strategic direction to policy makers; demonstrating the value of large datasets in combination with innovative machine learning techniques, and subject matter expertise, to identify improved physically-based understandings of the system; and, highlighting the need for coupled-systems approaches as physical models alone do not capture human behaviour-based factors of contamination.
Récupéré en direct depuis OpenAlex et désinversé. Les résumés ne sont pas conservés dans cette base de données : les index inversés représentent 8,6 Go des 9,3 Go de texte de la base, et le serveur dispose de 13 Go libres.
Comment cette classification a été obtenuedéplier
Prédiction machine sur la base complète
Imitation des enseignantsNi prévalence calibrée, ni vérité terrain. Validation humaine à venir. Le volet Gemma est une étiquette directe du modèle pour chaque travail de la base, lue sur la notice réduite au titre. Le volet Codex est un classifieur appris des 10 348 étiquettes directes de Codex et calibré sur les taux pondérés de l'échantillon; les champs sans appui suffisant ne portent aucun appel Codex. Le mode candidate est l'union des deux volets; le consensus est leur intersection. Ces sorties portent le statut machine_predicted_unvalidated et ne sont pas des étiquettes humaines.
Scores du classifieur distillé par catégorie (deux têtes)
| Catégorie | Codex | Gemma |
|---|---|---|
| Métarecherche | 0,000 | 0,002 |
| Méta-épidémiologie (sens strict) | 0,000 | 0,000 |
| Méta-épidémiologie (sens large) | 0,000 | 0,001 |
| Bibliométrie | 0,002 | 0,005 |
| Études des sciences et des technologies | 0,001 | 0,001 |
| Communication savante | 0,001 | 0,000 |
| Science ouverte | 0,001 | 0,001 |
| Intégrité de la recherche | 0,001 | 0,000 |
| Charge utile insuffisante (le modèle a refusé de juger) | 0,001 | 0,000 |
Scores machine (provisoires)
Les deux têtes enseignantes du modèle étudiant, lues sur ce travail. Un score ordonne la base pour la relecture; il n'affirme jamais une catégorie, et le statut de validation accompagne chaque rangée tel quel.
Scores de référence d'un modèle non mature (critères de maturité non atteints, 7 itérations). Un score ordonne; il n'affirme jamais une catégorie.
score_only:v0-immature-baseline · tel quel depuis la passe de notation : score_only signifie que le nombre peut ordonner les travaux, et qu'aucune étiquette de catégorie n'en découleClassification
machine, non validéePrédiction automatique; un appel candidat d’une seule source (Gemma direct ou Codex distillé), pas un consensus.
Le détail, modèle par modèle et score par score, se trouve en fin de page sous « Comment cette classification a été obtenue ».