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
18238
Atdid: 18238 • Atd Number: ATD-2-1438 • Bblid: 236405
Atdid
18238
Atd Number
ATD-2-1438
Bblid
236405
Inspectionid
403539
Inspect Date
2025-06-27T00:00:00.000
Atdissuedate
2025-08-04T11:57:20.000
Cb
10
House Num
601
Onstname
VINCENT AVE.
Atddismissed
No
9580
Atdid: 9580 • Atd Number: ATD-5-631 • Bblid: 1047807
Atdid
9580
Atd Number
ATD-5-631
Bblid
1047807
Inspectionid
333692
Inspect Date
1998-08-05T00:00:00.000
Atdissuedate
2022-03-11T17:03:45.000
Cb
3
House Num
21
Onstname
CLAYPIT RD.
Atddismissed
No
11804
Atdid: 11804 • Atd Number: ATD-3-4799 • Bblid: 296809
Atdid
11804
Atd Number
ATD-3-4799
Bblid
296809
Inspectionid
353141
Inspect Date
2023-03-17T00:00:00.000
Atdissuedate
2023-03-17T12:05:25.000
Cb
8
House Num
1397
Onstname
STERLING PL.
Atddismissed
No
2484
Atdid: 2484 • Atd Number: ATD-3-1627 • Bblid: 253435
Atdid
2484
Atd Number
ATD-3-1627
Bblid
253435
Violationid
175686
Atdissuedate
2020-08-20T00:00:00.000
Cb
2
House Num
192
Onstname
STATE STREET
Atddismissed
Yes
Atddismissedon
2022-08-12T11:21:23.000
10250
Atdid: 10250 • Atd Number: ATD-4-4639 • Bblid: 845830
Atdid
10250
Atd Number
ATD-4-4639
Bblid
845830
Inspectionid
337457
Inspect Date
2022-06-08T00:00:00.000
Atdissuedate
2022-06-08T11:12:00.000
Cb
10
House Num
132-34
Onstname
87TH ST.
Atddismissed
No
12206
Atdid: 12206 • Atd Number: ATD-2-1055 • Bblid: 242437
Atdid
12206
Atd Number
ATD-2-1055
Bblid
242437
Violationid
193948
Inspectionid
356856
Inspect Date
2023-05-10T13:33:02.000
Atdissuedate
2023-05-10T13:33:02.000
Cb
10
House Num
700
Onstname
MINNIEFORD AVENUE
Atddismissed
No
17243
Atdid: 17243 • Atd Number: ATD-3-6820 • Bblid: 253810
Atdid
17243
Atd Number
ATD-3-6820
Bblid
253810
Inspectionid
393154
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-04-04T10:52:39.000
Cb
6
House Num
129
Onstname
PACIFIC STREET
Atddismissed
No
8571
Atdid: 8571 • Atd Number: ATD-3-3140 • Bblid: 420037
Atdid
8571
Atd Number
ATD-3-3140
Bblid
420037
Inspectionid
330502
Inspect Date
2021-12-08T00:00:00.000
Atdissuedate
2021-12-08T17:12:50.000
Cb
12
House Num
558
Onstname
E. 5TH ST.
Atddismissed
No
18576
Atdid: 18576 • Atd Number: ATD-5-1027 • Bblid: 1028646
Atdid
18576
Atd Number
ATD-5-1027
Bblid
1028646
Inspectionid
405648
Inspect Date
2025-08-20T00:00:00.000
Atdissuedate
2025-09-11T11:50:43.000
Cb
3
House Num
30
Onstname
LUDLOW ST.
Atddismissed
No
9630
Atdid: 9630 • Atd Number: ATD-4-4334 • Bblid: 880618
Atdid
9630
Atd Number
ATD-4-4334
Bblid
880618
Inspectionid
333799
Inspect Date
2021-04-07T00:00:00.000
Atdissuedate
2022-03-15T18:50:36.000
Cb
13
House Num
120-35
Onstname
222ND ST.
Atddismissed
No
10861
Atdid: 10861 • Atd Number: ATD-3-4232 • Bblid: 306252
Atdid
10861
Atd Number
ATD-3-4232
Bblid
306252
Inspectionid
343476
Inspect Date
2022-09-29T00:00:00.000
Atdissuedate
2022-09-12T11:36:57.000
Cb
3
House Num
435
Onstname
PULASKI ST.
Atddismissed
No
11554
Atdid: 11554 • Atd Number: ATD-1-275 • Bblid: 47229
Atdid
11554
Atd Number
ATD-1-275
Bblid
47229
Inspectionid
349783
Inspect Date
2022-12-28T00:00:00.000
Atdissuedate
2022-12-28T12:45:23.000
Cb
6
House Num
335
Onstname
E. 18TH ST.
Atddismissed
No
13540
Atdid: 13540 • Atd Number: ATD-4-5579 • Bblid: 856690
Atdid
13540
Atd Number
ATD-4-5579
Bblid
856690
Inspectionid
364856
Inspect Date
2023-10-03T00:00:00.000
Atdissuedate
2023-10-04T07:33:42.000
Cb
10
House Num
133-11
Onstname
122ND PL.
Atddismissed
No
13014
Atdid: 13014 • Atd Number: ATD-4-5476 • Bblid: 897546
Atdid
13014
Atd Number
ATD-4-5476
Bblid
897546
Inspectionid
360968
Inspect Date
2023-07-25T00:00:00.000
Atdissuedate
2023-07-28T09:47:09.000
Cb
13
House Num
259-06
Onstname
148TH AVE.
Atddismissed
No
10492
Atdid: 10492 • Atd Number: ATD-3-3961 • Bblid: 255623
Atdid
10492
Atd Number
ATD-3-3961
Bblid
255623
Inspectionid
339891
Inspect Date
2022-07-16T00:00:00.000
Atdissuedate
2022-07-16T15:01:07.000
Cb
6
House Num
268
Onstname
DEGRAW ST.
Atddismissed
No
18379
Atdid: 18379 • Atd Number: ATD-4-7271 • Bblid: 593341
Atdid
18379
Atd Number
ATD-4-7271
Bblid
593341
Inspectionid
404533
Inspect Date
2025-08-20T00:00:00.000
Atdissuedate
2025-08-20T12:26:11.000
Cb
1
House Num
22-52
Onstname
78TH ST.
Atddismissed
No
11577
Atdid: 11577 • Atd Number: ATD-4-4944 • Bblid: 759845
Atdid
11577
Atd Number
ATD-4-4944
Bblid
759845
Inspectionid
350081
Inspect Date
2023-01-04T00:00:00.000
Atdissuedate
2023-01-06T10:46:58.000
Cb
13
House Num
82-48
Onstname
243RD ST.
Atddismissed
No
12847
Atdid: 12847 • Atd Number: ATD-3-5152 • Bblid: 306868
Atdid
12847
Atd Number
ATD-3-5152
Bblid
306868
Inspectionid
359958
Inspect Date
2023-07-06T00:00:00.000
Atdissuedate
2023-07-13T13:54:22.000
Cb
3
House Num
203
Onstname
VAN BUREN ST.
Atddismissed
No
12229
Atdid: 12229 • Atd Number: ATD-3-5015 • Bblid: 328500
Atdid
12229
Atd Number
ATD-3-5015
Bblid
328500
Inspectionid
356961
Inspect Date
2023-05-11T00:00:00.000
Atdissuedate
2023-05-11T15:13:33.000
Cb
2
House Num
57
Onstname
S. PORTLAND AVE.
Atddismissed
No
18513
Atdid: 18513 • Atd Number: ATD-3-7293 • Bblid: 378401
Atdid
18513
Atd Number
ATD-3-7293
Bblid
378401
Inspectionid
405383
Inspect Date
2025-09-05T00:00:00.000
Atdissuedate
2025-09-08T10:12:15.000
Cb
5
House Num
630
Onstname
BARBEY ST.
Atddismissed
No
14805
Atdid: 14805 • Atd Number: ATD-3-6145 • Bblid: 458225
Atdid
14805
Atd Number
ATD-3-6145
Bblid
458225
Inspectionid
379872
Inspect Date
2024-07-25T00:00:00.000
Atdissuedate
2024-07-27T10:05:39.000
Cb
11
House Num
1529
Onstname
BAY RIDGE PKWY.
Atddismissed
No
13444
Atdid: 13444 • Atd Number: ATD-2-1239 • Bblid: 216298
Atdid
13444
Atd Number
ATD-2-1239
Bblid
216298
Inspectionid
364018
Inspect Date
2023-08-08T00:00:00.000
Atdissuedate
2023-09-21T09:59:31.000
Cb
12
House Num
3224
Onstname
SEYMOUR AVE.
Atddismissed
No
16119
Atdid: 16119 • Atd Number: ATD-4-6316 • Bblid: 759648
Atdid
16119
Atd Number
ATD-4-6316
Bblid
759648
Inspectionid
383305
Inspect Date
2024-09-25T00:00:00.000
Atdissuedate
2024-09-27T10:02:35.000
Cb
11
House Num
224-55
Onstname
77TH AVE.
Atddismissed
No
14366
Atdid: 14366 • Atd Number: ATD-3-5923 • Bblid: 266899
Atdid
14366
Atd Number
ATD-3-5923
Bblid
266899
Inspectionid
376235
Inspect Date
2024-04-25T00:00:00.000
Atdissuedate
2024-04-29T10:36:40.000
Cb
7
House Num
518
Onstname
48TH ST.
Atddismissed
No
6721
Atdid: 6721 • Atd Number: ATD-4-3082 • Bblid: 680788
Atdid
6721
Atd Number
ATD-4-3082
Bblid
680788
Violationid
252922
Atdissuedate
2020-06-19T00:00:00.000
Cb
7
House Num
11-21
Onstname
123 STREET
Atddismissed
No
11748
Atdid: 11748 • Atd Number: ATD-3-4776 • Bblid: 296952
Atdid
11748
Atd Number
ATD-3-4776
Bblid
296952
Inspectionid
352525
Inspect Date
2023-03-09T00:00:00.000
Atdissuedate
2023-03-09T11:19:52.000
Cb
8
House Num
1512
Onstname
PROSPECT PL.
Atddismissed
No
14908
Atdid: 14908 • Atd Number: ATD-4-6220 • Bblid: 777653
Atdid
14908
Atd Number
ATD-4-6220
Bblid
777653
Violationid
293131
Reinspectionid
36651
Inspect Date
2024-08-15T12:09:46.000
Atdissuedate
2024-08-15T12:09:46.000
Cb
9
House Num
84-39
Onstname
89 STREET
Atddismissed
No
12854
Atdid: 12854 • Atd Number: ATD-4-5444 • Bblid: 749704
Atdid
12854
Atd Number
ATD-4-5444
Bblid
749704
Inspectionid
359992
Inspect Date
2023-05-13T00:00:00.000
Atdissuedate
2023-07-14T12:43:21.000
Cb
8
House Num
186-05
Onstname
ABERDEEN RD.
Atddismissed
No
15053
Atdid: 15053 • Atd Number: ATD-3-6281 • Bblid: 487930
Atdid
15053
Atd Number
ATD-3-6281
Bblid
487930
Inspectionid
381899
Inspect Date
2024-09-13T00:00:00.000
Atdissuedate
2024-09-16T14:21:30.000
Cb
11
House Num
166
Onstname
BAY 40TH ST.
Atddismissed
No
11163
Atdid: 11163 • Atd Number: ATD-1-205 • Bblid: 93287
Atdid
11163
Atd Number
ATD-1-205
Bblid
93287
Inspectionid
346014
Inspect Date
2022-10-14T00:00:00.000
Atdissuedate
2022-10-14T15:01:31.000
Cb
8
House Num
111
Onstname
E. 62ND ST.
Atddismissed
No
14133
Atdid: 14133 • Atd Number: ATD-4-5892 • Bblid: 746469
Atdid
14133
Atd Number
ATD-4-5892
Bblid
746469
Inspectionid
373349
Inspect Date
2024-03-08T00:00:00.000
Atdissuedate
2024-03-18T10:09:55.000
Cb
8
House Num
67-28
Onstname
181ST ST.
Atddismissed
No
18247
Atdid: 18247 • Atd Number: ATD-3-7201 • Bblid: 420305
Atdid
18247
Atd Number
ATD-3-7201
Bblid
420305
Inspectionid
403582
Inspect Date
2025-07-11T00:00:00.000
Atdissuedate
2025-08-05T08:58:09.000
Cb
12
House Num
424
Onstname
DAHILL RD.
Atddismissed
No
16553
Atdid: 16553 • Atd Number: ATD-3-6489 • Bblid: 268194
Atdid
16553
Atd Number
ATD-3-6489
Bblid
268194
Inspectionid
386887
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2024-12-19T12:03:38.000
Cb
7
House Num
362
Onstname
52ND ST.
Atddismissed
No
12363
Atdid: 12363 • Atd Number: ATD-4-5229 • Bblid: 604357
Atdid
12363
Atd Number
ATD-4-5229
Bblid
604357
Inspectionid
357520
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:21:56.000
Cb
2
House Num
68-15
Onstname
QUEENS BOULEVARD
Atddismissed
No
14883
Atdid: 14883 • Atd Number: ATD-3-6185 • Bblid: 428979
Atdid
14883
Atd Number
ATD-3-6185
Bblid
428979
Inspectionid
380368
Inspect Date
2024-08-06T00:00:00.000
Atdissuedate
2024-08-07T09:33:58.000
Cb
11
House Num
6629
Onstname
OVINGTON CT.
Atddismissed
No
13442
Atdid: 13442 • Atd Number: ATD-2-1237 • Bblid: 216294
Atdid
13442
Atd Number
ATD-2-1237
Bblid
216294
Inspectionid
364016
Inspect Date
2023-08-08T00:00:00.000
Atdissuedate
2023-09-21T09:48:54.000
Cb
12
House Num
3220
Onstname
SEYMOUR AVE.
Atddismissed
No
16761
Atdid: 16761 • Atd Number: ATD-4-6602 • Bblid: 709212
Atdid
16761
Atd Number
ATD-4-6602
Bblid
709212
Inspectionid
389199
Inspect Date
2025-01-23T00:00:00.000
Atdissuedate
2025-01-31T12:04:54.000
Cb
7
House Num
33-54
Onstname
166TH ST.
Atddismissed
No
9617
Atdid: 9617 • Atd Number: ATD-4-4323 • Bblid: 773710
Atdid
9617
Atd Number
ATD-4-4323
Bblid
773710
Inspectionid
333783
Inspect Date
2021-12-08T00:00:00.000
Atdissuedate
2022-03-15T15:39:00.000
Cb
13
House Num
269-20
Onstname
80TH AVE.
Atddismissed
No
12243
Atdid: 12243 • Atd Number: ATD-4-5186 • Bblid: 827509
Atdid
12243
Atd Number
ATD-4-5186
Bblid
827509
Inspectionid
357163
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2023-05-15T13:58:54.000
Cb
13
House Num
90-29
Onstname
215TH PL.
Atddismissed
No
9181
Atdid: 9181 • Atd Number: ATD-4-4188 • Bblid: 721674
Atdid
9181
Atd Number
ATD-4-4188
Bblid
721674
Inspectionid
332839
Inspect Date
2019-06-12T00:00:00.000
Atdissuedate
2022-02-28T16:04:57.000
Cb
7
House Num
23-17
Onstname
202ND ST.
Atddismissed
No
17133
Atdid: 17133 • Atd Number: ATD-2-1352 • Bblid: 176972
Atdid
17133
Atd Number
ATD-2-1352
Bblid
176972
Inspectionid
392555
Inspect Date
2025-03-29T00:00:00.000
Atdissuedate
2025-03-29T09:30:39.000
Cb
9
House Num
1222
Onstname
BEACH AVE.
Atddismissed
No
9758
Atdid: 9758 • Atd Number: ATD-2-907 • Bblid: 200075
Atdid
9758
Atd Number
ATD-2-907
Bblid
200075
Inspectionid
334351
Inspect Date
2019-08-08T00:00:00.000
Atdissuedate
2022-03-29T17:52:11.000
Cb
11
House Num
1210
Onstname
LAKEWOOD PL.
Atddismissed
No
16184
Atdid: 16184 • Atd Number: ATD-3-6329 • Bblid: 479960
Atdid
16184
Atd Number
ATD-3-6329
Bblid
479960
Inspectionid
383711
Inspect Date
2024-10-01T00:00:00.000
Atdissuedate
2024-10-03T12:49:30.000
Cb
14
House Num
811
Onstname
E. 12TH ST.
Atddismissed
No
16966
Atdid: 16966 • Atd Number: ATD-4-6665 • Bblid: 638941
Atdid
16966
Atd Number
ATD-4-6665
Bblid
638941
Inspectionid
391626
Inspect Date
2025-02-01T00:00:00.000
Atdissuedate
2025-03-19T09:09:13.000
Cb
5
House Num
59-85
Onstname
57TH DR.
Atddismissed
No
13183
Atdid: 13183 • Atd Number: ATD-3-5362 • Bblid: 422844
Atdid
13183
Atd Number
ATD-3-5362
Bblid
422844
Inspectionid
361822
Inspect Date
2023-08-10T00:00:00.000
Atdissuedate
2023-08-10T10:27:02.000
Cb
12
House Num
1608
Onstname
46TH ST.
Atddismissed
No
17547
Atdid: 17547 • Atd Number: ATD-4-6859 • Bblid: 868341
Atdid
17547
Atd Number
ATD-4-6859
Bblid
868341
Inspectionid
396324
Inspect Date
2025-04-16T00:00:00.000
Atdissuedate
2025-05-06T12:01:30.000
Cb
12
House Num
119-45
Onstname
SUTPHIN BLVD.
Atddismissed
No
10076
Atdid: 10076 • Atd Number: ATD-3-3696 • Bblid: 407419
Atdid
10076
Atd Number
ATD-3-3696
Bblid
407419
Inspectionid
336348
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-11T12:34:39.000
Cb
9
House Num
260
Onstname
MIDWOOD ST.
Atddismissed
No
9886
Atdid: 9886 • Atd Number: ATD-4-4492 • Bblid: 702686
Atdid
9886
Atd Number
ATD-4-4492
Bblid
702686
Inspectionid
335016
Inspect Date
2021-10-19T00:00:00.000
Atdissuedate
2022-04-15T12:58:20.000
Cb
7
House Num
132-23
Onstname
SANFORD AVE.
Atddismissed
No
922
Atdid: 922 • Atd Number: ATD-3-65 • Bblid: 332297
Atdid
922
Atd Number
ATD-3-65
Bblid
332297
Violationid
56511
Atdissuedate
2020-08-12T00:00:00.000
Cb
1
House Num
220
Onstname
HOOPER STREET
Atddismissed
Yes
Atddismissedon
2024-07-22T10:23:43.000
18387
Atdid: 18387 • Atd Number: ATD-4-7279 • Bblid: 887043
Atdid
18387
Atd Number
ATD-4-7279
Bblid
887043
Inspectionid
404556
Inspect Date
2025-08-05T00:00:00.000
Atdissuedate
2025-08-20T14:00:36.000
Cb
13
House Num
136-37
Onstname
222ND ST.
Atddismissed
No
NYC Data AI • Public-data exploration interface