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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128888 | 128888 | 110631 | Undocumented 2 | Tree(s) :: 17 | 1001X Mandalay Ln | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 5991736.200759999 | 2101819.33429 | 37.7507200830769 | -122.47143306251002 | (37.7507200830769, -122.47143306251) | ||||||
| 128889 | 128889 | 104678 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3531-3535 16TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003359.0 | 2106442.3 | 37.7640791638998 | -122.431570451949 | (37.7640791638998, -122.431570451949) | ||||
| 129188 | 129188 | 105003 | Undocumented 2 | Shrub :: Shrub 98 | 607 CONGO ST | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 6000094.1 | 2095817.0 | 37.73471905904071 | -122.44210000591002 | (37.7347190590407, -122.44210000591) | ||||||
| 129226 | 129226 | 107382 | 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) | ||||||
| 129264 | 129264 | 103265 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2365 UNION ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001713.0 | 2118319.0 | 37.796596142729896 | -122.43811430510799 | (37.7965961427299, -122.438114305108) | |||||
| 129412 | 129412 | 104753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2328 12TH AVE | Front Yard : Cutout 8 | Tree 1 | Private 1 | 22 | Permit Number 770921 | 5992676.8 | 2099585.2 | 37.7446400909628 | -122.468017927356 | (37.7446400909628, -122.468017927356) | ||||
| 129474 | 129474 | 105806 | Undocumented 2 | Tree(s) :: 17 | 1248X ANZA ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x3 | 5994834.0 | 2112130.0 | 37.779209208537296 | -122.46146809167601 | (37.7792092085373, -122.461468091676) | |||||
| 138278 | 138278 | 104894 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 235 Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | ||||||
| 138336 | 138336 | 106366 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 9 SEAL ROCK DR | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981833.1 | 2112945.4 | 37.7806911884837 | -122.506503269885 | (37.7806911884837, -122.506503269885) | ||||||
| 138482 | 138482 | 104990 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1931 21ST AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5989677.9 | 2102204.3 | 37.751657810714896 | -122.478578913714 | (37.7516578107149, -122.478578913714) | ||||
| 139222 | 139222 | 111092 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 801 GONZALEZ DR | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 2 | Permit Number 775593 | 5988333.0 | 2089769.0 | 37.717435525652704 | -122.48231868452 | (37.7174355256527, -122.48231868452) | |||
| 139317 | 139317 | 111997 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 69 Divisadero St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2015 12:00:00 AM | 3 | 6x3 | Permit Number 775676 | 6001902.9 | 2108046.4 | 37.7684009894266 | -122.436721500778 | (37.7684009894266, -122.436721500778) | ||
| 139871 | 139871 | 105221 | Undocumented 2 | Tree(s) :: 17 | 1587 41ST AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | 3x3 | Permit Number 771982 | 5983395.5 | 2104359.9 | 37.7572097335405 | -122.50046328346399 | (37.7572097335405, -122.500463283464) | |||
| 140625 | 140625 | 104744 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 15 WAVERLY PL | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010745.5 | 2116998.1 | 37.793478820697295 | -122.406766557506 | (37.7934788206973, -122.406766557506) | ||||
| 140828 | 140828 | 106677 | Undocumented 2 | Tree(s) :: 17 | 2862 21ST ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009011.0 | 2103999.0 | 37.7576891530245 | -122.41184909914 | (37.7576891530245, -122.41184909914) | ||||||
| 141026 | 141026 | 107031 | Undocumented 2 | Tree(s) :: 17 | 4022 19TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x4 | 6002868.3 | 2104782.6 | 37.7594942034983 | -122.43314904402901 | (37.7594942034983, -122.433149044029) | |||||
| 141350 | 141350 | 107857 | Undocumented 2 | Tree(s) :: 17 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 774528 | 5981725.3 | 2096580.0 | 37.7357501162313 | -122.50566267275299 | (37.7357501162313, -122.505662672753) | ||||
| 141839 | 141839 | 115853 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401x KANSAS ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011620.0 | 2106285.0 | 37.764112022223394 | -122.402986839965 | (37.7641120222234, -122.402986839965) | |||||
| 142086 | 142086 | 110077 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4099x ALEMANY BLVD | Median : Cutout 11 | Tree 1 | Private 1 | 48 | 5991599.0 | 2086829.0 | 37.7095524384103 | -122.470815701049 | (37.7095524384103, -122.470815701049) | |||||
| 142221 | 142221 | 104943 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 830X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | ||||||
| 142250 | 142250 | 106332 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1160 MISSION ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2014 12:00:00 AM | 3x3 | Permit Number 778325 | 6009057.1 | 2111529.8 | 37.7783695713182 | -122.412221910581 | (37.7783695713182, -122.412221910581) | |||
| 142442 | 142442 | 104893 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 233 Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | ||||||
| 142992 | 142992 | 97797 | Undocumented 2 | Tree(s) :: 17 | 400 Sussex St | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/14/2011 12:00:00 AM | 17 | Permit Number 768175 | 6000884.7 | 2096726.7 | 37.7372619068373 | -122.43943182637501 | (37.7372619068373, -122.439431826375) | |||
| 143207 | 143207 | 98706 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 353 UPPER TER | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 5999086.1 | 2105914.9 | 37.7623879420949 | -122.446311165521 | (37.7623879420949, -122.446311165521) | ||||||
| 143438 | 143438 | 112252 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5301x DIAMOND HEIGHTS BLVD | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 3x3 | 6001927.0 | 2098732.0 | 37.7428272563398 | -122.43597156823799 | (37.7428272563398, -122.435971568238) | ||||
| 143587 | 143587 | 104820 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 CASTRO ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002463.2 | 2104094.7 | 37.757582407620504 | -122.434500892974 | (37.7575824076205, -122.434500892974) | ||||
| 144263 | 144263 | 100075 | Undocumented 2 | Tree(s) :: 17 | 707-709 Noe St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003067.0 | 2104139.0 | 37.757738301523105 | -122.43241587342699 | (37.7577383015231, -122.432415873427) | |||||
| 144827 | 144827 | 104940 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 111X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | ||||||
| 145559 | 145559 | 98736 | Undocumented 2 | Tree(s) :: 17 | 89 Paradise Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6000827.4 | 2096045.9 | 37.73538932786521 | -122.439581147409 | (37.7353893278652, -122.439581147409) | ||||||
| 145609 | 145609 | 107703 | Undocumented 2 | Tree(s) :: 17 | 41 Hill St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/15/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773950 | 6006079.4584099995 | 2103417.96835 | 37.7559288760699 | -122.421946314733 | (37.7559288760699, -122.421946314733) | ||
| 145874 | 145874 | 100769 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3701 21st St | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | Street tree w/in RoW | 6003717.0 | 2103606.0 | 37.7563116466144 | -122.43012988292 | (37.7563116466144, -122.43012988292) | ||||
| 145993 | 145993 | 106859 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 946 RHODE ISLAND ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 14 | 3x3 | Permit Number 773008 | 6011839.2 | 2104029.4 | 37.7579308843014 | -122.402070102772 | (37.7579308843014, -122.402070102772) | ||
| 28352 | 28352 | 125438 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 250 Euclid Ave | 0 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5998091.24108 | 2114006.2469099998 | 37.78454782955 | -122.45033529224199 | (37.78454782955, -122.450335292242) | ||||
| 38564 | 38564 | 192200 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 326 10th St | 0 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008879.18119 | 2109418.2333 | 37.7725617219648 | -122.41268808588998 | (37.7725617219648, -122.41268808589) | |||
| 53096 | 53096 | 125439 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 99 Collins St | 0 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5998117.25486 | 2114050.06951 | 37.7846696436241 | -122.450248453727 | (37.7846696436241, -122.450248453727) | ||||
| 71132 | 71132 | 192728 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1485 Innes Ave | 0 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6016125.1130099995 | 2096726.19867 | 37.738116091292206 | -122.38673818960899 | (37.7381160912922, -122.386738189609) | |||
| 71627 | 71627 | 121889 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 17th Ave | 0 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5990520.54715 | 2115002.72082 | 37.78684768786071 | -122.47659987163799 | (37.7868476878607, -122.476599871638) | |||
| 72085 | 72085 | 191061 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Clara St | 0 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6011653.56606 | 2111728.79849 | 37.779061325667 | -122.403253717397 | (37.779061325667, -122.403253717397) | |||
| 132555 | 132555 | 191060 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Clara St | 0 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011653.22625 | 2111699.06795 | 37.7789796735174 | -122.40325280096901 | (37.7789796735174, -122.403252800969) | |||
| 175263 | 175263 | 226690 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1451 San Bruno Ave | 0 | Front Yard : Yard 7 | Tree 1 | Private 1 | 0 | 6011227.792669999 | 2101285.4147 | 37.7503623610541 | -122.40399151941901 | (37.7503623610541, -122.403991519419) | ||||
| 179150 | 179150 | 236928 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 563 Ellsworth St | 0 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008012.37418 | 2096216.3399099999 | 37.736263633562395 | -122.414751994907 | (37.7362636335624, -122.414751994907) | |||
| 2 | 2 | 232565 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 940 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/20/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779625 | 6000396.48544 | 2101998.8644 | 37.7517102172731 | -122.441498017841 | (37.7517102172731, -122.441498017841) | |
| 4 | 4 | 207368 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 920 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5992009.48044 | 2105269.9271 | 37.760210314285004 | -122.47073935813 | (37.760210314285, -122.47073935813) | |||
| 17 | 17 | 145278 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 730 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2017 12:00:00 AM | 0 | Width 3ft | Permit Number 779614 | 5992589.961569999 | 2110455.11477 | 37.774481011910204 | -122.469109146279 | (37.7744810119102, -122.469109146279) | |
| 18 | 18 | 96369 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 168 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2011 12:00:00 AM | 24 | 3x3 | Permit Number 767919 | 6001162.44444 | 2121276.45677 | 37.8046852096195 | -122.44023153767799 | (37.8046852096195, -122.440231537678) | |
| 19 | 19 | 182260 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1471 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5987398.0 | 2105276.0 | 37.759959232607606 | -122.486688530832 | (37.7599592326076, -122.486688530832) | |||
| 35 | 35 | 183515 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2562 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/21/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779639 | 5988336.7554 | 2097879.9474 | 37.7397063254514 | -122.482899813956 | (37.7397063254514, -122.482899813956) | |
| 37 | 37 | 226924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 1 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 11 | Width 4ft | 6002558.65829 | 2099967.6575700003 | 37.7462559468486 | -122.433875776072 | (37.7462559468486, -122.433875776072) | |||
| 38 | 38 | 192589 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1390 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008004.0 | 2110521.0 | 37.775540499151 | -122.415793536261 | (37.775540499151, -122.415793536261) | |||
| 49 | 49 | 251186 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3042 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002010.0 | 2118654.0 | 37.7975328515761 | -122.437110618013 | (37.7975328515761, -122.437110618013) | ||||
| 52 | 52 | 233897 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 1021 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003182.0050800005 | 2102290.73647 | 37.75266992967379 | -122.43188616810801 | (37.7526699296738, -122.431886168108) | |||
| 66 | 66 | 222538 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002556.19825 | 2099973.42317 | 37.746271638232 | -122.43388469462201 | (37.746271638232, -122.433884694622) | |||
| 71 | 71 | 251206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 270 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005145.0 | 2094297.0 | 37.7308320294825 | -122.424529217878 | (37.7308320294825, -122.424529217878) | ||||
| 81 | 81 | 221366 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 55 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 778991 | 6000992.93047 | 2101385.53728 | 37.750060130381605 | -122.439391477336 | (37.7500601303816, -122.439391477336) | |
| 83 | 83 | 130626 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3660 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | Permit Number 779583 | 5996802.12344 | 2115996.768 | 37.789939408212206 | -122.454939052208 | (37.7899394082122, -122.454939052208) | ||
| 88 | 88 | 251208 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4115 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5982071.0 | 2104840.0 | 37.758450113202294 | -122.505079418654 | (37.7584501132023, -122.505079418654) | ||||
| 110 | 110 | 97646 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1824 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5988290.0 | 2103126.0 | 37.7541078738982 | -122.48344595561899 | (37.7541078738982, -122.483445955619) | |||
| 125 | 125 | 119758 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 151X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 128 | 128 | 212622 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 115 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991392.0 | 2089980.0 | 37.718192344870296 | -122.471760605115 | (37.7181923448703, -122.471760605115) | |||
| 133 | 133 | 218972 | Undocumented 2 | Fraxinus americana :: American Ash 23 | 742 Myra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | Permit Number 779535 | 5997475.9556599995 | 2098006.28819 | 37.7405807633888 | -122.451309623139 | (37.7405807633888, -122.451309623139) | ||
| 136 | 136 | 213016 | Undocumented 2 | Tree(s) :: 17 | 120 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779661 | 5993626.83548 | 2102594.2327400004 | 37.7529569465285 | -122.4649514087 | (37.7529569465285, -122.4649514087) | |
| 142 | 142 | 251241 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2305 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998495.0 | 2111363.0 | 37.777313260379 | -122.44874797929701 | (37.777313260379, -122.448747979297) | |||||
| 155 | 155 | 251225 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Yukon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x2.5 | 6000238.0 | 2104757.0 | 37.7592743544717 | -122.442244057145 | (37.7592743544717, -122.442244057145) | ||||
| 162 | 162 | 251231 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 164 Serrano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989598.0 | 2090848.0 | 37.7204716934452 | -122.478025052476 | (37.7204716934452, -122.478025052476) | ||||
| 167 | 167 | 251232 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 168 | 168 | 179480 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5989599.0 | 2090767.0 | 37.7202493457345 | -122.478015677124 | (37.7202493457345, -122.478015677124) | ||||
| 171 | 171 | 251242 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2449 Golden Gate Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5997716.0 | 2111278.0 | 37.7770352956542 | -122.451436646998 | (37.7770352956542, -122.451436646998) | |||||
| 185 | 185 | 251243 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 299x Chapman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008953.0 | 2098186.0 | 37.7417246968109 | -122.411638974942 | (37.7417246968109, -122.411638974942) | ||||
| 191 | 191 | 210495 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | Permit Number 779799 | 5992304.44524 | 2094447.3559700001 | 37.7305113566072 | -122.468931622808 | (37.7305113566072, -122.468931622808) | ||
| 241 | 241 | 251257 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1748x Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5986101.0 | 2094852.0 | 37.7312620395563 | -122.490407299046 | (37.7312620395563, -122.490407299046) | ||||
| 245 | 245 | 251255 | Undocumented 2 | Tree(s) :: 17 | 4089x Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991686.0 | 2086822.0 | 37.7095382490701 | -122.47051450746099 | (37.7095382490701, -122.470514507461) | ||||
| 249 | 249 | 251254 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 09th Ave | 1 | unknown : Cutout 12 | Tree 1 | MTA 6 | 3x3 | 5993109.0 | 2113253.0 | 37.782193225103605 | -122.467517213871 | (37.7821932251036, -122.467517213871) | ||||
| 253 | 253 | 251256 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 4091x Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991686.0 | 2086783.0 | 37.70943116445179 | -122.470511668938 | (37.7094311644518, -122.470511668938) | ||||
| 254 | 254 | 98489 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1813 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2016 12:00:00 AM | 3 | 4.5x5 | Permit Number 777656 | 5999969.69733 | 2115286.35323 | 37.7881699939074 | -122.443928497714 | (37.7881699939074, -122.443928497714) | |
| 263 | 263 | 141358 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
| 265 | 265 | 109354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007474.1784 | 2120601.5824599997 | 37.803189502164294 | -122.418341225173 | (37.8031895021643, -122.418341225173) | |||
| 306 | 306 | 173816 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 328 | 328 | 251272 | Undocumented 2 | Acer negundo :: Box Elder 74 | 1301X 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993949.0 | 2106317.0 | 37.7631972735035 | -122.46410754142299 | (37.7631972735035, -122.464107541423) | ||||
| 333 | 333 | 242579 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 818 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2016 12:00:00 AM | 11 | Width 3ft | Permit Number 778239 | 6001257.943419999 | 2101462.97247 | 37.7502878270446 | -122.438480597209 | (37.7502878270446, -122.438480597209) | |
| 334 | 334 | 246360 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1932 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6006755.8259 | 2107130.7038 | 37.76616130474321 | -122.419870652653 | (37.7661613047432, -122.419870652653) | |||
| 364 | 364 | 182551 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2565 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986541.5452 | 2105693.4321 | 37.7610554202125 | -122.489681251316 | (37.7610554202125, -122.489681251316) | |||
| 379 | 379 | 122497 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 31X 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6008445.21835 | 2111601.2724900004 | 37.7785314648928 | -122.414343702699 | (37.7785314648928, -122.414343702699) | |||
| 383 | 383 | 181340 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1360 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5988678.0351 | 2106085.8063 | 37.7622572799997 | -122.48232089502501 | (37.7622572799997, -122.482320895025) | |||
| 411 | 411 | 154366 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 411 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6006164.37856 | 2107202.76015 | 37.7663258166161 | -122.42192147568899 | (37.7663258166161, -122.421921475689) | |||
| 427 | 427 | 251307 | Undocumented 2 | Tree(s) :: 17 | 200 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6016315.0 | 2096328.0 | 37.7370332293639 | -122.38605389871 | (37.7370332293639, -122.38605389871) | ||||
| 429 | 429 | 142788 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 733 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Polk St Scape will replant | 6007029.0497 | 2113497.6534 | 37.7836588132661 | -122.419377346786 | (37.7836588132661, -122.419377346786) | ||
| 443 | 443 | 251293 | Undocumented 2 | :: 54 | 3789 Market St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 6000208.0 | 2102740.0 | 37.753734455764 | -122.44220302061701 | (37.753734455764, -122.442203020617) | ||||
| 448 | 448 | 224849 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 779889 | 6003244.1353400005 | 2095137.54828 | 37.733032453088704 | -122.431160782146 | (37.7330324530887, -122.431160782146) | ||
| 450 | 450 | 142159 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 490X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
| 462 | 462 | 187628 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779889 | 6003236.0 | 2095183.0 | 37.7331567921798 | -122.431192151262 | (37.7331567921798, -122.431192151262) | |||
| 474 | 474 | 251300 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 476 | 476 | 174954 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4xt | Permit Number 779898 | 6007316.0 | 2110809.0 | 37.776292577113104 | -122.418193923043 | (37.7762925771131, -122.418193923043) | |||
| 482 | 482 | 142326 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1652 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999940.0 | 2110256.0 | 37.774356244626205 | -122.44366972691601 | (37.7743562446262, -122.443669726916) | |||
| 491 | 491 | 236057 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004642.9908 | 2107763.18347 | 37.767778685763 | -122.427223596101 | (37.767778685763, -122.427223596101) | |||
| 492 | 492 | 173939 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2017 12:00:00 AM | 3 | 5xt | Permit Number 779890 | 6014341.0 | 2104455.0 | 37.7592388085315 | -122.39344754111201 | (37.7592388085315, -122.393447541112) | |
| 495 | 495 | 248613 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 5997648.1233 | 2107524.615 | 37.766725579885 | -122.451400674442 | (37.766725579885, -122.451400674442) | |||
| 496 | 496 | 245474 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 19 | Width 4ft | 5997377.53226 | 2106405.56262 | 37.7636374489232 | -122.452255843041 | (37.7636374489232, -122.452255843041) | |||
| 514 | 514 | 251312 | Undocumented 2 | :: 54 | 1499 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2099547.0 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | ||||
| 523 | 523 | 247328 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 696X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6003691.2873 | 2110070.3794 | 37.774059815342795 | -122.430680081912 | (37.7740598153428, -122.430680081912) | |||
| 539 | 539 | 206615 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 779324 | 5994758.52704 | 2099346.29484 | 37.7441041156281 | -122.460802465585 | (37.7441041156281, -122.460802465585) |
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");