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
8747
Atdid: 8747 • Atd Number: ATD-4-3943 • Bblid: 772531
Atdid
8747
Atd Number
ATD-4-3943
Bblid
772531
Inspectionid
331101
Inspect Date
2021-12-15T00:00:00.000
Atdissuedate
2021-12-28T13:22:35.000
Cb
13
House Num
78-26
Onstname
268TH ST.
Atddismissed
Yes
Atddismissedon
2022-04-08T13:58:39.000
10893
Atdid: 10893 • Atd Number: ATD-3-4264 • Bblid: 282103
Atdid
10893
Atd Number
ATD-3-4264
Bblid
282103
Inspectionid
343586
Inspect Date
2022-09-08T00:00:00.000
Atdissuedate
2022-09-12T13:39:04.000
Cb
6
House Num
236
Onstname
GARFIELD PL.
Atddismissed
No
13049
Atdid: 13049 • Atd Number: ATD-3-5293 • Bblid: 422496
Atdid
13049
Atd Number
ATD-3-5293
Bblid
422496
Inspectionid
361043
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T16:20:43.000
Cb
12
House Num
1654
Onstname
45TH ST.
Atddismissed
No
9211
Atdid: 9211 • Atd Number: ATD-1-186 • Bblid: 136994
Atdid
9211
Atd Number
ATD-1-186
Bblid
136994
Inspectionid
332869
Inspect Date
2013-12-11T00:00:00.000
Atdissuedate
2022-02-28T17:47:16.000
Cb
8
House Num
48
Onstname
FORT CHARLES PL.
Atddismissed
No
11485
Atdid: 11485 • Atd Number: ATD-3-4687 • Bblid: 365576
Atdid
11485
Atd Number
ATD-3-4687
Bblid
365576
Inspectionid
349094
Inspect Date
2022-10-15T00:00:00.000
Atdissuedate
2022-12-08T11:16:05.000
Cb
16
House Num
763
Onstname
SARATOGA AVE.
Atddismissed
No
17454
Atdid: 17454 • Atd Number: ATD-4-6808 • Bblid: 643720
Atdid
17454
Atd Number
ATD-4-6808
Bblid
643720
Inspectionid
395421
Inspect Date
2025-04-22T00:00:00.000
Atdissuedate
2025-04-28T08:37:27.000
Cb
5
House Num
59-41
Onstname
69TH LN.
Atddismissed
No
12261
Atdid: 12261 • Atd Number: ATD-2-1077 • Bblid: 153457
Atdid
12261
Atd Number
ATD-2-1077
Bblid
153457
Inspectionid
357225
Inspect Date
2023-05-17T00:00:00.000
Atdissuedate
2023-05-17T12:16:44.000
Cb
5
House Num
2028
Onstname
JEROME AVE.
Atddismissed
No
17530
Atdid: 17530 • Atd Number: ATD-4-6843 • Bblid: 908395
Atdid
17530
Atd Number
ATD-4-6843
Bblid
908395
Inspectionid
396093
Inspect Date
2025-04-30T00:00:00.000
Atdissuedate
2025-05-05T09:40:42.000
Cb
14
House Num
13-36
Onstname
SAMANTHA DR.
Atddismissed
No
18496
Atdid: 18496 • Atd Number: ATD-2-1461 • Bblid: 202044
Atdid
18496
Atd Number
ATD-2-1461
Bblid
202044
Inspectionid
405246
Inspect Date
2025-08-29T00:00:00.000
Atdissuedate
2025-09-05T08:58:15.000
Cb
11
House Num
1947
Onstname
YATES AVE.
Atddismissed
No
17100
Atdid: 17100 • Atd Number: ATD-3-6747 • Bblid: 414593
Atdid
17100
Atd Number
ATD-3-6747
Bblid
414593
Inspectionid
392480
Inspect Date
2022-05-25T00:00:00.000
Atdissuedate
2025-03-28T10:10:33.000
Cb
7
House Num
82
Onstname
SHERMAN ST.
Atddismissed
No
2319
Atdid: 2319 • Atd Number: ATD-3-1462 • Bblid: 479305
Atdid
2319
Atd Number
ATD-3-1462
Bblid
479305
Violationid
169017
Atdissuedate
2020-08-12T00:00:00.000
Cb
11
House Num
38
Onstname
LAKE STREET
Atddismissed
Yes
Atddismissedon
2023-01-31T12:39:30.000
13829
Atdid: 13829 • Atd Number: ATD-4-5720 • Bblid: 631246
Atdid
13829
Atd Number
ATD-4-5720
Bblid
631246
Inspectionid
370299
Inspect Date
2023-11-24T00:00:00.000
Atdissuedate
2024-01-02T13:45:43.000
Cb
2
House Num
50-19
Onstname
48TH ST.
Atddismissed
No
16885
Atdid: 16885 • Atd Number: ATD-3-6618 • Bblid: 374319
Atdid
16885
Atd Number
ATD-3-6618
Bblid
374319
Inspectionid
390767
Inspect Date
2025-03-05T00:00:00.000
Atdissuedate
2025-03-10T12:00:35.000
Cb
5
House Num
255
Onstname
LINWOOD ST.
Atddismissed
No
17822
Atdid: 17822 • Atd Number: ATD-4-7034 • Bblid: 676343
Atdid
17822
Atd Number
ATD-4-7034
Bblid
676343
Inspectionid
399350
Inspect Date
2025-06-05T00:00:00.000
Atdissuedate
2025-06-06T15:28:33.000
Cb
5
House Num
77-70
Onstname
76TH ST.
Atddismissed
No
15067
Atdid: 15067 • Atd Number: ATD-5-876 • Bblid: 995808
Atdid
15067
Atd Number
ATD-5-876
Bblid
995808
Inspectionid
382034
Inspect Date
2018-03-07T00:00:00.000
Atdissuedate
2024-09-21T14:35:03.000
Cb
2
House Num
65
Onstname
JACQUES AVE.
Atddismissed
No
17080
Atdid: 17080 • Atd Number: ATD-3-6731 • Bblid: 287611
Atdid
17080
Atd Number
ATD-3-6731
Bblid
287611
Inspectionid
392453
Inspect Date
2023-03-09T00:00:00.000
Atdissuedate
2025-03-27T14:58:00.000
Cb
8
House Num
572
Onstname
PARK PL.
Atddismissed
No
16207
Atdid: 16207 • Atd Number: ATD-3-6341 • Bblid: 506825
Atdid
16207
Atd Number
ATD-3-6341
Bblid
506825
Inspectionid
384019
Inspect Date
2024-10-11T00:00:00.000
Atdissuedate
2024-10-11T15:10:09.000
Cb
15
House Num
2117
Onstname
BATCHELDER ST.
Atddismissed
No
16527
Atdid: 16527 • Atd Number: ATD-3-6465 • Bblid: 292011
Atdid
16527
Atd Number
ATD-3-6465
Bblid
292011
Inspectionid
386439
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2024-12-18T07:41:33.000
Cb
8
House Num
435
Onstname
EASTERN PKWY.
Atddismissed
No
18585
Atdid: 18585 • Atd Number: ATD-2-1474 • Bblid: 203250
Atdid
18585
Atd Number
ATD-2-1474
Bblid
203250
Inspectionid
405671
Inspect Date
2025-09-11T00:00:00.000
Atdissuedate
2025-09-11T15:50:53.000
Cb
11
House Num
2108
Onstname
TOMLINSON AVE.
Atddismissed
No
9347
Atdid: 9347 • Atd Number: ATD-3-3444 • Bblid: 497079
Atdid
9347
Atd Number
ATD-3-3444
Bblid
497079
Inspectionid
333070
Inspect Date
2021-01-13T00:00:00.000
Atdissuedate
2022-03-02T17:06:06.000
Cb
15
House Num
2162
Onstname
EAST 8 STREET
Atddismissed
No
9994
Atdid: 9994 • Atd Number: ATD-4-4546 • Bblid: 654491
Atdid
9994
Atd Number
ATD-4-4546
Bblid
654491
Inspectionid
335820
Inspect Date
2022-04-19T00:00:00.000
Atdissuedate
2022-04-29T13:56:55.000
Cb
6
House Num
64-61
Onstname
ELLWELL CRES
Atddismissed
No
16534
Atdid: 16534 • Atd Number: ATD-3-6472 • Bblid: 355800
Atdid
16534
Atd Number
ATD-3-6472
Bblid
355800
Inspectionid
386446
Inspect Date
2024-12-04T00:00:00.000
Atdissuedate
2024-12-18T07:50:37.000
Cb
4
House Num
1057A
Onstname
GREENE AVE.
Atddismissed
No
16340
Atdid: 16340 • Atd Number: ATD-4-6411 • Bblid: 869141
Atdid
16340
Atd Number
ATD-4-6411
Bblid
869141
Inspectionid
384795
Inspect Date
2024-10-23T00:00:00.000
Atdissuedate
2024-11-04T12:37:47.000
Cb
12
House Num
155-20
Onstname
116TH DR.
Atddismissed
No
14453
Atdid: 14453 • Atd Number: ATD-3-5975 • Bblid: 445709
Atdid
14453
Atd Number
ATD-3-5975
Bblid
445709
Violationid
76656
Inspectionid
377230
Inspect Date
2024-05-11T14:50:44.000
Atdissuedate
2024-05-11T14:50:44.000
Cb
10
House Num
571
Onstname
BAY RIDGE PARKWAY
Atddismissed
No
11792
Atdid: 11792 • Atd Number: ATD-2-983 • Bblid: 225314
Atdid
11792
Atd Number
ATD-2-983
Bblid
225314
Violationid
277736
Reinspectionid
33016
Inspect Date
2023-03-14T11:11:31.000
Atdissuedate
2023-03-14T11:11:31.000
Cb
12
House Num
4211
Onstname
BRUNER AVENUE
Atddismissed
No
11751
Atdid: 11751 • Atd Number: ATD-3-4779 • Bblid: 296936
Atdid
11751
Atd Number
ATD-3-4779
Bblid
296936
Inspectionid
352528
Inspect Date
2023-03-09T00:00:00.000
Atdissuedate
2023-03-09T11:21:04.000
Cb
8
House Num
1498
Onstname
PROSPECT PL.
Atddismissed
No
16652
Atdid: 16652 • Atd Number: ATD-2-1331 • Bblid: 163392
Atdid
16652
Atd Number
ATD-2-1331
Bblid
163392
Inspectionid
388508
Inspect Date
2024-12-30T00:00:00.000
Atdissuedate
2025-01-06T13:26:39.000
Cb
5
House Num
2076
Onstname
HARRISON AVE.
Atddismissed
Yes
Atddismissedon
2025-03-03T11:39:36.000
17972
Atdid: 17972 • Atd Number: ATD-3-7082 • Bblid: 275528
Atdid
17972
Atd Number
ATD-3-7082
Bblid
275528
Inspectionid
401191
Inspect Date
2025-05-17T00:00:00.000
Atdissuedate
2025-06-24T16:38:09.000
Cb
6
House Num
66
Onstname
BERKELEY PL.
Atddismissed
No
9452
Atdid: 9452 • Atd Number: ATD-3-3515 • Bblid: 489505
Atdid
9452
Atd Number
ATD-3-3515
Bblid
489505
Inspectionid
333286
Inspect Date
2018-08-29T00:00:00.000
Atdissuedate
2022-03-04T17:40:55.000
Cb
13
House Num
104
Onstname
BAY 50TH ST.
Atddismissed
No
18108
Atdid: 18108 • Atd Number: ATD-4-7158 • Bblid: 832379
Atdid
18108
Atd Number
ATD-4-7158
Bblid
832379
Inspectionid
402545
Inspect Date
2025-07-15T00:00:00.000
Atdissuedate
2025-07-17T11:14:16.000
Cb
12
House Num
99-18
Onstname
205TH PL.
Atddismissed
No
17697
Atdid: 17697 • Atd Number: ATD-4-6953 • Bblid: 755212
Atdid
17697
Atd Number
ATD-4-6953
Bblid
755212
Inspectionid
398056
Inspect Date
2025-05-20T00:00:00.000
Atdissuedate
2025-05-21T12:51:04.000
Cb
11
House Num
225-11
Onstname
HORACE HARDING EXPY.
Atddismissed
No
16744
Atdid: 16744 • Atd Number: ATD-4-6588 • Bblid: 621751
Atdid
16744
Atd Number
ATD-4-6588
Bblid
621751
Inspectionid
388979
Inspect Date
2025-01-03T00:00:00.000
Atdissuedate
2025-01-24T15:07:17.000
Cb
4
House Num
92-45
Onstname
51ST AVE.
Atddismissed
No
15008
Atdid: 15008 • Atd Number: ATD-3-6248 • Bblid: 333607
Atdid
15008
Atd Number
ATD-3-6248
Bblid
333607
Inspectionid
381566
Inspect Date
2024-09-27T00:00:00.000
Atdissuedate
2024-09-09T13:06:20.000
Cb
1
House Num
231
Onstname
LYNCH ST.
Atddismissed
No
12572
Atdid: 12572 • Atd Number: ATD-2-1149 • Bblid: 142086
Atdid
12572
Atd Number
ATD-2-1149
Bblid
142086
Inspectionid
358555
Inspect Date
2023-06-14T00:00:00.000
Atdissuedate
2023-06-14T16:30:19.000
Cb
3
House Num
982
Onstname
BROOK AVENUE
Atddismissed
No
14998
Atdid: 14998 • Atd Number: ATD-3-6239 • Bblid: 329227
Atdid
14998
Atd Number
ATD-3-6239
Bblid
329227
Inspectionid
381502
Inspect Date
2024-08-23T00:00:00.000
Atdissuedate
2024-09-09T09:54:40.000
Cb
2
House Num
98
Onstname
LAFAYETTE AVE.
Atddismissed
No
15039
Atdid: 15039 • Atd Number: ATD-4-6277 • Bblid: 604704
Atdid
15039
Atd Number
ATD-4-6277
Bblid
604704
Inspectionid
381810
Inspect Date
2024-09-11T00:00:00.000
Atdissuedate
2024-09-13T14:27:01.000
Cb
3
House Num
25-34
Onstname
84TH ST.
Atddismissed
No
11793
Atdid: 11793 • Atd Number: ATD-2-984 • Bblid: 210760
Atdid
11793
Atd Number
ATD-2-984
Bblid
210760
Violationid
280504
Reinspectionid
33857
Inspect Date
2023-03-14T11:12:31.000
Atdissuedate
2023-03-14T11:12:31.000
Cb
12
House Num
3217
Onstname
CRUGER AVENUE
Atddismissed
Yes
Atddismissedon
2025-08-05T12:26:43.000
13304
Atdid: 13304 • Atd Number: ATD-3-5457 • Bblid: 312403
Atdid
13304
Atd Number
ATD-3-5457
Bblid
312403
Inspectionid
362481
Inspect Date
2023-08-23T00:00:00.000
Atdissuedate
2023-08-23T09:11:46.000
Cb
3
House Num
149
Onstname
ELLERY ST.
Atddismissed
No
9466
Atdid: 9466 • Atd Number: ATD-4-4245 • Bblid: 734307
Atdid
9466
Atd Number
ATD-4-4245
Bblid
734307
Inspectionid
333366
Inspect Date
2019-08-10T00:00:00.000
Atdissuedate
2022-03-07T15:41:18.000
Cb
8
House Num
144-37
Onstname
69TH AVE.
Atddismissed
No
10603
Atdid: 10603 • Atd Number: ATD-3-4028 • Bblid: 319138
Atdid
10603
Atd Number
ATD-3-4028
Bblid
319138
Inspectionid
340903
Inspect Date
2022-08-03T00:00:00.000
Atdissuedate
2022-08-04T14:51:53.000
Cb
3
House Num
277
Onstname
JEFFERSON AVE.
Atddismissed
No
16391
Atdid: 16391 • Atd Number: ATD-3-6422 • Bblid: 287887
Atdid
16391
Atd Number
ATD-3-6422
Bblid
287887
Inspectionid
385096
Inspect Date
2021-09-15T00:00:00.000
Atdissuedate
2024-11-16T11:57:38.000
Cb
8
House Num
402
Onstname
STERLING PL.
Atddismissed
No
13451
Atdid: 13451 • Atd Number: ATD-4-5538 • Bblid: 670740
Atdid
13451
Atd Number
ATD-4-5538
Bblid
670740
Inspectionid
364059
Inspect Date
2023-09-21T00:00:00.000
Atdissuedate
2023-09-21T14:25:47.000
Cb
5
House Num
69-24
Onstname
64TH PL.
Atddismissed
No
17341
Atdid: 17341 • Atd Number: ATD-4-6760 • Bblid: 817891
Atdid
17341
Atd Number
ATD-4-6760
Bblid
817891
Inspectionid
394492
Inspect Date
2025-03-22T00:00:00.000
Atdissuedate
2025-04-14T09:08:28.000
Cb
12
House Num
106-12
Onstname
RUSCOE ST.
Atddismissed
No
16144
Atdid: 16144 • Atd Number: ATD-3-6312 • Bblid: 266412
Atdid
16144
Atd Number
ATD-3-6312
Bblid
266412
Inspectionid
383464
Inspect Date
2024-09-24T00:00:00.000
Atdissuedate
2024-09-30T11:15:07.000
Cb
12
House Num
840
Onstname
46TH ST.
Atddismissed
No
17827
Atdid: 17827 • Atd Number: ATD-5-981 • Bblid: 967568
Atdid
17827
Atd Number
ATD-5-981
Bblid
967568
Inspectionid
399396
Inspect Date
2025-06-07T00:00:00.000
Atdissuedate
2025-06-07T12:49:51.000
Cb
2
House Num
19
Onstname
DRYSDALE ST.
Atddismissed
No
12259
Atdid: 12259 • Atd Number: ATD-2-1075 • Bblid: 162688
Atdid
12259
Atd Number
ATD-2-1075
Bblid
162688
Inspectionid
357223
Inspect Date
2023-05-17T00:00:00.000
Atdissuedate
2023-05-17T12:13:57.000
Cb
5
House Num
2050
Onstname
JEROME AVENUE
Atddismissed
No
14595
Atdid: 14595 • Atd Number: ATD-3-6042 • Bblid: 506441
Atdid
14595
Atd Number
ATD-3-6042
Bblid
506441
Violationid
291186
Reinspectionid
36519
Inspect Date
2024-06-17T10:12:18.000
Atdissuedate
2024-06-17T10:12:18.000
Cb
15
House Num
2129
Onstname
EAST 23 STREET
Atddismissed
No
14753
Atdid: 14753 • Atd Number: ATD-3-6129 • Bblid: 459180
Atdid
14753
Atd Number
ATD-3-6129
Bblid
459180
Inspectionid
379494
Inspect Date
2024-07-17T00:00:00.000
Atdissuedate
2024-07-17T11:09:43.000
Cb
10
House Num
1333
Onstname
77TH ST.
Atddismissed
No
9168
Atdid: 9168 • Atd Number: ATD-3-3343 • Bblid: 422137
Atdid
9168
Atd Number
ATD-3-3343
Bblid
422137
Inspectionid
332789
Inspect Date
2019-07-11T00:00:00.000
Atdissuedate
2022-02-25T14:30:39.000
Cb
14
House Num
358
Onstname
WEBSTER AVE.
Atddismissed
No
12502
Atdid: 12502 • Atd Number: ATD-4-5328 • Bblid: 792307
Atdid
12502
Atd Number
ATD-4-5328
Bblid
792307
Inspectionid
358047
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T16:24:49.000
Cb
9
Onstname
112 STREET
Atddismissed
No