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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1069 | 1069 | 80004 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 881 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2017 12:00:00 AM | 3 | Permit Number 779791 | 5982299.17664 | 2109781.12407 | 37.772030443625795 | -122.504656395048 | (37.7720304436258, -122.504656395048) | |
| 116949 | 116949 | 41673 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 69 Deming St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 778874 | 5999228.79012001 | 2105180.00479751 | 37.7603782511364 | -122.445764801622 | (37.7603782511364, -122.445764801622) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 115871 | 115871 | 112754 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 60 Sharon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | 3x3 | Permit Number 776174 | 6003822.5 | 2106803.2 | 37.765096368537705 | -122.429993087375 | (37.7650963685377, -122.429993087375) | ||
| 129129 | 129129 | 55856 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | Permit Number 776174 | 6003842.74750128 | 2106799.59707315 | 37.7650876224345 | -122.42992279922 | (37.7650876224345, -122.42992279922) | |||
| 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) |
| 85096 | 85096 | 107303 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2432 Diamond St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2014 12:00:00 AM | 2x3 | Permit Number 773619 | 6001987.23202 | 2097099.10599 | 37.738347131542895 | -122.43564650704599 | (37.7383471315429, -122.435646507046) | |||
| 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) | |
| 135182 | 135182 | 105522 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1790 27TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | 5 | 3x3 | Permit Number 772657 | 5987869.5 | 2103119.5 | 37.7540655437983 | -122.484899652045 | (37.7540655437983, -122.484899652045) | |
| 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) | ||
| 111075 | 111075 | 96908 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 390X 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2011 12:00:00 AM | 4x4 | Permit Number 767974 | 6003983.7 | 2100148.0 | 37.746831890001104 | -122.428961010832 | (37.7468318900011, -122.428961010832) | ||
| 172175 | 172175 | 95903 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1986 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767605 | 5989131.1765 | 2101822.5426 | 37.7505778487932 | -122.480441591554 | (37.7505778487932, -122.480441591554) |
| 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) | |
| 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) | |||
| 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) | |
| 111437 | 111437 | 94133 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 315 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53516 | 5999195.3 | 2090879.5 | 37.7211105719006 | -122.44485264784599 | (37.7211105719006, -122.444852647846) | ||
| 174350 | 174350 | 93937 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 427 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53392 | 5990582.69863 | 2112452.2597 | 37.7798484361675 | -122.476198485506 | (37.7798484361675, -122.476198485506) | |
| 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) | |
| 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) | ||
| 139835 | 139835 | 88996 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2924 Steiner St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2008 12:00:00 AM | 3x3 | Permit Number 51745 | 6002052.0 | 2118164.0 | 37.7961898267193 | -122.436930189765 | (37.7961898267193, -122.436930189765) | |||
| 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) | |
| 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) | |
| 159103 | 159103 | 79179 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1859 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 1 | 3x3 | Permit Number 50037 | 5983166.9149 | 2102491.0694 | 37.7520650271804 | -122.50111558741199 | (37.7520650271804, -122.501115587412) | |
| 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) | ||
| 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) | ||
| 108912 | 108912 | 53551 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 116 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2007 12:00:00 AM | 3x3 | Permit Number 49757 | 5997037.05674347 | 2089332.93754069 | 37.7167406655365 | -122.452201492855 | (37.7167406655365, -122.452201492855) | ||
| 117650 | 117650 | 86774 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 573 Connecticut St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2007 12:00:00 AM | 3x3 | Permit Number 49746 | 6013291.0 | 2104402.0 | 37.7590348868282 | -122.39707525671601 | (37.7590348868282, -122.397075256716) | |||
| 114230 | 114230 | 86759 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 120349 | 120349 | 86760 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 125822 | 125822 | 86761 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 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 | ||||||||
| 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) | ||
| 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) | |||
| 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) | ||
| 154225 | 154225 | 52681 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 6 | Permit Number 48754 | 5984542.32395 | 2111051.13386 | 37.7756492220711 | -122.49699104738 | (37.7756492220711, -122.49699104738) | ||
| 157132 | 157132 | 52677 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 7 | Permit Number 48754 | 5984472.12802 | 2111009.36044 | 37.7755304106086 | -122.49723078434401 | (37.7755304106086, -122.497230784344) | ||
| 158678 | 158678 | 52682 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 5 | Permit Number 48754 | 5984583.26235 | 2111053.32202 | 37.7756576289957 | -122.496849595053 | (37.7756576289957, -122.496849595053) | ||
| 159448 | 159448 | 52683 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 5 | Permit Number 48754 | 5984474.1727 | 2110997.72398 | 37.7754985800658 | -122.49722285223801 | (37.7754985800658, -122.497222852238) | ||
| 174075 | 174075 | 52673 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 7 | Permit Number 48754 | 5984474.785130001 | 2110952.04196 | 37.7753731862643 | -122.497217360825 | (37.7753731862643, -122.497217360825) | ||
| 180730 | 180730 | 52680 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 6 | Permit Number 48754 | 5984555.73131 | 2111052.6848299997 | 37.7756542662383 | -122.496944783224 | (37.7756542662383, -122.496944783224) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 140544 | 140544 | 52244 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 3 | 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) | |||
| 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) | |||
| 110888 | 110888 | 51881 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 438 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/2005 12:00:00 AM | Permit Number 48097 | 5989393.54128853 | 2112360.26063999 | 37.7795268026551 | -122.48030552365499 | (37.7795268026551, -122.480305523655) | ||
| 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) | |||
| 126094 | 126094 | 51733 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 834 Toland St | 1 | 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) | |||
| 160448 | 160448 | 32341 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 120 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2005 12:00:00 AM | 6 | Permit Number 47986 | 6010882.28946 | 2093426.3819099998 | 37.728763829978796 | -122.404633115548 | (37.7287638299788, -122.404633115548) | ||
| 113972 | 113972 | 51581 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1639 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2005 12:00:00 AM | 3 | Permit Number 47874 | 6006611.817858701 | 2116483.82002415 | 37.791834582054896 | -122.421032908654 | (37.7918345820549, -122.421032908654) | ||
| 156074 | 156074 | 51042 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2031 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 4 | Permit Number 47515 | 5990334.5392 | 2101532.5464 | 37.749851453790605 | -122.476259131856 | (37.7498514537906, -122.476259131856) | ||
| 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) |
| 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) | ||
| 185444 | 185444 | 34477 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1818 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 11 | Permit Number 46532 | 6008722.614159999 | 2119125.18072 | 37.7992058679054 | -122.413916459984 | (37.7992058679054, -122.413916459984) | |
| 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) | |
| 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) | ||
| 158553 | 158553 | 47683 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 730 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | 8 | Permit Number 45474 | 5991337.42645 | 2110428.10245 | 37.7743343910633 | -122.473439892203 | (37.7743343910633, -122.473439892203) | |
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 144090 | 144090 | 46425 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500x LAIDLEY ST | 2 | 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) | ||
| 128532 | 128532 | 34618 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2295 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/2002 12:00:00 AM | Permit Number 44529 | 6002289.17159211 | 2107042.12264547 | 37.7656654347214 | -122.435313579001 | (37.7656654347214, -122.435313579001) | ||
| 127305 | 127305 | 45839 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 562 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2001 12:00:00 AM | Permit Number 44449 | 5984130.8408017 | 2112009.83198879 | 37.778257408954794 | -122.498485276772 | (37.7782574089548, -122.498485276772) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 111162 | 111162 | 42427 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 620 Joost Ave | 1 | 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) | ||
| 112462 | 112462 | 42266 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1771 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42507 | 5987792.97769873 | 2103248.83655487 | 37.754416209778206 | -122.48517377049801 | (37.7544162097782, -122.485173770498) | ||
| 186861 | 186861 | 41550 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2271 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2000 12:00:00 AM | 5 | Permit Number 42072 | 6003891.05094 | 2116280.93986 | 37.7911237785009 | -122.430432278226 | (37.7911237785009, -122.430432278226) | ||
| 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) | ||
| 108527 | 108527 | 40769 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 90 Entrada Ct | 2 | 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) | ||
| 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) | ||
| 140857 | 140857 | 40765 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 26 Entrada Ct | 2 | 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) | ||
| 119584 | 119584 | 40760 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 125 De Soto St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2000 12:00:00 AM | Permit Number 41726 | 5993244.02089224 | 2091981.15429222 | 37.723794012147 | -122.46550430814301 | (37.723794012147, -122.465504308143) | ||
| 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) | ||
| 111989 | 111989 | 40758 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 De Soto St | 3 | 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) | ||
| 112091 | 112091 | 40756 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 De Soto St | 1 | 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) | ||
| 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) | ||
| 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) | ||
| 120601 | 120601 | 40749 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 Cedro Ave | 4 | 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) | ||
| 145154 | 145154 | 40747 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 Cedro Ave | 2 | 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) | ||
| 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) | ||
| 124326 | 124326 | 40743 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 40 Cedro Ave | 2 | 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) | ||
| 140597 | 140597 | 40745 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 40 Cedro Ave | 4 | 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) | ||
| 143861 | 143861 | 40742 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 40 Cedro Ave | 1 | 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) | ||
| 130136 | 130136 | 40664 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 37 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 11 | Permit Number 41655 | 6003638.4352 | 2093754.51209 | 37.7292572834764 | -122.429698976444 | (37.7292572834764, -122.429698976444) | |
| 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) | ||
| 110052 | 110052 | 40479 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 543 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41557 | 5996251.58042917 | 2089868.37749114 | 37.718165830416005 | -122.45495514714099 | (37.718165830416, -122.454955147141) | ||
| 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) | ||
| 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) | ||
| 139268 | 139268 | 40477 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 2 | 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) | ||
| 123269 | 123269 | 40459 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 256 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41544 | 6008229.9197421 | 2097395.17552334 | 37.739512678985896 | -122.414083219638 | (37.7395126789859, -122.414083219638) |
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");