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
11683
Atdid: 11683 • Atd Number: ATD-3-4748 • Bblid: 503539
Atdid
11683
Atd Number
ATD-3-4748
Bblid
503539
Inspectionid
351787
Inspect Date
2023-01-24T00:00:00.000
Atdissuedate
2023-02-21T10:26:34.000
Cb
15
House Num
1919
Onstname
E. 24TH ST.
Atddismissed
No
14292
Atdid: 14292 • Atd Number: ATD-4-5957 • Bblid: 626512
Atdid
14292
Atd Number
ATD-4-5957
Bblid
626512
Inspectionid
375527
Inspect Date
2024-04-17T00:00:00.000
Atdissuedate
2024-04-17T12:06:48.000
Cb
4
House Num
111-49
Onstname
42ND AVE.
Atddismissed
No
11533
Atdid: 11533 • Atd Number: ATD-4-4923 • Bblid: 670208
Atdid
11533
Atd Number
ATD-4-4923
Bblid
670208
Inspectionid
349629
Inspect Date
2022-12-21T00:00:00.000
Atdissuedate
2022-12-23T11:49:14.000
Cb
5
House Num
61-49
Onstname
GATES AVE.
Atddismissed
No
12533
Atdid: 12533 • Atd Number: ATD-5-694 • Bblid: 995278
Atdid
12533
Atd Number
ATD-5-694
Bblid
995278
Inspectionid
358358
Inspect Date
2023-05-23T00:00:00.000
Atdissuedate
2023-06-12T10:45:15.000
Cb
2
House Num
143
Onstname
BANCROFT AVE.
Atddismissed
No
11474
Atdid: 11474 • Atd Number: ATD-4-4900 • Bblid: 757032
Atdid
11474
Atd Number
ATD-4-4900
Bblid
757032
Inspectionid
348865
Inspect Date
2019-10-08T00:00:00.000
Atdissuedate
2022-12-01T10:24:15.000
Cb
11
House Num
67-17
Onstname
215TH ST.
Atddismissed
No
15012
Atdid: 15012 • Atd Number: ATD-3-6252 • Bblid: 333590
Atdid
15012
Atd Number
ATD-3-6252
Bblid
333590
Inspectionid
381572
Inspect Date
2024-08-28T00:00:00.000
Atdissuedate
2024-09-09T13:11:19.000
Cb
1
House Num
243
Onstname
LYNCH ST.
Atddismissed
No
17185
Atdid: 17185 • Atd Number: ATD-4-6698 • Bblid: 596316
Atdid
17185
Atd Number
ATD-4-6698
Bblid
596316
Inspectionid
392777
Inspect Date
2022-11-09T00:00:00.000
Atdissuedate
2025-03-31T13:07:13.000
Cb
3
House Num
30-31
Onstname
70TH ST.
Atddismissed
No
9099
Atdid: 9099 • Atd Number: ATD-4-4148 • Bblid: 687866
Atdid
9099
Atd Number
ATD-4-4148
Bblid
687866
Inspectionid
332650
Inspect Date
2019-06-29T00:00:00.000
Atdissuedate
2022-02-22T14:51:31.000
Cb
7
House Num
149-27
Onstname
10TH AVE.
Atddismissed
No
14738
Atdid: 14738 • Atd Number: ATD-3-6124 • Bblid: 530428
Atdid
14738
Atd Number
ATD-3-6124
Bblid
530428
Inspectionid
379326
Inspect Date
2024-05-22T00:00:00.000
Atdissuedate
2024-07-15T09:53:12.000
Cb
17
House Num
5444
Onstname
KINGS HWY.
Atddismissed
No
13482
Atdid: 13482 • Atd Number: ATD-3-5551 • Bblid: 428023
Atdid
13482
Atd Number
ATD-3-5551
Bblid
428023
Inspectionid
364353
Inspect Date
2023-09-16T00:00:00.000
Atdissuedate
2023-09-26T10:33:05.000
Cb
11
House Num
1655
Onstname
64TH ST.
Atddismissed
No
12921
Atdid: 12921 • Atd Number: ATD-3-5208 • Bblid: 431405
Atdid
12921
Atd Number
ATD-3-5208
Bblid
431405
Inspectionid
360340
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T10:30:18.000
Cb
12
House Num
1445
Onstname
44TH ST.
Atddismissed
No
13465
Atdid: 13465 • Atd Number: ATD-4-5544 • Bblid: 841484
Atdid
13465
Atd Number
ATD-4-5544
Bblid
841484
Inspectionid
364204
Inspect Date
2023-09-22T00:00:00.000
Atdissuedate
2023-09-25T13:06:40.000
Cb
13
House Num
105-02
Onstname
223RD ST.
Atddismissed
No
17460
Atdid: 17460 • Atd Number: ATD-4-6814 • Bblid: 798942
Atdid
17460
Atd Number
ATD-4-6814
Bblid
798942
Inspectionid
395438
Inspect Date
2025-04-23T00:00:00.000
Atdissuedate
2025-04-28T11:09:41.000
Cb
10
House Num
107-14
Onstname
LIBERTY AVE.
Atddismissed
Yes
Atddismissedon
2025-08-05T13:26:43.000
14101
Atdid: 14101 • Atd Number: ATD-3-5785 • Bblid: 271408
Atdid
14101
Atd Number
ATD-3-5785
Bblid
271408
Inspectionid
373143
Inspect Date
2024-03-13T00:00:00.000
Atdissuedate
2024-03-13T12:17:56.000
Cb
7
House Num
571
Onstname
17TH ST.
Atddismissed
No
13201
Atdid: 13201 • Atd Number: ATD-3-5380 • Bblid: 281904
Atdid
13201
Atd Number
ATD-3-5380
Bblid
281904
Inspectionid
361844
Inspect Date
2023-08-11T00:00:00.000
Atdissuedate
2023-08-11T08:23:41.000
Cb
6
House Num
851
Onstname
PRESIDENT ST.
Atddismissed
No
13620
Atdid: 13620 • Atd Number: ATD-3-5605 • Bblid: 412158
Atdid
13620
Atd Number
ATD-3-5605
Bblid
412158
Inspectionid
365826
Inspect Date
2023-08-09T00:00:00.000
Atdissuedate
2023-10-25T10:06:45.000
Cb
14
House Num
500
Onstname
E. 18TH ST.
Atddismissed
No
18460
Atdid: 18460 • Atd Number: ATD-4-7315 • Bblid: 727943
Atdid
18460
Atd Number
ATD-4-7315
Bblid
727943
Inspectionid
405029
Inspect Date
2025-08-28T00:00:00.000
Atdissuedate
2025-08-29T13:18:28.000
Cb
11
House Num
36-27
Onstname
203RD ST.
Atddismissed
No
14339
Atdid: 14339 • Atd Number: ATD-4-5988 • Bblid: 649176
Atdid
14339
Atd Number
ATD-4-5988
Bblid
649176
Inspectionid
375980
Inspect Date
2024-04-17T00:00:00.000
Atdissuedate
2024-04-23T13:22:59.000
Cb
5
House Num
75-12
Onstname
JUNIPER BLVD. S.
Atddismissed
No
11881
Atdid: 11881 • Atd Number: ATD-3-4853 • Bblid: 452418
Atdid
11881
Atd Number
ATD-3-4853
Bblid
452418
Inspectionid
353779
Inspect Date
2023-02-15T00:00:00.000
Atdissuedate
2023-03-24T12:25:58.000
Cb
10
House Num
257
Onstname
91ST ST.
Atddismissed
No
16517
Atdid: 16517 • Atd Number: ATD-3-6456 • Bblid: 282532
Atdid
16517
Atd Number
ATD-3-6456
Bblid
282532
Inspectionid
386322
Inspect Date
2024-12-13T00:00:00.000
Atdissuedate
2024-12-16T13:32:20.000
Cb
6
House Num
593
Onstname
2ND ST.
Atddismissed
No
13291
Atdid: 13291 • Atd Number: ATD-3-5451 • Bblid: 476162
Atdid
13291
Atd Number
ATD-3-5451
Bblid
476162
Inspectionid
362385
Inspect Date
2023-08-19T00:00:00.000
Atdissuedate
2023-08-22T12:17:09.000
Cb
11
House Num
1663
Onstname
W. 8TH ST.
Atddismissed
No
16298
Atdid: 16298 • Atd Number: ATD-3-6375 • Bblid: 279069
Atdid
16298
Atd Number
ATD-3-6375
Bblid
279069
Inspectionid
384477
Inspect Date
2024-09-17T00:00:00.000
Atdissuedate
2024-10-28T10:53:02.000
Cb
6
House Num
363
Onstname
11TH ST.
Atddismissed
No
12806
Atdid: 12806 • Atd Number: ATD-3-5140 • Bblid: 484770
Atdid
12806
Atd Number
ATD-3-5140
Bblid
484770
Inspectionid
359741
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-07-10T16:55:25.000
Cb
15
House Num
1744
Onstname
E. 23RD ST.
Atddismissed
No
12409
Atdid: 12409 • Atd Number: ATD-4-5261 • Bblid: 577990
Atdid
12409
Atd Number
ATD-4-5261
Bblid
577990
Inspectionid
357721
Inspect Date
2023-02-16T00:00:00.000
Atdissuedate
2023-05-26T11:00:22.000
Cb
1
House Num
32-64
Onstname
32ND ST.
Atddismissed
Yes
Atddismissedon
2024-03-08T18:23:03.000
14111
Atdid: 14111 • Atd Number: ATD-3-5794 • Bblid: 411668
Atdid
14111
Atd Number
ATD-3-5794
Bblid
411668
Inspectionid
373216
Inspect Date
2024-03-14T00:00:00.000
Atdissuedate
2024-03-14T13:00:46.000
Cb
17
House Num
2402
Onstname
CORTELYOU RD.
Atddismissed
Yes
Atddismissedon
2024-11-06T15:39:54.000
9801
Atdid: 9801 • Atd Number: ATD-1-196 • Bblid: 67884
Atdid
9801
Atd Number
ATD-1-196
Bblid
67884
Inspectionid
334440
Inspect Date
2021-03-19T00:00:00.000
Atdissuedate
2022-03-31T13:00:52.000
Cb
7
House Num
113
Onstname
W. 69TH ST.
Atddismissed
No
16169
Atdid: 16169 • Atd Number: ATD-4-6346 • Bblid: 743508
Atdid
16169
Atd Number
ATD-4-6346
Bblid
743508
Inspectionid
383607
Inspect Date
2024-09-12T00:00:00.000
Atdissuedate
2024-10-01T11:25:50.000
Cb
8
House Num
69-24
Onstname
169TH ST.
Atddismissed
No
10885
Atdid: 10885 • Atd Number: ATD-3-4256 • Bblid: 282127
Atdid
10885
Atd Number
ATD-3-4256
Bblid
282127
Inspectionid
343575
Inspect Date
2022-09-02T00:00:00.000
Atdissuedate
2022-09-12T13:31:46.000
Cb
6
House Num
260
Onstname
GARFIELD PL.
Atddismissed
No
16790
Atdid: 16790 • Atd Number: ATD-3-6587 • Bblid: 258649
Atdid
16790
Atd Number
ATD-3-6587
Bblid
258649
Inspectionid
389521
Inspect Date
2025-02-05T00:00:00.000
Atdissuedate
2025-02-06T13:49:23.000
Cb
6
House Num
482
Onstname
WARREN ST.
Atddismissed
Yes
Atddismissedon
2025-07-25T11:12:03.000
9936
Atdid: 9936 • Atd Number: ATD-4-4515 • Bblid: 654391
Atdid
9936
Atd Number
ATD-4-4515
Bblid
654391
Inspectionid
335338
Inspect Date
2022-04-13T00:00:00.000
Atdissuedate
2022-04-21T12:07:20.000
Cb
6
House Num
65-15
Onstname
CROMWELL CRES
Atddismissed
No
10454
Atdid: 10454 • Atd Number: ATD-3-3934 • Bblid: 417692
Atdid
10454
Atd Number
ATD-3-3934
Bblid
417692
Inspectionid
339437
Inspect Date
2022-06-22T00:00:00.000
Atdissuedate
2022-07-14T08:45:11.000
Cb
12
House Num
246
Onstname
E. 5TH ST.
Atddismissed
No
16587
Atdid: 16587 • Atd Number: ATD-4-6512 • Bblid: 581253
Atdid
16587
Atd Number
ATD-4-6512
Bblid
581253
Inspectionid
387128
Inspect Date
2024-12-02T00:00:00.000
Atdissuedate
2024-12-20T13:46:32.000
Cb
1
House Num
30-90
Onstname
41ST ST.
Atddismissed
No
10187
Atdid: 10187 • Atd Number: ATD-4-4618 • Bblid: 735041
Atdid
10187
Atd Number
ATD-4-4618
Bblid
735041
Inspectionid
337067
Inspect Date
2022-05-18T00:00:00.000
Atdissuedate
2022-05-27T09:15:42.000
Cb
8
House Num
136-60
Onstname
72ND AVE.
Atddismissed
No
8554
Atdid: 8554 • Atd Number: ATD-2-844 • Bblid: 208812
Atdid
8554
Atd Number
ATD-2-844
Bblid
208812
Inspectionid
330360
Inspect Date
2021-11-30T00:00:00.000
Atdissuedate
2021-12-07T13:48:29.000
Cb
12
House Num
3020
Onstname
BRONX PARK E.
Atddismissed
No
11370
Atdid: 11370 • Atd Number: ATD-1-232 • Bblid: 75437
Atdid
11370
Atd Number
ATD-1-232
Bblid
75437
Inspectionid
347902
Inspect Date
2022-11-09T00:00:00.000
Atdissuedate
2022-11-09T14:44:21.000
Cb
7
House Num
161
Onstname
W. 87TH ST.
Atddismissed
No
8510
Atdid: 8510 • Atd Number: ATD-3-3110 • Bblid: 260560
Atdid
8510
Atd Number
ATD-3-3110
Bblid
260560
Violationid
263412
Inspectionid
329691
Inspect Date
2021-11-18T15:55:25.000
Atdissuedate
2021-11-18T15:55:25.000
Cb
6
House Num
38
Onstname
1ST ST.
Atddismissed
No
12916
Atdid: 12916 • Atd Number: ATD-3-5203 • Bblid: 432113
Atdid
12916
Atd Number
ATD-3-5203
Bblid
432113
Inspectionid
360335
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T10:12:33.000
Cb
12
House Num
1460
Onstname
44TH ST.
Atddismissed
No
8708
Atdid: 8708 • Atd Number: ATD-4-3918 • Bblid: 587926
Atdid
8708
Atd Number
ATD-4-3918
Bblid
587926
Inspectionid
330954
Inspect Date
2021-12-21T00:00:00.000
Atdissuedate
2021-12-21T13:56:49.000
Cb
1
House Num
23-51
Onstname
28TH ST.
Atddismissed
No
10741
Atdid: 10741 • Atd Number: ATD-3-4119 • Bblid: 310077
Atdid
10741
Atd Number
ATD-3-4119
Bblid
310077
Inspectionid
342706
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-09-06T13:26:51.000
Cb
3
House Num
497
Onstname
MACON ST.
Atddismissed
No
11422
Atdid: 11422 • Atd Number: ATD-1-254 • Bblid: 119365
Atdid
11422
Atd Number
ATD-1-254
Bblid
119365
Inspectionid
348392
Inspect Date
2022-11-03T00:00:00.000
Atdissuedate
2022-11-18T13:46:25.000
Cb
11
House Num
326
Onstname
E. 120TH ST.
Atddismissed
Yes
Atddismissedon
2023-02-24T11:37:38.000
11203
Atdid: 11203 • Atd Number: ATD-3-4521 • Bblid: 463130
Atdid
11203
Atd Number
ATD-3-4521
Bblid
463130
Inspectionid
346368
Inspect Date
2022-10-07T00:00:00.000
Atdissuedate
2022-10-18T09:54:14.000
Cb
11
House Num
1543
Onstname
83RD ST.
Atddismissed
No
17746
Atdid: 17746 • Atd Number: ATD-2-1406 • Bblid: 199648
Atdid
17746
Atd Number
ATD-2-1406
Bblid
199648
Inspectionid
398695
Inspect Date
2025-05-27T00:00:00.000
Atdissuedate
2025-05-27T19:30:35.000
Cb
10
House Num
1739
Onstname
PARKVIEW AVE.
Atddismissed
No
11632
Atdid: 11632 • Atd Number: ATD-4-4977 • Bblid: 747792
Atdid
11632
Atd Number
ATD-4-4977
Bblid
747792
Inspectionid
350901
Inspect Date
2022-06-13T00:00:00.000
Atdissuedate
2023-01-31T10:39:38.000
Cb
8
House Num
73-20
Onstname
198TH ST.
Atddismissed
No
8932
Atdid: 8932 • Atd Number: ATD-3-3260 • Bblid: 473912
Atdid
8932
Atd Number
ATD-3-3260
Bblid
473912
Inspectionid
332161
Inspect Date
2019-04-23T00:00:00.000
Atdissuedate
2022-01-31T10:56:08.000
Cb
12
House Num
311
Onstname
AVENUE O.
Atddismissed
No
12567
Atdid: 12567 • Atd Number: ATD-2-1144 • Bblid: 209020
Atdid
12567
Atd Number
ATD-2-1144
Bblid
209020
Inspectionid
358550
Inspect Date
2023-06-14T00:00:00.000
Atdissuedate
2023-06-14T16:12:03.000
Cb
11
House Num
952
Onstname
ADEE AVE.
Atddismissed
No
9111
Atdid: 9111 • Atd Number: ATD-4-4160 • Bblid: 657386
Atdid
9111
Atd Number
ATD-4-4160
Bblid
657386
Inspectionid
332662
Inspect Date
2019-06-21T00:00:00.000
Atdissuedate
2022-02-22T15:11:18.000
Cb
6
House Num
68-20
Onstname
EXETER ST.
Atddismissed
No
13604
Atdid: 13604 • Atd Number: ATD-3-5604 • Bblid: 422524
Atdid
13604
Atd Number
ATD-3-5604
Bblid
422524
Inspectionid
365668
Inspect Date
2023-10-18T00:00:00.000
Atdissuedate
2023-10-23T11:55:45.000
Cb
12
House Num
4508
Onstname
17TH AVE.
Atddismissed
No
11123
Atdid: 11123 • Atd Number: ATD-3-4459 • Bblid: 451350
Atdid
11123
Atd Number
ATD-3-4459
Bblid
451350
Inspectionid
345436
Inspect Date
2022-10-07T00:00:00.000
Atdissuedate
2022-10-11T09:37:35.000
Cb
10
House Num
359
Onstname
88TH ST.
Atddismissed
No
11658
Atdid: 11658 • Atd Number: ATD-3-4737 • Bblid: 415358
Atdid
11658
Atd Number
ATD-3-4737
Bblid
415358
Inspectionid
351445
Inspect Date
2022-07-06T00:00:00.000
Atdissuedate
2023-02-13T12:11:02.000
Cb
7
House Num
311
Onstname
VANDERBILT ST.
Atddismissed
No
10921
Atdid: 10921 • Atd Number: ATD-3-4288 • Bblid: 300493
Atdid
10921
Atd Number
ATD-3-4288
Bblid
300493
Inspectionid
343844
Inspect Date
2022-09-14T00:00:00.000
Atdissuedate
2022-09-14T14:42:45.000
Cb
16
House Num
1685
Onstname
PARK PL.
Atddismissed
No