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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97285 | 97285 | 102172 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 143029 | 143029 | 102171 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 9827 | 9827 | 173704 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |||
| 9830 | 9830 | 60472 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | 3x3 | Permit Number 20066 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |
| 10275 | 10275 | 32464 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99x Deming St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36974 | 5999085.33670349 | 2105174.9537063 | 37.7603561904001 | -122.446260575093 | (37.7603561904001, -122.446260575093) | ||
| 92691 | 92691 | 52391 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 99103 | 99103 | 52390 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 119408 | 119408 | 52392 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 145547 | 145547 | 52389 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 119045 | 119045 | 32752 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X LOBOS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5995934.0 | 2088667.0 | 37.714848906239204 | -122.455966075921 | (37.7148489062392, -122.455966075921) | ||
| 102043 | 102043 | 41729 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 143280 | 143280 | 41725 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 144874 | 144874 | 41728 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 145443 | 145443 | 41726 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 79343 | 79343 | 34456 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 999x UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38200 | 6008246.0 | 2119227.0 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | ||
| 124171 | 124171 | 34457 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 999x UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 3x3 | Permit Number 38200 | 6008246.0 | 2119227.0 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | |
| 14778 | 14778 | 32943 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 999X Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37261 | 6015287.47006 | 2104039.63341 | 37.7581508424957 | -122.39014514528499 | (37.7581508424957, -122.390145145285) |
| 134683 | 134683 | 32942 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 999X Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 13 | Permit Number 37261 | 6015289.11919 | 2103969.2804799997 | 37.757957759865604 | -122.39013452698299 | (37.7579577598656, -122.390134526983) | |
| 78138 | 78138 | 40317 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 999 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41459 | 6006351.75417313 | 2103777.48351974 | 37.7569313744996 | -122.42103015034901 | (37.7569313744996, -122.421030150349) | ||
| 4844 | 4844 | 253688 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||||
| 4848 | 4848 | 31890 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||
| 97287 | 97287 | 31892 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||
| 120635 | 120635 | 31891 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 999 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2002 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||
| 45697 | 45697 | 38488 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 999 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2003 12:00:00 AM | 12 | Permit Number 47240 | 6008353.25415 | 2118952.7565200003 | 37.7987116832495 | -122.415182364581 | (37.7987116832495, -122.415182364581) | |
| 35203 | 35203 | 96010 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767660 | 6009745.43326 | 2116416.2091099997 | 37.7918250833144 | -122.410185778057 | (37.7918250833144, -122.410185778057) |
| 47750 | 47750 | 96007 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009660.15049 | 2116404.46705 | 37.791788061820704 | -122.41048002812599 | (37.7917880618207, -122.410480028126) |
| 76026 | 76026 | 96009 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009716.9001400005 | 2116412.09513 | 37.7918121879409 | -122.41028421245701 | (37.7918121879409, -122.410284212457) |
| 78558 | 78558 | 96014 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 999 California St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767660 | 6009569.0 | 2116409.0 | 37.791795397820394 | -122.410795730189 | (37.7917953978204, -122.410795730189) | |
| 83040 | 83040 | 96012 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 999 California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767660 | 6009569.0 | 2116409.0 | 37.791795397820394 | -122.410795730189 | (37.7917953978204, -122.410795730189) | |
| 84064 | 84064 | 96013 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 999 California St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767660 | 6009569.0 | 2116409.0 | 37.791795397820394 | -122.410795730189 | (37.7917953978204, -122.410795730189) | |
| 119478 | 119478 | 96015 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 999 California St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767660 | 6009569.0 | 2116409.0 | 37.791795397820394 | -122.410795730189 | (37.7917953978204, -122.410795730189) | |
| 131555 | 131555 | 96006 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009630.99676 | 2116399.7599 | 37.791773502706796 | -122.41058056783702 | (37.7917735027068, -122.410580567837) |
| 134858 | 134858 | 96008 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009692.64051 | 2116408.6515099998 | 37.791801372693 | -122.410367907846 | (37.791801372693, -122.410367907846) |
| 170773 | 170773 | 96011 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009766.6453599995 | 2116419.41202 | 37.7918350666884 | -122.410112610112 | (37.7918350666884, -122.410112610112) |
| 3489 | 3489 | 74967 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 998 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 8 | 3x3 | 6012084.12824 | 2119041.9172900002 | 37.799165460472295 | -122.40227854024401 | (37.7991654604723, -122.402278540244) | |
| 30932 | 30932 | 74829 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 998 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | 6012078.13426 | 2119069.37262 | 37.7992405115981 | -122.402301213024 | (37.7992405115981, -122.402301213024) | ||
| 41672 | 41672 | 81720 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 998 Indiana St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 3 | 6014948.390319999 | 2104075.36829 | 37.758230150117505 | -122.39132033706001 | (37.7582301501175, -122.39132033706) | ||
| 61836 | 61836 | 81719 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 4 | 6014948.610719999 | 2104053.54358 | 37.7581702363807 | -122.391318049186 | (37.7581702363807, -122.391318049186) | ||
| 73430 | 73430 | 81717 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 5 | 6014951.75745 | 2104011.46368 | 37.758054868645395 | -122.391304224825 | (37.7580548686454, -122.391304224825) | ||
| 129675 | 129675 | 81722 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 998 Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 4 | 6014944.17963 | 2104119.9743 | 37.758352394954 | -122.39133801773899 | (37.758352394954, -122.391338017739) | ||
| 158109 | 158109 | 81718 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 998 Indiana St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 3 | 6014951.7156 | 2104031.36678 | 37.7581095159642 | -122.39130576084999 | (37.7581095159642, -122.39130576085) | ||
| 179748 | 179748 | 81721 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 3 | 6014944.54926 | 2104094.31483 | 37.7582819600733 | -122.39133494567301 | (37.7582819600733, -122.391334945673) | ||
| 187818 | 187818 | 81723 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 4 | 6014945.424980001 | 2104137.64024 | 37.7584009709475 | -122.39133494566201 | (37.7584009709475, -122.391334945662) | ||
| 91627 | 91627 | 62806 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 998 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1986 12:00:00 AM | Permit Number 23165 | 6001478.75963757 | 2111822.72775324 | 37.7787457270266 | -122.438459155796 | (37.7787457270266, -122.438459155796) | ||
| 78401 | 78401 | 49775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
| 92628 | 92628 | 49774 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
| 77883 | 77883 | 46576 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 996 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/05/2002 12:00:00 AM | Permit Number 44710 | 6003759.39576103 | 2102474.00246404 | 37.7532058498338 | -122.429902520856 | (37.7532058498338, -122.429902520856) | ||
| 86883 | 86883 | 46574 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 996 Sanchez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/05/2002 12:00:00 AM | Permit Number 44710 | 6003759.39576103 | 2102474.00246404 | 37.7532058498338 | -122.429902520856 | (37.7532058498338, -122.429902520856) | ||
| 96276 | 96276 | 46578 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 996 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/05/2002 12:00:00 AM | Permit Number 44710 | 6003759.39576103 | 2102474.00246404 | 37.7532058498338 | -122.429902520856 | (37.7532058498338, -122.429902520856) | ||
| 113982 | 113982 | 46575 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 996 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/05/2002 12:00:00 AM | Permit Number 44710 | 6003759.39576103 | 2102474.00246404 | 37.7532058498338 | -122.429902520856 | (37.7532058498338, -122.429902520856) | ||
| 116813 | 116813 | 46577 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 996 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/05/2002 12:00:00 AM | 4 | Permit Number 44710 | 6003759.39576103 | 2102474.00246404 | 37.7532058498338 | -122.429902520856 | (37.7532058498338, -122.429902520856) | |
| 109895 | 109895 | 35560 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 994 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38933 | 6005676.53456798 | 2103185.0108578 | 37.7552664968553 | -122.42332319978901 | (37.7552664968553, -122.423323199789) | ||
| 93261 | 93261 | 67116 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 994 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30535 | 5998844.26522705 | 2106564.92896199 | 37.7641589439786 | -122.447194363227 | (37.7641589439786, -122.447194363227) | ||
| 78210 | 78210 | 61170 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 993 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1983 12:00:00 AM | Permit Number 21029 | 6007622.52723732 | 2103890.01374739 | 37.757311908984 | -122.416643300115 | (37.757311908984, -122.416643300115) | ||
| 97556 | 97556 | 65252 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 992 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28051 | 6009395.74802139 | 2103403.69283522 | 37.7560761510907 | -122.41047644187 | (37.7560761510907, -122.41047644187) | ||
| 43608 | 43608 | 80804 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 991 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2003 12:00:00 AM | 2 | 6015534.52104 | 2104634.07686 | 37.759796756532005 | -122.38933223909201 | (37.759796756532, -122.389332239092) | ||
| 187543 | 187543 | 80805 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 991 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2003 12:00:00 AM | 3 | 6015535.39126 | 2104617.2014200003 | 37.7597504684343 | -122.389328050963 | (37.7597504684343, -122.389328050963) | ||
| 86329 | 86329 | 38453 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 991 Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.727463804070396 | -122.379579913535 | (37.7274638040704, -122.379579913535) | ||
| 110769 | 110769 | 38456 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 991 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.727463804070396 | -122.379579913535 | (37.7274638040704, -122.379579913535) | ||
| 116083 | 116083 | 38454 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 991 Palou Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.727463804070396 | -122.379579913535 | (37.7274638040704, -122.379579913535) | ||
| 123151 | 123151 | 38455 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 991 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.727463804070396 | -122.379579913535 | (37.7274638040704, -122.379579913535) | ||
| 33396 | 33396 | 52147 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 991 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 3 | Permit Number 48338 | 6018752.39982 | 2094769.7701 | 37.7328892306529 | -122.377518518074 | (37.7328892306529, -122.377518518074) | |
| 106640 | 106640 | 98271 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 109285 | 109285 | 98270 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | witin landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 118014 | 118014 | 98273 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 84853 | 84853 | 34486 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 990 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38212 | 6008234.44982697 | 2119317.66608687 | 37.7997069566126 | -122.41561931718799 | (37.7997069566126, -122.415619317188) | ||
| 96126 | 96126 | 34487 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 990 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38212 | 6008234.44982697 | 2119317.66608687 | 37.7997069566126 | -122.41561931718799 | (37.7997069566126, -122.415619317188) | ||
| 139575 | 139575 | 34488 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 990 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38212 | 6008234.44982697 | 2119317.66608687 | 37.7997069566126 | -122.41561931718799 | (37.7997069566126, -122.415619317188) | ||
| 103749 | 103749 | 69409 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 990 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33514 | 6001528.72905075 | 2086815.30428152 | 37.710084087104896 | -122.43649593455099 | (37.7100840871049, -122.436495934551) | ||
| 145744 | 145744 | 109499 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774984 | 6002392.9 | 2096233.9 | 37.7359945088656 | -122.43418207236999 | (37.7359945088656, -122.43418207237) |
| 179071 | 179071 | 67710 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 7 | Permit Number 31321 | 6013724.697430001 | 2112718.68187 | 37.7818947719595 | -122.396158176154 | (37.7818947719595, -122.396158176154) | |
| 102344 | 102344 | 115732 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 99 ORD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 22 | 3x3 | 6000874.0 | 2105811.0 | 37.7622046070719 | -122.44012004716801 | (37.7622046070719, -122.440120047168) | ||
| 139421 | 139421 | 108632 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 99 ORD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774601 | 6000898.0 | 2105859.0 | 37.7623377695764 | -122.440040482469 | (37.7623377695764, -122.440040482469) |
| 119552 | 119552 | 68112 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 99 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767697 | 6008270.46985677 | 2099447.7930484 | 37.7451509909812 | -122.414088190825 | (37.7451509909812, -122.414088190825) | |
| 37401 | 37401 | 35575 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | 7X6 | Permit Number 38943 | 6005733.52150857 | 2103415.89933022 | 37.7559036789868 | -122.42314253259501 | (37.7559036789868, -122.423142532595) | |
| 113761 | 113761 | 52388 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 99 Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | Permit Number 48513 | 6006895.43343812 | 2098993.06991313 | 37.7438250958144 | -122.41881059601299 | (37.7438250958144, -122.418810596013) | ||
| 143109 | 143109 | 34088 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/2002 12:00:00 AM | Permit Number 39308 | 5995595.84819231 | 2093296.84467021 | 37.7275419455651 | -122.45746962855101 | (37.7275419455651, -122.457469628551) | ||
| 79005 | 79005 | 31812 | Permitted Site 1 | Tree(s) :: 17 | 99 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2015 12:00:00 AM | Permit Number 776677 | 6001914.86865911 | 2108255.52596642 | 37.768975877879896 | -122.436695073767 | (37.7689758778799, -122.436695073767) | ||
| 84078 | 84078 | 31810 | Permitted Site 1 | Tree(s) :: 17 | 99 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2015 12:00:00 AM | Permit Number 776677 | 6001914.86865911 | 2108255.52596642 | 37.768975877879896 | -122.436695073767 | (37.7689758778799, -122.436695073767) | ||
| 101597 | 101597 | 31811 | Permitted Site 1 | Tree(s) :: 17 | 99 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2015 12:00:00 AM | Permit Number 776677 | 6001914.86865911 | 2108255.52596642 | 37.768975877879896 | -122.436695073767 | (37.7689758778799, -122.436695073767) | ||
| 121436 | 121436 | 37351 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 99 Curtis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39857 | 6000722.91615892 | 2087924.83898491 | 37.7130847996496 | -122.43936045434401 | (37.7130847996496, -122.439360454344) | ||
| 124829 | 124829 | 37350 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 99 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39857 | 6000722.91615892 | 2087924.83898491 | 37.7130847996496 | -122.43936045434401 | (37.7130847996496, -122.439360454344) | ||
| 138321 | 138321 | 37349 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 99 Curtis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39857 | 6000722.91615892 | 2087924.83898491 | 37.7130847996496 | -122.43936045434401 | (37.7130847996496, -122.439360454344) | ||
| 138577 | 138577 | 103085 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 99 Colton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.42033558182301 | (37.7728452155106, -122.420335581823) | ||
| 141309 | 141309 | 103086 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 99 Colton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.42033558182301 | (37.7728452155106, -122.420335581823) | ||
| 19635 | 19635 | 36019 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 99 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39165 | 6006729.30953986 | 2099082.13183863 | 37.744060284741295 | -122.419391331569 | (37.7440602847413, -122.419391331569) | ||
| 82633 | 82633 | 109310 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 99 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772820 | 6006724.0 | 2099085.0 | 37.7440678610189 | -122.41940989424101 | (37.7440678610189, -122.419409894241) |
| 7114 | 7114 | 45767 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997811.6954 | 2113198.143 | 37.782312986330794 | -122.45124412099399 | (37.7823129863308, -122.451244120994) |
| 107633 | 107633 | 66160 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99 Bay View St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | Permit Number 29231 | 6013641.58815417 | 2094885.58391758 | 37.7329243309061 | -122.395196144067 | (37.7329243309061, -122.395196144067) | ||
| 138612 | 138612 | 67468 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 99 Agua Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | Permit Number 30989 | 5996784.33302359 | 2098587.30616541 | 37.7421364707665 | -122.453742919924 | (37.7421364707665, -122.453742919924) | ||
| 145126 | 145126 | 73935 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 98x LANDERS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/1984 12:00:00 AM | 13 | 3x3 | 6004473.0 | 2107480.0 | 37.766991517350796 | -122.42779139415501 | (37.7669915173508, -122.427791394155) | |
| 124297 | 124297 | 59670 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 98X PARNASSUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 15 | 3x3 | Permit Number 32228 | 5998297.0 | 2106864.0 | 37.76494883262271 | -122.449108733904 | (37.7649488326227, -122.449108733904) |
| 18921 | 18921 | 32751 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X LOBOS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5996424.0 | 2088680.0 | 37.71491271306979 | -122.45427337935101 | (37.7149127130698, -122.454273379351) | ||
| 105848 | 105848 | 32749 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X LOBOS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5996424.0 | 2088680.0 | 37.71491271306979 | -122.45427337935101 | (37.7149127130698, -122.454273379351) | ||
| 126457 | 126457 | 32748 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X LOBOS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5996424.0 | 2088680.0 | 37.71491271306979 | -122.45427337935101 | (37.7149127130698, -122.454273379351) | ||
| 111474 | 111474 | 98267 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5994599.8 | 2086859.2 | 37.7098084453918 | -122.460446681932 | (37.7098084453918, -122.460446681932) | |||
| 96885 | 96885 | 36396 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98X COLON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996199.0 | 2093723.0 | 37.728746692627205 | -122.45541532696501 | (37.7287466926272, -122.455415326965) | ||
| 113250 | 113250 | 36399 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98X COLON AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996199.0 | 2093723.0 | 37.728746692627205 | -122.45541532696501 | (37.7287466926272, -122.455415326965) | ||
| 119812 | 119812 | 36397 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98X COLON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996199.0 | 2093723.0 | 37.728746692627205 | -122.45541532696501 | (37.7287466926272, -122.455415326965) | ||
| 126810 | 126810 | 36401 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98X COLON AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996199.0 | 2093723.0 | 37.728746692627205 | -122.45541532696501 | (37.7287466926272, -122.455415326965) |
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");