Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5120 | 5120 | 253810 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 281 Ralston St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x6 | 5992187.95019 | 2089731.22021 | 37.7175552771373 | -122.46899127483299 | (37.7175552771373, -122.468991274833) | ||||
| 5078 | 5078 | 253759 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 330 Twin Peaks Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x6 | Permit Number 780692 | 5998725.10706 | 2103975.38052 | 37.75704188115579 | -122.44742009249201 | (37.7570418811558, -122.447420092492) | |||
| 5072 | 5072 | 253758 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 330 Twin Peaks Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x6 | Permit Number 780692 | 5998725.10706 | 2103975.38052 | 37.75704188115579 | -122.44742009249201 | (37.7570418811558, -122.447420092492) | |||
| 5061 | 5061 | 253757 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 330 Twin Peaks Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x6 | Permit Number 780692 | 5998725.10706 | 2103975.38052 | 37.75704188115579 | -122.44742009249201 | (37.7570418811558, -122.447420092492) | |||
| 4921 | 4921 | 253716 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2959 21st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5x15 | 5989962.0 | 2095532.0 | 37.733353897105495 | -122.477108940264 | (37.7333538971055, -122.477108940264) | ||||
| 4919 | 4919 | 253715 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 2959 21st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5x15 | 5989962.0 | 2095532.0 | 37.733353897105495 | -122.477108940264 | (37.7333538971055, -122.477108940264) | ||||
| 4764 | 4764 | 253679 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 94 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4x8 | 5997405.0 | 2099153.0 | 37.7437252916895 | -122.45163765514201 | (37.7437252916895, -122.451637655142) | ||||
| 4725 | 4725 | 253667 | Undocumented 2 | Juniperus californica :: California juniper 226 | 2 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Width 3ft | 5995617.0 | 2110854.0 | 37.775750686051005 | -122.458666990683 | (37.775750686051, -122.458666990683) | ||||
| 4659 | 4659 | 253652 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 131 Font Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 4344 | 4344 | 253624 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 735 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998960.0 | 2095994.0 | 37.735140362702396 | -122.446033688862 | (37.7351403627024, -122.446033688862) | ||||
| 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) | ||||
| 3577 | 3577 | 253466 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98X Marston Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3544 | 3544 | 253465 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3585 | 3585 | 253464 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3567 | 3567 | 253463 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3561 | 3561 | 253462 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 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) | ||||
| 3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
| 2503 | 2503 | 253120 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 815 Buena Vista Ave West | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x100 | 6000071.60031 | 2108311.04493 | 37.769023393565604 | -122.44307478834801 | (37.7690233935656, -122.443074788348) | ||||
| 3147 | 3147 | 253098 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1290 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035.0 | 2097938.0 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | ||
| 3158 | 3158 | 253097 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1290 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | DPW 4 | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035.0 | 2097938.0 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | |
| 2399 | 2399 | 253072 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1350 46th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5x10 | Permit Number 780489 | 5981849.666569999 | 2105897.22193 | 37.761339917853896 | -122.50592325662 | (37.7613399178539, -122.50592325662) | |||
| 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) | |||||
| 1956 | 1956 | 252838 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 99 Pond St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1736 | 1736 | 251677 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 772x Panorama Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996636.0 | 2102785.0 | 37.7536537924326 | -122.454558985212 | (37.7536537924326, -122.454558985212) | ||||
| 1680 | 1680 | 251668 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 301x Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5995349.0 | 2100852.0 | 37.7482723626065 | -122.458869747183 | (37.7482723626065, -122.458869747183) | ||||
| 2015 | 2015 | 251655 | DPW Maintained 3 | Shrub :: Shrub 98 | 300x Chester Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5991691.0 | 2087193.0 | 37.710557214846794 | -122.47052422929701 | (37.7105572148468, -122.470524229297) | ||||
| 1500 | 1500 | 251574 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 191 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999731.0 | 2100707.0 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | ||||
| 1438 | 1438 | 251533 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1201X Pierce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6002292.0 | 2112799.0 | 37.7814725496882 | -122.43571571002899 | (37.7814725496882, -122.435715710029) | ||||
| 1029 | 1029 | 251428 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5030 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | ||||
| 1034 | 1034 | 251427 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5028 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999606.0 | 2100130.0 | 37.7465337016449 | -122.44409733772801 | (37.7465337016449, -122.444097337728) | ||||
| 1027 | 1027 | 251426 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 5020 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999455.0 | 2100046.0 | 37.7462944425817 | -122.44461344107401 | (37.7462944425817, -122.444613441074) | |||||
| 1025 | 1025 | 251425 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 128 | 5016 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | |||||
| 1030 | 1030 | 251424 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 5016 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | ||||
| 818 | 818 | 251389 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 202x Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999774.0 | 2095231.0 | 37.7330917931436 | -122.44316462438499 | (37.7330917931436, -122.443164624385) | ||||
| 782 | 782 | 251385 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 784 | 784 | 251384 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 712 | 712 | 251366 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 682 | 682 | 251365 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 713 | 713 | 251364 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 545 | 545 | 251322 | Undocumented 2 | Betula spp :: Birch 95 | 828 Foerster St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Width 3ft | 5998302.82159 | 2096489.58159 | 37.7364635618398 | -122.448341458403 | (37.7364635618398, -122.448341458403) | ||||
| 277 | 277 | 251265 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 272 | 272 | 251264 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 300 | 300 | 251263 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 293 | 293 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 251 | 251 | 251258 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1748x Eucalyptus Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5986101.0 | 2094852.0 | 37.7312620395563 | -122.490407299046 | (37.7312620395563, -122.490407299046) | ||||
| 241 | 241 | 251257 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1748x Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5986101.0 | 2094852.0 | 37.7312620395563 | -122.490407299046 | (37.7312620395563, -122.490407299046) | ||||
| 24522 | 24522 | 251177 | Undocumented 2 | Tree(s) :: 17 | 178 Bluxome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6012557.0 | 2110038.0 | 37.7744691941496 | -122.400009583897 | (37.7744691941496, -122.400009583897) | ||||
| 22896 | 22896 | 251145 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996559.0 | 2104265.0 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | ||||
| 22892 | 22892 | 251144 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996559.0 | 2104265.0 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | ||||
| 156361 | 156361 | 250992 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 401 45th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5981868.90383 | 2112895.86911 | 37.7805572993057 | -122.50637573525299 | (37.7805572993057, -122.506375735253) | |||
| 56135 | 56135 | 250989 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 401 45th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5981864.98937 | 2112954.2603599997 | 37.7807173939441 | -122.506393608376 | (37.7807173939441, -122.506393608376) | ||||
| 25083 | 25083 | 250988 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 401 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981857.67732 | 2112961.27677 | 37.780736228431394 | -122.50641942431999 | (37.7807362284314, -122.50641942432) | ||||
| 26191 | 26191 | 250755 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2930 Lake St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5986296.61932 | 2114541.51737 | 37.78533546029529 | -122.491179523725 | (37.7853354602953, -122.491179523725) | |||
| 148512 | 148512 | 250682 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 760 El Camino Del Mar | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5986116.1315 | 2114915.54539 | 37.7863518857815 | -122.491831493528 | (37.7863518857815, -122.491831493528) | |||
| 57095 | 57095 | 250681 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 760 El Camino Del Mar | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5986129.95377 | 2114905.93928 | 37.786326318052204 | -122.49178296523701 | (37.7863263180522, -122.491782965237) | |||
| 40537 | 40537 | 250680 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 760 El Camino Del Mar | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5986144.61668 | 2114895.8917799997 | 37.7862995875046 | -122.491731496117 | (37.7862995875046, -122.491731496117) | |||
| 148317 | 148317 | 250651 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 142 El Camino Del Mar | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 4ft | 5988051.29763 | 2115371.58762 | 37.78771696311829 | -122.48516986981501 | (37.7877169631183, -122.485169869815) | |||
| 70053 | 70053 | 250650 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 142 El Camino Del Mar | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 5988068.63131 | 2115372.88737 | 37.787721541568 | -122.48510999475401 | (37.787721541568, -122.485109994754) | |||
| 71820 | 71820 | 250649 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 142 El Camino Del Mar | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 5988079.239440001 | 2115372.9404 | 37.7877223050946 | -122.485073297006 | (37.7877223050946, -122.485073297006) | |||
| 36196 | 36196 | 250612 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 7ft | 5998863.03763 | 2111421.5701099997 | 37.7774951176523 | -122.447479040039 | (37.7774951176523, -122.447479040039) | |||
| 163635 | 163635 | 250611 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998832.7511599995 | 2111418.50425 | 37.7774849687826 | -122.447583589827 | (37.7774849687826, -122.447583589827) | ||||
| 31539 | 31539 | 250610 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5998818.59622 | 2111415.77935 | 37.777476677952706 | -122.44763236005899 | (37.7774766779527, -122.447632360059) | ||||
| 185930 | 185930 | 250609 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998802.7301 | 2111413.8391299997 | 37.7774704438335 | -122.447687106294 | (37.7774704438335, -122.447687106294) | ||||
| 166559 | 166559 | 250608 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998787.15443 | 2111411.5145799997 | 37.777463171018205 | -122.447740820088 | (37.7774631710182, -122.447740820088) | ||||
| 169943 | 169943 | 250607 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998769.74892 | 2111409.2448299997 | 37.7774559440593 | -122.447800867812 | (37.7774559440593, -122.447800867812) | ||||
| 186988 | 186988 | 250606 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998755.1093 | 2111407.10323 | 37.777449227027795 | -122.447851356665 | (37.7774492270278, -122.447851356665) | ||||
| 152639 | 152639 | 250605 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998735.90805 | 2111405.0281 | 37.777442431746 | -122.44791763041401 | (37.777442431746, -122.447917630414) | ||||
| 149775 | 149775 | 250604 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998717.2926900005 | 2111402.6365099996 | 37.7774348009994 | -122.44798185458099 | (37.7774348009994, -122.447981854581) | ||||
| 164454 | 164454 | 250603 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998697.83635 | 2111399.4102 | 37.7774248302192 | -122.448048927835 | (37.7774248302192, -122.448048927835) | ||||
| 45361 | 45361 | 250602 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998679.25957 | 2111396.77415 | 37.7774165303825 | -122.448113000908 | (37.7774165303825, -122.448113000908) | ||||
| 44611 | 44611 | 250601 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998661.06901 | 2111393.5225 | 37.7774065623113 | -122.44817569357201 | (37.7774065623113, -122.448175693572) | ||||
| 50865 | 50865 | 250599 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5998631.4294 | 2111385.5677400003 | 37.7773830261474 | -122.44827765331499 | (37.7773830261474, -122.448277653315) | |||
| 176192 | 176192 | 250598 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 10ft | 5998612.86839 | 2111383.01591 | 37.7773749583343 | -122.448341677839 | (37.7773749583343, -122.448341677839) | |||
| 62280 | 62280 | 250596 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 5998572.26922 | 2111378.3859099997 | 37.7773599243436 | -122.44848178950899 | (37.7773599243436, -122.448481789509) | |||
| 137941 | 137941 | 250595 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | 5998510.6665900005 | 2111373.95167 | 37.777344226694495 | -122.44869457271099 | (37.7773442266945, -122.448694572711) | ||||
| 52572 | 52572 | 250594 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 5998426.00628 | 2111357.0235599997 | 37.7772929050689 | -122.448986219244 | (37.7772929050689, -122.448986219244) | |||
| 162932 | 162932 | 250593 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 7ft | 5998409.0493 | 2111353.9501099996 | 37.7772834963756 | -122.44904465719499 | (37.7772834963756, -122.449044657195) | |||
| 33389 | 33389 | 250592 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 7ft | 5998381.460969999 | 2111351.09812 | 37.7772740876697 | -122.44913988818999 | (37.7772740876697, -122.44913988819) | |||
| 30950 | 30950 | 250591 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 7ft | 5998359.83298 | 2111349.05645 | 37.7772672447332 | -122.44921455891199 | (37.7772672447332, -122.449214558912) | |||
| 131820 | 131820 | 250590 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | 5998102.22715 | 2111312.63197 | 37.7771524948281 | -122.45010307019501 | (37.7771524948281, -122.450103070195) | ||||
| 52831 | 52831 | 250589 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5997875.419290001 | 2111281.04875 | 37.7770527941865 | -122.450885388659 | (37.7770527941865, -122.450885388659) | ||||
| 23707 | 23707 | 250588 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | 5997756.4661 | 2111264.0896400004 | 37.7769994185268 | -122.45129565939399 | (37.7769994185268, -122.451295659394) | ||||
| 65004 | 65004 | 250587 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5997646.23108 | 2111248.80698 | 37.776951143824 | -122.451675891826 | (37.776951143824, -122.451675891826) | |||
| 70548 | 70548 | 250586 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 5997628.86615 | 2111246.4251 | 37.7769436093046 | -122.451735790285 | (37.7769436093046, -122.451735790285) | |||
| 24475 | 24475 | 250585 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 5997613.33684 | 2111244.7016 | 37.7769379876264 | -122.451789386298 | (37.7769379876264, -122.451789386298) | |||
| 25484 | 25484 | 250584 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5997564.36038 | 2111236.37019 | 37.7769123065995 | -122.451958208801 | (37.7769123065995, -122.451958208801) | ||||
| 71537 | 71537 | 250581 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5997509.5198800005 | 2111229.44513 | 37.776890150891795 | -122.45214741807699 | (37.7768901508918, -122.452147418077) | ||||
| 55672 | 55672 | 250580 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 8ft | 5997493.10232 | 2111228.13721 | 37.7768856192175 | -122.45220411672399 | (37.7768856192175, -122.452204116724) | |||
| 26036 | 26036 | 250579 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5997478.12296 | 2111225.14885 | 37.7768765558548 | -122.452255718936 | (37.7768765558548, -122.452255718936) | |||
| 177444 | 177444 | 250578 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 5997460.213380001 | 2111222.95498 | 37.7768695060652 | -122.452317514945 | (37.7768695060652, -122.452317514945) | |||
| 169298 | 169298 | 250577 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 8ft | 5997444.6396 | 2111219.7245400003 | 37.776859743909895 | -122.452371155927 | (37.7768597439099, -122.452371155927) | |||
| 60845 | 60845 | 250576 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 8ft | 5997348.720930001 | 2111207.04633 | 37.7768194372103 | -122.452702050664 | (37.7768194372103, -122.452702050664) | |||
| 50298 | 50298 | 250575 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | 5997256.45682 | 2111186.28266 | 37.776757138456794 | -122.453019719107 | (37.7767571384568, -122.453019719107) | ||||
| 161181 | 161181 | 250574 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 5997258.88405 | 2111163.19525 | 37.77669388555061 | -122.453009655693 | (37.7766938855506, -122.453009655693) | ||||
| 72328 | 72328 | 250573 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5997263.272609999 | 2111141.17003 | 37.7766336615401 | -122.45299288421002 | (37.7766336615401, -122.45299288421) | ||||
| 1387 | 1387 | 250572 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/15/2017 12:00:00 AM | 3 | Permit Number 779711 | 5997267.39343 | 2111112.94332 | 37.7765563945078 | -122.45297659119 | (37.7765563945078, -122.45297659119) | ||
| 176048 | 176048 | 250571 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5997270.54496 | 2111084.7365 | 37.7764791265377 | -122.45296365267299 | (37.7764791265377, -122.452963652673) | ||||
| 23781 | 23781 | 250570 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5997272.199569999 | 2111059.97973 | 37.7764112457195 | -122.452956141515 | (37.7764112457195, -122.452956141515) | ||||
| 69246 | 69246 | 250569 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 5997276.1967400005 | 2111033.33857 | 37.7763383251004 | -122.452940390794 | (37.7763383251004, -122.452940390794) |
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");