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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81019 | 81019 | 112013 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 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) | |||
| 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) | ||||||
| 82492 | 82492 | 112009 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 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) | |||||
| 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) | |||
| 83540 | 83540 | 111656 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1740 CESAR CHAVEZ ST | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 6014066.0 | 2101066.0 | 37.749918058990104 | -122.394161367931 | (37.7499180589901, -122.394161367931) | |||
| 84128 | 84128 | 112015 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 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) | |||
| 85087 | 85087 | 111629 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 200 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | 5999893.57375842 | 2109179.37340811 | 37.7713974526383 | -122.443752960181 | (37.7713974526383, -122.443752960181) | |||
| 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) | ||||||
| 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) | ||||
| 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) | |||||
| 88289 | 88289 | 61437 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 788 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2016 12:00:00 AM | 3 | Permit Number 778418 | 5993530.07441 | 2110197.53457 | 37.7738280413865 | -122.46583842282101 | (37.7738280413865, -122.465838422821) | ||
| 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) | |||||
| 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) | |||
| 90475 | 90475 | 112007 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 92138 | 92138 | 101902 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1100 Ocean Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 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) | ||
| 93352 | 93352 | 112398 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 246 CRESCENT AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6006552.0 | 2095759.0 | 37.7349257177289 | -122.419768681192 | (37.7349257177289, -122.419768681192) | |||||
| 93993 | 93993 | 112012 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 94216 | 94216 | 100680 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 387 Beacon St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 7' wide public RoW | 6002378.0 | 2098199.0 | 37.7413893731095 | -122.434374040118 | (37.7413893731095, -122.434374040118) | |||||
| 94966 | 94966 | 113130 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 95231 | 95231 | 113127 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 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) | |||||
| 95977 | 95977 | 112005 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 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) | |||
| 96677 | 96677 | 111660 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1740 CESAR CHAVEZ ST | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 6014066.0 | 2101066.0 | 37.749918058990104 | -122.394161367931 | (37.7499180589901, -122.394161367931) | |||
| 96955 | 96955 | 41426 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3901 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 42033 | 6003639.60917921 | 2104762.31302618 | 37.759482223502395 | -122.430480029002 | (37.7594822235024, -122.430480029002) | ||
| 98813 | 98813 | 106448 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 999 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002658.0 | 2110219.0 | 37.7744092970816 | -122.43426502395701 | (37.7744092970816, -122.434265023957) | |||||
| 99055 | 99055 | 98374 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 106 De Soto St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993231.0 | 2091825.0 | 37.7233644995117 | -122.465537980019 | (37.7233644995117, -122.465537980019) | |||||
| 100025 | 100025 | 121675 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992325.42312898 | 2094471.30725357 | 37.7305783328736 | -122.46886084210199 | (37.7305783328736, -122.468860842102) | |||||
| 100041 | 100041 | 113128 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 100581 | 100581 | 108317 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1795 Lincoln Way | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5990313.88148 | 2107203.45347 | 37.765421057721795 | -122.476744840008 | (37.7654210577218, -122.476744840008) | |||||
| 100877 | 100877 | 34518 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 201 Stillings Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38229 | 5999437.15230869 | 2095745.6775321 | 37.7344857636851 | -122.44436616674601 | (37.7344857636851, -122.444366166746) | |||
| 101700 | 101700 | 86749 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 81 Parker Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49713 | 5996801.8 | 2114038.7 | 37.7845630578844 | -122.454798641129 | (37.7845630578844, -122.454798641129) | |||||
| 102210 | 102210 | 100310 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3899 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5996194.7 | 2115482.8 | 37.7884933268854 | -122.457003479054 | (37.7884933268854, -122.457003479054) | |||||
| 102326 | 102326 | 104898 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 310 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 102722 | 102722 | 95195 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 254 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 01/14/2011 12:00:00 AM | Permit Number 767109 | 5986864.6 | 2114238.7 | 37.7845371806063 | -122.489192237355 | (37.7845371806063, -122.489192237355) | |||
| 102950 | 102950 | 105540 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2694 47TH AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5981878.3 | 2096771.8 | 37.736285749950206 | -122.50514791128201 | (37.7362857499502, -122.505147911282) | ||||
| 103516 | 103516 | 111419 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200x SAN MARCOS AVE | 4 | Median : Yard 3 | Tree 1 | Private 1 | 10 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
| 103613 | 103613 | 34289 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2715 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38080 | 5987074.67438797 | 2114433.79174181 | 37.7850851064396 | -122.488479804204 | (37.7850851064396, -122.488479804204) | ||
| 103706 | 103706 | 34223 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4353 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1997 12:00:00 AM | Permit Number 38036 | 6001597.05586573 | 2101140.27274833 | 37.7494210542971 | -122.43728482259199 | (37.7494210542971, -122.437284822592) | |||
| 104528 | 104528 | 39968 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 20 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41229 | 5994642.74946915 | 2095844.31987513 | 37.7344818986137 | -122.460949031683 | (37.7344818986137, -122.460949031683) | |||
| 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) | ||||
| 105502 | 105502 | 98375 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 106 De Soto St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993231.0 | 2091825.0 | 37.7233644995117 | -122.465537980019 | (37.7233644995117, -122.465537980019) | |||||
| 106220 | 106220 | 102130 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 33 Topaz Way | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Permit Number 769641 | 6001571.9 | 2098568.0 | 37.7423567715609 | -122.437187662125 | (37.7423567715609, -122.437187662125) | |||
| 106527 | 106527 | 93736 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999812.1 | 2109210.9 | 37.771479369328205 | -122.44403704657 | (37.7714793693282, -122.44403704657) | |||||
| 106585 | 106585 | 111654 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1740 CESAR CHAVEZ ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 6014066.0 | 2101066.0 | 37.749918058990104 | -122.394161367931 | (37.7499180589901, -122.394161367931) | |||
| 106681 | 106681 | 97654 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2331 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5981707.8 | 2099208.6 | 37.7429664967596 | -122.505917998204 | (37.7429664967596, -122.505917998204) | |||||
| 106817 | 106817 | 55765 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1932 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1973 12:00:00 AM | Permit Number 11801 | 5989775.56943078 | 2106540.70455177 | 37.7635700889575 | -122.478558247096 | (37.7635700889575, -122.478558247096) | |||
| 107126 | 107126 | 85498 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1 Nebraska St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 108027 | 108027 | 54458 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4235 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1972 12:00:00 AM | Permit Number 10249 | 6001672.30868862 | 2101726.83398167 | 37.751035889282 | -122.437066586385 | (37.751035889282, -122.437066586385) | |||
| 108150 | 108150 | 52738 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 4 | 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) | |||
| 108792 | 108792 | 52088 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 533 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48285 | 6003018.90245389 | 2105154.15611633 | 37.7605229492534 | -122.432654727925 | (37.7605229492534, -122.432654727925) | ||||
| 109051 | 109051 | 33491 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 29 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2007 12:00:00 AM | Permit Number 49655 | 6006996.29665496 | 2099574.0262700003 | 37.7454259501675 | -122.418503020578 | (37.7454259501675, -122.418503020578) | |||
| 109409 | 109409 | 32427 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1901 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1996 12:00:00 AM | Permit Number 36954 | 6003387.68416895 | 2115217.90617727 | 37.7881764318356 | -122.432097963893 | (37.7881764318356, -122.432097963893) | |||
| 109421 | 109421 | 194074 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2235 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | 6011541.53422 | 2097819.64053 | 37.7408636163769 | -122.40266287538999 | (37.7408636163769, -122.40266287539) | ||||
| 109527 | 109527 | 41271 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 229 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41954 | 5994679.37055115 | 2091871.07942789 | 37.723574453453494 | -122.460534605902 | (37.7235744534535, -122.460534605902) | |||
| 109657 | 109657 | 98303 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 6 Locksley Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994194.0 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | |||||
| 109788 | 109788 | 113131 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 109839 | 109839 | 113123 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 110440 | 110440 | 111631 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 200 Central Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | 5999893.57375842 | 2109179.37340811 | 37.7713974526383 | -122.443752960181 | (37.7713974526383, -122.443752960181) | |||
| 110464 | 110464 | 51814 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 266 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | Permit Number 48060 | 5994901.32061156 | 2096492.00794019 | 37.736275166275796 | -122.460101979176 | (37.7362751662758, -122.460101979176) | |||
| 110927 | 110927 | 52190 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 71 Eagle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48381 | 5999969.39262726 | 2104422.33072392 | 37.758340122613795 | -122.44314899255 | (37.7583401226138, -122.44314899255) | ||||
| 111980 | 111980 | 100294 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1482 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994335.4 | 2105438.4 | 37.760807128362 | -122.46270738304199 | (37.760807128362, -122.462707383042) | |||||
| 112222 | 112222 | 111655 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1740 CESAR CHAVEZ ST | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 6014066.0 | 2101066.0 | 37.749918058990104 | -122.394161367931 | (37.7499180589901, -122.394161367931) | |||
| 112509 | 112509 | 111420 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200x SAN MARCOS AVE | 5 | Median : Yard 3 | Tree 1 | Private 1 | 15 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
| 113123 | 113123 | 49092 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 101 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46240 | 6005012.04174128 | 2092633.4383737 | 37.7262567475706 | -122.424870568097 | (37.7262567475706, -122.424870568097) | ||||
| 113184 | 113184 | 40561 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 25 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1999 12:00:00 AM | Permit Number 41605 | 6002662.09875993 | 2105750.86481793 | 37.7621411257649 | -122.43393140036699 | (37.7621411257649, -122.433931400367) | |||
| 113608 | 113608 | 51648 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1430 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47932 | 5999618.72813404 | 2107626.34389142 | 37.7671175447299 | -122.444592021369 | (37.7671175447299, -122.444592021369) | |||
| 113702 | 113702 | 112010 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 113873 | 113873 | 61358 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1029 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1984 12:00:00 AM | Permit Number 21266 | 6001344.49519126 | 2100781.43952904 | 37.7484214231354 | -122.438132480542 | (37.7484214231354, -122.438132480542) | |||
| 114027 | 114027 | 52737 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 5 | 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) | |||
| 115297 | 115297 | 86750 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 81 Parker Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49713 | 5996801.8 | 2114038.7 | 37.7845630578844 | -122.454798641129 | (37.7845630578844, -122.454798641129) | |||||
| 116224 | 116224 | 53992 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | Permit Number 9709 | 5992325.42312898 | 2094471.30725357 | 37.7305783328736 | -122.46886084210199 | (37.7305783328736, -122.468860842102) | |||
| 116320 | 116320 | 49878 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 511@ PAGE Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2003 12:00:00 AM | Permit Number 46644 | 5998896.54514998 | 2108984.87658964 | 37.77080649578671 | -122.44718771644301 | (37.7708064957867, -122.447187716443) | |||
| 117009 | 117009 | 112004 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 117353 | 117353 | 108117 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 148 28TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5987142.8 | 2114987.8 | 37.786610228944504 | -122.488284841308 | (37.7866102289445, -122.488284841308) | |||||
| 117949 | 117949 | 98373 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 701@ de Soto Urbano Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993201.0 | 2091808.0 | 37.7233160913053 | -122.46564044909799 | (37.7233160913053, -122.465640449098) | |||||
| 117957 | 117957 | 98300 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 6 Locksley Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994194.0 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | |||||
| 118620 | 118620 | 104908 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 500 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 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) | ||||
| 119719 | 119719 | 85507 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1 Nebraska St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 119856 | 119856 | 85365 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 66 Clarendon Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/17/2007 12:00:00 AM | Permit Number 49641 | 5997837.8 | 2104660.2 | 37.758871479144396 | -122.45053809231199 | (37.7588714791444, -122.450538092312) | |||
| 119890 | 119890 | 43991 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 141 Hampshire St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | Permit Number 43551 | 6009974.46243584 | 2107504.86062599 | 37.767369454596 | -122.408764367283 | (37.767369454596, -122.408764367283) | |||
| 120273 | 120273 | 113891 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x STORRIE ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 12 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | ||||
| 120329 | 120329 | 113129 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 120984 | 120984 | 108301 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2898 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 773671 | 6000896.59861 | 2115909.1323 | 37.7899328124933 | -122.440766276199 | (37.7899328124933, -122.440766276199) | ||||
| 121140 | 121140 | 112006 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) |
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");