trees
261 rows where qCaretaker_id = 8 sorted by TreeID descending
This data as json, CSV (advanced)
| rowid | TreeID ▲ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 131664 | 87713 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1199X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991170.406953 | 2089609.549246 | 37.7171623542714 | -122.472499557475 | (37.7171623542714, -122.472499557475) | 9 | 8 | 6 | 64 | 24 | ||
| 98606 | 87710 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 999X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.52698 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | 9 | 8 | 6 | 64 | 24 | ||
| 170407 | 87709 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 999X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.52698 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | 9 | 8 | 6 | 64 | 24 | ||
| 63325 | 87708 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 999X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.52698 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | 9 | 8 | 6 | 64 | 24 | ||
| 92807 | 87707 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 999X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.52698 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | 9 | 8 | 6 | 64 | 24 | ||
| 88015 | 87706 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 999X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.52698 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | 9 | 8 | 6 | 64 | 24 | ||
| 26768 | 87705 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 899X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991284.231533 | 2091244.723898 | 37.7216587293859 | -122.472225251777 | (37.7216587293859, -122.472225251777) | 9 | 8 | 4 | 64 | 40 | ||
| 81357 | 87704 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 899X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991284.231533 | 2091244.723898 | 37.7216587293859 | -122.472225251777 | (37.7216587293859, -122.472225251777) | 9 | 8 | 4 | 64 | 40 | ||
| 94550 | 87703 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 899X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991284.231533 | 2091244.723898 | 37.7216587293859 | -122.472225251777 | (37.7216587293859, -122.472225251777) | 9 | 8 | 4 | 64 | 40 | ||
| 64783 | 87702 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 799X Junipero Serra Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | 9 | 8 | 4 | 59 | 40 | ||
| 47235 | 87701 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Junipero Serra Blvd | 27 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 8 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | 9 | 8 | 4 | 59 | 40 | |||
| 132022 | 87700 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 799X Junipero Serra Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | 9 | 8 | 4 | 59 | 40 | ||
| 32850 | 87699 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 799X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | 9 | 8 | 4 | 59 | 40 | ||
| 39758 | 87698 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 799X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | 9 | 8 | 4 | 59 | 40 | ||
| 101704 | 87697 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 699X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991401.754734 | 2093132.84952 | 37.7268498550224 | -122.471956555148 | (37.7268498550224, -122.471956555148) | 9 | 8 | 4 | 59 | 40 | ||
| 56955 | 87696 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 699X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991401.754734 | 2093132.84952 | 37.7268498550224 | -122.471956555148 | (37.7268498550224, -122.471956555148) | 9 | 8 | 4 | 59 | 40 | ||
| 159354 | 87632 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991221.225523 | 2091214.465808 | 37.7215720016004 | -122.472440839907 | (37.7215720016004, -122.472440839907) | 9 | 8 | 4 | 64 | 40 | ||
| 48416 | 87631 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991221.225523 | 2091214.465808 | 37.7215720016004 | -122.472440839907 | (37.7215720016004, -122.472440839907) | 9 | 8 | 4 | 64 | 40 | ||
| 66468 | 87630 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991221.225523 | 2091214.465808 | 37.7215720016004 | -122.472440839907 | (37.7215720016004, -122.472440839907) | 9 | 8 | 4 | 64 | 40 | ||
| 110339 | 87629 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991221.225523 | 2091214.465808 | 37.7215720016004 | -122.472440839907 | (37.7215720016004, -122.472440839907) | 9 | 8 | 4 | 64 | 40 | ||
| 36728 | 85667 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 639 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012912 | 2111624 | 37.7788437746878 | -122.398892898465 | (37.7788437746878, -122.398892898465) | 6 | 2 | 9 | 28856 | 34 | ||
| 157419 | 85427 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | 9 | 8 | 4 | 59 | 40 | |||
| 91312 | 85425 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | 9 | 8 | 4 | 59 | 40 | |||
| 123948 | 75029 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 02/24/2016 12:00:00 AM | 3 | This record is for lthe ot between 141-143 Arleta Ave. | 6010470.01061258 | 2087860.00753073 | 37.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
| 132603 | 74892 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 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.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
| 179439 | 29858 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1700X Evans Ave | 13 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 4X4 | 6014689.41423 | 2099276.62431 | 37.7450394402319 | -122.391880446552 | (37.7450394402319, -122.391880446552) | 10 | 3 | 8 | 58 | 1 | |||
| 3304 | 29846 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1700X Evans Ave | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014879.93963 | 2099132.42343 | 37.7446540699209 | -122.391211560464 | (37.7446540699209, -122.391211560464) | 10 | 3 | 8 | 58 | 1 | ||
| 187741 | 29844 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1700X Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014896.13106 | 2099120.97008 | 37.74462351995 | -122.3911547728 | (37.74462351995, -122.3911547728) | 10 | 3 | 8 | 58 | 1 | ||
| 27122 | 29840 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1700X Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014944.2776 | 2099085.41213 | 37.7445285569526 | -122.390985805465 | (37.7445285569526, -122.390985805465) | 10 | 3 | 8 | 58 | 1 | ||
| 41533 | 29838 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1700X Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014986.46906 | 2099054.93467 | 37.7444472132656 | -122.39083778516 | (37.7444472132656, -122.39083778516) | 10 | 3 | 8 | 58 | 1 | ||
| 97083 | 29837 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1700X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6015003.68842 | 2099041.04772 | 37.7444100379867 | -122.390777273371 | (37.7444100379867, -122.390777273371) | 10 | 3 | 8 | 58 | 1 | ||
| 135230 | 29836 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1700X Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6015024.36841 | 2099025.21413 | 37.7443677096073 | -122.390704659402 | (37.7443677096073, -122.390704659402) | 10 | 3 | 8 | 58 | 1 | ||
| 178282 | 29835 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1700X Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6015037.39009 | 2099016.77397 | 37.7443452571283 | -122.390659043104 | (37.7443452571283, -122.390659043104) | 10 | 3 | 8 | 58 | 1 | ||
| 125664 | 29834 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1700X Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6015058.47657 | 2099001.06615 | 37.7443032965649 | -122.390585032484 | (37.7443032965649, -122.390585032484) | 10 | 3 | 8 | 58 | 1 | ||
| 23170 | 28848 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
| 170648 | 27826 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Junipero Serra Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/08/2005 12:00:00 AM | 3 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | ||
| 106861 | 27800 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 799X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | ||
| 73084 | 27799 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/08/2005 12:00:00 AM | 3 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
| 1663 | 27797 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 3 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
| 193865 | 26172 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
| 137783 | 26171 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/01/2000 12:00:00 AM | 30 | 3x3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | ||
| 39088 | 255806 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 255X Evelyn Way | 1 | Median : Yard | Tree | PUC 8 | 10x10 | 5998108 | 2098711 | 37.742551901709 | -122.449175024155 | (37.742551901709, -122.449175024155) | 9 | 7 | 4 | 59 | 40 | ||||
| 53415 | 254271 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1201X Junipero Serra Blvd | 1 | Side Yard : Yard | Tree | PUC 8 | 10x10 | 5991180 | 2089593 | 37.717117469349 | -122.472465193375 | (37.717117469349, -122.472465193375) | 9 | 8 | 6 | 64 | 24 | ||||
| 112077 | 253339 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 2019X 24th Ave | 1 | Sidewalk: Property side : Yard | Tree | PUC 8 | 3x3 | 5988853 | 2101569 | 37.7498655183494 | -122.481384971136 | (37.7498655183494, -122.481384971136) | 1 | 8 | 3 | 29491 | 35 | ||||
| 76902 | 24461 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1199X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
| 83353 | 24460 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/22/1995 12:00:00 AM | 6 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
| 55084 | 24459 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1199X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
| 29397 | 24458 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 6 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 71990 | 24457 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 999X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 131171 | 24456 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Junipero Serra Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/22/1995 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | ||
| 134137 | 24414 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
| 193977 | 24413 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/22/1995 12:00:00 AM | 6 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
| 31724 | 24412 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
| 35376 | 24410 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1199X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
| 17286 | 24406 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/28/2000 12:00:00 AM | 6 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 170020 | 24405 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/28/2000 12:00:00 AM | 12 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 74809 | 24402 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/01/2000 12:00:00 AM | 6 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
| 92194 | 24401 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 12 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
| 126039 | 24400 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/15/1995 12:00:00 AM | 6 | 3x3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | ||
| 67784 | 24399 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/15/1995 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | ||
| 52387 | 24398 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Junipero Serra Blvd | 30 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/01/2000 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | ||
| 95450 | 24397 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 699X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | ||
| 23572 | 24396 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 699X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | ||
| 150522 | 24395 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 699X Junipero Serra Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/22/1995 12:00:00 AM | 6 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | ||
| 34542 | 24394 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 699X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | ||
| 86803 | 24393 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 699X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | ||
| 12893 | 24392 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 699X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/21/1995 12:00:00 AM | 12 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | ||
| 79092 | 24391 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 699X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/21/1995 12:00:00 AM | 12 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | ||
| 65281 | 24390 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 501X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/22/1995 12:00:00 AM | 6 | 3 | 5991485.44871 | 2094112.76804 | 37.7295453093597 | -122.471738611958 | (37.7295453093597, -122.471738611958) | 9 | 8 | 4 | 59 | 40 | ||
| 130244 | 17662 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | |||
| 63614 | 17661 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | |||
| 20881 | 17660 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | |||
| 158167 | 17659 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | |||
| 52940 | 17658 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | |||
| 119788 | 17656 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | ||
| 103141 | 1756 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 19 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 5 | 6010168.4492363 | 2121611.1016263 | 37.8061126865638 | -122.409088856241 | (37.8061126865638, -122.409088856241) | 3 | 1 | 10 | 308 | 23 | |||
| 166972 | 1755 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 18 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 5 | 6010168.4492363 | 2121611.1016263 | 37.8061126865638 | -122.409088856241 | (37.8061126865638, -122.409088856241) | 3 | 1 | 10 | 308 | 23 | |||
| 94104 | 1754 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 17 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 5 | 6010168.4492363 | 2121611.1016263 | 37.8061126865638 | -122.409088856241 | (37.8061126865638, -122.409088856241) | 3 | 1 | 10 | 308 | 23 | |||
| 48631 | 1752 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 16 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 5 | 6010681.2119 | 2121680.6552 | 37.8063323749123 | -122.407319254019 | (37.8063323749123, -122.407319254019) | 3 | 1 | 10 | 308 | 23 | |||
| 161775 | 1751 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 5 | 6010656.7677 | 2121676.8945 | 37.8063206808441 | -122.407403582579 | (37.8063206808441, -122.407403582579) | 3 | 1 | 10 | 308 | 23 | |||
| 189236 | 1750 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 5 | 6010626.0557 | 2121671.8803 | 37.8063051940875 | -122.4075095136 | (37.8063051940875, -122.4075095136) | 3 | 1 | 10 | 308 | 23 | |||
| 177266 | 1749 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 18 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 5 | 6010575.9137 | 2121665.6126 | 37.8062851777933 | -122.407682597345 | (37.8062851777933, -122.407682597345) | 3 | 1 | 10 | 308 | 23 | |||
| 92138 | 1748 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 12 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 5 | 6010555.2301 | 2121661.2252 | 37.8062719732238 | -122.407753867308 | (37.8062719732238, -122.407753867308) | 3 | 1 | 10 | 308 | 23 | |||
| 45921 | 1747 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 13 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 5 | 6010526.3985 | 2121656.8377 | 37.8062583121866 | -122.407853334929 | (37.8062583121866, -122.407853334929) | 3 | 1 | 10 | 308 | 23 | |||
| 46323 | 1746 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 5 | 6010500.0739 | 2121656.211 | 37.8062551176462 | -122.407944391944 | (37.8062551176462, -122.407944391944) | 3 | 1 | 10 | 308 | 23 | |||
| 106118 | 1744 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 5 | 6010455.5729 | 2121649.3164 | 37.8062336952468 | -122.408097909479 | (37.8062336952468, -122.408097909479) | 3 | 1 | 10 | 308 | 23 | |||
| 170514 | 1742 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 5 | 6010362.8102 | 2121638.0345 | 37.8061975236724 | -122.408418135849 | (37.8061975236724, -122.408418135849) | 3 | 1 | 10 | 308 | 23 | |||
| 143263 | 1741 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 5 | 6010277.5688 | 2121623.6186 | 37.8061531673047 | -122.408712111835 | (37.8061531673047, -122.408712111835) | 3 | 1 | 10 | 308 | 23 | |||
| 116763 | 1740 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 5 | 6010239.3355 | 2121619.2312 | 37.8061389791251 | -122.408844115422 | (37.8061389791251, -122.408844115422) | 3 | 1 | 10 | 308 | 23 | |||
| 102121 | 1739 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 08/19/2006 12:00:00 AM | 3 | 6010211.1306 | 2121614.8438 | 37.8061253525476 | -122.408941413862 | (37.8061253525476, -122.408941413862) | 3 | 1 | 10 | 308 | 23 | |||
| 8495 | 1737 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 50X Bay St | 19 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | 3 | 1 | 10 | 308 | 23 | |||
| 58585 | 1736 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 50X Bay St | 18 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | 3 | 1 | 10 | 308 | 23 | |||
| 34756 | 1735 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 50X Bay St | 17 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | 3 | 1 | 10 | 308 | 23 | ||
| 42970 | 1734 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 50X Bay St | 16 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | 3 | 1 | 10 | 308 | 23 | |||
| 166971 | 1733 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 50X Bay St | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | 3 | 1 | 10 | 308 | 23 | ||
| 91535 | 1732 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 50X Bay St | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | 3 | 1 | 10 | 308 | 23 | ||
| 145403 | 1731 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 50X Bay St | 13 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | 3 | 1 | 10 | 308 | 23 | |||
| 167632 | 1730 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 50X Bay St | 12 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | 3 | 1 | 10 | 308 | 23 | |||
| 184611 | 1729 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 50X Bay St | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | 3 | 1 | 10 | 308 | 23 | |||
| 36407 | 1728 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 50X Bay St | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | 3 | 1 | 10 | 308 | 23 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );