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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90012 | 90012 | 94626 | Permitted Site 1 | Alnus rhombifolia :: White Alder 204 | 1740 Bancroft Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 9 | permit 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
| 116551 | 116551 | 93975 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 59@ Golden gate Ave Roselyn Ter | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Tree 3 on Golden Gate Ave | 5998204.2 | 2111419.4 | 37.777451486883294 | -122.449758011487 | (37.7774514868833, -122.449758011487) | ||||
| 139234 | 139234 | 93020 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | Tree 3 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
| 85124 | 85124 | 85121 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/27/2007 12:00:00 AM | 7 | 2x2 | Tree 2. Permit Number 49495. | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | |
| 138791 | 138791 | 93974 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 59@ Golden Gate Ave Roselyn Ter | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Tree 2 on Golden Gate Ave | 5998204.2 | 2111419.4 | 37.777451486883294 | -122.449758011487 | (37.7774514868833, -122.449758011487) | ||||
| 87296 | 87296 | 93973 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 59@ Golden gate Ave Roselyn Ter | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Tree 1 on Golden gate Ave | 5998204.2 | 2111419.4 | 37.777451486883294 | -122.449758011487 | (37.7774514868833, -122.449758011487) | ||||
| 92708 | 92708 | 85104 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 9 | 2x2 | Tree 1 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
| 2153 | 2153 | 251201 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Permit Number 780227 | 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) | |
| 4916 | 4916 | 251372 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1526 Masonic Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/01/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779800 | 5999767.0 | 2107205.0 | 37.7659690994291 | -122.44404889486401 | (37.7659690994291, -122.444048894864) | |
| 13300 | 13300 | 114607 | Undocumented 2 | Tree(s) :: 17 | 2399X 15TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | Permit Number 779471 | 5991654.0 | 2099150.0 | 37.7433860243849 | -122.471522828523 | (37.7433860243849, -122.471522828523) | |||
| 10157 | 10157 | 173899 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 1762 12th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | |||
| 10163 | 10163 | 173898 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 1762 12th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | |||
| 10019 | 10019 | 173629 | Significant Tree 6 | Tibochina urvilleana :: Princess Flower 260 | 10X Junipero Serra Blvd Off Ramp | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779383 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | |
| 13252 | 13252 | 115099 | Undocumented 2 | Tree(s) :: 17 | 1061X PACHECO ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/16/2017 12:00:00 AM | 3 | 3x10 | Permit Number 779333 | 5991641.0 | 2102174.0 | 37.7516883950984 | -122.47178811631599 | (37.7516883950984, -122.471788116316) | |
| 88445 | 88445 | 122634 | Significant Tree 6 | Tree(s) :: 17 | 3680X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3 | 3x10 | Permit Number 779220 | 5990592.0 | 2091224.0 | 37.7215617409212 | -122.474616575991 | (37.7215617409212, -122.474616575991) | |
| 103209 | 103209 | 122566 | Permitted Site 1 | Betula spp :: Birch 95 | 378 Sweeny St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779091 | 6008597.7357 | 2094518.65936 | 37.731635041845706 | -122.412608176508 | (37.7316350418457, -122.412608176508) | |
| 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) | |
| 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) | |
| 9790 | 9790 | 104876 | Planning Code 138.1 required 4 | Prunus laurocerasus :: English laurel 227 | 2478 43rd Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 778928 | 5983068.6 | 2098273.8 | 37.740479796641296 | -122.50114367627701 | (37.7404797966413, -122.501143676277) | |||
| 9985 | 9985 | 120925 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 9986 | 9986 | 1263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/1998 12:00:00 AM | 10 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |
| 9994 | 9994 | 120923 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 9998 | 9998 | 120931 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 9999 | 9999 | 120922 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10006 | 10006 | 120927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10015 | 10015 | 120928 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10021 | 10021 | 120935 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 11052 | 11052 | 1284 | Significant Tree 6 | Acer buergeranum :: Trident Maple 120 | 3995X Alemany Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3X10 | Permit Number 778829 | 5992111.480830001 | 2087185.8440900003 | 37.7105618710011 | -122.469070448459 | (37.7105618710011, -122.469070448459) | ||
| 82026 | 82026 | 119268 | Permitted Site 1 | Tree(s) :: 17 | 109 Gates St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778717 | 6008342.0 | 2098018.0 | 37.741229112716105 | -122.41373973636001 | (37.7412291127161, -122.41373973636) | |
| 10052 | 10052 | 121312 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x4 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10061 | 10061 | 121311 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x4 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10071 | 10071 | 121313 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x4 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10075 | 10075 | 121310 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x4 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 141673 | 141673 | 117508 | Undocumented 2 | Malus :: Crab Apple 235 | 21 MOUNTAIN SPRING AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 9 | 3x10 | Permit Number 778424 | 5997487.0 | 2104391.0 | 37.758112238825206 | -122.451731896555 | (37.7581122388252, -122.451731896555) | ||
| 86503 | 86503 | 117100 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 677 ULLOA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 778379 | 5994251.0 | 2098113.0 | 37.7406885817292 | -122.46246793072201 | (37.7406885817292, -122.462467930722) | |||
| 114540 | 114540 | 117101 | Undocumented 2 | Tree(s) :: 17 | 677 ULLOA ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778379 | 5994251.0 | 2098113.0 | 37.7406885817292 | -122.46246793072201 | (37.7406885817292, -122.462467930722) | |
| 114144 | 114144 | 116645 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 20 HAWTHORNE ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 04/25/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778170 | 6012906.0 | 2114090.0 | 37.785614507123796 | -122.39908679358801 | (37.7856145071238, -122.399086793588) | |
| 5925 | 5925 | 95365 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 661 Broadway | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 778058 | 6010478.0762 | 2118518.1883 | 37.797637647796996 | -122.40779910526899 | (37.797637647797, -122.407799105269) | ||
| 53643 | 53643 | 95364 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 661 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 3x3 | Permit Number 778058 | 6010448.4751 | 2118513.4790000003 | 37.797623060035 | -122.407901201302 | (37.797623060035, -122.407901201302) | ||
| 88463 | 88463 | 116012 | Undocumented 2 | Salix discolor :: Pussy Willow 437 | 250 HAZELWOOD AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 18 | 10x10 | Permit Number 777957 | 5996359.0 | 2095057.0 | 37.7324187155695 | -122.454958550665 | (37.7324187155695, -122.454958550665) | ||
| 117259 | 117259 | 116463 | Undocumented 2 | Tree(s) :: 17 | 1898X FUNSTON AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 35 | 3x3 | Permit Number 777893 | 5992212.0 | 2102539.0 | 37.752723611861704 | -122.46984011316201 | (37.7527236118617, -122.469840113162) | ||
| 126648 | 126648 | 116460 | Undocumented 2 | Tree(s) :: 17 | 66 AERIAL WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 30 | 3x3 | Permit Number 777893 | 5992280.0 | 2102576.0 | 37.7528291346084 | -122.469607652393 | (37.7528291346084, -122.469607652393) | ||
| 93028 | 93028 | 115827 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 60X CHUMASERO DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777531 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | |
| 105446 | 105446 | 38572 | Permitted Site 1 | Dracaena draco :: Dragon Tree 361 | 1222 Palou Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/25/2016 12:00:00 AM | 3 | Permit Number 777465 | 6016907.86791438 | 2093772.63366009 | 37.730049495784 | -122.38382619652398 | (37.730049495784, -122.383826196524) | ||
| 106512 | 106512 | 117420 | Permitted Site 1 | Tree(s) :: 17 | 77 Dorado Ter | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777175 | 5994584.4 | 2093084.8 | 37.7269015728644 | -122.46095082579399 | (37.7269015728644, -122.460950825794) | |
| 53187 | 53187 | 69218 | Permitted Site 1 | Tree(s) :: 17 | 1196 Treat Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/02/2015 12:00:00 AM | 3x3 | Permit Number 776894 | 6008647.40418625 | 2101585.3758574 | 37.7510414812393 | -122.412935918741 | (37.7510414812393, -122.412935918741) | ||
| 86280 | 86280 | 113491 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 132 | 366x 07TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/07/2015 12:00:00 AM | 6 | 3x3 | Permit Number 776681 | 5993712.0 | 2113143.0 | 37.7819259902039 | -122.465423128165 | (37.7819259902039, -122.465423128165) | |
| 82017 | 82017 | 112740 | Undocumented 2 | Tree(s) :: 17 | 2514 CLAY ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/09/2015 12:00:00 AM | 3x3 | Permit Number 776637 | 6002696.0 | 2116178.0 | 37.7907733646004 | -122.43455974658 | (37.7907733646004, -122.43455974658) | ||
| 79092 | 79092 | 115287 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1526 12th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 776185 | 5992489.2 | 2105046.7 | 37.759625121297795 | -122.469064003389 | (37.7596251212978, -122.469064003389) | |||
| 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) | |
| 84318 | 84318 | 114974 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 23 Holloway Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 775981 | 5996745.4 | 2091181.1 | 37.7217985747524 | -122.45334295571999 | (37.7217985747524, -122.45334295572) | |||
| 98092 | 98092 | 115300 | Permitted Site 1 | Tristania conferta :: 79 | 177 Lomita Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | |||
| 99519 | 99519 | 115299 | Permitted Site 1 | Tristania conferta :: 79 | 177 Lomita Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | |||
| 105069 | 105069 | 115270 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 2218 31st Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775791 | 5986730.3 | 2100136.4 | 37.7458083387155 | -122.48861998421499 | (37.7458083387155, -122.488619984215) | |||
| 99798 | 99798 | 111746 | Permitted Site 1 | Tristania conferta :: 79 | 398X 03rd St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/22/2015 12:00:00 AM | 3 | 10x20 | Permit Number 775763 | 6013296.047180001 | 2113048.21405 | 37.7827757318295 | -122.397664238011 | (37.7827757318295, -122.397664238011) | |
| 140674 | 140674 | 111747 | Permitted Site 1 | Tristania conferta :: 79 | 398X 03rd St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/22/2015 12:00:00 AM | 3 | 10x20 | Permit Number 775763 | 6013296.047180001 | 2113048.21405 | 37.7827757318295 | -122.397664238011 | (37.7827757318295, -122.397664238011) | |
| 107475 | 107475 | 110612 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 15 MAGELLAN AVE | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775412 | 5994586.0 | 2101167.0 | 37.7490933856104 | -122.46153099469801 | (37.7490933856104, -122.461530994698) | ||
| 77563 | 77563 | 94632 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3600 16th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 3x3 | Permit Number 775358 | 6002902.0 | 2106490.0 | 37.764184223284396 | -122.433154488347 | (37.7641842232844, -122.433154488347) | ||
| 141647 | 141647 | 122627 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 34 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 3x4 | Permit Number 775279 | 5984731.0 | 2094410.0 | 37.729968312905505 | -122.49511098534401 | (37.7299683129055, -122.495110985344) | |
| 109068 | 109068 | 112659 | Permitted Site 1 | Tree(s) :: 17 | 101 Quintara St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/14/2015 12:00:00 AM | Permit Number 775001 | 5993151.2 | 2101136.7 | 37.748927499569604 | -122.466490304373 | (37.7489274995696, -122.466490304373) | |||
| 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) | |
| 15948 | 15948 | 101850 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001X Rhode Island St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 2 | 3x3 | Permit Number 774983 | 6011937.4679 | 2103668.00433 | 37.7569440557359 | -122.401704847401 | (37.7569440557359, -122.401704847401) | |
| 63008 | 63008 | 114541 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001X Rhode Island St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011939.68484 | 2103650.19837 | 37.756895288204 | -122.401695928834 | (37.756895288204, -122.401695928834) | ||
| 138648 | 138648 | 122626 | Planning Code 138.1 required 4 | Cordyline australis :: Dracena Palm 141 | 330 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 3x5 | Permit Number 774975 | 5984613.0 | 2095517.0 | 37.73300093168071 | -122.495600537949 | (37.7330009316807, -122.495600537949) | |
| 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) | |
| 53784 | 53784 | 113548 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1911 20th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 774960 | 6012300.00129 | 2104664.7502 | 37.759701124429796 | -122.400521077012 | (37.7597011244298, -122.400521077012) | ||
| 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) | |
| 88436 | 88436 | 110160 | Undocumented 2 | Ficus Spp. :: 253 | 484 Sanchez St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774829 | 6003562.4 | 2105468.5 | 37.761416869861996 | -122.430797452614 | (37.761416869862, -122.430797452614) | ||||
| 86120 | 86120 | 114712 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 92714 | 92714 | 114713 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 97865 | 97865 | 114715 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 105879 | 105879 | 114717 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 110071 | 110071 | 114718 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 118222 | 118222 | 114719 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 125441 | 125441 | 114716 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 143907 | 143907 | 114714 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 121701 | 121701 | 108636 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 68 Mangels Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774603 | 6000942.00546 | 2095224.20835 | 37.7331396755893 | -122.439126041581 | (37.7331396755893, -122.439126041581) | |
| 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) | |
| 110771 | 110771 | 109970 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1x DAVIS ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | ||
| 103873 | 103873 | 110454 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 7630 Geary Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774506 | 5983294.7 | 2112541.2 | 37.7796673212814 | -122.501417065582 | (37.7796673212814, -122.501417065582) | |
| 119888 | 119888 | 107369 | Undocumented 2 | Tree(s) :: 17 | 1990X LAGUNA ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/21/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774385 | 6004403.0 | 2115650.0 | 37.789420363641895 | -122.42861595649099 | (37.7894203636419, -122.428615956491) | |
| 81042 | 81042 | 112562 | Permitted Site 1 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.47414022419301 | (37.7515380150924, -122.474140224193) | ||||
| 117600 | 117600 | 112563 | Permitted Site 1 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.47414022419301 | (37.7515380150924, -122.474140224193) | ||||
| 90642 | 90642 | 108476 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 104770 | 104770 | 108475 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 119669 | 119669 | 108477 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 92122 | 92122 | 115292 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2058 17th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 774300 | 5991031.5 | 2101384.0 | 37.7494839769409 | -122.47383819807501 | (37.7494839769409, -122.473838198075) | |||
| 78260 | 78260 | 108099 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2390X Green St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/20/2014 12:00:00 AM | 3 | Permit Number 774210 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | ||
| 125075 | 125075 | 53133 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 925 Holloway Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774158 | 5994000.81776041 | 2091173.40830125 | 37.7216197566197 | -122.46282963525199 | (37.7216197566197, -122.462829635252) | ||
| 105658 | 105658 | 112431 | Undocumented 2 | Tree(s) :: 17 | 19 Arguello Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3x3 | Permit Number 774101 | 5995479.0 | 2115773.8 | 37.7892512085361 | -122.45950075691601 | (37.7892512085361, -122.459500756916) | ||
| 110265 | 110265 | 112433 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Arguello Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 774101 | 5995479.0 | 2115773.8 | 37.7892512085361 | -122.45950075691601 | (37.7892512085361, -122.459500756916) | |||
| 99781 | 99781 | 112425 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 17 Arguello Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3x3 | Permit Number 774100 | 5995478.7 | 2115781.3 | 37.789271784254495 | -122.45950233827601 | (37.7892717842545, -122.459502338276) | ||
| 84422 | 84422 | 107419 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
| 85088 | 85088 | 107418 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
| 140378 | 140378 | 107415 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
| 142964 | 142964 | 107417 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) |
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");