Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 403 | 403 | 65940 | Planning Code 138.1 required 4 | Liquidambar styraciflua :: American Sweet Gum 62 | 620 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 8 | Permit Number 28961 | 6007431.46715 | 2113367.23378 | 37.78332336932171 | -122.41797588370702 | (37.7833233693217, -122.417975883707) | |
| 2811 | 2811 | 115532 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007293.46404 | 2111265.83422 | 37.777545665835596 | -122.41830427922501 | (37.7775456658356, -122.418304279225) | ||
| 3318 | 3318 | 253415 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 Stoneybrook Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/31/2017 12:00:00 AM | 3 | Permit Number 779907 | 6005926.97731 | 2093972.4268599998 | 37.729984953042795 | -122.421802746417 | (37.7299849530428, -122.421802746417) | |||
| 3497 | 3497 | 247942 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3 | Permit Number 775404 | 6010292.72224 | 2098904.67919 | 37.7437730949632 | -122.40705728398399 | (37.7437730949632, -122.407057283984) | |||
| 3501 | 3501 | 247943 | Planning Code 138.1 required 4 | Maytenus boaria :: Mayten 22 | 29 Joy St | 6 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 2 | Permit Number 775404 | 6010304.2598 | 2098903.51059 | 37.7437705318851 | -122.407017307297 | (37.7437705318851, -122.407017307297) | |||
| 3506 | 3506 | 247939 | Planning Code 138.1 required 4 | Quercus agrifolia :: Coast Live Oak 180 | 29 Joy St | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 12 | Permit Number 775404 | 6010258.299769999 | 2098917.5156900003 | 37.7438064148349 | -122.40717721395 | (37.7438064148349, -122.40717721395) | |||
| 3510 | 3510 | 247941 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 5 | Permit Number 775404 | 6010287.82636 | 2098909.7574 | 37.743786764646 | -122.40707457072901 | (37.743786764646, -122.407074570729) | |||
| 3511 | 3511 | 247940 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 5 | Permit Number 775404 | 6010280.31746 | 2098909.2881400003 | 37.7437850559498 | -122.407100501782 | (37.7437850559498, -122.407100501782) | |||
| 3513 | 3513 | 247938 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 29 Joy St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | |||
| 3858 | 3858 | 35488 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | Permit Number 770253 | 6000772.5656 | 2114469.8149 | 37.7859737553806 | -122.441092113094 | (37.7859737553806, -122.441092113094) | ||
| 5103 | 5103 | 253796 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Scotia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2017 12:00:00 AM | 3 | Permit Number 779938 | 6011980.63004 | 2095004.60122 | 37.733158617067296 | -122.40094689916799 | (37.7331586170673, -122.400946899168) | ||
| 6140 | 6140 | 115534 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007259.83389 | 2111260.26588 | 37.777528483399294 | -122.418420222514 | (37.7775284833993, -122.418420222514) | ||
| 6989 | 6989 | 115533 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007275.38703 | 2111262.82601 | 37.7775363884346 | -122.418366600452 | (37.7775363884346, -122.418366600452) | ||
| 8241 | 8241 | 115531 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007312.7374599995 | 2111269.98589 | 37.777558150214404 | -122.41823790028 | (37.7775581502144, -122.41823790028) | ||
| 8494 | 8494 | 115535 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007237.56945 | 2111260.60051 | 37.777528148837796 | -122.41849726655899 | (37.7775281488378, -122.418497266559) | ||
| 9790 | 9790 | 104876 | Planning Code 138.1 required 4 | Prunus laurocerasus :: English laurel 227 | 2478 43rd Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 778928 | 5983068.6 | 2098273.8 | 37.740479796641296 | -122.50114367627701 | (37.7404797966413, -122.501143676277) | |||
| 20380 | 20380 | 112084 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 83281 | 83281 | 107646 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.765380001 | 2115716.99395 | 37.789681792424105 | -122.42387802240101 | (37.7896817924241, -122.423878022401) | ||
| 88619 | 88619 | 107647 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.765380001 | 2115716.99395 | 37.789681792424105 | -122.42387802240101 | (37.7896817924241, -122.423878022401) | ||
| 104211 | 104211 | 112085 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 110900 | 110900 | 118361 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.765380001 | 2115716.99395 | 37.789681792424105 | -122.42387802240101 | (37.7896817924241, -122.423878022401) | ||
| 113628 | 113628 | 116851 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 83 Panorama Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | |||
| 115704 | 115704 | 114985 | Planning Code 138.1 required 4 | Acer buergeranum :: Trident Maple 120 | 1188 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | Permit Number 773128 | 6003158.9 | 2101346.9 | 37.7500770674438 | -122.43189868142001 | (37.7500770674438, -122.43189868142) | |||
| 117231 | 117231 | 116850 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 83 Panorama Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | |||
| 121738 | 121738 | 107645 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.765380001 | 2115716.99395 | 37.789681792424105 | -122.42387802240101 | (37.7896817924241, -122.423878022401) | ||
| 140550 | 140550 | 116849 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 83 Panorama Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | |||
| 141889 | 141889 | 118360 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.765380001 | 2115716.99395 | 37.789681792424105 | -122.42387802240101 | (37.7896817924241, -122.423878022401) | ||
| 151101 | 151101 | 39246 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3524 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 1 | Permit Number 772836 | 5997390.1418 | 2116079.3582900004 | 37.7901998932662 | -122.452910535096 | (37.7901998932662, -122.452910535096) | ||
| 126630 | 126630 | 115885 | Planning Code 138.1 required 4 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | 10x10 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | |
| 139787 | 139787 | 68987 | Planning Code 138.1 required 4 | Cordyline australis :: Dracena Palm 141 | 767 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 775182 | 5999291.63198947 | 2121477.34728573 | 37.8051301110493 | -122.44672010757 | (37.8051301110493, -122.44672010757) | |
| 35251 | 35251 | 121502 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | |||
| 38160 | 38160 | 121504 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014396.4001 | 2115093.29031 | 37.7884522533286 | -122.39400066032499 | (37.7884522533286, -122.394000660325) | |||
| 46572 | 46572 | 121505 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014377.50413 | 2115113.61118 | 37.7885069995398 | -122.394067461056 | (37.7885069995398, -122.394067461056) | |||
| 60824 | 60824 | 121501 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014441.60375 | 2115047.86993 | 37.7883300516388 | -122.39384108102101 | (37.7883300516388, -122.393841081021) | |||
| 151686 | 151686 | 121503 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014412.49464 | 2115075.87435 | 37.7884053276005 | -122.39394375569401 | (37.7884053276005, -122.393943755694) | |||
| 350 | 350 | 85805 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627.0 | 2111882.0 | 37.77948049775679 | -122.40335640121799 | (37.7794804977568, -122.403356401218) | |
| 351 | 351 | 251213 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 365 | 365 | 251211 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 384 | 384 | 85806 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627.0 | 2111882.0 | 37.77948049775679 | -122.40335640121799 | (37.7794804977568, -122.403356401218) | |
| 387 | 387 | 85807 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 396 | 396 | 251212 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 116994 | 116994 | 114980 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 281 32ND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 5985853.0 | 2114037.0 | 37.7839242715215 | -122.492677119536 | (37.7839242715215, -122.492677119536) | ||||
| 46754 | 46754 | 115098 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 537 Natoma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010148.06204 | 2111925.42664 | 37.7795170247346 | -122.408475763058 | (37.7795170247346, -122.408475763058) | |
| 84353 | 84353 | 115886 | Planning Code 138.1 required 4 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 134 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | 2x4 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | |
| 126350 | 126350 | 115887 | Planning Code 138.1 required 4 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 134 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | 2x4 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | |
| 133773 | 133773 | 101942 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 537 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010108.2937199995 | 2111885.47528 | 37.7794051005107 | -122.408610520167 | (37.7794051005107, -122.408610520167) | |
| 149675 | 149675 | 115096 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 537 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010119.08101 | 2111896.4319 | 37.7794357889593 | -122.408573975335 | (37.7794357889593, -122.408573975335) | |
| 179588 | 179588 | 115097 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 537 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010133.894719999 | 2111910.59383 | 37.779475503918 | -122.408523727481 | (37.779475503918, -122.408523727481) | |
| 4790 | 4790 | 158406 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 50 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2017 12:00:00 AM | 3 | 3X3 | Permit Number 770857 | 6001789.37716 | 2096842.5543 | 37.7376314601307 | -122.436312235543 | (37.7376314601307, -122.436312235543) | |
| 9824 | 9824 | 173697 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007975.5805432 | 2110395.7628536997 | 37.775195030008994 | -122.415882976003 | (37.775195030009, -122.415882976003) | |
| 13838 | 13838 | 15248 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007914.867219999 | 2110337.26914 | 37.7750310067149 | -122.41608885424 | (37.7750310067149, -122.41608885424) | |
| 15438 | 15438 | 104819 | Planning Code 138.1 required 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 468 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770905 | 6011018.41682 | 2111922.08536 | 37.7795565535331 | -122.405464583724 | (37.7795565535331, -122.405464583724) | |
| 16367 | 16367 | 15247 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007902.55668 | 2110326.57547 | 37.77500095226429 | -122.416130681693 | (37.7750009522643, -122.416130681693) | |
| 16888 | 16888 | 18349 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 480 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6010310.27618 | 2106136.10948 | 37.763629979170496 | -122.40750631726101 | (37.7636299791705, -122.407506317261) | ||
| 84996 | 84996 | 15236 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008261.49106 | 2110663.4843099997 | 37.7759461992201 | -122.41491289655599 | (37.7759461992201, -122.414912896556) | |
| 86819 | 86819 | 15237 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008256.52807 | 2110680.03106 | 37.7759913537931 | -122.414931236282 | (37.7759913537931, -122.414931236282) | |
| 90620 | 90620 | 116853 | Planning Code 138.1 required 4 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | 3X3 | Permit Number 773331 | 6005973.81147 | 2115593.81965 | 37.7893548777914 | -122.423177122971 | (37.7893548777914, -122.423177122971) | |
| 106734 | 106734 | 5313 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 1785 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770253 | 6001045.0 | 2114480.0 | 37.786017234839 | -122.440150297316 | (37.786017234839, -122.440150297316) | |
| 145330 | 145330 | 15235 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008256.52807 | 2110680.03106 | 37.7759913537931 | -122.414931236282 | (37.7759913537931, -122.414931236282) | |
| 17038 | 17038 | 115537 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 89451 | 89451 | 115539 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 120162 | 120162 | 114792 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Linares Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x10 | 5993887.4 | 2102332.1 | 37.7522522176371 | -122.464031307011 | (37.7522522176371, -122.464031307011) | ||||
| 120364 | 120364 | 115538 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 142150 | 142150 | 115536 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 142926 | 142926 | 114793 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 10 Linares Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x10 | Permit Number 777094 | 5993887.4 | 2102332.1 | 37.7522522176371 | -122.464031307011 | (37.7522522176371, -122.464031307011) | |||
| 1388 | 1388 | 251519 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1395 | 1395 | 251525 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 173 Sanchez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1401 | 1401 | 251523 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1413 | 1413 | 246406 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | |||
| 1414 | 1414 | 251524 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1416 | 1416 | 251521 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1425 | 1425 | 251522 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1433 | 1433 | 251520 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 3523 | 3523 | 253474 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 20 | 20 | 251179 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 1043 Minna St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6007668.0 | 2109797.0 | 37.7735336727503 | -122.41690453761002 | (37.7735336727503, -122.41690453761) | ||||
| 21 | 21 | 251178 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 1043 Minna St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6007668.0 | 2109797.0 | 37.7735336727503 | -122.41690453761002 | (37.7735336727503, -122.41690453761) | ||||
| 54 | 54 | 121137 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1388x Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 60 | 60 | 121139 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1388x Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 70 | 70 | 121138 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1388x Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 224 | 224 | 117019 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008121.68381 | 2113004.40875 | 37.782365960952 | -122.41556230388201 | (37.782365960952, -122.415562303882) | |
| 361 | 361 | 85803 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 923 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778048 | 6011427.0378 | 2111936.1074 | 37.779617893816 | -122.40405196806002 | (37.779617893816, -122.40405196806) | |
| 394 | 394 | 85804 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 923 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778048 | 6011441.4589 | 2111949.4191 | 37.7796552503769 | -122.404003016031 | (37.7796552503769, -122.404003016031) | |
| 518 | 518 | 251314 | Planning Code 138.1 required 4 | :: 54 | 1108 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001901.0 | 2100825.0 | 37.7485726639367 | -122.43621121860001 | (37.7485726639367, -122.4362112186) | ||||
| 533 | 533 | 251313 | Planning Code 138.1 required 4 | :: 54 | 390 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2099547.0 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | ||||
| 948 | 948 | 251406 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 445 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2017 12:00:00 AM | 3 | 3x3 | 6001636.0 | 2088904.0 | 37.7158252789105 | -122.43627456666799 | (37.7158252789105, -122.436274566668) | ||
| 976 | 976 | 160371 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 868 Edinburgh St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001686.38396 | 2088939.3945099998 | 37.7159253269669 | -122.43610294800199 | (37.7159253269669, -122.436102948002) | |
| 977 | 977 | 242613 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 48 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Permit Number 777782 | 6007306.44134 | 2099195.30791 | 37.744403529591395 | -122.417403753004 | (37.7444035295914, -122.417403753004) | ||
| 991 | 991 | 160369 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 868 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001700.06015 | 2088961.7176 | 37.715987398188894 | -122.436057273237 | (37.7159873981889, -122.436057273237) | |
| 994 | 994 | 160370 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 868 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001693.73373 | 2088950.71414 | 37.715956825716 | -122.436078353349 | (37.715956825716, -122.436078353349) | |
| 1180 | 1180 | 251470 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 194 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777454 | 6009558.57553 | 2094850.0846799999 | 37.7325989441491 | -122.409309728531 | (37.7325989441491, -122.409309728531) | |
| 1436 | 1436 | 251534 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1818 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2017 12:00:00 AM | 3 | 3x3 | 5983226.0 | 2102732.0 | 37.7527300247516 | -122.500929082058 | (37.7527300247516, -122.500929082058) | ||
| 1451 | 1451 | 251539 | Planning Code 138.1 required 4 | Brahea edulis :: Guadalupe Palm 115 | 1746 Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981086.0 | 2103156.0 | 37.753768326371 | -122.50836092480499 | (37.753768326371, -122.508360924805) | ||||
| 1459 | 1459 | 251538 | Planning Code 138.1 required 4 | Brahea edulis :: Guadalupe Palm 115 | 1746 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2001 12:00:00 AM | 3x3 | 5981086.0 | 2103156.0 | 37.753768326371 | -122.50836092480499 | (37.753768326371, -122.508360924805) | |||
| 1934 | 1934 | 252840 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 80 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997842.0 | 2113206.0 | 37.782336294689 | -122.45113984781099 | (37.782336294689, -122.451139847811) | ||||
| 2025 | 2025 | 243143 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98x Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195.0 | 2098242.0 | 37.7417233638646 | -122.42117921336501 | (37.7417233638646, -122.421179213365) | ||
| 2032 | 2032 | 243144 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98x Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195.0 | 2098242.0 | 37.7417233638646 | -122.42117921336501 | (37.7417233638646, -122.421179213365) | ||
| 2142 | 2142 | 252906 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 600 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | |
| 2143 | 2143 | 252905 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 600 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | |
| 2147 | 2147 | 252908 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 600 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | |
| 2571 | 2571 | 253124 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 399x Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780530 |
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");