Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qAddress, qSiteInfo, qCareAssistant, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86822 | 86822 | 114840 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2455x HYDE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x3 | 6006980.0 | 2120877.0 | 37.803917898432395 | -122.42007090461901 | (37.8039178984324, -122.420070904619) | ||||
| 2990 | 2990 | 11143 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.12852 | 2121148.49105 | 37.804660646434996 | -122.42025584765301 | (37.804660646435, -122.420255847653) | |||
| 3132 | 3132 | 253339 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 2019X 24th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | PUC 13 | 3x3 | 5988853.0 | 2101569.0 | 37.7498655183494 | -122.481384971136 | (37.7498655183494, -122.481384971136) | ||||
| 14328 | 14328 | 29834 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1700X Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6015058.47657 | 2099001.06615 | 37.7443032965649 | -122.390585032484 | (37.7443032965649, -122.390585032484) | ||
| 77637 | 77637 | 11714 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 899X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
| 79051 | 79051 | 11687 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 799X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 79921 | 79921 | 1719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
| 85296 | 85296 | 12456 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 86430 | 86430 | 11785 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 95471 | 95471 | 24391 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/21/1995 12:00:00 AM | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
| 96335 | 96335 | 107866 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 ALEMANY BLVD | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | PUC 13 | 15 | 3x3 | 6008820.4 | 2095497.5 | 37.734335221774394 | -122.411907523711 | (37.7343352217744, -122.411907523711) | |||
| 100974 | 100974 | 87629 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991221.225523001 | 2091214.4658080002 | 37.7215720016004 | -122.472440839907 | (37.7215720016004, -122.472440839907) | ||
| 103241 | 103241 | 11760 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3x3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | |||
| 103862 | 103862 | 11145 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 104025 | 104025 | 17656 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | ||
| 104270 | 104270 | 75029 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 141X Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | FUF 1 | 02/24/2016 12:00:00 AM | 3 | This record is for lthe ot between 141-143 Arleta Ave. | 6010470.01061258 | 2087860.00753073 | 37.713456663779795 | -122.40566649087499 | (37.7134566637798, -122.405666490875) | |
| 109658 | 109658 | 11633 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 111971 | 111971 | 116809 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 1 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 122991 | 122991 | 11815 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
| 125399 | 125399 | 11871 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991566.5284818 | 2087248.8358641004 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | |||
| 128325 | 128325 | 11875 | Permitted Site 1 | Juglans californica :: Walnut: Black (s.calif) 407 | 1501X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3x3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 1980 | 1980 | 11144 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006934.8566 | 2121129.59308 | 37.8046089111446 | -122.42024506476801 | (37.8046089111446, -122.420245064768) | |||
| 2320 | 2320 | 1739 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 6010211.1306 | 2121614.8438 | 37.8061253525476 | -122.408941413862 | (37.8061253525476, -122.408941413862) | |||
| 15882 | 15882 | 29835 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1700X Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6015037.39009 | 2099016.77397 | 37.744345257128295 | -122.390659043104 | (37.7443452571283, -122.390659043104) | ||
| 27174 | 27174 | 24392 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/21/1995 12:00:00 AM | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
| 86590 | 86590 | 87630 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991221.225523001 | 2091214.4658080002 | 37.7215720016004 | -122.472440839907 | (37.7215720016004, -122.472440839907) | ||
| 93732 | 93732 | 11634 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 499X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 97337 | 97337 | 87706 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.5269799998 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | ||
| 97919 | 97919 | 11876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 104340 | 104340 | 74892 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 141X Arleta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | FUF 1 | 02/24/2016 12:00:00 AM | 3 | This is for the trees adjacent to the lot between 141-143 Arleta | 6010470.01061258 | 2087860.00753073 | 37.713456663779795 | -122.40566649087499 | (37.7134566637798, -122.405666490875) | |
| 104630 | 104630 | 11816 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
| 105274 | 105274 | 11872 | Permitted Site 1 | Juglans hindsii :: Walnut: Black (n.calif) 442 | 1499X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991566.5284818 | 2087248.8358641004 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | |||
| 105606 | 105606 | 11715 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/15/1995 12:00:00 AM | 12 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
| 113163 | 113163 | 11689 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 116303 | 116303 | 11786 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1199X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 6 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
| 128539 | 128539 | 11146 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 142437 | 142437 | 1720 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
| 145293 | 145293 | 12457 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 146001 | 146001 | 116815 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 2 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 8258 | 8258 | 1740 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010239.3355 | 2121619.2312 | 37.8061389791251 | -122.408844115422 | (37.8061389791251, -122.408844115422) | |||
| 15770 | 15770 | 29836 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1700X Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6015024.36841 | 2099025.2141299997 | 37.744367709607296 | -122.390704659402 | (37.7443677096073, -122.390704659402) | ||
| 19844 | 19844 | 27797 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 3 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
| 79410 | 79410 | 24459 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1199X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
| 79934 | 79934 | 12458 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 83384 | 83384 | 17658 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 100151 | 100151 | 27800 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 799X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
| 101927 | 101927 | 11761 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
| 106977 | 106977 | 11873 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1499X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991566.5284818 | 2087248.8358641004 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | |||
| 107376 | 107376 | 11877 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 109059 | 109059 | 11648 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/28/2000 12:00:00 AM | 3 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
| 112455 | 112455 | 11817 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
| 125164 | 125164 | 1721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
| 125554 | 125554 | 11635 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 499X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 125710 | 125710 | 85667 | Permitted Site 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 254 | 639 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012912.0 | 2111624.0 | 37.77884377468779 | -122.39889289846501 | (37.7788437746878, -122.398892898465) | ||
| 140009 | 140009 | 11147 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 144844 | 144844 | 116816 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 3 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 5751 | 5751 | 1741 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010277.5688 | 2121623.6186 | 37.8061531673047 | -122.408712111835 | (37.8061531673047, -122.408712111835) | |||
| 16509 | 16509 | 29837 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1700X Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6015003.68842 | 2099041.04772 | 37.744410037986704 | -122.39077727337099 | (37.7444100379867, -122.390777273371) | ||
| 49592 | 49592 | 11636 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 81955 | 81955 | 87698 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 799X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | ||
| 101063 | 101063 | 11148 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 107737 | 107737 | 1722 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 108403 | 108403 | 12459 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 117411 | 117411 | 17659 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 118144 | 118144 | 11649 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 699X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
| 125010 | 125010 | 24410 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1199X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
| 127145 | 127145 | 116817 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 4 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 127707 | 127707 | 11818 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
| 139746 | 139746 | 11878 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 141240 | 141240 | 11874 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991566.5284818 | 2087248.8358641004 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | |||
| 8654 | 8654 | 1742 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010362.8102 | 2121638.0345 | 37.8061975236724 | -122.408418135849 | (37.8061975236724, -122.408418135849) | |||
| 13529 | 13529 | 29838 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1700X Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014986.46906 | 2099054.93467 | 37.7444472132656 | -122.39083778516 | (37.7444472132656, -122.39083778516) | ||
| 86583 | 86583 | 11688 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 94232 | 94232 | 87707 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.5269799998 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | ||
| 110974 | 110974 | 116818 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 5 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 115308 | 115308 | 1723 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 120483 | 120483 | 11149 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 125491 | 125491 | 17660 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 127369 | 127369 | 12460 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 139267 | 139267 | 11650 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 699X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
| 139406 | 139406 | 11819 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
| 140923 | 140923 | 11637 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 499X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 143977 | 143977 | 11717 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/08/2005 12:00:00 AM | 3 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
| 18608 | 18608 | 24390 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 501X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 6 | 3 | 5991485.44871 | 2094112.7680400002 | 37.7295453093597 | -122.471738611958 | (37.7295453093597, -122.471738611958) | ||
| 59669 | 59669 | 116819 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 6 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 11 | 6010427.9948 | 2121647.4361 | 37.8062269882557 | -122.40819321595501 | (37.8062269882557, -122.408193215955) | ||||
| 81627 | 81627 | 11762 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3X3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | |||
| 85915 | 85915 | 11690 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 87807 | 87807 | 17661 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 92092 | 92092 | 24393 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 699X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
| 96704 | 96704 | 87703 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 899X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991284.231533 | 2091244.7238979999 | 37.7216587293859 | -122.472225251777 | (37.7216587293859, -122.472225251777) | ||
| 99823 | 99823 | 11150 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 101961 | 101961 | 12461 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 111936 | 111936 | 11787 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 112223 | 112223 | 1724 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
| 140503 | 140503 | 116975 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 6 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 6111 | 6111 | 1744 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 5 | 6010455.5729 | 2121649.3164 | 37.806233695246796 | -122.40809790947901 | (37.8062336952468, -122.408097909479) | |||
| 16702 | 16702 | 29840 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1700X Evans Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014944.2776 | 2099085.41213 | 37.7445285569526 | -122.390985805465 | (37.7445285569526, -122.390985805465) | ||
| 78641 | 78641 | 116976 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 7 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 79858 | 79858 | 87631 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991221.225523001 | 2091214.4658080002 | 37.7215720016004 | -122.472440839907 | (37.7215720016004, -122.472440839907) | ||
| 82768 | 82768 | 87696 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 699X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991401.754733999 | 2093132.8495200002 | 37.726849855022394 | -122.471956555148 | (37.7268498550224, -122.471956555148) |
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");