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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145744 | 145744 | 109499 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774984 | 6002392.9 | 2096233.9 | 37.7359945088656 | -122.43418207236999 | (37.7359945088656, -122.43418207237) |
| 70620 | 70620 | 221840 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 98 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 6004312.44121 | 2095336.44977 | 37.733639072774295 | -122.42748153156602 | (37.7336390727743, -122.427481531566) | |||
| 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) | |||
| 176883 | 176883 | 221839 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 98 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6004329.201169999 | 2095336.9528400002 | 37.733641402021796 | -122.42742362331002 | (37.7336414020218, -122.42742362331) | |||
| 11377 | 11377 | 108847 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 970 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001586.13513 | 2086816.33243 | 37.7100901720951 | -122.43629760175101 | (37.7100901720951, -122.436297601751) | |
| 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) | |
| 120428 | 120428 | 67814 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 963 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31468 | 6003800.96031756 | 2102663.38209888 | 37.7537281954709 | -122.42977228881901 | (37.7537281954709, -122.429772288819) | ||
| 168389 | 168389 | 221920 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 963 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 6003802.10196 | 2102678.8215099997 | 37.753770653104205 | -122.429769441907 | (37.7537706531042, -122.429769441907) | |||
| 172913 | 172913 | 203509 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 942 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5991897.43235 | 2105257.276 | 37.7601690974381 | -122.471125954211 | (37.7601690974381, -122.471125954211) | |||
| 68079 | 68079 | 203508 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 936 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5991919.73486 | 2105259.11564 | 37.7601754385635 | -122.471048955151 | (37.7601754385635, -122.471048955151) | |||
| 71829 | 71829 | 203532 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 935 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5996459.44919 | 2098104.63925 | 37.7407925546419 | -122.45483139437701 | (37.7407925546419, -122.454831394377) | |||
| 107928 | 107928 | 90903 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 933 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 5992701.41821 | 2110665.49388 | 37.7750650957048 | -122.468738911315 | (37.7750650957048, -122.468738911315) | |||
| 9 | 9 | 203507 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 920 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5991972.62617 | 2105259.8491700003 | 37.76018051163321 | -122.470866084321 | (37.7601805116332, -122.470866084321) | |||
| 22 | 22 | 203506 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 910 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5992059.0 | 2105289.0 | 37.760265546982495 | -122.470569484113 | (37.7602655469825, -122.470569484113) | |||
| 53295 | 53295 | 189219 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 902 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 51 | Width 4ft | 6015755.01178 | 2096440.4400900002 | 37.7373109588264 | -122.38799789070801 | (37.7373109588264, -122.387997890708) | |||
| 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) | |||
| 76285 | 76285 | 175208 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 9 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6005371.81589 | 2093231.8898099998 | 37.727920278496 | -122.423669377345 | (37.727920278496, -122.423669377345) | |||
| 173232 | 173232 | 175209 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 9 Athens St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6005385.77988 | 2093250.96165 | 37.727973433805204 | -122.423622458831 | (37.7279734338052, -122.423622458831) | |||
| 61939 | 61939 | 221906 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 879 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002491.822919999 | 2103096.81966 | 37.7548440920015 | -122.43433056233201 | (37.7548440920015, -122.434330562332) | |||
| 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) | ||
| 160527 | 160527 | 67252 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 874 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 25 | Permit Number 30716 | 5983584.68504 | 2109860.80212 | 37.77232475148129 | -122.500215683916 | (37.7723247514813, -122.500215683916) | |
| 24259 | 24259 | 175213 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 87 Valmar Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005270.21686 | 2092560.99775 | 37.726072420781705 | -122.423972920124 | (37.7260724207817, -122.423972920124) | |||
| 172303 | 172303 | 175212 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 87 Valmar Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005258.73549 | 2092540.80848 | 37.7260163372638 | -122.424011175489 | (37.7260163372638, -122.424011175489) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 186592 | 186592 | 175215 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 857 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 8ft | 6010301.67863 | 2094727.3315700002 | 37.7323034959049 | -122.406731980322 | (37.7323034959049, -122.406731980322) | |||
| 163474 | 163474 | 117937 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 852 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5982958.9976699995 | 2109991.0051700003 | 37.7726455076262 | -122.502389596139 | (37.7726455076262, -122.502389596139) | |||
| 69427 | 69427 | 64508 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 841 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 36 | Permit Number 25389 | 6000432.9415 | 2111897.9264 | 37.7788926598871 | -122.442082438032 | (37.7788926598871, -122.442082438032) | |
| 65323 | 65323 | 35138 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 832 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 9 | Permit Number 38668 | 6001976.8462 | 2088896.9612599998 | 37.715825312477605 | -122.435095942923 | (37.7158253124776, -122.435095942923) | |
| 66449 | 66449 | 124123 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 83 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5996382.54086 | 2112452.81509 | 37.7801845808517 | -122.456134428556 | (37.7801845808517, -122.456134428556) | |||
| 153707 | 153707 | 202091 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 82 Carr St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012965.80047 | 2090628.9418799998 | 37.7211988543156 | -122.39723414844102 | (37.7211988543156, -122.397234148441) | |||
| 160814 | 160814 | 65231 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 812 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | 10 | Permit Number 28018 | 6008328.075 | 2093605.1534799999 | 37.7291116131036 | -122.41347586773001 | (37.7291116131036, -122.41347586773) | ||
| 152919 | 152919 | 221813 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 810 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007573.94838 | 2095674.4873099998 | 37.7347511816054 | -122.416229453325 | (37.7347511816054, -122.416229453325) | |||
| 66659 | 66659 | 74492 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 800 Excelsior Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 11 | 6004373.61085 | 2091456.86354 | 37.7229900511464 | -122.42699382922 | (37.7229900511464, -122.42699382922) | ||
| 72089 | 72089 | 74647 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 800 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 9 | 6004365.04367 | 2091463.5414099998 | 37.7230079026666 | -122.42702391962 | (37.7230079026666, -122.42702391962) | ||
| 163002 | 163002 | 74128 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 800 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 9 | 6004381.290630001 | 2091452.37119 | 37.72297815039779 | -122.426966961977 | (37.7229781503978, -122.426966961977) | ||
| 163428 | 163428 | 73896 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 800 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6004393.1018199995 | 2091444.69797 | 37.7229577492801 | -122.426925586868 | (37.7229577492801, -122.426925586868) | ||
| 47027 | 47027 | 221919 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 80 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6004080.1128 | 2102611.51792 | 37.75360159226479 | -122.428803219313 | (37.7536015922648, -122.428803219313) | |||
| 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) | ||
| 133545 | 133545 | 122030 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 791 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5990356.6859800005 | 2110010.07931 | 37.773129772425605 | -122.476801870398 | (37.7731297724256, -122.476801870398) | |||
| 162375 | 162375 | 221918 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 78 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6004080.11539 | 2102633.3428599997 | 37.7536615185686 | -122.428804766139 | (37.7536615185686, -122.428804766139) | |||
| 179732 | 179732 | 221814 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 78 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007954.65071 | 2098276.18605 | 37.74191627460979 | -122.415097327373 | (37.7419162746098, -122.415097327373) | |||
| 63823 | 63823 | 37604 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 775 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 24 | Permit Number 40032 | 5992242.46027 | 2110184.69167 | 37.773718418011 | -122.470291511842 | (37.773718418011, -122.470291511842) | |
| 54020 | 54020 | 203587 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 77 Staples Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 39 | Width 3ft | 5999512.80503 | 2093756.92182 | 37.7290294222638 | -122.443961766319 | (37.7290294222638, -122.443961766319) | |||
| 68860 | 68860 | 203586 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 77 Staples Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 5999493.48314 | 2093757.18666 | 37.729029047242605 | -122.444028582376 | (37.7290290472426, -122.444028582376) | |||
| 76869 | 76869 | 203588 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 77 Staples Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5999527.8711 | 2093756.3356599999 | 37.729028672217005 | -122.443909639833 | (37.729028672217, -122.443909639833) | |||
| 48418 | 48418 | 175178 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 763 Morse St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998593.8483 | 2087142.30255 | 37.7108147396853 | -122.44666292955 | (37.7108147396853, -122.44666292955) | |||
| 71009 | 71009 | 175177 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 763 Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998527.33807 | 2087102.1362299998 | 37.7107006525794 | -122.44688991486 | (37.7107006525794, -122.44688991486) | |||
| 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) | ||
| 139563 | 139563 | 64418 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 76 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1988 12:00:00 AM | Permit Number 25266 | 6003598.76227624 | 2097871.53968329 | 37.740559459966896 | -122.43012971529801 | (37.7405594599669, -122.430129715298) | ||
| 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) | |
| 132368 | 132368 | 78248 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 734 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 14 | 6002539.2435099995 | 2089283.26415 | 37.716917933889 | -122.43317962523899 | (37.716917933889, -122.433179625239) | ||
| 179343 | 179343 | 118877 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 732 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5981379.1733800005 | 2110733.6758 | 37.7745917102455 | -122.50790940578399 | (37.7745917102455, -122.507909405784) | |||
| 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) | ||
| 159561 | 159561 | 175214 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 728 Burrows St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6009081.49175 | 2092873.82998 | 37.7271458291085 | -122.410819605863 | (37.7271458291085, -122.410819605863) | |||
| 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) | ||
| 171064 | 171064 | 221812 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 724 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007603.04648 | 2096007.0336200001 | 37.735665917145504 | -122.41615239491699 | (37.7356659171455, -122.416152394917) | |||
| 91313 | 91313 | 114424 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 724 MOULTRIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x2 | 6007601.0 | 2096031.0 | 37.735731608506 | -122.416161167234 | (37.735731608506, -122.416161167234) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 138969 | 138969 | 47448 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 714 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778519 | 5981684.9751 | 2110860.5304900003 | 37.7749580289324 | -122.506861007188 | (37.7749580289324, -122.506861007188) | |
| 47049 | 47049 | 175197 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 701 Peru Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6005286.47432 | 2092498.9207099997 | 37.725902888684104 | -122.423912306729 | (37.7259028886841, -122.423912306729) | |||
| 157572 | 157572 | 67291 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 701 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1992 12:00:00 AM | 19 | Permit Number 30767 | 6005304.5061800005 | 2092488.2449299998 | 37.725874593312994 | -122.423849212975 | (37.725874593313, -122.423849212975) | |
| 60499 | 60499 | 124074 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 701 Funston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 5991915.64045 | 2110472.3398700003 | 37.7744893213305 | -122.47144298584699 | (37.7744893213305, -122.471442985847) | ||||
| 184006 | 184006 | 248223 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 70 Fair Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007150.20605 | 2099339.87769 | 37.744791694087 | -122.417954229812 | (37.744791694087, -122.417954229812) | ||||
| 157412 | 157412 | 221929 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 70 Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002463.4686 | 2106805.25277 | 37.7650249445694 | -122.434693785007 | (37.7650249445694, -122.434693785007) | |||
| 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) | |
| 48669 | 48669 | 221899 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 7 Marsily St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004290.71623 | 2095557.06224 | 37.7342435961597 | -122.427572353179 | (37.7342435961597, -122.427572353179) | |||
| 53413 | 53413 | 221902 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 7 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004251.6155900005 | 2095453.80279 | 37.7339578572562 | -122.42770018193501 | (37.7339578572562, -122.427700181935) | |||
| 134803 | 134803 | 221900 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 7 Marsily St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004249.689119999 | 2095508.6135900002 | 37.734108246392395 | -122.427710746252 | (37.7341082463924, -122.427710746252) | |||
| 136674 | 136674 | 221901 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 7 Marsily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004253.7444400005 | 2095482.9703 | 37.734038065090395 | -122.427694899296 | (37.7340380650904, -122.427694899296) | |||
| 175684 | 175684 | 221896 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 7 Marsily St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6004330.56552 | 2095607.6651400002 | 37.7343847942306 | -122.427438185126 | (37.7343847942306, -122.427438185126) | |||
| 179823 | 179823 | 221897 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 7 Marsily St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6004313.27155 | 2095583.983 | 37.7343187902678 | -122.427496289445 | (37.7343187902678, -122.427496289445) | |||
| 180906 | 180906 | 221898 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 7 Marsily St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6004300.13641 | 2095569.34378 | 37.7342778513286 | -122.427540659282 | (37.7342778513286, -122.427540659282) | |||
| 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) | |
| 49216 | 49216 | 38203 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 691 Goettingen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 14 | Permit Number 40328 | 6010707.714480001 | 2091513.67595 | 37.723502179070394 | -122.40510200945101 | (37.7235021790704, -122.405102009451) | |
| 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) | ||
| 147282 | 147282 | 175181 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 690 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6002921.15596 | 2089379.53862 | 37.7172039398928 | -122.431866410902 | (37.7172039398928, -122.431866410902) | |||
| 178727 | 178727 | 175180 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 690 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6002933.07108 | 2089399.59548 | 37.717259687060206 | -122.43182665728001 | (37.7172596870602, -122.43182665728) | |||
| 140831 | 140831 | 65036 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 69 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1992 12:00:00 AM | Permit Number 31412 | 6002360.88534811 | 2108648.78551282 | 37.7700810087641 | -122.435180464659 | (37.7700810087641, -122.435180464659) | ||
| 173271 | 173271 | 221785 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 69 Scott St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 3ft | 6002359.55948 | 2108655.6822200003 | 37.7700998701305 | -122.43518554417801 | (37.7700998701305, -122.435185544178) | |||
| 136807 | 136807 | 95918 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 682 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767617 | 5991324.67511 | 2110779.5547700003 | 37.775298644974704 | -122.473509641895 | (37.7752986449747, -122.473509641895) |
| 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) | |||
| 170269 | 170269 | 203535 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 68 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994859.58645 | 2095502.43187 | 37.7335556327814 | -122.46017459849101 | (37.7335556327814, -122.460174598491) | |||
| 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) | |
| 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) | |||
| 60188 | 60188 | 221858 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 677 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6002223.92198 | 2099714.60458 | 37.745542121680295 | -122.435015156842 | (37.7455421216803, -122.435015156842) | |||
| 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) | |||
| 73518 | 73518 | 221788 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 67 Richland Ave | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6005032.772530001 | 2096203.58298 | 37.7360607419969 | -122.42505281075199 | (37.7360607419969, -122.425052810752) | |||
| 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) | ||
| 48208 | 48208 | 70645 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 67 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 4 | 6002626.20323 | 2094469.32888 | 37.7311626384362 | -122.433249403638 | (37.7311626384362, -122.433249403638) | ||
| 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) | |
| 158394 | 158394 | 82673 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 67 Jennings Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52499 | 6012920.293380001 | 2089198.31583 | 37.717268108327204 | -122.39729118254299 | (37.7172681083272, -122.397291182543) | |
| 106142 | 106142 | 67911 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 66 Marston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31614 | 5998875.49490681 | 2093226.9126308 | 37.7275377658836 | -122.44612687983299 | (37.7275377658836, -122.446126879833) | ||
| 33071 | 33071 | 175210 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 66 Madison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6005427.44885 | 2093231.2859200002 | 37.72792176057511 | -122.423477009653 | (37.7279217605751, -122.423477009653) | |||
| 68452 | 68452 | 175211 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 66 Madison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6005436.48818 | 2093200.6412400003 | 37.7278381272226 | -122.423443582752 | (37.7278381272226, -122.423443582752) | |||
| 127645 | 127645 | 66266 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 658 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1990 12:00:00 AM | Permit Number 29373 | 5997726.05518981 | 2098148.01561628 | 37.7409842298876 | -122.450455094169 | (37.7409842298876, -122.450455094169) |
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");