13 rows where qSpecies_id = 80

View and edit SQL

Suggested facets: SiteOrder, PlotSize, Longitude, Fire Prevention Districts, Police Districts, Supervisor Districts, Neighborhoods (old)

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)
264 103685 Undocumented 4 Prunus amygdalus :: Almond 80 901X SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6008052 2102672 37.7539916655216 -122.415071798268 (37.7539916655216, -122.415071798268) 2 4 7 28859 19
1495 251251 DPW Maintained 1 Prunus amygdalus :: Almond 80 321X Corbett Ave 2 Front Yard : Yard Tree DPW 1       10x10   5999565 2105069 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425) 15 5 5 28862 3
15180 19576 DPW Maintained 1 Prunus amygdalus :: Almond 80 100 STAIRWAY3 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 15ST                      
28592 23553 DPW Maintained 1 Prunus amygdalus :: Almond 80 2900X Van Ness Ave 3 Median : Cutout Tree DPW 1     12 9   6005648.5023441 2120304.1415398 37.8022698669467 -122.424637865654 (37.8022698669467, -122.424637865654) 5 9 1 28858 32
58678 112181 DPW Maintained 1 Prunus amygdalus :: Almond 80 301x CORBETT AVE 9 Sidewalk: Property side : Yard Tree DPW 1       3x3   5999677 2105220 37.760513648973 -122.444217531177 (37.760513648973, -122.444217531177) 15 5 5 28862 3
61154 251252 DPW Maintained 1 Prunus amygdalus :: Almond 80 321X Corbett Ave 3 Front Yard : Yard Tree DPW 1       10x10   5999565 2105069 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425) 15 5 5 28862 3
69803 91215 Permitted Site 7 Prunus amygdalus :: Almond 80 2901 Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52044 6007111 2101465 37.7506245935345 -122.41824043827 (37.7506245935345, -122.41824043827) 2 4 7 28859 19
71846 23552 DPW Maintained 1 Prunus amygdalus :: Almond 80 2900X Van Ness Ave 2 Median : Cutout Tree DPW 1     12 9   6005648.5023441 2120304.1415398 37.8022698669467 -122.424637865654 (37.8022698669467, -122.424637865654) 5 9 1 28858 32
90335 91214 Permitted Site 7 Prunus amygdalus :: Almond 80 2901 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52044 6007111 2101465 37.7506245935345 -122.41824043827 (37.7506245935345, -122.41824043827) 2 4 7 28859 19
91127 103689 Undocumented 4 Prunus amygdalus :: Almond 80 901X SHOTWELL ST 3 Sidewalk: Curb side : Cutout Tree Private 2     22 3x3   6008118 2102601 37.753800424316 -122.414838529249 (37.753800424316, -122.414838529249) 2 4 7 28859 19
91175 23556 DPW Maintained 1 Prunus amygdalus :: Almond 80 2900X Van Ness Ave 6 Median : Cutout Tree DPW 1     12 9   6005648.5023441 2120304.1415398 37.8022698669467 -122.424637865654 (37.8022698669467, -122.424637865654) 5 9 1 28858 32
129176 91213 Permitted Site 7 Prunus amygdalus :: Almond 80 2901 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52044 6007111 2101465 37.7506245935345 -122.41824043827 (37.7506245935345, -122.41824043827) 2 4 7 28859 19
157314 251250 DPW Maintained 1 Prunus amygdalus :: Almond 80 321X Corbett Ave 1 Front Yard : Yard Tree DPW 1       10x10   5999565 2105069 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425) 15 5 5 28862 3

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