trees

108 rows where qSpecies_id = 218 sorted by qCaretaker_id

✎ 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
128993 221290 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 2800 Mariposa St 8 : Tree Private 2     9 Width 1ft   6009034.84859 2105927.00235 37.7629843459795 -122.411902860852 (37.7629843459795, -122.411902860852) 8 4 7 28859 19
148498 221289 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 2800 Mariposa St 1 : Tree Private 2     15 Width 4ft   6009185.07 2105937.33918 37.7630211552339 -122.411384024848 (37.7630211552339, -122.411384024848) 8 4 7 28859 19
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
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
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
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)
);