trees

3 rows where Fire Prevention Districts = 11 and qLegalStatus_id = 11 sorted by qSiteInfo descending

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

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)
51932 253858 Landmark tree 11 Arctostaphylos manzanita 'Dr Hurd' :: Dr. Hurd Manzanita 417 115 Parker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996817 2113681 37.7835817804999 -122.454720202744 (37.7835817804999, -122.454720202744) 11 6 1 54 31
16836 255909 Landmark tree 11 Aesculus californica :: California Buckeye 168 2694 McAllister St 1 Front Yard : Yard Tree Private 2         Under Review 5996297 2110789 37.7756112723889 -122.456310013186 (37.7756112723889, -122.456310013186) 11 6 2 54 16
64831 111748 Landmark tree 11 Aesculus californica :: California Buckeye 168 730 28th Ave 1 Back Yard : Yard Tree Private 2           5987294.2 2110946.4 37.7755225253955 -122.487464059213 (37.7755225253955, -122.487464059213) 11 6 2 55 26

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