trees
8 rows where SiteOrder = 2, qLegalStatus_id = 2 and qSiteInfo = "Sidewalk: Property side : Cutout"
This data as json, CSV (advanced)
These facets timed out: SiteOrder, qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1560 | 258220 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
37189 | 121502 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | 6 | 2 | 9 | 28855 | 6 | |||
51709 | 173899 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 1762 12th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | 1 | 8 | 4 | 56 | 12 | |||
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 | ||
129348 | 251179 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 1043 Minna St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6007668 | 2109797 | 37.7735336727503 | -122.41690453761 | (37.7735336727503, -122.41690453761) | 8 | 2 | 9 | 28853 | 19 | ||||
160249 | 113337 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2X STANFORD ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727 | 2112481 | 37.7812978691674 | -122.392674013487 | (37.7812978691674, -122.392674013487) | 6 | 2 | 9 | 28856 | 6 | ||
166329 | 117480 | Planning Code 138.1 required 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 601 PACHECO ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x9 | 5993107 | 2101833 | 37.7508368102529 | -122.466693753982 | (37.7508368102529, -122.466693753982) | 1 | 8 | 4 | 29491 | 12 | ||||
177060 | 116640 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 4x4 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 |
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) );