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
16981
Atdid: 16981 • Atd Number: ATD-5-937 • Bblid: 965393
Atdid
16981
Atd Number
ATD-5-937
Bblid
965393
Inspectionid
391700
Inspect Date
2025-03-15T00:00:00.000
Atdissuedate
2025-03-20T13:01:20.000
Cb
1
House Num
23
Onstname
WOODCREST RD.
Atddismissed
No
13748
Atdid: 13748 • Atd Number: ATD-4-5661 • Bblid: 901844
Atdid
13748
Atd Number
ATD-4-5661
Bblid
901844
Inspectionid
369120
Inspect Date
2023-12-06T00:00:00.000
Atdissuedate
2023-12-07T15:05:57.000
Cb
10
House Num
94-07
Onstname
157TH AVE.
Atddismissed
No
10097
Atdid: 10097 • Atd Number: ATD-3-3716 • Bblid: 472327
Atdid
10097
Atd Number
ATD-3-3716
Bblid
472327
Inspectionid
336459
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-16T11:03:09.000
Cb
11
House Num
2354
Onstname
62ND ST.
Atddismissed
No
13286
Atdid: 13286 • Atd Number: ATD-3-5446 • Bblid: 483257
Atdid
13286
Atd Number
ATD-3-5446
Bblid
483257
Inspectionid
362360
Inspect Date
2023-08-08T00:00:00.000
Atdissuedate
2023-08-22T11:37:20.000
Cb
14
House Num
1522
Onstname
E. 23RD ST.
Atddismissed
No
12111
Atdid: 12111 • Atd Number: ATD-3-4965 • Bblid: 328380
Atdid
12111
Atd Number
ATD-3-4965
Bblid
328380
Inspectionid
356386
Inspect Date
2023-04-27T00:00:00.000
Atdissuedate
2023-04-27T15:25:01.000
Cb
2
House Num
199
Onstname
ASHLAND PL.
Atddismissed
No
13047
Atdid: 13047 • Atd Number: ATD-3-5291 • Bblid: 422492
Atdid
13047
Atd Number
ATD-3-5291
Bblid
422492
Inspectionid
361041
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T15:24:50.000
Cb
12
House Num
1650
Onstname
45TH ST.
Atddismissed
No
12321
Atdid: 12321 • Atd Number: ATD-2-1118 • Bblid: 163768
Atdid
12321
Atd Number
ATD-2-1118
Bblid
163768
Inspectionid
357372
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T12:35:28.000
Cb
5
House Num
1930
Onstname
SEDGWICK AVENUE
Atddismissed
No
14679
Atdid: 14679 • Atd Number: ATD-3-6093 • Bblid: 462990
Atdid
14679
Atd Number
ATD-3-6093
Bblid
462990
Inspectionid
378987
Inspect Date
2024-06-24T00:00:00.000
Atdissuedate
2024-07-02T12:50:59.000
Cb
11
House Num
1415
Onstname
83RD ST.
Atddismissed
No
11954
Atdid: 11954 • Atd Number: ATD-2-1005 • Bblid: 226983
Atdid
11954
Atd Number
ATD-2-1005
Bblid
226983
Inspectionid
354290
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-31T09:27:23.000
Cb
12
House Num
4340
Onstname
ELY AVE.
Atddismissed
No
17297
Atdid: 17297 • Atd Number: ATD-3-6840 • Bblid: 393767
Atdid
17297
Atd Number
ATD-3-6840
Bblid
393767
Inspectionid
394051
Inspect Date
2025-03-20T00:00:00.000
Atdissuedate
2025-04-10T14:24:21.000
Cb
17
House Num
127
Onstname
E. 57TH ST.
Atddismissed
No
17483
Atdid: 17483 • Atd Number: ATD-4-6829 • Bblid: 768540
Atdid
17483
Atd Number
ATD-4-6829
Bblid
768540
Inspectionid
395664
Inspect Date
2025-04-30T00:00:00.000
Atdissuedate
2025-04-30T14:30:51.000
Cb
11
House Num
60-05
Onstname
264TH ST.
Atddismissed
No
16201
Atdid: 16201 • Atd Number: ATD-4-6359 • Bblid: 655104
Atdid
16201
Atd Number
ATD-4-6359
Bblid
655104
Inspectionid
383959
Inspect Date
2024-09-25T00:00:00.000
Atdissuedate
2024-10-09T11:53:32.000
Cb
6
House Num
85-25
Onstname
67TH AVE.
Atddismissed
No
18601
Atdid: 18601 • Atd Number: ATD-4-7373 • Bblid: 729471
Atdid
18601
Atd Number
ATD-4-7373
Bblid
729471
Inspectionid
405900
Inspect Date
2025-09-06T00:00:00.000
Atdissuedate
2025-09-15T12:59:52.000
Cb
11
House Num
219-19
Onstname
39TH AVE.
Atddismissed
No
13638
Atdid: 13638 • Atd Number: ATD-3-5620 • Bblid: 359507
Atdid
13638
Atd Number
ATD-3-5620
Bblid
359507
Inspectionid
366095
Inspect Date
2023-10-11T00:00:00.000
Atdissuedate
2023-10-30T09:32:18.000
Cb
4
House Num
1177
Onstname
JEFFERSON AVE.
Atddismissed
No
18365
Atdid: 18365 • Atd Number: ATD-5-1021 • Bblid: 1014282
Atdid
18365
Atd Number
ATD-5-1021
Bblid
1014282
Inspectionid
404450
Inspect Date
2025-08-12T00:00:00.000
Atdissuedate
2025-08-18T14:18:48.000
Cb
3
House Num
74
Onstname
GREENCROFT AVE.
Atddismissed
No
10203
Atdid: 10203 • Atd Number: ATD-4-4627 • Bblid: 656518
Atdid
10203
Atd Number
ATD-4-4627
Bblid
656518
Inspectionid
337185
Inspect Date
2022-05-17T00:00:00.000
Atdissuedate
2022-06-02T13:22:38.000
Cb
6
House Num
68-38
Onstname
SELFRIDGE ST.
Atddismissed
No
11153
Atdid: 11153 • Atd Number: ATD-3-4478 • Bblid: 546712
Atdid
11153
Atd Number
ATD-3-4478
Bblid
546712
Inspectionid
345971
Inspect Date
2022-10-13T00:00:00.000
Atdissuedate
2022-10-14T13:56:41.000
Cb
18
House Num
7324
Onstname
AVENUE M.
Atddismissed
No
14556
Atdid: 14556 • Atd Number: ATD-3-6015 • Bblid: 480018
Atdid
14556
Atd Number
ATD-3-6015
Bblid
480018
Inspectionid
378086
Inspect Date
2024-05-22T00:00:00.000
Atdissuedate
2024-06-03T14:50:18.000
Cb
14
House Num
874
Onstname
E. 14TH ST.
Atddismissed
No
9592
Atdid: 9592 • Atd Number: ATD-3-3568 • Bblid: 541797
Atdid
9592
Atd Number
ATD-3-3568
Bblid
541797
Inspectionid
333731
Inspect Date
2022-03-14T00:00:00.000
Atdissuedate
2022-03-14T15:35:32.000
Cb
18
House Num
1146
Onstname
E. 103RD ST.
Atddismissed
No
12508
Atdid: 12508 • Atd Number: ATD-4-5334 • Bblid: 795953
Atdid
12508
Atd Number
ATD-4-5334
Bblid
795953
Inspectionid
358054
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T16:30:14.000
Cb
9
House Num
118-22
Onstname
ATLANTIC AVE.
Atddismissed
No
12120
Atdid: 12120 • Atd Number: ATD-3-4974 • Bblid: 504833
Atdid
12120
Atd Number
ATD-3-4974
Bblid
504833
Inspectionid
356424
Inspect Date
2021-06-25T00:00:00.000
Atdissuedate
2023-04-28T16:36:45.000
Cb
15
House Num
2075
Onstname
E. 26TH ST.
Atddismissed
No
18174
Atdid: 18174 • Atd Number: ATD-4-7176 • Bblid: 814419
Atdid
18174
Atd Number
ATD-4-7176
Bblid
814419
Inspectionid
402971
Inspect Date
2025-07-18T00:00:00.000
Atdissuedate
2025-07-23T12:46:02.000
Cb
12
House Num
107-28
Onstname
154TH ST.
Atddismissed
No
12157
Atdid: 12157 • Atd Number: ATD-3-4988 • Bblid: 258031
Atdid
12157
Atd Number
ATD-3-4988
Bblid
258031
Inspectionid
356697
Inspect Date
2023-05-05T00:00:00.000
Atdissuedate
2023-05-05T14:06:16.000
Cb
2
House Num
171
Onstname
WYCKOFF ST.
Atddismissed
No
16712
Atdid: 16712 • Atd Number: ATD-1-356 • Bblid: 116812
Atdid
16712
Atd Number
ATD-1-356
Bblid
116812
Inspectionid
388815
Inspect Date
2025-01-17T00:00:00.000
Atdissuedate
2025-01-21T11:27:39.000
Cb
10
House Num
56
Onstname
W. 120TH ST.
Atddismissed
No
14079
Atdid: 14079 • Atd Number: ATD-4-5872 • Bblid: 620560
Atdid
14079
Atd Number
ATD-4-5872
Bblid
620560
Inspectionid
372867
Inspect Date
2024-03-08T00:00:00.000
Atdissuedate
2024-03-08T11:32:32.000
Cb
4
House Num
88-03
Onstname
54TH AVE.
Atddismissed
No
16211
Atdid: 16211 • Atd Number: ATD-3-6345 • Bblid: 544124
Atdid
16211
Atd Number
ATD-3-6345
Bblid
544124
Inspectionid
384085
Inspect Date
2024-10-11T00:00:00.000
Atdissuedate
2024-10-15T09:19:50.000
Cb
18
House Num
1325
Onstname
E. 103RD ST.
Atddismissed
No
16227
Atdid: 16227 • Atd Number: ATD-3-6348 • Bblid: 257189
Atdid
16227
Atd Number
ATD-3-6348
Bblid
257189
Inspectionid
384145
Inspect Date
2024-10-08T00:00:00.000
Atdissuedate
2024-10-15T11:56:28.000
Cb
6
House Num
597
Onstname
HENRY ST.
Atddismissed
Yes
Atddismissedon
2025-05-16T09:32:35.000
17572
Atdid: 17572 • Atd Number: ATD-4-6866 • Bblid: 751860
Atdid
17572
Atd Number
ATD-4-6866
Bblid
751860
Inspectionid
396659
Inspect Date
2025-05-07T00:00:00.000
Atdissuedate
2025-05-09T13:47:15.000
Cb
11
House Num
217-04
Onstname
47TH RD.
Atddismissed
Yes
Atddismissedon
2025-05-12T12:08:55.000
11382
Atdid: 11382 • Atd Number: ATD-4-4884 • Bblid: 596210
Atdid
11382
Atd Number
ATD-4-4884
Bblid
596210
Inspectionid
348045
Inspect Date
2022-11-09T00:00:00.000
Atdissuedate
2022-11-10T15:14:07.000
Cb
3
House Num
70-02
Onstname
30TH AVE.
Atddismissed
No
10044
Atdid: 10044 • Atd Number: ATD-4-4585 • Bblid: 654882
Atdid
10044
Atd Number
ATD-4-4585
Bblid
654882
Inspectionid
336094
Inspect Date
2022-04-28T00:00:00.000
Atdissuedate
2022-05-03T13:16:48.000
Cb
6
House Num
62-19
Onstname
BOELSEN CRES
Atddismissed
No
13911
Atdid: 13911 • Atd Number: ATD-3-5721 • Bblid: 410813
Atdid
13911
Atd Number
ATD-3-5721
Bblid
410813
Inspectionid
371209
Inspect Date
2024-01-30T00:00:00.000
Atdissuedate
2024-02-01T11:24:14.000
Cb
17
House Num
2515
Onstname
BEVERLEY RD.
Atddismissed
No
14461
Atdid: 14461 • Atd Number: ATD-4-6039 • Bblid: 860904
Atdid
14461
Atd Number
ATD-4-6039
Bblid
860904
Inspectionid
377271
Inspect Date
2024-03-12T00:00:00.000
Atdissuedate
2024-05-13T11:32:46.000
Cb
12
House Num
111-65
Onstname
145TH ST.
Atddismissed
No
11314
Atdid: 11314 • Atd Number: ATD-3-4600 • Bblid: 298977
Atdid
11314
Atd Number
ATD-3-4600
Bblid
298977
Inspectionid
347433
Inspect Date
2022-10-29T00:00:00.000
Atdissuedate
2022-11-01T15:31:25.000
Cb
9
House Num
799
Onstname
MONTGOMERY ST.
Atddismissed
No
14975
Atdid: 14975 • Atd Number: ATD-4-6254 • Bblid: 577008
Atdid
14975
Atd Number
ATD-4-6254
Bblid
577008
Inspectionid
381180
Inspect Date
2024-08-13T00:00:00.000
Atdissuedate
2024-08-28T08:19:26.000
Cb
1
House Num
31-67
Onstname
30TH ST.
Atddismissed
No
14446
Atdid: 14446 • Atd Number: ATD-4-6028 • Bblid: 585302
Atdid
14446
Atd Number
ATD-4-6028
Bblid
585302
Inspectionid
377181
Inspect Date
2024-03-21T00:00:00.000
Atdissuedate
2024-05-09T14:44:45.000
Cb
1
House Num
22-48
Onstname
43RD ST.
Atddismissed
No
11513
Atdid: 11513 • Atd Number: ATD-4-4907 • Bblid: 644994
Atdid
11513
Atd Number
ATD-4-4907
Bblid
644994
Inspectionid
349336
Inspect Date
2022-12-08T00:00:00.000
Atdissuedate
2022-12-16T08:10:48.000
Cb
4
House Num
86-13
Onstname
55TH RD.
Atddismissed
No
12530
Atdid: 12530 • Atd Number: ATD-5-691 • Bblid: 995284
Atdid
12530
Atd Number
ATD-5-691
Bblid
995284
Inspectionid
358354
Inspect Date
2023-05-18T00:00:00.000
Atdissuedate
2023-06-12T10:37:21.000
Cb
2
House Num
131
Onstname
BANCROFT AVE.
Atddismissed
No
14045
Atdid: 14045 • Atd Number: ATD-1-308 • Bblid: 136712
Atdid
14045
Atd Number
ATD-1-308
Bblid
136712
Inspectionid
372624
Inspect Date
2024-03-08T00:00:00.000
Atdissuedate
2024-03-01T13:25:25.000
Cb
8
House Num
69
Onstname
ADRIAN AVE.
Atddismissed
No
3632
Atdid: 3632 • Atd Number: ATD-4-346 • Bblid: 758058
Atdid
3632
Atd Number
ATD-4-346
Bblid
758058
Violationid
120300
Atdissuedate
2020-08-18T00:00:00.000
Cb
11
House Num
7918
Onstname
215 STREET
Atddismissed
Yes
Atddismissedon
2024-05-31T10:27:11.000
10234
Atdid: 10234 • Atd Number: ATD-3-3813 • Bblid: 332754
Atdid
10234
Atd Number
ATD-3-3813
Bblid
332754
Inspectionid
337365
Inspect Date
2022-06-03T00:00:00.000
Atdissuedate
2022-06-06T12:46:08.000
Cb
1
House Num
82
Onstname
PENN ST.
Atddismissed
No
5068
Atdid: 5068 • Atd Number: ATD-4-1587 • Bblid: 583185
Atdid
5068
Atd Number
ATD-4-1587
Bblid
583185
Violationid
212215
Atdissuedate
2020-05-05T00:00:00.000
Cb
1
House Num
31-49
Onstname
47 STREET
Atddismissed
No
9699
Atdid: 9699 • Atd Number: ATD-4-4383 • Bblid: 668907
Atdid
9699
Atd Number
ATD-4-4383
Bblid
668907
Inspectionid
334085
Inspect Date
2022-03-15T00:00:00.000
Atdissuedate
2022-03-23T15:18:51.000
Cb
5
House Num
17-22
Onstname
STEPHEN ST.
Atddismissed
No
11701
Atdid: 11701 • Atd Number: ATD-3-4755 • Bblid: 433784
Atdid
11701
Atd Number
ATD-3-4755
Bblid
433784
Inspectionid
351917
Inspect Date
2023-02-15T00:00:00.000
Atdissuedate
2023-02-24T10:22:54.000
Cb
12
House Num
1135
Onstname
51ST ST.
Atddismissed
No
11508
Atdid: 11508 • Atd Number: ATD-2-961 • Bblid: 204606
Atdid
11508
Atd Number
ATD-2-961
Bblid
204606
Inspectionid
349273
Inspect Date
2022-10-26T00:00:00.000
Atdissuedate
2022-12-14T12:17:12.000
Cb
11
House Num
2344
Onstname
TIEMANN AVE.
Atddismissed
No
9344
Atdid: 9344 • Atd Number: ATD-3-3441 • Bblid: 486437
Atdid
9344
Atd Number
ATD-3-3441
Bblid
486437
Inspectionid
333067
Inspect Date
2021-03-20T00:00:00.000
Atdissuedate
2022-03-02T17:01:58.000
Cb
15
House Num
1936
Onstname
STUART ST.
Atddismissed
No
14766
Atdid: 14766 • Atd Number: ATD-4-6161 • Bblid: 567969
Atdid
14766
Atd Number
ATD-4-6161
Bblid
567969
Inspectionid
379529
Inspect Date
2024-07-16T00:00:00.000
Atdissuedate
2024-07-18T11:40:49.000
Cb
2
House Num
45-42
Onstname
11TH ST.
Atddismissed
No
10524
Atdid: 10524 • Atd Number: ATD-4-4747 • Bblid: 669300
Atdid
10524
Atd Number
ATD-4-4747
Bblid
669300
Inspectionid
340127
Inspect Date
2019-06-27T00:00:00.000
Atdissuedate
2022-07-20T10:39:49.000
Cb
5
House Num
72-56
Onstname
61ST ST.
Atddismissed
No
13154
Atdid: 13154 • Atd Number: ATD-3-5354 • Bblid: 294511
Atdid
13154
Atd Number
ATD-3-5354
Bblid
294511
Inspectionid
361586
Inspect Date
2023-07-14T00:00:00.000
Atdissuedate
2023-08-07T09:42:56.000
Cb
9
House Num
199
Onstname
LEFFERTS AVE.
Atddismissed
No
8917
Atdid: 8917 • Atd Number: ATD-4-4039 • Bblid: 753663
Atdid
8917
Atd Number
ATD-4-4039
Bblid
753663
Inspectionid
332144
Inspect Date
2019-04-05T00:00:00.000
Atdissuedate
2022-01-31T08:50:37.000
Cb
11
House Num
56-28
Onstname
FRANCIS LEWIS BLVD.
Atddismissed
No
14153
Atdid: 14153 • Atd Number: ATD-3-5815 • Bblid: 481920
Atdid
14153
Atd Number
ATD-3-5815
Bblid
481920
Inspectionid
373502
Inspect Date
2024-03-18T00:00:00.000
Atdissuedate
2024-03-18T16:39:20.000
Cb
14
House Num
1383
Onstname
E. 16TH ST.
Atddismissed
No
NYC Data AI • Public-data exploration interface