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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1659 | 1659 | 251643 | Undocumented 2 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007328.0 | 2121670.0 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | |||
| 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) | ||||
| 5256 | 5256 | 253838 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1458 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5.5x4 | 5981900.0 | 2105162.0 | 37.759324170949604 | -122.505694672765 | (37.7593241709496, -122.505694672765) | |||
| 5541 | 5541 | 81381 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 822 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2003 12:00:00 AM | 3x3 | 6007769.502 | 2114456.07002 | 37.7863320683098 | -122.41688358241899 | (37.7863320683098, -122.416883582419) | ||
| 10027 | 10027 | 122385 | Undocumented 2 | Tree(s) :: 17 | 1642 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 778904 | 5990935.0 | 2104213.0 | 37.7572460781285 | -122.474378311379 | (37.7572460781285, -122.474378311379) | ||
| 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) | |||
| 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) | ||||
| 38343 | 38343 | 122390 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x2 | 5991007.0 | 2102078.0 | 37.7513881006776 | -122.47397354599501 | (37.7513881006776, -122.473973545995) | |||
| 82474 | 82474 | 108629 | Undocumented 2 | :: 54 | 82-98X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6002862.02202 | 2108710.63631 | 37.7702792804688 | -122.433451461668 | (37.7702792804688, -122.433451461668) | |||
| 83043 | 83043 | 108962 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 83734 | 83734 | 121582 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6013716.0 | 2106401.0 | 37.764547352750604 | -122.39574546120899 | (37.7645473527506, -122.395745461209) | |||
| 83803 | 83803 | 98247 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | I think these were planted in 2010 by FUF. | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | ||
| 86311 | 86311 | 101001 | Undocumented 2 | Tree(s) :: 17 | 500X Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/2012 12:00:00 AM | Permit Number 769389 | 6008398.5 | 2096033.1 | 37.7357821841588 | -122.413404038925 | (37.7357821841588, -122.413404038925) | ||
| 88381 | 88381 | 108965 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 93463 | 93463 | 98506 | Undocumented 2 | Tree(s) :: 17 | 135 Sussex St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/2012 12:00:00 AM | 3x3 | Permit Number 768601 | 6002042.0 | 2096528.0 | 37.7367821173785 | -122.435416304249 | (37.7367821173785, -122.435416304249) | |
| 94644 | 94644 | 109077 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5993247.8 | 2113128.2 | 37.7818585707794 | -122.467027956142 | (37.7818585707794, -122.467027956142) | ||||
| 98095 | 98095 | 98507 | Undocumented 2 | Tree(s) :: 17 | 135 Sussex St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/2012 12:00:00 AM | 3x3 | Permit Number 768601 | 6002042.0 | 2096528.0 | 37.7367821173785 | -122.435416304249 | (37.7367821173785, -122.435416304249) | |
| 102413 | 102413 | 108826 | Undocumented 2 | :: 54 | 146-150X Gillette Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6013072.89275 | 2086799.9167400002 | 37.7106910734067 | -122.39659568235001 | (37.7106910734067, -122.39659568235) | ||||
| 110078 | 110078 | 108964 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 110141 | 110141 | 96891 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 202 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/2002 12:00:00 AM | 3x3 | 6000536.2 | 2102231.9 | 37.7523580354324 | -122.44103158445499 | (37.7523580354324, -122.441031584455) | ||
| 112953 | 112953 | 118305 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399X Willard St North | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5996275.15044137 | 2110427.69020243 | 37.774617956047294 | -122.456359464233 | (37.7746179560473, -122.456359464233) | ||||
| 115978 | 115978 | 108771 | Undocumented 2 | :: 54 | 500X Lathrop Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | ||||
| 119964 | 119964 | 68048 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2000 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/2004 12:00:00 AM | Permit Number 31785 | 5993199.49138674 | 2101849.51717042 | 37.7508874994446 | -122.46637511328501 | (37.7508874994446, -122.466375113285) | ||
| 120209 | 120209 | 37756 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1233 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40103 | 6010069.75990931 | 2102022.02439605 | 37.75232016005229 | -122.40804803696501 | (37.7523201600523, -122.408048036965) | ||
| 121705 | 121705 | 82302 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 852 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | 6010413.10633886 | 2104268.77797616 | 37.7585084630291 | -122.407019031742 | (37.7585084630291, -122.407019031742) | |||
| 122059 | 122059 | 108765 | Undocumented 2 | :: 54 | 500X Lathrop Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | ||||
| 124295 | 124295 | 118306 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399X Willard St North | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5996275.15044137 | 2110427.69020243 | 37.774617956047294 | -122.456359464233 | (37.7746179560473, -122.456359464233) | ||||
| 128187 | 128187 | 98505 | Undocumented 2 | Tree(s) :: 17 | 135 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/2012 12:00:00 AM | 3x3 | Permit Number 768601 | 6002042.0 | 2096528.0 | 37.7367821173785 | -122.435416304249 | (37.7367821173785, -122.435416304249) | |
| 140112 | 140112 | 98246 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | I think these were planted by FUF in 2010. C.Buck | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | ||
| 141848 | 141848 | 96914 | Undocumented 2 | Magnolia spp :: Magnolia 89 | 4396X 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | 3x3 | Permit exists for 2 Magnolias on Hoffman frontage. These two appear to be about the same age. | 6000641.3 | 2102303.1 | 37.7525595190983 | -122.440673239158 | (37.7525595190983, -122.440673239158) | |
| 3387 | 3387 | 161273 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 566 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 0 | Width 0ft | 6002889.180369999 | 2090346.5289900003 | 37.719857269085104 | -122.432045948864 | (37.7198572690851, -122.432045948864) | ||
| 3455 | 3455 | 160606 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 745 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 0 | Width 0ft | 6002538.27018 | 2089198.0058799998 | 37.716683778298 | -122.43317690119301 | (37.716683778298, -122.433176901193) | ||
| 29342 | 29342 | 78567 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 40 Sears St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5996717.44875 | 2086996.04025 | 37.7103057728767 | -122.453137611232 | (37.7103057728767, -122.453137611232) | ||
| 39626 | 39626 | 78781 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 Laura St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5997342.70536 | 2086993.5441299998 | 37.7103347346378 | -122.450976426135 | (37.7103347346378, -122.450976426135) | ||
| 154735 | 154735 | 81046 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 35 Laura St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 0 | 5997413.7835 | 2086913.9109900002 | 37.7101201491898 | -122.450725028737 | (37.7101201491898, -122.450725028737) | ||
| 182397 | 182397 | 78518 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 Laura St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5997355.58596 | 2086978.87375 | 37.7102951905332 | -122.450930851174 | (37.7102951905332, -122.450930851174) | ||
| 13782 | 13782 | 121585 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 424 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6013758.73818 | 2105099.18568 | 37.760975233543 | -122.395506429391 | (37.760975233543, -122.395506429391) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 31327 | 31327 | 74456 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1600 Cabrillo St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 1 | 5990434.64458 | 2110641.0438200003 | 37.774866749948394 | -122.47657830845199 | (37.7748667499484, -122.476578308452) | ||
| 32196 | 32196 | 84329 | Undocumented 2 | Metrosideros spp :: 289 | 2720 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 1 | 5987112.16957 | 2111200.9124 | 37.7762107270604 | -122.48811244404699 | (37.7762107270604, -122.488112444047) | ||
| 34009 | 34009 | 70454 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2631 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 1 | 5982726.9666 | 2097193.7529 | 37.7374942155975 | -122.502244984058 | (37.7374942155975, -122.502244984058) | ||
| 36070 | 36070 | 70557 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 20 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 1 | 6004148.34946 | 2093373.6236 | 37.7282403094269 | -122.42790902788 | (37.7282403094269, -122.42790902788) | ||
| 36445 | 36445 | 106365 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1970 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 4x2 | 5981684.7966 | 2101671.2426 | 37.7497268716349 | -122.506180099858 | (37.7497268716349, -122.506180099858) | ||
| 36688 | 36688 | 72131 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 975 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/2014 12:00:00 AM | 1 | Permit Number 772897 | 6012808.0555 | 2103001.2980400003 | 37.75516196906929 | -122.398647223515 | (37.7551619690693, -122.398647223515) | |
| 37977 | 37977 | 72335 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 775 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 1 | 5988805.09626 | 2110041.06897 | 37.773124736634294 | -122.482171226619 | (37.7731247366343, -122.482171226619) | ||
| 39170 | 39170 | 75389 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010589.86723 | 2106590.9300700002 | 37.7648944592258 | -122.40657134700199 | (37.7648944592258, -122.406571347002) | ||
| 39677 | 39677 | 71213 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2130 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 1 | 5988234.1964 | 2100800.0919 | 37.7477183038635 | -122.483468434844 | (37.7477183038635, -122.483468434844) | ||
| 39790 | 39790 | 79264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 180 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5989943.75827 | 2114181.74363 | 37.7845600440954 | -122.47853534669399 | (37.7845600440954, -122.478535346694) | |||
| 41486 | 41486 | 81182 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2119 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 1 | 5982918.3441 | 2100688.6349 | 37.7471014440375 | -122.501841820419 | (37.7471014440375, -122.501841820419) | ||
| 42297 | 42297 | 80634 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 577 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 1 | 6013018.0309 | 2104352.7115 | 37.758884352052604 | -122.398015861652 | (37.7588843520526, -122.398015861652) | ||
| 42653 | 42653 | 72326 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1226 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 1 | 5994837.87053 | 2112161.8700599996 | 37.7792969379819 | -122.461457013109 | (37.7792969379819, -122.461457013109) | ||
| 43887 | 43887 | 72500 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2311 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1996 12:00:00 AM | 1 | 5986050.4379 | 2098869.9561 | 37.7422913280707 | -122.49087764471001 | (37.7422913280707, -122.49087764471) | ||
| 52169 | 52169 | 82920 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1734 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 1 | 5982872.9956 | 2103302.6049 | 37.754276013066104 | -122.502192036803 | (37.7542760130661, -122.502192036803) | ||
| 58072 | 58072 | 78399 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 735 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2016 12:00:00 AM | 1 | Permit Number 777389 | 5986605.59767 | 2110891.31043 | 37.775331081992896 | -122.48984201538299 | (37.7753310819929, -122.489842015383) | |
| 59749 | 59749 | 84260 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 660 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 1 | 5988186.45102 | 2111472.04935 | 37.777017806636 | -122.484416148832 | (37.777017806636, -122.484416148832) | ||
| 59932 | 59932 | 83369 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1055 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2014 12:00:00 AM | 1 | Permit Number 772823 | 6012226.746040001 | 2103450.91527 | 37.7563641153385 | -122.40068915850401 | (37.7563641153385, -122.400689158504) | |
| 60143 | 60143 | 72252 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 531 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 1 | 6002585.93283 | 2090796.9641 | 37.7210768666757 | -122.43312633500601 | (37.7210768666757, -122.433126335006) | ||
| 60469 | 60469 | 80737 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 186 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 1 | 6000043.5525400005 | 2087718.3093599998 | 37.7124790304587 | -122.44169374357 | (37.7124790304587, -122.44169374357) | ||
| 60538 | 60538 | 75145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010592.19708 | 2106537.02068 | 37.76474656661821 | -122.406559489431 | (37.7647465666182, -122.406559489431) | ||
| 61360 | 61360 | 83419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5988867.9747 | 2099162.5294 | 37.7432588555713 | -122.48115699763201 | (37.7432588555713, -122.481156997632) | |||
| 61537 | 61537 | 71798 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2126 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 1 | 5997657.8233 | 2109919.8494 | 37.7733028345136 | -122.451539910128 | (37.7733028345136, -122.451539910128) | ||
| 63995 | 63995 | 80365 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 500 Campbell Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 1 | 6010298.5826900005 | 2088549.9300799998 | 37.7153414628213 | -122.406307590233 | (37.7153414628213, -122.406307590233) | ||
| 64108 | 64108 | 83143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2006 12:00:00 AM | 1 | 6016637.512159999 | 2095504.68596 | 37.7347904181313 | -122.384881478104 | (37.7347904181313, -122.384881478104) | ||
| 65070 | 65070 | 78191 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 680 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 1 | 6015407.71241 | 2105894.14692 | 37.7632496064147 | -122.389858829046 | (37.7632496064147, -122.389858829046) | ||
| 65671 | 65671 | 78959 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2083 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5987558.9086 | 2101118.3339 | 37.748552784681 | -122.485826868551 | (37.748552784681, -122.485826868551) | |||
| 66621 | 66621 | 74233 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2400 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1996 12:00:00 AM | 1 | 6010292.05063 | 2106000.6973900003 | 37.7632571481177 | -122.407559806245 | (37.7632571481177, -122.407559806245) | ||
| 66759 | 66759 | 78797 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 85 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 1 | 6001030.801469999 | 2087976.50512 | 37.713244179940794 | -122.43830000075899 | (37.7132441799408, -122.438300000759) | ||
| 72825 | 72825 | 74616 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2350 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 1 | 5991316.62714 | 2112033.26872 | 37.7787405344574 | -122.473628955238 | (37.7787405344574, -122.473628955238) | ||
| 125070 | 125070 | 79413 | Undocumented 2 | Tree(s) :: 17 | 1666 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2005 12:00:00 AM | 1 | 5987817.2161 | 2103952.4133 | 37.7563494532381 | -122.485141568367 | (37.7563494532381, -122.485141568367) | ||
| 128117 | 128117 | 74740 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1600 Cabrillo St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 1 | 5990492.61047 | 2110642.71913 | 37.7748747117504 | -122.47637791678899 | (37.7748747117504, -122.476377916789) | ||
| 130363 | 130363 | 79434 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 606 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 1 | 6004043.3643 | 2110877.3492 | 37.7762954962714 | -122.42951974871 | (37.7762954962714, -122.42951974871) | ||
| 134586 | 134586 | 78989 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2319 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5988235.2891 | 2099507.8812 | 37.7441702991504 | -122.483369943638 | (37.7441702991504, -122.483369943638) | |||
| 134691 | 134691 | 71335 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 277 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 1 | 6011311.013780001 | 2111537.1063 | 37.7785158463684 | -122.404425254319 | (37.7785158463684, -122.404425254319) | ||
| 135908 | 135908 | 83938 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2518 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5986775.0522 | 2098100.4905 | 37.740220885396 | -122.48831564909099 | (37.740220885396, -122.488315649091) | |||
| 138003 | 138003 | 70633 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 514 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 1 | 3x3 | 6003062.45597 | 2090620.0521099998 | 37.720618125211 | -122.43146651207898 | (37.720618125211, -122.431466512079) | |
| 147342 | 147342 | 76428 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 300 Spear St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1998 12:00:00 AM | 1 | 6015359.03097 | 2115547.59056 | 37.7897531109548 | -122.390701840925 | (37.7897531109548, -122.390701840925) | ||
| 147888 | 147888 | 74993 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 414 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1989 12:00:00 AM | 1 | 6011197.75639 | 2112352.56567 | 37.780748577930204 | -122.404874484592 | (37.7807485779302, -122.404874484592) | ||
| 148431 | 148431 | 70574 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 361 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 1 | 6014535.60695 | 2112281.72508 | 37.7807400739275 | -122.393322195566 | (37.7807400739275, -122.393322195566) | ||
| 148642 | 148642 | 84257 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 894 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 1 | 5988243.88098 | 2109914.2292 | 37.7727438112406 | -122.48410321533899 | (37.7727438112406, -122.484103215339) | ||
| 150341 | 150341 | 72450 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3880 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 1 | 5996319.64273 | 2114949.8711200003 | 37.7870372213321 | -122.456532645474 | (37.7870372213321, -122.456532645474) | ||
| 152701 | 152701 | 79704 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 741 30th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 1 | 5986608.73592 | 2110811.35473 | 37.7751117294897 | -122.489825277977 | (37.7751117294897, -122.489825277977) | ||
| 154934 | 154934 | 80023 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 632-632 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/2002 12:00:00 AM | 1 | 6001104.7117 | 2110909.6213 | 37.7762172841329 | -122.43968765086201 | (37.7762172841329, -122.439687650862) | ||
| 157408 | 157408 | 69788 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1526 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2001 12:00:00 AM | 1 | 5982204.5216 | 2104686.309 | 37.758035976388896 | -122.50460626225299 | (37.7580359763889, -122.504606262253) | ||
| 159486 | 159486 | 70590 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 4532 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 1 | 5984535.20919 | 2111789.62528 | 37.777676489914796 | -122.497070180867 | (37.7776764899148, -122.497070180867) | ||
| 167899 | 167899 | 69965 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1039 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/1992 12:00:00 AM | 1 | 5992352.5387699995 | 2110655.12549 | 37.7750164659141 | -122.469944995693 | (37.7750164659141, -122.469944995693) | ||
| 169130 | 169130 | 79549 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 206 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2002 12:00:00 AM | 1 | 6005878.19097 | 2092769.79945 | 37.7266800504424 | -122.421886012749 | (37.7266800504424, -122.421886012749) | ||
| 169784 | 169784 | 72418 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 3878 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 1 | 5996349.46796 | 2114952.54152 | 37.7870462658131 | -122.456429650633 | (37.7870462658131, -122.456429650633) | ||
| 173778 | 173778 | 71255 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1392 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 1 | 6007494.44606 | 2117816.87319 | 37.795544530015604 | -122.418073553678 | (37.7955445300156, -122.418073553678) | ||
| 173811 | 173811 | 83658 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 735 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 1 | 6001863.16562 | 2089646.8314200002 | 37.717877833364 | -122.435542488698 | (37.717877833364, -122.435542488698) | ||
| 174137 | 174137 | 84659 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 187 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5996845.0781 | 2111686.6666 | 37.7781074773999 | -122.45447894833201 | (37.7781074773999, -122.454478948332) | |||
| 176593 | 176593 | 84231 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 178 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 1 | 5988065.203290001 | 2114809.31405 | 37.786173930503104 | -122.48508048983 | (37.7861739305031, -122.48508048983) | ||
| 178448 | 178448 | 83479 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 729 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/2010 12:00:00 AM | 1 | Permit Number 53461 | 6015479.82715 | 2105607.22668 | 37.762465784296204 | -122.389589366061 | (37.7624657842962, -122.389589366061) | |
| 180943 | 180943 | 83574 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 194-194 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 1 | 6013135.88002 | 2106202.3185099997 | 37.7639695289884 | -122.39773801610399 | (37.7639695289884, -122.397738016104) | ||
| 180951 | 180951 | 73633 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 782 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 1 | 5983562.4874599995 | 2110479.0519 | 37.7740209842304 | -122.500338183608 | (37.7740209842304, -122.500338183608) | ||
| 181929 | 181929 | 74171 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 466 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 1 | 6011049.67315 | 2111947.37062 | 37.7796277285636 | -122.405358235294 | (37.7796277285636, -122.405358235294) |
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");