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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 176213 | 176213 | 117711 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 499 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5983128.07701 | 2112627.91147 | 37.779895618618 | -122.50199989527701 | (37.779895618618, -122.501999895277) | |||
| 178782 | 178782 | 117712 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 499 41st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5983131.36299 | 2112604.59919 | 37.7798318029571 | -122.501986802339 | (37.7798318029571, -122.501986802339) | |||
| 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) | ||
| 134492 | 134492 | 109833 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2525 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5986661.7219 | 2105698.5773 | 37.761076563265 | -122.489265996065 | (37.761076563265, -122.489265996065) | ||||
| 110420 | 110420 | 109834 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2521 JUDAH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 2x2 | 5986663.0 | 2105677.0 | 37.7610173925517 | -122.489259989237 | (37.7610173925517, -122.489259989237) | |||
| 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) | |||
| 41129 | 41129 | 95156 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 21 | 5988717.78601 | 2113765.0163 | 37.7833445754979 | -122.48274619510799 | (37.7833445754979, -122.482746195108) | |||
| 146991 | 146991 | 95155 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 5988718.098730001 | 2113738.3311400004 | 37.7832713237769 | -122.482743157022 | (37.7832713237769, -122.482743157022) | |||
| 70878 | 70878 | 95154 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 5988718.8555 | 2113711.8550400003 | 37.783198671909794 | -122.48273859805 | (37.7831986719098, -122.48273859805) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 149599 | 149599 | 103034 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 646 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5990990.666019999 | 2111015.32542 | 37.775926658519296 | -122.474682255974 | (37.7759266585193, -122.474682255974) | |||
| 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) | |
| 61784 | 61784 | 124031 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 101 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5991786.57969 | 2114495.60147 | 37.785528628097296 | -122.472182755667 | (37.7855286280973, -122.472182755667) | |||
| 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) | |||
| 131678 | 131678 | 218980 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5991479.42203 | 2093975.5381 | 37.729168161565596 | -122.47174944968 | (37.7291681615656, -122.47174944968) | |||
| 55255 | 55255 | 218981 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991484.23887 | 2094055.3535200001 | 37.7293875934485 | -122.47173861195 | (37.7293875934485, -122.47173861195) | |||
| 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) | |||
| 36930 | 36930 | 123091 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 625 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5992511.629819999 | 2111163.49628 | 37.776421509726795 | -122.46943168307301 | (37.7764215097268, -122.469431683073) | |||
| 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) | |
| 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) | ||
| 51104 | 51104 | 218982 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 765 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5994400.37766 | 2089911.3418700001 | 37.7181774299307 | -122.46135702892599 | (37.7181774299307, -122.461357028926) | |||
| 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) | |||
| 150110 | 150110 | 218983 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 145 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5994996.58862 | 2099522.38942 | 37.7446013220014 | -122.459992061292 | (37.7446013220014, -122.459992061292) | |||
| 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) | ||
| 39496 | 39496 | 128828 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 435 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997654.94419 | 2114925.25732 | 37.7870462100671 | -122.45191104747101 | (37.7870462100671, -122.451911047471) | |||
| 54232 | 54232 | 128829 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 435 Locust St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997655.29995 | 2114907.57058 | 37.7869976673453 | -122.45190854016 | (37.7869976673453, -122.45190854016) | |||
| 34669 | 34669 | 128830 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 435 Locust St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997658.68844 | 2114896.31526 | 37.7869669572999 | -122.451896004506 | (37.7869669572999, -122.451896004506) | |||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | |||
| 180611 | 180611 | 248461 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 737 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5997928.543 | 2107954.7837 | 37.7679227668769 | -122.45046176887199 | (37.7679227668769, -122.450461768872) | |||
| 48870 | 48870 | 248472 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 739 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997932.4798 | 2107931.7687 | 37.7678597988713 | -122.45044649265101 | (37.7678597988713, -122.450446492651) | |||
| 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) | |||
| 183427 | 183427 | 245928 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 745 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997937.6279 | 2107896.9433 | 37.7677644718406 | -122.45042617523501 | (37.7677644718406, -122.450426175235) | |||
| 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) | ||
| 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) | |||
| 77091 | 77091 | 245948 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 751 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997946.7127 | 2107822.2959 | 37.7675600290425 | -122.45038937038099 | (37.7675600290425, -122.450389370381) | |||
| 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) | |||
| 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) | |||
| 46763 | 46763 | 225859 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5998015.015430001 | 2107655.1459 | 37.7671049865286 | -122.450141071966 | (37.7671049865286, -122.450141071966) | |||
| 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) | ||||
| 77057 | 77057 | 244222 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 403 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5998378.2216 | 2109230.1948 | 37.771450447350205 | -122.44899827507099 | (37.7714504473502, -122.448998275071) | |||
| 68047 | 68047 | 218985 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 735 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5998106.15759 | 2095768.84675 | 37.7344733504624 | -122.448969503563 | (37.7344733504624, -122.448969503563) | |||
| 42002 | 42002 | 247256 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 495 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998886.7546 | 2109090.8048 | 37.7710967882875 | -122.44722920696002 | (37.7710967882875, -122.44722920696) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 157043 | 157043 | 140110 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 530 Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5999154.3839 | 2110993.6634 | 37.7763368408046 | -122.446440388413 | (37.7763368408046, -122.446440388413) | |||
| 165008 | 165008 | 140106 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 570 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 5999163.5213 | 2110903.9816 | 37.7760911194684 | -122.446402326499 | (37.7760911194684, -122.446402326499) | |||
| 78070 | 78070 | 14506 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 6X6 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
| 84493 | 84493 | 14510 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 6X6 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
| 104204 | 104204 | 14512 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
| 123150 | 123150 | 14511 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
| 70099 | 70099 | 141636 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5999161.9551 | 2110417.0445 | 37.7747540254261 | -122.446372706542 | (37.7747540254261, -122.446372706542) | |||
| 87397 | 87397 | 14536 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 92924 | 92924 | 14535 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 107403 | 107403 | 14539 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 112962 | 112962 | 14532 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 116039 | 116039 | 14534 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 119571 | 119571 | 14537 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 70 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 119891 | 119891 | 14538 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 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) | |||
| 124314 | 124314 | 14533 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 184285 | 184285 | 140248 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 703 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5999166.4977 | 2110388.5774 | 37.77467612149329 | -122.44635494450701 | (37.7746761214933, -122.446354944507) | |||
| 174984 | 174984 | 140249 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 705 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 5999170.7375 | 2110360.1102 | 37.7745981999883 | -122.446338229944 | (37.7745981999883, -122.446338229944) | |||
| 63548 | 63548 | 140250 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 707 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 5999174.9773 | 2110335.2771 | 37.7745302567897 | -122.446321776898 | (37.7745302567897, -122.446321776898) | |||
| 147706 | 147706 | 140251 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 709 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 5999178.3085 | 2110310.1412 | 37.7744614302846 | -122.446308445103 | (37.7744614302846, -122.446308445103) | |||
| 162605 | 162605 | 140252 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 711 Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5999181.9426 | 2110282.5826 | 37.774385968961 | -122.44629389123399 | (37.774385968961, -122.446293891234) | |||
| 156087 | 156087 | 140253 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 713 Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999184.6682 | 2110258.3552 | 37.774319602373296 | -122.446282719732 | (37.7743196023733, -122.446282719732) | |||
| 168614 | 168614 | 140254 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 715 Masonic Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5999189.5137 | 2110231.4023 | 37.774245873326294 | -122.44626401906 | (37.7742458733263, -122.44626401906) | |||
| 159853 | 159853 | 140255 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 717 Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 0ft | 5999192.2393 | 2110210.2033 | 37.7741878219471 | -122.44625306549801 | (37.7741878219471, -122.446253065498) | |||
| 110122 | 110122 | 14584 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1159 Masonic Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 100 | 4x4 | 5999323.48045 | 2108827.83023 | 37.7703996711999 | -122.445699648114 | (37.7703996711999, -122.445699648114) | |||
| 178588 | 178588 | 112518 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1849 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5999474.66705 | 2115314.93957 | 37.7882202345095 | -122.44564326833401 | (37.7882202345095, -122.445643268334) | |||
| 172737 | 172737 | 247291 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1167 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5999365.8341 | 2108846.2504 | 37.7704526663824 | -122.44555447206699 | (37.7704526663824, -122.445554472067) | |||
| 45480 | 45480 | 247292 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1177 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999383.1114 | 2108836.268 | 37.770426243584104 | -122.44549399211701 | (37.7704262435841, -122.445493992117) | |||
| 82530 | 82530 | 14583 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1159 Masonic Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 60 | 4X4 | 5999386.3171 | 2108834.4593 | 37.7704214603588 | -122.445482773554 | (37.7704214603588, -122.445482773554) | |||
| 61678 | 61678 | 245995 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1211 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5999389.3905 | 2108708.3738 | 37.770075436927705 | -122.44546307506901 | (37.7700754369277, -122.445463075069) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 65804 | 65804 | 245998 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1211 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999402.4121 | 2108663.858 | 37.769953951156 | -122.445414832365 | (37.769953951156, -122.445414832365) | |||
| 98223 | 98223 | 10420 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1219X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999405.64403 | 2108687.20317 | 37.7700182355876 | -122.445405332062 | (37.7700182355876, -122.445405332062) | |||
| 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) | |||
| 82641 | 82641 | 10412 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1154X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 5999422.66976 | 2108913.34746 | 37.7706401425115 | -122.445362703114 | (37.7706401425115, -122.445362703114) | ||||
| 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) | |||
| 96659 | 96659 | 10421 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1219X Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999421.35342 | 2108678.34127 | 37.7699947998181 | -122.44535035645 | (37.7699947998181, -122.44535035645) | |||
| 179740 | 179740 | 247506 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1156 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999445.2509 | 2108843.2771 | 37.7704490360361 | -122.445279556183 | (37.7704490360361, -122.445279556183) | |||
| 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) | |||
| 70852 | 70852 | 247505 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1170 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5999449.0461 | 2108807.2233 | 37.7703502580574 | -122.44526383601999 | (37.7703502580574, -122.44526383602) | |||
| 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) | |
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 65364 | 65364 | 245086 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 163 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000286.248 | 2109508.2514 | 37.772322857937205 | -122.44241830003 | (37.7723228579372, -122.44241830003) |
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");