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
9040
Atdid: 9040 • Atd Number: ATD-4-4101 • Bblid: 761150
Atdid
9040
Atd Number
ATD-4-4101
Bblid
761150
Inspectionid
332449
Inspect Date
2021-12-29T00:00:00.000
Atdissuedate
2022-02-14T14:25:14.000
Cb
13
House Num
88-11
Onstname
MOLINE ST.
Atddismissed
No
16946
Atdid: 16946 • Atd Number: ATD-3-6645 • Bblid: 543972
Atdid
16946
Atd Number
ATD-3-6645
Bblid
543972
Inspectionid
391468
Inspect Date
2025-03-11T00:00:00.000
Atdissuedate
2025-03-17T10:47:08.000
Cb
18
House Num
10023
Onstname
AVENUE N.
Atddismissed
No
12616
Atdid: 12616 • Atd Number: ATD-2-1165 • Bblid: 144497
Atdid
12616
Atd Number
ATD-2-1165
Bblid
144497
Inspectionid
358714
Inspect Date
2023-06-13T00:00:00.000
Atdissuedate
2023-06-16T12:34:14.000
Cb
4
House Num
1053
Onstname
ANDERSON AVE.
Atddismissed
No
8545
Atdid: 8545 • Atd Number: ATD-3-3125 • Bblid: 447636
Atdid
8545
Atd Number
ATD-3-3125
Bblid
447636
Inspectionid
330310
Inspect Date
2021-12-07T00:00:00.000
Atdissuedate
2021-12-07T11:40:22.000
Cb
10
House Num
1027
Onstname
78TH ST.
Atddismissed
No
17922
Atdid: 17922 • Atd Number: ATD-4-7086 • Bblid: 753027
Atdid
17922
Atd Number
ATD-4-7086
Bblid
753027
Inspectionid
400636
Inspect Date
2025-06-18T00:00:00.000
Atdissuedate
2025-06-20T09:03:47.000
Cb
11
House Num
217-11
Onstname
49TH AVE.
Atddismissed
No
9887
Atdid: 9887 • Atd Number: ATD-4-4493 • Bblid: 702687
Atdid
9887
Atd Number
ATD-4-4493
Bblid
702687
Inspectionid
335026
Inspect Date
2021-10-19T00:00:00.000
Atdissuedate
2022-04-15T13:20:01.000
Cb
7
House Num
132-21
Onstname
SANFORD AVE.
Atddismissed
No
14134
Atdid: 14134 • Atd Number: ATD-4-5893 • Bblid: 647306
Atdid
14134
Atd Number
ATD-4-5893
Bblid
647306
Inspectionid
373351
Inspect Date
2024-02-29T00:00:00.000
Atdissuedate
2024-03-18T10:11:11.000
Cb
5
House Num
61-82
Onstname
78TH ST.
Atddismissed
No
5628
Atdid: 5628 • Atd Number: ATD-4-1989 • Bblid: 909539
Atdid
5628
Atd Number
ATD-4-1989
Bblid
909539
Violationid
226287
Atdissuedate
2020-05-21T00:00:00.000
Cb
14
House Num
11-35
Onstname
DICKENS STREET
Atddismissed
No
11158
Atdid: 11158 • Atd Number: ATD-3-4483 • Bblid: 546696
Atdid
11158
Atd Number
ATD-3-4483
Bblid
546696
Inspectionid
345976
Inspect Date
2022-10-13T00:00:00.000
Atdissuedate
2022-10-14T14:00:08.000
Cb
18
House Num
7228
Onstname
AVENUE M.
Atddismissed
No
11671
Atdid: 11671 • Atd Number: ATD-4-4994 • Bblid: 725962
Atdid
11671
Atd Number
ATD-4-4994
Bblid
725962
Inspectionid
351637
Inspect Date
2023-02-15T00:00:00.000
Atdissuedate
2023-02-16T11:12:04.000
Cb
11
House Num
32-38
Onstname
204TH ST.
Atddismissed
No
9401
Atdid: 9401 • Atd Number: ATD-3-3491 • Bblid: 537499
Atdid
9401
Atd Number
ATD-3-3491
Bblid
537499
Inspectionid
333160
Inspect Date
2020-11-25T00:00:00.000
Atdissuedate
2022-03-03T17:19:03.000
Cb
17
House Num
704
Onstname
E. 94TH ST.
Atddismissed
Yes
Atddismissedon
2022-09-16T13:07:01.000
12189
Atdid: 12189 • Atd Number: ATD-2-1041 • Bblid: 166771
Atdid
12189
Atd Number
ATD-2-1041
Bblid
166771
Inspectionid
356831
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2023-05-09T14:17:24.000
Cb
7
House Num
2715
Onstname
GRAND CONCOURSE
Atddismissed
No
13528
Atdid: 13528 • Atd Number: ATD-4-5567 • Bblid: 761599
Atdid
13528
Atd Number
ATD-4-5567
Bblid
761599
Inspectionid
364815
Inspect Date
2023-09-27T00:00:00.000
Atdissuedate
2023-10-03T15:09:25.000
Cb
13
House Num
88-10
Onstname
240TH ST.
Atddismissed
No
9091
Atdid: 9091 • Atd Number: ATD-4-4140 • Bblid: 622541
Atdid
9091
Atd Number
ATD-4-4140
Bblid
622541
Inspectionid
332642
Inspect Date
2019-06-01T00:00:00.000
Atdissuedate
2022-02-22T11:48:21.000
Cb
4
House Num
96-18
Onstname
50TH AVE.
Atddismissed
No
12500
Atdid: 12500 • Atd Number: ATD-4-5326 • Bblid: 793886
Atdid
12500
Atd Number
ATD-4-5326
Bblid
793886
Inspectionid
358045
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T16:23:35.000
Cb
9
House Num
111-02
Onstname
ATLANTIC AVE.
Atddismissed
No
11129
Atdid: 11129 • Atd Number: ATD-3-4465 • Bblid: 547753
Atdid
11129
Atd Number
ATD-3-4465
Bblid
547753
Inspectionid
345486
Inspect Date
2022-09-20T00:00:00.000
Atdissuedate
2022-10-11T10:13:29.000
Cb
18
House Num
1629
Onstname
E. 56TH ST.
Atddismissed
No
8735
Atdid: 8735 • Atd Number: ATD-4-3931 • Bblid: 772547
Atdid
8735
Atd Number
ATD-4-3931
Bblid
772547
Inspectionid
331089
Inspect Date
2021-11-10T00:00:00.000
Atdissuedate
2021-12-28T13:01:25.000
Cb
13
House Num
78-19
Onstname
267TH ST.
Atddismissed
No
17694
Atdid: 17694 • Atd Number: ATD-4-6950 • Bblid: 755234
Atdid
17694
Atd Number
ATD-4-6950
Bblid
755234
Inspectionid
398051
Inspect Date
2025-05-20T00:00:00.000
Atdissuedate
2025-05-21T12:00:26.000
Cb
11
House Num
224-03
Onstname
HORACE HARDING EXPY.
Atddismissed
No
17626
Atdid: 17626 • Atd Number: ATD-4-6897 • Bblid: 796660
Atdid
17626
Atd Number
ATD-4-6897
Bblid
796660
Inspectionid
397169
Inspect Date
2025-05-15T00:00:00.000
Atdissuedate
2025-05-15T15:40:48.000
Cb
9
House Num
95-27
Onstname
129TH ST.
Atddismissed
No
9324
Atdid: 9324 • Atd Number: ATD-3-3427 • Bblid: 447324
Atdid
9324
Atd Number
ATD-3-3427
Bblid
447324
Inspectionid
333034
Inspect Date
2019-07-02T00:00:00.000
Atdissuedate
2022-03-02T09:36:43.000
Cb
10
House Num
7718
Onstname
COLONIAL RD.
Atddismissed
No
9163
Atdid: 9163 • Atd Number: ATD-3-3338 • Bblid: 414607
Atdid
9163
Atd Number
ATD-3-3338
Bblid
414607
Inspectionid
332781
Inspect Date
2021-06-18T00:00:00.000
Atdissuedate
2022-02-25T13:06:01.000
Cb
7
House Num
199
Onstname
TERRACE PL.
Atddismissed
No
17944
Atdid: 17944 • Atd Number: ATD-3-7061 • Bblid: 285030
Atdid
17944
Atd Number
ATD-3-7061
Bblid
285030
Inspectionid
400730
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-23T09:58:36.000
Cb
7
House Num
12
Onstname
FULLER PL.
Atddismissed
No
13138
Atdid: 13138 • Atd Number: ATD-3-5345 • Bblid: 422390
Atdid
13138
Atd Number
ATD-3-5345
Bblid
422390
Inspectionid
361496
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T15:28:07.000
Cb
12
House Num
1573
Onstname
46 STREET
Atddismissed
No
8599
Atdid: 8599 • Atd Number: ATD-3-3150 • Bblid: 255511
Atdid
8599
Atd Number
ATD-3-3150
Bblid
255511
Inspectionid
330643
Inspect Date
2021-12-03T00:00:00.000
Atdissuedate
2021-12-13T10:09:58.000
Cb
6
House Num
282
Onstname
COURT ST.
Atddismissed
Yes
Atddismissedon
2022-05-24T09:31:20.000
11176
Atdid: 11176 • Atd Number: ATD-3-4494 • Bblid: 419618
Atdid
11176
Atd Number
ATD-3-4494
Bblid
419618
Inspectionid
346106
Inspect Date
2022-10-13T00:00:00.000
Atdissuedate
2022-10-17T10:02:01.000
Cb
12
House Num
1518
Onstname
39TH ST.
Atddismissed
No
11532
Atdid: 11532 • Atd Number: ATD-4-4922 • Bblid: 670204
Atdid
11532
Atd Number
ATD-4-4922
Bblid
670204
Inspectionid
349627
Inspect Date
2022-12-21T00:00:00.000
Atdissuedate
2022-12-23T11:46:42.000
Cb
5
House Num
61-53
Onstname
GATES AVE.
Atddismissed
No
18269
Atdid: 18269 • Atd Number: ATD-4-7214 • Bblid: 851243
Atdid
18269
Atd Number
ATD-4-7214
Bblid
851243
Inspectionid
403700
Inspect Date
2025-07-30T00:00:00.000
Atdissuedate
2025-08-06T12:45:22.000
Cb
10
House Num
127-02
Onstname
109TH AVE.
Atddismissed
No
10391
Atdid: 10391 • Atd Number: ATD-4-4698 • Bblid: 673480
Atdid
10391
Atd Number
ATD-4-4698
Bblid
673480
Inspectionid
338771
Inspect Date
2022-07-06T00:00:00.000
Atdissuedate
2022-07-06T12:57:24.000
Cb
5
House Num
77-27
Onstname
62ND ST.
Atddismissed
No
10112
Atdid: 10112 • Atd Number: ATD-3-3729 • Bblid: 253969
Atdid
10112
Atd Number
ATD-3-3729
Bblid
253969
Inspectionid
336550
Inspect Date
2022-05-16T00:00:00.000
Atdissuedate
2022-05-17T15:00:00.000
Cb
6
House Num
129
Onstname
AMITY ST.
Atddismissed
Yes
Atddismissedon
2022-05-24T11:01:34.000
10397
Atdid: 10397 • Atd Number: ATD-4-4704 • Bblid: 650875
Atdid
10397
Atd Number
ATD-4-4704
Bblid
650875
Inspectionid
338844
Inspect Date
2022-07-07T00:00:00.000
Atdissuedate
2022-07-07T10:13:25.000
Cb
5
House Num
65-19
Onstname
77TH ST.
Atddismissed
No
13533
Atdid: 13533 • Atd Number: ATD-4-5572 • Bblid: 761617
Atdid
13533
Atd Number
ATD-4-5572
Bblid
761617
Inspectionid
364843
Inspect Date
2023-09-22T00:00:00.000
Atdissuedate
2023-10-03T15:30:43.000
Cb
13
House Num
88-38
Onstname
240TH ST.
Atddismissed
No
9490
Atdid: 9490 • Atd Number: ATD-3-3532 • Bblid: 276065
Atdid
9490
Atd Number
ATD-3-3532
Bblid
276065
Inspectionid
333396
Inspect Date
2021-07-29T00:00:00.000
Atdissuedate
2022-03-08T13:29:49.000
Cb
6
House Num
635
Onstname
CARROLL ST.
Atddismissed
No
13379
Atdid: 13379 • Atd Number: ATD-5-811 • Bblid: 947730
Atdid
13379
Atd Number
ATD-5-811
Bblid
947730
Inspectionid
363288
Inspect Date
2023-09-09T00:00:00.000
Atdissuedate
2023-09-11T12:37:00.000
Cb
2
House Num
271
Onstname
MARTIN AVE.
Atddismissed
No
16359
Atdid: 16359 • Atd Number: ATD-4-6419 • Bblid: 791260
Atdid
16359
Atd Number
ATD-4-6419
Bblid
791260
Inspectionid
385000
Inspect Date
2024-10-30T00:00:00.000
Atdissuedate
2024-11-14T12:32:18.000
Cb
9
House Num
102-28
Onstname
91ST AVE.
Atddismissed
No
18300
Atdid: 18300 • Atd Number: ATD-4-7229 • Bblid: 858587
Atdid
18300
Atd Number
ATD-4-7229
Bblid
858587
Inspectionid
404007
Inspect Date
2025-08-08T00:00:00.000
Atdissuedate
2025-08-12T09:19:56.000
Cb
10
House Num
135-15
Onstname
114TH ST.
Atddismissed
No
14029
Atdid: 14029 • Atd Number: ATD-3-5749 • Bblid: 469068
Atdid
14029
Atd Number
ATD-3-5749
Bblid
469068
Violationid
286853
Reinspectionid
36009
Inspect Date
2024-02-28T09:43:37.000
Atdissuedate
2024-02-28T09:43:37.000
Cb
11
House Num
299
Onstname
BAY 11 STREET
Atddismissed
No
16387
Atdid: 16387 • Atd Number: ATD-3-6418 • Bblid: 287871
Atdid
16387
Atd Number
ATD-3-6418
Bblid
287871
Inspectionid
385092
Inspect Date
2021-09-15T00:00:00.000
Atdissuedate
2024-11-16T11:49:49.000
Cb
8
House Num
366
Onstname
STERLING PL.
Atddismissed
No
10677
Atdid: 10677 • Atd Number: ATD-3-4074 • Bblid: 267999
Atdid
10677
Atd Number
ATD-3-4074
Bblid
267999
Inspectionid
341966
Inspect Date
2022-08-18T00:00:00.000
Atdissuedate
2022-08-24T12:31:13.000
Cb
7
House Num
365
Onstname
52ND ST.
Atddismissed
No
12422
Atdid: 12422 • Atd Number: ATD-1-287 • Bblid: 79692
Atdid
12422
Atd Number
ATD-1-287
Bblid
79692
Inspectionid
357747
Inspect Date
2023-05-26T00:00:00.000
Atdissuedate
2023-05-26T12:28:10.000
Cb
5
House Num
1140
Onstname
AVENUE OF THE AMER
Atddismissed
No
12789
Atdid: 12789 • Atd Number: ATD-3-5123 • Bblid: 502604
Atdid
12789
Atd Number
ATD-3-5123
Bblid
502604
Inspectionid
359596
Inspect Date
2023-07-08T00:00:00.000
Atdissuedate
2023-07-08T11:00:51.000
Cb
15
House Num
1944
Onstname
E. 12TH ST.
Atddismissed
No
13682
Atdid: 13682 • Atd Number: ATD-3-5642 • Bblid: 423910
Atdid
13682
Atd Number
ATD-3-5642
Bblid
423910
Inspectionid
366464
Inspect Date
2023-11-02T00:00:00.000
Atdissuedate
2023-11-14T10:49:20.000
Cb
12
House Num
961
Onstname
DAHILL RD.
Atddismissed
No
13967
Atdid: 13967 • Atd Number: ATD-3-5740 • Bblid: 479989
Atdid
13967
Atd Number
ATD-3-5740
Bblid
479989
Inspectionid
371703
Inspect Date
2024-02-09T00:00:00.000
Atdissuedate
2024-02-15T12:27:09.000
Cb
14
House Num
759
Onstname
E. 17TH ST.
Atddismissed
No
2021
Atdid: 2021 • Atd Number: ATD-3-1164 • Bblid: 278145
Atdid
2021
Atd Number
ATD-3-1164
Bblid
278145
Violationid
153661
Atdissuedate
2020-08-13T00:00:00.000
Cb
6
House Num
380
Onstname
6 AVENUE
Atddismissed
Yes
Atddismissedon
2025-03-17T11:09:54.000
18154
Atdid: 18154 • Atd Number: ATD-3-7163 • Bblid: 561880
Atdid
18154
Atd Number
ATD-3-7163
Bblid
561880
Inspectionid
402878
Inspect Date
2025-07-12T00:00:00.000
Atdissuedate
2025-07-21T18:19:15.000
Cb
15
House Num
2743
Onstname
BROWN ST.
Atddismissed
No
13131
Atdid: 13131 • Atd Number: ATD-3-5343 • Bblid: 422766
Atdid
13131
Atd Number
ATD-3-5343
Bblid
422766
Inspectionid
361477
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T12:36:28.000
Cb
12
House Num
1578
Onstname
46TH ST.
Atddismissed
No
10379
Atdid: 10379 • Atd Number: ATD-3-3892 • Bblid: 417684
Atdid
10379
Atd Number
ATD-3-3892
Bblid
417684
Inspectionid
338591
Inspect Date
2022-06-22T00:00:00.000
Atdissuedate
2022-07-05T13:56:55.000
Cb
12
House Num
234
Onstname
E. 5TH ST.
Atddismissed
No
16944
Atdid: 16944 • Atd Number: ATD-2-1341 • Bblid: 240404
Atdid
16944
Atd Number
ATD-2-1341
Bblid
240404
Inspectionid
391457
Inspect Date
2025-03-11T00:00:00.000
Atdissuedate
2025-03-17T10:31:27.000
Cb
10
House Num
2602
Onstname
MILES AVE.
Atddismissed
No
2305
Atdid: 2305 • Atd Number: ATD-3-1448 • Bblid: 433610
Atdid
2305
Atd Number
ATD-3-1448
Bblid
433610
Violationid
236279
Atdissuedate
2020-07-20T00:00:00.000
Cb
12
House Num
1417
Onstname
50 STREET
Atddismissed
Yes
Atddismissedon
2025-03-18T13:06:58.000
17937
Atdid: 17937 • Atd Number: ATD-3-7054 • Bblid: 285041
Atdid
17937
Atd Number
ATD-3-7054
Bblid
285041
Inspectionid
400719
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-23T09:50:09.000
Cb
7
House Num
34
Onstname
FULLER PL.
Atddismissed
No
16723
Atdid: 16723 • Atd Number: ATD-4-6582 • Bblid: 772704
Atdid
16723
Atd Number
ATD-4-6582
Bblid
772704
Inspectionid
388903
Inspect Date
2025-01-14T00:00:00.000
Atdissuedate
2025-01-23T11:25:17.000
Cb
13
House Num
79-19
Onstname
264TH ST.
Atddismissed
No