trees
14 rows where Supervisor Districts = 3, qLegalStatus_id = 2 and qSiteInfo = "Sidewalk: Property side : Cutout" sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14929 | 256105 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1935 34th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Port | 09/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778629 | 5985666.45669 | 2102048.38182 | 37.7509959848908 | -122.492439326416 | (37.7509959848908, -122.492439326416) | 1 | 8 | 3 | 29491 | 35 |
24135 | 254150 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2123 30th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 3x6 | Permit Number 778310 | 5986951.71761 | 2100810.65655 | 37.7476725845461 | -122.487903895201 | (37.7476725845461, -122.487903895201) | 1 | 8 | 3 | 29491 | 35 | |
25630 | 255709 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2458 40th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 775348 | 5983968.47211 | 2098431.39968 | 37.740965323086 | -122.498043953777 | (37.740965323086, -122.498043953777) | 1 | 8 | 3 | 29491 | 35 | |
36667 | 112972 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4099x ULLOA ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773327 | 5983385 | 2098079 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | 1 | 8 | 3 | 29491 | 35 | |
42827 | 253341 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1935 46th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 769984 | 5981944.68101 | 2101921.14451 | 37.7504283278742 | -122.505299944249 | (37.7504283278742, -122.505299944249) | 1 | 8 | 3 | 29491 | 35 | |
45850 | 112974 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4099x ULLOA ST | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385 | 2098079 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | 1 | 8 | 3 | 29491 | 35 | ||
64240 | 112973 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4099x ULLOA ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385 | 2098079 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | 1 | 8 | 3 | 29491 | 35 | ||
84340 | 115405 | Planning Code 138.1 required 2 | Podocarpus macrophyllus :: Yew Pine 137 | 2050 43RD AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/29/2016 12:00:00 AM | 3 | 3x3 | 5982969 | 2101168 | 37.7484206232379 | -122.50170211889 | (37.7484206232379, -122.50170211889) | 1 | 8 | 3 | 29491 | 35 | ||
107033 | 104876 | Planning Code 138.1 required 2 | Prunus laurocerasus :: English laurel 371 | 2478 43rd Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | Permit Number 778928 | 5983068.6 | 2098273.8 | 37.7404797966413 | -122.501143676277 | (37.7404797966413, -122.501143676277) | 1 | 8 | 3 | 29491 | 35 | |||
124554 | 112975 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4099x ULLOA ST | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385 | 2098079 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | 1 | 8 | 3 | 29491 | 35 | ||
144548 | 254740 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1814 42nd Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779958 | 5983225 | 2102757 | 37.752798609062 | -122.500934388909 | (37.752798609062, -122.500934388909) | 1 | 8 | 3 | 56 | 35 | |
167627 | 256505 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 4023 Pacheco St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 780999 | 5982525.89889 | 2101484.48033 | 37.7492635534225 | -122.50325775688 | (37.7492635534225, -122.50325775688) | 1 | 8 | 3 | 29491 | 35 | |
180231 | 254400 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2346 46th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/12/2018 12:00:00 AM | 3 | 3X3 | 5982081.05878 | 2099125.72352 | 37.7427609043033 | -122.504621254744 | (37.7427609043033, -122.504621254744) | 1 | 8 | 3 | 29491 | 35 | ||
194418 | 265072 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 2027 41st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5983517.97374 | 2101348.17171 | 37.7489475550359 | -122.499817124771 | (37.7489475550359, -122.499817124771) | 1 | 8 | 3 | 29491 | 35 |
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) );