6 rows where qLegalStatus_id = 6 and qSiteInfo = "Sidewalk: Curb side : Pot" sorted by qCareAssistant

View and edit SQL

qSiteInfo

  • Sidewalk: Curb side : Pot · 6
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)
551 234021 Significant Tree 6 Pittosporum tobira :: Japanese Mockorange 118 147 Nevada St 1 Sidewalk: Curb side : Pot Tree Private 2     13 Width 3ft   6009064.54563 2097789.74594 37.7406429263284 -122.411225300822 (37.7406429263284, -122.411225300822) 10 7 7 28859 2
11129 236516 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 63 Bronte St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6009359.84862 2097078.24448 37.7387058549889 -122.410154031979 (37.7387058549889, -122.410154031979) 10 7 7 28859 2
15717 221238 Significant Tree 6 Betula pendula :: European White Birch 253 55 Bronte St 1 Sidewalk: Curb side : Pot Tree Private 2     14 Width 3ft   6009363.02974 2097125.97708 37.7388370966643 -122.41014640214 (37.7388370966643, -122.41014640214) 10 7 7 28859 2
30260 114430 Significant Tree 6 Olea europaea :: Olive Tree 9 455 EDDY ST 2 Sidewalk: Curb side : Pot Tree Private 2       3x3   6008254 2113439 37.7835666804498 -122.415135318852 (37.7835666804498, -122.415135318852) 7 10 9 28852 36
74248 208929 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 501 Saint Francis Blvd 1 Sidewalk: Curb side : Pot Tree Private 2     34 Width 6ft   5993145.62708 2096072.03007 37.735020873007 -122.466141577798 (37.735020873007, -122.466141577798) 1 8 4 59 40
187436 114429 Significant Tree 6 Olea europaea :: Olive Tree 9 455 EDDY ST 1 Sidewalk: Curb side : Pot Tree Private 2     10 3x3   6008254 2113439 37.7835666804498 -122.415135318852 (37.7835666804498, -122.415135318852) 7 10 9 28852 36

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