Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 184612 | 184612 | 47181 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 201 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 6 | 4.5x6 | Permit Number 45142 | 5987713.21287 | 2114556.61779 | 37.785459589237 | -122.486279710203 | (37.785459589237, -122.486279710203) |
| 184472 | 184472 | 138052 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1801 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003417.3541 | 2114976.1709 | 37.7875143701184 | -122.431978042658 | (37.7875143701184, -122.431978042658) | |||
| 184396 | 184396 | 117905 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 541 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5983767.17374 | 2112125.62524 | 37.7785540103948 | -122.499751875651 | (37.7785540103948, -122.499751875651) | |||
| 184392 | 184392 | 232870 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 301 Putnam St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 9ft | 6009078.53533 | 2095890.1763799998 | 37.73542790527029 | -122.411042789701 | (37.7354279052703, -122.411042789701) | |||
| 184364 | 184364 | 177938 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5989480.9198900005 | 2089050.18574 | 37.71552854698071 | -122.478298370392 | (37.7155285469807, -122.478298370392) | ||||
| 184362 | 184362 | 194211 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 539 Stevenson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009462.60815 | 2112402.45945 | 37.780788433187205 | -122.410880750763 | (37.7807884331872, -122.410880750763) | |||
| 184325 | 184325 | 137985 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2281 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003041.7191 | 2115135.3028 | 37.787930003407794 | -122.433289038266 | (37.7879300034078, -122.433289038266) | |||
| 184282 | 184282 | 233760 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003146.44095 | 2107902.79715 | 37.7680772840686 | -122.43240995128201 | (37.7680772840686, -122.432409951282) | |||
| 184276 | 184276 | 232896 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 220 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010802.3699 | 2099742.6867299997 | 37.74610258906971 | -122.405354037277 | (37.7461025890697, -122.405354037277) | |||
| 184266 | 184266 | 232878 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2700 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009790.52018 | 2105038.73437 | 37.760587730058106 | -122.40922655576401 | (37.7605877300581, -122.409226555764) | |||
| 184216 | 184216 | 233143 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Worth St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6000860.583219999 | 2102930.76024 | 37.7542954075331 | -122.43995992263099 | (37.7542954075331, -122.439959922631) | |||
| 184193 | 184193 | 138517 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2180 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001767.3097 | 2113968.5147 | 37.7846539224739 | -122.437614662489 | (37.7846539224739, -122.437614662489) | |||
| 184112 | 184112 | 233673 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 381 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002689.64198 | 2101497.38313 | 37.7504636453848 | -122.433532153208 | (37.7504636453848, -122.433532153208) | |||
| 184101 | 184101 | 177924 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Crespi Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5989730.82285 | 2090240.32639 | 37.718810881792 | -122.47752153959 | (37.718810881792, -122.47752153959) | ||||
| 184096 | 184096 | 84677 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 218 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53575 | 5998816.90097 | 2089525.7076700001 | 37.7173717668583 | -122.44606333266 | (37.7173717668583, -122.44606333266) | |
| 184093 | 184093 | 137990 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1802 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004427.935 | 2115085.8149 | 37.787872664485704 | -122.42848945363899 | (37.7878726644857, -122.428489453639) | |||
| 184077 | 184077 | 48454 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 740 Euclid Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45822 | 5995992.02942 | 2113838.59375 | 37.783967137027 | -122.457585672171 | (37.783967137027, -122.457585672171) | ||
| 184058 | 184058 | 177854 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 701 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6000936.66084 | 2089691.6636 | 37.7179482664819 | -122.43874821026002 | (37.7179482664819, -122.43874821026) | ||||
| 184055 | 184055 | 177862 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 941 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000858.94149 | 2091517.8146099998 | 37.7229580424721 | -122.439147663029 | (37.7229580424721, -122.439147663029) | |||
| 184029 | 184029 | 131781 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2758 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5999580.2108 | 2118368.8939099996 | 37.7966116124855 | -122.445497792185 | (37.7966116124855, -122.445497792185) | |||
| 184023 | 184023 | 119455 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 770 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5985727.9206 | 2110655.10709 | 37.7746312487913 | -122.49286065837799 | (37.7746312487913, -122.492860658378) | |||
| 184013 | 184013 | 194162 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1905 23rd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6012692.731819999 | 2102821.3503099997 | 37.7546614459721 | -122.399033419356 | (37.7546614459721, -122.399033419356) | |||
| 183967 | 183967 | 115620 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100x Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6012248.320119999 | 2106930.54412 | 37.7659196081195 | -122.400859007135 | (37.7659196081195, -122.400859007135) | |||
| 183930 | 183930 | 245952 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1469 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998682.8902 | 2108284.1103 | 37.7688701596332 | -122.44787629089599 | (37.7688701596332, -122.447876290896) | |||
| 183857 | 183857 | 210635 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1836 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993775.3880900005 | 2102985.08493 | 37.754038690640606 | -122.46446606615801 | (37.7540386906406, -122.464466066158) | |||
| 183757 | 183757 | 233197 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 799 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007609.55119 | 2095754.8120799998 | 37.7349737377405 | -122.416112048657 | (37.7349737377405, -122.416112048657) | |||
| 183753 | 183753 | 210642 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 340 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991799.31001 | 2099806.7187900003 | 37.7451976111984 | -122.47106822132099 | (37.7451976111984, -122.471068221321) | |||
| 183748 | 183748 | 177988 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 222 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004089.3228400005 | 2092259.6266 | 37.7251781817095 | -122.428033733287 | (37.7251781817095, -122.428033733287) | |||
| 183735 | 183735 | 142135 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2901 GEARY BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998056.6282 | 2113053.2138 | 37.7819290697108 | -122.45038631523899 | (37.7819290697108, -122.450386315239) | |||
| 183716 | 183716 | 88553 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 734 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51498 | 5991338.26851 | 2110389.97452 | 37.7742297509054 | -122.4734341978 | (37.7742297509054, -122.4734341978) | ||
| 183665 | 183665 | 49829 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1919 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46612 | 6011639.18515 | 2106026.99161 | 37.763404660331 | -122.402902336091 | (37.763404660331, -122.402902336091) | |
| 183554 | 183554 | 233612 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 555 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009002.811840001 | 2105601.88525 | 37.7620898514905 | -122.411990688641 | (37.7620898514905, -122.411990688641) | |||
| 183533 | 183533 | 92389 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2210 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52794 | 5986107.9 | 2100167.2 | 37.7458565681974 | -122.490774390723 | (37.7458565681974, -122.490774390723) |
| 183494 | 183494 | 131890 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3225 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5999224.60117 | 2115306.7219700003 | 37.7881833911006 | -122.44650785946101 | (37.7881833911006, -122.446507859461) | |||
| 183465 | 183465 | 210619 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1351 06th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5994232.97707 | 2106350.8089900003 | 37.7633064669379 | -122.46312782010901 | (37.7633064669379, -122.463127820109) | |||
| 183428 | 183428 | 177855 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 435 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010393.78556 | 2086237.29466 | 37.7089967592527 | -122.40581571863301 | (37.7089967592527, -122.405815718633) | |||
| 183369 | 183369 | 194238 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 6 Hillview Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 6016710.45664 | 2095786.72783 | 37.735568882989796 | -122.384648921526 | (37.7355688829898, -122.384648921526) | |||
| 183345 | 183345 | 210695 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 300 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994492.7301 | 2091933.2658400002 | 37.7237344631722 | -122.461184289828 | (37.7237344631722, -122.461184289828) | |||
| 183300 | 183300 | 131982 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2553 Hyde St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006953.2822900005 | 2121013.06293 | 37.8042899872466 | -122.420173025464 | (37.8042899872466, -122.420173025464) | |||
| 183286 | 183286 | 177914 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Font Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5989849.3669300005 | 2089820.74775 | 37.7176657012986 | -122.477081140675 | (37.7176657012986, -122.477081140675) | ||||
| 183219 | 183219 | 233201 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 203 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008290.88905 | 2097632.56099 | 37.7401679116228 | -122.413889201539 | (37.7401679116228, -122.413889201539) | |||
| 183125 | 183125 | 137931 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2002 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003335.365 | 2115227.8721 | 37.788200829356605 | -122.432279691216 | (37.7882008293566, -122.432279691216) | |||
| 183078 | 183078 | 40660 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 221 Craut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767511 | 6004060.03324 | 2093896.80533 | 37.7296718529572 | -122.428251612036 | (37.7296718529572, -122.428251612036) |
| 183015 | 183015 | 124651 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Arguello Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 5995459.76206 | 2115756.0288299997 | 37.7892013075378 | -122.459566029798 | (37.7892013075378, -122.459566029798) | |||
| 183010 | 183010 | 232924 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 555 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002978.482580001 | 2098878.49987 | 37.7432891886523 | -122.43234630086 | (37.7432891886523, -122.43234630086) | |||
| 182941 | 182941 | 82904 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 218 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52251 | 5988073.54197 | 2114506.7997 | 37.7853437980261 | -122.48502943768601 | (37.7853437980261, -122.485029437686) | |
| 182903 | 182903 | 210784 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 228 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5993510.6961 | 2103949.17224 | 37.7566705638228 | -122.465451457821 | (37.7566705638228, -122.465451457821) | |||
| 182879 | 182879 | 233744 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3950 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004015.28401 | 2104246.02541 | 37.7580858943779 | -122.429143947253 | (37.7580858943779, -122.429143947253) | |||
| 182866 | 182866 | 233121 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1709 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6002633.83803 | 2100523.51706 | 37.7477864724724 | -122.4336555339 | (37.7477864724724, -122.4336555339) | |||
| 182815 | 182815 | 246018 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 603 Clayton St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 5998473.1811 | 2108575.8861 | 37.769659312933896 | -122.448622674121 | (37.7696593129339, -122.448622674121) | |||
| 182789 | 182789 | 56406 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 258 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 10 | Permit Number 12564 | 5992163.0601 | 2113723.61694 | 37.7834307514284 | -122.470824002588 | (37.7834307514284, -122.470824002588) | ||
| 182775 | 182775 | 123849 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 26 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995440.45598 | 2114952.8950099996 | 37.7869950091021 | -122.45957463386699 | (37.7869950091021, -122.459574633867) | |||
| 182708 | 182708 | 232907 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 229 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004758.59906 | 2109474.41705 | 37.7724838568662 | -122.426945611154 | (37.7724838568662, -122.426945611154) | |||
| 182571 | 182571 | 41554 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1852 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2000 12:00:00 AM | 6 | Permit Number 42078 | 6004404.2313 | 2115269.6804 | 37.7883761715059 | -122.428584575414 | (37.7883761715059, -122.428584575414) | ||
| 182545 | 182545 | 182973 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2501 19th Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 5990445.0142 | 2098037.2692 | 37.740260736287496 | -122.47562191476601 | (37.7402607362875, -122.475621914766) | |||
| 182496 | 182496 | 232977 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4754 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5998342.50989 | 2105685.39373 | 37.7617152793471 | -122.448866424146 | (37.7617152793471, -122.448866424146) | |||
| 182491 | 182491 | 210802 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 140 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994514.12025 | 2099458.39814 | 37.744397857581795 | -122.46165569017201 | (37.7443978575818, -122.461655690172) | |||
| 182479 | 182479 | 233145 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 235 Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000622.80574 | 2103017.27251 | 37.7545194106514 | -122.440788420366 | (37.7545194106514, -122.440788420366) | |||
| 182460 | 182460 | 132019 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1116 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6007503.17736 | 2119909.69915 | 37.80129139754929 | -122.41819179113001 | (37.8012913975493, -122.41819179113) | ||||
| 182373 | 182373 | 244528 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 554 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998973.8326 | 2108771.3824 | 37.77022471070921 | -122.44690501339 | (37.7702247107092, -122.44690501339) | |||
| 182364 | 182364 | 233174 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 876 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999196.075069999 | 2107215.75897 | 37.7659660554201 | -122.44602437403799 | (37.7659660554201, -122.446024374038) | |||
| 182322 | 182322 | 177911 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 345 Schwerin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008674.6498300005 | 2086439.3705 | 37.7094553262778 | -122.411771593104 | (37.7094553262778, -122.411771593104) | |||
| 182313 | 182313 | 210832 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100 El Verano Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5994491.87078 | 2094685.88565 | 37.731292439379395 | -122.461386713728 | (37.7312924393794, -122.461386713728) | |||
| 182287 | 182287 | 31152 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 34 Marston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34855 | 5999102.9501 | 2093219.07707 | 37.7275292379625 | -122.445340005246 | (37.7275292379625, -122.445340005246) | |
| 182282 | 182282 | 87129 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 7316 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50078 | 5981335.81938 | 2110728.67919 | 37.774575436536296 | -122.508059002234 | (37.7745754365363, -122.508059002234) | |
| 182264 | 182264 | 233638 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 750x San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005667.10941 | 2098695.24621 | 37.7429381014114 | -122.42303669349899 | (37.7429381014114, -122.423036693499) | |||
| 182239 | 182239 | 210612 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1297 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5994220.73174 | 2106715.7612099997 | 37.764307825163996 | -122.46319665510799 | (37.764307825164, -122.463196655108) | |||
| 182236 | 182236 | 182356 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3151 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5985005.527000001 | 2104966.2042 | 37.7589688553292 | -122.494939971824 | (37.7589688553292, -122.494939971824) | |||
| 182176 | 182176 | 131795 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3460 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5999250.6254900005 | 2120749.14861 | 37.8031283320577 | -122.446809584704 | (37.8031283320577, -122.446809584704) | |||
| 182158 | 182158 | 210757 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1359 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5994545.14623 | 2106277.94052 | 37.7631243668099 | -122.462042852794 | (37.7631243668099, -122.462042852794) | |||
| 182150 | 182150 | 232459 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1201 San Jose Ave | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004401.596369999 | 2096010.3452700002 | 37.7354944802799 | -122.427221282156 | (37.7354944802799, -122.427221282156) | ||||
| 182121 | 182121 | 42857 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2587 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 4 | Permit Number 43444 | 5986747.1123 | 2097651.6781 | 37.7389869353159 | -122.48837927722401 | (37.7389869353159, -122.488379277224) | |
| 182086 | 182086 | 194207 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 443 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011160.10683 | 2112013.7535200003 | 37.7798161743168 | -122.40498087078699 | (37.7798161743168, -122.404980870787) | |||
| 181997 | 181997 | 210636 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1836 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993777.18063 | 2102969.7865400002 | 37.7539967885227 | -122.464458756471 | (37.7539967885227, -122.464458756471) | |||
| 181967 | 181967 | 194208 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 443 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011171.46915 | 2112023.89083 | 37.7798446441471 | -122.404942277258 | (37.7798446441471, -122.404942277258) | |||
| 181928 | 181928 | 232984 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 60 Grattan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5998238.971369999 | 2106560.94652 | 37.7641134052337 | -122.449287603655 | (37.7641134052337, -122.449287603655) | |||
| 181897 | 181897 | 233181 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1088 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998975.05646 | 2106207.82472 | 37.763185897523606 | -122.44671629981899 | (37.7631858975236, -122.446716299819) | |||
| 181854 | 181854 | 131970 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 851 Bay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006761.3651 | 2121137.86846 | 37.8046218559624 | -122.420846037638 | (37.8046218559624, -122.420846037638) | |||
| 181819 | 181819 | 177987 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 247 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003817.74975 | 2092243.8026299998 | 37.7251193642443 | -122.428971405999 | (37.7251193642443, -122.428971405999) | |||
| 181773 | 181773 | 246529 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Laguna St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6005210.23202 | 2109136.89842 | 37.77158263905 | -122.425359343752 | (37.77158263905, -122.425359343752) | |||
| 181750 | 181750 | 210631 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1446 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5993378.13325 | 2105628.69584 | 37.7612744523625 | -122.466031944136 | (37.7612744523625, -122.466031944136) | |||
| 181687 | 181687 | 232913 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 229 Haight St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004866.27117 | 2109489.03769 | 37.772530089217895 | -122.42657420375099 | (37.7725300892179, -122.426574203751) | |||
| 181650 | 181650 | 183500 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2546 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989263.245 | 2098011.6951 | 37.7401219355721 | -122.479706081979 | (37.7401219355721, -122.479706081979) | |||
| 181624 | 181624 | 233025 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 539 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009848.47652 | 2098970.25976 | 37.7439282945659 | -122.408598012407 | (37.7439282945659, -122.408598012407) | |||
| 181620 | 181620 | 218170 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1434 Portola Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992917.22018 | 2097403.6420400003 | 37.73866396545999 | -122.46702803503901 | (37.73866396546, -122.467028035039) | |||
| 181597 | 181597 | 177860 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5999854.501540001 | 2088904.19241 | 37.715724424706394 | -122.44243224526699 | (37.7157244247064, -122.442432245267) | |||
| 181539 | 181539 | 233214 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 42 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007330.949990001 | 2099246.41319 | 37.7445452321859 | -122.41732262786199 | (37.7445452321859, -122.417322627862) | |||
| 181466 | 181466 | 233038 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 719 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007946.81709 | 2103621.6255 | 37.7565932095171 | -122.415502774159 | (37.7565932095171, -122.415502774159) | |||
| 181368 | 181368 | 210812 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 481 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994777.82414 | 2100010.49145 | 37.7459289434724 | -122.460783866705 | (37.7459289434724, -122.460783866705) | |||
| 181321 | 181321 | 124607 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3935 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5995867.02911 | 2115169.16923 | 37.787613359123995 | -122.458114454713 | (37.787613359124, -122.458114454713) | |||
| 181316 | 181316 | 75333 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 550 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 4 | 5984432.92075 | 2112122.5576299997 | 37.7785846311766 | -122.497448611437 | (37.7785846311766, -122.497448611437) | ||
| 181146 | 181146 | 210640 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 439 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993473.81307 | 2105251.38351 | 37.7602439705117 | -122.465673617351 | (37.7602439705117, -122.465673617351) | |||
| 181144 | 181144 | 123820 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1851 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992902.99984 | 2112035.48615 | 37.778838367737606 | -122.46814128190701 | (37.7788383677376, -122.468141281907) | |||
| 181019 | 181019 | 55603 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 655 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1973 12:00:00 AM | 2 | Permit Number 11578 | 5982556.76294 | 2111288.6784099997 | 37.7761848980348 | -122.50387707418899 | (37.7761848980348, -122.503877074189) | ||
| 180974 | 180974 | 194218 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1121 Jamestown Ave | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 6013410.02884 | 2090031.5953 | 37.7195833814573 | -122.39565673576901 | (37.7195833814573, -122.395656735769) | ||||
| 180933 | 180933 | 56397 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 114 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 14 | Permit Number 12554 | 5992131.67655 | 2114594.11315 | 37.78581907904471 | -122.47099601200199 | (37.7858190790447, -122.470996012002) | ||
| 180894 | 180894 | 92331 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2539 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52763 | 5987045.4336 | 2097971.4347 | 37.7398823039806 | -122.48737131399099 | (37.7398823039806, -122.487371313991) |
| 180728 | 180728 | 210787 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 228 Moraga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5993459.01298 | 2103951.3020599997 | 37.7566734308553 | -122.46563035007401 | (37.7566734308553, -122.465630350074) | |||
| 180680 | 180680 | 232947 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 40 Jersey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004869.4439199995 | 2101662.19085 | 37.7510396045052 | -122.42600596261299 | (37.7510396045052, -122.426005962613) | |||
| 180667 | 180667 | 233725 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4582 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000721.45807 | 2104676.56088 | 37.7590810301826 | -122.44056625992799 | (37.7590810301826, -122.440566259928) |
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");