Skip to content

Link Evictions to Owners #33

@ericrobskyhuntley

Description

@ericrobskyhuntley

We have a previous workflow in place (see process_link_filings() in R/filing_linkers.R). This 1) does basic text processing 2) joins on address/city, 3) joins on address/zip, 3) joins on location within a parcel. There are several issues here:

  1. this ties to location, not owners, meaning that we wind up with filings linked to a parcel that an entity might no longer own.
  2. it's a wreck with condo ownership and other cases where there are multiple properties on a parcel
  3. it relies on geocoder result accuracy.

As such, new workflow should look like this:

  1. tie address to address in addresses table (or append if not found).
  2. if address not found (or if existing address has no location), associate parcel loc_id with address.
  3. join to owners on name/address.
  4. join to owners on name (cosine similarity)/address.
  5. for those filings unmatched in 3-4, match by name within parcel.

Metadata

Metadata

Labels

No labels
No labels

Projects

Status

Backlog

Relationships

None yet

Development

No branches or pull requests

Issue actions