Ask NYC Browse All Data Public Safety Transportation Health Buildings

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
9921
Atdid: 9921 • Atd Number: ATD-3-3634 • Bblid: 259544
Atdid
9921
Atd Number
ATD-3-3634
Bblid
259544
Inspectionid
335289
Inspect Date
2022-04-20T00:00:00.000
Atdissuedate
2022-04-20T15:16:46.000
Cb
6
House Num
468
Onstname
DEGRAW ST.
Atddismissed
No
18151
Atdid: 18151 • Atd Number: ATD-3-7160 • Bblid: 540468
Atdid
18151
Atd Number
ATD-3-7160
Bblid
540468
Inspectionid
402857
Inspect Date
2025-07-03T00:00:00.000
Atdissuedate
2025-07-21T14:27:01.000
Cb
18
House Num
1301
Onstname
REMSEN AVE.
Atddismissed
No
13224
Atdid: 13224 • Atd Number: ATD-3-5395 • Bblid: 422665
Atdid
13224
Atd Number
ATD-3-5395
Bblid
422665
Inspectionid
362044
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T15:28:03.000
Cb
12
House Num
1739
Onstname
46TH ST.
Atddismissed
No
14348
Atdid: 14348 • Atd Number: ATD-4-5995 • Bblid: 643807
Atdid
14348
Atd Number
ATD-4-5995
Bblid
643807
Inspectionid
376038
Inspect Date
2024-04-24T00:00:00.000
Atdissuedate
2024-04-24T10:30:54.000
Cb
5
House Num
60-25
Onstname
69TH LN.
Atddismissed
No
16306
Atdid: 16306 • Atd Number: ATD-3-6383 • Bblid: 274086
Atdid
16306
Atd Number
ATD-3-6383
Bblid
274086
Inspectionid
384497
Inspect Date
2024-10-01T00:00:00.000
Atdissuedate
2024-10-28T15:06:33.000
Cb
6
House Num
131
Onstname
SAINT MARKS PL.
Atddismissed
No
13400
Atdid: 13400 • Atd Number: ATD-3-5519 • Bblid: 477221
Atdid
13400
Atd Number
ATD-3-5519
Bblid
477221
Inspectionid
363394
Inspect Date
2023-09-07T00:00:00.000
Atdissuedate
2023-09-11T18:16:55.000
Cb
11
House Num
1748
Onstname
W. 8TH ST.
Atddismissed
No
18061
Atdid: 18061 • Atd Number: ATD-3-7112 • Bblid: 513231
Atdid
18061
Atd Number
ATD-3-7112
Bblid
513231
Inspectionid
402210
Inspect Date
2025-07-12T00:00:00.000
Atdissuedate
2025-07-14T11:33:51.000
Cb
15
House Num
2680
Onstname
FORD ST.
Atddismissed
No
10229
Atdid: 10229 • Atd Number: ATD-3-3808 • Bblid: 362725
Atdid
10229
Atd Number
ATD-3-3808
Bblid
362725
Inspectionid
337350
Inspect Date
2022-06-04T00:00:00.000
Atdissuedate
2022-06-06T11:59:18.000
Cb
4
House Num
156
Onstname
MOFFAT ST.
Atddismissed
No
10899
Atdid: 10899 • Atd Number: ATD-3-4270 • Bblid: 267232
Atdid
10899
Atd Number
ATD-3-4270
Bblid
267232
Violationid
191592
Inspectionid
343598
Inspect Date
2022-09-12T13:57:21.000
Atdissuedate
2022-09-12T13:57:21.000
Cb
7
House Num
417
Onstname
50 STREET
Atddismissed
No
13043
Atdid: 13043 • Atd Number: ATD-3-5287 • Bblid: 422484
Atdid
13043
Atd Number
ATD-3-5287
Bblid
422484
Inspectionid
361037
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T15:04:22.000
Cb
12
House Num
1638
Onstname
45TH ST.
Atddismissed
No
15070
Atdid: 15070 • Atd Number: ATD-4-6280 • Bblid: 747100
Atdid
15070
Atd Number
ATD-4-6280
Bblid
747100
Inspectionid
382054
Inspect Date
2024-08-15T00:00:00.000
Atdissuedate
2024-09-23T11:02:58.000
Cb
8
House Num
69-81
Onstname
179TH ST.
Atddismissed
No
17514
Atdid: 17514 • Atd Number: ATD-4-6836 • Bblid: 643846
Atdid
17514
Atd Number
ATD-4-6836
Bblid
643846
Inspectionid
396036
Inspect Date
2025-04-18T00:00:00.000
Atdissuedate
2025-05-05T08:12:49.000
Cb
5
House Num
59-21
Onstname
70TH ST.
Atddismissed
No
9800
Atdid: 9800 • Atd Number: ATD-4-4437 • Bblid: 570362
Atdid
9800
Atd Number
ATD-4-4437
Bblid
570362
Inspectionid
334439
Inspect Date
2018-10-24T00:00:00.000
Atdissuedate
2022-03-31T13:00:15.000
Cb
2
House Num
39-40
Onstname
44TH ST.
Atddismissed
No
13514
Atdid: 13514 • Atd Number: ATD-3-5568 • Bblid: 268460
Atdid
13514
Atd Number
ATD-3-5568
Bblid
268460
Inspectionid
364688
Inspect Date
2023-07-26T00:00:00.000
Atdissuedate
2023-10-02T12:06:59.000
Cb
7
House Num
549
Onstname
53RD ST.
Atddismissed
No
11552
Atdid: 11552 • Atd Number: ATD-1-273 • Bblid: 47219
Atdid
11552
Atd Number
ATD-1-273
Bblid
47219
Inspectionid
349778
Inspect Date
2022-12-28T00:00:00.000
Atdissuedate
2022-12-28T12:44:03.000
Cb
6
House Num
325
Onstname
E. 18TH ST.
Atddismissed
No
12199
Atdid: 12199 • Atd Number: ATD-2-1051 • Bblid: 166852
Atdid
12199
Atd Number
ATD-2-1051
Bblid
166852
Inspectionid
356841
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2023-05-09T14:47:04.000
Cb
7
House Num
2820
Onstname
GRAND CONCOURSE
Atddismissed
No
12364
Atdid: 12364 • Atd Number: ATD-4-5230 • Bblid: 634209
Atdid
12364
Atd Number
ATD-4-5230
Bblid
634209
Inspectionid
357521
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:22:37.000
Cb
2
Onstname
69 STREET
Atddismissed
No
13432
Atdid: 13432 • Atd Number: ATD-5-824 • Bblid: 1026026
Atdid
13432
Atd Number
ATD-5-824
Bblid
1026026
Inspectionid
363914
Inspect Date
2023-09-19T00:00:00.000
Atdissuedate
2023-09-20T13:36:21.000
Cb
3
House Num
35
Onstname
MACON AVE.
Atddismissed
No
13668
Atdid: 13668 • Atd Number: ATD-3-5631 • Bblid: 426657
Atdid
13668
Atd Number
ATD-3-5631
Bblid
426657
Inspectionid
366408
Inspect Date
2023-10-17T00:00:00.000
Atdissuedate
2023-11-13T08:44:58.000
Cb
12
House Num
1611
Onstname
60TH ST.
Atddismissed
No
18123
Atdid: 18123 • Atd Number: ATD-5-1006 • Bblid: 1012177
Atdid
18123
Atd Number
ATD-5-1006
Bblid
1012177
Inspectionid
402689
Inspect Date
2025-07-17T00:00:00.000
Atdissuedate
2025-07-18T12:21:38.000
Cb
3
House Num
300
Onstname
MONTREAL AVE.
Atddismissed
No
17394
Atdid: 17394 • Atd Number: ATD-4-6780 • Bblid: 751002
Atdid
17394
Atd Number
ATD-4-6780
Bblid
751002
Inspectionid
394902
Inspect Date
2017-08-03T00:00:00.000
Atdissuedate
2025-04-18T14:53:35.000
Cb
11
House Num
214-32
Onstname
45TH DR.
Atddismissed
No
12150
Atdid: 12150 • Atd Number: ATD-4-5173 • Bblid: 717140
Atdid
12150
Atd Number
ATD-4-5173
Bblid
717140
Violationid
282907
Reinspectionid
34209
Inspect Date
2023-05-04T11:17:07.000
Atdissuedate
2023-05-04T11:17:07.000
Cb
7
House Num
47-24
Onstname
167 STREET
Atddismissed
No
13603
Atdid: 13603 • Atd Number: ATD-4-5603 • Bblid: 582239
Atdid
13603
Atd Number
ATD-4-5603
Bblid
582239
Inspectionid
365646
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-10-23T10:50:56.000
Cb
1
House Num
25-51
Onstname
42ND ST.
Atddismissed
No
14727
Atdid: 14727 • Atd Number: ATD-4-6145 • Bblid: 631884
Atdid
14727
Atd Number
ATD-4-6145
Bblid
631884
Inspectionid
379275
Inspect Date
2024-06-03T00:00:00.000
Atdissuedate
2024-07-11T12:45:41.000
Cb
2
House Num
51-01
Onstname
64TH ST.
Atddismissed
No
13033
Atdid: 13033 • Atd Number: ATD-3-5277 • Bblid: 422464
Atdid
13033
Atd Number
ATD-3-5277
Bblid
422464
Inspectionid
361027
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T14:25:07.000
Cb
12
House Num
1614
Onstname
45TH ST.
Atddismissed
No
12918
Atdid: 12918 • Atd Number: ATD-3-5205 • Bblid: 432117
Atdid
12918
Atd Number
ATD-3-5205
Bblid
432117
Inspectionid
360337
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T10:14:29.000
Cb
12
House Num
1470
Onstname
44TH ST.
Atddismissed
No
11355
Atdid: 11355 • Atd Number: ATD-3-4629 • Bblid: 282867
Atdid
11355
Atd Number
ATD-3-4629
Bblid
282867
Inspectionid
347738
Inspect Date
2022-11-02T00:00:00.000
Atdissuedate
2022-11-07T11:48:56.000
Cb
6
House Num
520
Onstname
7TH ST.
Atddismissed
No
11254
Atdid: 11254 • Atd Number: ATD-3-4560 • Bblid: 283392
Atdid
11254
Atd Number
ATD-3-4560
Bblid
283392
Inspectionid
346852
Inspect Date
2022-10-18T00:00:00.000
Atdissuedate
2022-10-24T13:16:06.000
Cb
6
House Num
556
Onstname
9TH ST.
Atddismissed
No
14770
Atdid: 14770 • Atd Number: ATD-4-6165 • Bblid: 710463
Atdid
14770
Atd Number
ATD-4-6165
Bblid
710463
Inspectionid
379572
Inspect Date
2024-06-01T00:00:00.000
Atdissuedate
2024-07-18T14:31:45.000
Cb
7
House Num
36-17
Onstname
171ST ST.
Atddismissed
No
11299
Atdid: 11299 • Atd Number: ATD-3-4588 • Bblid: 278645
Atdid
11299
Atd Number
ATD-3-4588
Bblid
278645
Inspectionid
347284
Inspect Date
2022-10-26T00:00:00.000
Atdissuedate
2022-11-01T09:58:42.000
Cb
6
House Num
297
Onstname
8TH ST.
Atddismissed
No
12731
Atdid: 12731 • Atd Number: ATD-4-5398 • Bblid: 837455
Atdid
12731
Atd Number
ATD-4-5398
Bblid
837455
Inspectionid
359224
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-30T11:32:58.000
Cb
13
House Num
114-62
Onstname
COLFAX ST.
Atddismissed
No
13208
Atdid: 13208 • Atd Number: ATD-3-5382 • Bblid: 251446
Atdid
13208
Atd Number
ATD-3-5382
Bblid
251446
Inspectionid
361931
Inspect Date
2023-08-11T00:00:00.000
Atdissuedate
2023-08-14T07:58:46.000
Cb
2
House Num
146
Onstname
BOND ST.
Atddismissed
No
16888
Atdid: 16888 • Atd Number: ATD-3-6620 • Bblid: 531059
Atdid
16888
Atd Number
ATD-3-6620
Bblid
531059
Inspectionid
390790
Inspect Date
2025-02-01T00:00:00.000
Atdissuedate
2025-03-10T12:32:12.000
Cb
18
House Num
596
Onstname
E. 80TH ST.
Atddismissed
No
9263
Atdid: 9263 • Atd Number: ATD-2-871 • Bblid: 231822
Atdid
9263
Atd Number
ATD-2-871
Bblid
231822
Inspectionid
332969
Inspect Date
2020-11-20T00:00:00.000
Atdissuedate
2022-03-01T17:40:51.000
Cb
10
House Num
2841
Onstname
ZULETTE AVE.
Atddismissed
No
8801
Atdid: 8801 • Atd Number: ATD-4-3977 • Bblid: 601837
Atdid
8801
Atd Number
ATD-4-3977
Bblid
601837
Inspectionid
331385
Inspect Date
2021-12-14T00:00:00.000
Atdissuedate
2021-12-30T14:32:02.000
Cb
3
House Num
37-39
Onstname
78TH ST.
Atddismissed
No
10827
Atdid: 10827 • Atd Number: ATD-3-4198 • Bblid: 309163
Atdid
10827
Atd Number
ATD-3-4198
Bblid
309163
Inspectionid
343328
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-09-12T09:55:03.000
Cb
3
House Num
523
Onstname
HANCOCK ST.
Atddismissed
No
13346
Atdid: 13346 • Atd Number: ATD-3-5484 • Bblid: 310694
Atdid
13346
Atd Number
ATD-3-5484
Bblid
310694
Inspectionid
362849
Inspect Date
2023-08-29T00:00:00.000
Atdissuedate
2023-08-29T11:58:39.000
Cb
3
House Num
307
Onstname
MACDONOUGH ST.
Atddismissed
No
10551
Atdid: 10551 • Atd Number: ATD-3-4001 • Bblid: 319056
Atdid
10551
Atd Number
ATD-3-4001
Bblid
319056
Inspectionid
340341
Inspect Date
2022-07-21T00:00:00.000
Atdissuedate
2022-07-25T10:42:17.000
Cb
3
House Num
410
Onstname
PUTNAM AVE.
Atddismissed
No
8781
Atdid: 8781 • Atd Number: ATD-4-3958 • Bblid: 579913
Atdid
8781
Atd Number
ATD-4-3958
Bblid
579913
Inspectionid
331245
Inspect Date
2021-10-26T00:00:00.000
Atdissuedate
2021-12-29T14:38:36.000
Cb
1
House Num
30-24
Onstname
36TH ST.
Atddismissed
No
10873
Atdid: 10873 • Atd Number: ATD-3-4244 • Bblid: 359442
Atdid
10873
Atd Number
ATD-3-4244
Bblid
359442
Inspectionid
343526
Inspect Date
2022-08-26T00:00:00.000
Atdissuedate
2022-09-12T12:36:42.000
Cb
4
House Num
148
Onstname
CORNELIA ST.
Atddismissed
No
18242
Atdid: 18242 • Atd Number: ATD-2-1441 • Bblid: 236377
Atdid
18242
Atd Number
ATD-2-1441
Bblid
236377
Inspectionid
403568
Inspect Date
2025-07-02T00:00:00.000
Atdissuedate
2025-08-04T12:09:19.000
Cb
10
House Num
653
Onstname
VINCENT AVE.
Atddismissed
No
9460
Atdid: 9460 • Atd Number: ATD-4-4242 • Bblid: 803293
Atdid
9460
Atd Number
ATD-4-4242
Bblid
803293
Inspectionid
333294
Inspect Date
2011-10-22T00:00:00.000
Atdissuedate
2022-03-04T17:52:55.000
Cb
9
House Num
135-17
Onstname
87TH AVE.
Atddismissed
No
11929
Atdid: 11929 • Atd Number: ATD-3-4880 • Bblid: 286545
Atdid
11929
Atd Number
ATD-3-4880
Bblid
286545
Inspectionid
354183
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-29T12:40:44.000
Cb
8
House Num
191
Onstname
PROSPECT PL.
Atddismissed
No
11863
Atdid: 11863 • Atd Number: ATD-3-4836 • Bblid: 509772
Atdid
11863
Atd Number
ATD-3-4836
Bblid
509772
Inspectionid
353588
Inspect Date
2023-03-16T00:00:00.000
Atdissuedate
2023-03-22T12:11:24.000
Cb
15
House Num
2436
Onstname
E. 14TH ST.
Atddismissed
No
16965
Atdid: 16965 • Atd Number: ATD-4-6664 • Bblid: 638995
Atdid
16965
Atd Number
ATD-4-6664
Bblid
638995
Inspectionid
391623
Inspect Date
2025-02-01T00:00:00.000
Atdissuedate
2025-03-19T09:07:24.000
Cb
5
House Num
59-77
Onstname
57TH DR.
Atddismissed
No
18588
Atdid: 18588 • Atd Number: ATD-3-7323 • Bblid: 479684
Atdid
18588
Atd Number
ATD-3-7323
Bblid
479684
Inspectionid
405689
Inspect Date
2025-09-04T00:00:00.000
Atdissuedate
2025-09-11T15:58:30.000
Cb
15
House Num
1818
Onstname
E. 9TH ST.
Atddismissed
No
3172
Atdid: 3172 • Atd Number: ATD-4-96 • Bblid: 748823
Atdid
3172
Atd Number
ATD-4-96
Bblid
748823
Violationid
119220
Atdissuedate
2020-08-10T00:00:00.000
Cb
8
House Num
75-16
Onstname
188 STREET
Atddismissed
No
14640
Atdid: 14640 • Atd Number: ATD-4-6110 • Bblid: 735013
Atdid
14640
Atd Number
ATD-4-6110
Bblid
735013
Inspectionid
378633
Inspect Date
2024-06-07T00:00:00.000
Atdissuedate
2024-06-20T15:05:54.000
Cb
8
House Num
136-22
Onstname
72ND AVE.
Atddismissed
No
10675
Atdid: 10675 • Atd Number: ATD-3-4072 • Bblid: 453035
Atdid
10675
Atd Number
ATD-3-4072
Bblid
453035
Inspectionid
341948
Inspect Date
2022-08-13T00:00:00.000
Atdissuedate
2022-08-24T09:56:05.000
Cb
10
House Num
9202
Onstname
RIDGE BLVD.
Atddismissed
No
14627
Atdid: 14627 • Atd Number: ATD-3-6064 • Bblid: 425180
Atdid
14627
Atd Number
ATD-3-6064
Bblid
425180
Inspectionid
378574
Inspect Date
2024-06-15T00:00:00.000
Atdissuedate
2024-06-18T10:04:13.000
Cb
12
House Num
5424
Onstname
17TH AVE.
Atddismissed
No
NYC Data AI • Public-data exploration interface