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
9866
Atdid: 9866 • Atd Number: ATD-4-4475 • Bblid: 654529
Atdid
9866
Atd Number
ATD-4-4475
Bblid
654529
Inspectionid
334894
Inspect Date
2022-04-08T00:00:00.000
Atdissuedate
2022-04-14T13:02:26.000
Cb
6
House Num
64-22
Onstname
DIETERLE CRES
Atddismissed
No
8366
Atdid: 8366 • Atd Number: ATD-2-816 • Bblid: 224616
Atdid
8366
Atd Number
ATD-2-816
Bblid
224616
Inspectionid
325777
Inspect Date
2021-06-16T00:00:00.000
Atdissuedate
2021-06-16T00:00:00.000
Cb
12
House Num
646
Onstname
E. 236TH ST.
Atddismissed
Yes
Atddismissedon
2022-05-24T09:01:54.000
17096
Atdid: 17096 • Atd Number: ATD-3-6743 • Bblid: 333486
Atdid
17096
Atd Number
ATD-3-6743
Bblid
333486
Inspectionid
392476
Inspect Date
2022-09-08T00:00:00.000
Atdissuedate
2025-03-28T09:56:26.000
Cb
1
House Num
137
Onstname
LYNCH ST.
Atddismissed
No
10491
Atdid: 10491 • Atd Number: ATD-3-3960 • Bblid: 255649
Atdid
10491
Atd Number
ATD-3-3960
Bblid
255649
Inspectionid
339878
Inspect Date
2022-07-16T00:00:00.000
Atdissuedate
2022-07-16T14:57:42.000
Cb
6
House Num
296
Onstname
DEGRAW ST.
Atddismissed
No
12389
Atdid: 12389 • Atd Number: ATD-4-5255 • Bblid: 604435
Atdid
12389
Atd Number
ATD-4-5255
Bblid
604435
Inspectionid
357546
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:48:37.000
Cb
2
House Num
70-65
Onstname
QUEENS BLVD.
Atddismissed
No
17317
Atdid: 17317 • Atd Number: ATD-3-6855 • Bblid: 319544
Atdid
17317
Atd Number
ATD-3-6855
Bblid
319544
Inspectionid
394424
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-04-14T08:11:47.000
Cb
3
House Num
282
Onstname
MACON ST.
Atddismissed
No
17035
Atdid: 17035 • Atd Number: ATD-4-6683 • Bblid: 590161
Atdid
17035
Atd Number
ATD-4-6683
Bblid
590161
Inspectionid
392304
Inspect Date
2025-03-21T00:00:00.000
Atdissuedate
2025-03-26T13:01:58.000
Cb
1
House Num
22-65
Onstname
21ST ST.
Atddismissed
Yes
Atddismissedon
2025-07-29T08:57:36.000
8729
Atdid: 8729 • Atd Number: ATD-4-3925 • Bblid: 784804
Atdid
8729
Atd Number
ATD-4-3925
Bblid
784804
Inspectionid
331069
Inspect Date
2021-12-28T00:00:00.000
Atdissuedate
2021-12-28T10:36:39.000
Cb
9
House Num
81-35
Onstname
102ND RD.
Atddismissed
No
16241
Atdid: 16241 • Atd Number: ATD-4-6384 • Bblid: 906970
Atdid
16241
Atd Number
ATD-4-6384
Bblid
906970
Inspectionid
384179
Inspect Date
2023-04-25T00:00:00.000
Atdissuedate
2024-10-15T14:02:50.000
Cb
14
House Num
12-04
Onstname
FRISCO AVE.
Atddismissed
No
16199
Atdid: 16199 • Atd Number: ATD-4-6358 • Bblid: 655103
Atdid
16199
Atd Number
ATD-4-6358
Bblid
655103
Inspectionid
383957
Inspect Date
2024-09-25T00:00:00.000
Atdissuedate
2024-10-09T11:52:48.000
Cb
6
House Num
85-27
Onstname
67TH AVE.
Atddismissed
No
13480
Atdid: 13480 • Atd Number: ATD-3-5549 • Bblid: 428350
Atdid
13480
Atd Number
ATD-3-5549
Bblid
428350
Inspectionid
364339
Inspect Date
2023-09-16T00:00:00.000
Atdissuedate
2023-09-26T10:25:48.000
Cb
11
House Num
1692
Onstname
64TH ST.
Atddismissed
No
9882
Atdid: 9882 • Atd Number: ATD-4-4489 • Bblid: 746836
Atdid
9882
Atd Number
ATD-4-4489
Bblid
746836
Inspectionid
334973
Inspect Date
2022-04-08T00:00:00.000
Atdissuedate
2022-04-15T10:59:50.000
Cb
8
House Num
67-16
Onstname
199TH ST.
Atddismissed
No
10413
Atdid: 10413 • Atd Number: ATD-4-4714 • Bblid: 724349
Atdid
10413
Atd Number
ATD-4-4714
Bblid
724349
Inspectionid
339081
Inspect Date
2022-06-29T00:00:00.000
Atdissuedate
2022-07-11T11:19:55.000
Cb
11
House Num
28-27
Onstname
JORDAN ST.
Atddismissed
No
10543
Atdid: 10543 • Atd Number: ATD-3-3993 • Bblid: 531199
Atdid
10543
Atd Number
ATD-3-3993
Bblid
531199
Inspectionid
340265
Inspect Date
2022-07-21T00:00:00.000
Atdissuedate
2022-07-21T14:11:25.000
Cb
18
House Num
587
Onstname
E. 81ST ST.
Atddismissed
No
18401
Atdid: 18401 • Atd Number: ATD-4-7284 • Bblid: 907331
Atdid
18401
Atd Number
ATD-4-7284
Bblid
907331
Inspectionid
404664
Inspect Date
2025-04-29T00:00:00.000
Atdissuedate
2025-08-22T09:46:23.000
Cb
14
House Num
332
Onstname
BEACH 12TH ST.
Atddismissed
No
13469
Atdid: 13469 • Atd Number: ATD-4-5545 • Bblid: 825027
Atdid
13469
Atd Number
ATD-4-5545
Bblid
825027
Inspectionid
364220
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-09-25T13:45:24.000
Cb
13
House Num
91-19
Onstname
210TH PL.
Atddismissed
No
10113
Atdid: 10113 • Atd Number: ATD-3-3730 • Bblid: 412895
Atdid
10113
Atd Number
ATD-3-3730
Bblid
412895
Inspectionid
336554
Inspect Date
2022-05-17T00:00:00.000
Atdissuedate
2022-05-18T07:44:25.000
Cb
14
House Num
576
Onstname
RUGBY RD.
Atddismissed
No
18229
Atdid: 18229 • Atd Number: ATD-3-7193 • Bblid: 379448
Atdid
18229
Atd Number
ATD-3-7193
Bblid
379448
Inspectionid
403495
Inspect Date
2025-07-15T00:00:00.000
Atdissuedate
2025-08-04T09:45:22.000
Cb
5
House Num
119
Onstname
RICHMOND ST.
Atddismissed
No
11842
Atdid: 11842 • Atd Number: ATD-3-4816 • Bblid: 286195
Atdid
11842
Atd Number
ATD-3-4816
Bblid
286195
Inspectionid
353518
Inspect Date
2023-03-21T00:00:00.000
Atdissuedate
2023-03-21T14:56:59.000
Cb
8
House Num
149
Onstname
SAINT MARKS AVE.
Atddismissed
No
17252
Atdid: 17252 • Atd Number: ATD-4-6734 • Bblid: 586229
Atdid
17252
Atd Number
ATD-4-6734
Bblid
586229
Inspectionid
393200
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-04T11:33:05.000
Cb
1
House Num
21-36
Onstname
STEINWAY ST.
Atddismissed
No
12318
Atdid: 12318 • Atd Number: ATD-2-1115 • Bblid: 162686
Atdid
12318
Atd Number
ATD-2-1115
Bblid
162686
Inspectionid
357369
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T12:28:08.000
Cb
5
House Num
67
Onstname
E. BURNSIDE AVE.
Atddismissed
No
14652
Atdid: 14652 • Atd Number: ATD-3-6074 • Bblid: 510699
Atdid
14652
Atd Number
ATD-3-6074
Bblid
510699
Violationid
289926
Reinspectionid
36100
Inspect Date
2024-06-25T10:49:56.000
Atdissuedate
2024-06-25T10:49:56.000
Cb
15
House Num
2544
Onstname
EAST 15 STREET
Atddismissed
No
10632
Atdid: 10632 • Atd Number: ATD-3-4041 • Bblid: 554969
Atdid
10632
Atd Number
ATD-3-4041
Bblid
554969
Inspectionid
341262
Inspect Date
2022-08-09T00:00:00.000
Atdissuedate
2022-08-09T15:19:00.000
Cb
18
House Num
2744
Onstname
ARKANSAS DR.
Atddismissed
No
9473
Atdid: 9473 • Atd Number: ATD-4-4252 • Bblid: 737823
Atdid
9473
Atd Number
ATD-4-4252
Bblid
737823
Inspectionid
333377
Inspect Date
2019-08-16T00:00:00.000
Atdissuedate
2022-03-07T16:07:40.000
Cb
8
House Num
150-49
Onstname
78TH RD.
Atddismissed
No
13331
Atdid: 13331 • Atd Number: ATD-3-5473 • Bblid: 487925
Atdid
13331
Atd Number
ATD-3-5473
Bblid
487925
Inspectionid
362645
Inspect Date
2023-08-23T00:00:00.000
Atdissuedate
2023-08-28T11:23:32.000
Cb
11
House Num
124
Onstname
BAY 37TH ST.
Atddismissed
No
10925
Atdid: 10925 • Atd Number: ATD-3-4292 • Bblid: 276336
Atdid
10925
Atd Number
ATD-3-4292
Bblid
276336
Violationid
278008
Reinspectionid
33022
Inspect Date
2022-09-15T13:51:45.000
Atdissuedate
2022-09-15T13:51:45.000
Cb
6
House Num
37
Onstname
GARFIELD PLACE
Atddismissed
No
16452
Atdid: 16452 • Atd Number: ATD-3-6437 • Bblid: 471404
Atdid
16452
Atd Number
ATD-3-6437
Bblid
471404
Inspectionid
385520
Inspect Date
2023-12-27T00:00:00.000
Atdissuedate
2024-12-02T11:02:10.000
Cb
12
House Num
1341
Onstname
E. 3RD ST.
Atddismissed
No
11463
Atdid: 11463 • Atd Number: ATD-3-4673 • Bblid: 315639
Atdid
11463
Atd Number
ATD-3-4673
Bblid
315639
Inspectionid
348744
Inspect Date
2022-11-03T00:00:00.000
Atdissuedate
2022-11-28T12:02:40.000
Cb
3
House Num
103
Onstname
CHAUNCEY ST.
Atddismissed
No
9495
Atdid: 9495 • Atd Number: ATD-4-4259 • Bblid: 737861
Atdid
9495
Atd Number
ATD-4-4259
Bblid
737861
Inspectionid
333421
Inspect Date
2019-08-16T00:00:00.000
Atdissuedate
2022-03-08T15:37:30.000
Cb
8
House Num
150-11
Onstname
78TH RD.
Atddismissed
No
8874
Atdid: 8874 • Atd Number: ATD-3-3240 • Bblid: 506222
Atdid
8874
Atd Number
ATD-3-3240
Bblid
506222
Inspectionid
331869
Inspect Date
2022-01-25T00:00:00.000
Atdissuedate
2022-01-25T10:30:55.000
Cb
15
House Num
2144
Onstname
E. 19TH ST.
Atddismissed
No
9696
Atdid: 9696 • Atd Number: ATD-4-4380 • Bblid: 668893
Atdid
9696
Atd Number
ATD-4-4380
Bblid
668893
Inspectionid
334077
Inspect Date
2022-03-15T00:00:00.000
Atdissuedate
2022-03-23T15:09:06.000
Cb
5
House Num
17-08
Onstname
STEPHEN ST.
Atddismissed
No
12195
Atdid: 12195 • Atd Number: ATD-2-1047 • Bblid: 166822
Atdid
12195
Atd Number
ATD-2-1047
Bblid
166822
Inspectionid
356837
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2023-05-09T14:41:49.000
Cb
7
House Num
2754
Onstname
GRAND CONCOURSE
Atddismissed
No
9869
Atdid: 9869 • Atd Number: ATD-4-4478 • Bblid: 895213
Atdid
9869
Atd Number
ATD-4-4478
Bblid
895213
Inspectionid
334906
Inspect Date
2022-04-14T00:00:00.000
Atdissuedate
2022-04-14T14:13:24.000
Cb
13
House Num
257-19
Onstname
147TH AVE.
Atddismissed
No
17393
Atdid: 17393 • Atd Number: ATD-4-6779 • Bblid: 852756
Atdid
17393
Atd Number
ATD-4-6779
Bblid
852756
Inspectionid
394839
Inspect Date
2025-04-10T00:00:00.000
Atdissuedate
2025-04-16T16:14:24.000
Cb
10
House Num
114-12
Onstname
120TH ST.
Atddismissed
No
14505
Atdid: 14505 • Atd Number: ATD-3-5988 • Bblid: 405381
Atdid
14505
Atd Number
ATD-3-5988
Bblid
405381
Inspectionid
377577
Inspect Date
2024-04-23T00:00:00.000
Atdissuedate
2024-05-20T14:10:08.000
Cb
17
House Num
785
Onstname
E. 37TH ST.
Atddismissed
No
12651
Atdid: 12651 • Atd Number: ATD-4-5392 • Bblid: 605667
Atdid
12651
Atd Number
ATD-4-5392
Bblid
605667
Inspectionid
358961
Inspect Date
2023-06-23T00:00:00.000
Atdissuedate
2023-06-23T13:31:40.000
Cb
3
House Num
26-23
Onstname
95TH ST.
Atddismissed
No
5062
Atdid: 5062 • Atd Number: ATD-4-1581 • Bblid: 658071
Atdid
5062
Atd Number
ATD-4-1581
Bblid
658071
Violationid
211971
Atdissuedate
2020-05-05T00:00:00.000
Cb
6
House Num
93-14
Onstname
70 AVENUE
Atddismissed
Yes
Atddismissedon
2025-05-20T14:39:18.000
14263
Atdid: 14263 • Atd Number: ATD-3-5882 • Bblid: 485753
Atdid
14263
Atd Number
ATD-3-5882
Bblid
485753
Inspectionid
375161
Inspect Date
2024-03-26T00:00:00.000
Atdissuedate
2024-04-10T12:14:43.000
Cb
15
House Num
1826
Onstname
E. 23RD ST.
Atddismissed
No
16444
Atdid: 16444 • Atd Number: ATD-4-6461 • Bblid: 735006
Atdid
16444
Atd Number
ATD-4-6461
Bblid
735006
Inspectionid
385442
Inspect Date
2024-11-25T00:00:00.000
Atdissuedate
2024-11-29T07:46:12.000
Cb
8
House Num
73-28
Onstname
136TH ST.
Atddismissed
No
12901
Atdid: 12901 • Atd Number: ATD-4-5455 • Bblid: 760367
Atdid
12901
Atd Number
ATD-4-5455
Bblid
760367
Inspectionid
360302
Inspect Date
2023-05-10T00:00:00.000
Atdissuedate
2023-07-20T09:01:32.000
Cb
13
House Num
232-11
Onstname
HILLSIDE AVE.
Atddismissed
No
17568
Atdid: 17568 • Atd Number: ATD-3-6961 • Bblid: 287422
Atdid
17568
Atd Number
ATD-3-6961
Bblid
287422
Inspectionid
396541
Inspect Date
2025-05-06T00:00:00.000
Atdissuedate
2025-05-08T09:03:17.000
Cb
8
House Num
280
Onstname
PARK PL.
Atddismissed
No
9767
Atdid: 9767 • Atd Number: ATD-4-4421 • Bblid: 764313
Atdid
9767
Atd Number
ATD-4-4421
Bblid
764313
Inspectionid
334360
Inspect Date
2019-12-31T00:00:00.000
Atdissuedate
2022-03-29T18:02:08.000
Cb
11
House Num
41-76
Onstname
GLENWOOD ST.
Atddismissed
No
14433
Atdid: 14433 • Atd Number: ATD-3-5967 • Bblid: 277820
Atdid
14433
Atd Number
ATD-3-5967
Bblid
277820
Inspectionid
377102
Inspect Date
2024-04-23T00:00:00.000
Atdissuedate
2024-05-08T13:35:08.000
Cb
6
House Num
421
Onstname
6TH ST.
Atddismissed
No
18413
Atdid: 18413 • Atd Number: ATD-3-7262 • Bblid: 478111
Atdid
18413
Atd Number
ATD-3-7262
Bblid
478111
Inspectionid
404709
Inspect Date
2025-08-22T00:00:00.000
Atdissuedate
2025-08-25T10:29:34.000
Cb
15
House Num
1846
Onstname
E. 5TH ST.
Atddismissed
No
8880
Atdid: 8880 • Atd Number: ATD-4-4020 • Bblid: 646152
Atdid
8880
Atd Number
ATD-4-4020
Bblid
646152
Inspectionid
331922
Inspect Date
2021-12-30T00:00:00.000
Atdissuedate
2022-01-25T20:13:19.000
Cb
4
House Num
84-24
Onstname
55TH RD.
Atddismissed
No
10280
Atdid: 10280 • Atd Number: ATD-3-3837 • Bblid: 414595
Atdid
10280
Atd Number
ATD-3-3837
Bblid
414595
Inspectionid
337642
Inspect Date
2022-05-25T00:00:00.000
Atdissuedate
2022-06-13T12:55:28.000
Cb
7
House Num
88
Onstname
SHERMAN ST.
Atddismissed
No
9160
Atdid: 9160 • Atd Number: ATD-3-3335 • Bblid: 406782
Atdid
9160
Atd Number
ATD-3-3335
Bblid
406782
Inspectionid
332778
Inspect Date
2019-07-12T00:00:00.000
Atdissuedate
2022-02-25T12:48:23.000
Cb
9
House Num
205
Onstname
OCEAN AVE.
Atddismissed
No
16796
Atdid: 16796 • Atd Number: ATD-1-368 • Bblid: 116818
Atdid
16796
Atd Number
ATD-1-368
Bblid
116818
Inspectionid
389571
Inspect Date
2025-01-28T00:00:00.000
Atdissuedate
2025-02-07T13:26:37.000
Cb
10
House Num
66
Onstname
W. 120TH ST.
Atddismissed
No
14458
Atdid: 14458 • Atd Number: ATD-4-6036 • Bblid: 860898
Atdid
14458
Atd Number
ATD-4-6036
Bblid
860898
Inspectionid
377268
Inspect Date
2024-03-12T00:00:00.000
Atdissuedate
2024-05-13T11:25:44.000
Cb
12
House Num
111-71
Onstname
145TH ST.
Atddismissed
No
10589
Atdid: 10589 • Atd Number: ATD-3-4017 • Bblid: 434169
Atdid
10589
Atd Number
ATD-3-4017
Bblid
434169
Inspectionid
340742
Inspect Date
2022-07-08T00:00:00.000
Atdissuedate
2022-08-02T10:40:45.000
Cb
12
House Num
1355
Onstname
52ND ST.
Atddismissed
No