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
17907
Atdid: 17907 • Atd Number: ATD-2-1414 • Bblid: 231282
Atdid
17907
Atd Number
ATD-2-1414
Bblid
231282
Inspectionid
400543
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-17T10:29:23.000
Cb
10
House Num
3000
Onstname
LASALLE AVE.
Atddismissed
Yes
Atddismissedon
2025-08-04T11:52:45.000
11192
Atdid: 11192 • Atd Number: ATD-3-4510 • Bblid: 480338
Atdid
11192
Atd Number
ATD-3-4510
Bblid
480338
Inspectionid
346296
Inspect Date
2022-09-27T00:00:00.000
Atdissuedate
2022-10-17T15:20:01.000
Cb
14
House Num
947
Onstname
E. 12TH ST.
Atddismissed
No
11241
Atdid: 11241 • Atd Number: ATD-3-4547 • Bblid: 302619
Atdid
11241
Atd Number
ATD-3-4547
Bblid
302619
Inspectionid
346809
Inspect Date
2022-10-20T00:00:00.000
Atdissuedate
2022-10-24T10:42:21.000
Cb
16
House Num
644
Onstname
DECATUR ST.
Atddismissed
No
12873
Atdid: 12873 • Atd Number: ATD-4-5445 • Bblid: 837512
Atdid
12873
Atd Number
ATD-4-5445
Bblid
837512
Inspectionid
360141
Inspect Date
2023-07-05T00:00:00.000
Atdissuedate
2023-07-17T12:58:46.000
Cb
12
House Num
205-09
Onstname
114TH DR.
Atddismissed
No
14271
Atdid: 14271 • Atd Number: ATD-4-5944 • Bblid: 823215
Atdid
14271
Atd Number
ATD-4-5944
Bblid
823215
Inspectionid
375210
Inspect Date
2024-04-06T00:00:00.000
Atdissuedate
2024-04-11T14:16:56.000
Cb
12
House Num
89-32
Onstname
202ND ST.
Atddismissed
No
13011
Atdid: 13011 • Atd Number: ATD-4-5473 • Bblid: 897567
Atdid
13011
Atd Number
ATD-4-5473
Bblid
897567
Violationid
255323
Inspectionid
360905
Inspect Date
2023-07-28T09:32:19.000
Atdissuedate
2023-07-28T09:32:19.000
Cb
13
House Num
259-58
Onstname
148 AVENUE
Atddismissed
No
16490
Atdid: 16490 • Atd Number: ATD-1-335 • Bblid: 96162
Atdid
16490
Atd Number
ATD-1-335
Bblid
96162
Inspectionid
385822
Inspect Date
2024-12-04T00:00:00.000
Atdissuedate
2024-12-06T14:52:08.000
Cb
8
House Num
209
Onstname
E. 62ND ST.
Atddismissed
No
16257
Atdid: 16257 • Atd Number: ATD-3-6355 • Bblid: 259212
Atdid
16257
Atd Number
ATD-3-6355
Bblid
259212
Inspectionid
384217
Inspect Date
2024-09-24T00:00:00.000
Atdissuedate
2024-10-17T16:51:12.000
Cb
6
House Num
56
Onstname
DOUGLASS ST.
Atddismissed
No
17420
Atdid: 17420 • Atd Number: ATD-4-6796 • Bblid: 894038
Atdid
17420
Atd Number
ATD-4-6796
Bblid
894038
Inspectionid
395149
Inspect Date
2025-04-09T00:00:00.000
Atdissuedate
2025-04-23T08:39:02.000
Cb
13
House Num
142-09
Onstname
230TH PL.
Atddismissed
No
14443
Atdid: 14443 • Atd Number: ATD-4-6025 • Bblid: 608284
Atdid
14443
Atd Number
ATD-4-6025
Bblid
608284
Inspectionid
377159
Inspect Date
2024-04-26T00:00:00.000
Atdissuedate
2024-05-09T14:15:09.000
Cb
3
House Num
33-43
Onstname
88TH ST.
Atddismissed
No
11234
Atdid: 11234 • Atd Number: ATD-3-4540 • Bblid: 302669
Atdid
11234
Atd Number
ATD-3-4540
Bblid
302669
Inspectionid
346784
Inspect Date
2022-10-19T00:00:00.000
Atdissuedate
2022-10-24T10:32:03.000
Cb
16
House Num
694
Onstname
DECATUR ST.
Atddismissed
No
13870
Atdid: 13870 • Atd Number: ATD-4-5743 • Bblid: 809955
Atdid
13870
Atd Number
ATD-4-5743
Bblid
809955
Inspectionid
370741
Inspect Date
2023-09-13T00:00:00.000
Atdissuedate
2024-01-16T11:30:37.000
Cb
12
House Num
180-05
Onstname
90TH AVE.
Atddismissed
No
10991
Atdid: 10991 • Atd Number: ATD-3-4344 • Bblid: 318210
Atdid
10991
Atd Number
ATD-3-4344
Bblid
318210
Inspectionid
344468
Inspect Date
2022-09-17T00:00:00.000
Atdissuedate
2022-09-23T16:28:52.000
Cb
3
House Num
486
Onstname
JEFFERSON AVE.
Atddismissed
No
8973
Atdid: 8973 • Atd Number: ATD-4-4072 • Bblid: 898804
Atdid
8973
Atd Number
ATD-4-4072
Bblid
898804
Inspectionid
332285
Inspect Date
2019-06-25T00:00:00.000
Atdissuedate
2022-02-07T11:35:45.000
Cb
13
House Num
148-06
Onstname
HUXLEY ST.
Atddismissed
No
17058
Atdid: 17058 • Atd Number: ATD-3-6717 • Bblid: 276181
Atdid
17058
Atd Number
ATD-3-6717
Bblid
276181
Inspectionid
392388
Inspect Date
2022-08-26T00:00:00.000
Atdissuedate
2025-03-27T10:49:52.000
Cb
6
House Num
715
Onstname
PRESIDENT ST.
Atddismissed
No
12071
Atdid: 12071 • Atd Number: ATD-3-4946 • Bblid: 250886
Atdid
12071
Atd Number
ATD-3-4946
Bblid
250886
Inspectionid
356085
Inspect Date
2023-04-20T00:00:00.000
Atdissuedate
2023-04-20T12:35:59.000
Cb
2
House Num
553
Onstname
PACIFIC ST.
Atddismissed
No
12117
Atdid: 12117 • Atd Number: ATD-3-4971 • Bblid: 456986
Atdid
12117
Atd Number
ATD-3-4971
Bblid
456986
Inspectionid
356421
Inspect Date
2022-06-07T00:00:00.000
Atdissuedate
2023-04-28T16:08:16.000
Cb
10
House Num
1330
Onstname
72ND ST.
Atddismissed
No
9972
Atdid: 9972 • Atd Number: ATD-3-3659 • Bblid: 255949
Atdid
9972
Atd Number
ATD-3-3659
Bblid
255949
Inspectionid
335519
Inspect Date
2022-04-21T00:00:00.000
Atdissuedate
2022-04-25T12:38:06.000
Cb
6
House Num
149
Onstname
UNION ST.
Atddismissed
No
18354
Atdid: 18354 • Atd Number: ATD-3-7239 • Bblid: 307029
Atdid
18354
Atd Number
ATD-3-7239
Bblid
307029
Inspectionid
404421
Inspect Date
2025-08-12T00:00:00.000
Atdissuedate
2025-08-18T13:36:43.000
Cb
3
House Num
275
Onstname
VAN BUREN ST.
Atddismissed
No
12248
Atdid: 12248 • Atd Number: ATD-2-1065 • Bblid: 153364
Atdid
12248
Atd Number
ATD-2-1065
Bblid
153364
Inspectionid
357209
Inspect Date
2023-05-17T00:00:00.000
Atdissuedate
2023-05-17T11:38:48.000
Cb
4
House Num
1304
Onstname
INWOOD AVENUE
Atddismissed
No
11325
Atdid: 11325 • Atd Number: ATD-1-214 • Bblid: 114353
Atdid
11325
Atd Number
ATD-1-214
Bblid
114353
Inspectionid
347486
Inspect Date
2022-11-02T00:00:00.000
Atdissuedate
2022-11-02T14:30:47.000
Cb
11
House Num
1453
Onstname
5TH AVE.
Atddismissed
No
11569
Atdid: 11569 • Atd Number: ATD-4-4938 • Bblid: 759894
Atdid
11569
Atd Number
ATD-4-4938
Bblid
759894
Inspectionid
349948
Inspect Date
2022-12-28T00:00:00.000
Atdissuedate
2023-01-03T12:32:27.000
Cb
13
House Num
83-29
Onstname
240TH ST.
Atddismissed
Yes
Atddismissedon
2023-01-03T12:33:12.000
8653
Atdid: 8653 • Atd Number: ATD-3-3177 • Bblid: 474007
Atdid
8653
Atd Number
ATD-3-3177
Bblid
474007
Inspectionid
330798
Inspect Date
2021-07-14T00:00:00.000
Atdissuedate
2021-12-16T08:58:18.000
Cb
12
House Num
1540
Onstname
E. 7TH ST.
Atddismissed
No
12640
Atdid: 12640 • Atd Number: ATD-4-5381 • Bblid: 568712
Atdid
12640
Atd Number
ATD-4-5381
Bblid
568712
Inspectionid
358941
Inspect Date
2023-06-23T00:00:00.000
Atdissuedate
2023-06-23T12:12:19.000
Cb
2
House Num
45-10
Onstname
COURT SQ.
Atddismissed
No
18072
Atdid: 18072 • Atd Number: ATD-3-7123 • Bblid: 529828
Atdid
18072
Atd Number
ATD-3-7123
Bblid
529828
Inspectionid
402296
Inspect Date
2025-06-04T00:00:00.000
Atdissuedate
2025-07-14T13:27:55.000
Cb
17
House Num
392
Onstname
E. 58TH ST.
Atddismissed
No
11617
Atdid: 11617 • Atd Number: ATD-4-4972 • Bblid: 647095
Atdid
11617
Atd Number
ATD-4-4972
Bblid
647095
Inspectionid
350661
Inspect Date
2023-01-17T00:00:00.000
Atdissuedate
2023-01-23T14:39:53.000
Cb
5
House Num
61-64
Onstname
69TH LN.
Atddismissed
No
8652
Atdid: 8652 • Atd Number: ATD-3-3176 • Bblid: 473995
Atdid
8652
Atd Number
ATD-3-3176
Bblid
473995
Inspectionid
330797
Inspect Date
2021-07-14T00:00:00.000
Atdissuedate
2021-12-16T08:55:54.000
Cb
12
House Num
1516
Onstname
E. 7TH ST.
Atddismissed
No
8702
Atdid: 8702 • Atd Number: ATD-4-3915 • Bblid: 870383
Atdid
8702
Atd Number
ATD-4-3915
Bblid
870383
Inspectionid
330904
Inspect Date
2021-08-30T00:00:00.000
Atdissuedate
2021-12-20T11:57:41.000
Cb
12
House Num
137-29
Onstname
157TH ST.
Atddismissed
No
16864
Atdid: 16864 • Atd Number: ATD-4-6631 • Bblid: 810336
Atdid
16864
Atd Number
ATD-4-6631
Bblid
810336
Inspectionid
390383
Inspect Date
2025-02-20T00:00:00.000
Atdissuedate
2025-03-06T09:24:24.000
Cb
12
House Num
89-08
Onstname
186TH ST.
Atddismissed
No
11860
Atdid: 11860 • Atd Number: ATD-3-4833 • Bblid: 509756
Atdid
11860
Atd Number
ATD-3-4833
Bblid
509756
Inspectionid
353583
Inspect Date
2023-03-16T00:00:00.000
Atdissuedate
2023-03-22T12:06:46.000
Cb
15
House Num
2412
Onstname
E. 14TH ST.
Atddismissed
No
12525
Atdid: 12525 • Atd Number: ATD-4-5343 • Bblid: 783521
Atdid
12525
Atd Number
ATD-4-5343
Bblid
783521
Violationid
283691
Reinspectionid
35363
Inspect Date
2023-06-06T15:43:21.000
Atdissuedate
2023-06-06T15:43:21.000
Cb
9
House Num
97-26
Onstname
76 STREET
Atddismissed
No
11819
Atdid: 11819 • Atd Number: ATD-3-4808 • Bblid: 433768
Atdid
11819
Atd Number
ATD-3-4808
Bblid
433768
Inspectionid
353262
Inspect Date
2023-02-15T00:00:00.000
Atdissuedate
2023-03-20T10:11:00.000
Cb
12
House Num
1157
Onstname
51ST ST.
Atddismissed
No
18567
Atdid: 18567 • Atd Number: ATD-3-7311 • Bblid: 506446
Atdid
18567
Atd Number
ATD-3-7311
Bblid
506446
Inspectionid
405615
Inspect Date
2025-09-09T00:00:00.000
Atdissuedate
2025-09-10T12:02:12.000
Cb
15
House Num
2167
Onstname
E. 26TH ST.
Atddismissed
No
18370
Atdid: 18370 • Atd Number: ATD-2-1448 • Bblid: 223813
Atdid
18370
Atd Number
ATD-2-1448
Bblid
223813
Inspectionid
404506
Inspect Date
2025-07-23T00:00:00.000
Atdissuedate
2025-08-19T14:38:15.000
Cb
12
House Num
4079
Onstname
EDSON AVE.
Atddismissed
No
17808
Atdid: 17808 • Atd Number: ATD-4-7025 • Bblid: 870396
Atdid
17808
Atd Number
ATD-4-7025
Bblid
870396
Inspectionid
399310
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-06T11:14:52.000
Cb
12
House Num
165-04
Onstname
SAYRES AVE.
Atddismissed
No
15115
Atdid: 15115 • Atd Number: ATD-4-6314 • Bblid: 807053
Atdid
15115
Atd Number
ATD-4-6314
Bblid
807053
Inspectionid
382228
Inspect Date
2024-08-27T00:00:00.000
Atdissuedate
2024-09-23T16:20:40.000
Cb
12
House Num
170-21
Onstname
90TH AVE.
Atddismissed
No
14831
Atdid: 14831 • Atd Number: ATD-4-6186 • Bblid: 862255
Atdid
14831
Atd Number
ATD-4-6186
Bblid
862255
Violationid
295667
Reinspectionid
37008
Inspect Date
2024-07-31T14:08:34.000
Atdissuedate
2024-07-31T14:08:34.000
Cb
12
House Num
115-04
Onstname
145 STREET
Atddismissed
No
14691
Atdid: 14691 • Atd Number: ATD-4-6118 • Bblid: 591060
Atdid
14691
Atd Number
ATD-4-6118
Bblid
591060
Inspectionid
379068
Inspect Date
2024-06-24T00:00:00.000
Atdissuedate
2024-07-08T10:01:02.000
Cb
1
House Num
19-09
Onstname
21ST DR.
Atddismissed
No
11581
Atdid: 11581 • Atd Number: ATD-4-4948 • Bblid: 759838
Atdid
11581
Atd Number
ATD-4-4948
Bblid
759838
Inspectionid
350088
Inspect Date
2023-01-05T00:00:00.000
Atdissuedate
2023-01-06T11:26:04.000
Cb
13
House Num
82-18
Onstname
243RD ST.
Atddismissed
No
9411
Atdid: 9411 • Atd Number: ATD-4-4212 • Bblid: 683628
Atdid
9411
Atd Number
ATD-4-4212
Bblid
683628
Inspectionid
333179
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-03-04T10:24:49.000
Cb
7
House Num
18-22
Onstname
PARSONS BLVD.
Atddismissed
No
8620
Atdid: 8620 • Atd Number: ATD-3-3159 • Bblid: 282751
Atdid
8620
Atd Number
ATD-3-3159
Bblid
282751
Inspectionid
330715
Inspect Date
2019-05-15T00:00:00.000
Atdissuedate
2021-12-14T17:23:41.000
Cb
6
House Num
587
Onstname
7TH ST.
Atddismissed
No
12863
Atdid: 12863 • Atd Number: ATD-3-5167 • Bblid: 510059
Atdid
12863
Atd Number
ATD-3-5167
Bblid
510059
Inspectionid
360062
Inspect Date
2023-07-15T00:00:00.000
Atdissuedate
2023-07-15T15:08:20.000
Cb
15
House Num
2436
Onstname
E. 26TH ST.
Atddismissed
No
13574
Atdid: 13574 • Atd Number: ATD-2-1247 • Bblid: 141072
Atdid
13574
Atd Number
ATD-2-1247
Bblid
141072
Inspectionid
365196
Inspect Date
2023-10-05T00:00:00.000
Atdissuedate
2023-10-12T09:54:49.000
Cb
4
House Num
607
Onstname
WALTON AVE.
Atddismissed
No
17895
Atdid: 17895 • Atd Number: ATD-4-7075 • Bblid: 650498
Atdid
17895
Atd Number
ATD-4-7075
Bblid
650498
Inspectionid
400427
Inspect Date
2025-06-12T00:00:00.000
Atdissuedate
2025-06-16T11:12:48.000
Cb
5
House Num
64-26
Onstname
83RD ST.
Atddismissed
No
9327
Atdid: 9327 • Atd Number: ATD-3-3430 • Bblid: 460984
Atdid
9327
Atd Number
ATD-3-3430
Bblid
460984
Inspectionid
333037
Inspect Date
2019-06-26T00:00:00.000
Atdissuedate
2022-03-02T09:45:41.000
Cb
11
House Num
1936
Onstname
78TH ST.
Atddismissed
No
14624
Atdid: 14624 • Atd Number: ATD-3-6061 • Bblid: 424789
Atdid
14624
Atd Number
ATD-3-6061
Bblid
424789
Inspectionid
378571
Inspect Date
2024-06-15T00:00:00.000
Atdissuedate
2024-06-18T10:02:35.000
Cb
12
House Num
1643
Onstname
55TH ST.
Atddismissed
No
7649
Atdid: 7649 • Atd Number: ATD-2-762 • Bblid: 150588
Atdid
7649
Atd Number
ATD-2-762
Bblid
150588
Inspectionid
308326
Inspect Date
2020-01-15T00:00:00.000
Atdissuedate
2020-01-15T00:00:00.000
Cb
2
House Num
1041
Onstname
FAILE ST.
Atddismissed
Yes
Atddismissedon
2025-08-05T12:38:11.000
10661
Atdid: 10661 • Atd Number: ATD-3-4059 • Bblid: 514981
Atdid
10661
Atd Number
ATD-3-4059
Bblid
514981
Inspectionid
341676
Inspect Date
2022-08-16T00:00:00.000
Atdissuedate
2022-08-18T08:54:08.000
Cb
14
House Num
1185
Onstname
E. 21ST ST.
Atddismissed
No
12729
Atdid: 12729 • Atd Number: ATD-2-1179 • Bblid: 139983
Atdid
12729
Atd Number
ATD-2-1179
Bblid
139983
Inspectionid
359176
Inspect Date
2023-06-27T00:00:00.000
Atdissuedate
2023-06-30T09:29:07.000
Cb
1
House Num
423
Onstname
E. 140TH ST.
Atddismissed
No
16931
Atdid: 16931 • Atd Number: ATD-3-6637 • Bblid: 278765
Atdid
16931
Atd Number
ATD-3-6637
Bblid
278765
Inspectionid
391408
Inspect Date
2025-03-14T00:00:00.000
Atdissuedate
2025-03-17T08:27:22.000
Cb
6
House Num
395
Onstname
8TH ST.
Atddismissed
No
NYC Data AI • Public-data exploration interface