Ask NYC Browse All Data Public Safety Transportation Health Buildings

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
16907
Atdid: 16907 • Atd Number: ATD-5-930 • Bblid: 995209
Atdid
16907
Atd Number
ATD-5-930
Bblid
995209
Inspectionid
390923
Inspect Date
2025-03-07T00:00:00.000
Atdissuedate
2025-03-11T15:30:08.000
Cb
2
House Num
224
Onstname
MIDLAND AVE.
Atddismissed
No
18213
Atdid: 18213 • Atd Number: ATD-3-7183 • Bblid: 540969
Atdid
18213
Atd Number
ATD-3-7183
Bblid
540969
Inspectionid
403373
Inspect Date
2025-07-23T00:00:00.000
Atdissuedate
2025-07-29T13:12:53.000
Cb
18
House Num
1045
Onstname
E. 102ND ST.
Atddismissed
No
14420
Atdid: 14420 • Atd Number: ATD-3-5954 • Bblid: 277739
Atdid
14420
Atd Number
ATD-3-5954
Bblid
277739
Inspectionid
377042
Inspect Date
2024-04-11T00:00:00.000
Atdissuedate
2024-05-08T12:47:21.000
Cb
6
House Num
365
Onstname
5TH ST.
Atddismissed
No
9517
Atdid: 9517 • Atd Number: ATD-4-4275 • Bblid: 757189
Atdid
9517
Atd Number
ATD-4-4275
Bblid
757189
Inspectionid
333542
Inspect Date
2021-06-05T00:00:00.000
Atdissuedate
2022-03-09T16:12:56.000
Cb
11
House Num
61-16
Onstname
228TH ST.
Atddismissed
No
10123
Atdid: 10123 • Atd Number: ATD-3-3737 • Bblid: 562349
Atdid
10123
Atd Number
ATD-3-3737
Bblid
562349
Inspectionid
336773
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-23T10:40:38.000
Cb
15
House Num
2723
Onstname
FORD ST.
Atddismissed
No
16951
Atdid: 16951 • Atd Number: ATD-4-6657 • Bblid: 884029
Atdid
16951
Atd Number
ATD-4-6657
Bblid
884029
Inspectionid
391507
Inspect Date
2025-03-15T00:00:00.000
Atdissuedate
2025-03-17T14:04:01.000
Cb
13
House Num
131-67
Onstname
233RD ST.
Atddismissed
No
17047
Atdid: 17047 • Atd Number: ATD-3-6706 • Bblid: 265622
Atdid
17047
Atd Number
ATD-3-6706
Bblid
265622
Inspectionid
392375
Inspect Date
2022-06-02T00:00:00.000
Atdissuedate
2025-03-26T15:12:52.000
Cb
7
House Num
454
Onstname
45TH ST.
Atddismissed
No
14826
Atdid: 14826 • Atd Number: ATD-3-6161 • Bblid: 507300
Atdid
14826
Atd Number
ATD-3-6161
Bblid
507300
Inspectionid
380005
Inspect Date
2024-07-30T00:00:00.000
Atdissuedate
2024-07-31T11:24:17.000
Cb
15
House Num
1717
Onstname
AVENUE W.
Atddismissed
No
16226
Atdid: 16226 • Atd Number: ATD-4-6374 • Bblid: 804729
Atdid
16226
Atd Number
ATD-4-6374
Bblid
804729
Inspectionid
384138
Inspect Date
2023-02-01T00:00:00.000
Atdissuedate
2024-10-15T11:51:21.000
Cb
8
House Num
148-32
Onstname
87TH RD.
Atddismissed
No
11144
Atdid: 11144 • Atd Number: ATD-3-4475 • Bblid: 378458
Atdid
11144
Atd Number
ATD-3-4475
Bblid
378458
Inspectionid
345793
Inspect Date
2022-10-07T00:00:00.000
Atdissuedate
2022-10-13T13:51:26.000
Cb
5
House Num
625
Onstname
ELTON ST.
Atddismissed
Yes
Atddismissedon
2023-01-04T15:01:14.000
9609
Atdid: 9609 • Atd Number: ATD-4-4316 • Bblid: 763846
Atdid
9609
Atd Number
ATD-4-4316
Bblid
763846
Inspectionid
333749
Inspect Date
2020-10-19T00:00:00.000
Atdissuedate
2022-03-14T19:14:37.000
Cb
11
House Num
43-22
Onstname
MARATHON PKWY.
Atddismissed
No
12949
Atdid: 12949 • Atd Number: ATD-3-5226 • Bblid: 414153
Atdid
12949
Atd Number
ATD-3-5226
Bblid
414153
Inspectionid
360478
Inspect Date
2023-07-22T00:00:00.000
Atdissuedate
2023-07-22T12:40:42.000
Cb
14
House Num
529
Onstname
E. 29TH ST.
Atddismissed
No
17425
Atdid: 17425 • Atd Number: ATD-4-6799 • Bblid: 861891
Atdid
17425
Atd Number
ATD-4-6799
Bblid
861891
Inspectionid
395237
Inspect Date
2025-04-16T00:00:00.000
Atdissuedate
2025-04-24T13:22:21.000
Cb
12
House Num
114-45
Onstname
148TH ST.
Atddismissed
No
17399
Atdid: 17399 • Atd Number: ATD-4-6785 • Bblid: 657983
Atdid
17399
Atd Number
ATD-4-6785
Bblid
657983
Inspectionid
394954
Inspect Date
2025-04-15T00:00:00.000
Atdissuedate
2025-04-21T08:33:11.000
Cb
6
House Num
96-06
Onstname
68TH AVE.
Atddismissed
No
17444
Atdid: 17444 • Atd Number: ATD-4-6804 • Bblid: 836399
Atdid
17444
Atd Number
ATD-4-6804
Bblid
836399
Inspectionid
395370
Inspect Date
2025-04-07T00:00:00.000
Atdissuedate
2025-04-25T09:57:30.000
Cb
12
House Num
113-13
Onstname
205TH ST.
Atddismissed
No
14232
Atdid: 14232 • Atd Number: ATD-4-5930 • Bblid: 787892
Atdid
14232
Atd Number
ATD-4-5930
Bblid
787892
Inspectionid
374596
Inspect Date
2024-03-13T00:00:00.000
Atdissuedate
2024-04-03T12:14:41.000
Cb
9
House Num
102-31
Onstname
85TH RD.
Atddismissed
No
14841
Atdid: 14841 • Atd Number: ATD-5-872 • Bblid: 1028741
Atdid
14841
Atd Number
ATD-5-872
Bblid
1028741
Violationid
295659
Reinspectionid
37108
Inspect Date
2024-08-01T12:48:36.000
Atdissuedate
2024-08-01T12:48:36.000
Cb
3
House Num
66
Onstname
GOLD AVENUE
Atddismissed
Yes
Atddismissedon
2024-08-01T12:50:07.000
18077
Atdid: 18077 • Atd Number: ATD-3-7126 • Bblid: 529806
Atdid
18077
Atd Number
ATD-3-7126
Bblid
529806
Inspectionid
402310
Inspect Date
2025-06-04T00:00:00.000
Atdissuedate
2025-07-14T13:39:22.000
Cb
17
House Num
360
Onstname
E. 58TH ST.
Atddismissed
No
17519
Atdid: 17519 • Atd Number: ATD-3-6948 • Bblid: 292084
Atdid
17519
Atd Number
ATD-3-6948
Bblid
292084
Inspectionid
396041
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-05T08:22:48.000
Cb
8
House Num
569
Onstname
EASTERN PKWY.
Atddismissed
No
16429
Atdid: 16429 • Atd Number: ATD-1-331 • Bblid: 103679
Atdid
16429
Atd Number
ATD-1-331
Bblid
103679
Inspectionid
385341
Inspect Date
2024-11-20T00:00:00.000
Atdissuedate
2024-11-25T08:47:08.000
Cb
8
House Num
21
Onstname
E. 94TH ST.
Atddismissed
No
16488
Atdid: 16488 • Atd Number: ATD-3-6443 • Bblid: 260501
Atdid
16488
Atd Number
ATD-3-6443
Bblid
260501
Inspectionid
385794
Inspect Date
2024-10-03T00:00:00.000
Atdissuedate
2024-12-06T13:20:16.000
Cb
6
House Num
288
Onstname
CARROLL ST.
Atddismissed
No
11297
Atdid: 11297 • Atd Number: ATD-3-4586 • Bblid: 386192
Atdid
11297
Atd Number
ATD-3-4586
Bblid
386192
Inspectionid
347255
Inspect Date
2022-10-21T00:00:00.000
Atdissuedate
2022-10-31T14:34:06.000
Cb
5
House Num
746
Onstname
ALABAMA AVE.
Atddismissed
No
18208
Atdid: 18208 • Atd Number: ATD-2-1433 • Bblid: 223833
Atdid
18208
Atd Number
ATD-2-1433
Bblid
223833
Inspectionid
403318
Inspect Date
2025-07-22T00:00:00.000
Atdissuedate
2025-07-29T09:59:22.000
Cb
12
House Num
4047
Onstname
EDSON AVE.
Atddismissed
No
18086
Atdid: 18086 • Atd Number: ATD-3-7130 • Bblid: 517231
Atdid
18086
Atd Number
ATD-3-7130
Bblid
517231
Inspectionid
402347
Inspect Date
2025-07-11T00:00:00.000
Atdissuedate
2025-07-14T14:34:20.000
Cb
14
House Num
1244
Onstname
E. 27TH ST.
Atddismissed
No
16855
Atdid: 16855 • Atd Number: ATD-4-6624 • Bblid: 657597
Atdid
16855
Atd Number
ATD-4-6624
Bblid
657597
Inspectionid
390319
Inspect Date
2025-02-21T00:00:00.000
Atdissuedate
2025-03-05T12:46:57.000
Cb
6
House Num
93-01
Onstname
69TH AVE.
Atddismissed
No
8884
Atdid: 8884 • Atd Number: ATD-4-4023 • Bblid: 587110
Atdid
8884
Atd Number
ATD-4-4023
Bblid
587110
Inspectionid
331955
Inspect Date
2021-12-14T00:00:00.000
Atdissuedate
2022-01-26T10:57:23.000
Cb
1
House Num
20-20
Onstname
35TH ST.
Atddismissed
No
13347
Atdid: 13347 • Atd Number: ATD-4-5521 • Bblid: 838784
Atdid
13347
Atd Number
ATD-4-5521
Bblid
838784
Inspectionid
362864
Inspect Date
2023-08-10T00:00:00.000
Atdissuedate
2023-08-29T13:09:58.000
Cb
12
House Num
116-11
Onstname
194TH ST.
Atddismissed
No
13785
Atdid: 13785 • Atd Number: ATD-4-5686 • Bblid: 733952
Atdid
13785
Atd Number
ATD-4-5686
Bblid
733952
Inspectionid
369825
Inspect Date
2023-12-19T00:00:00.000
Atdissuedate
2023-12-19T07:35:08.000
Cb
7
House Num
136-08
Onstname
64TH RD.
Atddismissed
No
13583
Atdid: 13583 • Atd Number: ATD-3-5593 • Bblid: 359491
Atdid
13583
Atd Number
ATD-3-5593
Bblid
359491
Inspectionid
365363
Inspect Date
2023-10-11T00:00:00.000
Atdissuedate
2023-10-16T10:33:42.000
Cb
4
House Num
1195
Onstname
JEFFERSON AVE.
Atddismissed
No
14538
Atdid: 14538 • Atd Number: ATD-3-6001 • Bblid: 459448
Atdid
14538
Atd Number
ATD-3-6001
Bblid
459448
Inspectionid
377880
Inspect Date
2024-05-17T00:00:00.000
Atdissuedate
2024-05-28T13:54:42.000
Cb
11
House Num
1766
Onstname
76TH ST.
Atddismissed
No
10914
Atdid: 10914 • Atd Number: ATD-3-4285 • Bblid: 354462
Atdid
10914
Atd Number
ATD-3-4285
Bblid
354462
Inspectionid
343734
Inspect Date
2022-09-09T00:00:00.000
Atdissuedate
2022-09-13T09:35:21.000
Cb
4
House Num
419
Onstname
STOCKHOLM ST.
Atddismissed
No
14038
Atdid: 14038 • Atd Number: ATD-3-5751 • Bblid: 257667
Atdid
14038
Atd Number
ATD-3-5751
Bblid
257667
Inspectionid
372446
Inspect Date
2024-02-26T00:00:00.000
Atdissuedate
2024-02-29T10:29:35.000
Cb
6
House Num
71
Onstname
4TH PL.
Atddismissed
No
12137
Atdid: 12137 • Atd Number: ATD-4-5167 • Bblid: 628416
Atdid
12137
Atd Number
ATD-4-5167
Bblid
628416
Inspectionid
356548
Inspect Date
2023-05-02T00:00:00.000
Atdissuedate
2023-05-02T12:32:53.000
Cb
6
House Num
102-22
Onstname
65TH RD.
Atddismissed
No
11298
Atdid: 11298 • Atd Number: ATD-3-4587 • Bblid: 453390
Atdid
11298
Atd Number
ATD-3-4587
Bblid
453390
Inspectionid
347280
Inspect Date
2022-10-31T00:00:00.000
Atdissuedate
2022-11-01T09:46:06.000
Cb
10
House Num
214
Onstname
94TH ST.
Atddismissed
No
14168
Atdid: 14168 • Atd Number: ATD-3-5830 • Bblid: 533552
Atdid
14168
Atd Number
ATD-3-5830
Bblid
533552
Inspectionid
373558
Inspect Date
2024-03-13T00:00:00.000
Atdissuedate
2024-03-19T10:25:51.000
Cb
18
House Num
926
Onstname
E. 83RD ST.
Atddismissed
No
13951
Atdid: 13951 • Atd Number: ATD-3-5734 • Bblid: 378406
Atdid
13951
Atd Number
ATD-3-5734
Bblid
378406
Inspectionid
371590
Inspect Date
2024-02-07T00:00:00.000
Atdissuedate
2024-02-14T11:10:44.000
Cb
5
House Num
624
Onstname
ELTON ST.
Atddismissed
No
18421
Atdid: 18421 • Atd Number: ATD-4-7291 • Bblid: 787857
Atdid
18421
Atd Number
ATD-4-7291
Bblid
787857
Inspectionid
404735
Inspect Date
2025-04-14T00:00:00.000
Atdissuedate
2025-08-25T11:42:54.000
Cb
9
House Num
108-03
Onstname
85TH AVE.
Atddismissed
No
13562
Atdid: 13562 • Atd Number: ATD-3-5578 • Bblid: 418533
Atdid
13562
Atd Number
ATD-3-5578
Bblid
418533
Inspectionid
365122
Inspect Date
2023-10-06T00:00:00.000
Atdissuedate
2023-10-10T16:10:45.000
Cb
12
House Num
1419
Onstname
40TH ST.
Atddismissed
No
17957
Atdid: 17957 • Atd Number: ATD-3-7072 • Bblid: 405935
Atdid
17957
Atd Number
ATD-3-7072
Bblid
405935
Inspectionid
400773
Inspect Date
2025-06-12T00:00:00.000
Atdissuedate
2025-06-23T11:48:01.000
Cb
17
House Num
555
Onstname
E. 32ND ST.
Atddismissed
No
10297
Atdid: 10297 • Atd Number: ATD-4-4663 • Bblid: 616534
Atdid
10297
Atd Number
ATD-4-4663
Bblid
616534
Inspectionid
337745
Inspect Date
2022-06-16T00:00:00.000
Atdissuedate
2022-06-16T14:24:01.000
Cb
3
House Num
33-46
Onstname
96TH ST.
Atddismissed
No
8979
Atdid: 8979 • Atd Number: ATD-3-3278 • Bblid: 325269
Atdid
8979
Atd Number
ATD-3-3278
Bblid
325269
Inspectionid
332291
Inspect Date
2019-07-27T00:00:00.000
Atdissuedate
2022-02-07T15:30:24.000
Cb
2
House Num
25
Onstname
IRVING PL.
Atddismissed
No
11888
Atdid: 11888 • Atd Number: ATD-2-993 • Bblid: 223044
Atdid
11888
Atd Number
ATD-2-993
Bblid
223044
Inspectionid
353874
Inspect Date
2023-03-23T00:00:00.000
Atdissuedate
2023-03-27T10:23:15.000
Cb
12
House Num
3925
Onstname
PRATT AVE.
Atddismissed
No
13699
Atdid: 13699 • Atd Number: ATD-4-5639 • Bblid: 689846
Atdid
13699
Atd Number
ATD-4-5639
Bblid
689846
Inspectionid
367708
Inspect Date
2023-11-18T00:00:00.000
Atdissuedate
2023-11-18T08:54:43.000
Cb
7
House Num
162-23
Onstname
12TH AVE.
Atddismissed
No
14025
Atdid: 14025 • Atd Number: ATD-4-5847 • Bblid: 900794
Atdid
14025
Atd Number
ATD-4-5847
Bblid
900794
Inspectionid
372332
Inspect Date
2024-02-27T00:00:00.000
Atdissuedate
2024-02-27T12:05:46.000
Cb
10
House Num
162-08
Onstname
84TH ST.
Atddismissed
No
11278
Atdid: 11278 • Atd Number: ATD-4-4860 • Bblid: 617679
Atdid
11278
Atd Number
ATD-4-4860
Bblid
617679
Inspectionid
347049
Inspect Date
2022-10-20T00:00:00.000
Atdissuedate
2022-10-26T15:20:49.000
Cb
3
House Num
101-11
Onstname
34TH AVE.
Atddismissed
No
13558
Atdid: 13558 • Atd Number: ATD-3-5575 • Bblid: 359749
Atdid
13558
Atd Number
ATD-3-5575
Bblid
359749
Inspectionid
365078
Inspect Date
2023-10-06T00:00:00.000
Atdissuedate
2023-10-10T12:01:55.000
Cb
4
House Num
316
Onstname
CORNELIA ST.
Atddismissed
No
18359
Atdid: 18359 • Atd Number: ATD-4-7262 • Bblid: 572757
Atdid
18359
Atd Number
ATD-4-7262
Bblid
572757
Inspectionid
404429
Inspect Date
2024-08-28T00:00:00.000
Atdissuedate
2025-08-18T13:44:22.000
Cb
1
House Num
36-34
Onstname
CRESCENT ST.
Atddismissed
No
18366
Atdid: 18366 • Atd Number: ATD-5-1022 • Bblid: 1014280
Atdid
18366
Atd Number
ATD-5-1022
Bblid
1014280
Inspectionid
404451
Inspect Date
2025-08-12T00:00:00.000
Atdissuedate
2025-08-18T14:19:29.000
Cb
3
House Num
76
Onstname
GREENCROFT AVE.
Atddismissed
No
13255
Atdid: 13255 • Atd Number: ATD-3-5426 • Bblid: 422865
Atdid
13255
Atd Number
ATD-3-5426
Bblid
422865
Inspectionid
362075
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T16:58:21.000
Cb
12
House Num
1662
Onstname
47TH ST.
Atddismissed
No
17451
Atdid: 17451 • Atd Number: ATD-3-6925 • Bblid: 378311
Atdid
17451
Atd Number
ATD-3-6925
Bblid
378311
Inspectionid
395411
Inspect Date
2025-03-31T00:00:00.000
Atdissuedate
2025-04-25T22:35:36.000
Cb
5
House Num
560
Onstname
SCHENCK AVE.
Atddismissed
No
NYC Data AI • Public-data exploration interface