Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92656 | 92656 | 10376 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1255X Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 21x6 | 6000170.7774495995 | 2108835.6049214 | 37.7704693578958 | -122.44276941339199 | (37.7704693578958, -122.442769413392) | |||
| 92924 | 92924 | 14535 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 95505 | 95505 | 1429 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 75X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5 | 5995465.54596 | 2115556.4736099998 | 37.788653715516205 | -122.45953155962 | (37.7886537155162, -122.45953155962) | |||
| 96237 | 96237 | 11349 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1300X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | |||
| 98223 | 98223 | 10420 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1219X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999405.64403 | 2108687.20317 | 37.7700182355876 | -122.445405332062 | (37.7700182355876, -122.445405332062) | |||
| 99379 | 99379 | 1642 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 860 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5995719.79795 | 2110383.37965 | 37.7744643941763 | -122.45827731837299 | (37.7744643941763, -122.458277318373) | |||
| 100775 | 100775 | 107342 | Significant Tree 6 | Prunus laurocerasus :: English laurel 227 | 110 JULIAN AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 100 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | ||||
| 100856 | 100856 | 14543 | DPW Maintained 3 | Quillaja saponaria :: Chilean Soapbark 343 | 736 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999282.2180699995 | 2110225.9006 | 37.7742360610429 | -122.44594294328002 | (37.7742360610429, -122.44594294328) | |||
| 101124 | 101124 | 4763 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 22 Commer Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6016508.324428201 | 2094752.2608580003 | 37.732717262878396 | -122.385275716107 | (37.7327172628784, -122.385275716107) | |||
| 101187 | 101187 | 5485 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 101724 | 101724 | 8162 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1104 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 6002393.15082 | 2111291.80956 | 37.7773399284264 | -122.435257938115 | (37.7773399284264, -122.435257938115) | |||
| 101797 | 101797 | 1506 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 345 Arguello Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5995528.42515 | 2113903.2607299997 | 37.7841180535654 | -122.45919424672701 | (37.7841180535654, -122.459194246727) | |||
| 103017 | 103017 | 10275 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 222 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 6004852.2764800005 | 2109616.19972 | 37.772878454111705 | -122.42663166961701 | (37.7728784541117, -122.426631669617) | |||
| 104204 | 104204 | 14512 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
| 105690 | 105690 | 8166 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1124 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6002264.1606 | 2111273.81911 | 37.7772832052401 | -122.435702869129 | (37.7772832052401, -122.435702869129) | |||
| 106251 | 106251 | 13123 | DPW Maintained 3 | Persea borbonia :: False Avocado 244 | 1671 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6004412.3101699995 | 2119715.97512 | 37.8005850211999 | -122.428873735983 | (37.8005850211999, -122.428873735983) | |||
| 106368 | 106368 | 10362 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1126 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X4 | 6000713.44362 | 2108968.6618 | 37.7708656202791 | -122.440901879767 | (37.7708656202791, -122.440901879767) | |||
| 107403 | 107403 | 14539 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 110122 | 110122 | 14584 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1159 Masonic Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 100 | 4x4 | 5999323.48045 | 2108827.83023 | 37.7703996711999 | -122.445699648114 | (37.7703996711999, -122.445699648114) | |||
| 110986 | 110986 | 12738 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1630 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/2013 12:00:00 AM | 100 | 4x4 | 5990343.3046 | 2114764.5197400004 | 37.7861833727245 | -122.47719566934299 | (37.7861833727245, -122.477195669343) | ||
| 112742 | 112742 | 13155 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1871 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3x3 | 6003453.14477 | 2119540.71202 | 37.8000494585448 | -122.43218031398199 | (37.8000494585448, -122.432180313982) | |||
| 112962 | 112962 | 14532 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 114688 | 114688 | 1471 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 223 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5995498.41446 | 2114753.58122 | 37.7864510796736 | -122.459359672388 | (37.7864510796736, -122.459359672388) | |||
| 115010 | 115010 | 9648 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 420X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999128.38767 | 2111347.91542 | 37.77730804103229 | -122.446555809153 | (37.7773080410323, -122.446555809153) | |||
| 116039 | 116039 | 14534 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 116697 | 116697 | 12594 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 545 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5993765.6939900005 | 2114834.3012 | 37.786572939805204 | -122.465360268476 | (37.7865729398052, -122.465360268476) | |||
| 117123 | 117123 | 12636 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 901 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5992666.273990001 | 2114790.8903900003 | 37.7863902797856 | -122.46916079788099 | (37.7863902797856, -122.469160797881) | |||
| 117853 | 117853 | 3012 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2440 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6002689.255201099 | 2115491.3069188 | 37.7888874982911 | -122.434533962619 | (37.7888874982911, -122.434533962619) | |||
| 118001 | 118001 | 13409 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 364 Marietta Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 5 | 5999660.108164 | 2097381.7238333 | 37.738990678772396 | -122.443712833155 | (37.7389906787724, -122.443712833155) | |||
| 118523 | 118523 | 12662 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1044 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5992177.16633 | 2114831.4087900002 | 37.7864732581467 | -122.470855923323 | (37.7864732581467, -122.470855923323) | |||
| 118710 | 118710 | 105850 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 44 MENDOSA AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 100 | 6x15 | 5993395.1 | 2101192.7 | 37.7490953323683 | -122.465650972372 | (37.7490953323683, -122.465650972372) | |||
| 118883 | 118883 | 3331 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5330 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3x3 | 5991002.22066 | 2114113.47051 | 37.784433979884795 | -122.474868477503 | (37.7844339798848, -122.474868477503) | |||
| 119858 | 119858 | 12540 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 227 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5994726.9405 | 2114869.90451 | 37.786726085899794 | -122.462037198106 | (37.7867260858998, -122.462037198106) | |||
| 119891 | 119891 | 14538 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 120313 | 120313 | 14531 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 121745 | 121745 | 17198 | DPW Maintained 3 | Persea borbonia :: False Avocado 244 | 1675X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 6004367.95797 | 2119722.65234 | 37.8006008446769 | -122.42902768903099 | (37.8006008446769, -122.429027689031) | |||
| 123150 | 123150 | 14511 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
| 124314 | 124314 | 14533 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 128485 | 128485 | 12541 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 233 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5994692.63999 | 2114868.9307 | 37.7867214372248 | -122.462155798195 | (37.7867214372248, -122.462155798195) | |||
| 129442 | 129442 | 1529 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 451 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X4 | 5995566.01052 | 2113204.19125 | 37.7822007565611 | -122.45901358165001 | (37.7822007565611, -122.45901358165) | |||
| 138556 | 138556 | 12905 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6007848.98747 | 2111478.5775200003 | 37.7781610630449 | -122.41639760505 | (37.7781610630449, -122.41639760505) | |||
| 138620 | 138620 | 1526 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 440 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 5995608.48873 | 2113422.41383 | 37.782802379218296 | -122.458882431606 | (37.7828023792183, -122.458882431606) | |||
| 139352 | 139352 | 1510 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 369 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 5995536.869969999 | 2113765.1567 | 37.7837393424086 | -122.45915502719102 | (37.7837393424086, -122.459155027191) | |||
| 141688 | 141688 | 1614 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 757 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5995631.63313 | 2111076.8894 | 37.7763635225537 | -122.458632510412 | (37.7763635225537, -122.458632510412) | |||
| 143064 | 143064 | 12729 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5990435.001209999 | 2114760.85795 | 37.786178638116 | -122.47687815891899 | (37.786178638116, -122.476878158919) | |||
| 143942 | 143942 | 14544 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 740 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5x5 | 5999285.75973 | 2110200.8265 | 37.7741674161959 | -122.445928888319 | (37.7741674161959, -122.445928888319) | |||
| 145511 | 145511 | 19288 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 55X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5995247.58897 | 2114888.2393799997 | 37.7868063902482 | -122.46023721951599 | (37.7868063902482, -122.460237219516) | |||
| 145939 | 145939 | 10418 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1219X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999402.57096 | 2108712.61162 | 37.7700878253378 | -122.445417788957 | (37.7700878253378, -122.445417788957) | |||
| 10449 | 10449 | 98333 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 12X Canyon Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 99 | 6003235.70781 | 2086338.01389 | 37.708870401808205 | -122.43056224915199 | (37.7088704018082, -122.430562249152) | ||||
| 23770 | 23770 | 186402 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984820.6527 | 2102319.266 | 37.7516902715465 | -122.495384132242 | (37.7516902715465, -122.495384132242) | |||
| 24028 | 24028 | 186361 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984795.4735 | 2102590.7965 | 37.752434345234 | -122.495491228463 | (37.752434345234, -122.495491228463) | |||
| 25740 | 25740 | 187008 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984967.4388 | 2098043.05 | 37.739957538540295 | -122.49456132318899 | (37.7399575385403, -122.494561323189) | |||
| 77244 | 77244 | 185929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2000 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5985012.7201 | 2101493.4926 | 37.7494341681805 | -122.494659074897 | (37.7494341681805, -122.494659074897) | |||
| 106826 | 106826 | 107037 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1060 Clayton St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 99 | 5998985.0 | 2106259.0 | 37.7633269800406 | -122.446685590868 | (37.7633269800406, -122.446685590868) | ||||
| 128096 | 128096 | 108044 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD OFF RAMP | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 99 | 5985539.0 | 2095817.0 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | ||||
| 144456 | 144456 | 108046 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD ON RAMP | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 99 | 5985273.0 | 2095807.0 | 37.733835821368295 | -122.493340136435 | (37.7338358213683, -122.493340136435) | ||||
| 152584 | 152584 | 184346 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1251 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984686.7384 | 2106407.7493 | 37.7629082680796 | -122.49614883097901 | (37.7629082680796, -122.496148830979) | |||
| 153184 | 153184 | 185035 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5985023.8956 | 2096287.7176 | 37.7351411700064 | -122.49423677323401 | (37.7351411700064, -122.494236773234) | |||
| 155847 | 155847 | 186256 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984812.6153 | 2103003.1364 | 37.7535675206606 | -122.49546235883498 | (37.7535675206606, -122.495462358835) | |||
| 163766 | 163766 | 185074 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984997.7254 | 2096135.7209 | 37.7347222961152 | -122.49431605154301 | (37.7347222961152, -122.494316051543) | |||
| 167561 | 167561 | 186155 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1700 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984957.7478 | 2103324.5301 | 37.7544584761874 | -122.494984162752 | (37.7544584761874, -122.494984162752) | |||
| 171399 | 171399 | 184735 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984680.1977 | 2106291.6891 | 37.7625892162308 | -122.496162889393 | (37.7625892162308, -122.496162889393) | |||
| 8464 | 8464 | 3003 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2356 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 95 | 3X3 | 6003075.2981900005 | 2115553.9711 | 37.7890814648974 | -122.43320278729601 | (37.7890814648974, -122.433202787296) | |||
| 145251 | 145251 | 3057 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 95 | 3X3 | 6001337.5504485 | 2115252.7303216998 | 37.7881556043161 | -122.43919355883301 | (37.7881556043161, -122.439193558833) | |||
| 149618 | 149618 | 185710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 95 | Width 0ft | 5984848.6658 | 2100421.3565 | 37.7464807716884 | -122.495147319794 | (37.7464807716884, -122.495147319794) | |||
| 174141 | 174141 | 217519 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 125 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 94 | Width 10ft | 5998618.10798 | 2093180.61105 | 37.72739593057529 | -122.447013334218 | (37.7273959305753, -122.447013334218) | |||
| 2016 | 2016 | 13112 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1601 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6004666.807 | 2119779.6281 | 37.800774197193796 | -122.42799761136001 | (37.8007741971938, -122.42799761136) | |||
| 4255 | 4255 | 4659 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009780.1976 | 2119571.0943 | 37.800489575353104 | -122.410288343699 | (37.8004895753531, -122.410288343699) | |||
| 4302 | 4302 | 13161 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1895 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6003359.5664 | 2119590.4223 | 37.8001806439695 | -122.432507683341 | (37.8001806439695, -122.432507683341) | |||
| 4904 | 4904 | 23927 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1715 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6003460.7841 | 2114695.1886 | 37.7867453258178 | -122.43180771362199 | (37.7867453258178, -122.431807713622) | |||
| 5016 | 5016 | 8176 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001924.4605 | 2111208.7057 | 37.7770851190514 | -122.43687333680799 | (37.7770851190514, -122.436873336808) | |||
| 5145 | 5145 | 4664 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009692.467999999 | 2119649.5892 | 37.8007001848924 | -122.410597470914 | (37.8007001848924, -122.410597470914) | |||
| 5408 | 5408 | 8173 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001985.2987 | 2111217.5273 | 37.777112798515205 | -122.436663510376 | (37.7771127985152, -122.436663510376) | |||
| 5411 | 5411 | 8150 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002846.3106 | 2111341.485 | 37.7775020483312 | -122.433693863913 | (37.7775020483312, -122.433693863913) | |||
| 5508 | 5508 | 8174 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001968.8724 | 2111216.0063 | 37.777107688726204 | -122.436720225115 | (37.7771076887262, -122.436720225115) | |||
| 5576 | 5576 | 14497 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5999071.4256 | 2111558.1482 | 37.7778820323449 | -122.446767989356 | (37.7778820323449, -122.446767989356) | |||
| 6165 | 6165 | 14421 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 3X3 | 5998843.9665 | 2113055.4136 | 37.7819801389805 | -122.44766265742399 | (37.7819801389805, -122.447662657424) | |||
| 6232 | 6232 | 13105 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1530 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6004999.0901 | 2119899.25 | 37.8011214413621 | -122.426856296775 | (37.8011214413621, -122.426856296775) | ||
| 6364 | 6364 | 13127 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004182.8465 | 2119787.4466 | 37.8007682730329 | -122.42967287413 | (37.8007682730329, -122.42967287413) | |||
| 6528 | 6528 | 13104 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1530 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6005037.4004 | 2119906.2866 | 37.801142928088495 | -122.426724227861 | (37.8011429280885, -122.426724227861) | ||
| 6820 | 6820 | 8167 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1124 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6002248.7279 | 2111258.5930000003 | 37.7772405215532 | -122.435755166091 | (37.7772405215532, -122.435755166091) | |||
| 6844 | 6844 | 2941 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1938 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 6005079.693519999 | 2115832.49574 | 37.7899597239052 | -122.426287669836 | (37.7899597239052, -122.426287669836) | |||
| 6968 | 6968 | 4661 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009739.5649 | 2119605.2627 | 37.8005811155969 | -122.41043136381901 | (37.8005811155969, -122.410431363819) | |||
| 7409 | 7409 | 2866 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1370 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6007767.81348 | 2116206.02953 | 37.791136933759496 | -122.41701346161999 | (37.7911369337595, -122.41701346162) | |||
| 7626 | 7626 | 8175 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001945.7539 | 2111212.6602 | 37.777097187307604 | -122.436799959546 | (37.7770971873076, -122.436799959546) | |||
| 7726 | 7726 | 14482 | DPW Maintained 3 | Tristania conferta :: 79 | 281 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5998940.9244 | 2112049.1164 | 37.7792226484867 | -122.447254781672 | (37.7792226484867, -122.447254781672) | |||
| 8009 | 8009 | 8146 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002926.0085 | 2111351.5233 | 37.7775341328911 | -122.433418880148 | (37.7775341328911, -122.433418880148) | |||
| 8446 | 8446 | 11434 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6011450.63994 | 2118045.46213 | 37.7963940539012 | -122.404400461805 | (37.7963940539012, -122.404400461805) | |||
| 8946 | 8946 | 14523 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 625 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4x4 | 5999129.3058 | 2110654.1301 | 37.7754031370148 | -122.446502707181 | (37.7754031370148, -122.446502707181) | |||
| 16926 | 16926 | 24992 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 340 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004882.50848 | 2106257.6214799997 | 37.763658315014204 | -122.426287928865 | (37.7636583150142, -122.426287928865) | |||
| 17005 | 17005 | 25139 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005326.84877 | 2098252.91312 | 37.741704348480795 | -122.42418177058599 | (37.7417043484808, -122.424181770586) | |||
| 17024 | 17024 | 25136 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005320.97591 | 2098341.7574 | 37.741947963130706 | -122.424208394127 | (37.7419479631307, -122.424208394127) | |||
| 17056 | 17056 | 25058 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005092.48697 | 2102458.1018 | 37.753237594341996 | -122.425291287561 | (37.753237594342, -122.425291287561) | |||
| 17162 | 17162 | 25069 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005114.64614 | 2102050.12648 | 37.752118640770995 | -122.42518562892599 | (37.752118640771, -122.425185628926) | |||
| 17193 | 17193 | 5734 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1725 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 6005365.37115 | 2098326.9608400003 | 37.7419098417621 | -122.424053837524 | (37.7419098417621, -122.424053837524) | |||
| 17207 | 17207 | 25101 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1450X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005235.8244 | 2099843.7861200003 | 37.746067383302496 | -122.424609642834 | (37.7460673833025, -122.424609642834) | |||
| 17246 | 17246 | 10340 | DPW Maintained 3 | Tristania conferta :: 79 | 914 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X4 | 6001716.4806 | 2109101.7503 | 37.7712881236094 | -122.437441889428 | (37.7712881236094, -122.437441889428) | |||
| 17252 | 17252 | 24963 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004800.736959999 | 2107633.50365 | 37.7674315357679 | -122.42666873508999 | (37.7674315357679, -122.42666873509) | |||
| 17260 | 17260 | 24994 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004873.5625 | 2106448.79257 | 37.7641827195917 | -122.42633248217399 | (37.7641827195917, -122.426332482174) | |||
| 17276 | 17276 | 25090 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1250X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005182.99372 | 2100845.43458 | 37.7488146961375 | -122.424863573617 | (37.7488146961375, -122.424863573617) |
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");