Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 69640 | 69640 | 213344 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 117 Vernon St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992432.58541 | 2088617.0275700002 | 37.7145101052228 | -122.468064688059 | (37.7145101052228, -122.468064688059) | |||
| 31639 | 31639 | 213343 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 117 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992434.92339 | 2088648.0359 | 37.7145953816368 | -122.468058861341 | (37.7145953816368, -122.468058861341) | |||
| 173982 | 173982 | 213346 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 223 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992956.82489 | 2088699.8094099998 | 37.7147676656708 | -122.466258733373 | (37.7147676656708, -122.466258733373) | |||
| 53955 | 53955 | 213335 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 53 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5991917.8551 | 2088918.99095 | 37.715309483835 | -122.469865758501 | (37.715309483835, -122.469865758501) | |||
| 149456 | 149456 | 213310 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111 Caine Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997269.145819999 | 2089132.21478 | 37.716202819983 | -122.451384810958 | (37.716202819983, -122.451384810958) | |||
| 147069 | 147069 | 213311 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 109 Caine Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997282.73831 | 2089151.44786 | 37.716256407882106 | -122.451339215357 | (37.7162564078821, -122.451339215357) | |||
| 66393 | 66393 | 213312 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 109 Caine Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997293.25449 | 2089167.74263 | 37.716301751698204 | -122.451304041065 | (37.7163017516982, -122.451304041065) | |||
| 180916 | 180916 | 213313 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 109 Caine Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997305.300980001 | 2089185.13122 | 37.7163501865023 | -122.45126365610099 | (37.7163501865023, -122.451263656101) | |||
| 62370 | 62370 | 213314 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 109 Caine Ave | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997314.23204 | 2089197.70588 | 37.716385224975795 | -122.45123369250601 | (37.7163852249758, -122.451233692506) | |||
| 46295 | 46295 | 213353 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 Bright St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993739.98906 | 2089300.2829200001 | 37.7164615783281 | -122.46359536864401 | (37.7164615783281, -122.463595368644) | |||
| 149708 | 149708 | 213331 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 151 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5991924.78555 | 2089552.6251599998 | 37.7170496899626 | -122.469887910591 | (37.7170496899626, -122.469887910591) | |||
| 130595 | 130595 | 213349 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 382 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993261.23034 | 2089739.3179799998 | 37.71763946535779 | -122.465282053445 | (37.7176394653578, -122.465282053445) | |||
| 146887 | 146887 | 213309 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 31 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997387.15624 | 2089756.5855900003 | 37.7179239542144 | -122.45102191023899 | (37.7179239542144, -122.451021910239) | |||
| 164627 | 164627 | 213356 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 128 Shields St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993609.42924 | 2089850.5677200002 | 37.717965004654495 | -122.464086568463 | (37.7179650046545, -122.464086568463) | |||
| 31801 | 31801 | 213330 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 217 Byxbee St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5991929.42464 | 2089936.9124 | 37.7181051172336 | -122.46989983921101 | (37.7181051172336, -122.469899839211) | |||
| 54772 | 54772 | 213329 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 217 Byxbee St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5991930.7925 | 2089955.0472 | 37.718154990039295 | -122.46989643078999 | (37.7181549900393, -122.46989643079) | |||
| 181827 | 181827 | 213350 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 610 Head St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993524.58129 | 2089927.1808799999 | 37.7181704754556 | -122.464385407781 | (37.7181704754556, -122.464385407781) | |||
| 133217 | 133217 | 213328 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 217 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5991931.18505 | 2089973.6935 | 37.7182062109212 | -122.469896430786 | (37.7182062109212, -122.469896430786) | |||
| 147855 | 147855 | 213348 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 438 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993267.15159 | 2090112.97171 | 37.7186657698839 | -122.46528871291599 | (37.7186657698839, -122.465288712916) | |||
| 188763 | 188763 | 213318 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 347 Howth St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997130.27848 | 2090199.39045 | 37.7191250833297 | -122.45194174763 | (37.7191250833297, -122.45194174763) | |||
| 53913 | 53913 | 213317 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 341 Howth St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5997142.77814 | 2090220.59605 | 37.7191840249054 | -122.45190007034401 | (37.7191840249054, -122.451900070344) | |||
| 65836 | 65836 | 213340 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 375 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992193.1878 | 2090324.6899599999 | 37.719185103182895 | -122.469016337141 | (37.7191851031829, -122.469016337141) | |||
| 157491 | 157491 | 213339 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 375 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992194.5826900005 | 2090348.43318 | 37.7192503768696 | -122.46901324258499 | (37.7192503768696, -122.469013242585) | |||
| 146360 | 146360 | 213315 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Howth St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5997161.752669999 | 2090255.4552900002 | 37.7192808270242 | -122.451836996388 | (37.7192808270242, -122.451836996388) | |||
| 28020 | 28020 | 213316 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Howth St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997165.98186 | 2090264.50059 | 37.7193059055324 | -122.451823029928 | (37.7193059055324, -122.451823029928) | |||
| 56569 | 56569 | 213355 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 430 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992826.5059 | 2090512.32679 | 37.7197368804329 | -122.466840849243 | (37.7197368804329, -122.466840849243) | |||
| 53636 | 53636 | 213354 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5993565.63371 | 2090507.60393 | 37.7197665436602 | -122.46428562440701 | (37.7197665436602, -122.464285624407) | |||
| 38693 | 38693 | 213308 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 219 Tara St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997858.51511 | 2090428.8363400002 | 37.719796773473604 | -122.44944104777001 | (37.7197967734736, -122.44944104777) | |||
| 183819 | 183819 | 213307 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 247 Louisburg St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997575.966440001 | 2090467.37945 | 37.7198864367809 | -122.45042049131901 | (37.7198864367809, -122.450420491319) | |||
| 31968 | 31968 | 213326 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 333 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991939.8499300005 | 2090759.9353900002 | 37.7203655398194 | -122.46992369461701 | (37.7203655398194, -122.469923694617) | |||
| 133184 | 133184 | 213342 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 442 Vernon St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5992492.2832 | 2090792.26428 | 37.7204862252464 | -122.468016479897 | (37.7204862252464, -122.468016479897) | |||
| 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) | |||
| 165465 | 165465 | 213351 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 752 Head St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5993534.806030001 | 2090819.23886 | 37.7206204409725 | -122.46441479849899 | (37.7206204409725, -122.464414798499) | |||
| 154951 | 154951 | 213325 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 351 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991942.4704599995 | 2090861.00435 | 37.7206432019019 | -122.46992199131701 | (37.7206432019019, -122.469921991317) | |||
| 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) | |||
| 56542 | 56542 | 213324 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 355 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5991941.51913 | 2090886.05993 | 37.7207119433918 | -122.469927103079 | (37.7207119433918, -122.469927103079) | |||
| 132513 | 132513 | 202042 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Exeter St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012532.81359 | 2090984.9967200002 | 37.7221523937885 | -122.398755844523 | (37.7221523937885, -122.398755844523) | |||
| 30296 | 30296 | 202045 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Exeter St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012584.35783 | 2091031.2434099999 | 37.7222822496095 | -122.39858091108201 | (37.7222822496095, -122.398580911082) | |||
| 146355 | 146355 | 202308 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 178 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6013012.36975 | 2092926.2043 | 37.7275092640335 | -122.39723417993099 | (37.7275092640335, -122.397234179931) | |||
| 170214 | 170214 | 201292 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6012604.14806 | 2093027.6922900002 | 37.7277651940081 | -122.398652533104 | (37.7277651940081, -122.398652533104) | |||
| 157220 | 157220 | 196473 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012815.80377 | 2093626.35145 | 37.729420779337204 | -122.397962808852 | (37.7294207793372, -122.397962808852) | |||
| 53116 | 53116 | 196472 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012828.31305 | 2093641.68277 | 37.7294635726784 | -122.39792063783001 | (37.7294635726784, -122.39792063783) | |||
| 183766 | 183766 | 196475 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 58 Ceres St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013844.58264 | 2093878.5960799998 | 37.730170634955705 | -122.39442385069401 | (37.7301706349557, -122.394423850694) | |||
| 180996 | 180996 | 196474 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 74 Neptune St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013054.126569999 | 2093955.76147 | 37.7303385419805 | -122.39716198774599 | (37.7303385419805, -122.397161987746) | |||
| 152228 | 152228 | 213360 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Elmhurst Dr | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5991212.62572 | 2094437.93395 | 37.7304223444182 | -122.47270547849399 | (37.7304223444182, -122.472705478494) | |||
| 24236 | 24236 | 213361 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Elmhurst Dr | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991216.12738 | 2094471.85178 | 37.730515676960394 | -122.47269584493701 | (37.7305156769604, -122.472695844937) | |||
| 72650 | 72650 | 213363 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 62 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5990931.27665 | 2094545.31392 | 37.7307008923171 | -122.473685962554 | (37.7307008923171, -122.473685962554) | |||
| 56297 | 56297 | 179040 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5989055.545969999 | 2095618.79902 | 37.7335395942586 | -122.480249118621 | (37.7335395942586, -122.480249118621) | |||
| 155549 | 155549 | 179039 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5989055.72291 | 2095627.1595 | 37.7335625602678 | -122.48024911859699 | (37.7335625602678, -122.480249118597) | |||
| 119487 | 119487 | 179038 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5989055.89984 | 2095635.51997 | 37.733585526248795 | -122.480249118607 | (37.7335855262488, -122.480249118607) | |||
| 75532 | 75532 | 179037 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5989055.57419 | 2095644.9365599998 | 37.733611362859605 | -122.480250933435 | (37.7336113628596, -122.480250933435) | |||
| 133641 | 133641 | 196482 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6012916.33928 | 2095157.16046 | 37.733629664074705 | -122.39772257563 | (37.7336296640747, -122.39772257563) | |||
| 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) | |||
| 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) | |||
| 31599 | 31599 | 218216 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Lenox Way | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5993396.63989 | 2098589.94545 | 37.7419489172986 | -122.465456597447 | (37.7419489172986, -122.465456597447) | |||
| 184114 | 184114 | 218215 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 126 Lenox Way | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5993412.17188 | 2098613.00635 | 37.74201313250371 | -122.465404568079 | (37.7420131325037, -122.465404568079) | |||
| 47683 | 47683 | 247785 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 310 30th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004480.1773 | 2098425.89767 | 37.7421314823968 | -122.42712159768101 | (37.7421314823968, -122.427121597681) | |||
| 27319 | 27319 | 246424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 418 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6003710.7768 | 2099847.4001700003 | 37.7459910605319 | -122.429883314964 | (37.7459910605319, -122.429883314964) | |||
| 61043 | 61043 | 246498 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 313 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004359.59327 | 2099835.65026 | 37.745995519392295 | -122.42763895699 | (37.7459955193923, -122.42763895699) | |||
| 25479 | 25479 | 246475 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 318 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004316.48172 | 2099879.2195200003 | 37.7461127118429 | -122.427791134863 | (37.7461127118429, -122.427791134863) | |||
| 66508 | 66508 | 246474 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 312 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004388.68199 | 2099882.3051 | 37.746125268169706 | -122.42754169531601 | (37.7461252681697, -122.427541695316) | |||
| 180388 | 180388 | 246511 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 207 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6005075.21268 | 2099872.36362 | 37.746136778598 | -122.42516705074101 | (37.746136778598, -122.425167050741) | |||
| 31951 | 31951 | 246463 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Duncan St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6005105.34641 | 2099923.38039 | 37.746278561223605 | -122.42506648135 | (37.7462785612236, -122.42506648135) | |||
| 146677 | 146677 | 246461 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Duncan St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6005134.84006 | 2099924.67887 | 37.7462837925778 | -122.424964588148 | (37.7462837925778, -122.424964588148) | |||
| 33154 | 33154 | 196457 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012824.47283 | 2101012.7675799998 | 37.7497028090569 | -122.398450923095 | (37.7497028090569, -122.398450923095) | |||
| 73254 | 73254 | 196456 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 12 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012848.61003 | 2101014.24206 | 37.7497082022719 | -122.39836755861201 | (37.7497082022719, -122.398367558612) | |||
| 167280 | 167280 | 196455 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 11 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012871.437030001 | 2101015.96129 | 37.7497141944763 | -122.39828874203998 | (37.7497141944763, -122.39828874204) | |||
| 153811 | 153811 | 196454 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 10 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012891.82767 | 2101016.42082 | 37.749716592054206 | -122.398218262172 | (37.7497165920542, -122.398218262172) | |||
| 39978 | 39978 | 196453 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 7 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012987.92898 | 2101021.89129 | 37.749736965294794 | -122.39788632150601 | (37.7497369652948, -122.397886321506) | |||
| 56860 | 56860 | 196452 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013266.78575 | 2101037.1874599997 | 37.7497944913407 | -122.396923089148 | (37.7497944913407, -122.396923089148) | |||
| 178948 | 178948 | 196451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013299.05466 | 2101039.80695 | 37.7498034800424 | -122.396811684714 | (37.7498034800424, -122.396811684714) | |||
| 147208 | 147208 | 196450 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013387.24706 | 2101044.34817 | 37.7498208576628 | -122.39650702770001 | (37.7498208576628, -122.3965070277) | |||
| 68445 | 68445 | 196459 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1760 Cesar Chavez St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6013796.36432 | 2101069.01684 | 37.7499113519264 | -122.395093999398 | (37.7499113519264, -122.395093999398) | |||
| 49624 | 49624 | 196458 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1760 Cesar Chavez St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6013820.908980001 | 2101070.2514 | 37.7499161066554 | -122.395009208608 | (37.7499161066554, -122.395009208608) | |||
| 28434 | 28434 | 196463 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Cesar Chavez St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014925.6309 | 2101062.89752 | 37.7499572830217 | -122.39118848116999 | (37.7499572830217, -122.39118848117) | |||
| 68841 | 68841 | 196464 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Cesar Chavez St | 6 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6015016.3527 | 2101061.7401099997 | 37.7499591392145 | -122.390874677125 | (37.7499591392145, -122.390874677125) | |||
| 55544 | 55544 | 196465 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015262.99985 | 2101056.82815 | 37.7499593343528 | -122.39002140848801 | (37.7499593343528, -122.390021408488) | |||
| 171137 | 171137 | 196466 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6015450.2681 | 2101056.0343 | 37.7499675388841 | -122.389373764399 | (37.7499675388841, -122.389373764399) | |||
| 51355 | 51355 | 196467 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 8 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6015482.81101 | 2101057.8670900003 | 37.7499743755266 | -122.389261356351 | (37.7499743755266, -122.389261356351) | |||
| 151967 | 151967 | 196468 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 12 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6015629.24905 | 2101065.86664 | 37.7500044578413 | -122.38875552004801 | (37.7500044578413, -122.388755520048) | |||
| 133460 | 133460 | 196469 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Cesar Chavez St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015764.4296 | 2101073.59632 | 37.750033173207 | -122.388288593857 | (37.750033173207, -122.388288593857) | |||
| 73561 | 73561 | 239462 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 173 Marview Way | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5998149.4954699995 | 2103367.33608 | 37.7553394322787 | -122.449366958943 | (37.7553394322787, -122.449366958943) | |||
| 154208 | 154208 | 196449 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Madera St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012958.79837 | 2103280.94306 | 37.7559382107998 | -122.398145525023 | (37.7559382107998, -122.398145525023) | |||
| 41344 | 41344 | 196448 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Madera St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012976.23669 | 2103282.94556 | 37.755944680513295 | -122.398085357651 | (37.7559446805133, -122.398085357651) | |||
| 65975 | 65975 | 196447 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Madera St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012994.61219 | 2103283.12733 | 37.7559462030644 | -122.398021821446 | (37.7559462030644, -122.398021821446) | |||
| 43621 | 43621 | 239463 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Palo Alto Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997639.21555 | 2103894.3138099997 | 37.7567571793145 | -122.451169653584 | (37.7567571793145, -122.451169653584) | |||
| 35028 | 35028 | 196446 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 701 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012741.003 | 2104236.29493 | 37.7585492646472 | -122.398965788556 | (37.7585492646472, -122.398965788556) | |||
| 29741 | 29741 | 196461 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 615 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014144.28645 | 2104277.08263 | 37.7587393543665 | -122.39411542098999 | (37.7587393543665, -122.39411542099) | |||
| 158187 | 158187 | 196460 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 364 Missouri St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013463.46293 | 2105385.87525 | 37.76174599211679 | -122.396547761567 | (37.7617459921168, -122.396547761567) | |||
| 38004 | 38004 | 238044 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Dolores St | 13 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6004736.08926 | 2107889.20151 | 37.7681299654601 | -122.426910555597 | (37.7681299654601, -122.426910555597) | |||
| 63915 | 63915 | 238043 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Dolores St | 11 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6004732.65726 | 2107906.91695 | 37.7681784137377 | -122.426923688388 | (37.7681784137377, -122.426923688388) | |||
| 129929 | 129929 | 238042 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Dolores St | 9 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6004734.59668 | 2107939.64619 | 37.768268390012295 | -122.426919311396 | (37.7682683900123, -122.426919311396) | |||
| 169844 | 169844 | 238041 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Dolores St | 7 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6004732.58551 | 2107964.8947400004 | 37.7683376027325 | -122.426928066278 | (37.7683376027325, -122.426928066278) | |||
| 152297 | 152297 | 238037 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Elgin Park | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6005845.91582 | 2108560.6963400003 | 37.770036420279006 | -122.423119511166 | (37.770036420279, -122.423119511166) | |||
| 54786 | 54786 | 238038 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Elgin Park | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005844.524569999 | 2108573.0044 | 37.7700701367551 | -122.423125198471 | (37.7700701367551, -122.423125198471) | |||
| 31016 | 31016 | 238039 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 89 Elgin Park | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005843.94387 | 2108584.75014 | 37.7701023549756 | -122.423128042119 | (37.7701023549756, -122.423128042119) | |||
| 40677 | 40677 | 238040 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 49 Pearl St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005642.224280001 | 2108761.00256 | 37.7705749163322 | -122.423838323102 | (37.7705749163322, -122.423838323102) | |||
| 181685 | 181685 | 238036 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1345 Stevenson St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6006282.85406 | 2108818.1643 | 37.77076801336371 | -122.421626435124 | (37.7707680133637, -122.421626435124) | |||
| 58834 | 58834 | 246596 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Waller St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6005499.23386 | 2109278.3771900004 | 37.771987429293794 | -122.424369733388 | (37.7719874292938, -122.424369733388) |
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");