Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 558 | 558 | 251320 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 35 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6004965.06472 | 2096463.48809 | 37.7367705580153 | -122.425305393447 | (37.7367705580153, -122.425305393447) | ||||
| 580 | 580 | 48268 | Permitted Site 1 | Tree(s) :: 17 | 132 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 588 | 588 | 251328 | Undocumented 2 | Tree(s) :: 17 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |||
| 592 | 592 | 251331 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2232 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003295.0 | 2116396.0 | 37.791405922266996 | -122.43250281523301 | (37.791405922267, -122.432502815233) | ||||
| 595 | 595 | 119606 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 299x Avalon Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 597 | 597 | 251329 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
| 599 | 599 | 251330 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003295.0 | 2116396.0 | 37.791405922266996 | -122.43250281523301 | (37.791405922267, -122.432502815233) | ||||
| 610 | 610 | 251327 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
| 617 | 617 | 57850 | Permitted Site 1 | Tree(s) :: 17 | 1700 S. Amaylett Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | Permit Number 16791 | ||||||||
| 621 | 621 | 251339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | ||
| 626 | 626 | 251342 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/1996 12:00:00 AM | 3x3 | Permit Number 37503 | 5992527.0 | 2093770.0 | 37.7286643609316 | -122.46811297163299 | (37.7286643609316, -122.468112971633) | ||
| 628 | 628 | 251337 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
| 629 | 629 | 251338 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
| 631 | 631 | 251294 | Property Tree 7 | :: 54 | 7126 Geary Blvd | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5984860.0 | 2112552.0 | 37.779788778901796 | -122.49600289252199 | (37.7797887789018, -122.496002892522) | ||||
| 632 | 632 | 44905 | Permitted Site 1 | Tree(s) :: 17 | 139 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 633 | 633 | 48204 | Permitted Site 1 | Tree(s) :: 17 | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 634 | 634 | 251340 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
| 635 | 635 | 251315 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 638 | 638 | 251341 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | 3x3 | Permit Number 37503 | 5992527.0 | 2093770.0 | 37.7286643609316 | -122.46811297163299 | (37.7286643609316, -122.468112971633) | ||
| 644 | 644 | 251319 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 645 | 645 | 251316 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 651 | 651 | 251359 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4050 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994421.0 | 2112898.0 | 37.7812941506761 | -122.462952553035 | (37.7812941506761, -122.462952553035) | ||||
| 655 | 655 | 251353 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 510 22nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 5989096.969740001 | 2111833.32857 | 37.7780627562405 | -122.481292881664 | (37.7780627562405, -122.481292881664) | ||||
| 667 | 667 | 251356 | Undocumented 2 | :: 54 | 519 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989039.0 | 2111772.0 | 37.777890994652296 | -122.481488924787 | (37.7778909946523, -122.481488924787) | ||||
| 669 | 669 | 251343 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 934 Brannan St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 674 | 674 | 251361 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 301 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010388.0 | 2110913.0 | 37.7767505721368 | -122.40757431033701 | (37.7767505721368, -122.407574310337) | ||||
| 675 | 675 | 47038 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 716 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45030 | ||||||||
| 682 | 682 | 251365 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 689 | 689 | 48269 | Permitted Site 1 | Tree(s) :: 17 | 120 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 697 | 697 | 251362 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1300X Stanyan St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | ||||
| 709 | 709 | 251360 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 301 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1991 12:00:00 AM | 3x3 | 6010388.0 | 2110913.0 | 37.7767505721368 | -122.40757431033701 | (37.7767505721368, -122.407574310337) | |||
| 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 | ||||||||||
| 726 | 726 | 44958 | Permitted Site 1 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 729 | 729 | 48266 | Permitted Site 1 | Tree(s) :: 17 | 130 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 731 | 731 | 251375 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 746 | 746 | 251371 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 747 | 747 | 251378 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 749 | 749 | 251374 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 750 | 750 | 251368 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 270 06th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6010822.0 | 2111616.0 | 37.7787051302825 | -122.40612250689199 | (37.7787051302825, -122.406122506892) | |||
| 752 | 752 | 251380 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 731 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 757 | 757 | 251377 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 763 | 763 | 251373 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 764 | 764 | 251379 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 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) | ||||
| 780 | 780 | 251383 | Undocumented 2 | Persea americana :: Avocado 113 | 49x Milan Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997587.0 | 2087495.0 | 37.711725600519706 | -122.450168218052 | (37.7117256005197, -122.450168218052) | ||||
| 781 | 781 | 251370 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 390 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 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) | ||||
| 783 | 783 | 251381 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 731 Huron Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 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) | ||||
| 785 | 785 | 251376 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 786 | 786 | 251369 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 793 | 793 | 65876 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1990 12:00:00 AM | Permit Number 28874 | |||||||||
| 809 | 809 | 46145 | Permitted Site 1 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 813 | 813 | 251390 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Width 3ft | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 814 | 814 | 44650 | Permitted Site 1 | Tree(s) :: 17 | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 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) | ||||
| 820 | 820 | 251223 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | Width 3ft | 5991438.54417 | 2088636.90192 | 37.714507218415 | -122.47150190860901 | (37.714507218415, -122.471501908609) | |||
| 821 | 821 | 251392 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Width 3ft | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 844 | 844 | 251224 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80X Junipero Serra Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | Width 3ft | 5991438.54417 | 2088636.90192 | 37.714507218415 | -122.47150190860901 | (37.714507218415, -122.471501908609) | |||
| 855 | 855 | 251398 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 858 | 858 | 251395 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2101 26th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012226.0 | 2101445.0 | 37.750856267744496 | -122.400550836744 | (37.7508562677445, -122.400550836744) | |||||
| 859 | 859 | 251396 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 864 | 864 | 37366 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 125 Street | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39871 | ||||||||
| 870 | 870 | 117001 | DPW Maintained 3 | :: 54 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 881 | 881 | 251399 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008927.4869099995 | 2120274.72498 | 37.802373734427796 | -122.413288863041 | (37.8023737344278, -122.413288863041) | ||||
| 883 | 883 | 251306 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 885 | 885 | 251305 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 887 | 887 | 251303 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 2 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 892 | 892 | 251400 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | ||||
| 896 | 896 | 251302 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 921 | 921 | 30278 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 128 | ||||||||||
| 934 | 934 | 251409 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 95x Andover St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6007642.0 | 2098274.0 | 37.741892697320296 | -122.41617822056101 | (37.7418926973203, -122.416178220561) | ||||
| 937 | 937 | 45898 | Permitted Site 1 | Tree(s) :: 17 | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 938 | 938 | 251414 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2005 12:00:00 AM | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | |||
| 940 | 940 | 51496 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1350 REVISED Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47808 | 6000958.86990754 | 2110035.78536621 | 37.773809648853 | -122.44012948036101 | (37.773809648853, -122.440129480361) | |||
| 947 | 947 | 251413 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2005 12:00:00 AM | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | |||
| 952 | 952 | 48321 | Permitted Site 1 | Tree(s) :: 17 | 187 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 953 | 953 | 46022 | Permitted Site 1 | Tree(s) :: 17 | 215 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 954 | 954 | 251405 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 540 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:08:00 PM | Width 0ft | 6009678.016 | 2120549.6995 | 37.8031708545804 | -122.410711083519 | (37.8031708545804, -122.410711083519) | |||
| 955 | 955 | 251402 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 190 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007981.0 | 2093052.0 | 37.7275732783897 | -122.41463660892599 | (37.7275732783897, -122.414636608926) | ||||
| 961 | 961 | 251408 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 75 Christmas Tree Point Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998776.0 | 2103023.0 | 37.75442978774979 | -122.447175546291 | (37.7544297877498, -122.447175546291) | ||||
| 963 | 963 | 251419 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 966 | 966 | 251417 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5990003.0 | 2112517.0 | 37.779992561868504 | -122.478208632121 | (37.7799925618685, -122.478208632121) | ||||
| 967 | 967 | 251416 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | ||||
| 970 | 970 | 251418 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 971 | 971 | 251415 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2005 12:00:00 AM | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | |||
| 975 | 975 | 251421 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 09/30/2014 01:37:00 PM | 3x3 | 6014268.0 | 2110701.0 | 37.776384889187796 | -122.394137287636 | (37.7763848891878, -122.394137287636) | ||
| 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) | |||||
| 1010 | 1010 | 45949 | Permitted Site 1 | Tree(s) :: 17 | 146 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1015 | 1015 | 48313 | Permitted Site 1 | Tree(s) :: 17 | 179 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 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) | ||||
| 1038 | 1038 | 57888 | Permitted Site 1 | Tree(s) :: 17 | 2382 Fost St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1977 12:00:00 AM | Permit Number 16841 | ||||||||
| 1048 | 1048 | 251423 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2162 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5999946.0 | 2089791.0 | 37.718164612456604 | -122.44217960719999 | (37.7181646124566, -122.4421796072) | ||||
| 1067 | 1067 | 48140 | Permitted Site 1 | Tree(s) :: 17 | 250 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 |
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");