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
9013
Atdid: 9013 • Atd Number: ATD-3-3295 • Bblid: 302073
Atdid
9013
Atd Number
ATD-3-3295
Bblid
302073
Inspectionid
332355
Inspect Date
2019-08-20T00:00:00.000
Atdissuedate
2022-02-10T09:47:51.000
Cb
3
House Num
595
Onstname
DECATUR ST.
Atddismissed
No
11915
Atdid: 11915 • Atd Number: ATD-3-4867 • Bblid: 310921
Atdid
11915
Atd Number
ATD-3-4867
Bblid
310921
Inspectionid
354121
Inspect Date
2023-03-07T00:00:00.000
Atdissuedate
2023-03-28T11:49:43.000
Cb
3
House Num
574
Onstname
MACDONOUGH ST.
Atddismissed
No
14389
Atdid: 14389 • Atd Number: ATD-4-6009 • Bblid: 896104
Atdid
14389
Atd Number
ATD-4-6009
Bblid
896104
Inspectionid
376608
Inspect Date
2024-05-03T00:00:00.000
Atdissuedate
2024-05-03T10:55:02.000
Cb
13
House Num
249-16
Onstname
148TH AVE.
Atddismissed
No
16209
Atdid: 16209 • Atd Number: ATD-3-6343 • Bblid: 420755
Atdid
16209
Atd Number
ATD-3-6343
Bblid
420755
Inspectionid
384068
Inspect Date
2024-10-08T00:00:00.000
Atdissuedate
2024-10-15T08:36:58.000
Cb
12
House Num
418
Onstname
CORTELYOU RD.
Atddismissed
No
9355
Atdid: 9355 • Atd Number: ATD-3-3452 • Bblid: 505730
Atdid
9355
Atd Number
ATD-3-3452
Bblid
505730
Inspectionid
333078
Inspect Date
2021-05-04T00:00:00.000
Atdissuedate
2022-03-02T17:21:02.000
Cb
15
House Num
2005
Onstname
COYLE ST.
Atddismissed
No
18559
Atdid: 18559 • Atd Number: ATD-2-1468 • Bblid: 202062
Atdid
18559
Atd Number
ATD-2-1468
Bblid
202062
Inspectionid
405591
Inspect Date
2025-08-29T00:00:00.000
Atdissuedate
2025-09-09T13:19:42.000
Cb
11
House Num
1921
Onstname
YATES AVE.
Atddismissed
No
18009
Atdid: 18009 • Atd Number: ATD-5-997 • Bblid: 1028271
Atdid
18009
Atd Number
ATD-5-997
Bblid
1028271
Inspectionid
401667
Inspect Date
2025-04-28T00:00:00.000
Atdissuedate
2025-06-30T11:49:40.000
Cb
3
House Num
51
Onstname
LUDLOW ST.
Atddismissed
No
10612
Atdid: 10612 • Atd Number: ATD-3-4032 • Bblid: 342878
Atdid
10612
Atd Number
ATD-3-4032
Bblid
342878
Inspectionid
341012
Inspect Date
2022-07-12T00:00:00.000
Atdissuedate
2022-08-08T10:50:52.000
Cb
1
House Num
583
Onstname
LEONARD ST.
Atddismissed
No
10251
Atdid: 10251 • Atd Number: ATD-4-4640 • Bblid: 845828
Atdid
10251
Atd Number
ATD-4-4640
Bblid
845828
Inspectionid
337458
Inspect Date
2022-06-08T00:00:00.000
Atdissuedate
2022-06-08T11:12:35.000
Cb
10
House Num
132-32
Onstname
87TH ST.
Atddismissed
No
16819
Atdid: 16819 • Atd Number: ATD-3-6603 • Bblid: 304049
Atdid
16819
Atd Number
ATD-3-6603
Bblid
304049
Inspectionid
389779
Inspect Date
2025-02-07T00:00:00.000
Atdissuedate
2025-02-12T10:09:45.000
Cb
16
House Num
289
Onstname
MACDOUGAL ST.
Atddismissed
No
10846
Atdid: 10846 • Atd Number: ATD-3-4217 • Bblid: 299821
Atdid
10846
Atd Number
ATD-3-4217
Bblid
299821
Inspectionid
343373
Inspect Date
2022-09-07T00:00:00.000
Atdissuedate
2022-09-12T10:18:56.000
Cb
16
House Num
292
Onstname
SARATOGA AVE.
Atddismissed
No
17890
Atdid: 17890 • Atd Number: ATD-3-7046 • Bblid: 443769
Atdid
17890
Atd Number
ATD-3-7046
Bblid
443769
Inspectionid
400369
Inspect Date
2025-06-13T00:00:00.000
Atdissuedate
2025-06-13T15:00:22.000
Cb
10
House Num
246
Onstname
71ST ST.
Atddismissed
No
16779
Atdid: 16779 • Atd Number: ATD-4-6608 • Bblid: 907661
Atdid
16779
Atd Number
ATD-4-6608
Bblid
907661
Inspectionid
389359
Inspect Date
2025-01-15T00:00:00.000
Atdissuedate
2025-02-05T10:36:38.000
Cb
14
House Num
160
Onstname
BEACH 3RD ST.
Atddismissed
No
9372
Atdid: 9372 • Atd Number: ATD-3-3469 • Bblid: 285086
Atdid
9372
Atd Number
ATD-3-3469
Bblid
285086
Inspectionid
333097
Inspect Date
2021-06-14T00:00:00.000
Atdissuedate
2022-03-03T08:39:14.000
Cb
7
House Num
35
Onstname
FULLER PL.
Atddismissed
No
9729
Atdid: 9729 • Atd Number: ATD-4-4413 • Bblid: 760772
Atdid
9729
Atd Number
ATD-4-4413
Bblid
760772
Inspectionid
334142
Inspect Date
2016-07-20T00:00:00.000
Atdissuedate
2022-03-24T17:54:02.000
Cb
13
House Num
235-03
Onstname
88TH AVE.
Atddismissed
No
12944
Atdid: 12944 • Atd Number: ATD-5-769 • Bblid: 997442
Atdid
12944
Atd Number
ATD-5-769
Bblid
997442
Inspectionid
360433
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-07-21T10:52:52.000
Cb
2
House Num
344
Onstname
HAMDEN AVE.
Atddismissed
No
17704
Atdid: 17704 • Atd Number: ATD-3-6996 • Bblid: 471498
Atdid
17704
Atd Number
ATD-3-6996
Bblid
471498
Inspectionid
398123
Inspect Date
2025-05-15T00:00:00.000
Atdissuedate
2025-05-21T14:12:56.000
Cb
12
House Num
1365
Onstname
E. 4TH ST.
Atddismissed
No
9444
Atdid: 9444 • Atd Number: ATD-3-3507 • Bblid: 450423
Atdid
9444
Atd Number
ATD-3-3507
Bblid
450423
Inspectionid
333278
Inspect Date
2021-08-12T00:00:00.000
Atdissuedate
2022-03-04T17:17:43.000
Cb
10
House Num
467
Onstname
85TH ST.
Atddismissed
No
13356
Atdid: 13356 • Atd Number: ATD-3-5491 • Bblid: 445481
Atdid
13356
Atd Number
ATD-3-5491
Bblid
445481
Violationid
280957
Reinspectionid
35732
Inspect Date
2023-08-31T14:04:53.000
Atdissuedate
2023-08-31T14:04:53.000
Cb
10
House Num
1064
Onstname
73 STREET
Atddismissed
No
11538
Atdid: 11538 • Atd Number: ATD-1-265 • Bblid: 117117
Atdid
11538
Atd Number
ATD-1-265
Bblid
117117
Inspectionid
349680
Inspect Date
2022-12-09T00:00:00.000
Atdissuedate
2022-12-27T09:11:52.000
Cb
10
House Num
19
Onstname
W. 122ND ST.
Atddismissed
No
11481
Atdid: 11481 • Atd Number: ATD-3-4685 • Bblid: 259956
Atdid
11481
Atd Number
ATD-3-4685
Bblid
259956
Inspectionid
348892
Inspect Date
2022-11-30T00:00:00.000
Atdissuedate
2022-12-02T07:32:35.000
Cb
6
House Num
472
Onstname
SACKETT ST.
Atddismissed
No
12788
Atdid: 12788 • Atd Number: ATD-3-5122 • Bblid: 502600
Atdid
12788
Atd Number
ATD-3-5122
Bblid
502600
Inspectionid
359594
Inspect Date
2023-07-08T00:00:00.000
Atdissuedate
2023-07-08T11:00:17.000
Cb
15
House Num
1940
Onstname
E. 12TH ST.
Atddismissed
No
14997
Atdid: 14997 • Atd Number: ATD-4-6267 • Bblid: 695913
Atdid
14997
Atd Number
ATD-4-6267
Bblid
695913
Inspectionid
381497
Inspect Date
2024-08-20T00:00:00.000
Atdissuedate
2024-09-09T09:12:57.000
Cb
7
House Num
156-05
Onstname
29TH AVE.
Atddismissed
No
17126
Atdid: 17126 • Atd Number: ATD-3-6771 • Bblid: 510207
Atdid
17126
Atd Number
ATD-3-6771
Bblid
510207
Inspectionid
392537
Inspect Date
2022-04-19T00:00:00.000
Atdissuedate
2025-03-28T15:34:15.000
Cb
15
House Num
2466
Onstname
E. 27TH ST.
Atddismissed
No
12236
Atdid: 12236 • Atd Number: ATD-3-5022 • Bblid: 562666
Atdid
12236
Atd Number
ATD-3-5022
Bblid
562666
Inspectionid
357057
Inspect Date
2023-04-21T00:00:00.000
Atdissuedate
2023-05-15T10:25:22.000
Cb
15
House Num
2041
Onstname
GERRITSEN AVE.
Atddismissed
No
17535
Atdid: 17535 • Atd Number: ATD-4-6847 • Bblid: 678628
Atdid
17535
Atd Number
ATD-4-6847
Bblid
678628
Inspectionid
396268
Inspect Date
2025-04-29T00:00:00.000
Atdissuedate
2025-05-05T13:58:49.000
Cb
6
House Num
97-36
Onstname
72ND DR.
Atddismissed
No
8854
Atdid: 8854 • Atd Number: ATD-5-593 • Bblid: 1054066
Atdid
8854
Atd Number
ATD-5-593
Bblid
1054066
Inspectionid
331785
Inspect Date
2022-01-19T00:00:00.000
Atdissuedate
2022-01-21T12:33:15.000
Cb
3
House Num
64
Onstname
CARTERET ST.
Atddismissed
No
14428
Atdid: 14428 • Atd Number: ATD-3-5962 • Bblid: 277717
Atdid
14428
Atd Number
ATD-3-5962
Bblid
277717
Inspectionid
377058
Inspect Date
2024-04-17T00:00:00.000
Atdissuedate
2024-05-08T12:54:10.000
Cb
6
House Num
387
Onstname
5TH ST.
Atddismissed
No
9660
Atdid: 9660 • Atd Number: ATD-4-4363 • Bblid: 797703
Atdid
9660
Atd Number
ATD-4-4363
Bblid
797703
Inspectionid
333857
Inspect Date
2019-08-09T00:00:00.000
Atdissuedate
2022-03-16T15:48:47.000
Cb
9
House Num
102-28
Onstname
VAN WYCK EXPY.
Atddismissed
No
16573
Atdid: 16573 • Atd Number: ATD-3-6503 • Bblid: 297888
Atdid
16573
Atd Number
ATD-3-6503
Bblid
297888
Inspectionid
387001
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2024-12-20T10:32:46.000
Cb
8
House Num
1257
Onstname
LINCOLN PL.
Atddismissed
No
13867
Atdid: 13867 • Atd Number: ATD-3-5702 • Bblid: 399617
Atdid
13867
Atd Number
ATD-3-5702
Bblid
399617
Inspectionid
370701
Inspect Date
2024-01-12T00:00:00.000
Atdissuedate
2024-01-12T12:40:39.000
Cb
9
House Num
121
Onstname
E. 45TH ST.
Atddismissed
No
18011
Atdid: 18011 • Atd Number: ATD-5-999 • Bblid: 1028279
Atdid
18011
Atd Number
ATD-5-999
Bblid
1028279
Inspectionid
401669
Inspect Date
2025-04-28T00:00:00.000
Atdissuedate
2025-06-30T11:54:54.000
Cb
3
House Num
43
Onstname
LUDLOW ST.
Atddismissed
No
8488
Atdid: 8488 • Atd Number: ATD-3-3091 • Bblid: 315536
Atdid
8488
Atd Number
ATD-3-3091
Bblid
315536
Inspectionid
329604
Inspect Date
2021-11-10T00:00:00.000
Atdissuedate
2021-11-15T10:52:40.000
Cb
3
House Num
276
Onstname
CLIFTON PL.
Atddismissed
No
18240
Atdid: 18240 • Atd Number: ATD-2-1439 • Bblid: 236397
Atdid
18240
Atd Number
ATD-2-1439
Bblid
236397
Inspectionid
403550
Inspect Date
2025-06-27T00:00:00.000
Atdissuedate
2025-08-04T12:01:17.000
Cb
10
House Num
619
Onstname
VINCENT AVE.
Atddismissed
No
13276
Atdid: 13276 • Atd Number: ATD-2-1222 • Bblid: 178149
Atdid
13276
Atd Number
ATD-2-1222
Bblid
178149
Inspectionid
362220
Inspect Date
2023-08-11T00:00:00.000
Atdissuedate
2023-08-21T10:13:50.000
Cb
9
House Num
2050
Onstname
BLACKROCK AVE.
Atddismissed
No
14849
Atdid: 14849 • Atd Number: ATD-3-6170 • Bblid: 504606
Atdid
14849
Atd Number
ATD-3-6170
Bblid
504606
Inspectionid
380119
Inspect Date
2024-08-02T00:00:00.000
Atdissuedate
2024-08-05T10:29:50.000
Cb
15
House Num
2157
Onstname
E. 21ST ST.
Atddismissed
No
12016
Atdid: 12016 • Atd Number: ATD-5-685 • Bblid: 968205
Atdid
12016
Atd Number
ATD-5-685
Bblid
968205
Violationid
284352
Reinspectionid
34289
Inspect Date
2023-04-13T10:12:35.000
Atdissuedate
2023-04-13T10:12:35.000
Cb
2
House Num
88
Onstname
CARPENTER AVENUE
Atddismissed
No
11782
Atdid: 11782 • Atd Number: ATD-4-5042 • Bblid: 838630
Atdid
11782
Atd Number
ATD-4-5042
Bblid
838630
Inspectionid
352820
Inspect Date
2023-03-09T00:00:00.000
Atdissuedate
2023-03-13T12:22:46.000
Cb
12
House Num
191-36
Onstname
116TH AVE.
Atddismissed
No
13876
Atdid: 13876 • Atd Number: ATD-4-5748 • Bblid: 770348
Atdid
13876
Atd Number
ATD-4-5748
Bblid
770348
Inspectionid
370800
Inspect Date
2024-01-13T00:00:00.000
Atdissuedate
2024-01-18T13:25:29.000
Cb
13
House Num
83-11
Onstname
250TH ST.
Atddismissed
No
16292
Atdid: 16292 • Atd Number: ATD-3-6370 • Bblid: 471016
Atdid
16292
Atd Number
ATD-3-6370
Bblid
471016
Inspectionid
384447
Inspect Date
2024-10-28T00:00:00.000
Atdissuedate
2024-10-28T09:46:40.000
Cb
12
House Num
965
Onstname
OCEAN PARKWAY
Atddismissed
No
8689
Atdid: 8689 • Atd Number: ATD-4-3911 • Bblid: 776412
Atdid
8689
Atd Number
ATD-4-3911
Bblid
776412
Inspectionid
330858
Inspect Date
2021-12-15T00:00:00.000
Atdissuedate
2021-12-17T11:38:26.000
Cb
9
House Num
86-27
Onstname
79TH ST.
Atddismissed
No
13816
Atdid: 13816 • Atd Number: ATD-4-5711 • Bblid: 861140
Atdid
13816
Atd Number
ATD-4-5711
Bblid
861140
Inspectionid
370095
Inspect Date
2023-12-01T00:00:00.000
Atdissuedate
2023-12-26T12:08:34.000
Cb
12
House Num
111-71
Onstname
INWOOD ST.
Atddismissed
No
10405
Atdid: 10405 • Atd Number: ATD-4-4711 • Bblid: 702061
Atdid
10405
Atd Number
ATD-4-4711
Bblid
702061
Inspectionid
338949
Inspect Date
2022-07-09T00:00:00.000
Atdissuedate
2022-07-09T14:50:07.000
Cb
7
House Num
147-31
Onstname
41ST AVE.
Atddismissed
No
16591
Atdid: 16591 • Atd Number: ATD-4-6516 • Bblid: 581255
Atdid
16591
Atd Number
ATD-4-6516
Bblid
581255
Inspectionid
387142
Inspect Date
2024-12-02T00:00:00.000
Atdissuedate
2024-12-20T13:57:12.000
Cb
1
House Num
30-92
Onstname
41ST ST.
Atddismissed
No
17665
Atdid: 17665 • Atd Number: ATD-3-6984 • Bblid: 373208
Atdid
17665
Atd Number
ATD-3-6984
Bblid
373208
Inspectionid
397586
Inspect Date
2025-05-15T00:00:00.000
Atdissuedate
2025-05-19T09:35:24.000
Cb
5
House Num
66
Onstname
ELTON ST.
Atddismissed
No
13737
Atdid: 13737 • Atd Number: ATD-4-5657 • Bblid: 882718
Atdid
13737
Atd Number
ATD-4-5657
Bblid
882718
Inspectionid
368921
Inspect Date
2023-12-05T00:00:00.000
Atdissuedate
2023-12-05T14:24:25.000
Cb
13
House Num
130-42
Onstname
227TH ST.
Atddismissed
No
16831
Atdid: 16831 • Atd Number: ATD-3-6610 • Bblid: 507306
Atdid
16831
Atd Number
ATD-3-6610
Bblid
507306
Inspectionid
389949
Inspect Date
2025-02-20T00:00:00.000
Atdissuedate
2025-02-24T09:39:01.000
Cb
15
House Num
1701
Onstname
AVENUE W.
Atddismissed
No
10802
Atdid: 10802 • Atd Number: ATD-3-4178 • Bblid: 551645
Atdid
10802
Atd Number
ATD-3-4178
Bblid
551645
Inspectionid
343005
Inspect Date
2022-09-07T00:00:00.000
Atdissuedate
2022-09-08T11:21:04.000
Cb
18
House Num
1796
Onstname
E. 51ST ST.
Atddismissed
No
10432
Atdid: 10432 • Atd Number: ATD-4-4719 • Bblid: 803852
Atdid
10432
Atd Number
ATD-4-4719
Bblid
803852
Inspectionid
339253
Inspect Date
2022-07-11T00:00:00.000
Atdissuedate
2022-07-12T12:17:11.000
Cb
12
House Num
88-05
Onstname
146TH ST.
Atddismissed
No
16938
Atdid: 16938 • Atd Number: ATD-3-6644 • Bblid: 281999
Atdid
16938
Atd Number
ATD-3-6644
Bblid
281999
Inspectionid
391425
Inspect Date
2025-03-11T00:00:00.000
Atdissuedate
2025-03-17T09:57:07.000
Cb
6
House Num
765
Onstname
CARROLL ST.
Atddismissed
No