Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86843 | 86843 | 109377 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 96460 | 96460 | 109375 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 112237 | 112237 | 109378 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 118325 | 118325 | 109374 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 127758 | 127758 | 109376 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 139657 | 139657 | 117644 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1111X SANSOME ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x30 | 6011937.0 | 2119613.0 | 37.8007253016149 | -122.402827843034 | (37.8007253016149, -122.402827843034) | ||||
| 110212 | 110212 | 110320 | Property Tree 7 | :: 54 | 9 Imperial Aly | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | ||||||
| 84088 | 84088 | 103516 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 980 Green St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6008298.0 | 2118971.0 | 37.7987586699451 | -122.415374854445 | (37.7987586699451, -122.415374854445) | |||||
| 101483 | 101483 | 113482 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2839 Pierce St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001345.0 | 2118077.0 | 37.7959107386074 | -122.43937030854799 | (37.7959107386074, -122.439370308548) | ||||||
| 142682 | 142682 | 102752 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 2452 Green St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001313.0 | 2117994.0 | 37.7956810212331 | -122.43947508164 | (37.7956810212331, -122.43947508164) | ||||||
| 82327 | 82327 | 33793 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 83310 | 83310 | 33775 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 85637 | 85637 | 33789 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 89534 | 89534 | 33794 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 92335 | 92335 | 33787 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 112911 | 112911 | 33786 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 120104 | 120104 | 33790 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 120823 | 120823 | 33791 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 128175 | 128175 | 33776 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 128562 | 128562 | 33799 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 142955 | 142955 | 33788 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 77354 | 77354 | 33781 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x misson st | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6013804.30364325 | 2116217.11127164 | 37.7915050790356 | -122.396128026757 | (37.7915050790356, -122.396128026757) | |
| 80457 | 80457 | 104540 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 84515 | 84515 | 104544 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 94698 | 94698 | 104538 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 97796 | 97796 | 104543 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 98516 | 98516 | 104542 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 125858 | 125858 | 104539 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 138525 | 138525 | 104568 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 140502 | 140502 | 104541 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 128311 | 128311 | 98265 | Property Tree 7 | Pinus pinea :: Italian Stone Pine 143 | 755 O'Farrell St | Back Yard : Yard 13 | Tree 1 | Private 1 | Backyard tree; not significant | 6007700.0 | 2113968.3 | 37.784988860902295 | -122.417089467607 | (37.7849888609023, -122.417089467607) | |||||
| 154560 | 154560 | 110181 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 2620 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 1.5x4 | 5999902.8272 | 2114053.62 | 37.784781414472704 | -122.444071244627 | (37.7847814144727, -122.444071244627) | |||
| 98644 | 98644 | 106968 | Property Tree 7 | :: 54 | 351 26th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.48618540122601 | (37.7828456076198, -122.486185401226) | ||||||
| 98786 | 98786 | 100139 | Property Tree 7 | Tree(s) :: 17 | 155 05th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.782125333955705 | -122.40549178692301 | (37.7821253339557, -122.405491786923) | ||||
| 145060 | 145060 | 102056 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 332 19th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5990007.7 | 2113121.3 | 37.781652074321705 | -122.47823656971501 | (37.7816520743217, -122.478236569715) | |||||
| 631 | 631 | 251294 | Property Tree 7 | :: 54 | 7126 Geary Blvd | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5984860.0 | 2112552.0 | 37.779788778901796 | -122.49600289252199 | (37.7797887789018, -122.496002892522) | ||||
| 114652 | 114652 | 97162 | Property Tree 7 | Malus :: Crab Apple 235 | 478 10th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | Tree in backyard on private property; not significant. | 5992861.5 | 2112216.7 | 37.7793335349967 | -122.468298031686 | (37.7793335349967, -122.468298031686) | |||||
| 102208 | 102208 | 110843 | Property Tree 7 | Pseudotsuga menziesii :: Douglas Fir 231 | 2037 TURK BLVD | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6000252.0 | 2111948.0 | 37.779019836036206 | -122.442711981138 | (37.7790198360362, -122.442711981138) | |||||
| 100224 | 100224 | 91109 | Property Tree 7 | Tree(s) :: 17 | 2650 Turk Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 103103 | 103103 | 91108 | Property Tree 7 | Tree(s) :: 17 | 2650 Turk Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 92938 | 92938 | 99277 | Property Tree 7 | Tree(s) :: 17 | 85X 10th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517.0 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | |||
| 97530 | 97530 | 99275 | Property Tree 7 | Tree(s) :: 17 | 85X 10th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517.0 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | |||
| 125343 | 125343 | 99276 | Property Tree 7 | Tree(s) :: 17 | 85X 10th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517.0 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | |||
| 2595 | 2595 | 253142 | Property Tree 7 | Juniperus silicicola :: Southern red cedar 186 | 735 29th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5986898.0 | 2110914.0 | 37.7754104499772 | -122.48883220977301 | (37.7754104499772, -122.488832209773) | ||||
| 2606 | 2606 | 253143 | Property Tree 7 | Juniperus silicicola :: Southern red cedar 186 | 735 29th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5986898.0 | 2110914.0 | 37.7754104499772 | -122.48883220977301 | (37.7754104499772, -122.488832209773) | ||||
| 113280 | 113280 | 105686 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 3 | Front Yard : Pot 30 | Tree 1 | Private 1 | 6 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
| 124771 | 124771 | 105685 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 2 | Front Yard : Pot 30 | Tree 1 | Private 1 | 8 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
| 126368 | 126368 | 105684 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 1 | Front Yard : Pot 30 | Tree 1 | Private 1 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
| 669 | 669 | 251343 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 934 Brannan St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 100855 | 100855 | 114731 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 934 BRANNAN ST | Back Yard : Yard 13 | Tree 1 | Private 1 | Dept of Real Estate 9 | 10x10 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 141354 | 141354 | 120533 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 22 | 3x3 | 6010745.0 | 2108673.0 | 37.7706200263658 | -122.40618148078501 | (37.7706200263658, -122.406181480785) | |||
| 3552 | 3552 | 253469 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 701 Stanyan St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5997178.0 | 2108423.0 | 37.7691653834469 | -122.45309160151399 | (37.7691653834469, -122.453091601514) | |||||
| 115312 | 115312 | 100244 | Property Tree 7 | Persea americana :: Avocado 113 | 71 Sanchez St | Back Yard : Yard 13 | Tree 1 | Private 1 | Interior courtyard | 6003507.0 | 2107903.0 | 37.7680982797144 | -122.431162830878 | (37.7680982797144, -122.431162830878) | |||||
| 141787 | 141787 | 103673 | Property Tree 7 | :: 54 | 64 Henry St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003097.0 | 2107420.0 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | ||||||
| 119975 | 119975 | 112668 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 129 Henry St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002668.0 | 2107340.8 | 37.766507036069605 | -122.434024647923 | (37.7665070360696, -122.434024647923) | ||||||
| 113071 | 113071 | 108574 | Property Tree 7 | Tree(s) :: 17 | 1891 15th St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7x8 | 6004884.86016 | 2107160.4412599998 | 37.7661373754728 | -122.426344078904 | (37.7661373754728, -122.426344078904) | ||||
| 91108 | 91108 | 97177 | Property Tree 7 | Tree(s) :: 17 | 257 Roosevelt Way | Back Yard : Yard 13 | Tree 1 | Private 1 | Monterey cypress tree in backyard on private property; not a Significant tree | 6000848.1 | 2107127.9 | 37.765819014897296 | -122.44030407045099 | (37.7658190148973, -122.440304070451) | |||||
| 104184 | 104184 | 104318 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 22 Beaver St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6002763.0 | 2106816.0 | 37.765071454107996 | -122.433658549479 | (37.765071454108, -122.433658549479) | ||||
| 79535 | 79535 | 96590 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 81703 | 81703 | 96593 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 85657 | 85657 | 96591 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 97416 | 97416 | 96594 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 116314 | 116314 | 96592 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 121581 | 121581 | 96589 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 109200 | 109200 | 101625 | Property Tree 7 | Fagus sylvatica :: European Beech 250 | 64 Levant St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 769362 | 6000275.9 | 2106473.5 | 37.76398959970761 | -122.442236202383 | (37.7639895997076, -122.442236202383) | ||||
| 79751 | 79751 | 105231 | Property Tree 7 | Pinus Spp :: Pine Spp 105 | 460X ROOSEVELT WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6000051.0 | 2106345.0 | 37.7636239504047 | -122.44300483360901 | (37.7636239504047, -122.443004833609) | ||||
| 78101 | 78101 | 96597 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 110024 | 110024 | 96606 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 111128 | 111128 | 96599 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 113186 | 113186 | 96604 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 113756 | 113756 | 96600 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 123910 | 123910 | 96598 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | tree 3 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 126860 | 126860 | 96602 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 128034 | 128034 | 96601 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 142264 | 142264 | 96605 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 144514 | 144514 | 96603 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 116035 | 116035 | 105232 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 460X ROOSEVELT WAY | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5999944.0 | 2106286.0 | 37.7634558498539 | -122.443370673769 | (37.7634558498539, -122.443370673769) | ||||
| 105403 | 105403 | 105236 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 235X STATES ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | ||||
| 140844 | 140844 | 102706 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1342 Funston Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992135.4 | 2106294.8 | 37.7630316255695 | -122.470378504645 | (37.7630316255695, -122.470378504645) | |||||
| 1928 | 1928 | 252837 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1929 | 1929 | 252833 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1945 | 1945 | 252839 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 99 Pond St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1948 | 1948 | 252834 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1955 | 1955 | 252835 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 120804 | 120804 | 96938 | Property Tree 7 | Tree(s) :: 17 | 1306 Cole St | Back Yard : Yard 13 | Tree 1 | Private 1 | Backyard tree on private property | 5998246.0 | 2105961.0 | 37.7624665052811 | -122.449220068104 | (37.7624665052811, -122.449220068104) | |||||
| 86057 | 86057 | 94469 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 103566 | 103566 | 94487 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 126549 | 126549 | 94468 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 1380 | 1380 | 251512 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4116x 18th St | 1 | Back Yard : Yard 13 | Tree 1 | MTA 6 | 3x3 | 6002190.0 | 2105341.0 | 37.760988934022706 | -122.43553488468001 | (37.7609889340227, -122.43553488468) | ||||
| 112498 | 112498 | 106458 | Property Tree 7 | Tree(s) :: 17 | 71 HANCOCK ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003861.6 | 2105050.0 | 37.7602847161222 | -122.429732794413 | (37.7602847161222, -122.429732794413) | ||||||
| 129004 | 129004 | 108871 | Property Tree 7 | Tree(s) :: 17 | 99x OAKWOOD ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6005305.0 | 2104962.0 | 37.760124716943295 | -122.424734485609 | (37.7601247169433, -122.424734485609) | |||||
| 82732 | 82732 | 102470 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1021 Kirkham St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5991773.0 | 2105198.0 | 37.7599991432047 | -122.471551983129 | (37.7599991432047, -122.471551983129) | |||||
| 113649 | 113649 | 102469 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1021 Kirkham St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5991773.0 | 2105198.0 | 37.7599991432047 | -122.471551983129 | (37.7599991432047, -122.471551983129) | |||||
| 119332 | 119332 | 120526 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1439 47th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 3x3 | 5981489.0 | 2105275.0 | 37.759610238830206 | -122.50712446853998 | (37.7596102388302, -122.50712446854) | |||
| 5096 | 5096 | 253768 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998692.0 | 2104165.0 | 37.7575606372552 | -122.44754823773899 | (37.7575606372552, -122.447548237739) | |||||
| 79404 | 79404 | 97051 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 795 Wisconsin St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.39877559017401 | (37.7574425906128, -122.398775590174) | |||
| 80849 | 80849 | 97052 | Property Tree 7 | Pyrus spp :: Pear Tree 291 | 795 Wisconsin St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.39877559017401 | (37.7574425906128, -122.398775590174) | |||
| 88934 | 88934 | 107130 | Property Tree 7 | Phoenix dactylifera :: Date Palm 65 | 751 DOLORES ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005081.8 | 2103948.4 | 37.7573290011944 | -122.42543429450701 | (37.7573290011944, -122.425434294507) | |||||
| 78510 | 78510 | 114817 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 100 RACCOON DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 5998725.0 | 2104028.0 | 37.757186355085004 | -122.447424250084 | (37.757186355085, -122.447424250084) | |||||
| 4447 | 4447 | 253626 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1671 Funston Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5992125.0 | 2104081.0 | 37.756952512450205 | -122.47025325330601 | (37.7569525124502, -122.470253253306) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");