Northumbrian Water Domestic Water Quality
收藏资源简介：
Data Origin Samples were taken from customer taps. They were then analysed, and the results were uploaded to a sampling system. Sample results are then validated and submitted to the DWI each month. This is a yearly rolled up version of these extracts. 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. Supplementary information Below is a curated selection of links for additional reading, which provide a deeper understanding of this dataset. Drinking Water Inspectorate Standards and Regulations: https://www.dwi.gov.uk/drinking-water-standards-and-regulations/ LSOA (England and Wales) and Data Zone (Scotland): https://www.nrscotland.gov.uk/files/geography/2011-census/geography-bckground-info-comparison-of-thresholds.pdf Description for LSOA boundaries by the ONS: https://www.ons.gov.uk/methodology/geography/ukgeographies/censusgeographies/census2021geographies Postcode to LSOA lookup tables: https://geoportal.statistics.gov.uk/datasets/postcode-to-2021-census-output-area-to-lower-layer-super-output-area-to-middle-layer-super-output-area-to-local-authority-district-august-2023-lookup-in-the-uk/about Legislation history: https://www.dwi.gov.uk/water-companies/legislation/ Check My Area Tool: Northumbrian Water - https://www.nwl.co.uk/check-your-area/ Essex and Suffolk Water - https://www.eswater.co.uk/check-your-area/ Example Water Quality Info Sheet
数据来源 样本取自用户取水龙头，随后对样本开展检测分析，并将分析结果上传至采样系统。每月均会对样本检测结果进行核验，并提交至英国饮用水监察局（Drinking Water Inspectorate, DWI）。本数据集为上述提取数据按年度汇总后的版本。 数据甄选流程 我们就以下三项议题展开研讨：一是应选用单一样本还是样本均值；二是适配最小可行产品（MVP）的合理日期区间；三是如何通过地理维度实现数据匿名化的最优方案。 首选方案：将地理空间数据匹配至低层级超级输出区（Lower Layer Super Output Area, LSOA）。具体操作为：通过地理空间关联，将每个用户样本的采集点位（以其标注所用坐标系为准）匹配至所属的LSOA。 MVP可接受的替代方案：通过邮编与LSOA进行关联。具体为：基于邮编关联英国国家统计局（Office for National Statistics, ONS）数据集，保留LSOA编码字段。 为何优先选用地理空间匹配至LSOA的方案？因该方案精度更高：邮编映射的匹配基准为邮编对应地址的平均点位，而非样本点的精确位置。 补充信息 以下为精选的拓展阅读链接，可帮助深入理解本数据集： 1. 英国饮用水监察局（DWI）标准与法规：https://www.dwi.gov.uk/drinking-water-standards-and-regulations/ 2. 英格兰与威尔士低层级超级输出区（LSOA）及苏格兰数据区（Data Zone）：https://www.nrscotland.gov.uk/files/geography/2011-census/geography-bckground-info-comparison-of-thresholds.pdf 3. 英国国家统计局（ONS）关于LSOA边界的官方说明：https://www.ons.gov.uk/methodology/geography/ukgeographies/censusgeographies/census2021geographies 4. 邮编至LSOA关联查询表：https://geoportal.statistics.gov.uk/datasets/postcode-to-2021-census-output-area-to-lower-layer-super-output-area-to-middle-layer-super-output-area-to-local-authority-district-august-2023-lookup-in-the-uk/about 5. 法规沿革：https://www.dwi.gov.uk/water-companies/legislation/ 6. 区域水质查询工具： - 诺森布里亚水务（Northumbrian Water）：https://www.nwl.co.uk/check-your-area/ - 埃塞克斯与萨福克水务（Essex and Suffolk Water）：https://www.eswater.co.uk/check-your-area/ 7. 水质信息表示例
