Income-restricted housing units

[AmandaDoyle]

Description: The number of income restricted housing units by geography. Three data points 1) Units with regulatory agreements since 2014, 2) NYCHA units, 3) All income restricted housing

Logic: Units with regulatory agreements since 2014: Source: Housing NY. Sum the total number (all counted units) of income restricted units by geographic area that have a project start date of Jan 1, 2014 or later. Use Community Board to map to PUMA or use lat/long values to do spatial join to PUMA. NYCHA units: report Public Housing Units by PUMA from Equitable Development Data Tool - Displacement Risk Index 2-8-2022.xlsx All income restricted housing: SUM Units with regulatory agreements since 2014 and NYCHA units to report total number at PUMA level

Report count and percent for each value. See screenshot of targeted figma mockup

Source(s): Housing NY Equitable Development Data Tool - Displacement Risk Index 2-8-2022.xlsx

Year(s):

• [ ] 2014-present

Geographies:

• [ ] PUMA
• [ ] Borough
• [ ] City

Race and ethnicity breakdown: No Denominator: 2020 unit counts from census

SME: HPD

Questions:

Roadblocks:

[levysamu]

Sources should include NYCHA. This information was received directly from NYCHA because the data that is currently publicly available is difficult/impossible to parse by NTA. There is a meeting scheduled for 2/7 to hopefully formalize the process by which we will get this information in the future and to finalize more detailed, PUMA level information to share as part of the EDDT (as opposed to the more simple NTA data used for the DRI). Below is what I received from NYCHA (excel) and what I'm expecting from them in the future (table)

Equitable Development Data Tool - Displacement Risk Index 2010 NTA 12.16.2021.xlsx

[levysamu]

For the EDDT (unlike the DRI) I don't think these two sources actually need to be combined to produce a single data point.

[SashaWeinstein]

The regulatory agreement and NYCHA numbers both look good to me. I assume RAD stands for regulatory agreement something, do you know what the "D" stands for?

I need a bit more clarification on the "total" data point. Sam says

"For the EDDT (unlike the DRI) I don't think these two sources actually need to be combined to produce a single data point."

Isn't the total just that though? Also do we add the race crosstabs for the two categories to get race crosstabs for the total?

[levysamu]

It stands for "Rental Assistance Demonstration"

I think I was saying that the All Income Restricted Housing row was unnecessary, since it is just the sum of the other two lines and isn't 100% accurate.

I don't believe this table is broken out by race. There is a different table focused on NYCHA occupants that does.

[SashaWeinstein]

Thanks for the quick reply! Sorry to speak about you in the third person, didn't think about how you would get an email too.

I see now which total you were speaking of, that makes sense to me. I should have been more specific about which spreadsheet I was referencing. The Equitable Development Data Tool - Displacement Risk Index 2-8-2022.xlsx referenced in the issue itself seems to have all the info I need. My plan is to get race crosstab on the total by adding the race crosstabs of the two categories and it should be simple to move forward

[levysamu]

No worries. Below is a screenshot for the two different tables with NYCHA information. Table 1 is related to this github issue. It does not have race/ethnicity data since it is at the unit-level and is not describing the occupants. The All Income-restricted Housing row is not necessary since it is just a sum of the two rows below it. The NYCHA numbers here should reference column B (total unit count) of the table you referenced.

Table 2 is only for NYCHA occupants and is broken out by race and ethnicity. This is where the race/ethnicity data in the table you just referenced belongs.

[levysamu]

We actually do not need to reference the difference between Public Housing Units and RAD at this point in time. We may at a future date, but I think we're going to keep it simple for the time being.

[SashaWeinstein]

Ok great thanks for the clarification. I should have assumed that the crosstabs are for population as units don't have a race.