NYCPlanning / db-equitable-development-tool

Data Repo for the equitable development tool (EDDT)
MIT License
0 stars 0 forks source link

Residential evictions executed by city marshals #51

Open AmandaDoyle opened 2 years ago

AmandaDoyle commented 2 years ago

Description: Number of residential evictions executed by marshal

Logic:

Source(s): https://data.cityofnewyork.us/City-Government/Evictions/6z8x-wfk4

Year(s):

Geographies:

Race and ethnicity breakdown: No Denominator:

SME: HPD

Questions:

Roadblocks:

SashaWeinstein commented 2 years ago

Around 90% of the evictions have a lat/long and can be assigned to a PUMA without geocoding. The evictions without coordinates seem to be mostly misspellings and records with addresses like "1013 EAST 96TH STREET - BASEMENT-REAR ROOM" Should we try to geocode these 10% of records? Around 6.3k evictions

AmandaDoyle commented 2 years ago

Yes, if it's low hanging fruit we should try to geocode the records and increase the percentage of records with lat/longs and/or add PUMA info from GeoSupport

SashaWeinstein commented 2 years ago

Geocoding is documented in issue #63.

I don't know if writing tests for this indicator really makes sense as I don't know how to run the tests in a container in github actions. If unit tests are written here are two I think could be helpful:

  1. Ensure the PUMA assigned from the geocoding matches the borough of the eviction
  2. Make sure that total evictions citywide equals sum of evictions across all boroughs. Assume each eviction gets a borough, we know this not to be true for PUMAs
SashaWeinstein commented 2 years ago

Hey @AmandaDoyle is evictions a suitable indicator label? evictionscitymarshals seems a little wordy. We also have an eviction cases filed indicator but that indicator has "filings" in the label

levysamu commented 2 years ago

What are you all using to calculate the rate for this indicator? Are you using the units_occupied field that comes from PUMS?

AmandaDoyle commented 2 years ago

@levysamu we aren't calculating a rate. This is just a count.

levysamu commented 2 years ago

Ok, so we don't have the information to populate the below screenshot?

image

AmandaDoyle commented 2 years ago

Correct, as you saw in the email with HPD from Mon 2/28/2022 it was decided it would be inappropriate to calculate the rate. Leaving comment for documentation purposes.