Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qAddress, qSiteInfo, qCareAssistant, DBH, PlotSize
PlantDate ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |
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) | |
9947 | 9947 | 11824 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | PUC 13 | 03/13/2013 12:00:00 AM | 2 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | ||
96683 | 96683 | 11823 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1299X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | |||
114303 | 114303 | 11822 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1299X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | PUC 13 | 10 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | |||
118852 | 118852 | 11820 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1299X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
79124 | 79124 | 11774 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 2x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
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) | ||
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) | |||
91193 | 91193 | 11791 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
92042 | 92042 | 11788 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
94360 | 94360 | 24461 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1199X Junipero Serra Blvd | 7 | 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) | ||
96556 | 96556 | 24460 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 6 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
102978 | 102978 | 11789 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
110250 | 110250 | 24414 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
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) | |||
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) | ||
121435 | 121435 | 11773 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
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) | ||
125704 | 125704 | 11772 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
127942 | 127942 | 24412 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
142712 | 142712 | 11790 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
145860 | 145860 | 24413 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 6 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
104595 | 104595 | 87713 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1199X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991170.4069529995 | 2089609.549246 | 37.717162354271395 | -122.47249955747499 | (37.7171623542714, -122.472499557475) | ||
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) | |||
86548 | 86548 | 24457 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 13 | 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) | ||
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) | ||
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) | |||
117787 | 117787 | 24405 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/28/2000 12:00:00 AM | 12 | 3X3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
123921 | 123921 | 24406 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/28/2000 12:00:00 AM | 6 | 3x3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
125742 | 125742 | 24458 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 6 | 3X3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
90644 | 90644 | 87708 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 7 | 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) | ||
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) | ||
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) | ||
98322 | 98322 | 87710 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 12 | 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) | ||
138768 | 138768 | 87709 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 8 | 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) | ||
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) | ||
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) | ||
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) | ||
118719 | 118719 | 87632 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 8 | 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) | ||
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) | ||
32415 | 32415 | 11719 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
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) | ||
83233 | 83233 | 28848 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
89108 | 89108 | 27799 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 23 | 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) | ||
90084 | 90084 | 24402 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/01/2000 12:00:00 AM | 6 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
92392 | 92392 | 24401 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 12 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
92648 | 92648 | 11723 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 899X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
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) | ||
108076 | 108076 | 11722 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 899X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
117588 | 117588 | 11721 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 899X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
118796 | 118796 | 11718 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 899X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
124190 | 124190 | 11727 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 22 | 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) | ||
127364 | 127364 | 11720 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
139141 | 139141 | 11725 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 899X Junipero Serra Blvd | 20 | 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) | ||
141711 | 141711 | 11726 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 899X Junipero Serra Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/15/1995 12:00:00 AM | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
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) | ||
144393 | 144393 | 11724 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 12 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
95006 | 95006 | 87704 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 899X Junipero Serra Blvd | 10 | 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) | ||
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) | ||
128386 | 128386 | 87705 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 899X Junipero Serra Blvd | 19 | 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) | ||
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) | |||
79297 | 79297 | 11696 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
80752 | 80752 | 24398 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/01/2000 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
84989 | 84989 | 24399 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/15/1995 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
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) | |||
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) | |||
88556 | 88556 | 11694 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
88676 | 88676 | 11697 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/21/1995 12:00:00 AM | 6 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
89131 | 89131 | 11698 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 799X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
91670 | 91670 | 11699 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
91904 | 91904 | 11692 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
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) | ||
105506 | 105506 | 11693 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
108860 | 108860 | 24456 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
109280 | 109280 | 11700 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 799X Junipero Serra Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
109450 | 109450 | 24400 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/15/1995 12:00:00 AM | 6 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
111277 | 111277 | 11695 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
112345 | 112345 | 26171 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/01/2000 12:00:00 AM | 30 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
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) | |||
113884 | 113884 | 11686 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
117628 | 117628 | 27826 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/08/2005 12:00:00 AM | 3 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
122590 | 122590 | 11691 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 9 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
144673 | 144673 | 26172 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
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) | ||
81957 | 81957 | 87701 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 8 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | |||
87918 | 87918 | 87702 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 799X Junipero Serra Blvd | 28 | 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) |
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");