13 rows where DBH = 6 and qSpecies_id = 65 sorted by PlotSize

View and edit SQL

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)
65306 43793 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 170 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/26/2000 12:00:00 AM 6   Permit Number 43423 5989012.43621 2114211.91029 37.7845887590001 -122.481759578125 (37.7845887590001, -122.481759578125) 11 6 2 55 26
72092 175200 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 648 Peru Ave 6 Side Yard : Yard Tree Private 2     6     6005058.70512 2092602.03865 37.7261731664377 -122.424707022338 (37.7261731664377, -122.424707022338) 9 7 6 28861 5
133256 5134 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2815 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1992 12:00:00 AM 6 3X3   6002450.59942 2095504.85865 37.7339960032757 -122.433930487392 (37.7339960032757, -122.433930487392) 2 7 5 63 7
12275 90670 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3730 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 04/07/2008 12:00:00 AM 6 3x3   5984065.245536 2110402.073206 37.7738391205751 -122.498593397317 (37.7738391205751, -122.498593397317) 11 6 2 55 26
29996 83821 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1514 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2008 12:00:00 AM 6 3x3 Permit Number 50163 5981890.7885 2104754.0668 37.7582035604252 -122.505696289301 (37.7582035604252, -122.505696289301) 1 8 3 56 35
73567 83915 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1218 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2008 12:00:00 AM 6 3x3 Permit Number 50159 5982131.5385 2106775.0727 37.763766832166 -122.505013452733 (37.763766832166, -122.505013452733) 1 8 3 56 35
70877 125553 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 22 Dashiell Hammett St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 1ft   6010381.65829 2116025.18682 37.7907870714036 -122.407956842555 (37.7907870714036, -122.407956842555) 5 1 10 28857 21
59779 221868 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 30 Woodland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5997080.14125 2106419.81481 37.7636595407827 -122.45328544896 (37.7636595407827, -122.45328544896) 15 5 11 29492 12
59602 117945 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3851 Cabrillo St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5983670.24655 2110340.72956 37.7736475155565 -122.499955205725 (37.7736475155565, -122.499955205725) 11 6 2 55 26
145859 122210 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 577 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5991577.51719 2111532.45164 37.7773805333672 -122.472689918421 (37.7773805333672, -122.472689918421) 11 6 2 54 26
47655 189217 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1634 Jerrold Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6015116.50224 2097212.0883 37.7393943516633 -122.390259427548 (37.7393943516633, -122.390259427548) 10 3 8 58 1
102114 123272 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 550 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5993787.32117 2111737.84714 37.7780721632368 -122.465060466509 (37.7780721632368, -122.465060466509) 11 6 2 54 11
190416 203514 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1206 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5993631.78497 2107236.32673 37.7657032159447 -122.465271454925 (37.7657032159447, -122.465271454925) 11 8 11 56 12

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