How to Run Landings Query
How to Download, Format, and Calculate Totals
Additional Information
How to Run Landings Query
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.
|
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.
|
3. Choose how you would like your query to group data geographically. By state, or by NOAA Fisheries region
|
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.)
|
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.
|
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.
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
|
8. Click the RUN REPORT button.
|
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.
|
10. To start over or create a new query, select the Reset all Parameters button.
|
How to Download, Format, and Calculate Totals
To download a Landings 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 Landings 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 Landings 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 Landings 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
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.
|