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
12253
Atdid: 12253 • Atd Number: ATD-2-1070 • Bblid: 153382
Atdid
12253
Atd Number
ATD-2-1070
Bblid
153382
Inspectionid
357214
Inspect Date
2023-05-17T00:00:00.000
Atdissuedate
2023-05-17T11:45:20.000
Cb
4
House Num
1345
Onstname
JEROME AVE.
Atddismissed
No
14599
Atdid: 14599 • Atd Number: ATD-4-6095 • Bblid: 569061
Atdid
14599
Atd Number
ATD-4-6095
Bblid
569061
Inspectionid
378427
Inspect Date
2024-06-12T00:00:00.000
Atdissuedate
2024-06-17T10:55:39.000
Cb
2
House Num
39-48
Onstname
47TH ST.
Atddismissed
No
9088
Atdid: 9088 • Atd Number: ATD-4-4137 • Bblid: 622535
Atdid
9088
Atd Number
ATD-4-4137
Bblid
622535
Inspectionid
332637
Inspect Date
2019-06-01T00:00:00.000
Atdissuedate
2022-02-22T09:39:09.000
Cb
4
House Num
96-12
Onstname
50TH AVE.
Atddismissed
No
10849
Atdid: 10849 • Atd Number: ATD-3-4220 • Bblid: 299815
Atdid
10849
Atd Number
ATD-3-4220
Bblid
299815
Inspectionid
343376
Inspect Date
2022-09-07T00:00:00.000
Atdissuedate
2022-09-12T10:20:06.000
Cb
16
House Num
286
Onstname
SARATOGA AVE.
Atddismissed
No
12375
Atdid: 12375 • Atd Number: ATD-4-5241 • Bblid: 634487
Atdid
12375
Atd Number
ATD-4-5241
Bblid
634487
Inspectionid
357532
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:38:43.000
Cb
2
House Num
70-32
Onstname
47 AVENUE
Atddismissed
No
11878
Atdid: 11878 • Atd Number: ATD-3-4851 • Bblid: 287500
Atdid
11878
Atd Number
ATD-3-4851
Bblid
287500
Inspectionid
353655
Inspect Date
2023-03-22T00:00:00.000
Atdissuedate
2023-03-22T12:41:56.000
Cb
8
House Num
370
Onstname
PARK PL.
Atddismissed
No
11273
Atdid: 11273 • Atd Number: ATD-3-4578 • Bblid: 469098
Atdid
11273
Atd Number
ATD-3-4578
Bblid
469098
Inspectionid
347001
Inspect Date
2022-10-14T00:00:00.000
Atdissuedate
2022-10-26T13:24:28.000
Cb
11
House Num
251
Onstname
BAY 11TH ST.
Atddismissed
No
18334
Atdid: 18334 • Atd Number: ATD-2-1446 • Bblid: 140152
Atdid
18334
Atd Number
ATD-2-1446
Bblid
140152
Inspectionid
404315
Inspect Date
2025-08-15T00:00:00.000
Atdissuedate
2025-08-15T16:24:41.000
Cb
1
House Num
415
Onstname
E. 147TH ST.
Atddismissed
No
13392
Atdid: 13392 • Atd Number: ATD-5-817 • Bblid: 947644
Atdid
13392
Atd Number
ATD-5-817
Bblid
947644
Inspectionid
363370
Inspect Date
2023-09-09T00:00:00.000
Atdissuedate
2023-09-11T17:52:46.000
Cb
2
House Num
168
Onstname
ARDMORE AVE.
Atddismissed
No
13091
Atdid: 13091 • Atd Number: ATD-5-781 • Bblid: 1123662
Atdid
13091
Atd Number
ATD-5-781
Bblid
1123662
Inspectionid
361303
Inspect Date
2023-07-22T00:00:00.000
Atdissuedate
2023-08-02T11:47:43.000
Cb
0
House Num
135
Onstname
PLATT ST.
Atddismissed
No
11119
Atdid: 11119 • Atd Number: ATD-3-4455 • Bblid: 451376
Atdid
11119
Atd Number
ATD-3-4455
Bblid
451376
Inspectionid
345421
Inspect Date
2022-10-05T00:00:00.000
Atdissuedate
2022-10-11T09:31:24.000
Cb
10
House Num
319
Onstname
88TH ST.
Atddismissed
No
10664
Atdid: 10664 • Atd Number: ATD-3-4062 • Bblid: 251266
Atdid
10664
Atd Number
ATD-3-4062
Bblid
251266
Inspectionid
341730
Inspect Date
2022-08-13T00:00:00.000
Atdissuedate
2022-08-20T11:57:35.000
Cb
2
House Num
102
Onstname
DEAN ST.
Atddismissed
No
12862
Atdid: 12862 • Atd Number: ATD-3-5166 • Bblid: 510057
Atdid
12862
Atd Number
ATD-3-5166
Bblid
510057
Inspectionid
360061
Inspect Date
2023-07-15T00:00:00.000
Atdissuedate
2023-07-15T15:08:02.000
Cb
15
House Num
2434
Onstname
E. 26TH ST.
Atddismissed
No
11874
Atdid: 11874 • Atd Number: ATD-3-4847 • Bblid: 287506
Atdid
11874
Atd Number
ATD-3-4847
Bblid
287506
Inspectionid
353647
Inspect Date
2023-03-22T00:00:00.000
Atdissuedate
2023-03-22T12:40:10.000
Cb
8
House Num
382
Onstname
PARK PL.
Atddismissed
No
13995
Atdid: 13995 • Atd Number: ATD-4-5825 • Bblid: 886807
Atdid
13995
Atd Number
ATD-4-5825
Bblid
886807
Inspectionid
371982
Inspect Date
2024-02-10T00:00:00.000
Atdissuedate
2024-02-20T15:58:14.000
Cb
13
House Num
227-11
Onstname
135 AVENUE
Atddismissed
Yes
Atddismissedon
2024-11-06T15:42:30.000
3728
Atdid: 3728 • Atd Number: ATD-4-399 • Bblid: 643557
Atdid
3728
Atd Number
ATD-4-399
Bblid
643557
Violationid
105719
Atdissuedate
2020-08-18T00:00:00.000
Cb
5
House Num
5946
Onstname
69 LANE
Atddismissed
Yes
Atddismissedon
2025-03-17T11:01:33.000
13997
Atdid: 13997 • Atd Number: ATD-4-5827 • Bblid: 647560
Atdid
13997
Atd Number
ATD-4-5827
Bblid
647560
Inspectionid
372024
Inspect Date
2024-02-01T00:00:00.000
Atdissuedate
2024-02-21T15:15:27.000
Cb
5
House Num
61-44
Onstname
76TH ST.
Atddismissed
Yes
Atddismissedon
2025-05-15T09:48:06.000
13568
Atdid: 13568 • Atd Number: ATD-3-5584 • Bblid: 418505
Atdid
13568
Atd Number
ATD-3-5584
Bblid
418505
Inspectionid
365132
Inspect Date
2023-10-06T00:00:00.000
Atdissuedate
2023-10-10T16:15:53.000
Cb
12
House Num
1465
Onstname
40TH ST.
Atddismissed
No
13386
Atdid: 13386 • Atd Number: ATD-3-5508 • Bblid: 406193
Atdid
13386
Atd Number
ATD-3-5508
Bblid
406193
Inspectionid
363305
Inspect Date
2023-08-31T00:00:00.000
Atdissuedate
2023-09-11T14:11:16.000
Cb
17
House Num
778
Onstname
E. 37TH ST.
Atddismissed
No
10310
Atdid: 10310 • Atd Number: ATD-4-4669 • Bblid: 802110
Atdid
10310
Atd Number
ATD-4-4669
Bblid
802110
Inspectionid
337805
Inspect Date
2022-06-16T00:00:00.000
Atdissuedate
2022-06-17T11:00:47.000
Cb
10
House Num
107-46
Onstname
121ST ST.
Atddismissed
No
12754
Atdid: 12754 • Atd Number: ATD-5-758 • Bblid: 1007831
Atdid
12754
Atd Number
ATD-5-758
Bblid
1007831
Inspectionid
359456
Inspect Date
2023-07-05T00:00:00.000
Atdissuedate
2023-07-05T12:54:23.000
Cb
3
House Num
69
Onstname
ILYSE CT.
Atddismissed
No
12819
Atdid: 12819 • Atd Number: ATD-3-5150 • Bblid: 308287
Atdid
12819
Atd Number
ATD-3-5150
Bblid
308287
Inspectionid
359850
Inspect Date
2023-07-11T00:00:00.000
Atdissuedate
2023-07-12T09:28:48.000
Cb
3
House Num
675
Onstname
MONROE ST.
Atddismissed
No
11283
Atdid: 11283 • Atd Number: ATD-4-4864 • Bblid: 672785
Atdid
11283
Atd Number
ATD-4-4864
Bblid
672785
Inspectionid
347069
Inspect Date
2022-10-19T00:00:00.000
Atdissuedate
2022-10-27T10:37:47.000
Cb
5
House Num
71-49
Onstname
70TH ST.
Atddismissed
No
17285
Atdid: 17285 • Atd Number: ATD-3-6836 • Bblid: 397071
Atdid
17285
Atd Number
ATD-3-6836
Bblid
397071
Inspectionid
393497
Inspect Date
2025-02-07T00:00:00.000
Atdissuedate
2025-04-07T12:54:46.000
Cb
17
House Num
549
Onstname
E. 53RD ST.
Atddismissed
No
18341
Atdid: 18341 • Atd Number: ATD-4-7250 • Bblid: 855415
Atdid
18341
Atd Number
ATD-4-7250
Bblid
855415
Inspectionid
404353
Inspect Date
2025-07-25T00:00:00.000
Atdissuedate
2025-08-18T10:10:45.000
Cb
10
House Num
116-32
Onstname
121ST ST.
Atddismissed
No
8819
Atdid: 8819 • Atd Number: ATD-4-3984 • Bblid: 773585
Atdid
8819
Atd Number
ATD-4-3984
Bblid
773585
Inspectionid
331564
Inspect Date
2017-09-08T00:00:00.000
Atdissuedate
2022-01-11T09:10:13.000
Cb
13
House Num
81-03
Onstname
258TH ST.
Atddismissed
No
13134
Atdid: 13134 • Atd Number: ATD-4-5488 • Bblid: 711458
Atdid
13134
Atd Number
ATD-4-5488
Bblid
711458
Inspectionid
361481
Inspect Date
2023-05-26T00:00:00.000
Atdissuedate
2023-08-03T12:55:34.000
Cb
7
House Num
40-21
Onstname
172ND ST.
Atddismissed
No
17247
Atdid: 17247 • Atd Number: ATD-4-6730 • Bblid: 709701
Atdid
17247
Atd Number
ATD-4-6730
Bblid
709701
Inspectionid
393163
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-04T10:56:00.000
Cb
7
House Num
33-23
Onstname
172ND ST.
Atddismissed
No
17338
Atdid: 17338 • Atd Number: ATD-3-6869 • Bblid: 278695
Atdid
17338
Atd Number
ATD-3-6869
Bblid
278695
Inspectionid
394475
Inspect Date
2025-04-05T00:00:00.000
Atdissuedate
2025-04-14T08:58:46.000
Cb
6
House Num
430
Onstname
7TH ST.
Atddismissed
No
8552
Atdid: 8552 • Atd Number: ATD-2-842 • Bblid: 217708
Atdid
8552
Atd Number
ATD-2-842
Bblid
217708
Inspectionid
330356
Inspect Date
2021-10-08T00:00:00.000
Atdissuedate
2021-12-07T13:34:09.000
Cb
12
House Num
1958
Onstname
BURKE AVE.
Atddismissed
No
14809
Atdid: 14809 • Atd Number: ATD-3-6149 • Bblid: 458209
Atdid
14809
Atd Number
ATD-3-6149
Bblid
458209
Inspectionid
379878
Inspect Date
2024-07-25T00:00:00.000
Atdissuedate
2024-07-27T10:07:36.000
Cb
11
House Num
1555
Onstname
BAY RIDGE PKWY.
Atddismissed
No
8649
Atdid: 8649 • Atd Number: ATD-3-3173 • Bblid: 283712
Atdid
8649
Atd Number
ATD-3-3173
Bblid
283712
Inspectionid
330787
Inspect Date
2019-04-27T00:00:00.000
Atdissuedate
2021-12-15T16:33:15.000
Cb
6
House Num
688
Onstname
10TH ST.
Atddismissed
No
10257
Atdid: 10257 • Atd Number: ATD-3-3824 • Bblid: 421295
Atdid
10257
Atd Number
ATD-3-3824
Bblid
421295
Inspectionid
337483
Inspect Date
2022-06-08T00:00:00.000
Atdissuedate
2022-06-08T13:08:35.000
Cb
12
House Num
622
Onstname
E. 8TH ST.
Atddismissed
No
16694
Atdid: 16694 • Atd Number: ATD-3-6546 • Bblid: 282901
Atdid
16694
Atd Number
ATD-3-6546
Bblid
282901
Inspectionid
388663
Inspect Date
2025-01-10T00:00:00.000
Atdissuedate
2025-01-10T12:20:05.000
Cb
6
House Num
481
Onstname
8TH ST.
Atddismissed
No
10173
Atdid: 10173 • Atd Number: ATD-3-3782 • Bblid: 358553
Atdid
10173
Atd Number
ATD-3-3782
Bblid
358553
Inspectionid
337014
Inspect Date
2022-05-26T00:00:00.000
Atdissuedate
2022-05-26T11:33:00.000
Cb
4
House Num
1283
Onstname
MADISON ST.
Atddismissed
No
12010
Atdid: 12010 • Atd Number: ATD-3-4909 • Bblid: 361363
Atdid
12010
Atd Number
ATD-3-4909
Bblid
361363
Inspectionid
354732
Inspect Date
2023-04-11T00:00:00.000
Atdissuedate
2023-04-11T13:11:43.000
Cb
4
House Num
255
Onstname
COVERT ST.
Atddismissed
No
12485
Atdid: 12485 • Atd Number: ATD-2-1133 • Bblid: 225443
Atdid
12485
Atd Number
ATD-2-1133
Bblid
225443
Inspectionid
358024
Inspect Date
2023-05-18T00:00:00.000
Atdissuedate
2023-06-02T14:48:59.000
Cb
12
House Num
4242
Onstname
ELY AVE.
Atddismissed
No
16749
Atdid: 16749 • Atd Number: ATD-4-6591 • Bblid: 788803
Atdid
16749
Atd Number
ATD-4-6591
Bblid
788803
Inspectionid
389050
Inspect Date
2025-01-09T00:00:00.000
Atdissuedate
2025-01-29T11:02:23.000
Cb
9
House Num
84-08
Onstname
124TH ST.
Atddismissed
No
11414
Atdid: 11414 • Atd Number: ATD-1-246 • Bblid: 119372
Atdid
11414
Atd Number
ATD-1-246
Bblid
119372
Inspectionid
348384
Inspect Date
2022-11-03T00:00:00.000
Atdissuedate
2022-11-18T13:42:24.000
Cb
11
House Num
306
Onstname
E. 120TH ST.
Atddismissed
No
11375
Atdid: 11375 • Atd Number: ATD-4-4877 • Bblid: 596675
Atdid
11375
Atd Number
ATD-4-4877
Bblid
596675
Inspectionid
347977
Inspect Date
2022-11-02T00:00:00.000
Atdissuedate
2022-11-10T14:01:11.000
Cb
3
House Num
30-36
Onstname
79TH ST.
Atddismissed
No
14374
Atdid: 14374 • Atd Number: ATD-3-5931 • Bblid: 488543
Atdid
14374
Atd Number
ATD-3-5931
Bblid
488543
Inspectionid
376287
Inspect Date
2024-04-17T00:00:00.000
Atdissuedate
2024-04-29T11:05:24.000
Cb
11
House Num
8836
Onstname
24TH AVE.
Atddismissed
No
15029
Atdid: 15029 • Atd Number: ATD-3-6265 • Bblid: 535034
Atdid
15029
Atd Number
ATD-3-6265
Bblid
535034
Inspectionid
381656
Inspect Date
2024-08-16T00:00:00.000
Atdissuedate
2024-09-09T16:13:41.000
Cb
18
House Num
1163
Onstname
E. 84TH ST.
Atddismissed
No
16618
Atdid: 16618 • Atd Number: ATD-1-348 • Bblid: 106016
Atdid
16618
Atd Number
ATD-1-348
Bblid
106016
Inspectionid
387280
Inspect Date
2024-12-20T00:00:00.000
Atdissuedate
2024-12-30T09:56:08.000
Cb
8
House Num
133
Onstname
E. 91ST ST.
Atddismissed
No
7258
Atdid: 7258 • Atd Number: ATD-2-728 • Bblid: 224508
Atdid
7258
Atd Number
ATD-2-728
Bblid
224508
Inspectionid
136312
Inspect Date
2011-09-10T00:00:00.000
Atdissuedate
2011-09-10T00:00:00.000
Cb
12
House Num
622
Onstname
E. 235TH ST.
Atddismissed
Yes
Atddismissedon
2022-05-24T09:00:51.000
17290
Atdid: 17290 • Atd Number: ATD-4-6749 • Bblid: 790017
Atdid
17290
Atd Number
ATD-4-6749
Bblid
790017
Inspectionid
393739
Inspect Date
2025-04-07T00:00:00.000
Atdissuedate
2025-04-09T15:01:24.000
Cb
9
House Num
123-19
Onstname
HILLSIDE AVE.
Atddismissed
No
10500
Atdid: 10500 • Atd Number: ATD-3-3969 • Bblid: 546515
Atdid
10500
Atd Number
ATD-3-3969
Bblid
546515
Inspectionid
339975
Inspect Date
2022-07-18T00:00:00.000
Atdissuedate
2022-07-18T11:43:57.000
Cb
18
House Num
6623
Onstname
AVENUE M.
Atddismissed
No
15072
Atdid: 15072 • Atd Number: ATD-4-6282 • Bblid: 747120
Atdid
15072
Atd Number
ATD-4-6282
Bblid
747120
Inspectionid
382072
Inspect Date
2024-08-15T00:00:00.000
Atdissuedate
2024-09-23T11:15:38.000
Cb
8
House Num
69-41
Onstname
179TH ST.
Atddismissed
No
13553
Atdid: 13553 • Atd Number: ATD-3-5571 • Bblid: 423137
Atdid
13553
Atd Number
ATD-3-5571
Bblid
423137
Inspectionid
365048
Inspect Date
2023-10-04T00:00:00.000
Atdissuedate
2023-10-10T11:24:50.000
Cb
12
House Num
1729
Onstname
49TH ST.
Atddismissed
No
16971
Atdid: 16971 • Atd Number: ATD-4-6669 • Bblid: 770757
Atdid
16971
Atd Number
ATD-4-6669
Bblid
770757
Inspectionid
391650
Inspect Date
2025-03-14T00:00:00.000
Atdissuedate
2025-03-19T10:34:17.000
Cb
13
House Num
84-29
Onstname
250TH ST.
Atddismissed
No
14688
Atdid: 14688 • Atd Number: ATD-3-6102 • Bblid: 462952
Atdid
14688
Atd Number
ATD-3-6102
Bblid
462952
Inspectionid
378997
Inspect Date
2024-07-02T00:00:00.000
Atdissuedate
2024-07-02T13:19:50.000
Cb
11
House Num
1461
Onstname
83RD ST.
Atddismissed
No