|
|
5 pseine Tables
The following are listings of the tables in the pseine database,
including attribute names, data types (and any range restrictions),
and comments.
5.1 Table 1: effort
Comment: ;Table of raw data from the Ministry of Fisheries
Catch and Effort database of a unit of effort; i.e., a 24-hour period
of purse seine shots.
|
Attributes
|
Data Type
|
Null?
|
Comment
|
|
effort_id
|
longinteger
|
No
|
Unique sequential number assigned to each effort record as
imported from source.
|
|
vessel_key
|
longinteger
|
|
Mfish identification number of the fishing vessel.
|
|
land_date
|
date(5)
|
|
Landing date for trip.
|
|
catch_date
|
date(5)
|
|
Date for each day fishing.
|
|
Method
|
character(2,1)
|
|
Fishing method code: PS = Purse seine.
|
|
Latitude
|
decimal(5,1)
|
|
Latitude at start of fishing. In DDMM.m format where 43
degrees 34.6 minutes is stored as 4334.6
|
|
longitude
|
decimal(6,1)
|
|
Longitude at start of fishing. In DDDMM.m format where 173
degrees 45.6 minutes is stored as 17345.6
|
|
e_or_w
|
character(1,1)
|
|
Meridian of starting position for a purse seine shot - E for
East and W for West.
|
|
stat_area
|
character(3,1)
|
|
Statistical area at start of fishing, 3 digit code.
|
|
hrs
|
integer
|
|
Search time in units of hours.
|
|
mins
|
integer
|
|
Search time in units of minutes.
|
|
search_time
|
integer
|
|
Total time spent searching in 24-hour period (in nearest whole
hours).
|
|
shots_per_day
|
decimal(6,1)
|
|
Total number of shots/sets in 24 hour period.
|
|
warp_length
|
decimal(6,1)
|
|
Length of net and all warps used in shot (metres).
|
|
fishing_time
|
decimal(6,1)
|
|
Total time spent with fishing gear in the water in a 24-hour
period (in decimal hours).
|
|
target
|
character(3,1) 3-
|
|
character code for the target species.
|
|
total_catch
|
longinteger
|
|
Total estimated greenweight (kg) for catch in a 24-hour
period.
|
|
Creator:
|
dba
|
|
|
|
Indices:
|
UNIQUE BTREE ON (effort_id)
NORMAL (2, 15) BTREE ON (vessel_id)
NORMAL (2, 15) BTREE ON (land_date)
NORMAL (2, 15) BTREE ON (catch_date)
NORMAL (2, 15) BTREE ON (target)
|
5.2 Table 2: catch
|
Comment:
|
Table of raw catch data from the Ministry of Fisheries Catch
and Effort database for each unit effort.
|
|
Attributes
|
Data Type
|
Null?
|
Comment
|
|
effort_id
|
longinteger
|
No
|
Unique sequential number assigned to each effort record as
imported from source.
|
|
Species
|
character(3,1)
|
No
|
3-character species code.
|
|
Greenweight
|
longinteger
|
|
Unique sequential number assigned to each effort record as
imported from source
|
|
Creator:
|
dba
|
|
|
|
Referential:
|
No such effort id (effort_id) INSERT effort (effort_id)
|
|
Indices:
|
NORMAL (2, 15) BTREE ON (effort_id)
NORMAL (2, 15) BTREE ON (species)
|
5.3 Table 3: landing
|
Comment:
|
Table of raw landing data from the Ministry of Fisheries Catch
and Effort database for each unit effort.
|
|
Attributes
|
Data Type
|
Null?
|
Comment
|
|
vessel_key
|
longinteger
|
|
Mfish identification number of the fishing vessel.
|
|
land_date
|
date(5)
|
|
|
|
start_date
|
date(5)
|
|
|
|
end_date
|
date(5)
|
|
|
|
quota_code
|
character(4,1)
|
|
|
|
state_code
|
character(3,1)
|
|
|
|
destination
|
character(1,1)
|
|
|
|
greenweight
|
longinteger
|
|
|
|
Creator:
|
dba
|
|
|
|
Indices:
|
NORMAL (2, 15) BTREE ON (vessel_id)
NORMAL (2, 15) BTREE ON (land_date)
|
5.4 Table 4: catch_eff
|
Comment:
|
Table to store cleaned catch and effort data recorded by
commercial purse seine vessels.
|
|
Attributes
|
Data Type
|
Null?
|
Comment
|
|
vessel_key
|
longinteger
|
|
Mfish identification number of the fishing vessel.
|
|
land_date
|
date(5)
|
|
Landing date for trip.
|
|
catch_date
|
date(5)
|
|
Date for each day fishing.
|
|
method
|
character(2,1)
|
|
Fishing method code (PS = Purse seine).
|
|
latitude
|
decimal(5,1)
|
|
Latitude at start of fishing. In DDMM.m format where 43
degrees 34.6 minutes is stored as 4334.6
|
|
longitude
|
decimal(6,1)
|
|
Longitude at start of fishing. In DDDMM.m format where 173
degrees 45.6 minutes is stored as 17345.6
|
|
stat_area
|
character(3,1)
|
|
Statistical area at start of fishing, 3 digit code. Refer
rdb:area_codes.
|
|
search_time
|
decimal(3,1)
|
|
Total time spent searching in 24-hour period (in decimal
hours).
|
|
shots_per_day
|
integer
|
|
Total number of shots/sets in 24 hour period.
|
|
warp_length
|
decimal(6,1)
|
|
Length of net and all warps used in shot (metres).
|
|
fishing_time
|
decimal(3,1)
|
|
Total time spent with fishing gear in the water in 24-hour
period (in decimal hours).
|
|
call_sign
|
character(3,1)
|
|
Call sign of spotter plane used for searching.
|
|
target
|
character(3,1)
|
|
3-character code for the target species. Refer
rdb:species_master.
|
|
total_catch
|
longinteger
|
|
Total estimated greenweight (kg) for catch in a 24-hour
period.
|
|
species1
|
character(3,1)
|
|
Species of greatest quantity in catch, code from
rdb:species_master.
|
|
catch1
|
longinteger
|
|
Estimated greenweight (kg) for species1.
|
|
species2
|
character(3,1)
|
|
Species of second greatest quantity in catch, code as for
species1.
|
|
catch2
|
longinteger
|
|
Estimated greenweight (kg) for species2.
|
|
species3
|
character(3,1)
|
|
Species of third greatest quantity in catch, code as for
species1.
|
|
catch3
|
longinteger
|
|
Estimated greenweight (kg) for species3.
|
|
species4
|
character(3,1)
|
|
Species of fourth greatest quantity in catch, code as for
species1.
|
|
catch4
|
longinteger
|
|
Estimated greenweight (kg) for species4.
|
|
species5
|
character(3,1)
|
|
Species of fifth greatest quantity in catch, code as for
species1.
|
|
catch5
|
longinteger
|
|
Estimated greenweight (kg) for species5.
|
|
kah_landing
|
longinteger
|
|
Actual greenweight (kg) of kahawai landed.
|
|
Creator:
|
dba
|
|
|
|
Indices:
|
NORMAL (2, 15) BTREE ON (vessel_id)
NORMAL (2, 15) BTREE ON (latitude)
NORMAL (2, 15) BTREE ON (longitude)
NORMAL (2, 15) BTREE ON (target)
|
|