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
12380
Atdid: 12380 • Atd Number: ATD-4-5246 • Bblid: 634501
Atdid
12380
Atd Number
ATD-4-5246
Bblid
634501
Inspectionid
357537
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:41:59.000
Cb
2
House Num
72-12
Onstname
QUEENS BLVD.
Atddismissed
No
17675
Atdid: 17675 • Atd Number: ATD-4-6931 • Bblid: 647995
Atdid
17675
Atd Number
ATD-4-6931
Bblid
647995
Inspectionid
397669
Inspect Date
2025-04-02T00:00:00.000
Atdissuedate
2025-05-19T14:36:18.000
Cb
5
House Num
62-08
Onstname
69TH PL.
Atddismissed
No
10646
Atdid: 10646 • Atd Number: ATD-3-4048 • Bblid: 554855
Atdid
10646
Atd Number
ATD-3-4048
Bblid
554855
Inspectionid
341452
Inspect Date
2022-08-13T00:00:00.000
Atdissuedate
2022-08-13T14:15:50.000
Cb
18
House Num
2771
Onstname
E. 65TH ST.
Atddismissed
No
11501
Atdid: 11501 • Atd Number: ATD-3-4699 • Bblid: 278159
Atdid
11501
Atd Number
ATD-3-4699
Bblid
278159
Inspectionid
349238
Inspect Date
2022-12-01T00:00:00.000
Atdissuedate
2022-12-12T14:39:11.000
Cb
6
House Num
390A
Onstname
6TH AVE.
Atddismissed
Yes
Atddismissedon
2025-03-17T11:08:50.000
16897
Atdid: 16897 • Atd Number: ATD-4-6640 • Bblid: 741447
Atdid
16897
Atd Number
ATD-4-6640
Bblid
741447
Inspectionid
390833
Inspect Date
2025-03-04T00:00:00.000
Atdissuedate
2025-03-10T13:50:17.000
Cb
8
House Num
162-37
Onstname
76TH RD.
Atddismissed
No
18048
Atdid: 18048 • Atd Number: ATD-3-7108 • Bblid: 561341
Atdid
18048
Atd Number
ATD-3-7108
Bblid
561341
Inspectionid
402062
Inspect Date
2025-07-09T00:00:00.000
Atdissuedate
2025-07-10T12:22:49.000
Cb
15
House Num
4709
Onstname
BEDFORD AVE.
Atddismissed
No
9314
Atdid: 9314 • Atd Number: ATD-3-3418 • Bblid: 440649
Atdid
9314
Atd Number
ATD-3-3418
Bblid
440649
Inspectionid
333020
Inspect Date
2019-07-22T00:00:00.000
Atdissuedate
2022-03-02T08:55:23.000
Cb
7
House Num
531
Onstname
62ND ST.
Atddismissed
No
16816
Atdid: 16816 • Atd Number: ATD-3-6601 • Bblid: 532131
Atdid
16816
Atd Number
ATD-3-6601
Bblid
532131
Inspectionid
389759
Inspect Date
2025-02-08T00:00:00.000
Atdissuedate
2025-02-11T11:41:35.000
Cb
18
House Num
660
Onstname
E. 80TH ST.
Atddismissed
No
12852
Atdid: 12852 • Atd Number: ATD-3-5157 • Bblid: 553818
Atdid
12852
Atd Number
ATD-3-5157
Bblid
553818
Inspectionid
359979
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-07-13T16:06:53.000
Cb
18
House Num
3708
Onstname
AVENUE T.
Atddismissed
No
12744
Atdid: 12744 • Atd Number: ATD-4-5407 • Bblid: 734290
Atdid
12744
Atd Number
ATD-4-5407
Bblid
734290
Inspectionid
359327
Inspect Date
2023-06-22T00:00:00.000
Atdissuedate
2023-07-03T12:35:26.000
Cb
8
House Num
144-41
Onstname
68TH AVE.
Atddismissed
No
14867
Atdid: 14867 • Atd Number: ATD-4-6200 • Bblid: 801974
Atdid
14867
Atd Number
ATD-4-6200
Bblid
801974
Inspectionid
380228
Inspect Date
2023-10-11T00:00:00.000
Atdissuedate
2024-08-05T14:54:39.000
Cb
10
House Num
107-32
Onstname
120TH ST.
Atddismissed
No
12655
Atdid: 12655 • Atd Number: ATD-2-1168 • Bblid: 153073
Atdid
12655
Atd Number
ATD-2-1168
Bblid
153073
Inspectionid
358981
Inspect Date
2023-06-14T00:00:00.000
Atdissuedate
2023-06-26T09:14:16.000
Cb
4
House Num
1517
Onstname
MORRIS AVE.
Atddismissed
No
16899
Atdid: 16899 • Atd Number: ATD-1-371 • Bblid: 75349
Atdid
16899
Atd Number
ATD-1-371
Bblid
75349
Inspectionid
390853
Inspect Date
2025-02-26T00:00:00.000
Atdissuedate
2025-03-11T08:48:29.000
Cb
7
House Num
118
Onstname
W. 87TH ST.
Atddismissed
No
11266
Atdid: 11266 • Atd Number: ATD-3-4572 • Bblid: 555283
Atdid
11266
Atd Number
ATD-3-4572
Bblid
555283
Inspectionid
346964
Inspect Date
2022-09-30T00:00:00.000
Atdissuedate
2022-10-25T11:17:27.000
Cb
18
House Num
315
Onstname
ARKANSAS DR.
Atddismissed
No
13024
Atdid: 13024 • Atd Number: ATD-3-5268 • Bblid: 509809
Atdid
13024
Atd Number
ATD-3-5268
Bblid
509809
Inspectionid
361016
Inspect Date
2023-07-11T00:00:00.000
Atdissuedate
2023-07-28T12:08:04.000
Cb
15
House Num
1712
Onstname
AVENUE X.
Atddismissed
No
12025
Atdid: 12025 • Atd Number: ATD-3-4920 • Bblid: 361279
Atdid
12025
Atd Number
ATD-3-4920
Bblid
361279
Inspectionid
355809
Inspect Date
2023-04-13T00:00:00.000
Atdissuedate
2023-04-13T13:43:10.000
Cb
4
House Num
199
Onstname
COVERT ST.
Atddismissed
No
14313
Atdid: 14313 • Atd Number: ATD-4-5974 • Bblid: 656444
Atdid
14313
Atd Number
ATD-4-5974
Bblid
656444
Inspectionid
375778
Inspect Date
2024-04-22T00:00:00.000
Atdissuedate
2024-04-22T12:04:15.000
Cb
6
House Num
69-26
Onstname
ALDERTON ST.
Atddismissed
No
14722
Atdid: 14722 • Atd Number: ATD-4-6140 • Bblid: 631868
Atdid
14722
Atd Number
ATD-4-6140
Bblid
631868
Inspectionid
379267
Inspect Date
2024-06-03T00:00:00.000
Atdissuedate
2024-07-11T12:34:38.000
Cb
2
House Num
51-19
Onstname
64TH ST.
Atddismissed
No
14007
Atdid: 14007 • Atd Number: ATD-3-5746 • Bblid: 367753
Atdid
14007
Atd Number
ATD-3-5746
Bblid
367753
Inspectionid
372154
Inspect Date
2023-12-14T00:00:00.000
Atdissuedate
2024-02-26T10:10:20.000
Cb
5
House Num
74
Onstname
WILLIAMS AVE.
Atddismissed
No
17744
Atdid: 17744 • Atd Number: ATD-4-6982 • Bblid: 761593
Atdid
17744
Atd Number
ATD-4-6982
Bblid
761593
Inspectionid
398683
Inspect Date
2023-10-02T00:00:00.000
Atdissuedate
2025-05-27T16:29:41.000
Cb
13
House Num
88-02
Onstname
240TH ST.
Atddismissed
No
11945
Atdid: 11945 • Atd Number: ATD-4-5086 • Bblid: 790956
Atdid
11945
Atd Number
ATD-4-5086
Bblid
790956
Inspectionid
354270
Inspect Date
2023-03-30T00:00:00.000
Atdissuedate
2023-03-30T13:59:35.000
Cb
9
House Num
87-15
Onstname
114TH ST.
Atddismissed
No
18591
Atdid: 18591 • Atd Number: ATD-3-7325 • Bblid: 502988
Atdid
18591
Atd Number
ATD-3-7325
Bblid
502988
Inspectionid
405707
Inspect Date
2025-07-08T00:00:00.000
Atdissuedate
2025-09-12T10:16:39.000
Cb
15
House Num
1972
Onstname
E. 19TH ST.
Atddismissed
No
18368
Atdid: 18368 • Atd Number: ATD-3-7245 • Bblid: 251430
Atdid
18368
Atd Number
ATD-3-7245
Bblid
251430
Inspectionid
404492
Inspect Date
2025-08-12T00:00:00.000
Atdissuedate
2025-08-19T09:35:37.000
Cb
2
House Num
182
Onstname
DEAN ST.
Atddismissed
No
9961
Atdid: 9961 • Atd Number: ATD-3-3648 • Bblid: 270588
Atdid
9961
Atd Number
ATD-3-3648
Bblid
270588
Inspectionid
335455
Inspect Date
2022-04-05T00:00:00.000
Atdissuedate
2022-04-25T08:33:57.000
Cb
7
House Num
460
Onstname
58TH ST.
Atddismissed
No
14344
Atdid: 14344 • Atd Number: ATD-3-5912 • Bblid: 460821
Atdid
14344
Atd Number
ATD-3-5912
Bblid
460821
Inspectionid
376000
Inspect Date
2024-04-19T00:00:00.000
Atdissuedate
2024-04-23T16:10:35.000
Cb
10
House Num
7817
Onstname
12TH AVE.
Atddismissed
No
12277
Atdid: 12277 • Atd Number: ATD-3-5036 • Bblid: 562748
Atdid
12277
Atd Number
ATD-3-5036
Bblid
562748
Inspectionid
357313
Inspect Date
2023-05-12T00:00:00.000
Atdissuedate
2023-05-18T13:28:02.000
Cb
15
House Num
2162
Onstname
STUART ST.
Atddismissed
No
9392
Atdid: 9392 • Atd Number: ATD-4-4211 • Bblid: 654832
Atdid
9392
Atd Number
ATD-4-4211
Bblid
654832
Inspectionid
333144
Inspect Date
2022-03-03T00:00:00.000
Atdissuedate
2022-03-03T15:14:36.000
Cb
6
House Num
63-34
Onstname
CROMWELL CRES
Atddismissed
No
18443
Atdid: 18443 • Atd Number: ATD-3-7278 • Bblid: 517805
Atdid
18443
Atd Number
ATD-3-7278
Bblid
517805
Inspectionid
404949
Inspect Date
2025-08-26T00:00:00.000
Atdissuedate
2025-08-27T15:30:47.000
Cb
14
House Num
1344
Onstname
E. 23RD ST.
Atddismissed
No
13272
Atdid: 13272 • Atd Number: ATD-4-5510 • Bblid: 845022
Atdid
13272
Atd Number
ATD-4-5510
Bblid
845022
Inspectionid
362201
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-18T13:55:33.000
Cb
13
House Num
116-21
Onstname
219TH ST.
Atddismissed
No
9433
Atdid: 9433 • Atd Number: ATD-4-4233 • Bblid: 654788
Atdid
9433
Atd Number
ATD-4-4233
Bblid
654788
Inspectionid
333265
Inspect Date
2022-03-04T00:00:00.000
Atdissuedate
2022-03-04T14:41:07.000
Cb
6
House Num
63-30
Onstname
DIETERLE CRES
Atddismissed
No
10570
Atdid: 10570 • Atd Number: ATD-4-4755 • Bblid: 770848
Atdid
10570
Atd Number
ATD-4-4755
Bblid
770848
Inspectionid
340571
Inspect Date
2022-07-15T00:00:00.000
Atdissuedate
2022-07-29T10:25:40.000
Cb
13
House Num
85-11
Onstname
250TH ST.
Atddismissed
No
10328
Atdid: 10328 • Atd Number: ATD-4-4681 • Bblid: 581995
Atdid
10328
Atd Number
ATD-4-4681
Bblid
581995
Inspectionid
338084
Inspect Date
2022-03-30T00:00:00.000
Atdissuedate
2022-06-25T19:09:08.000
Cb
1
House Num
30-73
Onstname
43RD ST.
Atddismissed
No
12519
Atdid: 12519 • Atd Number: ATD-3-5062 • Bblid: 444753
Atdid
12519
Atd Number
ATD-3-5062
Bblid
444753
Inspectionid
358200
Inspect Date
2023-06-01T00:00:00.000
Atdissuedate
2023-06-05T16:09:43.000
Cb
10
House Num
329
Onstname
73RD ST.
Atddismissed
No
2180
Atdid: 2180 • Atd Number: ATD-3-1323 • Bblid: 320848
Atdid
2180
Atd Number
ATD-3-1323
Bblid
320848
Violationid
162931
Atdissuedate
2020-08-10T00:00:00.000
Cb
2
House Num
101
Onstname
WAVERLY AVENUE
Atddismissed
Yes
Atddismissedon
2023-11-30T07:53:05.000
10633
Atdid: 10633 • Atd Number: ATD-3-4042 • Bblid: 554961
Atdid
10633
Atd Number
ATD-3-4042
Bblid
554961
Inspectionid
341266
Inspect Date
2022-08-09T00:00:00.000
Atdissuedate
2022-08-09T15:19:52.000
Cb
18
House Num
2728
Onstname
ARKANSAS DR.
Atddismissed
No
11495
Atdid: 11495 • Atd Number: ATD-3-4693 • Bblid: 356172
Atdid
11495
Atd Number
ATD-3-4693
Bblid
356172
Inspectionid
349193
Inspect Date
2022-12-09T00:00:00.000
Atdissuedate
2022-12-12T13:31:31.000
Cb
4
House Num
1368
Onstname
GREENE AVE.
Atddismissed
No
17579
Atdid: 17579 • Atd Number: ATD-3-6967 • Bblid: 287430
Atdid
17579
Atd Number
ATD-3-6967
Bblid
287430
Inspectionid
396786
Inspect Date
2025-05-06T00:00:00.000
Atdissuedate
2025-05-12T07:32:06.000
Cb
8
House Num
296
Onstname
PARK PL.
Atddismissed
No
16556
Atdid: 16556 • Atd Number: ATD-3-6492 • Bblid: 268172
Atdid
16556
Atd Number
ATD-3-6492
Bblid
268172
Inspectionid
386906
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2024-12-19T12:28:21.000
Cb
7
House Num
336
Onstname
52ND ST.
Atddismissed
Yes
Atddismissedon
2025-03-22T14:43:04.000
13081
Atdid: 13081 • Atd Number: ATD-3-5312 • Bblid: 509129
Atdid
13081
Atd Number
ATD-3-5312
Bblid
509129
Inspectionid
361196
Inspect Date
2023-07-26T00:00:00.000
Atdissuedate
2023-08-01T12:16:53.000
Cb
15
House Num
2368
Onstname
E. 24TH ST.
Atddismissed
No
13466
Atdid: 13466 • Atd Number: ATD-3-5542 • Bblid: 509427
Atdid
13466
Atd Number
ATD-3-5542
Bblid
509427
Inspectionid
364214
Inspect Date
2023-09-08T00:00:00.000
Atdissuedate
2023-09-25T13:42:38.000
Cb
15
House Num
2309
Onstname
E. 29TH ST.
Atddismissed
Yes
Atddismissedon
2024-02-27T18:50:48.000
10191
Atdid: 10191 • Atd Number: ATD-3-3783 • Bblid: 419599
Atdid
10191
Atd Number
ATD-3-3783
Bblid
419599
Inspectionid
337109
Inspect Date
2022-05-27T00:00:00.000
Atdissuedate
2022-05-31T13:53:39.000
Cb
12
House Num
1502
Onstname
37TH ST.
Atddismissed
Yes
Atddismissedon
2023-02-24T09:21:18.000
13436
Atdid: 13436 • Atd Number: ATD-5-828 • Bblid: 1026012
Atdid
13436
Atd Number
ATD-5-828
Bblid
1026012
Inspectionid
363918
Inspect Date
2023-09-19T00:00:00.000
Atdissuedate
2023-09-20T13:37:49.000
Cb
3
House Num
7
Onstname
MACON AVE.
Atddismissed
No
12796
Atdid: 12796 • Atd Number: ATD-3-5130 • Bblid: 503143
Atdid
12796
Atd Number
ATD-3-5130
Bblid
503143
Inspectionid
359625
Inspect Date
2023-07-08T00:00:00.000
Atdissuedate
2023-07-08T13:02:07.000
Cb
15
House Num
1970
Onstname
E. 22ND ST.
Atddismissed
No
12180
Atdid: 12180 • Atd Number: ATD-2-1034 • Bblid: 162394
Atdid
12180
Atd Number
ATD-2-1034
Bblid
162394
Inspectionid
356815
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2023-05-09T12:42:25.000
Cb
7
House Num
2605
Onstname
GRAND CONCOURSE
Atddismissed
No
1596
Atdid: 1596 • Atd Number: ATD-3-739 • Bblid: 477262
Atdid
1596
Atd Number
ATD-3-739
Bblid
477262
Violationid
80468
Atdissuedate
2020-02-14T00:00:00.000
Cb
11
House Num
1794
Onstname
WEST 8 STREET
Atddismissed
Yes
Atddismissedon
2022-05-24T10:28:04.000
11809
Atdid: 11809 • Atd Number: ATD-4-5054 • Bblid: 727575
Atdid
11809
Atd Number
ATD-4-5054
Bblid
727575
Inspectionid
353171
Inspect Date
2023-03-17T00:00:00.000
Atdissuedate
2023-03-17T13:36:17.000
Cb
11
House Num
34-12
Onstname
209TH ST.
Atddismissed
Yes
Atddismissedon
2023-03-17T13:36:36.000
14032
Atdid: 14032 • Atd Number: ATD-4-5853 • Bblid: 598105
Atdid
14032
Atd Number
ATD-4-5853
Bblid
598105
Inspectionid
372371
Inspect Date
2024-02-28T00:00:00.000
Atdissuedate
2024-02-28T10:26:11.000
Cb
3
House Num
32-45
Onstname
70TH ST.
Atddismissed
No
13982
Atdid: 13982 • Atd Number: ATD-4-5813 • Bblid: 583599
Atdid
13982
Atd Number
ATD-4-5813
Bblid
583599
Inspectionid
371935
Inspect Date
2024-01-26T00:00:00.000
Atdissuedate
2024-02-20T11:05:38.000
Cb
1
House Num
25-78
Onstname
47TH ST.
Atddismissed
No
9545
Atdid: 9545 • Atd Number: ATD-4-4289 • Bblid: 760713
Atdid
9545
Atd Number
ATD-4-4289
Bblid
760713
Inspectionid
333629
Inspect Date
2019-07-18T00:00:00.000
Atdissuedate
2022-03-10T15:38:51.000
Cb
13
House Num
233-70
Onstname
87TH AVE.
Atddismissed
No
11759
Atdid: 11759 • Atd Number: ATD-3-4784 • Bblid: 285546
Atdid
11759
Atd Number
ATD-3-4784
Bblid
285546
Inspectionid
352601
Inspect Date
2023-03-10T00:00:00.000
Atdissuedate
2023-03-10T11:21:40.000
Cb
8
House Num
938
Onstname
PACIFIC ST.
Atddismissed
No
NYC Data AI • Public-data exploration interface