Consolidate Toilet reporting in warehouse

Issue #1222 resolved
Brian Lewis repo owner created an issue

This is a small bite out of #1142:

Toilet data is collected on the Census workbook and also the Android WASH survey. Currently warehouse.washToilets only takes data from the Android survey. We should consolidate toilet data from the census into this table too.

Simple rules are:

  • for any survey year, the most recent Android survey or Census data is used.
  • If there is both a Survey and a Census record in the same year, the Android survey gets precedence.
  • Each record should record its source of data (WASH or CENSUS).

Note that the Census load and the Kiribati PDF load both write to the table toilets, which will serve as the basis for this expanded process. This makes warehouse.WashToilets available to Kiribati and more generally to countries not using the WASH android survey consistently.

Comments (3)

  1. Brian Lewis reporter

    This illustrates the effect of this change: Prior to including CENSUS data, only schools with a WASH survey are reported in WashToilets:

    With this change, those schools with census toilet data report that data when there is no WASH survey:

  2. Log in to comment