trees

6 rows where PlotSize = "Width 2ft" and qSpecies_id = 101 sorted by Fire Prevention Districts

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 2ft · 6 ✖
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)
150691 218962 DPW Maintained 1 Ficus Spp. :: 101 1484 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   5993695.02979 2105338.23672 37.7604952042075 -122.464914846736 (37.7604952042075, -122.464914846736) 1 8 11 56 12
130742 224461 DPW Maintained 1 Ficus Spp. :: 101 1079 Hampshire St 2 Sidewalk: Curb side : Pot Tree Private 2     3 Width 2ft   6010270.40379 2102959.48183 37.7549054419377 -122.407420259331 (37.7549054419377, -122.407420259331) 10 4 7 28859 19
169592 224460 DPW Maintained 1 Ficus Spp. :: 101 1079 Hampshire St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 2ft   6010269.27051 2102947.54161 37.7548725933213 -122.407423336815 (37.7548725933213, -122.407423336815) 10 4 7 28859 19
142738 224478 DPW Maintained 1 Ficus Spp. :: 101 1320 Stevenson St 5 : Tree Private 2     3 Width 2ft   6006256.60572 2108994.81583 37.7712515761271 -122.421729778032 (37.7712515761271, -122.421729778032) 8 2 9 28853 19
187590 224480 DPW Maintained 1 Ficus Spp. :: 101 1320 Stevenson St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6006252.90876 2109004.03741 37.7712766879051 -122.421743221097 (37.7712766879051, -122.421743221097) 8 2 9 28853 19
12510 176400 DPW Maintained 1 Ficus Spp. :: 101 640 Rolph St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6002836.32134 2087254.29787 37.7113636849491 -122.432007969613 (37.7113636849491, -122.432007969613) 9 7 6 28861 5

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