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
12557
Atdid: 12557 • Atd Number: ATD-3-5074 • Bblid: 407274
Atdid
12557
Atd Number
ATD-3-5074
Bblid
407274
Inspectionid
358505
Inspect Date
2023-05-17T00:00:00.000
Atdissuedate
2023-06-13T14:44:06.000
Cb
9
House Num
163
Onstname
MIDWOOD ST.
Atddismissed
No
13214
Atdid: 13214 • Atd Number: ATD-3-5385 • Bblid: 422645
Atdid
13214
Atd Number
ATD-3-5385
Bblid
422645
Inspectionid
362034
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T15:24:00.000
Cb
12
House Num
1775
Onstname
46TH ST.
Atddismissed
No
16274
Atdid: 16274 • Atd Number: ATD-5-885 • Bblid: 991933
Atdid
16274
Atd Number
ATD-5-885
Bblid
991933
Inspectionid
384309
Inspect Date
2024-10-17T00:00:00.000
Atdissuedate
2024-10-23T12:58:01.000
Cb
2
House Num
362
Onstname
CROMWELL AVE.
Atddismissed
No
13601
Atdid: 13601 • Atd Number: ATD-3-5603 • Bblid: 419830
Atdid
13601
Atd Number
ATD-3-5603
Bblid
419830
Inspectionid
365579
Inspect Date
2023-10-19T00:00:00.000
Atdissuedate
2023-10-20T11:10:57.000
Cb
12
House Num
627
Onstname
CORTELYOU RD.
Atddismissed
No
10674
Atdid: 10674 • Atd Number: ATD-3-4071 • Bblid: 479555
Atdid
10674
Atd Number
ATD-3-4071
Bblid
479555
Inspectionid
341945
Inspect Date
2022-02-08T00:00:00.000
Atdissuedate
2022-08-24T07:41:06.000
Cb
15
House Num
1836
Onstname
E. 8TH ST.
Atddismissed
No
10602
Atdid: 10602 • Atd Number: ATD-3-4027 • Bblid: 319128
Atdid
10602
Atd Number
ATD-3-4027
Bblid
319128
Inspectionid
340902
Inspect Date
2022-08-03T00:00:00.000
Atdissuedate
2022-08-04T14:51:28.000
Cb
3
House Num
287
Onstname
JEFFERSON AVE.
Atddismissed
No
17565
Atdid: 17565 • Atd Number: ATD-3-6958 • Bblid: 287433
Atdid
17565
Atd Number
ATD-3-6958
Bblid
287433
Inspectionid
396531
Inspect Date
2025-05-06T00:00:00.000
Atdissuedate
2025-05-08T08:43:41.000
Cb
8
House Num
302
Onstname
PARK PL.
Atddismissed
No
14670
Atdid: 14670 • Atd Number: ATD-3-6084 • Bblid: 254516
Atdid
14670
Atd Number
ATD-3-6084
Bblid
254516
Violationid
286124
Reinspectionid
35693
Inspect Date
2024-06-28T13:03:55.000
Atdissuedate
2024-06-28T13:03:55.000
Cb
6
House Num
169
Onstname
WARREN STREET
Atddismissed
No
9784
Atdid: 9784 • Atd Number: ATD-4-4431 • Bblid: 632680
Atdid
9784
Atd Number
ATD-4-4431
Bblid
632680
Inspectionid
334377
Inspect Date
2019-09-13T00:00:00.000
Atdissuedate
2022-03-29T18:24:12.000
Cb
5
House Num
53-74
Onstname
64TH ST.
Atddismissed
No
15074
Atdid: 15074 • Atd Number: ATD-3-6291 • Bblid: 464372
Atdid
15074
Atd Number
ATD-3-6291
Bblid
464372
Inspectionid
382090
Inspect Date
2024-09-19T00:00:00.000
Atdissuedate
2024-09-23T11:34:24.000
Cb
11
House Num
1854
Onstname
83RD ST.
Atddismissed
No
10483
Atdid: 10483 • Atd Number: ATD-3-3952 • Bblid: 265841
Atdid
10483
Atd Number
ATD-3-3952
Bblid
265841
Inspectionid
339769
Inspect Date
2022-06-14T00:00:00.000
Atdissuedate
2022-07-15T08:50:56.000
Cb
7
House Num
334
Onstname
45TH ST.
Atddismissed
No
8787
Atdid: 8787 • Atd Number: ATD-4-3963 • Bblid: 668341
Atdid
8787
Atd Number
ATD-4-3963
Bblid
668341
Inspectionid
331289
Inspect Date
2021-12-01T00:00:00.000
Atdissuedate
2021-12-30T11:08:05.000
Cb
5
House Num
1633
Onstname
SUMMERFIELD ST.
Atddismissed
No
18196
Atdid: 18196 • Atd Number: ATD-5-1013 • Bblid: 1001110
Atdid
18196
Atd Number
ATD-5-1013
Bblid
1001110
Inspectionid
403181
Inspect Date
2025-07-25T00:00:00.000
Atdissuedate
2025-07-25T14:16:26.000
Cb
3
House Num
402
Onstname
RIGA ST.
Atddismissed
No
11247
Atdid: 11247 • Atd Number: ATD-3-4553 • Bblid: 526102
Atdid
11247
Atd Number
ATD-3-4553
Bblid
526102
Inspectionid
346832
Inspect Date
2022-10-20T00:00:00.000
Atdissuedate
2022-10-24T11:46:45.000
Cb
18
House Num
1319
Onstname
E. 55TH ST.
Atddismissed
No
15068
Atdid: 15068 • Atd Number: ATD-2-1305 • Bblid: 172307
Atdid
15068
Atd Number
ATD-2-1305
Bblid
172307
Inspectionid
382048
Inspect Date
2024-09-18T00:00:00.000
Atdissuedate
2024-09-23T10:29:07.000
Cb
9
House Num
545
Onstname
BOLTON AVE.
Atddismissed
No
8612
Atdid: 8612 • Atd Number: ATD-3-3151 • Bblid: 267815
Atdid
8612
Atd Number
ATD-3-3151
Bblid
267815
Inspectionid
330707
Inspect Date
2021-07-02T00:00:00.000
Atdissuedate
2021-12-14T16:01:07.000
Cb
7
House Num
741
Onstname
51ST ST.
Atddismissed
No
9677
Atdid: 9677 • Atd Number: ATD-5-650 • Bblid: 1006664
Atdid
9677
Atd Number
ATD-5-650
Bblid
1006664
Inspectionid
333874
Inspect Date
2016-11-16T00:00:00.000
Atdissuedate
2022-03-16T18:17:45.000
Cb
3
House Num
65
Onstname
AMBER ST.
Atddismissed
No
13658
Atdid: 13658 • Atd Number: ATD-4-5626 • Bblid: 735416
Atdid
13658
Atd Number
ATD-4-5626
Bblid
735416
Inspectionid
366330
Inspect Date
2023-11-04T00:00:00.000
Atdissuedate
2023-11-04T14:06:33.000
Cb
8
House Num
72-12
Onstname
139TH ST.
Atddismissed
No
10464
Atdid: 10464 • Atd Number: ATD-4-4726 • Bblid: 587510
Atdid
10464
Atd Number
ATD-4-4726
Bblid
587510
Inspectionid
339552
Inspect Date
2022-07-14T00:00:00.000
Atdissuedate
2022-07-14T10:51:32.000
Cb
1
House Num
22-50
Onstname
35TH ST.
Atddismissed
No
11107
Atdid: 11107 • Atd Number: ATD-4-4836 • Bblid: 858728
Atdid
11107
Atd Number
ATD-4-4836
Bblid
858728
Inspectionid
345241
Inspect Date
2022-09-29T00:00:00.000
Atdissuedate
2022-10-05T12:59:47.000
Cb
10
House Num
149-35
Onstname
114TH PL.
Atddismissed
No
17274
Atdid: 17274 • Atd Number: ATD-3-6832 • Bblid: 280766
Atdid
17274
Atd Number
ATD-3-6832
Bblid
280766
Inspectionid
393437
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-07T11:47:51.000
Cb
7
House Num
157
Onstname
16TH ST.
Atddismissed
No
17693
Atdid: 17693 • Atd Number: ATD-4-6949 • Bblid: 754094
Atdid
17693
Atd Number
ATD-4-6949
Bblid
754094
Inspectionid
398035
Inspect Date
2025-05-20T00:00:00.000
Atdissuedate
2025-05-21T11:21:07.000
Cb
11
House Num
56-40
Onstname
207TH ST.
Atddismissed
No
12476
Atdid: 12476 • Atd Number: ATD-4-5308 • Bblid: 630376
Atdid
12476
Atd Number
ATD-4-5308
Bblid
630376
Inspectionid
357998
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T11:15:21.000
Cb
2
House Num
46-01
Onstname
48TH AVE.
Atddismissed
No
15015
Atdid: 15015 • Atd Number: ATD-3-6253 • Bblid: 546205
Atdid
15015
Atd Number
ATD-3-6253
Bblid
546205
Inspectionid
381596
Inspect Date
2024-08-13T00:00:00.000
Atdissuedate
2024-09-09T13:33:10.000
Cb
18
House Num
1118
Onstname
E. 72ND ST.
Atddismissed
No
10528
Atdid: 10528 • Atd Number: ATD-3-3979 • Bblid: 421508
Atdid
10528
Atd Number
ATD-3-3979
Bblid
421508
Inspectionid
340150
Inspect Date
2022-06-23T00:00:00.000
Atdissuedate
2022-07-20T15:57:46.000
Cb
12
House Num
1750
Onstname
44TH ST.
Atddismissed
No
12513
Atdid: 12513 • Atd Number: ATD-2-1138 • Bblid: 162039
Atdid
12513
Atd Number
ATD-2-1138
Bblid
162039
Inspectionid
358067
Inspect Date
2023-06-01T00:00:00.000
Atdissuedate
2023-06-05T09:44:44.000
Cb
6
House Num
866
Onstname
HORNADAY PL.
Atddismissed
No
9297
Atdid: 9297 • Atd Number: ATD-3-3401 • Bblid: 301738
Atdid
9297
Atd Number
ATD-3-3401
Bblid
301738
Inspectionid
333003
Inspect Date
2016-03-05T00:00:00.000
Atdissuedate
2022-03-02T08:37:28.000
Cb
3
House Num
848
Onstname
HANCOCK ST.
Atddismissed
No
12971
Atdid: 12971 • Atd Number: ATD-3-5245 • Bblid: 507815
Atdid
12971
Atd Number
ATD-3-5245
Bblid
507815
Inspectionid
360578
Inspect Date
2023-06-27T00:00:00.000
Atdissuedate
2023-07-24T12:12:27.000
Cb
15
House Num
4339
Onstname
BEDFORD AVE.
Atddismissed
No
10565
Atdid: 10565 • Atd Number: ATD-3-4007 • Bblid: 531151
Atdid
10565
Atd Number
ATD-3-4007
Bblid
531151
Inspectionid
340477
Inspect Date
2022-07-26T00:00:00.000
Atdissuedate
2022-07-26T12:37:37.000
Cb
18
House Num
558
Onstname
E. 81ST ST.
Atddismissed
No
8598
Atdid: 8598 • Atd Number: ATD-3-3149 • Bblid: 255497
Atdid
8598
Atd Number
ATD-3-3149
Bblid
255497
Inspectionid
330629
Inspect Date
2021-12-09T00:00:00.000
Atdissuedate
2021-12-13T09:56:45.000
Cb
6
House Num
268
Onstname
COURT ST.
Atddismissed
Yes
Atddismissedon
2022-05-24T09:28:44.000
9676
Atdid: 9676 • Atd Number: ATD-5-649 • Bblid: 944441
Atdid
9676
Atd Number
ATD-5-649
Bblid
944441
Inspectionid
333873
Inspect Date
2021-04-26T00:00:00.000
Atdissuedate
2022-03-16T18:14:13.000
Cb
1
House Num
62
Onstname
TODT HILL RD.
Atddismissed
No
9149
Atdid: 9149 • Atd Number: ATD-4-4176 • Bblid: 706470
Atdid
9149
Atd Number
ATD-4-4176
Bblid
706470
Inspectionid
332732
Inspect Date
2019-08-03T00:00:00.000
Atdissuedate
2022-02-23T15:39:38.000
Cb
7
House Num
43-04
Onstname
COLDEN ST.
Atddismissed
No
12089
Atdid: 12089 • Atd Number: ATD-2-1019 • Bblid: 232531
Atdid
12089
Atd Number
ATD-2-1019
Bblid
232531
Violationid
277138
Reinspectionid
34025
Inspect Date
2023-04-24T14:47:52.000
Atdissuedate
2023-04-24T14:47:52.000
Cb
10
House Num
3169
Atddismissed
Yes
Atddismissedon
2024-05-08T10:37:43.000
11500
Atdid: 11500 • Atd Number: ATD-3-4698 • Bblid: 282592
Atdid
11500
Atd Number
ATD-3-4698
Bblid
282592
Inspectionid
349224
Inspect Date
2022-11-29T00:00:00.000
Atdissuedate
2022-12-12T14:07:42.000
Cb
6
House Num
553
Onstname
3RD ST.
Atddismissed
No
17753
Atdid: 17753 • Atd Number: ATD-3-7011 • Bblid: 489237
Atdid
17753
Atd Number
ATD-3-7011
Bblid
489237
Inspectionid
398724
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-05-28T10:28:37.000
Cb
13
House Num
153
Onstname
BAY 47TH ST.
Atddismissed
No
10434
Atdid: 10434 • Atd Number: ATD-3-3918 • Bblid: 310223
Atdid
10434
Atd Number
ATD-3-3918
Bblid
310223
Inspectionid
339264
Inspect Date
2022-07-12T00:00:00.000
Atdissuedate
2022-07-12T14:30:20.000
Cb
3
House Num
575
Onstname
MACON ST.
Atddismissed
No
16950
Atdid: 16950 • Atd Number: ATD-4-6656 • Bblid: 884047
Atdid
16950
Atd Number
ATD-4-6656
Bblid
884047
Inspectionid
391505
Inspect Date
2025-03-15T00:00:00.000
Atdissuedate
2025-03-17T14:02:09.000
Cb
13
House Num
131-25
Onstname
233RD ST.
Atddismissed
No
10519
Atdid: 10519 • Atd Number: ATD-2-935 • Bblid: 230174
Atdid
10519
Atd Number
ATD-2-935
Bblid
230174
Inspectionid
340095
Inspect Date
2022-07-19T00:00:00.000
Atdissuedate
2022-07-19T15:35:04.000
Cb
10
House Num
1111
Onstname
DEAN AVE.
Atddismissed
No
13186
Atdid: 13186 • Atd Number: ATD-3-5365 • Bblid: 422850
Atdid
13186
Atd Number
ATD-3-5365
Bblid
422850
Inspectionid
361825
Inspect Date
2023-08-10T00:00:00.000
Atdissuedate
2023-08-10T10:33:00.000
Cb
12
House Num
1620
Onstname
46TH ST.
Atddismissed
No
11541
Atdid: 11541 • Atd Number: ATD-1-268 • Bblid: 115076
Atdid
11541
Atd Number
ATD-1-268
Bblid
115076
Inspectionid
349704
Inspect Date
2022-12-07T00:00:00.000
Atdissuedate
2022-12-27T10:34:23.000
Cb
11
House Num
174
Onstname
E. 111TH ST.
Atddismissed
No
18489
Atdid: 18489 • Atd Number: ATD-4-7326 • Bblid: 620523
Atdid
18489
Atd Number
ATD-4-7326
Bblid
620523
Inspectionid
405237
Inspect Date
2025-01-30T00:00:00.000
Atdissuedate
2025-09-04T16:34:04.000
Cb
4
House Num
87-38
Onstname
52ND AVE.
Atddismissed
No
11920
Atdid: 11920 • Atd Number: ATD-3-4871 • Bblid: 286529
Atdid
11920
Atd Number
ATD-3-4871
Bblid
286529
Inspectionid
354167
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-29T12:10:04.000
Cb
8
House Num
223
Onstname
PROSPECT PL.
Atddismissed
No
3832
Atdid: 3832 • Atd Number: ATD-4-457 • Bblid: 804435
Atdid
3832
Atd Number
ATD-4-457
Bblid
804435
Violationid
153250
Atdissuedate
2020-08-17T00:00:00.000
Cb
8
House Num
87-19
Onstname
143 STREET
Atddismissed
Yes
Atddismissedon
2022-04-14T15:07:34.000
18350
Atdid: 18350 • Atd Number: ATD-3-7236 • Bblid: 307035
Atdid
18350
Atd Number
ATD-3-7236
Bblid
307035
Inspectionid
404381
Inspect Date
2025-08-12T00:00:00.000
Atdissuedate
2025-08-18T10:42:31.000
Cb
3
House Num
269
Onstname
VAN BUREN ST.
Atddismissed
No
16549
Atdid: 16549 • Atd Number: ATD-3-6485 • Bblid: 297906
Atdid
16549
Atd Number
ATD-3-6485
Bblid
297906
Inspectionid
386856
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2024-12-19T08:22:44.000
Cb
8
House Num
1223
Onstname
LINCOLN PL.
Atddismissed
No
17386
Atdid: 17386 • Atd Number: ATD-4-6772 • Bblid: 863114
Atdid
17386
Atd Number
ATD-4-6772
Bblid
863114
Inspectionid
394775
Inspect Date
2025-04-02T00:00:00.000
Atdissuedate
2025-04-15T13:07:21.000
Cb
12
House Num
117-01
Onstname
145TH ST.
Atddismissed
No
17700
Atdid: 17700 • Atd Number: ATD-3-6994 • Bblid: 276380
Atdid
17700
Atd Number
ATD-3-6994
Bblid
276380
Inspectionid
398088
Inspect Date
2025-05-17T00:00:00.000
Atdissuedate
2025-05-21T13:44:51.000
Cb
6
House Num
668
Onstname
CARROLL ST.
Atddismissed
No
18479
Atdid: 18479 • Atd Number: ATD-4-7325 • Bblid: 787141
Atdid
18479
Atd Number
ATD-4-7325
Bblid
787141
Inspectionid
405200
Inspect Date
2024-11-14T00:00:00.000
Atdissuedate
2025-09-04T14:01:35.000
Cb
10
House Num
107-56
Onstname
93RD ST.
Atddismissed
No
16783
Atdid: 16783 • Atd Number: ATD-3-6582 • Bblid: 554322
Atdid
16783
Atd Number
ATD-3-6582
Bblid
554322
Inspectionid
389366
Inspect Date
2025-01-14T00:00:00.000
Atdissuedate
2025-02-05T11:17:39.000
Cb
18
House Num
2265
Onstname
RYDER ST.
Atddismissed
Yes
Atddismissedon
2025-03-01T09:21:57.000
10348
Atdid: 10348 • Atd Number: ATD-4-4695 • Bblid: 857015
Atdid
10348
Atd Number
ATD-4-4695
Bblid
857015
Inspectionid
338390
Inspect Date
2022-07-01T00:00:00.000
Atdissuedate
2022-07-01T10:24:35.000
Cb
10
House Num
130-36
Onstname
126TH ST.
Atddismissed
No