1. Help Centre
  2. Financial Integration for a Municipality
  3. Phase 2 - Convert & Map Data (Data Integration)

Comparing Deeds, Valuations, Financial Accounts (Municipal and District) & Map

Using Allotment code, Stand and portion per property as the key to synchronize these five sources of property information, mismatches need to be monitored and corrected by the municipality to reduce queries and improve revenue collection.

Filter: 1a - In Deeds (Ctrl Dn - Missing in SG)

Looking at # columns, there should be at least 1x ‘1’ per row.

Question we are trying to solve: 

WHAT APPEARS IN DEEDS BUT IS MISSING ON THE MAP?

Sort By: Distr Code, Mun Code, Allotmntno, Standno, Portionno, Remainder etc.

Process to follow:

  1. Make the layer active and open the data grid;
  2. Click on the first entry & then click CTRL - you should be moved to the next entry that has no geometry;
  3. Inspect the entry above and below it (it is in numerical order - stand no sequence - so they should be the number above and below it) - investigate;
  4. Check the SG diagrams either by clicking on property or Manual Search in the Gauteng office;
    1. Does it exist in the SG?
    2. Is there anything on the diagram about what happened? Ie. cancelled - follow the train to find what the new stand number is;
    3. Check the comments on the SG diagrams too.
  5. Check the imagery - is there something there?
  6. If it has been consolidated/subdivided then open Deeds Summary & check that it is there (if the property is brown then it is in deeds);
  7. UPDATE Map Remarks;
  8. In SG Remarks put in the new stand number & a comment on what seems to have happened.

SG MAP REMARKS

Subdivision not Registered   - SD NOT REG

Consolidated not Registered - CONS NOT REG

Subdivision                               - SD “new stand no”

Consolidated                            - CONS “new stand no”

Scenarios:

    • A property has been replaced - it remains on the system but it does not actually exist;
    • Original land parcel deleted - the SG should never have deleted it and they need to recapture the deleted item;
    • No stand no. - ignore;
    • Sectional Schemes - ignore;

REMEMBER:

  • Numbers grow incrementally BUT if there is a consolidation/subdivision the new property will be allocated the next available no and this can mess with the sequencing.
  • You can search for the erf in the left hand search bar
  • Ignore sectional schemes
  • If consolidated or subdivided check deeds to see if it is registered.
  • ONLY edit the entries selected by the CTRL down arrow 

Filter: 2a - In Deeds (Missing in Mun Prop) 

Question we are trying to solve: 

WHAT APPEARS IN DEEDS BUT IS MISSING FROM THE MUNICIPAL SYSTEM?

Sort By: Distr Code, Mun Code, Allotmntno, Standno, Portionno, Remainder etc.

Process to follow:

  1. Make the layer active and open the data grid;
  2. Ensure you have the correct Aerial Imagery selected;
  3. Start from the top of the list and move all the way through dealing with all entries;
  4. Ignore entries that are rural/farmland (Minor Region Code ends 0000) & properties that are ungeocoded; 
  5. Inspect the selected property to see what the current activity is;
    • Are there any buildings on the property? → Missing 
    • Is the property empty of buildings? → Vacant
    • Is the property falling over a road? → Road
    • Is the property a field, open space, park etc? → POS (Public Open Space)
    • Is it a small property located along side a road, usually long & thin or small & triangular? → Road Reserve
    • Is the property just agriculture activity? → Farm
  6. UPDATE Mun Prop Remarks;
  7. If there is a whole suburb, neighborhood or area that seems to be missing - notify Derryn as this could be an incorrect Minor Region Code. 

Filter: 4a - In Valuation (Missing in Municipal Property)

Question we are trying to solve: 

WHAT APPEARS IN VALUATION BUT IS MISSING FROM THE MUNICIPAL SYSTEM?

Sort By: Distr Code, Mun Code, Allotmntno, Standno, Portionno, Remainder etc.

Process to follow:

  1. Make the layer active and open the data grid;
  2. Ensure you have the correct Aerial Imagery selected;
  3. Start from the top of the list and move all the way through dealing with all entries that are blank in their Mun Prop Remarks column;
  4. Ignore entries that are rural/farmland (Minor Region Code ends 0000) & properties that are ungeocoded; 
  5. Inspect the selected property & then write down it’s Minor Region Code (MRC) & Stand No (stand no needs to be 8 digits so if the stand no is 365 then it should be 00000365);
  6. Move to the Location Address Layer - search for the property using the MRC & Stand No.
  7. Investigate to see if the property can be found in the Location Address & if it has a remainder or is the parent parcel; 
  8. UPDATE Mun Prop Remarks according to what was found in step 7;

Sample remarks about our conclusions:

SG TO CAPTURE

MISSING

SUBDIV NOT REGISTERED

CONSOL- NOW “NEW STAND NO”

INVESTIGATE - PTN 

VACANT

ROAD

ROAD (ADJACENT)

POS

ALLEY

MISSING - SS

BULK ACCOUNT - BILLED AS UNIT 00000

INVESTIGATE - NOT ON MAP - HAS A SG KEY (appears when you search on location address but is not geocoded)

INVESTIGATE - NOTHING SHOWN ON MAP ( nothing appears when search on location address)

INVESTIGATE - FARM PROPERTY - NO BILLING

INVESTIGATE -VACANT. NO BILLING - SURROUNDING PROPERTY HAS BILLING

PTN1 & REM, BUT NO PTN 2

PTN 1, NO PTN 2

If there is a whole suburb, neighborhood or area that seems to be missing or incorrect  - notify Derryn as this could be an incorrect Minor Region Code. 

Filter: 7a - In Municipal Property (Missing in SG Ctrl Dn)

Question we are trying to solve: 

WHAT APPEARS IN MUNICIPAL PROPERTY BUT IS MISSING FROM THE MAP?

Sort By: Distr Code, Mun Code, Allotmntno, Standno, Portionno, Remainder etc.

Process to follow:

  1. Make the layer active and open the data grid;
  2. Ensure you have the correct Aerial Imagery selected;
  3. Click on the first entry & then click CTRL - you should be moved to the next entry that has no geometry;
  4. Search for the property in the erf number search bar on the left hand side of the screen;
    1. If it is not there, search for the erf number in the SG diagrams manual search bar & investigate to see what happened;
    2. Look at the Sg diagrams & follow the trail (if needs be);
  5. Investigate to see if the property can be found & then determine the outcome;
  6. UPDATE Mun Prop Remarks and/or Map Remarks according to what was found in step 5;

if the PTN NO NOT FOUND we fill it in both SG and Mun columns.

STAND NO INVALID 

9999, remainder, any other rubbish

STAND NOT FOUND

Erf seems valid but can’t be found when searched for

PTN NO INVALID

 

PTN NOT FOUND

Stand no found but ptn not found

CONSOL - NOW nnnn

 

SD - NOW nnnnn

 

REPLACED - nnnnn

 

SS - nnnnn

 

SG TO CAPTURE

 

RESEARCH  

 

CANCELLED - NOW nnnnn

 

RELAYOUT - NOW nnnn

 
   

 

Filter: 3 - In Deeds (Missing in Valuation)

Question we are trying to solve: 

WHAT APPEARS IN DEEDS BUT IS MISSING FROM VALUATION ROLL?

Sort By: Distr Code, Mun Code, Allotmntno, Standno, Portionno, Remainder etc.

Filter: 2a - In Deeds (Missing in Mun Prop) 

Dealing with “Missing” Properties

Question we are trying to solve: 

WHY IS THIS PROPERTY MISSING - IS IT OUR MISTAKE OR IS IT ACTUALLY MISSING FROM THE MUNICIPAL SYSTEM?

Sort By: Distr Code, Mun Code, Allotmntno, Standno, Portionno, Remainder etc.

Process to follow:

  1. Make the layer active and open the data grid;
  2. Ensure you have the correct Aerial Imagery selected;
  3. Start from the top of the list and move all the way through dealing with all entries that say “Missing”;
  4. UPDATE Mun Prop Remarks;
  5. If there is a whole suburb, neighbourhood or area that seems to be missing - notify Derryn as this could be an incorrect Minor Region Code.