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
18134
Atdid: 18134 • Atd Number: ATD-4-7168 • Bblid: 771935
Atdid
18134
Atd Number
ATD-4-7168
Bblid
771935
Inspectionid
402719
Inspect Date
2025-07-17T00:00:00.000
Atdissuedate
2025-07-21T08:32:28.000
Cb
13
House Num
248-51
Onstname
88TH DR.
Atddismissed
No
11622
Atdid: 11622 • Atd Number: ATD-2-972 • Bblid: 164786
Atdid
11622
Atd Number
ATD-2-972
Bblid
164786
Inspectionid
350733
Inspect Date
2023-01-13T00:00:00.000
Atdissuedate
2023-01-25T12:11:53.000
Cb
8
House Num
3131
Onstname
SEDGWICK AVE.
Atddismissed
No
18084
Atdid: 18084 • Atd Number: ATD-4-7144 • Bblid: 834143
Atdid
18084
Atd Number
ATD-4-7144
Bblid
834143
Inspectionid
402333
Inspect Date
2025-06-23T00:00:00.000
Atdissuedate
2025-07-14T14:14:11.000
Cb
12
House Num
191-09
Onstname
109TH RD.
Atddismissed
No
9544
Atdid: 9544 • Atd Number: ATD-4-4288 • Bblid: 760706
Atdid
9544
Atd Number
ATD-4-4288
Bblid
760706
Inspectionid
333628
Inspect Date
2019-07-18T00:00:00.000
Atdissuedate
2022-03-10T15:37:04.000
Cb
13
House Num
233-56
Onstname
87TH AVE.
Atddismissed
No
2541
Atdid: 2541 • Atd Number: ATD-3-1684 • Bblid: 366834
Atdid
2541
Atd Number
ATD-3-1684
Bblid
366834
Violationid
241460
Atdissuedate
2020-07-20T00:00:00.000
Cb
16
House Num
603
Onstname
OSBORN STREET
Atddismissed
Yes
Atddismissedon
2024-03-19T09:55:33.000
18181
Atdid: 18181 • Atd Number: ATD-1-390 • Bblid: 65041
Atdid
18181
Atd Number
ATD-1-390
Bblid
65041
Inspectionid
403059
Inspect Date
2025-07-23T00:00:00.000
Atdissuedate
2025-07-23T15:12:27.000
Cb
7
House Num
25
Onstname
W. 69TH ST.
Atddismissed
No
10468
Atdid: 10468 • Atd Number: ATD-3-3942 • Bblid: 437889
Atdid
10468
Atd Number
ATD-3-3942
Bblid
437889
Inspectionid
339609
Inspect Date
2022-07-06T00:00:00.000
Atdissuedate
2022-07-14T13:54:28.000
Cb
12
House Num
1440
Onstname
60TH ST.
Atddismissed
No
10084
Atdid: 10084 • Atd Number: ATD-3-3704 • Bblid: 407399
Atdid
10084
Atd Number
ATD-3-3704
Bblid
407399
Inspectionid
336358
Inspect Date
2022-05-11T00:00:00.000
Atdissuedate
2022-05-11T12:42:40.000
Cb
9
House Num
230
Onstname
MIDWOOD ST.
Atddismissed
No
8516
Atdid: 8516 • Atd Number: ATD-3-3112 • Bblid: 268462
Atdid
8516
Atd Number
ATD-3-3112
Bblid
268462
Inspectionid
329926
Inspect Date
2021-11-23T00:00:00.000
Atdissuedate
2021-11-24T10:49:12.000
Cb
7
House Num
545
Onstname
53RD ST.
Atddismissed
No
13111
Atdid: 13111 • Atd Number: ATD-2-1208 • Bblid: 178040
Atdid
13111
Atd Number
ATD-2-1208
Bblid
178040
Inspectionid
361410
Inspect Date
2023-06-01T00:00:00.000
Atdissuedate
2023-08-03T11:52:46.000
Cb
9
House Num
1947
Onstname
ELLIS AVE.
Atddismissed
No
16285
Atdid: 16285 • Atd Number: ATD-4-6397 • Bblid: 656034
Atdid
16285
Atd Number
ATD-4-6397
Bblid
656034
Violationid
291785
Reinspectionid
37638
Inspect Date
2024-10-25T09:28:31.000
Atdissuedate
2024-10-25T09:28:31.000
Cb
6
House Num
67-18
Onstname
GROTON STREET
Atddismissed
No
9860
Atdid: 9860 • Atd Number: ATD-4-4469 • Bblid: 654802
Atdid
9860
Atd Number
ATD-4-4469
Bblid
654802
Inspectionid
334873
Inspect Date
2022-04-07T00:00:00.000
Atdissuedate
2022-04-14T12:20:22.000
Cb
6
House Num
63-39
Onstname
DIETERLE CRES
Atddismissed
No
11128
Atdid: 11128 • Atd Number: ATD-3-4464 • Bblid: 406182
Atdid
11128
Atd Number
ATD-3-4464
Bblid
406182
Inspectionid
345468
Inspect Date
2022-09-30T00:00:00.000
Atdissuedate
2022-10-11T10:04:01.000
Cb
17
House Num
863
Onstname
E. 34TH ST.
Atddismissed
No
16956
Atdid: 16956 • Atd Number: ATD-3-6649 • Bblid: 430358
Atdid
16956
Atd Number
ATD-3-6649
Bblid
430358
Inspectionid
391528
Inspect Date
2025-03-12T00:00:00.000
Atdissuedate
2025-03-18T09:35:08.000
Cb
12
House Num
1015
Onstname
41ST ST.
Atddismissed
No
14294
Atdid: 14294 • Atd Number: ATD-4-5959 • Bblid: 626498
Atdid
14294
Atd Number
ATD-4-5959
Bblid
626498
Inspectionid
375534
Inspect Date
2024-04-17T00:00:00.000
Atdissuedate
2024-04-17T12:08:20.000
Cb
4
House Num
111-69
Onstname
42ND AVE.
Atddismissed
No
16598
Atdid: 16598 • Atd Number: ATD-3-6509 • Bblid: 406491
Atdid
16598
Atd Number
ATD-3-6509
Bblid
406491
Violationid
297868
Reinspectionid
37703
Inspect Date
2024-12-23T11:54:42.000
Atdissuedate
2024-12-23T11:54:42.000
Cb
17
House Num
884
Onstname
EAST 37 STREET
Atddismissed
No
9345
Atdid: 9345 • Atd Number: ATD-3-3442 • Bblid: 486455
Atdid
9345
Atd Number
ATD-3-3442
Bblid
486455
Inspectionid
333068
Inspect Date
2021-03-20T00:00:00.000
Atdissuedate
2022-03-02T17:03:07.000
Cb
15
House Num
1958
Onstname
STUART ST.
Atddismissed
No
11371
Atdid: 11371 • Atd Number: ATD-1-233 • Bblid: 75445
Atdid
11371
Atd Number
ATD-1-233
Bblid
75445
Inspectionid
347913
Inspect Date
2022-11-09T00:00:00.000
Atdissuedate
2022-11-09T14:51:38.000
Cb
7
House Num
137
Onstname
W. 87TH ST.
Atddismissed
No
11488
Atdid: 11488 • Atd Number: ATD-4-4903 • Bblid: 760453
Atdid
11488
Atd Number
ATD-4-4903
Bblid
760453
Inspectionid
349111
Inspect Date
2022-12-09T00:00:00.000
Atdissuedate
2022-12-09T08:47:20.000
Cb
13
House Num
233-04
Onstname
SEWARD AVE.
Atddismissed
No
15098
Atdid: 15098 • Atd Number: ATD-4-6297 • Bblid: 598403
Atdid
15098
Atd Number
ATD-4-6297
Bblid
598403
Inspectionid
382176
Inspect Date
2024-09-19T00:00:00.000
Atdissuedate
2024-09-23T13:08:49.000
Cb
3
House Num
32-36
Onstname
74TH ST.
Atddismissed
No
16477
Atdid: 16477 • Atd Number: ATD-2-1326 • Bblid: 244886
Atdid
16477
Atd Number
ATD-2-1326
Bblid
244886
Inspectionid
385735
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2024-12-04T09:24:18.000
Cb
8
House Num
5119
Onstname
POST RD.
Atddismissed
No
16324
Atdid: 16324 • Atd Number: ATD-1-323 • Bblid: 105881
Atdid
16324
Atd Number
ATD-1-323
Bblid
105881
Inspectionid
384643
Inspect Date
2024-10-28T00:00:00.000
Atdissuedate
2024-11-01T07:47:17.000
Cb
8
House Num
138
Onstname
E. 95TH ST.
Atddismissed
No
17543
Atdid: 17543 • Atd Number: ATD-4-6855 • Bblid: 871699
Atdid
17543
Atd Number
ATD-4-6855
Bblid
871699
Inspectionid
396299
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-06T09:59:06.000
Cb
12
House Num
117-70
Onstname
MARSDEN ST.
Atddismissed
No
12808
Atdid: 12808 • Atd Number: ATD-3-5141 • Bblid: 510071
Atdid
12808
Atd Number
ATD-3-5141
Bblid
510071
Inspectionid
359752
Inspect Date
2023-06-21T00:00:00.000
Atdissuedate
2023-07-10T17:11:49.000
Cb
15
House Num
2452
Onstname
E. 26TH ST.
Atddismissed
No
11450
Atdid: 11450 • Atd Number: ATD-3-4665 • Bblid: 254297
Atdid
11450
Atd Number
ATD-3-4665
Bblid
254297
Inspectionid
348581
Inspect Date
2022-11-22T00:00:00.000
Atdissuedate
2022-11-23T16:49:21.000
Cb
6
House Num
89
Onstname
BALTIC ST.
Atddismissed
No
16612
Atdid: 16612 • Atd Number: ATD-1-342 • Bblid: 105907
Atdid
16612
Atd Number
ATD-1-342
Bblid
105907
Inspectionid
387261
Inspect Date
2024-12-20T00:00:00.000
Atdissuedate
2024-12-30T08:04:39.000
Cb
8
House Num
125
Onstname
E. 94TH ST.
Atddismissed
No
17138
Atdid: 17138 • Atd Number: ATD-3-6778 • Bblid: 298117
Atdid
17138
Atd Number
ATD-3-6778
Bblid
298117
Inspectionid
392597
Inspect Date
2025-03-25T00:00:00.000
Atdissuedate
2025-03-31T09:10:37.000
Cb
9
House Num
1593
Onstname
UNION ST.
Atddismissed
No
11221
Atdid: 11221 • Atd Number: ATD-4-4856 • Bblid: 711891
Atdid
11221
Atd Number
ATD-4-4856
Bblid
711891
Inspectionid
346572
Inspect Date
2022-10-20T00:00:00.000
Atdissuedate
2022-10-20T14:19:23.000
Cb
11
House Num
42-24
Onstname
193RD ST.
Atddismissed
No
10657
Atdid: 10657 • Atd Number: ATD-3-4055 • Bblid: 534255
Atdid
10657
Atd Number
ATD-3-4055
Bblid
534255
Inspectionid
341637
Inspect Date
2022-08-17T00:00:00.000
Atdissuedate
2022-08-17T15:57:24.000
Cb
18
House Num
8020
Onstname
AVENUE J.
Atddismissed
No
18507
Atdid: 18507 • Atd Number: ATD-3-7288 • Bblid: 489314
Atdid
18507
Atd Number
ATD-3-7288
Bblid
489314
Inspectionid
405325
Inspect Date
2025-09-06T00:00:00.000
Atdissuedate
2025-09-06T11:33:09.000
Cb
13
House Num
112
Onstname
BAY 49TH ST.
Atddismissed
No
18093
Atdid: 18093 • Atd Number: ATD-1-387 • Bblid: 65031
Atdid
18093
Atd Number
ATD-1-387
Bblid
65031
Inspectionid
402378
Inspect Date
2025-07-11T00:00:00.000
Atdissuedate
2025-07-14T16:13:23.000
Cb
7
House Num
37
Onstname
W. 69TH ST.
Atddismissed
No
18275
Atdid: 18275 • Atd Number: ATD-3-7212 • Bblid: 515616
Atdid
18275
Atd Number
ATD-3-7212
Bblid
515616
Inspectionid
403724
Inspect Date
2025-08-04T00:00:00.000
Atdissuedate
2025-08-06T14:01:10.000
Cb
18
House Num
1191
Onstname
E. 34TH ST.
Atddismissed
No
18000
Atdid: 18000 • Atd Number: ATD-4-7108 • Bblid: 629946
Atdid
18000
Atd Number
ATD-4-7108
Bblid
629946
Inspectionid
401654
Inspect Date
2025-06-20T00:00:00.000
Atdissuedate
2025-06-30T11:17:37.000
Cb
6
House Num
69-03
Onstname
112 STREET
Atddismissed
No
8225
Atdid: 8225 • Atd Number: ATD-3-2935 • Bblid: 313981
Atdid
8225
Atd Number
ATD-3-2935
Bblid
313981
Inspectionid
323166
Inspect Date
2021-06-16T00:00:00.000
Atdissuedate
2021-06-16T00:00:00.000
Cb
3
House Num
7
Onstname
HART ST.
Atddismissed
Yes
Atddismissedon
2024-10-04T12:07:26.000
11814
Atdid: 11814 • Atd Number: ATD-2-986 • Bblid: 220704
Atdid
11814
Atd Number
ATD-2-986
Bblid
220704
Inspectionid
353235
Inspect Date
2023-03-16T00:00:00.000
Atdissuedate
2023-03-20T09:55:55.000
Cb
12
House Num
1015
Onstname
E. 223RD ST.
Atddismissed
No
9796
Atdid: 9796 • Atd Number: ATD-3-3595 • Bblid: 466397
Atdid
9796
Atd Number
ATD-3-3595
Bblid
466397
Inspectionid
334435
Inspect Date
2019-06-28T00:00:00.000
Atdissuedate
2022-03-31T10:44:11.000
Cb
11
House Num
8737
Onstname
14TH AVE.
Atddismissed
No
17081
Atdid: 17081 • Atd Number: ATD-3-6732 • Bblid: 287612
Atdid
17081
Atd Number
ATD-3-6732
Bblid
287612
Inspectionid
392454
Inspect Date
2023-03-09T00:00:00.000
Atdissuedate
2025-03-27T15:01:00.000
Cb
8
House Num
574
Onstname
PARK PL.
Atddismissed
Yes
Atddismissedon
2025-05-23T11:53:54.000
11786
Atdid: 11786 • Atd Number: ATD-4-5046 • Bblid: 795664
Atdid
11786
Atd Number
ATD-4-5046
Bblid
795664
Inspectionid
352844
Inspect Date
2023-02-22T00:00:00.000
Atdissuedate
2023-03-13T12:35:27.000
Cb
9
House Num
101-21
Onstname
114TH ST.
Atddismissed
No
18043
Atdid: 18043 • Atd Number: ATD-3-7106 • Bblid: 502783
Atdid
18043
Atd Number
ATD-3-7106
Bblid
502783
Inspectionid
402007
Inspect Date
2025-07-10T00:00:00.000
Atdissuedate
2025-07-10T10:46:38.000
Cb
15
House Num
1920
Onstname
E. 17TH ST.
Atddismissed
No
18584
Atdid: 18584 • Atd Number: ATD-3-7320 • Bblid: 509923
Atdid
18584
Atd Number
ATD-3-7320
Bblid
509923
Inspectionid
405670
Inspect Date
2025-09-05T00:00:00.000
Atdissuedate
2025-09-11T15:50:46.000
Cb
15
House Num
1914
Onstname
AVENUE X.
Atddismissed
No
16453
Atdid: 16453 • Atd Number: ATD-4-6466 • Bblid: 634462
Atdid
16453
Atd Number
ATD-4-6466
Bblid
634462
Inspectionid
385528
Inspect Date
2024-11-14T00:00:00.000
Atdissuedate
2024-12-02T11:44:26.000
Cb
5
House Num
51-20
Onstname
69TH PL.
Atddismissed
No
14304
Atdid: 14304 • Atd Number: ATD-4-5965 • Bblid: 656408
Atdid
14304
Atd Number
ATD-4-5965
Bblid
656408
Inspectionid
375757
Inspect Date
2024-04-22T00:00:00.000
Atdissuedate
2024-04-22T11:56:42.000
Cb
6
House Num
68-38
Onstname
ALDERTON ST.
Atddismissed
No
13396
Atdid: 13396 • Atd Number: ATD-3-5515 • Bblid: 477255
Atdid
13396
Atd Number
ATD-3-5515
Bblid
477255
Inspectionid
363380
Inspect Date
2023-09-09T00:00:00.000
Atdissuedate
2023-09-11T18:10:48.000
Cb
11
House Num
1782
Onstname
W. 8TH ST.
Atddismissed
No
9595
Atdid: 9595 • Atd Number: ATD-4-4302 • Bblid: 770582
Atdid
9595
Atd Number
ATD-4-4302
Bblid
770582
Inspectionid
333735
Inspect Date
2019-06-28T00:00:00.000
Atdissuedate
2022-03-14T15:59:46.000
Cb
13
House Num
84-30
Onstname
LITTLE NECK PKWY.
Atddismissed
No
12159
Atdid: 12159 • Atd Number: ATD-3-4990 • Bblid: 258021
Atdid
12159
Atd Number
ATD-3-4990
Bblid
258021
Inspectionid
356702
Inspect Date
2023-05-05T00:00:00.000
Atdissuedate
2023-05-05T14:07:46.000
Cb
2
House Num
181
Onstname
WYCKOFF ST.
Atddismissed
No
12574
Atdid: 12574 • Atd Number: ATD-2-1151 • Bblid: 143499
Atdid
12574
Atd Number
ATD-2-1151
Bblid
143499
Inspectionid
358575
Inspect Date
2023-06-15T00:00:00.000
Atdissuedate
2023-06-15T09:52:55.000
Cb
4
House Num
1107
Onstname
MORRIS AVENUE
Atddismissed
No
17681
Atdid: 17681 • Atd Number: ATD-4-6937 • Bblid: 706537
Atdid
17681
Atd Number
ATD-4-6937
Bblid
706537
Inspectionid
397713
Inspect Date
2025-05-17T00:00:00.000
Atdissuedate
2025-05-20T09:30:19.000
Cb
7
House Num
142-04
Onstname
56TH RD.
Atddismissed
No
17757
Atdid: 17757 • Atd Number: ATD-4-6987 • Bblid: 651187
Atdid
17757
Atd Number
ATD-4-6987
Bblid
651187
Inspectionid
398745
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-05-28T16:19:16.000
Cb
5
House Num
64-19
Onstname
73RD PL.
Atddismissed
No
17816
Atdid: 17816 • Atd Number: ATD-4-7028 • Bblid: 676311
Atdid
17816
Atd Number
ATD-4-7028
Bblid
676311
Inspectionid
399334
Inspect Date
2025-06-04T00:00:00.000
Atdissuedate
2025-06-06T15:08:58.000
Cb
5
House Num
77-24
Onstname
76TH ST.
Atddismissed
No
10339
Atdid: 10339 • Atd Number: ATD-4-4688 • Bblid: 785502
Atdid
10339
Atd Number
ATD-4-4688
Bblid
785502
Inspectionid
338328
Inspect Date
2022-06-30T00:00:00.000
Atdissuedate
2022-06-30T09:24:20.000
Cb
10
House Num
103-12
Onstname
92ND ST.
Atddismissed
No