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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 858 | 858 | 251395 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2101 26th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012226.0 | 2101445.0 | 37.750856267744496 | -122.400550836744 | (37.7508562677445, -122.400550836744) | |||||
| 999 | 999 | 251422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 480x De Long St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992963.0 | 2086633.0 | 37.709093057147996 | -122.466087289133 | (37.709093057148, -122.466087289133) | |||||
| 1524 | 1524 | 251544 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 863X Ocean Ave | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5997430.0 | 2091537.0 | 37.722815009603295 | -122.451002133856 | (37.7228150096033, -122.451002133856) | |||||
| 1556 | 1556 | 251583 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 75 Rice St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995352.0 | 2086409.0 | 37.7086155444167 | -122.45781440192499 | (37.7086155444167, -122.457814401925) | |||||
| 1620 | 1620 | 251543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard 17 | Tree 1 | Private 1 | |||||||||||
| 1635 | 1635 | 251542 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 Vista Ln | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 780127 | 5999350.0 | 2102347.0 | 37.752606437592604 | -122.445141915929 | (37.7526064375926, -122.445141915929) | ||||
| 1683 | 1683 | 251669 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 203 Addison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002642.0 | 2097220.0 | 37.7387162474086 | -122.433391278876 | (37.7387162474086, -122.433391278876) | |||||
| 1735 | 1735 | 251679 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 5 Dwight St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011495.0 | 2091622.0 | 37.7238435952898 | -122.40238810251101 | (37.7238435952898, -122.402388102511) | |||||
| 1769 | 1769 | 251689 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 355 Silver Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003702.0 | 2093526.0 | 37.728633439635104 | -122.429462937782 | (37.7286334396351, -122.429462937782) | |||||
| 1836 | 1836 | 251749 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 601 Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002875.0 | 2087693.0 | 37.7125704580966 | -122.43190559156 | (37.7125704580966, -122.43190559156) | |||||
| 1848 | 1848 | 251743 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 143 Cordova St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001773.0 | 2087479.0 | 37.7119203272299 | -122.43569914014999 | (37.7119203272299, -122.43569914015) | |||||
| 1946 | 1946 | 252821 | Undocumented 2 | Nyssa sylvatica :: Tupelo: Sour Gum 162 | 47 Miramar Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995289.0 | 2090229.0 | 37.719100747698704 | -122.45830844121001 | (37.7191007476987, -122.45830844121) | |||||
| 2126 | 2126 | 252903 | Undocumented 2 | Private shrub :: Private Shrub 64 | 215 Capistrano Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6001180.0 | 2093207.0 | 37.727614424830705 | -122.438158778943 | (37.7276144248307, -122.438158778943) | |||||
| 2198 | 2198 | 252932 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 66 Edgar Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997141.0 | 2091179.0 | 37.7218154760893 | -122.451975324711 | (37.7218154760893, -122.451975324711) | |||||
| 2199 | 2199 | 252934 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 78 Edgar Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997141.0 | 2091229.0 | 37.7219527643602 | -122.451978930217 | (37.7219527643602, -122.451978930217) | |||||
| 2201 | 2201 | 252933 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 72 Edgar Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997141.0 | 2091205.0 | 37.7218868659906 | -122.45197719957199 | (37.7218868659906, -122.451977199572) | |||||
| 2749 | 2749 | 253209 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1129 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001432.0 | 2087854.0 | 37.712930619101 | -122.43690455890899 | (37.712930619101, -122.436904558909) | |||||
| 2757 | 2757 | 253210 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 567 Mississippi St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014163.0 | 2104519.0 | 37.7594046471392 | -122.394067636073 | (37.7594046471392, -122.394067636073) | |||||
| 3851 | 3851 | 252871 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2557 Sutter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5999847.0 | 2113975.0 | 37.7845623594454 | -122.444258736096 | (37.7845623594454, -122.444258736096) | |||||
| 4032 | 4032 | 253155 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 546 Ellington Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:02:00 AM | 3 | 3x3 | 5997941.0 | 2087090.0 | 37.710633814489604 | -122.44891554828999 | (37.7106338144896, -122.44891554829) | |||
| 4222 | 4222 | 253622 | Undocumented 2 | Pittosporum spp :: Pittosporum spp 128 | 300x Naglee Ave | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 5181 | 5181 | 253819 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100x Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001057.0 | 2086858.0 | 37.71017450293179 | -122.43812937571998 | (37.7101745029318, -122.43812937572) | |||||
| 9710 | 9710 | 173649 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 2645 Lake St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987243.0 | 2114574.0 | 37.7854798983764 | -122.48790776340401 | (37.7854798983764, -122.487907763404) | |||||
| 9962 | 9962 | 173753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1140 Lawton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990653.0 | 2104548.0 | 37.7581495573033 | -122.475378025252 | (37.7581495573033, -122.475378025252) | |||||
| 10086 | 10086 | 88538 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1306 York St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x12 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367021999 | (37.7511299031436, -122.40816367022) | |||
| 10162 | 10162 | 173888 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Vasquez Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995783.0 | 2100209.0 | 37.7465317821399 | -122.457322486502 | (37.7465317821399, -122.457322486502) | |||||
| 10220 | 10220 | 173929 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 95 High St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999870.0 | 2100717.0 | 37.7481605193068 | -122.443226610241 | (37.7481605193068, -122.443226610241) | |||||
| 10258 | 10258 | 173932 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1109x Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003491.0 | 2094313.0 | 37.7307824159859 | -122.430248501015 | (37.7307824159859, -122.430248501015) | |||||
| 13297 | 13297 | 173883 | Undocumented 2 | Tree(s) :: 17 | 127 Holloway Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779596 | 5996444.0 | 2091166.0 | 37.721739833175 | -122.454383721237 | (37.721739833175, -122.454383721237) | ||
| 18642 | 18642 | 106966 | Undocumented 2 | Tree(s) :: 17 | 2391 47TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981720.8 | 2098834.4 | 37.7419398125124 | -122.505845312535 | (37.7419398125124, -122.505845312535) | ||||||
| 18892 | 18892 | 116488 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2149 LYON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999319.0 | 2116238.0 | 37.7907458271484 | -122.446248274058 | (37.7907458271484, -122.446248274058) | |||||
| 19238 | 19238 | 104509 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 DICHIERA CT | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5998620.0 | 2088043.0 | 37.7132893442667 | -122.446637305723 | (37.7132893442667, -122.446637305723) | |||||
| 19560 | 19560 | 103375 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 22 VANDEWATER ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x2.5 | Permit Number 770057 | 6009069.0 | 2121391.0 | 37.8054466905223 | -122.41287812458401 | (37.8054466905223, -122.412878124584) | ||||
| 19599 | 19599 | 106501 | Undocumented 2 | Tree(s) :: 17 | 1266 09TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5993358.0 | 2106830.8 | 37.764573953722 | -122.46618893715001 | (37.764573953722, -122.46618893715) | |||||
| 20384 | 20384 | 104821 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2173 15TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003063.7 | 2107068.1 | 37.7657807169148 | -122.43263651234301 | (37.7657807169148, -122.432636512343) | |||||
| 30135 | 30135 | 105475 | Undocumented 2 | Tree(s) :: 17 | 671 Waller St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2014 12:00:00 AM | 3x3 | 6002476.36422 | 2108834.33955 | 37.770597051265604 | -122.434794296397 | (37.7705970512656, -122.434794296397) | ||||
| 32417 | 32417 | 105247 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1301X COLE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x 5 | 5998246.0 | 2105821.0 | 37.7620821004846 | -122.44920998148999 | (37.7620821004846, -122.44920998149) | ||||
| 42981 | 42981 | 106868 | Undocumented 2 | Tree(s) :: 17 | 1956 GREAT HWY | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5981193.7 | 2101737.6 | 37.749880147789895 | -122.507883225183 | (37.7498801477899, -122.507883225183) | ||||||
| 47993 | 47993 | 105254 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 130 GONZALEZ DR | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 5990327.0 | 2090136.0 | 37.7185590045312 | -122.47545320091999 | (37.7185590045312, -122.47545320092) | |||||
| 58951 | 58951 | 107381 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 14 MOSS ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010161.8 | 2111354.5 | 37.7779501635385 | -122.408387955783 | (37.7779501635385, -122.408387955783) | ||||||
| 77398 | 77398 | 106965 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 63 BELLE AVE | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516001 | (37.7085786821221, -122.47025464516) | ||||||
| 77551 | 77551 | 116996 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 606x FULTON ST | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/29/2016 12:00:00 AM | 3 | 6004628.0 | 2111737.0 | 37.7786889706302 | -122.42755859051901 | (37.7786889706302, -122.427558590519) | ||||
| 77575 | 77575 | 107856 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981725.3 | 2096580.0 | 37.7357501162313 | -122.50566267275299 | (37.7357501162313, -122.505662672753) | |||||
| 77577 | 77577 | 107520 | Undocumented 2 | Tree(s) :: 17 | 2 CHURCH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004041.5 | 2108639.2 | 37.7701499806884 | -122.42936655700701 | (37.7701499806884, -122.429366557007) | ||||||
| 77894 | 77894 | 107651 | Undocumented 2 | Tree(s) :: 17 | 2908 23RD ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009361.7 | 2102802.2 | 37.7544226781239 | -122.41055171892201 | (37.7544226781239, -122.410551718922) | ||||||
| 77943 | 77943 | 115998 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 143 ASHBURY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998718.0 | 2110172.0 | 37.7740558300516 | -122.447890785953 | (37.7740558300516, -122.447890785953) | |||||
| 78453 | 78453 | 102458 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3267 20th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6008409.0 | 2104449.0 | 37.7588909590293 | -122.413962902008 | (37.7588909590293, -122.413962902008) | ||||
| 78574 | 78574 | 109626 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 117 JUDSON AVE | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x12 | 5999286.5 | 2093444.4 | 37.728158398345705 | -122.44472166307101 | (37.7281583983457, -122.444721663071) | |||||
| 78600 | 78600 | 97647 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1844 Noriega St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988207.7 | 2103154.5 | 37.754181336878204 | -122.483732655057 | (37.7541813368782, -122.483732655057) | |||||
| 78648 | 78648 | 112011 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 78970 | 78970 | 106970 | Undocumented 2 | Tree(s) :: 17 | 30 Piedmont St | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/11/2014 12:00:00 AM | Permit Number 772781 | 5999571.08265 | 2107127.2788400003 | 37.76574451836729 | -122.444720943629 | (37.7657445183673, -122.444720943629) | ||||
| 79312 | 79312 | 105448 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 453 WALLER ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003543.7 | 2108942.4 | 37.770954298248206 | -122.431110085749 | (37.7709542982482, -122.431110085749) | ||||
| 79961 | 79961 | 105904 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 700X BROTHERHOOD WAY | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 772491 | 5991178.9 | 2088065.4 | 37.7129229890255 | -122.47235769727399 | (37.7129229890255, -122.472357697274) | |||||
| 80132 | 80132 | 105261 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 619 GONZALEZ DR | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988914.8 | 2089258.8 | 37.716068469533205 | -122.48027037241002 | (37.7160684695332, -122.48027037241) | |||||
| 80283 | 80283 | 112014 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 80431 | 80431 | 106930 | Undocumented 2 | Tree(s) :: 17 | 560 Jersey St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | 3X3 | Permit Number 772858 | 6001503.6522699995 | 2101489.5191200003 | 37.750374691310604 | -122.43763282240499 | (37.7503746913106, -122.437632822405) | |||
| 80788 | 80788 | 107855 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981725.3 | 2096580.0 | 37.7357501162313 | -122.50566267275299 | (37.7357501162313, -122.505662672753) | |||||
| 81019 | 81019 | 112013 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 81502 | 81502 | 107995 | Undocumented 2 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 907 Minnesota St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | 6x11 | Permit Number 774103 | 6015290.10173 | 2104424.8547900002 | 37.7592087238569 | -122.39016295569598 | (37.7592087238569, -122.390162955696) | ||
| 81573 | 81573 | 110967 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2439 WASHINGTON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003043.0 | 2116458.0 | 37.7915618650441 | -122.43337916182101 | (37.7915618650441, -122.433379161821) | ||||
| 81746 | 81746 | 100074 | Undocumented 2 | Tree(s) :: 17 | 701 Noe St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003070.0 | 2104166.0 | 37.7578126071811 | -122.43240742658399 | (37.7578126071811, -122.432407426584) | ||||||
| 82492 | 82492 | 112009 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 82620 | 82620 | 102901 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 712 BATTERY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6012523.0 | 2118543.0 | 37.797820041376205 | -122.400724815577 | (37.7978200413762, -122.400724815577) | ||||
| 82811 | 82811 | 114380 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 437X SERRANO DR | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 48 | 5988907.0 | 2090368.0 | 37.7191136019865 | -122.48037847439699 | (37.7191136019865, -122.480378474397) | |||||
| 83446 | 83446 | 106682 | Undocumented 2 | Acer spp :: Maple 158 | 212 COLLINGWOOD ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002028.5 | 2104520.8 | 37.7587276896571 | -122.436034749265 | (37.7587276896571, -122.436034749265) | ||||||
| 83612 | 83612 | 105285 | Undocumented 2 | Persea americana :: Avocado 113 | 1055 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 5998993.5 | 2106394.4 | 37.763699240068796 | -122.44666593484399 | (37.7636992400688, -122.446665934844) | ||||
| 83863 | 83863 | 107650 | Undocumented 2 | Tree(s) :: 17 | 888 DUNCAN ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000841.2 | 2099697.3 | 37.74541599809321 | -122.439795143209 | (37.7454159980932, -122.439795143209) | ||||||
| 84128 | 84128 | 112015 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 84214 | 84214 | 121763 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 580 07th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011520.0 | 2109619.0 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | |||||
| 84244 | 84244 | 105061 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 163 10TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 4x3 | 5992696.3 | 2114396.0 | 37.785307754338 | -122.46902816717301 | (37.785307754338, -122.469028167173) | ||||
| 84395 | 84395 | 104895 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300 Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | ||||||
| 84654 | 84654 | 115910 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 867 HAYES ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003721.0 | 2110697.0 | 37.7757820445063 | -122.430622023399 | (37.7757820445063, -122.430622023399) | ||||||
| 84801 | 84801 | 113939 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3333 BUCHANAN ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003181.0 | 2119826.0 | 37.8008173514055 | -122.43314243340299 | (37.8008173514055, -122.433142433403) | |||||
| 85096 | 85096 | 107303 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2432 Diamond St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2014 12:00:00 AM | 2x3 | Permit Number 773619 | 6001987.23202 | 2097099.10599 | 37.738347131542895 | -122.43564650704599 | (37.7383471315429, -122.435646507046) | |||
| 85837 | 85837 | 100841 | Undocumented 2 | Tree(s) :: 17 | 139 Stillman St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014008.0 | 2112974.0 | 37.782611576233 | -122.39519596308998 | (37.782611576233, -122.39519596309) | |||||
| 86623 | 86623 | 107513 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2760 GREENWICH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999743.0 | 2118796.0 | 37.797793624169 | -122.444965226189 | (37.797793624169, -122.444965226189) | ||||||
| 87256 | 87256 | 106063 | Undocumented 2 | Tree(s) :: 17 | 274 MONTICELLO ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991733.9 | 2090351.1 | 37.7192310708749 | -122.470605827889 | (37.7192310708749, -122.470605827889) | |||||
| 87442 | 87442 | 102899 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 710 SANSOME ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6012187.0 | 2118224.0 | 37.796925398035995 | -122.401865040709 | (37.796925398036, -122.401865040709) | ||||
| 87731 | 87731 | 109029 | Undocumented 2 | Melaleuca leucadendron :: Weeping Tea Tree 497 | 923 CAPP ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007430.9 | 2101912.0 | 37.7518699557381 | -122.417165865844 | (37.7518699557381, -122.417165865844) | |||||
| 87795 | 87795 | 107402 | Undocumented 2 | Tree(s) :: 17 | 88 LUNDYS LN | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006885.0 | 2099070.0 | 37.744035741100504 | -122.418852127392 | (37.7440357411005, -122.418852127392) | ||||||
| 88272 | 88272 | 106800 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 443 Clementina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6011195.0 | 2112052.0 | 37.7799231406809 | -122.404862852803 | (37.7799231406809, -122.404862852803) | |||||
| 88593 | 88593 | 104720 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 63 SUSSEX ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002455.5 | 2096493.1 | 37.7367097651894 | -122.43398416151399 | (37.7367097651894, -122.433984161514) | ||||
| 89080 | 89080 | 106004 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 695X CAMPBELL AVE | unknown : Yard 19 | Tree 1 | Rec/Park 3 | 6009136.9 | 2088912.4 | 37.716271678506 | -122.41034847162202 | (37.716271678506, -122.410348471622) | ||||||
| 89122 | 89122 | 107161 | Undocumented 2 | Tree(s) :: 17 | 3772 20TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2014 12:00:00 AM | 3 | 5x5 | Permit Number 773829 | 6005193.3 | 2104336.4 | 37.7584006572295 | -122.42507628966001 | (37.7584006572295, -122.42507628966) | ||
| 90156 | 90156 | 104503 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 157 ALBION ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6005993.0 | 2106325.0 | 37.7639060282426 | -122.422451867395 | (37.7639060282426, -122.422451867395) | ||||
| 90159 | 90159 | 104807 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2069 GREEN ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003141.4 | 2118171.7 | 37.796272826569705 | -122.433161198258 | (37.7962728265697, -122.433161198258) | ||||||
| 90297 | 90297 | 107819 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 75X RALSTON ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 45 | Permit Number 775492 | 5992193.0 | 2088303.0 | 37.7136340221674 | -122.46886994586599 | (37.7136340221674, -122.468869945866) | ||||
| 90475 | 90475 | 112007 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 90732 | 90732 | 107620 | Undocumented 2 | Tree(s) :: 17 | 138 CORTLAND AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006430.5 | 2097564.1 | 37.7398752757691 | -122.420316827642 | (37.7398752757691, -122.420316827642) | ||||||
| 91444 | 91444 | 107078 | Undocumented 2 | Tree(s) :: 17 | 92 Homestead St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 07/25/2014 12:00:00 AM | 3x3.5 | Permit Number 773562 | 6000948.33481 | 2101213.46128 | 37.7495851129185 | -122.439533357227 | (37.7495851129185, -122.439533357227) | |||
| 91490 | 91490 | 113779 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 322 LISBON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002684.0 | 2091576.0 | 37.723221487961 | -122.432842971004 | (37.723221487961, -122.432842971004) | |||||
| 92476 | 92476 | 107359 | Undocumented 2 | Tree(s) :: 17 | 3636 Clay St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 771771 | 5997400.59946 | 2115444.59193 | 37.788457593521706 | -122.452828517416 | (37.7884575935217, -122.452828517416) | |||||
| 92684 | 92684 | 115379 | Undocumented 2 | Tree(s) :: 17 | 4004 20TH ST | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6003604.0 | 2104237.0 | 37.758037821948 | -122.43056569919399 | (37.758037821948, -122.430565699194) | |||||
| 92707 | 92707 | 112016 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/08/2015 12:00:00 AM | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | ||||
| 93550 | 93550 | 105290 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 330 11TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | 5992515.1 | 2113228.4 | 37.7820913739714 | -122.469570031425 | (37.7820913739714, -122.469570031425) | ||||
| 93980 | 93980 | 110202 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1039 PAGE ST | Front Yard : Cutout 8 | Tree 1 | Private 1 | 4x5 | 6001572.7 | 2109358.5 | 37.771984919077 | -122.43795762529301 | (37.771984919077, -122.437957625293) | |||||
| 93993 | 93993 | 112012 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 94146 | 94146 | 110101 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1348 Douglass St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 3x3 | Permit Number 774671 | 6001379.0 | 2099692.0 | 37.7454320431231 | -122.437935141467 | (37.7454320431231, -122.437935141467) | |||
| 94216 | 94216 | 100680 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 387 Beacon St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 7' wide public RoW | 6002378.0 | 2098199.0 | 37.7413893731095 | -122.434374040118 | (37.7413893731095, -122.434374040118) | |||||
| 94481 | 94481 | 107509 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 240 PIXLEY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002182.3 | 2118985.3 | 37.7984523071777 | -122.436538140501 | (37.7984523071777, -122.436538140501) |
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");