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
9138
Atdid: 9138 • Atd Number: ATD-3-3329 • Bblid: 383782
Atdid
9138
Atd Number
ATD-3-3329
Bblid
383782
Inspectionid
332689
Inspect Date
2019-08-03T00:00:00.000
Atdissuedate
2022-02-23T10:23:42.000
Cb
5
House Num
607
Onstname
DREW ST.
Atddismissed
No
9756
Atdid: 9756 • Atd Number: ATD-2-906 • Bblid: 200073
Atdid
9756
Atd Number
ATD-2-906
Bblid
200073
Inspectionid
334349
Inspect Date
2019-08-08T00:00:00.000
Atdissuedate
2022-03-29T17:49:30.000
Cb
11
House Num
1788
Onstname
TENBROECK AVE.
Atddismissed
No
9025
Atdid: 9025 • Atd Number: ATD-3-3301 • Bblid: 1121070
Atdid
9025
Atd Number
ATD-3-3301
Bblid
1121070
Inspectionid
332388
Inspect Date
2019-09-04T00:00:00.000
Atdissuedate
2022-02-11T14:26:36.000
Cb
0
House Num
2431
Onstname
E. 15TH ST.
Atddismissed
No
12343
Atdid: 12343 • Atd Number: ATD-4-5209 • Bblid: 602823
Atdid
12343
Atd Number
ATD-4-5209
Bblid
602823
Inspectionid
357465
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T11:42:14.000
Cb
2
House Num
51-27
Onstname
QUEENS BOULEVARD
Atddismissed
No
17985
Atdid: 17985 • Atd Number: ATD-3-7086 • Bblid: 496731
Atdid
17985
Atd Number
ATD-3-7086
Bblid
496731
Inspectionid
401569
Inspect Date
2025-06-25T00:00:00.000
Atdissuedate
2025-06-26T11:29:25.000
Cb
15
House Num
2223
Onstname
E. 4TH ST.
Atddismissed
No
9011
Atdid: 9011 • Atd Number: ATD-3-3293 • Bblid: 302067
Atdid
9011
Atd Number
ATD-3-3293
Bblid
302067
Inspectionid
332353
Inspect Date
2019-08-20T00:00:00.000
Atdissuedate
2022-02-10T09:15:49.000
Cb
3
House Num
601
Onstname
DECATUR ST.
Atddismissed
No
8799
Atdid: 8799 • Atd Number: ATD-4-3975 • Bblid: 644178
Atdid
8799
Atd Number
ATD-4-3975
Bblid
644178
Inspectionid
331340
Inspect Date
2021-12-07T00:00:00.000
Atdissuedate
2021-12-30T11:44:13.000
Cb
5
House Num
60-05
Onstname
72ND ST.
Atddismissed
No
11184
Atdid: 11184 • Atd Number: ATD-3-4502 • Bblid: 475359
Atdid
11184
Atd Number
ATD-3-4502
Bblid
475359
Inspectionid
346153
Inspect Date
2022-10-14T00:00:00.000
Atdissuedate
2022-10-17T10:29:42.000
Cb
12
House Num
1579
Onstname
OCEAN PKWY.
Atddismissed
Yes
Atddismissedon
2022-10-17T10:30:47.000
12887
Atdid: 12887 • Atd Number: ATD-3-5178 • Bblid: 346390
Atdid
12887
Atd Number
ATD-3-5178
Bblid
346390
Inspectionid
360228
Inspect Date
2023-05-25T00:00:00.000
Atdissuedate
2023-07-18T09:56:45.000
Cb
1
House Num
755
Onstname
METROPOLITAN AVE.
Atddismissed
No
13800
Atdid: 13800 • Atd Number: ATD-4-5695 • Bblid: 861078
Atdid
13800
Atd Number
ATD-4-5695
Bblid
861078
Inspectionid
370018
Inspect Date
2023-11-22T00:00:00.000
Atdissuedate
2023-12-22T12:40:14.000
Cb
12
House Num
145-28
Onstname
111TH AVE.
Atddismissed
No
8837
Atdid: 8837 • Atd Number: ATD-5-591 • Bblid: 997178
Atdid
8837
Atd Number
ATD-5-591
Bblid
997178
Inspectionid
331708
Inspect Date
2022-01-18T00:00:00.000
Atdissuedate
2022-01-18T12:06:00.000
Cb
2
House Num
401
Onstname
JEFFERSON AVE.
Atddismissed
No
13182
Atdid: 13182 • Atd Number: ATD-4-5500 • Bblid: 770452
Atdid
13182
Atd Number
ATD-4-5500
Bblid
770452
Inspectionid
361812
Inspect Date
2023-08-10T00:00:00.000
Atdissuedate
2023-08-10T09:50:36.000
Cb
13
House Num
83-14
Onstname
248TH ST.
Atddismissed
No
8814
Atdid: 8814 • Atd Number: ATD-3-3232 • Bblid: 270285
Atdid
8814
Atd Number
ATD-3-3232
Bblid
270285
Inspectionid
331539
Inspect Date
2021-11-08T00:00:00.000
Atdissuedate
2022-01-07T14:57:40.000
Cb
7
House Num
434
Onstname
57TH ST.
Atddismissed
No
17369
Atdid: 17369 • Atd Number: ATD-3-6886 • Bblid: 284568
Atdid
17369
Atd Number
ATD-3-6886
Bblid
284568
Inspectionid
394693
Inspect Date
2025-04-09T00:00:00.000
Atdissuedate
2025-04-15T07:37:45.000
Cb
7
House Num
15
Onstname
WINDSOR PL.
Atddismissed
No
17347
Atdid: 17347 • Atd Number: ATD-4-6762 • Bblid: 877258
Atdid
17347
Atd Number
ATD-4-6762
Bblid
877258
Inspectionid
394542
Inspect Date
2025-03-22T00:00:00.000
Atdissuedate
2025-04-14T10:48:15.000
Cb
12
House Num
119-50
Onstname
196TH ST.
Atddismissed
No
14491
Atdid: 14491 • Atd Number: ATD-2-1277 • Bblid: 164560
Atdid
14491
Atd Number
ATD-2-1277
Bblid
164560
Inspectionid
377471
Inspect Date
2024-05-04T00:00:00.000
Atdissuedate
2024-05-20T09:57:55.000
Cb
8
House Num
2748
Onstname
KINGSBRIDGE TER.
Atddismissed
No
11527
Atdid: 11527 • Atd Number: ATD-3-4706 • Bblid: 495672
Atdid
11527
Atd Number
ATD-3-4706
Bblid
495672
Inspectionid
349473
Inspect Date
2022-12-10T00:00:00.000
Atdissuedate
2022-12-19T10:43:51.000
Cb
15
House Num
2115
Onstname
E. 5TH ST.
Atddismissed
No
13958
Atdid: 13958 • Atd Number: ATD-4-5795 • Bblid: 676222
Atdid
13958
Atd Number
ATD-4-5795
Bblid
676222
Inspectionid
371621
Inspect Date
2024-02-08T00:00:00.000
Atdissuedate
2024-02-14T12:52:09.000
Cb
5
House Num
79-53
Onstname
78TH AVE.
Atddismissed
No
10237
Atdid: 10237 • Atd Number: ATD-3-3816 • Bblid: 332750
Atdid
10237
Atd Number
ATD-3-3816
Bblid
332750
Inspectionid
337369
Inspect Date
2022-06-03T00:00:00.000
Atdissuedate
2022-06-06T13:07:44.000
Cb
1
House Num
78
Onstname
PENN ST.
Atddismissed
No
14430
Atdid: 14430 • Atd Number: ATD-3-5964 • Bblid: 457837
Atdid
14430
Atd Number
ATD-3-5964
Bblid
457837
Inspectionid
377080
Inspect Date
2024-04-10T00:00:00.000
Atdissuedate
2024-05-08T13:08:30.000
Cb
11
House Num
7318
Onstname
17TH AVE.
Atddismissed
No
10964
Atdid: 10964 • Atd Number: ATD-3-4322 • Bblid: 279296
Atdid
10964
Atd Number
ATD-3-4322
Bblid
279296
Inspectionid
344279
Inspect Date
2022-09-20T00:00:00.000
Atdissuedate
2022-09-22T09:11:44.000
Cb
6
House Num
148
Onstname
11TH ST.
Atddismissed
No
13660
Atdid: 13660 • Atd Number: ATD-5-850 • Bblid: 947145
Atdid
13660
Atd Number
ATD-5-850
Bblid
947145
Inspectionid
366339
Inspect Date
2023-11-03T00:00:00.000
Atdissuedate
2023-11-06T10:41:23.000
Cb
2
House Num
428
Onstname
BUCHANAN AVE.
Atddismissed
No
18345
Atdid: 18345 • Atd Number: ATD-4-7254 • Bblid: 855431
Atdid
18345
Atd Number
ATD-4-7254
Bblid
855431
Inspectionid
404364
Inspect Date
2025-07-25T00:00:00.000
Atdissuedate
2025-08-18T10:14:45.000
Cb
10
House Num
116-56
Onstname
121ST ST.
Atddismissed
No
9105
Atdid: 9105 • Atd Number: ATD-4-4154 • Bblid: 687868
Atdid
9105
Atd Number
ATD-4-4154
Bblid
687868
Inspectionid
332656
Inspect Date
2019-06-29T00:00:00.000
Atdissuedate
2022-02-22T15:02:57.000
Cb
7
House Num
149-21
Onstname
10TH AVE.
Atddismissed
No
17253
Atdid: 17253 • Atd Number: ATD-4-6735 • Bblid: 586297
Atdid
17253
Atd Number
ATD-4-6735
Bblid
586297
Inspectionid
393201
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-04T11:33:37.000
Cb
1
House Num
21-34
Onstname
STEINWAY ST.
Atddismissed
No
18013
Atdid: 18013 • Atd Number: ATD-5-1001 • Bblid: 1037154
Atdid
18013
Atd Number
ATD-5-1001
Bblid
1037154
Inspectionid
401703
Inspect Date
2025-06-24T00:00:00.000
Atdissuedate
2025-07-01T11:30:06.000
Cb
3
House Num
61
Onstname
ALBEE AVE.
Atddismissed
No
13820
Atdid: 13820 • Atd Number: ATD-3-5686 • Bblid: 437178
Atdid
13820
Atd Number
ATD-3-5686
Bblid
437178
Inspectionid
370138
Inspect Date
2023-12-20T00:00:00.000
Atdissuedate
2023-12-28T08:53:34.000
Cb
12
House Num
5813
Onstname
13TH AVE.
Atddismissed
No
11709
Atdid: 11709 • Atd Number: ATD-4-5014 • Bblid: 577954
Atdid
11709
Atd Number
ATD-4-5014
Bblid
577954
Inspectionid
352011
Inspect Date
2023-02-03T00:00:00.000
Atdissuedate
2023-02-24T12:50:37.000
Cb
1
House Num
32-16
Onstname
32ND ST.
Atddismissed
No
9567
Atdid: 9567 • Atd Number: ATD-3-3558 • Bblid: 331722
Atdid
9567
Atd Number
ATD-3-3558
Bblid
331722
Inspectionid
333667
Inspect Date
2019-04-15T00:00:00.000
Atdissuedate
2022-03-11T11:22:24.000
Cb
1
House Num
138
Onstname
WILSON ST.
Atddismissed
No
8675
Atdid: 8675 • Atd Number: ATD-4-3901 • Bblid: 719574
Atdid
8675
Atd Number
ATD-4-3901
Bblid
719574
Inspectionid
330844
Inspect Date
2021-12-10T00:00:00.000
Atdissuedate
2021-12-16T15:25:34.000
Cb
11
House Num
56-09
Onstname
187TH ST.
Atddismissed
No
13518
Atdid: 13518 • Atd Number: ATD-5-836 • Bblid: 963360
Atdid
13518
Atd Number
ATD-5-836
Bblid
963360
Inspectionid
364694
Inspect Date
2023-09-28T00:00:00.000
Atdissuedate
2023-10-02T12:22:39.000
Cb
2
House Num
281
Onstname
LANDER AVE.
Atddismissed
No
12084
Atdid: 12084 • Atd Number: ATD-4-5151 • Bblid: 835647
Atdid
12084
Atd Number
ATD-4-5151
Bblid
835647
Inspectionid
356128
Inspect Date
2023-04-05T00:00:00.000
Atdissuedate
2023-04-24T09:00:22.000
Cb
12
House Num
112-29
Onstname
201ST ST.
Atddismissed
No
14654
Atdid: 14654 • Atd Number: ATD-3-6076 • Bblid: 498211
Atdid
14654
Atd Number
ATD-3-6076
Bblid
498211
Inspectionid
378795
Inspect Date
2024-04-25T00:00:00.000
Atdissuedate
2024-06-25T14:58:58.000
Cb
15
House Num
290
Onstname
AVENUE W.
Atddismissed
No
10407
Atdid: 10407 • Atd Number: ATD-4-4713 • Bblid: 702056
Atdid
10407
Atd Number
ATD-4-4713
Bblid
702056
Inspectionid
338954
Inspect Date
2022-07-09T00:00:00.000
Atdissuedate
2022-07-09T14:51:36.000
Cb
7
House Num
147-47
Onstname
41ST AVE.
Atddismissed
No
9089
Atdid: 9089 • Atd Number: ATD-4-4138 • Bblid: 622537
Atdid
9089
Atd Number
ATD-4-4138
Bblid
622537
Inspectionid
332639
Inspect Date
2019-06-01T00:00:00.000
Atdissuedate
2022-02-22T09:46:25.000
Cb
4
House Num
96-14
Onstname
50TH AVE.
Atddismissed
No
11387
Atdid: 11387 • Atd Number: ATD-3-4638 • Bblid: 260036
Atdid
11387
Atd Number
ATD-3-4638
Bblid
260036
Inspectionid
348061
Inspect Date
2022-11-09T00:00:00.000
Atdissuedate
2022-11-14T09:44:17.000
Cb
6
House Num
376
Onstname
UNION ST.
Atddismissed
No
14392
Atdid: 14392 • Atd Number: ATD-2-1270 • Bblid: 245140
Atdid
14392
Atd Number
ATD-2-1270
Bblid
245140
Inspectionid
376667
Inspect Date
2024-04-27T00:00:00.000
Atdissuedate
2024-05-06T11:20:55.000
Cb
8
House Num
5435
Onstname
FIELDSTON RD.
Atddismissed
No
17644
Atdid: 17644 • Atd Number: ATD-4-6913 • Bblid: 761117
Atdid
17644
Atd Number
ATD-4-6913
Bblid
761117
Inspectionid
397226
Inspect Date
2025-02-11T00:00:00.000
Atdissuedate
2025-05-16T10:47:27.000
Cb
13
House Num
240-15
Onstname
88TH AVE.
Atddismissed
No
14355
Atdid: 14355 • Atd Number: ATD-4-6001 • Bblid: 629994
Atdid
14355
Atd Number
ATD-4-6001
Bblid
629994
Inspectionid
376110
Inspect Date
2024-04-25T00:00:00.000
Atdissuedate
2024-04-25T12:58:06.000
Cb
6
House Num
112-36
Onstname
69TH RD.
Atddismissed
No
17226
Atdid: 17226 • Atd Number: ATD-4-6724 • Bblid: 862602
Atdid
17226
Atd Number
ATD-4-6724
Bblid
862602
Inspectionid
392958
Inspect Date
2025-03-29T00:00:00.000
Atdissuedate
2025-04-01T16:12:55.000
Cb
12
House Num
147-17
Onstname
116TH AVE.
Atddismissed
No
13168
Atdid: 13168 • Atd Number: ATD-5-793 • Bblid: 967181
Atdid
13168
Atd Number
ATD-5-793
Bblid
967181
Inspectionid
361720
Inspect Date
2023-08-01T00:00:00.000
Atdissuedate
2023-08-07T14:35:46.000
Cb
2
House Num
138
Onstname
JOSEPH AVE.
Atddismissed
No
11980
Atdid: 11980 • Atd Number: ATD-4-5099 • Bblid: 656674
Atdid
11980
Atd Number
ATD-4-5099
Bblid
656674
Inspectionid
354450
Inspect Date
2023-04-05T00:00:00.000
Atdissuedate
2023-04-05T11:22:23.000
Cb
6
House Num
67-89
Onstname
FLEET ST.
Atddismissed
No
16636
Atdid: 16636 • Atd Number: ATD-4-6535 • Bblid: 665764
Atdid
16636
Atd Number
ATD-4-6535
Bblid
665764
Inspectionid
388439
Inspect Date
2024-12-26T00:00:00.000
Atdissuedate
2025-01-03T11:44:09.000
Cb
5
House Num
5922
Onstname
BLEECKER ST.
Atddismissed
No
9318
Atdid: 9318 • Atd Number: ATD-3-3422 • Bblid: 440657
Atdid
9318
Atd Number
ATD-3-3422
Bblid
440657
Inspectionid
333024
Inspect Date
2019-07-19T00:00:00.000
Atdissuedate
2022-03-02T08:58:39.000
Cb
7
House Num
523
Onstname
62ND ST.
Atddismissed
No
3145
Atdid: 3145 • Atd Number: ATD-3-2207 • Bblid: 251262
Atdid
3145
Atd Number
ATD-3-2207
Bblid
251262
Violationid
251721
Atdissuedate
2020-02-13T00:00:00.000
Cb
2
House Num
98
Onstname
DEAN STREET
Atddismissed
Yes
Atddismissedon
2023-02-07T12:52:32.000
16373
Atdid: 16373 • Atd Number: ATD-3-6412 • Bblid: 494117
Atdid
16373
Atd Number
ATD-3-6412
Bblid
494117
Inspectionid
385052
Inspect Date
2024-11-15T00:00:00.000
Atdissuedate
2024-11-14T13:37:09.000
Cb
15
House Num
709
Onstname
AVENUE T.
Atddismissed
No
12477
Atdid: 12477 • Atd Number: ATD-4-5309 • Bblid: 630364
Atdid
12477
Atd Number
ATD-4-5309
Bblid
630364
Inspectionid
358000
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T11:17:51.000
Cb
2
House Num
46-19
Onstname
48TH AVE.
Atddismissed
No
13350
Atdid: 13350 • Atd Number: ATD-3-5486 • Bblid: 375702
Atdid
13350
Atd Number
ATD-3-5486
Bblid
375702
Inspectionid
362884
Inspect Date
2023-08-15T00:00:00.000
Atdissuedate
2023-08-29T15:12:06.000
Cb
5
House Num
163
Onstname
ATKINS AVE.
Atddismissed
No
13519
Atdid: 13519 • Atd Number: ATD-5-837 • Bblid: 963348
Atdid
13519
Atd Number
ATD-5-837
Bblid
963348
Inspectionid
364701
Inspect Date
2023-09-28T00:00:00.000
Atdissuedate
2023-10-02T12:25:49.000
Cb
2
House Num
261
Onstname
LANDER AVE.
Atddismissed
No
13377
Atdid: 13377 • Atd Number: ATD-5-809 • Bblid: 947726
Atdid
13377
Atd Number
ATD-5-809
Bblid
947726
Inspectionid
363285
Inspect Date
2023-09-09T00:00:00.000
Atdissuedate
2023-09-11T12:35:18.000
Cb
2
House Num
279
Onstname
MARTIN AVE.
Atddismissed
No
NYC Data AI • Public-data exploration interface