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
18183
Atdid: 18183 • Atd Number: ATD-4-7181 • Bblid: 664026
Atdid
18183
Atd Number
ATD-4-7181
Bblid
664026
Inspectionid
403073
Inspect Date
2025-07-15T00:00:00.000
Atdissuedate
2025-07-23T16:40:33.000
Cb
5
House Num
1718
Onstname
HART ST.
Atddismissed
No
14666
Atdid: 14666 • Atd Number: ATD-4-6116 • Bblid: 738382
Atdid
14666
Atd Number
ATD-4-6116
Bblid
738382
Inspectionid
378891
Inspect Date
2024-05-23T00:00:00.000
Atdissuedate
2024-06-27T14:14:15.000
Cb
8
House Num
150-14
Onstname
GRAND CENTRAL PKWY.
Atddismissed
No
16756
Atdid: 16756 • Atd Number: ATD-4-6598 • Bblid: 657454
Atdid
16756
Atd Number
ATD-4-6598
Bblid
657454
Inspectionid
389128
Inspect Date
2025-01-24T00:00:00.000
Atdissuedate
2025-01-29T12:12:14.000
Cb
6
House Num
68-13
Onstname
FLEET ST.
Atddismissed
No
10915
Atdid: 10915 • Atd Number: ATD-3-4286 • Bblid: 354460
Atdid
10915
Atd Number
ATD-3-4286
Bblid
354460
Inspectionid
343735
Inspect Date
2022-09-09T00:00:00.000
Atdissuedate
2022-09-13T09:36:11.000
Cb
4
House Num
421
Onstname
STOCKHOLM ST.
Atddismissed
No
14201
Atdid: 14201 • Atd Number: ATD-4-5905 • Bblid: 602458
Atdid
14201
Atd Number
ATD-4-5905
Bblid
602458
Inspectionid
373900
Inspect Date
2024-03-21T00:00:00.000
Atdissuedate
2024-03-21T12:48:51.000
Cb
4
House Num
40-48
Onstname
73RD ST.
Atddismissed
No
16467
Atdid: 16467 • Atd Number: ATD-4-6480 • Bblid: 572440
Atdid
16467
Atd Number
ATD-4-6480
Bblid
572440
Inspectionid
385635
Inspect Date
2024-11-20T00:00:00.000
Atdissuedate
2024-12-02T13:18:12.000
Cb
1
House Num
35-32
Onstname
CRESCENT ST.
Atddismissed
No
8683
Atdid: 8683 • Atd Number: ATD-4-3906 • Bblid: 874658
Atdid
8683
Atd Number
ATD-4-3906
Bblid
874658
Inspectionid
330852
Inspect Date
2019-06-26T00:00:00.000
Atdissuedate
2021-12-17T10:36:04.000
Cb
12
House Num
176-16
Onstname
129TH AVE.
Atddismissed
No
14749
Atdid: 14749 • Atd Number: ATD-3-6126 • Bblid: 549166
Atdid
14749
Atd Number
ATD-3-6126
Bblid
549166
Inspectionid
379407
Inspect Date
2024-07-09T00:00:00.000
Atdissuedate
2024-07-16T10:01:19.000
Cb
18
House Num
7305
Onstname
AVENUE U.
Atddismissed
No
10740
Atdid: 10740 • Atd Number: ATD-3-4118 • Bblid: 360048
Atdid
10740
Atd Number
ATD-3-4118
Bblid
360048
Inspectionid
342672
Inspect Date
2022-08-29T00:00:00.000
Atdissuedate
2022-09-06T12:22:41.000
Cb
4
House Num
1211
Onstname
HANCOCK ST.
Atddismissed
No
16848
Atdid: 16848 • Atd Number: ATD-5-911 • Bblid: 932216
Atdid
16848
Atd Number
ATD-5-911
Bblid
932216
Inspectionid
390150
Inspect Date
2025-03-01T00:00:00.000
Atdissuedate
2025-03-01T14:13:59.000
Cb
1
House Num
739
Onstname
OAKLAND AVE.
Atddismissed
No
9107
Atdid: 9107 • Atd Number: ATD-4-4156 • Bblid: 687879
Atdid
9107
Atd Number
ATD-4-4156
Bblid
687879
Inspectionid
332658
Inspect Date
2019-07-17T00:00:00.000
Atdissuedate
2022-02-22T15:05:10.000
Cb
7
House Num
149-18
Onstname
10TH AVE.
Atddismissed
No
10806
Atdid: 10806 • Atd Number: ATD-4-4807 • Bblid: 589155
Atdid
10806
Atd Number
ATD-4-4807
Bblid
589155
Inspectionid
343028
Inspect Date
2022-09-08T00:00:00.000
Atdissuedate
2022-09-08T11:36:33.000
Cb
1
House Num
24-27
Onstname
CRESCENT ST.
Atddismissed
No
13473
Atdid: 13473 • Atd Number: ATD-3-5548 • Bblid: 509457
Atdid
13473
Atd Number
ATD-3-5548
Bblid
509457
Inspectionid
364225
Inspect Date
2023-09-08T00:00:00.000
Atdissuedate
2023-09-25T13:51:39.000
Cb
15
House Num
2369
Onstname
E. 29TH ST.
Atddismissed
No
9080
Atdid: 9080 • Atd Number: ATD-5-605 • Bblid: 1028712
Atdid
9080
Atd Number
ATD-5-605
Bblid
1028712
Inspectionid
332627
Inspect Date
2022-02-18T00:00:00.000
Atdissuedate
2022-02-22T06:40:45.000
Cb
3
House Num
284
Onstname
ANNADALE RD.
Atddismissed
No
13918
Atdid: 13918 • Atd Number: ATD-4-5774 • Bblid: 657103
Atdid
13918
Atd Number
ATD-4-5774
Bblid
657103
Inspectionid
371251
Inspect Date
2023-12-18T00:00:00.000
Atdissuedate
2024-02-01T13:52:39.000
Cb
6
House Num
72-61
Onstname
YELLOWSTONE BLVD.
Atddismissed
No
6053
Atdid: 6053 • Atd Number: ATD-4-2414 • Bblid: 907368
Atdid
6053
Atd Number
ATD-4-2414
Bblid
907368
Violationid
237363
Atdissuedate
2020-06-05T00:00:00.000
Cb
14
House Num
9-08
Onstname
SEAGIRT BOULEVARD
Atddismissed
No
13238
Atdid: 13238 • Atd Number: ATD-3-5409 • Bblid: 433098
Atdid
13238
Atd Number
ATD-3-5409
Bblid
433098
Inspectionid
362058
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T16:35:43.000
Cb
12
House Num
1440
Onstname
47TH ST.
Atddismissed
No
11104
Atdid: 11104 • Atd Number: ATD-4-4833 • Bblid: 858724
Atdid
11104
Atd Number
ATD-4-4833
Bblid
858724
Inspectionid
345234
Inspect Date
2022-09-29T00:00:00.000
Atdissuedate
2022-10-05T12:55:27.000
Cb
10
House Num
149-43
Onstname
114TH PL.
Atddismissed
No
9513
Atdid: 9513 • Atd Number: ATD-4-4271 • Bblid: 756278
Atdid
9513
Atd Number
ATD-4-4271
Bblid
756278
Inspectionid
333538
Inspect Date
2019-08-23T00:00:00.000
Atdissuedate
2022-03-09T15:28:29.000
Cb
11
House Num
216-17
Onstname
64TH AVE.
Atddismissed
No
14970
Atdid: 14970 • Atd Number: ATD-4-6249 • Bblid: 639175
Atdid
14970
Atd Number
ATD-4-6249
Bblid
639175
Inspectionid
381094
Inspect Date
2021-04-21T00:00:00.000
Atdissuedate
2024-08-27T11:41:55.000
Cb
5
House Num
60-57
Onstname
FLUSHING AVE.
Atddismissed
No
18531
Atdid: 18531 • Atd Number: ATD-4-7342 • Bblid: 719788
Atdid
18531
Atd Number
ATD-4-7342
Bblid
719788
Inspectionid
405453
Inspect Date
2025-09-05T00:00:00.000
Atdissuedate
2025-09-08T11:01:10.000
Cb
11
House Num
56-36
Onstname
187TH ST.
Atddismissed
No
11706
Atdid: 11706 • Atd Number: ATD-4-5011 • Bblid: 635605
Atdid
11706
Atd Number
ATD-4-5011
Bblid
635605
Inspectionid
351981
Inspect Date
2023-01-25T00:00:00.000
Atdissuedate
2023-02-24T12:28:51.000
Cb
5
House Num
52-50
Onstname
71ST ST.
Atddismissed
No
11141
Atdid: 11141 • Atd Number: ATD-3-4472 • Bblid: 381389
Atdid
11141
Atd Number
ATD-3-4472
Bblid
381389
Inspectionid
345786
Inspect Date
2022-10-07T00:00:00.000
Atdissuedate
2022-10-13T13:27:44.000
Cb
5
House Num
21
Onstname
MILFORD ST.
Atddismissed
No
11250
Atdid: 11250 • Atd Number: ATD-3-4556 • Bblid: 283402
Atdid
11250
Atd Number
ATD-3-4556
Bblid
283402
Inspectionid
346847
Inspect Date
2022-10-18T00:00:00.000
Atdissuedate
2022-10-24T13:13:55.000
Cb
6
House Num
566
Onstname
9TH ST.
Atddismissed
No
11031
Atdid: 11031 • Atd Number: ATD-3-4381 • Bblid: 515566
Atdid
11031
Atd Number
ATD-3-4381
Bblid
515566
Inspectionid
344663
Inspect Date
2022-09-28T00:00:00.000
Atdissuedate
2022-09-28T09:23:19.000
Cb
18
House Num
3413
Onstname
AVENUE K.
Atddismissed
No
15022
Atdid: 15022 • Atd Number: ATD-3-6260 • Bblid: 546224
Atdid
15022
Atd Number
ATD-3-6260
Bblid
546224
Inspectionid
381617
Inspect Date
2024-08-15T00:00:00.000
Atdissuedate
2024-09-09T14:09:35.000
Cb
18
House Num
1158
Onstname
E. 72ND ST.
Atddismissed
No
17024
Atdid: 17024 • Atd Number: ATD-3-6692 • Bblid: 264417
Atdid
17024
Atd Number
ATD-3-6692
Bblid
264417
Inspectionid
392258
Inspect Date
2021-09-22T00:00:00.000
Atdissuedate
2025-03-26T11:29:14.000
Cb
7
House Num
427
Onstname
37TH ST.
Atddismissed
No
9892
Atdid: 9892 • Atd Number: ATD-4-4498 • Bblid: 777160
Atdid
9892
Atd Number
ATD-4-4498
Bblid
777160
Inspectionid
335054
Inspect Date
2022-04-15T00:00:00.000
Atdissuedate
2022-04-18T08:31:41.000
Cb
9
House Num
85-35
Onstname
87TH ST.
Atddismissed
No
11629
Atdid: 11629 • Atd Number: ATD-1-283 • Bblid: 132125
Atdid
11629
Atd Number
ATD-1-283
Bblid
132125
Inspectionid
350832
Inspect Date
2022-12-28T00:00:00.000
Atdissuedate
2023-01-30T12:37:14.000
Cb
9
House Num
227
Onstname
EDGECOMBE AVE.
Atddismissed
No
12122
Atdid: 12122 • Atd Number: ATD-4-5159 • Bblid: 860876
Atdid
12122
Atd Number
ATD-4-5159
Bblid
860876
Inspectionid
356435
Inspect Date
2023-03-20T00:00:00.000
Atdissuedate
2023-05-01T10:58:36.000
Cb
12
House Num
111-70
Onstname
145TH ST.
Atddismissed
No
16344
Atdid: 16344 • Atd Number: ATD-4-6415 • Bblid: 589392
Atdid
16344
Atd Number
ATD-4-6415
Bblid
589392
Inspectionid
384805
Inspect Date
2024-10-24T00:00:00.000
Atdissuedate
2024-11-04T12:48:55.000
Cb
1
House Num
20-48
Onstname
26TH ST.
Atddismissed
No
17075
Atdid: 17075 • Atd Number: ATD-5-943 • Bblid: 969538
Atdid
17075
Atd Number
ATD-5-943
Bblid
969538
Inspectionid
392429
Inspect Date
2025-03-26T00:00:00.000
Atdissuedate
2025-03-27T13:40:15.000
Cb
2
House Num
110
Onstname
GARY PL.
Atddismissed
No
13359
Atdid: 13359 • Atd Number: ATD-3-5494 • Bblid: 545153
Atdid
13359
Atd Number
ATD-3-5494
Bblid
545153
Inspectionid
362936
Inspect Date
2023-09-01T00:00:00.000
Atdissuedate
2023-09-01T13:00:02.000
Cb
18
House Num
10532
Onstname
FLATLANDS 9 STREET
Atddismissed
No
17799
Atdid: 17799 • Atd Number: ATD-4-7019 • Bblid: 649241
Atdid
17799
Atd Number
ATD-4-7019
Bblid
649241
Inspectionid
399209
Inspect Date
2025-04-22T00:00:00.000
Atdissuedate
2025-06-05T11:29:05.000
Cb
5
House Num
63-25
Onstname
75TH ST.
Atddismissed
No
9978
Atdid: 9978 • Atd Number: ATD-3-3661 • Bblid: 280177
Atdid
9978
Atd Number
ATD-3-3661
Bblid
280177
Inspectionid
335688
Inspect Date
2022-04-12T00:00:00.000
Atdissuedate
2022-04-27T11:06:19.000
Cb
6
House Num
286
Onstname
13TH ST.
Atddismissed
No
9057
Atdid: 9057 • Atd Number: ATD-1-175 • Bblid: 133015
Atdid
9057
Atd Number
ATD-1-175
Bblid
133015
Inspectionid
332568
Inspect Date
2019-06-22T00:00:00.000
Atdissuedate
2022-02-18T14:26:56.000
Cb
9
House Num
522
Onstname
W. 143RD ST.
Atddismissed
No
11884
Atdid: 11884 • Atd Number: ATD-3-4856 • Bblid: 452432
Atdid
11884
Atd Number
ATD-3-4856
Bblid
452432
Inspectionid
353809
Inspect Date
2023-03-02T00:00:00.000
Atdissuedate
2023-03-24T14:59:32.000
Cb
10
House Num
243
Onstname
91ST ST.
Atddismissed
No
13817
Atdid: 13817 • Atd Number: ATD-4-5712 • Bblid: 869291
Atdid
13817
Atd Number
ATD-4-5712
Bblid
869291
Inspectionid
370100
Inspect Date
2023-12-26T00:00:00.000
Atdissuedate
2023-12-26T13:25:49.000
Cb
12
House Num
117-09
Onstname
LONG STREET
Atddismissed
No
10309
Atdid: 10309 • Atd Number: ATD-4-4668 • Bblid: 802106
Atdid
10309
Atd Number
ATD-4-4668
Bblid
802106
Inspectionid
337803
Inspect Date
2022-06-16T00:00:00.000
Atdissuedate
2022-06-17T10:59:51.000
Cb
10
House Num
107-42
Onstname
121ST ST.
Atddismissed
No
18364
Atdid: 18364 • Atd Number: ATD-3-7244 • Bblid: 306997
Atdid
18364
Atd Number
ATD-3-7244
Bblid
306997
Inspectionid
404439
Inspect Date
2025-08-08T00:00:00.000
Atdissuedate
2025-08-18T14:10:31.000
Cb
3
House Num
309
Onstname
VAN BUREN ST.
Atddismissed
No
10366
Atdid: 10366 • Atd Number: ATD-3-3879 • Bblid: 420708
Atdid
10366
Atd Number
ATD-3-3879
Bblid
420708
Inspectionid
338551
Inspect Date
2022-06-24T00:00:00.000
Atdissuedate
2022-07-05T13:02:48.000
Cb
12
House Num
621
Onstname
E. 3RD ST.
Atddismissed
No
9878
Atdid: 9878 • Atd Number: ATD-3-3621 • Bblid: 314990
Atdid
9878
Atd Number
ATD-3-3621
Bblid
314990
Inspectionid
334952
Inspect Date
2022-03-30T00:00:00.000
Atdissuedate
2022-04-15T09:45:49.000
Cb
3
House Num
559
Onstname
LAFAYETTE AVE.
Atddismissed
No
14041
Atdid: 14041 • Atd Number: ATD-3-5754 • Bblid: 514585
Atdid
14041
Atd Number
ATD-3-5754
Bblid
514585
Inspectionid
372456
Inspect Date
2024-02-27T00:00:00.000
Atdissuedate
2024-02-29T10:57:54.000
Cb
14
House Num
2820
Onstname
AVENUE I.
Atddismissed
No
12779
Atdid: 12779 • Atd Number: ATD-4-5417 • Bblid: 587102
Atdid
12779
Atd Number
ATD-4-5417
Bblid
587102
Inspectionid
359539
Inspect Date
2023-07-07T00:00:00.000
Atdissuedate
2023-07-07T10:51:59.000
Cb
1
House Num
20-12
Onstname
35TH ST.
Atddismissed
No
9357
Atdid: 9357 • Atd Number: ATD-3-3454 • Bblid: 515913
Atdid
9357
Atd Number
ATD-3-3454
Bblid
515913
Inspectionid
333080
Inspect Date
2020-11-17T00:00:00.000
Atdissuedate
2022-03-02T17:33:19.000
Cb
14
House Num
3292
Onstname
BEDFORD AVE.
Atddismissed
No
5420
Atdid: 5420 • Atd Number: ATD-4-1812 • Bblid: 907275
Atdid
5420
Atd Number
ATD-4-1812
Bblid
907275
Violationid
217360
Atdissuedate
2020-05-14T00:00:00.000
Cb
14
House Num
6-15
Onstname
LANETT AVENUE
Atddismissed
No
10020
Atdid: 10020 • Atd Number: ATD-4-4564 • Bblid: 654514
Atdid
10020
Atd Number
ATD-4-4564
Bblid
654514
Inspectionid
335987
Inspect Date
2022-04-21T00:00:00.000
Atdissuedate
2022-05-03T10:50:12.000
Cb
6
House Num
62-06
Onstname
ELLWELL CRES
Atddismissed
No
9356
Atdid: 9356 • Atd Number: ATD-3-3453 • Bblid: 510387
Atdid
9356
Atd Number
ATD-3-3453
Bblid
510387
Inspectionid
333079
Inspect Date
2020-11-18T00:00:00.000
Atdissuedate
2022-03-02T17:29:56.000
Cb
15
House Num
2817
Onstname
AVENUE Y.
Atddismissed
No
13485
Atdid: 13485 • Atd Number: ATD-3-5554 • Bblid: 428011
Atdid
13485
Atd Number
ATD-3-5554
Bblid
428011
Inspectionid
364356
Inspect Date
2023-09-16T00:00:00.000
Atdissuedate
2023-09-26T10:34:22.000
Cb
11
House Num
1673
Onstname
64TH ST.
Atddismissed
No
14463
Atdid: 14463 • Atd Number: ATD-4-6041 • Bblid: 860908
Atdid
14463
Atd Number
ATD-4-6041
Bblid
860908
Inspectionid
377273
Inspect Date
2024-03-12T00:00:00.000
Atdissuedate
2024-05-13T11:35:11.000
Cb
12
House Num
111-61
Onstname
145TH ST.
Atddismissed
No