trees

5 rows where PlotSize = "Width 8ft" and qSpecies_id = 59

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 8ft · 5 ✖
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)
56401 234907 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 11 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   6009682.36778 2096375.42259 37.7367941301369 -122.408989332604 (37.7367941301369, -122.408989332604) 10 7 7 28859 2
100049 196024 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1670 Owen St 29 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6013848.21751 2107498.56576 37.7675683801977 -122.395365047877 (37.7675683801977, -122.395365047877) 14 3 9 310 20
108842 196023 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1670 Owen St 28 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6013858.29957 2107482.27299 37.7675242045935 -122.395329033601 (37.7675242045935, -122.395329033601) 14 3 9 310 20
125376 234906 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 10 Sidewalk: Property side : Yard Tree Private 2     17 Width 8ft   6009686.02423 2096384.83518 37.7368201799074 -122.408977354526 (37.7368201799074, -122.408977354526) 10 7 7 28859 2
164603 234905 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 9 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   6009688.58582 2096390.10165 37.736834783993 -122.40896886942 (37.736834783993, -122.40896886942) 10 7 7 28859 2

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