trees

21 rows where Supervisor Districts = 7, qLegalStatus_id = 7 and qSpecies_id = 65

✎ View and edit SQL

This data as json, CSV (advanced)

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)
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
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
23336 63134 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 27 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23649 6007447.90223159 2099378.78534919 37.7449152757931 -122.416927606356 (37.7449152757931, -122.416927606356) 2 7 7 28859 2
33290 63461 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 45 Powers Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1987 12:00:00 AM     Permit Number 24052 6006867.21716204 2099801.68707108 37.7460437878528 -122.418965501899 (37.7460437878528, -122.418965501899) 2 7 7 28859 2
35130 63135 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 25 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23650 6007455.65629161 2099393.17627053 37.7449552262088 -122.416901813576 (37.7449552262088, -122.416901813576) 2 7 7 28859 2
56987 63133 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 28 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23648 6007400.02445462 2099399.55358264 37.7449696074565 -122.417094630618 (37.7449696074565, -122.417094630618) 2 7 7 28859 2
58635 63004 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 368 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/1986 12:00:00 AM 20 4x6 Permit Number 23414 6007279.07639479 2096499.56656681 37.7370000828457 -122.417307379598 (37.7370000828457, -122.417307379598) 2 7 7 28859 2
67823 103022 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 40X Coleridge St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/15/2013 12:00:00 AM 3 3x3 Permit Number 770067 6006901 2099544.2 37.7453386886112 -122.418830426928 (37.7453386886112, -122.418830426928) 2 7 7 28859 2
69147 33484 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 300 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM 30 6x6 Permit Number 37610 6006227.43678663 2098258.25526822 37.741769825751 -122.421068211473 (37.741769825751, -122.421068211473) 2 7 7 28859 2
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
76448 108926 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 36 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772355 6007347.4 2099299.8 37.7446927459132 -122.417269529335 (37.7446927459132, -122.417269529335) 2 7 7 28859 2
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
129447 63292 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 3075 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23858 6009183.06965006 2100534.27317896 37.7481854410784 -122.411009292537 (37.7481854410784, -122.411009292537) 2 4 7 28859 2
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
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
132523 115548 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 368 Highland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   20 4x6   6007279.07639479 2096499.56656681 37.7370000828457 -122.417307379598 (37.7370000828457, -122.417307379598) 2 7 7 28859 2
132571 63129 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 34 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23643 6007144.61352889 2099320.79872129 37.7447389927671 -122.417972215495 (37.7447389927671, -122.417972215495) 2 7 7 28859 2
142834 33539 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 253 BOCANA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2015 12:00:00 AM   4x4 Permit Number 775951 6007035 2097463 37.7396317225537 -122.418219548801 (37.7396317225537, -122.418219548801) 2 7 7 28859 2
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
185506 63233 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 200x ESMERALDA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/13/1987 12:00:00 AM     Permit Number 23781 6007093 2098828 37.7433829729046 -122.41811575542 (37.7433829729046, -122.41811575542) 2 7 7 28859 2

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