trees

4 rows where qSpecies_id = 494

✎ 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)
63905 233278 DPW Maintained 1 Melia azerdarach :: Chinaberry 494 3505 19th St 5 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006204.87094 2104908.16573 37.7600276835502 -122.421618432062 (37.7600276835502, -122.421618432062) 2 4 5 28859 19
104100 233276 DPW Maintained 1 Melia azerdarach :: Chinaberry 494 3505 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6006171.87694 2104906.35376 37.7600208477895 -122.42173241392 (37.7600208477895, -122.42173241392) 2 4 5 28859 19
106119 233277 DPW Maintained 1 Melia azerdarach :: Chinaberry 494 3505 19th St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006189.40782 2104907.80432 37.7600258192592 -122.421671885974 (37.7600258192592, -122.421671885974) 2 4 5 28859 19
135803 233279 DPW Maintained 1 Melia azerdarach :: Chinaberry 494 1147 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008077.51806 2101244.83866 37.7500744367816 -122.414882549508 (37.7500744367816, -122.414882549508) 2 4 7 28859 19

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