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
9995
Atdid: 9995 • Atd Number: ATD-4-4547 • Bblid: 654497
Atdid
9995
Atd Number
ATD-4-4547
Bblid
654497
Inspectionid
335821
Inspect Date
2022-04-19T00:00:00.000
Atdissuedate
2022-04-29T13:57:31.000
Cb
6
House Num
64-45
Onstname
ELLWELL CRES
Atddismissed
No
11916
Atdid: 11916 • Atd Number: ATD-2-997 • Bblid: 233177
Atdid
11916
Atd Number
ATD-2-997
Bblid
233177
Inspectionid
354123
Inspect Date
2023-03-23T00:00:00.000
Atdissuedate
2023-03-28T11:50:28.000
Cb
10
House Num
1475
Onstname
STADIUM AVE.
Atddismissed
No
14402
Atdid: 14402 • Atd Number: ATD-3-5943 • Bblid: 530042
Atdid
14402
Atd Number
ATD-3-5943
Bblid
530042
Inspectionid
376754
Inspect Date
2024-04-30T00:00:00.000
Atdissuedate
2024-05-06T12:26:18.000
Cb
17
House Num
122
Onstname
BRANTON ST.
Atddismissed
No
10369
Atdid: 10369 • Atd Number: ATD-3-3882 • Bblid: 417844
Atdid
10369
Atd Number
ATD-3-3882
Bblid
417844
Inspectionid
338557
Inspect Date
2022-06-15T00:00:00.000
Atdissuedate
2022-07-05T13:20:45.000
Cb
12
House Num
231
Onstname
E. 5TH ST.
Atddismissed
No
9403
Atdid: 9403 • Atd Number: ATD-3-3493 • Bblid: 537509
Atdid
9403
Atd Number
ATD-3-3493
Bblid
537509
Inspectionid
333162
Inspect Date
2020-11-25T00:00:00.000
Atdissuedate
2022-03-03T17:21:53.000
Cb
17
House Num
716
Onstname
E. 94TH ST.
Atddismissed
No
18355
Atdid: 18355 • Atd Number: ATD-4-7259 • Bblid: 572735
Atdid
18355
Atd Number
ATD-4-7259
Bblid
572735
Inspectionid
404425
Inspect Date
2024-08-28T00:00:00.000
Atdissuedate
2025-08-18T13:39:25.000
Cb
1
House Num
36-12
Onstname
CRESCENT ST.
Atddismissed
No
14260
Atdid: 14260 • Atd Number: ATD-3-5879 • Bblid: 485772
Atdid
14260
Atd Number
ATD-3-5879
Bblid
485772
Inspectionid
375154
Inspect Date
2024-03-21T00:00:00.000
Atdissuedate
2024-04-10T11:43:10.000
Cb
15
House Num
1860
Onstname
E. 23RD ST.
Atddismissed
No
12300
Atdid: 12300 • Atd Number: ATD-2-1097 • Bblid: 153679
Atdid
12300
Atd Number
ATD-2-1097
Bblid
153679
Inspectionid
357351
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T12:04:52.000
Cb
4
House Num
1376
Onstname
CROMWELL AVE.
Atddismissed
No
9644
Atdid: 9644 • Atd Number: ATD-4-4348 • Bblid: 735869
Atdid
9644
Atd Number
ATD-4-4348
Bblid
735869
Inspectionid
333813
Inspect Date
2021-04-07T00:00:00.000
Atdissuedate
2022-03-15T19:09:02.000
Cb
8
House Num
141-14
Onstname
70TH AVE.
Atddismissed
No
12505
Atdid: 12505 • Atd Number: ATD-4-5331 • Bblid: 794084
Atdid
12505
Atd Number
ATD-4-5331
Bblid
794084
Inspectionid
358050
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T16:26:30.000
Cb
9
House Num
114-02
Onstname
ATLANTIC AVE.
Atddismissed
No
17580
Atdid: 17580 • Atd Number: ATD-5-973 • Bblid: 933844
Atdid
17580
Atd Number
ATD-5-973
Bblid
933844
Inspectionid
396855
Inspect Date
2025-04-16T00:00:00.000
Atdissuedate
2025-05-12T11:50:42.000
Cb
1
House Num
61
Onstname
DRAKE AVE.
Atddismissed
No
14318
Atdid: 14318 • Atd Number: ATD-3-5902 • Bblid: 326094
Atdid
14318
Atd Number
ATD-3-5902
Bblid
326094
Inspectionid
375802
Inspect Date
2024-04-17T00:00:00.000
Atdissuedate
2024-04-22T14:35:54.000
Cb
2
House Num
418
Onstname
CUMBERLAND ST.
Atddismissed
No
17459
Atdid: 17459 • Atd Number: ATD-4-6813 • Bblid: 806904
Atdid
17459
Atd Number
ATD-4-6813
Bblid
806904
Inspectionid
395437
Inspect Date
2025-04-22T00:00:00.000
Atdissuedate
2025-04-28T11:07:26.000
Cb
12
House Num
89-19
Onstname
168TH PL.
Atddismissed
No
13561
Atdid: 13561 • Atd Number: ATD-3-5577 • Bblid: 418572
Atdid
13561
Atd Number
ATD-3-5577
Bblid
418572
Inspectionid
365121
Inspect Date
2023-10-06T00:00:00.000
Atdissuedate
2023-10-10T16:10:21.000
Cb
12
House Num
1413
Onstname
40TH ST.
Atddismissed
No
13797
Atdid: 13797 • Atd Number: ATD-4-5692 • Bblid: 685549
Atdid
13797
Atd Number
ATD-4-5692
Bblid
685549
Inspectionid
369985
Inspect Date
2023-12-22T00:00:00.000
Atdissuedate
2023-12-22T11:03:32.000
Cb
7
House Num
141-40
Onstname
25TH AVE.
Atddismissed
No
10790
Atdid: 10790 • Atd Number: ATD-3-4167 • Bblid: 466923
Atdid
10790
Atd Number
ATD-3-4167
Bblid
466923
Inspectionid
342945
Inspect Date
2022-08-18T00:00:00.000
Atdissuedate
2022-09-08T07:27:09.000
Cb
11
House Num
90
Onstname
BAY 14TH ST.
Atddismissed
No
18020
Atdid: 18020 • Atd Number: ATD-5-1004 • Bblid: 930905
Atdid
18020
Atd Number
ATD-5-1004
Bblid
930905
Inspectionid
401759
Inspect Date
2025-07-02T00:00:00.000
Atdissuedate
2025-07-02T14:45:33.000
Cb
1
House Num
199
Onstname
HART BLVD.
Atddismissed
No
11010
Atdid: 11010 • Atd Number: ATD-3-4362 • Bblid: 267190
Atdid
11010
Atd Number
ATD-3-4362
Bblid
267190
Inspectionid
344565
Inspect Date
2022-09-20T00:00:00.000
Atdissuedate
2022-09-26T12:30:49.000
Cb
7
House Num
469
Onstname
50TH ST.
Atddismissed
No
10233
Atdid: 10233 • Atd Number: ATD-3-3812 • Bblid: 332758
Atdid
10233
Atd Number
ATD-3-3812
Bblid
332758
Inspectionid
337364
Inspect Date
2022-06-03T00:00:00.000
Atdissuedate
2022-06-06T12:41:18.000
Cb
1
House Num
92
Onstname
PENN STREET
Atddismissed
Yes
Atddismissedon
2022-11-10T08:16:04.000
16407
Atdid: 16407 • Atd Number: ATD-5-893 • Bblid: 1056178
Atdid
16407
Atd Number
ATD-5-893
Bblid
1056178
Inspectionid
385161
Inspect Date
2024-11-15T00:00:00.000
Atdissuedate
2024-11-19T09:18:24.000
Cb
3
House Num
229
Onstname
HECKER ST.
Atddismissed
No
11394
Atdid: 11394 • Atd Number: ATD-1-235 • Bblid: 103960
Atdid
11394
Atd Number
ATD-1-235
Bblid
103960
Inspectionid
348268
Inspect Date
2022-11-15T00:00:00.000
Atdissuedate
2022-11-17T12:38:57.000
Cb
8
House Num
162
Onstname
E. 81ST ST.
Atddismissed
No
9694
Atdid: 9694 • Atd Number: ATD-4-4378 • Bblid: 894738
Atdid
9694
Atd Number
ATD-4-4378
Bblid
894738
Inspectionid
333938
Inspect Date
2022-03-18T00:00:00.000
Atdissuedate
2022-03-18T12:09:05.000
Cb
13
House Num
243-34
Onstname
144TH AVE.
Atddismissed
No
12778
Atdid: 12778 • Atd Number: ATD-2-1183 • Bblid: 205318
Atdid
12778
Atd Number
ATD-2-1183
Bblid
205318
Inspectionid
359533
Inspect Date
2023-07-05T00:00:00.000
Atdissuedate
2023-07-06T17:59:37.000
Cb
11
House Num
2533
Onstname
HOLLAND AVE.
Atddismissed
No
14116
Atdid: 14116 • Atd Number: ATD-3-5798 • Bblid: 519954
Atdid
14116
Atd Number
ATD-3-5798
Bblid
519954
Inspectionid
373271
Inspect Date
2024-03-15T00:00:00.000
Atdissuedate
2024-03-15T14:31:52.000
Cb
18
House Num
1655
Onstname
E. 34TH ST.
Atddismissed
No
17725
Atdid: 17725 • Atd Number: ATD-4-6972 • Bblid: 726874
Atdid
17725
Atd Number
ATD-4-6972
Bblid
726874
Inspectionid
398324
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-05-23T13:09:12.000
Cb
11
House Num
32-26
Onstname
BELL BLVD.
Atddismissed
No
11516
Atdid: 11516 • Atd Number: ATD-4-4909 • Bblid: 637605
Atdid
11516
Atd Number
ATD-4-4909
Bblid
637605
Inspectionid
349402
Inspect Date
2022-12-15T00:00:00.000
Atdissuedate
2022-12-16T12:32:23.000
Cb
5
House Num
60-70
Onstname
54TH PL.
Atddismissed
No
14739
Atdid: 14739 • Atd Number: ATD-3-6125 • Bblid: 476772
Atdid
14739
Atd Number
ATD-3-6125
Bblid
476772
Inspectionid
379330
Inspect Date
2024-07-12T00:00:00.000
Atdissuedate
2024-07-15T11:15:50.000
Cb
15
House Num
1661
Onstname
E. 10TH ST.
Atddismissed
No
18361
Atdid: 18361 • Atd Number: ATD-3-7241 • Bblid: 307013
Atdid
18361
Atd Number
ATD-3-7241
Bblid
307013
Inspectionid
404433
Inspect Date
2025-08-08T00:00:00.000
Atdissuedate
2025-08-18T13:53:04.000
Cb
3
House Num
291
Onstname
VAN BUREN ST.
Atddismissed
No
10652
Atdid: 10652 • Atd Number: ATD-3-4054 • Bblid: 328848
Atdid
10652
Atd Number
ATD-3-4054
Bblid
328848
Inspectionid
341572
Inspect Date
2022-08-11T00:00:00.000
Atdissuedate
2022-08-15T14:45:25.000
Cb
2
House Num
290
Onstname
CARLTON AVE.
Atddismissed
No
12874
Atdid: 12874 • Atd Number: ATD-2-1191 • Bblid: 202425
Atdid
12874
Atd Number
ATD-2-1191
Bblid
202425
Inspectionid
360144
Inspect Date
2023-07-12T00:00:00.000
Atdissuedate
2023-07-17T13:00:16.000
Cb
11
House Num
2032
Onstname
MATTHEWS AVE.
Atddismissed
No
10411
Atdid: 10411 • Atd Number: ATD-3-3905 • Bblid: 434165
Atdid
10411
Atd Number
ATD-3-3905
Bblid
434165
Inspectionid
338995
Inspect Date
2022-07-06T00:00:00.000
Atdissuedate
2022-07-11T08:32:41.000
Cb
12
House Num
1359
Onstname
52ND ST.
Atddismissed
No
14835
Atdid: 14835 • Atd Number: ATD-5-867 • Bblid: 1032210
Atdid
14835
Atd Number
ATD-5-867
Bblid
1032210
Inspectionid
380046
Inspect Date
2024-07-31T00:00:00.000
Atdissuedate
2024-08-01T11:39:21.000
Cb
3
House Num
24
Onstname
BELFIELD AVE.
Atddismissed
No
13633
Atdid: 13633 • Atd Number: ATD-3-5615 • Bblid: 306712
Atdid
13633
Atd Number
ATD-3-5615
Bblid
306712
Inspectionid
366067
Inspect Date
2023-10-28T00:00:00.000
Atdissuedate
2023-10-28T15:10:27.000
Cb
3
House Num
1054
Onstname
DEKALB AVE.
Atddismissed
No
8859
Atdid: 8859 • Atd Number: ATD-4-4002 • Bblid: 609363
Atdid
8859
Atd Number
ATD-4-4002
Bblid
609363
Inspectionid
331797
Inspect Date
2019-01-30T00:00:00.000
Atdissuedate
2022-01-21T13:17:56.000
Cb
3
House Num
37-27
Onstname
89TH ST.
Atddismissed
No
11858
Atdid: 11858 • Atd Number: ATD-3-4831 • Bblid: 421930
Atdid
11858
Atd Number
ATD-3-4831
Bblid
421930
Inspectionid
353578
Inspect Date
2023-03-21T00:00:00.000
Atdissuedate
2023-03-22T12:03:19.000
Cb
14
House Num
169
Onstname
PARKVILLE AVE.
Atddismissed
No
18107
Atdid: 18107 • Atd Number: ATD-3-7136 • Bblid: 250381
Atdid
18107
Atd Number
ATD-3-7136
Bblid
250381
Inspectionid
402537
Inspect Date
2025-07-11T00:00:00.000
Atdissuedate
2025-07-17T09:33:34.000
Cb
2
House Num
540
Onstname
STATE ST.
Atddismissed
No
16937
Atdid: 16937 • Atd Number: ATD-3-6643 • Bblid: 278745
Atdid
16937
Atd Number
ATD-3-6643
Bblid
278745
Inspectionid
391418
Inspect Date
2025-03-14T00:00:00.000
Atdissuedate
2025-03-17T08:35:16.000
Cb
6
House Num
415
Onstname
8TH ST.
Atddismissed
No
13539
Atdid: 13539 • Atd Number: ATD-4-5578 • Bblid: 761629
Atdid
13539
Atd Number
ATD-4-5578
Bblid
761629
Inspectionid
364852
Inspect Date
2023-09-07T00:00:00.000
Atdissuedate
2023-10-03T15:47:27.000
Cb
13
House Num
88-56
Onstname
240TH ST.
Atddismissed
No
14779
Atdid: 14779 • Atd Number: ATD-4-6169 • Bblid: 894206
Atdid
14779
Atd Number
ATD-4-6169
Bblid
894206
Inspectionid
379701
Inspect Date
2024-07-10T00:00:00.000
Atdissuedate
2024-07-22T13:29:21.000
Cb
13
House Num
143-30
Onstname
243RD ST.
Atddismissed
No
11589
Atdid: 11589 • Atd Number: ATD-4-4955 • Bblid: 669797
Atdid
11589
Atd Number
ATD-4-4955
Bblid
669797
Inspectionid
350366
Inspect Date
2023-01-09T00:00:00.000
Atdissuedate
2023-01-11T12:39:49.000
Cb
5
House Num
75-02
Onstname
64TH PL.
Atddismissed
No
17023
Atdid: 17023 • Atd Number: ATD-3-6691 • Bblid: 264414
Atdid
17023
Atd Number
ATD-3-6691
Bblid
264414
Inspectionid
392248
Inspect Date
2021-09-22T00:00:00.000
Atdissuedate
2025-03-26T11:21:38.000
Cb
7
House Num
435
Onstname
37TH ST.
Atddismissed
No
13555
Atdid: 13555 • Atd Number: ATD-3-5573 • Bblid: 359741
Atdid
13555
Atd Number
ATD-3-5573
Bblid
359741
Inspectionid
365054
Inspect Date
2023-10-06T00:00:00.000
Atdissuedate
2023-10-10T11:26:40.000
Cb
4
House Num
308
Onstname
CORNELIA ST.
Atddismissed
No
12693
Atdid: 12693 • Atd Number: ATD-5-728 • Bblid: 1025255
Atdid
12693
Atd Number
ATD-5-728
Bblid
1025255
Inspectionid
359104
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-29T14:57:57.000
Cb
3
House Num
405
Onstname
ARTHUR KILL RD.
Atddismissed
No
9209
Atdid: 9209 • Atd Number: ATD-3-3360 • Bblid: 443900
Atdid
9209
Atd Number
ATD-3-3360
Bblid
443900
Inspectionid
332867
Inspect Date
2021-01-15T00:00:00.000
Atdissuedate
2022-02-28T17:45:09.000
Cb
10
House Num
7024
Onstname
PERRY TER.
Atddismissed
No
14391
Atdid: 14391 • Atd Number: ATD-2-1269 • Bblid: 245142
Atdid
14391
Atd Number
ATD-2-1269
Bblid
245142
Inspectionid
376665
Inspect Date
2024-04-27T00:00:00.000
Atdissuedate
2024-05-06T11:09:00.000
Cb
8
House Num
5433
Onstname
FIELDSTON RD.
Atddismissed
No
191
Atdid: 191 • Atd Number: ATD-1-128 • Bblid: 46082
Atdid
191
Atd Number
ATD-1-128
Bblid
46082
Violationid
191074
Atdissuedate
2020-03-17T00:00:00.000
Cb
6
House Num
214
Onstname
EAST 30 STREET
Atddismissed
Yes
Atddismissedon
2025-06-13T13:21:09.000
18650
Atdid: 18650 • Atd Number: ATD-3-7353 • Bblid: 377736
Atdid
18650
Atd Number
ATD-3-7353
Bblid
377736
Inspectionid
406286
Inspect Date
2025-09-09T00:00:00.000
Atdissuedate
2025-09-22T11:00:30.000
Cb
5
House Num
497
Onstname
SCHENCK AVE.
Atddismissed
No
8478
Atdid: 8478 • Atd Number: ATD-3-3087 • Bblid: 252998
Atdid
8478
Atd Number
ATD-3-3087
Bblid
252998
Inspectionid
329520
Inspect Date
2019-07-26T00:00:00.000
Atdissuedate
2021-11-12T11:50:00.000
Cb
2
House Num
160
Onstname
CLINTON ST.
Atddismissed
No
17357
Atdid: 17357 • Atd Number: ATD-4-6770 • Bblid: 741841
Atdid
17357
Atd Number
ATD-4-6770
Bblid
741841
Inspectionid
394592
Inspect Date
2025-04-10T00:00:00.000
Atdissuedate
2025-04-14T13:04:20.000
Cb
8
House Num
159-19
Onstname
GRAND CENTRAL PKWY.
Atddismissed
No
14744
Atdid: 14744 • Atd Number: ATD-4-6150 • Bblid: 718057
Atdid
14744
Atd Number
ATD-4-6150
Bblid
718057
Inspectionid
379364
Inspect Date
2024-07-02T00:00:00.000
Atdissuedate
2024-07-15T13:38:48.000
Cb
11
House Num
46-78
Onstname
HOLLIS COURT BLVD.
Atddismissed
No
NYC Data AI • Public-data exploration interface