Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 68911 | 68911 | 175196 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 149 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6002904.026380001 | 2092823.59155 | 37.7266595719653 | -122.432171435767 | (37.7266595719653, -122.432171435767) | |||
| 159561 | 159561 | 175214 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 728 Burrows St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6009081.49175 | 2092873.82998 | 37.7271458291085 | -122.410819605863 | (37.7271458291085, -122.410819605863) | |||
| 5123 | 5123 | 175078 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1584 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001809.644719999 | 2092991.8257799998 | 37.7270593952569 | -122.435966703417 | (37.7270593952569, -122.435966703417) | |||
| 10544 | 10544 | 52929 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 22 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48913 | 6002555.71096 | 2093126.63865 | 37.727471916095205 | -122.433397195531 | (37.7274719160952, -122.433397195531) |
| 68452 | 68452 | 175211 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 66 Madison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6005436.48818 | 2093200.6412400003 | 37.7278381272226 | -122.423443582752 | (37.7278381272226, -122.423443582752) | |||
| 29783 | 29783 | 175207 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 9 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6005359.84242 | 2093211.4983700002 | 37.7278636122004 | -122.423709320725 | (37.7278636122004, -122.423709320725) | |||
| 106142 | 106142 | 67911 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 66 Marston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31614 | 5998875.49490681 | 2093226.9126308 | 37.7275377658836 | -122.44612687983299 | (37.7275377658836, -122.446126879833) | ||
| 33071 | 33071 | 175210 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 66 Madison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6005427.44885 | 2093231.2859200002 | 37.72792176057511 | -122.423477009653 | (37.7279217605751, -122.423477009653) | |||
| 76285 | 76285 | 175208 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 9 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6005371.81589 | 2093231.8898099998 | 37.727920278496 | -122.423669377345 | (37.727920278496, -122.423669377345) | |||
| 75821 | 75821 | 68256 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 243 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 16 | Permit Number 32061 | 6009551.9423 | 2093241.4503 | 37.7281816043806 | -122.40921918673901 | (37.7281816043806, -122.409219186739) | |
| 173232 | 173232 | 175209 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 9 Athens St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6005385.77988 | 2093250.96165 | 37.727973433805204 | -122.423622458831 | (37.7279734338052, -122.423622458831) | |||
| 161829 | 161829 | 203565 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 33 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993248.53272 | 2093275.53129 | 37.727348315068205 | -122.46558270220699 | (37.7273483150682, -122.465582702207) | |||
| 75371 | 75371 | 70397 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 130 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 21 | 6006350.25387 | 2093285.0007900002 | 37.7281212922586 | -122.420290654116 | (37.7281212922586, -122.420290654116) | ||
| 187464 | 187464 | 70495 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 41 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 8 | 6004160.9944400005 | 2093317.3094099998 | 37.728086398555206 | -122.427861302663 | (37.7280863985552, -122.427861302663) | ||
| 38546 | 38546 | 70527 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 25 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 7 | 6004201.75826 | 2093380.3315400002 | 37.728261749270395 | -122.427724869209 | (37.7282617492704, -122.427724869209) | ||
| 146423 | 146423 | 95109 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 615 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 9 | 3x3 | Permit Number 54038 | 6001824.30736 | 2093468.5255200001 | 37.7283691373029 | -122.43595011001301 | (37.7283691373029, -122.435950110013) |
| 48862 | 48862 | 203590 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999238.54402 | 2093513.75556 | 37.728346095777205 | -122.444892431558 | (37.7283460957772, -122.444892431558) | |||
| 87275 | 87275 | 67908 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31611 | 5999270.9302444 | 2093516.90049213 | 37.728356579287706 | -122.44478069728001 | (37.7283565792877, -122.44478069728) | ||
| 139191 | 139191 | 68818 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32765 | 5999442.86322085 | 2093551.99082798 | 37.7284627395009 | -122.44418883965099 | (37.7284627395009, -122.444188839651) | ||
| 75174 | 75174 | 203585 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5999428.77785 | 2093578.76175 | 37.7285354426355 | -122.444239456297 | (37.7285354426355, -122.444239456297) | |||
| 160814 | 160814 | 65231 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 812 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | 10 | Permit Number 28018 | 6008328.075 | 2093605.1534799999 | 37.7291116131036 | -122.41347586773001 | (37.7291116131036, -122.41347586773) | ||
| 154866 | 154866 | 38552 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1820 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 16 | Permit Number 40520 | 6015364.9925 | 2093693.5794 | 37.729747018873205 | -122.389154637038 | (37.7297470188732, -122.389154637038) | |
| 44597 | 44597 | 203581 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 24 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5997456.8868 | 2093709.9818900002 | 37.7287830449036 | -122.451065815142 | (37.7287830449036, -122.451065815142) | |||
| 177216 | 177216 | 203582 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 24 Gennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5997457.41638 | 2093726.64675 | 37.7288288329774 | -122.451065185614 | (37.7288288329774, -122.451065185614) | |||
| 118302 | 118302 | 87374 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 149 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50353 | 5999085.2 | 2093741.7 | 37.7289632252792 | -122.445438930282 | (37.7289632252792, -122.445438930282) | |||
| 186748 | 186748 | 203583 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 24 Gennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997456.92965 | 2093746.9579099999 | 37.72888457474001 | -122.45106833235901 | (37.72888457474, -122.451068332359) | |||
| 76869 | 76869 | 203588 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 77 Staples Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5999527.8711 | 2093756.3356599999 | 37.729028672217005 | -122.443909639833 | (37.729028672217, -122.443909639833) | |||
| 54020 | 54020 | 203587 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 77 Staples Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 39 | Width 3ft | 5999512.80503 | 2093756.92182 | 37.7290294222638 | -122.443961766319 | (37.7290294222638, -122.443961766319) | |||
| 68860 | 68860 | 203586 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 77 Staples Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 5999493.48314 | 2093757.18666 | 37.729029047242605 | -122.444028582376 | (37.7290290472426, -122.444028582376) | |||
| 143041 | 143041 | 67515 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 179 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | Permit Number 31051 | 5998906.63498153 | 2093763.92891486 | 37.729014065318395 | -122.44605783860099 | (37.7290140653184, -122.446057838601) | ||
| 91929 | 91929 | 203584 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 391 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 5ft | 5997518.2723 | 2093790.63155 | 37.729008004011 | -122.450859415354 | (37.729008004011, -122.450859415354) | |||
| 168106 | 168106 | 203589 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 50 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 5999730.96004 | 2093799.89189 | 37.729159850032396 | -122.443210675031 | (37.7291598500324, -122.443210675031) | |||
| 81824 | 81824 | 68866 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 50 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32829 | 5999664.63009036 | 2093804.62136616 | 37.72916905360999 | -122.44344032201401 | (37.72916905361, -122.443440322014) | ||
| 96756 | 96756 | 97554 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 250@Flood Detroit St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 42524 | 5999434.0 | 2093931.0 | 37.7295029047189 | -122.444246704733 | (37.7295029047189, -122.444246704733) | ||||
| 98137 | 98137 | 97552 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 250@Flood Detroit St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 42524 | 5999434.0 | 2093931.0 | 37.7295029047189 | -122.444246704733 | (37.7295029047189, -122.444246704733) | ||||
| 110715 | 110715 | 97553 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 250@Flood Detroit St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 42524 | 5999434.0 | 2093931.0 | 37.7295029047189 | -122.444246704733 | (37.7295029047189, -122.444246704733) | ||||
| 76297 | 76297 | 203550 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 181 Flood Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999525.01063 | 2094056.66117 | 37.72985313291311 | -122.443941098101 | (37.7298531329131, -122.443941098101) | |||
| 70493 | 70493 | 203552 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 181 Flood Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5999546.8407 | 2094056.9301900002 | 37.7298551168086 | -122.443865648605 | (37.7298551168086, -122.443865648605) | |||
| 169525 | 169525 | 203551 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 181 Flood Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5999536.14329 | 2094057.1534 | 37.7298551194964 | -122.44390264669201 | (37.7298551194964, -122.443902646692) | |||
| 178211 | 178211 | 203549 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 181 Flood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5999506.567319999 | 2094057.55855 | 37.7298545448296 | -122.444004922987 | (37.7298545448296, -122.444004922987) | |||
| 136914 | 136914 | 203547 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 181 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5999467.7352599995 | 2094058.60837 | 37.7298552121426 | -122.444139244847 | (37.7298552121426, -122.444139244847) | |||
| 39283 | 39283 | 203548 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 181 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999484.36005 | 2094058.99303 | 37.7298572167403 | -122.44408179885401 | (37.7298572167403, -122.444081798854) | |||
| 77309 | 77309 | 97549 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 199x FLOOD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | Permit Number 42524 | 5999753.0 | 2094070.0 | 37.729902760805295 | -122.443153872698 | (37.7299027608053, -122.443153872698) | ||
| 114495 | 114495 | 97551 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 199x FLOOD AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 42524 | 5999753.0 | 2094070.0 | 37.729902760805295 | -122.443153872698 | (37.7299027608053, -122.443153872698) | ||||
| 125834 | 125834 | 97550 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 199x FLOOD AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 42524 | 5999753.0 | 2094070.0 | 37.729902760805295 | -122.443153872698 | (37.7299027608053, -122.443153872698) | ||
| 99240 | 99240 | 67506 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 431 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1992 12:00:00 AM | Permit Number 31036 | 5997894.54403764 | 2094074.0284741002 | 37.7298076778319 | -122.449579034013 | (37.7298076778319, -122.449579034013) | ||
| 176258 | 176258 | 203546 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 431 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 2ft | 5997874.7531 | 2094083.7013400001 | 37.729833105003294 | -122.44964814996099 | (37.7298331050033, -122.449648149961) | |||
| 55437 | 55437 | 203580 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 5999938.98985 | 2094086.49898 | 37.7299586665457 | -122.442512069977 | (37.7299586665457, -122.442512069977) | |||
| 163037 | 163037 | 203545 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 521 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997305.75976 | 2094091.3285 | 37.7298214785687 | -122.451615764982 | (37.7298214785687, -122.451615764982) | |||
| 91622 | 91622 | 68831 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32782 | 5999950.39080564 | 2094093.84509942 | 37.729979487143 | -122.442473182831 | (37.729979487143, -122.442473182831) | ||
| 168814 | 168814 | 82830 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1475 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52467 | 6015906.1825 | 2094100.414 | 37.7308940918936 | -122.387312034756 | (37.7308940918936, -122.387312034756) | |
| 99396 | 99396 | 68849 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 230 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32812 | 5999215.30905725 | 2094104.51871766 | 37.7299668673625 | -122.44501520736 | (37.7299668673625, -122.44501520736) | ||
| 179857 | 179857 | 38581 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1483 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 15 | Permit Number 40541 | 6015866.8585 | 2094128.4257 | 37.7309688285238 | -122.38744993888399 | (37.7309688285238, -122.387449938884) | |
| 46056 | 46056 | 203567 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 209 Colon Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5996068.02094 | 2094221.27645 | 37.7301073235953 | -122.455904133578 | (37.7301073235953, -122.455904133578) | |||
| 153630 | 153630 | 203566 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 209 Colon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5996063.41122 | 2094232.8960099998 | 37.7301389635391 | -122.455920909543 | (37.7301389635391, -122.455920909543) | |||
| 32014 | 32014 | 35736 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 351 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | 9 | Permit Number 39011 | 6008805.61164 | 2094302.44729 | 37.731053034462 | -122.411874232722 | (37.731053034462, -122.411874232722) | |
| 175246 | 175246 | 35737 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 351 Hale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | 11 | Permit Number 39011 | 6008822.29863 | 2094308.6261200001 | 37.731070936367296 | -122.411816979173 | (37.7310709363673, -122.411816979173) | |
| 88212 | 88212 | 95120 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 67 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54047 | 6002640.0 | 2094338.0 | 37.730802821842204 | -122.43319232563101 | (37.7308028218422, -122.433192325631) | |
| 130119 | 130119 | 203536 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 347 Hearst Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 5999101.320719999 | 2094349.11818 | 37.730631973677795 | -122.445426858158 | (37.7306319736778, -122.445426858158) | |||
| 30513 | 30513 | 203538 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 313 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5999326.9827 | 2094355.3161799998 | 37.7306618716326 | -122.444647158563 | (37.7306618716326, -122.444647158563) | |||
| 136489 | 136489 | 203537 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 313 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5999311.412769999 | 2094355.91227 | 37.7306626198655 | -122.44470102883001 | (37.7306626198655, -122.44470102883) | |||
| 48562 | 48562 | 95121 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 68 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54048 | 6002661.0 | 2094358.0 | 37.730858928558895 | -122.433121153797 | (37.7308589285589, -122.433121153797) | |
| 183001 | 183001 | 203539 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 350 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5999078.20964 | 2094394.83884 | 37.7307561925253 | -122.445510042754 | (37.7307561925253, -122.445510042754) | |||
| 115853 | 115853 | 108890 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 350 Hearst Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773349 | 5999093.24367 | 2094395.39174 | 37.7307585689262 | -122.445458107682 | (37.7307585689262, -122.445458107682) | |
| 173770 | 173770 | 203541 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 510 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5998007.81838 | 2094409.8522599998 | 37.7307362500822 | -122.449211618134 | (37.7307362500822, -122.449211618134) | |||
| 49330 | 49330 | 203542 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 518 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5997986.70851 | 2094410.2920099997 | 37.7307362500736 | -122.449284629593 | (37.7307362500736, -122.449284629593) | |||
| 172538 | 172538 | 203543 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 518 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997969.26989 | 2094410.6553 | 37.730736250080795 | -122.449344943519 | (37.7307362500808, -122.449344943519) | |||
| 44268 | 44268 | 203544 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 522 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 5997938.28847 | 2094411.0721200001 | 37.730735622335 | -122.449452080662 | (37.730735622335, -122.449452080662) | |||
| 18634 | 18634 | 67500 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 518 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1997 12:00:00 AM | Permit Number 31028 | 5997975.78487802 | 2094419.07569222 | 37.7307597431483 | -122.449323026732 | (37.7307597431483, -122.449323026732) | ||
| 30945 | 30945 | 203540 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 305 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5998091.5711199995 | 2094441.2535 | 37.7308272605603 | -122.448924334186 | (37.7308272605603, -122.448924334186) | |||
| 48208 | 48208 | 70645 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 67 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 4 | 6002626.20323 | 2094469.32888 | 37.7311626384362 | -122.433249403638 | (37.7311626384362, -122.433249403638) | ||
| 46801 | 46801 | 175192 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 63 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002620.39107 | 2094490.53041 | 37.731220523295896 | -122.433271011664 | (37.7312205232959, -122.433271011664) | |||
| 114872 | 114872 | 55367 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 166 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1996 12:00:00 AM | Permit Number 11301 | 5993332.6421826 | 2094501.86251048 | 37.730720369862 | -122.46538098284799 | (37.730720369862, -122.465380982848) | ||
| 86941 | 86941 | 40424 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 175 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2016 12:00:00 AM | 3 | Permit Number 778380 | 5996165.75170379 | 2094545.8989408 | 37.7310042675093 | -122.45558972239401 | (37.7310042675093, -122.455589722394) | |
| 186592 | 186592 | 175215 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 857 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 8ft | 6010301.67863 | 2094727.3315700002 | 37.7323034959049 | -122.406731980322 | (37.7323034959049, -122.406731980322) | |||
| 128213 | 128213 | 66317 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 125 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29434 | 6001244.97910985 | 2094913.4211356998 | 37.732303560745 | -122.43805632811899 | (37.732303560745, -122.438056328119) | ||
| 100555 | 100555 | 38954 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 293 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2008 12:00:00 AM | 3x3 | Permit Number 50374 | 6000154.66929043 | 2094929.77821336 | 37.73228640687 | -122.441826941763 | (37.73228640687, -122.441826941763) | ||
| 70674 | 70674 | 203574 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 32 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6001891.78226 | 2094951.9742400001 | 37.7324461814313 | -122.435822942293 | (37.7324461814313, -122.435822942293) | |||
| 136513 | 136513 | 203573 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 22 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6001918.411230001 | 2094952.2854099998 | 37.7324485484508 | -122.435730902059 | (37.7324485484508, -122.435730902059) | |||
| 93851 | 93851 | 66313 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 22 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29428 | 6001939.09148098 | 2094954.61972241 | 37.7324561325978 | -122.43565957260401 | (37.7324561325978, -122.435659572604) | ||
| 129125 | 129125 | 66314 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 32 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29429 | 6001885.6486627 | 2094955.45184976 | 37.7324553817298 | -122.43584439628599 | (37.7324553817298, -122.435844396286) | ||
| 91063 | 91063 | 66304 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 400 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | 3x50 | Permit Number 29418 | 6000123.45614997 | 2094964.38431909 | 37.732379648564 | -122.44193733536999 | (37.732379648564, -122.44193733537) | |
| 36093 | 36093 | 203577 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 268 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6000290.88836 | 2094968.3024400002 | 37.7323999463844 | -122.44135876589701 | (37.7323999463844, -122.441358765897) | |||
| 154528 | 154528 | 203578 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 312 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5999939.80462 | 2094974.46238 | 37.7323968536154 | -122.442572982852 | (37.7323968536154, -122.442572982852) | |||
| 84626 | 84626 | 66322 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 268 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | Permit Number 29439 | 6000307.14957074 | 2094979.56664824 | 37.7324318016212 | -122.441303355183 | (37.7324318016212, -122.441303355183) | ||
| 114578 | 114578 | 66323 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 274 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | Permit Number 29440 | 6000269.21852417 | 2094980.11816522 | 37.7324311551198 | -122.441434530926 | (37.7324311551198, -122.441434530926) | ||
| 168569 | 168569 | 203579 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 312 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 5999939.25303 | 2094981.39881 | 37.7324158679899 | -122.44257538767 | (37.7324158679899, -122.44257538767) | |||
| 11336 | 11336 | 97263 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 220 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773740 | 6009330.61336 | 2094994.9708200002 | 37.732983995812795 | -122.41010807752599 | (37.7329839958128, -122.410108077526) | |
| 55095 | 55095 | 221838 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004035.0330300005 | 2095100.1710299999 | 37.732974610471395 | -122.42842377735 | (37.7329746104714, -122.42842377735) | |||
| 44826 | 44826 | 53159 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1747@ 3RD ST Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 13 | Permit Number 49080 | 6014484.905180001 | 2095154.52732 | 37.733709657875295 | -122.392299359741 | (37.7337096578753, -122.392299359741) | |
| 165262 | 165262 | 53160 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1747@ 3RD ST Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 8 | Permit Number 49080 | 6014477.38224 | 2095160.1105 | 37.73372457041361 | -122.39232575933201 | (37.7337245704136, -122.392325759332) | |
| 84363 | 84363 | 94666 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53803 | 6004020.0 | 2095225.0 | 37.7333165119994 | -122.428484644893 | (37.7333165119994, -122.428484644893) | |
| 36231 | 36231 | 203575 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 60 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6001009.56246 | 2095231.0134 | 37.7331622045591 | -122.438892966938 | (37.7331622045591, -122.438892966938) | |||
| 180394 | 180394 | 203576 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 404 Baden St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6000769.77181 | 2095296.00897 | 37.7333270215234 | -122.439726643888 | (37.7333270215234, -122.439726643888) | ||||
| 21771 | 21771 | 27336 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 615 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2000 12:00:00 AM | 3 | 2X3 | 6002282.10236 | 2095328.3579400002 | 37.7335018092598 | -122.434500417276 | (37.7335018092598, -122.434500417276) | ||
| 85384 | 85384 | 59441 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 98 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1980 12:00:00 AM | Permit Number 18804 | 6004258.919079901 | 2095333.58373446 | 37.7336281759245 | -122.42766636908001 | (37.7336281759245, -122.42766636908) | |||
| 70620 | 70620 | 221840 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 98 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 6004312.44121 | 2095336.44977 | 37.733639072774295 | -122.42748153156602 | (37.7336390727743, -122.427481531566) | |||
| 176883 | 176883 | 221839 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 98 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6004329.201169999 | 2095336.9528400002 | 37.733641402021796 | -122.42742362331002 | (37.7336414020218, -122.42742362331) | |||
| 150869 | 150869 | 221841 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 5 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6004259.60988 | 2095362.69857 | 37.7337081577855 | -122.42766605443998 | (37.7337081577855, -122.42766605444) | |||
| 21024 | 21024 | 228 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 2974 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/1992 12:00:00 AM | 70 | 3X4 | 5990613.87863 | 2095369.93557 | 37.732946707226205 | -122.47484341251601 | (37.7329467072262, -122.474843412516) |
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");