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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100086 | 100086 | 113361 | Undocumented 2 | Tree(s) :: 17 | 378 SANCHEZ ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2015 12:00:00 AM | 15 | 3x3 | Permit Number 776225 | 6003537.0 | 2106091.0 | 37.7631246661428 | -122.43092972883301 | (37.7631246661428, -122.430929728833) | |
| 95164 | 95164 | 101950 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 11 | 3x3 | Permit Number 769636 | 6008537.0 | 2110562.0 | 37.775683024565296 | -122.413952655551 | (37.7756830245653, -122.413952655551) | |
| 102013 | 102013 | 101949 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769636 | 6008537.0 | 2110562.0 | 37.775683024565296 | -122.413952655551 | (37.7756830245653, -122.413952655551) | |
| 185344 | 185344 | 101909 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1801 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 1 | 3x3 | Permit Number 56808 | 6000521.0 | 2114812.0 | 37.786898975000206 | -122.44198702889099 | (37.7868989750002, -122.441987028891) | |
| 82339 | 82339 | 97989 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 876 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2011 12:00:00 AM | 3x3 | Permit Number 768167 | 6000897.0 | 2099683.0 | 37.7453799097395 | -122.439601171278 | (37.7453799097395, -122.439601171278) | ||
| 131037 | 131037 | 97978 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767976 | 6008558.536309999 | 2094188.79818 | 37.7307271138572 | -122.412720385963 | (37.7307271138572, -122.412720385963) | |
| 139894 | 139894 | 97957 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2270 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 3x3 | Permit Number 768057 | 6011896.3 | 2098543.4 | 37.7428707065024 | -122.401487073764 | (37.7428707065024, -122.401487073764) | ||
| 146618 | 146618 | 97960 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280X McKinnon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768057 | 6011686.23984 | 2098718.09501 | 37.7433386585668 | -122.40222568708401 | (37.7433386585668, -122.402225687084) | |
| 150833 | 150833 | 97956 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280x McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768057 | 6011739.12667 | 2098678.3172400002 | 37.7432323892731 | -122.40204002115499 | (37.7432323892731, -122.402040021155) | |
| 151131 | 151131 | 97958 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280X McKinnon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768057 | 6011714.55105 | 2098696.24817 | 37.7432802520847 | -122.402126258043 | (37.7432802520847, -122.402126258043) | |
| 151647 | 151647 | 97959 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280X McKinnon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768057 | 6011701.54939 | 2098706.65667 | 37.743308105886506 | -122.40217194628299 | (37.7433081058865, -122.402171946283) | |
| 154807 | 154807 | 97976 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767976 | 6008561.06273 | 2094180.5010099998 | 37.7307044734101 | -122.412711065359 | (37.7307044734101, -122.412711065359) | |
| 176442 | 176442 | 97961 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280X McKinnon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768057 | 6011645.30787 | 2098748.77937 | 37.743420626377294 | -122.402369377168 | (37.7434206263773, -122.402369377168) | |
| 185638 | 185638 | 97974 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 14 | 3x3 | Permit Number 767976 | 6008567.92648 | 2094152.82902 | 37.7306288773042 | -122.412685380727 | (37.7306288773042, -122.412685380727) | |
| 9668 | 9668 | 124721 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 701x York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3x3 | 6009904.0 | 2104980.0 | 37.7604328157288 | -122.408829935053 | (37.7604328157288, -122.408829935053) | |||
| 98672 | 98672 | 124720 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 701x York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3 | 3x3 | 6009904.0 | 2104980.0 | 37.7604328157288 | -122.408829935053 | (37.7604328157288, -122.408829935053) | ||
| 142405 | 142405 | 121587 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1136 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3 | 3x3 | 6012170.0 | 2103110.0 | 37.7554248716487 | -122.400861456416 | (37.7554248716487, -122.400861456416) | ||
| 140451 | 140451 | 75710 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1190 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1993 12:00:00 AM | 12 | 18x3 | 6008645.48606603 | 2101619.0486747 | 37.7511338315754 | -122.412944932355 | (37.7511338315754, -122.412944932355) | ||
| 25537 | 25537 | 71240 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1929 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 19 | 6001514.7914 | 2112836.7931 | 37.781532142896 | -122.43840717979201 | (37.781532142896, -122.438407179792) | ||
| 156324 | 156324 | 77283 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1210 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 16 | 6001986.2323 | 2110871.5472 | 37.7761628769629 | -122.436635509753 | (37.7761628769629, -122.436635509753) | ||
| 178404 | 178404 | 71238 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1215 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 4 | 6001314.2765 | 2112604.1281 | 37.7808818966461 | -122.439084183551 | (37.7808818966461, -122.439084183551) | ||
| 144064 | 144064 | 108205 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1192 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2014 12:00:00 AM | 3 | Permit Number 774208 | 6000914.97169 | 2109351.778 | 37.7719290371123 | -122.440232269589 | (37.7719290371123, -122.440232269589) | ||
| 29927 | 29927 | 83659 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 6 | 6001685.54257 | 2090383.4533900002 | 37.7198903425557 | -122.436209138162 | (37.7198903425557, -122.436209138162) | ||
| 35817 | 35817 | 83433 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 760 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 4 | 6000998.571 | 2089370.50235 | 37.7170699516967 | -122.43851121642099 | (37.7170699516967, -122.438511216421) | ||
| 45157 | 45157 | 83662 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 739 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 8 | 6001858.1049 | 2089640.1660799999 | 37.717859244391796 | -122.43555950477501 | (37.7178592443918, -122.435559504775) | ||
| 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) | ||
| 168792 | 168792 | 83538 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 243 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 5 | 6004140.213830001 | 2089715.70651 | 37.7181960153187 | -122.427676641269 | (37.7181960153187, -122.427676641269) | ||
| 173811 | 173811 | 83658 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 735 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 1 | 6001863.16562 | 2089646.8314200002 | 37.717877833364 | -122.435542488698 | (37.717877833364, -122.435542488698) | ||
| 176737 | 176737 | 82969 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 243 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 8 | 6002566.256709999 | 2092290.10285 | 37.7251755754681 | -122.43330098875 | (37.7251755754681, -122.43330098875) | ||
| 10039 | 10039 | 106657 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 706 20TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2016 12:00:00 AM | 10 | 3x3 | 5989753.9107099995 | 2110247.9151 | 37.773747820615704 | -122.47890432357 | (37.7737478206157, -122.47890432357) | ||
| 103625 | 103625 | 121549 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 53 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2016 12:00:00 AM | 3 | 3x3 | 6002689.0 | 2105575.0 | 37.7616597701015 | -122.433825788836 | (37.7616597701015, -122.433825788836) | ||
| 110863 | 110863 | 121421 | Undocumented 2 | Tree(s) :: 17 | 301 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2016 12:00:00 AM | 3 | Permit Number 779128 | 6001229.40575975 | 2096509.00524046 | 37.736683779153104 | -122.438224431893 | (37.7366837791531, -122.438224431893) | |
| 127923 | 127923 | 81254 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 706 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2016 12:00:00 AM | 3 | 3x3 | 5989768.37779 | 2110442.38687 | 37.7742826266156 | -122.478868506685 | (37.7742826266156, -122.478868506685) | |
| 105114 | 105114 | 113094 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 5725 DIAMOND HEIGHTS BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 3x3 | Permit Number 776952 | 6000738.0 | 2097078.0 | 37.7382181444182 | -122.43996421610001 | (37.7382181444182, -122.4399642161) | ||
| 145993 | 145993 | 106859 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 946 RHODE ISLAND ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 14 | 3x3 | Permit Number 773008 | 6011839.2 | 2104029.4 | 37.7579308843014 | -122.402070102772 | (37.7579308843014, -122.402070102772) | ||
| 83799 | 83799 | 108198 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 808 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2014 12:00:00 AM | 3 | 2x2 | Permit Number 774168 | 5999486.009 | 2095579.2645400001 | 37.7340316201973 | -122.444185299389 | (37.7340316201973, -122.444185299389) | |
| 10539 | 10539 | 97421 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 84 Liebig St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2011 12:00:00 AM | 3 | 6x15 | Permit Number 768371 | 5995500.38132 | 2086681.7504200002 | 37.709372977163504 | -122.457321298761 | (37.7093729771635, -122.457321298761) | |
| 74568 | 74568 | 97937 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768327 | 6009817.5879999995 | 2121415.668 | 37.8055564131765 | -122.410289267199 | (37.8055564131765, -122.410289267199) | |
| 27453 | 27453 | 71972 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 776 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 13 | 6009259.7893900005 | 2119456.28205 | 37.8001451441351 | -122.41208105430599 | (37.8001451441351, -122.412081054306) | ||
| 58907 | 58907 | 74852 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1660 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 8 | 6009221.87688 | 2119018.0672 | 37.7989397873109 | -122.412181258567 | (37.7989397873109, -122.412181258567) | ||
| 71745 | 71745 | 74989 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1660 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 9 | 6009226.90425 | 2118994.74178 | 37.798876023557 | -122.41216221273199 | (37.798876023557, -122.412162212732) | ||
| 133555 | 133555 | 73615 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1821 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 6 | 6009537.2097 | 2119931.0165 | 37.801464208964205 | -122.411154621412 | (37.8014642089642, -122.411154621412) | ||
| 146660 | 146660 | 73675 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 510 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 11 | 6010458.2549 | 2119616.6906 | 37.80065275675229 | -122.407945198153 | (37.8006527567523, -122.407945198153) | ||
| 161662 | 161662 | 71973 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1932 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 6 | 6009096.9457 | 2119928.0152 | 37.8014312681268 | -122.41267792569799 | (37.8014312681268, -122.412677925698) | ||
| 177975 | 177975 | 72303 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 665 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 7 | 6009725.8283 | 2120167.3092 | 37.8021235862289 | -122.410518608839 | (37.8021235862289, -122.410518608839) | ||
| 118627 | 118627 | 109096 | Undocumented 2 | Tree(s) :: 17 | 194 FARALLONES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779352 | 5995118.3 | 2088431.1 | 37.71415432875 | -122.458768388595 | (37.71415432875, -122.458768388595) | |
| 118131 | 118131 | 95223 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 299 on 16th St Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774713 | 6004880.0 | 2106610.0 | 37.764625720621794 | -122.426321695151 | (37.7646257206218, -122.426321695151) | |
| 142497 | 142497 | 95221 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 299 on 16th St Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 774713 | 6004880.0 | 2106610.0 | 37.764625720621794 | -122.426321695151 | (37.7646257206218, -122.426321695151) | ||
| 5221 | 5221 | 72132 | Undocumented 2 | Tree(s) :: 17 | 950 Wisconsin St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 12/01/2011 12:00:00 AM | 3 | 3x3 | Permit Number 780813 | 6012748.1522699995 | 2103075.8524599997 | 37.755363341648795 | -122.398859619973 | (37.7553633416488, -122.398859619973) |
| 115250 | 115250 | 122559 | Undocumented 2 | Tree(s) :: 17 | 3903 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779290 | 5996054.0 | 2115495.0 | 37.78851874399879 | -122.45749115913999 | (37.7885187439988, -122.45749115914) | |
| 86311 | 86311 | 101001 | Undocumented 2 | Tree(s) :: 17 | 500X Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/2012 12:00:00 AM | Permit Number 769389 | 6008398.5 | 2096033.1 | 37.7357821841588 | -122.413404038925 | (37.7357821841588, -122.413404038925) | ||
| 72835 | 72835 | 101867 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769242 | 6012649.1 | 2113074.7 | 37.7828124097662 | -122.399904277178 | (37.7828124097662, -122.399904277178) | |
| 115900 | 115900 | 121400 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3998X 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779042 | 6003912.0 | 2101337.0 | 37.750092548464295 | -122.429293713772 | (37.7500925484643, -122.429293713772) | |
| 119077 | 119077 | 121401 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3998X 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779042 | 6003912.0 | 2101337.0 | 37.750092548464295 | -122.429293713772 | (37.7500925484643, -122.429293713772) | |
| 145933 | 145933 | 101232 | Undocumented 2 | Tree(s) :: 17 | 3575 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779254 | 5997770.0 | 2115107.0 | 37.7875518165957 | -122.451526095937 | (37.7875518165957, -122.451526095937) | |
| 99637 | 99637 | 100135 | Undocumented 2 | Tree(s) :: 17 | 155 05th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/27/2012 12:00:00 AM | 9 | Permit Number 769351 | 6011029.6 | 2112857.4 | 37.782125333955705 | -122.40549178692301 | (37.7821253339557, -122.405491786923) | ||
| 116056 | 116056 | 98012 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 4515 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 8 | 3x3 | Permit Number 770790 | 6001417.0 | 2104061.0 | 37.7574304316811 | -122.43811665528 | (37.7574304316811, -122.43811665528) | |
| 120420 | 120420 | 113553 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700 TAYLOR ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 3x3 | 6009263.0 | 2115423.0 | 37.7890709188275 | -122.411784791395 | (37.7890709188275, -122.411784791395) | |||
| 129132 | 129132 | 114513 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 418 BELVEDERE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 6x7 | 5998550.0 | 2106753.0 | 37.7646585215155 | -122.44822568086201 | (37.7646585215155, -122.448225680862) | |||
| 5802 | 5802 | 122541 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2233 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779046 | 6001437.2497 | 2113869.2014 | 37.7843624618515 | -122.438749438347 | (37.7843624618515, -122.438749438347) | |
| 5856 | 5856 | 120901 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2032 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778866 | 6001448.95372 | 2115547.55562 | 37.7889714571097 | -122.438829258958 | (37.7889714571097, -122.438829258958) | |
| 16678 | 16678 | 101870 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779151 | 6012595.5925 | 2113052.7427 | 37.782749136894296 | -122.40008784930299 | (37.7827491368943, -122.400087849303) | |
| 80396 | 80396 | 121580 | Undocumented 2 | Tree(s) :: 17 | 3595 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 5x6 | Permit Number 779170 | 6004440.0 | 2103609.0 | 37.7563608063483 | -122.427629711642 | (37.7563608063483, -122.427629711642) | |
| 80925 | 80925 | 121237 | Undocumented 2 | Tree(s) :: 17 | 3512 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779014 | 6004884.0 | 2103735.0 | 37.7567318772846 | -122.42610317358 | (37.7567318772846, -122.42610317358) | |
| 121340 | 121340 | 121567 | Undocumented 2 | Tree(s) :: 17 | 499X Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779059 | 5998083.0 | 2114873.0 | 37.7869272334312 | -122.450426308155 | (37.7869272334312, -122.450426308155) | |
| 40209 | 40209 | 80574 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 619 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2002 12:00:00 AM | 3 | 5988121.26409 | 2111709.35839 | 37.777665594619 | -122.484659059603 | (37.777665594619, -122.484659059603) | ||
| 13608 | 13608 | 116924 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015542.44799 | 2102559.60008 | 37.754101124282606 | -122.389159972153 | (37.7541011242826, -122.389159972153) | ||
| 14030 | 14030 | 116926 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015510.15678 | 2102558.1918900004 | 37.7540954675573 | -122.389271545654 | (37.7540954675573, -122.389271545654) | ||
| 14067 | 14067 | 116930 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015446.80292 | 2102557.08015 | 37.7540889024884 | -122.389490562948 | (37.7540889024884, -122.389490562948) | ||
| 14797 | 14797 | 116925 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015524.58204 | 2102559.09611 | 37.7540987500629 | -122.389221722302 | (37.7540987500629, -122.389221722302) | ||
| 15260 | 15260 | 116923 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015559.42731 | 2102560.4848599997 | 37.7541044949445 | -122.389101314797 | (37.7541044949445, -122.389101314797) | ||
| 15315 | 15315 | 116934 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1275 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015367.98495 | 2102613.01131 | 37.7542381072096 | -122.38976704331999 | (37.7542381072096, -122.38976704332) | ||
| 15996 | 15996 | 116935 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1275 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015368.355880001 | 2102637.50716 | 37.7543053881926 | -122.389767471397 | (37.7543053881926, -122.389767471397) | ||
| 16017 | 16017 | 116931 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015431.47773 | 2102556.1938099996 | 37.754085619065705 | -122.38954349973301 | (37.7540856190657, -122.389543499733) | ||
| 16512 | 16512 | 116928 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015476.82973 | 2102557.66932 | 37.754092185022394 | -122.38938676319599 | (37.7540921850224, -122.389386763196) | ||
| 16552 | 16552 | 116933 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1275 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015369.147890001 | 2102590.92817 | 37.7541775360745 | -122.38976147920799 | (37.7541775360745, -122.389761479208) | ||
| 16611 | 16611 | 116932 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015412.75293 | 2102554.60022 | 37.7540802051572 | -122.38960814389799 | (37.7540802051572, -122.389608143898) | ||
| 16727 | 16727 | 116927 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015494.24319 | 2102557.91546 | 37.7540938262957 | -122.38932655988899 | (37.7540938262957, -122.389326559889) | ||
| 16892 | 16892 | 116929 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015461.93425 | 2102556.8401200003 | 37.7540890823654 | -122.38943821792401 | (37.7540890823654, -122.389438217924) | ||
| 58943 | 58943 | 116918 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1390x TENNESSEE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 60911 | 60911 | 121797 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 310 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779075 | 6004274.0 | 2096577.0 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | |
| 104006 | 104006 | 121798 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 310 Miguel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6004274.0 | 2096577.0 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | ||
| 108702 | 108702 | 116920 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1390x TENNESSEE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 109779 | 109779 | 116919 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1390x TENNESSEE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 109843 | 109843 | 121799 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 310 Miguel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779075 | 6004274.0 | 2096577.0 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | |
| 110363 | 110363 | 116922 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 900x 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 121953 | 121953 | 116921 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1390x TENNESSEE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 125251 | 125251 | 121800 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 310 Miguel St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6004274.0 | 2096577.0 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | ||
| 127868 | 127868 | 110833 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 533 PARNASSUS AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 5995513.0 | 2106277.0 | 37.7631774598891 | -122.458695326495 | (37.7631774598891, -122.458695326495) | ||
| 57978 | 57978 | 71993 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 3449 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1986 12:00:00 AM | 20 | 5984766.04316 | 2113148.2827 | 37.7814204950816 | -122.496371935666 | (37.7814204950816, -122.496371935666) | ||
| 130627 | 130627 | 71994 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 38th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1986 12:00:00 AM | 4 | 5984087.82115 | 2113103.7785400003 | 37.7812585454782 | -122.49871492967699 | (37.7812585454782, -122.498714929677) | ||
| 168124 | 168124 | 71995 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 400 38th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1986 12:00:00 AM | 3 | 5984088.02561 | 2113084.3081799997 | 37.7812050975324 | -122.498712783587 | (37.7812050975324, -122.498712783587) | ||
| 104713 | 104713 | 121604 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 132 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779127 | 6002211.0 | 2096230.0 | 37.735973474651296 | -122.43481069394899 | (37.7359734746513, -122.434810693949) | |
| 119888 | 119888 | 107369 | Undocumented 2 | Tree(s) :: 17 | 1990X LAGUNA ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/21/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774385 | 6004403.0 | 2115650.0 | 37.789420363641895 | -122.42861595649099 | (37.7894203636419, -122.428615956491) | |
| 30752 | 30752 | 72905 | Undocumented 2 | Quercus robur :: English Oak 358 | 130 Alpha St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1998 12:00:00 AM | 30 | 6010919.95523 | 2088121.9 | 37.7142009182997 | -122.404129735303 | (37.7142009182997, -122.404129735303) | ||
| 34809 | 34809 | 74063 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 130 Alpha St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1998 12:00:00 AM | 12 | 6010946.7362 | 2088147.19919 | 37.714271881112296 | -122.404038948741 | (37.7142718811123, -122.404038948741) | ||
| 54742 | 54742 | 72881 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 130 Alpha St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1998 12:00:00 AM | 8 | 6010899.06821 | 2088108.5640200002 | 37.714163133309896 | -122.40420099129601 | (37.7141631333099, -122.404200991296) | ||
| 65838 | 65838 | 74275 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 130 Alpha St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1998 12:00:00 AM | 12 | 6010944.700130001 | 2088154.7138 | 37.714292400951 | -122.40404651475401 | (37.714292400951, -122.404046514754) | ||
| 142759 | 142759 | 73831 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 102 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1998 12:00:00 AM | 19 | 6010808.25129 | 2088026.1904400003 | 37.713931877121 | -122.404509096323 | (37.713931877121, -122.404509096323) | ||
| 5559 | 5559 | 98004 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1908 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2015 12:00:00 AM | 14 | 5x5 | Permit Number 775450 | 6003753.55269 | 2119031.9849799997 | 37.79866965343071 | -122.43110445762301 | (37.7986696534307, -122.431104457623) |
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");