Data Gathering

Data from numerous sources is placed in a common database. These include;

  • Surveyor General cadastre for the Council�s particular area.
  • Deeds Register data is matched to each property.
  • Municipal Assessment Rates data is matched to the above using any common field.
  • Municipal GIS (if available) is matched to the above using any common field.
  • Municipal billing data for each Utility
  • Other municipal databases that have a common key match.

Data Matching

The above data is matched to achieve a single, accurate database.

  • Mismatched data is identified, examined and corrected
    1. Geographic locations
    2. Language (i.e. school vs. skool)
    3. Typos
  • Data that cannot be reconciled is listed for further examination
  • A gap analysis lists all data missing from the various fields

Data cleansing

  • Missing and mismatched data is compared to additional databases.
  • Additional missing data is sourced.

Data analysis

Various analytical techniques are used to uncover anomalies for further investigation.

  • Municipal Rates on Erfs
  • Utility Basic charges per utility
  • Utility Tariff inconsistency
  • Utility Consumption inconsistency
  • Plus numerous other techniques

Verification of findings

  • Telephone & Email
  • Meter readers
  • Installation staff
  • Physical inspection

Action to correct anomalies proved

  • Notice to Valuation Department stating findings
  • Notice to relevant Utility Department stating findings
  • Notice to Billing Department stating findings
  • Notice to Municipal manager
  • Notice to Project Director

Final Handover and debtors collection

  • Conversion of all data to Municipal required electronic format
  • Deliver data to required Departments
  • Assist with transfer of data to the universal Municipal database chosen by Council, as required.
  • Assist with the collection of new, improved and arrear revenue collected.