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
7643
Atdid: 7643 • Atd Number: ATD-2-760 • Bblid: 201388
Atdid
7643
Atd Number
ATD-2-760
Bblid
201388
Inspectionid
308142
Inspect Date
2020-01-08T00:00:00.000
Atdissuedate
2020-01-08T00:00:00.000
Cb
11
House Num
1961
Onstname
WALLACE AVE.
Atddismissed
No
7644
Atdid: 7644 • Atd Number: ATD-1-135 • Bblid: 76363
Atdid
7644
Atd Number
ATD-1-135
Bblid
76363
Inspectionid
308266
Inspect Date
2020-01-14T00:00:00.000
Atdissuedate
2020-01-14T00:00:00.000
Cb
7
House Num
147
Onstname
W. 95TH ST.
Atddismissed
No
7645
Atdid: 7645 • Atd Number: ATD-1-136 • Bblid: 76321
Atdid
7645
Atd Number
ATD-1-136
Bblid
76321
Inspectionid
308267
Inspect Date
2020-01-14T00:00:00.000
Atdissuedate
2020-01-14T00:00:00.000
Cb
7
House Num
145
Onstname
W. 95TH ST.
Atddismissed
No
7646
Atdid: 7646 • Atd Number: ATD-2-761 • Bblid: 199343
Atdid
7646
Atd Number
ATD-2-761
Bblid
199343
Inspectionid
308276
Inspect Date
2020-01-14T00:00:00.000
Atdissuedate
2020-01-14T00:00:00.000
Cb
10
House Num
1616
Onstname
JARVIS AVE.
Atddismissed
No
7647
Atdid: 7647 • Atd Number: ATD-3-2728 • Bblid: 283634
Atdid
7647
Atd Number
ATD-3-2728
Bblid
283634
Inspectionid
308299
Inspect Date
2019-10-17T00:00:00.000
Atdissuedate
2019-10-17T00:00:00.000
Cb
6
House Num
513
Onstname
11TH ST.
Atddismissed
No
7648
Atdid: 7648 • Atd Number: ATD-3-2729 • Bblid: 283624
Atdid
7648
Atd Number
ATD-3-2729
Bblid
283624
Inspectionid
308304
Inspect Date
2019-10-17T00:00:00.000
Atdissuedate
2019-10-17T00:00:00.000
Cb
6
House Num
523
Onstname
11TH ST.
Atddismissed
No
7650
Atdid: 7650 • Atd Number: ATD-3-2730 • Bblid: 302953
Atdid
7650
Atd Number
ATD-3-2730
Bblid
302953
Inspectionid
308391
Inspect Date
2020-01-14T00:00:00.000
Atdissuedate
2020-01-14T00:00:00.000
Cb
3
House Num
402A
Onstname
BAINBRIDGE ST.
Atddismissed
No
7651
Atdid: 7651 • Atd Number: ATD-3-2731 • Bblid: 311484
Atdid
7651
Atd Number
ATD-3-2731
Bblid
311484
Inspectionid
308415
Inspect Date
2020-01-16T00:00:00.000
Atdissuedate
2020-01-16T00:00:00.000
Cb
3
House Num
249
Onstname
BAINBRIDGE ST.
Atddismissed
No
7652
Atdid: 7652 • Atd Number: ATD-3-2732 • Bblid: 447983
Atdid
7652
Atd Number
ATD-3-2732
Bblid
447983
Inspectionid
308544
Inspect Date
2020-01-14T00:00:00.000
Atdissuedate
2020-01-14T00:00:00.000
Cb
10
House Num
368
Onstname
78TH ST.
Atddismissed
No
7653
Atdid: 7653 • Atd Number: ATD-3-2733 • Bblid: 447943
Atdid
7653
Atd Number
ATD-3-2733
Bblid
447943
Inspectionid
308555
Inspect Date
2020-01-14T00:00:00.000
Atdissuedate
2020-01-14T00:00:00.000
Cb
10
House Num
318
Onstname
78TH ST.
Atddismissed
No
7654
Atdid: 7654 • Atd Number: ATD-3-2734 • Bblid: 484901
Atdid
7654
Atd Number
ATD-3-2734
Bblid
484901
Inspectionid
308556
Inspect Date
2020-01-16T00:00:00.000
Atdissuedate
2020-01-16T00:00:00.000
Cb
15
House Num
1744
Onstname
E. 24TH ST.
Atddismissed
No
7655
Atdid: 7655 • Atd Number: ATD-2-763 • Bblid: 240854
Atdid
7655
Atd Number
ATD-2-763
Bblid
240854
Inspectionid
308599
Inspect Date
2020-01-17T00:00:00.000
Atdissuedate
2020-01-17T00:00:00.000
Cb
10
House Num
96
Onstname
REYNOLDS ST.
Atddismissed
No
7656
Atdid: 7656 • Atd Number: ATD-3-2735 • Bblid: 452064
Atdid
7656
Atd Number
ATD-3-2735
Bblid
452064
Inspectionid
308879
Inspect Date
2020-01-23T00:00:00.000
Atdissuedate
2020-01-23T00:00:00.000
Cb
10
House Num
75
Onstname
GELSTON AVE.
Atddismissed
No
7657
Atdid: 7657 • Atd Number: ATD-3-2736 • Bblid: 452068
Atdid
7657
Atd Number
ATD-3-2736
Bblid
452068
Inspectionid
308881
Inspect Date
2020-01-23T00:00:00.000
Atdissuedate
2020-01-23T00:00:00.000
Cb
10
House Num
71
Onstname
GELSTON AVE.
Atddismissed
No
7658
Atdid: 7658 • Atd Number: ATD-3-2737 • Bblid: 451963
Atdid
7658
Atd Number
ATD-3-2737
Bblid
451963
Inspectionid
308894
Inspect Date
2020-01-23T00:00:00.000
Atdissuedate
2020-01-23T00:00:00.000
Cb
10
House Num
516
Onstname
88TH ST.
Atddismissed
No
7659
Atdid: 7659 • Atd Number: ATD-3-2738 • Bblid: 451965
Atdid
7659
Atd Number
ATD-3-2738
Bblid
451965
Inspectionid
308896
Inspect Date
2020-01-23T00:00:00.000
Atdissuedate
2020-01-23T00:00:00.000
Cb
10
House Num
518
Onstname
88TH ST.
Atddismissed
No
7660
Atdid: 7660 • Atd Number: ATD-3-2739 • Bblid: 434767
Atdid
7660
Atd Number
ATD-3-2739
Bblid
434767
Inspectionid
308902
Inspect Date
2020-01-23T00:00:00.000
Atdissuedate
2020-01-23T00:00:00.000
Cb
12
House Num
5317
Onstname
12TH AVE.
Atddismissed
No
7661
Atdid: 7661 • Atd Number: ATD-3-2740 • Bblid: 453948
Atdid
7661
Atd Number
ATD-3-2740
Bblid
453948
Inspectionid
308916
Inspect Date
2020-01-24T00:00:00.000
Atdissuedate
2020-01-24T00:00:00.000
Cb
10
House Num
157
Onstname
MARINE AVE.
Atddismissed
No
7662
Atdid: 7662 • Atd Number: ATD-4-3551 • Bblid: 754598
Atdid
7662
Atd Number
ATD-4-3551
Bblid
754598
Inspectionid
308953
Inspect Date
2020-01-23T00:00:00.000
Atdissuedate
2020-01-23T00:00:00.000
Cb
11
House Num
58-32
Onstname
218TH ST.
Atddismissed
No
7663
Atdid: 7663 • Atd Number: ATD-4-3552 • Bblid: 754596
Atdid
7663
Atd Number
ATD-4-3552
Bblid
754596
Inspectionid
308954
Inspect Date
2020-01-23T00:00:00.000
Atdissuedate
2020-01-23T00:00:00.000
Cb
11
House Num
58-28
Onstname
218TH ST.
Atddismissed
No
7664
Atdid: 7664 • Atd Number: ATD-3-2741 • Bblid: 447842
Atdid
7664
Atd Number
ATD-3-2741
Bblid
447842
Inspectionid
309016
Inspect Date
2020-01-15T00:00:00.000
Atdissuedate
2020-01-15T00:00:00.000
Cb
10
House Num
216
Onstname
78TH ST.
Atddismissed
No
7665
Atdid: 7665 • Atd Number: ATD-3-2742 • Bblid: 449960
Atdid
7665
Atd Number
ATD-3-2742
Bblid
449960
Inspectionid
309074
Inspect Date
2020-01-16T00:00:00.000
Atdissuedate
2020-01-16T00:00:00.000
Cb
10
House Num
118
Onstname
83RD ST.
Atddismissed
No
7666
Atdid: 7666 • Atd Number: ATD-3-2743 • Bblid: 449958
Atdid
7666
Atd Number
ATD-3-2743
Bblid
449958
Inspectionid
309075
Inspect Date
2020-01-16T00:00:00.000
Atdissuedate
2020-01-16T00:00:00.000
Cb
10
House Num
114
Onstname
83RD ST.
Atddismissed
No
7667
Atdid: 7667 • Atd Number: ATD-4-3553 • Bblid: 787905
Atdid
7667
Atd Number
ATD-4-3553
Bblid
787905
Inspectionid
309150
Inspect Date
2020-01-17T00:00:00.000
Atdissuedate
2020-01-17T00:00:00.000
Cb
9
House Num
85-34
Onstname
107TH ST.
Atddismissed
No
7668
Atdid: 7668 • Atd Number: ATD-4-3554 • Bblid: 787911
Atdid
7668
Atd Number
ATD-4-3554
Bblid
787911
Inspectionid
309156
Inspect Date
2020-01-17T00:00:00.000
Atdissuedate
2020-01-17T00:00:00.000
Cb
9
House Num
85-42
Onstname
107TH ST.
Atddismissed
No
7669
Atdid: 7669 • Atd Number: ATD-4-3555 • Bblid: 787903
Atdid
7669
Atd Number
ATD-4-3555
Bblid
787903
Inspectionid
309158
Inspect Date
2020-01-17T00:00:00.000
Atdissuedate
2020-01-17T00:00:00.000
Cb
9
House Num
85-28
Onstname
107TH ST.
Atddismissed
No
7670
Atdid: 7670 • Atd Number: ATD-4-3556 • Bblid: 787893
Atdid
7670
Atd Number
ATD-4-3556
Bblid
787893
Inspectionid
309163
Inspect Date
2020-01-17T00:00:00.000
Atdissuedate
2020-01-17T00:00:00.000
Cb
9
House Num
85-10
Onstname
107TH ST.
Atddismissed
No
7671
Atdid: 7671 • Atd Number: ATD-3-2744 • Bblid: 283272
Atdid
7671
Atd Number
ATD-3-2744
Bblid
283272
Inspectionid
309184
Inspect Date
2019-10-02T00:00:00.000
Atdissuedate
2019-10-02T00:00:00.000
Cb
6
House Num
563
Onstname
9TH ST.
Atddismissed
No
7672
Atdid: 7672 • Atd Number: ATD-4-3557 • Bblid: 763647
Atdid
7672
Atd Number
ATD-4-3557
Bblid
763647
Inspectionid
309227
Inspect Date
2020-01-30T00:00:00.000
Atdissuedate
2020-01-30T00:00:00.000
Cb
11
House Num
247-12
Onstname
41ST AVE.
Atddismissed
No
7673
Atdid: 7673 • Atd Number: ATD-4-3558 • Bblid: 605062
Atdid
7673
Atd Number
ATD-4-3558
Bblid
605062
Inspectionid
309262
Inspect Date
2020-01-14T00:00:00.000
Atdissuedate
2020-01-14T00:00:00.000
Cb
3
House Num
25-37
Onstname
90TH ST.
Atddismissed
No
7674
Atdid: 7674 • Atd Number: ATD-4-3559 • Bblid: 605054
Atdid
7674
Atd Number
ATD-4-3559
Bblid
605054
Inspectionid
309266
Inspect Date
2020-01-17T00:00:00.000
Atdissuedate
2020-01-17T00:00:00.000
Cb
3
House Num
25-53
Onstname
90TH ST.
Atddismissed
No
7675
Atdid: 7675 • Atd Number: ATD-3-2745 • Bblid: 305040
Atdid
7675
Atd Number
ATD-3-2745
Bblid
305040
Inspectionid
309278
Inspect Date
2020-01-08T00:00:00.000
Atdissuedate
2020-01-08T00:00:00.000
Cb
3
House Num
1051
Onstname
HERKIMER ST.
Atddismissed
No
7676
Atdid: 7676 • Atd Number: ATD-3-2746 • Bblid: 305038
Atdid
7676
Atd Number
ATD-3-2746
Bblid
305038
Inspectionid
309279
Inspect Date
2020-01-08T00:00:00.000
Atdissuedate
2020-01-08T00:00:00.000
Cb
3
House Num
1053
Onstname
HERKIMER ST.
Atddismissed
No
7677
Atdid: 7677 • Atd Number: ATD-3-2747 • Bblid: 305036
Atdid
7677
Atd Number
ATD-3-2747
Bblid
305036
Inspectionid
309280
Inspect Date
2020-01-08T00:00:00.000
Atdissuedate
2020-01-08T00:00:00.000
Cb
3
House Num
1055
Onstname
HERKIMER ST.
Atddismissed
No
7678
Atdid: 7678 • Atd Number: ATD-3-2748 • Bblid: 305028
Atdid
7678
Atd Number
ATD-3-2748
Bblid
305028
Inspectionid
309284
Inspect Date
2020-01-08T00:00:00.000
Atdissuedate
2020-01-08T00:00:00.000
Cb
3
House Num
1063
Onstname
HERKIMER ST.
Atddismissed
No
7679
Atdid: 7679 • Atd Number: ATD-3-2749 • Bblid: 305026
Atdid
7679
Atd Number
ATD-3-2749
Bblid
305026
Inspectionid
309285
Inspect Date
2020-01-08T00:00:00.000
Atdissuedate
2020-01-08T00:00:00.000
Cb
3
House Num
1065
Onstname
HERKIMER ST.
Atddismissed
No
7680
Atdid: 7680 • Atd Number: ATD-3-2750 • Bblid: 305022
Atdid
7680
Atd Number
ATD-3-2750
Bblid
305022
Inspectionid
309287
Inspect Date
2020-01-09T00:00:00.000
Atdissuedate
2020-01-09T00:00:00.000
Cb
3
House Num
1069
Onstname
HERKIMER ST.
Atddismissed
No
7681
Atdid: 7681 • Atd Number: ATD-3-2751 • Bblid: 305020
Atdid
7681
Atd Number
ATD-3-2751
Bblid
305020
Inspectionid
309288
Inspect Date
2020-01-09T00:00:00.000
Atdissuedate
2020-01-09T00:00:00.000
Cb
3
House Num
1071
Onstname
HERKIMER ST.
Atddismissed
No
7682
Atdid: 7682 • Atd Number: ATD-3-2752 • Bblid: 305018
Atdid
7682
Atd Number
ATD-3-2752
Bblid
305018
Inspectionid
309289
Inspect Date
2020-01-09T00:00:00.000
Atdissuedate
2020-01-09T00:00:00.000
Cb
3
House Num
1073
Onstname
HERKIMER ST.
Atddismissed
No
7683
Atdid: 7683 • Atd Number: ATD-3-2753 • Bblid: 305016
Atdid
7683
Atd Number
ATD-3-2753
Bblid
305016
Inspectionid
309290
Inspect Date
2020-01-09T00:00:00.000
Atdissuedate
2020-01-09T00:00:00.000
Cb
3
House Num
1075
Onstname
HERKIMER ST.
Atddismissed
No
7684
Atdid: 7684 • Atd Number: ATD-3-2754 • Bblid: 305014
Atdid
7684
Atd Number
ATD-3-2754
Bblid
305014
Inspectionid
309291
Inspect Date
2020-01-09T00:00:00.000
Atdissuedate
2020-01-09T00:00:00.000
Cb
3
House Num
1077
Onstname
HERKIMER ST.
Atddismissed
No
7685
Atdid: 7685 • Atd Number: ATD-3-2755 • Bblid: 304994
Atdid
7685
Atd Number
ATD-3-2755
Bblid
304994
Inspectionid
309301
Inspect Date
2020-01-09T00:00:00.000
Atdissuedate
2020-01-09T00:00:00.000
Cb
3
House Num
1095
Onstname
HERKIMER ST.
Atddismissed
No
7686
Atdid: 7686 • Atd Number: ATD-3-2756 • Bblid: 305060
Atdid
7686
Atd Number
ATD-3-2756
Bblid
305060
Inspectionid
309306
Inspect Date
2020-01-09T00:00:00.000
Atdissuedate
2020-01-09T00:00:00.000
Cb
3
House Num
1105
Onstname
HERKIMER ST.
Atddismissed
No
7687
Atdid: 7687 • Atd Number: ATD-3-2757 • Bblid: 305058
Atdid
7687
Atd Number
ATD-3-2757
Bblid
305058
Inspectionid
309307
Inspect Date
2020-01-09T00:00:00.000
Atdissuedate
2020-01-09T00:00:00.000
Cb
3
House Num
1107
Onstname
HERKIMER ST.
Atddismissed
No
7688
Atdid: 7688 • Atd Number: ATD-3-2758 • Bblid: 493305
Atdid
7688
Atd Number
ATD-3-2758
Bblid
493305
Inspectionid
309331
Inspect Date
2020-01-28T00:00:00.000
Atdissuedate
2020-01-28T00:00:00.000
Cb
11
House Num
1943
Onstname
W. 13TH ST.
Atddismissed
No
7689
Atdid: 7689 • Atd Number: ATD-4-3560 • Bblid: 717790
Atdid
7689
Atd Number
ATD-4-3560
Bblid
717790
Inspectionid
309455
Inspect Date
2020-01-23T00:00:00.000
Atdissuedate
2020-01-23T00:00:00.000
Cb
11
House Num
175-40
Onstname
UNDERHILL AVE.
Atddismissed
No
7690
Atdid: 7690 • Atd Number: ATD-4-3561 • Bblid: 605064
Atdid
7690
Atd Number
ATD-4-3561
Bblid
605064
Inspectionid
309492
Inspect Date
2020-01-28T00:00:00.000
Atdissuedate
2020-01-28T00:00:00.000
Cb
3
House Num
25-33
Onstname
90TH ST.
Atddismissed
No
7691
Atdid: 7691 • Atd Number: ATD-4-3562 • Bblid: 605068
Atdid
7691
Atd Number
ATD-4-3562
Bblid
605068
Inspectionid
309494
Inspect Date
2020-01-29T00:00:00.000
Atdissuedate
2020-01-29T00:00:00.000
Cb
3
House Num
25-25
Onstname
90TH ST.
Atddismissed
No
7692
Atdid: 7692 • Atd Number: ATD-3-2759 • Bblid: 373631
Atdid
7692
Atd Number
ATD-3-2759
Bblid
373631
Inspectionid
309501
Inspect Date
2020-01-29T00:00:00.000
Atdissuedate
2020-01-29T00:00:00.000
Cb
5
House Num
55
Onstname
VAN SICLEN AVE.
Atddismissed
No
7693
Atdid: 7693 • Atd Number: ATD-4-3563 • Bblid: 783894
Atdid
7693
Atd Number
ATD-4-3563
Bblid
783894
Inspectionid
309546
Inspect Date
2020-01-24T00:00:00.000
Atdissuedate
2020-01-24T00:00:00.000
Cb
9
House Num
97-27
Onstname
88TH ST.
Atddismissed
No