trees
27 rows where Zip Codes = 55 and qLegalStatus_id = 6 sorted by DBH
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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) );