trees

108 rows where qSpecies_id = 218 sorted by qSiteInfo

✎ 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)
112450 251388 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 1658 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/19/2017 12:00:00 AM 3     6014992.04618 2094842.79599 37.7328818542219 -122.390524234407 (37.7328818542219, -122.390524234407) 10 3 8 58 1
167617 115204 Permitted Site 7 Brahea edulis :: Guadalupe Palm 218 1225X Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/19/2016 12:00:00 AM     Permit Number 777371 6009246.03898 2101881.5428 37.7518882746477 -122.410886686356 (37.7518882746477, -122.410886686356) 2 4 7 28859 19
169568 220733 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 1237 Alabama St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6009257.54901 2102010.66421 37.752243458587 -122.410856001419 (37.752243458587, -122.410856001419) 2 4 7 28859 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
41919 175571 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 1145 Russia Ave 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 5ft   6004133.69387 2089325.85486 37.717125198844 -122.427671417122 (37.717125198844, -122.427671417122) 9 7 6 28861 5
95688 123175 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 745 10th Ave 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 5ft   5992848.69959 2110368.8816 37.7742591855672 -122.468207855172 (37.7742591855672, -122.468207855172) 11 6 2 54 11
151584 123180 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 783 10th Ave 2 Sidewalk: Property side : Yard Tree Private 2     14 Width 2ft   5992855.90755 2110145.86563 37.7736472599324 -122.468166695245 (37.7736472599324, -122.468166695245) 11 6 2 54 11
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

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