My boss has asked me to look into using ArcMap to see how proximity to schools is affecting property values. Obviously they do, but he wants a brief analysis and a pretty map to show our county commissioners. I'm working with the appraisers in my office to understand "influences" but I wanted to check in here as well and see if anyone else has experience with a project like this? What tools did you use, and how did you use CAMA reports if at all?
This is a great question and I'm looking into it. I think that school district may just be a property characteristic used in the regression analysis. That analysis outputs the impact of each individual characteristic on value like a fireplace or swimming pool.
There are a few options you could try. Brent suggested regression analysis, which would estimate how much (if at all) certain school districts impact value (on average). From the CAMA perspective, lots of this information is hiding inside of our location adjustments. Make sure someone with spatial regression analysis is included in this process, otherwise you can come up with some pretty funky and misleading results (especially with all of the other factors correlated with location).
For the purposes you describe, you may just be fine with a map. I would recommend using the analysis feature in ArcGIS Online or ArcGIS Pro. Assuming you have a layer with the district boundaries, you can upload this with a spreadsheet of validated, arm's-length sales, merge the two, and then fill in the polygons with different colors that can convey information about the markets (e.g. median price per square foot). It's important to note with your maps that readers do not draw false conclusions and that there could be other locational influences or physical characteristics impacting values. If you end up going down a route where you are calculating school district adjustments for CAMA purposes, you definitely want to have someone with specific regression experience do this. Hope this helps! 🙂