Data source: data.sfgov.org
This data as json, CSV (advanced)
PlantType ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 85205 | 85205 | 104946 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 532 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 85324 | 85324 | 33493 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 7 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37621 | 6007079.73577518 | 2099722.81418474 | 37.7458391853073 | -122.418225047767 | (37.7458391853073, -122.418225047767) | ||
| 85676 | 85676 | 117632 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3406 CLAY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998421.0 | 2115586.0 | 37.7889042820755 | -122.449308299768 | (37.7889042820755, -122.449308299768) | ||||
| 86305 | 86305 | 103594 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 10X Hermann St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.42595813798201 | (37.7707643495235, -122.425958137982) | ||||
| 86358 | 86358 | 122728 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2199x Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008252.0 | 2105724.0 | 37.7623829973195 | -122.414596107789 | (37.7623829973195, -122.414596107789) | ||||
| 86881 | 86881 | 109021 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1800x FOLSOM ST | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.41571376452801 | (37.7678993280557, -122.415713764528) | ||||
| 86917 | 86917 | 104944 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 532 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 87006 | 87006 | 102864 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2750X Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x7.5 | 6000834.2 | 2116922.3 | 37.792711153164 | -122.44105488676901 | (37.792711153164, -122.441054886769) | ||||
| 87404 | 87404 | 99494 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Plymouth Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 5995903.0 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | |||||
| 87458 | 87458 | 99996 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44594 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | ||||
| 87578 | 87578 | 51565 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3860 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | Permit Number 47863 | 6004041.27502949 | 2102496.18556684 | 37.753282718477294 | -122.428929306917 | (37.7532827184773, -122.428929306917) | |||
| 87595 | 87595 | 114791 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 100x GILLETTE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013060.0 | 2086881.0 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | ||||
| 87953 | 87953 | 105869 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 3555 Cesar Chavez St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | |||||
| 88187 | 88187 | 121221 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1639 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 5998709.0 | 2108958.0 | 37.770721981796896 | -122.4478345011 | (37.7707219817969, -122.4478345011) | ||||
| 88221 | 88221 | 46423 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 179 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1969 12:00:00 AM | Permit Number 44645 | 5999395.58867085 | 2107159.64271916 | 37.765823365237296 | -122.445330264611 | (37.7658233652373, -122.445330264611) | |||
| 88606 | 88606 | 113723 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 282X MARIETTA DR | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5x30 | 5999031.0 | 2097664.0 | 37.739729839693496 | -122.445908288102 | (37.7397298396935, -122.445908288102) | ||||
| 88791 | 88791 | 120126 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 620 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986678.0 | 2115081.0 | 37.786839000237705 | -122.489899771602 | (37.7868390002377, -122.489899771602) | ||||
| 88948 | 88948 | 104951 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 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) | ||||
| 89057 | 89057 | 33184 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 585 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37394 | 5994051.93950389 | 2099322.38418157 | 37.743997782291395 | -122.46324393518499 | (37.7439977822914, -122.463243935185) | ||
| 89125 | 89125 | 44162 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 853 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | Permit Number 43636 | 6002495.49530521 | 2109506.13705466 | 37.772442727355205 | -122.43477616990101 | (37.7724427273552, -122.434776169901) | ||
| 89145 | 89145 | 50979 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 201 Richardson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2004 12:00:00 AM | 3x3 | Permit Number 47465 | 5999116.7 | 2119758.3 | 37.8004000774175 | -122.447201682136 | (37.8004000774175, -122.447201682136) | ||
| 89444 | 89444 | 120946 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3224 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6007386.0 | 2102705.0 | 37.7540448270925 | -122.417377329228 | (37.7540448270925, -122.417377329228) | ||||
| 89535 | 89535 | 112306 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1254 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008684.0 | 2117318.0 | 37.794241627369104 | -122.41392216986799 | (37.7942416273691, -122.413922169868) | ||||
| 89582 | 89582 | 99611 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Entrada Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992743.0 | 2092489.0 | 37.7251595224946 | -122.46727314778099 | (37.7251595224946, -122.467273147781) | |||||
| 89684 | 89684 | 60589 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 538 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | Permit Number 20207 | 6000640.47849283 | 2110797.5063283 | 37.7758830107493 | -122.441285509617 | (37.7758830107493, -122.441285509617) | ||
| 89809 | 89809 | 99092 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2801@Broderick Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000146.4 | 2117058.8 | 37.7930467467367 | -122.44344450483601 | (37.7930467467367, -122.443444504836) | ||||
| 89864 | 89864 | 106457 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1x CHESTNUT ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011546.0 | 2121132.0 | 37.8048742648975 | -122.40428784546499 | (37.8048742648975, -122.404287845465) | |||||
| 89897 | 89897 | 100020 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 90001 | 90001 | 100009 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Washington St Montgomery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 90092 | 90092 | 93735 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 201@ Page Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 2 on Page St. | 5999812.1 | 2109210.9 | 37.771479369328205 | -122.44403704657 | (37.7714793693282, -122.44403704657) | ||||
| 90173 | 90173 | 95961 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 5990756.89162 | 2112756.21837 | 37.780693122390204 | -122.47561808245399 | (37.7806931223902, -122.475618082454) | ||||
| 90186 | 90186 | 121100 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001372.84758587 | 2109038.85294203 | 37.7710958809442 | -122.438626020879 | (37.7710958809442, -122.438626020879) | ||||
| 90308 | 90308 | 98550 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 290X Brighton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5.5x5.5 | 5996260.0 | 2091802.8 | 37.723477781170295 | -122.45506574958999 | (37.7234777811703, -122.45506574959) | ||||
| 90415 | 90415 | 104958 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 759 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 90419 | 90419 | 114701 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 645 STOCKTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010496.0 | 2116407.0 | 37.791841839530704 | -122.407588155464 | (37.7918418395307, -122.407588155464) | ||||
| 90639 | 90639 | 117269 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 399X SANTA CLARA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x10 | 5993324.0 | 2095440.0 | 37.7332957649176 | -122.46547898513701 | (37.7332957649176, -122.465478985137) | ||||
| 90700 | 90700 | 109270 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 875x CHENERY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6001242.0 | 2095902.0 | 37.7350178001347 | -122.438137418666 | (37.7350178001347, -122.438137418666) | ||||
| 90706 | 90706 | 114172 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1x SHRADER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997234.0 | 2110523.0 | 37.774934649960606 | -122.453049512511 | (37.7749346499606, -122.453049512511) | ||||
| 90746 | 90746 | 121116 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 90853 | 90853 | 58013 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3531 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1977 12:00:00 AM | 10x5 | Permit Number 16980 | 6005344.55719622 | 2106027.69514764 | 37.76305309818179 | -122.424673487617 | (37.7630530981818, -122.424673487617) | ||
| 90873 | 90873 | 102411 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 55X Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000310.8 | 2109142.0 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | |||||
| 91050 | 91050 | 97402 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 Stanford Heights Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5997807.0 | 2095590.8 | 37.7339673631019 | -122.449990957178 | (37.7339673631019, -122.449990957178) | |||||
| 91120 | 91120 | 53212 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 132 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2006 12:00:00 AM | Permit Number 49185 | 6004089.5020644 | 2108196.64307491 | 37.7689375443291 | -122.42916895785 | (37.7689375443291, -122.42916895785) | |||
| 91219 | 91219 | 33466 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 60 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37619 | 6006826.41498367 | 2099370.6210257 | 37.7448578799465 | -122.41907602046601 | (37.7448578799465, -122.419076020466) | ||
| 92060 | 92060 | 87052 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 511 Euclid Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 50168 | 5996764.3 | 2113789.0 | 37.783875296894294 | -122.45491032952499 | (37.7838752968943, -122.454910329525) | |||
| 92184 | 92184 | 94438 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 598 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998670.0 | 2105688.0 | 37.7617411583254 | -122.447733959945 | (37.7617411583254, -122.447733959945) | ||||
| 92464 | 92464 | 113184 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 100x HOLLADAY AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010899.0 | 2100465.0 | 37.7480913062991 | -122.405070752301 | (37.7480913062991, -122.405070752301) | ||||
| 92591 | 92591 | 100000 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Washington St Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 92625 | 92625 | 105890 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999444.5 | 2109060.1 | 37.771044333973705 | -122.445297745357 | (37.7710443339737, -122.445297745357) | |||||
| 92698 | 92698 | 122725 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2199x Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008252.0 | 2105724.0 | 37.7623829973195 | -122.414596107789 | (37.7623829973195, -122.414596107789) | ||||
| 92719 | 92719 | 99993 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44594 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | ||||
| 92857 | 92857 | 53058 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 235@ FOLSOM Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2006 12:00:00 AM | Permit Number 49035 | 6014758.5845738 | 2115729.7936401 | 37.790220067206704 | -122.392792095849 | (37.7902200672067, -122.392792095849) | |||
| 93074 | 93074 | 109022 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1800x FOLSOM ST | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.41571376452801 | (37.7678993280557, -122.415713764528) | ||||
| 93348 | 93348 | 38998 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2180 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1999 12:00:00 AM | Permit Number 40764 | 6008727.07607359 | 2105746.22742921 | 37.7624707078907 | -122.412954561883 | (37.7624707078907, -122.412954561883) | ||
| 93475 | 93475 | 110365 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1899x MARIPOSA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011823.0 | 2106021.0 | 37.7633984709679 | -122.40226615501801 | (37.7633984709679, -122.402266155018) | ||||
| 94083 | 94083 | 98322 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1899X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001966.9 | 2114999.4 | 37.7874958161075 | -122.4369979772 | (37.7874958161075, -122.4369979772) | ||||
| 94189 | 94189 | 47042 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 50 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | 6x9 | Permit Number 45032 | 6004340.5553933 | 2108752.14114491 | 37.7704770161634 | -122.428340177957 | (37.7704770161634, -122.428340177957) | |
| 94325 | 94325 | 52113 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 501 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | 4x4 | Permit Number 48304 | 6005450.41519372 | 2110958.1148217 | 37.7765968250138 | -122.42465811266199 | (37.7765968250138, -122.424658112662) | |
| 94404 | 94404 | 67891 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 737 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1993 12:00:00 AM | Permit Number 31591 | 5999915.87653863 | 2107957.83758922 | 37.768044694701096 | -122.443588048997 | (37.7680446947011, -122.443588048997) | |||
| 94725 | 94725 | 94441 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 598 Belvedere St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998670.0 | 2105688.0 | 37.7617411583254 | -122.447733959945 | (37.7617411583254, -122.447733959945) | ||||
| 94825 | 94825 | 104959 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 759 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 94838 | 94838 | 109881 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1520 PAGE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.44624140323401 | (37.7711622584795, -122.446241403234) | ||||
| 95095 | 95095 | 103597 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 10X Hermann St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.42595813798201 | (37.7707643495235, -122.425958137982) | ||||
| 95177 | 95177 | 112307 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1254 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 3x3 | 6008684.0 | 2117318.0 | 37.794241627369104 | -122.41392216986799 | (37.7942416273691, -122.413922169868) | |||
| 95291 | 95291 | 101437 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 31X College Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004315.3 | 2095877.6 | 37.7351251110849 | -122.427510187339 | (37.7351251110849, -122.427510187339) | |||||
| 95388 | 95388 | 33683 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37762 | 6005419.42693285 | 2111179.83479418 | 37.7772038638652 | -122.42478108729999 | (37.7772038638652, -122.4247810873) | |||
| 95546 | 95546 | 104524 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 43X BONVIEW ST | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | |||||
| 95555 | 95555 | 104945 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 532 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 95599 | 95599 | 33528 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 183 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37638 | 6007285.94975907 | 2097957.3067179 | 37.7410031014535 | -122.417386891564 | (37.7410031014535, -122.417386891564) | ||
| 95698 | 95698 | 112876 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x FRANCONIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010100.0 | 2099291.0 | 37.744823060949294 | -122.407750909418 | (37.7448230609493, -122.407750909418) | ||||
| 95868 | 95868 | 50448 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 303on BOCANA Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47095 | 6006949.39342482 | 2097361.11055858 | 37.739347137768604 | -122.418508317181 | (37.7393471377686, -122.418508317181) | |||
| 95902 | 95902 | 96835 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 6001 Geary Blvd | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5988352.4 | 2112527.1 | 37.779924341439 | -122.483919468894 | (37.779924341439, -122.483919468894) | |||||
| 95921 | 95921 | 116835 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 95969 | 95969 | 121114 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Stanyan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.45438257610901 | (37.7738204478349, -122.454382576109) | |||
| 96107 | 96107 | 113492 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2850 LAKE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986565.0 | 2114493.0 | 37.7852179229774 | -122.49024745024299 | (37.7852179229774, -122.490247450243) | ||||
| 96275 | 96275 | 109023 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1800x FOLSOM ST | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.41571376452801 | (37.7678993280557, -122.415713764528) | ||||
| 96522 | 96522 | 108113 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 786 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x7 | 5998636.0 | 2107697.0 | 37.76725542331079 | -122.447996203185 | (37.7672554233108, -122.447996203185) | ||||
| 96580 | 96580 | 43346 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 43101 | 5987278.98724374 | 2109843.31804433 | 37.772492884784896 | -122.487435636536 | (37.7724928847849, -122.487435636536) | |||
| 97178 | 97178 | 102863 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2750X Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x7 | 6000834.2 | 2116922.3 | 37.792711153164 | -122.44105488676901 | (37.792711153164, -122.441054886769) | ||||
| 97374 | 97374 | 115900 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X CHURCH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6004447.0 | 2103700.0 | 37.75661106685771 | -122.42761198632499 | (37.7566110668577, -122.427611986325) | ||||
| 97408 | 97408 | 46076 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3800 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2005 12:00:00 AM | Permit Number 47852 | 5996586.74903344 | 2115641.8686237 | 37.788952592538706 | -122.455658560713 | (37.7889525925387, -122.455658560713) | |||
| 97491 | 97491 | 112305 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1254 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 3x3 | 6008684.0 | 2117318.0 | 37.794241627369104 | -122.41392216986799 | (37.7942416273691, -122.413922169868) | |||
| 97535 | 97535 | 33818 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 746 Myra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37832 | 5997388.75056927 | 2098060.66039763 | 37.7407250625957 | -122.45161506422501 | (37.7407250625957, -122.451615064225) | |||
| 98128 | 98128 | 50878 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2506 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47388 | 6002262.04828144 | 2097251.96755917 | 37.7387824596371 | -122.43470725599501 | (37.7387824596371, -122.434707255995) | ||||
| 98229 | 98229 | 62433 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4392 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 770962 | 6000030.87492783 | 2105785.85783865 | 37.762087537224396 | -122.44303428204901 | (37.7620875372244, -122.443034282049) | ||
| 98374 | 98374 | 50312 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1055 Ellis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.783428536862395 | -122.42353751818999 | (37.7834285368624, -122.42353751819) | |||
| 98716 | 98716 | 121098 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001372.84758587 | 2109038.85294203 | 37.7710958809442 | -122.438626020879 | (37.7710958809442, -122.438626020879) | ||||
| 98729 | 98729 | 111233 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2601X 15TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991704.0 | 2097685.0 | 37.73936640081129 | -122.471243228199 | (37.7393664008113, -122.471243228199) | ||||
| 98743 | 98743 | 50635 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2900 Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.722057508368394 | -122.39326197707399 | (37.7220575083684, -122.393261977074) | ||
| 98987 | 98987 | 104915 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 99120 | 99120 | 50969 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3901 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 47462 | 6002458.87676393 | 2102943.00430693 | 37.7544198816731 | -122.43443350231001 | (37.7544198816731, -122.43443350231) | |||
| 99199 | 99199 | 50657 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 35 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2005 12:00:00 AM | Permit Number 47239 | 5995410.10661733 | 2114891.76691609 | 37.7868254226819 | -122.4596752059 | (37.7868254226819, -122.4596752059) | ||
| 99247 | 99247 | 39768 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 46 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1999 12:00:00 AM | Permit Number 41135 | 6001607.15965673 | 2108512.01191252 | 37.7696626327912 | -122.437777789702 | (37.7696626327912, -122.437777789702) | |||
| 99750 | 99750 | 92208 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
| 99863 | 99863 | 48654 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 Moraga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45947 | 5992474.12537509 | 2103859.88961246 | 37.7563655794475 | -122.469029766101 | (37.7563655794475, -122.469029766101) | ||
| 100050 | 100050 | 112184 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 301x CORBETT AVE | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | ||||
| 100209 | 100209 | 110231 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 60 CHURCH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6004050.0 | 2108474.0 | 37.7696968628614 | -122.42932537357001 | (37.7696968628614, -122.42932537357) | ||||
| 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) | |||||
| 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) |
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");