trees

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

✎ 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)
139444 115733 Significant Tree 6 Acer rubrum :: Red Maple 75 50 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776548 5993693.2 2096969 37.7375153061033 -122.464313539267 (37.7375153061033, -122.464313539267) 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
193743 211099 Significant Tree 6 Tree(s) :: 17 501 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2   05/18/2018 12:00:00 AM 3 10x10 Permit Number 781418 5993137.63738 2096084.35497 37.7350542531473 -122.466170096172 (37.7350542531473, -122.466170096172) 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
188463 115734 Significant Tree 6 Acer rubrum :: Red Maple 75 55 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 776555 5993732.7 2097034 37.7376960566374 -122.464181687663 (37.7376960566374, -122.464181687663) 1 8 4 59 40
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
178454 96779 Significant Tree 6 Tree(s) :: 17 555 Melrose Ave 1 Back Yard : Yard Tree Private 2   07/18/2011 12:00:00 AM     Permit Number 767966 5996882.6 2095364.1 37.7332919614683 -122.45317051412 (37.7332919614683, -122.45317051412) 9 7 4 59 40
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
38717 98546 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 555@Rio Teresita Blvd 2 Sidewalk: Property side : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
116509 98545 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 555@Rio Teresita Blvd 1 Front Yard : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
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
193868 115735 Significant Tree 6 Acer rubrum :: Red Maple 75 57 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776554 5993777.6 2097002.8 37.7376129769989 -122.464024183823 (37.7376129769989, -122.464024183823) 1 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
60308 99100 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 60 Santa Monica Way 1 Sidewalk: Curb side : Cutout Tree Private 2           5993700.7 2097327 37.7384987171226 -122.464313592449 (37.7384987171226, -122.464313592449) 1 8 4 59 40
128997 109708 Significant Tree 6 Tree(s) :: 17 621 Laguna Honda Blvd 3 Front Yard : Cutout Tree Private 2 FUF 07/29/2015 12:00:00 AM     Permit Number 774799 5995723.9 2099907.4 37.7457002690083 -122.457505029341 (37.7457002690083, -122.457505029341) 1 5 4 59 40
187809 99099 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 65X Santa Monica Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2012 12:00:00 AM     Permit Number 768467 5993743.4 2097365.9 37.7386079879791 -122.464168780849 (37.7386079879791, -122.464168780849) 1 8 4 59 40
146154 99098 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 66 Santa Monica Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2012 12:00:00 AM     Permit Number 768466 5993736.6 2097303.5 37.7384362612216 -122.464187762983 (37.7384362612216, -122.464187762983) 1 8 4 59 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
194175 116308 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 699X DETROIT ST 9 Back Yard : Yard Tree Private 2       3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40
47483 113358 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 702 Foerster St 1 Sidewalk: Property side : Cutout Tree Private 2           5998153.40008835 2095558.62470631 37.7338988325043 -122.448791034412 (37.7338988325043, -122.448791034412) 9 7 4 59 40
110581 113359 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 702 Foerster St 2 Sidewalk: Property side : Cutout Tree Private 2           5998153.40008835 2095558.62470631 37.7338988325043 -122.448791034412 (37.7338988325043, -122.448791034412) 9 7 4 59 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
76095 106244 Significant Tree 6 Magnolia spp :: Magnolia 224 735 MANGELS AVE 1 Front Yard : Yard Tree Private 2   06/02/2014 12:00:00 AM 14   Permit Number 772876 5996640.8 2095225.8 37.7328983615352 -122.453996493912 (37.7328983615352, -122.453996493912) 9 7 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
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
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
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
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
85195 98151 Significant Tree 6 Pinus radiata :: Monterey Pine 15 850 Rockdale Dr 3 Front Yard : Yard Tree Private 2         Permit Number 768501 5996729.9 2098301.3 37.7413480470066 -122.453910481227 (37.7413480470066, -122.453910481227) 9 7 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
139989 100474 Significant Tree 6 Pinus halepensis :: Allepo Pine 330 930 Monterey Blvd 2 Front Yard : Yard Tree Private 2           5995794.4 2094643.4 37.7312506649165 -122.456880589247 (37.7312506649165, -122.456880589247) 9 7 4 59 40
189375 100473 Significant Tree 6 Pinus halepensis :: Allepo Pine 330 930 Monterey Blvd 1 Front Yard : Yard Tree Private 2           5995794.4 2094643.4 37.7312506649165 -122.456880589247 (37.7312506649165, -122.456880589247) 9 7 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
182457 115738 Significant Tree 6 Acer rubrum :: Red Maple 75 95x Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776553 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
139381 109706 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 96 CRESTA VISTA DR   Back Yard : Cutout Tree Private 2           5995602.1 2096103.5 37.7352487002973 -122.457651008037 (37.7352487002973, -122.457651008037) 9 7 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
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
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
62177 99097 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 99X Santa Monica Way 1 Sidewalk: Curb side : Yard Tree Private 2           5994003.8 2097131.6 37.7379796635799 -122.463251452094 (37.7379796635799, -122.463251452094) 9 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

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