Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 467 | 467 | 85277 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 801 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49566 | ||||||||
| 1621 | 1621 | 88501 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1599 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51438 | 6015120.9647 | 2094333.0532 | 37.7314893544439 | -122.390042929541 | (37.7314893544439, -122.390042929541) | |
| 2212 | 2212 | 204345 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 44 Southwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 13 | Width 3ft | Permit Number 46258 | 5995599.60309 | 2092472.80372 | 37.7252795425123 | -122.45739705673 | (37.7252795425123, -122.45739705673) | |
| 2752 | 2752 | 204285 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 130 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2016 12:00:00 AM | 0 | Width 4ft | Permit Number 778704 | 5994440.258090001 | 2105345.9021900003 | 37.7605591918785 | -122.462338019278 | (37.7605591918785, -122.462338019278) | |
| 3364 | 3364 | 188226 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 3 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 6 | Width 3ft | Permit Number 37286 | 6013575.41694 | 2105253.06849 | 37.7613875637091 | -122.396151246903 | (37.7613875637091, -122.396151246903) | |
| 3371 | 3371 | 188225 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 2 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 6 | Width 3ft | Permit Number 37286 | 6013591.2999599995 | 2105254.0413599997 | 37.7613911187249 | -122.396096381957 | (37.7613911187249, -122.396096381957) | |
| 3379 | 3379 | 188227 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 4 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 5 | Width 3ft | Permit Number 37286 | 6013561.10942 | 2105252.84027 | 37.7613861409778 | -122.39620071499901 | (37.7613861409778, -122.396200714999) | |
| 3441 | 3441 | 32703 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 890 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37106 | 6007477.85623 | 2114415.95786 | 37.7862055211206 | -122.417889760126 | (37.7862055211206, -122.417889760126) |
| 6342 | 6342 | 30510 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2774 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 6x7 | Permit Number 778747 | 5999768.8918 | 2117782.75925 | 37.7950130117898 | -122.444802762862 | (37.7950130117898, -122.444802762862) | |
| 6578 | 6578 | 9618 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2000 12:00:00 AM | 7 | 3X3 | 6002831.8444 | 2112032.7875 | 37.7793993714118 | -122.43379332982599 | (37.7793993714118, -122.433793329826) | ||
| 10426 | 10426 | 108779 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005562.18075 | 2088048.73923 | 37.7136992126121 | -122.422643108799 | (37.7136992126121, -122.422643108799) |
| 10629 | 10629 | 108781 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005591.90568 | 2088038.18998 | 37.7136719236049 | -122.422539619323 | (37.7136719236049, -122.422539619323) |
| 12330 | 12330 | 108783 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005623.18894 | 2088028.7554099998 | 37.7136477830893 | -122.42243082291901 | (37.7136477830893, -122.422430822919) |
| 17785 | 17785 | 32763 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1754 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778589 | 6009301.89278 | 2099228.78566 | 37.7446075228294 | -122.410506232583 | (37.7446075228294, -122.410506232583) | |
| 19782 | 19782 | 67081 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 345 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1995 12:00:00 AM | Permit Number 30479 | 6006832.91402463 | 2097113.31465906 | 37.7386601871907 | -122.418893482297 | (37.7386601871907, -122.418893482297) | ||
| 20905 | 20905 | 46594 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2138 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2002 12:00:00 AM | Permit Number 44723 | 5991340.38326484 | 2100857.00751715 | 37.748054878059705 | -122.472731661639 | (37.7480548780597, -122.472731661639) | |||
| 22943 | 22943 | 115613 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 22952 | 22952 | 115614 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 24672 | 24672 | 61260 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 445 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1995 12:00:00 AM | Permit Number 21147 | 6007898.64601891 | 2096796.82911577 | 37.737851139099 | -122.41518627959299 | (37.737851139099, -122.415186279593) | ||
| 27026 | 27026 | 52825 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 323 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2006 12:00:00 AM | 2 | Permit Number 48850 | 5987743.22888 | 2113770.24482 | 37.7833021825875 | -122.486118118549 | (37.7833021825875, -122.486118118549) | ||
| 27077 | 27077 | 50163 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2127WASHINGTON Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2003 12:00:00 AM | 4 | Permit Number 46876 | 6000341.02119 | 2116095.30485 | 37.7904123382987 | -122.442701892589 | (37.7904123382987, -122.442701892589) | ||
| 28594 | 28594 | 35262 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2231 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 10 | Permit Number 38747 | 6006326.183230001 | 2118540.89021 | 37.797466675306104 | -122.42216741420499 | (37.7974666753061, -122.422167414205) | |
| 32937 | 32937 | 40207 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 543 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 11 | Permit Number 41389 | 5982528.29213 | 2112062.1562099997 | 37.7783069675702 | -122.504032865431 | (37.7783069675702, -122.504032865431) | |
| 34514 | 34514 | 34711 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 814 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38367 | 5981711.82187 | 2110159.4624900003 | 37.7730346823923 | -122.50671613138701 | (37.7730346823923, -122.506716131387) | |
| 35132 | 35132 | 40200 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 826 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 7 | Permit Number 41382 | 5983263.94969 | 2110159.75947 | 37.773126771678704 | -122.501347236887 | (37.7731267716787, -122.501347236887) | |
| 35164 | 35164 | 33237 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2571 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1996 12:00:00 AM | 4 | Permit Number 37422 | 5988602.8399 | 2097831.1801 | 37.7395879019735 | -122.481976246635 | (37.7395879019735, -122.481976246635) | |
| 36627 | 36627 | 40215 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 483 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 9 | Permit Number 41394 | 5981890.02626 | 2112509.7593099996 | 37.7794983994124 | -122.506274024618 | (37.7794983994124, -122.506274024618) | |
| 36654 | 36654 | 56830 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1790 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | 7 | 3x3 | Permit Number 772657 | 5987850.7365 | 2103123.4557 | 37.7540753121952 | -122.484964830141 | (37.7540753121952, -122.484964830141) | |
| 40240 | 40240 | 39382 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 442 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 15 | Permit Number 40924 | 6011028.8433300005 | 2112194.85786 | 37.7803061060932 | -122.40544772953699 | (37.7803061060932, -122.405447729537) | ||
| 43319 | 43319 | 103461 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 666 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2013 12:00:00 AM | 0 | 3x3 | Permit Number 770172 | 6005398.7 | 2111581.8 | 37.77830639149621 | -122.42488139317899 | (37.7783063914962, -122.424881393179) | |
| 43684 | 43684 | 67023 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2111 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 2 | Permit Number 768246 | 6000360.43065 | 2115965.11174 | 37.79005596844821 | -122.44262538545 | (37.7900559684482, -122.44262538545) | ||
| 44423 | 44423 | 38052 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2721 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 11 | Permit Number 40249 | 6000449.1918 | 2114423.1814 | 37.7858272875297 | -122.442207546183 | (37.7858272875297, -122.442207546183) | |
| 45990 | 45990 | 34666 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3047 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1997 12:00:00 AM | 3 | 5.5x6 | Permit Number 38514 | 6003371.82856 | 2118846.08663 | 37.7981375866326 | -122.432412059279 | (37.7981375866326, -122.432412059279) |
| 46211 | 46211 | 38855 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1546 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 7 | Permit Number 40682 | 5989647.796 | 2104818.2381 | 37.7588332407039 | -122.478874180945 | (37.7588332407039, -122.478874180945) | |
| 47440 | 47440 | 66426 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 340 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29567 | 6008601.026441 | 2097160.55912441 | 37.7388893105844 | -122.41278350726101 | (37.7388893105844, -122.412783507261) | ||
| 52040 | 52040 | 48559 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1407 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2002 12:00:00 AM | 5 | Permit Number 45875 | 5999686.8778 | 2113772.6173 | 37.7839975324947 | -122.444798150334 | (37.7839975324947, -122.444798150334) | ||
| 53493 | 53493 | 33102 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 375 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37343 | 6011697.96502 | 2119046.16805 | 37.799155568835 | -122.40361510367701 | (37.799155568835, -122.403615103677) | |
| 53637 | 53637 | 33253 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2514 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 4 | Permit Number 37431 | 5987084.6825 | 2098140.6264 | 37.7403491484322 | -122.487248033346 | (37.7403491484322, -122.487248033346) | |
| 56659 | 56659 | 39383 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 442 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 11 | Permit Number 40924 | 6011035.938999999 | 2112201.64162 | 37.7803251294514 | -122.405423660089 | (37.7803251294514, -122.405423660089) | |
| 57759 | 57759 | 52679 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 6 | Permit Number 48754 | 5984569.7272 | 2111052.9985 | 37.77565594760279 | -122.49689639188101 | (37.7756559476028, -122.496896391881) | ||
| 58138 | 58138 | 33322 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3115 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 9 | Permit Number 37465 | 6004626.67946 | 2120295.23032 | 37.8021876375982 | -122.428173235217 | (37.8021876375982, -122.428173235217) | |
| 62221 | 62221 | 80798 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2255 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2009 12:00:00 AM | 0 | 3x13 | Permit Number 52014 | 5981702.96222667 | 2099742.73288113 | 37.74443279244029 | -122.505974318528 | (37.7444327924403, -122.505974318528) | |
| 63444 | 63444 | 34710 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 810 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38366 | 5981708.71753 | 2110203.70271 | 37.7731559703061 | -122.50673015139499 | (37.7731559703061, -122.506730151395) | |
| 63509 | 63509 | 53408 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 732 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/2002 12:00:00 AM | 2 | Permit Number 6307 | 6011253.43466 | 2104717.71315 | 37.7597881275257 | -122.404144378963 | (37.7597881275257, -122.404144378963) | |
| 66942 | 66942 | 38846 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1470 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 7 | Permit Number 40676 | 5989942.607000001 | 2105373.0458 | 37.7603737086332 | -122.477895157521 | (37.7603737086332, -122.477895157521) | |
| 69260 | 69260 | 31285 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2582 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2015 12:00:00 AM | 1 | Permit Number 776543 | 5991130.3489 | 2097847.73429 | 37.7397800286191 | -122.473238505753 | (37.7397800286191, -122.473238505753) | |
| 70713 | 70713 | 94867 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 585 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53938 | 6013855.010369999 | 2104400.1239 | 37.7590611164982 | -122.39512449630199 | (37.7590611164982, -122.395124496302) | |
| 71231 | 71231 | 32716 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 930 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37111 | 6008229.60793 | 2115679.81731 | 37.7897180499914 | -122.41537839431801 | (37.7897180499914, -122.415378394318) |
| 73722 | 73722 | 34655 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2020 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38333 | 5988552.6311 | 2105140.1389 | 37.7596534386529 | -122.48268531251499 | (37.7596534386529, -122.482685312515) | |
| 77556 | 77556 | 34600 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3200 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38292 | 5999389.38393742 | 2116031.83359368 | 37.7901837678549 | -122.445989915265 | (37.7901837678549, -122.445989915265) | ||
| 77765 | 77765 | 53374 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 116 Swiss Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1989 12:00:00 AM | Permit Number 28184 | 6001229.12577462 | 2096449.65021028 | 37.736520788133795 | -122.438221149135 | (37.7365207881338, -122.438221149135) | ||
| 78485 | 78485 | 68039 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1765 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1993 12:00:00 AM | Permit Number 31776 | 5993091.33572917 | 2103469.18343171 | 37.7553284439634 | -122.46686685356701 | (37.7553284439634, -122.466866853567) | ||
| 79343 | 79343 | 34456 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 999x UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38200 | 6008246.0 | 2119227.0 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | ||
| 79682 | 79682 | 52242 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48413 | 6013439.04799366 | 2103846.48755141 | 37.7575178110179 | -122.396524293417 | (37.7575178110179, -122.396524293417) | |||
| 80281 | 80281 | 91063 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 70 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2008 12:00:00 AM | 3x3 | Permit Number 51971 | 6008176.0 | 2108000.0 | 37.768628094650204 | -122.415020067856 | (37.7686280946502, -122.415020067856) | ||
| 80403 | 80403 | 52245 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48413 | 6013439.04799366 | 2103846.48755141 | 37.7575178110179 | -122.396524293417 | (37.7575178110179, -122.396524293417) | |||
| 80429 | 80429 | 66424 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 331 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29564 | 6008656.02628353 | 2097191.94254108 | 37.7389785695141 | -122.41259556059099 | (37.7389785695141, -122.412595560591) | ||
| 80630 | 80630 | 46428 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2436St Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2002 12:00:00 AM | Permit Number 44648 | 5981449.87635789 | 2098495.5570397 | 37.740993493681 | -122.506756936313 | (37.740993493681, -122.506756936313) | |||
| 80749 | 80749 | 42426 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 620 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42577 | 5997972.86705556 | 2095014.83999466 | 37.7323954036406 | -122.449376022575 | (37.7323954036406, -122.449376022575) | ||
| 80899 | 80899 | 51734 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 834 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2005 12:00:00 AM | Permit Number 48014 | 6012117.32852637 | 2098230.03082929 | 37.7420225917964 | -122.40070080435301 | (37.7420225917964, -122.400700804353) | |||
| 81742 | 81742 | 52727 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 10@ MARKET Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2006 12:00:00 AM | Permit Number 48783 | 5999674.65009068 | 2101508.9182706 | 37.7503237940053 | -122.443959012396 | (37.7503237940053, -122.443959012396) | |||
| 81835 | 81835 | 40103 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2701 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1999 12:00:00 AM | Permit Number 41327 | 5987231.374238401 | 2111151.67144351 | 37.7760824787808 | -122.48769646963801 | (37.7760824787808, -122.487696469638) | |||
| 82779 | 82779 | 40744 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 40 Cedro Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41719 | 5992588.05334035 | 2093209.10678957 | 37.7271278125133 | -122.46786112953899 | (37.7271278125133, -122.467861129539) | ||
| 83020 | 83020 | 115619 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 83329 | 83329 | 44367 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 845 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2001 12:00:00 AM | Permit Number 43736 | 6002495.55510721 | 2088615.90278678 | 37.7150830283913 | -122.43328297514601 | (37.7150830283913, -122.433282975146) | |||
| 84436 | 84436 | 40478 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41556 | 5996299.47149878 | 2089867.48348074 | 37.7181661228901 | -122.454789544621 | (37.7181661228901, -122.454789544621) | ||
| 84456 | 84456 | 35589 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 59 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42715 | 6007013.60126505 | 2099209.55425367 | 37.744426166063 | -122.418417345369 | (37.744426166063, -122.418417345369) | ||
| 85829 | 85829 | 40748 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 Cedro Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41720 | 5992465.74581598 | 2093166.10361938 | 37.7270026730351 | -122.46828081444599 | (37.7270026730351, -122.468280814446) | ||
| 85890 | 85890 | 40764 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 26 Entrada Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41729 | 5992399.49150569 | 2092389.70166559 | 37.7248670377879 | -122.46845338960199 | (37.7248670377879, -122.468453389602) | ||
| 85928 | 85928 | 87198 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3984 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2008 12:00:00 AM | 3 | 2.5x3 | Permit Number 50214 | 5995710.95001 | 2114863.89205 | 37.786766180939395 | -122.45863234603901 | (37.7867661809394, -122.458632346039) | |
| 87174 | 87174 | 34601 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3200 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38292 | 5999389.38393742 | 2116031.83359368 | 37.7901837678549 | -122.445989915265 | (37.7901837678549, -122.445989915265) | ||
| 88076 | 88076 | 35089 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1483 FUNSTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38630 | 5992081.0 | 2105361.0 | 37.7604645121053 | -122.470498641045 | (37.7604645121053, -122.470498641045) | ||
| 88109 | 88109 | 64811 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 714 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49823 | 6001902.40841481 | 2099743.14733631 | 37.745602232257 | -122.436128941313 | (37.745602232257, -122.436128941313) | ||
| 88330 | 88330 | 50887 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2155 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | 2 | 4x5 | Permit Number 47396 | 5991292.02661422 | 2100750.87371172 | 37.7477606627783 | -122.47289113742501 | (37.7477606627783, -122.472891137425) |
| 89002 | 89002 | 119272 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1101 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2016 12:00:00 AM | 3 | 3x3 | 6009465.43944441 | 2117056.87897214 | 37.793568508665295 | -122.41119983681601 | (37.7935685086653, -122.411199836816) | ||
| 89126 | 89126 | 33051 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 271 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49853 | 6006201.46275008 | 2101595.657532 | 37.7509321104635 | -122.42139497515 | (37.7509321104635, -122.42139497515) | ||
| 91552 | 91552 | 112669 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500x LAIDLEY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003128.0 | 2096056.0 | 37.7355477305103 | -122.43162784146999 | (37.7355477305103, -122.43162784147) | ||||
| 91555 | 91555 | 40476 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41556 | 5996299.47149878 | 2089867.48348074 | 37.7181661228901 | -122.454789544621 | (37.7181661228901, -122.454789544621) | ||
| 91737 | 91737 | 40467 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 113 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41552 | 6007405.69792358 | 2097686.69945555 | 37.7402668106935 | -122.416953676795 | (37.7402668106935, -122.416953676795) | ||
| 94020 | 94020 | 104295 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3665X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999151.92915 | 2121319.46506 | 37.8046886279394 | -122.44719219431002 | (37.8046886279394, -122.44719219431) | ||||
| 94277 | 94277 | 40757 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 De Soto St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41725 | 5993077.65625848 | 2091558.66043318 | 37.722624350413795 | -122.46604871174499 | (37.7226243504138, -122.466048711745) | ||
| 96501 | 96501 | 69421 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 400 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1994 12:00:00 AM | 8 | Permit Number 33526 | 6008905.76984219 | 2106354.06627794 | 37.7641497228891 | -122.41237948925101 | (37.7641497228891, -122.412379489251) | ||
| 97462 | 97462 | 47590 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 246 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45434 | 5987870.09368443 | 2115354.49759594 | 37.7876594816311 | -122.485795537984 | (37.7876594816311, -122.485795537984) | |
| 98497 | 98497 | 34712 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 814 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38367 | 5981714.39581019 | 2110184.94689539 | 37.7731048066849 | -122.50670911846599 | (37.7731048066849, -122.506709118466) | ||
| 98523 | 98523 | 40340 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1646 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | Permit Number 41471 | 5998688.07142674 | 2109026.60811122 | 37.770909165958 | -122.44791183337 | (37.770909165958, -122.44791183337) | |||
| 98616 | 98616 | 104294 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3665X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999151.92915 | 2121319.46506 | 37.8046886279394 | -122.44719219431002 | (37.8046886279394, -122.44719219431) | ||||
| 98918 | 98918 | 69214 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1179 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33265 | 6008096.22978477 | 2101070.94205252 | 37.7495980071801 | -122.41480553750601 | (37.7495980071801, -122.414805537506) | ||
| 99138 | 99138 | 51977 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2350 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2005 12:00:00 AM | Permit Number 48197 | 5983329.08324082 | 2099142.92260776 | 37.7428814621262 | -122.500307281497 | (37.7428814621262, -122.500307281497) | |||
| 100101 | 100101 | 67039 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 4439 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1992 12:00:00 AM | Permit Number 30416 | 6000406.70783191 | 2101659.7908888 | 37.7507797856784 | -122.441438339157 | (37.7507797856784, -122.441438339157) | ||
| 100146 | 100146 | 40768 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 90 Entrada Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41731 | 5992535.95232782 | 2092083.0060810002 | 37.7240328083641 | -122.46795936676901 | (37.7240328083641, -122.467959366769) | ||
| 100357 | 100357 | 66425 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 337 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | 8 | 3x3 | Permit Number 29566 | 6008654.10344933 | 2097170.34560865 | 37.7389191611384 | -122.41260068259399 | (37.7389191611384, -122.412600682594) |
| 100684 | 100684 | 66868 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 980 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 3x3 | Permit Number 30175 | 6007892.40589298 | 2115166.96998046 | 37.7882909386851 | -122.416508740658 | (37.7882909386851, -122.416508740658) | |
| 101198 | 101198 | 53712 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 316 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31809 | 5993068.20232093 | 2103252.30098864 | 37.7547316057452 | -122.46693108886002 | (37.7547316057452, -122.46693108886) | ||
| 102297 | 102297 | 40746 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 Cedro Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41720 | 5992465.74581598 | 2093166.10361938 | 37.7270026730351 | -122.46828081444599 | (37.7270026730351, -122.468280814446) | ||
| 102399 | 102399 | 68058 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1749 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32368 | 5993397.30702034 | 2103583.39285974 | 37.7556596880509 | -122.46581701937299 | (37.7556596880509, -122.465817019373) | ||
| 102496 | 102496 | 33400 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 333 Santa Ana Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41597 | 5992649.0 | 2094625.0 | 37.7310190240744 | -122.46775337202101 | (37.7310190240744, -122.467753372021) | ||
| 102526 | 102526 | 67040 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 4443 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1992 12:00:00 AM | Permit Number 30417 | 6000382.41393306 | 2101658.41146972 | 37.7507746140875 | -122.441522250405 | (37.7507746140875, -122.441522250405) | ||
| 102704 | 102704 | 96293 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 417 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 04/25/2011 12:00:00 AM | Permit Number 57003 | 5995136.0 | 2100316.9 | 37.7467908665237 | -122.45956754031602 | (37.7467908665237, -122.459567540316) | |||
| 105536 | 105536 | 52243 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48413 | 6013439.04799366 | 2103846.48755141 | 37.7575178110179 | -122.396524293417 | (37.7575178110179, -122.396524293417) | |||
| 106352 | 106352 | 46426 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500x LAIDLEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2002 12:00:00 AM | 3x3 | Permit Number 44647 | 6003128.0 | 2096056.0 | 37.7355477305103 | -122.43162784146999 | (37.7355477305103, -122.43162784147) |
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");