Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 156176 | 156176 | 44741 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 271 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 3 | Permit Number 43859 | 5992054.55445 | 2086618.7004799999 | 37.7090013413078 | -122.46922594483601 | (37.7090013413078, -122.469225944836) | |
| 140557 | 140557 | 109055 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 320 Hanover St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772693 | 5999569.6 | 2086544.4 | 37.70922872292179 | -122.443247602414 | (37.7092287229218, -122.443247602414) | |
| 28678 | 28678 | 179035 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 178 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010379.06325 | 2086412.1514400002 | 37.709476057444796 | -122.40587891040899 | (37.7094760574448, -122.405878910409) | |||
| 10329 | 10329 | 109051 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772570 | 5995048.30925 | 2086814.9244099997 | 37.7097126663738 | -122.45889335865 | (37.7097126663738, -122.45889335865) |
| 157300 | 157300 | 57927 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 559 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 3 | Permit Number 16885 | 5999203.256130001 | 2086855.58023 | 37.7100622571339 | -122.444536089569 | (37.7100622571339, -122.444536089569) | ||
| 97508 | 97508 | 108899 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 16 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772775 | 6000547.04329 | 2086890.00633 | 37.710233369404605 | -122.43989417722 | (37.7102333694046, -122.43989417722) |
| 82049 | 82049 | 69397 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | Permit Number 772744 | 6001523.93675849 | 2087030.79827901 | 37.7106755138649 | -122.436527911504 | (37.7106755138649, -122.436527911504) | |
| 12718 | 12718 | 109057 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 825 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772770 | 5997289.5352300005 | 2087142.99435 | 37.7107420465867 | -122.45117096298401 | (37.7107420465867, -122.451170962984) |
| 13060 | 13060 | 109069 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1065 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772763 | 6002105.570119999 | 2087176.80573 | 37.7111094529054 | -122.434528092094 | (37.7111094529054, -122.434528092094) |
| 106738 | 106738 | 95016 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 83 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010516.6 | 2087234.5 | 37.7117417518759 | -122.405461434977 | (37.7117417518759, -122.405461434977) | |||
| 87906 | 87906 | 95006 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 195 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2013 12:00:00 AM | 3 | 3x3 | 6009968.4 | 2087457.4 | 37.7123231225616 | -122.407371876718 | (37.7123231225616, -122.407371876718) | ||
| 185251 | 185251 | 213304 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 252 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994495.39623 | 2087783.3442799998 | 37.71233992151021 | -122.460874450904 | (37.7123399215102, -122.460874450904) | |||
| 61447 | 61447 | 109722 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6012966.2543 | 2089212.97453 | 37.7173109169351 | -122.397133343428 | (37.7173109169351, -122.397133343428) | |||
| 73454 | 73454 | 109719 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013017.968169999 | 2089237.9100799998 | 37.7173822637496 | -122.39695633886002 | (37.7173822637496, -122.39695633886) | |||
| 126749 | 126749 | 213306 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 136 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5995570.34382 | 2089650.80872 | 37.7175293343767 | -122.457294144606 | (37.7175293343767, -122.457294144606) | |||
| 21015 | 21015 | 19321 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/2010 12:00:00 AM | 3 | 3X3 | 5993639.27417 | 2089852.22483 | 37.7179712747243 | -122.46398352863001 | (37.7179712747243, -122.46398352863) | ||
| 38328 | 38328 | 213300 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 729 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5994737.406330001 | 2089905.17069 | 37.7181798769692 | -122.46019162623699 | (37.7181798769692, -122.460191626237) | |||
| 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) | |||
| 114369 | 114369 | 28253 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3432 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2002 12:00:00 AM | 3 | 3X3 | 6012031.1541281 | 2089723.1062284 | 37.718659534499295 | -122.40040137877199 | (37.7186595344993, -122.400401378772) | ||
| 93800 | 93800 | 22521 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6600 03rd St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/20/1992 12:00:00 AM | 3 | 3X3 | 6012847.5284056 | 2089784.7633558998 | 37.7188743244909 | -122.39758380657601 | (37.7188743244909, -122.397583806576) | ||
| 142091 | 142091 | 22527 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6600 03rd St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 6012847.5284056 | 2089784.7633558998 | 37.7188743244909 | -122.39758380657601 | (37.7188743244909, -122.397583806576) | |||
| 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) | |||
| 131462 | 131462 | 179011 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 579 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6001850.91399 | 2090131.7943 | 37.71920873736379 | -122.435619512955 | (37.7192087373638, -122.435619512955) | |||
| 11888 | 11888 | 108379 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Bertita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773806 | 6000690.090969999 | 2090159.58738 | 37.7192190489897 | -122.439634019098 | (37.7192190489897, -122.439634019098) |
| 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) | |||
| 71360 | 71360 | 78237 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1215 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | Permit Number 779512 | 5999758.88688 | 2090259.2057 | 37.7194395330998 | -122.442859978114 | (37.7194395330998, -122.442859978114) | |
| 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) | |||
| 56276 | 56276 | 213296 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 845 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996989.86469 | 2090498.6101799998 | 37.719938627140706 | -122.45244868286699 | (37.7199386271407, -122.452448682867) | |||
| 10377 | 10377 | 28246 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3326 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2002 12:00:00 AM | 3 | 2X3 | 6011947.80562 | 2090200.17318 | 37.7199648154144 | -122.400722979282 | (37.7199648154144, -122.400722979282) | ||
| 171422 | 171422 | 213295 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 845 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996972.211569999 | 2090510.38577 | 37.719969948743206 | -122.452510552626 | (37.7199699487432, -122.452510552626) | |||
| 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) | |||
| 29313 | 29313 | 179001 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 500 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001827.054219999 | 2090687.03762 | 37.7207319560017 | -122.435741691253 | (37.7207319560017, -122.435741691253) | |||
| 10479 | 10479 | 35851 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 500 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778923 | 6001833.39372 | 2090697.4113200002 | 37.720760799954206 | -122.435720519401 | (37.7207607999542, -122.435720519401) | |
| 24965 | 24965 | 213284 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 152 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994475.62527 | 2090947.51619 | 37.7210268472907 | -122.461171998816 | (37.7210268472907, -122.461171998816) | |||
| 169629 | 169629 | 178987 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 438 Delano Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5999543.39819 | 2091383.90085 | 37.722515400656 | -122.443685595329 | (37.722515400656, -122.443685595329) | |||
| 32250 | 32250 | 178990 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 342 Oneida Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5999327.15458 | 2091397.10095 | 37.7225393091341 | -122.44443404622 | (37.7225393091341, -122.44443404622) | |||
| 130269 | 130269 | 178991 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 342 Oneida Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5999304.0712 | 2091408.36096 | 37.7225689094196 | -122.444514648859 | (37.7225689094196, -122.444514648859) | |||
| 183477 | 183477 | 179148 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004516.54682 | 2091330.1429599999 | 37.722650185652 | -122.426490709795 | (37.722650185652, -122.426490709795) | |||
| 93823 | 93823 | 28615 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999987.60975 | 2091601.0392099998 | 37.7231369387356 | -122.442165640215 | (37.7231369387356, -122.442165640215) | |||
| 117446 | 117446 | 28616 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999998.87347 | 2091601.9533400002 | 37.7231400906515 | -122.44212676945601 | (37.7231400906515, -122.442126769456) | |||
| 90559 | 90559 | 28617 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000011.03973 | 2091602.5396 | 37.7231423937331 | -122.44208475527701 | (37.7231423937331, -122.442084755277) | |||
| 144521 | 144521 | 28618 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000023.845509999 | 2091604.32382 | 37.723148022568104 | -122.442040616354 | (37.7231480225681, -122.442040616354) | |||
| 101577 | 101577 | 28619 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6000038.78425 | 2091606.3548299999 | 37.7231544505641 | -122.441989121927 | (37.7231544505641, -122.441989121927) | |||
| 89743 | 89743 | 28620 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6000051.9098 | 2091608.73805 | 37.723161742302 | -122.441943920583 | (37.723161742302, -122.441943920583) | |||
| 77241 | 77241 | 178993 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Wanda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6000610.93325 | 2091649.2659200002 | 37.7233048624224 | -122.44001439546301 | (37.7233048624224, -122.440014395463) | |||
| 165270 | 165270 | 95771 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 335 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767506 | 6003734.79279 | 2091608.3124 | 37.7233697529841 | -122.429212886579 | (37.7233697529841, -122.429212886579) |
| 52225 | 52225 | 179138 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 614 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009724.980769999 | 2091494.3266200002 | 37.7233940625658 | -122.40849779373899 | (37.7233940625658, -122.408497793739) | |||
| 156737 | 156737 | 179151 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 358 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003390.22791 | 2091653.2200900002 | 37.7234735473518 | -122.430407185342 | (37.7234735473518, -122.430407185342) | |||
| 10595 | 10595 | 78395 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 367 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768554 | 5999771.76948 | 2091747.9413700001 | 37.723527995008396 | -122.442922299331 | (37.7235279950084, -122.442922299331) |
| 10582 | 10582 | 69800 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 367 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | 3x3 | 5999779.7835 | 2091764.7216900003 | 37.7235745268131 | -122.442895800812 | (37.7235745268131, -122.442895800812) | |
| 12339 | 12339 | 62181 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2016 12:00:00 AM | 3 | Permit Number 778619 | 6000227.937530001 | 2091768.58709 | 37.7236106804803 | -122.44134689306802 | (37.7236106804803, -122.441346893068) | |
| 12147 | 12147 | 62165 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779350 | 6000139.34294 | 2091815.10105 | 37.723733349795 | -122.441656484657 | (37.723733349795, -122.441656484657) | |
| 12084 | 12084 | 43317 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 263 Athens St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51344 | 6004450.31399 | 2091734.8767 | 37.7237577510972 | -122.42674847077299 | (37.7237577510972, -122.426748470773) | |
| 161896 | 161896 | 214837 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 527 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994748.36207 | 2092060.94977 | 37.7240997605754 | -122.46030986640899 | (37.7240997605754, -122.460309866409) | |||
| 178265 | 178265 | 95761 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 211 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767498 | 6004841.33495 | 2091865.6988400002 | 37.724139060046795 | -122.425406081532 | (37.7241390600468, -122.425406081532) |
| 60230 | 60230 | 95768 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 276 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767503 | 6003901.58098 | 2091957.48005 | 37.7243379307235 | -122.428661209168 | (37.7243379307235, -122.428661209168) |
| 112700 | 112700 | 115765 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 161 De Soto St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 768395 | 5993291.8 | 2092241.0 | 37.7245102406902 | -122.46535801148501 | (37.7245102406902, -122.465358011485) | ||
| 87808 | 87808 | 107938 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 613 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772422 | 5994837.09376 | 2092346.0584099998 | 37.7248877040282 | -122.460023781173 | (37.7248877040282, -122.460023781173) | |
| 142104 | 142104 | 107937 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 613 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772422 | 5994837.09376 | 2092346.0584099998 | 37.7248877040282 | -122.460023781173 | (37.7248877040282, -122.460023781173) | |
| 47216 | 47216 | 214727 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 620 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994875.65194 | 2092373.1358900003 | 37.7249642698646 | -122.45989245148199 | (37.7249642698646, -122.459892451482) | |||
| 27793 | 27793 | 213495 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 613 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994845.468309999 | 2092391.05162 | 37.725011726204 | -122.45999808945 | (37.725011726204, -122.45999808945) | |||
| 148638 | 148638 | 213496 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 613 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994849.15595 | 2092409.59158 | 37.7250628445589 | -122.459986684233 | (37.7250628445589, -122.459986684233) | |||
| 160951 | 160951 | 213494 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 145 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995154.792169999 | 2092431.6275799999 | 37.7251409237001 | -122.458931734507 | (37.7251409237001, -122.458931734507) | |||
| 2996 | 2996 | 178926 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 406 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 780238 | 6000939.854169999 | 2092384.3608900001 | 37.7253419851205 | -122.43893003518801 | (37.7253419851205, -122.438930035188) | ||
| 12716 | 12716 | 108567 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773758 | 6009500.29517 | 2092233.5680799999 | 37.725411278805296 | -122.409326636833 | (37.7254112788053, -122.409326636833) |
| 180118 | 180118 | 179152 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002842.979780001 | 2092426.64855 | 37.725566194215006 | -122.43235413394699 | (37.725566194215, -122.432354133947) | |||
| 53669 | 53669 | 179093 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 527 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004168.29585 | 2092423.50512 | 37.7256326235285 | -122.427772402901 | (37.7256326235285, -122.427772402901) | |||
| 56422 | 56422 | 179145 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 102 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011376.8849 | 2092609.1227799999 | 37.726547436394604 | -122.402865802033 | (37.7265474363946, -122.402865802033) | |||
| 29661 | 29661 | 179112 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 261 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006571.20289 | 2092730.1435099998 | 37.7266102225609 | -122.419487475869 | (37.7266102225609, -122.419487475869) | |||
| 75565 | 75565 | 179113 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 261 Oxford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006566.09251 | 2092743.8375 | 37.726647535439604 | -122.419506113419 | (37.7266475354396, -122.419506113419) | |||
| 75623 | 75623 | 213607 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 133 Dorado Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994538.46067 | 2093084.1341 | 37.726897100910705 | -122.46110958766 | (37.7268971009107, -122.46110958766) | |||
| 174755 | 174755 | 179072 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Arago St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5999599.07977 | 2092991.3421200002 | 37.7269322392262 | -122.443608534205 | (37.7269322392262, -122.443608534205) | |||
| 61906 | 61906 | 201275 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 210 Kalmanovitz St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 2ft | 6013023.37655 | 2092747.7881599998 | 37.7270199824665 | -122.39718362363399 | (37.7270199824665, -122.397183623634) | |||
| 31476 | 31476 | 179124 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Somerset St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009979.33211 | 2092867.06279 | 37.727177550003205 | -122.40771529004101 | (37.7271775500032, -122.407715290041) | |||
| 183055 | 183055 | 179125 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Somerset St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009972.5795599995 | 2092885.80828 | 37.7272286431674 | -122.407739954855 | (37.7272286431674, -122.407739954855) | |||
| 131875 | 131875 | 95679 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 318 Holyoke St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767431 | 6009609.49645 | 2092896.87368 | 37.727238694008705 | -122.408995916549 | (37.7272386940087, -122.408995916549) |
| 176543 | 176543 | 179052 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000689.90663 | 2093113.92443 | 37.7273309752317 | -122.439846362535 | (37.7273309752317, -122.439846362535) | |||
| 35880 | 35880 | 179128 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Somerset St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009952.22714 | 2092954.05683 | 37.727414899966504 | -122.407815123785 | (37.7274148999665, -122.407815123785) | |||
| 137009 | 137009 | 179049 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 179 Santa Rosa Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001280.877619999 | 2093214.7145099998 | 37.7276413438501 | -122.437810596884 | (37.7276413438501, -122.437810596884) | |||
| 161730 | 161730 | 179133 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Somerset St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009923.85676 | 2093045.64408 | 37.7276647909784 | -122.407919656493 | (37.7276647909784, -122.407919656493) | |||
| 137942 | 137942 | 179048 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 179 Santa Rosa Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001267.83675 | 2093223.5544 | 37.7276648746137 | -122.437856312126 | (37.7276648746137, -122.437856312126) | |||
| 10513 | 10513 | 117008 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1315 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2016 12:00:00 AM | 3 | 3x3 | 6006952.61647 | 2093135.11232 | 37.7277436552341 | -122.418197638517 | (37.7277436552341, -122.418197638517) | ||
| 67890 | 67890 | 179045 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 179 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001222.93015 | 2093254.58379 | 37.7277475205286 | -122.438013776233 | (37.7277475205286, -122.438013776233) | |||
| 70952 | 70952 | 213489 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 600 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995410.713269999 | 2093398.12402 | 37.727809398374795 | -122.45811696403798 | (37.7278093983748, -122.458116964038) | |||
| 150216 | 150216 | 38139 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Burrows St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 3 | Permit Number 40297 | 6010028.250109999 | 2093116.7620400002 | 37.7278659099719 | -122.407563777644 | (37.7278659099719, -122.407563777644) | |
| 71204 | 71204 | 214751 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5995612.00056 | 2093441.40457 | 37.7279398000583 | -122.45742424415701 | (37.7279398000583, -122.457424244157) | |||
| 4846 | 4846 | 76677 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 3 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 150877 | 150877 | 179137 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 Burrows St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010853.917 | 2093371.07735 | 37.728610389447496 | -122.404727309634 | (37.7286103894475, -122.404727309634) | |||
| 132680 | 132680 | 213534 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993559.98064 | 2093781.74568 | 37.7287562145219 | -122.464542776527 | (37.7287562145219, -122.464542776527) | |||
| 41657 | 41657 | 213555 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Valdez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5996402.0458 | 2093842.9488400002 | 37.7290876920423 | -122.45472205120599 | (37.7290876920423, -122.454722051206) | |||
| 61186 | 61186 | 213488 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 800 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995426.39984 | 2094264.81715 | 37.7301900297225 | -122.458125434766 | (37.7301900297225, -122.458125434766) | |||
| 188578 | 188578 | 213560 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996382.63845 | 2094254.1039 | 37.7302155120395 | -122.454818838046 | (37.7302155120395, -122.454818838046) | |||
| 64023 | 64023 | 213692 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 119 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000067.8174 | 2094188.92148 | 37.7302472374194 | -122.442074047998 | (37.7302472374194, -122.442074047998) | |||
| 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) | |||
| 11489 | 11489 | 918 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1246 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3x6 | 6002972.02958 | 2094203.5052200002 | 37.730452359288996 | -122.43203484674801 | (37.730452359289, -122.432034846748) | ||
| 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) | |||
| 136223 | 136223 | 179108 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 286 Trumbull St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6005259.27603 | 2094300.24021 | 37.7308473792844 | -122.42413437721301 | (37.7308473792844, -122.424134377213) | |||
| 175674 | 175674 | 45552 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2003 12:00:00 AM | 3 | Permit Number 44300 | 5987586.8772599995 | 2094815.36489 | 37.7312481217032 | -122.485267730441 | (37.7312481217032, -122.485267730441) | |
| 184323 | 184323 | 45553 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 Sylvan Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44300 | 5987588.08064 | 2094826.81646 | 37.7312796348483 | -122.485264410152 | (37.7312796348483, -122.485264410152) |
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");