(Partial) Data dictionary for lead piping project part 1
All Lead WQ Samples (2010-2018) (UoE):
Result Numeric Entry: Lead concentration in tap water (in µg/l)
DMA Name: District Meter Area Name
RSZ Water System Name: Name of Water Treatment Area (Same as column WTW Name (Code) in Phosphate Dosing dataset)
Sample Template: Type of survey carried out by Scottish Water (survey method closest to random sample is the ‘Scheduled’ sample)
Comm pipe data:
AGE: Year communication pipe was installed
Pipe age: Age of communication pipe
Date: Date of pipe inspection
Property Type: Type of property serviced by communication pipe
Pipe material: Type of material communication pipe is made of
Estimated length of pipe: In meters
Lead Comms Pipe Replacement:
WO Completed Status: Outcome of work order
Phosphate Dosing WTWs Y or N:
WTW Name (Code): Name of Water Treatment Zone (comparable to RSZ Water System Name in All Lead WQ Samples (2010-2018) (UoE))
Phosphate Dosing on Site: Whether or not orthophosphate dosing of drinking water occurs in water treatment zone. Orthophosphate is added to water by Scottish Water to stop lead in water distribution pipes reaching customers’ taps.
Postcode, household count, urban class:
CensusHouseholdCount2011: Number of households in each street postcode based on Scottish 2011 census
UrbanRural8Fold2016Code: Code (from 1 to 8) denoting urban/rural location of postcode (on ordinal scale where 1 is city centre and 8 is remote rural)
SAA_PropertyAgeData:
Building_Type: Type of house (e.g. detached, semidetached, terraced)
Age_Year: Year in which house was built
Scottish Water Zonal Phosphate Levels:
Phosphorus: Amount of orthophosphate dosing in drinking water at Water Treatment Zone
Rig: Location of water testing rig which tests for lead concentration and amount of orthophosphate in water
UK-HPI-full-file-2019-08:
CouncilArea2018Code: This column can be used to link datasets
AveragePrice: Average house price in region in each date