Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 21199 | 21199 | 97237 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) | |||
| 76012 | 76012 | 97025 | Property Tree 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 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) | |||||
| 78101 | 78101 | 96597 | 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) | |||||
| 78805 | 78805 | 97021 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 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) | |||||
| 79404 | 79404 | 97051 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 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) | |||
| 79535 | 79535 | 96590 | 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) | |||||
| 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) | |||
| 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) | |||||
| 81246 | 81246 | 109097 | Property Tree 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774331 | 6002630.6 | 2098839.9 | 37.743163470374895 | -122.43354642924999 | (37.7431634703749, -122.43354642925) |
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 95068 | 95068 | 109091 | Property Tree 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 4235 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773805 | 6001611.4 | 2102294.1 | 37.7525900037408 | -122.43731782876002 | (37.7525900037408, -122.43731782876) |
| 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) | |||||
| 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) | |||||
| 100052 | 100052 | 97238 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) |
| 102061 | 102061 | 109092 | Property Tree 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 237 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773766 | 6004335.1 | 2099509.2 | 37.7450977767532 | -122.427700396282 | (37.7450977767532, -122.427700396282) |
| 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) | |||||
| 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) | |||||
| 104891 | 104891 | 102101 | Property Tree 7 | Cordyline australis :: Dracena Palm 141 | 331 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769722 | 5992434.3 | 2090067.3 | 37.718492301183204 | -122.468164197766 | (37.7184923011832, -122.468164197766) |
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 116314 | 116314 | 96592 | 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) | |||||
| 121581 | 121581 | 96589 | 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) | |||||
| 122755 | 122755 | 102079 | Property Tree 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 76 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769729 | 6008162.3 | 2099676.4 | 37.7457726186307 | -122.414478397936 | (37.7457726186307, -122.414478397936) | |
| 123910 | 123910 | 96598 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | tree 3 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 125485 | 125485 | 97041 | 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) | |||||
| 125835 | 125835 | 97004 | 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) | |||||
| 126860 | 126860 | 96602 | 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) | |||||
| 127434 | 127434 | 97236 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 125 Excelsior Ave | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) | |||
| 127473 | 127473 | 97045 | Property Tree 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 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) | |||||
| 128034 | 128034 | 96601 | 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) | |||||
| 128784 | 128784 | 97039 | 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) | |||||
| 140389 | 140389 | 97037 | 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) | |||||
| 140586 | 140586 | 97044 | 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) | |||||
| 140629 | 140629 | 97038 | 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) | |||||
| 142264 | 142264 | 96605 | 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) | |||||
| 142369 | 142369 | 97035 | Property Tree 7 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 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) | |||||
| 144514 | 144514 | 96603 | 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) | |||||
| 145213 | 145213 | 97026 | Property Tree 7 | Tilia cordata :: Littleleaf Linden 208 | 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) | |||||
| 145522 | 145522 | 97036 | 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) | |||||
| 146266 | 146266 | 109076 | Property Tree 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 772744 | 6001554.7 | 2087011.6 | 37.7106245477128 | -122.43642021389401 | (37.7106245477128, -122.436420213894) | ||
| 631 | 631 | 251294 | Property Tree 7 | :: 54 | 7126 Geary Blvd | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5984860.0 | 2112552.0 | 37.779788778901796 | -122.49600289252199 | (37.7797887789018, -122.496002892522) | ||||
| 669 | 669 | 251343 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 934 Brannan St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 901 | 901 | 224716 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 5 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 13 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 903 | 903 | 225889 | Property Tree 7 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 | 3255x 24th St | 7 | Back Yard : Cutout 16 | Tree 1 | MTA 6 | 18 | Width 8ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 905 | 905 | 224715 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 4 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 12 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 909 | 909 | 234895 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3255x 24th St | 6 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 40 | Width 10ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 914 | 914 | 225888 | Property Tree 7 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 | 3255x 24th St | 1 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 32 | 6x6 | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 916 | 916 | 224714 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 3 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 11 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 928 | 928 | 224422 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 2 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 16 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 1273 | 1273 | 251481 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 32 Peralta Ave | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 3x3 | 6010779.0 | 2100499.0 | 37.7481779538542 | -122.40548810426901 | (37.7481779538542, -122.405488104269) | ||||
| 1380 | 1380 | 251512 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4116x 18th St | 1 | Back Yard : Yard 13 | Tree 1 | MTA 6 | 3x3 | 6002190.0 | 2105341.0 | 37.760988934022706 | -122.43553488468001 | (37.7609889340227, -122.43553488468) | ||||
| 1928 | 1928 | 252837 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1929 | 1929 | 252833 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1945 | 1945 | 252839 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 99 Pond St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1948 | 1948 | 252834 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1955 | 1955 | 252835 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1996 | 1996 | 252848 | Property Tree 7 | Pinus halepensis :: Allepo Pine 164 | 99 Reposa Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5998022.0 | 2098104.0 | 37.7408803073177 | -122.44942865965 | (37.7408803073177, -122.44942865965) | ||||
| 2595 | 2595 | 253142 | Property Tree 7 | Juniperus silicicola :: Southern red cedar 186 | 735 29th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5986898.0 | 2110914.0 | 37.7754104499772 | -122.48883220977301 | (37.7754104499772, -122.488832209773) | ||||
| 2606 | 2606 | 253143 | Property Tree 7 | Juniperus silicicola :: Southern red cedar 186 | 735 29th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5986898.0 | 2110914.0 | 37.7754104499772 | -122.48883220977301 | (37.7754104499772, -122.488832209773) | ||||
| 2764 | 2764 | 253207 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 89 Woodhaven Ct | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5996069.0 | 2103645.0 | 37.75598259914371 | -122.45658197288401 | (37.7559825991437, -122.456581972884) | ||||
| 3132 | 3132 | 253339 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 2019X 24th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | PUC 13 | 3x3 | 5988853.0 | 2101569.0 | 37.7498655183494 | -122.481384971136 | (37.7498655183494, -122.481384971136) | ||||
| 3552 | 3552 | 253469 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 701 Stanyan St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5997178.0 | 2108423.0 | 37.7691653834469 | -122.45309160151399 | (37.7691653834469, -122.453091601514) | |||||
| 4447 | 4447 | 253626 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1671 Funston Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5992125.0 | 2104081.0 | 37.756952512450205 | -122.47025325330601 | (37.7569525124502, -122.470253253306) | ||||
| 5096 | 5096 | 253768 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998692.0 | 2104165.0 | 37.7575606372552 | -122.44754823773899 | (37.7575606372552, -122.447548237739) | |||||
| 9474 | 9474 | 173600 | Property Tree 7 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Clarendon Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996184.0 | 2102497.0 | 37.7528370823128 | -122.45610127186899 | (37.7528370823128, -122.456101271869) | ||||
| 11978 | 11978 | 112948 | Property Tree 7 | Ligustrum japonicum :: Japanese Privet 4 | 400 Pioche St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x15 | 6005670.66964 | 2093276.94718 | 37.7280608613968 | -122.42263943148599 | (37.7280608613968, -122.422639431486) | |||
| 12440 | 12440 | 100166 | Property Tree 7 | Salix spp :: Willow 218 | 2340 Twin Peaks Blvd | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769026 | ||||||||||
| 13296 | 13296 | 187658 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 600X Clarendon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5995637.0 | 2102382.0 | 37.7524899085688 | -122.457984564932 | (37.7524899085688, -122.457984564932) | ||||
| 13321 | 13321 | 187670 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 230 Victoria St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5993274.0 | 2088748.0 | 37.7149182807441 | -122.465165952001 | (37.7149182807441, -122.465165952001) | ||||
| 18793 | 18793 | 114373 | Property Tree 7 | Liquidambar styraciflua :: American Sweet Gum 62 | 805 GONZALEZ DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5988302.0 | 2089566.0 | 37.7168763353695 | -122.482410970247 | (37.7168763353695, -122.482410970247) | ||||
| 19656 | 19656 | 101900 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1100 Ocean Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 22300 | 22300 | 248974 | Property Tree 7 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 716 Goettingen St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010713.0 | 2091306.0 | 37.7229322393396 | -122.405069122237 | (37.7229322393396, -122.405069122237) | ||||
| 22826 | 22826 | 251117 | Property Tree 7 | Sequoiadendron giganteum :: Sierra Redwood 212 | 2024 Castro St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002622.0 | 2099601.0 | 37.7452527853239 | -122.43363054854099 | (37.7452527853239, -122.433630548541) | |||||
| 74398 | 74398 | 97290 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 55 Hiliritas Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 778896 | 6001461.7 | 2096833.2 | 37.7375871516219 | -122.437444499981 | (37.7375871516219, -122.437444499981) | |||||
| 76017 | 76017 | 106971 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 3479X San Bruno Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6011510.60551 | 2091910.0343099998 | 37.7246353494236 | -122.402354399294 | (37.7246353494236, -122.402354399294) | ||||
| 77354 | 77354 | 33781 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x misson st | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6013804.30364325 | 2116217.11127164 | 37.7915050790356 | -122.396128026757 | (37.7915050790356, -122.396128026757) | |
| 77987 | 77987 | 100070 | Property Tree 7 | Tree(s) :: 17 | 331 Serrano Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 777990 | 5990400.0 | 2090718.0 | 37.7201612636948 | -122.47524333880699 | (37.7201612636948, -122.475243338807) | ||||
| 78509 | 78509 | 102745 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Moncada Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992354.0 | 2093377.4 | 37.727576385896604 | -122.468682482409 | (37.7275763858966, -122.468682482409) | |||||
| 78510 | 78510 | 114817 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 100 RACCOON DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 5998725.0 | 2104028.0 | 37.757186355085004 | -122.447424250084 | (37.757186355085, -122.447424250084) | |||||
| 78854 | 78854 | 101901 | Property Tree 7 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Ocean Ave | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 79011 | 79011 | 108637 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 15 TUCKER AVE | Back Yard : Yard 13 | Tree 1 | Private 1 | 6011049.2 | 2088423.2 | 37.715035447895396 | -122.403704200211 | (37.7150354478954, -122.403704200211) | ||||||
| 79534 | 79534 | 121404 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1900 08th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 10x10 | 5993817.0 | 2102486.0 | 37.7526707300666 | -122.464285931649 | (37.7526707300666, -122.464285931649) | |||
| 79751 | 79751 | 105231 | Property Tree 7 | Pinus Spp :: Pine Spp 105 | 460X ROOSEVELT WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6000051.0 | 2106345.0 | 37.7636239504047 | -122.44300483360901 | (37.7636239504047, -122.443004833609) | ||||
| 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) | ||||||
| 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) |
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");