5.2  Diary survey tables:

    

5.2.1       Table 1: t_phone

Comment:  Table for diary survey , telephone or intercept questionnaire .

 
Attributes                 Data Type               Null?      Comment

 

 zonel                        smallint                                  Zone lived in, ie phone book selected from.

 

 resp                          integer                     No          Respondent number, unique per survey.

 

 fishers                       smallint                                  Fishers in the household? 1=Yes, 2=No.

 

 not15                        smallint                                  Fisher(s) not 15 (yrs old) or older 1=ticked (=Yes)

 

 no_fishers                 smallint                                  Number in household who went fishing in the last 12 months.

 

 no_LE14                   smallint                                  Number of fishers 14 years or younger.

 

 no_commercial          smallint                                  Number of commercial fishers in the household.

 

 commercial               smallint                                  Is respondent a commercial fisherman, 1=Yes, 2=No.

 

 trips                          smallint                                  Number of fishing trips in the last 12 months, 1=LT 6, 2=6-15, 3=16-30, 4=30 or more, 5=D.K.

 

 intend                       smallint                                  Think will go saltwater fishing, diving or shellfish gathering in the coming 12 months? 1=Yes 2=No 3=DK

                                                                              For additional codes see Appendix 3 of the database documentation.

 

 SNA10                      smallint                                  In the last 12 months catch a total of more than 10 SNA? 1=Yes, 2=No, 3=Don't Know.

 

 KAH10                      smallint                                  In the last 12 months catch a total of more than 10 KAH? 1=Yes, 2=No, 3=Don't Know.

 

 BCO10                      smallint                                  In the last 12 months catch a total of more than 10 BCO? 1=Yes, 2=No, 3=Don't Know.

 

 meas                        smallint                                  Willing to measure length of SNA, KAH and BCO? 1=Yes, 2=No.

 

 gp_size                     smallint                                  Number of people usually go fishing with: 0=No one else, 1=1, 2=2, 3=3, 4=4, 5=5, 6=6 or more, 7=it varies, 8=Don’t Know

 

 fish_meths                character( 26 ,1)                       2 char codes, comma separated, for the type of fishing method used (refer t_fishmeth_codes).

 

 meth_type                 smallint                                  Code used to identify which fishing method coding series was used (refer t_fishmeth_codes).

 

 

  sex                           smallint                                  Sex : 1=Male, 2=Female.

 

 age_gp                      smallint                                  Age group : 0=14 years or under, 1=15-20, 2=21-30, 3=31-40, 4=41-50, 5=51-60, 6=61 years or older. For additional codes see Appendix 3 of the database documentation.

 

 ethnic                       smallint                                  Ethnic group : 1=European or Pakeha, 2=NZ Maori, 3=Pacific groups, 4=Other, 5=Asian. For additional codes see Appendix 3 of the database documentation.

 

 fish_club                   smallint                                  Belong to a marine fishing club? 1=Yes, 2=No.

 

 boat_club                  smallint                                  Belong to a marine boating club? 1=Yes, 2=No.

 

 dive_club                   smallint                                  Belong to a diving club? 1=Yes, 2=No.

 

 sca_fish                    smallint                                  Since July this year have dived or dredged for scallops?   1=Yes, 2=No.

 

 sca_dive                    integer                                   Number of scallop diving trips since 15 July this year.

 

 sca_dredge               integer                                   Number of scallop dredging trips since 15 July this year.

 

 diarist_yn                  smallint                                  Prepared to keep a diary ?, 1=Yes, 2=No.

 

 survey                       character(5,1)           No           Survey code, 3 chars for region + 2 numerics for yr

 

 Creator:                   dba

 Indices:                    UNIQUE t_phone_pk ON (survey, resp)

5.2.2      Table 2: t_sca

Comment:    Table for supplementary phone questionnaire for scallop fishers in the diary survey.  Currently for the Central region only.  

Attributes                 Data Type               Null?      Comment

 

 resp                          integer                     No          Unique 4-digit number for each respondent to the survey.

 

 area_sca                   character(4,1)           No          Area made trips to for scallops:

                                                                                         GLDB = Golden Bay,

                                                                                         TASB = Tasman Bay (incl. Croisilles Harbour),

                                                                                         PELO = Pelorus Sound,

                                                                                         QCSD = Queen Charlotte Sound (incl. Tory Channel),

                                                                                         CORO = Coromandel Peninsula,

                                                                                         STEW = Stewart Island,

                                                                                         ELSW = Elsewhere.

 

 no_trips                     smallint                                  Number of SCA trips to area.

 

 limit                          smallint                                  Number of trips to area caught limit bag of 50 SCA .

 

 avg_ctch                   smallint                                  Average SCA catch this season on trips to area.

 

 survey                       character(5,1)           No          Survey code, 3 chars for region + 2 numeric for yr.

 

 Creator:                   dba

 Indices:                    UNIQUE t_sca_pk ON (survey, resp, area_sca)

       

5.2.3       Table 3: t_response

Comment:   Table of response status for those considered valid diarists, eg if they went fishing or not etc

 
Attributes                 Data Type               Null?      Comment

 

 key                           longinteger               No          Primary key generated from a counter.

 

 zonel                        smallint                    No          1-digit code to denote the zone the respondent lives in.

 

 resp                          longinteger               No          Unique 4-digit number for each respondent to the survey.

 

 year_s                      integer                                   4 digit year of start of the quarter or other time period

 

 month_s                    smallint                                  Month start (range 1-12)

 

 day_s                       smallint                                  Day start

 

 year_f                       integer                                   4 digit year finish

 

 month_f                     smallint                                  Month finish (range 1-12)

 

 day_f                        smallint                                  Day finish

 

 quarter                      smallint                                  quarter of the year

                                                                              (range 1-4)

 

 response                   smallint                                  response status for the quarter or other time period, refer to Appendix 3 of the database documentation for the codes.

 

 weighting                   decimal(11,9)                          weighting factor, used for scaling up catches.

 

 survey                       character(5,1)                         Survey code, 3 chars for region + 2 numeric for yr.

 

 Creator:                   dba

 Indices:                    PRIMARY KEY BTREE ON (key)

                                 UNIQUE t_response_pk ON (resp, survey, year_s, month_s)

                                 NORMAL (2, 15) response_survey_ndx ON (survey)

                                 NORMAL (2, 15) response_resp_ndx ON (resp)

    

5.2.4        Table.4: t_effort

Comment:    This table contains diarist's data on their effort for one fishing trip as a recreational angler.

 

Attributes                 Data Type               Null?      Comment

 

 trip_no                      longinteger               No          Unique sequential for each trip in the survey.

 

 resp                          integer                                   Unique 4-digit number for each respondent to the survey.

 

 resp_status               smallint                                  Status of diarist:1=fishing; 2=no fishing; 3=no response; 4=withdrew; 5=not included; 6=deceased

 

 quarter                      character(1,1)                         3 month period of the year.

 

 fish_date                   character(8,1)                         Date of the fishing trip, format as punched .

 

 trip_date                    date(4)                                   Date of the fishing trip.

 

 zonel                        smallint                                  1-digit code to denote the zone the respondent lives in.

 

 resp_locn                  character(30,1)                       Where the respondents residence is located.

 

 fish_zone                  smallint                                  2-digit code for the zone fished in during a fishing trip (refer t_zonef_codes and Appendix 4 of the database documentation).

 

 CRAarea                   character(1,1)                         Rock Lobster area code, A thru H correspond to QMA's   CRA1 thru CRA5, & CRA7 thru 9 respectively .

                                 smatch '[A-H]'

 

 SCAarea                   smallint                                  Scallop area,  refer to Appendix 4 of the database documentation for areas.

 

 fish_loc                     character(3,1)                         Locality code, for where fished, (refer t_locality_codes).

 

 locality                      character(60,1)                       Locality name, where fished as recorded by the diarist

 

 qma                          smallint                                  Quota Management Area

 

 hrs                            decimal(4,1)                           Time (decimal hours) spent fishing during the trip.

 

 ramp                         character(3,1)                         ramp code for Boat departure point eg ramp or marina, refer t_ramp_codes

 

  target_sp                   character(35,1)                       List of 3-char codes  (separated by commas)  for each of the species targetted by the angler during the fishing trip (see rdb:curr_spp).

 

 fish_meth                  character(2,1)                         2 char code for the type of fishing method used in a fishing trip (refer t_fishmeth_codes)

 

  meth_type                 smallint                                  Code to identify which fishing method coding series was used (refer t_fishmeth_codes)

 

 boat                          smallint                                  1-digit code for type of boat used in a fishing trip, refer to Appendix 3 of the database documentation.

 

 group_size                smallint                                  Number of people in the fishing group

 

 survey                       character(5,1)           No          Survey code, 3 chars for region + 2 numerics for yr   refer t_survey_codes.

 

 comments                 character(70,1)

 

 Creator:                   dba

 Referential:              INVALID BOAT CODES (boat) INSERT t_boat_codes (boat)

                                 INVALID FISH_LOC (fish_loc) INSERT t_locality_codes (fish_loc)

                                 INVALID RAMP (ramp) INSERT t_ramp_codes (ramp)

                                 INVALID SURVEY (survey) INSERT t_survey_codes (survey)

                                 INVALID FISH ZONE (fish_zone, survey) INSERT t_zonef_codes (fish_zone, survey)

                                 INVALID FISH METH (fish_meth, meth_type) INSERT t_fishmeth_codes (fish_meth, meth_type)

 Indices:                    UNIQUE effort_indx ON (trip_no)

                                 NORMAL (2, 15) eff_resp_indx ON (resp)

                                 NORMAL (2, 15) eff_zonl_indx ON (zonel)

                                 NORMAL (2, 15) eff_zonf_indx ON (fish_zone)

                                 NORMAL (2, 15) eff_gear_indx ON (fish_meth)

                                 NORMAL (2, 15) eff_boat_indx ON (boat)

                                 NORMAL (2, 15) eff_target_indx ON (target_sp)

                                 NORMAL (2, 15) eff_survey_indx ON (survey)

                                 NORMAL (2, 15) eff_date_indx ON (trip_date)

   

5.2.5 Table 5: t_catch 

Comment:    This table contains diarist's data on the catch from a fishing trip.

 

Attributes                 Data Type               Null?      Comment

 

 trip_no                      longinteger               No          Unique sequential for each trip in the survey.

 

 species                     character(3,1)           No          3-char code for species caught, refer rdb:curr_spp.

 

 no_caught                 integer                                   Number of the species caught during the trip.

 

 weight                       decimal(4,1)                           Weight (decimal kg) of the species caught.

 

 survey                       character(5,1)           No          Survey code, 3 chars for region + 2 numerics for yr

 

 Creator:                   dba

 Referential:              NO SUCH TRIP (trip_no) INSERT t_effort (trip_no)

                                 t_catch invalid species (species) INSERT

                                 {/data/db2/rdb,neptune.niwa.cri.nz,rdb} :species_master (code)

 Indices:                    NORMAL (2, 15) ctch_spp_indx ON (species)

                                 NORMAL (2, 15) ctch_survey_ndx ON (survey)

                                 UNIQUE ctch_indx ON (trip_no, species)

 

5.2.6 Table 6: t_lgth

Comment:  Diarist's fish length measurements.

 

Attributes                 Data Type               Null?      Comment

 

 trip_no                      longinteger                             Trip number.

 

 resp                          longinteger               No          Respondent number.

 

 trip_date                    date(4)                                   Date of the fishing trip.

 

 species                     character(3,1)           No          3-char species code, refer rdb:curr_spp.

 

 lgth                           integer                     No          Length of the fish in cm.

 

 sex                           character(1,1)                         Sex code: 1=Male, 2=Female.

 

 no_fish                      integer                                   Number of fish.

 

 survey                       character(5,1)           No          Survey code, 3 chars for region + 2 numerics for yr

 

 Creator:                   dba

 Indices:                    NORMAL (2, 15) lgth_date_ndx ON (trip_date)

                                 NORMAL (2, 15) lgth_resp_ndx ON (resp)