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
18239
Atdid: 18239 • Atd Number: ATD-5-1014 • Bblid: 979288
Atdid
18239
Atd Number
ATD-5-1014
Bblid
979288
Inspectionid
403547
Inspect Date
2025-08-01T00:00:00.000
Atdissuedate
2025-08-04T12:00:18.000
Cb
1
House Num
67
Onstname
CLIFF ST.
Atddismissed
No
10095
Atdid: 10095 • Atd Number: ATD-3-3714 • Bblid: 472321
Atdid
10095
Atd Number
ATD-3-3714
Bblid
472321
Inspectionid
336457
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-16T10:54:19.000
Cb
11
House Num
2344
Onstname
62ND ST.
Atddismissed
No
9169
Atdid: 9169 • Atd Number: ATD-3-3344 • Bblid: 424436
Atdid
9169
Atd Number
ATD-3-3344
Bblid
424436
Inspectionid
332790
Inspect Date
2019-08-09T00:00:00.000
Atdissuedate
2022-02-25T15:03:02.000
Cb
12
House Num
1559
Onstname
53RD ST.
Atddismissed
No
10244
Atdid: 10244 • Atd Number: ATD-3-3823 • Bblid: 332770
Atdid
10244
Atd Number
ATD-3-3823
Bblid
332770
Inspectionid
337385
Inspect Date
2022-06-03T00:00:00.000
Atdissuedate
2022-06-06T13:34:27.000
Cb
1
House Num
110
Onstname
PENN ST.
Atddismissed
Yes
Atddismissedon
2023-02-23T10:15:39.000
17304
Atdid: 17304 • Atd Number: ATD-3-6844 • Bblid: 474538
Atdid
17304
Atd Number
ATD-3-6844
Bblid
474538
Inspectionid
394118
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-10T16:04:18.000
Cb
11
House Num
1531
Onstname
W. 10TH ST.
Atddismissed
No
14811
Atdid: 14811 • Atd Number: ATD-3-6150 • Bblid: 317349
Atdid
14811
Atd Number
ATD-3-6150
Bblid
317349
Inspectionid
379886
Inspect Date
2024-07-23T00:00:00.000
Atdissuedate
2024-07-29T10:34:08.000
Cb
3
House Num
390
Onstname
MONROE ST.
Atddismissed
No
15082
Atdid: 15082 • Atd Number: ATD-3-6293 • Bblid: 487912
Atdid
15082
Atd Number
ATD-3-6293
Bblid
487912
Inspectionid
382113
Inspect Date
2024-09-17T00:00:00.000
Atdissuedate
2024-09-23T11:54:55.000
Cb
11
House Num
148
Onstname
BAY 40TH ST.
Atddismissed
No
9585
Atdid: 9585 • Atd Number: ATD-5-636 • Bblid: 959117
Atdid
9585
Atd Number
ATD-5-636
Bblid
959117
Inspectionid
333697
Inspect Date
2018-05-15T00:00:00.000
Atdissuedate
2022-03-11T17:33:34.000
Cb
1
House Num
36
Onstname
SOUTH AVE.
Atddismissed
No
9097
Atdid: 9097 • Atd Number: ATD-4-4146 • Bblid: 638896
Atdid
9097
Atd Number
ATD-4-4146
Bblid
638896
Inspectionid
332648
Inspect Date
2019-05-29T00:00:00.000
Atdissuedate
2022-02-22T13:01:40.000
Cb
5
House Num
59-79
Onstname
GRAND AVE.
Atddismissed
No
16750
Atdid: 16750 • Atd Number: ATD-4-6592 • Bblid: 788801
Atdid
16750
Atd Number
ATD-4-6592
Bblid
788801
Inspectionid
389054
Inspect Date
2025-01-09T00:00:00.000
Atdissuedate
2025-01-29T11:04:17.000
Cb
9
House Num
84-06
Onstname
124TH ST.
Atddismissed
No
11854
Atdid: 11854 • Atd Number: ATD-3-4828 • Bblid: 437818
Atdid
11854
Atd Number
ATD-3-4828
Bblid
437818
Inspectionid
353549
Inspect Date
2021-05-20T00:00:00.000
Atdissuedate
2023-03-22T10:35:21.000
Cb
10
House Num
1161
Onstname
63RD ST.
Atddismissed
No
11177
Atdid: 11177 • Atd Number: ATD-3-4495 • Bblid: 391709
Atdid
11177
Atd Number
ATD-3-4495
Bblid
391709
Inspectionid
346108
Inspect Date
2022-10-12T00:00:00.000
Atdissuedate
2022-10-17T10:08:53.000
Cb
17
House Num
54
Onstname
E. 55TH ST.
Atddismissed
No
16701
Atdid: 16701 • Atd Number: ATD-3-6547 • Bblid: 391116
Atdid
16701
Atd Number
ATD-3-6547
Bblid
391116
Inspectionid
388713
Inspect Date
2024-08-22T00:00:00.000
Atdissuedate
2025-01-15T11:59:59.000
Cb
17
House Num
126
Onstname
E. 51ST ST.
Atddismissed
No
12391
Atdid: 12391 • Atd Number: ATD-4-5257 • Bblid: 604431
Atdid
12391
Atd Number
ATD-4-5257
Bblid
604431
Inspectionid
357548
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:49:38.000
Cb
2
House Num
72-17
Onstname
QUEENS BLVD.
Atddismissed
No
17118
Atdid: 17118 • Atd Number: ATD-3-6764 • Bblid: 477778
Atdid
17118
Atd Number
ATD-3-6764
Bblid
477778
Inspectionid
392516
Inspect Date
2024-01-10T00:00:00.000
Atdissuedate
2025-03-28T14:40:57.000
Cb
15
House Num
1784
Onstname
E. 2ND ST.
Atddismissed
No
14457
Atdid: 14457 • Atd Number: ATD-4-6035 • Bblid: 860896
Atdid
14457
Atd Number
ATD-4-6035
Bblid
860896
Inspectionid
377267
Inspect Date
2024-03-12T00:00:00.000
Atdissuedate
2024-05-13T11:24:49.000
Cb
12
House Num
111-73
Onstname
145TH ST.
Atddismissed
No
14160
Atdid: 14160 • Atd Number: ATD-3-5822 • Bblid: 554720
Atdid
14160
Atd Number
ATD-3-5822
Bblid
554720
Inspectionid
373529
Inspect Date
2024-03-19T00:00:00.000
Atdissuedate
2024-03-19T09:23:09.000
Cb
18
House Num
2292
Onstname
NATIONAL DR.
Atddismissed
No
13498
Atdid: 13498 • Atd Number: ATD-3-5560 • Bblid: 444930
Atdid
13498
Atd Number
ATD-3-5560
Bblid
444930
Inspectionid
364524
Inspect Date
2023-07-18T00:00:00.000
Atdissuedate
2023-09-28T10:10:45.000
Cb
10
House Num
530
Onstname
72ND ST.
Atddismissed
No
11233
Atdid: 11233 • Atd Number: ATD-3-4539 • Bblid: 302671
Atdid
11233
Atd Number
ATD-3-4539
Bblid
302671
Inspectionid
346783
Inspect Date
2022-10-19T00:00:00.000
Atdissuedate
2022-10-24T10:31:22.000
Cb
16
House Num
696
Onstname
DECATUR ST.
Atddismissed
No
12488
Atdid: 12488 • Atd Number: ATD-4-5314 • Bblid: 782893
Atdid
12488
Atd Number
ATD-4-5314
Bblid
782893
Inspectionid
358032
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T15:59:51.000
Cb
9
House Num
94-05
Onstname
85 STREET
Atddismissed
No
18555
Atdid: 18555 • Atd Number: ATD-4-7360 • Bblid: 589030
Atdid
18555
Atd Number
ATD-4-7360
Bblid
589030
Inspectionid
405559
Inspect Date
2025-07-18T00:00:00.000
Atdissuedate
2025-09-09T10:47:31.000
Cb
1
House Num
25-43
Onstname
CRESCENT ST.
Atddismissed
No
16603
Atdid: 16603 • Atd Number: ATD-3-6513 • Bblid: 297908
Atdid
16603
Atd Number
ATD-3-6513
Bblid
297908
Inspectionid
387186
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2024-12-24T08:56:21.000
Cb
8
House Num
1221
Onstname
LINCOLN PL.
Atddismissed
No
12166
Atdid: 12166 • Atd Number: ATD-3-4996 • Bblid: 396544
Atdid
12166
Atd Number
ATD-3-4996
Bblid
396544
Inspectionid
356737
Inspect Date
2023-04-19T00:00:00.000
Atdissuedate
2023-05-08T10:40:08.000
Cb
17
House Num
672
Onstname
E. 91ST ST.
Atddismissed
No
12909
Atdid: 12909 • Atd Number: ATD-3-5196 • Bblid: 432099
Atdid
12909
Atd Number
ATD-3-5196
Bblid
432099
Inspectionid
360327
Inspect Date
2023-07-20T00:00:00.000
Atdissuedate
2023-07-20T09:55:02.000
Cb
12
House Num
1430
Onstname
44TH ST.
Atddismissed
No
11406
Atdid: 11406 • Atd Number: ATD-4-4889 • Bblid: 785872
Atdid
11406
Atd Number
ATD-4-4889
Bblid
785872
Inspectionid
348370
Inspect Date
2022-10-20T00:00:00.000
Atdissuedate
2022-11-18T11:56:45.000
Cb
10
House Num
107-29
Onstname
77TH ST.
Atddismissed
No
10794
Atdid: 10794 • Atd Number: ATD-3-4171 • Bblid: 260822
Atdid
10794
Atd Number
ATD-3-4171
Bblid
260822
Inspectionid
342974
Inspect Date
2022-08-27T00:00:00.000
Atdissuedate
2022-09-08T09:58:49.000
Cb
6
House Num
84
Onstname
2ND ST.
Atddismissed
No
18232
Atdid: 18232 • Atd Number: ATD-2-1437 • Bblid: 147136
Atdid
18232
Atd Number
ATD-2-1437
Bblid
147136
Violationid
303805
Reinspectionid
39676
Inspect Date
2025-08-04T10:29:20.000
Atdissuedate
2025-08-04T10:29:20.000
Cb
1
House Num
847
Onstname
JACKSON AVENUE
Atddismissed
No
16913
Atdid: 16913 • Atd Number: ATD-3-6629 • Bblid: 443668
Atdid
16913
Atd Number
ATD-3-6629
Bblid
443668
Inspectionid
390971
Inspect Date
2025-03-11T00:00:00.000
Atdissuedate
2025-03-13T07:59:32.000
Cb
10
House Num
84
Onstname
71ST ST.
Atddismissed
No
18248
Atdid: 18248 • Atd Number: ATD-3-7202 • Bblid: 298623
Atdid
18248
Atd Number
ATD-3-7202
Bblid
298623
Inspectionid
403591
Inspect Date
2025-03-26T00:00:00.000
Atdissuedate
2025-08-05T09:36:21.000
Cb
9
House Num
1618
Onstname
UNION ST.
Atddismissed
No
9937
Atdid: 9937 • Atd Number: ATD-4-4516 • Bblid: 780711
Atdid
9937
Atd Number
ATD-4-4516
Bblid
780711
Inspectionid
335340
Inspect Date
2021-08-04T00:00:00.000
Atdissuedate
2022-04-21T12:08:19.000
Cb
9
House Num
87-17
Onstname
91ST AVE.
Atddismissed
No
14968
Atdid: 14968 • Atd Number: ATD-4-6247 • Bblid: 760870
Atdid
14968
Atd Number
ATD-4-6247
Bblid
760870
Inspectionid
381082
Inspect Date
2024-08-13T00:00:00.000
Atdissuedate
2024-08-26T14:31:17.000
Cb
13
House Num
87-10
Onstname
239TH ST.
Atddismissed
No
11185
Atdid: 11185 • Atd Number: ATD-3-4503 • Bblid: 456237
Atdid
11185
Atd Number
ATD-3-4503
Bblid
456237
Inspectionid
346168
Inspect Date
2022-10-12T00:00:00.000
Atdissuedate
2022-10-17T11:04:11.000
Cb
11
House Num
1675
Onstname
72ND ST.
Atddismissed
No
8588
Atdid: 8588 • Atd Number: ATD-5-580 • Bblid: 930551
Atdid
8588
Atd Number
ATD-5-580
Bblid
930551
Inspectionid
330528
Inspect Date
2019-07-29T00:00:00.000
Atdissuedate
2021-12-10T10:31:40.000
Cb
1
House Num
52
Onstname
WALDRON AVE.
Atddismissed
No
11137
Atdid: 11137 • Atd Number: ATD-3-4468 • Bblid: 546700
Atdid
11137
Atd Number
ATD-3-4468
Bblid
546700
Inspectionid
345716
Inspect Date
2022-10-12T00:00:00.000
Atdissuedate
2022-10-13T09:59:56.000
Cb
18
House Num
7304
Onstname
AVENUE M.
Atddismissed
No
14845
Atdid: 14845 • Atd Number: ATD-3-6166 • Bblid: 504626
Atdid
14845
Atd Number
ATD-3-6166
Bblid
504626
Inspectionid
380110
Inspect Date
2024-08-02T00:00:00.000
Atdissuedate
2024-08-05T10:26:02.000
Cb
15
House Num
2127
Onstname
E. 21ST ST.
Atddismissed
No
5848
Atdid: 5848 • Atd Number: ATD-4-2209 • Bblid: 805847
Atdid
5848
Atd Number
ATD-4-2209
Bblid
805847
Violationid
234153
Atdissuedate
2020-05-26T00:00:00.000
Cb
8
House Num
147-23
Onstname
84 AVENUE
Atddismissed
Yes
Atddismissedon
2025-08-04T12:42:28.000
12599
Atdid: 12599 • Atd Number: ATD-3-5081 • Bblid: 380271
Atdid
12599
Atd Number
ATD-3-5081
Bblid
380271
Inspectionid
358628
Inspect Date
2023-06-15T00:00:00.000
Atdissuedate
2023-06-15T11:33:02.000
Cb
5
House Num
430
Onstname
RIDGEWOOD AVE.
Atddismissed
Yes
Atddismissedon
2023-06-15T11:33:21.000
11327
Atdid: 11327 • Atd Number: ATD-1-216 • Bblid: 114359
Atdid
11327
Atd Number
ATD-1-216
Bblid
114359
Inspectionid
347488
Inspect Date
2022-11-02T00:00:00.000
Atdissuedate
2022-11-02T14:32:04.000
Cb
11
House Num
1447
Onstname
5TH AVE.
Atddismissed
No
17849
Atdid: 17849 • Atd Number: ATD-4-7046 • Bblid: 783660
Atdid
17849
Atd Number
ATD-4-7046
Bblid
783660
Inspectionid
399916
Inspect Date
2025-05-15T00:00:00.000
Atdissuedate
2025-06-11T11:18:13.000
Cb
9
House Num
97-23
Onstname
84TH ST.
Atddismissed
No
10183
Atdid: 10183 • Atd Number: ATD-4-4614 • Bblid: 735017
Atdid
10183
Atd Number
ATD-4-4614
Bblid
735017
Inspectionid
337063
Inspect Date
2022-05-12T00:00:00.000
Atdissuedate
2022-05-27T09:07:45.000
Cb
8
House Num
136-26
Onstname
72ND AVE.
Atddismissed
No
16331
Atdid: 16331 • Atd Number: ATD-3-6404 • Bblid: 291421
Atdid
16331
Atd Number
ATD-3-6404
Bblid
291421
Inspectionid
384686
Inspect Date
2023-06-30T00:00:00.000
Atdissuedate
2024-11-02T14:11:30.000
Cb
8
House Num
947
Onstname
SAINT JOHNS PL.
Atddismissed
No
13349
Atdid: 13349 • Atd Number: ATD-3-5485 • Bblid: 375706
Atdid
13349
Atd Number
ATD-3-5485
Bblid
375706
Inspectionid
362881
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-08-29T15:02:39.000
Cb
5
House Num
159
Onstname
ATKINS AVE.
Atddismissed
No
11608
Atdid: 11608 • Atd Number: ATD-3-4711 • Bblid: 278383
Atdid
11608
Atd Number
ATD-3-4711
Bblid
278383
Inspectionid
350538
Inspect Date
2023-01-07T00:00:00.000
Atdissuedate
2023-01-19T11:41:28.000
Cb
6
House Num
268
Onstname
7TH ST.
Atddismissed
No
17529
Atdid: 17529 • Atd Number: ATD-4-6842 • Bblid: 579887
Atdid
17529
Atd Number
ATD-4-6842
Bblid
579887
Inspectionid
396083
Inspect Date
2025-05-02T00:00:00.000
Atdissuedate
2025-05-05T09:17:52.000
Cb
1
House Num
30-39
Onstname
35TH ST.
Atddismissed
No
12579
Atdid: 12579 • Atd Number: ATD-2-1156 • Bblid: 149098
Atdid
12579
Atd Number
ATD-2-1156
Bblid
149098
Inspectionid
358580
Inspect Date
2023-06-15T00:00:00.000
Atdissuedate
2023-06-15T10:00:46.000
Cb
2
House Num
924
Onstname
REV JAMES POLITE AVE
Atddismissed
No
12751
Atdid: 12751 • Atd Number: ATD-3-5107 • Bblid: 420029
Atdid
12751
Atd Number
ATD-3-5107
Bblid
420029
Violationid
279169
Reinspectionid
35662
Inspect Date
2023-07-05T11:19:22.000
Atdissuedate
2023-07-05T11:19:22.000
Cb
12
House Num
536
Onstname
EAST 5 STREET
Atddismissed
No
14589
Atdid: 14589 • Atd Number: ATD-4-6090 • Bblid: 690875
Atdid
14589
Atd Number
ATD-4-6090
Bblid
690875
Inspectionid
378386
Inspect Date
2024-06-05T00:00:00.000
Atdissuedate
2024-06-13T09:52:44.000
Cb
7
House Num
147-11
Onstname
17TH RD.
Atddismissed
No
14396
Atdid: 14396 • Atd Number: ATD-4-6013 • Bblid: 677765
Atdid
14396
Atd Number
ATD-4-6013
Bblid
677765
Inspectionid
376681
Inspect Date
2024-05-06T00:00:00.000
Atdissuedate
2024-05-06T11:28:05.000
Cb
5
House Num
87-35
Onstname
81ST AVE.
Atddismissed
No
17651
Atdid: 17651 • Atd Number: ATD-4-6920 • Bblid: 761135
Atdid
17651
Atd Number
ATD-4-6920
Bblid
761135
Inspectionid
397242
Inspect Date
2025-02-11T00:00:00.000
Atdissuedate
2025-05-16T11:01:47.000
Cb
13
House Num
241-17
Onstname
88TH AVE.
Atddismissed
No
11678
Atdid: 11678 • Atd Number: ATD-4-4998 • Bblid: 632358
Atdid
11678
Atd Number
ATD-4-4998
Bblid
632358
Inspectionid
351752
Inspect Date
2023-02-16T00:00:00.000
Atdissuedate
2023-02-16T17:58:15.000
Cb
5
House Num
53-155
Onstname
63RD ST.
Atddismissed
No