Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 110994 | 110994 | 111670 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99x CARL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998115.0 | 2107097.0 | 37.7655781805803 | -122.44975501544201 | (37.7655781805803, -122.449755015442) | ||||
| 116012 | 116012 | 111669 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99x CARL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998115.0 | 2107097.0 | 37.7655781805803 | -122.44975501544201 | (37.7655781805803, -122.449755015442) | ||||
| 101415 | 101415 | 24476 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99X Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002281.226578901 | 2096676.7830479 | 37.73720422475029 | -122.43459982975 | (37.7372042247503, -122.43459982975) | |||
| 5163 | 5163 | 12318 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 999 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1997 12:00:00 AM | 6 | 4X4 | 6004783.3056 | 2112237.6551 | 37.7800724294036 | -122.427056996678 | (37.7800724294036, -122.427056996678) | ||
| 147315 | 147315 | 222595 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6002381.71285 | 2096266.74074 | 37.736084047029 | -122.434223097845 | (37.736084047029, -122.434223097845) | |||
| 133067 | 133067 | 204658 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5994773.2638 | 2095284.74721 | 37.732952958415105 | -122.46045727068001 | (37.7329529584151, -122.46045727068) | |||
| 7114 | 7114 | 45767 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997811.6954 | 2113198.143 | 37.782312986330794 | -122.45124412099399 | (37.7823129863308, -122.451244120994) |
| 7399 | 7399 | 45765 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Blake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997815.0796 | 2113173.4382 | 37.782245347199996 | -122.451230630986 | (37.7822453472, -122.451230630986) | |
| 54695 | 54695 | 52371 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 970JONES Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48503 | 6008855.4568 | 2115649.67517 | 37.78967044259821 | -122.41321087889901 | (37.7896704425982, -122.413210878899) |
| 160140 | 160140 | 113225 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 970JONES Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | 6008828.65356 | 2115644.6839900003 | 37.7896552332384 | -122.413303262628 | (37.7896552332384, -122.413303262628) | ||
| 11427 | 11427 | 27057 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 945 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/25/1999 12:00:00 AM | 7 | 2X3 | 6007415.89764 | 2093543.05958 | 37.72888985646029 | -122.416624950003 | (37.7288898564603, -122.416624950003) | ||
| 80412 | 80412 | 99239 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 940 Laguna Honda Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768814 | 5996167.3 | 2098870.1 | 37.7428775588654 | -122.45589685275 | (37.7428775588654, -122.45589685275) | ||||
| 187841 | 187841 | 221327 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 936 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010186.18174 | 2103764.32859 | 37.757110656958204 | -122.407768272711 | (37.7571106569582, -122.407768272711) | |||
| 5851 | 5851 | 9507 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 935 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005077.1287 | 2112297.1038 | 37.7802522713917 | -122.42604476220501 | (37.7802522713917, -122.426044762205) | |||
| 157068 | 157068 | 30677 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 920 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 8 | Permit Number 34600 | 6008142.25986 | 2110035.66546 | 37.7742156570679 | -122.415280896104 | (37.7742156570679, -122.415280896104) | |
| 45314 | 45314 | 221329 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 92 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010301.696169999 | 2100286.438 | 37.7475676053645 | -122.407123632349 | (37.7475676053645, -122.407123632349) | |||
| 133403 | 133403 | 175786 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 913 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008114.21781 | 2093492.5462599997 | 37.728790407640794 | -122.41420722787599 | (37.7287904076408, -122.414207227876) | |||
| 135580 | 135580 | 175787 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 913 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008123.2351400005 | 2093495.1719799999 | 37.7287981238093 | -122.414176239965 | (37.7287981238093, -122.414176239965) | |||
| 184588 | 184588 | 175788 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 913 Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008132.91971 | 2093497.9491400002 | 37.7288062932694 | -122.414142956056 | (37.7288062932694, -122.414142956056) | |||
| 91494 | 91494 | 26491 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 912X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1998 12:00:00 AM | 6 | 4X4 | 6004848.1679 | 2112085.98552 | 37.7796596496687 | -122.426821804086 | (37.7796596496687, -122.426821804086) | ||
| 12561 | 12561 | 27049 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 910 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3x3 | 6007348.52678 | 2093482.2197099999 | 37.7287190140661 | -122.41685354777701 | (37.7287190140661, -122.416853547777) | ||
| 135572 | 135572 | 221334 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90x Peralta Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6010340.53234 | 2100283.1811900004 | 37.747560836176 | -122.406989109071 | (37.747560836176, -122.406989109071) | |||
| 104860 | 104860 | 95797 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 907 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767539 | 6008624.3 | 2103231.6 | 37.7555603448561 | -122.413132208673 | (37.7555603448561, -122.413132208673) | |
| 179663 | 179663 | 222506 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 907 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008600.17028 | 2103215.25622 | 37.7555141138929 | -122.413214501368 | (37.7555141138929, -122.413214501368) | |||
| 135324 | 135324 | 139823 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 903 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004856.1173 | 2112030.4835 | 37.7795077042444 | -122.42679034995899 | (37.7795077042444, -122.426790349959) | |||
| 86680 | 86680 | 39663 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.719932478931796 | -122.46264932396299 | (37.7199324789318, -122.462649323963) | ||
| 90504 | 90504 | 39664 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.719932478931796 | -122.46264932396299 | (37.7199324789318, -122.462649323963) | ||
| 13750 | 13750 | 96932 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011002.04218 | 2094782.5630700001 | 37.732494311353506 | -122.404314536086 | (37.7324943113535, -122.404314536086) | |||
| 13770 | 13770 | 96936 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010967.89306 | 2094873.35668 | 37.732741703157394 | -122.404438986978 | (37.7327417031574, -122.404438986978) | |||
| 14841 | 14841 | 96934 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010990.76512 | 2094811.6628299998 | 37.7325735829947 | -122.404355571269 | (37.7325735829947, -122.404355571269) | |||
| 15147 | 15147 | 96937 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010960.45235 | 2094890.17175 | 37.732787457976706 | -122.40446589470699 | (37.7327874579767, -122.404465894707) | |||
| 16389 | 16389 | 96935 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010973.7505 | 2094855.21788 | 37.7326922251695 | -122.404417459925 | (37.7326922251695, -122.404417459925) | |||
| 16570 | 16570 | 96933 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010997.56747 | 2094792.1485099997 | 37.7325203809043 | -122.40433068074101 | (37.7325203809043, -122.404330680741) | |||
| 93238 | 93238 | 96931 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010934.9 | 2094931.8 | 37.7329003323541 | -122.404557165415 | (37.7329003323541, -122.404557165415) | |||
| 165867 | 165867 | 188339 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011007.54195 | 2094765.98142 | 37.7324490889606 | -122.40429435530301 | (37.7324490889606, -122.404294355303) | |||
| 144749 | 144749 | 16346 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 900X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996119.1686597 | 2094698.5315602 | 37.7314206866198 | -122.45576179592301 | (37.7314206866198, -122.455761795923) | ||
| 28539 | 28539 | 188302 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008239.71976 | 2109507.11568 | 37.7727698610843 | -122.414906347362 | (37.7727698610843, -122.414906347362) | |||
| 34236 | 34236 | 188300 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008269.7706 | 2109537.20803 | 37.7728541761188 | -122.41480452791001 | (37.7728541761188, -122.41480452791) | |||
| 62206 | 62206 | 188301 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008261.50029 | 2109526.90873 | 37.772825431974894 | -122.41483240691002 | (37.7728254319749, -122.41483240691) | |||
| 164795 | 164795 | 188303 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6008234.3659 | 2109502.33979 | 37.772756446777294 | -122.414924528938 | (37.7727564467773, -122.414924528938) | |||
| 60387 | 60387 | 35218 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 896 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1998 12:00:00 AM | 5 | Permit Number 40401 | 6011658.1335 | 2112244.4696 | 37.780477493902204 | -122.403274202035 | (37.7804774939022, -122.403274202035) | ||
| 169372 | 169372 | 35219 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 896 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1998 12:00:00 AM | 7 | Permit Number 38722 | 6011641.6488 | 2112229.3585 | 37.7804350816614 | -122.403330167353 | (37.7804350816614, -122.403330167353) | ||
| 99616 | 99616 | 26698 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 89 Dukes Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6016127.069051901 | 2096424.3370057999 | 37.73728734855921 | -122.386710382374 | (37.7372873485592, -122.386710382374) | |||
| 177655 | 177655 | 175760 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 885 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011559.50494 | 2090784.62511 | 37.72154793606661 | -122.402106275984 | (37.7215479360666, -122.402106275984) | |||
| 117199 | 117199 | 51289 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 875 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | Permit Number 47661 | 5995029.72941729 | 2089837.87433116 | 37.718011907210204 | -122.45917632673999 | (37.7180119072102, -122.45917632674) | |||
| 126232 | 126232 | 45238 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 871 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2001 12:00:00 AM | Permit Number 44088 | 6008421.36689101 | 2115188.65226849 | 37.7883802062735 | -122.414680152021 | (37.7883802062735, -122.414680152021) | |||
| 21100 | 21100 | 4336 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 870 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001641.12667 | 2095893.9772400002 | 37.7350184628259 | -122.436756924204 | (37.7350184628259, -122.436756924204) | |||
| 115008 | 115008 | 12297 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 861 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2004 12:00:00 AM | 3 | 4X4 | 6004837.02716 | 2111802.36626 | 37.778880271067294 | -122.426840140564 | (37.7788802710673, -122.426840140564) | ||
| 179630 | 179630 | 141961 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 861 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004842.0409 | 2111803.9569 | 37.7788849220533 | -122.426822909349 | (37.7788849220533, -122.426822909349) | |||
| 180711 | 180711 | 188316 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 850 Carolina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6012420.02519 | 2103984.29593 | 37.7578394396596 | -122.40005818423799 | (37.7578394396596, -122.400058184238) | |||
| 185574 | 185574 | 188315 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 850 Carolina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6012418.401980001 | 2104012.51765 | 37.757916839799705 | -122.400065779927 | (37.7579168397997, -122.400065779927) | |||
| 51006 | 51006 | 221351 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 Sycamore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006363.61838 | 2105832.54053 | 37.7625747506491 | -122.421135037456 | (37.7625747506491, -122.421135037456) | |||
| 145034 | 145034 | 47724 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 Sycamore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2015 12:00:00 AM | 3 | Permit Number 774851 | 6006351.18478147 | 2105818.87737664 | 37.7625365339004 | -122.421177070604 | (37.7625365339004, -122.421177070604) | ||
| 89747 | 89747 | 39705 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 El Verano Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | ||
| 95766 | 95766 | 39704 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 El Verano Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | ||
| 143953 | 143953 | 32519 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 845 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37021 | 6007591.14794748 | 2095436.54835454 | 37.734098820334 | -122.41615314248001 | (37.734098820334, -122.41615314248) | ||
| 122560 | 122560 | 12293 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 841X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2002 12:00:00 AM | 3 | 4X4 | 6004846.05575 | 2111737.27176 | 37.7787020480516 | -122.42680427007099 | (37.7787020480516, -122.426804270071) | ||
| 30793 | 30793 | 141963 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 841 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004850.8791 | 2111736.5633 | 37.7787003755045 | -122.42678753375401 | (37.7787003755045, -122.426787533754) | |||
| 97932 | 97932 | 175756 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 837 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6000844.62416 | 2089035.80235 | 37.7161421822999 | -122.439019362161 | (37.7161421822999, -122.439019362161) | |||
| 159939 | 159939 | 188347 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 83 Scotia Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011997.83069 | 2095044.25145 | 37.7332684477844 | -122.400890216316 | (37.7332684477844, -122.400890216316) | |||
| 45681 | 45681 | 49816 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46737 | 6012410.64537 | 2104168.1082 | 37.758343624767605 | -122.400103532548 | (37.7583436247676, -122.400103532548) |
| 55954 | 55954 | 49814 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46606 | 6012411.85736 | 2104145.59448 | 37.758281874620295 | -122.400097759826 | (37.7582818746203, -122.400097759826) | |
| 72565 | 72565 | 116874 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6012413.67241 | 2104134.33813 | 37.7582510683591 | -122.400090692038 | (37.7582510683591, -122.400090692038) | |||
| 74849 | 74849 | 49815 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2003 12:00:00 AM | 11 | 3x3 | Permit Number 46737 | 6012411.853019999 | 2104156.1373900003 | 37.7583108228906 | -122.40009851524599 | (37.7583108228906, -122.400098515246) | |
| 149081 | 149081 | 116875 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6012413.40755 | 2104121.29509 | 37.7582152402716 | -122.400090692059 | (37.7582152402716, -122.400090692059) | |||
| 156145 | 156145 | 116876 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6012412.723680001 | 2104109.13047 | 37.7581818007698 | -122.400092202897 | (37.7581818007698, -122.400092202897) | |||
| 102550 | 102550 | 22595 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1992 12:00:00 AM | 6 | 4x4 | 6006111.721580001 | 2112834.13473 | 37.7817852453704 | -122.42250379427601 | (37.7817852453704, -122.422503794276) | ||
| 175431 | 175431 | 204612 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5992412.91605 | 2102688.13741 | 37.7531447159591 | -122.469156169131 | (37.7531447159591, -122.469156169131) | |||
| 19179 | 19179 | 96019 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769.0 | 2115301.0 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | |
| 91224 | 91224 | 96020 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769.0 | 2115301.0 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | |
| 125086 | 125086 | 96018 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769.0 | 2115301.0 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | |
| 131619 | 131619 | 96016 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767661 | 6008769.14714 | 2115306.341 | 37.788722884506996 | -122.41348521078999 | (37.788722884507, -122.41348521079) |
| 135943 | 135943 | 96017 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767661 | 6008768.28006 | 2115323.27409 | 37.7887693299764 | -122.413489408823 | (37.7887693299764, -122.413489408823) |
| 146218 | 146218 | 12283 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 803X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | ||
| 175309 | 175309 | 141965 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 803 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004856.9254 | 2111690.3911 | 37.7785739398403 | -122.426763328248 | (37.7785739398403, -122.426763328248) | |||
| 102034 | 102034 | 19417 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5988998.102828201 | 2096024.0271709 | 37.7346489082814 | -122.48047736602301 | (37.7346489082814, -122.480477366023) | ||
| 30747 | 30747 | 188322 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012715.86863 | 2103660.87857 | 37.75696789675921 | -122.39901232755399 | (37.7569678967592, -122.399012327554) | |||
| 34214 | 34214 | 188320 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012714.93717 | 2103702.00953 | 37.7570807814757 | -122.399018435778 | (37.7570807814757, -122.399018435778) | |||
| 35460 | 35460 | 188321 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012714.29279 | 2103681.1367599997 | 37.757023433506 | -122.399019199302 | (37.757023433506, -122.399019199302) | |||
| 50745 | 50745 | 188325 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6012720.87909 | 2103581.41048 | 37.7567499739592 | -122.39898942183201 | (37.7567499739592, -122.398989421832) | |||
| 53807 | 53807 | 188319 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012713.14067 | 2103722.27252 | 37.7571363191045 | -122.39902607101001 | (37.7571363191045, -122.39902607101) | |||
| 65817 | 65817 | 188323 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012718.59247 | 2103642.7954599997 | 37.7569183962771 | -122.399001638237 | (37.7569183962771, -122.399001638237) | |||
| 179966 | 179966 | 188324 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6012719.06472 | 2103600.79409 | 37.756803096012 | -122.39899705709 | (37.756803096012, -122.39899705709) | |||
| 175592 | 175592 | 125889 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006091.49195 | 2112832.09387 | 37.781778500422 | -122.42257363436501 | (37.781778500422, -122.422573634365) | |||
| 21739 | 21739 | 22825 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 80 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/1993 12:00:00 AM | 25 | 3X3 | 5999298.50958 | 2099073.67343 | 37.7436157369876 | -122.44508467424299 | (37.7436157369876, -122.445084674243) | ||
| 172086 | 172086 | 125890 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 8 Sharp Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007493.35542 | 2119123.01732 | 37.799130814105794 | -122.41816997447799 | (37.7991308141058, -122.418169974478) | |||
| 86882 | 86882 | 27082 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 799X Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.7294700001 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | ||
| 100453 | 100453 | 27079 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 799X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/1999 12:00:00 AM | 8 | 2X3 | 6006577.59669 | 2093640.7294700001 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | ||
| 156878 | 156878 | 56952 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 795 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 7 | Permit Number 14204 | 5993489.41899 | 2110144.08424 | 37.7736789357713 | -122.465975170673 | (37.7736789357713, -122.465975170673) | ||
| 4291 | 4291 | 252895 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 790x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:29:00 PM | 3 | 3x3 | 5997282.0 | 2090432.0 | 37.719772464034904 | -122.45143407539 | (37.7197724640349, -122.45143407539) | ||
| 185696 | 185696 | 175790 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 79 Colby St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6008193.10922 | 2093597.69816 | 37.7290835632519 | -122.413941929669 | (37.7290835632519, -122.413941929669) | |||
| 5700 | 5700 | 107235 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008834.66692 | 2115296.44284 | 37.788699385205796 | -122.413257820814 | (37.7886993852058, -122.413257820814) | |||
| 32397 | 32397 | 125884 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008808.31826 | 2115292.9035099996 | 37.7886881877568 | -122.413348733254 | (37.7886881877568, -122.413348733254) | |||
| 40087 | 40087 | 125883 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008823.04151 | 2115295.3212900003 | 37.7886956530184 | -122.413297963833 | (37.7886956530184, -122.413297963833) | |||
| 150124 | 150124 | 123229 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 785 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993489.53527 | 2110160.53271 | 37.773724105582296 | -122.465975963885 | (37.7737241055823, -122.465975963885) | |||
| 173962 | 173962 | 123230 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 785 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993487.30033 | 2110174.28885 | 37.7737617473343 | -122.465984694601 | (37.7737617473343, -122.465984694601) | |||
| 25555 | 25555 | 175783 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 771 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006465.53434 | 2093625.53998 | 37.729062833884605 | -122.419916279827 | (37.7290628338846, -122.419916279827) | |||
| 420 | 420 | 54426 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 770 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 15 | 3x3 | Permit Number 12242 | 6012397.0815 | 2104349.75534 | 37.758841631549394 | -122.400163199892 | (37.7588416315494, -122.400163199892) | |
| 27115 | 27115 | 175782 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 769 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006531.05237 | 2093633.80708 | 37.729089224484795 | -122.419690364741 | (37.7290892244848, -122.419690364741) | |||
| 61588 | 61588 | 56137 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 767 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 23 | Permit Number 12241 | 6012457.22858 | 2104373.65416 | 37.7589106059655 | -122.399956860327 | (37.7589106059655, -122.399956860327) |
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");