The Atlantic Coastal Cooperative Statistics Program (ACCSP) is the principal source of dependable and timely marine fishery statistics for Atlantic coast fisheries

 

Data Warehouse FAQ

The timing of updates varies by data source. The status of available data can be found here. This status is updated as data are loaded.

The ACCSP data are unique because we harmonize data received from all program partners into one integrated set of codes for variables such as species, gear and fishing area. Data are available through flexible and intuitive queries and can be viewed or downloaded through our interface. Through the Data Warehouse, users can obtain confidential access to data that is retrievable and downloadable online so users do not have to wait for a data request to be fulfilled. If you have a custom request, the Data Team will work with you to provide you the data you need in a timely fashion.

ACCSP data can be used for a variety of projects and tasks including research, management decisions, stock assessments, compliance etc. If you have used the ACCSP data and would like to share your experience, please contact us at info@accsp.org.

Email support@accsp.org and ask to have your password reset. Please remember to include your full name in the email. You will receive an email with instructions and be required to change your password upon the next login.

A non-confidential account will allow you access to tables in the Data Warehouse that display non-confidential data only. Due to federal and state regulations that prohibit public disclosure of data that could lead to the identification of the contributing individual or individuals, access to detailed data is limited to those users with confidential accounts. Non-confidential data are summarized to abide by the rules of confidentiality.

A confidential account will allow you access to tables in the Data Warehouse that display non-confidential data as well as tables displaying confidential data to which you have been granted access.

The Data Warehouse has been tested using Internet Explorer 6 and Mozilla Firefox 1.5 and 2.0. Internet Explorer 7 is not yet supported by Oracle.

The Data Warehouse is available at the same level of accessibility 24/7 with the exception of scheduled back-ups from 10 pm Friday night to 3 am Saturday morning. The variation in speed that you experience is primarily dependent upon your personal Internet Service Provider. You likely notice that your connection is faster or slower at particular times of day and so the best time for you is when you find your connection to be fastest.

Reported quantity refers to what was landed and reported, including market and grade categories. Reported quantity must be viewed with the units of measure (lbs, bushels, etc.).

Landed pounds refers to the reported quantity converted into pounds. For example, a landing may have a reported quantity of 13 and unit measure of count and be dressed. These 13 dressed fish weigh 28 pounds and so the landed pounds is 28.

Live pounds is the reported quantity converted to whole animal weight. Live pounds is a more accurate measure of what was harvested. For example, the 13 dressed fish weigh 28 pounds, but represent 35 pounds of live weight. Shellfish are the exception and are converted to meat-weights in this column.

It depends. Dealer reports have true weights, market and grade categories and price information but are generally not required to have detailed fishing area and gear information. Dealer reports are more complete for total landings.

Therefore, dealer reports are best used for questions such as “How much of species X was landed last year in my state?”

Fishermen reports have better effort information (fishing area and gear) but weights may have been estimated by the captain.

Fishermen reports are best used for questions such as “How much of species X was caught in fishing area 611 (Long Island Sound)?"

Oracle Discoverer Viewer allows users to press the ‘Send as Email’ button found on the left side of the screen under the ‘ACTIONS’ menu to send the workbook output as an attachment to an email. If you think that all ACCSP users could benefit from your modified workbook, please email your workbook to support@accsp.org and request that your workbook features be incorporated into the standard workbooks available.

Once the original results of your query are displayed there are a number of options for rearranging the displayed results to suit your particular needs.

Next to the ‘Tools’ arrow just above the displayed table is the ‘Layout.’ By clicking this item you will display three pull-down boxes.

The first will allow you to ‘Move’ or ‘Swap’ and the second two will allow you to choose row, column and page item headings.

These options will allow you to create a page that works best for you.

For example, if the query displays the 2003 alewife landings for all months by area it will have area as rows, live pounds as a column heading and year and month as page items.  You can change this display to move area to column headings and month to rows to show the data as monthly values by area. With a little practice, these tools will greatly improve the flexibility of the queries.

Many queries allow the selection of more than one species. Select the species you are interested in and then run the query.

These species do not have to be scientifically related by family.

They can be caught in the same gear of have the same ecological role.

After the results are displayed, the species may be listed as a page item (drop down list above the table of results).

The drop down list includes ‘all species,’ which will group the results of your query.

For example, if you are interested in shrimp landings, but are unsure how each state reported the landings by species, select ‘SHRIMP, WHITE’, ‘SHRIMP, PINK’, ‘SHRIMP, BROWN’ and ‘SHRIMP, PENAEID’ and view the results by ‘all species.’

Depending upon the year and data source, some data may have been reported in monthly or annual summaries. If data are a monthly summary, the day value will be 00. If data are an annual summary the day and month values will be 00. The 00 value can also be found if the day or month are unknown or not reported.

Errors occur when you press return after completing a field instead of utilizing the ‘Go’ button. If you get an error, please use the back button and either move the cursor over to the ‘Go’ button before pressing return or use the mouse to click on the ‘Go’ button. You may need to log out and back in again to reset the query. If errors persist, please contact support@accsp.org.

If the display is not showing the rows or columns you would like, you may need to manipulate the rows, columns and page items to an arrangement that best suits your needs.

If you are not seeing the headings you want, you may need to drill deeper to display these items. This can be done by clicking the blue triangle next to a field heading, choosing ‘Drill to Related’ and then picking the desired field from the list displayed.

If you cannot arrange the page or drill to the desired level, you may not have access to this level of data. Please see our section on confidential vs. non-confidential accounts.

You can find information on how to do this here and more detailed instructions in the Data Warehouse User Manual.

If you have a unique question or cannot retrieve the data you desire from the Data Warehouse, you should complete this Custom Data Request Form. A staff member from the Data Team will work with you to create a custom data request.

The most important thing is to have a well defined question. Know what species, geographical span, temporal span, gears, etc. are relevant to your query. You should also be able to define your fishery.  The term fishery can refer to harvest of a particular species with a specific gear or be defined by a precise geographic area.

The Data Team will respond to your request within two weeks. However, issues with confidentiality and partner clearance can extend this turn-around time. Please allow for this lead time when you are submitting a custom data request.