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
17498
Atdid: 17498 • Atd Number: ATD-4-6832 • Bblid: 753449
Atdid
17498
Atd Number
ATD-4-6832
Bblid
753449
Inspectionid
395904
Inspect Date
2025-04-03T00:00:00.000
Atdissuedate
2025-05-02T14:44:36.000
Cb
11
House Num
53-15
Onstname
OCEANIA ST.
Atddismissed
No
13936
Atdid: 13936 • Atd Number: ATD-4-5785 • Bblid: 584851
Atdid
13936
Atd Number
ATD-4-5785
Bblid
584851
Inspectionid
371415
Inspect Date
2024-02-08T00:00:00.000
Atdissuedate
2024-02-08T11:43:51.000
Cb
1
House Num
21-54
Onstname
46TH ST.
Atddismissed
No
8761
Atdid: 8761 • Atd Number: ATD-3-3211 • Bblid: 264622
Atdid
8761
Atd Number
ATD-3-3211
Bblid
264622
Inspectionid
331130
Inspect Date
2021-12-22T00:00:00.000
Atdissuedate
2021-12-28T15:05:36.000
Cb
7
House Num
433
Onstname
41ST ST.
Atddismissed
No
9695
Atdid: 9695 • Atd Number: ATD-4-4379 • Bblid: 758501
Atdid
9695
Atd Number
ATD-4-4379
Bblid
758501
Inspectionid
333995
Inspect Date
2022-03-18T00:00:00.000
Atdissuedate
2022-03-21T13:14:48.000
Cb
11
House Num
80-35
Onstname
208TH ST.
Atddismissed
No
13309
Atdid: 13309 • Atd Number: ATD-3-5459 • Bblid: 316647
Atdid
13309
Atd Number
ATD-3-5459
Bblid
316647
Inspectionid
362501
Inspect Date
2023-08-24T00:00:00.000
Atdissuedate
2023-08-24T11:27:06.000
Cb
3
House Num
456
Onstname
QUINCY ST.
Atddismissed
No
17509
Atdid: 17509 • Atd Number: ATD-4-6834 • Bblid: 873263
Atdid
17509
Atd Number
ATD-4-6834
Bblid
873263
Inspectionid
396027
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-05T07:57:37.000
Cb
12
House Num
175-04
Onstname
BAISLEY BLVD.
Atddismissed
No
9666
Atdid: 9666 • Atd Number: ATD-2-894 • Bblid: 180951
Atdid
9666
Atd Number
ATD-2-894
Bblid
180951
Inspectionid
333863
Inspect Date
2019-07-13T00:00:00.000
Atdissuedate
2022-03-16T17:50:11.000
Cb
9
House Num
1472
Onstname
ROSEDALE AVE.
Atddismissed
No
14834
Atdid: 14834 • Atd Number: ATD-4-6189 • Bblid: 860808
Atdid
14834
Atd Number
ATD-4-6189
Bblid
860808
Violationid
290018
Reinspectionid
36200
Inspect Date
2024-07-31T14:21:20.000
Atdissuedate
2024-07-31T14:21:20.000
Cb
12
House Num
111-06
Onstname
145 STREET
Atddismissed
No
17731
Atdid: 17731 • Atd Number: ATD-4-6978 • Bblid: 726882
Atdid
17731
Atd Number
ATD-4-6978
Bblid
726882
Inspectionid
398334
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-05-23T13:32:04.000
Cb
11
House Num
32-40
Onstname
BELL BLVD.
Atddismissed
No
9710
Atdid: 9710 • Atd Number: ATD-4-4394 • Bblid: 764972
Atdid
9710
Atd Number
ATD-4-4394
Bblid
764972
Inspectionid
334123
Inspect Date
2013-09-11T00:00:00.000
Atdissuedate
2022-03-24T16:55:42.000
Cb
11
House Num
242-30
Onstname
VAN ZANDT AVE.
Atddismissed
No
16954
Atdid: 16954 • Atd Number: ATD-4-6660 • Bblid: 638979
Atdid
16954
Atd Number
ATD-4-6660
Bblid
638979
Inspectionid
391522
Inspect Date
2025-02-28T00:00:00.000
Atdissuedate
2025-03-17T15:15:24.000
Cb
5
House Num
59-27
Onstname
57TH DR.
Atddismissed
No
13037
Atdid: 13037 • Atd Number: ATD-3-5281 • Bblid: 422472
Atdid
13037
Atd Number
ATD-3-5281
Bblid
422472
Inspectionid
361031
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T14:41:52.000
Cb
12
House Num
1624
Onstname
45TH ST.
Atddismissed
No
11415
Atdid: 11415 • Atd Number: ATD-1-247 • Bblid: 119393
Atdid
11415
Atd Number
ATD-1-247
Bblid
119393
Inspectionid
348385
Inspect Date
2022-11-03T00:00:00.000
Atdissuedate
2022-11-18T13:42:49.000
Cb
11
House Num
308
Onstname
E. 120TH ST.
Atddismissed
Yes
Atddismissedon
2023-02-24T11:39:28.000
14889
Atdid: 14889 • Atd Number: ATD-3-6190 • Bblid: 369306
Atdid
14889
Atd Number
ATD-3-6190
Bblid
369306
Inspectionid
380444
Inspect Date
2024-08-08T00:00:00.000
Atdissuedate
2024-08-12T09:32:37.000
Cb
5
House Num
351
Onstname
SHEFFIELD AVE.
Atddismissed
No
9691
Atdid: 9691 • Atd Number: ATD-4-4375 • Bblid: 894752
Atdid
9691
Atd Number
ATD-4-4375
Bblid
894752
Inspectionid
333933
Inspect Date
2022-03-16T00:00:00.000
Atdissuedate
2022-03-18T12:05:17.000
Cb
13
House Num
243-56
Onstname
144TH AVE.
Atddismissed
No
15040
Atdid: 15040 • Atd Number: ATD-4-6278 • Bblid: 604692
Atdid
15040
Atd Number
ATD-4-6278
Bblid
604692
Inspectionid
381817
Inspect Date
2024-09-11T00:00:00.000
Atdissuedate
2024-09-13T14:34:47.000
Cb
3
House Num
25-12
Onstname
84TH ST.
Atddismissed
No
14053
Atdid: 14053 • Atd Number: ATD-4-5862 • Bblid: 895637
Atdid
14053
Atd Number
ATD-4-5862
Bblid
895637
Inspectionid
372669
Inspect Date
2024-02-29T00:00:00.000
Atdissuedate
2024-03-04T08:35:24.000
Cb
13
House Num
138-47
Onstname
248TH ST.
Atddismissed
No
9342
Atdid: 9342 • Atd Number: ATD-3-3439 • Bblid: 479559
Atdid
9342
Atd Number
ATD-3-3439
Bblid
479559
Inspectionid
333065
Inspect Date
2021-03-10T00:00:00.000
Atdissuedate
2022-03-02T16:55:57.000
Cb
15
House Num
1844
Onstname
E. 8TH ST.
Atddismissed
No
12023
Atdid: 12023 • Atd Number: ATD-3-4918 • Bblid: 361283
Atdid
12023
Atd Number
ATD-3-4918
Bblid
361283
Inspectionid
355807
Inspect Date
2023-04-13T00:00:00.000
Atdissuedate
2023-04-13T13:42:26.000
Cb
4
House Num
195
Onstname
COVERT ST.
Atddismissed
No
8984
Atdid: 8984 • Atd Number: ATD-4-4075 • Bblid: 677675
Atdid
8984
Atd Number
ATD-4-4075
Bblid
677675
Inspectionid
332297
Inspect Date
2020-12-04T00:00:00.000
Atdissuedate
2022-02-08T08:15:52.000
Cb
5
House Num
87-11
Onstname
UNION TPKE.
Atddismissed
No
8929
Atdid: 8929 • Atd Number: ATD-4-4043 • Bblid: 673885
Atdid
8929
Atd Number
ATD-4-4043
Bblid
673885
Inspectionid
332157
Inspect Date
2019-05-17T00:00:00.000
Atdissuedate
2022-01-31T10:48:00.000
Cb
5
House Num
65-08
Onstname
COOPER AVE.
Atddismissed
No
10850
Atdid: 10850 • Atd Number: ATD-3-4221 • Bblid: 262279
Atdid
10850
Atd Number
ATD-3-4221
Bblid
262279
Inspectionid
343377
Inspect Date
2022-09-09T00:00:00.000
Atdissuedate
2022-09-12T10:20:20.000
Cb
6
House Num
93
Onstname
DIKEMAN ST.
Atddismissed
No
16540
Atdid: 16540 • Atd Number: ATD-3-6478 • Bblid: 282522
Atdid
16540
Atd Number
ATD-3-6478
Bblid
282522
Inspectionid
386578
Inspect Date
2024-12-17T00:00:00.000
Atdissuedate
2024-12-18T11:27:11.000
Cb
6
House Num
613
Onstname
2ND ST.
Atddismissed
No
17858
Atdid: 17858 • Atd Number: ATD-3-7040 • Bblid: 275510
Atdid
17858
Atd Number
ATD-3-7040
Bblid
275510
Inspectionid
399965
Inspect Date
2025-05-17T00:00:00.000
Atdissuedate
2025-06-11T15:15:57.000
Cb
6
House Num
48
Onstname
BERKELEY PL.
Atddismissed
No
14253
Atdid: 14253 • Atd Number: ATD-4-5941 • Bblid: 685083
Atdid
14253
Atd Number
ATD-4-5941
Bblid
685083
Inspectionid
374989
Inspect Date
2024-03-26T00:00:00.000
Atdissuedate
2024-04-08T12:20:28.000
Cb
7
House Num
141-19
Onstname
25TH AVE.
Atddismissed
No
8644
Atdid: 8644 • Atd Number: ATD-3-3168 • Bblid: 282783
Atdid
8644
Atd Number
ATD-3-3168
Bblid
282783
Inspectionid
330782
Inspect Date
2019-05-15T00:00:00.000
Atdissuedate
2021-12-15T15:55:23.000
Cb
6
House Num
555
Onstname
7TH ST.
Atddismissed
No
14123
Atdid: 14123 • Atd Number: ATD-3-5805 • Bblid: 519914
Atdid
14123
Atd Number
ATD-3-5805
Bblid
519914
Inspectionid
373291
Inspect Date
2024-03-15T00:00:00.000
Atdissuedate
2024-03-15T14:38:54.000
Cb
18
House Num
1703
Onstname
E. 34TH ST.
Atddismissed
No
9023
Atdid: 9023 • Atd Number: ATD-3-3299 • Bblid: 509701
Atdid
9023
Atd Number
ATD-3-3299
Bblid
509701
Inspectionid
332385
Inspect Date
2019-09-04T00:00:00.000
Atdissuedate
2022-02-11T14:22:37.000
Cb
15
House Num
2441
Onstname
E. 15TH ST.
Atddismissed
No
16589
Atdid: 16589 • Atd Number: ATD-4-6514 • Bblid: 581247
Atdid
16589
Atd Number
ATD-4-6514
Bblid
581247
Inspectionid
387139
Inspect Date
2024-12-02T00:00:00.000
Atdissuedate
2024-12-20T13:53:53.000
Cb
1
House Num
30-84
Onstname
41ST ST.
Atddismissed
No
13775
Atdid: 13775 • Atd Number: ATD-4-5678 • Bblid: 841100
Atdid
13775
Atd Number
ATD-4-5678
Bblid
841100
Inspectionid
369525
Inspect Date
2023-12-14T00:00:00.000
Atdissuedate
2023-12-14T07:51:10.000
Cb
13
House Num
223-32
Onstname
HEMPSTEAD AVE.
Atddismissed
No
14518
Atdid: 14518 • Atd Number: ATD-3-5990 • Bblid: 291484
Atdid
14518
Atd Number
ATD-3-5990
Bblid
291484
Inspectionid
377748
Inspect Date
2024-05-18T00:00:00.000
Atdissuedate
2024-05-21T15:41:49.000
Cb
8
House Num
968
Onstname
SAINT JOHNS PL.
Atddismissed
No
9021
Atdid: 9021 • Atd Number: ATD-4-4096 • Bblid: 898842
Atdid
9021
Atd Number
ATD-4-4096
Bblid
898842
Inspectionid
332381
Inspect Date
2019-06-26T00:00:00.000
Atdissuedate
2022-02-10T16:27:10.000
Cb
13
House Num
148-82
Onstname
HUXLEY ST.
Atddismissed
No
12103
Atdid: 12103 • Atd Number: ATD-3-4958 • Bblid: 268785
Atdid
12103
Atd Number
ATD-3-4958
Bblid
268785
Inspectionid
356323
Inspect Date
2023-04-19T00:00:00.000
Atdissuedate
2023-04-26T14:05:40.000
Cb
7
House Num
443
Onstname
54TH ST.
Atddismissed
No
14480
Atdid: 14480 • Atd Number: ATD-4-6051 • Bblid: 896621
Atdid
14480
Atd Number
ATD-4-6051
Bblid
896621
Inspectionid
377407
Inspect Date
2024-05-16T00:00:00.000
Atdissuedate
2024-05-16T16:03:23.000
Cb
13
House Num
149-66
Onstname
WELLER LN.
Atddismissed
No
9156
Atdid: 9156 • Atd Number: ATD-4-4180 • Bblid: 706494
Atdid
9156
Atd Number
ATD-4-4180
Bblid
706494
Inspectionid
332765
Inspect Date
2019-08-03T00:00:00.000
Atdissuedate
2022-02-24T15:48:29.000
Cb
7
House Num
43-32
Onstname
COLDEN ST.
Atddismissed
No
9716
Atdid: 9716 • Atd Number: ATD-4-4400 • Bblid: 661288
Atdid
9716
Atd Number
ATD-4-4400
Bblid
661288
Inspectionid
334129
Inspect Date
2012-05-17T00:00:00.000
Atdissuedate
2022-03-24T17:28:46.000
Cb
9
House Num
119-12
Onstname
PARK LN. S.
Atddismissed
No
18170
Atdid: 18170 • Atd Number: ATD-3-7171 • Bblid: 561540
Atdid
18170
Atd Number
ATD-3-7171
Bblid
561540
Inspectionid
402947
Inspect Date
2025-07-12T00:00:00.000
Atdissuedate
2025-07-22T16:45:56.000
Cb
15
House Num
2710
Onstname
BROWN ST.
Atddismissed
No
15061
Atdid: 15061 • Atd Number: ATD-3-6289 • Bblid: 457833
Atdid
15061
Atd Number
ATD-3-6289
Bblid
457833
Inspectionid
381942
Inspect Date
2024-09-14T00:00:00.000
Atdissuedate
2024-09-18T11:59:44.000
Cb
11
House Num
7312
Onstname
17TH AVE.
Atddismissed
No
12045
Atdid: 12045 • Atd Number: ATD-4-5126 • Bblid: 744759
Atdid
12045
Atd Number
ATD-4-5126
Bblid
744759
Inspectionid
355965
Inspect Date
2023-04-04T00:00:00.000
Atdissuedate
2023-04-17T13:16:13.000
Cb
8
House Num
76-11
Onstname
167TH ST.
Atddismissed
No
13738
Atdid: 13738 • Atd Number: ATD-4-5658 • Bblid: 882696
Atdid
13738
Atd Number
ATD-4-5658
Bblid
882696
Inspectionid
368932
Inspect Date
2023-12-05T00:00:00.000
Atdissuedate
2023-12-05T14:30:17.000
Cb
13
House Num
130-14
Onstname
227TH ST.
Atddismissed
No
17082
Atdid: 17082 • Atd Number: ATD-3-6733 • Bblid: 287613
Atdid
17082
Atd Number
ATD-3-6733
Bblid
287613
Inspectionid
392455
Inspect Date
2023-03-09T00:00:00.000
Atdissuedate
2025-03-27T15:03:42.000
Cb
8
House Num
576
Onstname
PARK PL.
Atddismissed
Yes
Atddismissedon
2025-05-23T11:51:18.000
3877
Atdid: 3877 • Atd Number: ATD-3-2548 • Bblid: 279087
Atdid
3877
Atd Number
ATD-3-2548
Bblid
279087
Violationid
262234
Atdissuedate
2020-08-03T00:00:00.000
Cb
6
House Num
345
Onstname
11 STREET
Atddismissed
Yes
Atddismissedon
2024-10-28T10:45:51.000
11745
Atdid: 11745 • Atd Number: ATD-3-4773 • Bblid: 548427
Atdid
11745
Atd Number
ATD-3-4773
Bblid
548427
Inspectionid
352491
Inspect Date
2023-03-03T00:00:00.000
Atdissuedate
2023-03-09T10:32:28.000
Cb
18
House Num
2063
Onstname
PEARSON ST.
Atddismissed
No
17303
Atdid: 17303 • Atd Number: ATD-3-6843 • Bblid: 467377
Atdid
17303
Atd Number
ATD-3-6843
Bblid
467377
Inspectionid
394103
Inspect Date
2025-04-09T00:00:00.000
Atdissuedate
2025-04-10T15:37:51.000
Cb
11
House Num
8743
Onstname
21ST AVE.
Atddismissed
No
11194
Atdid: 11194 • Atd Number: ATD-3-4512 • Bblid: 481998
Atdid
11194
Atd Number
ATD-3-4512
Bblid
481998
Inspectionid
346300
Inspect Date
2022-09-21T00:00:00.000
Atdissuedate
2022-10-17T15:22:31.000
Cb
14
House Num
1382
Onstname
E. 18TH ST.
Atddismissed
No
16593
Atdid: 16593 • Atd Number: ATD-4-6518 • Bblid: 775703
Atdid
16593
Atd Number
ATD-4-6518
Bblid
775703
Violationid
297741
Reinspectionid
37836
Inspect Date
2024-12-23T11:21:59.000
Atdissuedate
2024-12-23T11:21:59.000
Cb
13
House Num
87-27
Onstname
257 STREET
Atddismissed
No
8628
Atdid: 8628 • Atd Number: ATD-3-3164 • Bblid: 258869
Atdid
8628
Atd Number
ATD-3-3164
Bblid
258869
Inspectionid
330751
Inspect Date
2021-12-11T00:00:00.000
Atdissuedate
2021-12-15T10:04:05.000
Cb
6
House Num
107
Onstname
BUTLER STREET
Atddismissed
No
11862
Atdid: 11862 • Atd Number: ATD-3-4835 • Bblid: 509770
Atdid
11862
Atd Number
ATD-3-4835
Bblid
509770
Inspectionid
353587
Inspect Date
2023-03-16T00:00:00.000
Atdissuedate
2023-03-22T12:09:50.000
Cb
15
House Num
2432
Onstname
E. 14TH ST.
Atddismissed
No
11724
Atdid: 11724 • Atd Number: ATD-3-4764 • Bblid: 491915
Atdid
11724
Atd Number
ATD-3-4764
Bblid
491915
Inspectionid
352130
Inspect Date
2023-02-18T00:00:00.000
Atdissuedate
2023-02-27T13:35:54.000
Cb
13
House Num
2889
Onstname
W. 27TH ST.
Atddismissed
No
14768
Atdid: 14768 • Atd Number: ATD-4-6163 • Bblid: 577769
Atdid
14768
Atd Number
ATD-4-6163
Bblid
577769
Inspectionid
379539
Inspect Date
2024-07-11T00:00:00.000
Atdissuedate
2024-07-18T12:19:27.000
Cb
1
House Num
36-23
Onstname
32ND ST.
Atddismissed
No
NYC Data AI • Public-data exploration interface