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
13756
Atdid: 13756 • Atd Number: ATD-4-5667 • Bblid: 656983
Atdid
13756
Atd Number
ATD-4-5667
Bblid
656983
Inspectionid
369157
Inspect Date
2023-12-08T00:00:00.000
Atdissuedate
2023-12-08T08:22:51.000
Cb
6
House Num
72-87
Onstname
YELLOWSTONE BLVD.
Atddismissed
No
11729
Atdid: 11729 • Atd Number: ATD-3-4769 • Bblid: 481027
Atdid
11729
Atd Number
ATD-3-4769
Bblid
481027
Inspectionid
352163
Inspect Date
2023-01-27T00:00:00.000
Atdissuedate
2023-02-28T09:59:33.000
Cb
14
House Num
1118
Onstname
E. 13TH ST.
Atddismissed
No
13807
Atdid: 13807 • Atd Number: ATD-4-5702 • Bblid: 861054
Atdid
13807
Atd Number
ATD-4-5702
Bblid
861054
Inspectionid
370028
Inspect Date
2023-11-22T00:00:00.000
Atdissuedate
2023-12-22T12:53:10.000
Cb
12
House Num
111-39
Onstname
INWOOD ST.
Atddismissed
No
11926
Atdid: 11926 • Atd Number: ATD-3-4877 • Bblid: 286540
Atdid
11926
Atd Number
ATD-3-4877
Bblid
286540
Inspectionid
354178
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-29T12:38:28.000
Cb
8
House Num
201
Onstname
PROSPECT PL.
Atddismissed
No
12050
Atdid: 12050 • Atd Number: ATD-2-1015 • Bblid: 225451
Atdid
12050
Atd Number
ATD-2-1015
Bblid
225451
Inspectionid
355972
Inspect Date
2023-03-24T00:00:00.000
Atdissuedate
2023-04-17T13:32:46.000
Cb
12
House Num
4225
Onstname
GRACE AVE.
Atddismissed
No
17958
Atdid: 17958 • Atd Number: ATD-3-7073 • Bblid: 456457
Atdid
17958
Atd Number
ATD-3-7073
Bblid
456457
Inspectionid
400775
Inspect Date
2025-06-12T00:00:00.000
Atdissuedate
2025-06-23T11:51:13.000
Cb
11
House Num
7115
Onstname
20TH AVE.
Atddismissed
Yes
Atddismissedon
2025-08-05T12:43:41.000
10688
Atdid: 10688 • Atd Number: ATD-4-4791 • Bblid: 774278
Atdid
10688
Atd Number
ATD-4-4791
Bblid
774278
Inspectionid
342054
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-08-26T10:33:21.000
Cb
13
House Num
82-54
Onstname
261ST ST.
Atddismissed
No
17942
Atdid: 17942 • Atd Number: ATD-3-7059 • Bblid: 285033
Atdid
17942
Atd Number
ATD-3-7059
Bblid
285033
Inspectionid
400727
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-23T09:55:08.000
Cb
7
House Num
18
Onstname
FULLER PL.
Atddismissed
No
10194
Atdid: 10194 • Atd Number: ATD-3-3786 • Bblid: 282102
Atdid
10194
Atd Number
ATD-3-3786
Bblid
282102
Inspectionid
337141
Inspect Date
2022-05-14T00:00:00.000
Atdissuedate
2022-06-01T11:35:39.000
Cb
6
House Num
845
Onstname
CARROLL ST.
Atddismissed
No
10023
Atdid: 10023 • Atd Number: ATD-4-4567 • Bblid: 654634
Atdid
10023
Atd Number
ATD-4-4567
Bblid
654634
Inspectionid
336002
Inspect Date
2022-04-22T00:00:00.000
Atdissuedate
2022-05-03T11:15:08.000
Cb
6
House Num
62-41
Onstname
DIETERLE CRES
Atddismissed
No
4685
Atdid: 4685 • Atd Number: ATD-4-1216 • Bblid: 766136
Atdid
4685
Atd Number
ATD-4-1216
Bblid
766136
Violationid
204694
Atdissuedate
2020-04-16T00:00:00.000
Cb
11
House Num
48-60
Onstname
GLENWOOD STREET
Atddismissed
Yes
Atddismissedon
2024-11-27T11:21:25.000
14370
Atdid: 14370 • Atd Number: ATD-3-5927 • Bblid: 456930
Atdid
14370
Atd Number
ATD-3-5927
Bblid
456930
Inspectionid
376260
Inspect Date
2024-04-17T00:00:00.000
Atdissuedate
2024-04-29T10:48:03.000
Cb
11
House Num
1743
Onstname
73RD ST.
Atddismissed
No
17536
Atdid: 17536 • Atd Number: ATD-4-6848 • Bblid: 678650
Atdid
17536
Atd Number
ATD-4-6848
Bblid
678650
Inspectionid
396272
Inspect Date
2025-04-29T00:00:00.000
Atdissuedate
2025-05-05T14:14:14.000
Cb
6
House Num
97-20
Onstname
72ND DR.
Atddismissed
No
11309
Atdid: 11309 • Atd Number: ATD-1-212 • Bblid: 116823
Atdid
11309
Atd Number
ATD-1-212
Bblid
116823
Inspectionid
347347
Inspect Date
2022-11-01T00:00:00.000
Atdissuedate
2022-11-01T12:55:01.000
Cb
10
House Num
20
Onstname
W. 126TH ST.
Atddismissed
No
18045
Atdid: 18045 • Atd Number: ATD-3-7107 • Bblid: 321186
Atdid
18045
Atd Number
ATD-3-7107
Bblid
321186
Inspectionid
402032
Inspect Date
2025-07-10T00:00:00.000
Atdissuedate
2025-07-10T12:00:15.000
Cb
2
House Num
123
Onstname
RYERSON ST.
Atddismissed
No
6143
Atdid: 6143 • Atd Number: ATD-4-2504 • Bblid: 906905
Atdid
6143
Atd Number
ATD-4-2504
Bblid
906905
Violationid
238724
Atdissuedate
2020-02-21T00:00:00.000
Cb
14
House Num
8-37
Onstname
CORNAGA AVENUE
Atddismissed
No
13152
Atdid: 13152 • Atd Number: ATD-3-5352 • Bblid: 294515
Atdid
13152
Atd Number
ATD-3-5352
Bblid
294515
Inspectionid
361584
Inspect Date
2023-07-14T00:00:00.000
Atdissuedate
2023-08-07T09:41:34.000
Cb
9
House Num
195
Onstname
LEFFERTS AVE.
Atddismissed
No
14311
Atdid: 14311 • Atd Number: ATD-4-5972 • Bblid: 656440
Atdid
14311
Atd Number
ATD-4-5972
Bblid
656440
Inspectionid
375776
Inspect Date
2024-04-22T00:00:00.000
Atdissuedate
2024-04-22T12:03:28.000
Cb
6
House Num
69-20
Onstname
ALDERTON ST.
Atddismissed
No
14741
Atdid: 14741 • Atd Number: ATD-4-6147 • Bblid: 704601
Atdid
14741
Atd Number
ATD-4-6147
Bblid
704601
Inspectionid
379359
Inspect Date
2024-07-02T00:00:00.000
Atdissuedate
2024-07-15T13:29:03.000
Cb
7
House Num
41-34
Onstname
COLLEGE POINT BLVD
Atddismissed
Yes
Atddismissedon
2024-11-06T10:42:32.000
8676
Atdid: 8676 • Atd Number: ATD-3-3180 • Bblid: 518072
Atdid
8676
Atd Number
ATD-3-3180
Bblid
518072
Inspectionid
330845
Inspect Date
2020-11-19T00:00:00.000
Atdissuedate
2021-12-17T09:02:40.000
Cb
18
House Num
1391
Onstname
E. 35TH ST.
Atddismissed
No
17646
Atdid: 17646 • Atd Number: ATD-4-6915 • Bblid: 761103
Atdid
17646
Atd Number
ATD-4-6915
Bblid
761103
Inspectionid
397233
Inspect Date
2025-02-11T00:00:00.000
Atdissuedate
2025-05-16T10:53:06.000
Cb
13
House Num
239-15
Onstname
88TH AVE.
Atddismissed
No
10109
Atdid: 10109 • Atd Number: ATD-3-3726 • Bblid: 279859
Atdid
10109
Atd Number
ATD-3-3726
Bblid
279859
Inspectionid
336525
Inspect Date
2021-09-02T00:00:00.000
Atdissuedate
2022-05-17T11:44:21.000
Cb
6
House Num
345
Onstname
13TH ST.
Atddismissed
No
16884
Atdid: 16884 • Atd Number: ATD-5-928 • Bblid: 924216
Atdid
16884
Atd Number
ATD-5-928
Bblid
924216
Inspectionid
390540
Inspect Date
2025-03-07T00:00:00.000
Atdissuedate
2025-03-08T08:42:58.000
Cb
1
House Num
18-20
Onstname
CLINTON AVENUE
Atddismissed
No
12527
Atdid: 12527 • Atd Number: ATD-3-5065 • Bblid: 458356
Atdid
12527
Atd Number
ATD-3-5065
Bblid
458356
Inspectionid
358279
Inspect Date
2023-05-25T00:00:00.000
Atdissuedate
2023-06-07T10:20:13.000
Cb
10
House Num
7524
Onstname
12TH AVE.
Atddismissed
No
11808
Atdid: 11808 • Atd Number: ATD-3-4803 • Bblid: 296785
Atdid
11808
Atd Number
ATD-3-4803
Bblid
296785
Inspectionid
353153
Inspect Date
2023-03-17T00:00:00.000
Atdissuedate
2023-03-17T12:10:05.000
Cb
8
House Num
1423
Onstname
STERLING PL.
Atddismissed
No
11961
Atdid: 11961 • Atd Number: ATD-4-5089 • Bblid: 875526
Atdid
11961
Atd Number
ATD-4-5089
Bblid
875526
Inspectionid
354351
Inspect Date
2023-03-02T00:00:00.000
Atdissuedate
2023-04-03T12:02:59.000
Cb
12
House Num
175-18
Onstname
139TH RD.
Atddismissed
No
11102
Atdid: 11102 • Atd Number: ATD-4-4831 • Bblid: 786648
Atdid
11102
Atd Number
ATD-4-4831
Bblid
786648
Inspectionid
345228
Inspect Date
2022-09-29T00:00:00.000
Atdissuedate
2022-10-05T12:48:00.000
Cb
10
House Num
89-13
Onstname
107TH AVE.
Atddismissed
No
13284
Atdid: 13284 • Atd Number: ATD-3-5444 • Bblid: 424095
Atdid
13284
Atd Number
ATD-3-5444
Bblid
424095
Inspectionid
362337
Inspect Date
2023-08-15T00:00:00.000
Atdissuedate
2023-08-22T11:13:55.000
Cb
12
House Num
1678
Onstname
52ND ST.
Atddismissed
No
11365
Atdid: 11365 • Atd Number: ATD-3-4631 • Bblid: 400857
Atdid
11365
Atd Number
ATD-3-4631
Bblid
400857
Inspectionid
347810
Inspect Date
2022-11-02T00:00:00.000
Atdissuedate
2022-11-07T15:42:08.000
Cb
17
House Num
882
Onstname
BROOKLYN AVE.
Atddismissed
No
12688
Atdid: 12688 • Atd Number: ATD-5-724 • Bblid: 1021877
Atdid
12688
Atd Number
ATD-5-724
Bblid
1021877
Inspectionid
359092
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-29T12:54:14.000
Cb
3
House Num
497
Onstname
DOANE AVE.
Atddismissed
No
18288
Atdid: 18288 • Atd Number: ATD-4-7224 • Bblid: 854236
Atdid
18288
Atd Number
ATD-4-7224
Bblid
854236
Inspectionid
403933
Inspect Date
2025-07-31T00:00:00.000
Atdissuedate
2025-08-11T11:50:07.000
Cb
10
House Num
116-41
Onstname
127TH ST.
Atddismissed
No
10106
Atdid: 10106 • Atd Number: ATD-3-3723 • Bblid: 279847
Atdid
10106
Atd Number
ATD-3-3723
Bblid
279847
Inspectionid
336520
Inspect Date
2021-09-02T00:00:00.000
Atdissuedate
2022-05-17T11:37:33.000
Cb
6
House Num
355
Onstname
13TH ST.
Atddismissed
No
16506
Atdid: 16506 • Atd Number: ATD-5-898 • Bblid: 989818
Atdid
16506
Atd Number
ATD-5-898
Bblid
989818
Inspectionid
386049
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2024-12-12T09:58:37.000
Cb
2
House Num
29
Onstname
ATLANTIC AVE.
Atddismissed
No
14046
Atdid: 14046 • Atd Number: ATD-1-309 • Bblid: 136771
Atdid
14046
Atd Number
ATD-1-309
Bblid
136771
Inspectionid
372625
Inspect Date
2021-12-17T00:00:00.000
Atdissuedate
2024-03-01T13:31:43.000
Cb
8
House Num
39
Onstname
ADRIAN AVE.
Atddismissed
No
11442
Atdid: 11442 • Atd Number: ATD-2-960 • Bblid: 172868
Atdid
11442
Atd Number
ATD-2-960
Bblid
172868
Inspectionid
348536
Inspect Date
2022-10-07T00:00:00.000
Atdissuedate
2022-11-22T12:57:44.000
Cb
9
House Num
630
Onstname
COMMONWEALTH AVE.
Atddismissed
No
17706
Atdid: 17706 • Atd Number: ATD-4-6958 • Bblid: 695868
Atdid
17706
Atd Number
ATD-4-6958
Bblid
695868
Inspectionid
398174
Inspect Date
2025-05-21T00:00:00.000
Atdissuedate
2025-05-22T10:08:32.000
Cb
7
House Num
25-12
Onstname
160TH ST.
Atddismissed
No
18090
Atdid: 18090 • Atd Number: ATD-4-7147 • Bblid: 742270
Atdid
18090
Atd Number
ATD-4-7147
Bblid
742270
Inspectionid
402365
Inspect Date
2025-07-11T00:00:00.000
Atdissuedate
2025-07-14T15:04:39.000
Cb
8
House Num
161-09
Onstname
84TH AVE.
Atddismissed
No
11659
Atdid: 11659 • Atd Number: ATD-3-4738 • Bblid: 420015
Atdid
11659
Atd Number
ATD-3-4738
Bblid
420015
Inspectionid
351576
Inspect Date
2023-02-14T00:00:00.000
Atdissuedate
2023-02-15T11:21:32.000
Cb
12
House Num
508
Onstname
E. 5TH ST.
Atddismissed
No
18052
Atdid: 18052 • Atd Number: ATD-4-7130 • Bblid: 765941
Atdid
18052
Atd Number
ATD-4-7130
Bblid
765941
Inspectionid
402091
Inspect Date
2025-07-09T00:00:00.000
Atdissuedate
2025-07-11T14:03:14.000
Cb
11
House Num
49-57
Onstname
ANNANDALE LN.
Atddismissed
No
10610
Atdid: 10610 • Atd Number: ATD-3-4030 • Bblid: 342866
Atdid
10610
Atd Number
ATD-3-4030
Bblid
342866
Inspectionid
341010
Inspect Date
2022-07-13T00:00:00.000
Atdissuedate
2022-08-08T10:43:08.000
Cb
1
House Num
595
Onstname
LEONARD ST.
Atddismissed
No
18593
Atdid: 18593 • Atd Number: ATD-3-7326 • Bblid: 385977
Atdid
18593
Atd Number
ATD-3-7326
Bblid
385977
Inspectionid
405764
Inspect Date
2025-06-12T00:00:00.000
Atdissuedate
2025-09-15T09:50:52.000
Cb
5
House Num
721
Onstname
ASHFORD ST.
Atddismissed
No
14328
Atdid: 14328 • Atd Number: ATD-3-5909 • Bblid: 521186
Atdid
14328
Atd Number
ATD-3-5909
Bblid
521186
Inspectionid
375936
Inspect Date
2024-02-21T00:00:00.000
Atdissuedate
2024-04-23T12:35:12.000
Cb
17
House Num
4012
Onstname
GLENWOOD RD.
Atddismissed
No
9008
Atdid: 9008 • Atd Number: ATD-3-3290 • Bblid: 302051
Atdid
9008
Atd Number
ATD-3-3290
Bblid
302051
Inspectionid
332350
Inspect Date
2019-08-20T00:00:00.000
Atdissuedate
2022-02-10T09:07:14.000
Cb
3
House Num
615
Onstname
DECATUR ST.
Atddismissed
No
11496
Atdid: 11496 • Atd Number: ATD-3-4694 • Bblid: 356166
Atdid
11496
Atd Number
ATD-3-4694
Bblid
356166
Inspectionid
349198
Inspect Date
2022-12-09T00:00:00.000
Atdissuedate
2022-12-12T13:32:35.000
Cb
4
House Num
1356
Onstname
GREENE AVE.
Atddismissed
No
12895
Atdid: 12895 • Atd Number: ATD-3-5185 • Bblid: 431784
Atdid
12895
Atd Number
ATD-3-5185
Bblid
431784
Inspectionid
360290
Inspect Date
2023-07-19T00:00:00.000
Atdissuedate
2023-07-19T15:58:13.000
Cb
12
House Num
1416
Onstname
43RD ST.
Atddismissed
No
16731
Atdid: 16731 • Atd Number: ATD-3-6558 • Bblid: 277635
Atdid
16731
Atd Number
ATD-3-6558
Bblid
277635
Inspectionid
388927
Inspect Date
2025-01-04T00:00:00.000
Atdissuedate
2025-01-24T10:58:13.000
Cb
6
House Num
318
Onstname
4TH ST.
Atddismissed
No
10823
Atdid: 10823 • Atd Number: ATD-3-4194 • Bblid: 309137
Atdid
10823
Atd Number
ATD-3-4194
Bblid
309137
Inspectionid
343319
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-09-12T09:50:48.000
Cb
3
House Num
541
Onstname
HANCOCK ST.
Atddismissed
No
8863
Atdid: 8863 • Atd Number: ATD-4-4006 • Bblid: 619287
Atdid
8863
Atd Number
ATD-4-4006
Bblid
619287
Inspectionid
331826
Inspect Date
2022-01-13T00:00:00.000
Atdissuedate
2022-01-24T12:03:59.000
Cb
3
House Num
104-14
Onstname
37TH DR.
Atddismissed
No
12626
Atdid: 12626 • Atd Number: ATD-1-297 • Bblid: 132357
Atdid
12626
Atd Number
ATD-1-297
Bblid
132357
Inspectionid
358843
Inspect Date
2022-11-03T00:00:00.000
Atdissuedate
2023-06-22T09:32:22.000
Cb
9
House Num
459
Onstname
W. 148TH ST.
Atddismissed
No
10578
Atdid: 10578 • Atd Number: ATD-4-4762 • Bblid: 770844
Atdid
10578
Atd Number
ATD-4-4762
Bblid
770844
Inspectionid
340582
Inspect Date
2022-07-19T00:00:00.000
Atdissuedate
2022-07-29T11:07:04.000
Cb
13
House Num
85-19
Onstname
250TH ST.
Atddismissed
No
NYC Data AI • Public-data exploration interface