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
17235
Atdid: 17235 • Atd Number: ATD-3-6815 • Bblid: 426075
Atdid
17235
Atd Number
ATD-3-6815
Bblid
426075
Inspectionid
393097
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-04-03T10:14:58.000
Cb
12
House Num
1550
Onstname
58TH ST.
Atddismissed
No
18579
Atdid: 18579 • Atd Number: ATD-4-7363 • Bblid: 810743
Atdid
18579
Atd Number
ATD-4-7363
Bblid
810743
Inspectionid
405652
Inspect Date
2025-06-09T00:00:00.000
Atdissuedate
2025-09-11T13:32:36.000
Cb
8
House Num
86-05
Onstname
MIDLAND PKWY.
Atddismissed
No
13041
Atdid: 13041 • Atd Number: ATD-3-5285 • Bblid: 422480
Atdid
13041
Atd Number
ATD-3-5285
Bblid
422480
Inspectionid
361035
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T14:59:50.000
Cb
12
House Num
1634
Onstname
45TH ST.
Atddismissed
No
11529
Atdid: 11529 • Atd Number: ATD-3-4708 • Bblid: 286087
Atdid
11529
Atd Number
ATD-3-4708
Bblid
286087
Inspectionid
349545
Inspect Date
2022-12-17T00:00:00.000
Atdissuedate
2022-12-20T12:42:54.000
Cb
8
House Num
125
Onstname
SAINT MARKS AVE.
Atddismissed
No
18277
Atdid: 18277 • Atd Number: ATD-4-7217 • Bblid: 857416
Atdid
18277
Atd Number
ATD-4-7217
Bblid
857416
Inspectionid
403733
Inspect Date
2025-08-06T00:00:00.000
Atdissuedate
2025-08-07T09:20:07.000
Cb
10
House Num
131-06
Onstname
SUTTER AVE.
Atddismissed
No
14047
Atdid: 14047 • Atd Number: ATD-1-310 • Bblid: 136775
Atdid
14047
Atd Number
ATD-1-310
Bblid
136775
Inspectionid
372626
Inspect Date
2021-12-17T00:00:00.000
Atdissuedate
2024-03-01T13:32:46.000
Cb
8
House Num
33
Onstname
ADRIAN AVE.
Atddismissed
No
16858
Atdid: 16858 • Atd Number: ATD-4-6625 • Bblid: 731572
Atdid
16858
Atd Number
ATD-4-6625
Bblid
731572
Inspectionid
390363
Inspect Date
2025-02-12T00:00:00.000
Atdissuedate
2025-03-06T08:57:54.000
Cb
7
House Num
132-24
Onstname
60TH AVE.
Atddismissed
No
10968
Atdid: 10968 • Atd Number: ATD-3-4326 • Bblid: 472233
Atdid
10968
Atd Number
ATD-3-4326
Bblid
472233
Inspectionid
344315
Inspect Date
2022-09-22T00:00:00.000
Atdissuedate
2022-09-22T12:01:46.000
Cb
11
House Num
2311
Onstname
62ND ST.
Atddismissed
No
18375
Atdid: 18375 • Atd Number: ATD-4-7267 • Bblid: 754080
Atdid
18375
Atd Number
ATD-4-7267
Bblid
754080
Inspectionid
404519
Inspect Date
2025-08-20T00:00:00.000
Atdissuedate
2025-08-20T11:03:16.000
Cb
11
House Num
56-10
Onstname
207TH ST.
Atddismissed
No
8903
Atdid: 8903 • Atd Number: ATD-5-598 • Bblid: 994006
Atdid
8903
Atd Number
ATD-5-598
Bblid
994006
Inspectionid
332116
Inspect Date
2017-06-27T00:00:00.000
Atdissuedate
2022-01-27T10:40:32.000
Cb
2
House Num
103
Onstname
ADAMS AVE.
Atddismissed
No
11074
Atdid: 11074 • Atd Number: ATD-3-4422 • Bblid: 279581
Atdid
11074
Atd Number
ATD-3-4422
Bblid
279581
Inspectionid
345020
Inspect Date
2022-09-27T00:00:00.000
Atdissuedate
2022-10-03T09:26:44.000
Cb
6
House Num
265
Onstname
12TH ST.
Atddismissed
No
13987
Atdid: 13987 • Atd Number: ATD-4-5818 • Bblid: 771219
Atdid
13987
Atd Number
ATD-4-5818
Bblid
771219
Inspectionid
371969
Inspect Date
2024-02-02T00:00:00.000
Atdissuedate
2024-02-20T12:16:16.000
Cb
13
House Num
86-12
Onstname
252ND ST.
Atddismissed
No
17091
Atdid: 17091 • Atd Number: ATD-5-944 • Bblid: 952909
Atdid
17091
Atd Number
ATD-5-944
Bblid
952909
Inspectionid
392469
Inspect Date
2021-06-28T00:00:00.000
Atdissuedate
2025-03-28T09:08:49.000
Cb
1
House Num
161
Onstname
PALMER AVE.
Atddismissed
No
10705
Atdid: 10705 • Atd Number: ATD-3-4088 • Bblid: 509749
Atdid
10705
Atd Number
ATD-3-4088
Bblid
509749
Inspectionid
342184
Inspect Date
2022-08-19T00:00:00.000
Atdissuedate
2022-08-29T14:06:25.000
Cb
15
House Num
2440
Onstname
E. 17TH ST.
Atddismissed
No
9044
Atdid: 9044 • Atd Number: ATD-4-4105 • Bblid: 772468
Atdid
9044
Atd Number
ATD-4-4105
Bblid
772468
Inspectionid
332453
Inspect Date
2022-02-10T00:00:00.000
Atdissuedate
2022-02-14T14:47:11.000
Cb
13
House Num
77-98
Onstname
LANGDALE ST.
Atddismissed
No
14229
Atdid: 14229 • Atd Number: ATD-4-5928 • Bblid: 741853
Atdid
14229
Atd Number
ATD-4-5928
Bblid
741853
Inspectionid
374458
Inspect Date
2024-03-27T00:00:00.000
Atdissuedate
2024-03-30T11:04:47.000
Cb
8
House Num
159-05
Onstname
GRAND CENTRAL PKWY.
Atddismissed
No
18155
Atdid: 18155 • Atd Number: ATD-2-1424 • Bblid: 206629
Atdid
18155
Atd Number
ATD-2-1424
Bblid
206629
Inspectionid
402891
Inspect Date
2025-07-16T00:00:00.000
Atdissuedate
2025-07-22T11:24:18.000
Cb
11
House Num
2436
Onstname
FISH AVE.
Atddismissed
No
13908
Atdid: 13908 • Atd Number: ATD-3-5719 • Bblid: 407664
Atdid
13908
Atd Number
ATD-3-5719
Bblid
407664
Inspectionid
371190
Inspect Date
2024-01-31T00:00:00.000
Atdissuedate
2024-01-31T11:48:00.000
Cb
9
House Num
27
Onstname
HAWTHORNE ST.
Atddismissed
No
14011
Atdid: 14011 • Atd Number: ATD-4-5833 • Bblid: 872573
Atdid
14011
Atd Number
ATD-4-5833
Bblid
872573
Inspectionid
372179
Inspect Date
2024-02-08T00:00:00.000
Atdissuedate
2024-02-26T10:43:43.000
Cb
12
House Num
120-15
Onstname
171ST ST.
Atddismissed
No
11937
Atdid: 11937 • Atd Number: ATD-3-4888 • Bblid: 332453
Atdid
11937
Atd Number
ATD-3-4888
Bblid
332453
Violationid
283164
Reinspectionid
34191
Inspect Date
2023-03-30T08:49:59.000
Atdissuedate
2023-03-30T08:49:59.000
Cb
1
House Num
224
Atddismissed
No
9450
Atdid: 9450 • Atd Number: ATD-3-3513 • Bblid: 456884
Atdid
9450
Atd Number
ATD-3-3513
Bblid
456884
Inspectionid
333284
Inspect Date
2020-01-16T00:00:00.000
Atdissuedate
2022-03-04T17:38:03.000
Cb
10
House Num
1269
Onstname
73RD ST.
Atddismissed
No
10079
Atdid: 10079 • Atd Number: ATD-3-3699 • Bblid: 407413
Atdid
10079
Atd Number
ATD-3-3699
Bblid
407413
Inspectionid
336351
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-11T12:35:55.000
Cb
9
House Num
254
Onstname
MIDWOOD ST.
Atddismissed
No
17351
Atdid: 17351 • Atd Number: ATD-3-6877 • Bblid: 309379
Atdid
17351
Atd Number
ATD-3-6877
Bblid
309379
Inspectionid
394570
Inspect Date
2025-03-29T00:00:00.000
Atdissuedate
2025-04-14T11:41:17.000
Cb
3
House Num
174
Onstname
PATCHEN AVE.
Atddismissed
No
12963
Atdid: 12963 • Atd Number: ATD-3-5237 • Bblid: 507825
Atdid
12963
Atd Number
ATD-3-5237
Bblid
507825
Inspectionid
360564
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-07-24T11:46:38.000
Cb
15
House Num
4327
Onstname
BEDFORD AVE.
Atddismissed
No
16793
Atdid: 16793 • Atd Number: ATD-1-365 • Bblid: 116828
Atdid
16793
Atd Number
ATD-1-365
Bblid
116828
Inspectionid
389563
Inspect Date
2025-01-28T00:00:00.000
Atdissuedate
2025-02-07T13:17:56.000
Cb
10
House Num
80
Onstname
W. 120TH ST.
Atddismissed
No
16685
Atdid: 16685 • Atd Number: ATD-3-6540 • Bblid: 555799
Atdid
16685
Atd Number
ATD-3-6540
Bblid
555799
Inspectionid
388630
Inspect Date
2024-12-17T00:00:00.000
Atdissuedate
2025-01-09T10:55:11.000
Cb
18
House Num
2454
Onstname
E. 65TH ST.
Atddismissed
No
17387
Atdid: 17387 • Atd Number: ATD-4-6773 • Bblid: 753073
Atdid
17387
Atd Number
ATD-4-6773
Bblid
753073
Inspectionid
394797
Inspect Date
2025-04-08T00:00:00.000
Atdissuedate
2025-04-16T15:25:13.000
Cb
11
House Num
50-05
Onstname
217TH ST.
Atddismissed
No
10236
Atdid: 10236 • Atd Number: ATD-3-3815 • Bblid: 332752
Atdid
10236
Atd Number
ATD-3-3815
Bblid
332752
Inspectionid
337367
Inspect Date
2022-06-03T00:00:00.000
Atdissuedate
2022-06-06T12:55:17.000
Cb
1
House Num
80
Onstname
PENN ST.
Atddismissed
No
10329
Atdid: 10329 • Atd Number: ATD-4-4682 • Bblid: 854171
Atdid
10329
Atd Number
ATD-4-4682
Bblid
854171
Inspectionid
338115
Inspect Date
2022-06-10T00:00:00.000
Atdissuedate
2022-06-25T19:43:57.000
Cb
10
House Num
128-03
Onstname
116TH AVE.
Atddismissed
No
14362
Atdid: 14362 • Atd Number: ATD-3-5919 • Bblid: 443941
Atdid
14362
Atd Number
ATD-3-5919
Bblid
443941
Inspectionid
376211
Inspect Date
2024-04-25T00:00:00.000
Atdissuedate
2024-04-29T10:10:51.000
Cb
10
House Num
238
Onstname
OVINGTON AVE.
Atddismissed
Yes
Atddismissedon
2024-04-29T10:16:19.000
9007
Atdid: 9007 • Atd Number: ATD-3-3289 • Bblid: 302049
Atdid
9007
Atd Number
ATD-3-3289
Bblid
302049
Inspectionid
332349
Inspect Date
2019-08-20T00:00:00.000
Atdissuedate
2022-02-10T09:02:54.000
Cb
3
House Num
617
Onstname
DECATUR ST.
Atddismissed
No
14987
Atdid: 14987 • Atd Number: ATD-3-6237 • Bblid: 303057
Atdid
14987
Atd Number
ATD-3-6237
Bblid
303057
Inspectionid
381353
Inspect Date
2024-08-27T00:00:00.000
Atdissuedate
2024-09-04T11:58:29.000
Cb
3
House Num
442
Onstname
BAINBRIDGE ST.
Atddismissed
No
16383
Atdid: 16383 • Atd Number: ATD-2-1320 • Bblid: 179535
Atdid
16383
Atd Number
ATD-2-1320
Bblid
179535
Inspectionid
385088
Inspect Date
2023-08-01T00:00:00.000
Atdissuedate
2024-11-16T11:01:32.000
Cb
10
House Num
1363
Onstname
HERSCHELL ST.
Atddismissed
No
17382
Atdid: 17382 • Atd Number: ATD-3-6895 • Bblid: 525443
Atdid
17382
Atd Number
ATD-3-6895
Bblid
525443
Inspectionid
394751
Inspect Date
2025-04-14T00:00:00.000
Atdissuedate
2025-04-15T10:27:58.000
Cb
18
House Num
2076
Onstname
E. 41ST ST.
Atddismissed
No
11609
Atdid: 11609 • Atd Number: ATD-3-4712 • Bblid: 278397
Atdid
11609
Atd Number
ATD-3-4712
Bblid
278397
Inspectionid
350546
Inspect Date
2023-01-07T00:00:00.000
Atdissuedate
2023-01-19T12:34:17.000
Cb
6
House Num
284
Onstname
7TH ST.
Atddismissed
No
13992
Atdid: 13992 • Atd Number: ATD-4-5822 • Bblid: 886851
Atdid
13992
Atd Number
ATD-4-5822
Bblid
886851
Inspectionid
371979
Inspect Date
2024-02-10T00:00:00.000
Atdissuedate
2024-02-20T15:56:37.000
Cb
13
House Num
134-42
Onstname
228TH ST.
Atddismissed
No
14548
Atdid: 14548 • Atd Number: ATD-3-6007 • Bblid: 491506
Atdid
14548
Atd Number
ATD-3-6007
Bblid
491506
Inspectionid
377980
Inspect Date
2024-06-01T00:00:00.000
Atdissuedate
2024-06-01T13:26:31.000
Cb
13
House Num
2872
Onstname
W. 33RD ST.
Atddismissed
No
9483
Atdid: 9483 • Atd Number: ATD-3-3526 • Bblid: 267817
Atdid
9483
Atd Number
ATD-3-3526
Bblid
267817
Inspectionid
333389
Inspect Date
2021-07-02T00:00:00.000
Atdissuedate
2022-03-08T10:33:24.000
Cb
7
House Num
739
Onstname
51ST ST.
Atddismissed
Yes
Atddismissedon
2022-05-24T09:38:16.000
12677
Atdid: 12677 • Atd Number: ATD-3-5092 • Bblid: 271262
Atdid
12677
Atd Number
ATD-3-5092
Bblid
271262
Violationid
285359
Reinspectionid
35538
Inspect Date
2023-06-29T08:56:49.000
Atdissuedate
2023-06-29T08:56:49.000
Cb
7
House Num
535
Onstname
17 STREET
Atddismissed
No
18308
Atdid: 18308 • Atd Number: ATD-3-7223 • Bblid: 413573
Atdid
18308
Atd Number
ATD-3-7223
Bblid
413573
Violationid
301056
Reinspectionid
39188
Inspect Date
2025-08-13T08:40:11.000
Atdissuedate
2025-08-13T08:40:11.000
Cb
14
House Num
670
Onstname
EAST 22 STREET
Atddismissed
No
18492
Atdid: 18492 • Atd Number: ATD-1-397 • Bblid: 75317
Atdid
18492
Atd Number
ATD-1-397
Bblid
75317
Inspectionid
405240
Inspect Date
2025-02-27T00:00:00.000
Atdissuedate
2025-09-04T16:44:56.000
Cb
7
House Num
124
Onstname
W. 87TH ST.
Atddismissed
No
11904
Atdid: 11904 • Atd Number: ATD-4-5080 • Bblid: 727581
Atdid
11904
Atd Number
ATD-4-5080
Bblid
727581
Inspectionid
354076
Inspect Date
2023-03-17T00:00:00.000
Atdissuedate
2023-03-28T10:21:31.000
Cb
11
House Num
34-22
Onstname
209TH ST.
Atddismissed
No
16834
Atdid: 16834 • Atd Number: ATD-5-904 • Bblid: 997473
Atdid
16834
Atd Number
ATD-5-904
Bblid
997473
Inspectionid
390008
Inspect Date
2025-02-12T00:00:00.000
Atdissuedate
2025-02-26T11:23:48.000
Cb
2
House Num
463
Onstname
NAUGHTON AVE.
Atddismissed
No
14438
Atdid: 14438 • Atd Number: ATD-3-5972 • Bblid: 342327
Atdid
14438
Atd Number
ATD-3-5972
Bblid
342327
Inspectionid
377119
Inspect Date
2024-04-30T00:00:00.000
Atdissuedate
2024-05-08T13:42:02.000
Cb
1
House Num
140
Onstname
DIAMOND ST.
Atddismissed
No
12035
Atdid: 12035 • Atd Number: ATD-3-4928 • Bblid: 332303
Atdid
12035
Atd Number
ATD-3-4928
Bblid
332303
Inspectionid
355870
Inspect Date
2023-04-14T00:00:00.000
Atdissuedate
2023-04-14T14:46:37.000
Cb
1
House Num
140
Onstname
HEWES ST.
Atddismissed
No
5564
Atdid: 5564 • Atd Number: ATD-4-1925 • Bblid: 770512
Atdid
5564
Atd Number
ATD-4-1925
Bblid
770512
Violationid
224951
Atdissuedate
2020-07-20T00:00:00.000
Cb
13
House Num
84-55
Onstname
252 STREET
Atddismissed
Yes
Atddismissedon
2025-01-08T13:51:43.000
13087
Atdid: 13087 • Atd Number: ATD-3-5316 • Bblid: 457695
Atdid
13087
Atd Number
ATD-3-5316
Bblid
457695
Inspectionid
361293
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-08-02T11:24:57.000
Cb
11
House Num
1578
Onstname
73RD ST.
Atddismissed
No
14097
Atdid: 14097 • Atd Number: ATD-3-5782 • Bblid: 258146
Atdid
14097
Atd Number
ATD-3-5782
Bblid
258146
Inspectionid
373015
Inspect Date
2024-03-12T00:00:00.000
Atdissuedate
2024-03-12T08:49:48.000
Cb
2
House Num
158A
Onstname
NEVINS ST.
Atddismissed
No
10988
Atdid: 10988 • Atd Number: ATD-3-4341 • Bblid: 286436
Atdid
10988
Atd Number
ATD-3-4341
Bblid
286436
Inspectionid
344456
Inspect Date
2022-09-22T00:00:00.000
Atdissuedate
2022-09-23T14:13:44.000
Cb
8
House Num
118
Onstname
SAINT MARKS AVE.
Atddismissed
No
1487
Atdid: 1487 • Atd Number: ATD-3-630 • Bblid: 303475
Atdid
1487
Atd Number
ATD-3-630
Bblid
303475
Violationid
52087
Atdissuedate
2020-08-12T00:00:00.000
Cb
16
House Num
475
Onstname
MARION STREET
Atddismissed
Yes
Atddismissedon
2023-01-31T12:55:40.000