trees

9 rows where PlotSize = "Width 5ft", SiteOrder = 1 and qSpecies_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

PlotSize ✖

  • Width 5ft · 9 ✖
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)
49432 222887 DPW Maintained 1 Ceratonia siliqua :: Carob 5 123 Webster St 1 : Tree Private 2     13 Width 5ft   6004226.51196 2109212.81898 37.77173547164 -122.428767500918 (37.77173547164, -122.428767500918) 7 9 11 29492 10
61480 246510 DPW Maintained 1 Ceratonia siliqua :: Carob 5 231 Duncan St 1 : Tree Private 2     1 Width 5ft   6004993.26159 2099869.66747 37.7461247456624 -122.425450235552 (37.7461247456624, -122.425450235552) 2 7 5 63 22
76472 225100 DPW Maintained 1 Ceratonia siliqua :: Carob 5 75 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 5ft   6006056.75092 2109200.3154 37.7718045566698 -122.422435689168 (37.7718045566698, -122.422435689168) 8 2 9 28853 19
86068 188467 DPW Maintained 1 Ceratonia siliqua :: Carob 5 255 12th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6008105.35323 2108904.54782 37.77110780062 -122.415328472924 (37.77110780062, -122.415328472924) 8 2 9 28853 19
111186 189933 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6013208.14765 2116234.45684 37.7915195179644 -122.398191948892 (37.7915195179644, -122.398191948892) 12 2 9 28855 6
161020 189926 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013338.6063 2116192.95214 37.7914128215027 -122.397737648268 (37.7914128215027, -122.397737648268) 12 2 9 28855 6
182345 222884 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Valencia St 1 : Tree Private 2     18 Width 5ft   6006058.17228 2109199.11331 37.7718013362 -122.422430687153 (37.7718013362, -122.422430687153) 8 2 9 28853 19
182570 189917 DPW Maintained 1 Ceratonia siliqua :: Carob 5 338 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6013829.87851 2116068.4816 37.7910983996161 -122.396029117153 (37.7910983996161, -122.396029117153) 12 2 9 28855 6
193471 225085 DPW Maintained 1 Ceratonia siliqua :: Carob 5 406 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6004142.31119 2101495.14459 37.7505398125629 -122.428508555547 (37.7505398125629, -122.428508555547) 2 4 5 28862 22

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