trees
130 rows where qSpecies_id = 135 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |||
95519 | 49632 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 63@ HOWARD Kissling St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2003 12:00:00 AM | Permit Number 46485 | 6008295.13782655 | 2109508.07731358 | 37.7727756153304 | -122.41471471751 | (37.7727756153304, -122.41471471751) | 8 | 2 | 9 | 28853 | 34 | ||
90866 | 49848 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 5 | 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 | |||
65076 | 49849 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 8 | 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 | |||
104344 | 49850 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 6 | 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 | |||
147883 | 49851 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 1 | 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 | |||
161093 | 49852 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 3 | 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 | |||
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 | |||
4414 | 49854 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 7 | 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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
85203 | 67606 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 888 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1996 12:00:00 AM | Permit Number 31179 | 6011033.13178113 | 2109012.34051696 | 37.7715678900614 | -122.405208723585 | (37.7715678900614, -122.405208723585) | 14 | 2 | 9 | 28853 | 34 | ||
68874 | 67787 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 3869 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1996 12:00:00 AM | Permit Number 31427 | 6003995.24886848 | 2102441.58633155 | 37.7531301965068 | -122.429084582188 | (37.7531301965068, -122.429084582188) | 2 | 4 | 5 | 28862 | 22 | ||
73114 | 67854 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 338 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31524 | 6004320.8787505 | 2099880.04207248 | 37.746115219117 | -122.427775989091 | (37.746115219117, -122.427775989091) | 2 | 7 | 5 | 63 | 22 | ||
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 |
180921 | 82202 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 3170-3172 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50066 | 6008538.87748807 | 2101576.58279524 | 37.751011244921 | -122.413310594546 | (37.751011244921, -122.413310594546) | 2 | 4 | 7 | 28859 | 19 | |
98974 | 91382 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 3255 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2009 12:00:00 AM | 3x3 | Permit Number 52080 | 6006568.9 | 2103493.4 | 37.7561635850725 | -122.420259015234 | (37.7561635850725, -122.420259015234) | 2 | 4 | 7 | 28859 | 19 | ||
1083 | 94032 | DPW Maintained 1 | Arecastrum romanzoffianum :: Queen Palm 135 | 1500 Oakdale Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015583.39088 | 2095096.21149 | 37.733610469696 | -122.388497468614 | (37.733610469696, -122.388497468614) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
183474 | 96697 | DPW Maintained 1 | Arecastrum romanzoffianum :: Queen Palm 135 | 1599X Oakdale Ave | 1 | 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 | |||
114298 | 97103 | Undocumented 4 | Arecastrum romanzoffianum :: Queen Palm 135 | 882 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2007 12:00:00 AM | 14 | 2x2 | 6009914 | 2104066 | 37.7579237379711 | -122.408730867443 | (37.7579237379711, -122.408730867443) | 2 | 4 | 7 | 28859 | 19 | ||
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 |
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) );