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
9382
Atdid: 9382 • Atd Number: ATD-3-3479 • Bblid: 333438
Atdid
9382
Atd Number
ATD-3-3479
Bblid
333438
Inspectionid
333110
Inspect Date
2020-11-05T00:00:00.000
Atdissuedate
2022-03-03T08:54:01.000
Cb
1
House Num
134
Onstname
HEYWARD ST.
Atddismissed
No
18042
Atdid: 18042 • Atd Number: ATD-4-7125 • Bblid: 688876
Atdid
18042
Atd Number
ATD-4-7125
Bblid
688876
Inspectionid
401988
Inspect Date
2025-05-15T00:00:00.000
Atdissuedate
2025-07-09T17:16:07.000
Cb
7
House Num
154-11
Onstname
12TH RD.
Atddismissed
No
17426
Atdid: 17426 • Atd Number: ATD-4-6800 • Bblid: 861892
Atdid
17426
Atd Number
ATD-4-6800
Bblid
861892
Inspectionid
395238
Inspect Date
2025-04-16T00:00:00.000
Atdissuedate
2025-04-24T13:25:49.000
Cb
12
House Num
114-43
Onstname
148TH ST.
Atddismissed
No
12620
Atdid: 12620 • Atd Number: ATD-4-5370 • Bblid: 617398
Atdid
12620
Atd Number
ATD-4-5370
Bblid
617398
Inspectionid
358806
Inspect Date
2023-06-21T00:00:00.000
Atdissuedate
2023-06-21T11:41:04.000
Cb
3
House Num
35-45
Onstname
97TH ST.
Atddismissed
No
12730
Atdid: 12730 • Atd Number: ATD-4-5397 • Bblid: 837457
Atdid
12730
Atd Number
ATD-4-5397
Bblid
837457
Inspectionid
359222
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-30T11:31:01.000
Cb
13
House Num
114-64
Onstname
COLFAX ST.
Atddismissed
No
9193
Atdid: 9193 • Atd Number: ATD-3-3350 • Bblid: 434721
Atdid
9193
Atd Number
ATD-3-3350
Bblid
434721
Inspectionid
332851
Inspect Date
2020-11-14T00:00:00.000
Atdissuedate
2022-02-28T17:29:57.000
Cb
12
House Num
1161
Onstname
54TH ST.
Atddismissed
No
9797
Atdid: 9797 • Atd Number: ATD-3-3596 • Bblid: 524980
Atdid
9797
Atd Number
ATD-3-3596
Bblid
524980
Inspectionid
334436
Inspect Date
2021-04-29T00:00:00.000
Atdissuedate
2022-03-31T11:49:27.000
Cb
18
House Num
1084
Onstname
E. 57TH ST.
Atddismissed
No
16714
Atdid: 16714 • Atd Number: ATD-1-358 • Bblid: 117004
Atdid
16714
Atd Number
ATD-1-358
Bblid
117004
Inspectionid
388837
Inspect Date
2024-11-27T00:00:00.000
Atdissuedate
2025-01-21T14:34:57.000
Cb
10
House Num
38
Onstname
W. 127TH ST.
Atddismissed
No
17323
Atdid: 17323 • Atd Number: ATD-3-6861 • Bblid: 319556
Atdid
17323
Atd Number
ATD-3-6861
Bblid
319556
Inspectionid
394430
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-04-14T08:18:57.000
Cb
3
House Num
296
Onstname
MACON ST.
Atddismissed
No
14018
Atdid: 14018 • Atd Number: ATD-4-5840 • Bblid: 832952
Atdid
14018
Atd Number
ATD-4-5840
Bblid
832952
Inspectionid
372212
Inspect Date
2024-02-21T00:00:00.000
Atdissuedate
2024-02-26T11:06:24.000
Cb
13
House Num
100-39
Onstname
207TH ST.
Atddismissed
No
11095
Atdid: 11095 • Atd Number: ATD-3-4442 • Bblid: 375648
Atdid
11095
Atd Number
ATD-3-4442
Bblid
375648
Inspectionid
345124
Inspect Date
2022-09-30T00:00:00.000
Atdissuedate
2022-10-04T10:57:57.000
Cb
5
House Num
158
Onstname
ATKINS AVE.
Atddismissed
No
9966
Atdid: 9966 • Atd Number: ATD-3-3653 • Bblid: 270558
Atdid
9966
Atd Number
ATD-3-3653
Bblid
270558
Inspectionid
335467
Inspect Date
2022-04-05T00:00:00.000
Atdissuedate
2022-04-25T08:41:26.000
Cb
7
House Num
424
Onstname
58TH ST.
Atddismissed
No
12817
Atdid: 12817 • Atd Number: ATD-3-5148 • Bblid: 361843
Atdid
12817
Atd Number
ATD-3-5148
Bblid
361843
Inspectionid
359835
Inspect Date
2023-07-07T00:00:00.000
Atdissuedate
2023-07-11T12:44:44.000
Cb
4
House Num
242
Onstname
SCHAEFER ST.
Atddismissed
No
6055
Atdid: 6055 • Atd Number: ATD-4-2416 • Bblid: 907371
Atdid
6055
Atd Number
ATD-4-2416
Bblid
907371
Violationid
237419
Atdissuedate
2020-06-05T00:00:00.000
Cb
14
House Num
9-14
Onstname
SEAGIRT BOULEVARD
Atddismissed
No
9977
Atdid: 9977 • Atd Number: ATD-4-4536 • Bblid: 605953
Atdid
9977
Atd Number
ATD-4-4536
Bblid
605953
Inspectionid
335663
Inspect Date
2020-10-26T00:00:00.000
Atdissuedate
2022-04-27T08:35:10.000
Cb
3
House Num
30-04
Onstname
86TH ST.
Atddismissed
No
13840
Atdid: 13840 • Atd Number: ATD-4-5730 • Bblid: 821720
Atdid
13840
Atd Number
ATD-4-5730
Bblid
821720
Inspectionid
370390
Inspect Date
2023-12-13T00:00:00.000
Atdissuedate
2024-01-06T10:44:56.000
Cb
12
House Num
189-26
Onstname
113TH AVE.
Atddismissed
No
16376
Atdid: 16376 • Atd Number: ATD-3-6415 • Bblid: 328424
Atdid
16376
Atd Number
ATD-3-6415
Bblid
328424
Inspectionid
385068
Inspect Date
2024-11-08T00:00:00.000
Atdissuedate
2024-11-15T10:28:28.000
Cb
2
House Num
26
Onstname
SAINT FELIX ST.
Atddismissed
No
18031
Atdid: 18031 • Atd Number: ATD-3-7104 • Bblid: 250784
Atdid
18031
Atd Number
ATD-3-7104
Bblid
250784
Inspectionid
401930
Inspect Date
2025-07-01T00:00:00.000
Atdissuedate
2025-07-07T14:46:03.000
Cb
2
House Num
495
Onstname
PACIFIC ST.
Atddismissed
No
14151
Atdid: 14151 • Atd Number: ATD-3-5813 • Bblid: 481930
Atdid
14151
Atd Number
ATD-3-5813
Bblid
481930
Inspectionid
373497
Inspect Date
2024-03-18T00:00:00.000
Atdissuedate
2024-03-18T16:37:10.000
Cb
14
House Num
1367
Onstname
E. 16TH ST.
Atddismissed
No
9916
Atdid: 9916 • Atd Number: ATD-4-4504 • Bblid: 654466
Atdid
9916
Atd Number
ATD-4-4504
Bblid
654466
Inspectionid
335260
Inspect Date
2022-04-15T00:00:00.000
Atdissuedate
2022-04-20T13:57:19.000
Cb
6
House Num
63-16
Onstname
ELLWELL CRES
Atddismissed
No
14882
Atdid: 14882 • Atd Number: ATD-3-6184 • Bblid: 428981
Atdid
14882
Atd Number
ATD-3-6184
Bblid
428981
Inspectionid
380367
Inspect Date
2024-08-06T00:00:00.000
Atdissuedate
2024-08-07T09:33:28.000
Cb
11
House Num
6627
Onstname
OVINGTON CT.
Atddismissed
No
11332
Atdid: 11332 • Atd Number: ATD-3-4609 • Bblid: 281793
Atdid
11332
Atd Number
ATD-3-4609
Bblid
281793
Inspectionid
347498
Inspect Date
2022-11-02T00:00:00.000
Atdissuedate
2022-11-03T10:36:36.000
Cb
6
House Num
270
Onstname
BERKELEY PL.
Atddismissed
No
17130
Atdid: 17130 • Atd Number: ATD-2-1349 • Bblid: 208976
Atdid
17130
Atd Number
ATD-2-1349
Bblid
208976
Inspectionid
392543
Inspect Date
2025-03-28T00:00:00.000
Atdissuedate
2025-03-28T18:39:47.000
Cb
11
House Num
2705
Onstname
MICKLE AVE.
Atddismissed
No
18188
Atdid: 18188 • Atd Number: ATD-4-7186 • Bblid: 828691
Atdid
18188
Atd Number
ATD-4-7186
Bblid
828691
Inspectionid
403103
Inspect Date
2025-07-23T00:00:00.000
Atdissuedate
2025-07-24T10:22:28.000
Cb
13
House Num
88-27
Onstname
212TH ST.
Atddismissed
No
11987
Atdid: 11987 • Atd Number: ATD-4-5106 • Bblid: 656718
Atdid
11987
Atd Number
ATD-4-5106
Bblid
656718
Inspectionid
354474
Inspect Date
2023-04-05T00:00:00.000
Atdissuedate
2023-04-05T12:02:57.000
Cb
6
House Num
67-41
Onstname
FLEET ST.
Atddismissed
No
18039
Atdid: 18039 • Atd Number: ATD-4-7122 • Bblid: 579887
Atdid
18039
Atd Number
ATD-4-7122
Bblid
579887
Inspectionid
401978
Inspect Date
2025-05-02T00:00:00.000
Atdissuedate
2025-07-09T16:48:41.000
Cb
1
House Num
30-39
Onstname
35TH ST.
Atddismissed
No
11059
Atdid: 11059 • Atd Number: ATD-3-4407 • Bblid: 469732
Atdid
11059
Atd Number
ATD-3-4407
Bblid
469732
Inspectionid
344948
Inspect Date
2022-09-29T00:00:00.000
Atdissuedate
2022-09-30T17:03:56.000
Cb
11
House Num
8830
Onstname
20TH AVE.
Atddismissed
No
12225
Atdid: 12225 • Atd Number: ATD-3-5011 • Bblid: 328508
Atdid
12225
Atd Number
ATD-3-5011
Bblid
328508
Inspectionid
356956
Inspect Date
2023-05-11T00:00:00.000
Atdissuedate
2023-05-11T15:10:06.000
Cb
2
House Num
49
Onstname
S. PORTLAND AVE.
Atddismissed
No
10965
Atdid: 10965 • Atd Number: ATD-3-4323 • Bblid: 276077
Atdid
10965
Atd Number
ATD-3-4323
Bblid
276077
Violationid
277272
Reinspectionid
33025
Inspect Date
2022-09-22T10:39:33.000
Atdissuedate
2022-09-22T10:39:33.000
Cb
6
House Num
623
Onstname
CARROLL STREET
Atddismissed
No
13070
Atdid: 13070 • Atd Number: ATD-2-1203 • Bblid: 226564
Atdid
13070
Atd Number
ATD-2-1203
Bblid
226564
Inspectionid
361103
Inspect Date
2023-06-24T00:00:00.000
Atdissuedate
2023-07-31T13:30:40.000
Cb
12
House Num
4363
Onstname
WICKHAM AVE.
Atddismissed
Yes
Atddismissedon
2024-07-11T09:55:21.000
12617
Atdid: 12617 • Atd Number: ATD-3-5088 • Bblid: 251328
Atdid
12617
Atd Number
ATD-3-5088
Bblid
251328
Inspectionid
358745
Inspect Date
2023-05-31T00:00:00.000
Atdissuedate
2023-06-20T09:28:46.000
Cb
2
House Num
107
Onstname
BERGEN ST.
Atddismissed
No
18454
Atdid: 18454 • Atd Number: ATD-4-7309 • Bblid: 588942
Atdid
18454
Atd Number
ATD-4-7309
Bblid
588942
Inspectionid
404986
Inspect Date
2025-08-28T00:00:00.000
Atdissuedate
2025-08-28T12:59:50.000
Cb
1
House Num
20-18
Onstname
27TH ST.
Atddismissed
No
14623
Atdid: 14623 • Atd Number: ATD-3-6060 • Bblid: 424791
Atdid
14623
Atd Number
ATD-3-6060
Bblid
424791
Inspectionid
378570
Inspect Date
2024-06-15T00:00:00.000
Atdissuedate
2024-06-18T10:02:03.000
Cb
12
House Num
1639
Onstname
55TH ST.
Atddismissed
No
13281
Atdid: 13281 • Atd Number: ATD-3-5441 • Bblid: 509403
Atdid
13281
Atd Number
ATD-3-5441
Bblid
509403
Inspectionid
362264
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-21T13:14:07.000
Cb
15
House Num
2345
Onstname
E. 28TH ST.
Atddismissed
No
9925
Atdid: 9925 • Atd Number: ATD-3-3638 • Bblid: 259530
Atdid
9925
Atd Number
ATD-3-3638
Bblid
259530
Inspectionid
335296
Inspect Date
2022-04-20T00:00:00.000
Atdissuedate
2022-04-20T15:18:56.000
Cb
6
House Num
454
Onstname
DEGRAW ST.
Atddismissed
No
17321
Atdid: 17321 • Atd Number: ATD-3-6859 • Bblid: 319550
Atdid
17321
Atd Number
ATD-3-6859
Bblid
319550
Inspectionid
394428
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-04-14T08:18:06.000
Cb
3
House Num
290
Onstname
MACON ST.
Atddismissed
No
14844
Atdid: 14844 • Atd Number: ATD-5-875 • Bblid: 951887
Atdid
14844
Atd Number
ATD-5-875
Bblid
951887
Violationid
294116
Reinspectionid
37031
Inspect Date
2024-08-01T15:15:11.000
Atdissuedate
2024-08-01T15:15:11.000
Cb
2
House Num
94
Onstname
ALTAMONT STREET
Atddismissed
No
17280
Atdid: 17280 • Atd Number: ATD-4-6741 • Bblid: 848060
Atdid
17280
Atd Number
ATD-4-6741
Bblid
848060
Inspectionid
393447
Inspect Date
2025-03-26T00:00:00.000
Atdissuedate
2025-04-07T12:08:29.000
Cb
10
House Num
153-38
Onstname
79TH ST.
Atddismissed
No
17337
Atdid: 17337 • Atd Number: ATD-3-6868 • Bblid: 278693
Atdid
17337
Atd Number
ATD-3-6868
Bblid
278693
Inspectionid
394474
Inspect Date
2025-04-05T00:00:00.000
Atdissuedate
2025-04-14T08:56:30.000
Cb
6
House Num
428
Onstname
7TH ST.
Atddismissed
No
8491
Atdid: 8491 • Atd Number: ATD-3-3094 • Bblid: 315512
Atdid
8491
Atd Number
ATD-3-3094
Bblid
315512
Inspectionid
329615
Inspect Date
2021-11-10T00:00:00.000
Atdissuedate
2021-11-15T11:17:28.000
Cb
3
House Num
252
Onstname
CLIFTON PL.
Atddismissed
No
9803
Atdid: 9803 • Atd Number: ATD-4-4439 • Bblid: 779290
Atdid
9803
Atd Number
ATD-4-4439
Bblid
779290
Inspectionid
334472
Inspect Date
2018-09-20T00:00:00.000
Atdissuedate
2022-03-31T14:51:00.000
Cb
9
House Num
87-78
Onstname
94TH ST.
Atddismissed
No
9514
Atdid: 9514 • Atd Number: ATD-4-4272 • Bblid: 756282
Atdid
9514
Atd Number
ATD-4-4272
Bblid
756282
Inspectionid
333539
Inspect Date
2019-08-23T00:00:00.000
Atdissuedate
2022-03-09T15:30:33.000
Cb
11
House Num
216-11
Onstname
64TH AVE.
Atddismissed
No
11837
Atdid: 11837 • Atd Number: ATD-4-5066 • Bblid: 839768
Atdid
11837
Atd Number
ATD-4-5066
Bblid
839768
Inspectionid
353507
Inspect Date
2023-03-17T00:00:00.000
Atdissuedate
2023-03-21T14:17:48.000
Cb
13
House Num
104-37
Onstname
212TH PL.
Atddismissed
No
9728
Atdid: 9728 • Atd Number: ATD-4-4412 • Bblid: 760770
Atdid
9728
Atd Number
ATD-4-4412
Bblid
760770
Inspectionid
334141
Inspect Date
2016-07-20T00:00:00.000
Atdissuedate
2022-03-24T17:52:14.000
Cb
13
House Num
235-07
Onstname
88TH AVE.
Atddismissed
No
10400
Atdid: 10400 • Atd Number: ATD-4-4707 • Bblid: 650841
Atdid
10400
Atd Number
ATD-4-4707
Bblid
650841
Inspectionid
338862
Inspect Date
2022-07-07T00:00:00.000
Atdissuedate
2022-07-07T10:23:02.000
Cb
5
House Num
65-53
Onstname
77TH ST.
Atddismissed
No
17809
Atdid: 17809 • Atd Number: ATD-4-7026 • Bblid: 870364
Atdid
17809
Atd Number
ATD-4-7026
Bblid
870364
Inspectionid
399311
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-06T11:19:57.000
Cb
12
House Num
163-12
Onstname
SAYRES AVE.
Atddismissed
No
18294
Atdid: 18294 • Atd Number: ATD-3-7218 • Bblid: 516477
Atdid
18294
Atd Number
ATD-3-7218
Bblid
516477
Inspectionid
403963
Inspect Date
2025-08-06T00:00:00.000
Atdissuedate
2025-08-11T12:36:24.000
Cb
18
House Num
1150
Onstname
E. 32ND ST.
Atddismissed
No
16542
Atdid: 16542 • Atd Number: ATD-3-6480 • Bblid: 282519
Atdid
16542
Atd Number
ATD-3-6480
Bblid
282519
Inspectionid
386581
Inspect Date
2024-12-17T00:00:00.000
Atdissuedate
2024-12-18T11:28:12.000
Cb
6
House Num
619
Onstname
2ND ST.
Atddismissed
No
10359
Atdid: 10359 • Atd Number: ATD-3-3872 • Bblid: 314189
Atdid
10359
Atd Number
ATD-3-3872
Bblid
314189
Inspectionid
338511
Inspect Date
2022-06-22T00:00:00.000
Atdissuedate
2022-07-05T11:20:54.000
Cb
3
House Num
229A
Onstname
HART ST.
Atddismissed
No
13768
Atdid: 13768 • Atd Number: ATD-4-5673 • Bblid: 771828
Atdid
13768
Atd Number
ATD-4-5673
Bblid
771828
Inspectionid
369279
Inspect Date
2023-10-11T00:00:00.000
Atdissuedate
2023-12-11T14:53:20.000
Cb
13
House Num
88-59
Onstname
247TH ST.
Atddismissed
No