194,517 rows sorted by qSiteInfo

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)
118 236256 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 151 Valencia St 1 : Tree Private 2     9 Width 4ft   6006073.15075 2108915.83898 37.7710243776945 -122.422358744984 (37.7710243776945, -122.422358744984) 8 2 9 28853 19
138 203559 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 145 Lakeview Ave 1 : Tree Private 2     1 Width 3ft   5997146.51683 2089373.33367 37.7168578537955 -122.45182605794 (37.7168578537955, -122.45182605794) 9 8 6 28861 24
146 190658 DPW Maintained 1 :: 45 1461 Fairfax Ave 4 : Tree Private 2     7 Width 3ft   6016241.73559 2097685.48667 37.7407565574799 -122.386401828788 (37.7407565574799, -122.386401828788) 10 3 8 58 1
147 198543 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700 Newcomb Ave 1 : Tree Private 2     3 Width 0ft   6014375.16951 2096346.21278 37.7369756879815 -122.392762090617 (37.7369756879815, -122.392762090617) 10 3 8 58 1
152 235666 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1301 Jessie St 4 : Tree Private 2     3 Width 2ft   6006462.25734 2109005.38337 37.7712921868165 -122.421019169707 (37.7712921868165, -122.421019169707) 8 2 9 28853 19
211 196303 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 249 Shipley St 1 : Tree Private 2     1 Width 5ft   6011469.59111 2111688.37468 37.7789400547713 -122.403887319468 (37.7789400547713, -122.403887319468) 14 2 9 28856 34
219 131064 DPW Maintained 1 Maytenus boaria :: Mayten 58 1877 Greenwich St 1 : Tree Private 2     3 Width 4ft   6003926.06281 2119346.70194 37.7995435588443 -122.430529985984 (37.7995435588443, -122.430529985984) 13 9 1 57 17
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
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
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
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
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
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
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
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
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
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
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
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
356 233580 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1317 Clayton St 1 : Tree Private 2     6 Width 3ft   5999035.80578 2105154.14715 37.7602962318988 -122.44643038196 (37.7602962318988, -122.44643038196) 15 5 5 28862 12
368 234039 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 93 Scott St 1 : Tree Private 2     12 Width 4ft   6002347.86623 2108745.44445 37.7703456710482 -122.435232412346 (37.7703456710482, -122.435232412346) 15 5 5 29492 9
372 189871 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Newhall St 9 : Tree Private 2     7 Width 3ft   6016028.58203 2097927.48174 37.7414092251604 -122.387155715173 (37.7414092251604, -122.387155715173) 10 3 8 58 1
409 187885 DPW Maintained 1 Acer rubrum :: Red Maple 75 1600 Indiana St 23 : Tree Private 2     3 Width 3ft   6015152.38977 2100397.43257 37.748142637288 -122.390357841268 (37.748142637288, -122.390357841268) 10 3 8 58 1
411 247779 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 254 30th St 1 : Tree Private 2     6 Width 3ft   6004930.81683 2098452.72536 37.7422306182373 -122.42556533529 (37.7422306182373, -122.42556533529) 2 7 5 63 22
418 191568 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1610 Innes Ave 7 : Tree Private 2     6 Width 3ft   6015230.3015 2097471.78413 37.7401137346697 -122.389884091895 (37.7401137346697, -122.389884091895) 10 3 8 58 1
437 202267 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 28 Orsi Cir 1 : Tree Private 2     5 Width 2ft   6013033.98272 2093207.99375 37.7282842035544 -122.397179214247 (37.7282842035544, -122.397179214247) 10 3 8 58 1
440 204255 DPW Maintained 1 Arbutus unedo :: Strawberry Tree 106 40 Rossmoor Dr 1 : Tree Private 2     2 Width 3ft   5991076.25798 2094451.16026 37.7304507656815 -122.473177880653 (37.7304507656815, -122.473177880653) 9 8 4 64 40
441 200380 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 199x Shipley St 2 : Tree Private 2     7 Width 2ft   6011866.27149 2112076.32254 37.7800274232626 -122.402542323073 (37.7800274232626, -122.402542323073) 6 2 9 28856 34
457 198704 DPW Maintained 1 Ulmus spp :: Elm Spp 98 1675 Bay Shore Blvd 2 : Tree Private 2     11 Width 3ft   6012158.49704 2090987.28634 37.7221378175792 -122.400049934761 (37.7221378175792, -122.400049934761) 10 3 8 58 1
469 245799 DPW Maintained 1 Corymbia calophylla :: 108 50 Church St 1 : Tree Private 2     21 Width 6ft   6004070.93701 2108481.83175 37.7697195522468 -122.429253511635 (37.7697195522468, -122.429253511635) 7 9 5 29492 10
472 221573 DPW Maintained 1 Acer buergeranum :: Trident Maple 110 40 Elgin Park 1 : Tree Private 2     1 Width 3ft   6005806.54195 2108839.22973 37.7707989842145 -122.423275507581 (37.7707989842145, -122.423275507581) 8 2 5 28853 19
473 175337 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 114 De Long St 4 : Tree Private 2     14 Width 3ft   5994455.45704 2086824.92953 37.7097060419823 -122.460943071888 (37.7097060419823, -122.460943071888) 9 8 6 28861 25
480 225991 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 99 Laussat St 2 : Tree Private 2     1 Width 3ft   6004313.0789 2109253.93974 37.7718532783246 -122.428470991768 (37.7718532783246, -122.428470991768) 7 9 11 28852 10
482 175383 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3001 Ocean Ave 1 : Tree Private 2     8 Width 3ft   5989487.94212 2095224.7734 37.7324828171076 -122.478725410769 (37.7324828171076, -122.478725410769) 1 8 4 64 35
648 189633 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 10 : Tree Private 2     10 Width 3ft   6007281.55408 2110475.16176 37.775373998252 -122.418289406239 (37.775373998252, -122.418289406239) 8 2 9 28853 34
649 189627 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 4 : Tree Private 2     16 Width 3ft   6007528.52851 2110215.72509 37.7746755460784 -122.417416671761 (37.7746755460784, -122.417416671761) 8 2 9 28853 34
806 189267 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1300 Fairfax Ave 6 : Tree Private 2     1 Width 4ft   6017011.55747 2097196.03632 37.7394552087924 -122.383705980546 (37.7394552087924, -122.383705980546) 10 3 8 58 1
832 211486 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 300 Junipero Serra Blvd 17 : Tree Private 2     56 Width 0ft   5991389.83684 2094502.84602 37.7306108333036 -122.47209757005 (37.7306108333036, -122.47209757005) 9 8 4 64 40
1021 213351 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 752 Head St 1 : Tree Private 2     3 Width 3ft   5993534.80603 2090819.23886 37.7206204409725 -122.464414798499 (37.7206204409725, -122.464414798499) 9 8 6 64 24
1024 200362 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Phelps St 3 : Tree Private 2     7 Width 5ft   6014166.7855 2096532.27247 37.7374749933851 -122.393495590258 (37.7374749933851, -122.393495590258) 10 3 8 58 1
1042 189625 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 2 : Tree Private 2     18 Width 3ft   6007555.58457 2110185.16197 37.7745931492825 -122.417320912844 (37.7745931492825, -122.417320912844) 8 2 9 28853 34
1113 188226 DPW Maintained 1 Arbutus unedo :: Strawberry Tree 106 1350 19th St 3 : Tree Private 2   11/01/1996 12:00:00 AM 6 Width 3ft Permit Number 37286 6013575.41694 2105253.06849 37.7613875637091 -122.396151246903 (37.7613875637091, -122.396151246903) 10 3 8 28856 29
1115 238053 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 426 Lily St 2 : Tree Private 2     9 Width 3ft   6004459.53739 2109991.59452 37.7738869854343 -122.428016956418 (37.7738869854343, -122.428016956418) 7 9 11 28852 10
1258 190419 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1300 Evans Ave 15 : Tree Private 2   05/01/2017 12:00:00 AM 3 Width 3ft   6017844.32202 2096957.74462 37.7388469037738 -122.380810054756 (37.7388469037738, -122.380810054756) 10 3 8 58 1
1289 190652 DPW Maintained 1 :: 45 310 Arkansas St 1 : Tree Private 2     8 Width 3ft   6012893.9262 2105541.86403 37.7621425904374 -122.398528520183 (37.7621425904374, -122.398528520183) 10 3 8 28856 29
1454 247689 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2 Central Ave 4 : Tree Private 2     24 Width 4ft   5999999.2126 2108392.11953 37.7692418764422 -122.443330996248 (37.7692418764422, -122.443330996248) 15 5 11 29492 9
1550 201970 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1651 Carroll Ave 21 : Tree Private 2     3 Width 3ft   6013765.00423 2092206.62002 37.7255753034535 -122.39458193082 (37.7255753034535, -122.39458193082) 10 3 8 58 1
1688 213308 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 219 Tara St 1 : Tree Private 2     3 Width 3ft   5997858.51511 2090428.83634 37.7197967734736 -122.44944104777 (37.7197967734736, -122.44944104777) 9 8 6 28861 24
1727 249457 DPW Maintained 1 Olea europaea :: Olive Tree 9 201 Olive St 2 : Tree Private 2     11 Width 4ft   6006319.82833 2113698.46294 37.7841702168319 -122.421845255461 (37.7841702168319, -122.421845255461) 7 9 11 28858 41
1839 227130 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 200 Portola Dr 2 : Tree Private 2     3 Width 3ft   5999573.30223 2100550.73469 37.7476870722101 -122.444240631696 (37.7476870722101, -122.444240631696) 2 4 5 63 38
1925 250092 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1698 Gough St 1 : Tree Private 2     6 Width 3ft   6005353.59952 2115427.24795 37.7888624934521 -122.425311128409 (37.7888624934521, -122.425311128409) 13 9 1 28858 41
2067 211204 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 700 Junipero Serra Blvd 150 : Tree Private 2     8 Width 0ft   5991184.95958 2091479.43645 37.7222974463483 -122.472585508941 (37.7222974463483, -122.472585508941) 9 8 4 64 40
2070 213331 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 151 Byxbee St 1 : Tree Private 2     6 Width 2ft   5991924.78555 2089552.62516 37.7170496899626 -122.469887910591 (37.7170496899626, -122.469887910591) 9 8 6 64 24
2082 195047 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 360 06th St 2 : Tree DPW 1   02/25/2002 12:00:00 AM 3 Width 3ft Permit Number 42039 6011214.59355 2111232.18316 37.7776732094966 -122.404737337955 (37.7776732094966, -122.404737337955) 14 2 9 28853 34
2322 218250 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2751 14th Ave 1 : Tree Private 2     14 Width 3ft   5992235.80201 2097238.62713 37.738171520993 -122.469372026199 (37.738171520993, -122.469372026199) 1 8 4 59 40
2378 239239 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101 Scott St 1 : Tree Private 2     20 Width 6ft   6002329.06188 2108869.34471 37.7706848027038 -122.435306320439 (37.7706848027038, -122.435306320439) 15 5 11 29492 9
2432 250771 DPW Maintained 1 Maytenus boaria :: Mayten 58 244 32nd Ave 1 : Tree Private 2     8 Width 3ft   5985908.77802 2114250.76348 37.7845144656071 -122.492499898474 (37.7845144656071, -122.492499898474) 11 6 1 55 33
2464 190663 DPW Maintained 1 :: 45 1360 Fairfax Ave 5 : Tree Private 2     2 Width 3ft   6016747.40621 2097393.16894 37.7399818904553 -122.384633036796 (37.7399818904553, -122.384633036796) 10 3 8 58 1
2491 193810 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 285 Texas St 3 : Tree Private 2     10 Width 3ft   6013775.34661 2105819.12575 37.7629529551453 -122.395499427275 (37.7629529551453, -122.395499427275) 14 3 8 28856 29
2505 196318 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 323 11th St 1 : Tree Private 2     4 Width 3ft   6008553.79261 2109149.29537 37.7718050135221 -122.413794615322 (37.7718050135221, -122.413794615322) 8 2 9 28853 34
2617 247759 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 75 Alpine Ter 1 : Tree Private 2     10 Width 3ft   6001668.74952 2108376.80716 37.7692948959648 -122.437555068929 (37.7692948959648, -122.437555068929) 15 5 5 29492 9
2621 202038 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 75 Crane St 2 : Tree Private 2     2 Width 3ft   6012275.87253 2090920.17769 37.7219600944649 -122.399639484201 (37.7219600944649, -122.399639484201) 10 3 8 58 1
2766 247224 DPW Maintained 1 Schinus molle :: California Pepper 91 135 Divisadero St 1 : Tree Private 2   08/07/2019 12:00:00 AM 3 Width 3ft   6001887.60725 2108459.11842 37.7695333431173 -122.436803945272 (37.7695333431173, -122.436803945272) 15 5 5 29492 9
2787 194758 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 750 Phelps St 43 : Tree Private 2     1 Width 2ft   6015105.78884 2097790.25184 37.740981275571 -122.390336854658 (37.740981275571, -122.390336854658) 10 3 8 58 1
2811 246987 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 70 Clipper St 1 : Tree Private 2     11 Width 3ft   6004726.23458 2101068.69852 37.7494019174823 -122.426458941248 (37.7494019174823, -122.426458941248) 2 4 5 28862 22
2850 178600 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200 Winston Dr 6 : Tree Private 2     6 Width 0ft   5989476.93903 2093627.59215 37.7280967254778 -122.478646687712 (37.7280967254778, -122.478646687712) 1 8 4 64 14
3047 189052 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1498 Fairfax Ave 9 : Tree Private 2   04/13/2020 12:00:00 AM 3 Width 4ft   6016122.19881 2097851.77649 37.7412065377553 -122.386826739572 (37.7412065377553, -122.386826739572) 10 3 8 58 1
3132 241639 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 200 Guerrero St 1 : Tree Private 2     4 Width 2ft   6005424.1713 2107755.72538 37.7678023541299 -122.424521053307 (37.7678023541299, -122.424521053307) 8 4 5 28853 19
3164 249333 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 840 Post St 4 : Tree Private 2     15 Width 4ft   6008047.50765 2114838.3401 37.7873973224712 -122.415948831592 (37.7873973224712, -122.415948831592) 13 1 10 28858 21
3177 191238 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1600 Newhall St 8 : Tree Private 2     2 Width 2ft   6014118.19632 2095356.58877 37.7342441078693 -122.393581327137 (37.7342441078693, -122.393581327137) 10 3 8 58 1
3192 247788 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 0 30th St 4 : Tree Private 2     14 Width 3ft   6004361.25599 2098418.69842 37.7421049892529 -122.427532277614 (37.7421049892529, -122.427532277614) 2 7 5 63 22
3314 193435 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 600 Missouri St 1 : Tree Private 2     7 Width 3ft   6013537.44197 2104295.86136 37.7587571690323 -122.396215498963 (37.7587571690323, -122.396215498963) 10 3 8 28856 29
3340 192835 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 333 03rd St 5 : Tree Private 2     1 Width 2ft   6013082.87743 2113319.47205 37.7835086710412 -122.398420759824 (37.7835086710412, -122.398420759824) 6 2 9 28856 6
3344 197494 DPW Maintained 1 Schinus molle :: California Pepper 91 401 Texas St 3 : Tree Private 2     23 Width 7ft   6013811.84722 2105166.53521 37.7611631145139 -122.395327465206 (37.7611631145139, -122.395327465206) 10 3 8 28856 29
3377 227135 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 200 Portola Dr 11 : Tree Private 2     2 Width 3ft   5999460.85655 2100362.14837 37.7471628438967 -122.444615908893 (37.7471628438967, -122.444615908893) 2 4 5 63 38
3538 249405 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 430 Turk St 1 : Tree Private 2     8 Width 4ft   6007893.39158 2113084.10787 37.7825719605735 -122.416357743418 (37.7825719605735, -122.416357743418) 7 10 9 28852 36
3586 217748 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 611 Frederick St 1 : Tree Private 2     6 Width 3ft   5996609.14457 2107297.9343 37.766043624629 -122.45497792451 (37.766043624629, -122.45497792451) 15 5 11 29492 12
3615 190055 DPW Maintained 1 Cinnamomum camphora :: Camphor Tree 90 601 Amador St 7 : Tree Private 2     6 Width 3ft   6017078.53264 2099510.1323 37.7458129489113 -122.383635473719 (37.7458129489113, -122.383635473719) 10 3 8 58 1
3646 189251 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 120 Loomis St 1 : Tree Private 2     1 Width 4ft   6010844.92077 2097998.29295 37.7413152397136 -122.405084094075 (37.7413152397136, -122.405084094075) 10 3 8 58 1
3743 193316 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 136 Hawthorne St 2 : Tree Private 2     9 Width 2ft   6013300.83104 2113672.81478 37.7844910077044 -122.397691511273 (37.7844910077044, -122.397691511273) 6 2 9 28856 6
3805 250547 DPW Maintained 1 Maytenus boaria :: Mayten 58 120 El Camino Del Mar 2 : Tree Private 2     2 Width 4ft   5988224.27982 2115368.83764 37.7877194875147 -122.484571190206 (37.7877194875147, -122.484571190206) 11 6 1 55 33
3807 204110 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 500 Junipero Serra Blvd 24 : Tree Private 2     3 Width 0ft   5991353.72908 2093672.35856 37.7283284331018 -122.472161885976 (37.7283284331018, -122.472161885976) 9 8 4 64 40
3820 247644 DPW Maintained 1 Podocarpus henkelii :: Long-Leafed Yellow-Wood 187 390 Ogden Ave 4 : Tree Private 2     3 Width 3ft   6008136.34334 2096071.82568 37.7358737936308 -122.414313159039 (37.7358737936308, -122.414313159039) 2 7 7 28859 2
3999 213261 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 255 Ramsell St 1 : Tree Private 2     7 Width 3ft   5992959.15066 2088902.16567 37.7153234215169 -122.466265391939 (37.7153234215169, -122.466265391939) 9 8 6 64 24
4014 201331 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 95 Bitting Ave 2 : Tree Private 2     6 Width 2ft   6012535.62971 2092785.01018 37.7270950209928 -122.398872378676 (37.7270950209928, -122.398872378676) 10 3 8 58 1
4100 204072 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 216 Arch St 1 : Tree Private 2   04/14/2020 12:00:00 AM 3 Width 3ft Permit Number 767875 5992726.82301 2088588.57169 37.7144489603362 -122.467045625763 (37.7144489603362, -122.467045625763) 9 8 6 64 24
4277 192886 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2 Rizal St 7 : Tree Private 2     9 Width 3ft   6012771.99776 2112717.29257 37.7818379024256 -122.399453999917 (37.7818379024256, -122.399453999917) 6 2 9 28856 34
4292 190709 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 715 Wisconsin St 1 : Tree Private 2     11 Width 3ft   6012742.49696 2104176.10053 37.7583840672751 -122.398956396912 (37.7583840672751, -122.398956396912) 10 3 8 28856 29
4543 206871 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700 Junipero Serra Blvd 167 : Tree Private 2     28 Width 0ft   5991178.39011 2091334.01969 37.7218977876304 -122.472597620991 (37.7218977876304, -122.472597620991) 9 8 4 64 40
4551 189261 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2215 Newcomb Ave 1 : Tree Private 2     1 Width 3ft   6011901.66973 2098145.68488 37.7417789652237 -122.401440561855 (37.7417789652237, -122.401440561855) 10 3 8 58 1
4565 187804 DPW Maintained 1 Acer buergeranum :: Trident Maple 110 1022 Minna St 8 : Tree Private 2     3 Width 3ft   6007516.81394 2109678.2468 37.7731990993886 -122.417419096312 (37.7731990993886, -122.417419096312) 8 2 9 28853 19
4676 204157 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 900 Junipero Serra Blvd 109 : Tree Private 2     2 Width 0ft   5991141.76494 2090345.59901 37.7191817082419 -122.472652193669 (37.7191817082419, -122.472652193669) 9 8 4 64 40
4812 198517 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1763 Newcomb Ave 2 : Tree Private 2     5 Width 7ft   6014346.73951 2096322.78373 37.7369097775472 -122.392858747949 (37.7369097775472, -122.392858747949) 10 3 8 58 1
4823 190051 DPW Maintained 1 Cinnamomum camphora :: Camphor Tree 90 601 Amador St 2 : Tree Private 2     5 Width 3ft   6016961.70348 2099501.73786 37.7457834412444 -122.384038871819 (37.7457834412444, -122.384038871819) 10 3 8 58 1
5037 215607 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 900 Junipero Serra Blvd 47 : Tree Private 2     2 Width 0ft   5991157.54734 2090681.21679 37.7201041455671 -122.472622096933 (37.7201041455671, -122.472622096933) 9 8 4 64 40
5051 192939 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1559 Howard St 3 : Tree Private 2     5 Width 3ft   6007881.70364 2109409.76028 37.7724824224706 -122.416137872687 (37.7724824224706, -122.416137872687) 8 2 9 28853 19
5058 228531 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1744 Bryant St 1 : Tree Private 2     8 Width 3ft   6009451.25319 2106552.40785 37.7647249190387 -122.410506818932 (37.7647249190387, -122.410506818932) 8 4 7 28859 19
5120 197001 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 16 : Tree Private 2     9 Width 4ft   6013598.90827 2100122.82985 37.7473023413409 -122.395710528743 (37.7473023413409, -122.395710528743) 10 3 8 58 1

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)
);