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
8475
Atdid: 8475 • Atd Number: ATD-3-3084 • Bblid: 289306
Atdid
8475
Atd Number
ATD-3-3084
Bblid
289306
Inspectionid
329462
Inspect Date
2021-10-28T00:00:00.000
Atdissuedate
2021-10-28T00:00:00.000
Cb
8
House Num
1402
Onstname
DEAN ST.
Atddismissed
No
10818
Atdid: 10818 • Atd Number: ATD-3-4189 • Bblid: 462875
Atdid
10818
Atd Number
ATD-3-4189
Bblid
462875
Inspectionid
343294
Inspect Date
2022-09-10T00:00:00.000
Atdissuedate
2022-09-10T15:46:44.000
Cb
10
House Num
1353
Onstname
83RD ST.
Atddismissed
No
9420
Atdid: 9420 • Atd Number: ATD-4-4221 • Bblid: 683579
Atdid
9420
Atd Number
ATD-4-4221
Bblid
683579
Inspectionid
333203
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-03-04T10:44:10.000
Cb
7
House Num
15-06
Onstname
PARSONS BLVD.
Atddismissed
No
17823
Atdid: 17823 • Atd Number: ATD-3-7024 • Bblid: 429003
Atdid
17823
Atd Number
ATD-3-7024
Bblid
429003
Inspectionid
399370
Inspect Date
2025-06-07T00:00:00.000
Atdissuedate
2025-06-07T12:31:34.000
Cb
11
House Num
6622
Onstname
OVINGTON CT.
Atddismissed
No
14447
Atdid: 14447 • Atd Number: ATD-4-6029 • Bblid: 585301
Atdid
14447
Atd Number
ATD-4-6029
Bblid
585301
Inspectionid
377186
Inspect Date
2024-04-01T00:00:00.000
Atdissuedate
2024-05-09T14:48:13.000
Cb
1
House Num
22-38
Onstname
43RD ST.
Atddismissed
No
8902
Atdid: 8902 • Atd Number: ATD-4-4030 • Bblid: 630895
Atdid
8902
Atd Number
ATD-4-4030
Bblid
630895
Inspectionid
332115
Inspect Date
2017-10-26T00:00:00.000
Atdissuedate
2022-01-27T10:35:27.000
Cb
2
House Num
50-16
Onstname
46TH ST.
Atddismissed
No
17612
Atdid: 17612 • Atd Number: ATD-3-6978 • Bblid: 274333
Atdid
17612
Atd Number
ATD-3-6978
Bblid
274333
Inspectionid
397088
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2025-05-15T10:38:29.000
Cb
6
House Num
635
Onstname
BALTIC ST.
Atddismissed
No
11873
Atdid: 11873 • Atd Number: ATD-3-4846 • Bblid: 420604
Atdid
11873
Atd Number
ATD-3-4846
Bblid
420604
Inspectionid
353640
Inspect Date
2023-03-18T00:00:00.000
Atdissuedate
2023-03-22T12:38:43.000
Cb
12
House Num
593
Onstname
E. 2ND ST.
Atddismissed
No
14757
Atdid: 14757 • Atd Number: ATD-2-1293 • Bblid: 178929
Atdid
14757
Atd Number
ATD-2-1293
Bblid
178929
Violationid
286557
Reinspectionid
36928
Inspect Date
2024-07-17T13:21:34.000
Atdissuedate
2024-07-17T13:21:34.000
Cb
9
House Num
2265
Onstname
CHATTERTON AVENUE
Atddismissed
No
14149
Atdid: 14149 • Atd Number: ATD-3-5811 • Bblid: 448399
Atdid
14149
Atd Number
ATD-3-5811
Bblid
448399
Inspectionid
373480
Inspect Date
2024-03-13T00:00:00.000
Atdissuedate
2024-03-18T16:13:46.000
Cb
10
House Num
363
Onstname
80TH ST.
Atddismissed
No
16378
Atdid: 16378 • Atd Number: ATD-1-325 • Bblid: 126226
Atdid
16378
Atd Number
ATD-1-325
Bblid
126226
Inspectionid
385075
Inspect Date
2024-06-29T00:00:00.000
Atdissuedate
2024-11-15T11:56:09.000
Cb
10
House Num
148
Onstname
W. 120TH ST.
Atddismissed
No
13818
Atdid: 13818 • Atd Number: ATD-4-5713 • Bblid: 875757
Atdid
13818
Atd Number
ATD-4-5713
Bblid
875757
Inspectionid
370101
Inspect Date
2023-12-26T00:00:00.000
Atdissuedate
2023-12-26T13:26:23.000
Cb
12
House Num
172-14
Onstname
144TH RD.
Atddismissed
No
17015
Atdid: 17015 • Atd Number: ATD-3-6683 • Bblid: 282914
Atdid
17015
Atd Number
ATD-3-6683
Bblid
282914
Inspectionid
392204
Inspect Date
2025-03-19T00:00:00.000
Atdissuedate
2025-03-25T13:10:55.000
Cb
6
House Num
578
Onstname
4TH ST.
Atddismissed
No
17281
Atdid: 17281 • Atd Number: ATD-4-6742 • Bblid: 799719
Atdid
17281
Atd Number
ATD-4-6742
Bblid
799719
Inspectionid
393463
Inspect Date
2025-03-25T00:00:00.000
Atdissuedate
2025-04-07T12:27:44.000
Cb
10
House Num
107-48
Onstname
107TH ST.
Atddismissed
No
18480
Atdid: 18480 • Atd Number: ATD-2-1455 • Bblid: 225345
Atdid
18480
Atd Number
ATD-2-1455
Bblid
225345
Inspectionid
405201
Inspect Date
2025-08-26T00:00:00.000
Atdissuedate
2025-09-04T14:06:35.000
Cb
12
House Num
4123
Onstname
BAYCHESTER AVE.
Atddismissed
No
8744
Atdid: 8744 • Atd Number: ATD-4-3940 • Bblid: 772525
Atdid
8744
Atd Number
ATD-4-3940
Bblid
772525
Inspectionid
331098
Inspect Date
2021-12-01T00:00:00.000
Atdissuedate
2021-12-28T13:16:07.000
Cb
13
House Num
78-08
Onstname
268TH ST.
Atddismissed
No
16178
Atdid: 16178 • Atd Number: ATD-3-6325 • Bblid: 543967
Atdid
16178
Atd Number
ATD-3-6325
Bblid
543967
Violationid
289624
Reinspectionid
37493
Inspect Date
2024-10-03T11:19:22.000
Atdissuedate
2024-10-03T11:19:22.000
Cb
18
House Num
1372
Onstname
EAST 100 STREET
Atddismissed
No
17716
Atdid: 17716 • Atd Number: ATD-4-6964 • Bblid: 797597
Atdid
17716
Atd Number
ATD-4-6964
Bblid
797597
Inspectionid
398298
Inspect Date
2025-05-20T00:00:00.000
Atdissuedate
2025-05-23T11:24:57.000
Cb
9
House Num
102-14
Onstname
135TH ST.
Atddismissed
No
16263
Atdid: 16263 • Atd Number: ATD-3-6361 • Bblid: 372730
Atdid
16263
Atd Number
ATD-3-6361
Bblid
372730
Inspectionid
384265
Inspect Date
2024-10-01T00:00:00.000
Atdissuedate
2024-10-21T11:48:52.000
Cb
5
House Num
38
Onstname
HIGHLAND PL.
Atddismissed
No
16286
Atdid: 16286 • Atd Number: ATD-4-6398 • Bblid: 589593
Atdid
16286
Atd Number
ATD-4-6398
Bblid
589593
Inspectionid
384388
Inspect Date
2024-10-03T00:00:00.000
Atdissuedate
2024-10-25T14:16:04.000
Cb
1
House Num
23-24
Onstname
CRESCENT ST.
Atddismissed
No
18400
Atdid: 18400 • Atd Number: ATD-2-1449 • Bblid: 196636
Atdid
18400
Atd Number
ATD-2-1449
Bblid
196636
Violationid
30082
Inspectionid
404663
Inspect Date
2025-08-22T09:43:51.000
Atdissuedate
2025-08-22T09:43:51.000
Cb
11
House Num
928
Onstname
PIERCE AVENUE
Atddismissed
No
11281
Atdid: 11281 • Atd Number: ATD-4-4862 • Bblid: 672799
Atdid
11281
Atd Number
ATD-4-4862
Bblid
672799
Inspectionid
347062
Inspect Date
2022-10-19T00:00:00.000
Atdissuedate
2022-10-27T10:30:20.000
Cb
5
House Num
71-21
Onstname
70TH ST.
Atddismissed
No
2310
Atdid: 2310 • Atd Number: ATD-3-1453 • Bblid: 424014
Atdid
2310
Atd Number
ATD-3-1453
Bblid
424014
Violationid
168828
Atdissuedate
2020-08-11T00:00:00.000
Cb
12
House Num
1515
Onstname
52 STREET
Atddismissed
Yes
Atddismissedon
2023-01-31T13:00:16.000
11922
Atdid: 11922 • Atd Number: ATD-3-4873 • Bblid: 286531
Atdid
11922
Atd Number
ATD-3-4873
Bblid
286531
Inspectionid
354169
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-29T12:10:48.000
Cb
8
House Num
219
Onstname
PROSPECT PL.
Atddismissed
No
8798
Atdid: 8798 • Atd Number: ATD-4-3974 • Bblid: 644176
Atdid
8798
Atd Number
ATD-4-3974
Bblid
644176
Inspectionid
331339
Inspect Date
2021-12-07T00:00:00.000
Atdissuedate
2021-12-30T11:43:28.000
Cb
5
House Num
60-07
Onstname
72ND ST.
Atddismissed
No
12102
Atdid: 12102 • Atd Number: ATD-3-4957 • Bblid: 268787
Atdid
12102
Atd Number
ATD-3-4957
Bblid
268787
Inspectionid
356322
Inspect Date
2023-04-19T00:00:00.000
Atdissuedate
2023-04-26T14:04:52.000
Cb
7
House Num
439
Onstname
54TH ST.
Atddismissed
No
13222
Atdid: 13222 • Atd Number: ATD-3-5393 • Bblid: 422661
Atdid
13222
Atd Number
ATD-3-5393
Bblid
422661
Inspectionid
362042
Inspect Date
2023-08-16T00:00:00.000
Atdissuedate
2023-08-16T15:27:15.000
Cb
12
House Num
1749
Onstname
46TH ST.
Atddismissed
No
14540
Atdid: 14540 • Atd Number: ATD-3-6003 • Bblid: 459434
Atdid
14540
Atd Number
ATD-3-6003
Bblid
459434
Inspectionid
377882
Inspect Date
2024-05-17T00:00:00.000
Atdissuedate
2024-05-28T13:55:32.000
Cb
11
House Num
1742
Onstname
76TH ST.
Atddismissed
No
14173
Atdid: 14173 • Atd Number: ATD-3-5834 • Bblid: 511300
Atdid
14173
Atd Number
ATD-3-5834
Bblid
511300
Inspectionid
373611
Inspect Date
2024-01-13T00:00:00.000
Atdissuedate
2024-03-19T13:01:52.000
Cb
15
House Num
4553
Onstname
BEDFORD AVE.
Atddismissed
No
13114
Atdid: 13114 • Atd Number: ATD-3-5327 • Bblid: 422740
Atdid
13114
Atd Number
ATD-3-5327
Bblid
422740
Inspectionid
361421
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T12:01:37.000
Cb
12
House Num
1520
Onstname
46TH ST.
Atddismissed
No
12564
Atdid: 12564 • Atd Number: ATD-1-294 • Bblid: 114770
Atdid
12564
Atd Number
ATD-1-294
Bblid
114770
Inspectionid
358527
Inspect Date
2023-06-13T00:00:00.000
Atdissuedate
2023-06-13T16:13:31.000
Cb
11
House Num
1711
Onstname
LEXINGTON AVE.
Atddismissed
No
10829
Atdid: 10829 • Atd Number: ATD-3-4200 • Bblid: 262307
Atdid
10829
Atd Number
ATD-3-4200
Bblid
262307
Inspectionid
343334
Inspect Date
2022-09-09T00:00:00.000
Atdissuedate
2022-09-12T10:06:05.000
Cb
6
House Num
65
Onstname
DIKEMAN ST.
Atddismissed
No
11834
Atdid: 11834 • Atd Number: ATD-4-5065 • Bblid: 673974
Atdid
11834
Atd Number
ATD-4-5065
Bblid
673974
Inspectionid
353488
Inspect Date
2023-03-21T00:00:00.000
Atdissuedate
2023-03-21T11:51:26.000
Cb
5
House Num
78-22
Onstname
61ST ST.
Atddismissed
No
11592
Atdid: 11592 • Atd Number: ATD-4-4958 • Bblid: 669780
Atdid
11592
Atd Number
ATD-4-4958
Bblid
669780
Inspectionid
350377
Inspect Date
2023-01-09T00:00:00.000
Atdissuedate
2023-01-11T12:54:22.000
Cb
5
House Num
74-32
Onstname
64TH PL.
Atddismissed
No
11827
Atdid: 11827 • Atd Number: ATD-4-5058 • Bblid: 717980
Atdid
11827
Atd Number
ATD-4-5058
Bblid
717980
Inspectionid
353367
Inspect Date
2023-03-16T00:00:00.000
Atdissuedate
2023-03-20T14:00:31.000
Cb
11
House Num
50-23
Onstname
175TH ST.
Atddismissed
No
18476
Atdid: 18476 • Atd Number: ATD-2-1454 • Bblid: 225353
Atdid
18476
Atd Number
ATD-2-1454
Bblid
225353
Inspectionid
405190
Inspect Date
2025-08-26T00:00:00.000
Atdissuedate
2025-09-04T13:52:39.000
Cb
12
House Num
4115
Onstname
BAYCHESTER AVE.
Atddismissed
No
14824
Atdid: 14824 • Atd Number: ATD-3-6159 • Bblid: 534629
Atdid
14824
Atd Number
ATD-3-6159
Bblid
534629
Violationid
294949
Inspectionid
378113
Inspect Date
2024-07-31T10:44:45.000
Atdissuedate
2024-07-31T10:44:45.000
Cb
18
House Num
1184
Onstname
EAST 82 STREET
Atddismissed
No
9674
Atdid: 9674 • Atd Number: ATD-5-647 • Bblid: 929948
Atdid
9674
Atd Number
ATD-5-647
Bblid
929948
Inspectionid
333871
Inspect Date
2021-05-04T00:00:00.000
Atdissuedate
2022-03-16T18:03:31.000
Cb
1
House Num
608
Onstname
CARY AVE.
Atddismissed
Yes
Atddismissedon
2024-05-17T09:46:37.000
18446
Atdid: 18446 • Atd Number: ATD-4-7301 • Bblid: 588970
Atdid
18446
Atd Number
ATD-4-7301
Bblid
588970
Inspectionid
404966
Inspect Date
2025-08-28T00:00:00.000
Atdissuedate
2025-08-28T12:35:56.000
Cb
1
House Num
20-50
Onstname
27TH ST.
Atddismissed
No
12383
Atdid: 12383 • Atd Number: ATD-4-5249 • Bblid: 604334
Atdid
12383
Atd Number
ATD-4-5249
Bblid
604334
Inspectionid
357540
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:45:16.000
Cb
2
House Num
70-25
Onstname
QUEENS BLVD.
Atddismissed
No
11924
Atdid: 11924 • Atd Number: ATD-3-4875 • Bblid: 286534
Atdid
11924
Atd Number
ATD-3-4875
Bblid
286534
Inspectionid
354172
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-29T12:11:50.000
Cb
8
House Num
213
Onstname
PROSPECT PL.
Atddismissed
No
13094
Atdid: 13094 • Atd Number: ATD-3-5321 • Bblid: 421140
Atdid
13094
Atd Number
ATD-3-5321
Bblid
421140
Inspectionid
361339
Inspect Date
2023-08-02T00:00:00.000
Atdissuedate
2023-08-02T16:22:54.000
Cb
12
House Num
1765
Onstname
45TH ST.
Atddismissed
No
11861
Atdid: 11861 • Atd Number: ATD-3-4834 • Bblid: 509760
Atdid
11861
Atd Number
ATD-3-4834
Bblid
509760
Inspectionid
353584
Inspect Date
2023-03-16T00:00:00.000
Atdissuedate
2023-03-22T12:07:11.000
Cb
15
House Num
2420
Onstname
E. 14TH ST.
Atddismissed
No
10518
Atdid: 10518 • Atd Number: ATD-4-4746 • Bblid: 876759
Atdid
10518
Atd Number
ATD-4-4746
Bblid
876759
Inspectionid
340086
Inspect Date
2022-06-25T00:00:00.000
Atdissuedate
2022-07-19T14:47:08.000
Cb
12
House Num
118-28
Onstname
202ND ST.
Atddismissed
No
18106
Atdid: 18106 • Atd Number: ATD-3-7135 • Bblid: 250222
Atdid
18106
Atd Number
ATD-3-7135
Bblid
250222
Inspectionid
402534
Inspect Date
2025-07-15T00:00:00.000
Atdissuedate
2025-07-17T09:20:53.000
Cb
2
House Num
441
Onstname
STATE ST.
Atddismissed
No
9651
Atdid: 9651 • Atd Number: ATD-4-4355 • Bblid: 749368
Atdid
9651
Atd Number
ATD-4-4355
Bblid
749368
Inspectionid
333820
Inspect Date
2021-04-29T00:00:00.000
Atdissuedate
2022-03-15T19:16:48.000
Cb
8
House Num
82-03
Onstname
UTOPIA PKWY.
Atddismissed
No
14272
Atdid: 14272 • Atd Number: ATD-3-5888 • Bblid: 425744
Atdid
14272
Atd Number
ATD-3-5888
Bblid
425744
Inspectionid
375211
Inspect Date
2024-02-27T00:00:00.000
Atdissuedate
2024-04-11T17:18:36.000
Cb
12
House Num
1130
Onstname
E. 5TH ST.
Atddismissed
No
11054
Atdid: 11054 • Atd Number: ATD-4-4828 • Bblid: 764923
Atdid
11054
Atd Number
ATD-4-4828
Bblid
764923
Inspectionid
344791
Inspect Date
2022-09-30T00:00:00.000
Atdissuedate
2022-09-30T09:46:51.000
Cb
11
House Num
50-40
Onstname
245TH ST.
Atddismissed
No
17973
Atdid: 17973 • Atd Number: ATD-4-7096 • Bblid: 669594
Atdid
17973
Atd Number
ATD-4-7096
Bblid
669594
Violationid
302029
Inspectionid
383515
Inspect Date
2025-06-25T09:44:43.000
Atdissuedate
2025-06-25T09:44:43.000
Cb
5
House Num
75-50
Onstname
61 STREET
Atddismissed
No
13571
Atdid: 13571 • Atd Number: ATD-3-5587 • Bblid: 418497
Atdid
13571
Atd Number
ATD-3-5587
Bblid
418497
Inspectionid
365135
Inspect Date
2023-10-06T00:00:00.000
Atdissuedate
2023-10-10T16:17:05.000
Cb
12
House Num
1473
Onstname
40TH ST.
Atddismissed
No