Appendix 3 - Reference Documentation - Code Tables
The following tables document the codes used for various attributes in the rec_data database.
NB That code lists longer than approximately 1 page that are documented in a table of this database are not listed in this appendix.
Survey codes
Diary surveys
survey |
Description |
|
SOU92 |
South region diary survey |
1 Sep 91 - 31 Aug 92 |
SOU93 |
South region diary survey (continuation / variability survey of SOU92) |
1 Sep 92 - 31 Aug 93 |
CEN93 |
Central region diary survey |
1 Dec 92 - 30 Nov 93 |
CEN94 |
Central region linking survey (continuation / variability survey of CEN93) |
1 Dec 93 - 30 Nov 94 |
NOR94 |
North region diary survey |
1 Dec 93 - 30 Nov 94 |
JBL96 |
National 1996 diary survey 1st quarter data punched by John Bell & Associates |
|
NAT96 |
National diary survey |
1 Jan 96 - 31 Dec 96 |
NAT97 |
National diary survey (continuation / variability survey of NAT96) |
1 Jan 97 - 31 Dec 97 |
PAT93 |
Paterson Inlet (Stewart Is) diary survey |
1 Dec 93 - 28 Feb 98 |
AKA97 |
Akaroa Harbour diary survey |
Dec 96 - Apr 98 |
WLG99 |
Wellington area diary survey |
Jan 99 - 30 Apr 00 |
MBS99 |
Greater Marlborough Sounds |
Jan 99 - 30 Apr 00 |
KAI99 |
Kaikoura area diary survey |
Dec 98 - Sep 99 |
BLF98 |
Bluff Harbour |
1 Apr 98 - 31 Mar 99 |
OTG98 |
Otago Harbour |
1 Apr 98 - 31 Mar 99 |
NAT00 |
National diary survey (additional data collected in phone survey not in this database, see database comments or marlin metadatabase) |
1 Dec 99 - 30 Nov 00 |
NAT01 |
National diary survey |
1 Dec 00 - 30 Nov 01 |
Boat ramp surveys
NOR91 |
North region boat ramp survey |
Nov 90 - Jul 91 |
NOR94 |
North region boat ramp survey and Aerial sightings observer survey |
Jan 94 - Jun 94 |
NOR98 |
North region boat ramp survey (only at a small number of ramps) |
Dec 97 - Dec 98 |
NOR01 |
North region boat ramp survey targeting Kahawai catches |
Jan 01 - Apr 01 |
NOR02 |
North region boat ramp survey |
Jan 02 - May 02 |
| NOR03 |
North region boat ramp survey |
Jan 03 - Apr 03 |
| NOR04 |
North region boat ramp survey |
Dec 03 - Nov 04 |
| NOR05 |
North region boat ramp survey |
Dec 04 - Nov 05 |
| NOR06 |
North region boat ramp survey |
Jan 06 - Apr 06 |
CEN93 |
Central region boat ramp survey |
Dec 92 - Apr 93 |
NAT96 |
National boat ramp survey |
Dec 95 - Jan 97 |
KAI99 |
Kaikoura area boat ramp and Roving observer survey |
Dec 98 - Jan 99 |
MAK00 |
Maketu Taiapure fishing survey |
1999 - 2001 |
NAT00 |
National boatramp survey |
2000 |
| OTG01 |
Otago boat ramp and observer survey |
Mar 01 - Feb 02 |
TGB04 |
Tasman and Golden Bays boatramp survey of scallop and oyster catches |
Sep 2003 to Feb 2004 |
| WCN05 |
West Coast North Island, boatramp survey |
Oct 05 - Apr 06 |
Shellfish Harvest surveys
NSH98 |
North region Shellfish Harvest survey |
Dec 97 - Dec 98 |
NB For the regional diary surveys e.g. Otago & Bluff, the start & end dates are not rigidly defined. Some respondents may get their diaries weeks before others, and others may send in final trips late, including trips after the official end date.
Time of day codes by survey - (t_code)
Survey |
t_code |
Description |
|
|
|
|
|
Main Survey |
Pilot survey |
NOR91 |
N |
Morning |
07:00-10:00 |
|
NOR91 |
M |
Mid-day |
10:00-14:00 |
08:30-12:30 |
NOR91 |
A |
Afternoon |
14:00-18:00 |
12:30-17:00 |
NOR91 |
E |
Evening |
18:00-21:00 |
17:00-21:00 |
NOR94 |
D |
Dawn |
Before 11:00 |
|
NOR94 |
M |
Midday |
11:00-15:00 |
|
NOR94 |
A |
Afternoon |
15:00-19:00 |
|
NOR94 |
E |
Evening |
After 19:00 |
|
NAT96 |
A |
10:00 - 12:00 |
|
|
NAT96 |
B |
12:00 - 14:00 |
|
|
NAT96 |
C |
14:00 - 16:00 |
|
|
NAT96 |
D |
16:00 - 18:00 |
|
|
NAT96 |
E |
18:00 - 20:00 |
|
|
NAT96 |
F |
20:00 - 22:00 |
|
|
For surveys, NOR01, NOR02, NOR03 etc whhere there were more than one interviewer at the same ramp on the same dat t_code was used to distinguish the sessions.
NB For the NOR91 survey the first phase termed the pilot survey was primarily from 26 December 1990 to late January 1991, while the second phase termed the main survey was mainly from late February 1991 through until early June 1991.
For other surveys, generally coding was simplified so for the first session of each day, t_code had a value of A, the second B etc, or 1 & 2 etc respectively.
t_session attributes.
Day type (day_type)
1 Weekend or Public holiday
2 Weekday
3 Contest (eg Furuno Contest in the NORth region surveys)
Interview type (iv_type)
1 Ramp
2 Beach
3 Roving boat
4 Other
5 Marina
6 Fixed (observer)
7 Roving (observer)
Platform type (platform_type)
A Aeroplane
B Boat
L Land
Session type (sess_type)
I Interview
O Observer
Environmental data
Sea conditions (sea_state)
1 Smooth (0.1 - 0.5)
2 Slight (0.5 - 1.0)
3 Moderate (1.0 - 2.5)
4 Rough (2.5 - 4.0)
Rain (rain)
1 Nil
2 Light continuous
3 Light scattered
4 Medium scattered
5 Heavy rain (added April 2004)
Overhead conditions (overhead)
1 Sunny continuous
2 Mainly sunny
3 Mainly cloudy
4 Continuously cloudy
Wind speed (wind_speed)
1 Nil
2 Light (1-10 kts)
3 Medium (11-20 kts)
4 Strong (21 + kts)
Wind direction (wind_dirn) in table t_session
1 Nil (no wind)
2 Variable
3 North
4 South
5 North East
6 South West
7 East
8 West
9 South East
10 North West
Intercept Outcome Codes (outcome) in table t_group
I Interviewed
R Refused
Z Incomplete interview for surfcasting mainly
N Not interviewed
O Other (boat skiing, picnicking etc)
X Interviewed but invalid for CPUE analysis
F Fishing but not willing to be interviewed,
In TGB04 survey means fishing but not for scallops or oysters
A Furuno Fishing Contest
Sub-region (sub_region) in table t_interview
sub_region |
Description |
Location Codes (fish_loc) |
B |
Bay of Islands |
BLA KER RAW RUS BRT |
BR |
Barrier Islands (diary zone) |
|
C |
Coromandel East |
KUA MEB MEI SHO WMM |
D |
Dargaville Coast |
GKG HKG MBF |
ES |
Eastern Gulf (diary zone) |
|
E |
East Cape |
MAT WHA HAU OPO TEK |
|
(Tarawera River-Te Kaha) |
|
F |
Far North |
HOU GRV RNU KAR |
|
(Houhora - Takau Bay) |
MGN TAU CAV TAK |
FR |
Firth of Thames (diary zone) |
|
G |
General (no area given) |
|
H |
Hokianga Harbour |
HKH |
I |
Inner Gulf |
WAI RAN MOT |
IN |
Inner Gulf (diary zone) |
|
K |
Kaipara Harbour |
HEL PTO DAR |
KW |
Kawhia Harbour |
KWH |
M |
Manukau Harbour |
MAN PPK PUR WAK WAR |
MD |
Mid Gulf |
OMA KAW TIR TAM NOI COR FIR MID |
MR |
Muriwai-Waikato Coast |
BET MUR PIH WKU |
N |
Ninety Mile Beach |
APR BLF NMB WPP |
NP |
New Plymouth Coast |
NPL OKR WTR |
O |
Outer Gulf |
LIT PAK COL MOK GRE FIT ARI BAR NEE |
OH |
Ohiwa Harbour |
OHI |
P |
Bay of Plenty Coast (Waihi - Tarawera River) |
FIV MAK MII PAP |
PI |
BOP offshore islands |
ALD CUV MAY WHI |
R |
Raglan Harbour |
RLN |
RL |
Raglan Coast |
AOT ASS CRY MKP |
|
(Aotea H. included) |
GAN KPP PNU |
T |
Tutukaka Coast |
OAK TUT PKI BRE HEN |
TP |
The Top (Northland) |
REI NOR GEB |
TG |
Tauranga Harbour |
KAT TEP |
W |
Whangarei Harbour |
WEI |
WG |
Wanganui Coast |
RTN WNG WVL |
WS |
Western Gulf (diary zone) |
|
WA |
Whangaroa Harbour |
WGA |
Age group (age_gp)
For the CEN93 and NOR94 surveys in the boat ramp interviews one fisher from each boat was asked which of the following age group categories he/she was in.
age_gp |
age in years |
1 |
15-20 |
2 |
21-30 |
3 |
31-40 |
4 |
41-50 |
5 |
51-60 |
6 |
61 years and over. |
The NOR94 survey also has many records coded to "Z" (presumably for not asked).
These codes are the same as used in the age_gp attribute in the table t_phone for the diary surveys.
The NOR00 and NOR01 surveys used a different age grouping for the age_gp attribute in table t_phone below.
age_gp |
age |
20 |
Refused |
21 |
15-17 yrs |
22 |
18-19 yrs |
23 |
20-24 yrs |
24 |
25-29 yrs |
25 |
30-34 yrs |
26 |
35-39 yrs |
27 |
40-44 yrs |
28 |
45-49 yrs |
29 |
50-54 yrs |
30 |
55-59 yrs |
31 |
60-64 yrs |
32 |
65-69 yrs |
33 |
70-74 yrs |
34 |
75 plus |
35 |
under 15 |
The NOR05 boatramp survey used a different age grouping for the age_gp attribute in table t_interview below.
age_gp |
age |
10 |
0-9 yrs |
11 |
10-19 yrs |
12 |
20-29 yrs |
13 |
30-39 yrs |
14 |
40-49 yrs |
15 |
50-59 yrs |
16 |
60-69 yrs |
17 |
70-79 yrs |
18 |
80-89 yrs |
19 |
90-99 yrs |
Ethnic group (ethnic) in table t_phone
ethnic |
|
1 |
European or pakeha |
2 |
NZ Maori |
3 |
Pacific groups |
4 |
Other |
Until 2003 the above codes were used for the attribute ethnic in table t_phone. The NOR00 and NOR01 surveys asked the ethnicity question differently by asking which ethnic group or groups they belong to. The NOR00 and NOR01 surveys used the following additional codes for the attribute ethnic.
ethnic |
|
5 |
Asian |
11 |
Not Answered |
12 |
|
13 |
Maori/Caucasian |
14 |
Maori/Pacific |
15 |
Maori/Asian |
16 |
Maori/Caucasian/Pacific |
17 |
Maori/Caucasian/Asian |
18 |
Maori/Pacific/Asian |
19 |
Maori/Pacific/Asian/Caucasian |
20 |
Caucasian/Pacific |
21 |
Caucasian/Asian |
22 |
Caucasian/Pacific/Asian |
23 |
Pacific/Asian |
t_length observed codes (observd) from t_observd_codes
observd |
Description |
1 |
measured |
2 |
counted |
3 |
observed |
4 |
not observed |
5 |
head removed (for otoliths) |
F |
fish filleted (including headed fish) |
B |
fish used for bait |
L |
thrown back - legal size (dead or alive) |
U |
thrown back - under size, dead |
R |
returned fish |
X |
sex = female (for CRA) |
Y |
sex = male (for CRA) |
t_length Fish measurement method codes (meas_meth)
from rdb:t_fish_meas_codes
meas_meth |
Description |
1 |
Fork Length |
2 |
Total Length |
3 |
Pelvic Length (rays) |
4 |
Shell Length |
W |
Tail width as legally defined for red rock lobsters |
t_boat_codes re: t_effort.boat & t_group.group_type
boat |
group_type |
Description |
1 |
C |
Charter |
2 |
Y |
Yacht |
3 |
L |
Motor Launch |
4 |
T |
Trailer-dinghy (excluding yachts) |
5 |
|
Other |
|
M |
Maori hui permit |
|
S |
Shore fishing |
. |
R |
Snorkelling from rocks (added for NAT00 survey) |
The above list includes all records from the table t_boat_codes.
count_codes from t_obs_count
Codes used for the attributes count_code, as documented in table t_count_codes.
count_code |
description |
FSR |
Fishers or Group size, the number of people actively fishing in the boat/party. |
TBT |
TrailerBoats - ie the number of trailer boats with people fishing. |
LCH |
Launches - ie the number of launches with people fishing. |
YCH |
Yachts - ie the number of yachts with people fishing. |
| BOT |
Boats (type not specified) - ie the number of boats with people fishing. |
| CHT |
Charter Boats - ie the number of Charter Boats with people fishing. |
| DIV |
Diving - ie the number of fishers Diving |
| KYK |
Kayaks - ie the number of Kayaks with people fishing |
The above list documents the meaning of the attribute tally in the table t_obs_counts.
Response status for diary surveys (response) from t_response
response |
Description |
0 |
Did not fish the time period i.e., the quarter |
1 |
Made trips i.e., went fishing |
4 |
Have been contacted but no return |
7 |
Either a diarist was not yet recruited or no longer a part of the survey due to design structure. Added for NAT01 survey |
6 |
Can't be contacted (2 x 6's => 8) |
8 |
Dropped from the survey |
9 |
No records available (equivalent to null) |
t_effort zone lived in (zonel) by survey
survey = NAT96 & NAT97 |
survey = NOR94 |
zonel |
Telephone directory |
zonel |
Telephone directory |
|
- area of residence |
|
- area of residence |
1 |
Northland |
1 |
Northland |
2 |
Auckland |
2 |
Auckland |
3 |
Bay of Plenty |
3 |
Waikato |
4 |
Waikato |
4 |
Bay of Plenty |
5 |
Gisborne |
|
|
6 |
Hawkes Bay |
|
|
7 |
Wanganui |
|
|
8 |
Taranaki |
|
|
9 |
Manawatu |
|
|
10 |
Wairarapa |
|
|
11 |
Wellington |
|
|
12 |
Marlborough |
|
|
13 |
Nelson |
|
|
14 |
West Coast |
|
|
15 |
Christchurch |
|
|
16 |
Timaru - Oamaru |
|
|
17 |
Otago |
|
|
18 |
Southland |
|
|
survey = |
NAT00 & NAT01 |
zonel |
Telephone directory |
|
- area of residence |
1 |
Northland |
2 |
Auckland |
3 |
Waikato |
4 |
Bay of Plenty |
5 |
Gisborne |
6 |
Hawkes Bay |
7 |
Taranaki |
8 |
Manawatu / Wanganui |
9 |
Wellington |
10 |
Nelson /Marlborough/Tasman |
11 |
West Coast |
12 |
Canterbury |
13 |
Otago |
14 |
Southland |
South region survey
[ South region survey codes are SOU92 & SOU93 ]
zonel |
Description |
1 |
Clarence Mouth - Conway Mouth |
2 |
Conway Mouth - Sumner Beach |
3 |
Sumner Beach - Rakaia Mouth |
4 |
Rakaia Mouth - Waitaki Mouth |
5 |
Waitaki Mouth - Toko Mouth |
6 |
Toko Mouth - Slope Point |
7 |
Slope Point - Te Waewae Point |
8 |
Stewart Island |
9 |
Te Waewae Point - Awarua Point |
Central region survey
[Central region survey codes are CEN93 & CEN94]
zonel |
Description |
1 |
Cape Runaway - Whareongaonga |
2 |
Whareongaonga - Cape Turnagain |
3 |
Cape Turnagain - Turakirae Head |
4 |
Turakirae Head - Otaki River |
5 |
Otaki River - Waitotara River |
6 |
Waitotara River - Tirua Point |
7 |
Clarence River - Stephens Island |
8 |
Stephens Island - Kahurangi Point |
9 |
Kahurangi Point - Awarua Point |
NB That the definitions of the zonel codes for the South and Central regions correspond to the definitions for the fish_zone codes (see also t_zonef_codes).
Intend to go fishing in the next 12 months, intend in the t_phone table
intend
intend
4 |
Definitely go |
The NOR00 and NOR01 surveys |
5 |
Probably go |
added codes 4- 8 to intend. |
6 |
Possibly go |
|
7 |
Probably not go |
|
8 |
Definitely not go |
|