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
11346
Atdid: 11346 • Atd Number: ATD-3-4620 • Bblid: 528796
Atdid
11346
Atd Number
ATD-3-4620
Bblid
528796
Inspectionid
347688
Inspect Date
2022-11-02T00:00:00.000
Atdissuedate
2022-11-07T11:00:32.000
Cb
18
House Num
1369
Onstname
E. 59TH ST.
Atddismissed
No
18220
Atdid: 18220 • Atd Number: ATD-2-1435 • Bblid: 140130
Atdid
18220
Atd Number
ATD-2-1435
Bblid
140130
Violationid
302934
Reinspectionid
39510
Inspect Date
2025-07-30T11:29:14.000
Atdissuedate
2025-07-30T11:29:14.000
Cb
1
House Num
437
Onstname
EAST 147 STREET
Atddismissed
No
17771
Atdid: 17771 • Atd Number: ATD-4-6998 • Bblid: 667062
Atdid
17771
Atd Number
ATD-4-6998
Bblid
667062
Inspectionid
398918
Inspect Date
2025-05-30T00:00:00.000
Atdissuedate
2025-06-02T08:54:10.000
Cb
5
House Num
60-70
Onstname
PALMETTO ST.
Atddismissed
No
13685
Atdid: 13685 • Atd Number: ATD-4-5635 • Bblid: 872100
Atdid
13685
Atd Number
ATD-4-5635
Bblid
872100
Inspectionid
366499
Inspect Date
2023-11-04T00:00:00.000
Atdissuedate
2023-11-14T14:30:23.000
Cb
12
House Num
167-08
Onstname
118TH AVE.
Atddismissed
No
11237
Atdid: 11237 • Atd Number: ATD-3-4543 • Bblid: 302645
Atdid
11237
Atd Number
ATD-3-4543
Bblid
302645
Inspectionid
346796
Inspect Date
2022-10-20T00:00:00.000
Atdissuedate
2022-10-24T10:36:36.000
Cb
16
House Num
670
Onstname
DECATUR ST.
Atddismissed
No
17622
Atdid: 17622 • Atd Number: ATD-4-6893 • Bblid: 572455
Atdid
17622
Atd Number
ATD-4-6893
Bblid
572455
Inspectionid
397146
Inspect Date
2025-05-02T00:00:00.000
Atdissuedate
2025-05-15T15:08:59.000
Cb
1
House Num
35-37
Onstname
28TH ST.
Atddismissed
No
10206
Atdid: 10206 • Atd Number: ATD-4-4630 • Bblid: 794337
Atdid
10206
Atd Number
ATD-4-4630
Bblid
794337
Inspectionid
337229
Inspect Date
2022-05-24T00:00:00.000
Atdissuedate
2022-06-02T13:57:45.000
Cb
9
House Num
95-76
Onstname
111TH ST.
Atddismissed
No
18428
Atdid: 18428 • Atd Number: ATD-4-7297 • Bblid: 728598
Atdid
18428
Atd Number
ATD-4-7297
Bblid
728598
Inspectionid
404874
Inspect Date
2025-08-26T00:00:00.000
Atdissuedate
2025-08-26T11:45:26.000
Cb
11
House Num
219-10
Onstname
36TH AVE.
Atddismissed
No
13042
Atdid: 13042 • Atd Number: ATD-3-5286 • Bblid: 422482
Atdid
13042
Atd Number
ATD-3-5286
Bblid
422482
Inspectionid
361036
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T15:03:07.000
Cb
12
House Num
1636
Onstname
45TH ST.
Atddismissed
No
18005
Atdid: 18005 • Atd Number: ATD-5-993 • Bblid: 1028261
Atdid
18005
Atd Number
ATD-5-993
Bblid
1028261
Inspectionid
401662
Inspect Date
2025-04-28T00:00:00.000
Atdissuedate
2025-06-30T11:44:21.000
Cb
3
House Num
63
Onstname
LUDLOW ST.
Atddismissed
No
14068
Atdid: 14068 • Atd Number: ATD-3-5764 • Bblid: 274922
Atdid
14068
Atd Number
ATD-3-5764
Bblid
274922
Inspectionid
372763
Inspect Date
2024-02-29T00:00:00.000
Atdissuedate
2024-03-05T14:30:08.000
Cb
6
House Num
133
Onstname
SAINT JOHNS PL.
Atddismissed
No
8442
Atdid: 8442 • Atd Number: ATD-4-3805 • Bblid: 1119648
Atdid
8442
Atd Number
ATD-4-3805
Bblid
1119648
Inspectionid
327536
Inspect Date
2021-09-24T00:00:00.000
Atdissuedate
2021-09-24T00:00:00.000
Cb
0
House Num
26-33
Onstname
14TH ST.
Atddismissed
Yes
Atddismissedon
2023-02-24T10:56:58.000
9129
Atdid: 9129 • Atd Number: ATD-3-3320 • Bblid: 354860
Atdid
9129
Atd Number
ATD-3-3320
Bblid
354860
Inspectionid
332680
Inspect Date
2021-08-26T00:00:00.000
Atdissuedate
2022-02-23T08:31:34.000
Cb
4
House Num
404
Onstname
STOCKHOLM ST.
Atddismissed
No
10860
Atdid: 10860 • Atd Number: ATD-3-4231 • Bblid: 306250
Atdid
10860
Atd Number
ATD-3-4231
Bblid
306250
Inspectionid
343475
Inspect Date
2022-08-29T00:00:00.000
Atdissuedate
2022-09-12T11:36:25.000
Cb
3
House Num
437
Onstname
PULASKI ST.
Atddismissed
No
17407
Atdid: 17407 • Atd Number: ATD-3-6899 • Bblid: 357994
Atdid
17407
Atd Number
ATD-3-6899
Bblid
357994
Inspectionid
394983
Inspect Date
2025-03-29T00:00:00.000
Atdissuedate
2025-04-21T10:14:11.000
Cb
4
House Num
299
Onstname
PALMETTO ST.
Atddismissed
No
17845
Atdid: 17845 • Atd Number: ATD-3-7034 • Bblid: 317085
Atdid
17845
Atd Number
ATD-3-7034
Bblid
317085
Inspectionid
399738
Inspect Date
2025-06-10T00:00:00.000
Atdissuedate
2025-06-10T09:03:35.000
Cb
3
House Num
232
Onstname
MONROE ST.
Atddismissed
No
10762
Atdid: 10762 • Atd Number: ATD-3-4140 • Bblid: 265189
Atdid
10762
Atd Number
ATD-3-4140
Bblid
265189
Inspectionid
342780
Inspect Date
2022-09-02T00:00:00.000
Atdissuedate
2022-09-06T15:18:58.000
Cb
7
House Num
434
Onstname
44TH ST.
Atddismissed
No
11199
Atdid: 11199 • Atd Number: ATD-3-4517 • Bblid: 425047
Atdid
11199
Atd Number
ATD-3-4517
Bblid
425047
Inspectionid
346337
Inspect Date
2022-10-12T00:00:00.000
Atdissuedate
2022-10-18T08:36:44.000
Cb
12
House Num
1522
Onstname
54TH ST.
Atddismissed
No
17795
Atdid: 17795 • Atd Number: ATD-4-7015 • Bblid: 758258
Atdid
17795
Atd Number
ATD-4-7015
Bblid
758258
Inspectionid
399180
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-05T10:32:25.000
Cb
11
House Num
78-26
Onstname
220TH PL.
Atddismissed
No
18394
Atdid: 18394 • Atd Number: ATD-3-7249 • Bblid: 554015
Atdid
18394
Atd Number
ATD-3-7249
Bblid
554015
Inspectionid
404639
Inspect Date
2025-07-19T00:00:00.000
Atdissuedate
2025-08-21T16:44:05.000
Cb
18
House Num
2057
Onstname
E. 53RD PL.
Atddismissed
No
11548
Atdid: 11548 • Atd Number: ATD-1-269 • Bblid: 47199
Atdid
11548
Atd Number
ATD-1-269
Bblid
47199
Inspectionid
349768
Inspect Date
2022-12-28T00:00:00.000
Atdissuedate
2022-12-28T12:40:58.000
Cb
6
House Num
303
Onstname
E. 18TH ST.
Atddismissed
No
17986
Atdid: 17986 • Atd Number: ATD-3-7087 • Bblid: 496729
Atdid
17986
Atd Number
ATD-3-7087
Bblid
496729
Inspectionid
401570
Inspect Date
2025-06-25T00:00:00.000
Atdissuedate
2025-06-26T11:30:04.000
Cb
15
House Num
2225
Onstname
E. 4TH ST.
Atddismissed
No
12289
Atdid: 12289 • Atd Number: ATD-2-1086 • Bblid: 163421
Atdid
12289
Atd Number
ATD-2-1086
Bblid
163421
Inspectionid
357338
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T11:42:39.000
Cb
5
House Num
2231
Onstname
JEROME AVENUE
Atddismissed
No
13907
Atdid: 13907 • Atd Number: ATD-3-5718 • Bblid: 407668
Atdid
13907
Atd Number
ATD-3-5718
Bblid
407668
Inspectionid
371188
Inspect Date
2024-01-31T00:00:00.000
Atdissuedate
2024-01-31T11:47:26.000
Cb
9
House Num
23
Onstname
HAWTHORNE ST.
Atddismissed
No
10045
Atdid: 10045 • Atd Number: ATD-4-4586 • Bblid: 654683
Atdid
10045
Atd Number
ATD-4-4586
Bblid
654683
Inspectionid
336108
Inspect Date
2022-04-29T00:00:00.000
Atdissuedate
2022-05-03T14:02:05.000
Cb
6
House Num
62-36
Onstname
CROMWELL CRES
Atddismissed
No
17685
Atdid: 17685 • Atd Number: ATD-4-6941 • Bblid: 873559
Atdid
17685
Atd Number
ATD-4-6941
Bblid
873559
Inspectionid
397721
Inspect Date
2025-05-17T00:00:00.000
Atdissuedate
2025-05-20T10:05:52.000
Cb
12
House Num
178-14
Onstname
BAISLEY BLVD.
Atddismissed
No
12770
Atdid: 12770 • Atd Number: ATD-2-1181 • Bblid: 210820
Atdid
12770
Atd Number
ATD-2-1181
Bblid
210820
Inspectionid
359519
Inspect Date
2023-07-05T00:00:00.000
Atdissuedate
2023-07-06T11:51:13.000
Cb
12
House Num
781
Onstname
S. OAK DR.
Atddismissed
No
11006
Atdid: 11006 • Atd Number: ATD-3-4359 • Bblid: 535738
Atdid
11006
Atd Number
ATD-3-4359
Bblid
535738
Inspectionid
344552
Inspect Date
2022-09-24T00:00:00.000
Atdissuedate
2022-09-26T10:40:18.000
Cb
18
House Num
1209
Onstname
E. 82ND ST.
Atddismissed
No
10051
Atdid: 10051 • Atd Number: ATD-4-4592 • Bblid: 682641
Atdid
10051
Atd Number
ATD-4-4592
Bblid
682641
Inspectionid
336142
Inspect Date
2022-03-19T00:00:00.000
Atdissuedate
2022-05-04T14:23:57.000
Cb
7
House Num
15-45
Onstname
125TH ST.
Atddismissed
No
17591
Atdid: 17591 • Atd Number: ATD-2-1400 • Bblid: 241366
Atdid
17591
Atd Number
ATD-2-1400
Bblid
241366
Inspectionid
396977
Inspect Date
2025-04-02T00:00:00.000
Atdissuedate
2025-05-13T11:03:43.000
Cb
10
House Num
525
Onstname
MINNIEFORD AVE.
Atddismissed
No
14754
Atdid: 14754 • Atd Number: ATD-4-6155 • Bblid: 601781
Atdid
14754
Atd Number
ATD-4-6155
Bblid
601781
Inspectionid
379505
Inspect Date
2024-07-10T00:00:00.000
Atdissuedate
2024-07-17T11:38:36.000
Cb
3
House Num
37-34
Onstname
79TH ST.
Atddismissed
No
16237
Atdid: 16237 • Atd Number: ATD-4-6382 • Bblid: 821594
Atdid
16237
Atd Number
ATD-4-6382
Bblid
821594
Inspectionid
384175
Inspect Date
2023-02-15T00:00:00.000
Atdissuedate
2024-10-15T13:37:26.000
Cb
12
House Num
188-44
Onstname
MANGIN AVE.
Atddismissed
No
16557
Atdid: 16557 • Atd Number: ATD-3-6493 • Bblid: 268170
Atdid
16557
Atd Number
ATD-3-6493
Bblid
268170
Inspectionid
386908
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2024-12-19T12:29:16.000
Cb
7
House Num
334
Onstname
52ND ST.
Atddismissed
No
10882
Atdid: 10882 • Atd Number: ATD-3-4253 • Bblid: 282077
Atdid
10882
Atd Number
ATD-3-4253
Bblid
282077
Inspectionid
343569
Inspect Date
2022-09-02T00:00:00.000
Atdissuedate
2022-09-12T13:27:25.000
Cb
6
House Num
210
Onstname
GARFIELD PL.
Atddismissed
No
16470
Atdid: 16470 • Atd Number: ATD-4-6483 • Bblid: 579135
Atdid
16470
Atd Number
ATD-4-6483
Bblid
579135
Inspectionid
385668
Inspect Date
2024-11-20T00:00:00.000
Atdissuedate
2024-12-02T13:48:54.000
Cb
1
House Num
28-19
Onstname
35TH ST.
Atddismissed
No
13417
Atdid: 13417 • Atd Number: ATD-4-5529 • Bblid: 585988
Atdid
13417
Atd Number
ATD-4-5529
Bblid
585988
Inspectionid
363730
Inspect Date
2023-08-07T00:00:00.000
Atdissuedate
2023-09-18T12:29:15.000
Cb
1
House Num
41-01
Onstname
20TH AVE.
Atddismissed
No
16349
Atdid: 16349 • Atd Number: ATD-2-1316 • Bblid: 202126
Atdid
16349
Atd Number
ATD-2-1316
Bblid
202126
Inspectionid
384889
Inspect Date
2024-10-25T00:00:00.000
Atdissuedate
2024-11-06T15:11:23.000
Cb
11
House Num
1922
Onstname
YATES AVE.
Atddismissed
No
14044
Atdid: 14044 • Atd Number: ATD-2-1262 • Bblid: 207486
Atdid
14044
Atd Number
ATD-2-1262
Bblid
207486
Inspectionid
372623
Inspect Date
2024-03-01T00:00:00.000
Atdissuedate
2024-03-01T12:33:03.000
Cb
11
House Num
2519
Onstname
KINGSLAND AVE.
Atddismissed
No
14905
Atdid: 14905 • Atd Number: ATD-4-6217 • Bblid: 586637
Atdid
14905
Atd Number
ATD-4-6217
Bblid
586637
Inspectionid
380598
Inspect Date
2024-08-12T00:00:00.000
Atdissuedate
2024-08-15T11:43:20.000
Cb
1
House Num
23-62
Onstname
37TH ST.
Atddismissed
No
11103
Atdid: 11103 • Atd Number: ATD-4-4832 • Bblid: 786658
Atdid
11103
Atd Number
ATD-4-4832
Bblid
786658
Inspectionid
345232
Inspect Date
2022-09-29T00:00:00.000
Atdissuedate
2022-10-05T12:53:30.000
Cb
10
House Num
89-03
Onstname
107TH AVE.
Atddismissed
No
9409
Atdid: 9409 • Atd Number: ATD-3-3499 • Bblid: 548945
Atdid
9409
Atd Number
ATD-3-3499
Bblid
548945
Inspectionid
333170
Inspect Date
2021-01-05T00:00:00.000
Atdissuedate
2022-03-03T17:43:25.000
Cb
18
House Num
2023
Onstname
E. 68TH ST.
Atddismissed
No
13938
Atdid: 13938 • Atd Number: ATD-3-5727 • Bblid: 417466
Atdid
13938
Atd Number
ATD-3-5727
Bblid
417466
Inspectionid
371503
Inspect Date
2024-02-01T00:00:00.000
Atdissuedate
2024-02-12T09:19:45.000
Cb
12
House Num
228
Onstname
E. 2ND ST.
Atddismissed
No
16327
Atdid: 16327 • Atd Number: ATD-3-6400 • Bblid: 255512
Atdid
16327
Atd Number
ATD-3-6400
Bblid
255512
Inspectionid
384682
Inspect Date
2022-10-20T00:00:00.000
Atdissuedate
2024-11-02T11:34:42.000
Cb
6
House Num
356
Onstname
CLINTON ST.
Atddismissed
No
13875
Atdid: 13875 • Atd Number: ATD-4-5747 • Bblid: 772082
Atdid
13875
Atd Number
ATD-4-5747
Bblid
772082
Inspectionid
370783
Inspect Date
2024-01-13T00:00:00.000
Atdissuedate
2024-01-18T11:17:25.000
Cb
13
House Num
90-10
Onstname
247TH ST.
Atddismissed
No
12625
Atdid: 12625 • Atd Number: ATD-4-5373 • Bblid: 750143
Atdid
12625
Atd Number
ATD-4-5373
Bblid
750143
Inspectionid
358842
Inspect Date
2023-06-22T00:00:00.000
Atdissuedate
2023-06-22T09:32:00.000
Cb
8
House Num
80-08
Onstname
193RD ST.
Atddismissed
No
17438
Atdid: 17438 • Atd Number: ATD-3-6915 • Bblid: 489597
Atdid
17438
Atd Number
ATD-3-6915
Bblid
489597
Inspectionid
395325
Inspect Date
2025-04-14T00:00:00.000
Atdissuedate
2025-04-24T17:28:29.000
Cb
13
House Num
105
Onstname
BAY 49TH ST.
Atddismissed
No
12809
Atdid: 12809 • Atd Number: ATD-3-5142 • Bblid: 480764
Atdid
12809
Atd Number
ATD-3-5142
Bblid
480764
Inspectionid
359753
Inspect Date
2023-06-21T00:00:00.000
Atdissuedate
2023-07-10T17:14:05.000
Cb
14
House Num
946
Onstname
E. 19TH ST.
Atddismissed
No
13438
Atdid: 13438 • Atd Number: ATD-3-5535 • Bblid: 310835
Atdid
13438
Atd Number
ATD-3-5535
Bblid
310835
Inspectionid
363940
Inspect Date
2023-09-20T00:00:00.000
Atdissuedate
2023-09-20T14:59:36.000
Cb
3
House Num
377
Onstname
DECATUR ST.
Atddismissed
No
17356
Atdid: 17356 • Atd Number: ATD-4-6769 • Bblid: 741845
Atdid
17356
Atd Number
ATD-4-6769
Bblid
741845
Inspectionid
394590
Inspect Date
2025-04-10T00:00:00.000
Atdissuedate
2025-04-14T13:03:25.000
Cb
8
House Num
159-15
Onstname
GRAND CENTRAL PKWY.
Atddismissed
No
12186
Atdid: 12186 • Atd Number: ATD-2-1038 • Bblid: 166775
Atdid
12186
Atd Number
ATD-2-1038
Bblid
166775
Inspectionid
356828
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2023-05-09T14:07:34.000
Cb
7
House Num
2685
Onstname
GRAND CONCOURSE
Atddismissed
No