trees

108 rows where qSpecies_id = 218 sorted by YCoord

✎ 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)
167753 221284 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 100x McCoppin St 3 Median : Yard Tree DPW 1     12 Width 7ft   6005955.03618 2109112.17277 37.7715567997324 -122.42278126266 (37.7715567997324, -122.42278126266) 8 2 9 28853 19
74654 221288 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 100x McCoppin St 7 Median : Yard Tree DPW 1     13 Width 7ft   6005916.40156 2109112.96669 37.7715567997353 -122.422914958583 (37.7715567997353, -122.422914958583) 8 2 9 28853 19
118228 221282 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 100x McCoppin St 1 Median : Yard Tree DPW 1     14 Width 7ft   6005974.66789 2109113.44306 37.7715613952811 -122.422713445673 (37.7715613952811, -122.422713445673) 8 2 9 28853 19
71901 221287 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 100x McCoppin St 6 Median : Yard Tree DPW 1     12 Width 7ft   6005922.32152 2109128.46401 37.7715996856938 -122.422895582686 (37.7715996856938, -122.422895582686) 8 2 9 28853 19
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
53052 221283 DPW Maintained 1 Brahea edulis :: Guadalupe Palm 218 100x McCoppin St 2 Median : Yard Tree DPW 1     13 Width 7ft   6005964.92172 2109129.81976 37.7716058118893 -122.422748322291 (37.7716058118893, -122.422748322291) 8 2 9 28853 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
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

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