Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 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) | |||
| 88638 | 88638 | 24333 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 601X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | ||||
| 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) | |||||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | |||||
| 90871 | 90871 | 111272 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X BOSWORTH ST | 11 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 8 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 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) | ||
| 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) | |||||
| 92602 | 92602 | 95971 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5900 Geary Blvd | 5 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 5988665.62185 | 2112680.2165599996 | 37.7803629858967 | -122.482847132605 | (37.7803629858967, -122.482847132605) | |||
| 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) | |||||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||||
| 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) | ||
| 95752 | 95752 | 57351 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4018 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1976 12:00:00 AM | 32 | Permit Number 16185 | 6001769.31123132 | 2102956.25307942 | 37.754417093101296 | -122.436819142141 | (37.7544170931013, -122.436819142141) | ||
| 95818 | 95818 | 60967 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 721 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | 22 | Permit Number 20772 | 5994690.06322675 | 2091210.94869199 | 37.721762508120705 | -122.46044983368999 | (37.7217625081207, -122.46044983369) | |
| 95857 | 95857 | 2117 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 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) | |||||
| 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) | |||
| 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) | |||
| 97454 | 97454 | 105000 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 280X SAN MARCOS AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 65 | Tree tag no. 416 | 5993063.2 | 2100277.9 | 37.7465643757171 | -122.466732187112 | (37.7465643757171, -122.466732187112) | |||
| 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) | |||
| 97581 | 97581 | 88132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1288 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 6007534.97421 | 2121589.88295 | 37.80590654683979 | -122.41820094914101 | (37.8059065468398, -122.418200949141) | ||||
| 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) | ||||
| 98208 | 98208 | 18063 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2901 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/02/1990 12:00:00 AM | 12 | 6000054.1494607 | 2114718.9299923 | 37.7866168143441 | -122.443595531026 | (37.7866168143441, -122.443595531026) | |||
| 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) | |||
| 98676 | 98676 | 95965 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5400 Geary Blvd | 1 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 5990210.87302 | 2112736.64328 | 37.7806077057511 | -122.47750557201701 | (37.7806077057511, -122.477505572017) | |||
| 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) | |||||
| 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) | |||
| 99739 | 99739 | 111264 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X BOSWORTH ST | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 10 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 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) | ||
| 100278 | 100278 | 24335 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 601X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | ||||
| 100446 | 100446 | 2113 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 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) | |||||
| 101100 | 101100 | 33710 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 107 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37778 | 6003699.03578605 | 2108805.33287927 | 37.770586746466606 | -122.430562993164 | (37.7705867464666, -122.430562993164) | |||
| 101158 | 101158 | 106500 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 420X Shrader St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997462.73555 | 2109001.92463 | 37.770771276139705 | -122.452148498658 | (37.7707712761397, -122.452148498658) | |||||
| 101571 | 101571 | 47011 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 190 Hermann St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45008 | 6004362.86360721 | 2108776.26099442 | 37.7705445057003 | -122.428264732992 | (37.7705445057003, -122.428264732992) | |||
| 102839 | 102839 | 102414 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1301 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6000345.0 | 2109213.0 | 37.77151552050871 | -122.44219387377399 | (37.7715155205087, -122.442193873774) | |||||
| 103157 | 103157 | 46319 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 286 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2002 12:00:00 AM | Permit Number 44573 | 6003285.02102914 | 2101578.06066566 | 37.750718929229 | -122.431479048341 | (37.750718929229, -122.431479048341) | |||
| 103229 | 103229 | 101442 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 31X College Ave | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004315.3 | 2095877.6 | 37.7351251110849 | -122.427510187339 | (37.7351251110849, -122.427510187339) | |||||
| 103408 | 103408 | 33684 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400 Ivy St | 2 | 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) | |||
| 103627 | 103627 | 2130 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 103674 | 103674 | 51158 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2663DIVISADERO Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 47563 | 6000913.18019234 | 2117191.80900567 | 37.7934556526619 | -122.440800954263 | (37.7934556526619, -122.440800954263) | |||
| 103736 | 103736 | 2138 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 103923 | 103923 | 121004 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 770 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010080.56543171 | 2116389.03640526 | 37.7917692527785 | -122.409024297587 | (37.7917692527785, -122.409024297587) | |||||
| 104582 | 104582 | 95964 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Geary Blvd | 6 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 5990756.89162 | 2112756.21837 | 37.780693122390204 | -122.47561808245399 | (37.7806931223902, -122.475618082454) | ||||
| 104933 | 104933 | 73957 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3100X 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1988 12:00:00 AM | 12 | 6008781.55607863 | 2105099.68545767 | 37.7606985097306 | -122.41272042520201 | (37.7606985097306, -122.412720425202) | |||
| 105037 | 105037 | 95960 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5100 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 5991179.182440001 | 2112771.35122 | 37.780759144985 | -122.47415829445299 | (37.780759144985, -122.474158294453) | |||
| 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) | ||||
| 105814 | 105814 | 48445 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 510 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2002 12:00:00 AM | Permit Number 45816 | 6011222.45390726 | 2109921.84553885 | 37.774075764530394 | -122.404617880494 | (37.7740757645304, -122.404617880494) | |||
| 105850 | 105850 | 104948 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 535 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 105899 | 105899 | 30491 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1123 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1956 12:00:00 AM | Permit Number 150 | 6011534.42767209 | 2119133.27614211 | 37.7993856101137 | -122.404187135798 | (37.7993856101137, -122.404187135798) | |||
| 106000 | 106000 | 43348 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Fulton St | 3 | 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) | |||
| 106031 | 106031 | 108759 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1443 PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999670.4 | 2109034.0 | 37.7709855623052 | -122.444514476591 | (37.7709855623052, -122.444514476591) | |||||
| 106372 | 106372 | 47599 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | ||
| 106694 | 106694 | 33517 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 148 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2005 12:00:00 AM | Permit Number 48274 | 6007365.58443644 | 2098215.69549509 | 37.741717059847495 | -122.41712984786601 | (37.7417170598475, -122.417129847866) | |||
| 106768 | 106768 | 51557 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 29 West Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2005 12:00:00 AM | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691001 | (37.7868031451511, -122.48266323691) | |||
| 106968 | 106968 | 2121 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 06/01/2000 12:00:00 AM | 3 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 107064 | 107064 | 99971 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2270 Folsom St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
| 107083 | 107083 | 30837 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 549 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1995 12:00:00 AM | Permit Number 34686 | 5991243.131678 | 2111669.17977704 | 37.7777365894405 | -122.473856633134 | (37.7777365894405, -122.473856633134) | |||
| 107100 | 107100 | 53057 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 235@ FOLSOM Main St | 1 | 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) | |||
| 107470 | 107470 | 33185 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 585 Dewey Blvd | 1 | 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) | ||
| 108285 | 108285 | 53059 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 235@ FOLSOM Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49035 | 6014758.5845738 | 2115729.7936401 | 37.790220067206704 | -122.392792095849 | (37.7902200672067, -122.392792095849) | ||||
| 108450 | 108450 | 56950 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1450 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 32 | Permit Number 14202 | 6006662.38450486 | 2118054.63736364 | 37.796150504380606 | -122.42096952545499 | (37.7961505043806, -122.420969525455) | ||
| 108479 | 108479 | 30493 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 245 Bemis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1956 12:00:00 AM | Permit Number 153 | 6003080.18850262 | 2096294.42354032 | 37.736199676901705 | -122.431810162156 | (37.7361996769017, -122.431810162156) | |||
| 108489 | 108489 | 50567 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2295 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | |||
| 109025 | 109025 | 33515 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 65 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37620 | 6006865.28384578 | 2099333.19830806 | 37.74475731433971 | -122.41893896519899 | (37.7447573143397, -122.418938965199) | |||
| 109040 | 109040 | 106904 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X MAYFAIR DR | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 5997868.0 | 2114773.0 | 37.7866403525015 | -122.45116294110301 | (37.7866403525015, -122.451162941103) | ||||
| 109129 | 109129 | 106906 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X MAYFAIR DR | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5997868.0 | 2114773.0 | 37.7866403525015 | -122.45116294110301 | (37.7866403525015, -122.451162941103) | ||||
| 109169 | 109169 | 33489 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 41 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37615 | 6006958.13481375 | 2099504.24101761 | 37.7452321871095 | -122.41863003056999 | (37.7452321871095, -122.41863003057) | |||
| 109243 | 109243 | 95967 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5500 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 5 | 5989915.47138 | 2112737.13311 | 37.780591904899104 | -122.478527531838 | (37.7805919048991, -122.478527531838) | |||
| 109251 | 109251 | 104950 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 109301 | 109301 | 2114 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 109389 | 109389 | 33217 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.745301271936604 | -122.459301205113 | (37.7453012719366, -122.459301205113) | ||
| 109632 | 109632 | 54447 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 312 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2015 12:00:00 AM | 3 | Permit Number 10227 | 6013732.98221263 | 2105635.65539745 | 37.762446829343205 | -122.395633096853 | (37.7624468293432, -122.395633096853) | ||
| 109651 | 109651 | 100021 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 109730 | 109730 | 100022 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) |
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");