trees

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

✎ 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)
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
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
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
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
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
154657 100850 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 Estero Ave 1 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
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
24761 101258 Significant Tree 6 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1049 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992548 2106581 37.7638413023971 -122.468972303767 (37.7638413023971, -122.468972303767) 1 8 11 56 12
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
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
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
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
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
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
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
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
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
15671 104278 Significant Tree 6 Acacia spp :: Acacia Spp 105 2 Allston Way 1 Back Yard : Yard Tree Private 2           5994445.1 2098202.2 37.7409446783355 -122.461803277974 (37.7409446783355, -122.461803277974) 1 8 4 59 40
95436 104406 Significant Tree 6 Pinus radiata :: Monterey Pine 15 290 Stonecrest Dr 1 Back Yard : Yard Tree Private 2     36   Permit Number 770927 5990725 2092655 37.7254986161427 -122.474261202586 (37.7254986161427, -122.474261202586) 9 8 4 64 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
33433 104433 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X PORTOLA DR 2 Front Yard : Yard Tree Private 2     16     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
35139 104434 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X PORTOLA DR 3 Front Yard : Yard Tree Private 2     13     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
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
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
69183 104494 Significant Tree 6 Acer circinatum :: Vine Maple 452 171 SAN MARCOS AVE 2 Front Yard : Yard Tree Private 2         Permit Number 770388 5993514 2100282 37.7466016393389 -122.465173679454 (37.7466016393389, -122.465173679454) 1 8 4 29491 40
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
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
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
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
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
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
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
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
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
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
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
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
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
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
30556 104909 Significant Tree 6 Pinus radiata :: Monterey Pine 15 533 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
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
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
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
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
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
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
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
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
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
7291 105130 Significant Tree 6 Tree(s) :: 17 4045 MORAGA ST   Sidewalk: Property side : Yard Tree Private 2           5981665.2 2103465.9 37.7546533409301 -122.506380933635 (37.7546533409301, -122.506380933635) 1 8 3 56 35
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
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
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
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
156684 105850 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 44 MENDOSA AVE 1 Sidewalk: Property side : Yard Tree Private 2     100 6x15   5993395.1 2101192.7 37.7490953323683 -122.465650972372 (37.7490953323683, -122.465650972372) 1 8 4 29491 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
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
188800 106107 Significant Tree 6 Magnolia champaca :: Champa 141 135 MENDOSA AVE 1 Sidewalk: Property side : Yard Tree Private 2   04/23/2014 12:00:00 AM     Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40
122278 106109 Significant Tree 6 Magnolia champaca :: Champa 141 135 MENDOSA AVE 2 Sidewalk: Property side : Yard Tree Private 2   04/23/2014 12:00:00 AM     Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40
89112 106184 Significant Tree 6 Olea europaea :: Olive Tree 9 1327 ULLOA ST 1 Front Yard : Cutout Tree Private 2 FUF   2 4x4   5991893.8 2098371.4 37.7412620575898 -122.470636971077 (37.7412620575898, -122.470636971077) 1 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
181784 106310 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 4 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
81883 106311 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 5 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
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
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
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
137083 106962 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 218 SADOWA ST 3 Sidewalk: Property side : Cutout Tree Private 2     22     5994814 2087793.9 37.7123872323548 -122.459774032106 (37.7123872323548, -122.459774032106) 9 8 6 28861 24
127456 107197 Significant Tree 6 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 339 Kirkham St 1 Front Yard : Cutout Tree Private 2   08/07/2014 12:00:00 AM   3x3 Permit Number 773549 5993785.2645 2105241.58741 37.7602350326789 -122.464595750688 (37.7602350326789, -122.464595750688) 1 8 4 56 12
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
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
23427 107541 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2 GARFIELD ST 4 Back Yard : Yard Tree Private 2     36     5993976.6 2090624.3 37.7201106425596 -122.462873531809 (37.7201106425596, -122.462873531809) 9 8 6 64 24
66315 109521 Significant Tree 6 Tree(s) :: 17 1308 Ulloa St 1 Front Yard : Yard Tree Private 2       3x3   5991965.5 2098469.9 37.7415366593774 -122.470396231887 (37.7415366593774, -122.470396231887) 1 8 4 29491 40
101112 110321 Significant Tree 6 Ilex opaca :: American Holly 473 1x SAN PABLO AVE   Sidewalk: Curb side : Cutout Tree Private 2   04/06/2015 12:00:00 AM 3 3x3 Permit Number 774750 5994773 2097898 37.740128291439 -122.460647489756 (37.740128291439, -122.460647489756) 9 8 4 59 40
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
97746 111068 Significant Tree 6 Ilex spp :: Holly Species 81 1836 08TH AVE 1 Front Yard : Cutout Tree Private 2       3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
43207 111069 Significant Tree 6 Ilex spp :: Holly Species 81 1836 08TH AVE 3 Front Yard : Cutout Tree Private 2       3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
75962 111070 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 1836 08TH AVE 2 Front Yard : Cutout Tree Private 2     2 3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
133714 111093 Significant Tree 6 Pinus radiata :: Monterey Pine 15 100x FONT BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2015 12:00:00 AM 50 3x3 Permit Number 775594 5990916 2088996 37.715462969911 -122.473334188491 (37.715462969911, -122.473334188491) 1 8 4 64 14
34293 111094 Significant Tree 6 Pinus radiata :: Monterey Pine 15 150x FONT BLVD   Sidewalk: Curb side : Cutout Tree Private 2   06/04/2015 12:00:00 AM 30 3x3 Permit Number 775594 5990976 2089133 37.7158426125161 -122.473136789074 (37.7158426125161, -122.473136789074) 1 8 4 64 14
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
89539 112250 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 243 WINSTON DR 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990059 2093141 37.7267944442094 -122.476598971146 (37.7267944442094, -122.476598971146) 1 8 4 64 14
149763 112290 Significant Tree 6 Acer rubrum :: Red Maple 75 34 YERBA BUENA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3 3x3 Permit Number 776546 5993584 2097045 37.7377176881769 -122.464696609393 (37.7377176881769, -122.464696609393) 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
90582 112375 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 801 ULLOA ST 1 Sidewalk: Curb side : Cutout Tree MTA 3     42     5993401 2098089 37.7405736985828 -122.465405140197 (37.7405736985828, -122.465405140197) 1 8 4 59 40
124516 112376 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 801 ULLOA ST 2 Sidewalk: Curb side : Cutout Tree MTA 3     24     5993401 2098089 37.7405736985828 -122.465405140197 (37.7405736985828, -122.465405140197) 1 8 4 59 40
43088 112378 Significant Tree 6 :: 45 1850 19TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5990394 2102783 37.7532883185876 -122.476144836826 (37.7532883185876, -122.476144836826) 1 8 4 56 12
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
132771 112955 Significant Tree 6 Araucaria heterophylla :: Norfolk Island Pine 238 121X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2           5991652.84779157 2095347.0788302 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136) 9 8 4 59 40
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
92766 114034 Significant Tree 6 Ulmus pumila :: Siberian Elm 99 198x FONT BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     40 3x3   5990818 2089012 37.7155012267577 -122.473674083302 (37.7155012267577, -122.473674083302) 1 8 4 64 14
9206 114067 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 6 Higuera Ave 1 Front Yard : Cutout Tree Private 2     20     5987898 2090420 37.7191976939958 -122.48386996767 (37.7191976939958, -122.48386996767) 1 8 4 64 14
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
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
161250 114073 Significant Tree 6 Betula pendula :: European White Birch 253 18x HIGUERA AVE 1 Sidewalk: Curb side : Yard Tree Private 2     6     5988029 2090212 37.7186342037977 -122.483401916227 (37.7186342037977, -122.483401916227) 1 8 4 64 14
91742 114074 Significant Tree 6 Betula pendula :: European White Birch 253 18x HIGUERA AVE 2 Sidewalk: Curb side : Yard Tree Private 2     5     5988029 2090212 37.7186342037977 -122.483401916227 (37.7186342037977, -122.483401916227) 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
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
76029 114099 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 201x VIDAL DR 1 Sidewalk: Curb side : Cutout Tree Private 2     14     5987665 2090646 37.7198046658936 -122.484691919383 (37.7198046658936, -122.484691919383) 1 8 4 64 14
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

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