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
17769
Atdid: 17769 • Atd Number: ATD-4-6996 • Bblid: 686658
Atdid
17769
Atd Number
ATD-4-6996
Bblid
686658
Inspectionid
398915
Inspect Date
2025-05-30T00:00:00.000
Atdissuedate
2025-06-02T08:49:56.000
Cb
7
House Num
145-60
Onstname
9TH AVE.
Atddismissed
No
18412
Atdid: 18412 • Atd Number: ATD-3-7261 • Bblid: 483108
Atdid
18412
Atd Number
ATD-3-7261
Bblid
483108
Inspectionid
404704
Inspect Date
2025-08-22T00:00:00.000
Atdissuedate
2025-08-25T10:26:25.000
Cb
14
House Num
1555
Onstname
E. 17TH ST.
Atddismissed
No
14731
Atdid: 14731 • Atd Number: ATD-3-6117 • Bblid: 559582
Atdid
14731
Atd Number
ATD-3-6117
Bblid
559582
Violationid
294188
Reinspectionid
36848
Inspect Date
2024-07-11T17:56:05.000
Atdissuedate
2024-07-11T17:56:05.000
Cb
15
House Num
61
Onstname
EXETER STREET
Atddismissed
No
12388
Atdid: 12388 • Atd Number: ATD-4-5254 • Bblid: 604340
Atdid
12388
Atd Number
ATD-4-5254
Bblid
604340
Inspectionid
357545
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:48:06.000
Cb
2
Onstname
QUEENS BOULEVARD
Atddismissed
No
9990
Atdid: 9990 • Atd Number: ATD-3-3666 • Bblid: 323041
Atdid
9990
Atd Number
ATD-3-3666
Bblid
323041
Inspectionid
335784
Inspect Date
2022-04-28T00:00:00.000
Atdissuedate
2022-04-28T15:21:02.000
Cb
2
House Num
294
Onstname
CLINTON AVE.
Atddismissed
No
10216
Atdid: 10216 • Atd Number: ATD-3-3796 • Bblid: 362665
Atdid
10216
Atd Number
ATD-3-3796
Bblid
362665
Inspectionid
337326
Inspect Date
2022-06-04T00:00:00.000
Atdissuedate
2022-06-06T11:31:50.000
Cb
4
House Num
126
Onstname
MOFFAT ST.
Atddismissed
No
9697
Atdid: 9697 • Atd Number: ATD-4-4381 • Bblid: 668903
Atdid
9697
Atd Number
ATD-4-4381
Bblid
668903
Inspectionid
334082
Inspect Date
2022-03-15T00:00:00.000
Atdissuedate
2022-03-23T15:12:30.000
Cb
5
House Num
17-18
Onstname
STEPHEN ST.
Atddismissed
No
18257
Atdid: 18257 • Atd Number: ATD-3-7208 • Bblid: 518958
Atdid
18257
Atd Number
ATD-3-7208
Bblid
518958
Inspectionid
403629
Inspect Date
2025-08-05T00:00:00.000
Atdissuedate
2025-08-05T12:01:16.000
Cb
15
House Num
1553
Onstname
E. 29TH ST.
Atddismissed
No
12870
Atdid: 12870 • Atd Number: ATD-3-5174 • Bblid: 332316
Atdid
12870
Atd Number
ATD-3-5174
Bblid
332316
Inspectionid
360101
Inspect Date
2023-05-25T00:00:00.000
Atdissuedate
2023-07-17T12:04:46.000
Cb
1
House Num
237
Onstname
HEWES ST.
Atddismissed
No
12695
Atdid: 12695 • Atd Number: ATD-5-730 • Bblid: 1009661
Atdid
12695
Atd Number
ATD-5-730
Bblid
1009661
Inspectionid
359106
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-29T15:13:16.000
Cb
3
House Num
386
Onstname
ARTHUR KILL RD.
Atddismissed
No
17524
Atdid: 17524 • Atd Number: ATD-3-6953 • Bblid: 292061
Atdid
17524
Atd Number
ATD-3-6953
Bblid
292061
Inspectionid
396046
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-05T08:27:56.000
Cb
8
House Num
597
Onstname
EASTERN PKWY.
Atddismissed
No
17215
Atdid: 17215 • Atd Number: ATD-4-6715 • Bblid: 709677
Atdid
17215
Atd Number
ATD-4-6715
Bblid
709677
Inspectionid
392914
Inspect Date
2025-03-31T00:00:00.000
Atdissuedate
2025-04-01T13:05:02.000
Cb
7
House Num
172-03
Onstname
35TH AVE.
Atddismissed
No
18550
Atdid: 18550 • Atd Number: ATD-4-7355 • Bblid: 711775
Atdid
18550
Atd Number
ATD-4-7355
Bblid
711775
Inspectionid
405531
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-09-08T15:48:02.000
Cb
7
House Num
41-07
Onstname
159TH ST.
Atddismissed
No
17210
Atdid: 17210 • Atd Number: ATD-2-1366 • Bblid: 208944
Atdid
17210
Atd Number
ATD-2-1366
Bblid
208944
Inspectionid
392903
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-04-01T12:43:19.000
Cb
11
House Num
2757
Onstname
MICKLE AVE.
Atddismissed
No
16695
Atdid: 16695 • Atd Number: ATD-4-6568 • Bblid: 745162
Atdid
16695
Atd Number
ATD-4-6568
Bblid
745162
Inspectionid
388668
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2025-01-10T13:29:10.000
Cb
8
House Num
75-42
Onstname
UTOPIA PKWY.
Atddismissed
No
8713
Atdid: 8713 • Atd Number: ATD-2-851 • Bblid: 149591
Atdid
8713
Atd Number
ATD-2-851
Bblid
149591
Inspectionid
330997
Inspect Date
2021-09-08T00:00:00.000
Atdissuedate
2021-12-22T14:11:30.000
Cb
2
House Num
1033
Onstname
KELLY ST.
Atddismissed
No
18104
Atdid: 18104 • Atd Number: ATD-4-7156 • Bblid: 783140
Atdid
18104
Atd Number
ATD-4-7156
Bblid
783140
Inspectionid
402514
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-07-16T15:45:23.000
Cb
9
House Num
96-08
Onstname
95TH AVE.
Atddismissed
No
14200
Atdid: 14200 • Atd Number: ATD-3-5860 • Bblid: 552067
Atdid
14200
Atd Number
ATD-3-5860
Bblid
552067
Inspectionid
373832
Inspect Date
2024-03-21T00:00:00.000
Atdissuedate
2024-03-21T08:54:08.000
Cb
18
House Num
1925
Onstname
E. 35TH ST.
Atddismissed
No
11690
Atdid: 11690 • Atd Number: ATD-4-5002 • Bblid: 679895
Atdid
11690
Atd Number
ATD-4-5002
Bblid
679895
Inspectionid
351842
Inspect Date
2023-01-13T00:00:00.000
Atdissuedate
2023-02-21T12:45:56.000
Cb
7
House Num
121-19
Onstname
8TH AVE.
Atddismissed
No
17673
Atdid: 17673 • Atd Number: ATD-3-6992 • Bblid: 282943
Atdid
17673
Atd Number
ATD-3-6992
Bblid
282943
Inspectionid
397601
Inspect Date
2025-05-16T00:00:00.000
Atdissuedate
2025-05-19T10:09:50.000
Cb
6
House Num
439
Onstname
8TH ST.
Atddismissed
No
12552
Atdid: 12552 • Atd Number: ATD-5-700 • Bblid: 922259
Atdid
12552
Atd Number
ATD-5-700
Bblid
922259
Inspectionid
358480
Inspect Date
2023-06-13T00:00:00.000
Atdissuedate
2023-06-13T11:55:11.000
Cb
1
House Num
184
Onstname
DANIEL LOW TER.
Atddismissed
No
13107
Atdid: 13107 • Atd Number: ATD-4-5484 • Bblid: 782229
Atdid
13107
Atd Number
ATD-4-5484
Bblid
782229
Inspectionid
361396
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T11:39:18.000
Cb
9
House Num
76-11
Onstname
97TH AVE.
Atddismissed
No
14690
Atdid: 14690 • Atd Number: ATD-3-6104 • Bblid: 462942
Atdid
14690
Atd Number
ATD-3-6104
Bblid
462942
Inspectionid
379000
Inspect Date
2024-07-02T00:00:00.000
Atdissuedate
2024-07-02T13:20:51.000
Cb
11
House Num
8224
Onstname
15TH AVE.
Atddismissed
No
11788
Atdid: 11788 • Atd Number: ATD-4-5048 • Bblid: 657945
Atdid
11788
Atd Number
ATD-4-5048
Bblid
657945
Inspectionid
352860
Inspect Date
2023-02-13T00:00:00.000
Atdissuedate
2023-03-13T12:43:34.000
Cb
6
House Num
68-39
Onstname
HARROW ST.
Atddismissed
No
11619
Atdid: 11619 • Atd Number: ATD-4-4974 • Bblid: 633726
Atdid
11619
Atd Number
ATD-4-4974
Bblid
633726
Inspectionid
350708
Inspect Date
2023-01-24T00:00:00.000
Atdissuedate
2023-01-24T11:42:46.000
Cb
5
House Num
66-15
Onstname
53RD AVE.
Atddismissed
No
12931
Atdid: 12931 • Atd Number: ATD-3-5218 • Bblid: 422453
Atdid
12931
Atd Number
ATD-3-5218
Bblid
422453
Inspectionid
360350
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T11:13:09.000
Cb
12
House Num
1558
Onstname
44TH ST.
Atddismissed
No
13066
Atdid: 13066 • Atd Number: ATD-3-5305 • Bblid: 267349
Atdid
13066
Atd Number
ATD-3-5305
Bblid
267349
Inspectionid
361088
Inspect Date
2023-07-26T00:00:00.000
Atdissuedate
2023-07-31T10:47:40.000
Cb
7
House Num
4915
Onstname
6TH AVE.
Atddismissed
No
12841
Atdid: 12841 • Atd Number: ATD-4-5438 • Bblid: 645315
Atdid
12841
Atd Number
ATD-4-5438
Bblid
645315
Inspectionid
359941
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-07-13T12:13:51.000
Cb
4
House Num
86-25
Onstname
57TH RD.
Atddismissed
No
9353
Atdid: 9353 • Atd Number: ATD-3-3450 • Bblid: 505715
Atdid
9353
Atd Number
ATD-3-3450
Bblid
505715
Inspectionid
333076
Inspect Date
2021-05-04T00:00:00.000
Atdissuedate
2022-03-02T17:17:22.000
Cb
15
House Num
2027
Onstname
COYLE ST.
Atddismissed
No
11974
Atdid: 11974 • Atd Number: ATD-3-4900 • Bblid: 547739
Atdid
11974
Atd Number
ATD-3-4900
Bblid
547739
Inspectionid
354424
Inspect Date
2023-03-16T00:00:00.000
Atdissuedate
2023-04-05T10:35:09.000
Cb
18
House Num
1651
Onstname
E. 56TH ST.
Atddismissed
Yes
Atddismissedon
2023-06-13T07:50:27.000
12124
Atdid: 12124 • Atd Number: ATD-4-5161 • Bblid: 860874
Atdid
12124
Atd Number
ATD-4-5161
Bblid
860874
Inspectionid
356436
Inspect Date
2023-03-20T00:00:00.000
Atdissuedate
2023-05-01T11:31:10.000
Cb
12
House Num
111-68
Onstname
145TH ST.
Atddismissed
No
8965
Atdid: 8965 • Atd Number: ATD-4-4064 • Bblid: 671901
Atdid
8965
Atd Number
ATD-4-4064
Bblid
671901
Inspectionid
332266
Inspect Date
2019-10-12T00:00:00.000
Atdissuedate
2022-02-04T15:12:11.000
Cb
5
House Num
69-25
Onstname
CENTRAL AVE.
Atddismissed
No
13167
Atdid: 13167 • Atd Number: ATD-5-792 • Bblid: 1018166
Atdid
13167
Atd Number
ATD-5-792
Bblid
1018166
Inspectionid
361710
Inspect Date
2023-08-02T00:00:00.000
Atdissuedate
2023-08-07T14:10:56.000
Cb
3
House Num
16
Onstname
RIDGECREST AVE.
Atddismissed
No
12875
Atdid: 12875 • Atd Number: ATD-2-1192 • Bblid: 202427
Atdid
12875
Atd Number
ATD-2-1192
Bblid
202427
Inspectionid
360145
Inspect Date
2023-07-12T00:00:00.000
Atdissuedate
2023-07-17T13:01:00.000
Cb
11
House Num
2034
Onstname
MATTHEWS AVE.
Atddismissed
No
12252
Atdid: 12252 • Atd Number: ATD-2-1069 • Bblid: 153384
Atdid
12252
Atd Number
ATD-2-1069
Bblid
153384
Inspectionid
357213
Inspect Date
2023-05-17T00:00:00.000
Atdissuedate
2023-05-17T11:44:48.000
Cb
4
House Num
1339
Onstname
JEROME AVE.
Atddismissed
No
11870
Atdid: 11870 • Atd Number: ATD-3-4843 • Bblid: 420600
Atdid
11870
Atd Number
ATD-3-4843
Bblid
420600
Inspectionid
353632
Inspect Date
2023-03-18T00:00:00.000
Atdissuedate
2023-03-22T12:37:21.000
Cb
12
House Num
597
Onstname
E. 2ND ST.
Atddismissed
No
17698
Atdid: 17698 • Atd Number: ATD-4-6954 • Bblid: 755200
Atdid
17698
Atd Number
ATD-4-6954
Bblid
755200
Inspectionid
398058
Inspect Date
2025-05-20T00:00:00.000
Atdissuedate
2025-05-21T12:53:10.000
Cb
11
House Num
226-05
Onstname
HORACE HARDING EXPY.
Atddismissed
No
13998
Atdid: 13998 • Atd Number: ATD-4-5828 • Bblid: 769067
Atdid
13998
Atd Number
ATD-4-5828
Bblid
769067
Inspectionid
372036
Inspect Date
2024-02-22T00:00:00.000
Atdissuedate
2024-02-22T10:25:53.000
Cb
13
House Num
76-20
Onstname
269TH ST.
Atddismissed
No
11311
Atdid: 11311 • Atd Number: ATD-3-4597 • Bblid: 298997
Atdid
11311
Atd Number
ATD-3-4597
Bblid
298997
Inspectionid
347424
Inspect Date
2022-10-29T00:00:00.000
Atdissuedate
2022-11-01T15:12:21.000
Cb
9
House Num
771
Onstname
MONTGOMERY ST.
Atddismissed
No
11290
Atdid: 11290 • Atd Number: ATD-4-4871 • Bblid: 798965
Atdid
11290
Atd Number
ATD-4-4871
Bblid
798965
Inspectionid
347107
Inspect Date
2022-10-18T00:00:00.000
Atdissuedate
2022-10-27T11:50:58.000
Cb
10
House Num
104-37
Onstname
107TH ST.
Atddismissed
No
12298
Atdid: 12298 • Atd Number: ATD-2-1095 • Bblid: 153722
Atdid
12298
Atd Number
ATD-2-1095
Bblid
153722
Inspectionid
357347
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T12:01:29.000
Cb
4
House Num
1361
Onstname
CROMWELL AVENUE
Atddismissed
No
17540
Atdid: 17540 • Atd Number: ATD-4-6852 • Bblid: 871685
Atdid
17540
Atd Number
ATD-4-6852
Bblid
871685
Inspectionid
396292
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-06T09:43:42.000
Cb
12
House Num
117-52
Onstname
MARSDEN ST.
Atddismissed
No
14960
Atdid: 14960 • Atd Number: ATD-4-6243 • Bblid: 661613
Atdid
14960
Atd Number
ATD-4-6243
Bblid
661613
Violationid
279302
Reinspectionid
33518
Inspect Date
2024-08-26T11:24:46.000
Atdissuedate
2024-08-26T11:24:46.000
Cb
6
House Num
111-31
Onstname
77 AVENUE
Atddismissed
No
10501
Atdid: 10501 • Atd Number: ATD-3-3970 • Bblid: 282639
Atdid
10501
Atd Number
ATD-3-3970
Bblid
282639
Violationid
47066
Inspectionid
339979
Inspect Date
2022-07-18T11:59:25.000
Atdissuedate
2022-07-18T11:59:25.000
Cb
6
House Num
581
Onstname
THIRD STREET
Atddismissed
No
14074
Atdid: 14074 • Atd Number: ATD-3-5768 • Bblid: 400855
Atdid
14074
Atd Number
ATD-3-5768
Bblid
400855
Violationid
287224
Reinspectionid
35908
Inspect Date
2024-03-07T10:05:18.000
Atdissuedate
2024-03-07T10:05:18.000
Cb
17
House Num
880
Onstname
BROOKLYN AVENUE
Atddismissed
No
10167
Atdid: 10167 • Atd Number: ATD-2-925 • Bblid: 219423
Atdid
10167
Atd Number
ATD-2-925
Bblid
219423
Inspectionid
336907
Inspect Date
2022-05-23T00:00:00.000
Atdissuedate
2022-05-24T11:16:08.000
Cb
12
House Num
876
Onstname
E. 223RD ST.
Atddismissed
No
14840
Atdid: 14840 • Atd Number: ATD-5-871 • Bblid: 1027069
Atdid
14840
Atd Number
ATD-5-871
Bblid
1027069
Violationid
292640
Reinspectionid
36636
Inspect Date
2024-08-01T12:33:55.000
Atdissuedate
2024-08-01T12:33:55.000
Cb
3
House Num
521
Onstname
ANNADALE ROAD
Atddismissed
No
12296
Atdid: 12296 • Atd Number: ATD-2-1093 • Bblid: 153669
Atdid
12296
Atd Number
ATD-2-1093
Bblid
153669
Inspectionid
357345
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T11:57:38.000
Cb
4
House Num
1290
Onstname
CROMWELL AVENUE
Atddismissed
No
13773
Atdid: 13773 • Atd Number: ATD-3-5676 • Bblid: 362291
Atdid
13773
Atd Number
ATD-3-5676
Bblid
362291
Inspectionid
369350
Inspect Date
2023-12-08T00:00:00.000
Atdissuedate
2023-12-12T12:37:45.000
Cb
4
House Num
297A
Onstname
COOPER STREET
Atddismissed
No
18557
Atdid: 18557 • Atd Number: ATD-2-1466 • Bblid: 202066
Atdid
18557
Atd Number
ATD-2-1466
Bblid
202066
Inspectionid
405589
Inspect Date
2025-08-29T00:00:00.000
Atdissuedate
2025-09-09T13:14:18.000
Cb
11
House Num
1915
Onstname
YATES AVE.
Atddismissed
No
NYC Data AI • Public-data exploration interface