Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
767 | 767 | 251382 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 731 Huron Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
999 | 999 | 251422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 480x De Long St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992963.0 | 2086633.0 | 37.709093057147996 | -122.466087289133 | (37.709093057148, -122.466087289133) | |||||
1493 | 1493 | 103663 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
1557 | 1557 | 251590 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 340x Vicente St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5991910.0 | 2097743.0 | 37.739537567792894 | -122.47053520105601 | (37.7395375677929, -122.470535201056) | ||||
1633 | 1633 | 251599 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 740 Moraga St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992006.0 | 2103899.0 | 37.756445907456396 | -122.470651540396 | (37.7564459074564, -122.470651540396) | ||||
1686 | 1686 | 251474 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 32nd Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779951 | 5985659.0 | 2114437.0 | 37.78501121016021 | -122.493377758762 | (37.7850112101602, -122.493377758762) | |
1694 | 1694 | 251475 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 32nd Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779951 | 5985659.0 | 2114437.0 | 37.78501121016021 | -122.493377758762 | (37.7850112101602, -122.493377758762) | |
1712 | 1712 | 251473 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 32nd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779951 | 5985659.0 | 2114437.0 | 37.78501121016021 | -122.493377758762 | (37.7850112101602, -122.493377758762) | |
1907 | 1907 | 251816 | Undocumented 2 | Acer spp :: Maple 158 | 1800 Ellis St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6002197.0 | 2113045.0 | 37.782142606902205 | -122.436061972283 | (37.7821426069022, -122.436061972283) | ||||
2071 | 2071 | 252870 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 716 McAllister St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | ||||
2081 | 2081 | 252873 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Broderick St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||||
2100 | 2100 | 178279 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 4 | Width 0ft | 5987917.15522 | 2088760.91322 | 37.714643374877895 | -122.48368218070499 | (37.7146433748779, -122.483682180705) | |||
2126 | 2126 | 252903 | Undocumented 2 | Private shrub :: Private Shrub 64 | 215 Capistrano Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6001180.0 | 2093207.0 | 37.727614424830705 | -122.438158778943 | (37.7276144248307, -122.438158778943) | |||||
2497 | 2497 | 252857 | Undocumented 2 | Tree(s) :: 17 | 124 Persia Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 780172 | 6002102.0 | 2091308.0 | 37.7224525933916 | -122.43483567372 | (37.7224525933916, -122.43483567372) | |||
3031 | 3031 | 78440 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 953 Key Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/12/2002 12:00:00 AM | 31 | 6013574.75289 | 2089557.5945599999 | 37.7182910313742 | -122.395054157617 | (37.7182910313742, -122.395054157617) | |||
3034 | 3034 | 253070 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 132 Sagamore St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 0ft | Permit Number 780451 | 5995539.3842400005 | 2087458.9579900003 | 37.7115092483173 | -122.45724268539699 | (37.7115092483173, -122.457242685397) | |||
3044 | 3044 | 253288 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 650 Peru Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | |||||
3046 | 3046 | 253289 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 650 Peru Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | |||||
3049 | 3049 | 253290 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 650 Peru Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | |||||
3050 | 3050 | 253291 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 650 Peru Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | |||||
3284 | 3284 | 253385 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1100 Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004275.0 | 2112509.0 | 37.780788718892204 | -122.428834805692 | (37.7807887188922, -122.428834805692) | |||||
3286 | 3286 | 253400 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 1555 Evans Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | ||||
3303 | 3303 | 253399 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 1555 Evans Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | ||||
3311 | 3311 | 253404 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 1555 Evans Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | ||||
3313 | 3313 | 253405 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 1555 Evans Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | ||||
3686 | 3686 | 253401 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
3689 | 3689 | 252876 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Baker St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||||
3690 | 3690 | 253398 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
3692 | 3692 | 253403 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
3693 | 3693 | 252877 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1400 Baker St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||||
3694 | 3694 | 252874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Post St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000387.0 | 2114050.0 | 37.784799083264396 | -122.44239591065 | (37.7847990832644, -122.44239591065) | ||||
3696 | 3696 | 253396 | Undocumented 2 | Tree(s) :: 17 | 400x Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6016185.0 | 2098125.0 | 37.741960230665995 | -122.38662864108801 | (37.741960230666, -122.386628641088) | |
3697 | 3697 | 253402 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
3699 | 3699 | 253406 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
3703 | 3703 | 253397 | Undocumented 2 | Tree(s) :: 17 | 400x Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6016185.0 | 2098125.0 | 37.741960230665995 | -122.38662864108801 | (37.741960230666, -122.386628641088) | |
3733 | 3733 | 175357 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 5ft | 5992890.63105 | 2087809.5806900002 | 37.7123194916216 | -122.466422861444 | (37.7123194916216, -122.466422861444) | |||
3738 | 3738 | 175361 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 5ft | 5993097.02114 | 2087813.9243700001 | 37.7123433254574 | -122.465709836634 | (37.7123433254574, -122.465709836634) | |||
3740 | 3740 | 175359 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 5ft | 5993023.53483 | 2087808.23472 | 37.7123234639353 | -122.465963412176 | (37.7123234639353, -122.465963412176) | |||
3747 | 3747 | 175360 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 5ft | 5993054.1062900005 | 2087811.2090200002 | 37.7123333942521 | -122.46585796488002 | (37.7123333942521, -122.46585796488) | |||
3748 | 3748 | 175358 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 5ft | 5992915.27224 | 2087806.8926400002 | 37.7123135327144 | -122.466337499576 | (37.7123135327144, -122.466337499576) | |||
3756 | 3756 | 252875 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Post St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000387.0 | 2114050.0 | 37.784799083264396 | -122.44239591065 | (37.7847990832644, -122.44239591065) | ||||
3804 | 3804 | 253558 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1240 Wisconsin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012830.0 | 2101639.0 | 37.7514226163546 | -122.39847574638901 | (37.7514226163546, -122.398475746389) | |||||
3851 | 3851 | 252871 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2557 Sutter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5999847.0 | 2113975.0 | 37.7845623594454 | -122.444258736096 | (37.7845623594454, -122.444258736096) | |||||
4105 | 4105 | 253605 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 301 Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5997753.0 | 2098469.0 | 37.741867117319 | -122.45038506263799 | (37.741867117319, -122.450385062638) | ||||
4383 | 4383 | 253609 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 318 Utah St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 4ft | Permit Number 780845 | 6010580.39617 | 2106780.39752 | 37.7654141639451 | -122.40661745795299 | (37.7654141639451, -122.406617457953) | |||
4693 | 4693 | 253655 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1048 Ingalls St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6018024.0 | 2094000.0 | 37.7307354351655 | -122.379983340658 | (37.7307354351655, -122.379983340658) | ||||
4881 | 4881 | 253712 | Undocumented 2 | Pittosporum spp :: Pittosporum spp 128 | 339 Vienna St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 3ft | 6003970.0 | 2091429.0 | 37.7228907132276 | -122.428387044746 | (37.7228907132276, -122.428387044746) | ||||
5598 | 5598 | 103666 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
7764 | 7764 | 103662 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
8408 | 8408 | 103664 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
9972 | 9972 | 173766 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
9974 | 9974 | 173765 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
9975 | 9975 | 173768 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
9976 | 9976 | 173769 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
9978 | 9978 | 173767 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
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) | |||
10099 | 10099 | 173842 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 288X Graystone Ter | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999483.0 | 2103863.0 | 37.7567765924541 | -122.444790942005 | (37.7567765924541, -122.444790942005) | |||||
10665 | 10665 | 103665 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
11415 | 11415 | 103667 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
17977 | 17977 | 116827 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 14 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
18891 | 18891 | 107407 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 171 TWIN PEAKS BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5998631.4 | 2104681.4 | 37.7589750798494 | -122.44779499190099 | (37.7589750798494, -122.447794991901) | ||||
22288 | 22288 | 237856 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 636 30th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6002455.57988 | 2098272.49197 | 37.7415955682714 | -122.434111048608 | (37.7415955682714, -122.434111048608) | |||
22822 | 22822 | 248039 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 21 Rutledge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010496.95071 | 2099420.9430400003 | 37.745202070015296 | -122.406387476112 | (37.7452020700153, -122.406387476112) | ||||
22891 | 22891 | 247616 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Bradford St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6009490.26965 | 2096786.7692099998 | 37.737912836413706 | -122.409682528235 | (37.7379128364137, -122.409682528235) | ||||
23388 | 23388 | 191040 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1301 Minnesota St | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6015380.38588 | 2102504.53618 | 37.75394094514021 | -122.389716581452 | (37.7539409451402, -122.389716581452) | ||||
23442 | 23442 | 187500 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005130.65162 | 2086494.3835099998 | 37.709406927448796 | -122.424024164397 | (37.7094069274488, -122.424024164397) | ||||
23496 | 23496 | 222676 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 701 Church St | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6004317.3839 | 2104765.72552 | 37.7595299645462 | -122.428136192139 | (37.7595299645462, -122.428136192139) | |||
23547 | 23547 | 125572 | Undocumented 2 | Araucaria columnaris :: Coral reef araucaria 185 | 1120 Greenwich St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6007488.07621 | 2119895.66738 | 37.8012520198356 | -122.418243052479 | (37.8012520198356, -122.418243052479) | ||||
23804 | 23804 | 223982 | Undocumented 2 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 107 | 1000 San Jose Ave | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6005159.471609999 | 2097237.42875 | 37.738906606148205 | -122.424688283133 | (37.7389066061482, -122.424688283133) | ||||
23865 | 23865 | 188421 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 602 Arthur Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015740.2817 | 2099823.35637 | 37.7465989366059 | -122.388284852668 | (37.7465989366059, -122.388284852668) | ||||
23907 | 23907 | 247195 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 900 Waller St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6001251.021869999 | 2108666.7471 | 37.7700672400275 | -122.43902074711201 | (37.7700672400275, -122.439020747112) | ||||
23909 | 23909 | 249678 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2400 Baker St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5999727.06015 | 2117202.6736 | 37.7934178626924 | -122.444905786498 | (37.7934178626924, -122.444905786498) | ||||
23961 | 23961 | 247944 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 21 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010317.99645 | 2098902.9194900002 | 37.7437696775404 | -122.40696976733999 | (37.7437696775404, -122.40696976734) | ||||
24072 | 24072 | 246633 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3320 Harrison St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6009029.84734 | 2099262.75496 | 37.7446855398981 | -122.411449314735 | (37.7446855398981, -122.411449314735) | ||||
24107 | 24107 | 120282 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 129 24th Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5988304.19862 | 2115114.50046 | 37.787025803891204 | -122.484276029631 | (37.7870258038912, -122.484276029631) | ||||
24196 | 24196 | 198273 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014246.68754 | 2106694.7124400004 | 37.7653833298046 | -122.393930504207 | (37.7653833298046, -122.393930504207) | ||||
24228 | 24228 | 197487 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1301 Minnesota St | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6015378.84744 | 2102468.94598 | 37.75384313667529 | -122.389719416144 | (37.7538431366753, -122.389719416144) | ||||
24281 | 24281 | 223831 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006175.86532 | 2097493.16654 | 37.7396661564679 | -122.421192213677 | (37.7396661564679, -122.421192213677) | ||||
24288 | 24288 | 224150 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1001 San Jose Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6005234.007999999 | 2096984.22045 | 37.738215562603294 | -122.424412565406 | (37.7382155626033, -122.424412565406) | ||||
24400 | 24400 | 220351 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 3921 21st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6002309.75741 | 2103525.9195 | 37.7560119615059 | -122.434990881437 | (37.7560119615059, -122.434990881437) | ||||
24447 | 24447 | 201523 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 799 Earl St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 10ft | 6020371.96237 | 2093662.3098400002 | 37.729937451546704 | -122.371842613372 | (37.7299374515467, -122.371842613372) | |||
24493 | 24493 | 190983 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6016115.94828 | 2100251.3725900003 | 37.7477949890666 | -122.387015672733 | (37.7477949890666, -122.387015672733) | ||||
24497 | 24497 | 227291 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 65 Zircon Pl | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 4ft | 6002354.98671 | 2098718.92039 | 37.7428156470274 | -122.43449077742399 | (37.7428156470274, -122.434490777424) | |||
24654 | 24654 | 190986 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6016149.69105 | 2100259.24355 | 37.747818469462 | -122.38689953970601 | (37.747818469462, -122.386899539706) | ||||
24719 | 24719 | 247088 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2301 Castro St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6002764.361830001 | 2098589.4854900003 | 37.74248347881979 | -122.43306602918001 | (37.7424834788198, -122.43306602918) | ||||
24891 | 24891 | 213671 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 3ft | 5994885.5088599995 | 2098943.91671 | 37.7430065910919 | -122.460334245238 | (37.7430065910919, -122.460334245238) | |||
24892 | 24892 | 197177 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1900 23rd St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6012740.291540001 | 2102830.02856 | 37.7546879247201 | -122.39886955298599 | (37.7546879247201, -122.398869552986) | ||||
24900 | 24900 | 249938 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 339 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011244.68883 | 2120032.5219400004 | 37.8018385261831 | -122.405253098256 | (37.8018385261831, -122.405253098256) | |||
24963 | 24963 | 189144 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 602 Arthur Ave | 45 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 5ft | 6015967.83076 | 2099823.77263 | 37.7466126854204 | -122.38749803403 | (37.7466126854204, -122.38749803403) | |||
25037 | 25037 | 249812 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Chestnut St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010650.1980099995 | 2121033.7396299997 | 37.8045543690542 | -122.40738094817699 | (37.8045543690542, -122.407380948177) | |||
25070 | 25070 | 245815 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 92 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004991.22077 | 2096914.7584400002 | 37.7380111224129 | -122.42524706251699 | (37.7380111224129, -122.425247062517) | ||||
25090 | 25090 | 223699 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 72 | 6004901.063490001 | 2096745.81285 | 37.737542142145706 | -122.425546760699 | (37.7375421421457, -122.425546760699) | ||||
25099 | 25099 | 224199 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005272.32245 | 2097108.7115200001 | 37.738559550591795 | -122.42428894459299 | (37.7385595505918, -122.424288944593) | ||||
25107 | 25107 | 191446 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Tulare St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6016252.95003 | 2100312.60959 | 37.747970718394704 | -122.386546192477 | (37.7479707183947, -122.386546192477) | ||||
25153 | 25153 | 219212 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 1501 15th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5991536.71945 | 2105150.6616 | 37.759855492149704 | -122.47236570472 | (37.7598554921497, -122.47236570472) | ||||
25418 | 25418 | 191034 | Undocumented 2 | Diospyros kaki :: Persimmon 293 | 2338 Lane St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6013925.13865 | 2092881.2708700001 | 37.727436659956005 | -122.394075563956 | (37.727436659956, -122.394075563956) | |||
25490 | 25490 | 225139 | Undocumented 2 | Chamaecyparis species :: 347 | 701 Church St | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004346.6017 | 2104631.68872 | 37.759163584356706 | -122.428025590809 | (37.7591635843567, -122.428025590809) | ||||
25522 | 25522 | 175043 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 199 Shakespeare St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 8ft | 5993498.29454 | 2086678.39145 | 37.709248559547504 | -122.464240538697 | (37.7092485595475, -122.464240538697) | |||
25572 | 25572 | 191703 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1501 Quint St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 4ft | 6013259.66608 | 2096346.4213299998 | 37.7369142408999 | -122.396618925818 | (37.7369142408999, -122.396618925818) | |||
25613 | 25613 | 240953 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1101 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004805.95854 | 2096424.9931 | 37.7366558692687 | -122.42585275411601 | (37.7366558692687, -122.425852754116) |
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");