Ask NYC Browse All Data Public Safety Transportation Health Buildings

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
12093
Atdid: 12093 • Atd Number: ATD-4-5154 • Bblid: 649163
Atdid
12093
Atd Number
ATD-4-5154
Bblid
649163
Inspectionid
356250
Inspect Date
2023-04-26T00:00:00.000
Atdissuedate
2023-04-26T10:15:40.000
Cb
5
House Num
62-22
Onstname
84TH ST.
Atddismissed
No
13088
Atdid: 13088 • Atd Number: ATD-3-5317 • Bblid: 457693
Atdid
13088
Atd Number
ATD-3-5317
Bblid
457693
Inspectionid
361294
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-08-02T11:26:09.000
Cb
11
House Num
1576
Onstname
73RD ST.
Atddismissed
No
12267
Atdid: 12267 • Atd Number: ATD-2-1079 • Bblid: 207280
Atdid
12267
Atd Number
ATD-2-1079
Bblid
207280
Inspectionid
357261
Inspect Date
2023-01-20T00:00:00.000
Atdissuedate
2023-05-18T09:40:54.000
Cb
11
House Num
1574
Onstname
ALLERTON AVE.
Atddismissed
No
11614
Atdid: 11614 • Atd Number: ATD-1-282 • Bblid: 132298
Atdid
11614
Atd Number
ATD-1-282
Bblid
132298
Inspectionid
350629
Inspect Date
2022-12-13T00:00:00.000
Atdissuedate
2023-01-23T10:52:50.000
Cb
9
House Num
421
Onstname
W. 147TH ST.
Atddismissed
No
16203
Atdid: 16203 • Atd Number: ATD-4-6361 • Bblid: 655115
Atdid
16203
Atd Number
ATD-4-6361
Bblid
655115
Inspectionid
383965
Inspect Date
2024-09-25T00:00:00.000
Atdissuedate
2024-10-09T12:24:24.000
Cb
6
House Num
85-09
Onstname
67TH AVE.
Atddismissed
No
13116
Atdid: 13116 • Atd Number: ATD-3-5329 • Bblid: 422744
Atdid
13116
Atd Number
ATD-3-5329
Bblid
422744
Inspectionid
361441
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T12:13:18.000
Cb
12
House Num
1528
Onstname
46TH ST.
Atddismissed
No
9203
Atdid: 9203 • Atd Number: ATD-1-183 • Bblid: 94327
Atdid
9203
Atd Number
ATD-1-183
Bblid
94327
Inspectionid
332861
Inspect Date
2018-10-12T00:00:00.000
Atdissuedate
2022-02-28T17:39:33.000
Cb
8
House Num
120
Onstname
E. 70TH ST.
Atddismissed
No
18227
Atdid: 18227 • Atd Number: ATD-3-7191 • Bblid: 379458
Atdid
18227
Atd Number
ATD-3-7191
Bblid
379458
Inspectionid
403491
Inspect Date
2025-07-17T00:00:00.000
Atdissuedate
2025-08-04T09:43:20.000
Cb
5
House Num
103
Onstname
RICHMOND ST.
Atddismissed
No
12406
Atdid: 12406 • Atd Number: ATD-3-5047 • Bblid: 479897
Atdid
12406
Atd Number
ATD-3-5047
Bblid
479897
Inspectionid
357675
Inspect Date
2023-05-25T00:00:00.000
Atdissuedate
2023-05-25T10:44:38.000
Cb
14
House Num
15
Onstname
WELLINGTON CT.
Atddismissed
No
2442
Atdid: 2442 • Atd Number: ATD-3-1585 • Bblid: 340840
Atdid
2442
Atd Number
ATD-3-1585
Bblid
340840
Violationid
239548
Atdissuedate
2020-01-31T00:00:00.000
Cb
1
House Num
170
Onstname
JAVA STREET
Atddismissed
Yes
Atddismissedon
2023-09-29T14:24:27.000
11932
Atdid: 11932 • Atd Number: ATD-3-4883 • Bblid: 286551
Atdid
11932
Atd Number
ATD-3-4883
Bblid
286551
Inspectionid
354189
Inspect Date
2023-03-28T00:00:00.000
Atdissuedate
2023-03-29T12:43:43.000
Cb
8
House Num
179
Onstname
PROSPECT PL.
Atddismissed
No
17699
Atdid: 17699 • Atd Number: ATD-4-6955 • Bblid: 755194
Atdid
17699
Atd Number
ATD-4-6955
Bblid
755194
Inspectionid
398061
Inspect Date
2025-05-20T00:00:00.000
Atdissuedate
2025-05-21T12:56:33.000
Cb
11
House Num
59-18
Onstname
CLOVERDALE BLVD.
Atddismissed
No
12668
Atdid: 12668 • Atd Number: ATD-5-710 • Bblid: 1023883
Atdid
12668
Atd Number
ATD-5-710
Bblid
1023883
Inspectionid
359074
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-06-28T15:48:05.000
Cb
3
House Num
680
Onstname
ARTHUR KILL RD.
Atddismissed
No
13532
Atdid: 13532 • Atd Number: ATD-4-5571 • Bblid: 761615
Atdid
13532
Atd Number
ATD-4-5571
Bblid
761615
Inspectionid
364841
Inspect Date
2023-09-22T00:00:00.000
Atdissuedate
2023-10-03T15:27:42.000
Cb
13
House Num
88-34
Onstname
240TH ST.
Atddismissed
No
11333
Atdid: 11333 • Atd Number: ATD-1-220 • Bblid: 74559
Atdid
11333
Atd Number
ATD-1-220
Bblid
74559
Inspectionid
347510
Inspect Date
2022-11-03T00:00:00.000
Atdissuedate
2022-11-03T10:59:37.000
Cb
7
House Num
25
Onstname
W. 90TH ST.
Atddismissed
No
18481
Atdid: 18481 • Atd Number: ATD-2-1456 • Bblid: 225343
Atdid
18481
Atd Number
ATD-2-1456
Bblid
225343
Inspectionid
405202
Inspect Date
2025-08-26T00:00:00.000
Atdissuedate
2025-09-04T14:09:23.000
Cb
12
House Num
4125
Onstname
BAYCHESTER AVE.
Atddismissed
No
15006
Atdid: 15006 • Atd Number: ATD-3-6246 • Bblid: 547395
Atdid
15006
Atd Number
ATD-3-6246
Bblid
547395
Inspectionid
381543
Inspect Date
2024-08-12T00:00:00.000
Atdissuedate
2024-09-09T11:56:17.000
Cb
18
House Num
7271
Onstname
ROYCE PL.
Atddismissed
No
13141
Atdid: 13141 • Atd Number: ATD-2-1212 • Bblid: 237741
Atdid
13141
Atd Number
ATD-2-1212
Bblid
237741
Inspectionid
361522
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-08-04T12:22:35.000
Cb
10
House Num
940
Onstname
REVERE AVE.
Atddismissed
No
9657
Atdid: 9657 • Atd Number: ATD-4-4360 • Bblid: 797683
Atdid
9657
Atd Number
ATD-4-4360
Bblid
797683
Inspectionid
333854
Inspect Date
2019-08-09T00:00:00.000
Atdissuedate
2022-03-16T15:35:06.000
Cb
9
House Num
102-08
Onstname
VAN WYCK EXPY.
Atddismissed
No
13626
Atdid: 13626 • Atd Number: ATD-3-5608 • Bblid: 323539
Atdid
13626
Atd Number
ATD-3-5608
Bblid
323539
Inspectionid
366045
Inspect Date
2023-10-28T00:00:00.000
Atdissuedate
2023-10-28T07:36:37.000
Cb
3
House Num
379
Onstname
GREENE AVE.
Atddismissed
No
16921
Atdid: 16921 • Atd Number: ATD-4-6648 • Bblid: 643549
Atdid
16921
Atd Number
ATD-4-6648
Bblid
643549
Inspectionid
391049
Inspect Date
2025-03-07T00:00:00.000
Atdissuedate
2025-03-13T15:04:25.000
Cb
5
House Num
59-38
Onstname
69TH LN.
Atddismissed
No
11656
Atdid: 11656 • Atd Number: ATD-3-4735 • Bblid: 279448
Atdid
11656
Atd Number
ATD-3-4735
Bblid
279448
Violationid
281334
Reinspectionid
33908
Inspect Date
2023-02-13T09:48:33.000
Atdissuedate
2023-02-13T09:48:33.000
Cb
6
House Num
197A
Onstname
12 STREET
Atddismissed
Yes
Atddismissedon
2024-03-06T18:30:37.000
12459
Atdid: 12459 • Atd Number: ATD-4-5291 • Bblid: 775463
Atdid
12459
Atd Number
ATD-4-5291
Bblid
775463
Inspectionid
357952
Inspect Date
2023-05-31T00:00:00.000
Atdissuedate
2023-06-02T07:51:11.000
Cb
13
House Num
265-12
Onstname
E. WILLISTON AVE.
Atddismissed
No
12581
Atdid: 12581 • Atd Number: ATD-2-1158 • Bblid: 149030
Atdid
12581
Atd Number
ATD-2-1158
Bblid
149030
Inspectionid
358582
Inspect Date
2023-06-15T00:00:00.000
Atdissuedate
2023-06-15T10:02:00.000
Cb
2
House Num
916
Onstname
REV JAMES POLITE AVE
Atddismissed
No
10319
Atdid: 10319 • Atd Number: ATD-4-4675 • Bblid: 834944
Atdid
10319
Atd Number
ATD-4-4675
Bblid
834944
Inspectionid
337923
Inspect Date
2022-06-15T00:00:00.000
Atdissuedate
2022-06-21T14:45:41.000
Cb
12
House Num
194-13
Onstname
112TH AVE.
Atddismissed
No
17263
Atdid: 17263 • Atd Number: ATD-2-1374 • Bblid: 176272
Atdid
17263
Atd Number
ATD-2-1374
Bblid
176272
Inspectionid
393265
Inspect Date
2025-04-02T00:00:00.000
Atdissuedate
2025-04-04T16:17:52.000
Cb
9
House Num
1131
Onstname
THIERIOT AVE.
Atddismissed
No
9351
Atdid: 9351 • Atd Number: ATD-3-3448 • Bblid: 505705
Atdid
9351
Atd Number
ATD-3-3448
Bblid
505705
Inspectionid
333074
Inspect Date
2021-05-04T00:00:00.000
Atdissuedate
2022-03-02T17:13:51.000
Cb
15
House Num
2047
Onstname
COYLE ST.
Atddismissed
No
14593
Atdid: 14593 • Atd Number: ATD-3-6040 • Bblid: 287476
Atdid
14593
Atd Number
ATD-3-6040
Bblid
287476
Violationid
285717
Reinspectionid
36644
Inspect Date
2024-06-13T13:48:44.000
Atdissuedate
2024-06-13T13:48:44.000
Cb
8
House Num
291
Onstname
STERLING PLACE
Atddismissed
No
12387
Atdid: 12387 • Atd Number: ATD-4-5253 • Bblid: 604342
Atdid
12387
Atd Number
ATD-4-5253
Bblid
604342
Inspectionid
357544
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:47:23.000
Cb
2
House Num
70-55
Onstname
QUEENS BLVD.
Atddismissed
No
16440
Atdid: 16440 • Atd Number: ATD-4-6457 • Bblid: 735010
Atdid
16440
Atd Number
ATD-4-6457
Bblid
735010
Inspectionid
385438
Inspect Date
2024-11-25T00:00:00.000
Atdissuedate
2024-11-29T07:41:12.000
Cb
8
House Num
73-44
Onstname
136TH ST.
Atddismissed
No
12439
Atdid: 12439 • Atd Number: ATD-3-5050 • Bblid: 469180
Atdid
12439
Atd Number
ATD-3-5050
Bblid
469180
Inspectionid
357805
Inspect Date
2023-05-24T00:00:00.000
Atdissuedate
2023-05-30T10:35:07.000
Cb
11
House Num
301
Onstname
BAY 13TH ST.
Atddismissed
No
16319
Atdid: 16319 • Atd Number: ATD-3-6396 • Bblid: 283426
Atdid
16319
Atd Number
ATD-3-6396
Bblid
283426
Inspectionid
384555
Inspect Date
2024-10-22T00:00:00.000
Atdissuedate
2024-10-29T12:26:21.000
Cb
6
House Num
683
Onstname
10TH ST.
Atddismissed
No
11152
Atdid: 11152 • Atd Number: ATD-3-4477 • Bblid: 536424
Atdid
11152
Atd Number
ATD-3-4477
Bblid
536424
Inspectionid
345957
Inspect Date
2022-10-12T00:00:00.000
Atdissuedate
2022-10-14T13:20:35.000
Cb
18
House Num
1312
Onstname
E. 84TH ST.
Atddismissed
No
18026
Atdid: 18026 • Atd Number: ATD-4-7116 • Bblid: 770935
Atdid
18026
Atd Number
ATD-4-7116
Bblid
770935
Inspectionid
401844
Inspect Date
2025-07-03T00:00:00.000
Atdissuedate
2025-07-07T08:49:20.000
Cb
13
House Num
84-60
Onstname
253RD ST.
Atddismissed
No
11183
Atdid: 11183 • Atd Number: ATD-3-4501 • Bblid: 425061
Atdid
11183
Atd Number
ATD-3-4501
Bblid
425061
Inspectionid
346148
Inspect Date
2022-10-12T00:00:00.000
Atdissuedate
2022-10-17T10:25:38.000
Cb
12
House Num
1544
Onstname
54TH ST.
Atddismissed
No
12110
Atdid: 12110 • Atd Number: ATD-3-4964 • Bblid: 328390
Atdid
12110
Atd Number
ATD-3-4964
Bblid
328390
Inspectionid
356381
Inspect Date
2023-04-27T00:00:00.000
Atdissuedate
2023-04-27T15:23:54.000
Cb
2
House Num
185
Onstname
ASHLAND PL.
Atddismissed
No
18347
Atdid: 18347 • Atd Number: ATD-4-7256 • Bblid: 855433
Atdid
18347
Atd Number
ATD-4-7256
Bblid
855433
Inspectionid
404367
Inspect Date
2025-07-25T00:00:00.000
Atdissuedate
2025-08-18T10:15:38.000
Cb
10
Onstname
121 STREET
Atddismissed
No
12366
Atdid: 12366 • Atd Number: ATD-4-5232 • Bblid: 604306
Atdid
12366
Atd Number
ATD-4-5232
Bblid
604306
Inspectionid
357523
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:33:33.000
Cb
2
House Num
70-01
Onstname
QUEENS BLVD.
Atddismissed
No
5648
Atdid: 5648 • Atd Number: ATD-4-2009 • Bblid: 887626
Atdid
5648
Atd Number
ATD-4-2009
Bblid
887626
Violationid
227493
Atdissuedate
2020-05-22T00:00:00.000
Cb
13
House Num
225-17
Onstname
139 AVENUE
Atddismissed
Yes
Atddismissedon
2024-03-27T11:11:16.000
12922
Atdid: 12922 • Atd Number: ATD-3-5209 • Bblid: 431409
Atdid
12922
Atd Number
ATD-3-5209
Bblid
431409
Inspectionid
360341
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T10:33:47.000
Cb
12
House Num
1437
Onstname
44TH ST.
Atddismissed
No
13767
Atdid: 13767 • Atd Number: ATD-5-861 • Bblid: 956084
Atdid
13767
Atd Number
ATD-5-861
Bblid
956084
Inspectionid
369269
Inspect Date
2023-12-07T00:00:00.000
Atdissuedate
2023-12-11T11:59:38.000
Cb
1
House Num
19
Onstname
WRIGHT AVE.
Atddismissed
No
13749
Atdid: 13749 • Atd Number: ATD-4-5662 • Bblid: 901842
Atdid
13749
Atd Number
ATD-4-5662
Bblid
901842
Inspectionid
369121
Inspect Date
2023-12-06T00:00:00.000
Atdissuedate
2023-12-07T15:06:59.000
Cb
10
House Num
94-11
Onstname
157TH AVE.
Atddismissed
No
12915
Atdid: 12915 • Atd Number: ATD-3-5202 • Bblid: 432111
Atdid
12915
Atd Number
ATD-3-5202
Bblid
432111
Inspectionid
360334
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T10:09:37.000
Cb
12
House Num
1456
Onstname
44TH ST.
Atddismissed
No
10494
Atdid: 10494 • Atd Number: ATD-3-3963 • Bblid: 326425
Atdid
10494
Atd Number
ATD-3-3963
Bblid
326425
Inspectionid
339914
Inspect Date
2022-06-29T00:00:00.000
Atdissuedate
2022-07-18T09:14:33.000
Cb
2
House Num
466
Onstname
CARLTON AVE.
Atddismissed
No
10078
Atdid: 10078 • Atd Number: ATD-3-3698 • Bblid: 407415
Atdid
10078
Atd Number
ATD-3-3698
Bblid
407415
Inspectionid
336350
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-11T12:35:36.000
Cb
9
House Num
256
Onstname
MIDWOOD ST.
Atddismissed
No
11791
Atdid: 11791 • Atd Number: ATD-2-982 • Bblid: 225312
Atdid
11791
Atd Number
ATD-2-982
Bblid
225312
Violationid
277625
Reinspectionid
32904
Inspect Date
2023-03-14T11:10:48.000
Atdissuedate
2023-03-14T11:10:48.000
Cb
12
House Num
4213
Onstname
BRUNER AVENUE
Atddismissed
No
9310
Atdid: 9310 • Atd Number: ATD-3-3414 • Bblid: 416999
Atdid
9310
Atd Number
ATD-3-3414
Bblid
416999
Inspectionid
333016
Inspect Date
2017-11-29T00:00:00.000
Atdissuedate
2022-03-02T08:51:15.000
Cb
12
House Num
154
Onstname
TEHAMA ST.
Atddismissed
No
11425
Atdid: 11425 • Atd Number: ATD-3-4647 • Bblid: 255492
Atdid
11425
Atd Number
ATD-3-4647
Bblid
255492
Inspectionid
348438
Inspect Date
2022-11-19T00:00:00.000
Atdissuedate
2022-11-21T10:41:54.000
Cb
6
House Num
334
Onstname
CLINTON ST.
Atddismissed
No
11492
Atdid: 11492 • Atd Number: ATD-1-264 • Bblid: 129400
Atdid
11492
Atd Number
ATD-1-264
Bblid
129400
Inspectionid
349149
Inspect Date
2022-11-15T00:00:00.000
Atdissuedate
2022-12-12T13:09:53.000
Cb
10
House Num
34
Onstname
EDGECOMBE AVE.
Atddismissed
No
12171
Atdid: 12171 • Atd Number: ATD-4-5178 • Bblid: 842743
Atdid
12171
Atd Number
ATD-4-5178
Bblid
842743
Inspectionid
356790
Inspect Date
2023-04-21T00:00:00.000
Atdissuedate
2023-05-09T08:52:40.000
Cb
13
House Num
223-39
Onstname
113TH DR.
Atddismissed
No
NYC Data AI • Public-data exploration interface