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
13144
Atdid: 13144 • Atd Number: ATD-5-788 • Bblid: 952166
Atdid
13144
Atd Number
ATD-5-788
Bblid
952166
Inspectionid
361553
Inspect Date
2023-08-05T00:00:00.000
Atdissuedate
2023-08-07T08:38:48.000
Cb
2
House Num
18
Onstname
SYDNEY PL.
Atddismissed
No
18015
Atdid: 18015 • Atd Number: ATD-5-1002 • Bblid: 1028722
Atdid
18015
Atd Number
ATD-5-1002
Bblid
1028722
Inspectionid
401705
Inspect Date
2025-06-12T00:00:00.000
Atdissuedate
2025-07-01T12:45:57.000
Cb
3
House Num
604
Onstname
DRUMGOOLE RD. W.
Atddismissed
No
13151
Atdid: 13151 • Atd Number: ATD-3-5351 • Bblid: 294517
Atdid
13151
Atd Number
ATD-3-5351
Bblid
294517
Inspectionid
361583
Inspect Date
2023-07-14T00:00:00.000
Atdissuedate
2023-08-07T09:40:22.000
Cb
9
House Num
193
Onstname
LEFFERTS AVE.
Atddismissed
No
16772
Atdid: 16772 • Atd Number: ATD-3-6577 • Bblid: 419970
Atdid
16772
Atd Number
ATD-3-6577
Bblid
419970
Inspectionid
389283
Inspect Date
2025-01-31T00:00:00.000
Atdissuedate
2025-02-03T11:45:27.000
Cb
12
House Num
362
Onstname
E. 9TH ST.
Atddismissed
No
9579
Atdid: 9579 • Atd Number: ATD-4-4301 • Bblid: 769865
Atdid
9579
Atd Number
ATD-4-4301
Bblid
769865
Inspectionid
333691
Inspect Date
2019-08-20T00:00:00.000
Atdissuedate
2022-03-11T16:25:18.000
Cb
13
House Num
82-35
Onstname
247TH ST.
Atddismissed
No
17331
Atdid: 17331 • Atd Number: ATD-4-6756 • Bblid: 781546
Atdid
17331
Atd Number
ATD-4-6756
Bblid
781546
Inspectionid
394464
Inspect Date
2025-04-10T00:00:00.000
Atdissuedate
2025-04-14T08:51:00.000
Cb
9
House Num
91-29
Onstname
85TH ST.
Atddismissed
No
11886
Atdid: 11886 • Atd Number: ATD-3-4858 • Bblid: 444421
Atdid
11886
Atd Number
ATD-3-4858
Bblid
444421
Inspectionid
353839
Inspect Date
2022-05-20T00:00:00.000
Atdissuedate
2023-03-27T09:24:49.000
Cb
10
House Num
1032
Onstname
71ST ST.
Atddismissed
No
14340
Atdid: 14340 • Atd Number: ATD-4-5989 • Bblid: 649180
Atdid
14340
Atd Number
ATD-4-5989
Bblid
649180
Inspectionid
375981
Inspect Date
2024-04-17T00:00:00.000
Atdissuedate
2024-04-23T13:31:41.000
Cb
5
House Num
75-18
Onstname
JUNIPER BLVD. S.
Atddismissed
No
10047
Atdid: 10047 • Atd Number: ATD-4-4588 • Bblid: 654684
Atdid
10047
Atd Number
ATD-4-4588
Bblid
654684
Inspectionid
336110
Inspect Date
2022-04-30T00:00:00.000
Atdissuedate
2022-05-03T14:03:24.000
Cb
6
House Num
62-40
Onstname
CROMWELL CRES
Atddismissed
No
9782
Atdid: 9782 • Atd Number: ATD-4-4429 • Bblid: 663990
Atdid
9782
Atd Number
ATD-4-4429
Bblid
663990
Inspectionid
334375
Inspect Date
2019-09-12T00:00:00.000
Atdissuedate
2022-03-29T18:21:52.000
Cb
5
House Num
1749
Onstname
DEKALB AVE.
Atddismissed
No
9935
Atdid: 9935 • Atd Number: ATD-4-4514 • Bblid: 654395
Atdid
9935
Atd Number
ATD-4-4514
Bblid
654395
Inspectionid
335337
Inspect Date
2022-04-13T00:00:00.000
Atdissuedate
2022-04-21T12:06:21.000
Cb
6
House Num
89-04
Onstname
65TH DR.
Atddismissed
No
8828
Atdid: 8828 • Atd Number: ATD-2-852 • Bblid: 176182
Atdid
8828
Atd Number
ATD-2-852
Bblid
176182
Inspectionid
331623
Inspect Date
2007-07-03T00:00:00.000
Atdissuedate
2022-01-13T12:36:41.000
Cb
9
House Num
1124
Onstname
BEACH AVE.
Atddismissed
No
14904
Atdid: 14904 • Atd Number: ATD-4-6216 • Bblid: 737635
Atdid
14904
Atd Number
ATD-4-6216
Bblid
737635
Inspectionid
380548
Inspect Date
2024-08-07T00:00:00.000
Atdissuedate
2024-08-13T11:22:46.000
Cb
8
House Num
150-19
Onstname
77TH RD.
Atddismissed
No
17648
Atdid: 17648 • Atd Number: ATD-4-6917 • Bblid: 761107
Atdid
17648
Atd Number
ATD-4-6917
Bblid
761107
Inspectionid
397236
Inspect Date
2025-02-11T00:00:00.000
Atdissuedate
2025-05-16T10:55:32.000
Cb
13
House Num
239-21
Onstname
88TH AVE.
Atddismissed
No
14598
Atdid: 14598 • Atd Number: ATD-4-6094 • Bblid: 569077
Atdid
14598
Atd Number
ATD-4-6094
Bblid
569077
Inspectionid
378418
Inspect Date
2024-06-12T00:00:00.000
Atdissuedate
2024-06-17T10:47:03.000
Cb
2
House Num
39-70
Onstname
47TH ST.
Atddismissed
No
17474
Atdid: 17474 • Atd Number: ATD-4-6822 • Bblid: 819697
Atdid
17474
Atd Number
ATD-4-6822
Bblid
819697
Inspectionid
395491
Inspect Date
2025-04-25T00:00:00.000
Atdissuedate
2025-04-28T12:26:30.000
Cb
12
House Num
177-38
Onstname
105TH AVE.
Atddismissed
No
8659
Atdid: 8659 • Atd Number: ATD-4-3886 • Bblid: 862761
Atdid
8659
Atd Number
ATD-4-3886
Bblid
862761
Inspectionid
330805
Inspect Date
2019-07-18T00:00:00.000
Atdissuedate
2021-12-16T10:06:48.000
Cb
12
House Num
116-40
Onstname
146TH ST.
Atddismissed
No
12042
Atdid: 12042 • Atd Number: ATD-3-4935 • Bblid: 414346
Atdid
12042
Atd Number
ATD-3-4935
Bblid
414346
Inspectionid
355919
Inspect Date
2023-04-10T00:00:00.000
Atdissuedate
2023-04-17T10:31:03.000
Cb
14
House Num
717
Onstname
E. 18TH ST.
Atddismissed
No
16483
Atdid: 16483 • Atd Number: ATD-3-6441 • Bblid: 316345
Atdid
16483
Atd Number
ATD-3-6441
Bblid
316345
Inspectionid
385784
Inspect Date
2024-12-06T00:00:00.000
Atdissuedate
2024-12-06T11:11:41.000
Cb
3
House Num
445
Onstname
QUINCY ST.
Atddismissed
No
16424
Atdid: 16424 • Atd Number: ATD-3-6429 • Bblid: 259337
Atdid
16424
Atd Number
ATD-3-6429
Bblid
259337
Inspectionid
385321
Inspect Date
2024-10-17T00:00:00.000
Atdissuedate
2024-11-22T11:49:01.000
Cb
6
House Num
373
Onstname
DEGRAW STREET
Atddismissed
No
16128
Atdid: 16128 • Atd Number: ATD-4-6322 • Bblid: 607287
Atdid
16128
Atd Number
ATD-4-6322
Bblid
607287
Inspectionid
383327
Inspect Date
2024-09-18T00:00:00.000
Atdissuedate
2024-09-27T12:36:05.000
Cb
3
House Num
32-26
Onstname
88TH ST.
Atddismissed
No
13731
Atdid: 13731 • Atd Number: ATD-5-854 • Bblid: 1012339
Atdid
13731
Atd Number
ATD-5-854
Bblid
1012339
Inspectionid
368837
Inspect Date
2023-11-28T00:00:00.000
Atdissuedate
2023-12-05T10:06:17.000
Cb
3
House Num
111
Onstname
CHAMPLAIN AVE.
Atddismissed
No
17148
Atdid: 17148 • Atd Number: ATD-3-6787 • Bblid: 274041
Atdid
17148
Atd Number
ATD-3-6787
Bblid
274041
Inspectionid
392641
Inspect Date
2021-10-28T00:00:00.000
Atdissuedate
2025-03-31T10:07:46.000
Cb
6
House Num
24
Onstname
ST MARKS AVENUE
Atddismissed
No
17302
Atdid: 17302 • Atd Number: ATD-3-6842 • Bblid: 467379
Atdid
17302
Atd Number
ATD-3-6842
Bblid
467379
Inspectionid
394102
Inspect Date
2025-04-09T00:00:00.000
Atdissuedate
2025-04-10T15:36:32.000
Cb
11
House Num
8741
Onstname
21ST AVE.
Atddismissed
No
10707
Atdid: 10707 • Atd Number: ATD-3-4090 • Bblid: 509739
Atdid
10707
Atd Number
ATD-3-4090
Bblid
509739
Inspectionid
342190
Inspect Date
2022-08-20T00:00:00.000
Atdissuedate
2022-08-29T14:15:06.000
Cb
15
House Num
2426
Onstname
E. 17TH ST.
Atddismissed
No
11024
Atdid: 11024 • Atd Number: ATD-3-4375 • Bblid: 254536
Atdid
11024
Atd Number
ATD-3-4375
Bblid
254536
Inspectionid
344641
Inspect Date
2022-09-21T00:00:00.000
Atdissuedate
2022-09-27T15:16:13.000
Cb
6
House Num
149
Onstname
WARREN ST.
Atddismissed
No
13828
Atdid: 13828 • Atd Number: ATD-4-5719 • Bblid: 631248
Atdid
13828
Atd Number
ATD-4-5719
Bblid
631248
Inspectionid
370298
Inspect Date
2023-11-24T00:00:00.000
Atdissuedate
2024-01-02T13:44:05.000
Cb
2
House Num
50-17
Onstname
48TH ST.
Atddismissed
No
14578
Atdid: 14578 • Atd Number: ATD-3-6032 • Bblid: 445845
Atdid
14578
Atd Number
ATD-3-6032
Bblid
445845
Inspectionid
378359
Inspect Date
2024-06-05T00:00:00.000
Atdissuedate
2024-06-11T15:26:13.000
Cb
10
House Num
617
Onstname
BAY RIDGE PKWY.
Atddismissed
No
12889
Atdid: 12889 • Atd Number: ATD-4-5453 • Bblid: 590431
Atdid
12889
Atd Number
ATD-4-5453
Bblid
590431
Inspectionid
360263
Inspect Date
2023-07-19T00:00:00.000
Atdissuedate
2023-07-19T12:53:22.000
Cb
1
House Num
18-09
Onstname
26TH AVE.
Atddismissed
No
8815
Atdid: 8815 • Atd Number: ATD-3-3233 • Bblid: 270286
Atdid
8815
Atd Number
ATD-3-3233
Bblid
270286
Inspectionid
331540
Inspect Date
2021-11-08T00:00:00.000
Atdissuedate
2022-01-07T14:59:07.000
Cb
7
House Num
436
Onstname
57TH ST.
Atddismissed
No
12974
Atdid: 12974 • Atd Number: ATD-4-5461 • Bblid: 897657
Atdid
12974
Atd Number
ATD-4-5461
Bblid
897657
Inspectionid
360610
Inspect Date
2023-07-25T00:00:00.000
Atdissuedate
2023-07-25T10:01:03.000
Cb
13
House Num
259-04
Onstname
148TH DR.
Atddismissed
No
11169
Atdid: 11169 • Atd Number: ATD-1-211 • Bblid: 96130
Atdid
11169
Atd Number
ATD-1-211
Bblid
96130
Inspectionid
346045
Inspect Date
2022-10-14T00:00:00.000
Atdissuedate
2022-10-14T15:14:16.000
Cb
8
House Num
212
Onstname
E. 62ND ST.
Atddismissed
No
14309
Atdid: 14309 • Atd Number: ATD-4-5970 • Bblid: 656422
Atdid
14309
Atd Number
ATD-4-5970
Bblid
656422
Inspectionid
375767
Inspect Date
2024-04-22T00:00:00.000
Atdissuedate
2024-04-22T11:59:46.000
Cb
6
House Num
68-54
Onstname
ALDERTON ST.
Atddismissed
No
9668
Atdid: 9668 • Atd Number: ATD-2-895 • Bblid: 181434
Atdid
9668
Atd Number
ATD-2-895
Bblid
181434
Inspectionid
333865
Inspect Date
2019-06-14T00:00:00.000
Atdissuedate
2022-03-16T17:52:47.000
Cb
9
House Num
1346
Onstname
O'DELL ST.
Atddismissed
No
11363
Atdid: 11363 • Atd Number: ATD-1-228 • Bblid: 26903
Atdid
11363
Atd Number
ATD-1-228
Bblid
26903
Inspectionid
347777
Inspect Date
2022-11-03T00:00:00.000
Atdissuedate
2022-11-07T13:01:34.000
Cb
2
House Num
144
Onstname
W. 11TH ST.
Atddismissed
No
15069
Atdid: 15069 • Atd Number: ATD-4-6279 • Bblid: 808417
Atdid
15069
Atd Number
ATD-4-6279
Bblid
808417
Inspectionid
382049
Inspect Date
2024-08-09T00:00:00.000
Atdissuedate
2024-09-23T10:45:03.000
Cb
8
House Num
164-26
Onstname
GRAND CENTRAL PKWY.
Atddismissed
No
18145
Atdid: 18145 • Atd Number: ATD-5-1010 • Bblid: 1023863
Atdid
18145
Atd Number
ATD-5-1010
Bblid
1023863
Inspectionid
402830
Inspect Date
2025-07-02T00:00:00.000
Atdissuedate
2025-07-21T12:08:26.000
Cb
3
House Num
489
Onstname
RIDGEWOOD AVE.
Atddismissed
No
9232
Atdid: 9232 • Atd Number: ATD-3-3371 • Bblid: 469309
Atdid
9232
Atd Number
ATD-3-3371
Bblid
469309
Inspectionid
332938
Inspect Date
2021-01-14T00:00:00.000
Atdissuedate
2022-03-01T17:08:40.000
Cb
11
House Num
329
Onstname
BAY 14TH ST.
Atddismissed
No
13499
Atdid: 13499 • Atd Number: ATD-3-5561 • Bblid: 444929
Atdid
13499
Atd Number
ATD-3-5561
Bblid
444929
Inspectionid
364525
Inspect Date
2023-06-21T00:00:00.000
Atdissuedate
2023-09-28T10:16:15.000
Cb
10
House Num
528
Onstname
72ND ST.
Atddismissed
No
15030
Atdid: 15030 • Atd Number: ATD-3-6266 • Bblid: 535032
Atdid
15030
Atd Number
ATD-3-6266
Bblid
535032
Inspectionid
381657
Inspect Date
2024-08-16T00:00:00.000
Atdissuedate
2024-09-09T16:15:20.000
Cb
18
House Num
1167
Onstname
E. 84TH ST.
Atddismissed
No
17861
Atdid: 17861 • Atd Number: ATD-3-7043 • Bblid: 275490
Atdid
17861
Atd Number
ATD-3-7043
Bblid
275490
Inspectionid
399989
Inspect Date
2025-06-07T00:00:00.000
Atdissuedate
2025-06-11T15:53:28.000
Cb
6
House Num
26
Onstname
BERKELEY PLACE
Atddismissed
No
9919
Atdid: 9919 • Atd Number: ATD-4-4507 • Bblid: 654546
Atdid
9919
Atd Number
ATD-4-4507
Bblid
654546
Inspectionid
335276
Inspect Date
2022-04-15T00:00:00.000
Atdissuedate
2022-04-20T14:06:38.000
Cb
6
House Num
63-79
Onstname
CARLTON ST.
Atddismissed
No
11662
Atdid: 11662 • Atd Number: ATD-5-681 • Bblid: 938131
Atdid
11662
Atd Number
ATD-5-681
Bblid
938131
Inspectionid
351579
Inspect Date
2023-02-10T00:00:00.000
Atdissuedate
2023-02-15T14:36:19.000
Cb
1
House Num
312
Onstname
CRYSTAL AVE.
Atddismissed
No
14680
Atdid: 14680 • Atd Number: ATD-3-6094 • Bblid: 462984
Atdid
14680
Atd Number
ATD-3-6094
Bblid
462984
Inspectionid
378988
Inspect Date
2024-06-28T00:00:00.000
Atdissuedate
2024-07-02T12:51:35.000
Cb
11
House Num
1423
Onstname
83RD ST.
Atddismissed
No
16583
Atdid: 16583 • Atd Number: ATD-4-6508 • Bblid: 577267
Atdid
16583
Atd Number
ATD-4-6508
Bblid
577267
Inspectionid
387065
Inspect Date
2024-12-11T00:00:00.000
Atdissuedate
2024-12-20T12:43:09.000
Cb
1
House Num
33-53
Onstname
29TH ST.
Atddismissed
No
12313
Atdid: 12313 • Atd Number: ATD-2-1110 • Bblid: 153912
Atdid
12313
Atd Number
ATD-2-1110
Bblid
153912
Inspectionid
357364
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T12:21:17.000
Cb
5
House Num
1730
Onstname
HARRISON AVE.
Atddismissed
No
9139
Atdid: 9139 • Atd Number: ATD-3-3330 • Bblid: 386491
Atdid
9139
Atd Number
ATD-3-3330
Bblid
386491
Inspectionid
332690
Inspect Date
2019-06-24T00:00:00.000
Atdissuedate
2022-02-23T10:26:11.000
Cb
5
House Num
796
Onstname
NEW JERSEY AVE.
Atddismissed
No
10945
Atdid: 10945 • Atd Number: ATD-2-949 • Bblid: 219720
Atdid
10945
Atd Number
ATD-2-949
Bblid
219720
Inspectionid
344174
Inspect Date
2022-09-17T00:00:00.000
Atdissuedate
2022-09-20T09:53:16.000
Cb
12
House Num
859
Onstname
E. 232ND ST.
Atddismissed
No
14082
Atdid: 14082 • Atd Number: ATD-4-5875 • Bblid: 620554
Atdid
14082
Atd Number
ATD-4-5875
Bblid
620554
Inspectionid
372870
Inspect Date
2024-03-08T00:00:00.000
Atdissuedate
2024-03-08T11:39:49.000
Cb
4
House Num
88-09
Onstname
54TH AVE.
Atddismissed
No
9084
Atdid: 9084 • Atd Number: ATD-4-4133 • Bblid: 596088
Atdid
9084
Atd Number
ATD-4-4133
Bblid
596088
Inspectionid
332631
Inspect Date
2019-07-12T00:00:00.000
Atdissuedate
2022-02-22T09:15:07.000
Cb
3
House Num
69-15
Onstname
31ST AVE.
Atddismissed
No
NYC Data AI • Public-data exploration interface