Street_Tree_List

Data source: data.sfgov.org

9,170 rows where qSiteInfo = 2 sorted by PlantDate

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: PlantType, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate ▼ DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
168 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 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 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 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 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 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 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 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 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 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 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)
1006 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)
2611 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 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 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 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 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 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 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 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 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 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 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 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 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 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)
2814 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 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 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)
2940 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)
2985 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 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 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 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 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)
3040 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 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 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 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 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 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 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 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 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 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 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 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)
3734 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 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 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 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 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 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 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 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 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 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 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 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 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)
4769 4769 194422 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 199X Kissling St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     52 Width 5ft   6007901.53326 2109054.5781799997 37.771508291196 -122.41604412194401 (37.771508291196, -122.416044121944)
5045 5045 123372 Undocumented 2 Crateagus spp :: Hawthorn 160 785 03rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5995014.0 2110353.0 37.7743403969856 -122.46071658922399 (37.7743403969856, -122.460716589224)
5057 5057 123370 Undocumented 2 Pinus radiata :: Monterey Pine 3 785 03rd Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     41 Width 4ft   5995014.0 2110353.0 37.7743403969856 -122.46071658922399 (37.7743403969856, -122.460716589224)
5245 5245 205593 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 30 Vasquez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5995699.652000001 2100090.8564 37.746202601761105 -122.45760214624201 (37.7462026017611, -122.457602146242)
9497 9497 122159 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 547 15th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   5991246.192840001 2111684.05416 37.7777776077222 -122.473847129053 (37.7777776077222, -122.473847129053)
9572 9572 100227 Undocumented 2 Maytenus boaria :: Mayten 22 542 Valley St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30   Permit Number 769993 6002426.0 2099190.0 37.7441131524814 -122.434278904907 (37.7441131524814, -122.434278904907)
10103 10103 173844 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2X Crestline Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5999319.0 2101169.0 37.7493701671822 -122.445164434644 (37.7493701671822, -122.445164434644)
10991 10991 116458 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 267 777 Brotherhood Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 10x20   5989819.39068 2088633.8654 37.7144050769972 -122.477098071327 (37.7144050769972, -122.477098071327)
11055 11055 116459 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 267 777 Brotherhood Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 10x20 Permit Number 777772 5989848.42836 2088633.8329099999 37.7144066723949 -122.476997704287 (37.7144066723949, -122.476997704287)
13306 13306 187657 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 5 2072 15th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       3x3   5991666.0 2101424.0 37.7496305363998 -122.47164701446 (37.7496305363998, -122.47164701446)
13307 13307 187654 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 375 Woodside Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       3x3   5997267.0 2099886.0 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039)
18835 18835 114526 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1 TIOGA AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           6011351.0 2088602.0 37.715543251319204 -122.402673611341 (37.7155432513192, -122.402673611341)
19238 19238 104509 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 80 DICHIERA CT   Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14     5998620.0 2088043.0 37.7132893442667 -122.446637305723 (37.7132893442667, -122.446637305723)
19268 19268 104883 Undocumented 2 Pinus radiata :: Monterey Pine 3 132 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5990322.1 2090011.1 37.718215776001294 -122.475461023549 (37.7182157760013, -122.475461023549)
20076 20076 98360 Permitted Site 1 Pinus radiata :: Monterey Pine 3 807 Francisco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1         Permit Number 768654 6007370.5 2120864.5 37.8039055703948 -122.418718664572 (37.8039055703948, -122.418718664572)
22365 22365 141244 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 31 COMMONWEALTH AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5996487.1971 2114345.4775 37.7853873361438 -122.455909239222 (37.7853873361438, -122.455909239222)
22816 22816 208166 Undocumented 2 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 15 Santa Rita Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993909.69845 2100938.88006 37.7484280758139 -122.463853078355 (37.7484280758139, -122.463853078355)
22821 22821 197331 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1501 25th St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     6014124.123369999 2101967.77095 37.752397360459 -122.39402349321199 (37.752397360459, -122.394023493212)
22882 22882 176369 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 0 Font Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5990491.08034 2089186.3269 37.7159609464097 -122.47481676917101 (37.7159609464097, -122.474816769171)
22887 22887 120259 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 130 24th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5988369.32629 2115004.14379 37.7867265878172 -122.484042609601 (37.7867265878172, -122.484042609601)
22906 22906 240229 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 116 Crescent Ave 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 10ft   6006267.81246 2095797.32513 37.7350149365947 -122.42075393896299 (37.7350149365947, -122.420753938963)
22912 22912 210552 Undocumented 2 Myoporum laetum :: Myoporum 1 414 Dewey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 3ft   5995155.65345 2100448.38141 37.7471530116111 -122.459509101961 (37.7471530116111, -122.459509101961)
22986 22986 250821 Undocumented 2 Maytenus boaria :: Mayten 22 45 Sea View Ter 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5986295.23656 2114137.57517 37.7842262706806 -122.49115456935 (37.7842262706806, -122.49115456935)
23367 23367 208982 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 320 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     45 Width 3ft   5993096.565780001 2095876.3159599998 37.7344806601409 -122.46629697974501 (37.7344806601409, -122.466296979745)
23375 23375 218050 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 72 San Rafael Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991878.2117099995 2095609.0189900002 37.7336763568794 -122.470489732417 (37.7336763568794, -122.470489732417)
23387 23387 213501 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 787 Faxon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5994873.7468 2093233.8423799998 37.7273274525845 -122.459961359351 (37.7273274525845, -122.459961359351)

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