trees

1 row where PlantDate = "07/21/2010 12:00:00 AM" and qLegalStatus_id = 10

✎ View and edit SQL

This data as json, CSV (advanced)

PlantDate ✖

  • 07/21/2010 12:00:00 AM · 1 ✖
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)
189972 17872 Section 143 10 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2148 Pine St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 07/21/2010 12:00:00 AM 0 3X3 Permit Number 53638 6003654.7045158 2115269.5781823 37.7883334451781 -122.431177809024 (37.7883334451781, -122.431177809024) 13 9 1 29490 27

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