valuebill case study and benefits valuebill case study and benefits david lloyd llpg manager
TRANSCRIPT
ValuebillValuebillCase Study Case Study andand
BenefitsBenefitsDavid Lloyd
LLPG Manager
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Valuebill Requirement
• HDC - 1 of 10 pilots
• Initial Valuebill Meeting
• Major/initial task - data cleanse
• IA provide reference anomalies
• IA provide address matching anomalies
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Valuebill Project Team
• 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)
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Review
• Strategy
• Benefits
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Strategy
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Valuebill Project Team + Support
• 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
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Task
IA would match the NLPG to VOA addresses
HDC to internally match CTAX & NDR cross references to the LPG
IA would match the NLPG to VOA references
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Process
Where are we now?
What do we want to achieve?
How to achieve it?
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Where Are We Now?
• 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
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
What Do We Want To Achieve?
• 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
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
How To Achieve It?
Current extractCurrent extract
Battery of report
anomalies
Battery of report
anomalies
Process anomalies
Process anomalies
100% synchronisation
100% synchronisation
Future procedures & controls
Future procedures & controls
Cross references
Addresses
Building noBuilding no Building nameBuilding name Street nameStreet name
LocalityLocality Post TownPost Town PostcodePostcode
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
CTAX/NDR xref Distribution
NLPG HubNLPG HubNLPG HubNLPG Hub
LALACTAX/NDRCTAX/NDR
LALACTAX/NDRCTAX/NDRLLPGLLPGLLPGLLPG
VOA VOA DatabaseDatabaseVOA VOA
DatabaseDatabaseLocal Local VOAVOA
Local Local VOAVOA
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
NLPG Matched to VOA
• Matching Cross references
– 368 CTAX & 267 NDR
– Analysed reports
– Narrated each item
• Work impact on local VOA
• Matching addresses – 37 CTAX & 10
NDR items
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
CTAX/NDR xref Distribution
NLPG HubNLPG HubNLPG HubNLPG Hub
LALACTAX/NDRCTAX/NDR
LALACTAX/NDRCTAX/NDRLLPGLLPGLLPGLLPG
VOA VOA DatabaseDatabaseVOA VOA
DatabaseDatabaseLocal Local VOAVOA
Local Local VOAVOA
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Benefits
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Connectivity
• 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
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Address Cleansing
• Council Tax addresses
• Non Domestic Rating addresses
• Land & Property Gazetteer
• Positional accuracy
21
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Street Name Differences
Abbey FieldsAbbeyfields
Corunna Close Coruna Close
Parkside Park Side
The Rampleys The Rampley
Westmere
Westmeare
Whellams
Whellums 404014001400
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Building Name Differences
Stoneley Grange
The Grange
Balcony House
No house name
The Old Stable Old Stables11001100
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Postcode Differences
58005800PE28 5YD PE28 5YB
PE29 1ZA PE29 1YY
PE28 2JH PE28 2BJ
PE29 7WJ PE18 7WJPE19 1TU
PE19 1TT
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Town Name Differences
Old Hurst Oldhurst
Woodhurst Wood Hurst
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Other Dataset Matching
• Knowledge that all Revenue
properties are included in the LPG
• Use the LPG to match other internal
datasets
• Address cleansing
• Mailings
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
• All Revenue properties displayed
spatially on the intranet
Spatially Display Properties
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Spatially Display Properties
• All Revenue properties displayed
spatially on the intranet
• Assist with inspections
• Identify cross references incorrectly
attached
• Opportunity to question buildings
without CTAX or NDR cross reference
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
CTAX Reference Compatibility
• 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
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Call Centre
• 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
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
VOA
• Faster communication
• More accurate exchange of data
• 100% match of cross references
for the VOA
• Correct cross reference details
• VOA holds the LPG UPRN
• Postcode
• XY coordinates
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Additional Revenue
• One commercial property
• 3 domestic properties
– 2 dwellings
– 1 annexe
• Additional annual income £150k
Pathfinder House, St Mary's Street, Huntingdon, PE29 3TNTel 01480 388388 Fax 01480 388099 www.huntsdc.gov.uk
Thank you
Thank you