trees
130 rows where qSpecies_id = 135 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
85783 | 42930 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 500 Florida St | 5 | 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 | |||
95766 | 42929 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 500 Florida St | 4 | 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 | |||
126955 | 42928 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 500 Florida St | 3 | 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 | |||
141302 | 42940 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 90 14TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42835 | 6008035 | 2107992 | 37.768598204142 | -122.415507210488 | (37.768598204142, -122.415507210488) | 8 | 4 | 7 | 28853 | 19 | |||
179746 | 42938 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 90 14TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42835 | 6008035 | 2107992 | 37.768598204142 | -122.415507210488 | (37.768598204142, -122.415507210488) | 8 | 4 | 7 | 28853 | 19 | |||
54486 | 34500 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 25 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38222 | 6009645.01690865 | 2098580.66047923 | 37.7428471430012 | -122.409274044281 | (37.7428471430012, -122.409274044281) | 10 | 7 | 7 | 28859 | 2 | ||
110604 | 37273 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 3835 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2005 12:00:00 AM | Permit Number 48093 | 6002885.4241061 | 2102966.59502763 | 37.7545088594203 | -122.4329600781 | (37.7545088594203, -122.4329600781) | 2 | 4 | 5 | 28862 | 22 | ||
166864 | 63865 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1000 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24568 | 6002960.35246681 | 2111688.65043181 | 37.7784617483317 | -122.433324169044 | (37.7784617483317, -122.433324169044) | 15 | 9 | 11 | 29490 | 41 | ||
157931 | 34535 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 65 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38244 | 6009619.36143098 | 2098302.27912824 | 37.7420813311149 | -122.409343112846 | (37.7420813311149, -122.409343112846) | 10 | 7 | 7 | 28859 | 2 | ||
17356 | 42926 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 500 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43380 | 6009210.68116468 | 2105903.38929548 | 37.7629293730529 | -122.411293045793 | (37.7629293730529, -122.411293045793) | 8 | 4 | 7 | 28859 | 19 | ||
39054 | 40709 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 123 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41688 | 6004184.11835809 | 2094337.00833883 | 37.7308875722611 | -122.427853990581 | (37.7308875722611, -122.427853990581) | 9 | 7 | 6 | 28861 | 5 | ||
79953 | 43906 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1090 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 | ||
133325 | 43908 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1090 Hampshire St | 3 | 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 | |||
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 | |||
165649 | 48501 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1005(REVISED) Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45840 | 6003172.67516889 | 2102390.65351866 | 37.7529437493543 | -122.43192556655 | (37.7529437493543, -122.43192556655) | 2 | 4 | 5 | 28862 | 22 | |||
174894 | 120647 | Undocumented 4 | Arecastrum romanzoffianum :: Queen Palm 135 | 69x Dearborn St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/22/2016 12:00:00 AM | 3 | 3x3 | 6005880 | 2105692 | 37.7621615842697 | -122.422797712098 | (37.7621615842697, -122.422797712098) | 8 | 4 | 5 | 28859 | 19 | ||
124651 | 58288 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 338 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2008 12:00:00 AM | 3x3 | Permit Number 51750 | 6002903.89546307 | 2106265.3823574 | 37.763567585215 | -122.433131882506 | (37.763567585215, -122.433131882506) | 15 | 4 | 5 | 28862 | 3 | ||
742 | 37975 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1199 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
141366 | 37974 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1199 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
48045 | 33810 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 316 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 | ||
28568 | 37688 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 337 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2004 12:00:00 AM | Permit Number 40076 | 6007827.58787691 | 2105971.77560699 | 37.7630394784034 | -122.41608154409 | (37.7630394784034, -122.41608154409) | 8 | 4 | 7 | 28859 | 19 | ||
99289 | 35774 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 3692 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/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 | ||
140924 | 35772 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 3692 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/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 | ||
14785 | 52320 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 4308 21st St | 4 | 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 | ||
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 | ||
76167 | 52319 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 4308 21st St | 3 | 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 | ||
111384 | 52322 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 4308 21st St | 1 | 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 | ||
24485 | 50762 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1247 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2009 12:00:00 AM | Permit Number 53107 | 6009900.23371634 | 2109608.97618966 | 37.7731427119765 | -122.409169607112 | (37.7731427119765, -122.409169607112) | 14 | 2 | 9 | 28853 | 34 | |||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );