Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17 | 17 | 145278 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 730 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2017 12:00:00 AM | 0 | Width 3ft | Permit Number 779614 | 5992589.961569999 | 2110455.11477 | 37.774481011910204 | -122.469109146279 | (37.7744810119102, -122.469109146279) | |
| 719 | 719 | 246969 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 1 | : 4 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 9 | Width 4ft | Permit Number 778955 | 6002937.11929 | 2106633.84457 | 37.7645811776972 | -122.433043298823 | (37.7645811776972, -122.433043298823) | |
| 80688 | 80688 | 14354 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778955 | 6002931.216347099 | 2106726.8081779 | 37.7648360983599 | -122.43307035800699 | (37.7648360983599, -122.433070358007) | |
| 30539 | 30539 | 56277 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 70 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2016 12:00:00 AM | 3 | Permit Number 778721 | 6005870.964575401 | 2104060.4446756 | 37.757681205790206 | -122.42271301134599 | (37.7576812057902, -122.422713011346) | ||
| 4297 | 4297 | 50999 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 3000X Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/2010 12:00:00 AM | 3 | 3x3 | Permit Number 774202 | 5999788.70466 | 2116412.94537 | 37.7912529948724 | -122.444635704772 | (37.7912529948724, -122.444635704772) | |
| 5689 | 5689 | 51000 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 3000X Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/2010 12:00:00 AM | 3 | 3x3 | Permit Number 774202 | 5999777.56327 | 2116411.2536400002 | 37.7912477140612 | -122.444674131902 | (37.7912477140612, -122.444674131902) | |
| 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) | ||
| 72530 | 72530 | 107389 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 773951 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | ||||
| 79285 | 79285 | 107390 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 773951 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | ||||
| 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) | ||||
| 117322 | 117322 | 107388 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 773951 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | ||||
| 93991 | 93991 | 107500 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1101x PAGE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | Permit Number 773474 | 6001297.0 | 2109248.0 | 37.7716658315653 | -122.438903370258 | (37.7716658315653, -122.438903370258) | ||
| 93662 | 93662 | 104651 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 21 Beaver St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770906 | 6002646.8 | 2106754.0 | 37.7648946232156 | -122.43405602387301 | (37.7648946232156, -122.434056023873) | |||||
| 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) | |||
| 66955 | 66955 | 30368 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 406 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1956 12:00:00 AM | 43 | Permit Number 56 | 6012907.774259999 | 2105144.73435 | 37.761052931381 | -122.398452757696 | (37.761052931381, -122.398452757696) | ||
| 96681 | 96681 | 52015 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 282 29th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.42625790812401 | (37.7437962026999, -122.426257908124) | |||
| 98309 | 98309 | 52013 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 282 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.42625790812401 | (37.7437962026999, -122.426257908124) | |||
| 111349 | 111349 | 52016 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 282 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.42625790812401 | (37.7437962026999, -122.426257908124) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 2149 | 2149 | 225887 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 117 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 42143 | 6001804.962730001 | 2096660.33983 | 37.73713202700829 | -122.436245312495 | (37.7371320270083, -122.436245312495) | |
| 54662 | 54662 | 40381 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 336 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1999 12:00:00 AM | Permit Number 41493 | 6002951.47000009 | 2101559.64792523 | 37.7506494618032 | -122.432631180412 | (37.7506494618032, -122.432631180412) | |||
| 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) | ||
| 26815 | 26815 | 68776 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 499 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | 16 | Permit Number 32706 | 5983126.84332 | 2112651.33679 | 37.7799598652159 | -122.50200589693199 | (37.7799598652159, -122.502005896932) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | ||
| 28216 | 28216 | 58361 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 435 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1978 12:00:00 AM | 13 | Permit Number 17389 | 5997651.60838 | 2114939.03748 | 37.7870838556688 | -122.45192358310601 | (37.7870838556688, -122.451923583106) | ||
| 24080 | 24080 | 58360 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 457 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1978 12:00:00 AM | 16 | Permit Number 17388 | 5997662.21392 | 2114878.66722 | 37.786918702384796 | -122.45188253354999 | (37.7869187023848, -122.45188253355) | ||
| 61916 | 61916 | 57851 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1001 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | 20 | Permit Number 16792 | 6003796.0811 | 2112295.2301 | 37.780174641820004 | -122.430476360985 | (37.78017464182, -122.430476360985) | ||
| 49132 | 49132 | 57220 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2525 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/1975 12:00:00 AM | 8 | Permit Number 14507 | 5986650.329 | 2105697.8423 | 37.761073880118396 | -122.489305344609 | (37.7610738801184, -122.489305344609) | ||
| 64512 | 64512 | 57085 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 725 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 15 | Permit Number 14352 | 6011859.01316 | 2104976.52396 | 37.7605325827245 | -122.40206816360799 | (37.7605325827245, -122.402068163608) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 77596 | 77596 | 56267 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 20 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 20 | 6x6 | Permit Number 12393 | 6006178.98761338 | 2104077.53782444 | 37.7577455134305 | -122.42164895373101 | (37.7577455134305, -122.421648953731) | |
| 1161 | 1161 | 228132 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 236 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 23 | Width 3ft | Permit Number 12386 | 5997539.90606 | 2106468.8722 | 37.7638205814857 | -122.451698812867 | (37.7638205814857, -122.451698812867) | |
| 41509 | 41509 | 54991 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 646 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 13 | 3x3 | Permit Number 10869 | 5990991.81393 | 2111001.00614 | 37.7758874082105 | -122.474677239765 | (37.7758874082105, -122.474677239765) | |
| 35734 | 35734 | 54990 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 643 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 11 | Permit Number 10868 | 5990941.26745 | 2111008.08375 | 37.7759039123762 | -122.47485260799101 | (37.7759039123762, -122.474852607991) | ||
| 52930 | 52930 | 54989 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 639 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 8 | Permit Number 10867 | 5990941.20394 | 2111018.6338299997 | 37.77593287632679 | -122.474853597928 | (37.7759328763268, -122.474853597928) | ||
| 696 | 696 | 5946 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1415 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003699.8521 | 2112803.046 | 37.7815635260957 | -122.43084551167601 | (37.7815635260957, -122.430845511676) | |||
| 715 | 715 | 246970 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 2 | : 4 | Tree 1 | DPW 2 | 9 | Width 4ft | 6002947.4073 | 2106634.57369 | 37.764583763244794 | -122.43300776749099 | (37.7645837632448, -122.433007767491) | |||
| 1385 | 1385 | 23847 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1370 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003735.9392 | 2113413.2165 | 37.7832409463281 | -122.43076422395599 | (37.7832409463281, -122.430764223956) | |||
| 1657 | 1657 | 251641 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1785 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6003432.0 | 2114811.0 | 37.787061682920395 | -122.43191557230301 | (37.7870616829204, -122.431915572303) | ||||
| 1662 | 1662 | 251640 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1785 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6003432.0 | 2114811.0 | 37.787061682920395 | -122.43191557230301 | (37.7870616829204, -122.431915572303) | ||||
| 2038 | 2038 | 23713 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 709 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003942.7402 | 2111225.1787 | 37.7772448524761 | -122.429892651683 | (37.7772448524761, -122.429892651683) | |||
| 2117 | 2117 | 5944 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1415 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003654.4203 | 2112794.2785 | 37.78153687853621 | -122.43100205797701 | (37.7815368785362, -122.431002057977) | |||
| 2242 | 2242 | 23928 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1715 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6003464.0168 | 2114669.7894 | 37.7866757692841 | -122.431794715065 | (37.7866757692841, -122.431794715065) | |||
| 2714 | 2714 | 141996 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 WEBSTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 0ft | 6003983.1859 | 2111655.6546 | 37.7784291232811 | -122.42978344870899 | (37.7784291232811, -122.429783448709) | |||
| 2717 | 2717 | 141997 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 WEBSTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 0ft | 6003978.0604 | 2111685.2682 | 37.7785101446541 | -122.42980329253 | (37.7785101446541, -122.42980329253) | |||
| 2718 | 2718 | 141991 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004002.4362 | 2111527.1662 | 37.7780774159831 | -122.429707688099 | (37.7780774159831, -122.429707688099) | |||
| 2724 | 2724 | 141999 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 WEBSTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003970.657000001 | 2111746.2039 | 37.778677039760794 | -122.429833251248 | (37.7786770397608, -122.429833251248) | |||
| 2725 | 2725 | 141994 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 0ft | 6003989.735 | 2111607.5325 | 37.7782973627546 | -122.429757359707 | (37.7782973627546, -122.429757359707) | |||
| 2728 | 2728 | 142000 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 WEBSTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 0ft | 6003967.2401 | 2111768.9836 | 37.7787393936814 | -122.429846696894 | (37.7787393936814, -122.429846696894) | |||
| 3202 | 3202 | 14513 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999073.0679 | 2111076.7771 | 37.776560404910796 | -122.4467276636 | (37.7765604049108, -122.4467276636) | |||
| 3257 | 3257 | 253379 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3262 | 3262 | 253382 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3270 | 3270 | 253380 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3271 | 3271 | 253381 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3279 | 3279 | 253383 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 4608 | 4608 | 4436 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1292 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/2017 12:00:00 AM | 3 | 3X3 | 6004456.3598 | 2101397.3807200002 | 37.75028914274171 | -122.42741558697901 | (37.7502891427417, -122.427415586979) | ||
| 4904 | 4904 | 23927 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1715 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6003460.7841 | 2114695.1886 | 37.7867453258178 | -122.43180771362199 | (37.7867453258178, -122.431807713622) | |||
| 5289 | 5289 | 5945 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1415 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6003671.9554 | 2112797.4667 | 37.7815466261115 | -122.43094162257 | (37.7815466261115, -122.43094162257) | |||
| 5913 | 5913 | 23706 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 8X8 | 6003994.1877 | 2111257.6303 | 37.7773368699173 | -122.42971699343799 | (37.7773368699173, -122.429716993438) | |||
| 5918 | 5918 | 23710 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003962.5277 | 2111419.0963 | 37.77777842285779 | -122.429838035535 | (37.7777784228578, -122.429838035535) | |||
| 6042 | 6042 | 14515 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 515 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 4X4 | 5999080.7636 | 2111027.2361 | 37.7764248176545 | -122.44669747668699 | (37.7764248176545, -122.446697476687) | |||
| 6955 | 6955 | 23850 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1401X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003612.0155 | 2113606.6244 | 37.7837649741264 | -122.43120675986401 | (37.7837649741264, -122.431206759864) | |||
| 7093 | 7093 | 23752 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 34 | 4X4 | 6003928.8061 | 2112053.0316 | 37.7795171425157 | -122.429999922728 | (37.7795171425157, -122.429999922728) | |||
| 7229 | 7229 | 23933 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1737 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4X4 | 6003453.8571 | 2114739.0598 | 37.7868653923719 | -122.431834813039 | (37.7868653923719, -122.431834813039) | |||
| 7253 | 7253 | 23719 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 780 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/1999 12:00:00 AM | 80 | 4X4 | 6004022.2052 | 2111346.6982 | 37.777583014840296 | -122.429626425718 | (37.7775830148403, -122.429626425718) | ||
| 7451 | 7451 | 28768 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6X6 | 5999147.2771 | 2111039.3503 | 37.7764618793954 | -122.446468260318 | (37.7764618793954, -122.446468260318) | |||
| 7466 | 7466 | 23749 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6003935.7161 | 2111981.6282 | 37.779321477825704 | -122.429970923277 | (37.7793214778257, -122.429970923277) | |||
| 7469 | 7469 | 23746 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6003946.8489 | 2111892.9498 | 37.779078619397396 | -122.429926083012 | (37.7790786193974, -122.429926083012) | |||
| 7515 | 7515 | 23751 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 29 | 4x4 | 6003930.3417 | 2112029.9983 | 37.7794539857546 | -122.42999296692899 | (37.7794539857546, -122.429992966929) | |||
| 7686 | 7686 | 23718 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 760 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1992 12:00:00 AM | 12 | 4X4 | 6004031.4914 | 2111284.7902 | 37.7774135565599 | -122.429589885322 | (37.7774135565599, -122.429589885322) | ||
| 7737 | 7737 | 8094 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 762 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 100 | 3X3 | 6004211.6397 | 2111535.7715 | 37.7781128879326 | -122.428984591665 | (37.7781128879326, -122.428984591665) | |||
| 7937 | 7937 | 28767 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6X6 | 5999141.8623 | 2111078.2688 | 37.7765684303305 | -122.44648979216299 | (37.7765684303305, -122.446489792163) | |||
| 8490 | 8490 | 23932 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1737 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4x4 | 6003450.6245 | 2114754.2993 | 37.7869070529375 | -122.43184708562299 | (37.7869070529375, -122.431847085623) | |||
| 8689 | 8689 | 23745 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 4x4 | 6003951.3115 | 2111867.7982 | 37.779009812059 | -122.429908850506 | (37.779009812059, -122.429908850506) | |||
| 8799 | 8799 | 23802 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1160 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6003829.6195 | 2112722.1937 | 37.7813488773836 | -122.43039080821998 | (37.7813488773836, -122.43039080822) | |||
| 8983 | 8983 | 23748 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 38 | 4x4 | 6003941.8583 | 2111953.2204 | 37.779243824898295 | -122.42994764790701 | (37.7792438248983, -122.429947647907) | |||
| 9109 | 9109 | 23140 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1621X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 6004632.02812 | 2099337.8259 | 37.744644014501205 | -122.42666146912599 | (37.7446440145012, -122.426661469126) | |||
| 9261 | 9261 | 23750 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4x4 | 6003934.1806 | 2112005.4294 | 37.779386743058296 | -122.429977933491 | (37.7793867430583, -122.429977933491) | |||
| 9347 | 9347 | 23747 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | 4x4 | 6003945.3133 | 2111922.8931 | 37.779160749313895 | -122.42993353175301 | (37.7791607493139, -122.429933531753) | |||
| 9527 | 9527 | 9961 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004044.3152 | 2111193.6969 | 37.777164162929 | -122.429539025484 | (37.777164162929, -122.429539025484) | |||
| 9878 | 9878 | 14590 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1221 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5999397.8697 | 2108638.7231 | 37.7698846777669 | -122.44542873681401 | (37.7698846777669, -122.445428736814) | |||
| 17342 | 17342 | 16656 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 200 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 6002872.09203 | 2107040.69534 | 37.7656946022435 | -122.433297284454 | (37.7656946022435, -122.433297284454) | |||
| 17417 | 17417 | 14589 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1221 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5999408.7715 | 2108648.7165 | 37.769912739454604 | -122.445391746523 | (37.7699127394546, -122.445391746523) | |||
| 17501 | 17501 | 16632 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 150 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002845.7066 | 2107359.01628 | 37.7665671370879 | -122.433411295115 | (37.7665671370879, -122.433411295115) | |||
| 17618 | 17618 | 16652 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 198 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X5 | 6002855.56746 | 2107156.83131 | 37.7660125458771 | -122.43336273892 | (37.7660125458771, -122.43336273892) | |||
| 17700 | 17700 | 4504 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1780 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 4X4 | 6004619.48057 | 2098494.87239 | 37.7423287477646 | -122.426644841002 | (37.7423287477646, -122.426644841002) | |||
| 17793 | 17793 | 16659 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 201 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X4 | 6002918.29496 | 2107052.8377799997 | 37.765730563431894 | -122.43313834635 | (37.7657305634319, -122.43313834635) | |||
| 18104 | 18104 | 23633 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 198X Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006450.06706 | 2098653.35241 | 37.7428672213344 | -122.42032646421801 | (37.7428672213344, -122.420326464218) | |||
| 18178 | 18178 | 4495 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1618 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1990 12:00:00 AM | 18 | 3x3 | 6004570.56721 | 2099356.4076799997 | 37.744691560861895 | -122.426875312064 | (37.7446915608619, -122.426875312064) | ||
| 18347 | 18347 | 14360 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X5 | 6002944.99981 | 2106698.0348400003 | 37.7647578756004 | -122.43302062870501 | (37.7647578756004, -122.433020628705) | |||
| 18383 | 18383 | 4503 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1767 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004674.71192 | 2098595.28716 | 37.742607586167395 | -122.42646101595601 | (37.7426075861674, -122.426461015956) | |||
| 18531 | 18531 | 16655 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 200 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5X4 | 6002860.3108 | 2107045.92477 | 37.765708292624296 | -122.433338406847 | (37.7657082926243, -122.433338406847) | |||
| 18603 | 18603 | 14356 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002946.4626400005 | 2106656.3475200003 | 37.764643495314296 | -122.43301259056801 | (37.7646434953143, -122.433012590568) |
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");