sheds
Brook Frye
10/23/2020
Using data pulled from the sheds dashboard and open data
- https://www1.nyc.gov/assets/buildings/html/sidewalk-shed-map.html
- https://data.cityofnewyork.us/Housing-Development/DOB-Permit-Issuance/ipu4-2q9a
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 1.0 153.0 308.0 371.1 366.0 4389.0
## activity N
## 1: Local Law 11 523
## 2: Construction or Maintenance 1353How many sheds per day go up?
using historical data, we can see that there’s a seasonal pattern, where more sheds go up in the early summer. The trend seems to be pretty constant and doesn’t seem to be increasing year to year. 
How many sheds have gone up during the pandemic?
There was a big decrease in sheds going up during this time 
Is there a correlation between age of building and how long a shed goes up?
Not sure how trustworthy the “year built” field is in the pluto data, data is pretty noisy 
Is there a correlation between the year it was first altered?
Similar pattern to the plot above, the two date are correlated 
Is there a correlation between DOB violations and how long a shed stays up?
There’s a curious separation in the data between sheds that stay up < 1000 days & more than 1000 days 
There are 69 properties with liens
XG boost/random forest model that predicts length of time a shed goes up
## [1] train-rmse:474.632782
## [2] train-rmse:446.396027
## [3] train-rmse:422.440094
## [4] train-rmse:399.010620
## [5] train-rmse:375.755005
## [6] train-rmse:356.793518
## [7] train-rmse:338.974213
## [8] train-rmse:321.404022
## [9] train-rmse:304.202545
## [10] train-rmse:291.094788
## [11] train-rmse:279.476288
## [12] train-rmse:267.963135
## [13] train-rmse:259.827332
## [14] train-rmse:248.346756
## [15] train-rmse:238.772369
## [16] train-rmse:231.013794
## [17] train-rmse:223.924500
## [18] train-rmse:216.143967
## [19] train-rmse:209.621490
## [20] train-rmse:203.375916
## [21] train-rmse:197.126572
## [22] train-rmse:191.412140
## [23] train-rmse:187.422180
## [24] train-rmse:182.706985
## [25] train-rmse:177.876053
## [26] train-rmse:174.364014
## [27] train-rmse:171.034058
## [28] train-rmse:167.680099
## [29] train-rmse:164.691544
## [30] train-rmse:161.726700
## [31] train-rmse:159.898911
## [32] train-rmse:156.651123
## [33] train-rmse:153.850342
## [34] train-rmse:150.816910
## [35] train-rmse:148.472824
## [36] train-rmse:146.098160
## [37] train-rmse:143.485580
## [38] train-rmse:141.345108
## [39] train-rmse:139.015045
## [40] train-rmse:137.437027
## [41] train-rmse:135.558456
## [42] train-rmse:133.697601
## [43] train-rmse:132.218079
## [44] train-rmse:130.424423
## [45] train-rmse:129.086761
## [46] train-rmse:127.461960
## [47] train-rmse:126.379997
## [48] train-rmse:124.779182
## [49] train-rmse:123.387245
## [50] train-rmse:122.354019
## [51] train-rmse:121.029770
## [52] train-rmse:120.077904
## [53] train-rmse:119.128944
## [54] train-rmse:117.778114
## [55] train-rmse:117.030472
## [56] train-rmse:116.153152
## [57] train-rmse:115.233597
## [58] train-rmse:114.599937
## [59] train-rmse:114.150215
## [60] train-rmse:113.440010
## [61] train-rmse:112.708923
## [62] train-rmse:111.847870
## [63] train-rmse:111.158813
## [64] train-rmse:110.827293
## [65] train-rmse:110.433907
## [66] train-rmse:110.023315
## [67] train-rmse:109.588371
## [68] train-rmse:109.102058
## [69] train-rmse:108.606346
## [70] train-rmse:108.272324
## [71] train-rmse:107.777809
## [72] train-rmse:107.517853
## [73] train-rmse:106.997688
## [74] train-rmse:106.488777
## [75] train-rmse:106.177162
## [76] train-rmse:105.869629
## [77] train-rmse:105.763794
## [78] train-rmse:105.413521
## [79] train-rmse:105.159462
## [80] train-rmse:104.832588
## [81] train-rmse:104.702232
## [82] train-rmse:104.494888
## [83] train-rmse:104.214455
## [84] train-rmse:103.946312
## [85] train-rmse:103.597275
## [86] train-rmse:103.532310
## [87] train-rmse:103.267296
## [88] train-rmse:103.190453
## [89] train-rmse:102.953819
## [90] train-rmse:102.699249
## [91] train-rmse:102.447105
## [92] train-rmse:102.312256
## [93] train-rmse:102.131714
## [94] train-rmse:101.864830
## [95] train-rmse:101.772842
## [96] train-rmse:101.700058
## [97] train-rmse:101.677116
## [98] train-rmse:101.584778
## [99] train-rmse:101.461311
## [100] train-rmse:101.429657
## [101] train-rmse:101.064445
## [102] train-rmse:101.010460
## [103] train-rmse:100.813950
## [104] train-rmse:100.548965
## [105] train-rmse:100.494965
## [106] train-rmse:100.417732
## [107] train-rmse:100.194252
## [108] train-rmse:100.151756
## [109] train-rmse:100.098259
## [110] train-rmse:100.009880
## [111] train-rmse:99.956032
## [112] train-rmse:99.937782
## [113] train-rmse:99.978447
## [114] train-rmse:99.892601
## [115] train-rmse:99.758461
## [116] train-rmse:99.731415
## [117] train-rmse:99.639053
## [118] train-rmse:99.654121
## [119] train-rmse:99.684357
## [120] train-rmse:99.537086
## [121] train-rmse:99.493843
## [122] train-rmse:99.455994
## [123] train-rmse:99.497574
## [124] train-rmse:99.465538
## [125] train-rmse:99.433990
## [126] train-rmse:99.384506
## [127] train-rmse:99.338150
## [128] train-rmse:99.128777
## [129] train-rmse:99.074631
## [130] train-rmse:99.063911
## [131] train-rmse:99.080795
## [132] train-rmse:99.112480
## [133] train-rmse:99.024918
## [134] train-rmse:98.992157
## [135] train-rmse:98.979340
## [136] train-rmse:98.900047
## [137] train-rmse:98.887337
## [138] train-rmse:98.894524
## [139] train-rmse:98.969780
## [140] train-rmse:98.861290
## [141] train-rmse:98.796616
## [142] train-rmse:98.778984
## [143] train-rmse:98.771400
## [144] train-rmse:98.784378
## [145] train-rmse:98.763664
## [146] train-rmse:98.706543
## [147] train-rmse:98.695442
## [148] train-rmse:98.708153
## [149] train-rmse:98.736671
## [150] train-rmse:98.722473
## [151] train-rmse:98.731873
## [152] train-rmse:98.819603
## [153] train-rmse:98.742645
## [154] train-rmse:98.809013
## [155] train-rmse:98.867584
## [156] train-rmse:98.939224
## [157] train-rmse:98.766258
## [158] train-rmse:98.633720
## [159] train-rmse:98.645164
## [160] train-rmse:98.606384
## [161] train-rmse:98.464439
## [162] train-rmse:98.400620
## [163] train-rmse:98.435493
## [164] train-rmse:98.384537
## [165] train-rmse:98.316360
## [166] train-rmse:98.411789
## [167] train-rmse:98.360786
## [168] train-rmse:98.335579
## [169] train-rmse:98.276527
## [170] train-rmse:98.331245
## [171] train-rmse:98.408028
## [172] train-rmse:98.360672
## [173] train-rmse:98.431496
## [174] train-rmse:98.409027
## [175] train-rmse:98.399879
## [176] train-rmse:98.232338
## [177] train-rmse:98.256454
## [178] train-rmse:98.296593
## [179] train-rmse:98.280846
## [180] train-rmse:98.288651
## [181] train-rmse:98.315620
## [182] train-rmse:98.275986
## [183] train-rmse:98.206482
## [184] train-rmse:98.149529
## [185] train-rmse:98.139397
## [186] train-rmse:98.099846
## [187] train-rmse:98.065224
## [188] train-rmse:98.111229
## [189] train-rmse:98.054695
## [190] train-rmse:98.109230
## [191] train-rmse:98.126869
## [192] train-rmse:98.050690
## [193] train-rmse:98.193008
## [194] train-rmse:98.229980
## [195] train-rmse:98.185364
## [196] train-rmse:98.104706
## [197] train-rmse:98.074379
## [198] train-rmse:98.050705
## [199] train-rmse:98.030525
## [200] train-rmse:98.026642
## [201] train-rmse:98.020676
## [202] train-rmse:97.999924
## [203] train-rmse:97.974937
## [204] train-rmse:97.989677
## [205] train-rmse:97.974304
## [206] train-rmse:97.933968
## [207] train-rmse:97.937851
## [208] train-rmse:98.014832
## [209] train-rmse:98.044411
## [210] train-rmse:98.012703
## [211] train-rmse:98.008743
## [212] train-rmse:98.081413
## [213] train-rmse:97.983658
## [214] train-rmse:98.049652
## [215] train-rmse:98.009438
## [216] train-rmse:97.980309
## [217] train-rmse:97.966743
## [218] train-rmse:97.942421
## [219] train-rmse:97.929466
## [220] train-rmse:98.049461
## [221] train-rmse:97.955086
## [222] train-rmse:98.083618
## [223] train-rmse:98.104294
## [224] train-rmse:98.006500
## [225] train-rmse:98.077263
## [226] train-rmse:98.087166
## [227] train-rmse:97.982384
## [228] train-rmse:98.009140
## [229] train-rmse:98.059784
## [230] train-rmse:98.177116
## [231] train-rmse:98.151123
## [232] train-rmse:98.127846
## [233] train-rmse:98.149155
## [234] train-rmse:98.050728
## [235] train-rmse:97.997841
## [236] train-rmse:97.966454
## [237] train-rmse:97.956215
## [238] train-rmse:98.028214
## [239] train-rmse:98.067902
## [240] train-rmse:98.093353
## [241] train-rmse:98.058838
## [242] train-rmse:98.089935
## [243] train-rmse:98.116898
## [244] train-rmse:98.094337
## [245] train-rmse:98.086517
## [246] train-rmse:98.071968
## [247] train-rmse:98.025253
## [248] train-rmse:98.101822
## [249] train-rmse:98.099113
## [250] train-rmse:98.058739
## [251] train-rmse:97.996635
## [252] train-rmse:98.001862
## [253] train-rmse:97.948395
## [254] train-rmse:97.955559
## [255] train-rmse:97.933403
## [256] train-rmse:97.904633
## [257] train-rmse:97.965538
## [258] train-rmse:98.094986
## [259] train-rmse:98.034935
## [260] train-rmse:98.054863
## [261] train-rmse:98.065514
## [262] train-rmse:98.089455
## [263] train-rmse:98.085503
## [264] train-rmse:98.080048
## [265] train-rmse:98.044838
## [266] train-rmse:98.136353
## [267] train-rmse:98.045349
## [268] train-rmse:98.098656
## [269] train-rmse:98.145073
## [270] train-rmse:98.230743
## [271] train-rmse:98.190727
## [272] train-rmse:98.145256
## [273] train-rmse:98.242767
## [274] train-rmse:98.225105
## [275] train-rmse:98.185669
## [276] train-rmse:98.112274
## [277] train-rmse:98.148338
## [278] train-rmse:98.228752
## [279] train-rmse:98.264343
## [280] train-rmse:98.212990
## [281] train-rmse:98.136978
## [282] train-rmse:98.149406
## [283] train-rmse:98.108681
## [284] train-rmse:98.067116
## [285] train-rmse:98.031776
## [286] train-rmse:97.995224
## [287] train-rmse:97.979668
## [288] train-rmse:97.983482
## [289] train-rmse:98.063492
## [290] train-rmse:97.985298
## [291] train-rmse:97.997124
## [292] train-rmse:98.130058
## [293] train-rmse:98.127052
## [294] train-rmse:98.118927
## [295] train-rmse:98.057396
## [296] train-rmse:98.143997
## [297] train-rmse:98.307343
## [298] train-rmse:98.234894
## [299] train-rmse:98.369370
## [300] train-rmse:98.325287
## [301] train-rmse:98.373703
## [302] train-rmse:98.402153
## [303] train-rmse:98.337395
## [304] train-rmse:98.195236
## [305] train-rmse:98.123688
## [306] train-rmse:98.155426
## [307] train-rmse:98.213173
## [308] train-rmse:98.205345
## [309] train-rmse:98.354774
## [310] train-rmse:98.301834
## [311] train-rmse:98.196098
## [312] train-rmse:98.348694
## [313] train-rmse:98.265015
## [314] train-rmse:98.150093
## [315] train-rmse:98.276169
## [316] train-rmse:98.220177
## [317] train-rmse:98.192451
## [318] train-rmse:98.155815
## [319] train-rmse:98.419174
## [320] train-rmse:98.529350
## [321] train-rmse:98.580544
## [322] train-rmse:98.641106
## [323] train-rmse:98.658623
## [324] train-rmse:98.579720
## [325] train-rmse:98.650284
## [326] train-rmse:98.636482
## [327] train-rmse:98.457916
## [328] train-rmse:98.550453
## [329] train-rmse:98.462639
## [330] train-rmse:98.621857
## [331] train-rmse:98.484436
## [332] train-rmse:98.387489
## [333] train-rmse:98.296043
## [334] train-rmse:98.139099
## [335] train-rmse:98.171997
## [336] train-rmse:98.207840
## [337] train-rmse:98.223587
## [338] train-rmse:98.346077
## [339] train-rmse:98.243271
## [340] train-rmse:98.194962
## [341] train-rmse:98.325012
## [342] train-rmse:98.241417
## [343] train-rmse:98.122658
## [344] train-rmse:98.163132
## [345] train-rmse:98.253975
## [346] train-rmse:98.116577
## [347] train-rmse:98.186218
## [348] train-rmse:98.190193
## [349] train-rmse:98.149147
## [350] train-rmse:98.120010
## [351] train-rmse:98.141083
## [352] train-rmse:98.125916
## [353] train-rmse:98.142250
## [354] train-rmse:98.118111
## [355] train-rmse:98.158203
## [356] train-rmse:98.184921
## [357] train-rmse:98.167435
## [358] train-rmse:98.231895
## [359] train-rmse:98.160034
## [360] train-rmse:98.188850
## [361] train-rmse:98.197937
## [362] train-rmse:98.271484
## [363] train-rmse:98.360291
## [364] train-rmse:98.473083
## [365] train-rmse:98.427734
## [366] train-rmse:98.314819
## [367] train-rmse:98.257019
## [368] train-rmse:98.327904
## [369] train-rmse:98.398376
## [370] train-rmse:98.276169
## [371] train-rmse:98.305580
## [372] train-rmse:98.435631
## [373] train-rmse:98.492775
## [374] train-rmse:98.560104
## [375] train-rmse:98.492645
## [376] train-rmse:98.435555
## [377] train-rmse:98.540901
## [378] train-rmse:98.564049
## [379] train-rmse:98.406013
## [380] train-rmse:98.295273
## [381] train-rmse:98.296043
## [382] train-rmse:98.175835
## [383] train-rmse:98.086670
## [384] train-rmse:98.139740
## [385] train-rmse:98.162186
## [386] train-rmse:98.204796
## [387] train-rmse:98.248474
## [388] train-rmse:98.233551
## [389] train-rmse:98.339142
## [390] train-rmse:98.393028
## [391] train-rmse:98.517143
## [392] train-rmse:98.487282
## [393] train-rmse:98.422203
## [394] train-rmse:98.306145
## [395] train-rmse:98.309448
## [396] train-rmse:98.331795
## [397] train-rmse:98.281052
## [398] train-rmse:98.345177
## [399] train-rmse:98.215424
## [400] train-rmse:98.233261
## [401] train-rmse:98.247826
## [402] train-rmse:98.175140
## [403] train-rmse:98.214218
## [404] train-rmse:98.227890
## [405] train-rmse:98.193398
## [406] train-rmse:98.226662
## [407] train-rmse:98.153419
## [408] train-rmse:98.166428
## [409] train-rmse:98.150032
## [410] train-rmse:98.234291
## [411] train-rmse:98.189331
## [412] train-rmse:98.214005
## [413] train-rmse:98.337021
## [414] train-rmse:98.438728
## [415] train-rmse:98.479668
## [416] train-rmse:98.375610
## [417] train-rmse:98.319061
## [418] train-rmse:98.315735
## [419] train-rmse:98.188332
## [420] train-rmse:98.149223
## [421] train-rmse:98.197548
## [422] train-rmse:98.219856
## [423] train-rmse:98.185234
## [424] train-rmse:98.240524
## [425] train-rmse:98.261566
## [426] train-rmse:98.335770
## [427] train-rmse:98.251564
## [428] train-rmse:98.285530
## [429] train-rmse:98.186707
## [430] train-rmse:98.157013
## [431] train-rmse:98.016922
## [432] train-rmse:98.031746
## [433] train-rmse:98.052185
## [434] train-rmse:98.055855
## [435] train-rmse:98.100586
## [436] train-rmse:98.209312
## [437] train-rmse:98.092667
## [438] train-rmse:98.217720
## [439] train-rmse:98.174530
## [440] train-rmse:98.165047
## [441] train-rmse:98.251564
## [442] train-rmse:98.149849
## [443] train-rmse:98.239670
## [444] train-rmse:98.213974
## [445] train-rmse:98.242737
## [446] train-rmse:98.249649
## [447] train-rmse:98.288391
## [448] train-rmse:98.256058
## [449] train-rmse:98.403999
## [450] train-rmse:98.556076
## [451] train-rmse:98.558144
## [452] train-rmse:98.650208
## [453] train-rmse:98.638657
## [454] train-rmse:98.413879
## [455] train-rmse:98.299324
## [456] train-rmse:98.287910
## [457] train-rmse:98.209442
## [458] train-rmse:98.181099
## [459] train-rmse:98.194466
## [460] train-rmse:98.160324
## [461] train-rmse:98.169090
## [462] train-rmse:98.162918
## [463] train-rmse:98.145668
## [464] train-rmse:98.275932
## [465] train-rmse:98.268166
## [466] train-rmse:98.332458
## [467] train-rmse:98.378731
## [468] train-rmse:98.370163
## [469] train-rmse:98.461372
## [470] train-rmse:98.280266
## [471] train-rmse:98.271835
## [472] train-rmse:98.275345
## [473] train-rmse:98.182060
## [474] train-rmse:98.107536
## [475] train-rmse:98.033234
## [476] train-rmse:98.005890
## [477] train-rmse:97.981247
## [478] train-rmse:97.932701
## [479] train-rmse:97.930931
## [480] train-rmse:97.883522
## [481] train-rmse:97.914146
## [482] train-rmse:97.960953
## [483] train-rmse:97.972702
## [484] train-rmse:98.056831
## [485] train-rmse:98.138596
## [486] train-rmse:98.064468
## [487] train-rmse:98.008011
## [488] train-rmse:98.017570
## [489] train-rmse:98.092880
## [490] train-rmse:98.140030
## [491] train-rmse:98.249641
## [492] train-rmse:98.251396
## [493] train-rmse:98.324776
## [494] train-rmse:98.389656
## [495] train-rmse:98.248146
## [496] train-rmse:98.259201
## [497] train-rmse:98.187500
## [498] train-rmse:98.137009
## [499] train-rmse:98.164261
## [500] train-rmse:98.135468
## [1] 174299.3
Top 20 bbls with sheds up longest amount of time
## length_time bbl
## 1: 4389 days 1001530001
## 2: 4243 days 1001930033
## 3: 3233 days 2025860026
## 4: 2887 days 1017870001
## 5: 2877 days 1019920013
## 6: 2664 days 1000770024
## 7: 2618 days 1008627503
## 8: 2512 days 4004250005
## 9: 2507 days 2036420001
## 10: 2477 days 1005227501
## 11: 2401 days 1001747505
## 12: 2186 days 1011420061
## 13: 2148 days 1010100025
## 14: 2148 days 1010100000
## 15: 2139 days 1005307508
## 16: 2081 days 1008550016
## 17: 2054 days 3021050001
## 18: 2023 days 3067740059
## 19: 2023 days 3067740055
## 20: 1990 days 1015100057Data is sourced from: - Complaints: https://data.cityofnewyork.us/Housing-Development/DOB-Complaints-Received/eabe-havv - Liens: https://data.cityofnewyork.us/City-Government/Tax-Lien-Sale-Lists/9rz4-mjek - Open Balance: https://data.cityofnewyork.us/City-Government/DOF-Property-Charges-Balance/scjx-j6np - Sales: https://data.cityofnewyork.us/dataset/NYC-Citywide-Rolling-Calendar-Sales/usep-8jbt