194,517 rows sorted by PermitNotes

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes ▼ XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
234 183167 DPW Maintained 1 :: 45 2422 45th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5982411.0498 2098597.3573 37.7413295619026 -122.503441142831 (37.7413295619026, -122.503441142831) 1 8 3 29491 35
235 184469 DPW Maintained 1 :: 45 2182 48th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981423.7042 2100234.3036 37.7457660664858 -122.506976375045 (37.7457660664858, -122.506976375045) 1 8 3 29491 35
236 27345 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 664 Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2008 12:00:00 AM 4 4x4   6004282.41706 2110648.93551 37.7756818605142 -122.428676512776 (37.7756818605142, -122.428676512776) 7 9 11 28852 10
237 15807 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 4959 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1995 12:00:00 AM 6 3X3   6000887.014 2090089.1979 37.7190369816005 -122.438948290663 (37.7190369816005, -122.438948290663) 9 7 6 28861 5
238 119796 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 4 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
239 205987 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1639 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5990866.8027 2104246.93654 37.7573353075836 -122.474616638541 (37.7573353075836, -122.474616638541) 1 8 4 56 12
240 26863 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 637 Buchanan St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6004510.83387 2110645.31056 37.7756848318303 -122.427886103845 (37.7756848318303, -122.427886103845) 7 9 11 28852 10
242 184584 DPW Maintained 1 :: 45 1750 38th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984424.998 2103256.5795 37.7542407008981 -122.496821507327 (37.7542407008981, -122.496821507327) 1 8 3 56 35
243 21365 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2592X Sunset Blvd 27 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5985018.1742183 2097562.094386 37.7386399329486 -122.494350460592 (37.7386399329486, -122.494350460592) 1 8 3 29491 35
244 200570 DPW Maintained 1 :: 45 1445 La Salle Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6016341.8296 2095299.657 37.7342110910182 -122.385889477594 (37.7342110910182, -122.385889477594) 10 3 8 58 1
245 251484 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 900 Bosworth St 7 Front Yard : Yard Tree DPW 1           6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
246 136052 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1114 Greenwich St 1 Side Yard : Yard Tree Private 2     3     6007569.13805 2119905.68389 37.801284085155 -122.417963252702 (37.801284085155, -122.417963252702) 5 1 1 28858 32
247 240348 DPW Maintained 1 Quercus suber :: Cork Oak 78 1201 San Jose Ave 26 Front Yard : Yard Tree Private 2     1     6004340.86769 2095971.00866 37.7353830362869 -122.427428442788 (37.7353830362869, -122.427428442788) 2 7 5 28861 2
248 119766 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 1 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
249 222839 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3100x Cesar Chavez St 5 Median : Yard Tree DPW 1     5 Width 10ft   6008877.38377 2100577.11513 37.7482859289696 -122.412069375694 (37.7482859289696, -122.412069375694) 2 4 7 28859 2
250 248390 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 34 Downey St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5998825.2199 2108039.7272 37.7682072798204 -122.447366392326 (37.7682072798204, -122.447366392326) 15 5 11 29492 9
251 187669 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 554 Valley St 1 Median : Yard Tree Private 2           6002324 2099197 37.7441265828549 -122.434632098307 (37.7441265828549, -122.434632098307) 2 7 5 63 22
252 204152 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 900 Junipero Serra Blvd 37 : Tree Private 2     1 Width 0ft   5991169.92245 2090751.38969 37.7202975393725 -122.472584434247 (37.7202975393725, -122.472584434247) 9 8 4 64 40
253 200884 DPW Maintained 1 :: 45 1200 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6012817.0471 2107089.1245 37.7663867409086 -122.39890301604 (37.7663867409086, -122.39890301604) 14 3 8 28856 20
254 130309 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 95 Vallejo St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6013009.60555 2119229.44522 37.7997319839043 -122.399089221411 (37.7997319839043, -122.399089221411) 3 1 10 28860 6
255 118456 DPW Maintained 1 Myoporum laetum :: Myoporum 62 490 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   5981010.56733 2112424.984 37.7792138173967 -122.509310094921 (37.7792138173967, -122.509310094921) 11 6 2 55 26
256 254254 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
257 115298 Permitted Site 7 :: 45 84 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231) 1 8 4 29491 40
258 139105 DPW Maintained 1 :: 45 1310 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5999792.0294 2113376.32 37.7829154028675 -122.444405875371 (37.7829154028675, -122.444405875371) 15 6 1 29490 31
259 196282 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1 25th St 13 : Yard Tree Private 2     12     6015015.25562 2102205.64875 37.7531000097757 -122.390958410295 (37.7531000097757, -122.390958410295) 10 3 8 28856 29
260 56449 Permitted Site 7 Tree(s) :: 17 1439 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5982754.68200032 2105326.56088651 37.7598262733968 -122.502750996927 (37.7598262733968, -122.502750996927) 1 8 3 56 35
261 119280 Undocumented 4 Ficus nitida :: Laurel Fig 53 95 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995293 2090512 37.7198780283713 -122.458315087488 (37.7198780283713, -122.458315087488) 9 8 6 28861 24
262 141330 DPW Maintained 1 :: 45 1314 HAYES ST 2 Sidewalk: Curb side : Pot Tree Private 2     0 Width 0ft   6001510.5734 2110463.2514 37.7750147569158 -122.438251682494 (37.7750147569158, -122.438251682494) 15 5 11 29492 10
263 17585 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 801X Persia Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6003724.8526 2090366.56287 37.71995962001 -122.429158750084 (37.71995962001, -122.429158750084) 9 7 6 28861 5
264 103685 Undocumented 4 Prunus amygdalus :: Almond 80 901X SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6008052 2102672 37.7539916655216 -122.415071798268 (37.7539916655216, -122.415071798268) 2 4 7 28859 19
265 18017 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2713 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000875.2767 2114835.3915 37.7869833841555 -122.440762994582 (37.7869833841555, -122.440762994582) 13 6 1 29490 27
266 219228 DPW Maintained 1 Ilex spp :: Holly Species 81 200x Terrace Dr 4 Median : Yard Tree DPW 1     10     5993785.97496 2096493.89011 37.736216119669 -122.463958297244 (37.736216119669, -122.463958297244) 1 8 4 59 40
267 178174 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard Tree Private 2     2     5988358.3694 2089791.63303 37.717499145949 -122.482232652541 (37.717499145949, -122.482232652541) 1 8 4 64 14
268 247892 DPW Maintained 1 :: 45 1283 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000447.0072 2109223.9761 37.7715514711219 -122.441841814274 (37.7715514711219, -122.441841814274) 15 5 11 29492 9
269 194187 DPW Maintained 1 Olea europaea :: Olive Tree 9 1100 19th St 7 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   6014241.14855 2105287.11165 37.7615180580268 -122.393851124637 (37.7615180580268, -122.393851124637) 10 3 8 28856 29
270 182815 DPW Maintained 1 :: 45 2111 Noriega St 2 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5987460.7639 2102999.1421 37.7537112584365 -122.486304306666 (37.7537112584365, -122.486304306666) 1 8 3 56 35
271 107116 DPW Maintained 1 Tree(s) :: 17 300X LIBERTY ST 18 Median : Cutout Tree DPW 1     12     6004270.1 2103982.4 37.7573764628527 -122.428243896062 (37.7573764628527, -122.428243896062) 2 4 5 28862 3
272 232035 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 39 Scott St 1 : Tree Private 2     5 Width 3ft   6002379.25876 2108512.04182 37.769706587622 -122.435107129612 (37.769706587622, -122.435107129612) 15 5 5 29492 9
273 117070 Private 9 Tree(s) :: 17 6 JOY ST 3 Front Yard : Yard Tree Private 2           6010444 2098901 37.7437714571602 -122.406533939617 (37.7437714571602, -122.406533939617) 2 7 7 28859 2
274 232433 DPW Maintained 1 Olea europaea :: Olive Tree 9 100 Church St 2 : Tree Private 2     7 Width 3ft   6004078.25972 2108290.75217 37.7691953086514 -122.429214555715 (37.7691953086514, -122.429214555715) 7 9 5 28862 3
275 193456 DPW Maintained 1 Malus :: Crab Apple 82 185 Hampshire St 3 Sidewalk: Curb side : Pot Tree Private 2     4 Width 5ft   6010023.67884 2107445.71101 37.76720979983 -122.40858996078 (37.76720979983, -122.40858996078) 8 4 8 28853 19
276 182945 DPW Maintained 1 :: 45 2691 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981809.5051 2096798.8146 37.7363558765881 -122.50538776138 (37.7363558765881, -122.50538776138) 1 8 3 29491 35
277 110381 Undocumented 4 Myoporum laetum :: Myoporum 62 2235 PALOU AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       27x18   6011689 2097713 37.740579036374 -122.402145495204 (37.740579036374, -122.402145495204) 10 3 8 58 1
278 247719 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 12 Broderick St 1 : Tree Private 2     2 Width 3ft   6001402.47389 2108783.95066 37.770397668046 -122.438505276404 (37.770397668046, -122.438505276404) 15 5 11 29492 9
279 182423 DPW Maintained 1 :: 45 1539 25th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5988365.4024 2104835.4768 37.7588060244513 -122.483310502266 (37.7588060244513, -122.483310502266) 1 8 3 56 35
280 8072 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 661 Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6005345.6576 2111619.4154 37.7784066780298 -122.425067563729 (37.7784066780298, -122.425067563729) 7 9 11 28852 10
281 136194 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2914 Fillmore St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6002528.73575 2118269.03723 37.7965053162169 -122.435288106477 (37.7965053162169, -122.435288106477) 13 9 1 57 17
282 119806 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 251X Octavia St Frontage West 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005545 2110174 37.7744491774234 -122.424275134654 (37.7744491774234, -122.424275134654) 7 9 11 28852 10
283 78989 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2319 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5988235.2891 2099507.8812 37.7441702991504 -122.483369943638 (37.7441702991504, -122.483369943638) 1 8 3 29491 35
284 142846 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 1249 POLK ST 1 Sidewalk: Curb side : Pot Tree Private 2     8 Width 0ft   6006785.3377 2115265.4346 37.7884989771715 -122.420346012985 (37.7884989771715, -122.420346012985) 13 9 10 28858 21
285 260625 DPW Maintained 1 Laurus x 'Saratoga' :: Hybrid Laurel 4 1601x Thomas Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
286 18512 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 626 Powell St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6010135.39241 2115955.1821 37.7905810646201 -122.408803973339 (37.7905810646201, -122.408803973339) 5 1 10 28857 21
288 125298 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 822 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6010056.95509 2118170.07703 37.7966582351325 -122.409231726859 (37.7966582351325, -122.409231726859) 3 1 10 308 4
289 211158 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 300x Marietta Dr 38 Median : Cutout Tree DPW 1     21 Width 5ft   5999457.51761 2097516.55077 37.7393493243992 -122.444422982731 (37.7393493243992, -122.444422982731) 9 7 4 59 40
290 72670 DPW Maintained 1 Taxus baccata :: Irish Yew 86 203 04th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     5994586.71732 2114106.61682 37.7846222306097 -122.462466948558 (37.7846222306097, -122.462466948558) 11 6 2 54 11
291 210733 DPW Maintained 1 Olea europaea :: Olive Tree 9 239 Ramsell St 1 : Tree Private 2     7 Width 3ft   5992956.15258 2088805.34296 37.7150573966491 -122.466268722147 (37.7150573966491, -122.466268722147) 9 8 6 64 24
292 141019 DPW Maintained 1 Myoporum laetum :: Myoporum 62 400 Anza St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5997825.3169 2112597.8673 37.7806655664219 -122.451153693978 (37.7806655664219, -122.451153693978) 15 6 2 54 16
293 102283 Undocumented 4 Tree(s) :: 17 4428 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6000463 2102288 37.7525079029002 -122.441288746114 (37.7525079029002, -122.441288746114) 2 4 5 28862 22
295 200164 DPW Maintained 1 :: 45 1027 Ingerson Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6014014.4798 2089939.2839 37.7193635176037 -122.393560894555 (37.7193635176037, -122.393560894555) 10 3 8 58 1
296 185842 DPW Maintained 1 :: 45 2000 35th Ave 8 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985421.3197 2101412.6246 37.7492360339251 -122.493240190301 (37.7492360339251, -122.493240190301) 1 8 3 29491 35
297 113036 DPW Maintained 1 Tree(s) :: 17 242X 07TH AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
298 107634 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 2431 24TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6011247.3 2102253.3 37.7530210518745 -122.403992166267 (37.7530210518745, -122.403992166267) 10 4 8 28859 19
299 116945 Undocumented 4 :: 45 3676 23RD ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005238 2102584 37.7535915013127 -122.424797029407 (37.7535915013127, -122.424797029407) 2 4 5 28859 19
300 234411 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 10x Benton Ave 4 Median : Yard Tree DPW 1     32     6004755.33467 2095032.93123 37.7328307189427 -122.425928720736 (37.7328307189427, -122.425928720736) 2 7 7 28861 2
301 108803 Undocumented 4 :: 45 401-499 University St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008323.15237 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207) 9 3 7 309 28
302 184152 DPW Maintained 1 :: 45 1585 44th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5982483.9557 2104316.7349 37.7570376635662 -122.503612507973 (37.7570376635662, -122.503612507973) 1 8 3 56 35
303 87474 DPW Maintained 1 Tristania conferta :: 61 6290 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x5   6013182.5276 2090518.895 37.7209087510834 -122.39647726989 (37.7209087510834, -122.39647726989) 10 3 8 58 1
304 132028 DPW Maintained 1 Olea europaea :: Olive Tree 9 33x Battery St 1 Median : Yard Tree DPW 1     27     6012842.61776 2116100.99756 37.7911327033699 -122.399447311639 (37.7911327033699, -122.399447311639) 4 1 10 28854 6
305 56460 Permitted Site 7 Tree(s) :: 17 2430 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2           6006920.19744074 2104198.59660265 37.7581196808576 -122.419094125211 (37.7581196808576, -122.419094125211) 2 4 7 28859 19
306 20543 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1303X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree DPW 1     36 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
307 99748 Undocumented 4 Tree(s) :: 17 4224 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002441 2100645 37.7481090922721 -122.434331041256 (37.7481090922721, -122.434331041256) 2 4 5 28862 22
308 102295 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 1500 Michigan St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6016449 2101073.5 37.7500708170088 -122.385921283567 (37.7500708170088, -122.385921283567) 10 3 8 58 1
310 218546 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 25 Elmhurst Dr 5 : Tree Private 2     7 Width 3ft   5991216.07157 2094485.7269 37.730553771324 -122.472697049151 (37.730553771324, -122.472697049151) 9 8 4 64 40
311 138787 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2714 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6000799 2114887 37.7871207435599 -122.441030597921 (37.7871207435599, -122.441030597921) 13 6 1 29490 27
312 201949 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1650 Carroll Ave 18 : Tree Private 2     2 Width 3ft   6013468.57071 2092447.06427 37.7262190300648 -122.395623522912 (37.7262190300648, -122.395623522912) 10 3 8 58 1
313 119729 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 9 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
314 184219 DPW Maintained 1 :: 45 3439 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5984114.8945 2104934.4274 37.7588294281219 -122.498017803137 (37.7588294281219, -122.498017803137) 1 8 3 56 35
315 106681 Undocumented 4 Acer spp :: Maple 88 272 COLLINGWOOD ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6002031.2 2104270.9 37.7580416780136 -122.436007529668 (37.7580416780136, -122.436007529668) 2 4 5 28862 3
316 245380 DPW Maintained 1 :: 45 3620 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005334.5439 2097112.3285 37.7385729952273 -122.424074069598 (37.7385729952273, -122.424074069598) 2 7 5 28859 2
317 189161 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 109 Kissling St 4 : Tree Private 2     2 Width 3ft   6008149.50016 2109391.65635 37.7724477670719 -122.415210253457 (37.7724477670719, -122.415210253457) 8 2 9 28853 19
318 190050 DPW Maintained 1 Cinnamomum camphora :: Camphor Tree 90 601 Amador St 1 : Tree Private 2     6 Width 3ft   6016946.57228 2099501.56467 37.7457821291547 -122.384091181786 (37.7457821291547, -122.384091181786) 10 3 8 58 1
319 96811 Permitted Site 7 Schinus molle :: California Pepper 91 356 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996379.5 2106960.2 37.7651031164685 -122.455747798641 (37.7651031164685, -122.455747798641) 15 5 11 29492 12
320 228444 DPW Maintained 1 :: 45 399 Haight St 1 : Tree Private 2     4 Width 3ft   6004268.91864 2109406.82097 37.7722705538615 -122.428634644993 (37.7722705538615, -122.428634644993) 7 9 11 28852 10
321 219060 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 221 Congo St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6000072.85251 2094491.10418 37.731077247812 -122.442078323383 (37.731077247812, -122.442078323383) 9 7 4 63 40
322 131741 DPW Maintained 1 Myoporum laetum :: Myoporum 62 2901 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6000273.04756 2116436.32711 37.7913448210684 -122.44296157632 (37.7913448210684, -122.44296157632) 13 6 1 29490 27
323 106136 Undocumented 4 Tree(s) :: 17 200X RIDGEWOOD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996801 2094865 37.7319168756422 -122.453416604011 (37.7319168756422, -122.453416604011) 9 7 4 59 40
324 97786 DPW Maintained 1 Olea europaea :: Olive Tree 9 810 Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6012446.82878 2118928.41788 37.7988740576432 -122.401015485586 (37.7988740576432, -122.401015485586) 3 1 10 28860 6
325 248307 DPW Maintained 1 :: 45 1323 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999369.7066 2108379.5015 37.7691713129844 -122.445507509409 (37.7691713129844, -122.445507509409) 15 5 11 29492 9
326 228441 DPW Maintained 1 :: 45 419 Haight St 1 : Tree DPW 1   04/08/2008 12:00:00 AM 6 Width 3ft   6004104.36681 2109385.12417 37.7722016657998 -122.429202297052 (37.7722016657998, -122.429202297052) 7 9 11 29492 10
327 182422 DPW Maintained 1 :: 45 1534 28th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5987477.4649 2104817.3887 37.7587046434176 -122.486380033207 (37.7587046434176, -122.486380033207) 1 8 3 56 35
328 197129 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400 Newhall St 11 : Tree Private 2     5 Width 3ft   6015974.4503 2097856.83037 37.7412122331485 -122.387337958305 (37.7412122331485, -122.387337958305) 10 3 8 58 1
329 101063 Undocumented 4 Tree(s) :: 17 710 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001857 2102025 37.7518650783703 -122.436449244442 (37.7518650783703, -122.436449244442) 2 4 5 28862 22
330 250773 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 259 32nd Ave 1 : Tree Private 2     14 Width 3ft   5985865.92055 2114194.89594 37.7843585636424 -122.492644052605 (37.7843585636424, -122.492644052605) 11 6 1 55 33
331 194117 DPW Maintained 1 Nyssa sylvatica :: Tupelo: Sour Gum 92 2 13th St 9 : Tree Private 2     2 Width 3ft   6009035.07102 2108345.44011 37.7696248302591 -122.412073015253 (37.7696248302591, -122.412073015253) 8 4 9 28853 19
332 182987 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1975 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5989890.895 2098325.8493 37.7410209633467 -122.477558903564 (37.7410209633467, -122.477558903564) 1 8 3 29491 35
334 162296 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 299 Olmstead St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2020 12:00:00 AM 3 Width 0ft   6010920.41592 2090984.45712 37.7220609417541 -122.40432950351 (37.7220609417541, -122.40432950351) 10 3 7 309 28
335 102831 Undocumented 4 Schinus terebinthifolius :: Brazilian Pepper 93 25X Lansing St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6014531.5 2114230.8 37.7860915609161 -122.393472847757 (37.7860915609161, -122.393472847757) 6 2 9 28855 6
336 189035 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 50 Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010091.10409 2111787.20644 37.7791343146469 -122.408663052281 (37.7791343146469, -122.408663052281) 14 2 9 28853 34
337 193188 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 401 Harrison St 6 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6014838.37703 2114321.79559 37.7863584598262 -122.392417493778 (37.7863584598262, -122.392417493778) 6 2 9 28855 6
339 18096 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 3008 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/29/1997 12:00:00 AM 6 3X3   5999424.6928 2114682.6521 37.7864812852303 -122.445770680231 (37.7864812852303, -122.445770680231) 15 6 1 29490 31

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);