trees
6 rows where DBH = 7, SiteOrder = 2 and qSpecies_id = 65 sorted by PlotSize
This data as json, CSV (advanced)
These facets timed out: SiteOrder, DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
106863 | 91463 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52106 | 6008009.62404 | 2119930.75783 | 37.8013777126716 | -122.416440749956 | (37.8013777126716, -122.416440749956) | 5 | 1 | 1 | 308 | 32 | |
102836 | 203534 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5995350.02472 | 2096965.99603 | 37.7376024192215 | -122.45858493525 | (37.7376024192215, -122.45858493525) | 9 | 7 | 4 | 59 | 40 | |||
49734 | 117948 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3851 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5983620.50726 | 2110339.60464 | 37.7736415077236 | -122.500127175628 | (37.7736415077236, -122.500127175628) | 11 | 6 | 2 | 55 | 26 | |||
130503 | 175177 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 763 Morse St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998527.33807 | 2087102.13623 | 37.7107006525794 | -122.44688991486 | (37.7107006525794, -122.44688991486) | 9 | 7 | 6 | 28861 | 5 | |||
137740 | 124329 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 122 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995931.07902 | 2113567.14983 | 37.7832183231598 | -122.457776888478 | (37.7832183231598, -122.457776888478) | 11 | 6 | 1 | 54 | 31 | |||
191257 | 221925 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 651 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003063.11799 | 2104395.60529 | 37.7584426581259 | -122.432447626582 | (37.7584426581259, -122.432447626582) | 2 | 4 | 5 | 28862 | 3 |
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) );