Skip to Main Content

Header

QUICK START GUIDE

How to Run Landings Query

How to Download, Format, and Calculate Totals

Additional Information

How to Run Landings Query

Steps

1. To begin a report, select whether you would like commercial landings data, recreational landings data, or both using the Data Set check boxes at the top of the Parameters window. Next, select the year or years you would like to query by highlighting them in the list on the left. To select multiple years, hold down the CTRL key while clicking on the years you want, or click and drag down the list.

image

2. Once the years you wish to be included in your query are highlighted, click the right arrow to move them into the box on the right. 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.

image

3. Choose how you would like your query to group data geographically. By state, or by NOAA Fisheries region

image

4. Select the state(s), or region that you would like to query. Hold down the ctrl key or click-and-drag to select multiple states or regions simultaneously.

(Please note that for Florida, you will need to specify if you would like to view data for the east (Atlantic) coast, the west (Gulf of Mexico) coast, or both.)

image

5. Click the single arrow pointing right to add it to your query. If you accidentally select a state or region that you do not want to query, simply select it and click the arrow pointing to the left.

You can also select all states or regions by clicking the double arrow pointing to the right.

image

6. Select the species you would like to query. Hold down the ctrl key to select multiple species simultaneously. You can also select "ALL SPECIES. "

To find a specific species or group more quickly you can use the "Search Species" option to quickly narrow the options. For example, by typing "tuna" and clicking the "Search" button, you will only see those species with "tuna" in the name.

image

Please note that some group names such as "Salmon**" include only those salmonoid fishes that were not more specifically identified at the time of reporting. To get total Salmon landings, include all species AND "Salmon**".

7. Click the single arrow pointing to the right to add it to your query.

You can also select all species by clicking the double arrow pointing right

image

8. Click the RUN REPORT button.

image

9. The results of your query will appear on the right side of the page in the format you selected. To change the format, make a different selection and run the report again. Further modifications to your results can be made by clicking on the "Actions" button above your data. Here you can download your data, change the columns included in your results, and apply a variety of filters and mathematical tools. Please see below for further details.

image image

10. To start over or create a new query, select the Reset all Parameters button.

image


How to Download, Format, and Calculate Totals

Report Download

To download a Landings report:

  1. Click on the Format & Download dropdown button.
  2. Click Download
  3. Choose a format to download the report.
image

Chart

To create a chart or graph of the Landings data:

  1. Click on the Format & Download dropdown button.
  2. Click Format
  3. Click Chart
  4. Select a Chart Type.
  5. Select a column in the Label dropdown.
  6. Select a column in the Value dropdown.
  7. Select a mathematical function in the Function dropdown.
  8. Enter a title name in the Axis Title for Label field.
  9. Enter a title name in the Axis Title for Value field.
  10. Click the Apply button.

image

Highlight

To highlight specific information in the Landings report:

  1. Click on the Format & Download dropdown button.
  2. Click Format
  3. Click Highlight
  4. Select a Highlight Type. You can choose to highlight an entire row or a single cell where the condition is applicable.
  5. In the Highlight box, select a background color. This will be the color of the highlight.
  6. Choose which information to highlight in the Highlight Condition section by selecting an option from the Column, Operator, and Expression dropdowns.
  7. Click the Apply button.
image

Calculate

To calculate specific information in the Landings report:

  1. Click on the Format & Download dropdown button.
  2. Click Format
  3. Click Group By
  4. Select a column in the Select Group By Column dropdown.
  5. Select a function in the Functions dropdown.
  6. Select a column in the Column dropdown.
  7. Click the Apply button.
image



Additional Information

Landings Data Restrictions

Some caveats with the landings data:

The dollar value of landings are reported as nominal (current at the time of reporting) values. Users can use the Consumer Price Index (CPI) or the Producer Price Index (PPI) to convert these nominal landing values into real (deflated) values.

All annual and monthly landing summaries will return only non- confidential landing statistics. Most summarized landings are non- confidential, but whenever confidential landings occur, they have been combined with other landings and usually reported with "unc" for unclassified (i.e., "finfishes, unc" or "shellfishes, unc"). Total landings by state include confidential data and will be accurate, but landings reported by individual species may, in some instances, be misleading due to data confidentiality.

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.