Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187913 | 187913 | 196376 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012181.9653199995 | 2112407.5214 | 37.780954438148704 | -122.40147347253999 | (37.7809544381487, -122.40147347254) | |||
| 184862 | 184862 | 196379 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012397.66121 | 2112347.77768 | 37.7808024284316 | -122.400723071038 | (37.7808024284316, -122.400723071038) | |||
| 184353 | 184353 | 196416 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 74 Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010037.74833 | 2110859.1244200002 | 37.776583030628295 | -122.408782138683 | (37.7765830306283, -122.408782138683) | |||
| 179436 | 179436 | 135891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2398 North Point St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 5999308.28669 | 2120504.72693 | 37.802460509893606 | -122.44659245147301 | (37.8024605098936, -122.446592451473) | |||
| 179102 | 179102 | 196398 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011290.67787 | 2111282.0901599997 | 37.7778144947827 | -122.404477648835 | (37.7778144947827, -122.404477648835) | |||
| 178587 | 178587 | 183559 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1616 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987905.5766 | 2097633.8663 | 37.7390055533414 | -122.484372584152 | (37.7390055533414, -122.484372584152) | |||
| 177236 | 177236 | 178894 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 38 Curtis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000524.98993 | 2088394.3572900002 | 37.714362726143 | -122.44007819877 | (37.714362726143, -122.44007819877) | |||
| 177156 | 177156 | 196391 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013949.37152 | 2112913.94153 | 37.7824434087757 | -122.395394585209 | (37.7824434087757, -122.395394585209) | |||
| 173783 | 173783 | 214446 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 500 Magellan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993157.34712 | 2099454.9185599997 | 37.744310110719205 | -122.46634683724 | (37.7443101107192, -122.46634683724) | |||
| 172215 | 172215 | 135896 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4 Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6006986.1238400005 | 2115548.09953 | 37.7892864176805 | -122.419671386337 | (37.7892864176805, -122.419671386337) | |||
| 171955 | 171955 | 96275 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 55@ Alemany Trumbull St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6003967.5577300005 | 2094330.4049099998 | 37.73085718729 | -122.428602205549 | (37.73085718729, -122.428602205549) | ||||
| 165001 | 165001 | 139978 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1002 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001945.5177 | 2111990.8232 | 37.7792338137079 | -122.436856496835 | (37.7792338137079, -122.436856496835) | |||
| 163418 | 163418 | 48665 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1715REVISED Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | 2 | Permit Number 45950 | 6004834.5382 | 2115307.6761 | 37.7885048406598 | -122.42709848948799 | (37.7885048406598, -122.427098489488) | |
| 162852 | 162852 | 140802 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 JORDAN AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5996233.7192 | 2113991.8267 | 37.7844017542187 | -122.45676060516199 | (37.7844017542187, -122.456760605162) | |||
| 161927 | 161927 | 214476 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 270 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5998285.21453 | 2093571.32939 | 37.7284497264529 | -122.448192264458 | (37.7284497264529, -122.448192264458) | ||||
| 160478 | 160478 | 138981 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 431 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005467.783 | 2110751.9814 | 37.7760318136474 | -122.42458336578999 | (37.7760318136474, -122.42458336579) | |||
| 158937 | 158937 | 214443 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991170.54389 | 2101147.50148 | 37.7488426659675 | -122.473340138153 | (37.7488426659675, -122.473340138153) | |||
| 157232 | 157232 | 238013 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 77 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999618.479619999 | 2106729.8577400004 | 37.764656004003 | -122.44452844265899 | (37.764656004003, -122.444528442659) | |||
| 157201 | 157201 | 139388 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 432 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005550.9106 | 2110887.2787 | 37.776408001399496 | -122.42430543018601 | (37.7764080013995, -122.424305430186) | |||
| 156919 | 156919 | 196387 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013895.88765 | 2112864.3036700003 | 37.782304139751794 | -122.39557613855301 | (37.7823041397518, -122.395576138553) | |||
| 155982 | 155982 | 245875 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 230 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001285.051 | 2109638.8769 | 37.772738401980604 | -122.438972719673 | (37.7727384019806, -122.438972719673) | |||
| 154431 | 154431 | 178903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011814.45609 | 2090752.0893599999 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | |||
| 153974 | 153974 | 214453 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 195 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994424.22111 | 2100746.43892 | 37.7479293180792 | -122.462059929142 | (37.7479293180792, -122.462059929142) | |||
| 151338 | 151338 | 182066 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1383 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988020.5944 | 2105839.0631 | 37.761541526107 | -122.48457660662399 | (37.761541526107, -122.484576606624) | |||
| 150387 | 150387 | 196421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010097.257019999 | 2110794.49543 | 37.776408907491 | -122.408571719809 | (37.776408907491, -122.408571719809) | |||
| 149261 | 149261 | 142760 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010826.0266 | 2120017.8226 | 37.8017747502564 | -122.406700835434 | (37.8017747502564, -122.406700835434) | |||
| 147197 | 147197 | 139395 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 486 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005025.4278 | 2111110.8954 | 37.7769923120329 | -122.426139147688 | (37.7769923120329, -122.426139147688) | |||
| 143597 | 143597 | 119811 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 250 Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
| 143514 | 143514 | 4029 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2150 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) | ||
| 143410 | 143410 | 41856 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1001 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | ||
| 141980 | 141980 | 37295 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 286 Cumberland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39824 | 6003747.0165405 | 2104527.26651018 | 37.758842925599396 | -122.430091793701 | (37.7588429255994, -122.430091793701) | ||
| 141926 | 141926 | 40944 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88209 Hoff St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1999 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.76357769940321 | -122.42054143219102 | (37.7635776994032, -122.420541432191) | |||
| 141416 | 141416 | 11200 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 186 Idora Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5995344.6608195 | 2099448.7962231003 | 37.74441926622529 | -122.45878317784799 | (37.7444192662253, -122.458783177848) | |||
| 141213 | 141213 | 52530 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 San Juan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48628 | 6001389.835788901 | 2092264.63848184 | 37.725038846492794 | -122.43736592524701 | (37.7250388464928, -122.437365925247) | ||
| 141140 | 141140 | 47334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 Garfield St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45265 | 5993656.96278859 | 2090531.97182441 | 37.719838715813104 | -122.463971702484 | (37.7198387158131, -122.463971702484) | ||
| 140278 | 140278 | 116700 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1X CARRIE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002805.0 | 2095529.0 | 37.734082395521895 | -122.43270694044399 | (37.7340823955219, -122.432706940444) | ||||
| 139535 | 139535 | 32140 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 618 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35496 | 6004564.35276407 | 2110630.82762794 | 37.7756480927458 | -122.42769993653499 | (37.7756480927458, -122.427699936535) | |||
| 138531 | 138531 | 91340 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 829 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100.0 | 2112601.0 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | ||
| 138307 | 138307 | 37889 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1301 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1998 12:00:00 AM | Permit Number 40164 | 5995819.25622169 | 2092686.22988595 | 37.725878173698796 | -122.45665316971001 | (37.7258781736988, -122.45665316971) | |||
| 137794 | 137794 | 142584 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2232 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6008967.5673 | 2120856.1596 | 37.803972458794796 | -122.41319130359699 | (37.8039724587948, -122.413191303597) | |||
| 136440 | 136440 | 247321 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 216 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002799.395 | 2109324.8498 | 37.771962206126794 | -122.433711993285 | (37.7719622061268, -122.433711993285) | |||
| 132824 | 132824 | 237988 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005544.33972 | 2096386.4343299998 | 37.736591695453896 | -122.42329710838001 | (37.7365916954539, -122.42329710838) | |||
| 131720 | 131720 | 238018 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5999581.71277 | 2106854.10087 | 37.7649950466081 | -122.444664539759 | (37.7649950466081, -122.444664539759) | |||
| 127506 | 127506 | 119859 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 431 Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 127304 | 127304 | 39161 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 301x Cumberland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40829 | 6003629.0 | 2104450.0 | 37.758624085440104 | -122.43049443639099 | (37.7586240854401, -122.430494436391) | ||
| 126193 | 126193 | 50547 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 60 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180.0 | 2099188.0 | 37.74432002092679 | -122.421298240567 | (37.7443200209268, -122.421298240567) | |||
| 124282 | 124282 | 36360 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 131 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39315 | 5995616.87742593 | 2093562.88394601 | 37.728273633305996 | -122.45741616982401 | (37.728273633306, -122.457416169824) | ||
| 123312 | 123312 | 42439 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 550 Judson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42584 | 5996829.49530885 | 2093648.57745681 | 37.7285785035344 | -122.45323030571801 | (37.7285785035344, -122.453230305718) | ||
| 123189 | 123189 | 37285 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 699 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39818 | 6002432.10165251 | 2104152.77929012 | 37.757740114019 | -122.434612596377 | (37.757740114019, -122.434612596377) | |||
| 122585 | 122585 | 46333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 201 Lily St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2002 12:00:00 AM | Permit Number 44582 | 6005568.06039934 | 2110039.04677053 | 37.7740799306106 | -122.42418576450599 | (37.7740799306106, -122.424185764506) | ||
| 122559 | 122559 | 49139 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Westwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46263 | 5995223.85849165 | 2092714.15560614 | 37.7259206476516 | -122.458713425318 | (37.7259206476516, -122.458713425318) | ||
| 121773 | 121773 | 4025 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1900 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/25/2015 03:01:00 PM | 3 | 3X3 | 6013444.007912099 | 2101040.051797 | 37.7498122193832 | -122.39631044368099 | (37.7498122193832, -122.396310443681) | ||
| 121592 | 121592 | 37267 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
| 121128 | 121128 | 39754 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 183 Hancock St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41121 | 6003118.27900273 | 2105026.07032459 | 37.7601768917443 | -122.432301882241 | (37.7601768917443, -122.432301882241) | ||
| 121025 | 121025 | 111845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1550 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||
| 120573 | 120573 | 40228 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 101 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | |||
| 120418 | 120418 | 36384 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 701 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965563998 | 37.725848495794395 | -122.459920281258 | (37.7258484957944, -122.459920281258) | ||
| 119894 | 119894 | 36423 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39337 | 5996091.95170793 | 2094186.31684288 | 37.7300127063789 | -122.455818876187 | (37.7300127063789, -122.455818876187) | |||
| 119096 | 119096 | 36426 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 301 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39338 | 5996108.64471019 | 2094137.0690645 | 37.729878441846104 | -122.455757608246 | (37.7298784418461, -122.455757608246) | |||
| 118168 | 118168 | 135902 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6008341.98532 | 2119430.34352 | 37.8000223848775 | -122.415255184482 | (37.8000223848775, -122.415255184482) | ||||
| 117113 | 117113 | 103651 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 307X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |
| 116072 | 116072 | 43862 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2345 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43481 | 5985730.68059538 | 2097009.14058612 | 37.7371633406591 | -122.491846290454 | (37.7371633406591, -122.491846290454) | ||
| 115915 | 115915 | 40512 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 445 Darien Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41576 | 5992747.41981015 | 2094935.12337926 | 37.7318762282888 | -122.46743566386299 | (37.7318762282888, -122.467435663863) | ||
| 115696 | 115696 | 40388 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 706 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41499 | 5994916.05908376 | 2092743.92651485 | 37.725984695353105 | -122.459779615207 | (37.7259846953531, -122.459779615207) | ||
| 115422 | 115422 | 36368 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 143 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39319 | 5995629.61458477 | 2093656.01088528 | 37.7285300690508 | -122.457378871767 | (37.7285300690508, -122.457378871767) | ||
| 115038 | 115038 | 116014 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 469 PACHECO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 5993702.0 | 2101802.0 | 37.7507860118971 | -122.464633955158 | (37.7507860118971, -122.464633955158) | ||||
| 114564 | 114564 | 32169 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 114011 | 114011 | 32382 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
| 112820 | 112820 | 121653 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 306 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993098.0 | 2103247.0 | 37.7547187703987 | -122.466827655897 | (37.7547187703987, -122.466827655897) | ||||
| 112492 | 112492 | 119852 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 331 Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 112419 | 112419 | 110545 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2x LILY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6006369.0 | 2110405.0 | 37.775129941044604 | -122.421441165405 | (37.7751299410446, -122.421441165405) | ||||
| 111078 | 111078 | 32925 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 338 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | 3x3 | Permit Number 37251 | 5993527.89393066 | 2105989.81652966 | 37.7622746341272 | -122.465540224747 | (37.7622746341272, -122.465540224747) | |
| 110660 | 110660 | 99280 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 230 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001309.9 | 2109637.7 | 37.7727365843062 | -122.43888668006001 | (37.7727365843062, -122.43888668006) | |||||
| 109355 | 109355 | 119876 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 450X Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 108079 | 108079 | 119843 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 107925 | 107925 | 119597 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 431 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005470.0 | 2110737.0 | 37.7759908035691 | -122.42457463067 | (37.7759908035691, -122.42457463067) | ||||
| 107704 | 107704 | 37692 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 562 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40078 | 6007845.87669797 | 2104655.5935128 | 37.759426574444106 | -122.415925080154 | (37.7594265744441, -122.415925080154) | ||
| 107585 | 107585 | 45063 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2101 27th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2001 12:00:00 AM | Permit Number 43947 | 5987870.53797958 | 2100985.88306806 | 37.748207264307496 | -122.484739557427 | (37.7482072643075, -122.484739557427) | |||
| 106645 | 106645 | 34098 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37974 | 5995414.643408099 | 2093328.34737639 | 37.727618034343706 | -122.45809832977899 | (37.7276180343437, -122.458098329779) | |||
| 105582 | 105582 | 44167 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Sycamore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | Permit Number 43637 | 6006615.48283376 | 2105833.54152838 | 37.762591694443294 | -122.420263998944 | (37.7625916944433, -122.420263998944) | |||
| 105211 | 105211 | 84787 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Corbett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | Permit No. 49308 | 5999615.8 | 2105217.4 | 37.76050301831479 | -122.444429006349 | (37.7605030183148, -122.444429006349) | |||
| 104740 | 104740 | 42036 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42358 | 6004596.89230657 | 2098983.86286022 | 37.7436701266667 | -122.42675775960501 | (37.7436701266667, -122.426757759605) | |||
| 103494 | 103494 | 2455 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1801X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 18 | 4X4 | 6003961.1396892 | 2114603.1916159 | 37.786521075947796 | -122.430070036959 | (37.7865210759478, -122.430070036959) | ||
| 102813 | 102813 | 35300 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3459 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/1998 12:00:00 AM | Permit Number 38773 | 6005812.46547868 | 2106053.59345559 | 37.763150623964 | -122.423056990755 | (37.763150623964, -122.423056990755) | |||
| 100849 | 100849 | 41304 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1387 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2000 12:00:00 AM | Permit Number 41977 | 6006476.01966821 | 2101521.23564445 | 37.7507432410359 | -122.420440247305 | (37.7507432410359, -122.420440247305) | |||
| 100074 | 100074 | 43904 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) |
| 98609 | 98609 | 42762 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |||
| 97850 | 97850 | 97824 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 595X Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6002402.0 | 2104748.0 | 37.7593727378271 | -122.434759263601 | (37.7593727378271, -122.434759263601) | |||
| 96807 | 96807 | 48495 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 688(REVISED) Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45836 | 6008651.5358149 | 2098064.55146278 | 37.7413743105027 | -122.412672757895 | (37.7413743105027, -122.412672757895) | |||
| 96725 | 96725 | 109157 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2016 12:00:00 AM | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | |||
| 96310 | 96310 | 34129 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1401 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37983 | 5995840.26429469 | 2093321.75315516 | 37.7276243745144 | -122.45662648597799 | (37.7276243745144, -122.456626485978) | ||
| 94182 | 94182 | 117166 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 93746 | 93746 | 31921 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.47136143824699 | (37.7451690123809, -122.471361438247) | ||
| 93484 | 93484 | 42563 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 201 San Benito Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42649 | 5992910.18577839 | 2095362.95085697 | 37.7330603317539 | -122.46690404336 | (37.7330603317539, -122.46690404336) | ||
| 93317 | 93317 | 93179 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 290 Maple St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651.0 | 2115280.0 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | ||
| 92723 | 92723 | 107754 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 400X Lily St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | |||||
| 90463 | 90463 | 37879 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 591 Flood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40158 | 5996748.50508252 | 2094082.2355121998 | 37.7297645826714 | -122.45354159093701 | (37.7297645826714, -122.453541590937) | ||
| 89242 | 89242 | 50787 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6900 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2004 12:00:00 AM | Permit Number 47313 | 5985644.2903515 | 2112526.34575893 | 37.7797642444003 | -122.493287836243 | (37.7797642444003, -122.493287836243) | |||
| 89222 | 89222 | 89359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 308 Tocoloma Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50704 | 6012556.9 | 2087009.2 | 37.7112369933076 | -122.39839375585301 | (37.7112369933076, -122.398393755853) | ||
| 88018 | 88018 | 46638 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 670 Victoria St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2002 12:00:00 AM | Permit Number 44768 | 5993413.9529017 | 2091571.4332661 | 37.7226788173129 | -122.46488714503201 | (37.7226788173129, -122.464887145032) |
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");