Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 156890 | 156890 | 249999 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 121 | Width 0ft | 6011509.9435 | 2120224.2158 | 37.8023796968334 | -122.404348688764 | (37.8023796968334, -122.404348688764) | |||
| 100775 | 100775 | 107342 | Significant Tree 6 | Prunus laurocerasus :: English laurel 227 | 110 JULIAN AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 100 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | ||||
| 139589 | 139589 | 109576 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 21X STILLINGS AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 60 | 6000417.0 | 2095694.0 | 37.7343997262189 | -122.44097481223999 | (37.7343997262189, -122.44097481224) | ||||
| 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) | |||
| 44939 | 44939 | 223816 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 45 | Width 5ft | 6002135.08017 | 2096585.1811900001 | 37.7369444095655 | -122.435098574335 | (37.7369444095655, -122.435098574335) | |||
| 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) | ||||
| 112387 | 112387 | 109194 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 4705 03rd St | Back Yard : Yard 13 | Tree 1 | Arts Commission 19 | 45 | 6015121.6 | 2095617.0 | 37.7350148477359 | -122.39013039721901 | (37.7350148477359, -122.390130397219) | |||||
| 85994 | 85994 | 104510 | Private 5 | Sequoia sempervirens :: Coast Redwood 116 | 254 ALLISON ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 40 | 6000052.0 | 2087408.0 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | ||||
| 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) | ||||
| 51644 | 51644 | 249877 | Undocumented 2 | Magnolia x soulangiana :: Saucer Magnolia 92 | 230 Greenwich St | 13 | Back Yard : Yard 13 | Tree 1 | Private 1 | 39 | Width 0ft | 6011569.83125 | 2120441.49442 | 37.802979637259 | -122.404156747344 | (37.802979637259, -122.404156747344) | |||
| 181159 | 181159 | 224265 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 58 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 38 | 6002671.84671 | 2096513.9082400003 | 37.7367791753169 | -122.433237644116 | (37.7367791753169, -122.433237644116) | ||||
| 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) | |||
| 67699 | 67699 | 249892 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 230 Greenwich St | 28 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | Width 0ft | 6011427.28959 | 2120425.37078 | 37.80292740013321 | -122.404648882458 | (37.8029274001332, -122.404648882458) | |||
| 101621 | 101621 | 104406 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 290 Stonecrest Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | Permit Number 770927 | 5990725.0 | 2092655.0 | 37.7254986161427 | -122.474261202586 | (37.7254986161427, -122.474261202586) | |||
| 114869 | 114869 | 111205 | Landmark tree 9 | Araucaria heterophylla :: Norfolk Island Pine 24 | 46 COOK ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 | 5997514.0 | 2113392.0 | 37.7828282170553 | -122.452288002469 | (37.7828282170553, -122.452288002469) | ||||
| 117738 | 117738 | 104008 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 357 Collingwood St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | 6002124.0 | 2103789.0 | 37.7567237682266 | -122.435652112093 | (37.7567237682266, -122.435652112093) | ||||
| 124990 | 124990 | 107541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 GARFIELD ST | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.46287353180901 | (37.7201106425596, -122.462873531809) | ||||
| 120579 | 120579 | 114365 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2546 28th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | 5987735.7 | 2097954.4 | 37.739875761389605 | -122.48498344199601 | (37.7398757613896, -122.484983441996) | ||||
| 135843 | 135843 | 250193 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011782.399230001 | 2119949.71509 | 37.8016412059365 | -122.403386530161 | (37.8016412059365, -122.403386530161) | |||
| 164095 | 164095 | 249920 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 358 Greenwich St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011181.16541 | 2120413.994 | 37.8028824034529 | -122.405499802075 | (37.8028824034529, -122.405499802075) | |||
| 156630 | 156630 | 249923 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 33 | Width 0ft | 6011163.06331 | 2120405.05222 | 37.8028568393309 | -122.40556181483801 | (37.8028568393309, -122.405561814838) | |||
| 104967 | 104967 | 108502 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2300 33RD AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 32 | 5986128.8 | 2099536.7 | 37.7441266056665 | -122.49065574130199 | (37.7441266056665, -122.490655741302) | ||||
| 114948 | 114948 | 113440 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 BEACON ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 32 | 3x3 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) | ||||
| 24155 | 24155 | 249927 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011132.35015 | 2120388.99651 | 37.8028110368738 | -122.40566696715099 | (37.8028110368738, -122.405666967151) | |||
| 74282 | 74282 | 249879 | Undocumented 2 | Salix spp :: Willow 218 | 230 Greenwich St | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011548.40111 | 2120431.82846 | 37.8029518994613 | -122.404230226458 | (37.8029518994613, -122.404230226458) | |||
| 159363 | 159363 | 249970 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011737.037830001 | 2120086.51138 | 37.802014281606205 | -122.403553132272 | (37.8020142816062, -122.403553132272) | |||
| 79705 | 79705 | 108816 | Private 5 | Pinus radiata :: Monterey Pine 3 | 348 Gold Mine Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 6001084.0 | 2097744.0 | 37.740066514789 | -122.43881563429301 | (37.740066514789, -122.438815634293) | ||||
| 101345 | 101345 | 104689 | Private 5 | Pinus radiata :: Monterey Pine 3 | 657 PALMETTO AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 5991786.0 | 2087190.1 | 37.7105547448876 | -122.470195680575 | (37.7105547448876, -122.470195680575) | ||||
| 105403 | 105403 | 105236 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 235X STATES ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | ||||
| 122510 | 122510 | 116619 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 120x KNOLLVIEW WAY | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 3x3 | 5997764.0 | 2102030.0 | 37.7516453806516 | -122.45060370088001 | (37.7516453806516, -122.45060370088) | |||
| 138928 | 138928 | 108171 | Undocumented 2 | Tree(s) :: 17 | 59x MACONDRAY LN | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | Permit Number 774825 | 6008454.0 | 2119149.0 | 37.7992561803015 | -122.414847646907 | (37.7992561803015, -122.414847646907) | |||
| 47640 | 47640 | 249876 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 230 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 29 | Width 0ft | 6011590.626680001 | 2120460.04582 | 37.8030317367952 | -122.40408609031 | (37.8030317367952, -122.40408609031) | |||
| 28833 | 28833 | 249969 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 28 | Width 0ft | 6011730.79134 | 2120085.86253 | 37.802012151107704 | -122.403574702535 | (37.8020121511077, -122.403574702535) | |||
| 37934 | 37934 | 249882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | Width 0ft | 6011509.072430001 | 2120419.3733099997 | 37.8029155030083 | -122.40436544761499 | (37.8029155030083, -122.404365447615) | |||
| 73581 | 73581 | 191844 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | 6015247.82087 | 2099125.91751 | 37.7446566150196 | -122.38993903417 | (37.7446566150196, -122.38993903417) | ||||
| 88847 | 88847 | 103457 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Bosworth St | 3 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 26 | Located on DPW property next to 84 Lippard Ave | 6001796.5 | 2095573.7 | 37.7341478843848 | -122.436196831648 | (37.7341478843848, -122.436196831648) | |||
| 131807 | 131807 | 249873 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 26 | Width 0ft | 6011670.78297 | 2120474.23594 | 37.8030751776447 | -122.403809705266 | (37.8030751776447, -122.403809705266) | |||
| 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) | ||||
| 60639 | 60639 | 191813 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 6011137.70759 | 2106686.95849 | 37.7651887659782 | -122.40468325722901 | (37.7651887659782, -122.404683257229) | ||||
| 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) | ||||
| 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) | ||||
| 33977 | 33977 | 249894 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 30 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011403.76038 | 2120447.63681 | 37.802987222140395 | -122.40473187458599 | (37.8029872221404, -122.404731874586) | |||
| 73889 | 73889 | 191811 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | 6011131.47947 | 2106831.70462 | 37.76558585803421 | -122.40471498982299 | (37.7655858580342, -122.404714989823) | ||||
| 74522 | 74522 | 249896 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 32 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011386.30387 | 2120437.51769 | 37.8029584618196 | -122.404791570676 | (37.8029584618196, -122.404791570676) | |||
| 96669 | 96669 | 112123 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 771 WALLER ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | 3x3 | 6002060.0 | 2108730.0 | 37.770286913106204 | -122.43622703445601 | (37.7702869131062, -122.436227034456) | ||||
| 124250 | 124250 | 99374 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 21 Panorama Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | 5998009.0 | 2100230.0 | 37.7467170430405 | -122.449626769288 | (37.7467170430405, -122.449626769288) | |||||
| 176393 | 176393 | 249926 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011142.49576 | 2120408.96257 | 37.8028664261111 | -122.405633265077 | (37.8028664261111, -122.405633265077) | |||
| 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) | |||
| 54971 | 54971 | 249878 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 230 Greenwich St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | Width 0ft | 6011550.21069 | 2120457.44752 | 37.803022344253705 | -122.40422576851299 | (37.8030223442537, -122.404225768513) | |||
| 63607 | 63607 | 191841 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 6015067.74656 | 2099262.4877299997 | 37.7450216201491 | -122.39057124226801 | (37.7450216201491, -122.390571242268) | ||||
| 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) | ||||
| 163352 | 163352 | 223998 | Undocumented 2 | Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 | 100 Hwy 101 Southbound | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 6005894.41752 | 2108909.3321599998 | 37.770996427668 | -122.422976527055 | (37.770996427668, -122.422976527055) | ||||
| 172941 | 172941 | 191812 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 6011136.684719999 | 2106709.3643099996 | 37.765250230128004 | -122.404688372578 | (37.765250230128, -122.404688372578) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 30471 | 30471 | 188564 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Vermont St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | 6011131.87643 | 2106822.77201 | 37.7655613532939 | -122.404712987912 | (37.7655613532939, -122.404712987912) | ||||
| 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) | |||
| 133552 | 133552 | 249874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | Width 0ft | 6011664.0982800005 | 2120483.35155 | 37.803099833442296 | -122.403833479743 | (37.8030998334423, -122.403833479743) | |||
| 160942 | 160942 | 249712 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | 5999372.04623 | 2116967.23886 | 37.792751153907204 | -122.44611721373998 | (37.7927511539072, -122.44611721374) | ||||
| 34603 | 34603 | 249714 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 5999388.9274 | 2116973.5904200003 | 37.7927695576174 | -122.446059261445 | (37.7927695576174, -122.446059261445) | ||||
| 46680 | 46680 | 249916 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011201.85513 | 2120410.11068 | 37.8028728976405 | -122.40542793096901 | (37.8028728976405, -122.405427930969) | |||
| 51446 | 51446 | 249918 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011195.29362 | 2120394.33345 | 37.8028292103611 | -122.405449525493 | (37.8028292103611, -122.405449525493) | |||
| 119332 | 119332 | 120526 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1439 47th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 3x3 | 5981489.0 | 2105275.0 | 37.759610238830206 | -122.50712446853998 | (37.7596102388302, -122.50712446854) | |||
| 129259 | 129259 | 122558 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1760 Diamond St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 3x3 | 6001927.0 | 2098732.0 | 37.7428272563398 | -122.43597156823799 | (37.7428272563398, -122.435971568238) | |||
| 130010 | 130010 | 249997 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011507.582230001 | 2120247.7373900004 | 37.802444149427 | -122.40435851653 | (37.802444149427, -122.40435851653) | |||
| 142191 | 142191 | 114191 | Significant Tree 6 | Tree(s) :: 17 | 201 Delano Ave | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Permit Number 776814 | 6000172.52130735 | 2092388.14283689 | 37.7253086814057 | -122.44158289611 | (37.7253086814057, -122.44158289611) | |||
| 144877 | 144877 | 120110 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 90X Knollview Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 3x25 | 5997618.0 | 2101448.0 | 37.750038994650396 | -122.45106661992399 | (37.7500389946504, -122.451066619924) | |||
| 172795 | 172795 | 191843 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 6015141.47385 | 2099207.7707599998 | 37.7448754686187 | -122.390312482158 | (37.7448754686187, -122.390312482158) | ||||
| 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) | ||||
| 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) | ||||
| 171246 | 171246 | 249875 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | Width 0ft | 6011656.00691 | 2120465.5569700003 | 37.803050521838706 | -122.40386022737499 | (37.8030505218387, -122.403860227375) | |||
| 182994 | 182994 | 191809 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | 6011127.66334 | 2106895.1514 | 37.76575985524929 | -122.404732656101 | (37.7657598552493, -122.404732656101) | ||||
| 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) | ||||
| 31427 | 31427 | 223996 | Undocumented 2 | Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 | 100 Hwy 101 Southbound | 23 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6005945.0032 | 2108837.4935 | 37.770802030213105 | -122.42279644320699 | (37.7708020302131, -122.422796443207) | ||||
| 35303 | 35303 | 249715 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 5999395.51836 | 2116974.38878 | 37.7927721260745 | -122.44603651397 | (37.7927721260745, -122.44603651397) | ||||
| 61728 | 61728 | 249895 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 31 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011395.76102 | 2120447.38073 | 37.8029860719045 | -122.404759538639 | (37.8029860719045, -122.404759538639) | |||
| 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) | ||||
| 160585 | 160585 | 249998 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011504.54206 | 2120237.90093 | 37.8024169710215 | -122.40436834431699 | (37.8024169710215, -122.404368344317) | |||
| 163778 | 163778 | 223997 | Undocumented 2 | Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 | 100 Hwy 101 Southbound | 16 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6005905.0919699995 | 2108895.1603 | 37.770958117464396 | -122.42293859636601 | (37.7709581174644, -122.422938596366) | ||||
| 170870 | 170870 | 249922 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011172.25119 | 2120397.10621 | 37.802835535282604 | -122.405529459923 | (37.8028355352826, -122.405529459923) | |||
| 183262 | 183262 | 191810 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6011130.07486 | 2106859.15267 | 37.7656611456652 | -122.40472178059099 | (37.7656611456652, -122.404721780591) | ||||
| 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) | |||
| 48281 | 48281 | 209182 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 3ft | 5994867.86795 | 2098472.15279 | 37.7417102300345 | -122.46036106750799 | (37.7417102300345, -122.460361067508) | |||
| 50449 | 50449 | 242820 | Undocumented 2 | Tree(s) :: 17 | 37 Poppy Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 2ft | 6002456.61791 | 2096763.3951400002 | 37.7374519967974 | -122.4339996118 | (37.7374519967974, -122.4339996118) | |||
| 183987 | 183987 | 245781 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 8ft | 6003587.5616 | 2096850.22083 | 37.7377545179491 | -122.43009560263799 | (37.7377545179491, -122.430095602638) | |||
| 27098 | 27098 | 249881 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 230 Greenwich St | 17 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 0ft | 6011514.20842 | 2120460.74576 | 37.803029388647104 | -122.404350588107 | (37.8030293886471, -122.404350588107) | |||
| 48070 | 48070 | 209184 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 3ft | 5994856.4919300005 | 2098484.57238 | 37.7417436767315 | -122.460401301401 | (37.7417436767315, -122.460401301401) | |||
| 71300 | 71300 | 191840 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | 6015034.2062 | 2099284.7294900003 | 37.7450808306162 | -122.39068877377701 | (37.7450808306162, -122.390688773777) | ||||
| 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) | ||||
| 180980 | 180980 | 249806 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 0ft | 6010784.31321 | 2121039.01987 | 37.804576372755605 | -122.406917200191 | (37.8045763727556, -122.406917200191) | |||
| 27599 | 27599 | 232417 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 173 Everson St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6002718.41885 | 2097663.27226 | 37.7399377058635 | -122.433158722322 | (37.7399377058635, -122.433158722322) | ||||
| 35242 | 35242 | 249713 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 5999382.51554 | 2116973.87968 | 37.792769985700296 | -122.446081467494 | (37.7927699857003, -122.446081467494) | ||||
| 51583 | 51583 | 249891 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 27 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 0ft | 6011455.072819999 | 2120426.06234 | 37.8029308517393 | -122.404552786308 | (37.8029308517393, -122.404552786308) | |||
| 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) | |||
| 105590 | 105590 | 121144 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 400 Franconia St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 3x3 | 6010016.0 | 2098808.0 | 37.743492145498294 | -122.40800731166901 | (37.7434921454983, -122.408007311669) | |||
| 111685 | 111685 | 107343 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 110 JULIAN AVE | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | ||||
| 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) | |||
| 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) |
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");