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
17020
Atdid: 17020 • Atd Number: ATD-3-6688 • Bblid: 472310
Atdid
17020
Atd Number
ATD-3-6688
Bblid
472310
Inspectionid
392241
Inspect Date
2025-03-26T00:00:00.000
Atdissuedate
2025-03-26T11:13:00.000
Cb
11
House Num
2235
Onstname
64TH ST.
Atddismissed
No
17333
Atdid: 17333 • Atd Number: ATD-3-6866 • Bblid: 278681
Atdid
17333
Atd Number
ATD-3-6866
Bblid
278681
Inspectionid
394470
Inspect Date
2025-04-05T00:00:00.000
Atdissuedate
2025-04-14T08:53:24.000
Cb
6
House Num
416
Onstname
7TH ST.
Atddismissed
No
14829
Atdid: 14829 • Atd Number: ATD-3-6164 • Bblid: 427120
Atdid
14829
Atd Number
ATD-3-6164
Bblid
427120
Inspectionid
380010
Inspect Date
2024-07-30T00:00:00.000
Atdissuedate
2024-07-31T11:31:12.000
Cb
11
House Num
1855
Onstname
62ND ST.
Atddismissed
No
11902
Atdid: 11902 • Atd Number: ATD-4-5078 • Bblid: 728415
Atdid
11902
Atd Number
ATD-4-5078
Bblid
728415
Inspectionid
354056
Inspect Date
2023-03-24T00:00:00.000
Atdissuedate
2023-03-28T08:10:30.000
Cb
11
House Num
217-41
Onstname
CORBETT RD.
Atddismissed
No
11159
Atdid: 11159 • Atd Number: ATD-3-4484 • Bblid: 546686
Atdid
11159
Atd Number
ATD-3-4484
Bblid
546686
Inspectionid
345979
Inspect Date
2022-10-13T00:00:00.000
Atdissuedate
2022-10-14T14:02:46.000
Cb
18
House Num
7212
Onstname
AVENUE M.
Atddismissed
No
14136
Atdid: 14136 • Atd Number: ATD-4-5895 • Bblid: 647284
Atdid
14136
Atd Number
ATD-4-5895
Bblid
647284
Inspectionid
373360
Inspect Date
2023-11-04T00:00:00.000
Atdissuedate
2024-03-18T10:29:02.000
Cb
5
House Num
61-56
Onstname
78TH ST.
Atddismissed
No
10987
Atdid: 10987 • Atd Number: ATD-3-4340 • Bblid: 406335
Atdid
10987
Atd Number
ATD-3-4340
Bblid
406335
Inspectionid
344451
Inspect Date
2022-09-21T00:00:00.000
Atdissuedate
2022-09-23T14:12:27.000
Cb
17
House Num
645
Onstname
E. 31ST ST.
Atddismissed
No
16619
Atdid: 16619 • Atd Number: ATD-4-6525 • Bblid: 649639
Atdid
16619
Atd Number
ATD-4-6525
Bblid
649639
Inspectionid
387282
Inspect Date
2024-11-02T00:00:00.000
Atdissuedate
2024-12-30T10:48:56.000
Cb
5
House Num
63-40
Onstname
78TH ST.
Atddismissed
No
17229
Atdid: 17229 • Atd Number: ATD-5-952 • Bblid: 1028213
Atdid
17229
Atd Number
ATD-5-952
Bblid
1028213
Inspectionid
393021
Inspect Date
2025-03-29T00:00:00.000
Atdissuedate
2025-04-02T15:59:56.000
Cb
3
House Num
116
Onstname
NOTUS AVE.
Atddismissed
No
12763
Atdid: 12763 • Atd Number: ATD-3-5112 • Bblid: 267423
Atdid
12763
Atd Number
ATD-3-5112
Bblid
267423
Inspectionid
359498
Inspect Date
2023-07-06T00:00:00.000
Atdissuedate
2023-07-06T09:58:08.000
Cb
7
House Num
647
Onstname
50TH ST.
Atddismissed
No
11318
Atdid: 11318 • Atd Number: ATD-3-4604 • Bblid: 298947
Atdid
11318
Atd Number
ATD-3-4604
Bblid
298947
Inspectionid
347446
Inspect Date
2022-10-29T00:00:00.000
Atdissuedate
2022-11-01T15:51:15.000
Cb
9
House Num
831
Onstname
MONTGOMERY ST.
Atddismissed
No
17873
Atdid: 17873 • Atd Number: ATD-4-7060 • Bblid: 768495
Atdid
17873
Atd Number
ATD-4-7060
Bblid
768495
Inspectionid
400255
Inspect Date
2025-06-11T00:00:00.000
Atdissuedate
2025-06-13T08:54:16.000
Cb
11
House Num
57-07
Onstname
HEWLETT ST.
Atddismissed
No
12601
Atdid: 12601 • Atd Number: ATD-4-5364 • Bblid: 770916
Atdid
12601
Atd Number
ATD-4-5364
Bblid
770916
Inspectionid
358637
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-15T11:56:47.000
Cb
13
House Num
85-36
Onstname
252ND ST.
Atddismissed
No
9753
Atdid: 9753 • Atd Number: ATD-3-3589 • Bblid: 524944
Atdid
9753
Atd Number
ATD-3-3589
Bblid
524944
Inspectionid
334328
Inspect Date
2021-04-30T00:00:00.000
Atdissuedate
2022-03-29T12:42:49.000
Cb
18
House Num
1030
Onstname
E. 57TH ST.
Atddismissed
No
8774
Atdid: 8774 • Atd Number: ATD-3-3219 • Bblid: 290597
Atdid
8774
Atd Number
ATD-3-3219
Bblid
290597
Inspectionid
331212
Inspect Date
2021-12-28T00:00:00.000
Atdissuedate
2021-12-29T11:39:18.000
Cb
8
House Num
1133
Onstname
PARK PL.
Atddismissed
No
11222
Atdid: 11222 • Atd Number: ATD-3-4528 • Bblid: 281944
Atdid
11222
Atd Number
ATD-3-4528
Bblid
281944
Inspectionid
346578
Inspect Date
2022-10-20T00:00:00.000
Atdissuedate
2022-10-20T15:13:39.000
Cb
6
House Num
32
Onstname
MONTGOMERY PL.
Atddismissed
No
12676
Atdid: 12676 • Atd Number: ATD-5-718 • Bblid: 1009262
Atdid
12676
Atd Number
ATD-5-718
Bblid
1009262
Inspectionid
359082
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-29T08:37:57.000
Cb
3
House Num
37
Onstname
DEWEY AVE.
Atddismissed
No
18021
Atdid: 18021 • Atd Number: ATD-4-7111 • Bblid: 664012
Atdid
18021
Atd Number
ATD-4-7111
Bblid
664012
Inspectionid
401767
Inspect Date
2025-06-25T00:00:00.000
Atdissuedate
2025-07-03T07:43:52.000
Cb
5
House Num
1704
Onstname
HART ST.
Atddismissed
No
10511
Atdid: 10511 • Atd Number: ATD-4-4743 • Bblid: 690927
Atdid
10511
Atd Number
ATD-4-4743
Bblid
690927
Inspectionid
340050
Inspect Date
2022-07-14T00:00:00.000
Atdissuedate
2022-07-19T12:24:42.000
Cb
7
House Num
147-03
Onstname
18TH AVE.
Atddismissed
No
6054
Atdid: 6054 • Atd Number: ATD-4-2415 • Bblid: 907370
Atdid
6054
Atd Number
ATD-4-2415
Bblid
907370
Violationid
237395
Atdissuedate
2020-06-05T00:00:00.000
Cb
14
House Num
9-10
Onstname
SEAGIRT BOULEVARD
Atddismissed
No
17319
Atdid: 17319 • Atd Number: ATD-3-6857 • Bblid: 319546
Atdid
17319
Atd Number
ATD-3-6857
Bblid
319546
Inspectionid
394426
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-04-14T08:14:12.000
Cb
3
House Num
286
Onstname
MACON ST.
Atddismissed
No
11076
Atdid: 11076 • Atd Number: ATD-3-4424 • Bblid: 279582
Atdid
11076
Atd Number
ATD-3-4424
Bblid
279582
Inspectionid
345022
Inspect Date
2022-09-27T00:00:00.000
Atdissuedate
2022-10-03T09:33:05.000
Cb
6
House Num
263
Onstname
12TH ST.
Atddismissed
No
9680
Atdid: 9680 • Atd Number: ATD-3-3574 • Bblid: 447642
Atdid
9680
Atd Number
ATD-3-3574
Bblid
447642
Inspectionid
333878
Inspect Date
2022-03-15T00:00:00.000
Atdissuedate
2022-03-17T13:06:17.000
Cb
10
House Num
1019
Onstname
78TH ST.
Atddismissed
No
15100
Atdid: 15100 • Atd Number: ATD-4-6299 • Bblid: 808749
Atdid
15100
Atd Number
ATD-4-6299
Bblid
808749
Inspectionid
382178
Inspect Date
2024-09-13T00:00:00.000
Atdissuedate
2024-09-23T13:16:09.000
Cb
8
House Num
175-20
Onstname
MAYFIELD RD.
Atddismissed
No
9986
Atdid: 9986 • Atd Number: ATD-4-4541 • Bblid: 570992
Atdid
9986
Atd Number
ATD-4-4541
Bblid
570992
Inspectionid
335749
Inspect Date
2022-04-27T00:00:00.000
Atdissuedate
2022-04-27T12:31:33.000
Cb
2
House Num
40-13
Onstname
50TH AVE.
Atddismissed
No
10976
Atdid: 10976 • Atd Number: ATD-3-4329 • Bblid: 290601
Atdid
10976
Atd Number
ATD-3-4329
Bblid
290601
Violationid
279354
Inspectionid
331210
Inspect Date
2022-09-22T17:09:18.000
Atdissuedate
2022-09-22T17:09:18.000
Cb
8
House Num
1129
Onstname
PARK PLACE
Atddismissed
No
17841
Atdid: 17841 • Atd Number: ATD-4-7039 • Bblid: 711763
Atdid
17841
Atd Number
ATD-4-7039
Bblid
711763
Inspectionid
399647
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-06-09T12:34:53.000
Cb
7
House Num
41-33
Onstname
159TH ST.
Atddismissed
Yes
Atddismissedon
2025-08-05T13:23:16.000
12105
Atdid: 12105 • Atd Number: ATD-3-4960 • Bblid: 268781
Atdid
12105
Atd Number
ATD-3-4960
Bblid
268781
Inspectionid
356325
Inspect Date
2023-04-19T00:00:00.000
Atdissuedate
2023-04-26T14:07:58.000
Cb
7
House Num
447
Onstname
54TH ST.
Atddismissed
No
8832
Atdid: 8832 • Atd Number: ATD-4-3989 • Bblid: 772872
Atdid
8832
Atd Number
ATD-4-3989
Bblid
772872
Inspectionid
331634
Inspect Date
2021-12-15T00:00:00.000
Atdissuedate
2022-01-13T16:29:52.000
Cb
13
House Num
79-15
Onstname
267TH ST.
Atddismissed
No
15095
Atdid: 15095 • Atd Number: ATD-4-6294 • Bblid: 696616
Atdid
15095
Atd Number
ATD-4-6294
Bblid
696616
Inspectionid
382162
Inspect Date
2024-08-28T00:00:00.000
Atdissuedate
2024-09-23T12:26:51.000
Cb
7
House Num
32-14
Onstname
163RD ST.
Atddismissed
No
12853
Atdid: 12853 • Atd Number: ATD-3-5158 • Bblid: 553816
Atdid
12853
Atd Number
ATD-3-5158
Bblid
553816
Inspectionid
359980
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-07-13T16:07:31.000
Cb
18
House Num
3704
Onstname
AVENUE T.
Atddismissed
No
9650
Atdid: 9650 • Atd Number: ATD-4-4354 • Bblid: 736737
Atdid
9650
Atd Number
ATD-4-4354
Bblid
736737
Inspectionid
333819
Inspect Date
2021-03-26T00:00:00.000
Atdissuedate
2022-03-15T19:15:22.000
Cb
8
House Num
144-31
Onstname
75TH RD.
Atddismissed
No
16394
Atdid: 16394 • Atd Number: ATD-4-6433 • Bblid: 654740
Atdid
16394
Atd Number
ATD-4-6433
Bblid
654740
Inspectionid
385099
Inspect Date
2022-04-28T00:00:00.000
Atdissuedate
2024-11-16T12:09:16.000
Cb
6
House Num
62-30
Onstname
BOELSEN CRES
Atddismissed
No
1885
Atdid: 1885 • Atd Number: ATD-3-1028 • Bblid: 469160
Atdid
1885
Atd Number
ATD-3-1028
Bblid
469160
Violationid
226634
Atdissuedate
2020-01-15T00:00:00.000
Cb
11
House Num
281
Onstname
BAY 13 STREET
Atddismissed
Yes
Atddismissedon
2023-07-13T15:44:53.000
18352
Atdid: 18352 • Atd Number: ATD-3-7238 • Bblid: 307031
Atdid
18352
Atd Number
ATD-3-7238
Bblid
307031
Inspectionid
404385
Inspect Date
2025-08-12T00:00:00.000
Atdissuedate
2025-08-18T10:52:42.000
Cb
3
House Num
273
Onstname
VAN BUREN ST.
Atddismissed
No
14231
Atdid: 14231 • Atd Number: ATD-2-1267 • Bblid: 230941
Atdid
14231
Atd Number
ATD-2-1267
Bblid
230941
Inspectionid
374518
Inspect Date
2024-03-27T00:00:00.000
Atdissuedate
2024-04-01T14:42:57.000
Cb
10
House Num
1306
Onstname
EDWARDS AVE.
Atddismissed
No
5120
Atdid: 5120 • Atd Number: ATD-4-1630 • Bblid: 709271
Atdid
5120
Atd Number
ATD-4-1630
Bblid
709271
Violationid
213047
Atdissuedate
2020-05-08T00:00:00.000
Cb
7
House Num
33-27
Onstname
155 STREET
Atddismissed
Yes
Atddismissedon
2024-07-08T10:06:10.000
17720
Atdid: 17720 • Atd Number: ATD-4-6967 • Bblid: 650810
Atdid
17720
Atd Number
ATD-4-6967
Bblid
650810
Inspectionid
398308
Inspect Date
2025-05-20T00:00:00.000
Atdissuedate
2025-05-23T11:59:21.000
Cb
5
House Num
64-19
Onstname
73 STREET
Atddismissed
No
16384
Atdid: 16384 • Atd Number: ATD-2-1321 • Bblid: 196242
Atdid
16384
Atd Number
ATD-2-1321
Bblid
196242
Inspectionid
385089
Inspect Date
2022-06-08T00:00:00.000
Atdissuedate
2024-11-16T11:03:56.000
Cb
11
House Num
867
Onstname
VAN NEST AVE.
Atddismissed
No
13838
Atdid: 13838 • Atd Number: ATD-4-5728 • Bblid: 740750
Atdid
13838
Atd Number
ATD-4-5728
Bblid
740750
Inspectionid
370376
Inspect Date
2024-01-05T00:00:00.000
Atdissuedate
2024-01-05T14:19:54.000
Cb
8
House Num
153-28
Onstname
78TH RD.
Atddismissed
Yes
Atddismissedon
2024-03-08T17:26:46.000
13637
Atdid: 13637 • Atd Number: ATD-3-5619 • Bblid: 306636
Atdid
13637
Atd Number
ATD-3-5619
Bblid
306636
Inspectionid
366074
Inspect Date
2023-10-28T00:00:00.000
Atdissuedate
2023-10-28T15:12:52.000
Cb
3
House Num
1042
Onstname
DEKALB AVE.
Atddismissed
No
12947
Atdid: 12947 • Atd Number: ATD-3-5224 • Bblid: 478867
Atdid
12947
Atd Number
ATD-3-5224
Bblid
478867
Inspectionid
360447
Inspect Date
2023-07-21T00:00:00.000
Atdissuedate
2023-07-22T09:13:39.000
Cb
11
House Num
1824
Onstname
W. 6TH ST.
Atddismissed
No
13055
Atdid: 13055 • Atd Number: ATD-3-5299 • Bblid: 422508
Atdid
13055
Atd Number
ATD-3-5299
Bblid
422508
Inspectionid
361049
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T16:29:25.000
Cb
12
House Num
1674
Onstname
45TH ST.
Atddismissed
No
17490
Atdid: 17490 • Atd Number: ATD-5-969 • Bblid: 1026230
Atdid
17490
Atd Number
ATD-5-969
Bblid
1026230
Inspectionid
395685
Inspect Date
2025-04-19T00:00:00.000
Atdissuedate
2025-04-30T15:25:57.000
Cb
3
House Num
6
Onstname
ANDREA CT.
Atddismissed
No
11522
Atdid: 11522 • Atd Number: ATD-4-4915 • Bblid: 666669
Atdid
11522
Atd Number
ATD-4-4915
Bblid
666669
Inspectionid
349424
Inspect Date
2022-12-14T00:00:00.000
Atdissuedate
2022-12-16T12:55:01.000
Cb
5
House Num
60-21
Onstname
69TH AVE.
Atddismissed
No
16222
Atdid: 16222 • Atd Number: ATD-4-6371 • Bblid: 908710
Atdid
16222
Atd Number
ATD-4-6371
Bblid
908710
Inspectionid
384129
Inspect Date
2024-10-10T00:00:00.000
Atdissuedate
2024-10-15T11:33:36.000
Cb
14
House Num
31-28
Onstname
MOTT AVE.
Atddismissed
No
11009
Atdid: 11009 • Atd Number: ATD-3-4361 • Bblid: 267188
Atdid
11009
Atd Number
ATD-3-4361
Bblid
267188
Inspectionid
344564
Inspect Date
2022-09-20T00:00:00.000
Atdissuedate
2022-09-26T12:30:17.000
Cb
7
House Num
471
Onstname
50TH ST.
Atddismissed
No
13263
Atdid: 13263 • Atd Number: ATD-3-5434 • Bblid: 404632
Atdid
13263
Atd Number
ATD-3-5434
Bblid
404632
Inspectionid
362096
Inspect Date
2023-08-15T00:00:00.000
Atdissuedate
2023-08-17T08:01:25.000
Cb
17
House Num
698
Onstname
E. 37TH ST.
Atddismissed
No
13675
Atdid: 13675 • Atd Number: ATD-3-5635 • Bblid: 332299
Atdid
13675
Atd Number
ATD-3-5635
Bblid
332299
Inspectionid
366446
Inspect Date
2023-10-19T00:00:00.000
Atdissuedate
2023-11-13T12:35:30.000
Cb
1
House Num
270
Onstname
MARCY AVE.
Atddismissed
No
15041
Atdid: 15041 • Atd Number: ATD-3-6271 • Bblid: 448497
Atdid
15041
Atd Number
ATD-3-6271
Bblid
448497
Inspectionid
381818
Inspect Date
2022-06-14T00:00:00.000
Atdissuedate
2024-09-13T19:15:50.000
Cb
10
House Num
457
Onstname
80TH ST.
Atddismissed
No