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
9254
Atdid: 9254 • Atd Number: ATD-3-3381 • Bblid: 471438
Atdid
9254
Atd Number
ATD-3-3381
Bblid
471438
Inspectionid
332960
Inspect Date
2021-05-07T00:00:00.000
Atdissuedate
2022-03-01T17:33:21.000
Cb
12
House Num
1316
Onstname
E. 5TH ST.
Atddismissed
No
10978
Atdid: 10978 • Atd Number: ATD-3-4331 • Bblid: 520476
Atdid
10978
Atd Number
ATD-3-4331
Bblid
520476
Inspectionid
344387
Inspect Date
2022-09-23T00:00:00.000
Atdissuedate
2022-09-23T12:31:52.000
Cb
18
House Num
1758
Onstname
E. 32ND ST.
Atddismissed
No
17181
Atdid: 17181 • Atd Number: ATD-4-6694 • Bblid: 896396
Atdid
17181
Atd Number
ATD-4-6694
Bblid
896396
Inspectionid
392717
Inspect Date
2022-07-08T00:00:00.000
Atdissuedate
2025-03-31T11:41:22.000
Cb
13
House Num
253-40
Onstname
149TH RD.
Atddismissed
No
13515
Atdid: 13515 • Atd Number: ATD-5-833 • Bblid: 963368
Atdid
13515
Atd Number
ATD-5-833
Bblid
963368
Inspectionid
364689
Inspect Date
2023-09-28T00:00:00.000
Atdissuedate
2023-10-02T12:20:42.000
Cb
2
House Num
291
Onstname
LANDER AVE.
Atddismissed
No
13570
Atdid: 13570 • Atd Number: ATD-3-5586 • Bblid: 418501
Atdid
13570
Atd Number
ATD-3-5586
Bblid
418501
Inspectionid
365134
Inspect Date
2023-10-06T00:00:00.000
Atdissuedate
2023-10-10T16:16:35.000
Cb
12
House Num
1469
Onstname
40TH ST.
Atddismissed
No
13961
Atdid: 13961 • Atd Number: ATD-4-5798 • Bblid: 773759
Atdid
13961
Atd Number
ATD-4-5798
Bblid
773759
Violationid
288778
Reinspectionid
36250
Inspect Date
2024-02-15T10:09:56.000
Atdissuedate
2024-02-15T10:09:56.000
Cb
13
House Num
81-18
Onstname
262 STREET
Atddismissed
Yes
Atddismissedon
2024-03-06T18:40:22.000
10230
Atdid: 10230 • Atd Number: ATD-3-3809 • Bblid: 332766
Atdid
10230
Atd Number
ATD-3-3809
Bblid
332766
Inspectionid
337354
Inspect Date
2022-06-03T00:00:00.000
Atdissuedate
2022-06-06T12:09:42.000
Cb
1
House Num
104
Onstname
PENN ST.
Atddismissed
Yes
Atddismissedon
2022-06-06T12:11:27.000
12832
Atdid: 12832 • Atd Number: ATD-4-5429 • Bblid: 739452
Atdid
12832
Atd Number
ATD-4-5429
Bblid
739452
Inspectionid
359929
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-07-13T11:07:23.000
Cb
7
House Num
163-19
Onstname
HORACE HARDING EXPWY
Atddismissed
No
14388
Atdid: 14388 • Atd Number: ATD-3-5939 • Bblid: 417124
Atdid
14388
Atd Number
ATD-3-5939
Bblid
417124
Inspectionid
376553
Inspect Date
2024-01-27T00:00:00.000
Atdissuedate
2024-05-02T13:13:39.000
Cb
12
House Num
3325
Onstname
12TH AVE.
Atddismissed
No
18624
Atdid: 18624 • Atd Number: ATD-4-7386 • Bblid: 899329
Atdid
18624
Atd Number
ATD-4-7386
Bblid
899329
Inspectionid
406105
Inspect Date
2025-09-11T00:00:00.000
Atdissuedate
2025-09-18T13:45:43.000
Cb
10
House Num
157-32
Onstname
87TH ST.
Atddismissed
No
13881
Atdid: 13881 • Atd Number: ATD-3-5707 • Bblid: 399026
Atdid
13881
Atd Number
ATD-3-5707
Bblid
399026
Inspectionid
370852
Inspect Date
2024-01-23T00:00:00.000
Atdissuedate
2024-01-23T13:03:30.000
Cb
9
House Num
493
Onstname
RUTLAND RD.
Atddismissed
No
18384
Atdid: 18384 • Atd Number: ATD-4-7276 • Bblid: 887059
Atdid
18384
Atd Number
ATD-4-7276
Bblid
887059
Inspectionid
404548
Inspect Date
2025-08-05T00:00:00.000
Atdissuedate
2025-08-20T13:55:41.000
Cb
13
House Num
136-19
Onstname
222ND ST.
Atddismissed
No
17555
Atdid: 17555 • Atd Number: ATD-2-1393 • Bblid: 207632
Atdid
17555
Atd Number
ATD-2-1393
Bblid
207632
Inspectionid
396345
Inspect Date
2025-05-02T00:00:00.000
Atdissuedate
2025-05-06T16:40:57.000
Cb
11
House Num
2431
Onstname
DELANOY AVE.
Atddismissed
No
13943
Atdid: 13943 • Atd Number: ATD-4-5789 • Bblid: 741846
Atdid
13943
Atd Number
ATD-4-5789
Bblid
741846
Inspectionid
371568
Inspect Date
2024-02-10T00:00:00.000
Atdissuedate
2024-02-12T12:53:15.000
Cb
11
House Num
59-05
Onstname
174TH ST.
Atddismissed
No
17120
Atdid: 17120 • Atd Number: ATD-3-6766 • Bblid: 503141
Atdid
17120
Atd Number
ATD-3-6766
Bblid
503141
Inspectionid
392520
Inspect Date
2023-07-08T00:00:00.000
Atdissuedate
2025-03-28T14:58:46.000
Cb
15
House Num
1968
Onstname
E. 22ND ST.
Atddismissed
No
9927
Atdid: 9927 • Atd Number: ATD-5-663 • Bblid: 1033619
Atdid
9927
Atd Number
ATD-5-663
Bblid
1033619
Inspectionid
335307
Inspect Date
2021-12-07T00:00:00.000
Atdissuedate
2022-04-21T10:31:01.000
Cb
3
House Num
10
Onstname
LISA LN.
Atddismissed
No
11822
Atdid: 11822 • Atd Number: ATD-2-991 • Bblid: 215960
Atdid
11822
Atd Number
ATD-2-991
Bblid
215960
Inspectionid
353309
Inspect Date
2023-03-15T00:00:00.000
Atdissuedate
2023-03-20T11:03:21.000
Cb
12
House Num
3326
Onstname
FENTON AVE.
Atddismissed
No
12482
Atdid: 12482 • Atd Number: ATD-2-1130 • Bblid: 236803
Atdid
12482
Atd Number
ATD-2-1130
Bblid
236803
Inspectionid
358008
Inspect Date
2023-05-26T00:00:00.000
Atdissuedate
2023-06-02T11:38:19.000
Cb
10
House Num
194
Onstname
THROGS NECK BLVD
Atddismissed
No
12831
Atdid: 12831 • Atd Number: ATD-4-5428 • Bblid: 710502
Atdid
12831
Atd Number
ATD-4-5428
Bblid
710502
Inspectionid
359905
Inspect Date
2023-07-10T00:00:00.000
Atdissuedate
2023-07-13T07:24:01.000
Cb
7
House Num
35-26
Onstname
168TH ST.
Atddismissed
No
11338
Atdid: 11338 • Atd Number: ATD-3-4612 • Bblid: 277451
Atdid
11338
Atd Number
ATD-3-4612
Bblid
277451
Inspectionid
347629
Inspect Date
2022-11-04T00:00:00.000
Atdissuedate
2022-11-07T10:19:04.000
Cb
6
House Num
367
Onstname
4TH ST.
Atddismissed
No
11893
Atdid: 11893 • Atd Number: ATD-4-5070 • Bblid: 727669
Atdid
11893
Atd Number
ATD-4-5070
Bblid
727669
Inspectionid
353931
Inspect Date
2023-03-08T00:00:00.000
Atdissuedate
2023-03-27T12:07:45.000
Cb
11
House Num
201-08
Onstname
36TH AVE.
Atddismissed
No
12844
Atdid: 12844 • Atd Number: ATD-4-5441 • Bblid: 645295
Atdid
12844
Atd Number
ATD-4-5441
Bblid
645295
Inspectionid
359945
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-07-13T12:16:11.000
Cb
4
House Num
86-17
Onstname
57TH RD.
Atddismissed
No
9248
Atdid: 9248 • Atd Number: ATD-3-3378 • Bblid: 469457
Atdid
9248
Atd Number
ATD-3-3378
Bblid
469457
Inspectionid
332954
Inspect Date
2020-11-25T00:00:00.000
Atdissuedate
2022-03-01T17:29:16.000
Cb
11
House Num
8893
Onstname
18TH AVE.
Atddismissed
No
11037
Atdid: 11037 • Atd Number: ATD-3-4387 • Bblid: 318190
Atdid
11037
Atd Number
ATD-3-4387
Bblid
318190
Inspectionid
344671
Inspect Date
2022-09-22T00:00:00.000
Atdissuedate
2022-09-28T12:23:57.000
Cb
3
House Num
452
Onstname
JEFFERSON AVE.
Atddismissed
No
8666
Atdid: 8666 • Atd Number: ATD-4-3893 • Bblid: 808166
Atdid
8666
Atd Number
ATD-4-3893
Bblid
808166
Inspectionid
330835
Inspect Date
2019-06-12T00:00:00.000
Atdissuedate
2021-12-16T10:57:24.000
Cb
8
House Num
84-63
Onstname
168TH PL.
Atddismissed
No
16307
Atdid: 16307 • Atd Number: ATD-3-6384 • Bblid: 274134
Atdid
16307
Atd Number
ATD-3-6384
Bblid
274134
Inspectionid
384501
Inspect Date
2024-10-01T00:00:00.000
Atdissuedate
2024-10-28T15:28:08.000
Cb
6
House Num
83
Onstname
SAINT MARKS PL.
Atddismissed
No
11275
Atdid: 11275 • Atd Number: ATD-4-4857 • Bblid: 617675
Atdid
11275
Atd Number
ATD-4-4857
Bblid
617675
Inspectionid
347042
Inspect Date
2022-10-20T00:00:00.000
Atdissuedate
2022-10-26T15:14:18.000
Cb
3
House Num
101-17
Onstname
34TH AVE.
Atddismissed
No
10701
Atdid: 10701 • Atd Number: ATD-3-4084 • Bblid: 554719
Atdid
10701
Atd Number
ATD-3-4084
Bblid
554719
Inspectionid
342112
Inspect Date
2022-08-23T00:00:00.000
Atdissuedate
2022-08-29T09:04:47.000
Cb
18
House Num
2765
Onstname
E. 64TH ST.
Atddismissed
No
8643
Atdid: 8643 • Atd Number: ATD-3-3167 • Bblid: 282777
Atdid
8643
Atd Number
ATD-3-3167
Bblid
282777
Inspectionid
330781
Inspect Date
2019-05-15T00:00:00.000
Atdissuedate
2021-12-15T15:52:08.000
Cb
6
House Num
561
Onstname
7TH ST.
Atddismissed
No
9226
Atdid: 9226 • Atd Number: ATD-4-4197 • Bblid: 783509
Atdid
9226
Atd Number
ATD-4-4197
Bblid
783509
Inspectionid
332889
Inspect Date
2022-03-01T00:00:00.000
Atdissuedate
2022-03-01T13:07:32.000
Cb
9
House Num
97-14
Onstname
76TH ST.
Atddismissed
No
14843
Atdid: 14843 • Atd Number: ATD-5-874 • Bblid: 1026666
Atdid
14843
Atd Number
ATD-5-874
Bblid
1026666
Violationid
294643
Reinspectionid
37049
Inspect Date
2024-08-01T13:09:18.000
Atdissuedate
2024-08-01T13:09:18.000
Cb
3
House Num
46
Onstname
VAN BRUNT STREET
Atddismissed
Yes
Atddismissedon
2025-05-08T12:37:22.000
11523
Atdid: 11523 • Atd Number: ATD-4-4916 • Bblid: 773757
Atdid
11523
Atd Number
ATD-4-4916
Bblid
773757
Inspectionid
349450
Inspect Date
2022-12-15T00:00:00.000
Atdissuedate
2022-12-16T13:59:41.000
Cb
13
House Num
81-14
Onstname
262ND ST.
Atddismissed
Yes
Atddismissedon
2023-04-27T17:08:45.000
14125
Atdid: 14125 • Atd Number: ATD-4-5884 • Bblid: 805157
Atdid
14125
Atd Number
ATD-4-5884
Bblid
805157
Inspectionid
373304
Inspect Date
2024-03-16T00:00:00.000
Atdissuedate
2024-03-16T10:11:45.000
Cb
8
House Num
85-50
Onstname
150TH ST.
Atddismissed
No
12328
Atdid: 12328 • Atd Number: ATD-4-5195 • Bblid: 656925
Atdid
12328
Atd Number
ATD-4-5195
Bblid
656925
Inspectionid
357388
Inspect Date
2023-04-06T00:00:00.000
Atdissuedate
2023-05-19T13:19:38.000
Cb
6
House Num
93-17
Onstname
68TH AVE.
Atddismissed
No
17950
Atdid: 17950 • Atd Number: ATD-3-7067 • Bblid: 282194
Atdid
17950
Atd Number
ATD-3-7067
Bblid
282194
Inspectionid
400756
Inspect Date
2025-06-10T00:00:00.000
Atdissuedate
2025-06-23T11:18:02.000
Cb
6
House Num
20
Onstname
POLHEMUS PL.
Atddismissed
No
3663
Atdid: 3663 • Atd Number: ATD-3-2448 • Bblid: 260064
Atdid
3663
Atd Number
ATD-3-2448
Bblid
260064
Violationid
259932
Atdissuedate
2020-03-12T00:00:00.000
Cb
6
House Num
345
Onstname
PRESIDENT STREET
Atddismissed
Yes
Atddismissedon
2023-11-13T12:38:13.000
9655
Atdid: 9655 • Atd Number: ATD-4-4358 • Bblid: 797679
Atdid
9655
Atd Number
ATD-4-4358
Bblid
797679
Inspectionid
333852
Inspect Date
2019-08-09T00:00:00.000
Atdissuedate
2022-03-16T15:19:05.000
Cb
9
House Num
102-04
Onstname
VAN WYCK EXPY.
Atddismissed
No
10000
Atdid: 10000 • Atd Number: ATD-4-4552 • Bblid: 654501
Atdid
10000
Atd Number
ATD-4-4552
Bblid
654501
Inspectionid
335834
Inspect Date
2022-04-19T00:00:00.000
Atdissuedate
2022-04-29T14:08:25.000
Cb
6
House Num
64-37
Onstname
ELLWELL CRES
Atddismissed
No
12163
Atdid: 12163 • Atd Number: ATD-3-4993 • Bblid: 323067
Atdid
12163
Atd Number
ATD-3-4993
Bblid
323067
Inspectionid
356713
Inspect Date
2022-04-28T00:00:00.000
Atdissuedate
2023-05-06T13:10:44.000
Cb
2
House Num
332
Onstname
CLINTON AVE.
Atddismissed
No
10457
Atdid: 10457 • Atd Number: ATD-3-3937 • Bblid: 425002
Atdid
10457
Atd Number
ATD-3-3937
Bblid
425002
Inspectionid
339469
Inspect Date
2022-07-06T00:00:00.000
Atdissuedate
2022-07-14T09:04:03.000
Cb
12
House Num
1548
Onstname
55TH ST.
Atddismissed
No
9100
Atdid: 9100 • Atd Number: ATD-4-4149 • Bblid: 657213
Atdid
9100
Atd Number
ATD-4-4149
Bblid
657213
Inspectionid
332651
Inspect Date
2019-06-28T00:00:00.000
Atdissuedate
2022-02-22T14:52:09.000
Cb
6
House Num
67-47
Onstname
GROTON ST.
Atddismissed
No
15080
Atdid: 15080 • Atd Number: ATD-4-6288 • Bblid: 747915
Atdid
15080
Atd Number
ATD-4-6288
Bblid
747915
Inspectionid
382100
Inspect Date
2024-08-20T00:00:00.000
Atdissuedate
2024-09-23T11:42:12.000
Cb
8
House Num
73-48
Onstname
193RD ST.
Atddismissed
No
9507
Atdid: 9507 • Atd Number: ATD-3-3537 • Bblid: 284182
Atdid
9507
Atd Number
ATD-3-3537
Bblid
284182
Inspectionid
333438
Inspect Date
2021-08-20T00:00:00.000
Atdissuedate
2022-03-09T09:05:10.000
Cb
6
House Num
453
Onstname
14TH ST.
Atddismissed
No
8958
Atdid: 8958 • Atd Number: ATD-4-4057 • Bblid: 896305
Atdid
8958
Atd Number
ATD-4-4057
Bblid
896305
Inspectionid
332259
Inspect Date
2019-07-18T00:00:00.000
Atdissuedate
2022-02-04T12:28:22.000
Cb
13
House Num
147-62
Onstname
253RD ST.
Atddismissed
No
8921
Atdid: 8921 • Atd Number: ATD-4-4041 • Bblid: 689855
Atdid
8921
Atd Number
ATD-4-4041
Bblid
689855
Inspectionid
332148
Inspect Date
2019-08-28T00:00:00.000
Atdissuedate
2022-01-31T09:16:15.000
Cb
7
House Num
14-55
Onstname
166TH ST.
Atddismissed
No
16666
Atdid: 16666 • Atd Number: ATD-3-6534 • Bblid: 277675
Atdid
16666
Atd Number
ATD-3-6534
Bblid
277675
Inspectionid
388562
Inspect Date
2025-01-03T00:00:00.000
Atdissuedate
2025-01-08T14:15:38.000
Cb
6
House Num
350
Onstname
4TH ST.
Atddismissed
No
10597
Atdid: 10597 • Atd Number: ATD-3-4022 • Bblid: 319089
Atdid
10597
Atd Number
ATD-3-4022
Bblid
319089
Inspectionid
340889
Inspect Date
2022-07-26T00:00:00.000
Atdissuedate
2022-08-04T14:38:52.000
Cb
3
House Num
327
Onstname
JEFFERSON AVE.
Atddismissed
No
10592
Atdid: 10592 • Atd Number: ATD-3-4019 • Bblid: 415344
Atdid
10592
Atd Number
ATD-3-4019
Bblid
415344
Inspectionid
340791
Inspect Date
2022-06-02T00:00:00.000
Atdissuedate
2022-08-02T13:17:32.000
Cb
7
House Num
327
Onstname
VANDERBILT ST.
Atddismissed
No
18399
Atdid: 18399 • Atd Number: ATD-3-7253 • Bblid: 484710
Atdid
18399
Atd Number
ATD-3-7253
Bblid
484710
Inspectionid
404660
Inspect Date
2025-08-21T00:00:00.000
Atdissuedate
2025-08-22T08:56:26.000
Cb
15
House Num
1885
Onstname
E. 21ST ST.
Atddismissed
No
10533
Atdid: 10533 • Atd Number: ATD-3-3983 • Bblid: 329494
Atdid
10533
Atd Number
ATD-3-3983
Bblid
329494
Inspectionid
340227
Inspect Date
2022-07-12T00:00:00.000
Atdissuedate
2022-07-21T11:56:00.000
Cb
2
House Num
378
Onstname
ADELPHI ST.
Atddismissed
No