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
12183
Atdid: 12183 • Atd Number: ATD-2-1036 • Bblid: 166777
Atdid
12183
Atd Number
ATD-2-1036
Bblid
166777
Inspectionid
356825
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2023-05-09T14:05:11.000
Cb
7
House Num
2675
Onstname
GRAND CONCOURSE
Atddismissed
No
9243
Atdid: 9243 • Atd Number: ATD-1-194 • Bblid: 114355
Atdid
9243
Atd Number
ATD-1-194
Bblid
114355
Inspectionid
332949
Inspect Date
2019-07-03T00:00:00.000
Atdissuedate
2022-03-01T17:23:20.000
Cb
11
House Num
1451
Onstname
5TH AVE.
Atddismissed
Yes
Atddismissedon
2022-11-02T14:31:09.000
10254
Atdid: 10254 • Atd Number: ATD-4-4643 • Bblid: 845822
Atdid
10254
Atd Number
ATD-4-4643
Bblid
845822
Inspectionid
337461
Inspect Date
2022-06-08T00:00:00.000
Atdissuedate
2022-06-08T11:14:35.000
Cb
10
House Num
132-26
Onstname
87TH ST.
Atddismissed
No
12480
Atdid: 12480 • Atd Number: ATD-4-5312 • Bblid: 782750
Atdid
12480
Atd Number
ATD-4-5312
Bblid
782750
Inspectionid
358003
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T11:20:11.000
Cb
9
House Num
84-02
Onstname
ATLANTIC AVENUE
Atddismissed
No
12403
Atdid: 12403 • Atd Number: ATD-3-5045 • Bblid: 307763
Atdid
12403
Atd Number
ATD-3-5045
Bblid
307763
Inspectionid
357648
Inspect Date
2023-05-24T00:00:00.000
Atdissuedate
2023-05-25T08:31:35.000
Cb
3
House Num
541A
Onstname
QUINCY ST.
Atddismissed
No
13446
Atdid: 13446 • Atd Number: ATD-2-1241 • Bblid: 216302
Atdid
13446
Atd Number
ATD-2-1241
Bblid
216302
Inspectionid
364021
Inspect Date
2023-08-08T00:00:00.000
Atdissuedate
2023-09-21T10:08:22.000
Cb
12
House Num
3228
Onstname
SEYMOUR AVE.
Atddismissed
No
14286
Atdid: 14286 • Atd Number: ATD-4-5952 • Bblid: 684999
Atdid
14286
Atd Number
ATD-4-5952
Bblid
684999
Inspectionid
375363
Inspect Date
2024-03-30T00:00:00.000
Atdissuedate
2024-04-15T14:00:08.000
Cb
7
House Num
23-39
Onstname
WHITESTONE EXPY.
Atddismissed
No
9659
Atdid: 9659 • Atd Number: ATD-4-4362 • Bblid: 797701
Atdid
9659
Atd Number
ATD-4-4362
Bblid
797701
Inspectionid
333856
Inspect Date
2019-08-09T00:00:00.000
Atdissuedate
2022-03-16T15:44:14.000
Cb
9
House Num
102-26
Onstname
VAN WYCK EXPY.
Atddismissed
No
9246
Atdid: 9246 • Atd Number: ATD-3-3377 • Bblid: 469456
Atdid
9246
Atd Number
ATD-3-3377
Bblid
469456
Inspectionid
332952
Inspect Date
2020-11-25T00:00:00.000
Atdissuedate
2022-03-01T17:26:59.000
Cb
11
House Num
8895
Onstname
18TH AVE.
Atddismissed
No
11755
Atdid: 11755 • Atd Number: ATD-3-4782 • Bblid: 290986
Atdid
11755
Atd Number
ATD-3-4782
Bblid
290986
Inspectionid
352571
Inspect Date
2022-04-19T00:00:00.000
Atdissuedate
2023-03-09T12:53:46.000
Cb
8
House Num
687
Onstname
SAINT JOHNS PL.
Atddismissed
No
12470
Atdid: 12470 • Atd Number: ATD-4-5302 • Bblid: 609311
Atdid
12470
Atd Number
ATD-4-5302
Bblid
609311
Inspectionid
357973
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T10:06:23.000
Cb
3
House Num
88-01
Onstname
ROOSEVELT AVE.
Atddismissed
No
12855
Atdid: 12855 • Atd Number: ATD-3-5159 • Bblid: 510270
Atdid
12855
Atd Number
ATD-3-5159
Bblid
510270
Inspectionid
359997
Inspect Date
2023-07-14T00:00:00.000
Atdissuedate
2023-07-14T12:51:09.000
Cb
15
House Num
2426
Onstname
E. 28TH ST.
Atddismissed
No
13899
Atdid: 13899 • Atd Number: ATD-3-5710 • Bblid: 511282
Atdid
13899
Atd Number
ATD-3-5710
Bblid
511282
Inspectionid
371062
Inspect Date
2024-01-13T00:00:00.000
Atdissuedate
2024-01-29T13:01:39.000
Cb
15
House Num
4599
Onstname
BEDFORD AVE.
Atddismissed
No
10343
Atdid: 10343 • Atd Number: ATD-3-3860 • Bblid: 315957
Atdid
10343
Atd Number
ATD-3-3860
Bblid
315957
Inspectionid
338353
Inspect Date
2022-06-30T00:00:00.000
Atdissuedate
2022-06-30T13:01:24.000
Cb
3
House Num
132
Onstname
VAN BUREN ST.
Atddismissed
No
8723
Atdid: 8723 • Atd Number: ATD-4-3922 • Bblid: 773985
Atdid
8723
Atd Number
ATD-4-3922
Bblid
773985
Inspectionid
331050
Inspect Date
2021-12-03T00:00:00.000
Atdissuedate
2021-12-27T14:10:03.000
Cb
13
House Num
81-12
Onstname
267TH ST.
Atddismissed
No
10110
Atdid: 10110 • Atd Number: ATD-3-3727 • Bblid: 279861
Atdid
10110
Atd Number
ATD-3-3727
Bblid
279861
Inspectionid
336526
Inspect Date
2021-09-02T00:00:00.000
Atdissuedate
2022-05-17T11:47:28.000
Cb
6
House Num
343
Onstname
13TH ST.
Atddismissed
No
9768
Atdid: 9768 • Atd Number: ATD-2-911 • Bblid: 201714
Atdid
9768
Atd Number
ATD-2-911
Bblid
201714
Inspectionid
334361
Inspect Date
2019-06-22T00:00:00.000
Atdissuedate
2022-03-29T18:02:11.000
Cb
11
House Num
1926
Onstname
HONE AVE.
Atddismissed
No
16742
Atdid: 16742 • Atd Number: ATD-4-6586 • Bblid: 795605
Atdid
16742
Atd Number
ATD-4-6586
Bblid
795605
Inspectionid
388952
Inspect Date
2025-01-02T00:00:00.000
Atdissuedate
2025-01-24T14:42:27.000
Cb
9
House Num
94-19
Onstname
121ST ST.
Atddismissed
No
12223
Atdid: 12223 • Atd Number: ATD-3-5009 • Bblid: 328512
Atdid
12223
Atd Number
ATD-3-5009
Bblid
328512
Inspectionid
356954
Inspect Date
2023-05-11T00:00:00.000
Atdissuedate
2023-05-11T15:09:19.000
Cb
2
House Num
45
Onstname
S. PORTLAND AVE.
Atddismissed
No
14806
Atdid: 14806 • Atd Number: ATD-3-6146 • Bblid: 458223
Atdid
14806
Atd Number
ATD-3-6146
Bblid
458223
Inspectionid
379873
Inspect Date
2024-07-25T00:00:00.000
Atdissuedate
2024-07-27T10:05:58.000
Cb
11
House Num
1531
Onstname
BAY RIDGE PKWY.
Atddismissed
No
16126
Atdid: 16126 • Atd Number: ATD-2-1308 • Bblid: 147835
Atdid
16126
Atd Number
ATD-2-1308
Bblid
147835
Inspectionid
383322
Inspect Date
2024-09-16T00:00:00.000
Atdissuedate
2024-09-27T12:33:26.000
Cb
1
House Num
765
Onstname
WESTCHESTER AVENUE
Atddismissed
Yes
Atddismissedon
2024-11-06T13:54:43.000
9143
Atdid: 9143 • Atd Number: ATD-4-4170 • Bblid: 669394
Atdid
9143
Atd Number
ATD-4-4170
Bblid
669394
Inspectionid
332714
Inspect Date
2022-02-23T00:00:00.000
Atdissuedate
2022-02-23T12:19:59.000
Cb
5
House Num
74-18
Onstname
62ND ST.
Atddismissed
No
9102
Atdid: 9102 • Atd Number: ATD-4-4151 • Bblid: 687867
Atdid
9102
Atd Number
ATD-4-4151
Bblid
687867
Inspectionid
332653
Inspect Date
2019-06-29T00:00:00.000
Atdissuedate
2022-02-22T14:57:17.000
Cb
7
House Num
149-25
Onstname
10TH AVE.
Atddismissed
No
5776
Atdid: 5776 • Atd Number: ATD-4-2137 • Bblid: 651603
Atdid
5776
Atd Number
ATD-4-2137
Bblid
651603
Violationid
232705
Atdissuedate
2020-05-27T00:00:00.000
Cb
5
House Num
66-09
Onstname
70 STREET
Atddismissed
Yes
Atddismissedon
2023-08-16T08:25:24.000
12950
Atdid: 12950 • Atd Number: ATD-3-5227 • Bblid: 414142
Atdid
12950
Atd Number
ATD-3-5227
Bblid
414142
Inspectionid
360488
Inspect Date
2023-07-22T00:00:00.000
Atdissuedate
2023-07-22T12:43:55.000
Cb
14
House Num
565
Onstname
E. 29TH ST.
Atddismissed
No
9883
Atdid: 9883 • Atd Number: ATD-4-4490 • Bblid: 746834
Atdid
9883
Atd Number
ATD-4-4490
Bblid
746834
Inspectionid
334974
Inspect Date
2022-04-07T00:00:00.000
Atdissuedate
2022-04-15T11:20:08.000
Cb
8
House Num
67-14
Onstname
199TH ST.
Atddismissed
No
13509
Atdid: 13509 • Atd Number: ATD-4-5561 • Bblid: 608578
Atdid
13509
Atd Number
ATD-4-5561
Bblid
608578
Inspectionid
364600
Inspect Date
2023-09-28T00:00:00.000
Atdissuedate
2023-09-28T13:51:21.000
Cb
3
House Num
91-11
Onstname
35TH AVE.
Atddismissed
No
13101
Atdid: 13101 • Atd Number: ATD-4-5480 • Bblid: 788715
Atdid
13101
Atd Number
ATD-4-5480
Bblid
788715
Inspectionid
361382
Inspect Date
2023-08-01T00:00:00.000
Atdissuedate
2023-08-03T10:42:00.000
Cb
9
House Num
86-41
Onstname
111TH ST.
Atddismissed
No
14322
Atdid: 14322 • Atd Number: ATD-4-5977 • Bblid: 729318
Atdid
14322
Atd Number
ATD-4-5977
Bblid
729318
Inspectionid
375860
Inspect Date
2024-04-23T00:00:00.000
Atdissuedate
2024-04-23T09:34:23.000
Cb
11
House Num
41-30
Onstname
CORPORAL KENNEDY ST.
Atddismissed
No
17370
Atdid: 17370 • Atd Number: ATD-3-6887 • Bblid: 284566
Atdid
17370
Atd Number
ATD-3-6887
Bblid
284566
Inspectionid
394694
Inspect Date
2025-04-09T00:00:00.000
Atdissuedate
2025-04-15T07:38:17.000
Cb
7
House Num
17
Onstname
WINDSOR PL.
Atddismissed
No
9432
Atdid: 9432 • Atd Number: ATD-4-4232 • Bblid: 654790
Atdid
9432
Atd Number
ATD-4-4232
Bblid
654790
Inspectionid
333264
Inspect Date
2022-03-04T00:00:00.000
Atdissuedate
2022-03-04T14:40:22.000
Cb
6
House Num
63-34
Onstname
DIETERLE CRES
Atddismissed
No
14425
Atdid: 14425 • Atd Number: ATD-3-5959 • Bblid: 277725
Atdid
14425
Atd Number
ATD-3-5959
Bblid
277725
Inspectionid
377050
Inspect Date
2024-04-16T00:00:00.000
Atdissuedate
2024-05-08T12:51:41.000
Cb
6
House Num
379
Onstname
5TH ST.
Atddismissed
No
11765
Atdid: 11765 • Atd Number: ATD-3-4789 • Bblid: 516129
Atdid
11765
Atd Number
ATD-3-4789
Bblid
516129
Inspectionid
352620
Inspect Date
2023-03-10T00:00:00.000
Atdissuedate
2023-03-10T12:13:33.000
Cb
14
House Num
1136
Onstname
E. 28TH ST.
Atddismissed
No
14347
Atdid: 14347 • Atd Number: ATD-4-5994 • Bblid: 643803
Atdid
14347
Atd Number
ATD-4-5994
Bblid
643803
Inspectionid
376036
Inspect Date
2024-04-24T00:00:00.000
Atdissuedate
2024-04-24T10:15:07.000
Cb
5
House Num
60-33
Onstname
69TH LN.
Atddismissed
No
11506
Atdid: 11506 • Atd Number: ATD-3-4704 • Bblid: 280077
Atdid
11506
Atd Number
ATD-3-4704
Bblid
280077
Inspectionid
349262
Inspect Date
2022-11-30T00:00:00.000
Atdissuedate
2022-12-13T12:55:46.000
Cb
6
House Num
242
Onstname
13TH ST.
Atddismissed
No
11959
Atdid: 11959 • Atd Number: ATD-4-5088 • Bblid: 761700
Atdid
11959
Atd Number
ATD-4-5088
Bblid
761700
Inspectionid
354329
Inspect Date
2023-03-31T00:00:00.000
Atdissuedate
2023-03-31T13:52:07.000
Cb
13
House Num
89-05
Onstname
237TH ST.
Atddismissed
No
8869
Atdid: 8869 • Atd Number: ATD-4-4012 • Bblid: 607983
Atdid
8869
Atd Number
ATD-4-4012
Bblid
607983
Inspectionid
331838
Inspect Date
2022-01-12T00:00:00.000
Atdissuedate
2022-01-24T12:17:36.000
Cb
3
House Num
33-21
Onstname
85TH ST.
Atddismissed
No
14936
Atdid: 14936 • Atd Number: ATD-3-6214 • Bblid: 317967
Atdid
14936
Atd Number
ATD-3-6214
Bblid
317967
Inspectionid
380850
Inspect Date
2024-07-30T00:00:00.000
Atdissuedate
2024-08-19T15:20:54.000
Cb
3
House Num
238
Onstname
JEFFERSON AVE.
Atddismissed
No
17249
Atdid: 17249 • Atd Number: ATD-4-6731 • Bblid: 709705
Atdid
17249
Atd Number
ATD-4-6731
Bblid
709705
Inspectionid
393167
Inspect Date
2025-04-03T00:00:00.000
Atdissuedate
2025-04-04T11:02:47.000
Cb
7
House Num
33-19
Onstname
172ND ST.
Atddismissed
No
8632
Atdid: 8632 • Atd Number: ATD-4-3873 • Bblid: 772535
Atdid
8632
Atd Number
ATD-4-3873
Bblid
772535
Inspectionid
330770
Inspect Date
2021-12-07T00:00:00.000
Atdissuedate
2021-12-15T13:22:22.000
Cb
13
House Num
78-42
Onstname
268TH ST.
Atddismissed
No
11139
Atdid: 11139 • Atd Number: ATD-3-4470 • Bblid: 381345
Atdid
11139
Atd Number
ATD-3-4470
Bblid
381345
Inspectionid
345756
Inspect Date
2022-10-07T00:00:00.000
Atdissuedate
2022-10-13T12:50:55.000
Cb
5
House Num
73
Onstname
MILFORD ST.
Atddismissed
No
11970
Atdid: 11970 • Atd Number: ATD-2-1010 • Bblid: 231257
Atdid
11970
Atd Number
ATD-2-1010
Bblid
231257
Inspectionid
354394
Inspect Date
2023-02-27T00:00:00.000
Atdissuedate
2023-04-04T12:16:28.000
Cb
10
House Num
3257
Onstname
BRUCKNER BLVD.
Atddismissed
No
14099
Atdid: 14099 • Atd Number: ATD-4-5881 • Bblid: 897510
Atdid
14099
Atd Number
ATD-4-5881
Bblid
897510
Inspectionid
373101
Inspect Date
2024-03-12T00:00:00.000
Atdissuedate
2024-03-12T15:10:26.000
Cb
13
House Num
259-69
Onstname
148TH RD.
Atddismissed
Yes
Atddismissedon
2024-03-14T11:25:42.000
13804
Atdid: 13804 • Atd Number: ATD-4-5699 • Bblid: 861066
Atdid
13804
Atd Number
ATD-4-5699
Bblid
861066
Inspectionid
370023
Inspect Date
2023-11-22T00:00:00.000
Atdissuedate
2023-12-22T12:45:51.000
Cb
12
House Num
111-23
Onstname
INWOOD ST.
Atddismissed
No
10963
Atdid: 10963 • Atd Number: ATD-3-4321 • Bblid: 279294
Atdid
10963
Atd Number
ATD-3-4321
Bblid
279294
Inspectionid
344277
Inspect Date
2022-09-20T00:00:00.000
Atdissuedate
2022-09-22T09:10:20.000
Cb
6
House Num
146
Onstname
11TH ST.
Atddismissed
No
16729
Atdid: 16729 • Atd Number: ATD-3-6556 • Bblid: 277641
Atdid
16729
Atd Number
ATD-3-6556
Bblid
277641
Inspectionid
388925
Inspect Date
2025-01-04T00:00:00.000
Atdissuedate
2025-01-24T10:56:09.000
Cb
6
House Num
322
Onstname
4TH ST.
Atddismissed
No
13119
Atdid: 13119 • Atd Number: ATD-3-5332 • Bblid: 422812
Atdid
13119
Atd Number
ATD-3-5332
Bblid
422812
Inspectionid
361451
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T12:16:48.000
Cb
12
House Num
1536
Onstname
46TH ST.
Atddismissed
No
14205
Atdid: 14205 • Atd Number: ATD-4-5908 • Bblid: 819205
Atdid
14205
Atd Number
ATD-4-5908
Bblid
819205
Inspectionid
373917
Inspect Date
2024-03-21T00:00:00.000
Atdissuedate
2024-03-21T13:09:55.000
Cb
12
House Num
111-17
Onstname
180TH ST.
Atddismissed
No
11256
Atdid: 11256 • Atd Number: ATD-3-4562 • Bblid: 283379
Atdid
11256
Atd Number
ATD-3-4562
Bblid
283379
Inspectionid
346860
Inspect Date
2022-10-19T00:00:00.000
Atdissuedate
2022-10-24T13:21:11.000
Cb
6
House Num
538
Onstname
9 STREET
Atddismissed
No
13259
Atdid: 13259 • Atd Number: ATD-3-5430 • Bblid: 422881
Atdid
13259
Atd Number
ATD-3-5430
Bblid
422881
Inspectionid
362079
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T17:01:27.000
Cb
12
House Num
1686
Onstname
47TH ST.
Atddismissed
No