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) | |
| 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) | |||
| 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) | |
| 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) | |
| 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) | |||
| 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) | |
| 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) | |||||
| 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) | |
| 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) | |||
| 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) | |
| 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) | |||
| 18912 | 18912 | 4820 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 398X Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 4x4 | 6006006.1956778 | 2097849.2293648 | 37.7406342583881 | -122.42180414448299 | (37.7406342583881, -122.421804144483) | |||
| 19125 | 19125 | 28638 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.777378207850795 | -122.42957257421499 | (37.7773782078508, -122.429572574215) | |||
| 19670 | 19670 | 16660 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 201 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X3 | 6002906.0863 | 2107052.64489 | 37.76572934125 | -122.433180559653 | (37.76572934125, -122.433180559653) | |||
| 19713 | 19713 | 16653 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 198 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 6X6 | 6002873.0768099995 | 2107160.80802 | 37.7660244582848 | -122.43330246186399 | (37.7660244582848, -122.433302461864) | |||
| 19858 | 19858 | 10411 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1160 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 5999445.7253 | 2108826.6734 | 37.7704034735557 | -122.445276721272 | (37.7704034735557, -122.445276721272) | |||
| 19909 | 19909 | 16683 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 255 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 10X9 | 6002919.68827 | 2106838.75041 | 37.7651428106103 | -122.433118229438 | (37.7651428106103, -122.433118229438) | |||
| 20159 | 20159 | 14361 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5X5 | 6002933.12369 | 2106696.89177 | 37.764754063359796 | -122.433061623395 | (37.7647540633598, -122.433061623395) | |||
| 20195 | 20195 | 16682 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 259 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 10X9 | 6002924.1082 | 2106824.1942 | 37.76510309351521 | -122.43310190188 | (37.7651030935152, -122.43310190188) | |||
| 20237 | 20237 | 16633 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 150 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002856.03732 | 2107366.99767 | 37.7665896381334 | -122.43337613341002 | (37.7665896381334, -122.43337613341) | |||
| 20277 | 20277 | 16663 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 207 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002906.06809 | 2107042.07255 | 37.7657003111441 | -122.43317986716002 | (37.7657003111441, -122.43317986716) | |||
| 20745 | 20745 | 14359 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002945.74556 | 2106677.88542 | 37.7647025924854 | -122.433016609656 | (37.7647025924854, -122.433016609656) | |||
| 20771 | 20771 | 4502 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1763 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6004673.08752 | 2098626.19455 | 37.7426923589722 | -122.426468832889 | (37.7426923589722, -122.426468832889) | |||
| 20858 | 20858 | 14357 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002936.44481 | 2106655.1660700003 | 37.764639683102395 | -122.43304715512899 | (37.7646396831024, -122.433047155129) | |||
| 21077 | 21077 | 16677 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 247 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6X8 | 6002925.629869999 | 2106851.64017 | 37.7651785397952 | -122.433098599934 | (37.7651785397952, -122.433098599934) | |||
| 21088 | 21088 | 16664 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 207 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002919.64524 | 2107042.50705 | 37.7657022743565 | -122.433132937832 | (37.7657022743565, -122.433132937832) | |||
| 21343 | 21343 | 14358 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002934.58534 | 2106677.65284 | 37.764701320838796 | -122.43305519326599 | (37.7647013208388, -122.433055193266) | |||
| 21368 | 21368 | 4571 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 229 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 4x4 | 6006415.89392 | 2098506.82504 | 37.7424629643998 | -122.42043422728399 | (37.7424629643998, -122.420434227284) | |||
| 22065 | 22065 | 4564 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 203 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6006429.48639 | 2098539.4739099997 | 37.7425533768305 | -122.42038954535101 | (37.7425533768305, -122.420389545351) | |||
| 23227 | 23227 | 2679 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2085 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6003592.8137 | 2114862.3516 | 37.7872117965975 | -122.43136285998101 | (37.7872117965975, -122.431362859981) | |||
| 23844 | 23844 | 192384 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 6015929.33713 | 2106466.90045 | 37.7648511775542 | -122.38809465775 | (37.7648511775542, -122.38809465775) | |||
| 23876 | 23876 | 218979 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 551 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991462.95986 | 2093729.88952 | 37.7284927194476 | -122.47178846497101 | (37.7284927194476, -122.471788464971) | |||
| 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) | ||
| 24409 | 24409 | 139234 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1401 WEBSTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003647.0002 | 2113350.0697 | 37.783062521715 | -122.431067408706 | (37.783062521715, -122.431067408706) | |||
| 25298 | 25298 | 245131 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1264 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000494.8167 | 2109275.2528 | 37.7716949881709 | -122.44168011954399 | (37.7716949881709, -122.441680119544) | |||
| 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) | |
| 26817 | 26817 | 139262 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004035.029 | 2111258.7004 | 37.7773421207118 | -122.429575786462 | (37.7773421207118, -122.429575786462) | |||
| 27154 | 27154 | 192389 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 450 Amador St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 6018217.012999999 | 2099612.2395900004 | 37.746156176965606 | -122.37970582128901 | (37.7461561769656, -122.379705821289) | |||
| 27230 | 27230 | 218984 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 145 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5994984.805980001 | 2099511.62786 | 37.744571095774 | -122.46003202358101 | (37.744571095774, -122.460032023581) | |||
| 27348 | 27348 | 225835 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6010878.34698 | 2102482.51525 | 37.7536298057935 | -122.40528422380899 | (37.7536298057935, -122.405284223809) | |||
| 27894 | 27894 | 128840 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 4 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6011231.32586 | 2121455.9320099996 | 37.8057461137655 | -122.40539964187599 | (37.8057461137655, -122.405399641876) | |||
| 27922 | 27922 | 225842 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 20 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 6ft | 6006154.9324 | 2104068.30883 | 37.7577188162864 | -122.421731491214 | (37.7577188162864, -122.421731491214) | |||
| 28136 | 28136 | 247011 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Valley St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6002619.5945 | 2099198.996 | 37.7441488398068 | -122.433610141488 | (37.7441488398068, -122.433610141488) | ||||
| 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) | ||
| 28273 | 28273 | 245996 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1211 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5999394.2357 | 2108683.5418 | 37.7700075311334 | -122.445444529843 | (37.7700075311334, -122.445444529843) | |||
| 28615 | 28615 | 248431 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 721 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 0ft | 5997917.0355 | 2108037.1532 | 37.7681482738929 | -122.450507510702 | (37.7681482738929, -122.450507510702) | |||
| 28691 | 28691 | 247010 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Valley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6002631.32186 | 2099201.86815 | 37.74415739146121 | -122.433569796116 | (37.7441573914612, -122.433569796116) |
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");