About the Data Warehouse
The Data Warehouse is an online database populated with Atlantic coast fishery-dependent data supplied by the ACCSP's 23 program partners. The Warehouse harmonizes all of the data received into one set of codes for variables such as species, gear, and fishing area, making it possible to combine datasets from different sources for larger scale analyses.
What is the data load process?
Types of Data Available
Commercial landings data represent the best compilation of state and federal landings submitted by both dealers and fishermen. Commercial Catch and Effort (trip reports) are fisherman reports, or logbooks that typically have good effort data (area/gear) but in most cases do not represent 100% of the fishing activity (pounds landed).
ACCSP has Biological sampling data for American lobster (1981-2016) and Atlantic herring (2002 - 2016) available via custom data request.
ACCSP has recreational catch and effort data starting in 1981 available via the Data Warehouse. The data since 2004 have been updated in conjunction with the new Marine Recreational Information Program estimation methodology released in February 2012. This includes both the public estimates and the advanced queries for bag limit analysis and directed trips.
Which Data Warehouse should I use?
Public Data Warehouse
- No username and password required
- Only non-confidential data available
- Data can be exported or downloaded
- Queries may not be saved
Login Data Warehouse
- Username and password required
- Contains both non-confidential and confidential data--the data presented will depend on the user's level of access
- User must apply for a non-confidential or confidential account
- Queries and workbooks can be saved and reused
Custom Data Request
- If you have a unique question or cannot retrieve the data you desire from the Data Warehouse, you can submit a custom data request.
- The Data Team will work with you to develop a custom dataset that suits your needs. To submit a custom data request, please click below.
Citing the Data Warehouse
ACCSP recommends the following citation format to cite data retrieved from the Data Warehouse:
Atlantic Coastal Cooperative Statistics Program. (Dates of data by year). Nested Menu Title; generated by John Doe; using Data Warehouse [online application], Arlington, VA: Available at http://www.accsp.org; (Login or Public) Data Warehouse; accessed (month, day, year).
Atlantic Coastal Cooperative Statistics Program. (2007-2016). Data Warehouse, Confidential, Fishermen Trips, Summary; generated by John Doe; using Data Warehouse [online application], Arlington, VA: Available at http://www.accsp.org; Login Data Warehouse; accessed (June, 28, 2017).
Atlantic Coastal Cooperative Statistics Program. (2017). SAFIS, SAFIS Landings, Summary; generated by John Doe; using Data Warehouse [online application], Arlington, VA: Available at http://www.accsp.org; Login Data Warehouse; accessed (May, 16, 2017).
Email firstname.lastname@example.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.
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)?"
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.