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
12136
Atdid: 12136 • Atd Number: ATD-4-5166 • Bblid: 628432
Atdid
12136
Atd Number
ATD-4-5166
Bblid
628432
Inspectionid
356539
Inspect Date
2023-05-02T00:00:00.000
Atdissuedate
2023-05-02T12:25:28.000
Cb
6
House Num
102-38
Onstname
65TH RD.
Atddismissed
No
11740
Atdid: 11740 • Atd Number: ATD-4-5031 • Bblid: 752435
Atdid
11740
Atd Number
ATD-4-5031
Bblid
752435
Inspectionid
352318
Inspect Date
2023-02-24T00:00:00.000
Atdissuedate
2023-03-03T10:40:42.000
Cb
11
House Num
50-31
Onstname
206TH ST.
Atddismissed
No
18474
Atdid: 18474 • Atd Number: ATD-2-1452 • Bblid: 225359
Atdid
18474
Atd Number
ATD-2-1452
Bblid
225359
Inspectionid
405187
Inspect Date
2025-08-25T00:00:00.000
Atdissuedate
2025-09-04T13:45:55.000
Cb
12
House Num
4109
Onstname
BAYCHESTER AVE.
Atddismissed
No
17051
Atdid: 17051 • Atd Number: ATD-3-6710 • Bblid: 251269
Atdid
17051
Atd Number
ATD-3-6710
Bblid
251269
Inspectionid
392379
Inspect Date
2023-06-01T00:00:00.000
Atdissuedate
2025-03-27T09:08:21.000
Cb
2
House Num
209
Onstname
BERGEN ST.
Atddismissed
No
13559
Atdid: 13559 • Atd Number: ATD-2-1246 • Bblid: 176355
Atdid
13559
Atd Number
ATD-2-1246
Bblid
176355
Inspectionid
365086
Inspect Date
2023-09-01T00:00:00.000
Atdissuedate
2023-10-10T12:14:32.000
Cb
9
House Num
1166
Onstname
CROES AVE.
Atddismissed
No
12314
Atdid: 12314 • Atd Number: ATD-2-1111 • Bblid: 153636
Atdid
12314
Atd Number
ATD-2-1111
Bblid
153636
Inspectionid
357365
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T12:21:51.000
Cb
5
House Num
50
Onstname
W. BURNSIDE AVE.
Atddismissed
No
12447
Atdid: 12447 • Atd Number: ATD-3-5058 • Bblid: 526181
Atdid
12447
Atd Number
ATD-3-5058
Bblid
526181
Inspectionid
357860
Inspect Date
2023-05-06T00:00:00.000
Atdissuedate
2023-05-30T12:42:47.000
Cb
18
House Num
1147
Onstname
E. 59TH ST.
Atddismissed
No
13589
Atdid: 13589 • Atd Number: ATD-3-5598 • Bblid: 508067
Atdid
13589
Atd Number
ATD-3-5598
Bblid
508067
Inspectionid
365401
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-10-16T13:16:13.000
Cb
15
House Num
2243
Onstname
E. 29TH ST.
Atddismissed
No
13404
Atdid: 13404 • Atd Number: ATD-4-5525 • Bblid: 655710
Atdid
13404
Atd Number
ATD-4-5525
Bblid
655710
Inspectionid
363426
Inspect Date
2023-09-13T00:00:00.000
Atdissuedate
2023-09-13T10:43:42.000
Cb
6
House Num
66-52
Onstname
SAUNDERS ST.
Atddismissed
No
11714
Atdid: 11714 • Atd Number: ATD-3-4758 • Bblid: 452200
Atdid
11714
Atd Number
ATD-3-4758
Bblid
452200
Inspectionid
352046
Inspect Date
2023-02-24T00:00:00.000
Atdissuedate
2023-02-27T09:57:31.000
Cb
10
House Num
648A
Onstname
88TH ST.
Atddismissed
No
17259
Atdid: 17259 • Atd Number: ATD-4-6739 • Bblid: 861899
Atdid
17259
Atd Number
ATD-4-6739
Bblid
861899
Inspectionid
393249
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-04T14:39:39.000
Cb
12
House Num
114-29
Onstname
148TH ST.
Atddismissed
No
6733
Atdid: 6733 • Atd Number: ATD-4-3094 • Bblid: 771842
Atdid
6733
Atd Number
ATD-4-3094
Bblid
771842
Violationid
252983
Atdissuedate
2020-06-23T00:00:00.000
Cb
13
House Num
254-16
Onstname
87 ROAD
Atddismissed
Yes
Atddismissedon
2022-07-18T13:59:54.000
14049
Atdid: 14049 • Atd Number: ATD-4-5859 • Bblid: 639040
Atdid
14049
Atd Number
ATD-4-5859
Bblid
639040
Inspectionid
372635
Inspect Date
2024-03-01T00:00:00.000
Atdissuedate
2024-03-01T14:02:22.000
Cb
5
House Num
59-67
Onstname
58TH RD.
Atddismissed
No
12516
Atdid: 12516 • Atd Number: ATD-4-5339 • Bblid: 830214
Atdid
12516
Atd Number
ATD-4-5339
Bblid
830214
Inspectionid
358175
Inspect Date
2023-05-12T00:00:00.000
Atdissuedate
2023-06-05T15:07:03.000
Cb
13
House Num
222-34
Onstname
93RD AVE.
Atddismissed
No
18504
Atdid: 18504 • Atd Number: ATD-2-1464 • Bblid: 202325
Atdid
18504
Atd Number
ATD-2-1464
Bblid
202325
Inspectionid
405289
Inspect Date
2025-09-05T00:00:00.000
Atdissuedate
2025-09-05T16:31:40.000
Cb
11
House Num
1913
Onstname
NARRAGANSETT AVE.
Atddismissed
No
11265
Atdid: 11265 • Atd Number: ATD-3-4571 • Bblid: 555287
Atdid
11265
Atd Number
ATD-3-4571
Bblid
555287
Inspectionid
346962
Inspect Date
2022-09-30T00:00:00.000
Atdissuedate
2022-10-25T11:09:55.000
Cb
18
House Num
325
Onstname
ARKANSAS DR.
Atddismissed
No
13504
Atdid: 13504 • Atd Number: ATD-4-5556 • Bblid: 610354
Atdid
13504
Atd Number
ATD-4-5556
Bblid
610354
Inspectionid
364570
Inspect Date
2023-09-27T00:00:00.000
Atdissuedate
2023-09-28T12:35:59.000
Cb
4
House Num
41-18
Onstname
JUDGE ST.
Atddismissed
No
17168
Atdid: 17168 • Atd Number: ATD-3-6801 • Bblid: 332817
Atdid
17168
Atd Number
ATD-3-6801
Bblid
332817
Inspectionid
392681
Inspect Date
2025-03-25T00:00:00.000
Atdissuedate
2025-03-31T11:04:58.000
Cb
1
House Num
281
Onstname
RUTLEDGE ST.
Atddismissed
No
11210
Atdid: 11210 • Atd Number: ATD-4-4847 • Bblid: 660275
Atdid
11210
Atd Number
ATD-4-4847
Bblid
660275
Inspectionid
346442
Inspect Date
2022-10-14T00:00:00.000
Atdissuedate
2022-10-19T11:16:35.000
Cb
6
House Num
111-24
Onstname
75TH AVE.
Atddismissed
No
13948
Atdid: 13948 • Atd Number: ATD-2-1258 • Bblid: 139032
Atdid
13948
Atd Number
ATD-2-1258
Bblid
139032
Inspectionid
371583
Inspect Date
2024-02-08T00:00:00.000
Atdissuedate
2024-02-14T10:15:01.000
Cb
1
House Num
522
Onstname
E. 139TH ST.
Atddismissed
No
9183
Atdid: 9183 • Atd Number: ATD-4-4190 • Bblid: 721490
Atdid
9183
Atd Number
ATD-4-4190
Bblid
721490
Inspectionid
332841
Inspect Date
2019-08-19T00:00:00.000
Atdissuedate
2022-02-28T16:34:41.000
Cb
7
House Num
23-35
Onstname
206TH ST.
Atddismissed
No
8753
Atdid: 8753 • Atd Number: ATD-4-3949 • Bblid: 769331
Atdid
8753
Atd Number
ATD-4-3949
Bblid
769331
Inspectionid
331108
Inspect Date
2021-10-14T00:00:00.000
Atdissuedate
2021-12-28T13:56:37.000
Cb
13
House Num
77-11
Onstname
269TH ST.
Atddismissed
No
11763
Atdid: 11763 • Atd Number: ATD-4-5033 • Bblid: 827723
Atdid
11763
Atd Number
ATD-4-5033
Bblid
827723
Inspectionid
352617
Inspect Date
2021-03-17T00:00:00.000
Atdissuedate
2023-03-10T11:57:20.000
Cb
13
House Num
89-13
Onstname
212TH ST.
Atddismissed
No
9175
Atdid: 9175 • Atd Number: ATD-5-613 • Bblid: 1028686
Atdid
9175
Atd Number
ATD-5-613
Bblid
1028686
Inspectionid
332798
Inspect Date
2022-02-26T00:00:00.000
Atdissuedate
2022-02-26T14:46:06.000
Cb
3
House Num
248
Onstname
ANNADALE RD.
Atddismissed
No
17076
Atdid: 17076 • Atd Number: ATD-3-6727 • Bblid: 517255
Atdid
17076
Atd Number
ATD-3-6727
Bblid
517255
Inspectionid
392437
Inspect Date
2025-03-26T00:00:00.000
Atdissuedate
2025-03-27T13:46:15.000
Cb
14
House Num
2715
Onstname
AVENUE M.
Atddismissed
No
12309
Atdid: 12309 • Atd Number: ATD-2-1106 • Bblid: 153866
Atdid
12309
Atd Number
ATD-2-1106
Bblid
153866
Inspectionid
357360
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T12:16:58.000
Cb
5
House Num
1731
Onstname
HARRISON AVE.
Atddismissed
No
17114
Atdid: 17114 • Atd Number: ATD-3-6760 • Bblid: 443889
Atdid
17114
Atd Number
ATD-3-6760
Bblid
443889
Inspectionid
392512
Inspect Date
2021-05-26T00:00:00.000
Atdissuedate
2025-03-28T14:07:51.000
Cb
10
House Num
371
Onstname
72ND ST.
Atddismissed
No
11441
Atdid: 11441 • Atd Number: ATD-1-257 • Bblid: 22141
Atdid
11441
Atd Number
ATD-1-257
Bblid
22141
Inspectionid
348533
Inspect Date
2022-11-10T00:00:00.000
Atdissuedate
2022-11-22T12:52:50.000
Cb
2
House Num
12
Onstname
BEDFORD ST.
Atddismissed
No
9827
Atdid: 9827 • Atd Number: ATD-4-4448 • Bblid: 589471
Atdid
9827
Atd Number
ATD-4-4448
Bblid
589471
Inspectionid
334580
Inspect Date
2020-11-20T00:00:00.000
Atdissuedate
2022-04-05T10:01:41.000
Cb
1
House Num
23-74
Onstname
26TH ST.
Atddismissed
No
11579
Atdid: 11579 • Atd Number: ATD-4-4946 • Bblid: 759842
Atdid
11579
Atd Number
ATD-4-4946
Bblid
759842
Inspectionid
350084
Inspect Date
2023-01-04T00:00:00.000
Atdissuedate
2023-01-06T10:59:22.000
Cb
13
House Num
82-34
Onstname
243RD ST.
Atddismissed
No
10579
Atdid: 10579 • Atd Number: ATD-4-4763 • Bblid: 743317
Atdid
10579
Atd Number
ATD-4-4763
Bblid
743317
Inspectionid
340586
Inspect Date
2022-07-29T00:00:00.000
Atdissuedate
2022-07-29T12:44:29.000
Cb
8
House Num
69-05
Onstname
173RD ST.
Atddismissed
Yes
Atddismissedon
2022-07-29T12:45:29.000
10645
Atdid: 10645 • Atd Number: ATD-3-4047 • Bblid: 554857
Atdid
10645
Atd Number
ATD-3-4047
Bblid
554857
Inspectionid
341451
Inspect Date
2022-08-13T00:00:00.000
Atdissuedate
2022-08-13T14:15:30.000
Cb
18
House Num
2769
Onstname
E. 65TH ST.
Atddismissed
No
10671
Atdid: 10671 • Atd Number: ATD-3-4069 • Bblid: 275700
Atdid
10671
Atd Number
ATD-3-4069
Bblid
275700
Inspectionid
341797
Inspect Date
2022-04-28T00:00:00.000
Atdissuedate
2022-08-22T09:31:06.000
Cb
6
House Num
154
Onstname
BERKELEY PL.
Atddismissed
No
16577
Atdid: 16577 • Atd Number: ATD-3-6507 • Bblid: 297874
Atdid
16577
Atd Number
ATD-3-6507
Bblid
297874
Inspectionid
387006
Inspect Date
2024-12-19T00:00:00.000
Atdissuedate
2024-12-20T10:49:30.000
Cb
8
House Num
264
Onstname
SCHENECTADY AVE.
Atddismissed
No
17690
Atdid: 17690 • Atd Number: ATD-4-6946 • Bblid: 909916
Atdid
17690
Atd Number
ATD-4-6946
Bblid
909916
Inspectionid
397794
Inspect Date
2025-05-12T00:00:00.000
Atdissuedate
2025-05-20T12:31:19.000
Cb
14
House Num
29-52
Onstname
OCEANCREST BLVD.
Atddismissed
No
10069
Atdid: 10069 • Atd Number: ATD-3-3689 • Bblid: 407437
Atdid
10069
Atd Number
ATD-3-3689
Bblid
407437
Inspectionid
336339
Inspect Date
2022-05-09T00:00:00.000
Atdissuedate
2022-05-11T12:32:04.000
Cb
9
House Num
282
Onstname
MIDWOOD ST.
Atddismissed
No
16346
Atdid: 16346 • Atd Number: ATD-4-6417 • Bblid: 611117
Atdid
16346
Atd Number
ATD-4-6417
Bblid
611117
Inspectionid
384871
Inspect Date
2024-10-11T00:00:00.000
Atdissuedate
2024-11-06T14:40:48.000
Cb
4
House Num
42-42
Onstname
77TH ST.
Atddismissed
No
11349
Atdid: 11349 • Atd Number: ATD-3-4623 • Bblid: 282827
Atdid
11349
Atd Number
ATD-3-4623
Bblid
282827
Inspectionid
347725
Inspect Date
2022-11-02T00:00:00.000
Atdissuedate
2022-11-07T11:41:27.000
Cb
6
House Num
480
Onstname
7TH ST.
Atddismissed
No
18406
Atdid: 18406 • Atd Number: ATD-3-7257 • Bblid: 517837
Atdid
18406
Atd Number
ATD-3-7257
Bblid
517837
Inspectionid
404678
Inspect Date
2025-08-22T00:00:00.000
Atdissuedate
2025-08-22T11:17:28.000
Cb
14
House Num
1361
Onstname
E. 23RD ST.
Atddismissed
No
16186
Atdid: 16186 • Atd Number: ATD-3-6331 • Bblid: 479958
Atdid
16186
Atd Number
ATD-3-6331
Bblid
479958
Inspectionid
383718
Inspect Date
2024-10-01T00:00:00.000
Atdissuedate
2024-10-03T13:25:23.000
Cb
14
House Num
815
Onstname
E. 12TH ST.
Atddismissed
No
10437
Atdid: 10437 • Atd Number: ATD-3-3921 • Bblid: 310207
Atdid
10437
Atd Number
ATD-3-3921
Bblid
310207
Inspectionid
339273
Inspect Date
2022-07-12T00:00:00.000
Atdissuedate
2022-07-12T14:32:58.000
Cb
3
House Num
583A
Onstname
MACON ST.
Atddismissed
No
13122
Atdid: 13122 • Atd Number: ATD-2-1209 • Bblid: 208329
Atdid
13122
Atd Number
ATD-2-1209
Bblid
208329
Inspectionid
361461
Inspect Date
2023-07-31T00:00:00.000
Atdissuedate
2023-08-03T12:19:40.000
Cb
11
House Num
2737
Onstname
FISH AVE.
Atddismissed
No
17496
Atdid: 17496 • Atd Number: ATD-3-6934 • Bblid: 471975
Atdid
17496
Atd Number
ATD-3-6934
Bblid
471975
Inspectionid
395843
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-02T12:13:26.000
Cb
12
House Num
1215
Onstname
E. 8TH ST.
Atddismissed
No
18503
Atdid: 18503 • Atd Number: ATD-2-1463 • Bblid: 202301
Atdid
18503
Atd Number
ATD-2-1463
Bblid
202301
Inspectionid
405286
Inspect Date
2025-09-05T00:00:00.000
Atdissuedate
2025-09-05T16:19:46.000
Cb
11
House Num
1937
Onstname
NARRAGANSETT AVE.
Atddismissed
No
18616
Atdid: 18616 • Atd Number: ATD-4-7378 • Bblid: 798831
Atdid
18616
Atd Number
ATD-4-7378
Bblid
798831
Inspectionid
406046
Inspect Date
2025-09-12T00:00:00.000
Atdissuedate
2025-09-18T11:58:02.000
Cb
10
House Num
104-44
Onstname
106TH ST.
Atddismissed
No
17925
Atdid: 17925 • Atd Number: ATD-5-986 • Bblid: 1028656
Atdid
17925
Atd Number
ATD-5-986
Bblid
1028656
Inspectionid
400645
Inspect Date
2025-04-28T00:00:00.000
Atdissuedate
2025-06-20T12:08:52.000
Cb
3
House Num
46
Onstname
LUDLOW ST.
Atddismissed
Yes
Atddismissedon
2025-09-11T11:56:34.000
17740
Atdid: 17740 • Atd Number: ATD-3-7007 • Bblid: 507908
Atdid
17740
Atd Number
ATD-3-7007
Bblid
507908
Inspectionid
398572
Inspect Date
2023-07-27T00:00:00.000
Atdissuedate
2025-05-27T11:07:07.000
Cb
15
House Num
2244
Onstname
E. 29TH ST.
Atddismissed
No
630
Atdid: 630 • Atd Number: ATD-2-497 • Bblid: 208812
Atdid
630
Atd Number
ATD-2-497
Bblid
208812
Violationid
247672
Atdissuedate
2019-11-16T00:00:00.000
Cb
12
House Num
3020
Onstname
BRONX PARK EAST
Atddismissed
Yes
Atddismissedon
2021-12-07T13:47:58.000
10394
Atdid: 10394 • Atd Number: ATD-4-4701 • Bblid: 650889
Atdid
10394
Atd Number
ATD-4-4701
Bblid
650889
Inspectionid
338834
Inspect Date
2022-07-07T00:00:00.000
Atdissuedate
2022-07-07T10:06:48.000
Cb
5
House Num
65-05
Onstname
77TH ST.
Atddismissed
Yes
Atddismissedon
2022-07-07T10:07:16.000
13693
Atdid: 13693 • Atd Number: ATD-2-1252 • Bblid: 152068
Atdid
13693
Atd Number
ATD-2-1252
Bblid
152068
Inspectionid
367609
Inspect Date
2023-10-31T00:00:00.000
Atdissuedate
2023-11-16T10:59:32.000
Cb
4
House Num
1345
Onstname
CLAY AVE.
Atddismissed
No