ccao-data / model-res-avm

Automated valuation model for all class 200 residential properties in Cook County (except vacant land and condos)
GNU Affero General Public License v3.0
28 stars 5 forks source link

Add newly collected data as features #110

Closed dfsnow closed 10 months ago

dfsnow commented 11 months ago

The Data Department has created or collected a few additional features since the 2023 model. We need to update the model parameters, ingest, and code to use these new features. They include:

stevevance commented 10 months ago

On corner lots, Chicago Cityscape has a filter for this because some developers may prefer to develop a house on a corner lot given the possibility that they could design a house differently.

The SQL SELECTS the Cook County streets layer with two aliases, selecting all roads with unique names within 40 feet of the parcel line. If there are two or more results, the parcel is assumed to be a corner lot.

Note of caution: the Cook County streets layer has a lot of bad data, i.e. it has not been updated in a while (decades?). I am dealing with it by manually marking some roads as deleted. You may want to find a better-quality roads network data source.

dfsnow commented 10 months ago

We created our own corner feature with a fairly straightforward spatial algorithm. We've already calculated the corners for the whole county and will add the feature to the Open Data portal once it's ready.

Our calculation used OpenStreetMap data for the street layer.

wrridgeway commented 10 months ago

Corner lot has been added through another PR.

wrridgeway commented 10 months ago

@dfsnow is "Home improvement exemption status" already built?

dfsnow commented 10 months ago

@dfsnow is "Home improvement exemption status" already built?

No, that one's a bit more tentative. I need to update PTAXSIM so we can pull the 2022 exemption.

wrridgeway commented 10 months ago

@dfsnow is "Home improvement exemption status" already built?

No, that one's a bit more tentative. I need to update PTAXSIM so we can pull the 2022 exemption.

Alright, perhaps that can be its own issue then. Might as well get secondary roads and airport noise merged in.