trees

6 rows where PlotSize = "Width 1ft" and qSpecies_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 1ft · 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)
6962 189948 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 1ft   6014781.22378 2116142.62721 37.7913548700732 -122.392742658052 (37.7913548700732, -122.392742658052) 12 2 9 28855 6
107370 189952 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 1ft   6014715.63981 2116037.408 37.7910623197318 -122.392962214036 (37.7910623197318, -122.392962214036) 12 2 9 28855 6
113987 189951 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 1ft   6014728.34644 2116051.81938 37.7911025958469 -122.392919257911 (37.7911025958469, -122.392919257911) 12 2 9 28855 6
138761 189947 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 1ft   6014726.02618 2116202.25149 37.7915155186799 -122.392937815425 (37.7915155186799, -122.392937815425) 12 2 9 28855 6
159299 189945 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 1ft   6014694.61322 2116242.67208 37.7916247593304 -122.393049334066 (37.7916247593304, -122.393049334066) 12 2 9 28855 6
161983 189946 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 1ft   6014709.04159 2116225.6637 37.7915788597386 -122.392998221109 (37.7915788597386, -122.392998221109) 12 2 9 28855 6

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