Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 649 | 649 | 96374 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1315 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008916.2106800005 | 2117429.1962900003 | 37.7945599836999 | -122.41312655846599 | (37.7945599836999, -122.413126558466) | |
| 3846 | 3846 | 239484 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 725 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2017 12:00:00 AM | 8 | Width 3ft | Permit Number 779370 | 6007401.15098 | 2095467.39415 | 37.7341728312175 | -122.416812207728 | (37.7341728312175, -122.416812207728) | |
| 4533 | 4533 | 214732 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994886.41967 | 2092806.74885 | 37.7261554857857 | -122.459886624766 | (37.7261554857857, -122.459886624766) | |
| 4537 | 4537 | 214730 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994894.76005 | 2092775.8058599997 | 37.7260710034609 | -122.459855552309 | (37.7260710034609, -122.459855552309) | |
| 4542 | 4542 | 214731 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994889.57203 | 2092796.33348 | 37.7261270689877 | -122.459874973176 | (37.7261270689877, -122.459874973176) | |
| 6734 | 6734 | 96373 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1315 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008912.46348 | 2117456.9297 | 37.7946359224745 | -122.41314148629499 | (37.7946359224745, -122.413141486295) | |
| 11353 | 11353 | 28245 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3312 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2002 12:00:00 AM | 8 | 2X3 | 6011933.46331 | 2090279.87862 | 37.7201828704297 | -122.40077815269899 | (37.7201828704297, -122.400778152699) | ||
| 12009 | 12009 | 28254 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3410 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2002 12:00:00 AM | 8 | 3X3 | 6012011.64722 | 2089824.91922 | 37.7189380045612 | -122.400475954423 | (37.7189380045612, -122.400475954423) | ||
| 12039 | 12039 | 28243 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3230 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/2004 12:00:00 AM | 8 | 2X3 | 6011870.75873 | 2090643.72462 | 37.7211784199346 | -122.401020454343 | (37.7211784199346, -122.401020454343) | ||
| 12648 | 12648 | 1088 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2222 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 8 | 3X3 | 5999676.1210900005 | 2089518.7544200001 | 37.717401703502205 | -122.443092918703 | (37.7174017035022, -122.443092918703) | ||
| 12882 | 12882 | 62704 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 251 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1986 12:00:00 AM | 8 | 3x3 | Permit Number 23044 | 5999960.32769 | 2091545.33962 | 37.7229824455563 | -122.442255952067 | (37.7229824455563, -122.442255952067) | |
| 12903 | 12903 | 28302 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3410 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6012014.9954 | 2089805.7813099998 | 37.7188856424495 | -122.40046303743799 | (37.7188856424495, -122.400463037438) | |||
| 13073 | 13073 | 28301 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3336 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2003 12:00:00 AM | 8 | 3X3 | 6011974.103080001 | 2090046.14983 | 37.719543365213 | -122.400621263274 | (37.719543365213, -122.400621263274) | ||
| 16945 | 16945 | 27513 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2001 12:00:00 AM | 8 | 3X3 | 6005754.33518 | 2101803.9188099997 | 37.751478728181795 | -122.422955987444 | (37.7514787281818, -122.422955987444) | ||
| 17483 | 17483 | 27512 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005753.54797 | 2101830.48031 | 37.75155161552 | -122.422960597352 | (37.75155161552, -122.422960597352) | ||
| 17628 | 17628 | 27516 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005758.28533 | 2101749.6847900003 | 37.75133003695179 | -122.422938473144 | (37.7513300369518, -122.422938473144) | ||
| 18229 | 18229 | 27514 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005755.80226 | 2101784.51034 | 37.7514255197779 | -122.422949534811 | (37.7514255197779, -122.422949534811) | ||
| 19226 | 19226 | 30599 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 8 | 5x7 | Permit Number 34566 | 6004311.30995 | 2108965.65965 | 37.771061631219 | -122.428456559416 | (37.771061631219, -122.428456559416) |
| 20572 | 20572 | 27519 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005760.41969 | 2101697.87743 | 37.751187906306896 | -122.42292741057 | (37.7511879063069, -122.42292741057) | ||
| 21098 | 21098 | 10199 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X2 | 6005752.31611 | 2101874.30524 | 37.7516718791661 | -122.42296797178801 | (37.7516718791661, -122.422967971788) | |||
| 21630 | 21630 | 26477 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 112 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2001 12:00:00 AM | 8 | 3x3 | 6001287.0278199995 | 2098748.5722 | 37.742836382684295 | -122.438185594392 | (37.7428363826843, -122.438185594392) | ||
| 21994 | 21994 | 27517 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005756.59865 | 2101732.46517 | 37.7512826606677 | -122.422943082157 | (37.7512826606677, -122.422943082157) | ||
| 23387 | 23387 | 213501 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 787 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994873.7468 | 2093233.8423799998 | 37.7273274525845 | -122.459961359351 | (37.7273274525845, -122.459961359351) | |||
| 24585 | 24585 | 49743 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 114 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 8 | Permit Number 46542 | 6010621.23603 | 2087831.01483 | 37.7133855110935 | -122.405141759495 | (37.7133855110935, -122.405141759495) | |
| 24980 | 24980 | 213333 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991918.76578 | 2089524.2789200002 | 37.7169715101175 | -122.469906655166 | (37.7169715101175, -122.469906655166) | |||
| 25078 | 25078 | 238351 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 737 Sanchez St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6003693.255030001 | 2104105.37257 | 37.7576814602529 | -122.43024762673001 | (37.7576814602529, -122.43024762673) | |||
| 25256 | 25256 | 238433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Corbett Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 5999629.6727599995 | 2105348.1757099996 | 37.7608628875441 | -122.444390425487 | (37.7608628875441, -122.444390425487) | |||
| 25464 | 25464 | 213655 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 16 Edgehill Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994743.32278 | 2099041.60515 | 37.7432666390437 | -122.460832960696 | (37.7432666390437, -122.460832960696) | |||
| 26032 | 26032 | 48415 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2475 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 8 | Permit Number 45793 | 6001140.73556 | 2118622.32163 | 37.797396422056295 | -122.440116223893 | (37.7973964220563, -122.440116223893) | |
| 26096 | 26096 | 237169 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3288 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009012.45876 | 2099552.61688 | 37.745480461461796 | -122.41152991648998 | (37.7454804614618, -122.41152991649) | |||
| 26957 | 26957 | 135923 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 299 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001988.80401 | 2118923.8728 | 37.7982726468322 | -122.43720329460501 | (37.7982726468322, -122.437203294605) | |||
| 27459 | 27459 | 213462 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 314 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993067.05595 | 2099698.4128799997 | 37.7449734740606 | -122.46667673826201 | (37.7449734740606, -122.466676738262) | |||
| 27620 | 27620 | 237378 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 979 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009172.53349 | 2103497.3298400003 | 37.756320741037506 | -122.411255009913 | (37.7563207410375, -122.411255009913) | |||
| 28053 | 28053 | 237240 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997785.09075 | 2104911.6741400003 | 37.759558947007605 | -122.45073851589198 | (37.7595589470076, -122.450738515892) | |||
| 28238 | 28238 | 238269 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4102 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002324.68279 | 2104735.52248 | 37.759334087708396 | -122.43502577154301 | (37.7593340877084, -122.435025771543) | |||
| 28887 | 28887 | 84197 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 551 Sawyer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50697 | 6007614.52495 | 2086883.3270299998 | 37.7106148095844 | -122.41546698201 | (37.7106148095844, -122.41546698201) | |
| 29081 | 29081 | 213477 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 240 San Fernando Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992115.588269999 | 2095197.1132200002 | 37.7325590895214 | -122.46963908349899 | (37.7325590895214, -122.469639083499) | |||
| 29095 | 29095 | 218241 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 329 Wawona St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 5992046.53731 | 2097216.7007400002 | 37.7381003774208 | -122.470024807225 | (37.7381003774208, -122.470024807225) | |||
| 29866 | 29866 | 238523 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 124 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002701.22767 | 2096788.6026400002 | 37.7375350896745 | -122.43315568259199 | (37.7375350896745, -122.433155682592) | |||
| 30317 | 30317 | 213584 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 Montecito Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996668.25598 | 2094583.6155700001 | 37.7311366516249 | -122.45385521265301 | (37.7311366516249, -122.453855212653) | |||
| 30718 | 30718 | 238270 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4102 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002298.332 | 2104734.4029099997 | 37.7593295173753 | -122.43511682520399 | (37.7593295173753, -122.435116825204) | |||
| 31288 | 31288 | 49149 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2721 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2003 12:00:00 AM | 8 | Permit Number 46272 | 6001579.27273 | 2117782.40416 | 37.7951151846669 | -122.43853856390301 | (37.7951151846669, -122.438538563903) | ||
| 32123 | 32123 | 238182 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1305 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002572.19519 | 2101717.4702 | 37.7510612880479 | -122.43395402248699 | (37.7510612880479, -122.433954022487) | |||
| 32395 | 32395 | 238175 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4045 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002888.82693 | 2101799.2842 | 37.751303893668705 | -122.432864922793 | (37.7513038936687, -122.432864922793) | |||
| 32586 | 32586 | 214733 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995184.64943 | 2092735.3524200001 | 37.7259765953253 | -122.45885050145701 | (37.7259765953253, -122.458850501457) | |||
| 32614 | 32614 | 213347 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 529 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5993232.83209 | 2090695.6130099997 | 37.7202635827786 | -122.465449643 | (37.7202635827786, -122.465449643) | |||
| 32717 | 32717 | 238069 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 319 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006950.62768 | 2096574.68335 | 37.737187852424796 | -122.418448301161 | (37.7371878524248, -122.418448301161) | |||
| 33130 | 33130 | 237129 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1050 York St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009970.37435 | 2102983.71181 | 37.7549551744519 | -122.408459559056 | (37.7549551744519, -122.408459559056) | |||
| 33370 | 33370 | 237351 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3198 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008523.191869999 | 2100617.92059 | 37.7483780923826 | -122.413297051018 | (37.7483780923826, -122.413297051018) | |||
| 34721 | 34721 | 237103 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3445 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6005888.26667 | 2106058.31953 | 37.763167877818205 | -122.422795155399 | (37.7631678778182, -122.422795155399) | |||
| 35197 | 35197 | 238210 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3715 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003614.081590001 | 2103008.39668 | 37.7546649398446 | -122.430443172631 | (37.7546649398446, -122.430443172631) | |||
| 35216 | 35216 | 135924 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 273 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002069.33792 | 2118935.23427 | 37.7983084200504 | -122.436925437376 | (37.7983084200504, -122.436925437376) | |||
| 35644 | 35644 | 239449 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 49 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002646.1476 | 2095522.1771900002 | 37.734054651307794 | -122.43325565485 | (37.7340546513078, -122.43325565485) | |||
| 35919 | 35919 | 213457 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993075.78823 | 2099665.10758 | 37.7448825301024 | -122.466644123432 | (37.7448825301024, -122.466644123432) | |||
| 36253 | 36253 | 46768 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 39 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 8 | Permit Number 44864 | 6002453.43832 | 2093143.7233900002 | 37.7275130240946 | -122.433751972693 | (37.7275130240946, -122.433751972693) | |
| 36502 | 36502 | 214815 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 655 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5997076.755580001 | 2094378.60032 | 37.73059714113489 | -122.452428176541 | (37.7305971411349, -122.452428176541) | |||
| 36765 | 36765 | 179054 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Santa Ysabel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000895.42593 | 2093107.17468 | 37.7273241385819 | -122.439135400803 | (37.7273241385819, -122.439135400803) | |||
| 37234 | 37234 | 214686 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2624 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992129.357580001 | 2097425.2712 | 37.738677846497396 | -122.469753639146 | (37.7386778464974, -122.469753639146) | |||
| 38676 | 38676 | 179059 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 329 Santa Rosa Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000540.14475 | 2093725.6550599998 | 37.729002120636295 | -122.440407941486 | (37.7290021206363, -122.440407941486) | |||
| 39923 | 39923 | 238083 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 199 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008630.1472 | 2098081.04423 | 37.7414183955492 | -122.412747878228 | (37.7414183955492, -122.412747878228) | |||
| 40170 | 40170 | 213651 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Edgehill Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994859.86261 | 2099088.6488 | 37.743402514010704 | -122.460433407183 | (37.7434025140107, -122.460433407183) | |||
| 40502 | 40502 | 38237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Langton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 8 | Permit Number 40353 | 6010112.774540001 | 2110816.57283 | 37.776470395916796 | -122.408519597801 | (37.7764703959168, -122.408519597801) | ||
| 40582 | 40582 | 238263 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4072 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002561.957830001 | 2104751.42418 | 37.7593912198459 | -122.43420629669599 | (37.7593912198459, -122.434206296696) | |||
| 41345 | 41345 | 213459 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 331 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5992964.35444 | 2099654.10226 | 37.7448458809298 | -122.467028637559 | (37.7448458809298, -122.467028637559) | |||
| 41435 | 41435 | 44490 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 49 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 8 | Permit Number 43795 | 6005454.79601 | 2093298.7109 | 37.728108438248704 | -122.423387260924 | (37.7281084382487, -122.423387260924) | |
| 41870 | 41870 | 238456 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82 Carmelita St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002619.45981 | 2108763.39436 | 37.770410376359 | -122.43429425487899 | (37.770410376359, -122.434294254879) | |||
| 42067 | 42067 | 213594 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2086 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993216.27549 | 2101282.1093200003 | 37.749330511306205 | -122.466275841157 | (37.7493305113062, -122.466275841157) | |||
| 42262 | 42262 | 214783 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 984 Portola Dr | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5996077.08302 | 2098544.42751 | 37.7419781641671 | -122.456185254462 | (37.7419781641671, -122.456185254462) | |||
| 42381 | 42381 | 214725 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995169.64109 | 2092461.80365 | 37.7252246334854 | -122.458882587469 | (37.7252246334854, -122.458882587469) | |||
| 42559 | 42559 | 237380 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 937 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009162.70546 | 2103687.8763099997 | 37.7568433874198 | -122.41130245906601 | (37.7568433874198, -122.411302459066) | |||
| 43390 | 43390 | 239508 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008645.57123 | 2097204.44722 | 37.7390123178534 | -122.412632593227 | (37.7390123178534, -122.412632593227) | |||
| 44808 | 44808 | 213630 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Reposa Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997903.821330001 | 2097994.0573400003 | 37.740571670359294 | -122.449829354368 | (37.7405716703593, -122.449829354368) | |||
| 45961 | 45961 | 213699 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 62 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999655.47058 | 2093801.73285 | 37.7291606000606 | -122.44347177969802 | (37.7291606000606, -122.443471779698) | |||
| 46495 | 46495 | 213405 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2291 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991470.93113 | 2099841.87305 | 37.7452751372339 | -122.47220625042802 | (37.7452751372339, -122.472206250428) | |||
| 47141 | 47141 | 213471 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 390 Magellan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993863.77689 | 2099599.9221099997 | 37.744748989783 | -122.463914695418 | (37.744748989783, -122.463914695418) | |||
| 47569 | 47569 | 179024 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 947 Olmstead St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008925.8511 | 2090372.5517900002 | 37.7202691181059 | -122.411181045172 | (37.7202691181059, -122.411181045172) | |||
| 47808 | 47808 | 214592 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1355 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993614.672730001 | 2106263.3144900003 | 37.7630305927228 | -122.465259958904 | (37.7630305927228, -122.465259958904) | |||
| 50539 | 50539 | 238409 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 209 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000055.039469999 | 2105629.0572200003 | 37.761658379262705 | -122.442939445802 | (37.7616583792627, -122.442939445802) | |||
| 50683 | 50683 | 237197 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 289 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004694.44371 | 2098975.373 | 37.743652330405396 | -122.426419845916 | (37.7436523304054, -122.426419845916) | |||
| 50853 | 50853 | 38717 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 458 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40620 | 5994382.59481 | 2112404.76272 | 37.779937641475705 | -122.463049617411 | (37.7799376414757, -122.463049617411) | ||
| 51040 | 51040 | 80385 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1754 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 8 | 6011729.10125 | 2092748.5600299998 | 37.7269499630479 | -122.40165799273599 | (37.7269499630479, -122.401657992736) | ||
| 51525 | 51525 | 33649 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 541 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 8 | Permit Number 37740 | 6004806.91261 | 2110706.66354 | 37.775870037302106 | -122.426866263978 | (37.7758700373021, -122.426866263978) | ||
| 52335 | 52335 | 135946 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 33 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001854.08706 | 2120729.8042200003 | 37.803223599954705 | -122.437798867946 | (37.8032235999547, -122.437798867946) | |||
| 52784 | 52784 | 214595 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1392 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993365.23899 | 2106030.71085 | 37.76237753652379 | -122.466105754188 | (37.7623775365238, -122.466105754188) | |||
| 52861 | 52861 | 238375 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 587 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002532.66014 | 2103828.3416 | 37.7568549940812 | -122.434241630147 | (37.7568549940812, -122.434241630147) | |||
| 53578 | 53578 | 237017 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 401 Lily St | 7 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6004569.305 | 2109982.95925 | 37.77386948462421 | -122.42763663674299 | (37.7738694846242, -122.427636636743) | |||
| 53692 | 53692 | 238068 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 303 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006931.4487 | 2096577.7659200002 | 37.73719523678071 | -122.41851483031701 | (37.7371952367807, -122.418514830317) | |||
| 53714 | 53714 | 238314 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 45 Eagle St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000118.88808 | 2104341.86796 | 37.7581277146448 | -122.44262619575001 | (37.7581277146448, -122.44262619575) | |||
| 53850 | 53850 | 238294 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4510 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001025.78237 | 2105254.1129099997 | 37.7606841715574 | -122.43955516745199 | (37.7606841715574, -122.439555167452) | |||
| 54133 | 54133 | 213695 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 231 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998737.63514 | 2093659.6015599999 | 37.728717954649504 | -122.446634578437 | (37.7287179546495, -122.446634578437) | |||
| 54230 | 54230 | 34485 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 851 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 8 | Permit Number 38211 | 6008882.966680001 | 2119355.1714 | 37.799846369579704 | -122.41337785691299 | (37.7998463695797, -122.413377856913) | |
| 54523 | 54523 | 31006 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 8 | Permit Number 34780 | 6000669.33593 | 2088075.8661099998 | 37.713496437089894 | -122.43955646516599 | (37.7134964370899, -122.439556465166) | |
| 54921 | 54921 | 213635 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 583 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996825.88745 | 2094091.1401400003 | 37.729793468270394 | -122.453274715555 | (37.7297934682704, -122.453274715555) | |||
| 54958 | 54958 | 238113 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 503 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006831.286280001 | 2100790.86095 | 37.7487578122252 | -122.41915989962601 | (37.7487578122252, -122.419159899626) | |||
| 55027 | 55027 | 239461 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5725 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6000723.2907 | 2097082.5930400002 | 37.7382299184717 | -122.44001540269 | (37.7382299184717, -122.44001540269) | |||
| 56005 | 56005 | 213450 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993181.54452 | 2099646.75602 | 37.744838243897206 | -122.46627710741801 | (37.7448382438972, -122.466277107418) | |||
| 56129 | 56129 | 238362 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 309 Cumberland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003602.3920599995 | 2104471.36589 | 37.758681243751504 | -122.43058798325899 | (37.7586812437515, -122.430587983259) | |||
| 56536 | 56536 | 68520 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 643 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32400 | 5995312.0360199995 | 2111170.0323400004 | 37.77660089482001 | -122.45974482687402 | (37.77660089482, -122.459744826874) | |
| 57314 | 57314 | 214586 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Lurline St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991797.242819999 | 2105160.13834 | 37.759896587568896 | -122.471465380821 | (37.7598965875689, -122.471465380821) | |||
| 57461 | 57461 | 238344 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 213 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002080.48499 | 2104602.09911 | 37.7589538705354 | -122.43586077857701 | (37.7589538705354, -122.435860778577) |
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");