Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | 5 | 188702 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Evans Ave | 2 | : 4 | Tree 1 | DPW 2 | 17 | Width 4ft | 6015994.71985 | 2098219.31717 | 37.7422086702947 | -122.387293152263 | (37.7422086702947, -122.387293152263) | |||
| 7 | 7 | 188697 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Evans Ave | 13 | : 4 | Tree 1 | DPW 2 | 15 | Width 3ft | 6017236.81305 | 2097292.98379 | 37.7397338556296 | -122.38293388291001 | (37.7397338556296, -122.38293388291) | |||
| 14 | 14 | 196590 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | Permit Number 772992 | 6007565.6944699995 | 2109618.27361 | 37.773037177355796 | -122.41724576098301 | (37.7730371773558, -122.417245760983) | ||
| 15 | 15 | 196591 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | Permit Number 772992 | 6007555.65106 | 2109624.06249 | 37.7730525072055 | -122.417280912782 | (37.7730525072055, -122.417280912782) | ||
| 29 | 29 | 188686 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Evans Ave | 20 | : 4 | Tree 1 | DPW 2 | 12 | Width 3ft | 6017760.57019 | 2097020.5910900002 | 37.739014844955705 | -122.381104000867 | (37.7390148449557, -122.381104000867) | |||
| 30 | 30 | 196592 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | Permit Number 772992 | 6007533.59843 | 2109642.31042 | 37.7731013709756 | -122.41735848920901 | (37.7731013709756, -122.417358489209) | ||
| 131 | 131 | 237033 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 7 | : 4 | Tree 1 | DPW 2 | 6 | Width 4ft | 6005718.98472 | 2109769.85153 | 37.7733493059578 | -122.423644547079 | (37.7733493059578, -122.423644547079) | |||
| 135 | 135 | 237030 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 5 | Width 4ft | 6005725.94025 | 2109733.85532 | 37.773250861665204 | -122.423617927146 | (37.7732508616652, -122.423617927146) | |||
| 715 | 715 | 246970 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 2 | : 4 | Tree 1 | DPW 2 | 9 | Width 4ft | 6002947.4073 | 2106634.57369 | 37.764583763244794 | -122.43300776749099 | (37.7645837632448, -122.433007767491) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 1541 | 1541 | 196583 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6010636.210390001 | 2110621.8756 | 37.7759651028325 | -122.406695151275 | (37.7759651028325, -122.406695151275) | |||
| 1544 | 1544 | 196581 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 3 | : 4 | Tree 1 | DPW 2 | 10 | Width 3ft | 6010649.28152 | 2110608.88242 | 37.77593015789721 | -122.40664901875 | (37.7759301578972, -122.40664901875) | |||
| 1554 | 1554 | 196582 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6010641.65206 | 2110616.23142 | 37.7759499096844 | -122.40667592917801 | (37.7759499096844, -122.406675929178) | |||
| 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) | ||
| 2250 | 2250 | 200335 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 7 | : 4 | Tree 1 | Purchasing Dept 15 | 4 | Width 2ft | 6015505.4551 | 2098329.2709 | 37.7424834725483 | -122.388992567847 | (37.7424834725483, -122.388992567847) | |||
| 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) | ||
| 2514 | 2514 | 246848 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 10 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001221.8841699995 | 2109765.97896 | 37.773083798207296 | -122.439200331843 | (37.7730837982073, -122.439200331843) | |||
| 2519 | 2519 | 246843 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 5 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001198.912769999 | 2109877.26909 | 37.7733880658265 | -122.439287771129 | (37.7733880658265, -122.439287771129) | |||
| 2532 | 2532 | 246847 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 9 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001212.96216 | 2109784.10249 | 37.773133053181404 | -122.43923249339198 | (37.7731330531814, -122.439232493392) | |||
| 2533 | 2533 | 246849 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 11 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001216.8657599995 | 2109748.1446700003 | 37.7730345441487 | -122.439216412614 | (37.7730345441487, -122.439216412614) | |||
| 2535 | 2535 | 246841 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 3 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001195.01805 | 2109899.62825 | 37.7734492368388 | -122.439302846449 | (37.7734492368388, -122.439302846449) | |||
| 2546 | 2546 | 246846 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 8 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001207.38463 | 2109809.38993 | 37.773202168766105 | -122.43925359959101 | (37.7732021687661, -122.439253599591) | |||
| 2552 | 2552 | 246840 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 2 | : 4 | Tree 1 | DPW for City Agency 10 | 19 | Width 3ft | 6001188.51269 | 2109936.2184200003 | 37.7735493340682 | -122.43932797261999 | (37.7735493340682, -122.43932797262) | |||
| 2553 | 2553 | 246842 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 4 | : 4 | Tree 1 | DPW for City Agency 10 | 15 | Width 4ft | 6001208.43411 | 2109888.06605 | 37.7734182533891 | -122.439255609578 | (37.7734182533891, -122.439255609578) | |||
| 2554 | 2554 | 246844 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 6 | : 4 | Tree 1 | DPW for City Agency 10 | 17 | Width 3ft | 6001203.63374 | 2109838.69012 | 37.773282406297895 | -122.439268674924 | (37.7732824062979, -122.439268674924) | |||
| 2565 | 2565 | 191072 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 779704 | 6008614.31812 | 2108613.9778 | 37.770338555601505 | -122.41354738542101 | (37.7703385556015, -122.413547385421) | ||
| 3210 | 3210 | 194747 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1580 Burke Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6016181.61808 | 2099214.241 | 37.74495087589921 | -122.386716274933 | (37.7449508758992, -122.386716274933) | |||
| 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) | |||
| 5187 | 5187 | 247186 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.770700815109294 | -122.439956869431 | (37.7707008151093, -122.439956869431) | ||
| 22286 | 22286 | 188618 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 15 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015989.5781 | 2098825.23782 | 37.7438721192948 | -122.387353189223 | (37.7438721192948, -122.387353189223) | |||
| 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) | |||
| 22364 | 22364 | 249565 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Franklin St | 3 | : 4 | Tree 1 | Private 1 | 25 | Width 4ft | 6005937.376069999 | 2114355.05187 | 37.785951472517 | -122.423215093814 | (37.785951472517, -122.423215093814) | |||
| 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) | |||
| 22878 | 22878 | 211497 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 500 Junipero Serra Blvd | 69 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991316.04145 | 2093239.9376700001 | 37.7271389322076 | -122.472260663898 | (37.7271389322076, -122.472260663898) | |||
| 22880 | 22880 | 230389 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 51 13th St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008142.81587 | 2108281.73826 | 37.7693998171644 | -122.41515479496701 | (37.7693998171644, -122.415154794967) | |||
| 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) | |||
| 23424 | 23424 | 197132 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016788.78445 | 2098277.43468 | 37.742412193171795 | -122.384551543811 | (37.7424121931718, -122.384551543811) | |||
| 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) | |||
| 23455 | 23455 | 194596 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 800 Wisconsin St | 7 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6012720.64304 | 2103613.2936299997 | 37.7568375049672 | -122.398992475934 | (37.7568375049672, -122.398992475934) | |||
| 23459 | 23459 | 240288 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 3980 22nd St | 2 | : 4 | Tree 1 | Private 1 | 20 | 6001954.916780001 | 2102957.6016 | 37.7544313427449 | -122.43617736779 | (37.7544313427449, -122.43617736779) | ||||
| 23467 | 23467 | 205659 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1598 10th Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5993106.7424 | 2104692.3682 | 37.7586878807581 | -122.466902491455 | (37.7586878807581, -122.466902491455) | |||
| 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) | |||
| 23509 | 23509 | 188616 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 13 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015976.85216 | 2098785.54996 | 37.7437624397877 | -122.38739442491999 | (37.7437624397877, -122.38739442492) | |||
| 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) | |||
| 23554 | 23554 | 193631 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2 Industrial St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012126.8471099995 | 2097436.10996 | 37.7398431844134 | -122.400612133368 | (37.7398431844134, -122.400612133368) | |||
| 23570 | 23570 | 250043 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Daniel Burnham Ct | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006138.25466 | 2114733.68143 | 37.787002430166396 | -122.422547022523 | (37.7870024301664, -122.422547022523) | |||
| 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) | |||
| 23657 | 23657 | 196979 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1551 20th St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013315.21298 | 2104723.80911 | 37.7599198521353 | -122.39701407983802 | (37.7599198521353, -122.397014079838) | |||
| 23679 | 23679 | 191569 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1610 Innes Ave | 8 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6015206.39657 | 2097489.64193 | 37.7401614427971 | -122.38996799323401 | (37.7401614427971, -122.389967993234) | |||
| 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) | |||
| 23710 | 23710 | 199357 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 929 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 23 | Width 7ft | 6011910.785069999 | 2104052.6476 | 37.757998712287204 | -122.401824164069 | (37.7579987122872, -122.401824164069) | |||
| 23714 | 23714 | 234376 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6008587.75214 | 2108113.66978 | 37.7689633348285 | -122.41360388622499 | (37.7689633348285, -122.413603886225) | |||
| 23726 | 23726 | 192170 | Undocumented 2 | Ficus rubiginosa :: Port Jackson Fig 188 | 1601 Kansas St | 9 | : 4 | Tree 1 | Private 1 | 51 | Width 7ft | 6011813.79085 | 2100866.0430099997 | 37.749243580141204 | -122.40193560806001 | (37.7492435801412, -122.40193560806) | |||
| 23741 | 23741 | 234546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 390 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6006093.30748 | 2107339.39133 | 37.7666969650198 | -122.422177005484 | (37.7666969650198, -122.422177005484) | |||
| 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) | |||
| 23814 | 23814 | 247646 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.769089824469496 | -122.43773118404499 | (37.7690898244695, -122.437731184045) | |||
| 23825 | 23825 | 247187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6000970.93564 | 2108908.88323 | 37.770716144966 | -122.440006923906 | (37.770716144966, -122.440006923906) | |||
| 23828 | 23828 | 177148 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991345.1062 | 2088786.2704900003 | 37.7149119421181 | -122.47183574413401 | (37.7149119421181, -122.471835744134) | |||
| 23879 | 23879 | 193824 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1550 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 14 | Width 6ft | 6015655.00087 | 2098203.32161 | 37.742145929985796 | -122.388466689285 | (37.7421459299858, -122.388466689285) | |||
| 23924 | 23924 | 215624 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 66 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991139.11135 | 2090614.21248 | 37.7199191010706 | -122.47268094048201 | (37.7199191010706, -122.472680940482) | |||
| 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) | |||
| 23951 | 23951 | 222885 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006051.02822 | 2109339.24494 | 37.7721857010308 | -122.422465357814 | (37.7721857010308, -122.422465357814) | |||
| 23966 | 23966 | 221105 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009452.05657 | 2105439.4087799997 | 37.761668922891296 | -122.41042544467301 | (37.7616689228913, -122.410425444673) | |||
| 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) | |||
| 24013 | 24013 | 232628 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Starview Way | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997489.976480001 | 2102197.32823 | 37.7520891340271 | -122.451563373145 | (37.7520891340271, -122.451563373145) | |||
| 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) | |||
| 24055 | 24055 | 188977 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Thomas Ave | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6012688.07294 | 2095454.3657900002 | 37.7344330140672 | -122.398532612087 | (37.7344330140672, -122.398532612087) | |||
| 24067 | 24067 | 201949 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 18 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013468.57071 | 2092447.06427 | 37.7262190300648 | -122.395623522912 | (37.7262190300648, -122.395623522912) | |||
| 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) | |||
| 24091 | 24091 | 193642 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2000 Oakdale Ave | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012823.32202 | 2097168.087 | 37.739146068631705 | -122.398185200408 | (37.7391460686317, -122.398185200408) | |||
| 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) | |||
| 24219 | 24219 | 189857 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6017207.28329 | 2098227.98563 | 37.7422995503725 | -122.383101045278 | (37.7422995503725, -122.383101045278) | |||
| 24236 | 24236 | 213361 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Elmhurst Dr | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991216.12738 | 2094471.85178 | 37.730515676960394 | -122.47269584493701 | (37.7305156769604, -122.472695844937) | |||
| 24261 | 24261 | 250049 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Daniel Burnham Ct | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005972.08253 | 2114712.11265 | 37.7869338316717 | -122.42312040780199 | (37.7869338316717, -122.423120407802) | |||
| 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) | |||
| 24295 | 24295 | 249534 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006252.357009999 | 2114034.72493 | 37.785089704362704 | -122.422102579373 | (37.7850897043627, -122.422102579373) | |||
| 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) | |||
| 24334 | 24334 | 246922 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 417 Frederick St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 5997854.3485 | 2107475.00928 | 37.7666011818151 | -122.45068380291 | (37.7666011818151, -122.45068380291) | |||
| 24340 | 24340 | 241638 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 Guerrero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6005425.11854 | 2107744.6412400003 | 37.767771973225 | -122.424516988391 | (37.767771973225, -122.424516988391) | |||
| 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) | |||
| 24373 | 24373 | 201122 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3401 03rd St | 11 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016102.9288 | 2099545.92892 | 37.7458572657 | -122.387011499888 | (37.7458572657, -122.387011499888) | |||
| 24374 | 24374 | 192945 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 238 11th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6008246.27864 | 2109382.4071299997 | 37.7724278093356 | -122.41487483150401 | (37.7724278093356, -122.414874831504) | |||
| 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) | |||
| 24466 | 24466 | 207106 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Tara St | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | |||
| 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) |
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");