trees

3 rows where PlotSize = "Width 4ft" and qSpecies_id = 35

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

PlotSize ✖

  • Width 4ft · 3 ✖
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)
144700 118538 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7900x Geary Blvd 1 Median : Cutout Tree DPW 1     11 Width 4ft   5982472.23583 2112389.87128 37.7792034803758 -122.504251064408 (37.7792034803758, -122.504251064408) 11 6 2 55 26
145424 211006 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 600x Portola Dr 1 Median : Cutout Tree DPW 1     6 Width 4ft   5997174.86391 2099677.95775 37.7451535147355 -122.452471281937 (37.7451535147355, -122.452471281937) 1 7 4 59 40
166211 211005 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 800x Portola Dr 2 Median : Cutout Tree DPW 1     7 Width 4ft   5996562.64616 2099171.26049 37.7437271539842 -122.454551615288 (37.7437271539842, -122.454551615288) 1 7 4 59 40

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