Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108029 | 108029 | 86830 | Permitted Site 1 | Araucaria heterophylla :: Norfolk Island Pine 24 | 144 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | unpermitted private planting on DPW-maintained street | 6002845.0 | 2107418.0 | 37.7667290519071 | -122.43341795453999 | (37.7667290519071, -122.43341795454) | ||
| 109303 | 109303 | 93030 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 45 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | undocumented | 6004830.0 | 2101620.0 | 37.7509215289079 | -122.42613936044901 | (37.7509215289079, -122.426139360449) | ||
| 128235 | 128235 | 93029 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 45 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 5x6 | undocumented | 6004830.0 | 2101620.0 | 37.7509215289079 | -122.42613936044901 | (37.7509215289079, -122.426139360449) | ||
| 20491 | 20491 | 85214 | Jacaranda mimosifolia :: Jacaranda 52 | 2889 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/13/2007 12:00:00 AM | 3 | 3x3 | under 3yr maintenance agreement. ends on 4/13/2007 | 6009588.01504 | 2102148.81833 | 37.75264132339179 | -122.409722943913 | (37.7526413233918, -122.409722943913) | |
| 145363 | 145363 | 85250 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1335 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/19/2007 12:00:00 AM | 15 | 3x3 | under 3yr maintenance agreement. Expires 7/19/2010. | 6001350.124369999 | 2111060.02557 | 37.7766442216524 | -122.43884948393499 | (37.7766442216524, -122.438849483935) | |
| 120951 | 120951 | 85249 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1335 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/19/2007 12:00:00 AM | 3 | 3x3 | under 3 yr maintenance agreement. expires 7/19/2010 | 6001350.124369999 | 2111060.02557 | 37.7766442216524 | -122.43884948393499 | (37.7766442216524, -122.438849483935) | |
| 340 | 340 | 191854 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 573 10th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 24 | Width 6ft | tree is in ROW therefore DPW maintained | 6009977.72395 | 2108375.30106 | 37.7697596664942 | -122.408814503513 | (37.7697596664942, -122.408814503513) | ||
| 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) | |||
| 14802 | 14802 | 24222 | Section 143 8 | Quercus suber :: Cork Oak 76 | 54 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2010 12:00:00 AM | 3 | 4x4 | this is original dpw basin record. | 6017205.2608 | 2094992.48681 | 37.7334154068844 | -122.38288292190398 | (37.7334154068844, -122.382882921904) | |
| 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) | ||||
| 127330 | 127330 | 109501 | Private 5 | Ulmus americana :: American Elm 119 | 1400X on Filbert Montgomery St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | see 279 Filbert St. Same tree; shared responsibility | 6011485.9 | 2120124.8 | 37.802105381717894 | -122.404424889694 | (37.8021053817179, -122.404424889694) | ||||
| 17026 | 17026 | 16614 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | privately planted on dpw street without permit | 6002879.45304 | 2107636.12058 | 37.7673299123847 | -122.433314375152 | (37.7673299123847, -122.433314375152) | ||
| 83526 | 83526 | 86829 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 258 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/13/2009 12:00:00 AM | 3 | 3x3 | privately planted on DPW street; unpermitted | 6002882.169263 | 2106798.606637 | 37.765030457224704 | -122.43324512978701 | (37.7650304572247, -122.433245129787) | |
| 124310 | 124310 | 16684 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 262 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1998 12:00:00 AM | 3 | 4x4 | privately planted on DPW street; unpermitted | 6002878.0000942005 | 2106783.4724173998 | 37.7649886658228 | -122.4332584684 | (37.7649886658228, -122.4332584684) | |
| 21175 | 21175 | 5356 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 220 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2015 03:17:00 PM | 3 | 6x6 | posted for removal 3/27/14 DPW | 6004796.958190001 | 2107043.90776 | 37.765812433218706 | -122.426639815582 | (37.7658124332187, -122.426639815582) | |
| 90012 | 90012 | 94626 | Permitted Site 1 | Alnus rhombifolia :: White Alder 204 | 1740 Bancroft Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 9 | permit 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
| 8577 | 8577 | 11027 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1441 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | owner Victor Seeto signed agreement 3/10/10 to maintain bricks in tree basin in a safe/accessible manner that does not damage tree or restrict growth. | 6007472.87331 | 2117336.51186 | 37.7942243630038 | -122.418114127466 | (37.7942243630038, -122.418114127466) | ||
| 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) | ||||
| 110767 | 110767 | 110456 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 200X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | next to cross walk | 5998971.779069999 | 2112109.89902 | 37.7793913048339 | -122.44715241864401 | (37.7793913048339, -122.447152418644) | |||
| 99668 | 99668 | 104881 | Private 5 | Privet :: 262 | 101 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | missing? | 5990474.7 | 2090014.4 | 37.718233681711204 | -122.47493379652201 | (37.7182336817112, -122.474933796522) | ||||
| 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) | ||||
| 97339 | 97339 | 85212 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 229 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2007 12:00:00 AM | 3 | 3x3 | maintenance agreement through 7/2/2010 | 5994738.0 | 2088050.0 | 37.7130860517587 | -122.46005525076299 | (37.7130860517587, -122.460055250763) | |
| 86057 | 86057 | 94469 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 103566 | 103566 | 94487 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 104879 | 104879 | 94466 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 126549 | 126549 | 94468 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 144608 | 144608 | 94467 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 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) | ||||
| 3514 | 3514 | 21564 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1450 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4X4 | dead | 6005645.68769 | 2114853.19648 | 37.787302788433706 | -122.424259698627 | (37.7873027884337, -122.424259698627) | ||
| 105077 | 105077 | 85251 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1151 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | 3x3 | Under 3yr maintenance agreement. Expires 6/15/2010. | 6001497.16836 | 2088486.70556 | 37.714671592027294 | -122.43672457862 | (37.7146715920273, -122.43672457862) | |
| 61148 | 61148 | 85309 | Olea europaea :: Olive Tree 41 | 1250 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/26/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.77064078968729 | -122.442827504693 | (37.7706407896873, -122.442827504693) | |
| 140895 | 140895 | 85310 | Olea europaea :: Olive Tree 41 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/27/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.77064078968729 | -122.442827504693 | (37.7706407896873, -122.442827504693) | |
| 19901 | 19901 | 21524 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2709X Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Tree was replanted 02/06/07 | 6002363.91789 | 2096241.5628900002 | 37.7360139044279 | -122.434282822689 | (37.7360139044279, -122.434282822689) | |||
| 97454 | 97454 | 105000 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 280X SAN MARCOS AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 65 | Tree tag no. 416 | 5993063.2 | 2100277.9 | 37.7465643757171 | -122.466732187112 | (37.7465643757171, -122.466732187112) | |||
| 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) | ||
| 120551 | 120551 | 13294 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2680X Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2001 12:00:00 AM | 8 | 3X3 | Tree located adjacent to 3000 Baker | 5999556.3855 | 2119169.40502 | 37.798808242360295 | -122.445637828136 | (37.7988082423603, -122.445637828136) | |
| 128507 | 128507 | 110558 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1X Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection | 6007165.9 | 2109609.0 | 37.7729892139286 | -122.418628045346 | (37.7729892139286, -122.418628045346) | |||
| 114652 | 114652 | 97162 | Property Tree 7 | Malus :: Crab Apple 235 | 478 10th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | Tree in backyard on private property; not significant. | 5992861.5 | 2112216.7 | 37.7793335349967 | -122.468298031686 | (37.7793335349967, -122.468298031686) | |||||
| 22308 | 22308 | 248932 | Landmark tree 9 | Araucaria heterophylla :: Norfolk Island Pine 24 | 46 Cook St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 | 5997514.0 | 2113392.0 | 37.7828282170553 | -122.452288002469 | (37.7828282170553, -122.452288002469) | ||||
| 114869 | 114869 | 111205 | Landmark tree 9 | Araucaria heterophylla :: Norfolk Island Pine 24 | 46 COOK ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 | 5997514.0 | 2113392.0 | 37.7828282170553 | -122.452288002469 | (37.7828282170553, -122.452288002469) | ||||
| 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) | |||
| 99553 | 99553 | 93063 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x2.5 | Tree 5 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | |||
| 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) | |||
| 128840 | 128840 | 94065 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 5 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 96625 | 96625 | 93062 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2.5x2.5 | Tree 4 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | ||
| 126310 | 126310 | 92977 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1741 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Tree 4 on Seymour St. | 6001670.119 | 2112142.3771 | 37.779634286353996 | -122.437820070618 | (37.779634286354, -122.437820070618) | |||
| 97926 | 97926 | 93120 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1555 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Tree 4 on Lyon St | 6000421.0 | 2110261.0 | 37.774397395284 | -122.44200622209299 | (37.774397395284, -122.442006222093) | ||
| 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) | ||
| 116724 | 116724 | 93001 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 395 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | Tree 4 on Harrison St | 6013360.4 | 2113007.0 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | ||
| 105829 | 105829 | 94064 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 4 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 95827 | 95827 | 93061 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x2.5 | Tree 3 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | |||
| 180376 | 180376 | 92976 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1741 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Tree 3 on Seymour St. | 6001673.9808 | 2112126.93 | 37.779592092116395 | -122.437805604344 | (37.7795920921164, -122.437805604344) | |||
| 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) | ||
| 139372 | 139372 | 93000 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 395 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | Tree 3 on Harrison St | 6013360.4 | 2113007.0 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | ||
| 116551 | 116551 | 93975 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 59@ Golden gate Ave Roselyn Ter | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Tree 3 on Golden Gate Ave | 5998204.2 | 2111419.4 | 37.777451486883294 | -122.449758011487 | (37.7774514868833, -122.449758011487) | ||||
| 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) | |||
| 145528 | 145528 | 94063 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 3 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 121533 | 121533 | 93024 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 394 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 3 on 25th St | 6005476.0 | 2101410.0 | 37.750381408432204 | -122.42389049729601 | (37.7503814084322, -122.423890497296) | ||||
| 103513 | 103513 | 93863 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Tree 3 on 18th St. | 6015474.0 | 2105663.0 | 37.76261860269621 | -122.38961341567699 | (37.7626186026962, -122.389613415677) | |||
| 139234 | 139234 | 93020 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | Tree 3 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
| 85124 | 85124 | 85121 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/27/2007 12:00:00 AM | 7 | 2x2 | Tree 2. Permit Number 49495. | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | |
| 83213 | 83213 | 93060 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x5 | Tree 2 on Willard | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | |||
| 179113 | 179113 | 92975 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1741 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Tree 2 on Seymour St. | 6001675.9117 | 2112115.8273 | 37.7795617167054 | -122.437798129123 | (37.7795617167054, -122.437798129123) | |||
| 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) | ||
| 100435 | 100435 | 92999 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 395 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Tree 2 on Harrison St | 6013360.4 | 2113007.0 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | ||
| 138791 | 138791 | 93974 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 59@ Golden Gate Ave Roselyn Ter | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Tree 2 on Golden Gate Ave | 5998204.2 | 2111419.4 | 37.777451486883294 | -122.449758011487 | (37.7774514868833, -122.449758011487) | ||||
| 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) | ||
| 142740 | 142740 | 94062 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 2 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 120498 | 120498 | 93977 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 75 Loraine Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | Tree 2 on Anza. | 5996139.989030001 | 2112289.25125 | 37.7797215523196 | -122.45696168713002 | (37.7797215523196, -122.45696168713) | ||
| 144992 | 144992 | 93023 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 394 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 2 on 25th St | 6005476.0 | 2101410.0 | 37.750381408432204 | -122.42389049729601 | (37.7503814084322, -122.423890497296) | ||||
| 103081 | 103081 | 93862 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Tree 2 on 18th St. | 6015474.0 | 2105663.0 | 37.76261860269621 | -122.38961341567699 | (37.7626186026962, -122.389613415677) | |||
| 89654 | 89654 | 93059 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x5 | Tree 1 on Willard | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | |||
| 141818 | 141818 | 92965 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3650X Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Tree 1 on Rivera St | 5981790.1 | 2100170.3 | 37.7456119015234 | -122.505704709348 | (37.7456119015234, -122.505704709348) | ||
| 119539 | 119539 | 92973 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 1 on Market St. | 6001664.0 | 2105786.0 | 37.7621809066996 | -122.437385951828 | (37.7621809066996, -122.437385951828) | ||||
| 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) | ||
| 145724 | 145724 | 93021 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1403 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x4 | Tree 1 on Judah | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
| 100287 | 100287 | 92998 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 395 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Tree 1 on Harrison St | 6013360.4 | 2113007.0 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | ||
| 87296 | 87296 | 93973 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 59@ Golden gate Ave Roselyn Ter | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Tree 1 on Golden gate Ave | 5998204.2 | 2111419.4 | 37.777451486883294 | -122.449758011487 | (37.7774514868833, -122.449758011487) | ||||
| 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) | |||
| 121161 | 121161 | 94061 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 1 on Craut. | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 90151 | 90151 | 94067 | Permitted Site 1 | Tree(s) :: 17 | 729 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2010 12:00:00 AM | 3x3 | Tree 1 on 18th St. | 6015474.0 | 2105663.0 | 37.76261860269621 | -122.38961341567699 | (37.7626186026962, -122.389613415677) | ||
| 92708 | 92708 | 85104 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 9 | 2x2 | Tree 1 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
| 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) | ||||
| 104353 | 104353 | 98250 | Permitted Site 1 | Tree(s) :: 17 | 650 Eddy St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | Sidewalk landscaping permit adjacent to building. | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) |
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");