trees
14 rows where SiteOrder = 4 and qSpecies_id = 135
This data as json, CSV (advanced)
These facets timed out: 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 17496 | 35801 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1998 12:00:00 AM | Permit Number 39046 | ||||||||||||||
| 36942 | 120509 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 888 Brannan St | 4 | 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 | ||||
| 57225 | 42008 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 240 Manor Dr | 4 | 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 | ||
| 72683 | 42051 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 405 Duncan St | 4 | 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 | ||
| 75703 | 110335 | DPW Maintained 1 | Arecastrum romanzoffianum :: Queen Palm 135 | 53x DEARBORN ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005854 | 2105793 | 37.7624374394694 | -122.422894814814 | (37.7624374394694, -122.422894814814) | 8 | 4 | 5 | 28859 | 19 | ||||
| 90762 | 108142 | Undocumented 4 | Arecastrum romanzoffianum :: Queen Palm 135 | 3390x 18TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006957.7 | 2105612.4 | 37.7620037686995 | -122.419064704614 | (37.7620037686995, -122.419064704614) | 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 | |||
| 96902 | 49855 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 4 | 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 | |||
| 100199 | 36676 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 99X ALBION ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1998 12:00:00 AM | 14 | 3x3 | Permit Number 39481 | 6005790 | 2106965 | 37.7656518628938 | -122.42319948022 | (37.7656518628938, -122.42319948022) | 8 | 4 | 5 | 28853 | 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 | ||
| 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 | ||
| 176985 | 31427 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 4220 21st St | 4 | 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 | ||
| 189513 | 35724 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 190 Dartmouth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.412628258541 | (37.7280780839519, -122.412628258541) | 9 | 3 | 7 | 309 | 28 |
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) );