Beyond the map: Connecting GIS and CAMA to improve assessment
A property record, a building sketch, a sales comparison and a field inspection all describe the same place. Connecting them through location can help assessment offices spend less time moving information and more time understanding it.
Assessment work depends on information moving between people. Property records need to be maintained, building details verified, sales analyzed, inspections completed and broader patterns reviewed.
When records, imagery, sketches and sales data sit in separate applications, each task can involve exporting information, re-entering details or requesting help from another team. The challenge is not a shortage of information, it is the friction between the tools and people who use it.
A computer-assisted mass appraisal (CAMA) system manages property records and valuation processes. A geographic information system (GIS) provides spatial context. Connecting the two makes location part of the assessment workflow, rather than something consulted separately.
In a recent presentation at IAAO, I explored what connecting GIS and CAMA can mean in practice for five people around the assessment office: Alex, a data auditor and collector; Sarah, a residential appraiser; David, a valuation analyst; James, a field appraiser; and Michelle, an assessor. Their responsibilities differ, but each depends on timely, connected property information.
When the map and property record disagree
For Alex, a data auditor and collector, is responsible for reviewing and assessing data quality. He likes to use a map for his visualizing to understand more about the property on one screen and then his CAMA system on another. This allows him to answer the question: Does what is happening on the map for this property and the surrounding properties match what is in the CAMA system?
The challenge he faces is that anytime he makes a change to his CAMA system, he cannot visualize those changes right away. In a disconnected workflow, record changes move through an overnight, weekly or monthly export, data transformation and GIS layer publication. If he wants to verify the change and how it fits in with the bigger picture, he must come back to that same area once the update has been completed and also, when that transformation is.
Assessment Analyst GAMA (AA GAMA) connects the record and map so that the data in your CAMA system is the same data that appears on the map in real time. Edits made in the record or on the map stay synchronized, reducing the need to move and reconcile separate copies of the same information. Whether looking at new valuations for equity or property use codes for consistency, being able to visualize the data and the data changes in real time allows Alex to complete full workflow in one complete journey, rather than having it segmented in two different parts in a disconnected system.
When a sketch needs to reflect the building
Sarah, a residential appraiser, needs to determine whether the existing sketch represents what is on the property and must add a new detached garage to the assessed value. She has access to aerial imagery, a CAMA system and CAD sketching, but they are three separate systems that have some or limited integrations.
In this workflow, Sarah retrieves the sketch, opens imagery elsewhere, measures the building on the imagery using the measure tools, redraws it in CAD and then either updates the area automatically or manually in CAMA. These separate steps require manual intervention and duplicate effort to add the new improvement to the parcel’s overall valuation.
With GeoSketch, the sketch becomes spatial data. Sarah can compare it against georeferenced imagery, draw and classify the garage on the map, and synchronize its area and component type with the assessment record. This single solution provides all the tools and functionality that were used before but reduces the friction of moving between different systems. The important change is not simply a better drawing. It is a closer connection between the building, its location and the information used for assessment.
When comparable sales need more than a table
When a property owner calls asking how their assessment was determined, is filing an appeal or simply wondering what sales are used to support the valuation, David, the valuation analyst, needs to turn to comparable sales to help answer these questions.
Selecting sales by their attributes is only part of the task. Understanding their locations adds another perspective, but a disconnected workflow requires identifying the parameters to generate a comparison sales grid, exporting the results, requesting or creating a separate map to help understand this location, then putting everything together to share the results. David could use free mapping tools like Google Maps, but that means the same flow of having to go back and forth between different systems to generate comparable sales selection.
Meanwhile, a connected, map-based approach, as provided by AA GAMA Comparable Sales, brings candidate sales, selection and comparison together. Whether using a spatially driven algorithm to generate the sales selection or manually selecting the comparables, being able to see them on the map first creates a powerful visualization that provides more clarity and details compared to looking at just a comparable sales grid and then having to map them in a separate mapping application. Bringing the comparison grid and map together helps explain the relationship between the subject property and its comparables for an easier explanation to the property owner.
When fieldwork needs to stay connected
Some property questions require an inspection. That brings James, a field appraiser, into the process. He usually works from downloading data packets that separate the inspection from the office workflow. That download is essentially a snapshot of the data at the time, which means if something changes on the parcel between when he creates the packet and when he goes out into the field, he is then working with stale data. Imagine showing up to a property where you have the wrong owner because someone updated the ownership file back in the office after you created the data packet, or that data update is delayed because the parcel is checked out. As soon as you create that snapshot, the data potentially can be stale. Only after you have made the changes in the field and check the parcels back in can you reconcile the differences.
A connected field workflow links live CAMA data with your mobile device, so whether you are in the field or sitting at your desk, you are looking at live data. The AA GAMA mobile application allows the user back in the office to assign work in real time to the field worker who then can access the most current data set. This allows for the user in the field to update live data and have a co-worker review that information and provide timely feedback about the quality of the work in case any corrections are needed for future properties. Working on a connected mobile device, where field work and office work are using the same data sets, allow for a faster delivery of assessment data from the inspection and review. All property edits, sketches, photographs and any other changes can move in real time from the field to the office or vice-a-versa, so that everyone is always looking at the most current data.
When assessment data needs a broader perspective
Michelle, an assessor, is responsible and accountable for all the assessments within her jurisdiction. She needs to look beyond an individual metric; she needs to ensure that the assessments meet high-quality standards. Based on the data, she wants to discover where and what else are the changes that occurring, and what patterns deserve a closer review.
The typical standard process is a report-request cycle where Michelle needs to export rows and rebuild charts for each question. There are other data visualization options she can leverage to display, but those are solutions that will take Michelle outside of the application, and the data changes will be delayed.
AA GAMA will provide spatial views of values, sales, and market areas, with statistics based on the map view with live CAMA data. Michelle can visualize the data on the map and apply different filters to understand the quality of the data in real time while visualizing it on the map; allowing for the data quality to come to life.
The value is in the connections
Assessment teams have different responsibilities, but their work depends on connected information. Each person's work should inform the next without requiring repeated exports, duplicate entry or manual reconciliation.
The value of connecting GIS and CAMA goes beyond putting assessment data on a map. It brings property information, spatial context and workflows together, helping teams spend less time moving information and more time using it. AA GAMA removes that friction and connects everything through location which helps assessment offices spend less time on moving information and more time understanding it.
To learn more, visit our website or reach out to assessment@esri.ca.