Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1262 | 1262 | 251479 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1214 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 779194 | 5987090.84961 | 2106996.2792700003 | 37.7646647351899 | -122.48787719677 | (37.7646647351899, -122.48787719677) | ||||
| 1333 | 1333 | 187634 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 148 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779931 | 5987142.0 | 2114987.0 | 37.786607985699604 | -122.48828755026399 | (37.7866079856996, -122.488287550264) | |||
| 9615 | 9615 | 138532 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1670 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6001631.8101 | 2114208.4561 | 37.785305035186894 | -122.438100638619 | (37.7853050351869, -122.438100638619) | ||||
| 9833 | 9833 | 173705 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 181 Addison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002695.0 | 2097057.0 | 37.738271693727796 | -122.433196386583 | (37.7382716937278, -122.433196386583) | ||||
| 9946 | 9946 | 173747 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2799x 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981791.0 | 2096580.0 | 37.735753982711294 | -122.50543552617201 | (37.7357539827113, -122.505435526172) | ||||
| 10258 | 10258 | 173932 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1109x Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003491.0 | 2094313.0 | 37.7307824159859 | -122.430248501015 | (37.7307824159859, -122.430248501015) | |||||
| 11284 | 11284 | 105132 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1619 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 777355 | 5981562.16 | 2104041.1764 | 37.756226819608 | -122.50677993398399 | (37.756226819608, -122.506779933984) | ||
| 11510 | 11510 | 107860 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3667 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 777933 | 5981683.9506 | 2096685.2741 | 37.7360367363779 | -122.505813433386 | (37.7360367363779, -122.505813433386) | |||
| 11593 | 11593 | 116739 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1678 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778366 | 5983788.3957 | 2103743.2164 | 37.755539548337204 | -122.49905895584999 | (37.7555395483372, -122.49905895585) | |||
| 13254 | 13254 | 115458 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 476 FAIR OAKS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005502.0 | 2100939.0 | 37.7490896185955 | -122.423767101444 | (37.7490896185955, -122.423767101444) | ||||
| 20976 | 20976 | 108213 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 126 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995164.0 | 2113575.0 | 37.783195780257 | -122.46043122472 | (37.783195780257, -122.46043122472) | |||||
| 21679 | 21679 | 210472 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 624 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5993801.69661 | 2106684.35823 | 37.764197452264106 | -122.464643687651 | (37.7641974522641, -122.464643687651) | ||||
| 42986 | 42986 | 113272 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 505 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000604.42582894 | 2110679.50515746 | 37.7755569556145 | -122.44140175558 | (37.7755569556145, -122.44140175558) | |||||
| 53606 | 53606 | 121385 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993159.0 | 2107262.0 | 37.7657464318194 | -122.466908568463 | (37.7657464318194, -122.466908568463) | ||||
| 61688 | 61688 | 57206 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2202 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1975 12:00:00 AM | Permit Number 774014 | 6000908.32678769 | 2115906.78943665 | 37.7899270475037 | -122.44072552972 | (37.7899270475037, -122.44072552972) | |||
| 63656 | 63656 | 112446 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 254 CENTRAL AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999892.0 | 2109423.0 | 37.772066299939205 | -122.443775909671 | (37.7720662999392, -122.443775909671) | ||||
| 65296 | 65296 | 110379 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2194 PALOU AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011949.0 | 2097537.0 | 37.7401102866319 | -122.401234145483 | (37.7401102866319, -122.401234145483) | ||||
| 75161 | 75161 | 41044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1444 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2000 12:00:00 AM | Permit Number 41825 | 6007214.22869275 | 2117785.20726397 | 37.795441807697294 | -122.41904090928001 | (37.7954418076973, -122.41904090928) | ||
| 77575 | 77575 | 107856 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981725.3 | 2096580.0 | 37.7357501162313 | -122.50566267275299 | (37.7357501162313, -122.505662672753) | |||||
| 77606 | 77606 | 106897 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2768 GREAT HWY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981642.5 | 2096616.3 | 37.735844912626 | -122.505951630112 | (37.735844912626, -122.505951630112) | |||||
| 77652 | 77652 | 31202 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 276 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1969 12:00:00 AM | Permit Number 34894 | 5995678.83964111 | 2091843.96330625 | 37.7235574477937 | -122.45707767911101 | (37.7235574477937, -122.457077679111) | |||
| 77956 | 77956 | 45719 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 227 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | Permit Number 44389 | 5993425.80357844 | 2089157.89359185 | 37.7160525030782 | -122.464671006022 | (37.7160525030782, -122.464671006022) | |||
| 78090 | 78090 | 113273 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 505 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000604.42582894 | 2110679.50515746 | 37.7755569556145 | -122.44140175558 | (37.7755569556145, -122.44140175558) | |||||
| 78094 | 78094 | 98145 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2495 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x7 | Permit Number 768497 | 5987947.1 | 2098339.7 | 37.7409460050834 | -122.484280768936 | (37.7409460050834, -122.484280768936) | |||
| 78222 | 78222 | 38067 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1654X SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 8x5 | Permit Number 40258 | 6001625.0 | 2114095.0 | 37.7849931264589 | -122.43811606926701 | (37.7849931264589, -122.438116069267) | |
| 78233 | 78233 | 40342 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 170 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | Permit Number 41473 | 5993510.486220299 | 2094049.6713278 | 37.7294890191855 | -122.464733328734 | (37.7294890191855, -122.464733328734) | |||
| 78519 | 78519 | 94912 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1506 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999677.4 | 2107342.3 | 37.7663409791409 | -122.44436866988998 | (37.7663409791409, -122.44436866989) | |||||
| 78722 | 78722 | 97496 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 677 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995323.3 | 2110955.5 | 37.7760124935324 | -122.459690319245 | (37.7760124935324, -122.459690319245) | |||||
| 78781 | 78781 | 121184 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 79111 | 79111 | 122609 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1214 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987117.0 | 2106960.0 | 37.764566647704896 | -122.48778408507201 | (37.7645666477049, -122.487784085072) | ||||
| 79226 | 79226 | 55388 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1377 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1972 12:00:00 AM | 3x3 | Permit Number 11325 | 5993310.46042535 | 2106120.10977525 | 37.762619842052494 | -122.466301708727 | (37.7626198420525, -122.466301708727) | ||
| 79242 | 79242 | 121190 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 79255 | 79255 | 57585 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 297 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | 3x3 | Permit Number 16453 | 6013500.41645948 | 2105713.4077908 | 37.762647381026504 | -122.39644291208 | (37.7626473810265, -122.39644291208) | ||
| 79356 | 79356 | 117521 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1601 PAGE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998904.0 | 2109014.0 | 37.7708868872166 | -122.447164026359 | (37.7708868872166, -122.447164026359) | ||||
| 79648 | 79648 | 94502 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 60 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 53693 | 5994613.0 | 2095460.0 | 37.733424938715 | -122.461024038199 | (37.733424938715, -122.461024038199) | ||||
| 79987 | 79987 | 110384 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2280 PALOU AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24x18 | 6011419.0 | 2097963.0 | 37.741250408777205 | -122.40309663685801 | (37.7412504087772, -122.403096636858) | ||||
| 80010 | 80010 | 121602 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 247X Addison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002641.0 | 2097233.0 | 37.7387518856743 | -122.433395665119 | (37.7387518856743, -122.433395665119) | ||||
| 80352 | 80352 | 121187 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 80679 | 80679 | 94196 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 355 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | |||||
| 80788 | 80788 | 107855 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981725.3 | 2096580.0 | 37.7357501162313 | -122.50566267275299 | (37.7357501162313, -122.505662672753) | |||||
| 81459 | 81459 | 25185 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3638 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 3X3 | 6000425.6878797 | 2103367.625274 | 37.7554701662116 | -122.441495243201 | (37.7554701662116, -122.441495243201) | |||
| 81630 | 81630 | 112805 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1590 NOE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003316.0 | 2098976.0 | 37.743576033800004 | -122.431186211773 | (37.7435760338, -122.431186211773) | ||||
| 81854 | 81854 | 64519 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 505 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1988 12:00:00 AM | Permit Number 25401 | 6000604.42582894 | 2110679.50515746 | 37.7755569556145 | -122.44140175558 | (37.7755569556145, -122.44140175558) | |||
| 82038 | 82038 | 122338 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 410X 04th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994775.0 | 2112759.0 | 37.780932878116396 | -122.461717814262 | (37.7809328781164, -122.461717814262) | ||||
| 82321 | 82321 | 101274 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2350 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988480.0 | 2106495.0 | 37.763369292926996 | -122.483035808211 | (37.763369292927, -122.483035808211) | ||||
| 83086 | 83086 | 113959 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 549 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002757.9 | 2103817.6 | 37.7568382818529 | -122.43346190022498 | (37.7568382818529, -122.433461900225) | ||||
| 83109 | 83109 | 66626 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 496 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2009 12:00:00 AM | Permit Number 52007 | 6003158.91614039 | 2102739.58919536 | 37.7539010640869 | -122.43199806254499 | (37.7539010640869, -122.431998062545) | |||
| 83258 | 83258 | 54511 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 624 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | 3x3 | Permit Number 10305 | 5993855.83604665 | 2106680.47077674 | 37.7641898993307 | -122.464456154065 | (37.7641898993307, -122.464456154065) | ||
| 83432 | 83432 | 113936 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 EL CAMINO DEL MAR | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 776988 | 5985966.0 | 2115003.0 | 37.7865832348262 | -122.49235734524099 | (37.7865832348262, -122.492357345241) | |||
| 83514 | 83514 | 110421 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 39 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011494.0 | 2097294.0 | 37.739417665451604 | -122.402790273501 | (37.7394176654516, -122.402790273501) | ||||
| 83776 | 83776 | 112448 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 254 CENTRAL AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999892.0 | 2109423.0 | 37.772066299939205 | -122.443775909671 | (37.7720662999392, -122.443775909671) | ||||
| 84788 | 84788 | 103369 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1528 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770212 | 6003912.8 | 2099364.9 | 37.744677665265606 | -122.429150348387 | (37.7446776652656, -122.429150348387) | |||
| 84871 | 84871 | 31201 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 257 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1969 12:00:00 AM | Permit Number 34892 | 5995623.87772067 | 2091687.20373025 | 37.723123866844894 | -122.457256336737 | (37.7231238668449, -122.457256336737) | |||
| 85073 | 85073 | 105050 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2835 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771766 | 6002056.0 | 2117852.0 | 37.7953333833033 | -122.436894002104 | (37.7953333833033, -122.436894002104) | |||
| 85079 | 85079 | 110426 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 90 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011326.0 | 2097433.0 | 37.7397899480097 | -122.403380922944 | (37.7397899480097, -122.403380922944) | ||||
| 85308 | 85308 | 121568 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 499X Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998083.0 | 2114873.0 | 37.7869272334312 | -122.450426308155 | (37.7869272334312, -122.450426308155) | ||||
| 85450 | 85450 | 121597 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 998X Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000144.0 | 2102038.0 | 37.7518032865281 | -122.44237395255101 | (37.7518032865281, -122.442373952551) | ||||
| 86054 | 86054 | 114065 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 898x ELIZABETH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000938.0 | 2102006.0 | 37.751760645744206 | -122.439625904919 | (37.7517606457442, -122.439625904919) | ||||
| 86356 | 86356 | 118325 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200x TARAVAL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992604.0 | 2099181.0 | 37.7435260562612 | -122.4682402545 | (37.7435260562612, -122.4682402545) | ||||
| 86623 | 86623 | 107513 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2760 GREENWICH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999743.0 | 2118796.0 | 37.797793624169 | -122.444965226189 | (37.797793624169, -122.444965226189) | ||||||
| 87073 | 87073 | 118915 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5980733.09837 | 2110116.47079 | 37.772858959689 | -122.510098401613 | (37.772858959689, -122.510098401613) | ||||
| 87082 | 87082 | 110870 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 343X AUSTIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775635 | 6005575.0 | 2115207.0 | 37.7882702532087 | -122.424529439646 | (37.7882702532087, -122.424529439646) | |||
| 87239 | 87239 | 31218 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2302 Steiner St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34907 | 6002345.06195587 | 2116106.2366551002 | 37.79055639288929 | -122.43576883650199 | (37.7905563928893, -122.435768836502) | ||||
| 87992 | 87992 | 101275 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2350 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988480.0 | 2106495.0 | 37.763369292926996 | -122.483035808211 | (37.763369292927, -122.483035808211) | ||||
| 88376 | 88376 | 122391 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 163 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999026.0 | 2095466.0 | 37.733694368197 | -122.445767544074 | (37.733694368197, -122.445767544074) | ||||
| 88572 | 88572 | 121382 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993159.0 | 2107262.0 | 37.7657464318194 | -122.466908568463 | (37.7657464318194, -122.466908568463) | ||||
| 88588 | 88588 | 118899 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7300 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5980716.90165 | 2109609.13106 | 37.771464998604 | -122.510116727255 | (37.771464998604, -122.510116727255) | ||||
| 88670 | 88670 | 112445 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 254 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999892.0 | 2109423.0 | 37.772066299939205 | -122.443775909671 | (37.7720662999392, -122.443775909671) | ||||
| 89056 | 89056 | 121188 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 89162 | 89162 | 122337 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 410X 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994775.0 | 2112759.0 | 37.780932878116396 | -122.461717814262 | (37.7809328781164, -122.461717814262) | ||||
| 89600 | 89600 | 103266 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2365 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001713.0 | 2118319.0 | 37.796596142729896 | -122.43811430510799 | (37.7965961427299, -122.438114305108) | ||||
| 90341 | 90341 | 52736 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 90877 | 90877 | 109386 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300X BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000704.0 | 2110147.0 | 37.7741005029649 | -122.441019094263 | (37.7741005029649, -122.441019094263) | ||||
| 90890 | 90890 | 44755 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 256 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2001 12:00:00 AM | Permit Number 43869 | 6014282.34232981 | 2105939.88092695 | 37.7633127092766 | -122.39375434301 | (37.7633127092766, -122.39375434301) | |||
| 90930 | 90930 | 121191 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 91286 | 91286 | 94498 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1600X Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2015 12:00:00 AM | 7x7 | 5998899.3 | 2109049.0 | 37.770982719767794 | -122.44718280302601 | (37.7709827197678, -122.447182803026) | |||
| 91357 | 91357 | 49091 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 101 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46240 | 6005012.04174128 | 2092633.4383737 | 37.7262567475706 | -122.424870568097 | (37.7262567475706, -122.424870568097) | ||||
| 91506 | 91506 | 121193 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 91621 | 91621 | 110056 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 490 Jamestown Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6016119.9 | 2086810.2 | 37.7108884169699 | -122.38606516043899 | (37.7108884169699, -122.386065160439) | |||||
| 91684 | 91684 | 32012 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 196 Casitas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 35406 | 5994862.5482333 | 2097095.53050341 | 37.7379300603176 | -122.460279744028 | (37.7379300603176, -122.460279744028) | ||||
| 91834 | 91834 | 117602 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3749 CLEMENT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5983838.0 | 2113090.0 | 37.781206058559704 | -122.499578155566 | (37.7812060585597, -122.499578155566) | ||||
| 92083 | 92083 | 38475 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 162 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40476 | 5999822.84916102 | 2087316.82231241 | 37.7113640595721 | -122.44242775396002 | (37.7113640595721, -122.44242775396) | ||
| 92220 | 92220 | 116215 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3801 SACRAMENTO ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996623.0 | 2114922.0 | 37.7869781063352 | -122.45548108802099 | (37.7869781063352, -122.455481088021) | ||||
| 92242 | 92242 | 33912 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 665 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 37882 | 6002076.88418057 | 2102621.6953038997 | 37.753515953271496 | -122.435731542402 | (37.7535159532715, -122.435731542402) | ||
| 92497 | 92497 | 99770 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1025x Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 595 Clipper St is true property address | 6001337.9 | 2100792.7 | 37.7484519666196 | -122.438156093062 | (37.7484519666196, -122.438156093062) | |||
| 93052 | 93052 | 107928 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 495 09th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | |||
| 93067 | 93067 | 122490 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 69x Bonview St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | ||||
| 93201 | 93201 | 113412 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1672 16TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991218.0 | 2103997.0 | 37.7566693908752 | -122.47338384272499 | (37.7566693908752, -122.473383842725) | ||||
| 93516 | 93516 | 121154 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 50X Trumbull St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778630 | 6003754.0 | 2094198.0 | 37.730481544978794 | -122.429331070998 | (37.7304815449788, -122.429331070998) | |||
| 93562 | 93562 | 110425 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011518.0 | 2097294.0 | 37.7394190054764 | -122.402707291584 | (37.7394190054764, -122.402707291584) | ||||
| 93687 | 93687 | 112450 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 254 CENTRAL AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999892.0 | 2109423.0 | 37.772066299939205 | -122.443775909671 | (37.7720662999392, -122.443775909671) | ||||
| 94344 | 94344 | 114062 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 898x ELIZABETH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | 3x3 | Permit Number 777118 | 6000938.0 | 2102006.0 | 37.751760645744206 | -122.439625904919 | (37.7517606457442, -122.439625904919) | ||
| 94621 | 94621 | 118324 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200x TARAVAL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992604.0 | 2099181.0 | 37.7435260562612 | -122.4682402545 | (37.7435260562612, -122.4682402545) | ||||
| 95270 | 95270 | 121186 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 95589 | 95589 | 119627 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 El Sereno Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999504.0 | 2097253.0 | 37.738628328633396 | -122.44424333392901 | (37.7386283286334, -122.444243333929) | ||||
| 95654 | 95654 | 112156 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 501 SANCHEZ ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003633.0 | 2105226.0 | 37.7607550226872 | -122.43053597282899 | (37.7607550226872, -122.430535972829) | |||||
| 95751 | 95751 | 110523 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 DOUGLASS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775559 | 6001085.0 | 2106026.0 | 37.762806954373104 | -122.439405692132 | (37.7628069543731, -122.439405692132) | |||
| 95894 | 95894 | 107924 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 495 09th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.6283400003 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | |||
| 95978 | 95978 | 38435 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 950 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | Permit Number 40462 | 6003103.32448359 | 2102701.71275072 | 37.7537939125694 | -122.43218760661101 | (37.7537939125694, -122.432187606611) | |||
| 96471 | 96471 | 56770 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 249 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | Permit Number 777118 | 6000646.04543173 | 2102139.76865728 | 37.752111320918495 | -122.440645114373 | (37.7521113209185, -122.440645114373) |
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");