trees

416 rows where Police Districts = 8 and qLegalStatus_id = 6 sorted by qSiteInfo

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
75453 100529 Significant Tree 6 Tree(s) :: 17 720 Victoria St 1 Front Yard : Yard Tree Private 2   09/24/2012 12:00:00 AM     Permit Number 769203 5993611.6 2091925.6 37.723662667106 -122.464229627127 (37.723662667106, -122.464229627127) 9 8 4 59 40
75557 254361 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1749 09th Ave 1 Front Yard : Yard Tree Private 2       6x6   5993372 2103579 37.7556461665355 -122.465904219148 (37.7556461665355, -122.465904219148) 1 8 4 56 12
76411 104900 Significant Tree 6 Betula pendula :: European White Birch 253 317 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
78664 114390 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 23x PINTO AVE 1 Front Yard : Yard Tree Private 2     7     5988521 2090808 37.7202992922588 -122.481744923362 (37.7202992922588, -122.481744923362) 1 8 4 64 14
81276 114097 Significant Tree 6 Pinus thunbergii :: Japanese Black Pine 207 221x VIDAL DR 1 Front Yard : Yard Tree Private 2     14     5987664 2090556 37.7195574904968 -122.484688777519 (37.7195574904968, -122.484688777519) 1 8 4 64 14
81747 107245 Significant Tree 6 Tree(s) :: 17 140 CEDRO AVE   Front Yard : Yard Tree Private 2           5991993.7 2093259.3 37.7272312918526 -122.469919436342 (37.7272312918526, -122.469919436342) 9 8 4 59 40
82758 106514 Significant Tree 6 Tree(s) :: 17 190 EUCALYPTUS DR 2 Front Yard : Yard Tree Private 2           5990695.4 2094728.8 37.7311910349726 -122.474514801842 (37.7311910349726, -122.474514801842) 1 8 4 64 40
83312 254136 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1623 47th Ave 1 Front Yard : Yard Tree Private 2       10x6 Permit Number 781075 5981544 2104016 37.7561566229771 -122.506840869024 (37.7561566229771, -122.506840869024) 1 8 3 56 35
84029 102075 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 273 Magellan Ave 5 Front Yard : Yard Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
85339 115176 Significant Tree 6 Tree(s) :: 17 460 Pacheco St 1 Front Yard : Yard Tree Private 2   01/14/2016 12:00:00 AM   10x10 Permit Number 775764 5993727.4 2101897.6 37.7510499693469 -122.464553061226 (37.7510499693469, -122.464553061226) 1 8 4 29491 12
91798 173615 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1200X JUNIPERO SERRA BLVD 14 Front Yard : Yard Tree Private 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
93552 104749 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1X Junipero Serra Blvd Off Ramp 1 Front Yard : Yard Tree Private 2         Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719554 (37.7132507161795, -122.47185719554) 1 8 4 64 14
94784 253250 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99X Lopez Ave 1 Front Yard : Yard Tree Private 2   01/09/2018 12:00:00 AM 3 10x10 Permit Number 780226 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
95053 114148 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 7 Front Yard : Yard Tree Private 2     19     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
95583 102077 Significant Tree 6 Ulmus glabra :: Scotch Elm 531 273 Magellan Ave 7 Front Yard : Yard Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
96414 114394 Significant Tree 6 Ficus Spp. :: 101 134x TAPIA DR 1 Front Yard : Yard Tree Private 2     28     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
96682 115070 Significant Tree 6 :: 45 401 DARIEN WAY 1 Front Yard : Yard Tree Private 2     17     5992724 2094938 37.7318827746659 -122.467516839465 (37.7318827746659, -122.467516839465) 9 8 4 59 40
97021 105907 Significant Tree 6 Pinus Spp :: Pine Spp 100 1837 30TH AVE 1 Front Yard : Yard Tree Private 2     6     5986904 2102674 37.7527860393128 -122.488205804709 (37.7527860393128, -122.488205804709) 1 8 3 56 35
98635 105649 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990274.6 2090665.2 37.7200090188364 -122.475672946469 (37.7200090188364, -122.475672946469) 1 8 4 64 14
99854 104898 Significant Tree 6 Myoporum laetum :: Myoporum 62 310 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
101005 104736 Significant Tree 6 Lagunaria patersonii :: Primrose Tree 6 1499X 44th Ave 1 Front Yard : Yard Tree Private 2         Permit Number 770763 5982473.05016 2105245.16297 37.7595862228156 -122.503718978789 (37.7595862228156, -122.503718978789) 1 8 3 56 35
101814 110427 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1860 09TH AVE 2 Front Yard : Yard Tree Private 2   05/12/2015 12:00:00 AM 3   Permit Number 775447 5993494 2102835 37.7536103714224 -122.465428263995 (37.7536103714224, -122.465428263995) 1 8 4 56 12
101899 100432 Significant Tree 6 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 200X Stonecrest Dr 2 Front Yard : Yard Tree Private 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
102526 100433 Significant Tree 6 Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 200X Stonecrest Dr 3 Front Yard : Yard Tree Private 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
102553 253254 Significant Tree 6 Pinus radiata :: Monterey Pine 15 270 Castenada Ave 1 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
104010 104913 Significant Tree 6 Callistemon citrinus :: Lemon Bottlebrush 67 608 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
105349 114158 Significant Tree 6 Prunus armeniaca :: Apricot 296 1200X JUNIPERO SERRA BLVD 6 Front Yard : Yard Tree Private 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
105498 93932 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
105921 102569 Significant Tree 6 Olea europaea :: Olive Tree 9 0 Diaz Ave 1 Front Yard : Yard Tree Private 2   02/04/2013 12:00:00 AM 2   Permit Number 769785 5990053.95839 2089992.81974 37.7181500356804 -122.476386530439 (37.7181500356804, -122.476386530439) 1 8 4 64 14
106522 102073 Significant Tree 6 Pittosporum eugenioides :: Tarata 138 273 Magellan Ave 3 Front Yard : Yard Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
107089 255281 Significant Tree 6 Olea europaea :: Olive Tree 9 320 Magellan Ave 2 Front Yard : Yard Tree Private 2   05/01/2018 12:00:00 AM 3 10x20 Permit Number 781012 5994287.14264 2099988.88368 37.7458413694018 -122.462478996433 (37.7458413694018, -122.462478996433) 1 8 4 29491 40
107229 255805 Significant Tree 6 Ailanthus altissima :: Tree Of Heaven 333 2 Sola Ave 1 Front Yard : Yard Tree Private 2       10x10   5994994 2100719 37.7478867659483 -122.460087684856 (37.7478867659483, -122.460087684856) 1 8 4 29491 40
107818 98757 Significant Tree 6 Pinus radiata :: Monterey Pine 15 340 Castenada Ave 1 Front Yard : Yard Tree Private 2           5993579.1 2100062.8 37.7460035255592 -122.464932655613 (37.7460035255592, -122.464932655613) 1 8 4 29491 40
109420 114102 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 7 ACEVEDO AVE 1 Front Yard : Yard Tree Private 2     18     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
110154 102074 Significant Tree 6 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 273 Magellan Ave 4 Front Yard : Yard Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
111294 255282 Significant Tree 6 Olea europaea :: Olive Tree 9 320 Magellan Ave 3 Front Yard : Yard Tree Private 2   05/01/2018 12:00:00 AM 3 10x20 Permit Number 781012 5994287.14264 2099988.88368 37.7458413694018 -122.462478996433 (37.7458413694018, -122.462478996433) 1 8 4 29491 40
112272 105540 Significant Tree 6 Myoporum laetum :: Myoporum 62 2694 47TH AVE 1 Front Yard : Yard Tree Private 2     12     5981878.3 2096771.8 37.7362857499502 -122.505147911282 (37.7362857499502, -122.505147911282) 1 8 3 29491 35
113390 104936 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 837 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
114129 254093 Significant Tree 6 Tree(s) :: 17 716 Gonzalez Dr 2 Front Yard : Yard Tree Private 2   01/24/2018 12:00:00 AM 3 10x10 Permit Number 781051 5988732 2090042 37.7182083166364 -122.480959519123 (37.7182083166364, -122.480959519123) 1 8 4 64 14
115084 104751 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 13X JUAN BAUTISTA CIR 2 Front Yard : Yard Tree Private 2           5989494 2090180 37.7186314952818 -122.47833572412 (37.7186314952818, -122.47833572412) 1 8 4 64 14
120316 106363 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 101 URBANO DR 1 Front Yard : Yard Tree Private 2     80     5993535.8 2092458.1 37.7251204132224 -122.464530299025 (37.7251204132224, -122.464530299025) 9 8 4 59 40
124365 116951 Significant Tree 6 Araucaria heterophylla :: Norfolk Island Pine 238 299 Tara St 1 Front Yard : Yard Tree Private 2           5997754 2090179.6 37.7191064490611 -122.449784366221 (37.7191064490611, -122.449784366221) 9 8 6 28861 24
125248 106038 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 230 Lakeview Ave   Front Yard : Yard Tree Private 2         Permit Number 772456 5997013.1 2089546.6 37.7173259605404 -122.452299707743 (37.7173259605404, -122.452299707743) 9 8 6 28861 24
125330 104932 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 717 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990427 2090598 37.7198333383806 -122.475141254145 (37.7198333383806, -122.475141254145) 1 8 4 64 40
125509 254393 Significant Tree 6 Araucaria heterophylla :: Norfolk Island Pine 238 150 Granville Way 1 Front Yard : Yard Tree Private 2       10x10   5994538 2098550 37.7419049979895 -122.461507275162 (37.7419049979895, -122.461507275162) 1 8 4 59 40
126137 104937 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 839 Gonzalez Dr 2 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
127076 104193 Significant Tree 6 Calocedrus decurrens :: Incense Cedar 206 122 Arch St 1 Front Yard : Yard Tree Private 2           5992720.4 2088013.1 37.7128684825751 -122.467026013031 (37.7128684825751, -122.467026013031) 9 8 6 64 24
127778 114100 Significant Tree 6 Betula pendula :: European White Birch 253 21x ACEVEDO AVE 1 Front Yard : Yard Tree Private 2     10     5988027 2090598 37.7196939458216 -122.48343711114 (37.7196939458216, -122.48343711114) 1 8 4 64 14
128499 255151 Significant Tree 6 Araucaria bidwillii :: Bunya Bunya 551 201 Vicente St 4 Front Yard : Yard Tree Private 2       Width 3ft   5992494.60347 2097875.96956 37.7399364549038 -122.468523586018 (37.7399364549038, -122.468523586018) 1 8 4 59 40
138477 104934 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 805 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
142019 104750 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1X Junipero Serra Blvd Off Ramp 2 Front Yard : Yard Tree Private 2   08/30/2016 12:00:00 AM 3   Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719554 (37.7132507161795, -122.47185719554) 1 8 4 64 14
144280 253255 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 270 Castenada Ave 2 Front Yard : Yard Tree Private 2   01/09/2018 12:00:00 AM 3 10x10 Permit Number 780226 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
145813 173616 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1200X JUNIPERO SERRA BLVD 15 Front Yard : Yard Tree Private 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
146533 104435 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X PORTOLA DR 4 Front Yard : Yard Tree Private 2     16     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
147278 100431 Significant Tree 6 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 200X Stonecrest Dr 1 Front Yard : Yard Tree Private 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
149040 114068 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 8 HIGUERA AVE 1 Front Yard : Yard Tree Private 2     20     5987898 2090420 37.7191976939958 -122.48386996767 (37.7191976939958, -122.48386996767) 1 8 4 64 14
152541 114384 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 418X SERRANO DR 2 Front Yard : Yard Tree Private 2     6     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
154838 102479 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 760 Victoria St 5 Front Yard : Yard Tree Private 2           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167) 9 8 4 59 40
155948 102478 Significant Tree 6 Afrocarpus gracilior :: Fern Pine 89 760 Victoria St 4 Front Yard : Yard Tree Private 2           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167) 9 8 4 59 40
156777 114101 Significant Tree 6 Betula pendula :: European White Birch 253 21x ACEVEDO AVE 2 Front Yard : Yard Tree Private 2     7     5988027 2090598 37.7196939458216 -122.48343711114 (37.7196939458216, -122.48343711114) 1 8 4 64 14
157181 101138 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1290 Portola Dr 1 Front Yard : Yard Tree Private 2           5994035.6 2097938.3 37.7401964926879 -122.463200022957 (37.7401964926879, -122.463200022957) 1 8 4 59 40
159155 104908 Significant Tree 6 Myoporum laetum :: Myoporum 62 500 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
160583 104899 Significant Tree 6 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 314 Gonzalez Dr 2 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
160882 113234 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2023 43RD AVE 1 Front Yard : Yard Tree Private 2     12 3x3   5982877 2101339 37.7488847374588 -122.502032899239 (37.7488847374588, -122.502032899239) 1 8 3 29491 35
164851 103422 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1365 Portola Dr 1 Front Yard : Yard Tree Private 2         Permit Number 769779 5993416.2 2097683.7 37.7394617231066 -122.465323151466 (37.7394617231066, -122.465323151466) 1 8 4 59 40
165218 114145 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 1200x JUNIPERO SERRA BLVD 2 Front Yard : Yard Tree Private 2     6     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
168382 255283 Significant Tree 6 Olea europaea :: Olive Tree 9 320 Magellan Ave 4 Front Yard : Yard Tree Private 2   05/01/2018 12:00:00 AM 3 10x20 Permit Number 781012 5994287.14264 2099988.88368 37.7458413694018 -122.462478996433 (37.7458413694018, -122.462478996433) 1 8 4 29491 40
169388 104432 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 1601X PORTOLA DR 1 Front Yard : Yard Tree Private 2     14     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
171749 253384 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 55 Cerritos Ave 1 Front Yard : Yard Tree Private 2       10x10   5992588 2092941 37.7263916542788 -122.46784182224 (37.7263916542788, -122.46784182224) 9 8 4 59 40
172353 99662 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1337 Portola Dr 1 Front Yard : Yard Tree Private 2           5993559.3 2097744.3 37.7396363671104 -122.464832777968 (37.7396363671104, -122.464832777968) 1 8 4 59 40
173122 112354 Significant Tree 6 Tree(s) :: 17 300 Moncada Way 1 Front Yard : Yard Tree Private 2   01/04/2016 12:00:00 AM   10x10 Permit Number 775546 5992209.2 2093928.1 37.729080105492 -122.469223117768 (37.729080105492, -122.469223117768) 9 8 4 59 40
173819 104916 Significant Tree 6 Pinus radiata :: Monterey Pine 15 700 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
173820 104912 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 606 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
173894 114104 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 400x ARBALLO DR 1 Front Yard : Yard Tree Private 2     12 3x3   5988116 2090625 37.7197732605649 -122.48313145165 (37.7197732605649, -122.48313145165) 1 8 4 64 14
177784 114257 Significant Tree 6 Leptospermum quinquenervia :: Tea Tree 470 50x CHUMASERO DR 1 Front Yard : Yard Tree Private 2           5990913 2088468 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941) 1 8 4 64 14
178381 254173 Significant Tree 6 Geijera parviflora :: Australian Willow 25 1850 19th Ave 1 Front Yard : Yard Tree Private 2       3x6   5990394 2102783 37.7532883185876 -122.476144836826 (37.7532883185876, -122.476144836826) 1 8 4 56 12
180735 114146 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 1200x JUNIPERO SERRA BLVD 3 Front Yard : Yard Tree Private 2     12     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
181284 114154 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1200x JUNIPERO SERRA BLVD 13 Front Yard : Yard Tree Private 2     20     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
181383 104933 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 755 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990427 2090598 37.7198333383806 -122.475141254145 (37.7198333383806, -122.475141254145) 1 8 4 64 40
183573 104808 Significant Tree 6 Ilex aquifolium :: European Holly 390 1665 08th Ave   Front Yard : Yard Tree Private 2     40     5993673.5 2104163.7 37.7572689897716 -122.464904006701 (37.7572689897716, -122.464904006701) 1 8 4 56 12
183605 104761 Significant Tree 6 Ilex aquifolium :: European Holly 390 1665 18TH AVE   Front Yard : Yard Tree Private 2     50 9x9   5990543.2 2104073 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248) 1 8 4 56 12
184580 114393 Significant Tree 6 Ficus Spp. :: 101 118x TAPIA DR 1 Front Yard : Yard Tree Private 2     36     5988638 2090878 37.7204982977387 -122.481345621141 (37.7204982977387, -122.481345621141) 1 8 4 64 14
185053 99826 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Cascade Walk 1 Front Yard : Yard Tree Private 2           5992183.1 2103187.3 37.7545020044945 -122.469987253468 (37.7545020044945, -122.469987253468) 1 8 4 56 12
186272 104762 Significant Tree 6 Ilex aquifolium :: European Holly 390 1665 18TH AVE   Front Yard : Yard Tree Private 2     50 9x9   5990543.2 2104073 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248) 1 8 4 56 12
187303 118359 Significant Tree 6 Pinus radiata :: Monterey Pine 15 8 Keystone Way 1 Front Yard : Yard Tree Private 2     20 3x3   5994105 2092664 37.7257185609933 -122.46257757783 (37.7257185609933, -122.46257757783) 9 8 4 59 40
187309 106198 Significant Tree 6 Juniperus scopulorum 'Pat :: Juniper Tree 'Pathfinder' 570 2101 42ND AVE 1 Front Yard : Yard Tree Private 2     18     5983206.1 2100796.8 37.7474153345648 -122.500854798087 (37.7474153345648, -122.500854798087) 1 8 3 29491 35
188942 104888 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 146 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
194270 264977 Significant Tree 6 Tree(s) :: 17 188 Yerba Buena Ave 1 Front Yard : Yard Tree Private 2   12/02/2020 12:00:00 AM 3 3x3 Permit Number 787864 5994639 2096200 37.7354582929988 -122.460987765625 (37.7354582929988, -122.460987765625) 9 8 4 59 40
194374 265048 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 959 Kirkham St 1 Front Yard : Yard Tree Private 2       20x20   5991956 2105209 37.7600399316741 -122.470919881603 (37.7600399316741, -122.470919881603) 1 8 4 56 12
150390 99101 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 55x Santa Monica Way 1 Median : Yard Tree Private 2   04/07/2012 12:00:00 AM     Permit Number 768464 5993693.6 2097654.3 37.7393969918941 -122.464361897304 (37.7393969918941, -122.464361897304) 1 8 4 59 40
51266 255290 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3353 19th Ave 1 Side Yard : Cutout Tree Private 2       3x3   5990801 2093784 37.7286029699614 -122.474080817952 (37.7286029699614, -122.474080817952) 9 8 4 64 40
2183 117295 Significant Tree 6 Tree(s) :: 17 130 CAMBON DR 1 Side Yard : Yard Tree Private 2       3x3   5990450 2089482 37.7167704112637 -122.474980331165 (37.7167704112637, -122.474980331165) 1 8 4 64 14
12152 255704 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 201X Hernandez Ave 1 Side Yard : Yard Tree Private 2       10x10   5995122 2099706 37.7451126829106 -122.459571712369 (37.7451126829106, -122.459571712369) 1 8 4 59 40
26477 253808 Significant Tree 6 Tree(s) :: 17 2 Garfield St 2 Side Yard : Yard Tree Private 2   09/14/2018 12:00:00 AM 3 10x10 Permit Number 780744 5993976 2090624 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037) 9 8 6 64 24
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
63888 254137 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1619 47th Ave 1 Side Yard : Yard Tree Private 2       6x6   5981543 2104041 37.756225206981 -122.506846181577 (37.756225206981, -122.506846181577) 1 8 3 56 35
69528 253807 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 2 Garfield St 1 Side Yard : Yard Tree Private 2       10x2 Permit Number 780744 5993976 2090624 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037) 9 8 6 64 24
76823 255913 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 121 San Marcos Ave 1 Side Yard : Yard Tree Private 2       10x10   5993694 2100263 37.7465598483618 -122.464549884035 (37.7465598483618, -122.464549884035) 1 8 4 29491 40
95557 114140 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 5 Side Yard : Yard Tree Private 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
95967 254201 Significant Tree 6 Tree(s) :: 17 55X Aerial Way 1 Side Yard : Yard Tree Private 2       10x10 Permit Number 781191 5992360 2102538 37.7527294198072 -122.469328234463 (37.7527294198072, -122.469328234463) 1 8 4 56 12

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