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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4866 | 4866 | 253703 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1221 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998953.0 | 2105574.0 | 37.7614443133046 | -122.44674697738199 | (37.7614443133046, -122.446746977382) | ||||
| 9773 | 9773 | 114349 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1240 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3x15 | Permit Number 777354 | 5981849.8 | 2106648.5 | 37.7634027199113 | -122.50597849798001 | (37.7634027199113, -122.50597849798) | ||
| 18080 | 18080 | 112764 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 145 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997123.4 | 2089342.1 | 37.7167707693614 | -122.45190370908001 | (37.7167707693614, -122.45190370908) | ||
| 18159 | 18159 | 64301 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 151 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/1988 12:00:00 AM | Permit Number 25112 | 6004932.609957799 | 2099277.06478887 | 37.74449416747979 | -122.42561779186899 | (37.7444941674798, -122.425617791869) | ||
| 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) | ||
| 46608 | 46608 | 113206 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 50x DASHIELL HAMMETT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 6010410.0 | 2116139.0 | 37.791101161746504 | -122.40786681024599 | (37.7911011617465, -122.407866810246) | ||||
| 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) | |
| 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) | ||
| 76400 | 76400 | 63461 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 45 Powers Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1987 12:00:00 AM | Permit Number 24052 | 6006867.21716204 | 2099801.68707108 | 37.7460437878528 | -122.418965501899 | (37.7460437878528, -122.418965501899) | ||
| 77472 | 77472 | 65559 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 301 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1990 12:00:00 AM | Permit Number 28458 | 5995039.18564511 | 2096207.71663667 | 37.735502500801 | -122.45960474158501 | (37.735502500801, -122.459604741585) | ||
| 77614 | 77614 | 65560 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 310 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1990 12:00:00 AM | Permit Number 28459 | 5995012.80467967 | 2096143.76494049 | 37.735325388127606 | -122.459691319295 | (37.7353253881276, -122.459691319295) | ||
| 79405 | 79405 | 113208 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 50x DASHIELL HAMMETT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 6010410.0 | 2116139.0 | 37.791101161746504 | -122.40786681024599 | (37.7911011617465, -122.407866810246) | ||||
| 80430 | 80430 | 63857 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 317 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24557 | 6002233.40181795 | 2109560.38159908 | 37.7725767859044 | -122.435686656968 | (37.7725767859044, -122.435686656968) | ||
| 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) | ||
| 81614 | 81614 | 63855 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 728 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24554 | 6003932.92812606 | 2110451.32130531 | 37.7751194750929 | -122.429871382589 | (37.7751194750929, -122.429871382589) | ||
| 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) | ||
| 82306 | 82306 | 67034 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3947 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1992 12:00:00 AM | Permit Number 30406 | 6003485.585090701 | 2102413.54143102 | 37.7530243281476 | -122.430845098487 | (37.7530243281476, -122.430845098487) | ||
| 82499 | 82499 | 119902 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 598 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002915.0 | 2095952.0 | 37.7352500947879 | -122.43235683741001 | (37.7352500947879, -122.43235683741) | ||||
| 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) | ||
| 83680 | 83680 | 67285 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 119 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1992 12:00:00 AM | Permit Number 30761 | 6004716.66423484 | 2092675.63660854 | 37.726355926218204 | -122.425894675863 | (37.7263559262182, -122.425894675863) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |||
| 85078 | 85078 | 64790 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 221 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1989 12:00:00 AM | Permit Number 25786 | 6002754.53875379 | 2109297.20875 | 37.771883765265706 | -122.433865178188 | (37.7718837652657, -122.433865178188) | ||
| 85108 | 85108 | 115172 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1255 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775163 | 5982077.3 | 2106555.6 | 37.7631610318136 | -122.505184777155 | (37.7631610318136, -122.505184777155) | |||
| 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) | |||
| 85388 | 85388 | 113205 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 50x DASHIELL HAMMETT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 6010410.0 | 2116139.0 | 37.791101161746504 | -122.40786681024599 | (37.7911011617465, -122.407866810246) | ||||
| 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) | ||
| 85777 | 85777 | 94147 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1838 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53552 | 5992870.9 | 2102941.4 | 37.7538665624087 | -122.46759079981199 | (37.7538665624087, -122.467590799812) | ||
| 86574 | 86574 | 119901 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 598 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002915.0 | 2095952.0 | 37.7352500947879 | -122.43235683741001 | (37.7352500947879, -122.43235683741) | ||||
| 87259 | 87259 | 62770 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1622 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1986 12:00:00 AM | Permit Number 23124 | 5993110.09884511 | 2104424.43713032 | 37.7579524055375 | -122.46687140584801 | (37.7579524055375, -122.466871405848) | ||
| 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) | ||
| 87393 | 87393 | 62771 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1628 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/1986 12:00:00 AM | Permit Number 23125 | 5993111.44496049 | 2104385.34678202 | 37.7578451513046 | -122.466863908769 | (37.7578451513046, -122.466863908769) | ||
| 88128 | 88128 | 66622 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/1991 12:00:00 AM | Permit Number 29826 | 6010209.78585513 | 2104179.32451342 | 37.758251464098294 | -122.40771590105699 | (37.7582514640983, -122.407715901057) | ||
| 88131 | 88131 | 62339 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 67 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | Permit Number 22481 | 6004929.22923105 | 2096213.38801269 | 37.736081814832204 | -122.42541149958599 | (37.7360818148322, -122.425411499586) | ||
| 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) | |
| 88845 | 88845 | 65658 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 72 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1990 12:00:00 AM | Permit Number 28578 | 5998676.92004406 | 2096648.99460169 | 37.73692265288229 | -122.44705951571999 | (37.7369226528823, -122.44705951572) | ||
| 88960 | 88960 | 67941 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 127 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31655 | 6004179.48175958 | 2095714.01541041 | 37.734668261802504 | -122.427968106929 | (37.7346682618025, -122.427968106929) | ||
| 89107 | 89107 | 113210 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 50x DASHIELL HAMMETT ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 6010410.0 | 2116139.0 | 37.791101161746504 | -122.40786681024599 | (37.7911011617465, -122.407866810246) | ||||
| 89439 | 89439 | 53384 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | Permit Number 772607 | 5994713.25997575 | 2090306.35958478 | 37.719280057149504 | -122.46030414100001 | (37.7192800571495, -122.460304141) | ||
| 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) | ||
| 90218 | 90218 | 102082 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 577 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/2009 12:00:00 AM | 3x3 | Permit Number 52510 | 5994678.1 | 2111611.2 | 37.7777757479831 | -122.46196977885499 | (37.7777757479831, -122.461969778855) | |
| 90889 | 90889 | 68056 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1655 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1993 12:00:00 AM | Permit Number 31793 | 5993375.65948901 | 2104224.93951181 | 37.7574199602528 | -122.465938496778 | (37.7574199602528, -122.465938496778) | ||
| 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) | |
| 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) | ||
| 91784 | 91784 | 67260 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 596 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | Permit Number 30727 | 5983830.17257963 | 2111769.87555254 | 37.7775809215722 | -122.499507644306 | (37.7775809215722, -122.499507644306) | ||
| 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) | ||
| 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) | ||
| 92871 | 92871 | 65809 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2268 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28777 | 5991325.30735018 | 2099972.38049218 | 37.7456250483576 | -122.472719302053 | (37.7456250483576, -122.472719302053) | ||
| 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) | ||
| 93496 | 93496 | 67386 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 725 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1992 12:00:00 AM | Permit Number 30883 | 5991613.49950521 | 2110478.88524866 | 37.7744898098292 | -122.47248861666999 | (37.7744898098292, -122.47248861667) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 95937 | 95937 | 47054 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 149 Casitas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45042 | 5994940.24503133 | 2097052.6739603002 | 37.7378168558175 | -122.460008006142 | (37.7378168558175, -122.460008006142) | |||
| 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) | ||||
| 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) | |
| 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) | ||
| 97211 | 97211 | 113211 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 50x DASHIELL HAMMETT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010410.0 | 2116139.0 | 37.791101161746504 | -122.40786681024599 | (37.7911011617465, -122.407866810246) | ||||
| 97413 | 97413 | 102475 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 581 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 38389 | 6007298.0 | 2103932.0 | 37.7574089362149 | -122.417768621509 | (37.7574089362149, -122.417768621509) | |||
| 97818 | 97818 | 64417 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 48 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/1988 12:00:00 AM | Permit Number 25265 | 6003653.48603698 | 2098020.8724606005 | 37.7409725927511 | -122.42995115133199 | (37.7409725927511, -122.429951151332) | ||
| 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) | ||||
| 98299 | 98299 | 64258 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 184 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1988 12:00:00 AM | Permit Number 25059 | 6004745.64406041 | 2098733.50242163 | 37.742991103255 | -122.426225591142 | (37.742991103255, -122.426225591142) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 100420 | 100420 | 113209 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 50x DASHIELL HAMMETT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 6010410.0 | 2116139.0 | 37.791101161746504 | -122.40786681024599 | (37.7911011617465, -122.407866810246) | ||||
| 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) | ||
| 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) | ||
| 100955 | 100955 | 87814 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2000 10th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | ||
| 101214 | 101214 | 83535 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1779 48th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50180 | 5981283.63190284 | 2102973.80068941 | 37.7532797037627 | -122.50766396178301 | (37.7532797037627, -122.507663961783) | |||
| 101356 | 101356 | 87815 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2000 10th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | ||
| 101524 | 101524 | 63770 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 533 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1999 12:00:00 AM | Permit Number 24449 | 6003130.90758036 | 2110082.2752918997 | 37.7740607150966 | -122.43261938033501 | (37.7740607150966, -122.432619380335) | ||
| 101742 | 101742 | 64297 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 219 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1988 12:00:00 AM | Permit Number 25106 | 6005151.45554357 | 2098997.50110191 | 37.743738912881795 | -122.42484118253799 | (37.7437389128818, -122.424841182538) | ||
| 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) | |
| 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) | ||
| 102123 | 102123 | 60473 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 145 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997228.1128738 | 2089314.92516138 | 37.716702150620605 | -122.451539811129 | (37.7167021506206, -122.451539811129) | |||
| 102691 | 102691 | 115201 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1352 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 775318 | 6003856.3 | 2100365.8 | 37.747422706117 | -122.429417077187 | (37.747422706117, -122.429417077187) | |||
| 102920 | 102920 | 63866 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 879 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24569 | 6002490.08825783 | 2103093.39072976 | 37.754834578517205 | -122.434336316133 | (37.7548345785172, -122.434336316133) | ||
| 104325 | 104325 | 94832 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1212 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993646.6 | 2107243.8 | 37.7657245899289 | -122.46522075623301 | (37.7657245899289, -122.465220756233) | ||||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 108289 | 108289 | 69204 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2850 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33252 | 6008949.31851966 | 2101859.27420808 | 37.7518104876034 | -122.41191121770201 | (37.7518104876034, -122.411911217702) | ||
| 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) | |||
| 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) | |
| 109637 | 109637 | 63292 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3075 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23858 | 6009183.06965006 | 2100534.27317896 | 37.7481854410784 | -122.411009292537 | (37.7481854410784, -122.411009292537) | ||
| 110686 | 110686 | 39929 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 137 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | Permit Number 767825 | 6010490.84450997 | 2087849.27835868 | 37.71342836866339 | -122.405593725995 | (37.7134283686634, -122.405593725995) | ||
| 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) | ||||
| 112433 | 112433 | 97220 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 120 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 776182 | 5993132.0 | 2101212.0 | 37.749133146159004 | -122.466562169914 | (37.749133146159, -122.466562169914) | |||
| 112685 | 112685 | 115169 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1463 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 777351 | 5983676.8 | 2105200.0 | 37.759532920891 | -122.49955253982901 | (37.759532920891, -122.499552539829) | |||
| 113113 | 113113 | 33539 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 253 BOCANA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | 4x4 | Permit Number 775951 | 6007035.0 | 2097463.0 | 37.7396317225537 | -122.418219548801 | (37.7396317225537, -122.418219548801) | ||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) |
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");