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
9335
Atdid: 9335 • Atd Number: ATD-4-4201 • Bblid: 722398
Atdid
9335
Atd Number
ATD-4-4201
Bblid
722398
Inspectionid
333058
Inspect Date
2019-07-27T00:00:00.000
Atdissuedate
2022-03-02T15:24:56.000
Cb
7
House Num
15-07
Onstname
209TH ST.
Atddismissed
No
17295
Atdid: 17295 • Atd Number: ATD-2-1381 • Bblid: 244095
Atdid
17295
Atd Number
ATD-2-1381
Bblid
244095
Inspectionid
394040
Inspect Date
2025-04-10T00:00:00.000
Atdissuedate
2025-04-10T13:20:53.000
Cb
8
House Num
3010
Onstname
ARLINGTON AVE.
Atddismissed
No
10197
Atdid: 10197 • Atd Number: ATD-3-3789 • Bblid: 384810
Atdid
10197
Atd Number
ATD-3-3789
Bblid
384810
Inspectionid
337149
Inspect Date
2022-06-01T00:00:00.000
Atdissuedate
2022-06-01T15:06:02.000
Cb
5
House Num
695
Onstname
AUTUMN AVE.
Atddismissed
No
11419
Atdid: 11419 • Atd Number: ATD-1-251 • Bblid: 119367
Atdid
11419
Atd Number
ATD-1-251
Bblid
119367
Inspectionid
348389
Inspect Date
2022-11-03T00:00:00.000
Atdissuedate
2022-11-18T13:45:07.000
Cb
11
House Num
320
Onstname
E. 120TH ST.
Atddismissed
Yes
Atddismissedon
2023-02-24T11:38:08.000
11956
Atdid: 11956 • Atd Number: ATD-2-1007 • Bblid: 226997
Atdid
11956
Atd Number
ATD-2-1007
Bblid
226997
Inspectionid
354296
Inspect Date
2023-03-28T00:00:00.000
Atdissuedate
2023-03-31T09:32:28.000
Cb
12
House Num
4362
Onstname
ELY AVE.
Atddismissed
No
8484
Atdid: 8484 • Atd Number: ATD-4-3823 • Bblid: 780452
Atdid
8484
Atd Number
ATD-4-3823
Bblid
780452
Inspectionid
329556
Inspect Date
2021-10-12T00:00:00.000
Atdissuedate
2021-11-13T18:58:27.000
Cb
9
House Num
89-36
Onstname
85TH ST.
Atddismissed
No
14879
Atdid: 14879 • Atd Number: ATD-3-6181 • Bblid: 428989
Atdid
14879
Atd Number
ATD-3-6181
Bblid
428989
Inspectionid
380363
Inspect Date
2024-08-06T00:00:00.000
Atdissuedate
2024-08-07T09:31:47.000
Cb
11
House Num
6619
Onstname
OVINGTON CT.
Atddismissed
No
13502
Atdid: 13502 • Atd Number: ATD-3-5564 • Bblid: 444714
Atdid
13502
Atd Number
ATD-3-5564
Bblid
444714
Inspectionid
364560
Inspect Date
2023-07-13T00:00:00.000
Atdissuedate
2023-09-28T12:09:08.000
Cb
10
House Num
112
Onstname
72ND ST.
Atddismissed
No
10862
Atdid: 10862 • Atd Number: ATD-3-4233 • Bblid: 306254
Atdid
10862
Atd Number
ATD-3-4233
Bblid
306254
Inspectionid
343477
Inspect Date
2022-08-29T00:00:00.000
Atdissuedate
2022-09-12T11:37:53.000
Cb
3
House Num
433
Onstname
PULASKI ST.
Atddismissed
No
13535
Atdid: 13535 • Atd Number: ATD-4-5574 • Bblid: 850870
Atdid
13535
Atd Number
ATD-4-5574
Bblid
850870
Inspectionid
364847
Inspect Date
2023-10-03T00:00:00.000
Atdissuedate
2023-10-03T15:40:28.000
Cb
10
House Num
109-50
Onstname
113TH ST.
Atddismissed
No
3498
Atdid: 3498 • Atd Number: ATD-3-2380 • Bblid: 271432
Atdid
3498
Atd Number
ATD-3-2380
Bblid
271432
Violationid
256782
Atdissuedate
2020-03-06T00:00:00.000
Cb
7
House Num
402
Onstname
17 STREET
Atddismissed
Yes
Atddismissedon
2023-07-25T08:24:54.000
9046
Atdid: 9046 • Atd Number: ATD-4-4107 • Bblid: 675953
Atdid
9046
Atd Number
ATD-4-4107
Bblid
675953
Inspectionid
332457
Inspect Date
2022-02-15T00:00:00.000
Atdissuedate
2022-02-15T10:27:47.000
Cb
5
House Num
77-25
Onstname
79TH ST.
Atddismissed
No
10246
Atdid: 10246 • Atd Number: ATD-4-4635 • Bblid: 786098
Atdid
10246
Atd Number
ATD-4-4635
Bblid
786098
Inspectionid
337448
Inspect Date
2022-06-07T00:00:00.000
Atdissuedate
2022-06-08T11:05:06.000
Cb
10
House Num
80-07
Onstname
SUTTER AVE.
Atddismissed
No
14390
Atdid: 14390 • Atd Number: ATD-3-5940 • Bblid: 266919
Atdid
14390
Atd Number
ATD-3-5940
Bblid
266919
Inspectionid
376609
Inspect Date
2024-04-25T00:00:00.000
Atdissuedate
2024-05-03T11:55:22.000
Cb
7
House Num
542
Onstname
48TH ST.
Atddismissed
No
16780
Atdid: 16780 • Atd Number: ATD-4-6609 • Bblid: 737406
Atdid
16780
Atd Number
ATD-4-6609
Bblid
737406
Inspectionid
389360
Inspect Date
2025-01-15T00:00:00.000
Atdissuedate
2025-02-05T10:46:55.000
Cb
8
House Num
147-07A
Onstname
77TH RD.
Atddismissed
No
14574
Atdid: 14574 • Atd Number: ATD-3-6028 • Bblid: 460468
Atdid
14574
Atd Number
ATD-3-6028
Bblid
460468
Inspectionid
378335
Inspect Date
2024-06-08T00:00:00.000
Atdissuedate
2024-06-10T15:40:14.000
Cb
10
House Num
1337
Onstname
79TH ST.
Atddismissed
No
9597
Atdid: 9597 • Atd Number: ATD-4-4304 • Bblid: 773704
Atdid
9597
Atd Number
ATD-4-4304
Bblid
773704
Inspectionid
333737
Inspect Date
2021-12-08T00:00:00.000
Atdissuedate
2022-03-14T16:06:20.000
Cb
13
House Num
269-08
Onstname
80TH AVE.
Atddismissed
No
14582
Atdid: 14582 • Atd Number: ATD-3-6036 • Bblid: 445819
Atdid
14582
Atd Number
ATD-3-6036
Bblid
445819
Inspectionid
378364
Inspect Date
2024-06-05T00:00:00.000
Atdissuedate
2024-06-11T15:31:04.000
Cb
10
House Num
647
Onstname
BAY RIDGE PKWY.
Atddismissed
No
9225
Atdid: 9225 • Atd Number: ATD-4-4196 • Bblid: 744424
Atdid
9225
Atd Number
ATD-4-4196
Bblid
744424
Inspectionid
332883
Inspect Date
2022-02-23T00:00:00.000
Atdissuedate
2022-03-01T09:54:03.000
Cb
8
House Num
164-32
Onstname
73RD AVE.
Atddismissed
No
12879
Atdid: 12879 • Atd Number: ATD-2-1195 • Bblid: 202413
Atdid
12879
Atd Number
ATD-2-1195
Bblid
202413
Inspectionid
360154
Inspect Date
2023-07-12T00:00:00.000
Atdissuedate
2023-07-17T13:04:43.000
Cb
11
House Num
2020
Onstname
MATTHEWS AVE.
Atddismissed
No
13903
Atdid: 13903 • Atd Number: ATD-3-5714 • Bblid: 477780
Atdid
13903
Atd Number
ATD-3-5714
Bblid
477780
Inspectionid
371094
Inspect Date
2024-01-10T00:00:00.000
Atdissuedate
2024-01-29T14:31:22.000
Cb
15
House Num
1786
Onstname
E. 2ND ST.
Atddismissed
No
8797
Atdid: 8797 • Atd Number: ATD-4-3973 • Bblid: 644150
Atdid
8797
Atd Number
ATD-4-3973
Bblid
644150
Inspectionid
331326
Inspect Date
2021-12-07T00:00:00.000
Atdissuedate
2021-12-30T11:37:37.000
Cb
5
House Num
60-37
Onstname
72ND ST.
Atddismissed
No
17911
Atdid: 17911 • Atd Number: ATD-2-1418 • Bblid: 233716
Atdid
17911
Atd Number
ATD-2-1418
Bblid
233716
Inspectionid
400562
Inspect Date
2025-05-20T00:00:00.000
Atdissuedate
2025-06-17T10:48:48.000
Cb
10
House Num
3220
Onstname
WATT AVE.
Atddismissed
No
18280
Atdid: 18280 • Atd Number: ATD-4-7220 • Bblid: 857472
Atdid
18280
Atd Number
ATD-4-7220
Bblid
857472
Inspectionid
403739
Inspect Date
2025-08-06T00:00:00.000
Atdissuedate
2025-08-07T09:56:05.000
Cb
10
House Num
131-22
Onstname
SUTTER AVE.
Atddismissed
No
16246
Atdid: 16246 • Atd Number: ATD-4-6386 • Bblid: 871803
Atdid
16246
Atd Number
ATD-4-6386
Bblid
871803
Violationid
298141
Reinspectionid
37678
Inspect Date
2024-10-17T09:35:52.000
Atdissuedate
2024-10-17T09:35:52.000
Cb
12
House Num
170-34
Onstname
118 ROAD
Atddismissed
No
17859
Atdid: 17859 • Atd Number: ATD-3-7041 • Bblid: 496654
Atdid
17859
Atd Number
ATD-3-7041
Bblid
496654
Inspectionid
399979
Inspect Date
2025-06-07T00:00:00.000
Atdissuedate
2025-06-11T15:39:23.000
Cb
15
House Num
2124
Onstname
E. 1ST ST.
Atddismissed
No
10782
Atdid: 10782 • Atd Number: ATD-3-4159 • Bblid: 262676
Atdid
10782
Atd Number
ATD-3-4159
Bblid
262676
Inspectionid
342882
Inspect Date
2022-08-05T00:00:00.000
Atdissuedate
2022-09-07T14:39:48.000
Cb
7
House Num
192
Onstname
18TH ST.
Atddismissed
No
11738
Atdid: 11738 • Atd Number: ATD-4-5029 • Bblid: 752425
Atdid
11738
Atd Number
ATD-4-5029
Bblid
752425
Inspectionid
352311
Inspect Date
2023-02-23T00:00:00.000
Atdissuedate
2023-03-03T10:04:00.000
Cb
11
House Num
50-41
Onstname
206TH ST.
Atddismissed
No
18142
Atdid: 18142 • Atd Number: ATD-3-7152 • Bblid: 521030
Atdid
18142
Atd Number
ATD-3-7152
Bblid
521030
Inspectionid
402800
Inspect Date
2025-07-02T00:00:00.000
Atdissuedate
2025-07-21T11:26:50.000
Cb
17
House Num
985
Onstname
E. 39TH ST.
Atddismissed
No
15050
Atdid: 15050 • Atd Number: ATD-3-6278 • Bblid: 251563
Atdid
15050
Atd Number
ATD-3-6278
Bblid
251563
Inspectionid
381890
Inspect Date
2024-09-10T00:00:00.000
Atdissuedate
2024-09-16T13:17:23.000
Cb
2
House Num
196
Onstname
DEAN ST.
Atddismissed
No
18117
Atdid: 18117 • Atd Number: ATD-4-7167 • Bblid: 833605
Atdid
18117
Atd Number
ATD-4-7167
Bblid
833605
Inspectionid
402612
Inspect Date
2025-07-15T00:00:00.000
Atdissuedate
2025-07-17T14:14:58.000
Cb
12
House Num
104-16
Onstname
204TH ST.
Atddismissed
No
11053
Atdid: 11053 • Atd Number: ATD-4-4827 • Bblid: 887449
Atdid
11053
Atd Number
ATD-4-4827
Bblid
887449
Inspectionid
344789
Inspect Date
2022-09-26T00:00:00.000
Atdissuedate
2022-09-30T08:50:54.000
Cb
13
House Num
135-04
Onstname
228TH ST.
Atddismissed
No
16629
Atdid: 16629 • Atd Number: ATD-4-6531 • Bblid: 608365
Atdid
16629
Atd Number
ATD-4-6531
Bblid
608365
Inspectionid
388356
Inspect Date
2025-01-02T00:00:00.000
Atdissuedate
2025-01-02T15:31:33.000
Cb
3
House Num
34-23
Onstname
86TH ST.
Atddismissed
Yes
Atddismissedon
2025-08-05T13:28:16.000
16499
Atdid: 16499 • Atd Number: ATD-3-6448 • Bblid: 266479
Atdid
16499
Atd Number
ATD-3-6448
Bblid
266479
Inspectionid
385850
Inspect Date
2024-10-23T00:00:00.000
Atdissuedate
2024-12-09T13:10:25.000
Cb
7
House Num
518
Onstname
47TH ST.
Atddismissed
No
10238
Atdid: 10238 • Atd Number: ATD-3-3817 • Bblid: 332748
Atdid
10238
Atd Number
ATD-3-3817
Bblid
332748
Inspectionid
337371
Inspect Date
2022-06-03T00:00:00.000
Atdissuedate
2022-06-06T13:09:52.000
Cb
1
House Num
76
Onstname
PENN ST.
Atddismissed
No
17898
Atdid: 17898 • Atd Number: ATD-4-7077 • Bblid: 701042
Atdid
17898
Atd Number
ATD-4-7077
Bblid
701042
Inspectionid
400442
Inspect Date
2025-06-03T00:00:00.000
Atdissuedate
2025-06-16T11:40:31.000
Cb
7
House Num
144-31
Onstname
38TH AVE.
Atddismissed
No
18119
Atdid: 18119 • Atd Number: ATD-3-7137 • Bblid: 560971
Atdid
18119
Atd Number
ATD-3-7137
Bblid
560971
Inspectionid
402674
Inspect Date
2025-07-16T00:00:00.000
Atdissuedate
2025-07-18T12:03:34.000
Cb
15
House Num
4728
Onstname
BEDFORD AVE.
Atddismissed
No
10485
Atdid: 10485 • Atd Number: ATD-3-3954 • Bblid: 265580
Atdid
10485
Atd Number
ATD-3-3954
Bblid
265580
Inspectionid
339807
Inspect Date
2022-06-15T00:00:00.000
Atdissuedate
2022-07-15T09:37:48.000
Cb
7
House Num
315
Onstname
46TH ST.
Atddismissed
No
12570
Atdid: 12570 • Atd Number: ATD-2-1147 • Bblid: 142899
Atdid
12570
Atd Number
ATD-2-1147
Bblid
142899
Inspectionid
358553
Inspect Date
2023-06-14T00:00:00.000
Atdissuedate
2023-06-14T16:22:22.000
Cb
4
House Num
924
Onstname
TELLER AVE.
Atddismissed
No
10019
Atdid: 10019 • Atd Number: ATD-4-4563 • Bblid: 654510
Atdid
10019
Atd Number
ATD-4-4563
Bblid
654510
Inspectionid
335986
Inspect Date
2022-04-21T00:00:00.000
Atdissuedate
2022-05-03T10:49:35.000
Cb
6
House Num
62-02
Onstname
ELLWELL CRES
Atddismissed
No
16374
Atdid: 16374 • Atd Number: ATD-3-6413 • Bblid: 494119
Atdid
16374
Atd Number
ATD-3-6413
Bblid
494119
Inspectionid
385053
Inspect Date
2024-11-15T00:00:00.000
Atdissuedate
2024-11-14T13:37:47.000
Cb
15
House Num
705
Onstname
AVENUE T.
Atddismissed
No
9606
Atdid: 9606 • Atd Number: ATD-4-4313 • Bblid: 724794
Atdid
9606
Atd Number
ATD-4-4313
Bblid
724794
Inspectionid
333746
Inspect Date
2021-07-21T00:00:00.000
Atdissuedate
2022-03-14T19:04:46.000
Cb
11
House Num
28-45
Onstname
CLEARVIEW EXPY.
Atddismissed
No
55
Atdid: 55 • Atd Number: ATD-1-55 • Bblid: 130562
Atdid
55
Atd Number
ATD-1-55
Bblid
130562
Violationid
240256
Atdissuedate
2019-10-05T00:00:00.000
Cb
10
House Num
246
Onstname
WEST 139 STREET
Atddismissed
Yes
Atddismissedon
2022-07-15T10:18:09.000
11696
Atdid: 11696 • Atd Number: ATD-4-5007 • Bblid: 858251
Atdid
11696
Atd Number
ATD-4-5007
Bblid
858251
Inspectionid
351883
Inspect Date
2023-02-09T00:00:00.000
Atdissuedate
2023-02-23T11:36:43.000
Cb
10
House Num
133-25
Onstname
131ST ST.
Atddismissed
No
8748
Atdid: 8748 • Atd Number: ATD-4-3944 • Bblid: 772533
Atdid
8748
Atd Number
ATD-4-3944
Bblid
772533
Inspectionid
331102
Inspect Date
2021-12-15T00:00:00.000
Atdissuedate
2021-12-28T13:24:39.000
Cb
13
House Num
78-34
Onstname
268TH ST.
Atddismissed
No
8521
Atdid: 8521 • Atd Number: ATD-4-3833 • Bblid: 846741
Atdid
8521
Atd Number
ATD-4-3833
Bblid
846741
Inspectionid
330005
Inspect Date
2021-11-10T00:00:00.000
Atdissuedate
2021-11-24T12:00:05.000
Cb
10
House Num
92-30
Onstname
SILVER RD.
Atddismissed
No
14910
Atdid: 14910 • Atd Number: ATD-4-6222 • Bblid: 729329
Atdid
14910
Atd Number
ATD-4-6222
Bblid
729329
Inspectionid
380634
Inspect Date
2024-08-09T00:00:00.000
Atdissuedate
2024-08-15T15:37:45.000
Cb
11
House Num
38-37
Onstname
213TH ST.
Atddismissed
No
13301
Atdid: 13301 • Atd Number: ATD-3-5454 • Bblid: 417216
Atdid
13301
Atd Number
ATD-3-5454
Bblid
417216
Inspectionid
362449
Inspect Date
2023-08-07T00:00:00.000
Atdissuedate
2023-08-22T13:45:57.000
Cb
12
House Num
86
Onstname
LOUISA ST.
Atddismissed
No
8923
Atdid: 8923 • Atd Number: ATD-2-859 • Bblid: 197965
Atdid
8923
Atd Number
ATD-2-859
Bblid
197965
Inspectionid
332150
Inspect Date
2019-05-07T00:00:00.000
Atdissuedate
2022-01-31T09:25:59.000
Cb
11
House Num
1715
Onstname
LURTING AVE.
Atddismissed
No
13046
Atdid: 13046 • Atd Number: ATD-3-5290 • Bblid: 422490
Atdid
13046
Atd Number
ATD-3-5290
Bblid
422490
Inspectionid
361040
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-07-28T15:20:47.000
Cb
12
House Num
1646
Onstname
45TH ST.
Atddismissed
No