|
|
6 rlcs Catch Sampling Views
The following listings of the views in the catch sampling schema of the rlcs database, including attribute names, data types (and any range restrictions), and comments.
6.1 View 1: v_lob_sample
Comment: Details of a red rock lobster catch sample. Refer t_sample for attribute comments.
| View: |
select attr 'sample_no', attr 'date_s', attr 'species',
attr 'area', attr 'vessel_no', attr 'calipers', attr
'recorder', attr 'sampler', attr 'wind1_dir', attr
'beau1_scale', attr 'wind2_dir', attr 'beau2_scale', attr
'swell1_dir', attr 'swell1_code', attr 'swell2_dir', attr
'swell2_code', attr 'method', attr 'GPS', attr 'vessel',
attr 'skipper', attr 'divers', attr 'remarks', attr
'season', attr 'keepers', attr 'kg_est', attr 'kg_act',
attr 'sample_type' from 't_sample' where ((attr
'sample_type' = 'CS' or attr 'sample_type' = 'CT')) |
| Attributes |
Data Type |
Null? |
| |
|
|
| sample_no |
character(10,1) |
Not Null |
| date_s |
date(4) |
|
| species |
character(3,1) |
Not Null |
| area |
integer |
|
| vessel_no |
longinteger |
|
| calipers |
decimal(3,2) |
|
| recorder |
character(12,1) |
|
| sampler |
character(12,1) |
|
| wind1_dir |
character(3,1) |
|
| beau1_scale |
smallint |
|
| wind2_dir |
character(3,1) |
|
| beau2_scale |
smallint |
|
| swell1_dir |
character(3,1) |
|
| swell1_code |
smallint |
|
| swell2_dir |
character(3,1) |
|
| swell2_code |
smallint |
|
| method |
character(1,1) |
|
| GPS |
character(1,1) |
|
| vessel |
character(18,1) |
|
| skipper |
character(20,1) |
|
| divers |
character(29,1) |
|
| remarks |
character(35,1) |
|
| season |
smallint |
|
| keepers |
integer |
|
| kg_est |
integer |
|
| kg_act |
decimal(4,1) |
|
| sample_type |
character(2,1) |
Not Null |
|
|
| 6.2 View 2: v_cra_catch Comment: Details of each pot used during a red rock lobster catch sample. Refer t_effort for attribute comments.
| View: |
select attr 'sample_no', attr 'season', attr 'effort_no'
print 'pot_no', attr 'pot_type', attr 'es_gaps', attr
'depth', attr 'soak', attr 'bait', attr 'caught', attr
'octopus', attr 'no_legal', attr 'legal_wt', attr
'no_berried', attr 'sample_type' from ' t_effort' where
(attr 'sample_type' = 'CS') |
| Attributes |
Data Type |
Null? |
| |
|
|
| sample_no |
character(10,1) |
Not Null |
| season |
smallint |
|
| pot_no |
integer |
Not Null |
| es_gaps |
character(2,1) |
Not Null |
| depth |
smallint |
|
| soak |
integer |
|
| bait |
integer |
|
| caught |
integer |
|
| octopus |
integer |
|
| no_legal |
integer |
|
| legal_wt |
decimal(7,4) |
|
| no_berried |
integer |
|
| sample_type |
character(2,1) |
Not Null | 6.3 View 3: v_cra_lfComment: Details of individual rock lobsters measured during a red rock lobster catch sample. Refer t_crayfish for attribute comments.
| View: |
select attr 'sample_no', attr 'season', attr 'species',
attr 'effort_no' print 'pot_no', attr 'sex', attr
'carapace', attr 'tail_width', attr 'injury', attr 'moult',
attr 'resident', attr 'status', attr 'sample_type' from
't_crayfish' where (attr 'sample_type' = 'CS') |
| Attributes |
Data Type |
Null? |
| |
|
|
| sample_no |
character(10,1) |
Not Null |
| season |
smallint |
|
| species |
character(3,1) |
Not Null |
| pot_no |
integer |
|
| sex |
smallint |
|
| carapace |
decimal(4,1) |
|
| tail_width |
decimal(4,1) |
|
| injury |
smallint |
|
| moult |
smallint |
|
| resident |
smallint |
|
| status |
integer |
|
| sample_type |
character(2,1) |
Not Null | 6.4 View 4: v_morp_sample Comment: Details of a market/morphometric sample. Refer t_sample for attribute comments.
| View: |
select attr 'sample_no', attr 'date_s', attr 'species',
attr 'area', attr 'vessel_no', attr 'calipers', attr
'method', attr 'GPS', attr 'vessel', attr 'skipper', attr
'divers', attr 'remarks', attr 'season', attr 'kg_act',
attr 'sample_type' from 't_sample' where (attr
'sample_type' = 'WS') |
| Attributes |
Data Type |
Null? |
| |
|
|
| sample_no |
character(10,1) |
Not Null |
| date_s |
date(4) |
|
| species |
character(3,1) |
|
| area |
integer |
Not Null |
| vessel_no |
longinteger |
|
| calipers |
decimal(3,2) |
|
| method |
character(1,1) |
|
| GPS |
character(1,1) |
|
| vessel |
character(18,1) |
|
| skipper |
character(20,1) |
|
| divers |
character(29,1) |
|
| remarks |
character(35,1) |
|
| season |
smallint |
|
| kg_act |
decimal(4,1) |
|
| sample_type |
character(2,1) |
Not Null | 6.5 View 5: v_cra_wt Comment: Details of individual red rock lobsters measured during a market/morphometric sample. Refer t_crayfish for attribute comments.
| View: |
select attr 'sample_no', attr 'season', attr 'species',
attr 'sex', attr 'carapace', attr 'tail_width', attr
'injury', attr 'status', attr 'weight', attr 'sample_type'
from ' t_crayfish' where (attr 'sample_type' = 'WS') |
| Attributes |
Data Type |
Null? |
| |
|
|
| sample_no |
character(10,1) |
Not Null |
| season |
integer |
|
| species |
character(3,1) |
Not Null |
| sex |
smallint |
|
| carapace |
decimal(4,1) |
|
| tail_width |
decimal(4,1) |
|
| injury |
smallint |
|
| status |
integer |
|
| weight |
integer |
|
| sample_type |
character(2,1) |
Not Null | 6.6 View 6: v_phc_sample Comment: Details of a packhorse rock lobster exploratory catch sample.Refer t_sample for attribute comments.
| View: |
select attr 'sample_no', attr 'date_s', attr 'area', attr
'vessel_no', attr 'calipers', attr 'recorder', attr
'sampler', attr 'method', attr 'GPS', attr 'vessel', attr
'skipper', attr 'sample_type' from 't_sample' where (attr
'sample_type' = 'PH') |
| Attributes |
Data Type |
Null? |
| |
|
|
| sample_no |
character(10,1) |
Not Null |
| date_s area |
date(4) |
|
| area |
integer |
|
| vessel_no |
longinteger |
|
| calipers |
decimal(3,2) |
|
| recorder |
character(12,1) |
|
| sampler |
character(12,1) |
|
| method |
character(1,1) |
|
| GPS |
character(1,1) |
|
| vessel |
character(18,1) |
|
| skipper |
character(20,1) |
|
| sample_type |
character(2,1) |
Not Null | 6.7 View 7: v_phc_catch Comment: Details of each pot/set used during a packhorse rock lobster exploratory catch sample. Refer t_effort for attribute comments.
| View: |
select attr 'sample_no', attr 'effort_no' print 'set_no',
attr 'num_of_effort' print 'num_of_pots', attr 'pot_type',
attr 'depth', attr 'soak', attr 'bait', attr 'caught' print
'phc_caught', attr 'no_legal' print 'phc_kept', attr
'caught_sp2' print 'cra_caught', attr 'latitude', attr
'longitude', attr 'EorW', attr 'sample_type' from
't_effort' where (attr 'sample_type' ='PH') |
| Attributes |
Data Type |
Null? |
| |
|
|
| sample_no |
character(10,1) |
Not Null |
| set_no |
integer |
Not Null |
| num_of_pots |
integer |
|
| pot_type |
character(2,1) |
Not Null |
| depth |
integer |
|
| soak |
integer |
|
| bait |
integer |
|
| phc_caught |
integer |
|
| phc_kept |
integer |
|
| cra_caught |
integer |
|
| latitude |
decimal(5,1) |
|
| longitude |
decimal(6,1) |
|
| EorW |
character(1,1) |
|
| sample_type |
character(2,1) |
Not Null | 6.8 View 8: v_phc_lf Comment: Details of individual packhorse rock lobsters measured during a packhorse rock lobster exploratory catch sample. Refer t_crayfish for attribute comments.
| View: |
select attr 'sample_no', attr 'effort_no' print 'set_no',
attr 'sex', attr 'carapace', attr 'tail_width', attr
'tail_length', attr 'sample_type' from ' t_crayfish' where
(attr 'sample_type' = 'PH') |
| Attributes |
Data Type |
Null? |
| |
|
|
| sample_no |
character(10,1) |
Not Null |
| set_no |
integer |
|
| sex |
smallint |
|
| carapace |
decimal(4,1) |
|
| tail_width |
decimal(4,1) |
|
| tail_length |
integer |
|
| sample_type |
character(2,1) |
Not Null | 6.9 View 9: v_mls_sample Comment: Details of a red rock lobster Minimum Legal size (MLS) investigation sample. Refer to t_sample for attribute comments.
| View: |
select attr 'sample_no', attr 'date_s', attr 'CFA', attr
'area', attr 'remarks' print 'location', attr 'sample_type
'from 't_sample' where (attr 'sample_type' ='LS'). |
| Attributes |
Data Type |
Null? |
| |
|
|
| sample_no |
character(10,1) |
Not Null |
| date_s |
date(4) |
|
| CFA |
character(3,1) |
|
| area |
integer |
|
| location |
character(35,1) |
|
| sample_type |
character(2,1) |
Not Null | 6.10 View 10: v_mls_lf Comment: Details of individual red rock lobsters measured during a MLS investigation sample. Refer t_crayfish for attribute comments.
| View: |
select attr 'sample_no', attr 'sex', attr 'carapace', attr
'twf1', attr 'tail_width', attr 'tail_length', attr
'sample_type' from ' t_crayfish' where (attr 'sample_type'
='LS') |
| Attributes |
Data Type |
Null? |
| |
|
|
| sample_no |
character(10,1) |
Not Null |
| sex |
smallint |
|
| carapace |
decimal(4,1) |
|
| twf1 |
decimal(4,1) |
|
| tail_width |
decimal(4,1) |
|
| tail_length |
integer |
|
| sample_type |
character(2,1) |
Not Null | 6.11 View 11: v_tag_sample Comment: Details of a tag sample. Refer t_sample for attribute comments.
| View: |
select attr 'sample_no', attr 'date_s', attr 'species',
attr 'area', attr 'vessel_no', attr 'calipers', attr
'method', attr 'GPS', attr 'vessel', attr 'skipper', attr
'divers', attr 'remarks', attr 'season', attr 'sample_type'
from 't_sample' where ((attr 'sample_type' = 'TG' or attr
'sample_type' = 'CT')) |
| Attributes |
Data Type |
Null? |
| |
|
|
| sample_no |
character(10,1) |
Not Null |
| date_s |
date(4) |
|
| species |
character(3,1) |
Not Null |
| area |
integer |
|
| vessel_no |
longinteger |
|
| calipers |
decimal(3,2) |
|
| method |
character(1,1) |
|
| GPS |
character(1,1) |
|
| vessel |
character(18,1) |
|
| skipper |
character(20,1) |
|
| divers |
character(29,1) |
|
| remarks |
character(35,1) |
|
| season |
smallint |
|
| sample_type |
character(2,1) |
Not Null |
|
|