OpenData Wiki

Dataset documentation and review before publication

User Tools

Site Tools


datasets:bafu:25122461-6ad7-3043-b1e5-02e7bdb2e2a7

Tap water, unspecified natural origin OECD, at user — RER

Dataset documentation and final control (tdc-doc, imported mode)
Open this dataset in OpenData

Abstract. BAFU 2026 v1 (Swiss Federal Office for the Environment). Dataset Tap water, unspecified natural origin OECD, at user [RER], per 1 kg. EF v3.1 climate change 2.014e-04 kg CO2 eq (Monte Carlo 95 % interval 1.465e-04–3.706e-04). Main contributors: Electricity, medium voltage, production ENTSO-E, at grid 53 %; Water works 20 %; Water supply network 8 %; Ozone, liquid, at plant 7 %; Water storage 3 %; Charcoal, at plant 3 %. Status: final control passed.
Item Value
Dataset name Tap water, unspecified natural origin OECD, at user
Dataset UUID / graph id 25122461-6ad7-3043-b1e5-02e7bdb2e2a7 / activity:tap_water_unspecified_natural_origin_oecd_at_user__rer
Reference product, unit Tap water, unspecified natural origin OECD, at user, 1 kg
Location RER
Time period 2000-01/2000-12
Category water / drinking water
Source database BAFU 2026 v1 (Swiss Federal Office for the Environment), version 2026 v1
Publisher Swiss Federal Office for the Environment (FOEN/BAFU)
Background database BAFU 2026 v1 (graph bafuquery-db)
LCIA method EF v3.1, consensus-flow-list implementation, 25 categories (bw2calc on the graph matrix)
Status final control passed
Documented by tdc-doc, imported mode (graph recalculation, Monte Carlo, final control), 2026-11-17

Introduction

Rough estimation investigated for CH and data for energy use in DE.; Formula: H2O; UUID: 25122461-6ad7-3043-b1e5-02e7bdb2e2a7

This report documents an imported dataset: its inventory and metadata come from the publisher, not from the tdc pipeline. tdc-doc recomputes it on the graph, checks it (Section 7), and reports it in the ISO 14044 / BAFU DQR v2.1 structure used for tdc's own datasets. Sections that only apply to datasets built by tdc (stoichiometry, energy model, literature excerpts) are replaced by what the publisher declares.

Goal and scope

Function, functional unit and reference flow

Reference flow: 1 kg of Tap water, unspecified natural origin OECD, at user (RER). All results are given per unit of the reference flow.

System boundary

Infrastructure and energy use for water treatment and transportation to the end user. No emissions from water treatment. Water flows adapted with new elementary flows for water balance.

Technology

Example of a water works in CH.

Native BAFU dataset: exchanges as delivered in EcoSpold v1, linked by the graph migration (graphlca.load).

LCIA method

EF v3.1, characterisation only (no normalisation or weighting), consensus-flow-list implementation of the 25 categories, with regionalised factors where the flow carries a place.

Life cycle inventory

Inventory table

Direct exchanges per reference flow, ordered by their share of climate change. Uncertainty: the distribution declared on the graph edge (BAFU: lognormal from the pedigree matrix). Pedigree: the scores the publisher declares (BAFU: reliability, completeness, temporal, geographical, technological, sample size; PEF DQR otherwise).

Exchange Type Location / compartment Amount Unit Uncertainty Pedigree GWP share (%) Notes
Electricity, medium voltage, production ENTSO-E, at grid technosphere ENTSO-E 3.9000e-04 kWh lognormal, GSD² 2 — 53.1 ███████████
Water works technosphere CH 1.1907e-11 p lognormal, GSD² 3.05 (2,3,1,3,1,5) 20.3 ████
Water supply network technosphere CH 3.1429e-10 km lognormal, GSD² 3.05 (2,3,1,3,1,5) 8.4 ██
Ozone, liquid, at plant technosphere RER 3.3333e-06 kg lognormal, GSD² 1.22 (2,3,1,3,1,5) 6.9 █
Water storage technosphere CH 2.0568e-11 p lognormal, GSD² 3.05 (2,3,1,3,1,5) 3.0 █
Charcoal, at plant technosphere GLO 4.1700e-06 kg lognormal, GSD² 1.22 (2,3,1,3,1,5) 2.5 █
Treatment, sewage, unpolluted, to wastewater treatment, class 3 technosphere CH 1.7656e-05 m3 lognormal, GSD² 1.57 (5,3,1,3,1,5) 2.4 ·
Pump station technosphere CH 2.0568e-11 p lognormal, GSD² 3.05 (2,3,1,3,1,5) 1.5 ·
Aluminium sulphate, powder, at plant technosphere RER 6.3300e-06 kg lognormal, GSD² 1.22 (2,3,1,3,1,5) 1.2 ·
Hydrogen peroxide, 50% in H2O, at plant technosphere RER 8.8000e-07 kg lognormal, GSD² 1.22 (2,3,1,3,1,5) 0.4 ·
Transport, freight, lorry, fleet average technosphere RER 1.4813e-06 tkm lognormal, GSD² 2.09 — 0.1 ·
Transport, freight, rail technosphere RER 8.8880e-06 tkm lognormal, GSD² 2.09 — 0.1 ·
Disposal, wood untreated, 20% water, to municipal incineration technosphere CH 4.1700e-06 kg lognormal, GSD² 1.22 (2,3,1,3,1,5) 0.0 ·
Chlorine, liquid, production mix, at plant technosphere RER 1.0000e-07 kg lognormal, GSD² 1.22 (2,3,1,3,1,5) 0.0 ·
Chloride(1-) elementary water/River 5.0352e-06 kg lognormal, GSD² 1.77 — 0.0 ·
Water elementary natural resource 0.0011287 m3 lognormal, GSD² 1.07 (1,3,1,3,1,1) 0.0 ·
Chlorine elementary water/River 1.0000e-07 kg lognormal, GSD² 1.77 — 0.0 ·
Waste Heat elementary air/Ground level / Urban (>1000 people/s… 0.001404 MJ lognormal, GSD² 1.22 (2,3,1,1,1,5) 0.0 ·
Aluminium elementary water/River 1.2948e-06 kg none declared: tdc-doc default ±50 % — 0.0 ·

Data quality

13 of 19 direct exchanges carry a declared pedigree, 18 carry a distribution. Mean declared pedigree (1 = best, 5 = worst): reliability 2.15 · completeness 3.0 · temporal 1.0 · geographical 2.85 · technological 1.0 · sample size 4.69.

Field As declared by the publisher
Data generator / entry / validation data generator: Niels Jungbluth (ESU); data entry: Niels Jungbluth (ESU); validation (proof reading): Manuele Margni
extrapolations From CH and DE to RER situation. Share of resource uses (ground and surface water) estimated.
sampling procedure Literature.
production volume na
uncertainty adjustments none
validation details Proof reading validation: 16.05.2012; Other validation: \Server\e\ESU-Docs\Projektablage\124 ecoinvent operation\08 chemicals[EcoSpold-tapwater-2.4.xlsx]X-Process;
time period comment Time of publication.

Data gaps, proxies and assumptions

Item Class Value used Reason Effect
1 exchange(s) without declared uncertainty uncertainty fixed in the Monte Carlo the publisher declares no distribution ±50 % in the sensitivity check (Section 6.3)

Life cycle impact assessment (EF v3.1)

Per 1 kg. The 95 % interval and GSD² come from the Monte Carlo of Section 6.4.

Impact category Indicator Unit Result 2.5 % 97.5 % GSD²
Acidification Accumulated Exceedance (AE) mol H+ eq 3.341e-07 2.670e-07 6.105e-07 1.54
Climate change-Biogenic Radiative forcing as Global Warming Potential (GWP100) kg CO2 eq 6.707e-06 4.493e-06 1.123e-05 1.6
Climate change-Fossil Radiative forcing as Global Warming Potential (GWP100) kg CO2 eq 1.946e-04 1.402e-04 3.622e-04 1.63
Climate change-Land use and land use change Radiative forcing as Global Warming Potential (GWP100) kg CO2 eq 8.085e-08 5.575e-08 1.604e-07 1.71
Climate change Radiative forcing as Global Warming Potential (GWP100) kg CO2 eq 2.014e-04 1.465e-04 3.706e-04 1.62
EF-particulate Matter Impact on human health disease incidence 7.789e-12 5.783e-12 1.800e-11 1.81
Ecotoxicity, freshwater_inorganics Comparative Toxic Unit for ecosystems (CTUe) CTUe 0.008823 0.008012 0.01054 1.15
Ecotoxicity, freshwater_organics Comparative Toxic Unit for ecosystems (CTUe) CTUe 8.631e-06 7.234e-06 2.526e-05 1.89
Ecotoxicity, freshwater Comparative Toxic Unit for ecosystems (CTUe) CTUe 0.008832 0.008024 0.01056 1.15
Eutrophication marine Fraction of nutrients reaching marine end compartment (N) kg N eq 1.362e-07 1.026e-07 2.612e-07 1.62
Eutrophication, freshwater Fraction of nutrients reaching freshwater end compartment (P) kg P eq 1.265e-07 5.832e-08 5.047e-07 3.04
Eutrophication, terrestrial Accumulated Exceedance (AE) mol N eq 1.026e-06 7.923e-07 2.028e-06 1.63
Human toxicity, cancer_inorganics Comparative Toxic Unit for human (CTUh) CTUh 5.386e-14 4.493e-14 2.061e-13 2.14
Human toxicity, cancer_organics Comparative Toxic Unit for human (CTUh) CTUh 1.059e-13 6.724e-14 2.221e-13 1.84
Human toxicity, cancer Comparative Toxic Unit for human (CTUh) CTUh 1.598e-13 1.230e-13 3.756e-13 1.79
Human toxicity, non-cancer_inorganics Comparative Toxic Unit for human (CTUh) CTUh 3.896e-12 2.628e-12 1.894e-11 2.73
Human toxicity, non-cancer_organics Comparative Toxic Unit for human (CTUh) CTUh 9.345e-14 7.569e-14 1.969e-13 1.65
Human toxicity, non-cancer Comparative Toxic Unit for human (CTUh) CTUh 3.989e-12 2.743e-12 1.908e-11 2.69
Ionising radiation, human health Human exposure efficiency relative to U235 kBq U235 eq 1.726e-04 5.376e-05 0.001262 4.77
Land use Soil quality index pt (soil quality index) 0.008213 0.005762 0.01713 1.72
Ozone depletion Ozone Depletion Potential (ODP) kg CFC-11 eq 4.078e-12 2.993e-12 9.787e-12 1.82
Photochemical ozone formation - human health Tropospheric ozone concentration increase kg NMVOC eq 4.707e-07 3.728e-07 9.815e-07 1.63
Resource use, fossils Abiotic resource depletion fossil fuels (ADP-fossil) MJ 0.003357 0.002369 0.00676 1.75
Resource use, minerals and metals Abiotic resource depletion (ADP ultimate reserve) kg Sb eq 3.833e-10 2.188e-10 1.030e-09 —
Water use User deprivation potential (deprivation-weighted water consumption) m3 world eq deprived 0.0485 -0.06305 0.1089 —

Climate change 2.014e-04 kg CO2 eq per kg. Main contributors: Electricity, medium voltage, production ENTSO-E, at grid 53 %; Water works 20 %; Water supply network 8 %; Ozone, liquid, at plant 7 %; Water storage 3 %; Charcoal, at plant 3 %.

Interpretation

Significant issues

Direct exchanges dominating climate change: Electricity, medium voltage, production ENTSO-E, at grid 53 %; Water works 20 %; Water supply network 8 %; Ozone, liquid, at plant 7 %; Water storage 3 %; Charcoal, at plant 3 %. Most sensitive exchanges (Section 6.3): Electricity, medium voltage, production ENTSO-E, at grid [ENTSO-E] (-26.2 / +51.6 %); Water works [CH] (-13.5 / +40.4 %); Water supply network [CH] (-5.6 / +16.6 %).

Independent recalculation

Graph result against BAFU 2026 v1 published EF 3.1 results (LCIA Results.xlsx, June 2026):

Category Graph Published Graph / published
Acidification 3.341e-07 6.211e-07 0.538
Climate change-Biogenic 6.707e-06 6.707e-06 1.000
Climate change-Fossil 1.946e-04 1.946e-04 1.000
Climate change-Land use and land use change 8.085e-08 8.085e-08 1.000
Climate change 2.014e-04 2.014e-04 1.000
EF-particulate Matter 7.789e-12 7.789e-12 1.000
Ecotoxicity, freshwater_inorganics 0.008823 0.008838 0.998
Ecotoxicity, freshwater_organics 8.631e-06 8.474e-06 1.019
Ecotoxicity, freshwater 0.008832 0.008846 0.998
Eutrophication marine 1.362e-07 1.362e-07 1.000
Eutrophication, freshwater 1.265e-07 1.265e-07 1.000
Eutrophication, terrestrial 1.026e-06 1.260e-06 0.814
Human toxicity, cancer_inorganics 5.386e-14 5.097e-14 1.057
Human toxicity, cancer_organics 1.059e-13 1.059e-13 1.000
Human toxicity, cancer 1.598e-13 1.569e-13 1.018
Human toxicity, non-cancer_inorganics 3.896e-12 3.807e-12 1.023
Human toxicity, non-cancer_organics 9.345e-14 9.344e-14 1.000
Human toxicity, non-cancer 3.989e-12 3.901e-12 1.023
Ionising radiation, human health 1.726e-04 1.726e-04 1.000
Land use 0.008213 0.004896 1.677
Ozone depletion 4.078e-12 4.078e-12 1.000
Photochemical ozone formation - human health 4.707e-07 4.707e-07 1.000
Resource use, fossils 0.003357 0.003361 0.999
Resource use, minerals and metals 3.833e-10 3.681e-10 1.041
Water use 0.0485 0.04315 1.124
Over all BAFU datasets, climate change agrees with the published table for 98.1 % of them within ±5 % (median ×1.000). Systematic differences are expected where the graph characterises differently from BAFU's table: regionalised factors (acidification, terrestrial eutrophication, land use, water use, by the flow's place) and the metal resource factors; these categories: Acidification median ×0.81 (16 % within ±5 %); Eutrophication, terrestrial median ×0.93 (37 % within ±5 %); Land use median ×1.23 (6 % within ±5 %); Resource use, minerals and metals median ×1.04 (52 % within ±5 %); Water use median ×0.75 (11 % within ±5 %). BAFU's table is per its own unit (electricity per MJ, cars per m, crops per m2), converted here, and carries the organics and inorganics sub-indicators of freshwater ecotoxicity in each other's column (primary copper: 99.7 % of its ecotoxicity under 'organics'); they are compared like with like.
Also published by BAFU for this dataset: IPCC 2021 GWP100 2.014e-04 kg CO2 eq; Ecological Scarcity
2021 total 0.415 UBP.

Sensitivity check

One at a time on each direct exchange, over its declared 95 % range (±50 % when none is declared, the tdc-doc default for an assumption without a range). The supply chain behind each input is held at its mean.

Exchange Base Low / high Range Δ GWP100 (%) Δ other categories (max %)
Electricity, medium voltage, production ENTSO-E, at grid [ENTSO-E] 3.900e-04 kWh ×0.507 / ×1.97 lognormal, GSD² 2 -26.2 / +51.6 79.6 (Ionising radiation, human health)
Water works [CH] 1.191e-11 p ×0.335 / ×2.99 lognormal, GSD² 3.05 -13.5 / +40.4 75.7 (EF-particulate Matter)
Water supply network [CH] 3.143e-10 km ×0.335 / ×2.99 lognormal, GSD² 3.05 -5.6 / +16.6 116.7 (Human toxicity, non-cancer_inorganics)
Water storage [CH] 2.057e-11 p ×0.335 / ×2.99 lognormal, GSD² 3.05 -2.0 / +5.9 29.9 (Land use)
Pump station [CH] 2.057e-11 p ×0.335 / ×2.99 lognormal, GSD² 3.05 -1.0 / +3.0 13.9 (Resource use, minerals and metals)
Ozone, liquid, at plant [RER] 3.333e-06 kg ×0.82 / ×1.22 lognormal, GSD² 1.22 -1.2 / +1.5 2.3 (Ionising radiation, human health)
Treatment, sewage, unpolluted, to wastewater treatment, class 3 [CH] 1.766e-05 m3 ×0.643 / ×1.55 lognormal, GSD² 1.57 -0.9 / +1.4 3.7 (Resource use, minerals and metals)
Charcoal, at plant [GLO] 4.170e-06 kg ×0.82 / ×1.22 lognormal, GSD² 1.22 -0.5 / +0.6 14.8 (Climate change-Biogenic)
Aluminium sulphate, powder, at plant [RER] 6.330e-06 kg ×0.82 / ×1.22 lognormal, GSD² 1.22 -0.2 / +0.3 2.1 (Acidification)
Transport, freight, lorry, fleet average [RER] 1.481e-06 tkm ×0.484 / ×2.06 lognormal, GSD² 2.09 -0.1 / +0.1 1.4 (Climate change-Land use and land use change)
Hydrogen peroxide, 50% in H2O, at plant [RER] 8.800e-07 kg ×0.82 / ×1.22 lognormal, GSD² 1.22 -0.1 / +0.1 0.2 (Ecotoxicity, freshwater_organics)
Transport, freight, rail [RER] 8.888e-06 tkm ×0.484 / ×2.06 lognormal, GSD² 2.09 -0.0 / +0.1 0.6 (Human toxicity, non-cancer_organics)
Disposal, wood untreated, 20% water, to municipal incineration [CH] 4.170e-06 kg ×0.82 / ×1.22 lognormal, GSD² 1.22 -0.0 / +0.0 0.1 (Eutrophication marine)
Chlorine, liquid, production mix, at plant [RER] 1.000e-07 kg ×0.82 / ×1.22 lognormal, GSD² 1.22 -0.0 / +0.0 0.9 (Ozone depletion)
Chloride(1-) [water/River] 5.035e-06 kg ×0.57 / ×1.75 lognormal, GSD² 1.77 -0.0 / +0.0 13.0 (Ecotoxicity, freshwater_inorganics)

Uncertainty analysis

Monte Carlo over the whole supply chain: 1000 draws (seed 42, computed 2026-11-17), every exchange of the database that carries a distribution resampled at each draw, one adjoint solve per category per draw. Exchanges without a distribution enter as fixed values (Section 4.3). Results in Section 5.

Comparison with other data

No other location of this dataset in the graph.

Conclusions and limitations

GWP100 2.014e-04 kg CO2 eq per kg (95 % interval 1.465e-04–3.706e-04). Dominant contributors: Electricity, medium voltage, production ENTSO-E, at grid 53 %; Water works 20 %; Water supply network 8 %; Ozone, liquid, at plant 7 %; Water storage 3 %; Charcoal, at plant 3 %. Most sensitive: Electricity, medium voltage, production ENTSO-E, at grid [ENTSO-E] (-26.2 / +51.6 %); Water works [CH] (-13.5 / +40.4 %); Water supply network [CH] (-5.6 / +16.6 %). final control passed. The documentation relies on the publisher's metadata; this report is not a critical review in the sense of ISO 14044 clause 6.

Final control

Item Status Detail
reference flow PASS production amount 1.0 kg
closure: sum of direct contributions = dataset score (all 25 categories) PASS largest relative gap 3.9e-16
independent recalculation vs BAFU 2026 v1 published EF 3.1 results (LCIA Results.xlsx, June 2026) (climate change) PASS graph / published = 1; categories within ±5 %: 20/25
every technosphere input of the EcoSpold delivery is in the graph PASS all present (bafu_links_check.py)
uncertainty declared on the direct exchanges PASS 18/19 exchanges carry a distribution (95 %); the others enter the Monte Carlo as fixed values
Monte Carlo 95 % interval contains the deterministic score PASS 2.014e-04 in [1.465e-04, 3.706e-04]
time period declared PASS 2000-01/2000-12
geography is a known location code PASS RER
sources cited PASS 2 reference(s), of which 1 dataset source(s); 0 resolved to a bibliographic record (DOI or Crossref/OpenAlex match), the others kept as the publisher declares them

References

  1. Althaus H.-J., Chudacoff M., Hischier R., Jungbluth N., Osses M., Primas A. (2007) Life Cycle Inventories of Chemicals. Final report ecoinvent data v2.0. Volume: 8. Swiss Centre for LCI, Empa - TSL. Dübendorf, CH. Type: Measurement on site Source: CD-ROM First author: Althaus H.-J. Other authors: Chudacoff M., Hischier R., Jungbluth N., Osses M., Primas A. Year: 2007 Title of anthology: Final repo… — published source; as declared by BAFU (not found in OpenAlex/Crossref)
  2. Life Cycle Inventory database of the Swiss Federal Administration, BAFU:2026 — database; dataset citation
  3. International Organization for Standardization (2006). ISO 14044:2006 Environmental management — Life cycle assessment — Requirements and guidelines (incl. Amd 1:2017, Amd 2:2020). Geneva.
  4. Frischknecht R. (2023). FOEN LCI data — Data quality requirements (DQR) v2.1. treeze Ltd. on behalf of the Swiss Federal Office for the Environment (FOEN/BAFU), Uster / Bern. (tdc-doc method reference; title, version and year to verify against the user's copy)
  5. European Commission, Joint Research Centre (2022). Environmental Footprint (EF) reference package 3.1. Ispra.
  6. Mutel C. (2017). Brightway: An open source framework for Life Cycle Assessment. Journal of Open Source Software 2(12), 236. https://doi.org/10.21105/joss.00236

Annex — licence and terms of use

BAFU:2026 Terms of Use - free use, processing and reuse of the data (including in LCA studies and calculators); the data may not be sold, resold or distributed as a database; modifications must be documented and shared under equivalent terms; credit required.


To suggest a correction or a dataset that does not exist yet, use Propose a dataset.

datasets/bafu/25122461-6ad7-3043-b1e5-02e7bdb2e2a7.txt · Last modified: by 127.0.0.1

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki