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
18622
Atdid: 18622 • Atd Number: ATD-4-7384 • Bblid: 786778
Atdid
18622
Atd Number
ATD-4-7384
Bblid
786778
Inspectionid
406092
Inspect Date
2025-09-15T00:00:00.000
Atdissuedate
2025-09-18T13:16:33.000
Cb
10
House Num
107-16
Onstname
92ND ST.
Atddismissed
No
9240
Atdid: 9240 • Atd Number: ATD-3-3375 • Bblid: 469365
Atdid
9240
Atd Number
ATD-3-3375
Bblid
469365
Inspectionid
332946
Inspect Date
2021-01-13T00:00:00.000
Atdissuedate
2022-03-01T17:19:19.000
Cb
11
House Num
263
Onstname
BAY 14TH ST.
Atddismissed
No
9064
Atdid: 9064 • Atd Number: ATD-4-4114 • Bblid: 584369
Atdid
9064
Atd Number
ATD-4-4114
Bblid
584369
Inspectionid
332575
Inspect Date
2019-06-05T00:00:00.000
Atdissuedate
2022-02-18T15:36:23.000
Cb
1
House Num
20-71
Onstname
47TH ST.
Atddismissed
No
17964
Atdid: 17964 • Atd Number: ATD-3-7076 • Bblid: 480162
Atdid
17964
Atd Number
ATD-3-7076
Bblid
480162
Inspectionid
400837
Inspect Date
2025-06-13T00:00:00.000
Atdissuedate
2025-06-24T12:11:10.000
Cb
14
House Num
887
Onstname
E. 15TH ST.
Atddismissed
No
14005
Atdid: 14005 • Atd Number: ATD-3-5744 • Bblid: 367749
Atdid
14005
Atd Number
ATD-3-5744
Bblid
367749
Inspectionid
372150
Inspect Date
2023-12-14T00:00:00.000
Atdissuedate
2024-02-26T09:52:23.000
Cb
5
House Num
70
Onstname
WILLIAMS AVE.
Atddismissed
No
14963
Atdid: 14963 • Atd Number: ATD-4-6246 • Bblid: 682926
Atdid
14963
Atd Number
ATD-4-6246
Bblid
682926
Inspectionid
381066
Inspect Date
2024-08-24T00:00:00.000
Atdissuedate
2024-08-26T13:00:30.000
Cb
7
House Num
14-37
Onstname
131ST ST.
Atddismissed
No
14991
Atdid: 14991 • Atd Number: ATD-3-6238 • Bblid: 404688
Atdid
14991
Atd Number
ATD-3-6238
Bblid
404688
Inspectionid
381412
Inspect Date
2024-08-20T00:00:00.000
Atdissuedate
2024-09-05T11:49:02.000
Cb
17
House Num
3702
Onstname
AVENUE D.
Atddismissed
No
16375
Atdid: 16375 • Atd Number: ATD-3-6414 • Bblid: 328434
Atdid
16375
Atd Number
ATD-3-6414
Bblid
328434
Inspectionid
385063
Inspect Date
2024-11-08T00:00:00.000
Atdissuedate
2024-11-15T10:08:17.000
Cb
2
House Num
56
Onstname
SAINT FELIX ST.
Atddismissed
No
9776
Atdid: 9776 • Atd Number: ATD-5-652 • Bblid: 933604
Atdid
9776
Atd Number
ATD-5-652
Bblid
933604
Inspectionid
334369
Inspect Date
2012-09-29T00:00:00.000
Atdissuedate
2022-03-29T18:12:34.000
Cb
1
House Num
166
Onstname
SLOSSON AVE.
Atddismissed
No
16909
Atdid: 16909 • Atd Number: ATD-5-931 • Bblid: 924989
Atdid
16909
Atd Number
ATD-5-931
Bblid
924989
Inspectionid
390947
Inspect Date
2025-03-11T00:00:00.000
Atdissuedate
2025-03-12T08:42:58.000
Cb
1
House Num
103
Onstname
STANLEY AVE.
Atddismissed
No
13267
Atdid: 13267 • Atd Number: ATD-3-5438 • Bblid: 422888
Atdid
13267
Atd Number
ATD-3-5438
Bblid
422888
Inspectionid
362103
Inspect Date
2023-08-17T00:00:00.000
Atdissuedate
2023-08-17T10:09:50.000
Cb
12
House Num
01675
Onstname
47 STREET
Atddismissed
No
17315
Atdid: 17315 • Atd Number: ATD-3-6853 • Bblid: 301839
Atdid
17315
Atd Number
ATD-3-6853
Bblid
301839
Inspectionid
394402
Inspect Date
2025-03-28T00:00:00.000
Atdissuedate
2025-04-14T07:47:47.000
Cb
3
House Num
594
Onstname
MACDONOUGH ST.
Atddismissed
No
9010
Atdid: 9010 • Atd Number: ATD-3-3292 • Bblid: 302063
Atdid
9010
Atd Number
ATD-3-3292
Bblid
302063
Inspectionid
332352
Inspect Date
2019-08-20T00:00:00.000
Atdissuedate
2022-02-10T09:13:02.000
Cb
3
House Num
605
Onstname
DECATUR ST.
Atddismissed
No
13218
Atdid: 13218 • Atd Number: ATD-3-5389 • Bblid: 422653
Atdid
13218
Atd Number
ATD-3-5389
Bblid
422653
Inspectionid
362038
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T15:25:39.000
Cb
12
House Num
1761
Onstname
46TH ST.
Atddismissed
No
17595
Atdid: 17595 • Atd Number: ATD-3-6969 • Bblid: 471412
Atdid
17595
Atd Number
ATD-3-6969
Bblid
471412
Inspectionid
397036
Inspect Date
2025-05-08T00:00:00.000
Atdissuedate
2025-05-14T13:24:23.000
Cb
12
House Num
402
Onstname
AVENUE L.
Atddismissed
No
14692
Atdid: 14692 • Atd Number: ATD-4-6119 • Bblid: 683239
Atdid
14692
Atd Number
ATD-4-6119
Bblid
683239
Inspectionid
379069
Inspect Date
2024-06-26T00:00:00.000
Atdissuedate
2024-07-08T10:02:35.000
Cb
7
House Num
14-54
Onstname
143RD ST.
Atddismissed
No
16579
Atdid: 16579 • Atd Number: ATD-4-6504 • Bblid: 574970
Atdid
16579
Atd Number
ATD-4-6504
Bblid
574970
Inspectionid
387009
Inspect Date
2024-12-05T00:00:00.000
Atdissuedate
2024-12-20T11:32:26.000
Cb
1
House Num
33-26
Onstname
14TH ST.
Atddismissed
No
17961
Atdid: 17961 • Atd Number: ATD-3-7074 • Bblid: 480186
Atdid
17961
Atd Number
ATD-3-7074
Bblid
480186
Inspectionid
400823
Inspect Date
2025-06-13T00:00:00.000
Atdissuedate
2025-06-24T11:51:55.000
Cb
14
House Num
861
Onstname
E. 15TH ST.
Atddismissed
No
13146
Atdid: 13146 • Atd Number: ATD-3-5347 • Bblid: 294557
Atdid
13146
Atd Number
ATD-3-5347
Bblid
294557
Inspectionid
361564
Inspect Date
2023-07-15T00:00:00.000
Atdissuedate
2023-08-07T08:54:43.000
Cb
9
House Num
145
Onstname
LEFFERTS AVE.
Atddismissed
No
13792
Atdid: 13792 • Atd Number: ATD-4-5689 • Bblid: 874821
Atdid
13792
Atd Number
ATD-4-5689
Bblid
874821
Inspectionid
369926
Inspect Date
2023-11-30T00:00:00.000
Atdissuedate
2023-12-19T14:10:46.000
Cb
12
House Num
176-17
Onstname
130TH AVE.
Atddismissed
No
11173
Atdid: 11173 • Atd Number: ATD-3-4491 • Bblid: 366278
Atdid
11173
Atd Number
ATD-3-4491
Bblid
366278
Inspectionid
346075
Inspect Date
2022-10-13T00:00:00.000
Atdissuedate
2022-10-17T09:28:20.000
Cb
16
House Num
494
Onstname
WATKINS ST.
Atddismissed
No
9583
Atdid: 9583 • Atd Number: ATD-5-634 • Bblid: 1047865
Atdid
9583
Atd Number
ATD-5-634
Bblid
1047865
Inspectionid
333695
Inspect Date
2019-07-16T00:00:00.000
Atdissuedate
2022-03-11T17:11:33.000
Cb
3
House Num
45
Onstname
CLAYPIT RD.
Atddismissed
No
13690
Atdid: 13690 • Atd Number: ATD-3-5647 • Bblid: 332184
Atdid
13690
Atd Number
ATD-3-5647
Bblid
332184
Inspectionid
367558
Inspect Date
2023-10-24T00:00:00.000
Atdissuedate
2023-11-16T08:38:48.000
Cb
1
House Num
197
Onstname
HOOPER ST.
Atddismissed
No
8887
Atdid: 8887 • Atd Number: ATD-3-3245 • Bblid: 277857
Atdid
8887
Atd Number
ATD-3-3245
Bblid
277857
Inspectionid
331988
Inspect Date
2021-12-06T00:00:00.000
Atdissuedate
2022-01-26T11:33:01.000
Cb
6
House Num
463
Onstname
5TH ST.
Atddismissed
Yes
Atddismissedon
2022-05-24T09:26:31.000
10201
Atdid: 10201 • Atd Number: ATD-4-4625 • Bblid: 656524
Atdid
10201
Atd Number
ATD-4-4625
Bblid
656524
Inspectionid
337183
Inspect Date
2022-05-17T00:00:00.000
Atdissuedate
2022-06-02T13:20:58.000
Cb
6
House Num
68-44
Onstname
SELFRIDGE ST.
Atddismissed
No
18390
Atdid: 18390 • Atd Number: ATD-4-7281 • Bblid: 783138
Atdid
18390
Atd Number
ATD-4-7281
Bblid
783138
Inspectionid
404607
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-08-21T12:50:42.000
Cb
9
House Num
96-06
Onstname
95TH AVE.
Atddismissed
No
14426
Atdid: 14426 • Atd Number: ATD-3-5960 • Bblid: 277723
Atdid
14426
Atd Number
ATD-3-5960
Bblid
277723
Inspectionid
377052
Inspect Date
2024-04-16T00:00:00.000
Atdissuedate
2024-05-08T12:52:27.000
Cb
6
House Num
381
Onstname
5TH ST.
Atddismissed
No
18495
Atdid: 18495 • Atd Number: ATD-4-7328 • Bblid: 884049
Atdid
18495
Atd Number
ATD-4-7328
Bblid
884049
Inspectionid
405244
Inspect Date
2025-03-16T00:00:00.000
Atdissuedate
2025-09-04T17:05:54.000
Cb
13
House Num
131-19
Onstname
233RD ST.
Atddismissed
No
17250
Atdid: 17250 • Atd Number: ATD-4-6732 • Bblid: 709707
Atdid
17250
Atd Number
ATD-4-6732
Bblid
709707
Inspectionid
393168
Inspect Date
2025-04-03T00:00:00.000
Atdissuedate
2025-04-04T11:07:02.000
Cb
7
House Num
33-17
Onstname
172ND ST.
Atddismissed
No
11672
Atdid: 11672 • Atd Number: ATD-4-4995 • Bblid: 725966
Atdid
11672
Atd Number
ATD-4-4995
Bblid
725966
Inspectionid
351639
Inspect Date
2023-02-15T00:00:00.000
Atdissuedate
2023-02-16T11:20:52.000
Cb
11
House Num
32-42
Onstname
204TH ST.
Atddismissed
No
11303
Atdid: 11303 • Atd Number: ATD-3-4592 • Bblid: 278623
Atdid
11303
Atd Number
ATD-3-4592
Bblid
278623
Inspectionid
347294
Inspect Date
2022-10-28T00:00:00.000
Atdissuedate
2022-11-01T10:06:06.000
Cb
6
House Num
327
Onstname
8TH ST.
Atddismissed
No
11064
Atdid: 11064 • Atd Number: ATD-3-4412 • Bblid: 464168
Atdid
11064
Atd Number
ATD-3-4412
Bblid
464168
Inspectionid
344974
Inspect Date
2022-09-30T00:00:00.000
Atdissuedate
2022-09-30T17:27:09.000
Cb
11
House Num
2253
Onstname
84TH ST.
Atddismissed
No
13917
Atdid: 13917 • Atd Number: ATD-4-5773 • Bblid: 657109
Atdid
13917
Atd Number
ATD-4-5773
Bblid
657109
Inspectionid
371249
Inspect Date
2023-12-18T00:00:00.000
Atdissuedate
2024-02-01T13:51:03.000
Cb
6
House Num
72-55
Onstname
YELLOWSTONE BLVD.
Atddismissed
No
14298
Atdid: 14298 • Atd Number: ATD-4-5963 • Bblid: 742745
Atdid
14298
Atd Number
ATD-4-5963
Bblid
742745
Inspectionid
375548
Inspect Date
2024-03-13T00:00:00.000
Atdissuedate
2024-04-17T12:17:25.000
Cb
8
House Num
65-44
Onstname
169TH ST.
Atddismissed
No
11490
Atdid: 11490 • Atd Number: ATD-3-4690 • Bblid: 257599
Atdid
11490
Atd Number
ATD-3-4690
Bblid
257599
Inspectionid
349143
Inspect Date
2022-11-29T00:00:00.000
Atdissuedate
2022-12-12T12:49:35.000
Cb
6
House Num
78
Onstname
3RD PL.
Atddismissed
No
17991
Atdid: 17991 • Atd Number: ATD-4-7107 • Bblid: 766283
Atdid
17991
Atd Number
ATD-4-7107
Bblid
766283
Inspectionid
401593
Inspect Date
2025-06-18T00:00:00.000
Atdissuedate
2025-06-27T11:34:38.000
Cb
11
House Num
54-05
Onstname
253 STREET
Atddismissed
No
17063
Atdid: 17063 • Atd Number: ATD-4-6686 • Bblid: 799429
Atdid
17063
Atd Number
ATD-4-6686
Bblid
799429
Inspectionid
392402
Inspect Date
2025-03-27T00:00:00.000
Atdissuedate
2025-03-27T11:19:25.000
Cb
10
House Num
100-09
Onstname
133RD AVE.
Atddismissed
No
16507
Atdid: 16507 • Atd Number: ATD-5-899 • Bblid: 989816
Atdid
16507
Atd Number
ATD-5-899
Bblid
989816
Inspectionid
386050
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2024-12-12T09:59:03.000
Cb
2
House Num
31
Onstname
ATLANTIC AVE.
Atddismissed
No
16659
Atdid: 16659 • Atd Number: ATD-3-6527 • Bblid: 515908
Atdid
16659
Atd Number
ATD-3-6527
Bblid
515908
Inspectionid
388539
Inspect Date
2024-11-15T00:00:00.000
Atdissuedate
2025-01-08T10:07:45.000
Cb
18
House Num
1204
Onstname
E. 38TH ST.
Atddismissed
No
13972
Atdid: 13972 • Atd Number: ATD-4-5803 • Bblid: 577333
Atdid
13972
Atd Number
ATD-4-5803
Bblid
577333
Inspectionid
371839
Inspect Date
2024-02-16T00:00:00.000
Atdissuedate
2024-02-16T10:56:11.000
Cb
1
House Num
32-28
Onstname
30TH ST.
Atddismissed
No
18129
Atdid: 18129 • Atd Number: ATD-3-7142 • Bblid: 516164
Atdid
18129
Atd Number
ATD-3-7142
Bblid
516164
Inspectionid
402708
Inspect Date
2025-07-12T00:00:00.000
Atdissuedate
2025-07-18T15:39:32.000
Cb
14
House Num
1141
Onstname
E. 28TH ST.
Atddismissed
No
14415
Atdid: 14415 • Atd Number: ATD-4-6022 • Bblid: 814175
Atdid
14415
Atd Number
ATD-4-6022
Bblid
814175
Inspectionid
377034
Inspect Date
2024-05-01T00:00:00.000
Atdissuedate
2024-05-08T12:32:29.000
Cb
12
House Num
106-30A
Onstname
GUY R. BREWER BLVD.
Atddismissed
No
13013
Atdid: 13013 • Atd Number: ATD-4-5475 • Bblid: 897558
Atdid
13013
Atd Number
ATD-4-5475
Bblid
897558
Inspectionid
360924
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T09:37:07.000
Cb
13
House Num
259-48
Onstname
148TH AVE.
Atddismissed
No
14055
Atdid: 14055 • Atd Number: ATD-4-5864 • Bblid: 894180
Atdid
14055
Atd Number
ATD-4-5864
Bblid
894180
Inspectionid
372671
Inspect Date
2024-02-28T00:00:00.000
Atdissuedate
2024-03-04T08:47:48.000
Cb
13
House Num
240-03
Onstname
CANEY RD.
Atddismissed
No
8972
Atdid: 8972 • Atd Number: ATD-4-4071 • Bblid: 898798
Atdid
8972
Atd Number
ATD-4-4071
Bblid
898798
Inspectionid
332273
Inspect Date
2019-06-25T00:00:00.000
Atdissuedate
2022-02-07T10:30:45.000
Cb
13
House Num
147-76
Onstname
HUXLEY ST.
Atddismissed
No
11555
Atdid: 11555 • Atd Number: ATD-1-276 • Bblid: 47237
Atdid
11555
Atd Number
ATD-1-276
Bblid
47237
Inspectionid
349787
Inspect Date
2022-12-28T00:00:00.000
Atdissuedate
2022-12-28T12:46:13.000
Cb
6
House Num
343
Onstname
E. 18TH ST.
Atddismissed
No
2860
Atdid: 2860 • Atd Number: ATD-3-2003 • Bblid: 264005
Atdid
2860
Atd Number
ATD-3-2003
Bblid
264005
Violationid
192520
Atdissuedate
2020-08-17T00:00:00.000
Cb
7
House Num
179
Onstname
32 STREET
Atddismissed
Yes
Atddismissedon
2022-09-19T13:13:53.000
18522
Atdid: 18522 • Atd Number: ATD-3-7299 • Bblid: 378415
Atdid
18522
Atd Number
ATD-3-7299
Bblid
378415
Inspectionid
405406
Inspect Date
2025-08-29T00:00:00.000
Atdissuedate
2025-09-08T10:21:15.000
Cb
5
House Num
644
Onstname
BARBEY ST.
Atddismissed
No
12188
Atdid: 12188 • Atd Number: ATD-2-1040 • Bblid: 166806
Atdid
12188
Atd Number
ATD-2-1040
Bblid
166806
Inspectionid
356830
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2023-05-09T14:11:27.000
Cb
7
House Num
2676
Onstname
GRAND CONCOURSE
Atddismissed
No
13078
Atdid: 13078 • Atd Number: ATD-3-5309 • Bblid: 509072
Atdid
13078
Atd Number
ATD-3-5309
Bblid
509072
Inspectionid
361187
Inspect Date
2023-07-27T00:00:00.000
Atdissuedate
2023-08-01T12:01:47.000
Cb
15
House Num
2334
Onstname
E. 24TH ST.
Atddismissed
No