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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28966 | 28966 | 242013 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3350 18th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6007139.614130001 | 2105587.52459 | 37.7619457090369 | -122.418433769026 | (37.7619457090369, -122.418433769026) | |||
| 28999 | 28999 | 222600 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 41 Roanoke St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 6ft | 6003358.58638 | 2096297.6712 | 37.736224371859606 | -122.430847858561 | (37.7362243718596, -122.430847858561) | |||
| 29025 | 29025 | 130878 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1160 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6006883.37994 | 2114899.5545099997 | 37.7874998847581 | -122.419980826847 | (37.7874998847581, -122.419980826847) | |||
| 29106 | 29106 | 229884 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 137 Bradford St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 5ft | 6009563.00843 | 2097787.4840700002 | 37.7406646584401 | -122.409501640412 | (37.7406646584401, -122.409501640412) | |||
| 29119 | 29119 | 220589 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 653 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002332.20411 | 2099716.00641 | 37.7455521185496 | -122.43464083471301 | (37.7455521185496, -122.434640834713) | |||
| 29131 | 29131 | 194397 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1797 Bancroft Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 1ft | 6013420.92243 | 2092796.80792 | 37.7271767046165 | -122.39581273756501 | (37.7271767046165, -122.395812737565) | |||
| 29149 | 29149 | 226660 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.5122 | 2108095.82328 | 37.7686970968169 | -122.426937645858 | (37.7686970968169, -122.426937645858) | |||
| 29394 | 29394 | 228372 | Undocumented 2 | Grevillea spp :: Silkoak species 369 | 3784 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 1ft | 6005132.77553 | 2104314.58442 | 37.7583373376056 | -122.425284057905 | (37.7583373376056, -122.425284057905) | |||
| 29521 | 29521 | 231336 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4864 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5997916.37939 | 2105662.1050400003 | 37.7616269560303 | -122.45033855228998 | (37.7616269560303, -122.45033855229) | |||
| 29639 | 29639 | 220335 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 523 Day St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6002527.73455 | 2098555.81183 | 37.7423775935402 | -122.433881808696 | (37.7423775935402, -122.433881808696) | |||
| 29646 | 29646 | 229482 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1557 Church St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004608.55119 | 2099805.21218 | 37.745926022487104 | -122.426775926168 | (37.7459260224871, -122.426775926168) | |||
| 29706 | 29706 | 188799 | Undocumented 2 | Bambusa spp :: Bamboo Species 346 | 370 De Haro St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6011991.8145 | 2106659.3783299997 | 37.7651607368141 | -122.401727150587 | (37.7651607368141, -122.401727150587) | |||
| 29718 | 29718 | 130970 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002945.56276 | 2118345.7946599997 | 37.796739734404 | -122.433851284829 | (37.796739734404, -122.433851284829) | |||
| 29825 | 29825 | 188590 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 762 De Haro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 2ft | 6012084.87947 | 2104884.86073 | 37.7602934997697 | -122.401280549067 | (37.7602934997697, -122.401280549067) | |||
| 29953 | 29953 | 128264 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Lombard St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6012036.74363 | 2120874.77061 | 37.8041953857812 | -122.40257146471201 | (37.8041953857812, -122.402571464712) | |||
| 30005 | 30005 | 223689 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 278 Upper Ter | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | Width 4ft | 5999412.71789 | 2106090.89076 | 37.7628898173431 | -122.445194172985 | (37.7628898173431, -122.445194172985) | |||
| 30172 | 30172 | 176454 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1609 Burrows St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6006663.80662 | 2092086.9978599998 | 37.7248494992863 | -122.41912174768801 | (37.7248494992863, -122.419121747688) | |||
| 30394 | 30394 | 196366 | Undocumented 2 | Prunus persica :: Peach 330 | 1797 Bancroft Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 1ft | 6013425.402509999 | 2092793.8234599999 | 37.7271687591255 | -122.395797040827 | (37.7271687591255, -122.395797040827) | |||
| 30452 | 30452 | 131764 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1492 Pacific Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6007026.74159 | 2117749.85493 | 37.7953341794929 | -122.419687137974 | (37.7953341794929, -122.419687137974) | |||
| 30492 | 30492 | 194157 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 301 Rhode Island St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6011751.61895 | 2106914.05853 | 37.7658466245494 | -122.40257584440701 | (37.7658466245494, -122.402575844407) | |||
| 30751 | 30751 | 117574 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 838 Grant Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 3x3 | 6010874.95685 | 2117476.8733599996 | 37.7948006593736 | -122.406352374685 | (37.7948006593736, -122.406352374685) | |||
| 30789 | 30789 | 236735 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2235 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | Width 8ft | 6002728.24168 | 2098985.0046599996 | 37.7435674334864 | -122.433219176525 | (37.7435674334864, -122.433219176525) | |||
| 30790 | 30790 | 131310 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3701 Jackson St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 3ft | 5996519.22769 | 2115911.43003 | 37.7896888606915 | -122.45591166899099 | (37.7896888606915, -122.455911668991) | |||
| 30862 | 30862 | 179685 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 218 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6003869.47166 | 2092417.36805 | 37.7255988638766 | -122.42880497658899 | (37.7255988638766, -122.428804976589) | |||
| 30955 | 30955 | 128524 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300 California St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6012616.9506 | 2116879.25162 | 37.7932570243399 | -122.400282802519 | (37.7932570243399, -122.400282802519) | |||
| 31025 | 31025 | 129553 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6012058.5984 | 2115646.10201 | 37.7898399378192 | -122.402128014397 | (37.7898399378192, -122.402128014397) | |||
| 31166 | 31166 | 125541 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 65 Heather Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5997339.5515 | 2114115.46943 | 37.7848046777406 | -122.45294375606501 | (37.7848046777406, -122.452943756065) | ||||
| 31275 | 31275 | 195449 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014736.842019999 | 2117083.55492 | 37.7939359738125 | -122.392962080059 | (37.7939359738125, -122.392962080059) | |||
| 31309 | 31309 | 128503 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 132 Bush St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6012584.68475 | 2116164.76471 | 37.791293413119604 | -122.400344237911 | (37.7912934131196, -122.400344237911) | |||
| 31352 | 31352 | 248689 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 598 Belvedere St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 2ft | 5998658.65328 | 2105780.9789299998 | 37.7619958066699 | -122.44777989743 | (37.7619958066699, -122.44777989743) | |||
| 31389 | 31389 | 211482 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 458 Orizaba Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 1ft | 5994045.41043 | 2089492.79513 | 37.7170077644759 | -122.46255364615699 | (37.7170077644759, -122.462553646157) | |||
| 31528 | 31528 | 188591 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 762 De Haro St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 2ft | 6012098.14806 | 2104884.14995 | 37.7602922883855 | -122.401234609004 | (37.7602922883855, -122.401234609004) | |||
| 31725 | 31725 | 127856 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1032 Broadway | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 6008567.79894 | 2118317.2360099996 | 37.7969787562238 | -122.41439497666401 | (37.7969787562238, -122.414394976664) | |||
| 31774 | 31774 | 246750 | Undocumented 2 | Archontophoenix cunninghamiana :: King Palm 210 | 178 Ripley St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009174.6087 | 2099095.18815 | 37.744233556835 | -122.41093692330799 | (37.744233556835, -122.410936923308) | |||
| 31876 | 31876 | 190283 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 199 New Montgomery St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012884.630030001 | 2114398.01689 | 37.786459058895396 | -122.399182357001 | (37.7864590588954, -122.399182357001) | |||
| 31988 | 31988 | 194601 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 560 Missouri St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 2ft | 6013524.119940001 | 2104470.94675 | 37.7592371740688 | -122.396273844275 | (37.7592371740688, -122.396273844275) | |||
| 31993 | 31993 | 135726 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1910 Baker St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5999972.00363 | 2115592.60206 | 37.789011004802106 | -122.443942530717 | (37.7890110048021, -122.443942530717) | |||
| 32033 | 32033 | 235482 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 106 Chattanooga St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 6004702.50004 | 2102988.75016 | 37.7546725903948 | -122.42667772741699 | (37.7546725903948, -122.426677727417) | |||
| 32331 | 32331 | 127525 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 535 Post St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6009652.45173 | 2115007.72817 | 37.787952522523604 | -122.41040799874399 | (37.7879525225236, -122.410407998744) | |||
| 32420 | 32420 | 128487 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 201 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6011932.367980001 | 2116321.01874 | 37.7916860526201 | -122.40261224357701 | (37.7916860526201, -122.402612243577) | |||
| 32476 | 32476 | 126017 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Post St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009644.05128 | 2115053.2571900003 | 37.788077063340204 | -122.410440279012 | (37.7880770633402, -122.410440279012) | |||
| 32493 | 32493 | 215383 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 270 Arch St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5992739.059780001 | 2088994.50565 | 37.7155642635536 | -122.467032825702 | (37.7155642635536, -122.467032825702) | |||
| 32945 | 32945 | 178518 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008249.62715 | 2086262.35093 | 37.708945414261606 | -122.41322803793899 | (37.7089454142616, -122.413228037939) | |||
| 32960 | 32960 | 124335 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 176 Palm Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5995959.20478 | 2113110.98096 | 37.78196742074471 | -122.457646568088 | (37.7819674207447, -122.457646568088) | |||
| 33006 | 33006 | 190233 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 536 Mission St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6013086.524119999 | 2115360.2171099996 | 37.789112285559 | -122.39855139355 | (37.789112285559, -122.39855139355) | |||
| 33047 | 33047 | 132295 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1213 Lombard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6006526.56714 | 2120062.48471 | 37.8016558891581 | -122.421582156104 | (37.8016558891581, -122.421582156104) | |||
| 33116 | 33116 | 137510 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 85 Toledo Way | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6001467.72221 | 2119937.0331200003 | 37.8010248834562 | -122.439079041178 | (37.8010248834562, -122.439079041178) | |||
| 33287 | 33287 | 118775 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 630 45th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 27 | Width 2ft | 5981986.088380001 | 2111427.82901 | 37.7765333919608 | -122.50586147692101 | (37.7765333919608, -122.505861476921) | |||
| 33419 | 33419 | 218015 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990772.5777900005 | 2099709.35635 | 37.7448708407289 | -122.474611345145 | (37.7448708407289, -122.474611345145) | |||
| 33455 | 33455 | 229568 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 120 Parnassus Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5997906.00205 | 2106832.18299 | 37.7648391005609 | -122.450458797056 | (37.7648391005609, -122.450458797056) | |||
| 33683 | 33683 | 221802 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 325 Day St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 3ft | 6003816.248819999 | 2098634.77002 | 37.7426674306639 | -122.42943214577 | (37.7426674306639, -122.42943214577) | |||
| 33746 | 33746 | 239587 | Undocumented 2 | Schinus molle :: California Pepper 138 | 105 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 5ft | 6007266.87289 | 2098693.35025 | 37.7430230396951 | -122.41750500495701 | (37.7430230396951, -122.417505004957) | |||
| 33859 | 33859 | 220622 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 58 Fountain St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6000334.98133 | 2101342.05017 | 37.7499032598351 | -122.441663574927 | (37.7499032598351, -122.441663574927) | |||
| 33874 | 33874 | 196602 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 608 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6013520.1448 | 2104276.81958 | 37.758703921979794 | -122.396273986373 | (37.7587039219798, -122.396273986373) | |||
| 33890 | 33890 | 231844 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 96 Museum Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6000872.22935 | 2106652.07973 | 37.764513903924104 | -122.44018648793501 | (37.7645139039241, -122.440186487935) | |||
| 33930 | 33930 | 179988 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 Morse St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 5998318.043769999 | 2087022.65362 | 37.7104704522241 | -122.447607562158 | (37.7104704522241, -122.447607562158) | |||
| 34064 | 34064 | 126015 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Post St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009674.03362 | 2115055.86699 | 37.788085909974605 | -122.410336729273 | (37.7880859099746, -122.410336729273) | |||
| 34157 | 34157 | 220325 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 737 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6001752.60876 | 2099682.61141 | 37.745427503077394 | -122.43664259248999 | (37.7454275030774, -122.43664259249) | |||
| 34184 | 34184 | 129681 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6012011.03614 | 2116789.35281 | 37.7929763782966 | -122.402372995143 | (37.7929763782966, -122.402372995143) | |||
| 34188 | 34188 | 221823 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 588 Ogden Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 4ft | 6007760.27568 | 2096148.55485 | 37.7360633428545 | -122.41561880828199 | (37.7360633428545, -122.415618808282) | |||
| 34297 | 34297 | 220329 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 4489 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 8ft | 6000090.03644 | 2101642.36493 | 37.7507138925428 | -122.44253216264099 | (37.7507138925428, -122.442532162641) | |||
| 34503 | 34503 | 215417 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 286 Orizaba Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 5994025.97554 | 2088461.57938 | 37.7141751725286 | -122.46254606394699 | (37.7141751725286, -122.462546063947) | ||||
| 34507 | 34507 | 129677 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012069.97592 | 2116796.7218299997 | 37.792999901879604 | -122.402169577472 | (37.7929999018796, -122.402169577472) | |||
| 34574 | 34574 | 128396 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 316 Sutter St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 2ft | 6010818.135480001 | 2115581.56402 | 37.7895934165555 | -122.40641537306801 | (37.7895934165555, -122.406415373068) | |||
| 34594 | 34594 | 211059 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2088 15th Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 6ft | 5991648.13538 | 2101268.0455099996 | 37.749201292209996 | -122.47169742662201 | (37.74920129221, -122.471697426622) | |||
| 34597 | 34597 | 211298 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 401 Orizaba Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 5ft | 5993996.41913 | 2089243.4812200002 | 37.7163203865396 | -122.462704908526 | (37.7163203865396, -122.462704908526) | |||
| 34732 | 34732 | 100681 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | 6012316.03692 | 2116830.7554099998 | 37.793107081281 | -122.401320580594 | (37.793107081281, -122.401320580594) | ||||
| 34739 | 34739 | 129549 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6012078.1031 | 2115538.76346 | 37.78954630017979 | -122.40205298038401 | (37.7895463001798, -122.402052980384) | |||
| 34772 | 34772 | 131290 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3878 Clay St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 5ft | 5996291.53313 | 2115272.33104 | 37.7879209958986 | -122.456653226584 | (37.7879209958986, -122.456653226584) | |||
| 34786 | 34786 | 126022 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 550 Geary St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009023.96612 | 2114628.9203 | 37.786877155513004 | -122.412555665234 | (37.786877155513, -122.412555665234) | |||
| 34843 | 34843 | 250128 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1798 Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6005370.71997 | 2115516.69917 | 37.78910907136579 | -122.42525826176399 | (37.7891090713658, -122.425258261764) | |||
| 34860 | 34860 | 237993 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 480 Jersey St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6001987.72906 | 2101502.95079 | 37.7504390831161 | -122.43595981461701 | (37.7504390831161, -122.435959814617) | |||
| 34865 | 34865 | 129550 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6012076.26306 | 2115552.15036 | 37.7895829547447 | -122.40206028827 | (37.7895829547447, -122.40206028827) | |||
| 34869 | 34869 | 220361 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 3378 18th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6007031.22663 | 2105582.9717 | 37.7619271056612 | -122.418808316877 | (37.7619271056612, -122.418808316877) | |||
| 34911 | 34911 | 176616 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1373 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 5999306.08729 | 2089805.4122099997 | 37.7181676947695 | -122.44439253889601 | (37.7181676947695, -122.444392538896) | |||
| 34983 | 34983 | 127970 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 362 Green St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 2ft | 6011213.49855 | 2119375.68536 | 37.800033269380705 | -122.40531474949199 | (37.8000332693807, -122.405314749492) | |||
| 35205 | 35205 | 223840 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2145 Castro St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 10ft | 6002711.92837 | 2099262.74028 | 37.7443291052999 | -122.433295425556 | (37.7443291052999, -122.433295425556) | |||
| 35252 | 35252 | 221239 | Undocumented 2 | Betula pendula :: European White Birch 146 | 207 Montcalm St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 5ft | 6010023.25186 | 2099680.69535 | 37.745888782448 | -122.40804376831001 | (37.745888782448, -122.40804376831) | |||
| 35271 | 35271 | 232573 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4490 24th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 4ft | 6000081.98126 | 2101692.80168 | 37.7508519204933 | -122.44256363892599 | (37.7508519204933, -122.442563638926) | |||
| 35364 | 35364 | 128452 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 251 Leidesdorff St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012151.25811 | 2116572.97679 | 37.7923900877774 | -122.401872599739 | (37.7923900877774, -122.401872599739) | |||
| 35429 | 35429 | 214965 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Teresita Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 5997341.38795 | 2099482.28659 | 37.7446257889394 | -122.451881359962 | (37.7446257889394, -122.451881359962) | |||
| 35452 | 35452 | 127427 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1870 Sacramento St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6005811.11401 | 2116269.47164 | 37.791200866578 | -122.423788099553 | (37.791200866578, -122.423788099553) | |||
| 35611 | 35611 | 136717 | Undocumented 2 | Tecoma stans :: Trumpet bush 389 | 1333 Pacific Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6007744.86524 | 2117813.8042900003 | 37.7955501948491 | -122.41720684013201 | (37.7955501948491, -122.417206840132) | |||
| 35691 | 35691 | 128410 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 251 Sutter St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6011310.6043300005 | 2115591.95138 | 37.789649474890204 | -122.40471220461399 | (37.7896494748902, -122.404712204614) | |||
| 35731 | 35731 | 200325 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 301 Main St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6015214.59398 | 2115265.69066 | 37.788971064105795 | -122.391181870273 | (37.7889710641058, -122.391181870273) | |||
| 35750 | 35750 | 250093 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1700 Gough St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6005332.30774 | 2115621.39854 | 37.789394379498894 | -122.425398617158 | (37.7893943794989, -122.425398617158) | |||
| 35821 | 35821 | 130973 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002952.36205 | 2118301.89076 | 37.796619571497104 | -122.43382461811501 | (37.7966195714971, -122.433824618115) | |||
| 35844 | 35844 | 128267 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Lombard St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6011926.44398 | 2120867.47841 | 37.8041692046961 | -122.402952654037 | (37.8041692046961, -122.402952654037) | |||
| 35849 | 35849 | 197509 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | 6009753.46902 | 2109444.94334 | 37.7726840927246 | -122.40966570732999 | (37.7726840927246, -122.40966570733) | ||||
| 35862 | 35862 | 204983 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 770 Myra Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 5997269.92545 | 2098069.6489 | 37.7407429372348 | -122.452026562677 | (37.7407429372348, -122.452026562677) | |||
| 35863 | 35863 | 129806 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6010377.17129 | 2116863.70379 | 37.793089185679705 | -122.40803152672702 | (37.7930891856797, -122.408031526727) | |||
| 36081 | 36081 | 130608 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3730 Webster St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6002569.200540001 | 2121458.63125 | 37.8052654036378 | -122.435376365035 | (37.8052654036378, -122.435376365035) | |||
| 36109 | 36109 | 224807 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1468 Sanchez St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 2ft | 6003911.9159 | 2099717.26212 | 37.7456451201217 | -122.42917852528099 | (37.7456451201217, -122.429178525281) | |||
| 36386 | 36386 | 214970 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Juanita Way | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5997356.998319999 | 2099424.95505 | 37.744469264646604 | -122.45182324753799 | (37.7444692646466, -122.451823247538) | |||
| 36580 | 36580 | 142827 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1714 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006619.3625 | 2116773.8493 | 37.7926313555217 | -122.421027406021 | (37.7926313555217, -122.421027406021) | |||
| 36634 | 36634 | 247287 | Undocumented 2 | :: 54 | 640 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997019.8905 | 2108844.4958 | 37.770313639572 | -122.453668930321 | (37.770313639572, -122.453668930321) | |||
| 36678 | 36678 | 245275 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 211 Montcalm St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6009973.05434 | 2099655.25827 | 37.7458161271257 | -122.408215551417 | (37.7458161271257, -122.408215551417) | |||
| 36703 | 36703 | 232957 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1500 Cole St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 5998345.3439 | 2105333.405 | 37.7607489686178 | -122.448831267855 | (37.7607489686178, -122.448831267855) | |||
| 36736 | 36736 | 205507 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1518 05th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 5994641.653519999 | 2105137.30281 | 37.7599980266194 | -122.46162636506 | (37.7599980266194, -122.46162636506) | ||||
| 37006 | 37006 | 113232 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1001 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 3x3 | 6006901.77113 | 2114384.86271 | 37.7860877036192 | -122.419880660363 | (37.7860877036192, -122.419880660363) |
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");