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
16784
Atdid: 16784 • Atd Number: ATD-3-6583 • Bblid: 341389
Atdid
16784
Atd Number
ATD-3-6583
Bblid
341389
Inspectionid
389398
Inspect Date
2025-02-05T00:00:00.000
Atdissuedate
2025-02-05T13:14:30.000
Cb
1
House Num
125
Onstname
MILTON ST.
Atddismissed
No
17328
Atdid: 17328 • Atd Number: ATD-3-6865 • Bblid: 278669
Atdid
17328
Atd Number
ATD-3-6865
Bblid
278669
Inspectionid
394459
Inspect Date
2025-04-05T00:00:00.000
Atdissuedate
2025-04-14T08:50:02.000
Cb
6
House Num
404
Onstname
7TH ST.
Atddismissed
No
11276
Atdid: 11276 • Atd Number: ATD-4-4858 • Bblid: 617689
Atdid
11276
Atd Number
ATD-4-4858
Bblid
617689
Inspectionid
347046
Inspect Date
2022-10-20T00:00:00.000
Atdissuedate
2022-10-26T15:17:29.000
Cb
3
House Num
101-01
Onstname
34TH AVE.
Atddismissed
No
18250
Atdid: 18250 • Atd Number: ATD-4-7203 • Bblid: 855423
Atdid
18250
Atd Number
ATD-4-7203
Bblid
855423
Inspectionid
403596
Inspect Date
2025-07-25T00:00:00.000
Atdissuedate
2025-08-05T11:20:02.000
Cb
10
House Num
116-44
Onstname
121ST ST.
Atddismissed
No
16486
Atdid: 16486 • Atd Number: ATD-3-6442 • Bblid: 311889
Atdid
16486
Atd Number
ATD-3-6442
Bblid
311889
Inspectionid
385785
Inspect Date
2024-12-06T00:00:00.000
Atdissuedate
2024-12-06T12:01:59.000
Cb
3
House Num
38
Onstname
SCHENECTADY AVE.
Atddismissed
No
16411
Atdid: 16411 • Atd Number: ATD-1-330 • Bblid: 126230
Atdid
16411
Atd Number
ATD-1-330
Bblid
126230
Violationid
299398
Reinspectionid
37847
Inspect Date
2024-11-19T14:52:48.000
Atdissuedate
2024-11-19T14:52:48.000
Cb
10
House Num
156
Onstname
WEST 120 STREET
Atddismissed
No
14511
Atdid: 14511 • Atd Number: ATD-4-6069 • Bblid: 856199
Atdid
14511
Atd Number
ATD-4-6069
Bblid
856199
Inspectionid
377662
Inspect Date
2024-05-08T00:00:00.000
Atdissuedate
2024-05-21T11:14:28.000
Cb
10
House Num
133-34
Onstname
117TH ST.
Atddismissed
No
13181
Atdid: 13181 • Atd Number: ATD-4-5499 • Bblid: 654760
Atdid
13181
Atd Number
ATD-4-5499
Bblid
654760
Inspectionid
361811
Inspect Date
2023-08-04T00:00:00.000
Atdissuedate
2023-08-10T09:44:51.000
Cb
6
House Num
63-29
Onstname
ELLWELL CRES
Atddismissed
No
9219
Atdid: 9219 • Atd Number: ATD-3-3367 • Bblid: 468021
Atdid
9219
Atd Number
ATD-3-3367
Bblid
468021
Inspectionid
332877
Inspect Date
2021-05-14T00:00:00.000
Atdissuedate
2022-02-28T17:55:08.000
Cb
11
House Num
200
Onstname
BAY 14TH ST.
Atddismissed
No
17544
Atdid: 17544 • Atd Number: ATD-4-6856 • Bblid: 871701
Atdid
17544
Atd Number
ATD-4-6856
Bblid
871701
Inspectionid
396300
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-06T10:02:42.000
Cb
12
House Num
117-72
Onstname
MARSDEN ST.
Atddismissed
No
18254
Atdid: 18254 • Atd Number: ATD-3-7206 • Bblid: 307490
Atdid
18254
Atd Number
ATD-3-7206
Bblid
307490
Inspectionid
403612
Inspect Date
2025-07-25T00:00:00.000
Atdissuedate
2025-08-05T11:33:56.000
Cb
3
House Num
948
Onstname
GREENE AVE.
Atddismissed
No
9631
Atdid: 9631 • Atd Number: ATD-4-4335 • Bblid: 893619
Atdid
9631
Atd Number
ATD-4-4335
Bblid
893619
Inspectionid
333800
Inspect Date
2021-05-11T00:00:00.000
Atdissuedate
2022-03-15T18:51:44.000
Cb
13
House Num
226-20
Onstname
144TH AVE.
Atddismissed
No
11285
Atdid: 11285 • Atd Number: ATD-4-4866 • Bblid: 672781
Atdid
11285
Atd Number
ATD-4-4866
Bblid
672781
Inspectionid
347071
Inspect Date
2022-10-19T00:00:00.000
Atdissuedate
2022-10-27T10:43:19.000
Cb
5
House Num
71-53
Onstname
70TH ST.
Atddismissed
No
13427
Atdid: 13427 • Atd Number: ATD-3-5533 • Bblid: 309261
Atdid
13427
Atd Number
ATD-3-5533
Bblid
309261
Inspectionid
363852
Inspect Date
2023-09-19T00:00:00.000
Atdissuedate
2023-09-19T11:00:18.000
Cb
3
House Num
613
Onstname
HANCOCK ST.
Atddismissed
No
18302
Atdid: 18302 • Atd Number: ATD-4-7231 • Bblid: 858588
Atdid
18302
Atd Number
ATD-4-7231
Bblid
858588
Inspectionid
404009
Inspect Date
2025-08-08T00:00:00.000
Atdissuedate
2025-08-12T09:24:19.000
Cb
10
House Num
135-11
Onstname
114TH ST.
Atddismissed
No
14145
Atdid: 14145 • Atd Number: ATD-3-5807 • Bblid: 448431
Atdid
14145
Atd Number
ATD-3-5807
Bblid
448431
Inspectionid
373466
Inspect Date
2024-03-12T00:00:00.000
Atdissuedate
2024-03-18T16:07:21.000
Cb
10
House Num
317
Onstname
80TH ST.
Atddismissed
No
10990
Atdid: 10990 • Atd Number: ATD-3-4343 • Bblid: 286634
Atdid
10990
Atd Number
ATD-3-4343
Bblid
286634
Inspectionid
344460
Inspect Date
2022-09-22T00:00:00.000
Atdissuedate
2022-09-23T14:16:36.000
Cb
8
House Num
279
Onstname
PROSPECT PL.
Atddismissed
No
12776
Atdid: 12776 • Atd Number: ATD-4-5415 • Bblid: 876137
Atdid
12776
Atd Number
ATD-4-5415
Bblid
876137
Inspectionid
359529
Inspect Date
2023-05-06T00:00:00.000
Atdissuedate
2023-07-06T14:41:31.000
Cb
12
House Num
190-01
Onstname
119TH AVE.
Atddismissed
No
16713
Atdid: 16713 • Atd Number: ATD-1-357 • Bblid: 116986
Atdid
16713
Atd Number
ATD-1-357
Bblid
116986
Inspectionid
388825
Inspect Date
2024-11-29T00:00:00.000
Atdissuedate
2025-01-21T14:17:16.000
Cb
10
House Num
78
Onstname
W. 127TH ST.
Atddismissed
No
14602
Atdid: 14602 • Atd Number: ATD-4-6098 • Bblid: 569111
Atdid
14602
Atd Number
ATD-4-6098
Bblid
569111
Inspectionid
378452
Inspect Date
2024-06-12T00:00:00.000
Atdissuedate
2024-06-17T11:31:14.000
Cb
2
House Num
39-12
Onstname
47TH ST.
Atddismissed
No
16752
Atdid: 16752 • Atd Number: ATD-4-6594 • Bblid: 579645
Atdid
16752
Atd Number
ATD-4-6594
Bblid
579645
Inspectionid
389065
Inspect Date
2024-12-26T00:00:00.000
Atdissuedate
2025-01-29T11:14:24.000
Cb
1
House Num
36-04
Onstname
36TH AVE.
Atddismissed
No
10011
Atdid: 10011 • Atd Number: ATD-3-3669 • Bblid: 275674
Atdid
10011
Atd Number
ATD-3-3669
Bblid
275674
Violationid
198530
Inspectionid
335894
Inspect Date
2022-05-02T10:49:14.000
Atdissuedate
2022-05-02T10:49:14.000
Cb
6
House Num
124
Onstname
BERKELEY PLACE
Atddismissed
No
17864
Atdid: 17864 • Atd Number: ATD-4-7051 • Bblid: 768533
Atdid
17864
Atd Number
ATD-4-7051
Bblid
768533
Inspectionid
400221
Inspect Date
2025-06-11T00:00:00.000
Atdissuedate
2025-06-13T08:37:36.000
Cb
11
House Num
58-23
Onstname
HEWLETT ST.
Atddismissed
No
12827
Atdid: 12827 • Atd Number: ATD-2-1190 • Bblid: 196152
Atdid
12827
Atd Number
ATD-2-1190
Bblid
196152
Inspectionid
359890
Inspect Date
2023-06-23T00:00:00.000
Atdissuedate
2023-07-12T11:28:16.000
Cb
11
House Num
1731
Onstname
MATTHEWS AVE.
Atddismissed
No
17360
Atdid: 17360 • Atd Number: ATD-3-6879 • Bblid: 272045
Atdid
17360
Atd Number
ATD-3-6879
Bblid
272045
Inspectionid
394657
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-14T15:04:42.000
Cb
7
House Num
316
Onstname
19TH ST.
Atddismissed
No
18434
Atdid: 18434 • Atd Number: ATD-3-7271 • Bblid: 307427
Atdid
18434
Atd Number
ATD-3-7271
Bblid
307427
Inspectionid
404892
Inspect Date
2025-08-14T00:00:00.000
Atdissuedate
2025-08-27T10:46:30.000
Cb
3
House Num
847
Onstname
GREENE AVE.
Atddismissed
No
9375
Atdid: 9375 • Atd Number: ATD-3-3472 • Bblid: 447621
Atdid
9375
Atd Number
ATD-3-3472
Bblid
447621
Inspectionid
333100
Inspect Date
2022-03-03T00:00:00.000
Atdissuedate
2022-03-03T08:43:34.000
Cb
10
House Num
1047
Onstname
78TH ST.
Atddismissed
No
15025
Atdid: 15025 • Atd Number: ATD-4-6271 • Bblid: 659124
Atdid
15025
Atd Number
ATD-4-6271
Bblid
659124
Inspectionid
381632
Inspect Date
2024-09-05T00:00:00.000
Atdissuedate
2024-09-09T14:19:47.000
Cb
6
House Num
71-37
Onstname
LOUBET ST.
Atddismissed
No
16638
Atdid: 16638 • Atd Number: ATD-4-6537 • Bblid: 785688
Atdid
16638
Atd Number
ATD-4-6537
Bblid
785688
Inspectionid
388462
Inspect Date
2024-12-30T00:00:00.000
Atdissuedate
2025-01-03T12:15:25.000
Cb
10
House Num
107-64
Onstname
77TH ST.
Atddismissed
No
10931
Atdid: 10931 • Atd Number: ATD-3-4296 • Bblid: 457557
Atdid
10931
Atd Number
ATD-3-4296
Bblid
457557
Inspectionid
343948
Inspect Date
2022-09-16T00:00:00.000
Atdissuedate
2022-09-16T15:05:55.000
Cb
11
House Num
1849
Onstname
74TH ST.
Atddismissed
No
11650
Atdid: 11650 • Atd Number: ATD-4-4984 • Bblid: 649415
Atdid
11650
Atd Number
ATD-4-4984
Bblid
649415
Inspectionid
351300
Inspect Date
2023-01-12T00:00:00.000
Atdissuedate
2023-02-09T13:51:33.000
Cb
5
House Num
63-40
Onstname
77TH ST.
Atddismissed
No
13853
Atdid: 13853 • Atd Number: ATD-3-5697 • Bblid: 511702
Atdid
13853
Atd Number
ATD-3-5697
Bblid
511702
Inspectionid
370493
Inspect Date
2024-01-08T00:00:00.000
Atdissuedate
2024-01-09T12:01:36.000
Cb
15
House Num
2549
Onstname
E. 29TH ST.
Atddismissed
No
14581
Atdid: 14581 • Atd Number: ATD-3-6035 • Bblid: 445823
Atdid
14581
Atd Number
ATD-3-6035
Bblid
445823
Inspectionid
378362
Inspect Date
2024-06-05T00:00:00.000
Atdissuedate
2024-06-11T15:29:25.000
Cb
10
House Num
641
Onstname
BAY RIDGE PKWY.
Atddismissed
No
10761
Atdid: 10761 • Atd Number: ATD-3-4139 • Bblid: 265191
Atdid
10761
Atd Number
ATD-3-4139
Bblid
265191
Inspectionid
342779
Inspect Date
2022-09-02T00:00:00.000
Atdissuedate
2022-09-06T15:16:48.000
Cb
7
House Num
436
Onstname
44TH ST.
Atddismissed
No
11894
Atdid: 11894 • Atd Number: ATD-2-996 • Bblid: 219478
Atdid
11894
Atd Number
ATD-2-996
Bblid
219478
Inspectionid
353936
Inspect Date
2023-03-24T00:00:00.000
Atdissuedate
2023-03-27T12:26:26.000
Cb
12
House Num
841
Onstname
E. 227TH ST.
Atddismissed
No
13661
Atdid: 13661 • Atd Number: ATD-3-5628 • Bblid: 342380
Atdid
13661
Atd Number
ATD-3-5628
Bblid
342380
Inspectionid
366350
Inspect Date
2023-11-01T00:00:00.000
Atdissuedate
2023-11-06T11:39:54.000
Cb
1
House Num
144
Onstname
MESEROLE AVE.
Atddismissed
No
8524
Atdid: 8524 • Atd Number: ATD-4-3836 • Bblid: 661617
Atdid
8524
Atd Number
ATD-4-3836
Bblid
661617
Inspectionid
330019
Inspect Date
2021-11-19T00:00:00.000
Atdissuedate
2021-11-24T12:50:18.000
Cb
6
House Num
111-11
Onstname
77TH AVE.
Atddismissed
No
17258
Atdid: 17258 • Atd Number: ATD-4-6738 • Bblid: 861900
Atdid
17258
Atd Number
ATD-4-6738
Bblid
861900
Inspectionid
393248
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-04T14:36:03.000
Cb
12
House Num
114-27
Onstname
148TH ST.
Atddismissed
No
12555
Atdid: 12555 • Atd Number: ATD-3-5072 • Bblid: 407264
Atdid
12555
Atd Number
ATD-3-5072
Bblid
407264
Inspectionid
358499
Inspect Date
2023-05-17T00:00:00.000
Atdissuedate
2023-06-13T14:36:13.000
Cb
9
House Num
175
Onstname
MIDWOOD ST.
Atddismissed
No
16519
Atdid: 16519 • Atd Number: ATD-3-6458 • Bblid: 282526
Atdid
16519
Atd Number
ATD-3-6458
Bblid
282526
Inspectionid
386327
Inspect Date
2024-12-13T00:00:00.000
Atdissuedate
2024-12-16T13:34:03.000
Cb
6
House Num
605
Onstname
2ND ST.
Atddismissed
No
16524
Atdid: 16524 • Atd Number: ATD-3-6463 • Bblid: 259392
Atdid
16524
Atd Number
ATD-3-6463
Bblid
259392
Inspectionid
386410
Inspect Date
2024-10-02T00:00:00.000
Atdissuedate
2024-12-17T13:23:40.000
Cb
6
House Num
370
Onstname
DEGRAW ST.
Atddismissed
No
10714
Atdid: 10714 • Atd Number: ATD-3-4097 • Bblid: 269539
Atdid
10714
Atd Number
ATD-3-4097
Bblid
269539
Inspectionid
342240
Inspect Date
2022-05-12T00:00:00.000
Atdissuedate
2022-08-30T08:18:57.000
Cb
7
House Num
453
Onstname
56TH ST.
Atddismissed
No
12156
Atdid: 12156 • Atd Number: ATD-3-4987 • Bblid: 258043
Atdid
12156
Atd Number
ATD-3-4987
Bblid
258043
Inspectionid
356691
Inspect Date
2023-05-05T00:00:00.000
Atdissuedate
2023-05-05T14:04:02.000
Cb
2
House Num
159
Onstname
WYCKOFF ST.
Atddismissed
No
9069
Atdid: 9069 • Atd Number: ATD-4-4119 • Bblid: 584439
Atdid
9069
Atd Number
ATD-4-4119
Bblid
584439
Inspectionid
332584
Inspect Date
2019-08-29T00:00:00.000
Atdissuedate
2022-02-18T16:10:18.000
Cb
1
House Num
20-45
Onstname
47TH ST.
Atddismissed
No
11644
Atdid: 11644 • Atd Number: ATD-4-4980 • Bblid: 669774
Atdid
11644
Atd Number
ATD-4-4980
Bblid
669774
Inspectionid
351023
Inspect Date
2023-01-09T00:00:00.000
Atdissuedate
2023-02-07T12:37:20.000
Cb
5
House Num
74-20
Onstname
64TH PL.
Atddismissed
No
13336
Atdid: 13336 • Atd Number: ATD-3-5478 • Bblid: 403931
Atdid
13336
Atd Number
ATD-3-5478
Bblid
403931
Inspectionid
362676
Inspect Date
2023-08-23T00:00:00.000
Atdissuedate
2023-08-28T11:49:51.000
Cb
17
House Num
1291
Onstname
ALBANY AVE.
Atddismissed
Yes
Atddismissedon
2023-08-28T11:58:17.000
14712
Atdid: 14712 • Atd Number: ATD-4-6134 • Bblid: 777100
Atdid
14712
Atd Number
ATD-4-6134
Bblid
777100
Inspectionid
379213
Inspect Date
2024-05-29T00:00:00.000
Atdissuedate
2024-07-09T12:46:54.000
Cb
9
House Num
86-32
Onstname
90TH ST.
Atddismissed
No
14343
Atdid: 14343 • Atd Number: ATD-3-5911 • Bblid: 460820
Atdid
14343
Atd Number
ATD-3-5911
Bblid
460820
Inspectionid
375999
Inspect Date
2024-04-19T00:00:00.000
Atdissuedate
2024-04-23T16:09:53.000
Cb
10
House Num
7821
Onstname
12TH AVE.
Atddismissed
No
13324
Atdid: 13324 • Atd Number: ATD-2-1230 • Bblid: 210504
Atdid
13324
Atd Number
ATD-2-1230
Bblid
210504
Inspectionid
362622
Inspect Date
2023-08-15T00:00:00.000
Atdissuedate
2023-08-28T11:08:29.000
Cb
12
House Num
713
Onstname
ROSEWOOD ST.
Atddismissed
No
11933
Atdid: 11933 • Atd Number: ATD-3-4884 • Bblid: 286553
Atdid
11933
Atd Number
ATD-3-4884
Bblid
286553
Inspectionid
354190
Inspect Date
2023-03-28T00:00:00.000
Atdissuedate
2023-03-29T12:44:24.000
Cb
8
House Num
175
Onstname
PROSPECT PL.
Atddismissed
No
NYC Data AI • Public-data exploration interface