Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119284 | 119284 | 116071 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 4150X CLEMENT ST | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 8 | 3x3 | 5983115.0 | 2113126.0 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | |||
| 24107 | 24107 | 120282 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 129 24th Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5988304.19862 | 2115114.50046 | 37.787025803891204 | -122.484276029631 | (37.7870258038912, -122.484276029631) | ||||
| 82402 | 82402 | 114388 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 361x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 88059 | 88059 | 88281 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 935 Ulloa St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51275 | 5993125.0 | 2098282.0 | 37.7410877064311 | -122.466373457073 | (37.7410877064311, -122.466373457073) | ||
| 75496 | 75496 | 213000 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1624 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 6ft | 5993419.01621 | 2104404.96618 | 37.757916767851 | -122.465801633144 | (37.757916767851, -122.465801633144) | |||
| 67129 | 67129 | 213001 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1684 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 6ft | 5993433.46083 | 2104046.51042 | 37.75693337449479 | -122.465725635034 | (37.7569333744948, -122.465725635034) | |||
| 49076 | 49076 | 213002 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1684 09th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 6ft | 5993433.63561 | 2104037.38887 | 37.756908339163104 | -122.46572436788401 | (37.7569083391631, -122.465724367884) | |||
| 29900 | 29900 | 213665 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 3ft | 5994824.1493 | 2098927.22664 | 37.7429572344905 | -122.460545199208 | (37.7429572344905, -122.460545199208) | |||
| 147471 | 147471 | 213666 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 3ft | 5994837.41528 | 2098931.7185400003 | 37.742970331311795 | -122.460499654841 | (37.7429703313118, -122.460499654841) | |||
| 33821 | 33821 | 213667 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 3ft | 5994852.48941 | 2098936.7686799997 | 37.7429850649213 | -122.46044789885401 | (37.7429850649213, -122.460447898854) | |||
| 156414 | 156414 | 213668 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 3ft | 5994864.53372 | 2098940.09364 | 37.742994887300895 | -122.460406494088 | (37.7429948873009, -122.460406494088) | |||
| 37522 | 37522 | 213670 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 3ft | 5994884.54629 | 2098945.43271 | 37.74301069827921 | -122.460337683337 | (37.7430106982792, -122.460337683337) | |||
| 39231 | 39231 | 213669 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 3ft | 5994884.8089 | 2098938.57589 | 37.7429918862669 | -122.460336278605 | (37.7429918862669, -122.460336278605) | |||
| 24891 | 24891 | 213671 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 3ft | 5994885.5088599995 | 2098943.91671 | 37.7430065910919 | -122.460334245238 | (37.7430065910919, -122.460334245238) | |||
| 123568 | 123568 | 96765 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 184 Edgewood Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/12/2011 12:00:00 AM | Permit Number 767998 | 5996632.0 | 2105999.0 | 37.76247839448661 | -122.45480501488301 | (37.7624783944866, -122.454805014883) | |||
| 80392 | 80392 | 98149 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 850 Rockdale Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | |||
| 94269 | 94269 | 98150 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 850 Rockdale Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | |||
| 93838 | 93838 | 94852 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 769 Joost Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5997030.4 | 2094957.2 | 37.7321831815324 | -122.45263017562 | (37.7321831815324, -122.45263017562) | ||||
| 170863 | 170863 | 236791 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 192 Marview Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 5998125.74661 | 2103459.41933 | 37.755590911501606 | -122.44945572381799 | (37.7555909115016, -122.449455723818) | |||
| 177400 | 177400 | 250146 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2501 Lyon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999207.44391 | 2117490.79429 | 37.79417929707979 | -122.446724430609 | (37.7941792970798, -122.446724430609) | ||||
| 133128 | 133128 | 250147 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2501 Lyon St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5999210.3991 | 2117472.66602 | 37.794129690476105 | -122.446712900392 | (37.7941296904761, -122.446712900392) | ||||
| 70262 | 70262 | 250148 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2501 Lyon St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5999211.58041 | 2117458.2617099998 | 37.7940902075462 | -122.44670777604799 | (37.7940902075462, -122.446707776048) | ||||
| 135104 | 135104 | 250149 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2501 Lyon St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5999215.63832 | 2117439.7417 | 37.794039588317 | -122.446692402146 | (37.794039588317, -122.446692402146) | ||||
| 146477 | 146477 | 250150 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2501 Lyon St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999218.59352 | 2117421.61343 | 37.7939899817095 | -122.446680871938 | (37.7939899817095, -122.446680871938) | ||||
| 98763 | 98763 | 249657 | Undocumented 2 | Prunus spp :: Cherry 84 | 2401 Lyon St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 10ft | 5999220.856459999 | 2117228.0712599996 | 37.7934586955217 | -122.44665911012301 | (37.7934586955217, -122.446659110123) | |||
| 45545 | 45545 | 250151 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2501 Lyon St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5999220.87756 | 2117406.8173700003 | 37.7939494861264 | -122.446671903881 | (37.7939494861264, -122.446671903881) | ||||
| 44190 | 44190 | 249661 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2401 Lyon St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999232.658419999 | 2117208.86838 | 37.7934066436505 | -122.446616892353 | (37.7934066436505, -122.446616892353) | ||||
| 53345 | 53345 | 249662 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2401 Lyon St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5999235.55005 | 2117182.1724900003 | 37.79333350898529 | -122.446604965544 | (37.7933335089853, -122.446604965544) | ||||
| 131040 | 131040 | 249663 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2401 Lyon St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999240.36151 | 2117161.61527 | 37.793277339139706 | -122.446586837907 | (37.7932773391397, -122.446586837907) | ||||
| 137658 | 137658 | 249664 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2401 Lyon St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5999241.54149 | 2117138.79958 | 37.7932147607016 | -122.446581112841 | (37.7932147607016, -122.446581112841) | ||||
| 151158 | 151158 | 249665 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2401 Lyon St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999244.57563 | 2117118.96584 | 37.7931604758161 | -122.44656918693998 | (37.7931604758161, -122.44656918694) | ||||
| 77174 | 77174 | 249666 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2401 Lyon St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999246.11095 | 2117099.98704 | 37.793108452756 | -122.44656250858 | (37.793108452756, -122.44656250858) | ||||
| 165936 | 165936 | 249667 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2401 Lyon St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5999247.612269999 | 2117079.36111 | 37.7930519051704 | -122.446555829313 | (37.7930519051704, -122.446555829313) | ||||
| 150089 | 150089 | 249642 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2460 Lyon St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 5999289.16084 | 2117209.34278 | 37.793411173535105 | -122.446421424722 | (37.7934111735351, -122.446421424722) | ||||
| 34414 | 34414 | 249641 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2460 Lyon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999290.35855 | 2117187.34 | 37.7933508281386 | -122.44641569694599 | (37.7933508281386, -122.446415696946) | ||||
| 60082 | 60082 | 249703 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2400 Baker St | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999691.6374699995 | 2117215.06978 | 37.793449877667 | -122.445029242728 | (37.793449877667, -122.445029242728) | ||||
| 55581 | 55581 | 249708 | Undocumented 2 | Prunus lusitanica :: Portugese Cherry Laurel 430 | 2400 Baker St | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5999695.18411 | 2117183.83938 | 37.7933643296589 | -122.44501472497 | (37.7933643296589, -122.44501472497) | ||||
| 155612 | 155612 | 249707 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2400 Baker St | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999697.96101 | 2117191.03981 | 37.793384258626205 | -122.445005634599 | (37.7933842586262, -122.445005634599) | ||||
| 184038 | 184038 | 249689 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2400 Baker St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999718.81935 | 2117298.99939 | 37.7936818775552 | -122.444941227873 | (37.7936818775552, -122.444941227873) | ||||
| 33070 | 33070 | 249679 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2400 Baker St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999741.43988 | 2117216.47572 | 37.793456580320395 | -122.44485702433998 | (37.7934565803204, -122.44485702434) | ||||
| 52553 | 52553 | 249684 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999742.6330699995 | 2117264.679 | 37.793589001891796 | -122.44485636243 | (37.7935890018918, -122.44485636243) | ||||
| 54903 | 54903 | 249683 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999743.16478 | 2117253.42108 | 37.7935581209611 | -122.44485371304701 | (37.7935581209611, -122.444853713047) | ||||
| 188711 | 188711 | 249682 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999744.1267099995 | 2117244.44172 | 37.7935335209065 | -122.444849738942 | (37.7935335209065, -122.444849738942) | ||||
| 76324 | 76324 | 249680 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Baker St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 5999746.74355 | 2117232.18734 | 37.7935000229554 | -122.444839803216 | (37.7935000229554, -122.444839803216) | ||||
| 29068 | 29068 | 237593 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 37 Seward St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6000955.31205 | 2104253.31098 | 37.7579322029301 | -122.439727139419 | (37.7579322029301, -122.439727139419) | |||
| 138241 | 138241 | 237594 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 37 Seward St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 3ft | 6000962.1319699995 | 2104249.24086 | 37.757921415553604 | -122.439703261523 | (37.7579214155536, -122.439703261523) | |||
| 143868 | 143868 | 99827 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 2398 Broadway | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 174515 | 174515 | 236750 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3943 21st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6002208.02955 | 2103519.5484700003 | 37.7559886915345 | -122.43534223396601 | (37.7559886915345, -122.435342233966) | ||||
| 22288 | 22288 | 237856 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 636 30th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6002455.57988 | 2098272.49197 | 37.7415955682714 | -122.434111048608 | (37.7415955682714, -122.434111048608) | |||
| 61578 | 61578 | 238534 | Undocumented 2 | Prunus spp :: Cherry 84 | 671 Church St | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6004315.939809999 | 2105094.00544 | 37.7604312615151 | -122.428164581928 | (37.7604312615151, -122.428164581928) | |||
| 29351 | 29351 | 237735 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 701 Church St | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 3ft | 6004351.71049 | 2104523.66761 | 37.758867273023604 | -122.42800022455499 | (37.7588672730236, -122.428000224555) | |||
| 35443 | 35443 | 237864 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1201 San Jose Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004410.62481 | 2096042.76783 | 37.735584015890204 | -122.427192376154 | (37.7355840158902, -122.427192376154) | ||||
| 129663 | 129663 | 237865 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1201 San Jose Ave | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004416.51581 | 2096041.25908 | 37.735580206346704 | -122.427171901277 | (37.7355802063467, -122.427171901277) | ||||
| 40808 | 40808 | 235821 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1101 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004684.25074 | 2096286.8967900001 | 37.7362698092063 | -122.426263721818 | (37.7362698092063, -122.426263721818) | ||||
| 175316 | 175316 | 235818 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004748.03107 | 2096617.2038599998 | 37.7371803628754 | -122.426066713609 | (37.7371803628754, -122.426066713609) | ||||
| 162715 | 162715 | 235819 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6004808.19427 | 2096683.55845 | 37.7373659577613 | -122.42586342366 | (37.7373659577613, -122.42586342366) | ||||
| 162343 | 162343 | 237863 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004816.92245 | 2096702.3480099998 | 37.737418042901204 | -122.42583458331801 | (37.7374180429012, -122.425834583318) | ||||
| 151464 | 151464 | 235817 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004822.42973 | 2096709.04499 | 37.7374367425214 | -122.425816018614 | (37.7374367425214, -122.425816018614) | ||||
| 69153 | 69153 | 237112 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004834.0708099995 | 2096408.3013799998 | 37.736611626213495 | -122.425754370088 | (37.7366116262135, -122.425754370088) | ||||
| 89616 | 89616 | 237113 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 San Jose Ave | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004838.14282 | 2096415.36394 | 37.7366312485184 | -122.425740793928 | (37.7366312485184, -122.425740793928) | ||||
| 130170 | 130170 | 237114 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 San Jose Ave | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004844.31996 | 2096418.97753 | 37.736641519684504 | -122.425719694004 | (37.7366415196845, -122.425719694004) | ||||
| 177422 | 177422 | 237963 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1000 San Jose Ave | 106 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005052.98208 | 2096959.6805599998 | 37.7381379574049 | -122.42503671826799 | (37.7381379574049, -122.425036718268) | ||||
| 160246 | 160246 | 237862 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1000 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005165.80079 | 2097273.24395 | 37.7390053040631 | -122.424668946839 | (37.7390053040631, -122.424668946839) | ||||
| 176516 | 176516 | 235822 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Eugenia Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006569.74565 | 2098123.14893 | 37.7414181446448 | -122.419875033313 | (37.7414181446448, -122.419875033313) | ||||
| 187204 | 187204 | 237951 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 200 Eugenia Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6006574.718780001 | 2098103.54318 | 37.7413645918137 | -122.419856447043 | (37.7413645918137, -122.419856447043) | ||||
| 128628 | 128628 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 1150 Lombard St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.42057600387301 | (37.8027004912885, -122.420576003873) | ||
| 75846 | 75846 | 136630 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1101 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6007480.489990001 | 2119873.18384 | 37.8011898586792 | -122.418267709195 | (37.8011898586792, -122.418267709195) | ||||
| 61141 | 61141 | 136053 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1101 Greenwich St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6007566.05683 | 2119890.57017 | 37.8012424132723 | -122.417972843093 | (37.8012424132723, -122.417972843093) | ||||
| 132950 | 132950 | 136054 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1101 Greenwich St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6007578.67798 | 2119880.17499 | 37.80121458104 | -122.417928430959 | (37.80121458104, -122.417928430959) | ||||
| 172165 | 172165 | 135823 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1015 Vallejo St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6008630.162959999 | 2118635.32656 | 37.7978556572789 | -122.414201697946 | (37.7978556572789, -122.414201697946) | ||||
| 164608 | 164608 | 135833 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008637.50385 | 2119009.84925 | 37.798884416044295 | -122.414202807733 | (37.7988844160443, -122.414202807733) | ||||
| 32547 | 32547 | 135824 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1013 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6008637.906 | 2118634.49639 | 37.7978538127598 | -122.41417484600099 | (37.7978538127598, -122.414174846001) | ||||
| 156622 | 156622 | 135832 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6008638.145690001 | 2119013.6558 | 37.7988949039377 | -122.414200856206 | (37.7988949039377, -122.414200856206) | ||||
| 170177 | 170177 | 135830 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008645.65329 | 2119014.61059 | 37.7988979472514 | -122.41417494494101 | (37.7988979472514, -122.414174944941) | ||||
| 177555 | 177555 | 135829 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008653.20032 | 2119016.0444 | 37.798902308044205 | -122.414148931139 | (37.7989023080442, -122.414148931139) | ||||
| 63126 | 63126 | 135827 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008668.93858 | 2119018.75606 | 37.7989106375677 | -122.414094663337 | (37.7989106375677, -122.414094663337) | ||||
| 30016 | 30016 | 135826 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6008677.52116 | 2119019.1422200003 | 37.798912179918396 | -122.414064992014 | (37.7989121799184, -122.414064992014) | ||||
| 31907 | 31907 | 246740 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 132 Ripley St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 8ft | 6008857.53269 | 2099073.06292 | 37.7441550208325 | -122.41203174448201 | (37.7441550208325, -122.412031744482) | |||
| 41647 | 41647 | 246741 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Ripley St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 8ft | 6008870.15252 | 2099074.1430099998 | 37.7441586945704 | -122.41198818403099 | (37.7441586945704, -122.411988184031) | |||
| 171682 | 171682 | 135825 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 941 Vallejo St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6008892.44244 | 2118672.21795 | 37.7979716806151 | -122.413296744356 | (37.7979716806151, -122.413296744356) | ||||
| 63982 | 63982 | 247592 | Undocumented 2 | Prunus spp :: Cherry 84 | 800 Tompkins Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6008994.80779 | 2096446.35961 | 37.736950368458096 | -122.41137154767799 | (37.7369503684581, -122.411371547678) | ||||
| 123816 | 123816 | 246630 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 3320 Harrison St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6009028.4352400005 | 2099278.75412 | 37.7447293908617 | -122.411455327621 | (37.7447293908617, -122.411455327621) | ||||
| 59058 | 59058 | 246632 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3320 Harrison St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6009038.19965 | 2099264.8934299997 | 37.744691880139705 | -122.411420585011 | (37.7446918801397, -122.411420585011) | ||||
| 90918 | 90918 | 117588 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 261 Ripley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/27/2016 12:00:00 AM | 3 | Permit Number 778127 | 6009622.3 | 2099176.0 | 37.744480542407395 | -122.409394598776 | (37.7444805424074, -122.409394598776) | ||
| 41124 | 41124 | 247987 | Undocumented 2 | Prunus spp :: Cherry 84 | 124 Mullen Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6009857.2555 | 2099808.73815 | 37.7462310644209 | -122.408626794296 | (37.7462310644209, -122.408626794296) | ||||
| 68114 | 68114 | 246828 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 400 Franconia St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6009896.65994 | 2098729.7560099997 | 37.743270622146 | -122.408414443683 | (37.743270622146, -122.408414443683) | ||||
| 78531 | 78531 | 104869 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 Holladay Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770735 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | ||||
| 91612 | 91612 | 104867 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 Holladay Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770735 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | ||||
| 74729 | 74729 | 247959 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 12 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6010396.832769999 | 2098907.5359799997 | 37.743786764640795 | -122.40669749401 | (37.7437867646408, -122.40669749401) | ||||
| 168699 | 168699 | 247958 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010403.29697 | 2098902.73698 | 37.7437739492996 | -122.406674804102 | (37.7437739492996, -122.406674804102) | ||||
| 123929 | 123929 | 247956 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 6 Joy St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010454.452819999 | 2098883.02488 | 37.7437226861619 | -122.40649652970501 | (37.7437226861619, -122.406496529705) | ||||
| 32465 | 32465 | 248037 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 Rutledge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010488.35763 | 2099431.59018 | 37.745230824035204 | -122.40641793974599 | (37.7452308240352, -122.406417939746) | ||||
| 64801 | 64801 | 248042 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 43 Rutledge St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010523.22894 | 2099409.2799 | 37.745171515566796 | -122.40629578842301 | (37.7451715155668, -122.406295788423) | ||||
| 30309 | 30309 | 249829 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 339 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6011201.84726 | 2120367.04696 | 37.802754654775704 | -122.405424923615 | (37.8027546547757, -122.405424923615) | |||
| 116481 | 116481 | 249933 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 345 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011225.47356 | 2120026.31802 | 37.801820417444 | -122.405319155254 | (37.801820417444, -122.405319155254) | |||
| 63079 | 63079 | 249835 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6011233.03828 | 2120380.52255 | 37.8027933993566 | -122.40531793578 | (37.8027933993566, -122.40531793578) | |||
| 35676 | 35676 | 249834 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 6011234.1519 | 2120371.9476900003 | 37.8027699171526 | -122.40531347785401 | (37.8027699171526, -122.405313477854) | |||
| 39263 | 39263 | 249833 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011234.89731 | 2120366.37397 | 37.8027546547576 | -122.40531050560101 | (37.8027546547576, -122.405310505601) | |||
| 184115 | 184115 | 249937 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 339 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011248.56733 | 2120031.66705 | 37.8018363956996 | -122.405239616532 | (37.8018363956996, -122.405239616532) | |||
| 171242 | 171242 | 249941 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 331 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6011275.707669999 | 2120025.2952 | 37.8018204174494 | -122.40514524887199 | (37.8018204174494, -122.405145248872) |
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");