trees

4 rows where Neighborhoods (old) = 29, qSiteInfo = "Sidewalk: Curb side : Cutout" and qSpecies_id = 47

✎ View and edit SQL

This data as json, CSV (advanced)

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)
28693 191372 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2220 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6011446.77315 2104664.66226 37.7596532625069 -122.403471980161 (37.7596532625069, -122.403471980161) 10 3 8 28856 29
36662 121603 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 749 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2     35 3x3   6012453.25739 2104452.2107 37.7591260835233 -122.399976111225 (37.7591260835233, -122.399976111225) 10 3 8 28856 29
59598 191367 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 548 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6011194.69766 2105791.52689 37.7627332975312 -122.404423107658 (37.7627332975312, -122.404423107658) 8 3 8 28856 29
108342 35388 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 753 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 7   Permit Number 38842 6011306.15832 2104840.46729 37.7601281288176 -122.403970671318 (37.7601281288176, -122.403970671318) 10 3 8 28856 29

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