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
8873
Atdid: 8873 • Atd Number: ATD-4-4016 • Bblid: 618575
Atdid
8873
Atd Number
ATD-4-4016
Bblid
618575
Inspectionid
331854
Inspect Date
2022-01-13T00:00:00.000
Atdissuedate
2022-01-24T12:46:49.000
Cb
3
House Num
37-50
Onstname
98TH ST.
Atddismissed
No
8999
Atdid: 8999 • Atd Number: ATD-4-4090 • Bblid: 638129
Atdid
8999
Atd Number
ATD-4-4090
Bblid
638129
Inspectionid
332331
Inspect Date
2022-02-09T00:00:00.000
Atdissuedate
2022-02-09T13:16:48.000
Cb
5
House Num
54-18
Onstname
NURGE AVE.
Atddismissed
No
9556
Atdid: 9556 • Atd Number: ATD-5-628 • Bblid: 1043621
Atdid
9556
Atd Number
ATD-5-628
Bblid
1043621
Inspectionid
333644
Inspect Date
2021-03-17T00:00:00.000
Atdissuedate
2022-03-10T17:46:24.000
Cb
3
House Num
823
Onstname
SHELDON AVE.
Atddismissed
No
10667
Atdid: 10667 • Atd Number: ATD-3-4065 • Bblid: 519682
Atdid
10667
Atd Number
ATD-3-4065
Bblid
519682
Inspectionid
341762
Inspect Date
2022-08-17T00:00:00.000
Atdissuedate
2022-08-22T08:48:34.000
Cb
18
House Num
1535
Onstname
E. 36TH ST.
Atddismissed
No
18508
Atdid: 18508 • Atd Number: ATD-3-7289 • Bblid: 489330
Atdid
18508
Atd Number
ATD-3-7289
Bblid
489330
Inspectionid
405336
Inspect Date
2025-09-06T00:00:00.000
Atdissuedate
2025-09-06T11:43:08.000
Cb
13
House Num
136
Onstname
BAY 49TH ST.
Atddismissed
No
13525
Atdid: 13525 • Atd Number: ATD-4-5564 • Bblid: 820886
Atdid
13525
Atd Number
ATD-4-5564
Bblid
820886
Inspectionid
364727
Inspect Date
2023-06-24T00:00:00.000
Atdissuedate
2023-10-02T14:24:14.000
Cb
12
House Num
115-02
Onstname
MEXICO ST.
Atddismissed
No
18287
Atdid: 18287 • Atd Number: ATD-4-7223 • Bblid: 854228
Atdid
18287
Atd Number
ATD-4-7223
Bblid
854228
Inspectionid
403928
Inspect Date
2025-07-31T00:00:00.000
Atdissuedate
2025-08-11T11:45:26.000
Cb
10
House Num
116-49
Onstname
127TH ST.
Atddismissed
No
14958
Atdid: 14958 • Atd Number: ATD-3-6228 • Bblid: 368873
Atdid
14958
Atd Number
ATD-3-6228
Bblid
368873
Inspectionid
381022
Inspect Date
2024-08-15T00:00:00.000
Atdissuedate
2024-08-26T09:46:37.000
Cb
5
House Num
361
Onstname
WYONA ST.
Atddismissed
No
9136
Atdid: 9136 • Atd Number: ATD-3-3327 • Bblid: 369181
Atdid
9136
Atd Number
ATD-3-3327
Bblid
369181
Inspectionid
332687
Inspect Date
2019-04-04T00:00:00.000
Atdissuedate
2022-02-23T09:53:23.000
Cb
5
House Num
310
Onstname
SNEDIKER AVE.
Atddismissed
No
10702
Atdid: 10702 • Atd Number: ATD-3-4085 • Bblid: 280249
Atdid
10702
Atd Number
ATD-3-4085
Bblid
280249
Inspectionid
342113
Inspect Date
2022-08-26T00:00:00.000
Atdissuedate
2022-08-29T09:08:55.000
Cb
6
House Num
303
Onstname
14TH ST.
Atddismissed
No
12689
Atdid: 12689 • Atd Number: ATD-5-725 • Bblid: 1025259
Atdid
12689
Atd Number
ATD-5-725
Bblid
1025259
Inspectionid
359093
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-29T14:25:39.000
Cb
3
Onstname
ARTHUR KILL ROAD
Atddismissed
No
13394
Atdid: 13394 • Atd Number: ATD-3-5513 • Bblid: 477211
Atdid
13394
Atd Number
ATD-3-5513
Bblid
477211
Inspectionid
363376
Inspect Date
2023-09-08T00:00:00.000
Atdissuedate
2023-09-11T18:09:04.000
Cb
11
House Num
1738
Onstname
W. 8TH ST.
Atddismissed
No
9953
Atdid: 9953 • Atd Number: ATD-4-4532 • Bblid: 654473
Atdid
9953
Atd Number
ATD-4-4532
Bblid
654473
Inspectionid
335375
Inspect Date
2022-04-12T00:00:00.000
Atdissuedate
2022-04-21T12:45:31.000
Cb
6
House Num
65-50
Onstname
CROMWELL CRES
Atddismissed
No
16722
Atdid: 16722 • Atd Number: ATD-4-6581 • Bblid: 646288
Atdid
16722
Atd Number
ATD-4-6581
Bblid
646288
Inspectionid
388873
Inspect Date
2024-11-08T00:00:00.000
Atdissuedate
2025-01-22T13:03:23.000
Cb
4
House Num
54-09
Onstname
83RD ST.
Atddismissed
No
15105
Atdid: 15105 • Atd Number: ATD-4-6304 • Bblid: 598385
Atdid
15105
Atd Number
ATD-4-6304
Bblid
598385
Inspectionid
382185
Inspect Date
2024-09-19T00:00:00.000
Atdissuedate
2024-09-23T13:41:17.000
Cb
3
House Num
32-18
Onstname
74TH ST.
Atddismissed
No
13408
Atdid: 13408 • Atd Number: ATD-3-5524 • Bblid: 258698
Atdid
13408
Atd Number
ATD-3-5524
Bblid
258698
Inspectionid
363597
Inspect Date
2023-09-15T00:00:00.000
Atdissuedate
2023-09-15T08:14:05.000
Cb
2
House Num
583
Onstname
WARREN ST.
Atddismissed
No
8572
Atdid: 8572 • Atd Number: ATD-3-3141 • Bblid: 308144
Atdid
8572
Atd Number
ATD-3-3141
Bblid
308144
Inspectionid
330504
Inspect Date
2021-08-15T00:00:00.000
Atdissuedate
2021-12-09T08:10:52.000
Cb
3
House Num
561
Onstname
MONROE ST.
Atddismissed
Yes
Atddismissedon
2021-12-09T08:27:05.000
14781
Atdid: 14781 • Atd Number: ATD-4-6171 • Bblid: 868917
Atdid
14781
Atd Number
ATD-4-6171
Bblid
868917
Inspectionid
379707
Inspect Date
2024-06-07T00:00:00.000
Atdissuedate
2024-07-22T13:39:07.000
Cb
12
House Num
124-04
Onstname
155TH ST.
Atddismissed
No
11228
Atdid: 11228 • Atd Number: ATD-3-4534 • Bblid: 281970
Atdid
11228
Atd Number
ATD-3-4534
Bblid
281970
Inspectionid
346723
Inspect Date
2022-10-20T00:00:00.000
Atdissuedate
2022-10-24T09:20:54.000
Cb
6
House Num
60
Onstname
MONTGOMERY PL.
Atddismissed
No
14661
Atdid: 14661 • Atd Number: ATD-3-6081 • Bblid: 259135
Atdid
14661
Atd Number
ATD-3-6081
Bblid
259135
Violationid
287780
Reinspectionid
37184
Inspect Date
2024-06-27T13:52:32.000
Atdissuedate
2024-06-27T13:52:32.000
Cb
6
House Num
49
Onstname
DOUGLASS STREET
Atddismissed
No
9555
Atdid: 9555 • Atd Number: ATD-5-627 • Bblid: 1043615
Atdid
9555
Atd Number
ATD-5-627
Bblid
1043615
Inspectionid
333643
Inspect Date
2021-03-25T00:00:00.000
Atdissuedate
2022-03-10T17:42:16.000
Cb
3
House Num
817
Onstname
SHELDON AVE.
Atddismissed
No
9292
Atdid: 9292 • Atd Number: ATD-3-3396 • Bblid: 449928
Atdid
9292
Atd Number
ATD-3-3396
Bblid
449928
Inspectionid
332998
Inspect Date
2012-09-04T00:00:00.000
Atdissuedate
2022-03-02T08:32:33.000
Cb
10
House Num
33
Onstname
86TH ST.
Atddismissed
No
8754
Atdid: 8754 • Atd Number: ATD-4-3950 • Bblid: 772483
Atdid
8754
Atd Number
ATD-4-3950
Bblid
772483
Inspectionid
331109
Inspect Date
2021-12-28T00:00:00.000
Atdissuedate
2021-12-28T14:25:05.000
Cb
13
House Num
78-32
Onstname
267TH ST.
Atddismissed
No
18313
Atdid: 18313 • Atd Number: ATD-2-1444 • Bblid: 225005
Atdid
18313
Atd Number
ATD-2-1444
Bblid
225005
Inspectionid
404137
Inspect Date
2025-06-21T00:00:00.000
Atdissuedate
2025-08-13T14:26:52.000
Cb
12
House Num
1813
Onstname
EDENWALD AVE.
Atddismissed
No
13794
Atdid: 13794 • Atd Number: ATD-3-5683 • Bblid: 251866
Atdid
13794
Atd Number
ATD-3-5683
Bblid
251866
Inspectionid
369954
Inspect Date
2023-11-30T00:00:00.000
Atdissuedate
2023-12-20T12:25:30.000
Cb
2
House Num
22
Onstname
ORANGE ST.
Atddismissed
Yes
Atddismissedon
2023-12-20T14:02:59.000
11045
Atdid: 11045 • Atd Number: ATD-3-4395 • Bblid: 318180
Atdid
11045
Atd Number
ATD-3-4395
Bblid
318180
Inspectionid
344679
Inspect Date
2022-09-22T00:00:00.000
Atdissuedate
2022-09-28T12:37:24.000
Cb
3
House Num
434A
Onstname
JEFFERSON AVE.
Atddismissed
No
9480
Atdid: 9480 • Atd Number: ATD-3-3524 • Bblid: 267793
Atdid
9480
Atd Number
ATD-3-3524
Bblid
267793
Inspectionid
333386
Inspect Date
2021-07-02T00:00:00.000
Atdissuedate
2022-03-08T10:26:43.000
Cb
7
House Num
767
Onstname
51ST ST.
Atddismissed
Yes
Atddismissedon
2023-02-22T16:09:31.000
11368
Atdid: 11368 • Atd Number: ATD-3-4632 • Bblid: 462635
Atdid
11368
Atd Number
ATD-3-4632
Bblid
462635
Inspectionid
347887
Inspect Date
2022-11-05T00:00:00.000
Atdissuedate
2022-11-09T13:56:12.000
Cb
11
House Num
2245
Onstname
82ND ST.
Atddismissed
No
10567
Atdid: 10567 • Atd Number: ATD-4-4753 • Bblid: 845573
Atdid
10567
Atd Number
ATD-4-4753
Bblid
845573
Inspectionid
340494
Inspect Date
2022-07-21T00:00:00.000
Atdissuedate
2022-07-26T14:58:10.000
Cb
10
House Num
132-33
Onstname
RUBY ST.
Atddismissed
No
9458
Atdid: 9458 • Atd Number: ATD-4-4240 • Bblid: 803289
Atdid
9458
Atd Number
ATD-4-4240
Bblid
803289
Inspectionid
333292
Inspect Date
2003-06-25T00:00:00.000
Atdissuedate
2022-03-04T17:50:25.000
Cb
9
House Num
136-01
Onstname
87TH AVE.
Atddismissed
No
10810
Atdid: 10810 • Atd Number: ATD-3-4181 • Bblid: 517317
Atdid
10810
Atd Number
ATD-3-4181
Bblid
517317
Inspectionid
343046
Inspect Date
2022-08-26T00:00:00.000
Atdissuedate
2022-09-08T16:17:13.000
Cb
18
House Num
3105
Onstname
AVENUE M.
Atddismissed
No
11286
Atdid: 11286 • Atd Number: ATD-4-4867 • Bblid: 672765
Atdid
11286
Atd Number
ATD-4-4867
Bblid
672765
Inspectionid
347078
Inspect Date
2022-10-19T00:00:00.000
Atdissuedate
2022-10-27T10:48:05.000
Cb
5
House Num
71-77
Onstname
70TH ST.
Atddismissed
No
110
Atdid: 110 • Atd Number: ATD-1-94 • Bblid: 27984
Atdid
110
Atd Number
ATD-1-94
Bblid
27984
Violationid
4079
Atdissuedate
2020-03-17T00:00:00.000
Cb
2
House Num
66
Onstname
BANK STREET
Atddismissed
Yes
Atddismissedon
2025-08-18T15:56:03.000
14179
Atdid: 14179 • Atd Number: ATD-3-5840 • Bblid: 531936
Atdid
14179
Atd Number
ATD-3-5840
Bblid
531936
Inspectionid
373659
Inspect Date
2023-12-15T00:00:00.000
Atdissuedate
2024-03-19T14:03:56.000
Cb
18
House Num
661
Onstname
E. 78TH ST.
Atddismissed
No
8626
Atdid: 8626 • Atd Number: ATD-3-3162 • Bblid: 285088
Atdid
8626
Atd Number
ATD-3-3162
Bblid
285088
Inspectionid
330749
Inspect Date
2021-06-14T00:00:00.000
Atdissuedate
2021-12-15T09:14:26.000
Cb
7
House Num
31
Onstname
FULLER PL.
Atddismissed
No
8795
Atdid: 8795 • Atd Number: ATD-4-3971 • Bblid: 644142
Atdid
8795
Atd Number
ATD-4-3971
Bblid
644142
Inspectionid
331323
Inspect Date
2021-12-07T00:00:00.000
Atdissuedate
2021-12-30T11:35:35.000
Cb
5
House Num
60-45
Onstname
72ND ST.
Atddismissed
No
18204
Atdid: 18204 • Atd Number: ATD-4-7192 • Bblid: 590161
Atdid
18204
Atd Number
ATD-4-7192
Bblid
590161
Inspectionid
403307
Inspect Date
2025-07-29T00:00:00.000
Atdissuedate
2025-07-29T08:58:14.000
Cb
1
House Num
22-65
Onstname
21ST ST.
Atddismissed
No
17587
Atdid: 17587 • Atd Number: ATD-4-6875 • Bblid: 634703
Atdid
17587
Atd Number
ATD-4-6875
Bblid
634703
Inspectionid
396946
Inspect Date
2025-05-10T00:00:00.000
Atdissuedate
2025-05-12T15:14:32.000
Cb
4
House Num
79-25
Onstname
CALAMUS AVE.
Atddismissed
No
14308
Atdid: 14308 • Atd Number: ATD-4-5969 • Bblid: 656420
Atdid
14308
Atd Number
ATD-4-5969
Bblid
656420
Inspectionid
375765
Inspect Date
2024-04-22T00:00:00.000
Atdissuedate
2024-04-22T11:58:40.000
Cb
6
House Num
68-50
Onstname
ALDERTON ST.
Atddismissed
No
10253
Atdid: 10253 • Atd Number: ATD-4-4642 • Bblid: 845824
Atdid
10253
Atd Number
ATD-4-4642
Bblid
845824
Inspectionid
337460
Inspect Date
2022-06-08T00:00:00.000
Atdissuedate
2022-06-08T11:13:56.000
Cb
10
House Num
132-28
Onstname
87TH ST.
Atddismissed
No
12826
Atdid: 12826 • Atd Number: ATD-4-5424 • Bblid: 777094
Atdid
12826
Atd Number
ATD-4-5424
Bblid
777094
Inspectionid
359883
Inspect Date
2023-06-03T00:00:00.000
Atdissuedate
2023-07-12T11:10:16.000
Cb
9
House Num
86-26
Onstname
90TH ST.
Atddismissed
No
11075
Atdid: 11075 • Atd Number: ATD-3-4423 • Bblid: 318175
Atdid
11075
Atd Number
ATD-3-4423
Bblid
318175
Inspectionid
345021
Inspect Date
2022-09-22T00:00:00.000
Atdissuedate
2022-10-03T09:31:52.000
Cb
3
House Num
426
Onstname
JEFFERSON AVE.
Atddismissed
No
10398
Atdid: 10398 • Atd Number: ATD-4-4705 • Bblid: 650865
Atdid
10398
Atd Number
ATD-4-4705
Bblid
650865
Inspectionid
338849
Inspect Date
2022-07-07T00:00:00.000
Atdissuedate
2022-07-07T10:15:52.000
Cb
5
House Num
65-29
Onstname
77TH ST.
Atddismissed
No
16886
Atdid: 16886 • Atd Number: ATD-3-6619 • Bblid: 374321
Atdid
16886
Atd Number
ATD-3-6619
Bblid
374321
Inspectionid
390769
Inspect Date
2025-03-05T00:00:00.000
Atdissuedate
2025-03-10T12:01:39.000
Cb
5
House Num
251
Onstname
LINWOOD ST.
Atddismissed
No
9399
Atdid: 9399 • Atd Number: ATD-3-3489 • Bblid: 519596
Atdid
9399
Atd Number
ATD-3-3489
Bblid
519596
Inspectionid
333158
Inspect Date
2021-03-12T00:00:00.000
Atdissuedate
2022-03-03T17:06:45.000
Cb
18
House Num
1536
Onstname
E. 36TH ST.
Atddismissed
Yes
Atddismissedon
2023-06-29T11:09:04.000
13873
Atdid: 13873 • Atd Number: ATD-4-5745 • Bblid: 774342
Atdid
13873
Atd Number
ATD-4-5745
Bblid
774342
Inspectionid
370781
Inspect Date
2024-01-10T00:00:00.000
Atdissuedate
2024-01-18T10:42:42.000
Cb
13
House Num
261-11
Onstname
83RD AVE.
Atddismissed
No
11206
Atdid: 11206 • Atd Number: ATD-3-4524 • Bblid: 463112
Atdid
11206
Atd Number
ATD-3-4524
Bblid
463112
Inspectionid
346377
Inspect Date
2022-10-07T00:00:00.000
Atdissuedate
2022-10-18T09:59:41.000
Cb
11
House Num
1563
Onstname
83RD ST.
Atddismissed
No
15035
Atdid: 15035 • Atd Number: ATD-4-6275 • Bblid: 773767
Atdid
15035
Atd Number
ATD-4-6275
Bblid
773767
Violationid
288837
Reinspectionid
37450
Inspect Date
2024-09-12T14:56:09.000
Atdissuedate
2024-09-12T14:56:09.000
Cb
13
House Num
81-36
Onstname
262 STREET
Atddismissed
No
12942
Atdid: 12942 • Atd Number: ATD-5-768 • Bblid: 1005921
Atdid
12942
Atd Number
ATD-5-768
Bblid
1005921
Inspectionid
360415
Inspect Date
2023-07-06T00:00:00.000
Atdissuedate
2023-07-20T17:01:34.000
Cb
3
House Num
107
Onstname
TYSENS LN.
Atddismissed
No
18149
Atdid: 18149 • Atd Number: ATD-3-7158 • Bblid: 540462
Atdid
18149
Atd Number
ATD-3-7158
Bblid
540462
Inspectionid
402854
Inspect Date
2025-07-03T00:00:00.000
Atdissuedate
2025-07-21T14:10:53.000
Cb
18
House Num
1317
Onstname
REMSEN AVE.
Atddismissed
No