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
12039
Atdid: 12039 • Atd Number: ATD-3-4932 • Bblid: 448503
Atdid
12039
Atd Number
ATD-3-4932
Bblid
448503
Violationid
282116
Reinspectionid
34015
Inspect Date
2023-04-17T10:19:45.000
Atdissuedate
2023-04-17T10:19:45.000
Cb
10
House Num
447
Onstname
80 STREET
Atddismissed
No
16660
Atdid: 16660 • Atd Number: ATD-3-6528 • Bblid: 515888
Atdid
16660
Atd Number
ATD-3-6528
Bblid
515888
Inspectionid
388549
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2025-01-08T10:19:58.000
Cb
18
House Num
1184
Onstname
E. 38TH ST.
Atddismissed
No
11427
Atdid: 11427 • Atd Number: ATD-3-4649 • Bblid: 255500
Atdid
11427
Atd Number
ATD-3-4649
Bblid
255500
Inspectionid
348442
Inspect Date
2022-11-19T00:00:00.000
Atdissuedate
2022-11-21T10:45:30.000
Cb
6
House Num
344
Onstname
CLINTON ST.
Atddismissed
Yes
Atddismissedon
2023-02-10T11:51:14.000
17759
Atdid: 17759 • Atd Number: ATD-4-6989 • Bblid: 651181
Atdid
17759
Atd Number
ATD-4-6989
Bblid
651181
Inspectionid
398748
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-05-28T16:22:53.000
Cb
5
House Num
64-25
Onstname
73RD PL.
Atddismissed
No
14696
Atdid: 14696 • Atd Number: ATD-4-6123 • Bblid: 709277
Atdid
14696
Atd Number
ATD-4-6123
Bblid
709277
Inspectionid
379074
Inspect Date
2024-06-27T00:00:00.000
Atdissuedate
2024-07-08T10:08:45.000
Cb
7
House Num
33-19
Onstname
155TH ST.
Atddismissed
No
14013
Atdid: 14013 • Atd Number: ATD-4-5835 • Bblid: 839921
Atdid
14013
Atd Number
ATD-4-5835
Bblid
839921
Inspectionid
372187
Inspect Date
2024-02-21T00:00:00.000
Atdissuedate
2024-02-26T10:47:50.000
Cb
13
House Num
209-26
Onstname
BARDWELL AVE.
Atddismissed
No
15032
Atdid: 15032 • Atd Number: ATD-4-6273 • Bblid: 595097
Atdid
15032
Atd Number
ATD-4-6273
Bblid
595097
Inspectionid
381686
Inspect Date
2024-09-06T00:00:00.000
Atdissuedate
2024-09-11T10:40:26.000
Cb
3
House Num
23-66
Onstname
92ND ST.
Atddismissed
No
17971
Atdid: 17971 • Atd Number: ATD-4-7095 • Bblid: 842924
Atdid
17971
Atd Number
ATD-4-7095
Bblid
842924
Inspectionid
400939
Inspect Date
2025-06-17T00:00:00.000
Atdissuedate
2025-06-24T14:12:10.000
Cb
13
House Num
217-27
Onstname
114TH RD.
Atddismissed
No
14481
Atdid: 14481 • Atd Number: ATD-4-6052 • Bblid: 896631
Atdid
14481
Atd Number
ATD-4-6052
Bblid
896631
Inspectionid
377408
Inspect Date
2024-05-16T00:00:00.000
Atdissuedate
2024-05-16T16:05:19.000
Cb
13
House Num
149-82
Onstname
WELLER LN.
Atddismissed
No
9015
Atdid: 9015 • Atd Number: ATD-3-3297 • Bblid: 493805
Atdid
9015
Atd Number
ATD-3-3297
Bblid
493805
Inspectionid
332373
Inspect Date
2019-06-15T00:00:00.000
Atdissuedate
2022-02-10T10:41:38.000
Cb
11
House Num
1928
Onstname
W. 5TH ST.
Atddismissed
No
17843
Atdid: 17843 • Atd Number: ATD-4-7041 • Bblid: 823659
Atdid
17843
Atd Number
ATD-4-7041
Bblid
823659
Inspectionid
399679
Inspect Date
2025-06-06T00:00:00.000
Atdissuedate
2025-06-09T13:01:49.000
Cb
8
House Num
191-48
Onstname
FOOTHILL AVE.
Atddismissed
No
12575
Atdid: 12575 • Atd Number: ATD-2-1152 • Bblid: 150067
Atdid
12575
Atd Number
ATD-2-1152
Bblid
150067
Inspectionid
358576
Inspect Date
2023-06-15T00:00:00.000
Atdissuedate
2023-06-15T09:56:01.000
Cb
2
House Num
1126
Onstname
LONGWOOD AVENUE
Atddismissed
No
8825
Atdid: 8825 • Atd Number: ATD-3-3236 • Bblid: 309483
Atdid
8825
Atd Number
ATD-3-3236
Bblid
309483
Inspectionid
331607
Inspect Date
2015-12-11T00:00:00.000
Atdissuedate
2022-01-13T11:27:17.000
Cb
3
House Num
816
Onstname
JEFFERSON AVE.
Atddismissed
No
10835
Atdid: 10835 • Atd Number: ATD-3-4206 • Bblid: 262305
Atdid
10835
Atd Number
ATD-3-4206
Bblid
262305
Inspectionid
343344
Inspect Date
2022-09-09T00:00:00.000
Atdissuedate
2022-09-12T10:09:00.000
Cb
6
House Num
67
Onstname
DIKEMAN ST.
Atddismissed
No
13257
Atdid: 13257 • Atd Number: ATD-3-5428 • Bblid: 422875
Atdid
13257
Atd Number
ATD-3-5428
Bblid
422875
Inspectionid
362077
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T17:00:25.000
Cb
12
House Num
1678
Onstname
47TH ST.
Atddismissed
No
12474
Atdid: 12474 • Atd Number: ATD-4-5306 • Bblid: 569775
Atdid
12474
Atd Number
ATD-4-5306
Bblid
569775
Inspectionid
357987
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T10:56:09.000
Cb
2
House Num
45-01
Onstname
48TH AVE.
Atddismissed
No
17045
Atdid: 17045 • Atd Number: ATD-3-6704 • Bblid: 265151
Atdid
17045
Atd Number
ATD-3-6704
Bblid
265151
Inspectionid
392373
Inspect Date
2022-05-02T00:00:00.000
Atdissuedate
2025-03-26T14:52:05.000
Cb
7
House Num
758
Onstname
43RD ST.
Atddismissed
No
14946
Atdid: 14946 • Atd Number: ATD-4-6238 • Bblid: 807757
Atdid
14946
Atd Number
ATD-4-6238
Bblid
807757
Violationid
296796
Reinspectionid
37436
Inspect Date
2024-08-22T14:14:08.000
Atdissuedate
2024-08-22T14:14:08.000
Cb
8
House Num
87-33
Onstname
164 STREET
Atddismissed
No
12891
Atdid: 12891 • Atd Number: ATD-3-5181 • Bblid: 510427
Atdid
12891
Atd Number
ATD-3-5181
Bblid
510427
Inspectionid
360274
Inspect Date
2023-07-19T00:00:00.000
Atdissuedate
2023-07-19T13:21:58.000
Cb
15
House Num
2431
Onstname
E. 28TH ST.
Atddismissed
No
14786
Atdid: 14786 • Atd Number: ATD-3-6138 • Bblid: 499308
Atdid
14786
Atd Number
ATD-3-6138
Bblid
499308
Inspectionid
379741
Inspect Date
2024-07-23T00:00:00.000
Atdissuedate
2024-07-24T13:20:13.000
Cb
15
House Num
2494
Onstname
E. 3RD ST.
Atddismissed
No
10014
Atdid: 10014 • Atd Number: ATD-3-3672 • Bblid: 277564
Atdid
10014
Atd Number
ATD-3-3672
Bblid
277564
Inspectionid
335910
Inspect Date
2022-04-28T00:00:00.000
Atdissuedate
2022-05-02T11:02:26.000
Cb
6
House Num
433
Onstname
4TH ST.
Atddismissed
No
11795
Atdid: 11795 • Atd Number: ATD-3-4794 • Bblid: 286828
Atdid
11795
Atd Number
ATD-3-4794
Bblid
286828
Inspectionid
352900
Inspect Date
2023-03-14T00:00:00.000
Atdissuedate
2023-03-14T12:13:27.000
Cb
8
House Num
433
Onstname
PROSPECT PL.
Atddismissed
No
11001
Atdid: 11001 • Atd Number: ATD-3-4354 • Bblid: 318194
Atdid
11001
Atd Number
ATD-3-4354
Bblid
318194
Inspectionid
344482
Inspect Date
2022-09-17T00:00:00.000
Atdissuedate
2022-09-23T16:53:55.000
Cb
3
House Num
458
Onstname
JEFFERSON AVE.
Atddismissed
No
12127
Atdid: 12127 • Atd Number: ATD-3-4975 • Bblid: 265628
Atdid
12127
Atd Number
ATD-3-4975
Bblid
265628
Inspectionid
356441
Inspect Date
2022-06-03T00:00:00.000
Atdissuedate
2023-05-01T11:54:05.000
Cb
7
House Num
462
Onstname
45TH ST.
Atddismissed
No
9130
Atdid: 9130 • Atd Number: ATD-3-3321 • Bblid: 354880
Atdid
9130
Atd Number
ATD-3-3321
Bblid
354880
Inspectionid
332681
Inspect Date
2021-09-08T00:00:00.000
Atdissuedate
2022-02-23T08:34:11.000
Cb
4
House Num
417
Onstname
STANHOPE ST.
Atddismissed
No
11114
Atdid: 11114 • Atd Number: ATD-4-4839 • Bblid: 858720
Atdid
11114
Atd Number
ATD-4-4839
Bblid
858720
Inspectionid
345333
Inspect Date
2022-09-29T00:00:00.000
Atdissuedate
2022-10-06T14:56:06.000
Cb
10
House Num
149-49
Onstname
114TH PL.
Atddismissed
No
12209
Atdid: 12209 • Atd Number: ATD-2-1058 • Bblid: 242429
Atdid
12209
Atd Number
ATD-2-1058
Bblid
242429
Inspectionid
356862
Inspect Date
2023-05-08T00:00:00.000
Atdissuedate
2023-05-10T13:47:08.000
Cb
10
House Num
676
Onstname
MINNIEFORD AVE.
Atddismissed
No
16382
Atdid: 16382 • Atd Number: ATD-1-328 • Bblid: 113564
Atdid
16382
Atd Number
ATD-1-328
Bblid
113564
Inspectionid
385085
Inspect Date
2024-11-14T00:00:00.000
Atdissuedate
2024-11-15T14:39:34.000
Cb
8
House Num
553
Onstname
E. 86TH ST.
Atddismissed
No
14632
Atdid: 14632 • Atd Number: ATD-3-6068 • Bblid: 407244
Atdid
14632
Atd Number
ATD-3-6068
Bblid
407244
Violationid
291303
Reinspectionid
36453
Inspect Date
2024-06-18T15:56:14.000
Atdissuedate
2024-06-18T15:56:14.000
Cb
9
House Num
197
Onstname
MIDWOOD STREET
Atddismissed
No
14546
Atdid: 14546 • Atd Number: ATD-4-6083 • Bblid: 734283
Atdid
14546
Atd Number
ATD-4-6083
Bblid
734283
Inspectionid
377974
Inspect Date
2024-05-31T00:00:00.000
Atdissuedate
2024-05-31T15:50:30.000
Cb
8
House Num
144-22
Onstname
68TH DR.
Atddismissed
Yes
Atddismissedon
2024-05-31T15:51:09.000
11040
Atdid: 11040 • Atd Number: ATD-3-4390 • Bblid: 318185
Atdid
11040
Atd Number
ATD-3-4390
Bblid
318185
Inspectionid
344674
Inspect Date
2022-09-22T00:00:00.000
Atdissuedate
2022-09-28T12:27:23.000
Cb
3
House Num
444
Onstname
JEFFERSON AVE.
Atddismissed
No
16239
Atdid: 16239 • Atd Number: ATD-1-322 • Bblid: 106036
Atdid
16239
Atd Number
ATD-1-322
Bblid
106036
Inspectionid
384177
Inspect Date
2024-10-08T00:00:00.000
Atdissuedate
2024-10-15T13:39:07.000
Cb
8
House Num
133
Onstname
E. 92ND ST.
Atddismissed
No
8893
Atdid: 8893 • Atd Number: ATD-3-3251 • Bblid: 453326
Atdid
8893
Atd Number
ATD-3-3251
Bblid
453326
Inspectionid
332028
Inspect Date
2022-01-26T00:00:00.000
Atdissuedate
2022-01-26T15:25:38.000
Cb
10
House Num
60
Onstname
94TH ST.
Atddismissed
No
17606
Atdid: 17606 • Atd Number: ATD-4-6878 • Bblid: 647550
Atdid
17606
Atd Number
ATD-4-6878
Bblid
647550
Inspectionid
397076
Inspect Date
2025-04-03T00:00:00.000
Atdissuedate
2025-05-15T09:42:49.000
Cb
5
House Num
61-30
Onstname
76TH ST.
Atddismissed
No
14969
Atdid: 14969 • Atd Number: ATD-4-6248 • Bblid: 636394
Atdid
14969
Atd Number
ATD-4-6248
Bblid
636394
Violationid
294724
Reinspectionid
36752
Inspect Date
2024-08-27T10:32:10.000
Atdissuedate
2024-08-27T10:32:10.000
Cb
4
House Num
79-33
Onstname
ELKS ROAD
Atddismissed
No
8661
Atdid: 8661 • Atd Number: ATD-4-3888 • Bblid: 864872
Atdid
8661
Atd Number
ATD-4-3888
Bblid
864872
Inspectionid
330808
Inspect Date
2021-04-28T00:00:00.000
Atdissuedate
2021-12-16T10:12:57.000
Cb
12
House Num
126-38
Onstname
145TH ST.
Atddismissed
No
9611
Atdid: 9611 • Atd Number: ATD-3-3571 • Bblid: 435557
Atdid
9611
Atd Number
ATD-3-3571
Bblid
435557
Inspectionid
333751
Inspect Date
2021-07-16T00:00:00.000
Atdissuedate
2022-03-15T09:16:09.000
Cb
12
House Num
1349
Onstname
55TH ST.
Atddismissed
No
11421
Atdid: 11421 • Atd Number: ATD-1-253 • Bblid: 119390
Atdid
11421
Atd Number
ATD-1-253
Bblid
119390
Inspectionid
348391
Inspect Date
2022-11-03T00:00:00.000
Atdissuedate
2022-11-18T13:46:06.000
Cb
11
House Num
324
Onstname
E. 120TH ST.
Atddismissed
Yes
Atddismissedon
2023-02-24T11:38:55.000
9440
Atdid: 9440 • Atd Number: ATD-3-3503 • Bblid: 551362
Atdid
9440
Atd Number
ATD-3-3503
Bblid
551362
Inspectionid
333274
Inspect Date
2020-12-08T00:00:00.000
Atdissuedate
2022-03-04T16:57:12.000
Cb
18
House Num
1778
Onstname
E. 53RD ST.
Atddismissed
No
18187
Atdid: 18187 • Atd Number: ATD-4-7185 • Bblid: 828683
Atdid
18187
Atd Number
ATD-4-7185
Bblid
828683
Inspectionid
403101
Inspect Date
2025-07-23T00:00:00.000
Atdissuedate
2025-07-24T10:20:20.000
Cb
13
House Num
88-39
Onstname
212TH ST.
Atddismissed
No
9769
Atdid: 9769 • Atd Number: ATD-4-4422 • Bblid: 769074
Atdid
9769
Atd Number
ATD-4-4422
Bblid
769074
Inspectionid
334362
Inspect Date
2019-09-26T00:00:00.000
Atdissuedate
2022-03-29T18:03:28.000
Cb
13
House Num
77-22
Onstname
LITTLE NECK PKWY.
Atddismissed
No
6708
Atdid: 6708 • Atd Number: ATD-4-3069 • Bblid: 869742
Atdid
6708
Atd Number
ATD-4-3069
Bblid
869742
Violationid
252529
Atdissuedate
2020-06-18T00:00:00.000
Cb
12
House Num
133-03
Onstname
160 STREET
Atddismissed
Yes
Atddismissedon
2024-02-26T11:23:05.000
10341
Atdid: 10341 • Atd Number: ATD-4-4690 • Bblid: 785550
Atdid
10341
Atd Number
ATD-4-4690
Bblid
785550
Inspectionid
338335
Inspect Date
2022-06-30T00:00:00.000
Atdissuedate
2022-06-30T09:42:09.000
Cb
10
House Num
103-28
Onstname
92ND ST.
Atddismissed
No
16390
Atdid: 16390 • Atd Number: ATD-3-6421 • Bblid: 287883
Atdid
16390
Atd Number
ATD-3-6421
Bblid
287883
Inspectionid
385095
Inspect Date
2021-09-15T00:00:00.000
Atdissuedate
2024-11-16T11:56:11.000
Cb
8
House Num
394
Onstname
STERLING PL.
Atddismissed
No
16673
Atdid: 16673 • Atd Number: ATD-4-6558 • Bblid: 735834
Atdid
16673
Atd Number
ATD-4-6558
Bblid
735834
Inspectionid
388590
Inspect Date
2024-10-25T00:00:00.000
Atdissuedate
2025-01-08T15:56:05.000
Cb
8
House Num
75-28
Onstname
VLEIGH PL.
Atddismissed
No
9417
Atdid: 9417 • Atd Number: ATD-4-4218 • Bblid: 683599
Atdid
9417
Atd Number
ATD-4-4218
Bblid
683599
Inspectionid
333195
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-03-04T10:39:14.000
Cb
7
House Num
15-44
Onstname
PARSONS BLVD.
Atddismissed
No
9667
Atdid: 9667 • Atd Number: ATD-5-641 • Bblid: 993734
Atdid
9667
Atd Number
ATD-5-641
Bblid
993734
Inspectionid
333864
Inspect Date
2019-09-27T00:00:00.000
Atdissuedate
2022-03-16T17:51:33.000
Cb
2
House Num
237
Onstname
NAUGHTON AVE.
Atddismissed
Yes
Atddismissedon
2024-08-01T12:06:37.000
4702
Atdid: 4702 • Atd Number: ATD-4-1233 • Bblid: 768451
Atdid
4702
Atd Number
ATD-4-1233
Bblid
768451
Violationid
205386
Atdissuedate
2020-04-16T00:00:00.000
Cb
11
House Num
259-15
Onstname
57 AVENUE
Atddismissed
No
16531
Atdid: 16531 • Atd Number: ATD-3-6469 • Bblid: 292023
Atdid
16531
Atd Number
ATD-3-6469
Bblid
292023
Inspectionid
386443
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2024-12-18T07:46:43.000
Cb
8
House Num
443
Onstname
EASTERN PKWY.
Atddismissed
No
16150
Atdid: 16150 • Atd Number: ATD-3-6318 • Bblid: 427048
Atdid
16150
Atd Number
ATD-3-6318
Bblid
427048
Inspectionid
383530
Inspect Date
2024-09-24T00:00:00.000
Atdissuedate
2024-09-30T12:27:32.000
Cb
11
House Num
1709
Onstname
62ND ST.
Atddismissed
No
NYC Data AI • Public-data exploration interface