trees
1,732 rows where qLegalStatus_id = 6 sorted by qCaretaker_id descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15723 | 105168 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 2 | Front Yard : Cutout | Tree | Arts Commission 19 | 23 | 3x3 | Permit Number 770204 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | ||
| 29803 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600X Oakdale Ave | 2 | Front Yard : Cutout | Tree | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.83637 | 37.735069048787 | -122.391004288315 | (37.735069048787, -122.391004288315) | 10 | 3 | 8 | 58 | 1 | |||
| 179978 | 105160 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1600X OAKDALE AVE | 1 | Front Yard : Yard | Tree | Arts Commission 19 | 13 | Permit Number 770204 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
| 3726 | 94934 | Significant Tree 6 | Ficus carica 'Black Mission' :: Black Mission Fig 265 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 | ||||
| 16142 | 94943 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 364 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
| 20461 | 104283 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 5 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 30460 | 104285 | Significant Tree 6 | Tree(s) :: 17 | 71X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 34585 | 104280 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 2 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 45754 | 94935 | Significant Tree 6 | Ficus carica 'Brown Turkey' :: Brown Turkey Fig 463 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 | ||||
| 48640 | 104279 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 59683 | 104288 | Significant Tree 6 | Tree(s) :: 17 | 137X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 67820 | 104290 | Significant Tree 6 | Tree(s) :: 17 | 11X Hare St | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 68149 | 94937 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 504 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
| 79851 | 94940 | Significant Tree 6 | Morus alba :: White Mulberry 246 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
| 126993 | 104281 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 3 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 132116 | 104289 | Significant Tree 6 | Tree(s) :: 17 | 10X Hare St | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 133125 | 104286 | Significant Tree 6 | Tree(s) :: 17 | 200X West Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 133191 | 94939 | Significant Tree 6 | Morus alba :: White Mulberry 246 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
| 138259 | 94938 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 504 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
| 144050 | 94941 | Significant Tree 6 | Morus alba :: White Mulberry 246 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
| 156652 | 104284 | Significant Tree 6 | Tree(s) :: 17 | 45X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 172566 | 94942 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 364 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
| 173631 | 96998 | Significant Tree 6 | Prunus spp :: Cherry 68 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 | |||||
| 174752 | 104282 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 4 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 175413 | 96996 | Significant Tree 6 | Malus :: Crab Apple 82 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 | |||||
| 179763 | 94944 | Significant Tree 6 | Pyrus pyrifolia 'Sainseiki' :: Asian Pear 'Sainseiki' 568 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
| 182512 | 104287 | Significant Tree 6 | Tree(s) :: 17 | 119X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 182637 | 94936 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 504 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
| 3436 | 103654 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
| 4934 | 103659 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 6834 | 103660 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 7411 | 103658 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 8509 | 103668 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 14456 | 103661 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 18988 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
| 28942 | 110737 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
| 29114 | 103653 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
| 67675 | 110738 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
| 108684 | 103655 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
| 109449 | 103656 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
| 124026 | 110739 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
| 152489 | 103652 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
| 17604 | 261710 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3555 16th St | 1 | Front Yard : Yard | Tree | Public Library 12 | 8x8 | 6003221.95473 | 2106496.25325 | 37.7642195378276 | -122.432048304209 | (37.7642195378276, -122.432048304209) | 15 | 4 | 5 | 28862 | 3 | ||||
| 42649 | 115940 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 3401x 17TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 20 | 3x3 | 6006069 | 2106010 | 37.7630453994978 | -122.422166625338 | (37.7630453994978, -122.422166625338) | 8 | 4 | 5 | 28859 | 19 | |||
| 99418 | 115942 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 3401x 17TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 3x3 | 6006069 | 2106010 | 37.7630453994978 | -122.422166625338 | (37.7630453994978, -122.422166625338) | 8 | 4 | 5 | 28859 | 19 | ||||
| 170533 | 115941 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 3401x 17TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 3x3 | 6006069 | 2106010 | 37.7630453994978 | -122.422166625338 | (37.7630453994978, -122.422166625338) | 8 | 4 | 5 | 28859 | 19 | ||||
| 61387 | 114840 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2455x HYDE ST | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x3 | 6006980 | 2120877 | 37.8039178984324 | -122.420070904619 | (37.8039178984324, -122.420070904619) | 5 | 1 | 1 | 28858 | 32 | ||||
| 78486 | 94301 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1150X Fillmore St | 5 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
| 98424 | 94303 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 6 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
| 110239 | 94295 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 2 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
| 118707 | 94293 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 1 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
| 125310 | 94299 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1150X Fillmore St | 4 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
| 144623 | 96617 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ Valencia 19th St | 251 | Sidewalk: Property side : | Tree | Rec/Park 5 | Permit Number 771218 | 6006277 | 2104934 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | 2 | 4 | 7 | 28859 | 19 | ||||
| 153073 | 94297 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1150X Fillmore St | 3 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
| 170957 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : | Tree | Rec/Park 5 | Permit Number 771218 | 6006277 | 2104934 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | 2 | 4 | 7 | 28859 | 19 | ||||
| 185499 | 94945 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 1820X Palou Ave | : Cutout | Tree | Rec/Park 5 | FUF | 04/04/2009 12:00:00 AM | 6013714.4 | 2096294.3 | 37.7367964240349 | -122.395043047708 | (37.7367964240349, -122.395043047708) | 10 | 3 | 8 | 58 | 1 | ||||
| 5747 | 94949 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
| 7373 | 96567 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 13082 | 96572 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 37736 | 101041 | Significant Tree 6 | Tree(s) :: 17 | 3750 18th St | 1 | Front Yard : Yard | Tree | SFUSD 4 | 03/15/2012 12:00:00 AM | 30 | Permit Number 769376 | 6005230 | 2105481 | 37.7615455321967 | -122.425030802687 | (37.7615455321967, -122.425030802687) | 8 | 4 | 5 | 28859 | 19 | ||
| 41336 | 96569 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 54868 | 96570 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 57870 | 96483 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 72268 | 94951 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
| 78450 | 94948 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Pomona St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
| 99609 | 96481 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 101013 | 94947 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Pomona St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
| 103743 | 96568 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 106870 | 117252 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 2 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
| 109546 | 96484 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 110019 | 96485 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 115682 | 111766 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1860 HAYES ST | 4 | Front Yard : Yard | Tree | SFUSD 4 | 5998973 | 2110255 | 37.7742982989317 | -122.447014674672 | (37.7742982989317, -122.447014674672) | 15 | 5 | 11 | 29492 | 16 | |||||
| 124067 | 96482 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 130983 | 94950 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
| 133744 | 117251 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 1 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
| 135218 | 94946 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Pomona St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
| 135340 | 96571 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 170438 | 96480 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 176886 | 117253 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 3 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
| 6915 | 116579 | Significant Tree 6 | Shrub :: Shrub 66 | 3000x 19TH AVE | 2 | Sidewalk: Property side : Cutout | Tree | MTA 3 | DPW | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 40 | |||
| 20043 | 116577 | Significant Tree 6 | Shrub :: Shrub 66 | 3000x 19TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | MTA 3 | DPW | 30 | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 40 | ||
| 32937 | 178336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 401 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | MTA 3 | 29 | Width 8ft | 5998664.9682 | 2091522.93582 | 37.7228470175482 | -122.44673211619 | (37.7228470175482, -122.44673211619) | 9 | 7 | 6 | 28861 | 25 | |||
| 36628 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.7228516427597 | -122.445718558684 | (37.7228516427597, -122.445718558684) | 9 | 7 | 6 | 28861 | 25 | |||
| 39321 | 120597 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 43131 | 116576 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 2500x OCEAN AVE | 1 | Sidewalk: Property side : Yard | Tree | MTA 3 | DPW | 30 | 10X10 | 5991377 | 2094742 | 37.7312667472315 | -122.472159374256 | (37.7312667472315, -122.472159374256) | 1 | 8 | 4 | 64 | 40 | ||
| 44800 | 120594 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 47041 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998978.57855 | 2091518.53644 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | 9 | 7 | 6 | 28861 | 25 | |||
| 49633 | 177105 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 12 | Sidewalk: Property side : Yard | Tree | MTA 3 | 4 | Width 5ft | 5998924.5969 | 2091518.78116 | 37.7228504376811 | -122.445834339179 | (37.7228504376811, -122.445834339179) | 9 | 7 | 6 | 28861 | 25 | |||
| 54303 | 178335 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 401 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | MTA 3 | 33 | Width 8ft | 5998656.04486 | 2091523.12147 | 37.7228470175503 | -122.446762975526 | (37.7228470175503, -122.446762975526) | 9 | 7 | 6 | 28861 | 25 | |||
| 57339 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard | Tree | MTA 3 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369564 | (37.7228504376851, -122.44574369564) | 9 | 7 | 6 | 28861 | 25 | |||
| 63382 | 177743 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Ocean Ave | 4 | Sidewalk: Property side : Yard | Tree | MTA 3 | 37 | 5998700.41574 | 2091522.98281 | 37.7228491714484 | -122.446609585371 | (37.7228491714484, -122.446609585371) | 9 | 7 | 6 | 28861 | 25 | ||||
| 80257 | 122411 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 8 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 90582 | 112375 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 801 ULLOA ST | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 42 | 5993401 | 2098089 | 37.7405736985828 | -122.465405140197 | (37.7405736985828, -122.465405140197) | 1 | 8 | 4 | 59 | 40 | ||||
| 92548 | 122410 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 95104 | 120593 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499x Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 34 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | |||
| 102801 | 122418 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 15 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 104414 | 120596 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 36 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | |||
| 114550 | 178337 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 401 Ocean Ave | 3 | Sidewalk: Property side : Yard | Tree | MTA 3 | 29 | 5998676.28102 | 2091524.00797 | 37.7228506076618 | -122.446693087413 | (37.7228506076618, -122.446693087413) | 9 | 7 | 6 | 28861 | 25 | ||||
| 116578 | 120595 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 124516 | 112376 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 801 ULLOA ST | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 24 | 5993401 | 2098089 | 37.7405736985828 | -122.465405140197 | (37.7405736985828, -122.465405140197) | 1 | 8 | 4 | 59 | 40 |
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) );