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
8716
Atdid: 8716 • Atd Number: ATD-3-3196 • Bblid: 279070
Atdid
8716
Atd Number
ATD-3-3196
Bblid
279070
Inspectionid
331031
Inspect Date
2021-09-10T00:00:00.000
Atdissuedate
2021-12-27T09:41:20.000
Cb
6
House Num
483
Onstname
10TH ST.
Atddismissed
No
17815
Atdid: 17815 • Atd Number: ATD-1-379 • Bblid: 131914
Atdid
17815
Atd Number
ATD-1-379
Bblid
131914
Inspectionid
399319
Inspect Date
2025-06-05T00:00:00.000
Atdissuedate
2025-06-06T12:19:04.000
Cb
9
House Num
48
Onstname
HAMILTON TER.
Atddismissed
No
16336
Atdid: 16336 • Atd Number: ATD-4-6407 • Bblid: 752219
Atdid
16336
Atd Number
ATD-4-6407
Bblid
752219
Inspectionid
384748
Inspect Date
2024-10-22T00:00:00.000
Atdissuedate
2024-11-04T10:44:13.000
Cb
11
House Num
50-11
Onstname
202ND ST.
Atddismissed
No
17423
Atdid: 17423 • Atd Number: ATD-4-6797 • Bblid: 861889
Atdid
17423
Atd Number
ATD-4-6797
Bblid
861889
Inspectionid
395235
Inspect Date
2025-04-17T00:00:00.000
Atdissuedate
2025-04-24T13:11:04.000
Cb
12
House Num
114-49
Onstname
148TH ST.
Atddismissed
No
10331
Atdid: 10331 • Atd Number: ATD-4-4683 • Bblid: 719391
Atdid
10331
Atd Number
ATD-4-4683
Bblid
719391
Inspectionid
338190
Inspect Date
2022-06-14T00:00:00.000
Atdissuedate
2022-06-27T11:00:14.000
Cb
11
House Num
53-44
Onstname
196TH ST.
Atddismissed
No
14761
Atdid: 14761 • Atd Number: ATD-3-6130 • Bblid: 497825
Atdid
14761
Atd Number
ATD-3-6130
Bblid
497825
Inspectionid
379518
Inspect Date
2024-03-14T00:00:00.000
Atdissuedate
2024-07-17T17:18:37.000
Cb
15
House Num
2272
Onstname
E. 2ND ST.
Atddismissed
No
17111
Atdid: 17111 • Atd Number: ATD-3-6757 • Bblid: 418209
Atdid
17111
Atd Number
ATD-3-6757
Bblid
418209
Inspectionid
392509
Inspect Date
2024-02-08T00:00:00.000
Atdissuedate
2025-03-28T13:43:04.000
Cb
12
House Num
225
Onstname
E. 8TH ST.
Atddismissed
No
11369
Atdid: 11369 • Atd Number: ATD-3-4633 • Bblid: 462621
Atdid
11369
Atd Number
ATD-3-4633
Bblid
462621
Inspectionid
347891
Inspect Date
2022-11-05T00:00:00.000
Atdissuedate
2022-11-09T13:58:01.000
Cb
11
House Num
2269
Onstname
82ND ST.
Atddismissed
No
10128
Atdid: 10128 • Atd Number: ATD-3-3742 • Bblid: 562337
Atdid
10128
Atd Number
ATD-3-3742
Bblid
562337
Inspectionid
336785
Inspect Date
2022-05-09T00:00:00.000
Atdissuedate
2022-05-23T11:23:48.000
Cb
15
House Num
2741
Onstname
FORD ST.
Atddismissed
No
16309
Atdid: 16309 • Atd Number: ATD-3-6386 • Bblid: 274112
Atdid
16309
Atd Number
ATD-3-6386
Bblid
274112
Inspectionid
384504
Inspect Date
2024-10-01T00:00:00.000
Atdissuedate
2024-10-28T15:38:29.000
Cb
6
House Num
105
Onstname
ST MARKS PLACE
Atddismissed
No
9562
Atdid: 9562 • Atd Number: ATD-3-3553 • Bblid: 310858
Atdid
9562
Atd Number
ATD-3-3553
Bblid
310858
Inspectionid
333650
Inspect Date
2021-08-27T00:00:00.000
Atdissuedate
2022-03-11T10:01:24.000
Cb
3
House Num
220
Onstname
PATCHEN AVE.
Atddismissed
No
13102
Atdid: 13102 • Atd Number: ATD-4-5481 • Bblid: 594888
Atdid
13102
Atd Number
ATD-4-5481
Bblid
594888
Inspectionid
361383
Inspect Date
2023-07-29T00:00:00.000
Atdissuedate
2023-08-03T10:47:40.000
Cb
3
House Num
22-52
Onstname
99TH ST.
Atddismissed
No
10344
Atdid: 10344 • Atd Number: ATD-3-3861 • Bblid: 315956
Atdid
10344
Atd Number
ATD-3-3861
Bblid
315956
Inspectionid
338354
Inspect Date
2022-06-30T00:00:00.000
Atdissuedate
2022-06-30T13:01:40.000
Cb
3
House Num
130
Onstname
VAN BUREN ST.
Atddismissed
No
17593
Atdid: 17593 • Atd Number: ATD-2-1402 • Bblid: 241358
Atdid
17593
Atd Number
ATD-2-1402
Bblid
241358
Inspectionid
396981
Inspect Date
2025-04-02T00:00:00.000
Atdissuedate
2025-05-13T11:07:26.000
Cb
10
House Num
533
Onstname
MINNIEFORD AVE.
Atddismissed
No
18511
Atdid: 18511 • Atd Number: ATD-3-7292 • Bblid: 378399
Atdid
18511
Atd Number
ATD-3-7292
Bblid
378399
Inspectionid
405379
Inspect Date
2025-09-05T00:00:00.000
Atdissuedate
2025-09-08T10:11:27.000
Cb
5
House Num
628
Onstname
BARBEY ST.
Atddismissed
No
14144
Atdid: 14144 • Atd Number: ATD-4-5903 • Bblid: 893521
Atdid
14144
Atd Number
ATD-4-5903
Bblid
893521
Inspectionid
373382
Inspect Date
2024-03-14T00:00:00.000
Atdissuedate
2024-03-18T12:48:25.000
Cb
13
House Num
143-67
Onstname
226TH ST.
Atddismissed
No
13847
Atdid: 13847 • Atd Number: ATD-3-5691 • Bblid: 481499
Atdid
13847
Atd Number
ATD-3-5691
Bblid
481499
Inspectionid
370468
Inspect Date
2024-01-04T00:00:00.000
Atdissuedate
2024-01-09T11:22:38.000
Cb
14
House Num
1208
Onstname
E. 18TH ST.
Atddismissed
No
14583
Atdid: 14583 • Atd Number: ATD-3-6037 • Bblid: 445817
Atdid
14583
Atd Number
ATD-3-6037
Bblid
445817
Inspectionid
378365
Inspect Date
2024-06-05T00:00:00.000
Atdissuedate
2024-06-11T15:32:53.000
Cb
10
House Num
649
Onstname
BAY RIDGE PKWY.
Atddismissed
No
11895
Atdid: 11895 • Atd Number: ATD-4-5071 • Bblid: 914807
Atdid
11895
Atd Number
ATD-4-5071
Bblid
914807
Inspectionid
354008
Inspect Date
2023-03-24T00:00:00.000
Atdissuedate
2023-03-27T14:31:19.000
Cb
14
House Num
351
Onstname
BEACH 69TH ST.
Atddismissed
No
4871
Atdid: 4871 • Atd Number: ATD-4-1402 • Bblid: 661380
Atdid
4871
Atd Number
ATD-4-1402
Bblid
661380
Violationid
189158
Atdissuedate
2020-08-20T00:00:00.000
Cb
9
House Num
121-20
Onstname
AUDLEY STREET
Atddismissed
Yes
Atddismissedon
2024-09-03T11:06:05.000
18605
Atdid: 18605 • Atd Number: ATD-3-7330 • Bblid: 486079
Atdid
18605
Atd Number
ATD-3-7330
Bblid
486079
Inspectionid
405917
Inspect Date
2025-09-12T00:00:00.000
Atdissuedate
2025-09-15T18:07:46.000
Cb
15
House Num
1827
Onstname
E. 24TH ST.
Atddismissed
No
12125
Atdid: 12125 • Atd Number: ATD-4-5162 • Bblid: 860868
Atdid
12125
Atd Number
ATD-4-5162
Bblid
860868
Inspectionid
356439
Inspect Date
2023-03-21T00:00:00.000
Atdissuedate
2023-05-01T11:52:36.000
Cb
12
House Num
111-62
Onstname
145TH ST.
Atddismissed
No
13440
Atdid: 13440 • Atd Number: ATD-2-1235 • Bblid: 216286
Atdid
13440
Atd Number
ATD-2-1235
Bblid
216286
Inspectionid
364010
Inspect Date
2023-08-08T00:00:00.000
Atdissuedate
2023-09-21T09:31:07.000
Cb
12
House Num
3212
Onstname
SEYMOUR AVE.
Atddismissed
No
13689
Atdid: 13689 • Atd Number: ATD-3-5646 • Bblid: 332176
Atdid
13689
Atd Number
ATD-3-5646
Bblid
332176
Inspectionid
367544
Inspect Date
2023-10-19T00:00:00.000
Atdissuedate
2023-11-16T08:34:03.000
Cb
1
House Num
205
Onstname
HOOPER ST.
Atddismissed
No
9038
Atdid: 9038 • Atd Number: ATD-4-4099 • Bblid: 761142
Atdid
9038
Atd Number
ATD-4-4099
Bblid
761142
Inspectionid
332446
Inspect Date
2021-12-29T00:00:00.000
Atdissuedate
2022-02-14T13:25:17.000
Cb
13
House Num
88-23
Onstname
MOLINE ST.
Atddismissed
No
14822
Atdid: 14822 • Atd Number: ATD-3-6158 • Bblid: 324782
Atdid
14822
Atd Number
ATD-3-6158
Bblid
324782
Inspectionid
379960
Inspect Date
2024-07-26T00:00:00.000
Atdissuedate
2024-07-30T09:49:04.000
Cb
3
House Num
83
Onstname
QUINCY ST.
Atddismissed
No
12812
Atdid: 12812 • Atd Number: ATD-3-5144 • Bblid: 505142
Atdid
12812
Atd Number
ATD-3-5144
Bblid
505142
Inspectionid
359766
Inspect Date
2023-07-11T00:00:00.000
Atdissuedate
2023-07-11T07:14:07.000
Cb
15
House Num
2029
Onstname
E. 28TH ST.
Atddismissed
No
12349
Atdid: 12349 • Atd Number: ATD-4-5215 • Bblid: 603430
Atdid
12349
Atd Number
ATD-4-5215
Bblid
603430
Inspectionid
357475
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T11:46:54.000
Cb
2
House Num
56-01
Onstname
QUEENS BLVD.
Atddismissed
No
11455
Atdid: 11455 • Atd Number: ATD-1-260 • Bblid: 134681
Atdid
11455
Atd Number
ATD-1-260
Bblid
134681
Inspectionid
348662
Inspect Date
2022-11-04T00:00:00.000
Atdissuedate
2022-11-25T11:35:29.000
Cb
12
House Num
564
Onstname
W. 171ST ST.
Atddismissed
No
11320
Atdid: 11320 • Atd Number: ATD-3-4606 • Bblid: 299005
Atdid
11320
Atd Number
ATD-3-4606
Bblid
299005
Inspectionid
347451
Inspect Date
2022-10-29T00:00:00.000
Atdissuedate
2022-11-01T16:17:27.000
Cb
9
House Num
789
Onstname
MONTGOMERY ST.
Atddismissed
No
18044
Atdid: 18044 • Atd Number: ATD-4-7126 • Bblid: 693768
Atdid
18044
Atd Number
ATD-4-7126
Bblid
693768
Inspectionid
402012
Inspect Date
2025-06-13T00:00:00.000
Atdissuedate
2025-07-10T11:18:54.000
Cb
7
House Num
25-24
Onstname
146TH ST.
Atddismissed
No
12775
Atdid: 12775 • Atd Number: ATD-4-5414 • Bblid: 876143
Atdid
12775
Atd Number
ATD-4-5414
Bblid
876143
Inspectionid
359527
Inspect Date
2023-05-06T00:00:00.000
Atdissuedate
2023-07-06T14:30:24.000
Cb
12
House Num
118-39
Onstname
190TH ST.
Atddismissed
No
13746
Atdid: 13746 • Atd Number: ATD-5-859 • Bblid: 1015304
Atdid
13746
Atd Number
ATD-5-859
Bblid
1015304
Inspectionid
369104
Inspect Date
2023-11-17T00:00:00.000
Atdissuedate
2023-12-06T12:30:20.000
Cb
3
House Num
15
Onstname
WATERSIDE PKWY.
Atddismissed
No
18080
Atdid: 18080 • Atd Number: ATD-4-7141 • Bblid: 836863
Atdid
18080
Atd Number
ATD-4-7141
Bblid
836863
Inspectionid
402314
Inspect Date
2025-06-26T00:00:00.000
Atdissuedate
2025-07-14T13:43:07.000
Cb
12
House Num
191-40
Onstname
114TH DR.
Atddismissed
No
16521
Atdid: 16521 • Atd Number: ATD-3-6460 • Bblid: 259410
Atdid
16521
Atd Number
ATD-3-6460
Bblid
259410
Inspectionid
386383
Inspect Date
2024-10-02T00:00:00.000
Atdissuedate
2024-12-17T12:53:33.000
Cb
6
House Num
388
Onstname
DEGRAW STREET
Atddismissed
No
14957
Atdid: 14957 • Atd Number: ATD-3-6227 • Bblid: 368875
Atdid
14957
Atd Number
ATD-3-6227
Bblid
368875
Inspectionid
381021
Inspect Date
2024-08-15T00:00:00.000
Atdissuedate
2024-08-26T09:45:32.000
Cb
5
House Num
359
Onstname
WYONA ST.
Atddismissed
No
9743
Atdid: 9743 • Atd Number: ATD-2-897 • Bblid: 196165
Atdid
9743
Atd Number
ATD-2-897
Bblid
196165
Inspectionid
334308
Inspect Date
2004-05-04T00:00:00.000
Atdissuedate
2022-03-28T17:26:19.000
Cb
11
House Num
1719
Onstname
HOLLAND AVE.
Atddismissed
No
8812
Atdid: 8812 • Atd Number: ATD-3-3230 • Bblid: 418935
Atdid
8812
Atd Number
ATD-3-3230
Bblid
418935
Inspectionid
331533
Inspect Date
2021-12-30T00:00:00.000
Atdissuedate
2022-01-07T14:02:43.000
Cb
12
House Num
392
Onstname
E. 7TH ST.
Atddismissed
No
14622
Atdid: 14622 • Atd Number: ATD-3-6059 • Bblid: 424809
Atdid
14622
Atd Number
ATD-3-6059
Bblid
424809
Inspectionid
378565
Inspect Date
2024-06-15T00:00:00.000
Atdissuedate
2024-06-18T09:57:27.000
Cb
12
House Num
1609
Onstname
55TH ST.
Atddismissed
No
17772
Atdid: 17772 • Atd Number: ATD-4-6999 • Bblid: 643428
Atdid
17772
Atd Number
ATD-4-6999
Bblid
643428
Inspectionid
398920
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-02T11:08:18.000
Cb
5
House Num
60-11
Onstname
69TH ST.
Atddismissed
No
12586
Atdid: 12586 • Atd Number: ATD-4-5351 • Bblid: 598273
Atdid
12586
Atd Number
ATD-4-5351
Bblid
598273
Inspectionid
358591
Inspect Date
2023-06-12T00:00:00.000
Atdissuedate
2023-06-15T10:43:57.000
Cb
3
House Num
32-16
Onstname
73RD ST.
Atddismissed
No
10844
Atdid: 10844 • Atd Number: ATD-3-4215 • Bblid: 262283
Atdid
10844
Atd Number
ATD-3-4215
Bblid
262283
Inspectionid
343371
Inspect Date
2022-09-09T00:00:00.000
Atdissuedate
2022-09-12T10:18:07.000
Cb
6
House Num
89
Onstname
DIKEMAN ST.
Atddismissed
No
18201
Atdid: 18201 • Atd Number: ATD-2-1430 • Bblid: 223855
Atdid
18201
Atd Number
ATD-2-1430
Bblid
223855
Inspectionid
403274
Inspect Date
2025-07-15T00:00:00.000
Atdissuedate
2025-07-28T11:56:00.000
Cb
12
House Num
4027
Onstname
EDSON AVE.
Atddismissed
No
9435
Atdid: 9435 • Atd Number: ATD-4-4235 • Bblid: 654784
Atdid
9435
Atd Number
ATD-4-4235
Bblid
654784
Inspectionid
333267
Inspect Date
2022-03-04T00:00:00.000
Atdissuedate
2022-03-04T14:42:01.000
Cb
6
House Num
63-20
Onstname
DIETERLE CRES
Atddismissed
No
13541
Atdid: 13541 • Atd Number: ATD-4-5580 • Bblid: 754202
Atdid
13541
Atd Number
ATD-4-5580
Bblid
754202
Inspectionid
364863
Inspect Date
2023-10-04T00:00:00.000
Atdissuedate
2023-10-04T07:45:21.000
Cb
11
House Num
56-11
Onstname
218TH ST.
Atddismissed
No
16615
Atdid: 16615 • Atd Number: ATD-1-345 • Bblid: 106010
Atdid
16615
Atd Number
ATD-1-345
Bblid
106010
Inspectionid
387274
Inspect Date
2024-12-20T00:00:00.000
Atdissuedate
2024-12-30T09:47:06.000
Cb
8
House Num
119
Onstname
E. 91ST ST.
Atddismissed
No
17179
Atdid: 17179 • Atd Number: ATD-2-1359 • Bblid: 208962
Atdid
17179
Atd Number
ATD-2-1359
Bblid
208962
Inspectionid
392713
Inspect Date
2025-03-28T00:00:00.000
Atdissuedate
2025-03-31T11:37:55.000
Cb
11
House Num
2741
Onstname
MICKLE AVE.
Atddismissed
No
18098
Atdid: 18098 • Atd Number: ATD-3-7133 • Bblid: 404945
Atdid
18098
Atd Number
ATD-3-7133
Bblid
404945
Inspectionid
402425
Inspect Date
2025-07-08T00:00:00.000
Atdissuedate
2025-07-15T13:14:36.000
Cb
17
House Num
1341
Onstname
ALBANY AVE.
Atddismissed
No
11358
Atdid: 11358 • Atd Number: ATD-1-223 • Bblid: 33919
Atdid
11358
Atd Number
ATD-1-223
Bblid
33919
Inspectionid
347767
Inspect Date
2022-11-04T00:00:00.000
Atdissuedate
2022-11-07T12:44:30.000
Cb
4
House Num
220
Onstname
W. 22ND ST.
Atddismissed
No
17975
Atdid: 17975 • Atd Number: ATD-4-7098 • Bblid: 626336
Atdid
17975
Atd Number
ATD-4-7098
Bblid
626336
Inspectionid
401486
Inspect Date
2025-06-25T00:00:00.000
Atdissuedate
2025-06-25T11:08:08.000
Cb
4
House Num
111-87
Onstname
41ST AVE.
Atddismissed
No