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
9427
Atdid: 9427 • Atd Number: ATD-4-4228 • Bblid: 683613
Atdid
9427
Atd Number
ATD-4-4228
Bblid
683613
Inspectionid
333233
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-03-04T11:43:11.000
Cb
7
House Num
17-24
Onstname
PARSONS BLVD.
Atddismissed
No
17774
Atdid: 17774 • Atd Number: ATD-4-7001 • Bblid: 771333
Atdid
17774
Atd Number
ATD-4-7001
Bblid
771333
Inspectionid
398937
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-06-02T11:41:00.000
Cb
13
House Num
86-20
Onstname
254TH ST.
Atddismissed
No
14603
Atdid: 14603 • Atd Number: ATD-3-6044 • Bblid: 504843
Atdid
14603
Atd Number
ATD-3-6044
Bblid
504843
Violationid
281895
Reinspectionid
35551
Inspect Date
2024-06-17T11:31:21.000
Atdissuedate
2024-06-17T11:31:21.000
Cb
15
House Num
2063
Onstname
EAST 26 STREET
Atddismissed
No
14341
Atdid: 14341 • Atd Number: ATD-4-5990 • Bblid: 649182
Atdid
14341
Atd Number
ATD-4-5990
Bblid
649182
Inspectionid
375986
Inspect Date
2024-04-17T00:00:00.000
Atdissuedate
2024-04-23T13:33:44.000
Cb
5
House Num
75-20
Onstname
JUNIPER BLVD. S.
Atddismissed
No
10320
Atdid: 10320 • Atd Number: ATD-4-4676 • Bblid: 834948
Atdid
10320
Atd Number
ATD-4-4676
Bblid
834948
Inspectionid
337928
Inspect Date
2022-06-15T00:00:00.000
Atdissuedate
2022-06-21T14:49:57.000
Cb
12
House Num
194-07
Onstname
112TH AVE.
Atddismissed
No
10231
Atdid: 10231 • Atd Number: ATD-3-3810 • Bblid: 332764
Atdid
10231
Atd Number
ATD-3-3810
Bblid
332764
Inspectionid
337359
Inspect Date
2022-06-03T00:00:00.000
Atdissuedate
2022-06-06T12:26:08.000
Cb
1
House Num
102
Onstname
PENN ST.
Atddismissed
Yes
Atddismissedon
2023-02-23T10:15:13.000
10403
Atdid: 10403 • Atd Number: ATD-5-666 • Bblid: 1033607
Atdid
10403
Atd Number
ATD-5-666
Bblid
1033607
Inspectionid
338912
Inspect Date
2021-12-07T00:00:00.000
Atdissuedate
2022-07-08T09:56:48.000
Cb
3
House Num
24
Onstname
LISA LN.
Atddismissed
No
13612
Atdid: 13612 • Atd Number: ATD-4-5611 • Bblid: 896841
Atdid
13612
Atd Number
ATD-4-5611
Bblid
896841
Inspectionid
365698
Inspect Date
2023-10-04T00:00:00.000
Atdissuedate
2023-10-23T13:51:52.000
Cb
13
House Num
255-31
Onstname
148TH DR.
Atddismissed
No
17427
Atdid: 17427 • Atd Number: ATD-4-6801 • Bblid: 861894
Atdid
17427
Atd Number
ATD-4-6801
Bblid
861894
Inspectionid
395239
Inspect Date
2025-04-16T00:00:00.000
Atdissuedate
2025-04-24T13:32:15.000
Cb
12
House Num
114-39
Onstname
148TH ST.
Atddismissed
No
12576
Atdid: 12576 • Atd Number: ATD-2-1153 • Bblid: 194440
Atdid
12576
Atd Number
ATD-2-1153
Bblid
194440
Inspectionid
358577
Inspect Date
2023-06-15T00:00:00.000
Atdissuedate
2023-06-15T09:57:45.000
Cb
10
House Num
2501
Onstname
FRISBY AVE.
Atddismissed
No
18253
Atdid: 18253 • Atd Number: ATD-3-7205 • Bblid: 307488
Atdid
18253
Atd Number
ATD-3-7205
Bblid
307488
Inspectionid
403611
Inspect Date
2025-07-25T00:00:00.000
Atdissuedate
2025-08-05T11:33:30.000
Cb
3
House Num
946
Onstname
GREENE AVE.
Atddismissed
No
8492
Atdid: 8492 • Atd Number: ATD-3-3095 • Bblid: 315510
Atdid
8492
Atd Number
ATD-3-3095
Bblid
315510
Inspectionid
329616
Inspect Date
2021-11-10T00:00:00.000
Atdissuedate
2021-11-15T11:18:04.000
Cb
3
House Num
250
Onstname
CLIFTON PL.
Atddismissed
No
13054
Atdid: 13054 • Atd Number: ATD-3-5298 • Bblid: 422506
Atdid
13054
Atd Number
ATD-3-5298
Bblid
422506
Inspectionid
361048
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T16:26:50.000
Cb
12
House Num
1672
Onstname
45TH ST.
Atddismissed
No
9125
Atdid: 9125 • Atd Number: ATD-3-3316 • Bblid: 343261
Atdid
9125
Atd Number
ATD-3-3316
Bblid
343261
Inspectionid
332676
Inspect Date
2019-04-03T00:00:00.000
Atdissuedate
2022-02-23T08:24:23.000
Cb
1
House Num
293
Onstname
KINGSLAND AVE.
Atddismissed
No
9870
Atdid: 9870 • Atd Number: ATD-4-4479 • Bblid: 895211
Atdid
9870
Atd Number
ATD-4-4479
Bblid
895211
Inspectionid
334907
Inspect Date
2022-04-14T00:00:00.000
Atdissuedate
2022-04-14T14:13:45.000
Cb
13
House Num
257-23
Onstname
147TH AVE.
Atddismissed
No
18258
Atdid: 18258 • Atd Number: ATD-4-7205 • Bblid: 856057
Atdid
18258
Atd Number
ATD-4-7205
Bblid
856057
Inspectionid
403632
Inspect Date
2025-08-05T00:00:00.000
Atdissuedate
2025-08-05T12:07:25.000
Cb
10
House Num
133-27
Onstname
114TH PL.
Atddismissed
No
10611
Atdid: 10611 • Atd Number: ATD-3-4031 • Bblid: 342876
Atdid
10611
Atd Number
ATD-3-4031
Bblid
342876
Inspectionid
341011
Inspect Date
2022-07-12T00:00:00.000
Atdissuedate
2022-08-08T10:49:44.000
Cb
1
House Num
585
Onstname
LEONARD ST.
Atddismissed
No
13654
Atdid: 13654 • Atd Number: ATD-4-5622 • Bblid: 735276
Atdid
13654
Atd Number
ATD-4-5622
Bblid
735276
Inspectionid
366290
Inspect Date
2023-11-04T00:00:00.000
Atdissuedate
2023-11-04T10:10:53.000
Cb
8
House Num
136-70
Onstname
71ST RD.
Atddismissed
Yes
Atddismissedon
2024-03-08T17:57:54.000
11030
Atdid: 11030 • Atd Number: ATD-2-952 • Bblid: 154794
Atdid
11030
Atd Number
ATD-2-952
Bblid
154794
Inspectionid
344658
Inspect Date
2022-09-24T00:00:00.000
Atdissuedate
2022-09-28T08:18:19.000
Cb
5
House Num
1821
Onstname
PALISADE PL.
Atddismissed
No
8942
Atdid: 8942 • Atd Number: ATD-3-3268 • Bblid: 473744
Atdid
8942
Atd Number
ATD-3-3268
Bblid
473744
Inspectionid
332223
Inspect Date
2016-08-04T00:00:00.000
Atdissuedate
2022-02-02T09:30:36.000
Cb
12
House Num
1579
Onstname
E. 3RD ST.
Atddismissed
No
14278
Atdid: 14278 • Atd Number: ATD-3-5891 • Bblid: 435095
Atdid
14278
Atd Number
ATD-3-5891
Bblid
435095
Inspectionid
375277
Inspect Date
2024-04-13T00:00:00.000
Atdissuedate
2024-04-13T09:22:10.000
Cb
12
House Num
1061
Onstname
54TH ST.
Atddismissed
No
12463
Atdid: 12463 • Atd Number: ATD-4-5295 • Bblid: 813609
Atdid
12463
Atd Number
ATD-4-5295
Bblid
813609
Inspectionid
357966
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T09:36:42.000
Cb
12
House Num
106-32
Onstname
SUTPHIN BLVD.
Atddismissed
No
13315
Atdid: 13315 • Atd Number: ATD-2-1229 • Bblid: 177984
Atdid
13315
Atd Number
ATD-2-1229
Bblid
177984
Inspectionid
362535
Inspect Date
2023-08-15T00:00:00.000
Atdissuedate
2023-08-24T13:12:30.000
Cb
9
House Num
1966
Onstname
CROSS BRONX EXPY.
Atddismissed
No
14547
Atdid: 14547 • Atd Number: ATD-4-6084 • Bblid: 734285
Atdid
14547
Atd Number
ATD-4-6084
Bblid
734285
Inspectionid
377975
Inspect Date
2024-05-31T00:00:00.000
Atdissuedate
2024-05-31T15:57:26.000
Cb
8
House Num
144-24
Onstname
68TH DR.
Atddismissed
No
8615
Atdid: 8615 • Atd Number: ATD-3-3154 • Bblid: 279980
Atdid
8615
Atd Number
ATD-3-3154
Bblid
279980
Inspectionid
330710
Inspect Date
2019-07-24T00:00:00.000
Atdissuedate
2021-12-14T16:51:54.000
Cb
6
House Num
181
Onstname
13TH ST.
Atddismissed
No
13032
Atdid: 13032 • Atd Number: ATD-3-5276 • Bblid: 422462
Atdid
13032
Atd Number
ATD-3-5276
Bblid
422462
Inspectionid
361026
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T14:24:06.000
Cb
12
House Num
4501
Onstname
16TH AVE.
Atddismissed
No
18519
Atdid: 18519 • Atd Number: ATD-3-7296 • Bblid: 378407
Atdid
18519
Atd Number
ATD-3-7296
Bblid
378407
Inspectionid
405401
Inspect Date
2025-08-28T00:00:00.000
Atdissuedate
2025-09-08T10:17:24.000
Cb
5
House Num
636
Onstname
BARBEY ST.
Atddismissed
No
11699
Atdid: 11699 • Atd Number: ATD-3-4753 • Bblid: 433798
Atdid
11699
Atd Number
ATD-3-4753
Bblid
433798
Inspectionid
351915
Inspect Date
2023-02-15T00:00:00.000
Atdissuedate
2023-02-24T10:21:48.000
Cb
12
House Num
1117
Onstname
51ST ST.
Atddismissed
No
18524
Atdid: 18524 • Atd Number: ATD-3-7301 • Bblid: 378419
Atdid
18524
Atd Number
ATD-3-7301
Bblid
378419
Inspectionid
405408
Inspect Date
2025-08-29T00:00:00.000
Atdissuedate
2025-09-08T10:22:26.000
Cb
5
House Num
648
Onstname
BARBEY ST.
Atddismissed
No
12919
Atdid: 12919 • Atd Number: ATD-3-5206 • Bblid: 431808
Atdid
12919
Atd Number
ATD-3-5206
Bblid
431808
Inspectionid
360338
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T10:25:13.000
Cb
12
House Num
1465
Onstname
44TH ST.
Atddismissed
No
12706
Atdid: 12706 • Atd Number: ATD-5-741 • Bblid: 1007997
Atdid
12706
Atd Number
ATD-5-741
Bblid
1007997
Inspectionid
359117
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-29T15:28:08.000
Cb
3
House Num
327
Onstname
ARTHUR KILL ROAD
Atddismissed
No
10489
Atdid: 10489 • Atd Number: ATD-3-3958 • Bblid: 257068
Atdid
10489
Atd Number
ATD-3-3958
Bblid
257068
Inspectionid
339840
Inspect Date
2022-07-16T00:00:00.000
Atdissuedate
2022-07-16T13:18:18.000
Cb
6
House Num
104
Onstname
SUMMIT ST.
Atddismissed
No
14522
Atdid: 14522 • Atd Number: ATD-4-6076 • Bblid: 662013
Atdid
14522
Atd Number
ATD-4-6076
Bblid
662013
Inspectionid
377766
Inspect Date
2024-05-22T00:00:00.000
Atdissuedate
2024-05-22T10:12:06.000
Cb
9
House Num
116
Onstname
81ST AVE.
Atddismissed
No
10073
Atdid: 10073 • Atd Number: ATD-3-3693 • Bblid: 407425
Atdid
10073
Atd Number
ATD-3-3693
Bblid
407425
Inspectionid
336345
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-11T12:33:43.000
Cb
9
House Num
268
Onstname
MIDWOOD ST.
Atddismissed
No
18652
Atdid: 18652 • Atd Number: ATD-3-7355 • Bblid: 377734
Atdid
18652
Atd Number
ATD-3-7355
Bblid
377734
Inspectionid
406290
Inspect Date
2025-09-09T00:00:00.000
Atdissuedate
2025-09-22T11:01:59.000
Cb
5
House Num
503
Onstname
SCHENCK AVE.
Atddismissed
No
4052
Atdid: 4052 • Atd Number: ATD-4-583 • Bblid: 770661
Atdid
4052
Atd Number
ATD-4-583
Bblid
770661
Violationid
162844
Atdissuedate
2020-08-17T00:00:00.000
Cb
13
House Num
84-26
Onstname
249 STREET
Atddismissed
Yes
Atddismissedon
2024-02-23T09:10:15.000
14774
Atdid: 14774 • Atd Number: ATD-4-6166 • Bblid: 753808
Atdid
14774
Atd Number
ATD-4-6166
Bblid
753808
Inspectionid
379611
Inspect Date
2024-07-19T00:00:00.000
Atdissuedate
2024-07-22T10:32:03.000
Cb
11
House Num
56-30
Onstname
211TH ST.
Atddismissed
No
16817
Atdid: 16817 • Atd Number: ATD-5-902 • Bblid: 1009781
Atdid
16817
Atd Number
ATD-5-902
Bblid
1009781
Inspectionid
389764
Inspect Date
2024-03-01T00:00:00.000
Atdissuedate
2025-02-11T17:43:55.000
Cb
3
House Num
139
Onstname
HEREFORD ST.
Atddismissed
No
9274
Atdid: 9274 • Atd Number: ATD-2-877 • Bblid: 232024
Atdid
9274
Atd Number
ATD-2-877
Bblid
232024
Inspectionid
332980
Inspect Date
2020-11-17T00:00:00.000
Atdissuedate
2022-03-01T17:50:36.000
Cb
10
House Num
2877
Onstname
ZULETTE AVE.
Atddismissed
No
8568
Atdid: 8568 • Atd Number: ATD-4-3845 • Bblid: 816752
Atdid
8568
Atd Number
ATD-4-3845
Bblid
816752
Inspectionid
330497
Inspect Date
2019-06-16T00:00:00.000
Atdissuedate
2021-12-08T15:18:42.000
Cb
12
House Num
92-18
Onstname
177TH ST.
Atddismissed
No
17917
Atdid: 17917 • Atd Number: ATD-4-7082 • Bblid: 662541
Atdid
17917
Atd Number
ATD-4-7082
Bblid
662541
Inspectionid
400576
Inspect Date
2025-06-13T00:00:00.000
Atdissuedate
2025-06-17T15:00:00.000
Cb
5
House Num
20-25
Onstname
LINDEN ST.
Atddismissed
No
16287
Atdid: 16287 • Atd Number: ATD-4-6399 • Bblid: 589599
Atdid
16287
Atd Number
ATD-4-6399
Bblid
589599
Inspectionid
384391
Inspect Date
2024-10-03T00:00:00.000
Atdissuedate
2024-10-25T14:18:00.000
Cb
1
House Num
23-30
Onstname
CRESCENT ST.
Atddismissed
No
12118
Atdid: 12118 • Atd Number: ATD-3-4972 • Bblid: 453870
Atdid
12118
Atd Number
ATD-3-4972
Bblid
453870
Inspectionid
356422
Inspect Date
2022-06-22T00:00:00.000
Atdissuedate
2023-04-28T16:17:18.000
Cb
10
House Num
150
Onstname
95TH ST.
Atddismissed
Yes
Atddismissedon
2023-09-29T14:31:09.000
10018
Atdid: 10018 • Atd Number: ATD-4-4562 • Bblid: 605963
Atdid
10018
Atd Number
ATD-4-4562
Bblid
605963
Inspectionid
335981
Inspect Date
2020-11-02T00:00:00.000
Atdissuedate
2022-05-03T09:43:04.000
Cb
3
House Num
30-14
Onstname
86TH ST.
Atddismissed
No
12994
Atdid: 12994 • Atd Number: ATD-3-5254 • Bblid: 422352
Atdid
12994
Atd Number
ATD-3-5254
Bblid
422352
Inspectionid
360788
Inspect Date
2023-07-27T00:00:00.000
Atdissuedate
2023-07-27T13:26:32.000
Cb
12
House Num
1522
Onstname
45TH ST.
Atddismissed
No
10367
Atdid: 10367 • Atd Number: ATD-3-3880 • Bblid: 420706
Atdid
10367
Atd Number
ATD-3-3880
Bblid
420706
Inspectionid
338552
Inspect Date
2022-06-24T00:00:00.000
Atdissuedate
2022-07-05T13:03:30.000
Cb
12
House Num
625
Onstname
E. 3RD ST.
Atddismissed
No
9442
Atdid: 9442 • Atd Number: ATD-3-3505 • Bblid: 554355
Atdid
9442
Atd Number
ATD-3-3505
Bblid
554355
Inspectionid
333276
Inspect Date
2021-01-14T00:00:00.000
Atdissuedate
2022-03-04T17:13:45.000
Cb
18
House Num
2766
Onstname
MILL AVE.
Atddismissed
No
9486
Atdid: 9486 • Atd Number: ATD-5-619 • Bblid: 1043187
Atdid
9486
Atd Number
ATD-5-619
Bblid
1043187
Inspectionid
333392
Inspect Date
2019-08-01T00:00:00.000
Atdissuedate
2022-03-08T10:46:02.000
Cb
3
House Num
820
Onstname
IONIA AVE.
Atddismissed
No
10977
Atdid: 10977 • Atd Number: ATD-3-4330 • Bblid: 520478
Atdid
10977
Atd Number
ATD-3-4330
Bblid
520478
Inspectionid
344386
Inspect Date
2022-09-23T00:00:00.000
Atdissuedate
2022-09-23T12:31:13.000
Cb
18
House Num
1760
Onstname
E. 32ND ST.
Atddismissed
No
14794
Atdid: 14794 • Atd Number: ATD-4-6178 • Bblid: 577211
Atdid
14794
Atd Number
ATD-4-6178
Bblid
577211
Inspectionid
379806
Inspect Date
2024-07-19T00:00:00.000
Atdissuedate
2024-07-25T13:23:14.000
Cb
1
House Num
34-31
Onstname
29TH ST.
Atddismissed
No