25 rows where SiteOrder = 5 and qSpecies_id = 65 sorted by PlotSize

View and edit SQL

DBH

SiteOrder

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
107628 97552 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 250@Flood Detroit St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 42524 5999434 2093931 37.7295029047189 -122.444246704733 (37.7295029047189, -122.444246704733) 9 7 4 63 40
126786 248223 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 70 Fair Ave 5 Side Yard : Yard Tree Private 2     18     6007150.20605 2099339.87769 37.744791694087 -122.417954229812 (37.744791694087, -122.417954229812) 2 7 7 28859 2
142656 108766 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 500X Lathrop Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
180027 114084 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 20 Cook St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   17     5997493.8327 2113562.2002 37.7832943866098 -122.452370058209 (37.7832943866098, -122.452370058209) 15 6 1 54 31
112453 113209 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 50x DASHIELL HAMMETT ST 5 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6010410 2116139 37.7911011617465 -122.407866810246 (37.7911011617465, -122.407866810246) 5 1 10 28857 21
32128 96872 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 620 Palmetto Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     12 2x3   5991838.49017 2087239.32227 37.7106929318927 -122.470017846453 (37.7106929318927, -122.470017846453) 9 8 4 64 24
98528 87814 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2000 10th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2008 12:00:00 AM   3x3 Permit Number 777426 5993220.6 2101817.5 37.750800806475 -122.466299791721 (37.750800806475, -122.466299791721) 1 8 4 29491 40
177357 90774 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3899X Cabrillo St 5 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2008 12:00:00 AM 3 3x3   5983556.085422 2110343.567935 37.7736486085903 -122.500350310129 (37.7736486085903, -122.500350310129) 11 6 2 55 26
14927 262428 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 99 France Ave 5 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6001205.1197 2090381.66789 37.7198581324333 -122.437869661652 (37.7198581324333, -122.437869661652) 9 7 6 28861 5
39337 185946 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2001 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984833.7396 2101513.2963 37.7494780662031 -122.495279445201 (37.7494780662031, -122.495279445201) 1 8 3 29491 35
140770 125556 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 22 Dashiell Hammett St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 1ft   6010373.88988 2116082.2243 37.7909432476765 -122.407987745034 (37.7909432476765, -122.407987745034) 5 1 10 28857 21
22793 221849 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6004448.4556 2095570.1665 37.7342884984186 -122.427027930603 (37.7342884984186, -122.427027930603) 2 7 5 28861 25
36536 175211 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 66 Madison St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6005436.48818 2093200.64124 37.7278381272226 -122.423443582752 (37.7278381272226, -122.423443582752) 9 7 6 28861 5
172356 175209 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 9 Athens St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6005385.77988 2093250.96165 37.7279734338052 -122.423622458831 (37.7279734338052, -122.423622458831) 9 7 6 28861 5
8756 221784 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 201 Buchanan St 5 : Tree Private 2     5 Width 3ft   6004701.97389 2109293.67351 37.7719843770185 -122.427128606994 (37.7719843770185, -122.427128606994) 7 9 11 28852 10
34364 175214 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 728 Burrows St 5 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6009081.49175 2092873.82998 37.7271458291085 -122.410819605863 (37.7271458291085, -122.410819605863) 9 3 7 309 28
53116 175186 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 526 Lathrop Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6012896.74794 2086580.57878 37.7100790097123 -122.397189112215 (37.7100790097123, -122.397189112215) 10 3 8 309 1
54598 203572 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 551 Pacheco St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993278.30091 2101842.3779 37.7508724439154 -122.466102066078 (37.7508724439154, -122.466102066078) 1 8 4 29491 40
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
72140 221898 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Marsily St 5 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6004300.13641 2095569.34378 37.7342778513286 -122.427540659282 (37.7342778513286, -122.427540659282) 2 7 5 28861 25
77660 175178 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 763 Morse St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5998593.8483 2087142.30255 37.7108147396853 -122.44666292955 (37.7108147396853, -122.44666292955) 9 7 6 28861 5
162886 203588 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 77 Staples Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   5999527.8711 2093756.33566 37.729028672217 -122.443909639833 (37.729028672217, -122.443909639833) 9 7 4 63 40
176460 124540 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1001 Balboa St 5 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5992434.91117 2111337.17059 37.7768939384148 -122.469709718849 (37.7768939384148, -122.469709718849) 11 6 2 54 11
193967 125548 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1445 Greenwich St 5 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6006007.30583 2119647.97872 37.8004884684307 -122.423349556855 (37.8004884684307, -122.423349556855) 13 9 1 28858 32

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