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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106 | 106 | 10645 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 906 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6003455.1435 | 2110726.9996 | 37.775849351151706 | -122.431543829861 | (37.7758493511517, -122.431543829861) | |||
| 148 | 148 | 175046 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 3ft | 5991566.54873 | 2087591.2585200001 | 37.7116435395983 | -122.47098334961399 | (37.7116435395983, -122.470983349614) | |||
| 189 | 189 | 138807 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002661.6347 | 2115086.2451 | 37.7877737339769 | -122.434600550462 | (37.7877737339769, -122.434600550462) | |||
| 221 | 221 | 138361 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002830.8674 | 2114461.7028 | 37.78606850519029 | -122.433970377911 | (37.7860685051903, -122.433970377911) | |||
| 222 | 222 | 251247 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 722X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6016169.292972799 | 2097000.9113916 | 37.738872842648796 | -122.38660458641 | (37.7388728426488, -122.38660458641) | ||||
| 239 | 239 | 251252 | DPW Maintained 3 | Prunus amygdalus :: Almond 63 | 321X Corbett Ave | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 10x10 | 5999565.0 | 2105069.0 | 37.7600926500434 | -122.444594033425 | (37.7600926500434, -122.444594033425) | ||||
| 242 | 242 | 194017 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 717 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 4ft | 6016141.23024 | 2096883.95841 | 37.7385501598741 | -122.386693461838 | (37.7385501598741, -122.386693461838) | |||
| 246 | 246 | 251253 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1350 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008544.9526 | 2110145.4696299997 | 37.774539777213995 | -122.413895673958 | (37.774539777214, -122.413895673958) | ||||
| 288 | 288 | 226558 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 320 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 7ft | 6004836.50691 | 2106380.98977 | 37.7639944545966 | -122.42645581878 | (37.7639944545966, -122.42645581878) | |||
| 309 | 309 | 20164 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1155X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1990 12:00:00 AM | 25 | 4X4 | 6002621.0 | 2112212.0 | 37.7798794773869 | -122.43453554599199 | (37.7798794773869, -122.434535545992) | ||
| 323 | 323 | 27392 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007139.14869 | 2120046.64789 | 37.801646927424706 | -122.419461214785 | (37.8016469274247, -122.419461214785) | |||
| 325 | 325 | 21670 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1776 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 4X4 | 6004121.8146 | 2114641.2436 | 37.786634655728605 | -122.429516856277 | (37.7866346557286, -122.429516856277) | |||
| 329 | 329 | 5267 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1245 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6001292.1098 | 2112753.8798 | 37.7812918154006 | -122.43917160516001 | (37.7812918154006, -122.43917160516) | |||
| 393 | 393 | 251277 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/26/2011 12:00:00 AM | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | ||
| 479 | 479 | 85531 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 101X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007317.968280001 | 2109362.68703 | 37.7723214572932 | -122.418084555959 | (37.7723214572932, -122.418084555959) | |||
| 481 | 481 | 14087 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007224.7884 | 2110663.6072 | 37.775888228839705 | -122.418499137854 | (37.7758882288397, -122.418499137854) | ||
| 499 | 499 | 248944 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1500x Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/10/2017 12:58:00 PM | 3 | 3x3 | 6016393.0 | 2097292.0 | 37.739684495027205 | -122.385851388433 | (37.7396844950272, -122.385851388433) | |
| 613 | 613 | 20019 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 663 | 663 | 237022 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 3 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:40:00 PM | 3 | Width 6ft | 6005770.133230001 | 2109412.50366 | 37.772371001847 | -122.423442207693 | (37.772371001847, -122.423442207693) | ||
| 696 | 696 | 5946 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1415 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003699.8521 | 2112803.046 | 37.7815635260957 | -122.43084551167601 | (37.7815635260957, -122.430845511676) | |||
| 723 | 723 | 230153 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 3ft | 6004293.15538 | 2105508.69845 | 37.7615686206128 | -122.428272938555 | (37.7615686206128, -122.428272938555) | |||
| 731 | 731 | 251375 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 746 | 746 | 251371 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 753 | 753 | 48 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 810 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6003376.13457 | 2107738.85817 | 37.767640169485105 | -122.43160376032499 | (37.7676401694851, -122.431603760325) | |||
| 772 | 772 | 221430 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:19:00 AM | 1 | Width 3ft | 6005430.67341 | 2108312.23866 | 37.7693307735195 | -122.424538153922 | (37.7693307735195, -122.424538153922) | ||
| 790 | 790 | 216490 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 800x Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | Width 3ft | 6001788.93125 | 2095501.57158 | 37.7339494063362 | -122.436217839104 | (37.7339494063362, -122.436217839104) | |||
| 791 | 791 | 191798 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2 Newhall St | 3 | : 4 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 6 | Width 3ft | Permit Number 774049 | 6018546.987380001 | 2097184.73725 | 37.7395089360924 | -122.378396294176 | (37.7395089360924, -122.378396294176) | |
| 796 | 796 | 212189 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002068.0773599995 | 2095471.6867 | 37.7338832054473 | -122.435250610137 | (37.7338832054473, -122.435250610137) | ||||
| 831 | 831 | 244348 | DPW Maintained 3 | Shrub :: Shrub 98 | 300 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2017 02:44:00 PM | 3 | Width 0ft | 6005622.9962 | 2110384.2841 | 37.7750309704349 | -122.424020287681 | (37.7750309704349, -122.424020287681) | ||
| 852 | 852 | 244300 | DPW Maintained 3 | Shrub :: Shrub 98 | 350 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/2017 11:46:00 AM | 3 | Width 0ft | 6005602.4578 | 2110538.44 | 37.775453085580295 | -122.424102299872 | (37.7754530855803, -122.424102299872) | ||
| 854 | 854 | 203901 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3794 19th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 12 | Width 3ft | 5990470.121669999 | 2090714.3108400002 | 37.720155198286 | -122.475000685058 | (37.720155198286, -122.475000685058) | |||
| 893 | 893 | 18095 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 3001 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5999540.0604 | 2114647.8242 | 37.7863922432736 | -122.44536903339501 | (37.7863922432736, -122.445369033395) | |||
| 965 | 965 | 130085 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 4ft | 6006282.409 | 2112253.58537 | 37.7802008260541 | -122.421872043567 | (37.7802008260541, -122.421872043567) | |||
| 968 | 968 | 129976 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 90x Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 4ft | 6009114.5006 | 2112815.4856 | 37.781902979173005 | -122.41211422669399 | (37.781902979173, -122.412114226694) | |||
| 988 | 988 | 199496 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 4ft | 6010015.0817 | 2112492.094 | 37.781065511609604 | -122.40897579419399 | (37.7810655116096, -122.408975794194) | |||
| 1018 | 1018 | 7366 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2360 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002774.54957 | 2116438.38146 | 37.79149276403471 | -122.434306592692 | (37.7914927640347, -122.434306592692) | |||
| 1062 | 1062 | 189665 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 5ft | 6015925.0907 | 2103156.8300799998 | 37.755762196378996 | -122.387878359099 | (37.755762196379, -122.387878359099) | |||
| 1074 | 1074 | 11442 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2200X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6005100.87554 | 2117226.15448 | 37.7937875569128 | -122.42631364855801 | (37.7937875569128, -122.426313648558) | |||
| 1084 | 1084 | 8287 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1601 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2017 12:00:00 AM | 6 | 3x3 | 6015799.31492 | 2097666.33838 | 37.7406794801837 | -122.387930230222 | (37.7406794801837, -122.387930230222) | ||
| 1105 | 1105 | 244414 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 261 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2017 04:17:00 PM | 3 | Width 0ft | 6005541.7456 | 2110219.4552 | 37.7745738026307 | -122.424289625835 | (37.7745738026307, -122.424289625835) | ||
| 1111 | 1111 | 3698 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 401X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 11:57:00 AM | 3 | 3X3 | 6016408.29218 | 2099351.9279400003 | 37.745341482920296 | -122.385942065688 | (37.7453414829203, -122.385942065688) | ||
| 1116 | 1116 | 8576 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 6 | 6001010.5429 | 2113459.32 | 37.7832127479531 | -122.440196288881 | (37.7832127479531, -122.440196288881) | |||
| 1175 | 1175 | 2161 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x100 | 6009743.36579 | 2090187.72527 | 37.71980743673429 | -122.408342124702 | (37.7198074367343, -122.408342124702) | |||
| 1194 | 1194 | 119795 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1226 | 1226 | 119830 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1234 | 1234 | 119748 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1336 | 1336 | 7171 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003475.9145 | 2111120.5411 | 37.7769310959731 | -122.431500078765 | (37.7769310959731, -122.431500078765) | ||
| 1355 | 1355 | 29680 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006072.343230001 | 2117086.04016 | 37.7934577026643 | -122.422942314134 | (37.7934577026643, -122.422942314134) | ||||
| 1383 | 1383 | 26841 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 779930 | 6006975.88726 | 2110943.04151 | 37.7766414730488 | -122.419379980819 | (37.7766414730488, -122.419379980819) | ||
| 1400 | 1400 | 235284 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4235 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/07/1990 12:00:00 AM | 11 | Width 3ft | 6001885.77275 | 2104671.54401 | 37.7591334867264 | -122.43653915428499 | (37.7591334867264, -122.436539154285) | ||
| 1448 | 1448 | 138093 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1890 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 0ft | 6003632.0 | 2114586.0 | 37.7864552256154 | -122.43120755079399 | (37.7864552256154, -122.431207550794) | |||
| 1461 | 1461 | 234073 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 17 | Width 3ft | 6011143.13167 | 2101723.71293 | 37.7515611015794 | -122.404315130536 | (37.7515611015794, -122.404315130536) | |||
| 1544 | 1544 | 196581 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 3 | : 4 | Tree 1 | DPW 2 | 10 | Width 3ft | 6010649.28152 | 2110608.88242 | 37.77593015789721 | -122.40664901875 | (37.7759301578972, -122.40664901875) | |||
| 1575 | 1575 | 246375 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2248 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6003217.3444 | 2106843.7794 | 37.765173499092995 | -122.43208906900499 | (37.765173499093, -122.432089069005) | |||
| 1578 | 1578 | 143015 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 968 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/2016 07:32:00 AM | 16 | Width 0ft | 6008678.8788 | 2120570.254 | 37.8031712224349 | -122.41417009265301 | (37.8031712224349, -122.414170092653) | ||
| 1585 | 1585 | 23896 | DPW Maintained 3 | Shrub :: Shrub 98 | 1581 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/2017 12:00:00 AM | 3 | 3x3 | 6003535.353102201 | 2114132.0136397 | 37.7852032161945 | -122.43150950273301 | (37.7852032161945, -122.431509502733) | ||
| 1743 | 1743 | 200855 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6008978.4093 | 2112218.7143 | 37.7802567505844 | -122.412542843301 | (37.7802567505844, -122.412542843301) | |||
| 1744 | 1744 | 9601 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6003062.4207 | 2112013.0769 | 37.7793583323419 | -122.432994261414 | (37.7793583323419, -122.432994261414) | |||
| 1745 | 1745 | 17972 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2515 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001748.1253 | 2114954.2725 | 37.7873594702652 | -122.437751658759 | (37.7873594702652, -122.437751658759) | |||
| 1762 | 1762 | 200860 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1131 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 0ft | 6008794.0112 | 2112059.0249 | 37.779807931141 | -122.413169468366 | (37.779807931141, -122.413169468366) | |||
| 1791 | 1791 | 251711 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 3 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1858 | 1858 | 12328 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1025 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004756.1585 | 2112422.6893 | 37.780578952523996 | -122.427164094387 | (37.780578952524, -122.427164094387) | |||
| 1902 | 1902 | 242360 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 388 Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | Width 3ft | 6006031.24378 | 2097876.97394 | 37.7407118512751 | -122.421719507764 | (37.7407118512751, -122.421719507764) | |||
| 1940 | 1940 | 139586 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3 Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6000731.3449 | 2112139.6442 | 37.779573356306 | -122.44106749101401 | (37.779573356306, -122.441067491014) | |||
| 1958 | 1958 | 23757 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003900.3372 | 2111922.0621 | 37.7791559204238 | -122.43008906318701 | (37.7791559204238, -122.430089063187) | |||
| 1990 | 1990 | 123760 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/14/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 778327 | 5994952.60534 | 2110751.23907 | 37.7754303235309 | -122.460957832773 | (37.7754303235309, -122.460957832773) | |
| 1997 | 1997 | 28906 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 354 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2014 12:00:00 AM | 5 | 3X3 | Permit Number 779305 | 6011835.68516 | 2111895.24936 | 37.779528530663704 | -122.402635398413 | (37.7795285306637, -122.402635398413) | |
| 2011 | 2011 | 224701 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 3ft | 6007503.74003 | 2102097.0446900004 | 37.7523821439458 | -122.416927083514 | (37.7523821439458, -122.416927083514) | |||
| 2047 | 2047 | 127862 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1898 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 3ft | 6007316.9194 | 2118776.88276 | 37.7981704829404 | -122.41875594393 | (37.7981704829404, -122.41875594393) | |||
| 2050 | 2050 | 252861 | DPW Maintained 3 | Tree(s) :: 17 | 988 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779759 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | |
| 2061 | 2061 | 252860 | DPW Maintained 3 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 167 | 1800X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002556.0 | 2114541.0 | 37.7862706325854 | -122.434927017215 | (37.7862706325854, -122.434927017215) | ||||
| 2063 | 2063 | 24316 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2004 12:00:00 AM | 3 | 3X3 | 6006540.648630001 | 2112546.28984 | 37.7810190813924 | -122.420999461083 | (37.7810190813924, -122.420999461083) | ||
| 2067 | 2067 | 252866 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1660 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000023.0 | 2106990.0 | 37.7653933634599 | -122.443148003218 | (37.7653933634599, -122.443148003218) | ||||
| 2217 | 2217 | 13060 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/26/2013 12:00:00 AM | 3 | 2X2 | 6009601.7098 | 2120500.5639 | 37.8030316618488 | -122.41097167179701 | (37.8030316618488, -122.410971671797) | ||
| 2240 | 2240 | 122755 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 693 Vermont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 6011274.22678 | 2105356.76628 | 37.7615439863765 | -122.40411744427601 | (37.7615439863765, -122.404117444276) | |||
| 2243 | 2243 | 20174 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1200X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6002845.6787 | 2112476.9688 | 37.7806197669525 | -122.433777227143 | (37.7806197669525, -122.433777227143) | ||
| 2249 | 2249 | 191500 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1196 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 3ft | 6016876.9140800005 | 2094649.78681 | 37.732456273623704 | -122.38399426453998 | (37.7324562736237, -122.38399426454) | |||
| 2251 | 2251 | 13985 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6008672.0 | 2111900.0 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | |||
| 2264 | 2264 | 14060 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1390 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/07/2017 12:00:00 AM | 3 | 4x4 | 6007755.5079 | 2111176.7984 | 37.777327192558104 | -122.41669960143999 | (37.7773271925581, -122.41669960144) | ||
| 2329 | 2329 | 6184 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005484.2824 | 2113445.6337 | 37.7834288547985 | -122.424717956993 | (37.7834288547985, -122.424717956993) | |||
| 2330 | 2330 | 6147 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 939 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6006318.99495 | 2113507.73043 | 37.7836464651567 | -122.42183458592 | (37.7836464651567, -122.42183458592) | |||
| 2342 | 2342 | 3126 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3200 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998843.08615 | 2114964.7899700003 | 37.787222737075 | -122.447803205161 | (37.787222737075, -122.447803205161) | |||
| 2426 | 2426 | 192160 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 3ft | Permit Number 779453 | 6007491.12658 | 2110012.65001 | 37.774115845790796 | -122.41753165726699 | (37.7741158457908, -122.417531657267) | ||
| 2495 | 2495 | 13230 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2301X Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6001287.1241 | 2119305.7914 | 37.7992813828917 | -122.439658706658 | (37.7992813828917, -122.439658706658) | |||
| 2501 | 2501 | 119761 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2513 | 2513 | 138183 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1865 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 2 | Width 0ft | 6003936.4381 | 2114774.6580000003 | 37.7869904804487 | -122.43016773530199 | (37.7869904804487, -122.430167735302) | ||
| 2531 | 2531 | 8603 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 5999987.1554 | 2113318.7057 | 37.782768340075606 | -122.443726682203 | (37.7827683400756, -122.443726682203) | |||
| 2559 | 2559 | 19580 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY4 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 8 | ||||||||
| 2574 | 2574 | 139639 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/1997 12:00:00 AM | 22 | Width 0ft | 6001669.0 | 2112367.0 | 37.7802509803634 | -122.437840034507 | (37.7802509803634, -122.437840034507) | ||
| 2613 | 2613 | 98090 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007144.43128 | 2115568.9527 | 37.7893525915946 | -122.419125139911 | (37.7893525915946, -122.419125139911) | ||
| 2655 | 2655 | 5870 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1010X Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005526.7803 | 2113108.4242 | 37.782505360766294 | -122.42454693631599 | (37.7825053607663, -122.424546936316) | |||
| 2745 | 2745 | 1164 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 2849X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5997509.5346800005 | 2087964.66518 | 37.7130107600005 | -122.450469794845 | (37.7130107600005, -122.450469794845) | ||
| 2843 | 2843 | 23527 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005732.6493 | 2119830.06962 | 37.800972938614294 | -122.424312938499 | (37.8009729386143, -122.424312938499) | |||
| 2844 | 2844 | 17858 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2121 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003631.9915 | 2115212.7417 | 37.7881760994608 | -122.43125233371799 | (37.7881760994608, -122.431252333718) | |||
| 2871 | 2871 | 16699 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900 Noriega St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/10/2017 12:00:00 AM | 3 | 8 | 5991131.39821 | 2103159.65216 | 37.7543652389679 | -122.473622260865 | (37.7543652389679, -122.473622260865) | ||
| 2880 | 2880 | 41129 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2049 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) |
| 2927 | 2927 | 13682 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6011577.51187 | 2114828.29204 | 37.787567561449706 | -122.403734970715 | (37.7875675614497, -122.403734970715) | |||
| 2961 | 2961 | 137577 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1095 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 17 | Width 0ft | 6002355.8984 | 2112213.5374 | 37.7798686462193 | -122.435452758685 | (37.7798686462193, -122.435452758685) | ||
| 3066 | 3066 | 13737 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 780155 | 6010751.43772 | 2114034.04518 | 37.7853405666668 | -122.40653704776001 | (37.7853405666668, -122.40653704776) | ||
| 3191 | 3191 | 21648 | DPW Maintained 3 | Tree(s) :: 17 | 1660 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X2 | 6004632.9541 | 2114713.0403 | 37.7868607185832 | -122.427753554263 | (37.7868607185832, -122.427753554263) |
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");