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
11300
Atdid: 11300 • Atd Number: ATD-3-4589 • Bblid: 278643
Atdid
11300
Atd Number
ATD-3-4589
Bblid
278643
Inspectionid
347285
Inspect Date
2022-10-26T00:00:00.000
Atdissuedate
2022-11-01T09:59:35.000
Cb
6
House Num
299
Onstname
8TH ST.
Atddismissed
Yes
Atddismissedon
2023-07-15T10:32:38.000
17206
Atdid: 17206 • Atd Number: ATD-4-6713 • Bblid: 876363
Atdid
17206
Atd Number
ATD-4-6713
Bblid
876363
Inspectionid
392891
Inspect Date
2025-03-19T00:00:00.000
Atdissuedate
2025-04-01T12:35:02.000
Cb
12
House Num
117-34
Onstname
194TH ST.
Atddismissed
No
10772
Atdid: 10772 • Atd Number: ATD-3-4150 • Bblid: 310057
Atdid
10772
Atd Number
ATD-3-4150
Bblid
310057
Inspectionid
342817
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-09-07T11:50:33.000
Cb
3
House Num
517
Onstname
MACON STREET
Atddismissed
No
16719
Atdid: 16719 • Atd Number: ATD-3-6551 • Bblid: 380705
Atdid
16719
Atd Number
ATD-3-6551
Bblid
380705
Inspectionid
388856
Inspect Date
2025-01-17T00:00:00.000
Atdissuedate
2025-01-22T10:35:45.000
Cb
5
House Num
214
Onstname
NICHOLS AVE.
Atddismissed
No
10514
Atdid: 10514 • Atd Number: ATD-3-3972 • Bblid: 344480
Atdid
10514
Atd Number
ATD-3-3972
Bblid
344480
Inspectionid
340058
Inspect Date
2022-07-19T00:00:00.000
Atdissuedate
2022-07-19T12:50:04.000
Cb
1
House Num
62
Onstname
ECKFORD ST.
Atddismissed
No
14706
Atdid: 14706 • Atd Number: ATD-4-6130 • Bblid: 765541
Atdid
14706
Atd Number
ATD-4-6130
Bblid
765541
Inspectionid
379147
Inspect Date
2024-03-28T00:00:00.000
Atdissuedate
2024-07-08T15:53:46.000
Cb
11
House Num
248-31
Onstname
THORNHILL AVE.
Atddismissed
No
10116
Atdid: 10116 • Atd Number: ATD-3-3733 • Bblid: 508823
Atdid
10116
Atd Number
ATD-3-3733
Bblid
508823
Inspectionid
336620
Inspect Date
2022-05-18T00:00:00.000
Atdissuedate
2022-05-19T10:41:46.000
Cb
15
House Num
1717
Onstname
AVENUE X.
Atddismissed
No
12295
Atdid: 12295 • Atd Number: ATD-2-1092 • Bblid: 143822
Atdid
12295
Atd Number
ATD-2-1092
Bblid
143822
Inspectionid
357344
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T11:56:37.000
Cb
4
House Num
112
Onstname
E. 167TH ST.
Atddismissed
No
13236
Atdid: 13236 • Atd Number: ATD-3-5407 • Bblid: 433094
Atdid
13236
Atd Number
ATD-3-5407
Bblid
433094
Inspectionid
362056
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T16:34:39.000
Cb
12
House Num
1434
Onstname
47TH ST.
Atddismissed
No
11670
Atdid: 11670 • Atd Number: ATD-4-4993 • Bblid: 725956
Atdid
11670
Atd Number
ATD-4-4993
Bblid
725956
Inspectionid
351635
Inspect Date
2023-02-15T00:00:00.000
Atdissuedate
2023-02-16T11:04:35.000
Cb
11
House Num
32-32
Onstname
204TH ST.
Atddismissed
No
10169
Atdid: 10169 • Atd Number: ATD-3-3779 • Bblid: 385650
Atdid
10169
Atd Number
ATD-3-3779
Bblid
385650
Inspectionid
336931
Inspect Date
2022-05-24T00:00:00.000
Atdissuedate
2022-05-24T14:55:52.000
Cb
5
House Num
649
Onstname
BRADFORD ST.
Atddismissed
No
12924
Atdid: 12924 • Atd Number: ATD-3-5211 • Bblid: 431419
Atdid
12924
Atd Number
ATD-3-5211
Bblid
431419
Inspectionid
360343
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T10:38:49.000
Cb
12
House Num
1423
Onstname
44TH ST.
Atddismissed
No
10133
Atdid: 10133 • Atd Number: ATD-3-3747 • Bblid: 305837
Atdid
10133
Atd Number
ATD-3-3747
Bblid
305837
Inspectionid
336795
Inspect Date
2022-05-18T00:00:00.000
Atdissuedate
2022-05-23T12:15:35.000
Cb
16
House Num
10
Onstname
JARDINE PL.
Atddismissed
No
13169
Atdid: 13169 • Atd Number: ATD-5-794 • Bblid: 1009821
Atdid
13169
Atd Number
ATD-5-794
Bblid
1009821
Inspectionid
361729
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-07T14:42:51.000
Cb
3
House Num
76
Onstname
ISLINGTON ST.
Atddismissed
No
18064
Atdid: 18064 • Atd Number: ATD-3-7115 • Bblid: 513178
Atdid
18064
Atd Number
ATD-3-7115
Bblid
513178
Inspectionid
402216
Inspect Date
2025-07-12T00:00:00.000
Atdissuedate
2025-07-14T11:50:33.000
Cb
15
House Num
2660
Onstname
FORD ST.
Atddismissed
No
3146
Atdid: 3146 • Atd Number: ATD-3-2208 • Bblid: 251266
Atdid
3146
Atd Number
ATD-3-2208
Bblid
251266
Violationid
251738
Atdissuedate
2020-02-13T00:00:00.000
Cb
2
House Num
102
Onstname
DEAN STREET
Atddismissed
Yes
Atddismissedon
2022-08-20T11:55:45.000
18342
Atdid: 18342 • Atd Number: ATD-4-7251 • Bblid: 855421
Atdid
18342
Atd Number
ATD-4-7251
Bblid
855421
Inspectionid
404357
Inspect Date
2025-07-25T00:00:00.000
Atdissuedate
2025-08-18T10:12:23.000
Cb
10
House Num
116-42
Onstname
121ST ST.
Atddismissed
No
12342
Atdid: 12342 • Atd Number: ATD-4-5208 • Bblid: 602827
Atdid
12342
Atd Number
ATD-4-5208
Bblid
602827
Inspectionid
357435
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T16:21:33.000
Cb
2
House Num
51-11
Onstname
QUEENS BLVD.
Atddismissed
No
10052
Atdid: 10052 • Atd Number: ATD-4-4593 • Bblid: 768762
Atdid
10052
Atd Number
ATD-4-4593
Bblid
768762
Inspectionid
336150
Inspect Date
2021-02-18T00:00:00.000
Atdissuedate
2022-05-04T14:34:44.000
Cb
13
House Num
248-01
Onstname
UNION TPKE.
Atddismissed
Yes
Atddismissedon
2022-05-24T12:44:59.000
12465
Atdid: 12465 • Atd Number: ATD-4-5297 • Bblid: 813102
Atdid
12465
Atd Number
ATD-4-5297
Bblid
813102
Inspectionid
357968
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T09:38:14.000
Cb
12
House Num
106-15
Onstname
SUTPHIN BLVD.
Atddismissed
No
9441
Atdid: 9441 • Atd Number: ATD-3-3504 • Bblid: 554339
Atdid
9441
Atd Number
ATD-3-3504
Bblid
554339
Inspectionid
333275
Inspect Date
2021-01-13T00:00:00.000
Atdissuedate
2022-03-04T17:12:12.000
Cb
18
House Num
2750
Onstname
MILL AVE.
Atddismissed
No
11426
Atdid: 11426 • Atd Number: ATD-3-4648 • Bblid: 255490
Atdid
11426
Atd Number
ATD-3-4648
Bblid
255490
Inspectionid
348440
Inspect Date
2022-11-19T00:00:00.000
Atdissuedate
2022-11-21T10:43:36.000
Cb
6
House Num
332
Onstname
CLINTON ST.
Atddismissed
Yes
Atddismissedon
2023-02-10T11:51:52.000
9701
Atdid: 9701 • Atd Number: ATD-4-4385 • Bblid: 636550
Atdid
9701
Atd Number
ATD-4-4385
Bblid
636550
Inspectionid
334107
Inspect Date
2022-03-24T00:00:00.000
Atdissuedate
2022-03-24T10:51:57.000
Cb
4
House Num
82-23
Onstname
GRAND AVE.
Atddismissed
No
16165
Atdid: 16165 • Atd Number: ATD-4-6342 • Bblid: 737428
Atdid
16165
Atd Number
ATD-4-6342
Bblid
737428
Inspectionid
383602
Inspect Date
2024-09-24T00:00:00.000
Atdissuedate
2024-10-01T10:56:15.000
Cb
8
House Num
147-08
Onstname
77TH RD.
Atddismissed
No
8595
Atdid: 8595 • Atd Number: ATD-3-3147 • Bblid: 271830
Atdid
8595
Atd Number
ATD-3-3147
Bblid
271830
Inspectionid
330591
Inspect Date
2021-12-10T00:00:00.000
Atdissuedate
2021-12-13T09:13:01.000
Cb
7
House Num
542
Onstname
17TH ST.
Atddismissed
No
10958
Atdid: 10958 • Atd Number: ATD-3-4316 • Bblid: 279284
Atdid
10958
Atd Number
ATD-3-4316
Bblid
279284
Inspectionid
344270
Inspect Date
2022-09-20T00:00:00.000
Atdissuedate
2022-09-22T09:03:20.000
Cb
6
House Num
136
Onstname
11TH ST.
Atddismissed
No
14398
Atdid: 14398 • Atd Number: ATD-4-6015 • Bblid: 677761
Atdid
14398
Atd Number
ATD-4-6015
Bblid
677761
Inspectionid
376683
Inspect Date
2024-05-06T00:00:00.000
Atdissuedate
2024-05-06T11:28:41.000
Cb
5
House Num
87-41
Onstname
81ST AVE.
Atddismissed
No
9777
Atdid: 9777 • Atd Number: ATD-4-4425 • Bblid: 877791
Atdid
9777
Atd Number
ATD-4-4425
Bblid
877791
Inspectionid
334370
Inspect Date
2019-08-13T00:00:00.000
Atdissuedate
2022-03-29T18:14:19.000
Cb
12
House Num
120-41
Onstname
FARMERS BLVD.
Atddismissed
No
12935
Atdid: 12935 • Atd Number: ATD-5-763 • Bblid: 1027506
Atdid
12935
Atd Number
ATD-5-763
Bblid
1027506
Inspectionid
360378
Inspect Date
2023-07-15T00:00:00.000
Atdissuedate
2023-07-20T13:28:13.000
Cb
3
House Num
44
Onstname
MONTEREY AVE.
Atddismissed
No
17984
Atdid: 17984 • Atd Number: ATD-3-7085 • Bblid: 496733
Atdid
17984
Atd Number
ATD-3-7085
Bblid
496733
Inspectionid
401568
Inspect Date
2025-06-25T00:00:00.000
Atdissuedate
2025-06-26T11:28:47.000
Cb
15
House Num
2219
Onstname
E. 4TH ST.
Atddismissed
No
17976
Atdid: 17976 • Atd Number: ATD-4-7099 • Bblid: 626362
Atdid
17976
Atd Number
ATD-4-7099
Bblid
626362
Inspectionid
401504
Inspect Date
2025-06-23T00:00:00.000
Atdissuedate
2025-06-25T11:19:44.000
Cb
4
House Num
111-47
Onstname
41ST AVE.
Atddismissed
No
14312
Atdid: 14312 • Atd Number: ATD-4-5973 • Bblid: 656442
Atdid
14312
Atd Number
ATD-4-5973
Bblid
656442
Inspectionid
375777
Inspect Date
2024-04-22T00:00:00.000
Atdissuedate
2024-04-22T12:03:48.000
Cb
6
House Num
69-22
Onstname
ALDERTON ST.
Atddismissed
No
17239
Atdid: 17239 • Atd Number: ATD-3-6819 • Bblid: 469590
Atdid
17239
Atd Number
ATD-3-6819
Bblid
469590
Inspectionid
393141
Inspect Date
2025-04-03T00:00:00.000
Atdissuedate
2025-04-04T09:59:00.000
Cb
11
House Num
252
Onstname
BAY 13TH ST.
Atddismissed
No
11362
Atdid: 11362 • Atd Number: ATD-1-227 • Bblid: 33935
Atdid
11362
Atd Number
ATD-1-227
Bblid
33935
Inspectionid
347772
Inspect Date
2022-11-04T00:00:00.000
Atdissuedate
2022-11-07T12:46:40.000
Cb
4
House Num
236
Onstname
W. 22ND ST.
Atddismissed
No
12029
Atdid: 12029 • Atd Number: ATD-4-5125 • Bblid: 752540
Atdid
12029
Atd Number
ATD-4-5125
Bblid
752540
Inspectionid
355818
Inspect Date
2023-04-13T00:00:00.000
Atdissuedate
2023-04-13T14:07:07.000
Cb
11
House Num
51-19
Onstname
199TH ST.
Atddismissed
No
9216
Atdid: 9216 • Atd Number: ATD-1-188 • Bblid: 132246
Atdid
9216
Atd Number
ATD-1-188
Bblid
132246
Inspectionid
332874
Inspect Date
2017-08-02T00:00:00.000
Atdissuedate
2022-02-28T17:51:22.000
Cb
9
House Num
455
Onstname
W. 141ST ST.
Atddismissed
No
9917
Atdid: 9917 • Atd Number: ATD-4-4505 • Bblid: 654468
Atdid
9917
Atd Number
ATD-4-4505
Bblid
654468
Inspectionid
335262
Inspect Date
2022-04-15T00:00:00.000
Atdissuedate
2022-04-20T13:58:08.000
Cb
6
House Num
63-20
Onstname
ELLWELL CRES
Atddismissed
No
16558
Atdid: 16558 • Atd Number: ATD-3-6494 • Bblid: 268164
Atdid
16558
Atd Number
ATD-3-6494
Bblid
268164
Inspectionid
386912
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2024-12-19T12:30:36.000
Cb
7
House Num
326
Onstname
52ND ST.
Atddismissed
No
17004
Atdid: 17004 • Atd Number: ATD-3-6672 • Bblid: 275207
Atdid
17004
Atd Number
ATD-3-6672
Bblid
275207
Inspectionid
392143
Inspect Date
2025-03-20T00:00:00.000
Atdissuedate
2025-03-24T13:35:25.000
Cb
6
House Num
55
Onstname
LINCOLN PL.
Atddismissed
No
12934
Atdid: 12934 • Atd Number: ATD-3-5221 • Bblid: 422473
Atdid
12934
Atd Number
ATD-3-5221
Bblid
422473
Inspectionid
360354
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T11:24:32.000
Cb
12
House Num
4404
Onstname
16TH AVE.
Atddismissed
No
18189
Atdid: 18189 • Atd Number: ATD-2-1427 • Bblid: 178863
Atdid
18189
Atd Number
ATD-2-1427
Bblid
178863
Inspectionid
403145
Inspect Date
2025-07-23T00:00:00.000
Atdissuedate
2025-07-24T11:15:32.000
Cb
9
House Num
2229
Onstname
BRUCKNER BLVD.
Atddismissed
No
13672
Atdid: 13672 • Atd Number: ATD-4-5634 • Bblid: 823114
Atdid
13672
Atd Number
ATD-4-5634
Bblid
823114
Inspectionid
366430
Inspect Date
2023-10-24T00:00:00.000
Atdissuedate
2023-11-13T10:50:55.000
Cb
12
House Num
89-35
Onstname
199TH ST.
Atddismissed
No
11652
Atdid: 11652 • Atd Number: ATD-3-4732 • Bblid: 250727
Atdid
11652
Atd Number
ATD-3-4732
Bblid
250727
Inspectionid
351328
Inspect Date
2023-01-11T00:00:00.000
Atdissuedate
2023-02-09T14:24:18.000
Cb
2
House Num
405
Onstname
PACIFIC ST.
Atddismissed
No
17122
Atdid: 17122 • Atd Number: ATD-3-6768 • Bblid: 509054
Atdid
17122
Atd Number
ATD-3-6768
Bblid
509054
Inspectionid
392527
Inspect Date
2023-07-26T00:00:00.000
Atdissuedate
2025-03-28T15:12:28.000
Cb
15
House Num
2308
Onstname
E. 24TH ST.
Atddismissed
No
9296
Atdid: 9296 • Atd Number: ATD-3-3400 • Bblid: 436302
Atdid
9296
Atd Number
ATD-3-3400
Bblid
436302
Inspectionid
333002
Inspect Date
2019-07-24T00:00:00.000
Atdissuedate
2022-03-02T08:36:59.000
Cb
12
House Num
1032
Onstname
57TH ST.
Atddismissed
No
13348
Atdid: 13348 • Atd Number: ATD-5-804 • Bblid: 1028309
Atdid
13348
Atd Number
ATD-5-804
Bblid
1028309
Inspectionid
362866
Inspect Date
2023-07-25T00:00:00.000
Atdissuedate
2023-08-29T13:30:04.000
Cb
3
House Num
720
Onstname
DRUMGOOLE RD. W.
Atddismissed
No
17995
Atdid: 17995 • Atd Number: ATD-3-7093 • Bblid: 1078587
Atdid
17995
Atd Number
ATD-3-7093
Bblid
1078587
Inspectionid
401623
Inspect Date
2025-06-28T00:00:00.000
Atdissuedate
2025-06-28T15:02:21.000
Cb
5
House Num
597
Onstname
VANDALIA AVE.
Atddismissed
No
14837
Atdid: 14837 • Atd Number: ATD-5-869 • Bblid: 1008448
Atdid
14837
Atd Number
ATD-5-869
Bblid
1008448
Violationid
292961
Reinspectionid
36684
Inspect Date
2024-08-01T11:48:44.000
Atdissuedate
2024-08-01T11:48:44.000
Cb
3
House Num
23
Onstname
COTTONWOOD COURT
Atddismissed
No
9967
Atdid: 9967 • Atd Number: ATD-3-3654 • Bblid: 514263
Atdid
9967
Atd Number
ATD-3-3654
Bblid
514263
Inspectionid
335487
Inspect Date
2022-04-13T00:00:00.000
Atdissuedate
2022-04-25T11:34:40.000
Cb
14
House Num
982
Onstname
E. 26TH ST.
Atddismissed
No
9185
Atdid: 9185 • Atd Number: ATD-3-3346 • Bblid: 279047
Atdid
9185
Atd Number
ATD-3-3346
Bblid
279047
Inspectionid
332843
Inspect Date
2021-09-10T00:00:00.000
Atdissuedate
2022-02-28T17:03:39.000
Cb
6
House Num
517
Onstname
10TH ST.
Atddismissed
No