trees
7 rows where PlotSize = "10x10" and qLegalStatus_id = 2 sorted by PlantDate
This data as json, CSV (advanced)
These facets timed out: SiteOrder, PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
167011 | 254235 | Planning Code 138.1 required 2 | Syzygium australe :: Eugenia 228 | 454 Ralston St | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 10x10 | 5992261 | 2090872 | 37.7206918008503 | -122.468821743954 | (37.7206918008503, -122.468821743954) | 9 | 8 | 6 | 64 | 24 | ||||
29841 | 115885 | Planning Code 138.1 required 2 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | 10x10 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | 9 | 8 | 4 | 59 | 40 | |
32624 | 258085 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 10x10 | 5998725.10706 | 2103975.38052 | 37.7570418811558 | -122.447420092492 | (37.7570418811558, -122.447420092492) | 15 | 5 | 4 | 63 | 38 | ||
93370 | 255421 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2727 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780223 | 5985829 | 2096861 | 37.7367623321138 | -122.491495459369 | (37.7367623321138, -122.491495459369) | 1 | 8 | 3 | 29491 | 35 | |
48760 | 255654 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 298X Coso Ave | 2 | Side Yard : Yard | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 10x10 | Permit Number 776462 | 6007785 | 2099424 | 37.7450583812321 | -122.415765181935 | (37.7450583812321, -122.415765181935) | 2 | 7 | 7 | 28859 | 2 | |
183741 | 255653 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 298X Coso Ave | 1 | Side Yard : Yard | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 10x10 | Permit Number 776462 | 6007785 | 2099424 | 37.7450583812321 | -122.415765181935 | (37.7450583812321, -122.415765181935) | 2 | 7 | 7 | 28859 | 2 | |
175587 | 68987 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 767 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 775182 | 5999291.63198947 | 2121477.34728573 | 37.8051301110493 | -122.44672010757 | (37.8051301110493, -122.44672010757) | 13 | 9 | 1 | 57 | 17 |
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) );