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
17748
Atdid: 17748 • Atd Number: ATD-2-1408 • Bblid: 199644
Atdid
17748
Atd Number
ATD-2-1408
Bblid
199644
Inspectionid
398697
Inspect Date
2025-05-27T00:00:00.000
Atdissuedate
2025-05-27T19:34:19.000
Cb
10
House Num
1745
Onstname
PARKVIEW AVE.
Atddismissed
No
17059
Atdid: 17059 • Atd Number: ATD-3-6718 • Bblid: 276203
Atdid
17059
Atd Number
ATD-3-6718
Bblid
276203
Inspectionid
392389
Inspect Date
2022-08-26T00:00:00.000
Atdissuedate
2025-03-27T10:53:20.000
Cb
6
House Num
693
Onstname
PRESIDENT ST.
Atddismissed
No
9778
Atdid: 9778 • Atd Number: ATD-2-916 • Bblid: 218387
Atdid
9778
Atd Number
ATD-2-916
Bblid
218387
Inspectionid
334371
Inspect Date
2019-06-28T00:00:00.000
Atdissuedate
2022-03-29T18:14:49.000
Cb
12
House Num
687
Onstname
E. 224TH ST.
Atddismissed
No
13990
Atdid: 13990 • Atd Number: ATD-4-5820 • Bblid: 773335
Atdid
13990
Atd Number
ATD-4-5820
Bblid
773335
Inspectionid
371974
Inspect Date
2024-02-09T00:00:00.000
Atdissuedate
2024-02-20T13:42:22.000
Cb
13
House Num
80-11
Onstname
257TH ST.
Atddismissed
No
13904
Atdid: 13904 • Atd Number: ATD-3-5715 • Bblid: 477776
Atdid
13904
Atd Number
ATD-3-5715
Bblid
477776
Inspectionid
371096
Inspect Date
2024-01-10T00:00:00.000
Atdissuedate
2024-01-29T14:33:16.000
Cb
15
House Num
1782
Onstname
E. 2ND ST.
Atddismissed
No
9724
Atdid: 9724 • Atd Number: ATD-4-4408 • Bblid: 761295
Atdid
9724
Atd Number
ATD-4-4408
Bblid
761295
Inspectionid
334137
Inspect Date
2019-04-03T00:00:00.000
Atdissuedate
2022-03-24T17:43:45.000
Cb
13
House Num
88-14
Onstname
SABRE ST.
Atddismissed
No
7975
Atdid: 7975 • Atd Number: ATD-1-143 • Bblid: 47229
Atdid
7975
Atd Number
ATD-1-143
Bblid
47229
Inspectionid
316292
Inspect Date
2020-11-27T00:00:00.000
Atdissuedate
2020-11-27T00:00:00.000
Cb
6
House Num
335
Onstname
E. 18TH ST.
Atddismissed
Yes
Atddismissedon
2022-12-28T12:45:15.000
12303
Atdid: 12303 • Atd Number: ATD-2-1100 • Bblid: 153020
Atdid
12303
Atd Number
ATD-2-1100
Bblid
153020
Inspectionid
357354
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T12:13:15.000
Cb
4
House Num
110
Onstname
E. 170TH ST.
Atddismissed
No
10305
Atdid: 10305 • Atd Number: ATD-4-4664 • Bblid: 851055
Atdid
10305
Atd Number
ATD-4-4664
Bblid
851055
Inspectionid
337770
Inspect Date
2022-06-17T00:00:00.000
Atdissuedate
2022-06-17T10:35:44.000
Cb
10
House Num
109-28
Onstname
122ND ST.
Atddismissed
No
14284
Atdid: 14284 • Atd Number: ATD-4-5950 • Bblid: 685005
Atdid
14284
Atd Number
ATD-4-5950
Bblid
685005
Inspectionid
375359
Inspect Date
2024-03-30T00:00:00.000
Atdissuedate
2024-04-15T13:36:02.000
Cb
7
House Num
23-31
Onstname
WHITESTONE EXPY.
Atddismissed
No
10474
Atdid: 10474 • Atd Number: ATD-4-4733 • Bblid: 675886
Atdid
10474
Atd Number
ATD-4-4733
Bblid
675886
Inspectionid
339651
Inspect Date
2022-07-14T00:00:00.000
Atdissuedate
2022-07-14T15:08:39.000
Cb
5
House Num
84-21
Onstname
DORAN AVE.
Atddismissed
Yes
Atddismissedon
2022-07-14T15:09:41.000
11692
Atdid: 11692 • Atd Number: ATD-4-5004 • Bblid: 679899
Atdid
11692
Atd Number
ATD-4-5004
Bblid
679899
Inspectionid
351844
Inspect Date
2023-01-13T00:00:00.000
Atdissuedate
2023-02-21T12:46:53.000
Cb
7
House Num
121-13
Onstname
8TH AVE.
Atddismissed
No
14353
Atdid: 14353 • Atd Number: ATD-3-5913 • Bblid: 326747
Atdid
14353
Atd Number
ATD-3-5913
Bblid
326747
Inspectionid
376052
Inspect Date
2024-04-11T00:00:00.000
Atdissuedate
2024-04-24T10:58:55.000
Cb
2
House Num
69
Onstname
LEFFERTS PL.
Atddismissed
No
16641
Atdid: 16641 • Atd Number: ATD-4-6540 • Bblid: 785680
Atdid
16641
Atd Number
ATD-4-6540
Bblid
785680
Inspectionid
388465
Inspect Date
2024-12-30T00:00:00.000
Atdissuedate
2025-01-03T12:18:41.000
Cb
10
House Num
107-56
Onstname
77TH ST.
Atddismissed
No
11505
Atdid: 11505 • Atd Number: ATD-3-4703 • Bblid: 280079
Atdid
11505
Atd Number
ATD-3-4703
Bblid
280079
Inspectionid
349261
Inspect Date
2022-11-30T00:00:00.000
Atdissuedate
2022-12-13T12:55:06.000
Cb
6
House Num
244
Onstname
13TH ST.
Atddismissed
No
2652
Atdid: 2652 • Atd Number: ATD-3-1795 • Bblid: 554013
Atdid
2652
Atd Number
ATD-3-1795
Bblid
554013
Violationid
244725
Atdissuedate
2020-02-07T00:00:00.000
Cb
18
House Num
2061
Onstname
EAST 53 PLACE
Atddismissed
Yes
Atddismissedon
2025-08-21T16:45:10.000
9876
Atdid: 9876 • Atd Number: ATD-4-4485 • Bblid: 674091
Atdid
9876
Atd Number
ATD-4-4485
Bblid
674091
Inspectionid
334933
Inspect Date
2021-09-30T00:00:00.000
Atdissuedate
2022-04-15T08:59:21.000
Cb
5
House Num
78-29
Onstname
65TH ST.
Atddismissed
No
8907
Atdid: 8907 • Atd Number: ATD-5-599 • Bblid: 935961
Atdid
8907
Atd Number
ATD-5-599
Bblid
935961
Inspectionid
332126
Inspect Date
2010-07-01T00:00:00.000
Atdissuedate
2022-01-28T09:10:42.000
Cb
1
House Num
136
Onstname
CROWELL AVE.
Atddismissed
No
12294
Atdid: 12294 • Atd Number: ATD-2-1091 • Bblid: 144194
Atdid
12294
Atd Number
ATD-2-1091
Bblid
144194
Inspectionid
357343
Inspect Date
2023-05-12T00:00:00.000
Atdissuedate
2023-05-19T11:49:01.000
Cb
4
House Num
12
Onstname
E. 167TH ST.
Atddismissed
No
12139
Atdid: 12139 • Atd Number: ATD-4-5168 • Bblid: 611444
Atdid
12139
Atd Number
ATD-4-5168
Bblid
611444
Inspectionid
356604
Inspect Date
2023-05-03T00:00:00.000
Atdissuedate
2023-05-03T13:30:59.000
Cb
4
House Num
42-41
Onstname
78TH ST.
Atddismissed
No
17306
Atdid: 17306 • Atd Number: ATD-4-6751 • Bblid: 580383
Atdid
17306
Atd Number
ATD-4-6751
Bblid
580383
Inspectionid
394340
Inspect Date
2025-01-06T00:00:00.000
Atdissuedate
2025-04-11T12:20:28.000
Cb
1
House Num
25-77
Onstname
38TH ST.
Atddismissed
No
9311
Atdid: 9311 • Atd Number: ATD-3-3415 • Bblid: 416777
Atdid
9311
Atd Number
ATD-3-3415
Bblid
416777
Inspectionid
333017
Inspect Date
2018-08-02T00:00:00.000
Atdissuedate
2022-03-02T08:53:07.000
Cb
12
House Num
3550
Onstname
12TH AVE.
Atddismissed
No
18654
Atdid: 18654 • Atd Number: ATD-2-1477 • Bblid: 233950
Atdid
18654
Atd Number
ATD-2-1477
Bblid
233950
Inspectionid
406301
Inspect Date
2025-08-30T00:00:00.000
Atdissuedate
2025-09-22T11:10:46.000
Cb
10
House Num
2908
Onstname
OTIS AVE.
Atddismissed
No
12681
Atdid: 12681 • Atd Number: ATD-3-5096 • Bblid: 554685
Atdid
12681
Atd Number
ATD-3-5096
Bblid
554685
Violationid
285164
Reinspectionid
35591
Inspect Date
2023-06-29T11:15:55.000
Atdissuedate
2023-06-29T11:15:55.000
Cb
18
House Num
2269
Onstname
NATIONAL DRIVE
Atddismissed
No
8970
Atdid: 8970 • Atd Number: ATD-4-4069 • Bblid: 896727
Atdid
8970
Atd Number
ATD-4-4069
Bblid
896727
Inspectionid
332271
Inspect Date
2019-07-05T00:00:00.000
Atdissuedate
2022-02-07T09:53:59.000
Cb
13
House Num
256-22
Onstname
147TH AVE.
Atddismissed
No
14913
Atdid: 14913 • Atd Number: ATD-4-6225 • Bblid: 661374
Atdid
14913
Atd Number
ATD-4-6225
Bblid
661374
Inspectionid
380654
Inspect Date
2024-08-10T00:00:00.000
Atdissuedate
2024-08-16T09:12:42.000
Cb
9
House Num
82-26
Onstname
GRENFELL ST.
Atddismissed
No
12435
Atdid: 12435 • Atd Number: ATD-4-5277 • Bblid: 568779
Atdid
12435
Atd Number
ATD-4-5277
Bblid
568779
Inspectionid
357783
Inspect Date
2023-05-30T00:00:00.000
Atdissuedate
2023-05-30T10:17:45.000
Cb
2
House Num
39-41
Onstname
49TH ST.
Atddismissed
No
8876
Atdid: 8876 • Atd Number: ATD-3-3242 • Bblid: 506206
Atdid
8876
Atd Number
ATD-3-3242
Bblid
506206
Inspectionid
331875
Inspect Date
2022-01-25T00:00:00.000
Atdissuedate
2022-01-25T10:37:33.000
Cb
15
House Num
2114
Onstname
E. 19TH ST.
Atddismissed
No
17084
Atdid: 17084 • Atd Number: ATD-3-6735 • Bblid: 287619
Atdid
17084
Atd Number
ATD-3-6735
Bblid
287619
Inspectionid
392457
Inspect Date
2023-03-09T00:00:00.000
Atdissuedate
2025-03-27T15:07:39.000
Cb
8
House Num
588
Onstname
PARK PL.
Atddismissed
Yes
Atddismissedon
2025-08-05T12:50:33.000
13441
Atdid: 13441 • Atd Number: ATD-2-1236 • Bblid: 216288
Atdid
13441
Atd Number
ATD-2-1236
Bblid
216288
Inspectionid
364011
Inspect Date
2023-08-08T00:00:00.000
Atdissuedate
2023-09-21T09:31:53.000
Cb
12
House Num
3214
Onstname
SEYMOUR AVE.
Atddismissed
No
16751
Atdid: 16751 • Atd Number: ATD-4-6593 • Bblid: 788823
Atdid
16751
Atd Number
ATD-4-6593
Bblid
788823
Inspectionid
389063
Inspect Date
2025-01-09T00:00:00.000
Atdissuedate
2025-01-29T11:10:41.000
Cb
9
House Num
84-32
Onstname
124TH ST.
Atddismissed
No
12732
Atdid: 12732 • Atd Number: ATD-4-5399 • Bblid: 837447
Atdid
12732
Atd Number
ATD-4-5399
Bblid
837447
Inspectionid
359228
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-30T11:35:22.000
Cb
13
House Num
212-32
Onstname
NASHVILLE BLVD.
Atddismissed
No
10757
Atdid: 10757 • Atd Number: ATD-3-4135 • Bblid: 265195
Atdid
10757
Atd Number
ATD-3-4135
Bblid
265195
Inspectionid
342773
Inspect Date
2022-09-02T00:00:00.000
Atdissuedate
2022-09-06T15:12:58.000
Cb
7
House Num
440
Onstname
44TH ST.
Atddismissed
No
959
Atdid: 959 • Atd Number: ATD-3-102 • Bblid: 436920
Atdid
959
Atd Number
ATD-3-102
Bblid
436920
Violationid
75099
Atdissuedate
2020-08-13T00:00:00.000
Cb
12
House Num
1145
Onstname
59 STREET
Atddismissed
Yes
Atddismissedon
2021-12-02T12:28:08.000
9186
Atdid: 9186 • Atd Number: ATD-1-176 • Bblid: 27067
Atdid
9186
Atd Number
ATD-1-176
Bblid
27067
Inspectionid
332844
Inspect Date
2020-02-07T00:00:00.000
Atdissuedate
2022-02-28T17:17:59.000
Cb
2
House Num
00134
Onstname
WEST 13 STREET
Atddismissed
No
11093
Atdid: 11093 • Atd Number: ATD-3-4441 • Bblid: 555888
Atdid
11093
Atd Number
ATD-3-4441
Bblid
555888
Inspectionid
345117
Inspect Date
2022-09-28T00:00:00.000
Atdissuedate
2022-10-04T09:45:45.000
Cb
18
House Num
2616
Onstname
E. 65TH ST.
Atddismissed
No
14269
Atdid: 14269 • Atd Number: ATD-4-5942 • Bblid: 644690
Atdid
14269
Atd Number
ATD-4-5942
Bblid
644690
Inspectionid
375197
Inspect Date
2024-04-11T00:00:00.000
Atdissuedate
2024-04-11T10:51:24.000
Cb
4
House Num
57-35
Onstname
SEABURY ST.
Atddismissed
No
12780
Atdid: 12780 • Atd Number: ATD-4-5418 • Bblid: 587104
Atdid
12780
Atd Number
ATD-4-5418
Bblid
587104
Inspectionid
359540
Inspect Date
2023-07-07T00:00:00.000
Atdissuedate
2023-07-07T10:53:38.000
Cb
1
House Num
20-14
Onstname
35TH ST.
Atddismissed
No
18157
Atdid: 18157 • Atd Number: ATD-4-7171 • Bblid: 827080
Atdid
18157
Atd Number
ATD-4-7171
Bblid
827080
Inspectionid
402900
Inspect Date
2025-06-26T00:00:00.000
Atdissuedate
2025-07-22T12:40:41.000
Cb
13
House Num
91-21
Onstname
215TH PL.
Atddismissed
No
16299
Atdid: 16299 • Atd Number: ATD-3-6376 • Bblid: 279081
Atdid
16299
Atd Number
ATD-3-6376
Bblid
279081
Inspectionid
384478
Inspect Date
2024-09-27T00:00:00.000
Atdissuedate
2024-10-28T10:54:58.000
Cb
6
House Num
351
Onstname
11TH ST.
Atddismissed
No
12605
Atdid: 12605 • Atd Number: ATD-4-5368 • Bblid: 887427
Atdid
12605
Atd Number
ATD-4-5368
Bblid
887427
Inspectionid
358670
Inspect Date
2023-05-25T00:00:00.000
Atdissuedate
2023-06-15T13:54:43.000
Cb
13
House Num
135-29
Onstname
227TH ST.
Atddismissed
No
14563
Atdid: 14563 • Atd Number: ATD-2-1282 • Bblid: 246423
Atdid
14563
Atd Number
ATD-2-1282
Bblid
246423
Inspectionid
378212
Inspect Date
2024-06-06T00:00:00.000
Atdissuedate
2024-06-06T12:15:54.000
Cb
8
House Num
6169
Onstname
LIEBIG AVE.
Atddismissed
No
9197
Atdid: 9197 • Atd Number: ATD-3-3353 • Bblid: 434753
Atdid
9197
Atd Number
ATD-3-3353
Bblid
434753
Inspectionid
332855
Inspect Date
2020-11-12T00:00:00.000
Atdissuedate
2022-02-28T17:34:27.000
Cb
12
House Num
1117
Onstname
54TH ST.
Atddismissed
No
14976
Atdid: 14976 • Atd Number: ATD-4-6255 • Bblid: 760029
Atdid
14976
Atd Number
ATD-4-6255
Bblid
760029
Inspectionid
381189
Inspect Date
2024-08-13T00:00:00.000
Atdissuedate
2024-08-28T09:44:02.000
Cb
13
House Num
80-56
Onstname
233RD ST.
Atddismissed
No
12483
Atdid: 12483 • Atd Number: ATD-2-1131 • Bblid: 236807
Atdid
12483
Atd Number
ATD-2-1131
Bblid
236807
Inspectionid
358009
Inspect Date
2023-05-26T00:00:00.000
Atdissuedate
2023-06-02T11:56:27.000
Cb
10
House Num
200
Onstname
THROGS NECK BLVD
Atddismissed
No
11316
Atdid: 11316 • Atd Number: ATD-3-4602 • Bblid: 298957
Atdid
11316
Atd Number
ATD-3-4602
Bblid
298957
Inspectionid
347442
Inspect Date
2022-10-29T00:00:00.000
Atdissuedate
2022-11-01T15:41:06.000
Cb
9
House Num
821
Onstname
MONTGOMERY ST.
Atddismissed
No
9338
Atdid: 9338 • Atd Number: ATD-4-4204 • Bblid: 728026
Atdid
9338
Atd Number
ATD-4-4204
Bblid
728026
Inspectionid
333061
Inspect Date
2019-06-22T00:00:00.000
Atdissuedate
2022-03-02T15:46:49.000
Cb
11
House Num
36-20
Onstname
212TH ST.
Atddismissed
No
10736
Atdid: 10736 • Atd Number: ATD-3-4115 • Bblid: 554715
Atdid
10736
Atd Number
ATD-3-4115
Bblid
554715
Inspectionid
342613
Inspect Date
2022-08-23T00:00:00.000
Atdissuedate
2022-09-06T10:21:29.000
Cb
18
House Num
2771
Onstname
E. 64TH ST.
Atddismissed
No
11606
Atdid: 11606 • Atd Number: ATD-4-4970 • Bblid: 579784
Atdid
11606
Atd Number
ATD-4-4970
Bblid
579784
Inspectionid
350495
Inspect Date
2023-01-09T00:00:00.000
Atdissuedate
2023-01-17T12:22:23.000
Cb
1
House Num
31-17
Onstname
36TH ST.
Atddismissed
No
9341
Atdid: 9341 • Atd Number: ATD-3-3438 • Bblid: 479545
Atdid
9341
Atd Number
ATD-3-3438
Bblid
479545
Inspectionid
333064
Inspect Date
2021-03-10T00:00:00.000
Atdissuedate
2022-03-02T16:54:41.000
Cb
15
House Num
1818
Onstname
E. 8TH ST.
Atddismissed
No