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
9063
Atdid: 9063 • Atd Number: ATD-4-4113 • Bblid: 583721
Atdid
9063
Atd Number
ATD-4-4113
Bblid
583721
Inspectionid
332574
Inspect Date
2019-08-14T00:00:00.000
Atdissuedate
2022-02-18T15:33:51.000
Cb
1
House Num
25-80
Onstname
48TH ST.
Atddismissed
No
13719
Atdid: 13719 • Atd Number: ATD-4-5653 • Bblid: 606453
Atdid
13719
Atd Number
ATD-4-5653
Bblid
606453
Inspectionid
368696
Inspect Date
2023-11-29T00:00:00.000
Atdissuedate
2023-12-01T14:00:53.000
Cb
3
House Num
90-09
Onstname
32ND AVE.
Atddismissed
No
18461
Atdid: 18461 • Atd Number: ATD-4-7316 • Bblid: 727951
Atdid
18461
Atd Number
ATD-4-7316
Bblid
727951
Inspectionid
405031
Inspect Date
2025-08-28T00:00:00.000
Atdissuedate
2025-08-29T13:19:58.000
Cb
11
House Num
36-11
Onstname
203RD ST.
Atddismissed
No
11289
Atdid: 11289 • Atd Number: ATD-4-4870 • Bblid: 659316
Atdid
11289
Atd Number
ATD-4-4870
Bblid
659316
Inspectionid
347092
Inspect Date
2022-10-18T00:00:00.000
Atdissuedate
2022-10-27T11:03:07.000
Cb
6
House Num
71-27
Onstname
INGRAM ST.
Atddismissed
No
11675
Atdid: 11675 • Atd Number: ATD-3-4741 • Bblid: 425316
Atdid
11675
Atd Number
ATD-3-4741
Bblid
425316
Inspectionid
351749
Inspect Date
2023-01-31T00:00:00.000
Atdissuedate
2023-02-16T16:24:41.000
Cb
12
House Num
1731
Onstname
56TH ST.
Atddismissed
No
14239
Atdid: 14239 • Atd Number: ATD-4-5933 • Bblid: 644331
Atdid
14239
Atd Number
ATD-4-5933
Bblid
644331
Inspectionid
374751
Inspect Date
2024-04-03T00:00:00.000
Atdissuedate
2024-04-03T14:17:03.000
Cb
4
House Num
87-16
Onstname
55TH AVE.
Atddismissed
No
17095
Atdid: 17095 • Atd Number: ATD-3-6742 • Bblid: 332307
Atdid
17095
Atd Number
ATD-3-6742
Bblid
332307
Inspectionid
392475
Inspect Date
2023-04-14T00:00:00.000
Atdissuedate
2025-03-28T09:52:02.000
Cb
1
House Num
144
Onstname
HEWES ST.
Atddismissed
No
9098
Atdid: 9098 • Atd Number: ATD-4-4147 • Bblid: 686317
Atdid
9098
Atd Number
ATD-4-4147
Bblid
686317
Inspectionid
332649
Inspect Date
2019-08-03T00:00:00.000
Atdissuedate
2022-02-22T14:47:00.000
Cb
7
House Num
2
Onstname
CENTER DR.
Atddismissed
No
11098
Atdid: 11098 • Atd Number: ATD-3-4445 • Bblid: 555902
Atdid
11098
Atd Number
ATD-3-4445
Bblid
555902
Inspectionid
345177
Inspect Date
2022-09-28T00:00:00.000
Atdissuedate
2022-10-04T14:34:57.000
Cb
18
House Num
2644
Onstname
E. 65TH ST.
Atddismissed
No
8808
Atdid: 8808 • Atd Number: ATD-3-3227 • Bblid: 328676
Atdid
8808
Atd Number
ATD-3-3227
Bblid
328676
Inspectionid
331484
Inspect Date
2021-12-28T00:00:00.000
Atdissuedate
2022-01-05T15:13:04.000
Cb
2
House Num
302
Onstname
CLERMONT AVE.
Atddismissed
No
9941
Atdid: 9941 • Atd Number: ATD-4-4520 • Bblid: 654407
Atdid
9941
Atd Number
ATD-4-4520
Bblid
654407
Inspectionid
335344
Inspect Date
2022-04-14T00:00:00.000
Atdissuedate
2022-04-21T12:11:35.000
Cb
6
House Num
65-26
Onstname
BOELSEN CRES
Atddismissed
No
8924
Atdid: 8924 • Atd Number: ATD-3-3255 • Bblid: 279472
Atdid
8924
Atd Number
ATD-3-3255
Bblid
279472
Inspectionid
332151
Inspect Date
2019-04-27T00:00:00.000
Atdissuedate
2022-01-31T10:06:32.000
Cb
6
House Num
173
Onstname
12TH ST.
Atddismissed
Yes
Atddismissedon
2022-04-27T12:26:49.000
12282
Atdid: 12282 • Atd Number: ATD-3-5040 • Bblid: 271834
Atdid
12282
Atd Number
ATD-3-5040
Bblid
271834
Violationid
279710
Reinspectionid
33442
Inspect Date
2023-05-19T08:43:26.000
Atdissuedate
2023-05-19T08:43:26.000
Cb
7
House Num
546
Onstname
17 STREET
Atddismissed
No
16389
Atdid: 16389 • Atd Number: ATD-3-6420 • Bblid: 287876
Atdid
16389
Atd Number
ATD-3-6420
Bblid
287876
Inspectionid
385094
Inspect Date
2021-09-15T00:00:00.000
Atdissuedate
2024-11-16T11:54:03.000
Cb
8
House Num
378
Onstname
STERLING PLACE
Atddismissed
No
8834
Atdid: 8834 • Atd Number: ATD-3-3238 • Bblid: 250611
Atdid
8834
Atd Number
ATD-3-3238
Bblid
250611
Inspectionid
331668
Inspect Date
2019-11-23T00:00:00.000
Atdissuedate
2022-01-18T09:52:46.000
Cb
2
House Num
351
Onstname
PACIFIC STREET
Atddismissed
No
12390
Atdid: 12390 • Atd Number: ATD-4-5256 • Bblid: 604433
Atdid
12390
Atd Number
ATD-4-5256
Bblid
604433
Inspectionid
357547
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:49:02.000
Cb
2
House Num
72-01
Onstname
QUEENS BLVD.
Atddismissed
No
13898
Atdid: 13898 • Atd Number: ATD-3-5709 • Bblid: 511289
Atdid
13898
Atd Number
ATD-3-5709
Bblid
511289
Inspectionid
371060
Inspect Date
2024-01-13T00:00:00.000
Atdissuedate
2024-01-29T13:00:41.000
Cb
15
House Num
4583
Onstname
BEDFORD AVE.
Atddismissed
No
10744
Atdid: 10744 • Atd Number: ATD-3-4122 • Bblid: 554709
Atdid
10744
Atd Number
ATD-3-4122
Bblid
554709
Inspectionid
342719
Inspect Date
2022-08-25T00:00:00.000
Atdissuedate
2022-09-06T14:19:29.000
Cb
18
House Num
2780
Onstname
E. 64TH ST.
Atddismissed
No
13314
Atdid: 13314 • Atd Number: ATD-3-5464 • Bblid: 316623
Atdid
13314
Atd Number
ATD-3-5464
Bblid
316623
Inspectionid
362514
Inspect Date
2023-08-24T00:00:00.000
Atdissuedate
2023-08-24T11:30:30.000
Cb
3
House Num
432
Onstname
QUINCY ST.
Atddismissed
No
17610
Atdid: 17610 • Atd Number: ATD-4-6882 • Bblid: 647560
Atdid
17610
Atd Number
ATD-4-6882
Bblid
647560
Inspectionid
397081
Inspect Date
2025-04-02T00:00:00.000
Atdissuedate
2025-05-15T09:48:26.000
Cb
5
House Num
61-44
Onstname
76TH ST.
Atddismissed
No
17726
Atdid: 17726 • Atd Number: ATD-4-6973 • Bblid: 726873
Atdid
17726
Atd Number
ATD-4-6973
Bblid
726873
Inspectionid
398327
Inspect Date
2025-05-23T00:00:00.000
Atdissuedate
2025-05-23T13:13:16.000
Cb
11
House Num
32-22
Onstname
BELL BLVD.
Atddismissed
No
17209
Atdid: 17209 • Atd Number: ATD-3-6810 • Bblid: 287488
Atdid
17209
Atd Number
ATD-3-6810
Bblid
287488
Inspectionid
392902
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-04-01T12:41:08.000
Cb
8
House Num
169
Onstname
UNDERHILL AVE.
Atddismissed
No
10008
Atdid: 10008 • Atd Number: ATD-4-4560 • Bblid: 654704
Atdid
10008
Atd Number
ATD-4-4560
Bblid
654704
Inspectionid
335863
Inspect Date
2022-04-21T00:00:00.000
Atdissuedate
2022-04-29T14:34:12.000
Cb
6
House Num
62-17
Onstname
CROMWELL CRES
Atddismissed
No
18526
Atdid: 18526 • Atd Number: ATD-4-7337 • Bblid: 716255
Atdid
18526
Atd Number
ATD-4-7337
Bblid
716255
Inspectionid
405418
Inspect Date
2025-09-04T00:00:00.000
Atdissuedate
2025-09-08T10:26:58.000
Cb
11
House Num
45-48
Onstname
196TH ST.
Atddismissed
No
9487
Atdid: 9487 • Atd Number: ATD-3-3529 • Bblid: 276607
Atdid
9487
Atd Number
ATD-3-3529
Bblid
276607
Inspectionid
333393
Inspect Date
2021-07-30T00:00:00.000
Atdissuedate
2022-03-08T10:54:05.000
Cb
6
House Num
651
Onstname
CARROLL ST.
Atddismissed
No
16385
Atdid: 16385 • Atd Number: ATD-2-1322 • Bblid: 210125
Atdid
16385
Atd Number
ATD-2-1322
Bblid
210125
Inspectionid
385090
Inspect Date
2023-05-13T00:00:00.000
Atdissuedate
2024-11-16T11:05:37.000
Cb
12
House Num
3025
Onstname
WALLACE AVE.
Atddismissed
No
17121
Atdid: 17121 • Atd Number: ATD-3-6767 • Bblid: 509052
Atdid
17121
Atd Number
ATD-3-6767
Bblid
509052
Inspectionid
392526
Inspect Date
2023-07-26T00:00:00.000
Atdissuedate
2025-03-28T15:10:23.000
Cb
15
House Num
2304
Onstname
E. 24TH ST.
Atddismissed
No
17953
Atdid: 17953 • Atd Number: ATD-4-7089 • Bblid: 869209
Atdid
17953
Atd Number
ATD-4-7089
Bblid
869209
Violationid
301038
Reinspectionid
39342
Inspect Date
2025-06-23T11:22:43.000
Atdissuedate
2025-06-23T11:22:43.000
Cb
12
House Num
155-48
Onstname
116 DRIVE
Atddismissed
No
14675
Atdid: 14675 • Atd Number: ATD-3-6089 • Bblid: 462053
Atdid
14675
Atd Number
ATD-3-6089
Bblid
462053
Inspectionid
378944
Inspect Date
2024-06-24T00:00:00.000
Atdissuedate
2024-07-01T11:23:46.000
Cb
11
House Num
8015
Onstname
14TH AVE.
Atddismissed
No
17397
Atdid: 17397 • Atd Number: ATD-4-6783 • Bblid: 657643
Atdid
17397
Atd Number
ATD-4-6783
Bblid
657643
Inspectionid
394952
Inspect Date
2025-04-15T00:00:00.000
Atdissuedate
2025-04-21T08:32:12.000
Cb
6
House Num
93-10
Onstname
68TH AVE.
Atddismissed
No
16874
Atdid: 16874 • Atd Number: ATD-5-918 • Bblid: 953721
Atdid
16874
Atd Number
ATD-5-918
Bblid
953721
Inspectionid
390469
Inspect Date
2025-03-05T00:00:00.000
Atdissuedate
2025-03-06T16:49:13.000
Cb
1
House Num
114
Onstname
DECKER AVE.
Atddismissed
No
16637
Atdid: 16637 • Atd Number: ATD-4-6536 • Bblid: 785684
Atdid
16637
Atd Number
ATD-4-6536
Bblid
785684
Inspectionid
388456
Inspect Date
2024-12-30T00:00:00.000
Atdissuedate
2025-01-03T12:11:16.000
Cb
10
House Num
107-60
Onstname
77TH ST.
Atddismissed
No
16725
Atdid: 16725 • Atd Number: ATD-3-6552 • Bblid: 262415
Atdid
16725
Atd Number
ATD-3-6552
Bblid
262415
Inspectionid
388914
Inspect Date
2025-01-23T00:00:00.000
Atdissuedate
2025-01-23T14:35:21.000
Cb
6
House Num
44
Onstname
COFFEY ST.
Atddismissed
No
8838
Atdid: 8838 • Atd Number: ATD-3-3239 • Bblid: 480576
Atdid
8838
Atd Number
ATD-3-3239
Bblid
480576
Inspectionid
331715
Inspect Date
2022-01-12T00:00:00.000
Atdissuedate
2022-01-19T10:28:39.000
Cb
14
House Num
914
Onstname
E. 13TH ST.
Atddismissed
No
12153
Atdid: 12153 • Atd Number: ATD-4-5175 • Bblid: 734974
Atdid
12153
Atd Number
ATD-4-5175
Bblid
734974
Violationid
284130
Reinspectionid
34279
Inspect Date
2023-05-04T14:26:07.000
Atdissuedate
2023-05-04T14:26:07.000
Cb
8
House Num
136-10
Onstname
72 AVENUE
Atddismissed
No
11726
Atdid: 11726 • Atd Number: ATD-3-4766 • Bblid: 481065
Atdid
11726
Atd Number
ATD-3-4766
Bblid
481065
Inspectionid
352146
Inspect Date
2023-01-27T00:00:00.000
Atdissuedate
2023-02-28T09:33:09.000
Cb
14
House Num
1160
Onstname
E. 13TH ST.
Atddismissed
No
16392
Atdid: 16392 • Atd Number: ATD-3-6423 • Bblid: 287892
Atdid
16392
Atd Number
ATD-3-6423
Bblid
287892
Inspectionid
385097
Inspect Date
2021-09-14T00:00:00.000
Atdissuedate
2024-11-16T11:59:03.000
Cb
8
House Num
412
Onstname
STERLING PL.
Atddismissed
No
13001
Atdid: 13001 • Atd Number: ATD-3-5261 • Bblid: 422366
Atdid
13001
Atd Number
ATD-3-5261
Bblid
422366
Inspectionid
360808
Inspect Date
2023-07-27T00:00:00.000
Atdissuedate
2023-07-27T13:30:39.000
Cb
12
House Num
1544
Onstname
45TH ST.
Atddismissed
No
12664
Atdid: 12664 • Atd Number: ATD-5-706 • Bblid: 1025014
Atdid
12664
Atd Number
ATD-5-706
Bblid
1025014
Inspectionid
359070
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-06-28T14:29:38.000
Cb
3
House Num
3143
Onstname
RICHMOND AVENUE
Atddismissed
No
17448
Atdid: 17448 • Atd Number: ATD-3-6922 • Bblid: 378319
Atdid
17448
Atd Number
ATD-3-6922
Bblid
378319
Inspectionid
395408
Inspect Date
2025-03-25T00:00:00.000
Atdissuedate
2025-04-25T22:30:29.000
Cb
5
House Num
568
Onstname
SCHENCK AVE.
Atddismissed
No
16120
Atdid: 16120 • Atd Number: ATD-2-1306 • Bblid: 172309
Atdid
16120
Atd Number
ATD-2-1306
Bblid
172309
Inspectionid
383306
Inspect Date
2024-09-18T00:00:00.000
Atdissuedate
2024-09-27T11:57:41.000
Cb
9
House Num
543
Onstname
BOLTON AVE.
Atddismissed
No
12700
Atdid: 12700 • Atd Number: ATD-5-735 • Bblid: 1009603
Atdid
12700
Atd Number
ATD-5-735
Bblid
1009603
Inspectionid
359111
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-29T15:22:45.000
Cb
3
House Num
342
Onstname
ARTHUR KILL RD.
Atddismissed
No
11470
Atdid: 11470 • Atd Number: ATD-3-4679 • Bblid: 257617
Atdid
11470
Atd Number
ATD-3-4679
Bblid
257617
Inspectionid
348764
Inspect Date
2022-11-29T00:00:00.000
Atdissuedate
2022-11-29T15:25:32.000
Cb
6
House Num
90A
Onstname
3RD PL.
Atddismissed
No
11760
Atdid: 11760 • Atd Number: ATD-3-4785 • Bblid: 285543
Atdid
11760
Atd Number
ATD-3-4785
Bblid
285543
Inspectionid
352604
Inspect Date
2023-03-10T00:00:00.000
Atdissuedate
2023-03-10T11:22:34.000
Cb
8
House Num
932
Onstname
PACIFIC ST.
Atddismissed
No
18023
Atdid: 18023 • Atd Number: ATD-4-7113 • Bblid: 770911
Atdid
18023
Atd Number
ATD-4-7113
Bblid
770911
Inspectionid
401832
Inspect Date
2025-07-03T00:00:00.000
Atdissuedate
2025-07-07T08:26:03.000
Cb
13
House Num
84-12
Onstname
253RD ST.
Atddismissed
No
15076
Atdid: 15076 • Atd Number: ATD-4-6284 • Bblid: 747901
Atdid
15076
Atd Number
ATD-4-6284
Bblid
747901
Inspectionid
382094
Inspect Date
2024-08-20T00:00:00.000
Atdissuedate
2024-09-23T11:36:09.000
Cb
8
House Num
73-20
Onstname
193RD ST.
Atddismissed
No
8816
Atdid: 8816 • Atd Number: ATD-3-3234 • Bblid: 270288
Atdid
8816
Atd Number
ATD-3-3234
Bblid
270288
Inspectionid
331541
Inspect Date
2021-11-04T00:00:00.000
Atdissuedate
2022-01-07T15:01:00.000
Cb
7
House Num
440
Onstname
57TH ST.
Atddismissed
No
12758
Atdid: 12758 • Atd Number: ATD-5-762 • Bblid: 1007799
Atdid
12758
Atd Number
ATD-5-762
Bblid
1007799
Inspectionid
359472
Inspect Date
2023-07-05T00:00:00.000
Atdissuedate
2023-07-05T12:59:54.000
Cb
3
House Num
78
Onstname
BOYCE AVE.
Atddismissed
No
13468
Atdid: 13468 • Atd Number: ATD-3-5544 • Bblid: 509463
Atdid
13468
Atd Number
ATD-3-5544
Bblid
509463
Inspectionid
364219
Inspect Date
2023-09-08T00:00:00.000
Atdissuedate
2023-09-25T13:45:21.000
Cb
15
House Num
2361
Onstname
E. 29TH ST.
Atddismissed
No
10166
Atdid: 10166 • Atd Number: ATD-2-924 • Bblid: 208816
Atdid
10166
Atd Number
ATD-2-924
Bblid
208816
Inspectionid
336901
Inspect Date
2021-11-30T00:00:00.000
Atdissuedate
2022-05-24T08:24:53.000
Cb
12
House Num
3028
Onstname
BRONX PARK E.
Atddismissed
No