Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 595 | 595 | 119606 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 299x Avalon Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 1095 | 1095 | 54070 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1649 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 1 | Permit Number 9793 | 5981260.4052 | 2103836.5943 | 37.7556473215408 | -122.50780830550801 | (37.7556473215408, -122.507808305508) | ||
| 1262 | 1262 | 251479 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1214 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 779194 | 5987090.84961 | 2106996.2792700003 | 37.7646647351899 | -122.48787719677 | (37.7646647351899, -122.48787719677) | ||||
| 1423 | 1423 | 54061 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 330 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 12 | Permit Number 779745 | 5988745.7457 | 2113084.32895 | 37.7814772265446 | -122.482599571173 | (37.7814772265446, -122.482599571173) | ||
| 9912 | 9912 | 173731 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 484 Chenery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003566.0 | 2096120.0 | 37.7357482768139 | -122.43011807363199 | (37.7357482768139, -122.430118073632) | |||||
| 10036 | 10036 | 64803 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 110X VALLEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779438 | 6005124.0 | 2099350.0 | 37.7447052436017 | -122.424961191686 | (37.7447052436017, -122.424961191686) | |
| 11349 | 11349 | 104508 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 80 Dichiera Ct | 1 | Sidewalk: Curb side : Hanging Pot 15 | Tree 1 | Private 1 | 14 | 5998566.299869999 | 2087993.98473 | 37.7131516918716 | -122.446819386407 | (37.7131516918716, -122.446819386407) | ||||
| 13301 | 13301 | 187651 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 175 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998689.0 | 2104063.0 | 37.7572803991188 | -122.447551270828 | (37.7572803991188, -122.447551270828) | |||||
| 20976 | 20976 | 108213 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 126 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995164.0 | 2113575.0 | 37.783195780257 | -122.46043122472 | (37.783195780257, -122.46043122472) | |||||
| 23806 | 23806 | 232314 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 99 Elsie St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6007320.806890001 | 2098778.15204 | 37.7432589210582 | -122.417324523624 | (37.7432589210582, -122.417324523624) | ||||
| 25830 | 25830 | 61870 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3657 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1985 12:00:00 AM | 18 | Permit Number 21910 | 5997325.23307 | 2115369.87037 | 37.7882481090091 | -122.453083875833 | (37.7882481090091, -122.453083875833) | ||
| 26378 | 26378 | 118551 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 8140 Geary Blvd | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 5981667.59483 | 2112398.2493 | 37.7791791285325 | -122.50703522193999 | (37.7791791285325, -122.50703522194) | ||||
| 27599 | 27599 | 232417 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 173 Everson St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6002718.41885 | 2097663.27226 | 37.7399377058635 | -122.433158722322 | (37.7399377058635, -122.433158722322) | ||||
| 28873 | 28873 | 177837 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650 Peru Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | ||||
| 29143 | 29143 | 248220 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007112.652530001 | 2099342.90806 | 37.7447979012027 | -122.41808429785499 | (37.7447979012027, -122.418084297855) | ||||
| 29571 | 29571 | 194075 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 30 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | 6011495.74471 | 2097425.71535 | 37.739779425186704 | -122.402793501934 | (37.7397794251867, -122.402793501934) | ||||
| 29851 | 29851 | 210532 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 47 Ralston St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 5992170.38695 | 2088246.7586700001 | 37.7134782905637 | -122.46894401367099 | (37.7134782905637, -122.468944013671) | ||||
| 30242 | 30242 | 247859 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Bradford St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6009590.028030001 | 2098126.55062 | 37.741597175379894 | -122.409432139892 | (37.7415971753799, -122.409432139892) | ||||
| 30347 | 30347 | 35172 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 400 40th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 12 | Permit Number 38706 | 5983466.53844 | 2113086.7632299997 | 37.7811753688678 | -122.50086296861099 | (37.7811753688678, -122.500862968611) | ||
| 30481 | 30481 | 247913 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Franconia St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009968.0552900005 | 2098803.93583 | 37.743478301698296 | -122.40817280665001 | (37.7434783016983, -122.40817280665) | ||||
| 31069 | 31069 | 35171 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 400 40th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 13 | Permit Number 38706 | 5983467.302999999 | 2113078.2669599997 | 37.7811520854856 | -122.500859695146 | (37.7811520854856, -122.500859695146) | ||
| 32406 | 32406 | 194091 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Apparel Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6011263.07589 | 2097812.25269 | 37.7408277801759 | -122.403625166174 | (37.7408277801759, -122.403625166174) | ||||
| 33334 | 33334 | 66658 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1601 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1991 12:00:00 AM | 11 | Permit Number 29873 | 5989617.5654 | 2104410.2875 | 37.7577113621685 | -122.478948892591 | (37.7577113621685, -122.478948892591) | ||
| 34434 | 34434 | 83787 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1926 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 9 | 5981682.722 | 2101945.6334 | 37.750480149523796 | -122.506207617383 | (37.7504801495238, -122.506207617383) | ||
| 35296 | 35296 | 75017 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Dorman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1997 12:00:00 AM | 14 | 6011095.51982 | 2097238.5902400003 | 37.7392432646533 | -122.40416415145201 | (37.7392432646533, -122.404164151452) | ||
| 35348 | 35348 | 194039 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900x Carolina St | 74 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6012510.33858 | 2102789.20195 | 37.754563007990896 | -122.399661931254 | (37.7545630079909, -122.399661931254) | ||||
| 35354 | 35354 | 194072 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2280 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | 6011322.76778 | 2098041.04793 | 37.7414593371741 | -122.40343486513399 | (37.7414593371741, -122.403434865134) | ||||
| 36508 | 36508 | 31629 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2667 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | 12 | Permit Number 35146 | 5981804.4287 | 2096935.1986 | 37.736730050914296 | -122.505415418144 | (37.7367300509143, -122.505415418144) | |
| 36763 | 36763 | 194034 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 18 | : Yard 23 | Tree 1 | Private 1 | 25 | 6017329.2954 | 2102592.85695 | 37.754291333594395 | -122.382982871671 | (37.7542913335944, -122.382982871671) | ||||
| 37741 | 37741 | 177836 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650 Peru Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005089.4768199995 | 2092569.03703 | 37.7260842891429 | -122.424598299682 | (37.7260842891429, -122.424598299682) | ||||
| 38627 | 38627 | 210531 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 47 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992169.14182 | 2088256.46113 | 37.7135048592377 | -122.46894902289 | (37.7135048592377, -122.46894902289) | ||||
| 39656 | 39656 | 232338 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 691 29th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6002085.619519999 | 2098828.73569 | 37.743101879661396 | -122.43543002579399 | (37.7431018796614, -122.435430025794) | ||||
| 40576 | 40576 | 177849 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 104 Woolsey St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6011561.92381 | 2092191.20992 | 37.7254102643617 | -122.40219675676799 | (37.7254102643617, -122.402196756768) | ||||
| 42963 | 42963 | 113115 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 42986 | 42986 | 113272 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 505 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000604.42582894 | 2110679.50515746 | 37.7755569556145 | -122.44140175558 | (37.7755569556145, -122.44140175558) | |||||
| 43398 | 43398 | 194079 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 495 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6011076.69396 | 2097479.74807 | 37.7399043805938 | -122.404246211905 | (37.7399043805938, -122.404246211905) | ||||
| 44191 | 44191 | 194043 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1700 22nd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6012940.14961 | 2103802.44192 | 37.7573690942271 | -122.398246606115 | (37.7573690942271, -122.398246606115) | ||||
| 46568 | 46568 | 232340 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 691 29th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6002112.62766 | 2098832.12217 | 37.7431127119846 | -122.435336881217 | (37.7431127119846, -122.435336881217) | ||||
| 48536 | 48536 | 54077 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1416 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1972 12:00:00 AM | 12 | Permit Number 9800 | 5982488.8605 | 2105444.4291 | 37.7601342805878 | -122.503679056793 | (37.7601342805878, -122.503679056793) | ||
| 48592 | 48592 | 63207 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3633 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 14 | Permit Number 23749 | 5984209.30853 | 2113126.2552799997 | 37.7813273844972 | -122.498296310267 | (37.7813273844972, -122.498296310267) | |
| 49273 | 49273 | 194089 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Apparel Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6011234.191000001 | 2097831.41118 | 37.740878771736 | -122.403726387581 | (37.740878771736, -122.403726387581) | ||||
| 51833 | 51833 | 44251 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1735 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Permit Number 43686 | 6000810.1983 | 2111352.5828 | 37.7774167767615 | -122.440738231786 | (37.7774167767615, -122.440738231786) | |||
| 52499 | 52499 | 248193 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 216 Esmeralda Ave | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6007342.31013 | 2098763.52222 | 37.74321996062879 | -122.417249134357 | (37.7432199606288, -122.417249134357) | ||||
| 52509 | 52509 | 177834 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6005075.62014 | 2092583.76802 | 37.7261239546294 | -122.424647248878 | (37.7261239546294, -122.424647248878) | ||||
| 52722 | 52722 | 58056 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1957 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1977 12:00:00 AM | 5 | Permit Number 17025 | 6002479.0246 | 2119847.84274 | 37.8008374809215 | -122.435573122311 | (37.8008374809215, -122.435573122311) | ||
| 53078 | 53078 | 43995 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 141 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | 6 | Permit Number 43551 | 6009986.76566 | 2107516.11876 | 37.767401055952604 | -122.408722606278 | (37.7674010559526, -122.408722606278) | ||
| 53426 | 53426 | 232343 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 685 29th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6002200.5465400005 | 2098838.1570900003 | 37.7431342750257 | -122.43503331323099 | (37.7431342750257, -122.435033313231) | ||||
| 54080 | 54080 | 194100 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 84 Whitney Young Cir | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6016729.78084 | 2095080.8399099999 | 37.7336317244204 | -122.384532957547 | (37.7336317244204, -122.384532957547) | ||||
| 54380 | 54380 | 194099 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 84 Whitney Young Cir | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | 6016735.93504 | 2095074.45923 | 37.733614544669706 | -122.384511236201 | (37.7336145446697, -122.384511236201) | ||||
| 55465 | 55465 | 75612 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 618X Missouri St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013522.58771 | 2104188.6871599997 | 37.7584620654811 | -122.396259360694 | (37.7584620654811, -122.396259360694) | ||
| 55881 | 55881 | 194081 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 495 Barneveld Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6011081.84717 | 2097512.6776799997 | 37.739995086212204 | -122.404230711204 | (37.7399950862122, -122.404230711204) | ||||
| 56892 | 56892 | 248221 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6007127.43713 | 2099336.46972 | 37.744781055094705 | -122.418032719051 | (37.7447810550947, -122.418032719051) | ||||
| 57213 | 57213 | 194086 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 455 Barneveld Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6011140.069490001 | 2097730.23514 | 37.7405957056291 | -122.40404470801901 | (37.7405957056291, -122.404044708019) | ||||
| 57301 | 57301 | 83542 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 875 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 19 | 5980747.696719999 | 2109761.67142 | 37.7718856460039 | -122.51002154176399 | (37.7718856460039, -122.510021541764) | |||
| 58582 | 58582 | 194070 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 41 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | 6011513.73296 | 2097374.29319 | 37.7396392352499 | -122.40272769043501 | (37.7396392352499, -122.402727690435) | ||||
| 59204 | 59204 | 194061 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 570 Barneveld Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6010992.7511 | 2097246.2982 | 37.7392586862341 | -122.404520023974 | (37.7392586862341, -122.404520023974) | ||||
| 60123 | 60123 | 54383 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 651 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1972 12:00:00 AM | 15 | Permit Number 10149 | 5981319.187940001 | 2111228.52141 | 37.7759468761842 | -122.508153639765 | (37.7759468761842, -122.508153639765) | ||
| 60266 | 60266 | 177814 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 520 Carter St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6005234.109619999 | 2086313.99971 | 37.70891747232 | -122.423653779491 | (37.70891747232, -122.423653779491) | ||||
| 60467 | 60467 | 247863 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Bradford St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6009595.21098 | 2098157.48801 | 37.7416824131186 | -122.409416401771 | (37.7416824131186, -122.409416401771) | ||||
| 61219 | 61219 | 194047 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2 Turner Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6013813.323419999 | 2103501.8132700003 | 37.7565922319503 | -122.39520574557301 | (37.7565922319503, -122.395205745573) | ||||
| 61551 | 61551 | 194088 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 425 Barneveld Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6011172.247769999 | 2097813.5052 | 37.7408261452168 | -122.40393930564801 | (37.7408261452168, -122.403939305648) | ||||
| 61688 | 61688 | 57206 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2202 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1975 12:00:00 AM | Permit Number 774014 | 6000908.32678769 | 2115906.78943665 | 37.7899270475037 | -122.44072552972 | (37.7899270475037, -122.44072552972) | |||
| 62149 | 62149 | 232294 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200 Eugenia Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6006564.33926 | 2098135.6208099998 | 37.7414520850542 | -122.41989461157301 | (37.7414520850542, -122.419894611573) | ||||
| 62308 | 62308 | 194101 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 84 Whitney Young Cir | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6016735.28252 | 2095083.6486799999 | 37.733639740984394 | -122.384514132028 | (37.7336397409844, -122.384514132028) | ||||
| 63737 | 63737 | 232410 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 395 Addison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6001971.32528 | 2097704.62819 | 37.7400088512382 | -122.43574481549601 | (37.7400088512382, -122.435744815496) | ||||
| 64017 | 64017 | 232346 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 685 29th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6002224.42255 | 2098838.39473 | 37.7431362832177 | -122.434950773465 | (37.7431362832177, -122.434950773465) | ||||
| 64199 | 64199 | 194087 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 425 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6011153.61145 | 2097764.18431 | 37.7406896793961 | -122.40400027339899 | (37.7406896793961, -122.404000273399) | ||||
| 64729 | 64729 | 194038 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900x Carolina St | 53 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6012502.8583 | 2102970.8089 | 37.7550612440971 | -122.39970055084 | (37.7550612440971, -122.39970055084) | ||||
| 65099 | 65099 | 62101 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4224 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1985 12:00:00 AM | 4 | Permit Number 22194 | 5981140.9456 | 2104205.2821 | 37.756652594222004 | -122.508248791959 | (37.756652594222, -122.508248791959) | ||
| 65111 | 65111 | 248192 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 216 Esmeralda Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6007348.90224 | 2098760.26711 | 37.7432113936915 | -122.41722610990101 | (37.7432113936915, -122.417226109901) | ||||
| 65577 | 65577 | 194073 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2275 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | 6011416.20922 | 2097909.60407 | 37.741103639116 | -122.403102531469 | (37.741103639116, -122.403102531469) | ||||
| 65623 | 65623 | 177843 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 51 | 6005078.05129 | 2092608.48476 | 37.726191958666796 | -122.424640601997 | (37.7261919586668, -122.424640601997) | ||||
| 66758 | 66758 | 54071 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1650 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 17 | Permit Number 9794 | 5981301.6578 | 2103844.8448 | 37.7556724054432 | -122.50766625573 | (37.7556724054432, -122.50766625573) | ||
| 67490 | 67490 | 51036 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2614 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 3 | Permit Number 47511 | 5981836.5788 | 2097266.1752 | 37.7376407136614 | -122.50532878706001 | (37.7376407136614, -122.50532878706) | ||
| 67557 | 67557 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 690 Miramar Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995444.4 | 2093941.6 | 37.729303587844704 | -122.45803982404199 | (37.7293035878447, -122.458039824042) | |||||
| 68767 | 68767 | 194085 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 455 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6011132.21966 | 2097711.64553 | 37.7405442239471 | -122.404070541922 | (37.7405442239471, -122.404070541922) | ||||
| 69757 | 69757 | 247862 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Bradford St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6009589.386530001 | 2098133.6831900002 | 37.7416167239206 | -122.40943486124701 | (37.7416167239206, -122.409434861247) | ||||
| 70150 | 70150 | 248180 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 218 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007468.18996 | 2098662.76578 | 37.7429503870626 | -122.416806737143 | (37.7429503870626, -122.416806737143) | ||||
| 70190 | 70190 | 232359 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 460 Beacon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6002296.736959999 | 2098462.96978 | 37.7421095596165 | -122.43467389018998 | (37.7421095596165, -122.43467389019) | ||||
| 70448 | 70448 | 232414 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 297 Addison St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6002492.620630001 | 2097686.70985 | 37.739989248705605 | -122.433941112706 | (37.7399892487056, -122.433941112706) | ||||
| 71595 | 71595 | 57562 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1717 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1976 12:00:00 AM | 20 | Permit Number 16429 | 6000855.1553 | 2111361.653 | 37.777444241367 | -122.440583361864 | (37.777444241367, -122.440583361864) | ||
| 73078 | 73078 | 247860 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Bradford St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6009586.93034 | 2098129.5986 | 37.7416053709039 | -122.40944306575899 | (37.7416053709039, -122.409443065759) | ||||
| 74023 | 74023 | 76347 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 15 | 6013052.749419999 | 2119171.30409 | 37.7995747464454 | -122.398935843819 | (37.7995747464454, -122.398935843819) | ||
| 74676 | 74676 | 34232 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 378 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2005 12:00:00 AM | 6 | Permit Number 48201 | 5986869.968169999 | 2113396.40571 | 37.7822247950158 | -122.48911172009899 | (37.7822247950158, -122.489111720099) | ||
| 74822 | 74822 | 194102 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1000 Oakdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018083.18788 | 2093260.00153 | 37.7287068084484 | -122.379727324058 | (37.7287068084484, -122.379727324058) | ||||
| 75161 | 75161 | 41044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1444 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2000 12:00:00 AM | Permit Number 41825 | 6007214.22869275 | 2117785.20726397 | 37.795441807697294 | -122.41904090928001 | (37.7954418076973, -122.41904090928) | ||
| 75804 | 75804 | 106277 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 535 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5985625.27149 | 2112239.89732 | 37.7789766267584 | -122.493332520045 | (37.7789766267584, -122.493332520045) | ||||
| 75879 | 75879 | 35907 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2295 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 14 | Permit Number 39091 | 6011293.56173 | 2098002.1271 | 37.7413508375758 | -122.403533112479 | (37.7413508375758, -122.403533112479) | |
| 76036 | 76036 | 37096 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1467 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 7 | Permit Number 39696 | 5981524.9714 | 2105106.2752 | 37.759149087294794 | -122.506987547698 | (37.7591490872948, -122.506987547698) | |
| 77606 | 77606 | 106897 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2768 GREAT HWY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981642.5 | 2096616.3 | 37.735844912626 | -122.505951630112 | (37.735844912626, -122.505951630112) | |||||
| 77652 | 77652 | 31202 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 276 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1969 12:00:00 AM | Permit Number 34894 | 5995678.83964111 | 2091843.96330625 | 37.7235574477937 | -122.45707767911101 | (37.7235574477937, -122.457077679111) | |||
| 77956 | 77956 | 45719 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 227 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | Permit Number 44389 | 5993425.80357844 | 2089157.89359185 | 37.7160525030782 | -122.464671006022 | (37.7160525030782, -122.464671006022) | |||
| 78090 | 78090 | 113273 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 505 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000604.42582894 | 2110679.50515746 | 37.7755569556145 | -122.44140175558 | (37.7755569556145, -122.44140175558) | |||||
| 78233 | 78233 | 40342 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 170 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | Permit Number 41473 | 5993510.486220299 | 2094049.6713278 | 37.7294890191855 | -122.464733328734 | (37.7294890191855, -122.464733328734) | |||
| 78519 | 78519 | 94912 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1506 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999677.4 | 2107342.3 | 37.7663409791409 | -122.44436866988998 | (37.7663409791409, -122.44436866989) | |||||
| 78648 | 78648 | 112011 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 78722 | 78722 | 97496 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 677 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995323.3 | 2110955.5 | 37.7760124935324 | -122.459690319245 | (37.7760124935324, -122.459690319245) | |||||
| 79648 | 79648 | 94502 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 60 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 53693 | 5994613.0 | 2095460.0 | 37.733424938715 | -122.461024038199 | (37.733424938715, -122.461024038199) | ||||
| 80283 | 80283 | 112014 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 80679 | 80679 | 94196 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 355 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) |
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");