290 likes | 422 Views
Valuebill Case Study and Benefits David Lloyd LLPG Manager. HDC - 1 of 10 pilots Initial Valuebill Meeting Major/initial task - data cleanse IA provide reference anomalies IA provide address matching anomalies. Valuebill Requirement. Valuebill Project Team
E N D
HDC - 1 of 10 pilots Initial Valuebill Meeting Major/initial task - data cleanse IA provide reference anomalies IA provide address matching anomalies Valuebill Requirement
Valuebill Project Team Head of Information Management Head of Revenues Local Taxation Manager Business Analyst (Project Manager for GIS and LLPG) LLPG Manager (Valuebill Project Manager) Valuebill Project Team
Strategy Benefits Review
Challenge Strategy
Valuebill Project Team Head of Information Management Head of Revenues Local Taxation Manager Business Analyst (Project Manager for GIS and LLPG) LLPG Manager (Valuebill Project Manager) Street Naming & Numbering Intelligent Addressing Local VOA Valuebill Project Team + Support
Task HDC to internally match CTAX & NDR cross references to the LPG IA would match the NLPG to VOA references IA would match the NLPG to VOA addresses
Process Where are we now? What do we want to achieve? How to achieve it?
CTAX/NDR data used to create the LPG Data was 21 months out of date Did not include new cross references and held closed references 750 CTAX & 1,200 NDR differences Only some alternative addresses had been captured during LPG creation Where Are We Now?
100% cross reference synchronisation between LPG & CTAX/NDR Process to capture future additions and closures of CTAX/NDR into LPG Monthly synchronisation of Revenue cross references within LPG Where possible, synchronise addresses between LPG & CTAX/NDR What Do We Want To Achieve?
How To Achieve It? Cross references Current extract Battery of report anomalies Process anomalies 100% synchronisation Future procedures & controls Addresses Building no Building name Streetname Locality Post Town Postcode
CTAX/NDR xref Distribution NLPG Hub VOA Database Local VOA LLPG LA CTAX/NDR
Matching Cross references – 368 CTAX & 267 NDR Analysed reports Narrated each item Work impact on local VOA Matching addresses – 37 CTAX & 10 NDR items NLPG Matched to VOA
CTAX/NDR xref Distribution VOA Database NLPG Hub Local VOA LA CTAX/NDR LLPG
100% synchronisation of cross references Liaising between Uniform & Sx3 to establish connector Interim monthly ongoing synchronisation Provide VOA with the UPRN in communications Internet – Banding & RV Connectivity
Council Tax addresses Non Domestic Rating addresses Land & Property Gazetteer Positional accuracy Address Cleansing 21
Street Name Differences AbbeyFields Abbeyfields Westmere Corunna Close Coruna Close Westmeare Park Side Parkside Whellams The Rampley The Rampleys Whellums 1400 40
Building Name Differences Stoneley Grange TheGrange No house name Balcony House Old Stables The Old Stable 1100
Postcode Differences PE285YB PE285YD PE291YY PE291ZA PE282JH PE282BJ PE187WJ PE297WJ PE191TT PE191TU 5800
Town Name Differences OldHurst Oldhurst Woodhurst Wood Hurst
Knowledge that all Revenue properties are included in the LPG Use the LPG to match other internal datasets Address cleansing Mailings Other Dataset Matching
Spatially Display Properties • All Revenue properties displayedspatially on the intranet
All Revenue properties displayedspatially on the intranet Spatially Display Properties • Assist with inspections • Identify cross references incorrectly attached • Opportunity to question buildings without CTAX or NDR cross reference
Revenues changed the structure of the CTAX reference in earlier years Not reflected by the VOA Identified in May Revenues & VOA hub worked to align the current reference CTAX Reference Compatibility
Robust data LPG is a key enabler of our Customer First programme Calls from the public e.g. bin round or Housing With multiple LPI’s property identification within seconds Negates/reduces the need for candidate records Call Centre
Faster communication More accurate exchange of data 100% match of cross referencesfor the VOA Correct cross reference details VOA holds the LPG UPRN Postcode XY coordinates VOA
One commercial property Additional Revenue • 3 domestic properties • 2 dwellings • 1 annexe • Additional annual income £150k