trees

688 rows where qLegalStatus_id = 6 and qSiteInfo = "Front Yard : Yard" sorted by qCareAssistant

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Front Yard : Yard · 657 ✖
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)
6097 95161 Significant Tree 6 Acer palmatum :: Japanese Maple 216 2721 Pacific Ave   Front Yard : Yard Tree Private 2         Permit Number 54078 6001026.7 2116843.3 37.7925052022591 -122.440383162252 (37.7925052022591, -122.440383162252) 13 6 1 29490 27
6178 247627 Significant Tree 6 Pittosporum eugenioides :: Tarata 138 286 Bradford St 2 Front Yard : Yard Tree Private 2     9     6009494.82009 2096968.41626 37.7384118549208 -122.409679612627 (37.7384118549208, -122.409679612627) 10 7 7 28859 2
6296 260461 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
6334 104866 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Holladay Ave 1 Front Yard : Yard Tree Private 2           6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
7039 119606 Significant Tree 6 Myoporum laetum :: Myoporum 62 299x Avalon Ave 2 Front Yard : Yard Tree Private 2                              
7310 96412 Significant Tree 6 Acer palmatum :: Japanese Maple 216 185 Chilton Ave   Front Yard : Yard Tree Private 2   05/18/2011 12:00:00 AM     Permit Number 767805 6001587.1 2095138.7 37.732941575251 -122.436889661497 (37.732941575251, -122.436889661497) 9 7 5 63 40
7389 119599 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 4357x Mission St 1 Front Yard : Yard Tree Private 2         Permit Number 774415                    
7770 98170 Significant Tree 6 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 2324 Sacramento St   Front Yard : Yard Tree Private 2   12/22/2011 12:00:00 AM 3   Permit Number 768454 6003670.2 2115963.1 37.7902385582714 -122.431173718492 (37.7902385582714, -122.431173718492) 13 9 1 29490 27
8040 260572 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 6 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
8163 82435 Significant Tree 6 Pinus radiata :: Monterey Pine 15 51 Peralta Ave 1 Front Yard : Yard Tree Private 2   04/02/2005 12:00:00 AM 20     6010636.52703341 2100363.58782589 37.7477981742678 -122.405971235802 (37.7477981742678, -122.405971235802) 2 7 7 28859 2
8183 261995 Significant Tree 6 Phoenix spp :: Date palm (species unknown) 255 2727 Pierce St 2 Front Yard : Yard Tree Private 2   10/07/2020 12:00:00 AM 3 3x3 Permit Number 785198 6001553 2117834 37.7952553588401 -122.438633170174 (37.7952553588401, -122.438633170174) 13 9 1 57 27
8218 100711 Significant Tree 6 Tree(s) :: 17 966-968 Guerrero St 1 Front Yard : Yard Tree Private 2   09/27/2012 12:00:00 AM 14   Permit Number 769148 6005605.8 2103343.5 37.7556976788024 -122.423579088745 (37.7556976788024, -122.423579088745) 2 4 5 28859 19
8301 114726 Significant Tree 6 :: 45 520 Townsend St 2 Front Yard : Yard Tree Private 2           6012508.1 2109575.3 37.7731959986981 -122.400146236912 (37.7731959986981, -122.400146236912) 14 2 9 28853 34
8454 247630 Significant Tree 6 Pittosporum eugenioides :: Tarata 138 286 Bradford St 5 Front Yard : Yard Tree Private 2     7     6009492.89578 2096949.07994 37.7383586537362 -122.409684901541 (37.7383586537362, -122.409684901541) 10 7 7 28859 2
9218 106080 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 188 The Embarcadero 1 Front Yard : Yard Tree Private 2   03/20/2014 12:00:00 AM     Permit Number 771259 6015087.8131 2116516.98611 37.7923997963133 -122.391708043282 (37.7923997963133, -122.391708043282) 12 2 9 28855 6
9495 261033 Significant Tree 6 Tree(s) :: 17 551 Los Palmos Dr 1 Front Yard : Yard Tree Private 2   01/14/2020 12:00:00 AM 3 10x10 Permit Number 784596 5996615 2095626 37.7339957349096 -122.454114584985 (37.7339957349096, -122.454114584985) 9 7 4 59 40
9783 261822 Significant Tree 6 Acacia baileyana :: Bailey's Acacia 122 3580 21st St 2 Front Yard : Yard Tree Private 2       Width 3ft Permit Number 785112 6004538.52309 2103691.84305 37.7565938462521 -122.427294885373 (37.7565938462521, -122.427294885373) 2 4 5 28862 3
9889 116075 Significant Tree 6 Tree(s) :: 17 88 MONTCALM ST 1 Front Yard : Yard Tree Private 2           6010492 2099980 37.7467368416425 -122.406443980671 (37.7467368416425, -122.406443980671) 2 7 7 28859 2
9966 251172 Significant Tree 6 Pinus radiata :: Monterey Pine 15 363 Jersey St 2 Front Yard : Yard Tree Private 2           6002784.74363 2101501.25508 37.750479672211 -122.433203561601 (37.750479672211, -122.433203561601) 2 4 5 28862 22
9997 104935 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 835 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
10025 264885 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1279 44th Ave 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 787806 5982392 2106415 37.7627934961857 -122.504085938563 (37.7627934961857, -122.504085938563) 1 8 3 56 35
10123 257894 Significant Tree 6 Metrosideros robusta :: Northern Rata Tree 335 1776 Vallejo St 1 Front Yard : Yard Tree Private 2   01/27/2020 12:00:00 AM 3     6005064 2118169 37.7963742870274 -122.426508408066 (37.7963742870274, -122.426508408066) 13 9 1 28858 17
10162 230434 Significant Tree 6 Magnolia x soulangiana :: Saucer Magnolia 147 272 Anderson St 1 Front Yard : Yard Tree Private 2     9 Width 3ft   6007874.82314 2097362.07469 37.7394018403099 -122.415308650074 (37.7394018403099, -122.415308650074) 2 7 7 28859 2
10260 261386 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 97 31 Abbey St 1 Front Yard : Yard Tree Private 2       3x3   6004642 2106187 37.7634508076606 -122.427114742536 (37.7634508076606, -122.427114742536) 8 4 5 28862 3
10379 95953 Significant Tree 6 Tree(s) :: 17 499 Buena Vista East Ave   Front Yard : Yard Tree Private 2   03/18/2011 12:00:00 AM 21   Permit Number 57015 6000177 2107098 37.7656986843565 -122.442623109531 (37.7656986843565, -122.442623109531) 15 5 5 29492 3
10661 114250 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 131 FONT BLVD 1 Front Yard : Yard Tree Private 2     36     5990844 2088883 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248) 1 8 4 64 14
10910 120918 Significant Tree 6 Tree(s) :: 17 555x SAN JOSE AVE 2 Front Yard : Yard Tree Private 2   11/07/2016 12:00:00 AM 3 3x3 Permit Number 778877 6006305 2100249 37.747240333103 -122.420941331562 (37.747240333103, -122.420941331562) 2 7 7 28859 2
10947 94850 Significant Tree 6 Tree(s) :: 17 1107 Bowdoin St 1 Front Yard : Yard Tree Private 2   11/17/2010 12:00:00 AM     Permit Number 53929 6009593 2091048 37.7221611506882 -122.408922553301 (37.7221611506882, -122.408922553301) 10 3 7 309 28
11442 260571 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 5 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
11875 260569 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 3 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
12033 259149 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 150 Lenox Way 1 Front Yard : Yard Tree Private 2       5x5   5993309.4847 2098463.34097 37.7415962663129 -122.465748753199 (37.7415962663129, -122.465748753199) 1 8 4 59 40
12063 95300 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 701 Golden Gate Ave   Front Yard : Yard Tree Private 2   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617 -122.422419858646 (37.780652317617, -122.422419858646) 7 9 11 28852 41
12225 102131 Significant Tree 6 Tree(s) :: 17 850 Treat Ave 1 Front Yard : Yard Tree Private 2   12/24/2012 12:00:00 AM     Permit Number 769452 6008548.2 2103592.2 37.7565461982029 -122.413420887965 (37.7565461982029, -122.413420887965) 2 4 7 28859 19
12244 261985 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 1500x Bancroft Ave   Front Yard : Yard Tree Private 2           6014696 2091834 37.7246038778524 -122.391337493735 (37.7246038778524, -122.391337493735) 10 3 8 58 1
12273 261709 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 20 Entrada Ct 2 Front Yard : Yard Tree Private 2   02/21/2020 12:00:00 AM 3 3x3 Permit Number 783258 5992481.8221 2092418.55282 37.724951011222 -122.468170882637 (37.724951011222, -122.468170882637) 9 8 4 59 40
12344 247628 Significant Tree 6 Pittosporum eugenioides :: Tarata 138 286 Bradford St 3 Front Yard : Yard Tree Private 2     9     6009493.85882 2096962.27736 37.7383949449624 -122.409682503062 (37.7383949449624, -122.409682503062) 10 7 7 28859 2
12731 107057 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 601X Davis St 2 Front Yard : Yard Tree Private 2   07/23/2014 12:00:00 AM 9   Permit Number 771755 6013145.32204 2118507.86888 37.7977582696821 -122.398568926718 (37.7977582696821, -122.398568926718) 3 1 10 28860 6
12868 111864 Significant Tree 6 Callistemon citrinus :: Lemon Bottlebrush 67 45 Allston Way 1 Front Yard : Yard Tree Private 2   06/26/2015 12:00:00 AM 3   Permit Number 775591 5994228.4 2098418 37.7415247340782 -122.462568190827 (37.7415247340782, -122.462568190827) 1 8 4 59 40
12923 237906 Significant Tree 6 Tree(s) :: 17 3937 21st St 3 Front Yard : Yard Tree Private 2   10/06/2020 12:00:00 AM 3 Width 3ft Permit Number 785171 6002245.41508 2103514.00804 37.7559756019151 -122.43521254633 (37.7559756019151, -122.43521254633) 2 4 5 28862 22
13149 260567 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 1 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
13301 114388 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 361x ARBALLO DR 1 Front Yard : Yard Tree Private 2     7     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
13325 259319 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1746 20th Ave 1 Front Yard : Yard Tree Private 2       3x3   5990028 2103516 37.7552797120334 -122.477464095722 (37.7552797120334, -122.477464095722) 1 8 3 56 35
13777 261032 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 438 Roosevelt Way 2 Front Yard : Yard Tree Private 2       Width 3ft   6000030.97008 2106544.70148 37.7641711390149 -122.443088453592 (37.7641711390149, -122.443088453592) 15 5 5 29492 3
13805 119600 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 4357x Mission St 2 Front Yard : Yard Tree Private 2         Permit Number 774415                    
13981 261996 Significant Tree 6 Phoenix spp :: Date palm (species unknown) 255 2727 Pierce St 1 Front Yard : Yard Tree Private 2   10/07/2020 12:00:00 AM 3 3x3 Permit Number 785198 6001553 2117834 37.7952553588401 -122.438633170174 (37.7952553588401, -122.438633170174) 13 9 1 57 27
14326 112045 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2418 Pacific Ave 1 Front Yard : Yard Tree Private 2   06/26/2020 12:00:00 AM 3 3x3 Permit Number 785474 6002446.95594 2117111.03197 37.7933210893366 -122.435488200226 (37.7933210893366, -122.435488200226) 13 9 1 29490 27
14608 259056 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99 Cedro Ave 1 Front Yard : Yard Tree Private 2   10/09/2019 12:00:00 AM 3 3x3 Permit Number 784357 5992279 2093128 37.7268872622364 -122.468923614031 (37.7268872622364, -122.468923614031) 9 8 4 59 40
14822 96765 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 184 Edgewood Ave 1 Front Yard : Yard Tree Private 2   07/12/2011 12:00:00 AM     Permit Number 767998 5996632 2105999 37.7624783944866 -122.454805014883 (37.7624783944866, -122.454805014883) 15 5 11 29492 12
14866 259322 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1721 19th Ave 1 Front Yard : Yard Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783194 5990247 2103661 37.7556905489205 -122.476717329726 (37.7556905489205, -122.476717329726) 1 8 3 56 35
15065 261762 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 2943 Harrison St 1 Front Yard : Yard Tree Private 2       Width 3ft   6009034.67775 2101326.83516 37.7503533174728 -122.411578417814 (37.7503533174728, -122.411578417814) 2 4 7 28859 19
15093 119607 Significant Tree 6 Pinus radiata :: Monterey Pine 15 299x Avalon Ave 3 Front Yard : Yard Tree Private 2                              
15224 264691 Significant Tree 6 Leucodendron argenteum :: Silver Tree 46 1560 Plymouth Ave 1 Front Yard : Yard Tree Private 2       10x10   5995798 2094356 37.730461740667 -122.45684736471 (37.730461740667, -122.45684736471) 9 7 4 28861 40
15289 119601 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 4357x Mission St 3 Front Yard : Yard Tree Private 2         Permit Number 774415                    
15509 258701 Significant Tree 6 Tree(s) :: 17 206 Edgewood Ave 1 Front Yard : Yard Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783089 5996625 2105876 37.7621402663071 -122.454820337862 (37.7621402663071, -122.454820337862) 15 5 11 29492 12
15657 259657 Significant Tree 6 Tree(s) :: 17 132 Sagamore St 1 Front Yard : Yard Tree Private 2       3x3   5995545 2087474 37.7115508726991 -122.457224363425 (37.7115508726991, -122.457224363425) 9 8 6 28861 24
15911 105081 Significant Tree 6 :: 45 344 Fulton St 1 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
16054 247629 Significant Tree 6 Pittosporum eugenioides :: Tarata 138 286 Bradford St 4 Front Yard : Yard Tree Private 2     12     6009493.3855 2096955.46231 37.7383762057861 -122.409683658684 (37.7383762057861, -122.409683658684) 10 7 7 28859 2
16256 260911 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2035 15th Ave 1 Front Yard : Yard Tree Private 2       Width 3ft   5991575 2101572 37.7500316406912 -122.471972478281 (37.7500316406912, -122.471972478281) 1 8 4 29491 12
17108 105086 Significant Tree 6 :: 45 344 Fulton St 6 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
17429 103965 Significant Tree 6 Tree(s) :: 17 141 Marview Way 1 Front Yard : Yard Tree Private 2   07/11/2013 12:00:00 AM     Permit Number 770303 5998318.6 2103174 37.7548182509721 -122.448768222318 (37.7548182509721, -122.448768222318) 1 5 4 63 38
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
17949 100194 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 2 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
18320 261763 Significant Tree 6 Pinus radiata :: Monterey Pine 15 315 Montcalm St 1 Front Yard : Yard Tree Private 2       3x3   6009577 2099558 37.7455268923792 -122.409578193595 (37.7455268923792, -122.409578193595) 2 7 7 28859 2
18324 109414 Significant Tree 6 Persea americana :: Avocado 34 4 GUY PL 1 Front Yard : Yard Tree Private 2     14     6014378.1 2114502.6 37.7868293368446 -122.394022608955 (37.7868293368446, -122.394022608955) 6 2 9 28855 6
19246 253252 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 3 Front Yard : Yard Tree Private 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
19958 104685 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 7 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
20037 100423 Significant Tree 6 Leptospermum laevigatum :: Australian Tea Tree 47 155 Winston Dr 1 Front Yard : Yard Tree Private 2           5990788 2093142.6 37.7268410933597 -122.474078979965 (37.7268410933597, -122.474078979965) 9 8 4 64 40
20184 108109 Significant Tree 6 Tree(s) :: 17 952 CAPP ST 1 Front Yard : Yard Tree Private 2   01/06/2015 12:00:00 AM 3 3x3 Permit Number 774355 6007364.7 2101732.3 37.7513728159016 -122.417382061559 (37.7513728159016, -122.417382061559) 2 4 7 28859 19
20207 105239 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 6 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
20293 254534 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 737 Buena Vista Ave West 6 Front Yard : Yard Tree Private 2   02/27/2018 12:00:00 AM 3 10X10   5999910.14564 2107959.614 37.7680492454315 -122.443607999122 (37.7680492454315, -122.443607999122) 15 5 5 29492 9
20298 113730 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1580 Valencia St 7 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
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
20972 254094 Significant Tree 6 Pinus radiata :: Monterey Pine 15 320 Magellan Ave 1 Front Yard : Yard Tree Private 2       10x10 Permit Number 781012 5994209 2099943 37.7457108840866 -122.462745872627 (37.7457108840866, -122.462745872627) 1 8 4 29491 40
21762 100124 Significant Tree 6 Radermachera sinica :: China Doll Tree 394 40@ San Ramon Eastwood Dr 1 Front Yard : Yard Tree Private 2           5995635 2092781 37.7261278087338 -122.457296979484 (37.7261278087338, -122.457296979484) 9 7 4 28861 40
22018 106361 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1645 WEBSTER ST 2 Front Yard : Yard Tree Private 2     30     6003301.2 2114333.7 37.7857437219688 -122.432334009178 (37.7857437219688, -122.432334009178) 13 9 11 29490 13
22273 106336 Significant Tree 6 Pinus radiata :: Monterey Pine 15 112 EUGENIA AVE 1 Front Yard : Yard Tree Private 2     18     6006345.6 2098165.7 37.7415223501304 -122.420653072553 (37.7415223501304, -122.420653072553) 2 7 7 28859 2
22628 101981 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 25X Tiffany Ave 4 Front Yard : Yard Tree Private 2           6006415.7 2099833.4 37.7461054290546 -122.420529042399 (37.7461054290546, -122.420529042399) 2 7 7 28859 2
22679 108026 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 862 Kansas St   Front Yard : Yard Tree Private 2         Permit Number 774734 6011570 2104296 37.7586478799274 -122.403019866682 (37.7586478799274, -122.403019866682) 10 3 8 28856 29
22846 105861 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 2 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
22915 92852 Significant Tree 6 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 3794 16th St 1 Front Yard : Yard Tree Private 2   12/14/2009 12:00:00 AM     Permit Number 53072 6001901 2106436 37.7639791186972 -122.436612788339 (37.7639791186972, -122.436612788339) 15 5 5 28862 3
22976 103600 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 50X Hermann St 1 Front Yard : Yard Tree Private 2           6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
23065 98547 Significant Tree 6 Pinus radiata :: Monterey Pine 15 555@Rio Teresita Blvd 3 Front Yard : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
23401 114142 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99 Divisadero St   Front Yard : Yard Tree Private 2           6001906.1 2108188.4 37.7687910682296 -122.436720598265 (37.7687910682296, -122.436720598265) 15 5 5 29492 3
23740 255978 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 1 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
23771 105863 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 4 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
23877 105554 Significant Tree 6 Maytenus boaria :: Mayten 58 410 Elizabeth St 1 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
24668 97534 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 203 Surrey St 1 Front Yard : Yard Tree Private 2         Permit Number 768282 6002070 2096079.6 37.7355525046422 -122.435287431957 (37.7355525046422, -122.435287431957) 2 7 5 63 7
24819 122688 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 2590 Pacific Ave 1 Front Yard : Yard Tree Private 2     16 3x8   6001760 2117029 37.7930568116395 -122.43785923272 (37.7930568116395, -122.43785923272) 13 6 1 29490 27
24833 104679 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 1 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
24927 107413 Significant Tree 6 Pseudotsuga menziesii :: Douglas Fir 285 276 Yerba Buena Ave 1 Front Yard : Yard Tree Private 2     28     5995080.66446 2095640.15746 37.7339465073544 -122.459420244296 (37.7339465073544, -122.459420244296) 9 8 4 59 40
25337 106567 Significant Tree 6 Tree(s) :: 17 50 Mendell St 1 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
25451 105226 Significant Tree 6 Tree(s) :: 17 1150X Golden Gate Ave 1 Front Yard : Yard Tree Private 2   01/02/2014 12:00:00 AM     Permit Number 771276 6004329.61165 2112216.22051 37.7799879097685 -122.428625001082 (37.7799879097685, -122.428625001082) 7 9 11 29490 41
26236 99105 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1400@ Mendell Evans Ave 1 Front Yard : Yard Tree Private 2   04/09/2012 12:00:00 AM     Permit Number 768768 6016404 2098045.1 37.7417529632601 -122.385865834439 (37.7417529632601, -122.385865834439) 10 3 8 58 1
26401 114389 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 345x ARBALLO DR 1 Front Yard : Yard Tree Private 2     8     5988176 2090635 37.7198042094326 -122.48292478788 (37.7198042094326, -122.48292478788) 1 8 4 64 14
27545 115090 Significant Tree 6 Tree(s) :: 17 121 Topaz Way 1 Front Yard : Yard Tree Private 2   01/11/2016 12:00:00 AM     Permit Number 776934 6001846.4 2098050 37.7409500647868 -122.436201464472 (37.7409500647868, -122.436201464472) 2 7 5 63 7
27763 105240 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 10 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
27944 252826 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 3852 17th St 5 Front Yard : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
28176 114157 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200x JUNIPERO SERRA BLVD 18 Front Yard : Yard Tree Private 2     32     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
28198 106364 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 155 BORICA ST 1 Front Yard : Yard Tree Private 2           5992696 2092292.5 37.7246172684066 -122.467421338179 (37.7246172684066, -122.467421338179) 9 8 4 59 40
28531 173636 Significant Tree 6 Tree(s) :: 17 2590 Pacific Ave 2 Front Yard : Yard Tree Private 2   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760 2117029 37.7930568116395 -122.43785923272 (37.7930568116395, -122.43785923272) 13 6 1 29490 27

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);