Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22894 | 22894 | 206842 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994803.1874 | 2087784.4983 | 37.712360795684 | -122.45981072288001 | (37.712360795684, -122.45981072288) | |
| 22897 | 22897 | 215094 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.2030900002 | 37.7123610457095 | -122.45974695827199 | (37.7123610457095, -122.459746958272) | |
| 777 | 777 | 234744 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 15th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | Width 3ft | 6001486.4222099995 | 2107220.2274599997 | 37.766108846174795 | -122.438102867577 | (37.7661088461748, -122.438102867577) | |||
| 821 | 821 | 251392 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Width 3ft | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 843 | 843 | 216491 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/29/1998 12:00:00 AM | 0 | Width 3ft | 6001764.68694 | 2095507.97765 | 37.733965618424 | -122.43630211726601 | (37.733965618424, -122.436302117266) | ||
| 5088 | 5088 | 206891 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1675x 15th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | Width 3ft | 5991393.559640001 | 2103864.47578 | 37.756315678748706 | -122.472767037095 | (37.7563156787487, -122.472767037095) | |||
| 927 | 927 | 140951 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 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) | ||||
| 14398 | 14398 | 104044 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601X Kansas St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 70 | 9x9 | 6011818.89895 | 2100809.64818 | 37.749089017243904 | -122.401913980245 | (37.7490890172439, -122.401913980245) | |||
| 82646 | 82646 | 42355 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 380X Flood Ave | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 9 | 8x90 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 88765 | 88765 | 42344 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 380X Flood Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 8 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 123438 | 123438 | 42348 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 3 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 92501 | 92501 | 97725 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | |||
| 117800 | 117800 | 97724 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 96557 | 96557 | 107036 | Significant Tree 6 | Tree(s) :: 17 | 350 08th St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/23/2014 12:00:00 AM | 7x7 | Permit Number 772214 | 6009826.0 | 2110084.0 | 37.774442857676505 | -122.409459923405 | (37.7744428576765, -122.409459923405) | |||
| 92726 | 92726 | 97722 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 128722 | 128722 | 97723 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 142088 | 142088 | 114593 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1 BRADFORD ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | 6x9 | 6009441.0 | 2096050.0 | 37.735887066073104 | -122.409800886333 | (37.7358870660731, -122.409800886333) | |||
| 15582 | 15582 | 106047 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 618- 622 Carolina St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | 6x7 | 6012364.1992 | 2105044.14437 | 37.7607464370199 | -122.40032569478599 | (37.7607464370199, -122.400325694786) | |||
| 80242 | 80242 | 24613 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1735 Mission St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | 6x7 | 6006758.7391800005 | 2108085.91697 | 37.768784258651706 | -122.419928366315 | (37.7687842586517, -122.419928366315) | |||
| 4532 | 4532 | 253201 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4536 | 4536 | 253202 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4541 | 4541 | 253199 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4545 | 4545 | 253200 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 87877 | 87877 | 113532 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2681 28TH AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6x6 | 5987701.0 | 2097026.0 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | ||||
| 103044 | 103044 | 113533 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2681 28TH AVE | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6x6 | 5987701.0 | 2097026.0 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | ||||
| 107836 | 107836 | 113531 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2681 28TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 28 | 6x6 | 5987701.0 | 2097026.0 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | |||
| 77166 | 77166 | 77218 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 499X Hearst Ave | 22 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 3 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 145137 | 145137 | 77213 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 499X Hearst Ave | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 8 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 105768 | 105768 | 53309 | Permitted Site 1 | Eucalyptus microtheca :: Flooded Box: Coolibah 465 | 1775 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/28/1969 12:00:00 AM | 30 | 6x4 | Permit Number 6200 | 5992783.51352838 | 2103394.77336118 | 37.7551063623302 | -122.46792597398998 | (37.7551063623302, -122.46792597399) | |
| 104931 | 104931 | 98197 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 830 Joost Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6x24 | 5996641.8 | 2095053.2 | 37.732424500806204 | -122.45398057585 | (37.7324245008062, -122.45398057585) | ||||
| 141689 | 141689 | 75040 | DPW Maintained 3 | Tree(s) :: 17 | 499X Hearst Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 18 | 6x20 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 113458 | 113458 | 103544 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 905X Phelps St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 6x12 | 6014832.8 | 2097357.7 | 37.7397784309436 | -122.39125052869 | (37.7397784309436, -122.39125052869) | |||
| 143955 | 143955 | 103545 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 905X Phelps St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 6x12 | 6014832.8 | 2097357.7 | 37.7397784309436 | -122.39125052869 | (37.7397784309436, -122.39125052869) | |||
| 11634 | 11634 | 101011 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 83 Santa Ynez Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 6x10 | 6000610.71791 | 2092062.1351 | 37.724438494726 | -122.44004473049101 | (37.724438494726, -122.440044730491) | |||
| 84750 | 84750 | 122402 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 2020 09th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6x10 | 5993533.0 | 2101713.0 | 37.750531896370894 | -122.465211903667 | (37.7505318963709, -122.465211903667) | ||||
| 15094 | 15094 | 52153 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 525 Phelps St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 15 | 5x9 | Permit Number 48345 | 6015376.330519999 | 2098074.72194 | 37.7417773752369 | -122.38942127378701 | (37.7417773752369, -122.389421273787) |
| 99139 | 99139 | 74759 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Foerster St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 30 | 5x7 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 9067 | 9067 | 85664 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2774 FOLSOM ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/14/2007 12:00:00 AM | 3 | 5x5 | Permit Number 49691 | 6008274.0 | 2102260.0 | 37.7528728796483 | -122.414274918711 | (37.7528728796483, -122.414274918711) | |
| 10201 | 10201 | 173901 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4201x Lincoln Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x5 | |||||||||
| 15999 | 15999 | 94036 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/08/2012 12:00:00 AM | 3 | 5x5 | 6015673.325 | 2095216.0053 | 37.7339443827642 | -122.388194894968 | (37.7339443827642, -122.388194894968) | |
| 265 | 265 | 109354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007474.1784 | 2120601.5824599997 | 37.803189502164294 | -122.418341225173 | (37.8031895021643, -122.418341225173) | |||
| 24884 | 24884 | 109356 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 5x45 | 6007464.49344 | 2120601.01033 | 37.8031873860571 | -122.41837469975 | (37.8031873860571, -122.41837469975) | |||
| 48049 | 48049 | 109359 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007452.06537 | 2120598.7604799997 | 37.8031805089269 | -122.41841754792802 | (37.8031805089269, -122.418417547928) | |||
| 70565 | 70565 | 109362 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007443.52896 | 2120597.58705 | 37.8031768064372 | -122.41844700523701 | (37.8031768064372, -122.418447005237) | |||
| 71497 | 71497 | 109357 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 9 | 5x45 | 6007459.04695 | 2120599.58062 | 37.8031831538387 | -122.41839344609801 | (37.8031831538387, -122.418393446098) | |||
| 75911 | 75911 | 109363 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007417.13772 | 2120593.69695 | 37.8031646394947 | -122.418538057081 | (37.8031646394947, -122.418538057081) | |||
| 147679 | 147679 | 109360 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007448.76613 | 2120598.25036 | 37.803178922540205 | -122.418428928878 | (37.8031789225402, -122.418428928878) | |||
| 155176 | 155176 | 109361 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007445.84949 | 2120597.53947 | 37.803176806427004 | -122.418438971581 | (37.803176806427, -122.418438971581) | |||
| 171997 | 171997 | 109358 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007454.77295 | 2120598.70497 | 37.8031805089291 | -122.41840817430901 | (37.8031805089291, -122.418408174309) | |||
| 173674 | 173674 | 109355 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 5x45 | 6007469.51339 | 2120600.5219 | 37.8031863275346 | -122.41835729337299 | (37.8031863275346, -122.418357293373) | |||
| 81251 | 81251 | 110699 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 86766 | 86766 | 110697 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 89635 | 89635 | 110703 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 91726 | 91726 | 110707 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 93740 | 93740 | 110709 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 100155 | 100155 | 110713 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 103860 | 103860 | 98343 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999x Turk St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/01/2012 12:00:00 AM | 5x3 | Permit Number 768613 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||
| 105826 | 105826 | 110705 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 117765 | 117765 | 110711 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 122583 | 122583 | 110701 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 15983 | 15983 | 110861 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 170 Hawthorne St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | 5x24 | 6013543.16782 | 2113421.50619 | 37.783814463920706 | -122.396835478069 | (37.7838144639207, -122.396835478069) | |||
| 16392 | 16392 | 110857 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 170 Hawthorne St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 5x24 | 6013483.77966 | 2113482.08281 | 37.7839774876065 | -122.397045189184 | (37.7839774876065, -122.397045189184) | |||
| 16455 | 16455 | 110859 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 170 Hawthorne St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 5x24 | 6013516.8899300005 | 2113448.7565 | 37.7838878243194 | -122.396928301602 | (37.7838878243194, -122.396928301602) | |||
| 16586 | 16586 | 110860 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 170 Hawthorne St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 5x24 | 6013528.50874 | 2113433.67795 | 37.7838470688278 | -122.39688704702 | (37.7838470688278, -122.39688704702) | |||
| 16756 | 16756 | 110858 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 170 Hawthorne St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 5x24 | 6013503.26461 | 2113462.88625 | 37.7839258629187 | -122.396976431519 | (37.7839258629187, -122.396976431519) | |||
| 16234 | 16234 | 96620 | Permitted Site 1 | Azara microphylla :: Little-Leaf Azara 295 | 525 Phelps St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 15 | 5x15 | Permit Number 48345 | 6015380.46656 | 2098080.19885 | 37.741792643019096 | -122.38940735498801 | (37.7417926430191, -122.389407354988) | |
| 66023 | 66023 | 102260 | Undocumented 2 | Tree(s) :: 17 | 1350 46th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 24 | 4x6 | 5981875.8 | 2105892.8 | 37.761329314711105 | -122.505832545781 | (37.7613293147111, -122.505832545781) | |||
| 79096 | 79096 | 84742 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 147 Alhambra St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001618.0 | 2120311.0 | 37.8020602472718 | -122.438585827087 | (37.8020602472718, -122.438585827087) | ||
| 84179 | 84179 | 98330 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 147 Alhambra St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001593.9 | 2120254.3 | 37.801903193112004 | -122.438665159251 | (37.801903193112, -122.438665159251) | ||
| 101885 | 101885 | 122625 | Planning Code 138.1 required 4 | Cordyline australis :: Dracena Palm 141 | 189 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 4x5 | Permit Number 774974 | 5984222.0 | 2094938.0 | 37.731388248087605 | -122.496909587532 | (37.7313882480876, -122.496909587532) | |
| 132 | 132 | 116641 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
| 138 | 138 | 72565 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/16/1996 12:00:00 AM | 3 | 4x4 | Permit Number 770847 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |
| 139 | 139 | 116640 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
| 8317 | 8317 | 106949 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2401 Broadway | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 4x4 | 6002070.184169999 | 2117343.17856 | 37.7939370979581 | -122.43680848054599 | (37.7939370979581, -122.436808480546) | |||
| 79719 | 79719 | 112585 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | ||||
| 82449 | 82449 | 112583 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | |||
| 84691 | 84691 | 21808 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2600X Taylor St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/01/2016 12:00:00 AM | 3 | 4x4 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 92094 | 92094 | 101973 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1695 21st Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | Permit Number 769633 | 5989621.7 | 2103844.4 | 37.7561578263999 | -122.478893204843 | (37.7561578263999, -122.478893204843) | |||
| 102637 | 102637 | 107643 | DPW Maintained 3 | Tree(s) :: 17 | 455 ATHENS ST | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 4x4 | 6003769.0 | 2090659.8 | 37.720767283734105 | -122.429027043999 | (37.7207672837341, -122.429027043999) | ||||
| 108178 | 108178 | 112584 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | ||||
| 110122 | 110122 | 14584 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1159 Masonic Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 100 | 4x4 | 5999323.48045 | 2108827.83023 | 37.7703996711999 | -122.445699648114 | (37.7703996711999, -122.445699648114) | |||
| 113705 | 113705 | 112586 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | ||||
| 120905 | 120905 | 9746 | Permitted Site 1 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 272 | 710X McAllister St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/21/1998 12:00:00 AM | 6 | 4x4 | 6005653.6676 | 2112008.06895 | 37.779491220069296 | -122.424029686189 | (37.7794912200693, -122.424029686189) | ||
| 126196 | 126196 | 18399 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 24 | 4x4 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
| 138503 | 138503 | 18401 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 4x4 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
| 144628 | 144628 | 9747 | DPW Maintained 3 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 272 | 710X McAllister St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 05/24/2011 12:00:00 AM | 3 | 4x4 | 6005653.6676 | 2112008.06895 | 37.779491220069296 | -122.424029686189 | (37.7794912200693, -122.424029686189) | ||
| 108066 | 108066 | 114815 | Undocumented 2 | Tree(s) :: 17 | 160 BRENTWOOD AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/08/2016 12:00:00 AM | 3 | 4x15 | Permit Number 778944 | 5995496.0 | 2095622.0 | 37.7339205232551 | -122.457982998117 | (37.7339205232551, -122.457982998117) | |
| 104962 | 104962 | 97215 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 20 | 4x12 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | |||
| 126079 | 126079 | 110307 | Permitted Site 1 | Tree(s) :: 17 | 899x Stanyan St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Dept of Real Estate 5 | 04/03/2015 12:00:00 AM | 3 | 4x11 | Permit Number 774992 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972128999 | (37.7668387037649, -122.45306972129) | |
| 95633 | 95633 | 114816 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 125 BRENTWOOD AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x10 | 5995779.0 | 2095603.0 | 37.7338846095715 | -122.45700321324699 | (37.7338846095715, -122.457003213247) | ||||
| 79 | 79 | 251205 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4X4 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | ||||
| 2158 | 2158 | 251202 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | |
| 2159 | 2159 | 251203 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | |
| 2162 | 2162 | 251204 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | |
| 82530 | 82530 | 14583 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1159 Masonic Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 60 | 4X4 | 5999386.3171 | 2108834.4593 | 37.7704214603588 | -122.445482773554 | (37.7704214603588, -122.445482773554) | |||
| 82391 | 82391 | 105357 | Undocumented 2 | Tree(s) :: 17 | 171X Dorado Ter | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 18 | 3x9 | 5994283.2391 | 2093059.23457 | 37.7268140423665 | -122.461990071604 | (37.7268140423665, -122.461990071604) | |||
| 107922 | 107922 | 105358 | Undocumented 2 | Tree(s) :: 17 | 171X Dorado Ter | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 18 | 3x9 | 5994283.2391 | 2093059.23457 | 37.7268140423665 | -122.461990071604 | (37.7268140423665, -122.461990071604) | |||
| 109588 | 109588 | 113335 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X STANFORD ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727.0 | 2112481.0 | 37.781297869167396 | -122.392674013487 | (37.7812978691674, -122.392674013487) | ||
| 117679 | 117679 | 117480 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) |
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");