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
13720
Atdid: 13720 • Atd Number: ATD-4-5654 • Bblid: 571208
Atdid
13720
Atd Number
ATD-4-5654
Bblid
571208
Inspectionid
368705
Inspect Date
2023-11-30T00:00:00.000
Atdissuedate
2023-12-01T15:12:26.000
Cb
2
House Num
50-48
Onstname
40TH ST.
Atddismissed
No
14917
Atdid: 14917 • Atd Number: ATD-3-6200 • Bblid: 533926
Atdid
14917
Atd Number
ATD-3-6200
Bblid
533926
Inspectionid
380689
Inspect Date
2024-08-16T00:00:00.000
Atdissuedate
2024-08-16T10:16:44.000
Cb
18
House Num
2
Onstname
PAERDEGAT 1 STREET
Atddismissed
No
18222
Atdid: 18222 • Atd Number: ATD-3-7186 • Bblid: 540586
Atdid
18222
Atd Number
ATD-3-7186
Bblid
540586
Inspectionid
403459
Inspect Date
2025-07-10T00:00:00.000
Atdissuedate
2025-07-31T10:11:59.000
Cb
18
House Num
1311
Onstname
E. 91ST ST.
Atddismissed
No
14188
Atdid: 14188 • Atd Number: ATD-3-5848 • Bblid: 532380
Atdid
14188
Atd Number
ATD-3-5848
Bblid
532380
Inspectionid
373804
Inspect Date
2024-03-20T00:00:00.000
Atdissuedate
2024-03-20T14:45:03.000
Cb
18
House Num
609
Onstname
E. 83RD ST.
Atddismissed
No
14614
Atdid: 14614 • Atd Number: ATD-3-6051 • Bblid: 486060
Atdid
14614
Atd Number
ATD-3-6051
Bblid
486060
Inspectionid
378519
Inspect Date
2024-05-29T00:00:00.000
Atdissuedate
2024-06-17T13:11:24.000
Cb
15
House Num
1846
Onstname
E. 29TH ST.
Atddismissed
No
18203
Atdid: 18203 • Atd Number: ATD-4-7191 • Bblid: 878740
Atdid
18203
Atd Number
ATD-4-7191
Bblid
878740
Inspectionid
403286
Inspect Date
2025-07-23T00:00:00.000
Atdissuedate
2025-07-28T13:05:17.000
Cb
12
House Num
186-23
Onstname
PINEVILLE LN.
Atddismissed
No
13844
Atdid: 13844 • Atd Number: ATD-3-5690 • Bblid: 519355
Atdid
13844
Atd Number
ATD-3-5690
Bblid
519355
Inspectionid
370420
Inspect Date
2024-01-03T00:00:00.000
Atdissuedate
2024-01-08T12:31:05.000
Cb
18
House Num
1608
Onstname
E. 34TH ST.
Atddismissed
No
14466
Atdid: 14466 • Atd Number: ATD-4-6044 • Bblid: 860922
Atdid
14466
Atd Number
ATD-4-6044
Bblid
860922
Inspectionid
377276
Inspect Date
2024-03-12T00:00:00.000
Atdissuedate
2024-05-13T11:39:59.000
Cb
12
House Num
111-47
Onstname
145TH ST.
Atddismissed
No
14214
Atdid: 14214 • Atd Number: ATD-4-5916 • Bblid: 788225
Atdid
14214
Atd Number
ATD-4-5916
Bblid
788225
Inspectionid
374048
Inspect Date
2024-03-07T00:00:00.000
Atdissuedate
2024-03-22T14:53:30.000
Cb
9
House Num
84-48
Onstname
116TH ST.
Atddismissed
No
14865
Atdid: 14865 • Atd Number: ATD-3-6178 • Bblid: 317997
Atdid
14865
Atd Number
ATD-3-6178
Bblid
317997
Inspectionid
380225
Inspect Date
2024-07-26T00:00:00.000
Atdissuedate
2024-08-05T13:35:38.000
Cb
3
House Num
191
Onstname
HANCOCK ST.
Atddismissed
No
17854
Atdid: 17854 • Atd Number: ATD-4-7049 • Bblid: 633571
Atdid
17854
Atd Number
ATD-4-7049
Bblid
633571
Inspectionid
399952
Inspect Date
2025-05-22T00:00:00.000
Atdissuedate
2025-06-11T11:53:13.000
Cb
5
House Num
68-12
Onstname
JAY AVE.
Atddismissed
No
13981
Atdid: 13981 • Atd Number: ATD-4-5812 • Bblid: 827497
Atdid
13981
Atd Number
ATD-4-5812
Bblid
827497
Inspectionid
371917
Inspect Date
2024-02-02T00:00:00.000
Atdissuedate
2024-02-20T09:47:20.000
Cb
13
House Num
90-10
Onstname
215TH PL.
Atddismissed
No
10364
Atdid: 10364 • Atd Number: ATD-3-3877 • Bblid: 314191
Atdid
10364
Atd Number
ATD-3-3877
Bblid
314191
Inspectionid
338518
Inspect Date
2022-06-23T00:00:00.000
Atdissuedate
2022-07-05T11:30:42.000
Cb
3
House Num
237A
Onstname
HART ST.
Atddismissed
No
9946
Atdid: 9946 • Atd Number: ATD-4-4525 • Bblid: 654429
Atdid
9946
Atd Number
ATD-4-4525
Bblid
654429
Inspectionid
335354
Inspect Date
2022-04-12T00:00:00.000
Atdissuedate
2022-04-21T12:20:18.000
Cb
6
House Num
65-43
Onstname
DIETERLE CRES
Atddismissed
No
17418
Atdid: 17418 • Atd Number: ATD-3-6904 • Bblid: 257600
Atdid
17418
Atd Number
ATD-3-6904
Bblid
257600
Inspectionid
395145
Inspect Date
2025-04-23T00:00:00.000
Atdissuedate
2025-04-23T08:27:03.000
Cb
6
House Num
149
Onstname
LUQUER ST.
Atddismissed
No
13892
Atdid: 13892 • Atd Number: ATD-4-5761 • Bblid: 770799
Atdid
13892
Atd Number
ATD-4-5761
Bblid
770799
Inspectionid
371045
Inspect Date
2024-01-25T00:00:00.000
Atdissuedate
2024-01-29T12:18:59.000
Cb
13
House Num
84-56
Onstname
251ST ST.
Atddismissed
No
9624
Atdid: 9624 • Atd Number: ATD-2-891 • Bblid: 154852
Atdid
9624
Atd Number
ATD-2-891
Bblid
154852
Inspectionid
333793
Inspect Date
2020-12-02T00:00:00.000
Atdissuedate
2022-03-15T17:52:44.000
Cb
5
House Num
1660
Onstname
MONTGOMERY AVE.
Atddismissed
No
12450
Atdid: 12450 • Atd Number: ATD-4-5283 • Bblid: 829891
Atdid
12450
Atd Number
ATD-4-5283
Bblid
829891
Inspectionid
357911
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-31T13:40:25.000
Cb
13
House Num
94-51
Onstname
SPRINGFIELD BLVD.
Atddismissed
No
11564
Atdid: 11564 • Atd Number: ATD-4-4933 • Bblid: 579754
Atdid
11564
Atd Number
ATD-4-4933
Bblid
579754
Inspectionid
349888
Inspect Date
2022-12-21T00:00:00.000
Atdissuedate
2022-12-29T13:08:36.000
Cb
1
House Num
31-63
Onstname
36TH ST.
Atddismissed
No
13910
Atdid: 13910 • Atd Number: ATD-4-5767 • Bblid: 860882
Atdid
13910
Atd Number
ATD-4-5767
Bblid
860882
Violationid
290024
Reinspectionid
36280
Inspect Date
2024-02-01T09:53:25.000
Atdissuedate
2024-02-01T09:53:25.000
Cb
12
House Num
111-76
Onstname
145 STREET
Atddismissed
No
9942
Atdid: 9942 • Atd Number: ATD-4-4521 • Bblid: 654409
Atdid
9942
Atd Number
ATD-4-4521
Bblid
654409
Inspectionid
335345
Inspect Date
2022-04-14T00:00:00.000
Atdissuedate
2022-04-21T12:12:16.000
Cb
6
House Num
65-30
Onstname
BOELSEN CRES
Atddismissed
No
6774
Atdid: 6774 • Atd Number: ATD-4-3135 • Bblid: 799822
Atdid
6774
Atd Number
ATD-4-3135
Bblid
799822
Violationid
253597
Atdissuedate
2020-06-24T00:00:00.000
Cb
10
House Num
10733
Onstname
111 STREET
Atddismissed
Yes
Atddismissedon
2021-12-29T10:59:47.000
13691
Atdid: 13691 • Atd Number: ATD-3-5648 • Bblid: 332174
Atdid
13691
Atd Number
ATD-3-5648
Bblid
332174
Inspectionid
367569
Inspect Date
2023-10-19T00:00:00.000
Atdissuedate
2023-11-16T08:41:08.000
Cb
1
House Num
207
Onstname
HOOPER ST.
Atddismissed
No
10636
Atdid: 10636 • Atd Number: ATD-4-4780 • Bblid: 753827
Atdid
10636
Atd Number
ATD-4-4780
Bblid
753827
Inspectionid
341274
Inspect Date
2022-08-06T00:00:00.000
Atdissuedate
2022-08-09T16:22:58.000
Cb
11
House Num
56-40
Onstname
203RD ST.
Atddismissed
No
16757
Atdid: 16757 • Atd Number: ATD-3-6568 • Bblid: 423328
Atdid
16757
Atd Number
ATD-3-6568
Bblid
423328
Violationid
72487
Inspectionid
389036
Inspect Date
2025-01-30T08:41:31.000
Atdissuedate
2025-01-30T08:41:31.000
Cb
12
House Num
1536
Onstname
50 STREET
Atddismissed
No
10997
Atdid: 10997 • Atd Number: ATD-3-4350 • Bblid: 318201
Atdid
10997
Atd Number
ATD-3-4350
Bblid
318201
Inspectionid
344478
Inspect Date
2022-09-17T00:00:00.000
Atdissuedate
2022-09-23T16:50:02.000
Cb
3
House Num
470
Onstname
JEFFERSON AVE.
Atddismissed
No
9159
Atdid: 9159 • Atd Number: ATD-3-3334 • Bblid: 369181
Atdid
9159
Atd Number
ATD-3-3334
Bblid
369181
Inspectionid
332777
Inspect Date
2019-04-04T00:00:00.000
Atdissuedate
2022-02-25T12:41:01.000
Cb
5
House Num
310
Onstname
SNEDIKER AVE.
Atddismissed
No
11615
Atdid: 11615 • Atd Number: ATD-2-970 • Bblid: 181012
Atdid
11615
Atd Number
ATD-2-970
Bblid
181012
Violationid
270731
Reinspectionid
33397
Inspect Date
2023-01-23T12:27:50.000
Atdissuedate
2023-01-23T12:27:50.000
Cb
9
House Num
1517
Onstname
COMMONWEALTH AVENUE
Atddismissed
No
11262
Atdid: 11262 • Atd Number: ATD-3-4568 • Bblid: 292720
Atdid
11262
Atd Number
ATD-3-4568
Bblid
292720
Inspectionid
346937
Inspect Date
2022-10-22T00:00:00.000
Atdissuedate
2022-10-25T09:53:46.000
Cb
9
House Num
1174
Onstname
UNION ST.
Atddismissed
No
8811
Atdid: 8811 • Atd Number: ATD-4-3982 • Bblid: 771527
Atdid
8811
Atd Number
ATD-4-3982
Bblid
771527
Inspectionid
331531
Inspect Date
2022-01-05T00:00:00.000
Atdissuedate
2022-01-07T13:55:55.000
Cb
13
House Num
88-18
Onstname
247TH ST.
Atddismissed
No
15108
Atdid: 15108 • Atd Number: ATD-4-6307 • Bblid: 759633
Atdid
15108
Atd Number
ATD-4-6307
Bblid
759633
Inspectionid
382206
Inspect Date
2024-08-14T00:00:00.000
Atdissuedate
2024-09-23T15:08:50.000
Cb
13
House Num
81-60
Onstname
242ND ST.
Atddismissed
No
16810
Atdid: 16810 • Atd Number: ATD-4-6612 • Bblid: 885894
Atdid
16810
Atd Number
ATD-4-6612
Bblid
885894
Inspectionid
389700
Inspect Date
2025-02-07T00:00:00.000
Atdissuedate
2025-02-10T14:16:23.000
Cb
13
House Num
219-27
Onstname
EDGEWOOD AVE.
Atddismissed
No
12051
Atdid: 12051 • Atd Number: ATD-4-5130 • Bblid: 744747
Atdid
12051
Atd Number
ATD-4-5130
Bblid
744747
Inspectionid
355973
Inspect Date
2023-04-04T00:00:00.000
Atdissuedate
2023-04-17T13:34:18.000
Cb
8
House Num
76-23
Onstname
167TH ST.
Atddismissed
No
14492
Atdid: 14492 • Atd Number: ATD-4-6055 • Bblid: 805695
Atdid
14492
Atd Number
ATD-4-6055
Bblid
805695
Inspectionid
377494
Inspect Date
2024-05-04T00:00:00.000
Atdissuedate
2024-05-20T10:13:42.000
Cb
8
House Num
147-04
Onstname
84TH AVE.
Atddismissed
No
18126
Atdid: 18126 • Atd Number: ATD-5-1009 • Bblid: 1012163
Atdid
18126
Atd Number
ATD-5-1009
Bblid
1012163
Inspectionid
402695
Inspect Date
2025-07-17T00:00:00.000
Atdissuedate
2025-07-18T13:29:10.000
Cb
3
House Num
272
Onstname
MONTREAL AVE.
Atddismissed
No
17268
Atdid: 17268 • Atd Number: ATD-3-6826 • Bblid: 281420
Atdid
17268
Atd Number
ATD-3-6826
Bblid
281420
Inspectionid
393425
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-07T11:35:10.000
Cb
7
House Num
581
Onstname
6TH AVE.
Atddismissed
No
13639
Atdid: 13639 • Atd Number: ATD-5-842 • Bblid: 947133
Atdid
13639
Atd Number
ATD-5-842
Bblid
947133
Inspectionid
366103
Inspect Date
2023-10-27T00:00:00.000
Atdissuedate
2023-10-30T10:31:43.000
Cb
2
House Num
402
Onstname
BUCHANAN AVE.
Atddismissed
No
16915
Atdid: 16915 • Atd Number: ATD-3-6631 • Bblid: 520401
Atdid
16915
Atd Number
ATD-3-6631
Bblid
520401
Inspectionid
391025
Inspect Date
2025-03-11T00:00:00.000
Atdissuedate
2025-03-13T13:22:00.000
Cb
18
House Num
1751
Onstname
BURNETT ST.
Atddismissed
No
12867
Atdid: 12867 • Atd Number: ATD-3-5171 • Bblid: 264030
Atdid
12867
Atd Number
ATD-3-5171
Bblid
264030
Inspectionid
360075
Inspect Date
2023-07-17T00:00:00.000
Atdissuedate
2023-07-17T08:58:58.000
Cb
7
House Num
124
Onstname
32ND ST.
Atddismissed
No
8772
Atdid: 8772 • Atd Number: ATD-3-3217 • Bblid: 290607
Atdid
8772
Atd Number
ATD-3-3217
Bblid
290607
Inspectionid
331207
Inspect Date
2021-12-21T00:00:00.000
Atdissuedate
2021-12-29T11:30:42.000
Cb
8
House Num
1123
Onstname
PARK PL.
Atddismissed
No
11909
Atdid: 11909 • Atd Number: ATD-4-5084 • Bblid: 727589
Atdid
11909
Atd Number
ATD-4-5084
Bblid
727589
Inspectionid
354089
Inspect Date
2023-03-21T00:00:00.000
Atdissuedate
2023-03-28T11:29:23.000
Cb
11
House Num
34-36
Onstname
209TH ST.
Atddismissed
No
14961
Atdid: 14961 • Atd Number: ATD-4-6244 • Bblid: 682930
Atdid
14961
Atd Number
ATD-4-6244
Bblid
682930
Inspectionid
381063
Inspect Date
2024-08-24T00:00:00.000
Atdissuedate
2024-08-26T12:59:00.000
Cb
7
House Num
14-33
Onstname
131ST ST.
Atddismissed
No
12568
Atdid: 12568 • Atd Number: ATD-2-1145 • Bblid: 150252
Atdid
12568
Atd Number
ATD-2-1145
Bblid
150252
Inspectionid
358551
Inspect Date
2023-06-14T00:00:00.000
Atdissuedate
2023-06-14T16:18:36.000
Cb
2
House Num
940
Onstname
GARRISON AVE.
Atddismissed
No
15026
Atdid: 15026 • Atd Number: ATD-4-6272 • Bblid: 659116
Atdid
15026
Atd Number
ATD-4-6272
Bblid
659116
Inspectionid
381637
Inspect Date
2024-09-05T00:00:00.000
Atdissuedate
2024-09-09T14:29:43.000
Cb
6
House Num
71-49
Onstname
LOUBET ST.
Atddismissed
No
16347
Atdid: 16347 • Atd Number: ATD-2-1314 • Bblid: 202122
Atdid
16347
Atd Number
ATD-2-1314
Bblid
202122
Inspectionid
384881
Inspect Date
2024-10-25T00:00:00.000
Atdissuedate
2024-11-06T15:05:34.000
Cb
11
House Num
1918
Onstname
YATES AVE.
Atddismissed
No
11936
Atdid: 11936 • Atd Number: ATD-3-4887 • Bblid: 332439
Atdid
11936
Atd Number
ATD-3-4887
Bblid
332439
Violationid
283137
Reinspectionid
35362
Inspect Date
2023-03-30T08:47:21.000
Atdissuedate
2023-03-30T08:47:21.000
Cb
1
House Num
210
Atddismissed
No
13783
Atdid: 13783 • Atd Number: ATD-3-5678 • Bblid: 369817
Atdid
13783
Atd Number
ATD-3-5678
Bblid
369817
Inspectionid
369776
Inspect Date
2023-12-14T00:00:00.000
Atdissuedate
2023-12-18T11:30:01.000
Cb
5
House Num
451
Onstname
GEORGIA AVE.
Atddismissed
No
9422
Atdid: 9422 • Atd Number: ATD-4-4223 • Bblid: 721424
Atdid
9422
Atd Number
ATD-4-4223
Bblid
721424
Inspectionid
333213
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-03-04T10:54:03.000
Cb
7
House Num
23-23
Onstname
205TH ST.
Atddismissed
No
16794
Atdid: 16794 • Atd Number: ATD-1-366 • Bblid: 116880
Atdid
16794
Atd Number
ATD-1-366
Bblid
116880
Inspectionid
389565
Inspect Date
2025-01-28T00:00:00.000
Atdissuedate
2025-02-07T13:20:01.000
Cb
10
House Num
76
Onstname
W. 120TH ST.
Atddismissed
No
17661
Atdid: 17661 • Atd Number: ATD-4-6930 • Bblid: 674151
Atdid
17661
Atd Number
ATD-4-6930
Bblid
674151
Inspectionid
397300
Inspect Date
2025-05-07T00:00:00.000
Atdissuedate
2025-05-16T12:55:27.000
Cb
5
House Num
80-16
Onstname
57TH ST.
Atddismissed
No