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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 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) | |||||
| 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) | ||||||
| 99355 | 99355 | 106961 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 325 DWIGHT ST | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6010604.0 | 2091349.0 | 37.7230442144558 | -122.405448941518 | (37.7230442144558, -122.405448941518) | ||||||
| 105728 | 105728 | 104942 | Undocumented 2 | Tree(s) :: 17 | 840X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 09/11/2014 12:00:00 AM | 3 | Permit Number 770723 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||
| 107212 | 107212 | 104811 | Permitted Site 1 | Tree(s) :: 17 | 1900 08th Ave | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/18/2013 12:00:00 AM | Permit Number 770426 | 5993817.2 | 2102486.9 | 37.7526732127641 | -122.46428530535499 | (37.7526732127641, -122.464285305355) | ||||
| 110904 | 110904 | 109242 | Property Tree 7 | Private shrub :: Private Shrub 64 | 2479 DIAMOND ST | Sidewalk: Curb side : Yard 2 | Landscaping 2 | Private 1 | 6002238.1 | 2097343.7 | 37.7390329760373 | -122.434796615916 | (37.7390329760373, -122.434796615916) | ||||||
| 115356 | 115356 | 106044 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 415 DEWEY BLVD | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5995172.1 | 2100351.0 | 37.7468865723154 | -122.45944518004801 | (37.7468865723154, -122.459445180048) | ||||||
| 120337 | 120337 | 106158 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 450 MAGELLAN AVE | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6x6 | 5993514.2 | 2099497.2 | 37.7444467889139 | -122.465115996043 | (37.7444467889139, -122.465115996043) | ||||
| 121547 | 121547 | 104939 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 109X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | ||||||
| 125908 | 125908 | 104941 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 133X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | ||||||
| 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) | ||||||
| 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) | |||
| 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) | ||||||
| 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) | ||||||
| 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) | ||||||
| 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) | |||
| 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) | |
| 27 | 27 | 244214 | Private 5 | Tree(s) :: 17 | 342 Scott St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779666 | 6002262.2202 | 2109717.5413 | 37.7730099442883 | -122.43559821674499 | (37.7730099442883, -122.435598216745) | |
| 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) | |
| 50 | 50 | 138938 | Private 5 | Tree(s) :: 17 | 632 HAYES ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/21/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779650 | 6004797.9634 | 2110922.1515 | 37.7764612085261 | -122.426912572117 | (37.7764612085261, -122.426912572117) | |
| 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) | ||||
| 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) | ||
| 565 | 565 | 206617 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Garcia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994686.63181 | 2099351.09779 | 37.7441131663853 | -122.461051409618 | (37.7441131663853, -122.461051409618) | |||
| 608 | 608 | 233928 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 8 Octavia St Frontage East | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 8ft | 6005775.18179 | 2109348.30824 | 37.77219502161479 | -122.423420179704 | (37.7721950216148, -122.423420179704) | |||
| 721 | 721 | 183636 | Planning Code 138.1 required 4 | Pittosporum crassifolium :: Karo Tree 108 | 1478 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 3x9 | 5981570.9282 | 2105017.3718 | 37.7589076903569 | -122.506822015648 | (37.7589076903569, -122.506822015648) | |||
| 1001 | 1001 | 238568 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1300 Noe St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779731 | 6003218.5106 | 2100626.90187 | 37.7481035005842 | -122.431641146931 | (37.7481035005842, -122.431641146931) | |
| 1785 | 1785 | 228278 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2050 15th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 1871 | 1871 | 176854 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | |||
| 2094 | 2094 | 252881 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3536 Jennings St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 6013049.3063900005 | 2089480.54762 | 37.718050242412296 | -122.39686501810199 | (37.7180502424123, -122.396865018102) | ||||
| 2180 | 2180 | 251495 | Significant Tree 6 | Tree(s) :: 17 | 2448 Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 10x10 | Permit Number 780000 | 6003026.0 | 2116224.0 | 37.7909183964794 | -122.433421252488 | (37.7909183964794, -122.433421252488) | |
| 2402 | 2402 | 201606 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 598 Innes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 1 | Width 3ft | 6020954.32481 | 2093200.4635700001 | 37.7287012794353 | -122.36979738594101 | (37.7287012794353, -122.369797385941) | ||
| 2567 | 2567 | 252819 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 407 Miguel St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | Permit Number 780051 | 6004479.0 | 2096413.0 | 37.736604456337105 | -122.426982337456 | (37.7366044563371, -122.426982337456) | ||
| 2614 | 2614 | 248773 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5999776.82694 | 2101824.96428 | 37.751197407653706 | -122.44362838043999 | (37.7511974076537, -122.44362838044) | |||
| 2760 | 2760 | 251575 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 300 Sussex St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 08/02/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780395 | 6001194.0 | 2096647.0 | 37.737060666835205 | -122.438356728037 | (37.7370606668352, -122.438356728037) | |
| 2934 | 2934 | 250407 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/16/1997 12:00:00 AM | 12 | Width 4ft | Permit Number 38521 | 5987994.17396 | 2115794.4903599997 | 37.78887480516529 | -122.485398549405 | (37.7888748051653, -122.485398549405) | |
| 2983 | 2983 | 250419 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | 8 | Width 4ft | Permit Number 38081 | 5987849.1846199995 | 2115791.00757 | 37.7888567944531 | -122.48589993045601 | (37.7888567944531, -122.485899930456) | |
| 3029 | 3029 | 193472 | Undocumented 2 | Prunus persica nectarina :: Flowering Nectarine Tree 196 | 1059 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6013665.43892 | 2089838.8488900003 | 37.719068342415596 | -122.39476037791599 | (37.7190683424156, -122.394760377916) | ||||
| 3033 | 3033 | 253285 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 5981372.0 | 2112274.0 | 37.7788205636315 | -122.50804856364901 | (37.7788205636315, -122.508048563649) | |||
| 3254 | 3254 | 244746 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 98 12th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6007069.86029 | 2109755.10428 | 37.7733849739584 | -122.418970623803 | (37.7733849739584, -122.418970623803) | |||
| 3411 | 3411 | 181033 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 39 Curtis St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 4ft | 6000587.53239 | 2088326.47 | 37.71417988317489 | -122.439857163381 | (37.7141798831749, -122.439857163381) | |||
| 3413 | 3413 | 180646 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 451 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 6ft | 6002230.18825 | 2087673.61332 | 37.7124806510226 | -122.434132874236 | (37.7124806510226, -122.434132874236) | |||
| 3430 | 3430 | 180648 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 120 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 6ft | 6001751.26715 | 2087361.8508 | 37.7115974268507 | -122.435765878508 | (37.7115974268507, -122.435765878508) | |||
| 3432 | 3432 | 180655 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | |||
| 3734 | 3734 | 118035 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 5984123.0 | 2112760.0 | 37.7803166927985 | -122.498567828267 | (37.7803166927985, -122.498567828267) | |||
| 3812 | 3812 | 253561 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 530 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5993033.55222 | 2099443.36305 | 37.744271238444206 | -122.46677405027799 | (37.7442712384442, -122.466774050278) | ||||
| 3850 | 3850 | 207785 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 290 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 09/28/2017 12:00:00 AM | 3 | Width 10ft | 5993081.87997 | 2096205.8056700001 | 37.7353845093885 | -122.46637169180299 | (37.7353845093885, -122.466371691803) | ||
| 3920 | 3920 | 216755 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 115 Harold Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/04/2017 01:38:00 PM | 3 | Width 3ft | 5996789.877280001 | 2090654.02957 | 37.720353912480995 | -122.453151180205 | (37.720353912481, -122.453151180205) | ||
| 3943 | 3943 | 216737 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 11 Lee Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/04/2017 02:31:00 PM | 3 | Width 2ft | 5996481.70655 | 2089974.5093900003 | 37.7184704425356 | -122.45416736555799 | (37.7184704425356, -122.454167365558) | ||
| 3959 | 3959 | 216642 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 50 Lee Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/04/2017 01:57:00 PM | 3 | Width 2ft | 5996528.83108 | 2090217.4765599999 | 37.7191402755735 | -122.45402201441999 | (37.7191402755735, -122.45402201442) | ||
| 3999 | 3999 | 181035 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 170 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 04:20:00 PM | 3 | Width 4ft | 6000927.8060099995 | 2088408.3131900001 | 37.7144239699579 | -122.438686909772 | (37.7144239699579, -122.438686909772) | ||
| 4006 | 4006 | 216739 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 11 Brighton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 08:12:00 AM | 3 | Width 3ft | 5996185.57101 | 2089978.26988 | 37.7184637821573 | -122.4551912491 | (37.7184637821573, -122.4551912491) | ||
| 4008 | 4008 | 216051 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 48 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 02:54:00 PM | 3 | 5996419.4156599995 | 2088710.03455 | 37.7149949180514 | -122.454291392827 | (37.7149949180514, -122.454291392827) | |||
| 4014 | 4014 | 216033 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 4 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:13:00 PM | 3 | 5996833.19651 | 2088697.5304900003 | 37.7149843051513 | -122.452860296276 | (37.7149843051513, -122.452860296276) | |||
| 4026 | 4026 | 216034 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 8 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:11:00 PM | 3 | 5996778.28459 | 2088695.06883 | 37.714974399131705 | -122.45304991653099 | (37.7149743991317, -122.453049916531) | |||
| 4097 | 4097 | 216058 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 58 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 02:35:00 PM | 3 | 5996320.31527 | 2088710.5585599998 | 37.7149906732676 | -122.45463396169599 | (37.7149906732676, -122.454633961696) | |||
| 4103 | 4103 | 216046 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 38 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:02:00 PM | 3 | 5996487.74032 | 2088710.41168 | 37.7149998715299 | -122.454055262356 | (37.7149998715299, -122.454055262356) | |||
| 4113 | 4113 | 181027 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 95 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 04:23:00 PM | 3 | Width 4ft | 6000546.58685 | 2088667.2481099998 | 37.7151132526545 | -122.440023107188 | (37.7151132526545, -122.440023107188) | ||
| 4117 | 4117 | 216048 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 40 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 02:58:00 PM | 3 | 5996463.1782599995 | 2088711.43982 | 37.7150012861457 | -122.45414023299999 | (37.7150012861457, -122.454140233) | |||
| 4129 | 4129 | 216706 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 231 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:40:00 AM | 3 | Width 3ft | 5994712.86869 | 2090137.86358 | 37.718817384787606 | -122.460293291921 | (37.7188173847876, -122.460293291921) | ||
| 4144 | 4144 | 216652 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 329 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:15:00 AM | 3 | Width 4ft | 5994725.9247 | 2090785.7094700001 | 37.7205969659665 | -122.460295076156 | (37.7205969659665, -122.460295076156) | ||
| 4146 | 4146 | 216707 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 230 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:46:00 AM | 3 | Width 3ft | 5994758.05727 | 2090129.91465 | 37.7187981581945 | -122.460136518501 | (37.7187981581945, -122.460136518501) | ||
| 4150 | 4150 | 216749 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 26 Granada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:25:00 AM | 3 | Width 3ft | 5995639.9781599995 | 2090086.85434 | 37.7187306119189 | -122.45708497580699 | (37.7187306119189, -122.457084975807) | ||
| 4153 | 4153 | 216751 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 31 Granada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:38:00 AM | 3 | Width 3ft | 5995599.77101 | 2090122.1597400003 | 37.718825243070604 | -122.45722650749799 | (37.7188252430706, -122.457226507498) | ||
| 4163 | 4163 | 216683 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 129 Ashton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:06:00 AM | 3 | Width 3ft | 5994135.07503 | 2090797.4570099998 | 37.7205952167724 | -122.462338293592 | (37.7205952167724, -122.462338293592) | ||
| 4183 | 4183 | 180766 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1206 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:29:00 AM | 3 | Width 8ft | 6001093.57723 | 2087421.33847 | 37.7117233858917 | -122.438043283865 | (37.7117233858917, -122.438043283865) | ||
| 4209 | 4209 | 180663 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 355 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:48:00 PM | 3 | Width 6ft | 6002383.84355 | 2086445.14687 | 37.709116270155604 | -122.43351405884898 | (37.7091162701556, -122.433514058849) | ||
| 4220 | 4220 | 181020 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 183 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 12:41:00 PM | 3 | Width 4ft | 6000952.49174 | 2088426.9301099998 | 37.714476492181895 | -122.438602919392 | (37.7144764921819, -122.438602919392) | ||
| 4227 | 4227 | 181017 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 197 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:28:00 AM | 3 | Width 4ft | 6001019.31887 | 2088386.79799 | 37.7143700996689 | -122.43836906510201 | (37.7143700996689, -122.438369065102) | ||
| 4244 | 4244 | 180664 | Undocumented 2 | Magnolia champaca :: Champa 170 | 339 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:55:00 PM | 3 | Width 6ft | 6002468.5653 | 2086489.08528 | 37.7092417219876 | -122.43322438540399 | (37.7092417219876, -122.433224385404) | ||
| 4245 | 4245 | 181019 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 191 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 12:36:00 PM | 3 | Width 4ft | 6000981.45407 | 2088409.26942 | 37.714429647391896 | -122.438501549606 | (37.7144296473919, -122.438501549606) | ||
| 4249 | 4249 | 180650 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 178 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:41:00 AM | 3 | Width 7ft | 6001253.45718 | 2087396.1433599999 | 37.7116632967974 | -122.437488893205 | (37.7116632967974, -122.437488893205) | ||
| 4254 | 4254 | 180668 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:45:00 PM | 3 | Width 6ft | 6002314.90905 | 2086461.72548 | 37.709157880008 | -122.433753490754 | (37.709157880008, -122.433753490754) | ||
| 4257 | 4257 | 181010 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 215 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:17:00 AM | 3 | Width 4ft | 6001139.6561 | 2088316.9005900002 | 37.7141850209845 | -122.437948129327 | (37.7141850209845, -122.437948129327) | ||
| 4271 | 4271 | 180665 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 316 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 02:13:00 PM | 3 | Width 6ft | 6002643.65919 | 2086652.61793 | 37.7097006784091 | -122.432630907484 | (37.7097006784091, -122.432630907484) | ||
| 4284 | 4284 | 175543 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 187 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:37:00 AM | 3 | Width 6ft | 6001178.343719999 | 2087386.3168 | 37.7116320444605 | -122.43774780171302 | (37.7116320444605, -122.437747801713) | ||
| 4293 | 4293 | 216862 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 272 Sadowa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 08:43:00 AM | 3 | Width 3ft | 5994260.82584 | 2087785.69998 | 37.7123328897311 | -122.461685361516 | (37.7123328897311, -122.461685361516) | ||
| 4306 | 4306 | 181011 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 207 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:21:00 AM | 3 | Width 4ft | 6001121.315830001 | 2088326.0025400002 | 37.714208969932706 | -122.438012171843 | (37.7142089699327, -122.438012171843) | ||
| 4315 | 4315 | 216902 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 174 Bright St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/11/2017 11:02:00 AM | 3 | Width 3ft | 5993764.72474 | 2088364.55203 | 37.7138937098892 | -122.46344200363899 | (37.7138937098892, -122.463442003639) | ||
| 4358 | 4358 | 180653 | Undocumented 2 | Magnolia champaca :: Champa 170 | 245 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/11/2017 07:56:00 AM | 3 | Width 6ft | 6002847.75966 | 2086772.69306 | 37.7100419513527 | -122.43193406871299 | (37.7100419513527, -122.431934068713) | ||
| 4415 | 4415 | 216758 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 35 Bruce Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/11/2017 10:35:00 AM | 3 | Width 3ft | 5997172.50242 | 2091270.81822 | 37.7220693917577 | -122.45187305021099 | (37.7220693917577, -122.451873050211) | ||
| 4467 | 4467 | 216711 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 922 Capitol Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/13/2017 12:14:00 PM | 3 | Width 3ft | 5995050.42243 | 2090071.97473 | 37.7186558809545 | -122.45912174238998 | (37.7186558809545, -122.45912174239) | ||
| 4488 | 4488 | 216714 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 934 Capitol Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/13/2017 11:10:00 AM | 3 | Width 3ft | 5995052.942530001 | 2090158.7504099999 | 37.7188942912315 | -122.459119311509 | (37.7188942912315, -122.459119311509) | ||
| 4734 | 4734 | 181032 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 51 Curtis St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/24/2017 12:14:00 PM | 3 | Width 4ft | 6000613.84351 | 2088248.98957 | 37.7139686369286 | -122.439760670618 | (37.7139686369286, -122.439760670618) | ||
| 4769 | 4769 | 194422 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 52 | Width 5ft | 6007901.53326 | 2109054.5781799997 | 37.771508291196 | -122.41604412194401 | (37.771508291196, -122.416044121944) | |||
| 4797 | 4797 | 214559 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1342 Irving St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | Width 3ft | 5991532.56497 | 2106606.32246 | 37.7638521099028 | -122.472486197695 | (37.7638521099028, -122.472486197695) | ||
| 4821 | 4821 | 214558 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1340 Irving St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 4 | Width 3ft | 5991564.93185 | 2106609.34919 | 37.7638622938456 | -122.472374472204 | (37.7638622938456, -122.472374472204) | ||
| 5045 | 5045 | 123372 | Undocumented 2 | Crateagus spp :: Hawthorn 160 | 785 03rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5995014.0 | 2110353.0 | 37.7743403969856 | -122.46071658922399 | (37.7743403969856, -122.460716589224) | |||
| 9497 | 9497 | 122159 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 547 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 4ft | 5991246.192840001 | 2111684.05416 | 37.7777776077222 | -122.473847129053 | (37.7777776077222, -122.473847129053) | |||
| 9572 | 9572 | 100227 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 542 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Permit Number 769993 | 6002426.0 | 2099190.0 | 37.7441131524814 | -122.434278904907 | (37.7441131524814, -122.434278904907) | |||
| 10103 | 10103 | 173844 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2X Crestline Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5999319.0 | 2101169.0 | 37.7493701671822 | -122.445164434644 | (37.7493701671822, -122.445164434644) | |||||
| 10991 | 10991 | 116458 | Significant Tree 6 | Eucalyptus lehmanni :: Bushy Yate 267 | 777 Brotherhood Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 10x20 | 5989819.39068 | 2088633.8654 | 37.7144050769972 | -122.477098071327 | (37.7144050769972, -122.477098071327) | |||
| 11147 | 11147 | 83378 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 586 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52310 | 6003277.11077 | 2089949.83191 | 37.718790012118795 | -122.430676716663 | (37.7187900121188, -122.430676716663) | |
| 11417 | 11417 | 117425 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 218 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775470 | 6004576.76699 | 2091985.7103900001 | 37.724453633907 | -122.426329194258 | (37.724453633907, -122.426329194258) | ||
| 12169 | 12169 | 107579 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992416.91174 | 2086830.03613 | 37.7096025506984 | -122.467988957943 | (37.7096025506984, -122.467988957943) | ||
| 12904 | 12904 | 117426 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 395 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775297 | 6003998.920059999 | 2091015.17385 | 37.7217560742586 | -122.428257595231 | (37.7217560742586, -122.428257595231) | ||
| 13306 | 13306 | 187657 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2072 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5991666.0 | 2101424.0 | 37.7496305363998 | -122.47164701446 | (37.7496305363998, -122.47164701446) | ||||
| 13307 | 13307 | 187654 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 375 Woodside Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5997267.0 | 2099886.0 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | ||||
| 16807 | 16807 | 106757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 36 | 6013321.202330001 | 2089752.82506 | 37.718812992515105 | -122.395944254446 | (37.7188129925151, -122.395944254446) | |||
| 19268 | 19268 | 104883 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 132 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990322.1 | 2090011.1 | 37.718215776001294 | -122.475461023549 | (37.7182157760013, -122.475461023549) |
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");