Local e-gov National Projects Experience Sharing Workshops Series III VALUEBILL Part 3: Address Matching Barry Tuckwood - Valuebill Project Manager Barbara Jones - Valuebill Consultant David Lloyd - Huntingdonshire DC Andrew Lawes - East Riding Matthew

1
Local e-gov National ProjectsExperience Sharing
Workshops Series IIIVALUEBILLPart 3 Address
MatchingBarry Tuckwood - Valuebill Project
ManagerBarbara Jones - Valuebill
ConsultantDavid Lloyd - Huntingdonshire
DCAndrew Lawes - East RidingMatthew Toms -
South GloucestershireDavid Hughes - Valuation
Office AgencyNick Griffiths - IA NLPG
2
Valuebill How to do it 1

• Software
• Good data
• Updating facility
• Commitment

3
Valuebill How to do it 2

• DATA MATCHING
• Obtain data sets from NLPG including unmatched
  records
• Validate two lookup tables against LLPG, CT and
  NDR
• Review third lookup table and add appropriate
  unmatched
• Resolve with appropriate people inc VOA
• DATA QA AND CONTINUANCE
• Verify
• Enable regular updates of NLPG from LLPG
• Add UPRNs into local datasets

4
Valuebill How to do it 3

• BUSINESS PROCESS CHANGE
• Create and agree business procedures for internal
  exchange and maintenance of property address
  data and associated management controls
• DATA TRANSFER
• Enable internal electronic updates
• Enable electronic transfer with VOA
• Hooray youre there

5
National match rates
Table 1 Current Position (as at 8th February 2005) Table 1 Current Position (as at 8th February 2005) Table 1 Current Position (as at 8th February 2005) Table 1 Current Position (as at 8th February 2005) Table 1 Current Position (as at 8th February 2005)
Total Ctax NDR Other
Records Supplied 29,338,236 22,994,332 1,761,510 4,582,394

Matched and sent to VOA 24,165,364 21,590,316 1,050,379 1,524,669
Matched waiting to be sent 71,517 57,724 6,328 7,465
Set to minus 1 and sent to VOA 1,495,435 1,495,435
Set to minus 1 waiting to be sent 6 6

25,732,322 21,648,040 1,056,707 3,027,575
To Do 3,605,914 1,346,292 704,803 1,554,819

6
National Ctax / NDR to NLPG

• Council Tax
• Nationally 94 of Ctax data matched to NLPG
• 44 LAs 99 plus match rate
• 167 95-99
• 72 90-95
• 44 85-90
• 18 80-85
• 24 70-80
• 11 under 70
• 21,648, 040 of 22,994,332 records matched
• NDR
• Nationally 60 of NDR data matched to NLPG
• 3 LAs 90 plus match rate
• 14 80-90
• 16 75-80
• 45 70-75
• 128 60-70
• 100 50-60
• 74 under 50

7
National Ctax / NDR to NLPG

• Ctax match rates for attending Authorities

8
National Ctax / NDR to NLPG

• Ctax addresses relatively simple / clean
• Identifying and matching streets
• Ctax files provided on CD
• Matched look up table
• Billing Authority Reference plus UPRN
• VOA address and extracted NLPG address
• Match flag (EX or OH)
• List of unmatched records
• street gazetteer rural / urban differences
• NDR data subject to second process

9
National NDR clean up and match

• 116 Clean up routines and 32 matching routines
  developed
• Summary of results
• Overall match rate much the same as before
• Highlights amount of potentially historic or
  spurious commercial property related data in NLPG
• Resulted in a high level of cleaned addresses
  ready for review and insertion into LLPGs
• Identified a number of issues for both VOA and
  NLPG
• Address format / data entry conventions
• Use of company names
• Use of descriptive / positional addresses
• Conclusion that NDR is in fact easier to
  integrate into the NLPG than the common
  perception that it is impossible to resolve

10
National NDR clean up and match

• NDR match rates for attending Authorities

11
National NDR clean up and match

• Files A-C provided on CD
• Simple actions to be taken
• Specific Address Issues
• Advertising rights / car parking spaces /
  communication stations
• At, on, off
• Part / floors
• Organisation names

12
Any Questions?
13
Plenary