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
11891
Atdid: 11891 • Atd Number: ATD-3-4860 • Bblid: 522246
Atdid
11891
Atd Number
ATD-3-4860
Bblid
522246
Inspectionid
353922
Inspect Date
2023-03-23T00:00:00.000
Atdissuedate
2023-03-27T12:00:21.000
Cb
18
House Num
1220
Onstname
E. 46TH ST.
Atddismissed
Yes
Atddismissedon
2023-06-13T07:45:42.000
12452
Atdid: 12452 • Atd Number: ATD-4-5285 • Bblid: 829887
Atdid
12452
Atd Number
ATD-4-5285
Bblid
829887
Inspectionid
357914
Inspect Date
2023-05-23T00:00:00.000
Atdissuedate
2023-05-31T13:46:27.000
Cb
13
House Num
94-59
Onstname
SPRINGFIELD BLVD.
Atddismissed
Yes
Atddismissedon
2023-09-29T14:35:16.000
16546
Atdid: 16546 • Atd Number: ATD-4-6498 • Bblid: 653160
Atdid
16546
Atd Number
ATD-4-6498
Bblid
653160
Inspectionid
386638
Inspect Date
2024-11-25T00:00:00.000
Atdissuedate
2024-12-18T11:56:54.000
Cb
6
House Num
64-37
Onstname
AUSTIN ST.
Atddismissed
No
9875
Atdid: 9875 • Atd Number: ATD-4-4484 • Bblid: 674077
Atdid
9875
Atd Number
ATD-4-4484
Bblid
674077
Inspectionid
334932
Inspect Date
2021-09-30T00:00:00.000
Atdissuedate
2022-04-15T08:48:56.000
Cb
5
House Num
78-45
Onstname
65TH ST.
Atddismissed
No
17653
Atdid: 17653 • Atd Number: ATD-4-6922 • Bblid: 724869
Atdid
17653
Atd Number
ATD-4-6922
Bblid
724869
Inspectionid
397252
Inspect Date
2025-05-15T00:00:00.000
Atdissuedate
2025-05-16T11:26:21.000
Cb
11
House Num
207-27
Onstname
27TH AVE.
Atddismissed
No
10013
Atdid: 10013 • Atd Number: ATD-3-3671 • Bblid: 275678
Atdid
10013
Atd Number
ATD-3-3671
Bblid
275678
Inspectionid
335906
Inspect Date
2022-04-29T00:00:00.000
Atdissuedate
2022-05-02T10:56:47.000
Cb
6
House Num
128
Onstname
BERKELEY PL.
Atddismissed
No
8762
Atdid: 8762 • Atd Number: ATD-3-3212 • Bblid: 264612
Atdid
8762
Atd Number
ATD-3-3212
Bblid
264612
Inspectionid
331135
Inspect Date
2021-12-22T00:00:00.000
Atdissuedate
2021-12-28T15:07:56.000
Cb
7
House Num
445
Onstname
41ST ST.
Atddismissed
No
14972
Atdid: 14972 • Atd Number: ATD-4-6251 • Bblid: 748951
Atdid
14972
Atd Number
ATD-4-6251
Bblid
748951
Inspectionid
381098
Inspect Date
2024-08-06T00:00:00.000
Atdissuedate
2024-08-27T12:07:13.000
Cb
8
House Num
75-34
Onstname
190TH ST.
Atddismissed
No
10523
Atdid: 10523 • Atd Number: ATD-5-668 • Bblid: 932500
Atdid
10523
Atd Number
ATD-5-668
Bblid
932500
Inspectionid
340099
Inspect Date
2022-07-19T00:00:00.000
Atdissuedate
2022-07-19T16:53:59.000
Cb
1
House Num
200
Onstname
MORRISON AVE.
Atddismissed
No
8582
Atdid: 8582 • Atd Number: ATD-4-3854 • Bblid: 836725
Atdid
8582
Atd Number
ATD-4-3854
Bblid
836725
Inspectionid
330522
Inspect Date
2019-07-26T00:00:00.000
Atdissuedate
2021-12-10T10:12:52.000
Cb
12
House Num
114-08
Onstname
194TH ST.
Atddismissed
No
12057
Atdid: 12057 • Atd Number: ATD-4-5136 • Bblid: 745283
Atdid
12057
Atd Number
ATD-4-5136
Bblid
745283
Inspectionid
355983
Inspect Date
2023-04-05T00:00:00.000
Atdissuedate
2023-04-17T13:48:08.000
Cb
8
House Num
76-39
Onstname
167TH ST.
Atddismissed
No
16957
Atdid: 16957 • Atd Number: ATD-4-6662 • Bblid: 830544
Atdid
16957
Atd Number
ATD-4-6662
Bblid
830544
Inspectionid
391541
Inspect Date
2025-03-13T00:00:00.000
Atdissuedate
2025-03-18T10:12:45.000
Cb
13
House Num
92-41
Onstname
224TH ST.
Atddismissed
No
10796
Atdid: 10796 • Atd Number: ATD-3-4173 • Bblid: 551677
Atdid
10796
Atd Number
ATD-3-4173
Bblid
551677
Inspectionid
342987
Inspect Date
2022-09-08T00:00:00.000
Atdissuedate
2022-09-08T11:12:23.000
Cb
18
House Num
1834
Onstname
E. 51ST ST.
Atddismissed
No
13575
Atdid: 13575 • Atd Number: ATD-2-1248 • Bblid: 141084
Atdid
13575
Atd Number
ATD-2-1248
Bblid
141084
Inspectionid
365200
Inspect Date
2023-10-05T00:00:00.000
Atdissuedate
2023-10-12T09:55:56.000
Cb
4
House Num
591
Onstname
WALTON AVE.
Atddismissed
No
12100
Atdid: 12100 • Atd Number: ATD-3-4955 • Bblid: 268796
Atdid
12100
Atd Number
ATD-3-4955
Bblid
268796
Inspectionid
356317
Inspect Date
2023-04-19T00:00:00.000
Atdissuedate
2023-04-26T14:01:04.000
Cb
7
House Num
423
Onstname
54TH ST.
Atddismissed
No
14327
Atdid: 14327 • Atd Number: ATD-3-5908 • Bblid: 279232
Atdid
14327
Atd Number
ATD-3-5908
Bblid
279232
Inspectionid
375928
Inspect Date
2024-04-11T00:00:00.000
Atdissuedate
2024-04-23T11:53:44.000
Cb
6
House Num
246
Onstname
10TH ST.
Atddismissed
No
14407
Atdid: 14407 • Atd Number: ATD-4-6021 • Bblid: 896625
Atdid
14407
Atd Number
ATD-4-6021
Bblid
896625
Inspectionid
376861
Inspect Date
2024-05-06T00:00:00.000
Atdissuedate
2024-05-07T07:50:10.000
Cb
13
House Num
149-72
Onstname
WELLER LN.
Atddismissed
No
17959
Atdid: 17959 • Atd Number: ATD-4-7091 • Bblid: 805713
Atdid
17959
Atd Number
ATD-4-7091
Bblid
805713
Inspectionid
400790
Inspect Date
2025-06-23T00:00:00.000
Atdissuedate
2025-06-23T15:44:23.000
Cb
8
House Num
147-30
Onstname
84TH AVE.
Atddismissed
No
18608
Atdid: 18608 • Atd Number: ATD-3-7333 • Bblid: 551165
Atdid
18608
Atd Number
ATD-3-7333
Bblid
551165
Inspectionid
405950
Inspect Date
2025-08-13T00:00:00.000
Atdissuedate
2025-09-16T12:32:34.000
Cb
18
House Num
1826
Onstname
E. 38TH ST.
Atddismissed
No
10706
Atdid: 10706 • Atd Number: ATD-3-4089 • Bblid: 255484
Atdid
10706
Atd Number
ATD-3-4089
Bblid
255484
Inspectionid
342188
Inspect Date
2022-08-26T00:00:00.000
Atdissuedate
2022-08-29T14:12:30.000
Cb
6
House Num
326
Onstname
CLINTON ST.
Atddismissed
Yes
Atddismissedon
2023-02-24T13:21:19.000
16472
Atdid: 16472 • Atd Number: ATD-4-6485 • Bblid: 578285
Atdid
16472
Atd Number
ATD-4-6485
Bblid
578285
Inspectionid
385694
Inspect Date
2024-11-25T00:00:00.000
Atdissuedate
2024-12-02T14:18:27.000
Cb
1
House Num
32-07
Onstname
35TH AVE.
Atddismissed
No
9418
Atdid: 9418 • Atd Number: ATD-4-4219 • Bblid: 683591
Atdid
9418
Atd Number
ATD-4-4219
Bblid
683591
Inspectionid
333199
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-03-04T10:41:57.000
Cb
7
House Num
15-28
Onstname
PARSONS BLVD.
Atddismissed
No
13225
Atdid: 13225 • Atd Number: ATD-3-5396 • Bblid: 422667
Atdid
13225
Atd Number
ATD-3-5396
Bblid
422667
Inspectionid
362045
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T15:28:33.000
Cb
12
House Num
1735
Onstname
46TH ST.
Atddismissed
No
10142
Atdid: 10142 • Atd Number: ATD-3-3756 • Bblid: 362260
Atdid
10142
Atd Number
ATD-3-3756
Bblid
362260
Inspectionid
336810
Inspect Date
2022-05-19T00:00:00.000
Atdissuedate
2022-05-23T14:02:18.000
Cb
4
House Num
83A
Onstname
COOPER ST.
Atddismissed
No
14558
Atdid: 14558 • Atd Number: ATD-3-6017 • Bblid: 425005
Atdid
14558
Atd Number
ATD-3-6017
Bblid
425005
Inspectionid
378112
Inspect Date
2018-11-07T00:00:00.000
Atdissuedate
2024-06-03T16:20:21.000
Cb
12
House Num
1027
Onstname
DAHILL RD.
Atddismissed
No
18356
Atdid: 18356 • Atd Number: ATD-3-7240 • Bblid: 307021
Atdid
18356
Atd Number
ATD-3-7240
Bblid
307021
Inspectionid
404426
Inspect Date
2025-08-12T00:00:00.000
Atdissuedate
2025-08-18T13:41:12.000
Cb
3
House Num
283
Onstname
VAN BUREN ST.
Atddismissed
No
17919
Atdid: 17919 • Atd Number: ATD-4-7083 • Bblid: 810781
Atdid
17919
Atd Number
ATD-4-7083
Bblid
810781
Inspectionid
400618
Inspect Date
2025-06-09T00:00:00.000
Atdissuedate
2025-06-18T14:40:37.000
Cb
8
House Num
86-45
Onstname
MIDLAND PKWY.
Atddismissed
No
12802
Atdid: 12802 • Atd Number: ATD-3-5136 • Bblid: 484766
Atdid
12802
Atd Number
ATD-3-5136
Bblid
484766
Inspectionid
359734
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-07-10T15:40:19.000
Cb
15
House Num
1734
Onstname
E. 23RD ST.
Atddismissed
No
13108
Atdid: 13108 • Atd Number: ATD-3-5324 • Bblid: 432750
Atdid
13108
Atd Number
ATD-3-5324
Bblid
432750
Inspectionid
361399
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T11:40:59.000
Cb
12
House Num
1432
Onstname
46 STREET
Atddismissed
No
11752
Atdid: 11752 • Atd Number: ATD-3-4780 • Bblid: 296934
Atdid
11752
Atd Number
ATD-3-4780
Bblid
296934
Inspectionid
352529
Inspect Date
2023-03-09T00:00:00.000
Atdissuedate
2023-03-09T11:21:38.000
Cb
8
House Num
1496
Onstname
PROSPECT PL.
Atddismissed
No
10164
Atdid: 10164 • Atd Number: ATD-3-3776 • Bblid: 269528
Atdid
10164
Atd Number
ATD-3-3776
Bblid
269528
Inspectionid
336884
Inspect Date
2022-05-13T00:00:00.000
Atdissuedate
2022-05-23T15:02:54.000
Cb
7
House Num
465
Onstname
56TH ST.
Atddismissed
No
11015
Atdid: 11015 • Atd Number: ATD-3-4367 • Bblid: 267208
Atdid
11015
Atd Number
ATD-3-4367
Bblid
267208
Inspectionid
344572
Inspect Date
2022-09-20T00:00:00.000
Atdissuedate
2022-09-26T12:35:09.000
Cb
7
House Num
447
Onstname
50TH ST.
Atddismissed
No
12830
Atdid: 12830 • Atd Number: ATD-4-5427 • Bblid: 1117818
Atdid
12830
Atd Number
ATD-4-5427
Bblid
1117818
Inspectionid
359904
Inspect Date
2023-07-12T00:00:00.000
Atdissuedate
2023-07-12T16:43:23.000
Cb
0
House Num
42-33
Onstname
MAIN STREET
Atddismissed
No
18067
Atdid: 18067 • Atd Number: ATD-3-7118 • Bblid: 513160
Atdid
18067
Atd Number
ATD-3-7118
Bblid
513160
Inspectionid
402223
Inspect Date
2025-07-12T00:00:00.000
Atdissuedate
2025-07-14T11:53:38.000
Cb
15
House Num
2638
Onstname
FORD ST.
Atddismissed
No
3150
Atdid: 3150 • Atd Number: ATD-3-2212 • Bblid: 251290
Atdid
3150
Atd Number
ATD-3-2212
Bblid
251290
Violationid
251727
Atdissuedate
2020-02-13T00:00:00.000
Cb
2
House Num
126
Onstname
DEAN STREET
Atddismissed
Yes
Atddismissedon
2023-02-07T12:42:38.000
3139
Atdid: 3139 • Atd Number: ATD-4-80 • Bblid: 783380
Atdid
3139
Atd Number
ATD-4-80
Bblid
783380
Violationid
122062
Atdissuedate
2020-08-13T00:00:00.000
Cb
9
House Num
97-41
Onstname
DREW STREET
Atddismissed
Yes
Atddismissedon
2025-07-31T13:10:45.000
11883
Atdid: 11883 • Atd Number: ATD-3-4855 • Bblid: 452436
Atdid
11883
Atd Number
ATD-3-4855
Bblid
452436
Inspectionid
353807
Inspect Date
2023-03-02T00:00:00.000
Atdissuedate
2023-03-24T14:52:06.000
Cb
10
House Num
239
Onstname
91ST ST.
Atddismissed
No
13411
Atdid: 13411 • Atd Number: ATD-3-5526 • Bblid: 413215
Atdid
13411
Atd Number
ATD-3-5526
Bblid
413215
Inspectionid
363636
Inspect Date
2023-09-08T00:00:00.000
Atdissuedate
2023-09-18T09:04:29.000
Cb
17
House Num
2715
Onstname
FOSTER AVE.
Atddismissed
No
10913
Atdid: 10913 • Atd Number: ATD-3-4284 • Bblid: 271286
Atdid
10913
Atd Number
ATD-3-4284
Bblid
271286
Inspectionid
343718
Inspect Date
2022-09-08T00:00:00.000
Atdissuedate
2022-09-13T07:49:48.000
Cb
7
House Num
503
Onstname
17TH ST.
Atddismissed
No
17701
Atdid: 17701 • Atd Number: ATD-4-6956 • Bblid: 881828
Atdid
17701
Atd Number
ATD-4-6956
Bblid
881828
Inspectionid
398095
Inspect Date
2025-05-08T00:00:00.000
Atdissuedate
2025-05-21T13:46:59.000
Cb
13
House Num
226-64
Onstname
129TH AVE.
Atddismissed
No
17946
Atdid: 17946 • Atd Number: ATD-3-7063 • Bblid: 285027
Atdid
17946
Atd Number
ATD-3-7063
Bblid
285027
Inspectionid
400733
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-23T10:00:40.000
Cb
7
House Num
6
Onstname
FULLER PL.
Atddismissed
No
13993
Atdid: 13993 • Atd Number: ATD-4-5823 • Bblid: 886849
Atdid
13993
Atd Number
ATD-4-5823
Bblid
886849
Inspectionid
371980
Inspect Date
2024-02-10T00:00:00.000
Atdissuedate
2024-02-20T15:57:11.000
Cb
13
House Num
134-38
Onstname
228TH ST.
Atddismissed
No
17220
Atdid: 17220 • Atd Number: ATD-5-951 • Bblid: 1054704
Atdid
17220
Atd Number
ATD-5-951
Bblid
1054704
Inspectionid
392932
Inspect Date
2025-03-25T00:00:00.000
Atdissuedate
2025-04-01T13:27:13.000
Cb
3
House Num
108
Onstname
HECKER ST.
Atddismissed
No
8964
Atdid: 8964 • Atd Number: ATD-4-4063 • Bblid: 671753
Atdid
8964
Atd Number
ATD-4-4063
Bblid
671753
Inspectionid
332265
Inspect Date
2019-07-26T00:00:00.000
Atdissuedate
2022-02-04T15:07:01.000
Cb
5
House Num
70-19
Onstname
68TH PL.
Atddismissed
No
13695
Atdid: 13695 • Atd Number: ATD-3-5650 • Bblid: 360943
Atdid
13695
Atd Number
ATD-3-5650
Bblid
360943
Inspectionid
367642
Inspect Date
2023-11-16T00:00:00.000
Atdissuedate
2023-11-16T12:13:13.000
Cb
4
House Num
40
Onstname
ELDERT ST.
Atddismissed
No
14150
Atdid: 14150 • Atd Number: ATD-3-5812 • Bblid: 481932
Atdid
14150
Atd Number
ATD-3-5812
Bblid
481932
Inspectionid
373496
Inspect Date
2024-03-12T00:00:00.000
Atdissuedate
2024-03-18T16:36:43.000
Cb
14
House Num
1365
Onstname
E. 16TH ST.
Atddismissed
No
14441
Atdid: 14441 • Atd Number: ATD-4-6023 • Bblid: 825320
Atdid
14441
Atd Number
ATD-4-6023
Bblid
825320
Violationid
130811
Inspectionid
143889
Inspect Date
2024-05-09T11:42:01.000
Atdissuedate
2024-05-09T11:42:01.000
Cb
13
House Num
89-23
Onstname
208 STREET
Atddismissed
No
12892
Atdid: 12892 • Atd Number: ATD-3-5182 • Bblid: 510415
Atdid
12892
Atd Number
ATD-3-5182
Bblid
510415
Inspectionid
360280
Inspect Date
2023-07-19T00:00:00.000
Atdissuedate
2023-07-19T13:26:41.000
Cb
15
House Num
2455
Onstname
E. 28TH ST.
Atddismissed
No
18456
Atdid: 18456 • Atd Number: ATD-4-7311 • Bblid: 588930
Atdid
18456
Atd Number
ATD-4-7311
Bblid
588930
Inspectionid
404992
Inspect Date
2025-08-28T00:00:00.000
Atdissuedate
2025-08-28T13:04:03.000
Cb
1
House Num
20-06
Onstname
27TH ST.
Atddismissed
No
17749
Atdid: 17749 • Atd Number: ATD-4-6983 • Bblid: 847321
Atdid
17749
Atd Number
ATD-4-6983
Bblid
847321
Inspectionid
398706
Inspect Date
2023-10-12T00:00:00.000
Atdissuedate
2025-05-28T08:36:09.000
Cb
10
House Num
149-09
Onstname
85TH ST.
Atddismissed
No
NYC Data AI • Public-data exploration interface