26 rows where DBH = 9 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)
9579 74128 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 800 Excelsior Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6004381.29063 2091452.37119 37.7229781503978 -122.426966961977 (37.7229781503978, -122.426966961977) 9 7 6 28861 5
13559 70587 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1834 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     5989770.57381 2113384.40122 37.7823607090318 -122.479076155854 (37.7823607090318, -122.479076155854) 11 6 2 55 26
16687 74647 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 800 Excelsior Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6004365.04367 2091463.54141 37.7230079026666 -122.42702391962 (37.7230079026666, -122.42702391962) 9 7 6 28861 5
47876 37084 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1487 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 9   Permit Number 39685 5982148.9004 2105004.528 37.7589064434103 -122.504822200215 (37.7589064434103, -122.504822200215) 1 8 3 56 35
58638 175199 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 648 Peru Ave 4 Side Yard : Yard Tree Private 2     9     6005054.924 2092614.92051 37.7262083236385 -122.424721009467 (37.7262083236385, -122.424721009467) 9 7 6 28861 5
88120 38113 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1296 29th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/1998 12:00:00 AM 9   Permit Number 40278 5987108.7979 2106493.9222 37.7632864483052 -122.487778208637 (37.7632864483052, -122.487778208637) 1 8 3 56 35
104017 35736 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 351 Hale St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/14/1998 12:00:00 AM 9   Permit Number 39011 6008805.61164 2094302.44729 37.731053034462 -122.411874232722 (37.731053034462, -122.411874232722) 9 3 7 309 28
171813 35138 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 832 Naples St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1998 12:00:00 AM 9   Permit Number 38668 6001976.8462 2088896.96126 37.7158253124776 -122.435095942923 (37.7158253124776, -122.435095942923) 9 7 6 28861 5
88150 82830 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1475 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM 9 3x3 Permit Number 52467 6015906.1825 2094100.414 37.7308940918936 -122.387312034756 (37.7308940918936, -122.387312034756) 10 3 8 58 1
92398 91464 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1001 Greenwich St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2009 12:00:00 AM 9 3x3 Permit Number 52106 6008023.92041 2119932.41057 37.8013830546338 -122.416391395149 (37.8013830546338, -122.416391395149) 5 1 1 308 32
167316 91465 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1001 Greenwich St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2009 12:00:00 AM 9 3x3 Permit Number 52106 6008039.0019 2119934.2418 37.8013889308135 -122.416339336112 (37.8013889308135, -122.416339336112) 5 1 1 308 32
172987 95109 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 615 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2010 12:00:00 AM 9 3x3 Permit Number 54038 6001824.30736 2093468.52552 37.7283691373029 -122.435950110013 (37.7283691373029, -122.435950110013) 9 7 6 28861 25
43199 221866 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 53 Wilder St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6002528.4957 2095557.08411 37.734143822686 -122.433664907521 (37.734143822686, -122.433664907521) 2 7 5 63 7
98589 203535 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 68 Rosewood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5994859.58645 2095502.43187 37.7335556327814 -122.460174598491 (37.7335556327814, -122.460174598491) 9 8 4 59 40
136628 221862 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 252 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6004616.62035 2096933.09811 37.7380403090218 -122.426543547661 (37.7380403090218, -122.426543547661) 2 7 5 63 7
150799 203533 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 149 Casitas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5995336.83178 2096965.96659 37.737601580145 -122.458630547087 (37.737601580145, -122.458630547087) 9 7 4 59 40
161078 221858 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 677 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6002223.92198 2099714.60458 37.7455421216803 -122.435015156842 (37.7455421216803, -122.435015156842) 2 7 5 63 22
192333 221847 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6004411.28278 2095593.12873 37.7343494454616 -122.427158084072 (37.7343494454616, -122.427158084072) 2 7 5 28861 25
49802 117893 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4126 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5982758.1361 2110364.11873 37.773658165069 -122.503112014996 (37.773658165069, -122.503112014996) 11 6 2 55 26
79681 221871 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 619 Eugenia Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007314.53376 2097779.75076 37.7405171804218 -122.417275479073 (37.7405171804218, -122.417275479073) 2 7 7 28859 2
94909 203568 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1570 07th Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5994029.22996 2104753.97916 37.7589102480363 -122.463716604458 (37.7589102480363, -122.463716604458) 1 5 4 56 12
98143 250978 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 16 Seal Rock Dr 1 : Tree Private 2     9 Width 3ft   5981781.21701 2113006.5772 37.7808561080562 -122.506687293694 (37.7808561080562, -122.506687293694) 11 6 2 55 15
111117 120170 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2115 Balboa St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5988998.98639 2111212.7958 37.7763532490624 -122.481586377549 (37.7763532490624, -122.481586377549) 11 6 2 55 26
152880 221838 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 115 Cuvier St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6004035.03303 2095100.17103 37.7329746104714 -122.42842377735 (37.7329746104714, -122.42842377735) 9 7 5 28861 25
168785 221814 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 78 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007954.65071 2098276.18605 37.7419162746098 -122.415097327373 (37.7419162746098, -122.415097327373) 2 7 7 28859 2
190842 123821 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1851 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5992885.6569 2112034.46491 37.7788345620747 -122.468201203152 (37.7788345620747, -122.468201203152) 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)
);