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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 85398 | 85398 | 103022 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 40X Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/15/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770067 | 6006901.0 | 2099544.2 | 37.745338688611206 | -122.41883042692801 | (37.7453386886112, -122.418830426928) |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) |
| 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) | |
| 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) |
| 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) | ||
| 91954 | 91954 | 109278 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1626 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773630 | 5981021.8 | 2103979.8 | 37.756026462840296 | -122.508644093874 | (37.7560264628403, -122.508644093874) |
| 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) | ||
| 92882 | 92882 | 102654 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 203X Farallones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5995004.0 | 2088355.0 | 37.713938805652795 | -122.45915794357201 | (37.7139388056528, -122.459157943572) | |||
| 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) | ||
| 94642 | 94642 | 108926 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 36 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772355 | 6007347.4 | 2099299.8 | 37.744692745913206 | -122.417269529335 | (37.7446927459132, -122.417269529335) |
| 95188 | 95188 | 109277 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1787 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772804 | 5981271.8 | 2102925.3 | 37.7531458375643 | -122.50770127946801 | (37.7531458375643, -122.507701279468) |
| 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) | ||
| 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) | ||
| 99527 | 99527 | 109287 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773636 | 5982487.2 | 2097095.3 | 37.737209800771296 | -122.503066669454 | (37.7372098007713, -122.503066669454) |
| 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) | ||
| 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) |
| 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) | ||
| 101780 | 101780 | 46374 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2135 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778548 | 5982916.26389717 | 2100594.08542438 | 37.746841715159796 | -122.50184201898001 | (37.7468417151598, -122.50184201898) | |
| 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) | ||
| 103129 | 103129 | 109743 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 142 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775046 | 6002641.7 | 2105066.1 | 37.7602597694278 | -122.43395300270399 | (37.7602597694278, -122.433953002704) |
| 103908 | 103908 | 109191 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1340 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773400 | 5981564.2 | 2105932.0 | 37.761418601404294 | -122.506913128145 | (37.7614186014043, -122.506913128145) |
| 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) | ||||
| 104571 | 104571 | 81299 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 109 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 12 | 3x3 | Permit Number 50541 | 6006708.25661782 | 2103139.88479614 | 37.755200765272704 | -122.419751988993 | (37.7552007652727, -122.419751988993) | |
| 104744 | 104744 | 109285 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1530 Sloat Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) |
| 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) | ||
| 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) |
| 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) | |||
| 109097 | 109097 | 115548 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 368 Highland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 20 | 4x6 | 6007279.07639479 | 2096499.56656681 | 37.737000082845704 | -122.417307379598 | (37.7370000828457, -122.417307379598) | ||
| 109215 | 109215 | 109259 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1658 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773073 | 5981637.7 | 2103794.0 | 37.755552591394604 | -122.506500365189 | (37.7555525913946, -122.506500365189) |
| 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) | ||
| 109712 | 109712 | 109039 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2439 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773557 | 5985453.6 | 2098605.4 | 37.741530042819704 | -122.49292181518899 | (37.7415300428197, -122.492921815189) |
| 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) | ||||
| 112110 | 112110 | 64607 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2451 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1988 12:00:00 AM | 20 | Permit Number 25510 | 6008240.6573587 | 2104159.54552526 | 37.7580867271242 | -122.41452462882299 | (37.7580867271242, -122.414524628823) | |
| 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) | |||
| 113053 | 113053 | 109068 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1216 COLE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774077 | 5998287.0 | 2106143.6 | 37.762970223958 | -122.44909141982299 | (37.762970223958, -122.449091419823) | |
| 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) | ||
| 113254 | 113254 | 106164 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1366 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771080 | 5993998.9 | 2106208.9 | 37.762903334931295 | -122.463927108118 | (37.7629033349313, -122.463927108118) | |
| 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) | ||
| 114658 | 114658 | 108766 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 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) | ||
| 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) | |
| 115640 | 115640 | 105062 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 530 07th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771082 | 5993803.2 | 2111872.0 | 37.7784414265163 | -122.465015282122 | (37.7784414265163, -122.465015282122) | ||||
| 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) | |||
| 115807 | 115807 | 115202 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1352 Sanchez St | 2 | 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) |
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");