trees

5 rows where DBH = 13 and qSpecies_id = 384

✎ View and edit SQL

This data as json, CSV (advanced)

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)
79871 245813 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 47 Front Yard : Yard Tree Private 2     13     6005140.34889 2097123.40459 37.7385924414978 -122.424746291228 (37.7385924414978, -122.424746291228) 2 7 5 28859 7
110930 245809 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 43 Front Yard : Yard Tree Private 2     13     6005116.45422 2097135.79328 37.7386251084509 -122.424829788766 (37.7386251084509, -122.424829788766) 2 7 5 28859 7
138042 245811 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 45 Front Yard : Yard Tree Private 2     13     6005130.64633 2097121.32587 37.7385861857983 -122.424779690228 (37.7385861857983, -122.424779690228) 2 7 5 28859 7
147672 245808 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 9 Front Yard : Yard Tree Private 2     13     6005180.88138 2097324.81377 37.7391477548528 -122.424620472474 (37.7391477548528, -122.424620472474) 2 7 5 28859 7
191359 245812 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 1000 San Jose Ave 46 Front Yard : Yard Tree Private 2     13     6005133.84129 2097128.34789 37.7386056471346 -122.424769142989 (37.7386056471346, -122.424769142989) 2 7 5 28859 7

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