Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7553 | 7553 | 142835 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1515 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Width 0ft | 6006663.5874 | 2116129.9342 | 37.7908658176323 | -122.42082865045799 | (37.7908658176323, -122.420828650458) | ||||
| 16896 | 16896 | 100001 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 501X 01st St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Address is 100 1st Street | |||||||||
| 77434 | 77434 | 81367 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1001 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/08/2003 12:00:00 AM | 3x3 | 6006914.85774282 | 2114314.60875621 | 37.7858955407321 | -122.41983039718201 | (37.7858955407321, -122.419830397182) | |||
| 79489 | 79489 | 103710 | Permitted Site 1 | Tree(s) :: 17 | 520 Jones St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/13/2013 12:00:00 AM | 3x3.5 | Permit Number 770327 | 6008908.0 | 2114310.0 | 37.7859949684164 | -122.41293432549801 | (37.7859949684164, -122.412934325498) | ||
| 80726 | 80726 | 112691 | Undocumented 2 | Tree(s) :: 17 | 1x CUMBERLAND ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6005299.0 | 2104587.0 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | ||||
| 80863 | 80863 | 106175 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 81590 | 81590 | 114681 | Undocumented 2 | Ficus Spp. :: 253 | 235 GEARY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6010571.0 | 2114715.0 | 37.7872002104764 | -122.407209329428 | (37.7872002104764, -122.407209329428) | |||||
| 82217 | 82217 | 93894 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 83678 | 83678 | 99998 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013420.0 | 2115433.0 | 37.7893307029327 | -122.397402707509 | (37.7893307029327, -122.397402707509) | |||
| 83806 | 83806 | 111767 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 4966 17th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5997580.2349427 | 2105651.04183436 | 37.761577335837295 | -122.45150033551 | (37.7615773358373, -122.45150033551) | |||||
| 84192 | 84192 | 113229 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1150 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
| 85219 | 85219 | 111679 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1150 SUTTER ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6007057.0 | 2115063.0 | 37.787958446039504 | -122.419391734764 | (37.7879584460395, -122.419391734764) | ||||
| 85497 | 85497 | 103713 | Permitted Site 1 | Tree(s) :: 17 | 520 Jones St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3.5 | Permit Number 770327 | 6008908.0 | 2114310.0 | 37.7859949684164 | -122.41293432549801 | (37.7859949684164, -122.412934325498) | |||
| 87230 | 87230 | 106179 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 87768 | 87768 | 113227 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1150 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
| 88742 | 88742 | 93897 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 89278 | 89278 | 114685 | Undocumented 2 | Ficus Spp. :: 253 | 235 GEARY ST | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4x4 | 6010571.0 | 2114715.0 | 37.7872002104764 | -122.407209329428 | (37.7872002104764, -122.407209329428) | ||||
| 90332 | 90332 | 100684 | Undocumented 2 | Tree(s) :: 17 | 400 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6012367.0 | 2116823.0 | 37.7930886299645 | -122.40114369902099 | (37.7930886299645, -122.401143699021) | |||||
| 90472 | 90472 | 120871 | Undocumented 2 | Shrub :: Shrub 98 | 1387 08th Ave | 1 | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 5993606.0 | 2106068.0 | 37.762493810072606 | -122.465275766733 | (37.7624938100726, -122.465275766733) | |||||
| 92565 | 92565 | 116410 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 93837 | 93837 | 112695 | Undocumented 2 | Tree(s) :: 17 | 1x CUMBERLAND ST | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6005299.0 | 2104587.0 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | ||||
| 94511 | 94511 | 112694 | Undocumented 2 | Tree(s) :: 17 | 1x CUMBERLAND ST | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6005299.0 | 2104587.0 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | ||||
| 94785 | 94785 | 100008 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | |||
| 95159 | 95159 | 96547 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 96623 | 96623 | 106177 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 97394 | 97394 | 58598 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4966 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/19/1979 12:00:00 AM | Permit Number 17804 | 5997580.2349427 | 2105651.04183436 | 37.761577335837295 | -122.45150033551 | (37.7615773358373, -122.45150033551) | |||
| 98016 | 98016 | 93915 | Permitted Site 1 | Tree(s) :: 17 | 1131 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/26/2010 12:00:00 AM | Permit Number 53385 | 6006791.4 | 2114889.1 | 37.7874659967155 | -122.42029831720501 | (37.7874659967155, -122.420298317205) | |||
| 98599 | 98599 | 93896 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 98713 | 98713 | 100010 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 501X Mission St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | ||||
| 98842 | 98842 | 106181 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 99533 | 99533 | 100242 | Private 5 | Tree(s) :: 17 | 76 Linda St | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 6005815.0 | 2105046.0 | 37.76038415245 | -122.422976606568 | (37.76038415245, -122.422976606568) | ||||||
| 99763 | 99763 | 112693 | Undocumented 2 | Tree(s) :: 17 | 1x CUMBERLAND ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6005299.0 | 2104587.0 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | ||||
| 99800 | 99800 | 93888 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 99815 | 99815 | 93895 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 101067 | 101067 | 106178 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 101358 | 101358 | 99777 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 492x Jersey St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 492-494x Jersey St 845-849 Diamond St | 6001966.3 | 2101499.0 | 37.7504270178067 | -122.43603363507799 | (37.7504270178067, -122.436033635078) | |||
| 101965 | 101965 | 117577 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 701x CALIFORNIA ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6010911.0 | 2116555.0 | 37.79227143324471 | -122.406162679671 | (37.7922714332447, -122.406162679671) | ||||
| 104278 | 104278 | 117387 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 104345 | 104345 | 106180 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 104559 | 104559 | 114737 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 455x LILY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW for City Agency 10 | DPW 4 | 6004484.0 | 2109981.0 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | ||||
| 104672 | 104672 | 64402 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 05/14/1988 12:00:00 AM | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||
| 104752 | 104752 | 116408 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 106682 | 106682 | 96543 | Permitted Site 1 | Tree(s) :: 17 | 100 Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 107020 | 107020 | 116412 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 107198 | 107198 | 93898 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 107881 | 107881 | 93889 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 108635 | 108635 | 111677 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1138 SUTTER ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6007105.0 | 2115125.0 | 37.7881313861469 | -122.41923006280399 | (37.7881313861469, -122.419230062804) | ||||
| 108949 | 108949 | 117383 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 109802 | 109802 | 93893 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 110127 | 110127 | 96546 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 110429 | 110429 | 111678 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1150 SUTTER ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6007057.0 | 2115063.0 | 37.787958446039504 | -122.419391734764 | (37.7879584460395, -122.419391734764) | ||||
| 110892 | 110892 | 96548 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 111306 | 111306 | 52287 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 72 Valley St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 03/04/2011 12:00:00 AM | Permit Number 54678 | 6005433.61319764 | 2099357.0668783 | 37.7447421315969 | -122.42389111052499 | (37.7447421315969, -122.423891110525) | |||
| 112434 | 112434 | 98536 | Permitted Site 1 | Tree(s) :: 17 | 637A Capp St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | 3x3 | Permit Number 768694 | 6007346.4 | 2103619.4 | 37.756553332027 | -122.41757907963002 | (37.756553332027, -122.41757907963) | ||
| 113559 | 113559 | 112692 | Undocumented 2 | Tree(s) :: 17 | 1x CUMBERLAND ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6005299.0 | 2104587.0 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | ||||
| 113644 | 113644 | 117385 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 113940 | 113940 | 107411 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3634 20th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006068.0 | 2104353.0 | 37.7584956093101 | -122.422052363883 | (37.7584956093101, -122.422052363883) | ||||
| 114639 | 114639 | 103722 | Permitted Site 1 | Tree(s) :: 17 | 238 Eddy St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/14/2014 12:00:00 AM | 3x4 | Permit Number 770336 | 6009270.0 | 2113638.0 | 37.7841701309766 | -122.4116344015 | (37.7841701309766, -122.4116344015) | ||
| 117100 | 117100 | 117384 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 119725 | 119725 | 117382 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 119806 | 119806 | 117578 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 701x CALIFORNIA ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6010911.0 | 2116555.0 | 37.79227143324471 | -122.406162679671 | (37.7922714332447, -122.406162679671) | ||||
| 119854 | 119854 | 58338 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1150 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/07/1978 12:00:00 AM | 3x3 | Permit Number 17363 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||
| 121768 | 121768 | 93914 | Permitted Site 1 | Tree(s) :: 17 | 1131 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/26/2010 12:00:00 AM | Permit Number 53385 | 6006791.4 | 2114889.1 | 37.7874659967155 | -122.42029831720501 | (37.7874659967155, -122.420298317205) | |||
| 122175 | 122175 | 93892 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 124131 | 124131 | 114682 | Undocumented 2 | Ficus Spp. :: 253 | 235 GEARY ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6010571.0 | 2114715.0 | 37.7872002104764 | -122.407209329428 | (37.7872002104764, -122.407209329428) | |||||
| 124691 | 124691 | 100003 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | |||
| 125641 | 125641 | 113226 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1118 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006956.0 | 2114756.0 | 37.787109810462 | -122.419719385886 | (37.787109810462, -122.419719385886) | ||||
| 125867 | 125867 | 106176 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 126060 | 126060 | 103712 | Permitted Site 1 | Tree(s) :: 17 | 520 Jones St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/13/2013 12:00:00 AM | 3x3.5 | Permit Number 770327 | 6008908.0 | 2114310.0 | 37.7859949684164 | -122.41293432549801 | (37.7859949684164, -122.412934325498) | ||
| 127022 | 127022 | 114430 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 455 EDDY ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6008254.0 | 2113439.0 | 37.783566680449795 | -122.41513531885201 | (37.7835666804498, -122.415135318852) | ||||
| 127063 | 127063 | 101446 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||||
| 127244 | 127244 | 113228 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1150 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
| 127599 | 127599 | 93891 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 128024 | 128024 | 116409 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 128958 | 128958 | 100007 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | |||
| 129101 | 129101 | 106174 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 129253 | 129253 | 111768 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4966 17th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5997580.2349427 | 2105651.04183436 | 37.761577335837295 | -122.45150033551 | (37.7615773358373, -122.45150033551) | |||||
| 138268 | 138268 | 93890 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 138787 | 138787 | 113230 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1150 Polk St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
| 139163 | 139163 | 116411 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 139331 | 139331 | 117386 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 140350 | 140350 | 103723 | Permitted Site 1 | Tree(s) :: 17 | 238 Eddy St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/14/2014 12:00:00 AM | 3x4 | Permit Number 770336 | 6009270.0 | 2113638.0 | 37.7841701309766 | -122.4116344015 | (37.7841701309766, -122.4116344015) | ||
| 141907 | 141907 | 103711 | Permitted Site 1 | Tree(s) :: 17 | 520 Jones St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/13/2013 12:00:00 AM | 3x3.5 | Permit Number 770327 | 6008908.0 | 2114310.0 | 37.7859949684164 | -122.41293432549801 | (37.7859949684164, -122.412934325498) | ||
| 142312 | 142312 | 103724 | Permitted Site 1 | Tree(s) :: 17 | 238 Eddy St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/14/2014 12:00:00 AM | 3x4 | Permit Number 770336 | 6009270.0 | 2113638.0 | 37.7841701309766 | -122.4116344015 | (37.7841701309766, -122.4116344015) | ||
| 143083 | 143083 | 101447 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||||
| 143626 | 143626 | 96540 | Permitted Site 1 | Tree(s) :: 17 | 100 Pine St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 143941 | 143941 | 32129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 35 Spofford Ln | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35491 | 6010554.96159279 | 2117351.45133924 | 37.7944383752725 | -122.407450761229 | (37.7944383752725, -122.407450761229) | ||
| 22852 | 22852 | 138173 | Undocumented 2 | :: 54 | 1953 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 6000211.2401 | 2111613.6154 | 37.7780993776744 | -122.44282896766 | (37.7780993776744, -122.44282896766) | |||
| 36634 | 36634 | 247287 | Undocumented 2 | :: 54 | 640 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997019.8905 | 2108844.4958 | 37.770313639572 | -122.453668930321 | (37.770313639572, -122.453668930321) | |||
| 37254 | 37254 | 140262 | Undocumented 2 | :: 54 | 70 Cole St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997786.9682 | 2110316.587 | 37.7743995682404 | -122.451121798449 | (37.7743995682404, -122.451121798449) | |||
| 46024 | 46024 | 177585 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 Melra Ct | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 5ft | 6008966.99196 | 2086413.05326 | 37.7093994603862 | -122.410759348591 | (37.7093994603862, -122.410759348591) | |||
| 50533 | 50533 | 247288 | Undocumented 2 | :: 54 | 638 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997017.3270000005 | 2108860.304 | 37.770356897849105 | -122.453678939083 | (37.7703568978491, -122.453678939083) | |||
| 52776 | 52776 | 247289 | Undocumented 2 | :: 54 | 636 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997016.0452 | 2108877.8212 | 37.7704049220759 | -122.45368463790199 | (37.7704049220759, -122.453684637902) | |||
| 89561 | 89561 | 141330 | Undocumented 2 | :: 54 | 1314 HAYES ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 6001510.5734 | 2110463.2514 | 37.7750147569158 | -122.438251682494 | (37.7750147569158, -122.438251682494) | |||
| 129766 | 129766 | 246016 | Undocumented 2 | :: 54 | 1605 Haight St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5998345.69 | 2108581.6399 | 37.7696678206354 | -122.449064074288 | (37.7696678206354, -122.449064074288) | |||
| 134533 | 134533 | 181882 | Undocumented 2 | :: 54 | 2339 32nd Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5986377.6918 | 2099330.2097 | 37.7435741741127 | -122.48977995723999 | (37.7435741741127, -122.48977995724) | |||
| 134641 | 134641 | 184184 | Undocumented 2 | :: 54 | 1642 Lower Great Hwy | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5980990.4302 | 2103889.7643 | 37.7557774014806 | -122.508745894794 | (37.7557774014806, -122.508745894794) | |||
| 158331 | 158331 | 184392 | Undocumented 2 | :: 54 | 2040 Lower Great Hwy | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5981213.3751 | 2101162.7638 | 37.748302968665705 | -122.50777253673 | (37.7483029686657, -122.50777253673) | |||
| 165689 | 165689 | 140263 | Undocumented 2 | :: 54 | 60 Cole St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997782.8203 | 2110340.7836 | 37.7744657683679 | -122.451137892048 | (37.7744657683679, -122.451137892048) | |||
| 188216 | 188216 | 182185 | Undocumented 2 | :: 54 | 1638 25th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5988431.9652 | 2104143.1815 | 37.756909042216 | -122.483029559375 | (37.756909042216, -122.483029559375) |
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");