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
17125
Atdid: 17125 • Atd Number: ATD-3-6770 • Bblid: 510185
Atdid
17125
Atd Number
ATD-3-6770
Bblid
510185
Inspectionid
392533
Inspect Date
2022-04-20T00:00:00.000
Atdissuedate
2025-03-28T15:24:55.000
Cb
15
House Num
2436
Onstname
E. 27TH ST.
Atddismissed
No
16350
Atdid: 16350 • Atd Number: ATD-2-1317 • Bblid: 202128
Atdid
16350
Atd Number
ATD-2-1317
Bblid
202128
Inspectionid
384894
Inspect Date
2024-10-25T00:00:00.000
Atdissuedate
2024-11-06T15:14:30.000
Cb
11
House Num
1924
Onstname
YATES AVE.
Atddismissed
No
17287
Atdid: 17287 • Atd Number: ATD-4-6746 • Bblid: 837460
Atdid
17287
Atd Number
ATD-4-6746
Bblid
837460
Inspectionid
393549
Inspect Date
2025-03-26T00:00:00.000
Atdissuedate
2025-04-08T11:56:49.000
Cb
12
House Num
114-03
Onstname
205TH ST.
Atddismissed
No
9034
Atdid: 9034 • Atd Number: ATD-3-3308 • Bblid: 332024
Atdid
9034
Atd Number
ATD-3-3308
Bblid
332024
Inspectionid
332406
Inspect Date
2019-08-15T00:00:00.000
Atdissuedate
2022-02-11T16:37:39.000
Cb
1
House Num
233
Onstname
HOOPER ST.
Atddismissed
Yes
Atddismissedon
2022-05-24T10:22:50.000
12384
Atdid: 12384 • Atd Number: ATD-4-5250 • Bblid: 604332
Atdid
12384
Atd Number
ATD-4-5250
Bblid
604332
Inspectionid
357541
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:45:49.000
Cb
2
House Num
70-33
Onstname
QUEENS BLVD.
Atddismissed
No
16785
Atdid: 16785 • Atd Number: ATD-1-361 • Bblid: 116872
Atdid
16785
Atd Number
ATD-1-361
Bblid
116872
Inspectionid
389505
Inspect Date
2025-01-02T00:00:00.000
Atdissuedate
2025-02-06T13:32:21.000
Cb
10
House Num
36
Onstname
W. 120TH ST.
Atddismissed
No
18261
Atdid: 18261 • Atd Number: ATD-3-7210 • Bblid: 435224
Atdid
18261
Atd Number
ATD-3-7210
Bblid
435224
Inspectionid
403649
Inspect Date
2025-07-18T00:00:00.000
Atdissuedate
2025-08-05T13:17:23.000
Cb
12
House Num
859
Onstname
55TH ST.
Atddismissed
No
16518
Atdid: 16518 • Atd Number: ATD-3-6457 • Bblid: 282528
Atdid
16518
Atd Number
ATD-3-6457
Bblid
282528
Inspectionid
386325
Inspect Date
2024-12-13T00:00:00.000
Atdissuedate
2024-12-16T13:33:23.000
Cb
6
House Num
601
Onstname
2ND ST.
Atddismissed
No
17116
Atdid: 17116 • Atd Number: ATD-3-6762 • Bblid: 429150
Atdid
17116
Atd Number
ATD-3-6762
Bblid
429150
Inspectionid
392514
Inspect Date
2022-08-25T00:00:00.000
Atdissuedate
2025-03-28T14:13:10.000
Cb
11
House Num
1642
Onstname
66TH ST.
Atddismissed
Yes
Atddismissedon
2025-08-05T12:47:09.000
11613
Atdid: 11613 • Atd Number: ATD-3-4715 • Bblid: 271654
Atdid
11613
Atd Number
ATD-3-4715
Bblid
271654
Inspectionid
350616
Inspect Date
2022-12-29T00:00:00.000
Atdissuedate
2023-01-23T09:16:09.000
Cb
7
House Num
477
Onstname
18TH ST.
Atddismissed
No
11118
Atdid: 11118 • Atd Number: ATD-3-4454 • Bblid: 262924
Atdid
11118
Atd Number
ATD-3-4454
Bblid
262924
Inspectionid
345348
Inspect Date
2022-10-06T00:00:00.000
Atdissuedate
2022-10-07T09:40:33.000
Cb
7
House Num
224
Onstname
19TH ST.
Atddismissed
No
14085
Atdid: 14085 • Atd Number: ATD-4-5877 • Bblid: 620548
Atdid
14085
Atd Number
ATD-4-5877
Bblid
620548
Inspectionid
372880
Inspect Date
2024-03-08T00:00:00.000
Atdissuedate
2024-03-08T12:40:03.000
Cb
4
House Num
88-17
Onstname
54TH AVE.
Atddismissed
No
14464
Atdid: 14464 • Atd Number: ATD-4-6042 • Bblid: 860910
Atdid
14464
Atd Number
ATD-4-6042
Bblid
860910
Inspectionid
377274
Inspect Date
2024-03-12T00:00:00.000
Atdissuedate
2024-05-13T11:36:36.000
Cb
12
House Num
111-59
Onstname
145TH ST.
Atddismissed
No
11583
Atdid: 11583 • Atd Number: ATD-1-281 • Bblid: 133042
Atdid
11583
Atd Number
ATD-1-281
Bblid
133042
Inspectionid
350097
Inspect Date
2022-12-08T00:00:00.000
Atdissuedate
2023-01-09T10:09:41.000
Cb
9
House Num
527
Onstname
W. 148TH ST.
Atddismissed
No
11816
Atdid: 11816 • Atd Number: ATD-2-988 • Bblid: 220692
Atdid
11816
Atd Number
ATD-2-988
Bblid
220692
Inspectionid
353247
Inspect Date
2023-03-16T00:00:00.000
Atdissuedate
2023-03-20T10:02:38.000
Cb
12
House Num
1039
Onstname
E. 223RD ST.
Atddismissed
No
13258
Atdid: 13258 • Atd Number: ATD-3-5429 • Bblid: 422877
Atdid
13258
Atd Number
ATD-3-5429
Bblid
422877
Inspectionid
362078
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T17:00:48.000
Cb
12
House Num
1680
Onstname
47TH ST.
Atddismissed
No
16205
Atdid: 16205 • Atd Number: ATD-3-6339 • Bblid: 279448
Atdid
16205
Atd Number
ATD-3-6339
Bblid
279448
Inspectionid
383994
Inspect Date
2023-02-13T00:00:00.000
Atdissuedate
2024-10-09T13:28:12.000
Cb
6
House Num
197A
Onstname
12TH ST.
Atddismissed
No
18131
Atdid: 18131 • Atd Number: ATD-3-7144 • Bblid: 516150
Atdid
18131
Atd Number
ATD-3-7144
Bblid
516150
Inspectionid
402715
Inspect Date
2025-07-15T00:00:00.000
Atdissuedate
2025-07-18T15:44:01.000
Cb
14
House Num
2809
Onstname
AVENUE L.
Atddismissed
No
11321
Atdid: 11321 • Atd Number: ATD-3-4607 • Bblid: 298981
Atdid
11321
Atd Number
ATD-3-4607
Bblid
298981
Inspectionid
347452
Inspect Date
2022-10-29T00:00:00.000
Atdissuedate
2022-11-01T16:18:31.000
Cb
9
House Num
793
Onstname
MONTGOMERY ST.
Atddismissed
No
12718
Atdid: 12718 • Atd Number: ATD-3-5098 • Bblid: 305539
Atdid
12718
Atd Number
ATD-3-5098
Bblid
305539
Inspectionid
359135
Inspect Date
2023-06-16T00:00:00.000
Atdissuedate
2023-06-30T08:15:58.000
Cb
16
House Num
17
Onstname
PLEASANT PL.
Atddismissed
No
8603
Atdid: 8603 • Atd Number: ATD-4-3861 • Bblid: 735725
Atdid
8603
Atd Number
ATD-4-3861
Bblid
735725
Violationid
275676
Reinspectionid
33116
Inspect Date
2021-12-13T12:39:03.000
Atdissuedate
2021-12-13T12:39:03.000
Cb
8
House Num
137-54
Onstname
71 AVENUE
Atddismissed
No
11558
Atdid: 11558 • Atd Number: ATD-4-4930 • Bblid: 586958
Atdid
11558
Atd Number
ATD-4-4930
Bblid
586958
Inspectionid
349792
Inspect Date
2022-12-23T00:00:00.000
Atdissuedate
2022-12-28T14:10:51.000
Cb
1
House Num
20-11
Onstname
36TH ST.
Atddismissed
No
17581
Atdid: 17581 • Atd Number: ATD-5-974 • Bblid: 933882
Atdid
17581
Atd Number
ATD-5-974
Bblid
933882
Inspectionid
396859
Inspect Date
2025-04-08T00:00:00.000
Atdissuedate
2025-05-12T11:56:15.000
Cb
1
House Num
143
Onstname
DRAKE AVE.
Atddismissed
No
18631
Atdid: 18631 • Atd Number: ATD-3-7342 • Bblid: 391379
Atdid
18631
Atd Number
ATD-3-7342
Bblid
391379
Inspectionid
406200
Inspect Date
2025-03-20T00:00:00.000
Atdissuedate
2025-09-19T17:01:32.000
Cb
17
House Num
35
Onstname
E. 53RD ST.
Atddismissed
No
12941
Atdid: 12941 • Atd Number: ATD-5-767 • Bblid: 1005925
Atdid
12941
Atd Number
ATD-5-767
Bblid
1005925
Inspectionid
360413
Inspect Date
2023-07-06T00:00:00.000
Atdissuedate
2023-07-20T17:00:03.000
Cb
3
House Num
101
Onstname
TYSENS LN.
Atddismissed
No
18453
Atdid: 18453 • Atd Number: ATD-4-7308 • Bblid: 588948
Atdid
18453
Atd Number
ATD-4-7308
Bblid
588948
Inspectionid
404983
Inspect Date
2025-08-28T00:00:00.000
Atdissuedate
2025-08-28T12:58:00.000
Cb
1
House Num
20-24
Onstname
27TH ST.
Atddismissed
No
10591
Atdid: 10591 • Atd Number: ATD-3-4018 • Bblid: 415262
Atdid
10591
Atd Number
ATD-3-4018
Bblid
415262
Inspectionid
340790
Inspect Date
2022-06-01T00:00:00.000
Atdissuedate
2022-08-02T13:13:56.000
Cb
7
House Num
665
Onstname
20TH ST.
Atddismissed
No
14988
Atdid: 14988 • Atd Number: ATD-2-1299 • Bblid: 196710
Atdid
14988
Atd Number
ATD-2-1299
Bblid
196710
Inspectionid
381364
Inspect Date
2024-09-04T00:00:00.000
Atdissuedate
2024-09-04T12:21:32.000
Cb
11
House Num
1564
Onstname
BOGART AVE.
Atddismissed
No
13747
Atdid: 13747 • Atd Number: ATD-5-860 • Bblid: 1015302
Atdid
13747
Atd Number
ATD-5-860
Bblid
1015302
Inspectionid
369106
Inspect Date
2023-11-17T00:00:00.000
Atdissuedate
2023-12-06T12:30:52.000
Cb
3
House Num
17
Onstname
WATERSIDE PKWY.
Atddismissed
No
12678
Atdid: 12678 • Atd Number: ATD-3-5093 • Bblid: 262696
Atdid
12678
Atd Number
ATD-3-5093
Bblid
262696
Violationid
284794
Reinspectionid
35481
Inspect Date
2023-06-29T09:07:32.000
Atdissuedate
2023-06-29T09:07:32.000
Cb
7
House Num
214
Onstname
18 STREET
Atddismissed
No
16335
Atdid: 16335 • Atd Number: ATD-5-888 • Bblid: 1005954
Atdid
16335
Atd Number
ATD-5-888
Bblid
1005954
Inspectionid
384718
Inspect Date
2024-11-01T00:00:00.000
Atdissuedate
2024-11-02T15:43:09.000
Cb
3
House Num
89
Onstname
CRANFORD AVE.
Atddismissed
No
13544
Atdid: 13544 • Atd Number: ATD-4-5583 • Bblid: 730769
Atdid
13544
Atd Number
ATD-4-5583
Bblid
730769
Inspectionid
364965
Inspect Date
2023-10-05T00:00:00.000
Atdissuedate
2023-10-05T11:58:14.000
Cb
11
House Num
42-06
Onstname
219TH ST.
Atddismissed
No
17284
Atdid: 17284 • Atd Number: ATD-4-6745 • Bblid: 660120
Atdid
17284
Atd Number
ATD-4-6745
Bblid
660120
Inspectionid
393472
Inspect Date
2025-03-26T00:00:00.000
Atdissuedate
2025-04-07T12:30:17.000
Cb
6
House Num
74-00
Onstname
KESSEL ST.
Atddismissed
No
3148
Atdid: 3148 • Atd Number: ATD-3-2210 • Bblid: 251296
Atdid
3148
Atd Number
ATD-3-2210
Bblid
251296
Violationid
251733
Atdissuedate
2020-02-13T00:00:00.000
Cb
2
House Num
132
Onstname
DEAN STREET
Atddismissed
Yes
Atddismissedon
2022-08-20T12:01:39.000
10261
Atdid: 10261 • Atd Number: ATD-3-3827 • Bblid: 421383
Atdid
10261
Atd Number
ATD-3-3827
Bblid
421383
Inspectionid
337510
Inspect Date
2022-06-09T00:00:00.000
Atdissuedate
2022-06-09T14:52:52.000
Cb
12
House Num
540
Onstname
E. 9TH ST.
Atddismissed
No
14218
Atdid: 14218 • Atd Number: ATD-4-5920 • Bblid: 659242
Atdid
14218
Atd Number
ATD-4-5920
Bblid
659242
Inspectionid
374112
Inspect Date
2024-03-08T00:00:00.000
Atdissuedate
2024-03-25T09:56:27.000
Cb
6
House Num
71-56
Onstname
INGRAM ST.
Atddismissed
No
10924
Atdid: 10924 • Atd Number: ATD-3-4291 • Bblid: 276344
Atdid
10924
Atd Number
ATD-3-4291
Bblid
276344
Violationid
277978
Reinspectionid
33075
Inspect Date
2022-09-15T13:10:53.000
Atdissuedate
2022-09-15T13:10:53.000
Cb
6
House Num
19
Onstname
GARFIELD PLACE
Atddismissed
No
9477
Atdid: 9477 • Atd Number: ATD-3-3521 • Bblid: 267669
Atdid
9477
Atd Number
ATD-3-3521
Bblid
267669
Inspectionid
333381
Inspect Date
2021-06-25T00:00:00.000
Atdissuedate
2022-03-08T08:30:43.000
Cb
7
House Num
255
Onstname
51ST ST.
Atddismissed
No
4222
Atdid: 4222 • Atd Number: ATD-4-753 • Bblid: 883543
Atdid
4222
Atd Number
ATD-4-753
Bblid
883543
Violationid
172541
Atdissuedate
2020-08-20T00:00:00.000
Cb
13
House Num
131-14
Onstname
229 STREET
Atddismissed
Yes
Atddismissedon
2025-01-17T10:09:00.000
9471
Atdid: 9471 • Atd Number: ATD-4-4250 • Bblid: 735521
Atdid
9471
Atd Number
ATD-4-4250
Bblid
735521
Inspectionid
333372
Inspect Date
2019-07-11T00:00:00.000
Atdissuedate
2022-03-07T16:01:20.000
Cb
8
House Num
137-67
Onstname
75TH RD.
Atddismissed
No
16476
Atdid: 16476 • Atd Number: ATD-2-1325 • Bblid: 140131
Atdid
16476
Atd Number
ATD-2-1325
Bblid
140131
Inspectionid
385733
Inspect Date
2024-11-29T00:00:00.000
Atdissuedate
2024-12-03T12:02:59.000
Cb
1
House Num
415
Onstname
BROOK AVE.
Atddismissed
No
12182
Atdid: 12182 • Atd Number: ATD-4-5180 • Bblid: 880511
Atdid
12182
Atd Number
ATD-4-5180
Bblid
880511
Inspectionid
356821
Inspect Date
2023-05-05T00:00:00.000
Atdissuedate
2023-05-09T13:52:33.000
Cb
13
House Num
119-36
Onstname
227TH ST.
Atddismissed
No
14625
Atdid: 14625 • Atd Number: ATD-3-6062 • Bblid: 425190
Atdid
14625
Atd Number
ATD-3-6062
Bblid
425190
Inspectionid
378572
Inspect Date
2024-06-15T00:00:00.000
Atdissuedate
2024-06-18T10:03:15.000
Cb
12
House Num
1659
Onstname
55TH ST.
Atddismissed
Yes
Atddismissedon
2024-11-06T15:33:43.000
9770
Atdid: 9770 • Atd Number: ATD-2-912 • Bblid: 201716
Atdid
9770
Atd Number
ATD-2-912
Bblid
201716
Inspectionid
334363
Inspect Date
2019-06-22T00:00:00.000
Atdissuedate
2022-03-29T18:04:05.000
Cb
11
House Num
1928
Onstname
HONE AVE.
Atddismissed
No
9987
Atdid: 9987 • Atd Number: ATD-4-4542 • Bblid: 570990
Atdid
9987
Atd Number
ATD-4-4542
Bblid
570990
Inspectionid
335750
Inspect Date
2022-04-27T00:00:00.000
Atdissuedate
2022-04-27T12:31:53.000
Cb
2
House Num
40-15
Onstname
50TH AVE.
Atddismissed
No
11494
Atdid: 11494 • Atd Number: ATD-3-4692 • Bblid: 356178
Atdid
11494
Atd Number
ATD-3-4692
Bblid
356178
Inspectionid
349190
Inspect Date
2022-12-09T00:00:00.000
Atdissuedate
2022-12-12T13:30:30.000
Cb
4
House Num
1374
Onstname
GREENE AVE.
Atddismissed
No
16284
Atdid: 16284 • Atd Number: ATD-4-6396 • Bblid: 654489
Atdid
16284
Atd Number
ATD-4-6396
Bblid
654489
Violationid
281806
Reinspectionid
37616
Inspect Date
2024-10-25T09:12:25.000
Atdissuedate
2024-10-25T09:12:25.000
Cb
6
House Num
64-67
Onstname
ELLWELL CRESCENT
Atddismissed
No
8520
Atdid: 8520 • Atd Number: ATD-4-3832 • Bblid: 846745
Atdid
8520
Atd Number
ATD-4-3832
Bblid
846745
Inspectionid
330003
Inspect Date
2021-11-10T00:00:00.000
Atdissuedate
2021-11-24T11:57:31.000
Cb
10
House Num
92-36
Onstname
SILVER RD.
Atddismissed
No
13170
Atdid: 13170 • Atd Number: ATD-5-795 • Bblid: 1011836
Atdid
13170
Atd Number
ATD-5-795
Bblid
1011836
Inspectionid
361730
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-07T14:44:01.000
Cb
3
House Num
347
Onstname
MONTREAL AVE.
Atddismissed
No
14536
Atdid: 14536 • Atd Number: ATD-1-314 • Bblid: 29274
Atdid
14536
Atd Number
ATD-1-314
Bblid
29274
Inspectionid
377876
Inspect Date
2024-05-24T00:00:00.000
Atdissuedate
2024-05-24T13:43:47.000
Cb
2
House Num
761
Onstname
GREENWICH ST.
Atddismissed
No
NYC Data AI • Public-data exploration interface