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
10300
Atdid: 10300 • Atd Number: ATD-3-3849 • Bblid: 252796
Atdid
10300
Atd Number
ATD-3-3849
Bblid
252796
Inspectionid
337751
Inspect Date
2022-06-16T00:00:00.000
Atdissuedate
2022-06-17T08:16:47.000
Cb
2
House Num
46
Onstname
SIDNEY PL.
Atddismissed
No
17049
Atdid: 17049 • Atd Number: ATD-3-6708 • Bblid: 267419
Atdid
17049
Atd Number
ATD-3-6708
Bblid
267419
Inspectionid
392377
Inspect Date
2023-06-23T00:00:00.000
Atdissuedate
2025-03-26T15:45:36.000
Cb
7
House Num
651
Onstname
50TH ST.
Atddismissed
No
8522
Atdid: 8522 • Atd Number: ATD-4-3834 • Bblid: 846733
Atdid
8522
Atd Number
ATD-4-3834
Bblid
846733
Inspectionid
330009
Inspect Date
2021-11-10T00:00:00.000
Atdissuedate
2021-11-24T12:02:52.000
Cb
10
House Num
92-20
Onstname
SILVER RD.
Atddismissed
No
13274
Atdid: 13274 • Atd Number: ATD-2-1220 • Bblid: 178159
Atdid
13274
Atd Number
ATD-2-1220
Bblid
178159
Inspectionid
362218
Inspect Date
2023-08-11T00:00:00.000
Atdissuedate
2023-08-21T10:11:16.000
Cb
9
House Num
2064
Onstname
BLACKROCK AVE.
Atddismissed
No
11065
Atdid: 11065 • Atd Number: ATD-3-4413 • Bblid: 473020
Atdid
11065
Atd Number
ATD-3-4413
Bblid
473020
Inspectionid
344983
Inspect Date
2022-09-28T00:00:00.000
Atdissuedate
2022-09-30T17:34:33.000
Cb
12
House Num
1406
Onstname
E. 5TH ST.
Atddismissed
No
12454
Atdid: 12454 • Atd Number: ATD-3-5059 • Bblid: 274494
Atdid
12454
Atd Number
ATD-3-5059
Bblid
274494
Inspectionid
357934
Inspect Date
2023-05-12T00:00:00.000
Atdissuedate
2023-06-01T09:48:47.000
Cb
6
House Num
51
Onstname
PARK PL.
Atddismissed
No
11647
Atdid: 11647 • Atd Number: ATD-3-4731 • Bblid: 282092
Atdid
11647
Atd Number
ATD-3-4731
Bblid
282092
Violationid
284117
Reinspectionid
35395
Inspect Date
2023-02-09T12:18:47.000
Atdissuedate
2023-02-09T12:18:47.000
Cb
6
House Num
855
Onstname
CARROLL STREET
Atddismissed
No
18162
Atdid: 18162 • Atd Number: ATD-2-1426 • Bblid: 206623
Atdid
18162
Atd Number
ATD-2-1426
Bblid
206623
Inspectionid
402927
Inspect Date
2025-07-16T00:00:00.000
Atdissuedate
2025-07-22T13:25:17.000
Cb
11
House Num
2430
Onstname
FISH AVE.
Atddismissed
No
18635
Atdid: 18635 • Atd Number: ATD-3-7346 • Bblid: 332201
Atdid
18635
Atd Number
ATD-3-7346
Bblid
332201
Inspectionid
406231
Inspect Date
2025-09-17T00:00:00.000
Atdissuedate
2025-09-22T08:55:13.000
Cb
1
House Num
146
Onstname
HOOPER ST.
Atddismissed
No
17147
Atdid: 17147 • Atd Number: ATD-3-6786 • Bblid: 274039
Atdid
17147
Atd Number
ATD-3-6786
Bblid
274039
Inspectionid
392640
Inspect Date
2021-10-28T00:00:00.000
Atdissuedate
2025-03-31T10:05:13.000
Cb
6
House Num
22
Onstname
SAINT MARKS AVE.
Atddismissed
No
17375
Atdid: 17375 • Atd Number: ATD-3-6892 • Bblid: 284540
Atdid
17375
Atd Number
ATD-3-6892
Bblid
284540
Inspectionid
394707
Inspect Date
2025-04-09T00:00:00.000
Atdissuedate
2025-04-15T07:49:13.000
Cb
7
House Num
43
Onstname
WINDSOR PL.
Atddismissed
No
8853
Atdid: 8853 • Atd Number: ATD-5-592 • Bblid: 1054068
Atdid
8853
Atd Number
ATD-5-592
Bblid
1054068
Inspectionid
331784
Inspect Date
2022-01-19T00:00:00.000
Atdissuedate
2022-01-21T12:32:20.000
Cb
3
House Num
78
Onstname
CARTERET ST.
Atddismissed
No
14424
Atdid: 14424 • Atd Number: ATD-3-5958 • Bblid: 277727
Atdid
14424
Atd Number
ATD-3-5958
Bblid
277727
Inspectionid
377048
Inspect Date
2024-04-16T00:00:00.000
Atdissuedate
2024-05-08T12:50:39.000
Cb
6
House Num
377
Onstname
5TH ST.
Atddismissed
No
16854
Atdid: 16854 • Atd Number: ATD-5-914 • Bblid: 1029077
Atdid
16854
Atd Number
ATD-5-914
Bblid
1029077
Inspectionid
390312
Inspect Date
2025-02-28T00:00:00.000
Atdissuedate
2025-03-05T11:13:47.000
Cb
3
House Num
260
Onstname
WOODROW RD.
Atddismissed
No
12340
Atdid: 12340 • Atd Number: ATD-4-5206 • Bblid: 602803
Atdid
12340
Atd Number
ATD-4-5206
Bblid
602803
Inspectionid
357433
Inspect Date
2023-05-19T00:00:00.000
Atdissuedate
2023-05-19T16:20:06.000
Cb
2
House Num
51-05
Onstname
QUEENS BLVD.
Atddismissed
No
13295
Atdid: 13295 • Atd Number: ATD-5-799 • Bblid: 963635
Atdid
13295
Atd Number
ATD-5-799
Bblid
963635
Inspectionid
362397
Inspect Date
2023-08-17T00:00:00.000
Atdissuedate
2023-08-22T13:04:02.000
Cb
2
House Num
369
Onstname
HILLMAN AVE.
Atddismissed
No
12005
Atdid: 12005 • Atd Number: ATD-4-5120 • Bblid: 746051
Atdid
12005
Atd Number
ATD-4-5120
Bblid
746051
Inspectionid
354706
Inspect Date
2023-04-10T00:00:00.000
Atdissuedate
2023-04-10T14:57:46.000
Cb
8
House Num
82-81
Onstname
164TH PL.
Atddismissed
No
11088
Atdid: 11088 • Atd Number: ATD-3-4436 • Bblid: 258470
Atdid
11088
Atd Number
ATD-3-4436
Bblid
258470
Inspectionid
345087
Inspect Date
2022-08-13T00:00:00.000
Atdissuedate
2022-10-03T13:01:44.000
Cb
2
House Num
287
Onstname
WARREN STREET
Atddismissed
No
16662
Atdid: 16662 • Atd Number: ATD-3-6530 • Bblid: 515884
Atdid
16662
Atd Number
ATD-3-6530
Bblid
515884
Inspectionid
388551
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2025-01-08T10:22:29.000
Cb
18
House Num
1174
Onstname
E. 38TH ST.
Atddismissed
No
10577
Atdid: 10577 • Atd Number: ATD-4-4761 • Bblid: 770835
Atdid
10577
Atd Number
ATD-4-4761
Bblid
770835
Inspectionid
340581
Inspect Date
2022-07-19T00:00:00.000
Atdissuedate
2022-07-29T10:58:52.000
Cb
13
House Num
85-39
Onstname
250TH ST.
Atddismissed
No
16530
Atdid: 16530 • Atd Number: ATD-3-6468 • Bblid: 292005
Atdid
16530
Atd Number
ATD-3-6468
Bblid
292005
Inspectionid
386442
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2024-12-18T07:45:00.000
Cb
8
House Num
441
Onstname
EASTERN PKWY.
Atddismissed
No
10256
Atdid: 10256 • Atd Number: ATD-4-4645 • Bblid: 845812
Atdid
10256
Atd Number
ATD-4-4645
Bblid
845812
Inspectionid
337466
Inspect Date
2022-06-08T00:00:00.000
Atdissuedate
2022-06-08T11:18:31.000
Cb
10
House Num
132-14
Onstname
87TH ST.
Atddismissed
No
14317
Atdid: 14317 • Atd Number: ATD-3-5901 • Bblid: 326086
Atdid
14317
Atd Number
ATD-3-5901
Bblid
326086
Inspectionid
375799
Inspect Date
2024-04-16T00:00:00.000
Atdissuedate
2024-04-22T14:32:35.000
Cb
2
House Num
410
Onstname
CUMBERLAND ST.
Atddismissed
No
16621
Atdid: 16621 • Atd Number: ATD-1-350 • Bblid: 92403
Atdid
16621
Atd Number
ATD-1-350
Bblid
92403
Inspectionid
387291
Inspect Date
2024-12-27T00:00:00.000
Atdissuedate
2024-12-30T12:18:29.000
Cb
8
House Num
4
Onstname
E. 73RD ST.
Atddismissed
No
13176
Atdid: 13176 • Atd Number: ATD-4-5494 • Bblid: 577003
Atdid
13176
Atd Number
ATD-4-5494
Bblid
577003
Inspectionid
361752
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-08-08T10:16:19.000
Cb
1
House Num
33-59
Onstname
28TH ST.
Atddismissed
No
12008
Atdid: 12008 • Atd Number: ATD-3-4907 • Bblid: 361369
Atdid
12008
Atd Number
ATD-3-4907
Bblid
361369
Inspectionid
354729
Inspect Date
2023-04-11T00:00:00.000
Atdissuedate
2023-04-11T13:10:27.000
Cb
4
House Num
249
Onstname
COVERT ST.
Atddismissed
No
9020
Atdid: 9020 • Atd Number: ATD-4-4095 • Bblid: 898840
Atdid
9020
Atd Number
ATD-4-4095
Bblid
898840
Inspectionid
332380
Inspect Date
2019-06-26T00:00:00.000
Atdissuedate
2022-02-10T16:24:46.000
Cb
13
House Num
148-78
Onstname
HUXLEY ST.
Atddismissed
No
10279
Atdid: 10279 • Atd Number: ATD-3-3836 • Bblid: 283121
Atdid
10279
Atd Number
ATD-3-3836
Bblid
283121
Inspectionid
337636
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-06-13T12:49:58.000
Cb
6
House Num
448
Onstname
8TH ST.
Atddismissed
No
14630
Atdid: 14630 • Atd Number: ATD-3-6067 • Bblid: 425049
Atdid
14630
Atd Number
ATD-3-6067
Bblid
425049
Violationid
286371
Reinspectionid
35705
Inspect Date
2024-06-18T11:29:48.000
Atdissuedate
2024-06-18T11:29:48.000
Cb
12
House Num
1524
Onstname
54 STREET
Atddismissed
No
14277
Atdid: 14277 • Atd Number: ATD-3-5890 • Bblid: 435096
Atdid
14277
Atd Number
ATD-3-5890
Bblid
435096
Inspectionid
375276
Inspect Date
2024-04-13T00:00:00.000
Atdissuedate
2024-04-13T09:21:55.000
Cb
12
House Num
1059
Onstname
54TH ST.
Atddismissed
No
14678
Atdid: 14678 • Atd Number: ATD-3-6092 • Bblid: 462992
Atdid
14678
Atd Number
ATD-3-6092
Bblid
462992
Inspectionid
378986
Inspect Date
2024-06-24T00:00:00.000
Atdissuedate
2024-07-02T12:50:19.000
Cb
11
House Num
1413
Onstname
83RD ST.
Atddismissed
No
11985
Atdid: 11985 • Atd Number: ATD-4-5104 • Bblid: 656708
Atdid
11985
Atd Number
ATD-4-5104
Bblid
656708
Inspectionid
354467
Inspect Date
2023-04-05T00:00:00.000
Atdissuedate
2023-04-05T11:34:24.000
Cb
6
House Num
67-51
Onstname
FLEET ST.
Atddismissed
No
16812
Atdid: 16812 • Atd Number: ATD-3-6597 • Bblid: 532145
Atdid
16812
Atd Number
ATD-3-6597
Bblid
532145
Inspectionid
389754
Inspect Date
2025-02-08T00:00:00.000
Atdissuedate
2025-02-11T11:04:07.000
Cb
18
House Num
678
Onstname
E. 80TH ST.
Atddismissed
No
17288
Atdid: 17288 • Atd Number: ATD-4-6747 • Bblid: 837458
Atdid
17288
Atd Number
ATD-4-6747
Bblid
837458
Inspectionid
393550
Inspect Date
2025-03-26T00:00:00.000
Atdissuedate
2025-04-08T11:57:59.000
Cb
12
House Num
114-07
Onstname
205TH ST.
Atddismissed
No
11984
Atdid: 11984 • Atd Number: ATD-4-5103 • Bblid: 656700
Atdid
11984
Atd Number
ATD-4-5103
Bblid
656700
Inspectionid
354463
Inspect Date
2023-04-05T00:00:00.000
Atdissuedate
2023-04-05T11:32:11.000
Cb
6
House Num
67-61
Onstname
FLEET ST.
Atddismissed
No
11800
Atdid: 11800 • Atd Number: ATD-4-5052 • Bblid: 771756
Atdid
11800
Atd Number
ATD-4-5052
Bblid
771756
Inspectionid
353048
Inspect Date
2023-03-15T00:00:00.000
Atdissuedate
2023-03-15T14:18:42.000
Cb
13
House Num
87-57
Onstname
253RD ST.
Atddismissed
No
18425
Atdid: 18425 • Atd Number: ATD-4-7295 • Bblid: 577839
Atdid
18425
Atd Number
ATD-4-7295
Bblid
577839
Inspectionid
404756
Inspect Date
2025-08-25T00:00:00.000
Atdissuedate
2025-08-25T12:54:19.000
Cb
1
House Num
35-51
Onstname
30TH ST.
Atddismissed
No
17842
Atdid: 17842 • Atd Number: ATD-4-7040 • Bblid: 711759
Atdid
17842
Atd Number
ATD-4-7040
Bblid
711759
Inspectionid
399651
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-06-09T12:36:20.000
Cb
7
House Num
41-37
Onstname
159TH ST.
Atddismissed
Yes
Atddismissedon
2025-08-05T13:21:13.000
8858
Atdid: 8858 • Atd Number: ATD-2-856 • Bblid: 209891
Atdid
8858
Atd Number
ATD-2-856
Bblid
209891
Inspectionid
331796
Inspect Date
2020-12-14T00:00:00.000
Atdissuedate
2022-01-21T13:15:07.000
Cb
12
House Num
837
Onstname
ADEE AVE.
Atddismissed
No
17079
Atdid: 17079 • Atd Number: ATD-3-6730 • Bblid: 294714
Atdid
17079
Atd Number
ATD-3-6730
Bblid
294714
Inspectionid
392451
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2025-03-27T14:54:22.000
Cb
9
House Num
175
Onstname
STERLING ST.
Atddismissed
No
8709
Atdid: 8709 • Atd Number: ATD-4-3919 • Bblid: 587924
Atdid
8709
Atd Number
ATD-4-3919
Bblid
587924
Inspectionid
330955
Inspect Date
2021-12-21T00:00:00.000
Atdissuedate
2021-12-21T13:57:27.000
Cb
1
House Num
23-53
Onstname
28TH ST.
Atddismissed
No
12515
Atdid: 12515 • Atd Number: ATD-4-5338 • Bblid: 690475
Atdid
12515
Atd Number
ATD-4-5338
Bblid
690475
Inspectionid
358135
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-05T12:37:54.000
Cb
7
House Num
145-47
Onstname
19TH AVE.
Atddismissed
No
17117
Atdid: 17117 • Atd Number: ATD-3-6763 • Bblid: 471785
Atdid
17117
Atd Number
ATD-3-6763
Bblid
471785
Inspectionid
392515
Inspect Date
2023-05-23T00:00:00.000
Atdissuedate
2025-03-28T14:33:38.000
Cb
12
House Num
705
Onstname
AVENUE M.
Atddismissed
No
18037
Atdid: 18037 • Atd Number: ATD-4-7120 • Bblid: 735810
Atdid
18037
Atd Number
ATD-4-7120
Bblid
735810
Inspectionid
401973
Inspect Date
2025-06-18T00:00:00.000
Atdissuedate
2025-07-09T13:15:52.000
Cb
8
House Num
75-04
Onstname
VLEIGH PL.
Atddismissed
No
9626
Atdid: 9626 • Atd Number: ATD-4-4330 • Bblid: 822539
Atdid
9626
Atd Number
ATD-4-4330
Bblid
822539
Inspectionid
333795
Inspect Date
2021-07-09T00:00:00.000
Atdissuedate
2022-03-15T18:45:43.000
Cb
12
House Num
196-15
Onstname
89TH AVE.
Atddismissed
No
12348
Atdid: 12348 • Atd Number: ATD-4-5214 • Bblid: 603156
Atdid
12348
Atd Number
ATD-4-5214
Bblid
603156
Inspectionid
357473
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T11:46:27.000
Cb
2
House Num
55-11
Onstname
QUEENS BLVD.
Atddismissed
No
10273
Atdid: 10273 • Atd Number: ATD-4-4652 • Bblid: 747812
Atdid
10273
Atd Number
ATD-4-4652
Bblid
747812
Inspectionid
337601
Inspect Date
2022-06-11T00:00:00.000
Atdissuedate
2022-06-13T10:12:42.000
Cb
8
House Num
73-54
Onstname
198TH ST.
Atddismissed
No
16687
Atdid: 16687 • Atd Number: ATD-3-6542 • Bblid: 555791
Atdid
16687
Atd Number
ATD-3-6542
Bblid
555791
Inspectionid
388634
Inspect Date
2024-12-17T00:00:00.000
Atdissuedate
2025-01-09T10:58:59.000
Cb
18
House Num
2438
Onstname
E. 65TH ST.
Atddismissed
No
17709
Atdid: 17709 • Atd Number: ATD-4-6961 • Bblid: 696192
Atdid
17709
Atd Number
ATD-4-6961
Bblid
696192
Inspectionid
398178
Inspect Date
2025-05-21T00:00:00.000
Atdissuedate
2025-05-22T10:10:50.000
Cb
7
House Num
29-28
Onstname
160TH ST.
Atddismissed
No
13617
Atdid: 13617 • Atd Number: ATD-4-5616 • Bblid: 897047
Atdid
13617
Atd Number
ATD-4-5616
Bblid
897047
Inspectionid
365703
Inspect Date
2023-10-05T00:00:00.000
Atdissuedate
2023-10-23T13:55:50.000
Cb
13
House Num
255-51
Onstname
148TH DR.
Atddismissed
No