trees

6 rows where PlantDate = "06/08/1992 12:00:00 AM" and qSpecies_id = 65

✎ 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)
19588 67246 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4732 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1992 12:00:00 AM 21   Permit Number 30710 5983966.26401 2111769.24931 37.777587186025 -122.499036819383 (37.777587186025, -122.499036819383) 11 6 2 55 26
26083 65485 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 436 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1992 12:00:00 AM     Permit Number 30733 6004123.88206182 2110310.82859854 37.7747445284274 -122.429200810683 (37.7747445284274, -122.429200810683) 7 9 11 28852 10
84903 67260 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 596 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1992 12:00:00 AM     Permit Number 30727 5983830.17257963 2111769.87555254 37.7775809215722 -122.499507644306 (37.7775809215722, -122.499507644306) 11 6 2 55 26
85408 67245 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4738 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1992 12:00:00 AM 15   Permit Number 30709 5983942.53029 2111768.14196 37.7775827533368 -122.499118839179 (37.7775827533368, -122.499118839179) 11 6 2 55 26
133256 5134 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2815 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1992 12:00:00 AM 6 3X3   6002450.59942 2095504.85865 37.7339960032757 -122.433930487392 (37.7339960032757, -122.433930487392) 2 7 5 63 7
142288 67252 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 874 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1992 12:00:00 AM 25   Permit Number 30716 5983584.68504 2109860.80212 37.7723247514813 -122.500215683916 (37.7723247514813, -122.500215683916) 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)
);