Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9652 | 9652 | 114118 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9653 | 9653 | 114116 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9654 | 9654 | 114138 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/16/2016 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 9655 | 9655 | 114155 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 128 | 1200X JUNIPERO SERRA BLVD | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||||
| 9656 | 9656 | 114151 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9657 | 9657 | 114153 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9658 | 9658 | 114124 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9659 | 9659 | 114136 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9661 | 9661 | 114148 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9662 | 9662 | 114130 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9663 | 9663 | 114120 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||||
| 9664 | 9664 | 114135 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9665 | 9665 | 114123 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9666 | 9666 | 114127 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9669 | 9669 | 114126 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9671 | 9671 | 114132 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9672 | 9672 | 114137 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9673 | 9673 | 114129 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9675 | 9675 | 114114 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9676 | 9676 | 114117 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9677 | 9677 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9678 | 9678 | 114134 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9679 | 9679 | 114122 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9680 | 9680 | 173618 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||||
| 9989 | 9989 | 173658 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 9996 | 9996 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 9997 | 9997 | 173656 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10001 | 10001 | 173622 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10002 | 10002 | 114158 | Significant Tree 6 | Prunus armeniaca :: Apricot 259 | 1200X JUNIPERO SERRA BLVD | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10003 | 10003 | 173619 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10004 | 10004 | 114140 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10009 | 10009 | 173621 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10011 | 10011 | 173616 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1200X JUNIPERO SERRA BLVD | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10013 | 10013 | 173624 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10017 | 10017 | 173623 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10018 | 10018 | 173657 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10022 | 10022 | 173620 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10024 | 10024 | 173625 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1200X Junipero Serra Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 82589 | 82589 | 114111 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 85483 | 85483 | 114112 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 89097 | 89097 | 114144 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 89972 | 89972 | 114147 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 118401 | 118401 | 114145 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 119630 | 119630 | 114110 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 140509 | 140509 | 114146 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 144837 | 144837 | 114113 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 10020 | 10020 | 115676 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X Junipero Serra Blvd | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.2 | 2089585.5 | 37.717093588438 | -122.472660975441 | (37.717093588438, -122.472660975441) | |||
| 109591 | 109591 | 115677 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x Junipero Serra Blvd | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5991123.2 | 2089585.5 | 37.717093588438 | -122.472660975441 | (37.717093588438, -122.472660975441) | ||||
| 182080 | 182080 | 197888 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 955 Key Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6013536.79803 | 2089586.31829 | 37.7183677903304 | -122.395187363419 | (37.7183677903304, -122.395187363419) | ||||
| 9667 | 9667 | 11795 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | ||||
| 99816 | 99816 | 11794 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | |||
| 114205 | 114205 | 114109 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | ||||
| 120454 | 120454 | 11793 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | |||
| 124841 | 124841 | 11792 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1200X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | |||
| 137121 | 137121 | 179606 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 247 Mount Vernon Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5998687.8621 | 2089587.2484799998 | 37.717533374149205 | -122.44651378328501 | (37.7175333741492, -122.446513783285) | ||||
| 58289 | 58289 | 95775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 674 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767509 | 6002729.6643199995 | 2089587.30224 | 37.7177635556125 | -122.432543138167 | (37.7177635556125, -122.432543138167) |
| 184066 | 184066 | 176047 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5988958.7133 | 2089588.42281 | 37.7169760831658 | -122.480142699133 | (37.7169760831658, -122.480142699133) | ||||
| 4728 | 4728 | 160846 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 669 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 12:20:00 PM | 3 | Width 0ft | 6002781.71244 | 2089588.8302099998 | 37.717770702526295 | -122.432363340291 | (37.7177707025263, -122.432363340291) | |
| 114507 | 114507 | 66347 | Permitted Site 1 | Tree(s) :: 17 | 225 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1990 12:00:00 AM | Permit Number 29468 | 6001241.49729384 | 2089589.21674647 | 37.7176843080523 | -122.437687193351 | (37.7176843080523, -122.437687193351) | |||
| 137481 | 137481 | 177797 | Undocumented 2 | Musa spp :: Banana 371 | 247 Mount Vernon Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5998689.65231 | 2089589.5956599999 | 37.7175399212214 | -122.446507764144 | (37.7175399212214, -122.446507764144) | ||||
| 134563 | 134563 | 192745 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3429 Jennings St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6013179.5796 | 2089589.99773 | 37.71835802098379 | -122.396422384394 | (37.7183580209838, -122.396422384394) | ||||
| 10545 | 10545 | 55314 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1108 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 9 | 3x12 | Permit Number 11243 | 6011262.01011 | 2089590.5676900002 | 37.7182526888019 | -122.40305069543301 | (37.7182526888019, -122.403050695433) | |
| 110498 | 110498 | 114987 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 157 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | Permit Number 775985 | 5995400.7 | 2089591.3 | 37.7173561925503 | -122.45787621793899 | (37.7173561925503, -122.457876217939) | |||
| 176248 | 176248 | 217532 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 10 Caine Ave | 12 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5997565.18295 | 2089591.75195 | 37.7174815498251 | -122.450394677186 | (37.7174815498251, -122.450394677186) | |||
| 168554 | 168554 | 179603 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998658.1578 | 2089592.8520799999 | 37.7175470636356 | -122.446616859994 | (37.7175470636356, -122.446616859994) | |||
| 104735 | 104735 | 60459 | Permitted Site 1 | Tree(s) :: 17 | 68 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1982 12:00:00 AM | Permit Number 20045 | 5997217.96060042 | 2089592.86440605 | 37.7174647258552 | -122.451594939233 | (37.7174647258552, -122.451594939233) | |||
| 15656 | 15656 | 14874 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 6625X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2007 12:00:00 AM | 3 | 3x3 | 6012798.61753 | 2089593.2679700002 | 37.7183457929117 | -122.397739448711 | (37.7183457929117, -122.397739448711) | ||
| 134893 | 134893 | 175260 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 267 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004062.93179 | 2089593.3690900002 | 37.7178557316298 | -122.42793505965 | (37.7178557316298, -122.42793505965) | |||
| 172661 | 172661 | 200207 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1001 Gilman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015388.3475 | 2089594.6926 | 37.71849358038929 | -122.388787860953 | (37.7184935803893, -122.388787860953) | |||
| 113946 | 113946 | 32761 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 33 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37136 | 5996219.65696769 | 2089595.16443256 | 37.7174138200875 | -122.455045760827 | (37.7174138200875, -122.455045760827) | ||
| 177073 | 177073 | 207611 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 64 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5997222.96665 | 2089595.38167 | 37.717471924360794 | -122.45157781718599 | (37.7174719243608, -122.451577817186) | |||
| 61435 | 61435 | 179605 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 247 Mount Vernon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5998680.84891 | 2089595.4146 | 37.7175553958555 | -122.446538611763 | (37.7175553958555, -122.446538611763) | ||||
| 104630 | 104630 | 11816 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
| 112455 | 112455 | 11817 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
| 122991 | 122991 | 11815 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
| 127707 | 127707 | 11818 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
| 139406 | 139406 | 11819 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
| 46809 | 46809 | 177278 | Undocumented 2 | Magnolia champaca :: Champa 170 | 247 Mount Vernon Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998683.47325 | 2089596.01015 | 37.7175571809995 | -122.446529583477 | (37.7175571809995, -122.446529583477) | ||||
| 49286 | 49286 | 207854 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 258 Vernon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5992483.5365 | 2089596.1759 | 37.717201552190105 | -122.467959759631 | (37.7172015521901, -122.467959759631) | |||
| 71103 | 71103 | 180138 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 717 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002148.35393 | 2089596.3465900002 | 37.7177554068775 | -122.434553112137 | (37.7177554068775, -122.434553112137) | |||
| 23540 | 23540 | 50495 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 678 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 3 | Permit Number 47131 | 6001459.37999 | 2089596.3595900002 | 37.7177163070325 | -122.436934583487 | (37.7177163070325, -122.436934583487) | |
| 81697 | 81697 | 47681 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 57 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | Permit Number 45470 | 5996114.455132401 | 2089596.36116965 | 37.7174110701656 | -122.45540947913601 | (37.7174110701656, -122.455409479136) | ||
| 19833 | 19833 | 26915 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 10 Caine Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/26/1999 12:00:00 AM | 3 | 10 | 5997570.4467 | 2089598.1443599998 | 37.7174994031582 | -122.450376943463 | (37.7174994031582, -122.450376943463) | ||
| 81157 | 81157 | 60456 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 61 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2016 12:00:00 AM | 3 | Permit Number 20042 | 5997285.07727817 | 2089598.28264445 | 37.7174834464697 | -122.451363339533 | (37.7174834464697, -122.451363339533) | |
| 99332 | 99332 | 114425 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 61 Majestic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2016 12:00:00 AM | 3 | 5997285.07727817 | 2089598.28264445 | 37.7174834464697 | -122.451363339533 | (37.7174834464697, -122.451363339533) | ||
| 41426 | 41426 | 176252 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 95 Delta St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010107.1247 | 2089599.03617 | 37.7182113811213 | -122.407043259958 | (37.7182113811213, -122.407043259958) | |||
| 65750 | 65750 | 207490 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 13 Thrift St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996346.95254 | 2089599.2142 | 37.717432241793205 | -122.45460605392401 | (37.7174322417932, -122.454606053924) | |||
| 54791 | 54791 | 175874 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1441 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5999110.44202 | 2089599.42923 | 37.717590947838104 | -122.44505399834699 | (37.7175909478381, -122.445053998347) | |||
| 181898 | 181898 | 175416 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 242 Mount Vernon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998753.41529 | 2089599.85175 | 37.717571723930604 | -122.446288102908 | (37.7175717239306, -122.446288102908) | ||||
| 33211 | 33211 | 200211 | Undocumented 2 | :: 54 | 974 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014078.3317 | 2089599.8969999999 | 37.7184351760665 | -122.39331644356001 | (37.7184351760665, -122.39331644356) | |||
| 53101 | 53101 | 177277 | Undocumented 2 | Magnolia champaca :: Champa 170 | 247 Mount Vernon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998677.48032 | 2089600.90365 | 37.7175702751156 | -122.446550650088 | (37.7175702751156, -122.446550650088) | ||||
| 94368 | 94368 | 34183 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 306 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/1997 12:00:00 AM | Permit Number 38009 | 5996911.10451573 | 2089600.92218112 | 37.7174692729069 | -122.452656174904 | (37.7174692729069, -122.452656174904) | |||
| 23923 | 23923 | 180093 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 5999825.21966 | 2089601.0341900003 | 37.717636125294206 | -122.44258345996799 | (37.7176361252942, -122.442583459968) | |||
| 36817 | 36817 | 176286 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 901 Delano Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5998666.60141 | 2089601.1299700001 | 37.7175702751322 | -122.446588269645 | (37.7175702751322, -122.446588269645) | |||
| 109575 | 109575 | 108838 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 267 Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774666 | 6004068.9172 | 2089601.41292 | 37.717878156846 | -122.42791494359501 | (37.717878156846, -122.427914943595) | |
| 38103 | 38103 | 179604 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998666.20237 | 2089602.87221 | 37.7175750361301 | -122.44658977421801 | (37.7175750361301, -122.446589774218) | |||
| 155390 | 155390 | 176273 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 179 Niagara Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5999314.98259 | 2089602.87456 | 37.717612080124205 | -122.444347244552 | (37.7176120801242, -122.444347244552) | |||
| 165591 | 165591 | 95774 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 674 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767509 | 6002740.18183 | 2089602.96297 | 37.7178071529464 | -122.432507901839 | (37.7178071529464, -122.432507901839) |
| 114043 | 114043 | 39681 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 145 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41067 | 5995527.26769493 | 2089603.04086788 | 37.7173957009589 | -122.45743958411998 | (37.7173957009589, -122.45743958412) | ||
| 175950 | 175950 | 175945 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 901 Delano Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5998663.60507 | 2089603.57639 | 37.7175768212865 | -122.44659880250099 | (37.7175768212865, -122.446598802501) |
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");