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
7897
Atdid: 7897 • Atd Number: ATD-4-3597 • Bblid: 769336
Atdid
7897
Atd Number
ATD-4-3597
Bblid
769336
Inspectionid
313545
Inspect Date
2020-03-20T00:00:00.000
Atdissuedate
2020-03-20T00:00:00.000
Cb
13
House Num
270-14
Onstname
77TH AVE.
Atddismissed
No
7898
Atdid: 7898 • Atd Number: ATD-1-138 • Bblid: 73998
Atdid
7898
Atd Number
ATD-1-138
Bblid
73998
Inspectionid
313572
Inspect Date
2020-03-20T00:00:00.000
Atdissuedate
2020-03-20T00:00:00.000
Cb
7
House Num
32
Onstname
W. 87TH ST.
Atddismissed
No
7899
Atdid: 7899 • Atd Number: ATD-4-3598 • Bblid: 787760
Atdid
7899
Atd Number
ATD-4-3598
Bblid
787760
Inspectionid
313614
Inspect Date
2020-03-18T00:00:00.000
Atdissuedate
2020-03-18T00:00:00.000
Cb
9
House Num
84-32
Onstname
107TH ST.
Atddismissed
No
7900
Atdid: 7900 • Atd Number: ATD-4-3599 • Bblid: 788410
Atdid
7900
Atd Number
ATD-4-3599
Bblid
788410
Inspectionid
313621
Inspect Date
2020-03-20T00:00:00.000
Atdissuedate
2020-03-20T00:00:00.000
Cb
9
House Num
86-27
Onstname
107TH ST.
Atddismissed
No
7901
Atdid: 7901 • Atd Number: ATD-4-3600 • Bblid: 788384
Atdid
7901
Atd Number
ATD-4-3600
Bblid
788384
Inspectionid
313631
Inspect Date
2020-03-20T00:00:00.000
Atdissuedate
2020-03-20T00:00:00.000
Cb
9
House Num
86-67
Onstname
107TH ST.
Atddismissed
No
7902
Atdid: 7902 • Atd Number: ATD-3-2814 • Bblid: 316706
Atdid
7902
Atd Number
ATD-3-2814
Bblid
316706
Inspectionid
313635
Inspect Date
2020-03-05T00:00:00.000
Atdissuedate
2020-03-05T00:00:00.000
Cb
3
House Num
288
Onstname
QUINCY ST.
Atddismissed
No
7903
Atdid: 7903 • Atd Number: ATD-3-2815 • Bblid: 319329
Atdid
7903
Atd Number
ATD-3-2815
Bblid
319329
Inspectionid
313687
Inspect Date
2020-03-03T00:00:00.000
Atdissuedate
2020-03-03T00:00:00.000
Cb
3
House Num
568
Onstname
PUTNAM AVE.
Atddismissed
No
7904
Atdid: 7904 • Atd Number: ATD-3-2816 • Bblid: 319319
Atdid
7904
Atd Number
ATD-3-2816
Bblid
319319
Inspectionid
313692
Inspect Date
2020-03-03T00:00:00.000
Atdissuedate
2020-03-03T00:00:00.000
Cb
3
House Num
558
Onstname
PUTNAM AVE.
Atddismissed
No
7905
Atdid: 7905 • Atd Number: ATD-3-2817 • Bblid: 319309
Atdid
7905
Atd Number
ATD-3-2817
Bblid
319309
Inspectionid
313697
Inspect Date
2020-03-03T00:00:00.000
Atdissuedate
2020-03-03T00:00:00.000
Cb
3
House Num
548
Onstname
PUTNAM AVE.
Atddismissed
No
7906
Atdid: 7906 • Atd Number: ATD-3-2818 • Bblid: 449445
Atdid
7906
Atd Number
ATD-3-2818
Bblid
449445
Inspectionid
313891
Inspect Date
2020-08-08T00:00:00.000
Atdissuedate
2020-08-08T00:00:00.000
Cb
10
House Num
8211
Onstname
NARROWS AVE.
Atddismissed
No
7907
Atdid: 7907 • Atd Number: ATD-4-3601 • Bblid: 595985
Atdid
7907
Atd Number
ATD-4-3601
Bblid
595985
Inspectionid
314378
Inspect Date
2020-09-29T00:00:00.000
Atdissuedate
2020-09-29T00:00:00.000
Cb
3
House Num
93-15
Onstname
25TH AVE.
Atddismissed
No
7908
Atdid: 7908 • Atd Number: ATD-4-3602 • Bblid: 634041
Atdid
7908
Atd Number
ATD-4-3602
Bblid
634041
Inspectionid
314615
Inspect Date
2020-11-12T00:00:00.000
Atdissuedate
2020-11-12T00:00:00.000
Cb
2
House Num
66-09
Onstname
GARFIELD AVE.
Atddismissed
No
7909
Atdid: 7909 • Atd Number: ATD-4-3603 • Bblid: 606007
Atdid
7909
Atd Number
ATD-4-3603
Bblid
606007
Inspectionid
314748
Inspect Date
2020-10-28T00:00:00.000
Atdissuedate
2020-10-28T00:00:00.000
Cb
3
House Num
30-62
Onstname
86TH ST.
Atddismissed
No
7910
Atdid: 7910 • Atd Number: ATD-4-3604 • Bblid: 744504
Atdid
7910
Atd Number
ATD-4-3604
Bblid
744504
Inspectionid
314795
Inspect Date
2020-10-22T00:00:00.000
Atdissuedate
2020-10-22T00:00:00.000
Cb
8
House Num
164-19
Onstname
76TH AVE.
Atddismissed
No
7911
Atdid: 7911 • Atd Number: ATD-4-3605 • Bblid: 744508
Atdid
7911
Atd Number
ATD-4-3605
Bblid
744508
Inspectionid
314796
Inspect Date
2020-10-22T00:00:00.000
Atdissuedate
2020-10-22T00:00:00.000
Cb
8
House Num
164-11
Onstname
76TH AVE.
Atddismissed
No
7912
Atdid: 7912 • Atd Number: ATD-5-554 • Bblid: 958396
Atdid
7912
Atd Number
ATD-5-554
Bblid
958396
Inspectionid
314822
Inspect Date
2021-08-13T00:00:00.000
Atdissuedate
2021-08-13T00:00:00.000
Cb
1
House Num
30
Onstname
ANDROS AVE.
Atddismissed
No
7913
Atdid: 7913 • Atd Number: ATD-3-2819 • Bblid: 522434
Atdid
7913
Atd Number
ATD-3-2819
Bblid
522434
Inspectionid
314842
Inspect Date
2020-10-28T00:00:00.000
Atdissuedate
2020-10-28T00:00:00.000
Cb
18
House Num
1142
Onstname
E. 52ND ST.
Atddismissed
No
7914
Atdid: 7914 • Atd Number: ATD-3-2820 • Bblid: 522436
Atdid
7914
Atd Number
ATD-3-2820
Bblid
522436
Inspectionid
314843
Inspect Date
2020-10-28T00:00:00.000
Atdissuedate
2020-10-28T00:00:00.000
Cb
18
House Num
1144
Onstname
E. 52ND ST.
Atddismissed
No
7915
Atdid: 7915 • Atd Number: ATD-3-2821 • Bblid: 522440
Atdid
7915
Atd Number
ATD-3-2821
Bblid
522440
Inspectionid
314845
Inspect Date
2020-10-28T00:00:00.000
Atdissuedate
2020-10-28T00:00:00.000
Cb
18
House Num
1150
Onstname
E. 52ND ST.
Atddismissed
No
7916
Atdid: 7916 • Atd Number: ATD-4-3606 • Bblid: 866757
Atdid
7916
Atd Number
ATD-4-3606
Bblid
866757
Inspectionid
314984
Inspect Date
2020-10-27T00:00:00.000
Atdissuedate
2020-10-27T00:00:00.000
Cb
12
House Num
111-19
Onstname
158TH ST.
Atddismissed
No
7917
Atdid: 7917 • Atd Number: ATD-4-3607 • Bblid: 866753
Atdid
7917
Atd Number
ATD-4-3607
Bblid
866753
Inspectionid
314986
Inspect Date
2020-10-27T00:00:00.000
Atdissuedate
2020-10-27T00:00:00.000
Cb
12
House Num
111-23
Onstname
158TH ST.
Atddismissed
No
7918
Atdid: 7918 • Atd Number: ATD-4-3608 • Bblid: 866727
Atdid
7918
Atd Number
ATD-4-3608
Bblid
866727
Inspectionid
314997
Inspect Date
2020-10-28T00:00:00.000
Atdissuedate
2020-10-28T00:00:00.000
Cb
12
House Num
111-69
Onstname
158TH ST.
Atddismissed
No
7919
Atdid: 7919 • Atd Number: ATD-4-3609 • Bblid: 866725
Atdid
7919
Atd Number
ATD-4-3609
Bblid
866725
Inspectionid
314998
Inspect Date
2020-10-28T00:00:00.000
Atdissuedate
2020-10-28T00:00:00.000
Cb
12
House Num
111-71
Onstname
158TH ST.
Atddismissed
No
7921
Atdid: 7921 • Atd Number: ATD-4-3610 • Bblid: 797661
Atdid
7921
Atd Number
ATD-4-3610
Bblid
797661
Inspectionid
315187
Inspect Date
2020-11-06T00:00:00.000
Atdissuedate
2020-11-06T00:00:00.000
Cb
9
House Num
102-03
Onstname
134 STREET
Atddismissed
No
7922
Atdid: 7922 • Atd Number: ATD-5-555 • Bblid: 1014830
Atdid
7922
Atd Number
ATD-5-555
Bblid
1014830
Inspectionid
315200
Inspect Date
2020-11-17T00:00:00.000
Atdissuedate
2020-11-17T00:00:00.000
Cb
3
House Num
183
Onstname
CLEVELAND AVE.
Atddismissed
No
7923
Atdid: 7923 • Atd Number: ATD-4-3611 • Bblid: 605971
Atdid
7923
Atd Number
ATD-4-3611
Bblid
605971
Inspectionid
315214
Inspect Date
2020-11-02T00:00:00.000
Atdissuedate
2020-11-02T00:00:00.000
Cb
3
House Num
30-22
Onstname
86TH ST.
Atddismissed
No
7924
Atdid: 7924 • Atd Number: ATD-4-3612 • Bblid: 605969
Atdid
7924
Atd Number
ATD-4-3612
Bblid
605969
Inspectionid
315215
Inspect Date
2020-11-02T00:00:00.000
Atdissuedate
2020-11-02T00:00:00.000
Cb
3
House Num
30-20
Onstname
86TH ST.
Atddismissed
No
7925
Atdid: 7925 • Atd Number: ATD-4-3613 • Bblid: 605967
Atdid
7925
Atd Number
ATD-4-3613
Bblid
605967
Inspectionid
315216
Inspect Date
2020-11-02T00:00:00.000
Atdissuedate
2020-11-02T00:00:00.000
Cb
3
House Num
30-18
Onstname
86TH ST.
Atddismissed
No
7926
Atdid: 7926 • Atd Number: ATD-4-3614 • Bblid: 605965
Atdid
7926
Atd Number
ATD-4-3614
Bblid
605965
Inspectionid
315217
Inspect Date
2020-11-02T00:00:00.000
Atdissuedate
2020-11-02T00:00:00.000
Cb
3
House Num
30-16
Onstname
86TH ST.
Atddismissed
No
7927
Atdid: 7927 • Atd Number: ATD-4-3615 • Bblid: 605959
Atdid
7927
Atd Number
ATD-4-3615
Bblid
605959
Inspectionid
315220
Inspect Date
2020-11-02T00:00:00.000
Atdissuedate
2020-11-02T00:00:00.000
Cb
3
House Num
30-10
Onstname
86TH ST.
Atddismissed
No
7928
Atdid: 7928 • Atd Number: ATD-4-3616 • Bblid: 605957
Atdid
7928
Atd Number
ATD-4-3616
Bblid
605957
Inspectionid
315221
Inspect Date
2020-11-02T00:00:00.000
Atdissuedate
2020-11-02T00:00:00.000
Cb
3
House Num
30-08
Onstname
86TH ST.
Atddismissed
No
7929
Atdid: 7929 • Atd Number: ATD-4-3617 • Bblid: 605955
Atdid
7929
Atd Number
ATD-4-3617
Bblid
605955
Inspectionid
315222
Inspect Date
2020-11-02T00:00:00.000
Atdissuedate
2020-11-02T00:00:00.000
Cb
3
House Num
30-06
Onstname
86TH ST.
Atddismissed
No
7930
Atdid: 7930 • Atd Number: ATD-4-3618 • Bblid: 647218
Atdid
7930
Atd Number
ATD-4-3618
Bblid
647218
Inspectionid
315303
Inspect Date
2020-11-05T00:00:00.000
Atdissuedate
2020-11-05T00:00:00.000
Cb
5
House Num
61-09
Onstname
77TH ST.
Atddismissed
No
7931
Atdid: 7931 • Atd Number: ATD-4-3619 • Bblid: 647198
Atdid
7931
Atd Number
ATD-4-3619
Bblid
647198
Inspectionid
315307
Inspect Date
2020-11-05T00:00:00.000
Atdissuedate
2020-11-05T00:00:00.000
Cb
5
House Num
61-29
Onstname
77TH ST.
Atddismissed
No
7932
Atdid: 7932 • Atd Number: ATD-4-3620 • Bblid: 653234
Atdid
7932
Atd Number
ATD-4-3620
Bblid
653234
Inspectionid
315321
Inspect Date
2020-11-09T00:00:00.000
Atdissuedate
2020-11-09T00:00:00.000
Cb
6
House Num
63-13
Onstname
WETHEROLE ST.
Atddismissed
No
7933
Atdid: 7933 • Atd Number: ATD-4-3621 • Bblid: 653218
Atdid
7933
Atd Number
ATD-4-3621
Bblid
653218
Inspectionid
315327
Inspect Date
2020-11-09T00:00:00.000
Atdissuedate
2020-11-09T00:00:00.000
Cb
6
House Num
63-33
Onstname
WETHEROLE ST.
Atddismissed
No
7934
Atdid: 7934 • Atd Number: ATD-4-3622 • Bblid: 761864
Atdid
7934
Atd Number
ATD-4-3622
Bblid
761864
Inspectionid
315379
Inspect Date
2020-11-07T00:00:00.000
Atdissuedate
2020-11-07T00:00:00.000
Cb
13
House Num
89-38
Onstname
240TH ST.
Atddismissed
No
7935
Atdid: 7935 • Atd Number: ATD-4-3623 • Bblid: 761862
Atdid
7935
Atd Number
ATD-4-3623
Bblid
761862
Inspectionid
315380
Inspect Date
2020-11-07T00:00:00.000
Atdissuedate
2020-11-07T00:00:00.000
Cb
13
House Num
89-36
Onstname
240TH ST.
Atddismissed
No
7936
Atdid: 7936 • Atd Number: ATD-4-3624 • Bblid: 761846
Atdid
7936
Atd Number
ATD-4-3624
Bblid
761846
Inspectionid
315388
Inspect Date
2020-11-07T00:00:00.000
Atdissuedate
2020-11-07T00:00:00.000
Cb
13
House Num
89-12
Onstname
240TH ST.
Atddismissed
No
7937
Atdid: 7937 • Atd Number: ATD-4-3625 • Bblid: 761453
Atdid
7937
Atd Number
ATD-4-3625
Bblid
761453
Inspectionid
315408
Inspect Date
2020-11-14T00:00:00.000
Atdissuedate
2020-11-14T00:00:00.000
Cb
13
House Num
88-35
Onstname
238TH ST.
Atddismissed
No
7938
Atdid: 7938 • Atd Number: ATD-4-3626 • Bblid: 761455
Atdid
7938
Atd Number
ATD-4-3626
Bblid
761455
Inspectionid
315409
Inspect Date
2020-11-14T00:00:00.000
Atdissuedate
2020-11-14T00:00:00.000
Cb
13
House Num
88-31
Onstname
238TH ST.
Atddismissed
No
7939
Atdid: 7939 • Atd Number: ATD-4-3627 • Bblid: 761449
Atdid
7939
Atd Number
ATD-4-3627
Bblid
761449
Inspectionid
315410
Inspect Date
2020-11-14T00:00:00.000
Atdissuedate
2020-11-14T00:00:00.000
Cb
13
House Num
88-41
Onstname
238TH ST.
Atddismissed
No
7940
Atdid: 7940 • Atd Number: ATD-4-3628 • Bblid: 642133
Atdid
7940
Atd Number
ATD-4-3628
Bblid
642133
Inspectionid
315477
Inspect Date
2020-11-17T00:00:00.000
Atdissuedate
2020-11-17T00:00:00.000
Cb
5
House Num
69-65
Onstname
57TH DR.
Atddismissed
No
7941
Atdid: 7941 • Atd Number: ATD-4-3629 • Bblid: 642131
Atdid
7941
Atd Number
ATD-4-3629
Bblid
642131
Inspectionid
315480
Inspect Date
2020-11-17T00:00:00.000
Atdissuedate
2020-11-17T00:00:00.000
Cb
5
House Num
69-71
Onstname
57TH DR.
Atddismissed
No
7942
Atdid: 7942 • Atd Number: ATD-4-3630 • Bblid: 642139
Atdid
7942
Atd Number
ATD-4-3630
Bblid
642139
Inspectionid
315482
Inspect Date
2020-11-17T00:00:00.000
Atdissuedate
2020-11-17T00:00:00.000
Cb
5
House Num
69-73
Onstname
57TH DR.
Atddismissed
No
7943
Atdid: 7943 • Atd Number: ATD-4-3631 • Bblid: 641953
Atdid
7943
Atd Number
ATD-4-3631
Bblid
641953
Inspectionid
315488
Inspect Date
2020-11-17T00:00:00.000
Atdissuedate
2020-11-17T00:00:00.000
Cb
5
House Num
57-13
Onstname
69TH PL.
Atddismissed
No
7944
Atdid: 7944 • Atd Number: ATD-4-3632 • Bblid: 641951
Atdid
7944
Atd Number
ATD-4-3632
Bblid
641951
Inspectionid
315489
Inspect Date
2020-11-17T00:00:00.000
Atdissuedate
2020-11-17T00:00:00.000
Cb
5
House Num
57-15
Onstname
69TH PL.
Atddismissed
No
7945
Atdid: 7945 • Atd Number: ATD-4-3633 • Bblid: 641949
Atdid
7945
Atd Number
ATD-4-3633
Bblid
641949
Inspectionid
315490
Inspect Date
2020-11-17T00:00:00.000
Atdissuedate
2020-11-17T00:00:00.000
Cb
5
House Num
57-17
Onstname
69TH PL.
Atddismissed
No
7947
Atdid: 7947 • Atd Number: ATD-3-2824 • Bblid: 510153
Atdid
7947
Atd Number
ATD-3-2824
Bblid
510153
Inspectionid
315600
Inspect Date
2020-11-10T00:00:00.000
Atdissuedate
2020-11-10T00:00:00.000
Cb
15
House Num
2606
Onstname
AVENUE X.
Atddismissed
No
7948
Atdid: 7948 • Atd Number: ATD-3-2825 • Bblid: 510155
Atdid
7948
Atd Number
ATD-3-2825
Bblid
510155
Inspectionid
315601
Inspect Date
2020-11-17T00:00:00.000
Atdissuedate
2020-11-17T00:00:00.000
Cb
15
House Num
2608
Onstname
AVENUE X.
Atddismissed
No