Street_Tree_List

Data source: data.sfgov.org

9,170 rows where qSiteInfo = 2

View and edit SQL

Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2 232565 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 940 Elizabeth St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   03/20/2017 12:00:00 AM 3 Width 4ft Permit Number 779625 6000396.48544 2101998.8644 37.7517102172731 -122.441498017841 (37.7517102172731, -122.441498017841)
27 244214 Private 5 Tree(s) :: 17 342 Scott St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   03/20/2017 12:00:00 AM 3 Width 0ft Permit Number 779666 6002262.2202 2109717.5413 37.7730099442883 -122.43559821674499 (37.7730099442883, -122.435598216745)
35 183515 Undocumented 2 Myoporum laetum :: Myoporum 1 2562 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   03/21/2017 12:00:00 AM 3 Width 0ft Permit Number 779639 5988336.7554 2097879.9474 37.7397063254514 -122.482899813956 (37.7397063254514, -122.482899813956)
50 138938 Private 5 Tree(s) :: 17 632 HAYES ST 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   03/21/2017 12:00:00 AM 3 Width 0ft Permit Number 779650 6004797.9634 2110922.1515 37.7764612085261 -122.426912572117 (37.7764612085261, -122.426912572117)
168 179480 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 100 Serrano Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5989599.0 2090767.0 37.7202493457345 -122.478015677124 (37.7202493457345, -122.478015677124)
455 234501 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 2423 Market St 2 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2     12 Width 8ft   6002117.5892 2105782.84009 37.7621980066439 -122.435816935712 (37.7621980066439, -122.435816935712)
539 206615 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 198 Vasquez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft Permit Number 779324 5994758.52704 2099346.29484 37.7441041156281 -122.460802465585 (37.7441041156281, -122.460802465585)
553 206616 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 198 Vasquez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft Permit Number 779324 5994742.56026 2099334.6803900003 37.7440713065495 -122.460856833195 (37.7440713065495, -122.460856833195)
565 206617 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 198 Garcia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5994686.63181 2099351.09779 37.7441131663853 -122.461051409618 (37.7441131663853, -122.461051409618)
571 206618 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 198 Garcia Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft Permit Number 779324 5994673.79551 2099409.87557 37.7442738167873 -122.461100053935 (37.7442738167873, -122.461100053935)
608 233928 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 8 Octavia St Frontage East 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 8ft   6005775.18179 2109348.30824 37.77219502161479 -122.423420179704 (37.7721950216148, -122.423420179704)
721 183636 Planning Code 138.1 required 4 Pittosporum crassifolium :: Karo Tree 108 1478 47th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 3x9   5981570.9282 2105017.3718 37.7589076903569 -122.506822015648 (37.7589076903569, -122.506822015648)
789 175382 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80x Junipero Serra Blvd 19 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2     2 Width 3ft   5991305.518069999 2089124.29272 37.7158377779634 -122.471997198511 (37.7158377779634, -122.471997198511)
854 203901 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 3794 19th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2     12 Width 3ft   5990470.121669999 2090714.3108400002 37.720155198286 -122.475000685058 (37.720155198286, -122.475000685058)
892 251400 Undocumented 2 Celtis sinensis :: Chinese Hackberry 111 101 Rhine St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 3ft   5994375.43496 2086552.5575599999 37.7089535675334 -122.461199910156 (37.7089535675334, -122.461199910156)
1001 238568 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1300 Noe St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   04/27/2017 12:00:00 AM 3 Width 5ft Permit Number 779731 6003218.5106 2100626.90187 37.7481035005842 -122.431641146931 (37.7481035005842, -122.431641146931)
1006 232567 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 947 Elizabeth St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 4ft   6000330.76798 2101953.15424 37.751580964011204 -122.441721996685 (37.7515809640112, -122.441721996685)
1009 223537 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 1300 Noe St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 5ft   6003218.0959 2100594.3408 37.7480140720016 -122.431640256605 (37.7480140720016, -122.431640256605)
1103 211013 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 500 Junipero Serra Blvd 44 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5991332.59313 2093509.69784 37.727880584217 -122.47222310103399 (37.727880584217, -122.472223101034)
1368 141257 Undocumented 2 Rhaphiolepis indica :: India Hawthorn 144 51 COMMONWEALTH AVE 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5996492.2734 2114210.7856 37.7850177994523 -122.455881936455 (37.7850177994523, -122.455881936455)
1370 141258 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 51 COMMONWEALTH AVE 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5996495.6576 2114088.9538 37.7846834760254 -122.455861417999 (37.7846834760254, -122.455861417999)
1785 228278 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 2050 15th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
1857 251765 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 23 Seville St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1870 251767 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 23 Seville St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1871 176854 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 23 Seville St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1876 251766 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 23 Seville St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1878 251764 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 187 Seville St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 6ft   6001178.343719999 2087386.3168 37.7116320444605 -122.43774780171302 (37.7116320444605, -122.437747801713)
2066 252868 Undocumented 2 Shrub :: Shrub 98 15 Foerster St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 3ft   5998080.65269 2093664.7185 37.7286944544712 -122.44890616611099 (37.7286944544712, -122.448906166111)
2092 196948 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 3536 Jennings St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6013049.3063900005 2089480.54762 37.718050242412296 -122.39686501810199 (37.7180502424123, -122.396865018102)
2094 252881 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 3536 Jennings St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 3ft   6013049.3063900005 2089480.54762 37.718050242412296 -122.39686501810199 (37.7180502424123, -122.396865018102)
2102 196505 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3536 Jennings St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6013064.418880001 2089502.0027700001 37.7181099951501 -122.39681428375299 (37.7181099951501, -122.396814283753)
2180 251495 Significant Tree 6 Tree(s) :: 17 2448 Clay St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   06/28/2017 12:00:00 AM 3 10x10 Permit Number 780000 6003026.0 2116224.0 37.7909183964794 -122.433421252488 (37.7909183964794, -122.433421252488)
2211 188595 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1301 Rhode Island St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/05/2017 12:00:00 AM 3 Width 7ft   6011997.611930001 2102271.8897 37.7531139870419 -122.401398733477 (37.7531139870419, -122.401398733477)
2383 201821 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021045.51426 2093266.4470799998 37.7288874606638 -122.369486691782 (37.7288874606638, -122.369486691782)
2387 201822 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021035.49669 2093250.0299200001 37.72884183267921 -122.36952018972299 (37.7288418326792, -122.369520189723)
2402 201606 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 598 Innes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 1 Width 3ft   6020954.32481 2093200.4635700001 37.7287012794353 -122.36979738594101 (37.7287012794353, -122.369797385941)
2408 201820 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021056.53291 2093279.09213 37.728922786051506 -122.369449472416 (37.7289227860515, -122.369449472416)
2417 201819 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021071.50009 2093300.7706900002 37.7289831323462 -122.369399226393 (37.7289831323462, -122.369399226393)
2465 201607 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 598 Innes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 1 Width 3ft   6020934.32673 2093214.8340900003 37.7287396409072 -122.36986751418699 (37.7287396409072, -122.369867514187)
2567 252819 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 407 Miguel St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/19/2017 12:00:00 AM 3   Permit Number 780051 6004479.0 2096413.0 37.736604456337105 -122.426982337456 (37.7366044563371, -122.426982337456)
2611 248770 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1 Cuesta Ct 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 8ft   5999726.1375 2101744.56242 37.7509737525388 -122.44379789365499 (37.7509737525388, -122.443797893655)
2614 248773 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1 Cuesta Ct 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 8ft   5999776.82694 2101824.96428 37.751197407653706 -122.44362838043999 (37.7511974076537, -122.44362838044)
2625 248771 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1 Cuesta Ct 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 8ft   5999742.36883 2101773.9828 37.751055459558394 -122.4437438777 (37.7510554595584, -122.4437438777)
2626 248769 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1 Cuesta Ct 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 8ft   5999705.100819999 2101709.8291 37.7508771833507 -122.443868145114 (37.7508771833507, -122.443868145114)
2629 248772 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1 Cuesta Ct 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 8ft   5999759.8487 2101799.49731 37.7511265131926 -122.443685263491 (37.7511265131926, -122.443685263491)
2702 175365 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 18 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 5ft   5993296.25394 2087788.76232 37.712285726578 -122.465019407322 (37.712285726578, -122.465019407322)
2703 175367 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 23 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5993394.31846 2087754.15211 37.7121963492565 -122.464677958129 (37.7121963492565, -122.464677958129)
2705 175366 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 5ft   5993316.47827 2087783.2739799998 37.7122718230516 -122.464949108223 (37.7122718230516, -122.464949108223)
2708 175370 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 26 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5993448.13741 2087722.6413599998 37.712112930839 -122.464489658971 (37.712112930839, -122.464489658971)
2709 175364 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5993263.021319999 2087797.41727 37.7123075747038 -122.465134896479 (37.7123075747038, -122.465134896479)
2716 175362 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   5993185.52762 2087808.44828 37.7123333942447 -122.46540353654 (37.7123333942447, -122.46540353654)
2720 175369 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 25 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5993431.63462 2087732.39125 37.7121387503812 -122.46454740445101 (37.7121387503812, -122.464547404451)
2721 175371 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 27 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5993471.88559 2087712.01586 37.712085124705204 -122.464406808033 (37.7120851247052, -122.464406808033)
2722 175368 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 24 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5993415.10175 2087740.6954 37.7121605985029 -122.464605149022 (37.7121605985029, -122.464605149022)
2760 251575 Significant Tree 6 Pinus radiata :: Monterey Pine 3 300 Sussex St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   08/02/2017 12:00:00 AM 3 3x3 Permit Number 780395 6001194.0 2096647.0 37.737060666835205 -122.438356728037 (37.7370606668352, -122.438356728037)
2814 241583 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 38X Java St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2837 241584 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 38X Java St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2841 241585 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 38X Java St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2934 250407 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 25 Seacliff Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/16/1997 12:00:00 AM 12 Width 4ft Permit Number 38521 5987994.17396 2115794.4903599997 37.78887480516529 -122.485398549405 (37.7888748051653, -122.485398549405)
2940 250421 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 49 Seacliff Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5987880.27353 2115792.69032 37.788863226412296 -122.485792492053 (37.7888632264123, -122.485792492053)
2983 250419 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 49 Seacliff Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/14/1997 12:00:00 AM 8 Width 4ft Permit Number 38081 5987849.1846199995 2115791.00757 37.7888567944531 -122.48589993045601 (37.7888567944531, -122.485899930456)
2985 250408 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 25 Seacliff Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5988046.91633 2115796.65095 37.7888838100916 -122.485216228949 (37.7888838100916, -122.485216228949)
2987 250422 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 49 Seacliff Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5987891.12003 2115793.8659200002 37.7888670862959 -122.48575505145399 (37.7888670862959, -122.485755051454)
3017 250423 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 49 Seacliff Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5987905.22883 2115793.56651 37.7888670863011 -122.485706215587 (37.7888670863011, -122.485706215587)
3028 191362 Undocumented 2 Umbellularia californica :: California Bay 195 999 Key Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27     6013336.3333 2089743.8780099999 37.718789267498295 -122.39589132571999 (37.7187892674983, -122.39589132572)
3029 193472 Undocumented 2 Prunus persica nectarina :: Flowering Nectarine Tree 196 1059 Jamestown Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6013665.43892 2089838.8488900003 37.719068342415596 -122.39476037791599 (37.7190683424156, -122.394760377916)
3033 253285 Undocumented 2 Cordyline australis :: Dracena Palm 141 8245 Geary Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   08/15/2017 12:00:00 AM 3     5981372.0 2112274.0 37.7788205636315 -122.50804856364901 (37.7788205636315, -122.508048563649)
3040 189089 Undocumented 2 Acer negundo :: Box Elder 74 1033 Le Conte Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6012956.43123 2089677.63232 37.718586227543504 -122.397199861797 (37.7185862275435, -122.397199861797)
3041 182178 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1799X Lawton St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   5988865.0 2104441.0 37.7577519603078 -122.48155379203999 (37.7577519603078, -122.48155379204)
3065 175836 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 101 Rhine St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994366.585519999 2086543.72285 37.70892880020671 -122.46122985488998 (37.7089288002067, -122.46122985489)
3254 244746 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 98 12th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   6007069.86029 2109755.10428 37.7733849739584 -122.418970623803 (37.7733849739584, -122.418970623803)
3382 122965 Undocumented 2 Cordyline australis :: Dracena Palm 141 98 09th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5993050.799269999 2114904.9128799997 37.786725565514004 -122.467838745487 (37.786725565514, -122.467838745487)
3405 180669 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 171 Winding Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 6ft   6002170.184219999 2086635.71157 37.70962739445179 -122.434266111507 (37.7096273944518, -122.434266111507)
3411 181033 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 39 Curtis St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 4ft   6000587.53239 2088326.47 37.71417988317489 -122.439857163381 (37.7141798831749, -122.439857163381)
3413 180646 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 451 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 6ft   6002230.18825 2087673.61332 37.7124806510226 -122.434132874236 (37.7124806510226, -122.434132874236)
3423 251752 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 128 South Hill Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3430 180648 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 120 Seville St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 6ft   6001751.26715 2087361.8508 37.7115974268507 -122.435765878508 (37.7115974268507, -122.435765878508)
3432 180655 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 128 South Hill Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3488 251753 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 128 South Hill Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3678 208759 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 300 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/24/2005 12:00:00 AM 2 Width 3ft Permit Number 48287 5993126.46853 2099702.60224 37.7449884054972 -122.466471606489 (37.7449884054972, -122.466471606489)
3683 213464 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 Dorantes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/24/2005 12:00:00 AM 2 Width 3ft Permit Number 48287 5993110.29995 2099700.9644 37.7449829754007 -122.46652739502701 (37.7449829754007, -122.466527395027)
3734 118035 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 450 38th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 4ft   5984123.0 2112760.0 37.7803166927985 -122.498567828267 (37.7803166927985, -122.498567828267)
3768 228283 Section 143 8 Ginkgo biloba :: Maidenhair Tree 44 2036X 15th St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3773 228285 Section 143 8 Ginkgo biloba :: Maidenhair Tree 44 2036X 15th St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3775 228281 Section 143 8 Ginkgo biloba :: Maidenhair Tree 44 2036X 15th St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3776 228280 Section 143 8 Ginkgo biloba :: Maidenhair Tree 44 2036X 15th St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3780 228286 Section 143 8 Ginkgo biloba :: Maidenhair Tree 44 2036X 15th St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3781 228284 Section 143 8 Ginkgo biloba :: Maidenhair Tree 44 2036X 15th St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3791 228279 Section 143 8 Ginkgo biloba :: Maidenhair Tree 44 2036X 15th St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3795 228282 Section 143 8 Ginkgo biloba :: Maidenhair Tree 44 2036X 15th St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3800 213446 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 530 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993033.55222 2099443.36305 37.744271238444206 -122.46677405027799 (37.7442712384442, -122.466774050278)
3812 253561 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 530 Magellan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 3ft   5993033.55222 2099443.36305 37.744271238444206 -122.46677405027799 (37.7442712384442, -122.466774050278)
3816 219559 Undocumented 2 Ulmus americana :: American Elm 119 4 Cortes Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 3ft   5993189.55754 2099585.29183 37.7446699411581 -122.46624493416799 (37.7446699411581, -122.466244934168)
3822 253559 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4 Cortes Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 3ft   5993184.39566 2099612.1282900004 37.7447433294416 -122.46626473273199 (37.7447433294416, -122.466264732732)
3850 207785 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 290 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   09/28/2017 12:00:00 AM 3 Width 10ft   5993081.87997 2096205.8056700001 37.7353845093885 -122.46637169180299 (37.7353845093885, -122.466371691803)
3920 216755 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 115 Harold Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/04/2017 01:38:00 PM 3 Width 3ft   5996789.877280001 2090654.02957 37.720353912480995 -122.453151180205 (37.720353912481, -122.453151180205)
3943 216737 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 11 Lee Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/04/2017 02:31:00 PM 3 Width 2ft   5996481.70655 2089974.5093900003 37.7184704425356 -122.45416736555799 (37.7184704425356, -122.454167365558)
3959 216642 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 50 Lee Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/04/2017 01:57:00 PM 3 Width 2ft   5996528.83108 2090217.4765599999 37.7191402755735 -122.45402201441999 (37.7191402755735, -122.45402201442)
3999 181035 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 170 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 04:20:00 PM 3 Width 4ft   6000927.8060099995 2088408.3131900001 37.7144239699579 -122.438686909772 (37.7144239699579, -122.438686909772)
4004 251722 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 18 Lobos St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 03:08:00 PM 3     5996685.56427 2088703.70423 37.7149927956564 -122.45337101855101 (37.7149927956564, -122.453371018551)

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 1042.744ms · Data source: data.sfgov.org