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
8877
Atdid: 8877 • Atd Number: ATD-4-4017 • Bblid: 747657
Atdid
8877
Atd Number
ATD-4-4017
Bblid
747657
Inspectionid
331895
Inspect Date
2019-09-12T00:00:00.000
Atdissuedate
2022-01-25T12:32:40.000
Cb
8
House Num
73-20
Onstname
188TH ST.
Atddismissed
No
11953
Atdid: 11953 • Atd Number: ATD-2-1004 • Bblid: 226977
Atdid
11953
Atd Number
ATD-2-1004
Bblid
226977
Inspectionid
354286
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-31T09:13:21.000
Cb
12
House Num
4332
Onstname
ELY AVE.
Atddismissed
No
15047
Atdid: 15047 • Atd Number: ATD-2-1302 • Bblid: 150465
Atdid
15047
Atd Number
ATD-2-1302
Bblid
150465
Inspectionid
381848
Inspect Date
2024-07-15T00:00:00.000
Atdissuedate
2024-09-16T10:39:19.000
Cb
2
House Num
1045
Onstname
BRYANT AVE.
Atddismissed
No
11437
Atdid: 11437 • Atd Number: ATD-3-4658 • Bblid: 255522
Atdid
11437
Atd Number
ATD-3-4658
Bblid
255522
Inspectionid
348468
Inspect Date
2022-11-19T00:00:00.000
Atdissuedate
2022-11-21T10:58:10.000
Cb
6
House Num
366
Onstname
CLINTON ST.
Atddismissed
No
14801
Atdid: 14801 • Atd Number: ATD-3-6141 • Bblid: 480854
Atdid
14801
Atd Number
ATD-3-6141
Bblid
480854
Inspectionid
379851
Inspect Date
2024-07-22T00:00:00.000
Atdissuedate
2024-07-27T09:52:01.000
Cb
14
House Num
1028
Onstname
E. 16TH ST.
Atddismissed
No
12475
Atdid: 12475 • Atd Number: ATD-4-5307 • Bblid: 630698
Atdid
12475
Atd Number
ATD-4-5307
Bblid
630698
Inspectionid
357997
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T11:05:16.000
Cb
2
House Num
45-02
Onstname
48TH AVE.
Atddismissed
No
11493
Atdid: 11493 • Atd Number: ATD-3-4691 • Bblid: 355841
Atdid
11493
Atd Number
ATD-3-4691
Bblid
355841
Inspectionid
349156
Inspect Date
2022-12-08T00:00:00.000
Atdissuedate
2022-12-12T13:18:43.000
Cb
4
House Num
1329
Onstname
GREENE AVE.
Atddismissed
No
10075
Atdid: 10075 • Atd Number: ATD-3-3695 • Bblid: 407421
Atdid
10075
Atd Number
ATD-3-3695
Bblid
407421
Inspectionid
336347
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-11T12:34:23.000
Cb
9
House Num
264
Onstname
MIDWOOD ST.
Atddismissed
No
6949
Atdid: 6949 • Atd Number: ATD-4-3310 • Bblid: 686259
Atdid
6949
Atd Number
ATD-4-3310
Bblid
686259
Violationid
262067
Atdissuedate
2020-06-29T00:00:00.000
Cb
7
House Num
13
Onstname
NORTH DRIVE
Atddismissed
Yes
Atddismissedon
2023-02-24T09:51:37.000
6715
Atdid: 6715 • Atd Number: ATD-4-3076 • Bblid: 818638
Atdid
6715
Atd Number
ATD-4-3076
Bblid
818638
Violationid
252701
Atdissuedate
2020-06-19T00:00:00.000
Cb
12
House Num
110-17
Onstname
177 STREET
Atddismissed
Yes
Atddismissedon
2024-04-01T09:31:30.000
18047
Atdid: 18047 • Atd Number: ATD-4-7128 • Bblid: 770635
Atdid
18047
Atd Number
ATD-4-7128
Bblid
770635
Inspectionid
402039
Inspect Date
2025-06-04T00:00:00.000
Atdissuedate
2025-07-10T12:05:13.000
Cb
13
House Num
84-33
Onstname
248TH ST.
Atddismissed
No
9179
Atdid: 9179 • Atd Number: ATD-4-4186 • Bblid: 715471
Atdid
9179
Atd Number
ATD-4-4186
Bblid
715471
Inspectionid
332837
Inspect Date
2019-07-25T00:00:00.000
Atdissuedate
2022-02-28T15:37:20.000
Cb
7
House Num
47-40
Onstname
163RD ST.
Atddismissed
No
13739
Atdid: 13739 • Atd Number: ATD-3-5667 • Bblid: 407308
Atdid
13739
Atd Number
ATD-3-5667
Bblid
407308
Violationid
291526
Inspectionid
358516
Inspect Date
2023-12-06T09:01:28.000
Atdissuedate
2023-12-06T09:01:28.000
Cb
9
House Num
119
Onstname
MIDWOOD STREET
Atddismissed
No
16455
Atdid: 16455 • Atd Number: ATD-4-6468 • Bblid: 828111
Atdid
16455
Atd Number
ATD-4-6468
Bblid
828111
Inspectionid
385547
Inspect Date
2024-07-15T00:00:00.000
Atdissuedate
2024-12-02T12:13:28.000
Cb
13
House Num
89-05
Onstname
215TH ST.
Atddismissed
No
13608
Atdid: 13608 • Atd Number: ATD-4-5607 • Bblid: 896854
Atdid
13608
Atd Number
ATD-4-5607
Bblid
896854
Inspectionid
365694
Inspect Date
2023-10-05T00:00:00.000
Atdissuedate
2023-10-23T13:47:27.000
Cb
13
House Num
255-11
Onstname
148TH DR.
Atddismissed
No
9938
Atdid: 9938 • Atd Number: ATD-4-4517 • Bblid: 654381
Atdid
9938
Atd Number
ATD-4-4517
Bblid
654381
Inspectionid
335341
Inspect Date
2022-04-13T00:00:00.000
Atdissuedate
2022-04-21T12:08:34.000
Cb
6
House Num
65-41
Onstname
CROMWELL CRES
Atddismissed
No
17730
Atdid: 17730 • Atd Number: ATD-4-6977 • Bblid: 726881
Atdid
17730
Atd Number
ATD-4-6977
Bblid
726881
Inspectionid
398333
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-05-23T13:29:58.000
Cb
11
House Num
32-38
Onstname
BELL BLVD.
Atddismissed
No
14444
Atdid: 14444 • Atd Number: ATD-4-6026 • Bblid: 608300
Atdid
14444
Atd Number
ATD-4-6026
Bblid
608300
Inspectionid
377165
Inspect Date
2024-04-26T00:00:00.000
Atdissuedate
2024-05-09T14:29:01.000
Cb
3
House Num
33-25
Onstname
88TH ST.
Atddismissed
No
13474
Atdid: 13474 • Atd Number: ATD-4-5546 • Bblid: 837193
Atdid
13474
Atd Number
ATD-4-5546
Bblid
837193
Inspectionid
364263
Inspect Date
2023-09-05T00:00:00.000
Atdissuedate
2023-09-25T14:23:17.000
Cb
13
House Num
114-15
Onstname
209TH ST.
Atddismissed
No
13067
Atdid: 13067 • Atd Number: ATD-2-1201 • Bblid: 226582
Atdid
13067
Atd Number
ATD-2-1201
Bblid
226582
Inspectionid
361091
Inspect Date
2023-06-22T00:00:00.000
Atdissuedate
2023-07-31T10:58:33.000
Cb
12
House Num
4329
Onstname
WICKHAM AVE.
Atddismissed
No
12449
Atdid: 12449 • Atd Number: ATD-4-5282 • Bblid: 829893
Atdid
12449
Atd Number
ATD-4-5282
Bblid
829893
Inspectionid
357910
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-31T13:37:15.000
Cb
13
House Num
94-45
Onstname
SPRINGFIELD BLVD.
Atddismissed
No
17486
Atdid: 17486 • Atd Number: ATD-5-965 • Bblid: 1026242
Atdid
17486
Atd Number
ATD-5-965
Bblid
1026242
Inspectionid
395679
Inspect Date
2025-04-19T00:00:00.000
Atdissuedate
2025-04-30T15:23:07.000
Cb
3
House Num
5
Onstname
SALLY CT.
Atddismissed
No
11556
Atdid: 11556 • Atd Number: ATD-4-4928 • Bblid: 586956
Atdid
11556
Atd Number
ATD-4-4928
Bblid
586956
Inspectionid
349788
Inspect Date
2022-12-23T00:00:00.000
Atdissuedate
2022-12-28T14:08:01.000
Cb
1
House Num
20-13
Onstname
36TH ST.
Atddismissed
No
16961
Atdid: 16961 • Atd Number: ATD-3-6652 • Bblid: 458839
Atdid
16961
Atd Number
ATD-3-6652
Bblid
458839
Inspectionid
391601
Inspect Date
2025-03-18T00:00:00.000
Atdissuedate
2025-03-19T08:00:09.000
Cb
11
House Num
1682
Onstname
BAY RIDGE PKWY.
Atddismissed
No
9449
Atdid: 9449 • Atd Number: ATD-3-3512 • Bblid: 414972
Atdid
9449
Atd Number
ATD-3-3512
Bblid
414972
Inspectionid
333283
Inspect Date
2020-02-27T00:00:00.000
Atdissuedate
2022-03-04T17:36:12.000
Cb
7
House Num
123
Onstname
SHERMAN ST.
Atddismissed
No
10877
Atdid: 10877 • Atd Number: ATD-3-4248 • Bblid: 359448
Atdid
10877
Atd Number
ATD-3-4248
Bblid
359448
Inspectionid
343530
Inspect Date
2022-08-26T00:00:00.000
Atdissuedate
2022-09-12T12:38:18.000
Cb
4
House Num
154
Onstname
CORNELIA ST.
Atddismissed
No
18169
Atdid: 18169 • Atd Number: ATD-3-7170 • Bblid: 561546
Atdid
18169
Atd Number
ATD-3-7170
Bblid
561546
Inspectionid
402944
Inspect Date
2025-07-12T00:00:00.000
Atdissuedate
2025-07-22T16:44:02.000
Cb
15
House Num
2718
Onstname
BROWN ST.
Atddismissed
No
16838
Atdid: 16838 • Atd Number: ATD-4-6616 • Bblid: 690230
Atdid
16838
Atd Number
ATD-4-6616
Bblid
690230
Inspectionid
390053
Inspect Date
2025-02-25T00:00:00.000
Atdissuedate
2025-02-27T10:52:23.000
Cb
7
House Num
15-10
Onstname
145TH PL.
Atddismissed
No
13279
Atdid: 13279 • Atd Number: ATD-2-1225 • Bblid: 178123
Atdid
13279
Atd Number
ATD-2-1225
Bblid
178123
Inspectionid
362230
Inspect Date
2023-08-11T00:00:00.000
Atdissuedate
2023-08-21T10:23:37.000
Cb
9
House Num
2018
Onstname
BLACKROCK AVE.
Atddismissed
No
16479
Atdid: 16479 • Atd Number: ATD-3-6438 • Bblid: 359489
Atdid
16479
Atd Number
ATD-3-6438
Bblid
359489
Inspectionid
385741
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2024-12-04T09:41:10.000
Cb
4
House Num
1197
Onstname
JEFFERSON AVE.
Atddismissed
No
14945
Atdid: 14945 • Atd Number: ATD-4-6237 • Bblid: 895752
Atdid
14945
Atd Number
ATD-4-6237
Bblid
895752
Violationid
138777
Inspectionid
380917
Inspect Date
2024-08-22T10:43:48.000
Atdissuedate
2024-08-22T10:43:48.000
Cb
13
House Num
139-39
Onstname
HOOK CREEK BOULEVARD
Atddismissed
No
16635
Atdid: 16635 • Atd Number: ATD-4-6534 • Bblid: 785099
Atdid
16635
Atd Number
ATD-4-6534
Bblid
785099
Inspectionid
388407
Inspect Date
2024-12-23T00:00:00.000
Atdissuedate
2025-01-03T11:14:46.000
Cb
9
House Num
101-64
Onstname
95TH ST.
Atddismissed
No
17945
Atdid: 17945 • Atd Number: ATD-3-7062 • Bblid: 285029
Atdid
17945
Atd Number
ATD-3-7062
Bblid
285029
Inspectionid
400731
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-23T09:59:06.000
Cb
7
House Num
10
Onstname
FULLER PL.
Atddismissed
No
11150
Atdid: 11150 • Atd Number: ATD-2-954 • Bblid: 178951
Atdid
11150
Atd Number
ATD-2-954
Bblid
178951
Inspectionid
345943
Inspect Date
2022-08-16T00:00:00.000
Atdissuedate
2022-10-14T13:15:13.000
Cb
9
House Num
2241
Onstname
CHATTERTON AVE.
Atddismissed
No
16208
Atdid: 16208 • Atd Number: ATD-3-6342 • Bblid: 315517
Atdid
16208
Atd Number
ATD-3-6342
Bblid
315517
Inspectionid
384037
Inspect Date
2016-10-18T00:00:00.000
Atdissuedate
2024-10-11T16:01:20.000
Cb
3
House Num
317
Onstname
BAINBRIDGE ST.
Atddismissed
No
978
Atdid: 978 • Atd Number: ATD-3-121 • Bblid: 455157
Atdid
978
Atd Number
ATD-3-121
Bblid
455157
Violationid
202724
Atdissuedate
2019-12-12T00:00:00.000
Cb
11
House Num
1767
Onstname
70 STREET
Atddismissed
Yes
Atddismissedon
2025-07-24T10:23:22.000
12210
Atdid: 12210 • Atd Number: ATD-2-1059 • Bblid: 242427
Atdid
12210
Atd Number
ATD-2-1059
Bblid
242427
Inspectionid
356865
Inspect Date
2023-05-08T00:00:00.000
Atdissuedate
2023-05-10T13:50:45.000
Cb
10
House Num
670
Onstname
MINNIEFORD AVE.
Atddismissed
No
11253
Atdid: 11253 • Atd Number: ATD-3-4559 • Bblid: 283394
Atdid
11253
Atd Number
ATD-3-4559
Bblid
283394
Inspectionid
346851
Inspect Date
2022-10-18T00:00:00.000
Atdissuedate
2022-10-24T13:15:37.000
Cb
6
House Num
558
Onstname
9TH ST.
Atddismissed
No
13402
Atdid: 13402 • Atd Number: ATD-3-5520 • Bblid: 423885
Atdid
13402
Atd Number
ATD-3-5520
Bblid
423885
Inspectionid
363420
Inspect Date
2018-02-21T00:00:00.000
Atdissuedate
2023-09-12T13:14:32.000
Cb
12
House Num
1719
Onstname
52ND ST.
Atddismissed
No
2153
Atdid: 2153 • Atd Number: ATD-3-1296 • Bblid: 426128
Atdid
2153
Atd Number
ATD-3-1296
Bblid
426128
Violationid
159817
Atdissuedate
2020-08-10T00:00:00.000
Cb
12
House Num
1876
Onstname
58 STREET
Atddismissed
Yes
Atddismissedon
2023-02-07T10:39:31.000
11967
Atdid: 11967 • Atd Number: ATD-4-5093 • Bblid: 757476
Atdid
11967
Atd Number
ATD-4-5093
Bblid
757476
Inspectionid
354383
Inspect Date
2023-04-04T00:00:00.000
Atdissuedate
2023-04-04T11:02:28.000
Cb
11
House Num
64-59
Onstname
229TH ST.
Atddismissed
No
8497
Atdid: 8497 • Atd Number: ATD-3-3099 • Bblid: 259878
Atdid
8497
Atd Number
ATD-3-3099
Bblid
259878
Inspectionid
329628
Inspect Date
2021-11-15T00:00:00.000
Atdissuedate
2021-11-15T16:31:39.000
Cb
6
House Num
379
Onstname
UNION ST.
Atddismissed
No
12279
Atdid: 12279 • Atd Number: ATD-3-5038 • Bblid: 270584
Atdid
12279
Atd Number
ATD-3-5038
Bblid
270584
Violationid
281120
Reinspectionid
33847
Inspect Date
2023-05-18T14:09:05.000
Atdissuedate
2023-05-18T14:09:05.000
Cb
7
House Num
454
Onstname
58 STREET
Atddismissed
No
13407
Atdid: 13407 • Atd Number: ATD-3-5523 • Bblid: 250367
Atdid
13407
Atd Number
ATD-3-5523
Bblid
250367
Inspectionid
363487
Inspect Date
2023-09-13T00:00:00.000
Atdissuedate
2023-09-13T12:56:09.000
Cb
2
House Num
526
Onstname
STATE ST.
Atddismissed
No
16124
Atdid: 16124 • Atd Number: ATD-4-6319 • Bblid: 607277
Atdid
16124
Atd Number
ATD-4-6319
Bblid
607277
Inspectionid
383315
Inspect Date
2024-09-18T00:00:00.000
Atdissuedate
2024-09-27T12:27:19.000
Cb
3
House Num
32-16
Onstname
88TH ST.
Atddismissed
No
13686
Atdid: 13686 • Atd Number: ATD-3-5644 • Bblid: 356741
Atdid
13686
Atd Number
ATD-3-5644
Bblid
356741
Inspectionid
366513
Inspect Date
2023-11-15T00:00:00.000
Atdissuedate
2023-11-15T11:00:29.000
Cb
4
House Num
398
Onstname
BLEECKER ST.
Atddismissed
No
13085
Atdid: 13085 • Atd Number: ATD-3-5314 • Bblid: 485348
Atdid
13085
Atd Number
ATD-3-5314
Bblid
485348
Inspectionid
361267
Inspect Date
2023-07-11T00:00:00.000
Atdissuedate
2023-08-02T10:55:44.000
Cb
15
House Num
1237
Onstname
AVENUE S.
Atddismissed
No
15071
Atdid: 15071 • Atd Number: ATD-4-6281 • Bblid: 747102
Atdid
15071
Atd Number
ATD-4-6281
Bblid
747102
Inspectionid
382055
Inspect Date
2024-09-15T00:00:00.000
Atdissuedate
2024-09-23T11:03:41.000
Cb
8
House Num
69-77
Onstname
179TH ST.
Atddismissed
No
14723
Atdid: 14723 • Atd Number: ATD-4-6141 • Bblid: 631874
Atdid
14723
Atd Number
ATD-4-6141
Bblid
631874
Inspectionid
379270
Inspect Date
2024-06-03T00:00:00.000
Atdissuedate
2024-07-11T12:41:11.000
Cb
2
House Num
51-11
Onstname
64TH ST.
Atddismissed
No
12362
Atdid: 12362 • Atd Number: ATD-4-5228 • Bblid: 634190
Atdid
12362
Atd Number
ATD-4-5228
Bblid
634190
Inspectionid
357519
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:21:23.000
Cb
2
House Num
66-04
Onstname
QUEENS BLVD.
Atddismissed
No
NYC Data AI • Public-data exploration interface