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
13381
Atdid: 13381 • Atd Number: ATD-5-813 • Bblid: 947732
Atdid
13381
Atd Number
ATD-5-813
Bblid
947732
Inspectionid
363290
Inspect Date
2023-09-07T00:00:00.000
Atdissuedate
2023-09-11T12:39:12.000
Cb
2
House Num
267
Onstname
MARTIN AVE.
Atddismissed
No
17092
Atdid: 17092 • Atd Number: ATD-5-945 • Bblid: 960248
Atdid
17092
Atd Number
ATD-5-945
Bblid
960248
Inspectionid
392470
Inspect Date
2023-06-16T00:00:00.000
Atdissuedate
2025-03-28T09:12:41.000
Cb
1
House Num
385
Onstname
LATHROP AVE.
Atddismissed
No
8630
Atdid: 8630 • Atd Number: ATD-4-3871 • Bblid: 772464
Atdid
8630
Atd Number
ATD-4-3871
Bblid
772464
Inspectionid
330753
Inspect Date
2021-12-14T00:00:00.000
Atdissuedate
2021-12-15T10:40:06.000
Cb
13
House Num
77-61
Onstname
270TH ST.
Atddismissed
No
9620
Atdid: 9620 • Atd Number: ATD-4-4326 • Bblid: 782793
Atdid
9620
Atd Number
ATD-4-4326
Bblid
782793
Inspectionid
333789
Inspect Date
2019-07-25T00:00:00.000
Atdissuedate
2022-03-15T15:46:07.000
Cb
9
House Num
94-34
Onstname
87TH ST.
Atddismissed
No
16244
Atdid: 16244 • Atd Number: ATD-2-1310 • Bblid: 202455
Atdid
16244
Atd Number
ATD-2-1310
Bblid
202455
Inspectionid
384183
Inspect Date
2024-10-11T00:00:00.000
Atdissuedate
2024-10-15T16:03:42.000
Cb
11
House Num
2015
Onstname
MULINER AVE.
Atddismissed
No
12524
Atdid: 12524 • Atd Number: ATD-4-5342 • Bblid: 802483
Atdid
12524
Atd Number
ATD-4-5342
Bblid
802483
Violationid
281129
Reinspectionid
35364
Inspect Date
2023-06-06T15:40:18.000
Atdissuedate
2023-06-06T15:40:18.000
Cb
10
House Num
107-32
Onstname
LEFFERTS BOULEVARD
Atddismissed
No
14167
Atdid: 14167 • Atd Number: ATD-3-5829 • Bblid: 533570
Atdid
14167
Atd Number
ATD-3-5829
Bblid
533570
Inspectionid
373550
Inspect Date
2024-03-13T00:00:00.000
Atdissuedate
2024-03-19T10:16:24.000
Cb
18
House Num
946
Onstname
E. 83RD ST.
Atddismissed
No
14804
Atdid: 14804 • Atd Number: ATD-3-6144 • Bblid: 458229
Atdid
14804
Atd Number
ATD-3-6144
Bblid
458229
Inspectionid
379870
Inspect Date
2024-07-25T00:00:00.000
Atdissuedate
2024-07-27T10:04:45.000
Cb
11
House Num
1525
Onstname
BAY RIDGE PKWY.
Atddismissed
No
11443
Atdid: 11443 • Atd Number: ATD-1-258 • Bblid: 28458
Atdid
11443
Atd Number
ATD-1-258
Bblid
28458
Inspectionid
348548
Inspect Date
2022-11-10T00:00:00.000
Atdissuedate
2022-11-22T13:23:45.000
Cb
2
House Num
48
Onstname
JANE ST.
Atddismissed
No
12048
Atdid: 12048 • Atd Number: ATD-4-5129 • Bblid: 744753
Atdid
12048
Atd Number
ATD-4-5129
Bblid
744753
Inspectionid
355968
Inspect Date
2023-04-04T00:00:00.000
Atdissuedate
2023-04-17T13:26:22.000
Cb
8
House Num
76-17
Onstname
167TH ST.
Atddismissed
No
9364
Atdid: 9364 • Atd Number: ATD-3-3461 • Bblid: 257537
Atdid
9364
Atd Number
ATD-3-3461
Bblid
257537
Inspectionid
333088
Inspect Date
2021-01-04T00:00:00.000
Atdissuedate
2022-03-03T08:13:29.000
Cb
6
House Num
27
Onstname
4TH PL.
Atddismissed
No
9926
Atdid: 9926 • Atd Number: ATD-3-3639 • Bblid: 259516
Atdid
9926
Atd Number
ATD-3-3639
Bblid
259516
Inspectionid
335303
Inspect Date
2022-04-20T00:00:00.000
Atdissuedate
2022-04-20T15:21:02.000
Cb
6
House Num
440
Onstname
DEGRAW ST.
Atddismissed
No
17067
Atdid: 17067 • Atd Number: ATD-3-6722 • Bblid: 279466
Atdid
17067
Atd Number
ATD-3-6722
Bblid
279466
Inspectionid
392411
Inspect Date
2022-04-22T00:00:00.000
Atdissuedate
2025-03-27T12:06:33.000
Cb
6
House Num
179
Onstname
12 STREET
Atddismissed
Yes
Atddismissedon
2025-08-05T12:51:40.000
10726
Atdid: 10726 • Atd Number: ATD-4-4800 • Bblid: 670717
Atdid
10726
Atd Number
ATD-4-4800
Bblid
670717
Inspectionid
342403
Inspect Date
2022-09-01T00:00:00.000
Atdissuedate
2022-09-01T10:19:20.000
Cb
5
House Num
64-49
Onstname
MADISON ST.
Atddismissed
No
16671
Atdid: 16671 • Atd Number: ATD-4-6556 • Bblid: 735850
Atdid
16671
Atd Number
ATD-4-6556
Bblid
735850
Inspectionid
388582
Inspect Date
2024-10-24T00:00:00.000
Atdissuedate
2025-01-08T15:46:13.000
Cb
8
House Num
76-14
Onstname
VLEIGH PL.
Atddismissed
No
9104
Atdid: 9104 • Atd Number: ATD-4-4153 • Bblid: 657995
Atdid
9104
Atd Number
ATD-4-4153
Bblid
657995
Inspectionid
332655
Inspect Date
2019-06-28T00:00:00.000
Atdissuedate
2022-02-22T15:00:42.000
Cb
6
House Num
68-10
Onstname
FLEET ST.
Atddismissed
No
9681
Atdid: 9681 • Atd Number: ATD-3-3575 • Bblid: 541791
Atdid
9681
Atd Number
ATD-3-3575
Bblid
541791
Inspectionid
333881
Inspect Date
2022-03-16T00:00:00.000
Atdissuedate
2022-03-17T13:29:06.000
Cb
18
House Num
1132
Onstname
E. 103RD ST.
Atddismissed
No
10605
Atdid: 10605 • Atd Number: ATD-1-198 • Bblid: 132774
Atdid
10605
Atd Number
ATD-1-198
Bblid
132774
Inspectionid
340913
Inspect Date
2022-08-01T00:00:00.000
Atdissuedate
2022-08-04T16:09:23.000
Cb
9
House Num
53
Onstname
SAINT NICHOLAS PL.
Atddismissed
No
11187
Atdid: 11187 • Atd Number: ATD-3-4505 • Bblid: 303257
Atdid
11187
Atd Number
ATD-3-4505
Bblid
303257
Inspectionid
346247
Inspect Date
2022-10-15T00:00:00.000
Atdissuedate
2022-10-17T14:32:08.000
Cb
16
House Num
319
Onstname
MARION ST.
Atddismissed
No
14659
Atdid: 14659 • Atd Number: ATD-4-6111 • Bblid: 631819
Atdid
14659
Atd Number
ATD-4-6111
Bblid
631819
Inspectionid
378864
Inspect Date
2024-06-26T00:00:00.000
Atdissuedate
2024-06-26T15:33:36.000
Cb
2
House Num
50-39
Onstname
61ST ST.
Atddismissed
No
17817
Atdid: 17817 • Atd Number: ATD-4-7029 • Bblid: 676313
Atdid
17817
Atd Number
ATD-4-7029
Bblid
676313
Inspectionid
399335
Inspect Date
2025-06-04T00:00:00.000
Atdissuedate
2025-06-06T15:09:56.000
Cb
5
House Num
77-26
Onstname
76TH ST.
Atddismissed
No
10721
Atdid: 10721 • Atd Number: ATD-3-4104 • Bblid: 311192
Atdid
10721
Atd Number
ATD-3-4104
Bblid
311192
Inspectionid
342345
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-08-31T13:17:34.000
Cb
3
House Num
370
Onstname
MACDONOUGH ST.
Atddismissed
No
12716
Atdid: 12716 • Atd Number: ATD-5-751 • Bblid: 1007986
Atdid
12716
Atd Number
ATD-5-751
Bblid
1007986
Inspectionid
359127
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-29T15:50:13.000
Cb
3
Onstname
ARTHUR KILL ROAD
Atddismissed
No
13542
Atdid: 13542 • Atd Number: ATD-4-5581 • Bblid: 717912
Atdid
13542
Atd Number
ATD-4-5581
Bblid
717912
Inspectionid
364896
Inspect Date
2023-10-04T00:00:00.000
Atdissuedate
2023-10-04T14:57:05.000
Cb
11
House Num
49-75
Onstname
175TH PL.
Atddismissed
No
14721
Atdid: 14721 • Atd Number: ATD-4-6139 • Bblid: 631866
Atdid
14721
Atd Number
ATD-4-6139
Bblid
631866
Inspectionid
379266
Inspect Date
2024-06-03T00:00:00.000
Atdissuedate
2024-07-11T12:33:24.000
Cb
2
House Num
51-21
Onstname
64TH ST.
Atddismissed
No
14192
Atdid: 14192 • Atd Number: ATD-3-5852 • Bblid: 532368
Atdid
14192
Atd Number
ATD-3-5852
Bblid
532368
Inspectionid
373810
Inspect Date
2024-03-20T00:00:00.000
Atdissuedate
2024-03-20T14:47:26.000
Cb
18
House Num
623
Onstname
E. 83RD ST.
Atddismissed
No
8691
Atdid: 8691 • Atd Number: ATD-4-3913 • Bblid: 886715
Atdid
8691
Atd Number
ATD-4-3913
Bblid
886715
Inspectionid
330860
Inspect Date
2018-10-16T00:00:00.000
Atdissuedate
2021-12-17T11:42:19.000
Cb
13
House Num
134-33
Onstname
225TH ST.
Atddismissed
No
13831
Atdid: 13831 • Atd Number: ATD-4-5722 • Bblid: 631243
Atdid
13831
Atd Number
ATD-4-5722
Bblid
631243
Inspectionid
370303
Inspect Date
2023-11-24T00:00:00.000
Atdissuedate
2024-01-02T13:48:45.000
Cb
2
House Num
50-25
Onstname
48TH ST.
Atddismissed
No
14697
Atdid: 14697 • Atd Number: ATD-3-6105 • Bblid: 488046
Atdid
14697
Atd Number
ATD-3-6105
Bblid
488046
Inspectionid
379079
Inspect Date
2024-06-29T00:00:00.000
Atdissuedate
2024-07-08T10:11:18.000
Cb
11
House Num
126
Onstname
BAY 41ST ST.
Atddismissed
No
16214
Atdid: 16214 • Atd Number: ATD-4-6363 • Bblid: 733502
Atdid
16214
Atd Number
ATD-4-6363
Bblid
733502
Inspectionid
384090
Inspect Date
2021-06-16T00:00:00.000
Atdissuedate
2024-10-15T09:57:26.000
Cb
8
House Num
148-42
Onstname
61ST RD.
Atddismissed
No
13984
Atdid: 13984 • Atd Number: ATD-4-5815 • Bblid: 583540
Atdid
13984
Atd Number
ATD-4-5815
Bblid
583540
Inspectionid
371948
Inspect Date
2024-01-26T00:00:00.000
Atdissuedate
2024-02-20T11:19:08.000
Cb
1
House Num
25-50
Onstname
47TH ST.
Atddismissed
No
10993
Atdid: 10993 • Atd Number: ATD-3-4346 • Bblid: 318205
Atdid
10993
Atd Number
ATD-3-4346
Bblid
318205
Inspectionid
344474
Inspect Date
2022-09-17T00:00:00.000
Atdissuedate
2022-09-23T16:47:20.000
Cb
3
House Num
476A
Onstname
JEFFERSON AVENUE
Atddismissed
No
17364
Atdid: 17364 • Atd Number: ATD-3-6883 • Bblid: 284522
Atdid
17364
Atd Number
ATD-3-6883
Bblid
284522
Inspectionid
394668
Inspect Date
2025-04-08T00:00:00.000
Atdissuedate
2025-04-14T15:15:36.000
Cb
7
House Num
1622
Onstname
8TH AVE.
Atddismissed
No
9200
Atdid: 9200 • Atd Number: ATD-1-182 • Bblid: 75471
Atdid
9200
Atd Number
ATD-1-182
Bblid
75471
Inspectionid
332858
Inspect Date
2016-01-20T00:00:00.000
Atdissuedate
2022-02-28T17:37:00.000
Cb
7
House Num
166
Onstname
W. 88TH ST.
Atddismissed
No
11215
Atdid: 11215 • Atd Number: ATD-4-4852 • Bblid: 653769
Atdid
11215
Atd Number
ATD-4-4852
Bblid
653769
Inspectionid
346462
Inspect Date
2022-10-13T00:00:00.000
Atdissuedate
2022-10-19T11:44:47.000
Cb
6
House Num
63-21
Onstname
HARING ST.
Atddismissed
No
12055
Atdid: 12055 • Atd Number: ATD-4-5134 • Bblid: 745285
Atdid
12055
Atd Number
ATD-4-5134
Bblid
745285
Inspectionid
355979
Inspect Date
2023-04-05T00:00:00.000
Atdissuedate
2023-04-17T13:44:41.000
Cb
8
House Num
76-35
Onstname
167TH ST.
Atddismissed
No
13335
Atdid: 13335 • Atd Number: ATD-3-5477 • Bblid: 400540
Atdid
13335
Atd Number
ATD-3-5477
Bblid
400540
Inspectionid
362673
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-28T11:44:05.000
Cb
17
House Num
7
Onstname
FAIRVIEW PL.
Atddismissed
No
8875
Atdid: 8875 • Atd Number: ATD-3-3241 • Bblid: 506214
Atdid
8875
Atd Number
ATD-3-3241
Bblid
506214
Inspectionid
331872
Inspect Date
2022-01-25T00:00:00.000
Atdissuedate
2022-01-25T10:36:12.000
Cb
15
House Num
2126
Onstname
E. 19TH ST.
Atddismissed
No
9615
Atdid: 9615 • Atd Number: ATD-4-4321 • Bblid: 893586
Atdid
9615
Atd Number
ATD-4-4321
Bblid
893586
Inspectionid
333777
Inspect Date
2022-03-15T00:00:00.000
Atdissuedate
2022-03-15T14:12:42.000
Cb
13
House Num
144-20
Onstname
226TH ST.
Atddismissed
No
11977
Atdid: 11977 • Atd Number: ATD-4-5096 • Bblid: 662214
Atdid
11977
Atd Number
ATD-4-5096
Bblid
662214
Inspectionid
354442
Inspect Date
2023-04-04T00:00:00.000
Atdissuedate
2023-04-05T11:14:12.000
Cb
9
House Num
83-24
Onstname
TALBOT ST.
Atddismissed
No
10134
Atdid: 10134 • Atd Number: ATD-3-3748 • Bblid: 305839
Atdid
10134
Atd Number
ATD-3-3748
Bblid
305839
Inspectionid
336797
Inspect Date
2022-05-18T00:00:00.000
Atdissuedate
2022-05-23T12:18:55.000
Cb
16
House Num
12
Onstname
JARDINE PL.
Atddismissed
No
13765
Atdid: 13765 • Atd Number: ATD-4-5671 • Bblid: 789362
Atdid
13765
Atd Number
ATD-4-5671
Bblid
789362
Inspectionid
369265
Inspect Date
2023-12-06T00:00:00.000
Atdissuedate
2023-12-11T11:42:10.000
Cb
9
House Num
121-12
Onstname
84TH AVE.
Atddismissed
No
10821
Atdid: 10821 • Atd Number: ATD-3-4192 • Bblid: 309117
Atdid
10821
Atd Number
ATD-3-4192
Bblid
309117
Inspectionid
343316
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-09-12T09:49:36.000
Cb
3
House Num
553
Onstname
HANCOCK ST.
Atddismissed
No
13729
Atdid: 13729 • Atd Number: ATD-3-5661 • Bblid: 498209
Atdid
13729
Atd Number
ATD-3-5661
Bblid
498209
Inspectionid
368812
Inspect Date
2023-12-01T00:00:00.000
Atdissuedate
2023-12-05T09:10:16.000
Cb
15
House Num
288
Onstname
AVENUE W.
Atddismissed
No
13552
Atdid: 13552 • Atd Number: ATD-3-5570 • Bblid: 564401
Atdid
13552
Atd Number
ATD-3-5570
Bblid
564401
Inspectionid
365043
Inspect Date
2023-10-03T00:00:00.000
Atdissuedate
2023-10-10T11:18:45.000
Cb
15
House Num
2984
Onstname
GERRITSEN AVE.
Atddismissed
No
9121
Atdid: 9121 • Atd Number: ATD-3-3312 • Bblid: 333424
Atdid
9121
Atd Number
ATD-3-3312
Bblid
333424
Inspectionid
332672
Inspect Date
2020-10-28T00:00:00.000
Atdissuedate
2022-02-23T08:12:28.000
Cb
1
House Num
203
Onstname
LEE AVE.
Atddismissed
No
9414
Atdid: 9414 • Atd Number: ATD-4-4215 • Bblid: 683617
Atdid
9414
Atd Number
ATD-4-4215
Bblid
683617
Inspectionid
333187
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-03-04T10:32:53.000
Cb
7
House Num
17-32
Onstname
PARSONS BLVD.
Atddismissed
No
12155
Atdid: 12155 • Atd Number: ATD-3-4986 • Bblid: 258045
Atdid
12155
Atd Number
ATD-3-4986
Bblid
258045
Inspectionid
356690
Inspect Date
2023-05-05T00:00:00.000
Atdissuedate
2023-05-05T14:03:43.000
Cb
2
House Num
157
Onstname
WYCKOFF ST.
Atddismissed
No
9708
Atdid: 9708 • Atd Number: ATD-4-4392 • Bblid: 752629
Atdid
9708
Atd Number
ATD-4-4392
Bblid
752629
Inspectionid
334121
Inspect Date
2021-04-06T00:00:00.000
Atdissuedate
2022-03-24T16:48:38.000
Cb
11
House Num
50-03
Onstname
FRANCIS LEWIS BLVD.
Atddismissed
No
18369
Atdid: 18369 • Atd Number: ATD-3-7246 • Bblid: 251311
Atdid
18369
Atd Number
ATD-3-7246
Bblid
251311
Inspectionid
404494
Inspect Date
2025-08-07T00:00:00.000
Atdissuedate
2025-08-19T09:39:41.000
Cb
2
House Num
260
Onstname
DEAN ST.
Atddismissed
No