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) | |||
| 189128 | 189128 | 176796 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008486.43054 | 2094496.74036 | 37.7315686095034 | -122.41299143261001 | (37.7315686095034, -122.41299143261) | |||
| 189127 | 189127 | 131863 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3640 Lyon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998876.58216 | 2121318.22377 | 37.8046694831589 | -122.448144966435 | (37.8046694831589, -122.448144966435) | |||
| 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) | |
| 189122 | 189122 | 204102 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2690 Ocean Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5990691.67687 | 2095162.7954 | 37.7323824608655 | -122.474559334655 | (37.7323824608655, -122.474559334655) | |||
| 189121 | 189121 | 214450 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 45 Dorantes Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994111.5037 | 2100039.81972 | 37.7459711108718 | -122.463090021601 | (37.7459711108718, -122.463090021601) | |||
| 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) | |||
| 189117 | 189117 | 206706 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1479 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991135.602940001 | 2105348.51695 | 37.760375526938205 | -122.473767390769 | (37.7603755269382, -122.473767390769) | |||
| 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) | |||
| 189113 | 189113 | 123119 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 574 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 3ft | 5992561.79357 | 2111542.7313099997 | 37.7774656852602 | -122.469285763443 | (37.7774656852602, -122.469285763443) | |||
| 189112 | 189112 | 187998 | Undocumented 2 | Aloe barberae :: Tree aloe 350 | 2211 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6012098.53804 | 2101850.00675 | 37.7519612189539 | -122.40102006852501 | (37.7519612189539, -122.401020068525) | ||||
| 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) | |||
| 189101 | 189101 | 208366 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 700 Junipero Serra Blvd | 54 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991248.72719 | 2092445.9094099998 | 37.7249548323756 | -122.472435504713 | (37.7249548323756, -122.472435504713) | |||
| 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) | |||
| 189099 | 189099 | 209379 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1472 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5991194.711759999 | 2105382.04286 | 37.7604710034619 | -122.47356540841601 | (37.7604710034619, -122.473565408416) | |||
| 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) | |||
| 189097 | 189097 | 205746 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 33 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5993900.499 | 2101145.1165299998 | 37.748993818619795 | -122.46389985751999 | (37.7489938186198, -122.46389985752) | |||
| 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) | |
| 189094 | 189094 | 221424 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005689.534530001 | 2103630.03961 | 37.7564891759384 | -122.423309876046 | (37.7564891759384, -122.423309876046) | |||
| 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) | |||
| 189081 | 189081 | 205253 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1976 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991298.99836 | 2101963.32187 | 37.7510901338258 | -122.47295542976299 | (37.7510901338258, -122.472955429763) | |||
| 189080 | 189080 | 188626 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 24 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6016050.39554 | 2099032.09801 | 37.7444434828812 | -122.38715732045799 | (37.7444434828812, -122.387157320458) | |||
| 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) | |||
| 189078 | 189078 | 187940 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015048.62855 | 2115342.19505 | 37.7891719160015 | -122.39176144464899 | (37.7891719160015, -122.391761444649) | ||||
| 189077 | 189077 | 192894 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 345 04th St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6012507.03144 | 2112612.14811 | 37.781534427998295 | -122.400363278337 | (37.7815344279983, -122.400363278337) | |||
| 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) | |||
| 189069 | 189069 | 195235 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017260.82922 | 2097339.16357 | 37.7398619829554 | -122.382854057268 | (37.7398619829554, -122.382854057268) | ||||
| 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) | |||
| 189064 | 189064 | 185387 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2300 Sunset Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 0ft | 5985052.012999999 | 2099287.3331 | 37.743378953957794 | -122.494360600593 | (37.7433789539578, -122.494360600593) | |||
| 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) | |
| 189062 | 189062 | 250894 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 250 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986839.6011 | 2114252.83409 | 37.784574529539796 | -122.489279763454 | (37.7845745295398, -122.489279763454) | |||
| 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) | |||
| 189055 | 189055 | 250836 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 283 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986490.348619999 | 2114051.42085 | 37.7840011137113 | -122.49047321958 | (37.7840011137113, -122.49047321958) | |||
| 189054 | 189054 | 233323 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 51 Prentiss St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6008877.2756900005 | 2098293.43084 | 37.7420154302758 | -122.41190839527201 | (37.7420154302758, -122.411908395272) | |||
| 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) | |||
| 189051 | 189051 | 118424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5981802.00316 | 2111639.4369 | 37.7771035681701 | -122.50651396642 | (37.7771035681701, -122.50651396642) | |||
| 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) | |||
| 189046 | 189046 | 118637 | Undocumented 2 | Ilex spp :: Holly Species 163 | 489 45th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5981892.63195 | 2112480.11557 | 37.779417159851604 | -122.506262811826 | (37.7794171598516, -122.506262811826) | |||
| 189045 | 189045 | 219314 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 322 Havelock St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 5998659.44994 | 2092940.88551 | 37.726740062192796 | -122.44685317305 | (37.7267400621928, -122.44685317305) |
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");