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
17348
Atdid: 17348 • Atd Number: ATD-3-6876 • Bblid: 375553
Atdid
17348
Atd Number
ATD-3-6876
Bblid
375553
Inspectionid
394544
Inspect Date
2025-04-11T00:00:00.000
Atdissuedate
2025-04-14T10:50:45.000
Cb
5
House Num
329
Onstname
ASHFORD ST.
Atddismissed
No
12511
Atdid: 12511 • Atd Number: ATD-2-1136 • Bblid: 162035
Atdid
12511
Atd Number
ATD-2-1136
Bblid
162035
Inspectionid
358065
Inspect Date
2023-06-01T00:00:00.000
Atdissuedate
2023-06-05T09:32:51.000
Cb
6
House Num
870
Onstname
HORNADAY PL.
Atddismissed
No
14454
Atdid: 14454 • Atd Number: ATD-3-5976 • Bblid: 453173
Atdid
14454
Atd Number
ATD-3-5976
Bblid
453173
Inspectionid
377249
Inspect Date
2024-05-04T00:00:00.000
Atdissuedate
2024-05-13T11:03:04.000
Cb
10
House Num
215
Onstname
93RD ST.
Atddismissed
No
11919
Atdid: 11919 • Atd Number: ATD-3-4870 • Bblid: 286528
Atdid
11919
Atd Number
ATD-3-4870
Bblid
286528
Inspectionid
354166
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-29T12:09:42.000
Cb
8
House Num
225
Onstname
PROSPECT PL.
Atddismissed
No
10017
Atdid: 10017 • Atd Number: ATD-3-3675 • Bblid: 265147
Atdid
10017
Atd Number
ATD-3-3675
Bblid
265147
Inspectionid
335964
Inspect Date
2022-05-02T00:00:00.000
Atdissuedate
2022-05-02T13:35:31.000
Cb
7
House Num
750
Onstname
43RD ST.
Atddismissed
No
17676
Atdid: 17676 • Atd Number: ATD-4-6932 • Bblid: 647997
Atdid
17676
Atd Number
ATD-4-6932
Bblid
647997
Inspectionid
397672
Inspect Date
2025-05-17T00:00:00.000
Atdissuedate
2025-05-19T14:39:26.000
Cb
5
House Num
62-12
Onstname
69TH PL.
Atddismissed
No
8956
Atdid: 8956 • Atd Number: ATD-4-4055 • Bblid: 895601
Atdid
8956
Atd Number
ATD-4-4055
Bblid
895601
Inspectionid
332257
Inspect Date
2019-06-15T00:00:00.000
Atdissuedate
2022-02-04T11:46:23.000
Cb
13
House Num
141-45
Onstname
256TH ST.
Atddismissed
No
11353
Atdid: 11353 • Atd Number: ATD-3-4627 • Bblid: 282857
Atdid
11353
Atd Number
ATD-3-4627
Bblid
282857
Inspectionid
347734
Inspect Date
2022-11-02T00:00:00.000
Atdissuedate
2022-11-07T11:46:14.000
Cb
6
House Num
510
Onstname
7TH ST.
Atddismissed
No
11467
Atdid: 11467 • Atd Number: ATD-3-4676 • Bblid: 282428
Atdid
11467
Atd Number
ATD-3-4676
Bblid
282428
Inspectionid
348755
Inspect Date
2022-11-29T00:00:00.000
Atdissuedate
2022-11-29T15:18:12.000
Cb
6
House Num
17
Onstname
MONTGOMERY PL.
Atddismissed
No
11475
Atdid: 11475 • Atd Number: ATD-4-4901 • Bblid: 604739
Atdid
11475
Atd Number
ATD-4-4901
Bblid
604739
Inspectionid
348866
Inspect Date
2018-10-18T00:00:00.000
Atdissuedate
2022-12-01T10:26:52.000
Cb
3
House Num
25-50
Onstname
88TH ST.
Atddismissed
No
16863
Atdid: 16863 • Atd Number: ATD-4-6630 • Bblid: 787197
Atdid
16863
Atd Number
ATD-4-6630
Bblid
787197
Inspectionid
390368
Inspect Date
2025-02-27T00:00:00.000
Atdissuedate
2025-03-06T09:07:21.000
Cb
10
House Num
109-09
Onstname
97TH ST.
Atddismissed
No
13079
Atdid: 13079 • Atd Number: ATD-3-5310 • Bblid: 509064
Atdid
13079
Atd Number
ATD-3-5310
Bblid
509064
Inspectionid
361189
Inspect Date
2023-07-25T00:00:00.000
Atdissuedate
2023-08-01T12:04:19.000
Cb
15
House Num
2322
Onstname
E. 24TH ST.
Atddismissed
No
14112
Atdid: 14112 • Atd Number: ATD-3-5795 • Bblid: 313642
Atdid
14112
Atd Number
ATD-3-5795
Bblid
313642
Inspectionid
373229
Inspect Date
2024-02-27T00:00:00.000
Atdissuedate
2024-03-14T13:35:29.000
Cb
3
House Num
254
Onstname
VERNON AVE.
Atddismissed
No
12794
Atdid: 12794 • Atd Number: ATD-3-5128 • Bblid: 503151
Atdid
12794
Atd Number
ATD-3-5128
Bblid
503151
Inspectionid
359622
Inspect Date
2023-07-08T00:00:00.000
Atdissuedate
2023-07-08T13:01:03.000
Cb
15
House Num
1986
Onstname
E. 22ND ST.
Atddismissed
No
9192
Atdid: 9192 • Atd Number: ATD-1-179 • Bblid: 132371
Atdid
9192
Atd Number
ATD-1-179
Bblid
132371
Inspectionid
332850
Inspect Date
2010-08-04T00:00:00.000
Atdissuedate
2022-02-28T17:29:17.000
Cb
9
House Num
429
Onstname
CONVENT AVE.
Atddismissed
No
16844
Atdid: 16844 • Atd Number: ATD-5-907 • Bblid: 932826
Atdid
16844
Atd Number
ATD-5-907
Bblid
932826
Inspectionid
390133
Inspect Date
2025-03-01T00:00:00.000
Atdissuedate
2025-03-01T12:39:33.000
Cb
1
House Num
37
Onstname
BLAINE CT.
Atddismissed
No
12699
Atdid: 12699 • Atd Number: ATD-5-734 • Bblid: 1009669
Atdid
12699
Atd Number
ATD-5-734
Bblid
1009669
Inspectionid
359110
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-29T15:18:22.000
Cb
3
House Num
366
Onstname
ARTHUR KILL RD.
Atddismissed
No
13200
Atdid: 13200 • Atd Number: ATD-3-5379 • Bblid: 309815
Atdid
13200
Atd Number
ATD-3-5379
Bblid
309815
Inspectionid
361843
Inspect Date
2023-08-11T00:00:00.000
Atdissuedate
2023-08-11T08:22:31.000
Cb
3
House Num
500
Onstname
HALSEY ST.
Atddismissed
No
12418
Atdid: 12418 • Atd Number: ATD-2-1128 • Bblid: 181317
Atdid
12418
Atd Number
ATD-2-1128
Bblid
181317
Inspectionid
357743
Inspect Date
2023-05-26T00:00:00.000
Atdissuedate
2023-05-26T12:18:26.000
Cb
9
House Num
2001
Onstname
WESTCHESTER AVE.
Atddismissed
No
18266
Atdid: 18266 • Atd Number: ATD-4-7211 • Bblid: 856075
Atdid
18266
Atd Number
ATD-4-7211
Bblid
856075
Inspectionid
403680
Inspect Date
2025-08-05T00:00:00.000
Atdissuedate
2025-08-06T09:01:31.000
Cb
10
House Num
133-01
Onstname
114TH PL.
Atddismissed
No
16665
Atdid: 16665 • Atd Number: ATD-3-6533 • Bblid: 515868
Atdid
16665
Atd Number
ATD-3-6533
Bblid
515868
Inspectionid
388558
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2025-01-08T10:30:39.000
Cb
18
House Num
1156
Onstname
E. 38TH ST.
Atddismissed
No
13334
Atdid: 13334 • Atd Number: ATD-3-5476 • Bblid: 487580
Atdid
13334
Atd Number
ATD-3-5476
Bblid
487580
Inspectionid
362665
Inspect Date
2023-08-22T00:00:00.000
Atdissuedate
2023-08-28T11:41:02.000
Cb
11
House Num
172
Onstname
BAY 37TH ST.
Atddismissed
No
9260
Atdid: 9260 • Atd Number: ATD-3-3384 • Bblid: 471446
Atdid
9260
Atd Number
ATD-3-3384
Bblid
471446
Inspectionid
332966
Inspect Date
2021-05-07T00:00:00.000
Atdissuedate
2022-03-01T17:38:11.000
Cb
12
House Num
1326
Onstname
E. 5TH ST.
Atddismissed
No
12644
Atdid: 12644 • Atd Number: ATD-4-5385 • Bblid: 568205
Atdid
12644
Atd Number
ATD-4-5385
Bblid
568205
Inspectionid
358945
Inspect Date
2023-06-23T00:00:00.000
Atdissuedate
2023-06-23T12:40:32.000
Cb
2
House Num
25-34
Onstname
JACKSON AVE.
Atddismissed
No
9911
Atdid: 9911 • Atd Number: ATD-5-659 • Bblid: 997188
Atdid
9911
Atd Number
ATD-5-659
Bblid
997188
Inspectionid
335202
Inspect Date
2022-01-12T00:00:00.000
Atdissuedate
2022-04-20T09:13:22.000
Cb
2
House Num
385
Onstname
JEFFERSON AVE.
Atddismissed
No
13397
Atdid: 13397 • Atd Number: ATD-3-5516 • Bblid: 477243
Atdid
13397
Atd Number
ATD-3-5516
Bblid
477243
Inspectionid
363385
Inspect Date
2023-08-29T00:00:00.000
Atdissuedate
2023-09-11T18:12:41.000
Cb
11
House Num
1770
Onstname
W. 8TH ST.
Atddismissed
No
13428
Atdid: 13428 • Atd Number: ATD-4-5532 • Bblid: 592290
Atdid
13428
Atd Number
ATD-4-5532
Bblid
592290
Inspectionid
363875
Inspect Date
2023-09-16T00:00:00.000
Atdissuedate
2023-09-20T12:15:49.000
Cb
1
House Num
19-24
Onstname
81ST ST.
Atddismissed
No
18410
Atdid: 18410 • Atd Number: ATD-2-1450 • Bblid: 197386
Atdid
18410
Atd Number
ATD-2-1450
Bblid
197386
Inspectionid
404684
Inspect Date
2025-03-11T00:00:00.000
Atdissuedate
2025-08-22T12:15:39.000
Cb
11
House Num
1622
Onstname
BOGART AVE.
Atddismissed
No
17576
Atdid: 17576 • Atd Number: ATD-4-6870 • Bblid: 792867
Atdid
17576
Atd Number
ATD-4-6870
Bblid
792867
Inspectionid
396728
Inspect Date
2025-05-08T00:00:00.000
Atdissuedate
2025-05-09T15:36:21.000
Cb
9
House Num
117-18
Onstname
91ST AVE.
Atddismissed
No
17657
Atdid: 17657 • Atd Number: ATD-4-6926 • Bblid: 878738
Atdid
17657
Atd Number
ATD-4-6926
Bblid
878738
Inspectionid
397286
Inspect Date
2025-05-07T00:00:00.000
Atdissuedate
2025-05-16T12:16:23.000
Cb
12
House Num
186-25
Onstname
PINEVILLE LN.
Atddismissed
No
17198
Atdid: 17198 • Atd Number: ATD-4-6707 • Bblid: 867463
Atdid
17198
Atd Number
ATD-4-6707
Bblid
867463
Inspectionid
392855
Inspect Date
2025-03-18T00:00:00.000
Atdissuedate
2025-04-01T11:51:04.000
Cb
12
House Num
114-55
Onstname
157TH ST.
Atddismissed
No
13380
Atdid: 13380 • Atd Number: ATD-5-812 • Bblid: 947724
Atdid
13380
Atd Number
ATD-5-812
Bblid
947724
Inspectionid
363289
Inspect Date
2023-09-09T00:00:00.000
Atdissuedate
2023-09-11T12:37:50.000
Cb
2
House Num
283
Onstname
MARTIN AVE.
Atddismissed
No
9714
Atdid: 9714 • Atd Number: ATD-4-4398 • Bblid: 885109
Atdid
9714
Atd Number
ATD-4-4398
Bblid
885109
Inspectionid
334127
Inspect Date
2010-05-07T00:00:00.000
Atdissuedate
2022-03-24T17:18:00.000
Cb
12
House Num
137-47
Onstname
THURSTON ST.
Atddismissed
No
8496
Atdid: 8496 • Atd Number: ATD-3-3098 • Bblid: 259868
Atdid
8496
Atd Number
ATD-3-3098
Bblid
259868
Inspectionid
329627
Inspect Date
2021-11-15T00:00:00.000
Atdissuedate
2021-11-15T16:24:47.000
Cb
6
House Num
387
Onstname
UNION ST.
Atddismissed
No
17818
Atdid: 17818 • Atd Number: ATD-4-7030 • Bblid: 676319
Atdid
17818
Atd Number
ATD-4-7030
Bblid
676319
Inspectionid
399338
Inspect Date
2025-06-04T00:00:00.000
Atdissuedate
2025-06-06T15:14:21.000
Cb
5
House Num
77-36
Onstname
76TH ST.
Atddismissed
No
16322
Atdid: 16322 • Atd Number: ATD-3-6399 • Bblid: 283418
Atdid
16322
Atd Number
ATD-3-6399
Bblid
283418
Inspectionid
384559
Inspect Date
2024-10-22T00:00:00.000
Atdissuedate
2024-10-29T12:30:05.000
Cb
6
House Num
693
Onstname
10TH ST.
Atddismissed
No
9222
Atdid: 9222 • Atd Number: ATD-4-4193 • Bblid: 744418
Atdid
9222
Atd Number
ATD-4-4193
Bblid
744418
Inspectionid
332880
Inspect Date
2022-02-23T00:00:00.000
Atdissuedate
2022-03-01T09:51:47.000
Cb
8
House Num
164-24
Onstname
73RD AVE.
Atddismissed
No
13507
Atdid: 13507 • Atd Number: ATD-4-5559 • Bblid: 608609
Atdid
13507
Atd Number
ATD-4-5559
Bblid
608609
Inspectionid
364594
Inspect Date
2023-09-28T00:00:00.000
Atdissuedate
2023-09-28T12:55:04.000
Cb
3
House Num
35-48
Onstname
84TH ST.
Atddismissed
No
14590
Atdid: 14590 • Atd Number: ATD-4-6091 • Bblid: 699488
Atdid
14590
Atd Number
ATD-4-6091
Bblid
699488
Inspectionid
378389
Inspect Date
2024-06-05T00:00:00.000
Atdissuedate
2024-06-13T09:58:15.000
Cb
7
House Num
33-20
Onstname
147TH PL.
Atddismissed
No
18468
Atdid: 18468 • Atd Number: ATD-4-7318 • Bblid: 646299
Atdid
18468
Atd Number
ATD-4-7318
Bblid
646299
Inspectionid
405148
Inspect Date
2025-08-26T00:00:00.000
Atdissuedate
2025-09-03T12:10:43.000
Cb
4
House Num
54-53
Onstname
83RD ST.
Atddismissed
No
17996
Atdid: 17996 • Atd Number: ATD-3-7094 • Bblid: 1078591
Atdid
17996
Atd Number
ATD-3-7094
Bblid
1078591
Inspectionid
401627
Inspect Date
2025-06-28T00:00:00.000
Atdissuedate
2025-06-28T15:06:20.000
Cb
5
House Num
605
Onstname
VANDALIA AVE.
Atddismissed
No
12224
Atdid: 12224 • Atd Number: ATD-3-5010 • Bblid: 328510
Atdid
12224
Atd Number
ATD-3-5010
Bblid
328510
Inspectionid
356955
Inspect Date
2023-05-18T00:00:00.000
Atdissuedate
2023-05-11T15:09:46.000
Cb
2
House Num
47
Onstname
S. PORTLAND AVE.
Atddismissed
No
17320
Atdid: 17320 • Atd Number: ATD-3-6858 • Bblid: 319548
Atdid
17320
Atd Number
ATD-3-6858
Bblid
319548
Inspectionid
394427
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-04-14T08:17:21.000
Cb
3
House Num
288
Onstname
MACON ST.
Atddismissed
No
18607
Atdid: 18607 • Atd Number: ATD-3-7332 • Bblid: 551164
Atdid
18607
Atd Number
ATD-3-7332
Bblid
551164
Inspectionid
405949
Inspect Date
2025-08-13T00:00:00.000
Atdissuedate
2025-09-16T12:30:44.000
Cb
18
House Num
1822
Onstname
E. 38TH ST.
Atddismissed
No
10100
Atdid: 10100 • Atd Number: ATD-3-3719 • Bblid: 253957
Atdid
10100
Atd Number
ATD-3-3719
Bblid
253957
Inspectionid
336483
Inspect Date
2022-05-14T00:00:00.000
Atdissuedate
2022-05-17T07:41:20.000
Cb
6
House Num
141
Onstname
AMITY ST.
Atddismissed
Yes
Atddismissedon
2022-11-09T18:09:29.000
12215
Atdid: 12215 • Atd Number: ATD-3-5002 • Bblid: 252769
Atdid
12215
Atd Number
ATD-3-5002
Bblid
252769
Inspectionid
356898
Inspect Date
2023-05-10T00:00:00.000
Atdissuedate
2023-05-10T14:50:19.000
Cb
2
House Num
288
Onstname
HICKS ST.
Atddismissed
No
17299
Atdid: 17299 • Atd Number: ATD-5-956 • Bblid: 991317
Atdid
17299
Atd Number
ATD-5-956
Bblid
991317
Inspectionid
394068
Inspect Date
2025-04-08T00:00:00.000
Atdissuedate
2025-04-10T14:59:41.000
Cb
2
House Num
135
Onstname
REID AVE.
Atddismissed
No
17344
Atdid: 17344 • Atd Number: ATD-4-6761 • Bblid: 817863
Atdid
17344
Atd Number
ATD-4-6761
Bblid
817863
Inspectionid
394516
Inspect Date
2025-03-22T00:00:00.000
Atdissuedate
2025-04-14T09:44:52.000
Cb
12
House Num
106-54
Onstname
RUSCOE ST.
Atddismissed
No
10703
Atdid: 10703 • Atd Number: ATD-3-4086 • Bblid: 508403
Atdid
10703
Atd Number
ATD-3-4086
Bblid
508403
Inspectionid
342125
Inspect Date
2022-08-25T00:00:00.000
Atdissuedate
2022-08-29T11:04:50.000
Cb
15
House Num
2320
Onstname
E. 15TH ST.
Atddismissed
No
13133
Atdid: 13133 • Atd Number: ATD-4-5487 • Bblid: 711460
Atdid
13133
Atd Number
ATD-4-5487
Bblid
711460
Inspectionid
361479
Inspect Date
2023-05-26T00:00:00.000
Atdissuedate
2023-08-03T12:44:19.000
Cb
7
House Num
40-19
Onstname
172ND ST.
Atddismissed
No