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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60447 | 60447 | 175189 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 526 Lathrop Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013119.70644 | 2086508.4833799999 | 37.7098934597806 | -122.3964134685 | (37.7098934597806, -122.3964134685) | |||
| 187579 | 187579 | 175188 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 526 Lathrop Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013054.80397 | 2086529.42647 | 37.709947353446495 | -122.396639252322 | (37.7099473534465, -122.396639252322) | |||
| 135453 | 135453 | 175187 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 526 Lathrop Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012949.0524 | 2086563.25538 | 37.7100343547851 | -122.39700712268 | (37.7100343547851, -122.39700712268) | |||
| 63827 | 63827 | 175186 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 526 Lathrop Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012896.74794 | 2086580.5787799999 | 37.710079009712295 | -122.397189112215 | (37.7100790097123, -122.397189112215) | |||
| 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) | |
| 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) |
| 179866 | 179866 | 175185 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 526 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012801.34824 | 2086611.1137400002 | 37.7101575412033 | -122.397520974627 | (37.7101575412033, -122.397520974627) | |||
| 34901 | 34901 | 108776 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 15 | 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) | |
| 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) | |
| 126629 | 126629 | 108762 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 1 | 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) | |
| 144398 | 144398 | 108769 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 8 | 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) | |
| 145235 | 145235 | 108773 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 12 | 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) | |
| 12505 | 12505 | 1266 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5992143.8312800005 | 2087204.7899900002 | 37.7106157610663 | -122.46896001711 | (37.7106157610663, -122.46896001711) | |||
| 12571 | 12571 | 1265 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5992172.84146 | 2087217.03484 | 37.710651058571294 | -122.468860642897 | (37.7106510585713, -122.468860642897) | ||
| 12345 | 12345 | 96872 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 620 Palmetto Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x3 | 5991838.49017 | 2087239.3222700001 | 37.7106929318927 | -122.470017846453 | (37.7106929318927, -122.470017846453) | |||
| 13215 | 13215 | 96870 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 620 Palmetto Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x3 | 5991859.908319999 | 2087240.59875 | 37.710697674923104 | -122.469943914081 | (37.7106976749231, -122.469943914081) | |||
| 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) | |||
| 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) | |||
| 12394 | 12394 | 1269 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992328.07158 | 2087287.97745 | 37.7108548170665 | -122.468329295555 | (37.7108548170665, -122.468329295555) | |||
| 11329 | 11329 | 1275 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5992427.65168 | 2087335.5500599998 | 37.710991191174 | -122.467988584733 | (37.710991191174, -122.467988584733) | |||
| 11746 | 11746 | 1274 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 3X3 | Permit Number 778829 | 5992454.25389 | 2087344.9239400001 | 37.71101846581121 | -122.467897323323 | (37.7110184658112, -122.467897323323) | |
| 11911 | 11911 | 1278 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3995X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/1990 12:00:00 AM | 12 | 3X3 | 5992545.036040001 | 2087392.68167 | 37.711154838998 | -122.467587032028 | (37.711154838998, -122.467587032028) | ||
| 28728 | 28728 | 175190 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2201 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6011418.48668 | 2087333.2761400002 | 37.712063358416295 | -122.402351191059 | (37.7120633584163, -122.402351191059) | |||
| 66389 | 66389 | 175184 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 190 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001047.00422 | 2087602.25445 | 37.7122174923141 | -122.438217204682 | (37.7122174923141, -122.438217204682) | |||
| 66318 | 66318 | 65718 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 206 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1990 12:00:00 AM | 22 | Permit Number 28650 | 6000369.4893 | 2087691.53319 | 37.7124240746766 | -122.44056528958099 | (37.7124240746766, -122.440565289581) | |
| 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) | ||
| 65965 | 65965 | 39931 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 175 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 16 | Permit Number 41202 | 6010293.703319999 | 2087956.6998299998 | 37.713712300459704 | -122.406282682604 | (37.7137123004597, -122.406282682604) | |
| 76879 | 76879 | 175191 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 193 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6010202.71269 | 2087988.02388 | 37.7137932196449 | -122.40659938696699 | (37.7137932196449, -122.406599386967) | |||
| 136637 | 136637 | 39933 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 180 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 17 | Permit Number 41204 | 6010299.07366 | 2087996.8284 | 37.713822785758296 | -122.406266946271 | (37.7138227857583, -122.406266946271) | |
| 173901 | 173901 | 203557 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 377 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995020.43667 | 2088328.90175 | 37.7138680909275 | -122.459099244044 | (37.7138680909275, -122.459099244044) | |||
| 142759 | 142759 | 73831 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 102 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1998 12:00:00 AM | 19 | 6010808.25129 | 2088026.1904400003 | 37.713931877121 | -122.404509096323 | (37.713931877121, -122.404509096323) | ||
| 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) | |||
| 46327 | 46327 | 203556 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 209 Farallones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5994991.30881 | 2088378.07982 | 37.7140014477822 | -122.45920347906001 | (37.7140014477822, -122.45920347906) | |||
| 68419 | 68419 | 203554 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 209 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5994942.92929 | 2088379.09284 | 37.714001447791794 | -122.459370769157 | (37.7140014477918, -122.459370769157) | |||
| 75904 | 75904 | 203555 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 209 Farallones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5994968.99544 | 2088379.2885599998 | 37.714003483854796 | -122.459280689461 | (37.7140034838548, -122.459280689461) | |||
| 72731 | 72731 | 39936 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 262 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 11 | Permit Number 41207 | 6009779.3367800005 | 2088185.9421 | 37.7143129666441 | -122.40807668619499 | (37.7143129666441, -122.408076686195) | |
| 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) | ||
| 154545 | 154545 | 203558 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 179 Caine Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997048.33435 | 2088809.5415700001 | 37.7153041877202 | -122.45212476956002 | (37.7153041877202, -122.45212476956) | |||
| 70944 | 70944 | 175175 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 231 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 5998599.64276 | 2088795.69735 | 37.71535491666071 | -122.446761792925 | (37.7153549166607, -122.446761792925) | |||
| 158686 | 158686 | 175176 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 226 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5998630.92665 | 2088821.6560099998 | 37.715427980281795 | -122.44665552904699 | (37.7154279802818, -122.446655529047) | |||
| 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) | |
| 72837 | 72837 | 175179 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 450 Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6001771.8389099995 | 2089201.36797 | 37.7166495024579 | -122.43582630934999 | (37.7166495024579, -122.43582630935) | |||
| 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) | |||
| 18080 | 18080 | 112764 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 145 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997123.4 | 2089342.1 | 37.7167707693614 | -122.45190370908001 | (37.7167707693614, -122.45190370908) | ||
| 75047 | 75047 | 203560 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 145 Lakeview Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997153.12879 | 2089368.29033 | 37.716844384649704 | -122.45180284012599 | (37.7168443846497, -122.451802840126) | |||
| 170193 | 170193 | 203559 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 145 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997146.51683 | 2089373.33367 | 37.7168578537955 | -122.45182605793998 | (37.7168578537955, -122.45182605794) | |||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 134145 | 134145 | 175182 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 647 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002406.62971 | 2090005.7063400003 | 37.718894076269 | -122.43368961010799 | (37.718894076269, -122.433689610108) | |||
| 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) | |
| 57694 | 57694 | 203553 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994715.67756 | 2090305.5088 | 37.7192778601644 | -122.46029572277 | (37.7192778601644, -122.46029572277) | |||
| 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) | ||
| 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) |
| 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) | |||
| 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) | ||
| 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) | ||
| 169798 | 169798 | 175183 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 404 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003446.11855 | 2091231.22966 | 37.7223180210418 | -122.430183890869 | (37.7223180210418, -122.430183890869) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 63088 | 63088 | 70176 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 307 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 14 | 3.5x4 to 3.5x7 | 6004287.81152 | 2091470.5320099997 | 37.7230227297861 | -122.42729139328999 | (37.7230227297861, -122.42729139329) | |
| 154526 | 154526 | 175216 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 240 Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010752.32605 | 2091460.28671 | 37.7233580771044 | -122.404944037249 | (37.7233580771044, -122.404944037249) | |||
| 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) | |
| 72972 | 72972 | 70491 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 26 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 18 | 6005035.0472800005 | 2091735.87999 | 37.723793548611496 | -122.424727215697 | (37.7237935486115, -122.424727215697) | ||
| 74482 | 74482 | 203531 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 355 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 5995610.31086 | 2092357.07195 | 37.7249623857941 | -122.457351672459 | (37.7249623857941, -122.457351672459) | |||
| 146488 | 146488 | 203530 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 355 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5995608.479069999 | 2092372.56646 | 37.7250048247995 | -122.457359125149 | (37.7250048247995, -122.457359125149) | |||
| 186613 | 186613 | 52520 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 54 Norton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 30 | Permit Number 48621 | 6001810.81862 | 2092293.7166900001 | 37.7251426126309 | -122.4359127153 | (37.7251426126309, -122.4359127153) | |
| 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) |
| 172349 | 172349 | 175193 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 28 Harrington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002083.86995 | 2092418.4799900001 | 37.7255006920777 | -122.434977725241 | (37.7255006920777, -122.434977725241) | |||
| 153191 | 153191 | 175195 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 522 Avalon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6004033.56494 | 2092456.82753 | 37.7257164970033 | -122.428240530581 | (37.7257164970033, -122.428240530581) | |||
| 172513 | 172513 | 38214 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 331 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 11 | Permit Number 40337 | 6010588.27199 | 2092325.3016599999 | 37.7257240567036 | -122.40557203921499 | (37.7257240567036, -122.405572039215) | |
| 150882 | 150882 | 175194 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 522 Avalon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004004.48398 | 2092477.2158 | 37.7257708331541 | -122.42834251370199 | (37.7257708331541, -122.428342513702) | |||
| 103080 | 103080 | 74111 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 500X Avalon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1994 12:00:00 AM | 15 | 3x3 | 6003976.59234436 | 2092494.78352221 | 37.7258174919201 | -122.428440184616 | (37.7258174919201, -122.428440184616) | ||
| 47557 | 47557 | 203564 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 202 Elmwood Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5994856.42725 | 2092686.28381 | 37.7258229929193 | -122.459981583277 | (37.7258229929193, -122.459981583277) | |||
| 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) | |
| 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) | |||
| 143122 | 143122 | 175202 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 654 Peru Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6005192.08696 | 2092525.09672 | 37.725969433130395 | -122.42424045853399 | (37.7259694331304, -122.424240458534) | ||||
| 75996 | 75996 | 175203 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 655 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 52 | 6005189.8347 | 2092537.12043 | 37.7260023204239 | -122.424249099221 | (37.7260023204239, -122.424249099221) | ||||
| 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) | |||
| 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) | |||
| 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) |
| 73789 | 73789 | 175201 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 648 Peru Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6005063.1365 | 2092591.26253 | 37.7261438278596 | -122.42469093704099 | (37.7261438278596, -122.424690937041) | ||||
| 133850 | 133850 | 175204 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 653 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6005107.433759999 | 2092594.0364400002 | 37.72615394614 | -122.424538001034 | (37.72615394614, -122.424538001034) | ||||
| 163416 | 163416 | 175200 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 648 Peru Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6005058.70512 | 2092602.03865 | 37.726173166437704 | -122.42470702233801 | (37.7261731664377, -122.424707022338) | ||||
| 154464 | 154464 | 175199 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 648 Peru Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6005054.924 | 2092614.9205099999 | 37.7262083236385 | -122.42472100946699 | (37.7262083236385, -122.424721009467) | ||||
| 35978 | 35978 | 175198 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 648 Peru Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6005048.079 | 2092617.03467 | 37.726213742054604 | -122.424744822616 | (37.7262137420546, -122.424744822616) | ||||
| 150678 | 150678 | 175205 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 653 Peru Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6005071.6263 | 2092637.8609799999 | 37.7262722564417 | -122.42466490166201 | (37.7262722564417, -122.424664901662) | ||||
| 177427 | 177427 | 175206 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 653 Peru Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6005071.100819999 | 2092642.6936700002 | 37.72628549626779 | -122.42466706185199 | (37.7262854962678, -122.424667061852) | ||||
| 83680 | 83680 | 67285 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 119 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1992 12:00:00 AM | Permit Number 30761 | 6004716.66423484 | 2092675.63660854 | 37.726355926218204 | -122.425894675863 | (37.7263559262182, -122.425894675863) | ||
| 68911 | 68911 | 175196 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 149 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6002904.026380001 | 2092823.59155 | 37.7266595719653 | -122.432171435767 | (37.7266595719653, -122.432171435767) |
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");