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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80457 | 80457 | 104540 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 80595 | 80595 | 102251 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 125X Powhattan Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606.0 | 2098071.0 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | |||
| 80672 | 80672 | 98502 | Property Tree 7 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999066.0 | 2100737.0 | 37.7481695560511 | -122.44600824337601 | (37.7481695560511, -122.446008243376) | ||||||
| 80849 | 80849 | 97052 | Property Tree 7 | Pyrus spp :: Pear Tree 291 | 795 Wisconsin St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.39877559017401 | (37.7574425906128, -122.398775590174) | |||
| 81073 | 81073 | 101977 | Property Tree 7 | Cedrus deodara :: Deodar Cedar 129 | 601 Grand View Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000076.2 | 2101609.9 | 37.750623962991796 | -122.44257767940901 | (37.7506239629918, -122.442577679409) | ||||||
| 81165 | 81165 | 97014 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 81341 | 81341 | 97022 | Property Tree 7 | Umbellularia californica :: California Bay 195 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 81598 | 81598 | 94690 | Property Tree 7 | Brachychiton populneus :: Bottle Tree 329 | 749 Congo St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | Permit Number 53820 | 6000274.0 | 2096023.0 | 37.735294937499 | -122.441492809367 | (37.735294937499, -122.441492809367) | ||||
| 81703 | 81703 | 96593 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 82720 | 82720 | 98465 | Property Tree 7 | Tree(s) :: 17 | 190 Portola Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999550.3 | 2100620.3 | 37.7478767693988 | -122.444325170302 | (37.7478767693988, -122.444325170302) | ||||||
| 82732 | 82732 | 102470 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1021 Kirkham St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5991773.0 | 2105198.0 | 37.7599991432047 | -122.471551983129 | (37.7599991432047, -122.471551983129) | |||||
| 82794 | 82794 | 110929 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 445 BEACON ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6002243.0 | 2098437.0 | 37.7420352018096 | -122.434857838675 | (37.7420352018096, -122.434857838675) | |||||
| 82893 | 82893 | 97042 | Property Tree 7 | Heteromeles arbutifolia :: Toyon 322 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 84088 | 84088 | 103516 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 980 Green St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6008298.0 | 2118971.0 | 37.7987586699451 | -122.415374854445 | (37.7987586699451, -122.415374854445) | |||||
| 84515 | 84515 | 104544 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 85013 | 85013 | 97015 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 85657 | 85657 | 96591 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 85764 | 85764 | 115641 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 7 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 85853 | 85853 | 114950 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1X WOODACRE DR | 2 | unknown : Yard 19 | Tree 1 | DPW 2 | 30x100 | 5991187.0 | 2095315.0 | 37.732829063550795 | -122.47285799850201 | (37.7328290635508, -122.472857998502) | ||||
| 86057 | 86057 | 94469 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 86843 | 86843 | 109377 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 87429 | 87429 | 108624 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 101 GENEBERN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005050.2 | 2095237.8 | 37.733409902631 | -122.42492386614401 | (37.733409902631, -122.424923866144) | |||||
| 87538 | 87538 | 97027 | Property Tree 7 | Myoporum laetum :: Myoporum 1 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 87654 | 87654 | 99961 | Property Tree 7 | Callistemon citrinus :: Lemon Bottlebrush 28 | 537 Valley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459.0 | 2099152.0 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | |||
| 88802 | 88802 | 97029 | Property Tree 7 | Rhamnus californica :: Coffeeberry Tree 232 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 88934 | 88934 | 107130 | Property Tree 7 | Phoenix dactylifera :: Date Palm 65 | 751 DOLORES ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005081.8 | 2103948.4 | 37.7573290011944 | -122.42543429450701 | (37.7573290011944, -122.425434294507) | |||||
| 88993 | 88993 | 121199 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 72 Fountain St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6000322.0 | 2101283.0 | 37.7497403826665 | -122.441704227556 | (37.7497403826665, -122.441704227556) | |||||
| 89166 | 89166 | 102275 | Property Tree 7 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6001225.6 | 2097744.2 | 37.740075118911705 | -122.438326054857 | (37.7400751189117, -122.438326054857) | ||||||
| 90230 | 90230 | 98140 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 315 San Marcos Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992920.8 | 2100212.1 | 37.746375486546704 | -122.467219803339 | (37.7463754865467, -122.467219803339) | ||||||
| 90248 | 90248 | 97040 | Property Tree 7 | Hakea suaveolens :: Sweet Hakea Tree 14 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 90360 | 90360 | 115646 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 12 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 91108 | 91108 | 97177 | Property Tree 7 | Tree(s) :: 17 | 257 Roosevelt Way | Back Yard : Yard 13 | Tree 1 | Private 1 | Monterey cypress tree in backyard on private property; not a Significant tree | 6000848.1 | 2107127.9 | 37.765819014897296 | -122.44030407045099 | (37.7658190148973, -122.440304070451) | |||||
| 92228 | 92228 | 122453 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 217 San Marcos Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5993325.07095 | 2100296.14299 | 37.7466295758311 | -122.465827998209 | (37.7466295758311, -122.465827998209) | ||||
| 92371 | 92371 | 118371 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 4808 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999981.0 | 2101110.0 | 37.7492459313263 | -122.44287099416799 | (37.7492459313263, -122.442870994168) | ||||
| 92938 | 92938 | 99277 | Property Tree 7 | Tree(s) :: 17 | 85X 10th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517.0 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | |||
| 92954 | 92954 | 97034 | Property Tree 7 | :: 54 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 94698 | 94698 | 104538 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 94734 | 94734 | 98893 | Property Tree 7 | Tree(s) :: 17 | 216 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998910.0 | 2100761.0 | 37.7482265448319 | -122.44654941060699 | (37.7482265448319, -122.446549410607) | ||||||
| 94845 | 94845 | 97016 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 96460 | 96460 | 109375 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 96699 | 96699 | 115645 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 11 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 97037 | 97037 | 97024 | Property Tree 7 | Jacaranda mimosifolia :: Jacaranda 52 | 1455 Alabama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768189 | 6009349.0 | 2100759.5 | 37.748813167460106 | -122.410451409671 | (37.7488131674601, -122.410451409671) | ||||
| 97416 | 97416 | 96594 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 97530 | 97530 | 99275 | Property Tree 7 | Tree(s) :: 17 | 85X 10th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517.0 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | |||
| 97796 | 97796 | 104543 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 98180 | 98180 | 120995 | Property Tree 7 | Private shrub :: Private Shrub 64 | 231 Delano Ave | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 3x3 | 6000066.0 | 2092260.0 | 37.72495076112679 | -122.44194193563999 | (37.7249507611268, -122.44194193564) | ||||
| 98218 | 98218 | 122480 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 596X Buckingham Way | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 5990152.0 | 2094375.0 | 37.7301880902761 | -122.476367577616 | (37.7301880902761, -122.476367577616) | ||||
| 98291 | 98291 | 98892 | Property Tree 7 | Tree(s) :: 17 | 220 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998935.0 | 2100753.0 | 37.7482060067302 | -122.44646238623999 | (37.7482060067302, -122.44646238624) | ||||||
| 98516 | 98516 | 104542 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 98644 | 98644 | 106968 | Property Tree 7 | :: 54 | 351 26th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.48618540122601 | (37.7828456076198, -122.486185401226) | ||||||
| 98786 | 98786 | 100139 | Property Tree 7 | Tree(s) :: 17 | 155 05th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.782125333955705 | -122.40549178692301 | (37.7821253339557, -122.405491786923) | ||||
| 99354 | 99354 | 102249 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125X Powhattan Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606.0 | 2098071.0 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | |||
| 99755 | 99755 | 115644 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 10 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 99802 | 99802 | 98890 | Property Tree 7 | Tree(s) :: 17 | 256 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999134.0 | 2100748.0 | 37.748203642185395 | -122.44577389345 | (37.7482036421854, -122.44577389345) | ||||||
| 99914 | 99914 | 97028 | Property Tree 7 | Morus alba :: White Mulberry 112 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 99953 | 99953 | 117254 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2067 33RD AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5985987.0 | 2101171.0 | 37.7486056682842 | -122.49126630479601 | (37.7486056682842, -122.491266304796) | ||||
| 100224 | 100224 | 91109 | Property Tree 7 | Tree(s) :: 17 | 2650 Turk Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 100275 | 100275 | 96676 | Property Tree 7 | Prunus spp :: Cherry 84 | 1701 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2011 12:00:00 AM | 5989644.3 | 2103769.9 | 37.7559545815884 | -122.478809598698 | (37.7559545815884, -122.478809598698) | ||||
| 100855 | 100855 | 114731 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 934 BRANNAN ST | Back Yard : Yard 13 | Tree 1 | Private 1 | Dept of Real Estate 9 | 10x10 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 101483 | 101483 | 113482 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2839 Pierce St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001345.0 | 2118077.0 | 37.7959107386074 | -122.43937030854799 | (37.7959107386074, -122.439370308548) | ||||||
| 101635 | 101635 | 121104 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 477 Myra Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997298.0 | 2097021.0 | 37.7378652095891 | -122.45185385938998 | (37.7378652095891, -122.45185385939) | ||||
| 101894 | 101894 | 102250 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125X Powhattan Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606.0 | 2098071.0 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | |||
| 102307 | 102307 | 99256 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1466 York St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010099.0 | 2100741.0 | 37.7488043872035 | -122.407856595429 | (37.7488043872035, -122.407856595429) | ||||||
| 102527 | 102527 | 115648 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 14 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 102675 | 102675 | 115649 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 15 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 103103 | 103103 | 91108 | Property Tree 7 | Tree(s) :: 17 | 2650 Turk Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 103566 | 103566 | 94487 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 103600 | 103600 | 98436 | Property Tree 7 | Tree(s) :: 17 | 238 Glenview Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999035.0 | 2100736.0 | 37.7481650400364 | -122.446115368035 | (37.7481650400364, -122.446115368035) | ||||||
| 104184 | 104184 | 104318 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 22 Beaver St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6002763.0 | 2106816.0 | 37.765071454107996 | -122.433658549479 | (37.765071454108, -122.433658549479) | ||||
| 104476 | 104476 | 97043 | Property Tree 7 | Heteromeles arbutifolia :: Toyon 322 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 104754 | 104754 | 102248 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125X Powhattan Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606.0 | 2098071.0 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | |||
| 104783 | 104783 | 96999 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195A Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 105598 | 105598 | 106227 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 38 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997884.0 | 2095808.5 | 37.7345695210024 | -122.44974042873999 | (37.7345695210024, -122.44974042874) | |||||
| 105687 | 105687 | 122518 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 772X Panorama Dr | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5996713.0 | 2102901.0 | 37.753976715350106 | -122.45430108189 | (37.7539767153501, -122.45430108189) | ||||
| 107232 | 107232 | 98405 | Property Tree 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 84 Richland Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2012 12:00:00 AM | Permit Number 768549 | 6005038.1 | 2096133.0 | 37.735867237922 | -122.425029371072 | (37.735867237922, -122.425029371072) | ||||
| 107366 | 107366 | 101903 | Property Tree 7 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 107492 | 107492 | 98715 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 26 Vernon St | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992459.0 | 2088068.0 | 37.713004133171 | -122.46793347935301 | (37.713004133171, -122.467933479353) | ||||||
| 107550 | 107550 | 97032 | Property Tree 7 | Griselinia lucida :: Griselinia 477 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 107936 | 107936 | 118318 | Property Tree 7 | Maytenus boaria :: Mayten 22 | 20 Norton St | 1 | Front Yard : Yard 7 | Tree 1 | MTA 6 | 6002015.686319999 | 2092167.12899 | 37.724806667280895 | -122.435195459751 | (37.7248066672809, -122.435195459751) | |||||
| 107998 | 107998 | 97023 | Property Tree 7 | Jacaranda mimosifolia :: Jacaranda 52 | 1443 Alabama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768190 | 6009347.4 | 2100788.9 | 37.748893803646105 | -122.410459018192 | (37.7488938036461, -122.410459018192) | ||||
| 108009 | 108009 | 115652 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 18 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 108286 | 108286 | 100045 | Property Tree 7 | Acacia decurrens :: Acacia: Silver Wattle 181 | 556 28th St | Front Yard : Yard 7 | Tree 1 | Private 1 | Not sure which property tree is located on. | 6002301.0 | 2099461.0 | 37.7448501592716 | -122.434730501666 | (37.7448501592716, -122.434730501666) | |||||
| 109029 | 109029 | 108973 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 3485X SAN BRUNO AVE | 1 | Median : Yard 3 | Tree 1 | DPW for City Agency 10 | 6011510.0 | 2091910.0 | 37.724635221414 | -122.402356490066 | (37.724635221414, -122.402356490066) | |||||
| 109200 | 109200 | 101625 | Property Tree 7 | Fagus sylvatica :: European Beech 250 | 64 Levant St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 769362 | 6000275.9 | 2106473.5 | 37.76398959970761 | -122.442236202383 | (37.7639895997076, -122.442236202383) | ||||
| 109233 | 109233 | 104397 | Property Tree 7 | Pseudotsuga menziesii :: Douglas Fir 231 | 350 Collingwood St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002086.0 | 2103822.0 | 37.756812219827296 | -122.43578589078301 | (37.7568122198273, -122.435785890783) | |||||
| 110024 | 110024 | 96606 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 110212 | 110212 | 110320 | Property Tree 7 | :: 54 | 9 Imperial Aly | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | ||||||
| 110616 | 110616 | 101905 | Property Tree 7 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 110904 | 110904 | 109242 | Property Tree 7 | Private shrub :: Private Shrub 64 | 2479 DIAMOND ST | Sidewalk: Curb side : Yard 2 | Landscaping 2 | Private 1 | 6002238.1 | 2097343.7 | 37.7390329760373 | -122.434796615916 | (37.7390329760373, -122.434796615916) | ||||||
| 110958 | 110958 | 108680 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 240 SANTA ANA AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992606.9 | 2095181.7 | 37.73254515275271 | -122.46793939448999 | (37.7325451527527, -122.46793939449) | |||||
| 111128 | 111128 | 96599 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 112237 | 112237 | 109378 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 112498 | 112498 | 106458 | Property Tree 7 | Tree(s) :: 17 | 71 HANCOCK ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003861.6 | 2105050.0 | 37.7602847161222 | -122.429732794413 | (37.7602847161222, -122.429732794413) | ||||||
| 113071 | 113071 | 108574 | Property Tree 7 | Tree(s) :: 17 | 1891 15th St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7x8 | 6004884.86016 | 2107160.4412599998 | 37.7661373754728 | -122.426344078904 | (37.7661373754728, -122.426344078904) | ||||
| 113186 | 113186 | 96604 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 113407 | 113407 | 115650 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 16 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 113649 | 113649 | 102469 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1021 Kirkham St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5991773.0 | 2105198.0 | 37.7599991432047 | -122.471551983129 | (37.7599991432047, -122.471551983129) | |||||
| 113756 | 113756 | 96600 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 114652 | 114652 | 97162 | Property Tree 7 | Malus :: Crab Apple 235 | 478 10th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | Tree in backyard on private property; not significant. | 5992861.5 | 2112216.7 | 37.7793335349967 | -122.468298031686 | (37.7793335349967, -122.468298031686) | |||||
| 115179 | 115179 | 106275 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 42 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997882.5 | 2095834.4 | 37.7346405503947 | -122.449747480555 | (37.7346405503947, -122.449747480555) |
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");