trees
261 rows where qCaretaker_id = 8 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11053 | 116828 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 15 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
13714 | 116827 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 14 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
22667 | 116824 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 11 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
23878 | 116821 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 8 | Sidewalk: Curb side : Yard | Tree | PUC 8 | 14 | 6010478.7636 | 2121651.8235 | 37.806241877556 | -122.408017830638 | (37.806241877556, -122.408017830638) | 3 | 1 | 10 | 308 | 23 | ||||
35001 | 116817 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 4 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
38711 | 116976 | Undocumented 4 | Salix spp :: Willow 203 | 100x CARGO WAY | 7 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
49681 | 116977 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x CARGO WAY | 117 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
53972 | 116826 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 13 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
57984 | 116822 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 9 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
81034 | 116831 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 18 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
81049 | 116820 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 7 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
90664 | 116825 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 12 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 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 | |||
103044 | 116823 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 10 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
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 | |
126220 | 116830 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 17 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
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 | |
133362 | 116818 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 5 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
149148 | 116809 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 1 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
173000 | 116975 | Undocumented 4 | Salix spp :: Willow 203 | 100x CARGO WAY | 6 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
179845 | 116832 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 Midway St | 7 | Front Yard : Yard | Tree | PUC 8 | 6010125.275107 | 2121295.55695439 | 37.8052438606833 | -122.409215987298 | (37.8052438606833, -122.409215987298) | 3 | 1 | 10 | 308 | 23 | |||||
180453 | 116829 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 16 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
187851 | 116819 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 Bay St | 20 | Sidewalk: Curb side : Yard | Tree | PUC 8 | 11 | 6010427.9948 | 2121647.4361 | 37.8062269882557 | -122.408193215955 | (37.8062269882557, -122.408193215955) | 3 | 1 | 10 | 308 | 23 | ||||
191989 | 116816 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 3 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
192724 | 116815 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 2 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
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 | ||||
55364 | 11774 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 2x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
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 | ||
3325 | 11719 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
6276 | 11636 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 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 | ||
18185 | 11652 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 699X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
21093 | 11635 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
22831 | 11871 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
23382 | 11720 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
40076 | 11658 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 699X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
47105 | 11687 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 799X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
49919 | 11696 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 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 | ||
65090 | 11694 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 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 | ||
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 | ||
72539 | 11655 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 699X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 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 | ||
75317 | 11659 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 699X Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 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 | ||
83487 | 11823 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1299X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991432.1718154 | 2088660.0347764 | 37.7145703669544 | -122.471525618465 | (37.7145703669544, -122.471525618465) | 9 | 8 | 6 | 64 | 24 | |||
85341 | 11654 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 699X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
85615 | 11723 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 899X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
89514 | 11634 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 499X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
91152 | 11692 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
94438 | 11699 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Junipero Serra Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
99292 | 11656 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 699X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
100357 | 11657 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 699X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 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 | ||
114230 | 11633 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
117481 | 11872 | Permitted Site 7 | Juglans hindsii :: Walnut: Black (n.calif) 457 | 1499X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
117872 | 11693 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
119183 | 11700 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 799X Junipero Serra Blvd | 32 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
119413 | 11722 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 899X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
119872 | 11873 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
126974 | 11648 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 699X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/28/2000 12:00:00 AM | 3 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | ||
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 | ||
141266 | 11695 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
144238 | 11689 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
148376 | 11822 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1299X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Yard | Tree | PUC 8 | 10 | 3 | 5991432.1718154 | 2088660.0347764 | 37.7145703669544 | -122.471525618465 | (37.7145703669544, -122.471525618465) | 9 | 8 | 6 | 64 | 24 | |||
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 | ||
152984 | 11820 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1299X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991432.1718154 | 2088660.0347764 | 37.7145703669544 | -122.471525618465 | (37.7145703669544, -122.471525618465) | 9 | 8 | 6 | 64 | 24 | |||
153368 | 11649 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 699X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
166318 | 11721 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 899X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
166529 | 11718 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 899X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3 | 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 | ||
174279 | 11650 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 699X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
179933 | 11874 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
181483 | 11653 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 699X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
183178 | 11637 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 499X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
183477 | 11717 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 5 | 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 | ||
184861 | 11724 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 12 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
185799 | 11726 | Permitted Site 7 | Ulmus americana :: American Elm 74 | 899X Junipero Serra Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/15/1995 12:00:00 AM | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
186993 | 11824 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Yard | Tree | PUC 8 | 03/13/2013 12:00:00 AM | 2 | 3 | 5991432.1718154 | 2088660.0347764 | 37.7145703669544 | -122.471525618465 | (37.7145703669544, -122.471525618465) | 9 | 8 | 6 | 64 | 24 | ||
17272 | 11727 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/15/1995 12:00:00 AM | 12 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
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 | |||
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 | ||
27360 | 11818 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1201X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 5991184.5559808 | 2089595.7938425 | 37.7171254042551 | -122.472449649239 | (37.7171254042551, -122.472449649239) | 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 | ||
35922 | 11146 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
48230 | 11762 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | |||
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 | |||
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 | |||
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 | ||
87342 | 11143 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2553X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.12852 | 2121148.49105 | 37.804660646435 | -122.420255847653 | (37.804660646435, -122.420255847653) | 5 | 1 | 1 | 28858 | 32 | |||
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 | ||
102742 | 11150 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
108007 | 11876 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1501X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | 9 | 8 | 4 | 64 | 24 | |||
111891 | 11145 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
112297 | 11148 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
116132 | 11816 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1201X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 5991184.5559808 | 2089595.7938425 | 37.7171254042551 | -122.472449649239 | (37.7171254042551, -122.472449649239) | 9 | 8 | 6 | 64 | 24 | |||
118544 | 11877 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1501X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | 9 | 8 | 4 | 64 | 24 | |||
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 |
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) );