22 rows where DBH = 7 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)
2206 70527 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 25 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6004201.75826 2093380.33154 37.7282617492704 -122.427724869209 (37.7282617492704, -122.427724869209) 9 7 6 28861 5
68583 38114 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1296 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/1998 12:00:00 AM 7   Permit Number 40278 5987111.1601 2106473.2531 37.7632298344396 -122.487768520051 (37.7632298344396, -122.487768520051) 1 8 3 56 35
69194 175204 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 653 Peru Ave 1 Side Yard : Yard Tree Private 2     7     6005107.43376 2092594.03644 37.72615394614 -122.424538001034 (37.72615394614, -122.424538001034) 9 7 6 28861 5
95533 44242 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4007 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2001 12:00:00 AM 7   Permit Number 43678 5983296.4831 2106264.529 37.7624334942373 -122.500946571761 (37.7624334942373, -122.500946571761) 1 8 3 56 35
105651 32556 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 233 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/22/1996 12:00:00 AM 7   Permit Number 37043 6004755.28395 2103949.67696 37.7573140539292 -122.42656360702 (37.7573140539292, -122.42656360702) 2 4 5 28862 3
162563 33146 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 650 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 7   Permit Number 37371 5989131.31746 2110902.5354 37.7755090539386 -122.481105889377 (37.7755090539386, -122.481105889377) 11 6 2 55 26
1599 110941 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2484 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7 3x3   5984310 2098290 37.7405970958294 -122.496852660576 (37.7405970958294, -122.496852660576) 1 8 3 29491 35
23568 84675 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3025 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2008 12:00:00 AM 7 3x3 Permit Number 51854 5986186.78165 2110431.4764 37.7740440447924 -122.49125692663 (37.7740440447924, -122.49125692663) 11 6 2 55 26
106863 91463 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1001 Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2009 12:00:00 AM 7 3x3 Permit Number 52106 6008009.62404 2119930.75783 37.8013777126716 -122.416440749956 (37.8013777126716, -122.416440749956) 5 1 1 308 32
146765 139915 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1000 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6004816.1035 2112332.8828 37.7803357557587 -122.426950318013 (37.7803357557587, -122.426950318013) 7 9 11 28852 41
101822 203519 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1531 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5994271.83336 2105139.6012 37.7599830430151 -122.462905551751 (37.7599830430151, -122.462905551751) 1 5 4 56 12
102836 203534 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 149 Casitas Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5995350.02472 2096965.99603 37.7376024192215 -122.45858493525 (37.7376024192215, -122.45858493525) 9 7 4 59 40
137299 203520 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1537 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5994273.74981 2105115.42997 37.7599167854573 -122.462897170087 (37.7599167854573, -122.462897170087) 1 5 4 56 12
9645 203569 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 181 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5994053.625 2104649.1203 37.7586237384107 -122.463624625377 (37.7586237384107, -122.463624625377) 1 5 4 56 12
49734 117948 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3851 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5983620.50726 2110339.60464 37.7736415077236 -122.500127175628 (37.7736415077236, -122.500127175628) 11 6 2 55 26
89515 221937 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 31 Fairmount St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6005028.18878 2097255.91505 37.7389499498753 -122.425143513686 (37.7389499498753, -122.425143513686) 2 7 5 63 7
114883 221926 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 651 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003063.55536 2104400.84265 37.7584570634637 -122.432446488035 (37.7584570634637, -122.432446488035) 2 4 5 28862 3
130503 175177 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 763 Morse St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5998527.33807 2087102.13623 37.7107006525794 -122.44688991486 (37.7107006525794, -122.44688991486) 9 7 6 28861 5
137740 124329 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 122 Palm Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5995931.07902 2113567.14983 37.7832183231598 -122.457776888478 (37.7832183231598, -122.457776888478) 11 6 1 54 31
185444 221929 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 70 Beaver St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002463.4686 2106805.25277 37.7650249445694 -122.434693785007 (37.7650249445694, -122.434693785007) 15 5 5 28862 3
189738 203583 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 24 Gennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5997456.92965 2093746.95791 37.72888457474 -122.451068332359 (37.72888457474, -122.451068332359) 9 7 4 28861 40
191257 221925 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 651 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003063.11799 2104395.60529 37.7584426581259 -122.432447626582 (37.7584426581259, -122.432447626582) 2 4 5 28862 3

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