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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35701 | 35701 | 39897 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1525 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | 4 | Permit Number 41180 | 6000089.6621 | 2114362.3683 | 37.7856398137858 | -122.443447044634 | (37.7856398137858, -122.443447044634) | ||
| 36078 | 36078 | 43178 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1537 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 42984 | 6006296.5432 | 2092934.0049700001 | 37.7271545075605 | -122.420451430388 | (37.7271545075605, -122.420451430388) | |
| 36474 | 36474 | 232464 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6003586.39232 | 2095695.85827 | 37.7345848349269 | -122.430017322941 | (37.7345848349269, -122.430017322941) | ||||
| 36522 | 36522 | 43683 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 675 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 9 | Permit Number 43326 | 5994390.52222 | 2110930.65455 | 37.7758905913229 | -122.462915215949 | (37.7758905913229, -122.462915215949) | |
| 36608 | 36608 | 107488 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6011453.59321 | 2119920.31769 | 37.80154211772779 | -122.40452228489599 | (37.8015421177278, -122.404522284896) | ||||
| 36837 | 36837 | 37619 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 522 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 9 | Permit Number 45363 | 5990650.98195 | 2111800.44887 | 37.7780627029466 | -122.475914650197 | (37.7780627029466, -122.475914650197) | |
| 36854 | 36854 | 61552 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1236 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/2014 12:00:00 AM | 1 | Permit Number 772878 | 6012212.2651 | 2102631.23615 | 37.7541126481909 | -122.400681658131 | (37.7541126481909, -122.400681658131) | |
| 36870 | 36870 | 74231 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2054 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 2 | 6009468.6226 | 2120763.8774 | 37.8037471914209 | -122.411450838489 | (37.8037471914209, -122.411450838489) | ||
| 36936 | 36936 | 78310 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 542 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 9 | 6002972.7622 | 2090478.24127 | 37.7202236600817 | -122.43176643509399 | (37.7202236600817, -122.431766435094) | ||
| 37321 | 37321 | 194134 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 48 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015354.20873 | 2102436.4215599997 | 37.753752465207704 | -122.389802351607 | (37.7537524652077, -122.389802351607) | ||||
| 37757 | 37757 | 31048 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 15 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 5 | Permit Number 34804 | 6002823.26013 | 2087491.091 | 37.7120131267777 | -122.432070011132 | (37.7120131267777, -122.432070011132) | |
| 38009 | 38009 | 35479 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 810 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1998 12:00:00 AM | 11 | Permit Number 38891 | 6008353.20101 | 2093612.67362 | 37.7291336725688 | -122.413389536403 | (37.7291336725688, -122.413389536403) | |
| 38010 | 38010 | 55243 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 180 Escolta Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1972 12:00:00 AM | 8 | Permit Number 11163 | 5986298.9548 | 2097304.4873 | 37.738007482835 | -122.48990325036101 | (37.738007482835, -122.489903250361) | ||
| 38628 | 38628 | 55601 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 646 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1973 12:00:00 AM | 12 | Permit Number 11575 | 5982597.71515 | 2111371.57674 | 37.776414920590504 | -122.503741552554 | (37.7764149205905, -122.503741552554) | ||
| 38791 | 38791 | 58982 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 579 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1980 12:00:00 AM | 12 | Permit Number 18271 | 5995293.06178 | 2111624.74773 | 37.7778483315468 | -122.45984340978701 | (37.7778483315468, -122.459843409787) | ||
| 39000 | 39000 | 131839 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 5999268.60171 | 2116764.1225799997 | 37.7921875424622 | -122.44646051556002 | (37.7921875424622, -122.44646051556) | ||||
| 39071 | 39071 | 114959 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 517 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2015 12:00:00 AM | 1 | Permit Number 776031 | 6002108.88292 | 2086505.1138400002 | 37.7092653220046 | -122.43446864782801 | (37.7092653220046, -122.434468647828) | ||
| 39157 | 39157 | 56304 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 136 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1973 12:00:00 AM | 10 | Permit Number 12436 | 5993060.943080001 | 2114574.0130000003 | 37.7858175910225 | -122.46777957524701 | (37.7858175910225, -122.467779575247) | ||
| 39449 | 39449 | 194139 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 770 Illinois St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6015990.605380001 | 2105494.8516 | 37.7621855348578 | -122.387814914632 | (37.7621855348578, -122.387814914632) | ||||
| 39569 | 39569 | 43766 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 509 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 9 | Permit Number 43401 | 5990292.136609999 | 2111875.33871 | 37.778247517131796 | -122.477161485772 | (37.7782475171318, -122.477161485772) | |
| 39922 | 39922 | 43882 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2735 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 12 | Permit Number 43495 | 5996467.522580001 | 2111252.60671 | 37.7768940023179 | -122.45575365699301 | (37.7768940023179, -122.455753656993) | ||
| 40102 | 40102 | 35390 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 772 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 3 | Permit Number 38844 | 6012700.6062199995 | 2103940.5742099998 | 37.7577350292672 | -122.399084742776 | (37.7577350292672, -122.399084742776) | |
| 40385 | 40385 | 52938 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 46 Norton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 6 | Permit Number 48925 | 6001865.98716 | 2092261.2406099997 | 37.7250565744922 | -122.43571968122299 | (37.7250565744922, -122.435719681223) | |
| 40489 | 40489 | 49942 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2422@ TARAVAL 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 5 | Permit Number 46700 | 5986754.8629 | 2098754.0466 | 37.742014198797 | -122.488433474546 | (37.742014198797, -122.488433474546) | |
| 41012 | 41012 | 52441 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2231 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 7 | Permit Number 48552 | 6002319.04609 | 2115938.04243 | 37.7900930969695 | -122.43584681030501 | (37.7900930969695, -122.435846810305) | |
| 41105 | 41105 | 30844 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 238 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 9 | Permit Number 34692 | 5999056.13874 | 2115758.2343900003 | 37.7894135017764 | -122.44712321518499 | (37.7894135017764, -122.447123215185) | |
| 41369 | 41369 | 51276 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 482 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 4 | Permit Number 47651 | 5990021.33138 | 2112081.55633 | 37.778798018484004 | -122.47811337118999 | (37.778798018484, -122.47811337119) | |
| 41630 | 41630 | 53038 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2374@ TARAVAL 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2006 12:00:00 AM | 4 | Permit Number 49016 | 5987364.699 | 2099122.2495 | 37.7430607503819 | -122.48635190898399 | (37.7430607503819, -122.486351908984) | ||
| 41686 | 41686 | 48671 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 753 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46610 | 6011587.55769 | 2104839.3424400003 | 37.7601407580013 | -122.40299736025 | (37.7601407580013, -122.40299736025) | |
| 41849 | 41849 | 58017 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 354 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/1977 12:00:00 AM | 7 | Permit Number 16984 | 6006814.3957 | 2092799.81302 | 37.726815214933 | -122.418651703538 | (37.726815214933, -122.418651703538) | ||
| 41919 | 41919 | 50031 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 347 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 6 | Permit Number 46763 | 6008779.58166 | 2094534.76231 | 37.7316894612825 | -122.411980634224 | (37.7316894612825, -122.411980634224) | |
| 41953 | 41953 | 78551 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2255 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 5 | 5982019.5732 | 2099750.385 | 37.7444724345971 | -122.504880128796 | (37.7444724345971, -122.504880128796) | ||
| 42009 | 42009 | 38710 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1996 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 6 | Permit Number 40615 | 5999645.261 | 2111241.3734 | 37.7770450137925 | -122.44476012317 | (37.7770450137925, -122.44476012317) | |
| 42010 | 42010 | 32289 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1459 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 7 | Permit Number 36871 | 5991131.7394199995 | 2105485.99284 | 37.760752775430205 | -122.47379078211901 | (37.7607527754302, -122.473790782119) | ||
| 42250 | 42250 | 194138 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 770 Illinois St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6015994.24024 | 2105456.78042 | 37.7620812009176 | -122.387799686412 | (37.7620812009176, -122.387799686412) | ||||
| 42330 | 42330 | 56322 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 268 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 8 | Permit Number 12458 | 5993095.16583 | 2113684.0084700002 | 37.7833758581203 | -122.46759642764799 | (37.7833758581203, -122.467596427648) | ||
| 42725 | 42725 | 78364 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 426 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 6 | 6002109.01666 | 2091133.31338 | 37.721973341483995 | -122.43479893283701 | (37.721973341484, -122.434798932837) | ||
| 42941 | 42941 | 51398 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 409 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 7 | Permit Number 47725 | 6011224.1618 | 2112342.5923099997 | 37.780722669343206 | -122.404782432666 | (37.7807226693432, -122.404782432666) | |
| 42958 | 42958 | 49805 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1142SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 9 | Permit Number 46600 | 6014194.882780001 | 2105753.61687 | 37.7627964083541 | -122.394043799009 | (37.7627964083541, -122.394043799009) | |
| 43474 | 43474 | 55404 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 293 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1972 12:00:00 AM | 9 | Permit Number 11343 | 6011557.05341 | 2119721.55035 | 37.8010021324143 | -122.40415026682899 | (37.8010021324143, -122.404150266829) | ||
| 43623 | 43623 | 30478 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2424 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1956 12:00:00 AM | 4 | Permit Number 126 | 6001410.73244 | 2118019.68734 | 37.7957571135466 | -122.439138752573 | (37.7957571135466, -122.439138752573) | ||
| 43798 | 43798 | 41203 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 18 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1999 12:00:00 AM | 9 | Permit Number 41910 | 5993961.82877 | 2115413.43591 | 37.7881743948276 | -122.46472376628901 | (37.7881743948276, -122.464723766289) | ||
| 43805 | 43805 | 56488 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 555 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 5988104.04939 | 2112189.85065 | 37.7789838887397 | -122.484753866889 | (37.7789838887397, -122.484753866889) | ||||
| 44068 | 44068 | 68959 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1802 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32948 | 5989942.73777 | 2111303.8332599998 | 37.7766580439621 | -122.47832837215799 | (37.7766580439621, -122.478328372158) | ||
| 44376 | 44376 | 50205 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 615@ ANZA 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 6 | Permit Number 46913 | 5987501.56925 | 2111753.94334 | 37.777751903527104 | -122.486806042087 | (37.7777519035271, -122.486806042087) | |
| 44949 | 44949 | 194175 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 651 Missouri St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013644.331680001 | 2103874.0702400003 | 37.7576049693161 | -122.39581626740299 | (37.7576049693161, -122.395816267403) | ||||
| 45023 | 45023 | 45541 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3300 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44296 | 5988715.44051 | 2095267.2958099998 | 37.732554688228795 | -122.481399213927 | (37.7325546882288, -122.481399213927) | |
| 45156 | 45156 | 177964 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5988925.38088 | 2089008.91353 | 37.715382958419106 | -122.48021552173901 | (37.7153829584191, -122.480215521739) | ||||
| 45233 | 45233 | 194145 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 Pennsylvania Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014334.84146 | 2106266.74633 | 37.764213127454205 | -122.393595642523 | (37.7642131274542, -122.393595642523) | ||||
| 45253 | 45253 | 66571 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 269 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 9 | Permit Number 29760 | 6002938.60911 | 2091863.04833 | 37.7240240961129 | -122.431983324585 | (37.7240240961129, -122.431983324585) | |
| 45369 | 45369 | 50552 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2731 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | 5 | Permit Number 47177 | 5996499.54899 | 2111256.63391 | 37.7769068978686 | -122.455643159709 | (37.7769068978686, -122.455643159709) | ||
| 45713 | 45713 | 56489 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 567 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5988106.4335900005 | 2112126.7944900002 | 37.7788108931239 | -122.484740992236 | (37.7788108931239, -122.484740992236) | ||||
| 45831 | 45831 | 246626 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3300 Harrison St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009022.37721 | 2099388.9393599997 | 37.7450315954447 | -122.411484058261 | (37.7450315954447, -122.411484058261) | ||||
| 46225 | 46225 | 233148 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3980 22nd St | 10 | : 4 | Tree 1 | Private 1 | 6 | 6001886.52284 | 2102943.06219 | 37.7543875349734 | -122.4364128508 | (37.7543875349734, -122.4364128508) | ||||
| 46297 | 46297 | 59229 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 624 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1980 12:00:00 AM | 4 | Permit Number 18551 | 5996381.2711 | 2113852.7354 | 37.78402831768629 | -122.456240069464 | (37.7840283176863, -122.456240069464) | ||
| 46646 | 46646 | 43176 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 350 Pioche St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | 11 | Permit Number 42983 | 6005799.17081 | 2093310.07067 | 37.728159060187394 | -122.42219755049999 | (37.7281590601874, -122.4221975505) | ||
| 47308 | 47308 | 31298 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1718 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 8 | Permit Number 43850 | 5989075.352000001 | 2103610.9593 | 37.7554851201375 | -122.480765550046 | (37.7554851201375, -122.480765550046) | |
| 47671 | 47671 | 47851 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1238 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 5 | Permit Number 45610 | 5983067.6301 | 2106694.7653 | 37.7636013609659 | -122.501769909969 | (37.7636013609659, -122.501769909969) | |
| 47979 | 47979 | 131824 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 599 Spruce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5997098.15866 | 2113893.82945 | 37.784182276729204 | -122.45376288107501 | (37.7841822767292, -122.453762881075) | ||||
| 48675 | 48675 | 30331 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 146 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 2 | Permit Number 773837 | 6007384.6010300005 | 2098241.57686 | 37.741789194105 | -122.417065928069 | (37.741789194105, -122.417065928069) | ||
| 48789 | 48789 | 194147 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 Pennsylvania Ave | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014318.41099 | 2106520.5018700003 | 37.7649089715932 | -122.393670233204 | (37.7649089715932, -122.393670233204) | ||||
| 48999 | 48999 | 132016 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 955 Green St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6008442.208 | 2118980.08343 | 37.798791714829896 | -122.414876489872 | (37.7987917148299, -122.414876489872) | ||||
| 49113 | 49113 | 119630 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave West | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2016 12:00:00 AM | 3 | 5999876.8122 | 2107852.06726 | 37.7677520478965 | -122.443715568345 | (37.7677520478965, -122.443715568345) | |||
| 49173 | 49173 | 69441 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 598 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 7 | Permit Number 33548 | 6013520.05596 | 2111448.24133 | 37.7783950440445 | -122.39677705272699 | (37.7783950440445, -122.396777052727) | |
| 49226 | 49226 | 45516 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2975 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | Permit Number 44280 | 5988544.38188689 | 2095413.25132317 | 37.7329454972405 | -122.482001286035 | (37.7329454972405, -122.482001286035) | ||
| 49287 | 49287 | 232462 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6003605.59401 | 2095716.2711599998 | 37.734641971550396 | -122.42995239189501 | (37.7346419715504, -122.429952391895) | ||||
| 49442 | 49442 | 61875 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 226 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/1985 12:00:00 AM | 17 | Permit Number 21916 | 6001623.79973 | 2120628.37 | 37.8029319911659 | -122.438588510477 | (37.8029319911659, -122.438588510477) | ||
| 49450 | 49450 | 44449 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 81 Winding Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2003 12:00:00 AM | 3 | Permit Number 43778 | 6002622.57283 | 2086916.9861 | 37.7104253799983 | -122.432722658146 | (37.7104253799983, -122.432722658146) | ||
| 49615 | 49615 | 61791 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1243 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 13 | Permit Number 21814 | 6011992.65884 | 2102590.77396 | 37.753989297192796 | -122.40143827126002 | (37.7539892971928, -122.40143827126) | |
| 49991 | 49991 | 45543 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3300 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44296 | 5988727.593669999 | 2095266.58975 | 37.7325534561717 | -122.481357146331 | (37.7325534561717, -122.481357146331) | |
| 50041 | 50041 | 65382 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1709 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 9 | Permit Number 28221 | 6000542.2902 | 2114603.4223 | 37.786327487826206 | -122.44189839388599 | (37.7863274878262, -122.441898393886) | |
| 50107 | 50107 | 35980 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 349 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39134 | 6006399.96537133 | 2097866.62265006 | 37.740704214618 | -122.420443871581 | (37.740704214618, -122.420443871581) | ||
| 50329 | 50329 | 34243 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 281 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/1999 12:00:00 AM | 6 | Permit Number 41308 | 6010484.3701 | 2120961.6992 | 37.8043472811285 | -122.40794973039101 | (37.8043472811285, -122.407949730391) | ||
| 51064 | 51064 | 35735 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 322 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | 10 | Permit Number 39010 | 6008978.78205 | 2094418.18322 | 37.7313805342643 | -122.411283723474 | (37.7313805342643, -122.411283723474) | |
| 51282 | 51282 | 38213 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 131 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 10 | Permit Number 40336 | 6011149.37196 | 2092494.3008700002 | 37.7262194527653 | -122.403644234494 | (37.7262194527653, -122.403644234494) | |
| 51581 | 51581 | 177959 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5989083.70402 | 2089208.46347 | 37.71594007136579 | -122.47968288565201 | (37.7159400713658, -122.479682885652) | ||||
| 51876 | 51876 | 68063 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2646 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 15 | Permit Number 31800 | 6000346.74993 | 2118212.45676 | 37.7962258078186 | -122.442834164881 | (37.7962258078186, -122.442834164881) | ||
| 51889 | 51889 | 177940 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989427.62768 | 2089128.0215200002 | 37.7157391708956 | -122.478488258642 | (37.7157391708956, -122.478488258642) | ||||
| 51960 | 51960 | 83691 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 201 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 8 | 6004196.42852 | 2092337.1873 | 37.725397205294705 | -122.427669003321 | (37.7253972052947, -122.427669003321) | ||
| 51984 | 51984 | 47234 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 327 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 5 | Permit Number 45177 | 6005796.76676 | 2092182.16383 | 37.725061938938296 | -122.422125764794 | (37.7250619389383, -122.422125764794) | |
| 52027 | 52027 | 79191 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1750 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 10 | 6011751.02985 | 2092731.7740599997 | 37.7269050958844 | -122.401581006276 | (37.7269050958844, -122.401581006276) | ||
| 52134 | 52134 | 45597 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1770 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2001 12:00:00 AM | 7 | Permit Number 44332 | 5985361.4044 | 2103173.351 | 37.7540670019119 | -122.493577094797 | (37.7540670019119, -122.493577094797) | |
| 52483 | 52483 | 50498 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 924 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 6 | Permit Number 47135 | 6002542.62317 | 2088276.7856400001 | 37.714154557357396 | -122.433096072852 | (37.7141545573574, -122.433096072852) | |
| 52664 | 52664 | 75651 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 594 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1993 12:00:00 AM | 7 | 5990000.19108 | 2111343.54291 | 37.7767704107746 | -122.47813253045 | (37.7767704107746, -122.47813253045) | ||
| 52939 | 52939 | 177917 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989687.39355 | 2089722.5642099997 | 37.717386715401204 | -122.477633830752 | (37.7173867154012, -122.477633830752) | ||||
| 52965 | 52965 | 43154 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 175 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | 3 | Permit Number 45749 | 6006162.31236 | 2093033.7149099999 | 37.72742072396429 | -122.42092254204901 | (37.7274207239643, -122.420922542049) | |
| 53000 | 53000 | 131837 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 5999265.5562 | 2116805.62915 | 37.792301334578795 | -122.446474040467 | (37.7923013345788, -122.446474040467) | ||||
| 53827 | 53827 | 38527 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3460 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 40509 | 5999255.30311 | 2120731.11254 | 37.80307907709621 | -122.44679209919201 | (37.8030790770962, -122.446792099192) | |||
| 54043 | 54043 | 42969 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1150 Bacon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 11 | Permit Number 42856 | 6007967.99482 | 2092048.35205 | 37.7248167450851 | -122.41461057472799 | (37.7248167450851, -122.414610574728) | |
| 54755 | 54755 | 71633 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 666 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 5 | 5983841.90754 | 2111286.39703 | 37.7762541180901 | -122.49943131186501 | (37.7762541180901, -122.499431311865) | ||
| 55578 | 55578 | 107482 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6011457.97806 | 2119852.64786 | 37.801356557918794 | -122.404502345126 | (37.8013565579188, -122.404502345126) | ||||
| 55643 | 55643 | 107485 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6011457.45538 | 2119866.47345 | 37.8013944904094 | -122.40450512760401 | (37.8013944904094, -122.404505127604) | ||||
| 55778 | 55778 | 31100 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 23 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 9 | Permit Number 34830 | 6000065.10853 | 2093953.30855 | 37.729600144630496 | -122.44206650716801 | (37.7296001446305, -122.442066507168) | |
| 55984 | 55984 | 194132 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 46 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015356.8182 | 2102444.39788 | 37.7537745112003 | -122.389793884481 | (37.7537745112003, -122.389793884481) | ||||
| 56677 | 56677 | 131833 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2325 Lyon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5999254.62224 | 2116910.03669 | 37.7925873855434 | -122.44651938697399 | (37.7925873855434, -122.446519386974) | ||||
| 56980 | 56980 | 42624 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1838 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42682 | 6004413.9764 | 2115198.364 | 37.788180906101 | -122.42854577347201 | (37.788180906101, -122.428545773472) | |
| 57119 | 57119 | 30836 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 115 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/2004 12:00:00 AM | 2 | Permit Number 34685 | 6005037.93149 | 2099286.8892099997 | 37.744527093756396 | -122.425254310132 | (37.7445270937564, -122.425254310132) | |
| 57370 | 57370 | 177965 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1703 San Jose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6001599.27369 | 2094156.6391200002 | 37.7302457535263 | -122.43677729835699 | (37.7302457535263, -122.436777298357) | ||||
| 57533 | 57533 | 194133 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 47 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015360.93697 | 2102437.8741900004 | 37.7537568269303 | -122.38977918508199 | (37.7537568269303, -122.389779185082) | ||||
| 57589 | 57589 | 64167 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 500 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | 1 | Permit Number 774327 | 5992846.00253 | 2111993.1861900003 | 37.77871893161171 | -122.468335378215 | (37.7787189316117, -122.468335378215) |
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");