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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
213 | 213 | 28640 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003714.7015 | 2113244.5448 | 37.782776612799296 | -122.430825656777 | (37.7827766127993, -122.430825656777) | ||
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) | ||||
215 | 215 | 17196 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004629.787409999 | 2116932.39582 | 37.792954330542 | -122.42792271466601 | (37.792954330542, -122.427922714666) | |||
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) | ||||
223 | 223 | 23789 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003791.7059 | 2112684.1999 | 37.7812424081927 | -122.43051925893299 | (37.7812424081927, -122.430519258933) | |||
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) | ||
238 | 238 | 251251 | DPW Maintained 3 | Prunus amygdalus :: Almond 63 | 321X Corbett Ave | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 10x10 | 5999565.0 | 2105069.0 | 37.7600926500434 | -122.444594033425 | (37.7600926500434, -122.444594033425) | ||||
239 | 239 | 251252 | DPW Maintained 3 | Prunus amygdalus :: Almond 63 | 321X Corbett Ave | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 10x10 | 5999565.0 | 2105069.0 | 37.7600926500434 | -122.444594033425 | (37.7600926500434, -122.444594033425) | ||||
240 | 240 | 251249 | Private 5 | Private shrub :: Private Shrub 64 | 161 Lundys Ln | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 3x3 | 6006716.0 | 2098685.0 | 37.7429691002686 | -122.41940918518 | (37.7429691002686, -122.41940918518) | ||||
241 | 241 | 251257 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1748x Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5986101.0 | 2094852.0 | 37.7312620395563 | -122.490407299046 | (37.7312620395563, -122.490407299046) | ||||
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) | ||||
247 | 247 | 251250 | DPW Maintained 3 | Prunus amygdalus :: Almond 63 | 321X Corbett Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 10x10 | 5999565.0 | 2105069.0 | 37.7600926500434 | -122.444594033425 | (37.7600926500434, -122.444594033425) | ||||
248 | 248 | 23733 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 20 | 6003923.026000001 | 2111743.9893 | 37.7786682616238 | -122.429997867276 | (37.7786682616238, -122.429997867276) | |||
249 | 249 | 251254 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 09th Ave | 1 | unknown : Cutout 12 | Tree 1 | MTA 6 | 3x3 | 5993109.0 | 2113253.0 | 37.782193225103605 | -122.467517213871 | (37.7821932251036, -122.467517213871) | ||||
250 | 250 | 24634 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 507 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2011 12:00:00 AM | 3 | 3x3 | 6001641.187000001 | 2110229.9881 | 37.774381702191896 | -122.437783152308 | (37.7743817021919, -122.437783152308) | ||
251 | 251 | 251258 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1748x Eucalyptus Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5986101.0 | 2094852.0 | 37.7312620395563 | -122.490407299046 | (37.7312620395563, -122.490407299046) | ||||
252 | 252 | 182864 | DPW Maintained 3 | Tree(s) :: 17 | 1674 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2016 10:49:00 AM | 1 | Width 0ft | 5987818.6474 | 2103915.1987 | 37.7562473553988 | -122.485133888104 | (37.7562473553988, -122.485133888104) | ||
253 | 253 | 251256 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 4091x Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991686.0 | 2086783.0 | 37.70943116445179 | -122.470511668938 | (37.7094311644518, -122.470511668938) | ||||
254 | 254 | 98489 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1813 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2016 12:00:00 AM | 3 | 4.5x5 | Permit Number 777656 | 5999969.69733 | 2115286.35323 | 37.7881699939074 | -122.443928497714 | (37.7881699939074, -122.443928497714) | |
255 | 255 | 19810 | DPW Maintained 3 | Araucaria heterophylla :: Norfolk Island Pine 24 | 100 STAIRWAY24 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
256 | 256 | 221894 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3164 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008618.9330400005 | 2101573.97925 | 37.75100859049479 | -122.41303356944799 | (37.7510085904948, -122.413033569448) | |||
257 | 257 | 251260 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1163 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007684.87734 | 2102881.8281400003 | 37.754547168222295 | -122.41635626045701 | (37.7545471682223, -122.416356260457) | ||||
258 | 258 | 251259 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1050x Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009753.0 | 2116795.0 | 37.7928655753561 | -122.410186352148 | (37.7928655753561, -122.410186352148) | ||||
259 | 259 | 141361 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
260 | 260 | 221893 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3164 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008601.79804 | 2101572.78068 | 37.751004337584796 | -122.41309273944599 | (37.7510043375848, -122.413092739446) | |||
261 | 261 | 141359 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1499X Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
262 | 262 | 141360 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
263 | 263 | 141358 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
264 | 264 | 20199 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002784.1975 | 2112923.5771 | 37.7818425521761 | -122.434021853774 | (37.7818425521761, -122.434021853774) | ||
265 | 265 | 109354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007474.1784 | 2120601.5824599997 | 37.803189502164294 | -122.418341225173 | (37.8031895021643, -122.418341225173) | |||
266 | 266 | 173827 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
267 | 267 | 175151 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000727.04119 | 2093604.3094 | 37.728679573387495 | -122.43975313162399 | (37.7286795733875, -122.439753131624) | |
268 | 268 | 46773 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2017 12:00:00 AM | 3 | Permit Number 779460 | 6001741.72526 | 2092006.08473 | 37.7243489150655 | -122.43613098976101 | (37.7243489150655, -122.436130989761) | |
269 | 269 | 127441 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2101 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 4ft | 6005937.76794 | 2117668.55868 | 37.795049557533105 | -122.423449386982 | (37.7950495575331, -122.423449386982) | |||
270 | 270 | 28098 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 639 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2006 12:00:00 AM | 3 | 3X3 | 6001577.9698 | 2110674.4978 | 37.7755986195101 | -122.438033679217 | (37.7755986195101, -122.438033679217) | ||
271 | 271 | 175152 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Santa Rosa Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000750.8705 | 2093589.3929700002 | 37.728639972642604 | -122.43966968351002 | (37.7286399726426, -122.43966968351) | |
272 | 272 | 251264 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
273 | 273 | 20166 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1155X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 6002621.0 | 2112212.0 | 37.7798794773869 | -122.43453554599199 | (37.7798794773869, -122.434535545992) | |||
274 | 274 | 173825 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
275 | 275 | 818 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1385 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 5982124.8821 | 2105687.3873 | 37.7607799675436 | -122.504955867812 | (37.7607799675436, -122.504955867812) | |||
276 | 276 | 173808 | Undocumented 2 | Tree(s) :: 17 | 1201 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779410 | 6015204.0 | 2109228.0 | 37.772392338117704 | -122.390796408976 | (37.7723923381177, -122.390796408976) | |
277 | 277 | 251265 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
278 | 278 | 9598 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1350 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003113.217999999 | 2112071.7207 | 37.7795222347306 | -122.43282272296999 | (37.7795222347306, -122.43282272297) | |||
279 | 279 | 48153 | Permitted Site 1 | Tree(s) :: 17 | 263 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
280 | 280 | 194427 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 905 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008110.0 | 2110227.0 | 37.774739203286295 | -122.415406037323 | (37.7747392032863, -122.415406037323) | |||
281 | 281 | 9686 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6005996.09112 | 2110833.49174 | 37.7762854431535 | -122.42276159987499 | (37.7762854431535, -122.422761599875) | |||
282 | 282 | 173829 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
283 | 283 | 173821 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
284 | 284 | 137592 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1125 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1990 12:00:00 AM | 18 | Width 0ft | 6002857.6038 | 2112094.871 | 37.7795712988398 | -122.433708655697 | (37.7795712988398, -122.433708655697) | ||
285 | 285 | 98003 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1904 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x12 | 6003782.57859 | 2119037.12075 | 37.7986853996597 | -122.431004385541 | (37.7986853996597, -122.431004385541) | |||
286 | 286 | 10157 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005745.7610599995 | 2103227.37374 | 37.755386722241504 | -122.42308680461201 | (37.7553867222415, -122.423086804612) | |||
287 | 287 | 173824 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
288 | 288 | 226558 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 320 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 7ft | 6004836.50691 | 2106380.98977 | 37.7639944545966 | -122.42645581878 | (37.7639944545966, -122.42645581878) | |||
289 | 289 | 173826 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
290 | 290 | 173809 | Undocumented 2 | Tree(s) :: 17 | 1201 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779410 | 6015204.0 | 2109228.0 | 37.772392338117704 | -122.390796408976 | (37.7723923381177, -122.390796408976) | |
291 | 291 | 129605 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 4ft | 6005928.19437 | 2117729.67294 | 37.79521682154579 | -122.42348685993299 | (37.7952168215458, -122.423486859933) | |||
292 | 292 | 9421 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 701X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767203 | 6006076.0707 | 2112433.28351 | 37.7806825946662 | -122.42259863641199 | (37.7806825946662, -122.422598636412) | |
293 | 293 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
294 | 294 | 251266 | Private 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 10x Paloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
295 | 295 | 230413 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 310 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2016 08:33:00 AM | 1 | Width 7ft | 6004826.22566 | 2106515.9879900003 | 37.7643645463025 | -122.42650099174601 | (37.7643645463025, -122.426500991746) | ||
296 | 296 | 18021 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2725 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000769.3896 | 2114817.5231 | 37.78692829139071 | -122.44112805661501 | (37.7869282913907, -122.441128056615) | |||
297 | 297 | 32804 | Permitted Site 1 | Tree(s) :: 17 | 1683 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779644 | 5999817.40523345 | 2110171.54968226 | 37.774117372599896 | -122.44408773423099 | (37.7741173725999, -122.444087734231) | |
298 | 298 | 173822 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
299 | 299 | 196427 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 McLea Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010117.0 | 2109248.0 | 37.772163696411795 | -122.408394314545 | (37.7721636964118, -122.408394314545) | |||
300 | 300 | 251263 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 |
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");