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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 122291 | 122291 | 104956 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 759 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 144026 | 144026 | 104949 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 535 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 22414 | 22414 | 9013 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5317 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 8M | 5990485.6581 | 2112681.4706 | 37.7804721580667 | -122.47655093756501 | (37.7804721580667, -122.476550937565) | ||
| 26380 | 26380 | 206314 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3698 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5990493.86406 | 2091288.56287 | 37.721733327719 | -122.47496051233699 | (37.721733327719, -122.474960512337) | |||
| 179272 | 179272 | 205501 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1118 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 5990494.6785 | 2103168.0611799997 | 37.7543514325961 | -122.475824791393 | (37.7543514325961, -122.475824791393) | |||
| 128415 | 128415 | 96150 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 129 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 9x5 | 5990508.47141 | 2114517.58396 | 37.7855149374501 | -122.47660619485701 | (37.7855149374501, -122.476606194857) | |||
| 24919 | 24919 | 205502 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1112 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 5990518.963819999 | 2103168.28108 | 37.754353444374104 | -122.475740823499 | (37.7543534443741, -122.475740823499) | |||
| 161995 | 161995 | 176044 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 5990534.22824 | 2089263.3063400001 | 37.7161748133009 | -122.47467324639099 | (37.7161748133009, -122.474673246391) | ||||
| 119299 | 119299 | 353 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3590X 19th Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | |||
| 182768 | 182768 | 205503 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1106 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5990538.13175 | 2103170.07444 | 37.7543594797245 | -122.475674667545 | (37.7543594797245, -122.475674667545) | |||
| 35214 | 35214 | 206315 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3646 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5990563.4574 | 2092379.2095700002 | 37.72473200467321 | -122.474799514783 | (37.7247320046732, -122.474799514783) | |||
| 58965 | 58965 | 331 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3402X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 50 | 2X3 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 78918 | 78918 | 332 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3402X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 80 | 2X3 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 41746 | 41746 | 122082 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 431 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5990582.93071 | 2112432.87879 | 37.7797952350064 | -122.476196266646 | (37.7797952350064, -122.476196266646) | |||
| 50060 | 50060 | 206316 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3578 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5990600.84966 | 2093024.2495 | 37.726505289668204 | -122.47471731316601 | (37.7265052896682, -122.474717313166) | |||
| 149912 | 149912 | 206317 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3578 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 3ft | 5990608.28598 | 2093089.7399 | 37.7266855407931 | -122.474696384147 | (37.7266855407931, -122.474696384147) | |||
| 74409 | 74409 | 251072 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 10ft | 5990697.77 | 2112688.192 | 37.7805029132293 | -122.475817641236 | (37.7805029132293, -122.475817641236) | |||
| 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) | ||||
| 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) | ||||
| 119414 | 119414 | 95963 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 5 | 5990756.89162 | 2112756.21837 | 37.780693122390204 | -122.47561808245399 | (37.7806931223902, -122.475618082454) | |||
| 32868 | 32868 | 251069 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5990794.5513 | 2112690.3427 | 37.7805144291466 | -122.47548298954099 | (37.7805144291466, -122.475482989541) | |||
| 4673 | 4673 | 253651 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 131 Font Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 123839 | 123839 | 114250 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 131 FONT BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 148325 | 148325 | 205489 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1430 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 5990863.69165 | 2105623.89692 | 37.7611158947076 | -122.47472789547899 | (37.7611158947076, -122.474727895479) | |||
| 80267 | 80267 | 107218 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 WINSTON DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 42 | 5990934.3 | 2093194.2 | 37.7269912477326 | -122.47357699184799 | (37.7269912477326, -122.473576991848) | ||||
| 115186 | 115186 | 107220 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 WINSTON DR | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5990934.3 | 2093194.2 | 37.7269912477326 | -122.47357699184799 | (37.7269912477326, -122.473576991848) | |||||
| 79797 | 79797 | 114240 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x FONT BLVD | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | |||||
| 105245 | 105245 | 114225 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x FONT BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 144197 | 144197 | 121244 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | 5990956.24309491 | 2110611.72775368 | 37.7748164950302 | -122.474771867875 | (37.7748164950302, -122.474771867875) | ||||
| 185260 | 185260 | 122092 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 6ft | 5990960.29001 | 2110539.25119 | 37.774617728690295 | -122.474752577866 | (37.7746177286903, -122.474752577866) | |||
| 22280 | 22280 | 16692 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Noriega St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/25/2016 08:08:00 AM | 3 | 8 | 5990985.786309999 | 2103156.72144 | 37.7543487579916 | -122.474125605135 | (37.7543487579916, -122.474125605135) | ||
| 44686 | 44686 | 251075 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5100x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990994.9145 | 2112700.954 | 37.7805551774565 | -122.47479062026899 | (37.7805551774565, -122.474790620269) | |||
| 150323 | 150323 | 217785 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 124 Sloat Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 5991003.2864 | 2096055.6883900003 | 37.7348521691816 | -122.473547145886 | (37.7348521691816, -122.473547145886) | ||||
| 156095 | 156095 | 54995 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 692 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 13 | Permit Number 10873 | 5991003.861930001 | 2110730.86063 | 37.7751463606227 | -122.47461584260799 | (37.7751463606227, -122.474615842608) | ||
| 18870 | 18870 | 16690 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991053.49575 | 2103158.03284 | 37.7543562808184 | -122.473891546652 | (37.7543562808184, -122.473891546652) | ||
| 17715 | 17715 | 16378 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Moraga St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 5991088.16435 | 2103840.65792 | 37.756232597572605 | -122.473821451692 | (37.7562325975726, -122.473821451692) | |||
| 95442 | 95442 | 29636 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 98950 | 98950 | 29632 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 99891 | 99891 | 29635 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 100149 | 100149 | 29637 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 103060 | 103060 | 29629 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 103985 | 103985 | 29638 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 108232 | 108232 | 29628 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 140900 | 140900 | 29634 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 143674 | 143674 | 29630 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 145795 | 145795 | 29633 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1110X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 32763 | 32763 | 68295 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 25 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 17 | Permit Number 32104 | 5991131.604780001 | 2114879.69838 | 37.7865453253482 | -122.47447679418 | (37.7865453253482, -122.47447679418) | |
| 63740 | 63740 | 122144 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 25 15th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 8ft | 5991132.251759999 | 2114855.8727599997 | 37.7864799443229 | -122.47447281643299 | (37.7864799443229, -122.474472816433) | |||
| 136307 | 136307 | 122145 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 31 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 5991133.61704 | 2114833.40571 | 37.78641833516821 | -122.47446645276199 | (37.7864183351682, -122.474466452762) | |||
| 43190 | 43190 | 122146 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 31 15th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 8ft | 5991133.9927199995 | 2114818.51521 | 37.7863774717716 | -122.47446406594999 | (37.7863774717716, -122.47446406595) | |||
| 79741 | 79741 | 16693 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X NORIEGA ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991142.4 | 2103205.1 | 37.7544906639436 | -122.473587529216 | (37.7544906639436, -122.473587529216) | ||
| 51161 | 51161 | 122149 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 159 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5991148.1704400005 | 2114368.07321 | 37.785141504845704 | -122.47438213241001 | (37.7851415048457, -122.47438213241) | |||
| 62175 | 62175 | 212292 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5991164.37326 | 2089829.54432 | 37.7177660575462 | -122.472536442798 | (37.7177660575462, -122.472536442798) | |||
| 170614 | 170614 | 212293 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5991165.05081 | 2089858.71083 | 37.717846180842294 | -122.472536226064 | (37.7178461808423, -122.472536226064) | |||
| 154256 | 154256 | 212294 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5991166.95703 | 2089883.0190299999 | 37.7179130355286 | -122.472531408396 | (37.7179130355286, -122.472531408396) | |||
| 103696 | 103696 | 58220 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 40 Winston Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1978 12:00:00 AM | 32 | 3x80 | Permit Number 17215 | 5991168.576701799 | 2093158.16680643 | 37.726905874360796 | -122.472764483204 | (37.7269058743608, -122.472764483204) | |
| 186690 | 186690 | 212295 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5991170.53267 | 2089939.6813400001 | 37.7180688232854 | -122.472523177809 | (37.7180688232854, -122.472523177809) | |||
| 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) | |||
| 96556 | 96556 | 24460 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 6 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
| 110250 | 110250 | 24414 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
| 125704 | 125704 | 11772 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
| 127942 | 127942 | 24412 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
| 142712 | 142712 | 11790 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 145860 | 145860 | 24413 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 6 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
| 20236 | 20236 | 29626 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Junipero Serra Blvd | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991174.60245 | 2090776.1353200001 | 37.720365755664794 | -122.47257006037901 | (37.7203657556648, -122.472570060379) | ||
| 162250 | 162250 | 122264 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400 Balboa St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 4ft | 5991175.02195 | 2111348.8824 | 37.7768531954343 | -122.474068870116 | (37.7768531954343, -122.474068870116) | |||
| 162733 | 162733 | 212296 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5991176.06439 | 2090044.25898 | 37.7183562879852 | -122.472511677268 | (37.7183562879852, -122.472511677268) | |||
| 17935 | 17935 | 29599 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Junipero Serra Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991176.65606 | 2091094.6598 | 37.7212404641514 | -122.472586172621 | (37.7212404641514, -122.472586172621) | ||
| 67053 | 67053 | 212297 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991177.8274300005 | 2090064.7629799999 | 37.7184126889791 | -122.47250707726002 | (37.7184126889791, -122.47250707726) | |||
| 31562 | 31562 | 212298 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991179.120709999 | 2090094.55389 | 37.7184945623549 | -122.47250477768699 | (37.7184945623549, -122.472504777687) | |||
| 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) | |||
| 146358 | 146358 | 212299 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991184.2984 | 2090150.76712 | 37.7186492097602 | -122.47249097667401 | (37.7186492097602, -122.472490976674) | |||
| 173416 | 173416 | 212300 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991186.31185 | 2090192.49351 | 37.7187638967107 | -122.472487057435 | (37.7187638967107, -122.472487057435) | |||
| 87249 | 87249 | 29605 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 910X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991188.7321263 | 2091104.0152466998 | 37.7212668508959 | -122.472545111236 | (37.7212668508959, -122.472545111236) | ||
| 112917 | 112917 | 29604 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 910X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991188.7321263 | 2091104.0152466998 | 37.7212668508959 | -122.472545111236 | (37.7212668508959, -122.472545111236) | ||
| 127749 | 127749 | 29603 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 910X Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991188.7321263 | 2091104.0152466998 | 37.7212668508959 | -122.472545111236 | (37.7212668508959, -122.472545111236) | ||
| 184198 | 184198 | 212301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991188.84719 | 2090215.0879099998 | 37.7188260821255 | -122.47247994019199 | (37.7188260821255, -122.472479940192) | |||
| 163038 | 163038 | 212302 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991190.15994 | 2090239.4345099998 | 37.7188930078858 | -122.47247717658001 | (37.7188930078858, -122.47247717658) | |||
| 52489 | 52489 | 212303 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5991192.118419999 | 2090269.21075 | 37.7189748794765 | -122.47247257657601 | (37.7189748794765, -122.472472576576) | |||
| 157693 | 157693 | 212304 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991192.55124 | 2090289.74279 | 37.7190312804608 | -122.472472576553 | (37.7190312804608, -122.472472576553) | |||
| 58519 | 58519 | 212305 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991194.3003 | 2090309.58448 | 37.7190858620976 | -122.47246797653901 | (37.7190858620976, -122.472467976539) | |||
| 41461 | 41461 | 212306 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991196.13313 | 2090333.39999 | 37.719151359714395 | -122.472463376508 | (37.7191513597144, -122.472463376508) | |||
| 40997 | 40997 | 68216 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 371 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 13 | 4x4 | Permit Number 32003 | 5991199.85508 | 2112923.89297 | 37.781179180083704 | -122.474097911754 | (37.7811791800837, -122.474097911754) |
| 28203 | 28203 | 122263 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400 Balboa St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 4ft | 5991199.98338 | 2111351.52204 | 37.7768618890602 | -122.473982714477 | (37.7768618890602, -122.473982714477) | |||
| 68407 | 68407 | 212307 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5991200.212719999 | 2090369.09522 | 37.7192496061609 | -122.47245187595 | (37.7192496061609, -122.47245187595) | |||
| 66442 | 66442 | 212308 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991201.47803 | 2090397.56088 | 37.7193278390954 | -122.47244957640801 | (37.7193278390954, -122.472449576408) | |||
| 166561 | 166561 | 212309 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991201.91083 | 2090418.0925900002 | 37.719384239169294 | -122.472449576413 | (37.7193842391693, -122.472449576413) | |||
| 32028 | 32028 | 212310 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 5991202.259869999 | 2090434.6504900001 | 37.7194297232904 | -122.472449576395 | (37.7194297232904, -122.472449576395) | |||
| 55711 | 55711 | 205076 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5991204.8696099995 | 2090463.7504 | 37.7195097755318 | -122.472442675902 | (37.7195097755318, -122.472442675902) | |||
| 39182 | 39182 | 205077 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5991206.77223 | 2090490.8774299999 | 37.719584369801396 | -122.47243807587601 | (37.7195843698014, -122.472438075876) | |||
| 158549 | 158549 | 205078 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5991207.21899 | 2090512.07145 | 37.7196425892212 | -122.47243807587601 | (37.7196425892212, -122.472438075876) | |||
| 73785 | 73785 | 205079 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 5991209.0936900005 | 2090537.87387 | 37.7197135448202 | -122.47243347583 | (37.7197135448202, -122.47243347583) | |||
| 134648 | 134648 | 212249 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1111 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 4ft | 5991209.84448 | 2089782.7559 | 37.7176402198878 | -122.472375861652 | (37.7176402198878, -122.472375861652) | |||
| 31596 | 31596 | 205081 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 5991210.7499 | 2090584.88401 | 37.7198427189488 | -122.47243117628099 | (37.7198427189488, -122.472431176281) | |||
| 174777 | 174777 | 205080 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 5991211.60542 | 2090562.33735 | 37.7197808608892 | -122.47242657625 | (37.7197808608892, -122.47242657625) | |||
| 72304 | 72304 | 205082 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991216.27623 | 2090657.6545099998 | 37.720042848675604 | -122.47241737616501 | (37.7200428486756, -122.472417376165) | |||
| 111045 | 111045 | 11732 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 4X6 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | |||
| 69407 | 69407 | 205083 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5991217.1837 | 2090700.70485 | 37.720161106826 | -122.472417376171 | (37.720161106826, -122.472417376171) | |||
| 67638 | 67638 | 205084 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991220.51447 | 2090732.43963 | 37.720248435491904 | -122.472408175222 | (37.7202484354919, -122.472408175222) |
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");