Transforming in-situ measurements allows robust estimation of the spatial average of soil moisture despite sensor failures