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
9198
Atdid: 9198 • Atd Number: ATD-1-181 • Bblid: 75455
Atdid
9198
Atd Number
ATD-1-181
Bblid
75455
Inspectionid
332856
Inspect Date
2016-01-20T00:00:00.000
Atdissuedate
2022-02-28T17:34:44.000
Cb
7
House Num
112
Onstname
W. 88TH ST.
Atddismissed
No
12507
Atdid: 12507 • Atd Number: ATD-4-5333 • Bblid: 795949
Atdid
12507
Atd Number
ATD-4-5333
Bblid
795949
Inspectionid
358053
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T16:29:47.000
Cb
9
House Num
118-04
Onstname
ATLANTIC AVENUE
Atddismissed
No
10940
Atdid: 10940 • Atd Number: ATD-3-4303 • Bblid: 310043
Atdid
10940
Atd Number
ATD-3-4303
Bblid
310043
Inspectionid
344067
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-09-19T13:06:29.000
Cb
3
House Num
529
Onstname
MACON ST.
Atddismissed
No
17194
Atdid: 17194 • Atd Number: ATD-2-1361 • Bblid: 150467
Atdid
17194
Atd Number
ATD-2-1361
Bblid
150467
Inspectionid
392829
Inspect Date
2024-07-15T00:00:00.000
Atdissuedate
2025-03-31T14:57:28.000
Cb
2
House Num
1043
Onstname
BRYANT AVE.
Atddismissed
No
14667
Atdid: 14667 • Atd Number: ATD-4-6117 • Bblid: 738380
Atdid
14667
Atd Number
ATD-4-6117
Bblid
738380
Inspectionid
378892
Inspect Date
2024-06-26T00:00:00.000
Atdissuedate
2024-06-27T14:14:33.000
Cb
8
House Num
150-12
Onstname
GRAND CENTRAL PKWY.
Atddismissed
No
11407
Atdid: 11407 • Atd Number: ATD-1-239 • Bblid: 67882
Atdid
11407
Atd Number
ATD-1-239
Bblid
67882
Violationid
279067
Reinspectionid
33413
Inspect Date
2022-11-18T13:23:47.000
Atdissuedate
2022-11-18T13:23:47.000
Cb
7
House Num
117
Onstname
WEST 69 STREET
Atddismissed
Yes
Atddismissedon
2023-09-28T13:36:24.000
17110
Atdid: 17110 • Atd Number: ATD-3-6756 • Bblid: 399638
Atdid
17110
Atd Number
ATD-3-6756
Bblid
399638
Inspectionid
392507
Inspect Date
2024-05-20T00:00:00.000
Atdissuedate
2025-03-28T13:34:34.000
Cb
17
House Num
99
Onstname
E. 38TH ST.
Atddismissed
No
10433
Atdid: 10433 • Atd Number: ATD-3-3917 • Bblid: 310231
Atdid
10433
Atd Number
ATD-3-3917
Bblid
310231
Inspectionid
339260
Inspect Date
2022-07-12T00:00:00.000
Atdissuedate
2022-07-12T14:29:24.000
Cb
3
House Num
567
Onstname
MACON ST.
Atddismissed
No
13044
Atdid: 13044 • Atd Number: ATD-3-5288 • Bblid: 422486
Atdid
13044
Atd Number
ATD-3-5288
Bblid
422486
Inspectionid
361038
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T15:09:05.000
Cb
12
House Num
1642
Onstname
45TH ST.
Atddismissed
No
17512
Atdid: 17512 • Atd Number: ATD-3-6946 • Bblid: 295554
Atdid
17512
Atd Number
ATD-3-6946
Bblid
295554
Inspectionid
396031
Inspect Date
2025-05-01T00:00:00.000
Atdissuedate
2025-05-05T08:01:13.000
Cb
8
House Num
73
Onstname
BUFFALO AVE.
Atddismissed
No
9910
Atdid: 9910 • Atd Number: ATD-5-658 • Bblid: 1051766
Atdid
9910
Atd Number
ATD-5-658
Bblid
1051766
Inspectionid
335195
Inspect Date
2022-04-19T00:00:00.000
Atdissuedate
2022-04-19T14:34:16.000
Cb
3
House Num
258
Onstname
BEDELL AVE.
Atddismissed
No
12562
Atdid: 12562 • Atd Number: ATD-3-5079 • Bblid: 407306
Atdid
12562
Atd Number
ATD-3-5079
Bblid
407306
Inspectionid
358515
Inspect Date
2023-05-11T00:00:00.000
Atdissuedate
2023-06-13T14:58:34.000
Cb
9
House Num
121
Onstname
MIDWOOD ST.
Atddismissed
No
14950
Atdid: 14950 • Atd Number: ATD-3-6221 • Bblid: 412000
Atdid
14950
Atd Number
ATD-3-6221
Bblid
412000
Inspectionid
381000
Inspect Date
2024-08-23T00:00:00.000
Atdissuedate
2024-08-23T17:01:50.000
Cb
14
House Num
509
Onstname
RUGBY RD.
Atddismissed
No
18245
Atdid: 18245 • Atd Number: ATD-4-7200 • Bblid: 651171
Atdid
18245
Atd Number
ATD-4-7200
Bblid
651171
Inspectionid
403580
Inspect Date
2025-08-04T00:00:00.000
Atdissuedate
2025-08-04T15:56:06.000
Cb
5
House Num
64-39
Onstname
73RD PL.
Atddismissed
No
17097
Atdid: 17097 • Atd Number: ATD-3-6744 • Bblid: 333472
Atdid
17097
Atd Number
ATD-3-6744
Bblid
333472
Inspectionid
392477
Inspect Date
2022-11-23T00:00:00.000
Atdissuedate
2025-03-28T09:59:39.000
Cb
1
House Num
166
Onstname
HEYWARD ST.
Atddismissed
No
15060
Atdid: 15060 • Atd Number: ATD-3-6288 • Bblid: 485770
Atdid
15060
Atd Number
ATD-3-6288
Bblid
485770
Violationid
297723
Reinspectionid
37480
Inspect Date
2024-09-17T15:58:24.000
Atdissuedate
2024-09-17T15:58:24.000
Cb
15
House Num
1858
Onstname
EAST 23 STREET
Atddismissed
No
9127
Atdid: 9127 • Atd Number: ATD-3-3318 • Bblid: 353466
Atdid
9127
Atd Number
ATD-3-3318
Bblid
353466
Inspectionid
332678
Inspect Date
2019-09-06T00:00:00.000
Atdissuedate
2022-02-23T08:28:30.000
Cb
4
House Num
136
Onstname
SUYDAM ST.
Atddismissed
No
16250
Atdid: 16250 • Atd Number: ATD-5-882 • Bblid: 963350
Atdid
16250
Atd Number
ATD-5-882
Bblid
963350
Violationid
296832
Reinspectionid
37482
Inspect Date
2024-10-17T11:10:08.000
Atdissuedate
2024-10-17T11:10:08.000
Cb
2
House Num
263
Onstname
LANDER AVENUE
Atddismissed
No
17262
Atdid: 17262 • Atd Number: ATD-2-1373 • Bblid: 176282
Atdid
17262
Atd Number
ATD-2-1373
Bblid
176282
Inspectionid
393262
Inspect Date
2025-04-02T00:00:00.000
Atdissuedate
2025-04-04T16:14:22.000
Cb
9
House Num
1117
Onstname
THIERIOT AVE.
Atddismissed
No
8752
Atdid: 8752 • Atd Number: ATD-4-3948 • Bblid: 769327
Atdid
8752
Atd Number
ATD-4-3948
Bblid
769327
Inspectionid
331107
Inspect Date
2021-10-14T00:00:00.000
Atdissuedate
2021-12-28T13:56:00.000
Cb
13
House Num
77-19
Onstname
269TH ST.
Atddismissed
No
10370
Atdid: 10370 • Atd Number: ATD-3-3883 • Bblid: 417840
Atdid
10370
Atd Number
ATD-3-3883
Bblid
417840
Inspectionid
338559
Inspect Date
2022-06-16T00:00:00.000
Atdissuedate
2022-07-05T13:23:24.000
Cb
12
House Num
239
Onstname
E. 5TH ST.
Atddismissed
No
10922
Atdid: 10922 • Atd Number: ATD-3-4289 • Bblid: 276460
Atdid
10922
Atd Number
ATD-3-4289
Bblid
276460
Violationid
277983
Reinspectionid
33024
Inspect Date
2022-09-15T10:06:41.000
Atdissuedate
2022-09-15T10:06:41.000
Cb
6
House Num
103
Onstname
GARFIELD PLACE
Atddismissed
No
9625
Atdid: 9625 • Atd Number: ATD-4-4329 • Bblid: 692075
Atdid
9625
Atd Number
ATD-4-4329
Bblid
692075
Inspectionid
333794
Inspect Date
2020-11-05T00:00:00.000
Atdissuedate
2022-03-15T18:43:02.000
Cb
7
House Num
150-15
Onstname
22ND AVE.
Atddismissed
No
8860
Atdid: 8860 • Atd Number: ATD-4-4003 • Bblid: 738737
Atdid
8860
Atd Number
ATD-4-4003
Bblid
738737
Inspectionid
331801
Inspect Date
2016-08-16T00:00:00.000
Atdissuedate
2022-01-24T11:17:13.000
Cb
7
House Num
57-28
Onstname
PARSONS BLVD.
Atddismissed
No
16933
Atdid: 16933 • Atd Number: ATD-3-6639 • Bblid: 278759
Atdid
16933
Atd Number
ATD-3-6639
Bblid
278759
Inspectionid
391411
Inspect Date
2025-03-14T00:00:00.000
Atdissuedate
2025-03-17T08:29:32.000
Cb
6
House Num
401
Onstname
8TH ST.
Atddismissed
No
10312
Atdid: 10312 • Atd Number: ATD-3-3855 • Bblid: 317103
Atdid
10312
Atd Number
ATD-3-3855
Bblid
317103
Inspectionid
337831
Inspect Date
2022-06-17T00:00:00.000
Atdissuedate
2022-06-17T13:26:45.000
Cb
3
House Num
248
Onstname
MONROE ST.
Atddismissed
No
9359
Atdid: 9359 • Atd Number: ATD-3-3456 • Bblid: 518065
Atdid
9359
Atd Number
ATD-3-3456
Bblid
518065
Inspectionid
333082
Inspect Date
2020-11-19T00:00:00.000
Atdissuedate
2022-03-02T17:47:31.000
Cb
18
House Num
1411
Onstname
E. 35TH ST.
Atddismissed
No
17446
Atdid: 17446 • Atd Number: ATD-3-6920 • Bblid: 378325
Atdid
17446
Atd Number
ATD-3-6920
Bblid
378325
Inspectionid
395405
Inspect Date
2025-03-25T00:00:00.000
Atdissuedate
2025-04-25T22:11:45.000
Cb
5
House Num
574
Onstname
SCHENCK AVE.
Atddismissed
No
11585
Atdid: 11585 • Atd Number: ATD-4-4951 • Bblid: 750174
Atdid
11585
Atd Number
ATD-4-4951
Bblid
750174
Inspectionid
350302
Inspect Date
2023-01-05T00:00:00.000
Atdissuedate
2023-01-10T11:33:46.000
Cb
11
House Num
46-07
Onstname
204TH ST.
Atddismissed
No
16672
Atdid: 16672 • Atd Number: ATD-4-6557 • Bblid: 735840
Atdid
16672
Atd Number
ATD-4-6557
Bblid
735840
Inspectionid
388587
Inspect Date
2024-10-24T00:00:00.000
Atdissuedate
2025-01-08T15:53:16.000
Cb
8
House Num
76-04
Onstname
VLEIGH PL.
Atddismissed
No
4835
Atdid: 4835 • Atd Number: ATD-4-1366 • Bblid: 661378
Atdid
4835
Atd Number
ATD-4-1366
Bblid
661378
Violationid
188640
Atdissuedate
2020-08-21T00:00:00.000
Cb
9
House Num
8234
Onstname
GRENFELL STREET
Atddismissed
Yes
Atddismissedon
2024-08-07T10:09:00.000
10584
Atdid: 10584 • Atd Number: ATD-3-4012 • Bblid: 412154
Atdid
10584
Atd Number
ATD-3-4012
Bblid
412154
Inspectionid
340697
Inspect Date
2022-07-27T00:00:00.000
Atdissuedate
2022-08-01T13:49:28.000
Cb
14
House Num
494
Onstname
E. 18TH ST.
Atddismissed
No
13117
Atdid: 13117 • Atd Number: ATD-3-5330 • Bblid: 422810
Atdid
13117
Atd Number
ATD-3-5330
Bblid
422810
Inspectionid
361446
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T12:14:45.000
Cb
12
House Num
1532
Onstname
46TH ST.
Atddismissed
No
16221
Atdid: 16221 • Atd Number: ATD-4-6370 • Bblid: 905779
Atdid
16221
Atd Number
ATD-4-6370
Bblid
905779
Inspectionid
384114
Inspect Date
2024-10-10T00:00:00.000
Atdissuedate
2024-10-15T11:09:40.000
Cb
14
House Num
11-50
Onstname
REDFERN AVE.
Atddismissed
No
18337
Atdid: 18337 • Atd Number: ATD-4-7246 • Bblid: 855401
Atdid
18337
Atd Number
ATD-4-7246
Bblid
855401
Inspectionid
404345
Inspect Date
2025-07-25T00:00:00.000
Atdissuedate
2025-08-18T10:07:15.000
Cb
10
House Num
116-12
Onstname
121ST ST.
Atddismissed
No
16478
Atdid: 16478 • Atd Number: ATD-2-1327 • Bblid: 244805
Atdid
16478
Atd Number
ATD-2-1327
Bblid
244805
Inspectionid
385740
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2024-12-04T09:26:25.000
Cb
8
House Num
5112
Onstname
POST RD.
Atddismissed
No
9073
Atdid: 9073 • Atd Number: ATD-4-4123 • Bblid: 589541
Atdid
9073
Atd Number
ATD-4-4123
Bblid
589541
Inspectionid
332588
Inspect Date
2019-05-23T00:00:00.000
Atdissuedate
2022-02-18T16:25:33.000
Cb
1
House Num
23-45
Onstname
24TH ST.
Atddismissed
No
17765
Atdid: 17765 • Atd Number: ATD-4-6992 • Bblid: 651135
Atdid
17765
Atd Number
ATD-4-6992
Bblid
651135
Inspectionid
398820
Inspect Date
2025-05-29T00:00:00.000
Atdissuedate
2025-05-29T14:02:38.000
Cb
5
House Num
73-16
Onstname
PENELOPE AVE.
Atddismissed
No
13282
Atdid: 13282 • Atd Number: ATD-3-5442 • Bblid: 509389
Atdid
13282
Atd Number
ATD-3-5442
Bblid
509389
Inspectionid
362270
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-21T13:20:31.000
Cb
15
House Num
2365
Onstname
E. 28TH ST.
Atddismissed
No
13590
Atdid: 13590 • Atd Number: ATD-3-5599 • Bblid: 508083
Atdid
13590
Atd Number
ATD-3-5599
Bblid
508083
Inspectionid
365409
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-10-16T13:28:33.000
Cb
15
House Num
2225
Onstname
E. 29TH ST.
Atddismissed
No
10986
Atdid: 10986 • Atd Number: ATD-3-4339 • Bblid: 406337
Atdid
10986
Atd Number
ATD-3-4339
Bblid
406337
Inspectionid
344450
Inspect Date
2022-09-21T00:00:00.000
Atdissuedate
2022-09-23T14:11:48.000
Cb
17
House Num
641
Onstname
E. 31ST ST.
Atddismissed
No
16510
Atdid: 16510 • Atd Number: ATD-3-6453 • Bblid: 495424
Atdid
16510
Atd Number
ATD-3-6453
Bblid
495424
Inspectionid
386223
Inspect Date
2024-12-12T00:00:00.000
Atdissuedate
2024-12-13T16:28:02.000
Cb
15
House Num
2107
Onstname
E. 2ND ST.
Atddismissed
No
14303
Atdid: 14303 • Atd Number: ATD-2-1268 • Bblid: 196409
Atdid
14303
Atd Number
ATD-2-1268
Bblid
196409
Inspectionid
375737
Inspect Date
2024-04-19T00:00:00.000
Atdissuedate
2024-04-19T16:17:43.000
Cb
11
House Num
825
Onstname
KINSELLA ST.
Atddismissed
No
9853
Atdid: 9853 • Atd Number: ATD-3-3619 • Bblid: 297200
Atdid
9853
Atd Number
ATD-3-3619
Bblid
297200
Inspectionid
334807
Inspect Date
2021-01-28T00:00:00.000
Atdissuedate
2022-04-12T14:22:51.000
Cb
8
House Num
231
Onstname
ALBANY AVE.
Atddismissed
No
13700
Atdid: 13700 • Atd Number: ATD-4-5640 • Bblid: 689842
Atdid
13700
Atd Number
ATD-4-5640
Bblid
689842
Inspectionid
367710
Inspect Date
2023-11-18T00:00:00.000
Atdissuedate
2023-11-18T08:55:42.000
Cb
7
House Num
162-31
Onstname
12TH AVE.
Atddismissed
No
16232
Atdid: 16232 • Atd Number: ATD-4-6378 • Bblid: 816744
Atdid
16232
Atd Number
ATD-4-6378
Bblid
816744
Inspectionid
384162
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2024-10-15T13:23:20.000
Cb
12
House Num
92-29
Onstname
175TH ST.
Atddismissed
No
13179
Atdid: 13179 • Atd Number: ATD-4-5497 • Bblid: 777627
Atdid
13179
Atd Number
ATD-4-5497
Bblid
777627
Inspectionid
361793
Inspect Date
2023-08-08T00:00:00.000
Atdissuedate
2023-08-09T11:04:06.000
Cb
9
House Num
84-37
Onstname
89TH ST.
Atddismissed
No
18546
Atdid: 18546 • Atd Number: ATD-4-7352 • Bblid: 724199
Atdid
18546
Atd Number
ATD-4-7352
Bblid
724199
Inspectionid
405514
Inspect Date
2025-09-05T00:00:00.000
Atdissuedate
2025-09-08T13:20:36.000
Cb
11
House Num
27-21
Onstname
UTOPIA PKWY.
Atddismissed
No
12642
Atdid: 12642 • Atd Number: ATD-4-5383 • Bblid: 568211
Atdid
12642
Atd Number
ATD-4-5383
Bblid
568211
Inspectionid
358943
Inspect Date
2023-06-23T00:00:00.000
Atdissuedate
2023-06-23T12:31:22.000
Cb
2
House Num
45-31
Onstname
COURT SQUARE
Atddismissed
No
18263
Atdid: 18263 • Atd Number: ATD-4-7208 • Bblid: 647578
Atdid
18263
Atd Number
ATD-4-7208
Bblid
647578
Inspectionid
403672
Inspect Date
2025-08-05T00:00:00.000
Atdissuedate
2025-08-05T17:40:31.000
Cb
5
House Num
61-55
Onstname
75TH PL.
Atddismissed
No