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
14193
Atdid: 14193 • Atd Number: ATD-3-5853 • Bblid: 532366
Atdid
14193
Atd Number
ATD-3-5853
Bblid
532366
Inspectionid
373811
Inspect Date
2024-03-20T00:00:00.000
Atdissuedate
2024-03-20T14:47:47.000
Cb
18
House Num
625
Onstname
E. 83RD ST.
Atddismissed
No
13297
Atdid: 13297 • Atd Number: ATD-5-801 • Bblid: 963821
Atdid
13297
Atd Number
ATD-5-801
Bblid
963821
Inspectionid
362404
Inspect Date
2023-08-17T00:00:00.000
Atdissuedate
2023-08-22T13:07:43.000
Cb
2
House Num
309
Onstname
HILLMAN AVE.
Atddismissed
No
14935
Atdid: 14935 • Atd Number: ATD-4-6233 • Bblid: 667242
Atdid
14935
Atd Number
ATD-4-6233
Bblid
667242
Violationid
287039
Reinspectionid
35960
Inspect Date
2024-08-19T15:20:13.000
Atdissuedate
2024-08-19T15:20:13.000
Cb
5
House Num
60-14
Onstname
MADISON STREET
Atddismissed
Yes
Atddismissedon
2024-08-19T15:20:57.000
12052
Atdid: 12052 • Atd Number: ATD-4-5131 • Bblid: 744743
Atdid
12052
Atd Number
ATD-4-5131
Bblid
744743
Inspectionid
355975
Inspect Date
2023-04-05T00:00:00.000
Atdissuedate
2023-04-17T13:37:27.000
Cb
8
House Num
76-27
Onstname
167TH ST.
Atddismissed
No
16611
Atdid: 16611 • Atd Number: ATD-4-6524 • Bblid: 876345
Atdid
16611
Atd Number
ATD-4-6524
Bblid
876345
Inspectionid
387249
Inspect Date
2024-11-01T00:00:00.000
Atdissuedate
2024-12-27T14:36:09.000
Cb
12
House Num
117-15
Onstname
193RD ST.
Atddismissed
No
12323
Atdid: 12323 • Atd Number: ATD-2-1120 • Bblid: 154741
Atdid
12323
Atd Number
ATD-2-1120
Bblid
154741
Inspectionid
357374
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T12:43:15.000
Cb
5
House Num
1839
Onstname
SEDGWICK AVE.
Atddismissed
No
10330
Atdid: 10330 • Atd Number: ATD-3-3858 • Bblid: 275207
Atdid
10330
Atd Number
ATD-3-3858
Bblid
275207
Inspectionid
338157
Inspect Date
2022-06-23T00:00:00.000
Atdissuedate
2022-06-27T09:10:05.000
Cb
6
House Num
55
Onstname
LINCOLN PL.
Atddismissed
Yes
Atddismissedon
2025-03-24T13:35:17.000
14852
Atdid: 14852 • Atd Number: ATD-3-6172 • Bblid: 313632
Atdid
14852
Atd Number
ATD-3-6172
Bblid
313632
Inspectionid
380128
Inspect Date
2024-08-05T00:00:00.000
Atdissuedate
2024-08-05T11:18:29.000
Cb
3
House Num
238
Onstname
VERNON AVE.
Atddismissed
No
10776
Atdid: 10776 • Atd Number: ATD-3-4153 • Bblid: 429460
Atdid
10776
Atd Number
ATD-3-4153
Bblid
429460
Inspectionid
342837
Inspect Date
2022-08-20T00:00:00.000
Atdissuedate
2022-09-07T13:03:00.000
Cb
11
House Num
2081
Onstname
67TH ST.
Atddismissed
No
12178
Atdid: 12178 • Atd Number: ATD-2-1032 • Bblid: 162398
Atdid
12178
Atd Number
ATD-2-1032
Bblid
162398
Inspectionid
356813
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2023-05-09T12:38:42.000
Cb
7
House Num
2593
Onstname
GRAND CONCOURSE
Atddismissed
No
14161
Atdid: 14161 • Atd Number: ATD-3-5823 • Bblid: 532927
Atdid
14161
Atd Number
ATD-3-5823
Bblid
532927
Inspectionid
373531
Inspect Date
2024-03-19T00:00:00.000
Atdissuedate
2024-03-19T09:24:08.000
Cb
18
House Num
8220
Onstname
GLENWOOD RD.
Atddismissed
No
10168
Atdid: 10168 • Atd Number: ATD-3-3778 • Bblid: 275690
Atdid
10168
Atd Number
ATD-3-3778
Bblid
275690
Inspectionid
336916
Inspect Date
2022-05-02T00:00:00.000
Atdissuedate
2022-05-24T12:28:35.000
Cb
6
House Num
140
Onstname
BERKELEY PL.
Atddismissed
No
18472
Atdid: 18472 • Atd Number: ATD-4-7321 • Bblid: 678887
Atdid
18472
Atd Number
ATD-4-7321
Bblid
678887
Inspectionid
405181
Inspect Date
2025-08-30T00:00:00.000
Atdissuedate
2025-09-04T10:44:14.000
Cb
6
House Num
70-67
Onstname
WALNUT ST.
Atddismissed
No
16235
Atdid: 16235 • Atd Number: ATD-4-6380 • Bblid: 821479
Atdid
16235
Atd Number
ATD-4-6380
Bblid
821479
Inspectionid
384173
Inspect Date
2022-06-23T00:00:00.000
Atdissuedate
2024-10-15T13:29:45.000
Cb
12
House Num
187-33
Onstname
ILION AVE.
Atddismissed
No
10747
Atdid: 10747 • Atd Number: ATD-3-4125 • Bblid: 554669
Atdid
10747
Atd Number
ATD-3-4125
Bblid
554669
Inspectionid
342726
Inspect Date
2022-08-26T00:00:00.000
Atdissuedate
2022-09-06T14:24:54.000
Cb
18
House Num
2762
Onstname
E. 64TH ST.
Atddismissed
No
9894
Atdid: 9894 • Atd Number: ATD-4-4500 • Bblid: 777138
Atdid
9894
Atd Number
ATD-4-4500
Bblid
777138
Inspectionid
335065
Inspect Date
2022-04-15T00:00:00.000
Atdissuedate
2022-04-18T08:35:31.000
Cb
9
House Num
85-77
Onstname
87TH ST.
Atddismissed
No
14394
Atdid: 14394 • Atd Number: ATD-4-6011 • Bblid: 677779
Atdid
14394
Atd Number
ATD-4-6011
Bblid
677779
Inspectionid
376674
Inspect Date
2024-05-06T00:00:00.000
Atdissuedate
2024-05-06T11:26:14.000
Cb
5
House Num
87-17
Onstname
81ST AVE.
Atddismissed
No
8759
Atdid: 8759 • Atd Number: ATD-3-3209 • Bblid: 264628
Atdid
8759
Atd Number
ATD-3-3209
Bblid
264628
Inspectionid
331127
Inspect Date
2021-12-22T00:00:00.000
Atdissuedate
2021-12-28T15:02:53.000
Cb
7
House Num
425
Onstname
41ST ST.
Atddismissed
No
9905
Atdid: 9905 • Atd Number: ATD-3-3629 • Bblid: 272751
Atdid
9905
Atd Number
ATD-3-3629
Bblid
272751
Inspectionid
335163
Inspect Date
2022-04-15T00:00:00.000
Atdissuedate
2022-04-19T11:08:02.000
Cb
7
House Num
315
Onstname
22ND ST.
Atddismissed
No
17837
Atdid: 17837 • Atd Number: ATD-4-7035 • Bblid: 709461
Atdid
17837
Atd Number
ATD-4-7035
Bblid
709461
Inspectionid
399502
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-06-09T10:49:10.000
Cb
7
House Num
169-04
Onstname
33 AVENUE
Atddismissed
Yes
Atddismissedon
2025-08-05T13:24:51.000
13229
Atdid: 13229 • Atd Number: ATD-3-5400 • Bblid: 422712
Atdid
13229
Atd Number
ATD-3-5400
Bblid
422712
Inspectionid
362049
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T15:30:19.000
Cb
12
House Num
1721
Onstname
46TH ST.
Atddismissed
No
11712
Atdid: 11712 • Atd Number: ATD-4-5017 • Bblid: 630070
Atdid
11712
Atd Number
ATD-4-5017
Bblid
630070
Inspectionid
352024
Inspect Date
2023-02-10T00:00:00.000
Atdissuedate
2023-02-24T13:10:47.000
Cb
6
House Num
112-16
Onstname
71ST RD.
Atddismissed
No
8678
Atdid: 8678 • Atd Number: ATD-4-3902 • Bblid: 871415
Atdid
8678
Atd Number
ATD-4-3902
Bblid
871415
Inspectionid
330847
Inspect Date
2019-06-28T00:00:00.000
Atdissuedate
2021-12-17T09:48:47.000
Cb
12
House Num
115-17
Onstname
169TH ST.
Atddismissed
No
9027
Atdid: 9027 • Atd Number: ATD-5-603 • Bblid: 1026972
Atdid
9027
Atd Number
ATD-5-603
Bblid
1026972
Inspectionid
332391
Inspect Date
2022-02-11T00:00:00.000
Atdissuedate
2022-02-11T14:56:53.000
Cb
3
House Num
1009
Onstname
ARDEN AVE.
Atddismissed
No
8898
Atdid: 8898 • Atd Number: ATD-4-4028 • Bblid: 868650
Atdid
8898
Atd Number
ATD-4-4028
Bblid
868650
Inspectionid
332110
Inspect Date
2019-06-25T00:00:00.000
Atdissuedate
2022-01-27T09:03:23.000
Cb
12
House Num
150-19
Onstname
119TH AVE.
Atddismissed
No
13842
Atdid: 13842 • Atd Number: ATD-4-5732 • Bblid: 591919
Atdid
13842
Atd Number
ATD-4-5732
Bblid
591919
Inspectionid
370401
Inspect Date
2023-11-21T00:00:00.000
Atdissuedate
2024-01-08T11:01:08.000
Cb
1
House Num
19-36
Onstname
76TH ST.
Atddismissed
No
13491
Atdid: 13491 • Atd Number: ATD-4-5551 • Bblid: 693071
Atdid
13491
Atd Number
ATD-4-5551
Bblid
693071
Inspectionid
364476
Inspect Date
2023-09-27T00:00:00.000
Atdissuedate
2023-09-27T12:03:21.000
Cb
7
House Num
151-32
Onstname
21ST AVE.
Atddismissed
No
10620
Atdid: 10620 • Atd Number: ATD-4-4769 • Bblid: 879566
Atdid
10620
Atd Number
ATD-4-4769
Bblid
879566
Inspectionid
341088
Inspect Date
2022-07-30T00:00:00.000
Atdissuedate
2022-08-08T13:36:39.000
Cb
13
House Num
117-40
Onstname
223RD ST.
Atddismissed
No
13057
Atdid: 13057 • Atd Number: ATD-3-5301 • Bblid: 422512
Atdid
13057
Atd Number
ATD-3-5301
Bblid
422512
Inspectionid
361051
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T16:31:47.000
Cb
12
House Num
1680
Onstname
45TH ST.
Atddismissed
No
9019
Atdid: 9019 • Atd Number: ATD-4-4094 • Bblid: 898834
Atdid
9019
Atd Number
ATD-4-4094
Bblid
898834
Inspectionid
332379
Inspect Date
2019-06-26T00:00:00.000
Atdissuedate
2022-02-10T16:22:38.000
Cb
13
House Num
148-66
Onstname
HUXLEY ST.
Atddismissed
No
18626
Atdid: 18626 • Atd Number: ATD-3-7337 • Bblid: 511532
Atdid
18626
Atd Number
ATD-3-7337
Bblid
511532
Inspectionid
406175
Inspect Date
2025-09-06T00:00:00.000
Atdissuedate
2025-09-19T12:11:53.000
Cb
15
House Num
2532
Onstname
E. 28TH ST.
Atddismissed
No
13688
Atdid: 13688 • Atd Number: ATD-4-5636 • Bblid: 807978
Atdid
13688
Atd Number
ATD-4-5636
Bblid
807978
Inspectionid
367533
Inspect Date
2023-11-15T00:00:00.000
Atdissuedate
2023-11-15T14:58:19.000
Cb
8
House Num
84-05
Onstname
164TH ST.
Atddismissed
No
14211
Atdid: 14211 • Atd Number: ATD-4-5914 • Bblid: 826233
Atdid
14211
Atd Number
ATD-4-5914
Bblid
826233
Inspectionid
373989
Inspect Date
2023-10-20T00:00:00.000
Atdissuedate
2024-03-22T13:24:19.000
Cb
13
House Num
94-11
Onstname
215TH ST.
Atddismissed
No
16130
Atdid: 16130 • Atd Number: ATD-4-6324 • Bblid: 607289
Atdid
16130
Atd Number
ATD-4-6324
Bblid
607289
Inspectionid
383330
Inspect Date
2024-09-18T00:00:00.000
Atdissuedate
2024-09-27T12:42:59.000
Cb
3
House Num
32-28
Onstname
88TH ST.
Atddismissed
No
13021
Atdid: 13021 • Atd Number: ATD-3-5265 • Bblid: 509815
Atdid
13021
Atd Number
ATD-3-5265
Bblid
509815
Inspectionid
361013
Inspect Date
2023-07-11T00:00:00.000
Atdissuedate
2023-07-28T12:05:34.000
Cb
15
House Num
1720
Onstname
AVENUE X.
Atddismissed
No
15081
Atdid: 15081 • Atd Number: ATD-4-6289 • Bblid: 747917
Atdid
15081
Atd Number
ATD-4-6289
Bblid
747917
Inspectionid
382101
Inspect Date
2024-08-20T00:00:00.000
Atdissuedate
2024-09-23T11:43:51.000
Cb
8
House Num
73-52
Onstname
193RD ST.
Atddismissed
No
14233
Atdid: 14233 • Atd Number: ATD-3-5863 • Bblid: 435088
Atdid
14233
Atd Number
ATD-3-5863
Bblid
435088
Inspectionid
374607
Inspect Date
2024-02-21T00:00:00.000
Atdissuedate
2024-04-03T12:19:46.000
Cb
12
House Num
5310
Onstname
11TH AVE.
Atddismissed
No
10283
Atdid: 10283 • Atd Number: ATD-4-4656 • Bblid: 747784
Atdid
10283
Atd Number
ATD-4-4656
Bblid
747784
Inspectionid
337674
Inspect Date
2022-06-11T00:00:00.000
Atdissuedate
2022-06-13T17:22:52.000
Cb
8
House Num
73-08
Onstname
198TH ST.
Atddismissed
No
16563
Atdid: 16563 • Atd Number: ATD-3-6495 • Bblid: 460825
Atdid
16563
Atd Number
ATD-3-6495
Bblid
460825
Violationid
297810
Reinspectionid
37600
Inspect Date
2024-12-19T15:15:05.000
Atdissuedate
2024-12-19T15:15:05.000
Cb
10
House Num
7811
Onstname
12 AVENUE
Atddismissed
No
12326
Atdid: 12326 • Atd Number: ATD-2-1123 • Bblid: 152731
Atdid
12326
Atd Number
ATD-2-1123
Bblid
152731
Inspectionid
357377
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T12:46:16.000
Cb
5
House Num
109
Onstname
E. TREMONT AVE.
Atddismissed
No
18113
Atdid: 18113 • Atd Number: ATD-4-7163 • Bblid: 845882
Atdid
18113
Atd Number
ATD-4-7163
Bblid
845882
Inspectionid
402589
Inspect Date
2025-06-18T00:00:00.000
Atdissuedate
2025-07-17T13:31:06.000
Cb
10
House Num
132-12
Onstname
88TH ST.
Atddismissed
No
13806
Atdid: 13806 • Atd Number: ATD-4-5701 • Bblid: 861060
Atdid
13806
Atd Number
ATD-4-5701
Bblid
861060
Inspectionid
370026
Inspect Date
2023-11-22T00:00:00.000
Atdissuedate
2023-12-22T12:50:25.000
Cb
12
House Num
111-33
Onstname
INWOOD ST.
Atddismissed
No
17788
Atdid: 17788 • Atd Number: ATD-3-7017 • Bblid: 546265
Atdid
17788
Atd Number
ATD-3-7017
Bblid
546265
Inspectionid
399039
Inspect Date
2025-05-30T00:00:00.000
Atdissuedate
2025-06-04T09:44:36.000
Cb
18
House Num
1154
Onstname
E. 73RD ST.
Atddismissed
No
10351
Atdid: 10351 • Atd Number: ATD-3-3864 • Bblid: 424551
Atdid
10351
Atd Number
ATD-3-3864
Bblid
424551
Inspectionid
338404
Inspect Date
2022-06-29T00:00:00.000
Atdissuedate
2022-07-05T08:18:33.000
Cb
12
House Num
1613
Onstname
54TH ST.
Atddismissed
No
18274
Atdid: 18274 • Atd Number: ATD-3-7211 • Bblid: 515578
Atdid
18274
Atd Number
ATD-3-7211
Bblid
515578
Inspectionid
403710
Inspect Date
2025-08-05T00:00:00.000
Atdissuedate
2025-08-06T13:55:05.000
Cb
18
House Num
1249
Onstname
E. 34TH ST.
Atddismissed
No
10332
Atdid: 10332 • Atd Number: ATD-4-4684 • Bblid: 758550
Atdid
10332
Atd Number
ATD-4-4684
Bblid
758550
Inspectionid
338202
Inspect Date
2022-06-16T00:00:00.000
Atdissuedate
2022-06-27T12:04:34.000
Cb
11
House Num
80-41
Onstname
211TH ST.
Atddismissed
No
17270
Atdid: 17270 • Atd Number: ATD-3-6828 • Bblid: 280778
Atdid
17270
Atd Number
ATD-3-6828
Bblid
280778
Inspectionid
393432
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-07T11:42:37.000
Cb
7
House Num
147
Onstname
16TH ST.
Atddismissed
No
17327
Atdid: 17327 • Atd Number: ATD-4-6753 • Bblid: 781532
Atdid
17327
Atd Number
ATD-4-6753
Bblid
781532
Inspectionid
394458
Inspect Date
2025-04-10T00:00:00.000
Atdissuedate
2025-04-14T08:49:28.000
Cb
9
House Num
91-13
Onstname
85TH ST.
Atddismissed
No
2763
Atdid: 2763 • Atd Number: ATD-3-1906 • Bblid: 511760
Atdid
2763
Atd Number
ATD-3-1906
Bblid
511760
Violationid
188975
Atdissuedate
2020-08-17T00:00:00.000
Cb
15
House Num
2630
Onstname
EAST 11 STREET
Atddismissed
Yes
Atddismissedon
2025-07-12T10:54:05.000
10072
Atdid: 10072 • Atd Number: ATD-3-3692 • Bblid: 407427
Atdid
10072
Atd Number
ATD-3-3692
Bblid
407427
Inspectionid
336344
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-11T12:33:26.000
Cb
9
House Num
270
Onstname
MIDWOOD ST.
Atddismissed
No