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
17682
Atdid: 17682 • Atd Number: ATD-4-6938 • Bblid: 708072
Atdid
17682
Atd Number
ATD-4-6938
Bblid
708072
Inspectionid
397714
Inspect Date
2025-05-17T00:00:00.000
Atdissuedate
2025-05-20T09:38:25.000
Cb
7
House Num
146-30
Onstname
45TH AVE.
Atddismissed
No
10042
Atdid: 10042 • Atd Number: ATD-4-4583 • Bblid: 654744
Atdid
10042
Atd Number
ATD-4-4583
Bblid
654744
Inspectionid
336071
Inspect Date
2022-04-28T00:00:00.000
Atdissuedate
2022-05-03T12:04:45.000
Cb
6
House Num
63-145
Onstname
CARLTON ST.
Atddismissed
No
12273
Atdid: 12273 • Atd Number: ATD-3-5033 • Bblid: 271288
Atdid
12273
Atd Number
ATD-3-5033
Bblid
271288
Violationid
285383
Reinspectionid
35558
Inspect Date
2023-05-18T10:34:33.000
Atdissuedate
2023-05-18T10:34:33.000
Cb
7
House Num
501
Onstname
17 STREET
Atddismissed
No
8900
Atdid: 8900 • Atd Number: ATD-5-597 • Bblid: 1019832
Atdid
8900
Atd Number
ATD-5-597
Bblid
1019832
Inspectionid
332112
Inspect Date
2020-11-23T00:00:00.000
Atdissuedate
2022-01-27T09:51:56.000
Cb
3
House Num
55
Onstname
KINGHORN ST.
Atddismissed
No
13886
Atdid: 13886 • Atd Number: ATD-4-5755 • Bblid: 775604
Atdid
13886
Atd Number
ATD-4-5755
Bblid
775604
Inspectionid
371016
Inspect Date
2024-01-27T00:00:00.000
Atdissuedate
2024-01-29T11:56:00.000
Cb
13
House Num
86-24
Onstname
256TH ST.
Atddismissed
No
17449
Atdid: 17449 • Atd Number: ATD-3-6923 • Bblid: 378317
Atdid
17449
Atd Number
ATD-3-6923
Bblid
378317
Inspectionid
395409
Inspect Date
2025-03-25T00:00:00.000
Atdissuedate
2025-04-25T22:32:15.000
Cb
5
House Num
566
Onstname
SCHENCK AVE.
Atddismissed
No
14576
Atdid: 14576 • Atd Number: ATD-3-6030 • Bblid: 432761
Atdid
14576
Atd Number
ATD-3-6030
Bblid
432761
Inspectionid
378352
Inspect Date
2024-05-07T00:00:00.000
Atdissuedate
2024-06-11T14:34:13.000
Cb
12
House Num
1111
Onstname
48TH ST.
Atddismissed
No
10962
Atdid: 10962 • Atd Number: ATD-3-4320 • Bblid: 279292
Atdid
10962
Atd Number
ATD-3-4320
Bblid
279292
Inspectionid
344276
Inspect Date
2022-09-20T00:00:00.000
Atdissuedate
2022-09-22T09:08:52.000
Cb
6
House Num
144
Onstname
11TH ST.
Atddismissed
No
11638
Atdid: 11638 • Atd Number: ATD-3-4725 • Bblid: 279459
Atdid
11638
Atd Number
ATD-3-4725
Bblid
279459
Inspectionid
350964
Inspect Date
2023-01-24T00:00:00.000
Atdissuedate
2023-02-06T10:59:56.000
Cb
6
House Num
267
Onstname
11TH ST.
Atddismissed
No
11923
Atdid: 11923 • Atd Number: ATD-3-4874 • Bblid: 286532
Atdid
11923
Atd Number
ATD-3-4874
Bblid
286532
Inspectionid
354170
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-29T12:11:11.000
Cb
8
House Num
217
Onstname
PROSPECT PL.
Atddismissed
No
17811
Atdid: 17811 • Atd Number: ATD-1-375 • Bblid: 131936
Atdid
17811
Atd Number
ATD-1-375
Bblid
131936
Inspectionid
399315
Inspect Date
2025-06-05T00:00:00.000
Atdissuedate
2025-06-06T12:14:14.000
Cb
9
House Num
18
Onstname
HAMILTON TER.
Atddismissed
No
11550
Atdid: 11550 • Atd Number: ATD-1-271 • Bblid: 47211
Atdid
11550
Atd Number
ATD-1-271
Bblid
47211
Inspectionid
349774
Inspect Date
2022-12-28T00:00:00.000
Atdissuedate
2022-12-28T12:42:27.000
Cb
6
House Num
315
Onstname
E. 18TH ST.
Atddismissed
No
14846
Atdid: 14846 • Atd Number: ATD-3-6167 • Bblid: 504614
Atdid
14846
Atd Number
ATD-3-6167
Bblid
504614
Inspectionid
380115
Inspect Date
2024-08-02T00:00:00.000
Atdissuedate
2024-08-05T10:28:00.000
Cb
15
House Num
2145
Onstname
E. 21ST ST.
Atddismissed
No
17982
Atdid: 17982 • Atd Number: ATD-3-7083 • Bblid: 496649
Atdid
17982
Atd Number
ATD-3-7083
Bblid
496649
Inspectionid
401560
Inspect Date
2025-06-25T00:00:00.000
Atdissuedate
2025-06-26T11:25:12.000
Cb
15
House Num
442
Onstname
AVENUE U.
Atddismissed
No
11087
Atdid: 11087 • Atd Number: ATD-3-4435 • Bblid: 258472
Atdid
11087
Atd Number
ATD-3-4435
Bblid
258472
Inspectionid
345086
Inspect Date
2022-08-13T00:00:00.000
Atdissuedate
2022-10-03T13:00:59.000
Cb
2
House Num
285
Onstname
WARREN ST.
Atddismissed
No
8560
Atdid: 8560 • Atd Number: ATD-3-3130 • Bblid: 302033
Atdid
8560
Atd Number
ATD-3-3130
Bblid
302033
Inspectionid
330464
Inspect Date
2019-08-20T00:00:00.000
Atdissuedate
2021-12-08T11:10:57.000
Cb
3
House Num
633
Onstname
DECATUR ST.
Atddismissed
No
16456
Atdid: 16456 • Atd Number: ATD-4-6469 • Bblid: 828109
Atdid
16456
Atd Number
ATD-4-6469
Bblid
828109
Inspectionid
385548
Inspect Date
2024-07-15T00:00:00.000
Atdissuedate
2024-12-02T12:14:07.000
Cb
13
House Num
89-07
Onstname
215TH ST.
Atddismissed
No
14141
Atdid: 14141 • Atd Number: ATD-4-5900 • Bblid: 647236
Atdid
14141
Atd Number
ATD-4-5900
Bblid
647236
Inspectionid
373374
Inspect Date
2023-11-04T00:00:00.000
Atdissuedate
2024-03-18T10:42:30.000
Cb
5
House Num
61-08
Onstname
78TH ST.
Atddismissed
No
16395
Atdid: 16395 • Atd Number: ATD-4-6434 • Bblid: 654852
Atdid
16395
Atd Number
ATD-4-6434
Bblid
654852
Inspectionid
385100
Inspect Date
2022-04-26T00:00:00.000
Atdissuedate
2024-11-16T12:12:34.000
Cb
6
House Num
63-03
Onstname
CROMWELL CRES
Atddismissed
No
14199
Atdid: 14199 • Atd Number: ATD-3-5859 • Bblid: 532336
Atdid
14199
Atd Number
ATD-3-5859
Bblid
532336
Inspectionid
373826
Inspect Date
2024-03-20T00:00:00.000
Atdissuedate
2024-03-20T14:52:59.000
Cb
18
House Num
675
Onstname
E. 83RD ST.
Atddismissed
No
12594
Atdid: 12594 • Atd Number: ATD-4-5359 • Bblid: 612793
Atdid
12594
Atd Number
ATD-4-5359
Bblid
612793
Inspectionid
358611
Inspect Date
2023-06-15T00:00:00.000
Atdissuedate
2023-06-15T10:56:12.000
Cb
4
House Num
42-45
Onstname
FORLEY ST.
Atddismissed
No
10316
Atdid: 10316 • Atd Number: ATD-4-4672 • Bblid: 834934
Atdid
10316
Atd Number
ATD-4-4672
Bblid
834934
Inspectionid
337920
Inspect Date
2022-06-15T00:00:00.000
Atdissuedate
2022-06-21T14:36:05.000
Cb
12
House Num
194-23
Onstname
112TH AVE.
Atddismissed
Yes
Atddismissedon
2022-06-21T14:38:04.000
12191
Atdid: 12191 • Atd Number: ATD-2-1043 • Bblid: 166853
Atdid
12191
Atd Number
ATD-2-1043
Bblid
166853
Inspectionid
356833
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2023-05-09T14:21:00.000
Cb
7
House Num
2781
Onstname
GRAND CONCOURSE
Atddismissed
No
10539
Atdid: 10539 • Atd Number: ATD-3-3989 • Bblid: 531223
Atdid
10539
Atd Number
ATD-3-3989
Bblid
531223
Inspectionid
340253
Inspect Date
2022-07-21T00:00:00.000
Atdissuedate
2022-07-21T14:07:30.000
Cb
18
House Num
557
Onstname
E. 81ST ST.
Atddismissed
No
8636
Atdid: 8636 • Atd Number: ATD-4-3877 • Bblid: 772529
Atdid
8636
Atd Number
ATD-4-3877
Bblid
772529
Inspectionid
330774
Inspect Date
2021-12-01T00:00:00.000
Atdissuedate
2021-12-15T13:34:36.000
Cb
13
House Num
78-18
Onstname
268TH ST.
Atddismissed
No
10879
Atdid: 10879 • Atd Number: ATD-3-4250 • Bblid: 332537
Atdid
10879
Atd Number
ATD-3-4250
Bblid
332537
Inspectionid
343533
Inspect Date
2022-09-10T00:00:00.000
Atdissuedate
2022-09-12T12:39:54.000
Cb
1
House Num
81
Onstname
PENN ST.
Atddismissed
No
14647
Atdid: 14647 • Atd Number: ATD-2-1288 • Bblid: 152091
Atdid
14647
Atd Number
ATD-2-1288
Bblid
152091
Inspectionid
378714
Inspect Date
2024-06-21T00:00:00.000
Atdissuedate
2024-06-24T15:42:30.000
Cb
4
House Num
1692
Onstname
WEEKS AVE.
Atddismissed
No
14036
Atdid: 14036 • Atd Number: ATD-4-5857 • Bblid: 648764
Atdid
14036
Atd Number
ATD-4-5857
Bblid
648764
Inspectionid
372428
Inspect Date
2024-01-31T00:00:00.000
Atdissuedate
2024-02-28T15:18:22.000
Cb
5
House Num
62-64
Onstname
82ND ST.
Atddismissed
No
12168
Atdid: 12168 • Atd Number: ATD-2-1026 • Bblid: 227482
Atdid
12168
Atd Number
ATD-2-1026
Bblid
227482
Inspectionid
356752
Inspect Date
2023-04-26T00:00:00.000
Atdissuedate
2023-05-08T11:07:50.000
Cb
12
House Num
4623
Onstname
MATILDA AVE.
Atddismissed
No
13245
Atdid: 13245 • Atd Number: ATD-3-5416 • Bblid: 433112
Atdid
13245
Atd Number
ATD-3-5416
Bblid
433112
Inspectionid
362065
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T16:39:12.000
Cb
12
House Num
1460
Onstname
47TH ST.
Atddismissed
No
13300
Atdid: 13300 • Atd Number: ATD-3-5453 • Bblid: 417180
Atdid
13300
Atd Number
ATD-3-5453
Bblid
417180
Inspectionid
362444
Inspect Date
2023-08-14T00:00:00.000
Atdissuedate
2023-08-22T13:42:56.000
Cb
12
House Num
40
Onstname
LOUISA ST.
Atddismissed
No
10065
Atdid: 10065 • Atd Number: ATD-3-3685 • Bblid: 263745
Atdid
10065
Atd Number
ATD-3-3685
Bblid
263745
Inspectionid
336316
Inspect Date
2022-05-11T00:00:00.000
Atdissuedate
2022-05-11T11:01:34.000
Cb
7
House Num
197
Onstname
31ST ST.
Atddismissed
No
10333
Atdid: 10333 • Atd Number: ATD-4-4685 • Bblid: 758543
Atdid
10333
Atd Number
ATD-4-4685
Bblid
758543
Inspectionid
338211
Inspect Date
2022-06-16T00:00:00.000
Atdissuedate
2022-06-27T12:43:58.000
Cb
11
House Num
80-59
Onstname
211TH ST.
Atddismissed
No
15031
Atdid: 15031 • Atd Number: ATD-3-6267 • Bblid: 535020
Atdid
15031
Atd Number
ATD-3-6267
Bblid
535020
Inspectionid
381662
Inspect Date
2024-08-16T00:00:00.000
Atdissuedate
2024-09-09T16:17:58.000
Cb
18
House Num
1181
Onstname
E. 84TH ST.
Atddismissed
No
11840
Atdid: 11840 • Atd Number: ATD-3-4814 • Bblid: 286197
Atdid
11840
Atd Number
ATD-3-4814
Bblid
286197
Inspectionid
353516
Inspect Date
2023-03-21T00:00:00.000
Atdissuedate
2023-03-21T14:56:20.000
Cb
8
House Num
145
Onstname
SAINT MARKS AVE.
Atddismissed
Yes
Atddismissedon
2024-03-06T18:19:30.000
17445
Atdid: 17445 • Atd Number: ATD-4-6805 • Bblid: 836395
Atdid
17445
Atd Number
ATD-4-6805
Bblid
836395
Inspectionid
395374
Inspect Date
2025-04-07T00:00:00.000
Atdissuedate
2025-04-25T10:11:16.000
Cb
12
House Num
113-17
Onstname
205TH ST.
Atddismissed
No
11942
Atdid: 11942 • Atd Number: ATD-3-4893 • Bblid: 554679
Atdid
11942
Atd Number
ATD-3-4893
Bblid
554679
Inspectionid
354251
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-30T12:53:00.000
Cb
18
House Num
2774
Onstname
E. 64TH ST.
Atddismissed
No
14759
Atdid: 14759 • Atd Number: ATD-4-6156 • Bblid: 838567
Atdid
14759
Atd Number
ATD-4-6156
Bblid
838567
Inspectionid
379517
Inspect Date
2024-06-24T00:00:00.000
Atdissuedate
2024-07-17T14:24:41.000
Cb
12
House Num
189-11
Onstname
116TH RD.
Atddismissed
No
14226
Atdid: 14226 • Atd Number: ATD-3-5862 • Bblid: 292961
Atdid
14226
Atd Number
ATD-3-5862
Bblid
292961
Inspectionid
374379
Inspect Date
2024-03-29T00:00:00.000
Atdissuedate
2024-03-29T07:55:43.000
Cb
9
House Num
1354
Onstname
PRESIDENT ST.
Atddismissed
No
10638
Atdid: 10638 • Atd Number: ATD-4-4782 • Bblid: 725420
Atdid
10638
Atd Number
ATD-4-4782
Bblid
725420
Inspectionid
341301
Inspect Date
2022-08-06T00:00:00.000
Atdissuedate
2022-08-09T16:33:48.000
Cb
11
House Num
26-30
Onstname
BELL BLVD.
Atddismissed
No
12966
Atdid: 12966 • Atd Number: ATD-3-5240 • Bblid: 507839
Atdid
12966
Atd Number
ATD-3-5240
Bblid
507839
Inspectionid
360568
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-07-24T11:59:22.000
Cb
15
House Num
4307
Onstname
BEDFORD AVE.
Atddismissed
No
13173
Atdid: 13173 • Atd Number: ATD-3-5360 • Bblid: 277813
Atdid
13173
Atd Number
ATD-3-5360
Bblid
277813
Inspectionid
361738
Inspect Date
2023-08-08T00:00:00.000
Atdissuedate
2023-08-08T08:34:38.000
Cb
6
House Num
410
Onstname
4TH ST.
Atddismissed
No
18627
Atdid: 18627 • Atd Number: ATD-3-7338 • Bblid: 511530
Atdid
18627
Atd Number
ATD-3-7338
Bblid
511530
Inspectionid
406176
Inspect Date
2025-09-06T00:00:00.000
Atdissuedate
2025-09-19T12:12:50.000
Cb
15
House Num
2530
Onstname
E. 28TH ST.
Atddismissed
No
16164
Atdid: 16164 • Atd Number: ATD-4-6341 • Bblid: 737429
Atdid
16164
Atd Number
ATD-4-6341
Bblid
737429
Inspectionid
383601
Inspect Date
2024-09-24T00:00:00.000
Atdissuedate
2024-10-01T10:55:35.000
Cb
8
House Num
147-10
Onstname
77TH RD.
Atddismissed
No
16329
Atdid: 16329 • Atd Number: ATD-3-6402 • Bblid: 279597
Atdid
16329
Atd Number
ATD-3-6402
Bblid
279597
Inspectionid
384684
Inspect Date
2022-09-14T00:00:00.000
Atdissuedate
2024-11-02T12:49:57.000
Cb
6
House Num
229
Onstname
12TH ST.
Atddismissed
No
10599
Atdid: 10599 • Atd Number: ATD-3-4024 • Bblid: 319102
Atdid
10599
Atd Number
ATD-3-4024
Bblid
319102
Inspectionid
340894
Inspect Date
2022-07-26T00:00:00.000
Atdissuedate
2022-08-04T14:41:14.000
Cb
3
House Num
313
Onstname
JEFFERSON AVE.
Atddismissed
No
8908
Atdid: 8908 • Atd Number: ATD-4-4033 • Bblid: 761589
Atdid
8908
Atd Number
ATD-4-4033
Bblid
761589
Inspectionid
332127
Inspect Date
2019-02-20T00:00:00.000
Atdissuedate
2022-01-28T09:13:15.000
Cb
13
House Num
88-05
Onstname
239TH ST.
Atddismissed
Yes
Atddismissedon
2023-10-03T11:31:15.000
9879
Atdid: 9879 • Atd Number: ATD-4-4486 • Bblid: 674097
Atdid
9879
Atd Number
ATD-4-4486
Bblid
674097
Inspectionid
334958
Inspect Date
2021-09-30T00:00:00.000
Atdissuedate
2022-04-15T09:57:30.000
Cb
5
House Num
78-21
Onstname
65TH ST.
Atddismissed
No
18315
Atdid: 18315 • Atd Number: ATD-4-7237 • Bblid: 647618
Atdid
18315
Atd Number
ATD-4-7237
Bblid
647618
Inspectionid
404151
Inspect Date
2025-08-08T00:00:00.000
Atdissuedate
2025-08-13T15:35:56.000
Cb
5
House Num
61-11
Onstname
75TH PL.
Atddismissed
No
12161
Atdid: 12161 • Atd Number: ATD-3-4992 • Bblid: 258017
Atdid
12161
Atd Number
ATD-3-4992
Bblid
258017
Inspectionid
356704
Inspect Date
2023-05-05T00:00:00.000
Atdissuedate
2023-05-05T14:08:28.000
Cb
2
House Num
185
Onstname
WYCKOFF ST.
Atddismissed
No