DESIGN OF A FISHERIES LANDINGS SURVEY ODK XLS FORM

This page describes the design of a form for a landing survey with horizontal sampling for fishing effort.

I.e. in one form we collect data;

  1. on fishing effort;
  2. on the landings and price by species.

A paper form for such a landing survey is presented below

Landing survey formIn the form you see the following variables;

  1. Major strata
  2. Minor strata
  3. Landing site
  4. Date
  5. Name of the enumerator
  6. Type of canoe
  7. Major fishing gear
  8. Duration of the fising trip (days)
  9. Fishing effort
    • Fished yesterday?
    • Fished before yesterday?
    • How many days fished last week
  10. Landings
    • Species name or code
    • Quantity landed
    • First sales price per kg

Strata and landing sites

The major strata, minor strata and landing sites are linked. A certain number of landing sites are located in a minor strata and minor strata are located in a major strata.


Fishing units

A fishing unit is defined a “Type of canoe & type of major gear”


Fishing effort

The number of monthly fishing days of a fishing units is calculated as;

No of Fishing days: ((Today=1+Yesterday (yes=1)+Before yesterday (yes=1)+number last week)/10)*30.5


Fish landings

The fish landings and prices are collected by species.

You should note that one fishing unit can land several species. This is a “One to Many” relationship, One canoe-Many species.

This is important in the design of the ODK form as it require a “Repeat question”.


This paper form has been converted to an ODK XLS form and the design will be explained in the next paragraphs  (download the form).

The form has three major sheets;

  1. the survey sheet;
  2. the choices sheet;
  3. The setting sheet.

The survey sheet

Survey form 1

In the survey sheet you see in row 1, three main columns “type”, “name” and “label”.

Type: is the type of variable as defined by ODK

Name: is the name of the variable as being stored in the database (a name should always be one word!).

Label: is the name of the variables as it will be displayed at the mobile phone.

Row 2-7 are standard data not to be changed.

Row 8 is a note with the text “Welcome to the Landing survey for small scale fisheries”, this text will be displayed on the opening page of the mobile phone application. in column P: media:image “Nefisco.jpg” is entered. This is the name of the image which will be displayed at the opening page of the mobile phone application.

In row 9 a grouping “Strata, sites and enumerators” is started for the variables in row 10-13.  This is not essential, but it facilitates data analyses in a later stage.

In row 10: select_one majorstrate. this is a multiple choice for the major strata, whereby the names of the major strata are provided in the “choices sheet”.

In row 11: select_one minorstrate. this is a multiple choice for the minor strata, whereby the names of the minor strata are provided in the “choices sheet”.

Please note that in column W: choice_filter: filter=${majorstrate} is entered. This is an instruction that only the Minor strata located in the previous selected major stratum are displayed.

In row 12: select_one site. this is a multiple choice for the landing sites, whereby the names of the landing sites are provided in the “choices sheet”.

Please note again that in column W: choice_filter: filter=${minorstrate} is entered. This is an instruction that only the landing sites located in the previous selected minor stratum are displayed.

In row 13: select_one enumerator. this is a multiple choice for the names of the enumerators, whereby the names of the enumerators are provided in the “choices sheet”.

Please note again that in column W: choice_filter: filter=${minorstrate} is entered. This is an instruction that only the names of the enumerators working in the previous selected minor stratum are displayed.

In row 14: end group, this ends the grouping “Strata, sites and enumerators” which was started in row 9.

In row 15: a new grouping “Fishing units” is started.

In row 16: select_one canoetype. This is a multiple choice for the type of canoes, whereby the type of canoes are provided in the “choices sheet”.

In row 17: Select_one geartype. This is a multiple choice for the major fishing gear used, whereby the gear types are provided in the “choices sheet”.

In row 18: integer (no decimals) for the duration of the fishing trip.

In row 19 and 20: select_one yesno: make multiple choice for yes or no.

In row 21:integer (no decimals) for the number of days fished in the previous week.

In row 22: end group, this ends the grouping “Fishing units ” which was started in row 15.

In row 23: note: “Now we enter the catch data by species”.

In row 24: begin repeat for species. This is the instruction that landings of several different species can be entered and creates the one to many relationship between the fishing unit and the landings by species.

In row 25: select_one species3Alpha. This is a multiple choice for the “3 alpha code” of the fish species , whereby “3 alpha codes” are provided in the “choices sheet”.

The 3 alpha codes are the international agreed 3 letter code for a fish species which can be found in ASFIS list.

In row 26: decimal ( decimals allowed) for the landing of the previous selected species.

In row 27: integer (no decimals) for the fishprice for the previous selected species.

In row 28: end repeat instruction to end data entry.

In the fourth column “appearance” quick is entered for multiple choice questions. With this after selecting a variable on the mobile phone, the next question appears automatically.

In the fifth column “constraints”, a constraint to a numeric value is provided. If the constraint is encounter, then the messages in column six “constraint message” will appear.

If in the 11th column “required” yes is entered, then this question has to be answered before continuing with the next question.


The choices sheet

ChoicesSheet

The choices sheet has five columns;

list_name. provides the list of names for the variables which operate with multiple choices. It is essential the list_name is exactly the same as provided in the survey sheet after Select_one xxx (i.e. the xxx).

name: is the name of the variable as being stored in the database (a name should always be one word!).

label: is the name of the variables as it will be displayed by the mobile phone.

image: The name of the image which will be displyed on the mobile phone.

filter: the filter to be applied . Here you enter the text from the “name” column. In this case the minor strata are related to the major strata, the sites and the enumerators are related to the minor strata. But this only works if in the survey sheet the filters are set !


The setting sheet

SettingSheet

The setting sheet has 6 columns;

form_title: This is the title of your form

form-id: This is the unique ID that will identify the form. While the form title can have spaces and can be changed from time to time, the form ID must not contain spaces and must remain fixed for the life of the form. The form ID must also begin with a letter, and it can only include letters, numbers, underscores, and hyphens (no other punctuation or special characters).

version: This is the version number of the form (in our case the date when the form is created) the format should be “YYYYMMDD”! This will result in a new version of a later date, which is lexically greater than the previous version. The version of the form is of utmost important. If you make changes, add species fishing units etc. and you upload the form to the server, you have to change the version. Otherwise you risk losing data previously uploaded to the server.

public_key: This is the public key with which to encrypt all form submissions.

submission-url: This is the submission URL to use when submitting encrypted forms.

default_language: This is the name of the language associated with labels, images, and other content when no other language is specified.