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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 18905 | 18905 | 2050 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001988.91143 | 2095411.22902 | 37.733712706561896 | -122.435519986756 | (37.7337127065619, -122.435519986756) | |||
| 18927 | 18927 | 16200 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998771.6064 | 2094729.9860599998 | 37.731658919424504 | -122.446594117934 | (37.7316589194245, -122.446594117934) | |||
| 18940 | 18940 | 4329 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 828 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6001820.48709 | 2095859.0092200001 | 37.7349326405301 | -122.436134310946 | (37.7349326405301, -122.436134310946) | |||
| 18946 | 18946 | 16174 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 431 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999199.03492 | 2094645.6030400002 | 37.731451629275796 | -122.445110353454 | (37.7314516292758, -122.445110353454) | |||
| 18960 | 18960 | 4321 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X Brompton Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002183.61558 | 2095631.29861 | 37.7343280236114 | -122.43486257064801 | (37.7343280236114, -122.434862570648) | |||
| 19062 | 19062 | 50066 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 406 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46794 | 6003569.14495563 | 2105912.6827965 | 37.7626368713078 | -122.430805824209 | (37.7626368713078, -122.430805824209) | ||
| 19090 | 19090 | 17231 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5 Ora Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6001200.02819 | 2098556.64623 | 37.7423044507995 | -122.438472666097 | (37.7423044507995, -122.438472666097) | |||
| 19148 | 19148 | 2110 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1041 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/06/2005 12:00:00 AM | 3 | 3X3 | 6001168.361930001 | 2095632.80978 | 37.734274477972896 | -122.43837273163601 | (37.7342744779729, -122.438372731636) | ||
| 19221 | 19221 | 16213 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 534 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998521.85607 | 2094732.39423 | 37.7316512625738 | -122.44745772428999 | (37.7316512625738, -122.44745772429) | |||
| 19223 | 19223 | 19185 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 113 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6003523.98986 | 2107648.07805 | 37.7673992887615 | -122.431085867714 | (37.7673992887615, -122.431085867714) | |||
| 19233 | 19233 | 5084 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2567 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1994 12:00:00 AM | 12 | 3X3 | 6002282.63151 | 2096922.4202 | 37.7378787673769 | -122.434612531259 | (37.7378787673769, -122.434612531259) | ||
| 19247 | 19247 | 106705 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 199X BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 5996224.0 | 2090880.0 | 37.7209419254054 | -122.455123542447 | (37.7209419254054, -122.455123542447) | ||||
| 19288 | 19288 | 1995 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 170 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6007282.5849 | 2098052.32823 | 37.7412638200836 | -122.41740525844801 | (37.7412638200836, -122.417405258448) | |||
| 19298 | 19298 | 5087 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2580 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6002234.74697 | 2096825.352 | 37.7376095220579 | -122.43477115188801 | (37.7376095220579, -122.434771151888) | |||
| 19301 | 19301 | 16599 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 57 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002865.439809999 | 2107949.91005 | 37.768190706574394 | -122.433385270511 | (37.7681907065744, -122.433385270511) | |||
| 19302 | 19302 | 16196 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 487 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 5998881.1124599995 | 2094651.6641 | 37.731450120229795 | -122.446209903265 | (37.7314501202298, -122.446209903265) | |||
| 19349 | 19349 | 4318 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002203.816790001 | 2095704.7005900003 | 37.7345307155218 | -122.434797975952 | (37.7345307155218, -122.434797975952) | |||
| 19365 | 19365 | 16212 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 534 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998539.508719999 | 2094732.8633599998 | 37.73165355946 | -122.447396729574 | (37.73165355946, -122.447396729574) | |||
| 19367 | 19367 | 5108 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2680 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 4X4 | 6002307.8703 | 2096328.3771900001 | 37.7362490951029 | -122.43448280675501 | (37.7362490951029, -122.434482806755) | |||
| 19397 | 19397 | 16133 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 351 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999739.09066 | 2094636.71147 | 37.7314580252472 | -122.443242645952 | (37.7314580252472, -122.443242645952) | |||
| 19399 | 19399 | 5109 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2685 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002343.26695 | 2096337.55027 | 37.736276291512 | -122.434361081707 | (37.736276291512, -122.434361081707) | |||
| 19502 | 19502 | 27637 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300X Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x4 | 5994586.51749 | 2114934.4548299997 | 37.7868952379175 | -122.462527708701 | (37.7868952379175, -122.462527708701) | |||
| 19512 | 19512 | 16602 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 81 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002869.47017 | 2107840.0194599996 | 37.7678892025435 | -122.433363476353 | (37.7678892025435, -122.433363476353) | |||
| 19553 | 19553 | 12370 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1335 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004408.00965 | 2113459.2839 | 37.7834054897746 | -122.428442413333 | (37.7834054897746, -122.428442413333) | |||
| 19598 | 19598 | 16804 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 18 | 4x3 | 6001450.7704065 | 2113227.696464 | 37.7826018222756 | -122.438656679492 | (37.7826018222756, -122.438656679492) | |||
| 19664 | 19664 | 2052 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002043.06025 | 2095397.14145 | 37.733677100614706 | -122.43533177123899 | (37.7336771006147, -122.435331771239) | |||
| 19719 | 19719 | 5088 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2586 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6002230.0958 | 2096785.7567599998 | 37.737500538614896 | -122.43478440250401 | (37.7375005386149, -122.434784402504) | |||
| 19730 | 19730 | 12618 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 805 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5992909.32952 | 2114804.6184 | 37.7864420144633 | -122.46832089375499 | (37.7864420144633, -122.468320893755) | |||
| 19757 | 19757 | 22841 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 115 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/16/1993 12:00:00 AM | 30 | 3X3 | 5999601.25902 | 2098966.56578 | 37.743338920248206 | -122.444030149883 | (37.7433389202482, -122.444030149883) | ||
| 19763 | 19763 | 2054 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002076.85589 | 2095385.40046 | 37.7336467817625 | -122.435214090464 | (37.7336467817625, -122.435214090464) | |||
| 19765 | 19765 | 16171 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 427 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999238.94733 | 2094646.5725200002 | 37.731456569253396 | -122.444972438847 | (37.7314565692534, -122.444972438847) | |||
| 19844 | 19844 | 27797 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 3 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
| 19874 | 19874 | 16235 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 578 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998267.13673 | 2094738.2545599998 | 37.731652794120706 | -122.448338757752 | (37.7316527941207, -122.448338757752) | |||
| 19968 | 19968 | 2067 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 815 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6001798.14474 | 2095463.00063 | 37.7338440228646 | -122.436183226002 | (37.7338440228646, -122.436183226002) | |||
| 19976 | 19976 | 5077 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2530 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 85 | 3X3 | 6002265.741640001 | 2097118.1201900002 | 37.738415155434296 | -122.434684917677 | (37.7384151554343, -122.434684917677) | |||
| 20008 | 20008 | 16236 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 579 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998252.89851 | 2094662.9382599997 | 37.73144517935 | -122.448382560117 | (37.73144517935, -122.448382560117) | |||
| 20049 | 20049 | 16240 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 584 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998200.2405199995 | 2094739.92628 | 37.7316535594477 | -122.448570150599 | (37.7316535594477, -122.448570150599) | |||
| 20073 | 20073 | 12679 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1302 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4x4 | 5991386.800919999 | 2114799.39324 | 37.7863396121206 | -122.473588027094 | (37.7863396121206, -122.473588027094) | |||
| 20109 | 20109 | 4315 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 15X Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 0 | 6002224.89384 | 2095660.15305 | 37.734409594831206 | -122.434721921193 | (37.7344095948312, -122.434721921193) | |||
| 20179 | 20179 | 4352 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 925 Chenery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001454.126019999 | 2095943.2329900002 | 37.7351430782743 | -122.437406976652 | (37.7351430782743, -122.437406976652) | |||
| 20226 | 20226 | 5117 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2720 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2002 12:00:00 AM | 8 | 3X3 | 6002348.769730001 | 2096171.20815 | 37.735819866687 | -122.43433016751499 | (37.735819866687, -122.434330167515) | ||
| 20239 | 20239 | 16592 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 25 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002854.05233 | 2108135.77036 | 37.7687003874347 | -122.433437942027 | (37.7687003874347, -122.433437942027) | |||
| 20517 | 20517 | 5546 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 941 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/1991 12:00:00 AM | 20 | 3X3 | 6005114.255059999 | 2102860.25848 | 37.754343052711896 | -122.425244623562 | (37.7543430527119, -122.425244623562) | ||
| 20601 | 20601 | 12963 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 67 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001955.6227 | 2095631.91723 | 37.734316774895206 | -122.435650858813 | (37.7343167748952, -122.435650858813) | |||
| 20641 | 20641 | 15468 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2462 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6006922.7396 | 2104003.0379 | 37.7575828650076 | -122.41907146247699 | (37.7575828650076, -122.419071462477) | |||
| 20647 | 20647 | 2051 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002019.51441 | 2095402.45002 | 37.733690339522205 | -122.435413555604 | (37.7336903395222, -122.435413555604) |
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");