trees
194,517 rows sorted by qSiteInfo
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );