Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 83145 | 83145 | 118340 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 1 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006507.0 | 2110162.0 | 37.774470501260296 | -122.42094653529199 | (37.7744705012603, -122.420946535292) | ||||
| 121990 | 121990 | 118341 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 1 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006507.0 | 2110162.0 | 37.774470501260296 | -122.42094653529199 | (37.7744705012603, -122.420946535292) | ||||
| 97792 | 97792 | 89263 | Section 143 8 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775142 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | |
| 80528 | 80528 | 108822 | Section 143 8 | Acer buergeranum :: Trident Maple 120 | 101x FREMONT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6013648.6 | 2115847.1 | 37.7904804500674 | -122.396640813258 | (37.7904804500674, -122.396640813258) | ||||
| 87984 | 87984 | 108821 | Section 143 8 | Acer buergeranum :: Trident Maple 120 | 101x FREMONT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2015 12:00:00 AM | 3 | 5x5 | Permit Number 774616 | 6013648.6 | 2115847.1 | 37.7904804500674 | -122.396640813258 | (37.7904804500674, -122.396640813258) | |
| 145351 | 145351 | 108823 | Section 143 8 | Acer buergeranum :: Trident Maple 120 | 101x FREMONT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6013648.6 | 2115847.1 | 37.7904804500674 | -122.396640813258 | (37.7904804500674, -122.396640813258) | ||||
| 50489 | 50489 | 108536 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 1036X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009831.243980001 | 2112235.16984 | 37.780349758914795 | -122.40959364419399 | (37.7803497589148, -122.409593644194) | ||||
| 29879 | 29879 | 97159 | Section 143 8 | Schinus molle :: California Pepper 138 | 1079 Le Conte Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012757.6057400005 | 2089814.3813 | 37.7189506418481 | -122.397896712286 | (37.7189506418481, -122.397896712286) | ||
| 72331 | 72331 | 97157 | Section 143 8 | Schinus molle :: California Pepper 138 | 1079 Le Conte Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 2 | Permit Number 768080 | 6012734.70575 | 2089832.2191 | 37.7189983454895 | -122.397977119771 | (37.7189983454895, -122.397977119771) | ||
| 73660 | 73660 | 97156 | Section 143 8 | Schinus molle :: California Pepper 138 | 1079 Le Conte Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012721.62132 | 2089840.20593 | 37.7190195469812 | -122.39802290784401 | (37.7190195469812, -122.398022907844) | ||
| 132132 | 132132 | 97154 | Section 143 8 | Schinus molle :: California Pepper 138 | 1079 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 4 | Permit Number 768080 | 6012676.26956 | 2089874.1029 | 37.7191100952408 | -122.398182049174 | (37.7191100952408, -122.398182049174) | ||
| 149702 | 149702 | 97155 | Section 143 8 | Schinus molle :: California Pepper 138 | 1079 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012703.24235 | 2089857.9517299999 | 37.719067249734294 | -122.398087681509 | (37.7190672497343, -122.398087681509) | ||
| 181154 | 181154 | 97158 | Section 143 8 | Schinus molle :: California Pepper 138 | 1079 Le Conte Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012744.23117 | 2089823.98249 | 37.7189762599209 | -122.39794361640101 | (37.7189762599209, -122.397943616401) | ||
| 81444 | 81444 | 101926 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1099X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 3x3 | Permit Number 769132 | 6007639.0 | 2116135.7 | 37.790936579280896 | -122.417454166812 | (37.7909365792809, -122.417454166812) | ||
| 143550 | 143550 | 101925 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1099X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 3x3 | Permit Number 769132 | 6007639.0 | 2116135.7 | 37.790936579280896 | -122.417454166812 | (37.7909365792809, -122.417454166812) | ||
| 144056 | 144056 | 101924 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1099X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 3x3 | Permit Number 769132 | 6007639.0 | 2116135.7 | 37.790936579280896 | -122.417454166812 | (37.7909365792809, -122.417454166812) | ||
| 84197 | 84197 | 113998 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 1110 SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2015 12:00:00 AM | 3 | 3x3 | 6007591.0 | 2103152.0 | 37.75528371898589 | -122.41670005245301 | (37.7552837189859, -122.416700052453) | ||
| 121912 | 121912 | 111085 | Section 143 8 | Acer japonicum :: Japanese Maple 183 | 117 Manchester St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/20/2015 12:00:00 AM | 3 | Permit Number 774000 | 6008295.8 | 2099262.4 | 37.744643365507706 | -122.413987490618 | (37.7446433655077, -122.413987490618) | ||
| 83777 | 83777 | 103097 | Section 143 8 | Fagus sylvatica 'Red Obelisk' :: Red Obelisk Beech 478 | 1199X Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3x3 | Permit Number 768649 | 6008392.3 | 2117900.9 | 37.7958257402639 | -122.41497276422399 | (37.7958257402639, -122.414972764224) | ||
| 11899 | 11899 | 113090 | Section 143 8 | Pyrus calleryana :: Ornamental Pear 9 | 1213 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6008675.52728 | 2094042.6087200001 | 37.7303322746045 | -122.41230559972999 | (37.7303322746045, -122.41230559973) | ||
| 81380 | 81380 | 112795 | Section 143 8 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1235 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2015 12:00:00 AM | 3x3 | 5983624.1 | 2106731.7 | 37.763735444165796 | -122.49984801640899 | (37.7637354441658, -122.499848016409) | |||
| 108143 | 108143 | 110651 | Section 143 8 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 127 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5999845.0 | 2108967.0 | 37.770811558248 | -122.44390571748998 | (37.770811558248, -122.44390571749) | |||
| 88908 | 88908 | 107533 | Section 143 8 | Tree(s) :: 17 | 130 MATEO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774373 | 6003821.3 | 2096389.2 | 37.7365018950939 | -122.429254591879 | (37.7365018950939, -122.429254591879) | |
| 71351 | 71351 | 101919 | Section 143 8 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 9 | 3x3 | Permit Number 769132 | 6007497.406219999 | 2116101.25633 | 37.7908340376155 | -122.417941633898 | (37.7908340376155, -122.417941633898) | |
| 115319 | 115319 | 101923 | Section 143 8 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1401X California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 3x3 | Permit Number 769132 | 6007402.7 | 2116063.9 | 37.790726135860204 | -122.418266664095 | (37.7907261358602, -122.418266664095) | ||
| 154640 | 154640 | 101920 | Section 143 8 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 13 | 3x3 | Permit Number 769132 | 6007536.5156 | 2116104.21807 | 37.79084437080729 | -122.41780652694901 | (37.7908443708073, -122.417806526949) | |
| 159429 | 159429 | 101921 | Section 143 8 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769132 | 6007574.87115 | 2116111.37594 | 37.7908661829645 | -122.41767432572901 | (37.7908661829645, -122.417674325729) | |
| 185806 | 185806 | 101922 | Section 143 8 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769132 | 6007599.52227 | 2116115.67925 | 37.7908793859256 | -122.417589338874 | (37.7908793859256, -122.417589338874) | |
| 64007 | 64007 | 102480 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 1456 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768914 | 6004877.03101 | 2120232.9115400002 | 37.80203068792579 | -122.427302455863 | (37.8020306879258, -122.427302455863) | |
| 33388 | 33388 | 103092 | Section 143 8 | Fagus sylvatica :: European Beech 250 | 1540 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008422.05981 | 2117808.6375599997 | 37.7955740826282 | -122.41486325634399 | (37.7955740826282, -122.414863256344) | |
| 42795 | 42795 | 103093 | Section 143 8 | Fagus sylvatica :: European Beech 250 | 1540 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008420.39916 | 2117820.52002 | 37.79560661561779 | -122.41486984389401 | (37.7956066156178, -122.414869843894) | |
| 62948 | 62948 | 103091 | Section 143 8 | Fagus sylvatica :: European Beech 250 | 1540 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008424.20559 | 2117797.21945 | 37.7955428518875 | -122.414855023041 | (37.7955428518875, -122.414855023041) | |
| 149863 | 149863 | 103095 | Section 143 8 | Fagus sylvatica :: European Beech 250 | 1540 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008416.42419 | 2117851.09099 | 37.7956903325975 | -122.414885762773 | (37.7956903325975, -122.414885762773) | |
| 160143 | 160143 | 103094 | Section 143 8 | Fagus sylvatica :: European Beech 250 | 1540 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008418.50881 | 2117836.67229 | 37.7956508595435 | -122.414877528601 | (37.7956508595435, -122.414877528601) | |
| 176988 | 176988 | 103096 | Section 143 8 | Fagus sylvatica :: European Beech 250 | 1540 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008414.12252 | 2117870.41106 | 37.795743251405504 | -122.414895095058 | (37.7957432514055, -122.414895095058) | |
| 97621 | 97621 | 98306 | Section 143 8 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Terrace Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993776.0 | 2096639.0 | 37.7366139805049 | -122.46400331489299 | (37.7366139805049, -122.464003314893) | ||||||
| 98791 | 98791 | 111204 | Section 143 8 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 CLIPPER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2015 12:00:00 AM | 3 | 3x3 | 6004024.0 | 2101044.0 | 37.7492943788142 | -122.428885525131 | (37.7492943788142, -122.428885525131) | ||
| 114269 | 114269 | 111632 | Section 143 8 | Tree(s) :: 17 | 1758 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774682 | 5985071.0 | 2103231.6 | 37.7542099449347 | -122.49458566251002 | (37.7542099449347, -122.49458566251) | |
| 53719 | 53719 | 98437 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 1840 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2012 12:00:00 AM | 4 | 4x12 | Permit Number 768068 | 6005870.33263 | 2116931.58044 | 37.7930221942694 | -122.423630300016 | (37.7930221942694, -122.423630300016) | |
| 151907 | 151907 | 111321 | Section 143 8 | Acacia melanoxylon :: Blackwood Acacia 5 | 1X Peabody St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6010185.8855099995 | 2087316.24933 | 37.7119477217782 | -122.406610237293 | (37.7119477217782, -122.406610237293) | ||||
| 93245 | 93245 | 112892 | Section 143 8 | Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 216 | 1X WEBSTER ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6004219.0 | 2108568.0 | 37.769964530341895 | -122.428747509741 | (37.7699645303419, -122.428747509741) | ||||
| 98492 | 98492 | 112891 | Section 143 8 | Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 216 | 1X WEBSTER ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6004219.0 | 2108568.0 | 37.769964530341895 | -122.428747509741 | (37.7699645303419, -122.428747509741) | ||||
| 98030 | 98030 | 118337 | Section 143 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006507.0 | 2110162.0 | 37.774470501260296 | -122.42094653529199 | (37.7744705012603, -122.420946535292) | ||||
| 108721 | 108721 | 118336 | Section 143 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006507.0 | 2110162.0 | 37.774470501260296 | -122.42094653529199 | (37.7744705012603, -122.420946535292) | ||||
| 115517 | 115517 | 118338 | Section 143 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006507.0 | 2110162.0 | 37.774470501260296 | -122.42094653529199 | (37.7744705012603, -122.420946535292) | ||||
| 138904 | 138904 | 118339 | Section 143 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006507.0 | 2110162.0 | 37.774470501260296 | -122.42094653529199 | (37.7744705012603, -122.420946535292) | ||||
| 3768 | 3768 | 228283 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3773 | 3773 | 228285 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3775 | 3775 | 228281 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3776 | 3776 | 228280 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3780 | 3780 | 228286 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3781 | 3781 | 228284 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3791 | 3791 | 228279 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3795 | 3795 | 228282 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 18918 | 18918 | 109119 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
| 82999 | 82999 | 109123 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
| 93411 | 93411 | 109120 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
| 93779 | 93779 | 109124 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
| 100550 | 100550 | 109117 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
| 104643 | 104643 | 109122 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
| 125094 | 125094 | 109115 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
| 125268 | 125268 | 109121 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
| 126955 | 126955 | 109116 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
| 140060 | 140060 | 109118 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
| 99592 | 99592 | 112755 | Section 143 8 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2038 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | 3x3 | 5989157.5 | 2111303.8 | 37.7766123371313 | -122.481044705999 | (37.7766123371313, -122.481044705999) | |||
| 144968 | 144968 | 17872 | Section 143 8 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2148 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/21/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53638 | 6003654.7045158 | 2115269.5781823 | 37.788333445178104 | -122.43117780902399 | (37.7883334451781, -122.431177809024) |
| 175584 | 175584 | 96402 | Section 143 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2160 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2011 12:00:00 AM | 1 | 2x3 | 5985141.5215 | 2100472.7854 | 37.746639122425606 | -122.494138462065 | (37.7466391224256, -122.494138462065) | ||
| 84595 | 84595 | 102523 | Section 143 8 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2013 12:00:00 AM | 3X3 | Permit Number 769544 | 5992300.8 | 2100554.8 | 37.7472806432819 | -122.46938861272601 | (37.7472806432819, -122.469388612726) | ||
| 18623 | 18623 | 117138 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 84121 | 84121 | 117143 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 95513 | 95513 | 117140 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 103897 | 103897 | 117136 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 109812 | 109812 | 117145 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 111043 | 111043 | 117137 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 112757 | 112757 | 117142 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 116617 | 116617 | 117139 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 123153 | 123153 | 117141 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 139017 | 139017 | 117144 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 44012 | 44012 | 114160 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 2250 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002777.5161 | 2117854.22202 | 37.7953804657925 | -122.43439760046499 | (37.7953804657925, -122.434397600465) | |
| 62298 | 62298 | 114159 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 2250 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002793.85496 | 2117859.65506 | 37.795396310934294 | -122.434341453993 | (37.7953963109343, -122.434341453993) | |
| 87817 | 87817 | 112830 | Section 143 8 | Pittosporum undulatum :: Victorian Box 26 | 2265 MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2015 12:00:00 AM | 3 | 3x3 | 6006944.0 | 2105170.0 | 37.760788269780996 | -122.41908070679399 | (37.760788269781, -122.419080706794) | ||
| 13395 | 13395 | 110744 | Section 143 8 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 2300x Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010545.16814 | 2106015.79361 | 37.76331276399971 | -122.406685416098 | (37.7633127639997, -122.406685416098) | ||
| 13873 | 13873 | 110741 | Section 143 8 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 2300x Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010604.54028 | 2106019.5636299998 | 37.7633264372932 | -122.40648033199498 | (37.7633264372932, -122.406480331995) | ||
| 13959 | 13959 | 110743 | Section 143 8 | Cercis occidentalis :: Western Redbud 246 | 2300x Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010565.192009999 | 2106016.80838 | 37.7633166706365 | -122.406616231274 | (37.7633166706365, -122.406616231274) | ||
| 14294 | 14294 | 110746 | Section 143 8 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 2300x Mariposa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010517.260009999 | 2106013.51672 | 37.7633049506856 | -122.406781781161 | (37.7633049506856, -122.406781781161) | ||
| 15363 | 15363 | 110742 | Section 143 8 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 2300x Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010595.22782 | 2106018.33058 | 37.7633225306396 | -122.40651245401101 | (37.7633225306396, -122.406512454011) | ||
| 16786 | 16786 | 110745 | Section 143 8 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 2300x Mariposa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010533.01376 | 2106015.32988 | 37.763310810661295 | -122.406727421634 | (37.7633108106613, -122.406727421634) | ||
| 112556 | 112556 | 112627 | Section 143 8 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2385 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002100.0 | 2114635.0 | 37.78650283124671 | -122.436511387034 | (37.7865028312467, -122.436511387034) | ||||
| 79684 | 79684 | 107964 | Section 143 8 | Platanus x hispanica :: Sycamore: London Plane 15 | 2401x SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770079 | 6001096.0 | 2116670.0 | 37.792033311180504 | -122.440130949989 | (37.7920333111805, -122.440130949989) | |
| 8965 | 8965 | 107967 | Section 143 8 | Platanus x hispanica :: Sycamore: London Plane 15 | 2405x Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770079 | 6001240.6892800005 | 2116684.58018 | 37.792081580751294 | -122.439631370586 | (37.7920815807513, -122.439631370586) | |
| 108448 | 108448 | 85460 | Section 143 8 | Tree(s) :: 17 | 245x Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006128.0 | 2107603.0 | 37.7674227286224 | -122.422075738783 | (37.7674227286224, -122.422075738783) | |
| 111923 | 111923 | 85461 | Section 143 8 | Tree(s) :: 17 | 245x Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006128.0 | 2107603.0 | 37.7674227286224 | -122.422075738783 | (37.7674227286224, -122.422075738783) | |
| 116308 | 116308 | 85459 | Section 143 8 | Tree(s) :: 17 | 245x Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006128.0 | 2107603.0 | 37.7674227286224 | -122.422075738783 | (37.7674227286224, -122.422075738783) | |
| 1138 | 1138 | 44040 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 2504 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2012 12:00:00 AM | 3 | Permit Number 769379 | 6002104.9323 | 2116736.7445400003 | 37.7922739619269 | -122.436644820121 | (37.7922739619269, -122.436644820121) | ||
| 1723 | 1723 | 112197 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2570 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2015 12:00:00 AM | 3 | 3x3 | 6001886.22681 | 2116705.46829 | 37.792175654341605 | -122.43739930364599 | (37.7921756543416, -122.437399303646) | ||
| 102547 | 102547 | 112688 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 259 BRIGHT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2015 12:00:00 AM | 3 | 5x4 | 5993720.0 | 2088919.0 | 37.71541351482001 | -122.46363680360001 | (37.71541351482, -122.4636368036) | ||
| 51328 | 51328 | 109935 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011302.0 | 2112245.5 | 37.780460426865396 | -122.404506314811 | (37.7804604268654, -122.404506314811) | |
| 77766 | 77766 | 100060 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011435.0 | 2112345.0 | 37.7807410625565 | -122.404053207068 | (37.7807410625565, -122.404053207068) | |
| 97598 | 97598 | 100059 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011435.0 | 2112345.0 | 37.7807410625565 | -122.404053207068 | (37.7807410625565, -122.404053207068) | |
| 112863 | 112863 | 32654 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011426.1069309 | 2112339.71009356 | 37.7807260408269 | -122.40408360027 | (37.7807260408269, -122.40408360027) |
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");