Sidewalk Management Database - All Tree Damage (ATD)

Sidewalk Management System is used to track and organize inspections, violations and the status of New York City sidewalks.
Tracks properties where all sidewalk defects on the tax lot are due to trees/tree roots (All Tree Defects - ATD)
For more information please visit NYC DOT website: www.nyc.gov/sidewalks

Transportation Department of Transportation (DOT) Dataset j6v2-6uxq 13 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
9890
Atdid: 9890 • Atd Number: ATD-4-4496 • Bblid: 868255
Atdid
9890
Atd Number
ATD-4-4496
Bblid
868255
Inspectionid
335043
Inspect Date
2019-09-13T00:00:00.000
Atdissuedate
2022-04-15T16:24:49.000
Cb
12
House Num
119-19
Onstname
SUTPHIN BLVD.
Atddismissed
No
9993
Atdid: 9993 • Atd Number: ATD-4-4545 • Bblid: 654487
Atdid
9993
Atd Number
ATD-4-4545
Bblid
654487
Inspectionid
335819
Inspect Date
2022-04-19T00:00:00.000
Atdissuedate
2022-04-29T13:56:05.000
Cb
6
House Num
64-73
Onstname
ELLWELL CRES
Atddismissed
No
10431
Atdid: 10431 • Atd Number: ATD-2-934 • Bblid: 240750
Atdid
10431
Atd Number
ATD-2-934
Bblid
240750
Inspectionid
339252
Inspect Date
2022-07-09T00:00:00.000
Atdissuedate
2022-07-12T12:16:48.000
Cb
10
House Num
82
Onstname
BUCKLEY ST.
Atddismissed
No
12639
Atdid: 12639 • Atd Number: ATD-4-5380 • Bblid: 568209
Atdid
12639
Atd Number
ATD-4-5380
Bblid
568209
Inspectionid
358940
Inspect Date
2023-06-23T00:00:00.000
Atdissuedate
2023-06-23T12:08:07.000
Cb
2
House Num
4507
Onstname
COURT SQ.
Atddismissed
No
10102
Atdid: 10102 • Atd Number: ATD-4-4602 • Bblid: 775303
Atdid
10102
Atd Number
ATD-4-4602
Bblid
775303
Inspectionid
336501
Inspect Date
2022-04-29T00:00:00.000
Atdissuedate
2022-05-17T10:26:04.000
Cb
13
House Num
84-56
Onstname
260TH ST.
Atddismissed
No
12423
Atdid: 12423 • Atd Number: ATD-1-288 • Bblid: 41735
Atdid
12423
Atd Number
ATD-1-288
Bblid
41735
Inspectionid
357748
Inspect Date
2023-05-26T00:00:00.000
Atdissuedate
2023-05-26T12:38:34.000
Cb
6
House Num
80
Onstname
PARK AVE.
Atddismissed
No
16698
Atdid: 16698 • Atd Number: ATD-1-353 • Bblid: 133322
Atdid
16698
Atd Number
ATD-1-353
Bblid
133322
Inspectionid
388703
Inspect Date
2022-11-16T00:00:00.000
Atdissuedate
2025-01-13T16:03:09.000
Cb
9
House Num
540
Onstname
W. 148TH ST.
Atddismissed
Yes
Atddismissedon
2025-01-13T16:05:06.000
17223
Atdid: 17223 • Atd Number: ATD-4-6721 • Bblid: 775731
Atdid
17223
Atd Number
ATD-4-6721
Bblid
775731
Inspectionid
392938
Inspect Date
2025-03-01T00:00:00.000
Atdissuedate
2025-04-01T13:44:49.000
Cb
13
House Num
87-36
Onstname
258TH ST.
Atddismissed
No
13051
Atdid: 13051 • Atd Number: ATD-3-5295 • Bblid: 422500
Atdid
13051
Atd Number
ATD-3-5295
Bblid
422500
Inspectionid
361045
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T16:23:13.000
Cb
12
House Num
1662
Onstname
45TH ST.
Atddismissed
No
8784
Atdid: 8784 • Atd Number: ATD-3-3224 • Bblid: 266859
Atdid
8784
Atd Number
ATD-3-3224
Bblid
266859
Inspectionid
331275
Inspect Date
2021-12-14T00:00:00.000
Atdissuedate
2021-12-30T10:25:13.000
Cb
7
House Num
435
Onstname
49TH ST.
Atddismissed
No
18611
Atdid: 18611 • Atd Number: ATD-4-7374 • Bblid: 753259
Atdid
18611
Atd Number
ATD-4-7374
Bblid
753259
Inspectionid
405980
Inspect Date
2025-09-09T00:00:00.000
Atdissuedate
2025-09-17T13:06:00.000
Cb
11
House Num
53-08
Onstname
208TH ST.
Atddismissed
No
17318
Atdid: 17318 • Atd Number: ATD-3-6856 • Bblid: 319617
Atdid
17318
Atd Number
ATD-3-6856
Bblid
319617
Inspectionid
394425
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-04-14T08:13:37.000
Cb
3
House Num
284
Onstname
MACON ST.
Atddismissed
No
9521
Atdid: 9521 • Atd Number: ATD-3-3540 • Bblid: 326753
Atdid
9521
Atd Number
ATD-3-3540
Bblid
326753
Inspectionid
333546
Inspect Date
2020-11-05T00:00:00.000
Atdissuedate
2022-03-09T17:03:14.000
Cb
2
House Num
63
Onstname
LEFFERTS PL.
Atddismissed
No
17517
Atdid: 17517 • Atd Number: ATD-4-6839 • Bblid: 885329
Atdid
17517
Atd Number
ATD-4-6839
Bblid
885329
Inspectionid
396039
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-05T08:18:42.000
Cb
12
House Num
137-44
Onstname
SLOAN ST.
Atddismissed
No
18070
Atdid: 18070 • Atd Number: ATD-3-7121 • Bblid: 529832
Atdid
18070
Atd Number
ATD-3-7121
Bblid
529832
Inspectionid
402293
Inspect Date
2025-06-04T00:00:00.000
Atdissuedate
2025-07-14T13:24:45.000
Cb
17
House Num
400
Onstname
E. 58TH ST.
Atddismissed
No
10678
Atdid: 10678 • Atd Number: ATD-3-4075 • Bblid: 268001
Atdid
10678
Atd Number
ATD-3-4075
Bblid
268001
Inspectionid
341967
Inspect Date
2022-08-18T00:00:00.000
Atdissuedate
2022-08-24T12:32:55.000
Cb
7
House Num
363
Onstname
52ND ST.
Atddismissed
No
10517
Atdid: 10517 • Atd Number: ATD-3-3975 • Bblid: 332918
Atdid
10517
Atd Number
ATD-3-3975
Bblid
332918
Inspectionid
340068
Inspect Date
2022-07-19T00:00:00.000
Atdissuedate
2022-07-19T13:00:09.000
Cb
1
House Num
49
Onstname
HARRISON AVE.
Atddismissed
No
9868
Atdid: 9868 • Atd Number: ATD-4-4477 • Bblid: 895219
Atdid
9868
Atd Number
ATD-4-4477
Bblid
895219
Inspectionid
334905
Inspect Date
2022-04-14T00:00:00.000
Atdissuedate
2022-04-14T14:12:55.000
Cb
13
House Num
257-07
Onstname
147TH AVE.
Atddismissed
No
10559
Atdid: 10559 • Atd Number: ATD-2-940 • Bblid: 171675
Atdid
10559
Atd Number
ATD-2-940
Bblid
171675
Inspectionid
340462
Inspect Date
2022-07-21T00:00:00.000
Atdissuedate
2022-07-26T10:54:50.000
Cb
9
House Num
305
Onstname
TORRY AVE.
Atddismissed
No
12815
Atdid: 12815 • Atd Number: ATD-3-5147 • Bblid: 506431
Atdid
12815
Atd Number
ATD-3-5147
Bblid
506431
Inspectionid
359803
Inspect Date
2023-07-11T00:00:00.000
Atdissuedate
2023-07-11T11:43:35.000
Cb
15
House Num
2145
Onstname
E. 23RD ST.
Atddismissed
No
8989
Atdid: 8989 • Atd Number: ATD-4-4080 • Bblid: 677684
Atdid
8989
Atd Number
ATD-4-4080
Bblid
677684
Inspectionid
332302
Inspect Date
2020-12-04T00:00:00.000
Atdissuedate
2022-02-08T09:03:21.000
Cb
5
House Num
88-42
Onstname
75TH AVE.
Atddismissed
No
12596
Atdid: 12596 • Atd Number: ATD-4-5361 • Bblid: 612821
Atdid
12596
Atd Number
ATD-4-5361
Bblid
612821
Inspectionid
358624
Inspect Date
2023-06-15T00:00:00.000
Atdissuedate
2023-06-15T11:04:24.000
Cb
4
House Num
42-09
Onstname
FORLEY ST.
Atddismissed
No
13256
Atdid: 13256 • Atd Number: ATD-3-5427 • Bblid: 422873
Atdid
13256
Atd Number
ATD-3-5427
Bblid
422873
Inspectionid
362076
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T16:59:59.000
Cb
12
House Num
1674
Onstname
47TH ST.
Atddismissed
No
13635
Atdid: 13635 • Atd Number: ATD-3-5617 • Bblid: 306704
Atdid
13635
Atd Number
ATD-3-5617
Bblid
306704
Inspectionid
366071
Inspect Date
2023-10-28T00:00:00.000
Atdissuedate
2023-10-28T15:11:33.000
Cb
3
House Num
1048
Onstname
DEKALB AVE.
Atddismissed
Yes
Atddismissedon
2023-10-28T15:11:53.000
9488
Atdid: 9488 • Atd Number: ATD-3-3530 • Bblid: 276059
Atdid
9488
Atd Number
ATD-3-3530
Bblid
276059
Inspectionid
333394
Inspect Date
2021-07-30T00:00:00.000
Atdissuedate
2022-03-08T11:13:08.000
Cb
6
House Num
641
Onstname
CARROLL ST.
Atddismissed
No
17885
Atdid: 17885 • Atd Number: ATD-1-380 • Bblid: 46070
Atdid
17885
Atd Number
ATD-1-380
Bblid
46070
Inspectionid
400341
Inspect Date
2025-06-11T00:00:00.000
Atdissuedate
2025-06-13T11:28:05.000
Cb
6
House Num
236
Onstname
E. 30TH ST.
Atddismissed
No
10683
Atdid: 10683 • Atd Number: ATD-2-942 • Bblid: 229020
Atdid
10683
Atd Number
ATD-2-942
Bblid
229020
Inspectionid
342004
Inspect Date
2022-04-09T00:00:00.000
Atdissuedate
2022-08-25T11:27:08.000
Cb
12
House Num
4534
Onstname
MURDOCK AVE.
Atddismissed
No
16422
Atdid: 16422 • Atd Number: ATD-3-6427 • Bblid: 259347
Atdid
16422
Atd Number
ATD-3-6427
Bblid
259347
Inspectionid
385316
Inspect Date
2024-10-17T00:00:00.000
Atdissuedate
2024-11-22T10:55:13.000
Cb
6
House Num
363
Onstname
DEGRAW ST.
Atddismissed
No
16560
Atdid: 16560 • Atd Number: ATD-4-6500 • Bblid: 613810
Atdid
16560
Atd Number
ATD-4-6500
Bblid
613810
Inspectionid
386968
Inspect Date
2024-11-22T00:00:00.000
Atdissuedate
2024-12-19T14:51:32.000
Cb
4
House Num
94-56
Onstname
46TH AVE.
Atddismissed
No
17162
Atdid: 17162 • Atd Number: ATD-3-6797 • Bblid: 332845
Atdid
17162
Atd Number
ATD-3-6797
Bblid
332845
Inspectionid
392664
Inspect Date
2025-03-21T00:00:00.000
Atdissuedate
2025-03-31T10:50:58.000
Cb
1
House Num
245
Onstname
RUTLEDGE ST.
Atddismissed
No
18114
Atdid: 18114 • Atd Number: ATD-4-7164 • Bblid: 845886
Atdid
18114
Atd Number
ATD-4-7164
Bblid
845886
Inspectionid
402591
Inspect Date
2025-06-18T00:00:00.000
Atdissuedate
2025-07-17T13:32:36.000
Cb
10
House Num
132-18
Onstname
88TH ST.
Atddismissed
No
8589
Atdid: 8589 • Atd Number: ATD-5-581 • Bblid: 923955
Atdid
8589
Atd Number
ATD-5-581
Bblid
923955
Inspectionid
330529
Inspect Date
2021-04-27T00:00:00.000
Atdissuedate
2021-12-10T10:33:34.000
Cb
1
House Num
197
Onstname
FILLMORE ST.
Atddismissed
Yes
Atddismissedon
2024-04-30T10:27:00.000
17231
Atdid: 17231 • Atd Number: ATD-5-954 • Bblid: 1028217
Atdid
17231
Atd Number
ATD-5-954
Bblid
1028217
Inspectionid
393024
Inspect Date
2025-03-29T00:00:00.000
Atdissuedate
2025-04-02T16:00:52.000
Cb
3
House Num
124
Onstname
NOTUS AVE.
Atddismissed
No
17482
Atdid: 17482 • Atd Number: ATD-3-6933 • Bblid: 445994
Atdid
17482
Atd Number
ATD-3-6933
Bblid
445994
Inspectionid
395659
Inspect Date
2025-04-30T00:00:00.000
Atdissuedate
2025-04-30T12:37:49.000
Cb
10
House Num
335
Onstname
BAY RIDGE PKWY.
Atddismissed
No
9821
Atdid: 9821 • Atd Number: ATD-3-3608 • Bblid: 315885
Atdid
9821
Atd Number
ATD-3-3608
Bblid
315885
Inspectionid
334534
Inspect Date
2022-03-30T00:00:00.000
Atdissuedate
2022-04-04T10:44:02.000
Cb
3
House Num
64
Onstname
VAN BUREN ST.
Atddismissed
No
16808
Atdid: 16808 • Atd Number: ATD-4-6610 • Bblid: 885886
Atdid
16808
Atd Number
ATD-4-6610
Bblid
885886
Inspectionid
389696
Inspect Date
2025-02-07T00:00:00.000
Atdissuedate
2025-02-10T14:05:15.000
Cb
13
House Num
219-35
Onstname
EDGEWOOD AVE.
Atddismissed
Yes
Atddismissedon
2025-03-22T13:55:38.000
17429
Atdid: 17429 • Atd Number: ATD-3-6907 • Bblid: 471241
Atdid
17429
Atd Number
ATD-3-6907
Bblid
471241
Inspectionid
395250
Inspect Date
2025-04-17T00:00:00.000
Atdissuedate
2025-04-24T14:17:39.000
Cb
12
House Num
1274
Onstname
E. 7TH ST.
Atddismissed
No
17501
Atdid: 17501 • Atd Number: ATD-3-6936 • Bblid: 289129
Atdid
17501
Atd Number
ATD-3-6936
Bblid
289129
Inspectionid
396009
Inspect Date
2025-04-30T00:00:00.000
Atdissuedate
2025-05-05T07:41:10.000
Cb
8
House Num
1136
Onstname
DEAN ST.
Atddismissed
No
6246
Atdid: 6246 • Atd Number: ATD-4-2607 • Bblid: 909693
Atdid
6246
Atd Number
ATD-4-2607
Bblid
909693
Violationid
241140
Atdissuedate
2020-06-09T00:00:00.000
Cb
14
House Num
12-23
Onstname
BAY 27 STREET
Atddismissed
No
10009
Atdid: 10009 • Atd Number: ATD-4-4561 • Bblid: 654710
Atdid
10009
Atd Number
ATD-4-4561
Bblid
654710
Inspectionid
335866
Inspect Date
2022-04-21T00:00:00.000
Atdissuedate
2022-04-29T14:36:01.000
Cb
6
House Num
63-148
Onstname
ALDERTON ST.
Atddismissed
No
11186
Atdid: 11186 • Atd Number: ATD-3-4504 • Bblid: 555255
Atdid
11186
Atd Number
ATD-3-4504
Bblid
555255
Inspectionid
346225
Inspect Date
2022-10-14T00:00:00.000
Atdissuedate
2022-10-17T12:57:28.000
Cb
18
House Num
245
Onstname
ARKANSAS DR.
Atddismissed
No
10420
Atdid: 10420 • Atd Number: ATD-3-3909 • Bblid: 417842
Atdid
10420
Atd Number
ATD-3-3909
Bblid
417842
Inspectionid
339121
Inspect Date
2022-06-15T00:00:00.000
Atdissuedate
2022-07-11T13:47:29.000
Cb
12
House Num
233
Onstname
E. 5TH ST.
Atddismissed
No
12998
Atdid: 12998 • Atd Number: ATD-3-5258 • Bblid: 422360
Atdid
12998
Atd Number
ATD-3-5258
Bblid
422360
Inspectionid
360799
Inspect Date
2023-07-27T00:00:00.000
Atdissuedate
2023-07-27T13:28:45.000
Cb
12
House Num
1534
Onstname
45TH ST.
Atddismissed
No
16492
Atdid: 16492 • Atd Number: ATD-1-337 • Bblid: 96222
Atdid
16492
Atd Number
ATD-1-337
Bblid
96222
Inspectionid
385829
Inspect Date
2024-12-04T00:00:00.000
Atdissuedate
2024-12-06T15:11:12.000
Cb
8
House Num
229
Onstname
E. 62ND ST.
Atddismissed
No
16626
Atdid: 16626 • Atd Number: ATD-4-6528 • Bblid: 853094
Atdid
16626
Atd Number
ATD-4-6528
Bblid
853094
Inspectionid
388339
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2025-01-02T14:49:28.000
Cb
10
House Num
124-17
Onstname
111TH AVE.
Atddismissed
No
11236
Atdid: 11236 • Atd Number: ATD-3-4542 • Bblid: 302651
Atdid
11236
Atd Number
ATD-3-4542
Bblid
302651
Inspectionid
346793
Inspect Date
2022-10-19T00:00:00.000
Atdissuedate
2022-10-24T10:35:29.000
Cb
16
House Num
676
Onstname
DECATUR ST.
Atddismissed
No
10619
Atdid: 10619 • Atd Number: ATD-3-4039 • Bblid: 283311
Atdid
10619
Atd Number
ATD-3-4039
Bblid
283311
Inspectionid
341072
Inspect Date
2022-07-19T00:00:00.000
Atdissuedate
2022-08-08T12:03:50.000
Cb
6
House Num
571
Onstname
10TH ST.
Atddismissed
No
8144
Atdid: 8144 • Atd Number: ATD-4-3731 • Bblid: 632021
Atdid
8144
Atd Number
ATD-4-3731
Bblid
632021
Inspectionid
320421
Inspect Date
2021-04-09T00:00:00.000
Atdissuedate
2021-04-09T00:00:00.000
Cb
2
House Num
50-27
Onstname
63RD ST.
Atddismissed
Yes
Atddismissedon
2022-06-22T11:15:49.000
11313
Atdid: 11313 • Atd Number: ATD-3-4599 • Bblid: 298979
Atdid
11313
Atd Number
ATD-3-4599
Bblid
298979
Inspectionid
347432
Inspect Date
2022-10-29T00:00:00.000
Atdissuedate
2022-11-01T15:29:46.000
Cb
9
House Num
795
Onstname
MONTGOMERY ST.
Atddismissed
No
4252
Atdid: 4252 • Atd Number: ATD-4-783 • Bblid: 679419
Atdid
4252
Atd Number
ATD-4-783
Bblid
679419
Violationid
174289
Atdissuedate
2020-08-20T00:00:00.000
Cb
7
House Num
6-15
Onstname
119 STREET
Atddismissed
No