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
16408
Atdid: 16408 • Atd Number: ATD-5-894 • Bblid: 1056177
Atdid
16408
Atd Number
ATD-5-894
Bblid
1056177
Inspectionid
385162
Inspect Date
2024-11-15T00:00:00.000
Atdissuedate
2024-11-19T09:19:31.000
Cb
3
House Num
235
Onstname
HECKER ST.
Atddismissed
No
18377
Atdid: 18377 • Atd Number: ATD-4-7269 • Bblid: 887083
Atdid
18377
Atd Number
ATD-4-7269
Bblid
887083
Inspectionid
404522
Inspect Date
2025-08-05T00:00:00.000
Atdissuedate
2025-08-20T11:06:05.000
Cb
13
House Num
135-19
Onstname
222ND ST.
Atddismissed
No
8948
Atdid: 8948 • Atd Number: ATD-3-3271 • Bblid: 325175
Atdid
8948
Atd Number
ATD-3-3271
Bblid
325175
Inspectionid
332249
Inspect Date
2019-06-07T00:00:00.000
Atdissuedate
2022-02-04T11:04:39.000
Cb
2
House Num
73
Onstname
DOWNING ST.
Atddismissed
No
11685
Atdid: 11685 • Atd Number: ATD-3-4750 • Bblid: 503509
Atdid
11685
Atd Number
ATD-3-4750
Bblid
503509
Inspectionid
351804
Inspect Date
2023-02-08T00:00:00.000
Atdissuedate
2023-02-21T11:17:45.000
Cb
15
House Num
1967
Onstname
E. 24TH ST.
Atddismissed
No
13132
Atdid: 13132 • Atd Number: ATD-3-5344 • Bblid: 422768
Atdid
13132
Atd Number
ATD-3-5344
Bblid
422768
Inspectionid
361478
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T12:37:53.000
Cb
12
House Num
1582
Onstname
46TH ST.
Atddismissed
No
17372
Atdid: 17372 • Atd Number: ATD-3-6889 • Bblid: 284562
Atdid
17372
Atd Number
ATD-3-6889
Bblid
284562
Inspectionid
394696
Inspect Date
2025-04-09T00:00:00.000
Atdissuedate
2025-04-15T07:39:18.000
Cb
7
House Num
21
Onstname
WINDSOR PL.
Atddismissed
No
13071
Atdid: 13071 • Atd Number: ATD-2-1204 • Bblid: 226560
Atdid
13071
Atd Number
ATD-2-1204
Bblid
226560
Inspectionid
361105
Inspect Date
2023-06-24T00:00:00.000
Atdissuedate
2023-07-31T13:31:46.000
Cb
12
House Num
4371
Onstname
WICKHAM AVE.
Atddismissed
No
10912
Atdid: 10912 • Atd Number: ATD-3-4283 • Bblid: 271284
Atdid
10912
Atd Number
ATD-3-4283
Bblid
271284
Inspectionid
343717
Inspect Date
2022-09-08T00:00:00.000
Atdissuedate
2022-09-13T07:48:47.000
Cb
7
House Num
505
Onstname
17TH ST.
Atddismissed
No
14707
Atdid: 14707 • Atd Number: ATD-3-6108 • Bblid: 493362
Atdid
14707
Atd Number
ATD-3-6108
Bblid
493362
Violationid
291859
Reinspectionid
36598
Inspect Date
2024-07-09T11:23:36.000
Atdissuedate
2024-07-09T11:23:36.000
Cb
11
House Num
1969
Onstname
WEST 12 STREET
Atddismissed
No
9451
Atdid: 9451 • Atd Number: ATD-3-3514 • Bblid: 469012
Atdid
9451
Atd Number
ATD-3-3514
Bblid
469012
Inspectionid
333285
Inspect Date
2019-04-13T00:00:00.000
Atdissuedate
2022-03-04T17:39:31.000
Cb
11
House Num
310
Onstname
BAY 11TH ST.
Atddismissed
No
13460
Atdid: 13460 • Atd Number: ATD-4-5540 • Bblid: 758736
Atdid
13460
Atd Number
ATD-4-5540
Bblid
758736
Inspectionid
364121
Inspect Date
2023-09-22T00:00:00.000
Atdissuedate
2023-09-22T14:44:53.000
Cb
11
House Num
80-32
Onstname
SPRINGFIELD BLVD.
Atddismissed
No
14814
Atdid: 14814 • Atd Number: ATD-3-6153 • Bblid: 258145
Atdid
14814
Atd Number
ATD-3-6153
Bblid
258145
Inspectionid
379898
Inspect Date
2024-07-26T00:00:00.000
Atdissuedate
2024-07-29T11:00:30.000
Cb
2
House Num
158
Onstname
NEVINS ST.
Atddismissed
No
16328
Atdid: 16328 • Atd Number: ATD-3-6401 • Bblid: 257761
Atdid
16328
Atd Number
ATD-3-6401
Bblid
257761
Inspectionid
384683
Inspect Date
2022-05-11T00:00:00.000
Atdissuedate
2024-11-02T12:17:03.000
Cb
6
House Num
145
Onstname
NELSON ST.
Atddismissed
No
18629
Atdid: 18629 • Atd Number: ATD-3-7340 • Bblid: 391377
Atdid
18629
Atd Number
ATD-3-7340
Bblid
391377
Inspectionid
406198
Inspect Date
2025-03-20T00:00:00.000
Atdissuedate
2025-09-19T16:56:35.000
Cb
17
House Num
39
Onstname
E. 53RD ST.
Atddismissed
No
13221
Atdid: 13221 • Atd Number: ATD-3-5392 • Bblid: 422659
Atdid
13221
Atd Number
ATD-3-5392
Bblid
422659
Inspectionid
362041
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T15:26:52.000
Cb
12
House Num
1751
Onstname
46TH ST.
Atddismissed
No
18028
Atdid: 18028 • Atd Number: ATD-3-7101 • Bblid: 250791
Atdid
18028
Atd Number
ATD-3-7101
Bblid
250791
Inspectionid
401924
Inspect Date
2025-07-01T00:00:00.000
Atdissuedate
2025-07-07T14:40:54.000
Cb
2
House Num
479 A
Onstname
PACIFIC STREET
Atddismissed
No
10021
Atdid: 10021 • Atd Number: ATD-4-4565 • Bblid: 654516
Atdid
10021
Atd Number
ATD-4-4565
Bblid
654516
Inspectionid
335988
Inspect Date
2022-04-21T00:00:00.000
Atdissuedate
2022-05-03T10:51:22.000
Cb
6
House Num
62-08
Onstname
ELLWELL CRES
Atddismissed
No
10327
Atdid: 10327 • Atd Number: ATD-4-4680 • Bblid: 582045
Atdid
10327
Atd Number
ATD-4-4680
Bblid
582045
Inspectionid
338071
Inspect Date
2022-05-06T00:00:00.000
Atdissuedate
2022-06-25T18:43:40.000
Cb
1
House Num
30-17
Onstname
43RD ST.
Atddismissed
No
11142
Atdid: 11142 • Atd Number: ATD-3-4473 • Bblid: 378454
Atdid
11142
Atd Number
ATD-3-4473
Bblid
378454
Inspectionid
345788
Inspect Date
2022-10-07T00:00:00.000
Atdissuedate
2022-10-13T13:39:33.000
Cb
5
House Num
629
Onstname
ELTON ST.
Atddismissed
No
12211
Atdid: 12211 • Atd Number: ATD-4-5182 • Bblid: 721107
Atdid
12211
Atd Number
ATD-4-5182
Bblid
721107
Inspectionid
356872
Inspect Date
2023-05-10T00:00:00.000
Atdissuedate
2023-05-10T14:36:12.000
Cb
7
House Num
16-50
Onstname
201ST ST.
Atddismissed
No
14914
Atdid: 14914 • Atd Number: ATD-4-6226 • Bblid: 779834
Atdid
14914
Atd Number
ATD-4-6226
Bblid
779834
Inspectionid
380680
Inspect Date
2024-08-10T00:00:00.000
Atdissuedate
2024-08-16T09:30:29.000
Cb
9
House Num
90-32
Onstname
77TH ST.
Atddismissed
No
9162
Atdid: 9162 • Atd Number: ATD-3-3337 • Bblid: 407492
Atdid
9162
Atd Number
ATD-3-3337
Bblid
407492
Inspectionid
332780
Inspect Date
2019-04-23T00:00:00.000
Atdissuedate
2022-02-25T13:03:23.000
Cb
9
House Num
82
Onstname
MIDWOOD ST.
Atddismissed
No
9388
Atdid: 9388 • Atd Number: ATD-4-4207 • Bblid: 795710
Atdid
9388
Atd Number
ATD-4-4207
Bblid
795710
Inspectionid
333133
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-03-03T12:51:40.000
Cb
9
House Num
101-48
Onstname
116TH ST.
Atddismissed
No
14923
Atdid: 14923 • Atd Number: ATD-3-6204 • Bblid: 465678
Atdid
14923
Atd Number
ATD-3-6204
Bblid
465678
Inspectionid
380735
Inspect Date
2024-08-13T00:00:00.000
Atdissuedate
2024-08-19T09:10:43.000
Cb
11
House Num
78
Onstname
BAY 19TH ST.
Atddismissed
No
13492
Atdid: 13492 • Atd Number: ATD-4-5552 • Bblid: 577255
Atdid
13492
Atd Number
ATD-4-5552
Bblid
577255
Inspectionid
364479
Inspect Date
2023-08-31T00:00:00.000
Atdissuedate
2023-09-27T12:08:56.000
Cb
1
House Num
33-67
Onstname
29TH ST.
Atddismissed
No
14735
Atdid: 14735 • Atd Number: ATD-3-6121 • Bblid: 530438
Atdid
14735
Atd Number
ATD-3-6121
Bblid
530438
Inspectionid
379312
Inspect Date
2024-05-22T00:00:00.000
Atdissuedate
2024-07-15T09:40:18.000
Cb
17
House Num
5302
Onstname
AVENUE D.
Atddismissed
No
17838
Atdid: 17838 • Atd Number: ATD-4-7036 • Bblid: 810866
Atdid
17838
Atd Number
ATD-4-7036
Bblid
810866
Inspectionid
399585
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-09T12:08:41.000
Cb
8
House Num
85-09
Onstname
RADNOR ST.
Atddismissed
No
8670
Atdid: 8670 • Atd Number: ATD-4-3896 • Bblid: 719564
Atdid
8670
Atd Number
ATD-4-3896
Bblid
719564
Inspectionid
330839
Inspect Date
2021-12-14T00:00:00.000
Atdissuedate
2021-12-16T15:18:43.000
Cb
11
House Num
56-53
Onstname
187TH ST.
Atddismissed
No
16234
Atdid: 16234 • Atd Number: ATD-3-6350 • Bblid: 396579
Atdid
16234
Atd Number
ATD-3-6350
Bblid
396579
Inspectionid
384172
Inspect Date
2024-09-16T00:00:00.000
Atdissuedate
2024-10-15T13:28:44.000
Cb
17
House Num
638
Onstname
ROCKAWAY PKWY.
Atddismissed
No
8621
Atdid: 8621 • Atd Number: ATD-3-3160 • Bblid: 282755
Atdid
8621
Atd Number
ATD-3-3160
Bblid
282755
Inspectionid
330716
Inspect Date
2019-05-15T00:00:00.000
Atdissuedate
2021-12-14T17:26:14.000
Cb
6
House Num
583
Onstname
7TH ST.
Atddismissed
No
16562
Atdid: 16562 • Atd Number: ATD-4-6502 • Bblid: 613816
Atdid
16562
Atd Number
ATD-4-6502
Bblid
613816
Inspectionid
386970
Inspect Date
2024-11-22T00:00:00.000
Atdissuedate
2024-12-19T14:54:08.000
Cb
4
House Num
94-62
Onstname
46TH AVE.
Atddismissed
Yes
Atddismissedon
2024-12-19T14:54:39.000
17354
Atdid: 17354 • Atd Number: ATD-4-6767 • Bblid: 741855
Atdid
17354
Atd Number
ATD-4-6767
Bblid
741855
Inspectionid
394588
Inspect Date
2025-04-10T00:00:00.000
Atdissuedate
2025-04-14T13:02:46.000
Cb
8
House Num
159-03
Onstname
GRAND CENTRAL PKWY.
Atddismissed
No
16901
Atdid: 16901 • Atd Number: ATD-2-1337 • Bblid: 175983
Atdid
16901
Atd Number
ATD-2-1337
Bblid
175983
Inspectionid
390859
Inspect Date
2025-03-04T00:00:00.000
Atdissuedate
2025-03-11T08:54:32.000
Cb
9
House Num
1124
Onstname
MANOR AVE.
Atddismissed
No
14107
Atdid: 14107 • Atd Number: ATD-3-5790 • Bblid: 518383
Atdid
14107
Atd Number
ATD-3-5790
Bblid
518383
Inspectionid
373179
Inspect Date
2024-03-11T00:00:00.000
Atdissuedate
2024-03-14T11:43:07.000
Cb
14
House Num
1343
Onstname
E. 29TH ST.
Atddismissed
No
9895
Atdid: 9895 • Atd Number: ATD-4-4501 • Bblid: 777132
Atdid
9895
Atd Number
ATD-4-4501
Bblid
777132
Inspectionid
335068
Inspect Date
2022-04-15T00:00:00.000
Atdissuedate
2022-04-18T08:36:31.000
Cb
9
House Num
85-87
Onstname
87TH ST.
Atddismissed
No
17915
Atdid: 17915 • Atd Number: ATD-2-1421 • Bblid: 240706
Atdid
17915
Atd Number
ATD-2-1421
Bblid
240706
Inspectionid
400572
Inspect Date
2025-05-15T00:00:00.000
Atdissuedate
2025-06-17T14:47:37.000
Cb
10
House Num
111
Onstname
BUCKLEY ST.
Atddismissed
No
14427
Atdid: 14427 • Atd Number: ATD-3-5961 • Bblid: 251392
Atdid
14427
Atd Number
ATD-3-5961
Bblid
251392
Inspectionid
377056
Inspect Date
2024-04-18T00:00:00.000
Atdissuedate
2024-05-08T12:53:21.000
Cb
2
House Num
144
Onstname
DEAN ST.
Atddismissed
No
8720
Atdid: 8720 • Atd Number: ATD-3-3199 • Bblid: 258859
Atdid
8720
Atd Number
ATD-3-3199
Bblid
258859
Inspectionid
331041
Inspect Date
2021-12-11T00:00:00.000
Atdissuedate
2021-12-27T14:05:27.000
Cb
6
House Num
117
Onstname
BUTLER ST.
Atddismissed
No
9478
Atdid: 9478 • Atd Number: ATD-3-3522 • Bblid: 267671
Atdid
9478
Atd Number
ATD-3-3522
Bblid
267671
Inspectionid
333382
Inspect Date
2021-06-25T00:00:00.000
Atdissuedate
2022-03-08T09:12:53.000
Cb
7
House Num
253
Onstname
51ST ST.
Atddismissed
No
14485
Atdid: 14485 • Atd Number: ATD-2-1273 • Bblid: 164542
Atdid
14485
Atd Number
ATD-2-1273
Bblid
164542
Inspectionid
377453
Inspect Date
2024-05-04T00:00:00.000
Atdissuedate
2024-05-20T09:04:27.000
Cb
8
House Num
2716
Onstname
KINGSBRIDGE TER.
Atddismissed
No
16535
Atdid: 16535 • Atd Number: ATD-3-6473 • Bblid: 355799
Atdid
16535
Atd Number
ATD-3-6473
Bblid
355799
Inspectionid
386447
Inspect Date
2024-12-04T00:00:00.000
Atdissuedate
2024-12-18T07:51:43.000
Cb
4
House Num
1059
Onstname
GREENE AVE.
Atddismissed
No
9438
Atdid: 9438 • Atd Number: ATD-4-4238 • Bblid: 654776
Atdid
9438
Atd Number
ATD-4-4238
Bblid
654776
Inspectionid
333271
Inspect Date
2022-03-04T00:00:00.000
Atdissuedate
2022-03-04T14:45:12.000
Cb
6
House Num
63-02
Onstname
DIETERLE CRES
Atddismissed
No
12799
Atdid: 12799 • Atd Number: ATD-3-5133 • Bblid: 291411
Atdid
12799
Atd Number
ATD-3-5133
Bblid
291411
Inspectionid
359670
Inspect Date
2023-07-06T00:00:00.000
Atdissuedate
2023-07-10T11:18:42.000
Cb
8
House Num
971
Onstname
SAINT JOHNS PL.
Atddismissed
No
12824
Atdid: 12824 • Atd Number: ATD-2-1188 • Bblid: 171960
Atdid
12824
Atd Number
ATD-2-1188
Bblid
171960
Inspectionid
359877
Inspect Date
2023-05-05T00:00:00.000
Atdissuedate
2023-07-12T10:57:09.000
Cb
9
House Num
538
Onstname
COMMONWEALTH AVE.
Atddismissed
No
12978
Atdid: 12978 • Atd Number: ATD-1-303 • Bblid: 136761
Atdid
12978
Atd Number
ATD-1-303
Bblid
136761
Inspectionid
360657
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2023-07-25T12:39:50.000
Cb
8
House Num
51
Onstname
ADRIAN AVE.
Atddismissed
No
17167
Atdid: 17167 • Atd Number: ATD-2-1357 • Bblid: 208970
Atdid
17167
Atd Number
ATD-2-1357
Bblid
208970
Inspectionid
392680
Inspect Date
2025-03-28T00:00:00.000
Atdissuedate
2025-03-31T11:04:40.000
Cb
11
House Num
2717
Onstname
MICKLE AVE.
Atddismissed
No
16754
Atdid: 16754 • Atd Number: ATD-4-6596 • Bblid: 579651
Atdid
16754
Atd Number
ATD-4-6596
Bblid
579651
Inspectionid
389068
Inspect Date
2025-01-02T00:00:00.000
Atdissuedate
2025-01-29T11:16:31.000
Cb
1
House Num
36-12
Onstname
36TH AVE.
Atddismissed
No
18432
Atdid: 18432 • Atd Number: ATD-3-7269 • Bblid: 307421
Atdid
18432
Atd Number
ATD-3-7269
Bblid
307421
Inspectionid
404889
Inspect Date
2025-08-14T00:00:00.000
Atdissuedate
2025-08-27T10:40:45.000
Cb
3
House Num
851
Onstname
GREENE AVE.
Atddismissed
No
11648
Atdid: 11648 • Atd Number: ATD-4-4982 • Bblid: 649387
Atdid
11648
Atd Number
ATD-4-4982
Bblid
649387
Inspectionid
351272
Inspect Date
2023-02-02T00:00:00.000
Atdissuedate
2023-02-09T13:42:30.000
Cb
5
House Num
63-12
Onstname
77TH ST.
Atddismissed
No
13216
Atdid: 13216 • Atd Number: ATD-3-5387 • Bblid: 422649
Atdid
13216
Atd Number
ATD-3-5387
Bblid
422649
Inspectionid
362036
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T15:24:54.000
Cb
12
House Num
1769
Onstname
46TH ST.
Atddismissed
No