trees

10 rows where SiteOrder = 4 and qSpecies_id = 69

✎ 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)
25209 9281 DPW Maintained 1 Corymbia maculata :: Spotted Gum 69 2X George Ct 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017254.34484 2094072.23029 37.7308912760903 -122.382649209712 (37.7308912760903, -122.382649209712) 10 3 8 58 1
64254 50570 Permitted Site 7 Corymbia maculata :: Spotted Gum 69 2295 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
78738 189558 DPW Maintained 1 Corymbia maculata :: Spotted Gum 69 1445 Osceola Ln 4 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 3ft   6017184.67928 2094353.39729 37.731659456313 -122.382909617407 (37.731659456313, -122.382909617407) 10 3 8 58 1
87524 189531 DPW Maintained 1 Corymbia maculata :: Spotted Gum 69 110 Mendell St 4 : Tree Private 2     23 Width 4ft   6016991.36665 2098416.96478 37.7428065153073 -122.383860781748 (37.7428065153073, -122.383860781748) 10 3 8 58 1
95209 189551 DPW Maintained 1 Corymbia maculata :: Spotted Gum 69 270 Terry A Francois Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6016435.27108 2108120.27971 37.7694190177123 -122.386460036521 (37.7694190177123, -122.386460036521) 14 3 9 310 20
116269 189579 DPW Maintained 1 Corymbia maculata :: Spotted Gum 69 1 Whitfield Ct 4 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6017480.3384 2094118.23435 37.7310300765608 -122.381871103661 (37.7310300765608, -122.381871103661) 10 3 8 58 1
154586 189535 DPW Maintained 1 Corymbia maculata :: Spotted Gum 69 311 Terry A Francois Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6016492.9216 2108447.01871 37.7703193631661 -122.38628340695 (37.7703193631661, -122.38628340695) 14 3 9 310 20
169564 189565 DPW Maintained 1 Corymbia maculata :: Spotted Gum 69 1446 Osceola Ln 4 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 3ft   6017060.82222 2094404.36375 37.7317925559632 -122.383341366632 (37.7317925559632, -122.383341366632) 10 3 8 58 1
177588 99982 Undocumented 4 Corymbia maculata :: Spotted Gum 69 535@Clay Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
186977 189544 DPW Maintained 1 Corymbia maculata :: Spotted Gum 69 248 Terry A Francois Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6016419.27306 2108480.80858 37.7704080660008 -122.386540515932 (37.7704080660008, -122.386540515932) 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)
);