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
10466
Atdid: 10466 • Atd Number: ATD-4-4728 • Bblid: 828237
Atdid
10466
Atd Number
ATD-4-4728
Bblid
828237
Inspectionid
339567
Inspect Date
2022-07-06T00:00:00.000
Atdissuedate
2022-07-14T11:29:13.000
Cb
13
House Num
89-82
Onstname
218TH PL.
Atddismissed
No
8638
Atdid: 8638 • Atd Number: ATD-4-3879 • Bblid: 772416
Atdid
8638
Atd Number
ATD-4-3879
Bblid
772416
Inspectionid
330776
Inspect Date
2021-10-21T00:00:00.000
Atdissuedate
2021-12-15T13:58:45.000
Cb
13
House Num
77-59
Onstname
269TH ST.
Atddismissed
No
11574
Atdid: 11574 • Atd Number: ATD-1-280 • Bblid: 43074
Atdid
11574
Atd Number
ATD-1-280
Bblid
43074
Inspectionid
350024
Inspect Date
2023-01-04T00:00:00.000
Atdissuedate
2023-01-04T11:33:15.000
Cb
6
House Num
5
Onstname
GRAMERCY PARK W.
Atddismissed
No
17551
Atdid: 17551 • Atd Number: ATD-4-6863 • Bblid: 725707
Atdid
17551
Atd Number
ATD-4-6863
Bblid
725707
Inspectionid
396328
Inspect Date
2025-05-06T00:00:00.000
Atdissuedate
2025-05-06T12:38:56.000
Cb
11
House Num
29-30
Onstname
201ST ST.
Atddismissed
No
9880
Atdid: 9880 • Atd Number: ATD-4-4487 • Bblid: 674101
Atdid
9880
Atd Number
ATD-4-4487
Bblid
674101
Inspectionid
334965
Inspect Date
2021-09-30T00:00:00.000
Atdissuedate
2022-04-15T10:06:17.000
Cb
5
House Num
78-17
Onstname
65TH ST.
Atddismissed
No
2974
Atdid: 2974 • Atd Number: ATD-3-2098 • Bblid: 522841
Atdid
2974
Atd Number
ATD-3-2098
Bblid
522841
Violationid
249629
Atdissuedate
2020-02-11T00:00:00.000
Cb
18
House Num
866
Onstname
EAST 59 STREET
Atddismissed
Yes
Atddismissedon
2023-11-21T08:31:32.000
10655
Atdid: 10655 • Atd Number: ATD-4-4788 • Bblid: 856644
Atdid
10655
Atd Number
ATD-4-4788
Bblid
856644
Inspectionid
341585
Inspect Date
2022-08-03T00:00:00.000
Atdissuedate
2022-08-15T15:10:54.000
Cb
10
House Num
133-34
Onstname
122ND PL.
Atddismissed
No
11453
Atdid: 11453 • Atd Number: ATD-4-4892 • Bblid: 800574
Atdid
11453
Atd Number
ATD-4-4892
Bblid
800574
Inspectionid
348659
Inspect Date
2022-11-15T00:00:00.000
Atdissuedate
2022-11-25T11:30:10.000
Cb
10
House Num
104-63
Onstname
116TH ST.
Atddismissed
No
14332
Atdid: 14332 • Atd Number: ATD-4-5981 • Bblid: 641038
Atdid
14332
Atd Number
ATD-4-5981
Bblid
641038
Inspectionid
375960
Inspect Date
2024-04-15T00:00:00.000
Atdissuedate
2024-04-23T13:05:54.000
Cb
5
House Num
57-49
Onstname
65TH ST.
Atddismissed
No
13371
Atdid: 13371 • Atd Number: ATD-3-5501 • Bblid: 445395
Atdid
13371
Atd Number
ATD-3-5501
Bblid
445395
Inspectionid
363213
Inspect Date
2023-09-09T00:00:00.000
Atdissuedate
2023-09-11T09:39:27.000
Cb
10
House Num
1026
Onstname
72ND ST.
Atddismissed
No
10720
Atdid: 10720 • Atd Number: ATD-3-4103 • Bblid: 311190
Atdid
10720
Atd Number
ATD-3-4103
Bblid
311190
Inspectionid
342344
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-08-31T13:17:13.000
Cb
3
House Num
368
Onstname
MACDONOUGH ST.
Atddismissed
No
10998
Atdid: 10998 • Atd Number: ATD-3-4351 • Bblid: 318199
Atdid
10998
Atd Number
ATD-3-4351
Bblid
318199
Inspectionid
344479
Inspect Date
2022-09-17T00:00:00.000
Atdissuedate
2022-09-23T16:51:36.000
Cb
3
House Num
466
Onstname
JEFFERSON AVE.
Atddismissed
No
11778
Atdid: 11778 • Atd Number: ATD-3-4791 • Bblid: 436701
Atdid
11778
Atd Number
ATD-3-4791
Bblid
436701
Violationid
284025
Reinspectionid
35405
Inspect Date
2023-03-13T12:09:59.000
Atdissuedate
2023-03-13T12:09:59.000
Cb
12
House Num
1375
Onstname
58 STREET
Atddismissed
No
11663
Atdid: 11663 • Atd Number: ATD-4-4986 • Bblid: 725938
Atdid
11663
Atd Number
ATD-4-4986
Bblid
725938
Inspectionid
351625
Inspect Date
2023-02-07T00:00:00.000
Atdissuedate
2023-02-16T10:25:11.000
Cb
11
House Num
32-14
Onstname
204TH ST.
Atddismissed
No
12880
Atdid: 12880 • Atd Number: ATD-4-5447 • Bblid: 837502
Atdid
12880
Atd Number
ATD-4-5447
Bblid
837502
Inspectionid
360156
Inspect Date
2023-07-14T00:00:00.000
Atdissuedate
2023-07-17T13:07:46.000
Cb
12
House Num
205-29
Onstname
114TH DR.
Atddismissed
No
16451
Atdid: 16451 • Atd Number: ATD-1-333 • Bblid: 136030
Atdid
16451
Atd Number
ATD-1-333
Bblid
136030
Inspectionid
385492
Inspect Date
2024-11-01T00:00:00.000
Atdissuedate
2024-11-29T13:34:20.000
Cb
12
House Num
16
Onstname
CHITTENDEN AVE.
Atddismissed
No
8531
Atdid: 8531 • Atd Number: ATD-3-3115 • Bblid: 423734
Atdid
8531
Atd Number
ATD-3-3115
Bblid
423734
Inspectionid
330126
Inspect Date
2021-12-01T00:00:00.000
Atdissuedate
2021-12-01T19:21:05.000
Cb
12
House Num
5008
Onstname
20TH AVE.
Atddismissed
No
16634
Atdid: 16634 • Atd Number: ATD-4-6533 • Bblid: 617708
Atdid
16634
Atd Number
ATD-4-6533
Bblid
617708
Inspectionid
388393
Inspect Date
2024-12-20T00:00:00.000
Atdissuedate
2025-01-03T10:34:00.000
Cb
3
House Num
35-09
Onstname
100TH ST.
Atddismissed
No
9005
Atdid: 9005 • Atd Number: ATD-3-3287 • Bblid: 299273
Atdid
9005
Atd Number
ATD-3-3287
Bblid
299273
Inspectionid
332347
Inspect Date
2019-06-19T00:00:00.000
Atdissuedate
2022-02-09T16:41:31.000
Cb
9
House Num
802
Onstname
MONTGOMERY ST.
Atddismissed
No
11146
Atdid: 11146 • Atd Number: ATD-1-204 • Bblid: 103899
Atdid
11146
Atd Number
ATD-1-204
Bblid
103899
Inspectionid
345834
Inspect Date
2022-10-13T00:00:00.000
Atdissuedate
2022-10-13T14:52:34.000
Cb
8
House Num
177
Onstname
E. 80TH ST.
Atddismissed
No
9601
Atdid: 9601 • Atd Number: ATD-4-4308 • Bblid: 706780
Atdid
9601
Atd Number
ATD-4-4308
Bblid
706780
Inspectionid
333741
Inspect Date
2020-12-22T00:00:00.000
Atdissuedate
2022-03-14T18:57:31.000
Cb
7
House Num
47-29
Onstname
COLDEN ST.
Atddismissed
No
8820
Atdid: 8820 • Atd Number: ATD-5-585 • Bblid: 1001356
Atdid
8820
Atd Number
ATD-5-585
Bblid
1001356
Inspectionid
331565
Inspect Date
2018-11-30T00:00:00.000
Atdissuedate
2022-01-11T09:27:05.000
Cb
3
House Num
642
Onstname
TYSENS LN.
Atddismissed
No
8901
Atdid: 8901 • Atd Number: ATD-3-3252 • Bblid: 326921
Atdid
8901
Atd Number
ATD-3-3252
Bblid
326921
Inspectionid
332113
Inspect Date
2012-09-27T00:00:00.000
Atdissuedate
2022-01-27T10:30:38.000
Cb
3
House Num
37
Onstname
BREVOORT PL.
Atddismissed
No
14283
Atdid: 14283 • Atd Number: ATD-4-5949 • Bblid: 685013
Atdid
14283
Atd Number
ATD-4-5949
Bblid
685013
Inspectionid
375353
Inspect Date
2024-03-30T00:00:00.000
Atdissuedate
2024-04-15T13:24:35.000
Cb
7
House Num
23-21
Onstname
WHITESTONE EXPY.
Atddismissed
No
14375
Atdid: 14375 • Atd Number: ATD-3-5932 • Bblid: 548963
Atdid
14375
Atd Number
ATD-3-5932
Bblid
548963
Inspectionid
376299
Inspect Date
2024-03-13T00:00:00.000
Atdissuedate
2024-04-29T11:24:14.000
Cb
18
House Num
2047
Onstname
E. 67TH ST.
Atddismissed
No
8861
Atdid: 8861 • Atd Number: ATD-4-4004 • Bblid: 605197
Atdid
8861
Atd Number
ATD-4-4004
Bblid
605197
Violationid
100438
Inspectionid
331803
Inspect Date
2022-01-24T11:30:03.000
Atdissuedate
2022-01-24T11:30:03.000
Cb
3
House Num
26-29
Onstname
92 STREET
Atddismissed
No
11674
Atdid: 11674 • Atd Number: ATD-4-4997 • Bblid: 725974
Atdid
11674
Atd Number
ATD-4-4997
Bblid
725974
Inspectionid
351644
Inspect Date
2023-02-15T00:00:00.000
Atdissuedate
2023-02-16T11:29:09.000
Cb
11
House Num
32-50
Onstname
204TH ST.
Atddismissed
No
17257
Atdid: 17257 • Atd Number: ATD-4-6737 • Bblid: 861901
Atdid
17257
Atd Number
ATD-4-6737
Bblid
861901
Inspectionid
393247
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-04T14:33:02.000
Cb
12
House Num
114-25
Onstname
148TH ST.
Atddismissed
No
13268
Atdid: 13268 • Atd Number: ATD-3-5439 • Bblid: 286970
Atdid
13268
Atd Number
ATD-3-5439
Bblid
286970
Inspectionid
362132
Inspect Date
2023-08-09T00:00:00.000
Atdissuedate
2023-08-17T12:49:18.000
Cb
8
House Num
201
Onstname
PARK PL.
Atddismissed
No
4224
Atdid: 4224 • Atd Number: ATD-4-755 • Bblid: 883511
Atdid
4224
Atd Number
ATD-4-755
Bblid
883511
Violationid
172566
Atdissuedate
2020-08-20T00:00:00.000
Cb
13
House Num
131-80
Onstname
229 STREET
Atddismissed
Yes
Atddismissedon
2025-01-22T10:07:10.000
16747
Atdid: 16747 • Atd Number: ATD-2-1332 • Bblid: 226932
Atdid
16747
Atd Number
ATD-2-1332
Bblid
226932
Inspectionid
389020
Inspect Date
2025-01-28T00:00:00.000
Atdissuedate
2025-01-28T12:03:48.000
Cb
12
House Num
4355
Onstname
DE REIMER AVE.
Atddismissed
No
12828
Atdid: 12828 • Atd Number: ATD-4-5425 • Bblid: 600635
Atdid
12828
Atd Number
ATD-4-5425
Bblid
600635
Inspectionid
359893
Inspect Date
2023-06-24T00:00:00.000
Atdissuedate
2023-07-12T11:37:02.000
Cb
3
House Num
33-58
Onstname
75TH ST.
Atddismissed
No
17967
Atdid: 17967 • Atd Number: ATD-3-7079 • Bblid: 496409
Atdid
17967
Atd Number
ATD-3-7079
Bblid
496409
Inspectionid
400859
Inspect Date
2025-06-13T00:00:00.000
Atdissuedate
2025-06-24T12:58:17.000
Cb
15
House Num
2154
Onstname
E. 2ND ST.
Atddismissed
No
13925
Atdid: 13925 • Atd Number: ATD-4-5776 • Bblid: 846820
Atdid
13925
Atd Number
ATD-4-5776
Bblid
846820
Inspectionid
371352
Inspect Date
2024-01-18T00:00:00.000
Atdissuedate
2024-02-07T10:08:23.000
Cb
10
House Num
137-10
Onstname
WHITELAW ST.
Atddismissed
No
8796
Atdid: 8796 • Atd Number: ATD-4-3972 • Bblid: 644148
Atdid
8796
Atd Number
ATD-4-3972
Bblid
644148
Inspectionid
331325
Inspect Date
2021-12-07T00:00:00.000
Atdissuedate
2021-12-30T11:36:47.000
Cb
5
House Num
60-39
Onstname
72ND ST.
Atddismissed
No
18509
Atdid: 18509 • Atd Number: ATD-3-7290 • Bblid: 378395
Atdid
18509
Atd Number
ATD-3-7290
Bblid
378395
Inspectionid
405374
Inspect Date
2025-09-05T00:00:00.000
Atdissuedate
2025-09-08T10:09:25.000
Cb
5
House Num
624
Onstname
BARBEY ST.
Atddismissed
No
17574
Atdid: 17574 • Atd Number: ATD-4-6868 • Bblid: 751868
Atdid
17574
Atd Number
ATD-4-6868
Bblid
751868
Inspectionid
396662
Inspect Date
2025-05-07T00:00:00.000
Atdissuedate
2025-05-09T13:49:32.000
Cb
11
House Num
217-20
Onstname
47TH RD.
Atddismissed
No
13523
Atdid: 13523 • Atd Number: ATD-5-841 • Bblid: 963338
Atdid
13523
Atd Number
ATD-5-841
Bblid
963338
Inspectionid
364705
Inspect Date
2023-09-28T00:00:00.000
Atdissuedate
2023-10-02T12:27:43.000
Cb
2
House Num
253
Onstname
LANDER AVE.
Atddismissed
No
18116
Atdid: 18116 • Atd Number: ATD-4-7166 • Bblid: 833611
Atdid
18116
Atd Number
ATD-4-7166
Bblid
833611
Inspectionid
402610
Inspect Date
2025-07-15T00:00:00.000
Atdissuedate
2025-07-17T14:11:23.000
Cb
12
House Num
104-24
Onstname
204TH ST.
Atddismissed
No
16818
Atdid: 16818 • Atd Number: ATD-3-6602 • Bblid: 303231
Atdid
16818
Atd Number
ATD-3-6602
Bblid
303231
Inspectionid
389778
Inspect Date
2025-02-07T00:00:00.000
Atdissuedate
2025-02-12T10:09:05.000
Cb
16
House Num
295A
Onstname
SUMPTER ST.
Atddismissed
No
8561
Atdid: 8561 • Atd Number: ATD-3-3131 • Bblid: 302037
Atdid
8561
Atd Number
ATD-3-3131
Bblid
302037
Inspectionid
330465
Inspect Date
2019-08-20T00:00:00.000
Atdissuedate
2021-12-08T11:15:16.000
Cb
3
House Num
629
Onstname
DECATUR ST.
Atddismissed
No
8695
Atdid: 8695 • Atd Number: ATD-3-3185 • Bblid: 285158
Atdid
8695
Atd Number
ATD-3-3185
Bblid
285158
Inspectionid
330864
Inspect Date
2021-06-18T00:00:00.000
Atdissuedate
2021-12-20T08:45:33.000
Cb
7
House Num
51
Onstname
SHERMAN ST.
Atddismissed
No
11444
Atdid: 11444 • Atd Number: ATD-1-259 • Bblid: 76045
Atdid
11444
Atd Number
ATD-1-259
Bblid
76045
Inspectionid
348558
Inspect Date
2022-11-23T00:00:00.000
Atdissuedate
2022-11-23T09:57:39.000
Cb
7
House Num
159
Onstname
W. 91ST ST.
Atddismissed
No
12959
Atdid: 12959 • Atd Number: ATD-3-5233 • Bblid: 287376
Atdid
12959
Atd Number
ATD-3-5233
Bblid
287376
Inspectionid
360554
Inspect Date
2023-07-11T00:00:00.000
Atdissuedate
2023-07-24T11:17:51.000
Cb
8
House Num
201
Onstname
STERLING PL.
Atddismissed
No
11962
Atdid: 11962 • Atd Number: ATD-3-4897 • Bblid: 364773
Atdid
11962
Atd Number
ATD-3-4897
Bblid
364773
Violationid
284904
Reinspectionid
35411
Inspect Date
2023-04-03T12:04:43.000
Atdissuedate
2023-04-03T12:04:43.000
Cb
16
House Num
239
Onstname
CHESTER STREET
Atddismissed
No
2714
Atdid: 2714 • Atd Number: ATD-3-1857 • Bblid: 277171
Atdid
2714
Atd Number
ATD-3-1857
Bblid
277171
Violationid
186772
Atdissuedate
2020-08-17T00:00:00.000
Cb
6
House Num
371
Onstname
2 STREET
Atddismissed
Yes
Atddismissedon
2023-01-31T11:56:05.000
13628
Atdid: 13628 • Atd Number: ATD-3-5610 • Bblid: 306638
Atdid
13628
Atd Number
ATD-3-5610
Bblid
306638
Inspectionid
366057
Inspect Date
2023-10-28T00:00:00.000
Atdissuedate
2023-10-28T15:07:57.000
Cb
3
House Num
1068
Onstname
DEKALB AVE.
Atddismissed
No
8914
Atdid: 8914 • Atd Number: ATD-3-3253 • Bblid: 448739
Atdid
8914
Atd Number
ATD-3-3253
Bblid
448739
Inspectionid
332134
Inspect Date
2022-01-25T00:00:00.000
Atdissuedate
2022-01-28T13:15:11.000
Cb
10
House Num
619
Onstname
80TH ST.
Atddismissed
No
17292
Atdid: 17292 • Atd Number: ATD-3-6837 • Bblid: 526412
Atdid
17292
Atd Number
ATD-3-6837
Bblid
526412
Inspectionid
394013
Inspect Date
2025-04-08T00:00:00.000
Atdissuedate
2025-04-10T08:18:01.000
Cb
18
House Num
1188
Onstname
E. 58TH ST.
Atddismissed
No
8998
Atdid: 8998 • Atd Number: ATD-4-4089 • Bblid: 877738
Atdid
8998
Atd Number
ATD-4-4089
Bblid
877738
Inspectionid
332324
Inspect Date
2021-10-16T00:00:00.000
Atdissuedate
2022-02-08T15:45:55.000
Cb
12
House Num
189-02
Onstname
120TH AVE.
Atddismissed
No