Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128 | 128 | 212622 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 115 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991392.0 | 2089980.0 | 37.718192344870296 | -122.471760605115 | (37.7181923448703, -122.471760605115) | |||
| 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) | ||||
| 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) | ||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 362 | 362 | 187139 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 0ft | 5984937.035 | 2099496.8257 | 37.7439474344515 | -122.494773601416 | (37.7439474344515, -122.494773601416) | |||
| 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) | ||||
| 682 | 682 | 251365 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 712 | 712 | 251366 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 3 | 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 | ||||||||||
| 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) | ||||
| 810 | 810 | 212202 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 800 Bosworth St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6001677.26505 | 2095571.4535400001 | 37.734134940976 | -122.43660890297501 | (37.734134940976, -122.436608902975) | ||||
| 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) | ||||
| 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) | |||||
| 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) | |||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 1700 | 1700 | 123453 | Undocumented 2 | Photinia fraseri :: Photinia Tree 153 | 713 02nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779827 | 5995319.78488 | 2110672.1771299997 | 37.7752343616797 | -122.459681952866 | (37.7752343616797, -122.459681952866) | |
| 1715 | 1715 | 123454 | Undocumented 2 | Photinia fraseri :: Photinia Tree 153 | 713 02nd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | Permit Number 779827 | 5995320.73299 | 2110668.0352 | 37.7752230435543 | -122.459678373092 | (37.7752230435543, -122.459678373092) | ||
| 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) | ||||
| 1872 | 1872 | 177039 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 178 Seville St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6001177.23506 | 2087434.66895 | 37.711764745717 | -122.437755094333 | (37.711764745717, -122.437755094333) | |||
| 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) | |||||
| 2003 | 2003 | 127110 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3201 Laguna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 6ft | 6003718.35126 | 2119752.0994 | 37.8006449063974 | -122.431277695812 | (37.8006449063974, -122.431277695812) | |||
| 2059 | 2059 | 173596 | Significant Tree 6 | Tree(s) :: 17 | 200 Howard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | Permit Number 779179 | 6014439.0 | 2115766.0 | 37.790301726009204 | -122.393900378517 | (37.7903017260092, -122.393900378517) | |||
| 2068 | 2068 | 158899 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 253 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 0 | Width 0ft | 5998481.355769999 | 2093479.93721 | 37.7282099959864 | -122.447507621406 | (37.7282099959864, -122.447507621406) | |||
| 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) | |||
| 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) | ||||
| 2593 | 2593 | 155952 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 Manor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/20/2017 12:00:00 AM | 3 | 5993448.18795 | 2093194.64055 | 37.7271377226027 | -122.464886627823 | (37.7271377226027, -122.464886627823) | |||
| 2939 | 2939 | 203654 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 42 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | 6001070.39767 | 2095226.13763 | 37.7331522778487 | -122.438682294452 | (37.7331522778487, -122.438682294452) | ||
| 2953 | 2953 | 192045 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013178.04643 | 2110099.77457 | 37.7746734191738 | -122.39786558493401 | (37.7746734191738, -122.397865584934) | |
| 2963 | 2963 | 192048 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013251.73009 | 2110171.5616599997 | 37.7748746334969 | -122.39761573260401 | (37.7748746334969, -122.397615732604) | |
| 2964 | 2964 | 192047 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013240.399669999 | 2110155.0455099996 | 37.7748286529654 | -122.397653768512 | (37.7748286529654, -122.397653768512) | |
| 2976 | 2976 | 198801 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150 Executive Park Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 0 | Width 4ft | 6013745.097 | 2086994.3966599999 | 37.7112624653484 | -122.394285983735 | (37.7112624653484, -122.394285983735) | |||
| 2979 | 2979 | 192049 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013269.505969999 | 2110186.9808900002 | 37.77491796101779 | -122.397555323332 | (37.7749179610178, -122.397555323332) | |
| 2980 | 2980 | 192046 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013200.03931 | 2110117.49199 | 37.774723291973096 | -122.39779074965 | (37.7747232919731, -122.39779074965) | |
| 3005 | 3005 | 208852 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 42 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | 6001113.97001 | 2095223.0116299998 | 37.733146173254205 | -122.43853142959101 | (37.7331461732542, -122.438531429591) | ||
| 3009 | 3009 | 192050 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013285.99525 | 2110202.74852 | 37.774962173497 | -122.39749938908501 | (37.774962173497, -122.397499389085) | |
| 3142 | 3142 | 217765 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 470 West Portal Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 42 | Width 10ft | 5991548.70787 | 2096139.0246599999 | 37.7351125606845 | -122.471667523249 | (37.7351125606845, -122.471667523249) | |||
| 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) | |
| 3186 | 3186 | 218743 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 141 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 8 | Width 3ft | Permit Number 25334 | 5995930.5324099995 | 2096235.39856 | 37.7356297230374 | -122.456525038998 | (37.7356297230374, -122.456525038998) | |
| 3187 | 3187 | 207331 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 432 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/05/2002 12:00:00 AM | 8 | Width 8ft | Permit Number 45704 | 6000124.74065 | 2095150.49618 | 37.7328907415174 | -122.441946248045 | (37.7328907415174, -122.441946248045) | |
| 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) | ||||
| 3527 | 3527 | 205481 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 100 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | Width 8ft | 5998772.56194 | 2093243.78905 | 37.7275782258363 | -122.446483932112 | (37.7275782258363, -122.446483932112) | ||
| 3530 | 3530 | 123324 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 798 05th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Permit Number 780721 | 5994466.95086 | 2110266.43708 | 37.7740712286384 | -122.462602639066 | (37.7740712286384, -122.462602639066) | |||
| 3540 | 3540 | 123527 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2850 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | Permit Number 780721 | 5994500.1201 | 2110215.1995599996 | 37.77393245416361 | -122.462484184544 | (37.7739324541636, -122.462484184544) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 3579 | 3579 | 123325 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 798 05th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Permit Number 780721 | 5994467.5512 | 2110242.48836 | 37.7740055063811 | -122.46259882484101 | (37.7740055063811, -122.462598824841) | |||
| 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) | ||
| 3856 | 3856 | 246917 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5997637.485090001 | 2107521.28402 | 37.766715824697 | -122.451437229753 | (37.766715824697, -122.451437229753) | |||
| 3903 | 3903 | 220233 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Ashbury St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/23/1987 12:00:00 AM | 39 | Width 4ft | Permit Number 12054 | 5999170.85741 | 2106639.03394 | 37.764381073148705 | -122.44607010996201 | (37.7643810731487, -122.446070109962) | |
| 4028 | 4028 | 216741 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 990 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/05/2017 07:49:00 AM | 3 | Width 4ft | 5995950.8772 | 2090428.1380900003 | 37.719685546243895 | -122.456034989421 | (37.7196855462439, -122.456034989421) | ||
| 4068 | 4068 | 216743 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 990 Plymouth Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/05/2017 07:52:00 AM | 3 | Width 4ft | 5995950.66479 | 2090454.56836 | 37.7197581053329 | -122.45603763343901 | (37.7197581053329, -122.456037633439) | ||
| 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) | ||||
| 4549 | 4549 | 226945 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 1ft | 6001140.61217 | 2096125.6115299999 | 37.735626018710896 | -122.438503967885 | (37.7356260187109, -122.438503967885) | |||
| 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) | ||||
| 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) | ||||
| 4729 | 4729 | 123750 | Undocumented 2 | Prunus laurocerasus :: English laurel 227 | 2 Cabrillo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5995617.0 | 2110854.0 | 37.775750686051005 | -122.458666990683 | (37.775750686051, -122.458666990683) | |||
| 4757 | 4757 | 179682 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 501X San Juan Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6000425.2781 | 2092808.87665 | 37.726478317196204 | -122.44073930839 | (37.7264783171962, -122.44073930839) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 9629 | 9629 | 173614 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2955 20th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.4495400002 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | |
| 9631 | 9631 | 173613 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2955 20th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.4495400002 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | |
| 9639 | 9639 | 114121 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9640 | 9640 | 114128 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9642 | 9642 | 114119 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9645 | 9645 | 114115 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9646 | 9646 | 114139 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9648 | 9648 | 114133 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9649 | 9649 | 114125 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9650 | 9650 | 114131 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 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) | |||
| 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) | ||||
| 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) |
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");