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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11146 | 246588 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 68 Waller St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6005380.13328 | 2109258.65002 | 37.7719265371042 | -122.42478030806 | (37.7719265371042, -122.42478030806) | 7 | 9 | 11 | 28852 | 10 | |||
11305 | 189630 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 7 | : | Tree | Private 2 | 14 | Width 3ft | 6007441.71426 | 2110305.43642 | 37.7749169870715 | -122.417723340559 | (37.7749169870715, -122.417723340559) | 8 | 2 | 9 | 28853 | 34 | |||
11359 | 204256 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 40 Rossmoor Dr | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5991070.06293 | 2094489.8143 | 37.7305565412538 | -122.473202115591 | (37.7305565412538, -122.473202115591) | 9 | 8 | 4 | 64 | 40 | |||
11370 | 188616 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 13 | : | Tree | Private 2 | 16 | Width 3ft | 6015976.85216 | 2098785.54996 | 37.7437624397877 | -122.38739442492 | (37.7437624397877, -122.38739442492) | 10 | 3 | 8 | 58 | 1 | |||
11496 | 129518 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 3041 Divisadero St | 2 | : | Tree | Private 2 | 3 | Width 2ft | 6000446.00148 | 2118771.96061 | 37.7977677152718 | -122.44253092607 | (37.7977677152718, -122.44253092607) | 13 | 9 | 1 | 57 | 17 | |||
11553 | 221666 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 599 Buchanan St | 5 | : | Tree | Private 2 | 1 | Width 6ft | 6004540.01666 | 2110455.77622 | 37.7751660677958 | -122.427771645646 | (37.7751660677958, -122.427771645646) | 7 | 9 | 11 | 28852 | 10 | |||
11580 | 247184 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 1 | : | Tree | Private 2 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | 15 | 5 | 11 | 29492 | 9 | |
11597 | 189629 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 6 | : | Tree | Private 2 | 16 | Width 3ft | 6007461.61467 | 2110284.7901 | 37.774861417042 | -122.417653036967 | (37.774861417042, -122.417653036967) | 8 | 2 | 9 | 28853 | 34 | |||
11615 | 189628 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 5 | : | Tree | Private 2 | 11 | Width 3ft | 6007505.86156 | 2110238.1728 | 37.7747359067747 | -122.417496672745 | (37.7747359067747, -122.417496672745) | 8 | 2 | 9 | 28853 | 34 | |||
11636 | 249410 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 698 Polk St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6007114.55441 | 2113257.76141 | 37.7830049436594 | -122.419064511231 | (37.7830049436594, -122.419064511231) | 7 | 9 | 9 | 28852 | 36 | |||
11650 | 213242 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 116 Majestic Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5997026.98347 | 2089301.08259 | 37.7166526221889 | -122.452234013791 | (37.7166526221889, -122.452234013791) | 9 | 8 | 6 | 28861 | 24 | |||
11740 | 246800 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 125 Brewster St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6010336.37348 | 2099216.9029 | 37.7446328360494 | -122.406928349065 | (37.7446328360494, -122.406928349065) | 2 | 7 | 7 | 28859 | 2 | |||
11889 | 246929 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 349 Frederick St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 5998314.74139 | 2107540.20293 | 37.7668065294199 | -122.449096088512 | (37.7668065294199, -122.449096088512) | 15 | 5 | 11 | 29492 | 9 | |||
11931 | 202097 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 2650 Newhall St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6012483.7562 | 2092985.14235 | 37.7276416523229 | -122.399065747292 | (37.7276416523229, -122.399065747292) | 10 | 3 | 8 | 58 | 1 | |||
11953 | 189434 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Mendell St | 3 | : | Tree | Private 2 | 12 | Width 3ft | 6016859.57023 | 2097844.08748 | 37.7412262239015 | -122.384276612087 | (37.7412262239015, -122.384276612087) | 10 | 3 | 8 | 58 | 1 | |||
12032 | 213817 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 385 Bright St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 5993748.87526 | 2089757.7092 | 37.7177180733139 | -122.463597832781 | (37.7177180733139, -122.463597832781) | 9 | 8 | 6 | 64 | 24 | |||
12034 | 189635 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 12 | : | Tree | Private 2 | 13 | Width 3ft | 6007252.77598 | 2110507.15575 | 37.7754602261381 | -122.418391225675 | (37.7754602261381, -122.418391225675) | 8 | 2 | 9 | 28853 | 34 | |||
12073 | 201265 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 15 Orsi Cir | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6013080.9244 | 2093125.28837 | 37.728059724652 | -122.397011137269 | (37.728059724652, -122.397011137269) | 10 | 3 | 8 | 58 | 1 | |||
12074 | 204107 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 400 Junipero Serra Blvd | 19 | : | Tree | Private 2 | 5 | Width 0ft | 5991377.14521 | 2094057.78597 | 37.7293880754752 | -122.472109018414 | (37.7293880754752, -122.472109018414) | 9 | 8 | 4 | 64 | 40 | |||
12078 | 249366 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 775 Post St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6008444.56493 | 2114842.41912 | 37.7874308375006 | -122.414575379762 | (37.7874308375006, -122.414575379762) | 5 | 1 | 10 | 28858 | 36 | |||
12118 | 204126 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 700 Junipero Serra Blvd | 82 | : | Tree | Private 2 | 7 | Width 0ft | 5991258.86268 | 2092183.21278 | 37.7242341192967 | -122.472381325945 | (37.7242341192967, -122.472381325945) | 9 | 8 | 4 | 64 | 40 | |||
12141 | 219848 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 47 Clarendon Ave | 1 | : | Tree | Private 2 | 06/20/2010 12:00:00 AM | 4 | Width 3ft | Permit Number 768045 | 5998024.44262 | 2104629.5149 | 37.7587979065061 | -122.449890386836 | (37.7587979065061, -122.449890386836) | 15 | 5 | 4 | 28862 | 38 | |
12157 | 241051 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 961 San Bruno Ave | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6011090.2221 | 2103848.38169 | 37.757392016144 | -122.40464765488 | (37.757392016144, -122.40464765488) | 10 | 4 | 8 | 28859 | 19 | |||
12254 | 213339 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 375 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992194.58269 | 2090348.43318 | 37.7192503768696 | -122.469013242585 | (37.7192503768696, -122.469013242585) | 9 | 8 | 6 | 64 | 24 | |||
12291 | 190743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 39 Latona St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6014419.07803 | 2094437.81167 | 37.7317380471513 | -122.392476830144 | (37.7317380471513, -122.392476830144) | 10 | 3 | 8 | 58 | 1 | |||
12375 | 226540 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1220 Potrero Ave | 2 | : | Tree | Private 2 | 28 | Width 4ft | 6010529.29654 | 2102158.63708 | 37.752720986907 | -122.406468503221 | (37.752720986907, -122.406468503221) | 10 | 4 | 7 | 28859 | 19 | |||
12395 | 195067 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501 Bryant St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6008874.83792 | 2108609.10047 | 37.7703397885684 | -122.412645899583 | (37.7703397885684, -122.412645899583) | 8 | 2 | 9 | 28853 | 19 | |||
12427 | 189631 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 8 | : | Tree | Private 2 | 9 | Width 3ft | 6007308.18753 | 2110441.11785 | 37.7752820209699 | -122.418194860528 | (37.7752820209699, -122.418194860528) | 8 | 2 | 9 | 28853 | 34 | |||
12430 | 220123 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 501 Haight St | 1 | : | Tree | Private 2 | 26 | Width 4ft | 6003680.56736 | 2109328.54381 | 37.772022309504 | -122.430664217001 | (37.772022309504, -122.430664217001) | 15 | 9 | 11 | 29492 | 10 | |||
12446 | 191567 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1610 Innes Ave | 6 | : | Tree | Private 2 | 5 | Width 3ft | 6015249.67467 | 2097458.39036 | 37.7400780324848 | -122.389816171494 | (37.7400780324848, -122.389816171494) | 10 | 3 | 8 | 58 | 1 | |||
12592 | 190145 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1270 Fairfax Ave | 5 | : | Tree | Private 2 | 16 | Width 4ft | 6017279.69898 | 2096994.64423 | 37.7389170445949 | -122.38276484453 | (37.7389170445949, -122.38276484453) | 10 | 3 | 8 | 58 | 1 | |||
12695 | 204098 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 33 Sargent St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993844.91578 | 2089161.33864 | 37.7160861158451 | -122.463222616732 | (37.7160861158451, -122.463222616732) | 9 | 8 | 6 | 64 | 24 | |||
12711 | 190451 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Evans Ave | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6016356.86171 | 2098066.94132 | 37.7418103263734 | -122.386030346736 | (37.7418103263734, -122.386030346736) | 10 | 3 | 8 | 58 | 1 | |||
12742 | 194070 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 41 Dorman Ave | 1 | : | Tree | Private 2 | 15 | 6011513.73296 | 2097374.29319 | 37.7396392352499 | -122.402727690435 | (37.7396392352499, -122.402727690435) | 10 | 3 | 8 | 58 | 1 | ||||
12810 | 189626 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 3 | : | Tree | Private 2 | 14 | Width 3ft | 6007544.58338 | 2110195.50679 | 37.7746209347449 | -122.417359701486 | (37.7746209347449, -122.417359701486) | 8 | 2 | 9 | 28853 | 34 | |||
12898 | 246897 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 550 Frederick St | 4 | : | Tree | Private 2 | 10 | Width 3ft | 5996851.54862 | 2107390.70797 | 37.7663122602365 | -122.454146203593 | (37.7663122602365, -122.454146203593) | 15 | 5 | 11 | 29492 | 8 | |||
12946 | 192425 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 187 Clara St | 6 | : | Tree | Private 2 | 1 | Width 2ft | 6011952.39777 | 2111919.37561 | 37.7796012912124 | -122.402233334018 | (37.7796012912124, -122.402233334018) | 6 | 2 | 9 | 28856 | 34 | |||
12977 | 235705 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Scott St | 9 | : | Tree | Private 2 | 6 | Width 3ft | 6002413.688 | 2108646.89138 | 37.7700788062318 | -122.434997685721 | (37.7700788062318, -122.434997685721) | 15 | 5 | 5 | 29492 | 9 | |||
12986 | 189793 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 308 Hernandez Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6013450.09241 | 2105609.9853 | 37.7623606049856 | -122.396609715861 | (37.7623606049856, -122.396609715861) | 10 | 3 | 8 | 28856 | 29 | |||
13010 | 247253 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6000028.37595 | 2108519.10482 | 37.7695922091358 | -122.443239243804 | (37.7695922091358, -122.443239243804) | 15 | 5 | 11 | 29492 | 9 | |||
13054 | 201281 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 38 Lydia Ave | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6012822.1573 | 2092867.77977 | 37.7273382507444 | -122.397887653412 | (37.7273382507444, -122.397887653412) | 10 | 3 | 8 | 58 | 1 | |||
13089 | 234406 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 147 Valencia St | 1 | : | Tree | Private 2 | 20 | Width 8ft | 6006058.10348 | 2108951.831 | 37.7711223543454 | -122.422413351811 | (37.7711223543454, -122.422413351811) | 8 | 2 | 9 | 28853 | 19 | |||
13108 | 207243 | Permitted Site 7 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 324 Lakeview Ave | 1 | : | Tree | Private 2 | 08/19/2015 12:00:00 AM | 1 | Width 3ft | Permit Number 776404 | 5996808.75565 | 2089668.45236 | 37.7176488300194 | -122.453014817795 | (37.7176488300194, -122.453014817795) | 9 | 8 | 6 | 28861 | 24 | |
13256 | 204132 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 700 Junipero Serra Blvd | 110 | : | Tree | Private 2 | 1 | Width 0ft | 5991228.63223 | 2091912.68484 | 37.7234895669738 | -122.47246611402 | (37.7234895669738, -122.47246611402) | 9 | 8 | 4 | 64 | 40 | |||
13280 | 226873 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2001 Bryant St | 6 | : | Tree | Private 2 | 7 | Width 3ft | 6009581.91025 | 2105420.85963 | 37.7616252698063 | -122.409975021942 | (37.7616252698063, -122.409975021942) | 2 | 4 | 8 | 28859 | 19 | |||
13283 | 192880 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Rizal St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012900.3156 | 2112837.75427 | 37.7821758137123 | -122.399018534684 | (37.7821758137123, -122.399018534684) | 6 | 2 | 9 | 28856 | 34 | |||
13294 | 85220 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 603 22nd Ave | 3 | : | Tree | Private 2 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989076.71677 | 2111162.9995 | 37.7762210417533 | -122.481313842154 | (37.7762210417533, -122.481313842154) | 11 | 6 | 2 | 55 | 26 | ||
13379 | 250006 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Starr King Way | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6005940.10765 | 2113829.6095 | 37.784508891608 | -122.423168280499 | (37.784508891608, -122.423168280499) | 13 | 9 | 11 | 28858 | 41 | |||
13460 | 190428 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 26 | : | Tree | Private 2 | 1 | Width 3ft | 6017641.63274 | 2097108.43991 | 37.7392494942632 | -122.381521343831 | (37.7392494942632, -122.381521343831) | 10 | 3 | 8 | 58 | 1 | |||
13610 | 247805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 488 30th St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6003450.91279 | 2098365.25645 | 37.7419067175277 | -122.430676143802 | (37.7419067175277, -122.430676143802) | 2 | 7 | 5 | 63 | 22 | |||
13712 | 202138 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2639 Newhall St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6012756.67365 | 2093454.87992 | 37.728946660355 | -122.398155203507 | (37.728946660355, -122.398155203507) | 10 | 3 | 8 | 58 | 1 | |||
13727 | 246993 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 55 Clipper St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6004785.89781 | 2101026.33834 | 37.7492889788082 | -122.426249608749 | (37.7492889788082, -122.426249608749) | 2 | 4 | 5 | 28862 | 22 | |||
13928 | 193037 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1925 Evans Ave | 5 | : | Tree | Private 2 | 6 | Width 4ft | 6013937.10901 | 2099755.21268 | 37.7463117498036 | -122.394515309055 | (37.7463117498036, -122.394515309055) | 10 | 3 | 8 | 58 | 1 | |||
14040 | 190944 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1701 Newhall St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6014004.94796 | 2095137.53702 | 37.7336363433234 | -122.393957536921 | (37.7336363433234, -122.393957536921) | 10 | 3 | 8 | 58 | 1 | |||
14160 | 192815 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 666 Harrison St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6013604.81597 | 2113227.29521 | 37.7832846364215 | -122.396608578241 | (37.7832846364215, -122.396608578241) | 6 | 2 | 9 | 28856 | 6 | |||
14221 | 189868 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 401 Newhall St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6016117.80915 | 2097961.55377 | 37.7415077207098 | -122.386849571549 | (37.7415077207098, -122.386849571549) | 10 | 3 | 8 | 58 | 1 | |||
14358 | 206311 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 145 Majestic Ave | 1 | : | Tree | Private 2 | 16 | Width 3ft | 5996946.82319 | 2089129.17686 | 37.7161760165962 | -122.452498687872 | (37.7161760165962, -122.452498687872) | 9 | 8 | 6 | 28861 | 24 | |||
14420 | 235664 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6006467.28289 | 2108921.03594 | 37.7710608721893 | -122.42099579632 | (37.7710608721893, -122.42099579632) | 8 | 2 | 9 | 28853 | 19 | |||
14478 | 211030 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 165 | : | Tree | Private 2 | 4 | Width 0ft | 5991183.72988 | 2091349.85826 | 37.7219415855123 | -122.472580317121 | (37.7219415855123, -122.472580317121) | 9 | 8 | 4 | 64 | 40 | |||
14572 | 211520 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 136 Caine Ave | 1 | : | Tree | Private 2 | 7 | Width 10ft | 5997136.50298 | 2089006.99788 | 37.7158514071876 | -122.451834257948 | (37.7158514071876, -122.451834257948) | 9 | 8 | 6 | 28861 | 24 | |||
14617 | 200375 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 648 Hawthorne St | 6 | : | Tree | Private 2 | 18 | Width 3ft | 6013613.27103 | 2113399.30472 | 37.7837574055205 | -122.396591388586 | (37.7837574055205, -122.396591388586) | 6 | 2 | 9 | 28856 | 6 | |||
14618 | 247604 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900 Tompkins Ave | 9 | : | Tree | Private 2 | 13 | Width 3ft | 6009307.33621 | 2096408.35298 | 37.7368635344121 | -122.410288310675 | (37.7368635344121, -122.410288310675) | 10 | 7 | 7 | 28859 | 2 | |||
14650 | 199380 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 200 Jennings St | 18 | : | Tree | Private 2 | 15 | Width 3ft | 6018370.09073 | 2096624.46593 | 37.7379607900541 | -122.378969032793 | (37.7379607900541, -122.378969032793) | 10 | 3 | 8 | 58 | 1 | |||
14681 | 198706 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1601 Bay Shore Blvd | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6012044.34389 | 2091356.23289 | 37.7231445043056 | -122.400470439786 | (37.7231445043056, -122.400470439786) | 10 | 3 | 8 | 58 | 1 | |||
14684 | 246599 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 52 Waller St | 5 | : | Tree | Private 2 | 18 | Width 3ft | 6005448.39533 | 2109271.63735 | 37.7719660524162 | -122.42454510839 | (37.7719660524162, -122.42454510839) | 7 | 9 | 11 | 28852 | 10 | |||
14782 | 193113 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1918 Palou Ave | 1 | : | Tree | Private 2 | 18 | Width 6ft | 6013201.37448 | 2096537.6402 | 37.7374360437463 | -122.396833869195 | (37.7374360437463, -122.396833869195) | 10 | 3 | 8 | 58 | 1 | |||
14845 | 202098 | DPW Maintained 1 | Cercis canadensis :: Eastern Redbud 346 | 2650 Newhall St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6012472.96174 | 2092946.2226 | 37.7275341851331 | -122.399100333411 | (37.7275341851331, -122.399100333411) | 10 | 3 | 8 | 58 | 1 | |||
14853 | 188956 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1706 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014961.30392 | 2096622.74747 | 37.7377675329349 | -122.390754864938 | (37.7377675329349, -122.390754864938) | 10 | 3 | 8 | 58 | 1 | |||
14861 | 176144 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Lake Merced Blvd | 5 | : | Tree | Private 2 | 39 | Width 0ft | 5987593.26623 | 2090234.31177 | 37.7186700965335 | -122.484909687836 | (37.7186700965335, -122.484909687836) | 1 | 8 | 4 | 64 | 14 | |||
14885 | 204090 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 520 Garfield St | 1 | : | Tree | Private 2 | 04/13/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785246 | 5992622.63923 | 2090513.25983 | 37.7197276740608 | -122.467545605645 | (37.7197276740608, -122.467545605645) | 9 | 8 | 6 | 64 | 24 | |
14910 | 190062 | DPW Maintained 1 | Cinnamomum camphora :: Camphor Tree 90 | 601 Amador St | 14 | : | Tree | Private 2 | 8 | Width 3ft | 6017223.30586 | 2099518.56914 | 37.7458441158154 | -122.383135450667 | (37.7458441158154, -122.383135450667) | 10 | 3 | 8 | 58 | 1 | |||
15030 | 215614 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 55 | : | Tree | Private 2 | 5 | Width 0ft | 5991140.92054 | 2090646.29638 | 37.7200073002795 | -122.472677024844 | (37.7200073002795, -122.472677024844) | 9 | 8 | 4 | 64 | 40 | |||
15032 | 194567 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 382 Texas St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 6013743.43847 | 2105323.69355 | 37.7615908320593 | -122.39557507463 | (37.7615908320593, -122.39557507463) | 10 | 3 | 8 | 28856 | 29 | |||
15110 | 249752 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2500 Broderick St | 36 | : | Tree | Private 2 | 8 | Width 1ft | 6000236.97181 | 2117227.13869 | 37.7935141252181 | -122.443143217783 | (37.7935141252181, -122.443143217783) | 13 | 9 | 1 | 57 | 27 | |||
15146 | 92502 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 645 05th St | 3 | : | Tree | Private 2 | 23 | 6013059.80814 | 2110709.87576 | 37.7763420329883 | -122.398317413322 | (37.7763420329883, -122.398317413322) | 6 | 2 | 9 | 28856 | 34 | ||||
15150 | 235718 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 575 Florida St | 5 | : | Tree | Private 2 | 1 | Width 3ft | 6009281.61031 | 2105592.54154 | 37.7620798339263 | -122.411025768244 | (37.7620798339263, -122.411025768244) | 8 | 4 | 7 | 28859 | 19 | |||
15183 | 189306 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 499 Texas St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013832.17688 | 2104822.60916 | 37.7602198992576 | -122.395233060671 | (37.7602198992576, -122.395233060671) | 10 | 3 | 8 | 28856 | 29 | |||
15273 | 249329 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 814 Post St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6008232.68347 | 2114867.71891 | 37.7874883986038 | -122.415310240102 | (37.7874883986038, -122.415310240102) | 13 | 1 | 10 | 28858 | 21 | |||
15405 | 204726 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300 Junipero Serra Blvd | 30 | : | Tree | Private 2 | 5 | Width 0ft | 5991392.43358 | 2094433.51883 | 37.7304206284982 | -122.472083541544 | (37.7304206284982, -122.472083541544) | 9 | 8 | 4 | 64 | 40 | |||
15411 | 235712 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2800 18th St | 5 | : | Tree | Private 2 | 2 | Width 3ft | 6009409.0711 | 2105486.80385 | 37.7617966491233 | -122.410577461607 | (37.7617966491233, -122.410577461607) | 8 | 4 | 7 | 28859 | 19 | |||
15448 | 178519 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 74 Kelloch Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6008207.90106 | 2086273.84024 | 37.7089746188665 | -122.413373061735 | (37.7089746188665, -122.413373061735) | 9 | 7 | 8 | 309 | 39 | |||
15607 | 189834 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1698 Galvez Ave | 4 | : | Tree | Private 2 | 14 | Width 4ft | 6015429.09406 | 2098017.0802 | 37.7416220281222 | -122.389234809264 | (37.7416220281222, -122.389234809264) | 10 | 3 | 8 | 58 | 1 | |||
15804 | 250985 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 169 Seal Rock Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5981053.81587 | 2112927.80421 | 37.7805969621145 | -122.509197833038 | (37.7805969621145, -122.509197833038) | 11 | 6 | 2 | 55 | 26 | |||
15917 | 247048 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 537 Valley St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6002432.31725 | 2099137.61339 | 37.7439696696596 | -122.434253316852 | (37.7439696696596, -122.434253316852) | 2 | 7 | 5 | 63 | 22 | |||
15928 | 197140 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 53 Pomona St | 2 | : | Tree | Private 2 | 3 | Width 5ft | 6014151.58684 | 2094423.96338 | 37.7316851643341 | -122.39340063984 | (37.7316851643341, -122.39340063984) | 10 | 3 | 8 | 58 | 1 | |||
16071 | 202049 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Exeter St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6012555.81447 | 2090941.8893 | 37.7220353110641 | -122.398673311925 | (37.7220353110641, -122.398673311925) | 10 | 3 | 8 | 58 | 1 | |||
16103 | 247814 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 532 30th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6003126.49354 | 2098351.09832 | 37.7418494576778 | -122.431796869036 | (37.7418494576778, -122.431796869036) | 2 | 7 | 5 | 63 | 22 | |||
16209 | 262261 | - 12 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 290 Green St | : | Tree | Private 2 | FUF | 06/18/2020 12:00:00 AM | 3 | Permit Number 785454 | 6011550.34746 | 2119418.71162 | 37.8001702361868 | -122.404152146942 | (37.8001702361868, -122.404152146942) | 3 | 1 | 10 | 308 | 23 | ||
16210 | 193525 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2555 Phelps St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012034.50381 | 2093597.50497 | 37.7292980281618 | -122.4006618281 | (37.7292980281618, -122.4006618281) | 10 | 3 | 8 | 58 | 1 | |||
16361 | 188907 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1551 19th St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6013010.92349 | 2105173.17566 | 37.7611367706692 | -122.398098002138 | (37.7611367706692, -122.398098002138) | 10 | 3 | 8 | 28856 | 29 | |||
16376 | 190928 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1778 Quesada Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6014320.53257 | 2095360.07162 | 37.73426491189 | -122.392882024183 | (37.73426491189, -122.392882024183) | 10 | 3 | 8 | 58 | 1 | |||
16391 | 197750 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 772 Bryant St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6012005.03317 | 2110833.59776 | 37.7766229335303 | -122.401974894942 | (37.7766229335303, -122.401974894942) | 14 | 2 | 9 | 28856 | 34 | |||
16472 | 194714 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 474 Arkansas St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 6012934.12633 | 2104824.0141 | 37.7601737721161 | -122.398339113078 | (37.7601737721161, -122.398339113078) | 10 | 3 | 8 | 28856 | 29 | |||
16551 | 196136 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 893 Wisconsin St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6012789.60739 | 2103393.313 | 37.7562373289042 | -122.398738532573 | (37.7562373289042, -122.398738532573) | 10 | 3 | 8 | 28856 | 29 | |||
16604 | 213316 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 325 Howth St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 5997165.98186 | 2090264.50059 | 37.7193059055324 | -122.451823029928 | (37.7193059055324, -122.451823029928) | 9 | 8 | 6 | 28861 | 24 | |||
16684 | 201625 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 401 Galvez Ave | 7 | : | Tree | Private 2 | 11 | Width 3ft | 6021338.5629 | 2093518.11855 | 37.729594575111 | -122.368490962388 | (37.729594575111, -122.368490962388) | 10 | 3 | 8 | 58 | 1 | |||
16715 | 212653 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 238 Vernon St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5992477.51296 | 2089454.93509 | 37.7168133912952 | -122.467970312297 | (37.7168133912952, -122.467970312297) | 9 | 8 | 6 | 64 | 24 | |||
16777 | 228898 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Haight St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6005584.45074 | 2109588.27771 | 37.7728431531072 | -122.424097004096 | (37.7728431531072, -122.424097004096) | 7 | 9 | 11 | 28852 | 10 | |||
16929 | 187507 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1888 Geneva Ave | 7 | : | Tree | Private 2 | 4 | Width 3ft | 6004913.95724 | 2086749.26234 | 37.7100945337938 | -122.424791216847 | (37.7100945337938, -122.424791216847) | 9 | 7 | 6 | 309 | 5 | |||
16946 | 189444 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Mendell St | 7 | : | Tree | Private 2 | 18 | Width 4ft | 6017009.92172 | 2098163.28563 | 37.7421109895326 | -122.383778964147 | (37.7421109895326, -122.383778964147) | 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) );