I am analysing borehole water supply in rural communities. I have CSV data which includes the GPS location for each water point and a flag as to whether the water point is currently functioning (Yes/No).
I want to create a "heatmap-style" output with areas where there are functioning waterpoints to be coloured in green, areas where there are non-functioning water points covered in red but areas with no water points to be left untouched (ie white).
I can convert yes/no to boolean and interpolate but then areas where there are no water points - mountains etc - will be coloured depending on how the surrounding water points, which might be 10km away, are performing.
Do I need to somehow create both an interpolated layer and a heatmap and then group them together, such that transparency levels are set by point density (heatmap) and the actual colour is set by interpolation?