Option List Download
I used the download option list for the first time today and it didn't work correctly. Something happened with the delimiting feature or something like that.
Here's the body of what came out:
"label","key_value","condition_value","sort_order"
Baird Creek (Trib to Coweeman River),261,ZCDisplayValue_subbasin=='Coweeman',0
Coweeman River (Trib to Cowlitz River),567,ZCDisplayValue_subbasin=='Coweeman',1
Goble Creek (Trib to Coweeman River),5179,ZCDisplayValue_subbasin=='Coweeman',2
Mulholland Creek (Trib to Coweeman River),1295,ZCDisplayValue_subbasin=='Coweeman',3
North Fork Goble Creek (Trib to Goble Creek),845,ZCDisplayValue_subbasin=='Coweeman',4
South Fork Goble Creek (Trib to Goble Creek),4093,ZCDisplayValue_subbasin=='Coweeman',5
Big Tree Creek (Trib to East Fork Lewis River),4023,ZCDisplayValue_subbasin=='EF Lewis',6
Cedar Creek (Trib to Rock Creek - Upper),4088,ZCDisplayValue_subbasin=='EF Lewis',7
Coyote Creek (Trib to Rock Creek - Upper),4090,ZCDisplayValue_subbasin=='EF Lewis',8
East Fork Lewis River (Trib to Lewis River),1106,ZCDisplayValue_subbasin=='EF Lewis',9
King Creek (Trib to East Fork Lewis River),5467,ZCDisplayValue_subbasin=='EF Lewis',10
King Creek - LB Trib RM 2.31 (Trib to King Creek),5468,ZCDisplayValue_subbasin=='EF Lewis',11
Rock Creek - Upper (Trib to East Fork Lewis River),4056,ZCDisplayValue_subbasin=='EF Lewis',12
Beaver Creek (Trib to Elochoman River),294,"ZCDisplayValue_subbasin=='Elochoman, Skamokawa'",13
Clear Creek (Trib to Elochoman River),510,"ZCDisplayValue_subbasin=='Elochoman, Skamokawa'",14
East Fork Elochoman River (Trib to Elochoman River),742,"ZCDisplayValue_subbasin=='Elochoman, Skamokawa'",15
Elochoman River (Trib to Columbia River),741,"ZCDisplayValue_subbasin=='Elochoman, Skamokawa'",16
Jim Crow Creek (Trib to Columbia River),999,"ZCDisplayValue_subbasin=='Elochoman, Skamokawa'",17
Left Fork Skamokawa Creek (Trib to Skamokawa Creek),1616,"ZCDisplayValue_subbasin=='Elochoman, Skamokawa'",18
McDonald Creek (Trib to Skamokawa Creek),1205,"ZCDisplayValue_subbasin=='Elochoman, Skamokawa'",19
North Fork Elochoman River (Trib to Elochoman River),743,"ZCDisplayValue_subbasin=='Elochoman, Skamokawa'",20
Otter Creek (Trib to East Fork Elochoman River),5007,"ZCDisplayValue_subbasin=='Elochoman, Skamokawa'",21
Skamokawa Creek (Trib to Columbia River),4062,"ZCDisplayValue_subbasin=='Elochoman, Skamokawa'",22
Standard Creek (Trib to Skamokawa Creek),1707,"ZCDisplayValue_subbasin=='Elochoman, Skamokawa'",23
West Fork Elochoman River (Trib to Elochoman River),744,"ZCDisplayValue_subbasin=='Elochoman, Skamokawa'",24
Wilson Creek (Trib to Skamokawa Creek),3939,"ZCDisplayValue_subbasin=='Elochoman, Skamokawa'",25
EF Grays River RB Trib (Trib to East Fork Grays River),5029,"ZCDisplayValue_subbasin=='Grays, Chinook'",26
Blaney Creek (Trib to South Fork Grays River),348,"ZCDisplayValue_subbasin=='Grays, Chinook'",27
East Fork Grays River (Trib to Grays River),867,"ZCDisplayValue_subbasin=='Grays, Chinook'",28
'East Fork Grays River Trib' (Trib to East Fork Grays River),5028,"ZCDisplayValue_subbasin=='Grays, Chinook'",29
Fall Creek (Trib to Hull Creek),761,"ZCDisplayValue_subbasin=='Grays, Chinook'",30
Fossil Creek (Trib to Grays River),802,"ZCDisplayValue_subbasin=='Grays, Chinook'",31
Grays River (Trib to Columbia River),866,"ZCDisplayValue_subbasin=='Grays, Chinook'",32
Hull Creek (Trib to Grays River),954,"ZCDisplayValue_subbasin=='Grays, Chinook'",33
Hull Creek - West Fork (Trib to Hull Creek),5010,"ZCDisplayValue_subbasin=='Grays, Chinook'",34
Klints Creek (Trib to Grays River),1062,"ZCDisplayValue_subbasin=='Grays, Chinook'",35
Mitchell Creek (Trib to East Fork Grays River),1261,"ZCDisplayValue_subbasin=='Grays, Chinook'",36
Sisson Creek (Trib to Deep River),1610,"ZCDisplayValue_subbasin=='Grays, Chinook'",37
South Fork Grays River (Trib to Grays River),868,"ZCDisplayValue_subbasin=='Grays, Chinook'",38
West Fork Grays River (Trib to Grays River),869,"ZCDisplayValue_subbasin=='Grays, Chinook'",39
Beaver Creek (Trib to Green River),5154,
ZCDisplayValue_subbasin=='Green',40
Cascade Creek (Trib to Green River),462,
ZCDisplayValue_subbasin=='Green',41
Devils Creek (Trib to Green River),625,
ZCDisplayValue_subbasin=='Green',42
Elk Creek (Trib to Green River),5006,
ZCDisplayValue_subbasin=='Green',43
Green 2550 Trib (Trib to Green River),5151,
ZCDisplayValue_subbasin=='Green',44
Green River (Trib to North Fork Toutle River),872,
ZCDisplayValue_subbasin=='Green',45
Miners Creek (Trib to Green River),5157,
ZCDisplayValue_subbasin=='Green',46
Cedar Creek (Trib to Kalama River),473,
ZCDisplayValue_subbasin=='Kalama',47
Hatchery Creek (Trib to Kalama River),4034,
ZCDisplayValue_subbasin=='Kalama',48
Indian Creek (Trib to Kalama River),5003,
ZCDisplayValue_subbasin=='Kalama',49
Kalama River (Trib to Columbia River),1039,
ZCDisplayValue_subbasin=='Kalama',50
Arkansas Creek (Trib to Cowlitz River),251,
ZCDisplayValue_subbasin=='Lower Cowlitz',51
Baker Creek (Trib to Lacamas Creek),262,
ZCDisplayValue_subbasin=='Lower Cowlitz',52
Baxter Creek (Trib to Arkansas Creek),5338,
ZCDisplayValue_subbasin=='Lower Cowlitz',53
Bear Creek (Trib to Lacamas Creek),277,
ZCDisplayValue_subbasin=='Lower Cowlitz',54
Becker Creek (Trib to Stillwater Creek),304,
ZCDisplayValue_subbasin=='Lower Cowlitz',55
Blue Creek (Trib to Cowlitz River),352,
ZCDisplayValue_subbasin=='Lower Cowlitz',56
Brights Creek (Trib to Cowlitz River),387,
ZCDisplayValue_subbasin=='Lower Cowlitz',57
Campbell Creek (Trib to Stillwater Creek),428,
ZCDisplayValue_subbasin=='Lower Cowlitz',58
Cedar Creek (Trib to Salmon Creek),472,
ZCDisplayValue_subbasin=='Lower Cowlitz',59
Coon Creek (Trib to Lacamas Creek),552,
ZCDisplayValue_subbasin=='Lower Cowlitz',60
Cowlitz Prairie Creek (Trib to Mill Creek),5461,
ZCDisplayValue_subbasin=='Lower Cowlitz',61
Curtis Creek (Trib to Olequa Creek),585,
ZCDisplayValue_subbasin=='Lower Cowlitz',62
Delameter Creek (Trib to Arkansas Creek),619,
ZCDisplayValue_subbasin=='Lower Cowlitz',63
King Creek (Trib to Olequa Creek),1054,
ZCDisplayValue_subbasin=='Lower Cowlitz',64
Lacamas Creek (Trib to Cowlitz River),1076,
ZCDisplayValue_subbasin=='Lower Cowlitz',65
Leckler Creek (Trib to Cowlitz River),1099,
ZCDisplayValue_subbasin=='Lower Cowlitz',66
McCorkle Creek (Trib to Cowlitz River),5469,
ZCDisplayValue_subbasin=='Lower Cowlitz',67
Mill Creek (Trib to Cowlitz River),1235,
ZCDisplayValue_subbasin=='Lower Cowlitz',68
Monahan Creek (Trib to Delameter Creek),1268,
ZCDisplayValue_subbasin=='Lower Cowlitz',69
North Fork Arkansas Creek (Trib to Arkansas Creek),5375,
ZCDisplayValue_subbasin=='Lower Cowlitz',70
North Fork Brim Creek (Trib to Brim Creek),389,
ZCDisplayValue_subbasin=='Lower Cowlitz',71
North Fork King Creek (Trib to King Creek),1056,
ZCDisplayValue_subbasin=='Lower Cowlitz',72
North Fork Olequa Creek (Trib to Olequa Creek),1370,
ZCDisplayValue_subbasin=='Lower Cowlitz',73
Olequa Creek (Trib to Cowlitz River),1369,
ZCDisplayValue_subbasin=='Lower Cowlitz',74
Ostrander Creek (Trib to Cowlitz River),1377,
ZCDisplayValue_subbasin=='Lower Cowlitz',75
Salmon Creek (Trib to Cowlitz River),1541,
ZCDisplayValue_subbasin=='Lower Cowlitz',76
Sandy Bend Creek (Trib to Cowlitz River),5471,
ZCDisplayValue_subbasin=='Lower Cowlitz',77
South Fork Olequa Creek (Trib to Olequa Creek),1371,
ZCDisplayValue_subbasin=='Lower Cowlitz',78
South Fork Ostrander Creek (Trib to Ostrander Creek),5173,
ZCDisplayValue_subbasin=='Lower Cowlitz',79
Stillwater Creek (Trib to Olequa Creek),1723,
ZCDisplayValue_subbasin=='Lower Cowlitz',80
Stillwater RB Trib 1 (Trib to Stillwater Creek),5476,
ZCDisplayValue_subbasin=='Lower Cowlitz',81
Stillwater RB Trib 2 (Trib to Stillwater Creek),5477,
ZCDisplayValue_subbasin=='Lower Cowlitz',82
Whittle Creek (Trib to Cowlitz River),3925,
ZCDisplayValue_subbasin=='Lower Cowlitz',83
Greenleaf Creek (Trib to Hamilton Creek),874,
ZCDisplayValue_subbasin=='Lower Gorge',84
Hamilton Creek (Trib to Columbia River),889,
ZCDisplayValue_subbasin=='Lower Gorge',85
Woodward Creek (Trib to Columbia River),3960,
ZCDisplayValue_subbasin=='Lower Gorge',86
Abernathy Creek (Trib to Columbia River),213,"ZCDisplayValue_subbasin=='Mill, Abernathy, Germany, Coal'",87
'Benny Creek' (Trib to Germany Creek),5012,"ZCDisplayValue_subbasin=='Mill, Abernathy, Germany, Coal'",88
Cameron Creek (Trib to Abernathy Creek),422,"ZCDisplayValue_subbasin=='Mill, Abernathy, Germany, Coal'",89
Erick Creek (Trib to Abernathy Creek),4097,"ZCDisplayValue_subbasin=='Mill, Abernathy, Germany, Coal'",90
Germany Creek (Trib to Columbia River),834,"ZCDisplayValue_subbasin=='Mill, Abernathy, Germany, Coal'",91
Mill Creek (Trib to Columbia River),1237,"ZCDisplayValue_subbasin=='Mill, Abernathy, Germany, Coal'",92
Ordway Creek (Trib to Abernathy Creek),4099,"ZCDisplayValue_subbasin=='Mill, Abernathy, Germany, Coal'",93
Sara Creek (Trib to Abernathy Creek),5001,"ZCDisplayValue_subbasin=='Mill, Abernathy, Germany, Coal'",94
South Fork Mill Creek (Trib to Mill Creek),1586,"ZCDisplayValue_subbasin=='Mill, Abernathy, Germany, Coal'",95
Spruce Creek (Trib to South Fork Mill Creek),1695,"ZCDisplayValue_subbasin=='Mill, Abernathy, Germany, Coal'",96
Wiest Creek (Trib to Abernathy Creek),5002,"ZCDisplayValue_subbasin=='Mill, Abernathy, Germany, Coal'",97
Bear Creek (Trib to South Fork Toutle River),5005,
ZCDisplayValue_subbasin=='SF Toutle',98
Clancy Creek (Trib to South Fork Toutle River),5016,
ZCDisplayValue_subbasin=='SF Toutle',99
Disappointment Creek (Trib to South Fork Toutle River),5004,
ZCDisplayValue_subbasin=='SF Toutle',100
Dollar Creek (Trib to South Fork Toutle River),841,
ZCDisplayValue_subbasin=='SF Toutle',101
Flye Creek (Trib to South Fork Toutle River),5015,
ZCDisplayValue_subbasin=='SF Toutle',102
Goat Creek (Trib to South Fork Toutle River),5022,
ZCDisplayValue_subbasin=='SF Toutle',103
Goat Creek - RB Trib (Trib to Goat Creek),5464,
ZCDisplayValue_subbasin=='SF Toutle',104
Harrington Creek (Trib to South Fork Toutle River),902,
ZCDisplayValue_subbasin=='SF Toutle',105
Johnson Creek (Trib to South Fork Toutle River),1012,
ZCDisplayValue_subbasin=='SF Toutle',106
Loch Creek (Trib to Lower Loch Creek),5014,
ZCDisplayValue_subbasin=='SF Toutle',107
South Fork Toutle River (Trib to Toutle River),1802,
ZCDisplayValue_subbasin=='SF Toutle',108
Studebaker Creek (Trib to South Fork Toutle River),1736,
ZCDisplayValue_subbasin=='SF Toutle',109
Trouble Creek (Trib to South Fork Toutle River),1807,
ZCDisplayValue_subbasin=='SF Toutle',110
Boulder Creek (Trib to Little Washougal River),365,
ZCDisplayValue_subbasin=='Washougal',111
East Fork Little Washougal River (Trib to Little Washougal River),1134,
ZCDisplayValue_subbasin=='Washougal',112
Jones Creek (Trib to East Fork Little Washougal River),1022,
ZCDisplayValue_subbasin=='Washougal',113
Little Washougal River (Trib to Washougal River),1135,
ZCDisplayValue_subbasin=='Washougal',114
Washougal River (Trib to Columbia River),3883,
ZCDisplayValue_subbasin=='Washougal',115
Not On List,-1,subbasin>-1,116
-
"Hey Tony, It seems to have problems with the delimiting of option lists that have commas within them I downloaded a bunch of them with and without commas within the text and the files without commas are fine, whereas those with commas have this problem. This seems to make sense since it is a comma separated file. However, (I think you’ll agree) the flexibility of having commas in the text of the option lists is very valuable and should be supported in import and export. Thanks Steve" (the message was delivered to our Spam inbox)
-
Hi Steve,
I'll be reaching out to you in our support. From my testing, downloading/uploading CSV with commas seem to be working fine for me, though I am doing a simple test. The export you pasted here does seem like it's missing a bunch of data and we'll want to look at.
Thanks,
Keith
Please sign in to leave a comment.
Comments
5 comments