Data Cleaner - Sample Attribute Changes for Site Module

This is an Indicia specific extension to the rules supported by the :doc`data-cleaner`. It scans the incoming records for a specified survey and looks for any records at a site where a certain sample attribute’s value changes. This may be useful if a sample attribute records something that should be persistent at the site but where the recorder of a sample notes a change to that attribute’s value which should be investigated. An example might be a change to a “site type” attribute. For correct configuration in the warehouse, create a new verification rule with the following settings:

  • Title and Description set as required.

  • Test Type = SampleAttributeChangesForSite

  • Error Message = …

  • Metadata =


Fill in an appropriate error message and for the latter, replace n with the ID of the survey you want to scan and m with the ID of the attribute you want to check doesn’t change.


Because this rule requires the location_id to be filled in to detect the location for a record, the survey’s data input form must capture a location as well as a grid reference. This rule does not use a spatial query to work out the location for each record, so the rule is only really appropriate for surveys which capture records against a defined list of sites.