13 rows where qSiteInfo = "Median : Cutout" and qSpecies_id = 47

View and edit SQL

qSiteInfo

  • Median : Cutout · 13
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)
27885 200618 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 59 Median : Cutout Tree DPW 1     3 Width 0ft   6016445.2081 2095088.6176 37.733637339432 -122.385517359434 (37.733637339432, -122.385517359434) 10 3 8 58 1
31750 200604 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 61 Median : Cutout Tree DPW 1     8 Width 0ft   6016455.981 2095075.886 37.7336029770488 -122.385479227084 (37.7336029770488, -122.385479227084) 10 3 8 58 1
68936 13417 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 400 Marietta Dr 1 Median : Cutout Tree DPW 1     70 5   5999553.15658 2097034.91654 37.7380323275191 -122.444057708717 (37.7380323275191, -122.444057708717) 9 7 4 59 40
79037 200614 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 55 Median : Cutout Tree DPW 1     6 Width 0ft   6016432.4764 2095111.6325 37.7336998293082 -122.385562980445 (37.7336998293082, -122.385562980445) 10 3 8 58 1
102287 200612 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 53 Median : Cutout Tree DPW 1     4 Width 0ft   6016428.559 2095128.7713 37.7337466722751 -122.385577718213 (37.7337466722751, -122.385577718213) 10 3 8 58 1
107721 23670 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 317 Virginia Ave 1 Median : Cutout Tree DPW 1     3 12   6006937.9415449 2098264.8464559 37.7418279505329 -122.41861198258 (37.7418279505329, -122.41861198258) 2 7 7 28859 2
113599 200616 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 57 Median : Cutout Tree DPW 1     7 Width 0ft   6016436.8835 2095099.8803 37.7336678039609 -122.385546924914 (37.7336678039609, -122.385546924914) 10 3 8 58 1
125224 200619 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 60 Median : Cutout Tree DPW 1     8 Width 0ft   6016453.0429 2095085.1899 37.7336283611401 -122.385490033201 (37.7336283611401, -122.385490033201) 10 3 8 58 1
136968 29586 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 500X Junipero Serra Blvd 21 Median : Cutout Tree DPW 1     9 3X3   5991342.7865 2093687.81781 37.7283702470744 -122.472200841009 (37.7283702470744, -122.472200841009) 9 8 4 64 40
148733 24276 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 350X Winding Way 14 Median : Cutout Tree DPW 1     6 8   6000825.35085 2086800.6303 37.7100038012068 -122.438925891137 (37.7100038012068, -122.438925891137) 9 7 6 28861 5
159820 29601 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 900X Junipero Serra Blvd 10 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 3 3X3   5991172.09001 2091066.888 37.7211639453471 -122.472599932234 (37.7211639453471, -122.472599932234) 9 8 4 64 40
174988 29627 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 900X Junipero Serra Blvd 36 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 12 3X3   5991152.87782 2090760.03066 37.7203202787275 -122.472643981031 (37.7203202787275, -122.472643981031) 9 8 4 64 40
177935 121420 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1155x Prague St 1 Median : Cutout Tree DPW 1       3x3   6000780 2086820 37.7100544057225 -122.439084019343 (37.7100544057225, -122.439084019343) 9 7 6 28861 5

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