trees

23 rows where SiteOrder = 2 and qSpecies_id = 135

✎ View and edit SQL

This data as json, CSV (advanced)

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)
1637 35981 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 83 Prospect Stairs Street 2 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1998 12:00:00 AM     Permit Number 39135                    
5514 35799 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135   2 Sidewalk: Curb side : Cutout Tree Private 2   04/22/1998 12:00:00 AM     Permit Number 39046                    
7274 72838 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 3166 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/20/2011 12:00:00 AM 10 3x3 Permit Number 768580 6008564.90127915 2101578.02320048 37.7510166609997 -122.413220703223 (37.7510166609997, -122.413220703223) 2 4 7 28859 19
12049 31854 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 1263 Houston St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35300                    
17724 36678 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 99X ALBION ST 2 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1998 12:00:00 AM 16 3x3 Permit Number 39481 6005790 2106965 37.7656518628938 -122.42319948022 (37.7656518628938, -122.42319948022) 8 4 5 28853 19
19124 110333 DPW Maintained 1 Arecastrum romanzoffianum :: Queen Palm 135 53x DEARBORN ST 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005854 2105793 37.7624374394694 -122.422894814814 (37.7624374394694, -122.422894814814) 8 4 5 28859 19
23361 33811 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 316 Prospect Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/26/1996 12:00:00 AM     Permit Number 37826 6006425.25516212 2098022.87661931 37.7411346781584 -122.420367516795 (37.7411346781584, -122.420367516795) 2 7 7 28859 2
35457 47121 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 81 Santa Marina St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM     Permit Number 45103 6006109.36945154 2097632.81728263 37.7400458571469 -122.421432043326 (37.7400458571469, -122.421432043326) 2 7 7 28859 2
45495 42927 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 500 Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42831 6009210.68116468 2105903.38929548 37.7629293730529 -122.411293045793 (37.7629293730529, -122.411293045793) 8 4 7 28859 19
46150 52321 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 4308 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/2005 12:00:00 AM     Permit Number 48475 6001136.61726657 2103347.24100136 37.7554546726713 -122.43903517577 (37.7554546726713, -122.43903517577) 2 4 5 28862 38
50433 40321 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 3498x 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41461 6006512.30004445 2100871.01023057 37.7489599147889 -122.420268642175 (37.7489599147889, -122.420268642175) 2 4 7 28859 19
52579 42003 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 240 Manor Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42337 5993892.40263021 2094032.39552185 37.7294635953142 -122.463411763134 (37.7294635953142, -122.463411763134) 9 8 4 59 40
78988 31425 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 4220 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/1995 12:00:00 AM     Permit Number 35007 6001430.13223279 2103389.64483278 37.7555877996488 -122.438023150412 (37.7555877996488, -122.438023150412) 2 4 5 28862 3
83984 97104 Undocumented 4 Arecastrum romanzoffianum :: Queen Palm 135 882 York St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 2x2   6009914 2104066 37.7579237379711 -122.408730867443 (37.7579237379711, -122.408730867443) 2 4 7 28859 19
107797 37513 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 835 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39970 6007729.27336023 2114396.12651658 37.786165215164 -122.417018514766 (37.786165215164, -122.417018514766) 13 1 9 28858 36
110738 96696 DPW Maintained 1 Arecastrum romanzoffianum :: Queen Palm 135 1599X Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6015060.5348 2095438.80494 37.7345221731935 -122.390329076986 (37.7345221731935, -122.390329076986) 10 3 8 58 1
115994 120507 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 888 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6011033.13178113 2109012.34051696 37.7715678900614 -122.405208723585 (37.7715678900614, -122.405208723585) 14 2 9 28853 34
134421 42083 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 301 Precita Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42392 6008452.52473671 2100207.10363126 37.7472461128688 -122.413512366427 (37.7472461128688, -122.413512366427) 2 7 7 28859 2
135813 43907 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 1090 Hampshire St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2000 12:00:00 AM     Permit Number 43506 6010229.84125337 2102875.27259753 37.7546719517198 -122.407554599825 (37.7546719517198, -122.407554599825) 2 4 7 28859 19
154574 49853 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 600@ WOODSIDE Portola Dr 2 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM     Permit Number 46628 5997402.05166497 2099836.0241137 37.7456005399249 -122.451697110084 (37.7456005399249, -122.451697110084) 1 7 4 59 40
163105 35773 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 3692 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1998 12:00:00 AM     Permit Number 39030 6004971.89537308 2105472.67366607 37.7615080868858 -122.425922888595 (37.7615080868858, -122.425922888595) 8 4 5 28859 19
166407 49936 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 2526 26th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/02/2003 12:00:00 AM     Permit Number 46695 5988331.02491105 2098109.84036386 37.7403372178988 -122.482936471841 (37.7403372178988, -122.482936471841) 1 8 3 29491 35
171263 42049 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 405 Duncan St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 779344 6003892.7703069 2099803.34109747 37.7458803892155 -122.42925086473 (37.7458803892155, -122.42925086473) 2 7 5 63 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)
);