generating individualized tax assessment information · 1 generating individualized tax assessment...
TRANSCRIPT
![Page 1: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/1.jpg)
1
GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPSCUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP
R. Michael WhiteGlobal Information Systems, LLC
May 10, 2019
![Page 2: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/2.jpg)
INTRODUCTION• Global Information Systems
• Based in Lexington, KY• Offices in Houston, Kansas City, Atlanta and BANGOR• GIS Services for Pipeline, Railroad, Municipal
• Fayette County, Kentucky• Property Valuation Administrator• Looking for way to inform property owners how
their taxation compares to neighbors• Cut down number of reviews after tax bills go out• Previous year ran a test
• Chance meeting between owner of Global and the PVA
2
![Page 3: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/3.jpg)
PROJECT PARAMETERS
3
• Many thousands of documents to generate
• Data provided as CSV Files
• Use template Word/Publisher documents
• Avoid hand-editing of final product
• PDF generation in ArcGIS designed just as export of layout
• Need simple interface to select and generate batches of documents
• Formatted for bulk mailing
![Page 4: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/4.jpg)
COMPONENTS OF THE DOCUMENT – FRONT PAGE
4
• Full Color• Uses Word/Publisher template, PDF with text added• Owner info• Property info• Comparable sales• Link to online property records• Building/Property photo• Mailing address block
• USPS Bar Codes – removed• Had to be exactly correct location when printed
• Replaced text
![Page 5: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/5.jpg)
FRONT PAGE
5
![Page 6: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/6.jpg)
COMPONENTS OF THE DOCUMENT – BACK PAGE
6
• Monochrome to save printing expense
• Map of Neighborhood (highlighted)
• Target property call-out
• Recent Sales callouts• Maximum 36 call-outs, most recent first• Street address, sale price, assessed value• Call-out blocks vary in width• Finding a way to prevent leaders from crossing was a major issue!
• Key street names
![Page 7: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/7.jpg)
BACK PAGE
7
![Page 8: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/8.jpg)
TOOLS UTILIZED
8
• ArcObjects• Customization of ArcGIS Desktop
using VS C#• User Interface• Data loading• Build maps• Build front pages• Combine to make final
• Able to integrate a wide variety of tools to make a unified product
![Page 9: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/9.jpg)
TOOLS UTILIZED
9
• Use XML support file• Modification of XML used for
Assessor Tools™• Contains
• Folder Paths and File Names• Replacement text• Layer info• Template file names• Feature Info
• Customer can modify as needed• Named similar to mxd file, different extension
![Page 10: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/10.jpg)
TOOLS UTILIZED
10
• Processing CSV Files• Issues with consistency of format• Ultimately had to settle on a specific format from
year to year• Use GenericParsing C# library
• Fast and efficient• Relatively easy coding• Many options to handle different CSV formats
• Missing data caused problems
![Page 11: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/11.jpg)
TOOLS UTILIZED
11
• PDF generation• ArcGIS not suitable• Custom code to build front page
• Tax information• Photo• Comparables
• Third-party library for front page • QuickPDF
• Use PDF created from template Word file as basis, add custom elements
• Combine front and back pages as last step• Required creation of two source files and one final file
![Page 12: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/12.jpg)
ISSUES
12
• Paths• Program needs to know where to find files
• Many text formatting issues• Dates• Money
• Vagaries of ArcObjects• Example: text styling and callouts• Memory leaks In ArcGIS/ArcObjects
• Modified dialog to select multiple parcels by neighborhood• Data issues
• Problems when data from different CSV files out of synch• Problems when parcel data incorrect
![Page 13: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/13.jpg)
FINAL PRODUCT
13
![Page 14: GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION · 1 GENERATING INDIVIDUALIZED TAX ASSESSMENT INFORMATION MAPS CUSTOMIZING ARCGIS DESKTOP TO BUILD MORE THAN A MAP. R. Michael](https://reader030.vdocuments.us/reader030/viewer/2022040601/5e9094dbca7e2f10e06737ef/html5/thumbnails/14.jpg)
CONCLUSION
• Now in third year of production• Many thousands of documents generated and mailed• Almost no format changes year to year• Customer able to modify XML as needed without
assistance• Future may load data directly from CAMA system
database• Most important: positive results from property owners
14