trees

7 rows where PlotSize = "Width 9ft" and qSpecies_id = 136

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 9ft · 7 ✖
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)
28385 189981 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 23 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012438.4082 2096335.74445 37.7368391834845 -122.399457647549 (37.7368391834845, -122.399457647549) 10 3 8 58 1
47257 189985 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 27 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012486.98266 2096301.35622 37.7367474679233 -122.399287289877 (37.7367474679233, -122.399287289877) 10 3 8 58 1
55498 189988 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 34 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012609.72443 2096214.32079 37.736515326817 -122.398856808712 (37.736515326817, -122.398856808712) 10 3 8 58 1
139438 189983 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 25 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012461.23167 2096321.12771 37.7368003210833 -122.399377710436 (37.7368003210833, -122.399377710436) 10 3 8 58 1
151727 189984 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 26 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012475.97844 2096310.07171 37.7367707855307 -122.399325948156 (37.7367707855307, -122.399325948156) 10 3 8 58 1
180919 189982 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 24 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012448.34075 2096330.25882 37.7368246747079 -122.399422921133 (37.7368246747079, -122.399422921133) 10 3 8 58 1
193130 189987 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 2001 Revere Ave 33 Sidewalk: Property side : Yard Tree Private 2     2 Width 9ft   6012597.96632 2096223.24019 37.736539162453 -122.398898087577 (37.736539162453, -122.398898087577) 10 3 8 58 1

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