Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96198 | 96198 | 13301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
| 138487 | 138487 | 13304 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
| 141679 | 141679 | 13302 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
| 142098 | 142098 | 13303 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
| 79797 | 79797 | 114240 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x FONT BLVD | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | |||||
| 105245 | 105245 | 114225 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x FONT BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 180603 | 180603 | 206418 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x Castenada Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 5993828.80673 | 2100251.01259 | 37.7465347043225 | -122.464082870453 | (37.7465347043225, -122.464082870453) | |||
| 111688 | 111688 | 111064 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x CAPP ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007219.0 | 2106804.0 | 37.7652903353746 | -122.418245454749 | (37.7652903353746, -122.418245454749) | |||
| 79227 | 79227 | 106170 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 99X THOR AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6002346.0 | 2095994.0 | 37.7353331366469 | -122.434327078202 | (37.7353331366469, -122.434327078202) | |||
| 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) | |||
| 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) | ||
| 100469 | 100469 | 110542 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 996 SOUTH VAN NESS AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6007549.0 | 2103894.0 | 37.757318718735704 | -122.41689786927 | (37.7573187187357, -122.41689786927) | |||||
| 184458 | 184458 | 212074 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 99 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 6ft | 5994256.6309 | 2097391.5669400003 | 37.738708030453 | -122.462396147864 | (37.738708030453, -122.462396147864) | |||
| 76981 | 76981 | 248711 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 99 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007008.13109 | 2098978.7996400003 | 37.7437922577052 | -122.418419901463 | (37.7437922577052, -122.418419901463) | |||
| 113507 | 113507 | 111284 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 98X THOR AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 4.5 x9 | 6002346.0 | 2095994.0 | 37.7353331366469 | -122.434327078202 | (37.7353331366469, -122.434327078202) | |||
| 111830 | 111830 | 19170 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 98 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003469.0377609 | 2107737.5290241 | 37.7676417853534 | -122.431282325215 | (37.7676417853534, -122.431282325215) | |||
| 143619 | 143619 | 78 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 97X Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002876.5924018 | 2107716.5314312 | 37.7675505386543 | -122.433330016252 | (37.7675505386543, -122.433330016252) | |||
| 37133 | 37133 | 212073 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 97 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 6ft | 5994261.112380001 | 2097463.04726 | 37.7389045557057 | -122.46238583625 | (37.7389045557057, -122.46238583625) | |||
| 57730 | 57730 | 248676 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 97 Hermann St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6004877.40051 | 2108844.08516 | 37.7707598349224 | -122.426489774494 | (37.7707598349224, -122.426489774494) | |||
| 60611 | 60611 | 248672 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 97 Hermann St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004845.3119 | 2108840.5249400004 | 37.770748245377604 | -122.426600516098 | (37.7707482453776, -122.426600516098) | |||
| 62358 | 62358 | 248675 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 97 Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6004907.9602 | 2108848.8376700003 | 37.7707746116773 | -122.42638440632601 | (37.7707746116773, -122.426384406326) | |||
| 114541 | 114541 | 16568 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 95X Nido Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/2000 12:00:00 AM | 3 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | ||
| 144672 | 144672 | 16569 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 95X Nido Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/2000 12:00:00 AM | 3 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | ||
| 69385 | 69385 | 175996 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 959 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 6ft | 6001537.92258 | 2088610.3375099998 | 37.715013373939705 | -122.436592559601 | (37.7150133739397, -122.436592559601) | |||
| 162199 | 162199 | 248753 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 955 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6007616.90844 | 2104099.62454 | 37.7578871360994 | -122.41667758100901 | (37.7578871360994, -122.416677581009) | |||
| 108035 | 108035 | 107299 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 955 SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 7x6 | 6007636.8 | 2104105.7 | 37.757904936655706 | -122.416609217837 | (37.7579049366557, -122.416609217837) | |||
| 88986 | 88986 | 103455 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 953 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x9 | 6001548.0 | 2088631.0 | 37.7150706812167 | -122.436559205883 | (37.7150706812167, -122.436559205883) | ||||
| 42600 | 42600 | 212258 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 951 Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5991271.42052 | 2090740.59287 | 37.720273768507 | -122.4722328056 | (37.720273768507, -122.4722328056) | |||
| 45708 | 45708 | 212263 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 951 Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5991290.4593400005 | 2091078.6284 | 37.7212030325641 | -122.47219162296699 | (37.7212030325641, -122.472191622967) | |||
| 57206 | 57206 | 212260 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 951 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991277.37814 | 2090844.74627 | 37.7205600928662 | -122.472219800499 | (37.7205600928662, -122.472219800499) | |||
| 58636 | 58636 | 212257 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 951 Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | Width 4ft | 5991265.704390001 | 2090677.6464200001 | 37.7201006022469 | -122.472247978075 | (37.7201006022469, -122.472247978075) | |||
| 61766 | 61766 | 212261 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 951 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991287.20633 | 2090983.7854 | 37.7209424288218 | -122.472195957673 | (37.7209424288218, -122.472195957673) | |||
| 151220 | 151220 | 212262 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 951 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5991291.08137 | 2091048.64317 | 37.7211207365178 | -122.472187288206 | (37.7211207365178, -122.472187288206) | |||
| 162603 | 162603 | 212259 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 951 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991274.769669999 | 2090780.4857599998 | 37.720383498380706 | -122.472224135259 | (37.7203834983807, -122.472224135259) | |||
| 173983 | 173983 | 212264 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 951 Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991294.251 | 2091109.76949 | 37.7212887577439 | -122.472180785219 | (37.7212887577439, -122.472180785219) | |||
| 187653 | 187653 | 212256 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 951 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5991256.60801 | 2090543.58608 | 37.7197319791141 | -122.472269653524 | (37.7197319791141, -122.472269653524) | |||
| 18870 | 18870 | 16690 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991053.49575 | 2103158.03284 | 37.7543562808184 | -122.473891546652 | (37.7543562808184, -122.473891546652) | ||
| 22280 | 22280 | 16692 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Noriega St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/25/2016 08:08:00 AM | 3 | 8 | 5990985.786309999 | 2103156.72144 | 37.7543487579916 | -122.474125605135 | (37.7543487579916, -122.474125605135) | ||
| 100609 | 100609 | 122330 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996124.0 | 2112291.0 | 37.779725435748205 | -122.45701712633999 | (37.7797254357482, -122.45701712634) | ||||
| 143038 | 143038 | 122331 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996124.0 | 2112291.0 | 37.779725435748205 | -122.45701712633999 | (37.7797254357482, -122.45701712634) | ||||
| 180222 | 180222 | 124152 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 950 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5996091.59731 | 2112260.8127 | 37.779640688597105 | -122.45712703643 | (37.7796406885971, -122.45712703643) | |||
| 186942 | 186942 | 124151 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 950 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5996109.01256 | 2112263.6321400004 | 37.7796494301654 | -122.457066993925 | (37.7796494301654, -122.457066993925) | |||
| 70064 | 70064 | 212058 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 95 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 6ft | 5993986.52339 | 2097235.52478 | 37.7382640198529 | -122.463318724595 | (37.7382640198529, -122.463318724595) | |||
| 9450 | 9450 | 19167 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 95 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003517.6175946 | 2107764.5447227 | 37.767718716857 | -122.43111622226601 | (37.767718716857, -122.431116222266) | |||
| 65119 | 65119 | 222938 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 95 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003520.45561 | 2107781.71115 | 37.767766012513704 | -122.43110763132 | (37.7677660125137, -122.43110763132) | |||
| 66005 | 66005 | 248674 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 95 Hermann St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005037.30148 | 2108867.21091 | 37.7708323706535 | -122.42593832010901 | (37.7708323706535, -122.425938320109) | |||
| 170389 | 170389 | 248673 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 95 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6005207.144119999 | 2108888.77574 | 37.7709011795763 | -122.42535236503299 | (37.7709011795763, -122.425352365033) | |||
| 124725 | 124725 | 122498 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 949 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x6 | 5999128.0 | 2113764.0 | 37.7839419619379 | -122.446731035836 | (37.7839419619379, -122.446731035836) | |||
| 21145 | 21145 | 2092 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 943 Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6001450.63808 | 2095555.96116 | 37.7340795211485 | -122.437391313181 | (37.7340795211485, -122.437391313181) | |||
| 22111 | 22111 | 2089 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 943 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001413.27766 | 2095566.23245 | 37.7341055996942 | -122.43752121485399 | (37.7341055996942, -122.437521214854) | |||
| 20517 | 20517 | 5546 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 941 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/1991 12:00:00 AM | 20 | 3X3 | 6005114.255059999 | 2102860.25848 | 37.754343052711896 | -122.425244623562 | (37.7543430527119, -122.425244623562) | ||
| 94532 | 94532 | 12647 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 937 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4PL | 5992498.72996 | 2114784.19766 | 37.786362220871894 | -122.4697399651 | (37.7863622208719, -122.4697399651) | |||
| 32876 | 32876 | 212231 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 931 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6001483.11723 | 2095547.23015 | 37.7340573942257 | -122.437278397885 | (37.7340573942257, -122.437278397885) | |||
| 118613 | 118613 | 2086 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 931 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1992 12:00:00 AM | 12 | 2X2 | 6001457.30881 | 2095546.90958 | 37.734055046836204 | -122.437367602498 | (37.7340550468362, -122.437367602498) | ||
| 122405 | 122405 | 2087 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 931 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6001485.2451599995 | 2095489.86478 | 37.73390000314 | -122.437266934857 | (37.73390000314, -122.437266934857) | |||
| 156316 | 156316 | 212230 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 931 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 2ft | 6001470.48299 | 2095551.23311 | 37.734067667195504 | -122.437322364832 | (37.7340676671955, -122.437322364832) | |||
| 95204 | 95204 | 19166 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 93 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003516.962182701 | 2107776.3737946 | 37.7677511594735 | -122.431119333657 | (37.7677511594735, -122.431119333657) | |||
| 41238 | 41238 | 212072 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 93 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5994265.100769999 | 2097482.56478 | 37.73895837563 | -122.462373461579 | (37.73895837563, -122.462373461579) | |||
| 132878 | 132878 | 246776 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 926 Esmeralda Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6009551.14862 | 2098756.05448 | 37.743323477111794 | -122.40961099258001 | (37.7433234771118, -122.40961099258) | |||
| 18008 | 18008 | 4349 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 925 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001343.36929 | 2095994.0746099998 | 37.735276380288795 | -122.437793542132 | (37.7352763802888, -122.437793542132) | |||
| 20179 | 20179 | 4352 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 925 Chenery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001454.126019999 | 2095943.2329900002 | 37.7351430782743 | -122.437406976652 | (37.7351430782743, -122.437406976652) | |||
| 23323 | 23323 | 4351 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 925 Chenery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1992 12:00:00 AM | 28 | 3X3 | 6001420.13833 | 2095958.4548400003 | 37.735182941645 | -122.437525573868 | (37.735182941645, -122.437525573868) | ||
| 45208 | 45208 | 212170 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 925 Chenery St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 3ft | 6001544.08486 | 2095904.3177099999 | 37.735041339786 | -122.437093171723 | (37.735041339786, -122.437093171723) | |||
| 52326 | 52326 | 212171 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 925 Chenery St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001568.1946 | 2095894.69722 | 37.735016294564204 | -122.43700912736799 | (37.7350162945642, -122.437009127368) | |||
| 91562 | 91562 | 4350 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 925 Chenery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6001342.216569999 | 2095863.76561 | 37.7349185164407 | -122.437788197517 | (37.7349185164407, -122.437788197517) | |||
| 117926 | 117926 | 4353 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 925 Chenery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001342.216569999 | 2095863.76561 | 37.7349185164407 | -122.437788197517 | (37.7349185164407, -122.437788197517) | |||
| 17705 | 17705 | 4348 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 924 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001433.25109 | 2095991.10142 | 37.735273327102796 | -122.43748257546999 | (37.7352733271028, -122.43748257547) | |||
| 18857 | 18857 | 2085 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 921 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001545.78168 | 2095530.67878 | 37.734015510104896 | -122.437060563206 | (37.7340155101049, -122.437060563206) | |||
| 1274 | 1274 | 212204 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | Width 3ft | 6001555.51112 | 2095599.51711 | 37.7342050772889 | -122.437031852331 | (37.7342050772889, -122.437031852331) | |||
| 1277 | 1277 | 212203 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6001598.82808 | 2095593.8833700002 | 37.7341920703926 | -122.436881688932 | (37.7341920703926, -122.436881688932) | ||||
| 1303 | 1303 | 212206 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 3ft | 6001486.61652 | 2095618.44955 | 37.734253145164 | -122.43727139756399 | (37.734253145164, -122.437271397564) | |||
| 1307 | 1307 | 212207 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 11 | 6001467.5944 | 2095628.72955 | 37.7342802902926 | -122.43733789885 | (37.7342802902926, -122.43733789885) | ||||
| 43758 | 43758 | 212210 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6001335.34031 | 2095664.21523 | 37.734370206320705 | -122.437797683519 | (37.7343702063207, -122.437797683519) | ||||
| 52559 | 52559 | 212209 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001437.10561 | 2095636.3706200002 | 37.7342995375914 | -122.437443855175 | (37.7342995375914, -122.437443855175) | ||||
| 132005 | 132005 | 212213 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001230.14104 | 2095687.81352 | 37.734429019275105 | -122.438163080788 | (37.7344290192751, -122.438163080788) | |||
| 164827 | 164827 | 212212 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6001287.33853 | 2095677.45112 | 37.7344038193788 | -122.43796458870399 | (37.7344038193788, -122.437964588704) | ||||
| 172814 | 172814 | 212211 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6001309.95525 | 2095671.6217 | 37.734389099275106 | -122.43788597806999 | (37.7343890992751, -122.43788597807) | ||||
| 175331 | 175331 | 212208 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001453.89018 | 2095626.12972 | 37.734272372676294 | -122.43738509254601 | (37.7342723726763, -122.437385092546) | |||
| 179714 | 179714 | 212205 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6001520.45314 | 2095614.45375 | 37.7342440970832 | -122.43715412776301 | (37.7342440970832, -122.437154127763) | ||||
| 186334 | 186334 | 212214 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6001218.32955 | 2095696.7085799999 | 37.734452771280395 | -122.438204553905 | (37.7344527712804, -122.438204553905) | ||||
| 24873 | 24873 | 175997 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 918 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6003927.76143 | 2090183.89548 | 37.719469539881004 | -122.428444351129 | (37.719469539881, -122.428444351129) | |||
| 104551 | 104551 | 17603 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 918 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6003916.62917 | 2090182.06037 | 37.7194638711075 | -122.428482700528 | (37.7194638711075, -122.428482700528) | |||
| 14499 | 14499 | 35359 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 917 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 28 | 6x6 | Permit Number 38821 | 6011905.65469 | 2104108.25722 | 37.758151117709104 | -122.40184581615 | (37.7581511177091, -122.40184581615) |
| 115811 | 115811 | 248787 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 915 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 4ft | 6000502.53313 | 2101961.51161 | 37.7516136966213 | -122.44112861229401 | (37.7516136966213, -122.441128612294) | |||
| 77978 | 77978 | 50685 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 915 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47258 | 5999168.89515798 | 2107036.01925898 | 37.765470983210896 | -122.44610545370399 | (37.7654709832109, -122.446105453704) | ||||
| 87249 | 87249 | 29605 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 910X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991188.7321263 | 2091104.0152466998 | 37.7212668508959 | -122.472545111236 | (37.7212668508959, -122.472545111236) | ||
| 112917 | 112917 | 29604 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 910X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991188.7321263 | 2091104.0152466998 | 37.7212668508959 | -122.472545111236 | (37.7212668508959, -122.472545111236) | ||
| 127749 | 127749 | 29603 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 910X Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991188.7321263 | 2091104.0152466998 | 37.7212668508959 | -122.472545111236 | (37.7212668508959, -122.472545111236) | ||
| 68890 | 68890 | 222952 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 910 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002449.75588 | 2102930.69662 | 37.7543855699625 | -122.434464164711 | (37.7543855699625, -122.434464164711) | |||
| 177468 | 177468 | 222953 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 910 Castro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002449.557019999 | 2102903.83172 | 37.7543117940721 | -122.43446293172701 | (37.7543117940721, -122.434462931727) | |||
| 18048 | 18048 | 19161 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 91 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 6003505.743559999 | 2107783.3498 | 37.7677696781622 | -122.431158635477 | (37.7677696781622, -122.431158635477) | |||
| 116042 | 116042 | 4338 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 907 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2016 12:00:00 AM | 3 | 3x3 | 6001440.66779 | 2095942.1493400002 | 37.735139337695706 | -122.43745342895201 | (37.7351393376957, -122.437453428952) | ||
| 44203 | 44203 | 212232 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 907 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001561.310880001 | 2095526.9035 | 37.7340060267426 | -122.43700660386999 | (37.7340060267426, -122.43700660387) | |||
| 53896 | 53896 | 212233 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 907 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001573.662219999 | 2095523.19402 | 37.7339965434037 | -122.43696363607799 | (37.7339965434037, -122.436963636078) | |||
| 64923 | 64923 | 212234 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 907 Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001590.05805 | 2095519.40115 | 37.73398706095521 | -122.436906679309 | (37.7339870609552, -122.436906679309) | |||
| 83071 | 83071 | 2083 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 907 Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001485.2451599995 | 2095489.86478 | 37.73390000314 | -122.437266934857 | (37.73390000314, -122.437266934857) | |||
| 104447 | 104447 | 2082 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 907 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001485.2451599995 | 2095489.86478 | 37.73390000314 | -122.437266934857 | (37.73390000314, -122.437266934857) |
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");