Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28706 | 28706 | 223282 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 10 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005802.51447 | 2097630.0872400003 | 37.740021055027796 | -122.42249282938299 | (37.7400210550278, -122.422492829383) | |||
| 135878 | 135878 | 223668 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 10 Gladys St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005828.6404800005 | 2097671.05304 | 37.740135011734 | -122.42240540628299 | (37.740135011734, -122.422405406283) | |||
| 177315 | 177315 | 223667 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 10 Gladys St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005813.9989 | 2097648.1123599997 | 37.7400711958267 | -122.42245440134701 | (37.7400711958267, -122.422454401347) | |||
| 100833 | 100833 | 32757 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) | ||
| 108363 | 108363 | 32760 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) |
| 124807 | 124807 | 32759 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) | ||
| 145468 | 145468 | 32758 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) | ||
| 79932 | 79932 | 34810 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 101 Rome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38445 | 5999074.40253363 | 2089202.20922089 | 37.7164982153246 | -122.44515002823799 | (37.7164982153246, -122.445150028238) | ||
| 65480 | 65480 | 49145 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 1010 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2003 12:00:00 AM | 4 | Permit Number 46270 | 6013902.9734 | 2089731.1325 | 37.718785778664206 | -122.393931770521 | (37.7187857786642, -122.393931770521) | ||
| 171518 | 171518 | 68911 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 1037 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | Permit Number 32888 | 6008631.3882 | 2118270.06785 | 37.7968528160714 | -122.414171603039 | (37.7968528160714, -122.414171603039) | |
| 73196 | 73196 | 124327 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 104 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995930.14296 | 2113730.15975 | 37.783665851105106 | -122.45779192626001 | (37.7836658511051, -122.45779192626) | |||
| 54466 | 54466 | 206796 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 106 Thrift St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995821.5045300005 | 2089648.1918400002 | 37.7175365712383 | -122.456425813227 | (37.7175365712383, -122.456425813227) | |||
| 61320 | 61320 | 206795 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 106 Thrift St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5995838.02992 | 2089647.4067799998 | 37.717535364348 | -122.456368636129 | (37.717535364348, -122.456368636129) | |||
| 72106 | 72106 | 206794 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 106 Thrift St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5995856.77369 | 2089647.2346700002 | 37.7175359677947 | -122.456303835451 | (37.7175359677947, -122.456303835451) | |||
| 95276 | 95276 | 206793 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 106 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 5995874.19015 | 2089646.87055 | 37.7175359677985 | -122.456243608772 | (37.7175359677985, -122.456243608772) | |||
| 91336 | 91336 | 34210 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 110 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38026 | 6010548.985067501 | 2099059.00866257 | 37.7442111875512 | -122.406182054391 | (37.7442111875512, -122.406182054391) | ||
| 172763 | 172763 | 248033 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 110 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6010558.59528 | 2099039.59827 | 37.74415842836721 | -122.406147456957 | (37.7441584283672, -122.406147456957) | |||
| 38709 | 38709 | 190954 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 120 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6015962.97968 | 2113739.68127 | 37.7848224915123 | -122.38848597435499 | (37.7848224915123, -122.388485974355) | |||
| 145322 | 145322 | 33995 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 120 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38457 | 6010502.26399862 | 2099074.74698805 | 37.7442517881202 | -122.40634471521003 | (37.7442517881202, -122.40634471521) | ||
| 175143 | 175143 | 248034 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 120 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6010483.27046 | 2099064.9388900003 | 37.7442237946989 | -122.40640970014299 | (37.7442237946989, -122.406409700143) | |||
| 65926 | 65926 | 176082 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 120 Lathrop Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011914.4891800005 | 2086894.19237 | 37.7108853976137 | -122.400606027845 | (37.7108853976137, -122.400606027845) | |||
| 131951 | 131951 | 176083 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 120 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011939.3192 | 2086886.00886 | 37.7108643121037 | -122.40051963449899 | (37.7108643121037, -122.400519634499) | |||
| 83132 | 83132 | 34215 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 123 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38031 | 6010471.85076762 | 2099030.12086895 | 37.7441275531286 | -122.40644673425 | (37.7441275531286, -122.40644673425) | ||
| 185935 | 185935 | 248032 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 123 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6010451.01277 | 2099046.16811 | 37.7441704496095 | -122.40651991836 | (37.7441704496095, -122.40651991836) | |||
| 26963 | 26963 | 35238 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 1240 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 6 | Permit Number 38734 | 6006976.68497 | 2119487.9073799998 | 37.8001036152424 | -122.419983741574 | (37.8001036152424, -122.419983741574) | |
| 76668 | 76668 | 223269 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1260 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010823.03156 | 2102440.75531 | 37.7535120494589 | -122.405472576922 | (37.7535120494589, -122.405472576922) | |||
| 95636 | 95636 | 34306 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 1260 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38094 | 6010824.33318422 | 2102458.44647529 | 37.7535606982702 | -122.405469321452 | (37.7535606982702, -122.405469321452) | ||
| 31285 | 31285 | 176081 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 127 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 5999102.55094 | 2089159.5285 | 37.7163826304266 | -122.445049667216 | (37.7163826304266, -122.445049667216) | |||
| 24301 | 24301 | 206799 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 127 Stillings Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999908.7774 | 2095745.2433799999 | 37.7345114691125 | -122.44273557669099 | (37.7345114691125, -122.442735576691) | |||
| 122851 | 122851 | 33431 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 127 Stillings Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37535 | 5999930.67607914 | 2095733.95298446 | 37.7344817167018 | -122.44265905551799 | (37.7344817167018, -122.442659055518) | ||
| 52674 | 52674 | 223271 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1301 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010084.63709 | 2101573.03413 | 37.751088165204294 | -122.407964929261 | (37.7510881652043, -122.407964929261) | |||
| 107956 | 107956 | 34211 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 132 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38027 | 6010446.19872622 | 2099093.63297516 | 37.7443005084973 | -122.406539908391 | (37.7443005084973, -122.406539908391) | ||
| 163960 | 163960 | 248035 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 132 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6010441.24954 | 2099079.47689 | 37.744261362076294 | -122.40655602435899 | (37.7442613620763, -122.406556024359) | |||
| 86117 | 86117 | 46711 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 1337 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44841 | 5996760.70858802 | 2106869.35577873 | 37.7648755513325 | -122.454422736012 | (37.7648755513325, -122.454422736012) | ||
| 76256 | 76256 | 248031 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 135 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6010398.33522 | 2099063.65948 | 37.7442155299264 | -122.406703299111 | (37.7442155299264, -122.406703299111) | |||
| 109736 | 109736 | 34214 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 135 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38030 | 6010413.34787543 | 2099049.82798569 | 37.744178391599704 | -122.40665041382299 | (37.7441783915997, -122.406650413823) | ||
| 141044 | 141044 | 46131 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 137 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | Permit Number 44481 | 5997450.10216271 | 2107762.76782376 | 37.7673681457069 | -122.452102777266 | (37.7673681457069, -122.452102777266) | ||
| 123357 | 123357 | 34213 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 137 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38029 | 6010403.59737914 | 2099053.11250995 | 37.7441868646564 | -122.40668436049499 | (37.7441868646564, -122.406684360495) | ||
| 33140 | 33140 | 248036 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 146 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6010366.793380001 | 2099106.9890099997 | 37.7443327385694 | -122.406815417622 | (37.7443327385694, -122.406815417622) | |||
| 122799 | 122799 | 34212 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 146 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38028 | 6010380.78922037 | 2099115.666634 | 37.74435734854671 | -122.40676763416599 | (37.7443573485467, -122.406767634166) | ||
| 117952 | 117952 | 35259 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 15 North View Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | Permit Number 38745 | 6006261.16028369 | 2120974.78404058 | 37.8041458613164 | -122.422565451189 | (37.8041458613164, -122.422565451189) | ||
| 50490 | 50490 | 2506 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 1501 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/16/1999 12:00:00 AM | 3 | 3x3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | ||
| 126803 | 126803 | 45808 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 151 Charles St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2001 12:00:00 AM | Permit Number 44436 | 6004877.73984335 | 2097041.07807041 | 37.7383515558837 | -122.42564841052 | (37.7383515558837, -122.42564841052) | |||
| 40845 | 40845 | 36941 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 152 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 5 | Permit Number 39580 | 5994928.17811 | 2114463.2730099997 | 37.7856211696771 | -122.46131148063401 | (37.7856211696771, -122.461311480634) | |
| 59130 | 59130 | 36944 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 152 03rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 4 | Permit Number 39580 | 5994925.42579 | 2114533.20025 | 37.785813012576206 | -122.46132607375401 | (37.7858130125762, -122.461326073754) | |
| 135441 | 135441 | 36943 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 152 03rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 4 | Permit Number 39580 | 5994926.19435 | 2114520.7878400004 | 37.7857789756862 | -122.46132251465099 | (37.7857789756862, -122.461322514651) | |
| 16443 | 16443 | 2539 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 1575 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/05/1999 12:00:00 AM | 3 | 3X3 | 6016305.53274 | 2099035.35536 | 37.7444665522926 | -122.386275327464 | (37.7444665522926, -122.386275327464) | ||
| 31924 | 31924 | 223281 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 16 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005792.089819999 | 2097609.55014 | 37.7399640766707 | -122.422527414631 | (37.7399640766707, -122.422527414631) | |||
| 108856 | 108856 | 52142 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 16 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2005 12:00:00 AM | Permit Number 48323 | 6005795.19032335 | 2097640.79736733 | 37.7400500494445 | -122.42251891414101 | (37.7400500494445, -122.422518914141) | ||
| 32219 | 32219 | 95597 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1625 Carroll Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6013964.9434 | 2092060.83 | 37.725186106945294 | -122.393880551992 | (37.7251861069453, -122.393880551992) | |||
| 31916 | 31916 | 36945 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 165 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 8 | Permit Number 39581 | 5994878.4768199995 | 2114483.13102 | 37.7856728338639 | -122.461484871659 | (37.7856728338639, -122.461484871659) | |
| 161404 | 161404 | 36946 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 165 03rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39581 | 5994879.55101 | 2114458.4572900003 | 37.7856051482988 | -122.461479365875 | (37.7856051482988, -122.461479365875) | |
| 118866 | 118866 | 32528 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 17 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37030 | 6007054.5480271 | 2095691.64868794 | 37.734769083447205 | -122.418026418979 | (37.7347690834472, -122.418026418979) | ||
| 36389 | 36389 | 202190 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1900 Armstrong Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6013173.69096 | 2093416.62895 | 37.7288648499236 | -122.396710853637 | (37.7288648499236, -122.396710853637) | ||||
| 171425 | 171425 | 202159 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1907 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 6013147.17786 | 2093363.32947 | 37.7287170247605 | -122.39679877674999 | (37.7287170247605, -122.39679877675) | |||
| 152240 | 152240 | 202158 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1913 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6013140.94695 | 2093368.78005 | 37.7287316441256 | -122.39682069951701 | (37.7287316441256, -122.396820699517) | |||
| 37936 | 37936 | 202157 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1919 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 6013116.58632 | 2093387.72348 | 37.7287823029563 | -122.39690624394 | (37.7287823029563, -122.39690624394) | |||
| 23694 | 23694 | 126409 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1920 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004775.53242 | 2116016.61179 | 37.7904480629696 | -122.42735316234 | (37.7904480629696, -122.42735316234) | |||
| 62935 | 62935 | 126410 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1920 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6004771.881580001 | 2116049.56275 | 37.790538331527 | -122.427368142329 | (37.790538331527, -122.427368142329) | |||
| 35191 | 35191 | 202156 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1925 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6013109.746230001 | 2093393.80545 | 37.7287986220599 | -122.39693031698799 | (37.7287986220599, -122.396930316988) | |||
| 170843 | 170843 | 202194 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1928 Armstrong Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6013120.24399 | 2093453.13638 | 37.72896211700179 | -122.396898183325 | (37.7289621170018, -122.396898183325) | |||
| 26249 | 26249 | 202155 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1931 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6013085.35579 | 2093411.26351 | 37.728845200628705 | -122.39701586051399 | (37.7288452006287, -122.397015860514) | |||
| 23889 | 23889 | 202154 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1937 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 6013078.37637 | 2093416.60548 | 37.728859480065104 | -122.397040363418 | (37.7288594800651, -122.397040363418) | |||
| 32883 | 32883 | 202195 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1938 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 6013111.07859 | 2093460.1186900001 | 37.7289807788209 | -122.39693035835501 | (37.7289807788209, -122.396930358355) | |||
| 175817 | 175817 | 202153 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1943 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6013054.85353 | 2093433.92218 | 37.7289057187068 | -122.397122897799 | (37.7289057187068, -122.397122897799) | |||
| 158962 | 158962 | 202201 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1948 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 6013078.4423 | 2093486.02938 | 37.729050107561605 | -122.39704500125099 | (37.7290501075616, -122.397045001251) | |||
| 52637 | 52637 | 202151 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1955 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6013019.68164 | 2093458.4573099997 | 37.7289711290907 | -122.397246210158 | (37.7289711290907, -122.397246210158) | |||
| 41797 | 41797 | 202202 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1956 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6013055.77305 | 2093504.05261 | 37.72909833370429 | -122.397124634419 | (37.7290983337043, -122.397124634419) | |||
| 29779 | 29779 | 202150 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1961 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 6013012.274569999 | 2093463.5941 | 37.728984821287604 | -122.397272177194 | (37.7289848212876, -122.397272177194) | |||
| 148055 | 148055 | 202149 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1967 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6012987.61375 | 2093482.17002 | 37.7290344539678 | -122.39735873424101 | (37.7290344539678, -122.397358734241) | |||
| 155140 | 155140 | 202207 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1968 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 6013020.76239 | 2093529.61913 | 37.72916658504629 | -122.397247462005 | (37.7291665850463, -122.397247462005) | |||
| 159166 | 159166 | 202148 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1973 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6012979.956230001 | 2093488.41205 | 37.7290511669581 | -122.397385644629 | (37.7290511669581, -122.397385644629) | |||
| 164286 | 164286 | 202206 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1976 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6013013.79593 | 2093534.14859 | 37.7291786341692 | -122.397271863302 | (37.7291786341692, -122.397271863302) | |||
| 48176 | 48176 | 202145 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1991 Armstrong Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6012926.39508 | 2093534.5223299998 | 37.7291747940604 | -122.397574043633 | (37.7291747940604, -122.397574043633) | |||
| 178266 | 178266 | 202196 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1996 Armstrong Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6012954.27353 | 2093570.5990799998 | 37.7292754057276 | -122.397480193965 | (37.7292754057276, -122.397480193965) | |||
| 72750 | 72750 | 202197 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1998 Armstrong Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 6012952.41894 | 2093581.1404799998 | 37.7293042469875 | -122.39748734448901 | (37.7293042469875, -122.397487344489) | |||
| 175973 | 175973 | 202198 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1998 Armstrong Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6012950.89039 | 2093587.34994 | 37.7293212117817 | -122.39749306417102 | (37.7293212117817, -122.397493064171) | |||
| 135209 | 135209 | 202143 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1999 Armstrong Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6012908.83816 | 2093533.00853 | 37.7291696598447 | -122.39763463365601 | (37.7291696598447, -122.397634633656) | |||
| 161132 | 161132 | 202144 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1999 Armstrong Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6012917.46969 | 2093534.23595 | 37.7291735107263 | -122.39760487958598 | (37.7291735107263, -122.397604879586) | |||
| 85599 | 85599 | 41099 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.741600645555295 | -122.41705911631 | (37.7416006455553, -122.41705911631) | |||
| 123965 | 123965 | 41097 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.741600645555295 | -122.41705911631 | (37.7416006455553, -122.41705911631) | ||
| 125526 | 125526 | 41098 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.741600645555295 | -122.41705911631 | (37.7416006455553, -122.41705911631) | |||
| 158662 | 158662 | 223670 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007488.19675 | 2098176.2850900004 | 37.7416157445795 | -122.416703102889 | (37.7416157445795, -122.416703102889) | |||
| 179066 | 179066 | 223669 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007464.47007 | 2098181.71647 | 37.741629323436 | -122.416785526654 | (37.741629323436, -122.416785526654) | |||
| 180363 | 180363 | 223671 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007506.0274 | 2098173.94158 | 37.74161031266821 | -122.41664128437999 | (37.7416103126682, -122.41664128438) | |||
| 858 | 858 | 251395 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2101 26th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012226.0 | 2101445.0 | 37.750856267744496 | -122.400550836744 | (37.7508562677445, -122.400550836744) | |||||
| 188183 | 188183 | 45080 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2131 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 2 | Permit Number 43963 | 5987257.3685 | 2100779.0687 | 37.747603677476796 | -122.486844665894 | (37.7476036774768, -122.486844665894) | |
| 122324 | 122324 | 42048 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 214 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42365 | 6005128.75403076 | 2099926.75275442 | 37.746289143211 | -122.424985780451 | (37.746289143211, -122.424985780451) | |||
| 21674 | 21674 | 16056 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 219 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000606.99528 | 2094621.48132 | 37.73146565869779 | -122.440241050681 | (37.7314656586978, -122.440241050681) | |||
| 7979 | 7979 | 18858 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2205 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 3 | 3X3 | 6004161.3463 | 2115991.64976 | 37.7903447686476 | -122.429476425706 | (37.7903447686476, -122.429476425706) | ||
| 7998 | 7998 | 18857 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2205 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004122.834530001 | 2115986.40617 | 37.7903281905406 | -122.429609299623 | (37.7903281905406, -122.429609299623) | |||
| 17191 | 17191 | 16057 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 223 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000584.1346 | 2094621.9553599998 | 37.731465658714704 | -122.440320118183 | (37.7314656587147, -122.440320118183) | |||
| 27328 | 27328 | 87375 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2260 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50354 | 6002754.86508 | 2117851.80472 | 37.7953725427601 | -122.434475803729 | (37.7953725427601, -122.434475803729) | |
| 18327 | 18327 | 16062 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 234 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000489.610780001 | 2094702.95289 | 37.731682676805605 | -122.44065271176399 | (37.7316826768056, -122.440652711764) | |||
| 21129 | 21129 | 16061 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 234 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000514.97584 | 2094701.7216599998 | 37.7316807405534 | -122.440564931622 | (37.7316807405534, -122.440564931622) | |||
| 21884 | 21884 | 16063 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 235 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000510.81653 | 2094624.7410400002 | 37.73146913277839 | -122.44057379176701 | (37.7314691327784, -122.440573791767) | |||
| 17437 | 17437 | 16066 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 236 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000441.13466 | 2094703.95832 | 37.731682676816604 | -122.44082037507401 | (37.7316826768166, -122.440820375074) | |||
| 19001 | 19001 | 16065 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 236 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000470.32804 | 2094701.9984799998 | 37.7316789581131 | -122.440719307449 | (37.7316789581131, -122.440719307449) | |||
| 23363 | 23363 | 16067 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 236 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6000426.63236 | 2094704.03312 | 37.7316820562622 | -122.44087051766 | (37.7316820562622, -122.44087051766) | |||
| 21004 | 21004 | 16064 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 239 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000482.86247 | 2094624.68801 | 37.7314673953084 | -122.440670430219 | (37.7314673953084, -122.440670430219) |
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");