Affinity Water Domestic Water Quality 2024

Data Origin Samples were taken from customer taps. They were then analysed, and the results were uploaded to a sampling system. This dataset is an extract from this database. Data Triage We discussed: Whether to use individual samples or averages What date range would be appropriate for MVP How best to anonymise the data geographically Preferred: Geospatial to LSOA Do geospatial join to find the LSOA that each customer sample location (within whatever coordinate system you have them as) is found within Acceptable for MVP: Postcode to LSOA Join ONS dataset on postcode, keep LSOA code field Why is Geospatial to LSOA preferred? Because it is more accurate since the postcode mapping is best fitted by plotting the location of the postcode's mean address rather than sample point’s specific location.