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
16709
Atdid: 16709 • Atd Number: ATD-4-6577 • Bblid: 826314
Atdid
16709
Atd Number
ATD-4-6577
Bblid
826314
Inspectionid
388767
Inspect Date
2024-12-27T00:00:00.000
Atdissuedate
2025-01-17T12:27:28.000
Cb
13
House Num
94-38
Onstname
216TH ST.
Atddismissed
No
18564
Atdid: 18564 • Atd Number: ATD-2-1472 • Bblid: 202040
Atdid
18564
Atd Number
ATD-2-1472
Bblid
202040
Inspectionid
405602
Inspect Date
2025-08-29T00:00:00.000
Atdissuedate
2025-09-09T15:55:15.000
Cb
11
House Num
1951
Onstname
YATES AVE.
Atddismissed
No
11052
Atdid: 11052 • Atd Number: ATD-3-4402 • Bblid: 297711
Atdid
11052
Atd Number
ATD-3-4402
Bblid
297711
Inspectionid
344770
Inspect Date
2022-09-28T00:00:00.000
Atdissuedate
2022-09-29T13:41:42.000
Cb
8
House Num
909
Onstname
EASTERN PKWY.
Atddismissed
No
16574
Atdid: 16574 • Atd Number: ATD-3-6504 • Bblid: 297880
Atdid
16574
Atd Number
ATD-3-6504
Bblid
297880
Inspectionid
387002
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2024-12-20T10:36:07.000
Cb
8
House Num
1271
Onstname
LINCOLN PL.
Atddismissed
Yes
Atddismissedon
2025-08-05T12:59:21.000
13419
Atdid: 13419 • Atd Number: ATD-4-5531 • Bblid: 586006
Atdid
13419
Atd Number
ATD-4-5531
Bblid
586006
Inspectionid
363732
Inspect Date
2023-08-07T00:00:00.000
Atdissuedate
2023-09-18T12:31:12.000
Cb
1
House Num
41-17
Onstname
20TH AVE.
Atddismissed
No
9589
Atdid: 9589 • Atd Number: ATD-3-3565 • Bblid: 263052
Atdid
9589
Atd Number
ATD-3-3565
Bblid
263052
Inspectionid
333718
Inspect Date
2022-02-10T00:00:00.000
Atdissuedate
2022-03-14T13:07:55.000
Cb
7
House Num
678
Onstname
4TH AVE.
Atddismissed
No
9167
Atdid: 9167 • Atd Number: ATD-3-3342 • Bblid: 421098
Atdid
9167
Atd Number
ATD-3-3342
Bblid
421098
Inspectionid
332788
Inspect Date
2019-07-30T00:00:00.000
Atdissuedate
2022-02-25T14:28:57.000
Cb
12
House Num
507
Onstname
AVENUE F.
Atddismissed
No
10613
Atdid: 10613 • Atd Number: ATD-3-4033 • Bblid: 342882
Atdid
10613
Atd Number
ATD-3-4033
Bblid
342882
Inspectionid
341013
Inspect Date
2022-07-12T00:00:00.000
Atdissuedate
2022-08-08T10:52:55.000
Cb
1
House Num
579
Onstname
LEONARD ST.
Atddismissed
No
14241
Atdid: 14241 • Atd Number: ATD-4-5935 • Bblid: 591079
Atdid
14241
Atd Number
ATD-4-5935
Bblid
591079
Inspectionid
374767
Inspect Date
2024-03-14T00:00:00.000
Atdissuedate
2024-04-04T11:47:09.000
Cb
1
House Num
25-59
Onstname
14TH ST.
Atddismissed
No
4960
Atdid: 4960 • Atd Number: ATD-4-1491 • Bblid: 589860
Atdid
4960
Atd Number
ATD-4-1491
Bblid
589860
Violationid
210298
Atdissuedate
2020-05-01T00:00:00.000
Cb
1
House Num
22-55
Onstname
CRESCENT STREET
Atddismissed
Yes
Atddismissedon
2024-03-28T08:49:48.000
9113
Atdid: 9113 • Atd Number: ATD-4-4162 • Bblid: 657414
Atdid
9113
Atd Number
ATD-4-4162
Bblid
657414
Inspectionid
332664
Inspect Date
2019-06-21T00:00:00.000
Atdissuedate
2022-02-22T15:12:54.000
Cb
6
House Num
68-56
Onstname
EXETER ST.
Atddismissed
No
18447
Atdid: 18447 • Atd Number: ATD-4-7302 • Bblid: 588980
Atdid
18447
Atd Number
ATD-4-7302
Bblid
588980
Inspectionid
404968
Inspect Date
2025-08-28T00:00:00.000
Atdissuedate
2025-08-28T12:38:02.000
Cb
1
House Num
20-62
Onstname
27TH ST.
Atddismissed
No
12925
Atdid: 12925 • Atd Number: ATD-3-5212 • Bblid: 431764
Atdid
12925
Atd Number
ATD-3-5212
Bblid
431764
Inspectionid
360344
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T10:43:33.000
Cb
12
House Num
4319
Onstname
14TH AVE.
Atddismissed
No
11749
Atdid: 11749 • Atd Number: ATD-3-4777 • Bblid: 296950
Atdid
11749
Atd Number
ATD-3-4777
Bblid
296950
Inspectionid
352526
Inspect Date
2023-03-09T00:00:00.000
Atdissuedate
2023-03-09T11:20:19.000
Cb
8
House Num
1510
Onstname
PROSPECT PL.
Atddismissed
No
17537
Atdid: 17537 • Atd Number: ATD-4-6849 • Bblid: 678614
Atdid
17537
Atd Number
ATD-4-6849
Bblid
678614
Inspectionid
396273
Inspect Date
2025-04-25T00:00:00.000
Atdissuedate
2025-05-05T14:16:46.000
Cb
6
House Num
97-14
Onstname
72ND DR.
Atddismissed
No
14800
Atdid: 14800 • Atd Number: ATD-3-6140 • Bblid: 480878
Atdid
14800
Atd Number
ATD-3-6140
Bblid
480878
Inspectionid
379844
Inspect Date
2024-07-17T00:00:00.000
Atdissuedate
2024-07-27T09:48:49.000
Cb
14
House Num
1076
Onstname
E. 16TH ST.
Atddismissed
No
16764
Atdid: 16764 • Atd Number: ATD-3-6569 • Bblid: 260682
Atdid
16764
Atd Number
ATD-3-6569
Bblid
260682
Violationid
42222
Inspectionid
389210
Inspect Date
2025-02-01T07:27:15.000
Atdissuedate
2025-02-01T07:27:15.000
Cb
6
House Num
123 A
Onstname
SECOND PLACE
Atddismissed
No
16341
Atdid: 16341 • Atd Number: ATD-4-6412 • Bblid: 869139
Atdid
16341
Atd Number
ATD-4-6412
Bblid
869139
Inspectionid
384796
Inspect Date
2024-10-23T00:00:00.000
Atdissuedate
2024-11-04T12:38:12.000
Cb
12
House Num
155-18
Onstname
116TH DR.
Atddismissed
No
11975
Atdid: 11975 • Atd Number: ATD-3-4901 • Bblid: 554994
Atdid
11975
Atd Number
ATD-3-4901
Bblid
554994
Inspectionid
354428
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-04-05T10:52:14.000
Cb
18
House Num
2663
Onstname
E. 66TH ST.
Atddismissed
Yes
Atddismissedon
2023-06-13T07:50:59.000
13476
Atdid: 13476 • Atd Number: ATD-4-5548 • Bblid: 837189
Atdid
13476
Atd Number
ATD-4-5548
Bblid
837189
Inspectionid
364268
Inspect Date
2023-09-05T00:00:00.000
Atdissuedate
2023-09-25T14:30:36.000
Cb
13
House Num
114-31
Onstname
209TH ST.
Atddismissed
No
10670
Atdid: 10670 • Atd Number: ATD-3-4068 • Bblid: 519650
Atdid
10670
Atd Number
ATD-3-4068
Bblid
519650
Inspectionid
341783
Inspect Date
2022-08-17T00:00:00.000
Atdissuedate
2022-08-22T09:18:47.000
Cb
18
House Num
1575
Onstname
E. 36TH ST.
Atddismissed
No
10713
Atdid: 10713 • Atd Number: ATD-3-4096 • Bblid: 269526
Atdid
10713
Atd Number
ATD-3-4096
Bblid
269526
Inspectionid
342239
Inspect Date
2022-05-12T00:00:00.000
Atdissuedate
2022-08-30T08:17:35.000
Cb
7
House Num
469
Onstname
56TH ST.
Atddismissed
No
14851
Atdid: 14851 • Atd Number: ATD-4-6191 • Bblid: 742750
Atdid
14851
Atd Number
ATD-4-6191
Bblid
742750
Inspectionid
380127
Inspect Date
2024-08-01T00:00:00.000
Atdissuedate
2024-08-05T11:18:19.000
Cb
8
House Num
166-15
Onstname
69TH AVE.
Atddismissed
Yes
Atddismissedon
2025-01-31T12:34:55.000
10153
Atdid: 10153 • Atd Number: ATD-3-3767 • Bblid: 362264
Atdid
10153
Atd Number
ATD-3-3767
Bblid
362264
Inspectionid
336844
Inspect Date
2022-05-20T00:00:00.000
Atdissuedate
2022-05-23T14:38:18.000
Cb
4
House Num
79
Onstname
COOPER ST.
Atddismissed
Yes
Atddismissedon
2022-08-02T17:14:24.000
14519
Atdid: 14519 • Atd Number: ATD-3-5991 • Bblid: 291486
Atdid
14519
Atd Number
ATD-3-5991
Bblid
291486
Inspectionid
377749
Inspect Date
2024-05-18T00:00:00.000
Atdissuedate
2024-05-21T15:44:32.000
Cb
8
House Num
970
Onstname
SAINT JOHNS PL.
Atddismissed
No
16737
Atdid: 16737 • Atd Number: ATD-3-6564 • Bblid: 277663
Atdid
16737
Atd Number
ATD-3-6564
Bblid
277663
Inspectionid
388934
Inspect Date
2025-01-04T00:00:00.000
Atdissuedate
2025-01-24T11:06:18.000
Cb
6
House Num
340
Onstname
4 STREET
Atddismissed
No
14740
Atdid: 14740 • Atd Number: ATD-4-6146 • Bblid: 740562
Atdid
14740
Atd Number
ATD-4-6146
Bblid
740562
Inspectionid
379332
Inspect Date
2024-05-31T00:00:00.000
Atdissuedate
2024-07-15T11:19:25.000
Cb
8
House Num
153-05
Onstname
77TH RD.
Atddismissed
No
17463
Atdid: 17463 • Atd Number: ATD-4-6817 • Bblid: 678885
Atdid
17463
Atd Number
ATD-4-6817
Bblid
678885
Inspectionid
395448
Inspect Date
2025-03-25T00:00:00.000
Atdissuedate
2025-04-28T11:24:46.000
Cb
6
House Num
70-69
Onstname
WALNUT ST.
Atddismissed
No
9518
Atdid: 9518 • Atd Number: ATD-4-4276 • Bblid: 757193
Atdid
9518
Atd Number
ATD-4-4276
Bblid
757193
Inspectionid
333543
Inspect Date
2021-06-05T00:00:00.000
Atdissuedate
2022-03-09T16:21:00.000
Cb
11
House Num
61-24
Onstname
228TH ST.
Atddismissed
No
10135
Atdid: 10135 • Atd Number: ATD-3-3749 • Bblid: 305841
Atdid
10135
Atd Number
ATD-3-3749
Bblid
305841
Inspectionid
336799
Inspect Date
2022-05-18T00:00:00.000
Atdissuedate
2022-05-23T12:20:54.000
Cb
16
House Num
14
Onstname
JARDINE PL.
Atddismissed
No
11971
Atdid: 11971 • Atd Number: ATD-3-4899 • Bblid: 563031
Atdid
11971
Atd Number
ATD-3-4899
Bblid
563031
Inspectionid
354409
Inspect Date
2023-04-04T00:00:00.000
Atdissuedate
2023-04-04T12:19:11.000
Cb
15
House Num
301
Onstname
ALLEN AVE.
Atddismissed
No
12218
Atdid: 12218 • Atd Number: ATD-3-5004 • Bblid: 328534
Atdid
12218
Atd Number
ATD-3-5004
Bblid
328534
Inspectionid
356941
Inspect Date
2023-05-11T00:00:00.000
Atdissuedate
2023-05-11T15:06:26.000
Cb
2
House Num
25
Onstname
S. PORTLAND AVE.
Atddismissed
No
13947
Atdid: 13947 • Atd Number: ATD-3-5731 • Bblid: 372553
Atdid
13947
Atd Number
ATD-3-5731
Bblid
372553
Inspectionid
371577
Inspect Date
2024-02-07T00:00:00.000
Atdissuedate
2024-02-14T08:37:39.000
Cb
5
House Num
56
Onstname
BARBEY ST.
Atddismissed
No
14856
Atdid: 14856 • Atd Number: ATD-4-6193 • Bblid: 745421
Atdid
14856
Atd Number
ATD-4-6193
Bblid
745421
Inspectionid
380137
Inspect Date
2024-08-02T00:00:00.000
Atdissuedate
2024-08-05T11:38:48.000
Cb
8
House Num
176-16
Onstname
76TH AVE.
Atddismissed
No
17036
Atdid: 17036 • Atd Number: ATD-4-6684 • Bblid: 590157
Atdid
17036
Atd Number
ATD-4-6684
Bblid
590157
Inspectionid
392305
Inspect Date
2025-03-21T00:00:00.000
Atdissuedate
2025-03-26T13:02:51.000
Cb
1
House Num
22-69
Onstname
21ST ST.
Atddismissed
Yes
Atddismissedon
2025-07-29T09:27:50.000
12719
Atdid: 12719 • Atd Number: ATD-3-5099 • Bblid: 305543
Atdid
12719
Atd Number
ATD-3-5099
Bblid
305543
Inspectionid
359136
Inspect Date
2023-06-16T00:00:00.000
Atdissuedate
2023-06-30T08:23:37.000
Cb
16
House Num
11A
Onstname
PLEASANT PL.
Atddismissed
No
15046
Atdid: 15046 • Atd Number: ATD-3-6276 • Bblid: 507875
Atdid
15046
Atd Number
ATD-3-6276
Bblid
507875
Violationid
293036
Reinspectionid
37526
Inspect Date
2024-09-16T10:13:01.000
Atdissuedate
2024-09-16T10:13:01.000
Cb
15
House Num
4295
Onstname
BEDFORD AVENUE
Atddismissed
No
17824
Atdid: 17824 • Atd Number: ATD-3-7025 • Bblid: 457124
Atdid
17824
Atd Number
ATD-3-7025
Bblid
457124
Inspectionid
399383
Inspect Date
2025-06-07T00:00:00.000
Atdissuedate
2025-06-07T12:39:28.000
Cb
11
House Num
1433
Onstname
73RD ST.
Atddismissed
No
13905
Atdid: 13905 • Atd Number: ATD-3-5716 • Bblid: 407136
Atdid
13905
Atd Number
ATD-3-5716
Bblid
407136
Inspectionid
371150
Inspect Date
2024-01-31T00:00:00.000
Atdissuedate
2024-01-31T08:46:09.000
Cb
9
House Num
148
Onstname
MAPLE ST.
Atddismissed
No
8687
Atdid: 8687 • Atd Number: ATD-4-3910 • Bblid: 884825
Atdid
8687
Atd Number
ATD-4-3910
Bblid
884825
Inspectionid
330856
Inspect Date
2019-06-26T00:00:00.000
Atdissuedate
2021-12-17T11:18:41.000
Cb
12
House Num
177-05
Onstname
137TH AVE.
Atddismissed
No
8962
Atdid: 8962 • Atd Number: ATD-4-4061 • Bblid: 665804
Atdid
8962
Atd Number
ATD-4-4061
Bblid
665804
Inspectionid
332263
Inspect Date
2019-07-31T00:00:00.000
Atdissuedate
2022-02-04T14:49:24.000
Cb
5
House Num
59-23
Onstname
MENAHAN ST.
Atddismissed
No
8850
Atdid: 8850 • Atd Number: ATD-4-3999 • Bblid: 753813
Atdid
8850
Atd Number
ATD-4-3999
Bblid
753813
Inspectionid
331769
Inspect Date
2018-10-23T00:00:00.000
Atdissuedate
2022-01-21T10:18:59.000
Cb
11
House Num
56-03
Onstname
202ND ST.
Atddismissed
No
16253
Atdid: 16253 • Atd Number: ATD-3-6351 • Bblid: 281866
Atdid
16253
Atd Number
ATD-3-6351
Bblid
281866
Inspectionid
384213
Inspect Date
2024-10-04T00:00:00.000
Atdissuedate
2024-10-17T15:59:11.000
Cb
6
House Num
846
Onstname
UNION ST.
Atddismissed
No
11113
Atdid: 11113 • Atd Number: ATD-4-4838 • Bblid: 858722
Atdid
11113
Atd Number
ATD-4-4838
Bblid
858722
Inspectionid
345331
Inspect Date
2022-09-29T00:00:00.000
Atdissuedate
2022-10-06T14:55:21.000
Cb
10
House Num
149-47
Onstname
114TH PL.
Atddismissed
No
9969
Atdid: 9969 • Atd Number: ATD-3-3656 • Bblid: 514257
Atdid
9969
Atd Number
ATD-3-3656
Bblid
514257
Inspectionid
335495
Inspect Date
2022-04-13T00:00:00.000
Atdissuedate
2022-04-25T11:46:38.000
Cb
14
House Num
960
Onstname
E. 26TH ST.
Atddismissed
No
17013
Atdid: 17013 • Atd Number: ATD-3-6681 • Bblid: 282906
Atdid
17013
Atd Number
ATD-3-6681
Bblid
282906
Inspectionid
392200
Inspect Date
2025-03-19T00:00:00.000
Atdissuedate
2025-03-25T13:10:07.000
Cb
6
House Num
568
Onstname
4TH ST.
Atddismissed
No
8486
Atdid: 8486 • Atd Number: ATD-3-3089 • Bblid: 315540
Atdid
8486
Atd Number
ATD-3-3089
Bblid
315540
Inspectionid
329597
Inspect Date
2021-11-10T00:00:00.000
Atdissuedate
2021-11-15T09:57:03.000
Cb
3
House Num
280
Onstname
CLIFTON PL.
Atddismissed
Yes
Atddismissedon
2021-11-15T09:57:13.000
14790
Atdid: 14790 • Atd Number: ATD-4-6174 • Bblid: 845014
Atdid
14790
Atd Number
ATD-4-6174
Bblid
845014
Violationid
293230
Reinspectionid
36770
Inspect Date
2024-07-25T13:00:52.000
Atdissuedate
2024-07-25T13:00:52.000
Cb
13
House Num
116-31
Onstname
219 STREET
Atddismissed
No
11284
Atdid: 11284 • Atd Number: ATD-4-4865 • Bblid: 672783
Atdid
11284
Atd Number
ATD-4-4865
Bblid
672783
Inspectionid
347070
Inspect Date
2022-10-19T00:00:00.000
Atdissuedate
2022-10-27T10:38:28.000
Cb
5
House Num
71-51
Onstname
70TH ST.
Atddismissed
No
14087
Atdid: 14087 • Atd Number: ATD-4-5879 • Bblid: 620530
Atdid
14087
Atd Number
ATD-4-5879
Bblid
620530
Inspectionid
372887
Inspect Date
2024-03-08T00:00:00.000
Atdissuedate
2024-03-08T12:45:19.000
Cb
4
House Num
88-37
Onstname
54TH AVE.
Atddismissed
No