108 rows where qSpecies_id = 218

View and edit SQL

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)
185855 220705 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 3300x Cesar Chavez St 1 Median : Yard Tree DPW 1     13 Width 10ft   6007530.95819 2100569.16609 37.7481884658198 -122.416724727984 (37.7481884658198, -122.416724727984) 2 4 7 28859 2
186070 221310 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 3400x Cesar Chavez St 18 Median : Yard Tree DPW 1     15 Width 10ft   6006690.61046 2100560.24644 37.7481166738574 -122.419629996836 (37.7481166738574, -122.419629996836) 2 4 7 28859 2
188811 221297 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 2800x Cesar Chavez St 22 Median : Cutout Tree DPW 1     14 Width 6ft   6010135.01415 2100610.89808 37.7484491721017 -122.407722885716 (37.7484491721017, -122.407722885716) 2 4 7 28859 2
188843 221286 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 100x McCoppin St 5 Median : Yard Tree DPW 1     11 Width 7ft   6005932.045 2109110.97186 37.7715522050908 -122.42286070518 (37.7715522050908, -122.42286070518) 8 2 9 28853 19
189857 221292 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 501 Alabama St 4 Sidewalk: Property side : Yard Tree Private 2     10 Width 2ft   6008997.77018 2105852.60529 37.7627779884373 -122.41202584492 (37.7627779884373, -122.41202584492) 8 4 7 28859 19
190009 221300 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 2800x Cesar Chavez St 2 Median : Cutout Tree DPW 1     14 Width 6ft   6010513.72092 2100755.88609 37.7488684702131 -122.406423533516 (37.7488684702131, -122.406423533516) 2 4 7 28859 2
190995 221285 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 100x McCoppin St 4 Median : Yard Tree DPW 1     12 Width 7ft   6005941.9303 2109128.61885 37.7716012172564 -122.422827765695 (37.7716012172564, -122.422827765695) 8 2 9 28853 19
191259 220731 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 1245 Alabama St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6009260.11174 2101937.6364 37.7520430842361 -122.41084198187 (37.7520430842361, -122.41084198187) 2 4 7 28859 19

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