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
8656
Atdid: 8656 • Atd Number: ATD-4-3883 • Bblid: 858096
Atdid
8656
Atd Number
ATD-4-3883
Bblid
858096
Inspectionid
330801
Inspect Date
2019-06-21T00:00:00.000
Atdissuedate
2021-12-16T09:54:28.000
Cb
10
House Num
131-46
Onstname
135TH ST.
Atddismissed
No
11350
Atdid: 11350 • Atd Number: ATD-3-4624 • Bblid: 282831
Atdid
11350
Atd Number
ATD-3-4624
Bblid
282831
Inspectionid
347727
Inspect Date
2022-11-02T00:00:00.000
Atdissuedate
2022-11-07T11:42:02.000
Cb
6
House Num
484
Onstname
7TH ST.
Atddismissed
No
9889
Atdid: 9889 • Atd Number: ATD-4-4495 • Bblid: 726218
Atdid
9889
Atd Number
ATD-4-4495
Bblid
726218
Inspectionid
335030
Inspect Date
2012-03-27T00:00:00.000
Atdissuedate
2022-04-15T13:30:35.000
Cb
11
House Num
32-23
Onstname
207TH ST.
Atddismissed
No
10311
Atdid: 10311 • Atd Number: ATD-3-3854 • Bblid: 317133
Atdid
10311
Atd Number
ATD-3-3854
Bblid
317133
Inspectionid
337819
Inspect Date
2022-06-17T00:00:00.000
Atdissuedate
2022-06-17T13:19:54.000
Cb
3
House Num
270A
Onstname
MONROE ST.
Atddismissed
No
9229
Atdid: 9229 • Atd Number: ATD-3-3368 • Bblid: 519216
Atdid
9229
Atd Number
ATD-3-3368
Bblid
519216
Inspectionid
332906
Inspect Date
2022-02-24T00:00:00.000
Atdissuedate
2022-03-01T13:28:51.000
Cb
18
House Num
1557
Onstname
E. 31ST ST.
Atddismissed
No
10058
Atdid: 10058 • Atd Number: ATD-4-4597 • Bblid: 787145
Atdid
10058
Atd Number
ATD-4-4597
Bblid
787145
Violationid
269825
Reinspectionid
32413
Inspect Date
2022-05-09T10:25:42.000
Atdissuedate
2022-05-09T10:25:42.000
Cb
10
House Num
107-60
Onstname
93 STREET
Atddismissed
No
16426
Atdid: 16426 • Atd Number: ATD-3-6431 • Bblid: 259323
Atdid
16426
Atd Number
ATD-3-6431
Bblid
259323
Inspectionid
385325
Inspect Date
2024-10-17T00:00:00.000
Atdissuedate
2024-11-22T11:58:06.000
Cb
6
House Num
387
Onstname
DEGRAW ST.
Atddismissed
No
11582
Atdid: 11582 • Atd Number: ATD-4-4949 • Bblid: 792994
Atdid
11582
Atd Number
ATD-4-4949
Bblid
792994
Inspectionid
350094
Inspect Date
2022-12-01T00:00:00.000
Atdissuedate
2023-01-06T16:24:59.000
Cb
9
House Num
91-40
Onstname
120TH ST.
Atddismissed
No
12009
Atdid: 12009 • Atd Number: ATD-3-4908 • Bblid: 361365
Atdid
12009
Atd Number
ATD-3-4908
Bblid
361365
Inspectionid
354731
Inspect Date
2023-04-11T00:00:00.000
Atdissuedate
2023-04-11T13:11:24.000
Cb
4
House Num
253
Onstname
COVERT ST.
Atddismissed
No
1576
Atdid: 1576 • Atd Number: ATD-3-719 • Bblid: 282077
Atdid
1576
Atd Number
ATD-3-719
Bblid
282077
Violationid
47019
Atdissuedate
2020-02-14T00:00:00.000
Cb
6
House Num
210
Onstname
GARFIELD PLACE
Atddismissed
Yes
Atddismissedon
2022-09-12T13:27:02.000
9733
Atdid: 9733 • Atd Number: ATD-5-651 • Bblid: 923229
Atdid
9733
Atd Number
ATD-5-651
Bblid
923229
Inspectionid
334176
Inspect Date
2022-03-25T00:00:00.000
Atdissuedate
2022-03-25T13:00:42.000
Cb
1
House Num
182
Onstname
BEECHWOOD AVE.
Atddismissed
No
11018
Atdid: 11018 • Atd Number: ATD-3-4370 • Bblid: 254205
Atdid
11018
Atd Number
ATD-3-4370
Bblid
254205
Inspectionid
344577
Inspect Date
2022-08-31T00:00:00.000
Atdissuedate
2022-09-26T13:39:02.000
Cb
6
House Num
247
Onstname
CLINTON ST.
Atddismissed
No
13891
Atdid: 13891 • Atd Number: ATD-4-5760 • Bblid: 770837
Atdid
13891
Atd Number
ATD-4-5760
Bblid
770837
Inspectionid
371044
Inspect Date
2024-01-27T00:00:00.000
Atdissuedate
2024-01-29T12:13:46.000
Cb
13
House Num
84-60
Onstname
251ST ST.
Atddismissed
Yes
Atddismissedon
2024-01-29T12:19:07.000
9255
Atdid: 9255 • Atd Number: ATD-3-3382 • Bblid: 471440
Atdid
9255
Atd Number
ATD-3-3382
Bblid
471440
Inspectionid
332961
Inspect Date
2021-05-07T00:00:00.000
Atdissuedate
2022-03-01T17:34:39.000
Cb
12
House Num
1318
Onstname
E. 5TH ST.
Atddismissed
No
17625
Atdid: 17625 • Atd Number: ATD-4-6896 • Bblid: 645748
Atdid
17625
Atd Number
ATD-4-6896
Bblid
645748
Inspectionid
397156
Inspect Date
2025-05-05T00:00:00.000
Atdissuedate
2025-05-15T15:18:29.000
Cb
4
House Num
84-08
Onstname
53RD AVE.
Atddismissed
No
10317
Atdid: 10317 • Atd Number: ATD-4-4673 • Bblid: 834934
Atdid
10317
Atd Number
ATD-4-4673
Bblid
834934
Inspectionid
337921
Inspect Date
2022-06-17T00:00:00.000
Atdissuedate
2022-06-21T14:39:56.000
Cb
12
House Num
194-23
Onstname
112TH AVE.
Atddismissed
No
1489
Atdid: 1489 • Atd Number: ATD-3-632 • Bblid: 328315
Atdid
1489
Atd Number
ATD-3-632
Bblid
328315
Violationid
56097
Atdissuedate
2020-08-12T00:00:00.000
Cb
2
House Num
11 A
Onstname
SOUTH ELLIOTT PLACE
Atddismissed
No
12902
Atdid: 12902 • Atd Number: ATD-4-5456 • Bblid: 760365
Atdid
12902
Atd Number
ATD-4-5456
Bblid
760365
Inspectionid
360304
Inspect Date
2023-05-10T00:00:00.000
Atdissuedate
2023-07-20T09:07:22.000
Cb
13
House Num
232-15
Onstname
HILLSIDE AVE.
Atddismissed
No
14704
Atdid: 14704 • Atd Number: ATD-4-6128 • Bblid: 607355
Atdid
14704
Atd Number
ATD-4-6128
Bblid
607355
Inspectionid
379120
Inspect Date
2024-06-06T00:00:00.000
Atdissuedate
2024-07-08T14:43:07.000
Cb
3
House Num
32-24
Onstname
85TH ST.
Atddismissed
No
16773
Atdid: 16773 • Atd Number: ATD-3-6578 • Bblid: 302509
Atdid
16773
Atd Number
ATD-3-6578
Bblid
302509
Inspectionid
389288
Inspect Date
2024-09-10T00:00:00.000
Atdissuedate
2025-02-03T12:44:26.000
Cb
3
House Num
604
Onstname
DECATUR ST.
Atddismissed
No
9932
Atdid: 9932 • Atd Number: ATD-4-4511 • Bblid: 654385
Atdid
9932
Atd Number
ATD-4-4511
Bblid
654385
Inspectionid
335333
Inspect Date
2022-04-13T00:00:00.000
Atdissuedate
2022-04-21T12:01:23.000
Cb
6
House Num
65-33
Onstname
CROMWELL CRES
Atddismissed
No
16538
Atdid: 16538 • Atd Number: ATD-3-6476 • Bblid: 282524
Atdid
16538
Atd Number
ATD-3-6476
Bblid
282524
Inspectionid
386576
Inspect Date
2024-12-17T00:00:00.000
Atdissuedate
2024-12-18T11:26:27.000
Cb
6
House Num
609
Onstname
2ND ST.
Atddismissed
No
10854
Atdid: 10854 • Atd Number: ATD-3-4225 • Bblid: 311055
Atdid
10854
Atd Number
ATD-3-4225
Bblid
311055
Inspectionid
343402
Inspect Date
2022-09-10T00:00:00.000
Atdissuedate
2022-09-12T10:27:50.000
Cb
3
House Num
190A
Onstname
DECATUR ST.
Atddismissed
No
11913
Atdid: 11913 • Atd Number: ATD-3-4865 • Bblid: 310915
Atdid
11913
Atd Number
ATD-3-4865
Bblid
310915
Inspectionid
354118
Inspect Date
2023-03-07T00:00:00.000
Atdissuedate
2023-03-28T11:48:32.000
Cb
3
House Num
568
Onstname
MACDONOUGH ST.
Atddismissed
No
18383
Atdid: 18383 • Atd Number: ATD-4-7275 • Bblid: 593335
Atdid
18383
Atd Number
ATD-4-7275
Bblid
593335
Inspectionid
404541
Inspect Date
2025-08-20T00:00:00.000
Atdissuedate
2025-08-20T12:33:01.000
Cb
1
House Num
22-46
Onstname
78TH ST.
Atddismissed
No
16497
Atdid: 16497 • Atd Number: ATD-3-6446 • Bblid: 281554
Atdid
16497
Atd Number
ATD-3-6446
Bblid
281554
Inspectionid
385848
Inspect Date
2024-10-23T00:00:00.000
Atdissuedate
2024-12-09T13:07:50.000
Cb
7
House Num
24
Onstname
JACKSON PL.
Atddismissed
No
9605
Atdid: 9605 • Atd Number: ATD-4-4312 • Bblid: 724254
Atdid
9605
Atd Number
ATD-4-4312
Bblid
724254
Inspectionid
333745
Inspect Date
2020-12-04T00:00:00.000
Atdissuedate
2022-03-14T19:03:20.000
Cb
7
House Num
16-20
Onstname
215TH ST.
Atddismissed
No
12914
Atdid: 12914 • Atd Number: ATD-3-5201 • Bblid: 432109
Atdid
12914
Atd Number
ATD-3-5201
Bblid
432109
Inspectionid
360332
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T10:06:27.000
Cb
12
House Num
1450
Onstname
44TH ST.
Atddismissed
No
13478
Atdid: 13478 • Atd Number: ATD-5-830 • Bblid: 934255
Atdid
13478
Atd Number
ATD-5-830
Bblid
934255
Inspectionid
364298
Inspect Date
2023-09-21T00:00:00.000
Atdissuedate
2023-09-26T09:42:54.000
Cb
1
House Num
72
Onstname
DONGAN AVE.
Atddismissed
No
14907
Atdid: 14907 • Atd Number: ATD-4-6219 • Bblid: 586631
Atdid
14907
Atd Number
ATD-4-6219
Bblid
586631
Inspectionid
380603
Inspect Date
2024-08-12T00:00:00.000
Atdissuedate
2024-08-15T11:48:23.000
Cb
1
House Num
23-52
Onstname
37TH ST.
Atddismissed
No
10836
Atdid: 10836 • Atd Number: ATD-3-4207 • Bblid: 323382
Atdid
10836
Atd Number
ATD-3-4207
Bblid
323382
Inspectionid
343345
Inspect Date
2022-08-30T00:00:00.000
Atdissuedate
2022-09-12T10:09:22.000
Cb
3
House Num
139
Onstname
CLIFTON PL.
Atddismissed
No
15027
Atdid: 15027 • Atd Number: ATD-3-6263 • Bblid: 535044
Atdid
15027
Atd Number
ATD-3-6263
Bblid
535044
Inspectionid
381653
Inspect Date
2024-08-16T00:00:00.000
Atdissuedate
2024-09-09T16:11:31.000
Cb
18
House Num
1151
Onstname
E. 84TH ST.
Atddismissed
No
9918
Atdid: 9918 • Atd Number: ATD-4-4506 • Bblid: 654472
Atdid
9918
Atd Number
ATD-4-4506
Bblid
654472
Inspectionid
335263
Inspect Date
2022-04-15T00:00:00.000
Atdissuedate
2022-04-20T14:00:33.000
Cb
6
House Num
63-28
Onstname
ELLWELL CRES
Atddismissed
No
10696
Atdid: 10696 • Atd Number: ATD-4-4799 • Bblid: 876770
Atdid
10696
Atd Number
ATD-4-4799
Bblid
876770
Inspectionid
342093
Inspect Date
2022-06-25T00:00:00.000
Atdissuedate
2022-08-26T17:11:16.000
Cb
12
House Num
118-24
Onstname
202ND ST.
Atddismissed
No
13734
Atdid: 13734 • Atd Number: ATD-3-5664 • Bblid: 442489
Atdid
13734
Atd Number
ATD-3-5664
Bblid
442489
Inspectionid
368897
Inspect Date
2023-11-25T00:00:00.000
Atdissuedate
2023-12-05T11:46:15.000
Cb
10
House Num
329
Onstname
BAY RIDGE AVE.
Atddismissed
No
12490
Atdid: 12490 • Atd Number: ATD-4-5316 • Bblid: 781706
Atdid
12490
Atd Number
ATD-4-5316
Bblid
781706
Inspectionid
358034
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T16:02:13.000
Cb
9
House Num
87-01
Onstname
ATLANTIC AVE.
Atddismissed
No
8966
Atdid: 8966 • Atd Number: ATD-4-4065 • Bblid: 672224
Atdid
8966
Atd Number
ATD-4-4065
Bblid
672224
Inspectionid
332267
Inspect Date
2021-01-14T00:00:00.000
Atdissuedate
2022-02-04T15:18:03.000
Cb
5
House Num
70-33
Onstname
72ND PL.
Atddismissed
No
18561
Atdid: 18561 • Atd Number: ATD-3-7308 • Bblid: 445389
Atdid
18561
Atd Number
ATD-3-7308
Bblid
445389
Inspectionid
405599
Inspect Date
2024-10-17T00:00:00.000
Atdissuedate
2025-09-09T14:46:46.000
Cb
10
House Num
7203
Onstname
10TH AVE.
Atddismissed
No
13149
Atdid: 13149 • Atd Number: ATD-4-5492 • Bblid: 774728
Atdid
13149
Atd Number
ATD-4-5492
Bblid
774728
Inspectionid
361580
Inspect Date
2023-07-28T00:00:00.000
Atdissuedate
2023-08-07T09:28:01.000
Cb
13
House Num
83-03
Onstname
265TH ST.
Atddismissed
No
10569
Atdid: 10569 • Atd Number: ATD-4-4754 • Bblid: 770834
Atdid
10569
Atd Number
ATD-4-4754
Bblid
770834
Inspectionid
340570
Inspect Date
2022-07-19T00:00:00.000
Atdissuedate
2022-07-29T10:19:14.000
Cb
13
House Num
85-43
Onstname
250TH ST.
Atddismissed
No
16575
Atdid: 16575 • Atd Number: ATD-3-6505 • Bblid: 297878
Atdid
16575
Atd Number
ATD-3-6505
Bblid
297878
Inspectionid
387003
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2024-12-20T10:45:47.000
Cb
8
House Num
1273
Onstname
LINCOLN PL.
Atddismissed
No
18466
Atdid: 18466 • Atd Number: ATD-4-7317 • Bblid: 854232
Atdid
18466
Atd Number
ATD-4-7317
Bblid
854232
Inspectionid
405128
Inspect Date
2025-08-01T00:00:00.000
Atdissuedate
2025-09-02T18:02:38.000
Cb
10
House Num
116-45
Onstname
127TH ST.
Atddismissed
No
14380
Atdid: 14380 • Atd Number: ATD-3-5935 • Bblid: 353224
Atdid
14380
Atd Number
ATD-3-5935
Bblid
353224
Inspectionid
376382
Inspect Date
2024-04-23T00:00:00.000
Atdissuedate
2024-04-29T14:22:26.000
Cb
4
House Num
244
Onstname
SUYDAM ST.
Atddismissed
Yes
Atddismissedon
2024-11-06T10:34:57.000
12083
Atdid: 12083 • Atd Number: ATD-4-5150 • Bblid: 835649
Atdid
12083
Atd Number
ATD-4-5150
Bblid
835649
Inspectionid
356127
Inspect Date
2023-04-05T00:00:00.000
Atdissuedate
2023-04-24T08:59:36.000
Cb
12
House Num
112-27
Onstname
201ST ST.
Atddismissed
No
8347
Atdid: 8347 • Atd Number: ATD-3-3025 • Bblid: 324128
Atdid
8347
Atd Number
ATD-3-3025
Bblid
324128
Inspectionid
325253
Inspect Date
2021-07-29T00:00:00.000
Atdissuedate
2021-07-29T00:00:00.000
Cb
2
House Num
126
Onstname
SAINT JAMES PL.
Atddismissed
Yes
Atddismissedon
2022-05-24T10:01:20.000
9413
Atdid: 9413 • Atd Number: ATD-4-4214 • Bblid: 683623
Atdid
9413
Atd Number
ATD-4-4214
Bblid
683623
Inspectionid
333184
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-03-04T10:30:50.000
Cb
7
House Num
18-04
Onstname
PARSONS BLVD.
Atddismissed
No
9259
Atdid: 9259 • Atd Number: ATD-2-869 • Bblid: 219960
Atdid
9259
Atd Number
ATD-2-869
Bblid
219960
Inspectionid
332965
Inspect Date
2021-04-28T00:00:00.000
Atdissuedate
2022-03-01T17:37:48.000
Cb
12
House Num
958
Onstname
E. 224TH ST.
Atddismissed
No
8813
Atdid: 8813 • Atd Number: ATD-3-3231 • Bblid: 270277
Atdid
8813
Atd Number
ATD-3-3231
Bblid
270277
Inspectionid
331538
Inspect Date
2021-11-12T00:00:00.000
Atdissuedate
2022-01-07T14:56:45.000
Cb
7
House Num
422
Onstname
57TH ST.
Atddismissed
No
11634
Atdid: 11634 • Atd Number: ATD-1-284 • Bblid: 116755
Atdid
11634
Atd Number
ATD-1-284
Bblid
116755
Inspectionid
350937
Inspect Date
2022-11-05T00:00:00.000
Atdissuedate
2023-02-03T11:44:02.000
Cb
10
House Num
32
Onstname
W. 119TH ST.
Atddismissed
No
10174
Atdid: 10174 • Atd Number: ATD-4-4605 • Bblid: 734964
Atdid
10174
Atd Number
ATD-4-4605
Bblid
734964
Inspectionid
337048
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-27T08:17:29.000
Cb
8
House Num
135-08
Onstname
72ND AVE.
Atddismissed
No