Ask NYC Browse All Data Public Safety Transportation Health Buildings

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
16537
Atdid: 16537 • Atd Number: ATD-3-6475 • Bblid: 355794
Atdid
16537
Atd Number
ATD-3-6475
Bblid
355794
Inspectionid
386449
Inspect Date
2024-12-04T00:00:00.000
Atdissuedate
2024-12-18T07:52:51.000
Cb
4
House Num
1065A
Onstname
GREENE AVE.
Atddismissed
No
18124
Atdid: 18124 • Atd Number: ATD-5-1007 • Bblid: 1012171
Atdid
18124
Atd Number
ATD-5-1007
Bblid
1012171
Inspectionid
402690
Inspect Date
2025-07-17T00:00:00.000
Atdissuedate
2025-07-18T12:22:01.000
Cb
3
House Num
284
Onstname
MONTREAL AVE.
Atddismissed
No
14718
Atdid: 14718 • Atd Number: ATD-4-6136 • Bblid: 631844
Atdid
14718
Atd Number
ATD-4-6136
Bblid
631844
Inspectionid
379254
Inspect Date
2024-06-03T00:00:00.000
Atdissuedate
2024-07-11T12:23:12.000
Cb
2
House Num
51-43
Onstname
64TH ST.
Atddismissed
No
11503
Atdid: 11503 • Atd Number: ATD-3-4701 • Bblid: 259147
Atdid
11503
Atd Number
ATD-3-4701
Bblid
259147
Inspectionid
349254
Inspect Date
2022-11-29T00:00:00.000
Atdissuedate
2022-12-13T09:25:01.000
Cb
6
House Num
37
Onstname
DOUGLASS ST.
Atddismissed
No
12151
Atdid: 12151 • Atd Number: ATD-3-4984 • Bblid: 338518
Atdid
12151
Atd Number
ATD-3-4984
Bblid
338518
Violationid
280281
Reinspectionid
33576
Inspect Date
2023-05-04T12:54:21.000
Atdissuedate
2023-05-04T12:54:21.000
Cb
1
House Num
150
Onstname
SOUTH 2 STREET
Atddismissed
Yes
Atddismissedon
2023-09-29T14:22:56.000
10689
Atdid: 10689 • Atd Number: ATD-4-4792 • Bblid: 774280
Atdid
10689
Atd Number
ATD-4-4792
Bblid
774280
Inspectionid
342061
Inspect Date
2022-03-02T00:00:00.000
Atdissuedate
2022-08-26T12:18:08.000
Cb
13
House Num
82-50
Onstname
261ST ST.
Atddismissed
No
16868
Atdid: 16868 • Atd Number: ATD-4-6635 • Bblid: 820942
Atdid
16868
Atd Number
ATD-4-6635
Bblid
820942
Inspectionid
390395
Inspect Date
2025-02-28T00:00:00.000
Atdissuedate
2025-03-06T09:39:29.000
Cb
12
House Num
189-02
Onstname
114TH DR.
Atddismissed
No
18643
Atdid: 18643 • Atd Number: ATD-4-7392 • Bblid: 750775
Atdid
18643
Atd Number
ATD-4-7392
Bblid
750775
Inspectionid
406262
Inspect Date
2025-09-10T00:00:00.000
Atdissuedate
2025-09-22T10:31:58.000
Cb
11
House Num
46-35
Onstname
206TH ST.
Atddismissed
No
10983
Atdid: 10983 • Atd Number: ATD-3-4336 • Bblid: 412575
Atdid
10983
Atd Number
ATD-3-4336
Bblid
412575
Inspectionid
344416
Inspect Date
2022-09-21T00:00:00.000
Atdissuedate
2022-09-23T13:50:20.000
Cb
17
House Num
333
Onstname
E. 25TH ST.
Atddismissed
No
10609
Atdid: 10609 • Atd Number: ATD-4-4768 • Bblid: 734268
Atdid
10609
Atd Number
ATD-4-4768
Bblid
734268
Inspectionid
340964
Inspect Date
2022-08-05T00:00:00.000
Atdissuedate
2022-08-05T15:10:47.000
Cb
8
House Num
144-63
Onstname
68TH AVE.
Atddismissed
No
13751
Atdid: 13751 • Atd Number: ATD-4-5664 • Bblid: 901584
Atdid
13751
Atd Number
ATD-4-5664
Bblid
901584
Inspectionid
369129
Inspect Date
2023-12-06T00:00:00.000
Atdissuedate
2023-12-07T15:09:53.000
Cb
10
House Num
155-42
Onstname
100TH ST.
Atddismissed
No
9839
Atdid: 9839 • Atd Number: ATD-4-4458 • Bblid: 918134
Atdid
9839
Atd Number
ATD-4-4458
Bblid
918134
Inspectionid
334755
Inspect Date
2022-03-08T00:00:00.000
Atdissuedate
2022-04-08T14:10:35.000
Cb
14
House Num
167
Onstname
BEACH 126TH ST.
Atddismissed
No
14434
Atdid: 14434 • Atd Number: ATD-3-5968 • Bblid: 277802
Atdid
14434
Atd Number
ATD-3-5968
Bblid
277802
Inspectionid
377110
Inspect Date
2024-04-24T00:00:00.000
Atdissuedate
2024-05-08T13:37:42.000
Cb
6
House Num
439
Onstname
6TH ST.
Atddismissed
No
9043
Atdid: 9043 • Atd Number: ATD-4-4104 • Bblid: 761156
Atdid
9043
Atd Number
ATD-4-4104
Bblid
761156
Inspectionid
332452
Inspect Date
2021-12-29T00:00:00.000
Atdissuedate
2022-02-14T14:35:56.000
Cb
13
House Num
88-03
Onstname
MOLINE ST.
Atddismissed
No
12536
Atdid: 12536 • Atd Number: ATD-3-5066 • Bblid: 431686
Atdid
12536
Atd Number
ATD-3-5066
Bblid
431686
Inspectionid
358373
Inspect Date
2023-06-01T00:00:00.000
Atdissuedate
2023-06-12T11:33:34.000
Cb
12
House Num
1342
Onstname
43RD ST.
Atddismissed
No
13549
Atdid: 13549 • Atd Number: ATD-4-5588 • Bblid: 724885
Atdid
13549
Atd Number
ATD-4-5588
Bblid
724885
Inspectionid
364985
Inspect Date
2023-10-06T00:00:00.000
Atdissuedate
2023-10-06T10:29:06.000
Cb
11
House Num
26-19
Onstname
CLEARVIEW EXPY.
Atddismissed
No
6775
Atdid: 6775 • Atd Number: ATD-4-3136 • Bblid: 799828
Atdid
6775
Atd Number
ATD-4-3136
Bblid
799828
Violationid
253567
Atdissuedate
2020-06-24T00:00:00.000
Cb
10
House Num
10727
Onstname
111 STREET
Atddismissed
Yes
Atddismissedon
2021-12-29T11:00:26.000
13113
Atdid: 13113 • Atd Number: ATD-3-5326 • Bblid: 422738
Atdid
13113
Atd Number
ATD-3-5326
Bblid
422738
Inspectionid
361417
Inspect Date
2023-08-03T00:00:00.000
Atdissuedate
2023-08-03T11:58:42.000
Cb
12
House Num
1516
Onstname
46TH ST.
Atddismissed
No
14015
Atdid: 14015 • Atd Number: ATD-4-5837 • Bblid: 835054
Atdid
14015
Atd Number
ATD-4-5837
Bblid
835054
Inspectionid
372198
Inspect Date
2024-02-21T00:00:00.000
Atdissuedate
2024-02-26T10:52:58.000
Cb
13
House Num
208-16
Onstname
111TH AVE.
Atddismissed
No
16939
Atdid: 16939 • Atd Number: ATD-4-6652 • Bblid: 875954
Atdid
16939
Atd Number
ATD-4-6652
Bblid
875954
Inspectionid
391429
Inspect Date
2025-03-11T00:00:00.000
Atdissuedate
2025-03-17T10:03:55.000
Cb
12
House Num
140-40
Onstname
173RD ST.
Atddismissed
No
17913
Atdid: 17913 • Atd Number: ATD-2-1419 • Bblid: 240722
Atdid
17913
Atd Number
ATD-2-1419
Bblid
240722
Inspectionid
400567
Inspect Date
2025-05-15T00:00:00.000
Atdissuedate
2025-06-17T14:42:32.000
Cb
10
House Num
65
Onstname
BUCKLEY ST.
Atddismissed
No
13316
Atdid: 13316 • Atd Number: ATD-4-5513 • Bblid: 578157
Atdid
13316
Atd Number
ATD-4-5513
Bblid
578157
Inspectionid
362547
Inspect Date
2023-08-25T00:00:00.000
Atdissuedate
2023-08-25T11:00:02.000
Cb
1
House Num
34-47
Onstname
30TH ST.
Atddismissed
No
10507
Atdid: 10507 • Atd Number: ATD-4-4739 • Bblid: 717142
Atdid
10507
Atd Number
ATD-4-4739
Bblid
717142
Inspectionid
340044
Inspect Date
2022-07-13T00:00:00.000
Atdissuedate
2022-07-19T11:56:28.000
Cb
7
House Num
47-28
Onstname
167TH ST.
Atddismissed
No
10125
Atdid: 10125 • Atd Number: ATD-3-3739 • Bblid: 562345
Atdid
10125
Atd Number
ATD-3-3739
Bblid
562345
Inspectionid
336778
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-05-23T10:59:23.000
Cb
15
House Num
2729
Onstname
FORD ST.
Atddismissed
No
9561
Atdid: 9561 • Atd Number: ATD-3-3552 • Bblid: 310856
Atdid
9561
Atd Number
ATD-3-3552
Bblid
310856
Inspectionid
333649
Inspect Date
2021-08-27T00:00:00.000
Atdissuedate
2022-03-11T09:37:45.000
Cb
3
House Num
218
Onstname
PATCHEN AVE.
Atddismissed
No
12367
Atdid: 12367 • Atd Number: ATD-4-5233 • Bblid: 634221
Atdid
12367
Atd Number
ATD-4-5233
Bblid
634221
Inspectionid
357524
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:34:04.000
Cb
2
House Num
69-20
Onstname
QUEENS BLVD.
Atddismissed
No
12202
Atdid: 12202 • Atd Number: ATD-2-1054 • Bblid: 166843
Atdid
12202
Atd Number
ATD-2-1054
Bblid
166843
Inspectionid
356844
Inspect Date
2023-05-09T00:00:00.000
Atdissuedate
2023-05-09T15:06:02.000
Cb
7
House Num
2843
Onstname
GRAND CONCOURSE
Atddismissed
No
17614
Atdid: 17614 • Atd Number: ATD-4-6885 • Bblid: 648929
Atdid
17614
Atd Number
ATD-4-6885
Bblid
648929
Inspectionid
397096
Inspect Date
2025-05-03T00:00:00.000
Atdissuedate
2025-05-15T11:26:39.000
Cb
5
House Num
62-31
Onstname
82ND ST.
Atddismissed
No
14215
Atdid: 14215 • Atd Number: ATD-4-5917 • Bblid: 788227
Atdid
14215
Atd Number
ATD-4-5917
Bblid
788227
Inspectionid
374049
Inspect Date
2024-03-07T00:00:00.000
Atdissuedate
2024-03-22T14:54:36.000
Cb
9
House Num
84-52
Onstname
116TH ST.
Atddismissed
No
10282
Atdid: 10282 • Atd Number: ATD-3-3839 • Bblid: 283139
Atdid
10282
Atd Number
ATD-3-3839
Bblid
283139
Inspectionid
337648
Inspect Date
2022-05-10T00:00:00.000
Atdissuedate
2022-06-13T13:03:25.000
Cb
6
House Num
462A
Onstname
8TH ST.
Atddismissed
No
14307
Atdid: 14307 • Atd Number: ATD-4-5968 • Bblid: 656418
Atdid
14307
Atd Number
ATD-4-5968
Bblid
656418
Inspectionid
375764
Inspect Date
2024-04-22T00:00:00.000
Atdissuedate
2024-04-22T11:58:25.000
Cb
6
House Num
68-48
Onstname
ALDERTON ST.
Atddismissed
No
17884
Atdid: 17884 • Atd Number: ATD-4-7071 • Bblid: 720463
Atdid
17884
Atd Number
ATD-4-7071
Bblid
720463
Inspectionid
400305
Inspect Date
2025-06-12T00:00:00.000
Atdissuedate
2025-06-13T09:50:34.000
Cb
7
House Num
166-27
Onstname
21ST AVE.
Atddismissed
No
17124
Atdid: 17124 • Atd Number: ATD-4-6689 • Bblid: 836405
Atdid
17124
Atd Number
ATD-4-6689
Bblid
836405
Inspectionid
392532
Inspect Date
2025-03-28T00:00:00.000
Atdissuedate
2025-03-28T15:22:03.000
Cb
12
House Num
113-07
Onstname
205TH ST.
Atddismissed
No
14763
Atdid: 14763 • Atd Number: ATD-4-6158 • Bblid: 567977
Atdid
14763
Atd Number
ATD-4-6158
Bblid
567977
Inspectionid
379525
Inspect Date
2024-07-16T00:00:00.000
Atdissuedate
2024-07-18T11:22:35.000
Cb
2
House Num
45-32
Onstname
11TH ST.
Atddismissed
No
13696
Atdid: 13696 • Atd Number: ATD-4-5637 • Bblid: 862268
Atdid
13696
Atd Number
ATD-4-5637
Bblid
862268
Inspectionid
367672
Inspect Date
2023-11-15T00:00:00.000
Atdissuedate
2023-11-16T15:55:51.000
Cb
12
House Num
115-48
Onstname
145TH ST.
Atddismissed
No
11148
Atdid: 11148 • Atd Number: ATD-4-4844 • Bblid: 632639
Atdid
11148
Atd Number
ATD-4-4844
Bblid
632639
Inspectionid
345916
Inspect Date
2022-10-14T00:00:00.000
Atdissuedate
2022-10-14T11:55:35.000
Cb
5
House Num
53-28
Onstname
64TH ST.
Atddismissed
No
17043
Atdid: 17043 • Atd Number: ATD-3-6702 • Bblid: 548309
Atdid
17043
Atd Number
ATD-3-6702
Bblid
548309
Inspectionid
392348
Inspect Date
2025-03-26T00:00:00.000
Atdissuedate
2025-03-26T14:07:05.000
Cb
18
House Num
1439
Onstname
E. 70TH ST.
Atddismissed
No
13391
Atdid: 13391 • Atd Number: ATD-5-816 • Bblid: 947652
Atdid
13391
Atd Number
ATD-5-816
Bblid
947652
Inspectionid
363364
Inspect Date
2023-09-09T00:00:00.000
Atdissuedate
2023-09-11T17:50:11.000
Cb
2
House Num
192
Onstname
ARDMORE AVE.
Atddismissed
No
8782
Atdid: 8782 • Atd Number: ATD-4-3959 • Bblid: 579914
Atdid
8782
Atd Number
ATD-4-3959
Bblid
579914
Inspectionid
331246
Inspect Date
2021-10-27T00:00:00.000
Atdissuedate
2021-12-29T14:39:28.000
Cb
1
House Num
30-26
Onstname
36TH ST.
Atddismissed
No
13341
Atdid: 13341 • Atd Number: ATD-2-1232 • Bblid: 171350
Atdid
13341
Atd Number
ATD-2-1232
Bblid
171350
Inspectionid
362826
Inspect Date
2023-08-29T00:00:00.000
Atdissuedate
2023-08-29T10:41:06.000
Cb
9
House Num
1780
Onstname
LACOMBE AVE.
Atddismissed
No
15010
Atdid: 15010 • Atd Number: ATD-3-6250 • Bblid: 333597
Atdid
15010
Atd Number
ATD-3-6250
Bblid
333597
Inspectionid
381568
Inspect Date
2024-08-28T00:00:00.000
Atdissuedate
2024-09-09T13:08:53.000
Cb
1
House Num
235
Onstname
LYNCH ST.
Atddismissed
No
11695
Atdid: 11695 • Atd Number: ATD-4-5006 • Bblid: 858259
Atdid
11695
Atd Number
ATD-4-5006
Bblid
858259
Inspectionid
351878
Inspect Date
2023-02-09T00:00:00.000
Atdissuedate
2023-02-23T11:32:55.000
Cb
10
House Num
133-13
Onstname
131ST ST.
Atddismissed
No
18237
Atdid: 18237 • Atd Number: ATD-3-7200 • Bblid: 550991
Atdid
18237
Atd Number
ATD-3-7200
Bblid
550991
Inspectionid
403531
Inspect Date
2025-07-10T00:00:00.000
Atdissuedate
2025-08-04T10:35:36.000
Cb
18
House Num
1821
Onstname
E. 33RD ST.
Atddismissed
No
12801
Atdid: 12801 • Atd Number: ATD-3-5135 • Bblid: 484762
Atdid
12801
Atd Number
ATD-3-5135
Bblid
484762
Inspectionid
359729
Inspect Date
2023-07-01T00:00:00.000
Atdissuedate
2023-07-10T15:31:58.000
Cb
15
House Num
1724
Onstname
E. 23RD ST.
Atddismissed
No
14495
Atdid: 14495 • Atd Number: ATD-4-6058 • Bblid: 746042
Atdid
14495
Atd Number
ATD-4-6058
Bblid
746042
Inspectionid
377502
Inspect Date
2024-05-04T00:00:00.000
Atdissuedate
2024-05-20T10:23:18.000
Cb
8
House Num
82-59
Onstname
166TH ST.
Atddismissed
No
18551
Atdid: 18551 • Atd Number: ATD-4-7356 • Bblid: 715337
Atdid
18551
Atd Number
ATD-4-7356
Bblid
715337
Inspectionid
405532
Inspect Date
2025-06-04T00:00:00.000
Atdissuedate
2025-09-08T15:50:36.000
Cb
7
House Num
161-01
Onstname
LABURNUM AVE.
Atddismissed
No
16516
Atdid: 16516 • Atd Number: ATD-3-6455 • Bblid: 282533
Atdid
16516
Atd Number
ATD-3-6455
Bblid
282533
Inspectionid
386321
Inspect Date
2024-12-13T00:00:00.000
Atdissuedate
2024-12-16T13:31:56.000
Cb
6
House Num
591
Onstname
2ND ST.
Atddismissed
No
9429
Atdid: 9429 • Atd Number: ATD-4-4229 • Bblid: 588363
Atdid
9429
Atd Number
ATD-4-4229
Bblid
588363
Inspectionid
333236
Inspect Date
2022-03-04T00:00:00.000
Atdissuedate
2022-03-04T13:26:07.000
Cb
1
House Num
20-32
Onstname
29TH ST.
Atddismissed
No
10621
Atdid: 10621 • Atd Number: ATD-4-4770 • Bblid: 856564
Atdid
10621
Atd Number
ATD-4-4770
Bblid
856564
Inspectionid
341101
Inspect Date
2022-08-04T00:00:00.000
Atdissuedate
2022-08-08T13:47:31.000
Cb
10
House Num
133-18
Onstname
122ND ST.
Atddismissed
No
17278
Atdid: 17278 • Atd Number: ATD-3-6835 • Bblid: 280742
Atdid
17278
Atd Number
ATD-3-6835
Bblid
280742
Inspectionid
393442
Inspect Date
2025-04-04T00:00:00.000
Atdissuedate
2025-04-07T11:52:08.000
Cb
7
House Num
189
Onstname
16 STREET
Atddismissed
No
NYC Data AI • Public-data exploration interface