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
14093
Atdid: 14093 • Atd Number: ATD-3-5778 • Bblid: 266533
Atdid
14093
Atd Number
ATD-3-5778
Bblid
266533
Inspectionid
372990
Inspect Date
2024-03-04T00:00:00.000
Atdissuedate
2024-03-11T13:23:55.000
Cb
7
House Num
4708
Onstname
6TH AVE.
Atddismissed
No
11323
Atdid: 11323 • Atd Number: ATD-2-957 • Bblid: 173825
Atdid
11323
Atd Number
ATD-2-957
Bblid
173825
Inspectionid
347480
Inspect Date
2022-10-19T00:00:00.000
Atdissuedate
2022-11-02T11:51:53.000
Cb
9
House Num
2115
Onstname
HOMER AVE.
Atddismissed
No
9434
Atdid: 9434 • Atd Number: ATD-4-4234 • Bblid: 654786
Atdid
9434
Atd Number
ATD-4-4234
Bblid
654786
Inspectionid
333266
Inspect Date
2022-03-04T00:00:00.000
Atdissuedate
2022-03-04T14:41:36.000
Cb
6
House Num
63-26
Onstname
DIETERLE CRES
Atddismissed
No
10355
Atdid: 10355 • Atd Number: ATD-3-3868 • Bblid: 421334
Atdid
10355
Atd Number
ATD-3-3868
Bblid
421334
Inspectionid
338461
Inspect Date
2022-06-23T00:00:00.000
Atdissuedate
2022-07-05T09:22:39.000
Cb
12
House Num
635
Onstname
DAHILL RD.
Atddismissed
No
14118
Atdid: 14118 • Atd Number: ATD-3-5800 • Bblid: 519948
Atdid
14118
Atd Number
ATD-3-5800
Bblid
519948
Inspectionid
373274
Inspect Date
2024-03-15T00:00:00.000
Atdissuedate
2024-03-15T14:32:54.000
Cb
18
House Num
1663
Onstname
E. 34TH ST.
Atddismissed
No
17962
Atdid: 17962 • Atd Number: ATD-4-7093 • Bblid: 756168
Atdid
17962
Atd Number
ATD-4-7093
Bblid
756168
Inspectionid
400829
Inspect Date
2025-06-23T00:00:00.000
Atdissuedate
2025-06-24T11:56:12.000
Cb
11
House Num
64-16
Onstname
215TH ST.
Atddismissed
No
18553
Atdid: 18553 • Atd Number: ATD-4-7358 • Bblid: 589025
Atdid
18553
Atd Number
ATD-4-7358
Bblid
589025
Inspectionid
405538
Inspect Date
2025-07-18T00:00:00.000
Atdissuedate
2025-09-09T10:29:42.000
Cb
1
House Num
25-49
Onstname
CRESCENT ST.
Atddismissed
No
10478
Atdid: 10478 • Atd Number: ATD-3-3947 • Bblid: 270429
Atdid
10478
Atd Number
ATD-3-3947
Bblid
270429
Inspectionid
339714
Inspect Date
2022-06-04T00:00:00.000
Atdissuedate
2022-07-14T15:47:19.000
Cb
7
House Num
5710
Onstname
6TH AVE.
Atddismissed
No
17678
Atdid: 17678 • Atd Number: ATD-4-6934 • Bblid: 877167
Atdid
17678
Atd Number
ATD-4-6934
Bblid
877167
Inspectionid
397700
Inspect Date
2025-05-08T00:00:00.000
Atdissuedate
2025-05-20T09:19:35.000
Cb
12
House Num
118-40
Onstname
205TH ST.
Atddismissed
No
17834
Atdid: 17834 • Atd Number: ATD-3-7031 • Bblid: 299857
Atdid
17834
Atd Number
ATD-3-7031
Bblid
299857
Inspectionid
399438
Inspect Date
2025-06-05T00:00:00.000
Atdissuedate
2025-06-09T09:52:13.000
Cb
16
House Num
2101
Onstname
DEAN ST.
Atddismissed
No
8919
Atdid: 8919 • Atd Number: ATD-3-3254 • Bblid: 465995
Atdid
8919
Atd Number
ATD-3-3254
Bblid
465995
Inspectionid
332146
Inspect Date
2020-03-03T00:00:00.000
Atdissuedate
2022-01-31T08:55:24.000
Cb
11
House Num
1943
Onstname
BENSON AVE.
Atddismissed
No
9189
Atdid: 9189 • Atd Number: ATD-3-3348 • Bblid: 426203
Atdid
9189
Atd Number
ATD-3-3348
Bblid
426203
Inspectionid
332847
Inspect Date
2021-05-14T00:00:00.000
Atdissuedate
2022-02-28T17:24:13.000
Cb
12
House Num
5814
Onstname
17TH AVE.
Atddismissed
No
9571
Atdid: 9571 • Atd Number: ATD-3-3561 • Bblid: 415499
Atdid
9571
Atd Number
ATD-3-3561
Bblid
415499
Inspectionid
333677
Inspect Date
2021-06-30T00:00:00.000
Atdissuedate
2022-03-11T14:04:16.000
Cb
7
House Num
51
Onstname
E. 3RD ST.
Atddismissed
No
13253
Atdid: 13253 • Atd Number: ATD-3-5424 • Bblid: 422851
Atdid
13253
Atd Number
ATD-3-5424
Bblid
422851
Inspectionid
362073
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T16:55:11.000
Cb
12
House Num
1630
Onstname
47TH ST.
Atddismissed
No
9153
Atdid: 9153 • Atd Number: ATD-5-607 • Bblid: 1028706
Atdid
9153
Atd Number
ATD-5-607
Bblid
1028706
Inspectionid
332748
Inspect Date
2022-02-23T00:00:00.000
Atdissuedate
2022-02-24T13:42:01.000
Cb
3
House Num
276
Onstname
ANNADALE RD.
Atddismissed
No
9468
Atdid: 9468 • Atd Number: ATD-4-4247 • Bblid: 734317
Atdid
9468
Atd Number
ATD-4-4247
Bblid
734317
Inspectionid
333368
Inspect Date
2019-08-10T00:00:00.000
Atdissuedate
2022-03-07T15:53:47.000
Cb
8
House Num
144-27
Onstname
69TH AVE.
Atddismissed
No
12374
Atdid: 12374 • Atd Number: ATD-4-5240 • Bblid: 634489
Atdid
12374
Atd Number
ATD-4-5240
Bblid
634489
Inspectionid
357531
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:37:51.000
Cb
2
House Num
70-20
Onstname
QUEENS BLVD.
Atddismissed
No
14993
Atdid: 14993 • Atd Number: ATD-4-6263 • Bblid: 685147
Atdid
14993
Atd Number
ATD-4-6263
Bblid
685147
Inspectionid
381488
Inspect Date
2024-08-20T00:00:00.000
Atdissuedate
2024-09-09T09:03:12.000
Cb
7
House Num
25-47
Onstname
123RD ST.
Atddismissed
No
18236
Atdid: 18236 • Atd Number: ATD-3-7199 • Bblid: 550985
Atdid
18236
Atd Number
ATD-3-7199
Bblid
550985
Inspectionid
403530
Inspect Date
2025-07-10T00:00:00.000
Atdissuedate
2025-08-04T10:35:07.000
Cb
18
House Num
1829
Onstname
E. 33RD ST.
Atddismissed
No
16301
Atdid: 16301 • Atd Number: ATD-3-6378 • Bblid: 274141
Atdid
16301
Atd Number
ATD-3-6378
Bblid
274141
Inspectionid
384484
Inspect Date
2024-10-08T00:00:00.000
Atdissuedate
2024-10-28T11:10:53.000
Cb
6
House Num
15
Onstname
PROSPECT PL.
Atddismissed
No
16469
Atdid: 16469 • Atd Number: ATD-4-6482 • Bblid: 572436
Atdid
16469
Atd Number
ATD-4-6482
Bblid
572436
Inspectionid
385647
Inspect Date
2024-11-20T00:00:00.000
Atdissuedate
2024-12-02T13:31:58.000
Cb
1
House Num
35-20
Onstname
CRESCENT ST.
Atddismissed
No
8731
Atdid: 8731 • Atd Number: ATD-4-3927 • Bblid: 784794
Atdid
8731
Atd Number
ATD-4-3927
Bblid
784794
Inspectionid
331084
Inspect Date
2021-12-28T00:00:00.000
Atdissuedate
2021-12-28T12:14:28.000
Cb
9
House Num
81-37
Onstname
102ND RD.
Atddismissed
No
18243
Atdid: 18243 • Atd Number: ATD-2-1442 • Bblid: 236375
Atdid
18243
Atd Number
ATD-2-1442
Bblid
236375
Inspectionid
403569
Inspect Date
2025-07-02T00:00:00.000
Atdissuedate
2025-08-04T12:09:53.000
Cb
10
House Num
657
Onstname
VINCENT AVE.
Atddismissed
No
12421
Atdid: 12421 • Atd Number: ATD-1-286 • Bblid: 51257
Atdid
12421
Atd Number
ATD-1-286
Bblid
51257
Inspectionid
357746
Inspect Date
2023-05-26T00:00:00.000
Atdissuedate
2023-05-26T12:26:59.000
Cb
5
House Num
1133
Onstname
AVENUE OF THE AMER
Atddismissed
No
17688
Atdid: 17688 • Atd Number: ATD-4-6944 • Bblid: 909902
Atdid
17688
Atd Number
ATD-4-6944
Bblid
909902
Inspectionid
397787
Inspect Date
2025-05-12T00:00:00.000
Atdissuedate
2025-05-20T12:09:03.000
Cb
14
House Num
29-26
Onstname
OCEANCREST BLVD.
Atddismissed
No
9252
Atdid: 9252 • Atd Number: ATD-3-3380 • Bblid: 470508
Atdid
9252
Atd Number
ATD-3-3380
Bblid
470508
Inspectionid
332958
Inspect Date
2021-01-07T00:00:00.000
Atdissuedate
2022-03-01T17:32:02.000
Cb
14
House Num
805
Onstname
OCEAN PKWY.
Atddismissed
No
18296
Atdid: 18296 • Atd Number: ATD-4-7228 • Bblid: 572733
Atdid
18296
Atd Number
ATD-4-7228
Bblid
572733
Inspectionid
403982
Inspect Date
2024-08-28T00:00:00.000
Atdissuedate
2025-08-11T15:01:16.000
Cb
1
House Num
36-10
Onstname
CRESCENT ST.
Atddismissed
No
12603
Atdid: 12603 • Atd Number: ATD-4-5366 • Bblid: 891767
Atdid
12603
Atd Number
ATD-4-5366
Bblid
891767
Inspectionid
358643
Inspect Date
2023-06-13T00:00:00.000
Atdissuedate
2023-06-15T12:37:25.000
Cb
13
House Num
180-09
Onstname
145TH DR.
Atddismissed
No
17188
Atdid: 17188 • Atd Number: ATD-4-6701 • Bblid: 631342
Atdid
17188
Atd Number
ATD-4-6701
Bblid
631342
Inspectionid
392781
Inspect Date
2023-03-28T00:00:00.000
Atdissuedate
2025-03-31T13:28:07.000
Cb
2
House Num
51-23
Onstname
47TH ST.
Atddismissed
No
17787
Atdid: 17787 • Atd Number: ATD-3-7016 • Bblid: 516264
Atdid
17787
Atd Number
ATD-3-7016
Bblid
516264
Inspectionid
399038
Inspect Date
2025-05-30T00:00:00.000
Atdissuedate
2025-06-04T09:43:11.000
Cb
18
House Num
1129
Onstname
E. 32ND ST.
Atddismissed
No
10793
Atdid: 10793 • Atd Number: ATD-3-4170 • Bblid: 260824
Atdid
10793
Atd Number
ATD-3-4170
Bblid
260824
Inspectionid
342973
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-09-08T09:56:52.000
Cb
6
House Num
86
Onstname
2ND ST.
Atddismissed
No
10601
Atdid: 10601 • Atd Number: ATD-3-4026 • Bblid: 319126
Atdid
10601
Atd Number
ATD-3-4026
Bblid
319126
Inspectionid
340901
Inspect Date
2022-08-03T00:00:00.000
Atdissuedate
2022-08-04T14:49:10.000
Cb
3
House Num
289
Onstname
JEFFERSON AVE.
Atddismissed
No
16459
Atdid: 16459 • Atd Number: ATD-4-6472 • Bblid: 618585
Atdid
16459
Atd Number
ATD-4-6472
Bblid
618585
Inspectionid
385571
Inspect Date
2024-11-14T00:00:00.000
Atdissuedate
2024-12-02T12:23:14.000
Cb
3
House Num
97-17
Onstname
38TH AVE.
Atddismissed
No
9719
Atdid: 9719 • Atd Number: ATD-4-4403 • Bblid: 680348
Atdid
9719
Atd Number
ATD-4-4403
Bblid
680348
Inspectionid
334132
Inspect Date
2018-06-07T00:00:00.000
Atdissuedate
2022-03-24T17:33:08.000
Cb
7
House Num
7-11
Onstname
127TH ST.
Atddismissed
Yes
Atddismissedon
2024-04-19T14:31:16.000
12299
Atdid: 12299 • Atd Number: ATD-2-1096 • Bblid: 153394
Atdid
12299
Atd Number
ATD-2-1096
Bblid
153394
Inspectionid
357348
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T12:03:15.000
Cb
4
House Num
1400
Onstname
CROMWELL AVENUE
Atddismissed
No
12376
Atdid: 12376 • Atd Number: ATD-4-5242 • Bblid: 634485
Atdid
12376
Atd Number
ATD-4-5242
Bblid
634485
Inspectionid
357533
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:39:18.000
Cb
2
House Num
70-32
Onstname
47 AVENUE
Atddismissed
No
14086
Atdid: 14086 • Atd Number: ATD-4-5878 • Bblid: 620538
Atdid
14086
Atd Number
ATD-4-5878
Bblid
620538
Inspectionid
372884
Inspect Date
2024-03-08T00:00:00.000
Atdissuedate
2024-03-08T12:43:44.000
Cb
4
House Num
88-27
Onstname
54TH AVE.
Atddismissed
No
14354
Atdid: 14354 • Atd Number: ATD-4-6000 • Bblid: 629928
Atdid
14354
Atd Number
ATD-4-6000
Bblid
629928
Inspectionid
376108
Inspect Date
2024-04-25T00:00:00.000
Atdissuedate
2024-04-25T10:55:42.000
Cb
6
House Num
112-45
Onstname
69TH AVE.
Atddismissed
No
9672
Atdid: 9672 • Atd Number: ATD-5-645 • Bblid: 926214
Atdid
9672
Atd Number
ATD-5-645
Bblid
926214
Inspectionid
333869
Inspect Date
2021-04-07T00:00:00.000
Atdissuedate
2022-03-16T17:57:57.000
Cb
1
House Num
482
Onstname
KISSEL AVE.
Atddismissed
No
11869
Atdid: 11869 • Atd Number: ATD-3-4842 • Bblid: 287517
Atdid
11869
Atd Number
ATD-3-4842
Bblid
287517
Inspectionid
353629
Inspect Date
2023-03-22T00:00:00.000
Atdissuedate
2023-03-22T12:36:38.000
Cb
8
House Num
404
Onstname
PARK PL.
Atddismissed
No
14204
Atdid: 14204 • Atd Number: ATD-2-1264 • Bblid: 197498
Atdid
14204
Atd Number
ATD-2-1264
Bblid
197498
Inspectionid
373914
Inspect Date
2024-03-21T00:00:00.000
Atdissuedate
2024-03-21T12:58:29.000
Cb
11
House Num
933
Onstname
VAN NEST AVE.
Atddismissed
No
13327
Atdid: 13327 • Atd Number: ATD-4-5518 • Bblid: 618830
Atdid
13327
Atd Number
ATD-4-5518
Bblid
618830
Inspectionid
362635
Inspect Date
2023-08-25T00:00:00.000
Atdissuedate
2023-08-28T11:15:11.000
Cb
3
House Num
37-21
Onstname
99TH ST.
Atddismissed
No
1131
Atdid: 1131 • Atd Number: ATD-3-274 • Bblid: 257862
Atdid
1131
Atd Number
ATD-3-274
Bblid
257862
Violationid
41642
Atdissuedate
2020-08-13T00:00:00.000
Cb
6
House Num
149
Onstname
HUNTINGTON STREET
Atddismissed
Yes
Atddismissedon
2023-11-29T07:46:33.000
10693
Atdid: 10693 • Atd Number: ATD-4-4796 • Bblid: 774288
Atdid
10693
Atd Number
ATD-4-4796
Bblid
774288
Inspectionid
342065
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-08-26T12:24:42.000
Cb
13
House Num
82-32
Onstname
261ST ST.
Atddismissed
No
12615
Atdid: 12615 • Atd Number: ATD-2-1164 • Bblid: 144495
Atdid
12615
Atd Number
ATD-2-1164
Bblid
144495
Inspectionid
358713
Inspect Date
2023-06-13T00:00:00.000
Atdissuedate
2023-06-16T12:33:24.000
Cb
4
House Num
1055
Onstname
ANDERSON AVE.
Atddismissed
No
10521
Atdid: 10521 • Atd Number: ATD-2-937 • Bblid: 210849
Atdid
10521
Atd Number
ATD-2-937
Bblid
210849
Inspectionid
340097
Inspect Date
2022-07-06T00:00:00.000
Atdissuedate
2022-07-19T15:35:52.000
Cb
12
House Num
3222
Onstname
BRONXWOOD AVE.
Atddismissed
No
12040
Atdid: 12040 • Atd Number: ATD-3-4933 • Bblid: 414348
Atdid
12040
Atd Number
ATD-3-4933
Bblid
414348
Inspectionid
355916
Inspect Date
2023-04-10T00:00:00.000
Atdissuedate
2023-04-17T10:28:12.000
Cb
14
House Num
711
Onstname
E. 18TH ST.
Atddismissed
No
9489
Atdid: 9489 • Atd Number: ATD-3-3531 • Bblid: 276061
Atdid
9489
Atd Number
ATD-3-3531
Bblid
276061
Inspectionid
333395
Inspect Date
2021-07-29T00:00:00.000
Atdissuedate
2022-03-08T11:16:11.000
Cb
6
House Num
639
Onstname
CARROLL ST.
Atddismissed
No
12547
Atdid: 12547 • Atd Number: ATD-3-5069 • Bblid: 251249
Atdid
12547
Atd Number
ATD-3-5069
Bblid
251249
Inspectionid
358442
Inspect Date
2023-06-01T00:00:00.000
Atdissuedate
2023-06-13T08:36:00.000
Cb
2
House Num
225
Onstname
BERGEN ST.
Atddismissed
No
9818
Atdid: 9818 • Atd Number: ATD-4-4443 • Bblid: 578214
Atdid
9818
Atd Number
ATD-4-4443
Bblid
578214
Inspectionid
334518
Inspect Date
2021-06-09T00:00:00.000
Atdissuedate
2022-04-04T09:53:30.000
Cb
1
House Num
31-54
Onstname
32ND ST.
Atddismissed
No
NYC Data AI • Public-data exploration interface