Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, PlantType, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
484 | 484 | 205880 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 44 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 43 | Width 3ft | 5993348.04769 | 2101170.42115 | 37.7490314462559 | -122.46581205990499 | (37.7490314462559, -122.465812059905) | |||
1674 | 1674 | 251651 | Significant Tree 6 | Jacaranda mimosifolia :: Jacaranda 52 | 3237 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009049.0 | 2099828.0 | 37.746238652288106 | -122.411423013741 | (37.7462386522881, -122.411423013741) | ||||
1693 | 1693 | 251659 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1050 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
1702 | 1702 | 251658 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1050 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
1708 | 1708 | 251660 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
1710 | 1710 | 251657 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
1717 | 1717 | 251661 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
2114 | 2114 | 107983 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 2405x Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6001231.007069999 | 2116743.47753 | 37.7922427464694 | -122.43966909537599 | (37.7922427464694, -122.439669095376) | |||
2151 | 2151 | 252916 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001472.0 | 2098865.0 | 37.7431665844065 | -122.437554349716 | (37.7431665844065, -122.437554349716) | ||||
3037 | 3037 | 253283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 673 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005929.0 | 2099335.0 | 37.7447094953859 | -122.422176588207 | (37.7447094953859, -122.422176588207) | ||||
3204 | 3204 | 253366 | Significant Tree 6 | Ficus carica :: Edible Fig 201 | 20 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004582.0 | 2109434.0 | 37.772362894278395 | -122.427553605007 | (37.7723628942784, -122.427553605007) | ||||
9738 | 9738 | 173675 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 258 | 299x Beale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
9740 | 9740 | 173671 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
9741 | 9741 | 173676 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 258 | 299x Beale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
9743 | 9743 | 173674 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 299x Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
9744 | 9744 | 173673 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 299x Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
9749 | 9749 | 173677 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 258 | 299x Beale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
9750 | 9750 | 173672 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 299x Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
9752 | 9752 | 173678 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
10151 | 10151 | 173889 | Significant Tree 6 | Gleditsia triacanthos :: Honey Locust 67 | 190 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010824.0 | 2099939.0 | 37.746642831954496 | -122.405293064953 | (37.7466428319545, -122.405293064953) | ||||
11570 | 11570 | 174950 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 309 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987294.0 | 2096147.0 | 37.7348873783654 | -122.486377975564 | (37.7348873783654, -122.486377975564) | ||||
13290 | 13290 | 187642 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 2526 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006264.0 | 2119500.0 | 37.8000966404513 | -122.42245076966002 | (37.8000966404513, -122.42245076966) | ||||
20387 | 20387 | 121368 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 245 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 778992 | 6001431.0 | 2120732.0 | 37.8032055622797 | -122.439263127997 | (37.8032055622797, -122.439263127997) | ||
44089 | 44089 | 109772 | Significant Tree 6 | Yucca elephantipes :: Giant Yucca 211 | 2200x SAN JOSE AVE | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 5998886.0 | 2091075.0 | 37.7216297132481 | -122.44593585753599 | (37.7216297132481, -122.445935857536) | |||
47274 | 47274 | 121088 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1X Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000227.0 | 2103854.0 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | ||||
50101 | 50101 | 121189 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000x Duncan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
66014 | 66014 | 120590 | Significant Tree 6 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 52 Prosper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003308.0 | 2106220.0 | 37.763465890993295 | -122.43173097308998 | (37.7634658909933, -122.43173097309) | ||||
78383 | 78383 | 115661 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 341 HAZELWOOD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5996066.0 | 2095432.0 | 37.7334315621613 | -122.455998615118 | (37.7334315621613, -122.455998615118) | |||
78781 | 78781 | 121184 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
79242 | 79242 | 121190 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
80352 | 80352 | 121187 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
80520 | 80520 | 116010 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 199x SAN BUENAVENTURA WAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993547.0 | 2095667.0 | 37.7339319096844 | -122.464724497297 | (37.7339319096844, -122.464724497297) | ||||
80993 | 80993 | 85086 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
82126 | 82126 | 115125 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
82400 | 82400 | 115123 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
82760 | 82760 | 120597 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
82925 | 82925 | 112725 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 40x BERNAL HEIGHTS BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6009324.0 | 2098099.0 | 37.7415066181332 | -122.41035003366801 | (37.7415066181332, -122.410350033668) | |||
83367 | 83367 | 115940 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3401x 17TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 20 | 3x3 | 6006069.0 | 2106010.0 | 37.7630453994978 | -122.42216662533801 | (37.7630453994978, -122.422166625338) | |||
83893 | 83893 | 110583 | Significant Tree 6 | Phoenix canariensis :: Canary Island Date Palm 100 | 46 COOK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
83993 | 83993 | 114406 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 500X ARBALLO DR | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
84141 | 84141 | 120594 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
84791 | 84791 | 108196 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 930 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009368.6 | 2103733.3 | 37.7569796561067 | -122.410593604092 | (37.7569796561067, -122.410593604092) | |||||
84797 | 84797 | 112378 | Significant Tree 6 | :: 54 | 1850 19TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5990394.0 | 2102783.0 | 37.7532883185876 | -122.476144836826 | (37.7532883185876, -122.476144836826) | |||
84949 | 84949 | 86910 | Significant Tree 6 | Ilex spp :: Holly Species 163 | 1 Urbano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49875 | 5993901.0 | 2092133.0 | 37.7242488135215 | -122.463244271267 | (37.7242488135215, -122.463244271267) | |||
85026 | 85026 | 99100 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993700.7 | 2097327.0 | 37.7384987171226 | -122.464313592449 | (37.7384987171226, -122.464313592449) | |||||
85039 | 85039 | 115729 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 776540 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | |||
85687 | 85687 | 113112 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1633 OAKDALE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014731.0 | 2095647.0 | 37.735075549566204 | -122.391482947841 | (37.7350755495662, -122.391482947841) | |||||
86822 | 86822 | 114840 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2455x HYDE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x3 | 6006980.0 | 2120877.0 | 37.803917898432395 | -122.42007090461901 | (37.8039178984324, -122.420070904619) | ||||
88665 | 88665 | 109838 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 200x MONTCALM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6009924.0 | 2099647.0 | 37.745790704819704 | -122.408384592716 | (37.7457907048197, -122.408384592716) | |||
89056 | 89056 | 121188 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
89334 | 89334 | 116094 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
89824 | 89824 | 110738 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 333 | 1299x PERSIA AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6004594.0 | 2089787.0 | 37.71841743015371 | -122.42611316787901 | (37.7184174301537, -122.426113167879) | ||||
90057 | 90057 | 111634 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 3009 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 6009514.91537658 | 2100993.40768569 | 37.7494647260255 | -122.40989418187 | (37.7494647260255, -122.40989418187) | |||
90639 | 90639 | 117269 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 399X SANTA CLARA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x10 | 5993324.0 | 2095440.0 | 37.7332957649176 | -122.46547898513701 | (37.7332957649176, -122.465478985137) | ||||
90926 | 90926 | 114099 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 201x VIDAL DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5987665.0 | 2090646.0 | 37.719804665893605 | -122.484691919383 | (37.7198046658936, -122.484691919383) | ||||
90930 | 90930 | 121191 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
91008 | 91008 | 120156 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 758 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 10 | 5992930.0 | 2110298.0 | 37.77406925887279 | -122.467921468059 | (37.7740692588728, -122.467921468059) | ||||
91506 | 91506 | 121193 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
91812 | 91812 | 107986 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2401x SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001257.0 | 2116757.0 | 37.7922813550603 | -122.439580129378 | (37.7922813550603, -122.439580129378) | ||||
91855 | 91855 | 122410 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
91870 | 91870 | 122411 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
92339 | 92339 | 115295 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 500X 08TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010511.0 | 2109243.0 | 37.77217202356729 | -122.407031076357 | (37.7721720235673, -122.407031076357) | ||||
92450 | 92450 | 116095 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
93266 | 93266 | 114407 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 177 | 500X ARBALLO DR | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
93681 | 93681 | 96767 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 94 | 2229 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 768245 | 6003236.0 | 2116309.0 | 37.7911636966224 | -122.43270073645701 | (37.7911636966224, -122.432700736457) | |||
93904 | 93904 | 118327 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 109 ALPINE TER | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x7 | 6001716.4 | 2108199.1 | 37.7688096651516 | -122.43737752181002 | (37.7688096651516, -122.43737752181) | ||||
94007 | 94007 | 112375 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 42 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
94160 | 94160 | 113187 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3340 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6008444.0 | 2099179.0 | 37.7444226899799 | -122.41346914528499 | (37.7444226899799, -122.413469145285) | |||
94649 | 94649 | 112577 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 3326 23RD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Permit Number 775776 | 6006851.0 | 2102663.4 | 37.753900487576296 | -122.419224541208 | (37.7539004875763, -122.419224541208) | |||
94747 | 94747 | 114034 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 53 | 198x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 5990818.0 | 2089012.0 | 37.7155012267577 | -122.473674083302 | (37.7155012267577, -122.473674083302) | |||
95270 | 95270 | 121186 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
95855 | 95855 | 112250 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 243 WINSTON DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990059.0 | 2093141.0 | 37.726794444209396 | -122.47659897114599 | (37.7267944442094, -122.476598971146) | ||||
96134 | 96134 | 85085 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
96939 | 96939 | 113833 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 932 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 6007966.0 | 2102301.0 | 37.752968150444204 | -122.415342945464 | (37.7529681504442, -122.415342945464) | ||||
96972 | 96972 | 120593 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 499x Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 34 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | |||
97871 | 97871 | 115124 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
98270 | 98270 | 107984 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 2401x SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001096.0 | 2116670.0 | 37.792033311180504 | -122.440130949989 | (37.7920333111805, -122.440130949989) | ||||
98668 | 98668 | 108560 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 164 | 3790 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003155.9 | 2103640.4 | 37.7563743055091 | -122.432072816055 | (37.7563743055091, -122.432072816055) | |||||
99634 | 99634 | 99847 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 850@14th Ave Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991942.0 | 2105939.0 | 37.7620435090796 | -122.47102148161501 | (37.7620435090796, -122.471021481615) | |||||
99827 | 99827 | 122418 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
100978 | 100978 | 121192 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
101747 | 101747 | 113695 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 907 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6009441.0 | 2103786.0 | 37.7571284172194 | -122.41034693748101 | (37.7571284172194, -122.410346937481) | |||
102016 | 102016 | 105368 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 180 CLIFFORD TER | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999283.1 | 2106587.2 | 37.7642451591147 | -122.44567816768298 | (37.7642451591147, -122.445678167683) | ||||||
102605 | 102605 | 121181 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
102666 | 102666 | 121415 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 366 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6006692.0 | 2103986.0 | 37.757523086513096 | -122.419868246156 | (37.7575230865131, -122.419868246156) | |||
103031 | 103031 | 120596 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 36 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | |||
103307 | 103307 | 115942 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3401x 17TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 3x3 | 6006069.0 | 2106010.0 | 37.7630453994978 | -122.42216662533801 | (37.7630453994978, -122.422166625338) | ||||
103510 | 103510 | 92813 | Significant Tree 6 | Tree(s) :: 17 | 365 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 53020 | 6006011.0 | 2111744.0 | 37.7787863189721 | -122.42277474798 | (37.7787863189721, -122.42277474798) | |||
104153 | 104153 | 121416 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 366 San Carlos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006692.0 | 2103986.0 | 37.757523086513096 | -122.419868246156 | (37.7575230865131, -122.419868246156) | ||||
104170 | 104170 | 110739 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 333 | 1299x PERSIA AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6004594.0 | 2089787.0 | 37.71841743015371 | -122.42611316787901 | (37.7184174301537, -122.426113167879) | ||||
104617 | 104617 | 121185 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
104788 | 104788 | 121183 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
105009 | 105009 | 85087 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
105495 | 105495 | 112955 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 24 | 121X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991652.84779157 | 2095347.0788301998 | 37.7329441015396 | -122.471249796136 | (37.7329441015396, -122.471249796136) | |||||
105748 | 105748 | 120595 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
106195 | 106195 | 116091 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | |||
107199 | 107199 | 112376 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 24 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
107939 | 107939 | 114408 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 500X ARBALLO DR | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
109893 | 109893 | 114409 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 500X ARBALLO DR | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
109913 | 109913 | 122413 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) |
JSON shape: default, array, newline-delimited
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");