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
8755
Atdid: 8755 • Atd Number: ATD-3-3205 • Bblid: 292106
Atdid
8755
Atd Number
ATD-3-3205
Bblid
292106
Inspectionid
331114
Inspect Date
2021-12-23T00:00:00.000
Atdissuedate
2021-12-28T14:55:59.000
Cb
8
House Num
287
Onstname
NEW YORK AVE.
Atddismissed
No
17087
Atdid: 17087 • Atd Number: ATD-3-6738 • Bblid: 308246
Atdid
17087
Atd Number
ATD-3-6738
Bblid
308246
Inspectionid
392460
Inspect Date
2023-07-18T00:00:00.000
Atdissuedate
2025-03-27T15:44:26.000
Cb
3
House Num
731
Onstname
MONROE ST.
Atddismissed
No
10190
Atdid: 10190 • Atd Number: ATD-4-4621 • Bblid: 874409
Atdid
10190
Atd Number
ATD-4-4621
Bblid
874409
Inspectionid
337101
Inspect Date
2022-05-27T00:00:00.000
Atdissuedate
2022-05-31T13:05:20.000
Cb
12
House Num
174-05
Onstname
126TH AVE.
Atddismissed
No
8685
Atdid: 8685 • Atd Number: ATD-4-3908 • Bblid: 875006
Atdid
8685
Atd Number
ATD-4-3908
Bblid
875006
Inspectionid
330854
Inspect Date
2019-07-27T00:00:00.000
Atdissuedate
2021-12-17T10:40:46.000
Cb
12
House Num
134-66
Onstname
BEDELL ST.
Atddismissed
No
12539
Atdid: 12539 • Atd Number: ATD-4-5344 • Bblid: 691345
Atdid
12539
Atd Number
ATD-4-5344
Bblid
691345
Inspectionid
358414
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-06-12T14:36:34.000
Cb
7
House Num
147-46
Onstname
23RD AVE.
Atddismissed
No
14514
Atdid: 14514 • Atd Number: ATD-4-6072 • Bblid: 852518
Atdid
14514
Atd Number
ATD-4-6072
Bblid
852518
Inspectionid
377687
Inspect Date
2024-05-09T00:00:00.000
Atdissuedate
2024-05-21T11:49:55.000
Cb
10
House Num
111-23
Onstname
132ND ST.
Atddismissed
No
9900
Atdid: 9900 • Atd Number: ATD-3-3624 • Bblid: 407041
Atdid
9900
Atd Number
ATD-3-3624
Bblid
407041
Inspectionid
335134
Inspect Date
2022-04-14T00:00:00.000
Atdissuedate
2022-04-19T10:03:48.000
Cb
9
House Num
108
Onstname
LINCOLN RD.
Atddismissed
No
16647
Atdid: 16647 • Atd Number: ATD-4-6546 • Bblid: 785660
Atdid
16647
Atd Number
ATD-4-6546
Bblid
785660
Inspectionid
388475
Inspect Date
2024-12-30T00:00:00.000
Atdissuedate
2025-01-03T12:37:23.000
Cb
10
House Num
107-30
Onstname
77TH ST.
Atddismissed
No
11960
Atdid: 11960 • Atd Number: ATD-3-4896 • Bblid: 369132
Atdid
11960
Atd Number
ATD-3-4896
Bblid
369132
Inspectionid
354338
Inspect Date
2023-03-16T00:00:00.000
Atdissuedate
2023-04-03T11:28:30.000
Cb
5
House Num
428
Onstname
VERMONT ST.
Atddismissed
No
8646
Atdid: 8646 • Atd Number: ATD-3-3170 • Bblid: 283690
Atdid
8646
Atd Number
ATD-3-3170
Bblid
283690
Inspectionid
330784
Inspect Date
2019-04-27T00:00:00.000
Atdissuedate
2021-12-15T16:23:16.000
Cb
6
House Num
666
Onstname
10TH ST.
Atddismissed
No
10255
Atdid: 10255 • Atd Number: ATD-4-4644 • Bblid: 845816
Atdid
10255
Atd Number
ATD-4-4644
Bblid
845816
Inspectionid
337464
Inspect Date
2022-06-08T00:00:00.000
Atdissuedate
2022-06-08T11:17:02.000
Cb
10
House Num
132-18
Onstname
87TH ST.
Atddismissed
No
9078
Atdid: 9078 • Atd Number: ATD-4-4128 • Bblid: 600691
Atdid
9078
Atd Number
ATD-4-4128
Bblid
600691
Inspectionid
332622
Inspect Date
2022-01-27T00:00:00.000
Atdissuedate
2022-02-19T19:21:52.000
Cb
3
House Num
33-16
Onstname
76TH ST.
Atddismissed
No
14853
Atdid: 14853 • Atd Number: ATD-3-6173 • Bblid: 320135
Atdid
14853
Atd Number
ATD-3-6173
Bblid
320135
Inspectionid
380130
Inspect Date
2024-08-05T00:00:00.000
Atdissuedate
2024-08-05T11:21:01.000
Cb
3
House Num
26
Onstname
NEW YORK AVE.
Atddismissed
No
9519
Atdid: 9519 • Atd Number: ATD-4-4277 • Bblid: 1100920
Atdid
9519
Atd Number
ATD-4-4277
Bblid
1100920
Inspectionid
333544
Inspect Date
2021-06-05T00:00:00.000
Atdissuedate
2022-03-09T16:31:24.000
Cb
0
House Num
61-34
Onstname
228TH ST.
Atddismissed
No
16168
Atdid: 16168 • Atd Number: ATD-4-6345 • Bblid: 743510
Atdid
16168
Atd Number
ATD-4-6345
Bblid
743510
Inspectionid
383606
Inspect Date
2024-09-12T00:00:00.000
Atdissuedate
2024-10-01T11:25:31.000
Cb
8
House Num
69-28
Onstname
169TH ST.
Atddismissed
No
9404
Atdid: 9404 • Atd Number: ATD-3-3494 • Bblid: 548926
Atdid
9404
Atd Number
ATD-3-3494
Bblid
548926
Inspectionid
333163
Inspect Date
2021-01-06T00:00:00.000
Atdissuedate
2022-03-03T17:31:50.000
Cb
18
House Num
2059
Onstname
E. 68TH ST.
Atddismissed
No
13368
Atdid: 13368 • Atd Number: ATD-3-5499 • Bblid: 290840
Atdid
13368
Atd Number
ATD-3-5499
Bblid
290840
Inspectionid
363191
Inspect Date
2023-09-08T00:00:00.000
Atdissuedate
2023-09-08T15:18:48.000
Cb
8
House Num
15
Onstname
VIRGINIA PL.
Atddismissed
No
13564
Atdid: 13564 • Atd Number: ATD-3-5580 • Bblid: 418525
Atdid
13564
Atd Number
ATD-3-5580
Bblid
418525
Inspectionid
365124
Inspect Date
2023-10-06T00:00:00.000
Atdissuedate
2023-10-10T16:11:42.000
Cb
12
House Num
1431
Onstname
40TH ST.
Atddismissed
No
17422
Atdid: 17422 • Atd Number: ATD-3-6906 • Bblid: 419483
Atdid
17422
Atd Number
ATD-3-6906
Bblid
419483
Inspectionid
395163
Inspect Date
2025-04-22T00:00:00.000
Atdissuedate
2025-04-24T07:36:48.000
Cb
12
House Num
1523
Onstname
39TH ST.
Atddismissed
No
9377
Atdid: 9377 • Atd Number: ATD-3-3474 • Bblid: 318236
Atdid
9377
Atd Number
ATD-3-3474
Bblid
318236
Inspectionid
333102
Inspect Date
2021-05-12T00:00:00.000
Atdissuedate
2022-03-03T08:44:51.000
Cb
3
House Num
397A
Onstname
HANCOCK ST.
Atddismissed
No
12446
Atdid: 12446 • Atd Number: ATD-3-5057 • Bblid: 526189
Atdid
12446
Atd Number
ATD-3-5057
Bblid
526189
Inspectionid
357856
Inspect Date
2023-05-06T00:00:00.000
Atdissuedate
2023-05-30T12:38:54.000
Cb
18
House Num
1135
Onstname
E. 59TH ST.
Atddismissed
No
13856
Atdid: 13856 • Atd Number: ATD-3-5700 • Bblid: 511725
Atdid
13856
Atd Number
ATD-3-5700
Bblid
511725
Inspectionid
370506
Inspect Date
2024-01-05T00:00:00.000
Atdissuedate
2024-01-09T12:22:36.000
Cb
15
House Num
2511
Onstname
E. 29TH ST.
Atddismissed
No
12408
Atdid: 12408 • Atd Number: ATD-3-5049 • Bblid: 481176
Atdid
12408
Atd Number
ATD-3-5049
Bblid
481176
Violationid
250218
Reinspectionid
33707
Inspect Date
2023-05-25T16:41:39.000
Atdissuedate
2023-05-25T16:41:39.000
Cb
14
House Num
1816
Onstname
AVENUE J
Atddismissed
No
17254
Atdid: 17254 • Atd Number: ATD-4-6736 • Bblid: 586207
Atdid
17254
Atd Number
ATD-4-6736
Bblid
586207
Inspectionid
393217
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-04T11:40:50.000
Cb
1
House Num
21-02
Onstname
STEINWAY ST.
Atddismissed
No
11620
Atdid: 11620 • Atd Number: ATD-4-4975 • Bblid: 570941
Atdid
11620
Atd Number
ATD-4-4975
Bblid
570941
Inspectionid
350716
Inspect Date
2023-01-18T00:00:00.000
Atdissuedate
2023-01-24T16:26:26.000
Cb
2
House Num
45-22
Onstname
41ST ST.
Atddismissed
Yes
Atddismissedon
2023-03-10T12:26:39.000
12173
Atdid: 12173 • Atd Number: ATD-2-1027 • Bblid: 144182
Atdid
12173
Atd Number
ATD-2-1027
Bblid
144182
Inspectionid
356807
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2023-05-09T12:12:07.000
Cb
4
Onstname
RIVER AVENUE
Atddismissed
Yes
Atddismissedon
2023-05-09T12:12:22.000
17883
Atdid: 17883 • Atd Number: ATD-4-7070 • Bblid: 768453
Atdid
17883
Atd Number
ATD-4-7070
Bblid
768453
Inspectionid
400299
Inspect Date
2025-06-11T00:00:00.000
Atdissuedate
2025-06-13T09:36:28.000
Cb
11
House Num
259-19
Onstname
57TH AVE.
Atddismissed
Yes
Atddismissedon
2025-08-05T13:19:51.000
14331
Atdid: 14331 • Atd Number: ATD-4-5980 • Bblid: 641040
Atdid
14331
Atd Number
ATD-4-5980
Bblid
641040
Inspectionid
375959
Inspect Date
2024-04-15T00:00:00.000
Atdissuedate
2024-04-23T13:03:17.000
Cb
5
House Num
57-51
Onstname
65TH ST.
Atddismissed
No
9568
Atdid: 9568 • Atd Number: ATD-4-4295 • Bblid: 819392
Atdid
9568
Atd Number
ATD-4-4295
Bblid
819392
Inspectionid
333668
Inspect Date
2022-03-07T00:00:00.000
Atdissuedate
2022-03-11T11:23:59.000
Cb
12
House Num
114-61
Onstname
178TH PL.
Atddismissed
No
167
Atdid: 167 • Atd Number: ATD-2-49 • Bblid: 203338
Atdid
167
Atd Number
ATD-2-49
Bblid
203338
Violationid
203238
Atdissuedate
2019-10-12T00:00:00.000
Cb
11
House Num
2282
Onstname
BRONX PARK EAST
Atddismissed
Yes
Atddismissedon
2025-08-05T12:41:28.000
13031
Atdid: 13031 • Atd Number: ATD-3-5275 • Bblid: 422386
Atdid
13031
Atd Number
ATD-3-5275
Bblid
422386
Inspectionid
361025
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T14:22:09.000
Cb
12
House Num
4502
Onstname
16TH AVE.
Atddismissed
No
16667
Atdid: 16667 • Atd Number: ATD-4-6552 • Bblid: 735862
Atdid
16667
Atd Number
ATD-4-6552
Bblid
735862
Inspectionid
388576
Inspect Date
2024-10-23T00:00:00.000
Atdissuedate
2025-01-08T15:35:57.000
Cb
8
House Num
76-26
Onstname
VLEIGH PL.
Atddismissed
No
12121
Atdid: 12121 • Atd Number: ATD-4-5158 • Bblid: 860878
Atdid
12121
Atd Number
ATD-4-5158
Bblid
860878
Inspectionid
356434
Inspect Date
2023-03-20T00:00:00.000
Atdissuedate
2023-05-01T10:56:25.000
Cb
12
House Num
111-72
Onstname
145TH ST.
Atddismissed
Yes
Atddismissedon
2024-02-29T12:24:06.000
7974
Atdid: 7974 • Atd Number: ATD-1-142 • Bblid: 47221
Atdid
7974
Atd Number
ATD-1-142
Bblid
47221
Inspectionid
316288
Inspect Date
2020-11-27T00:00:00.000
Atdissuedate
2020-11-27T00:00:00.000
Cb
6
House Num
327
Onstname
E. 18TH ST.
Atddismissed
Yes
Atddismissedon
2022-12-28T12:44:10.000
12461
Atdid: 12461 • Atd Number: ATD-4-5293 • Bblid: 813098
Atdid
12461
Atd Number
ATD-4-5293
Bblid
813098
Inspectionid
357964
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T09:34:41.000
Cb
12
House Num
147-11
Onstname
TUSKEGEE AIRMEN WAY
Atddismissed
No
16986
Atdid: 16986 • Atd Number: ATD-3-6662 • Bblid: 449959
Atdid
16986
Atd Number
ATD-3-6662
Bblid
449959
Inspectionid
391946
Inspect Date
2025-03-22T00:00:00.000
Atdissuedate
2025-03-24T10:27:34.000
Cb
10
House Num
8210
Onstname
FORT HAMILTON PKWY.
Atddismissed
No
11949
Atdid: 11949 • Atd Number: ATD-2-1000 • Bblid: 226969
Atdid
11949
Atd Number
ATD-2-1000
Bblid
226969
Inspectionid
354282
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-31T09:10:25.000
Cb
12
House Num
4324
Onstname
ELY AVE.
Atddismissed
No
11626
Atdid: 11626 • Atd Number: ATD-3-4718 • Bblid: 255683
Atdid
11626
Atd Number
ATD-3-4718
Bblid
255683
Inspectionid
350810
Inspect Date
2023-01-24T00:00:00.000
Atdissuedate
2023-01-30T10:11:10.000
Cb
6
House Num
277
Onstname
SACKETT ST.
Atddismissed
No
17203
Atdid: 17203 • Atd Number: ATD-4-6711 • Bblid: 867473
Atdid
17203
Atd Number
ATD-4-6711
Bblid
867473
Inspectionid
392862
Inspect Date
2025-03-12T00:00:00.000
Atdissuedate
2025-04-01T11:55:51.000
Cb
12
House Num
114-39
Onstname
157TH ST.
Atddismissed
No
17159
Atdid: 17159 • Atd Number: ATD-3-6795 • Bblid: 290558
Atdid
17159
Atd Number
ATD-3-6795
Bblid
290558
Inspectionid
392657
Inspect Date
2021-10-22T00:00:00.000
Atdissuedate
2025-03-31T10:33:23.000
Cb
8
House Num
877
Onstname
PARK PL.
Atddismissed
No
17531
Atdid: 17531 • Atd Number: ATD-3-6956 • Bblid: 471377
Atdid
17531
Atd Number
ATD-3-6956
Bblid
471377
Inspectionid
396105
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-05T09:48:10.000
Cb
12
House Num
1241
Onstname
E. 7TH ST.
Atddismissed
No
13008
Atdid: 13008 • Atd Number: ATD-4-5470 • Bblid: 895195
Atdid
13008
Atd Number
ATD-4-5470
Bblid
895195
Violationid
243658
Inspectionid
360865
Inspect Date
2023-07-28T08:19:07.000
Atdissuedate
2023-07-28T08:19:07.000
Cb
13
House Num
258-23
Onstname
147 AVENUE
Atddismissed
No
10264
Atdid: 10264 • Atd Number: ATD-3-3830 • Bblid: 323658
Atdid
10264
Atd Number
ATD-3-3830
Bblid
323658
Inspectionid
337523
Inspect Date
2022-06-08T00:00:00.000
Atdissuedate
2022-06-10T09:24:36.000
Cb
2
House Num
273
Onstname
GREENE AVE.
Atddismissed
No
10205
Atdid: 10205 • Atd Number: ATD-4-4629 • Bblid: 794305
Atdid
10205
Atd Number
ATD-4-4629
Bblid
794305
Inspectionid
337215
Inspect Date
2022-05-24T00:00:00.000
Atdissuedate
2022-06-02T13:47:33.000
Cb
9
House Num
95-30
Onstname
111TH ST.
Atddismissed
No
17308
Atdid: 17308 • Atd Number: ATD-3-6846 • Bblid: 301889
Atdid
17308
Atd Number
ATD-3-6846
Bblid
301889
Inspectionid
394378
Inspect Date
2025-03-28T00:00:00.000
Atdissuedate
2025-04-14T07:34:22.000
Cb
3
House Num
638
Onstname
MACDONOUGH ST.
Atddismissed
No
10926
Atdid: 10926 • Atd Number: ATD-3-4293 • Bblid: 477132
Atdid
10926
Atd Number
ATD-3-4293
Bblid
477132
Inspectionid
343881
Inspect Date
2022-09-15T00:00:00.000
Atdissuedate
2022-09-15T15:06:11.000
Cb
11
House Num
55
Onstname
HIGHLAWN AVE.
Atddismissed
No
11062
Atdid: 11062 • Atd Number: ATD-3-4410 • Bblid: 429557
Atdid
11062
Atd Number
ATD-3-4410
Bblid
429557
Inspectionid
344961
Inspect Date
2022-09-30T00:00:00.000
Atdissuedate
2022-09-30T17:11:31.000
Cb
11
House Num
2054
Onstname
67TH ST.
Atddismissed
No
18027
Atdid: 18027 • Atd Number: ATD-3-7100 • Bblid: 250605
Atdid
18027
Atd Number
ATD-3-7100
Bblid
250605
Inspectionid
401915
Inspect Date
2025-06-26T00:00:00.000
Atdissuedate
2025-07-07T14:11:55.000
Cb
2
House Num
357
Onstname
PACIFIC ST.
Atddismissed
No
8518
Atdid: 8518 • Atd Number: ATD-4-3830 • Bblid: 784836
Atdid
8518
Atd Number
ATD-4-3830
Bblid
784836
Inspectionid
329993
Inspect Date
2021-11-04T00:00:00.000
Atdissuedate
2021-11-24T11:44:18.000
Cb
9
House Num
89-03
Onstname
102ND RD.
Atddismissed
No
12961
Atdid: 12961 • Atd Number: ATD-3-5235 • Bblid: 287382
Atdid
12961
Atd Number
ATD-3-5235
Bblid
287382
Inspectionid
360556
Inspect Date
2023-07-11T00:00:00.000
Atdissuedate
2023-07-24T11:19:56.000
Cb
8
House Num
185
Onstname
STERLING PL.
Atddismissed
No