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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35110 | 35110 | 176590 | Undocumented 2 | Juglans nigra :: Eastern black walnut 288 | 4103 Alemany Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | Width 10ft | 5991596.71486 | 2086796.0596 | 37.7094618598487 | -122.470821200944 | (37.7094618598487, -122.470821200944) | |||
| 2457 | 2457 | 253065 | Undocumented 2 | Private shrub :: Private Shrub 64 | 1x Drake St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6001423.0 | 2086924.0 | 37.710376533009295 | -122.436869130393 | (37.7103765330093, -122.436869130393) | ||||
| 780 | 780 | 251383 | Undocumented 2 | Persea americana :: Avocado 113 | 49x Milan Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997587.0 | 2087495.0 | 37.711725600519706 | -122.450168218052 | (37.7117256005197, -122.450168218052) | ||||
| 41322 | 41322 | 211727 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5992176.51123 | 2088212.22362 | 37.7133838194885 | -122.468920334526 | (37.7133838194885, -122.468920334526) | ||||
| 59360 | 59360 | 207117 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 41 Ralston St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | 5992170.67066 | 2088214.0686700002 | 37.7133885481037 | -122.46894065558399 | (37.7133885481037, -122.468940655584) | ||||
| 180672 | 180672 | 211726 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992180.41529 | 2088216.9630599997 | 37.7133970584078 | -122.46890718553699 | (37.7133970584078, -122.468907185537) | ||||
| 188904 | 188904 | 211725 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992180.34622 | 2088219.99909 | 37.7134053906231 | -122.468907645067 | (37.7134053906231, -122.468907645067) | ||||
| 157520 | 157520 | 203877 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Ralston St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992177.10886 | 2088222.03993 | 37.7134108072361 | -122.468918982843 | (37.7134108072361, -122.468918982843) | ||||
| 179961 | 179961 | 204383 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 41 Ralston St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5992172.93339 | 2088222.9751099998 | 37.7134131337717 | -122.46893348261699 | (37.7134131337717, -122.468933482617) | ||||
| 161892 | 161892 | 203876 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 5992169.18145 | 2088225.46502 | 37.7134197536892 | -122.468946631609 | (37.7134197536892, -122.468946631609) | ||||
| 155707 | 155707 | 203875 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992168.26739 | 2088231.33888 | 37.7134358290799 | -122.468950218092 | (37.7134358290799, -122.468950218092) | ||||
| 154924 | 154924 | 204382 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 41 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992173.48186 | 2088232.60675 | 37.7134396116198 | -122.46893228741999 | (37.7134396116198, -122.46893228742) | ||||
| 37767 | 37767 | 211724 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992178.335940001 | 2088233.1934099998 | 37.71344150289679 | -122.468915552827 | (37.7134415028968, -122.468915552827) | ||||
| 60662 | 60662 | 207115 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 47 Ralston St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992168.43399 | 2088239.2563900002 | 37.7134575782774 | -122.468950218099 | (37.7134575782774, -122.468950218099) | ||||
| 164753 | 164753 | 207116 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 47 Ralston St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992178.8337 | 2088240.4151599999 | 37.7134613608383 | -122.46891435762801 | (37.7134613608383, -122.468914357628) | ||||
| 170319 | 170319 | 211723 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 47 Ralston St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992174.6999 | 2088241.1909400001 | 37.7134632521081 | -122.468928701793 | (37.7134632521081, -122.468928701793) | ||||
| 175716 | 175716 | 211722 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 47 Ralston St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992176.846480001 | 2088244.58976 | 37.7134727084689 | -122.468921529709 | (37.7134727084689, -122.468921529709) | ||||
| 29851 | 29851 | 210532 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 47 Ralston St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 5992170.38695 | 2088246.7586700001 | 37.7134782905637 | -122.46894401367099 | (37.7134782905637, -122.468944013671) | ||||
| 184062 | 184062 | 204381 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 47 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992175.93878 | 2088248.61457 | 37.7134837071825 | -122.46892495972901 | (37.7134837071825, -122.468924959729) | ||||
| 32977 | 32977 | 219173 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 47 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 5992177.27741 | 2088252.3205900001 | 37.71349396036 | -122.46892060252199 | (37.71349396036, -122.468920602522) | ||||
| 38627 | 38627 | 210531 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 47 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992169.14182 | 2088256.46113 | 37.7135048592377 | -122.46894902289 | (37.7135048592377, -122.46894902289) | ||||
| 172487 | 172487 | 219172 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 47 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992175.93719 | 2088256.51499 | 37.7135053997375 | -122.46892553980601 | (37.7135053997375, -122.468925539806) | ||||
| 150424 | 150424 | 206446 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 53 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 5992168.00552 | 2088268.19461 | 37.7135370108901 | -122.468953803676 | (37.7135370108901, -122.468953803676) | ||||
| 167246 | 167246 | 206445 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 53 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 5992171.9093 | 2088272.93373 | 37.7135502489179 | -122.46894065561001 | (37.7135502489179, -122.46894065561) | ||||
| 188129 | 188129 | 207114 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 53 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992175.21623 | 2088282.1627599997 | 37.7135757806697 | -122.468929896991 | (37.7135757806697, -122.468929896991) | ||||
| 68946 | 68946 | 207113 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 53 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992170.39113 | 2088282.9530900002 | 37.7135776719473 | -122.468946631596 | (37.7135776719473, -122.468946631596) | ||||
| 31147 | 31147 | 207112 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5992171.746719999 | 2088295.8735200001 | 37.7136132266511 | -122.46894288591899 | (37.7136132266511, -122.468942885919) | ||||
| 188401 | 188401 | 207079 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 59 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5992173.18035 | 2088300.4585900002 | 37.7136258989769 | -122.46893826428699 | (37.7136258989769, -122.468938264287) | ||||
| 90297 | 90297 | 107819 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 75X RALSTON ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 45 | Permit Number 775492 | 5992193.0 | 2088303.0 | 37.7136340221674 | -122.46886994586599 | (37.7136340221674, -122.468869945866) | ||||
| 171720 | 171720 | 207111 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | 5992171.5605 | 2088305.6585 | 37.713640083085 | -122.468944241206 | (37.713640083085, -122.468944241206) | ||||
| 162496 | 162496 | 207110 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992170.63195 | 2088310.84387 | 37.7136542672107 | -122.468947827707 | (37.7136542672107, -122.468947827707) | ||||
| 177754 | 177754 | 209147 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 75 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | 5992171.618 | 2088327.33496 | 37.7136996047335 | -122.46894561897 | (37.7136996047335, -122.46894561897) | ||||
| 112733 | 112733 | 107503 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4140 19th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992157.71887 | 2088336.37745 | 37.7137236301705 | -122.46899431666 | (37.7137236301705, -122.46899431666) | ||||||
| 153486 | 153486 | 207109 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 75 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 5992170.77084 | 2088338.0326 | 37.713728928924105 | -122.46894932506599 | (37.7137289289241, -122.468949325066) | ||||
| 186880 | 186880 | 206444 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 75 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992169.96835 | 2088350.8654599998 | 37.71376411849379 | -122.46895303206301 | (37.7137641184938, -122.468953032063) | ||||
| 47848 | 47848 | 209611 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 77 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | 5992168.85342 | 2088365.8404 | 37.7138051716457 | -122.468957974754 | (37.7138051716457, -122.468957974754) | ||||
| 71643 | 71643 | 207108 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 89 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | 5992168.92954 | 2088415.8272900002 | 37.7139424279717 | -122.468961347182 | (37.7139424279717, -122.468961347182) | ||||
| 136701 | 136701 | 207107 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 89 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | 5992169.5585900005 | 2088419.4087099999 | 37.7139522980308 | -122.46895943344299 | (37.7139522980308, -122.468959433443) | ||||
| 25761 | 25761 | 217537 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 89 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 5992163.635980001 | 2088434.33055 | 37.713992927605204 | -122.468980989298 | (37.7139929276052, -122.468980989298) | ||||
| 161920 | 161920 | 218151 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | 5994130.74614 | 2090030.24083 | 37.7184883759248 | -122.46229764153799 | (37.7184883759248, -122.462297641538) | ||||
| 61253 | 61253 | 218150 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5994126.47455 | 2090031.2465099997 | 37.7184908913149 | -122.46231247944999 | (37.7184908913149, -122.46231247945) | ||||
| 30020 | 30020 | 218148 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 5994122.86099 | 2090034.3755400002 | 37.7184992748049 | -122.462325196761 | (37.7184992748049, -122.462325196761) | ||||
| 176884 | 176884 | 218149 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5994121.0220800005 | 2090034.4141 | 37.7184992747921 | -122.462331555861 | (37.7184992747921, -122.462331555861) | ||||
| 91893 | 91893 | 107542 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 GARFIELD ST | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 40 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.46287353180901 | (37.7201106425596, -122.462873531809) | ||||
| 10146 | 10146 | 173882 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 201x Howth St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997459.0 | 2090748.0 | 37.7206502603184 | -122.450845024895 | (37.7206502603184, -122.450845024895) | |||||
| 134977 | 134977 | 189464 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6014119.82993 | 2095366.8489 | 37.7342723708559 | -122.39357639702699 | (37.7342723708559, -122.393576397027) | ||||
| 74942 | 74942 | 189463 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 22 | 6014124.78069 | 2095373.74732 | 37.7342915875929 | -122.393559763171 | (37.7342915875929, -122.393559763171) | ||||
| 147650 | 147650 | 189462 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6014132.345380001 | 2095385.42746 | 37.7343240791916 | -122.393534426582 | (37.7343240791916, -122.393534426582) | ||||
| 147254 | 147254 | 211258 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 426 Los Palmos Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5997445.84853 | 2095752.3652400002 | 37.734390310651605 | -122.451251210378 | (37.7343903106516, -122.451251210378) | |||
| 68047 | 68047 | 218985 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 735 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5998106.15759 | 2095768.84675 | 37.7344733504624 | -122.448969503563 | (37.7344733504624, -122.448969503563) | |||
| 883 | 883 | 251306 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 885 | 885 | 251305 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 887 | 887 | 251303 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 2 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 896 | 896 | 251302 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 28538 | 28538 | 212784 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 739 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 3ft | 5998105.0801800005 | 2095806.61255 | 37.734576984727795 | -122.448975948078 | (37.7345769847278, -122.448975948078) | |||
| 68601 | 68601 | 212785 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 743 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 3ft | 5998104.46417 | 2095821.7845 | 37.734618608054795 | -122.448979170379 | (37.7346186080548, -122.448979170379) | |||
| 36699 | 36699 | 218742 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998867.6092 | 2095887.4020200002 | 37.734842393562104 | -122.44634545 | (37.7348423935621, -122.44634545) | |||
| 132146 | 132146 | 218741 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998851.10975 | 2095900.2680400002 | 37.73487677824821 | -122.44640341939 | (37.7348767782482, -122.44640341939) | |||
| 61847 | 61847 | 218740 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998836.63311 | 2095909.61295 | 37.734901610308704 | -122.446454142063 | (37.7349016103087, -122.446454142063) | |||
| 153368 | 153368 | 218739 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998821.443390001 | 2095918.27736 | 37.7349245331257 | -122.446507281187 | (37.7349245331257, -122.446507281187) | |||
| 43628 | 43628 | 218738 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998805.22806 | 2095928.00663 | 37.734950321189 | -122.446564042812 | (37.734950321189, -122.446564042812) | |||
| 149374 | 149374 | 218737 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998790.02414 | 2095935.97535 | 37.7349713329455 | -122.446617181062 | (37.7349713329455, -122.446617181062) | |||
| 99073 | 99073 | 108311 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 439x ARLINGTON ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003949.9 | 2096014.9 | 37.7354814316621 | -122.42878329168998 | (37.7354814316621, -122.42878329169) | |||||
| 433 | 433 | 251301 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 2 | Back Yard : Yard 13 | Tree 1 | Mayor Office of Housing 7 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 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) | ||||
| 47731 | 47731 | 227663 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6 Unnamed 011 | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 10ft | 6002739.4908 | 2096074.90228 | 37.735577602816896 | -122.432972414242 | (37.7355776028169, -122.432972414242) | |||
| 27928 | 27928 | 231945 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 33 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002666.1416 | 2096136.6991599998 | 37.7357431221521 | -122.433230424364 | (37.7357431221521, -122.433230424364) | |||
| 155248 | 155248 | 231944 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 33 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 2ft | 6002664.28784 | 2096138.10096 | 37.7357468660117 | -122.43323693366001 | (37.7357468660117, -122.43323693366) | |||
| 155846 | 155846 | 231943 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 33 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002661.77062 | 2096140.53935 | 37.7357534184718 | -122.43324581083901 | (37.7357534184718, -122.433245810839) | |||
| 62808 | 62808 | 231942 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 31 Penny Ln | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002659.32372 | 2096145.42523 | 37.735766695166504 | -122.433254619725 | (37.7357666951665, -122.433254619725) | |||
| 132003 | 132003 | 231941 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 31 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002655.75902 | 2096147.9144099997 | 37.7357733276597 | -122.43326712208 | (37.7357733276597, -122.43326712208) | |||
| 184761 | 184761 | 231940 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 31 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002651.97591 | 2096151.4784799998 | 37.735782899162395 | -122.433280456348 | (37.7357828991624, -122.433280456348) | |||
| 46775 | 46775 | 224477 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 23 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002584.32363 | 2096230.7970099999 | 37.735996851473296 | -122.43352002314501 | (37.7359968514733, -122.433520023145) | |||
| 183893 | 183893 | 240363 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 19 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002113.49716 | 2096265.44164 | 37.7360652530044 | -122.435150333941 | (37.7360652530044, -122.435150333941) | |||
| 30330 | 30330 | 233958 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 19 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002544.64531 | 2096274.1188599998 | 37.73611355200129 | -122.433660302082 | (37.7361135520013, -122.433660302082) | |||
| 171592 | 171592 | 223338 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 17 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002542.32415 | 2096276.52832 | 37.736120036118706 | -122.433668499417 | (37.7361200361187, -122.433668499417) | |||
| 161192 | 161192 | 233957 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 15 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002524.54294 | 2096295.7854099998 | 37.7361719027113 | -122.43373135214199 | (37.7361719027113, -122.433731352142) | |||
| 177217 | 177217 | 245789 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 13 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | Width 2ft | 6002510.68516 | 2096313.6496700002 | 37.736220167514404 | -122.433780540537 | (37.7362201675144, -122.433780540537) | |||
| 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) | ||||
| 131366 | 131366 | 237944 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 26 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 2ft | 6002164.0262 | 2096336.8178599998 | 37.736264104808 | -122.43498073797701 | (37.736264104808, -122.434980737977) | |||
| 164865 | 164865 | 239558 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 26 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 2ft | 6002169.792830001 | 2096347.5297 | 37.7362938444778 | -122.434961566227 | (37.7362938444778, -122.434961566227) | |||
| 52362 | 52362 | 237943 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 22 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 3ft | 6002178.91966 | 2096366.0304900003 | 37.7363451615923 | -122.43493133373501 | (37.7363451615923, -122.434931333735) | |||
| 163239 | 163239 | 220552 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 13 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6002169.64489 | 2096371.31931 | 37.736359156858704 | -122.434963778568 | (37.7363591568587, -122.434963778568) | |||
| 71286 | 71286 | 240425 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002456.8751300005 | 2096374.3168900001 | 37.736383692152295 | -122.433970918943 | (37.7363836921523, -122.433970918943) | |||
| 73730 | 73730 | 240424 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002452.23233 | 2096379.1355 | 37.7363966594644 | -122.43398731536502 | (37.7363966594644, -122.433987315365) | |||
| 29920 | 29920 | 240423 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002449.92079 | 2096381.9214299999 | 37.7364041778047 | -122.433995506402 | (37.7364041778047, -122.433995506402) | |||
| 72621 | 72621 | 220551 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 11 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | Width 5ft | 6002176.285680001 | 2096385.2225400002 | 37.736397708979794 | -122.434941812622 | (37.7363977089798, -122.434941812622) | |||
| 188488 | 188488 | 240422 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002442.71855 | 2096389.33655 | 37.7364241292793 | -122.43402093743201 | (37.7364241292793, -122.434020937432) | |||
| 35387 | 35387 | 240421 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002440.8921300005 | 2096392.57557 | 37.736432919229706 | -122.43402748359101 | (37.7364329192297, -122.434027483591) | |||
| 159982 | 159982 | 220096 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002436.28409 | 2096397.8300700001 | 37.736447085360105 | -122.43404379100402 | (37.7364470853601, -122.434043791004) | |||
| 134638 | 134638 | 233923 | Undocumented 2 | Persea americana :: Avocado 113 | 20 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002185.25785 | 2096400.06868 | 37.736438982481395 | -122.43491185351299 | (37.7364389824814, -122.434911853513) | |||
| 166281 | 166281 | 220095 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002427.25103 | 2096406.93673 | 37.7364715774983 | -122.43407567285601 | (37.7364715774983, -122.434075672856) | |||
| 50796 | 50796 | 225251 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 20 Ohlone Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002182.75585 | 2096407.15248 | 37.736458290902796 | -122.43492101042 | (37.7364582909028, -122.43492101042) | |||
| 187310 | 187310 | 227505 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 11 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002170.3179 | 2096422.89629 | 37.7365008135581 | -122.434965139225 | (37.7365008135581, -122.434965139225) | |||
| 75944 | 75944 | 242822 | Undocumented 2 | Tree(s) :: 17 | 18 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 46 | Width 5ft | 6002178.85689 | 2096424.55585 | 37.7365058551638 | -122.434935735002 | (37.7365058551638, -122.434935735002) | |||
| 174189 | 174189 | 242821 | Undocumented 2 | Tree(s) :: 17 | 18 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 37 | Width 5ft | 6002176.86514 | 2096431.6975599998 | 37.7365253515621 | -122.43494313191499 | (37.7365253515621, -122.434943131915) | |||
| 27063 | 27063 | 233956 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 3 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002403.3233199995 | 2096434.7165299999 | 37.7365464964208 | -122.434160386288 | (37.7365464964208, -122.434160386288) | |||
| 45661 | 45661 | 233955 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 3 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002401.2653 | 2096437.12023 | 37.736552979622104 | -122.434167673516 | (37.7365529796221, -122.434167673516) | |||
| 71556 | 71556 | 227504 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 16 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002174.41423 | 2096447.2518799999 | 37.7365679209746 | -122.434952717804 | (37.7365679209746, -122.434952717804) |
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");