trees

6 rows where DBH = 14 and qSpecies_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

DBH ✖

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)
102562 241293 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1300 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6011113.70254 2102244.24348 37.7529887195714 -122.404453537112 (37.7529887195714, -122.404453537112) 10 4 8 28859 19
106256 65755 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3036 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/20/1990 12:00:00 AM 14   Permit Number 28718 6004280.73363 2119630.96227 37.8003441497153 -122.429322978897 (37.8003441497153, -122.429322978897) 13 9 1 57 17
108931 196974 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 223 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6014047.89224 2106015.09524 37.7635062000657 -122.394570502234 (37.7635062000657, -122.394570502234) 14 3 8 28856 29
135225 197004 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 503 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6015943.64363 2113959.00175 37.7854236244348 -122.388568185881 (37.7854236244348, -122.388568185881) 6 2 9 28856 6
137034 241359 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 707 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 8ft   6008539.21153 2104376.13627 37.7586982040894 -122.413507415061 (37.7586982040894, -122.413507415061) 2 4 7 28859 19
149240 196980 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 320 Missouri St 1 : Tree Private 2     14 Width 3ft   6013452.78538 2105563.26016 37.7622324578928 -122.396597126255 (37.7622324578928, -122.396597126255) 10 3 8 28856 29

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