13 rows where qSpecies_id = 188

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)
1453 23301 DPW Maintained 1 Eucalyptus melliodora :: Yellow Box 188 950X Van Ness Ave 2 Median : Cutout Tree DPW 1     30 9   6006575.9602707 2113798.8129121 37.7844601942992 -122.420966256023 (37.7844601942992, -122.420966256023) 7 9 9 28858 36
4128 109223 Permitted Site 7 Eucalyptus melliodora :: Yellow Box 188 1675 OWENS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 4x4   6014234 2107598 37.7678628533553 -122.394037627847 (37.7678628533553, -122.394037627847) 14 3 9 310 20
33359 109228 Permitted Site 7 Eucalyptus melliodora :: Yellow Box 188 1675 OWENS ST 6 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014234 2107598 37.7678628533553 -122.394037627847 (37.7678628533553, -122.394037627847) 14 3 9 310 20
37978 109226 Permitted Site 7 Eucalyptus melliodora :: Yellow Box 188 1675 OWENS ST 4 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014234 2107598 37.7678628533553 -122.394037627847 (37.7678628533553, -122.394037627847) 14 3 9 310 20
57598 224277 DPW Maintained 1 Eucalyptus melliodora :: Yellow Box 188 1300 San Jose Ave 54 Front Yard : Yard Tree Private 2     26     6003308.13091 2095510.5396 37.7340602288786 -122.430966143696 (37.7340602288786, -122.430966143696) 2 7 5 63 7
71013 109231 Permitted Site 7 Eucalyptus melliodora :: Yellow Box 188 1675 OWENS ST 9 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014234 2107598 37.7678628533553 -122.394037627847 (37.7678628533553, -122.394037627847) 14 3 9 310 20
96812 109225 Permitted Site 7 Eucalyptus melliodora :: Yellow Box 188 1675 OWENS ST 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014234 2107598 37.7678628533553 -122.394037627847 (37.7678628533553, -122.394037627847) 14 3 9 310 20
99630 224276 DPW Maintained 1 Eucalyptus melliodora :: Yellow Box 188 1300 San Jose Ave 52 Front Yard : Yard Tree Private 2     21     6003327.68525 2095524.2382 37.7340989500965 -122.430899515596 (37.7340989500965, -122.430899515596) 2 7 5 63 7
116698 23296 DPW Maintained 1 Eucalyptus melliodora :: Yellow Box 188 900X Van Ness Ave 3 Median : Cutout Tree DPW 1     24 9   6006584.2678331 2113563.3466728 37.7838141299544 -122.42092079119 (37.7838141299544, -122.42092079119) 7 9 9 28858 36
137185 23300 DPW Maintained 1 Eucalyptus melliodora :: Yellow Box 188 950X Van Ness Ave 1 Median : Cutout Tree DPW 1     30 9   6006575.9602707 2113798.8129121 37.7844601942992 -122.420966256023 (37.7844601942992, -122.420966256023) 7 9 9 28858 36
141641 109227 Permitted Site 7 Eucalyptus melliodora :: Yellow Box 188 1675 OWENS ST 5 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014234 2107598 37.7678628533553 -122.394037627847 (37.7678628533553, -122.394037627847) 14 3 9 310 20
176456 23295 DPW Maintained 1 Eucalyptus melliodora :: Yellow Box 188 900X Van Ness Ave 2 Median : Cutout Tree DPW 1     24 9   6006584.2678331 2113563.3466728 37.7838141299544 -122.42092079119 (37.7838141299544, -122.42092079119) 7 9 9 28858 36
183017 109229 Permitted Site 7 Eucalyptus melliodora :: Yellow Box 188 1675 OWENS ST 7 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014234 2107598 37.7678628533553 -122.394037627847 (37.7678628533553, -122.394037627847) 14 3 9 310 20

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