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
9367
Atdid: 9367 • Atd Number: ATD-3-3464 • Bblid: 257516
Atdid
9367
Atd Number
ATD-3-3464
Bblid
257516
Inspectionid
333091
Inspect Date
2021-01-05T00:00:00.000
Atdissuedate
2022-03-03T08:18:18.000
Cb
6
House Num
521
Onstname
CLINTON ST.
Atddismissed
No
18570
Atdid: 18570 • Atd Number: ATD-3-7314 • Bblid: 543487
Atdid
18570
Atd Number
ATD-3-7314
Bblid
543487
Inspectionid
405618
Inspect Date
2025-03-17T00:00:00.000
Atdissuedate
2025-09-10T12:45:07.000
Cb
18
House Num
1559
Onstname
REMSEN AVE.
Atddismissed
No
12047
Atdid: 12047 • Atd Number: ATD-4-5128 • Bblid: 744755
Atdid
12047
Atd Number
ATD-4-5128
Bblid
744755
Inspectionid
355967
Inspect Date
2023-04-04T00:00:00.000
Atdissuedate
2023-04-17T13:24:17.000
Cb
8
House Num
76-15
Onstname
167TH ST.
Atddismissed
No
9523
Atdid: 9523 • Atd Number: ATD-5-622 • Bblid: 1009954
Atdid
9523
Atd Number
ATD-5-622
Bblid
1009954
Inspectionid
333549
Inspect Date
2019-08-06T00:00:00.000
Atdissuedate
2022-03-09T17:53:11.000
Cb
3
House Num
182
Onstname
LEVERETT AVE.
Atddismissed
No
10263
Atdid: 10263 • Atd Number: ATD-3-3829 • Bblid: 323657
Atdid
10263
Atd Number
ATD-3-3829
Bblid
323657
Inspectionid
337522
Inspect Date
2022-06-08T00:00:00.000
Atdissuedate
2022-06-10T09:23:54.000
Cb
2
House Num
275
Onstname
GREENE AVE.
Atddismissed
No
17187
Atdid: 17187 • Atd Number: ATD-4-6700 • Bblid: 628941
Atdid
17187
Atd Number
ATD-4-6700
Bblid
628941
Inspectionid
392779
Inspect Date
2023-05-16T00:00:00.000
Atdissuedate
2025-03-31T13:24:43.000
Cb
6
House Num
108-52
Onstname
63RD RD.
Atddismissed
No
9288
Atdid: 9288 • Atd Number: ATD-2-889 • Bblid: 207286
Atdid
9288
Atd Number
ATD-2-889
Bblid
207286
Inspectionid
332994
Inspect Date
2019-05-01T00:00:00.000
Atdissuedate
2022-03-02T08:25:20.000
Cb
11
House Num
1582
Onstname
ALLERTON AVE.
Atddismissed
No
8640
Atdid: 8640 • Atd Number: ATD-4-3881 • Bblid: 772418
Atdid
8640
Atd Number
ATD-4-3881
Bblid
772418
Inspectionid
330778
Inspect Date
2021-11-03T00:00:00.000
Atdissuedate
2021-12-15T14:06:18.000
Cb
13
House Num
77-51
Onstname
269TH ST.
Atddismissed
No
14299
Atdid: 14299 • Atd Number: ATD-4-5964 • Bblid: 742747
Atdid
14299
Atd Number
ATD-4-5964
Bblid
742747
Inspectionid
375549
Inspect Date
2024-03-13T00:00:00.000
Atdissuedate
2024-04-17T12:18:09.000
Cb
8
House Num
65-48
Onstname
169TH ST.
Atddismissed
No
13616
Atdid: 13616 • Atd Number: ATD-4-5615 • Bblid: 897049
Atdid
13616
Atd Number
ATD-4-5615
Bblid
897049
Inspectionid
365702
Inspect Date
2023-10-05T00:00:00.000
Atdissuedate
2023-10-23T13:55:12.000
Cb
13
House Num
255-47
Onstname
148TH DR.
Atddismissed
No
8581
Atdid: 8581 • Atd Number: ATD-4-3853 • Bblid: 828921
Atdid
8581
Atd Number
ATD-4-3853
Bblid
828921
Inspectionid
330521
Inspect Date
2019-06-26T00:00:00.000
Atdissuedate
2021-12-10T10:11:04.000
Cb
13
House Num
214-34
Onstname
WHITEHALL TER.
Atddismissed
No
17312
Atdid: 17312 • Atd Number: ATD-3-6850 • Bblid: 301851
Atdid
17312
Atd Number
ATD-3-6850
Bblid
301851
Inspectionid
394396
Inspect Date
2025-03-28T00:00:00.000
Atdissuedate
2025-04-14T07:44:08.000
Cb
3
House Num
606
Onstname
MACDONOUGH ST.
Atddismissed
No
18548
Atdid: 18548 • Atd Number: ATD-4-7354 • Bblid: 878952
Atdid
18548
Atd Number
ATD-4-7354
Bblid
878952
Inspectionid
405527
Inspect Date
2025-04-29T00:00:00.000
Atdissuedate
2025-09-08T14:36:50.000
Cb
12
House Num
190-12
Onstname
WILLIAMSON AVE.
Atddismissed
No
16419
Atdid: 16419 • Atd Number: ATD-4-6447 • Bblid: 638233
Atdid
16419
Atd Number
ATD-4-6447
Bblid
638233
Inspectionid
385273
Inspect Date
2024-11-08T00:00:00.000
Atdissuedate
2024-11-20T13:17:36.000
Cb
5
House Num
60-80
Onstname
60TH ST.
Atddismissed
No
14359
Atdid: 14359 • Atd Number: ATD-3-5916 • Bblid: 474888
Atdid
14359
Atd Number
ATD-3-5916
Bblid
474888
Inspectionid
376199
Inspect Date
2024-04-25T00:00:00.000
Atdissuedate
2024-04-29T10:01:15.000
Cb
11
House Num
1524
Onstname
W. 2ND ST.
Atddismissed
No
12106
Atdid: 12106 • Atd Number: ATD-3-4961 • Bblid: 257145
Atdid
12106
Atd Number
ATD-3-4961
Bblid
257145
Violationid
287422
Reinspectionid
35869
Inspect Date
2023-04-26T15:52:57.000
Atdissuedate
2023-04-26T15:52:57.000
Cb
6
House Num
580
Onstname
HENRY STREET
Atddismissed
Yes
Atddismissedon
2023-04-27T15:38:22.000
14939
Atdid: 14939 • Atd Number: ATD-3-6216 • Bblid: 317960
Atdid
14939
Atd Number
ATD-3-6216
Bblid
317960
Inspectionid
380857
Inspect Date
2024-08-13T00:00:00.000
Atdissuedate
2024-08-19T15:34:39.000
Cb
3
House Num
224
Onstname
JEFFERSON AVE.
Atddismissed
No
14507
Atdid: 14507 • Atd Number: ATD-4-6065 • Bblid: 776368
Atdid
14507
Atd Number
ATD-4-6065
Bblid
776368
Inspectionid
377593
Inspect Date
2024-05-20T00:00:00.000
Atdissuedate
2024-05-20T14:45:30.000
Cb
9
House Num
86-20
Onstname
79TH ST.
Atddismissed
No
16300
Atdid: 16300 • Atd Number: ATD-3-6377 • Bblid: 279000
Atdid
16300
Atd Number
ATD-3-6377
Bblid
279000
Inspectionid
384481
Inspect Date
2024-09-27T00:00:00.000
Atdissuedate
2024-10-28T10:59:00.000
Cb
6
House Num
395
Onstname
11TH ST.
Atddismissed
No
16325
Atdid: 16325 • Atd Number: ATD-1-324 • Bblid: 105929
Atdid
16325
Atd Number
ATD-1-324
Bblid
105929
Inspectionid
384644
Inspect Date
2024-10-28T00:00:00.000
Atdissuedate
2024-11-01T07:50:29.000
Cb
8
House Num
136
Onstname
E. 95TH ST.
Atddismissed
No
13195
Atdid: 13195 • Atd Number: ATD-3-5374 • Bblid: 422874
Atdid
13195
Atd Number
ATD-3-5374
Bblid
422874
Inspectionid
361834
Inspect Date
2023-08-10T00:00:00.000
Atdissuedate
2023-08-10T10:47:01.000
Cb
12
House Num
1679
Onstname
46 STREET
Atddismissed
No
11830
Atdid: 11830 • Atd Number: ATD-4-5061 • Bblid: 629725
Atdid
11830
Atd Number
ATD-4-5061
Bblid
629725
Inspectionid
353394
Inspect Date
2023-03-20T00:00:00.000
Atdissuedate
2023-03-20T14:11:39.000
Cb
6
House Num
110-12
Onstname
70TH RD.
Atddismissed
No
4603
Atdid: 4603 • Atd Number: ATD-4-1134 • Bblid: 784215
Atdid
4603
Atd Number
ATD-4-1134
Bblid
784215
Violationid
184101
Atdissuedate
2020-08-21T00:00:00.000
Cb
9
House Num
97-41
Onstname
84 STREET
Atddismissed
Yes
Atddismissedon
2025-07-31T18:45:15.000
8994
Atdid: 8994 • Atd Number: ATD-4-4085 • Bblid: 670828
Atdid
8994
Atd Number
ATD-4-4085
Bblid
670828
Inspectionid
332316
Inspect Date
2022-02-08T00:00:00.000
Atdissuedate
2022-02-08T13:03:21.000
Cb
5
House Num
68-29
Onstname
64TH PL.
Atddismissed
No
12580
Atdid: 12580 • Atd Number: ATD-2-1157 • Bblid: 149022
Atdid
12580
Atd Number
ATD-2-1157
Bblid
149022
Inspectionid
358581
Inspect Date
2023-06-15T00:00:00.000
Atdissuedate
2023-06-15T10:01:24.000
Cb
2
House Num
895
Onstname
REV JAMES POLITE AVE
Atddismissed
No
12619
Atdid: 12619 • Atd Number: ATD-5-702 • Bblid: 926540
Atdid
12619
Atd Number
ATD-5-702
Bblid
926540
Inspectionid
358802
Inspect Date
2023-06-21T00:00:00.000
Atdissuedate
2023-06-21T10:32:38.000
Cb
1
House Num
120
Onstname
DELAFIELD AVE.
Atddismissed
No
9952
Atdid: 9952 • Atd Number: ATD-4-4531 • Bblid: 654461
Atdid
9952
Atd Number
ATD-4-4531
Bblid
654461
Inspectionid
335369
Inspect Date
2022-04-12T00:00:00.000
Atdissuedate
2022-04-21T12:40:52.000
Cb
6
House Num
65-24
Onstname
CROMWELL CRES
Atddismissed
No
18415
Atdid: 18415 • Atd Number: ATD-3-7264 • Bblid: 478089
Atdid
18415
Atd Number
ATD-3-7264
Bblid
478089
Inspectionid
404712
Inspect Date
2025-08-22T00:00:00.000
Atdissuedate
2025-08-25T10:32:06.000
Cb
15
House Num
1810
Onstname
E. 5TH ST.
Atddismissed
No
10414
Atdid: 10414 • Atd Number: ATD-4-4715 • Bblid: 724347
Atdid
10414
Atd Number
ATD-4-4715
Bblid
724347
Inspectionid
339083
Inspect Date
2022-06-29T00:00:00.000
Atdissuedate
2022-07-11T11:20:44.000
Cb
11
House Num
28-31
Onstname
JORDAN ST.
Atddismissed
No
17710
Atdid: 17710 • Atd Number: ATD-2-1404 • Bblid: 241994
Atdid
17710
Atd Number
ATD-2-1404
Bblid
241994
Inspectionid
398190
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-05-22T11:10:37.000
Cb
10
House Num
275
Onstname
FORDHAM PL.
Atddismissed
No
17056
Atdid: 17056 • Atd Number: ATD-3-6715 • Bblid: 273100
Atdid
17056
Atd Number
ATD-3-6715
Bblid
273100
Inspectionid
392386
Inspect Date
2022-06-03T00:00:00.000
Atdissuedate
2025-03-27T10:28:37.000
Cb
7
House Num
625
Onstname
40TH ST.
Atddismissed
No
12489
Atdid: 12489 • Atd Number: ATD-4-5315 • Bblid: 781590
Atdid
12489
Atd Number
ATD-4-5315
Bblid
781590
Inspectionid
358033
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T16:01:32.000
Cb
9
House Num
91-50
Onstname
87TH ST.
Atddismissed
No
10743
Atdid: 10743 • Atd Number: ATD-3-4121 • Bblid: 310069
Atdid
10743
Atd Number
ATD-3-4121
Bblid
310069
Inspectionid
342712
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-09-06T13:47:19.000
Cb
3
House Num
505
Onstname
MACON ST.
Atddismissed
No
18599
Atdid: 18599 • Atd Number: ATD-4-7371 • Bblid: 744433
Atdid
18599
Atd Number
ATD-4-7371
Bblid
744433
Inspectionid
405847
Inspect Date
2025-09-11T00:00:00.000
Atdissuedate
2025-09-15T12:07:43.000
Cb
8
House Num
73-44
Onstname
172ND ST.
Atddismissed
No
15113
Atdid: 15113 • Atd Number: ATD-4-6312 • Bblid: 759649
Atdid
15113
Atd Number
ATD-4-6312
Bblid
759649
Inspectionid
382222
Inspect Date
2024-08-23T00:00:00.000
Atdissuedate
2024-09-23T15:29:11.000
Cb
13
House Num
81-32
Onstname
242ND ST.
Atddismissed
No
15114
Atdid: 15114 • Atd Number: ATD-4-6313 • Bblid: 759653
Atdid
15114
Atd Number
ATD-4-6313
Bblid
759653
Inspectionid
382224
Inspect Date
2024-08-23T00:00:00.000
Atdissuedate
2024-09-23T15:37:11.000
Cb
13
House Num
81-24
Onstname
242ND ST.
Atddismissed
No
12196
Atdid: 12196 • Atd Number: ATD-2-1048 • Bblid: 166824
Atdid
12196
Atd Number
ATD-2-1048
Bblid
166824
Inspectionid
356838
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2023-05-09T14:43:11.000
Cb
7
House Num
2760
Onstname
GRAND CONCOURSE
Atddismissed
No
14513
Atdid: 14513 • Atd Number: ATD-4-6071 • Bblid: 852517
Atdid
14513
Atd Number
ATD-4-6071
Bblid
852517
Inspectionid
377683
Inspect Date
2024-05-09T00:00:00.000
Atdissuedate
2024-05-21T11:36:30.000
Cb
10
House Num
111-29
Onstname
132ND ST.
Atddismissed
No
8597
Atdid: 8597 • Atd Number: ATD-4-3857 • Bblid: 774720
Atdid
8597
Atd Number
ATD-4-3857
Bblid
774720
Inspectionid
330618
Inspect Date
2021-12-02T00:00:00.000
Atdissuedate
2021-12-13T09:42:12.000
Cb
13
House Num
83-27
Onstname
265TH ST.
Atddismissed
No
16877
Atdid: 16877 • Atd Number: ATD-5-921 • Bblid: 953683
Atdid
16877
Atd Number
ATD-5-921
Bblid
953683
Inspectionid
390496
Inspect Date
2025-03-05T00:00:00.000
Atdissuedate
2025-03-06T16:58:13.000
Cb
1
House Num
56
Onstname
DECKER AVE.
Atddismissed
No
12453
Atdid: 12453 • Atd Number: ATD-4-5286 • Bblid: 829903
Atdid
12453
Atd Number
ATD-4-5286
Bblid
829903
Inspectionid
357918
Inspect Date
2023-05-24T00:00:00.000
Atdissuedate
2023-05-31T14:18:41.000
Cb
13
House Num
94-25
Onstname
SPRINGFIELD BLVD.
Atddismissed
No
14506
Atdid: 14506 • Atd Number: ATD-4-6064 • Bblid: 776370
Atdid
14506
Atd Number
ATD-4-6064
Bblid
776370
Inspectionid
377592
Inspect Date
2024-05-20T00:00:00.000
Atdissuedate
2024-05-20T14:45:15.000
Cb
9
House Num
86-22
Onstname
79TH ST.
Atddismissed
No
17620
Atdid: 17620 • Atd Number: ATD-4-6891 • Bblid: 640425
Atdid
17620
Atd Number
ATD-4-6891
Bblid
640425
Inspectionid
397129
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-15T14:56:04.000
Cb
5
House Num
60-91
Onstname
60TH DR.
Atddismissed
No
9116
Atdid: 9116 • Atd Number: ATD-4-4165 • Bblid: 663446
Atdid
9116
Atd Number
ATD-4-4165
Bblid
663446
Inspectionid
332667
Inspect Date
2019-07-02T00:00:00.000
Atdissuedate
2022-02-22T15:20:17.000
Cb
5
House Num
1863
Onstname
HART ST.
Atddismissed
No
2606
Atdid: 2606 • Atd Number: ATD-3-1749 • Bblid: 259938
Atdid
2606
Atd Number
ATD-3-1749
Bblid
259938
Violationid
242986
Atdissuedate
2020-02-07T00:00:00.000
Cb
6
House Num
454
Onstname
SACKETT STREET
Atddismissed
Yes
Atddismissedon
2024-12-26T13:39:15.000
13968
Atdid: 13968 • Atd Number: ATD-3-5741 • Bblid: 470104
Atdid
13968
Atd Number
ATD-3-5741
Bblid
470104
Inspectionid
371718
Inspect Date
2024-02-08T00:00:00.000
Atdissuedate
2024-02-15T12:43:49.000
Cb
14
House Num
328
Onstname
FOSTER AVE.
Atddismissed
No
16141
Atdid: 16141 • Atd Number: ATD-3-6309 • Bblid: 448937
Atdid
16141
Atd Number
ATD-3-6309
Bblid
448937
Inspectionid
383448
Inspect Date
2024-09-27T00:00:00.000
Atdissuedate
2024-09-30T11:10:44.000
Cb
10
House Num
538
Onstname
80TH ST.
Atddismissed
No
18537
Atdid: 18537 • Atd Number: ATD-3-7303 • Bblid: 377729
Atdid
18537
Atd Number
ATD-3-7303
Bblid
377729
Inspectionid
405486
Inspect Date
2025-09-05T00:00:00.000
Atdissuedate
2025-09-08T11:41:59.000
Cb
5
House Num
529
Onstname
SCHENCK AVE.
Atddismissed
No
8986
Atdid: 8986 • Atd Number: ATD-4-4077 • Bblid: 677676
Atdid
8986
Atd Number
ATD-4-4077
Bblid
677676
Inspectionid
332299
Inspect Date
2020-12-04T00:00:00.000
Atdissuedate
2022-02-08T08:39:37.000
Cb
5
House Num
88-32
Onstname
75TH AVE.
Atddismissed
No
10961
Atdid: 10961 • Atd Number: ATD-3-4319 • Bblid: 279278
Atdid
10961
Atd Number
ATD-3-4319
Bblid
279278
Inspectionid
344273
Inspect Date
2022-09-20T00:00:00.000
Atdissuedate
2022-09-22T09:06:50.000
Cb
6
House Num
130
Onstname
11TH ST.
Atddismissed
No
NYC Data AI • Public-data exploration interface