Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30074 | 30074 | 47440 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 859 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45351 | 5982914.18523 | 2109947.95579 | 37.7725246733221 | -122.50254141771099 | (37.7725246733221, -122.502541417711) | |
| 153533 | 153533 | 117710 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 477 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5983117.17834 | 2112671.33055 | 37.7800141944428 | -122.502040811752 | (37.7800141944428, -122.502040811752) | |||
| 24823 | 24823 | 47425 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 754 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45336 | 5984176.15569 | 2110679.3098400002 | 37.7746068364777 | -122.49823022658701 | (37.7746068364777, -122.498230226587) | |
| 32455 | 32455 | 118090 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6909 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5985513.83516 | 2112457.38253 | 37.779567259959 | -122.493734048085 | (37.779567259959, -122.493734048085) | |||
| 166433 | 166433 | 250875 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986467.14332 | 2114671.0752 | 37.7857011507179 | -122.490599105783 | (37.7857011507179, -122.490599105783) | |||
| 56077 | 56077 | 250876 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 30th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986468.29527 | 2114661.08637 | 37.7856737915584 | -122.490594385245 | (37.7856737915584, -122.490594385245) | |||
| 132130 | 132130 | 250868 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 133 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986468.4993 | 2114649.30576 | 37.7856414573183 | -122.490592812321 | (37.7856414573183, -122.490592812321) | |||
| 71320 | 71320 | 119536 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 871 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5986636.85825 | 2109986.6532900003 | 37.772848973963 | -122.489667337074 | (37.772848973963, -122.489667337074) | |||
| 50848 | 50848 | 50228 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 741 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 5 | Permit Number 46935 | 5987844.86264 | 2110914.45258 | 37.775466905732706 | -122.485556863724 | (37.7754669057327, -122.485556863724) | |
| 169580 | 169580 | 84326 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 728 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53994 | 5987888.08845 | 2110995.2066599997 | 37.7756911522049 | -122.48541326443899 | (37.7756911522049, -122.485413264439) |
| 58542 | 58542 | 43804 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | 6x5 | Permit Number 43434 | 5988398.115730001 | 2114095.5575599996 | 37.7842335442368 | -122.483876359267 | (37.7842335442368, -122.483876359267) |
| 36554 | 36554 | 120353 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2240 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5988483.640819999 | 2114700.0523900003 | 37.7858982939261 | -122.48362481032801 | (37.7858982939261, -122.483624810328) | |||
| 85693 | 85693 | 96953 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2302 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 32951 | 5988418.13148 | 2110571.74898 | 37.7745593211999 | -122.483548684419 | (37.7745593211999, -122.483548684419) | ||
| 112881 | 112881 | 96952 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2302 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 32951 | 5988431.28084 | 2110571.1656 | 37.7745584847462 | -122.483503155986 | (37.7745584847462, -122.483503155986) | ||
| 101603 | 101603 | 68962 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2302 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | 3x3 | Permit Number 32951 | 5988444.16962 | 2110572.72123 | 37.7745635062345 | -122.483458685783 | (37.7745635062345, -122.483458685783) |
| 111406 | 111406 | 27310 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2140 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2014 12:00:00 AM | 5 | 5 | 5988795.04874 | 2114709.3 | 37.7859418063725 | -122.4825481157 | (37.7859418063725, -122.4825481157) | ||
| 112154 | 112154 | 12805 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2099 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2003 12:00:00 AM | 5 | 3X3 | 5989075.33471 | 2114664.85982 | 37.7858360879126 | -122.48157515850401 | (37.7858360879126, -122.481575158504) | ||
| 185776 | 185776 | 50300 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2917 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 5 | Permit Number 47010 | 5989048.80024 | 2095796.1569299998 | 37.7340261814504 | -122.480285417057 | (37.7340261814504, -122.480285417057) | |
| 60427 | 60427 | 88580 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 474 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51522 | 5989397.97956 | 2112106.21746 | 37.778829528805794 | -122.480271570948 | (37.7788295288058, -122.480271570948) | ||
| 41693 | 41693 | 91420 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 770 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52101 | 5990400.3408699995 | 2110139.21584 | 37.7734868781795 | -122.47666030039301 | (37.7734868781795, -122.476660300393) | ||
| 162049 | 162049 | 179042 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2913 20th Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 5990217.2226599995 | 2095888.7019900002 | 37.7343481135815 | -122.476252619576 | (37.7343481135815, -122.476252619576) | |||
| 125051 | 125051 | 45479 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3008 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 5 | Permit Number 44261 | 5990293.0566 | 2095176.19647 | 37.732396152147295 | -122.475938421626 | (37.7323961521473, -122.475938421626) | |
| 131344 | 131344 | 50296 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3052 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 5 | Permit Number 47008 | 5990299.81493 | 2094981.9607400002 | 37.7318632220065 | -122.47590087674101 | (37.7318632220065, -122.475900876741) | |
| 60883 | 60883 | 68231 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 257 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 5 | Permit Number 32026 | 5990849.231930001 | 2113671.85139 | 37.7832125496886 | -122.475365506488 | (37.7832125496886, -122.475365506488) | |
| 26309 | 26309 | 214582 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990775.418980001 | 2105160.42766 | 37.7598382161767 | -122.47499935674 | (37.7598382161767, -122.47499935674) | |||
| 166970 | 166970 | 214482 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1501 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5990834.97468 | 2105131.29032 | 37.7597616641021 | -122.47479125810499 | (37.7597616641021, -122.474791258105) | |||
| 133299 | 133299 | 88377 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 458 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51355 | 5991270.95609 | 2112280.85053 | 37.7794176810179 | -122.47380501423599 | (37.7794176810179, -122.473805014236) | ||
| 171156 | 171156 | 214576 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1433 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991271.06324 | 2106533.25971 | 37.7636363598559 | -122.473385314688 | (37.7636363598559, -122.473385314688) | |||
| 71074 | 71074 | 213427 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2321 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991248.01995 | 2099587.85764 | 37.7445647735558 | -122.47295851264099 | (37.7445647735558, -122.472958512641) | |||
| 67866 | 67866 | 92826 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 755 14th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2009 12:00:00 AM | 5 | 3x3 | Permit Number 53040 | 5991610.35704 | 2110282.0512900003 | 37.7739491753353 | -122.47248513397899 | (37.7739491753353, -122.472485133979) | ||
| 151554 | 151554 | 213415 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2493 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991371.6003 | 2098454.8903099997 | 37.7414610899681 | -122.472448620415 | (37.7414610899681, -122.472448620415) | |||
| 52757 | 52757 | 213426 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2341 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991445.55169 | 2099460.12688 | 37.744225491721295 | -122.472266184835 | (37.7442254917213, -122.472266184835) | |||
| 38909 | 38909 | 213410 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2251 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991507.31959 | 2100089.11073 | 37.745956094003404 | -122.472098444193 | (37.7459560940034, -122.472098444193) | |||
| 46574 | 46574 | 214676 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2690 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991464.73998 | 2097129.41713 | 37.737827068958204 | -122.47202999139499 | (37.7378270689582, -122.472029991395) | |||
| 155902 | 155902 | 123062 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 472 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5991906.84489 | 2112217.36307 | 37.7792801711752 | -122.471600599763 | (37.7792801711752, -122.471600599763) | |||
| 147864 | 147864 | 213441 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2359 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991668.59965 | 2099367.7307599997 | 37.74398470183 | -122.471488209231 | (37.74398470183, -122.471488209231) | |||
| 175566 | 175566 | 214587 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Lurline St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991795.61852 | 2105144.1496 | 37.7598525927434 | -122.47146983337299 | (37.7598525927434, -122.471469833373) | |||
| 37641 | 37641 | 214515 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1203 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992128.70606 | 2106565.35498 | 37.7637741108079 | -122.47042136146601 | (37.7637741108079, -122.470421361466) | |||
| 40352 | 40352 | 214556 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1134 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992207.40042 | 2106631.63575 | 37.763960649997 | -122.47015401102199 | (37.763960649997, -122.470154011022) | |||
| 52601 | 52601 | 218243 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Wawona St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 5992077.34134 | 2097249.8857 | 37.7381932756065 | -122.46992071879299 | (37.7381932756065, -122.469920718793) | |||
| 49382 | 49382 | 214518 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1115 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992295.0711900005 | 2106570.75423 | 37.7637985534841 | -122.469846353829 | (37.7637985534841, -122.469846353829) | |||
| 32294 | 32294 | 213357 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992244.95419 | 2088111.9424400001 | 37.7131124256698 | -122.468676481533 | (37.7131124256698, -122.468676481533) | |||
| 180157 | 180157 | 214624 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1437 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992704.14512 | 2105656.98806 | 37.7613132293559 | -122.468365022027 | (37.7613132293559, -122.468365022027) | |||
| 150602 | 150602 | 214522 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 939 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992798.79184 | 2106588.46836 | 37.763876295380705 | -122.468105441723 | (37.7638762953807, -122.468105441723) | |||
| 163181 | 163181 | 213465 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992622.33383 | 2098106.49157 | 37.7405767874889 | -122.468098715706 | (37.7405767874889, -122.468098715706) | |||
| 151392 | 151392 | 213466 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992628.19492 | 2098122.8504 | 37.7406220431851 | -122.46807964016199 | (37.7406220431851, -122.468079640162) | |||
| 48529 | 48529 | 214705 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 365 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992551.259190001 | 2094363.4412599998 | 37.730295204541704 | -122.46807225674699 | (37.7302952045417, -122.468072256747) | |||
| 56506 | 56506 | 214706 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 365 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992562.58655 | 2094392.71432 | 37.7303762352585 | -122.468035225354 | (37.7303762352585, -122.468035225354) | |||
| 72170 | 72170 | 213468 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 108 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992714.16407 | 2098359.03254 | 37.7412755040554 | -122.467799567899 | (37.7412755040554, -122.467799567899) | |||
| 165821 | 165821 | 214707 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992641.20106 | 2094871.0597299999 | 37.731694192613 | -122.46779822343099 | (37.731694192613, -122.467798223431) | |||
| 63578 | 63578 | 214525 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 907 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992922.76122 | 2106591.1777 | 37.7638908931745 | -122.46767686978701 | (37.7638908931745, -122.467676869787) | |||
| 187309 | 187309 | 214781 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1723 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5992834.3473 | 2095346.2214400002 | 37.733010019498 | -122.467165018866 | (37.733010019498, -122.467165018866) | |||
| 42959 | 42959 | 213345 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 542 Arch St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992754.74517 | 2090800.4755 | 37.7205239248105 | -122.46710983737499 | (37.7205239248105, -122.467109837375) | |||
| 3800 | 3800 | 213446 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993033.55222 | 2099443.36305 | 37.744271238444206 | -122.46677405027799 | (37.7442712384442, -122.466774050278) | |||
| 135808 | 135808 | 213461 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 314 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993060.97049 | 2099698.9583900003 | 37.744974620699 | -122.466697820147 | (37.744974620699, -122.466697820147) | |||
| 45094 | 45094 | 213387 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1818 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993154.76021 | 2103068.62065 | 37.7542322625174 | -122.466618400145 | (37.7542322625174, -122.466618400145) | |||
| 129573 | 129573 | 214713 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 104 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993041.99484 | 2094312.53309 | 37.730183751567004 | -122.466372032662 | (37.730183751567, -122.466372032662) | |||
| 76510 | 76510 | 213388 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 243 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993230.59651 | 2103194.97026 | 37.7545835619962 | -122.466365323719 | (37.7545835619962, -122.466365323719) | |||
| 76200 | 76200 | 214712 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 104 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993048.1007199995 | 2094327.00059 | 37.730223828061206 | -122.46635197506599 | (37.7302238280612, -122.466351975066) | |||
| 58558 | 58558 | 213452 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Dorantes Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993170.15918 | 2099666.95184 | 37.7448930395731 | -122.466317942932 | (37.7448930395731, -122.466317942932) | |||
| 99512 | 99512 | 50872 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 764 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | 5 | 3x3 | Permit Number 47382 | 5993527.27631 | 2110282.90436 | 37.774062282603005 | -122.46585430594101 | (37.774062282603, -122.465854305941) | |
| 159746 | 159746 | 214711 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993359.6935 | 2094710.89058 | 37.7312958694138 | -122.46530264071998 | (37.7312958694138, -122.46530264072) | |||
| 48200 | 48200 | 31194 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 354 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46596 | 5993258.721390001 | 2089558.71458 | 37.7171434272164 | -122.46527761436899 | (37.7171434272164, -122.465277614369) | |
| 186426 | 186426 | 214765 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5993613.7342 | 2101408.96874 | 37.7497017595309 | -122.464910643325 | (37.7497017595309, -122.464910643325) | |||
| 124363 | 124363 | 214772 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 96 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5993626.401000001 | 2101411.46451 | 37.7497093426138 | -122.46486702261801 | (37.7497093426138, -122.464867022618) | |||
| 29824 | 29824 | 214773 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 92 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5993651.47421 | 2101409.8267 | 37.74970629121471 | -122.464780200252 | (37.7497062912147, -122.464780200252) | |||
| 39188 | 39188 | 214537 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 635 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993761.60534 | 2106621.85728 | 37.7640235296755 | -122.464777811668 | (37.7640235296755, -122.464777811668) | |||
| 178931 | 178931 | 214538 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 623 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993805.0623699995 | 2106624.13828 | 37.7640322980823 | -122.464627673449 | (37.7640322980823, -122.464627673449) | |||
| 147151 | 147151 | 213352 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 752 Head St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993533.94375 | 2090828.7779700002 | 37.7206465833581 | -122.464418471345 | (37.7206465833581, -122.464418471345) | |||
| 187534 | 187534 | 213472 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 390 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993869.43858 | 2099604.78571 | 37.744762670277204 | -122.463895471497 | (37.7447626702772, -122.463895471497) | |||
| 33752 | 33752 | 214776 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 36 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5993929.139169999 | 2101136.44437 | 37.7489716575191 | -122.463800191051 | (37.7489716575191, -122.463800191051) | |||
| 41995 | 41995 | 214691 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 369 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5994018.2022 | 2099672.39876 | 37.744956890555 | -122.463385984879 | (37.744956890555, -122.463385984879) | |||
| 169697 | 169697 | 213577 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994569.9735900005 | 2099964.1686400003 | 37.745789791378 | -122.46149922251001 | (37.745789791378, -122.46149922251) | |||
| 57124 | 57124 | 213298 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 769 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5994373.81571 | 2089911.00711 | 37.7181749819741 | -122.461448817305 | (37.7181749819741, -122.461448817305) | |||
| 168464 | 168464 | 213487 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 270 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994647.931480001 | 2100314.84296 | 37.746757141726704 | -122.461255072761 | (37.7467571417267, -122.461255072761) | |||
| 70509 | 70509 | 213291 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 66 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994463.86124 | 2090359.9518 | 37.719412859185795 | -122.461170094944 | (37.7194128591858, -122.461170094944) | |||
| 76930 | 76930 | 213653 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Edgehill Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994833.218169999 | 2099074.30171 | 37.7433615876766 | -122.46052449682699 | (37.7433615876766, -122.460524496827) | |||
| 46384 | 46384 | 214835 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 551 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5994751.30135 | 2092246.5764900001 | 37.7246096159288 | -122.460313148958 | (37.7246096159288, -122.460313148958) | |||
| 135038 | 135038 | 214836 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 551 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5994751.08968 | 2092221.3600299999 | 37.724540365428 | -122.460312054477 | (37.724540365428, -122.460312054477) | |||
| 176349 | 176349 | 213605 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 153 Vasquez Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994959.23188 | 2099490.14718 | 37.7445106442654 | -122.460118897178 | (37.7445106442654, -122.460118897178) | |||
| 131581 | 131581 | 214736 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995136.59009 | 2093647.8547099999 | 37.728479343838394 | -122.459082682125 | (37.7284793438384, -122.459082682125) | |||
| 74234 | 74234 | 214735 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Westwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995155.65804 | 2092771.31144 | 37.72607366365639 | -122.458953324553 | (37.7260736636564, -122.458953324553) | |||
| 135619 | 135619 | 214734 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995175.571830001 | 2092744.7785099999 | 37.7260019553109 | -122.45888256407801 | (37.7260019553109, -122.458882564078) | |||
| 24140 | 24140 | 213364 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1256 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995501.45899 | 2106973.1472099996 | 37.765088237057206 | -122.45878564505101 | (37.7650882370572, -122.458785645051) | |||
| 26947 | 26947 | 213289 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 524 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995193.9429 | 2090587.80207 | 37.720080470027206 | -122.45866297574301 | (37.7200804700272, -122.458662975743) | |||
| 130078 | 130078 | 214794 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 290 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995480.84421 | 2097515.15227 | 37.739117784956605 | -122.458172366777 | (37.7391177849566, -122.458172366777) | |||
| 175579 | 175579 | 64857 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 21 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 5 | Permit Number 25873 | 5995838.9792599995 | 2112526.25675 | 37.780355016559504 | -122.458020161226 | (37.7803550165595, -122.458020161226) | |
| 131282 | 131282 | 213492 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 598 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995442.0885 | 2093284.14 | 37.7274982284469 | -122.45800025452101 | (37.7274982284469, -122.458000254521) | |||
| 48211 | 48211 | 73744 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 5 | 5995854.8721 | 2112478.1679599998 | 37.7802238906314 | -122.45796169978998 | (37.7802238906314, -122.45796169979) | ||
| 44613 | 44613 | 64863 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 77 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 5 | Permit Number 25879 | 5995882.63467 | 2112271.55178 | 37.7796581724444 | -122.45785070123999 | (37.7796581724444, -122.45785070124) | |
| 38174 | 38174 | 214754 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995607.36531 | 2093372.70982 | 37.7277509145579 | -122.457435300396 | (37.7277509145579, -122.457435300396) | |||
| 163704 | 163704 | 214753 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995611.1547 | 2093431.54917 | 37.7279126909161 | -122.457426455583 | (37.7279126909161, -122.457426455583) | |||
| 24527 | 24527 | 214750 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995612.00037 | 2093456.6914400002 | 37.7279817741139 | -122.457425350319 | (37.7279817741139, -122.457425350319) | |||
| 147124 | 147124 | 214745 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995638.20043 | 2093638.9497200001 | 37.728483716343796 | -122.45734795645001 | (37.7284837163438, -122.45734795645) | |||
| 63695 | 63695 | 214742 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 149 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995645.35981 | 2093675.42483 | 37.7285842794183 | -122.457325843925 | (37.7285842794183, -122.457325843925) | |||
| 49020 | 49020 | 213515 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 136 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995664.797590001 | 2093624.26858 | 37.7284449330771 | -122.457254947662 | (37.7284449330771, -122.457254947662) | |||
| 28192 | 28192 | 213505 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 435 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995673.53388 | 2093929.48913 | 37.7292834969286 | -122.457246816911 | (37.7292834969286, -122.457246816911) | |||
| 131800 | 131800 | 213513 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995671.87942 | 2093659.25145 | 37.7285413943492 | -122.457232995212 | (37.7285413943492, -122.457232995212) | |||
| 165023 | 165023 | 213509 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995676.0127 | 2093766.8995400001 | 37.7288372074655 | -122.45722649041402 | (37.7288372074655, -122.457226490414) | |||
| 40048 | 40048 | 214790 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 385 Valdez Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5995727.44967 | 2095481.9792400002 | 37.7335493555041 | -122.45717268576401 | (37.7335493555041, -122.457172685764) |
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");