Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9655 | 9655 | 114155 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 128 | 1200X JUNIPERO SERRA BLVD | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||||
| 9656 | 9656 | 114151 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9657 | 9657 | 114153 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9661 | 9661 | 114148 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9677 | 9677 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9996 | 9996 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10002 | 10002 | 114158 | Significant Tree 6 | Prunus armeniaca :: Apricot 259 | 1200X JUNIPERO SERRA BLVD | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10004 | 10004 | 114140 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10011 | 10011 | 173616 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1200X JUNIPERO SERRA BLVD | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 89097 | 89097 | 114144 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 89972 | 89972 | 114147 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 118401 | 118401 | 114145 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 140509 | 140509 | 114146 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 83993 | 83993 | 114406 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 500X ARBALLO DR | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
| 93266 | 93266 | 114407 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 177 | 500X ARBALLO DR | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
| 107939 | 107939 | 114408 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 500X ARBALLO DR | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
| 109893 | 109893 | 114409 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 500X ARBALLO DR | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
| 112205 | 112205 | 114404 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 500X ARBALLO DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | |||
| 138618 | 138618 | 114405 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 500X ARBALLO DR | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
| 89824 | 89824 | 110738 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 333 | 1299x PERSIA AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6004594.0 | 2089787.0 | 37.71841743015371 | -122.42611316787901 | (37.7184174301537, -122.426113167879) | ||||
| 104170 | 104170 | 110739 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 333 | 1299x PERSIA AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6004594.0 | 2089787.0 | 37.71841743015371 | -122.42611316787901 | (37.7184174301537, -122.426113167879) | ||||
| 125443 | 125443 | 110737 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 333 | 1299x PERSIA AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6004594.0 | 2089787.0 | 37.71841743015371 | -122.42611316787901 | (37.7184174301537, -122.426113167879) | ||||
| 50102 | 50102 | 94943 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 417 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 88058 | 88058 | 94937 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 498 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 96189 | 96189 | 94940 | Significant Tree 6 | Morus alba :: White Mulberry 112 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 111560 | 111560 | 94941 | Significant Tree 6 | Morus alba :: White Mulberry 112 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 111884 | 111884 | 94939 | Significant Tree 6 | Morus alba :: White Mulberry 112 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 112975 | 112975 | 94938 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 498 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 139320 | 139320 | 94936 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 498 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 144144 | 144144 | 94944 | Significant Tree 6 | Pyrus pyrifolia 'Sainseiki' :: Asian Pear 'Sainseiki' 540 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 144883 | 144883 | 94942 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 417 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 11662 | 11662 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 0 Diaz Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.8197400002 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | ||
| 19054 | 19054 | 94934 | Significant Tree 6 | Ficus carica 'Black Mission' :: Black Mission Fig 311 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | ||||
| 81078 | 81078 | 94935 | Significant Tree 6 | Ficus carica 'Brown Turkey' :: Brown Turkey Fig 469 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | ||||
| 141804 | 141804 | 96996 | Significant Tree 6 | Malus :: Crab Apple 235 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | |||||
| 143629 | 143629 | 96998 | Significant Tree 6 | Prunus spp :: Cherry 84 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | |||||
| 52917 | 52917 | 116537 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754.0 | 2090179.0 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | |
| 96225 | 96225 | 116534 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754.0 | 2090179.0 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | |
| 101782 | 101782 | 116536 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754.0 | 2090179.0 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | |
| 111156 | 111156 | 116535 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754.0 | 2090179.0 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | |
| 108075 | 108075 | 116951 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 24 | 299 Tara St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5997754.0 | 2090179.6 | 37.7191064490611 | -122.44978436622101 | (37.7191064490611, -122.449784366221) | |||||
| 108061 | 108061 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5989494.0 | 2090180.0 | 37.7186314952818 | -122.47833572411999 | (37.7186314952818, -122.47833572412) | |||||
| 91565 | 91565 | 114074 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 18x HIGUERA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5988029.0 | 2090212.0 | 37.718634203797706 | -122.483401916227 | (37.7186342037977, -122.483401916227) | ||||
| 119334 | 119334 | 114073 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 18x HIGUERA AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5988029.0 | 2090212.0 | 37.718634203797706 | -122.483401916227 | (37.7186342037977, -122.483401916227) | ||||
| 108375 | 108375 | 111357 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 600x MANSELL ST | 1 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 48 | 3x3 | 6010142.0 | 2090267.0 | 37.720047423695505 | -122.40696976451099 | (37.7200474236955, -122.406969764511) | |||
| 89406 | 89406 | 114379 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 443X ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5988110.0 | 2090275.0 | 37.718811899837206 | -122.483126550771 | (37.7188118998372, -122.483126550771) | ||||
| 9948 | 9948 | 114067 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 Higuera Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 5987898.0 | 2090420.0 | 37.719197693995795 | -122.48386996767 | (37.7191976939958, -122.48386996767) | ||||
| 84582 | 84582 | 114072 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 454 ARBALLO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 86962 | 86962 | 114103 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 5 ACEVEDO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 103750 | 103750 | 114102 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 7 ACEVEDO AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 113595 | 113595 | 114068 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 8 HIGUERA AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5987898.0 | 2090420.0 | 37.719197693995795 | -122.48386996767 | (37.7191976939958, -122.48386996767) | ||||
| 88441 | 88441 | 114094 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 239x VIDAL DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5987668.0 | 2090475.0 | 37.7193353179991 | -122.484669012602 | (37.7193353179991, -122.484669012602) | ||||
| 83253 | 83253 | 98082 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | 525 Grafton Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5995193.7 | 2090526.9 | 37.7199132334677 | -122.45865940878001 | (37.7199132334677, -122.45865940878) | |||||
| 94574 | 94574 | 114097 | Significant Tree 6 | Pinus thunbergii :: Japanese Black Pine 306 | 221x VIDAL DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5987664.0 | 2090556.0 | 37.7195574904968 | -122.484688777519 | (37.7195574904968, -122.484688777519) | ||||
| 96627 | 96627 | 104900 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 317 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 99835 | 99835 | 104913 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 608 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 102326 | 102326 | 104898 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 310 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 118620 | 118620 | 104908 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 500 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 119511 | 119511 | 104899 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 314 Gonzalez Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 140531 | 140531 | 104916 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 700 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 142126 | 142126 | 104912 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 606 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 143237 | 143237 | 104888 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 146 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 127835 | 127835 | 114387 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 417x ARBALLO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5988152.0 | 2090574.0 | 37.7196353223366 | -122.483003277928 | (37.7196353223366, -122.483003277928) | ||||
| 80921 | 80921 | 104904 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 417 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 81710 | 81710 | 104892 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Gonzalez Dr | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | ||||||
| 124358 | 124358 | 104909 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 533 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 104018 | 104018 | 104932 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 717 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990427.0 | 2090598.0 | 37.7198333383806 | -122.47514125414499 | (37.7198333383806, -122.475141254145) | |||||
| 104403 | 104403 | 114100 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 21x ACEVEDO AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5988027.0 | 2090598.0 | 37.7196939458216 | -122.48343711113998 | (37.7196939458216, -122.48343711114) | ||||
| 118949 | 118949 | 114101 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 21x ACEVEDO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988027.0 | 2090598.0 | 37.7196939458216 | -122.48343711113998 | (37.7196939458216, -122.48343711114) | ||||
| 142616 | 142616 | 104933 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 755 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990427.0 | 2090598.0 | 37.7198333383806 | -122.47514125414499 | (37.7198333383806, -122.475141254145) | |||||
| 72156 | 72156 | 104935 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 835 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 99811 | 99811 | 104936 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 837 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 109347 | 109347 | 104937 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 839 Gonzalez Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 114209 | 114209 | 104934 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 805 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 82402 | 82402 | 114388 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 361x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 99779 | 99779 | 114394 | Significant Tree 6 | Ficus Spp. :: 253 | 134x TAPIA DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 110346 | 110346 | 114383 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 418X SERRANO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 138436 | 138436 | 114384 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 418X SERRANO DR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 5112 | 5112 | 253808 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 5144 | 5144 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Garfield St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x2 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 5161 | 5161 | 253809 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 124990 | 124990 | 107541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 GARFIELD ST | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.46287353180901 | (37.7201106425596, -122.462873531809) | ||||
| 144120 | 144120 | 114104 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 400x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 3x3 | 5988116.0 | 2090625.0 | 37.7197732605649 | -122.48313145165001 | (37.7197732605649, -122.48313145165) | |||
| 125203 | 125203 | 114389 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 345x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5988176.0 | 2090635.0 | 37.7198042094326 | -122.48292478788 | (37.7198042094326, -122.48292478788) | ||||
| 90926 | 90926 | 114099 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 201x VIDAL DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5987665.0 | 2090646.0 | 37.719804665893605 | -122.484691919383 | (37.7198046658936, -122.484691919383) | ||||
| 98711 | 98711 | 105649 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990274.6 | 2090665.2 | 37.7200090188364 | -122.475672946469 | (37.7200090188364, -122.475672946469) | |||||
| 115524 | 115524 | 117309 | Significant Tree 6 | Tree(s) :: 17 | 3711 19th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 777997 | 5990297.3 | 2090806.0 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | |
| 81776 | 81776 | 114391 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 23x PINTO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988521.0 | 2090808.0 | 37.720299292258794 | -122.481744923362 | (37.7202992922588, -122.481744923362) | ||||
| 93217 | 93217 | 114390 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 23x PINTO AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988521.0 | 2090808.0 | 37.720299292258794 | -122.481744923362 | (37.7202992922588, -122.481744923362) | ||||
| 144388 | 144388 | 114393 | Significant Tree 6 | Ficus Spp. :: 253 | 118x TAPIA DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5988638.0 | 2090878.0 | 37.72049829773871 | -122.48134562114099 | (37.7204982977387, -122.481345621141) | ||||
| 81688 | 81688 | 93931 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.5528400003 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | |||||
| 99064 | 99064 | 93932 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.5528400003 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | |||||
| 84041 | 84041 | 114392 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 104x TAPIA DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10 | 5988688.0 | 2090939.0 | 37.72066869526729 | -122.481177253578 | (37.7206686952673, -122.481177253578) | ||||
| 53190 | 53190 | 94850 | Significant Tree 6 | Tree(s) :: 17 | 1107 Bowdoin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | Permit Number 53929 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | |||
| 98300 | 98300 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1107 Bowdoin St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | ||
| 44089 | 44089 | 109772 | Significant Tree 6 | Yucca elephantipes :: Giant Yucca 211 | 2200x SAN JOSE AVE | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 5998886.0 | 2091075.0 | 37.7216297132481 | -122.44593585753599 | (37.7216297132481, -122.445935857536) | |||
| 121702 | 121702 | 95777 | Significant Tree 6 | Acer palmatum 'Sango Kaku' :: Coral Bark Maple 518 | 30 Onondaga Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/11/2011 12:00:00 AM | Permit Number 767524 | 6001190.6 | 2091111.6 | 37.721861535681704 | -122.437972107548 | (37.7218615356817, -122.437972107548) | ||||
| 111731 | 111731 | 122636 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3698X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990586.0 | 2091171.0 | 37.7214158684235 | -122.474633449984 | (37.7214158684235, -122.474633449984) | ||||
| 89464 | 89464 | 100191 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1201 Holloway Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992431.5 | 2091178.1 | 37.721542125529396 | -122.46825464021099 | (37.7215421255294, -122.468254640211) | |||||
| 88445 | 88445 | 122634 | Significant Tree 6 | Tree(s) :: 17 | 3680X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3 | 3x10 | Permit Number 779220 | 5990592.0 | 2091224.0 | 37.7215617409212 | -122.474616575991 | (37.7215617409212, -122.474616575991) |
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");