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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 126064 | 126064 | 9313 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 99X Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
| 18727 | 18727 | 3939 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 999X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002271.23678 | 2107631.4399099997 | 37.7672825369934 | -122.43541777162201 | (37.7672825369934, -122.435417771622) | |||
| 98813 | 98813 | 106448 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 999 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002658.0 | 2110219.0 | 37.7744092970816 | -122.43426502395701 | (37.7744092970816, -122.434265023957) | |||||
| 85450 | 85450 | 121597 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 998X Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000144.0 | 2102038.0 | 37.7518032865281 | -122.44237395255101 | (37.7518032865281, -122.442373952551) | ||||
| 106252 | 106252 | 121596 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 998X Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000144.0 | 2102038.0 | 37.7518032865281 | -122.44237395255101 | (37.7518032865281, -122.442373952551) | ||||
| 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) | ||||
| 173399 | 173399 | 232313 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 99 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6007317.39057 | 2098776.5375599996 | 37.743254295847 | -122.417336222008 | (37.743254295847, -122.417336222008) | ||||
| 85590 | 85590 | 105133 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 98X WINFIELD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6007331.0 | 2099216.0 | 37.7444617271859 | -122.417320300114 | (37.7444617271859, -122.417320300114) | |||
| 114350 | 114350 | 105134 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 98X WINFIELD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | Neighbor said they are not going to replant trees because ther eis no one to take care of them | 6007331.0 | 2099216.0 | 37.7444617271859 | -122.417320300114 | (37.7444617271859, -122.417320300114) | ||
| 36179 | 36179 | 232334 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 986 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 6000140.77216 | 2101983.38554 | 37.7516531444772 | -122.442381194354 | (37.7516531444772, -122.442381194354) | |||
| 39763 | 39763 | 232335 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 986 Elizabeth St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 6000130.35257 | 2101984.21301 | 37.751654822617795 | -122.442417285937 | (37.7516548226178, -122.442417285937) | |||
| 88241 | 88241 | 103519 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 97 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6007313.0 | 2098782.0 | 37.7432690474632 | -122.41735179051201 | (37.7432690474632, -122.417351790512) | |||
| 93493 | 93493 | 121630 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 96x Valmar Ter | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 12 | 3x3 | 6005224.0 | 2092573.0 | 37.726102766942205 | -122.42413354236 | (37.7261027669422, -122.42413354236) | |||
| 180343 | 180343 | 177809 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 968 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6002194.0253 | 2088207.5246700002 | 37.7139446016244 | -122.434296011252 | (37.7139446016244, -122.434296011252) | |||
| 155213 | 155213 | 246238 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 96 Delmar St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5999340.3322 | 2107840.1629 | 37.7676887482161 | -122.44557032465299 | (37.7676887482161, -122.445570324653) | |||
| 88268 | 88268 | 16577 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 88353 | 88353 | 16576 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 92712 | 92712 | 16571 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 94849 | 94849 | 16581 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 105214 | 105214 | 16574 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 109368 | 109368 | 16575 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 110532 | 110532 | 16573 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 122129 | 122129 | 16579 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 124560 | 124560 | 16578 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 124877 | 124877 | 16572 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 95978 | 95978 | 38435 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 950 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | Permit Number 40462 | 6003103.32448359 | 2102701.71275072 | 37.7537939125694 | -122.43218760661101 | (37.7537939125694, -122.432187606611) | |||
| 27901 | 27901 | 131768 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 940 Green St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6008521.12765 | 2119017.9011 | 37.7988999869032 | -122.41460607901699 | (37.7988999869032, -122.414606079017) | |||
| 138517 | 138517 | 105828 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 936 ELIZABETH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6000414.4 | 2102014.7 | 37.7517547185995 | -122.44143720329599 | (37.7517547185995, -122.441437203296) | ||||
| 88866 | 88866 | 102110 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 925 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x6 | Permit Number 769970 | 6000481.0 | 2101964.0 | 37.751619302581794 | -122.441203254922 | (37.7516193025818, -122.441203254922) | ||
| 11464 | 11464 | 97310 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 916 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5990323.69 | 2099081.1313 | 37.7431198777207 | -122.476117623457 | (37.7431198777207, -122.476117623457) | |||
| 46502 | 46502 | 232402 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 910 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002441.61747 | 2102925.57164 | 37.7543710360128 | -122.434491942973 | (37.7543710360128, -122.434491942973) | |||
| 130862 | 130862 | 232333 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 91 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6001510.18509 | 2099080.39648 | 37.743760183383 | -122.437437737066 | (37.743760183383, -122.437437737066) | |||
| 9884 | 9884 | 173718 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 906 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 3x3 | 6012418.0 | 2103694.0 | 37.757042237838796 | -122.400044801952 | (37.7570422378388, -122.400044801952) | |||
| 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) | ||||
| 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) | ||||
| 17169 | 17169 | 29607 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991176.48666 | 2091034.59302 | 37.7210755258009 | -122.472582381082 | (37.7210755258009, -122.472582381082) | ||
| 18962 | 18962 | 29617 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991168.23882 | 2090896.94142 | 37.7206970910675 | -122.472600860348 | (37.7206970910675, -122.472600860348) | ||
| 20519 | 20519 | 29614 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991166.98096 | 2090921.81223 | 37.720765307364395 | -122.47260702069599 | (37.7207653073644, -122.472607020696) | ||
| 19078 | 19078 | 16995 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 900 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6002566.6368 | 2109915.0941 | 37.7735696608208 | -122.43455933158998 | (37.7735696608208, -122.43455933159) | ||
| 14667 | 14667 | 3750 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012463.2126 | 2103693.82662 | 37.7570442824941 | -122.39988842642401 | (37.7570442824941, -122.399888426424) | |||
| 189138 | 189138 | 232332 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 90 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6001483.73316 | 2099106.7788299997 | 37.7438311192153 | -122.437531090286 | (37.7438311192153, -122.437531090286) | |||
| 85079 | 85079 | 110426 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 90 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011326.0 | 2097433.0 | 37.7397899480097 | -122.403380922944 | (37.7397899480097, -122.403380922944) | ||||
| 61774 | 61774 | 122847 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 8X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 5998894.0 | 2112969.0 | 37.7817457290664 | -122.447483343193 | (37.7817457290664, -122.447483343193) | |||
| 86054 | 86054 | 114065 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 898x ELIZABETH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000938.0 | 2102006.0 | 37.751760645744206 | -122.439625904919 | (37.7517606457442, -122.439625904919) | ||||
| 94344 | 94344 | 114062 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 898x ELIZABETH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | 3x3 | Permit Number 777118 | 6000938.0 | 2102006.0 | 37.751760645744206 | -122.439625904919 | (37.7517606457442, -122.439625904919) | ||
| 138802 | 138802 | 114064 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 898x ELIZABETH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 777118 | 6000938.0 | 2102006.0 | 37.751760645744206 | -122.439625904919 | (37.7517606457442, -122.439625904919) | |||
| 139818 | 139818 | 114063 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 898x ELIZABETH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | 3x3 | Permit Number 777118 | 6000938.0 | 2102006.0 | 37.751760645744206 | -122.439625904919 | (37.7517606457442, -122.439625904919) | ||
| 48697 | 48697 | 177826 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 89 Belle Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 5991639.3875 | 2086487.5926299999 | 37.708617351468895 | -122.47065126593999 | (37.7086173514689, -122.47065126594) | |||
| 55588 | 55588 | 248233 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 88 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006896.47114 | 2099079.32304 | 37.744061985971996 | -122.41881312374599 | (37.744061985972, -122.418813123746) | |||
| 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) | |||
| 63478 | 63478 | 118928 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 875 La Playa | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5980750.0793699995 | 2109680.6397599997 | 37.7716632974006 | -122.51000727921999 | (37.7716632974006, -122.51000727922) | |||
| 43960 | 43960 | 232361 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 869 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 4ft | 6000744.54456 | 2101976.60754 | 37.751668928482204 | -122.440292790492 | (37.7516689284822, -122.440292790492) | |||
| 1465 | 1465 | 210473 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 855 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2016 12:00:00 AM | 14 | Width 3ft | Permit Number 41828 | 5993066.85825 | 2107284.5743400003 | 37.765803096458995 | -122.46722890580901 | (37.765803096459, -122.467228905809) | |
| 9873 | 9873 | 118917 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 855 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 4x4 | 5980738.79777 | 2109987.23765 | 37.772504459681 | -122.510069084185 | (37.772504459681, -122.510069084185) | ||
| 77096 | 77096 | 118919 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 855 La Playa | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5980739.30228 | 2109925.40839 | 37.772334724474504 | -122.510062744769 | (37.7723347244745, -122.510062744769) | |||
| 147649 | 147649 | 118920 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 855 La Playa | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5980740.60981 | 2109900.97244 | 37.772267707662294 | -122.510056406253 | (37.7722677076623, -122.510056406253) | |||
| 185679 | 185679 | 118921 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 855 La Playa | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5980742.3657 | 2109876.07038 | 37.77219943749321 | -122.510048482225 | (37.7721994374932, -122.510048482225) | |||
| 125247 | 125247 | 41048 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 855 LINCOLN WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 41828 | 5993076.0 | 2107259.0 | 37.7657334037891 | -122.46719542706002 | (37.7657334037891, -122.46719542706) | |
| 31050 | 31050 | 119202 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5981058.93539 | 2109762.95865 | 37.7719075327332 | -122.508945060001 | (37.7719075327332, -122.508945060001) | |||
| 50372 | 50372 | 119204 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 5981054.81855 | 2109824.51434 | 37.772076303922205 | -122.50896387162399 | (37.7720763039222, -122.508963871624) | |||
| 158957 | 158957 | 119203 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5981056.2955 | 2109791.98887 | 37.7719870855851 | -122.508956347328 | (37.7719870855851, -122.508956347328) | |||
| 166903 | 166903 | 119200 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5981060.97068 | 2109705.7798200003 | 37.7717506564051 | -122.508933773591 | (37.7717506564051, -122.508933773591) | |||
| 175562 | 175562 | 119205 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5981054.80305 | 2109899.79176 | 37.772282992725394 | -122.508969515743 | (37.7722829927254, -122.508969515743) | |||
| 180494 | 180494 | 119201 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5981058.88623 | 2109735.33972 | 37.771831696349395 | -122.508943178948 | (37.7718316963494, -122.508943178948) | |||
| 189107 | 189107 | 119207 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5981051.50114 | 2110011.96585 | 37.7725907952116 | -122.50898926789499 | (37.7725907952116, -122.508989267895) | |||
| 22884 | 22884 | 119188 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5980787.759319999 | 2110046.86087 | 37.7726710552755 | -122.509904154395 | (37.7726710552755, -122.509904154395) | |||
| 33856 | 33856 | 119195 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5980799.52647 | 2109772.2275400003 | 37.771917686863205 | -122.50984304652201 | (37.7719176868632, -122.509843046522) | |||
| 41141 | 41141 | 119198 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5980803.32606 | 2109672.6528 | 37.771644507950896 | -122.50982250562599 | (37.7716445079509, -122.509822505626) | |||
| 47780 | 47780 | 119186 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5980784.52951 | 2110103.8461599997 | 37.7728273296306 | -122.509919560521 | (37.7728273296306, -122.509919560521) | |||
| 130398 | 130398 | 119192 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5980793.72014 | 2109909.69069 | 37.7722947778463 | -122.509873343995 | (37.7722947778463, -122.509873343995) | |||
| 131773 | 131773 | 119165 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5980803.057 | 2109634.63853 | 37.7715401160565 | -122.50982061198098 | (37.7715401160565, -122.509820611981) | |||
| 136004 | 136004 | 119197 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5980800.71853 | 2109703.31069 | 37.771728531734794 | -122.50983380285 | (37.7717285317348, -122.50983380285) | |||
| 146979 | 146979 | 119187 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5980787.15849 | 2110067.27485 | 37.7727270706244 | -122.50990774946501 | (37.7727270706244, -122.509907749465) | |||
| 158125 | 158125 | 119193 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5980794.10985 | 2109865.62761 | 37.7721738165622 | -122.509868722143 | (37.7721738165622, -122.509868722143) | |||
| 171674 | 171674 | 119191 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5980791.6714 | 2109938.71016 | 37.772374335952 | -122.50988258676901 | (37.772374335952, -122.509882586769) | |||
| 179305 | 179305 | 119189 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5980788.77167 | 2110011.06332 | 37.7725728254374 | -122.509897992863 | (37.7725728254374, -122.509897992863) | |||
| 188136 | 188136 | 119190 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5980791.5999300005 | 2109976.85312 | 37.7724790610914 | -122.50988566798999 | (37.7724790610914, -122.50988566799) | |||
| 134695 | 134695 | 210571 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 843 Detroit St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5999424.06656 | 2095555.48059 | 37.7339627810479 | -122.444397744158 | (37.7339627810479, -122.444397744158) | |||
| 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) | ||||
| 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) | ||||
| 166359 | 166359 | 114419 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 833 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5982597.66575 | 2110078.84881 | 37.7728654631954 | -122.503645967306 | (37.7728654631954, -122.503645967306) | |||
| 154737 | 154737 | 79125 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825-875 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 4x4 | 5980734.99741 | 2110066.24575 | 37.772721168522295 | -122.51008810063601 | (37.7727211685223, -122.510088100636) | ||
| 46941 | 46941 | 210475 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993130.45149 | 2107287.22386 | 37.7658140421158 | -122.467009144778 | (37.7658140421158, -122.467009144778) | |||
| 53606 | 53606 | 121385 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993159.0 | 2107262.0 | 37.7657464318194 | -122.466908568463 | (37.7657464318194, -122.466908568463) | ||||
| 65457 | 65457 | 210474 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993111.96397 | 2107286.56406 | 37.7658111633716 | -122.467073040683 | (37.7658111633716, -122.467073040683) | |||
| 88572 | 88572 | 121382 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993159.0 | 2107262.0 | 37.7657464318194 | -122.466908568463 | (37.7657464318194, -122.466908568463) | ||||
| 101670 | 101670 | 121384 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993159.0 | 2107262.0 | 37.7657464318194 | -122.466908568463 | (37.7657464318194, -122.466908568463) | ||||
| 108732 | 108732 | 121383 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993159.0 | 2107262.0 | 37.7657464318194 | -122.466908568463 | (37.7657464318194, -122.466908568463) | ||||
| 119922 | 119922 | 121381 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993159.0 | 2107262.0 | 37.7657464318194 | -122.466908568463 | (37.7657464318194, -122.466908568463) | ||||
| 132069 | 132069 | 210476 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993141.82692 | 2107286.84618 | 37.7658136616838 | -122.466969772444 | (37.7658136616838, -122.466969772444) | |||
| 156666 | 156666 | 210477 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993154.16087 | 2107287.0428400002 | 37.7658149135476 | -122.466927126579 | (37.7658149135476, -122.466927126579) | |||
| 172052 | 172052 | 210478 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 Lincoln Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5993192.68516 | 2107284.86594 | 37.7658111597894 | -122.466793722066 | (37.7658111597894, -122.466793722066) | |||
| 54534 | 54534 | 118916 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 La Playa | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | 5980736.9232 | 2110038.6027900004 | 37.772645382677105 | -122.510079385172 | (37.7726453826771, -122.510079385172) | |||
| 87073 | 87073 | 118915 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5980733.09837 | 2110116.47079 | 37.772858959689 | -122.510098401613 | (37.772858959689, -122.510098401613) | ||||
| 135063 | 135063 | 124622 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 824 Euclid Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 4ft | 5995745.69973 | 2113830.9736599997 | 37.783932061345 | -122.45843732536501 | (37.783932061345, -122.458437325365) | |||
| 80171 | 80171 | 114418 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 824 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777680 | 5982642.49578 | 2110126.6105299997 | 37.7729992386667 | -122.503494435004 | (37.7729992386667, -122.503494435004) | |
| 76048 | 76048 | 210570 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 820 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999463.89453 | 2095632.6105400003 | 37.7341768340999 | -122.444265587914 | (37.7341768340999, -122.444265587914) | |||
| 48961 | 48961 | 114417 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 818 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | 17 | 3x3 | Permit Number 777178 | 5982641.81741 | 2110164.71774 | 37.7731038301224 | -122.50349960390601 | (37.7731038301224, -122.503499603906) | |
| 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) |
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");