trees

5 rows where DBH = 9, SiteOrder = 2 and qSpecies_id = 65 sorted by PlotSize

✎ View and edit SQL

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)
88120 38113 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1296 29th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/1998 12:00:00 AM 9   Permit Number 40278 5987108.7979 2106493.9222 37.7632864483052 -122.487778208637 (37.7632864483052, -122.487778208637) 1 8 3 56 35
171813 35138 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 832 Naples St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1998 12:00:00 AM 9   Permit Number 38668 6001976.8462 2088896.96126 37.7158253124776 -122.435095942923 (37.7158253124776, -122.435095942923) 9 7 6 28861 5
43199 221866 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 53 Wilder St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6002528.4957 2095557.08411 37.734143822686 -122.433664907521 (37.734143822686, -122.433664907521) 2 7 5 63 7
111117 120170 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2115 Balboa St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5988998.98639 2111212.7958 37.7763532490624 -122.481586377549 (37.7763532490624, -122.481586377549) 11 6 2 55 26
190842 123821 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1851 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5992885.6569 2112034.46491 37.7788345620747 -122.468201203152 (37.7788345620747, -122.468201203152) 11 6 2 54 11

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);