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
9457
Atdid: 9457 • Atd Number: ATD-4-4239 • Bblid: 605633
Atdid
9457
Atd Number
ATD-4-4239
Bblid
605633
Inspectionid
333291
Inspect Date
2020-05-22T00:00:00.000
Atdissuedate
2022-03-04T17:47:10.000
Cb
3
House Num
26-46
Onstname
96TH ST.
Atddismissed
No
18101
Atdid: 18101 • Atd Number: ATD-4-7154 • Bblid: 820997
Atdid
18101
Atd Number
ATD-4-7154
Bblid
820997
Inspectionid
402481
Inspect Date
2025-07-16T00:00:00.000
Atdissuedate
2025-07-16T11:33:41.000
Cb
12
House Num
187-56
Onstname
QUENCER RD.
Atddismissed
No
11630
Atdid: 11630 • Atd Number: ATD-3-4721 • Bblid: 506061
Atdid
11630
Atd Number
ATD-3-4721
Bblid
506061
Inspectionid
350869
Inspect Date
2023-01-28T00:00:00.000
Atdissuedate
2023-01-30T13:51:45.000
Cb
15
House Num
2206
Onstname
E. 21ST ST.
Atddismissed
Yes
Atddismissedon
2024-03-06T18:36:34.000
17149
Atdid: 17149 • Atd Number: ATD-2-1354 • Bblid: 140289
Atdid
17149
Atd Number
ATD-2-1354
Bblid
140289
Inspectionid
392642
Inspect Date
2025-03-19T00:00:00.000
Atdissuedate
2025-03-31T10:09:38.000
Cb
1
House Num
457
Onstname
E. 145TH ST.
Atddismissed
No
17729
Atdid: 17729 • Atd Number: ATD-4-6976 • Bblid: 726880
Atdid
17729
Atd Number
ATD-4-6976
Bblid
726880
Inspectionid
398332
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-05-23T13:27:22.000
Cb
11
House Num
32-36
Onstname
BELL BLVD.
Atddismissed
No
18246
Atdid: 18246 • Atd Number: ATD-4-7201 • Bblid: 856047
Atdid
18246
Atd Number
ATD-4-7201
Bblid
856047
Inspectionid
403581
Inspect Date
2025-08-04T00:00:00.000
Atdissuedate
2025-08-04T16:47:52.000
Cb
10
House Num
133-39
Onstname
114TH PL.
Atddismissed
No
10268
Atdid: 10268 • Atd Number: ATD-4-4647 • Bblid: 592635
Atdid
10268
Atd Number
ATD-4-4647
Bblid
592635
Inspectionid
337570
Inspect Date
2022-05-27T00:00:00.000
Atdissuedate
2022-06-10T13:19:14.000
Cb
1
House Num
21-29
Onstname
71ST ST.
Atddismissed
No
9196
Atdid: 9196 • Atd Number: ATD-3-3352 • Bblid: 434751
Atdid
9196
Atd Number
ATD-3-3352
Bblid
434751
Inspectionid
332854
Inspect Date
2020-11-09T00:00:00.000
Atdissuedate
2022-02-28T17:33:09.000
Cb
12
House Num
1121
Onstname
54TH ST.
Atddismissed
No
16188
Atdid: 16188 • Atd Number: ATD-4-6352 • Bblid: 819284
Atdid
16188
Atd Number
ATD-4-6352
Bblid
819284
Inspectionid
383774
Inspect Date
2024-09-19T00:00:00.000
Atdissuedate
2024-10-05T14:41:32.000
Cb
12
House Num
112-14
Onstname
178TH ST.
Atddismissed
No
10662
Atdid: 10662 • Atd Number: ATD-3-4060 • Bblid: 554910
Atdid
10662
Atd Number
ATD-3-4060
Bblid
554910
Inspectionid
341692
Inspect Date
2022-08-18T00:00:00.000
Atdissuedate
2022-08-18T11:16:23.000
Cb
18
House Num
2780
Onstname
E. 66TH ST.
Atddismissed
No
13550
Atdid: 13550 • Atd Number: ATD-4-5589 • Bblid: 724883
Atdid
13550
Atd Number
ATD-4-5589
Bblid
724883
Inspectionid
364986
Inspect Date
2023-10-06T00:00:00.000
Atdissuedate
2023-10-06T10:29:27.000
Cb
11
House Num
26-23
Onstname
CLEARVIEW EXPY.
Atddismissed
No
9999
Atdid: 9999 • Atd Number: ATD-4-4551 • Bblid: 654481
Atdid
9999
Atd Number
ATD-4-4551
Bblid
654481
Inspectionid
335829
Inspect Date
2022-04-19T00:00:00.000
Atdissuedate
2022-04-29T14:05:34.000
Cb
6
House Num
87-05
Onstname
65TH DR.
Atddismissed
No
1418
Atdid: 1418 • Atd Number: ATD-3-561 • Bblid: 315542
Atdid
1418
Atd Number
ATD-3-561
Bblid
315542
Violationid
53812
Atdissuedate
2020-08-12T00:00:00.000
Cb
3
House Num
282
Onstname
CLIFTON PLACE
Atddismissed
Yes
Atddismissedon
2021-11-15T09:55:29.000
18034
Atdid: 18034 • Atd Number: ATD-4-7119 • Bblid: 664018
Atdid
18034
Atd Number
ATD-4-7119
Bblid
664018
Inspectionid
401964
Inspect Date
2025-07-09T00:00:00.000
Atdissuedate
2025-07-09T08:06:03.000
Cb
5
House Num
1710
Onstname
HART ST.
Atddismissed
No
9406
Atdid: 9406 • Atd Number: ATD-3-3496 • Bblid: 548939
Atdid
9406
Atd Number
ATD-3-3496
Bblid
548939
Inspectionid
333165
Inspect Date
2021-01-05T00:00:00.000
Atdissuedate
2022-03-03T17:34:19.000
Cb
18
House Num
2037
Onstname
E. 68TH ST.
Atddismissed
No
17868
Atdid: 17868 • Atd Number: ATD-4-7055 • Bblid: 768513
Atdid
17868
Atd Number
ATD-4-7055
Bblid
768513
Inspectionid
400229
Inspect Date
2025-06-11T00:00:00.000
Atdissuedate
2025-06-13T08:41:12.000
Cb
11
House Num
57-43
Onstname
HEWLETT ST.
Atddismissed
No
9012
Atdid: 9012 • Atd Number: ATD-3-3294 • Bblid: 302071
Atdid
9012
Atd Number
ATD-3-3294
Bblid
302071
Inspectionid
332354
Inspect Date
2019-08-20T00:00:00.000
Atdissuedate
2022-02-10T09:44:28.000
Cb
3
House Num
597
Onstname
DECATUR ST.
Atddismissed
No
9283
Atdid: 9283 • Atd Number: ATD-2-884 • Bblid: 242290
Atdid
9283
Atd Number
ATD-2-884
Bblid
242290
Inspectionid
332989
Inspect Date
2021-01-15T00:00:00.000
Atdissuedate
2022-03-02T08:16:46.000
Cb
10
House Num
467
Onstname
KING AVE.
Atddismissed
No
14978
Atdid: 14978 • Atd Number: ATD-4-6257 • Bblid: 623152
Atdid
14978
Atd Number
ATD-4-6257
Bblid
623152
Inspectionid
381214
Inspect Date
2024-08-26T00:00:00.000
Atdissuedate
2024-08-28T13:16:21.000
Cb
4
House Num
99-16
Onstname
ALSTYNE AVE.
Atddismissed
No
12244
Atdid: 12244 • Atd Number: ATD-2-1061 • Bblid: 144146
Atdid
12244
Atd Number
ATD-2-1061
Bblid
144146
Inspectionid
357205
Inspect Date
2023-05-17T00:00:00.000
Atdissuedate
2023-05-17T11:28:50.000
Cb
4
House Num
1240
Onstname
JEROME AVE.
Atddismissed
No
11769
Atdid: 11769 • Atd Number: ATD-2-980 • Bblid: 213871
Atdid
11769
Atd Number
ATD-2-980
Bblid
213871
Inspectionid
352642
Inspect Date
2023-03-08T00:00:00.000
Atdissuedate
2023-03-13T09:06:10.000
Cb
12
House Num
3809
Onstname
PAULDING AVE.
Atddismissed
No
14104
Atdid: 14104 • Atd Number: ATD-3-5787 • Bblid: 518397
Atdid
14104
Atd Number
ATD-3-5787
Bblid
518397
Inspectionid
373173
Inspect Date
2024-03-08T00:00:00.000
Atdissuedate
2024-03-14T11:29:48.000
Cb
14
House Num
1323
Onstname
E. 29TH ST.
Atddismissed
No
9824
Atdid: 9824 • Atd Number: ATD-4-4445 • Bblid: 789746
Atdid
9824
Atd Number
ATD-4-4445
Bblid
789746
Inspectionid
334568
Inspect Date
2022-03-24T00:00:00.000
Atdissuedate
2022-04-04T14:29:56.000
Cb
9
House Num
121-20
Onstname
HILLSIDE AVE.
Atddismissed
No
17313
Atdid: 17313 • Atd Number: ATD-3-6851 • Bblid: 301843
Atdid
17313
Atd Number
ATD-3-6851
Bblid
301843
Inspectionid
394400
Inspect Date
2025-03-28T00:00:00.000
Atdissuedate
2025-04-14T07:46:46.000
Cb
3
House Num
598
Onstname
MACDONOUGH ST.
Atddismissed
No
8728
Atdid: 8728 • Atd Number: ATD-4-3924 • Bblid: 784808
Atdid
8728
Atd Number
ATD-4-3924
Bblid
784808
Inspectionid
331066
Inspect Date
2021-12-28T00:00:00.000
Atdissuedate
2021-12-28T10:34:22.000
Cb
9
House Num
81-25
Onstname
102ND RD.
Atddismissed
No
12293
Atdid: 12293 • Atd Number: ATD-2-1090 • Bblid: 144158
Atdid
12293
Atd Number
ATD-2-1090
Bblid
144158
Inspectionid
357342
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T11:47:28.000
Cb
4
House Num
41
Onstname
E. 167TH ST.
Atddismissed
No
11963
Atdid: 11963 • Atd Number: ATD-4-5090 • Bblid: 875525
Atdid
11963
Atd Number
ATD-4-5090
Bblid
875525
Inspectionid
354352
Inspect Date
2023-03-03T00:00:00.000
Atdissuedate
2023-04-03T12:07:45.000
Cb
12
House Num
175-14
Onstname
139TH RD.
Atddismissed
No
16416
Atdid: 16416 • Atd Number: ATD-4-6444 • Bblid: 658326
Atdid
16416
Atd Number
ATD-4-6444
Bblid
658326
Inspectionid
385248
Inspect Date
2024-11-07T00:00:00.000
Atdissuedate
2024-11-20T12:39:47.000
Cb
6
House Num
69-11
Onstname
HARROW ST.
Atddismissed
No
12975
Atdid: 12975 • Atd Number: ATD-4-5462 • Bblid: 734318
Atdid
12975
Atd Number
ATD-4-5462
Bblid
734318
Inspectionid
360634
Inspect Date
2023-06-23T00:00:00.000
Atdissuedate
2023-07-25T11:47:21.000
Cb
8
House Num
144-11
Onstname
68TH AVE.
Atddismissed
No
14562
Atdid: 14562 • Atd Number: ATD-4-6086 • Bblid: 782385
Atdid
14562
Atd Number
ATD-4-6086
Bblid
782385
Inspectionid
378193
Inspect Date
2024-05-23T00:00:00.000
Atdissuedate
2024-06-06T11:10:01.000
Cb
9
House Num
78-09
Onstname
95TH AVE.
Atddismissed
No
11560
Atdid: 11560 • Atd Number: ATD-1-277 • Bblid: 116666
Atdid
11560
Atd Number
ATD-1-277
Bblid
116666
Inspectionid
349804
Inspect Date
2022-11-11T00:00:00.000
Atdissuedate
2022-12-29T10:21:12.000
Cb
10
House Num
70
Onstname
W. 119TH ST.
Atddismissed
No
13605
Atdid: 13605 • Atd Number: ATD-4-5604 • Bblid: 896844
Atdid
13605
Atd Number
ATD-4-5604
Bblid
896844
Inspectionid
365691
Inspect Date
2023-10-05T00:00:00.000
Atdissuedate
2023-10-23T13:42:46.000
Cb
13
House Num
255-27
Onstname
148TH DR.
Atddismissed
No
18299
Atdid: 18299 • Atd Number: ATD-3-7221 • Bblid: 509981
Atdid
18299
Atd Number
ATD-3-7221
Bblid
509981
Inspectionid
404002
Inspect Date
2025-08-09T00:00:00.000
Atdissuedate
2025-08-11T16:36:06.000
Cb
15
House Num
2465
Onstname
E. 23RD ST.
Atddismissed
No
11214
Atdid: 11214 • Atd Number: ATD-4-4851 • Bblid: 653763
Atdid
11214
Atd Number
ATD-4-4851
Bblid
653763
Inspectionid
346460
Inspect Date
2022-10-13T00:00:00.000
Atdissuedate
2022-10-19T11:43:51.000
Cb
6
House Num
63-33
Onstname
HARING ST.
Atddismissed
No
12392
Atdid: 12392 • Atd Number: ATD-4-5258 • Bblid: 604366
Atdid
12392
Atd Number
ATD-4-5258
Bblid
604366
Inspectionid
357549
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:50:07.000
Cb
2
House Num
7217A
Onstname
QUEENS BOULEVARD
Atddismissed
No
9276
Atdid: 9276 • Atd Number: ATD-2-878 • Bblid: 232032
Atdid
9276
Atd Number
ATD-2-878
Bblid
232032
Inspectionid
332982
Inspect Date
2020-11-17T00:00:00.000
Atdissuedate
2022-03-01T17:52:17.000
Cb
10
House Num
2867
Onstname
ZULETTE AVE.
Atddismissed
No
6057
Atdid: 6057 • Atd Number: ATD-4-2418 • Bblid: 907377
Atdid
6057
Atd Number
ATD-4-2418
Bblid
907377
Violationid
237450
Atdissuedate
2020-06-05T00:00:00.000
Cb
14
House Num
9-20
Onstname
SEAGIRT BOULEVARD
Atddismissed
No
8996
Atdid: 8996 • Atd Number: ATD-4-4087 • Bblid: 686305
Atdid
8996
Atd Number
ATD-4-4087
Bblid
686305
Inspectionid
332320
Inspect Date
2019-08-03T00:00:00.000
Atdissuedate
2022-02-08T14:01:12.000
Cb
7
House Num
16
Onstname
CENTER DR.
Atddismissed
No
11992
Atdid: 11992 • Atd Number: ATD-4-5111 • Bblid: 720102
Atdid
11992
Atd Number
ATD-4-5111
Bblid
720102
Inspectionid
354522
Inspect Date
2023-03-15T00:00:00.000
Atdissuedate
2023-04-06T11:41:12.000
Cb
11
House Num
58-36
Onstname
188TH ST.
Atddismissed
No
16295
Atdid: 16295 • Atd Number: ATD-3-6373 • Bblid: 279073
Atdid
16295
Atd Number
ATD-3-6373
Bblid
279073
Inspectionid
384458
Inspect Date
2024-09-27T00:00:00.000
Atdissuedate
2024-10-28T10:38:15.000
Cb
6
House Num
359
Onstname
11TH ST.
Atddismissed
No
14698
Atdid: 14698 • Atd Number: ATD-3-6106 • Bblid: 476403
Atdid
14698
Atd Number
ATD-3-6106
Bblid
476403
Inspectionid
379083
Inspect Date
2024-06-29T00:00:00.000
Atdissuedate
2024-07-08T10:14:59.000
Cb
11
House Num
1666
Onstname
W. 1ST ST.
Atddismissed
No
17794
Atdid: 17794 • Atd Number: ATD-4-7014 • Bblid: 756169
Atdid
17794
Atd Number
ATD-4-7014
Bblid
756169
Inspectionid
399149
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-05T08:55:03.000
Cb
11
House Num
64-22
Onstname
215TH ST.
Atddismissed
No
17570
Atdid: 17570 • Atd Number: ATD-3-6963 • Bblid: 332293
Atdid
17570
Atd Number
ATD-3-6963
Bblid
332293
Violationid
300112
Reinspectionid
39189
Inspect Date
2025-05-08T12:56:39.000
Atdissuedate
2025-05-08T12:56:39.000
Cb
1
House Num
214
Onstname
HOOPER STREET
Atddismissed
No
14076
Atdid: 14076 • Atd Number: ATD-3-5770 • Bblid: 522248
Atdid
14076
Atd Number
ATD-3-5770
Bblid
522248
Violationid
289846
Reinspectionid
36129
Inspect Date
2024-03-07T10:44:51.000
Atdissuedate
2024-03-07T10:44:51.000
Cb
18
House Num
1224
Onstname
EAST 46 STREET
Atddismissed
No
259
Atdid: 259 • Atd Number: ATD-2-126 • Bblid: 223367
Atdid
259
Atd Number
ATD-2-126
Bblid
223367
Violationid
208944
Atdissuedate
2019-10-26T00:00:00.000
Cb
12
House Num
4039
Onstname
WICKHAM AVENUE
Atddismissed
Yes
Atddismissedon
2022-05-24T09:17:42.000
12840
Atdid: 12840 • Atd Number: ATD-4-5437 • Bblid: 645287
Atdid
12840
Atd Number
ATD-4-5437
Bblid
645287
Inspectionid
359940
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-07-13T12:13:08.000
Cb
4
House Num
86-27
Onstname
57TH RD.
Atddismissed
No
9859
Atdid: 9859 • Atd Number: ATD-4-4468 • Bblid: 654748
Atdid
9859
Atd Number
ATD-4-4468
Bblid
654748
Inspectionid
334872
Inspect Date
2022-04-05T00:00:00.000
Atdissuedate
2022-04-14T12:11:11.000
Cb
6
House Num
63-55
Onstname
ELLWELL CRES
Atddismissed
No
10865
Atdid: 10865 • Atd Number: ATD-3-4236 • Bblid: 359525
Atdid
10865
Atd Number
ATD-3-4236
Bblid
359525
Inspectionid
343494
Inspect Date
2022-08-25T00:00:00.000
Atdissuedate
2022-09-12T12:25:13.000
Cb
4
House Num
124
Onstname
CORNELIA ST.
Atddismissed
No
8804
Atdid: 8804 • Atd Number: ATD-4-3980 • Bblid: 782967
Atdid
8804
Atd Number
ATD-4-3980
Bblid
782967
Inspectionid
331442
Inspect Date
2022-01-05T00:00:00.000
Atdissuedate
2022-01-05T12:14:26.000
Cb
9
House Num
95-18
Onstname
88TH ST.
Atddismissed
No
16924
Atdid: 16924 • Atd Number: ATD-4-6651 • Bblid: 643573
Atdid
16924
Atd Number
ATD-4-6651
Bblid
643573
Inspectionid
391057
Inspect Date
2025-03-07T00:00:00.000
Atdissuedate
2025-03-13T15:11:00.000
Cb
5
House Num
59-62
Onstname
69TH LN.
Atddismissed
No
NYC Data AI • Public-data exploration interface