trees
27,746 rows where qCaretaker_id = 1 sorted by Supervisor Districts descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts ▲ | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 98 | 261380 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 298x Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008523 | 2113477 | 37.7836861327236 | -122.414207368753 | (37.7836861327236, -122.414207368753) | 7 | 10 | 9 | 28852 | 36 | ||||
| 371 | 251215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | ||||
| 424 | 13666 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 653 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/21/2014 12:00:00 AM | 3 | 4x4 | 6011846.3206496 | 2114969.3004876 | 37.7879697501429 | -122.402814861202 | (37.7879697501429, -122.402814861202) | 12 | 2 | 9 | 28855 | 6 | ||
| 448 | 17338 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 175X Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/18/1993 12:00:00 AM | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | ||
| 535 | 50166 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 159 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46878 | 6010492.5895 | 2111415.08321 | 37.7781350293519 | -122.407247904281 | (37.7781350293519, -122.407247904281) | 14 | 2 | 9 | 28853 | 34 | |
| 1107 | 258138 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6014765.94263 | 2115143.61778 | 37.7886109721909 | -122.39272561329 | (37.7886109721909, -122.39272561329) | 6 | 2 | 9 | 28855 | 6 | |||
| 1150 | 97170 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 289 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6009625.74334 | 2110365.68554 | 37.7752050776892 | -122.41017254363 | (37.7752050776892, -122.41017254363) | 8 | 2 | 9 | 28853 | 34 | |||
| 1229 | 264907 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 1232 | 264776 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 1263 | 15197 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1110 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/1995 12:00:00 AM | 12 | 3X3 | 6009340.5816959 | 2111773.3907707 | 37.7790543166113 | -122.411258449881 | (37.7790543166113, -122.411258449881) | 8 | 2 | 9 | 28853 | 34 | ||
| 1449 | 13614 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 555 Market St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4X4 | 6012641.55561 | 2115729.4469 | 37.7901013041673 | -122.400116879409 | (37.7901013041673, -122.400116879409) | 12 | 2 | 9 | 28855 | 6 | |||
| 1453 | 23301 | DPW Maintained 1 | Eucalyptus melliodora :: Yellow Box 188 | 950X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006575.9602707 | 2113798.8129121 | 37.7844601942992 | -122.420966256023 | (37.7844601942992, -122.420966256023) | 7 | 9 | 9 | 28858 | 36 | |||
| 1524 | 28207 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | ||||
| 1534 | 28217 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | ||||
| 1683 | 85790 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1125 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010146.2096 | 2110708.8868 | 37.776176587646 | -122.408396338404 | (37.776176587646, -122.408396338404) | 8 | 2 | 9 | 28853 | 34 | ||
| 1735 | 28503 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 270 06th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/2013 12:00:00 AM | 3 | 3x3 | 6010824.2979387 | 2111653.7211901 | 37.7788088323978 | -122.406117215604 | (37.7788088323978, -122.406117215604) | 14 | 2 | 9 | 28853 | 34 | ||
| 1830 | 85780 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009172.9261 | 2109780.9319 | 37.7735740897245 | -122.411697620327 | (37.7735740897245, -122.411697620327) | 8 | 2 | 9 | 28853 | 34 | ||
| 1880 | 261557 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 900 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011458 | 2112074 | 37.7799982447009 | -122.403954562266 | (37.7799982447009, -122.403954562266) | 14 | 2 | 9 | 28853 | 34 | ||||
| 1888 | 29108 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 765 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2018 12:59:00 PM | 3 | 3x3 | 6007194.65596 | 2113631.10211 | 37.7840345567841 | -122.418813878265 | (37.7840345567841, -122.418813878265) | 7 | 9 | 9 | 28858 | 36 | ||
| 1970 | 260506 | DPW Maintained 1 | Tree(s) :: 17 | 289 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6009625.74334 | 2110365.68554 | 37.7752050776892 | -122.41017254363 | (37.7752050776892, -122.41017254363) | 8 | 2 | 9 | 28853 | 34 | ||||
| 2082 | 195047 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 06th St | 2 | : | Tree | DPW 1 | 02/25/2002 12:00:00 AM | 3 | Width 3ft | Permit Number 42039 | 6011214.59355 | 2111232.18316 | 37.7776732094966 | -122.404737337955 | (37.7776732094966, -122.404737337955) | 14 | 2 | 9 | 28853 | 34 | |
| 2151 | 258135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 988 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |||
| 2191 | 258156 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1180 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009302.702 | 2110851.89805 | 37.7765219905974 | -122.411324376274 | (37.7765219905974, -122.411324376274) | 8 | 2 | 9 | 28853 | 34 | |||
| 2207 | 26390 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1615X Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6007069.43005 | 2109322.62762 | 37.7721974718223 | -122.418941432593 | (37.7721974718223, -122.418941432593) | 8 | 2 | 9 | 28853 | 19 | |||
| 2227 | 28919 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 230 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6009994.1526974 | 2111207.6693813 | 37.7775376115192 | -122.408957547154 | (37.7775376115192, -122.408957547154) | 8 | 2 | 9 | 28853 | 34 | ||
| 2258 | 264781 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 90x Guy Pl | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 2444 | 187616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/03/2013 12:00:00 AM | 3x3 | 6013035 | 2114021 | 37.78543223702 | -122.398635644163 | (37.78543223702, -122.398635644163) | 6 | 2 | 9 | 28855 | 6 | ||
| 2468 | 14078 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007428.1196287 | 2110750.9276325 | 37.7761394345379 | -122.417801951992 | (37.7761394345379, -122.417801951992) | 8 | 2 | 9 | 28853 | 34 | |||
| 2469 | 260495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
| 2668 | 85700 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 918 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010976.81813 | 2112473.48761 | 37.7810682491478 | -122.405647340366 | (37.7810682491478, -122.405647340366) | 14 | 2 | 9 | 28853 | 34 | ||
| 2888 | 13930 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1095 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/1994 12:00:00 AM | 12 | 4X4 | 6009061.9861 | 2112312.9703 | 37.7805202452284 | -122.412260375327 | (37.7805202452284, -122.412260375327) | 14 | 2 | 9 | 28853 | 34 | ||
| 2913 | 264905 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 2925 | 28992 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 447 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009491 | 2108895 | 37.7711593648098 | -122.410534778589 | (37.7711593648098, -122.410534778589) | 8 | 2 | 9 | 28853 | 34 | ||
| 2955 | 13425 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 25 | 4x4 | 6014152.78687 | 2117194.52143 | 37.7942082021958 | -122.394990759026 | (37.7942082021958, -122.394990759026) | 12 | 2 | 9 | 28855 | 6 | ||
| 3022 | 264768 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 3248 | 85701 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 926 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010962.65697 | 2112458.52521 | 37.781026374014 | -122.405695276931 | (37.781026374014, -122.405695276931) | 14 | 2 | 9 | 28853 | 34 | ||
| 3271 | 260494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
| 3630 | 258965 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 3979 | 13887 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1028 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6009423.70824 | 2112763.96692 | 37.7817788655291 | -122.411040866943 | (37.7817788655291, -122.411040866943) | 14 | 2 | 9 | 28852 | 36 | |||
| 3980 | 29003 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 225X 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008536.6481126 | 2109865.7521973 | 37.7737712727069 | -122.413904609778 | (37.7737712727069, -122.413904609778) | 8 | 2 | 9 | 28853 | 34 | ||
| 4232 | 264908 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 4245 | 28231 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 4280 | 264767 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 90x Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 4323 | 264887 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
| 4382 | 264774 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 4421 | 15304 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1650 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/10/2019 03:08:00 PM | 3 | 3X3 | 6006931.2074 | 2109169.6745 | 37.7717697147956 | -122.419408704778 | (37.7717697147956, -122.419408704778) | 8 | 2 | 9 | 28853 | 19 | ||
| 4575 | 29055 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 400X 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008920.1536798 | 2108682.7358637 | 37.7705445174102 | -122.412494357701 | (37.7705445174102, -122.412494357701) | 8 | 2 | 9 | 28853 | 19 | ||
| 5064 | 258966 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 5191 | 13827 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 964 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6009845.6649 | 2113195.3529 | 37.7829870022194 | -122.409611544992 | (37.7829870022194, -122.409611544992) | 14 | 2 | 9 | 28852 | 36 | |||
| 5393 | 28504 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 270 06th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010824.2979387 | 2111653.7211901 | 37.7788088323978 | -122.406117215604 | (37.7788088323978, -122.406117215604) | 14 | 2 | 9 | 28853 | 34 | |||
| 5424 | 113149 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6010826.0688 | 2111360.9298 | 37.7780049945656 | -122.406090456701 | (37.7780049945656, -122.406090456701) | 14 | 2 | 9 | 28853 | 34 | |||
| 5493 | 264903 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 6078 | 255898 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 255 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 11/12/2019 06:17:00 AM | 3 | 3x3 | 6007944 | 2113354 | 37.7833158649371 | -122.416201780533 | (37.7833158649371, -122.416201780533) | 7 | 10 | 9 | 28852 | 36 | |
| 6270 | 258961 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 6327 | 28873 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 240 02nd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6013332.85473 | 2114278.45679 | 37.7861557436438 | -122.397623212266 | (37.7861557436438, -122.397623212266) | 6 | 2 | 9 | 28855 | 6 | ||
| 6607 | 28204 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6014268.5967781 | 2110706.0699128 | 37.7763988431969 | -122.394135578218 | (37.7763988431969, -122.394135578218) | 6 | 2 | 9 | 28856 | 20 | ||||
| 6666 | 23307 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/01/2014 12:00:00 AM | 2 | 3x3 | 6006542.62329 | 2114014.00443 | 37.7850491782092 | -122.421096875635 | (37.7850491782092, -122.421096875635) | 13 | 9 | 9 | 28858 | 36 | ||
| 6732 | 195683 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 102x King St | 12 | Median : Yard | Tree | DPW 1 | 10 | Width 10ft | 6015319.49651 | 2111685.54707 | 37.7791466227626 | -122.390568648644 | (37.7791466227626, -122.390568648644) | 6 | 2 | 9 | 28856 | 20 | |||
| 6742 | 264909 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 7181 | 14058 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1390 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6007799.3288 | 2111218.6717 | 37.7774446311696 | -122.416550977219 | (37.7774446311696, -122.416550977219) | 7 | 2 | 9 | 28852 | 36 | |||
| 7189 | 90402 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100X McCoppin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006023.914808 | 2109144.349895 | 37.7716490364194 | -122.422545294145 | (37.7716490364194, -122.422545294145) | 8 | 2 | 9 | 28853 | 19 | ||
| 7212 | 195766 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 700x King St | 2 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6014104.38527 | 2110532.00713 | 37.7759117775522 | -122.394691443959 | (37.7759117775522, -122.394691443959) | 6 | 2 | 9 | 310 | 20 | |||
| 7309 | 14032 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1245 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2012 12:00:00 AM | 3 | 4X4 | 6008153.5614441 | 2111445.1787375 | 37.7780864807987 | -122.415341604846 | (37.7780864807987, -122.415341604846) | 8 | 2 | 9 | 28853 | 34 | ||
| 7342 | 26844 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | Permit Number 775213 | 6006969.72882 | 2110998.7322 | 37.7767940394414 | -122.419405236481 | (37.7767940394414, -122.419405236481) | 7 | 9 | 9 | 28852 | 36 | ||
| 7382 | 85829 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
| 7560 | 13858 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 995 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/1990 12:00:00 AM | 35 | 4X4 | 6009732.8033 | 2112958.8474 | 37.7823312894321 | -122.409985299939 | (37.7823312894321, -122.409985299939) | 14 | 2 | 9 | 28853 | 34 | ||
| 7612 | 15318 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006784.5559 | 2108731.4352 | 37.7705581530288 | -122.419884880101 | (37.7705581530288, -122.419884880101) | 8 | 2 | 9 | 28853 | 19 | |||
| 7713 | 264772 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 7731 | 261556 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 900 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011458 | 2112074 | 37.7799982447009 | -122.403954562266 | (37.7799982447009, -122.403954562266) | 14 | 2 | 9 | 28853 | 34 | ||||
| 7810 | 192162 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1500 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 29 | Width 5ft | Permit Number 779453 | 6007414.0762 | 2109937.75552 | 37.7739058675964 | -122.417792878858 | (37.7739058675964, -122.417792878858) | 8 | 2 | 9 | 28853 | 19 | ||
| 7860 | 13507 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 333 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6013261.04703 | 2116332.20959 | 37.7917908704129 | -122.398015777109 | (37.7917908704129, -122.398015777109) | 12 | 2 | 9 | 28855 | 6 | |||
| 7972 | 264777 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 8039 | 260496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
| 8080 | 75081 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 172 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 8x9 | 6010488.28034 | 2111342.37314 | 37.7779351433246 | -122.407257684389 | (37.7779351433246, -122.407257684389) | 14 | 2 | 9 | 28853 | 34 | |||
| 8128 | 90393 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | 6007146.175112 | 2109626.370927 | 37.7730357998282 | -122.418697508419 | (37.7730357998282, -122.418697508419) | 8 | 2 | 9 | 28853 | 19 | ||
| 8132 | 19305 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 345 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/1990 12:00:00 AM | 20 | 3X3 | 6010549.63293 | 2110708.85281 | 37.7761990776491 | -122.407000778664 | (37.7761990776491, -122.407000778664) | 14 | 2 | 9 | 28853 | 34 | ||
| 8178 | 13824 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 964 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6009889.5706 | 2113199.7435 | 37.7830015179357 | -122.409459958667 | (37.7830015179357, -122.409459958667) | 14 | 2 | 9 | 28852 | 36 | |||
| 8205 | 200857 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1117 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | Width 0ft | Permit Number 780155 | 6008905.5117 | 2112149.5313 | 37.7800626991558 | -122.412790138104 | (37.7800626991558, -122.412790138104) | 8 | 2 | 9 | 28853 | 34 | ||
| 8263 | 28866 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 75 01st St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6013193.25193 | 2115823.02821 | 37.7903890018067 | -122.398214610023 | (37.7903890018067, -122.398214610023) | 12 | 2 | 9 | 28855 | 6 | ||
| 8419 | 85699 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 918 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010993.40445 | 2112488.15858 | 37.7811094596721 | -122.405590993329 | (37.7811094596721, -122.405590993329) | 14 | 2 | 9 | 28853 | 34 | ||
| 8442 | 43966 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 08/24/2000 12:00:00 AM | 9 | Permit Number 43534 | 6006884.39072 | 2112892.55093 | 37.7819892007742 | -122.419834861512 | (37.7819892007742, -122.419834861512) | 7 | 9 | 9 | 28852 | 36 | |
| 8476 | 86613 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1060 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010229.12599 | 2109123.99636 | 37.7718294894697 | -122.407997713136 | (37.7718294894697, -122.407997713136) | 14 | 2 | 9 | 28853 | 34 | ||
| 8487 | 261462 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101x King St | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6015505 | 2111943 | 37.7798638201711 | -122.3899448996 | (37.7798638201711, -122.3899448996) | 6 | 2 | 9 | 28856 | 20 | ||||
| 8744 | 261463 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101x King St | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6015505 | 2111943 | 37.7798638201711 | -122.3899448996 | (37.7798638201711, -122.3899448996) | 6 | 2 | 9 | 28856 | 20 | ||||
| 8897 | 191138 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 770 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 3ft | 6011596.13889 | 2113930.29234 | 37.7851029064102 | -122.403607318248 | (37.7851029064102, -122.403607318248) | 12 | 2 | 9 | 28853 | 6 | |||
| 8911 | 87411 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 898X Ellis St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006570.640875 | 2113589.260791 | 37.7838845156579 | -122.420969775985 | (37.7838845156579, -122.420969775985) | 7 | 9 | 9 | 28858 | 36 | |||
| 8917 | 261560 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 900 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011458 | 2112074 | 37.7799982447009 | -122.403954562266 | (37.7799982447009, -122.403954562266) | 14 | 2 | 9 | 28853 | 34 | ||||
| 8972 | 23214 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006727.4886023 | 2112541.6876005 | 37.7810169750537 | -122.42035276087 | (37.7810169750537, -122.42035276087) | 7 | 9 | 9 | 28852 | 36 | ||
| 9425 | 264770 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 9558 | 13935 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1140X Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4x4 | 6008690.2869843 | 2112068.9420038 | 37.7798293375501 | -122.413528998881 | (37.7798293375501, -122.413528998881) | 7 | 2 | 9 | 28852 | 36 | |||
| 9559 | 90383 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
| 9626 | 258963 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 9664 | 258964 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 9676 | 194361 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 28 | Width 8ft | 6016114.70966 | 2114269.45463 | 37.7862855364823 | -122.38799801482 | (37.7862855364823, -122.38799801482) | 6 | 2 | 9 | 28856 | 6 | |||
| 9755 | 194362 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6016123.07303 | 2114362.83881 | 37.786542411639 | -122.387975598289 | (37.786542411639, -122.387975598289) | 6 | 2 | 9 | 28856 | 6 | |||
| 9871 | 91779 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1184 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6010158.993686 | 2109919.902048 | 37.7740109351691 | -122.408296453122 | (37.7740109351691, -122.408296453122) | 8 | 2 | 9 | 28853 | 34 | ||
| 9875 | 23182 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 3 | 3X3 | 6006776.0786915 | 2112192.9314348 | 37.7800621132124 | -122.42015990463 | (37.7800621132124, -122.42015990463) | 7 | 9 | 9 | 28852 | 36 | ||
| 9895 | 130101 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 151 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2016 01:58:00 PM | 2 | Width 4ft | 6008550.81103 | 2113028.31881 | 37.7824557240915 | -122.414079400045 | (37.7824557240915, -122.414079400045) | 7 | 10 | 9 | 28852 | 36 | ||
| 10110 | 13676 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011822.15902 | 2114934.32739 | 37.7878723731553 | -122.402895995877 | (37.7878723731553, -122.402895995877) | 12 | 2 | 9 | 28855 | 6 | |
| 10154 | 258967 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );