trees

9 rows where Supervisor Districts = 5 and qSpecies_id = 181

✎ 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)
1288 233082 Permitted Site 7 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 1418 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/25/2020 12:00:00 AM 3 3x3 Permit Number 785211 6001974.22065 2099890.10044 37.746009810513 -122.43589113876 (37.746009810513, -122.43589113876) 2 7 5 63 22
15422 158373 DPW Maintained 1 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 240 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   6001519.98518 2096454.487 37.7365506072174 -122.437215872525 (37.7365506072174, -122.437215872525) 2 7 5 63 7
19245 233677 DPW Maintained 1 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 4068 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft Permit Number 785223 6003410.93999 2101286.47025 37.7499254263317 -122.431022800956 (37.7499254263317, -122.431022800956) 2 4 5 28862 22
33507 95540 Permitted Site 7 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 4750 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767327 6000130.6 2101122.2 37.7492879573628 -122.442354552038 (37.7492879573628, -122.442354552038) 2 4 5 28862 22
72908 32056 Permitted Site 7 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 3516 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/2009 12:00:00 AM   3x3 Permit Number 52612 6003328.9813191 2106558.55926414 37.7643966822396 -122.431682578762 (37.7643966822396, -122.431682578762) 15 4 5 28862 3
73236 88248 Permitted Site 7 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 4418 17th St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51234 6000065 2105781 37.7620761444221 -122.442915908064 (37.7620761444221, -122.442915908064) 15 5 5 28862 3
81594 95568 Permitted Site 7 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 353 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767360 6002854 2101511 37.7505103579798 -122.432964764241 (37.7505103579798, -122.432964764241) 2 4 5 28862 22
118405 62528 Permitted Site 7 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 4259 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2010 12:00:00 AM   3x3 Permit Number 53580 6000833.16850213 2102853.59020152 37.7540819566375 -122.440049196257 (37.7540819566375, -122.440049196257) 2 4 5 28862 22
157786 95576 Permitted Site 7 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 373 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767365 6003497 2099203 37.7442095786195 -122.430576552899 (37.7442095786195, -122.430576552899) 2 7 5 63 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)
);