27 rows where Zip Codes = 55 and qLegalStatus_id = 6 sorted by DBH

View and edit SQL

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)
1875 261661 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 741 30th Ave 1 Sidewalk: Curb side : Yard Tree Private 2 FUF         5986614 2110873 37.7752812973329 -122.489811603249 (37.7752812973329, -122.489811603249) 11 6 2 55 26
7835 258799 Significant Tree 6 Taxus baccata :: Irish Yew 86 566 29th Ave 1 Front Yard : Cutout Tree Private 2       3x3   5986943 2112080 37.7786145821325 -122.488762272653 (37.7786145821325, -122.488762272653) 11 6 2 55 26
13058 260903 Significant Tree 6 Taxus baccata :: Irish Yew 86 51 Shore View Ave 1 Sidewalk: Property side : Yard Tree Private 2       Width 4ft   5984536 2112849 37.7805852728313 -122.497145662996 (37.7805852728313, -122.497145662996) 11 6 2 55 26
17941 258800 Significant Tree 6 Juniperus chinensis :: Juniper 113 566 29th Ave 2 Front Yard : Cutout Tree Private 2       3x3   5986943 2112080 37.7786145821325 -122.488762272653 (37.7786145821325, -122.488762272653) 11 6 2 55 26
32630 85060 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 7070 California St 1 Front Yard : Cutout Tree Private 2   07/03/2007 12:00:00 AM     Permit Number 49405 5985878 2113896 37.7835385880022 -122.492580242312 (37.7835385880022, -122.492580242312) 11 6 2 55 26
32725 106972 Significant Tree 6 Tree(s) :: 17 464 46TH AVE 3 Front Yard : Yard Tree Private 2   08/07/2014 12:00:00 AM     Permit Number 773827 5981646.2 2112608 37.7797537818913 -122.507124798545 (37.7797537818913, -122.507124798545) 11 6 2 55 26
41301 108215 Significant Tree 6 Pinus radiata :: Monterey Pine 15 865 EL CAMINO DEL MAR 1 Front Yard : Yard Tree Private 2           5985761 2114995 37.7865492821054 -122.493065995445 (37.7865492821054, -122.493065995445) 11 6 1 55 33
45774 114249 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 499x 24TH AVE 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5988415 2112957 37.7811083698872 -122.483734439284 (37.7811083698872, -122.483734439284) 11 6 2 55 26
59898 108211 Significant Tree 6 Juniperus chinensis :: Juniper 113 524 45th Ave 2 Front Yard : Yard Tree Private 2         Permit Number 773704 5981973.19232 2112153.30127 37.7785245664452 -122.505959887315 (37.7785245664452, -122.505959887315) 11 6 2 55 26
59956 255159 Significant Tree 6 Pinus radiata :: Monterey Pine 15 4150 Clement St 1 Front Yard : Yard Tree Private 2           5983115 2113126 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527) 11 6 2 55 15
76263 85093 Significant Tree 6 Tree(s) :: 17 100 32nd Ave 2 Front Yard : Yard Tree Private 2   12/18/2009 12:00:00 AM     Permit Number 53112 5985781.7 2114962.8 37.7864620808454 -122.49299200677 (37.7864620808454, -122.49299200677) 11 6 1 55 33
86650 102302 Significant Tree 6 Tree(s) :: 17 740X 31st Ave 1 Front Yard : Yard Tree Private 2   01/14/2013 12:00:00 AM     Permit Number 769784 5986476.3 2110809.8 37.7750997269751 -122.490283282468 (37.7750997269751, -122.490283282468) 11 6 2 55 26
90328 96835 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 6001 Geary Blvd 1 Front Yard : Cutout Tree Private 2           5988352.4 2112527.1 37.779924341439 -122.483919468894 (37.779924341439, -122.483919468894) 11 6 2 55 26
108809 187638 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 875 El Camino Del Mar 2 Side Yard : Yard Tree Private 2       10x10   5985641 2114972 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676) 11 6 1 55 15
119552 101202 Significant Tree 6 Tree(s) :: 17 7070 California St 1 Front Yard : Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
135701 102604 Significant Tree 6 Tree(s) :: 17 401 45th Ave 1 Front Yard : Yard Tree Private 2   02/06/2013 12:00:00 AM     Permit Number 769720 5981859.7 2112893.4 37.7805499779863 -122.506407391963 (37.7805499779863, -122.506407391963) 11 6 2 55 26
145768 98703 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 7070@ 32nd Ave California St 4 Front Yard : Tree Private 2   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
146707 103477 Significant Tree 6 Tree(s) :: 17 875 El Camino Del Mar 1 Front Yard : Tree Private 2   05/08/2013 12:00:00 AM     Permit Number 770113 5985641.7 2114972.5 37.7864805258078 -122.493477079739 (37.7864805258078, -122.493477079739) 11 6 1 55 15
157354 187637 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 875 El Camino Del Mar 1 Side Yard : Yard Tree Private 2       10x10   5985641 2114972 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676) 11 6 1 55 15
162612 101203 Significant Tree 6 Tree(s) :: 17 7070 California St 2 Front Yard : Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
172848 108210 Significant Tree 6 Juniperus chinensis :: Juniper 113 524 45th Ave 1 Front Yard : Yard Tree Private 2         Permit Number 773704 5981973.19232 2112153.30127 37.7785245664452 -122.505959887315 (37.7785245664452, -122.505959887315) 11 6 2 55 26
156485 105434 Significant Tree 6 Eriobotrya deflexa :: Bronze Loquat 8 4355 ANZA ST 1 Back Yard : Yard Tree Private 2     10     5985110.8 2111730.2 37.7775470387472 -122.495074662501 (37.7775470387472, -122.495074662501) 11 6 2 55 26
182598 92909 Significant Tree 6 Tree(s) :: 17 100 32nd Ave 1 Front Yard : Yard Tree Private 2   12/18/2009 12:00:00 AM 11   Permit Number 53112 5985781.7 2114962.8 37.7864620808454 -122.49299200677 (37.7864620808454, -122.49299200677) 11 6 1 55 33
59834 253717 Significant Tree 6 Pinus Spp :: Pine Spp 100 4101 Balboa St 1 Back Yard : Yard Tree Private 2   01/08/2018 12:00:00 AM 3   Permit Number 780863 5982822 2110967 37.7753172554615 -122.50293574331 (37.7753172554615, -122.50293574331) 11 6 2 55 26
85997 111996 Significant Tree 6 Tree(s) :: 17 501 Point Lobos Ave   Front Yard : Yard Tree Private 2   07/08/2015 12:00:00 AM 3 3x3 Permit Number 775626 5981249.6 2112592.5 37.7796878572283 -122.508495636007 (37.7796878572283, -122.508495636007) 11 6 2 55 26
127746 120952 Significant Tree 6 Tree(s) :: 17 100X 32nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2   08/30/2016 12:00:00 AM 3 10x10 Permit Number 778529 5985781 2114962 37.7864598433405 -122.492994369609 (37.7864598433405, -122.492994369609) 11 6 1 55 33
68924 113937 Significant Tree 6 Pinus radiata :: Monterey Pine 15 800 EL CAMINO DEL MAR 1 Front Yard : Yard Tree Private 2     35     5985966 2115003 37.7865832348262 -122.492357345241 (37.7865832348262, -122.492357345241) 11 6 1 55 33

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