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
14088
Atdid: 14088 • Atd Number: ATD-4-5880 • Bblid: 789174
Atdid
14088
Atd Number
ATD-4-5880
Bblid
789174
Inspectionid
372893
Inspect Date
2024-03-06T00:00:00.000
Atdissuedate
2024-03-08T12:54:43.000
Cb
9
House Num
118-02
Onstname
84TH AVE.
Atddismissed
No
12968
Atdid: 12968 • Atd Number: ATD-3-5242 • Bblid: 507845
Atdid
12968
Atd Number
ATD-3-5242
Bblid
507845
Inspectionid
360571
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-07-24T12:05:12.000
Cb
15
House Num
4299
Onstname
BEDFORD AVE.
Atddismissed
No
17566
Atdid: 17566 • Atd Number: ATD-3-6959 • Bblid: 287429
Atdid
17566
Atd Number
ATD-3-6959
Bblid
287429
Inspectionid
396534
Inspect Date
2025-05-06T00:00:00.000
Atdissuedate
2025-05-08T08:59:28.000
Cb
8
House Num
294
Onstname
PARK PL.
Atddismissed
No
10625
Atdid: 10625 • Atd Number: ATD-4-4774 • Bblid: 753742
Atdid
10625
Atd Number
ATD-4-4774
Bblid
753742
Inspectionid
341123
Inspect Date
2022-07-20T00:00:00.000
Atdissuedate
2022-08-08T15:31:32.000
Cb
11
House Num
56-44
Onstname
210TH ST.
Atddismissed
No
11136
Atdid: 11136 • Atd Number: ATD-1-202 • Bblid: 94796
Atdid
11136
Atd Number
ATD-1-202
Bblid
94796
Inspectionid
345687
Inspect Date
2022-10-12T00:00:00.000
Atdissuedate
2022-10-12T12:54:17.000
Cb
8
House Num
170
Onstname
E. 75TH ST.
Atddismissed
No
13118
Atdid: 13118 • Atd Number: ATD-3-5331 • Bblid: 422746
Atdid
13118
Atd Number
ATD-3-5331
Bblid
422746
Inspectionid
361448
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T12:15:38.000
Cb
12
House Num
1534
Onstname
46TH ST.
Atddismissed
No
9940
Atdid: 9940 • Atd Number: ATD-4-4519 • Bblid: 654399
Atdid
9940
Atd Number
ATD-4-4519
Bblid
654399
Inspectionid
335343
Inspect Date
2022-04-14T00:00:00.000
Atdissuedate
2022-04-21T12:10:59.000
Cb
6
House Num
65-08
Onstname
BOELSEN CRES
Atddismissed
No
10304
Atdid: 10304 • Atd Number: ATD-3-3853 • Bblid: 324355
Atdid
10304
Atd Number
ATD-3-3853
Bblid
324355
Inspectionid
337769
Inspect Date
2022-06-10T00:00:00.000
Atdissuedate
2022-06-17T10:15:15.000
Cb
2
House Num
59
Onstname
CAMBRIDGE PL.
Atddismissed
No
9881
Atdid: 9881 • Atd Number: ATD-4-4488 • Bblid: 746824
Atdid
9881
Atd Number
ATD-4-4488
Bblid
746824
Inspectionid
334969
Inspect Date
2022-04-14T00:00:00.000
Atdissuedate
2022-04-15T10:19:02.000
Cb
8
House Num
67-02
Onstname
199TH ST.
Atddismissed
No
13184
Atdid: 13184 • Atd Number: ATD-3-5363 • Bblid: 422846
Atdid
13184
Atd Number
ATD-3-5363
Bblid
422846
Inspectionid
361823
Inspect Date
2023-08-10T00:00:00.000
Atdissuedate
2023-08-10T10:29:24.000
Cb
12
House Num
1612
Onstname
46TH ST.
Atddismissed
No
12302
Atdid: 12302 • Atd Number: ATD-2-1099 • Bblid: 153033
Atdid
12302
Atd Number
ATD-2-1099
Bblid
153033
Inspectionid
357353
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T12:11:05.000
Cb
4
House Num
1400
Onstname
TOWNSEND AVENUE
Atddismissed
No
12078
Atdid: 12078 • Atd Number: ATD-4-5145 • Bblid: 860527
Atdid
12078
Atd Number
ATD-4-5145
Bblid
860527
Inspectionid
356102
Inspect Date
2023-04-07T00:00:00.000
Atdissuedate
2023-04-24T08:24:22.000
Cb
12
House Num
108-09
Onstname
LIVERPOOL ST.
Atddismissed
No
9632
Atdid: 9632 • Atd Number: ATD-4-4336 • Bblid: 919013
Atdid
9632
Atd Number
ATD-4-4336
Bblid
919013
Inspectionid
333801
Inspect Date
2021-05-21T00:00:00.000
Atdissuedate
2022-03-15T18:52:51.000
Cb
14
House Num
2-38
Onstname
BEACH 133RD ST.
Atddismissed
No
12234
Atdid: 12234 • Atd Number: ATD-3-5020 • Bblid: 562678
Atdid
12234
Atd Number
ATD-3-5020
Bblid
562678
Inspectionid
357051
Inspect Date
2023-04-21T00:00:00.000
Atdissuedate
2023-05-15T10:18:51.000
Cb
15
House Num
2025
Onstname
GERRITSEN AVE.
Atddismissed
No
18120
Atdid: 18120 • Atd Number: ATD-3-7138 • Bblid: 560923
Atdid
18120
Atd Number
ATD-3-7138
Bblid
560923
Inspectionid
402675
Inspect Date
2025-07-16T00:00:00.000
Atdissuedate
2025-07-18T12:04:05.000
Cb
15
House Num
4726
Onstname
BEDFORD AVE.
Atddismissed
No
14377
Atdid: 14377 • Atd Number: ATD-4-6004 • Bblid: 871805
Atdid
14377
Atd Number
ATD-4-6004
Bblid
871805
Inspectionid
376350
Inspect Date
2024-04-19T00:00:00.000
Atdissuedate
2024-04-29T13:24:06.000
Cb
12
House Num
170-36
Onstname
118TH RD.
Atddismissed
No
9679
Atdid: 9679 • Atd Number: ATD-3-3573 • Bblid: 450439
Atdid
9679
Atd Number
ATD-3-3573
Bblid
450439
Inspectionid
333877
Inspect Date
2021-08-05T00:00:00.000
Atdissuedate
2022-03-17T09:05:13.000
Cb
10
House Num
445
Onstname
85TH ST.
Atddismissed
No
8789
Atdid: 8789 • Atd Number: ATD-4-3965 • Bblid: 668335
Atdid
8789
Atd Number
ATD-4-3965
Bblid
668335
Inspectionid
331292
Inspect Date
2021-12-01T00:00:00.000
Atdissuedate
2021-12-30T11:10:36.000
Cb
5
House Num
1639
Onstname
SUMMERFIELD ST.
Atddismissed
No
12761
Atdid: 12761 • Atd Number: ATD-3-5110 • Bblid: 267431
Atdid
12761
Atd Number
ATD-3-5110
Bblid
267431
Inspectionid
359494
Inspect Date
2023-07-06T00:00:00.000
Atdissuedate
2023-07-06T09:50:24.000
Cb
7
House Num
639
Onstname
50TH ST.
Atddismissed
No
16377
Atdid: 16377 • Atd Number: ATD-3-6416 • Bblid: 328425
Atdid
16377
Atd Number
ATD-3-6416
Bblid
328425
Inspectionid
385074
Inspect Date
2024-11-15T00:00:00.000
Atdissuedate
2024-11-15T11:36:00.000
Cb
2
House Num
28
Onstname
SAINT FELIX ST.
Atddismissed
No
14566
Atdid: 14566 • Atd Number: ATD-3-6022 • Bblid: 530150
Atdid
14566
Atd Number
ATD-3-6022
Bblid
530150
Inspectionid
378241
Inspect Date
2024-04-25T00:00:00.000
Atdissuedate
2024-06-10T10:22:21.000
Cb
17
House Num
843
Onstname
E. 51ST ST.
Atddismissed
No
12164
Atdid: 12164 • Atd Number: ATD-3-4994 • Bblid: 326076
Atdid
12164
Atd Number
ATD-3-4994
Bblid
326076
Inspectionid
356714
Inspect Date
2021-10-07T00:00:00.000
Atdissuedate
2023-05-06T13:22:34.000
Cb
2
House Num
13
Onstname
ATLANTIC COMMONS
Atddismissed
No
16528
Atdid: 16528 • Atd Number: ATD-3-6466 • Bblid: 292009
Atdid
16528
Atd Number
ATD-3-6466
Bblid
292009
Inspectionid
386440
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2024-12-18T07:43:02.000
Cb
8
House Num
437
Onstname
EASTERN PKWY.
Atddismissed
No
14542
Atdid: 14542 • Atd Number: ATD-3-6005 • Bblid: 459428
Atdid
14542
Atd Number
ATD-3-6005
Bblid
459428
Inspectionid
377884
Inspect Date
2024-05-17T00:00:00.000
Atdissuedate
2024-05-28T13:56:11.000
Cb
11
House Num
1734
Onstname
76TH ST.
Atddismissed
No
18409
Atdid: 18409 • Atd Number: ATD-4-7286 • Bblid: 755202
Atdid
18409
Atd Number
ATD-4-7286
Bblid
755202
Inspectionid
404683
Inspect Date
2025-05-20T00:00:00.000
Atdissuedate
2025-08-22T11:55:08.000
Cb
11
House Num
226-03
Onstname
HORACE HARDING EXPY.
Atddismissed
No
11472
Atdid: 11472 • Atd Number: ATD-4-4898 • Bblid: 596570
Atdid
11472
Atd Number
ATD-4-4898
Bblid
596570
Inspectionid
348828
Inspect Date
2022-11-10T00:00:00.000
Atdissuedate
2022-12-01T09:08:27.000
Cb
3
House Num
30-12
Onstname
78TH ST.
Atddismissed
No
14469
Atdid: 14469 • Atd Number: ATD-4-6047 • Bblid: 822043
Atdid
14469
Atd Number
ATD-4-6047
Bblid
822043
Inspectionid
377299
Inspect Date
2024-02-27T00:00:00.000
Atdissuedate
2024-05-13T14:10:15.000
Cb
12
House Num
88-22
Onstname
189TH ST.
Atddismissed
No
10930
Atdid: 10930 • Atd Number: ATD-3-4295 • Bblid: 537499
Atdid
10930
Atd Number
ATD-3-4295
Bblid
537499
Violationid
273533
Reinspectionid
33614
Inspect Date
2022-09-16T13:07:12.000
Atdissuedate
2022-09-16T13:07:12.000
Cb
17
House Num
704
Onstname
EAST 94 STREET
Atddismissed
No
16670
Atdid: 16670 • Atd Number: ATD-4-6555 • Bblid: 735852
Atdid
16670
Atd Number
ATD-4-6555
Bblid
735852
Inspectionid
388581
Inspect Date
2024-10-24T00:00:00.000
Atdissuedate
2025-01-08T15:45:21.000
Cb
8
House Num
76-16
Onstname
VLEIGH PL.
Atddismissed
No
17230
Atdid: 17230 • Atd Number: ATD-5-953 • Bblid: 1028215
Atdid
17230
Atd Number
ATD-5-953
Bblid
1028215
Inspectionid
393023
Inspect Date
2025-03-29T00:00:00.000
Atdissuedate
2025-04-02T16:00:24.000
Cb
3
House Num
120
Onstname
NOTUS AVE.
Atddismissed
No
11698
Atdid: 11698 • Atd Number: ATD-3-4752 • Bblid: 433800
Atdid
11698
Atd Number
ATD-3-4752
Bblid
433800
Inspectionid
351914
Inspect Date
2023-02-15T00:00:00.000
Atdissuedate
2023-02-24T10:21:15.000
Cb
12
House Num
1115
Onstname
51ST ST.
Atddismissed
No
13231
Atdid: 13231 • Atd Number: ATD-3-5402 • Bblid: 422716
Atdid
13231
Atd Number
ATD-3-5402
Bblid
422716
Inspectionid
362051
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T15:31:11.000
Cb
12
House Num
1715
Onstname
46TH ST.
Atddismissed
No
10324
Atdid: 10324 • Atd Number: ATD-3-3857 • Bblid: 291148
Atdid
10324
Atd Number
ATD-3-3857
Bblid
291148
Inspectionid
338020
Inspect Date
2022-06-10T00:00:00.000
Atdissuedate
2022-06-22T14:08:49.000
Cb
8
House Num
808
Onstname
STERLING PL.
Atddismissed
No
11373
Atdid: 11373 • Atd Number: ATD-4-4875 • Bblid: 592791
Atdid
11373
Atd Number
ATD-4-4875
Bblid
592791
Inspectionid
347964
Inspect Date
2022-10-27T00:00:00.000
Atdissuedate
2022-11-10T13:27:07.000
Cb
1
House Num
74-14
Onstname
21ST AVE.
Atddismissed
No
12645
Atdid: 12645 • Atd Number: ATD-4-5386 • Bblid: 605639
Atdid
12645
Atd Number
ATD-4-5386
Bblid
605639
Inspectionid
358947
Inspect Date
2023-06-23T00:00:00.000
Atdissuedate
2023-06-23T13:04:17.000
Cb
3
House Num
26-55
Onstname
95TH ST.
Atddismissed
No
13317
Atdid: 13317 • Atd Number: ATD-4-5514 • Bblid: 578159
Atdid
13317
Atd Number
ATD-4-5514
Bblid
578159
Inspectionid
362548
Inspect Date
2023-08-25T00:00:00.000
Atdissuedate
2023-08-25T11:00:53.000
Cb
1
House Num
34-43
Onstname
30TH ST.
Atddismissed
No
13399
Atdid: 13399 • Atd Number: ATD-3-5518 • Bblid: 477213
Atdid
13399
Atd Number
ATD-3-5518
Bblid
477213
Inspectionid
363391
Inspect Date
2023-09-08T00:00:00.000
Atdissuedate
2023-09-11T18:15:32.000
Cb
11
House Num
1740
Onstname
W. 8TH ST.
Atddismissed
No
14486
Atdid: 14486 • Atd Number: ATD-2-1274 • Bblid: 164538
Atdid
14486
Atd Number
ATD-2-1274
Bblid
164538
Inspectionid
377454
Inspect Date
2024-05-04T00:00:00.000
Atdissuedate
2024-05-20T09:14:31.000
Cb
8
House Num
2710
Onstname
KINGSBRIDGE TER.
Atddismissed
No
17604
Atdid: 17604 • Atd Number: ATD-4-6877 • Bblid: 647538
Atdid
17604
Atd Number
ATD-4-6877
Bblid
647538
Inspectionid
397068
Inspect Date
2025-04-03T00:00:00.000
Atdissuedate
2025-05-15T09:33:35.000
Cb
5
House Num
61-14
Onstname
76TH ST.
Atddismissed
No
12972
Atdid: 12972 • Atd Number: ATD-2-1198 • Bblid: 179775
Atdid
12972
Atd Number
ATD-2-1198
Bblid
179775
Inspectionid
360608
Inspect Date
2023-07-25T00:00:00.000
Atdissuedate
2023-07-25T09:19:09.000
Cb
9
House Num
1345
Onstname
BRONX RIVER AVE.
Atddismissed
No
13345
Atdid: 13345 • Atd Number: ATD-3-5483 • Bblid: 310696
Atdid
13345
Atd Number
ATD-3-5483
Bblid
310696
Inspectionid
362848
Inspect Date
2023-08-29T00:00:00.000
Atdissuedate
2023-08-29T11:58:12.000
Cb
3
House Num
305
Onstname
MACDONOUGH ST.
Atddismissed
No
17592
Atdid: 17592 • Atd Number: ATD-2-1401 • Bblid: 241360
Atdid
17592
Atd Number
ATD-2-1401
Bblid
241360
Inspectionid
396980
Inspect Date
2025-04-02T00:00:00.000
Atdissuedate
2025-05-13T11:06:30.000
Cb
10
House Num
531
Onstname
MINNIEFORD AVE.
Atddismissed
No
18282
Atdid: 18282 • Atd Number: ATD-4-7221 • Bblid: 704140
Atdid
18282
Atd Number
ATD-4-7221
Bblid
704140
Inspectionid
403893
Inspect Date
2025-08-01T00:00:00.000
Atdissuedate
2025-08-08T10:46:27.000
Cb
7
House Num
41-26
Onstname
149TH PL.
Atddismissed
No
17064
Atdid: 17064 • Atd Number: ATD-3-6719 • Bblid: 279203
Atdid
17064
Atd Number
ATD-3-6719
Bblid
279203
Inspectionid
392408
Inspect Date
2022-06-01T00:00:00.000
Atdissuedate
2025-03-27T11:54:31.000
Cb
6
House Num
469
Onstname
11TH ST.
Atddismissed
No
12506
Atdid: 12506 • Atd Number: ATD-4-5332 • Bblid: 792925
Atdid
12506
Atd Number
ATD-4-5332
Bblid
792925
Inspectionid
358051
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T16:27:30.000
Cb
9
Onstname
117 STREET
Atddismissed
No
12683
Atdid: 12683 • Atd Number: ATD-5-719 • Bblid: 1022225
Atdid
12683
Atd Number
ATD-5-719
Bblid
1022225
Inspectionid
359083
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-29T12:10:09.000
Cb
3
House Num
467
Onstname
ABINGDON AVE.
Atddismissed
No
17276
Atdid: 17276 • Atd Number: ATD-3-6834 • Bblid: 280750
Atdid
17276
Atd Number
ATD-3-6834
Bblid
280750
Inspectionid
393440
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-07T11:50:05.000
Cb
7
House Num
181
Onstname
16TH ST.
Atddismissed
No
11972
Atdid: 11972 • Atd Number: ATD-2-1011 • Bblid: 231249
Atdid
11972
Atd Number
ATD-2-1011
Bblid
231249
Inspectionid
354410
Inspect Date
2023-02-23T00:00:00.000
Atdissuedate
2023-04-04T12:20:26.000
Cb
10
House Num
3267
Onstname
BRUCKNER BLVD.
Atddismissed
No
16224
Atdid: 16224 • Atd Number: ATD-4-6373 • Bblid: 777156
Atdid
16224
Atd Number
ATD-4-6373
Bblid
777156
Inspectionid
384132
Inspect Date
2022-04-15T00:00:00.000
Atdissuedate
2024-10-15T11:43:07.000
Cb
9
House Num
85-43
Onstname
87TH ST.
Atddismissed
No
13095
Atdid: 13095 • Atd Number: ATD-5-782 • Bblid: 1008130
Atdid
13095
Atd Number
ATD-5-782
Bblid
1008130
Inspectionid
361349
Inspect Date
2023-07-15T00:00:00.000
Atdissuedate
2023-08-02T17:25:54.000
Cb
3
House Num
18
Onstname
BLYTHE PL.
Atddismissed
No