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
17711
Atdid: 17711 • Atd Number: ATD-4-6962 • Bblid: 790183
Atdid
17711
Atd Number
ATD-4-6962
Bblid
790183
Inspectionid
398212
Inspect Date
2025-04-03T00:00:00.000
Atdissuedate
2025-05-22T11:42:28.000
Cb
9
House Num
86-35
Onstname
126TH ST.
Atddismissed
No
8669
Atdid: 8669 • Atd Number: ATD-4-3895 • Bblid: 719822
Atdid
8669
Atd Number
ATD-4-3895
Bblid
719822
Inspectionid
330838
Inspect Date
2021-12-12T00:00:00.000
Atdissuedate
2021-12-16T15:16:37.000
Cb
11
House Num
56-01
Onstname
187TH ST.
Atddismissed
No
11879
Atdid: 11879 • Atd Number: ATD-4-5068 • Bblid: 687194
Atdid
11879
Atd Number
ATD-4-5068
Bblid
687194
Inspectionid
353744
Inspect Date
2023-03-22T00:00:00.000
Atdissuedate
2023-03-23T17:45:00.000
Cb
7
House Num
147-51
Onstname
5TH AVE.
Atddismissed
No
9492
Atdid: 9492 • Atd Number: ATD-4-4256 • Bblid: 737855
Atdid
9492
Atd Number
ATD-4-4256
Bblid
737855
Inspectionid
333417
Inspect Date
2019-08-16T00:00:00.000
Atdissuedate
2022-03-08T15:30:35.000
Cb
8
House Num
150-17
Onstname
78TH RD.
Atddismissed
No
18534
Atdid: 18534 • Atd Number: ATD-4-7345 • Bblid: 719774
Atdid
18534
Atd Number
ATD-4-7345
Bblid
719774
Inspectionid
405462
Inspect Date
2025-09-05T00:00:00.000
Atdissuedate
2025-09-08T11:05:16.000
Cb
11
House Num
56-06
Onstname
187TH ST.
Atddismissed
No
18014
Atdid: 18014 • Atd Number: ATD-3-7098 • Bblid: 518995
Atdid
18014
Atd Number
ATD-3-7098
Bblid
518995
Inspectionid
401704
Inspect Date
2025-07-01T00:00:00.000
Atdissuedate
2025-07-01T12:17:42.000
Cb
15
House Num
1587
Onstname
E. 27TH ST.
Atddismissed
No
8585
Atdid: 8585 • Atd Number: ATD-5-577 • Bblid: 990073
Atdid
8585
Atd Number
ATD-5-577
Bblid
990073
Inspectionid
330525
Inspect Date
2019-07-27T00:00:00.000
Atdissuedate
2021-12-10T10:25:38.000
Cb
2
House Num
135
Onstname
DELAWARE AVE.
Atddismissed
No
10384
Atdid: 10384 • Atd Number: ATD-3-3897 • Bblid: 417668
Atdid
10384
Atd Number
ATD-3-3897
Bblid
417668
Inspectionid
338597
Inspect Date
2022-06-22T00:00:00.000
Atdissuedate
2022-07-05T14:00:53.000
Cb
12
House Num
212
Onstname
E. 5TH ST.
Atddismissed
No
16789
Atdid: 16789 • Atd Number: ATD-3-6586 • Bblid: 258667
Atdid
16789
Atd Number
ATD-3-6586
Bblid
258667
Inspectionid
389512
Inspect Date
2025-02-05T00:00:00.000
Atdissuedate
2025-02-06T13:41:51.000
Cb
6
House Num
500
Onstname
WARREN ST.
Atddismissed
Yes
Atddismissedon
2025-07-25T11:20:21.000
8931
Atdid: 8931 • Atd Number: ATD-2-860 • Bblid: 197518
Atdid
8931
Atd Number
ATD-2-860
Bblid
197518
Inspectionid
332159
Inspect Date
2019-08-06T00:00:00.000
Atdissuedate
2022-01-31T10:53:06.000
Cb
11
House Num
1727
Onstname
RADCLIFF AVE.
Atddismissed
No
17232
Atdid: 17232 • Atd Number: ATD-3-6812 • Bblid: 426055
Atdid
17232
Atd Number
ATD-3-6812
Bblid
426055
Inspectionid
393091
Inspect Date
2025-04-02T00:00:00.000
Atdissuedate
2025-04-03T10:10:19.000
Cb
12
House Num
1524
Onstname
58TH ST.
Atddismissed
No
6056
Atdid: 6056 • Atd Number: ATD-4-2417 • Bblid: 907375
Atdid
6056
Atd Number
ATD-4-2417
Bblid
907375
Violationid
237418
Atdissuedate
2020-06-05T00:00:00.000
Cb
14
House Num
9-18
Onstname
SEAGIRT BOULEVARD
Atddismissed
No
15042
Atdid: 15042 • Atd Number: ATD-3-6272 • Bblid: 510081
Atdid
15042
Atd Number
ATD-3-6272
Bblid
510081
Violationid
291857
Reinspectionid
37461
Inspect Date
2024-09-16T10:04:10.000
Atdissuedate
2024-09-16T10:04:10.000
Cb
15
House Num
2466
Onstname
EAST 26 STREET
Atddismissed
No
11487
Atdid: 11487 • Atd Number: ATD-4-4902 • Bblid: 837180
Atdid
11487
Atd Number
ATD-4-4902
Bblid
837180
Inspectionid
349108
Inspect Date
2022-12-08T00:00:00.000
Atdissuedate
2022-12-09T08:03:54.000
Cb
13
House Num
209-03
Onstname
115TH AVE.
Atddismissed
No
12843
Atdid: 12843 • Atd Number: ATD-4-5440 • Bblid: 645291
Atdid
12843
Atd Number
ATD-4-5440
Bblid
645291
Inspectionid
359943
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-07-13T12:15:11.000
Cb
4
House Num
86-21
Onstname
57TH RD.
Atddismissed
No
13854
Atdid: 13854 • Atd Number: ATD-3-5698 • Bblid: 511694
Atdid
13854
Atd Number
ATD-3-5698
Bblid
511694
Inspectionid
370497
Inspect Date
2024-01-08T00:00:00.000
Atdissuedate
2024-01-09T12:16:41.000
Cb
15
House Num
2557
Onstname
E. 29TH ST.
Atddismissed
No
14014
Atdid: 14014 • Atd Number: ATD-4-5836 • Bblid: 872561
Atdid
14014
Atd Number
ATD-4-5836
Bblid
872561
Inspectionid
372196
Inspect Date
2024-02-08T00:00:00.000
Atdissuedate
2024-02-26T10:51:16.000
Cb
12
House Num
120-55
Onstname
171ST ST.
Atddismissed
No
8698
Atdid: 8698 • Atd Number: ATD-3-3188 • Bblid: 536280
Atdid
8698
Atd Number
ATD-3-3188
Bblid
536280
Inspectionid
330898
Inspect Date
2019-10-09T00:00:00.000
Atdissuedate
2021-12-20T11:01:03.000
Cb
18
House Num
5
Onstname
PAERDEGAT 14 STREET
Atddismissed
No
16792
Atdid: 16792 • Atd Number: ATD-1-364 • Bblid: 116784
Atdid
16792
Atd Number
ATD-1-364
Bblid
116784
Inspectionid
389557
Inspect Date
2025-01-02T00:00:00.000
Atdissuedate
2025-02-07T13:12:05.000
Cb
10
House Num
18
Onstname
W. 120TH ST.
Atddismissed
No
9048
Atdid: 9048 • Atd Number: ATD-3-3311 • Bblid: 447849
Atdid
9048
Atd Number
ATD-3-3311
Bblid
447849
Inspectionid
332476
Inspect Date
2022-02-15T00:00:00.000
Atdissuedate
2022-02-17T09:44:44.000
Cb
10
House Num
1069
Onstname
78TH ST.
Atddismissed
No
10293
Atdid: 10293 • Atd Number: ATD-3-3844 • Bblid: 265590
Atdid
10293
Atd Number
ATD-3-3844
Bblid
265590
Inspectionid
337711
Inspect Date
2022-06-03T00:00:00.000
Atdissuedate
2022-06-14T10:19:32.000
Cb
7
House Num
416
Onstname
45TH ST.
Atddismissed
No
16434
Atdid: 16434 • Atd Number: ATD-4-6451 • Bblid: 766136
Atdid
16434
Atd Number
ATD-4-6451
Bblid
766136
Inspectionid
385403
Inspect Date
2024-11-23T00:00:00.000
Atdissuedate
2024-11-27T11:22:45.000
Cb
11
House Num
48-60
Onstname
GLENWOOD ST.
Atddismissed
No
11017
Atdid: 11017 • Atd Number: ATD-3-4369 • Bblid: 267214
Atdid
11017
Atd Number
ATD-3-4369
Bblid
267214
Inspectionid
344575
Inspect Date
2022-09-20T00:00:00.000
Atdissuedate
2022-09-26T12:36:14.000
Cb
7
House Num
439
Onstname
50TH ST.
Atddismissed
No
10648
Atdid: 10648 • Atd Number: ATD-3-4050 • Bblid: 554847
Atdid
10648
Atd Number
ATD-3-4050
Bblid
554847
Inspectionid
341456
Inspect Date
2022-08-13T00:00:00.000
Atdissuedate
2022-08-13T14:17:08.000
Cb
18
House Num
2783
Onstname
E. 65TH ST.
Atddismissed
No
8780
Atdid: 8780 • Atd Number: ATD-4-3957 • Bblid: 579911
Atdid
8780
Atd Number
ATD-4-3957
Bblid
579911
Inspectionid
331241
Inspect Date
2021-10-22T00:00:00.000
Atdissuedate
2021-12-29T14:32:42.000
Cb
1
House Num
30-20
Onstname
36TH ST.
Atddismissed
No
13758
Atdid: 13758 • Atd Number: ATD-4-5669 • Bblid: 657591
Atdid
13758
Atd Number
ATD-4-5669
Bblid
657591
Inspectionid
369219
Inspect Date
2023-12-08T00:00:00.000
Atdissuedate
2023-12-08T12:27:59.000
Cb
6
House Num
93-09
Onstname
69TH AVE.
Atddismissed
No
9233
Atdid: 9233 • Atd Number: ATD-1-189 • Bblid: 30909
Atdid
9233
Atd Number
ATD-1-189
Bblid
30909
Inspectionid
332939
Inspect Date
2021-07-21T00:00:00.000
Atdissuedate
2022-03-01T17:10:02.000
Cb
4
House Num
471
Onstname
W. 21ST ST.
Atddismissed
No
10353
Atdid: 10353 • Atd Number: ATD-3-3866 • Bblid: 421379
Atdid
10353
Atd Number
ATD-3-3866
Bblid
421379
Inspectionid
338410
Inspect Date
2022-06-28T00:00:00.000
Atdissuedate
2022-07-05T08:29:31.000
Cb
12
House Num
534
Onstname
E. 9TH ST.
Atddismissed
No
13363
Atdid: 13363 • Atd Number: ATD-3-5497 • Bblid: 540990
Atdid
13363
Atd Number
ATD-3-5497
Bblid
540990
Inspectionid
363000
Inspect Date
2023-08-24T00:00:00.000
Atdissuedate
2023-09-06T09:37:52.000
Cb
18
House Num
1012
Onstname
E. 105TH ST.
Atddismissed
No
14568
Atdid: 14568 • Atd Number: ATD-3-6024 • Bblid: 464484
Atdid
14568
Atd Number
ATD-3-6024
Bblid
464484
Inspectionid
378287
Inspect Date
2024-06-06T00:00:00.000
Atdissuedate
2024-06-10T11:59:57.000
Cb
11
House Num
1941
Onstname
84TH ST.
Atddismissed
No
9031
Atdid: 9031 • Atd Number: ATD-3-3305 • Bblid: 331994
Atdid
9031
Atd Number
ATD-3-3305
Bblid
331994
Inspectionid
332403
Inspect Date
2019-08-16T00:00:00.000
Atdissuedate
2022-02-11T15:34:18.000
Cb
1
House Num
263
Onstname
HOOPER ST.
Atddismissed
No
13050
Atdid: 13050 • Atd Number: ATD-3-5294 • Bblid: 422498
Atdid
13050
Atd Number
ATD-3-5294
Bblid
422498
Inspectionid
361044
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T16:22:12.000
Cb
12
House Num
1660
Onstname
45TH ST.
Atddismissed
No
11061
Atdid: 11061 • Atd Number: ATD-3-4409 • Bblid: 469728
Atdid
11061
Atd Number
ATD-3-4409
Bblid
469728
Inspectionid
344950
Inspect Date
2022-09-29T00:00:00.000
Atdissuedate
2022-09-30T17:05:26.000
Cb
11
House Num
8826
Onstname
20TH AVE.
Atddismissed
No
17160
Atdid: 17160 • Atd Number: ATD-3-6796 • Bblid: 295885
Atdid
17160
Atd Number
ATD-3-6796
Bblid
295885
Inspectionid
392658
Inspect Date
2021-11-05T00:00:00.000
Atdissuedate
2025-03-31T10:41:13.000
Cb
8
House Num
84A
Onstname
UTICA AVE.
Atddismissed
No
12857
Atdid: 12857 • Atd Number: ATD-3-5161 • Bblid: 510276
Atdid
12857
Atd Number
ATD-3-5161
Bblid
510276
Inspectionid
360009
Inspect Date
2023-07-14T00:00:00.000
Atdissuedate
2023-07-14T12:56:05.000
Cb
15
House Num
2448
Onstname
E. 28TH ST.
Atddismissed
No
3511
Atdid: 3511 • Atd Number: ATD-4-268 • Bblid: 666698
Atdid
3511
Atd Number
ATD-4-268
Bblid
666698
Violationid
109121
Atdissuedate
2020-08-14T00:00:00.000
Cb
5
House Num
5935
Onstname
CATALPA AVENUE
Atddismissed
Yes
Atddismissedon
2023-03-03T15:47:04.000
8551
Atdid: 8551 • Atd Number: ATD-2-841 • Bblid: 217712
Atdid
8551
Atd Number
ATD-2-841
Bblid
217712
Inspectionid
330354
Inspect Date
2021-10-12T00:00:00.000
Atdissuedate
2021-12-07T13:32:07.000
Cb
12
House Num
1962
Onstname
BURKE AVE.
Atddismissed
No
12291
Atdid: 12291 • Atd Number: ATD-2-1088 • Bblid: 162977
Atdid
12291
Atd Number
ATD-2-1088
Bblid
162977
Inspectionid
357340
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T11:45:30.000
Cb
5
House Num
2318
Onstname
JEROME AVE.
Atddismissed
No
3465
Atdid: 3465 • Atd Number: ATD-4-240 • Bblid: 732223
Atdid
3465
Atd Number
ATD-4-240
Bblid
732223
Violationid
116829
Atdissuedate
2020-08-14T00:00:00.000
Cb
7
House Num
63-03
Onstname
136 STREET
Atddismissed
Yes
Atddismissedon
2024-06-26T11:46:08.000
10737
Atdid: 10737 • Atd Number: ATD-3-4116 • Bblid: 554741
Atdid
10737
Atd Number
ATD-3-4116
Bblid
554741
Inspectionid
342615
Inspect Date
2022-08-23T00:00:00.000
Atdissuedate
2022-09-06T10:25:13.000
Cb
18
House Num
2739
Onstname
E. 64TH ST.
Atddismissed
No
16561
Atdid: 16561 • Atd Number: ATD-4-6501 • Bblid: 613814
Atdid
16561
Atd Number
ATD-4-6501
Bblid
613814
Inspectionid
386969
Inspect Date
2024-11-22T00:00:00.000
Atdissuedate
2024-12-19T14:53:15.000
Cb
4
House Num
94-60
Onstname
46TH AVE.
Atddismissed
No
13545
Atdid: 13545 • Atd Number: ATD-4-5584 • Bblid: 730659
Atdid
13545
Atd Number
ATD-4-5584
Bblid
730659
Inspectionid
364966
Inspect Date
2023-10-05T00:00:00.000
Atdissuedate
2023-10-05T12:48:09.000
Cb
11
House Num
40-14
Onstname
220TH ST.
Atddismissed
No
14069
Atdid: 14069 • Atd Number: ATD-3-5765 • Bblid: 303238
Atdid
14069
Atd Number
ATD-3-5765
Bblid
303238
Inspectionid
372766
Inspect Date
2024-03-06T00:00:00.000
Atdissuedate
2024-03-06T09:12:35.000
Cb
16
House Num
347
Onstname
MARION ST.
Atddismissed
No
16584
Atdid: 16584 • Atd Number: ATD-4-6509 • Bblid: 577269
Atdid
16584
Atd Number
ATD-4-6509
Bblid
577269
Inspectionid
387067
Inspect Date
2024-12-11T00:00:00.000
Atdissuedate
2024-12-20T12:44:25.000
Cb
1
House Num
33-49
Onstname
29TH ST.
Atddismissed
No
17567
Atdid: 17567 • Atd Number: ATD-3-6960 • Bblid: 287428
Atdid
17567
Atd Number
ATD-3-6960
Bblid
287428
Inspectionid
396536
Inspect Date
2025-05-06T00:00:00.000
Atdissuedate
2025-05-08T09:00:09.000
Cb
8
House Num
292
Onstname
PARK PL.
Atddismissed
No
18306
Atdid: 18306 • Atd Number: ATD-4-7234 • Bblid: 771061
Atdid
18306
Atd Number
ATD-4-7234
Bblid
771061
Inspectionid
404089
Inspect Date
2025-08-13T00:00:00.000
Atdissuedate
2025-08-13T08:34:00.000
Cb
13
House Num
85-16
Onstname
LITTLE NECK PKWY.
Atddismissed
No
9574
Atdid: 9574 • Atd Number: ATD-4-4296 • Bblid: 762067
Atdid
9574
Atd Number
ATD-4-4296
Bblid
762067
Inspectionid
333685
Inspect Date
2020-01-31T00:00:00.000
Atdissuedate
2022-03-11T15:01:05.000
Cb
13
House Num
90-12
Onstname
242ND ST.
Atddismissed
No
10031
Atdid: 10031 • Atd Number: ATD-4-4572 • Bblid: 654616
Atdid
10031
Atd Number
ATD-4-4572
Bblid
654616
Inspectionid
336017
Inspect Date
2022-04-22T00:00:00.000
Atdissuedate
2022-05-03T11:27:29.000
Cb
6
House Num
62-50
Onstname
DIETERLE CRES
Atddismissed
No
8756
Atdid: 8756 • Atd Number: ATD-3-3206 • Bblid: 292104
Atdid
8756
Atd Number
ATD-3-3206
Bblid
292104
Inspectionid
331115
Inspect Date
2021-12-23T00:00:00.000
Atdissuedate
2021-12-28T14:56:46.000
Cb
8
House Num
289
Onstname
NEW YORK AVE.
Atddismissed
No
12378
Atdid: 12378 • Atd Number: ATD-4-5244 • Bblid: 634481
Atdid
12378
Atd Number
ATD-4-5244
Bblid
634481
Inspectionid
357535
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:41:02.000
Cb
2
House Num
70-50
Onstname
QUEENS BLVD.
Atddismissed
No
NYC Data AI • Public-data exploration interface