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
17510
Atdid: 17510 • Atd Number: ATD-3-6944 • Bblid: 295558
Atdid
17510
Atd Number
ATD-3-6944
Bblid
295558
Inspectionid
396029
Inspect Date
2025-04-30T00:00:00.000
Atdissuedate
2025-05-05T07:58:39.000
Cb
8
House Num
69
Onstname
BUFFALO AVE.
Atddismissed
No
12099
Atdid: 12099 • Atd Number: ATD-3-4954 • Bblid: 267474
Atdid
12099
Atd Number
ATD-3-4954
Bblid
267474
Inspectionid
356302
Inspect Date
2023-04-12T00:00:00.000
Atdissuedate
2023-04-26T11:42:53.000
Cb
7
House Num
446
Onstname
50TH ST.
Atddismissed
No
13487
Atdid: 13487 • Atd Number: ATD-3-5556 • Bblid: 427999
Atdid
13487
Atd Number
ATD-3-5556
Bblid
427999
Inspectionid
364358
Inspect Date
2023-09-16T00:00:00.000
Atdissuedate
2023-09-26T10:35:11.000
Cb
11
House Num
1689
Onstname
64TH ST.
Atddismissed
No
13292
Atdid: 13292 • Atd Number: ATD-3-5452 • Bblid: 476160
Atdid
13292
Atd Number
ATD-3-5452
Bblid
476160
Inspectionid
362386
Inspect Date
2023-08-19T00:00:00.000
Atdissuedate
2023-08-22T12:17:39.000
Cb
11
House Num
1665
Onstname
W. 8TH ST.
Atddismissed
No
18017
Atdid: 18017 • Atd Number: ATD-4-7110 • Bblid: 887181
Atdid
18017
Atd Number
ATD-4-7110
Bblid
887181
Inspectionid
401715
Inspect Date
2025-06-26T00:00:00.000
Atdissuedate
2025-07-01T17:01:24.000
Cb
13
House Num
135-12
Onstname
224TH ST.
Atddismissed
No
14235
Atdid: 14235 • Atd Number: ATD-4-5931 • Bblid: 630588
Atdid
14235
Atd Number
ATD-4-5931
Bblid
630588
Inspectionid
374642
Inspect Date
2024-03-22T00:00:00.000
Atdissuedate
2024-04-03T12:37:47.000
Cb
2
House Num
48-43
Onstname
44TH ST.
Atddismissed
No
17392
Atdid: 17392 • Atd Number: ATD-4-6778 • Bblid: 852760
Atdid
17392
Atd Number
ATD-4-6778
Bblid
852760
Inspectionid
394838
Inspect Date
2025-04-10T00:00:00.000
Atdissuedate
2025-04-16T16:13:33.000
Cb
10
House Num
114-20
Onstname
120TH ST.
Atddismissed
No
9249
Atdid: 9249 • Atd Number: ATD-2-864 • Bblid: 212865
Atdid
9249
Atd Number
ATD-2-864
Bblid
212865
Inspectionid
332955
Inspect Date
2021-01-27T00:00:00.000
Atdissuedate
2022-03-01T17:29:53.000
Cb
12
House Num
748
Onstname
E. 219TH ST.
Atddismissed
No
14140
Atdid: 14140 • Atd Number: ATD-4-5899 • Bblid: 647274
Atdid
14140
Atd Number
ATD-4-5899
Bblid
647274
Inspectionid
373368
Inspect Date
2023-11-04T00:00:00.000
Atdissuedate
2024-03-18T10:37:24.000
Cb
5
House Num
61-46
Onstname
78TH ST.
Atddismissed
No
1830
Atdid: 1830 • Atd Number: ATD-3-973 • Bblid: 298639
Atdid
1830
Atd Number
ATD-3-973
Bblid
298639
Violationid
51086
Atdissuedate
2020-02-11T00:00:00.000
Cb
9
House Num
1636
Onstname
UNION STREET
Atddismissed
Yes
Atddismissedon
2025-03-31T11:31:40.000
12876
Atdid: 12876 • Atd Number: ATD-2-1193 • Bblid: 202419
Atdid
12876
Atd Number
ATD-2-1193
Bblid
202419
Inspectionid
360149
Inspect Date
2023-07-12T00:00:00.000
Atdissuedate
2023-07-17T13:02:31.000
Cb
11
House Num
2026
Onstname
MATTHEWS AVE.
Atddismissed
No
14896
Atdid: 14896 • Atd Number: ATD-3-6194 • Bblid: 487890
Atdid
14896
Atd Number
ATD-3-6194
Bblid
487890
Inspectionid
380473
Inspect Date
2024-08-08T00:00:00.000
Atdissuedate
2024-08-12T10:26:11.000
Cb
11
House Num
124
Onstname
BAY 40TH ST.
Atddismissed
No
14552
Atdid: 14552 • Atd Number: ATD-3-6011 • Bblid: 562624
Atdid
14552
Atd Number
ATD-3-6011
Bblid
562624
Inspectionid
378051
Inspect Date
2024-06-01T00:00:00.000
Atdissuedate
2024-06-03T12:52:04.000
Cb
15
House Num
2070
Onstname
STUART ST.
Atddismissed
No
11575
Atdid: 11575 • Atd Number: ATD-3-4709 • Bblid: 521777
Atdid
11575
Atd Number
ATD-3-4709
Bblid
521777
Inspectionid
350063
Inspect Date
2023-01-03T00:00:00.000
Atdissuedate
2023-01-04T13:37:41.000
Cb
18
House Num
992
Onstname
E. 40TH ST.
Atddismissed
No
10481
Atdid: 10481 • Atd Number: ATD-3-3950 • Bblid: 265843
Atdid
10481
Atd Number
ATD-3-3950
Bblid
265843
Inspectionid
339766
Inspect Date
2022-06-14T00:00:00.000
Atdissuedate
2022-07-15T08:49:55.000
Cb
7
House Num
336
Onstname
45TH ST.
Atddismissed
No
11824
Atdid: 11824 • Atd Number: ATD-4-5055 • Bblid: 717968
Atdid
11824
Atd Number
ATD-4-5055
Bblid
717968
Inspectionid
353350
Inspect Date
2023-03-16T00:00:00.000
Atdissuedate
2023-03-20T13:34:31.000
Cb
11
House Num
50-47
Onstname
175TH ST.
Atddismissed
No
18194
Atdid: 18194 • Atd Number: ATD-5-1012 • Bblid: 1001347
Atdid
18194
Atd Number
ATD-5-1012
Bblid
1001347
Inspectionid
403169
Inspect Date
2025-07-25T00:00:00.000
Atdissuedate
2025-07-25T09:09:11.000
Cb
3
House Num
432
Onstname
FALCON AVE.
Atddismissed
No
16231
Atdid: 16231 • Atd Number: ATD-4-6377 • Bblid: 816743
Atdid
16231
Atd Number
ATD-4-6377
Bblid
816743
Inspectionid
384161
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2024-10-15T13:19:57.000
Cb
12
House Num
92-31
Onstname
175TH ST.
Atddismissed
No
17952
Atdid: 17952 • Atd Number: ATD-3-7069 • Bblid: 282188
Atdid
17952
Atd Number
ATD-3-7069
Bblid
282188
Inspectionid
400759
Inspect Date
2025-06-10T00:00:00.000
Atdissuedate
2025-06-23T11:22:11.000
Cb
6
House Num
14
Onstname
POLHEMUS PL.
Atddismissed
No
12836
Atdid: 12836 • Atd Number: ATD-4-5433 • Bblid: 645275
Atdid
12836
Atd Number
ATD-4-5433
Bblid
645275
Inspectionid
359934
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-07-13T12:09:25.000
Cb
4
House Num
86-41
Onstname
57TH RD.
Atddismissed
No
11354
Atdid: 11354 • Atd Number: ATD-3-4628 • Bblid: 282865
Atdid
11354
Atd Number
ATD-3-4628
Bblid
282865
Inspectionid
347737
Inspect Date
2022-11-02T00:00:00.000
Atdissuedate
2022-11-07T11:48:32.000
Cb
6
House Num
518
Onstname
7TH ST.
Atddismissed
No
14981
Atdid: 14981 • Atd Number: ATD-3-6234 • Bblid: 444591
Atdid
14981
Atd Number
ATD-3-6234
Bblid
444591
Inspectionid
381271
Inspect Date
2024-08-31T00:00:00.000
Atdissuedate
2024-08-31T11:37:02.000
Cb
10
House Num
649
Onstname
72ND ST.
Atddismissed
No
8556
Atdid: 8556 • Atd Number: ATD-2-846 • Bblid: 208814
Atdid
8556
Atd Number
ATD-2-846
Bblid
208814
Inspectionid
330362
Inspect Date
2021-11-30T00:00:00.000
Atdissuedate
2021-12-07T13:51:20.000
Cb
12
House Num
3024
Onstname
BRONX PARK E.
Atddismissed
No
17983
Atdid: 17983 • Atd Number: ATD-3-7084 • Bblid: 496735
Atdid
17983
Atd Number
ATD-3-7084
Bblid
496735
Inspectionid
401567
Inspect Date
2025-06-25T00:00:00.000
Atdissuedate
2025-06-26T11:28:07.000
Cb
15
House Num
2217
Onstname
E. 4TH ST.
Atddismissed
No
10698
Atdid: 10698 • Atd Number: ATD-3-4081 • Bblid: 259407
Atdid
10698
Atd Number
ATD-3-4081
Bblid
259407
Inspectionid
342099
Inspect Date
2022-08-26T00:00:00.000
Atdissuedate
2022-08-29T07:58:36.000
Cb
6
House Num
162
Onstname
DOUGLASS ST.
Atddismissed
No
17061
Atdid: 17061 • Atd Number: ATD-2-1345 • Bblid: 231187
Atdid
17061
Atd Number
ATD-2-1345
Bblid
231187
Inspectionid
392392
Inspect Date
2025-03-18T00:00:00.000
Atdissuedate
2025-03-27T10:56:25.000
Cb
10
House Num
1371
Onstname
HOLLYWOOD AVE.
Atddismissed
No
17462
Atdid: 17462 • Atd Number: ATD-4-6816 • Bblid: 862396
Atdid
17462
Atd Number
ATD-4-6816
Bblid
862396
Inspectionid
395447
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-28T11:16:39.000
Cb
12
House Num
115-42
Onstname
146TH ST.
Atddismissed
No
9873
Atdid: 9873 • Atd Number: ATD-4-4482 • Bblid: 812670
Atdid
9873
Atd Number
ATD-4-4482
Bblid
812670
Inspectionid
334930
Inspect Date
2019-09-14T00:00:00.000
Atdissuedate
2022-04-14T17:20:10.000
Cb
12
House Num
147-34
Onstname
97TH AVE.
Atddismissed
No
18197
Atdid: 18197 • Atd Number: ATD-4-7189 • Bblid: 830528
Atdid
18197
Atd Number
ATD-4-7189
Bblid
830528
Inspectionid
403182
Inspect Date
2025-07-07T00:00:00.000
Atdissuedate
2025-07-25T16:44:16.000
Cb
13
House Num
24-21
Onstname
FAIRBURY AVENUE
Atddismissed
No
11462
Atdid: 11462 • Atd Number: ATD-3-4672 • Bblid: 315659
Atdid
11462
Atd Number
ATD-3-4672
Bblid
315659
Inspectionid
348735
Inspect Date
2022-10-26T00:00:00.000
Atdissuedate
2022-11-28T11:55:07.000
Cb
3
House Num
83
Onstname
CHAUNCEY ST.
Atddismissed
No
8783
Atdid: 8783 • Atd Number: ATD-4-3960 • Bblid: 579781
Atdid
8783
Atd Number
ATD-4-3960
Bblid
579781
Inspectionid
331251
Inspect Date
2021-11-10T00:00:00.000
Atdissuedate
2021-12-29T14:43:34.000
Cb
1
House Num
30-40
Onstname
36TH ST.
Atddismissed
No
8635
Atdid: 8635 • Atd Number: ATD-4-3876 • Bblid: 772527
Atdid
8635
Atd Number
ATD-4-3876
Bblid
772527
Inspectionid
330773
Inspect Date
2021-12-01T00:00:00.000
Atdissuedate
2021-12-15T13:32:47.000
Cb
13
House Num
78-12
Onstname
268TH ST.
Atddismissed
No
17918
Atdid: 17918 • Atd Number: ATD-2-1423 • Bblid: 241330
Atdid
17918
Atd Number
ATD-2-1423
Bblid
241330
Inspectionid
400583
Inspect Date
2025-06-05T00:00:00.000
Atdissuedate
2025-06-18T09:38:46.000
Cb
10
House Num
415
Onstname
HUNTER AVE.
Atddismissed
No
18562
Atdid: 18562 • Atd Number: ATD-2-1470 • Bblid: 202046
Atdid
18562
Atd Number
ATD-2-1470
Bblid
202046
Inspectionid
405600
Inspect Date
2025-08-29T00:00:00.000
Atdissuedate
2025-09-09T15:00:20.000
Cb
11
House Num
1943
Onstname
YATES AVE.
Atddismissed
No
18646
Atdid: 18646 • Atd Number: ATD-4-7395 • Bblid: 730763
Atdid
18646
Atd Number
ATD-4-7395
Bblid
730763
Inspectionid
406270
Inspect Date
2025-09-10T00:00:00.000
Atdissuedate
2025-09-22T10:41:26.000
Cb
11
House Num
218-19
Onstname
43RD AVE.
Atddismissed
No
10307
Atdid: 10307 • Atd Number: ATD-4-4666 • Bblid: 851053
Atdid
10307
Atd Number
ATD-4-4666
Bblid
851053
Inspectionid
337778
Inspect Date
2022-06-17T00:00:00.000
Atdissuedate
2022-06-17T10:44:57.000
Cb
10
House Num
109-26
Onstname
122ND ST.
Atddismissed
No
12804
Atdid: 12804 • Atd Number: ATD-3-5138 • Bblid: 484780
Atdid
12804
Atd Number
ATD-3-5138
Bblid
484780
Inspectionid
359736
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-07-10T15:43:29.000
Cb
15
House Num
1762
Onstname
E. 23RD ST.
Atddismissed
No
8616
Atdid: 8616 • Atd Number: ATD-3-3155 • Bblid: 279982
Atdid
8616
Atd Number
ATD-3-3155
Bblid
279982
Inspectionid
330711
Inspect Date
2019-07-24T00:00:00.000
Atdissuedate
2021-12-14T16:55:26.000
Cb
6
House Num
179
Onstname
13TH ST.
Atddismissed
No
10967
Atdid: 10967 • Atd Number: ATD-3-4325 • Bblid: 276521
Atdid
10967
Atd Number
ATD-3-4325
Bblid
276521
Violationid
277226
Reinspectionid
33005
Inspect Date
2022-09-22T11:24:15.000
Atdissuedate
2022-09-22T11:24:15.000
Cb
6
House Num
686
Onstname
PRESIDENT STREET
Atddismissed
No
12460
Atdid: 12460 • Atd Number: ATD-4-5292 • Bblid: 813015
Atdid
12460
Atd Number
ATD-4-5292
Bblid
813015
Inspectionid
357963
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T09:33:44.000
Cb
12
House Num
106-20
Onstname
SUTPHIN BLVD.
Atddismissed
No
11573
Atdid: 11573 • Atd Number: ATD-4-4942 • Bblid: 776672
Atdid
11573
Atd Number
ATD-4-4942
Bblid
776672
Inspectionid
350004
Inspect Date
2022-12-28T00:00:00.000
Atdissuedate
2023-01-04T10:46:52.000
Cb
9
House Num
76-41
Onstname
85TH DR.
Atddismissed
No
13560
Atdid: 13560 • Atd Number: ATD-3-5576 • Bblid: 455623
Atdid
13560
Atd Number
ATD-3-5576
Bblid
455623
Inspectionid
365109
Inspect Date
2023-10-03T00:00:00.000
Atdissuedate
2023-10-10T14:23:04.000
Cb
11
House Num
1516
Onstname
70TH ST.
Atddismissed
No
8991
Atdid: 8991 • Atd Number: ATD-4-4082 • Bblid: 821014
Atdid
8991
Atd Number
ATD-4-4082
Bblid
821014
Inspectionid
332305
Inspect Date
2022-01-26T00:00:00.000
Atdissuedate
2022-02-08T09:36:18.000
Cb
12
House Num
189-01
Onstname
114TH DR.
Atddismissed
No
16296
Atdid: 16296 • Atd Number: ATD-3-6374 • Bblid: 279087
Atdid
16296
Atd Number
ATD-3-6374
Bblid
279087
Inspectionid
384470
Inspect Date
2024-09-26T00:00:00.000
Atdissuedate
2024-10-28T10:46:26.000
Cb
6
House Num
345
Onstname
11TH ST.
Atddismissed
No
13774
Atdid: 13774 • Atd Number: ATD-4-5677 • Bblid: 655118
Atdid
13774
Atd Number
ATD-4-5677
Bblid
655118
Inspectionid
369394
Inspect Date
2023-12-12T00:00:00.000
Atdissuedate
2023-12-12T14:52:31.000
Cb
6
House Num
66-26
Onstname
SELFRIDGE ST.
Atddismissed
No
13243
Atdid: 13243 • Atd Number: ATD-3-5414 • Bblid: 433108
Atdid
13243
Atd Number
ATD-3-5414
Bblid
433108
Inspectionid
362063
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T16:38:06.000
Cb
12
House Num
1456
Onstname
47TH ST.
Atddismissed
No
13942
Atdid: 13942 • Atd Number: ATD-4-5788 • Bblid: 637740
Atdid
13942
Atd Number
ATD-4-5788
Bblid
637740
Inspectionid
371554
Inspect Date
2024-02-12T00:00:00.000
Atdissuedate
2024-02-12T12:12:45.000
Cb
5
House Num
54-42
Onstname
ARNOLD AVE.
Atddismissed
No
8879
Atdid: 8879 • Atd Number: ATD-4-4019 • Bblid: 646114
Atdid
8879
Atd Number
ATD-4-4019
Bblid
646114
Inspectionid
331921
Inspect Date
2021-12-30T00:00:00.000
Atdissuedate
2022-01-25T20:11:37.000
Cb
4
House Num
84-26
Onstname
55TH RD.
Atddismissed
No
16310
Atdid: 16310 • Atd Number: ATD-3-6387 • Bblid: 274096
Atdid
16310
Atd Number
ATD-3-6387
Bblid
274096
Inspectionid
384507
Inspect Date
2024-10-01T00:00:00.000
Atdissuedate
2024-10-28T15:52:26.000
Cb
6
House Num
121
Onstname
SAINT MARKS PL.
Atddismissed
No
12037
Atdid: 12037 • Atd Number: ATD-3-4930 • Bblid: 332663
Atdid
12037
Atd Number
ATD-3-4930
Bblid
332663
Inspectionid
355875
Inspect Date
2023-04-14T00:00:00.000
Atdissuedate
2023-04-14T14:49:02.000
Cb
1
House Num
130
Onstname
HEWES ST.
Atddismissed
No