Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140036 | 140036 | 105148 | Permitted Site 1 | Tree(s) :: 17 | 185 Stratford Dr | : 4 | Tree 1 | Private 1 | 12/26/2013 12:00:00 AM | Permit Number 770387 | 5990916.9 | 2091282.3 | 37.7217406386467 | -122.473497746062 | (37.7217406386467, -122.473497746062) | ||||
| 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) | |||
| 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) | |||
| 382 | 382 | 228870 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 132 Church St | 1 | : 4 | Tree 1 | Private 1 | 11/03/2006 12:00:00 AM | 2 | Width 4ft | Permit Number 49185 | 6004081.45763 | 2108139.41942 | 37.768779966653106 | -122.42919270218599 | (37.7687799666531, -122.429192702186) | |
| 404 | 404 | 249555 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005893.0868 | 2115064.96247 | 37.787898211588704 | -122.423418809148 | (37.7878982115887, -122.423418809148) | |
| 576 | 576 | 240412 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3420 Market St | 1 | : 4 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.059769999 | 2103920.2632400002 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | ||
| 719 | 719 | 246969 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 1 | : 4 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 9 | Width 4ft | Permit Number 778955 | 6002937.11929 | 2106633.84457 | 37.7645811776972 | -122.433043298823 | (37.7645811776972, -122.433043298823) | |
| 748 | 748 | 195045 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 312 06th St | 1 | : 4 | Tree 1 | DPW 2 | 10 | Width 3ft | 6010980.17572 | 2111476.79231 | 37.7783317443601 | -122.40556550564501 | (37.7783317443601, -122.405565505645) | |||
| 761 | 761 | 195041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 402 06th St | 1 | : 4 | Tree 1 | DPW 2 | 28 | Width 3ft | 6011480.36813 | 2111044.01847 | 37.777171403968296 | -122.40380468436199 | (37.7771714039683, -122.403804684362) | |||
| 808 | 808 | 193091 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1395 Fairfax Ave | 1 | : 4 | Tree 1 | DPW 2 | 01/27/2015 12:22:00 PM | 6 | Width 3ft | 6016598.40823 | 2097419.6759099998 | 37.7400464320877 | -122.38515006152201 | (37.7400464320877, -122.385150061522) | ||
| 1099 | 1099 | 250070 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 1 | : 4 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005393.47416 | 2115303.0126799997 | 37.788523627097 | -122.425164323999 | (37.788523627097, -122.425164323999) | |||
| 1165 | 1165 | 249373 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 649 Jones St | 1 | : 4 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | 21 | Width 4ft | Permit Number 39973 | 6008805.56783 | 2114728.1661400003 | 37.78713740130579 | -122.4133182966 | (37.7871374013058, -122.4133182966) | |
| 1168 | 1168 | 218199 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 819 Ulloa St | 1 | : 4 | Tree 1 | DPW 2 | 13 | Width 3ft | 5993346.67502 | 2098141.32486 | 37.740714236277 | -122.46559677389799 | (37.740714236277, -122.465596773898) | |||
| 1969 | 1969 | 198010 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 213 Clara St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | Permit Number 779305 | 6011863.46506 | 2111836.2655700003 | 37.7793681257663 | -122.40253514649099 | (37.7793681257663, -122.402535146491) | ||
| 2241 | 2241 | 193105 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1649 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 10/28/1996 12:00:00 AM | 10 | Width 5ft | 6014582.89152 | 2095437.7386599998 | 37.734492738953 | -122.39198038730301 | (37.734492738953, -122.391980387303) | ||
| 2282 | 2282 | 234424 | Undocumented 2 | Photinia fraseri :: Photinia Tree 153 | 360 Church St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 780144 | 6004154.11162 | 2106813.1044400004 | 37.7651423384845 | -122.428846830126 | (37.7651423384845, -122.428846830126) | ||
| 2410 | 2410 | 201817 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021101.98762 | 2093338.62944 | 37.7290887577236 | -122.36929644199101 | (37.7290887577236, -122.369296441991) | ||
| 2475 | 2475 | 213240 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 72 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 11/24/1982 12:00:00 AM | 14 | Width 3ft | Permit Number 20046 | 5997197.846969999 | 2089560.74227 | 37.7173753740534 | -122.451662146612 | (37.7173753740534, -122.451662146612) | |
| 2946 | 2946 | 228442 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 413 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004129.64861 | 2109389.34953 | 37.7722146987825 | -122.429115146464 | (37.7722146987825, -122.429115146464) | ||
| 2970 | 2970 | 228443 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 401 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004157.65728 | 2109393.74469 | 37.7722283522845 | -122.42901857547301 | (37.7722283522845, -122.429018575473) | ||
| 2984 | 2984 | 228440 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 451 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 4 | Width 3ft | 6003980.50091 | 2109366.20592 | 37.7721427080557 | -122.42962941028401 | (37.7721427080557, -122.429629410284) | ||
| 3025 | 3025 | 228441 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 419 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | ||
| 3621 | 3621 | 249566 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005942.163819999 | 2114329.62673 | 37.7858819315591 | -122.42319672154899 | (37.7858819315591, -122.423196721549) | |||
| 3630 | 3630 | 246504 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 255 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 01/05/1989 12:00:00 AM | 9 | Width 3ft | Permit Number 25818 | 6004850.160540001 | 2099861.56096 | 37.7460944007479 | -122.425944484052 | (37.7460944007479, -122.425944484052) | |
| 3873 | 3873 | 228872 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 32 Church St | 1 | : 4 | Tree 1 | Private 1 | 10/02/2017 12:00:00 AM | 3 | 4x7 | Permit Number 780415 | 6004066.01114 | 2108522.69035 | 37.7698314611737 | -122.42927346400101 | (37.7698314611737, -122.429273464001) | |
| 5171 | 5171 | 247184 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | |
| 8599 | 8599 | 96031 | Permitted Site 1 | Psidium guajava :: Guava tree 252 | 1116 Greenwich St | 1 | : 4 | Tree 1 | Private 1 | 04/05/2011 12:00:00 AM | 20 | Permit Number 767346 | 6007512.843169999 | 2119899.46213 | 37.8012638333238 | -122.418157616905 | (37.8012638333238, -122.418157616905) | ||
| 22360 | 22360 | 191245 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1675 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6014937.212180001 | 2097262.06336 | 37.7395216264201 | -122.3908828304 | (37.7395216264201, -122.3908828304) | |||
| 22855 | 22855 | 188957 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1708 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6014940.685740001 | 2096639.31184 | 37.73781187133179 | -122.39082730983499 | (37.7378118713318, -122.390827309835) | |||
| 22911 | 22911 | 238577 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 133 Buchanan St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004747.18096 | 2108954.98025 | 37.771056963743 | -122.426948105892 | (37.771056963743, -122.426948105892) | |||
| 23411 | 23411 | 195158 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1188 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6011916.5871 | 2102892.02207 | 37.7548122137394 | -122.401722520004 | (37.7548122137394, -122.401722520004) | |||
| 23416 | 23416 | 247236 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Haight St | 1 | : 4 | Tree 1 | Private 1 | 26 | Width 6ft | 6000176.36555 | 2108836.62464 | 37.770472476353 | -122.442750157415 | (37.770472476353, -122.442750157415) | |||
| 23436 | 23436 | 187515 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Lauren Ct | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6012570.47183 | 2088125.85933 | 37.7143038745038 | -122.398425150324 | (37.7143038745038, -122.398425150324) | |||
| 23483 | 23483 | 234406 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 147 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 8ft | 6006058.10348 | 2108951.831 | 37.7711223543454 | -122.422413351811 | (37.7711223543454, -122.422413351811) | |||
| 23494 | 23494 | 219849 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 72 Skyview Way | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997939.73785 | 2101790.86322 | 37.7509988274335 | -122.449978746126 | (37.7509988274335, -122.449978746126) | |||
| 23501 | 23501 | 187800 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2 Heron St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6009988.42633 | 2110014.66553 | 37.7742615809293 | -122.40889316451499 | (37.7742615809293, -122.408893164515) | |||
| 23518 | 23518 | 247709 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 848 Waller St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6001610.36211 | 2108740.78692 | 37.7702909742819 | -122.437783100124 | (37.7702909742819, -122.437783100124) | |||
| 23580 | 23580 | 212649 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 321 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5992450.10328 | 2090020.5964400002 | 37.7183649772426 | -122.468106177365 | (37.7183649772426, -122.468106177365) | |||
| 23603 | 23603 | 231527 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 127 Scott St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6002315.440669999 | 2108966.67057 | 37.7709512619163 | -122.435360399361 | (37.7709512619163, -122.435360399361) | |||
| 23608 | 23608 | 210892 | Undocumented 2 | Paulownia tomentosa :: Empress Tree 332 | 210 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992474.84263 | 2089237.23886 | 37.7162154959333 | -122.467963716667 | (37.7162154959333, -122.467963716667) | |||
| 23687 | 23687 | 235690 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 63 Laussat St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6004411.60055 | 2109266.67882 | 37.7718938314631 | -122.428131106459 | (37.7718938314631, -122.428131106459) | |||
| 23764 | 23764 | 197793 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 66 Ceres St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013832.07065 | 2093815.87712 | 37.7299977259065 | -122.394462716674 | (37.7299977259065, -122.394462716674) | |||
| 23930 | 23930 | 246508 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004932.15845 | 2099866.5422 | 37.7461127118493 | -122.425661300149 | (37.7461127118493, -122.425661300149) | |||
| 23940 | 23940 | 190941 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1701 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013964.79274 | 2095080.10635 | 37.733476418703496 | -122.39409234708599 | (37.7334764187035, -122.394092347086) | |||
| 24000 | 24000 | 246500 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6004745.35521 | 2099854.76299 | 37.746069811469 | -122.426306403626 | (37.746069811469, -122.426306403626) | |||
| 24033 | 24033 | 189426 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 553 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 7ft | 6013011.23422 | 2104452.4501799997 | 37.759157834075204 | -122.398046364864 | (37.7591578340752, -122.398046364864) | |||
| 24071 | 24071 | 250790 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 284 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985915.81821 | 2114007.58209 | 37.7838471713633 | -122.49245762762101 | (37.7838471713633, -122.492457627621) | |||
| 24128 | 24128 | 198134 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 131 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6013337.1330699995 | 2095632.7165299999 | 37.7349588665628 | -122.396301078452 | (37.7349588665628, -122.396301078452) | |||
| 24147 | 24147 | 210947 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 171 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992177.81487 | 2089015.3385599998 | 37.715589054271 | -122.468974238973 | (37.715589054271, -122.468974238973) | |||
| 24285 | 24285 | 211375 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 462 Head St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993511.66198 | 2088947.80239 | 37.7154805924354 | -122.46435899649201 | (37.7154805924354, -122.464358996492) | |||
| 24309 | 24309 | 191424 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 743 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012751.8613599995 | 2104046.56843 | 37.758028922326496 | -122.398914919298 | (37.7580289223265, -122.398914919298) | |||
| 24318 | 24318 | 195049 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 425 07th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011046.10585 | 2110191.14121 | 37.7748053308349 | -122.405246869567 | (37.7748053308349, -122.405246869567) | |||
| 24332 | 24332 | 246923 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 411 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 6ft | 5997906.77047 | 2107481.56832 | 37.7666221917918 | -122.450502958247 | (37.7666221917918, -122.450502958247) | |||
| 24358 | 24358 | 211712 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 418 San Miguel St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997865.28032 | 2089936.92549 | 37.7184464872957 | -122.449382239324 | (37.7184464872957, -122.449382239324) | |||
| 24372 | 24372 | 246497 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 319 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 6ft | 6004279.93355 | 2099832.71811 | 37.7459829621447 | -122.427914200798 | (37.7459829621447, -122.427914200798) | |||
| 24404 | 24404 | 246777 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Esmeralda Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009797.217759999 | 2098767.51115 | 37.743368720206206 | -122.408760953364 | (37.7433687202062, -122.408760953364) | |||
| 24435 | 24435 | 189790 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 671 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6013319.6658 | 2103964.90842 | 37.7578363244071 | -122.39694547056601 | (37.7578363244071, -122.396945470566) | |||
| 24505 | 24505 | 195054 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 820 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6011686.5663 | 2110516.6477900003 | 37.775734882702295 | -122.403054272047 | (37.7757348827023, -122.403054272047) | |||
| 24574 | 24574 | 250326 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5987393.53331 | 2114913.8058 | 37.786421687562104 | -122.487411939018 | (37.7864216875621, -122.487411939018) | |||
| 24622 | 24622 | 247221 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 187 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6001849.330080001 | 2108668.89946 | 37.770107174421796 | -122.436951364836 | (37.7701071744218, -122.436951364836) | |||
| 24628 | 24628 | 193040 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1890 Evans Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6014266.5091 | 2099591.88048 | 37.745881580665 | -122.393364845912 | (37.745881580665, -122.393364845912) | |||
| 24738 | 24738 | 207248 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 574 Arch St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992756.55156 | 2091026.1972 | 37.7211438059241 | -122.46711999608401 | (37.7211438059241, -122.467119996084) | |||
| 24956 | 24956 | 198140 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 152 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 6013267.76129 | 2095794.5918400001 | 37.7353994821874 | -122.396552266301 | (37.7353994821874, -122.396552266301) | |||
| 24967 | 24967 | 241232 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 127 Duboce Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005861.10215 | 2108452.80959 | 37.7697410460526 | -122.42305931235201 | (37.7697410460526, -122.423059312352) | |||
| 25109 | 25109 | 241253 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 398 Guerrero St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005480.91961 | 2106731.68653 | 37.764993792043 | -122.424251927594 | (37.764993792043, -122.424251927594) | |||
| 25118 | 25118 | 249530 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 236 Myrtle St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6006266.61639 | 2114058.0965400003 | 37.7851546812964 | -122.422054907229 | (37.7851546812964, -122.422054907229) | |||
| 25166 | 25166 | 188682 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Evans Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6018053.21017 | 2096769.99546 | 37.738342908392504 | -122.38007476635299 | (37.7383429083925, -122.380074766353) | |||
| 25220 | 25220 | 235688 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 242 Church St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6004123.15327 | 2107397.4194400003 | 37.766744974426395 | -122.428995570805 | (37.7667449744264, -122.428995570805) | |||
| 25301 | 25301 | 190759 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 960 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6011851.68946 | 2103937.20655 | 37.757678438529894 | -122.40202042759701 | (37.7576784385299, -122.402020427597) | |||
| 25370 | 25370 | 191599 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2091 Bancroft Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011675.2321 | 2094112.7806 | 37.730692823599 | -122.40194007767799 | (37.730692823599, -122.401940077678) | |||
| 25479 | 25479 | 246475 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 318 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004316.48172 | 2099879.2195200003 | 37.7461127118429 | -122.427791134863 | (37.7461127118429, -122.427791134863) | |||
| 25659 | 25659 | 194764 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1101 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6014997.18752 | 2096468.24359 | 37.737345287747395 | -122.390620003515 | (37.7373452877474, -122.390620003515) | |||
| 25698 | 25698 | 202267 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 28 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6013033.98272 | 2093207.99375 | 37.728284203554395 | -122.397179214247 | (37.7282842035544, -122.397179214247) | |||
| 25735 | 25735 | 246806 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 132 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6010286.59808 | 2099166.12262 | 37.744490619049294 | -122.407096884714 | (37.7444906190493, -122.407096884714) | |||
| 25775 | 25775 | 188897 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 837 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6012777.55941 | 2103554.0520599997 | 37.7566780119987 | -122.398791479242 | (37.7566780119987, -122.398791479242) | |||
| 25791 | 25791 | 135673 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 3639 Webster St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002560.08245 | 2121134.92796 | 37.8043760820531 | -122.435384749408 | (37.8043760820531, -122.435384749408) | |||
| 25860 | 25860 | 246929 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 349 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 5998314.74139 | 2107540.20293 | 37.7668065294199 | -122.44909608851201 | (37.7668065294199, -122.449096088512) | |||
| 25865 | 25865 | 196050 | Undocumented 2 | Populus spp :: Poplar Spp 276 | 10 McLea Ct | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6010085.91639 | 2109269.38137 | 37.7722206639802 | -122.408503344349 | (37.7722206639802, -122.408503344349) | |||
| 25874 | 25874 | 192931 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1562 11th St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008981.17541 | 2108615.0151400003 | 37.7703619964339 | -122.412278495049 | (37.7703619964339, -122.412278495049) | |||
| 25906 | 25906 | 249410 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 698 Polk St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6007114.554409999 | 2113257.76141 | 37.7830049436594 | -122.419064511231 | (37.7830049436594, -122.419064511231) | |||
| 25944 | 25944 | 233355 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 45 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5998067.992430001 | 2104637.9237599997 | 37.758823486839 | -122.449740378141 | (37.758823486839, -122.449740378141) | |||
| 26062 | 26062 | 247051 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 519 Valley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6002519.90495 | 2099141.5459 | 37.743985438385295 | -122.43395073994499 | (37.7439854383853, -122.433950739945) | |||
| 26129 | 26129 | 201124 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3275 03rd St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016063.81763 | 2100244.9969099998 | 37.7477745960196 | -122.38719549489402 | (37.7477745960196, -122.387195494894) | |||
| 26136 | 26136 | 188896 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 851 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012778.37681 | 2103525.2873 | 37.7565990757928 | -122.398786633697 | (37.7565990757928, -122.398786633697) | |||
| 26163 | 26163 | 247176 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001288.35672 | 2108578.65763 | 37.7698274924813 | -122.438885293015 | (37.7698274924813, -122.438885293015) | |||
| 26165 | 26165 | 194702 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 632 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012974.17874 | 2104079.5234 | 37.758131794864504 | -122.39814835788 | (37.7581317948645, -122.39814835788) | |||
| 26172 | 26172 | 246467 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 244 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6004891.34106 | 2099910.0636400003 | 37.7462299051934 | -122.42580553881099 | (37.7462299051934, -122.425805538811) | |||
| 26235 | 26235 | 194704 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 656 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6012976.97974 | 2104015.65385 | 37.7579565790575 | -122.39813418994801 | (37.7579565790575, -122.398134189948) | |||
| 26280 | 26280 | 136663 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 3109 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6005049.76701 | 2120690.58566 | 37.803297110532895 | -122.426737318298 | (37.8032971105329, -122.426737318298) | |||
| 26286 | 26286 | 247164 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 181 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6001468.5616 | 2108335.5699400003 | 37.76917028501371 | -122.438244553041 | (37.7691702850137, -122.438244553041) | |||
| 26295 | 26295 | 201309 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 11 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012928.97985 | 2092740.84393 | 37.7269956593979 | -122.397509466884 | (37.7269956593979, -122.397509466884) | |||
| 26296 | 26296 | 193431 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 568 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013531.88693 | 2104447.0848 | 37.7591720865425 | -122.39624530967801 | (37.7591720865425, -122.396245309678) | |||
| 26300 | 26300 | 230904 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 485 Dellbrook Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5996727.95407 | 2103173.3402400003 | 37.7547253509046 | -122.454269037488 | (37.7547253509046, -122.454269037488) | |||
| 26358 | 26358 | 188851 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 397 08th St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6010057.61121 | 2109905.66708 | 37.7739661716411 | -122.40864614951299 | (37.7739661716411, -122.408646149513) | |||
| 26360 | 26360 | 249391 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 280 Turk St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6008635.33064 | 2113188.0691299997 | 37.7828991069454 | -122.41379830166201 | (37.7828991069454, -122.413798301662) | |||
| 26368 | 26368 | 137075 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 689 Hayes St | 1 | : 4 | Tree 1 | Private 1 | 24 | Width 5ft | 6004617.552730001 | 2110839.21576 | 37.776223284701 | -122.42753075415001 | (37.776223284701, -122.42753075415) | |||
| 26381 | 26381 | 251002 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 250 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5981992.43445 | 2112670.6708 | 37.7799462432625 | -122.50593169049299 | (37.7799462432625, -122.505931690493) | |||
| 26445 | 26445 | 195159 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1190 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6011918.3427099995 | 2102871.98584 | 37.7547572966145 | -122.40171504034201 | (37.7547572966145, -122.401715040342) | |||
| 26446 | 26446 | 238580 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 519 Hickory St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6004286.86456 | 2110289.10974 | 37.7746941188733 | -122.428635472355 | (37.7746941188733, -122.428635472355) |
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");