trees

4 rows where Zip Codes = 28859, qLegalStatus_id = 8 and qSiteInfo = "Back Yard : Yard"

✎ 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)
22171 251481 Property Tree 8 Pinus radiata :: Monterey Pine 15 32 Peralta Ave 1 Back Yard : Yard Tree DPW 1       3x3   6010779 2100499 37.7481779538542 -122.405488104269 (37.7481779538542, -122.405488104269) 2 7 7 28859 2
32266 108871 Property Tree 8 Tree(s) :: 17 99x OAKWOOD ST 1 Back Yard : Yard Tree Private 2           6005305 2104962 37.7601247169433 -122.424734485609 (37.7601247169433, -122.424734485609) 2 4 5 28859 19
105934 99256 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1466 York St   Back Yard : Yard Tree Private 2           6010099 2100741 37.7488043872035 -122.407856595429 (37.7488043872035, -122.407856595429) 2 4 7 28859 19
122758 121144 Property Tree 8 Pinus radiata :: Monterey Pine 15 400 Franconia St 1 Back Yard : Yard Tree Private 2     15 3x3   6010016 2098808 37.7434921454983 -122.408007311669 (37.7434921454983, -122.408007311669) 2 7 7 28859 2

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