Street_Tree_List

Data source: data.sfgov.org

170 rows where qSpecies = 96 sorted by Location

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▼
11975 105023 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 761 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   6002706.48951 2088960.92893 37.7160423584316 -122.432578526497 (37.7160423584316, -122.432578526497)
11816 56918 Permitted Site 1 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 757 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/14/1974 12:00:00 AM 8 3x3 Permit Number 14160 6002721.67474 2088983.8970400002 37.716106284944 -122.432527678806 (37.716106284944, -122.432527678806)
92915 84676 Permitted Site 1 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 25 Josiah Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2007 12:00:00 AM   3x3 Permit Number 49727 5996908.75152474 2089951.72351373 37.718432356708796 -122.45268961212099 (37.7184323567088, -122.452689612121)
101946 106725 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 421 CAMBRIDGE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       2x2   6006955.4 2092560.1 37.7261649524701 -122.418147266884 (37.7261649524701, -122.418147266884)
149842 213873 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 59 Eastwood Dr 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5995622.40469 2093021.42815 37.7267872433344 -122.45735790654301 (37.7267872433344, -122.457357906543)
64604 213872 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 59 Eastwood Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   5995621.30563 2093030.0501400002 37.7268108541226 -122.45736232942801 (37.7268108541226, -122.457362329428)
60149 213871 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 59 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   5995619.92029 2093040.27058 37.726838837427394 -122.457367857563 (37.7268388374274, -122.457367857563)
56473 213904 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 82 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5995638.93402 2093163.65377 37.727178710112796 -122.457311050068 (37.7271787101128, -122.457311050068)
35517 213903 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 82 Eastwood Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5995638.7479 2093177.24169 37.727216008587206 -122.45731267605301 (37.7272160085872, -122.457312676053)
172670 213901 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 95 Westwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5995124.969409999 2093273.24619 37.7274500913228 -122.459095741174 (37.7274500913228, -122.459095741174)
44958 213902 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 251 Wildwood Way 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5995694.04842 2093291.08185 37.727531762375605 -122.457129735051 (37.7275317623756, -122.457129735051)
38902 213906 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1434 Plymouth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995899.59842 2093547.7186200002 37.728248227952704 -122.456437701364 (37.7282482279527, -122.456437701364)
177111 213905 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1434 Plymouth Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5995905.10598 2093569.6319099998 37.72830871277029 -122.456420245524 (37.7283087127703, -122.456420245524)
51962 213878 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1 Northgate Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5994368.96004 2093846.3092 37.7289800926592 -122.46175078268699 (37.7289800926592, -122.461750782687)
150175 213877 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 31 Northgate Dr 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5994375.023440001 2093863.2353400001 37.729026916755295 -122.461731047976 (37.7290269167553, -122.461731047976)
181127 213876 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 31 Northgate Dr 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5994382.65367 2093880.64548 37.729075159987296 -122.461705931702 (37.7290751599873, -122.461705931702)
38823 213875 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 31 Northgate Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5994388.1311099995 2093892.32997 37.729107558052 -122.46168784273998 (37.729107558052, -122.46168784274)
179761 213874 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 31 Northgate Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   5994391.73766 2093905.5180799998 37.7291439769931 -122.461676330511 (37.7291439769931, -122.461676330511)
75148 197021 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 48 Lucy St 1 : 4 Tree 1 Private 1     7 Width 2ft   6014107.2197 2093837.90133 37.730073491982104 -122.39351302630199 (37.7300734919821, -122.393513026302)
188165 213870 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 340 San Leandro Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992329.85759 2094645.8649 37.731057880912104 -122.468858209345 (37.7310578809121, -122.468858209345)
91678 16109 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 300X Monterey Blvd 7 Median : Cutout 11 Tree 1 DPW 2     12 5   6000087.992657701 2094703.0882103 37.731660169421204 -122.44204119171499 (37.7316601694212, -122.442041191715)
145632 16107 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 300X Monterey Blvd 5 Median : Cutout 11 Tree 1 DPW 2     12 5   6000087.992657701 2094703.0882103 37.731660169421204 -122.44204119171499 (37.7316601694212, -122.442041191715)
97527 16188 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 460X Monterey Blvd 5 Median : Cutout 11 Tree 1 DPW 2     3 5   5999032.780474599 2094728.5162104 37.731669798591 -122.445691084837 (37.731669798591, -122.445691084837)
111934 16186 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 460X Monterey Blvd 3 Median : Cutout 11 Tree 1 DPW 2     3 5   5999032.780474599 2094728.5162104 37.731669798591 -122.445691084837 (37.731669798591, -122.445691084837)
85784 16046 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 200X Monterey Blvd 4 Median : Cutout 11 Tree 1 DPW 2     12 5   6000746.7708385 2094693.2718477002 37.731670735926 -122.43976296625401 (37.731670735926, -122.439762966254)
88696 16157 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 400X Monterey Blvd 3 Median : Cutout 11 Tree 1 DPW 2     3 5   5999414.3973652 2094721.8518035999 37.731673280479 -122.44437128480699 (37.731673280479, -122.444371284807)
109184 16158 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 400X Monterey Blvd 4 Median : Cutout 11 Tree 1 DPW 2   04/06/1998 12:00:00 AM 3 5   5999414.3973652 2094721.8518035999 37.731673280479 -122.44437128480699 (37.731673280479, -122.444371284807)
126834 16155 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 400X Monterey Blvd 1 Median : Cutout 11 Tree 1 DPW 2     3 5   5999414.3973652 2094721.8518035999 37.731673280479 -122.44437128480699 (37.731673280479, -122.444371284807)
139515 16160 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 400X Monterey Blvd 6 Median : Cutout 11 Tree 1 DPW 2   02/18/1999 12:00:00 AM 3 5   5999414.3973652 2094721.8518035999 37.731673280479 -122.44437128480699 (37.731673280479, -122.444371284807)
91038 16011 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 100X Monterey Blvd 5 Median : Cutout 11 Tree 1 DPW 2     6 4   6001411.931226401 2094682.0759854 37.7316778334432 -122.437462576871 (37.7316778334432, -122.437462576871)
141148 16008 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 100X Monterey Blvd 2 Median : Cutout 11 Tree 1 DPW 2   04/06/1998 12:00:00 AM 12 8   6001411.931226401 2094682.0759854 37.7316778334432 -122.437462576871 (37.7316778334432, -122.437462576871)
78844 24312 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 258X Monterey Blvd 6 Median : Cutout 11 Tree 1 DPW 2     12     6000364.9354737 2094709.7194476002 37.7316941555853 -122.441084223383 (37.7316941555853, -122.441084223383)
98506 16077 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 258X Monterey Blvd 5 Median : Cutout 11 Tree 1 DPW 2     12 5   6000364.9354737 2094709.7194476002 37.7316941555853 -122.441084223383 (37.7316941555853, -122.441084223383)
108818 16074 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 258X Monterey Blvd 2 Median : Cutout 11 Tree 1 DPW 2     12 5   6000364.9354737 2094709.7194476002 37.7316941555853 -122.441084223383 (37.7316941555853, -122.441084223383)
111702 16076 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 258X Monterey Blvd 4 Median : Cutout 11 Tree 1 DPW 2     12 5   6000364.9354737 2094709.7194476002 37.7316941555853 -122.441084223383 (37.7316941555853, -122.441084223383)
114201 16075 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 258X Monterey Blvd 3 Median : Cutout 11 Tree 1 DPW 2     12 5   6000364.9354737 2094709.7194476002 37.7316941555853 -122.441084223383 (37.7316941555853, -122.441084223383)
127845 16073 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 258X Monterey Blvd 1 Median : Cutout 11 Tree 1 DPW 2     12 5   6000364.9354737 2094709.7194476002 37.7316941555853 -122.441084223383 (37.7316941555853, -122.441084223383)
94639 110388 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 601X JOOST AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998083.0 2094940.0 37.732196210044705 -122.44898987974899 (37.7321962100447, -122.448989879749)
110197 110391 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 601X JOOST AVE 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998083.0 2094940.0 37.732196210044705 -122.44898987974899 (37.7321962100447, -122.448989879749)
120421 110392 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 601X JOOST AVE 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998083.0 2094940.0 37.732196210044705 -122.44898987974899 (37.7321962100447, -122.448989879749)
124276 110389 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 601X JOOST AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998083.0 2094940.0 37.732196210044705 -122.44898987974899 (37.7321962100447, -122.448989879749)
143071 110390 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 601X JOOST AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998083.0 2094940.0 37.732196210044705 -122.44898987974899 (37.7321962100447, -122.448989879749)
112123 16004 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 10X Monterey Blvd 3 Median : Cutout 11 Tree 1 DPW 2     6 8   6002126.588544 2094889.952748 37.732289219947 -122.435006728573 (37.732289219947, -122.435006728573)
75232 239128 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 346 Richland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6006911.82474 2096010.5177799999 37.7356365938626 -122.41854246738701 (37.7356365938626, -122.418542467387)
92010 18658 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 7 Richards Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6016334.44824 2095879.1633400002 37.7358018906208 -122.38595537929599 (37.7358018906208, -122.385955379296)
114263 18659 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 7 Richards Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6016312.43294 2095882.6817 37.7358103329414 -122.386031740711 (37.7358103329414, -122.386031740711)
25766 239129 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 319 Richland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6006586.63568 2096080.71636 37.735811030848204 -122.41967175235901 (37.7358110308482, -122.419671752359)
9432 24299 Permitted Site 1 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 10 Young Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6016330.713428901 2096036.3150308 37.736233190852296 -122.385979243301 (37.7362331908523, -122.385979243301)
9634 59356 Permitted Site 1 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 401 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/20/1981 12:00:00 AM     Permit Number 770924 6003905.57557543 2096316.85188886 37.7363080142655 -122.428958058919 (37.7363080142655, -122.428958058919)
9410 24298 Permitted Site 1 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 7 Young Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6016301.484983 2096086.6955833 37.736369908087795 -122.38608381002399 (37.7363699080878, -122.386083810024)
32032 197020 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 2251 Silver Ave 4 : 4 Tree 1 Private 1     7 Width 3ft   6012818.66799 2096282.81423 37.736715035672496 -122.398139200966 (37.7367150356725, -122.398139200966)
158578 239140 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 479 Andover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007508.73883 2096670.3114099998 37.7374818291124 -122.416525422908 (37.7374818291124, -122.416525422908)
131717 239141 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 479 Andover St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007510.966109999 2096684.13991 37.73751992438871 -122.416518701402 (37.7375199243887, -122.416518701402)
35034 197023 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1609 Kirkwood Ave 2 : 4 Tree 1 Private 1     3 Width 3ft   6015126.90438 2096778.6631 37.738204831888 -122.390193188884 (37.738204831888, -122.390193188884)
149503 197022 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1609 Kirkwood Ave 1 : 4 Tree 1 Private 1     4 Width 3ft   6015117.14922 2096785.42707 37.7382228632804 -122.39022739009701 (37.7382228632804, -122.390227390097)
62234 213895 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 744 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5990568.43351 2097726.13088 37.739413584555 -122.475172476244 (37.739413584555, -122.475172476244)
165229 213893 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 738 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5990593.74457 2097725.59661 37.7394135845647 -122.475084923648 (37.7394135845647, -122.475084923648)
38246 213896 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 750 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5990556.3666 2097726.3856099998 37.7394135845816 -122.475214216469 (37.7394135845816, -122.475214216469)
171128 213894 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 740 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5990581.9781599995 2097726.13845 37.739414390369 -122.47512564584 (37.739414390369, -122.47512564584)
165037 213892 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 734 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5990616.45042 2097727.17 37.7394192206197 -122.475006532441 (37.7394192206197, -122.475006532441)
48141 213891 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 730 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5990628.53589 2097727.79467 37.7394216362019 -122.47496479221701 (37.7394216362019, -122.474964792217)
42889 213890 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 404 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5991686.41791 2097763.49025 37.739580898037204 -122.47130973604999 (37.7395808980372, -122.47130973605)
50509 213889 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 2595 15th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5991720.6166900005 2097822.06078 37.739743696013 -122.471195758689 (37.739743696013, -122.471195758689)
52046 213888 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 2595 15th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5991720.70941 2097838.5992400004 37.739789111779 -122.471196642726 (37.739789111779, -122.471196642726)
176939 213887 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 2567 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5991715.1256 2097973.83861 37.7401601216784 -122.471225799651 (37.7401601216784, -122.471225799651)
187001 213867 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 149 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992890.5132 2098130.93383 37.7406593839363 -122.467173239557 (37.7406593839363, -122.467173239557)
57282 213866 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 149 Wawona St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992897.54808 2098137.40144 37.740677548444 -122.467149385961 (37.740677548444, -122.467149385961)
25214 213865 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 141 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992915.09669 2098161.84312 37.7407456720873 -122.467090486661 (37.7407456720873, -122.467090486661)
134167 213864 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 141 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992921.67848 2098165.7497799997 37.740756778702504 -122.467068013472 (37.7407567787025, -122.467068013472)
34780 213868 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 119 Madrone Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992740.26119 2098324.92506 37.741183360433105 -122.46770685410401 (37.7411833604331, -122.467706854104)
155587 213869 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 119 Madrone Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5992750.5547 2098352.69692 37.74126020928 -122.467673282394 (37.74126020928, -122.467673282394)
180476 213897 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 2365 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5992305.54148 2099333.17505 37.7439266478918 -122.46928331439399 (37.7439266478918, -122.469283314394)
26940 213898 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 521 Dewey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994465.82932 2099713.9197 37.7450966757864 -122.461841193329 (37.7450966757864, -122.461841193329)
84527 22821 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 64 Turquoise Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/01/2008 12:00:00 AM 3 3x3   5998921.4611914 2099744.1843889 37.7454352704129 -122.446436637784 (37.7454352704129, -122.446436637784)
120553 22818 DPW Maintained 3 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 60 Turquoise Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/12/1997 12:00:00 AM 3 3X3   5998904.0126134 2099759.7693507997 37.745477066338 -122.446498092976 (37.745477066338, -122.446498092976)
60442 213899 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 273 Magellan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5994690.46222 2100307.26006 37.746738768579 -122.46110745715599 (37.746738768579, -122.461107457156)
76728 213900 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 273 Magellan Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5994701.36928 2100318.44631 37.7467701108664 -122.461070552565 (37.7467701108664, -122.461070552565)
91652 7587 Permitted Site 1 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 3000X Folsom St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     50 3X3   6008378.51714 2100951.63552 37.7492862752884 -122.41382093686701 (37.7492862752884, -122.413820936867)
45167 241392 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1400 Potrero Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6010755.0647 2100977.86196 37.7494914656774 -122.405604594682 (37.7494914656774, -122.405604594682)
42476 241395 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 2500 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6011393.117330001 2101862.71198 37.7519567286313 -122.403460422082 (37.7519567286313, -122.403460422082)
39696 241394 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1398 Vermont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6011408.3222900005 2101904.99844 37.7520736872555 -122.403410815482 (37.7520736872555, -122.403410815482)
167714 213886 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1032 Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5990730.33666 2102492.76003 37.7525108935626 -122.4749605429 (37.7525108935626, -122.4749605429)
173456 213885 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 310 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5993322.888280001 2103946.18748 37.75665153504929 -122.466100743157 (37.7566515350493, -122.466100743157)
166454 241396 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 952 Hampshire St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6010191.29772 2103654.4580900003 37.7568092635594 -122.407742832678 (37.7568092635594, -122.407742832678)
24112 213879 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1667 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992447.253280001 2104111.52703 37.75705495743 -122.469141011975 (37.75705495743, -122.469141011975)
29753 213882 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1666 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992501.4307 2104115.72478 37.7570696136933 -122.46895395297199 (37.7570696136933, -122.468953952972)
46802 213881 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1658 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992500.1434 2104162.33535 37.7571975197705 -122.46896179684799 (37.7571975197705, -122.468961796848)
29493 213880 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 531 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5992597.19998 2104535.76314 37.7582284620821 -122.468653311406 (37.7582284620821, -122.468653311406)
150668 197019 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 586 Missouri St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 4ft   6013514.03834 2104373.90914 37.7589701689629 -122.39630191030399 (37.7589701689629, -122.396301910304)
134659 213908 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 9 Locksley Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5994103.8781 2104889.3347400003 37.7592862006088 -122.46346826115101 (37.7592862006088, -122.463468261151)
68515 213907 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 9 Locksley Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5994127.50266 2104950.54632 37.759455632884396 -122.463390998614 (37.7594556328844, -122.463390998614)
135627 213863 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 827 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5992302.54475 2105211.64406 37.7600672276448 -122.469721553127 (37.7600672276448, -122.469721553127)
75688 213859 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1447 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992399.4356 2105595.93354 37.7611279851974 -122.469414430147 (37.7611279851974, -122.469414430147)
39785 213860 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1448 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 2ft   5992447.46544 2105601.66923 37.7611465094251 -122.46924873453699 (37.7611465094251, -122.469248734537)
160714 213861 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1430 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   5992443.36702 2105705.84611 37.761432314878505 -122.46927049184299 (37.7614323148785, -122.469270491843)
134066 213858 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1427 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   5992396.3175800005 2105723.70303 37.7614786263699 -122.469434514712 (37.7614786263699, -122.469434514712)
38620 213862 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 1422 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   5993680.98078 2105782.7905200003 37.7617150230552 -122.464995722789 (37.7617150230552, -122.464995722789)
51528 239137 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 128 Woodland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   5997045.82374 2105845.81512 37.762081516563 -122.453362698034 (37.762081516563, -122.453362698034)
58772 241393 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 66 Dorland St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6005160.70352 2105758.78708 37.7623043550961 -122.425290238962 (37.7623043550961, -122.425290238962)
71830 239136 Undocumented 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 79 Woodland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5997078.63554 2106086.03977 37.762742993126395 -122.453266558717 (37.7627429931264, -122.453266558717)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 83.751ms · Data source: data.sfgov.org