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
17029
Atdid: 17029 • Atd Number: ATD-4-6677 • Bblid: 570933
Atdid
17029
Atd Number
ATD-4-6677
Bblid
570933
Inspectionid
392278
Inspect Date
2021-10-16T00:00:00.000
Atdissuedate
2025-03-26T12:06:57.000
Cb
2
House Num
45-14
Onstname
41ST ST.
Atddismissed
No
18386
Atdid: 18386 • Atd Number: ATD-4-7278 • Bblid: 887049
Atdid
18386
Atd Number
ATD-4-7278
Bblid
887049
Inspectionid
404553
Inspect Date
2025-08-05T00:00:00.000
Atdissuedate
2025-08-20T13:58:57.000
Cb
13
House Num
136-31
Onstname
222ND ST.
Atddismissed
No
10868
Atdid: 10868 • Atd Number: ATD-3-4239 • Bblid: 359531
Atdid
10868
Atd Number
ATD-3-4239
Bblid
359531
Inspectionid
343499
Inspect Date
2022-08-25T00:00:00.000
Atdissuedate
2022-09-12T12:29:04.000
Cb
4
House Num
128
Onstname
CORNELIA ST.
Atddismissed
No
8538
Atdid: 8538 • Atd Number: ATD-3-3121 • Bblid: 302769
Atdid
8538
Atd Number
ATD-3-3121
Bblid
302769
Inspectionid
330261
Inspect Date
2021-12-01T00:00:00.000
Atdissuedate
2021-12-06T11:04:55.000
Cb
16
House Num
726
Onstname
DECATUR ST.
Atddismissed
No
14609
Atdid: 14609 • Atd Number: ATD-3-6046 • Bblid: 486082
Atdid
14609
Atd Number
ATD-3-6046
Bblid
486082
Inspectionid
378513
Inspect Date
2024-05-29T00:00:00.000
Atdissuedate
2024-06-17T13:07:58.000
Cb
15
House Num
1874
Onstname
E. 29TH ST.
Atddismissed
No
17088
Atdid: 17088 • Atd Number: ATD-3-6739 • Bblid: 308270
Atdid
17088
Atd Number
ATD-3-6739
Bblid
308270
Inspectionid
392461
Inspect Date
2023-07-18T00:00:00.000
Atdissuedate
2025-03-27T15:46:39.000
Cb
3
House Num
707
Onstname
MONROE ST.
Atddismissed
No
10439
Atdid: 10439 • Atd Number: ATD-3-3923 • Bblid: 310183
Atdid
10439
Atd Number
ATD-3-3923
Bblid
310183
Inspectionid
339285
Inspect Date
2022-07-12T00:00:00.000
Atdissuedate
2022-07-12T14:36:34.000
Cb
3
House Num
603
Onstname
MACON ST.
Atddismissed
No
14224
Atdid: 14224 • Atd Number: ATD-2-1266 • Bblid: 197499
Atdid
14224
Atd Number
ATD-2-1266
Bblid
197499
Inspectionid
374335
Inspect Date
2024-03-21T00:00:00.000
Atdissuedate
2024-03-28T09:48:22.000
Cb
11
House Num
931
Onstname
VAN NEST AVE.
Atddismissed
No
16446
Atdid: 16446 • Atd Number: ATD-4-6463 • Bblid: 735454
Atdid
16446
Atd Number
ATD-4-6463
Bblid
735454
Inspectionid
385448
Inspect Date
2024-11-27T00:00:00.000
Atdissuedate
2024-11-29T08:12:16.000
Cb
8
House Num
137-08
Onstname
73RD TER.
Atddismissed
No
12471
Atdid: 12471 • Atd Number: ATD-4-5303 • Bblid: 610740
Atdid
12471
Atd Number
ATD-4-5303
Bblid
610740
Inspectionid
357974
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T10:09:01.000
Cb
4
House Num
87-46
Onstname
BRITTON AVE.
Atddismissed
No
11796
Atdid: 11796 • Atd Number: ATD-3-4795 • Bblid: 286825
Atdid
11796
Atd Number
ATD-3-4795
Bblid
286825
Inspectionid
352903
Inspect Date
2023-03-14T00:00:00.000
Atdissuedate
2023-03-14T12:14:25.000
Cb
8
House Num
439
Onstname
PROSPECT PL.
Atddismissed
No
10221
Atdid: 10221 • Atd Number: ATD-3-3801 • Bblid: 362679
Atdid
10221
Atd Number
ATD-3-3801
Bblid
362679
Inspectionid
337336
Inspect Date
2022-06-04T00:00:00.000
Atdissuedate
2022-06-06T11:44:54.000
Cb
4
House Num
140
Onstname
MOFFAT ST.
Atddismissed
Yes
Atddismissedon
2025-08-05T13:10:35.000
16160
Atdid: 16160 • Atd Number: ATD-4-6337 • Bblid: 737440
Atdid
16160
Atd Number
ATD-4-6337
Bblid
737440
Inspectionid
383595
Inspect Date
2024-09-24T00:00:00.000
Atdissuedate
2024-10-01T10:47:29.000
Cb
8
House Num
147-22
Onstname
77TH RD.
Atddismissed
No
14541
Atdid: 14541 • Atd Number: ATD-3-6004 • Bblid: 459432
Atdid
14541
Atd Number
ATD-3-6004
Bblid
459432
Inspectionid
377883
Inspect Date
2024-05-17T00:00:00.000
Atdissuedate
2024-05-28T13:55:53.000
Cb
11
House Num
1740
Onstname
76TH ST.
Atddismissed
No
12119
Atdid: 12119 • Atd Number: ATD-3-4973 • Bblid: 504833
Atdid
12119
Atd Number
ATD-3-4973
Bblid
504833
Inspectionid
356423
Inspect Date
2022-06-24T00:00:00.000
Atdissuedate
2023-04-28T16:32:33.000
Cb
15
House Num
2075
Onstname
E. 26TH ST.
Atddismissed
Yes
Atddismissedon
2023-04-28T16:34:21.000
14700
Atdid: 14700 • Atd Number: ATD-4-6124 • Bblid: 607362
Atdid
14700
Atd Number
ATD-4-6124
Bblid
607362
Inspectionid
379113
Inspect Date
2024-06-06T00:00:00.000
Atdissuedate
2024-07-08T14:36:07.000
Cb
3
House Num
32-40
Onstname
85TH ST.
Atddismissed
No
1110
Atdid: 1110 • Atd Number: ATD-3-253 • Bblid: 345981
Atdid
1110
Atd Number
ATD-3-253
Bblid
345981
Violationid
59084
Atdissuedate
2020-08-13T00:00:00.000
Cb
1
House Num
40
Onstname
SKILLMAN AVENUE
Atddismissed
Yes
Atddismissedon
2022-05-24T10:28:53.000
14012
Atdid: 14012 • Atd Number: ATD-4-5834 • Bblid: 872571
Atdid
14012
Atd Number
ATD-4-5834
Bblid
872571
Inspectionid
372183
Inspect Date
2024-02-08T00:00:00.000
Atdissuedate
2024-02-26T10:46:26.000
Cb
12
House Num
120-19
Onstname
171ST ST.
Atddismissed
No
2287
Atdid: 2287 • Atd Number: ATD-3-1430 • Bblid: 479237
Atdid
2287
Atd Number
ATD-3-1430
Bblid
479237
Violationid
167619
Atdissuedate
2020-08-11T00:00:00.000
Cb
11
House Num
1825
Onstname
WEST 3 STREET
Atddismissed
Yes
Atddismissedon
2023-01-31T13:08:19.000
11711
Atdid: 11711 • Atd Number: ATD-4-5016 • Bblid: 577984
Atdid
11711
Atd Number
ATD-4-5016
Bblid
577984
Inspectionid
352022
Inspect Date
2023-02-13T00:00:00.000
Atdissuedate
2023-02-24T13:04:04.000
Cb
1
House Num
32-56
Onstname
32ND ST.
Atddismissed
Yes
Atddismissedon
2024-03-08T18:33:00.000
14147
Atdid: 14147 • Atd Number: ATD-3-5809 • Bblid: 448423
Atdid
14147
Atd Number
ATD-3-5809
Bblid
448423
Inspectionid
373470
Inspect Date
2024-03-12T00:00:00.000
Atdissuedate
2024-03-18T16:09:14.000
Cb
10
House Num
327
Onstname
80TH ST.
Atddismissed
No
10299
Atdid: 10299 • Atd Number: ATD-3-3848 • Bblid: 252800
Atdid
10299
Atd Number
ATD-3-3848
Bblid
252800
Inspectionid
337750
Inspect Date
2022-06-16T00:00:00.000
Atdissuedate
2022-06-17T08:16:20.000
Cb
2
House Num
50
Onstname
SIDNEY PL.
Atddismissed
No
13074
Atdid: 13074 • Atd Number: ATD-2-1207 • Bblid: 158421
Atdid
13074
Atd Number
ATD-2-1207
Bblid
158421
Inspectionid
361164
Inspect Date
2023-07-29T00:00:00.000
Atdissuedate
2023-08-01T08:51:41.000
Cb
3
House Num
1490
Onstname
BRYANT AVE.
Atddismissed
Yes
Atddismissedon
2024-02-27T17:10:46.000
13508
Atdid: 13508 • Atd Number: ATD-4-5560 • Bblid: 750593
Atdid
13508
Atd Number
ATD-4-5560
Bblid
750593
Inspectionid
364595
Inspect Date
2023-09-28T00:00:00.000
Atdissuedate
2023-09-28T13:10:16.000
Cb
11
House Num
211-29
Onstname
45TH DR.
Atddismissed
No
12521
Atdid: 12521 • Atd Number: ATD-3-5064 • Bblid: 252919
Atdid
12521
Atd Number
ATD-3-5064
Bblid
252919
Inspectionid
358218
Inspect Date
2023-06-06T00:00:00.000
Atdissuedate
2023-06-06T07:45:51.000
Cb
2
House Num
79
Onstname
STATE ST.
Atddismissed
No
13344
Atdid: 13344 • Atd Number: ATD-3-5482 • Bblid: 310700
Atdid
13344
Atd Number
ATD-3-5482
Bblid
310700
Inspectionid
362846
Inspect Date
2023-08-29T00:00:00.000
Atdissuedate
2023-08-29T11:57:41.000
Cb
3
House Num
301
Onstname
MACDONOUGH ST.
Atddismissed
No
14117
Atdid: 14117 • Atd Number: ATD-3-5799 • Bblid: 519950
Atdid
14117
Atd Number
ATD-3-5799
Bblid
519950
Inspectionid
373273
Inspect Date
2024-03-15T00:00:00.000
Atdissuedate
2024-03-15T14:32:31.000
Cb
18
House Num
1661
Onstname
E. 34TH ST.
Atddismissed
No
16212
Atdid: 16212 • Atd Number: ATD-3-6346 • Bblid: 540586
Atdid
16212
Atd Number
ATD-3-6346
Bblid
540586
Inspectionid
384086
Inspect Date
2024-10-11T00:00:00.000
Atdissuedate
2024-10-15T09:20:49.000
Cb
18
House Num
1311
Onstname
E. 91ST ST.
Atddismissed
Yes
Atddismissedon
2025-07-31T10:11:04.000
16718
Atdid: 16718 • Atd Number: ATD-5-900 • Bblid: 1028297
Atdid
16718
Atd Number
ATD-5-900
Bblid
1028297
Inspectionid
388853
Inspect Date
2024-12-31T00:00:00.000
Atdissuedate
2025-01-22T09:59:05.000
Cb
3
House Num
700
Onstname
DRUMGOOLE RD. W.
Atddismissed
No
10587
Atdid: 10587 • Atd Number: ATD-3-4015 • Bblid: 412144
Atdid
10587
Atd Number
ATD-3-4015
Bblid
412144
Inspectionid
340704
Inspect Date
2022-07-26T00:00:00.000
Atdissuedate
2022-08-01T13:58:27.000
Cb
14
House Num
466
Onstname
E. 18TH ST.
Atddismissed
No
10473
Atdid: 10473 • Atd Number: ATD-4-4732 • Bblid: 675888
Atdid
10473
Atd Number
ATD-4-4732
Bblid
675888
Inspectionid
339650
Inspect Date
2022-07-14T00:00:00.000
Atdissuedate
2022-07-14T15:08:18.000
Cb
5
House Num
84-19
Onstname
DORAN AVE.
Atddismissed
No
10121
Atdid: 10121 • Atd Number: ATD-3-3735 • Bblid: 562353
Atdid
10121
Atd Number
ATD-3-3735
Bblid
562353
Inspectionid
336769
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-23T10:27:56.000
Cb
15
House Num
2715
Onstname
FORD ST.
Atddismissed
No
10732
Atdid: 10732 • Atd Number: ATD-3-4111 • Bblid: 304869
Atdid
10732
Atd Number
ATD-3-4111
Bblid
304869
Inspectionid
342530
Inspect Date
2022-08-25T00:00:00.000
Atdissuedate
2022-09-02T13:30:30.000
Cb
3
House Num
1022
Onstname
HERKIMER ST.
Atddismissed
No
18199
Atdid: 18199 • Atd Number: ATD-3-7179 • Bblid: 251120
Atdid
18199
Atd Number
ATD-3-7179
Bblid
251120
Inspectionid
403194
Inspect Date
2025-07-22T00:00:00.000
Atdissuedate
2025-07-28T07:51:16.000
Cb
2
House Num
173
Onstname
DEAN ST.
Atddismissed
No
3817
Atdid: 3817 • Atd Number: ATD-4-447 • Bblid: 907248
Atdid
3817
Atd Number
ATD-4-447
Bblid
907248
Violationid
150958
Atdissuedate
2020-03-17T00:00:00.000
Cb
14
House Num
6-51
Onstname
HICKSVILLE ROAD
Atddismissed
No
18578
Atdid: 18578 • Atd Number: ATD-4-7362 • Bblid: 808490
Atdid
18578
Atd Number
ATD-4-7362
Bblid
808490
Inspectionid
405650
Inspect Date
2025-03-04T00:00:00.000
Atdissuedate
2025-09-11T12:20:06.000
Cb
8
House Num
170-16
Onstname
GRAND CENTRAL PKWY.
Atddismissed
No
17847
Atdid: 17847 • Atd Number: ATD-4-7044 • Bblid: 641386
Atdid
17847
Atd Number
ATD-4-7044
Bblid
641386
Inspectionid
399891
Inspect Date
2025-05-08T00:00:00.000
Atdissuedate
2025-06-11T08:31:52.000
Cb
5
House Num
61-50
Onstname
ELIOT AVE.
Atddismissed
No
10308
Atdid: 10308 • Atd Number: ATD-4-4667 • Bblid: 802098
Atdid
10308
Atd Number
ATD-4-4667
Bblid
802098
Inspectionid
337799
Inspect Date
2022-06-16T00:00:00.000
Atdissuedate
2022-06-17T10:57:56.000
Cb
10
House Num
107-34
Onstname
121ST ST.
Atddismissed
No
10143
Atdid: 10143 • Atd Number: ATD-3-3757 • Bblid: 362259
Atdid
10143
Atd Number
ATD-3-3757
Bblid
362259
Inspectionid
336812
Inspect Date
2022-05-19T00:00:00.000
Atdissuedate
2022-05-23T14:11:05.000
Cb
4
House Num
85
Onstname
COOPER ST.
Atddismissed
No
15063
Atdid: 15063 • Atd Number: ATD-1-318 • Bblid: 43075
Atdid
15063
Atd Number
ATD-1-318
Bblid
43075
Inspectionid
381967
Inspect Date
2019-03-07T00:00:00.000
Atdissuedate
2024-09-18T13:53:08.000
Cb
5
House Num
125
Onstname
E. 26TH ST.
Atddismissed
No
17804
Atdid: 17804 • Atd Number: ATD-3-7022 • Bblid: 489230
Atdid
17804
Atd Number
ATD-3-7022
Bblid
489230
Inspectionid
399254
Inspect Date
2025-05-29T00:00:00.000
Atdissuedate
2025-06-06T09:21:22.000
Cb
13
House Num
169
Onstname
BAY 47TH ST.
Atddismissed
No
16680
Atdid: 16680 • Atd Number: ATD-3-6535 • Bblid: 253937
Atdid
16680
Atd Number
ATD-3-6535
Bblid
253937
Inspectionid
388622
Inspect Date
2024-12-30T00:00:00.000
Atdissuedate
2025-01-09T10:40:53.000
Cb
6
House Num
232
Onstname
CLINTON ST.
Atddismissed
No
17733
Atdid: 17733 • Atd Number: ATD-3-7002 • Bblid: 359499
Atdid
17733
Atd Number
ATD-3-7002
Bblid
359499
Inspectionid
398352
Inspect Date
2023-10-11T00:00:00.000
Atdissuedate
2025-05-23T14:39:52.000
Cb
4
House Num
1185
Onstname
JEFFERSON AVE.
Atddismissed
No
16594
Atdid: 16594 • Atd Number: ATD-4-6519 • Bblid: 804730
Atdid
16594
Atd Number
ATD-4-6519
Bblid
804730
Inspectionid
387157
Inspect Date
2024-12-17T00:00:00.000
Atdissuedate
2024-12-23T11:37:37.000
Cb
8
House Num
139-25
Onstname
PERSHING CRES
Atddismissed
No
10887
Atdid: 10887 • Atd Number: ATD-3-4258 • Bblid: 282123
Atdid
10887
Atd Number
ATD-3-4258
Bblid
282123
Inspectionid
343577
Inspect Date
2022-09-02T00:00:00.000
Atdissuedate
2022-09-12T13:32:51.000
Cb
6
House Num
256
Onstname
GARFIELD PL.
Atddismissed
No
16802
Atdid: 16802 • Atd Number: ATD-3-6591 • Bblid: 333254
Atdid
16802
Atd Number
ATD-3-6591
Bblid
333254
Inspectionid
389609
Inspect Date
2025-02-07T00:00:00.000
Atdissuedate
2025-02-10T11:03:08.000
Cb
1
House Num
82
Onstname
HEYWARD ST.
Atddismissed
No
10225
Atdid: 10225 • Atd Number: ATD-3-3804 • Bblid: 362720
Atdid
10225
Atd Number
ATD-3-3804
Bblid
362720
Inspectionid
337345
Inspect Date
2022-06-04T00:00:00.000
Atdissuedate
2022-06-06T11:57:03.000
Cb
4
House Num
146
Onstname
MOFFAT ST.
Atddismissed
No
16133
Atdid: 16133 • Atd Number: ATD-4-6327 • Bblid: 607305
Atdid
16133
Atd Number
ATD-4-6327
Bblid
607305
Inspectionid
383340
Inspect Date
2024-09-18T00:00:00.000
Atdissuedate
2024-09-27T12:55:52.000
Cb
3
House Num
32-44
Onstname
88TH ST.
Atddismissed
No
8614
Atdid: 8614 • Atd Number: ATD-3-3153 • Bblid: 269151
Atdid
8614
Atd Number
ATD-3-3153
Bblid
269151
Inspectionid
330709
Inspect Date
2019-04-17T00:00:00.000
Atdissuedate
2021-12-14T16:33:36.000
Cb
7
House Num
421
Onstname
55TH ST.
Atddismissed
Yes
Atddismissedon
2022-05-24T09:44:33.000
11821
Atdid: 11821 • Atd Number: ATD-2-990 • Bblid: 215968
Atdid
11821
Atd Number
ATD-2-990
Bblid
215968
Inspectionid
353308
Inspect Date
2023-03-15T00:00:00.000
Atdissuedate
2023-03-20T10:59:30.000
Cb
12
House Num
3334
Onstname
FENTON AVE.
Atddismissed
No