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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134 | 134 | 47510 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 54X Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2017 12:00:00 AM | 3 | 3x3 | Permit Number 45390 | 6003705.560409999 | 2094600.28554 | 37.731583388063 | -122.42952721221901 | (37.731583388063, -122.429527212219) | |
136 | 136 | 213016 | Undocumented 2 | Tree(s) :: 17 | 120 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779661 | 5993626.83548 | 2102594.2327400004 | 37.7529569465285 | -122.4649514087 | (37.7529569465285, -122.4649514087) | |
137 | 137 | 228561 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006199.77605 | 2105468.2728 | 37.7615653191939 | -122.42167583577299 | (37.7615653191939, -122.421675835773) | |||
140 | 140 | 6337 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1916 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001700.9234 | 2112915.307 | 37.7817583075946 | -122.437768878541 | (37.7817583075946, -122.437768878541) | |||
141 | 141 | 832 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1396 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:18:00 PM | 3 | 3X3 | 5981551.7086 | 2105613.8347 | 37.7605442750604 | -122.50693272862101 | (37.7605442750604, -122.506932728621) | ||
142 | 142 | 251241 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2305 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998495.0 | 2111363.0 | 37.777313260379 | -122.44874797929701 | (37.777313260379, -122.448747979297) | |||||
143 | 143 | 18836 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2055 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004953.14987 | 2116100.2629400003 | 37.7906877916676 | -122.426744576702 | (37.7906877916676, -122.426744576702) | |||
144 | 144 | 11598 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4134 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 11:51:00 AM | 3 | 3X3 | 5981663.7126 | 2105589.2786 | 37.760483446414796 | -122.506543543521 | (37.7604834464148, -122.506543543521) | ||
145 | 145 | 111561 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1498x Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779654 | 6011715.78319 | 2101470.3886700002 | 37.7508975116216 | -122.40231700873699 | (37.7508975116216, -122.402317008737) | |
146 | 146 | 97319 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1038 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:52:00 PM | 3 | 3x3 | 5989945.5882 | 2099070.048 | 37.7430675136338 | -122.477424174253 | (37.7430675136338, -122.477424174253) | ||
147 | 147 | 58021 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4026 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:07:00 PM | 3 | Permit Number 16988 | 5983218.6194 | 2106316.5419 | 37.7625717348083 | -122.50121971656999 | (37.7625717348083, -122.50121971657) | ||
148 | 148 | 175046 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 3ft | 5991566.54873 | 2087591.2585200001 | 37.7116435395983 | -122.47098334961399 | (37.7116435395983, -122.470983349614) | |||
149 | 149 | 26071 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 247 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 01:41:00 PM | 3 | 3X3 | 5993990.1569314 | 2088190.8403771 | 37.7134297247264 | -122.46265023824101 | (37.7134297247264, -122.462650238241) | ||
150 | 150 | 11606 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4200x Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 11:54:00 AM | 3 | 3X3 | 5981492.2847 | 2105581.1189 | 37.76045094714279 | -122.507135818078 | (37.7604509471428, -122.507135818078) | ||
151 | 151 | 36617 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
152 | 152 | 24532 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1395 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:21:00 PM | 3 | 3X3 | 5981507.2257 | 2105680.0147 | 37.7607233666377 | -122.50709148147499 | (37.7607233666377, -122.507091481475) | ||
153 | 153 | 5972 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1550 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 8 | 3X3 | 6003044.0843 | 2112751.363 | 37.7813844410266 | -122.43311045884899 | (37.7813844410266, -122.433110458849) | ||
154 | 154 | 830 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1384 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:15:00 PM | 3 | 5.5x6.5 | 5981549.5887 | 2105676.5499 | 37.7607163481902 | -122.506944712409 | (37.7607163481902, -122.506944712409) | ||
155 | 155 | 251225 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Yukon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x2.5 | 6000238.0 | 2104757.0 | 37.7592743544717 | -122.442244057145 | (37.7592743544717, -122.442244057145) | ||||
156 | 156 | 54712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4508 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 11:58:00 AM | 3 | 3x3 | Permit Number 10547 | 5981730.2931 | 2106265.9364 | 37.762345274891 | -122.506363455406 | (37.762345274891, -122.506363455406) | |
157 | 157 | 3193 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3698 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5996969.37189 | 2114704.2549799997 | 37.7864001056199 | -122.454266992435 | (37.7864001056199, -122.454266992435) | |||
158 | 158 | 21682 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1830 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:00:00 AM | 3 | 4x4 | 6003825.2217 | 2114604.0634 | 37.7865157709252 | -122.43054034167 | (37.7865157709252, -122.43054034167) | ||
159 | 159 | 97322 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1055 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:42:00 PM | 3 | 3x3 | 5989910.3078 | 2099001.0945 | 37.7428761380219 | -122.477541124233 | (37.7428761380219, -122.477541124233) | ||
160 | 160 | 175377 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991371.46907 | 2088876.77956 | 37.715161983326794 | -122.471751215951 | (37.7151619833268, -122.471751215951) | |||
161 | 161 | 142720 | Undocumented 2 | :: 54 | 1170 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6007999.4825 | 2121188.7351 | 37.8048312311886 | -122.416565007078 | (37.8048312311886, -122.416565007078) | ||||
162 | 162 | 251231 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 164 Serrano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989598.0 | 2090848.0 | 37.7204716934452 | -122.478025052476 | (37.7204716934452, -122.478025052476) | ||||
163 | 163 | 29943 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 242 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:23:00 PM | 3 | 3x3 | 5994593.32204167 | 2088106.90572275 | 37.7132339790874 | -122.460559423837 | (37.7132339790874, -122.460559423837) | ||
164 | 164 | 97323 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1011 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:25:00 PM | 3 | 3x3 | 5990005.0659 | 2099005.494 | 37.7428937161431 | -122.477213802134 | (37.7428937161431, -122.477213802134) | ||
165 | 165 | 11582 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4000 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 11:49:00 AM | 3 | 3X3 | 5982109.291 | 2105604.0369 | 37.760550193841404 | -122.505003612665 | (37.7605501938414, -122.505003612665) | ||
166 | 166 | 251230 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
167 | 167 | 251232 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
169 | 169 | 251221 | Permitted Site 1 | Tree(s) :: 17 | 2401X Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778039 | ||||||
170 | 170 | 48827 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 435 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | 5 | 3x3 | Permit Number 46051 | 6011929.23024 | 2118387.60951 | 37.79736024144329 | -122.402768502565 | (37.7973602414433, -122.402768502565) | |
172 | 172 | 48332 | Permitted Site 1 | Tree(s) :: 17 | 142 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
173 | 173 | 175044 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80x Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 5991568.948890001 | 2087568.2224599998 | 37.7115804269636 | -122.470973377029 | (37.7115804269636, -122.470973377029) | |||
174 | 174 | 251226 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1 Yukon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13x2.5 | 6000262.0 | 2104839.0 | 37.7595008741196 | -122.442166940047 | (37.7595008741196, -122.442166940047) | ||||
175 | 175 | 17881 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2205 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003346.6048 | 2115178.7939 | 37.7880667103656 | -122.432237297056 | (37.7880667103656, -122.432237297056) | |||
176 | 176 | 24515 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2030 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2016 07:40:00 AM | 3 | 3X3 | 5997710.2902 | 2109583.0289 | 37.772381016672895 | -122.45133412385 | (37.7723810166729, -122.45133412385) | ||
177 | 177 | 97317 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:59:00 PM | 3 | 3x3 | 5990071.4812 | 2099073.5168 | 37.7430843422325 | -122.476989128346 | (37.7430843422325, -122.476989128346) | ||
178 | 178 | 2985 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2253 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6003588.0004 | 2115559.2302 | 37.789124975971106 | -122.431429279776 | (37.7891249759711, -122.431429279776) | |||
179 | 179 | 182083 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:33:00 PM | 3 | Width 0ft | 5989775.2775 | 2098997.3719 | 37.742858080169505 | -122.47800774412599 | (37.7428580801695, -122.478007744126) | ||
180 | 180 | 18700 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100X Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999457.6873699995 | 2119517.78462 | 37.799759164102895 | -122.44600442526199 | (37.7997591641029, -122.446004425262) | |||
181 | 181 | 9914 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1900 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 126 | 3X3 | 6005235.69262 | 2116267.9294 | 37.7911641319684 | -122.42577893234899 | (37.7911641319684, -122.425778932349) | |||
182 | 182 | 93463 | DPW Maintained 3 | Prunus x 'Amanogawa' :: Flowering Cherry 57 | 1739 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 01:05:00 PM | 3 | 3x3 | 5987772.1588 | 2098929.0107 | 37.7425539090053 | -122.48492886712098 | (37.7425539090053, -122.484928867121) | ||
183 | 183 | 15429 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2125 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2015 12:00:00 AM | 15 | 4X4 | 6006871.98757 | 2105962.63928 | 37.762960616913205 | -122.41938599878401 | (37.7629606169132, -122.419385998784) | ||
184 | 184 | 138801 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2375 PINE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1997 12:00:00 AM | 2 | Width 0ft | 6002525.8905 | 2115062.7753 | 37.787701584977704 | -122.43506851988899 | (37.7877015849777, -122.435068519889) | ||
185 | 185 | 251243 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 299x Chapman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008953.0 | 2098186.0 | 37.7417246968109 | -122.411638974942 | (37.7417246968109, -122.411638974942) | ||||
186 | 186 | 138359 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 0ft | 6002861.592 | 2114464.6761 | 37.7860784126894 | -122.43386429175101 | (37.7860784126894, -122.433864291751) | |||
187 | 187 | 251248 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 829 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001839.0 | 2095802.0 | 37.7347771581377 | -122.436066227259 | (37.7347771581377, -122.436066227259) | ||||
188 | 188 | 138368 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002679.2262 | 2114443.3671 | 37.786009553218996 | -122.434493703661 | (37.786009553219, -122.434493703661) | |||
189 | 189 | 138807 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002661.6347 | 2115086.2451 | 37.7877737339769 | -122.434600550462 | (37.7877737339769, -122.434600550462) | |||
190 | 190 | 57209 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2898 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 773671 | 6000999.92024 | 2115926.87738 | 37.7899874194288 | -122.440410066565 | (37.7899874194288, -122.440410066565) | ||
191 | 191 | 210495 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | Permit Number 779799 | 5992304.44524 | 2094447.3559700001 | 37.7305113566072 | -122.468931622808 | (37.7305113566072, -122.468931622808) | ||
192 | 192 | 138369 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002665.8461 | 2114439.4026 | 37.78599790817471 | -122.434539711553 | (37.7859979081747, -122.434539711553) | |||
193 | 193 | 6069 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1930 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2015 12:00:00 AM | 3 | 3X3 | 6001175.3543 | 2112495.6639 | 37.7805761758993 | -122.439557004629 | (37.7805761758993, -122.439557004629) | ||
194 | 194 | 138802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002539.8455 | 2115065.9469 | 37.787711085766894 | -122.435020465254 | (37.7877110857669, -122.435020465254) | |||
195 | 195 | 138365 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 0ft | 6002748.6045 | 2114451.296 | 37.78603526200121 | -122.43425424087799 | (37.7860352620012, -122.434254240878) | |||
196 | 196 | 251246 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 722X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6016169.292972799 | 2097000.9113916 | 37.738872842648796 | -122.38660458641 | (37.7388728426488, -122.38660458641) | ||||
197 | 197 | 251245 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1992 12:00:00 AM | 6002463.96916 | 2095671.24377 | 37.73445361741221 | -122.433896153002 | (37.7344536174122, -122.433896153002) | ||||
199 | 199 | 138362 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 0ft | 6002806.585 | 2114457.2427 | 37.78605488083279 | -122.434054069465 | (37.7860548808328, -122.434054069465) | |||
200 | 200 | 134567 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 07/06/2011 12:00:00 AM | 4 | Width 4ft | 6007561.6986 | 2111595.58464 | 37.778466176805296 | -122.417399738421 | (37.7784661768053, -122.417399738421) | ||
201 | 201 | 138367 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 0ft | 6002691.6152 | 2114444.3582 | 37.7860129777854 | -122.434450912019 | (37.7860129777854, -122.434450912019) | |||
202 | 202 | 138810 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2355 PINE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6002718.089 | 2115091.954 | 37.787792613821004 | -122.434405637805 | (37.787792613821, -122.434405637805) | |||
203 | 203 | 134565 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 15 | Width 4ft | 6007431.26589 | 2111583.6583 | 37.7784260904314 | -122.41785010990299 | (37.7784260904314, -122.417850109903) | |||
204 | 204 | 61453 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1984 12:00:00 AM | Permit Number 21392 | |||||||||
205 | 205 | 134566 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 14 | Width 4ft | 6007493.55732 | 2111589.9734900002 | 37.7784469358085 | -122.417635067622 | (37.7784469358085, -122.417635067622) | |||
206 | 206 | 4750 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1201 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007660.31382 | 2121409.3470799997 | 37.8054178953714 | -122.417754386066 | (37.8054178953714, -122.417754386066) | |||
207 | 207 | 138805 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6002622.3069 | 2115079.2676 | 37.787752342886 | -122.434736117903 | (37.787752342886, -122.434736117903) | |||
208 | 208 | 100305 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3701 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003064.411830001 | 2121045.8637900003 | 37.804160163827206 | -122.433633107497 | (37.8041601638272, -122.433633107497) | |||
209 | 209 | 134568 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12/17/2009 12:00:00 AM | 5 | Width 4ft | 6007669.37768 | 2111613.23365 | 37.778520694605795 | -122.41702848568501 | (37.7785206946058, -122.417028485685) | ||
210 | 210 | 13438 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2002 12:00:00 AM | 6 | 4x4 | 6014077.43398 | 2117238.82075 | 37.794325647358704 | -122.395254594939 | (37.7943256473587, -122.395254594939) | ||
211 | 211 | 138370 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002647.5104 | 2114436.9248 | 37.7859900638921 | -122.434602970779 | (37.7859900638921, -122.434602970779) | |||
212 | 212 | 138800 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2375 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 0ft | 6002511.9355 | 2115060.8724 | 37.7876955676952 | -122.435116665287 | (37.7876955676952, -122.435116665287) | |||
214 | 214 | 251244 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 05/29/2013 12:00:00 AM | 6007340.02606 | 2111591.01475 | 37.778441154342296 | -122.41816626519301 | (37.7784411543423, -122.418166265193) | ||||
216 | 216 | 138364 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 0ft | 6002783.7892 | 2114453.2783 | 37.7860427018539 | -122.43413265320801 | (37.7860427018539, -122.434132653208) | |||
217 | 217 | 138366 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 0ft | 6002708.9598 | 2114445.3493 | 37.7860166836287 | -122.43439097535801 | (37.7860166836287, -122.434390975358) | |||
218 | 218 | 11423 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 722X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X3 | 6016169.292972799 | 2097000.9113916 | 37.738872842648796 | -122.38660458641 | (37.7388728426488, -122.38660458641) | |||
219 | 219 | 138804 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 0ft | 6002587.4194 | 2115073.5588 | 37.787734687268795 | -122.43485641346001 | (37.7877346872688, -122.43485641346) | |||
220 | 220 | 138363 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002798.656 | 2114455.2605 | 37.7860489882217 | -122.434081359893 | (37.7860489882217, -122.434081359893) | |||
221 | 221 | 138361 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002830.8674 | 2114461.7028 | 37.78606850519029 | -122.433970377911 | (37.7860685051903, -122.433970377911) | |||
222 | 222 | 251247 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 722X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6016169.292972799 | 2097000.9113916 | 37.738872842648796 | -122.38660458641 | (37.7388728426488, -122.38660458641) | ||||
224 | 224 | 117019 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008121.68381 | 2113004.40875 | 37.782365960952 | -122.41556230388201 | (37.782365960952, -122.415562303882) | |
225 | 225 | 138808 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/06/2015 11:29:00 AM | 5 | Width 0ft | 6002680.0299 | 2115089.4167 | 37.787783486631206 | -122.434537133485 | (37.7877834866312, -122.434537133485) | ||
226 | 226 | 220498 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 217 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | 8 | Width 3ft | Permit Number 11470 | 6001117.07632 | 2105053.576 | 37.760138741716794 | -122.43922504972001 | (37.7601387417168, -122.43922504972) | |
227 | 227 | 13622 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 562 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6012358.746590001 | 2115584.5782 | 37.789687756343604 | -122.401085198325 | (37.7896877563436, -122.401085198325) | |||
228 | 228 | 246283 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2125 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 0ft | 6006872.377 | 2105970.5198 | 37.7629822769131 | -122.419385210964 | (37.7629822769131, -122.419385210964) | |||
229 | 229 | 138803 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002563.9496 | 2115068.4842 | 37.787719421164496 | -122.434937251329 | (37.7877194211645, -122.434937251329) | |||
230 | 230 | 138371 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 0ft | 6002611.3346 | 2114434.4469999997 | 37.785981206770394 | -122.434727951803 | (37.7859812067704, -122.434727951803) | |||
231 | 231 | 138360 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 0ft | 6002847.7164 | 2114462.1983 | 37.7860708218731 | -122.433912120385 | (37.7860708218731, -122.433912120385) | |||
232 | 232 | 2726 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2211 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002817.4873 | 2114756.5606 | 37.7868773504916 | -122.43403775447099 | (37.7868773504916, -122.434037754471) | |||
233 | 233 | 121240 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2016 12:00:00 AM | 3 | 3x5 | Permit Number 778926 | 5996501.4108 | 2113948.5087 | 37.7842981813685 | -122.45583135787399 | (37.7842981813685, -122.455831357874) | |
234 | 234 | 26932 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1570 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2000 12:00:00 AM | 3 | 3X3 | 6002097.1307 | 2111930.5841 | 37.7790770280177 | -122.43632769328998 | (37.7790770280177, -122.43632769329) | ||
235 | 235 | 45975 | Permitted Site 1 | Tree(s) :: 17 | 132 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
236 | 236 | 8118 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 841 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003718.373 | 2111409.0283 | 37.777736949412606 | -122.430681932079 | (37.7777369494126, -122.430681932079) | ||
237 | 237 | 2654 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1988 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2005 12:00:00 AM | 12 | 3X3 | 6004003.2237 | 2114978.8425 | 37.7875549020514 | -122.429951242636 | (37.7875549020514, -122.429951242636) | ||
242 | 242 | 194017 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 717 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 4ft | 6016141.23024 | 2096883.95841 | 37.7385501598741 | -122.386693461838 | (37.7385501598741, -122.386693461838) | |||
243 | 243 | 2928 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1834 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6005568.20527 | 2115901.70542 | 37.7901773571486 | -122.42460238530501 | (37.7901773571486, -122.424602385305) | |||
244 | 244 | 9908 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1809 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 6x6 | 6005225.98494 | 2115998.17525 | 37.79042290624211 | -122.425793311632 | (37.7904229062421, -122.425793311632) | |||
245 | 245 | 251255 | Undocumented 2 | Tree(s) :: 17 | 4089x Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991686.0 | 2086822.0 | 37.7095382490701 | -122.47051450746099 | (37.7095382490701, -122.470514507461) | ||||
246 | 246 | 251253 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1350 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008544.9526 | 2110145.4696299997 | 37.774539777213995 | -122.413895673958 | (37.774539777214, -122.413895673958) |
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");