1 / 13

Valuebill: How to do it 1

kellsie
Download Presentation

Valuebill: How to do it 1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 Experience Sharing Workshops Series 2

  2. Valuebill: How to do it 1 • Software • Good data • Updating facility • Commitment Experience Sharing Workshops Series 2

  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 Experience Sharing Workshops Series 2

  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; you’re there Experience Sharing Workshops Series 2

  5. National match rates Experience Sharing Workshops Series 2

  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% • 1.056,707 of 1,761,510 records matched Experience Sharing Workshops Series 2

  7. National Ctax / NDR to NLPG • Ctax match rates for attending Authorities Experience Sharing Workshops Series 2

  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 Experience Sharing Workshops Series 2

  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 Experience Sharing Workshops Series 2

  10. National NDR clean up and match • NDR match rates for attending Authorities Experience Sharing Workshops Series 2

  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 Experience Sharing Workshops Series 2

  12. Any Questions? Experience Sharing Workshops Series 2

  13. Plenary Experience Sharing Workshops Series 2

More Related