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
12630
Atdid: 12630 • Atd Number: ATD-4-5375 • Bblid: 607815
Atdid
12630
Atd Number
ATD-4-5375
Bblid
607815
Inspectionid
358882
Inspect Date
2023-06-22T00:00:00.000
Atdissuedate
2023-06-22T11:29:43.000
Cb
3
House Num
33-40
Onstname
83RD ST.
Atddismissed
No
14336
Atdid: 14336 • Atd Number: ATD-4-5985 • Bblid: 641022
Atdid
14336
Atd Number
ATD-4-5985
Bblid
641022
Inspectionid
375968
Inspect Date
2024-04-15T00:00:00.000
Atdissuedate
2024-04-23T13:14:27.000
Cb
5
House Num
57-31
Onstname
65TH ST.
Atddismissed
No
8743
Atdid: 8743 • Atd Number: ATD-4-3939 • Bblid: 772523
Atdid
8743
Atd Number
ATD-4-3939
Bblid
772523
Inspectionid
331097
Inspect Date
2021-12-08T00:00:00.000
Atdissuedate
2021-12-28T13:12:48.000
Cb
13
House Num
267-18
Onstname
78TH AVE.
Atddismissed
Yes
Atddismissedon
2022-04-08T13:43:59.000
11952
Atdid: 11952 • Atd Number: ATD-2-1003 • Bblid: 226975
Atdid
11952
Atd Number
ATD-2-1003
Bblid
226975
Inspectionid
354285
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-31T09:12:42.000
Cb
12
House Num
4330
Onstname
ELY AVE.
Atddismissed
No
14206
Atdid: 14206 • Atd Number: ATD-4-5909 • Bblid: 819149
Atdid
14206
Atd Number
ATD-4-5909
Bblid
819149
Inspectionid
373946
Inspect Date
2024-03-21T00:00:00.000
Atdissuedate
2024-03-21T13:20:36.000
Cb
12
House Num
111-85
Onstname
180TH ST.
Atddismissed
No
15104
Atdid: 15104 • Atd Number: ATD-4-6303 • Bblid: 598387
Atdid
15104
Atd Number
ATD-4-6303
Bblid
598387
Inspectionid
382184
Inspect Date
2024-09-19T00:00:00.000
Atdissuedate
2024-09-23T13:40:33.000
Cb
3
House Num
32-20
Onstname
74TH ST.
Atddismissed
No
18439
Atdid: 18439 • Atd Number: ATD-4-7298 • Bblid: 678507
Atdid
18439
Atd Number
ATD-4-7298
Bblid
678507
Violationid
301222
Reinspectionid
39299
Inspect Date
2025-08-27T12:18:26.000
Atdissuedate
2025-08-27T12:18:26.000
Cb
6
House Num
89-17
Onstname
70 AVENUE
Atddismissed
No
16153
Atdid: 16153 • Atd Number: ATD-4-6331 • Bblid: 861136
Atdid
16153
Atd Number
ATD-4-6331
Bblid
861136
Inspectionid
383558
Inspect Date
2024-09-19T00:00:00.000
Atdissuedate
2024-09-30T13:59:45.000
Cb
12
House Num
111-64
Onstname
146TH ST.
Atddismissed
No
9815
Atdid: 9815 • Atd Number: ATD-3-3605 • Bblid: 443327
Atdid
9815
Atd Number
ATD-3-3605
Bblid
443327
Inspectionid
334493
Inspect Date
2022-03-31T00:00:00.000
Atdissuedate
2022-04-02T12:30:41.000
Cb
10
House Num
1032
Onstname
BAY RIDGE AVE.
Atddismissed
No
11469
Atdid: 11469 • Atd Number: ATD-3-4678 • Bblid: 257429
Atdid
11469
Atd Number
ATD-3-4678
Bblid
257429
Inspectionid
348759
Inspect Date
2022-11-29T00:00:00.000
Atdissuedate
2022-11-29T15:21:27.000
Cb
6
House Num
67
Onstname
3RD PL.
Atddismissed
No
9201
Atdid: 9201 • Atd Number: ATD-3-3355 • Bblid: 436157
Atdid
9201
Atd Number
ATD-3-3355
Bblid
436157
Inspectionid
332859
Inspect Date
2021-05-10T00:00:00.000
Atdissuedate
2022-02-28T17:37:17.000
Cb
12
House Num
5606
Onstname
12TH AVE.
Atddismissed
No
9982
Atdid: 9982 • Atd Number: ATD-4-4538 • Bblid: 746866
Atdid
9982
Atd Number
ATD-4-4538
Bblid
746866
Inspectionid
335729
Inspect Date
2022-04-04T00:00:00.000
Atdissuedate
2022-04-27T12:08:37.000
Cb
8
House Num
67-56
Onstname
199TH ST.
Atddismissed
No
16651
Atdid: 16651 • Atd Number: ATD-2-1330 • Bblid: 162060
Atdid
16651
Atd Number
ATD-2-1330
Bblid
162060
Inspectionid
388505
Inspect Date
2025-01-03T00:00:00.000
Atdissuedate
2025-01-06T13:06:25.000
Cb
5
House Num
2188
Onstname
VALENTINE AVE.
Atddismissed
No
449
Atdid: 449 • Atd Number: ATD-2-316 • Bblid: 172138
Atdid
449
Atd Number
ATD-2-316
Bblid
172138
Violationid
226978
Atdissuedate
2019-11-02T00:00:00.000
Cb
9
House Num
1869
Onstname
LACOMBE AVENUE
Atddismissed
Yes
Atddismissedon
2022-05-24T09:25:39.000
17931
Atdid: 17931 • Atd Number: ATD-4-7088 • Bblid: 577109
Atdid
17931
Atd Number
ATD-4-7088
Bblid
577109
Violationid
299340
Reinspectionid
39140
Inspect Date
2025-06-23T07:55:09.000
Atdissuedate
2025-06-23T07:55:09.000
Cb
1
House Num
34-53
Onstname
25 STREET
Atddismissed
No
17623
Atdid: 17623 • Atd Number: ATD-4-6894 • Bblid: 572469
Atdid
17623
Atd Number
ATD-4-6894
Bblid
572469
Inspectionid
397154
Inspect Date
2025-05-02T00:00:00.000
Atdissuedate
2025-05-15T15:15:15.000
Cb
1
House Num
35-05
Onstname
28TH ST.
Atddismissed
No
9963
Atdid: 9963 • Atd Number: ATD-3-3650 • Bblid: 270578
Atdid
9963
Atd Number
ATD-3-3650
Bblid
270578
Inspectionid
335459
Inspect Date
2022-04-05T00:00:00.000
Atdissuedate
2022-04-25T08:36:40.000
Cb
7
House Num
448
Onstname
58TH ST.
Atddismissed
No
17840
Atdid: 17840 • Atd Number: ATD-4-7038 • Bblid: 810870
Atdid
17840
Atd Number
ATD-4-7038
Bblid
810870
Inspectionid
399589
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-09T12:10:33.000
Cb
8
House Num
85-19
Onstname
RADNOR ST.
Atddismissed
No
12049
Atdid: 12049 • Atd Number: ATD-2-1014 • Bblid: 211308
Atdid
12049
Atd Number
ATD-2-1014
Bblid
211308
Inspectionid
355971
Inspect Date
2023-04-06T00:00:00.000
Atdissuedate
2023-04-17T13:31:48.000
Cb
12
House Num
3330
Onstname
BRONX BLVD.
Atddismissed
No
17305
Atdid: 17305 • Atd Number: ATD-3-6845 • Bblid: 474536
Atdid
17305
Atd Number
ATD-3-6845
Bblid
474536
Inspectionid
394119
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-10T16:04:40.000
Cb
11
House Num
1537
Onstname
W. 10TH ST.
Atddismissed
No
16266
Atdid: 16266 • Atd Number: ATD-3-6364 • Bblid: 435005
Atdid
16266
Atd Number
ATD-3-6364
Bblid
435005
Inspectionid
384272
Inspect Date
2024-10-17T00:00:00.000
Atdissuedate
2024-10-21T12:32:17.000
Cb
12
House Num
833
Onstname
54TH ST.
Atddismissed
No
9348
Atdid: 9348 • Atd Number: ATD-3-3445 • Bblid: 497449
Atdid
9348
Atd Number
ATD-3-3445
Bblid
497449
Inspectionid
333071
Inspect Date
2021-01-07T00:00:00.000
Atdissuedate
2022-03-02T17:07:25.000
Cb
15
House Num
52
Onstname
VILLAGE RD. E.
Atddismissed
No
13199
Atdid: 13199 • Atd Number: ATD-3-5378 • Bblid: 422452
Atdid
13199
Atd Number
ATD-3-5378
Bblid
422452
Inspectionid
361839
Inspect Date
2023-08-10T00:00:00.000
Atdissuedate
2023-08-10T11:26:54.000
Cb
12
House Num
4525
Onstname
16 AVENUE
Atddismissed
No
16767
Atdid: 16767 • Atd Number: ATD-3-6572 • Bblid: 302491
Atdid
16767
Atd Number
ATD-3-6572
Bblid
302491
Inspectionid
389258
Inspect Date
2024-09-11T00:00:00.000
Atdissuedate
2025-02-03T11:10:31.000
Cb
3
House Num
588
Onstname
DECATUR ST.
Atddismissed
No
11836
Atdid: 11836 • Atd Number: ATD-3-4811 • Bblid: 422962
Atdid
11836
Atd Number
ATD-3-4811
Bblid
422962
Inspectionid
353506
Inspect Date
2023-03-16T00:00:00.000
Atdissuedate
2023-03-21T11:58:00.000
Cb
12
House Num
1730
Onstname
46TH ST.
Atddismissed
No
11224
Atdid: 11224 • Atd Number: ATD-3-4530 • Bblid: 530305
Atdid
11224
Atd Number
ATD-3-4530
Bblid
530305
Inspectionid
346657
Inspect Date
2022-10-13T00:00:00.000
Atdissuedate
2022-10-21T15:16:55.000
Cb
17
House Num
230
Onstname
E. 89TH ST.
Atddismissed
No
13303
Atdid: 13303 • Atd Number: ATD-3-5456 • Bblid: 417184
Atdid
13303
Atd Number
ATD-3-5456
Bblid
417184
Inspectionid
362460
Inspect Date
2023-08-07T00:00:00.000
Atdissuedate
2023-08-22T13:52:46.000
Cb
12
House Num
44
Onstname
LOUISA ST.
Atddismissed
No
11762
Atdid: 11762 • Atd Number: ATD-3-4787 • Bblid: 285533
Atdid
11762
Atd Number
ATD-3-4787
Bblid
285533
Inspectionid
352614
Inspect Date
2023-03-10T00:00:00.000
Atdissuedate
2023-03-10T11:27:59.000
Cb
8
House Num
912
Onstname
PACIFIC ST.
Atddismissed
No
13423
Atdid: 13423 • Atd Number: ATD-5-821 • Bblid: 963713
Atdid
13423
Atd Number
ATD-5-821
Bblid
963713
Inspectionid
363790
Inspect Date
2023-08-18T00:00:00.000
Atdissuedate
2023-09-18T14:27:00.000
Cb
2
House Num
255
Onstname
HILLMAN AVE.
Atddismissed
No
11471
Atdid: 11471 • Atd Number: ATD-4-4897 • Bblid: 596334
Atdid
11471
Atd Number
ATD-4-4897
Bblid
596334
Inspectionid
348811
Inspect Date
2022-11-09T00:00:00.000
Atdissuedate
2022-12-01T08:45:42.000
Cb
3
House Num
30-11
Onstname
70TH ST.
Atddismissed
No
8511
Atdid: 8511 • Atd Number: ATD-4-3826 • Bblid: 661619
Atdid
8511
Atd Number
ATD-4-3826
Bblid
661619
Inspectionid
329714
Inspect Date
2021-11-19T00:00:00.000
Atdissuedate
2021-11-19T13:30:26.000
Cb
6
House Num
111-09
Onstname
77TH AVE.
Atddismissed
No
16509
Atdid: 16509 • Atd Number: ATD-3-6452 • Bblid: 495430
Atdid
16509
Atd Number
ATD-3-6452
Bblid
495430
Inspectionid
386222
Inspect Date
2024-12-12T00:00:00.000
Atdissuedate
2024-12-13T16:27:37.000
Cb
15
House Num
2091
Onstname
E. 2ND ST.
Atddismissed
No
14778
Atdid: 14778 • Atd Number: ATD-4-6168 • Bblid: 894212
Atdid
14778
Atd Number
ATD-4-6168
Bblid
894212
Inspectionid
379696
Inspect Date
2024-07-10T00:00:00.000
Atdissuedate
2024-07-22T13:25:35.000
Cb
13
House Num
143-42
Onstname
243RD ST.
Atddismissed
No
10092
Atdid: 10092 • Atd Number: ATD-3-3711 • Bblid: 472303
Atdid
10092
Atd Number
ATD-3-3711
Bblid
472303
Inspectionid
336451
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-16T10:46:53.000
Cb
11
House Num
2318
Onstname
62ND ST.
Atddismissed
No
11586
Atdid: 11586 • Atd Number: ATD-4-4952 • Bblid: 714664
Atdid
11586
Atd Number
ATD-4-4952
Bblid
714664
Inspectionid
350308
Inspect Date
2023-01-05T00:00:00.000
Atdissuedate
2023-01-10T11:51:08.000
Cb
7
House Num
45-57
Onstname
167TH ST.
Atddismissed
No
17554
Atdid: 17554 • Atd Number: ATD-2-1392 • Bblid: 207634
Atdid
17554
Atd Number
ATD-2-1392
Bblid
207634
Inspectionid
396344
Inspect Date
2025-05-02T00:00:00.000
Atdissuedate
2025-05-06T16:38:24.000
Cb
11
House Num
2425
Onstname
DELANOY AVE.
Atddismissed
No
8925
Atdid: 8925 • Atd Number: ATD-3-3256 • Bblid: 279990
Atdid
8925
Atd Number
ATD-3-3256
Bblid
279990
Inspectionid
332152
Inspect Date
2019-07-24T00:00:00.000
Atdissuedate
2022-01-31T10:08:47.000
Cb
6
House Num
171
Onstname
13TH ST.
Atddismissed
No
18346
Atdid: 18346 • Atd Number: ATD-4-7255 • Bblid: 855432
Atdid
18346
Atd Number
ATD-4-7255
Bblid
855432
Inspectionid
404366
Inspect Date
2025-07-25T00:00:00.000
Atdissuedate
2025-08-18T10:15:13.000
Cb
10
House Num
116-58
Onstname
121ST ST.
Atddismissed
No
16223
Atdid: 16223 • Atd Number: ATD-4-6372 • Bblid: 917459
Atdid
16223
Atd Number
ATD-4-6372
Bblid
917459
Inspectionid
384130
Inspect Date
2024-10-10T00:00:00.000
Atdissuedate
2024-10-15T11:36:09.000
Cb
14
House Num
224
Onstname
BEACH 125TH ST.
Atddismissed
No
12250
Atdid: 12250 • Atd Number: ATD-2-1067 • Bblid: 152888
Atdid
12250
Atd Number
ATD-2-1067
Bblid
152888
Inspectionid
357211
Inspect Date
2023-05-17T00:00:00.000
Atdissuedate
2023-05-17T11:42:02.000
Cb
4
House Num
1306
Onstname
JEROME AVE.
Atddismissed
No
17136
Atdid: 17136 • Atd Number: ATD-4-6690 • Bblid: 678795
Atdid
17136
Atd Number
ATD-4-6690
Bblid
678795
Inspectionid
392590
Inspect Date
2025-03-28T00:00:00.000
Atdissuedate
2025-03-31T08:48:53.000
Cb
6
House Num
91-09
Onstname
71ST AVE.
Atddismissed
No
11026
Atdid: 11026 • Atd Number: ATD-3-4377 • Bblid: 254532
Atdid
11026
Atd Number
ATD-3-4377
Bblid
254532
Inspectionid
344643
Inspect Date
2022-09-21T00:00:00.000
Atdissuedate
2022-09-27T15:19:00.000
Cb
6
House Num
153
Onstname
WARREN ST.
Atddismissed
No
17932
Atdid: 17932 • Atd Number: ATD-3-7049 • Bblid: 385993
Atdid
17932
Atd Number
ATD-3-7049
Bblid
385993
Inspectionid
400698
Inspect Date
2025-06-12T00:00:00.000
Atdissuedate
2025-06-23T09:12:17.000
Cb
5
House Num
703
Onstname
ASHFORD ST.
Atddismissed
No
12958
Atdid: 12958 • Atd Number: ATD-2-1197 • Bblid: 201608
Atdid
12958
Atd Number
ATD-2-1197
Bblid
201608
Inspectionid
360535
Inspect Date
2023-07-19T00:00:00.000
Atdissuedate
2023-07-24T10:24:29.000
Cb
11
House Num
928
Onstname
NEILL AVE.
Atddismissed
No
9199
Atdid: 9199 • Atd Number: ATD-3-3354 • Bblid: 435547
Atdid
9199
Atd Number
ATD-3-3354
Bblid
435547
Inspectionid
332857
Inspect Date
2021-07-19T00:00:00.000
Atdissuedate
2022-02-28T17:35:57.000
Cb
12
House Num
1359
Onstname
55TH ST.
Atddismissed
No
14098
Atdid: 14098 • Atd Number: ATD-3-5783 • Bblid: 521753
Atdid
14098
Atd Number
ATD-3-5783
Bblid
521753
Inspectionid
373020
Inspect Date
2024-03-12T00:00:00.000
Atdissuedate
2024-03-12T09:47:34.000
Cb
18
House Num
960
Onstname
E. 40TH ST.
Atddismissed
Yes
Atddismissedon
2024-03-15T11:41:29.000
12560
Atdid: 12560 • Atd Number: ATD-3-5077 • Bblid: 407298
Atdid
12560
Atd Number
ATD-3-5077
Bblid
407298
Inspectionid
358511
Inspect Date
2023-05-11T00:00:00.000
Atdissuedate
2023-06-13T14:56:00.000
Cb
9
House Num
133
Onstname
MIDWOOD ST.
Atddismissed
No
9565
Atdid: 9565 • Atd Number: ATD-3-3556 • Bblid: 310900
Atdid
9565
Atd Number
ATD-3-3556
Bblid
310900
Inspectionid
333653
Inspect Date
2021-08-20T00:00:00.000
Atdissuedate
2022-03-11T10:26:40.000
Cb
3
House Num
457A
Onstname
MACDONOUGH ST.
Atddismissed
No
8579
Atdid: 8579 • Atd Number: ATD-4-3851 • Bblid: 828909
Atdid
8579
Atd Number
ATD-4-3851
Bblid
828909
Inspectionid
330519
Inspect Date
2019-06-26T00:00:00.000
Atdissuedate
2021-12-10T09:51:48.000
Cb
13
House Num
214-04
Onstname
WHITEHALL TER.
Atddismissed
No
17897
Atdid: 17897 • Atd Number: ATD-4-7076 • Bblid: 701038
Atdid
17897
Atd Number
ATD-4-7076
Bblid
701038
Inspectionid
400438
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-16T11:38:30.000
Cb
7
House Num
144-41
Onstname
38TH AVE.
Atddismissed
No
NYC Data AI • Public-data exploration interface