Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188449 | 188449 | 224191 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 122 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005002.1777800005 | 2096858.81533 | 37.7378581342538 | -122.425205199076 | (37.7378581342538, -122.425205199076) | ||||
| 132733 | 132733 | 224190 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 121 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004977.04425 | 2096823.5682 | 37.737759933676706 | -122.425289590543 | (37.7377599336767, -122.425289590543) | ||||
| 160578 | 160578 | 224189 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 119 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | 6004983.70643 | 2096876.20955 | 37.737904851335 | -122.42527030099501 | (37.737904851335, -122.425270300995) | ||||
| 137626 | 137626 | 224272 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1000 San Jose Ave | 118 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005007.01889 | 2096875.50161 | 37.737904224505 | -122.425189647979 | (37.737904224505, -122.425189647979) | ||||
| 79463 | 79463 | 116977 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100x CARGO WAY | 117 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 188340 | 188340 | 224188 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 117 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005014.01111 | 2096876.39929 | 37.7379070843395 | -122.42516553628799 | (37.7379070843395, -122.425165536288) | ||||
| 59920 | 59920 | 224187 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 116 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6004997.70734 | 2096883.03935 | 37.737924395399205 | -122.42522237880699 | (37.7379243953992, -122.425222378807) | ||||
| 133023 | 133023 | 224217 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 115 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6005000.71693 | 2096893.74168 | 37.7379539516063 | -122.42521273450001 | (37.7379539516063, -122.4252127345) | ||||
| 136349 | 136349 | 224186 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 114 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6005021.679330001 | 2096895.74066 | 37.7379606245711 | -122.42514039930599 | (37.7379606245711, -122.425140399306) | ||||
| 46095 | 46095 | 224185 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 113 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6005009.48199 | 2096913.00579 | 37.7380073416725 | -122.42518379971901 | (37.7380073416725, -122.425183799719) | ||||
| 39013 | 39013 | 223986 | Undocumented 2 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 107 | 1000 San Jose Ave | 112 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005022.50641 | 2096918.9877400002 | 37.7380245025333 | -122.42513919334299 | (37.7380245025333, -122.425139193343) | ||||
| 49696 | 49696 | 248657 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 111 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6005025.16759 | 2096929.69692 | 37.7380540578596 | -122.425130754104 | (37.7380540578596, -122.425130754104) | ||||
| 176014 | 176014 | 248656 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 110 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005044.37292 | 2096931.03803 | 37.7380588251561 | -122.42506444708 | (37.7380588251561, -122.42506444708) | ||||
| 51689 | 51689 | 223995 | Undocumented 2 | Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 | 1000 San Jose Ave | 109 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005045.35559 | 2096944.9067 | 37.7380969609067 | -122.42506203599702 | (37.7380969609067, -122.425062035997) | ||||
| 28316 | 28316 | 224184 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 108 | Front Yard : Yard 7 | Tree 1 | Private 1 | 29 | 6005030.14843 | 2096951.46948 | 37.7381141217706 | -122.42511508160801 | (37.7381141217706, -122.425115081608) | ||||
| 169087 | 169087 | 248655 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 107 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005056.20315 | 2096946.76695 | 37.7381026814961 | -122.425024662861 | (37.7381026814961, -122.425024662861) | ||||
| 177422 | 177422 | 237963 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1000 San Jose Ave | 106 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005052.98208 | 2096959.6805599998 | 37.7381379574049 | -122.42503671826799 | (37.7381379574049, -122.425036718268) | ||||
| 62971 | 62971 | 224271 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1000 San Jose Ave | 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6005045.997 | 2096959.12957 | 37.73813604993279 | -122.425060830014 | (37.7381360499328, -122.425060830014) | ||||
| 37269 | 37269 | 227675 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 104 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6005040.407269999 | 2096975.5643799999 | 37.7381808604543 | -122.425081325568 | (37.7381808604543, -122.425081325568) | ||||
| 132835 | 132835 | 224183 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 103 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 6005049.3409400005 | 2096969.1303400001 | 37.7381636986871 | -122.42504997969499 | (37.7381636986871, -122.425049979695) | ||||
| 42917 | 42917 | 221413 | Undocumented 2 | Acacia spp :: Acacia Spp 176 | 1000 San Jose Ave | 102 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005081.29226 | 2097000.2093200001 | 37.738250839395 | -122.424941718412 | (37.738250839395, -122.424941718412) | ||||
| 179651 | 179651 | 240213 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1000 San Jose Ave | 101 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005074.47126 | 2096982.94014 | 37.738203036831 | -122.424964073757 | (37.738203036831, -122.424964073757) | ||||
| 187938 | 187938 | 223985 | Undocumented 2 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 107 | 1000 San Jose Ave | 100 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005168.16195 | 2097235.94873 | 37.7389030331571 | -122.424658130684 | (37.7389030331571, -122.424658130684) | ||||
| 32884 | 32884 | 224270 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1000 San Jose Ave | 99 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | 6004965.43171 | 2096836.50087 | 37.7377947878061 | -122.42533066077699 | (37.7377947878061, -122.425330660777) | ||||
| 158903 | 158903 | 245820 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 97 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004968.56772 | 2096865.41877 | 37.737874367011706 | -122.425321875304 | (37.7378743670117, -122.425321875304) | ||||
| 149603 | 149603 | 245819 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 96 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6004972.44653 | 2096874.3096599998 | 37.737898998529296 | -122.42530909685499 | (37.7378989985293, -122.425309096855) | ||||
| 42717 | 42717 | 245818 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 95 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6004977.00826 | 2096882.72633 | 37.7379223665264 | -122.42529392347001 | (37.7379223665264, -122.42529392347) | ||||
| 188089 | 188089 | 245817 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 94 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6004980.52596 | 2096892.5237200002 | 37.737949466684206 | -122.425282458027 | (37.7379494666842, -122.425282458027) | ||||
| 130875 | 130875 | 245816 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 93 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6004985.63853 | 2096904.07268 | 37.73798146635921 | -122.425265602924 | (37.7379814663592, -122.425265602924) | ||||
| 25070 | 25070 | 245815 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 92 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004991.22077 | 2096914.7584400002 | 37.7380111224129 | -122.42524706251699 | (37.7380111224129, -122.425247062517) | ||||
| 134377 | 134377 | 224017 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 91 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6004994.74234 | 2096924.0742900001 | 37.7380369005842 | -122.425235549407 | (37.7380369005842, -122.425235549407) | ||||
| 56985 | 56985 | 224016 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 90 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6005001.85234 | 2096930.1779200002 | 37.7380540614461 | -122.425211400785 | (37.7380540614461, -122.425211400785) | ||||
| 180081 | 180081 | 224015 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 89 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6005001.605909999 | 2096940.71634 | 37.7380829836485 | -122.42521300248801 | (37.7380829836485, -122.425213002488) | ||||
| 62712 | 62712 | 224182 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 88 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005012.77869 | 2096942.55547 | 37.7380886646675 | -122.42517450342 | (37.7380886646675, -122.42517450342) | ||||
| 29174 | 29174 | 224014 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 87 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005008.4122 | 2096950.18798 | 37.7381093751439 | -122.425190143511 | (37.7381093751439, -122.425190143511) | ||||
| 183400 | 183400 | 224013 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 86 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005014.2312 | 2096961.20623 | 37.738139957502796 | -122.42517080809601 | (37.7381399575028, -122.425170808096) | ||||
| 162867 | 162867 | 224012 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 85 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6005023.67021 | 2096975.18783 | 37.738178881048704 | -122.425139167258 | (37.7381788810487, -122.425139167258) | ||||
| 57543 | 57543 | 224011 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 84 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6005029.023080001 | 2096988.2407799999 | 37.738215023894 | -122.42512158818701 | (37.738215023894, -122.425121588187) | ||||
| 148496 | 148496 | 227674 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 83 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005065.1015800005 | 2097012.05309 | 37.7382824451638 | -122.42499854026899 | (37.7382824451638, -122.424998540269) | ||||
| 30126 | 30126 | 223714 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 82 | Front Yard : Yard 7 | Tree 1 | Private 1 | 34 | 6004606.42672 | 2096213.68372 | 37.736064383369396 | -122.42652758019699 | (37.7360643833694, -122.426527580197) | ||||
| 147305 | 147305 | 240212 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1000 San Jose Ave | 82 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6005076.07974 | 2097014.3587200001 | 37.738289396023 | -122.42496074716298 | (37.738289396023, -122.424960747163) | ||||
| 54591 | 54591 | 248654 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 81 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005089.97805 | 2097022.6793 | 37.7383130275105 | -122.42491328541901 | (37.7383130275105, -122.424913285419) | ||||
| 77269 | 77269 | 223713 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 81 | Front Yard : Yard 7 | Tree 1 | Private 1 | 52 | 6004590.4575 | 2096203.6023099998 | 37.7360357993049 | -122.426582074619 | (37.7360357993049, -122.426582074619) | ||||
| 171214 | 171214 | 239557 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1100 San Jose Ave | 81 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 5ft | 6004609.877180001 | 2096414.58836 | 37.736616217249704 | -122.42652995170299 | (37.7366162172497, -122.426529951703) | |||
| 75841 | 75841 | 224181 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 80 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6005034.65052 | 2097002.30081 | 37.7382539474614 | -122.425103131407 | (37.7382539474614, -122.425103131407) | ||||
| 152844 | 152844 | 223706 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 80 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004536.52923 | 2096375.8684900003 | 37.736505754442504 | -122.42678079059999 | (37.7365057544425, -122.4267807906) | ||||
| 162839 | 162839 | 243981 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 80 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6004609.846480001 | 2096189.0617 | 37.7359969701789 | -122.426514004025 | (37.7359969701789, -122.426514004025) | ||||
| 32831 | 32831 | 243980 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 79 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004603.12758 | 2096184.7977099998 | 37.7359848823907 | -122.426536930441 | (37.7359848823907, -122.426536930441) | ||||
| 164547 | 164547 | 224180 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 79 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6005045.53711 | 2097024.85946 | 37.7383165034054 | -122.425067095563 | (37.7383165034054, -122.425067095563) | ||||
| 181452 | 181452 | 220191 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 79 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6004894.80738 | 2096532.47755 | 37.7369560180099 | -122.425553212433 | (37.7369560180099, -122.425553212433) | ||||
| 181738 | 181738 | 223705 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 79 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6004537.44257 | 2096386.8120900001 | 37.7365358547364 | -122.426778411906 | (37.7365358547364, -122.426778411906) | ||||
| 53208 | 53208 | 220190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004897.78998 | 2096535.50608 | 37.73696450219779 | -122.425543115723 | (37.7369645021978, -122.425543115723) | ||||
| 74483 | 74483 | 243979 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004594.177069999 | 2096179.3802599998 | 37.735969501297 | -122.42656749031099 | (37.735969501297, -122.426567490311) | ||||
| 130832 | 130832 | 221572 | Undocumented 2 | Acca sellowiana :: Pineapple Guava Tree 363 | 1000 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005057.8171 | 2097028.65705 | 37.7383276244099 | -122.425024907477 | (37.7383276244099, -122.425024907477) | ||||
| 137317 | 137317 | 223704 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6004560.21701 | 2096406.8969299998 | 37.7365922907993 | -122.426701100777 | (37.7365922907993, -122.426701100777) | ||||
| 175483 | 175483 | 199514 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 1301 Minnesota St | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015365.49861 | 2102246.30047 | 37.753231058975 | -122.389750029948 | (37.753231058975, -122.389750029948) | ||||
| 42783 | 42783 | 233286 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1201 San Jose Ave | 77 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6004589.58697 | 2096178.94515 | 37.735968047088704 | -122.426583329156 | (37.7359680470887, -122.426583329156) | ||||
| 47865 | 47865 | 188233 | Undocumented 2 | Archontophoenix cunninghamiana :: King Palm 210 | 1301 Minnesota St | 77 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6015365.735640001 | 2102250.10516 | 37.753241518993505 | -122.38974947596701 | (37.7532415189935, -122.389749475967) | ||||
| 49562 | 49562 | 223703 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 77 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004573.37155 | 2096423.41392 | 37.7366383864359 | -122.426656795699 | (37.7366383864359, -122.426656795699) | ||||
| 146508 | 146508 | 220189 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 77 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6004903.37501 | 2096531.93768 | 37.7369550197456 | -122.425523551887 | (37.7369550197456, -122.425523551887) | ||||
| 35089 | 35089 | 243978 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004588.46206 | 2096170.32088 | 37.7359443031923 | -122.42658660449601 | (37.7359443031923, -122.426586604496) | ||||
| 158705 | 158705 | 190031 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1301 Minnesota St | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6015368.80756 | 2102249.49615 | 37.753240017127 | -122.389738810018 | (37.753240017127, -122.389738810018) | ||||
| 159461 | 159461 | 223702 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6004596.80195 | 2096429.4382 | 37.7366562523786 | -122.426576215516 | (37.7366562523786, -122.426576215516) | ||||
| 171542 | 171542 | 233283 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1000 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005053.15059 | 2097036.60001 | 37.738349170383394 | -122.425041606983 | (37.7383491703834, -122.425041606983) | ||||
| 178188 | 178188 | 220188 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004898.43848 | 2096540.4001099998 | 37.736977976744 | -122.425541221768 | (37.736977976744, -122.425541221768) | ||||
| 28978 | 28978 | 233911 | Undocumented 2 | Paulownia fortunei :: Dragon tree 365 | 1100 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 42 | 6004583.96879 | 2096449.39973 | 37.7367103367208 | -122.426622006327 | (37.7367103367208, -122.426622006327) | ||||
| 53546 | 53546 | 223712 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 59 | 6004557.86024 | 2096180.22234 | 37.7359697602838 | -122.426693112116 | (37.7359697602838, -122.426693112116) | ||||
| 56140 | 56140 | 224179 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005053.30155 | 2097043.93815 | 37.7383693277877 | -122.425041607006 | (37.7383693277877, -122.425041607006) | ||||
| 65971 | 65971 | 220202 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6003538.0871 | 2095667.4408599997 | 37.7345040713105 | -122.430182303581 | (37.7345040713105, -122.430182303581) | ||||
| 68649 | 68649 | 194407 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1301 Minnesota St | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6015362.28462 | 2102262.66677 | 37.7532758191494 | -122.38976228771999 | (37.7532758191494, -122.38976228772) | ||||
| 182151 | 182151 | 220187 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004907.90324 | 2096539.115 | 37.736974982905295 | -122.42550840641 | (37.7369749829053, -122.42550840641) | ||||
| 36036 | 36036 | 194406 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1301 Minnesota St | 74 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6015366.03061 | 2102265.75372 | 37.753284502988 | -122.38974954880399 | (37.753284502988, -122.389749548804) | ||||
| 36380 | 36380 | 243977 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 74 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6004578.54944 | 2096162.87225 | 37.73592329053071 | -122.426620346145 | (37.7359232905307, -122.426620346145) | ||||
| 170910 | 170910 | 220201 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 74 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 5ft | 6003510.43036 | 2095660.01539 | 37.734482116158105 | -122.430277392481 | (37.7344821161581, -122.430277392481) | |||
| 171906 | 171906 | 220186 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 74 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004903.97159 | 2096543.19438 | 37.736985961816295 | -122.42552229012699 | (37.7369859618163, -122.425522290127) | ||||
| 44798 | 44798 | 227608 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004572.06439 | 2096162.43718 | 37.7359217292935 | -122.426642736581 | (37.7359217292935, -122.426642736581) | ||||
| 158439 | 158439 | 220185 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004909.032430001 | 2096549.6336299998 | 37.7370039284954 | -122.42550525066002 | (37.7370039284954, -122.42550525066) | ||||
| 160587 | 160587 | 220200 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 5ft | 6003513.54179 | 2095663.72893 | 37.7344924889333 | -122.430266900093 | (37.7344924889333, -122.430266900093) | |||
| 167887 | 167887 | 233513 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1001 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 0 | 6005382.193969999 | 2097506.55271 | 37.7396581363049 | -122.42393734385901 | (37.7396581363049, -122.423937343859) | ||||
| 173662 | 173662 | 223984 | Undocumented 2 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 107 | 1000 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005069.130369999 | 2097045.62125 | 37.738374843333396 | -122.424986998352 | (37.7383748433334, -122.424986998352) | ||||
| 184005 | 184005 | 197977 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1301 Minnesota St | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015364.560269999 | 2102275.50149 | 37.7533111867689 | -122.389755314382 | (37.7533111867689, -122.389755314382) | ||||
| 40618 | 40618 | 245485 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1300 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 5ft | 6003516.634869999 | 2095667.30987 | 37.7345024965788 | -122.430256461687 | (37.7345024965788, -122.430256461687) | |||
| 47906 | 47906 | 241078 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 1201 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004568.5686800005 | 2096152.29188 | 37.735893674955 | -122.42665410042 | (37.735893674955, -122.42665410042) | ||||
| 62541 | 62541 | 224210 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6005362.146369999 | 2097481.1402 | 37.739587227456205 | -122.42400485326401 | (37.7395872274562, -122.424004853264) | ||||
| 132918 | 132918 | 191519 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1301 Minnesota St | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015362.355280001 | 2102287.9269 | 37.7533451820439 | -122.38976380757 | (37.7533451820439, -122.38976380757) | ||||
| 163471 | 163471 | 221974 | Undocumented 2 | Albizia distachya :: Plume Albizia Tree 360 | 1100 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004683.48895 | 2096521.1736700002 | 37.736913037616794 | -122.42628303026001 | (37.7369130376168, -122.42628303026) | ||||
| 165475 | 165475 | 220184 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004926.8696 | 2096549.97699 | 37.737005879105396 | -122.425443603957 | (37.7370058791054, -122.425443603957) | ||||
| 183480 | 183480 | 223983 | Undocumented 2 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 107 | 1000 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005068.86996 | 2097059.31242 | 37.7384124214878 | -122.424988872563 | (37.7384124214878, -122.424988872563) | ||||
| 38042 | 38042 | 220199 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 71 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 5ft | 6003519.67627 | 2095667.91857 | 37.73450434019979 | -122.43024598997499 | (37.7345043401998, -122.430245989975) | |||
| 41339 | 41339 | 234481 | Undocumented 2 | Pinus halepensis :: Allepo Pine 164 | 1201 San Jose Ave | 71 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004557.918269999 | 2096148.5785299998 | 37.73588287679821 | -122.42669065877199 | (37.7358828767982, -122.426690658772) | ||||
| 49482 | 49482 | 191518 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1301 Minnesota St | 71 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015362.96067 | 2102295.09834 | 37.7533649068725 | -122.38976221485201 | (37.7533649068725, -122.389762214852) | ||||
| 146828 | 146828 | 224178 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 71 | Front Yard : Yard 7 | Tree 1 | Private 1 | 29 | 6005061.63649 | 2097066.04261 | 37.7384304924721 | -122.425014361121 | (37.7384304924721, -122.425014361121) | ||||
| 159049 | 159049 | 224115 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1100 San Jose Ave | 71 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004680.7613 | 2096547.43611 | 37.7369849941684 | -122.426294330213 | (37.7369849941684, -122.426294330213) | ||||
| 173065 | 173065 | 220183 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 71 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6004926.20278 | 2096562.8505 | 37.7370411891885 | -122.425446825336 | (37.7370411891885, -122.425446825336) | ||||
| 37362 | 37362 | 189286 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1301 Minnesota St | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015368.15632 | 2102301.56591 | 37.7533829535663 | -122.389744698757 | (37.7533829535663, -122.389744698757) | ||||
| 42488 | 42488 | 220198 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 5ft | 6003524.19467 | 2095672.0219999999 | 37.7345158632135 | -122.430230661025 | (37.7345158632135, -122.430230661025) | |||
| 74654 | 74654 | 220182 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6004985.47233 | 2096611.09675 | 37.737177011099604 | -122.425245335799 | (37.7371770110996, -122.425245335799) | ||||
| 133017 | 133017 | 224114 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1100 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004687.50549 | 2096549.1812200001 | 37.736990167061 | -122.42627113673001 | (37.736990167061, -122.42627113673) | ||||
| 134025 | 134025 | 243976 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004556.64322 | 2096143.57753 | 37.735869073092395 | -122.426694711107 | (37.7358690730924, -122.426694711107) | ||||
| 166595 | 166595 | 224209 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6005356.45271 | 2097454.81484 | 37.7395146225008 | -122.424022667913 | (37.7395146225008, -122.424022667913) |
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");