32 rows where DBH = 15 and qSpecies_id = 65 sorted by PlotSize

View and edit SQL

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)
7372 175205 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 653 Peru Ave 6 Side Yard : Yard Tree Private 2     15     6005071.6263 2092637.86098 37.7262722564417 -122.424664901662 (37.7262722564417, -122.424664901662) 9 7 6 28861 5
31207 32474 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/10/1996 12:00:00 AM 15   Permit Number 36982 6000854.39467 2106273.37873 37.7634730690508 -122.440221013784 (37.7634730690508, -122.440221013784) 15 5 5 28862 3
53408 37793 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 347 Hamilton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1998 12:00:00 AM 15   Permit Number 40121 6009401.77176 2092702.5768 37.7266935573585 -122.409700314138 (37.7266935573585, -122.409700314138) 10 3 7 309 28
60145 38581 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1483 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 15   Permit Number 40541 6015866.8585 2094128.4257 37.7309688285238 -122.387449938884 (37.7309688285238, -122.387449938884) 10 3 8 58 1
85408 67245 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4738 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1992 12:00:00 AM 15   Permit Number 30709 5983942.53029 2111768.14196 37.7775827533368 -122.499118839179 (37.7775827533368, -122.499118839179) 11 6 2 55 26
190011 66065 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 615 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/06/1990 12:00:00 AM 15   Permit Number 29105 6013588.8129 2104207.15934 37.7585164708659 -122.396031617282 (37.7585164708659, -122.396031617282) 10 3 8 28856 29
192251 44734 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1434 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/2001 12:00:00 AM 15   Permit Number 43849 5988947.4767 2101073.1476 37.7485095315689 -122.481021968545 (37.7485095315689, -122.481021968545) 1 8 3 29491 35
154695 4846 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 210 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/27/1992 12:00:00 AM 15 3X3   6006713.9746 2097429.76412 37.7395223890352 -122.419327161814 (37.7395223890352, -122.419327161814) 2 7 7 28859 2
100013 112856 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 1700x BAKER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6000040 2114920 37.7871680933118 -122.443658934554 (37.7871680933118, -122.443658934554) 15 6 1 29490 31
111705 74111 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 500X Avalon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/25/1994 12:00:00 AM 15 3x3   6003976.59234436 2092494.78352221 37.7258174919201 -122.428440184616 (37.7258174919201, -122.428440184616) 9 7 6 28861 5
138216 121328 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2455 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5986403.9195 2098529.3345 37.7413767161187 -122.489630387324 (37.7413767161187, -122.489630387324) 1 8 3 29491 35
155522 247495 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 537 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003124.7415 2110167.9221 37.7742955303854 -122.432646828997 (37.7742955303854, -122.432646828997) 15 9 11 29492 10
163162 141448 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 194 Beaumont Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5996892.1188 2111627.1044 37.7779466329687 -122.454311915058 (37.7779466329687, -122.454311915058) 15 6 2 54 16
23331 125557 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 22 Dashiell Hammett St 6 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 1ft   6010370.0822 2116109.39697 37.7910176441083 -122.40800283658 (37.7910176441083, -122.40800283658) 5 1 10 28857 21
76757 203585 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 122 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   5999428.77785 2093578.76175 37.7285354426355 -122.444239456297 (37.7285354426355, -122.444239456297) 9 7 4 63 40
4279 117667 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4750 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5983866.04939 2111764.3275 37.777567793158 -122.499383126218 (37.777567793158, -122.499383126218) 11 6 2 55 26
10474 221869 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 673 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6007432.02888 2095820.07599 37.7351429550833 -122.416730429683 (37.7351429550833, -122.416730429683) 2 7 7 28859 2
53011 221889 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 190 Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6006689.37303 2102664.80303 37.7538952362014 -122.419783585756 (37.7538952362014, -122.419783585756) 2 4 7 28859 19
69909 175176 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 226 Rome St 1 Sidewalk: Property side : Yard Tree Private 2     15 Width 3ft   5998630.92665 2088821.65601 37.7154279802818 -122.446655529047 (37.7154279802818, -122.446655529047) 9 7 6 28861 25
93698 203506 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 910 Kirkham St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5992059 2105289 37.7602655469825 -122.470569484113 (37.7602655469825, -122.470569484113) 1 8 4 56 12
107364 221928 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3666 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002501.47722 2106518.4971 37.7642397410968 -122.434541817574 (37.7642397410968, -122.434541817574) 15 5 5 28862 3
110481 175078 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1584 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001809.64472 2092991.82578 37.7270593952569 -122.435966703417 (37.7270593952569, -122.435966703417) 9 7 6 28861 25
130543 221890 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 190 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6006689.76882 2102684.09428 37.7539482278401 -122.419783585763 (37.7539482278401, -122.419783585763) 2 4 7 28859 19
155147 221860 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 516 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/27/1998 12:00:00 AM 15 Width 3ft Permit Number 39568 6001163.03933 2103237.69221 37.7551553815387 -122.438935950032 (37.7551553815387, -122.438935950032) 2 4 5 28862 22
165676 203552 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 181 Flood Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5999546.8407 2094056.93019 37.7298551168086 -122.443865648605 (37.7298551168086, -122.443865648605) 9 7 4 63 40
190577 221864 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 592 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002944.20199 2095934.50761 37.7352037204832 -122.432254626652 (37.7352037204832, -122.432254626652) 2 7 5 63 7
192627 221915 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 476 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6003301.60957 2102160.71382 37.7523196977161 -122.431463273608 (37.7523196977161, -122.431463273608) 2 4 5 28862 22
81710 125550 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1445 Greenwich St 9 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6006031.52695 2119650.26621 37.8004961162623 -122.423265904597 (37.8004961162623, -122.423265904597) 13 9 1 28858 32
87625 221792 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2818 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009842.62719 2102814.79283 37.7544842057885 -122.408889429605 (37.7544842057885, -122.408889429605) 2 4 7 28859 19
157703 123202 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1310 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5993110.48216 2112011.57103 37.7787846837447 -122.467421785255 (37.7787846837447, -122.467421785255) 11 6 2 54 11
178287 125551 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1445 Greenwich St 11 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6006045.33094 2119651.17602 37.8004993933977 -122.423218201864 (37.8004993933977, -122.423218201864) 13 9 1 28858 32
99045 221908 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1175 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6003228.29657 2101452.81084 37.7503718075255 -122.431666264992 (37.7503718075255, -122.431666264992) 2 4 5 28862 22

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