trees

10 rows where PlotSize = "Width 3ft", SiteOrder = 4 and qSpecies_id = 65 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

PlotSize ✖

  • Width 3ft · 10 ✖
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)
48444 221887 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4107 Ogden Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008432.72367 2096048.99248 37.7358277429522 -122.41328683742 (37.7358277429522, -122.41328683742) 10 7 7 28859 2
88932 203571 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 551 Pacheco St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993265.94889 2101843.04784 37.7508735707655 -122.466144828838 (37.7508735707655, -122.466144828838) 1 8 4 29491 40
93698 203506 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 910 Kirkham St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5992059 2105289 37.7602655469825 -122.470569484113 (37.7602655469825, -122.470569484113) 1 8 4 56 12
95845 221899 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Marsily St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6004290.71623 2095557.06224 37.7342435961597 -122.427572353179 (37.7342435961597, -122.427572353179) 2 7 5 28861 25
114879 203587 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 77 Staples Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     39 Width 3ft   5999512.80503 2093756.92182 37.7290294222638 -122.443961766319 (37.7290294222638, -122.443961766319) 9 7 4 63 40
115755 175195 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 522 Avalon Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6004033.56494 2092456.82753 37.7257164970033 -122.428240530581 (37.7257164970033, -122.428240530581) 9 7 6 28861 5
138917 118284 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3549 Cabrillo St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5984589.17158 2110373.61993 37.773791708306 -122.496778979398 (37.773791708306, -122.496778979398) 11 6 2 55 26
144708 117946 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3851 Cabrillo St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5983654.61491 2110341.88423 37.773649768576 -122.500009362473 (37.773649768576, -122.500009362473) 11 6 2 55 26
160833 125544 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1410 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002431.61204 2121624.28708 37.8057124359506 -122.435864366851 (37.8057124359506, -122.435864366851) 13 9 1 57 17
169633 203549 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 181 Flood Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   5999506.56732 2094057.55855 37.7298545448296 -122.444004922987 (37.7298545448296, -122.444004922987) 9 7 4 63 40

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