AMMOP_HAUL

75080

AMMOP_HAUL

Entity

Published / External

75024

AMMOP Oracle database 1999 - 2013

Data Set

This table contains a list of hauls that occurred during an observers sample.

AIR_TEMP

VARCHAR2(8 BYTE)

Active Air temperature at the time of haul. Celsius

WATER_TEMP

VARCHAR2(8 BYTE)

Active Water temperature at the time of haul. Celsius

DISTANCE_OBSV_NET_MAXIMUM

VARCHAR2(6 BYTE)

Active Maximum distance between the observer vessel and the location of the fishing vessel where the net is hauled aboard for the duration of the haul, in whole meters.

DISTANCE_OBSV_NET_MINIMUM

VARCHAR2(6 BYTE)

Active Minimum distance between the observer vessel and the location of the fishing vessel where the net is hauled aboard for the duration of the haul, in whole meters.

DISTANCE_SHORE_MAXIMUM

VARCHAR2(6 BYTE)

Active Maximum net distance to shore in meters.

DISTANCE_SHORE_MINIMUM

VARCHAR2(6 BYTE)

Active Minimum net distance to shore in meters.

EVIDENCE_OF_BLOW_THROUGH

VARCHAR2(1 BYTE)

Active Any evidence of net blowthrough, Y=Yes, N=No.

GEAR_DAMAGE_CODE_ID

NUMBER(6,0)

Active Gear condition at end of haul. references AMMOP_GEAR_DAMAGE_CODE(

GEAR_DAMAGE_LOCATION_HOR_ID

NUMBER(6,0)

Active Horizontal location of gear damage after haul. references AMMOP_GEAR_DAMAGE_LH_CODE

GEAR_DAMAGE_LOCATION_VER_ID

NUMBER(6,0)

Active Vertical location of gear damage after haul. references AMMOP_GEAR_DAMAGE_LV_CODE

GEAR_DAMAGE_OBSTRUCTION_ID

NUMBER(6,0)

Active Gear obstructions at end of haul. references AMMOP_GEAR_DAMAGE_OBS_CODE

HAUL_BEGIN_DATE

DATE

Active Date haul began.

HAUL_BEGIN_DEPTH

VARCHAR2(6 BYTE)

Active Water depth, in whole fathoms, where haul began.

HAUL_BEGIN_DEPTH_FROM

VARCHAR2(1 BYTE)

Active How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.

HAUL_BEGIN_LATITUDE

VARCHAR2(9 BYTE)

Active Latitude location, in tenths of minutes (ddmm.m), where the haul began.

HAUL_BEGIN_LONGITUDE

VARCHAR2(9 BYTE)

Active Longitude location, in tenths of minutes (ddmm.m), where the haul began.

HAUL_BEGIN_TIME

VARCHAR2(4 BYTE)

Active Time haul began. Military time.

HAUL_END_DATE

DATE

Active Date haul ended.

HAUL_END_DEPTH

VARCHAR2(6 BYTE)

Active Water depth, in whole fathoms, where haul ended.

HAUL_END_DEPTH_FROM

VARCHAR2(1 BYTE)

Active How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.

HAUL_END_LATITUDE

VARCHAR2(9 BYTE)

Active Latitude location, in tenths of minutes (ddmm.m), where the haul ended.

HAUL_END_LONGITUDE

VARCHAR2(9 BYTE)

Active Longitude location, in tenths of minutes (ddmm.m), where the haul ended.

HAUL_END_TIME

VARCHAR2(4 BYTE)

Active Time haul ended. Military time.

HAUL_ID

NUMBER(6,0)

Active Human assigned haul number.

HYDRAULIC_PUMP_USED

VARCHAR2(1 BYTE)

Active Hydraulic pump used to clean net, Y=Yes,N=No.

NUMBER(6,0)

Active Unique table ID value. Populated by AMMOP_HAUL_SEQ

INCIDENTAL_TAKE_OBSERVED

VARCHAR2(1 BYTE)

Active Incidental take observed, Y=Yes, N=No.

LAND_FEATURE_ID

NUMBER(6,0)

Active Best description of nearest land feature. references AMMOP_LAND_FEATURE_CODE

MARINE_ZONE_ID

NUMBER(6,0)

Active Best description of marine zone. references MM_FISHING_ZONE

NET_ID

NUMBER(6,0)

Active Reference to gear used in haul.

NET_VIEW_DISTANCE

VARCHAR2(8 BYTE)

Active Distance to net. meters

NET_VIEW_PERCENT_OBSTRUCTED

VARCHAR2(9 BYTE)

Active Percent view obstructed.

NET_VIEW_PERCENT_UNDERWATER

VARCHAR2(9 BYTE)

Active Percent net underwater when viewed.

NET_VIEW_RANK_CODE

VARCHAR2(6 BYTE)

Active Net view rank code.

OBSERVED_HAUL

VARCHAR2(1 BYTE)

Active Partially or Fully.

PERCENT_NET_HAULED

VARCHAR2(9 BYTE)

Active Percentage of net that was actually pulled out of the water to any degree during this haul.

PERCENT_NET_OBSERVED

VARCHAR2(9 BYTE)

Active Percentage of net that was actually observed being hauled during this haul.

PERCENT_TOTAL_NET_SET

VARCHAR2(9 BYTE)

Active Percentage of net set prior to haul.

RIVER_HEIGHT

VARCHAR2(6 BYTE)

Active River height of nearest large river.

SAMPLE_ID

VARCHAR2(10 BYTE)

Active Reference to sample haul is a part of.

SET_BEGIN_DATE

DATE

Active Date set began.

SET_BEGIN_DEPTH

VARCHAR2(6 BYTE)

Active Water depth, in whole fathoms, where set began.

SET_BEGIN_DEPTH_FROM

VARCHAR2(1 BYTE)

Active How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.

SET_BEGIN_LATITUDE

VARCHAR2(9 BYTE)

Active Latitude location, in tenths of minutes (dddmm.m), where the set began.

SET_BEGIN_LONGITUDE

VARCHAR2(9 BYTE)

Active Longitude location, in tenths of minutes (dddmm.m), where the set began.

SET_BEGIN_TIME

VARCHAR2(4 BYTE)

Active Time set began. Military time

SET_END_DATE

DATE

Active Date set ended.

SET_END_DEPTH

VARCHAR2(6 BYTE)

Active Water depth, in whole fathoms, where set ended.

SET_END_DEPTH_FROM

VARCHAR2(1 BYTE)

Active How depth obtained, O=Observer, P=Permit Holder, C=Marine Chart.

SET_END_LATITUDE

VARCHAR2(9 BYTE)

Active Latitude location, in tenths of minutes (ddmm.m), where the set ended.

SET_END_LONGITUDE

VARCHAR2(9 BYTE)

Active Longitude location, in tenths of minutes (ddmm.m), where the set ended.

SET_END_TIME

VARCHAR2(4 BYTE)

Active Time set ended. Military time.

SET_OBSERVED

VARCHAR2(1 BYTE)

Active Any part of set observed, Y=Yes, N=No.

SOAK_BEGIN_CORKLINE_SHAPE_ID

NUMBER(6,0)

Active Corkline shape at the beginning of the soak. references AMMOP_CORKLINE_SHAPE_CODE

SOAK_BEGIN_NET_TENSION_ID

NUMBER(6,0)

Active Net tension at the beginning of the soak. references AMMOP_NETEND_TENSION_CODE

SOAK_CORKLINE_SHAPE_CHANGES

VARCHAR2(6 BYTE)

Active Number of cork line shape changes during soak.

SOAK_END_CORKLINE_SHAPE_ID

NUMBER(6,0)

Active Corkline shape at the end of the soak. references AMMOP_CORKLINE_SHAPE_CODE

SOAK_END_NET_TENSION_ID

NUMBER(6,0)

Active Net tension at the end of the soak. references AMMOP_NETEND_TENSION_CODE

SOAK_TENSION_ADJUSTMENTS

VARCHAR2(6 BYTE)

Active Number of corkline tension adjustments during soak.

SOAK_TIMES_NET_RUN

VARCHAR2(6 BYTE)

Active Number of times vessel ran length of net.

TARGET_SPECIES_ID

NUMBER(6,0)

Active Target species. references AGENCY_SPECIE

TIDE_ID

NUMBER(6,0)

Active Tide cycle at beginning of haul. references AMMOP_TIDE_CODE

WATER_CLARITY

VARCHAR2(8 BYTE)

Active Water clarity measurement in tenths of meters.

COMMENTS

VARCHAR2(2048 BYTE)

Active Additional information.

gov.noaa.nmfs.inport:75080

Rachel Wuest

2025-03-05T17:46:37

Daniel Woodrich

2025-05-21T19:12:03

2025-05-21

Alaska Fisheries Science Center

AFSC

7600 Sand Point Way N.E., Building 4

Seattle

98115

USA

https://www.afsc.noaa.gov

0700-1700 Pacific Time

1001

Public

1 Year