26 rows where DBH = 16 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)
6628 73438 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 212 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     5989642.98356 2113924.77294 37.7838370079244 -122.479557105797 (37.7838370079244, -122.479557105797) 11 6 2 55 26
12867 73402 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1434 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     5982802.3301 2105339.2702 37.759863969648 -122.502587148941 (37.759863969648, -122.502587148941) 1 8 3 56 35
14208 70581 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 366 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     5989681.74367 2112910.59233 37.7810546031553 -122.47934879186 (37.7810546031553, -122.47934879186) 11 6 2 55 26
65829 68256 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 243 Holyoke St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 16   Permit Number 32061 6009551.9423 2093241.4503 37.7281816043806 -122.409219186739 (37.7281816043806, -122.409219186739) 10 3 7 309 28
165874 38552 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1820 Keith St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 16   Permit Number 40520 6015364.9925 2093693.5794 37.7297470188732 -122.389154637038 (37.7297470188732, -122.389154637038) 10 3 8 58 1
190685 39931 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 175 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/1999 12:00:00 AM 16   Permit Number 41202 6010293.70332 2087956.69983 37.7137123004597 -122.406282682604 (37.7137123004597, -122.406282682604) 9 7 8 309 39
193468 114082 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 20 Cook St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     5997500.7704 2113521.7588 37.7831837426404 -122.452343137457 (37.7831837426404, -122.452343137457) 15 6 1 54 31
30504 37659 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 486 Funston Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2008 12:00:00 AM 16 3x3 Permit Number 51139 5991909.24916 2112157.7974 37.7791167592266 -122.471587940686 (37.7791167592266, -122.471587940686) 11 6 2 54 11
33356 138630 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1702 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6000078.3648 2114795.7207 37.7868290426993 -122.443517270296 (37.7868290426993, -122.443517270296) 13 6 1 29490 27
97742 141702 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 154 BEAUMONT AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5996846.4318 2111948.6051 37.7788267693983 -122.454493192496 (37.7788267693983, -122.454493192496) 15 6 2 54 16
181596 140134 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1624 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5999973.0263 2110940.5311 37.7762376765447 -122.443604667807 (37.7762376765447, -122.443604667807) 15 5 11 29492 16
71152 221844 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 127 Saint Marys Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6004153.19016 2095736.31086 37.7347279926082 -122.428060594226 (37.7347279926082, -122.428060594226) 2 7 5 28861 25
125012 221854 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4418 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6000475.00831 2102295.38218 37.7525288566262 -122.441247749083 (37.7525288566262, -122.441247749083) 2 4 5 28862 22
6832 221870 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 530 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6008584.18129 2096552.27767 37.7372181568784 -122.412798757353 (37.7372181568784, -122.412798757353) 10 7 7 28859 2
16984 203543 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 518 Hearst Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5997969.26989 2094410.6553 37.7307362500808 -122.449344943519 (37.7307362500808, -122.449344943519) 9 7 4 59 40
45404 221907 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1217 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003244.02772 2101149.87665 37.7495409130801 -122.431590240821 (37.7495409130801, -122.431590240821) 2 4 5 28862 22
49629 221833 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 577 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6007293.94274 2103980.62531 37.7575422218038 -122.417786099775 (37.7575422218038, -122.417786099775) 2 4 7 28859 19
103811 189214 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1498 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6014376.75149 2102028.72002 37.7525787510095 -122.393154121288 (37.7525787510095, -122.393154121288) 10 3 8 28856 29
139320 203578 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 312 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5999939.80462 2094974.46238 37.7323968536154 -122.442572982852 (37.7323968536154, -122.442572982852) 9 7 4 63 40
143155 221914 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 476 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003319.74249 2102160.73191 37.7523207750848 -122.431400568387 (37.7523207750848, -122.431400568387) 2 4 5 28862 22
149081 221900 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Marsily St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6004249.68912 2095508.61359 37.7341082463924 -122.427710746252 (37.7341082463924, -122.427710746252) 2 7 5 28861 25
154673 221886 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 121 Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6006322.71195 2097511.22057 37.7397240062552 -122.420685761336 (37.7397240062552, -122.420685761336) 2 7 7 28859 2
157942 221798 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 430 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6004116.67022 2110321.94704 37.7747746486742 -122.429226550889 (37.7747746486742, -122.429226550889) 7 9 11 28852 10
171216 203540 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 305 Foerster St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5998091.57112 2094441.2535 37.7308272605603 -122.448924334186 (37.7308272605603, -122.448924334186) 9 7 4 59 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
35544 221939 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 21 Harry St 3 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6003408.10773 2097774.81236 37.740283068906 -122.430782023672 (37.740283068906, -122.430782023672) 2 7 5 63 7

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