Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12043 | 12043 | 108683 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 384 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774613 | 6000302.208459999 | 2086863.37515 | 37.7101463059777 | -122.44073846482401 | (37.7101463059777, -122.440738464824) |
| 128249 | 128249 | 109405 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 112 ORTEGA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 775093 | 5993662.3 | 2102610.6 | 37.753003931617705 | -122.46482995514 | (37.7530039316177, -122.46482995514) | ||
| 46276 | 46276 | 68880 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3633 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 28 | Permit Number 32851 | 6000180.507069999 | 2120770.20455 | 37.8032392229736 | -122.44359322865299 | (37.8032392229736, -122.443593228653) | |
| 100482 | 100482 | 67827 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 429 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1992 12:00:00 AM | Permit Number 31487 | 6004187.64685523 | 2101514.68763135 | 37.7505960386394 | -122.428353174015 | (37.7505960386394, -122.428353174015) | ||
| 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) | |
| 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) | |
| 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) |
| 186613 | 186613 | 52520 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 54 Norton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 30 | Permit Number 48621 | 6001810.81862 | 2092293.7166900001 | 37.7251426126309 | -122.4359127153 | (37.7251426126309, -122.4359127153) | |
| 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) | ||
| 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) | ||
| 116775 | 116775 | 114957 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 590 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2015 12:00:00 AM | Permit Number 770549 | 5993817.0 | 2111494.4 | 37.7774054340765 | -122.46494011266 | (37.7774054340765, -122.46494011266) | |||
| 10710 | 10710 | 108565 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 521 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772537 | 6010495.60195 | 2092202.9401900002 | 37.7253828953025 | -122.40588377841401 | (37.7253828953025, -122.405883778414) |
| 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) | |
| 100535 | 100535 | 108501 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1221 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773645 | 5991730.30424 | 2107117.25477 | 37.7652664370978 | -122.471839523232 | (37.7652664370978, -122.471839523232) |
| 105306 | 105306 | 108505 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1347 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773650 | 5991435.09722 | 2106251.4139099997 | 37.7628719836646 | -122.472797425789 | (37.7628719836646, -122.472797425789) |
| 85576 | 85576 | 53235 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 80 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31473 | 6004075.80842764 | 2102593.23401919 | 37.7535511453461 | -122.428816801411 | (37.7535511453461, -122.428816801411) | ||
| 95916 | 95916 | 67817 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 76 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31472 | 6004074.53693177 | 2102616.18239315 | 37.7536140842238 | -122.428822834401 | (37.7536140842238, -122.428822834401) | ||
| 114845 | 114845 | 67788 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3879 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31428 | 6003934.74347541 | 2102438.27189101 | 37.7531176706218 | -122.42929358548 | (37.7531176706218, -122.42929358548) | ||
| 120428 | 120428 | 67814 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 963 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31468 | 6003800.96031756 | 2102663.38209888 | 37.7537281954709 | -122.42977228881901 | (37.7537281954709, -122.429772288819) | ||
| 43708 | 43708 | 64171 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 610 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1987 12:00:00 AM | 21 | Permit Number 24952 | 5991942.3425 | 2111250.75611 | 37.7766281856646 | -122.47140734968201 | (37.7766281856646, -122.471407349682) | |
| 140831 | 140831 | 65036 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 69 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1992 12:00:00 AM | Permit Number 31412 | 6002360.88534811 | 2108648.78551282 | 37.7700810087641 | -122.435180464659 | (37.7700810087641, -122.435180464659) | ||
| 123536 | 123536 | 114809 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1271 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | Permit Number 775836 | 5987972.1 | 2106659.4 | 37.763791122625 | -122.48480450813801 | (37.763791122625, -122.484804508138) | |||
| 80554 | 80554 | 63133 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 28 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23648 | 6007400.02445462 | 2099399.55358264 | 37.7449696074565 | -122.417094630618 | (37.7449696074565, -122.417094630618) | ||
| 107153 | 107153 | 63129 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 34 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23643 | 6007144.61352889 | 2099320.79872129 | 37.7447389927671 | -122.417972215495 | (37.7447389927671, -122.417972215495) | ||
| 126128 | 126128 | 63134 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 27 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23649 | 6007447.90223159 | 2099378.78534919 | 37.7449152757931 | -122.416927606356 | (37.7449152757931, -122.416927606356) | ||
| 127849 | 127849 | 63135 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 25 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23650 | 6007455.65629161 | 2099393.17627053 | 37.744955226208795 | -122.41690181357599 | (37.7449552262088, -122.416901813576) | ||
| 115761 | 115761 | 114784 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1350 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | Permit Number 773262 | 6000262.8 | 2113654.9 | 37.7837071608561 | -122.44279721991501 | (37.7837071608561, -122.442797219915) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 84854 | 84854 | 64151 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 432 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24930 | 6003105.46054998 | 2099234.08620142 | 37.7442727453071 | -122.43193262973601 | (37.7442727453071, -122.431932629736) | ||
| 92353 | 92353 | 64145 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 447 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24920 | 6002941.41423586 | 2098582.0522051 | 37.742473110247104 | -122.432453304275 | (37.7424731102471, -122.432453304275) | ||
| 95707 | 95707 | 62373 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 451 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24914 | 6003654.71208885 | 2098328.44048503 | 37.741817173247 | -122.429968846467 | (37.741817173247, -122.429968846467) | ||
| 105286 | 105286 | 64148 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1545 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24927 | 6003347.08832902 | 2099252.09112644 | 37.7443358777099 | -122.431098417838 | (37.7443358777099, -122.431098417838) | ||
| 113471 | 113471 | 64150 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 412 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24929 | 6003228.47286853 | 2099240.58677175 | 37.744297567234895 | -122.431507743694 | (37.7442975672349, -122.431507743694) | ||
| 121177 | 121177 | 64134 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 553 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24905 | 6003001.41812219 | 2098877.69698992 | 37.743288284611 | -122.432266938445 | (37.743288284611, -122.432266938445) | ||
| 124600 | 124600 | 64152 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 426 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24931 | 6003142.3642398 | 2099236.03637221 | 37.7442801920451 | -122.43180516397301 | (37.7442801920451, -122.431805163973) | ||
| 85077 | 85077 | 114757 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 861 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | Permit Number 777137 | 6000857.2 | 2101959.2 | 37.751627545050894 | -122.439901966271 | (37.7516275450509, -122.439901966271) | |||
| 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) | |||
| 19069 | 19069 | 4572 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 233 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 1 | 6x6 | Permit Number 775065 | 6006398.09865 | 2098473.12689 | 37.742369434016 | -122.420493366683 | (37.742369434016, -122.420493366683) | |
| 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) | ||
| 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) | ||
| 8499 | 8499 | 41209 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3241 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 48 | Permit Number 41916 | 6000362.60573 | 2119451.91027 | 37.7996299225355 | -122.44286834991101 | (37.7996299225355, -122.442868349911) | |
| 89835 | 89835 | 33484 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 300 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | 30 | 6x6 | Permit Number 37610 | 6006227.43678663 | 2098258.25526822 | 37.741769825751 | -122.42106821147301 | (37.741769825751, -122.421068211473) |
| 125420 | 125420 | 114566 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 633 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | Permit Number 774120 | 5997130.5 | 2113555.2 | 37.7832543439484 | -122.45362653243 | (37.7832543439484, -122.45362653243) | |||
| 97121 | 97121 | 112745 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 179 Caine Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2014 12:00:00 AM | Permit Number 774163 | 5997059.3 | 2088800.2 | 37.7152791660762 | -122.45208619405899 | (37.7152791660762, -122.452086194059) | ||
| 142759 | 142759 | 73831 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 102 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1998 12:00:00 AM | 19 | 6010808.25129 | 2088026.1904400003 | 37.713931877121 | -122.404509096323 | (37.713931877121, -122.404509096323) | ||
| 108515 | 108515 | 64300 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 170 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1987 12:00:00 AM | 6004802.69510738 | 2099321.91565877 | 37.744609975961104 | -122.426070203486 | (37.7446099759611, -122.426070203486) | |||
| 69963 | 69963 | 64114 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1270 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1987 12:00:00 AM | Permit Number 24882 | 5992718.32165221 | 2106821.08244246 | 37.764510344589894 | -122.46840068588101 | (37.7645103445899, -122.468400685881) | ||
| 89722 | 89722 | 64105 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 531 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1987 12:00:00 AM | Permit Number 24871 | 6003137.00791589 | 2098885.2523176004 | 37.7433167168502 | -122.43179864381099 | (37.7433167168502, -122.431798643811) | ||
| 95475 | 95475 | 64103 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1274 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1987 12:00:00 AM | Permit Number 24869 | 5992719.22945305 | 2106794.6949286 | 37.7644379438855 | -122.468395626163 | (37.7644379438855, -122.468395626163) | ||
| 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) | ||
| 118235 | 118235 | 59173 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 327 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1992 12:00:00 AM | Permit Number 18486 | 6003820.21364245 | 2098630.45378724 | 37.742655803759 | -122.429418128827 | (37.742655803759, -122.429418128827) | ||
| 97022 | 97022 | 94821 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1435 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53901 | 5991436.1 | 2105639.0 | 37.7611905159112 | -122.472749301819 | (37.7611905159112, -122.472749301819) | |
| 101896 | 101896 | 94830 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1537 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53908 | 5994260.8 | 2105105.8 | 37.7598895981479 | -122.462941258172 | (37.7598895981479, -122.462941258172) | |
| 107093 | 107093 | 94831 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1541 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53909 | 5994261.6 | 2105082.3 | 37.759825119308 | -122.46293678641099 | (37.759825119308, -122.462936786411) | |
| 109470 | 109470 | 94829 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1531 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53907 | 5994259.9 | 2105131.8 | 37.759960935580004 | -122.46294625717199 | (37.75996093558, -122.462946257172) | |
| 144631 | 144631 | 94833 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1208 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53910 | 5993657.5 | 2107252.8 | 37.7657499301273 | -122.46518370955499 | (37.7657499301273, -122.465183709555) | |
| 132438 | 132438 | 33146 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 650 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | Permit Number 37371 | 5989131.31746 | 2110902.5354 | 37.775509053938606 | -122.481105889377 | (37.7755090539386, -122.481105889377) | |
| 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) | |
| 25764 | 25764 | 104693 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2132 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770783 | 5988848.42745 | 2113351.68498 | 37.7822172841496 | -122.482263939923 | (37.7822172841496, -122.482263939923) | |
| 133834 | 133834 | 104694 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2132 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770783 | 5988835.56911 | 2113350.3875599997 | 37.7822129738615 | -122.482308328405 | (37.7822129738615, -122.482308328405) | |
| 127645 | 127645 | 66266 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 658 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1990 12:00:00 AM | Permit Number 29373 | 5997726.05518981 | 2098148.01561628 | 37.7409842298876 | -122.450455094169 | (37.7409842298876, -122.450455094169) | ||
| 25004 | 25004 | 94732 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3965 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53863 | 5995732.51221 | 2115478.09158 | 37.7884538465346 | -122.458602225523 | (37.7884538465346, -122.458602225523) |
| 182399 | 182399 | 94731 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3965 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53863 | 5995713.23783 | 2115474.26613 | 37.788442235114005 | -122.458668634362 | (37.788442235114, -122.458668634362) |
| 17027 | 17027 | 4845 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 202 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1992 12:00:00 AM | 24 | 3X3 | 6006694.31051 | 2097440.2331 | 37.7395500270059 | -122.41939589431999 | (37.7395500270059, -122.41939589432) | ||
| 20064 | 20064 | 4846 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 210 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1992 12:00:00 AM | 15 | 3X3 | 6006713.9746 | 2097429.76412 | 37.7395223890352 | -122.419327161814 | (37.7395223890352, -122.419327161814) | ||
| 92953 | 92953 | 81824 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 465 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49841 | 5998560.4175518 | 2097716.54493852 | 37.73984723368721 | -122.447539136623 | (37.7398472336872, -122.447539136623) | ||
| 117827 | 117827 | 81935 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 23 Gaviota Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49833 | 5998498.701224599 | 2097562.09988585 | 37.739419637447604 | -122.44774140930201 | (37.7394196374476, -122.447741409302) | ||
| 92546 | 92546 | 66234 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 211 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29332 | 5995321.94630668 | 2091329.89787669 | 37.7221254446058 | -122.45827419820401 | (37.7221254446058, -122.458274198204) | ||
| 99013 | 99013 | 66250 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 718 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29350 | 5994696.57852166 | 2091262.84709817 | 37.721905383508 | -122.460431070774 | (37.721905383508, -122.460431070774) | ||
| 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) | |
| 115438 | 115438 | 94661 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 246 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53798 | 6004650.0 | 2096961.0 | 37.7381188082759 | -122.426430123703 | (37.7381188082759, -122.426430123703) | |
| 116968 | 116968 | 94662 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 252 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53799 | 6004605.0 | 2096922.0 | 37.738009179189795 | -122.42658293494699 | (37.7380091791898, -122.426582934947) | |
| 153467 | 153467 | 32556 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 233 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | 7 | Permit Number 37043 | 6004755.28395 | 2103949.67696 | 37.75731405392921 | -122.42656360702 | (37.7573140539292, -122.42656360702) | ||
| 164599 | 164599 | 68540 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 562 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 28 | Permit Number 32423 | 5982889.49723 | 2111962.75458 | 37.7780552740204 | -122.50277598400801 | (37.7780552740204, -122.502775984008) | |
| 17413 | 17413 | 225 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 2962 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/17/1991 12:00:00 AM | 40 | 3X4 | 5990608.66265 | 2095460.33335 | 37.7331946143326 | -122.47486804133301 | (37.7331946143326, -122.474868041333) | ||
| 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) | ||
| 4318 | 4318 | 160894 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 642 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:21:00 AM | 3 | Width 0ft | 6002380.66916 | 2090044.6321900003 | 37.7189994849067 | -122.43378212606702 | (37.7189994849067, -122.433782126067) | |
| 4402 | 4402 | 160893 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 634 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:15:00 AM | 3 | Width 0ft | 6002406.55833 | 2090085.42086 | 37.719112950580296 | -122.433695551007 | (37.7191129505803, -122.433695551007) | |
| 27821 | 27821 | 32474 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 7 Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 15 | Permit Number 36982 | 6000854.394669999 | 2106273.37873 | 37.7634730690508 | -122.44022101378401 | (37.7634730690508, -122.440221013784) | |
| 181229 | 181229 | 84675 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3025 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 7 | 3x3 | Permit Number 51854 | 5986186.78165 | 2110431.4764 | 37.7740440447924 | -122.49125692663 | (37.7740440447924, -122.49125692663) | |
| 155435 | 155435 | 68456 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 107 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | 25 | Permit Number 32318 | 5991466.74972 | 2114692.7979200003 | 37.7860515606903 | -122.47330365010401 | (37.7860515606903, -122.473303650104) | |
| 30611 | 30611 | 113546 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2017 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011705.090480001 | 2105100.1338299997 | 37.7608633956443 | -122.40260920746701 | (37.7608633956443, -122.402609207467) | ||
| 188872 | 188872 | 113547 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2017 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011715.20847 | 2105100.54779 | 37.7608650971692 | -122.40257424272 | (37.7608650971692, -122.40257424272) | ||
| 82800 | 82800 | 59432 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3045 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1994 12:00:00 AM | Permit Number 18794 | 6002901.09620901 | 2096034.49584779 | 37.7354758211207 | -122.43241079809299 | (37.7354758211207, -122.432410798093) | ||
| 102064 | 102064 | 65305 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3629 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1989 12:00:00 AM | Permit Number 28122 | 6005455.44263685 | 2104863.06150764 | 37.7598615508482 | -122.424207139046 | (37.7598615508482, -122.424207139046) | ||
| 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) | ||
| 91065 | 91065 | 63004 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 368 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1986 12:00:00 AM | 20 | 4x6 | Permit Number 23414 | 6007279.07639479 | 2096499.56656681 | 37.737000082845704 | -122.417307379598 | (37.7370000828457, -122.417307379598) |
| 169018 | 169018 | 100940 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1470 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/2012 12:00:00 AM | 0 | Permit Number 769322 | 5982213.5 | 2105098.8 | 37.7591690876422 | -122.504605773131 | (37.7591690876422, -122.504605773131) | ||
| 166631 | 166631 | 62982 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1391 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | 20 | Permit Number 30047 | 6006920.35815 | 2118393.21581 | 37.7970946941148 | -122.420100923242 | (37.7970946941148, -122.420100923242) | |
| 184703 | 184703 | 66782 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1001 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | 14 | Permit Number 30052 | 6006921.4512 | 2120474.40868 | 37.802809186066604 | -122.420244926256 | (37.8028091860666, -122.420244926256) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) |
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");