trees

107 rows where Supervisor Districts = 7 and qSpecies_id = 65 sorted by qSpecies_id

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor 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)
167156 69206 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2864 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33255 6008953.68763074 2101781.1943032 37.7515963427841 -122.411890591701 (37.7515963427841, -122.411890591701) 2 4 7 28859 19
168785 221814 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 78 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007954.65071 2098276.18605 37.7419162746098 -122.415097327373 (37.7419162746098, -122.415097327373) 2 7 7 28859 2
179502 221830 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2451 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   6008241.38226 2104159.63616 37.7580870167112 -122.414522128209 (37.7580870167112, -122.414522128209) 2 4 7 28859 19
180514 221817 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 25 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6007435.65723 2099387.93304 37.7449397045122 -122.416970595441 (37.7449397045122, -122.416970595441) 2 7 7 28859 2
183922 221794 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 63 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009581.16571 2099887.27047 37.7464312301328 -122.409587024721 (37.7464312301328, -122.409587024721) 2 7 7 28859 2
185506 63233 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 200x ESMERALDA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/13/1987 12:00:00 AM     Permit Number 23781 6007093 2098828 37.7433829729046 -122.41811575542 (37.7433829729046, -122.41811575542) 2 7 7 28859 2
188123 248074 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 440 Holladay Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6010189.61639 2098448.43347 37.742514572897 -122.407381643363 (37.742514572897, -122.407381643363) 10 7 7 28859 2

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