5 oyster Tables

survey

smallint

No

Unique sequential numeric code for each survey.

proj_code

character(12,1)

Project or programme code for this survey

date_s

date(4)

Survey start date.

date_f

date(4)

Survey finish date.

survey_design

character(100,1)

Brief description of the overall survey design methodology.

sampling

character(100,1)

Brief description of the sampling methodology.

navigation

character(100,1)

Brief description of the navigation methodology.

area_km2

decimal(8,2) T

otal area (sq. km) surveyed.

dredge_type

character(20,1)

Brief description of the type of dredges used.

reference

text(60,60,60,1)

Bibliographic reference.

descrptn

text(60,60,60,1)

Description of survey.

Creator:

dba

Indices:

UNIQUE survey_pk ON (survey)

vess_id

integer

No

Vessel registration number.

vess_name

character(20,1)

Vessel name.

Creator:

dba

Indices:

UNIQUE vessel_pk ON (vess_id)

survey

smallint

No

Numeric survey code (refer: t_survey).

area_code

integer

Stratum area code.

area_km2

decimal(6,1)

Stratum area (km2).

descrptn

character(50,1)

Description of the stratum.

Creator:

dba

Referential:

No such survey (survey) INSERT t_survey (survey)

survey

smallint

No

Numeric survey code (refer: t_survey).

vess_id

integer

Vessel registration number (refer: t_vessel).

date_s

date(5)

Date on start of dredge station.

time_s

integer

Time (24hr, NZST) on start of dredge station.

station_no

integer

Sequential station number.

Grid

character(4,1)

Station grid reference.

sample_no

smallint

Sample number.

lat_s

decimal(6,4)

Latitude at start of dredge station (decimal degrees).

long_s

decimal(7,4)

Longitude at start of dredge station (decimal degrees).

depth_s

integer

Depth (m) at start of dredge station.

speed

smallint

Towing speed (knots).

lat_f

decimal(6,4)

Latitude at finish of dredge station (decimal degrees).

long_f

decimal(7,4)

Longitude at finish of dredge station (decimal degrees).

no_live1

integer

Number of live legal size oysters (>=58mm) in dredge.

new_clocks1

integer

Number of legal size (>=58mm) new clocks in dredge.

old_clocks1

integer

Number of legal size (>=58mm) old clocks in dredge.

no_live2

integer

Number of live sublegal size (<58mm) oysters in dredge.

new_clocks2

integer

Number of sublegal size (<58mm) new clocks in dredge.

old_clocks2

integer

Number of sublegal size (<58mm) old clocks in dredge.

no_live3

integer

Number of live oysters between 50mm and 57mm in dredge.

new_clocks3

integer

Number of new clocks between 50mm and 57mm in dredge.

old_clocks3

integer

Number of old clocks between 50mm and 57mm in dredge.

no_gapers1

integer

Number of live oysters (>= 58mm) that have a gap between their two shells (i.e., alive but sick) in dredge.

no_gapers3

integer

Number of live oysters 50mm and 57mm that have a gap between their two shells (i.e., alive but sick) in dredge.

no_live4

integer

Number of live oysters < 50mm in dredge.

no_live5

integer

Number of live oysters >50mm in dredge.

percent_full

smallint

Percent fullness of the dredge.

wind_force

smallint

.

Wind force (Beaufort scale) during dredge

dredge_no

smallint

Dredge number: 1=forward dredge 2=after dredge.

dredge_perf

character(1,1)

Did the dredge fish well? (Y/N)

sediment

smallint

Sediment type (0=weed 2=shell 3=shell/gravel 4=pea gravel 5=sand 6=sil 7=sponges 8=bryozoan).

Bryozoan

character(1,1)

Bryozoan substrate (Y/N)?

area_code

integer

Stratum area code.

Distance

decimal(9,7)

Distance dredged (km).

area_wt

character(1,1)

Area weight (0=0km grid=1nm grid 1 2=3.96km grid).

bonamia_samp

character(1,1)

Bonamia sp. Sample taken? Bonamia1 decimal(5,1) Percent prevalence of Bonamia sp. In oysters >=58mm.

Bonamia3

decimal(5,1)

Percent prevalence of Bonamia sp. In oysters between 50mm and 57mm.

tot_Bonamia

decimal(5,1)

Percent prevalence of Bonamia sp. In all oysters.

percent_infected

decimal(5,2)

Percent of a 50 oyster sample infected with Bonamia sp.

prevalence

character(1,1)

Levels of prevalence of Bonamia sp. In all oysters (o=0 l=1-10 m=11- 25 h=26+*=no sample).

percent_new

decimal(6,2)

Percent of new clocks over new clocks+live(>50mm).

stand_live1

decimal(11,7)

Number of live oysters >= 58mm in a standard 0.37km dredge.

stand_live2

decimal(11,7)

Number of live oysters < 58mm in a standard 0.37km dredge.

stand_live3

decimal(11,7)

Number of live oysters between 50mm and 57mm in a standard 0.37km dredge.

stand_live4

decimal(11,7)

Number of live oysters between <= 50mm in a standard 0.37km dredge.

thres_live1

character(20,1)

thres_live1a

character(20,1)

thres_live2

character(20,1)

thres_live2a

character(20,1)

Creator:

dba

Referential:

No such survey (survey) INSERT t_survey (survey)

Indices:

NORMAL (2, 15) station_survey_ndx ON (survey)

NORMAL (2, 15) station_vess_ndx ON (vess_id)

survey

smallint

No

Numeric survey code (refer: t_survey).

station_no

integer

No

Sequential station number.

fish_no

integer

No

Oyster number unique by station.

percent_samp

decimal(5,2)

Percentage of total oyster catch sampled per station

range 0.00 to 100.00

lgth

integer

Shell length (mm).

wdth

integer

Shell width (mm).

hght

integer

Shell height (mm).

shell_weight

decimal(4,1)

Weight of shell only (grams).

meat_weight

decimal(5,2)

Weight of oyster meat only (grams).

meat_vol

decimal(4,1)

Volume of the meat only.

size

character(1,1)

1-character code for the size of the oyster: R = recruit, P = pre-recruit, 0 = small recruit.

Smatch '[OPR]'

bonamia_score

smallint

Bonamia score: 0 = not infected, 1 = 1 Bonamia on imprint, 2 = 2-10 Bonamia on imprint, 3 = 10+, but few per hemocyte, 4 = many hemocytes infected, 5 = nearly all hemocytes infected heavily

range 0 to 5

Creator:

dba

Referential:

No such station (survey, station_no) INSERT t_station (survey, station_no)

survey

smallint

No

Numeric survey code (refer: t_survey).

Treatment

integer

Code to describe the fishing method and the treatment of the oysters (refer: t_treatment_codes).

Cell

integer

Cage cell number. 6 cells per cage.

size_group

integer

Oyster size group (1=Spat<10mm, 2=Pre-recruits 10-57mm, 3=Takeable oysters>=58mm).

damage_code

integer

Code to describe damage to oyster as a result of treatment (refer: t_damage_codes).

alive_code

integer

Dead or alive code (0=Alive, 1=Dead).

cluster_code

integer

A hierarchical code which describes the formation of clusters by tracing successive settlements (refer: t_cluster_codes).

no_oysters

integer

Usually takeable and pre-recruits were recorded as 1 oyster per record. Spat were assessed in groups and numbers of individuals given.

Creator:

dba

Referential:

No such survey (survey) INSERT t_survey (survey)

No such treatment (treatment) INSERT t_treatment_codes (treatment)

No such damage_code (damage_code) INSERT t_damage_codes (damage_code)

No such cluster_code (cluster_code) INSERT t_cluster_codes (cluster_code)

treatment

integer

No

Code to describe the fishing method and treatment of oysters at harvesting.

descrptn

character(50,1)

Description of treatment code.

Creator:

dba

Indices:

UNIQUE treatment_codes_pk ON (treatment)

damage_code

integer

No

Code to describe damage to oyster as a result of treatment.

descrptn

character(120,1)

Description of damage.

Creator:

dba

Indices:

UNIQUE damage_codes_pk ON (damage_code)

Attributes

Data Type

Null?

Comment

cluster_code

integer

No

A hierarchical code which describes the formation of clusters by tracing successive settlements.

descrptn

character(120,1)

Description of the cluster settlement.

Creator:

dba

Indices:

UNIQUE cluster_codes_pk ON (cluster_code)