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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 72523 | 72523 | 108691 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1638 41st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774623 | 5983468.36272 | 2103987.5899 | 37.756191751246796 | -122.500183776602 | (37.7561917512468, -122.500183776602) | |
| 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) | |||
| 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) | |
| 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) | ||||
| 115853 | 115853 | 108890 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 350 Hearst Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773349 | 5999093.24367 | 2094395.39174 | 37.7307585689262 | -122.445458107682 | (37.7307585689262, -122.445458107682) | |
| 118510 | 118510 | 121320 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 550 07th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5993807.0 | 2111747.0 | 37.7780984292352 | -122.46499305582701 | (37.7780984292352, -122.464993055827) | ||||
| 121044 | 121044 | 107168 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 65 SCOTT ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 6002336.3 | 2108640.7 | 37.7700574118158 | -122.435264926513 | (37.7700574118158, -122.435264926513) | |||||
| 123871 | 123871 | 106711 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 3990 FOLSOM ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008366.1 | 2096547.2 | 37.7371919715517 | -122.413552407719 | (37.7371919715517, -122.413552407719) | |||||
| 144078 | 144078 | 108734 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 54 Aloha Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774639 | 5991915.16633 | 2104292.89593 | 37.7575221893456 | -122.470994366205 | (37.7575221893456, -122.470994366205) | |
| 1165 | 1165 | 249373 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 649 Jones St | 1 | : 4 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | 21 | Width 4ft | Permit Number 39973 | 6008805.56783 | 2114728.1661400003 | 37.78713740130579 | -122.4133182966 | (37.7871374013058, -122.4133182966) | |
| 2135 | 2135 | 57208 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2238 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2015 12:00:00 AM | 3 | Permit Number 775007 | 6000879.71894 | 2116143.1485 | 37.7905743988346 | -122.440841472269 | (37.7905743988346, -122.440841472269) | ||
| 2378 | 2378 | 221860 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 516 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1998 12:00:00 AM | 15 | Width 3ft | Permit Number 39568 | 6001163.03933 | 2103237.69221 | 37.7551553815387 | -122.438935950032 | (37.7551553815387, -122.438935950032) | |
| 3745 | 3745 | 221791 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1991 12:00:00 AM | 30 | Width 6ft | Permit Number 29826 | 6010196.62735 | 2104192.74111 | 37.7582875664398 | -122.407762355146 | (37.7582875664398, -122.407762355146) | |
| 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) | |
| 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) | ||||
| 5123 | 5123 | 175078 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1584 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001809.644719999 | 2092991.8257799998 | 37.7270593952569 | -122.435966703417 | (37.7270593952569, -122.435966703417) | |||
| 5762 | 5762 | 107230 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1445 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005960.15833 | 2119639.59713 | 37.8004627936866 | -122.423512110213 | (37.8004627936866, -122.423512110213) | |||
| 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) | |
| 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) | ||
| 10544 | 10544 | 52929 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 22 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48913 | 6002555.71096 | 2093126.63865 | 37.727471916095205 | -122.433397195531 | (37.7274719160952, -122.433397195531) |
| 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) |
| 10987 | 10987 | 35857 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 28 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 28 | 4x6 | Permit Number 39076 | 6002203.07861 | 2092639.23336 | 37.7261135989609 | -122.43458140929899 | (37.7261135989609, -122.434581409299) |
| 11084 | 11084 | 121328 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2455 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5986403.9195 | 2098529.3345 | 37.7413767161187 | -122.48963038732401 | (37.7413767161187, -122.489630387324) | |||
| 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) | |
| 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) |
| 12058 | 12058 | 108846 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 970 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001611.41863 | 2086816.80035 | 37.7100928934503 | -122.436210250619 | (37.7100928934503, -122.436210250619) | |
| 12826 | 12826 | 117427 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 690 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776915 | 6002940.91679 | 2089412.4481900001 | 37.7172954225231 | -122.431800455543 | (37.7172954225231, -122.431800455543) | ||
| 12996 | 12996 | 35840 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 621 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 18 | 6x7 | Permit Number 39067 | 6002271.78016 | 2090299.1440400002 | 37.7196921382746 | -122.43417669731501 | (37.7196921382746, -122.434176697315) |
| 16903 | 16903 | 203213 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 626 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 10x4 | Permit Number 779632 | 6001387.0 | 2090021.0 | 37.7188781603148 | -122.437215155763 | (37.7188781603148, -122.437215155763) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 18491 | 18491 | 90669 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3722 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984088.982472 | 2110402.934687 | 37.7738428780038 | -122.498511352333 | (37.7738428780038, -122.498511352333) | |
| 18583 | 18583 | 26511 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2850 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008945.12722 | 2101866.39993 | 37.75182981809429 | -122.411926215341 | (37.7518298180943, -122.411926215341) | |||
| 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) | ||
| 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) | |
| 19788 | 19788 | 90670 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3730 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 6 | 3x3 | 5984065.2455360005 | 2110402.073206 | 37.773839120575104 | -122.49859339731701 | (37.7738391205751, -122.498593397317) | |
| 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) | ||
| 21024 | 21024 | 228 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 2974 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/1992 12:00:00 AM | 70 | 3X4 | 5990613.87863 | 2095369.93557 | 37.732946707226205 | -122.47484341251601 | (37.7329467072262, -122.474843412516) | ||
| 21771 | 21771 | 27336 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 615 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2000 12:00:00 AM | 3 | 2X3 | 6002282.10236 | 2095328.3579400002 | 37.7335018092598 | -122.434500417276 | (37.7335018092598, -122.434500417276) | ||
| 22901 | 22901 | 183545 | Planning Code 138.1 required 4 | Agonis flexuosa :: Peppermint Willow 7 | 2580 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | 4x4 | Permit Number 777874 | 5988340.9772 | 2097760.0505 | 37.73937736557679 | -122.482876432223 | (37.7393773655768, -122.482876432223) | |
| 22945 | 22945 | 104992 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2423 47TH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 10 | 2x6 | Permit Number 775156 | 5981729.7 | 2098576.9 | 37.74123331264771 | -122.505795454359 | (37.7412333126477, -122.505795454359) | |
| 23487 | 23487 | 203522 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 62 Aloha Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991862.2088 | 2104389.33207 | 37.757783914625705 | -122.471184538744 | (37.7577839146257, -122.471184538744) | |||
| 23776 | 23776 | 40163 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 39201 Dashiell Hammett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Permit Number 41356 | 6010358.38502 | 2116055.23844 | 37.7908682829043 | -122.40803948753 | (37.7908682829043, -122.40803948753) | |||
| 24411 | 24411 | 31817 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 378 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 11 | Permit Number 35283 | 6003458.13683 | 2099246.4861 | 37.7443267796662 | -122.43071403581999 | (37.7443267796662, -122.43071403582) | |
| 25751 | 25751 | 221793 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 26 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6009169.37019 | 2099491.8572 | 37.745322428990995 | -122.410983048655 | (37.745322428991, -122.410983048655) | |||
| 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) | |
| 25869 | 25869 | 37614 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 438 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 21 | Permit Number 40038 | 5990631.22382 | 2112392.71042 | 37.7796877441109 | -122.47602626679199 | (37.7796877441109, -122.476026266792) | |
| 26216 | 26216 | 221933 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 4166 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001253.22781 | 2105851.44827 | 37.7623372504834 | -122.43881134358601 | (37.7623372504834, -122.438811343586) | |||
| 26999 | 26999 | 221859 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 861 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6000847.19345 | 2101982.1025099996 | 37.7516898602076 | -122.43993821209499 | (37.7516898602076, -122.439938212095) | |||
| 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) | |
| 28243 | 28243 | 70581 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 366 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1994 12:00:00 AM | 16 | 5989681.74367 | 2112910.59233 | 37.7810546031553 | -122.47934879186 | (37.7810546031553, -122.47934879186) | ||
| 28689 | 28689 | 248075 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 407 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010292.794840001 | 2098665.98806 | 37.743117705012004 | -122.407040212138 | (37.743117705012, -122.407040212138) | |||
| 29547 | 29547 | 218232 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 371 Wawona St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 2ft | 5991901.5455 | 2097060.86466 | 37.7376641082099 | -122.47051476505 | (37.7376641082099, -122.47051476505) | |||
| 29783 | 29783 | 175207 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 9 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6005359.84242 | 2093211.4983700002 | 37.7278636122004 | -122.423709320725 | (37.7278636122004, -122.423709320725) | |||
| 30127 | 30127 | 38206 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 756 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 11 | Permit Number 40330 | 6010781.48445 | 2091161.67808 | 37.7225397893635 | -122.404822228563 | (37.7225397893635, -122.404822228563) | |
| 30409 | 30409 | 221881 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 4 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6007048.87361 | 2099774.96937 | 37.745980654479204 | -122.41833546232401 | (37.7459806544792, -122.418335462324) | |||
| 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) | ||
| 30945 | 30945 | 203540 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 305 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5998091.5711199995 | 2094441.2535 | 37.7308272605603 | -122.448924334186 | (37.7308272605603, -122.448924334186) | |||
| 31166 | 31166 | 125541 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 65 Heather Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5997339.5515 | 2114115.46943 | 37.7848046777406 | -122.45294375606501 | (37.7848046777406, -122.452943756065) | ||||
| 31428 | 31428 | 221908 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1175 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6003228.296569999 | 2101452.81084 | 37.750371807525504 | -122.431666264992 | (37.7503718075255, -122.431666264992) | |||
| 31679 | 31679 | 181649 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1265 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5986124.6924 | 2106639.2388 | 37.763627996398796 | -122.491192553457 | (37.7636279963988, -122.491192553457) | |||
| 32014 | 32014 | 35736 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 351 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | 9 | Permit Number 39011 | 6008805.61164 | 2094302.44729 | 37.731053034462 | -122.411874232722 | (37.731053034462, -122.411874232722) | |
| 32259 | 32259 | 248073 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 440 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6010194.1579599995 | 2098463.12553 | 37.7425551682987 | -122.407366975408 | (37.7425551682987, -122.407366975408) | |||
| 32779 | 32779 | 67371 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1009 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | 17 | Permit Number 30864 | 5992480.35304 | 2110659.61111 | 37.7750361697588 | -122.469503188985 | (37.7750361697588, -122.469503188985) | |
| 32786 | 32786 | 221912 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 424 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003582.2659599995 | 2102758.00468 | 37.7539756202844 | -122.43053533425 | (37.7539756202844, -122.43053533425) | |||
| 33303 | 33303 | 221855 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 310 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000611.21677 | 2101947.64163 | 37.751581803057206 | -122.440751776575 | (37.7515818030572, -122.440751776575) | |||
| 33683 | 33683 | 221802 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 325 Day St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 3ft | 6003816.248819999 | 2098634.77002 | 37.7426674306639 | -122.42943214577 | (37.7426674306639, -122.42943214577) | |||
| 33735 | 33735 | 221857 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 679 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002187.97645 | 2099712.9638400003 | 37.7455355755051 | -122.435139333412 | (37.7455355755051, -122.435139333412) | |||
| 34538 | 34538 | 67951 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 546 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 1 | Permit Number 31666 | 5988462.26619 | 2112267.73562 | 37.779218595028794 | -122.483520377593 | (37.7792185950288, -122.483520377593) | |
| 35641 | 35641 | 51092 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1962 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2004 12:00:00 AM | 8 | Permit Number 47549 | 5987266.4855 | 2101911.4788 | 37.75071350308671 | -122.486896287824 | (37.7507135030867, -122.486896287824) | ||
| 35991 | 35991 | 221810 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1214 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998223.78162 | 2106145.0747700003 | 37.762970657401205 | -122.44931017573299 | (37.7629706574012, -122.449310175733) | |||
| 36004 | 36004 | 203502 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1277 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990781.19981 | 2106711.0066299997 | 37.7640960267437 | -122.47509255800301 | (37.7640960267437, -122.475092558003) | |||
| 36093 | 36093 | 203577 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 268 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6000290.88836 | 2094968.3024400002 | 37.7323999463844 | -122.44135876589701 | (37.7323999463844, -122.441358765897) | |||
| 36231 | 36231 | 203575 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 60 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6001009.56246 | 2095231.0134 | 37.7331622045591 | -122.438892966938 | (37.7331622045591, -122.438892966938) | |||
| 36359 | 36359 | 65523 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 721 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1990 12:00:00 AM | 21 | Permit Number 28410 | 6001369.75843 | 2089371.2505700001 | 37.7170931137224 | -122.437228255287 | (37.7170931137224, -122.437228255287) | |
| 37052 | 37052 | 38204 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 691 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 14 | Permit Number 40328 | 6010720.89935 | 2091470.20831 | 37.723383562996794 | -122.405053372309 | (37.7233835629968, -122.405053372309) | |
| 37344 | 37344 | 221931 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2136 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003273.64696 | 2107146.54353 | 37.76600800788229 | -122.431915952764 | (37.7660080078823, -122.431915952764) | |||
| 37393 | 37393 | 90780 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3745 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983969.87464 | 2110351.83219 | 37.7736955796118 | -122.498919582943 | (37.7736955796118, -122.498919582943) | ||
| 37457 | 37457 | 67246 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 4732 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 21 | Permit Number 30710 | 5983966.26401 | 2111769.24931 | 37.777587186025 | -122.499036819383 | (37.777587186025, -122.499036819383) | |
| 37550 | 37550 | 203520 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1537 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994273.74981 | 2105115.42997 | 37.7599167854573 | -122.46289717008699 | (37.7599167854573, -122.462897170087) | |||
| 37591 | 37591 | 125540 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 47 Casa Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001554.266480001 | 2121557.3314 | 37.8054787165372 | -122.438895742254 | (37.8054787165372, -122.438895742254) | |||
| 38546 | 38546 | 70527 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 25 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 7 | 6004201.75826 | 2093380.3315400002 | 37.728261749270395 | -122.427724869209 | (37.7282617492704, -122.427724869209) | ||
| 39136 | 39136 | 44734 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1434 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 15 | Permit Number 43849 | 5988947.4767 | 2101073.1476 | 37.7485095315689 | -122.481021968545 | (37.7485095315689, -122.481021968545) | |
| 39285 | 39285 | 221786 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 65 Scott St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 2ft | 6002363.3837 | 2108638.99661 | 37.7700542727214 | -122.435171122647 | (37.7700542727214, -122.435171122647) | |||
| 39493 | 39493 | 221819 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 68 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006048.67396 | 2097610.71259 | 37.7399817402673 | -122.421640334157 | (37.7399817402673, -122.421640334157) | |||
| 40283 | 40283 | 221794 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 63 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009581.165709999 | 2099887.27047 | 37.7464312301328 | -122.40958702472099 | (37.7464312301328, -122.409587024721) | |||
| 40525 | 40525 | 83821 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1514 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50163 | 5981890.7885 | 2104754.0668 | 37.75820356042521 | -122.505696289301 | (37.7582035604252, -122.505696289301) | |
| 40756 | 40756 | 83009 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 622 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52378 | 6012068.99141 | 2105489.9515299997 | 37.7619540583423 | -122.40137802299499 | (37.7619540583423, -122.401378022995) | |
| 41259 | 41259 | 221817 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 25 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6007435.65723 | 2099387.93304 | 37.744939704512205 | -122.416970595441 | (37.7449397045122, -122.416970595441) | |||
| 41955 | 41955 | 83487 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2051 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50156 | 5982589.2289 | 2101159.5488 | 37.7483751044578 | -122.503014711943 | (37.7483751044578, -122.503014711943) | |
| 42022 | 42022 | 221917 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1033 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003826.31981 | 2102255.52555 | 37.7526097533439 | -122.429655503209 | (37.7526097533439, -122.429655503209) | |||
| 43081 | 43081 | 123202 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1310 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5993110.48216 | 2112011.5710299998 | 37.7787846837447 | -122.467421785255 | (37.7787846837447, -122.467421785255) | |||
| 43186 | 43186 | 221869 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 673 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007432.02888 | 2095820.07599 | 37.7351429550833 | -122.416730429683 | (37.7351429550833, -122.416730429683) | |||
| 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) | |
| 44268 | 44268 | 203544 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 522 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 5997938.28847 | 2094411.0721200001 | 37.730735622335 | -122.449452080662 | (37.730735622335, -122.449452080662) | |||
| 44377 | 44377 | 47976 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1515 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | 2 | Permit Number 45710 | 5988978.856000001 | 2104994.3044 | 37.7592778047967 | -122.48120055117701 | (37.7592778047967, -122.481200551177) | |
| 44597 | 44597 | 203581 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 24 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5997456.8868 | 2093709.9818900002 | 37.7287830449036 | -122.451065815142 | (37.7287830449036, -122.451065815142) | |||
| 45131 | 45131 | 221870 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 530 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008584.18129 | 2096552.27767 | 37.7372181568784 | -122.412798757353 | (37.7372181568784, -122.412798757353) |
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");