GIS Property Linking

GIS Property Linking

1. AL2 to Billing

   • AL2 not matched to Billing
     • Map points
       • Some AL2 outside boundary
         • File created of AL2 inside boundary not connected
     • Not PW
       • Insets / Bulk Meters
       • Southwick etc
       • Not needed AL2 points
       • But needed for emergency planning
       • Separate project
     • Match to Billing
       • Customer Services
       • Properties already matched
         • Flats
       • Properties not matched
         • Mismatched address
       • Update GIS
         • Toid matching file
   • Billing not matched to Gazetteer
     • Find through Access
       • Manually match
         • Toid matching file
   • Low and Medium Matches
     • Currently matched to postcode centroid etc
       • Mostly correct SMA
         • Might not be right main
     • Needs improving
       • Process
         • By Post Code
       • Owner
         • Customer Services
     • Troughs an issue
       • Separate project?

2. AL2 to Mains

   • Matching process problems
     • Some too far away
       • Histogram complete
         • Not worth increasing matching distance?
     • Corner Properties
     • More than one main in street
     • Unusual connections
     • Meeting with GS
   • Processes required to maintain / improve
     • Improve accuracy
       • Mains renewals
       • Inspectors
       • Meter Installers
     • Maintain GIS
       • New Properties

3. Results 25/03/14

   • High Confidence
     • Total = 290258
       • 282871 matched to main
       • 7387 not matched to main
     • High 1 = 272683
       • 269032 matched to main
       • 3651 not matched to main
     • High 2 = 1403
       • 115 not matched to main
       • 1288 matched to main
     • High 7 = 16172
       • 12551 matched to main
       • 3621 not matched to main
       • One billing to many AL2
         • Flats
         • Caravan Parks
   • Medium Confidence
     • Total = 4912
       • 4765 matched to main
       • 147 not matched to main
   • Low Confidence
     • Total = 31151
       • 29184 matched to main
       • 1957 not matched to main
   • Total
     • 326321 billing matched to AL2
       • 316821 matched to main
       • 9500 not matched to main

4. Testing

   • Updating Billing file
     • Are manual changes lost?
     • Are properties duplicated?
     • Trackit created for billing changes file

5. Open Water

   • Toid Matches
     • UPRN
     • PAF