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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |
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) | |
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) | |
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) | ||
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) | |
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) | ||
9707 | 9707 | 110499 | Section 143 8 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900X JESSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6007667.0 | 2110717.0 | 37.7760597176113 | -122.416973193872 | (37.7760597176113, -122.416973193872) | |||
152399 | 152399 | 98280 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 66 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | 2 | Permit Number 58649 | 6008148.55904 | 2110896.00071 | 37.776578287595 | -122.41532002290899 | (37.776578287595, -122.415320022909) | ||
170162 | 170162 | 98281 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 66 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008165.69574 | 2110879.12634 | 37.776532917703705 | -122.41525954711399 | (37.7765329177037, -122.415259547114) | ||
167151 | 167151 | 98282 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 66 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008179.30272 | 2110863.5043200003 | 37.776490788067896 | -122.415211370411 | (37.7764907880679, -122.415211370411) | ||
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) | ||
16141 | 16141 | 116230 | Section 143 8 | Pittosporum undulatum :: Victorian Box 26 | 49 Grace St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2014 12:00:00 AM | 3 | 2.5x4 | Permit Number 770598 | 6008318.164030001 | 2110322.45497 | 37.7750129977898 | -122.414692709823 | (37.7750129977898, -122.414692709823) | |
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) | ||
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) | |
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) | |
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) | |
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) | |
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) | |
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) | ||
82994 | 82994 | 113610 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009000.0 | 2105472.0 | 37.7617330585457 | -122.41199123457899 | (37.7617330585457, -122.411991234579) | |||
89850 | 89850 | 113613 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009000.0 | 2105472.0 | 37.7617330585457 | -122.41199123457899 | (37.7617330585457, -122.411991234579) | |||
98123 | 98123 | 113611 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009000.0 | 2105472.0 | 37.7617330585457 | -122.41199123457899 | (37.7617330585457, -122.411991234579) | |||
145031 | 145031 | 113612 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009000.0 | 2105472.0 | 37.7617330585457 | -122.41199123457899 | (37.7617330585457, -122.411991234579) | |||
102243 | 102243 | 111193 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 890x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774267 | 6009115.0 | 2096842.0 | 37.738043451743295 | -122.41098392432899 | (37.7380434517433, -122.410983924329) | |
103008 | 103008 | 111194 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 890x JARBOE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 3x3 | Permit Number 774267 | 6009115.0 | 2096842.0 | 37.738043451743295 | -122.41098392432899 | (37.7380434517433, -122.410983924329) | ||
107818 | 107818 | 111195 | Section 143 8 | Corymbia ficifolia :: Red Flowering Gum 60 | 890x JARBOE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x12 | 6009115.0 | 2096842.0 | 37.738043451743295 | -122.41098392432899 | (37.7380434517433, -122.410983924329) | |||
88189 | 88189 | 113605 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
97450 | 97450 | 113603 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
106970 | 106970 | 113608 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
116007 | 116007 | 113607 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
122514 | 122514 | 113604 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
123789 | 123789 | 113606 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
144368 | 144368 | 113609 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
88888 | 88888 | 113602 | Section 143 8 | Olea europaea :: Olive Tree 41 | 550 FLORIDA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233.0 | 2105681.0 | 37.762319994612604 | -122.411200142124 | (37.7623199946126, -122.411200142124) | ||
90793 | 90793 | 113600 | Section 143 8 | Olea europaea :: Olive Tree 41 | 550 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773946 | 6009233.0 | 2105681.0 | 37.762319994612604 | -122.411200142124 | (37.7623199946126, -122.411200142124) | |
122830 | 122830 | 113601 | Section 143 8 | Olea europaea :: Olive Tree 41 | 550 FLORIDA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233.0 | 2105681.0 | 37.762319994612604 | -122.411200142124 | (37.7623199946126, -122.411200142124) | ||
94702 | 94702 | 112368 | Section 143 8 | Prunus cerasifera :: Cherry Plum 16 | 550 Jessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2015 12:00:00 AM | 3 | 3x3 | 6009683.8 | 2112475.6 | 37.7810016601266 | -122.410120702727 | (37.7810016601266, -122.410120702727) | ||
96009 | 96009 | 112370 | Section 143 8 | Prunus cerasifera :: Cherry Plum 16 | 550 Jessie St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2015 12:00:00 AM | 3 | 3x3 | 6009683.8 | 2112475.6 | 37.7810016601266 | -122.410120702727 | (37.7810016601266, -122.410120702727) | ||
99018 | 99018 | 112371 | Section 143 8 | Prunus cerasifera :: Cherry Plum 16 | 550 Jessie St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2015 12:00:00 AM | 3 | 3x3 | 6009683.8 | 2112475.6 | 37.7810016601266 | -122.410120702727 | (37.7810016601266, -122.410120702727) | ||
123283 | 123283 | 112369 | Section 143 8 | Prunus cerasifera :: Cherry Plum 16 | 550 Jessie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2015 12:00:00 AM | 3 | 3x3 | 6009683.8 | 2112475.6 | 37.7810016601266 | -122.410120702727 | (37.7810016601266, -122.410120702727) | ||
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) | ||||
12209 | 12209 | 113082 | Section 143 8 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 414 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6010030.65327 | 2092539.3572 | 37.726280612054204 | -122.40751477809499 | (37.7262806120542, -122.407514778095) | ||
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) | ||||
120424 | 120424 | 72837 | Section 143 8 | Gleditsia triacanthos :: Honey Locust 67 | 2624 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770762 | 6010331.33933918 | 2104014.11752446 | 37.7578046465334 | -122.407283867997 | (37.7578046465334, -122.407283867997) | |
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | |
124592 | 124592 | 109936 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 5 | 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) | |
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) | |
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) | |
18013 | 18013 | 109951 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
77374 | 77374 | 109950 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
82275 | 82275 | 109948 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
92212 | 92212 | 109944 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
93248 | 93248 | 109945 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
93713 | 93713 | 109942 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
100892 | 100892 | 109943 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
104982 | 104982 | 109946 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
113160 | 113160 | 109947 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
144711 | 144711 | 109941 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
145620 | 145620 | 109949 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
15752 | 15752 | 117149 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011929.155180001 | 2097982.19203 | 37.7413315821976 | -122.40133403893499 | (37.7413315821976, -122.401334038935) | |
111849 | 111849 | 117150 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 TOLAND ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950.0 | 2098029.0 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | |
15089 | 15089 | 117148 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011961.8463 | 2098027.63913 | 37.7414581941431 | -122.401224196662 | (37.7414581941431, -122.401224196662) | |
15833 | 15833 | 117147 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011972.25416 | 2098042.58697 | 37.7414998183769 | -122.40118925978001 | (37.7414998183769, -122.40118925978) | |
13845 | 13845 | 117146 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011982.52405 | 2098055.99364 | 37.741537203178 | -122.401154691646 | (37.741537203178, -122.401154691646) | |
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) | |
77847 | 77847 | 103466 | Section 143 8 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 890X Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012118.0 | 2118740.5 | 37.7983397318906 | -122.402140129264 | (37.7983397318906, -122.402140129264) | |||||
80836 | 80836 | 103465 | Section 143 8 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 890X Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012118.0 | 2118740.5 | 37.7983397318906 | -122.402140129264 | (37.7983397318906, -122.402140129264) | |||||
116665 | 116665 | 103467 | Section 143 8 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 890X Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012118.0 | 2118740.5 | 37.7983397318906 | -122.402140129264 | (37.7983397318906, -122.402140129264) | |||||
126578 | 126578 | 103469 | Section 143 8 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 799X Battery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012272.7 | 2118721.6 | 37.798296470544706 | -122.401603488036 | (37.7982964705447, -122.401603488036) | |||||
128798 | 128798 | 116471 | Section 143 8 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 882 Carolina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | 6012399.9 | 2103853.8 | 37.757480004392 | -122.40011862143601 | (37.757480004392, -122.400118621436) | |||
148004 | 148004 | 103468 | Section 143 8 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 799X Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 6012421.85953 | 2118740.3114 | 37.798356169556605 | -122.401088663417 | (37.7983561695566, -122.401088663417) | ||||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) |
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");