trees

142 rows where Zip Codes = 59 and qLegalStatus_id = 6 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

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)
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
13972 260573 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 129 Edgehill Way 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5994858 2098970 37.7430766268484 -122.460431252252 (37.7430766268484, -122.460431252252) 1 8 4 59 40
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
36038 115661 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 341 HAZELWOOD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5996066 2095432 37.7334315621613 -122.455998615118 (37.7334315621613, -122.455998615118) 9 7 4 59 40
40307 86910 Significant Tree 6 Ilex spp :: Holly Species 81 1 Urbano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49875 5993901 2092133 37.7242488135215 -122.463244271267 (37.7242488135215, -122.463244271267) 9 8 4 59 40
47809 116010 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 243 199x SAN BUENAVENTURA WAY 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993547 2095667 37.7339319096844 -122.464724497297 (37.7339319096844, -122.464724497297) 9 8 4 59 40
74628 88281 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 935 Ulloa St 2 Front Yard : Yard Tree Private 2   07/09/2008 12:00:00 AM   3x3 Permit Number 51275 5993125 2098282 37.7410877064311 -122.466373457073 (37.7410877064311, -122.466373457073) 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
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
104794 115276 Significant Tree 6 Pinus radiata :: Monterey Pine 15 598X PORTOLA DR 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997411 2099824 37.7455680371271 -122.451665301061 (37.7455680371271, -122.451665301061) 1 7 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
120116 116009 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 243 199x SAN BUENAVENTURA WAY 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2016 12:00:00 AM 3 3x3 Permit Number 777954 5993547 2095667 37.7339319096844 -122.464724497297 (37.7339319096844, -122.464724497297) 9 8 4 59 40
125570 253265 Significant Tree 6 Juniperus chinensis :: Juniper 113 180 San Aleso Ave 1 Front Yard : Cutout Tree Private 2   09/19/2017 12:00:00 AM 3 3x3   5993319 2094440 37.7305497238902 -122.465423653439 (37.7305497238902, -122.465423653439) 9 8 4 59 40
134725 187654 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 375 Woodside Ave 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997267 2099886 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039) 1 5 4 59 38
143508 256539 Significant Tree 6 Pinus radiata :: Monterey Pine 15 379X Cresta Vista Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997117 2096261 37.7357680647268 -122.452424833384 (37.7357680647268, -122.452424833384) 9 7 4 59 40
144728 253098 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1290 Portola Dr 2 Sidewalk: Property side : Yard Tree DPW 1   08/22/2017 12:00:00 AM 3 3x3   5994035 2097938 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736) 1 8 4 59 40
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
185127 116345 Significant Tree 6 Tree(s) :: 17 85x SANTA CLARA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2016 12:00:00 AM 3 3x3 Permit Number 777165 5993361 2096925 37.7373753392635 -122.465458906558 (37.7373753392635, -122.465458906558) 1 8 4 59 40
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
192391 253097 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1290 Portola Dr 1 Sidewalk: Property side : Yard Tree Private 2 DPW 08/22/2017 12:00:00 AM 3 3x3   5994035 2097938 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736) 1 8 4 59 40
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
194499 265142 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 75X Cedro Ave 1 Back Yard : Cutout Tree Private 2       3x3   5992440 2092965 37.7264490050903 -122.468355192232 (37.7264490050903, -122.468355192232) 9 8 4 59 40
194504 265143 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 333 Lansdale Ave 1 Front Yard : Yard Tree Private 2       3x3   5995416 2096422 37.7361125310636 -122.458317465478 (37.7361125310636, -122.458317465478) 9 7 4 59 40
160307 110393 Significant Tree 6 Juniperus chinensis :: Juniper 113 451 LOS PALMOS DR 1 Sidewalk: Property side : Cutout Tree Private 2       3x8   5997298 2095759 37.7344000615683 -122.451762846846 (37.7344000615683, -122.451762846846) 9 7 4 59 40
4000 79751 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 15 Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       4x10   5991685.90264393 2095891.27109779 37.7344402285305 -122.471175151585 (37.7344402285305, -122.471175151585) 9 8 4 59 40
102524 258404 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 15 Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       4x10   5991685.90264393 2095891.27109779 37.7344402285305 -122.471175151585 (37.7344402285305, -122.471175151585) 9 8 4 59 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
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
15254 260460 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1798X Monterey Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       5x10   5992678 2095461 37.733316146518 -122.467713892437 (37.733316146518, -122.467713892437) 9 8 4 59 40
34088 256489 Significant Tree 6 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 2198X Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       5x10   5991651 2095488 37.7333309287491 -122.471266448142 (37.7333309287491, -122.471266448142) 9 8 4 59 40
54695 256491 Significant Tree 6 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 2198X Monterey Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2       5x10   5991651 2095488 37.7333309287491 -122.471266448142 (37.7333309287491, -122.471266448142) 9 8 4 59 40
72983 256490 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 2198X Monterey Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       5x10   5991651 2095488 37.7333309287491 -122.471266448142 (37.7333309287491, -122.471266448142) 9 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
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
16652 258405 Significant Tree 6 Myoporum laetum :: Myoporum 62 15 Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2       6x10   5991685.90264393 2095891.27109779 37.7344402285305 -122.471175151585 (37.7344402285305, -122.471175151585) 9 8 4 59 40
12289 254085 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Lansdale Ave 1 Front Yard : Cutout Tree Private 2       6x6   5995707 2096451 37.7362088759349 -122.457313463895 (37.7362088759349, -122.457313463895) 9 7 4 59 40
104704 256850 Significant Tree 6 Calocedrus decurrens :: Incense Cedar 206 100 Brentwood Ave 1 Front Yard : Yard Tree Private 2       6x6   5995843 2095739 37.7342617075966 -122.456791779994 (37.7342617075966, -122.456791779994) 9 7 4 59 40
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
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
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
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
137836 208971 Significant Tree 6 Tree(s) :: 17 150 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2   12/18/2018 12:00:00 AM 3 Width 6ft Permit Number 782070 5994318.90627 2096521.25566 37.7363219572757 -122.462117732164 (37.7363219572757, -122.462117732164) 9 8 4 59 40

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