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
13762
Atdid: 13762 • Atd Number: ATD-3-5673 • Bblid: 362315
Atdid
13762
Atd Number
ATD-3-5673
Bblid
362315
Inspectionid
369240
Inspect Date
2023-12-08T00:00:00.000
Atdissuedate
2023-12-08T15:30:13.000
Cb
4
House Num
281
Onstname
COOPER ST.
Atddismissed
No
13810
Atdid: 13810 • Atd Number: ATD-4-5705 • Bblid: 861046
Atdid
13810
Atd Number
ATD-4-5705
Bblid
861046
Inspectionid
370087
Inspect Date
2023-11-22T00:00:00.000
Atdissuedate
2023-12-26T11:57:30.000
Cb
12
House Num
111-47
Onstname
INWOOD ST.
Atddismissed
No
13813
Atdid: 13813 • Atd Number: ATD-4-5708 • Bblid: 861032
Atdid
13813
Atd Number
ATD-4-5708
Bblid
861032
Inspectionid
370091
Inspect Date
2023-11-22T00:00:00.000
Atdissuedate
2023-12-26T12:01:24.000
Cb
12
House Num
111-61
Onstname
INWOOD ST.
Atddismissed
No
12621
Atdid: 12621 • Atd Number: ATD-4-5371 • Bblid: 798836
Atdid
12621
Atd Number
ATD-4-5371
Bblid
798836
Inspectionid
358835
Inspect Date
2023-06-21T00:00:00.000
Atdissuedate
2023-06-21T15:30:35.000
Cb
10
House Num
112-01
Onstname
LIBERTY AVE.
Atddismissed
No
10087
Atdid: 10087 • Atd Number: ATD-3-3706 • Bblid: 395691
Atdid
10087
Atd Number
ATD-3-3706
Bblid
395691
Inspectionid
336391
Inspect Date
2022-05-13T00:00:00.000
Atdissuedate
2022-05-13T15:11:35.000
Cb
17
House Num
367
Onstname
E. 55TH ST.
Atddismissed
No
12671
Atdid: 12671 • Atd Number: ATD-5-713 • Bblid: 1023254
Atdid
12671
Atd Number
ATD-5-713
Bblid
1023254
Inspectionid
359077
Inspect Date
2023-06-28T00:00:00.000
Atdissuedate
2023-06-28T16:04:42.000
Cb
3
House Num
39
Onstname
ABINGDON CT.
Atddismissed
No
8897
Atdid: 8897 • Atd Number: ATD-4-4027 • Bblid: 644386
Atdid
8897
Atd Number
ATD-4-4027
Bblid
644386
Inspectionid
332098
Inspect Date
2022-01-14T00:00:00.000
Atdissuedate
2022-01-26T20:07:50.000
Cb
5
House Num
60-34
Onstname
76TH ST.
Atddismissed
No
9888
Atdid: 9888 • Atd Number: ATD-4-4494 • Bblid: 718049
Atdid
9888
Atd Number
ATD-4-4494
Bblid
718049
Inspectionid
335028
Inspect Date
2021-10-21T00:00:00.000
Atdissuedate
2022-04-15T13:22:52.000
Cb
11
House Num
46-70
Onstname
HOLLIS COURT BLVD.
Atddismissed
No
11657
Atdid: 11657 • Atd Number: ATD-3-4736 • Bblid: 415348
Atdid
11657
Atd Number
ATD-3-4736
Bblid
415348
Inspectionid
351444
Inspect Date
2022-07-06T00:00:00.000
Atdissuedate
2023-02-13T12:09:28.000
Cb
7
House Num
321
Onstname
VANDERBILT ST.
Atddismissed
No
13576
Atdid: 13576 • Atd Number: ATD-4-5593 • Bblid: 888572
Atdid
13576
Atd Number
ATD-4-5593
Bblid
888572
Inspectionid
365213
Inspect Date
2023-10-12T00:00:00.000
Atdissuedate
2023-10-12T11:43:49.000
Cb
13
House Num
137-32
Onstname
229TH ST.
Atddismissed
No
9920
Atdid: 9920 • Atd Number: ATD-3-3633 • Bblid: 259550
Atdid
9920
Atd Number
ATD-3-3633
Bblid
259550
Inspectionid
335286
Inspect Date
2022-04-20T00:00:00.000
Atdissuedate
2022-04-20T15:15:46.000
Cb
6
House Num
474
Onstname
DEGRAW ST.
Atddismissed
No
10061
Atdid: 10061 • Atd Number: ATD-3-3681 • Bblid: 291492
Atdid
10061
Atd Number
ATD-3-3681
Bblid
291492
Inspectionid
336241
Inspect Date
2022-05-04T00:00:00.000
Atdissuedate
2022-05-09T11:01:48.000
Cb
8
House Num
974
Onstname
SAINT JOHNS PL.
Atddismissed
No
16988
Atdid: 16988 • Atd Number: ATD-4-6672 • Bblid: 689907
Atdid
16988
Atd Number
ATD-4-6672
Bblid
689907
Inspectionid
392010
Inspect Date
2025-03-19T00:00:00.000
Atdissuedate
2025-03-24T11:16:52.000
Cb
7
House Num
167-18
Onstname
CRYDERS LN.
Atddismissed
No
18008
Atdid: 18008 • Atd Number: ATD-5-996 • Bblid: 1028269
Atdid
18008
Atd Number
ATD-5-996
Bblid
1028269
Inspectionid
401666
Inspect Date
2025-04-28T00:00:00.000
Atdissuedate
2025-06-30T11:49:04.000
Cb
3
House Num
53
Onstname
LUDLOW ST.
Atddismissed
No
12131
Atdid: 12131 • Atd Number: ATD-4-5165 • Bblid: 860812
Atdid
12131
Atd Number
ATD-4-5165
Bblid
860812
Inspectionid
356485
Inspect Date
2023-03-23T00:00:00.000
Atdissuedate
2023-05-01T13:51:47.000
Cb
12
House Num
111-10
Onstname
145TH ST.
Atddismissed
No
6076
Atdid: 6076 • Atd Number: ATD-4-2437 • Bblid: 582451
Atdid
6076
Atd Number
ATD-4-2437
Bblid
582451
Violationid
237744
Atdissuedate
2020-06-01T00:00:00.000
Cb
1
House Num
31-53
Onstname
45 STREET
Atddismissed
Yes
Atddismissedon
2024-07-11T08:58:57.000
9752
Atdid: 9752 • Atd Number: ATD-3-3588 • Bblid: 373277
Atdid
9752
Atd Number
ATD-3-3588
Bblid
373277
Violationid
275336
Reinspectionid
32680
Inspect Date
2022-03-29T12:23:34.000
Atdissuedate
2022-03-29T12:23:34.000
Cb
5
House Num
123
Onstname
HIGHLAND PLACE
Atddismissed
No
17207
Atdid: 17207 • Atd Number: ATD-2-1364 • Bblid: 208940
Atdid
17207
Atd Number
ATD-2-1364
Bblid
208940
Inspectionid
392897
Inspect Date
2025-04-01T00:00:00.000
Atdissuedate
2025-04-01T12:37:43.000
Cb
11
House Num
2763
Onstname
MICKLE AVE.
Atddismissed
No
12011
Atdid: 12011 • Atd Number: ATD-3-4910 • Bblid: 361361
Atdid
12011
Atd Number
ATD-3-4910
Bblid
361361
Inspectionid
354733
Inspect Date
2023-04-11T00:00:00.000
Atdissuedate
2023-04-11T13:12:07.000
Cb
4
House Num
257
Onstname
COVERT ST.
Atddismissed
No
8969
Atdid: 8969 • Atd Number: ATD-4-4068 • Bblid: 677649
Atdid
8969
Atd Number
ATD-4-4068
Bblid
677649
Inspectionid
332270
Inspect Date
2020-12-03T00:00:00.000
Atdissuedate
2022-02-04T16:25:26.000
Cb
5
House Num
87-45
Onstname
UNION TPKE.
Atddismissed
No
8785
Atdid: 8785 • Atd Number: ATD-4-3961 • Bblid: 668359
Atdid
8785
Atd Number
ATD-4-3961
Bblid
668359
Inspectionid
331281
Inspect Date
2021-12-01T00:00:00.000
Atdissuedate
2021-12-30T11:03:55.000
Cb
5
House Num
1615
Onstname
SUMMERFIELD ST.
Atddismissed
No
16513
Atdid: 16513 • Atd Number: ATD-4-6496 • Bblid: 771221
Atdid
16513
Atd Number
ATD-4-6496
Bblid
771221
Inspectionid
386305
Inspect Date
2024-02-02T00:00:00.000
Atdissuedate
2024-12-16T09:07:10.000
Cb
13
House Num
86-16
Onstname
252ND ST.
Atddismissed
No
10368
Atdid: 10368 • Atd Number: ATD-3-3881 • Bblid: 417850
Atdid
10368
Atd Number
ATD-3-3881
Bblid
417850
Inspectionid
338555
Inspect Date
2022-06-15T00:00:00.000
Atdissuedate
2022-07-05T13:17:52.000
Cb
12
House Num
225
Onstname
E. 5TH ST.
Atddismissed
No
11535
Atdid: 11535 • Atd Number: ATD-4-4925 • Bblid: 670226
Atdid
11535
Atd Number
ATD-4-4925
Bblid
670226
Inspectionid
349638
Inspect Date
2022-12-21T00:00:00.000
Atdissuedate
2022-12-23T12:06:19.000
Cb
5
House Num
61-31
Onstname
GATES AVE.
Atddismissed
No
8502
Atdid: 8502 • Atd Number: ATD-3-3104 • Bblid: 305349
Atdid
8502
Atd Number
ATD-3-3104
Bblid
305349
Inspectionid
329645
Inspect Date
2021-11-16T00:00:00.000
Atdissuedate
2021-11-17T10:24:45.000
Cb
16
House Num
1254
Onstname
HERKIMER ST.
Atddismissed
Yes
Atddismissedon
2021-11-17T10:26:49.000
14669
Atdid: 14669 • Atd Number: ATD-3-6083 • Bblid: 257856
Atdid
14669
Atd Number
ATD-3-6083
Bblid
257856
Violationid
283937
Reinspectionid
36190
Inspect Date
2024-06-28T13:03:17.000
Atdissuedate
2024-06-28T13:03:17.000
Cb
6
House Num
155
Onstname
HUNTINGTON STREET
Atddismissed
No
518
Atdid: 518 • Atd Number: ATD-2-385 • Bblid: 219547
Atdid
518
Atd Number
ATD-2-385
Bblid
219547
Violationid
156411
Atdissuedate
2020-08-11T00:00:00.000
Cb
12
House Num
873
Onstname
EAST 228 STREET
Atddismissed
Yes
Atddismissedon
2022-05-24T09:17:13.000
11512
Atdid: 11512 • Atd Number: ATD-4-4906 • Bblid: 596504
Atdid
11512
Atd Number
ATD-4-4906
Bblid
596504
Inspectionid
349313
Inspect Date
2022-11-18T00:00:00.000
Atdissuedate
2022-12-15T10:17:59.000
Cb
3
House Num
30-51
Onstname
74TH ST.
Atddismissed
No
13618
Atdid: 13618 • Atd Number: ATD-4-5617 • Bblid: 897045
Atdid
13618
Atd Number
ATD-4-5617
Bblid
897045
Inspectionid
365704
Inspect Date
2023-10-05T00:00:00.000
Atdissuedate
2023-10-23T13:56:45.000
Cb
13
House Num
255-55
Onstname
148TH DR.
Atddismissed
No
16605
Atdid: 16605 • Atd Number: ATD-3-6515 • Bblid: 297912
Atdid
16605
Atd Number
ATD-3-6515
Bblid
297912
Inspectionid
387188
Inspect Date
2024-12-18T00:00:00.000
Atdissuedate
2024-12-24T09:30:25.000
Cb
8
House Num
1217
Onstname
LINCOLN PL.
Atddismissed
No
16716
Atdid: 16716 • Atd Number: ATD-1-360 • Bblid: 117008
Atdid
16716
Atd Number
ATD-1-360
Bblid
117008
Inspectionid
388844
Inspect Date
2024-11-27T00:00:00.000
Atdissuedate
2025-01-21T15:15:17.000
Cb
10
House Num
62
Onstname
W. 127TH ST.
Atddismissed
No
9106
Atdid: 9106 • Atd Number: ATD-4-4155 • Bblid: 658015
Atdid
9106
Atd Number
ATD-4-4155
Bblid
658015
Inspectionid
332657
Inspect Date
2019-06-28T00:00:00.000
Atdissuedate
2022-02-22T15:03:16.000
Cb
6
House Num
68-38
Onstname
FLEET ST.
Atddismissed
No
7886
Atdid: 7886 • Atd Number: ATD-3-2808 • Bblid: 265470
Atdid
7886
Atd Number
ATD-3-2808
Bblid
265470
Inspectionid
313267
Cb
7
House Num
339
Onstname
45TH ST.
Atddismissed
Yes
Atddismissedon
2022-09-21T12:35:02.000
11264
Atdid: 11264 • Atd Number: ATD-3-4570 • Bblid: 292702
Atdid
11264
Atd Number
ATD-3-4570
Bblid
292702
Inspectionid
346959
Inspect Date
2022-10-22T00:00:00.000
Atdissuedate
2022-10-25T10:39:42.000
Cb
9
House Num
1156
Onstname
UNION ST.
Atddismissed
No
10723
Atdid: 10723 • Atd Number: ATD-3-4106 • Bblid: 332594
Atdid
10723
Atd Number
ATD-3-4106
Bblid
332594
Inspectionid
342390
Inspect Date
2022-08-25T00:00:00.000
Atdissuedate
2022-08-31T14:41:22.000
Cb
1
House Num
270
Onstname
HEWES ST.
Atddismissed
No
9190
Atdid: 9190 • Atd Number: ATD-1-178 • Bblid: 26839
Atdid
9190
Atd Number
ATD-1-178
Bblid
26839
Inspectionid
332848
Inspect Date
2020-01-09T00:00:00.000
Atdissuedate
2022-02-28T17:25:45.000
Cb
2
House Num
90
Onstname
BARROW ST.
Atddismissed
No
14043
Atdid: 14043 • Atd Number: ATD-4-5858 • Bblid: 613604
Atdid
14043
Atd Number
ATD-4-5858
Bblid
613604
Violationid
291106
Reinspectionid
36436
Inspect Date
2024-03-01T10:56:39.000
Atdissuedate
2024-03-01T10:56:39.000
Cb
4
House Num
41-32
Onstname
JUNCTION BOULEVARD
Atddismissed
No
17553
Atdid: 17553 • Atd Number: ATD-2-1391 • Bblid: 207638
Atdid
17553
Atd Number
ATD-2-1391
Bblid
207638
Inspectionid
396342
Inspect Date
2025-05-02T00:00:00.000
Atdissuedate
2025-05-06T16:30:46.000
Cb
11
House Num
2415
Onstname
DELANOY AVE.
Atddismissed
No
11925
Atdid: 11925 • Atd Number: ATD-3-4876 • Bblid: 286537
Atdid
11925
Atd Number
ATD-3-4876
Bblid
286537
Inspectionid
354175
Inspect Date
2023-03-29T00:00:00.000
Atdissuedate
2023-03-29T12:14:19.000
Cb
8
House Num
207
Onstname
PROSPECT PL.
Atddismissed
No
16807
Atdid: 16807 • Atd Number: ATD-3-6596 • Bblid: 473167
Atdid
16807
Atd Number
ATD-3-6596
Bblid
473167
Inspectionid
389683
Inspect Date
2025-02-04T00:00:00.000
Atdissuedate
2025-02-10T13:08:01.000
Cb
12
House Num
1308
Onstname
OCEAN PKWY.
Atddismissed
No
14360
Atdid: 14360 • Atd Number: ATD-3-5917 • Bblid: 489625
Atdid
14360
Atd Number
ATD-3-5917
Bblid
489625
Inspectionid
376200
Inspect Date
2024-04-26T00:00:00.000
Atdissuedate
2024-04-29T10:01:45.000
Cb
13
House Num
2546
Onstname
WEST 16 STREET
Atddismissed
No
14685
Atdid: 14685 • Atd Number: ATD-3-6099 • Bblid: 462964
Atdid
14685
Atd Number
ATD-3-6099
Bblid
462964
Inspectionid
378994
Inspect Date
2024-07-01T00:00:00.000
Atdissuedate
2024-07-02T13:18:42.000
Cb
11
House Num
1449
Onstname
83RD ST.
Atddismissed
No
9664
Atdid: 9664 • Atd Number: ATD-5-640 • Bblid: 990474
Atdid
9664
Atd Number
ATD-5-640
Bblid
990474
Inspectionid
333861
Inspect Date
2021-08-12T00:00:00.000
Atdissuedate
2022-03-16T17:43:04.000
Cb
2
House Num
7
Onstname
REMSEN ST.
Atddismissed
No
11733
Atdid: 11733 • Atd Number: ATD-3-4771 • Bblid: 437148
Atdid
11733
Atd Number
ATD-3-4771
Bblid
437148
Inspectionid
352210
Inspect Date
2023-02-27T00:00:00.000
Atdissuedate
2023-02-28T14:06:21.000
Cb
12
House Num
1215
Onstname
59TH ST.
Atddismissed
No
9909
Atdid: 9909 • Atd Number: ATD-5-657 • Bblid: 1051768
Atdid
9909
Atd Number
ATD-5-657
Bblid
1051768
Inspectionid
335194
Inspect Date
2022-04-19T00:00:00.000
Atdissuedate
2022-04-19T14:32:56.000
Cb
3
House Num
41
Onstname
GIEGERICH PL.
Atddismissed
No
8985
Atdid: 8985 • Atd Number: ATD-4-4076 • Bblid: 677677
Atdid
8985
Atd Number
ATD-4-4076
Bblid
677677
Inspectionid
332298
Inspect Date
2020-12-04T00:00:00.000
Atdissuedate
2022-02-08T08:22:29.000
Cb
5
House Num
87-07
Onstname
UNION TPKE.
Atddismissed
No
12814
Atdid: 12814 • Atd Number: ATD-3-5146 • Bblid: 506443
Atdid
12814
Atd Number
ATD-3-5146
Bblid
506443
Inspectionid
359797
Inspect Date
2023-07-11T00:00:00.000
Atdissuedate
2023-07-11T11:41:41.000
Cb
15
House Num
2127
Onstname
E. 23RD ST.
Atddismissed
No
11525
Atdid: 11525 • Atd Number: ATD-4-4918 • Bblid: 773763
Atdid
11525
Atd Number
ATD-4-4918
Bblid
773763
Inspectionid
349454
Inspect Date
2022-12-15T00:00:00.000
Atdissuedate
2022-12-16T14:08:07.000
Cb
13
House Num
81-28
Onstname
262ND ST.
Atddismissed
No
18445
Atdid: 18445 • Atd Number: ATD-4-7300 • Bblid: 664898
Atdid
18445
Atd Number
ATD-4-7300
Bblid
664898
Inspectionid
404957
Inspect Date
2025-08-27T00:00:00.000
Atdissuedate
2025-08-27T17:40:14.000
Cb
5
House Num
57-17
Onstname
CATALPA AVE.
Atddismissed
No
13521
Atdid: 13521 • Atd Number: ATD-5-839 • Bblid: 963344
Atdid
13521
Atd Number
ATD-5-839
Bblid
963344
Inspectionid
364703
Inspect Date
2023-09-28T00:00:00.000
Atdissuedate
2023-10-02T12:26:43.000
Cb
2
House Num
257
Onstname
LANDER AVE.
Atddismissed
No