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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 624 | 624 | 70356 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1912 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 5 | 6006535.5562 | 2117410.9094 | 37.7943758388735 | -122.42136264060801 | (37.7943758388735, -122.421362640608) | ||
| 959 | 959 | 83601 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2008 12:00:00 AM | 5 | 6009088.96788 | 2112689.1650900003 | 37.7815547005346 | -122.41219362785499 | (37.7815547005346, -122.412193627855) | ||
| 1060 | 1060 | 71174 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1432 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 3 | 5988368.0802 | 2099689.3718 | 37.7446763519612 | -122.48292408536301 | (37.7446763519612, -122.482924085363) | ||
| 1069 | 1069 | 80004 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 881 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2017 12:00:00 AM | 3 | Permit Number 779791 | 5982299.17664 | 2109781.12407 | 37.772030443625795 | -122.504656395048 | (37.7720304436258, -122.504656395048) | |
| 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) | |
| 4279 | 4279 | 78830 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 35 Laura St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/2017 04:01:00 PM | 3 | 5997431.0713 | 2086896.39523 | 37.7100730444948 | -122.450664016958 | (37.7100730444948, -122.450664016958) | ||
| 4330 | 4330 | 70503 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 193 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 7 | 6004252.47977 | 2092436.6780400001 | 37.725673555265395 | -122.42748232385901 | (37.7256735552654, -122.427482323859) | ||
| 4393 | 4393 | 71591 | Undocumented 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 187 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 11:19:00 AM | 3 | 5994642.6055 | 2086698.5979 | 37.709369932055004 | -122.460287110874 | (37.709369932055, -122.460287110874) | ||
| 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) | |
| 4846 | 4846 | 76677 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 3 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 4847 | 4847 | 76692 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 423 Burrows St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1988 12:00:00 AM | 13 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 5176 | 5176 | 253818 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 219 Concord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5999956.6131 | 2087048.59536 | 37.7106351918399 | -122.44194619318 | (37.7106351918399, -122.44194619318) | ||||
| 5225 | 5225 | 73666 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 725 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1988 12:00:00 AM | 8 | 6007366.2246900005 | 2113649.85624 | 37.7840957097951 | -122.418221641431 | (37.7840957097951, -122.418221641431) | ||
| 6538 | 6538 | 71898 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 455 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2015 12:00:00 AM | 3 | Permit Number 775644 | 6007926.40343 | 2114015.89838 | 37.7851322881578 | -122.416309554165 | (37.7851322881578, -122.416309554165) | |
| 7047 | 7047 | 71287 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 225 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/16/1982 12:00:00 AM | 6 | 5998480.7052 | 2112368.9268 | 37.780074457240794 | -122.448869905513 | (37.7800744572408, -122.448869905513) | ||
| 7812 | 7812 | 73980 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/23/1986 12:00:00 AM | 3 | Permit Number 769778 | 6007997.423219999 | 2113875.47963 | 37.7847507256189 | -122.416053899389 | (37.7847507256189, -122.416053899389) | |
| 7819 | 7819 | 74571 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1055 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774207 | 6008908.989 | 2115950.0282799997 | 37.7904981444129 | -122.413046908194 | (37.7904981444129, -122.413046908194) | |
| 8381 | 8381 | 71797 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2033 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 6 | 5998131.4502 | 2109940.9744 | 37.7733879494567 | -122.44990310006399 | (37.7733879494567, -122.449903100064) | ||
| 8830 | 8830 | 71801 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2170 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 8 | 5997504.5785 | 2109900.8998 | 37.77324202696929 | -122.452068634732 | (37.7732420269693, -122.452068634732) | ||
| 10248 | 10248 | 69823 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 490 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2017 12:00:00 AM | 3 | 5985346.30869 | 2112623.83377 | 37.7800144848575 | -122.49432585822201 | (37.7800144848575, -122.494325858222) | ||
| 12422 | 12422 | 70297 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2016 12:00:00 AM | 3 | 6003327.44558 | 2094643.03884 | 37.7316793628021 | -122.43083747856001 | (37.7316793628021, -122.43083747856) | ||
| 12916 | 12916 | 72155 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2014 12:00:00 AM | 3 | Permit Number 774096 | 6000883.4658699995 | 2093545.19578 | 37.7285261634496 | -122.43920812806499 | (37.7285261634496, -122.439208128065) | |
| 13616 | 13616 | 83038 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 6018593.33009 | 2097780.6594 | 37.7411477742489 | -122.378277419086 | (37.7411477742489, -122.378277419086) | |||
| 13795 | 13795 | 78433 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 870 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2016 12:00:00 AM | 3 | 6011558.925919999 | 2104265.3143 | 37.7585630053957 | -122.403056007737 | (37.7585630053957, -122.403056007737) | ||
| 15681 | 15681 | 73555 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 315 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 8 | 6011765.85635 | 2112068.38095 | 37.7800000110193 | -122.402889147539 | (37.7800000110193, -122.402889147539) | ||
| 16719 | 16719 | 71331 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 315 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 8 | 6011757.84173 | 2112077.6198 | 37.780024931232795 | -122.402917523848 | (37.7800249312328, -122.402917523848) | ||
| 19276 | 19276 | 108963 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 22988 | 22988 | 70383 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1465 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | 5982453.54 | 2105161.4635 | 37.759355260686 | -122.503780254641 | (37.759355260686, -122.503780254641) | ||
| 23470 | 23470 | 71021 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 511 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 6 | 5990601.64729 | 2111881.43393 | 37.7782822050168 | -122.476091231143 | (37.7782822050168, -122.476091231143) | ||
| 23649 | 23649 | 83478 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 10 | 6015481.04355 | 2105634.6159 | 37.762541056634 | -122.38958707191001 | (37.762541056634, -122.38958707191) | ||
| 23667 | 23667 | 71626 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 546 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6010902.3539 | 2118984.9834 | 37.7989430963584 | -122.406363890018 | (37.7989430963584, -122.406363890018) | ||
| 23692 | 23692 | 71227 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2270 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987645.1852 | 2099845.9848 | 37.7450642803204 | -122.48543517398599 | (37.7450642803204, -122.485435173986) | ||
| 23821 | 23821 | 74230 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1011 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 10 | 6011143.4423 | 2118449.9882 | 37.797487612886705 | -122.40549194088301 | (37.7974876128867, -122.405491940883) | ||
| 23884 | 23884 | 70675 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 49 Rausch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 11 | 6009740.45587 | 2110875.89947 | 37.7766124348397 | -122.409811748212 | (37.7766124348397, -122.409811748212) | ||
| 23887 | 23887 | 83255 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5983253.61867 | 2110435.38712 | 37.773882958787205 | -122.501403365431 | (37.7738829587872, -122.501403365431) | |||
| 23899 | 23899 | 72385 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 686 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 8 | 5995057.69186 | 2110887.03516 | 37.775809229939206 | -122.460604158861 | (37.7758092299392, -122.460604158861) | ||
| 23971 | 23971 | 78224 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 5 | 6009704.84764 | 2090538.9392099997 | 37.7207696402774 | -122.40850003035101 | (37.7207696402774, -122.408500030351) | ||
| 24154 | 24154 | 79962 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 751 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2002 12:00:00 AM | 2 | 5991293.33065 | 2110344.2165900003 | 37.774101509723 | -122.47358630593399 | (37.774101509723, -122.473586305934) | ||
| 24362 | 24362 | 73557 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 734 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 15 | 5982628.313080001 | 2110748.29603 | 37.774705372511704 | -122.50358954053301 | (37.7747053725117, -122.503589540533) | ||
| 24547 | 24547 | 83274 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1639X Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 5 | 6008741.72565 | 2118600.6509700003 | 37.7977667125146 | -122.41381320433001 | (37.7977667125146, -122.41381320433) | ||
| 24705 | 24705 | 74639 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 749 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 3 | 6007029.8225 | 2113512.7316900003 | 37.7837002581006 | -122.419375743216 | (37.7837002581006, -122.419375743216) | ||
| 24726 | 24726 | 72266 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 359 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 12 | 6002393.10905 | 2091502.19798 | 37.7230023412585 | -122.43384325116999 | (37.7230023412585, -122.43384325117) | ||
| 24817 | 24817 | 70493 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 53 La Grande Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6005304.47442 | 2091965.6716099998 | 37.7244397195916 | -122.42381218159599 | (37.7244397195916, -122.423812181596) | ||
| 24978 | 24978 | 70667 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 20 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 8 | 6009828.97228 | 2111081.0117200003 | 37.777180585152394 | -122.40952002252399 | (37.7771805851524, -122.409520022524) | ||
| 25010 | 25010 | 78257 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 538 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | 6003439.3186800005 | 2090205.80452 | 37.7195020449593 | -122.430134279779 | (37.7195020449593, -122.430134279779) | ||
| 25042 | 25042 | 70403 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 215 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 18 | 6006511.50188 | 2092924.3025099998 | 37.7271399781258 | -122.419707630826 | (37.7271399781258, -122.419707630826) | ||
| 25178 | 25178 | 71050 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | 11 | 6011229.446 | 2095779.1610400002 | 37.735243464197296 | -122.403598436523 | (37.7352434641973, -122.403598436523) | ||
| 25304 | 25304 | 78734 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 901 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 4 | 5997023.15719 | 2086886.0352900003 | 37.710021240846 | -122.452073093618 | (37.710021240846, -122.452073093618) | ||
| 25537 | 25537 | 71240 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1929 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 19 | 6001514.7914 | 2112836.7931 | 37.781532142896 | -122.43840717979201 | (37.781532142896, -122.438407179792) | ||
| 25545 | 25545 | 71820 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1262 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/1982 12:00:00 AM | 11 | 5988034.0091 | 2106701.9931 | 37.763911677097894 | -122.484593510615 | (37.7639116770979, -122.484593510615) | ||
| 25548 | 25548 | 71937 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1053 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 4 | 6011562.24883 | 2118965.23166 | 37.7989257551836 | -122.404079031531 | (37.7989257551836, -122.404079031531) | ||
| 25755 | 25755 | 70316 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1574 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5984074.4364 | 2104459.8766 | 37.7575240722826 | -122.49812267764 | (37.7575240722826, -122.49812267764) | ||
| 25783 | 25783 | 70682 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 414 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 8 | 6010606.08274 | 2106339.87511 | 37.764206026409795 | -122.406497569303 | (37.7642060264098, -122.406497569303) | ||
| 25826 | 25826 | 78305 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4435 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 14 | 5984852.19199 | 2111745.44954 | 37.777573766565396 | -122.49597038603301 | (37.7775737665654, -122.495970386033) | ||
| 25838 | 25838 | 75303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010591.15079 | 2106579.14528 | 37.7648621726769 | -122.40656607695699 | (37.7648621726769, -122.406566076957) | ||
| 25852 | 25852 | 70376 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1434 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 17 | 5982801.126 | 2105356.1278 | 37.7599101850833 | -122.502592561024 | (37.7599101850833, -122.502592561024) | ||
| 26003 | 26003 | 70424 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1473 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5982456.3495 | 2105108.4827 | 37.759209955641104 | -122.50376661440501 | (37.7592099556411, -122.503766614405) | ||
| 26055 | 26055 | 70169 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5233 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 3 | 5982394.507019999 | 2111657.31782 | 37.777187531817496 | -122.504465669217 | (37.7771875318175, -122.504465669217) | ||
| 26122 | 26122 | 70370 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1462 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5983119.2114 | 2105188.9573 | 37.7594698688276 | -122.50148010954901 | (37.7594698688276, -122.501480109549) | ||
| 26133 | 26133 | 71422 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 658 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 6 | 6009722.2927 | 2120212.6608 | 37.802247912275206 | -122.41053404810499 | (37.8022479122752, -122.410534048105) | ||
| 26181 | 26181 | 74488 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2334 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 1 | 5983318.4565 | 2099328.1281 | 37.7433893618735 | -122.50035771523599 | (37.7433893618735, -122.500357715236) | ||
| 26197 | 26197 | 70177 | Undocumented 2 | Melaleuca styphelliodes :: Paperbark Tree 239 | 775 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 11 | 5994102.47966 | 2110307.2614 | 37.7741623246726 | -122.463866362064 | (37.7741623246726, -122.463866362064) | ||
| 26277 | 26277 | 69804 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 510 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | 3 | 6010631.84232 | 2105884.1713400004 | 37.7629562079975 | -122.406376362283 | (37.7629562079975, -122.406376362283) | ||
| 26338 | 26338 | 71539 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 277 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 1 | 6011318.23655 | 2111544.7017900003 | 37.7785371054488 | -122.40440080264999 | (37.7785371054488, -122.40440080265) | ||
| 26375 | 26375 | 75838 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 101 Henry Adams St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | 15 | 6011420.310769999 | 2107843.20731 | 37.768379354641105 | -122.40378716196699 | (37.7683793546411, -122.403787161967) | ||
| 26435 | 26435 | 78813 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 110 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 5 | 5998921.129790001 | 2088066.27223 | 37.713370441156 | -122.445598173631 | (37.713370441156, -122.445598173631) | ||
| 26443 | 26443 | 83812 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1401 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 4 | 6008431.92619 | 2117409.9703900004 | 37.794479995297706 | -122.41480088836201 | (37.7944799952977, -122.414800888362) | ||
| 26509 | 26509 | 78220 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1168 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 11 | 6009637.32407 | 2090762.2749400001 | 37.7213790919536 | -122.408749187543 | (37.7213790919536, -122.408749187543) | ||
| 26540 | 26540 | 70481 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 934 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 3 | 6005107.91916 | 2092023.60961 | 37.7245877066523 | -122.424495766183 | (37.7245877066523, -122.424495766183) | ||
| 26561 | 26561 | 79997 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 8250 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 6 | 5981344.9471 | 2112403.2124900003 | 37.7791737487824 | -122.50815174160499 | (37.7791737487824, -122.508151741605) | ||
| 26685 | 26685 | 72437 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3770 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 8 | 5996832.97473 | 2115019.84204 | 37.7872588007918 | -122.45476169870001 | (37.7872588007918, -122.4547616987) | ||
| 26735 | 26735 | 75220 | Undocumented 2 | Magnolia spp :: Magnolia 89 | 246 Cole St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1994 12:00:00 AM | 1 | 5997870.8316 | 2109714.2746 | 37.772750574805 | -122.450788263508 | (37.772750574805, -122.450788263508) | ||
| 26855 | 26855 | 73378 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 6 | 5983190.4387300005 | 2110910.57285 | 37.775183970412996 | -122.501657073915 | (37.775183970413, -122.501657073915) | ||
| 26917 | 26917 | 84611 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2626 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 6 | 5987424.009980001 | 2110533.0833099997 | 37.7743952434606 | -122.486984660428 | (37.7743952434606, -122.486984660428) | ||
| 26966 | 26966 | 70402 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 212 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 6006462.64225 | 2092921.27798 | 37.727128920939606 | -122.419876323835 | (37.7271289209396, -122.419876323835) | ||
| 27045 | 27045 | 72016 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 112 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 10 | 6014238.82874 | 2112579.70736 | 37.7815417727734 | -122.394369772655 | (37.7815417727734, -122.394369772655) | ||
| 27152 | 27152 | 72787 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 125 Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 6000842.138719999 | 2087917.52073 | 37.7130714894434 | -122.43894785796199 | (37.7130714894434, -122.438947857962) | ||
| 27208 | 27208 | 78214 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 743 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 5 | 6011081.23974 | 2091316.8573 | 37.722982629931295 | -122.403796950193 | (37.7229826299313, -122.403796950193) | ||
| 27234 | 27234 | 73651 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2484 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1990 12:00:00 AM | 6 | 5989869.6737 | 2098462.6897 | 37.7413954601505 | -122.477642278142 | (37.7413954601505, -122.477642278142) | ||
| 27240 | 27240 | 73535 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2207 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 18 | 5987582.0279 | 2100272.2966 | 37.7462311393003 | -122.485684839892 | (37.7462311393003, -122.485684839892) | ||
| 27276 | 27276 | 84392 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2101 Jerrold Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6012504.257680001 | 2099077.65785 | 37.744371568599796 | -122.39942241122499 | (37.7443715685998, -122.399422411225) | ||
| 27369 | 27369 | 69766 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 8 | 6014547.15395 | 2096165.5632900002 | 37.7364892123042 | -122.392154828809 | (37.7364892123042, -122.392154828809) | ||
| 27394 | 27394 | 72145 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 350 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1985 12:00:00 AM | 1 | 6001088.11474 | 2092709.73665 | 37.72624382708 | -122.438440814794 | (37.72624382708, -122.438440814794) | ||
| 27399 | 27399 | 70234 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 5 | 5983192.21244 | 2110893.91815 | 37.775138345619396 | -122.501649705941 | (37.7751383456194, -122.501649705941) | ||
| 27400 | 27400 | 79632 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 66 Danton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2003 12:00:00 AM | 7 | 6002838.60108 | 2094532.2016200002 | 37.7313473196134 | -122.432519596596 | (37.7313473196134, -122.432519596596) | ||
| 27427 | 27427 | 109082 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5993123.846940001 | 2113007.94423 | 37.7815212258156 | -122.46744802506399 | (37.7815212258156, -122.467448025064) | |||
| 27453 | 27453 | 71972 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 776 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 13 | 6009259.7893900005 | 2119456.28205 | 37.8001451441351 | -122.41208105430599 | (37.8001451441351, -122.412081054306) | ||
| 27720 | 27720 | 72005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1963 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 5 | 5987221.7723 | 2101915.2958 | 37.7507213765199 | -122.487051188188 | (37.7507213765199, -122.487051188188) | ||
| 27962 | 27962 | 79969 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1209 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 2 | 6009151.65519 | 2110631.00796 | 37.7759070057295 | -122.411831280182 | (37.7759070057295, -122.411831280182) | ||
| 28035 | 28035 | 73552 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1558 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1988 12:00:00 AM | 7 | 6000334.7955 | 2110645.2290000003 | 37.775447477965706 | -122.4423320082 | (37.7754474779657, -122.4423320082) | ||
| 28065 | 28065 | 84526 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1607 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985279.5041 | 2104240.0581 | 37.756991093889496 | -122.49393892942699 | (37.7569910938895, -122.493938929427) | |||
| 28084 | 28084 | 77894 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 479 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 6 | 5991229.4686 | 2112148.09149 | 37.7790507581941 | -122.47393884706999 | (37.7790507581941, -122.47393884707) | ||
| 28242 | 28242 | 72839 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2466 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 3 | 5989244.3793 | 2098568.7958 | 37.7416504931176 | -122.479812066514 | (37.7416504931176, -122.479812066514) | ||
| 28243 | 28243 | 70581 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 366 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1994 12:00:00 AM | 16 | 5989681.74367 | 2112910.59233 | 37.7810546031553 | -122.47934879186 | (37.7810546031553, -122.47934879186) | ||
| 28284 | 28284 | 84384 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2101 Jerrold Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 4 | 6012605.75567 | 2099001.93015 | 37.7441692930905 | -122.399066135804 | (37.7441692930905, -122.399066135804) | ||
| 28339 | 28339 | 73442 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 314 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 8 | 6004223.020830001 | 2091452.87155 | 37.72297057362721 | -122.42751410409402 | (37.7229705736272, -122.427514104094) | ||
| 28420 | 28420 | 76531 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1998 12:00:00 AM | 5 | 6015319.3250400005 | 2115587.47441 | 37.789860419861895 | -122.39084200926001 | (37.7898604198619, -122.39084200926) | ||
| 28507 | 28507 | 73526 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 807 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 8 | 6009578.52705 | 2116144.74687 | 37.791070356964205 | -122.41074409605899 | (37.7910703569642, -122.410744096059) | ||
| 28586 | 28586 | 69849 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 22 Bernice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 6 | 6008480.655259999 | 2108494.13228 | 37.7700019816405 | -122.414001247166 | (37.7700019816405, -122.414001247166) | ||
| 28643 | 28643 | 72844 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2474 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 8 | 5989246.9405 | 2098504.7662 | 37.741474833316005 | -122.47979852661899 | (37.741474833316, -122.479798526619) |
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");