trees
1,732 rows where qLegalStatus_id = 6 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38960 | 103564 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 878 14th St | 2 | Front Yard : Yard | Tree | Private 2 | 13 | Permit Number 770193 | 6002986 | 2107714 | 37.7675497941952 | -122.432951409123 | (37.7675497941952, -122.432951409123) | 15 | 5 | 5 | 28862 | 3 | |||
39032 | 251604 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 48R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999482 | 2100041 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | 2 | 7 | 5 | 63 | 22 | |||||
39128 | 251719 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1301 Clayton St | 1 | Side Yard : Yard | Tree | Private 2 | 5999055 | 2105304 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | 15 | 5 | 5 | 28862 | 12 | |||||
39382 | 114391 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 23x PINTO AVE | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 5988521 | 2090808 | 37.7202992922588 | -122.481744923362 | (37.7202992922588, -122.481744923362) | 1 | 8 | 4 | 64 | 14 | ||||
39481 | 101978 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6006502 | 2099737 | 37.7458455996049 | -122.420223786963 | (37.7458455996049, -122.420223786963) | 2 | 7 | 7 | 28859 | 2 | ||||
39513 | 98455 | Significant Tree 6 | Washingtonia filifera :: California Fan Palm 176 | 2200 22nd St | 1 | Front Yard : Yard | Tree | Private 2 | 6011565.2 | 2103754.7 | 37.7571613219705 | -122.402998394603 | (37.7571613219705, -122.402998394603) | 10 | 3 | 8 | 28856 | 29 | |||||
39514 | 108244 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 Conrad St | 1 | Back Yard : Cutout | Tree | Private 2 | 20 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
39757 | 104892 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 Gonzalez Dr | Front Yard : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | ||||||
39795 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
40036 | 104493 | Significant Tree 6 | Acer circinatum :: Vine Maple 452 | 171 SAN MARCOS AVE | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770388 | 5993514 | 2100282 | 37.7466016393389 | -122.465173679454 | (37.7466016393389, -122.465173679454) | 1 | 8 | 4 | 29491 | 40 | ||||
40158 | 253917 | Significant Tree 6 | Eriobotrya japonica :: Edible Loquat 119 | 1819 Mason St | 1 | Front Yard : Yard | Tree | Private 2 | 6009087 | 2119549 | 37.8003900283184 | -122.412685532944 | (37.8003900283184, -122.412685532944) | 3 | 1 | 10 | 308 | 32 | |||||
40225 | 99859 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 4443 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | ||||
40244 | 115123 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
40516 | 254236 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 1 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 29492 | 16 | |||||
41027 | 113738 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 15 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
41301 | 108215 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 865 EL CAMINO DEL MAR | 1 | Front Yard : Yard | Tree | Private 2 | 5985761 | 2114995 | 37.7865492821054 | -122.493065995445 | (37.7865492821054, -122.493065995445) | 11 | 6 | 1 | 55 | 33 | |||||
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 | ||||
41877 | 114072 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 454 ARBALLO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
42183 | 110954 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 126X Mendell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6017060.74507 | 2098543.22184 | 37.7431570265693 | -122.383629676533 | (37.7431570265693, -122.383629676533) | 10 | 3 | 8 | 58 | 1 | |||
42469 | 251630 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 8R Amethyst Way | 2 | Back Yard : Yard | Tree | Private 2 | 5999237 | 2100032 | 37.7462435599048 | -122.445366249721 | (37.7462435599048, -122.445366249721) | 2 | 7 | 5 | 63 | 22 | |||||
42536 | 97945 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2 Mendosa Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.7489597362933 | -122.464854121346 | (37.7489597362933, -122.464854121346) | 1 | 8 | 4 | 29491 | 40 | ||||
42851 | 113727 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 4 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
42888 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Hiliritas Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | 2 | 7 | 5 | 63 | 7 | ||||
43239 | 258527 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 50 Hermann St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
43381 | 104682 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 4 | Front Yard : Yard | Tree | Private 2 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | 8 | 2 | 9 | 28853 | 34 | ||||
43399 | 117435 | Significant Tree 6 | Salix babylonica :: Weeping Willow 308 | 98X CLIPPER ST | 1 | Back Yard : Yard | Tree | Private 2 | 6004559 | 2101087 | 37.7494427139243 | -122.427038546128 | (37.7494427139243, -122.427038546128) | 2 | 4 | 5 | 28862 | 22 | |||||
43517 | 88608 | Significant Tree 6 | Tree(s) :: 17 | 350 Urbano Dr | 1 | Front Yard : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | Permit Number 51562 | 5991996 | 2092560 | 37.7253113201117 | -122.469860593138 | (37.7253113201117, -122.469860593138) | 9 | 8 | 4 | 59 | 40 | |||
43597 | 78107 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 970 GUERRERO ST | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6005649.9 | 2103318.5 | 37.7556315237614 | -122.423424799558 | (37.7556315237614, -122.423424799558) | 2 | 4 | 5 | 28859 | 19 | ||||
43892 | 99623 | Significant Tree 6 | Tree(s) :: 17 | 380 Connecticut St | 1 | Front Yard : Yard | Tree | Private 2 | 05/23/2012 12:00:00 AM | Permit Number 768850 | 6013171.4 | 2105301.7 | 37.7614986071193 | -122.397551993257 | (37.7614986071193, -122.397551993257) | 10 | 3 | 8 | 28856 | 29 | |||
44052 | 114240 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x FONT BLVD | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | |||||
44150 | 105208 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 2694 47TH AVE | Front Yard : Yard | Tree | Private 2 | 5981878.3 | 2096771.8 | 37.7362857499502 | -122.505147911282 | (37.7362857499502, -122.505147911282) | 1 | 8 | 3 | 29491 | 35 | ||||||
44457 | 252830 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 9 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
44600 | 107186 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 945 Sacramento St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.408109042355 | (37.7928004918921, -122.408109042355) | 3 | 1 | 10 | 28857 | 4 | ||||
44804 | 114228 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
45348 | 93222 | Significant Tree 6 | Tree(s) :: 17 | 85 Santa Rita Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/26/2010 12:00:00 AM | Permit Number 53213 | 5993788 | 2100441 | 37.7470540096767 | -122.464237765204 | (37.7470540096767, -122.464237765204) | 1 | 8 | 4 | 29491 | 40 | |||
45541 | 92053 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1001 Potrero Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | |||||
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 | ||||
45867 | 107185 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 10 Florence St | 1 | Front Yard : Cutout | Tree | Private 2 | Permit Number 773363 | 6008515.42073 | 2118375.20615 | 37.7971349853662 | -122.41458032272 | (37.7971349853662, -122.41458032272) | 5 | 1 | 10 | 308 | 21 | ||||
46337 | 115125 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
46495 | 85086 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
46691 | 258502 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 3321 16th St | 2 | Front Yard : Yard | Tree | Private 2 | 6004551.31558 | 2106568.33958 | 37.7644927464624 | -122.427455559127 | (37.7644927464624, -122.427455559127) | 8 | 4 | 5 | 28862 | 3 | |||||
46751 | 105555 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 410 Elizabeth St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 772516 | 6003623.1 | 2102191.9 | 37.7524235434098 | -122.430353733326 | (37.7524235434098, -122.430353733326) | 2 | 4 | 5 | 28862 | 22 | ||||
47218 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1160 Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.401550680127 | (37.8018575696458, -122.401550680127) | 3 | 1 | 10 | 28860 | 6 | |||
47325 | 104683 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 5 | Front Yard : Yard | Tree | Private 2 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | 8 | 2 | 9 | 28853 | 34 | ||||
47483 | 113358 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
47565 | 116834 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
47695 | 104013 | Significant Tree 6 | Fremontodendron spp :: Flannel Bush Tree 107 | 3978 Sacramento St | 1 | Front Yard : Yard | Tree | Private 2 | 07/24/2013 12:00:00 AM | Permit Number 770312 | 5995753.1 | 2114886.6 | 37.7868309532778 | -122.458488162336 | (37.7868309532778, -122.458488162336) | 11 | 6 | 1 | 54 | 31 | |||
48151 | 98950 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 10 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
48200 | 108097 | Significant Tree 6 | Tree(s) :: 17 | 3370 Washington St | 2 | Front Yard : Cutout | Tree | Private 2 | 5998663.3699 | 2115944.31994 | 37.789901994506 | -122.448495552231 | (37.789901994506, -122.448495552231) | 13 | 6 | 1 | 54 | 31 | |||||
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 | |||
48723 | 96186 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 3 | Sidewalk: Property side : | Tree | Private 2 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | 6 | 2 | 9 | 28855 | 6 | ||||
48743 | 253145 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 801X Santiago St | 1 | Side Yard : Yard | Tree | Private 2 | 5990274 | 2099728 | 37.7448931297685 | -122.476336677657 | (37.7448931297685, -122.476336677657) | 1 | 8 | 3 | 29491 | 35 | |||||
48765 | 98082 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 525 Grafton Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5995193.7 | 2090526.9 | 37.7199132334677 | -122.45865940878 | (37.7199132334677, -122.45865940878) | 9 | 8 | 6 | 28861 | 24 | |||||
48978 | 87197 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 617 Sanchez St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 50213 | 6003760 | 2104634 | 37.7591367256626 | -122.430054504807 | (37.7591367256626, -122.430054504807) | 2 | 4 | 5 | 28862 | 3 | ||||
49109 | 104146 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1710-1738 Diamond St | 1 | Front Yard : Yard | Tree | Private 2 | 40 | 6001979.7 | 2099047.6 | 37.7436968136687 | -122.435811922611 | (37.7436968136687, -122.435811922611) | 2 | 7 | 5 | 63 | 22 | ||||
49235 | 110583 | Significant Tree 6 | Phoenix canariensis :: Canary Island Date Palm 160 | 46 COOK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 5997534 | 2113434 | 37.782944683725 | -122.452221842699 | (37.782944683725, -122.452221842699) | 15 | 6 | 1 | 54 | 31 | ||||
49649 | 105844 | Significant Tree 6 | Tree(s) :: 17 | 355 Buena Vista Ave | Front Yard : Yard | Tree | Private 2 | 03/03/2014 12:00:00 AM | Permit Number 771052 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.440214908068 | (37.767492540377, -122.440214908068) | 15 | 5 | 5 | 29492 | 3 | ||||
50063 | 105765 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 95 ORA WAY | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6001454.9 | 2097857 | 37.7403978808149 | -122.437541306682 | (37.7403978808149, -122.437541306682) | 2 | 7 | 5 | 63 | 7 | ||||
50429 | 99288 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 845 Marina Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998881.62913 | 2121328.006 | 37.8046966310161 | -122.448128205765 | (37.8046966310161, -122.448128205765) | 13 | 9 | 1 | 57 | 17 | ||
50522 | 93931 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | Front Yard : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.55284 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | 1 | 8 | 4 | 64 | 14 | |||||
50525 | 173933 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 190 Beacon St | 1 | Front Yard : Yard | Tree | Private 2 | 6003193 | 2097540 | 37.7396261385587 | -122.431509020833 | (37.7396261385587, -122.431509020833) | 2 | 7 | 5 | 63 | 7 | |||||
50909 | 103563 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 878 14th St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Permit Number 770193 | 6002986 | 2107714 | 37.7675497941952 | -122.432951409123 | (37.7675497941952, -122.432951409123) | 15 | 5 | 5 | 28862 | 3 | |||
51024 | 105872 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 595X San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6006124.47156 | 2100100.14306 | 37.7468214281195 | -122.421555015777 | (37.7468214281195, -122.421555015777) | 2 | 7 | 7 | 28859 | 2 | |||||
51060 | 106568 | Significant Tree 6 | Tree(s) :: 17 | 50 Mendell St | 5 | Front Yard : Yard | Tree | Private 2 | 05/09/2014 12:00:00 AM | Permit Number 772455 | 6017061.8 | 2098665.7 | 37.7434933850228 | -122.383634554004 | (37.7434933850228, -122.383634554004) | 10 | 3 | 8 | 58 | 1 | |||
51498 | 88569 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 60 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
51852 | 114156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200x JUNIPERO SERRA BLVD | 17 | Front Yard : Yard | Tree | Private 2 | 32 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
51973 | 106945 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1150 LOMBARD ST | 4 | Front Yard : Yard | Tree | Private 2 | 13 | Permit Number 773092 | 6006825 | 2120436.8 | 37.8027004869705 | -122.420576026126 | (37.8027004869705, -122.420576026126) | 5 | 1 | 1 | 28858 | 32 | |||
52128 | 112811 | Significant Tree 6 | Tree(s) :: 17 | 2023 43rd Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5982877.4 | 2101339.2 | 37.7488853101021 | -122.502031530859 | (37.7488853101021, -122.502031530859) | 1 | 8 | 3 | 29491 | 35 | |||||
52276 | 104869 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 411 Holladay Ave | 4 | Front Yard : Yard | Tree | Private 2 | Permit Number 770735 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | ||||
52672 | 251603 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 44R Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999509 | 2100035 | 37.7462673204657 | -122.444425925791 | (37.7462673204657, -122.444425925791) | 2 | 7 | 5 | 63 | 22 | |||||
52837 | 99659 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1325 Portola Dr | 3 | Front Yard : Yard | Tree | Private 2 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | 1 | 8 | 4 | 59 | 40 | |||||
53110 | 112918 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
53862 | 173726 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1101 Connecticut St | 1 | Front Yard : Yard | Tree | Private 2 | 6013424 | 2101939 | 37.7522794251173 | -122.396442635345 | (37.7522794251173, -122.396442635345) | 10 | 3 | 8 | 28856 | 1 | |||||
54288 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | 1 | 8 | 4 | 59 | 40 | ||
54493 | 114150 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 9 | Front Yard : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
54607 | 108196 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 930 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009368.6 | 2103733.3 | 37.7569796561067 | -122.410593604092 | (37.7569796561067, -122.410593604092) | 2 | 4 | 7 | 28859 | 19 | |||||
54862 | 251605 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 48R Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999482 | 2100041 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | 2 | 7 | 5 | 63 | 22 | |||||
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 | ||||
55614 | 104904 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 417 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
55746 | 98694 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 1 | Back Yard : Yard | Tree | Private 2 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.7543910951738 | -122.455633951336 | (37.7543910951738, -122.455633951336) | 1 | 5 | 4 | 63 | 12 | |||
55812 | 101740 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 1590 Broadway | 3 | Front Yard : Yard | Tree | Private 2 | 12/21/2012 12:00:00 AM | 10 | Permit Number 769428 | 6006182.95151 | 2117984.64817 | 37.7959312951427 | -122.42262348649 | (37.7959312951427, -122.42262348649) | 13 | 9 | 10 | 28858 | 32 | ||
56286 | 112919 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
56298 | 114392 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 104x TAPIA DR | 1 | Front Yard : Cutout | Tree | Private 2 | 10 | 5988688 | 2090939 | 37.7206686952673 | -122.481177253578 | (37.7206686952673, -122.481177253578) | 1 | 8 | 4 | 64 | 14 | ||||
56372 | 107551 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 1 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
56668 | 113769 | Significant Tree 6 | Tree(s) :: 17 | 2550 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001418.65940389 | 2117313.19689891 | 37.7938177263924 | -122.439060665499 | (37.7938177263924, -122.439060665499) | 13 | 9 | 1 | 57 | 27 | |||||
57424 | 101476 | Significant Tree 6 | :: 45 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2015 12:00:00 AM | 3 | Permit Number 775316 | 6000089 | 2095440.1 | 37.7336838892166 | -122.442090592963 | (37.7336838892166, -122.442090592963) | 9 | 7 | 4 | 63 | 40 | ||
57862 | 96848 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 1486 Innes Ave | Front Yard : Yard | Tree | Private 2 | 6016133.4 | 2096820.6 | 37.7383757570157 | -122.386716118251 | (37.7383757570157, -122.386716118251) | 10 | 3 | 8 | 58 | 1 | ||||||
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 | ||||
58321 | 114094 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 239x VIDAL DR | 1 | Front Yard : Yard | Tree | Private 2 | 24 | 5987668 | 2090475 | 37.7193353179991 | -122.484669012602 | (37.7193353179991, -122.484669012602) | 1 | 8 | 4 | 64 | 14 | ||||
58472 | 104728 | Significant Tree 6 | Tree(s) :: 17 | 3212 Jackson St | 1 | Front Yard : Cutout | Tree | Private 2 | 11/06/2013 12:00:00 AM | Permit Number 770525 | 5998810.5 | 2116292.9 | 37.7908675143955 | -122.448011605492 | (37.7908675143955, -122.448011605492) | 13 | 6 | 1 | 54 | 31 | |||
58489 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1435X La Salle Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770699 | 6016460.43075 | 2095036.98644 | 37.7334964128222 | -122.385461132957 | (37.7334964128222, -122.385461132957) | 10 | 3 | 8 | 58 | 1 | ||||
58651 | 100191 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1201 Holloway Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5992431.5 | 2091178.1 | 37.7215421255294 | -122.468254640211 | (37.7215421255294, -122.468254640211) | 9 | 8 | 6 | 64 | 24 | |||||
58774 | 102106 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 50X Noe St | 8 | Front Yard : Yard | Tree | Private 2 | 12/19/2012 12:00:00 AM | 25 | Permit Number 769282 | 6002816.1 | 2107996.5 | 37.7683158318555 | -122.433559261751 | (37.7683158318555, -122.433559261751) | 15 | 5 | 5 | 28862 | 3 | ||
59354 | 102987 | Significant Tree 6 | Quercus palustris :: Pin Oak 379 | 161 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 769930 | 5996558.2 | 2106100.3 | 37.7627523048829 | -122.455067580852 | (37.7627523048829, -122.455067580852) | 15 | 5 | 11 | 29492 | 12 | ||||
59395 | 114525 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
59436 | 117588 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 261 Ripley St | 1 | Front Yard : Yard | Tree | Private 2 | 06/27/2016 12:00:00 AM | 3 | Permit Number 778127 | 6009622.3 | 2099176 | 37.7444805424074 | -122.409394598776 | (37.7444805424074, -122.409394598776) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |||
59764 | 105504 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 39 MAGELLAN AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 5994694.1 | 2101166.3 | 37.7490976851152 | -122.461157135733 | (37.7490976851152, -122.461157135733) | 1 | 8 | 4 | 29491 | 40 | ||||
59834 | 253717 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 4101 Balboa St | 1 | Back Yard : Yard | Tree | Private 2 | 01/08/2018 12:00:00 AM | 3 | Permit Number 780863 | 5982822 | 2110967 | 37.7753172554615 | -122.50293574331 | (37.7753172554615, -122.50293574331) | 11 | 6 | 2 | 55 | 26 | ||
59898 | 108211 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 524 45th Ave | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 773704 | 5981973.19232 | 2112153.30127 | 37.7785245664452 | -122.505959887315 | (37.7785245664452, -122.505959887315) | 11 | 6 | 2 | 55 | 26 |
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) );