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
13926
Atdid: 13926 • Atd Number: ATD-4-5777 • Bblid: 771237
Atdid
13926
Atd Number
ATD-4-5777
Bblid
771237
Inspectionid
371357
Inspect Date
2024-02-02T00:00:00.000
Atdissuedate
2024-02-07T10:39:48.000
Cb
13
House Num
86-40
Onstname
252ND ST.
Atddismissed
No
17768
Atdid: 17768 • Atd Number: ATD-4-6995 • Bblid: 686680
Atdid
17768
Atd Number
ATD-4-6995
Bblid
686680
Inspectionid
398903
Inspect Date
2025-05-30T00:00:00.000
Atdissuedate
2025-06-02T08:41:02.000
Cb
7
House Num
145-90
Onstname
9TH AVE.
Atddismissed
No
8694
Atdid: 8694 • Atd Number: ATD-3-3184 • Bblid: 285156
Atdid
8694
Atd Number
ATD-3-3184
Bblid
285156
Inspectionid
330863
Inspect Date
2021-06-18T00:00:00.000
Atdissuedate
2021-12-20T08:25:15.000
Cb
7
House Num
55
Onstname
SHERMAN ST.
Atddismissed
No
8663
Atdid: 8663 • Atd Number: ATD-4-3890 • Bblid: 868652
Atdid
8663
Atd Number
ATD-4-3890
Bblid
868652
Inspectionid
330820
Inspect Date
2019-06-25T00:00:00.000
Atdissuedate
2021-12-16T10:31:18.000
Cb
12
House Num
150-15
Onstname
119TH AVE.
Atddismissed
No
14828
Atdid: 14828 • Atd Number: ATD-3-6163 • Bblid: 427130
Atdid
14828
Atd Number
ATD-3-6163
Bblid
427130
Inspectionid
380008
Inspect Date
2024-07-30T00:00:00.000
Atdissuedate
2024-07-31T11:29:16.000
Cb
11
House Num
1825
Onstname
62ND ST.
Atddismissed
No
12336
Atdid: 12336 • Atd Number: ATD-4-5202 • Bblid: 630284
Atdid
12336
Atd Number
ATD-4-5202
Bblid
630284
Inspectionid
357429
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T16:08:49.000
Cb
2
House Num
45-01
Onstname
49 STREET
Atddismissed
No
11343
Atdid: 11343 • Atd Number: ATD-3-4617 • Bblid: 277475
Atdid
11343
Atd Number
ATD-3-4617
Bblid
277475
Inspectionid
347653
Inspect Date
2022-11-03T00:00:00.000
Atdissuedate
2022-11-07T10:27:58.000
Cb
6
House Num
325
Onstname
4TH ST.
Atddismissed
No
17970
Atdid: 17970 • Atd Number: ATD-4-7094 • Bblid: 842926
Atdid
17970
Atd Number
ATD-4-7094
Bblid
842926
Inspectionid
400936
Inspect Date
2025-06-17T00:00:00.000
Atdissuedate
2025-06-24T14:11:15.000
Cb
13
House Num
217-25
Onstname
114TH RD.
Atddismissed
No
14927
Atdid: 14927 • Atd Number: ATD-3-6208 • Bblid: 465664
Atdid
14927
Atd Number
ATD-3-6208
Bblid
465664
Inspectionid
380741
Inspect Date
2024-08-13T00:00:00.000
Atdissuedate
2024-08-19T09:14:04.000
Cb
11
House Num
62
Onstname
BAY 19TH ST.
Atddismissed
No
12985
Atdid: 12985 • Atd Number: ATD-3-5249 • Bblid: 422218
Atdid
12985
Atd Number
ATD-3-5249
Bblid
422218
Inspectionid
360712
Inspect Date
2023-07-27T00:00:00.000
Atdissuedate
2023-07-27T10:55:03.000
Cb
12
House Num
4323
Onstname
15TH AVE.
Atddismissed
No
13697
Atdid: 13697 • Atd Number: ATD-4-5638 • Bblid: 862274
Atdid
13697
Atd Number
ATD-4-5638
Bblid
862274
Inspectionid
367675
Inspect Date
2023-11-15T00:00:00.000
Atdissuedate
2023-11-16T15:58:37.000
Cb
12
House Num
115-60
Onstname
145TH ST.
Atddismissed
Yes
Atddismissedon
2024-03-08T17:46:40.000
16920
Atdid: 16920 • Atd Number: ATD-4-6647 • Bblid: 643535
Atdid
16920
Atd Number
ATD-4-6647
Bblid
643535
Inspectionid
391043
Inspect Date
2025-03-11T00:00:00.000
Atdissuedate
2025-03-13T14:58:39.000
Cb
5
House Num
59-24
Onstname
69TH LN.
Atddismissed
No
13459
Atdid: 13459 • Atd Number: ATD-4-5539 • Bblid: 608341
Atdid
13459
Atd Number
ATD-4-5539
Bblid
608341
Inspectionid
364117
Inspect Date
2023-09-22T00:00:00.000
Atdissuedate
2023-09-22T12:39:47.000
Cb
3
House Num
34-38
Onstname
87TH ST.
Atddismissed
No
9245
Atdid: 9245 • Atd Number: ATD-2-862 • Bblid: 171146
Atdid
9245
Atd Number
ATD-2-862
Bblid
171146
Inspectionid
332951
Inspect Date
2018-06-27T00:00:00.000
Atdissuedate
2022-03-01T17:26:57.000
Cb
9
House Num
1756
Onstname
LACOMBE AVE.
Atddismissed
No
12132
Atdid: 12132 • Atd Number: ATD-2-1021 • Bblid: 176662
Atdid
12132
Atd Number
ATD-2-1021
Bblid
176662
Inspectionid
356498
Inspect Date
2023-03-24T00:00:00.000
Atdissuedate
2023-05-01T14:16:52.000
Cb
9
House Num
1216
Onstname
ROSEDALE AVE.
Atddismissed
No
18560
Atdid: 18560 • Atd Number: ATD-2-1469 • Bblid: 202060
Atdid
18560
Atd Number
ATD-2-1469
Bblid
202060
Inspectionid
405592
Inspect Date
2025-08-29T00:00:00.000
Atdissuedate
2025-09-09T13:22:21.000
Cb
11
House Num
1923
Onstname
YATES AVE.
Atddismissed
No
3432
Atdid: 3432 • Atd Number: ATD-4-223 • Bblid: 801847
Atdid
3432
Atd Number
ATD-4-223
Bblid
801847
Violationid
126609
Atdissuedate
2020-08-14T00:00:00.000
Cb
10
House Num
105-64
Onstname
132 STREET
Atddismissed
Yes
Atddismissedon
2021-12-14T18:56:38.000
8951
Atdid: 8951 • Atd Number: ATD-4-4050 • Bblid: 920182
Atdid
8951
Atd Number
ATD-4-4050
Bblid
920182
Inspectionid
332252
Inspect Date
2019-08-07T00:00:00.000
Atdissuedate
2022-02-04T11:23:53.000
Cb
14
House Num
3-57
Onstname
BEACH 149TH ST.
Atddismissed
No
8681
Atdid: 8681 • Atd Number: ATD-4-3905 • Bblid: 874654
Atdid
8681
Atd Number
ATD-4-3905
Bblid
874654
Inspectionid
330850
Inspect Date
2019-06-26T00:00:00.000
Atdissuedate
2021-12-17T10:09:26.000
Cb
12
House Num
176-22
Onstname
129TH AVE.
Atddismissed
No
11326
Atdid: 11326 • Atd Number: ATD-1-215 • Bblid: 114355
Atdid
11326
Atd Number
ATD-1-215
Bblid
114355
Inspectionid
347487
Inspect Date
2022-11-02T00:00:00.000
Atdissuedate
2022-11-02T14:31:18.000
Cb
11
House Num
1451
Onstname
5TH AVE.
Atddismissed
No
14890
Atdid: 14890 • Atd Number: ATD-3-6191 • Bblid: 369304
Atdid
14890
Atd Number
ATD-3-6191
Bblid
369304
Inspectionid
380445
Inspect Date
2024-08-08T00:00:00.000
Atdissuedate
2024-08-12T09:33:19.000
Cb
5
House Num
355
Onstname
SHEFFIELD AVE.
Atddismissed
No
12618
Atdid: 12618 • Atd Number: ATD-5-701 • Bblid: 963903
Atdid
12618
Atd Number
ATD-5-701
Bblid
963903
Inspectionid
358790
Inspect Date
2023-06-21T00:00:00.000
Atdissuedate
2023-06-21T07:58:50.000
Cb
2
House Num
182
Onstname
LANDER AVE.
Atddismissed
No
11366
Atdid: 11366 • Atd Number: ATD-1-230 • Bblid: 45622
Atdid
11366
Atd Number
ATD-1-230
Bblid
45622
Inspectionid
347853
Inspect Date
2022-11-03T00:00:00.000
Atdissuedate
2022-11-09T13:30:06.000
Cb
6
House Num
218
Onstname
E. 31ST ST.
Atddismissed
No
13212
Atdid: 13212 • Atd Number: ATD-5-797 • Bblid: 1027261
Atdid
13212
Atd Number
ATD-5-797
Bblid
1027261
Inspectionid
361990
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-14T11:57:10.000
Cb
3
House Num
474
Onstname
GENESEE AVE.
Atddismissed
No
8807
Atdid: 8807 • Atd Number: ATD-3-3226 • Bblid: 328678
Atdid
8807
Atd Number
ATD-3-3226
Bblid
328678
Inspectionid
331483
Inspect Date
2021-12-28T00:00:00.000
Atdissuedate
2022-01-05T15:10:48.000
Cb
2
House Num
304
Onstname
CLERMONT AVE.
Atddismissed
No
13061
Atdid: 13061 • Atd Number: ATD-5-775 • Bblid: 1043089
Atdid
13061
Atd Number
ATD-5-775
Bblid
1043089
Inspectionid
361057
Inspect Date
2023-07-26T00:00:00.000
Atdissuedate
2023-07-31T09:43:08.000
Cb
3
House Num
1752
Onstname
CARLTON AVE.
Atddismissed
Yes
Atddismissedon
2023-07-31T09:54:15.000
13215
Atdid: 13215 • Atd Number: ATD-3-5386 • Bblid: 422647
Atdid
13215
Atd Number
ATD-3-5386
Bblid
422647
Inspectionid
362035
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T15:24:30.000
Cb
12
House Num
1771
Onstname
46TH ST.
Atddismissed
No
18598
Atdid: 18598 • Atd Number: ATD-4-7370 • Bblid: 744419
Atdid
18598
Atd Number
ATD-4-7370
Bblid
744419
Inspectionid
405846
Inspect Date
2025-09-11T00:00:00.000
Atdissuedate
2025-09-15T12:06:57.000
Cb
8
House Num
73-16
Onstname
172ND ST.
Atddismissed
No
8821
Atdid: 8821 • Atd Number: ATD-4-3985 • Bblid: 648097
Atdid
8821
Atd Number
ATD-4-3985
Bblid
648097
Inspectionid
331579
Inspect Date
2022-01-11T00:00:00.000
Atdissuedate
2022-01-11T11:02:42.000
Cb
5
House Num
62-61
Onstname
69TH ST.
Atddismissed
No
8934
Atdid: 8934 • Atd Number: ATD-3-3262 • Bblid: 291599
Atdid
8934
Atd Number
ATD-3-3262
Bblid
291599
Inspectionid
332192
Inspect Date
2022-01-19T00:00:00.000
Atdissuedate
2022-01-31T11:47:18.000
Cb
8
House Num
909
Onstname
LINCOLN PL.
Atddismissed
No
10783
Atdid: 10783 • Atd Number: ATD-3-4160 • Bblid: 262678
Atdid
10783
Atd Number
ATD-3-4160
Bblid
262678
Inspectionid
342886
Inspect Date
2022-08-05T00:00:00.000
Atdissuedate
2022-09-07T14:41:15.000
Cb
7
House Num
194
Onstname
18TH ST.
Atddismissed
No
11715
Atdid: 11715 • Atd Number: ATD-3-4759 • Bblid: 452262
Atdid
11715
Atd Number
ATD-3-4759
Bblid
452262
Inspectionid
352048
Inspect Date
2023-02-24T00:00:00.000
Atdissuedate
2023-02-27T09:58:06.000
Cb
10
House Num
648
Onstname
88TH ST.
Atddismissed
No
11850
Atdid: 11850 • Atd Number: ATD-3-4824 • Bblid: 323750
Atdid
11850
Atd Number
ATD-3-4824
Bblid
323750
Inspectionid
353545
Inspect Date
2023-03-18T00:00:00.000
Atdissuedate
2023-03-22T09:50:22.000
Cb
3
House Num
118
Onstname
CLIFTON PL.
Atddismissed
No
14876
Atdid: 14876 • Atd Number: ATD-4-6209 • Bblid: 842919
Atdid
14876
Atd Number
ATD-4-6209
Bblid
842919
Inspectionid
380237
Inspect Date
2023-01-04T00:00:00.000
Atdissuedate
2024-08-05T15:11:29.000
Cb
13
House Num
225-44
Onstname
MURDOCK AVE.
Atddismissed
No
10012
Atdid: 10012 • Atd Number: ATD-3-3670 • Bblid: 275674
Atdid
10012
Atd Number
ATD-3-3670
Bblid
275674
Inspectionid
335901
Inspect Date
2022-04-29T00:00:00.000
Atdissuedate
2022-05-02T10:51:51.000
Cb
6
House Num
124
Onstname
BERKELEY PL.
Atddismissed
Yes
Atddismissedon
2022-05-24T09:49:40.000
9746
Atdid: 9746 • Atd Number: ATD-2-900 • Bblid: 198147
Atdid
9746
Atd Number
ATD-2-900
Bblid
198147
Inspectionid
334311
Inspect Date
2019-07-16T00:00:00.000
Atdissuedate
2022-03-28T17:46:39.000
Cb
11
House Num
1660
Onstname
YATES AVE.
Atddismissed
No
14989
Atdid: 14989 • Atd Number: ATD-2-1300 • Bblid: 196704
Atdid
14989
Atd Number
ATD-2-1300
Bblid
196704
Inspectionid
381367
Inspect Date
2024-09-04T00:00:00.000
Atdissuedate
2024-09-04T12:24:25.000
Cb
11
House Num
1560
Onstname
BOGART AVE.
Atddismissed
No
12734
Atdid: 12734 • Atd Number: ATD-5-754 • Bblid: 1008458
Atdid
12734
Atd Number
ATD-5-754
Bblid
1008458
Inspectionid
359250
Inspect Date
2023-06-30T00:00:00.000
Atdissuedate
2023-06-30T12:42:20.000
Cb
3
House Num
9
Onstname
COTTONWOOD CT.
Atddismissed
No
12431
Atdid: 12431 • Atd Number: ATD-4-5273 • Bblid: 790839
Atdid
12431
Atd Number
ATD-4-5273
Bblid
790839
Inspectionid
357758
Inspect Date
2023-05-26T00:00:00.000
Atdissuedate
2023-05-26T15:27:42.000
Cb
9
House Num
104-02
Onstname
JAMAICA AVE.
Atddismissed
No
16268
Atdid: 16268 • Atd Number: ATD-3-6366 • Bblid: 471719
Atdid
16268
Atd Number
ATD-3-6366
Bblid
471719
Inspectionid
384274
Inspect Date
2024-10-17T00:00:00.000
Atdissuedate
2024-10-21T12:36:14.000
Cb
12
House Num
1220
Onstname
E. 8TH ST.
Atddismissed
No
16465
Atdid: 16465 • Atd Number: ATD-4-6478 • Bblid: 655458
Atdid
16465
Atd Number
ATD-4-6478
Bblid
655458
Inspectionid
385600
Inspect Date
2024-11-15T00:00:00.000
Atdissuedate
2024-12-02T12:43:39.000
Cb
6
House Num
66-43
Onstname
BURNS ST.
Atddismissed
No
16315
Atdid: 16315 • Atd Number: ATD-3-6392 • Bblid: 283457
Atdid
16315
Atd Number
ATD-3-6392
Bblid
283457
Inspectionid
384538
Inspect Date
2024-10-18T00:00:00.000
Atdissuedate
2024-10-29T12:13:19.000
Cb
6
House Num
641
Onstname
10TH ST.
Atddismissed
No
8868
Atdid: 8868 • Atd Number: ATD-4-4011 • Bblid: 597246
Atdid
8868
Atd Number
ATD-4-4011
Bblid
597246
Inspectionid
331837
Inspect Date
2022-01-13T00:00:00.000
Atdissuedate
2022-01-24T12:16:27.000
Cb
3
House Num
31-52
Onstname
76TH ST.
Atddismissed
No
10378
Atdid: 10378 • Atd Number: ATD-3-3891 • Bblid: 417686
Atdid
10378
Atd Number
ATD-3-3891
Bblid
417686
Inspectionid
338590
Inspect Date
2022-06-22T00:00:00.000
Atdissuedate
2022-07-05T13:56:13.000
Cb
12
House Num
236
Onstname
E. 5TH ST.
Atddismissed
No
12790
Atdid: 12790 • Atd Number: ATD-3-5124 • Bblid: 502606
Atdid
12790
Atd Number
ATD-3-5124
Bblid
502606
Inspectionid
359597
Inspect Date
2023-07-08T00:00:00.000
Atdissuedate
2023-07-08T11:01:59.000
Cb
15
House Num
1948
Onstname
E. 12TH ST.
Atddismissed
No
14797
Atdid: 14797 • Atd Number: ATD-4-6180 • Bblid: 577245
Atdid
14797
Atd Number
ATD-4-6180
Bblid
577245
Inspectionid
379818
Inspect Date
2024-07-19T00:00:00.000
Atdissuedate
2024-07-26T11:59:31.000
Cb
1
House Num
34-55
Onstname
29TH ST.
Atddismissed
No
10286
Atdid: 10286 • Atd Number: ATD-4-4659 • Bblid: 747798
Atdid
10286
Atd Number
ATD-4-4659
Bblid
747798
Inspectionid
337679
Inspect Date
2022-06-11T00:00:00.000
Atdissuedate
2022-06-13T17:29:26.000
Cb
8
House Num
73-30
Onstname
198TH ST.
Atddismissed
No
18054
Atdid: 18054 • Atd Number: ATD-4-7131 • Bblid: 771825
Atdid
18054
Atd Number
ATD-4-7131
Bblid
771825
Inspectionid
402098
Inspect Date
2025-07-08T00:00:00.000
Atdissuedate
2025-07-11T14:17:01.000
Cb
13
House Num
247-11
Onstname
88TH DR.
Atddismissed
No
13582
Atdid: 13582 • Atd Number: ATD-3-5592 • Bblid: 359493
Atdid
13582
Atd Number
ATD-3-5592
Bblid
359493
Inspectionid
365362
Inspect Date
2023-10-11T00:00:00.000
Atdissuedate
2023-10-16T10:30:31.000
Cb
4
House Num
1193
Onstname
JEFFERSON AVE.
Atddismissed
No
14330
Atdid: 14330 • Atd Number: ATD-4-5979 • Bblid: 641046
Atdid
14330
Atd Number
ATD-4-5979
Bblid
641046
Inspectionid
375950
Inspect Date
2024-04-15T00:00:00.000
Atdissuedate
2024-04-23T12:42:28.000
Cb
5
House Num
57-57
Onstname
65TH ST.
Atddismissed
No