Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114 | 114 | 251216 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 399X Townsend St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 118 | 118 | 251217 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 399X Townsend St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 595 | 595 | 119606 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 299x Avalon Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 883 | 883 | 251306 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 885 | 885 | 251305 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 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) | |||
| 4468 | 4468 | 253632 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 527 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6004455.0 | 2110106.0 | 37.7742008582336 | -122.42804080634701 | (37.7742008582336, -122.428040806347) | ||||
| 5081 | 5081 | 253792 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5085 | 5085 | 253795 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5092 | 5092 | 253791 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5097 | 5097 | 253793 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5099 | 5099 | 253794 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 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) | ||||
| 9684 | 9684 | 173630 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 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) | ||||
| 9868 | 9868 | 173714 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699x 29th St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6002089.0 | 2098776.0 | 37.7429572717864 | -122.435414565427 | (37.7429572717864, -122.435414565427) | ||||
| 9912 | 9912 | 173731 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 484 Chenery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003566.0 | 2096120.0 | 37.7357482768139 | -122.43011807363199 | (37.7357482768139, -122.430118073632) | |||||
| 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) | ||||
| 13301 | 13301 | 187651 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 175 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998689.0 | 2104063.0 | 37.7572803991188 | -122.447551270828 | (37.7572803991188, -122.447551270828) | |||||
| 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) | ||||
| 42963 | 42963 | 113115 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 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) | ||||
| 67557 | 67557 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 690 Miramar Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995444.4 | 2093941.6 | 37.729303587844704 | -122.45803982404199 | (37.7293035878447, -122.458039824042) | |||||
| 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) | ||
| 76347 | 76347 | 111157 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201x EUGENIA AVE | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6006591.0 | 2098138.0 | 37.7414601197382 | -122.419802596536 | (37.7414601197382, -122.419802596536) | ||||
| 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) | ||||
| 79542 | 79542 | 115664 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 601x PERU AVE | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6005068.0 | 2092670.0 | 37.726360298316294 | -122.42467972288401 | (37.7263602983163, -122.424679722884) | ||||
| 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) | ||||
| 81845 | 81845 | 113126 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 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) | ||||
| 82109 | 82109 | 105208 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2694 47TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 5981878.3 | 2096771.8 | 37.736285749950206 | -122.50514791128201 | (37.7362857499502, -122.505147911282) | ||||||
| 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) | ||||
| 82433 | 82433 | 111159 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201x EUGENIA AVE | 6 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6006591.0 | 2098138.0 | 37.7414601197382 | -122.419802596536 | (37.7414601197382, -122.419802596536) | ||||
| 82974 | 82974 | 113119 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 82981 | 82981 | 110866 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 INDIANA ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 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) | |||
| 87112 | 87112 | 108316 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1795 Lincoln Way | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5990313.88148 | 2107203.45347 | 37.765421057721795 | -122.476744840008 | (37.7654210577218, -122.476744840008) | |||||
| 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) | ||||
| 87282 | 87282 | 111156 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201x EUGENIA AVE | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6006591.0 | 2098138.0 | 37.7414601197382 | -122.419802596536 | (37.7414601197382, -122.419802596536) | ||||
| 87416 | 87416 | 108318 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1795 Lincoln Way | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5990313.88148 | 2107203.45347 | 37.765421057721795 | -122.476744840008 | (37.7654210577218, -122.476744840008) | |||||
| 87538 | 87538 | 97027 | Property Tree 7 | Myoporum laetum :: Myoporum 1 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 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) | ||||
| 88545 | 88545 | 113118 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 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) |
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");