Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4871 | 4871 | 253700 | Undocumented 2 | Tree(s) :: 17 | 293 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007203.0 | 2105623.0 | 37.76204668432629 | -122.41821705685899 | (37.7620466843263, -122.418217056859) | ||||
| 4865 | 4865 | 253699 | Undocumented 2 | Tree(s) :: 17 | 3076 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000057.0 | 2105400.0 | 37.761029556529294 | -122.44291621566002 | (37.7610295565293, -122.44291621566) | ||||
| 4864 | 4864 | 253698 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2200 Ofarrell St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Width 0ft | 6000775.0 | 2113124.0 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | ||||
| 4870 | 4870 | 253696 | Undocumented 2 | Tree(s) :: 17 | 235 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6003605.0 | 2109124.0 | 37.77145640087421 | -122.430911009882 | (37.7714564008742, -122.430911009882) | ||||
| 4854 | 4854 | 253694 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 536 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005450.0 | 2111168.0 | 37.7771730951376 | -122.42467448311199 | (37.7771730951376, -122.424674483112) | ||||
| 4859 | 4859 | 253693 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 536 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005450.0 | 2111168.0 | 37.7771730951376 | -122.42467448311199 | (37.7771730951376, -122.424674483112) | ||||
| 4851 | 4851 | 253692 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 68 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005803.0 | 2109684.0 | 37.77311832041121 | -122.42334782195499 | (37.7731183204112, -122.423347821955) | ||||
| 4855 | 4855 | 253691 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 60 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005848.0 | 2109690.0 | 37.7731373345919 | -122.42319258754601 | (37.7731373345919, -122.423192587546) | ||||
| 4856 | 4856 | 253690 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 60 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005848.0 | 2109690.0 | 37.7731373345919 | -122.42319258754601 | (37.7731373345919, -122.423192587546) | ||||
| 4852 | 4852 | 253689 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 60 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005848.0 | 2109690.0 | 37.7731373345919 | -122.42319258754601 | (37.7731373345919, -122.423192587546) | ||||
| 4844 | 4844 | 253688 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||||
| 4849 | 4849 | 253684 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 767 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009074.0 | 2092682.0 | 37.7266186845557 | -122.410831962563 | (37.7266186845557, -122.410831962563) | ||||
| 4764 | 4764 | 253679 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 94 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4x8 | 5997405.0 | 2099153.0 | 37.7437252916895 | -122.45163765514201 | (37.7437252916895, -122.451637655142) | ||||
| 4747 | 4747 | 253677 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 5x10 | |||||||||
| 4723 | 4723 | 253676 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x3.75 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 4726 | 4726 | 253675 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x14.2 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 4716 | 4716 | 253674 | DPW Maintained 3 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 600 x Sanchez St | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 6003598.0 | 2104743.0 | 37.75942683738779 | -122.43062255590701 | (37.7594268373878, -122.430622555907) | ||||
| 4727 | 4727 | 253673 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 600 x Sanchez St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 6003598.0 | 2104743.0 | 37.75942683738779 | -122.43062255590701 | (37.7594268373878, -122.430622555907) | ||||
| 4719 | 4719 | 253672 | DPW Maintained 3 | Tree(s) :: 17 | 390 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 4736 | 4736 | 253671 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1063 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001095.0 | 2086792.0 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | ||||
| 4721 | 4721 | 253670 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1063 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001095.0 | 2086792.0 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | ||||
| 4725 | 4725 | 253667 | Undocumented 2 | Juniperus californica :: California juniper 226 | 2 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Width 3ft | 5995617.0 | 2110854.0 | 37.775750686051005 | -122.458666990683 | (37.775750686051, -122.458666990683) | ||||
| 4704 | 4704 | 253666 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 578 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5993791.71774 | 2111566.05198 | 37.7776007134003 | -122.465032776868 | (37.7776007134003, -122.465032776868) | ||||
| 4701 | 4701 | 253665 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4707 | 4707 | 253664 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4708 | 4708 | 253663 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4698 | 4698 | 253662 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4710 | 4710 | 253661 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4700 | 4700 | 253660 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4703 | 4703 | 253659 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4699 | 4699 | 253658 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4702 | 4702 | 253657 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4709 | 4709 | 253656 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 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) | ||||
| 4659 | 4659 | 253652 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 131 Font Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 4673 | 4673 | 253651 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 131 Font Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 4669 | 4669 | 253646 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 11/09/1992 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
| 4684 | 4684 | 253645 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
| 4668 | 4668 | 253644 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 11/05/1992 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
| 4562 | 4562 | 253642 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010361.39347 | 2118971.94152 | 37.7988770104459 | -122.40823488063499 | (37.7988770104459, -122.408234880635) | ||||
| 4620 | 4620 | 253639 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 4405 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 5993893.0 | 2114132.0 | 37.784651953064206 | -122.46486880251801 | (37.7846519530642, -122.464868802518) | |||
| 4544 | 4544 | 253638 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 859 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2017 12:00:00 AM | 3 | 3x3 | 6009440.103999999 | 2118743.01656 | 37.7981968084542 | -122.411406675592 | (37.7981968084542, -122.411406675592) | ||
| 4553 | 4553 | 253637 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 701 Noe St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 3ft | 6003144.80454 | 2104133.37104 | 37.757727257313704 | -122.43214639144101 | (37.7577272573137, -122.432146391441) | ||||
| 4538 | 4538 | 253635 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 830 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | ||||
| 4548 | 4548 | 253634 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 830 Oak St | 1 | Sidewalk: Property side : Cutout 5 | tree 3 | DPW 2 | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | |||||
| 4555 | 4555 | 253633 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1907 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 777409 | ||||||
| 4468 | 4468 | 253632 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 527 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6004455.0 | 2110106.0 | 37.7742008582336 | -122.42804080634701 | (37.7742008582336, -122.428040806347) | ||||
| 4475 | 4475 | 253631 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 6009957.290080001 | 2113442.89538 | 37.783672949399204 | -122.409242840109 | (37.7836729493992, -122.409242840109) | ||||
| 4506 | 4506 | 253629 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
| 4520 | 4520 | 253628 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
| 4446 | 4446 | 253627 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 5991061.0 | 2093828.0 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | ||||
| 4447 | 4447 | 253626 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1671 Funston Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5992125.0 | 2104081.0 | 37.756952512450205 | -122.47025325330601 | (37.7569525124502, -122.470253253306) | ||||
| 4344 | 4344 | 253624 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 735 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998960.0 | 2095994.0 | 37.735140362702396 | -122.446033688862 | (37.7351403627024, -122.446033688862) | ||||
| 4434 | 4434 | 253623 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1331 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778744 | 5983976.422619999 | 2106100.27997 | 37.7620224120695 | -122.498582815109 | (37.7620224120695, -122.498582815109) | |
| 4222 | 4222 | 253622 | Undocumented 2 | Pittosporum spp :: Pittosporum spp 128 | 300x Naglee Ave | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 4283 | 4283 | 253621 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 200x Montcalm St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010036.0 | 2099760.0 | 37.7461072494139 | -122.40800527847799 | (37.7461072494139, -122.408005278478) | ||||
| 4182 | 4182 | 253620 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 1120 South Van Ness Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Width 3ft | 6007603.98274 | 2103104.1444200003 | 37.755153048679205 | -122.41665176419201 | (37.7551530486792, -122.416651764192) | ||||
| 4165 | 4165 | 253615 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006221.0 | 2118816.0 | 37.7982161239914 | -122.422550935399 | (37.7982161239914, -122.422550935399) | ||
| 4158 | 4158 | 253614 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1959x Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006418.0 | 2117595.0 | 37.794874677003605 | -122.421782481899 | (37.7948746770036, -122.421782481899) | ||||
| 4102 | 4102 | 253611 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Front St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6012712.81893 | 2119514.81479 | 37.8004989968021 | -122.400136271497 | (37.8004989968021, -122.400136271497) | ||||
| 4013 | 4013 | 253610 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1075 Mission St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 6009725.02676 | 2112060.52163 | 37.7798642637711 | -122.40994876804 | (37.7798642637711, -122.40994876804) | ||||
| 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) | |||
| 4063 | 4063 | 253608 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 400X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 5998814.0 | 2100235.0 | 37.746776792757004 | -122.44684353081101 | (37.746776792757, -122.446843530811) | ||||
| 4002 | 4002 | 253607 | Undocumented 2 | Tree(s) :: 17 | 499x Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010464.0 | 2112150.0 | 37.7801513385768 | -122.407398630227 | (37.7801513385768, -122.407398630227) | ||||
| 4089 | 4089 | 253606 | Undocumented 2 | Tree(s) :: 17 | 499x Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010464.0 | 2112150.0 | 37.7801513385768 | -122.407398630227 | (37.7801513385768, -122.407398630227) | ||||
| 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) | ||||
| 4010 | 4010 | 253604 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 267 Teresita Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 5997729.0 | 2098564.0 | 37.7421265906625 | -122.450474893449 | (37.7421265906625, -122.450474893449) | ||||
| 4041 | 4041 | 253601 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
| 4027 | 4027 | 253600 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
| 4034 | 4034 | 253599 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x9 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | ||||
| 3917 | 3917 | 253597 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010453.0 | 2107072.0 | 37.7662077096315 | -122.407078650031 | (37.7662077096315, -122.407078650031) | ||||
| 3965 | 3965 | 253596 | Permitted Site 1 | Tree(s) :: 17 | 198X Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780230 | ||||||
| 3897 | 3897 | 253589 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 365x 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6011360.0 | 2111196.0 | 37.7775819849571 | -122.404231777509 | (37.7775819849571, -122.404231777509) | ||||
| 3870 | 3870 | 253584 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3862 | 3862 | 253583 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3871 | 3871 | 253582 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3866 | 3866 | 253581 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3869 | 3869 | 253580 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3861 | 3861 | 253579 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3865 | 3865 | 253578 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3867 | 3867 | 253577 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3868 | 3868 | 253576 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2622 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 774112 | 5986417.0 | 2105735.0 | 37.7611622818619 | -122.49011505097 | (37.7611622818619, -122.49011505097) | ||
| 3843 | 3843 | 253568 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 301X Sargent St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5993018.0 | 2089140.0 | 37.7159798527116 | -122.46607925705901 | (37.7159798527116, -122.466079257059) | ||||
| 3835 | 3835 | 253567 | Private 5 | Salix spp :: Willow 218 | 25 Raycliff Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6000333.0 | 2116919.0 | 37.792673532262505 | -122.44278881704399 | (37.7926735322625, -122.442788817044) | |||||
| 3812 | 3812 | 253561 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 530 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5993033.55222 | 2099443.36305 | 37.744271238444206 | -122.46677405027799 | (37.7442712384442, -122.466774050278) | ||||
| 3817 | 3817 | 253560 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 535 Castenada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5992829.16774 | 2099990.2564 | 37.7457610706327 | -122.46752052447701 | (37.7457610706327, -122.467520524477) | ||||
| 3822 | 3822 | 253559 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5993184.39566 | 2099612.1282900004 | 37.7447433294416 | -122.46626473273199 | (37.7447433294416, -122.466264732732) | ||||
| 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) | |||||
| 3825 | 3825 | 253557 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 5ft | 6015583.67362 | 2102658.4010900003 | 37.7543746962452 | -122.38902430045499 | (37.7543746962452, -122.389024300455) | ||||
| 4771 | 4771 | 253556 | Permitted Site 1 | Tree(s) :: 17 | 27 Ceres St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:00:00 AM | 3 | Permit Number 780682 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | |
| 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) | ||||
| 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) | |
| 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) | ||||
| 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) | ||
| 3837 | 3837 | 253550 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 18 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:43:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3841 | 3841 | 253549 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 17 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:46:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 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) | ||
| 3842 | 3842 | 253547 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 15 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:40:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3840 | 3840 | 253546 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 14 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:50:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3832 | 3832 | 253545 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 13 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:58:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) |
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");