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
16690
Atdid: 16690 • Atd Number: ATD-3-6544 • Bblid: 291464
Atdid
16690
Atd Number
ATD-3-6544
Bblid
291464
Inspectionid
388645
Inspect Date
2025-01-02T00:00:00.000
Atdissuedate
2025-01-09T11:16:47.000
Cb
8
House Num
265
Onstname
NEW YORK AVE.
Atddismissed
No
13543
Atdid: 13543 • Atd Number: ATD-4-5582 • Bblid: 887119
Atdid
13543
Atd Number
ATD-4-5582
Bblid
887119
Inspectionid
364904
Inspect Date
2023-09-20T00:00:00.000
Atdissuedate
2023-10-04T15:13:01.000
Cb
13
House Num
135-38
Onstname
223RD ST.
Atddismissed
No
9212
Atdid: 9212 • Atd Number: ATD-3-3362 • Bblid: 443906
Atdid
9212
Atd Number
ATD-3-3362
Bblid
443906
Inspectionid
332870
Inspect Date
2021-01-21T00:00:00.000
Atdissuedate
2022-02-28T17:47:47.000
Cb
10
House Num
7030
Onstname
PERRY TER.
Atddismissed
No
11220
Atdid: 11220 • Atd Number: ATD-3-4527 • Bblid: 553696
Atdid
11220
Atd Number
ATD-3-4527
Bblid
553696
Inspectionid
346539
Inspect Date
2022-09-15T00:00:00.000
Atdissuedate
2022-10-20T09:39:19.000
Cb
18
House Num
3614
Onstname
AVENUE T.
Atddismissed
No
14587
Atdid: 14587 • Atd Number: ATD-4-6088 • Bblid: 679967
Atdid
14587
Atd Number
ATD-4-6088
Bblid
679967
Inspectionid
378383
Inspect Date
2024-06-04T00:00:00.000
Atdissuedate
2024-06-13T09:48:16.000
Cb
7
House Num
122-07
Onstname
6TH AVE.
Atddismissed
No
14190
Atdid: 14190 • Atd Number: ATD-3-5850 • Bblid: 532374
Atdid
14190
Atd Number
ATD-3-5850
Bblid
532374
Inspectionid
373807
Inspect Date
2024-03-20T00:00:00.000
Atdissuedate
2024-03-20T14:46:05.000
Cb
18
House Num
617
Onstname
E. 83RD ST.
Atddismissed
No
1711
Atdid: 1711 • Atd Number: ATD-3-854 • Bblid: 319102
Atdid
1711
Atd Number
ATD-3-854
Bblid
319102
Violationid
54226
Atdissuedate
2020-08-13T00:00:00.000
Cb
3
House Num
313
Onstname
JEFFERSON AVENUE
Atddismissed
Yes
Atddismissedon
2022-08-04T14:40:53.000
18602
Atdid: 18602 • Atd Number: ATD-3-7328 • Bblid: 292401
Atdid
18602
Atd Number
ATD-3-7328
Bblid
292401
Violationid
300218
Reinspectionid
38986
Inspect Date
2025-09-15T13:22:37.000
Atdissuedate
2025-09-15T13:22:37.000
Cb
8
House Num
829
Onstname
EASTERN PARKWAY
Atddismissed
No
8725
Atdid: 8725 • Atd Number: ATD-3-3203 • Bblid: 258877
Atdid
8725
Atd Number
ATD-3-3203
Bblid
258877
Inspectionid
331052
Inspect Date
2021-12-21T00:00:00.000
Atdissuedate
2021-12-27T14:11:06.000
Cb
6
House Num
89
Onstname
BUTLER ST.
Atddismissed
Yes
Atddismissedon
2022-05-24T09:37:32.000
11743
Atdid: 11743 • Atd Number: ATD-3-4772 • Bblid: 472215
Atdid
11743
Atd Number
ATD-3-4772
Bblid
472215
Inspectionid
352443
Inspect Date
2023-03-01T00:00:00.000
Atdissuedate
2023-03-08T10:23:06.000
Cb
11
House Num
2339
Onstname
62ND ST.
Atddismissed
No
9563
Atdid: 9563 • Atd Number: ATD-3-3554 • Bblid: 310880
Atdid
9563
Atd Number
ATD-3-3554
Bblid
310880
Inspectionid
333651
Inspect Date
2021-08-24T00:00:00.000
Atdissuedate
2022-03-11T10:06:35.000
Cb
3
House Num
471A
Onstname
MAC DONOUGH STREET
Atddismissed
No
14681
Atdid: 14681 • Atd Number: ATD-3-6095 • Bblid: 462976
Atdid
14681
Atd Number
ATD-3-6095
Bblid
462976
Inspectionid
378990
Inspect Date
2024-06-28T00:00:00.000
Atdissuedate
2024-07-02T12:54:22.000
Cb
11
House Num
1433
Onstname
83RD ST.
Atddismissed
No
12929
Atdid: 12929 • Atd Number: ATD-3-5216 • Bblid: 422439
Atdid
12929
Atd Number
ATD-3-5216
Bblid
422439
Inspectionid
360348
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T11:05:04.000
Cb
12
House Num
1540
Onstname
44TH ST.
Atddismissed
No
16362
Atdid: 16362 • Atd Number: ATD-4-6422 • Bblid: 678511
Atdid
16362
Atd Number
ATD-4-6422
Bblid
678511
Inspectionid
385012
Inspect Date
2024-10-31T00:00:00.000
Atdissuedate
2024-11-14T12:44:48.000
Cb
6
House Num
89-13
Onstname
70TH AVE.
Atddismissed
No
17732
Atdid: 17732 • Atd Number: ATD-4-6979 • Bblid: 726883
Atdid
17732
Atd Number
ATD-4-6979
Bblid
726883
Inspectionid
398335
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-05-23T13:34:51.000
Cb
11
House Num
32-42
Onstname
BELL BLVD.
Atddismissed
No
10855
Atdid: 10855 • Atd Number: ATD-3-4226 • Bblid: 311027
Atdid
10855
Atd Number
ATD-3-4226
Bblid
311027
Inspectionid
343426
Inspect Date
2022-09-10T00:00:00.000
Atdissuedate
2022-09-12T10:38:59.000
Cb
3
House Num
158
Onstname
DECATUR ST.
Atddismissed
No
14324
Atdid: 14324 • Atd Number: ATD-3-5906 • Bblid: 279268
Atdid
14324
Atd Number
ATD-3-5906
Bblid
279268
Inspectionid
375892
Inspect Date
2024-04-10T00:00:00.000
Atdissuedate
2024-04-23T11:01:40.000
Cb
6
House Num
286
Onstname
10TH ST.
Atddismissed
No
9024
Atdid: 9024 • Atd Number: ATD-3-3300 • Bblid: 509705
Atdid
9024
Atd Number
ATD-3-3300
Bblid
509705
Inspectionid
332386
Inspect Date
2019-09-04T00:00:00.000
Atdissuedate
2022-02-11T14:24:41.000
Cb
15
House Num
2433
Onstname
E. 15TH ST.
Atddismissed
No
17143
Atdid: 17143 • Atd Number: ATD-3-6783 • Bblid: 531240
Atdid
17143
Atd Number
ATD-3-6783
Bblid
531240
Inspectionid
392611
Inspect Date
2022-07-12T00:00:00.000
Atdissuedate
2025-03-31T09:17:26.000
Cb
18
House Num
589
Onstname
E. 85TH ST.
Atddismissed
No
17832
Atdid: 17832 • Atd Number: ATD-3-7029 • Bblid: 266645
Atdid
17832
Atd Number
ATD-3-7029
Bblid
266645
Inspectionid
399423
Inspect Date
2025-05-29T00:00:00.000
Atdissuedate
2025-06-09T08:13:19.000
Cb
7
House Num
661
Onstname
48TH ST.
Atddismissed
No
11294
Atdid: 11294 • Atd Number: ATD-3-4583 • Bblid: 386176
Atdid
11294
Atd Number
ATD-3-4583
Bblid
386176
Inspectionid
347245
Inspect Date
2022-10-21T00:00:00.000
Atdissuedate
2022-10-31T14:10:49.000
Cb
5
House Num
722
Onstname
ALABAMA AVE.
Atddismissed
No
14570
Atdid: 14570 • Atd Number: ATD-2-1284 • Bblid: 165157
Atdid
14570
Atd Number
ATD-2-1284
Bblid
165157
Inspectionid
378318
Inspect Date
2024-05-18T00:00:00.000
Atdissuedate
2024-06-10T12:57:28.000
Cb
8
House Num
3135
Onstname
KINGSBRIDGE TER.
Atddismissed
No
14857
Atdid: 14857 • Atd Number: ATD-4-6194 • Bblid: 746564
Atdid
14857
Atd Number
ATD-4-6194
Bblid
746564
Inspectionid
380148
Inspect Date
2024-08-02T00:00:00.000
Atdissuedate
2024-08-05T11:48:40.000
Cb
8
House Num
64-31
Onstname
181ST ST.
Atddismissed
No
16743
Atdid: 16743 • Atd Number: ATD-4-6587 • Bblid: 795597
Atdid
16743
Atd Number
ATD-4-6587
Bblid
795597
Inspectionid
388958
Inspect Date
2025-01-02T00:00:00.000
Atdissuedate
2025-01-24T14:49:43.000
Cb
9
House Num
94-27
Onstname
121ST ST.
Atddismissed
Yes
Atddismissedon
2025-05-07T14:50:26.000
17876
Atdid: 17876 • Atd Number: ATD-4-7063 • Bblid: 768481
Atdid
17876
Atd Number
ATD-4-7063
Bblid
768481
Inspectionid
400263
Inspect Date
2025-06-11T00:00:00.000
Atdissuedate
2025-06-13T08:58:56.000
Cb
11
House Num
262-23
Onstname
57TH AVE.
Atddismissed
No
2564
Atdid: 2564 • Atd Number: ATD-3-1707 • Bblid: 517319
Atdid
2564
Atd Number
ATD-3-1707
Bblid
517319
Violationid
179707
Atdissuedate
2020-08-20T00:00:00.000
Cb
18
House Num
3101
Onstname
AVENUE M
Atddismissed
Yes
Atddismissedon
2022-12-08T16:07:41.000
13594
Atdid: 13594 • Atd Number: ATD-3-5602 • Bblid: 396103
Atdid
13594
Atd Number
ATD-3-5602
Bblid
396103
Inspectionid
365451
Inspect Date
2023-09-16T00:00:00.000
Atdissuedate
2023-10-17T14:06:45.000
Cb
17
House Num
5619
Onstname
BEVERLEY RD.
Atddismissed
No
13410
Atdid: 13410 • Atd Number: ATD-3-5525 • Bblid: 1109920
Atdid
13410
Atd Number
ATD-3-5525
Bblid
1109920
Inspectionid
363623
Inspect Date
2023-09-15T00:00:00.000
Atdissuedate
2023-09-15T12:04:29.000
Cb
0
House Num
217
Onstname
LAFAYETTE AVE.
Atddismissed
Yes
Atddismissedon
2023-09-15T12:07:16.000
9017
Atdid: 9017 • Atd Number: ATD-4-4092 • Bblid: 898824
Atdid
9017
Atd Number
ATD-4-4092
Bblid
898824
Inspectionid
332377
Inspect Date
2019-06-26T00:00:00.000
Atdissuedate
2022-02-10T16:19:20.000
Cb
13
House Num
148-46
Onstname
HUXLEY ST.
Atddismissed
No
16334
Atdid: 16334 • Atd Number: ATD-5-887 • Bblid: 948569
Atdid
16334
Atd Number
ATD-5-887
Bblid
948569
Inspectionid
384705
Inspect Date
2024-11-01T00:00:00.000
Atdissuedate
2024-11-02T15:09:07.000
Cb
2
House Num
199
Onstname
GRAVES ST.
Atddismissed
No
17414
Atdid: 17414 • Atd Number: ATD-4-6793 • Bblid: 678915
Atdid
17414
Atd Number
ATD-4-6793
Bblid
678915
Inspectionid
395103
Inspect Date
2025-04-22T00:00:00.000
Atdissuedate
2025-04-22T15:09:02.000
Cb
6
House Num
91-61
Onstname
71ST RD.
Atddismissed
No
8557
Atdid: 8557 • Atd Number: ATD-2-847 • Bblid: 208816
Atdid
8557
Atd Number
ATD-2-847
Bblid
208816
Inspectionid
330365
Inspect Date
2021-11-30T00:00:00.000
Atdissuedate
2021-12-07T13:53:37.000
Cb
12
House Num
3028
Onstname
BRONX PARK E.
Atddismissed
Yes
Atddismissedon
2022-05-24T07:36:56.000
9173
Atdid: 9173 • Atd Number: ATD-5-611 • Bblid: 1028694
Atdid
9173
Atd Number
ATD-5-611
Bblid
1028694
Inspectionid
332794
Inspect Date
2022-02-26T00:00:00.000
Atdissuedate
2022-02-26T14:45:01.000
Cb
3
House Num
262
Onstname
ANNADALE RD.
Atddismissed
No
16571
Atdid: 16571 • Atd Number: ATD-3-6501 • Bblid: 297900
Atdid
16571
Atd Number
ATD-3-6501
Bblid
297900
Inspectionid
386999
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2024-12-20T10:25:28.000
Cb
8
House Num
1235
Onstname
LINCOLN PL.
Atddismissed
No
9596
Atdid: 9596 • Atd Number: ATD-4-4303 • Bblid: 772871
Atdid
9596
Atd Number
ATD-4-4303
Bblid
772871
Inspectionid
333736
Inspect Date
2019-03-01T00:00:00.000
Atdissuedate
2022-03-14T16:03:11.000
Cb
13
House Num
257-11
Onstname
80TH AVE.
Atddismissed
No
13827
Atdid: 13827 • Atd Number: ATD-4-5718 • Bblid: 631254
Atdid
13827
Atd Number
ATD-4-5718
Bblid
631254
Inspectionid
370294
Inspect Date
2023-11-24T00:00:00.000
Atdissuedate
2024-01-02T13:39:46.000
Cb
2
House Num
50-09
Onstname
48TH ST.
Atddismissed
No
8682
Atdid: 8682 • Atd Number: ATD-5-584 • Bblid: 985716
Atdid
8682
Atd Number
ATD-5-584
Bblid
985716
Inspectionid
330851
Inspect Date
2021-08-11T00:00:00.000
Atdissuedate
2021-12-17T10:35:25.000
Cb
2
House Num
11
Onstname
JACKSON AVE.
Atddismissed
No
8878
Atdid: 8878 • Atd Number: ATD-4-4018 • Bblid: 760714
Atdid
8878
Atd Number
ATD-4-4018
Bblid
760714
Inspectionid
331910
Inspect Date
2019-07-18T00:00:00.000
Atdissuedate
2022-01-25T13:08:10.000
Cb
13
House Num
233-72
Onstname
87TH AVE.
Atddismissed
No
17609
Atdid: 17609 • Atd Number: ATD-4-6881 • Bblid: 647556
Atdid
17609
Atd Number
ATD-4-6881
Bblid
647556
Inspectionid
397079
Inspect Date
2025-04-02T00:00:00.000
Atdissuedate
2025-05-15T09:46:12.000
Cb
5
House Num
61-38
Onstname
76TH ST.
Atddismissed
No
18291
Atdid: 18291 • Atd Number: ATD-4-7227 • Bblid: 854256
Atdid
18291
Atd Number
ATD-4-7227
Bblid
854256
Inspectionid
403943
Inspect Date
2025-07-31T00:00:00.000
Atdissuedate
2025-08-11T11:58:29.000
Cb
10
House Num
116-15
Onstname
127TH ST.
Atddismissed
No
13026
Atdid: 13026 • Atd Number: ATD-3-5270 • Bblid: 509805
Atdid
13026
Atd Number
ATD-3-5270
Bblid
509805
Inspectionid
361018
Inspect Date
2023-07-11T00:00:00.000
Atdissuedate
2023-07-28T12:09:16.000
Cb
15
House Num
1706
Onstname
AVENUE X.
Atddismissed
No
11689
Atdid: 11689 • Atd Number: ATD-4-5001 • Bblid: 679891
Atdid
11689
Atd Number
ATD-4-5001
Bblid
679891
Inspectionid
351838
Inspect Date
2023-01-13T00:00:00.000
Atdissuedate
2023-02-21T12:44:33.000
Cb
7
House Num
121-25
Onstname
8TH AVE.
Atddismissed
No
18221
Atdid: 18221 • Atd Number: ATD-2-1436 • Bblid: 246137
Atdid
18221
Atd Number
ATD-2-1436
Bblid
246137
Violationid
301400
Reinspectionid
39560
Inspect Date
2025-07-31T10:02:36.000
Atdissuedate
2025-07-31T10:02:36.000
Cb
8
House Num
6135
Onstname
SPENCER AVENUE
Atddismissed
No
16409
Atdid: 16409 • Atd Number: ATD-5-895 • Bblid: 1056174
Atdid
16409
Atd Number
ATD-5-895
Bblid
1056174
Inspectionid
385163
Inspect Date
2024-11-15T00:00:00.000
Atdissuedate
2024-11-19T09:21:57.000
Cb
3
House Num
249
Onstname
HECKER ST.
Atddismissed
No
12544
Atdid: 12544 • Atd Number: ATD-4-5349 • Bblid: 710706
Atdid
12544
Atd Number
ATD-4-5349
Bblid
710706
Inspectionid
358435
Inspect Date
2023-06-07T00:00:00.000
Atdissuedate
2023-06-12T15:54:27.000
Cb
11
House Num
36-24
Onstname
191ST ST.
Atddismissed
Yes
Atddismissedon
2025-09-08T10:12:33.000
16229
Atdid: 16229 • Atd Number: ATD-3-6349 • Bblid: 317288
Atdid
16229
Atd Number
ATD-3-6349
Bblid
317288
Inspectionid
384151
Inspect Date
2024-10-08T00:00:00.000
Atdissuedate
2024-10-15T12:09:54.000
Cb
3
House Num
339
Onstname
TOMPKINS AVE.
Atddismissed
No
9546
Atdid: 9546 • Atd Number: ATD-4-4290 • Bblid: 761491
Atdid
9546
Atd Number
ATD-4-4290
Bblid
761491
Inspectionid
333632
Inspect Date
2019-06-27T00:00:00.000
Atdissuedate
2022-03-10T15:42:32.000
Cb
13
House Num
88-24
Onstname
239TH ST.
Atddismissed
No
12573
Atdid: 12573 • Atd Number: ATD-2-1150 • Bblid: 152454
Atdid
12573
Atd Number
ATD-2-1150
Bblid
152454
Inspectionid
358574
Inspect Date
2023-06-15T00:00:00.000
Atdissuedate
2023-06-15T09:50:37.000
Cb
4
House Num
276
Onstname
E. 171ST ST.
Atddismissed
No
14533
Atdid: 14533 • Atd Number: ATD-4-6079 • Bblid: 794562
Atdid
14533
Atd Number
ATD-4-6079
Bblid
794562
Inspectionid
377823
Inspect Date
2024-05-22T00:00:00.000
Atdissuedate
2024-05-22T12:14:09.000
Cb
9
House Num
95-49
Onstname
112TH ST.
Atddismissed
No
14448
Atdid: 14448 • Atd Number: ATD-4-6030 • Bblid: 585191
Atdid
14448
Atd Number
ATD-4-6030
Bblid
585191
Inspectionid
377189
Inspect Date
2024-04-09T00:00:00.000
Atdissuedate
2024-05-09T14:50:11.000
Cb
1
House Num
22-32
Onstname
43RD ST.
Atddismissed
No