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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13861 | 13861 | 12127 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016490.26403 | 2095091.74303 | 37.733648414028295 | -122.385361804207 | (37.7336484140283, -122.385361804207) | |||
| 13902 | 13902 | 14887 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 151 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2006 12:00:00 AM | 3 | 3x3 | 6017068.53164 | 2098456.8281 | 37.7429202372855 | -122.38359673900699 | (37.7429202372855, -122.383596739007) | ||
| 13922 | 13922 | 14989 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6016436.5067300005 | 2097390.6567700002 | 37.7399577940171 | -122.38570783365101 | (37.7399577940171, -122.385707833651) | |||
| 14055 | 14055 | 102316 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2325 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x6 | 6010512.04072 | 2105967.73717 | 37.763178958366396 | -122.406796606491 | (37.7631789583664, -122.406796606491) | |||
| 14130 | 14130 | 12150 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/1996 12:00:00 AM | 2 | 3X3 | 6016234.16268 | 2095665.57813 | 37.735209878118 | -122.386287222793 | (37.735209878118, -122.386287222793) | ||
| 14260 | 14260 | 14934 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016937.56123 | 2098168.30957 | 37.742120784060795 | -122.38402951616301 | (37.7421207840608, -122.384029516163) | |||
| 14289 | 14289 | 102315 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2325 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x6 | 6010497.0299 | 2105967.33167 | 37.7631770050447 | -122.40684849557199 | (37.7631770050447, -122.406848495572) | |||
| 14350 | 14350 | 12152 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/1996 12:00:00 AM | 6 | 3X3 | 6016198.01461 | 2095698.1267099997 | 37.7352972490591 | -122.386414469663 | (37.7352972490591, -122.386414469663) | ||
| 14352 | 14352 | 14936 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016920.64099 | 2098083.60989 | 37.7418872804668 | -122.38408212471201 | (37.7418872804668, -122.384082124712) | |||
| 14417 | 14417 | 48751 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 14459 | 14459 | 14937 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016913.42346 | 2098066.4048200003 | 37.741839639797504 | -122.384105882978 | (37.7418396397975, -122.384105882978) | |||
| 14499 | 14499 | 35359 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 917 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 28 | 6x6 | Permit Number 38821 | 6011905.65469 | 2104108.25722 | 37.758151117709104 | -122.40184581615 | (37.7581511177091, -122.40184581615) |
| 14530 | 14530 | 12145 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6016306.3498599995 | 2095580.8792299998 | 37.734981307347205 | -122.386031740688 | (37.7349813073472, -122.386031740688) | |||
| 14566 | 14566 | 14942 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016868.17311 | 2097974.63279 | 37.7415851505377 | -122.38425595555401 | (37.7415851505377, -122.384255955554) | |||
| 14766 | 14766 | 12139 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1996 12:00:00 AM | 6 | 3X3 | 6016385.33586 | 2095408.8215700001 | 37.7345132425897 | -122.385746667286 | (37.7345132425897, -122.385746667286) | ||
| 14800 | 14800 | 12153 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016182.90625 | 2095712.9210700002 | 37.7353370350581 | -122.386467736523 | (37.7353370350581, -122.386467736523) | |||
| 15037 | 15037 | 14946 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016823.8175 | 2097912.1941299997 | 37.741411254039 | -122.38440497592899 | (37.741411254039, -122.384404975929) | |||
| 15253 | 15253 | 14890 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 151 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017084.252730001 | 2098515.6728 | 37.743082681818294 | -122.383546475015 | (37.7430826818183, -122.383546475015) | |||
| 15356 | 15356 | 54446 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 661 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1972 12:00:00 AM | 30 | Permit Number 10224 | 6014152.690909999 | 2104085.93791 | 37.7582149794585 | -122.394072973006 | (37.7582149794585, -122.394072973006) | ||
| 15452 | 15452 | 12142 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1996 12:00:00 AM | 3 | 3X3 | 6016364.0707 | 2095472.0382700001 | 37.734685646232 | -122.385824593536 | (37.734685646232, -122.385824593536) | ||
| 15460 | 15460 | 14875 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 50 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017137.53448 | 2098765.92965 | 37.7437727810994 | -122.383379656173 | (37.7437727810994, -122.383379656173) | |||
| 15463 | 15463 | 14991 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016409.43425 | 2097357.66427 | 37.739865705229505 | -122.38579914093201 | (37.7398657052295, -122.385799140932) | |||
| 15486 | 15486 | 14943 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016856.6474 | 2097956.20405 | 37.7415339116704 | -122.38429452477101 | (37.7415339116704, -122.384294524771) | |||
| 15558 | 15558 | 14894 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 151 Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6017116.82626 | 2098595.36732 | 37.743303307108704 | -122.38343939001899 | (37.7433033071087, -122.383439390019) | ||
| 15637 | 15637 | 48745 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 15647 | 15647 | 26457 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 401X Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/13/1997 12:00:00 AM | 6 | 3x3 | 6017757.31102 | 2096823.45757 | 37.7384733757484 | -122.381101567303 | (37.7384733757484, -122.381101567303) | ||
| 15691 | 15691 | 11881 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017730.140319999 | 2096877.36865 | 37.7386199049771 | -122.381199258841 | (37.7386199049771, -122.381199258841) | |||
| 15745 | 15745 | 106168 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1052 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6012164.747830001 | 2103476.70855 | 37.7564314799541 | -122.400905383382 | (37.7564314799541, -122.400905383382) | ||||
| 15813 | 15813 | 14969 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3x3 | 6016654.44168 | 2097681.89431 | 37.7407695301847 | -122.38497458311501 | (37.7407695301847, -122.384974583115) | |||
| 15841 | 15841 | 12149 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016248.95724 | 2095649.3696400002 | 37.735166191751 | -122.38623494249399 | (37.735166191751, -122.386234942494) | |||
| 16015 | 16015 | 12144 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6016321.20053 | 2095553.30546 | 37.734906417192704 | -122.38597847472201 | (37.7349064171927, -122.385978474722) | |||
| 16035 | 16035 | 54185 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1526 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | 30 | 4x4 | Permit Number 9920 | 6015598.37895 | 2096494.31778 | 37.7374502170542 | -122.388543207207 | (37.7374502170542, -122.388543207207) | |
| 16097 | 16097 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X Portola Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 16135 | 16135 | 12122 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1996 12:00:00 AM | 3 | 3X3 | 6016530.391559999 | 2095003.08247 | 37.7334071897754 | -122.38521689463998 | (37.7334071897754, -122.38521689464) | ||
| 16139 | 16139 | 19754 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY15 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
| 16140 | 16140 | 12129 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016454.923280001 | 2095170.51744 | 37.7338627575466 | -122.385489476485 | (37.7338627575466, -122.385489476485) | |||
| 16161 | 16161 | 14904 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 175 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6017055.387680001 | 2098389.95887 | 37.7427359014434 | -122.383637533158 | (37.7427359014434, -122.383637533158) | |||
| 16206 | 16206 | 12124 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016510.880609999 | 2095043.15703 | 37.733516147150794 | -122.38528714160499 | (37.7335161471508, -122.385287141605) | |||
| 16226 | 16226 | 14876 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 50 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6017126.2926199995 | 2098751.68022 | 37.7437330337612 | -122.383417536507 | (37.7437330337612, -122.383417536507) | |||
| 16230 | 16230 | 11782 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991290.0959 | 2091855.3897900002 | 37.7233358062868 | -122.472249472731 | (37.7233358062868, -122.472249472731) | ||
| 16235 | 16235 | 11882 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/2002 12:00:00 AM | 6 | 3X3 | 6017717.79122 | 2096860.5282400001 | 37.73857298286829 | -122.38124078595399 | (37.7385729828683, -122.381240785954) | ||
| 16296 | 16296 | 14940 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016890.87226 | 2098016.163 | 37.7417004391255 | -122.38418036034099 | (37.7417004391255, -122.384180360341) | |||
| 16332 | 16332 | 26455 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 401X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | Permit Number 769095 | 6017718.24501 | 2096772.8589700002 | 37.738332285595206 | -122.381233122826 | (37.7383322855952, -122.381233122826) | ||
| 16335 | 16335 | 14985 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016500.60947 | 2097476.87493 | 37.740198078478706 | -122.385492197802 | (37.7401980784787, -122.385492197802) | |||
| 16398 | 16398 | 14883 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 50 Mendell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6017019.70543 | 2098544.01606 | 37.7431569388511 | -122.383771637374 | (37.7431569388511, -122.383771637374) | ||
| 16427 | 16427 | 4769 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 20 Commer Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6016624.63849 | 2094705.64307 | 37.732595693724605 | -122.384870339116 | (37.7325956937246, -122.384870339116) | |||
| 16431 | 16431 | 14935 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/14/1989 12:00:00 AM | 12 | 3X3 | 6016933.70411 | 2098147.37147 | 37.742063079043206 | -122.38404139529699 | (37.7420630790432, -122.384041395297) | ||
| 16630 | 16630 | 4771 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 20 Commer Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6016532.61927 | 2094742.5477 | 37.7326919364855 | -122.385191045451 | (37.7326919364855, -122.385191045451) | |||
| 16652 | 16652 | 14973 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Mendell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016605.91834 | 2097618.21478 | 37.740591995028 | -122.385137924278 | (37.740591995028, -122.385137924278) | |||
| 16680 | 16680 | 14970 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 18 | 3x3 | 6016646.28629 | 2097669.62437 | 37.740735388316395 | -122.385001926999 | (37.7407353883164, -122.385001926999) | |||
| 16793 | 16793 | 14986 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016489.59625 | 2097461.2360400003 | 37.7401545279128 | -122.385529187825 | (37.7401545279128, -122.385529187825) | |||
| 16857 | 16857 | 50824 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47344 | |||||||||
| 16938 | 16938 | 16130 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 339 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 5999827.96036 | 2094635.2259799999 | 37.73145901361271 | -122.442935300848 | (37.7314590136127, -122.442935300848) | |||
| 17040 | 17040 | 12655 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1016 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 6x21 | 5992294.67406 | 2114836.34542 | 37.7864936077921 | -122.47044973930201 | (37.7864936077921, -122.470449739302) | |||
| 17061 | 17061 | 5075 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2518X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002273.67466 | 2097186.93566 | 37.7386045571491 | -122.434662408564 | (37.7386045571491, -122.434662408564) | |||
| 17111 | 17111 | 29966 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991400.88182 | 2093544.5626 | 37.7279802659702 | -122.471989567778 | (37.7279802659702, -122.471989567778) | ||
| 17140 | 17140 | 19179 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 106 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6003475.35494 | 2107644.30442 | 37.767386171248 | -122.431253819727 | (37.767386171248, -122.431253819727) | |||
| 17196 | 17196 | 11780 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991289.71415 | 2091805.7046599998 | 37.7231993611319 | -122.47224717228599 | (37.7231993611319, -122.472247172286) | ||
| 17200 | 17200 | 4330 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 831 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001821.43184 | 2095823.4199 | 37.7348349741444 | -122.436128498656 | (37.7348349741444, -122.436128498656) | |||
| 17365 | 17365 | 2069 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 843 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001701.031909999 | 2095490.9133099997 | 37.7339151466682 | -122.43652097087299 | (37.7339151466682, -122.436520970873) | |||
| 17402 | 17402 | 2557 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1101 Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001119.92736 | 2095647.46626 | 37.7343119662085 | -122.43854123490802 | (37.7343119662085, -122.438541234908) | |||
| 17406 | 17406 | 19187 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 125 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003528.70248 | 2107586.69801 | 37.7672310211182 | -122.43106518602501 | (37.7672310211182, -122.431065186025) | |||
| 17538 | 17538 | 30052 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 5991303.9336 | 2092006.82804 | 37.723752419029005 | -122.4722126725 | (37.723752419029, -122.4722126725) | |||
| 17615 | 17615 | 12962 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 65 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6001964.35979 | 2095666.44125 | 37.734412066167394 | -122.435623121007 | (37.7344120661674, -122.435623121007) | |||
| 17626 | 17626 | 5082 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2563 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002286.6614 | 2096942.37452 | 37.7379337860994 | -122.434600024386 | (37.7379337860994, -122.434600024386) | |||
| 17686 | 17686 | 14577 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1135 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 5999374.0888 | 2108906.7208 | 37.7706191740488 | -122.445530268097 | (37.7706191740488, -122.445530268097) | |||
| 17705 | 17705 | 4348 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 924 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001433.25109 | 2095991.10142 | 37.735273327102796 | -122.43748257546999 | (37.7352733271028, -122.43748257547) | |||
| 17711 | 17711 | 29585 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991398.016530001 | 2093471.7437599998 | 37.7277801578055 | -122.47199416782101 | (37.7277801578055, -122.471994167821) | ||
| 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) | |||
| 17750 | 17750 | 2151 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1107 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001039.9865 | 2095675.11992 | 37.734383349014394 | -122.43881959664101 | (37.7343833490144, -122.438819596641) | |||
| 17761 | 17761 | 11776 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991282.42505 | 2091712.4343599998 | 37.7229428421321 | -122.47226557329701 | (37.7229428421321, -122.472265573297) | ||
| 17765 | 17765 | 16205 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 508 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998710.56573 | 2094730.4194599998 | 37.7316566225543 | -122.44680517802401 | (37.7316566225543, -122.446805178024) | |||
| 17835 | 17835 | 100094 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 11X Shotwell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007856.7 | 2107724.0 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | |||
| 17838 | 17838 | 110450 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 56 HANCOCK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003933.0 | 2105145.0 | 37.760549606286396 | -122.429492630385 | (37.7605496062864, -122.429492630385) | ||||
| 17846 | 17846 | 5083 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2566 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6002238.293895099 | 2096914.6597978 | 37.7378549419938 | -122.434765273064 | (37.7378549419938, -122.434765273064) | |||
| 17868 | 17868 | 11672 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 710X Junipero Serra Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991310.6193982 | 2092985.7524279999 | 37.7264406890913 | -122.472260886614 | (37.7264406890913, -122.472260886614) | ||
| 17901 | 17901 | 16237 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 582 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5998240.26407 | 2094738.81412 | 37.7316527941384 | -122.448431701761 | (37.7316527941384, -122.448431701761) | |||
| 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) | ||
| 17949 | 17949 | 11779 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991286.49524 | 2091779.26927 | 37.723126589806704 | -122.47225637323 | (37.7231265898067, -122.47225637323) | ||
| 17961 | 17961 | 9357 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 244 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6000993.28256 | 2098353.57528 | 37.7417351034945 | -122.43917297625099 | (37.7417351034945, -122.439172976251) | |||
| 18008 | 18008 | 4349 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 925 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001343.36929 | 2095994.0746099998 | 37.735276380288795 | -122.437793542132 | (37.7352763802888, -122.437793542132) | |||
| 18048 | 18048 | 19161 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 91 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 6003505.743559999 | 2107783.3498 | 37.7677696781622 | -122.431158635477 | (37.7677696781622, -122.431158635477) | |||
| 18094 | 18094 | 16230 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 567 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998330.20149 | 2094661.3287400003 | 37.7314451793547 | -122.44811519437799 | (37.7314451793547, -122.448115194378) | |||
| 18112 | 18112 | 16175 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 435 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999172.6391900005 | 2094646.32207 | 37.7314520969304 | -122.445201659842 | (37.7314520969304, -122.445201659842) | |||
| 18119 | 18119 | 4297 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4348 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001630.45884 | 2100316.0332 | 37.7471597870885 | -122.43711030921301 | (37.7471597870885, -122.437110309213) | |||
| 18208 | 18208 | 25235 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1495 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 5995409.5475 | 2092077.8007 | 37.7241840406255 | -122.45802548285201 | (37.7241840406255, -122.458025482852) | |||
| 18247 | 18247 | 4314 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 730 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002222.872380001 | 2095754.0760700002 | 37.7346673711025 | -122.434735624149 | (37.7346673711025, -122.434735624149) | |||
| 18249 | 18249 | 4385 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5 Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001732.01968 | 2095763.05053 | 37.734664133544506 | -122.43643330766001 | (37.7346641335445, -122.43643330766) | |||
| 18275 | 18275 | 5786 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 545 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003176.40068 | 2108310.41756 | 37.769198208965896 | -122.432335439751 | (37.7691982089659, -122.432335439751) | |||
| 18349 | 18349 | 4320 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X Brompton Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002191.35969 | 2095656.04517 | 37.7343964116617 | -122.434837565898 | (37.7343964116617, -122.434837565898) | |||
| 18367 | 18367 | 99991 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44594 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | ||||
| 18437 | 18437 | 11778 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.6486 | 2091754.7927400002 | 37.723059276443294 | -122.472260973265 | (37.7230592764433, -122.472260973265) | ||
| 18545 | 18545 | 5094 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2608 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6002249.53771 | 2096620.3889799998 | 37.737047580668296 | -122.434705361078 | (37.7370475806683, -122.434705361078) | |||
| 18608 | 18608 | 24390 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 501X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 6 | 3 | 5991485.44871 | 2094112.7680400002 | 37.7295453093597 | -122.471738611958 | (37.7295453093597, -122.471738611958) | ||
| 18611 | 18611 | 4312 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002294.35545 | 2095730.49773 | 37.73460668843771 | -122.434486797948 | (37.7346066884377, -122.434486797948) | |||
| 18759 | 18759 | 12961 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 62 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6001945.75733 | 2095702.9994599998 | 37.7345113899755 | -122.435690050366 | (37.7345113899755, -122.435690050366) | |||
| 18773 | 18773 | 24545 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 704 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X4 | 6007936.0377400005 | 2097164.78596 | 37.7388635691031 | -122.415083035373 | (37.7388635691031, -122.415083035373) | |||
| 18857 | 18857 | 2085 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 921 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001545.78168 | 2095530.67878 | 37.734015510104896 | -122.437060563206 | (37.7340155101049, -122.437060563206) | |||
| 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) | ||
| 18901 | 18901 | 29590 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991297.67299 | 2091930.7639 | 37.723543203431504 | -122.47222877213301 | (37.7235432034315, -122.472228772133) |
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");