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
16520
Atdid: 16520 • Atd Number: ATD-3-6459 • Bblid: 282525
Atdid
16520
Atd Number
ATD-3-6459
Bblid
282525
Inspectionid
386328
Inspect Date
2024-12-13T00:00:00.000
Atdissuedate
2024-12-16T13:34:31.000
Cb
6
House Num
607
Onstname
2ND ST.
Atddismissed
No
10826
Atdid: 10826 • Atd Number: ATD-3-4197 • Bblid: 309147
Atdid
10826
Atd Number
ATD-3-4197
Bblid
309147
Inspectionid
343324
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-09-12T09:53:07.000
Cb
3
House Num
533A
Onstname
HANCOCK ST.
Atddismissed
No
18392
Atdid: 18392 • Atd Number: ATD-1-393 • Bblid: 115310
Atdid
18392
Atd Number
ATD-1-393
Bblid
115310
Inspectionid
404610
Inspect Date
2025-02-21T00:00:00.000
Atdissuedate
2025-08-21T13:34:23.000
Cb
11
House Num
242
Onstname
E. 112TH ST.
Atddismissed
No
12816
Atdid: 12816 • Atd Number: ATD-2-1184 • Bblid: 196706
Atdid
12816
Atd Number
ATD-2-1184
Bblid
196706
Inspectionid
359822
Inspect Date
2023-07-10T00:00:00.000
Atdissuedate
2023-07-11T12:36:58.000
Cb
11
House Num
1562
Onstname
BOGART AVE.
Atddismissed
No
10340
Atdid: 10340 • Atd Number: ATD-4-4689 • Bblid: 785512
Atdid
10340
Atd Number
ATD-4-4689
Bblid
785512
Inspectionid
338334
Inspect Date
2022-06-30T00:00:00.000
Atdissuedate
2022-06-30T09:41:08.000
Cb
10
House Num
103-24
Onstname
92ND ST.
Atddismissed
No
9706
Atdid: 9706 • Atd Number: ATD-4-4390 • Bblid: 749696
Atdid
9706
Atd Number
ATD-4-4390
Bblid
749696
Inspectionid
334119
Inspect Date
2021-05-21T00:00:00.000
Atdissuedate
2022-03-24T16:45:26.000
Cb
8
House Num
81-34
Onstname
KENT ST.
Atddismissed
No
9285
Atdid: 9285 • Atd Number: ATD-2-886 • Bblid: 232915
Atdid
9285
Atd Number
ATD-2-886
Bblid
232915
Inspectionid
332991
Inspect Date
2021-08-09T00:00:00.000
Atdissuedate
2022-03-02T08:20:11.000
Cb
10
House Num
3152
Onstname
PARSIFAL PL.
Atddismissed
No
14971
Atdid: 14971 • Atd Number: ATD-4-6250 • Bblid: 896303
Atdid
14971
Atd Number
ATD-4-6250
Bblid
896303
Inspectionid
381095
Inspect Date
2019-07-18T00:00:00.000
Atdissuedate
2024-08-27T11:44:53.000
Cb
13
House Num
147-60
Onstname
253RD ST.
Atddismissed
No
12079
Atdid: 12079 • Atd Number: ATD-4-5146 • Bblid: 860525
Atdid
12079
Atd Number
ATD-4-5146
Bblid
860525
Inspectionid
356103
Inspect Date
2023-04-07T00:00:00.000
Atdissuedate
2023-04-24T08:25:24.000
Cb
12
House Num
108-15
Onstname
LIVERPOOL ST.
Atddismissed
No
17105
Atdid: 17105 • Atd Number: ATD-3-6751 • Bblid: 536050
Atdid
17105
Atd Number
ATD-3-6751
Bblid
536050
Inspectionid
392502
Inspect Date
2022-06-29T00:00:00.000
Atdissuedate
2025-03-28T12:20:46.000
Cb
18
House Num
27
Onstname
PAERDEGAT 11 STREET
Atddismissed
No
17396
Atdid: 17396 • Atd Number: ATD-4-6782 • Bblid: 656637
Atdid
17396
Atd Number
ATD-4-6782
Bblid
656637
Inspectionid
394951
Inspect Date
2025-04-15T00:00:00.000
Atdissuedate
2025-04-21T08:30:03.000
Cb
6
House Num
67-04
Onstname
SELFRIDGE ST.
Atddismissed
No
13100
Atdid: 13100 • Atd Number: ATD-5-787 • Bblid: 1008144
Atdid
13100
Atd Number
ATD-5-787
Bblid
1008144
Inspectionid
361356
Inspect Date
2023-07-15T00:00:00.000
Atdissuedate
2023-08-02T17:29:50.000
Cb
3
House Num
40
Onstname
BLYTHE PL.
Atddismissed
No
9439
Atdid: 9439 • Atd Number: ATD-3-3502 • Bblid: 551360
Atdid
9439
Atd Number
ATD-3-3502
Bblid
551360
Inspectionid
333273
Inspect Date
2020-12-08T00:00:00.000
Atdissuedate
2022-03-04T16:55:35.000
Cb
18
House Num
1776
Onstname
E. 53RD ST.
Atddismissed
No
13494
Atdid: 13494 • Atd Number: ATD-3-5558 • Bblid: 443939
Atdid
13494
Atd Number
ATD-3-5558
Bblid
443939
Inspectionid
364485
Inspect Date
2023-06-21T00:00:00.000
Atdissuedate
2023-09-27T12:40:36.000
Cb
10
House Num
234
Onstname
OVINGTON AVE.
Atddismissed
No
8650
Atdid: 8650 • Atd Number: ATD-3-3174 • Bblid: 473993
Atdid
8650
Atd Number
ATD-3-3174
Bblid
473993
Inspectionid
330795
Inspect Date
2021-07-14T00:00:00.000
Atdissuedate
2021-12-16T08:48:06.000
Cb
12
House Num
1510
Onstname
E. 7TH ST.
Atddismissed
No
14663
Atdid: 14663 • Atd Number: ATD-4-6113 • Bblid: 738400
Atdid
14663
Atd Number
ATD-4-6113
Bblid
738400
Inspectionid
378882
Inspect Date
2024-05-23T00:00:00.000
Atdissuedate
2024-06-27T14:11:12.000
Cb
8
House Num
150-36
Onstname
GRAND CENTRAL PKWY.
Atddismissed
No
14664
Atdid: 14664 • Atd Number: ATD-4-6114 • Bblid: 738394
Atdid
14664
Atd Number
ATD-4-6114
Bblid
738394
Inspectionid
378885
Inspect Date
2024-05-23T00:00:00.000
Atdissuedate
2024-06-27T14:12:14.000
Cb
8
House Num
150-28
Onstname
GRAND CENTRAL PKWY.
Atddismissed
No
14488
Atdid: 14488 • Atd Number: ATD-2-1276 • Bblid: 164554
Atdid
14488
Atd Number
ATD-2-1276
Bblid
164554
Inspectionid
377460
Inspect Date
2024-05-04T00:00:00.000
Atdissuedate
2024-05-20T09:51:07.000
Cb
8
House Num
2736
Onstname
KINGSBRIDGE TER.
Atddismissed
No
16972
Atdid: 16972 • Atd Number: ATD-4-6670 • Bblid: 770598
Atdid
16972
Atd Number
ATD-4-6670
Bblid
770598
Inspectionid
391651
Inspect Date
2025-03-14T00:00:00.000
Atdissuedate
2025-03-19T10:56:54.000
Cb
13
House Num
253-11
Onstname
84TH DR.
Atddismissed
No
14065
Atdid: 14065 • Atd Number: ATD-4-5868 • Bblid: 743273
Atdid
14065
Atd Number
ATD-4-5868
Bblid
743273
Violationid
289958
Reinspectionid
36259
Inspect Date
2024-03-05T11:29:36.000
Atdissuedate
2024-03-05T11:29:36.000
Cb
8
House Num
173-09
Onstname
JEWEL AVENUE
Atddismissed
No
10027
Atdid: 10027 • Atd Number: ATD-3-3676 • Bblid: 554938
Atdid
10027
Atd Number
ATD-3-3676
Bblid
554938
Inspectionid
336009
Inspect Date
2022-04-27T00:00:00.000
Atdissuedate
2022-05-03T11:21:12.000
Cb
18
House Num
2727
Onstname
WHITMAN DR.
Atddismissed
No
18225
Atdid: 18225 • Atd Number: ATD-3-7189 • Bblid: 379462
Atdid
18225
Atd Number
ATD-3-7189
Bblid
379462
Inspectionid
403489
Inspect Date
2025-07-17T00:00:00.000
Atdissuedate
2025-08-04T09:42:11.000
Cb
5
House Num
95
Onstname
RICHMOND ST.
Atddismissed
No
17928
Atdid: 17928 • Atd Number: ATD-5-989 • Bblid: 1028636
Atdid
17928
Atd Number
ATD-5-989
Bblid
1028636
Inspectionid
400652
Inspect Date
2025-04-09T00:00:00.000
Atdissuedate
2025-06-20T12:17:12.000
Cb
3
House Num
14
Onstname
LUDLOW ST.
Atddismissed
No
17134
Atdid: 17134 • Atd Number: ATD-3-6775 • Bblid: 298147
Atdid
17134
Atd Number
ATD-3-6775
Bblid
298147
Inspectionid
392585
Inspect Date
2025-03-25T00:00:00.000
Atdissuedate
2025-03-31T08:35:36.000
Cb
9
House Num
1563
Onstname
UNION ST.
Atddismissed
No
14078
Atdid: 14078 • Atd Number: ATD-3-5772 • Bblid: 548428
Atdid
14078
Atd Number
ATD-3-5772
Bblid
548428
Violationid
289593
Reinspectionid
36156
Inspect Date
2024-03-07T11:25:58.000
Atdissuedate
2024-03-07T11:25:58.000
Cb
18
House Num
2061
Onstname
PEARSON STREET
Atddismissed
No
16736
Atdid: 16736 • Atd Number: ATD-3-6563 • Bblid: 277665
Atdid
16736
Atd Number
ATD-3-6563
Bblid
277665
Inspectionid
388933
Inspect Date
2025-01-04T00:00:00.000
Atdissuedate
2025-01-24T11:05:39.000
Cb
6
House Num
342
Onstname
4TH ST.
Atddismissed
No
11618
Atdid: 11618 • Atd Number: ATD-4-4973 • Bblid: 647097
Atdid
11618
Atd Number
ATD-4-4973
Bblid
647097
Inspectionid
350688
Inspect Date
2023-01-17T00:00:00.000
Atdissuedate
2023-01-23T15:01:59.000
Cb
5
House Num
61-66
Onstname
69TH LN.
Atddismissed
No
17481
Atdid: 17481 • Atd Number: ATD-3-6932 • Bblid: 553452
Atdid
17481
Atd Number
ATD-3-6932
Bblid
553452
Inspectionid
395610
Inspect Date
2025-04-24T00:00:00.000
Atdissuedate
2025-04-29T15:24:14.000
Cb
18
House Num
2140
Onstname
E. 34TH ST.
Atddismissed
No
11761
Atdid: 11761 • Atd Number: ATD-3-4786 • Bblid: 285542
Atdid
11761
Atd Number
ATD-3-4786
Bblid
285542
Inspectionid
352605
Inspect Date
2023-03-10T00:00:00.000
Atdissuedate
2023-03-10T11:23:02.000
Cb
8
House Num
930
Onstname
PACIFIC ST.
Atddismissed
No
12335
Atdid: 12335 • Atd Number: ATD-4-5201 • Bblid: 569171
Atdid
12335
Atd Number
ATD-4-5201
Bblid
569171
Inspectionid
357428
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T16:00:25.000
Cb
2
House Num
47-24
Onstname
GREENPOINT AVENUE
Atddismissed
No
10488
Atdid: 10488 • Atd Number: ATD-3-3957 • Bblid: 462039
Atdid
10488
Atd Number
ATD-3-3957
Bblid
462039
Inspectionid
339832
Inspect Date
2022-07-15T00:00:00.000
Atdissuedate
2022-07-15T14:06:31.000
Cb
10
House Num
1315
Onstname
81ST ST.
Atddismissed
No
16371
Atdid: 16371 • Atd Number: ATD-4-6431 • Bblid: 678519
Atdid
16371
Atd Number
ATD-4-6431
Bblid
678519
Inspectionid
385032
Inspect Date
2024-10-31T00:00:00.000
Atdissuedate
2024-11-14T13:05:18.000
Cb
6
House Num
89-03
Onstname
70TH AVE.
Atddismissed
No
11227
Atdid: 11227 • Atd Number: ATD-3-4533 • Bblid: 544518
Atdid
11227
Atd Number
ATD-3-4533
Bblid
544518
Inspectionid
346679
Inspect Date
2022-10-14T00:00:00.000
Atdissuedate
2022-10-21T15:31:21.000
Cb
18
House Num
1633
Onstname
E. 94TH ST.
Atddismissed
No
13115
Atdid: 13115 • Atd Number: ATD-3-5328 • Bblid: 422742
Atdid
13115
Atd Number
ATD-3-5328
Bblid
422742
Inspectionid
361425
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T12:03:57.000
Cb
12
House Num
1524
Onstname
46TH ST.
Atddismissed
No
13287
Atdid: 13287 • Atd Number: ATD-3-5447 • Bblid: 483259
Atdid
13287
Atd Number
ATD-3-5447
Bblid
483259
Inspectionid
362361
Inspect Date
2023-08-08T00:00:00.000
Atdissuedate
2023-08-22T11:38:02.000
Cb
14
House Num
1524
Onstname
E. 23RD ST.
Atddismissed
No
11416
Atdid: 11416 • Atd Number: ATD-1-248 • Bblid: 119369
Atdid
11416
Atd Number
ATD-1-248
Bblid
119369
Inspectionid
348386
Inspect Date
2022-11-03T00:00:00.000
Atdissuedate
2022-11-18T13:43:13.000
Cb
11
House Num
314
Onstname
E. 120TH ST.
Atddismissed
No
8866
Atdid: 8866 • Atd Number: ATD-4-4009 • Bblid: 597071
Atdid
8866
Atd Number
ATD-4-4009
Bblid
597071
Inspectionid
331831
Inspect Date
2022-01-13T00:00:00.000
Atdissuedate
2022-01-24T12:10:27.000
Cb
3
House Num
31-15
Onstname
73RD ST.
Atddismissed
No
12115
Atdid: 12115 • Atd Number: ATD-3-4969 • Bblid: 328362
Atdid
12115
Atd Number
ATD-3-4969
Bblid
328362
Inspectionid
356394
Inspect Date
2023-04-27T00:00:00.000
Atdissuedate
2023-04-27T15:27:20.000
Cb
2
House Num
231
Onstname
ASHLAND PL.
Atddismissed
Yes
Atddismissedon
2024-03-06T17:13:11.000
13928
Atdid: 13928 • Atd Number: ATD-2-1257 • Bblid: 219468
Atdid
13928
Atd Number
ATD-2-1257
Bblid
219468
Inspectionid
371371
Inspect Date
2023-04-06T00:00:00.000
Atdissuedate
2024-02-07T17:48:58.000
Cb
12
House Num
853
Onstname
E. 227TH ST.
Atddismissed
No
8764
Atdid: 8764 • Atd Number: ATD-3-3214 • Bblid: 264598
Atdid
8764
Atd Number
ATD-3-3214
Bblid
264598
Inspectionid
331142
Inspect Date
2021-12-22T00:00:00.000
Atdissuedate
2021-12-28T15:10:32.000
Cb
7
House Num
461
Onstname
41ST ST.
Atddismissed
No
10093
Atdid: 10093 • Atd Number: ATD-3-3712 • Bblid: 472311
Atdid
10093
Atd Number
ATD-3-3712
Bblid
472311
Inspectionid
336453
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-16T10:48:37.000
Cb
11
House Num
2326
Onstname
62ND ST.
Atddismissed
No
12684
Atdid: 12684 • Atd Number: ATD-5-720 • Bblid: 1022227
Atdid
12684
Atd Number
ATD-5-720
Bblid
1022227
Inspectionid
359084
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-29T12:19:48.000
Cb
3
House Num
402
Onstname
BROOKFIELD AVE.
Atddismissed
No
11032
Atdid: 11032 • Atd Number: ATD-3-4382 • Bblid: 515570
Atdid
11032
Atd Number
ATD-3-4382
Bblid
515570
Inspectionid
344665
Inspect Date
2022-09-28T00:00:00.000
Atdissuedate
2022-09-28T09:23:58.000
Cb
18
House Num
3409
Onstname
AVENUE K.
Atddismissed
No
13534
Atdid: 13534 • Atd Number: ATD-4-5573 • Bblid: 761619
Atdid
13534
Atd Number
ATD-4-5573
Bblid
761619
Inspectionid
364845
Inspect Date
2023-09-22T00:00:00.000
Atdissuedate
2023-10-03T15:35:56.000
Cb
13
House Num
88-40
Onstname
240TH ST.
Atddismissed
No
9133
Atdid: 9133 • Atd Number: ATD-3-3324 • Bblid: 354890
Atdid
9133
Atd Number
ATD-3-3324
Bblid
354890
Inspectionid
332684
Inspect Date
2021-09-08T00:00:00.000
Atdissuedate
2022-02-23T08:42:56.000
Cb
4
House Num
407
Onstname
STANHOPE ST.
Atddismissed
No
8539
Atdid: 8539 • Atd Number: ATD-3-3122 • Bblid: 302807
Atdid
8539
Atd Number
ATD-3-3122
Bblid
302807
Inspectionid
330276
Inspect Date
2021-12-01T00:00:00.000
Atdissuedate
2021-12-06T11:33:50.000
Cb
16
House Num
764
Onstname
DECATUR ST.
Atddismissed
No
8845
Atdid: 8845 • Atd Number: ATD-4-3996 • Bblid: 886407
Atdid
8845
Atd Number
ATD-4-3996
Bblid
886407
Inspectionid
331762
Inspect Date
2021-12-08T00:00:00.000
Atdissuedate
2022-01-19T15:51:20.000
Cb
12
House Num
182-15
Onstname
144TH AVE.
Atddismissed
No
9242
Atdid: 9242 • Atd Number: ATD-3-3376 • Bblid: 469452
Atdid
9242
Atd Number
ATD-3-3376
Bblid
469452
Inspectionid
332948
Inspect Date
2020-11-27T00:00:00.000
Atdissuedate
2022-03-01T17:21:40.000
Cb
11
House Num
8905
Onstname
18TH AVE.
Atddismissed
No
11377
Atdid: 11377 • Atd Number: ATD-4-4879 • Bblid: 596290
Atdid
11377
Atd Number
ATD-4-4879
Bblid
596290
Inspectionid
348022
Inspect Date
2022-11-09T00:00:00.000
Atdissuedate
2022-11-10T14:57:03.000
Cb
3
House Num
30-57
Onstname
70TH ST.
Atddismissed
No
13193
Atdid: 13193 • Atd Number: ATD-3-5372 • Bblid: 422864
Atdid
13193
Atd Number
ATD-3-5372
Bblid
422864
Inspectionid
361832
Inspect Date
2023-08-10T00:00:00.000
Atdissuedate
2023-08-10T10:42:06.000
Cb
12
House Num
1650
Onstname
46TH ST.
Atddismissed
No