trees

5 rows where DBH = 8, SiteOrder = 1 and qLegalStatus_id = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

SiteOrder ✖

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)
4535 106245 Planning Code 138.1 required 2 Tree(s) :: 17 566 De Haro St 1 Front Yard : Yard Tree Private 2     8   Permit Number 770844 6012026 2105714 37.7625668468002 -122.401542461625 (37.7625668468002, -122.401542461625) 8 3 8 28856 29
7744 225194 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3 Permit Number 778605 6007219.63733 2103836.19178 37.7571414587344 -122.418032839538 (37.7571414587344, -122.418032839538) 2 4 7 28859 19
136714 65940 Planning Code 138.1 required 2 Liquidambar styraciflua :: American Sweet Gum 37 620 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM 8   Permit Number 28961 6007431.46715 2113367.23378 37.7833233693217 -122.417975883707 (37.7833233693217, -122.417975883707) 7 9 9 28858 36
138593 56707 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 1688 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8   Permit Number 782197 5983170.4061 2103643.307 37.7552289545408 -122.501188731534 (37.7552289545408, -122.501188731534) 1 8 3 56 35
168906 109469 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013484.3589 2109540.27035 37.7731542007368 -122.3967667483 (37.7731542007368, -122.3967667483) 14 2 9 310 20

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