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
14591
Atdid: 14591 • Atd Number: ATD-3-6039 • Bblid: 318209
Atdid
14591
Atd Number
ATD-3-6039
Bblid
318209
Violationid
286077
Reinspectionid
36574
Inspect Date
2024-06-13T10:24:00.000
Atdissuedate
2024-06-13T10:24:00.000
Cb
3
House Num
484
Onstname
JEFFERSON AVENUE
Atddismissed
No
8536
Atdid: 8536 • Atd Number: ATD-3-3119 • Bblid: 327959
Atdid
8536
Atd Number
ATD-3-3119
Bblid
327959
Inspectionid
330200
Inspect Date
2021-11-18T00:00:00.000
Atdissuedate
2021-12-06T10:20:12.000
Cb
2
House Num
178
Onstname
ADELPHI ST.
Atddismissed
No
18420
Atdid: 18420 • Atd Number: ATD-4-7290 • Bblid: 727534
Atdid
18420
Atd Number
ATD-4-7290
Bblid
727534
Inspectionid
404733
Inspect Date
2025-08-19T00:00:00.000
Atdissuedate
2025-08-25T11:40:58.000
Cb
11
House Num
33-19
Onstname
BELL BLVD.
Atddismissed
No
11305
Atdid: 11305 • Atd Number: ATD-3-4594 • Bblid: 278615
Atdid
11305
Atd Number
ATD-3-4594
Bblid
278615
Inspectionid
347297
Inspect Date
2022-10-28T00:00:00.000
Atdissuedate
2022-11-01T10:08:02.000
Cb
6
House Num
335
Onstname
8TH ST.
Atddismissed
No
16525
Atdid: 16525 • Atd Number: ATD-3-6464 • Bblid: 286979
Atdid
16525
Atd Number
ATD-3-6464
Bblid
286979
Violationid
293640
Reinspectionid
37188
Inspect Date
2024-12-17T13:29:15.000
Atdissuedate
2024-12-17T13:29:15.000
Cb
8
House Num
183
Onstname
PARK PLACE
Atddismissed
No
12073
Atdid: 12073 • Atd Number: ATD-4-5143 • Bblid: 753744
Atdid
12073
Atd Number
ATD-4-5143
Bblid
753744
Violationid
285008
Reinspectionid
35870
Inspect Date
2023-04-20T13:26:01.000
Atdissuedate
2023-04-20T13:26:01.000
Cb
11
House Num
56-48
Onstname
210 STREET
Atddismissed
No
18022
Atdid: 18022 • Atd Number: ATD-4-7112 • Bblid: 664014
Atdid
18022
Atd Number
ATD-4-7112
Bblid
664014
Inspectionid
401768
Inspect Date
2025-07-03T00:00:00.000
Atdissuedate
2025-07-03T07:54:24.000
Cb
5
House Num
1706
Onstname
HART ST.
Atddismissed
No
8605
Atdid: 8605 • Atd Number: ATD-4-3863 • Bblid: 858062
Atdid
8605
Atd Number
ATD-4-3863
Bblid
858062
Inspectionid
330665
Inspect Date
2019-06-21T00:00:00.000
Atdissuedate
2021-12-13T12:50:02.000
Cb
10
House Num
131-12
Onstname
135TH ST.
Atddismissed
No
18408
Atdid: 18408 • Atd Number: ATD-3-7259 • Bblid: 517829
Atdid
18408
Atd Number
ATD-3-7259
Bblid
517829
Inspectionid
404681
Inspect Date
2025-08-22T00:00:00.000
Atdissuedate
2025-08-22T11:18:57.000
Cb
14
House Num
1381
Onstname
E. 23RD ST.
Atddismissed
No
13148
Atdid: 13148 • Atd Number: ATD-3-5349 • Bblid: 294535
Atdid
13148
Atd Number
ATD-3-5349
Bblid
294535
Inspectionid
361577
Inspect Date
2023-07-15T00:00:00.000
Atdissuedate
2023-08-07T09:00:35.000
Cb
9
House Num
171
Onstname
LEFFERTS AVE.
Atddismissed
No
13621
Atdid: 13621 • Atd Number: ATD-3-5606 • Bblid: 414306
Atdid
13621
Atd Number
ATD-3-5606
Bblid
414306
Inspectionid
365964
Inspect Date
2023-10-25T00:00:00.000
Atdissuedate
2023-10-26T15:20:18.000
Cb
14
House Num
652
Onstname
E. 18TH ST.
Atddismissed
No
17955
Atdid: 17955 • Atd Number: ATD-3-7070 • Bblid: 282184
Atdid
17955
Atd Number
ATD-3-7070
Bblid
282184
Inspectionid
400761
Inspect Date
2025-06-10T00:00:00.000
Atdissuedate
2025-06-23T11:23:35.000
Cb
6
House Num
10
Onstname
POLHEMUS PL.
Atddismissed
No
2112
Atdid: 2112 • Atd Number: ATD-3-1255 • Bblid: 324206
Atdid
2112
Atd Number
ATD-3-1255
Bblid
324206
Violationid
231533
Atdissuedate
2020-01-16T00:00:00.000
Cb
2
House Num
143
Onstname
ST JAMES PLACE
Atddismissed
Yes
Atddismissedon
2023-02-07T13:31:47.000
14726
Atdid: 14726 • Atd Number: ATD-4-6144 • Bblid: 631880
Atdid
14726
Atd Number
ATD-4-6144
Bblid
631880
Inspectionid
379273
Inspect Date
2024-06-03T00:00:00.000
Atdissuedate
2024-07-11T12:44:03.000
Cb
2
House Num
51-05
Onstname
64TH ST.
Atddismissed
No
13577
Atdid: 13577 • Atd Number: ATD-3-5588 • Bblid: 485265
Atdid
13577
Atd Number
ATD-3-5588
Bblid
485265
Inspectionid
365220
Inspect Date
2023-10-11T00:00:00.000
Atdissuedate
2023-10-12T13:27:47.000
Cb
15
House Num
1732
Onstname
GERRITSEN AVE.
Atddismissed
No
16580
Atdid: 16580 • Atd Number: ATD-4-6505 • Bblid: 574980
Atdid
16580
Atd Number
ATD-4-6505
Bblid
574980
Inspectionid
387014
Inspect Date
2024-12-05T00:00:00.000
Atdissuedate
2024-12-20T11:34:56.000
Cb
1
House Num
33-36
Onstname
14TH ST.
Atddismissed
No
10948
Atdid: 10948 • Atd Number: ATD-2-950 • Bblid: 235007
Atdid
10948
Atd Number
ATD-2-950
Bblid
235007
Inspectionid
344175
Inspect Date
2020-03-10T00:00:00.000
Atdissuedate
2022-09-20T11:08:07.000
Cb
10
House Num
619
Onstname
EDISON AVE.
Atddismissed
No
18103
Atdid: 18103 • Atd Number: ATD-3-7134 • Bblid: 540584
Atdid
18103
Atd Number
ATD-3-7134
Bblid
540584
Inspectionid
402503
Inspect Date
2025-07-10T00:00:00.000
Atdissuedate
2025-07-16T13:47:40.000
Cb
18
House Num
1315
Onstname
E. 91ST ST.
Atddismissed
No
17433
Atdid: 17433 • Atd Number: ATD-3-6911 • Bblid: 461557
Atdid
17433
Atd Number
ATD-3-6911
Bblid
461557
Inspectionid
395288
Inspect Date
2025-04-18T00:00:00.000
Atdissuedate
2025-04-24T14:48:41.000
Cb
10
House Num
1241
Onstname
80TH ST.
Atddismissed
No
13950
Atdid: 13950 • Atd Number: ATD-3-5733 • Bblid: 378404
Atdid
13950
Atd Number
ATD-3-5733
Bblid
378404
Inspectionid
371589
Inspect Date
2024-02-07T00:00:00.000
Atdissuedate
2024-02-14T11:06:58.000
Cb
5
House Num
620
Onstname
ELTON ST.
Atddismissed
No
11812
Atdid: 11812 • Atd Number: ATD-3-4805 • Bblid: 392896
Atdid
11812
Atd Number
ATD-3-4805
Bblid
392896
Inspectionid
353199
Inspect Date
2023-03-02T00:00:00.000
Atdissuedate
2023-03-20T09:39:34.000
Cb
17
House Num
8
Onstname
E. 58TH ST.
Atddismissed
No
10950
Atdid: 10950 • Atd Number: ATD-3-4309 • Bblid: 497910
Atdid
10950
Atd Number
ATD-3-4309
Bblid
497910
Inspectionid
344196
Inspect Date
2022-09-14T00:00:00.000
Atdissuedate
2022-09-20T14:48:30.000
Cb
15
House Num
2223
Onstname
E. 8TH ST.
Atddismissed
No
18433
Atdid: 18433 • Atd Number: ATD-3-7270 • Bblid: 307423
Atdid
18433
Atd Number
ATD-3-7270
Bblid
307423
Inspectionid
404890
Inspect Date
2025-08-14T00:00:00.000
Atdissuedate
2025-08-27T10:41:30.000
Cb
3
House Num
849A
Onstname
GREENE AVE.
Atddismissed
No
14634
Atdid: 14634 • Atd Number: ATD-4-6104 • Bblid: 735025
Atdid
14634
Atd Number
ATD-4-6104
Bblid
735025
Inspectionid
378623
Inspect Date
2024-06-20T00:00:00.000
Atdissuedate
2024-06-20T14:28:21.000
Cb
8
House Num
136-36
Onstname
72ND AVE.
Atddismissed
No
12464
Atdid: 12464 • Atd Number: ATD-4-5296 • Bblid: 813100
Atdid
12464
Atd Number
ATD-4-5296
Bblid
813100
Inspectionid
357967
Inspect Date
2023-06-02T00:00:00.000
Atdissuedate
2023-06-02T09:37:39.000
Cb
12
House Num
106-19
Onstname
SUTPHIN BLVD.
Atddismissed
No
10590
Atdid: 10590 • Atd Number: ATD-4-4765 • Bblid: 754689
Atdid
10590
Atd Number
ATD-4-4765
Bblid
754689
Inspectionid
340754
Inspect Date
2022-07-30T00:00:00.000
Atdissuedate
2022-08-02T11:04:21.000
Cb
11
House Num
58-20
Onstname
220TH ST.
Atddismissed
No
8633
Atdid: 8633 • Atd Number: ATD-4-3874 • Bblid: 772532
Atdid
8633
Atd Number
ATD-4-3874
Bblid
772532
Inspectionid
330771
Inspect Date
2021-12-01T00:00:00.000
Atdissuedate
2021-12-15T13:24:28.000
Cb
13
House Num
78-30
Onstname
268TH ST.
Atddismissed
No
16891
Atdid: 16891 • Atd Number: ATD-3-6623 • Bblid: 531033
Atdid
16891
Atd Number
ATD-3-6623
Bblid
531033
Inspectionid
390801
Inspect Date
2025-02-01T00:00:00.000
Atdissuedate
2025-03-10T12:38:05.000
Cb
18
House Num
564
Onstname
E. 80TH ST.
Atddismissed
No
16664
Atdid: 16664 • Atd Number: ATD-3-6532 • Bblid: 515872
Atdid
16664
Atd Number
ATD-3-6532
Bblid
515872
Inspectionid
388556
Inspect Date
2024-12-03T00:00:00.000
Atdissuedate
2025-01-08T10:29:21.000
Cb
18
House Num
1160
Onstname
E. 38TH ST.
Atddismissed
No
143
Atdid: 143 • Atd Number: ATD-1-107 • Bblid: 46064
Atdid
143
Atd Number
ATD-1-107
Bblid
46064
Violationid
6622
Atdissuedate
2020-03-17T00:00:00.000
Cb
6
House Num
246
Onstname
EAST 30 STREET
Atddismissed
Yes
Atddismissedon
2025-06-13T11:32:44.000
11436
Atdid: 11436 • Atd Number: ATD-3-4657 • Bblid: 255514
Atdid
11436
Atd Number
ATD-3-4657
Bblid
255514
Inspectionid
348466
Inspect Date
2022-11-19T00:00:00.000
Atdissuedate
2022-11-21T10:57:10.000
Cb
6
House Num
358
Onstname
CLINTON ST.
Atddismissed
Yes
Atddismissedon
2025-02-27T08:57:39.000
2083
Atdid: 2083 • Atd Number: ATD-3-1226 • Bblid: 315007
Atdid
2083
Atd Number
ATD-3-1226
Bblid
315007
Violationid
155603
Atdissuedate
2020-08-13T00:00:00.000
Cb
3
House Num
531
Onstname
LAFAYETTE AVENUE
Atddismissed
Yes
Atddismissedon
2022-04-15T10:15:03.000
11580
Atdid: 11580 • Atd Number: ATD-4-4947 • Bblid: 759840
Atdid
11580
Atd Number
ATD-4-4947
Bblid
759840
Inspectionid
350086
Inspect Date
2023-01-04T00:00:00.000
Atdissuedate
2023-01-06T11:09:22.000
Cb
13
House Num
82-26
Onstname
243RD ST.
Atddismissed
No
17611
Atdid: 17611 • Atd Number: ATD-4-6883 • Bblid: 647562
Atdid
17611
Atd Number
ATD-4-6883
Bblid
647562
Inspectionid
397082
Inspect Date
2025-04-02T00:00:00.000
Atdissuedate
2025-05-15T09:49:50.000
Cb
5
House Num
61-46
Onstname
76TH ST.
Atddismissed
No
11293
Atdid: 11293 • Atd Number: ATD-3-4582 • Bblid: 386174
Atdid
11293
Atd Number
ATD-3-4582
Bblid
386174
Inspectionid
347244
Inspect Date
2022-10-21T00:00:00.000
Atdissuedate
2022-10-31T14:08:28.000
Cb
5
House Num
720
Onstname
ALABAMA AVE.
Atddismissed
No
12696
Atdid: 12696 • Atd Number: ATD-5-731 • Bblid: 1009665
Atdid
12696
Atd Number
ATD-5-731
Bblid
1009665
Inspectionid
359107
Inspect Date
2023-06-29T00:00:00.000
Atdissuedate
2023-06-29T15:15:47.000
Cb
3
House Num
374
Onstname
ARTHUR KILL RD.
Atddismissed
No
18010
Atdid: 18010 • Atd Number: ATD-5-998 • Bblid: 1028277
Atdid
18010
Atd Number
ATD-5-998
Bblid
1028277
Inspectionid
401668
Inspect Date
2025-04-28T00:00:00.000
Atdissuedate
2025-06-30T11:53:38.000
Cb
3
House Num
45
Onstname
LUDLOW ST.
Atddismissed
No
14335
Atdid: 14335 • Atd Number: ATD-4-5984 • Bblid: 641026
Atdid
14335
Atd Number
ATD-4-5984
Bblid
641026
Inspectionid
375966
Inspect Date
2024-04-15T00:00:00.000
Atdissuedate
2024-04-23T13:10:46.000
Cb
5
House Num
57-37
Onstname
65TH ST.
Atddismissed
No
10006
Atdid: 10006 • Atd Number: ATD-4-4558 • Bblid: 654700
Atdid
10006
Atd Number
ATD-4-4558
Bblid
654700
Inspectionid
335861
Inspect Date
2022-04-21T00:00:00.000
Atdissuedate
2022-04-29T14:32:29.000
Cb
6
House Num
62-27
Onstname
CROMWELL CRES
Atddismissed
No
13922
Atdid: 13922 • Atd Number: ATD-3-5725 • Bblid: 417468
Atdid
13922
Atd Number
ATD-3-5725
Bblid
417468
Inspectionid
371318
Inspect Date
2024-02-01T00:00:00.000
Atdissuedate
2024-02-05T13:03:33.000
Cb
12
House Num
230
Onstname
E. 2ND ST.
Atddismissed
No
16654
Atdid: 16654 • Atd Number: ATD-4-6551 • Bblid: 621085
Atdid
16654
Atd Number
ATD-4-6551
Bblid
621085
Inspectionid
388514
Inspect Date
2024-11-27T00:00:00.000
Atdissuedate
2025-01-07T08:00:23.000
Cb
4
House Num
90-30
Onstname
52ND AVE.
Atddismissed
No
12948
Atdid: 12948 • Atd Number: ATD-3-5225 • Bblid: 414217
Atdid
12948
Atd Number
ATD-3-5225
Bblid
414217
Inspectionid
360458
Inspect Date
2023-07-22T00:00:00.000
Atdissuedate
2023-07-22T12:33:34.000
Cb
14
House Num
749
Onstname
E. 21ST ST.
Atddismissed
No
12565
Atdid: 12565 • Atd Number: ATD-2-1142 • Bblid: 227447
Atdid
12565
Atd Number
ATD-2-1142
Bblid
227447
Inspectionid
358548
Inspect Date
2023-06-14T00:00:00.000
Atdissuedate
2023-06-14T16:08:19.000
Cb
12
House Num
1737
Onstname
NEREID AVE.
Atddismissed
No
12379
Atdid: 12379 • Atd Number: ATD-4-5245 • Bblid: 634495
Atdid
12379
Atd Number
ATD-4-5245
Bblid
634495
Inspectionid
357536
Inspect Date
2023-05-22T00:00:00.000
Atdissuedate
2023-05-22T12:41:32.000
Cb
2
Onstname
72 STREET
Atddismissed
No
8851
Atdid: 8851 • Atd Number: ATD-1-167 • Bblid: 95559
Atdid
8851
Atd Number
ATD-1-167
Bblid
95559
Inspectionid
331770
Inspect Date
2018-04-12T00:00:00.000
Atdissuedate
2022-01-21T10:22:12.000
Cb
8
House Num
226
Onstname
E. 61ST ST.
Atddismissed
Yes
Atddismissedon
2024-03-11T13:28:51.000
17855
Atdid: 17855 • Atd Number: ATD-3-7037 • Bblid: 275524
Atdid
17855
Atd Number
ATD-3-7037
Bblid
275524
Inspectionid
399958
Inspect Date
2025-05-17T00:00:00.000
Atdissuedate
2025-06-11T12:46:20.000
Cb
6
House Num
62
Onstname
BERKELEY PL.
Atddismissed
No
16293
Atdid: 16293 • Atd Number: ATD-3-6371 • Bblid: 446547
Atdid
16293
Atd Number
ATD-3-6371
Bblid
446547
Inspectionid
384454
Inspect Date
2024-10-16T00:00:00.000
Atdissuedate
2024-10-28T10:01:33.000
Cb
10
House Num
629
Onstname
76TH ST.
Atddismissed
No
18617
Atdid: 18617 • Atd Number: ATD-4-7379 • Bblid: 786794
Atdid
18617
Atd Number
ATD-4-7379
Bblid
786794
Inspectionid
406057
Inspect Date
2025-09-15T00:00:00.000
Atdissuedate
2025-09-18T12:28:22.000
Cb
10
House Num
107-34
Onstname
92ND ST.
Atddismissed
No
10571
Atdid: 10571 • Atd Number: ATD-4-4756 • Bblid: 770850
Atdid
10571
Atd Number
ATD-4-4756
Bblid
770850
Inspectionid
340572
Inspect Date
2022-07-15T00:00:00.000
Atdissuedate
2022-07-29T10:32:04.000
Cb
13
House Num
85-07
Onstname
250TH ST.
Atddismissed
No
8915
Atdid: 8915 • Atd Number: ATD-4-4037 • Bblid: 644404
Atdid
8915
Atd Number
ATD-4-4037
Bblid
644404
Inspectionid
332140
Inspect Date
2022-01-14T00:00:00.000
Atdissuedate
2022-01-29T18:26:21.000
Cb
5
House Num
60-72
Onstname
76TH ST.
Atddismissed
No