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
18411
Atdid: 18411 • Atd Number: ATD-3-7260 • Bblid: 314237
Atdid
18411
Atd Number
ATD-3-7260
Bblid
314237
Inspectionid
404685
Inspect Date
2025-02-27T00:00:00.000
Atdissuedate
2025-08-22T12:30:09.000
Cb
3
House Num
64
Onstname
HART ST.
Atddismissed
No
14456
Atdid: 14456 • Atd Number: ATD-3-5978 • Bblid: 453153
Atdid
14456
Atd Number
ATD-3-5978
Bblid
453153
Inspectionid
377259
Inspect Date
2024-05-08T00:00:00.000
Atdissuedate
2024-05-13T11:08:30.000
Cb
10
House Num
249
Onstname
93RD ST.
Atddismissed
No
9764
Atdid: 9764 • Atd Number: ATD-4-4419 • Bblid: 737827
Atdid
9764
Atd Number
ATD-4-4419
Bblid
737827
Inspectionid
334357
Inspect Date
2019-08-16T00:00:00.000
Atdissuedate
2022-03-29T17:59:21.000
Cb
8
House Num
150-45
Onstname
78TH RD.
Atddismissed
No
10774
Atdid: 10774 • Atd Number: ATD-2-947 • Bblid: 225514
Atdid
10774
Atd Number
ATD-2-947
Bblid
225514
Inspectionid
342832
Inspect Date
2022-09-07T00:00:00.000
Atdissuedate
2022-09-07T12:49:48.000
Cb
12
House Num
4131
Onstname
GRACE AVE.
Atddismissed
No
14187
Atdid: 14187 • Atd Number: ATD-3-5847 • Bblid: 532382
Atdid
14187
Atd Number
ATD-3-5847
Bblid
532382
Inspectionid
373803
Inspect Date
2024-03-20T00:00:00.000
Atdissuedate
2024-03-20T14:44:37.000
Cb
18
House Num
605
Onstname
E. 83RD ST.
Atddismissed
No
10356
Atdid: 10356 • Atd Number: ATD-3-3869 • Bblid: 421497
Atdid
10356
Atd Number
ATD-3-3869
Bblid
421497
Inspectionid
338484
Inspect Date
2022-06-23T00:00:00.000
Atdissuedate
2022-07-05T10:19:24.000
Cb
12
House Num
1724
Onstname
44TH ST.
Atddismissed
No
10562
Atdid: 10562 • Atd Number: ATD-3-4004 • Bblid: 531161
Atdid
10562
Atd Number
ATD-3-4004
Bblid
531161
Inspectionid
340472
Inspect Date
2022-07-26T00:00:00.000
Atdissuedate
2022-07-26T12:36:12.000
Cb
18
House Num
574
Onstname
E. 81ST ST.
Atddismissed
No
18177
Atdid: 18177 • Atd Number: ATD-4-7179 • Bblid: 625638
Atdid
18177
Atd Number
ATD-4-7179
Bblid
625638
Inspectionid
402992
Inspect Date
2025-06-09T00:00:00.000
Atdissuedate
2025-07-23T13:29:36.000
Cb
4
House Num
108-69
Onstname
43RD AVE.
Atddismissed
No
17310
Atdid: 17310 • Atd Number: ATD-3-6848 • Bblid: 301869
Atdid
17310
Atd Number
ATD-3-6848
Bblid
301869
Inspectionid
394387
Inspect Date
2025-03-28T00:00:00.000
Atdissuedate
2025-04-14T07:39:31.000
Cb
3
House Num
620
Onstname
MACDONOUGH ST.
Atddismissed
No
17477
Atdid: 17477 • Atd Number: ATD-4-6825 • Bblid: 819685
Atdid
17477
Atd Number
ATD-4-6825
Bblid
819685
Inspectionid
395513
Inspect Date
2025-04-25T00:00:00.000
Atdissuedate
2025-04-28T12:51:26.000
Cb
12
House Num
105-03
Onstname
177 STREET
Atddismissed
No
10824
Atdid: 10824 • Atd Number: ATD-3-4195 • Bblid: 309139
Atdid
10824
Atd Number
ATD-3-4195
Bblid
309139
Inspectionid
343320
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-09-12T09:51:10.000
Cb
3
House Num
539A
Onstname
HANCOCK ST.
Atddismissed
No
12583
Atdid: 12583 • Atd Number: ATD-2-1160 • Bblid: 142102
Atdid
12583
Atd Number
ATD-2-1160
Bblid
142102
Inspectionid
358584
Inspect Date
2023-06-15T00:00:00.000
Atdissuedate
2023-06-15T10:04:51.000
Cb
3
House Num
975
Onstname
WASHINGTON AVE.
Atddismissed
No
9923
Atdid: 9923 • Atd Number: ATD-3-3636 • Bblid: 259540
Atdid
9923
Atd Number
ATD-3-3636
Bblid
259540
Inspectionid
335291
Inspect Date
2022-04-20T00:00:00.000
Atdissuedate
2022-04-20T15:17:22.000
Cb
6
House Num
464
Onstname
DEGRAW ST.
Atddismissed
No
10817
Atdid: 10817 • Atd Number: ATD-3-4188 • Bblid: 344153
Atdid
10817
Atd Number
ATD-3-4188
Bblid
344153
Inspectionid
343192
Inspect Date
2022-08-11T00:00:00.000
Atdissuedate
2022-09-09T15:50:00.000
Cb
1
House Num
52
Onstname
SUTTON ST.
Atddismissed
No
12141
Atdid: 12141 • Atd Number: ATD-3-4979 • Bblid: 523321
Atdid
12141
Atd Number
ATD-3-4979
Bblid
523321
Inspectionid
356635
Inspect Date
2023-04-14T00:00:00.000
Atdissuedate
2023-05-03T14:14:00.000
Cb
18
House Num
1323
Onstname
E. 46TH ST.
Atddismissed
No
16663
Atdid: 16663 • Atd Number: ATD-3-6531 • Bblid: 515882
Atdid
16663
Atd Number
ATD-3-6531
Bblid
515882
Inspectionid
388552
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2025-01-08T10:23:16.000
Cb
18
House Num
1172
Onstname
E. 38TH ST.
Atddismissed
No
11521
Atdid: 11521 • Atd Number: ATD-4-4914 • Bblid: 666667
Atdid
11521
Atd Number
ATD-4-4914
Bblid
666667
Inspectionid
349423
Inspect Date
2022-12-14T00:00:00.000
Atdissuedate
2022-12-16T12:54:11.000
Cb
5
House Num
60-23
Onstname
69TH AVE.
Atddismissed
No
14758
Atdid: 14758 • Atd Number: ATD-2-1294 • Bblid: 178967
Atdid
14758
Atd Number
ATD-2-1294
Bblid
178967
Violationid
286466
Reinspectionid
36932
Inspect Date
2024-07-17T13:23:21.000
Atdissuedate
2024-07-17T13:23:21.000
Cb
9
House Num
2213
Onstname
CHATTERTON AVENUE
Atddismissed
No
18378
Atdid: 18378 • Atd Number: ATD-4-7270 • Bblid: 887071
Atdid
18378
Atd Number
ATD-4-7270
Bblid
887071
Inspectionid
404528
Inspect Date
2025-08-05T00:00:00.000
Atdissuedate
2025-08-20T11:08:31.000
Cb
13
House Num
136-05
Onstname
222ND ST.
Atddismissed
No
16182
Atdid: 16182 • Atd Number: ATD-4-6351 • Bblid: 579411
Atdid
16182
Atd Number
ATD-4-6351
Bblid
579411
Inspectionid
383708
Inspect Date
2024-08-29T00:00:00.000
Atdissuedate
2024-10-03T12:25:28.000
Cb
1
House Num
25-07
Onstname
35TH ST.
Atddismissed
No
18234
Atdid: 18234 • Atd Number: ATD-3-7197 • Bblid: 550961
Atdid
18234
Atd Number
ATD-3-7197
Bblid
550961
Inspectionid
403522
Inspect Date
2025-07-30T00:00:00.000
Atdissuedate
2025-08-04T10:30:12.000
Cb
18
House Num
1859
Onstname
E. 33RD ST.
Atddismissed
No
14931
Atdid: 14931 • Atd Number: ATD-3-6211 • Bblid: 369380
Atdid
14931
Atd Number
ATD-3-6211
Bblid
369380
Inspectionid
380786
Inspect Date
2024-08-13T00:00:00.000
Atdissuedate
2024-08-19T11:53:45.000
Cb
5
House Num
391
Onstname
BRADFORD ST.
Atddismissed
No
8718
Atdid: 8718 • Atd Number: ATD-3-3198 • Bblid: 258855
Atdid
8718
Atd Number
ATD-3-3198
Bblid
258855
Inspectionid
331038
Inspect Date
2021-12-14T00:00:00.000
Atdissuedate
2021-12-27T14:00:45.000
Cb
6
House Num
121
Onstname
BUTLER ST.
Atddismissed
No
12056
Atdid: 12056 • Atd Number: ATD-4-5135 • Bblid: 745284
Atdid
12056
Atd Number
ATD-4-5135
Bblid
745284
Inspectionid
355980
Inspect Date
2023-04-05T00:00:00.000
Atdissuedate
2023-04-17T13:46:35.000
Cb
8
House Num
76-37
Onstname
167TH ST.
Atddismissed
No
13505
Atdid: 13505 • Atd Number: ATD-4-5557 • Bblid: 610362
Atdid
13505
Atd Number
ATD-4-5557
Bblid
610362
Inspectionid
364575
Inspect Date
2023-09-27T00:00:00.000
Atdissuedate
2023-09-28T12:38:41.000
Cb
4
House Num
41-30
Onstname
JUDGE ST.
Atddismissed
No
17500
Atdid: 17500 • Atd Number: ATD-2-1389 • Bblid: 207642
Atdid
17500
Atd Number
ATD-2-1389
Bblid
207642
Inspectionid
395918
Inspect Date
2025-05-02T00:00:00.000
Atdissuedate
2025-05-02T16:22:45.000
Cb
11
House Num
2405
Onstname
DELANOY AVE.
Atddismissed
No
18430
Atdid: 18430 • Atd Number: ATD-3-7267 • Bblid: 307417
Atdid
18430
Atd Number
ATD-3-7267
Bblid
307417
Inspectionid
404887
Inspect Date
2025-08-14T00:00:00.000
Atdissuedate
2025-08-27T10:39:32.000
Cb
3
House Num
855
Onstname
GREENE AVE.
Atddismissed
No
10410
Atdid: 10410 • Atd Number: ATD-3-3904 • Bblid: 309026
Atdid
10410
Atd Number
ATD-3-3904
Bblid
309026
Inspectionid
338977
Inspect Date
2022-07-09T00:00:00.000
Atdissuedate
2022-07-09T15:00:15.000
Cb
3
House Num
682
Onstname
PUTNAM AVE.
Atddismissed
No
16460
Atdid: 16460 • Atd Number: ATD-4-6473 • Bblid: 828037
Atdid
16460
Atd Number
ATD-4-6473
Bblid
828037
Inspectionid
385573
Inspect Date
2024-07-15T00:00:00.000
Atdissuedate
2024-12-02T12:23:49.000
Cb
13
House Num
89-59
Onstname
215TH ST.
Atddismissed
No
9783
Atdid: 9783 • Atd Number: ATD-4-4430 • Bblid: 663743
Atdid
9783
Atd Number
ATD-4-4430
Bblid
663743
Inspectionid
334376
Inspect Date
2019-06-27T00:00:00.000
Atdissuedate
2022-03-29T18:22:57.000
Cb
5
House Num
404
Onstname
WOODWARD AVE.
Atddismissed
No
12960
Atdid: 12960 • Atd Number: ATD-3-5234 • Bblid: 287377
Atdid
12960
Atd Number
ATD-3-5234
Bblid
287377
Inspectionid
360555
Inspect Date
2023-07-11T00:00:00.000
Atdissuedate
2023-07-24T11:18:44.000
Cb
8
House Num
199
Onstname
STERLING PL.
Atddismissed
No
16782
Atdid: 16782 • Atd Number: ATD-3-6581 • Bblid: 554346
Atdid
16782
Atd Number
ATD-3-6581
Bblid
554346
Inspectionid
389363
Inspect Date
2025-01-14T00:00:00.000
Atdissuedate
2025-02-05T11:16:01.000
Cb
18
House Num
2233
Onstname
RYDER ST.
Atddismissed
No
13015
Atdid: 13015 • Atd Number: ATD-4-5477 • Bblid: 897526
Atdid
13015
Atd Number
ATD-4-5477
Bblid
897526
Inspectionid
360978
Inspect Date
2023-07-26T00:00:00.000
Atdissuedate
2023-07-28T09:56:41.000
Cb
13
House Num
259-37
Onstname
148TH RD.
Atddismissed
Yes
Atddismissedon
2024-03-14T11:24:36.000
17947
Atdid: 17947 • Atd Number: ATD-3-7064 • Bblid: 285100
Atdid
17947
Atd Number
ATD-3-7064
Bblid
285100
Inspectionid
400734
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-23T10:03:53.000
Cb
7
House Num
4
Onstname
FULLER PL.
Atddismissed
No
17718
Atdid: 17718 • Atd Number: ATD-4-6966 • Bblid: 650818
Atdid
17718
Atd Number
ATD-4-6966
Bblid
650818
Inspectionid
398303
Inspect Date
2025-05-21T00:00:00.000
Atdissuedate
2025-05-23T11:41:22.000
Cb
5
House Num
64-09
Onstname
70TH ST.
Atddismissed
No
14819
Atdid: 14819 • Atd Number: ATD-3-6156 • Bblid: 312085
Atdid
14819
Atd Number
ATD-3-6156
Bblid
312085
Inspectionid
379925
Inspect Date
2024-07-22T00:00:00.000
Atdissuedate
2024-07-29T12:37:48.000
Cb
3
House Num
15
Onstname
KANE PL.
Atddismissed
No
13641
Atdid: 13641 • Atd Number: ATD-3-5621 • Bblid: 333494
Atdid
13641
Atd Number
ATD-3-5621
Bblid
333494
Inspectionid
366133
Inspect Date
2023-10-25T00:00:00.000
Atdissuedate
2023-10-31T14:37:08.000
Cb
1
House Num
127
Onstname
LYNCH ST.
Atddismissed
No
14062
Atdid: 14062 • Atd Number: ATD-4-5867 • Bblid: 801952
Atdid
14062
Atd Number
ATD-4-5867
Bblid
801952
Inspectionid
372733
Inspect Date
2023-10-11T00:00:00.000
Atdissuedate
2024-03-04T14:57:18.000
Cb
10
House Num
107-08
Onstname
120TH ST.
Atddismissed
Yes
Atddismissedon
2024-06-25T07:39:23.000
18487
Atdid: 18487 • Atd Number: ATD-3-7283 • Bblid: 302515
Atdid
18487
Atd Number
ATD-3-7283
Bblid
302515
Inspectionid
405235
Inspect Date
2024-09-11T00:00:00.000
Atdissuedate
2025-09-04T16:10:58.000
Cb
3
House Num
610
Onstname
DECATUR ST.
Atddismissed
No
16566
Atdid: 16566 • Atd Number: ATD-3-6496 • Bblid: 297892
Atdid
16566
Atd Number
ATD-3-6496
Bblid
297892
Inspectionid
386993
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2024-12-20T08:27:40.000
Cb
8
House Num
1251
Onstname
LINCOLN PL.
Atddismissed
No
9381
Atdid: 9381 • Atd Number: ATD-3-3478 • Bblid: 329602
Atdid
9381
Atd Number
ATD-3-3478
Bblid
329602
Inspectionid
333106
Inspect Date
2021-04-22T00:00:00.000
Atdissuedate
2022-03-03T08:50:53.000
Cb
2
House Num
368
Onstname
CLERMONT AVE.
Atddismissed
No
13855
Atdid: 13855 • Atd Number: ATD-3-5699 • Bblid: 511686
Atdid
13855
Atd Number
ATD-3-5699
Bblid
511686
Inspectionid
370500
Inspect Date
2024-01-08T00:00:00.000
Atdissuedate
2024-01-09T12:18:51.000
Cb
15
House Num
2567
Onstname
E. 29TH ST.
Atddismissed
No
13351
Atdid: 13351 • Atd Number: ATD-4-5522 • Bblid: 892964
Atdid
13351
Atd Number
ATD-4-5522
Bblid
892964
Inspectionid
362885
Inspect Date
2023-08-24T00:00:00.000
Atdissuedate
2023-08-29T15:14:33.000
Cb
13
House Num
145-19
Onstname
223RD ST.
Atddismissed
No
17525
Atdid: 17525 • Atd Number: ATD-3-6954 • Bblid: 292165
Atdid
17525
Atd Number
ATD-3-6954
Bblid
292165
Inspectionid
396047
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-05T08:28:30.000
Cb
8
House Num
601
Onstname
EASTERN PKWY.
Atddismissed
No
10830
Atdid: 10830 • Atd Number: ATD-3-4201 • Bblid: 323404
Atdid
10830
Atd Number
ATD-3-4201
Bblid
323404
Inspectionid
343335
Inspect Date
2022-08-30T00:00:00.000
Atdissuedate
2022-09-12T10:06:15.000
Cb
3
House Num
107
Onstname
CLIFTON PL.
Atddismissed
No
18167
Atdid: 18167 • Atd Number: ATD-3-7168 • Bblid: 561550
Atdid
18167
Atd Number
ATD-3-7168
Bblid
561550
Inspectionid
402941
Inspect Date
2025-07-12T00:00:00.000
Atdissuedate
2025-07-22T16:42:44.000
Cb
15
House Num
2722
Onstname
BROWN ST.
Atddismissed
No
13425
Atdid: 13425 • Atd Number: ATD-3-5531 • Bblid: 307364
Atdid
13425
Atd Number
ATD-3-5531
Bblid
307364
Inspectionid
363840
Inspect Date
2023-09-19T00:00:00.000
Atdissuedate
2023-09-19T08:46:14.000
Cb
3
House Num
904
Onstname
GREENE AVE.
Atddismissed
No
15099
Atdid: 15099 • Atd Number: ATD-4-6298 • Bblid: 808751
Atdid
15099
Atd Number
ATD-4-6298
Bblid
808751
Inspectionid
382177
Inspect Date
2024-09-13T00:00:00.000
Atdissuedate
2024-09-23T13:11:39.000
Cb
8
House Num
175-24
Onstname
MAYFIELD RD.
Atddismissed
No
12001
Atdid: 12001 • Atd Number: ATD-4-5117 • Bblid: 654969
Atdid
12001
Atd Number
ATD-4-5117
Bblid
654969
Inspectionid
354648
Inspect Date
2023-04-10T00:00:00.000
Atdissuedate
2023-04-10T12:01:08.000
Cb
6
House Num
85-30
Onstname
66TH AVE.
Atddismissed
No
12795
Atdid: 12795 • Atd Number: ATD-3-5129 • Bblid: 503147
Atdid
12795
Atd Number
ATD-3-5129
Bblid
503147
Inspectionid
359624
Inspect Date
2023-07-08T00:00:00.000
Atdissuedate
2023-07-08T13:01:36.000
Cb
15
House Num
1976
Onstname
E. 22ND ST.
Atddismissed
No