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
16945
Atdid: 16945 • Atd Number: ATD-2-1342 • Bblid: 240402
Atdid
16945
Atd Number
ATD-2-1342
Bblid
240402
Inspectionid
391458
Inspect Date
2025-03-12T00:00:00.000
Atdissuedate
2025-03-17T10:33:14.000
Cb
10
House Num
2600
Onstname
MILES AVE.
Atddismissed
No
12520
Atdid: 12520 • Atd Number: ATD-3-5063 • Bblid: 444751
Atdid
12520
Atd Number
ATD-3-5063
Bblid
444751
Inspectionid
358201
Inspect Date
2023-06-01T00:00:00.000
Atdissuedate
2023-06-05T16:10:54.000
Cb
10
House Num
331
Onstname
73RD ST.
Atddismissed
No
11383
Atdid: 11383 • Atd Number: ATD-3-4634 • Bblid: 260048
Atdid
11383
Atd Number
ATD-3-4634
Bblid
260048
Inspectionid
348055
Inspect Date
2022-11-09T00:00:00.000
Atdissuedate
2022-11-14T09:39:34.000
Cb
6
House Num
388
Onstname
UNION ST.
Atddismissed
No
9305
Atdid: 9305 • Atd Number: ATD-3-3409 • Bblid: 418348
Atdid
9305
Atd Number
ATD-3-3409
Bblid
418348
Inspectionid
333011
Inspect Date
2019-02-22T00:00:00.000
Atdissuedate
2022-03-02T08:46:45.000
Cb
12
House Num
307
Onstname
E. 4TH ST.
Atddismissed
No
10952
Atdid: 10952 • Atd Number: ATD-3-4311 • Bblid: 482864
Atdid
10952
Atd Number
ATD-3-4311
Bblid
482864
Violationid
265885
Reinspectionid
32926
Inspect Date
2022-09-20T14:55:14.000
Atdissuedate
2022-09-20T14:55:14.000
Cb
14
House Num
1552
Onstname
EAST 16 STREET
Atddismissed
No
11866
Atdid: 11866 • Atd Number: ATD-3-4839 • Bblid: 287527
Atdid
11866
Atd Number
ATD-3-4839
Bblid
287527
Inspectionid
353614
Inspect Date
2023-03-22T00:00:00.000
Atdissuedate
2023-03-22T12:32:56.000
Cb
8
House Num
424
Onstname
PARK PL.
Atddismissed
No
18628
Atdid: 18628 • Atd Number: ATD-3-7339 • Bblid: 511520
Atdid
18628
Atd Number
ATD-3-7339
Bblid
511520
Inspectionid
406180
Inspect Date
2025-09-06T00:00:00.000
Atdissuedate
2025-09-19T12:16:39.000
Cb
15
House Num
2516
Onstname
E. 28TH ST.
Atddismissed
No
13914
Atdid: 13914 • Atd Number: ATD-4-5770 • Bblid: 674779
Atdid
13914
Atd Number
ATD-4-5770
Bblid
674779
Inspectionid
371231
Inspect Date
2023-12-26T00:00:00.000
Atdissuedate
2024-02-01T13:28:57.000
Cb
5
House Num
80-12
Onstname
64TH LN.
Atddismissed
No
16896
Atdid: 16896 • Atd Number: ATD-4-6639 • Bblid: 741450
Atdid
16896
Atd Number
ATD-4-6639
Bblid
741450
Inspectionid
390830
Inspect Date
2025-03-04T00:00:00.000
Atdissuedate
2025-03-10T13:48:32.000
Cb
8
House Num
162-17
Onstname
76TH RD.
Atddismissed
No
13002
Atdid: 13002 • Atd Number: ATD-3-5262 • Bblid: 422370
Atdid
13002
Atd Number
ATD-3-5262
Bblid
422370
Inspectionid
360814
Inspect Date
2023-07-27T00:00:00.000
Atdissuedate
2023-07-27T13:31:51.000
Cb
12
House Num
1554
Onstname
45 STREET
Atddismissed
No
3874
Atdid: 3874 • Atd Number: ATD-3-2545 • Bblid: 279073
Atdid
3874
Atd Number
ATD-3-2545
Bblid
279073
Violationid
262220
Atdissuedate
2020-08-03T00:00:00.000
Cb
6
House Num
359
Onstname
11 STREET
Atddismissed
Yes
Atddismissedon
2024-10-28T10:37:38.000
10530
Atdid: 10530 • Atd Number: ATD-3-3981 • Bblid: 424667
Atdid
10530
Atd Number
ATD-3-3981
Bblid
424667
Inspectionid
340165
Inspect Date
2022-06-29T00:00:00.000
Atdissuedate
2022-07-20T16:06:12.000
Cb
12
House Num
1842
Onstname
53RD ST.
Atddismissed
No
13288
Atdid: 13288 • Atd Number: ATD-3-5448 • Bblid: 483261
Atdid
13288
Atd Number
ATD-3-5448
Bblid
483261
Inspectionid
362362
Inspect Date
2023-08-08T00:00:00.000
Atdissuedate
2023-08-22T11:38:52.000
Cb
14
House Num
1526
Onstname
E. 23RD ST.
Atddismissed
No
18618
Atdid: 18618 • Atd Number: ATD-4-7380 • Bblid: 786802
Atdid
18618
Atd Number
ATD-4-7380
Bblid
786802
Inspectionid
406075
Inspect Date
2025-09-15T00:00:00.000
Atdissuedate
2025-09-18T12:47:20.000
Cb
10
House Num
107-48
Onstname
92ND ST.
Atddismissed
No
11440
Atdid: 11440 • Atd Number: ATD-2-959 • Bblid: 172888
Atdid
11440
Atd Number
ATD-2-959
Bblid
172888
Inspectionid
348525
Inspect Date
2022-10-07T00:00:00.000
Atdissuedate
2022-11-22T12:33:52.000
Cb
9
House Num
650
Onstname
COMMONWEALTH AVE.
Atddismissed
No
10985
Atdid: 10985 • Atd Number: ATD-3-4338 • Bblid: 402303
Atdid
10985
Atd Number
ATD-3-4338
Bblid
402303
Inspectionid
344433
Inspect Date
2022-09-21T00:00:00.000
Atdissuedate
2022-09-23T14:01:42.000
Cb
17
House Num
97
Onstname
E. 31ST ST.
Atddismissed
No
11125
Atdid: 11125 • Atd Number: ATD-3-4461 • Bblid: 406202
Atdid
11125
Atd Number
ATD-3-4461
Bblid
406202
Inspectionid
345450
Inspect Date
2022-09-30T00:00:00.000
Atdissuedate
2022-10-11T09:58:14.000
Cb
17
House Num
823
Onstname
E. 34TH ST.
Atddismissed
No
12058
Atdid: 12058 • Atd Number: ATD-4-5137 • Bblid: 745281
Atdid
12058
Atd Number
ATD-4-5137
Bblid
745281
Inspectionid
355984
Inspect Date
2023-04-06T00:00:00.000
Atdissuedate
2023-04-17T13:48:53.000
Cb
8
House Num
76-43
Onstname
167TH ST.
Atddismissed
No
12673
Atdid: 12673 • Atd Number: ATD-5-715 • Bblid: 1023258
Atdid
12673
Atd Number
ATD-5-715
Bblid
1023258
Inspectionid
359079
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-06-28T16:15:08.000
Cb
3
House Num
31
Onstname
ABINGDON CT.
Atddismissed
No
8818
Atdid: 8818 • Atd Number: ATD-4-3983 • Bblid: 749553
Atdid
8818
Atd Number
ATD-4-3983
Bblid
749553
Inspectionid
331563
Inspect Date
2017-10-27T00:00:00.000
Atdissuedate
2022-01-10T11:19:40.000
Cb
8
House Num
184-57
Onstname
ABERDEEN RD.
Atddismissed
No
18312
Atdid: 18312 • Atd Number: ATD-3-7225 • Bblid: 517108
Atdid
18312
Atd Number
ATD-3-7225
Bblid
517108
Violationid
295774
Reinspectionid
37071
Inspect Date
2025-08-13T14:13:22.000
Atdissuedate
2025-08-13T14:13:22.000
Cb
14
House Num
2814
Onstname
AVENUE L
Atddismissed
No
12663
Atdid: 12663 • Atd Number: ATD-5-705 • Bblid: 1025277
Atdid
12663
Atd Number
ATD-5-705
Bblid
1025277
Inspectionid
359069
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-06-28T14:28:54.000
Cb
2
House Num
831
Onstname
ARTHUR KILL RD.
Atddismissed
No
13240
Atdid: 13240 • Atd Number: ATD-3-5411 • Bblid: 433102
Atdid
13240
Atd Number
ATD-3-5411
Bblid
433102
Inspectionid
362060
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T16:36:53.000
Cb
12
House Num
1444
Onstname
47TH ST.
Atddismissed
No
11046
Atdid: 11046 • Atd Number: ATD-3-4396 • Bblid: 318177
Atdid
11046
Atd Number
ATD-3-4396
Bblid
318177
Inspectionid
344680
Inspect Date
2022-09-22T00:00:00.000
Atdissuedate
2022-09-28T12:38:13.000
Cb
3
House Num
430
Onstname
JEFFERSON AVE.
Atddismissed
No
11021
Atdid: 11021 • Atd Number: ATD-4-4826 • Bblid: 705074
Atdid
11021
Atd Number
ATD-4-4826
Bblid
705074
Inspectionid
344601
Inspect Date
2022-08-25T00:00:00.000
Atdissuedate
2022-09-27T09:29:26.000
Cb
7
House Num
138-02
Onstname
56TH AVE.
Atddismissed
No
12585
Atdid: 12585 • Atd Number: ATD-4-5350 • Bblid: 598295
Atdid
12585
Atd Number
ATD-4-5350
Bblid
598295
Inspectionid
358586
Inspect Date
2023-06-12T00:00:00.000
Atdissuedate
2023-06-15T10:40:21.000
Cb
3
House Num
32-38
Onstname
73RD ST.
Atddismissed
No
11070
Atdid: 11070 • Atd Number: ATD-3-4418 • Bblid: 279596
Atdid
11070
Atd Number
ATD-3-4418
Bblid
279596
Inspectionid
345008
Inspect Date
2022-09-14T00:00:00.000
Atdissuedate
2022-10-03T08:51:11.000
Cb
6
House Num
231
Onstname
12TH ST.
Atddismissed
No
12063
Atdid: 12063 • Atd Number: ATD-3-4938 • Bblid: 354446
Atdid
12063
Atd Number
ATD-3-4938
Bblid
354446
Inspectionid
356056
Inspect Date
2023-04-19T00:00:00.000
Atdissuedate
2023-04-19T14:49:33.000
Cb
4
House Num
1716
Onstname
DEKALB AVE.
Atddismissed
No
18310
Atdid: 18310 • Atd Number: ATD-3-7224 • Bblid: 486048
Atdid
18310
Atd Number
ATD-3-7224
Bblid
486048
Violationid
298826
Reinspectionid
37731
Inspect Date
2025-08-13T13:54:31.000
Atdissuedate
2025-08-13T13:54:31.000
Cb
15
House Num
1830
Onstname
EAST 29 STREET
Atddismissed
No
2864
Atdid: 2864 • Atd Number: ATD-3-2007 • Bblid: 421259
Atdid
2864
Atd Number
ATD-3-2007
Bblid
421259
Violationid
192597
Atdissuedate
2020-03-17T00:00:00.000
Cb
12
House Num
724
Onstname
DITMAS AVENUE
Atddismissed
Yes
Atddismissedon
2023-02-07T10:54:56.000
10971
Atdid: 10971 • Atd Number: ATD-4-4821 • Bblid: 693444
Atdid
10971
Atd Number
ATD-4-4821
Bblid
693444
Violationid
269239
Reinspectionid
33183
Inspect Date
2022-09-22T12:12:11.000
Atdissuedate
2022-09-22T12:12:11.000
Cb
7
House Num
21-07
Onstname
154 STREET
Atddismissed
No
10038
Atdid: 10038 • Atd Number: ATD-4-4579 • Bblid: 654846
Atdid
10038
Atd Number
ATD-4-4579
Bblid
654846
Inspectionid
336048
Inspect Date
2022-04-26T00:00:00.000
Atdissuedate
2022-05-03T11:46:56.000
Cb
6
House Num
63-15
Onstname
CROMWELL CRES
Atddismissed
No
1116
Atdid: 1116 • Atd Number: ATD-3-259 • Bblid: 257189
Atdid
1116
Atd Number
ATD-3-259
Bblid
257189
Violationid
41543
Atdissuedate
2020-08-13T00:00:00.000
Cb
6
House Num
597
Onstname
HENRY STREET
Atddismissed
Yes
Atddismissedon
2024-10-15T11:56:04.000
15088
Atdid: 15088 • Atd Number: ATD-3-6298 • Bblid: 456663
Atdid
15088
Atd Number
ATD-3-6298
Bblid
456663
Inspectionid
382124
Inspect Date
2024-09-17T00:00:00.000
Atdissuedate
2024-09-23T12:03:10.000
Cb
11
House Num
2129
Onstname
72ND ST.
Atddismissed
No
9035
Atdid: 9035 • Atd Number: ATD-3-3309 • Bblid: 308142
Atdid
9035
Atd Number
ATD-3-3309
Bblid
308142
Inspectionid
332414
Inspect Date
2019-08-15T00:00:00.000
Atdissuedate
2022-02-14T10:08:37.000
Cb
3
House Num
563
Onstname
MONROE ST.
Atddismissed
No
2670
Atdid: 2670 • Atd Number: ATD-3-1813 • Bblid: 472325
Atdid
2670
Atd Number
ATD-3-1813
Bblid
472325
Violationid
185653
Atdissuedate
2020-08-17T00:00:00.000
Cb
11
House Num
2352
Onstname
62 STREET
Atddismissed
Yes
Atddismissedon
2022-05-16T11:00:55.000
17968
Atdid: 17968 • Atd Number: ATD-3-7080 • Bblid: 496407
Atdid
17968
Atd Number
ATD-3-7080
Bblid
496407
Inspectionid
400860
Inspect Date
2025-06-13T00:00:00.000
Atdissuedate
2025-06-24T13:04:51.000
Cb
15
House Num
2150
Onstname
E. 2ND ST.
Atddismissed
No
9349
Atdid: 9349 • Atd Number: ATD-3-3446 • Bblid: 505698
Atdid
9349
Atd Number
ATD-3-3446
Bblid
505698
Inspectionid
333072
Inspect Date
2021-05-04T00:00:00.000
Atdissuedate
2022-03-02T17:10:19.000
Cb
15
House Num
2065
Onstname
COYLE ST.
Atddismissed
No
13662
Atdid: 13662 • Atd Number: ATD-3-5629 • Bblid: 342386
Atdid
13662
Atd Number
ATD-3-5629
Bblid
342386
Inspectionid
366356
Inspect Date
2023-11-01T00:00:00.000
Atdissuedate
2023-11-06T11:55:13.000
Cb
1
House Num
150
Onstname
MESEROLE AVE.
Atddismissed
No
9494
Atdid: 9494 • Atd Number: ATD-4-4258 • Bblid: 737859
Atdid
9494
Atd Number
ATD-4-4258
Bblid
737859
Inspectionid
333420
Inspect Date
2019-08-16T00:00:00.000
Atdissuedate
2022-03-08T15:35:27.000
Cb
8
House Num
150-13
Onstname
78TH RD.
Atddismissed
No
16177
Atdid: 16177 • Atd Number: ATD-4-6349 • Bblid: 599962
Atdid
16177
Atd Number
ATD-4-6349
Bblid
599962
Violationid
251131
Inspectionid
383669
Inspect Date
2024-10-03T10:30:16.000
Atdissuedate
2024-10-03T10:30:16.000
Cb
2
House Num
37-07
Onstname
68 STREET
Atddismissed
No
15028
Atdid: 15028 • Atd Number: ATD-3-6264 • Bblid: 535038
Atdid
15028
Atd Number
ATD-3-6264
Bblid
535038
Inspectionid
381654
Inspect Date
2024-08-16T00:00:00.000
Atdissuedate
2024-09-09T16:12:15.000
Cb
18
House Num
1159
Onstname
E. 84TH ST.
Atddismissed
No
14183
Atdid: 14183 • Atd Number: ATD-3-5844 • Bblid: 532006
Atdid
14183
Atd Number
ATD-3-5844
Bblid
532006
Inspectionid
373670
Inspect Date
2023-12-15T00:00:00.000
Atdissuedate
2024-03-19T14:24:42.000
Cb
18
House Num
681
Onstname
E. 78TH ST.
Atddismissed
No
17631
Atdid: 17631 • Atd Number: ATD-4-6900 • Bblid: 760728
Atdid
17631
Atd Number
ATD-4-6900
Bblid
760728
Inspectionid
397190
Inspect Date
2025-01-17T00:00:00.000
Atdissuedate
2025-05-16T09:56:22.000
Cb
13
House Num
236-07
Onstname
88TH AVE.
Atddismissed
No
18198
Atdid: 18198 • Atd Number: ATD-4-7190 • Bblid: 830526
Atdid
18198
Atd Number
ATD-4-7190
Bblid
830526
Inspectionid
403192
Inspect Date
2025-07-07T00:00:00.000
Atdissuedate
2025-07-25T16:51:42.000
Cb
13
House Num
224-23
Onstname
FAIRBURY AVE.
Atddismissed
No
11756
Atdid: 11756 • Atd Number: ATD-5-682 • Bblid: 1000335
Atdid
11756
Atd Number
ATD-5-682
Bblid
1000335
Inspectionid
352583
Inspect Date
2023-03-01T00:00:00.000
Atdissuedate
2023-03-10T09:31:40.000
Cb
2
House Num
517
Onstname
GREELEY AVE.
Atddismissed
No
11380
Atdid: 11380 • Atd Number: ATD-4-4882 • Bblid: 596308
Atdid
11380
Atd Number
ATD-4-4882
Bblid
596308
Inspectionid
348032
Inspect Date
2022-11-09T00:00:00.000
Atdissuedate
2022-11-10T15:05:17.000
Cb
3
House Num
30-39
Onstname
70TH ST.
Atddismissed
No
11880
Atdid: 11880 • Atd Number: ATD-3-4852 • Bblid: 423392
Atdid
11880
Atd Number
ATD-3-4852
Bblid
423392
Inspectionid
353773
Inspect Date
2023-03-02T00:00:00.000
Atdissuedate
2023-03-24T12:09:36.000
Cb
12
House Num
1531
Onstname
51ST ST.
Atddismissed
No
14502
Atdid: 14502 • Atd Number: ATD-2-1279 • Bblid: 196343
Atdid
14502
Atd Number
ATD-2-1279
Bblid
196343
Inspectionid
377540
Inspect Date
2024-05-17T00:00:00.000
Atdissuedate
2024-05-20T13:15:24.000
Cb
11
House Num
856
Onstname
MORRIS PARK AVE.
Atddismissed
No
9161
Atdid: 9161 • Atd Number: ATD-3-3336 • Bblid: 407466
Atdid
9161
Atd Number
ATD-3-3336
Bblid
407466
Inspectionid
332779
Inspect Date
2019-04-23T00:00:00.000
Atdissuedate
2022-02-25T13:00:37.000
Cb
9
House Num
52
Onstname
MIDWOOD ST.
Atddismissed
No