Swift Link to Treasury Data

The Swift databases are obtained from the relevant authorities' treasury databases. As such Swift includes data for every stand and every meter in the study area. Fields in the databases include information on stand related data such as the owner, consumer, address, landuse, zoning, consumption and tax tariffs of the stand. The value of the stand and any improvements are also included. Information related to the meters includes the meter readings, the meter serial numbers and the date of installation.

This information is available to the user in a seamless structured data table and can be sorted, queried and saved in reports as required. It is also possible to separately view the data and a graphical display of water consumption for each user.

During the course of various studies it has been found that it is important to validate the historical meter records extracted from the treasury systems. Routines are required to identify and correct irregularities in the water meter readings such as sudden drops in the readings when a meter is replaced, spikes and/or dips in the water consumption records and unrealistically high or low readings. Possible causes for these errors include both faulty water meters and data capturing errors.

There are also basic functions to check the integrity of the latest readings against the historical meter records.

Swift allows the user to customize certain settings so that the analyses can be performed for any treasury database. For example what might be considered a large consumer in one town would not necessarily be a large user in another, larger town. Swift allows the user to define the consumption that determines the large users. Similarly, the suburbs and land use information can be categorized into user specified groups so that meaningful results can be obtained for any system.