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
10211
Atdid: 10211 • Atd Number: ATD-3-3794 • Bblid: 373017
Atdid
10211
Atd Number
ATD-3-3794
Bblid
373017
Inspectionid
337277
Inspect Date
2022-06-02T00:00:00.000
Atdissuedate
2022-06-03T12:08:49.000
Cb
5
House Num
127
Onstname
ESSEX ST.
Atddismissed
No
14421
Atdid: 14421 • Atd Number: ATD-3-5955 • Bblid: 277737
Atdid
14421
Atd Number
ATD-3-5955
Bblid
277737
Inspectionid
377043
Inspect Date
2024-04-16T00:00:00.000
Atdissuedate
2024-05-08T12:48:39.000
Cb
6
House Num
367
Onstname
5TH ST.
Atddismissed
No
12486
Atdid: 12486 • Atd Number: ATD-2-1134 • Bblid: 225444
Atdid
12486
Atd Number
ATD-2-1134
Bblid
225444
Inspectionid
358025
Inspect Date
2023-05-18T00:00:00.000
Atdissuedate
2023-06-02T14:51:54.000
Cb
12
House Num
1912
Onstname
PITMAN AVE.
Atddismissed
No
12665
Atdid: 12665 • Atd Number: ATD-5-707 • Bblid: 1025012
Atdid
12665
Atd Number
ATD-5-707
Bblid
1025012
Inspectionid
359071
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-06-28T14:30:11.000
Cb
3
House Num
3247
Onstname
RICHMOND AVE.
Atddismissed
No
12165
Atdid: 12165 • Atd Number: ATD-3-4995 • Bblid: 396530
Atdid
12165
Atd Number
ATD-3-4995
Bblid
396530
Inspectionid
356735
Inspect Date
2023-04-19T00:00:00.000
Atdissuedate
2023-05-08T10:38:29.000
Cb
17
House Num
648
Onstname
E. 91ST ST.
Atddismissed
No
6243
Atdid: 6243 • Atd Number: ATD-4-2604 • Bblid: 894746
Atdid
6243
Atd Number
ATD-4-2604
Bblid
894746
Violationid
241142
Atdissuedate
2020-06-09T00:00:00.000
Cb
13
House Num
243-46
Onstname
144 AVENUE
Atddismissed
Yes
Atddismissedon
2022-03-18T12:01:31.000
13382
Atdid: 13382 • Atd Number: ATD-5-814 • Bblid: 947898
Atdid
13382
Atd Number
ATD-5-814
Bblid
947898
Inspectionid
363291
Inspect Date
2023-09-07T00:00:00.000
Atdissuedate
2023-09-11T12:47:00.000
Cb
2
House Num
266
Onstname
MARTIN AVE.
Atddismissed
No
14573
Atdid: 14573 • Atd Number: ATD-3-6027 • Bblid: 460450
Atdid
14573
Atd Number
ATD-3-6027
Bblid
460450
Inspectionid
378334
Inspect Date
2024-06-08T00:00:00.000
Atdissuedate
2024-06-10T15:36:38.000
Cb
10
House Num
1357
Onstname
79TH ST.
Atddismissed
No
9286
Atdid: 9286 • Atd Number: ATD-2-887 • Bblid: 180991
Atdid
9286
Atd Number
ATD-2-887
Bblid
180991
Inspectionid
332992
Inspect Date
2020-01-09T00:00:00.000
Atdissuedate
2022-03-02T08:22:22.000
Cb
9
House Num
1477
Onstname
COMMONWEALTH AVE.
Atddismissed
No
18202
Atdid: 18202 • Atd Number: ATD-3-7180 • Bblid: 541541
Atdid
18202
Atd Number
ATD-3-7180
Bblid
541541
Inspectionid
403281
Inspect Date
2025-07-24T00:00:00.000
Atdissuedate
2025-07-28T12:55:31.000
Cb
18
House Num
1371
Onstname
E. 92ND ST.
Atddismissed
No
16397
Atdid: 16397 • Atd Number: ATD-4-6436 • Bblid: 579837
Atdid
16397
Atd Number
ATD-4-6436
Bblid
579837
Inspectionid
385102
Inspect Date
2021-11-10T00:00:00.000
Atdissuedate
2024-11-16T12:15:47.000
Cb
1
House Num
30-38
Onstname
36TH ST.
Atddismissed
No
17754
Atdid: 17754 • Atd Number: ATD-2-1409 • Bblid: 202730
Atdid
17754
Atd Number
ATD-2-1409
Bblid
202730
Inspectionid
398735
Inspect Date
2023-09-17T00:00:00.000
Atdissuedate
2025-05-28T11:00:27.000
Cb
11
House Num
2044
Onstname
BOGART AVE.
Atddismissed
No
13676
Atdid: 13676 • Atd Number: ATD-3-5636 • Bblid: 254461
Atdid
13676
Atd Number
ATD-3-5636
Bblid
254461
Inspectionid
366447
Inspect Date
2023-10-31T00:00:00.000
Atdissuedate
2023-11-13T12:36:06.000
Cb
6
House Num
185
Onstname
BALTIC ST.
Atddismissed
No
15062
Atdid: 15062 • Atd Number: ATD-1-317 • Bblid: 43075
Atdid
15062
Atd Number
ATD-1-317
Bblid
43075
Violationid
251593
Inspectionid
381966
Inspect Date
2024-09-18T13:51:47.000
Atdissuedate
2024-09-18T13:51:47.000
Cb
5
House Num
125
Onstname
EAST 26 STREET
Atddismissed
Yes
Atddismissedon
2024-09-18T13:51:54.000
12517
Atdid: 12517 • Atd Number: ATD-3-5060 • Bblid: 444761
Atdid
12517
Atd Number
ATD-3-5060
Bblid
444761
Inspectionid
358197
Inspect Date
2023-06-01T00:00:00.000
Atdissuedate
2023-06-05T16:04:52.000
Cb
10
House Num
321
Onstname
73RD ST.
Atddismissed
No
10839
Atdid: 10839 • Atd Number: ATD-3-4210 • Bblid: 323370
Atdid
10839
Atd Number
ATD-3-4210
Bblid
323370
Inspectionid
343351
Inspect Date
2022-08-30T00:00:00.000
Atdissuedate
2022-09-12T10:11:31.000
Cb
3
House Num
151
Onstname
CLIFTON PL.
Atddismissed
No
10658
Atdid: 10658 • Atd Number: ATD-3-4056 • Bblid: 482435
Atdid
10658
Atd Number
ATD-3-4056
Bblid
482435
Inspectionid
341670
Inspect Date
2022-08-17T00:00:00.000
Atdissuedate
2022-08-18T08:46:57.000
Cb
14
House Num
1438
Onstname
E. 19TH ST.
Atddismissed
No
18267
Atdid: 18267 • Atd Number: ATD-4-7212 • Bblid: 856067
Atdid
18267
Atd Number
ATD-4-7212
Bblid
856067
Inspectionid
403682
Inspect Date
2025-08-05T00:00:00.000
Atdissuedate
2025-08-06T09:08:43.000
Cb
10
House Num
133-15
Onstname
114TH PL.
Atddismissed
No
14915
Atdid: 14915 • Atd Number: ATD-4-6227 • Bblid: 779833
Atdid
14915
Atd Number
ATD-4-6227
Bblid
779833
Inspectionid
380681
Inspect Date
2024-08-10T00:00:00.000
Atdissuedate
2024-08-16T09:31:02.000
Cb
9
House Num
90-30
Onstname
77TH ST.
Atddismissed
No
16776
Atdid: 16776 • Atd Number: ATD-4-6605 • Bblid: 639371
Atdid
16776
Atd Number
ATD-4-6605
Bblid
639371
Inspectionid
389312
Inspect Date
2025-01-31T00:00:00.000
Atdissuedate
2025-02-04T10:34:56.000
Cb
5
House Num
60-11
Onstname
56TH RD.
Atddismissed
No
17513
Atdid: 17513 • Atd Number: ATD-4-6835 • Bblid: 643850
Atdid
17513
Atd Number
ATD-4-6835
Bblid
643850
Inspectionid
396035
Inspect Date
2025-04-18T00:00:00.000
Atdissuedate
2025-05-05T08:11:19.000
Cb
5
House Num
59-17
Onstname
70TH ST.
Atddismissed
Yes
Atddismissedon
2025-05-05T08:14:57.000
9093
Atdid: 9093 • Atd Number: ATD-4-4142 • Bblid: 628587
Atdid
9093
Atd Number
ATD-4-4142
Bblid
628587
Inspectionid
332644
Inspect Date
2020-12-10T00:00:00.000
Atdissuedate
2022-02-22T12:24:32.000
Cb
6
House Num
105-05
Onstname
62ND DR.
Atddismissed
No
11056
Atdid: 11056 • Atd Number: ATD-3-4404 • Bblid: 316999
Atdid
11056
Atd Number
ATD-3-4404
Bblid
316999
Inspectionid
344841
Inspect Date
2022-09-29T00:00:00.000
Atdissuedate
2022-09-30T11:13:16.000
Cb
3
House Num
193
Onstname
MADISON ST.
Atddismissed
Yes
Atddismissedon
2022-09-30T11:13:28.000
9640
Atdid: 9640 • Atd Number: ATD-4-4344 • Bblid: 735727
Atdid
9640
Atd Number
ATD-4-4344
Bblid
735727
Inspectionid
333809
Inspect Date
2021-03-30T00:00:00.000
Atdissuedate
2022-03-15T19:03:30.000
Cb
8
House Num
137-60
Onstname
71ST AVE.
Atddismissed
No
9702
Atdid: 9702 • Atd Number: ATD-4-4386 • Bblid: 636548
Atdid
9702
Atd Number
ATD-4-4386
Bblid
636548
Inspectionid
334108
Inspect Date
2022-03-24T00:00:00.000
Atdissuedate
2022-03-24T10:52:22.000
Cb
4
House Num
82-25
Onstname
GRAND AVE.
Atddismissed
No
10337
Atdid: 10337 • Atd Number: ATD-4-4686 • Bblid: 847736
Atdid
10337
Atd Number
ATD-4-4686
Bblid
847736
Inspectionid
338291
Inspect Date
2022-06-29T00:00:00.000
Atdissuedate
2022-06-29T13:06:59.000
Cb
10
House Num
80-12
Onstname
151ST AVE.
Atddismissed
No
17993
Atdid: 17993 • Atd Number: ATD-3-7091 • Bblid: 1078583
Atdid
17993
Atd Number
ATD-3-7091
Bblid
1078583
Inspectionid
401617
Inspect Date
2025-06-28T00:00:00.000
Atdissuedate
2025-06-28T14:52:02.000
Cb
5
House Num
589
Onstname
VANDALIA AVE.
Atddismissed
No
11000
Atdid: 11000 • Atd Number: ATD-3-4353 • Bblid: 318197
Atdid
11000
Atd Number
ATD-3-4353
Bblid
318197
Inspectionid
344481
Inspect Date
2022-09-17T00:00:00.000
Atdissuedate
2022-09-23T16:53:29.000
Cb
3
House Num
464
Onstname
JEFFERSON AVE.
Atddismissed
No
17200
Atdid: 17200 • Atd Number: ATD-4-6708 • Bblid: 867465
Atdid
17200
Atd Number
ATD-4-6708
Bblid
867465
Inspectionid
392857
Inspect Date
2025-03-18T00:00:00.000
Atdissuedate
2025-04-01T11:52:09.000
Cb
12
House Num
114-51
Onstname
157TH ST.
Atddismissed
No
17654
Atdid: 17654 • Atd Number: ATD-4-6923 • Bblid: 645019
Atdid
17654
Atd Number
ATD-4-6923
Bblid
645019
Inspectionid
397258
Inspect Date
2025-05-05T00:00:00.000
Atdissuedate
2025-05-16T11:29:42.000
Cb
4
House Num
53-03
Onstname
HASPEL ST.
Atddismissed
No
17175
Atdid: 17175 • Atd Number: ATD-3-6806 • Bblid: 552946
Atdid
17175
Atd Number
ATD-3-6806
Bblid
552946
Inspectionid
392693
Inspect Date
2023-08-09T00:00:00.000
Atdissuedate
2025-03-31T11:19:35.000
Cb
18
House Num
2066
Onstname
KIMBALL ST.
Atddismissed
No
18303
Atdid: 18303 • Atd Number: ATD-4-7232 • Bblid: 858577
Atdid
18303
Atd Number
ATD-4-7232
Bblid
858577
Inspectionid
404010
Inspect Date
2025-08-08T00:00:00.000
Atdissuedate
2025-08-12T09:26:24.000
Cb
10
House Num
135-43
Onstname
114TH ST.
Atddismissed
No
10834
Atdid: 10834 • Atd Number: ATD-3-4205 • Bblid: 323390
Atdid
10834
Atd Number
ATD-3-4205
Bblid
323390
Inspectionid
343342
Inspect Date
2022-08-30T00:00:00.000
Atdissuedate
2022-09-12T10:08:32.000
Cb
3
House Num
129
Onstname
CLIFTON PL.
Atddismissed
No
13422
Atdid: 13422 • Atd Number: ATD-5-820 • Bblid: 1008166
Atdid
13422
Atd Number
ATD-5-820
Bblid
1008166
Inspectionid
363773
Inspect Date
2023-07-15T00:00:00.000
Atdissuedate
2023-09-18T13:56:31.000
Cb
3
House Num
78
Onstname
BLYTHE PL.
Atddismissed
No
13714
Atdid: 13714 • Atd Number: ATD-5-852 • Bblid: 1012905
Atdid
13714
Atd Number
ATD-5-852
Bblid
1012905
Inspectionid
368388
Inspect Date
2023-11-24T00:00:00.000
Atdissuedate
2023-11-27T13:19:52.000
Cb
3
House Num
65
Onstname
HOOPER AVE.
Atddismissed
No
10334
Atdid: 10334 • Atd Number: ATD-3-3859 • Bblid: 315995
Atdid
10334
Atd Number
ATD-3-3859
Bblid
315995
Inspectionid
338227
Inspect Date
2022-06-16T00:00:00.000
Atdissuedate
2022-06-27T14:20:52.000
Cb
3
House Num
715
Onstname
GREENE AVE.
Atddismissed
No
16655
Atdid: 16655 • Atd Number: ATD-3-6523 • Bblid: 283642
Atdid
16655
Atd Number
ATD-3-6523
Bblid
283642
Inspectionid
388533
Inspect Date
2025-01-07T00:00:00.000
Atdissuedate
2025-01-07T11:45:53.000
Cb
6
House Num
505
Onstname
11TH ST.
Atddismissed
No
13868
Atdid: 13868 • Atd Number: ATD-3-5703 • Bblid: 437254
Atdid
13868
Atd Number
ATD-3-5703
Bblid
437254
Inspectionid
370736
Inspect Date
2023-12-27T00:00:00.000
Atdissuedate
2024-01-16T08:38:41.000
Cb
12
House Num
1370
Onstname
58TH ST.
Atddismissed
No
11754
Atdid: 11754 • Atd Number: ATD-4-5032 • Bblid: 626574
Atdid
11754
Atd Number
ATD-4-5032
Bblid
626574
Inspectionid
352556
Inspect Date
2023-03-09T00:00:00.000
Atdissuedate
2023-03-09T12:06:11.000
Cb
4
House Num
111-24
Onstname
42ND AVE.
Atddismissed
No
16852
Atdid: 16852 • Atd Number: ATD-5-912 • Bblid: 969814
Atdid
16852
Atd Number
ATD-5-912
Bblid
969814
Inspectionid
390308
Inspect Date
2025-02-28T00:00:00.000
Atdissuedate
2025-03-05T10:53:24.000
Cb
2
House Num
31
Onstname
BOWLING GREEN PL.
Atddismissed
No
14699
Atdid: 14699 • Atd Number: ATD-3-6107 • Bblid: 432659
Atdid
14699
Atd Number
ATD-3-6107
Bblid
432659
Inspectionid
379088
Inspect Date
2024-07-03T00:00:00.000
Atdissuedate
2024-07-08T10:25:33.000
Cb
12
House Num
4715
Onstname
FORT HAMILTON PKWY.
Atddismissed
No
14517
Atdid: 14517 • Atd Number: ATD-3-5989 • Bblid: 291629
Atdid
14517
Atd Number
ATD-3-5989
Bblid
291629
Inspectionid
377747
Inspect Date
2024-05-18T00:00:00.000
Atdissuedate
2024-05-21T15:36:26.000
Cb
8
House Num
962
Onstname
SAINT JOHNS PL.
Atddismissed
No
12913
Atdid: 12913 • Atd Number: ATD-3-5200 • Bblid: 432107
Atdid
12913
Atd Number
ATD-3-5200
Bblid
432107
Inspectionid
360331
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T10:03:31.000
Cb
12
House Num
1446
Onstname
44TH ST.
Atddismissed
No
16414
Atdid: 16414 • Atd Number: ATD-4-6442 • Bblid: 613489
Atdid
16414
Atd Number
ATD-4-6442
Bblid
613489
Inspectionid
385230
Inspect Date
2024-11-04T00:00:00.000
Atdissuedate
2024-11-20T12:05:32.000
Cb
4
House Num
94-14
Onstname
41ST AVE.
Atddismissed
No
14646
Atdid: 14646 • Atd Number: ATD-2-1287 • Bblid: 152592
Atdid
14646
Atd Number
ATD-2-1287
Bblid
152592
Inspectionid
378713
Inspect Date
2024-06-21T00:00:00.000
Atdissuedate
2024-06-24T15:41:48.000
Cb
4
House Num
1649
Onstname
TOPPING AVE.
Atddismissed
No
9619
Atdid: 9619 • Atd Number: ATD-4-4325 • Bblid: 776214
Atdid
9619
Atd Number
ATD-4-4325
Bblid
776214
Inspectionid
333788
Inspect Date
2019-06-22T00:00:00.000
Atdissuedate
2022-03-15T15:44:32.000
Cb
9
House Num
74-07
Onstname
85TH DR.
Atddismissed
No
17613
Atdid: 17613 • Atd Number: ATD-4-6884 • Bblid: 648943
Atdid
17613
Atd Number
ATD-4-6884
Bblid
648943
Inspectionid
397090
Inspect Date
2025-04-19T00:00:00.000
Atdissuedate
2025-05-15T11:19:40.000
Cb
5
House Num
62-11
Onstname
82ND ST.
Atddismissed
No
9238
Atdid: 9238 • Atd Number: ATD-3-3374 • Bblid: 469335
Atdid
9238
Atd Number
ATD-3-3374
Bblid
469335
Inspectionid
332944
Inspect Date
2021-01-14T00:00:00.000
Atdissuedate
2022-03-01T17:16:32.000
Cb
11
House Num
303
Onstname
BAY 14TH ST.
Atddismissed
No
8846
Atdid: 8846 • Atd Number: ATD-2-854 • Bblid: 199690
Atdid
8846
Atd Number
ATD-2-854
Bblid
199690
Inspectionid
331765
Inspect Date
2008-02-27T00:00:00.000
Atdissuedate
2022-01-21T09:29:13.000
Cb
10
House Num
1848
Onstname
PILGRIM AVE.
Atddismissed
No
16684
Atdid: 16684 • Atd Number: ATD-3-6539 • Bblid: 555801
Atdid
16684
Atd Number
ATD-3-6539
Bblid
555801
Inspectionid
388629
Inspect Date
2024-12-17T00:00:00.000
Atdissuedate
2025-01-09T10:53:58.000
Cb
18
House Num
2458
Onstname
E. 65TH ST.
Atddismissed
No