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
7694
Atdid: 7694 • Atd Number: ATD-2-764 • Bblid: 150240
Atdid
7694
Atd Number
ATD-2-764
Bblid
150240
Inspectionid
309576
Inspect Date
2020-01-31T00:00:00.000
Atdissuedate
2020-01-31T00:00:00.000
Cb
2
House Num
866
Onstname
MANIDA ST.
Atddismissed
No
7695
Atdid: 7695 • Atd Number: ATD-2-765 • Bblid: 150232
Atdid
7695
Atd Number
ATD-2-765
Bblid
150232
Inspectionid
309580
Inspect Date
2020-01-31T00:00:00.000
Atdissuedate
2020-01-31T00:00:00.000
Cb
2
House Num
856
Onstname
MANIDA ST.
Atddismissed
No
7696
Atdid: 7696 • Atd Number: ATD-2-766 • Bblid: 150178
Atdid
7696
Atd Number
ATD-2-766
Bblid
150178
Inspectionid
309586
Inspect Date
2020-01-31T00:00:00.000
Atdissuedate
2020-01-31T00:00:00.000
Cb
2
House Num
832
Onstname
MANIDA ST.
Atddismissed
No
7697
Atdid: 7697 • Atd Number: ATD-2-767 • Bblid: 150172
Atdid
7697
Atd Number
ATD-2-767
Bblid
150172
Inspectionid
309589
Inspect Date
2020-01-31T00:00:00.000
Atdissuedate
2020-01-31T00:00:00.000
Cb
2
House Num
826
Onstname
MANIDA ST.
Atddismissed
No
7698
Atdid: 7698 • Atd Number: ATD-4-3564 • Bblid: 640684
Atdid
7698
Atd Number
ATD-4-3564
Bblid
640684
Inspectionid
309598
Inspect Date
2020-02-04T00:00:00.000
Atdissuedate
2020-02-04T00:00:00.000
Cb
5
House Num
59-81
Onstname
FRESH POND RD.
Atddismissed
No
7699
Atdid: 7699 • Atd Number: ATD-3-2760 • Bblid: 511815
Atdid
7699
Atd Number
ATD-3-2760
Bblid
511815
Inspectionid
309641
Inspect Date
2020-02-04T00:00:00.000
Atdissuedate
2020-02-04T00:00:00.000
Cb
15
House Num
2608
Onstname
AVENUE Y.
Atddismissed
No
7700
Atdid: 7700 • Atd Number: ATD-3-2761 • Bblid: 286512
Atdid
7700
Atd Number
ATD-3-2761
Bblid
286512
Inspectionid
309698
Inspect Date
2020-01-31T00:00:00.000
Atdissuedate
2020-01-31T00:00:00.000
Cb
8
House Num
210
Onstname
SAINT MARKS AVE.
Atddismissed
No
7701
Atdid: 7701 • Atd Number: ATD-2-768 • Bblid: 181427
Atdid
7701
Atd Number
ATD-2-768
Bblid
181427
Inspectionid
309760
Inspect Date
2020-01-22T00:00:00.000
Atdissuedate
2020-01-22T00:00:00.000
Cb
9
House Num
1565
Onstname
LELAND AVE.
Atddismissed
No
7702
Atdid: 7702 • Atd Number: ATD-3-2762 • Bblid: 281935
Atdid
7702
Atd Number
ATD-3-2762
Bblid
281935
Inspectionid
309995
Inspect Date
2020-02-04T00:00:00.000
Atdissuedate
2020-02-04T00:00:00.000
Cb
6
House Num
828
Onstname
PRESIDENT STREET
Atddismissed
No
7703
Atdid: 7703 • Atd Number: ATD-3-2763 • Bblid: 281961
Atdid
7703
Atd Number
ATD-3-2763
Bblid
281961
Inspectionid
310007
Inspect Date
2020-02-04T00:00:00.000
Atdissuedate
2020-02-04T00:00:00.000
Cb
6
House Num
854
Onstname
PRESIDENT ST.
Atddismissed
No
7705
Atdid: 7705 • Atd Number: ATD-3-2765 • Bblid: 309134
Atdid
7705
Atd Number
ATD-3-2765
Bblid
309134
Inspectionid
310025
Inspect Date
2020-02-12T00:00:00.000
Atdissuedate
2020-02-12T00:00:00.000
Cb
3
House Num
581
Onstname
JEFFERSON AVE.
Atddismissed
No
7706
Atdid: 7706 • Atd Number: ATD-4-3565 • Bblid: 747141
Atdid
7706
Atd Number
ATD-4-3565
Bblid
747141
Inspectionid
310193
Inspect Date
2020-02-14T00:00:00.000
Atdissuedate
2020-02-14T00:00:00.000
Cb
8
House Num
69-12
Onstname
199TH ST.
Atddismissed
No
7707
Atdid: 7707 • Atd Number: ATD-4-3566 • Bblid: 747145
Atdid
7707
Atd Number
ATD-4-3566
Bblid
747145
Inspectionid
310194
Inspect Date
2020-02-14T00:00:00.000
Atdissuedate
2020-02-14T00:00:00.000
Cb
8
House Num
69-18
Onstname
199TH ST.
Atddismissed
No
7708
Atdid: 7708 • Atd Number: ATD-4-3567 • Bblid: 747157
Atdid
7708
Atd Number
ATD-4-3567
Bblid
747157
Inspectionid
310195
Inspect Date
2020-02-14T00:00:00.000
Atdissuedate
2020-02-14T00:00:00.000
Cb
8
House Num
69-34
Onstname
199TH ST.
Atddismissed
No
7709
Atdid: 7709 • Atd Number: ATD-4-3568 • Bblid: 747159
Atdid
7709
Atd Number
ATD-4-3568
Bblid
747159
Inspectionid
310196
Inspect Date
2020-02-14T00:00:00.000
Atdissuedate
2020-02-14T00:00:00.000
Cb
8
House Num
69-36
Onstname
199TH ST.
Atddismissed
No
7710
Atdid: 7710 • Atd Number: ATD-5-473 • Bblid: 940033
Atdid
7710
Atd Number
ATD-5-473
Bblid
940033
Inspectionid
310200
Inspect Date
2020-02-14T00:00:00.000
Atdissuedate
2020-02-14T00:00:00.000
Cb
1
House Num
112
Onstname
WARREN ST.
Atddismissed
No
7711
Atdid: 7711 • Atd Number: ATD-4-3569 • Bblid: 755646
Atdid
7711
Atd Number
ATD-4-3569
Bblid
755646
Inspectionid
310306
Inspect Date
2020-02-12T00:00:00.000
Atdissuedate
2020-02-12T00:00:00.000
Cb
11
House Num
223-51
Onstname
56TH RD.
Atddismissed
No
7712
Atdid: 7712 • Atd Number: ATD-4-3570 • Bblid: 763967
Atdid
7712
Atd Number
ATD-4-3570
Bblid
763967
Inspectionid
310407
Inspect Date
2020-02-08T00:00:00.000
Atdissuedate
2020-02-08T00:00:00.000
Cb
11
House Num
250-32
Onstname
42ND AVE.
Atddismissed
No
7713
Atdid: 7713 • Atd Number: ATD-4-3571 • Bblid: 763953
Atdid
7713
Atd Number
ATD-4-3571
Bblid
763953
Inspectionid
310414
Inspect Date
2020-02-08T00:00:00.000
Atdissuedate
2020-02-08T00:00:00.000
Cb
11
House Num
251-15
Onstname
43RD AVE.
Atddismissed
No
7714
Atdid: 7714 • Atd Number: ATD-4-3572 • Bblid: 763961
Atdid
7714
Atd Number
ATD-4-3572
Bblid
763961
Inspectionid
310416
Inspect Date
2020-02-08T00:00:00.000
Atdissuedate
2020-02-08T00:00:00.000
Cb
11
House Num
250-22
Onstname
42ND AVE.
Atddismissed
No
7715
Atdid: 7715 • Atd Number: ATD-3-2766 • Bblid: 476376
Atdid
7715
Atd Number
ATD-3-2766
Bblid
476376
Inspectionid
310420
Inspect Date
2020-01-23T00:00:00.000
Atdissuedate
2020-01-23T00:00:00.000
Cb
15
House Num
1740
Onstname
E. 2ND ST.
Atddismissed
No
7716
Atdid: 7716 • Atd Number: ATD-5-474 • Bblid: 938331
Atdid
7716
Atd Number
ATD-5-474
Bblid
938331
Inspectionid
310508
Inspect Date
2020-02-21T00:00:00.000
Atdissuedate
2020-02-21T00:00:00.000
Cb
1
House Num
256
Onstname
BRYSON AVE.
Atddismissed
No
7717
Atdid: 7717 • Atd Number: ATD-5-475 • Bblid: 938333
Atdid
7717
Atd Number
ATD-5-475
Bblid
938333
Inspectionid
310509
Inspect Date
2020-02-21T00:00:00.000
Atdissuedate
2020-02-21T00:00:00.000
Cb
1
House Num
260
Onstname
BRYSON AVE.
Atddismissed
No
7718
Atdid: 7718 • Atd Number: ATD-3-2767 • Bblid: 295020
Atdid
7718
Atd Number
ATD-3-2767
Bblid
295020
Inspectionid
310541
Inspect Date
2020-02-21T00:00:00.000
Atdissuedate
2020-02-21T00:00:00.000
Cb
9
House Num
103
Onstname
LEFFERTS AVE.
Atddismissed
No
7719
Atdid: 7719 • Atd Number: ATD-3-2768 • Bblid: 263998
Atdid
7719
Atd Number
ATD-3-2768
Bblid
263998
Inspectionid
310603
Inspect Date
2020-02-19T00:00:00.000
Atdissuedate
2020-02-19T00:00:00.000
Cb
7
House Num
153
Onstname
31ST ST.
Atddismissed
No
7720
Atdid: 7720 • Atd Number: ATD-4-3573 • Bblid: 755654
Atdid
7720
Atd Number
ATD-4-3573
Bblid
755654
Inspectionid
310731
Inspect Date
2020-02-21T00:00:00.000
Atdissuedate
2020-02-21T00:00:00.000
Cb
11
House Num
223-39
Onstname
56TH RD.
Atddismissed
No
7721
Atdid: 7721 • Atd Number: ATD-3-2769 • Bblid: 382865
Atdid
7721
Atd Number
ATD-3-2769
Bblid
382865
Inspectionid
310758
Inspect Date
2020-02-05T00:00:00.000
Atdissuedate
2020-02-05T00:00:00.000
Cb
5
House Num
1117
Onstname
GLENMORE AVE.
Atddismissed
No
7722
Atdid: 7722 • Atd Number: ATD-3-2770 • Bblid: 382879
Atdid
7722
Atd Number
ATD-3-2770
Bblid
382879
Inspectionid
310760
Inspect Date
2020-02-05T00:00:00.000
Atdissuedate
2020-02-05T00:00:00.000
Cb
5
House Num
1099
Onstname
GLENMORE AVE.
Atddismissed
No
7723
Atdid: 7723 • Atd Number: ATD-3-2771 • Bblid: 382873
Atdid
7723
Atd Number
ATD-3-2771
Bblid
382873
Inspectionid
310761
Inspect Date
2020-02-05T00:00:00.000
Atdissuedate
2020-02-05T00:00:00.000
Cb
5
House Num
1107
Onstname
GLENMORE AVE.
Atddismissed
No
7724
Atdid: 7724 • Atd Number: ATD-3-2772 • Bblid: 382867
Atdid
7724
Atd Number
ATD-3-2772
Bblid
382867
Inspectionid
310764
Inspect Date
2020-02-05T00:00:00.000
Atdissuedate
2020-02-05T00:00:00.000
Cb
5
House Num
1113
Onstname
GLENMORE AVE.
Atddismissed
No
7725
Atdid: 7725 • Atd Number: ATD-5-476 • Bblid: 933792
Atdid
7725
Atd Number
ATD-5-476
Bblid
933792
Inspectionid
311021
Inspect Date
2020-02-25T00:00:00.000
Atdissuedate
2020-02-25T00:00:00.000
Cb
1
House Num
52
Onstname
SANFORD PL.
Atddismissed
No
7726
Atdid: 7726 • Atd Number: ATD-5-477 • Bblid: 932127
Atdid
7726
Atd Number
ATD-5-477
Bblid
932127
Inspectionid
311023
Inspect Date
2020-02-25T00:00:00.000
Atdissuedate
2020-02-25T00:00:00.000
Cb
1
House Num
156
Onstname
WHITEWOOD AVE.
Atddismissed
No
7727
Atdid: 7727 • Atd Number: ATD-5-478 • Bblid: 932123
Atdid
7727
Atd Number
ATD-5-478
Bblid
932123
Inspectionid
311027
Inspect Date
2020-02-25T00:00:00.000
Atdissuedate
2020-02-25T00:00:00.000
Cb
1
House Num
763
Onstname
PELTON AVENUE
Atddismissed
No
7728
Atdid: 7728 • Atd Number: ATD-5-479 • Bblid: 932058
Atdid
7728
Atd Number
ATD-5-479
Bblid
932058
Inspectionid
311066
Inspect Date
2020-02-26T00:00:00.000
Atdissuedate
2020-02-26T00:00:00.000
Cb
1
House Num
795
Onstname
DAVIS AVE.
Atddismissed
No
7729
Atdid: 7729 • Atd Number: ATD-5-480 • Bblid: 932056
Atdid
7729
Atd Number
ATD-5-480
Bblid
932056
Inspectionid
311067
Inspect Date
2020-02-26T00:00:00.000
Atdissuedate
2020-02-26T00:00:00.000
Cb
1
House Num
799
Onstname
DAVIS AVE.
Atddismissed
No
7730
Atdid: 7730 • Atd Number: ATD-5-481 • Bblid: 932054
Atdid
7730
Atd Number
ATD-5-481
Bblid
932054
Inspectionid
311068
Inspect Date
2020-02-26T00:00:00.000
Atdissuedate
2020-02-26T00:00:00.000
Cb
1
House Num
803
Onstname
DAVIS AVE.
Atddismissed
No
7731
Atdid: 7731 • Atd Number: ATD-3-2773 • Bblid: 303577
Atdid
7731
Atd Number
ATD-3-2773
Bblid
303577
Inspectionid
311137
Inspect Date
2020-02-26T00:00:00.000
Atdissuedate
2020-02-26T00:00:00.000
Cb
3
House Num
280
Onstname
MARION ST.
Atddismissed
No
7732
Atdid: 7732 • Atd Number: ATD-4-3574 • Bblid: 763728
Atdid
7732
Atd Number
ATD-4-3574
Bblid
763728
Inspectionid
311145
Inspect Date
2020-02-27T00:00:00.000
Atdissuedate
2020-02-27T00:00:00.000
Cb
11
House Num
41-11
Onstname
249TH ST.
Atddismissed
No
7733
Atdid: 7733 • Atd Number: ATD-5-482 • Bblid: 1011229
Atdid
7733
Atd Number
ATD-5-482
Bblid
1011229
Inspectionid
311209
Inspect Date
2020-02-28T00:00:00.000
Atdissuedate
2020-02-28T00:00:00.000
Cb
3
House Num
547
Onstname
RIGA ST.
Atddismissed
No
7734
Atdid: 7734 • Atd Number: ATD-4-3575 • Bblid: 763680
Atdid
7734
Atd Number
ATD-4-3575
Bblid
763680
Inspectionid
311222
Inspect Date
2020-02-28T00:00:00.000
Atdissuedate
2020-02-28T00:00:00.000
Cb
11
House Num
42-09
Onstname
249TH ST.
Atddismissed
No
7735
Atdid: 7735 • Atd Number: ATD-4-3576 • Bblid: 763686
Atdid
7735
Atd Number
ATD-4-3576
Bblid
763686
Inspectionid
311225
Inspect Date
2020-02-28T00:00:00.000
Atdissuedate
2020-02-28T00:00:00.000
Cb
11
House Num
42-15
Onstname
249TH ST.
Atddismissed
No
7736
Atdid: 7736 • Atd Number: ATD-2-769 • Bblid: 172917
Atdid
7736
Atd Number
ATD-2-769
Bblid
172917
Inspectionid
311264
Inspect Date
2020-02-28T00:00:00.000
Atdissuedate
2020-02-28T00:00:00.000
Cb
9
House Num
650
Onstname
ROSEDALE AVE.
Atddismissed
No
7737
Atdid: 7737 • Atd Number: ATD-4-3577 • Bblid: 763718
Atdid
7737
Atd Number
ATD-4-3577
Bblid
763718
Inspectionid
311269
Inspect Date
2020-02-27T00:00:00.000
Atdissuedate
2020-02-27T00:00:00.000
Cb
11
House Num
41-55
Onstname
249TH ST.
Atddismissed
No
7738
Atdid: 7738 • Atd Number: ATD-4-3578 • Bblid: 763719
Atdid
7738
Atd Number
ATD-4-3578
Bblid
763719
Inspectionid
311276
Inspect Date
2020-02-27T00:00:00.000
Atdissuedate
2020-02-27T00:00:00.000
Cb
11
House Num
41-51
Onstname
249TH ST.
Atddismissed
No
7739
Atdid: 7739 • Atd Number: ATD-4-3579 • Bblid: 764221
Atdid
7739
Atd Number
ATD-4-3579
Bblid
764221
Inspectionid
311293
Inspect Date
2020-02-26T00:00:00.000
Atdissuedate
2020-02-26T00:00:00.000
Cb
11
House Num
33-17
Onstname
255TH ST.
Atddismissed
No
7740
Atdid: 7740 • Atd Number: ATD-4-3580 • Bblid: 755656
Atdid
7740
Atd Number
ATD-4-3580
Bblid
755656
Inspectionid
311319
Inspect Date
2020-02-25T00:00:00.000
Atdissuedate
2020-02-25T00:00:00.000
Cb
11
House Num
223-35
Onstname
56TH RD.
Atddismissed
No
7741
Atdid: 7741 • Atd Number: ATD-4-3581 • Bblid: 755664
Atdid
7741
Atd Number
ATD-4-3581
Bblid
755664
Inspectionid
311322
Inspect Date
2020-02-26T00:00:00.000
Atdissuedate
2020-02-26T00:00:00.000
Cb
11
House Num
223-23
Onstname
56TH RD.
Atddismissed
No
7742
Atdid: 7742 • Atd Number: ATD-2-770 • Bblid: 235190
Atdid
7742
Atd Number
ATD-2-770
Bblid
235190
Inspectionid
311462
Inspect Date
2020-02-28T00:00:00.000
Atdissuedate
2020-02-28T00:00:00.000
Cb
10
House Num
2979
Onstname
LAWTON AVE.
Atddismissed
No
7744
Atdid: 7744 • Atd Number: ATD-3-2774 • Bblid: 443472
Atdid
7744
Atd Number
ATD-3-2774
Bblid
443472
Inspectionid
311512
Inspect Date
2020-02-25T00:00:00.000
Atdissuedate
2020-02-25T00:00:00.000
Cb
10
House Num
258
Onstname
OVINGTON AVE.
Atddismissed
No
7745
Atdid: 7745 • Atd Number: ATD-3-2775 • Bblid: 443474
Atdid
7745
Atd Number
ATD-3-2775
Bblid
443474
Inspectionid
311513
Inspect Date
2020-02-27T00:00:00.000
Atdissuedate
2020-02-27T00:00:00.000
Cb
10
House Num
260
Onstname
OVINGTON AVE.
Atddismissed
No