16 rows where qSpecies_id = 21

View and edit SQL

Suggested facets: SiteOrder, qCaretaker_id, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods (old)

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)
36 166891 Permitted Site 7 Banksia integrifolia :: Coast Banksia 21 174 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2020 12:00:00 AM 3 3x3 Permit Number 787855 6003954.63071 2101612.59597 37.7508516839573 -122.429165942869 (37.7508516839573, -122.429165942869) 2 4 5 28862 22
3182 261252 Significant Tree 6 Banksia integrifolia :: Coast Banksia 21 100 Collins St 1 Front Yard : Cutout Tree Private 2   12/18/2019 12:00:00 AM 3                        
15707 257978 DPW Maintained 1 Banksia integrifolia :: Coast Banksia 21 2239 44th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3     5982635.96784 2099878.65963 37.7448608850094 -122.502758291062 (37.7448608850094, -122.502758291062) 1 8 3 29491 35
21071 258216 Permitted Site 7 Banksia integrifolia :: Coast Banksia 21 1525 44th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/18/2019 12:00:00 AM 3 3x3 Permit Number 783183 5982470.91812 2104727.52358 37.758164806501 -122.503688017142 (37.758164806501, -122.503688017142) 1 8 3 56 35
33443 98454 DPW Maintained 1 Banksia integrifolia :: Coast Banksia 21 1565 Kirkwood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2012 12:00:00 AM 5 3x3 Permit Number 768686 6015422.71517 2096555.33224 37.7376080138989 -122.389154823532 (37.7376080138989, -122.389154823532) 10 3 8 58 1
42644 246501 DPW Maintained 1 Banksia integrifolia :: Coast Banksia 21 267 Duncan St 1 : Tree Private 2     5 Width 3ft   6004772.39397 2099857.63594 37.7460792282712 -122.426213111567 (37.7460792282712, -122.426213111567) 2 7 5 63 22
45270 117718 DPW Maintained 1 Banksia integrifolia :: Coast Banksia 21 3945 Clement St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   5983166.80961 2113082.0246 37.7811447555658 -122.501899513947 (37.7811447555658, -122.501899513947) 11 6 2 55 26
71635 258412 Permitted Site 7 Banksia integrifolia :: Coast Banksia 21 2130 45th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2019 12:00:00 AM 3 3x3 Permit Number 783269 5982340.94516 2100600.50287 37.7468255237134 -122.503831858542 (37.7468255237134, -122.503831858542) 1 8 3 29491 35
78295 258230 Permitted Site 7 Banksia integrifolia :: Coast Banksia 21 2211 44th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/2019 12:00:00 AM 3 3x3 Permit Number 783203 5982629.52707 2100060.76504 37.7453605175795 -122.502794039293 (37.7453605175795, -122.502794039293) 1 8 3 29491 35
100654 254589 Permitted Site 7 Banksia integrifolia :: Coast Banksia 21 2118 47th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/06/2018 12:00:00 AM 3 3x3 Permit Number 781515 5981717.54613 2100657.45178 37.7469452139057 -122.505991697295 (37.7469452139057, -122.505991697295) 1 8 3 29491 35
103130 50851 DPW Maintained 1 Banksia integrifolia :: Coast Banksia 21 283 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2004 12:00:00 AM 8   Permit Number 47367 5992741.2206 2113607.79805 37.7831461632306 -122.468815380408 (37.7831461632306, -122.468815380408) 11 6 2 54 11
113389 78558 DPW Maintained 1 Banksia integrifolia :: Coast Banksia 21 2286 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2018 12:00:00 AM 3   Permit Number 781493 5982378.4208 2099556.0589 37.7439599736661 -122.503624940125 (37.7439599736661, -122.503624940125) 1 8 3 29491 35
134534 57239 DPW Maintained 1 Banksia integrifolia :: Coast Banksia 21 1525 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2008 12:00:00 AM 3 3x3 Permit Number 783183 5982470.2056 2104724.6567 37.7581568929674 -122.503690268992 (37.7581568929674, -122.503690268992) 1 8 3 56 35
141364 188811 DPW Maintained 1 Banksia integrifolia :: Coast Banksia 21 1570 Michigan St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 2ft   6016519.20446 2100876.91622 37.7495349236186 -122.385664810978 (37.7495349236186, -122.385664810978) 10 3 8 58 1
149417 258454 Permitted Site 7 Banksia integrifolia :: Coast Banksia 21 2039 47th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/15/2019 12:00:00 AM 3 3x3 Permit Number 783279 5981658.71984 2101205.85691 37.7484475179789 -122.506235768133 (37.7484475179789, -122.506235768133) 1 8 3 29491 35
168650 50850 DPW Maintained 1 Banksia integrifolia :: Coast Banksia 21 283 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2004 12:00:00 AM 8   Permit Number 47367 5992740.70347 2113621.41529 37.7831835225698 -122.468818160681 (37.7831835225698, -122.468818160681) 11 6 2 54 11

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