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
18012
Atdid: 18012 • Atd Number: ATD-5-1000 • Bblid: 1028283
Atdid
18012
Atd Number
ATD-5-1000
Bblid
1028283
Inspectionid
401670
Inspect Date
2025-04-28T00:00:00.000
Atdissuedate
2025-06-30T11:55:24.000
Cb
3
House Num
39
Onstname
LUDLOW ST.
Atddismissed
No
9616
Atdid: 9616 • Atd Number: ATD-4-4322 • Bblid: 893585
Atdid
9616
Atd Number
ATD-4-4322
Bblid
893585
Inspectionid
333778
Inspect Date
2022-03-15T00:00:00.000
Atdissuedate
2022-03-15T14:13:40.000
Cb
13
House Num
144-18
Onstname
226TH ST.
Atddismissed
No
13228
Atdid: 13228 • Atd Number: ATD-3-5399 • Bblid: 422673
Atdid
13228
Atd Number
ATD-3-5399
Bblid
422673
Inspectionid
362048
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T15:29:56.000
Cb
12
House Num
1723
Onstname
46TH ST.
Atddismissed
No
16122
Atdid: 16122 • Atd Number: ATD-4-6317 • Bblid: 578599
Atdid
16122
Atd Number
ATD-4-6317
Bblid
578599
Inspectionid
383311
Inspect Date
2024-09-18T00:00:00.000
Atdissuedate
2024-09-27T12:22:12.000
Cb
1
House Num
25-47
Onstname
31ST ST.
Atddismissed
No
10130
Atdid: 10130 • Atd Number: ATD-3-3744 • Bblid: 305831
Atdid
10130
Atd Number
ATD-3-3744
Bblid
305831
Inspectionid
336790
Inspect Date
2022-05-18T00:00:00.000
Atdissuedate
2022-05-23T12:04:09.000
Cb
16
House Num
4
Onstname
JARDINE PL.
Atddismissed
No
9484
Atdid: 9484 • Atd Number: ATD-3-3527 • Bblid: 267829
Atdid
9484
Atd Number
ATD-3-3527
Bblid
267829
Inspectionid
333390
Inspect Date
2021-07-02T00:00:00.000
Atdissuedate
2022-03-08T10:37:01.000
Cb
7
House Num
729
Onstname
51ST ST.
Atddismissed
No
11723
Atdid: 11723 • Atd Number: ATD-4-5022 • Bblid: 632952
Atdid
11723
Atd Number
ATD-4-5022
Bblid
632952
Inspectionid
352119
Inspect Date
2023-02-27T00:00:00.000
Atdissuedate
2023-02-27T12:15:21.000
Cb
2
House Num
51-09
Onstname
65TH ST.
Atddismissed
No
18462
Atdid: 18462 • Atd Number: ATD-1-394 • Bblid: 128787
Atdid
18462
Atd Number
ATD-1-394
Bblid
128787
Inspectionid
405056
Inspect Date
2025-08-29T00:00:00.000
Atdissuedate
2025-09-02T10:09:36.000
Cb
10
House Num
363
Onstname
W. 120TH ST.
Atddismissed
No
11397
Atdid: 11397 • Atd Number: ATD-1-238 • Bblid: 127188
Atdid
11397
Atd Number
ATD-1-238
Bblid
127188
Inspectionid
348280
Inspect Date
2022-11-17T00:00:00.000
Atdissuedate
2022-11-17T15:50:47.000
Cb
10
House Num
268
Onstname
W. 117TH ST.
Atddismissed
No
17484
Atdid: 17484 • Atd Number: ATD-4-6830 • Bblid: 768538
Atdid
17484
Atd Number
ATD-4-6830
Bblid
768538
Inspectionid
395665
Inspect Date
2025-04-30T00:00:00.000
Atdissuedate
2025-04-30T14:31:34.000
Cb
11
House Num
60-15
Onstname
264TH ST.
Atddismissed
No
16291
Atdid: 16291 • Atd Number: ATD-4-6403 • Bblid: 589645
Atdid
16291
Atd Number
ATD-4-6403
Bblid
589645
Inspectionid
384414
Inspect Date
2024-10-03T00:00:00.000
Atdissuedate
2024-10-25T14:37:46.000
Cb
1
House Num
23-88
Onstname
CRESCENT ST.
Atddismissed
No
11856
Atdid: 11856 • Atd Number: ATD-3-4829 • Bblid: 1099161
Atdid
11856
Atd Number
ATD-3-4829
Bblid
1099161
Inspectionid
353572
Inspect Date
2023-03-21T00:00:00.000
Atdissuedate
2023-03-22T11:59:16.000
Cb
0
House Num
107
Onstname
PARKVILLE AVE.
Atddismissed
No
10376
Atdid: 10376 • Atd Number: ATD-3-3889 • Bblid: 419945
Atdid
10376
Atd Number
ATD-3-3889
Bblid
419945
Inspectionid
338585
Inspect Date
2022-06-24T00:00:00.000
Atdissuedate
2022-07-05T13:53:29.000
Cb
12
House Num
551
Onstname
E. 3RD ST.
Atddismissed
No
13636
Atdid: 13636 • Atd Number: ATD-3-5618 • Bblid: 306702
Atdid
13636
Atd Number
ATD-3-5618
Bblid
306702
Inspectionid
366072
Inspect Date
2023-10-28T00:00:00.000
Atdissuedate
2023-10-28T15:12:22.000
Cb
3
House Num
1046
Onstname
DEKALB AVE.
Atddismissed
No
18536
Atdid: 18536 • Atd Number: ATD-4-7347 • Bblid: 751006
Atdid
18536
Atd Number
ATD-4-7347
Bblid
751006
Inspectionid
405472
Inspect Date
2025-09-05T00:00:00.000
Atdissuedate
2025-09-08T11:10:26.000
Cb
11
House Num
214-35
Onstname
46TH AVE.
Atddismissed
No
12962
Atdid: 12962 • Atd Number: ATD-3-5236 • Bblid: 507827
Atdid
12962
Atd Number
ATD-3-5236
Bblid
507827
Inspectionid
360563
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-07-24T11:43:04.000
Cb
15
House Num
4325
Onstname
BEDFORD AVE.
Atddismissed
No
14034
Atdid: 14034 • Atd Number: ATD-4-5855 • Bblid: 598117
Atdid
14034
Atd Number
ATD-4-5855
Bblid
598117
Inspectionid
372379
Inspect Date
2024-02-28T00:00:00.000
Atdissuedate
2024-02-28T10:30:34.000
Cb
3
House Num
32-31
Onstname
70TH ST.
Atddismissed
No
9424
Atdid: 9424 • Atd Number: ATD-4-4225 • Bblid: 721412
Atdid
9424
Atd Number
ATD-4-4225
Bblid
721412
Inspectionid
333215
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-03-04T10:55:31.000
Cb
7
House Num
23-51
Onstname
205TH ST.
Atddismissed
No
12407
Atdid: 12407 • Atd Number: ATD-3-5048 • Bblid: 315544
Atdid
12407
Atd Number
ATD-3-5048
Bblid
315544
Violationid
279248
Reinspectionid
33355
Inspect Date
2023-05-25T14:16:23.000
Atdissuedate
2023-05-25T14:16:23.000
Cb
3
House Num
284
Onstname
CLIFTON PLACE
Atddismissed
No
10520
Atdid: 10520 • Atd Number: ATD-2-936 • Bblid: 211042
Atdid
10520
Atd Number
ATD-2-936
Bblid
211042
Inspectionid
340096
Inspect Date
2022-07-05T00:00:00.000
Atdissuedate
2022-07-19T15:35:32.000
Cb
12
House Num
3222
Onstname
COLDEN AVE.
Atddismissed
No
18633
Atdid: 18633 • Atd Number: ATD-3-7344 • Bblid: 391383
Atdid
18633
Atd Number
ATD-3-7344
Bblid
391383
Inspectionid
406202
Inspect Date
2025-03-26T00:00:00.000
Atdissuedate
2025-09-19T17:05:59.000
Cb
17
House Num
25
Onstname
E. 53RD ST.
Atddismissed
No
16686
Atdid: 16686 • Atd Number: ATD-3-6541 • Bblid: 555795
Atdid
16686
Atd Number
ATD-3-6541
Bblid
555795
Inspectionid
388632
Inspect Date
2024-12-17T00:00:00.000
Atdissuedate
2025-01-09T10:56:50.000
Cb
18
House Num
2446
Onstname
E. 65TH ST.
Atddismissed
No
17969
Atdid: 17969 • Atd Number: ATD-3-7081 • Bblid: 496495
Atdid
17969
Atd Number
ATD-3-7081
Bblid
496495
Inspectionid
400926
Inspect Date
2025-06-17T00:00:00.000
Atdissuedate
2025-06-24T14:08:40.000
Cb
15
House Num
2172
Onstname
E. 3RD ST.
Atddismissed
No
3741
Atdid: 3741 • Atd Number: ATD-4-406 • Bblid: 909911
Atdid
3741
Atd Number
ATD-4-406
Bblid
909911
Violationid
139972
Atdissuedate
2020-08-17T00:00:00.000
Cb
14
House Num
11-26
Onstname
WATERVIEW STREET
Atddismissed
No
11547
Atdid: 11547 • Atd Number: ATD-2-967 • Bblid: 239315
Atdid
11547
Atd Number
ATD-2-967
Bblid
239315
Inspectionid
349751
Inspect Date
2022-11-01T00:00:00.000
Atdissuedate
2022-12-27T13:18:02.000
Cb
10
House Num
319
Onstname
BRINSMADE AVE.
Atddismissed
No
10417
Atdid: 10417 • Atd Number: ATD-2-932 • Bblid: 196973
Atdid
10417
Atd Number
ATD-2-932
Bblid
196973
Inspectionid
339096
Inspect Date
2022-06-14T00:00:00.000
Atdissuedate
2022-07-11T11:52:33.000
Cb
11
House Num
1561
Onstname
LURTING AVE.
Atddismissed
No
11697
Atdid: 11697 • Atd Number: ATD-4-5008 • Bblid: 859232
Atdid
11697
Atd Number
ATD-4-5008
Bblid
859232
Inspectionid
351894
Inspect Date
2023-02-09T00:00:00.000
Atdissuedate
2023-02-23T12:02:45.000
Cb
10
House Num
122-40
Onstname
149TH AVE.
Atddismissed
No
13089
Atdid: 13089 • Atd Number: ATD-3-5318 • Bblid: 457654
Atdid
13089
Atd Number
ATD-3-5318
Bblid
457654
Inspectionid
361295
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-08-02T11:27:31.000
Cb
11
House Num
1574
Onstname
73RD ST.
Atddismissed
No
1334
Atdid: 1334 • Atd Number: ATD-3-477 • Bblid: 421269
Atdid
1334
Atd Number
ATD-3-477
Bblid
421269
Violationid
218171
Atdissuedate
2019-12-19T00:00:00.000
Cb
12
House Num
580
Onstname
EAST 8 STREET
Atddismissed
Yes
Atddismissedon
2022-06-08T13:10:35.000
10851
Atdid: 10851 • Atd Number: ATD-3-4222 • Bblid: 311067
Atdid
10851
Atd Number
ATD-3-4222
Bblid
311067
Inspectionid
343383
Inspect Date
2022-09-10T00:00:00.000
Atdissuedate
2022-09-12T10:22:58.000
Cb
3
House Num
202
Onstname
DECATUR ST.
Atddismissed
No
16912
Atdid: 16912 • Atd Number: ATD-3-6628 • Bblid: 443678
Atdid
16912
Atd Number
ATD-3-6628
Bblid
443678
Inspectionid
390964
Inspect Date
2025-03-11T00:00:00.000
Atdissuedate
2025-03-13T07:47:33.000
Cb
10
House Num
98
Onstname
71ST ST.
Atddismissed
Yes
Atddismissedon
2025-03-21T10:14:09.000
11982
Atdid: 11982 • Atd Number: ATD-4-5101 • Bblid: 656688
Atdid
11982
Atd Number
ATD-4-5101
Bblid
656688
Inspectionid
354457
Inspect Date
2023-04-05T00:00:00.000
Atdissuedate
2023-04-05T11:28:22.000
Cb
6
House Num
67-75
Onstname
FLEET ST.
Atddismissed
No
12749
Atdid: 12749 • Atd Number: ATD-4-5411 • Bblid: 837389
Atdid
12749
Atd Number
ATD-4-5411
Bblid
837389
Inspectionid
359405
Inspect Date
2023-06-30T00:00:00.000
Atdissuedate
2023-07-05T10:02:18.000
Cb
13
House Num
114-03
Onstname
211TH ST.
Atddismissed
No
13136
Atdid: 13136 • Atd Number: ATD-4-5490 • Bblid: 711450
Atdid
13136
Atd Number
ATD-4-5490
Bblid
711450
Inspectionid
361484
Inspect Date
2023-05-26T00:00:00.000
Atdissuedate
2023-08-03T13:14:25.000
Cb
7
House Num
40-29
Onstname
172ND ST.
Atddismissed
No
13659
Atdid: 13659 • Atd Number: ATD-4-5627 • Bblid: 735418
Atdid
13659
Atd Number
ATD-4-5627
Bblid
735418
Inspectionid
366331
Inspect Date
2023-11-04T00:00:00.000
Atdissuedate
2023-11-04T14:07:03.000
Cb
8
House Num
72-16
Onstname
139TH ST.
Atddismissed
No
13112
Atdid: 13112 • Atd Number: ATD-3-5325 • Bblid: 422736
Atdid
13112
Atd Number
ATD-3-5325
Bblid
422736
Inspectionid
361415
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T11:57:49.000
Cb
12
House Num
1502
Onstname
46TH ST.
Atddismissed
No
10904
Atdid: 10904 • Atd Number: ATD-3-4275 • Bblid: 267220
Atdid
10904
Atd Number
ATD-3-4275
Bblid
267220
Inspectionid
343605
Inspect Date
2022-09-10T00:00:00.000
Atdissuedate
2022-09-12T14:09:20.000
Cb
7
House Num
429
Onstname
50TH ST.
Atddismissed
No
9833
Atdid: 9833 • Atd Number: ATD-4-4452 • Bblid: 918691
Atdid
9833
Atd Number
ATD-4-4452
Bblid
918691
Inspectionid
334678
Inspect Date
2022-03-10T00:00:00.000
Atdissuedate
2022-04-08T10:15:19.000
Cb
14
House Num
4-57
Onstname
BEACH 138TH ST.
Atddismissed
No
13802
Atdid: 13802 • Atd Number: ATD-4-5697 • Bblid: 861072
Atdid
13802
Atd Number
ATD-4-5697
Bblid
861072
Inspectionid
370021
Inspect Date
2023-11-22T00:00:00.000
Atdissuedate
2023-12-22T12:44:03.000
Cb
12
House Num
111-17
Onstname
INWOOD ST.
Atddismissed
No
14219
Atdid: 14219 • Atd Number: ATD-4-5921 • Bblid: 574254
Atdid
14219
Atd Number
ATD-4-5921
Bblid
574254
Inspectionid
374113
Inspect Date
2024-02-21T00:00:00.000
Atdissuedate
2024-03-25T11:03:19.000
Cb
1
House Num
11-52
Onstname
30TH RD.
Atddismissed
No
16642
Atdid: 16642 • Atd Number: ATD-4-6541 • Bblid: 785676
Atdid
16642
Atd Number
ATD-4-6541
Bblid
785676
Inspectionid
388467
Inspect Date
2024-12-30T00:00:00.000
Atdissuedate
2025-01-03T12:20:31.000
Cb
10
House Num
107-52
Onstname
77TH ST.
Atddismissed
No
10062
Atdid: 10062 • Atd Number: ATD-3-3682 • Bblid: 553002
Atdid
10062
Atd Number
ATD-3-3682
Bblid
553002
Violationid
275759
Reinspectionid
33681
Inspect Date
2022-05-10T09:18:39.000
Atdissuedate
2022-05-10T09:18:39.000
Cb
18
House Num
2031
Onstname
KIMBALL STREET
Atddismissed
No
13671
Atdid: 13671 • Atd Number: ATD-4-5633 • Bblid: 823116
Atdid
13671
Atd Number
ATD-4-5633
Bblid
823116
Inspectionid
366429
Inspect Date
2023-10-24T00:00:00.000
Atdissuedate
2023-11-13T10:47:22.000
Cb
12
House Num
89-31
Onstname
199TH ST.
Atddismissed
No
17000
Atdid: 17000 • Atd Number: ATD-3-6668 • Bblid: 442182
Atdid
17000
Atd Number
ATD-3-6668
Bblid
442182
Inspectionid
392102
Inspect Date
2025-03-20T00:00:00.000
Atdissuedate
2025-03-24T12:20:06.000
Cb
10
House Num
157
Onstname
BAY RIDGE AVE.
Atddismissed
No
11917
Atdid: 11917 • Atd Number: ATD-3-4868 • Bblid: 310927
Atdid
11917
Atd Number
ATD-3-4868
Bblid
310927
Inspectionid
354125
Inspect Date
2023-03-07T00:00:00.000
Atdissuedate
2023-03-28T11:50:57.000
Cb
3
House Num
578
Onstname
MACDONOUGH ST.
Atddismissed
No
8742
Atdid: 8742 • Atd Number: ATD-4-3938 • Bblid: 772540
Atdid
8742
Atd Number
ATD-4-3938
Bblid
772540
Inspectionid
331096
Inspect Date
2021-11-16T00:00:00.000
Atdissuedate
2021-12-28T13:09:11.000
Cb
13
House Num
78-53
Onstname
267TH ST.
Atddismissed
No
8835
Atdid: 8835 • Atd Number: ATD-5-589 • Bblid: 997184
Atdid
8835
Atd Number
ATD-5-589
Bblid
997184
Inspectionid
331705
Inspect Date
2022-01-18T00:00:00.000
Atdissuedate
2022-01-18T12:01:08.000
Cb
2
House Num
391
Onstname
JEFFERSON AVE.
Atddismissed
No
13128
Atdid: 13128 • Atd Number: ATD-3-5340 • Bblid: 422760
Atdid
13128
Atd Number
ATD-3-5340
Bblid
422760
Inspectionid
361474
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T12:29:25.000
Cb
12
House Num
1566
Onstname
46TH ST.
Atddismissed
No
17027
Atdid: 17027 • Atd Number: ATD-3-6695 • Bblid: 284640
Atdid
17027
Atd Number
ATD-3-6695
Bblid
284640
Inspectionid
392273
Inspect Date
2021-09-16T00:00:00.000
Atdissuedate
2025-03-26T11:49:45.000
Cb
7
House Num
107
Onstname
WINDSOR PL.
Atddismissed
No
12807
Atdid: 12807 • Atd Number: ATD-4-5422 • Bblid: 718863
Atdid
12807
Atd Number
ATD-4-5422
Bblid
718863
Inspectionid
359746
Inspect Date
2023-06-27T00:00:00.000
Atdissuedate
2023-07-10T17:01:57.000
Cb
11
House Num
188-16
Onstname
50TH AVE.
Atddismissed
No