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
18109
Atdid: 18109 • Atd Number: ATD-4-7159 • Bblid: 761216
Atdid
18109
Atd Number
ATD-4-7159
Bblid
761216
Inspectionid
402548
Inspect Date
2025-07-15T00:00:00.000
Atdissuedate
2025-07-17T11:49:02.000
Cb
13
House Num
88-24
Onstname
GETTYSBURG ST.
Atddismissed
No
14764
Atdid: 14764 • Atd Number: ATD-4-6159 • Bblid: 567975
Atdid
14764
Atd Number
ATD-4-6159
Bblid
567975
Inspectionid
379527
Inspect Date
2024-07-16T00:00:00.000
Atdissuedate
2024-07-18T11:29:36.000
Cb
2
House Num
45-34
Onstname
11TH ST.
Atddismissed
No
13663
Atdid: 13663 • Atd Number: ATD-4-5628 • Bblid: 747298
Atdid
13663
Atd Number
ATD-4-5628
Bblid
747298
Inspectionid
366377
Inspect Date
2023-11-08T00:00:00.000
Atdissuedate
2023-11-08T13:54:37.000
Cb
8
House Num
69-13
Onstname
181ST ST.
Atddismissed
No
10595
Atdid: 10595 • Atd Number: ATD-4-4766 • Bblid: 742315
Atdid
10595
Atd Number
ATD-4-4766
Bblid
742315
Inspectionid
340838
Inspect Date
2022-08-04T00:00:00.000
Atdissuedate
2022-08-04T10:40:56.000
Cb
7
House Num
60-09
Onstname
170TH ST.
Atddismissed
No
13362
Atdid: 13362 • Atd Number: ATD-3-5496 • Bblid: 559916
Atdid
13362
Atd Number
ATD-3-5496
Bblid
559916
Inspectionid
362957
Inspect Date
2023-09-05T00:00:00.000
Atdissuedate
2023-09-05T12:31:18.000
Cb
15
House Num
172
Onstname
EXETER ST.
Atddismissed
No
12986
Atdid: 12986 • Atd Number: ATD-4-5463 • Bblid: 897476
Atdid
12986
Atd Number
ATD-4-5463
Bblid
897476
Inspectionid
360741
Inspect Date
2023-07-27T00:00:00.000
Atdissuedate
2023-07-27T13:10:54.000
Cb
13
House Num
259-50
Onstname
147TH DR.
Atddismissed
No
11412
Atdid: 11412 • Atd Number: ATD-1-244 • Bblid: 119370
Atdid
11412
Atd Number
ATD-1-244
Bblid
119370
Inspectionid
348381
Inspect Date
2022-11-03T00:00:00.000
Atdissuedate
2022-11-18T13:41:08.000
Cb
11
House Num
312
Onstname
E. 120TH ST.
Atddismissed
No
11252
Atdid: 11252 • Atd Number: ATD-3-4558 • Bblid: 283396
Atdid
11252
Atd Number
ATD-3-4558
Bblid
283396
Inspectionid
346850
Inspect Date
2022-10-18T00:00:00.000
Atdissuedate
2022-10-24T13:15:12.000
Cb
6
House Num
560
Onstname
9 STREET
Atddismissed
No
10695
Atdid: 10695 • Atd Number: ATD-4-4798 • Bblid: 774296
Atdid
10695
Atd Number
ATD-4-4798
Bblid
774296
Inspectionid
342067
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-08-26T12:26:03.000
Cb
13
House Num
82-12
Onstname
261ST ST.
Atddismissed
No
9627
Atdid: 9627 • Atd Number: ATD-4-4331 • Bblid: 832522
Atdid
9627
Atd Number
ATD-4-4331
Bblid
832522
Inspectionid
333796
Inspect Date
2021-04-14T00:00:00.000
Atdissuedate
2022-03-15T18:47:02.000
Cb
12
House Num
100-32
Onstname
202ND ST.
Atddismissed
No
10287
Atdid: 10287 • Atd Number: ATD-4-4660 • Bblid: 747800
Atdid
10287
Atd Number
ATD-4-4660
Bblid
747800
Inspectionid
337680
Inspect Date
2022-06-11T00:00:00.000
Atdissuedate
2022-06-13T17:34:27.000
Cb
8
House Num
73-34
Onstname
198TH ST.
Atddismissed
No
14209
Atdid: 14209 • Atd Number: ATD-4-5912 • Bblid: 770327
Atdid
14209
Atd Number
ATD-4-5912
Bblid
770327
Inspectionid
373964
Inspect Date
2024-01-13T00:00:00.000
Atdissuedate
2024-03-22T09:42:52.000
Cb
13
House Num
83-57
Onstname
250TH ST.
Atddismissed
No
11004
Atdid: 11004 • Atd Number: ATD-3-4357 • Bblid: 442381
Atdid
11004
Atd Number
ATD-3-4357
Bblid
442381
Inspectionid
344516
Inspect Date
2022-09-24T00:00:00.000
Atdissuedate
2022-09-26T08:48:38.000
Cb
10
House Num
348
Onstname
68TH ST.
Atddismissed
No
11640
Atdid: 11640 • Atd Number: ATD-3-4727 • Bblid: 279443
Atdid
11640
Atd Number
ATD-3-4727
Bblid
279443
Inspectionid
350972
Inspect Date
2023-01-27T00:00:00.000
Atdissuedate
2023-02-06T11:06:59.000
Cb
6
House Num
283
Onstname
11TH ST.
Atddismissed
No
1052
Atdid: 1052 • Atd Number: ATD-3-195 • Bblid: 551697
Atdid
1052
Atd Number
ATD-3-195
Bblid
551697
Violationid
93164
Atdissuedate
2020-08-13T00:00:00.000
Cb
18
House Num
1856
Onstname
EAST 51 STREET
Atddismissed
Yes
Atddismissedon
2022-09-09T09:40:37.000
12648
Atdid: 12648 • Atd Number: ATD-4-5389 • Bblid: 605659
Atdid
12648
Atd Number
ATD-4-5389
Bblid
605659
Inspectionid
358957
Inspect Date
2023-06-23T00:00:00.000
Atdissuedate
2023-06-23T13:28:08.000
Cb
3
House Num
26-33
Onstname
95TH ST.
Atddismissed
No
9271
Atdid: 9271 • Atd Number: ATD-3-3389 • Bblid: 474064
Atdid
9271
Atd Number
ATD-3-3389
Bblid
474064
Inspectionid
332977
Inspect Date
2021-07-08T00:00:00.000
Atdissuedate
2022-03-01T17:48:15.000
Cb
12
House Num
1455
Onstname
OCEAN PKWY.
Atddismissed
No
2347
Atdid: 2347 • Atd Number: ATD-3-1490 • Bblid: 281999
Atdid
2347
Atd Number
ATD-3-1490
Bblid
281999
Violationid
170504
Atdissuedate
2020-08-12T00:00:00.000
Cb
6
House Num
765
Onstname
CARROLL STREET
Atddismissed
Yes
Atddismissedon
2025-03-17T09:56:49.000
9781
Atdid: 9781 • Atd Number: ATD-4-4428 • Bblid: 664083
Atdid
9781
Atd Number
ATD-4-4428
Bblid
664083
Inspectionid
334374
Inspect Date
2019-09-27T00:00:00.000
Atdissuedate
2022-03-29T18:20:32.000
Cb
5
House Num
18-16
Onstname
MENAHAN ST.
Atddismissed
No
8677
Atdid: 8677 • Atd Number: ATD-3-3181 • Bblid: 548411
Atdid
8677
Atd Number
ATD-3-3181
Bblid
548411
Inspectionid
330846
Inspect Date
2019-10-23T00:00:00.000
Atdissuedate
2021-12-17T09:20:50.000
Cb
18
House Num
2070
Onstname
PEARSON ST.
Atddismissed
No
15011
Atdid: 15011 • Atd Number: ATD-3-6251 • Bblid: 333592
Atdid
15011
Atd Number
ATD-3-6251
Bblid
333592
Inspectionid
381571
Inspect Date
2024-08-28T00:00:00.000
Atdissuedate
2024-09-09T13:10:29.000
Cb
1
House Num
241
Onstname
LYNCH ST.
Atddismissed
No
10326
Atdid: 10326 • Atd Number: ATD-2-928 • Bblid: 168993
Atdid
10326
Atd Number
ATD-2-928
Bblid
168993
Inspectionid
338065
Inspect Date
2022-06-23T00:00:00.000
Atdissuedate
2022-06-24T12:31:14.000
Cb
12
House Num
214
Onstname
E. 236TH ST.
Atddismissed
No
12327
Atdid: 12327 • Atd Number: ATD-4-5194 • Bblid: 656939
Atdid
12327
Atd Number
ATD-4-5194
Bblid
656939
Inspectionid
357387
Inspect Date
2023-04-06T00:00:00.000
Atdissuedate
2023-05-19T13:18:56.000
Cb
6
House Num
93-03
Onstname
68TH AVE.
Atddismissed
No
10754
Atdid: 10754 • Atd Number: ATD-3-4132 • Bblid: 554635
Atdid
10754
Atd Number
ATD-3-4132
Bblid
554635
Inspectionid
342751
Inspect Date
2022-08-29T00:00:00.000
Atdissuedate
2022-09-06T14:35:31.000
Cb
18
House Num
2720
Onstname
E. 64TH ST.
Atddismissed
No
11259
Atdid: 11259 • Atd Number: ATD-3-4565 • Bblid: 298565
Atdid
11259
Atd Number
ATD-3-4565
Bblid
298565
Inspectionid
346890
Inspect Date
2022-10-22T00:00:00.000
Atdissuedate
2022-10-24T15:38:40.000
Cb
9
House Num
1507
Onstname
PRESIDENT ST.
Atddismissed
No
16154
Atdid: 16154 • Atd Number: ATD-4-6332 • Bblid: 861138
Atdid
16154
Atd Number
ATD-4-6332
Bblid
861138
Inspectionid
383559
Inspect Date
2024-09-19T00:00:00.000
Atdissuedate
2024-09-30T14:00:35.000
Cb
12
House Num
111-68
Onstname
146TH ST.
Atddismissed
No
17489
Atdid: 17489 • Atd Number: ATD-5-968 • Bblid: 1026232
Atdid
17489
Atd Number
ATD-5-968
Bblid
1026232
Inspectionid
395684
Inspect Date
2025-04-19T00:00:00.000
Atdissuedate
2025-04-30T15:25:32.000
Cb
3
House Num
15
Onstname
DRUMGOOLE RD. E.
Atddismissed
No
12674
Atdid: 12674 • Atd Number: ATD-5-716 • Bblid: 1023260
Atdid
12674
Atd Number
ATD-5-716
Bblid
1023260
Inspectionid
359080
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-06-28T16:16:03.000
Cb
3
House Num
27
Onstname
ABINGDON CT.
Atddismissed
No
8645
Atdid: 8645 • Atd Number: ATD-3-3169 • Bblid: 283688
Atdid
8645
Atd Number
ATD-3-3169
Bblid
283688
Inspectionid
330783
Inspect Date
2019-04-27T00:00:00.000
Atdissuedate
2021-12-15T16:08:15.000
Cb
6
House Num
664
Onstname
10TH ST.
Atddismissed
No
17011
Atdid: 17011 • Atd Number: ATD-3-6679 • Bblid: 282900
Atdid
17011
Atd Number
ATD-3-6679
Bblid
282900
Inspectionid
392197
Inspect Date
2025-03-19T00:00:00.000
Atdissuedate
2025-03-25T13:09:28.000
Cb
6
House Num
562
Onstname
4TH ST.
Atddismissed
No
8567
Atdid: 8567 • Atd Number: ATD-3-3137 • Bblid: 506820
Atdid
8567
Atd Number
ATD-3-3137
Bblid
506820
Inspectionid
330471
Inspect Date
2019-08-02T00:00:00.000
Atdissuedate
2021-12-08T12:17:05.000
Cb
15
House Num
2158
Onstname
BROWN ST.
Atddismissed
Yes
Atddismissedon
2023-07-28T08:52:45.000
18143
Atdid: 18143 • Atd Number: ATD-3-7153 • Bblid: 521040
Atdid
18143
Atd Number
ATD-3-7153
Bblid
521040
Inspectionid
402803
Inspect Date
2025-07-02T00:00:00.000
Atdissuedate
2025-07-21T11:28:54.000
Cb
17
House Num
965
Onstname
E. 39TH ST.
Atddismissed
No
11165
Atdid: 11165 • Atd Number: ATD-1-207 • Bblid: 96106
Atdid
11165
Atd Number
ATD-1-207
Bblid
96106
Inspectionid
346030
Inspect Date
2022-10-14T00:00:00.000
Atdissuedate
2022-10-14T15:07:45.000
Cb
8
House Num
244
Onstname
E. 62ND ST.
Atddismissed
No
16564
Atdid: 16564 • Atd Number: ATD-2-1328 • Bblid: 234747
Atdid
16564
Atd Number
ATD-2-1328
Bblid
234747
Inspectionid
386991
Inspect Date
2024-12-13T00:00:00.000
Atdissuedate
2024-12-20T07:16:24.000
Cb
10
House Num
2952
Onstname
PHILIP AVE.
Atddismissed
No
12558
Atdid: 12558 • Atd Number: ATD-3-5075 • Bblid: 407284
Atdid
12558
Atd Number
ATD-3-5075
Bblid
407284
Inspectionid
358509
Inspect Date
2023-05-17T00:00:00.000
Atdissuedate
2023-06-13T14:47:11.000
Cb
9
House Num
149
Onstname
MIDWOOD ST.
Atddismissed
No
12850
Atdid: 12850 • Atd Number: ATD-3-5155 • Bblid: 553830
Atdid
12850
Atd Number
ATD-3-5155
Bblid
553830
Inspectionid
359975
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-07-13T16:03:32.000
Cb
18
House Num
3722
Onstname
AVENUE T.
Atddismissed
No
12272
Atdid: 12272 • Atd Number: ATD-3-5032 • Bblid: 272575
Atdid
12272
Atd Number
ATD-3-5032
Bblid
272575
Violationid
280509
Reinspectionid
33862
Inspect Date
2023-05-18T10:30:58.000
Atdissuedate
2023-05-18T10:30:58.000
Cb
7
House Num
285
Onstname
22 STREET
Atddismissed
No
9996
Atdid: 9996 • Atd Number: ATD-4-4548 • Bblid: 654505
Atdid
9996
Atd Number
ATD-4-4548
Bblid
654505
Inspectionid
335824
Inspect Date
2022-04-19T00:00:00.000
Atdissuedate
2022-04-29T14:00:11.000
Cb
6
House Num
64-31
Onstname
ELLWELL CRES
Atddismissed
No
13393
Atdid: 13393 • Atd Number: ATD-3-5512 • Bblid: 477205
Atdid
13393
Atd Number
ATD-3-5512
Bblid
477205
Inspectionid
363374
Inspect Date
2023-09-08T00:00:00.000
Atdissuedate
2023-09-11T18:08:14.000
Cb
11
House Num
1732
Onstname
W. 8TH ST.
Atddismissed
No
16463
Atdid: 16463 • Atd Number: ATD-4-6476 • Bblid: 655474
Atdid
16463
Atd Number
ATD-4-6476
Bblid
655474
Inspectionid
385592
Inspect Date
2024-11-15T00:00:00.000
Atdissuedate
2024-12-02T12:37:32.000
Cb
6
House Num
66-27
Onstname
BURNS ST.
Atddismissed
No
17527
Atdid: 17527 • Atd Number: ATD-4-6840 • Bblid: 579893
Atdid
17527
Atd Number
ATD-4-6840
Bblid
579893
Inspectionid
396075
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-05T09:11:49.000
Cb
1
House Num
30-25
Onstname
35TH ST.
Atddismissed
No
18604
Atdid: 18604 • Atd Number: ATD-3-7329 • Bblid: 486085
Atdid
18604
Atd Number
ATD-3-7329
Bblid
486085
Inspectionid
405914
Inspect Date
2025-09-12T00:00:00.000
Atdissuedate
2025-09-15T18:05:24.000
Cb
15
House Num
1815
Onstname
E. 24TH ST.
Atddismissed
No
10049
Atdid: 10049 • Atd Number: ATD-4-4590 • Bblid: 629559
Atdid
10049
Atd Number
ATD-4-4590
Bblid
629559
Inspectionid
336134
Inspect Date
2020-12-03T00:00:00.000
Atdissuedate
2022-05-04T13:40:32.000
Cb
6
House Num
110-12
Onstname
69TH AVE.
Atddismissed
No
17192
Atdid: 17192 • Atd Number: ATD-4-6705 • Bblid: 671676
Atdid
17192
Atd Number
ATD-4-6705
Bblid
671676
Inspectionid
392797
Inspect Date
2024-04-13T00:00:00.000
Atdissuedate
2025-03-31T13:57:37.000
Cb
5
House Num
69-29
Onstname
66TH PL.
Atddismissed
No
9147
Atdid: 9147 • Atd Number: ATD-4-4174 • Bblid: 695075
Atdid
9147
Atd Number
ATD-4-4174
Bblid
695075
Inspectionid
332730
Inspect Date
2019-09-30T00:00:00.000
Atdissuedate
2022-02-23T15:28:47.000
Cb
7
House Num
151-33
Onstname
29TH AVE.
Atddismissed
No
16272
Atdid: 16272 • Atd Number: ATD-3-6368 • Bblid: 271884
Atdid
16272
Atd Number
ATD-3-6368
Bblid
271884
Inspectionid
384303
Inspect Date
2024-10-22T00:00:00.000
Atdissuedate
2024-10-22T12:24:41.000
Cb
7
House Num
537
Onstname
18TH ST.
Atddismissed
No
16653
Atdid: 16653 • Atd Number: ATD-4-6550 • Bblid: 621075
Atdid
16653
Atd Number
ATD-4-6550
Bblid
621075
Inspectionid
388513
Inspect Date
2024-12-06T00:00:00.000
Atdissuedate
2025-01-07T07:57:52.000
Cb
4
House Num
90-18
Onstname
52ND AVE.
Atddismissed
No
11008
Atdid: 11008 • Atd Number: ATD-3-4360 • Bblid: 264007
Atdid
11008
Atd Number
ATD-3-4360
Bblid
264007
Inspectionid
344562
Inspect Date
2022-09-10T00:00:00.000
Atdissuedate
2022-09-26T11:50:46.000
Cb
7
House Num
177
Onstname
32ND ST.
Atddismissed
No
12031
Atdid: 12031 • Atd Number: ATD-3-4924 • Bblid: 332329
Atdid
12031
Atd Number
ATD-3-4924
Bblid
332329
Inspectionid
355856
Inspect Date
2023-04-14T00:00:00.000
Atdissuedate
2023-04-14T14:39:40.000
Cb
1
House Num
166
Onstname
HEWES ST.
Atddismissed
No
10803
Atdid: 10803 • Atd Number: ATD-3-4179 • Bblid: 332604
Atdid
10803
Atd Number
ATD-3-4179
Bblid
332604
Inspectionid
343018
Inspect Date
2022-08-26T00:00:00.000
Atdissuedate
2022-09-08T11:30:26.000
Cb
1
House Num
280
Onstname
HEWES ST.
Atddismissed
No