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
13546
Atdid: 13546 • Atd Number: ATD-4-5585 • Bblid: 755109
Atdid
13546
Atd Number
ATD-4-5585
Bblid
755109
Inspectionid
364967
Inspect Date
2023-10-05T00:00:00.000
Atdissuedate
2023-10-05T14:05:59.000
Cb
11
House Num
50-64
Onstname
231ST ST.
Atddismissed
No
17627
Atdid: 17627 • Atd Number: ATD-3-6979 • Bblid: 282527
Atdid
17627
Atd Number
ATD-3-6979
Bblid
282527
Violationid
301557
Reinspectionid
39338
Inspect Date
2025-05-16T09:10:16.000
Atdissuedate
2025-05-16T09:10:16.000
Cb
6
House Num
603
Onstname
2 STREET
Atddismissed
No
14516
Atdid: 14516 • Atd Number: ATD-4-6074 • Bblid: 851739
Atdid
14516
Atd Number
ATD-4-6074
Bblid
851739
Inspectionid
377699
Inspect Date
2024-05-15T00:00:00.000
Atdissuedate
2024-05-21T11:58:49.000
Cb
10
House Num
111-58
Onstname
114TH ST.
Atddismissed
No
9462
Atdid: 9462 • Atd Number: ATD-5-616 • Bblid: 969691
Atdid
9462
Atd Number
ATD-5-616
Bblid
969691
Inspectionid
333299
Inspect Date
2022-03-05T00:00:00.000
Atdissuedate
2022-03-05T11:02:34.000
Cb
2
House Num
54
Onstname
FREEDOM AVE.
Atddismissed
No
16649
Atdid: 16649 • Atd Number: ATD-4-6548 • Bblid: 785151
Atdid
16649
Atd Number
ATD-4-6548
Bblid
785151
Inspectionid
388493
Inspect Date
2024-10-29T00:00:00.000
Atdissuedate
2025-01-06T09:59:52.000
Cb
10
House Num
103-40
Onstname
96TH ST.
Atddismissed
No
11990
Atdid: 11990 • Atd Number: ATD-4-5109 • Bblid: 720094
Atdid
11990
Atd Number
ATD-4-5109
Bblid
720094
Inspectionid
354518
Inspect Date
2023-03-09T00:00:00.000
Atdissuedate
2023-04-06T11:33:32.000
Cb
11
House Num
58-20
Onstname
188TH ST.
Atddismissed
No
17767
Atdid: 17767 • Atd Number: ATD-4-6994 • Bblid: 717846
Atdid
17767
Atd Number
ATD-4-6994
Bblid
717846
Inspectionid
398880
Inspect Date
2025-05-30T00:00:00.000
Atdissuedate
2025-05-30T14:15:34.000
Cb
11
House Num
46-72
Onstname
188TH ST.
Atddismissed
No
17383
Atdid: 17383 • Atd Number: ATD-3-6896 • Bblid: 525445
Atdid
17383
Atd Number
ATD-3-6896
Bblid
525445
Inspectionid
394753
Inspect Date
2025-04-14T00:00:00.000
Atdissuedate
2025-04-15T10:29:15.000
Cb
18
House Num
2078
Onstname
E. 41ST ST.
Atddismissed
No
13946
Atdid: 13946 • Atd Number: ATD-3-5730 • Bblid: 372551
Atdid
13946
Atd Number
ATD-3-5730
Bblid
372551
Inspectionid
371575
Inspect Date
2024-02-07T00:00:00.000
Atdissuedate
2024-02-14T08:31:05.000
Cb
5
House Num
54
Onstname
BARBEY ST.
Atddismissed
No
12402
Atdid: 12402 • Atd Number: ATD-3-5044 • Bblid: 307765
Atdid
12402
Atd Number
ATD-3-5044
Bblid
307765
Inspectionid
357647
Inspect Date
2023-05-24T00:00:00.000
Atdissuedate
2023-05-25T08:30:43.000
Cb
3
House Num
541
Onstname
QUINCY ST.
Atddismissed
No
10054
Atdid: 10054 • Atd Number: ATD-3-3679 • Bblid: 384416
Atdid
10054
Atd Number
ATD-3-3679
Bblid
384416
Inspectionid
336200
Inspect Date
2022-05-03T00:00:00.000
Atdissuedate
2022-05-05T12:45:42.000
Cb
5
House Num
677
Onstname
AUTUMN AVE.
Atddismissed
No
17652
Atdid: 17652 • Atd Number: ATD-4-6921 • Bblid: 724863
Atdid
17652
Atd Number
ATD-4-6921
Bblid
724863
Inspectionid
397246
Inspect Date
2025-05-15T00:00:00.000
Atdissuedate
2025-05-16T11:20:26.000
Cb
11
House Num
207-43
Onstname
27TH AVE.
Atddismissed
No
12767
Atdid: 12767 • Atd Number: ATD-3-5116 • Bblid: 267407
Atdid
12767
Atd Number
ATD-3-5116
Bblid
267407
Inspectionid
359506
Inspect Date
2023-07-06T00:00:00.000
Atdissuedate
2023-07-06T10:15:50.000
Cb
7
House Num
667
Onstname
50TH ST.
Atddismissed
No
11089
Atdid: 11089 • Atd Number: ATD-3-4437 • Bblid: 555834
Atdid
11089
Atd Number
ATD-3-4437
Bblid
555834
Inspectionid
345100
Inspect Date
2022-09-29T00:00:00.000
Atdissuedate
2022-10-04T08:25:06.000
Cb
18
House Num
2683
Onstname
E. 64TH ST.
Atddismissed
No
18518
Atdid: 18518 • Atd Number: ATD-4-7336 • Bblid: 710692
Atdid
18518
Atd Number
ATD-4-7336
Bblid
710692
Inspectionid
405398
Inspect Date
2025-09-04T00:00:00.000
Atdissuedate
2025-09-08T10:15:48.000
Cb
11
House Num
190-22
Onstname
CROCHERON AVE.
Atddismissed
No
14782
Atdid: 14782 • Atd Number: ATD-3-6134 • Bblid: 480862
Atdid
14782
Atd Number
ATD-3-6134
Bblid
480862
Inspectionid
379710
Inspect Date
2024-07-18T00:00:00.000
Atdissuedate
2024-07-22T14:28:57.000
Cb
14
House Num
1044
Onstname
E. 16TH ST.
Atddismissed
No
14869
Atdid: 14869 • Atd Number: ATD-4-6202 • Bblid: 801988
Atdid
14869
Atd Number
ATD-4-6202
Bblid
801988
Inspectionid
380230
Inspect Date
2023-10-11T00:00:00.000
Atdissuedate
2024-08-05T14:56:29.000
Cb
10
House Num
107-46
Onstname
120TH ST.
Atddismissed
No
9603
Atdid: 9603 • Atd Number: ATD-4-4310 • Bblid: 604666
Atdid
9603
Atd Number
ATD-4-4310
Bblid
604666
Inspectionid
333743
Inspect Date
2021-05-27T00:00:00.000
Atdissuedate
2022-03-14T19:00:02.000
Cb
3
House Num
25-09
Onstname
82ND ST.
Atddismissed
No
13234
Atdid: 13234 • Atd Number: ATD-3-5405 • Bblid: 433088
Atdid
13234
Atd Number
ATD-3-5405
Bblid
433088
Inspectionid
362054
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T16:11:01.000
Cb
12
House Num
1426
Onstname
47TH ST.
Atddismissed
No
17789
Atdid: 17789 • Atd Number: ATD-3-7018 • Bblid: 394655
Atdid
17789
Atd Number
ATD-3-7018
Bblid
394655
Inspectionid
399047
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-04T09:51:17.000
Cb
17
House Num
100
Onstname
E. 59TH ST.
Atddismissed
No
17068
Atdid: 17068 • Atd Number: ATD-3-6723 • Bblid: 279593
Atdid
17068
Atd Number
ATD-3-6723
Bblid
279593
Inspectionid
392412
Inspect Date
2022-09-27T00:00:00.000
Atdissuedate
2025-03-27T12:11:52.000
Cb
6
House Num
237
Onstname
12TH ST.
Atddismissed
No
13385
Atdid: 13385 • Atd Number: ATD-3-5507 • Bblid: 406157
Atdid
13385
Atd Number
ATD-3-5507
Bblid
406157
Inspectionid
363303
Inspect Date
2023-08-22T00:00:00.000
Atdissuedate
2023-09-11T14:06:54.000
Cb
17
House Num
738
Onstname
E. 37TH ST.
Atddismissed
No
18514
Atdid: 18514 • Atd Number: ATD-4-7334 • Bblid: 710706
Atdid
18514
Atd Number
ATD-4-7334
Bblid
710706
Inspectionid
405385
Inspect Date
2025-09-04T00:00:00.000
Atdissuedate
2025-09-08T10:12:48.000
Cb
11
House Num
36-24
Onstname
191ST ST.
Atddismissed
No
14842
Atdid: 14842 • Atd Number: ATD-5-873 • Bblid: 1028741
Atdid
14842
Atd Number
ATD-5-873
Bblid
1028741
Inspectionid
380076
Inspect Date
2024-07-31T00:00:00.000
Atdissuedate
2024-08-01T12:50:49.000
Cb
3
House Num
66
Onstname
GOLD AVE.
Atddismissed
No
12604
Atdid: 12604 • Atd Number: ATD-4-5367 • Bblid: 887433
Atdid
12604
Atd Number
ATD-4-5367
Bblid
887433
Inspectionid
358666
Inspect Date
2023-05-25T00:00:00.000
Atdissuedate
2023-06-15T13:49:23.000
Cb
13
House Num
135-17
Onstname
227TH ST.
Atddismissed
No
16357
Atdid: 16357 • Atd Number: ATD-4-6418 • Bblid: 808316
Atdid
16357
Atd Number
ATD-4-6418
Bblid
808316
Inspectionid
384978
Inspect Date
2024-09-24T00:00:00.000
Atdissuedate
2024-11-12T13:23:06.000
Cb
8
House Num
84-84
Onstname
HOMELAWN ST.
Atddismissed
No
13531
Atdid: 13531 • Atd Number: ATD-4-5570 • Bblid: 761613
Atdid
13531
Atd Number
ATD-4-5570
Bblid
761613
Inspectionid
364836
Inspect Date
2023-09-22T00:00:00.000
Atdissuedate
2023-10-03T15:25:50.000
Cb
13
House Num
88-32
Onstname
240TH ST.
Atddismissed
No
17405
Atdid: 17405 • Atd Number: ATD-3-6897 • Bblid: 357996
Atdid
17405
Atd Number
ATD-3-6897
Bblid
357996
Inspectionid
394976
Inspect Date
2025-03-29T00:00:00.000
Atdissuedate
2025-04-21T10:04:43.000
Cb
4
House Num
295
Onstname
PALMETTO ST.
Atddismissed
No
13980
Atdid: 13980 • Atd Number: ATD-4-5811 • Bblid: 827495
Atdid
13980
Atd Number
ATD-4-5811
Bblid
827495
Inspectionid
371915
Inspect Date
2024-02-02T00:00:00.000
Atdissuedate
2024-02-20T09:40:57.000
Cb
13
House Num
90-06
Onstname
215TH PL.
Atddismissed
No
10266
Atdid: 10266 • Atd Number: ATD-3-3832 • Bblid: 323661
Atdid
10266
Atd Number
ATD-3-3832
Bblid
323661
Inspectionid
337526
Inspect Date
2022-06-08T00:00:00.000
Atdissuedate
2022-06-10T09:27:34.000
Cb
2
House Num
243
Onstname
GREENE AVE.
Atddismissed
No
8867
Atdid: 8867 • Atd Number: ATD-4-4010 • Bblid: 615521
Atdid
8867
Atd Number
ATD-4-4010
Bblid
615521
Inspectionid
331833
Inspect Date
2022-01-12T00:00:00.000
Atdissuedate
2022-01-24T12:12:04.000
Cb
3
House Num
106-18
Onstname
27TH AVE.
Atddismissed
No
12208
Atdid: 12208 • Atd Number: ATD-2-1057 • Bblid: 242433
Atdid
12208
Atd Number
ATD-2-1057
Bblid
242433
Inspectionid
356861
Inspect Date
2023-05-08T00:00:00.000
Atdissuedate
2023-05-10T13:45:38.000
Cb
10
House Num
690
Onstname
MINNIEFORD AVE.
Atddismissed
No
13770
Atdid: 13770 • Atd Number: ATD-4-5675 • Bblid: 818091
Atdid
13770
Atd Number
ATD-4-5675
Bblid
818091
Inspectionid
369308
Inspect Date
2023-10-11T00:00:00.000
Atdissuedate
2023-12-11T16:15:13.000
Cb
12
House Num
108-32
Onstname
173RD ST.
Atddismissed
No
17208
Atdid: 17208 • Atd Number: ATD-2-1365 • Bblid: 208942
Atdid
17208
Atd Number
ATD-2-1365
Bblid
208942
Inspectionid
392900
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-04-01T12:40:30.000
Cb
11
House Num
2761
Onstname
MICKLE AVE.
Atddismissed
No
10346
Atdid: 10346 • Atd Number: ATD-4-4693 • Bblid: 853229
Atdid
10346
Atd Number
ATD-4-4693
Bblid
853229
Inspectionid
338378
Inspect Date
2022-06-09T00:00:00.000
Atdissuedate
2022-07-01T10:05:08.000
Cb
10
House Num
114-36
Onstname
126TH ST.
Atddismissed
No
11785
Atdid: 11785 • Atd Number: ATD-4-5045 • Bblid: 871441
Atdid
11785
Atd Number
ATD-4-5045
Bblid
871441
Inspectionid
352842
Inspect Date
2023-03-05T00:00:00.000
Atdissuedate
2023-03-13T12:34:58.000
Cb
12
House Num
115-19
Onstname
170TH ST.
Atddismissed
No
11890
Atdid: 11890 • Atd Number: ATD-2-995 • Bblid: 223014
Atdid
11890
Atd Number
ATD-2-995
Bblid
223014
Inspectionid
353894
Inspect Date
2023-03-24T00:00:00.000
Atdissuedate
2023-03-27T10:47:52.000
Cb
12
House Num
3967
Onstname
BELL AVE.
Atddismissed
No
10791
Atdid: 10791 • Atd Number: ATD-3-4168 • Bblid: 260854
Atdid
10791
Atd Number
ATD-3-4168
Bblid
260854
Inspectionid
342962
Inspect Date
2022-08-24T00:00:00.000
Atdissuedate
2022-09-08T09:32:11.000
Cb
6
House Num
116
Onstname
2ND ST.
Atddismissed
No
18525
Atdid: 18525 • Atd Number: ATD-3-7302 • Bblid: 378421
Atdid
18525
Atd Number
ATD-3-7302
Bblid
378421
Inspectionid
405410
Inspect Date
2025-08-29T00:00:00.000
Atdissuedate
2025-09-08T10:23:41.000
Cb
5
House Num
650
Onstname
BARBEY ST.
Atddismissed
No
8980
Atdid: 8980 • Atd Number: ATD-4-4074 • Bblid: 677673
Atdid
8980
Atd Number
ATD-4-4074
Bblid
677673
Inspectionid
332292
Inspect Date
2020-12-04T00:00:00.000
Atdissuedate
2022-02-07T15:32:32.000
Cb
5
House Num
87-15
Onstname
UNION TPKE.
Atddismissed
No
8823
Atdid: 8823 • Atd Number: ATD-4-3986 • Bblid: 647759
Atdid
8823
Atd Number
ATD-4-3986
Bblid
647759
Inspectionid
331603
Inspect Date
2022-01-11T00:00:00.000
Atdissuedate
2022-01-12T15:12:25.000
Cb
5
House Num
61-36
Onstname
81ST ST.
Atddismissed
No
9707
Atdid: 9707 • Atd Number: ATD-4-4391 • Bblid: 752610
Atdid
9707
Atd Number
ATD-4-4391
Bblid
752610
Inspectionid
334120
Inspect Date
2021-04-06T00:00:00.000
Atdissuedate
2022-03-24T16:47:22.000
Cb
11
House Num
50-39
Onstname
FRANCIS LEWIS BLVD.
Atddismissed
No
13709
Atdid: 13709 • Atd Number: ATD-4-5645 • Bblid: 859080
Atdid
13709
Atd Number
ATD-4-5645
Bblid
859080
Inspectionid
367897
Inspect Date
2023-11-22T00:00:00.000
Atdissuedate
2023-11-22T12:47:13.000
Cb
10
House Num
149-38
Onstname
121ST ST.
Atddismissed
No
8844
Atdid: 8844 • Atd Number: ATD-4-3995 • Bblid: 635208
Atdid
8844
Atd Number
ATD-4-3995
Bblid
635208
Inspectionid
331753
Inspect Date
2022-01-19T00:00:00.000
Atdissuedate
2022-01-19T14:48:16.000
Cb
4
House Num
51-28
Onstname
MANILLA ST.
Atddismissed
No
16679
Atdid: 16679 • Atd Number: ATD-4-6564 • Bblid: 735798
Atdid
16679
Atd Number
ATD-4-6564
Bblid
735798
Inspectionid
388607
Inspect Date
2024-10-29T00:00:00.000
Atdissuedate
2025-01-08T16:10:02.000
Cb
8
House Num
73-38
Onstname
VLEIGH PL.
Atddismissed
No
10213
Atdid: 10213 • Atd Number: ATD-4-4632 • Bblid: 574252
Atdid
10213
Atd Number
ATD-4-4632
Bblid
574252
Inspectionid
337280
Inspect Date
2022-06-02T00:00:00.000
Atdissuedate
2022-06-03T12:17:09.000
Cb
1
House Num
11-48
Onstname
30TH RD.
Atddismissed
No
9735
Atdid: 9735 • Atd Number: ATD-3-3580 • Bblid: 312495
Atdid
9735
Atd Number
ATD-3-3580
Bblid
312495
Inspectionid
334212
Inspect Date
2022-03-22T00:00:00.000
Atdissuedate
2022-03-28T09:15:34.000
Cb
3
House Num
679
Onstname
PARK AVE.
Atddismissed
No
13430
Atdid: 13430 • Atd Number: ATD-4-5534 • Bblid: 647653
Atdid
13430
Atd Number
ATD-4-5534
Bblid
647653
Inspectionid
363881
Inspect Date
2023-09-15T00:00:00.000
Atdissuedate
2023-09-20T12:30:52.000
Cb
5
House Num
61-80
Onstname
80TH ST.
Atddismissed
No
13580
Atdid: 13580 • Atd Number: ATD-4-5594 • Bblid: 879896
Atdid
13580
Atd Number
ATD-4-5594
Bblid
879896
Inspectionid
365291
Inspect Date
2023-10-13T00:00:00.000
Atdissuedate
2023-10-13T12:56:26.000
Cb
13
House Num
118-36
Onstname
223RD ST.
Atddismissed
No
11736
Atdid: 11736 • Atd Number: ATD-4-5027 • Bblid: 621670
Atdid
11736
Atd Number
ATD-4-5027
Bblid
621670
Inspectionid
352307
Inspect Date
2023-03-03T00:00:00.000
Atdissuedate
2023-03-03T09:58:10.000
Cb
4
House Num
92-18
Onstname
54TH AVE.
Atddismissed
No