11 rows where PlotSize = "Width 6ft" and qSpecies_id = 5

View and edit SQL

These facets timed out: PlotSize

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)
30477 222899 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3737 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 6ft   6005393.47694 2104277.70893 37.7582508111316 -122.424379813902 (37.7582508111316, -122.424379813902) 2 4 5 28859 19
38272 125985 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 6 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 6ft   6008371.27829 2121652.4837 37.8061254702907 -122.415311214049 (37.8061254702907, -122.415311214049) 5 1 10 308 23
59975 125986 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 7 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 6ft   6008368.52895 2121668.47116 37.8061692132974 -122.415321861121 (37.8061692132974, -122.415321861121) 5 1 10 308 23
67416 125984 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 5 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 6ft   6008373.73288 2121637.11508 37.8060834098955 -122.41530163086 (37.8060834098955, -122.41530163086) 5 1 10 308 23
76986 205989 DPW Maintained 1 Ceratonia siliqua :: Carob 5 566 Dewey Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   5994108.82044 2099457.01961 37.744370734026 -122.463057021885 (37.744370734026, -122.463057021885) 1 8 4 29491 40
79309 125987 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 8 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 6ft   6008367.52131 2121686.8739 37.8062196859398 -122.415326651828 (37.8062196859398, -122.415326651828) 5 1 10 308 23
101361 222898 Undocumented 4 Ceratonia siliqua :: Carob 5 2771 22nd St 2 Sidewalk: Curb side : Yard Tree Private 2     21 Width 6ft   6009527.7031 2103333.93064 37.7558919964247 -122.410015170384 (37.7558919964247, -122.410015170384) 2 4 7 28859 19
107672 125981 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 6ft   6008384.91577 2121552.17509 37.8058508146246 -122.415256913874 (37.8058508146246, -122.415256913874) 5 1 10 308 23
111120 225061 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1289 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   5997502.5049 2105021.09629 37.7598432128005 -122.451723726786 (37.7598432128005, -122.451723726786) 15 5 11 29492 12
124920 125982 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 3 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 6ft   6008379.56749 2121591.49972 37.8059584895516 -122.415278208017 (37.8059584895516, -122.415278208017) 5 1 10 308 23
175418 125967 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3440 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 6ft   5998347.68841 2115559.33393 37.7888268704136 -122.449560024485 (37.7888268704136, -122.449560024485) 13 6 1 54 31

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