Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||
| 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 | ||||||||||
| 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 | ||||||||
| 3537 | 3537 | 102838 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 6592 | 6592 | 98837 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1101X Portola Dr | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 9596 | 9596 | 102839 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1101X Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 11273 | 11273 | 102842 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 14567 | 14567 | 98839 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1101X Portola Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 9867 | 9867 | 118924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 855 La Playa | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | Width 4ft | 5980738.40206 | 2109808.86226 | 37.772014669966396 | -122.510057198601 | (37.7720146699664, -122.510057198601) | ||
| 137746 | 137746 | 118929 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 875 La Playa | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5980750.23602 | 2109645.2788 | 37.7715662158284 | -122.510004109936 | (37.7715662158284, -122.510004109936) | |||
| 43202 | 43202 | 118930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 875 La Playa | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5980751.65283 | 2109636.5801 | 37.7715424153171 | -122.509998562861 | (37.7715424153171, -122.509998562861) | |||
| 47354 | 47354 | 119238 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 4701 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5980953.58736 | 2110230.22563 | 37.773184299817096 | -122.509344168 | (37.7731842998171, -122.509344168) | |||
| 137510 | 137510 | 118414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 641 48th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 5980997.21538 | 2111360.64896 | 37.7762906814163 | -122.509277221064 | (37.7762906814163, -122.509277221064) | ||||
| 166592 | 166592 | 118482 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 8349 Geary Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5981039.36975 | 2112282.68151 | 37.7788247951526 | -122.509199886896 | (37.7788247951526, -122.509199886896) | ||||
| 151681 | 151681 | 118454 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 8350 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5981044.43167 | 2112373.0207700003 | 37.7790731383894 | -122.50918908645399 | (37.7790731383894, -122.509189086454) | ||||
| 68925 | 68925 | 118481 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 8349 Geary Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981086.353519999 | 2112282.5400099996 | 37.7788271765554 | -122.509037343924 | (37.7788271765554, -122.509037343924) | ||||
| 135329 | 135329 | 118954 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 758 48th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 5981087.552180001 | 2110537.58401 | 37.7740361134392 | -122.50890360004999 | (37.7740361134392, -122.50890360005) | |||
| 175941 | 175941 | 118463 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 545 Point Lobos Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 5981101.15577 | 2112608.26384 | 37.7797223901441 | -122.509010330711 | (37.7797223901441, -122.509010330711) | ||||
| 105637 | 105637 | 96626 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 144733 | 144733 | 96627 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 161967 | 161967 | 186844 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2034 Lower Great Hwy | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5981219.1453 | 2101186.094 | 37.7483673667876 | -122.507754314909 | (37.7483673667876, -122.507754314909) | |||
| 165060 | 165060 | 118488 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8301 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5981255.6094 | 2112295.38099 | 37.778872410675895 | -122.508452785017 | (37.7788724106759, -122.508452785017) | ||||
| 58922 | 58922 | 185743 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2120 Lower Great Hwy | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5981266.2638 | 2100624.5993 | 37.7468284358609 | -122.507549726279 | (37.7468284358609, -122.507549726279) | |||
| 77363 | 77363 | 185742 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2120 Lower Great Hwy | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5981267.7362 | 2100613.3105 | 37.7467975267188 | -122.507543797463 | (37.7467975267188, -122.507543797463) | |||
| 171770 | 171770 | 185741 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2128 Lower Great Hwy | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5981273.1352 | 2100554.4124 | 37.746636127094 | -122.50752075912399 | (37.746636127094, -122.507520759124) | |||
| 49556 | 49556 | 185768 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2100 Lower Great Hwy | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5981299.1485 | 2100269.7385 | 37.7458560246461 | -122.507409691662 | (37.7458560246461, -122.507409691662) | |||
| 25511 | 25511 | 119143 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 625 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5981300.41517 | 2111472.41115 | 37.776615419273895 | -122.508236685403 | (37.7766154192739, -122.508236685403) | |||
| 154967 | 154967 | 119144 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 637 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 2ft | 5981304.908009999 | 2111421.80977 | 37.7764767475665 | -122.508217386884 | (37.7764767475665, -122.508217386884) | |||
| 133721 | 133721 | 119151 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 751 47th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5981332.09183 | 2110596.93925 | 37.774213497724396 | -122.50806211670799 | (37.7742134977244, -122.508062116708) | |||
| 156575 | 156575 | 118539 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5981337.09939 | 2112389.25007 | 37.7791349496719 | -122.508177852958 | (37.7791349496719, -122.508177852958) | ||||
| 51466 | 51466 | 118540 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.117190001 | 2112394.76177 | 37.7791500842164 | -122.50817820058701 | (37.7791500842164, -122.508178200587) | ||||
| 33118 | 33118 | 118541 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.423690001 | 2112399.66579 | 37.779163567264 | -122.50817750438699 | (37.779163567264, -122.508177504387) | ||||
| 69327 | 69327 | 118499 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5981338.204609999 | 2112298.18891 | 37.778884987819204 | -122.508167268986 | (37.7788849878192, -122.508167268986) | ||||
| 147638 | 147638 | 118498 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5981347.002859999 | 2112298.64035 | 37.7788867457895 | -122.508136866402 | (37.7788867457895, -122.508136866402) | ||||
| 67370 | 67370 | 119159 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 837 47th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5981353.13131 | 2110018.81201 | 37.7726273695738 | -122.50794642446002 | (37.7726273695738, -122.50794642446) | |||
| 158457 | 158457 | 118497 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5981364.20395 | 2112299.23238 | 37.7788893849054 | -122.50807740600901 | (37.7788893849054, -122.508077406009) | ||||
| 158101 | 158101 | 119243 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981398.37029 | 2111333.4256599997 | 37.7762395779827 | -122.507887519226 | (37.7762395779827, -122.507887519226) | |||
| 179080 | 179080 | 118669 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4550 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | 5981412.61192 | 2111005.49415 | 37.7753400136649 | -122.507813913091 | (37.7753400136649, -122.507813913091) | ||||
| 68212 | 68212 | 119242 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981417.66127 | 2111333.86508 | 37.7762419210818 | -122.507820820241 | (37.7762419210818, -122.507820820241) | |||
| 48201 | 48201 | 119241 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981435.03386 | 2111334.77238 | 37.776245435782 | -122.50776079209999 | (37.776245435782, -122.5077607921) | |||
| 36328 | 36328 | 119240 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981455.34518 | 2111336.83463 | 37.776252294734 | -122.507690683983 | (37.776252294734, -122.507690683983) | |||
| 69462 | 69462 | 119126 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 601 46th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5981603.35382 | 2111608.79109 | 37.777007725640104 | -122.507198870746 | (37.7770077256401, -122.507198870746) | |||
| 162594 | 162594 | 119125 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 601 46th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5981604.24423 | 2111607.23903 | 37.777003516584294 | -122.507195675426 | (37.7770035165843, -122.507195675426) | |||
| 109418 | 109418 | 119124 | Undocumented 2 | :: 54 | 601 46th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Width 5ft | 5981605.53063 | 2111566.74083 | 37.7768923962204 | -122.50718822030198 | (37.7768923962204, -122.507188220302) | ||||
| 164300 | 164300 | 186000 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1883 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5981612.0444 | 2102288.7145 | 37.7514179925848 | -122.506477461595 | (37.7514179925848, -122.506477461595) | |||
| 66923 | 66923 | 184506 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1883 47th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5981616.9431 | 2102289.37 | 37.7514200808256 | -122.506460570212 | (37.7514200808256, -122.506460570212) | |||
| 188122 | 188122 | 184539 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1939 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 0ft | 5981627.7505 | 2101868.0843 | 37.7502639852004 | -122.50639195948 | (37.7502639852004, -122.50639195948) | |||
| 67844 | 67844 | 119114 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 727 46th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 5ft | 5981633.48884 | 2110754.76442 | 37.7746645942414 | -122.50703125858601 | (37.7746645942414, -122.507031258586) | |||
| 29280 | 29280 | 184503 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1963 47th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 0ft | 5981636.5852 | 2101719.8576 | 37.7498575164936 | -122.506350418514 | (37.7498575164936, -122.506350418514) | |||
| 168002 | 168002 | 118630 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 349 Point Lobos Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5981637.79887 | 2112651.0038099997 | 37.7798713628306 | -122.507157052361 | (37.7798713628306, -122.507157052361) | ||||
| 166513 | 166513 | 184502 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1963 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5981638.5485 | 2101729.1831 | 37.7498832372827 | -122.506344320901 | (37.7498832372827, -122.506344320901) | |||
| 105512 | 105512 | 105130 | Significant Tree 6 | Tree(s) :: 17 | 4045 MORAGA ST | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5981665.2 | 2103465.9 | 37.7546533409301 | -122.506380933635 | (37.7546533409301, -122.506380933635) | ||||||
| 179465 | 179465 | 118837 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 600 46th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5981666.867000001 | 2111590.99028 | 37.776962590483606 | -122.506977842076 | (37.7769625904836, -122.506977842076) | |||
| 42200 | 42200 | 118839 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 600 46th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 5ft | 5981667.64941 | 2111553.97712 | 37.7768610093184 | -122.506972389283 | (37.7768610093184, -122.506972389283) | |||
| 128929 | 128929 | 118840 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 600 46th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5981669.20852 | 2111532.1943900003 | 37.7768012921712 | -122.506965379751 | (37.7768012921712, -122.506965379751) | |||
| 154803 | 154803 | 184534 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1906 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5981676.8437 | 2102069.7342 | 37.7508205493518 | -122.506237145813 | (37.7508205493518, -122.506237145813) | |||
| 163383 | 163383 | 184565 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4045 Moraga St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5981678.1974 | 2103481.7992 | 37.7546977608395 | -122.506337164847 | (37.7546977608395, -122.506337164847) | |||
| 152167 | 152167 | 184536 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1918 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5981680.2279 | 2102012.5409 | 37.7506637118715 | -122.50622120268801 | (37.7506637118715, -122.506221202688) | |||
| 106681 | 106681 | 97654 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2331 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5981707.8 | 2099208.6 | 37.7429664967596 | -122.505917998204 | (37.7429664967596, -122.505917998204) | |||||
| 188830 | 188830 | 118808 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 894 46th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5981738.117319999 | 2109674.1043 | 37.771703578835 | -122.50658917067 | (37.771703578835, -122.50658917067) | |||
| 151869 | 151869 | 118809 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 894 46th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5981738.19338 | 2109667.15136 | 37.771684492567395 | -122.50658839183001 | (37.7716844925674, -122.50658839183) | |||
| 69636 | 69636 | 118804 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6940 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5981816.18929 | 2109660.54581 | 37.77167094779411 | -122.506318113931 | (37.7716709477941, -122.506318113931) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 167519 | 167519 | 118972 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4400 Cabrillo St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5981914.76561 | 2110344.52005 | 37.7735547445483 | -122.50602785926 | (37.7735547445483, -122.50602785926) | |||
| 174258 | 174258 | 119070 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 601 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5981915.41012 | 2111609.48599 | 37.7770280083436 | -122.506119441606 | (37.7770280083436, -122.506119441606) | |||
| 186961 | 186961 | 118772 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 5355 Anza St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5981988.79716 | 2111633.19692 | 37.7770974313835 | -122.505867335722 | (37.7770974313835, -122.505867335722) | |||
| 186418 | 186418 | 119023 | Undocumented 2 | Acacia dealbata :: Silver Wattle 434 | 829 44th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5982278.31786 | 2110100.0638 | 37.772904932367 | -122.504752182409 | (37.772904932367, -122.504752182409) | |||
| 46431 | 46431 | 184394 | Undocumented 2 | Cercis occidentalis :: Western Redbud 246 | 2050 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5982331.3515 | 2101153.7956 | 37.7483441473859 | -122.50390600495199 | (37.7483441473859, -122.503906004952) | |||
| 68211 | 68211 | 183190 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2455 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5982371.7929 | 2098405.4722 | 37.7408003902911 | -122.50356267094801 | (37.7408003902911, -122.503562670948) | |||
| 137979 | 137979 | 183191 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2459 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5982373.485 | 2098374.3374 | 37.74071500217671 | -122.50355451536501 | (37.7407150021767, -122.503554515365) | |||
| 33318 | 33318 | 185383 | Undocumented 2 | Malus :: Crab Apple 235 | 2611 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5982402.2599 | 2097319.6826 | 37.7378209010805 | -122.503376950994 | (37.7378209010805, -122.503376950994) | |||
| 166448 | 166448 | 185129 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2615 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5982406.6772 | 2097293.1784 | 37.737748387476394 | -122.50335971655399 | (37.7377483874764, -122.503359716554) | |||
| 55751 | 55751 | 118533 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 7919 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5982413.97815 | 2112333.29099 | 37.7790447011013 | -122.504448405405 | (37.7790447011013, -122.504448405405) | |||
| 27070 | 27070 | 118586 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Point Lobos Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5982415.39383 | 2112637.72046 | 37.779880658188794 | -122.50446606808501 | (37.7798806581888, -122.504466068085) | |||
| 152024 | 152024 | 118532 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 7919 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5982426.71221 | 2112333.83561 | 37.779046945449 | -122.504404394244 | (37.779046945449, -122.504404394244) | |||
| 174513 | 174513 | 118584 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 110 Point Lobos Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5982432.95165 | 2112629.5696900003 | 37.7798593112778 | -122.504404724819 | (37.7798593112778, -122.504404724819) | ||||
| 34381 | 34381 | 118537 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 7915 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 5982434.92947 | 2112334.2727 | 37.7790486288769 | -122.504376000287 | (37.7790486288769, -122.504376000287) | |||
| 186151 | 186151 | 118583 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 110 Point Lobos Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5982437.33611 | 2112624.2044900004 | 37.7798448378945 | -122.50438915970699 | (37.7798448378945, -122.504389159707) | ||||
| 59074 | 59074 | 118585 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 110 Point Lobos Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5982437.76166 | 2112637.90018 | 37.779882467259704 | -122.504388702469 | (37.7798824672597, -122.504388702469) | ||||
| 157951 | 157951 | 118705 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4225 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5982441.7055 | 2110968.62548 | 37.7752993599927 | -122.504251368027 | (37.7752993599927, -122.504251368027) | |||
| 70868 | 70868 | 118536 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 7915 Geary Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5982451.538919999 | 2112333.71263 | 37.7790480679712 | -122.504318500947 | (37.7790480679712, -122.504318500947) | |||
| 75381 | 75381 | 118704 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4225 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 5982455.1363 | 2110968.5092599997 | 37.775299830770294 | -122.504204899972 | (37.7752998307703, -122.504204899972) | |||
| 153380 | 153380 | 118582 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 110 Point Lobos Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5982455.82259 | 2112616.16545 | 37.779823852339504 | -122.504324612183 | (37.7798238523395, -122.504324612183) | ||||
| 181846 | 181846 | 118590 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 101 Point Lobos Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5982474.39956 | 2112527.8997400003 | 37.7795825932214 | -122.504253806958 | (37.7795825932214, -122.504253806958) | ||||
| 186247 | 186247 | 118708 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4201 Balboa St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5982482.88801 | 2110969.6299 | 37.7753045397791 | -122.504108985066 | (37.7753045397791, -122.504108985066) | |||
| 181239 | 181239 | 118591 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 101 Point Lobos Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5982483.315119999 | 2112527.9777 | 37.77958333161529 | -122.50422297050301 | (37.7795833316153, -122.504222970503) | ||||
| 136022 | 136022 | 118580 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 7900 Geary Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5982502.32297 | 2112445.62468 | 37.7793583322752 | -122.504151113367 | (37.7793583322752, -122.504151113367) | |||
| 151529 | 151529 | 118577 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 7900 Geary Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5982502.68903 | 2112449.1000200002 | 37.7793678960656 | -122.504150104536 | (37.7793678960656, -122.504150104536) | |||
| 48105 | 48105 | 118707 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4201 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5982546.62842 | 2110970.49419 | 37.775310661099795 | -122.503888560039 | (37.7753106610998, -122.503888560039) | |||
| 74793 | 74793 | 184498 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1875 44th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5982546.757 | 2102373.8062 | 37.751706619904596 | -122.503251468292 | (37.7517066199046, -122.503251468292) | |||
| 76120 | 76120 | 184497 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1871 44th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5982548.7875 | 2102393.4347 | 37.751760633629 | -122.503245899839 | (37.751760633629, -122.503245899839) |
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");