Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Link Evictions to Owners #33

Open
ericrobskyhuntley opened this issue Aug 13, 2024 · 0 comments
Open

Link Evictions to Owners #33

ericrobskyhuntley opened this issue Aug 13, 2024 · 0 comments
Assignees
Labels
enhancement New feature or request

Comments

@ericrobskyhuntley
Copy link
Collaborator

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.
@ericrobskyhuntley ericrobskyhuntley added the enhancement New feature or request label Aug 13, 2024
@ericrobskyhuntley ericrobskyhuntley self-assigned this Aug 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant