trees

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

✎ 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)
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
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
31451 114152 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 11 Front Yard : Yard Tree Private 2     8     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
69364 114151 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 10 Front Yard : Yard Tree Private 2     8     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
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
23985 114387 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 417x ARBALLO DR 1 Sidewalk: Curb side : Yard Tree Private 2     7     5988152 2090574 37.7196353223366 -122.483003277928 (37.7196353223366, -122.483003277928) 1 8 4 64 14
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
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
72430 114147 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200x JUNIPERO SERRA BLVD 4 Front Yard : Yard Tree Private 2     7     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 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
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
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
141906 114383 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 418X SERRANO DR 1 Sidewalk: Curb side : Yard Tree Private 2     6     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 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
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
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
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
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
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
126287 114225 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 99x FONT BLVD 1 Sidewalk: Curb side : Yard Tree Private 2     48     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
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
72767 114153 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200x JUNIPERO SERRA BLVD 12 Front Yard : Yard Tree Private 2     40     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
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
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
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
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
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
71845 114379 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 443X ARBALLO DR 1 Front Yard : Yard Tree Private 2     36     5988110 2090275 37.7188118998372 -122.483126550771 (37.7188118998372, -122.483126550771) 1 8 4 64 14
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
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
891 207770 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 40 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     35 Width 10ft   5993240.61068 2097284.1687 37.7383545825079 -122.465901234858 (37.7383545825079, -122.465901234858) 1 8 4 59 40
74248 208929 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 501 Saint Francis Blvd 1 Sidewalk: Curb side : Pot Tree Private 2     34 Width 6ft   5993145.62708 2096072.03007 37.735020873007 -122.466141577798 (37.735020873007, -122.466141577798) 1 8 4 59 40
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
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
20043 116577 Significant Tree 6 Shrub :: Shrub 66 3000x 19TH AVE 1 Sidewalk: Property side : Cutout Tree MTA 3 DPW   30 3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
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
43131 116576 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 2500x OCEAN AVE 1 Sidewalk: Property side : Yard Tree MTA 3 DPW   30 10X10   5991377 2094742 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256) 1 8 4 64 40
109646 114230 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 6 Sidewalk: Curb side : Yard Tree Private 2     30     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
523 92314 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2783 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985837.7861 2096464.2212 37.7356733962807 -122.491435886509 (37.7356733962807, -122.491435886509) 1 8 3 29491 35
797 260459 Significant Tree 6 Tree(s) :: 17 1798X Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2019 12:00:00 AM 3 5x10 Permit Number 784470 5992678 2095461 37.733316146518 -122.467713892437 (37.733316146518, -122.467713892437) 9 8 4 59 40
821 261708 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 20 Entrada Ct 1 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
1002 260458 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 835 Darien Way 1 Sidewalk: Property side : Yard Tree Private 2   11/19/2019 12:00:00 AM 3 6x10 Permit Number 784514 5994066 2094094 37.7296427463027 -122.462816092129 (37.7296427463027, -122.462816092129) 9 8 4 59 40
1475 80073 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2788 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5985889.2586 2096432.3825 37.735588983385 -122.491255586179 (37.735588983385, -122.491255586179) 1 8 3 64 35
1697 92318 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2787 34th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985842.0312 2096446.1793 37.7356241060746 -122.49141988223 (37.7356241060746, -122.49141988223) 1 8 3 29491 35
1773 116537 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 6 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
2591 92319 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2788 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985889.2586 2096423.8922 37.7355656712712 -122.491254961509 (37.7355656712712, -122.491254961509) 1 8 3 64 35
4096 261159 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 3 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
5577 92312 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2711 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985822.132 2096946.3119 37.7369961745626 -122.49152548244 (37.7369961745626, -122.49152548244) 1 8 3 29491 35
6364 264920 Significant Tree 6 Tree(s) :: 17 99X Everglade Dr 2 Sidewalk: Property side : Cutout Tree Private 2   11/10/2020 12:00:00 AM 3 6x10 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
6747 261157 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 1 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
6931 92315 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2783 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985839.9086 2096474.3035 37.7357012036342 -122.491429290175 (37.7357012036342, -122.491429290175) 1 8 3 29491 35
7796 264921 Significant Tree 6 Tree(s) :: 17 99X Everglade Dr 3 Sidewalk: Property side : Cutout Tree Private 2   11/10/2020 12:00:00 AM 3 6x10 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
8007 261753 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 127 Edgehill Way 3 Back Yard : Cutout Tree Private 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
9381 261160 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 4 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
9908 215094 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 218 Sadowa St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994821.63014 2087784.20309 37.7123610457095 -122.459746958272 (37.7123610457095, -122.459746958272) 9 8 6 28861 24
11618 92317 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2787 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985840.9699 2096433.9745 37.7355905329114 -122.491422653463 (37.7355905329114, -122.491422653463) 1 8 3 29491 35
11628 261752 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 127 Edgehill Way 2 Back Yard : Cutout Tree Private 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
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
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
13120 258703 Significant Tree 6 Tree(s) :: 17 131X Juan Bautista Cir 2 Sidewalk: Curb side : Yard Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783241 5989556 2089774 37.7175203194228 -122.478091750656 (37.7175203194228, -122.478091750656) 1 8 4 64 14
13252 92316 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2787 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985840.4393 2096424.4229 37.7355642757438 -122.49142378511 (37.7355642757438, -122.49142378511) 1 8 3 29491 35
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
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
15674 258702 Significant Tree 6 Tree(s) :: 17 131X Juan Bautista Cir 1 Sidewalk: Curb side : Yard Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783241 5989556 2089774 37.7175203194228 -122.478091750656 (37.7175203194228, -122.478091750656) 1 8 4 64 14
16055 260578 Significant Tree 6 Tree(s) :: 17 1879 Funston Ave 1 Sidewalk: Property side : Cutout Tree Private 2   05/22/2020 12:00:00 AM 3 Width 3ft Permit Number 784834 5992075.37659 2102679.56742 37.7531016753032 -122.470322812874 (37.7531016753032, -122.470322812874) 1 8 4 56 12
19112 261751 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 127 Edgehill Way 1 Back Yard : Cutout Tree Private 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
21303 115100 Significant Tree 6 Tree(s) :: 17 710 PACHECO ST 1 Front Yard : Cutout Tree Private 2   02/04/2016 12:00:00 AM 3 3x3 Permit Number 777305 5992727 2102215 37.7518637464828 -122.468035600741 (37.7518637464828, -122.468035600741) 1 8 4 29491 12
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
37232 256765 Significant Tree 6 Tree(s) :: 17 355 Serrano Dr 1 Sidewalk: Property side : Yard Tree Private 2   01/15/2019 12:00:00 AM 3 3x3 Permit Number 782555 5988732 2090042 37.7182083166364 -122.480959519123 (37.7182083166364, -122.480959519123) 1 8 4 64 14
45577 92320 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 2733 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM 3 3x3   5984522 2096783 37.7364716996862 -122.496008508371 (37.7364716996862, -122.496008508371) 1 8 3 29491 35
46153 209002 Significant Tree 6 Tree(s) :: 17 115 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2   07/17/2018 12:00:00 AM 3 Width 4ft Permit Number 781950 5994125 2096751 37.7369416119865 -122.462804803775 (37.7369416119865, -122.462804803775) 9 8 4 59 40
52054 255462 Significant Tree 6 Tree(s) :: 17 98 Saint Francis Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   05/24/2018 12:00:00 AM 3 10x5 Permit Number 777805 5992112.53458 2095987.97644 37.7347304251367 -122.469707196177 (37.7347304251367, -122.469707196177) 9 8 4 59 40
52558 255280 Significant Tree 6 Olea europaea :: Olive Tree 9 320 Magellan Ave 1 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
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
69013 254092 Significant Tree 6 Tree(s) :: 17 716 Gonzalez Dr 1 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
71364 115730 Significant Tree 6 Acer rubrum :: Red Maple 75 10x Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776540 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
73267 115729 Significant Tree 6 Acer rubrum :: Red Maple 75 10x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 776540 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
73343 122634 Significant Tree 6 Tree(s) :: 17 3680X 19th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   12/05/2016 12:00:00 AM 3 3x10 Permit Number 779220 5990592 2091224 37.7215617409212 -122.474616575991 (37.7215617409212, -122.474616575991) 9 8 4 64 40
81780 206842 Significant Tree 6 Tree(s) :: 17 218 Sadowa St 3 Sidewalk: Property side : Cutout Tree Private 2   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994803.1874 2087784.4983 37.712360795684 -122.45981072288 (37.712360795684, -122.45981072288) 9 8 6 28861 24
82975 255461 Significant Tree 6 Tree(s) :: 17 37 Santa Paula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/24/2018 12:00:00 AM 3 10x6 Permit Number 777804 5994021.13024 2097608.02637 37.7392888101295 -122.463226093964 (37.7392888101295, -122.463226093964) 1 8 4 59 40
83163 115737 Significant Tree 6 Acer rubrum :: Red Maple 75 9x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776557 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
84393 116534 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 3 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
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
92153 117518 Significant Tree 6 Ulmus americana :: American Elm 74 30 Santa Paula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2016 12:00:00 AM 3   Permit Number 777803 5993995.8 2097679.6 37.7394838741894 -122.463318866351 (37.7394838741894, -122.463318866351) 1 8 4 59 40
92919 115827 Significant Tree 6 Myoporum laetum :: Myoporum 62 60X CHUMASERO DR 1 Sidewalk: Property side : Cutout Tree Private 2   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777531 5990913 2088468 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941) 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
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
96718 115731 Significant Tree 6 Acer rubrum :: Red Maple 75 15 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776556 5993468.8 2097225 37.7382052810266 -122.465107977902 (37.7382052810266, -122.465107977902) 1 8 4 59 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
103685 248958 Significant Tree 6 Pinus Spp :: Pine Spp 100 98x Rosewood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/2017 12:00:00 AM 3 3x3   5994824 2095658 37.7339807377795 -122.460308897898 (37.7339807377795, -122.460308897898) 9 8 4 59 40
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
105492 116536 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 5 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
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
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
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
114772 92311 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2211 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM 3 3x3   5986022.3 2100155.2 37.7458186185696 -122.491069496457 (37.7458186185696, -122.491069496457) 1 8 3 29491 35
116051 115752 Significant Tree 6 Acer rubrum :: Red Maple 75 100 Yerba Buena Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776558 5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
117265 116346 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 121 SAN BENITO WAY 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2016 12:00:00 AM 3 3x3 Permit Number 777164 5992901 2095856 37.7344135917102 -122.466971633047 (37.7344135917102, -122.466971633047) 9 8 4 59 40

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