trees

6 rows where SiteOrder = 15 and qSpecies_id = 162

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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)
27849 105617 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 401X 11th St 15 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6009144.21767 2108487.31593 37.7700205116512 -122.41170550536 (37.7700205116512, -122.41170550536) 8 2 9 28853 34
43784 105640 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1401X Harrison St 15 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009102.15962 2108882.87062 37.7711042533217 -122.411878939782 (37.7711042533217, -122.411878939782) 8 2 9 28853 34
49189 101587 Undocumented 4 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1200X Bryant St 15 Sidewalk: Property side : Cutout Tree Private 2     8 3x3   6009691.5 2108599.6 37.7703595033467 -122.409820383511 (37.7703595033467, -122.409820383511) 8 2 9 28853 34
58894 101562 Undocumented 4 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 435X 11th St 15 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6009095.5 2108566.4 37.770234925082 -122.411879608901 (37.770234925082, -122.411879608901) 8 2 9 28853 34
122235 105569 Undocumented 4 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 450 10th St 15 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6009467.7 2108781.2 37.7708455901598 -122.410607336919 (37.7708455901598, -122.410607336919) 8 2 9 28853 34
141385 105596 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1200X Bryant St 15 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009691.5 2108599.6 37.7703595033467 -122.409820383511 (37.7703595033467, -122.409820383511) 8 2 9 28853 34

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