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
11476
Atdid: 11476 • Atd Number: ATD-3-4680 • Bblid: 508835
Atdid
11476
Atd Number
ATD-3-4680
Bblid
508835
Inspectionid
348871
Inspect Date
2022-11-09T00:00:00.000
Atdissuedate
2022-12-01T12:48:49.000
Cb
15
House Num
1701
Onstname
AVENUE X.
Atddismissed
No
11591
Atdid: 11591 • Atd Number: ATD-4-4957 • Bblid: 669789
Atdid
11591
Atd Number
ATD-4-4957
Bblid
669789
Inspectionid
350371
Inspect Date
2023-01-09T00:00:00.000
Atdissuedate
2023-01-11T12:47:13.000
Cb
5
House Num
74-46
Onstname
64TH PL.
Atddismissed
No
15036
Atdid: 15036 • Atd Number: ATD-3-6269 • Bblid: 348453
Atdid
15036
Atd Number
ATD-3-6269
Bblid
348453
Inspectionid
381789
Inspect Date
2024-09-05T00:00:00.000
Atdissuedate
2024-09-13T13:23:38.000
Cb
1
House Num
41
Onstname
ORIENT AVE.
Atddismissed
No
9504
Atdid: 9504 • Atd Number: ATD-3-3534 • Bblid: 447626
Atdid
9504
Atd Number
ATD-3-3534
Bblid
447626
Inspectionid
333435
Inspect Date
2022-03-09T00:00:00.000
Atdissuedate
2022-03-09T07:30:03.000
Cb
10
House Num
1039
Onstname
78TH ST.
Atddismissed
No
13937
Atdid: 13937 • Atd Number: ATD-3-5726 • Bblid: 421433
Atdid
13937
Atd Number
ATD-3-5726
Bblid
421433
Inspectionid
371427
Inspect Date
2024-02-08T00:00:00.000
Atdissuedate
2024-02-08T12:20:53.000
Cb
12
House Num
565
Onstname
E. 8TH ST.
Atddismissed
No
16833
Atdid: 16833 • Atd Number: ATD-3-6612 • Bblid: 508934
Atdid
16833
Atd Number
ATD-3-6612
Bblid
508934
Inspectionid
389951
Inspect Date
2025-02-21T00:00:00.000
Atdissuedate
2025-02-24T09:41:19.000
Cb
15
House Num
2389
Onstname
E. 21ST ST.
Atddismissed
No
10542
Atdid: 10542 • Atd Number: ATD-3-3992 • Bblid: 531201
Atdid
10542
Atd Number
ATD-3-3992
Bblid
531201
Inspectionid
340264
Inspect Date
2022-07-21T00:00:00.000
Atdissuedate
2022-07-21T14:11:02.000
Cb
18
House Num
585
Onstname
E. 81ST ST.
Atddismissed
No
8911
Atdid: 8911 • Atd Number: ATD-2-858 • Bblid: 220117
Atdid
8911
Atd Number
ATD-2-858
Bblid
220117
Inspectionid
332130
Inspect Date
2021-03-23T00:00:00.000
Atdissuedate
2022-01-28T09:29:57.000
Cb
12
House Num
956
Onstname
E. 229TH ST.
Atddismissed
No
3871
Atdid: 3871 • Atd Number: ATD-3-2543 • Bblid: 279002
Atdid
3871
Atd Number
ATD-3-2543
Bblid
279002
Violationid
262230
Atdissuedate
2020-08-03T00:00:00.000
Cb
6
House Num
393
Onstname
11 STREET
Atddismissed
Yes
Atddismissedon
2024-10-28T10:33:26.000
15034
Atdid: 15034 • Atd Number: ATD-3-6268 • Bblid: 378412
Atdid
15034
Atd Number
ATD-3-6268
Bblid
378412
Violationid
296613
Reinspectionid
37459
Inspect Date
2024-09-12T14:26:33.000
Atdissuedate
2024-09-12T14:26:33.000
Cb
5
House Num
632
Onstname
ELTON STREET
Atddismissed
No
11209
Atdid: 11209 • Atd Number: ATD-3-4525 • Bblid: 419351
Atdid
11209
Atd Number
ATD-3-4525
Bblid
419351
Inspectionid
346433
Inspect Date
2022-10-13T00:00:00.000
Atdissuedate
2022-10-19T10:41:17.000
Cb
12
House Num
1572
Onstname
39TH ST.
Atddismissed
No
13413
Atdid: 13413 • Atd Number: ATD-3-5528 • Bblid: 313532
Atdid
13413
Atd Number
ATD-3-5528
Bblid
313532
Inspectionid
363656
Inspect Date
2023-09-16T00:00:00.000
Atdissuedate
2023-09-18T10:01:04.000
Cb
3
House Num
453
Onstname
WILLOUGHBY AVE.
Atddismissed
No
10335
Atdid: 10335 • Atd Number: ATD-2-929 • Bblid: 197023
Atdid
10335
Atd Number
ATD-2-929
Bblid
197023
Inspectionid
338238
Inspect Date
2022-06-17T00:00:00.000
Atdissuedate
2022-06-27T14:27:26.000
Cb
11
House Num
1546
Onstname
HONE AVE.
Atddismissed
No
9497
Atdid: 9497 • Atd Number: ATD-4-4261 • Bblid: 737869
Atdid
9497
Atd Number
ATD-4-4261
Bblid
737869
Inspectionid
333423
Inspect Date
2019-08-16T00:00:00.000
Atdissuedate
2022-03-08T15:41:38.000
Cb
8
House Num
150-03
Onstname
78TH RD.
Atddismissed
No
14435
Atdid: 14435 • Atd Number: ATD-3-5969 • Bblid: 277798
Atdid
14435
Atd Number
ATD-3-5969
Bblid
277798
Inspectionid
377111
Inspect Date
2024-04-24T00:00:00.000
Atdissuedate
2024-05-08T13:38:25.000
Cb
6
House Num
443
Onstname
6TH ST.
Atddismissed
No
12995
Atdid: 12995 • Atd Number: ATD-3-5255 • Bblid: 422354
Atdid
12995
Atd Number
ATD-3-5255
Bblid
422354
Inspectionid
360789
Inspect Date
2023-07-27T00:00:00.000
Atdissuedate
2023-07-27T13:27:08.000
Cb
12
House Num
1526
Onstname
45TH ST.
Atddismissed
No
16206
Atdid: 16206 • Atd Number: ATD-3-6340 • Bblid: 506061
Atdid
16206
Atd Number
ATD-3-6340
Bblid
506061
Inspectionid
384002
Inspect Date
2023-04-28T00:00:00.000
Atdissuedate
2024-10-09T13:41:39.000
Cb
15
House Num
2206
Onstname
E. 21ST ST.
Atddismissed
No
14943
Atdid: 14943 • Atd Number: ATD-4-6236 • Bblid: 652252
Atdid
14943
Atd Number
ATD-4-6236
Bblid
652252
Inspectionid
380897
Inspect Date
2024-08-19T00:00:00.000
Atdissuedate
2024-08-21T14:05:39.000
Cb
5
House Num
77-19
Onstname
66TH RD.
Atddismissed
No
10098
Atdid: 10098 • Atd Number: ATD-3-3717 • Bblid: 472333
Atdid
10098
Atd Number
ATD-3-3717
Bblid
472333
Inspectionid
336462
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-16T11:05:39.000
Cb
11
House Num
2364
Onstname
62ND ST.
Atddismissed
No
10522
Atdid: 10522 • Atd Number: ATD-5-667 • Bblid: 932498
Atdid
10522
Atd Number
ATD-5-667
Bblid
932498
Inspectionid
340098
Inspect Date
2022-07-19T00:00:00.000
Atdissuedate
2022-07-19T16:06:14.000
Cb
1
House Num
204
Onstname
MORRISON AVE.
Atddismissed
No
14543
Atdid: 14543 • Atd Number: ATD-3-6006 • Bblid: 459551
Atdid
14543
Atd Number
ATD-3-6006
Bblid
459551
Inspectionid
377885
Inspect Date
2024-05-17T00:00:00.000
Atdissuedate
2024-05-28T13:56:29.000
Cb
11
House Num
1718
Onstname
76TH ST.
Atddismissed
No
8490
Atdid: 8490 • Atd Number: ATD-3-3093 • Bblid: 315516
Atdid
8490
Atd Number
ATD-3-3093
Bblid
315516
Inspectionid
329613
Inspect Date
2021-11-10T00:00:00.000
Atdissuedate
2021-11-15T11:16:08.000
Cb
3
House Num
256
Onstname
CLIFTON PL.
Atddismissed
No
8230
Atdid: 8230 • Atd Number: ATD-3-2940 • Bblid: 313948
Atdid
8230
Atd Number
ATD-3-2940
Bblid
313948
Inspectionid
323192
Inspect Date
2021-06-16T00:00:00.000
Atdissuedate
2021-06-16T00:00:00.000
Cb
3
House Num
73
Onstname
HART ST.
Atddismissed
Yes
Atddismissedon
2024-12-05T13:53:00.000
14966
Atdid: 14966 • Atd Number: ATD-3-6231 • Bblid: 391110
Atdid
14966
Atd Number
ATD-3-6231
Bblid
391110
Inspectionid
381078
Inspect Date
2024-08-22T00:00:00.000
Atdissuedate
2024-08-26T13:10:18.000
Cb
17
House Num
118
Onstname
E. 51ST ST.
Atddismissed
No
12404
Atdid: 12404 • Atd Number: ATD-3-5046 • Bblid: 454275
Atdid
12404
Atd Number
ATD-3-5046
Bblid
454275
Violationid
273237
Reinspectionid
33424
Inspect Date
2023-05-25T09:41:42.000
Atdissuedate
2023-05-25T09:41:42.000
Cb
10
House Num
167
Onstname
99 STREET
Atddismissed
No
9638
Atdid: 9638 • Atd Number: ATD-4-4342 • Bblid: 735717
Atdid
9638
Atd Number
ATD-4-4342
Bblid
735717
Inspectionid
333807
Inspect Date
2021-03-30T00:00:00.000
Atdissuedate
2022-03-15T18:59:38.000
Cb
8
House Num
137-34
Onstname
71ST AVE.
Atddismissed
No
8617
Atdid: 8617 • Atd Number: ATD-3-3156 • Bblid: 279988
Atdid
8617
Atd Number
ATD-3-3156
Bblid
279988
Inspectionid
330712
Inspect Date
2019-07-24T00:00:00.000
Atdissuedate
2021-12-14T17:13:00.000
Cb
6
House Num
173
Onstname
13TH ST.
Atddismissed
No
12590
Atdid: 12590 • Atd Number: ATD-4-5355 • Bblid: 598293
Atdid
12590
Atd Number
ATD-4-5355
Bblid
598293
Inspectionid
358601
Inspect Date
2023-06-12T00:00:00.000
Atdissuedate
2023-06-15T10:49:55.000
Cb
3
House Num
32-36
Onstname
73RD ST.
Atddismissed
No
12072
Atdid: 12072 • Atd Number: ATD-4-5142 • Bblid: 753744
Atdid
12072
Atd Number
ATD-4-5142
Bblid
753744
Violationid
285008
Reinspectionid
35460
Inspect Date
2023-04-20T13:22:07.000
Atdissuedate
2023-04-20T13:22:07.000
Cb
11
House Num
56-48
Onstname
210 STREET
Atddismissed
No
12345
Atdid: 12345 • Atd Number: ATD-4-5211 • Bblid: 602988
Atdid
12345
Atd Number
ATD-4-5211
Bblid
602988
Inspectionid
357470
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T11:44:59.000
Cb
2
House Num
53-15
Onstname
QUEENS BLVD.
Atddismissed
No
10120
Atdid: 10120 • Atd Number: ATD-3-3734 • Bblid: 562341
Atdid
10120
Atd Number
ATD-3-3734
Bblid
562341
Inspectionid
336767
Inspect Date
2022-05-09T00:00:00.000
Atdissuedate
2022-05-23T10:20:15.000
Cb
15
House Num
2735
Onstname
FORD ST.
Atddismissed
No
9755
Atdid: 9755 • Atd Number: ATD-2-905 • Bblid: 200033
Atdid
9755
Atd Number
ATD-2-905
Bblid
200033
Inspectionid
334348
Inspect Date
2019-06-20T00:00:00.000
Atdissuedate
2022-03-29T17:35:56.000
Cb
11
House Num
1825
Onstname
NARRAGANSETT AVE.
Atddismissed
No
14532
Atdid: 14532 • Atd Number: ATD-3-6000 • Bblid: 347876
Atdid
14532
Atd Number
ATD-3-6000
Bblid
347876
Inspectionid
377816
Inspect Date
2024-05-20T00:00:00.000
Atdissuedate
2024-05-22T11:57:58.000
Cb
1
House Num
231
Onstname
FROST ST.
Atddismissed
Yes
Atddismissedon
2024-11-06T15:34:25.000
11401
Atdid: 11401 • Atd Number: ATD-3-4646 • Bblid: 458386
Atdid
11401
Atd Number
ATD-3-4646
Bblid
458386
Inspectionid
348297
Inspect Date
2022-10-29T00:00:00.000
Atdissuedate
2022-11-18T09:29:08.000
Cb
10
House Num
1139
Onstname
76TH ST.
Atddismissed
No
9629
Atdid: 9629 • Atd Number: ATD-4-4333 • Bblid: 841335
Atdid
9629
Atd Number
ATD-4-4333
Bblid
841335
Inspectionid
333798
Inspect Date
2021-01-22T00:00:00.000
Atdissuedate
2022-03-15T18:49:19.000
Cb
13
House Num
225-05
Onstname
107TH AVE.
Atddismissed
No
12839
Atdid: 12839 • Atd Number: ATD-4-5436 • Bblid: 645285
Atdid
12839
Atd Number
ATD-4-5436
Bblid
645285
Inspectionid
359939
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-07-13T12:12:31.000
Cb
4
House Num
86-29
Onstname
57TH RD.
Atddismissed
No
9998
Atdid: 9998 • Atd Number: ATD-4-4550 • Bblid: 654515
Atdid
9998
Atd Number
ATD-4-4550
Bblid
654515
Inspectionid
335828
Inspect Date
2022-04-19T00:00:00.000
Atdissuedate
2022-04-29T14:03:32.000
Cb
6
House Num
64-07
Onstname
ELLWELL CRES
Atddismissed
No
16116
Atdid: 16116 • Atd Number: ATD-3-6302 • Bblid: 292421
Atdid
16116
Atd Number
ATD-3-6302
Bblid
292421
Inspectionid
383270
Inspect Date
2024-09-12T00:00:00.000
Atdissuedate
2024-09-25T14:42:16.000
Cb
8
House Num
805
Onstname
EASTERN PKWY.
Atddismissed
No
18041
Atdid: 18041 • Atd Number: ATD-4-7124 • Bblid: 688858
Atdid
18041
Atd Number
ATD-4-7124
Bblid
688858
Inspectionid
401985
Inspect Date
2025-05-16T00:00:00.000
Atdissuedate
2025-07-09T17:13:24.000
Cb
7
House Num
154-63
Onstname
12TH RD.
Atddismissed
No
16195
Atdid: 16195 • Atd Number: ATD-4-6356 • Bblid: 749950
Atdid
16195
Atd Number
ATD-4-6356
Bblid
749950
Violationid
238004
Inspectionid
383943
Inspect Date
2024-10-09T09:24:52.000
Atdissuedate
2024-10-09T09:24:52.000
Cb
8
House Num
84-16
Onstname
193 STREET
Atddismissed
No
11722
Atdid: 11722 • Atd Number: ATD-4-5021 • Bblid: 632950
Atdid
11722
Atd Number
ATD-4-5021
Bblid
632950
Inspectionid
352118
Inspect Date
2023-02-27T00:00:00.000
Atdissuedate
2023-02-27T12:14:36.000
Cb
2
House Num
51-15
Onstname
65TH ST.
Atddismissed
No
14242
Atdid: 14242 • Atd Number: ATD-3-5867 • Bblid: 315651
Atdid
14242
Atd Number
ATD-3-5867
Bblid
315651
Inspectionid
374947
Inspect Date
2024-04-08T00:00:00.000
Atdissuedate
2024-04-08T09:42:06.000
Cb
3
House Num
91
Onstname
CHAUNCEY ST.
Atddismissed
No
1094
Atdid: 1094 • Atd Number: ATD-3-237 • Bblid: 252575
Atdid
1094
Atd Number
ATD-3-237
Bblid
252575
Violationid
207804
Atdissuedate
2019-12-13T00:00:00.000
Cb
2
House Num
69
Onstname
JORALEMON STREET
Atddismissed
Yes
Atddismissedon
2023-02-07T15:22:11.000
8587
Atdid: 8587 • Atd Number: ATD-5-579 • Bblid: 945380
Atdid
8587
Atd Number
ATD-5-579
Bblid
945380
Inspectionid
330527
Inspect Date
2019-08-27T00:00:00.000
Atdissuedate
2021-12-10T10:29:49.000
Cb
1
House Num
234
Onstname
BYRNE AVE.
Atddismissed
No
17507
Atdid: 17507 • Atd Number: ATD-3-6942 • Bblid: 295566
Atdid
17507
Atd Number
ATD-3-6942
Bblid
295566
Inspectionid
396019
Inspect Date
2025-04-30T00:00:00.000
Atdissuedate
2025-05-05T07:50:46.000
Cb
8
House Num
61
Onstname
BUFFALO AVENUE
Atddismissed
No
12823
Atdid: 12823 • Atd Number: ATD-2-1187 • Bblid: 171958
Atdid
12823
Atd Number
ATD-2-1187
Bblid
171958
Inspectionid
359874
Inspect Date
2023-05-05T00:00:00.000
Atdissuedate
2023-07-12T10:53:55.000
Cb
9
House Num
534
Onstname
COMMONWEALTH AVE.
Atddismissed
No
16351
Atdid: 16351 • Atd Number: ATD-2-1318 • Bblid: 202167
Atdid
16351
Atd Number
ATD-2-1318
Bblid
202167
Inspectionid
384895
Inspect Date
2024-10-25T00:00:00.000
Atdissuedate
2024-11-06T15:16:59.000
Cb
11
House Num
1928
Onstname
YATES AVE.
Atddismissed
No
17900
Atdid: 17900 • Atd Number: ATD-2-1410 • Bblid: 166473
Atdid
17900
Atd Number
ATD-2-1410
Bblid
166473
Inspectionid
400459
Inspect Date
2025-05-15T00:00:00.000
Atdissuedate
2025-06-16T11:49:53.000
Cb
7
House Num
3012
Onstname
BAINBRIDGE AVE.
Atddismissed
No
14334
Atdid: 14334 • Atd Number: ATD-4-5983 • Bblid: 641028
Atdid
14334
Atd Number
ATD-4-5983
Bblid
641028
Inspectionid
375965
Inspect Date
2024-04-15T00:00:00.000
Atdissuedate
2024-04-23T13:10:03.000
Cb
5
House Num
57-39
Onstname
65TH ST.
Atddismissed
No
14855
Atdid: 14855 • Atd Number: ATD-3-6174 • Bblid: 302014
Atdid
14855
Atd Number
ATD-3-6174
Bblid
302014
Inspectionid
380134
Inspect Date
2024-08-05T00:00:00.000
Atdissuedate
2024-08-05T11:32:44.000
Cb
3
House Num
751
Onstname
MACON ST.
Atddismissed
No