Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96798 | 96798 | 111179 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 400 NORTH POINT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | 9x6 | 6008572.0 | 2121805.0 | 37.806555520543 | -122.41462738080799 | (37.806555520543, -122.414627380808) | ||
| 92493 | 92493 | 112481 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 1275 Columbus Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 1710 | 1710 | 251657 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1717 | 1717 | 251661 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 119513 | 119513 | 121133 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x10 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | |||
| 47419 | 47419 | 99288 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 845 Marina Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998881.62913 | 2121328.006 | 37.8046966310161 | -122.448128205765 | (37.8046966310161, -122.448128205765) | ||
| 59539 | 59539 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 241 | 901 Bay St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | ||||
| 29261 | 29261 | 105753 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 3636 Buchanan St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/21/2014 12:00:00 AM | 13 | Permit Number 771077 | 6003146.89414 | 2120799.57812 | 37.803488607670296 | -122.433330062032 | (37.8034886076703, -122.433330062032) | ||
| 97249 | 97249 | 114184 | Significant Tree 6 | Tree(s) :: 17 | 2454 HYDE ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/07/2016 12:00:00 AM | 30x30 | Permit Number 776893 | 6007060.0 | 2120781.0 | 37.8036588138585 | -122.41978724303999 | (37.8036588138585, -122.41978724304) | ||
| 20387 | 20387 | 121368 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 245 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 778992 | 6001431.0 | 2120732.0 | 37.8032055622797 | -122.439263127997 | (37.8032055622797, -122.439263127997) | ||
| 95033 | 95033 | 106942 | Significant Tree 6 | Tree(s) :: 17 | 1300@ Embarcadero Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/02/2014 12:00:00 AM | Permit Number 772680 | 6012231.9986 | 2120618.97397 | 37.8035039293343 | -122.40187777389099 | (37.8035039293343, -122.401877773891) | |||
| 5478 | 5478 | 121205 | Significant Tree 6 | Cotoneaster SPP :: Cotoneaster 234 | 930 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x3 | 6007386.5238 | 2120591.4348299997 | 37.8031567047665 | -122.418643837145 | (37.8031567047665, -122.418643837145) | |||
| 96251 | 96251 | 107399 | Significant Tree 6 | Tree(s) :: 17 | 1300X Sansome St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/02/2014 12:00:00 AM | 3 | Permit Number 772689 | 6012222.0 | 2120529.0 | 37.8032563246841 | -122.40190604611401 | (37.8032563246841, -122.401906046114) | ||
| 114761 | 114761 | 112559 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1735x GRANT AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010373.0 | 2120454.0 | 37.8029470287696 | -122.40829930674299 | (37.8029470287696, -122.408299306743) | |||||
| 8003 | 8003 | 109210 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2637 Larkin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774817 | 6006569.78732 | 2120282.61277 | 37.802262741793704 | -122.421448236261 | (37.8022627417937, -122.421448236261) | |
| 96134 | 96134 | 85085 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
| 146084 | 146084 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 96590 | 96590 | 99643 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 1268 Lombard St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6006289.0 | 2120073.0 | 37.8016713630652 | -122.42240499597 | (37.8016713630652, -122.42240499597) | ||||
| 101472 | 101472 | 106058 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 301 FILBERT ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6011273.0 | 2120044.0 | 37.8018716248897 | -122.40515593659401 | (37.8018716248897, -122.405155936594) | ||||
| 88420 | 88420 | 96906 | Significant Tree 6 | Ulmus 'Frontier' :: Frontier Elm 464 | 1155@Sansome Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/05/2011 12:00:00 AM | Plaza | Permit Number 768022 | 6012245.0 | 2120028.0 | 37.80188198386271 | -122.401791216362 | (37.8018819838627, -122.401791216362) | ||
| 83772 | 83772 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1160 Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.40155068012699 | (37.8018575696458, -122.401550680127) | |||
| 101651 | 101651 | 106059 | Significant Tree 6 | Salix spp :: Willow 218 | 339 FILBERT ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6011263.6 | 2119947.8 | 37.801606957686 | -122.40518168715599 | (37.801606957686, -122.405181687156) | ||||
| 2003 | 2003 | 127110 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3201 Laguna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 6ft | 6003718.35126 | 2119752.0994 | 37.8006449063974 | -122.431277695812 | (37.8006449063974, -122.431277695812) | |||
| 98992 | 98992 | 114476 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 128 | 299x UNION ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 6011527.0 | 2119680.0 | 37.8008863659875 | -122.40425133897 | (37.8008863659875, -122.40425133897) | ||||
| 13290 | 13290 | 187642 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 2526 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006264.0 | 2119500.0 | 37.8000966404513 | -122.42245076966002 | (37.8000966404513, -122.42245076966) | ||||
| 7743 | 7743 | 121449 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1274 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 10x6 | 6006927.94593 | 2119481.89109 | 37.800084349978 | -122.420151970562 | (37.800084349978, -122.420151970562) | |||
| 103214 | 103214 | 106173 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 267 Green St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 771881 | 6011670.8 | 2119368.7 | 37.8000396459541 | -122.403731811098 | (37.8000396459541, -122.403731811098) | ||||
| 93109 | 93109 | 107611 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 470x Broadway | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 774041 | 6011286.02608 | 2118707.45024 | 37.7982025127238 | -122.40501669828998 | (37.7982025127238, -122.40501669829) | ||||
| 104863 | 104863 | 106838 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 735 Battery St | 1 | Front Yard : Pot 30 | Tree 1 | Private 1 | Permit Number 773117 | 6012413.67639 | 2118682.92207 | 37.798198135735895 | -122.40111294506201 | (37.7981981357359, -122.401112945062) | ||||
| 114979 | 114979 | 118322 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 720 BATTERY ST | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 6012486.0 | 2118560.0 | 37.7978646555778 | -122.400854041686 | (37.7978646555778, -122.400854041686) | |||||
| 77206 | 77206 | 107056 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 601X Davis St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/23/2014 12:00:00 AM | 12 | Permit Number 771755 | 6013142.97136 | 2118525.3196099997 | 37.797806054267895 | -122.39857828598 | (37.7978060542679, -122.39857828598) | ||
| 166020 | 166020 | 99921 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1740 Jones St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008331.64636 | 2118443.68708 | 37.7973126906849 | -122.415221079511 | (37.7973126906849, -122.415221079511) | ||||
| 79650 | 79650 | 107185 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 10 Florence St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 773363 | 6008515.42073 | 2118375.20615 | 37.7971349853662 | -122.41458032272 | (37.7971349853662, -122.41458032272) | ||||
| 563 | 563 | 173951 | Significant Tree 6 | Tree(s) :: 17 | 2646 Union St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/11/2017 12:00:00 AM | 3 | 10x10 | Permit Number 779549 | 6000338.0 | 2118225.0 | 37.796259749404605 | -122.442865342513 | (37.7962597494046, -122.442865342513) | |
| 63120 | 63120 | 105071 | Significant Tree 6 | Acacia stenophylla :: Shoestring Acacia 109 | 1808 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Permit Number 771033 | 6004794.05676 | 2118138.55822 | 37.796275437823894 | -122.427440299436 | (37.7962754378239, -122.427440299436) | |||
| 85678 | 85678 | 115250 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1404x Mason St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 6009352.6 | 2118074.7 | 37.796356867240206 | -122.41166222086001 | (37.7963568672402, -122.41166222086) | ||||
| 143100 | 143100 | 101741 | Significant Tree 6 | Tree(s) :: 17 | 1590 Broadway | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | Permit Number 769428 | 6006147.8 | 2117991.4 | 37.795947850763895 | -122.422745597666 | (37.7959478507639, -122.422745597666) | |||
| 50494 | 50494 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 131X Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.796266453658795 | -122.397554954018 | (37.7962664536588, -122.397554954018) | |
| 2105 | 2105 | 251411 | Significant Tree 6 | Tree(s) :: 17 | 2751 Buchanan St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/21/2017 12:00:00 AM | 3 | 6x6 | Permit Number 779887 | 6003497.0 | 2117826.0 | 37.7953437887296 | -122.431906052505 | (37.7953437887296, -122.431906052505) | |
| 97259 | 97259 | 116164 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2411 OCTAVIA ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 15x4 | 6004495.0 | 2117637.0 | 37.7948813682629 | -122.428439330772 | (37.7948813682629, -122.428439330772) | |||
| 66846 | 66846 | 112874 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2636 Vallejo St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2015 12:00:00 AM | 13 | 3x3 | Permit Number 776037 | 6000935.48392 | 2117605.97258 | 37.794594107573104 | -122.440753504176 | (37.7945941075731, -122.440753504176) | |
| 92947 | 92947 | 99830 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 2398@Steiner Broadway | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 143868 | 143868 | 99827 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 2398 Broadway | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 94082 | 94082 | 103143 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 46 | 2620 Buchanan St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6003626.0 | 2117322.0 | 37.7939672460834 | -122.431423695166 | (37.7939672460834, -122.431423695166) | ||||
| 82320 | 82320 | 113769 | Significant Tree 6 | Tree(s) :: 17 | 2550 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6001418.65940389 | 2117313.19689891 | 37.7938177263924 | -122.439060665499 | (37.7938177263924, -122.439060665499) | |||||
| 8131 | 8131 | 112367 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2770 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774944 | 6000432.434780001 | 2117179.73451 | 37.7933951089516 | -122.442463497617 | (37.7933951089516, -122.442463497617) | |
| 154324 | 154324 | 112045 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2418 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 18 | 3x3 | 6002446.95594 | 2117111.03197 | 37.7933210893366 | -122.435488200226 | (37.7933210893366, -122.435488200226) | |||
| 175900 | 175900 | 105351 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 9 | 2040 Jackson St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/16/2014 12:00:00 AM | 3 | Permit Number 769933 | 6004399.13095 | 2117053.27366 | 37.7932731788779 | -122.428729419132 | (37.7932731788779, -122.428729419132) | ||
| 1358 | 1358 | 173635 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |
| 125113 | 125113 | 122688 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 2590 Pacific Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 3x8 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |||
| 145177 | 145177 | 107016 | Significant Tree 6 | Tree(s) :: 17 | 945 SACRAMENTO ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | Permit Number 773422 | 6010352.6 | 2116759.1 | 37.7928005931964 | -122.408109164657 | (37.7928005931964, -122.408109164657) | |||
| 2114 | 2114 | 107983 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 2405x Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6001231.007069999 | 2116743.47753 | 37.7922427464694 | -122.43966909537599 | (37.7922427464694, -122.439669095376) | |||
| 99263 | 99263 | 101435 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 82951 | 82951 | 109969 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1x DAVIS ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 18 | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | |
| 89532 | 89532 | 112366 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2224 Baker St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 775823 | 5999858.5 | 2116547.8 | 37.791627252722 | -122.444403911295 | (37.791627252722, -122.444403911295) | |||
| 114328 | 114328 | 121377 | Significant Tree 6 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 2701 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001200.0 | 2116539.0 | 37.79167953949779 | -122.439761713662 | (37.7916795394978, -122.439761713662) | ||||
| 53186 | 53186 | 106080 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 188 The Embarcadero | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/20/2014 12:00:00 AM | Permit Number 771259 | 6015087.8131 | 2116516.98611 | 37.7923997963133 | -122.391708043282 | (37.7923997963133, -122.391708043282) | |||
| 139051 | 139051 | 112390 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 2201X LYON ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x12 | 5999307.0 | 2116423.0 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | ||||
| 93681 | 93681 | 96767 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 94 | 2229 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 768245 | 6003236.0 | 2116309.0 | 37.7911636966224 | -122.43270073645701 | (37.7911636966224, -122.432700736457) | |||
| 85444 | 85444 | 104728 | Significant Tree 6 | Tree(s) :: 17 | 3212 Jackson St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/06/2013 12:00:00 AM | Permit Number 770525 | 5998810.5 | 2116292.9 | 37.7908675143955 | -122.448011605492 | (37.7908675143955, -122.448011605492) | |||
| 2180 | 2180 | 251495 | Significant Tree 6 | Tree(s) :: 17 | 2448 Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 10x10 | Permit Number 780000 | 6003026.0 | 2116224.0 | 37.7909183964794 | -122.433421252488 | (37.7909183964794, -122.433421252488) | |
| 95709 | 95709 | 98492 | Significant Tree 6 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Laguna St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004211.7 | 2116183.0 | 37.7908730187591 | -122.429315856087 | (37.7908730187591, -122.429315856087) | |||||
| 115705 | 115705 | 117417 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2835 Washington St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | Permit Number 778177 | 6001153.1 | 2116153.5 | 37.790618387033206 | -122.439896334555 | (37.7906183870332, -122.439896334555) | |||
| 74055 | 74055 | 100572 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 3020 Washington St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Permit Number 769157 | 6000180.60876 | 2116141.82829 | 37.790530933705 | -122.44326025018299 | (37.790530933705, -122.443260250183) | |||
| 82032 | 82032 | 39247 | Significant Tree 6 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 3524 Jackson St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 5x10 | Permit Number 772836 | 5997387.02929021 | 2116081.37513577 | 37.790205252620794 | -122.452921449726 | (37.7902052526208, -122.452921449726) | ||
| 68819 | 68819 | 108096 | Significant Tree 6 | Ficus rubiginosa :: Port Jackson Fig 188 | 3370 Washington St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 17 | Permit Number 773610 | 5998674.83986 | 2115933.37372 | 37.789872594881295 | -122.44845507873801 | (37.7898725948813, -122.448455078738) | |||
| 85775 | 85775 | 114272 | Significant Tree 6 | Tree(s) :: 17 | 2241 Sacramento St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776884 | 6004082.4 | 2115905.7 | 37.79010430227179 | -122.42974344149499 | (37.7901043022718, -122.429743441495) | |
| 110845 | 110845 | 100434 | Significant Tree 6 | Tree(s) :: 17 | 2430 Sacramento St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/24/2012 12:00:00 AM | Permit Number 769154 | 6003168.3 | 2115899.0 | 37.7900341016439 | -122.432905672523 | (37.7900341016439, -122.432905672523) | |||
| 102912 | 102912 | 119613 | Significant Tree 6 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2X Sutter St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 6012582.0 | 2115890.0 | 37.7905388243453 | -122.400334219916 | (37.7905388243453, -122.400334219916) | |||
| 114679 | 114679 | 105349 | Significant Tree 6 | Tree(s) :: 17 | 151X Spruce St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/16/2014 12:00:00 AM | Permit Number 771071 | 5997060.93638 | 2115845.70083 | 37.7895394616557 | -122.45403267223999 | (37.7895394616557, -122.45403267224) | |||
| 2059 | 2059 | 173596 | Significant Tree 6 | Tree(s) :: 17 | 200 Howard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | Permit Number 779179 | 6014439.0 | 2115766.0 | 37.790301726009204 | -122.393900378517 | (37.7903017260092, -122.393900378517) | |||
| 126031 | 126031 | 110476 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3700 Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 5997015.1 | 2115715.0 | 37.7891779638687 | -122.454181816252 | (37.7891779638687, -122.454181816252) | |
| 151501 | 151501 | 98241 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 3760 Washington St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/10/2012 12:00:00 AM | 9 | Permit Number 768462 | 5996814.4677800005 | 2115674.0493799997 | 37.7890540175629 | -122.45487301496999 | (37.7890540175629, -122.45487301497) | ||
| 108754 | 108754 | 104003 | Significant Tree 6 | Acer palmatum 'Sango Kaku' :: Coral Bark Maple 518 | 2109 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/17/2013 12:00:00 AM | Permit Number 767176 | 6002333.5 | 2115633.4 | 37.789257448084605 | -122.435774995524 | (37.7892574480846, -122.435774995524) | |||
| 142025 | 142025 | 98491 | Significant Tree 6 | Robinia pseudoacacia :: Black Locust 169 | 55X Perine Pl | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | Permit Number 768655 | 6002130.5 | 2115544.8 | 37.7890026421633 | -122.436471006098 | (37.7890026421633, -122.436471006098) | ||||
| 9740 | 9740 | 173671 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 87860 | 87860 | 104228 | Significant Tree 6 | Tree(s) :: 17 | 183 FREMONT ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Permit Number 770922 | 6014038.0 | 2115456.0 | 37.7894282446126 | -122.395266095466 | (37.7894282446126, -122.395266095466) | |||
| 115320 | 115320 | 111036 | Significant Tree 6 | Magnolia spp :: Magnolia 89 | 3991-3997 Washington St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995610.3 | 2115419.4 | 37.7882856707006 | -122.459020806409 | (37.7882856707006, -122.459020806409) | |||||
| 119155 | 119155 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 53 | 1636 Bush St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665.0 | 2115204.0 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | |||
| 87085 | 87085 | 113937 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 800 EL CAMINO DEL MAR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 5985966.0 | 2115003.0 | 37.7865832348262 | -122.49235734524099 | (37.7865832348262, -122.492357345241) | ||||
| 82542 | 82542 | 108215 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 865 EL CAMINO DEL MAR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
| 116206 | 116206 | 103477 | Significant Tree 6 | Tree(s) :: 17 | 875 El Camino Del Mar | 1 | Front Yard : 25 | Tree 1 | Private 1 | 05/08/2013 12:00:00 AM | Permit Number 770113 | 5985641.7 | 2114972.5 | 37.7864805258078 | -122.493477079739 | (37.7864805258078, -122.493477079739) | |||
| 13275 | 13275 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 144783 | 144783 | 92909 | Significant Tree 6 | Tree(s) :: 17 | 100 32nd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/18/2009 12:00:00 AM | 11 | Permit Number 53112 | 5985781.7 | 2114962.8 | 37.786462080845396 | -122.49299200677 | (37.7864620808454, -122.49299200677) | ||
| 107759 | 107759 | 120952 | Significant Tree 6 | Tree(s) :: 17 | 100X 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 10x10 | Permit Number 778529 | 5985781.0 | 2114962.0 | 37.7864598433405 | -122.492994369609 | (37.7864598433405, -122.492994369609) | |
| 114181 | 114181 | 100694 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 80497 | 80497 | 104013 | Significant Tree 6 | Fremontodendron spp :: Flannel Bush Tree 331 | 3978 Sacramento St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/24/2013 12:00:00 AM | Permit Number 770312 | 5995753.1 | 2114886.6 | 37.7868309532778 | -122.45848816233601 | (37.7868309532778, -122.458488162336) | |||
| 92420 | 92420 | 98038 | Significant Tree 6 | Tree(s) :: 17 | 147 Lake St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/09/2011 12:00:00 AM | Permit Number 768423 | 5994977.2 | 2114852.5 | 37.7866927029397 | -122.461170103848 | (37.7866927029397, -122.461170103848) | |||
| 1337 | 1337 | 251410 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2777 Pine St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 779015 | 6000658.0 | 2114782.0 | 37.7868244087741 | -122.441510888069 | (37.7868244087741, -122.441510888069) | |||
| 82400 | 82400 | 115123 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
| 93937 | 93937 | 96184 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 1 | Sidewalk: Property side : 26 | Tree 1 | Private 1 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | ||||
| 140337 | 140337 | 113133 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 03rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | ||
| 26650 | 26650 | 109414 | Significant Tree 6 | Persea americana :: Avocado 113 | 4 GUY PL | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6014378.1 | 2114502.6 | 37.786829336844605 | -122.394022608955 | (37.7868293368446, -122.394022608955) | ||||
| 104638 | 104638 | 101202 | Significant Tree 6 | Tree(s) :: 17 | 7070 California St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769231 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 124001 | 124001 | 99698 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 102600 | 102600 | 106362 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1645 WEBSTER ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | ||||
| 97021 | 97021 | 106360 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1820 POST ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6003351.1 | 2114201.6 | 37.785383838011 | -122.43215193232099 | (37.785383838011, -122.432151932321) | ||||
| 1159 | 1159 | 112361 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 561X Folsom St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/16/2015 12:00:00 AM | 3 | 10x30 | Permit Number 775828 | 6013749.7362 | 2114198.9064599997 | 37.785960521430205 | -122.396175324952 | (37.7859605214302, -122.396175324952) | |
| 125647 | 125647 | 85060 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 7070 California St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/03/2007 12:00:00 AM | Permit Number 49405 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 120773 | 120773 | 115697 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1425x LAGUNA ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6004559.0 | 2113815.0 | 37.7843907406582 | -122.4279454018 | (37.7843907406582, -122.4279454018) |
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");