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
17636
Atdid: 17636 • Atd Number: ATD-4-6905 • Bblid: 760886
Atdid
17636
Atd Number
ATD-4-6905
Bblid
760886
Inspectionid
397205
Inspect Date
2025-01-17T00:00:00.000
Atdissuedate
2025-05-16T10:26:16.000
Cb
13
House Num
237-21
Onstname
88TH AVE.
Atddismissed
No
11060
Atdid: 11060 • Atd Number: ATD-3-4408 • Bblid: 469730
Atdid
11060
Atd Number
ATD-3-4408
Bblid
469730
Inspectionid
344949
Inspect Date
2022-09-29T00:00:00.000
Atdissuedate
2022-09-30T17:04:45.000
Cb
11
House Num
8828
Onstname
20TH AVE.
Atddismissed
No
10077
Atdid: 10077 • Atd Number: ATD-3-3697 • Bblid: 407417
Atdid
10077
Atd Number
ATD-3-3697
Bblid
407417
Inspectionid
336349
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-11T12:35:16.000
Cb
9
House Num
258
Onstname
MIDWOOD ST.
Atddismissed
No
12067
Atdid: 12067 • Atd Number: ATD-3-4942 • Bblid: 250900
Atdid
12067
Atd Number
ATD-3-4942
Bblid
250900
Inspectionid
356077
Inspect Date
2023-04-20T00:00:00.000
Atdissuedate
2023-04-20T12:33:42.000
Cb
2
House Num
531
Onstname
PACIFIC ST.
Atddismissed
No
13930
Atdid: 13930 • Atd Number: ATD-4-5779 • Bblid: 638399
Atdid
13930
Atd Number
ATD-4-5779
Bblid
638399
Inspectionid
371385
Inspect Date
2024-02-08T00:00:00.000
Atdissuedate
2024-02-08T09:02:51.000
Cb
5
House Num
58-31
Onstname
58TH AVE.
Atddismissed
No
16403
Atdid: 16403 • Atd Number: ATD-5-891 • Bblid: 1035802
Atdid
16403
Atd Number
ATD-5-891
Bblid
1035802
Inspectionid
385108
Inspect Date
2023-06-21T00:00:00.000
Atdissuedate
2024-11-16T12:43:26.000
Cb
3
House Num
978
Onstname
DRUMGOOLE RD. W.
Atddismissed
No
13698
Atdid: 13698 • Atd Number: ATD-2-1253 • Bblid: 196184
Atdid
13698
Atd Number
ATD-2-1253
Bblid
196184
Inspectionid
367701
Inspect Date
2023-11-17T00:00:00.000
Atdissuedate
2023-11-17T16:08:32.000
Cb
11
House Num
1706
Onstname
BARNES AVE.
Atddismissed
No
12426
Atdid: 12426 • Atd Number: ATD-1-291 • Bblid: 103881
Atdid
12426
Atd Number
ATD-1-291
Bblid
103881
Inspectionid
357751
Inspect Date
2023-05-26T00:00:00.000
Atdissuedate
2023-05-26T12:57:49.000
Cb
8
House Num
133
Onstname
E. 80TH ST.
Atddismissed
No
13701
Atdid: 13701 • Atd Number: ATD-4-5641 • Bblid: 689834
Atdid
13701
Atd Number
ATD-4-5641
Bblid
689834
Inspectionid
367714
Inspect Date
2023-11-18T00:00:00.000
Atdissuedate
2023-11-18T08:58:49.000
Cb
7
House Num
162-47
Onstname
12TH AVE.
Atddismissed
No
9634
Atdid: 9634 • Atd Number: ATD-4-4338 • Bblid: 735677
Atdid
9634
Atd Number
ATD-4-4338
Bblid
735677
Inspectionid
333803
Inspect Date
2021-03-31T00:00:00.000
Atdissuedate
2022-03-15T18:55:29.000
Cb
8
House Num
70-30
Onstname
137TH ST.
Atddismissed
No
10041
Atdid: 10041 • Atd Number: ATD-4-4582 • Bblid: 654742
Atdid
10041
Atd Number
ATD-4-4582
Bblid
654742
Inspectionid
336070
Inspect Date
2022-04-28T00:00:00.000
Atdissuedate
2022-05-03T12:04:07.000
Cb
6
House Num
62-34
Onstname
BOELSEN CRES
Atddismissed
No
17839
Atdid: 17839 • Atd Number: ATD-4-7037 • Bblid: 810868
Atdid
17839
Atd Number
ATD-4-7037
Bblid
810868
Inspectionid
399587
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-09T12:09:25.000
Cb
8
House Num
85-15
Onstname
RADNOR ST.
Atddismissed
No
10209
Atdid: 10209 • Atd Number: ATD-3-3792 • Bblid: 373023
Atdid
10209
Atd Number
ATD-3-3792
Bblid
373023
Inspectionid
337274
Inspect Date
2022-06-02T00:00:00.000
Atdissuedate
2022-06-03T12:07:34.000
Cb
5
House Num
121
Onstname
ESSEX ST.
Atddismissed
No
13859
Atdid: 13859 • Atd Number: ATD-3-5701 • Bblid: 399301
Atdid
13859
Atd Number
ATD-3-5701
Bblid
399301
Inspectionid
370615
Inspect Date
2024-01-11T00:00:00.000
Atdissuedate
2024-01-11T11:41:33.000
Cb
9
House Num
693
Onstname
WINTHROP ST.
Atddismissed
No
16515
Atdid: 16515 • Atd Number: ATD-3-6454 • Bblid: 351016
Atdid
16515
Atd Number
ATD-3-6454
Bblid
351016
Violationid
286066
Reinspectionid
35695
Inspect Date
2024-12-16T11:56:11.000
Atdissuedate
2024-12-16T11:56:11.000
Cb
4
House Num
19
Onstname
GARDEN STREET
Atddismissed
No
11482
Atdid: 11482 • Atd Number: ATD-1-261 • Bblid: 137393
Atdid
11482
Atd Number
ATD-1-261
Bblid
137393
Inspectionid
349049
Inspect Date
2022-11-23T00:00:00.000
Atdissuedate
2022-12-06T12:24:01.000
Cb
12
House Num
527
Onstname
W. 217TH ST.
Atddismissed
No
14403
Atdid: 14403 • Atd Number: ATD-4-6017 • Bblid: 789500
Atdid
14403
Atd Number
ATD-4-6017
Bblid
789500
Inspectionid
376832
Inspect Date
2024-05-06T00:00:00.000
Atdissuedate
2024-05-06T14:45:28.000
Cb
9
House Num
85-11
Onstname
124TH ST.
Atddismissed
No
10944
Atdid: 10944 • Atd Number: ATD-2-948 • Bblid: 223578
Atdid
10944
Atd Number
ATD-2-948
Bblid
223578
Inspectionid
344173
Inspect Date
2022-09-19T00:00:00.000
Atdissuedate
2022-09-20T09:50:51.000
Cb
12
House Num
4008
Onstname
BRUNER AVE.
Atddismissed
No
13786
Atdid: 13786 • Atd Number: ATD-3-5679 • Bblid: 460189
Atdid
13786
Atd Number
ATD-3-5679
Bblid
460189
Inspectionid
369852
Inspect Date
2023-12-15T00:00:00.000
Atdissuedate
2023-12-19T12:08:07.000
Cb
11
House Num
1864
Onstname
77TH ST.
Atddismissed
No
9564
Atdid: 9564 • Atd Number: ATD-3-3555 • Bblid: 310892
Atdid
9564
Atd Number
ATD-3-3555
Bblid
310892
Inspectionid
333652
Inspect Date
2021-08-24T00:00:00.000
Atdissuedate
2022-03-11T10:09:32.000
Cb
3
House Num
463A
Onstname
MACDONOUGH ST.
Atddismissed
No
16871
Atdid: 16871 • Atd Number: ATD-3-6616 • Bblid: 354663
Atdid
16871
Atd Number
ATD-3-6616
Bblid
354663
Inspectionid
390417
Inspect Date
2025-03-04T00:00:00.000
Atdissuedate
2025-03-06T12:00:34.000
Cb
4
House Num
21
Onstname
STANHOPE ST.
Atddismissed
No
13645
Atdid: 13645 • Atd Number: ATD-3-5625 • Bblid: 333510
Atdid
13645
Atd Number
ATD-3-5625
Bblid
333510
Inspectionid
366143
Inspect Date
2023-10-25T00:00:00.000
Atdissuedate
2023-10-31T15:15:42.000
Cb
1
House Num
111
Onstname
LYNCH ST.
Atddismissed
No
16870
Atdid: 16870 • Atd Number: ATD-3-6615 • Bblid: 354661
Atdid
16870
Atd Number
ATD-3-6615
Bblid
354661
Inspectionid
390416
Inspect Date
2025-03-04T00:00:00.000
Atdissuedate
2025-03-06T11:59:54.000
Cb
4
House Num
23
Onstname
STANHOPE ST.
Atddismissed
No
12910
Atdid: 12910 • Atd Number: ATD-3-5197 • Bblid: 432101
Atdid
12910
Atd Number
ATD-3-5197
Bblid
432101
Inspectionid
360328
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T09:55:40.000
Cb
12
House Num
1432
Onstname
44TH ST.
Atddismissed
No
16827
Atdid: 16827 • Atd Number: ATD-4-6613 • Bblid: 735406
Atdid
16827
Atd Number
ATD-4-6613
Bblid
735406
Inspectionid
389912
Inspect Date
2025-01-29T00:00:00.000
Atdissuedate
2025-02-21T08:41:22.000
Cb
8
House Num
72-11
Onstname
139TH ST.
Atddismissed
No
11566
Atdid: 11566 • Atd Number: ATD-4-4935 • Bblid: 759888
Atdid
11566
Atd Number
ATD-4-4935
Bblid
759888
Inspectionid
349920
Inspect Date
2022-12-29T00:00:00.000
Atdissuedate
2023-01-03T11:01:04.000
Cb
13
House Num
83-41
Onstname
240TH ST.
Atddismissed
No
12344
Atdid: 12344 • Atd Number: ATD-4-5210 • Bblid: 602831
Atdid
12344
Atd Number
ATD-4-5210
Bblid
602831
Inspectionid
357468
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T11:43:16.000
Cb
2
House Num
43-41
Onstname
52ND ST.
Atddismissed
No
14784
Atdid: 14784 • Atd Number: ATD-3-6136 • Bblid: 307383
Atdid
14784
Atd Number
ATD-3-6136
Bblid
307383
Violationid
294295
Inspectionid
358078
Inspect Date
2024-07-24T09:39:29.000
Atdissuedate
2024-07-24T09:39:29.000
Cb
3
House Num
302
Onstname
VAN BUREN STREET
Atddismissed
No
18209
Atdid: 18209 • Atd Number: ATD-2-1434 • Bblid: 223831
Atdid
18209
Atd Number
ATD-2-1434
Bblid
223831
Inspectionid
403319
Inspect Date
2025-07-22T00:00:00.000
Atdissuedate
2025-07-29T09:59:56.000
Cb
12
House Num
4049
Onstname
EDSON AVE.
Atddismissed
No
16536
Atdid: 16536 • Atd Number: ATD-3-6474 • Bblid: 355796
Atdid
16536
Atd Number
ATD-3-6474
Bblid
355796
Inspectionid
386448
Inspect Date
2024-12-04T00:00:00.000
Atdissuedate
2024-12-18T07:52:16.000
Cb
4
House Num
1065
Onstname
GREENE AVE.
Atddismissed
No
14345
Atdid: 14345 • Atd Number: ATD-4-5992 • Bblid: 643789
Atdid
14345
Atd Number
ATD-4-5992
Bblid
643789
Inspectionid
376029
Inspect Date
2024-04-24T00:00:00.000
Atdissuedate
2024-04-24T10:10:37.000
Cb
5
House Num
60-55
Onstname
69TH LN.
Atddismissed
No
18640
Atdid: 18640 • Atd Number: ATD-3-7348 • Bblid: 332183
Atdid
18640
Atd Number
ATD-3-7348
Bblid
332183
Inspectionid
406243
Inspect Date
2025-09-17T00:00:00.000
Atdissuedate
2025-09-22T09:21:03.000
Cb
1
House Num
128
Onstname
HOOPER ST.
Atddismissed
No
13975
Atdid: 13975 • Atd Number: ATD-4-5806 • Bblid: 919734
Atdid
13975
Atd Number
ATD-4-5806
Bblid
919734
Inspectionid
371858
Inspect Date
2024-02-16T00:00:00.000
Atdissuedate
2024-02-16T12:01:51.000
Cb
14
House Num
464
Onstname
BEACH 145TH ST.
Atddismissed
No
10684
Atdid: 10684 • Atd Number: ATD-2-943 • Bblid: 229012
Atdid
10684
Atd Number
ATD-2-943
Bblid
229012
Inspectionid
342008
Inspect Date
2022-04-09T00:00:00.000
Atdissuedate
2022-08-25T11:35:38.000
Cb
12
House Num
4524
Onstname
MURDOCK AVE.
Atddismissed
No
13694
Atdid: 13694 • Atd Number: ATD-3-5649 • Bblid: 360945
Atdid
13694
Atd Number
ATD-3-5649
Bblid
360945
Inspectionid
367641
Inspect Date
2023-11-16T00:00:00.000
Atdissuedate
2023-11-16T12:12:39.000
Cb
4
House Num
42
Onstname
ELDERT ST.
Atddismissed
No
12984
Atdid: 12984 • Atd Number: ATD-3-5248 • Bblid: 422379
Atdid
12984
Atd Number
ATD-3-5248
Bblid
422379
Inspectionid
360711
Inspect Date
2023-07-27T00:00:00.000
Atdissuedate
2023-07-27T10:48:58.000
Cb
12
House Num
1517
Onstname
44TH ST.
Atddismissed
No
10358
Atdid: 10358 • Atd Number: ATD-3-3871 • Bblid: 314195
Atdid
10358
Atd Number
ATD-3-3871
Bblid
314195
Inspectionid
338510
Inspect Date
2022-06-22T00:00:00.000
Atdissuedate
2022-07-05T11:19:05.000
Cb
3
House Num
229
Onstname
HART ST.
Atddismissed
No
14875
Atdid: 14875 • Atd Number: ATD-4-6208 • Bblid: 802190
Atdid
14875
Atd Number
ATD-4-6208
Bblid
802190
Inspectionid
380236
Inspect Date
2023-10-06T00:00:00.000
Atdissuedate
2024-08-05T15:09:05.000
Cb
10
House Num
107-08
Onstname
122ND ST.
Atddismissed
No
13075
Atdid: 13075 • Atd Number: ATD-3-5306 • Bblid: 541325
Atdid
13075
Atd Number
ATD-3-5306
Bblid
541325
Inspectionid
361170
Inspect Date
2023-07-22T00:00:00.000
Atdissuedate
2023-08-01T10:24:29.000
Cb
18
House Num
9014
Onstname
AVENUE K.
Atddismissed
No
9322
Atdid: 9322 • Atd Number: ATD-3-3425 • Bblid: 441580
Atdid
9322
Atd Number
ATD-3-3425
Bblid
441580
Inspectionid
333032
Inspect Date
2019-05-22T00:00:00.000
Atdissuedate
2022-03-02T09:31:45.000
Cb
10
House Num
325
Onstname
SENATOR ST.
Atddismissed
No
16474
Atdid: 16474 • Atd Number: ATD-4-6487 • Bblid: 579952
Atdid
16474
Atd Number
ATD-4-6487
Bblid
579952
Inspectionid
385702
Inspect Date
2024-11-27T00:00:00.000
Atdissuedate
2024-12-02T14:37:26.000
Cb
1
House Num
32-87
Onstname
37TH ST.
Atddismissed
No
16139
Atdid: 16139 • Atd Number: ATD-3-6307 • Bblid: 366108
Atdid
16139
Atd Number
ATD-3-6307
Bblid
366108
Inspectionid
383380
Inspect Date
2024-09-25T00:00:00.000
Atdissuedate
2024-09-30T10:14:46.000
Cb
16
House Num
464
Onstname
BRISTOL ST.
Atddismissed
No
18110
Atdid: 18110 • Atd Number: ATD-4-7160 • Bblid: 828689
Atdid
18110
Atd Number
ATD-4-7160
Bblid
828689
Inspectionid
402551
Inspect Date
2025-07-17T00:00:00.000
Atdissuedate
2025-07-17T11:58:55.000
Cb
13
House Num
88-29
Onstname
212TH ST.
Atddismissed
No
14240
Atdid: 14240 • Atd Number: ATD-4-5934 • Bblid: 591077
Atdid
14240
Atd Number
ATD-4-5934
Bblid
591077
Inspectionid
374766
Inspect Date
2024-03-14T00:00:00.000
Atdissuedate
2024-04-04T11:46:33.000
Cb
1
House Num
25-61
Onstname
14TH ST.
Atddismissed
No
18490
Atdid: 18490 • Atd Number: ATD-4-7327 • Bblid: 620523
Atdid
18490
Atd Number
ATD-4-7327
Bblid
620523
Inspectionid
405238
Inspect Date
2025-01-31T00:00:00.000
Atdissuedate
2025-09-04T16:34:15.000
Cb
4
House Num
87-38
Onstname
52ND AVE.
Atddismissed
No
12900
Atdid: 12900 • Atd Number: ATD-4-5454 • Bblid: 695736
Atdid
12900
Atd Number
ATD-4-5454
Bblid
695736
Inspectionid
360295
Inspect Date
2023-02-14T00:00:00.000
Atdissuedate
2023-07-19T16:13:08.000
Cb
7
House Num
154-43
Onstname
26TH AVE.
Atddismissed
No
11921
Atdid: 11921 • Atd Number: ATD-3-4872 • Bblid: 286530
Atdid
11921
Atd Number
ATD-3-4872
Bblid
286530
Inspectionid
354168
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-29T12:10:25.000
Cb
8
House Num
221
Onstname
PROSPECT PL.
Atddismissed
No
16804
Atdid: 16804 • Atd Number: ATD-3-6593 • Bblid: 340226
Atdid
16804
Atd Number
ATD-3-6593
Bblid
340226
Inspectionid
389624
Inspect Date
2025-02-07T00:00:00.000
Atdissuedate
2025-02-10T11:15:40.000
Cb
1
House Num
158
Onstname
EAGLE ST.
Atddismissed
No
14221
Atdid: 14221 • Atd Number: ATD-2-1265 • Bblid: 168025
Atdid
14221
Atd Number
ATD-2-1265
Bblid
168025
Inspectionid
374185
Inspect Date
2024-03-14T00:00:00.000
Atdissuedate
2024-03-26T10:05:46.000
Cb
7
House Num
3053
Onstname
PERRY AVE.
Atddismissed
No
8959
Atdid: 8959 • Atd Number: ATD-4-4058 • Bblid: 896721
Atdid
8959
Atd Number
ATD-4-4058
Bblid
896721
Inspectionid
332260
Inspect Date
2019-07-05T00:00:00.000
Atdissuedate
2022-02-04T13:06:06.000
Cb
13
House Num
256-12
Onstname
147TH AVE.
Atddismissed
No