How to Run Processed Products Query
How to Download, Format, and Calculate Totals
Additional Information
How to Run Processed Products Query
1. To run a report select parameters. Select the year that you would like to query. To select multiple years, hold down the ctrl key while clicking on the desired years or click-and-drag for subsequent years.
|
2. Click the single arrow pointing right to add it to your query. If you accidentally select a year that you do not want to query, simply select it and click the arrow pointing to the left.
You can also select all years by clicking the double arrow pointing right.
|
3. Select the product type that you would like to query. Hold down the ctrl key or click-and-drag to select product types simultaneously.
|
4. Click the single arrow pointing right to add it to your query. If you accidentally select a product type that you do not want to query, simply select it and click the arrow pointing to the left.
You can also select all product types by clicking the double arrow pointing to the right.
|
5. Select the species you would like to query. Hold down the ctrl key to select multiple species simultaneously.
To find the species type more quickly, you can use the "Search in Species" option to quickly narrow down the options. For example, by typing "tuna" and hitting "search," you can see the species field is narrowed to just tuna species.
|
6. Click the single arrow pointing to the right to add it to your query.
You can also select all product types by clicking the double arrow pointing right
|
7. Click the RUN REPORT button.
|
8. The results will appear on the right side of the page, by Year, Product name, Species, Pounds, and Dollars processed.
|
9. To start over or create a new query, use the left arrows to clear all previous selections.
|
How to Download, Format, and Calculate Totals
To download a Processed Products report:
- Click on the Format & Download dropdown button.
- Click Download
- Choose a format to download the report.
|
To create a chart or graph of the Processed Products data:
- Click on the Format & Download dropdown button.
- Click Format
- Click Chart
- Select a Chart Type.
- Select a column in the Label dropdown.
- Select a column in the Value dropdown.
- Select a mathematical function in the Function dropdown.
- Enter a title name in the Axis Title for Label field.
- Enter a title name in the Axis Title for Value field.
- Click the Apply button.
|
To highlight specific information in the Processed Products report:
- Click on the Format & Download dropdown button.
- Click Format
- Click Highlight
- Select a Highlight Type. You can choose to highlight an entire row or a single cell where the condition is applicable.
- In the Highlight box, select a background color. This will be the color of the highlight.
- Choose which information to highlight in the Highlight Condition section by selecting an option from the Column, Operator, and Expression dropdowns.
- Click the Apply button.
|
To calculate specific information in the Processed Products report:
- Click on the Format & Download dropdown button.
- Click Format
- Click Group By
- Select a column in the Select Group By Column dropdown.
- Select a function in the Functions dropdown.
- Select a column in the Column dropdown.
- Click the Apply button.
|
Additional Information
Processed Products Data Restrictions |
Some caveats with the Processed Products data:
Every year NOAA Fisheries conducts a survey of seafood processors across the United States gathering information on product quantity and value as well as plant employment. This data collection spans all regions within NOAA Fisheries and generates important information for use in publications and management decisions. The Annual Survey of Seafood Processors is one of the only data collection efforts that includes all companies, regardless of plant size, and includes quantity and value information at the species level (when possible).
The data collection is a collaborative effort between headquarters and the NOAA Fisheries Regions. Regional port agents distribute the survey to the processors in their area and stay in contact throughout the process to assist in filling out the form and answer any questions. Regional port agents play a vital role in keeping the survey current and reach out to local processors to improve return rates. The completed surveys are forwarded to NOAA Fisheries Headquarters, where Office of Science and Technology Fisheries Statistics Division staff enter all data, follow up with processors and port agents, tabulate annual figures and maintain historical databases.
|
User Feedback
|
Let us know what you think.
We are looking for user feedback on this query tool as we continue to fine-tune it and add new features.
Please navigate to the comments tab to submit a brief comment.
|