Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 21599 | 21599 | 1993 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 162 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6007301.508909999 | 2098085.20202 | 37.7413551489316 | -122.417342154839 | (37.7413551489316, -122.417342154839) | |||
| 104816 | 104816 | 1994 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 164 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007305.0525987 | 2098100.7713839 | 37.7413980983192 | -122.41733100504601 | (37.7413980983192, -122.417331005046) | |||
| 9050 | 9050 | 1999 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 217 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | 3X3 | 6007148.9837828 | 2097704.1672577998 | 37.7403003295941 | -122.417842531543 | (37.7403003295941, -122.417842531543) | |||
| 20917 | 20917 | 2068 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 825 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001750.47291 | 2095477.80199 | 37.7338819553801 | -122.43634910053999 | (37.7338819553801, -122.43634910054) | |||
| 138810 | 138810 | 2081 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 907 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/1990 12:00:00 AM | 6 | 2X2 | 6001485.2451599995 | 2095489.86478 | 37.73390000314 | -122.437266934857 | (37.73390000314, -122.437266934857) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 17750 | 17750 | 2151 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1107 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001039.9865 | 2095675.11992 | 37.734383349014394 | -122.43881959664101 | (37.7343833490144, -122.438819596641) | |||
| 21639 | 21639 | 2248 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 24 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002179.97974 | 2095615.76928 | 37.7342851772073 | -122.434874030709 | (37.7342851772073, -122.434874030709) | |||
| 108777 | 108777 | 3128 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3200 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998952.52581 | 2114994.22768 | 37.7873098198001 | -122.447426688631 | (37.7873098198001, -122.447426688631) | |||
| 80518 | 80518 | 3129 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3200 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998952.52581 | 2114994.22768 | 37.7873098198001 | -122.447426688631 | (37.7873098198001, -122.447426688631) | |||
| 123034 | 123034 | 3130 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3200 California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998952.52581 | 2114994.22768 | 37.7873098198001 | -122.447426688631 | (37.7873098198001, -122.447426688631) | |||
| 20887 | 20887 | 4296 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4344 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001646.5169400005 | 2100317.5627900003 | 37.747164899748995 | -122.43705489117599 | (37.747164899749, -122.437054891176) | |||
| 18119 | 18119 | 4297 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4348 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001630.45884 | 2100316.0332 | 37.7471597870885 | -122.43711030921301 | (37.7471597870885, -122.437110309213) | |||
| 18611 | 18611 | 4312 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002294.35545 | 2095730.49773 | 37.73460668843771 | -122.434486797948 | (37.7346066884377, -122.434486797948) | |||
| 20733 | 20733 | 4319 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X Brompton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002197.2955 | 2095679.49968 | 37.7344611493668 | -122.434818720617 | (37.7344611493668, -122.434818720617) | |||
| 18960 | 18960 | 4321 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X Brompton Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002183.61558 | 2095631.29861 | 37.7343280236114 | -122.43486257064801 | (37.7343280236114, -122.434862570648) | |||
| 118026 | 118026 | 4326 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 55X Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002005.9917905 | 2095776.0727988 | 37.734715453728 | -122.435487025858 | (37.734715453728, -122.435487025858) | |||
| 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) | ||
| 79466 | 79466 | 4342 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 901X Chenery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001465.6431599995 | 2095917.8806599998 | 37.7350741214051 | -122.437365343013 | (37.7350741214051, -122.437365343013) | |||
| 106921 | 106921 | 4786 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 120X Cornwall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5995096.1846199995 | 2114258.40388 | 37.7850683220037 | -122.460715378785 | (37.7850683220037, -122.460715378785) | |||
| 9286 | 9286 | 4816 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 50X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 11x5 | 6005990.1672425 | 2097819.1039723 | 37.7405506369184 | -122.421857425384 | (37.7405506369184, -122.421857425384) | |||
| 20759 | 20759 | 4847 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 216 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6006763.29686 | 2097403.25303 | 37.7394523732277 | -122.41915474650801 | (37.7394523732277, -122.419154746508) | |||
| 17061 | 17061 | 5075 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2518X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002273.67466 | 2097186.93566 | 37.7386045571491 | -122.434662408564 | (37.7386045571491, -122.434662408564) | |||
| 19233 | 19233 | 5084 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2567 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1994 12:00:00 AM | 12 | 3X3 | 6002282.63151 | 2096922.4202 | 37.7378787673769 | -122.434612531259 | (37.7378787673769, -122.434612531259) | ||
| 19719 | 19719 | 5088 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2586 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6002230.0958 | 2096785.7567599998 | 37.737500538614896 | -122.43478440250401 | (37.7375005386149, -122.434784402504) | |||
| 21048 | 21048 | 5089 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2590 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6002229.15895 | 2096765.16695 | 37.737443950566 | -122.43478616966298 | (37.737443950566, -122.434786169663) | |||
| 18545 | 18545 | 5094 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2608 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6002249.53771 | 2096620.3889799998 | 37.737047580668296 | -122.434705361078 | (37.7370475806683, -122.434705361078) | |||
| 20226 | 20226 | 5117 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2720 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2002 12:00:00 AM | 8 | 3X3 | 6002348.769730001 | 2096171.20815 | 37.735819866687 | -122.43433016751499 | (37.735819866687, -122.434330167515) | ||
| 98904 | 98904 | 5289 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2070X O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 18 | 3X3 | 6001402.6275094 | 2113220.9735965 | 37.78258062415 | -122.43882275095 | (37.78258062415, -122.43882275095) | |||
| 87633 | 87633 | 5290 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2070X O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 18 | 3X3 | 6001402.6275094 | 2113220.9735965 | 37.78258062415 | -122.43882275095 | (37.78258062415, -122.43882275095) | |||
| 121872 | 121872 | 5291 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2070X O'Farrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 18 | 4X3 | 6001402.6275094 | 2113220.9735965 | 37.78258062415 | -122.43882275095 | (37.78258062415, -122.43882275095) | |||
| 9297 | 9297 | 5763 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 401 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6004052.45174 | 2108353.78487 | 37.7693669201086 | -122.429308319494 | (37.7693669201086, -122.429308319494) | |||
| 22017 | 22017 | 5765 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 412 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/1990 12:00:00 AM | 12 | 3X3 | 6003796.50672 | 2108397.52526 | 37.76947252735229 | -122.430196742212 | (37.7694725273523, -122.430196742212) | ||
| 21533 | 21533 | 5767 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 449 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3X3 | 6003822.198969999 | 2108336.65808 | 37.7693068560416 | -122.430103531057 | (37.7693068560416, -122.430103531057) | |||
| 18275 | 18275 | 5786 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 545 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003176.40068 | 2108310.41756 | 37.769198208965896 | -122.432335439751 | (37.7691982089659, -122.432335439751) | |||
| 22090 | 22090 | 5789 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 551 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003097.4127 | 2108300.15747 | 37.7691655581641 | -122.43260792171101 | (37.7691655581641, -122.432607921711) | |||
| 95541 | 95541 | 5793 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 599 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002829.9725125 | 2108286.1985016996 | 37.7691120600587 | -122.433531983849 | (37.7691120600587, -122.433531983849) | |||
| 75300 | 75300 | 6092 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2010 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | 3X3 | 6000754.46545 | 2112450.66419 | 37.7804286547609 | -122.441009826336 | (37.7804286547609, -122.441009826336) | |||
| 97945 | 97945 | 6294 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1729 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1992 12:00:00 AM | 12 | 3X3 | 6002611.577880001 | 2112977.51583 | 37.7819808563968 | -122.434622894692 | (37.7819808563968, -122.434622894692) | ||
| 141911 | 141911 | 6300 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1765X ELLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3X3 | 6002440.0 | 2112973.0 | 37.781958715246 | -122.43521615153799 | (37.781958715246, -122.435216151538) | |||
| 129332 | 129332 | 6331 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1895X Ellis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | |||
| 126713 | 126713 | 6334 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1895X Ellis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | |||
| 99039 | 99039 | 6344 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1935 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001502.57255 | 2112758.95459 | 37.7813177231138 | -122.438443872554 | (37.7813177231138, -122.438443872554) | |||
| 118148 | 118148 | 7672 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 290X LAKE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5994618.0 | 2114909.0 | 37.7868271588239 | -122.46241694027701 | (37.7868271588239, -122.462416940277) | |||
| 78188 | 78188 | 7673 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 290X LAKE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5994618.0 | 2114909.0 | 37.7868271588239 | -122.46241694027701 | (37.7868271588239, -122.462416940277) | |||
| 6053 | 6053 | 7809 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006235.14399 | 2112561.39045 | 37.7810433181208 | -122.422057428004 | (37.7810433181208, -122.422057428004) | |||
| 3447 | 3447 | 7810 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006241.41357 | 2112578.9156299997 | 37.781091791593205 | -122.422036983727 | (37.7810917915932, -122.422036983727) | |||
| 8650 | 8650 | 7811 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006219.73405 | 2112674.25147 | 37.7813523377843 | -122.422118759068 | (37.7813523377843, -122.422118759068) | |||
| 6377 | 6377 | 7813 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006213.15076 | 2112713.3724700003 | 37.7814593831787 | -122.422144314209 | (37.7814593831787, -122.422144314209) | |||
| 89424 | 89424 | 8145 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6002886.962169999 | 2111360.68278 | 37.7775570672136 | -122.43355460906601 | (37.7775570672136, -122.433554609066) | |||
| 93458 | 93458 | 8147 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002886.962169999 | 2111360.68278 | 37.7775570672136 | -122.43355460906601 | (37.7775570672136, -122.433554609066) | |||
| 90915 | 90915 | 8148 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002886.962169999 | 2111360.68278 | 37.7775570672136 | -122.43355460906601 | (37.7775570672136, -122.433554609066) | |||
| 108139 | 108139 | 8163 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1108 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6002345.91863 | 2111334.94694 | 37.7774556905463 | -122.435424415956 | (37.7774556905463, -122.435424415956) | |||
| 24663 | 24663 | 8164 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1108 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6002345.91863 | 2111334.94694 | 37.7774556905463 | -122.435424415956 | (37.7774556905463, -122.435424415956) | |||
| 141671 | 141671 | 8801 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 520X Arguello Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 5995641.75206 | 2112765.0561599997 | 37.780999362391896 | -122.458719750364 | (37.7809993623919, -122.458719750364) | |||
| 92957 | 92957 | 9322 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 109X Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 2X2 | 6001353.7110351 | 2098757.7986155 | 37.7428655085674 | -122.43795568375 | (37.7428655085674, -122.43795568375) | |||
| 9275 | 9275 | 9356 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 241 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 6000999.4900667 | 2098404.1035626 | 37.74187419547079 | -122.43915513344 | (37.7418741954708, -122.43915513344) | |||
| 17961 | 17961 | 9357 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 244 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6000993.28256 | 2098353.57528 | 37.7417351034945 | -122.43917297625099 | (37.7417351034945, -122.439172976251) | |||
| 21497 | 21497 | 9366 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 264 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6001152.801969999 | 2098197.5633099996 | 37.7413158071797 | -122.438610236294 | (37.7413158071797, -122.438610236294) | |||
| 4186 | 4186 | 9424 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/1994 12:00:00 AM | 12 | 3X3 | 6006118.832780001 | 2112436.92682 | 37.7806950106942 | -122.422450960554 | (37.7806950106942, -122.422450960554) | ||
| 9177 | 9177 | 10667 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1021 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002954.21433 | 2110590.33753 | 37.7754457061984 | -122.43326690297701 | (37.7754457061984, -122.433266902977) | |||
| 109059 | 109059 | 11648 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/28/2000 12:00:00 AM | 3 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
| 141005 | 141005 | 11653 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
| 93707 | 93707 | 11654 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
| 78605 | 78605 | 11658 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
| 86056 | 86056 | 11659 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 16135 | 16135 | 12122 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1996 12:00:00 AM | 3 | 3X3 | 6016530.391559999 | 2095003.08247 | 37.7334071897754 | -122.38521689463998 | (37.7334071897754, -122.38521689464) | ||
| 13861 | 13861 | 12127 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016490.26403 | 2095091.74303 | 37.733648414028295 | -122.385361804207 | (37.7336484140283, -122.385361804207) | |||
| 16140 | 16140 | 12129 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016454.923280001 | 2095170.51744 | 37.7338627575466 | -122.385489476485 | (37.7338627575466, -122.385489476485) | |||
| 14766 | 14766 | 12139 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1996 12:00:00 AM | 6 | 3X3 | 6016385.33586 | 2095408.8215700001 | 37.7345132425897 | -122.385746667286 | (37.7345132425897, -122.385746667286) | ||
| 15452 | 15452 | 12142 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1996 12:00:00 AM | 3 | 3X3 | 6016364.0707 | 2095472.0382700001 | 37.734685646232 | -122.385824593536 | (37.734685646232, -122.385824593536) | ||
| 15841 | 15841 | 12149 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016248.95724 | 2095649.3696400002 | 37.735166191751 | -122.38623494249399 | (37.735166191751, -122.386234942494) | |||
| 14800 | 14800 | 12153 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016182.90625 | 2095712.9210700002 | 37.7353370350581 | -122.386467736523 | (37.7353370350581, -122.386467736523) | |||
| 9127 | 9127 | 12154 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016226.76201 | 2095667.61701 | 37.735215066832104 | -122.386312951947 | (37.7352150668321, -122.386312951947) | |||
| 9472 | 9472 | 12156 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016192.73501 | 2095700.95101 | 37.7353047117642 | -122.386432920212 | (37.7353047117642, -122.386432920212) | |||
| 9353 | 9353 | 12157 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016176.76201 | 2095719.00601 | 37.73535340295211 | -122.386489403775 | (37.7353534029521, -122.386489403775) | |||
| 9314 | 9314 | 12158 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016158.70701 | 2095735.6730099998 | 37.735398167686206 | -122.38655298897699 | (37.7353981676862, -122.386552988977) | |||
| 79107 | 79107 | 12374 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6004618.47022 | 2113718.13203 | 37.784128129581 | -122.42773275116501 | (37.784128129581, -122.427732751165) | |||
| 124929 | 124929 | 12388 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1450 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | 6004617.476430001 | 2113882.98777 | 37.7845807261574 | -122.427747939391 | (37.7845807261574, -122.427747939391) | |||
| 143679 | 143679 | 12390 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1450 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6004617.476430001 | 2113882.98777 | 37.7845807261574 | -122.427747939391 | (37.7845807261574, -122.427747939391) | |||
| 95192 | 95192 | 12517 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 25 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3X3 | 5995369.6399300005 | 2114888.72449 | 37.786814741917205 | -122.459814989787 | (37.7868147419172, -122.459814989787) |
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");