Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189144 | 189144 | 121399 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | ||||||||||
| 189143 | 189143 | 137803 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1800 PINE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004934.2786 | 2115449.7152 | 37.78890048406579 | -122.42676352221599 | (37.7889004840658, -122.426763522216) | |||
| 189142 | 189142 | 142672 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 444 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6009151.8318 | 2121171.42 | 37.80484842791721 | -122.412575941125 | (37.8048484279172, -122.412575941125) | |||
| 189141 | 189141 | 199474 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015480.23631 | 2109482.55519 | 37.7731066131226 | -122.389858657266 | (37.7731066131226, -122.389858657266) | |||
| 189140 | 189140 | 223074 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 876 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008549.8559 | 2103442.10784 | 37.7561341721705 | -122.41340454698401 | (37.7561341721705, -122.413404546984) | |||
| 189139 | 189139 | 246247 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 92 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999685.4059 | 2107775.5089 | 37.76753091894221 | -122.44437211474701 | (37.7675309189422, -122.444372114747) | |||
| 189138 | 189138 | 232332 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 90 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6001483.73316 | 2099106.7788299997 | 37.7438311192153 | -122.437531090286 | (37.7438311192153, -122.437531090286) | |||
| 189137 | 189137 | 237759 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 365 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999267.64686 | 2104906.15907 | 37.7596285572291 | -122.44561072185499 | (37.7596285572291, -122.445610721855) | |||
| 189136 | 189136 | 208878 | Undocumented 2 | Malus :: Crab Apple 235 | 430 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5995998.78542 | 2096380.30117 | 37.736031508641794 | -122.456299537593 | (37.7360315086418, -122.456299537593) | |||
| 189135 | 189135 | 195300 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6013572.66775 | 2116629.13955 | 37.7926235212146 | -122.396958390217 | (37.7926235212146, -122.396958390217) | |||
| 189134 | 189134 | 230425 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 70 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001023.25881 | 2106016.57579 | 37.762777563946294 | -122.439618557053 | (37.7627775639463, -122.439618557053) | |||
| 189133 | 189133 | 240490 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 439 Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003440.089980001 | 2103292.2182400003 | 37.755434388988 | -122.43106513834199 | (37.755434388988, -122.431065138342) | |||
| 189132 | 189132 | 127661 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 351 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6006169.59466 | 2111057.68357 | 37.776910807423 | -122.42217733372101 | (37.776910807423, -122.422177333721) | |||
| 189131 | 189131 | 137675 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1750 MCALLISTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6000771.1568 | 2111397.1454 | 37.777536910919 | -122.440876486346 | (37.777536910919, -122.440876486346) | |||
| 189130 | 189130 | 227619 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1193 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008092.35309 | 2100991.6752 | 37.7493801403813 | -122.414813334067 | (37.7493801403813, -122.414813334067) | |||
| 189129 | 189129 | 182301 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2537 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986893.9274 | 2105029.3143 | 37.7592525025823 | -122.488413720954 | (37.7592525025823, -122.488413720954) | |||
| 189126 | 189126 | 84279 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6016131.0603 | 2093656.105 | 37.7296865592841 | -122.386503619825 | (37.7296865592841, -122.386503619825) | ||
| 189125 | 189125 | 231832 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1986 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004292.74744 | 2107201.5836400003 | 37.7662168547599 | -122.42839501343201 | (37.7662168547599, -122.428395013432) | |||
| 189124 | 189124 | 179961 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 299 Lathrop Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012198.832140001 | 2086842.9214 | 37.7107604718955 | -122.399619668515 | (37.7107604718955, -122.399619668515) | |||
| 189123 | 189123 | 84613 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2029-22031 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50833 | 6000517.3597800005 | 2120966.99196 | 37.8037987541811 | -122.442441679147 | (37.8037987541811, -122.442441679147) | |
| 189120 | 189120 | 98169 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2941 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 19 | 3x3 | Permit Number 775039 | 6000613.54695 | 2116154.22533 | 37.7905896504327 | -122.44176320452299 | (37.7905896504327, -122.441763204523) | |
| 189119 | 189119 | 192323 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6011703.7817400005 | 2107812.61007 | 37.7683111734485 | -122.402804504224 | (37.7683111734485, -122.402804504224) | |||
| 189118 | 189118 | 133769 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2410 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001287.40015 | 2116702.6121799997 | 37.79213375041721 | -122.439471043978 | (37.7921337504172, -122.439471043978) | |||
| 189116 | 189116 | 197921 | Undocumented 2 | Tilia americana :: Basswood Linden 323 | 190 Irwin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6012958.27642 | 2107582.5819200003 | 37.767749533351896 | -122.39844915502701 | (37.7677495333519, -122.398449155027) | |||
| 189115 | 189115 | 53052 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2517@ SCOTT Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 5 | Permit Number 49029 | 6001372.258169999 | 2117256.0832 | 37.7936582667653 | -122.439217122188 | (37.7936582667653, -122.439217122188) | |
| 189114 | 189114 | 226186 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 148 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008641.8529900005 | 2097858.0991599998 | 37.740806894324706 | -122.412691646299 | (37.7408068943247, -122.412691646299) | |||
| 189111 | 189111 | 227095 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3651 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 6ft | 6005946.521790001 | 2104309.35666 | 37.7583689226977 | -122.422469389447 | (37.7583689226977, -122.422469389447) | |||
| 189110 | 189110 | 137859 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 20 Orben Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003149.2963 | 2115462.6131 | 37.7888348165279 | -122.43294023402599 | (37.7888348165279, -122.432940234026) | |||
| 189109 | 189109 | 222339 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 902 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003088.6063 | 2102957.06813 | 37.7544942233475 | -122.432256740954 | (37.7544942233475, -122.432256740954) | |||
| 189108 | 189108 | 192278 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009081.35576 | 2108813.05858 | 37.770911398573205 | -122.411945967131 | (37.7709113985732, -122.411945967131) | |||
| 189107 | 189107 | 119207 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5981051.50114 | 2110011.96585 | 37.7725907952116 | -122.50898926789499 | (37.7725907952116, -122.508989267895) | |||
| 189106 | 189106 | 240859 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 99 Albion St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005815.33313 | 2106780.6392099997 | 37.7651470814965 | -122.423098753019 | (37.7651470814965, -122.423098753019) | |||
| 189105 | 189105 | 235453 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 443 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006172.18998 | 2107045.3171200003 | 37.7658939558577 | -122.421883272498 | (37.7658939558577, -122.421883272498) | |||
| 189104 | 189104 | 196973 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 900 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6014457.83967 | 2102608.3730099997 | 37.754174858803296 | -122.39291425318899 | (37.7541748588033, -122.392914253189) | |||
| 189103 | 189103 | 96941 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 108 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 5995926.85193 | 2113670.95774 | 37.7835031091294 | -122.457799026544 | (37.7835031091294, -122.457799026544) | ||||
| 189102 | 189102 | 238781 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3050 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007897.85689 | 2103290.78904 | 37.7556820560028 | -122.415648672958 | (37.7556820560028, -122.415648672958) | |||
| 189100 | 189100 | 246130 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1486 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998621.8702 | 2108319.087 | 37.768962708792 | -122.448089872703 | (37.768962708792, -122.448089872703) | |||
| 189098 | 189098 | 204200 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998760.8473 | 2094991.49095 | 37.732376335602005 | -122.44665012230699 | (37.732376335602, -122.446650122307) | |||
| 189096 | 189096 | 212933 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1950 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5990982.0324 | 2102119.7924200003 | 37.7515014054748 | -122.47406293496901 | (37.7515014054748, -122.474062934969) | |||
| 189095 | 189095 | 83407 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 745 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52540 | 6007021.2303 | 2113557.8449 | 37.783823644044794 | -122.419408670548 | (37.7838236440448, -122.419408670548) | |
| 189093 | 189093 | 183550 | Undocumented 2 | Schinus molle :: California Pepper 138 | 2593 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5989227.3726 | 2097702.4617 | 37.7392707770079 | -122.479807490437 | (37.7392707770079, -122.479807490437) | |||
| 189092 | 189092 | 143539 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002781.8179 | 2118502.7622 | 37.7971614332575 | -122.434429107355 | (37.7971614332575, -122.434429107355) | |||
| 189091 | 189091 | 111384 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 340 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x5 | 6014593.215419999 | 2112428.75748 | 37.7811469919725 | -122.393133189548 | (37.7811469919725, -122.393133189548) | |||
| 189090 | 189090 | 238416 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 68 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001018.956780001 | 2106039.93414 | 37.7628414553775 | -122.439635110868 | (37.7628414553775, -122.439635110868) | |||
| 189089 | 189089 | 117809 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3840 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5983588.39645 | 2111074.63902 | 37.775657815018896 | -122.50029260305901 | (37.7756578150189, -122.500292603059) | |||
| 189088 | 189088 | 92444 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2643 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52835 | 5982411.0946 | 2097116.4843 | 37.737263493476 | -122.503331364341 | (37.737263493476, -122.503331364341) |
| 189087 | 189087 | 124257 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5994687.94836 | 2114935.07302 | 37.78690277595771 | -122.462176828634 | (37.7869027759577, -122.462176828634) | |||
| 189086 | 189086 | 204878 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 203 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992319.86511 | 2094949.31111 | 37.7318904912532 | -122.46891482886002 | (37.7318904912532, -122.46891482886) | |||
| 189085 | 189085 | 139033 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1535 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000628.7276 | 2113990.1365 | 37.784648488341496 | -122.441555317265 | (37.7846484883415, -122.441555317265) | |||
| 189084 | 189084 | 226247 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 3388 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005816.50215 | 2103176.18646 | 37.7552501655856 | -122.422838522483 | (37.7552501655856, -122.422838522483) | |||
| 189083 | 189083 | 231390 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007475.91312 | 2099467.8666 | 37.745161448558605 | -122.416837059595 | (37.7451614485586, -122.416837059595) | |||
| 189082 | 189082 | 239416 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1271 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6003261.0959 | 2100827.35219 | 37.7486563039573 | -122.431508196563 | (37.7486563039573, -122.431508196563) | |||
| 189079 | 189079 | 117920 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 727 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5983191.607000001 | 2110832.41366 | 37.7749694365706 | -122.501647249063 | (37.7749694365706, -122.501647249063) | |||
| 189076 | 189076 | 224298 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 470 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6000648.58117 | 2101290.67644 | 37.749780062602206 | -122.440575450118 | (37.7497800626022, -122.440575450118) | |||
| 189075 | 189075 | 219048 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1511 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994267.29691 | 2105231.39459 | 37.760234822608204 | -122.462927900797 | (37.7602348226082, -122.462927900797) | |||
| 189074 | 189074 | 184106 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2299 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5987259.8119 | 2104360.815 | 37.757438327672205 | -122.487099234581 | (37.7574383276722, -122.487099234581) | |||
| 189073 | 189073 | 236556 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2445 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008240.80913 | 2104185.04128 | 37.7581567411682 | -122.414525908043 | (37.7581567411682, -122.414525908043) | |||
| 189072 | 189072 | 202806 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 700 Mission Bay Blvd North | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014148.774 | 2108691.6113400003 | 37.7708609304265 | -122.394408999271 | (37.7708609304265, -122.394408999271) | |||
| 189071 | 189071 | 210353 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 116 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5993170.86596 | 2099198.21757 | 37.74360605486729 | -122.46628144035601 | (37.7436060548673, -122.466281440356) | |||
| 189070 | 189070 | 203497 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 585 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997548.43133 | 2095250.42463 | 37.733017974899504 | -122.45086036952299 | (37.7330179748995, -122.450860369523) | |||
| 189068 | 189068 | 244980 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 289 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005226.4402 | 2109722.7783 | 37.7731922392405 | -122.425344978098 | (37.7731922392405, -122.425344978098) | |||
| 189067 | 189067 | 239635 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3691 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003778.26076 | 2103599.43748 | 37.7562970969591 | -122.42991755395599 | (37.7562970969591, -122.429917553956) | |||
| 189066 | 189066 | 198682 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 Russ St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010265.525359999 | 2111657.0003299997 | 37.778786566576294 | -122.408050470058 | (37.7787865665763, -122.408050470058) | |||
| 189065 | 189065 | 188157 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1300 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015516.4206 | 2108820.46831 | 37.77129067504529 | -122.3896872384 | (37.7712906750453, -122.3896872384) | |||
| 189063 | 189063 | 62705 | Permitted Site 1 | Melaleuca styphelliodes :: Paperbark Tree 239 | 1279 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | 16 | Permit Number 23045 | 6006870.41308 | 2119076.22609 | 37.7989672544017 | -122.420322248197 | (37.7989672544017, -122.420322248197) | |
| 189061 | 189061 | 210775 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1280 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 5993026.62735 | 2106720.09282 | 37.7642508567239 | -122.467327005649 | (37.7642508567239, -122.467327005649) | |||
| 189060 | 189060 | 242523 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1746 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007971.8272400005 | 2108186.4031700003 | 37.7691284386503 | -122.415739487404 | (37.7691284386503, -122.415739487404) | |||
| 189059 | 189059 | 204171 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 701 Portola Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996920.14545 | 2099352.62395 | 37.7442456311472 | -122.453328566072 | (37.7442456311472, -122.453328566072) | |||
| 189058 | 189058 | 200839 | Undocumented 2 | Tristania conferta :: 79 | 1499 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6012131.3311 | 2106987.3608 | 37.7660690877931 | -122.40126764344 | (37.7660690877931, -122.40126764344) | |||
| 189057 | 189057 | 244124 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1763 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998142.521000001 | 2108902.4952 | 37.770537185364 | -122.449789951959 | (37.770537185364, -122.449789951959) | |||
| 189056 | 189056 | 246366 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1940 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6006763.6807 | 2106952.0622 | 37.7656712394659 | -122.419830807079 | (37.7656712394659, -122.419830807079) | |||
| 189053 | 189053 | 241893 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1305 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008569.76439 | 2097675.0673599998 | 37.7403002828328 | -122.412927964755 | (37.7403002828328, -122.412927964755) | |||
| 189052 | 189052 | 139053 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1470 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999716.3669 | 2113930.9987 | 37.784434089571704 | -122.444707517048 | (37.7844340895717, -122.444707517048) | |||
| 189050 | 189050 | 231046 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 875 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002490.77915 | 2103119.8434099997 | 37.7549072504735 | -122.434335817947 | (37.7549072504735, -122.434335817947) | |||
| 189049 | 189049 | 224725 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 Treat Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008501.01971 | 2104985.35015 | 37.7603688215875 | -122.41368259038299 | (37.7603688215875, -122.413682590383) | |||
| 189048 | 189048 | 95921 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 275 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767619 | 5988991.254980001 | 2113497.8107 | 37.782626811071296 | -122.48178053312701 | (37.7826268110713, -122.481780533127) |
| 189047 | 189047 | 241523 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4264 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6000734.8194 | 2102894.03072 | 37.754187397136505 | -122.440392210553 | (37.7541873971365, -122.440392210553) | |||
| 189044 | 189044 | 181896 | Undocumented 2 | Tree(s) :: 17 | 2343 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986379.7223 | 2099305.8434 | 37.7435073893325 | -122.489771144773 | (37.7435073893325, -122.489771144773) | |||
| 189041 | 189041 | 130818 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2205 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6003521.30137 | 2117210.30876 | 37.79365463619661 | -122.431777984168 | (37.7936546361966, -122.431777984168) | |||
| 189040 | 189040 | 127212 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2332 Baker St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999771.60185 | 2117008.74774 | 37.7928879353713 | -122.444737723873 | (37.7928879353713, -122.444737723873) | |||
| 189039 | 189039 | 117389 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1650 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6006295.544430001 | 2117317.5523599996 | 37.7941059690696 | -122.42218647533998 | (37.7941059690696, -122.42218647534) | |||
| 189038 | 189038 | 131471 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 280 Redwood St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6006315.87363 | 2112335.20118 | 37.7804268103756 | -122.421762072675 | (37.7804268103756, -122.421762072675) | |||
| 189037 | 189037 | 206564 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2044 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993156.7665 | 2101574.66751 | 37.7501303674196 | -122.46650288401399 | (37.7501303674196, -122.466502884014) | |||
| 189035 | 189035 | 195706 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 250 King St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6014489.99692 | 2110956.01492 | 37.777097439219204 | -122.39338718236601 | (37.7770974392192, -122.393387182366) | |||
| 189032 | 189032 | 30841 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2586 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1995 12:00:00 AM | 22 | Permit Number 34689 | 6002395.11591 | 2116122.86039 | 37.790604880464294 | -122.43559684281799 | (37.7906048804643, -122.435596842818) | ||
| 189031 | 189031 | 134365 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 920 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006003.89735 | 2113165.73066 | 37.782689643164396 | -122.422900390454 | (37.7826896431644, -122.422900390454) | |||
| 189028 | 189028 | 79350 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1946 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767118 | 5983237.8759 | 2101878.6369 | 37.750387624519796 | -122.500824911735 | (37.7503876245198, -122.500824911735) |
| 189027 | 189027 | 177145 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 646 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001109.079969999 | 2090060.7156599998 | 37.718971408083796 | -122.438178657041 | (37.7189714080838, -122.438178657041) | |||
| 189022 | 189022 | 43336 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 423 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 6 | Permit Number 43093 | 6003416.5357 | 2091104.1943299999 | 37.7219675345615 | -122.430277093028 | (37.7219675345615, -122.430277093028) | |
| 189020 | 189020 | 237480 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 508 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002957.32404 | 2103311.17002 | 37.755459058298605 | -122.43273604273399 | (37.7554590582986, -122.432736042734) | |||
| 189019 | 189019 | 248579 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 794 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998642.0083 | 2107670.5786 | 37.7671832202752 | -122.44797351892599 | (37.7671832202752, -122.447973518926) | |||
| 189017 | 189017 | 131199 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1847 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008657.5896 | 2119259.89568 | 37.7995721096252 | -122.414151004059 | (37.7995721096252, -122.414151004059) | |||
| 189013 | 189013 | 183208 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4208 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5982977.5431 | 2098144.6836 | 37.74011993093129 | -122.501448961428 | (37.7401199309313, -122.501448961428) | |||
| 189011 | 189011 | 80586 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1919 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985971.2412 | 2102145.8827 | 37.7512815105045 | -122.49139254176599 | (37.7512815105045, -122.491392541766) | |||
| 189010 | 189010 | 235790 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 19 Woodward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6006490.31542 | 2108352.63521 | 37.7695014774321 | -122.420875764729 | (37.7695014774321, -122.420875764729) | |||
| 189007 | 189007 | 214828 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996730.05288 | 2091219.63097 | 37.7219034920315 | -122.453398786937 | (37.7219034920315, -122.453398786937) | |||
| 189006 | 189006 | 137842 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1800X Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005085.0 | 2115443.0 | 37.7888905662133 | -122.42624156812799 | (37.7888905662133, -122.426241568128) | |||
| 189005 | 189005 | 105881 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 250 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 5997617.52659 | 2115483.20836 | 37.788576052199396 | -122.452080774722 | (37.7885760521994, -122.452080774722) | ||||
| 189003 | 189003 | 198354 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 529 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010061.1102599995 | 2112105.44077 | 37.7800064312917 | -122.408789271213 | (37.7800064312917, -122.408789271213) | |||
| 189001 | 189001 | 234324 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 115 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006201.08295 | 2102382.1354900002 | 37.753091576833796 | -122.421452136626 | (37.7530915768338, -122.421452136626) |
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");