trees

28 rows where Neighborhoods (old) = 19 and qSpecies_id = 65 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus_id ✖

SiteOrder ✖

  • 1 23
  • 2 5

Neighborhoods (old) ✖

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)
21022 69205 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2860 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33254 6008952.43931379 2101803.50283851 37.7516575269948 -122.411896484829 (37.7516575269948, -122.411896484829) 2 4 7 28859 19
74836 66622 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 867 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/15/1991 12:00:00 AM     Permit Number 29826 6010209.78585513 2104179.32451342 37.7582514640983 -122.407715901057 (37.7582514640983, -122.407715901057) 10 4 7 28859 19
101142 65305 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 3629 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1989 12:00:00 AM     Permit Number 28122 6005455.44263685 2104863.06150764 37.7598615508482 -122.424207139046 (37.7598615508482, -122.424207139046) 2 4 5 28859 19
129894 69204 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2850 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33252 6008949.31851966 2101859.27420808 37.7518104876034 -122.411911217702 (37.7518104876034, -122.411911217702) 2 4 7 28859 19
150990 64607 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2451 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/18/1988 12:00:00 AM 20   Permit Number 25510 6008240.6573587 2104159.54552526 37.7580867271242 -122.414524628823 (37.7580867271242, -122.414524628823) 2 4 7 28859 19
167156 69206 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2864 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33255 6008953.68763074 2101781.1943032 37.7515963427841 -122.411890591701 (37.7515963427841, -122.411890591701) 2 4 7 28859 19
754 34739 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 581 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM   3x3 Permit Number 38389 6007302.61875581 2103939.58827334 37.7574300317864 -122.417753185833 (37.7574300317864, -122.417753185833) 2 4 7 28859 19
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
93872 102475 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 581 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 38389 6007298 2103932 37.7574089362149 -122.417768621509 (37.7574089362149, -122.417768621509) 2 4 7 28859 19
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
41894 221832 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 573 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007293.28891 2103997.59658 37.7575887842104 -122.417789563935 (37.7575887842104, -122.417789563935) 2 4 7 28859 19
42770 221831 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 569 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007292.05586 2104018.90213 37.7576472149557 -122.417795338504 (37.7576472149557, -122.417795338504) 2 4 7 28859 19
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
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
88668 221892 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3272 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007901.84296 2101535.98387 37.7508639830901 -122.415510655785 (37.7508639830901, -122.415510655785) 2 4 7 28859 19
99508 221835 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 585 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007295.48201 2103941.69106 37.7574354039359 -122.41777801665 (37.7574354039359, -122.41777801665) 2 4 7 28859 19
120305 221888 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 192 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006128.60788 2102045.32396 37.7521626832758 -122.421678849418 (37.7521626832758, -122.421678849418) 2 4 5 28859 19
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
152125 221834 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 581 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6007293.84054 2103959.34746 37.7574837919732 -122.417784945026 (37.7574837919732, -122.417784945026) 2 4 7 28859 19
162952 221836 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 585 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007298.30885 2103900.40234 37.7573221936904 -122.417765313729 (37.7573221936904, -122.417765313729) 2 4 7 28859 19
15498 221829 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2451 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6008243.92561 2104140.04763 37.7580333739666 -122.414511946088 (37.7580333739666, -122.414511946088) 2 4 7 28859 19
20666 221837 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 109 Bartlett St 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 4ft   6006703.42014 2103074.38684 37.7550206505078 -122.419764067776 (37.7550206505078, -122.419764067776) 2 4 7 28859 19
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
91243 221828 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1070 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6008613.25764 2102303.67809 37.7530118609308 -122.413104786776 (37.7530118609308, -122.413104786776) 2 4 7 28859 19
179502 221830 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2451 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   6008241.38226 2104159.63616 37.7580870167112 -122.414522128209 (37.7580870167112, -122.414522128209) 2 4 7 28859 19
91117 221789 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3456 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 5ft   6005341.04131 2103147.38287 37.7551442389361 -122.424480760089 (37.7551442389361, -122.424480760089) 2 4 5 28859 19
101047 221790 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3456 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2     36 Width 5ft   6005327.10837 2103145.45598 37.7551381613168 -122.424528807253 (37.7551381613168, -122.424528807253) 2 4 5 28859 19
98506 221791 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 867 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/15/1991 12:00:00 AM 30 Width 6ft Permit Number 29826 6010196.62735 2104192.74111 37.7582875664398 -122.407762355146 (37.7582875664398, -122.407762355146) 10 4 7 28859 19

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