24 rows where DBH = 12 and qSpecies_id = 65 sorted by PlotSize

View and edit SQL

These facets timed out: 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)
101240 44243 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4005 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2001 12:00:00 AM 12   Permit Number 43678 5983313.0175 2106265.8208 37.7624380119611 -122.500889481832 (37.7624380119611, -122.500889481832) 1 8 3 56 35
124927 114086 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 20 Cook St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     5997489.0948 2113600.1035 37.783398187645 -122.452389185424 (37.783398187645, -122.452389185424) 15 6 1 54 31
188048 175198 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 648 Peru Ave 2 Side Yard : Yard Tree Private 2     12     6005048.079 2092617.03467 37.7262137420546 -122.424744822616 (37.7262137420546, -122.424744822616) 9 7 6 28861 5
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
145465 96870 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 620 Palmetto Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     12 2x3   5991859.90832 2087240.59875 37.7106976749231 -122.469943914081 (37.7106976749231, -122.469943914081) 9 8 4 64 24
112681 1278 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3995X Alemany Blvd 16 Sidewalk: Curb side : Cutout Tree DPW 1   02/21/1990 12:00:00 AM 12 3X3   5992545.03604 2087392.68167 37.711154838998 -122.467587032028 (37.711154838998, -122.467587032028) 9 8 4 64 24
144920 1269 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3995X Alemany Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5992328.07158 2087287.97745 37.7108548170665 -122.468329295555 (37.7108548170665, -122.468329295555) 9 8 4 64 24
61694 26511 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2850 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008945.12722 2101866.39993 37.7518298180943 -122.411926215341 (37.7518298180943, -122.411926215341) 2 4 7 28859 19
63335 102588 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 222 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002344.3 2109244.2 37.7717149279992 -122.435280428905 (37.7717149279992, -122.435280428905) 15 5 11 29492 9
130795 81299 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 109 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM 12 3x3 Permit Number 50541 6006708.25661782 2103139.88479614 37.7552007652727 -122.419751988993 (37.7552007652727, -122.419751988993) 2 4 7 28859 19
160053 107230 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1445 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005960.15833 2119639.59713 37.8004627936866 -122.423512110213 (37.8004627936866, -122.423512110213) 13 9 1 28858 32
125241 138631 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1704 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6000076.1375 2114809.8269 37.7868676476344 -122.443525989893 (37.7868676476344, -122.443525989893) 13 6 1 29490 27
156768 187082 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2600 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5985191.6703 2096995.0278 37.737093071648 -122.493708827707 (37.737093071648, -122.493708827707) 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
156364 125552 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 22 Dashiell Hammett St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 1ft   6010384.14225 2116014.5877 37.7907581078366 -122.407947500375 (37.7907581078366, -122.407947500375) 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
29348 221851 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6004484.38042 2095546.73676 37.7342261969882 -122.426902058798 (37.7342261969882, -122.426902058798) 2 7 5 28861 25
44302 221856 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 310 Hoffman Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6000610.61852 2101933.59312 37.7515431951678 -122.440752837776 (37.7515431951678, -122.440752837776) 2 4 5 28862 22
64032 221815 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3734 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008428.67762 2097499.17078 37.7398093887782 -122.413403351802 (37.7398093887782, -122.413403351802) 2 7 7 28859 2
95633 221883 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 34 Prospect Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007121.00835 2099271.28888 37.7446017212974 -122.418050328662 (37.7446017212974, -122.418050328662) 2 7 7 28859 2
133146 175192 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 63 Lamartine St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6002620.39107 2094490.53041 37.7312205232959 -122.433271011664 (37.7312205232959, -122.433271011664) 9 7 5 28861 25
97195 124538 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1001 Balboa St 10 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5992462.99268 2111339.00328 37.7769005935172 -122.469612710685 (37.7769005935172, -122.469612710685) 11 6 2 54 11
146877 203582 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 24 Gennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5997457.41638 2093726.64675 37.7288288329774 -122.451065185614 (37.7288288329774, -122.451065185614) 9 7 4 28861 40
33222 203575 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 60 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 5ft   6001009.56246 2095231.0134 37.7331622045591 -122.438892966938 (37.7331622045591, -122.438892966938) 9 7 5 63 40

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