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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3663 | 3663 | 36860 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 3664 | 3664 | 18949 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2838 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001202.00999 | 2115627.7019 | 37.7891774657247 | -122.43968939755699 | (37.7891774657247, -122.439689397557) | |||
| 3665 | 3665 | 115481 | Permitted Site 1 | Tree(s) :: 17 | 1277 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779302 | 5987681.0372 | 2106596.6773 | 37.7636019470532 | -122.48580658869 | (37.7636019470532, -122.48580658869) | |
| 3666 | 3666 | 21602 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005338.1501 | 2114762.148 | 37.7870354220648 | -122.425317233161 | (37.7870354220648, -122.425317233161) | |||
| 3667 | 3667 | 209703 | Undocumented 2 | Olea europaea 'Swan Hill' :: Olive 217 | 102 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5994492.3466 | 2105343.52789 | 37.7605556719136 | -122.462157698016 | (37.7605556719136, -122.462157698016) | |||
| 3668 | 3668 | 43018 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 3669 | 3669 | 128007 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 450 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6008574.61168 | 2121448.10995 | 37.8055757371873 | -122.414593071218 | (37.8055757371873, -122.414593071218) | ||
| 3670 | 3670 | 253512 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2498 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1997 12:00:00 AM | 3x3 | 6000414.87165 | 2119245.42001 | 37.7990659347341 | -122.442672656788 | (37.7990659347341, -122.442672656788) | |||
| 3671 | 3671 | 128005 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 444 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6008626.93235 | 2121456.53692 | 37.805601814825394 | -122.414412604251 | (37.8056018148254, -122.414412604251) | ||
| 3672 | 3672 | 233924 | Undocumented 2 | Persea indica :: Indian Bay 214 | 2427 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6011189.3984 | 2102738.18792 | 37.754349212155105 | -122.404226526651 | (37.7543492121551, -122.404226526651) | ||
| 3673 | 3673 | 3073 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2880 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/1998 12:00:00 AM | 3 | 3X3 | 6000583.9217 | 2115208.18648 | 37.7879903857924 | -122.44179777983999 | (37.7879903857924, -122.44179777984) | ||
| 3674 | 3674 | 32468 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2017 12:00:00 AM | 3 | Permit Number 36977 | 6000626.3294 | 2105651.6556 | 37.7617529834407 | -122.44096521177099 | (37.7617529834407, -122.440965211771) | |
| 3675 | 3675 | 237732 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4059 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001898.0 | 2105817.0 | 37.7622793253591 | -122.436578855242 | (37.7622793253591, -122.436578855242) | |||
| 3676 | 3676 | 233926 | Undocumented 2 | Persea indica :: Indian Bay 214 | 2427 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6011248.07781 | 2102739.69759 | 37.754356636065204 | -122.40402370342599 | (37.7543566360652, -122.404023703426) | ||
| 3677 | 3677 | 210350 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992051.8911 | 2099003.24187 | 37.7430060748628 | -122.470136351038 | (37.7430060748628, -122.470136351038) | |||
| 3678 | 3678 | 208759 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 300 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/24/2005 12:00:00 AM | 2 | Width 3ft | Permit Number 48287 | 5993126.46853 | 2099702.60224 | 37.7449884054972 | -122.466471606489 | (37.7449884054972, -122.466471606489) | |
| 3679 | 3679 | 253243 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 299X Moncada Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 3680 | 3680 | 9726 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 621 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005799.3606 | 2111864.1645 | 37.779104318085295 | -122.42351543791099 | (37.7791043180853, -122.423515437911) | |||
| 3681 | 3681 | 210783 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 102 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994553.24166 | 2105346.7379 | 37.7605679917509 | -122.46194732411001 | (37.7605679917509, -122.46194732411) | |||
| 3682 | 3682 | 215670 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 100 Cortes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2016 12:00:00 AM | 13 | Width 3ft | Permit Number 777819 | 5993206.76177 | 2099368.3728400003 | 37.7440753292166 | -122.46616968519899 | (37.7440753292166, -122.466169685199) | |
| 3683 | 3683 | 213464 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/24/2005 12:00:00 AM | 2 | Width 3ft | Permit Number 48287 | 5993110.29995 | 2099700.9644 | 37.7449829754007 | -122.46652739502701 | (37.7449829754007, -122.466527395027) | |
| 3684 | 3684 | 27830 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013136.88249 | 2119351.75589 | 37.800074911578 | -122.398657381345 | (37.800074911578, -122.398657381345) | |||
| 3685 | 3685 | 22584 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006566.74341 | 2112845.87169 | 37.7818431310978 | -122.420930462379 | (37.7818431310978, -122.420930462379) | |||
| 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) | |
| 3687 | 3687 | 152811 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 2901 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6009988.15821 | 2101607.87857 | 37.7511784382559 | -122.40830102206999 | (37.7511784382559, -122.40830102207) | |
| 3688 | 3688 | 9457 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005414.2393 | 2112401.6078 | 37.7805582605963 | -122.424885977306 | (37.7805582605963, -122.424885977306) | |||
| 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) | |
| 3691 | 3691 | 152812 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 2901 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6010002.42353 | 2101608.75594 | 37.751181646126795 | -122.40825175271401 | (37.7511816461268, -122.408251752714) | |
| 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) | ||||
| 3695 | 3695 | 57738 | Permitted Site 1 | Tree(s) :: 17 | 1999 So. Bascom Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1976 12:00:00 AM | Permit Number 16656 | ||||||||
| 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) | |
| 3698 | 3698 | 20141 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1001 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002903.1358 | 2111776.1473 | 37.7786987467479 | -122.433528357436 | (37.7786987467479, -122.433528357436) | |||
| 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) | |
| 3700 | 3700 | 152810 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 2901 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6009973.24314 | 2101608.01571 | 37.751177979599206 | -122.408352609887 | (37.7511779795992, -122.408352609887) | |
| 3701 | 3701 | 1557 | Permitted Site 1 | Aesculus x carnea :: Red Horse Chestnut 194 | 545 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 8 | 3X3 | 5995578.89655 | 2112509.35885 | 37.7802936727782 | -122.458918678629 | (37.7802936727782, -122.458918678629) | ||
| 3702 | 3702 | 143025 | Permitted Site 1 | Tree(s) :: 17 | 2147 MASON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2008 12:00:00 AM | 4 | Width 0ft | Permit Number 51763 | 6008956.6469 | 2120652.8991 | 37.803413743220794 | -122.413214712493 | (37.8034137432208, -122.413214712493) | |
| 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) | |
| 3704 | 3704 | 6903 | Permitted Site 1 | Tristania conferta :: 79 | 333 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3X3 | 6005734.9676 | 2110651.7554 | 37.775771702887894 | -122.42365197493 | (37.7757717028879, -122.42365197493) | ||
| 3705 | 3705 | 13973 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6008926.8051 | 2112282.1341 | 37.780427990023206 | -122.41272585143899 | (37.7804279900232, -122.412725851439) | |||
| 3706 | 3706 | 226704 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 460 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 18 | Width 4ft | Permit Number 38040 | 6007388.533559999 | 2107001.8580400003 | 37.7658431486538 | -122.41767310175399 | (37.7658431486538, -122.417673101754) | |
| 3707 | 3707 | 253520 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2626 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643.0 | 2120264.0 | 37.8022157634914 | -122.42119356191999 | (37.8022157634914, -122.42119356192) | ||
| 3708 | 3708 | 241324 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 490 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | Width 3ft | 6007395.8118199995 | 2106861.7423400003 | 37.765458833278 | -122.417637995807 | (37.765458833278, -122.417637995807) | ||
| 3709 | 3709 | 253265 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 180 San Aleso Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 5993319.0 | 2094440.0 | 37.730549723890206 | -122.465423653439 | (37.7305497238902, -122.465423653439) | ||
| 3710 | 3710 | 240036 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4121 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002205.0 | 2105251.0 | 37.7607426677704 | -122.435476567852 | (37.7607426677704, -122.435476567852) | |||
| 3711 | 3711 | 229522 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1400 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2008 12:00:00 AM | 3 | Width 2ft | 6004493.41372 | 2100695.79384 | 37.748364843572794 | -122.427237482541 | (37.7483648435728, -122.427237482541) | ||
| 3712 | 3712 | 196122 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | Width 3ft | 6011517.6969 | 2105021.50044 | 37.7606370219096 | -122.40325179104299 | (37.7606370219096, -122.403251791043) | ||
| 3713 | 3713 | 253521 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2626 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643.0 | 2120264.0 | 37.8022157634914 | -122.42119356191999 | (37.8022157634914, -122.42119356192) | ||
| 3714 | 3714 | 241323 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 490 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | Width 3ft | 6007394.41265 | 2106888.07859 | 37.765531067728894 | -122.417644702035 | (37.7655310677289, -122.417644702035) | ||
| 3715 | 3715 | 240037 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 4109 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002258.67075 | 2105277.61191 | 37.7608187856797 | -122.435292848592 | (37.7608187856797, -122.435292848592) | |||
| 3716 | 3716 | 20054 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 3717 | 3717 | 240414 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 4529 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000856.95656 | 2105193.67931 | 37.760508625697 | -122.440134724763 | (37.760508625697, -122.440134724763) | |||
| 3718 | 3718 | 13282 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2532 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 0 | 3x3 | 6000258.0 | 2119239.0 | 37.7990393633551 | -122.443215022549 | (37.7990393633551, -122.443215022549) | ||
| 3719 | 3719 | 227557 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 4648 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000417.67775 | 2104660.60062 | 37.759019904154 | -122.441615728291 | (37.759019904154, -122.441615728291) | |||
| 3720 | 3720 | 54865 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1845 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1972 12:00:00 AM | 14 | Permit Number 10724 | 5998997.2724 | 2110063.1394 | 37.77377288550579 | -122.44691690335199 | (37.7737728855058, -122.446916903352) | ||
| 3721 | 3721 | 36883 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2515 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002662.87522 | 2116961.2420799998 | 37.792922065545504 | -122.43473038919501 | (37.7929220655455, -122.434730389195) | ||
| 3722 | 3722 | 2900 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1675 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6006330.22809 | 2115940.35545 | 37.7903264863286 | -122.4219685876 | (37.7903264863286, -122.4219685876) | |||
| 3723 | 3723 | 253167 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 3724 | 3724 | 227558 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 4648 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000435.4436099995 | 2104661.21425 | 37.759022601217104 | -122.441554329764 | (37.7590226012171, -122.441554329764) | |||
| 3725 | 3725 | 51148 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1600X North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 47562 | 6003040.244080001 | 2121015.99755 | 37.804076787673104 | -122.43371460583799 | (37.8040767876731, -122.433714605838) | ||
| 3726 | 3726 | 14780 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1019 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004321.3595 | 2111841.1408 | 37.7789575666093 | -122.42862680452801 | (37.7789575666093, -122.428626804528) | ||
| 3727 | 3727 | 23506 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005800.086 | 2119369.4177599996 | 37.799711913718795 | -122.424046801229 | (37.7997119137188, -122.424046801229) | |||
| 3728 | 3728 | 18515 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 634 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010129.36296 | 2116007.85487 | 37.790725353638 | -122.408828552704 | (37.790725353638, -122.408828552704) | |||
| 3729 | 3729 | 18005 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2683 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001144.5248 | 2114870.2639 | 37.787094464568796 | -122.43983396035101 | (37.7870944645688, -122.439833960351) | |||
| 3730 | 3730 | 9439 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 770 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005833.93052 | 2112448.8947400004 | 37.7807117956403 | -122.423437426899 | (37.7807117956403, -122.423437426899) | |||
| 3731 | 3731 | 15515 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2763 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007078.6273 | 2102287.5862 | 37.7528814055888 | -122.41841070542401 | (37.7528814055888, -122.418410705424) | |||
| 3732 | 3732 | 15513 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2763 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6007075.5942 | 2102308.8178 | 37.7529395319689 | -122.41842269980101 | (37.7529395319689, -122.418422699801) | |||
| 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) | |||
| 3734 | 3734 | 118035 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 5984123.0 | 2112760.0 | 37.7803166927985 | -122.498567828267 | (37.7803166927985, -122.498567828267) | |||
| 3735 | 3735 | 63212 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 450 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 10 | Permit Number 23755 | 5984123.0 | 2112760.0 | 37.7803166927985 | -122.498567828267 | (37.7803166927985, -122.498567828267) | |
| 3736 | 3736 | 223410 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 898 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1993 12:00:00 AM | 9 | Width 4ft | Permit Number 32344 | 6010171.02881 | 2104045.21453 | 37.7578810584907 | -122.407840483778 | (37.7578810584907, -122.407840483778) | |
| 3737 | 3737 | 175356 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5992860.08995 | 2087808.05232 | 37.71231353272879 | -122.46652830874201 | (37.7123135327288, -122.466528308742) | |||
| 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) | |||
| 3739 | 3739 | 237154 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 861 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1992 12:00:00 AM | 5 | Width 6ft | Permit Number 30833 | 6010197.69553 | 2104230.40256 | 37.7583910361238 | -122.407761316458 | (37.7583910361238, -122.407761316458) | |
| 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) | |||
| 3741 | 3741 | 11063 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1706 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X4 | 6007392.7334199995 | 2118206.86499 | 37.7966096249815 | -122.418453164696 | (37.7966096249815, -122.418453164696) | |||
| 3742 | 3742 | 219632 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 878 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2015 12:00:00 AM | 1 | Width 3ft | Permit Number 774094 | 6010166.130969999 | 2104121.45382 | 37.7580901202723 | -122.40786279863899 | (37.7580901202723, -122.407862798639) | |
| 3743 | 3743 | 175363 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 5ft | 5993226.79298 | 2087801.79474 | 37.71231750501779 | -122.465260429219 | (37.7123175050178, -122.465260429219) | |||
| 3744 | 3744 | 46296 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 3745 | 3745 | 221791 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1991 12:00:00 AM | 30 | Width 6ft | Permit Number 29826 | 6010196.62735 | 2104192.74111 | 37.7582875664398 | -122.407762355146 | (37.7582875664398, -122.407762355146) | |
| 3746 | 3746 | 253553 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2763 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6007078.6273 | 2102287.5862 | 37.7528814055888 | -122.41841070542401 | (37.7528814055888, -122.418410705424) | ||||
| 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) | |||
| 3749 | 3749 | 223601 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 280x Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007724.0 | 2106220.0 | 37.7637152201621 | -122.41645740380899 | (37.7637152201621, -122.416457403809) | |||
| 3750 | 3750 | 253551 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 19 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 04:40:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3751 | 3751 | 45854 | Permitted Site 1 | Tree(s) :: 17 | 71 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 3752 | 3752 | 7102 | DPW Maintained 3 | Tristania conferta :: 79 | 2080 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 5997497.5881 | 2109552.6978 | 37.7722855537803 | -122.45206768793001 | (37.7722855537803, -122.45206768793) | |||
| 3753 | 3753 | 253554 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 1855 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778968 | 5986885.63083 | 2102641.2721 | 37.7526951056681 | -122.48826692291901 | (37.7526951056681, -122.488266922919) | |
| 3754 | 3754 | 253538 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 6 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 02:43:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3755 | 3755 | 253535 | DPW Maintained 3 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 1000 Cayuga Ave | 3 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 02:31:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 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) | ||||
| 3757 | 3757 | 6923 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 436 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005320.8239 | 2110648.3853 | 37.775739063409794 | -122.425084363796 | (37.7757390634098, -122.425084363796) | |||
| 3758 | 3758 | 253548 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 16 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 04:31:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3759 | 3759 | 253555 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 27 Ceres St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | ||||
| 3760 | 3760 | 253533 | DPW Maintained 3 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 1000 Cayuga Ave | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 01:57:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3761 | 3761 | 253534 | DPW Maintained 3 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 1000 Cayuga Ave | 2 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 02:08:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3762 | 3762 | 139362 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2869 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999793.3033 | 2114332.6333 | 37.7855412639984 | -122.44447021936199 | (37.7855412639984, -122.444470219362) |
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");