Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135851 | 135851 | 31058 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 6 | Permit Number 34809 | 6002732.75221 | 2087097.44922 | 37.71092714054029 | -122.432354735598 | (37.7109271405403, -122.432354735598) | |
| 51659 | 51659 | 178979 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 190 Rae Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997616.63139 | 2087136.8467599999 | 37.7107438892848 | -122.450040007061 | (37.7107438892848, -122.450040007061) | |||
| 168670 | 168670 | 178978 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 190 Rae Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997625.81626 | 2087145.6195099999 | 37.7107685028255 | -122.450008894089 | (37.7107685028255, -122.450008894089) | |||
| 52624 | 52624 | 86960 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 208 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49928 | 5993493.7535 | 2087361.9529 | 37.71112519553311 | -122.464305827668 | (37.7111251955331, -122.464305827668) | |
| 162550 | 162550 | 179156 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1219 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001622.38743 | 2087558.0089200002 | 37.712128712138295 | -122.436225349332 | (37.7121287121383, -122.436225349332) | |||
| 122960 | 122960 | 179028 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 535 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007927.50802 | 2088265.2218900002 | 37.7144267929389 | -122.41448296003 | (37.7144267929389, -122.41448296003) | |||
| 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) | |||
| 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) | |||
| 131821 | 131821 | 84213 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 159 Tioga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50702 | 6010145.69333 | 2089116.11525 | 37.716887537712005 | -122.406875926694 | (37.716887537712, -122.406875926694) | |
| 170473 | 170473 | 82703 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 67 Jennings Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52500 | 6012950.17329 | 2089208.10371 | 37.71729664739521 | -122.39718858698 | (37.7172966473952, -122.39718858698) | |
| 58743 | 58743 | 109720 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013003.046630001 | 2089225.87008 | 37.7173483736975 | -122.39700707233999 | (37.7173483736975, -122.39700707234) | |||
| 74785 | 74785 | 213334 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5991917.942369999 | 2089508.58685 | 37.716928375916 | -122.469908359396 | (37.716928375916, -122.469908359396) | |||
| 10340 | 10340 | 28256 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3476 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2003 12:00:00 AM | 6 | 3x3 | 6012060.981000001 | 2089540.1901200002 | 37.7181589470551 | -122.400285438425 | (37.7181589470551, -122.400285438425) | ||
| 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) | |||
| 11481 | 11481 | 28255 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3476 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2003 12:00:00 AM | 6 | 3x3 | 6012058.005419999 | 2089554.66958 | 37.7181985388057 | -122.400296740219 | (37.7181985388057, -122.400296740219) | ||
| 18995 | 18995 | 19331 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/05/2000 12:00:00 AM | 6 | 3x3 | 5993203.76699 | 2089824.45321 | 37.7178699121392 | -122.465486857851 | (37.7178699121392, -122.465486857851) | ||
| 97015 | 97015 | 10703 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130X Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5993684.4832438 | 2089860.5757616002 | 37.717996809726 | -122.46382786766 | (37.717996809726, -122.46382786766) | |||
| 178580 | 178580 | 213303 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 655 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995455.6031599995 | 2089891.9177400002 | 37.7181847719797 | -122.457708184405 | (37.7181847719797, -122.457708184405) | |||
| 183309 | 183309 | 213302 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 663 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995432.632669999 | 2089892.10127 | 37.7181839562956 | -122.457787596334 | (37.7181839562956, -122.457787596334) | |||
| 153330 | 153330 | 214830 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 16 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5996526.30071 | 2090008.918 | 37.718567477585204 | -122.454015706561 | (37.7185674775852, -122.454015706561) | |||
| 12793 | 12793 | 13368 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 900 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X50 | 6009218.46856 | 2090025.7710400003 | 37.719333336630896 | -122.410145089137 | (37.7193333366309, -122.410145089137) | |||
| 75303 | 75303 | 213294 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 23 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995303.99589 | 2090064.66919 | 37.71865039597979 | -122.458244719016 | (37.7186503959798, -122.458244719016) | |||
| 77144 | 77144 | 213292 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 221 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5994712.31061 | 2090077.6554299998 | 37.7186520354525 | -122.46029086104299 | (37.7186520354525, -122.460290861043) | |||
| 49933 | 49933 | 78363 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 6 | 6001858.247830001 | 2090145.2543799998 | 37.719246112288104 | -122.43559512512199 | (37.7192461122881, -122.435595125122) | ||
| 131042 | 131042 | 179006 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 428 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002479.44778 | 2090313.3392900003 | 37.7197428996051 | -122.433459879172 | (37.7197428996051, -122.433459879172) | |||
| 164134 | 164134 | 179004 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 500 Paris St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001810.04061 | 2090659.99307 | 37.7206567312996 | -122.435798567961 | (37.7206567312996, -122.435798567961) | |||
| 37063 | 37063 | 213321 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5991673.594880001 | 2090710.5616 | 37.7202145769251 | -122.470840448236 | (37.7202145769251, -122.470840448236) | |||
| 161020 | 161020 | 213320 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 238 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991458.7746 | 2090762.7040099998 | 37.720345321258705 | -122.47158680100901 | (37.7203453212587, -122.471586801009) | |||
| 178772 | 178772 | 78229 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 605 Colby St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 6 | 3x9 | 6008895.81383 | 2091285.82356 | 37.7227750861924 | -122.411349358704 | (37.7227750861924, -122.411349358704) | |
| 150500 | 150500 | 214833 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 229 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995622.68342 | 2091459.3417599997 | 37.7224981435639 | -122.45724398941601 | (37.7224981435639, -122.457243989416) | |||
| 167410 | 167410 | 178992 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000617.16509 | 2091662.40232 | 37.7233412867464 | -122.43999379469601 | (37.7233412867464, -122.439993794696) | |||
| 30633 | 30633 | 95739 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 612 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767485 | 6003904.92985 | 2091757.6805900002 | 37.7237895151604 | -122.428635396826 | (37.7237895151604, -122.428635396826) |
| 48235 | 48235 | 179065 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 252 Otsego Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000349.56267 | 2091773.3269599997 | 37.7236306229466 | -122.440926797246 | (37.7236306229466, -122.440926797246) | |||
| 59095 | 59095 | 214834 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1223 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995042.942000001 | 2092029.67306 | 37.7240308230599 | -122.459289291479 | (37.7240308230599, -122.459289291479) | |||
| 150273 | 150273 | 179139 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Woolsey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011492.5608 | 2092126.86899 | 37.725229725463706 | -122.40243201763799 | (37.7252297254637, -122.402432017638) | |||
| 150817 | 150817 | 179141 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Woolsey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011519.75007 | 2092135.2288799998 | 37.7252541978079 | -122.402338614032 | (37.7252541978079, -122.402338614032) | |||
| 170516 | 170516 | 44260 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 320 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 6 | Permit Number 43692 | 6003282.08858 | 2092150.8754099999 | 37.72483387178 | -122.430816500988 | (37.72483387178, -122.430816500988) | ||
| 57991 | 57991 | 37799 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 425 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2002 12:00:00 AM | 6 | Permit Number 40126 | 6010088.32636 | 2092511.7068599998 | 37.7262079180568 | -122.407313455853 | (37.7262079180568, -122.407313455853) | |
| 152492 | 152492 | 42978 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Oxford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 6 | Permit Number 42862 | 6006544.924430001 | 2092660.29869 | 37.7264169636546 | -122.41957336651699 | (37.7264169636546, -122.419573366517) | |
| 184864 | 184864 | 42977 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 6 | Permit Number 42862 | 6006537.3191599995 | 2092680.57085 | 37.7264721982142 | -122.419601095323 | (37.7264721982142, -122.419601095323) | |
| 158488 | 158488 | 213529 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5995838.74514 | 2092736.52805 | 37.7260173993826 | -122.45658943406201 | (37.7260173993826, -122.456589434062) | |||
| 130446 | 130446 | 179096 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003433.89202 | 2092737.4210599998 | 37.7264529950076 | -122.430333563241 | (37.7264529950076, -122.430333563241) | |||
| 75395 | 75395 | 179095 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003440.96301 | 2092748.0594099998 | 37.726482606065204 | -122.430309877805 | (37.7264826060652, -122.430309877805) | |||
| 147429 | 147429 | 69497 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 55 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 6 | Permit Number 33620 | 6000865.527869999 | 2092792.12819 | 37.726457391768896 | -122.439216186893 | (37.7264573917689, -122.439216186893) | |
| 169146 | 169146 | 214757 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995633.92023 | 2092945.0693400002 | 37.7265782417753 | -122.45731257623301 | (37.7265782417753, -122.457312576233) | |||
| 173960 | 173960 | 179131 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Somerset St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009936.14207 | 2093006.65558 | 37.7275584245623 | -122.40787443765 | (37.7275584245623, -122.40787443765) | |||
| 50364 | 50364 | 74315 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 6 | 6000588.288430001 | 2093013.22945 | 37.727048705022895 | -122.440190437741 | (37.7270487050229, -122.440190437741) | ||
| 185145 | 185145 | 214786 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 34 Fairfield Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5993908.89145 | 2093024.3192599998 | 37.7266966141529 | -122.463281639244 | (37.7266966141529, -122.463281639244) | |||
| 40185 | 40185 | 62775 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 6 | Permit Number 23130 | 6000616.95925 | 2093064.6604900002 | 37.727191555121706 | -122.440095009781 | (37.7271915551217, -122.440095009781) | |
| 171241 | 171241 | 213493 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 598 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995429.76267 | 2093267.5886900001 | 37.7274520743399 | -122.45804166739401 | (37.7274520743399, -122.458041667394) | |||
| 42511 | 42511 | 214723 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995322.28894 | 2093286.2773099998 | 37.7274972131074 | -122.45841455420299 | (37.7274972131074, -122.458414554203) | |||
| 11313 | 11313 | 26979 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 538 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004789.78173 | 2093487.7597 | 37.728589968546 | -122.42569968949199 | (37.728589968546, -122.425699689492) | |||
| 74115 | 74115 | 213518 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995655.95253 | 2093561.2181099998 | 37.7282713036556 | -122.45728096594999 | (37.7282713036556, -122.45728096595) | |||
| 180844 | 180844 | 214747 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995630.96112 | 2093598.65464 | 37.72837265995471 | -122.45737006898999 | (37.7283726599547, -122.45737006899) | |||
| 75094 | 75094 | 213514 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995669.27876 | 2093647.3614400001 | 37.7285085978803 | -122.45724112599899 | (37.7285085978803, -122.457241125999) | |||
| 133914 | 133914 | 179118 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 58 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007510.59781 | 2093662.40507 | 37.7292228790136 | -122.416306013514 | (37.7292228790136, -122.416306013514) | |||
| 168043 | 168043 | 214737 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995133.12046 | 2093665.44373 | 37.7285274395723 | -122.459095949818 | (37.7285274395723, -122.459095949818) | |||
| 51756 | 51756 | 179117 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 212 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004824.04554 | 2093769.3744299999 | 37.7293651562744 | -122.4256012722 | (37.7293651562744, -122.4256012722) | |||
| 56277 | 56277 | 213696 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 123 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999234.8811 | 2093770.79632 | 37.729051660688796 | -122.444923564269 | (37.7290516606888, -122.444923564269) | |||
| 58413 | 58413 | 40675 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 191 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 6 | Permit Number 47920 | 6004642.33575 | 2093798.50545 | 37.7294348744024 | -122.42623153326099 | (37.7294348744024, -122.426231533261) | |
| 33510 | 33510 | 40676 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 191 Maynard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 6 | Permit Number 47920 | 6004632.23626 | 2093798.9275599997 | 37.7294354625595 | -122.426266478225 | (37.7294354625595, -122.426266478225) | |
| 65575 | 65575 | 214738 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 169 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995625.765869999 | 2093824.2443799998 | 37.7289917766278 | -122.457404343046 | (37.7289917766278, -122.457404343046) | |||
| 35668 | 35668 | 213507 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 170 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995650.65208 | 2093847.52813 | 37.729057137577 | -122.457319993841 | (37.729057137577, -122.457319993841) | |||
| 185440 | 185440 | 213504 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 435 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995680.74302 | 2093936.8329099999 | 37.7293040752209 | -122.457222425468 | (37.7293040752209, -122.457222425468) | |||
| 34374 | 34374 | 213557 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Valdez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5996396.856430001 | 2093987.6566700002 | 37.7294847274146 | -122.454750441903 | (37.7294847274146, -122.454750441903) | |||
| 131980 | 131980 | 213544 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996121.67701 | 2094002.3279900001 | 37.72950922315211 | -122.455702818554 | (37.7295092231521, -122.455702818554) | |||
| 160674 | 160674 | 213538 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 350 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995937.4596 | 2094121.86195 | 37.729826861018296 | -122.456348312323 | (37.7298268610183, -122.456348312323) | |||
| 88204 | 88204 | 14623 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018016.8978124 | 2094239.2837711999 | 37.7313920698281 | -122.38002451510201 | (37.7313920698281, -122.380024515102) | ||
| 145234 | 145234 | 14624 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018000.3078284 | 2094247.4364445 | 37.7314135402286 | -122.38008243669701 | (37.7314135402286, -122.380082436697) | ||
| 131343 | 131343 | 39995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 869 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2004 12:00:00 AM | 6 | 3x3 | Permit Number 47551 | 6019405.77873 | 2094282.05396 | 37.7315860320638 | -122.375225801726 | (37.7315860320638, -122.375225801726) |
| 56405 | 56405 | 213539 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1560 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995783.29259 | 2094350.88739 | 37.7304468581388 | -122.45689784037701 | (37.7304468581388, -122.456897840377) | |||
| 56599 | 56599 | 43215 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 365 Sweeny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 6 | Permit Number 43005 | 6008686.27116 | 2094503.726 | 37.731599006589704 | -122.41230103567499 | (37.7315990065897, -122.412301035675) | |
| 34178 | 34178 | 213551 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 159 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996188.75737 | 2094532.8518700001 | 37.73096976354329 | -122.455509245751 | (37.7309697635433, -122.455509245751) | |||
| 164460 | 164460 | 213550 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 167 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996175.013809999 | 2094553.95501 | 37.731026919034704 | -122.455558283981 | (37.7310269190347, -122.455558283981) | |||
| 61183 | 61183 | 213585 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996654.35387 | 2094558.3489299999 | 37.731066478420296 | -122.453901450408 | (37.7310664784203, -122.453901450408) | |||
| 55895 | 55895 | 40019 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 12 Latona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 6 | Permit Number 41264 | 6014412.91208 | 2094585.9323200001 | 37.732144413937796 | -122.392508504263 | (37.7321444139378, -122.392508504263) | |
| 44371 | 44371 | 213690 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 531 Gennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5997444.64303 | 2095159.4948599997 | 37.732762361473604 | -122.451212635762 | (37.7327623614736, -122.451212635762) | |||
| 164635 | 164635 | 214779 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1723 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5992800.25839 | 2095349.1682799999 | 37.7330161429665 | -122.467283086348 | (37.7330161429665, -122.467283086348) | |||
| 58550 | 58550 | 214789 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 385 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5995719.97757 | 2095492.23955 | 37.7335770986874 | -122.45719926076401 | (37.7335770986874, -122.457199260764) | |||
| 177253 | 177253 | 238506 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002753.72188 | 2095533.8634 | 37.7340928410181 | -122.432884572069 | (37.7340928410181, -122.432884572069) | |||
| 29842 | 29842 | 238504 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 68 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002684.617740001 | 2095553.88907 | 37.7341439071982 | -122.433124916788 | (37.7341439071982, -122.433124916788) | |||
| 163597 | 163597 | 213615 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995123.16436 | 2095604.38426 | 37.733850726423 | -122.459270720479 | (37.733850726423, -122.459270720479) | |||
| 35079 | 35079 | 213616 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995109.982340001 | 2095633.16995 | 37.733929007011206 | -122.459318378264 | (37.7339290070112, -122.459318378264) | |||
| 24659 | 24659 | 239434 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 641 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002846.37462 | 2095677.3876200002 | 37.734492180455 | -122.43257449123699 | (37.734492180455, -122.432574491237) | |||
| 61198 | 61198 | 237276 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 798 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007581.948890001 | 2095782.1901200002 | 37.7350473598298 | -122.416209418232 | (37.7350473598298, -122.416209418232) | |||
| 146555 | 146555 | 50298 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2909 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 6 | Permit Number 47009 | 5989047.4642199995 | 2095832.2551400003 | 37.734125220204604 | -122.48029267726999 | (37.7341252202046, -122.48029267727) | |
| 27986 | 27986 | 237283 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 614 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007963.94281 | 2096020.98872 | 37.7357245205556 | -122.414905620711 | (37.7357245205556, -122.414905620711) | |||
| 26326 | 26326 | 213639 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 21 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999561.36601 | 2096051.1462299998 | 37.7353315950748 | -122.44395866097099 | (37.7353315950748, -122.443958660971) | |||
| 72863 | 72863 | 213642 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 26 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999509.40434 | 2096089.3844700002 | 37.735433624051105 | -122.444141057877 | (37.7354336240511, -122.444141057877) | |||
| 174015 | 174015 | 213621 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 758 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998164.29493 | 2096098.97248 | 37.7353831217245 | -122.44879227507 | (37.7353831217245, -122.44879227507) | |||
| 149886 | 149886 | 237275 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007612.774619999 | 2096112.0363 | 37.7359547784861 | -122.416126194979 | (37.7359547784861, -122.416126194979) | |||
| 43622 | 43622 | 239460 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 134 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002209.73333 | 2096210.1693 | 37.7359189522033 | -122.43481365563801 | (37.7359189522033, -122.434813655638) | |||
| 51050 | 51050 | 196476 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2074 Revere Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6012584.77785 | 2096296.25792 | 37.7367389189762 | -122.398948809344 | (37.7367389189762, -122.398948809344) | |||
| 153474 | 153474 | 196471 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Middle Point Rd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6018269.46967 | 2096338.3756 | 37.7371696942217 | -122.379297066815 | (37.7371696942217, -122.379297066815) | |||
| 120907 | 120907 | 78998 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450X Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 6 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 135523 | 135523 | 237342 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 475 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007557.00859 | 2096600.77561 | 37.737293613604706 | -122.41635360743 | (37.7372936136047, -122.41635360743) | |||
| 172744 | 172744 | 196477 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 3ft | 6012648.615180001 | 2096647.7620400002 | 37.7377076327033 | -122.39875275533501 | (37.7377076327033, -122.398752755335) | |||
| 68810 | 68810 | 237278 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 478 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007846.81653 | 2096648.9824 | 37.737442271546996 | -122.415355016422 | (37.737442271547, -122.415355016422) | |||
| 50623 | 50623 | 239509 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 444 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008753.78485 | 2096712.524 | 37.737667676711794 | -122.412223680483 | (37.7376676767118, -122.412223680483) |
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");