-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathEDA_Final.html
271 lines (221 loc) · 13.8 KB
/
EDA_Final.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
<!DOCTYPE HTML>
<!--
Phantom by HTML5 UP
html5up.net | @ajlkn
Free for personal and commercial use under the CCA 3.0 license (html5up.net/license)
-->
<html>
<head>
<title></title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no" />
<link rel="stylesheet" href="assets/css/main.css" />
<noscript><link rel="stylesheet" href="assets/css/noscript.css" /></noscript>
</head>
<body class="is-preload" style="background-color:white">
<!-- Wrapper -->
<div id="wrapper">
<!-- Header -->
<header id="header">
<div class="inner">
<!-- Pages -->
<div class = "topnav"><a href="index.html">Work</a>
<div class = "topnav-right">
<a href="about_me.html">About Me</a>
</div>
</div>
</div>
</header>
<!-- Main -->
<div id="main">
<div class="inner">
<h1>Estimating Informal Basement Apartment Flooding Risk</h1>
<span class="image right"><img src="images/flooding_overtime.gif" alt="" /></span>
<p style="page-break-before: always;"> </p>
<h2>Problem Statement </h2>
<p class = "text-primary"> When Hurricane Ida struck New York City in 2021, eleven people drowned after their basement apartments flooded. Informal basement units are a large and growing problem across the city, where more than 100,000 such units are estimated to exist. These units are overwhelmingly concentrated in BIPOC, low-income, and immigrant communities, per a Pratt Center analysis. </p>
<b>Skills Used:</b>
<p> R (dplyr, tidyr, sf, ggplot), Project Management, Presentation </p>
<h4>Questions: </h4>
<ol>
<li>Where are informal basement units concentrated in New York City? </li>
<li>How does the distribution of informal basement units interact with flood risk?</li>
</ol>
<h2>Estimating Informal Basements</h2>
<p class = "text-primary"> Basements that are above grade can be considered more likely to be legal residences,as these units are more easily capable of complying with DOB regulations for basement units (eg.light, airflow, drainage). Basements that are below grade and full size (ie. at least 75% of the floor area of the first floor) can be assumed to be the most likely candidates for informal basement units.These units are large enough to provide ample space for a residential unit, but are more prone to flooding due to sitting below street level. For the purposes of this project, we will assume that buildings with full, below grade basements are candidates for informal units. This is a rough assumption that likely oversimplifies the reality,but given the lack of clear data, this model will allow us to narrow down our study somewhat in hopes of identifying the most at-risk data. Given this assumption, there are 456,804 buildings across the five boroughs that could potentially contain informal basement apartments.
</p>
<div class="table-wrapper">
<table>
<thead>
<tr>
<th>Basement Grade</th>
<th>Basement Size</th>
<th># Units</th>
</tr>
</thead>
<tbody>
<tr>
<td>Above Grade</td>
<td>Full</td>
<td>146,815</td>
</tr>
<tr>
<td>Above Grade</td>
<td>Partial</td>
<td>1,535</td>
</tr>
<tr>
<td><b>Below Grade</b></td>
<td><b>Full</b></td>
<td><b>456,804</b></td>
</tr>
<tr>
<td>Below Grade</td>
<td>Partial</td>
<td>4,728</td>
</tr>
</tbody>
</table>
</div>
<div class="slideshow-container">
<!-- Full-width images with number and caption text -->
<div class="mySlides fade">
<div class="numbertext">1 / 3</div>
<img src="images/bldgs_possible_illeg_basemts_n.png" style="width:100%">
</div>
<div class="mySlides fade">
<div class="numbertext">2 / 3</div>
<img src="images/bldgs_possible_illegal.png" style="width:100%">
</div>
<div class="mySlides fade">
<div class="numbertext">3 / 3</div>
<img src="/images/bldgs_possible_illegal_ct.png" style="width:100%">
</div>
<!-- Next and previous buttons -->
<a class="prevgrey" onclick="plusSlides(-1)">❮</a>
<a class="nextgrey" onclick="plusSlides(1)">❯</a>
</div>
<br>
<!-- The dots/circles -->
<div style="text-align:center">
<span class="dot" onclick="currentSlide(1)"></span>
<span class="dot" onclick="currentSlide(2)"></span>
<span class="dot" onclick="currentSlide(3)"></span>
</div>
<h2>Quantifying Informal Basement Apartment Risk</h2>
<p>Data from the US Census Bureau was pulled in order to quantify vulnerability. We calculated the percent of census tract that were noted as immigrants, percentages of non-white residents, and income levels across the five boroughs. </p>
<div class="box alt">
<div class="row gtr-uniform">
<div class="col-4"><span class="image fit"><img src="images/immigrant.png" alt="" /></span></div>
<div class="col-4"><span class="image fit"><img src="images/minority.png" alt="" /></span></div>
<div class="col-4"><span class="image fit"><img src="images/income.png" alt="" /></span></div>
</div>
</div>
<h2>Final Vulnerability Scores</h2>
<p>Finally, using all vulnerability layers and risk projections, we conducted a Multi-Criterion Decision Analysis (MCDA) to determine final scores for each densus tract. A maximum of 6 and minimum of 1 was assigned to each layer, with highest scores appearing in bright yellow.</p>
<img src="images/MCDA_2.png" style="width:70%" class = "center">
<p>The majority of census tracts with particularly vulnerable communities are in Queens. Therefore, we recommend resources be allocated to these particular census tracts, particularly in events of extreme flood.</p>
<div class="table-wrapper">
<table>
<thead>
<tr>
<th>Census Tract, Borough</th>
<th>NTA Name</th>
<th>Immigrant Vulnerability</th>
<th>Income Vulnerability</th>
<th>Minority Vulnerability</th>
<th>Informal Apartments in Floodplain</th>
<th>Final Score</th>
</tr>
</thead>
<tbody>
<tr>
<td>Tract 454, Queens</td>
<td>Briarwood-Jamaica Hills</td>
<td>6</td>
<td>5</td>
<td>6</td>
<td>5</td>
<td>22</td>
</tr>
<tr>
<td>Tract 479, Queens</td>
<td>Elmhurst-Maspeth</td>
<td>6</td>
<td>5</td>
<td>5</td>
<td>6</td>
<td>22</td>
</tr>
<tr>
<td>Tract 869, Queens</td>
<td>Flushing</td>
<td>6</td>
<td>6</td>
<td>6</td>
<td>4</td>
<td>22</td>
</tr>
<tr>
<td>Tract 254, Queens</td>
<td>South Jamaica</td>
<td>4</td>
<td>6</td>
<td>6</td>
<td>6</td>
<td>22</td>
</tr>
<tr>
<td>Tract 470, Queens</td>
<td>Jamaica</td>
<td>6</td>
<td>4</td>
<td>6</td>
<td>6</td>
<td>22</td>
</tr>
<tr>
<td>Tract 104, Brooklyn</td>
<td>Sunset Park East</td>
<td>6</td>
<td>6</td>
<td>6</td>
<td>3</td>
<td>21</td>
<td></td>
</tr>
</tbody>
</table>
</div>
<p class = "text-primary"> For a more in depth look at the code, see <a href="/final_project.html"> markdown document here. </a></p>
<p class = "text-primary"> Project completed with <a href="https://www.linkedin.com/in/erikstrand2/"> Erik Strand</a> and <a href = "https://www.linkedin.com/in/tamim-abedin-816545123/"> Tamim Abedin </a> for <a href = "https://www.arch.columbia.edu/faculty/301-peter-marcotullio"> Peter Marcotullio</a> and <a href = "https://www.linkedin.com/in/kazukisakamoto/"> Kaz Sakamoto's </a> Fall 2021 Environmental Data Analysis course. </p>
<p class = "text-primary"> Thumbnail credit: Michael Appleton</p>
</div>
<div>
</div>
</div>
<!-- Footer -->
<footer id="footer">
<div class="inner">
<section>
<h2>Follow</h2>
<ul class="icons">
<li><a href="https://www.linkedin.com/in/sean-chew-urban/" class="icon brands style2 fa-linkedin"><span class="label">Linkedin</span></a></li>
<li><a href="https://github.com/sean-chew/sean-chew" class="icon brands style2 fa-github"><span class="label">GitHub</span></a></li>
<li><a href="mailto:[email protected]" class="icon solid style2 fa-envelope"><span class="label">Email</span></a></li>
</ul>
</section>
<ul class="copyright">
<li>© Untitled. All rights reserved</li><li>Design: <a href="http://html5up.net">HTML5 UP</a></li>
</ul>
</div>
</footer>
</div>
<!-- Scripts -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/browser.min.js"></script>
<script src="assets/js/breakpoints.min.js"></script>
<script src="assets/js/util.js"></script>
<script src="assets/js/main.js"></script>
</body>
</html>