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
17600
Atdid: 17600 • Atd Number: ATD-3-6974 • Bblid: 471520
Atdid
17600
Atd Number
ATD-3-6974
Bblid
471520
Inspectionid
397042
Inspect Date
2025-05-08T00:00:00.000
Atdissuedate
2025-05-14T13:26:51.000
Cb
12
House Num
1327
Onstname
E. 4TH ST.
Atddismissed
No
17170
Atdid: 17170 • Atd Number: ATD-4-6693 • Bblid: 683624
Atdid
17170
Atd Number
ATD-4-6693
Bblid
683624
Inspectionid
392685
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2025-03-31T11:07:34.000
Cb
7
House Num
18-06
Onstname
PARSONS BLVD.
Atddismissed
No
10094
Atdid: 10094 • Atd Number: ATD-3-3713 • Bblid: 472315
Atdid
10094
Atd Number
ATD-3-3713
Bblid
472315
Inspectionid
336454
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-16T10:50:52.000
Cb
11
House Num
2332
Onstname
62ND ST.
Atddismissed
No
14406
Atdid: 14406 • Atd Number: ATD-4-6020 • Bblid: 896623
Atdid
14406
Atd Number
ATD-4-6020
Bblid
896623
Inspectionid
376858
Inspect Date
2024-05-06T00:00:00.000
Atdissuedate
2024-05-07T07:36:23.000
Cb
13
House Num
149-70
Onstname
WELLER LN.
Atddismissed
No
9723
Atdid: 9723 • Atd Number: ATD-4-4407 • Bblid: 736767
Atdid
9723
Atd Number
ATD-4-4407
Bblid
736767
Inspectionid
334136
Inspect Date
2017-07-11T00:00:00.000
Atdissuedate
2022-03-24T17:42:02.000
Cb
8
House Num
144-39
Onstname
76TH AVE.
Atddismissed
No
12098
Atdid: 12098 • Atd Number: ATD-3-4953 • Bblid: 481989
Atdid
12098
Atd Number
ATD-3-4953
Bblid
481989
Inspectionid
356298
Inspect Date
2023-04-18T00:00:00.000
Atdissuedate
2023-04-26T11:33:14.000
Cb
14
House Num
1354
Onstname
E. 14TH ST.
Atddismissed
No
9795
Atdid: 9795 • Atd Number: ATD-3-3594 • Bblid: 524968
Atdid
9795
Atd Number
ATD-3-3594
Bblid
524968
Inspectionid
334434
Inspect Date
2021-04-29T00:00:00.000
Atdissuedate
2022-03-31T09:03:26.000
Cb
18
House Num
1068
Onstname
E. 57TH ST.
Atddismissed
No
18510
Atdid: 18510 • Atd Number: ATD-3-7291 • Bblid: 378397
Atdid
18510
Atd Number
ATD-3-7291
Bblid
378397
Inspectionid
405375
Inspect Date
2025-09-05T00:00:00.000
Atdissuedate
2025-09-08T10:10:26.000
Cb
5
House Num
626
Onstname
BARBEY ST.
Atddismissed
No
11835
Atdid: 11835 • Atd Number: ATD-3-4810 • Bblid: 422971
Atdid
11835
Atd Number
ATD-3-4810
Bblid
422971
Inspectionid
353500
Inspect Date
2023-03-16T00:00:00.000
Atdissuedate
2023-03-21T11:56:00.000
Cb
12
House Num
1754
Onstname
46TH ST.
Atddismissed
No
14686
Atdid: 14686 • Atd Number: ATD-3-6100 • Bblid: 462962
Atdid
14686
Atd Number
ATD-3-6100
Bblid
462962
Inspectionid
378995
Inspect Date
2024-07-01T00:00:00.000
Atdissuedate
2024-07-02T13:19:02.000
Cb
11
House Num
1451
Onstname
83RD ST.
Atddismissed
No
833
Atdid: 833 • Atd Number: ATD-2-700 • Bblid: 211308
Atdid
833
Atd Number
ATD-2-700
Bblid
211308
Violationid
192686
Atdissuedate
2020-08-12T00:00:00.000
Cb
12
House Num
3330
Onstname
BRONX BOULEVARD
Atddismissed
Yes
Atddismissedon
2023-04-17T13:30:48.000
14176
Atdid: 14176 • Atd Number: ATD-3-5837 • Bblid: 531946
Atdid
14176
Atd Number
ATD-3-5837
Bblid
531946
Inspectionid
373650
Inspect Date
2023-12-15T00:00:00.000
Atdissuedate
2024-03-19T13:46:52.000
Cb
18
House Num
641
Onstname
E. 78TH ST.
Atddismissed
No
14709
Atdid: 14709 • Atd Number: ATD-4-6131 • Bblid: 693492
Atdid
14709
Atd Number
ATD-4-6131
Bblid
693492
Inspectionid
379200
Inspect Date
2024-03-21T00:00:00.000
Atdissuedate
2024-07-09T11:51:12.000
Cb
7
House Num
154-41
Onstname
WILLETS POINT BLVD.
Atddismissed
No
16354
Atdid: 16354 • Atd Number: ATD-3-6407 • Bblid: 447385
Atdid
16354
Atd Number
ATD-3-6407
Bblid
447385
Inspectionid
384926
Inspect Date
2024-11-07T00:00:00.000
Atdissuedate
2024-11-12T09:01:13.000
Cb
10
House Num
546
Onstname
77TH ST.
Atddismissed
No
9135
Atdid: 9135 • Atd Number: ATD-3-3326 • Bblid: 494925
Atdid
9135
Atd Number
ATD-3-3326
Bblid
494925
Inspectionid
332686
Inspect Date
2019-06-19T00:00:00.000
Atdissuedate
2022-02-23T09:34:44.000
Cb
11
House Num
2052
Onstname
W. 7TH ST.
Atddismissed
No
17526
Atdid: 17526 • Atd Number: ATD-3-6955 • Bblid: 292161
Atdid
17526
Atd Number
ATD-3-6955
Bblid
292161
Inspectionid
396048
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-05T08:29:05.000
Cb
8
House Num
605
Onstname
EASTERN PKWY.
Atddismissed
No
17899
Atdid: 17899 • Atd Number: ATD-4-7078 • Bblid: 701048
Atdid
17899
Atd Number
ATD-4-7078
Bblid
701048
Inspectionid
400447
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-16T11:43:54.000
Cb
7
House Num
144-17
Onstname
38TH AVE.
Atddismissed
No
17584
Atdid: 17584 • Atd Number: ATD-4-6872 • Bblid: 844603
Atdid
17584
Atd Number
ATD-4-6872
Bblid
844603
Inspectionid
396875
Inspect Date
2025-04-30T00:00:00.000
Atdissuedate
2025-05-12T13:14:00.000
Cb
13
House Num
115-72
Onstname
228TH ST.
Atddismissed
No
12643
Atdid: 12643 • Atd Number: ATD-4-5384 • Bblid: 568203
Atdid
12643
Atd Number
ATD-4-5384
Bblid
568203
Inspectionid
358944
Inspect Date
2023-06-23T00:00:00.000
Atdissuedate
2023-06-23T12:34:49.000
Cb
2
House Num
27-17
Onstname
44 DRIVE
Atddismissed
No
17635
Atdid: 17635 • Atd Number: ATD-4-6904 • Bblid: 760888
Atdid
17635
Atd Number
ATD-4-6904
Bblid
760888
Inspectionid
397203
Inspect Date
2025-01-17T00:00:00.000
Atdissuedate
2025-05-16T10:22:18.000
Cb
13
House Num
237-17
Onstname
88TH AVE.
Atddismissed
No
17048
Atdid: 17048 • Atd Number: ATD-3-6707 • Bblid: 265626
Atdid
17048
Atd Number
ATD-3-6707
Bblid
265626
Inspectionid
392376
Inspect Date
2022-06-02T00:00:00.000
Atdissuedate
2025-03-26T15:20:43.000
Cb
7
House Num
460
Onstname
45TH ST.
Atddismissed
No
12365
Atdid: 12365 • Atd Number: ATD-4-5231 • Bblid: 634219
Atdid
12365
Atd Number
ATD-4-5231
Bblid
634219
Inspectionid
357522
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:25:01.000
Cb
2
Onstname
70TH STREET
Atddismissed
No
18205
Atdid: 18205 • Atd Number: ATD-4-7193 • Bblid: 590157
Atdid
18205
Atd Number
ATD-4-7193
Bblid
590157
Inspectionid
403308
Inspect Date
2025-07-29T00:00:00.000
Atdissuedate
2025-07-29T09:28:05.000
Cb
1
House Num
22-69
Onstname
21ST ST.
Atddismissed
No
17904
Atdid: 17904 • Atd Number: ATD-4-7081 • Bblid: 857048
Atdid
17904
Atd Number
ATD-4-7081
Bblid
857048
Inspectionid
400520
Inspect Date
2025-06-10T00:00:00.000
Atdissuedate
2025-06-16T15:12:51.000
Cb
10
House Num
130-48
Onstname
127TH ST.
Atddismissed
No
8606
Atdid: 8606 • Atd Number: ATD-4-3864 • Bblid: 858072
Atdid
8606
Atd Number
ATD-4-3864
Bblid
858072
Inspectionid
330666
Inspect Date
2019-06-21T00:00:00.000
Atdissuedate
2021-12-13T12:55:02.000
Cb
10
House Num
131-22
Onstname
135TH ST.
Atddismissed
No
7946
Atdid: 7946 • Atd Number: ATD-3-2823 • Bblid: 433531
Atdid
7946
Atd Number
ATD-3-2823
Bblid
433531
Inspectionid
315591
Inspect Date
2020-12-02T00:00:00.000
Atdissuedate
2020-12-02T00:00:00.000
Cb
12
House Num
1358
Onstname
49TH ST.
Atddismissed
Yes
Atddismissedon
2022-05-24T10:24:45.000
14897
Atdid: 14897 • Atd Number: ATD-3-6195 • Bblid: 487884
Atdid
14897
Atd Number
ATD-3-6195
Bblid
487884
Inspectionid
380474
Inspect Date
2024-08-08T00:00:00.000
Atdissuedate
2024-08-12T10:26:40.000
Cb
11
House Num
118
Onstname
BAY 40TH ST.
Atddismissed
No
14451
Atdid: 14451 • Atd Number: ATD-4-6033 • Bblid: 585299
Atdid
14451
Atd Number
ATD-4-6033
Bblid
585299
Inspectionid
377197
Inspect Date
2024-04-24T00:00:00.000
Atdissuedate
2024-05-09T14:55:59.000
Cb
1
House Num
22-18
Onstname
43RD ST.
Atddismissed
No
13512
Atdid: 13512 • Atd Number: ATD-3-5567 • Bblid: 332596
Atdid
13512
Atd Number
ATD-3-5567
Bblid
332596
Inspectionid
364678
Inspect Date
2023-09-16T00:00:00.000
Atdissuedate
2023-10-02T11:31:47.000
Cb
1
House Num
272
Onstname
HEWES ST.
Atddismissed
No
10759
Atdid: 10759 • Atd Number: ATD-3-4137 • Bblid: 265293
Atdid
10759
Atd Number
ATD-3-4137
Bblid
265293
Inspectionid
342777
Inspect Date
2022-09-02T00:00:00.000
Atdissuedate
2022-09-06T15:15:22.000
Cb
7
House Num
470
Onstname
44TH ST.
Atddismissed
No
16337
Atdid: 16337 • Atd Number: ATD-4-6408 • Bblid: 869163
Atdid
16337
Atd Number
ATD-4-6408
Bblid
869163
Inspectionid
384782
Inspect Date
2024-10-23T00:00:00.000
Atdissuedate
2024-11-04T12:28:50.000
Cb
12
House Num
155-60
Onstname
116TH DR.
Atddismissed
No
11302
Atdid: 11302 • Atd Number: ATD-3-4591 • Bblid: 278627
Atdid
11302
Atd Number
ATD-3-4591
Bblid
278627
Inspectionid
347292
Inspect Date
2022-10-26T00:00:00.000
Atdissuedate
2022-11-01T10:04:28.000
Cb
6
House Num
323
Onstname
8TH ST.
Atddismissed
No
17467
Atdid: 17467 • Atd Number: ATD-3-6926 • Bblid: 435598
Atdid
17467
Atd Number
ATD-3-6926
Bblid
435598
Inspectionid
395460
Inspect Date
2025-04-22T00:00:00.000
Atdissuedate
2025-04-28T11:57:41.000
Cb
12
House Num
1164
Onstname
55TH ST.
Atddismissed
No
10699
Atdid: 10699 • Atd Number: ATD-3-4082 • Bblid: 259393
Atdid
10699
Atd Number
ATD-3-4082
Bblid
259393
Inspectionid
342106
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-08-29T08:30:47.000
Cb
6
House Num
134
Onstname
DOUGLASS ST.
Atddismissed
No
17616
Atdid: 17616 • Atd Number: ATD-4-6887 • Bblid: 640417
Atdid
17616
Atd Number
ATD-4-6887
Bblid
640417
Inspectionid
397117
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-15T14:48:26.000
Cb
5
House Num
61-03
Onstname
60TH DR.
Atddismissed
No
18397
Atdid: 18397 • Atd Number: ATD-3-7252 • Bblid: 554043
Atdid
18397
Atd Number
ATD-3-7252
Bblid
554043
Inspectionid
404644
Inspect Date
2025-07-19T00:00:00.000
Atdissuedate
2025-08-21T16:48:57.000
Cb
18
House Num
2019
Onstname
E. 53RD PL.
Atddismissed
No
17891
Atdid: 17891 • Atd Number: ATD-3-7047 • Bblid: 443781
Atdid
17891
Atd Number
ATD-3-7047
Bblid
443781
Inspectionid
400370
Inspect Date
2025-06-13T00:00:00.000
Atdissuedate
2025-06-13T15:01:16.000
Cb
10
House Num
260
Onstname
71ST ST.
Atddismissed
No
11721
Atdid: 11721 • Atd Number: ATD-4-5020 • Bblid: 632970
Atdid
11721
Atd Number
ATD-4-5020
Bblid
632970
Inspectionid
352110
Inspect Date
2023-02-27T00:00:00.000
Atdissuedate
2023-02-27T12:08:46.000
Cb
2
House Num
51-33
Onstname
65TH ST.
Atddismissed
No
17874
Atdid: 17874 • Atd Number: ATD-4-7061 • Bblid: 768487
Atdid
17874
Atd Number
ATD-4-7061
Bblid
768487
Inspectionid
400260
Inspect Date
2025-06-11T00:00:00.000
Atdissuedate
2025-06-13T08:57:01.000
Cb
11
House Num
263-07
Onstname
57TH AVE.
Atddismissed
No
18228
Atdid: 18228 • Atd Number: ATD-3-7192 • Bblid: 379456
Atdid
18228
Atd Number
ATD-3-7192
Bblid
379456
Inspectionid
403492
Inspect Date
2025-07-17T00:00:00.000
Atdissuedate
2025-08-04T09:43:52.000
Cb
5
House Num
107
Onstname
RICHMOND ST.
Atddismissed
No
17283
Atdid: 17283 • Atd Number: ATD-4-6744 • Bblid: 854968
Atdid
17283
Atd Number
ATD-4-6744
Bblid
854968
Inspectionid
393470
Inspect Date
2025-04-02T00:00:00.000
Atdissuedate
2025-04-07T12:29:52.000
Cb
10
House Num
117-24
Onstname
133RD ST.
Atddismissed
No
17619
Atdid: 17619 • Atd Number: ATD-4-6890 • Bblid: 640437
Atdid
17619
Atd Number
ATD-4-6890
Bblid
640437
Inspectionid
397123
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-15T14:51:59.000
Cb
5
House Num
60-79
Onstname
60TH DR.
Atddismissed
No
10141
Atdid: 10141 • Atd Number: ATD-3-3755 • Bblid: 362261
Atdid
10141
Atd Number
ATD-3-3755
Bblid
362261
Inspectionid
336808
Inspect Date
2022-05-19T00:00:00.000
Atdissuedate
2022-05-23T13:58:07.000
Cb
4
House Num
83
Onstname
COOPER ST.
Atddismissed
No
12350
Atdid: 12350 • Atd Number: ATD-4-5216 • Bblid: 603428
Atdid
12350
Atd Number
ATD-4-5216
Bblid
603428
Inspectionid
357477
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T11:47:25.000
Cb
2
House Num
56-07
Onstname
QUEENS BOULEVARD
Atddismissed
No
16438
Atdid: 16438 • Atd Number: ATD-4-6455 • Bblid: 735022
Atdid
16438
Atd Number
ATD-4-6455
Bblid
735022
Inspectionid
385432
Inspect Date
2024-11-25T00:00:00.000
Atdissuedate
2024-11-29T07:26:54.000
Cb
8
House Num
73-70
Onstname
136TH ST.
Atddismissed
No
12245
Atdid: 12245 • Atd Number: ATD-2-1062 • Bblid: 144162
Atdid
12245
Atd Number
ATD-2-1062
Bblid
144162
Inspectionid
357206
Inspect Date
2023-05-17T00:00:00.000
Atdissuedate
2023-05-17T11:30:14.000
Cb
4
House Num
1225
Onstname
GERARD AVE.
Atddismissed
No
9837
Atdid: 9837 • Atd Number: ATD-4-4456 • Bblid: 675790
Atdid
9837
Atd Number
ATD-4-4456
Bblid
675790
Inspectionid
334717
Inspect Date
2022-03-31T00:00:00.000
Atdissuedate
2022-04-08T11:29:34.000
Cb
5
House Num
77-07
Onstname
79TH PL.
Atddismissed
No
12458
Atdid: 12458 • Atd Number: ATD-4-5290 • Bblid: 775459
Atdid
12458
Atd Number
ATD-4-5290
Bblid
775459
Inspectionid
357951
Inspect Date
2023-05-31T00:00:00.000
Atdissuedate
2023-06-02T07:49:23.000
Cb
13
House Num
265-04
Onstname
E. WILLISTON AVE.
Atddismissed
No
18146
Atdid: 18146 • Atd Number: ATD-3-7155 • Bblid: 540596
Atdid
18146
Atd Number
ATD-3-7155
Bblid
540596
Inspectionid
402833
Inspect Date
2025-07-11T00:00:00.000
Atdissuedate
2025-07-21T12:26:58.000
Cb
18
House Num
1295
Onstname
E. 91ST ST.
Atddismissed
No
18309
Atdid: 18309 • Atd Number: ATD-4-7236 • Bblid: 643441
Atdid
18309
Atd Number
ATD-4-7236
Bblid
643441
Inspectionid
404105
Inspect Date
2025-08-13T00:00:00.000
Atdissuedate
2025-08-13T11:49:11.000
Cb
5
House Num
69-11
Onstname
59TH DR.
Atddismissed
No
NYC Data AI • Public-data exploration interface