Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22144 | 22144 | 2049 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 701X Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001977.73953 | 2095412.31759 | 37.733715061000204 | -122.43555868909901 | (37.7337150610002, -122.435558689099) | |||
| 6578 | 6578 | 9618 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2000 12:00:00 AM | 7 | 3X3 | 6002831.8444 | 2112032.7875 | 37.7793993714118 | -122.43379332982599 | (37.7793993714118, -122.433793329826) | ||
| 21608 | 21608 | 19327 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 230 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5993348.8476 | 2089853.7551099998 | 37.717958734599705 | -122.46498750927601 | (37.7179587345997, -122.464987509276) | |||
| 6505 | 6505 | 20152 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1057 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1997 12:00:00 AM | 12 | 3X3 | 6002876.4729 | 2111952.9425 | 37.7791826693541 | -122.433633233262 | (37.7791826693541, -122.433633233262) | ||
| 138893 | 138893 | 23604 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 200X Vasquez Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
| 19384 | 19384 | 27275 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005306.02285 | 2108414.57657 | 37.7696047286145 | -122.424976596817 | (37.7696047286145, -122.424976596817) | |||
| 20784 | 20784 | 27276 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005326.21516 | 2108415.83453 | 37.7696093232375 | -122.424906841772 | (37.7696093232375, -122.424906841772) | |||
| 19378 | 19378 | 27278 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005367.959369999 | 2108416.37045 | 37.7696131525447 | -122.424762488 | (37.7696131525447, -122.424762488) | |||
| 20927 | 20927 | 27318 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 326 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5993116.17703 | 2089857.5003900002 | 37.7179555995549 | -122.465792014904 | (37.7179555995549, -122.465792014904) | |||
| 22191 | 22191 | 29356 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991811.277419999 | 2096273.10994 | 37.7354959129041 | -122.47076949802201 | (37.7354959129041, -122.470769498022) | ||
| 19222 | 19222 | 29357 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991847.829940001 | 2096308.81938 | 37.7355960757897 | -122.470645723443 | (37.7355960757897, -122.470645723443) | ||
| 22089 | 22089 | 29358 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991885.18 | 2096342.85411 | 37.735691686328295 | -122.470519069219 | (37.7356916863283, -122.470519069219) | ||
| 21756 | 21756 | 29359 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991917.55406 | 2096377.82265 | 37.735789573027205 | -122.470409686474 | (37.7357895730272, -122.470409686474) | ||
| 22167 | 22167 | 29360 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991958.47705 | 2096423.3893400002 | 37.73591705373521 | -122.470271518219 | (37.7359170537352, -122.470271518219) | ||
| 20563 | 20563 | 29361 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991939.73246 | 2096403.05712 | 37.735860142840096 | -122.470334844889 | (37.7358601428401, -122.470334844889) | ||
| 18576 | 18576 | 29362 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5991983.966469999 | 2096447.7248099998 | 37.7359853464519 | -122.470185163514 | (37.7359853464519, -122.470185163514) | ||
| 19218 | 19218 | 29363 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5992002.78104 | 2096471.37185 | 37.736051362971004 | -122.470121835975 | (37.736051362971, -122.470121835975) | ||
| 20965 | 20965 | 29364 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992027.40322 | 2096494.06765 | 37.7361151033221 | -122.470038359996 | (37.7361151033221, -122.470038359996) | ||
| 20795 | 20795 | 29365 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992050.3612 | 2096514.70328 | 37.7361730907045 | -122.46996048768601 | (37.7361730907045, -122.469960487686) | ||
| 18354 | 18354 | 29366 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/25/2012 12:00:00 AM | 3 | 3X3 | 5992064.02141 | 2096527.0918599998 | 37.7362078962607 | -122.46991416090599 | (37.7362078962607, -122.469914160906) | ||
| 15921 | 15921 | 29468 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1613 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/05/2015 07:24:00 AM | 3 | 3X3 | 6016802.5034 | 2093317.3698 | 37.7287936059494 | -122.384158766122 | (37.7287936059494, -122.384158766122) | ||
| 6342 | 6342 | 30510 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2774 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 6x7 | Permit Number 778747 | 5999768.8918 | 2117782.75925 | 37.7950130117898 | -122.444802762862 | (37.7950130117898, -122.444802762862) | |
| 136335 | 136335 | 31160 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 401 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 9 | Permit Number 34862 | 5992970.4282599995 | 2089958.37606 | 37.7182241712773 | -122.466303127503 | (37.7182241712773, -122.466303127503) | |
| 137249 | 137249 | 31161 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 401 Ramsell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34862 | 5992970.452219999 | 2089928.9593099998 | 37.7181434013758 | -122.466300907981 | (37.7181434013758, -122.466300907981) | |
| 173112 | 173112 | 31244 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2530 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 5 | Permit Number 34927 | 5991119.10611 | 2098174.96045 | 37.740677856906 | -122.47330123797701 | (37.740677856906, -122.473301237977) | |
| 69260 | 69260 | 31285 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2582 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2015 12:00:00 AM | 1 | Permit Number 776543 | 5991130.3489 | 2097847.73429 | 37.7397800286191 | -122.473238505753 | (37.7397800286191, -122.473238505753) | |
| 107572 | 107572 | 31365 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2327 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 4 | Permit Number 34970 | 5991025.17306 | 2099558.33269 | 37.7444708015922 | -122.47372691139499 | (37.7444708015922, -122.473726911395) | |
| 152340 | 152340 | 31373 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 616 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 17 | Permit Number 34975 | 5991252.30155 | 2099116.74406 | 37.743271464822705 | -122.47290936108801 | (37.7432714648227, -122.472909361088) | |
| 151895 | 151895 | 31374 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 618 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 17 | Permit Number 34976 | 5991223.6620000005 | 2099114.89273 | 37.7432647234805 | -122.47300825323799 | (37.7432647234805, -122.473008253238) | |
| 151192 | 151192 | 31864 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1734 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 10 | Permit Number 35306 | 5992515.136390001 | 2103625.8443 | 37.75572532149229 | -122.468870905993 | (37.7557253214923, -122.468870905993) | ||
| 160448 | 160448 | 32341 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 120 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2005 12:00:00 AM | 6 | Permit Number 47986 | 6010882.28946 | 2093426.3819099998 | 37.728763829978796 | -122.404633115548 | (37.7287638299788, -122.404633115548) | ||
| 156056 | 156056 | 32640 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2663 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 9 | Permit Number 37085 | 6010083.06076 | 2103949.57384 | 37.7576135254646 | -122.408137970501 | (37.7576135254646, -122.408137970501) | |
| 3441 | 3441 | 32703 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 890 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37106 | 6007477.85623 | 2114415.95786 | 37.7862055211206 | -122.417889760126 | (37.7862055211206, -122.417889760126) |
| 71231 | 71231 | 32716 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 930 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37111 | 6008229.60793 | 2115679.81731 | 37.7897180499914 | -122.41537839431801 | (37.7897180499914, -122.415378394318) |
| 171572 | 171572 | 32717 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 930 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37111 | 6008227.34815 | 2115705.62066 | 37.7897887726751 | -122.415388040436 | (37.7897887726751, -122.415388040436) |
| 17785 | 17785 | 32763 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1754 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778589 | 6009301.89278 | 2099228.78566 | 37.7446075228294 | -122.410506232583 | (37.7446075228294, -122.410506232583) | |
| 106575 | 106575 | 32837 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1200-1204 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37192 | 6002497.0 | 2102089.0 | 37.7520771531238 | -122.434240612887 | (37.7520771531238, -122.434240612887) | |||
| 89126 | 89126 | 33051 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 271 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49853 | 6006201.46275008 | 2101595.657532 | 37.7509321104635 | -122.42139497515 | (37.7509321104635, -122.42139497515) | ||
| 147953 | 147953 | 33095 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1127 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 11 | Permit Number 37338 | 6011115.1734 | 2118807.4721 | 37.798467596260096 | -122.405614950876 | (37.7984675962601, -122.405614950876) | |
| 53493 | 53493 | 33102 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 375 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37343 | 6011697.96502 | 2119046.16805 | 37.799155568835 | -122.40361510367701 | (37.799155568835, -122.403615103677) | |
| 177639 | 177639 | 33154 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2326 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 11 | Permit Number 37377 | 5986110.8462 | 2099395.3559 | 37.7437374639566 | -122.490707423066 | (37.7437374639566, -122.490707423066) | |
| 130671 | 130671 | 33159 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2443 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37382 | 5985780.7157 | 2098599.2186 | 37.741532194650794 | -122.491790321831 | (37.7415321946508, -122.491790321831) | |
| 158194 | 158194 | 33163 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1900 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | 5 | Permit Number 37385 | 5986968.1646 | 2099642.2172 | 37.7444653222212 | -122.487761192729 | (37.7444653222212, -122.487761192729) | ||
| 153663 | 153663 | 33178 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3333 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 8 | Permit Number 37390 | 5985663.1141 | 2098179.7448 | 37.74037355789021 | -122.49216606308599 | (37.7403735578902, -122.492166063086) | |
| 174099 | 174099 | 33231 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2553 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1996 12:00:00 AM | 9 | Permit Number 37417 | 5989219.0688 | 2097970.1761 | 37.7400053687963 | -122.479855786116 | (37.7400053687963, -122.479855786116) | |
| 35164 | 35164 | 33237 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2571 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1996 12:00:00 AM | 4 | Permit Number 37422 | 5988602.8399 | 2097831.1801 | 37.7395879019735 | -122.481976246635 | (37.7395879019735, -122.481976246635) | |
| 160322 | 160322 | 33239 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2581 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1996 12:00:00 AM | 8 | Permit Number 37424 | 5988605.1751 | 2097786.0324 | 37.739464073986 | -122.481964866217 | (37.739464073986, -122.481964866217) | |
| 129747 | 129747 | 33247 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2586 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 8 | Permit Number 37428 | 5987412.9749 | 2097696.9936 | 37.7391501881737 | -122.486080385609 | (37.7391501881737, -122.486080385609) | |
| 53637 | 53637 | 33253 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2514 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 4 | Permit Number 37431 | 5987084.6825 | 2098140.6264 | 37.7403491484322 | -122.487248033346 | (37.7403491484322, -122.487248033346) | |
| 160980 | 160980 | 33263 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1422 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 7 | Permit Number 37438 | 5988495.8087 | 2097654.8706 | 37.7390975767362 | -122.48233339540701 | (37.7390975767362, -122.482333395407) | |
| 162405 | 162405 | 33264 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1424 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 8 | Permit Number 37439 | 5988466.7481 | 2097653.8327 | 37.7390930364544 | -122.48243379651501 | (37.7390930364544, -122.482433796515) | |
| 58138 | 58138 | 33322 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3115 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 9 | Permit Number 37465 | 6004626.67946 | 2120295.23032 | 37.8021876375982 | -122.428173235217 | (37.8021876375982, -122.428173235217) | |
| 147813 | 147813 | 33323 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3115 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 7 | Permit Number 37465 | 6004629.84544 | 2120270.80512 | 37.802120751438295 | -122.428160537697 | (37.8021207514383, -122.428160537697) | |
| 119181 | 119181 | 33327 | Significant Tree 6 | Arbutus unedo :: Strawberry Tree 61 | 1629 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2010 12:00:00 AM | 3x3 | Originally issued under Permit Number 51411; permit expired; property changed owners; trees re-posted and permit 53716 issued | 6005242.65792202 | 2118493.60609418 | 37.7972756709044 | -122.425913331435 | (37.7972756709044, -122.425913331435) | ||
| 102496 | 102496 | 33400 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 333 Santa Ana Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41597 | 5992649.0 | 2094625.0 | 37.7310190240744 | -122.46775337202101 | (37.7310190240744, -122.467753372021) | ||
| 79343 | 79343 | 34456 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 999x UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38200 | 6008246.0 | 2119227.0 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | ||
| 124171 | 124171 | 34457 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 999x UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 3x3 | Permit Number 38200 | 6008246.0 | 2119227.0 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | |
| 185444 | 185444 | 34477 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1818 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 11 | Permit Number 46532 | 6008722.614159999 | 2119125.18072 | 37.7992058679054 | -122.413916459984 | (37.7992058679054, -122.413916459984) | |
| 77556 | 77556 | 34600 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3200 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38292 | 5999389.38393742 | 2116031.83359368 | 37.7901837678549 | -122.445989915265 | (37.7901837678549, -122.445989915265) | ||
| 87174 | 87174 | 34601 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3200 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38292 | 5999389.38393742 | 2116031.83359368 | 37.7901837678549 | -122.445989915265 | (37.7901837678549, -122.445989915265) | ||
| 128532 | 128532 | 34618 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2295 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/2002 12:00:00 AM | Permit Number 44529 | 6002289.17159211 | 2107042.12264547 | 37.7656654347214 | -122.435313579001 | (37.7656654347214, -122.435313579001) | ||
| 133846 | 133846 | 34647 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1587 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38326 | 5987753.3744 | 2104509.5361 | 37.7578754422043 | -122.485403233386 | (37.7578754422043, -122.485403233386) | |
| 135115 | 135115 | 34652 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1921 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 6 | Permit Number 38331 | 5988873.4566 | 2105098.7324 | 37.7595584078301 | -122.481572717376 | (37.7595584078301, -122.481572717376) | |
| 73722 | 73722 | 34655 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2020 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38333 | 5988552.6311 | 2105140.1389 | 37.7596534386529 | -122.48268531251499 | (37.7596534386529, -122.482685312515) | |
| 45990 | 45990 | 34666 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3047 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1997 12:00:00 AM | 3 | 5.5x6 | Permit Number 38514 | 6003371.82856 | 2118846.08663 | 37.7981375866326 | -122.432412059279 | (37.7981375866326, -122.432412059279) |
| 128964 | 128964 | 34704 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 615 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38361 | 5981612.97325 | 2111540.52057 | 37.7768208414608 | -122.50716052883699 | (37.7768208414608, -122.507160528837) | |
| 163553 | 163553 | 34707 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 678 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38364 | 5981677.4444 | 2111118.32695 | 37.7756654188698 | -122.506906183465 | (37.7756654188698, -122.506906183465) | |
| 112815 | 112815 | 34708 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 678 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38364 | 5981680.40522934 | 2111119.17303473 | 37.7756679163326 | -122.506896004177 | (37.7756679163326, -122.506896004177) | ||
| 63444 | 63444 | 34710 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 810 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38366 | 5981708.71753 | 2110203.70271 | 37.7731559703061 | -122.50673015139499 | (37.7731559703061, -122.506730151395) | |
| 34514 | 34514 | 34711 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 814 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38367 | 5981711.82187 | 2110159.4624900003 | 37.7730346823923 | -122.50671613138701 | (37.7730346823923, -122.506716131387) | |
| 98497 | 98497 | 34712 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 814 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38367 | 5981714.39581019 | 2110184.94689539 | 37.7731048066849 | -122.50670911846599 | (37.7731048066849, -122.506709118466) | ||
| 170316 | 170316 | 34716 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 870 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38371 | 5981723.61752 | 2109806.49015 | 37.772066217995 | -122.506649145791 | (37.772066217995, -122.506649145791) | |
| 88076 | 88076 | 35089 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1483 FUNSTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38630 | 5992081.0 | 2105361.0 | 37.7604645121053 | -122.470498641045 | (37.7604645121053, -122.470498641045) | ||
| 28594 | 28594 | 35262 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2231 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 10 | Permit Number 38747 | 6006326.183230001 | 2118540.89021 | 37.797466675306104 | -122.42216741420499 | (37.7974666753061, -122.422167414205) | |
| 84456 | 84456 | 35589 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 59 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42715 | 6007013.60126505 | 2099209.55425367 | 37.744426166063 | -122.418417345369 | (37.744426166063, -122.418417345369) | ||
| 44423 | 44423 | 38052 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2721 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 11 | Permit Number 40249 | 6000449.1918 | 2114423.1814 | 37.7858272875297 | -122.442207546183 | (37.7858272875297, -122.442207546183) | |
| 168364 | 168364 | 38053 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2721 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 9 | Permit Number 40249 | 6000435.904 | 2114420.5238 | 37.785819233145205 | -122.442253327272 | (37.7858192331452, -122.442253327272) | |
| 159373 | 159373 | 38691 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 13904 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40604 | 6001240.455 | 2110421.1619 | 37.7748838228637 | -122.439183061176 | (37.7748838228637, -122.439183061176) | |
| 66942 | 66942 | 38846 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1470 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 7 | Permit Number 40676 | 5989942.607000001 | 2105373.0458 | 37.7603737086332 | -122.477895157521 | (37.7603737086332, -122.477895157521) | |
| 187529 | 187529 | 38847 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1470 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 9 | Permit Number 40676 | 5989942.9457 | 2105353.4021 | 37.7603197919591 | -122.47789255007099 | (37.7603197919591, -122.477892550071) | |
| 46211 | 46211 | 38855 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1546 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 7 | Permit Number 40682 | 5989647.796 | 2104818.2381 | 37.7588332407039 | -122.478874180945 | (37.7588332407039, -122.478874180945) | |
| 40240 | 40240 | 39382 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 442 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 15 | Permit Number 40924 | 6011028.8433300005 | 2112194.85786 | 37.7803061060932 | -122.40544772953699 | (37.7803061060932, -122.405447729537) | ||
| 56659 | 56659 | 39383 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 442 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 11 | Permit Number 40924 | 6011035.938999999 | 2112201.64162 | 37.7803251294514 | -122.405423660089 | (37.7803251294514, -122.405423660089) | |
| 145517 | 145517 | 39710 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 780 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41095 | 5996936.4012082005 | 2095030.50112432 | 37.7323790624539 | -122.45296043786999 | (37.7323790624539, -122.45296043787) | ||
| 144740 | 144740 | 39817 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2101 46th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41148 | 5981978.01419846 | 2100783.80216684 | 37.7473074654157 | -122.505100399713 | (37.7473074654157, -122.505100399713) | ||
| 81835 | 81835 | 40103 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2701 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1999 12:00:00 AM | Permit Number 41327 | 5987231.374238401 | 2111151.67144351 | 37.7760824787808 | -122.48769646963801 | (37.7760824787808, -122.487696469638) | |||
| 35132 | 35132 | 40200 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 826 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 7 | Permit Number 41382 | 5983263.94969 | 2110159.75947 | 37.773126771678704 | -122.501347236887 | (37.7731267716787, -122.501347236887) | |
| 169736 | 169736 | 40201 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 830 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 9 | Permit Number 41383 | 5983264.50092 | 2110118.09525 | 37.7730124061407 | -122.50134224763599 | (37.7730124061407, -122.501342247636) | |
| 157325 | 157325 | 40205 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 531 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 10 | Permit Number 41387 | 5982523.74709 | 2112147.83586 | 37.7785419514891 | -122.50405493614099 | (37.7785419514891, -122.504054936141) | |
| 32937 | 32937 | 40207 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 543 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 11 | Permit Number 41389 | 5982528.29213 | 2112062.1562099997 | 37.7783069675702 | -122.504032865431 | (37.7783069675702, -122.504032865431) | |
| 152875 | 152875 | 40214 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 483 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 13 | Permit Number 41394 | 5981888.55122 | 2112529.15759 | 37.7795515745255 | -122.506280566157 | (37.7795515745255, -122.506280566157) | |
| 36627 | 36627 | 40215 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 483 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 9 | Permit Number 41394 | 5981890.02626 | 2112509.7593099996 | 37.7794983994124 | -122.506274024618 | (37.7794983994124, -122.506274024618) | |
| 98523 | 98523 | 40340 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1646 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | Permit Number 41471 | 5998688.07142674 | 2109026.60811122 | 37.770909165958 | -122.44791183337 | (37.770909165958, -122.44791183337) | |||
| 123269 | 123269 | 40459 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 256 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41544 | 6008229.9197421 | 2097395.17552334 | 37.739512678985896 | -122.414083219638 | (37.7395126789859, -122.414083219638) | ||
| 91737 | 91737 | 40467 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 113 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41552 | 6007405.69792358 | 2097686.69945555 | 37.7402668106935 | -122.416953676795 | (37.7402668106935, -122.416953676795) | ||
| 91555 | 91555 | 40476 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41556 | 5996299.47149878 | 2089867.48348074 | 37.7181661228901 | -122.454789544621 | (37.7181661228901, -122.454789544621) | ||
| 139268 | 139268 | 40477 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41556 | 5996299.47149878 | 2089867.48348074 | 37.7181661228901 | -122.454789544621 | (37.7181661228901, -122.454789544621) | ||
| 84436 | 84436 | 40478 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41556 | 5996299.47149878 | 2089867.48348074 | 37.7181661228901 | -122.454789544621 | (37.7181661228901, -122.454789544621) | ||
| 110052 | 110052 | 40479 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 543 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41557 | 5996251.58042917 | 2089868.37749114 | 37.718165830416005 | -122.45495514714099 | (37.718165830416, -122.454955147141) | ||
| 130136 | 130136 | 40664 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 37 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 11 | Permit Number 41655 | 6003638.4352 | 2093754.51209 | 37.7292572834764 | -122.429698976444 | (37.7292572834764, -122.429698976444) |
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");