Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84944 | 84944 | 56276 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 58 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 24 | Permit Number 12402 | 6005944.89012346 | 2104064.54703238 | 37.757696640503895 | -122.42245763762101 | (37.7576966405039, -122.422457637621) | ||
| 88273 | 88273 | 120870 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 815 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3x3 | 6001854.0 | 2108207.0 | 37.768839178210705 | -122.436902139783 | (37.7688391782107, -122.436902139783) | |||
| 88708 | 88708 | 17333 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 170 Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006561.617219999 | 2108839.89648 | 37.7708433996885 | -122.420663729244 | (37.7708433996885, -122.420663729244) | |||
| 88944 | 88944 | 56273 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 44 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 28 | Permit Number 12399 | 6006031.13656237 | 2104069.3331134 | 37.7577146469635 | -122.422159701591 | (37.7577146469635, -122.422159701591) | ||
| 89797 | 89797 | 23907 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1615 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 4X4 | 6003522.428263701 | 2114237.5945626 | 37.785492382250794 | -122.43156175891899 | (37.7854923822508, -122.431561758919) | |||
| 94656 | 94656 | 11004 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 40 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018314.1623349 | 2094585.1363671 | 37.7323581084588 | -122.37902081553499 | (37.7323581084588, -122.379020815535) | |||
| 94677 | 94677 | 104328 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 21 Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770906 | 6002767.0 | 2106786.0 | 37.76498930837 | -122.433642570245 | (37.76498930837, -122.433642570245) | |||
| 95235 | 95235 | 11010 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 85 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018199.1590574 | 2094619.5131788002 | 37.7324461587057 | -122.379420799908 | (37.7324461587057, -122.379420799908) | |||
| 95437 | 95437 | 50967 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 225 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/1974 12:00:00 AM | Permit Number 47461 | 6010511.43889259 | 2088929.82162599 | 37.7163964722207 | -122.40559860260099 | (37.7163964722207, -122.405598602601) | |||
| 96482 | 96482 | 8109 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 790X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6004003.8918437995 | 2111454.7703146 | 37.7778787172016 | -122.429697487702 | (37.7778787172016, -122.429697487702) | |||
| 98046 | 98046 | 4434 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1246 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6004452.33203 | 2101636.8791292 | 37.7509465218336 | -122.427446575049 | (37.7509465218336, -122.427446575049) | |||
| 98357 | 98357 | 107387 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 773951 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | ||||
| 99128 | 99128 | 23906 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1605 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 4X4 | 6003542.7980522 | 2114194.1073783003 | 37.785374131922396 | -122.43148817988899 | (37.7853741319224, -122.431488179889) | |||
| 99996 | 99996 | 51601 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1250 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | Permit Number 47896 | 6000577.00438268 | 2109291.24211111 | 37.7717435732091 | -122.44139697552001 | (37.7717435732091, -122.44139697552) | |||
| 101591 | 101591 | 11007 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 60 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018282.6314 | 2094636.8214067002 | 37.7324982868599 | -122.379133414916 | (37.7324982868599, -122.379133414916) | |||
| 101861 | 101861 | 59133 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 730 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 24 | Permit Number 18438 | 5992594.65054267 | 2110474.91091897 | 37.7745356377316 | -122.46909436740499 | (37.7745356377316, -122.469094367405) | ||
| 101948 | 101948 | 107386 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 26x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6011510.0 | 2087367.0 | 37.712161065506 | -122.402037262127 | (37.712161065506, -122.402037262127) | |||
| 102845 | 102845 | 23717 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 755 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6003929.8516061 | 2111310.486379 | 37.7774783563958 | -122.429943324105 | (37.7774783563958, -122.429943324105) | |||
| 102862 | 102862 | 60698 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 918 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | 15 | Permit Number 20345 | 6009112.76031538 | 2103802.68080771 | 37.7571558133036 | -122.411483299228 | (37.7571558133036, -122.411483299228) | |
| 103101 | 103101 | 49702 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1260@ BAKER Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46521 | 6000531.35028078 | 2109284.92106254 | 37.7717236162704 | -122.44155444188499 | (37.7717236162704, -122.441554441885) | |||
| 103883 | 103883 | 60678 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1160 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/1983 12:00:00 AM | 6x5 | Permit Number 20316 | 6001007.89737324 | 2109351.27378976 | 37.7719329428525 | -122.439910797466 | (37.7719329428525, -122.439910797466) | |
| 103943 | 103943 | 23915 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1631 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4X4 | 6003514.8324253 | 2114292.4573902 | 37.7856425912173 | -122.43159195647101 | (37.7856425912173, -122.431591956471) | |||
| 105887 | 105887 | 16639 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 159 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002897.330053501 | 2107339.8890724997 | 37.766517547095106 | -122.43323137202299 | (37.7665175470951, -122.433231372023) | |||
| 105990 | 105990 | 11009 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 80 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018206.0401963 | 2094670.6666495 | 37.7325869956158 | -122.379400561989 | (37.7325869956158, -122.379400561989) | |||
| 108953 | 108953 | 8080 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 677 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6004653.03771 | 2111392.08692 | 37.7777433402869 | -122.427447397341 | (37.7777433402869, -122.427447397341) | |||
| 108985 | 108985 | 33805 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 751 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/1996 12:00:00 AM | 3x3 | Permit Number 37823 | 5997939.03141438 | 2107846.29922309 | 37.7676254964359 | -122.45041766938401 | (37.7676254964359, -122.450417669384) | ||
| 109836 | 109836 | 225831 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6010886.07537 | 2102341.86633 | 37.753244046982395 | -122.405247593515 | (37.7532440469824, -122.405247593515) | |||
| 110819 | 110819 | 11005 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018298.396867501 | 2094610.9788869 | 37.7324281976732 | -122.37907711517201 | (37.7324281976732, -122.379077115172) | |||
| 111147 | 111147 | 54586 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 163 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/1987 12:00:00 AM | 5x4 | Permit Number 24629 | 6000291.49375014 | 2109442.50729731 | 37.7721426401996 | -122.442395433804 | (37.7721426401996, -122.442395433804) | ||
| 111505 | 111505 | 21714 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1711X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4x4 | 6003474.1759741 | 2114557.4451345 | 37.7863678761913 | -122.431751542559 | (37.7863678761913, -122.431751542559) | |||
| 112079 | 112079 | 23714 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.777378207850795 | -122.42957257421499 | (37.7773782078508, -122.429572574215) | |||
| 113136 | 113136 | 56271 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 38 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 30 | Permit Number 12397 | 6006068.09932512 | 2104071.38429116 | 37.75772236378771 | -122.422032014666 | (37.7577223637877, -122.422032014666) | ||
| 113245 | 113245 | 21719 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1645 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4X4 | 6003301.0 | 2114333.0 | 37.7857417886053 | -122.432334651108 | (37.7857417886053, -122.432334651108) | |||
| 113592 | 113592 | 54987 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 634 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | Permit Number 774084 | 5990988.52251 | 2111051.18052 | 37.7760249826043 | -122.47469228835699 | (37.7760249826043, -122.474692288357) | ||
| 114713 | 114713 | 23916 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1639 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6003511.011206 | 2114320.0570948003 | 37.7857181564596 | -122.431607147924 | (37.7857181564596, -122.431607147924) | |||
| 115922 | 115922 | 10410 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1154 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 5999422.7 | 2108913.3 | 37.770640013924606 | -122.44536259510099 | (37.7706400139246, -122.445362595101) | |||
| 115931 | 115931 | 23905 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1601 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 45 | 4X4 | 6003552.240720401 | 2114183.8642161 | 37.7853465419578 | -122.431454779618 | (37.7853465419578, -122.431454779618) | ||
| 116947 | 116947 | 102829 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 101 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x12 | 6000750.2 | 2109361.5 | 37.771946348826205 | -122.440802922949 | (37.7719463488262, -122.440802922949) | ||||
| 117497 | 117497 | 11002 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 25 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018294.3685242 | 2094521.575214 | 37.7321824905391 | -122.379084835175 | (37.7321824905391, -122.379084835175) | |||
| 118584 | 118584 | 10550 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 217 Harbor Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1992 12:00:00 AM | 12 | 3X4 | 6018348.7736836 | 2094772.4250311002 | 37.7328742748645 | -122.378914156582 | (37.7328742748645, -122.378914156582) | ||
| 118966 | 118966 | 8065 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 631 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x3 | 6004732.981000001 | 2111553.11801 | 37.7781900132645 | -122.427182319007 | (37.7781900132645, -122.427182319007) | |||
| 120313 | 120313 | 14531 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 121359 | 121359 | 103287 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011114.9 | 2121460.0 | 37.805750773231004 | -122.40580283963699 | (37.805750773231, -122.405802839637) | ||||
| 122617 | 122617 | 11001 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 20 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018345.6932697 | 2094533.4513275002 | 37.7322179299469 | -122.37890821657899 | (37.7322179299469, -122.378908216579) | |||
| 123057 | 123057 | 23785 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1085X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/2016 12:00:00 AM | 3 | 3X3 | 6003779.292648099 | 2112432.2054737 | 37.780549791072005 | -122.430544216434 | (37.780549791072, -122.430544216434) | ||
| 123076 | 123076 | 23781 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1010 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003903.8361546 | 2112182.8886988997 | 37.7798722837048 | -122.430095570639 | (37.7798722837048, -122.430095570639) | |||
| 124482 | 124482 | 10997 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 3X Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6018318.9881754005 | 2094475.1533634998 | 37.732056382705004 | -122.378996495822 | (37.732056382705, -122.378996495822) | |||
| 124648 | 124648 | 23721 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 802X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003990.015324599 | 2111477.493419 | 37.7779403234669 | -122.429747112563 | (37.7779403234669, -122.429747112563) | |||
| 124676 | 124676 | 5941 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1155X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6003735.29014 | 2112772.66113 | 37.7814821046204 | -122.43072074410699 | (37.7814821046204, -122.430720744107) | |||
| 125201 | 125201 | 4506 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1799 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6004678.8435244 | 2098420.1905157 | 37.7421270443151 | -122.42643426555 | (37.7421270443151, -122.42643426555) | |||
| 127245 | 127245 | 165 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | |||
| 127379 | 127379 | 23712 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 703 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 6003969.6344427 | 2111125.8223490003 | 37.7769735674529 | -122.42979252742599 | (37.7769735674529, -122.429792527426) | |||
| 128617 | 128617 | 10559 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 266 Harbor Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1992 12:00:00 AM | 18 | 3X4 | 6018220.577079 | 2094928.7869737998 | 37.733296545147795 | -122.379368227321 | (37.7332965451478, -122.379368227321) | ||
| 128834 | 128834 | 1324 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 4051X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 5991764.76245 | 2086963.37686 | 37.709930989883496 | -122.47025258193399 | (37.7099309898835, -122.470252581934) | |||
| 129769 | 129769 | 245118 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1154 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6001064.1842 | 2109354.1931 | 37.7719441624797 | -122.439716306994 | (37.7719441624797, -122.439716306994) | |||
| 130225 | 130225 | 139226 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1401 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003606.1847 | 2113661.4339 | 37.7839151368306 | -122.43123084580799 | (37.7839151368306, -122.431230845808) | |||
| 131153 | 131153 | 248433 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 718 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5997964.5796 | 2108003.6906 | 37.76805911521121 | -122.45034064885598 | (37.7680591152112, -122.450340648856) | |||
| 131504 | 131504 | 246974 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 255 Noe St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 7ft | 6002927.8614 | 2106813.40847 | 37.7650736914197 | -122.433088149808 | (37.7650736914197, -122.433088149808) | |||
| 131961 | 131961 | 128841 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011188.37532 | 2121452.8025599997 | 37.805735119545105 | -122.405548058817 | (37.8057351195451, -122.405548058817) | |||
| 132774 | 132774 | 245085 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 163 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6000283.9214 | 2109528.1943 | 37.77237748350021 | -122.442427779951 | (37.7723774835002, -122.442427779951) | |||
| 133045 | 133045 | 225879 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 3332 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006112.65396 | 2103193.2083099997 | 37.755313609161206 | -122.42181554905599 | (37.7553136091612, -122.421815549056) | |||
| 136089 | 136089 | 248382 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 708 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5997947.924 | 2108128.759 | 37.76840156792 | -122.450407275567 | (37.76840156792, -122.450407275567) | |||
| 137366 | 137366 | 225845 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 38 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 9ft | 6006048.77626 | 2104063.35692 | 37.7576992326564 | -122.42209827161301 | (37.7576992326564, -122.422098271613) | |||
| 137707 | 137707 | 140520 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 911 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6003853.2967 | 2111871.7714 | 37.7790151703313 | -122.43024820663601 | (37.7790151703313, -122.430248206636) | |||
| 137895 | 137895 | 225870 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 154 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006559.10741 | 2098855.11424 | 37.74342735780179 | -122.41996374694901 | (37.7434273578018, -122.419963746949) | |||
| 138124 | 138124 | 128839 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1661 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6005108.54777 | 2118478.70027 | 37.7972271633692 | -122.426376325029 | (37.7972271633692, -122.426376325029) | |||
| 138391 | 138391 | 21699 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1710X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | |||
| 139945 | 139945 | 16657 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 201 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002910.8788077 | 2107093.8667075 | 37.765842798192395 | -122.433166929024 | (37.7658427981924, -122.433166929024) | |||
| 140685 | 140685 | 23738 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 848 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 6003984.4734674 | 2111644.7647146 | 37.7783992952615 | -122.429778217597 | (37.7783992952615, -122.429778217597) | |||
| 141516 | 141516 | 5943 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1407 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003673.95863 | 2112759.04875 | 37.781441253516704 | -122.430931949696 | (37.7814412535167, -122.430931949696) | |||
| 142013 | 142013 | 23800 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1160 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6003835.7537369 | 2112705.7306783 | 37.7813040215007 | -122.430368411811 | (37.7813040215007, -122.430368411811) | |||
| 142601 | 142601 | 11006 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 55 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6018247.9816681 | 2094597.6118588 | 37.7323887144105 | -122.37925048612 | (37.7323887144105, -122.37925048612) | |||
| 143500 | 143500 | 23908 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1620 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6003617.383911 | 2114271.2538834 | 37.785590183829996 | -122.43123564401199 | (37.78559018383, -122.431235644012) | |||
| 145939 | 145939 | 10418 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1219X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999402.57096 | 2108712.61162 | 37.7700878253378 | -122.445417788957 | (37.7700878253378, -122.445417788957) | |||
| 145998 | 145998 | 8081 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 679 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004653.03771 | 2111392.08692 | 37.7777433402869 | -122.427447397341 | (37.7777433402869, -122.427447397341) | |||
| 146711 | 146711 | 142035 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 631 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 6004734.9181 | 2111554.9581 | 37.778195175243894 | -122.42717574897101 | (37.7781951752439, -122.427175748971) | |||
| 148119 | 148119 | 225853 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 70 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6005914.14898 | 2104056.24306 | 37.7576721055001 | -122.422563363205 | (37.7576721055001, -122.422563363205) | |||
| 148428 | 148428 | 248455 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 722 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5997972.3018 | 2107953.8752 | 37.7679227767606 | -122.450310347361 | (37.7679227767606, -122.450310347361) | |||
| 149635 | 149635 | 247736 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6001355.82425 | 2108703.21094 | 37.770173323178895 | -122.438660851038 | (37.7701733231789, -122.438660851038) | ||||
| 149737 | 149737 | 138415 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1600 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003590.5786 | 2114415.133 | 37.785983720539605 | -122.431338656815 | (37.7859837205396, -122.431338656815) | |||
| 149781 | 149781 | 182547 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2521 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5986679.7301 | 2105699.3123 | 37.7610796325405 | -122.489203768361 | (37.7610796325405, -122.489203768361) | |||
| 150732 | 150732 | 225872 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 918 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6009124.647999999 | 2103673.1383 | 37.756800785642604 | -122.41143303520599 | (37.7568007856426, -122.411433035206) | |||
| 150835 | 150835 | 245144 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1274 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000455.2634 | 2109270.2671 | 37.7716790450125 | -122.441816578597 | (37.7716790450125, -122.441816578597) | |||
| 151775 | 151775 | 225881 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 3426 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007418.72238 | 2104432.8053200003 | 37.7587908252517 | -122.417386604731 | (37.7587908252517, -122.417386604731) | |||
| 152294 | 152294 | 225856 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1242 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6004441.23544 | 2101663.28988 | 37.75101841198661 | -122.42748682946699 | (37.7510184119866, -122.427486829467) | |||
| 152600 | 152600 | 176486 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 14 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6011771.80954 | 2087312.16984 | 37.712025121923396 | -122.40112851596399 | (37.7120251219234, -122.401128515964) | |||
| 154410 | 154410 | 245927 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 745 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997935.2052 | 2107912.9933 | 37.76780840239189 | -122.45043571219 | (37.7678084023919, -122.45043571219) | |||
| 155214 | 155214 | 225860 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1400 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 4ft | 5997829.91039 | 2105879.4144599997 | 37.7622186838636 | -122.450653279939 | (37.7622186838636, -122.450653279939) | |||
| 155428 | 155428 | 139265 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 780 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004014.6878 | 2111401.0888 | 37.7777319323367 | -122.42965631110701 | (37.7777319323367, -122.429656311107) | |||
| 155580 | 155580 | 225869 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | Width 5ft | 6006549.95034 | 2098834.86462 | 37.743371240990896 | -122.419993973142 | (37.7433712409909, -122.419993973142) | |||
| 157699 | 157699 | 244875 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1325 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6000196.2123 | 2109189.1083 | 37.771441439180705 | -122.442706821096 | (37.7714414391807, -122.442706821096) | |||
| 160932 | 160932 | 225884 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 21 Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002640.58114 | 2106773.25038 | 37.7649471271327 | -122.434078909521 | (37.7649471271327, -122.434078909521) | |||
| 160958 | 160958 | 140694 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1003 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003790.2787 | 2112326.7287 | 37.7802608004471 | -122.43049868227399 | (37.7802608004471, -122.430498682274) | |||
| 162650 | 162650 | 192374 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 6015916.946 | 2106720.28142 | 37.765546220411295 | -122.38815520010901 | (37.7655462204113, -122.388155200109) | |||
| 164508 | 164508 | 140622 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 6003947.4892 | 2111192.4634 | 37.777155293276294 | -122.429873889239 | (37.7771552932763, -122.429873889239) | |||
| 164576 | 164576 | 141772 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1300 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003762.9168 | 2113237.1517 | 37.7827590448466 | -122.430658324501 | (37.7827590448466, -122.430658324501) | |||
| 168604 | 168604 | 225820 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6011084.057440001 | 2102692.0465599997 | 37.754216631403 | -122.40458757656799 | (37.754216631403, -122.404587576568) | |||
| 168857 | 168857 | 138722 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1653 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000049.7804 | 2114670.149 | 37.786482625236 | -122.443607141292 | (37.786482625236, -122.443607141292) | |||
| 169571 | 169571 | 218978 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 635 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5997875.75574 | 2094965.1361 | 37.7322533730829 | -122.449708177017 | (37.7322533730829, -122.449708177017) | ||||
| 169709 | 169709 | 142002 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 681 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004463.7555 | 2111518.3082 | 37.778079205485 | -122.428111187061 | (37.778079205485, -122.428111187061) |
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");