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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 95838 | 95838 | 92924 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | tree 4 on 14th st | 5992210.0 | 2097192.0 | 37.7380420035645 | -122.46945784276001 | (37.7380420035645, -122.46945784276) | ||
| 84452 | 84452 | 92923 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | tree 3 on 14th st | 5992210.0 | 2097192.0 | 37.7380420035645 | -122.46945784276001 | (37.7380420035645, -122.46945784276) | ||
| 89271 | 89271 | 92926 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 398 West Portal Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | tree 2 on 15th st | 5991862.0 | 2096794.0 | 37.7369290786614 | -122.470632059845 | (37.7369290786614, -122.470632059845) | |||
| 122422 | 122422 | 92922 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | tree 2 on 14th st. | 5992210.0 | 2097192.0 | 37.7380420035645 | -122.46945784276001 | (37.7380420035645, -122.46945784276) | ||
| 81647 | 81647 | 92928 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 West Portal Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | tree 2 on 14th st | 5992361.0 | 2097058.0 | 37.7376827987343 | -122.46892601674101 | (37.7376827987343, -122.468926016741) | |||
| 84463 | 84463 | 92925 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 398 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | tree 1 on 15th st | 5991862.0 | 2096794.0 | 37.7369290786614 | -122.470632059845 | (37.7369290786614, -122.470632059845) | |||
| 127493 | 127493 | 92943 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2800X 15TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | tree 1 on 15th st | 5991935.0 | 2096694.0 | 37.7366587249535 | -122.470372388311 | (37.7366587249535, -122.470372388311) | |||
| 79068 | 79068 | 92921 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | tree 1 on 14th st. | 5992210.0 | 2097192.0 | 37.7380420035645 | -122.46945784276001 | (37.7380420035645, -122.46945784276) | ||
| 122362 | 122362 | 92927 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | tree 1 on 14th st | 5992361.0 | 2097058.0 | 37.7376827987343 | -122.46892601674101 | (37.7376827987343, -122.468926016741) | |||
| 114717 | 114717 | 99960 | Undocumented 2 | Ulmus americana :: American Elm 119 | 279 Filbert St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | shared responsibility with 1400 Montgomery | 6011546.2 | 2120046.5 | 37.80189375856779 | -122.40421070766001 | (37.8018937585678, -122.40421070766) | ||||
| 138801 | 138801 | 115762 | Undocumented 2 | :: 54 | 84X Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | on Athens Street frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | |||
| 145417 | 145417 | 115870 | Undocumented 2 | :: 54 | 84X Cordova St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | on Athens St. Frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | ||||
| 143047 | 143047 | 115869 | Undocumented 2 | :: 54 | 84X Cordova St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | on Athens St frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | ||||
| 111624 | 111624 | 104922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 3 | Median : Yard 3 | Tree 1 | Private 1 | missing? | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
| 114615 | 114615 | 104938 | Undocumented 2 | Privet :: 262 | 101 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | missing? | 5990474.7 | 2090014.4 | 37.718233681711204 | -122.47493379652201 | (37.7182336817112, -122.474933796522) | ||||
| 80892 | 80892 | 104890 | Undocumented 2 | :: 54 | 150 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | empty | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | ||||
| 112265 | 112265 | 104738 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 200X Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree on the 23rd St side of property | 6005413.0 | 2102541.0 | 37.753483315938 | -122.42418878244499 | (37.753483315938, -122.424188782445) | ||||
| 7216 | 7216 | 92890 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 800 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Tree no. 2 on Montgomery | 6011720.98401 | 2118117.86666 | 37.796607963049 | -122.403470105059 | (37.796607963049, -122.403470105059) | ||
| 106271 | 106271 | 92908 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 802 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Tree no. 2 on Jackson St. | 6011726.0 | 2118056.0 | 37.796438372253796 | -122.40344839382601 | (37.7964383722538, -122.403448393826) | ||
| 92869 | 92869 | 99821 | Undocumented 2 | Salix spp :: Willow 218 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Tree closest to sidewalk and retaining wall | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 76486 | 76486 | 93151 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 284X Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Tree 5 on Funston. | 5991864.0342 | 2113562.75305 | 37.782971765930796 | -122.471846777677 | (37.7829717659308, -122.471846777677) | |||
| 354 | 354 | 93479 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113X Leroy Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 1.5x3 | Tree 4 on Leroy | 6008317.250990001 | 2116630.80353 | 37.792334150853 | -122.415142500331 | (37.792334150853, -122.415142500331) | ||
| 3947 | 3947 | 93478 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113X Leroy Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 1.5x3 | Tree 3 on Leroy | 6008314.47624 | 2116646.88711 | 37.792378156480396 | -122.415153240053 | (37.7923781564804, -122.415153240053) | ||
| 177136 | 177136 | 93149 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 284X Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Tree 3 on Funston. | 5991868.14141 | 2113524.63495 | 37.782867341772295 | -122.47182978962499 | (37.7828673417723, -122.471829789625) | |||
| 90092 | 90092 | 93735 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 201@ Page Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 2 on Page St. | 5999812.1 | 2109210.9 | 37.771479369328205 | -122.44403704657 | (37.7714793693282, -122.44403704657) | ||||
| 7611 | 7611 | 93477 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113X Leroy Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1.5x3 | Tree 2 on Leroy | 6008311.901880001 | 2116662.47431 | 37.7924208104303 | -122.415163251278 | (37.7924208104303, -122.415163251278) | ||
| 53961 | 53961 | 93148 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 284X Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x5 | Tree 2 on Funston. | 5991866.59303 | 2113502.9352 | 37.7828076706429 | -122.471833564338 | (37.7828076706429, -122.471833564338) | ||
| 6822 | 6822 | 93476 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113X Leroy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Tree 1 on Leroy. | 6008309.35619 | 2116677.55783 | 37.79246208300879 | -122.41517312764499 | (37.7924620830088, -122.415173127645) | ||
| 177671 | 177671 | 93147 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 284X Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Tree 1 on Funston. | 5991866.22681 | 2113485.5569 | 37.7827599334256 | -122.47183356435801 | (37.7827599334256, -122.471833564358) | |||
| 104270 | 104270 | 75029 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 141X Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | FUF 1 | 02/24/2016 12:00:00 AM | 3 | This record is for lthe ot between 141-143 Arleta Ave. | 6010470.01061258 | 2087860.00753073 | 37.713456663779795 | -122.40566649087499 | (37.7134566637798, -122.405666490875) | |
| 104340 | 104340 | 74892 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 141X Arleta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | FUF 1 | 02/24/2016 12:00:00 AM | 3 | This is for the trees adjacent to the lot between 141-143 Arleta | 6010470.01061258 | 2087860.00753073 | 37.713456663779795 | -122.40566649087499 | (37.7134566637798, -122.405666490875) | |
| 145874 | 145874 | 100769 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3701 21st St | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | Street tree w/in RoW | 6003717.0 | 2103606.0 | 37.7563116466144 | -122.43012988292 | (37.7563116466144, -122.43012988292) | ||||
| 3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
| 94452 | 94452 | 99756 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 517 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Probably planted at same time/permitted with tree no. 1 | 6001837.0 | 2100870.0 | 37.7486925868246 | -122.436435749617 | (37.7486925868246, -122.436435749617) | |||
| 69962 | 69962 | 99744 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 431 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Probably planted at same time as tree no. 1 w/same permit. CB | 6002387.0 | 2100900.0 | 37.7488061968535 | -122.43453600133999 | (37.7488061968535, -122.43453600134) | |||
| 429 | 429 | 142788 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 733 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Polk St Scape will replant | 6007029.0497 | 2113497.6534 | 37.7836588132661 | -122.419377346786 | (37.7836588132661, -122.419377346786) | ||
| 96093 | 96093 | 98227 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 207 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Planted without permit; 2' away from sewer line. | 6007132.0 | 2097003.0 | 37.7383741239705 | -122.41785156508499 | (37.7383741239705, -122.417851565085) | |||
| 141848 | 141848 | 96914 | Undocumented 2 | Magnolia spp :: Magnolia 89 | 4396X 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | 3x3 | Permit exists for 2 Magnolias on Hoffman frontage. These two appear to be about the same age. | 6000641.3 | 2102303.1 | 37.7525595190983 | -122.440673239158 | (37.7525595190983, -122.440673239158) | |
| 4383 | 4383 | 253609 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 318 Utah St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 4ft | Permit Number 780845 | 6010580.39617 | 2106780.39752 | 37.7654141639451 | -122.40661745795299 | (37.7654141639451, -122.406617457953) | |||
| 5221 | 5221 | 72132 | Undocumented 2 | Tree(s) :: 17 | 950 Wisconsin St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 12/01/2011 12:00:00 AM | 3 | 3x3 | Permit Number 780813 | 6012748.1522699995 | 2103075.8524599997 | 37.755363341648795 | -122.398859619973 | (37.7553633416488, -122.398859619973) |
| 5182 | 5182 | 225094 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 621 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780775 | 6002723.2165 | 2108842.98565 | 37.7706348030957 | -122.433941050651 | (37.7706348030957, -122.433941050651) | |
| 5171 | 5171 | 247184 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | |
| 5187 | 5187 | 247186 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.770700815109294 | -122.439956869431 | (37.7707008151093, -122.439956869431) | ||
| 3686 | 3686 | 253401 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3690 | 3690 | 253398 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3692 | 3692 | 253403 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3696 | 3696 | 253396 | Undocumented 2 | Tree(s) :: 17 | 400x Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6016185.0 | 2098125.0 | 37.741960230665995 | -122.38662864108801 | (37.741960230666, -122.386628641088) | |
| 3697 | 3697 | 253402 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3699 | 3699 | 253406 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3703 | 3703 | 253397 | Undocumented 2 | Tree(s) :: 17 | 400x Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6016185.0 | 2098125.0 | 37.741960230665995 | -122.38662864108801 | (37.741960230666, -122.386628641088) | |
| 3530 | 3530 | 123324 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 798 05th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Permit Number 780721 | 5994466.95086 | 2110266.43708 | 37.7740712286384 | -122.462602639066 | (37.7740712286384, -122.462602639066) | |||
| 3540 | 3540 | 123527 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2850 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | Permit Number 780721 | 5994500.1201 | 2110215.1995599996 | 37.77393245416361 | -122.462484184544 | (37.7739324541636, -122.462484184544) | ||
| 3579 | 3579 | 123325 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 798 05th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Permit Number 780721 | 5994467.5512 | 2110242.48836 | 37.7740055063811 | -122.46259882484101 | (37.7740055063811, -122.462598824841) | |||
| 4832 | 4832 | 70442 | Undocumented 2 | Tree(s) :: 17 | 2470 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2017 12:00:00 AM | 3 | Permit Number 780711 | 5983049.5384 | 2098315.9426 | 37.7405943893559 | -122.501212699104 | (37.7405943893559, -122.501212699104) | |
| 5061 | 5061 | 253757 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 330 Twin Peaks Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x6 | Permit Number 780692 | 5998725.10706 | 2103975.38052 | 37.75704188115579 | -122.44742009249201 | (37.7570418811558, -122.447420092492) | |||
| 5072 | 5072 | 253758 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 330 Twin Peaks Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x6 | Permit Number 780692 | 5998725.10706 | 2103975.38052 | 37.75704188115579 | -122.44742009249201 | (37.7570418811558, -122.447420092492) | |||
| 5078 | 5078 | 253759 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 330 Twin Peaks Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x6 | Permit Number 780692 | 5998725.10706 | 2103975.38052 | 37.75704188115579 | -122.44742009249201 | (37.7570418811558, -122.447420092492) | |||
| 3637 | 3637 | 253235 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 3647 | 3647 | 253240 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 3654 | 3654 | 253242 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 299X Moncada Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 3679 | 3679 | 253243 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 299X Moncada Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 2786 | 2786 | 252851 | Undocumented 2 | Olea Majestic Beauty :: 192 | 100X Langton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | Permit Number 780604 | 6010166.0 | 2110701.0 | 37.776156040570996 | -122.408327321329 | (37.776156040571, -122.408327321329) | |||
| 2767 | 2767 | 252950 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 2772 | 2772 | 252949 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 3309 | 3309 | 202650 | Undocumented 2 | Tree(s) :: 17 | 1737 Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780552 | 6011487.99785 | 2107902.18545 | 37.7685450763114 | -122.40355718732201 | (37.7685450763114, -122.403557187322) | |
| 2864 | 2864 | 209183 | Undocumented 2 | Tree(s) :: 17 | 140 Kensington Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994862.40668 | 2098482.07156 | 37.741737150351 | -122.460380669142 | (37.741737150351, -122.460380669142) | |
| 2887 | 2887 | 209188 | Undocumented 2 | Tree(s) :: 17 | 156 Kensington Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994823.818630001 | 2098534.27999 | 37.7418782818471 | -122.46051787510599 | (37.7418782818471, -122.460517875106) | |
| 2399 | 2399 | 253072 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1350 46th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5x10 | Permit Number 780489 | 5981849.666569999 | 2105897.22193 | 37.761339917853896 | -122.50592325662 | (37.7613399178539, -122.50592325662) | |||
| 5172 | 5172 | 188749 | Undocumented 2 | Tree(s) :: 17 | 150 Executive Park Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780488 | 6014108.91993 | 2086973.0281900002 | 37.7112240085512 | -122.393027016493 | (37.7112240085512, -122.393027016493) | |
| 5184 | 5184 | 188751 | Undocumented 2 | Tree(s) :: 17 | 150 Executive Park Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780488 | 6014156.58166 | 2086969.04913 | 37.7112157302901 | -122.39286200619301 | (37.7112157302901, -122.392862006193) | |
| 5185 | 5185 | 188731 | Undocumented 2 | Tree(s) :: 17 | 250 Executive Park Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780488 | 6014568.15603 | 2086931.8817200002 | 37.711136527893 | -122.391436894596 | (37.711136527893, -122.391436894596) | |
| 3034 | 3034 | 253070 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 132 Sagamore St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 0ft | Permit Number 780451 | 5995539.3842400005 | 2087458.9579900003 | 37.7115092483173 | -122.45724268539699 | (37.7115092483173, -122.457242685397) | |||
| 3873 | 3873 | 228872 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 32 Church St | 1 | : 4 | Tree 1 | Private 1 | 10/02/2017 12:00:00 AM | 3 | 4x7 | Permit Number 780415 | 6004066.01114 | 2108522.69035 | 37.7698314611737 | -122.42927346400101 | (37.7698314611737, -122.429273464001) | |
| 2852 | 2852 | 215287 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | Permit Number 780412 | 5992944.71929 | 2103190.50616 | 37.7545548052666 | -122.46735363008301 | (37.7545548052666, -122.467353630083) | ||
| 5199 | 5199 | 106301 | Undocumented 2 | Tree(s) :: 17 | 690X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780398 | 5993621.2581 | 2111409.4385599997 | 37.777160864634 | -122.46561106864701 | (37.777160864634, -122.465611068647) | |
| 5202 | 5202 | 123243 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 590 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | Permit Number 780398 | 5993481.9137 | 2111464.4660900002 | 37.7773039172851 | -122.466097100812 | (37.7773039172851, -122.466097100812) | ||
| 5204 | 5204 | 123240 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 590 08th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | Permit Number 780398 | 5993479.44876 | 2111515.72827 | 37.777444527227004 | -122.46610935382499 | (37.777444527227, -122.466109353825) | ||
| 5207 | 5207 | 100153 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 590 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 780398 | 5993481.43699 | 2111479.23814 | 37.7773444498569 | -122.46609982361299 | (37.7773444498569, -122.466099823613) | |||
| 5231 | 5231 | 123242 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 590 08th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | Permit Number 780398 | 5993480.94596 | 2111487.08691 | 37.7773659721383 | -122.46610209272801 | (37.7773659721383, -122.466102092728) | ||
| 2561 | 2561 | 125719 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3633 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | Permit Number 780396 | 5999650.86982 | 2121041.96427 | 37.803955181350105 | -122.44544560095801 | (37.8039551813501, -122.445445600958) | ||
| 2564 | 2564 | 126730 | Undocumented 2 | Tree(s) :: 17 | 2839 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 780358 | 5999405.85549 | 2118032.7905200003 | 37.7956788068866 | -122.44607691062001 | (37.7956788068866, -122.44607691062) | |
| 2683 | 2683 | 71631 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 678 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2017 12:00:00 AM | 3 | Permit Number 780356 | 5984775.35157 | 2111233.16415 | 37.776162677429205 | -122.496198392825 | (37.7761626774292, -122.496198392825) | |
| 2123 | 2123 | 128055 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 449 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780354 | 6008758.87824 | 2121765.85838 | 37.8064585449799 | -122.413977880988 | (37.8064585449799, -122.413977880988) | |
| 2228 | 2228 | 167815 | Undocumented 2 | Tree(s) :: 17 | 282 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | Permit Number 780344 | 6004374.21371 | 2109126.69451 | 37.771507353225395 | -122.42825045191799 | (37.7715073532254, -122.428250451918) | ||
| 3853 | 3853 | 246912 | Undocumented 2 | Tree(s) :: 17 | 457 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780340 | 5997564.78588 | 2107435.89495 | 37.7664772048727 | -122.451682522529 | (37.7664772048727, -122.451682522529) | |
| 2470 | 2470 | 211684 | Undocumented 2 | Tree(s) :: 17 | 95 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 780277 | 5995309.61761 | 2090529.04665 | 37.719925789337296 | -122.458258879737 | (37.7199257893373, -122.458258879737) | ||
| 2478 | 2478 | 211685 | Undocumented 2 | Tree(s) :: 17 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 780277 | 5995307.7579 | 2090507.37878 | 37.7198661876486 | -122.458263740606 | (37.7198661876486, -122.458263740606) | ||
| 2747 | 2747 | 177162 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 780274 | 6007512.10716 | 2087312.1903 | 37.711786621718296 | -122.415851310014 | (37.7117866217183, -122.415851310014) | ||
| 2758 | 2758 | 177160 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 780274 | 6007458.52227 | 2087256.96391 | 37.7116319689192 | -122.416032606129 | (37.7116319689192, -122.416032606129) | ||
| 2996 | 2996 | 178926 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 406 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 780238 | 6000939.854169999 | 2092384.3608900001 | 37.7253419851205 | -122.43893003518801 | (37.7253419851205, -122.438930035188) | ||
| 2915 | 2915 | 125433 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2700 Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780237 | 6000667.51729 | 2117651.20267 | 37.794703033474995 | -122.441683948183 | (37.794703033475, -122.441683948183) | |
| 2153 | 2153 | 251201 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | ||
| 2158 | 2158 | 251202 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | |
| 2159 | 2159 | 251203 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | |
| 2162 | 2162 | 251204 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | |
| 2277 | 2277 | 230875 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 236 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780225 | 6004378.79824 | 2096997.6993900002 | 37.7382042419264 | -122.42737041762 | (37.7382042419264, -122.42737041762) | |
| 2823 | 2823 | 184564 | Undocumented 2 | Tree(s) :: 17 | 4045 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 780224 | 5981651.1237 | 2103482.1376 | 37.7546970960302 | -122.50643081650401 | (37.7546970960302, -122.506430816504) | |
| 3399 | 3399 | 251598 | Undocumented 2 | Tree(s) :: 17 | 900x Moraga St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 09/06/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780206 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | |
| 2494 | 2494 | 183346 | Undocumented 2 | Tree(s) :: 17 | 1218 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 780189 | 5983062.3107 | 2106821.3399 | 37.7639485863173 | -122.50179767328699 | (37.7639485863173, -122.501797673287) | |
| 4349 | 4349 | 177097 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 86 San Gabriel Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:05:00 AM | 3 | 3x3 | Permit Number 780184 | 6000986.95239 | 2093579.8361799999 | 37.7286271663089 | -122.438852851774 | (37.7286271663089, -122.438852851774) |
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");