trees

11 rows where Supervisor Districts = 10 and qSpecies_id = 116 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
166698 136749 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1360 Jones St 4 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6008500.72583 2117239.96883 37.7940170782903 -122.414550796777 (37.7940170782903, -122.414550796777) 5 1 10 28857 21
162973 84928 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1500@Polk Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2007 12:00:00 AM 6   Permit Number 49344 6006295.34378 2118001.00844 37.7959825565137 -122.422235750095 (37.7959825565137, -122.422235750095) 13 9 10 28858 32
161164 109315 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1516 BROADWAY 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006331.3 2118082.2 37.7962075161748 -122.422117105361 (37.7962075161748, -122.422117105361) 13 9 10 28858 32
127274 143059 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 440 GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6010738.656 2120349.8129 37.8026814253217 -122.407026593467 (37.8026814253217, -122.407026593467) 3 1 10 308 23
120819 16366 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1306X Montgomery St 9 Median : Cutout Tree DPW 1     8 8   6011454.04278 2119896.37482 37.8014764015683 -122.404519042813 (37.8014764015683, -122.404519042813) 3 1 10 308 23
114110 66988 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1445 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/1992 12:00:00 AM 12   Permit Number 30339 6006117.71616 2118619.27503 37.7976701397196 -122.422894339811 (37.7976701397196, -122.422894339811) 13 9 10 28858 32
82601 63573 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1500@Polk Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 6   Permit Number 49344 6006306.38676 2118003.57118 37.7959902160323 -122.422197721351 (37.7959902160323, -122.422197721351) 13 9 10 28858 32
43466 109317 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1516 BROADWAY 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006331.3 2118082.2 37.7962075161748 -122.422117105361 (37.7962075161748, -122.422117105361) 13 9 10 28858 32
40270 52600 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1360WASHINGTON Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/03/2006 12:00:00 AM 9   Permit Number 48694 6008503.01401 2117214.59757 37.793947543601 -122.41454108323 (37.793947543601, -122.41454108323) 5 1 10 28857 21
38676 109314 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1516 BROADWAY 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006331.3 2118082.2 37.7962075161748 -122.422117105361 (37.7962075161748, -122.422117105361) 13 9 10 28858 32
4227 109316 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1516 BROADWAY 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006331.3 2118082.2 37.7962075161748 -122.422117105361 (37.7962075161748, -122.422117105361) 13 9 10 28858 32

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