Home

User Manual

1. _ Click to view or save Return to worksheet 10 HOW DO I SAVE FILES As a login user you can save your worksheet two ways Either you can save results to your computer when you get the message from Screenshot 21 Your Export is Ready page 24 or in the Actions box in the upper left corner on this page labeled Screenshot 22 Actions Menu Bax for Login Users Click on the Save as link in the Ac tions menu box Saving your worksheet is a good idea if you have to repeatedly run the same query Once you click the Save as link it will take you to a page that will allow you to name your table see opposite page labeled Screenshot 23 Saving and Naming Tables In our example we have named our table MD Black Sea Bass Commercial Landings Make sure to click on the Apply button at the right of the screen You will now be taken back to your worksheet However in the upper left corner you will see a message that tells you your workbook was successfully saved see opposite page labeled Screenshot 24 Workbook Saved The Workbooks link at the very top of the page can take you back to the list of workbooks Click on that link now to see your newly saved workbook listed MD Black Sea Bass Commercial Landings is now saved in your list of workbooks circled on opposite page in Screenshot 25 I zst of Available Workbooks Itis impor tant to remember that you are the owner of this work bo
2. Month in Year circled in Screenshot 16 Dr to Related Months and Year Use the layout toolbar to In Screenshot 17 Single State Monthly adjust the fields until you Landings Table you can see the monthly have them in the dsiplay landings of black sea bass for Maryland If that will work best for you you have confidential access there are a number of additional fields that are available and you can use this same drilling technique to display them Once you have displayed the field it can be moved around with the layout tools just as you did with the original fields Atlantic Coastal Cooperative Statistics Program ACCSP 8 HOW DO VIEW LESS DATA Drilling is used to add fields to your table If you would like to get rid of fields you can use the Collapse feature As you are looking at the Maryland monthly black sea bass landings table you left click on the blue triangle next to Year You will get a menu illustrated in Screenshot 18 Collapsing Data This is the same method used to drill data but the first option wasn t available before and is known as the Collapse feature When you collapse you are rolling all of the inner fields into the outer field you have chosen with the blue triangle J NA ua Me Ss A N a k 4 t p A TANNEZ et Gay WEL X id Dh ARVN Yi AN DWUM Data Warehouse User Manual 22 Screenshot 16 Dr to Related Months and Year yCr
3. WORKBOOK WITH OTHERS Oracle Discoverer allows you to export the results of your query to share with others see page 23 for more details Please remember that ACCSP 1s only the stewards of the data Due to federal and state regulations that prohibit public disclosure of data that could lead to the identi fication of the contributing individual or individuals access to detailed data is limited to those users with confidential accounts Please be mindful of this when you ate sharing your workbooks with others If you think that all Data Warehouse users could benefit from your modified workbook email your workbook to support accsp org and request that your workbook features be incorporated into the standard workbooks available HOW DO I REARRANGE ROWS COLUMNS AND PAGE ITEMS Once the original results of your query are displayed there are a number of options for rearranging the dis played 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 The second two will allow you to choose row column and page item headings For example if the query displays the 2003 alewife land ings 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
4. Se See DATA CENTER DATA WAREHOUSE EXIT SURVEY Did you find everything you were looking for By completely the exit survey you can tell us how effectiveness of the Data Warehouse Sh ee ee eee meee AboutUs Data Collection Standards DataCenter Links MediaCenter Document Archives Contact U Atlantic Coastal Cooperative Statistics Program ACCSP 13 WHAT DO YOU THINK You can leave the Data Warehouse at any point by click ing on the Exit link in the far upper right corner of the screen The exit page is illustrated on this page labeled Screenshot 35 Data Warehouse Exit Page When you leave you will be asked to take our survey Please take the time to fill this out so that we can make changes as necessary to improve the performance and usefulness of the Data Warehouse You don t have to fill out the survey each visit but it would be most appreciated if you could respond after one of your first visits and then again after you have spent more time using the system aS 5yr ia gt m A Data Center MORE INFORMATION Thank you so much for completing the survey your response is essential to continually improving the Program DATA WAREHOUSE EXIT SURVEY HELP Staff are available to assist during extended business hours 8 30 am 5 00 pm Monday through Friday at 703 842 0780 or support accsp org Status of Available Data Data Warehouse User Manual Atlantic Coast Fisheries Dat
5. a list of options for the file format of your export Our example will produce a Microsoft Excel Workbook xls file Once you have chosen your file type from the drop down list click on the Export button After a few seconds you will see a message that tells you your data request is ready Screenshot 21 Your Export is Ready You can use the Click to view or save button right to open your file or save Click to view or save it to your computer Below the button is a link to return to yout worksheet If you are done you can use the Exit link in the center of the screen to end your session At this point all login users will get a message asking if they would like to save the worksheet DWUM Data Warehouse User Manual Screenshot 19 Export from Actions Menu Box Connect gt Workbooks gt Commercial Landings Dealer Reports Non Confidential Landings by State by Species M04 2013 2 32 17 PM EDT Landings by State by Species Species Landed BASS BLACK SEA Landing Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Revert to saved 04 JUN Printable page Export Worksheet options y Parameters Select values for the following parameters Worksheets Indicates required field Select one or more BASS BLACK SEA L Species Atlantic Coast Landings Trends Species common name for which to display landings Table Select one or mor
6. 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 If the display is not showing the rows or columns you would like you may need to mantpulate the rows col umns 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 ac counts HOW DO I GROUP INDIVIDUAL SPECIES Many queries allow the selection of more than one species Select the species you are interested in and then run the query 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 If youre 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 WHAT DOES THE 00 MONTH AND DAY VALUE MEAN Dependi
7. each partner s data An understanding of the differences between 1 the indi vidual needs and requirements and 2 knowledge of the As program partners update data we inform you via history of the local data collection at the partner level is email updates and posting on the ACCSP website STATUS OF COMMERCIAL CATCH amp EFFORT DATA COLLECTION The chart below illustrates how data are collected at the partner level and the level of detail at which those data are submitted to the Program The Program began receiving all data directly from partners in 2007 1994 1995 2000 2001 2003 2007 Today 2004 2005 2006 ME DMR NH FGD MA DMF RI DFW CT DEEP NYS DEC NJ DFW DE DFW MD DNR VMRC NC DMF SC DNR GA DNR FL FWCC WHAT DO THE COLORS REPRESENT Trio reports represented as monthly summaries sumn Trip reports all fisheries Annual summaries Monthly summaries Atlantic Coastal Cooperative Statistics Program ACCSP UDERSTANDING CONFIDENTIALITY It is important to understand that ACCSP is the steward of the data in the Data Warehouse Due to federal and state regulations that prohibit public disclosure of data that could lead to the identification of the contribut ing individual or individuals access to detailed data is limited to those users with confidential accounts A confidential account will allow you access to tables in the Data Warehouse that display non confidential data as well as table
8. gt Recreational Estimates MRIP data for 2004 to present Users can enter parameters species years etc for each worksheet Atlantic Coastal Cooperative Statistics Program ACCSP D ADDITIONAL FEATURES THIS SECTION WILL COVER 11 Crosstab and Graph Options 12 Sharing your work 13 What do you think 11 CROSSTAB AND GRAPH OPTIONS Now you can 1 add and remove fields 2 manipulate the display 3 and export your results But there are some other useful features of the Data Warehouse that make it a valuable resource for fisheries management From the same Actions menu box from our worksheet page we will go to Worksheet options Click on the bubble next to Both to add a graph to your view illus trated in Screenshot 26 Worksheet Options Click on the Apply button at the right of the screen to see the new look of the query You should now be able to see the original table we have been using along with a graphical representation just below represented on opposite page labeled Screenshot 27 Crosstab and Graph Query DWUM Data Warehouse User Manual Screenshot 26 Worksheet Options Connect gt Workbooks gt MD Black Sea Bass Commercial Landings Landings by State by Species gt Worksheet options Select the items to display in the worksheet Cancel Display Options Title Graph Crosstab Both Text Area Text Area Sheet Options Show axis label
9. gt State Landed gt DE 185 717 362 923 gt MD 1 322 825 2 895 009 NJ 6 273 337 13 982 576 PNY 2 825 747 8 106 799 PVA 5 342 935 14 199 090 Year Total 15 950 561 39 546 396 Grand Total All Years 36 816 008 81 647 705 Screenshot 14 Annual Black Sea Bass Landings by State for the Mid Atlantic Region from 2000 to 2012 yCrosstab VY Tools Layout Format Stoplight Rows and Columns Move State Landed DE Below Measure Live Lbs Go More Page Items Species BASS BLACKSEA Subregion Mid Atlantic gt State Landed DE gt MD gt PNY PVA Live Lbs Value Live Lbs Value Live Lbs Value gt Year gt 2000 40 354 55 713 139 643 209 753 587 220 1 032 318 138 537 264 953 647 984 1 334 847 gt 2001 2 845 4845 78 577 140 756 646 810 721 349 248 796 395 110 661 208 1 316 536 2002 4517 7 568 196 786 316 716 618494 938 431 286 719 700 607 771 401 1 588 776 gt 2003 15 568 25 275 192 035 354 037 667 896 1 245 379 227 381 556 904 507 149 1 306 030 gt 2004 64 264 135 476 277 845 559 136 694815 1 270 809 233 491 549 416 496 811 1 162 714 gt 2005 913 2365 77 779 158 916 545 358 1 277 052 244074 714 783 433 852 1 128 303 gt 2006 9 608 23 852 43 104 117 502 494352 1 327 173 312 305 1 037 948 327 926 1 047 720 gt 2007 17 852 36 166 28140 85 383 480 112 1 474 249 270 404 989 377 189 376 662 910 gt 2008 17 332 36 814 50526 149 558 424667 1 086 240 201 930 70
10. individual trans actions to the Data Warehouse on a regular basis Data are then checked processed and loaded into the Data Ware house As soon as this process is completed the data are made available to you It should be noted that no adjust ments to numeric values are made without coordination with the data provider i e program partner The database is designed to accommodate a two ticket model of fisheries data collection This system assumes that there are separate reports tickets from both com mercial fish dealers and commercial fishermen The data from the dealers landings includes condition and price The data from the fishermen catch and effort includes gears used fishing areas and catch disposition In work ing with the data it is important to understand that these are separate data sets The two ticket reporting model is used from Maine to Virginia Many partners have elected to implement two ticket systems In this case the data sets are derived from infor mation submitted North Carolina to Florida reporting is done through a one ticket system where dealers provide landings data landing condition quantity and pricing and fishermen provide effort data gears fishing areas hours fishing Although fishermen provide catch quanti Atlantic Coastal Cooperative Statistics Program ACCSP ties these are most often estimates rather than actual weigh out Totals between landings and caught queries may not be equa
11. the information and provide an appropriate course of action Users are accountable for any violations by the partner granting access The Atlantic Coast Fisheries Data Collection Standards was updated in 2012 and is considered the blueprint for ACCSP To download please visit hitp wmm accsp org documents programdesign 2012 ACCSP_StandardsandAp pendices2012_Final0508201 2 pdf DWUM Data Warehouse User Manual NON CONFIDENTIAL QUERIES Confidential records are removed for non confidential users therefore values generated in non confidential queries may not be complete and accurate ACCSP has made every effort possible to minimize these differences and each non confidential workbook has a worksheet with comparisons to the confidential landings totals by species and year We do this by grouping all states and fishing areas combined These comparison views were created to provide a measure of how much data are confidential at the species year level More detail on workbooks and worksheets is provided on pages 9 and 10 CONFIDENTIAL QUERIES Users who have obtained signed permissions for confidential data access can run more detailed reports on the Data Warehouse It is important to note that the amount of data viewed is based on the access agreements Confidential users cannot assume they have complete data with access to only one confidential data source Confidential access for ACCSP is granted by dat
12. the table Click on the Layour link from the Tools menu Three drop down lists will appear Move Spe cies and Below Measure appear as these drop down lists in Screenshot 10 Layout Tools on the opposite page We ll start by moving the subregion You can do this by choosing Move in the first box Subregion in the second box and To Page Items in the third box Then click the Go button Notice that a subregior drop down now appears next to the Page Items in Screenshot 11 Layout Tools Subregions Default As a default the drop down box chooses the first option In our example it is the Gulf of Mexico This is also why only the state of Florida is shown We ll change this by choosing Mid Atlantic from the subregion dropdown as illustrated in Screenshot 12 Layout Tools Subregions Mid Atlantic example You should now be able to view the black sea bass landings for Delaware Maryland New Jersey New York and Virginia DWUM Data Warehouse User Manual 18 Screenshot 10 Layout Tools Landings by State by Species Species Landed BASS BLACK SEA Landing Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 20 y Parameters Select values for the following parameters Indicates required field Select ome ormore 545s BLACK SEA iP Species Species common name for which to display landings
13. then click Go circled on opposite page labeled Screenshot 13 Layout Tools Adjusting Year However you may want it easier to view So lets Move the State Landed to Columns then click Go Also we can now get the species out of the way since we are only dealing with black sea bass To do that choose Move Species and Page Items circled in Screenshot 14 Annual Black Sea Bass Landings by State for the Mid Atlantic Region from 2000 to 2012 Congratulations You should now see a clear easy to read table of annual black sea bass landings by state for the Mid Atlantic region from 2000 to 2012 You now have the information you need to move around the fields that are displayed Were ready to move on to the next section all about adding additional fields to your view Atlantic Coastal Cooperative Statistics Program ACCSP DWUM Data Warehouse User Manual Screenshot 13 Layout Tools Adjusting Year yCrosstab Y Tools Srmat Stoplight Rows and Columns Move Year v LeftofState Landed DE f Go More a Ap PPS E Y RAI SEM LAR ea Rc S E a Nien e Sa ae a ee a Above Species BASS BLACKS A A EE A e K hereto A Above Measure liiiasaiys C Pagelofl Below Measure Live Lbs Left of State Landed DE Page Items Subregion Mid Atlantic Year lt A Right of State Landed DE Species BASS BLACK SEA a e Live Lbs Value To Rows
14. 1 810 215390 758 848 gt 2009 5 843 25 164 56 814 251 723 203 867 590 449 124022 428 002 164389 568 836 gt 2010 2 989 7 831 91 349 257 045 305 294 995 563 201 708 617 542 263 563 927 975 gt 2011 3 524 1 762 53 470 180 488 293 609 970 008 183 207 623 135 271 554 994 327 amp 2012 108 92 36 757 113 997 310 842 1 053 556 153 173 527 212 392 332 1 401 269 Year Total 185 717 362 923 1 322 825 2 895 009 6 273 337 13 982 576 2 825 747 8 106 799 5 342 935 14 199 090 Grand Total All Years 185 717 362 923 1 322 825 2 895 009 6 273 337 13 982 576 2 825 747 8 106 799 5 342 935 14 199 090 20 7 HOW DO I VIEW MORE DETAIL You now have the information you need to move around the fields that are displayed and we are ready to move on to adding additional fields to your view and drill down for more detail The table is easier to read while viewing only one state so we ate going to display only the state of Maryland by choosing MD from the State Landed dropdown circled on opposite page labeled Screenshot 15 Szzg e State Annual Landings Table By left clicking on the blue triangle next to year you can see the additional fields such as months that are avail able This feature will not work if you are using Internet Explorer 7 or 8 It does work with Internet Explorer 9E or above We suggest that you use Mozilla Firefox to make this feature available Click on Drill to Related and choose
15. All rights reserved About Oracle BI Discoverer Viewer Version 11 1 1 6 0 Oracle Technology Network 9 Atlantic Coastal Cooperative Statistics Program ACCSP D QUERYING the DATA THIS SECTION WILL COVER 3 HOW DO I NAVIGATE AROUND THE DATA WAREHOUSE How do I navigate around the Once you entered with Data Warehouse either with or Data Warehouse without a login you will now be on the Data Warehouse How do query the data Homepage How do I select parameters On this page you will see a result list The result list will show you the list of workbooks available to you If you have non confidential access or are using the public ver sion your screen will appear as shown as Screenshot 3 Data Warehouse Homepage I you have confidential access you will have more workbooks available to you Any specialized workbooks that you have created and saved with your non confidential or confidential login account will be shown on this page We will discuss how to save specialized workbooks later in this manual By clicking on one of the blue arrows you can open the workbook to see a list of the available worksheets As an example the list of all worksheets within the ACCSP Codes workbook is shown as Screenshot 4 Codes Workbook and Worksheets For a list of all non confidential workbooks and worksheets see page 36 of this manual Confidential workbooks and worksheets will depend upon your level of access DWUM Data Warehouse Us
16. Atlantic Coastal Cooperative Statistics Program DATA WAREHOUSE User Manval 2013 edition OUR PROGRAM PARTNERS NOAA Fisheries U S Fish and Wildlife Service Atlantic States Marine Fisheries Commission New England Fishery Management Council Potomac River Fisheries Commission Mid Atlantic Fishery Management Council South Atlantic Fishery Management Council Maine Department of Marine Resources New Hampshire Fish and Game Department Massachusetts Division of Marine Fisheries Rhode Island Division of Fish and Wildlife Connecticut Department of Energy and Environmental Protection New York State Department of Environmental Conservation New Jersey Division of Fish and Wildlife Delaware Division of Fish and Wildlife Pennsylvania Fish and Boat Commission District of Columbia Fisheries and Wildlife Maryland Department of Natural Resources Virginia Marine Resources Commission North Carolina Division of Marine Fisheries South Carolina Department of Natural Resources Georgia Department of Natural Resources Florida Fish and Wildlife Conservation Commission WWW NMS NOAA gov WWW JWS LOV WWW ASM C OTZ WWW NEJMC OTS www prfe state va us www mafme org www safime net www maine gov dmr www wildlife state nh us Fishing www mass gov dfyele dmf www dem ri gov www ct gov deep www dec ny gov www state nj us dep few www fw delaware gov www fish state pa us WWW dC ZOV www dnr state md us fis
17. Bva 4 550 024 12 737 22 F worm atere 3 00 Ate 20 497 427 gt ot zags 02 227 Pua ssie 31 250 242 bnn z3 1 408 Pra 7339 14 782 gt F 3416 392 2287 72 P South atende 2 318 27 17 902 462 rr 32252323 4 TE SET PGA 138 gier NC 7 248 144 54 182 239 sc 345078 2 414484 Your Iota S487 450 STS 142 052 Grand Total All Yearc 34 387 450 75 142 052 DWUM Data Warehouse User Manual Screenshot 9 Choosing Year Parameters Search and Select Landing Year This page enables you to select the parameter values Cancel Select Search To find the value select a filter in the drop down list and enter a word in the text field then click the go button To see a list of all values clear the search box and click the go button Search by sad OOiS CO Case Sensitive Results Available Selected 2000 2001 2002 2002 S 2004 A 2005 Move 2006 2 2007 Move All 2008 a 2009 lt amp 010 Remove 2011 ee Remove All Previous 25 51 71 of 71 v Next gt C ANALYZING the DATA THIS SECTION WILL COVER How can I change the display How do I view more detail How do I view less data How do I export files How do save files Atlantic Coastal Cooperative Statistics Program ACCSP 6 HOW CAN I CHANGE THE DISPLAY From the page where you can view yout initial results there is a list of tools to help you work with the data You can use the layout tools to change the display of
18. Select one or more Landings Year s 2000 2001 2002 2003 2004 2 Sf OPTIONAL Year the landing was unloaded No selection ALL YEARS yCrosstab VTools Lave o Go More Move Species BASS BLACK SEA Below Measure Live Lbs 9 Pagelofl Page Items Year lt All gt v Screenshot 11 Layout Tools Subregions Default Screenshot 12 Layout Tools yCrosstab Subregions Mid Atlantic example yCrosstab V Tools Layout Format Stoplight Rows and Columns Pagelofl Move v Species BASS BLACK SEA Below Measure Live Lbs v Go More Page Items Subregion GulfofMexico Year lt All gt v C Pagelofl Species BASS BLACK SEA a Live Lbs Value Pad gt State Landed e a Ee yrii Mid Atlantic z MRTE Aaa North Atlantic Value Year Total 1 950 972 1 771 934 gt State Landed South Atlantic y y A lt All gt gt DE Bo 362 923 Grand Total All Years 36 816 008 81 647 705 j gt MD 1 322 825 2 895 009 NJ 6 273 337 13 982 576 gt NY 2 825 747 8 106 799 gt From Screenshot 12 Layout Tools Subregions Mid Atlantic example on page 18 we see all the years of landings lumped together You will most likely want to view each yeat separately We ll again use the layout tools to adjust the way Year is illustrated Choose Move Year and Left of State Landed DE
19. a Collection Standards FAQs for the Data Warehouse User ara VVarenn DWUM Data Warehouse User Manual FREQUENTLY ASKED QUESTIONS WHAT IS THE CURRENT STATUS OF DATA The timing of updates varies by data source program partners The most up to date status of available data can be found at hitp grouper acesp org 8080 my SPs SOAD pp WHY amp HOW SHOULD I USE ACCSP DATA The data in the Data Warehouse 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 We make the data available through personalized queries that can be viewed or downloaded through our flexible and intuitive interface Data can be used for a variety of projects and tasks including research management decisions stock assess ments compliance etc If you have retrieved data from the Data Warehouse data and would like to share your experience please contact us at info accsp org WHAT IF FORGET MY PASSWORD 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 HOW DO NON CONFIDENTIAL AND CONFIDENTIAL ACCOUNTS DIFFER A non confidential account will allow you access to tables in the Data Warehouse that display non confidential data only Due to federal and s
20. a source agency that col lected the data and therefore it may be necessary to have access to more than one soutce to see all of the data For example landings for one state port of landing may have been reported to two adjacent states and the NOAA Fisheries depending on the species and how the landing was reported Therefore to obtain complete data the user would need access to all three states and NOAA Fisheries data The ACCSP website has tables that show what sources have contributed data to landings in each state To view these tables please visit A4p grouper acesp org 8080 myJSPs status jsp A LETTING STARTED THIS SECTION WILL COVER 1 How do l access the Data Warehouse 2 How do I request an account 1 HOW DO I ACCESS THE DATA WAREHOUSE From the ACCSP homepage wwm accsp org you should scroll over Data Center and then click on Data Ware house from the menu that appears The page that you will be directed to is on the opposite page labeled as Screenshot 1 Te Data Warehouse Page You can access the data in the Data Warehouse 1 pub licly see opposite page labeled Screenshot 2a The Public Data Warehouse Page ot 2 with a login Both ways provide you the ability to access valuable fishery dependent data from all of our partners along the Atlantic coast Queries that you run within the Public Data Warehouse can not be saved However you can export or download the data When you come
21. al data policies and therefore each agency that you are requesting access to will have to ac cept or deny your request for confidential data access Once your account has been approved you will receive an e mail from us confirming your access with a username and instructions on how to set a password If at anytime you forget your password send us an email at support accsp org and we will reset it for you DWUM Data Warehouse User Manual Screenshot 1 The Data Warehouse Page e ATLANTIC COASTAL COOPERATIVE STATISTICS PROGRAM 16 000 ai Se AboutUs DataCollection Standards DataCenter Links Scag K Syuk Tar a T Media Center E rd d 2 DATA CENTER DATA WAREHOUSE What is the Data Warehouse The Data Warehouse is an on line database populated with fishery dependent data supplied by the 23 program partners of ACCSP The Data Warehouse is available 24 hours a day with the exception of an amp hour hiatus from Friday at 10 00 pm until Saturday at 6 00 am when the system is brought down for back ups What makes the Data Warehouse unique The Data Warehouse harmonizes fishery dependent data received from all program partners into one integrated set of codes for variables such as species gear and fishing area The benefits for using the Data Warehouse are that you have the ability to 1 access valuable and time saving tools such as exporting pivot tables 2 access attractive graphical reports tailored
22. ample a landing may have a re ported 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 DWUM Data Warehouse User Manual SHOULD LOOK AT DEALER REPORTS OR FISHERMEN TRIPS It depends on what you are looking to find Dealer re ports 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 ques tions such as How much of species X was caught in fishing area 611 Long Island Sound Please keep in mind that historically fishermen reports have not been required by all agencies Therefore fishermen reports may only represent a percentage of total dealer reported landed pounds HOW DO I SHARE A CUSTOMIZED
23. ave your parameters set you can click the Go button The results will populate at the bottom of the Parameters page on this page Screenshot 8 Crosstab of Populated Results Congratulations you have queried black sea bass for 2000 2012 Atlantic Coastal Cooperative Statistics Program ACCSP Screenshot 8 Crosstab of Populated Results Yomnect gt Workbooks gt Commercial Landings Dealer Reports Non Confidential L vast run Tussdzy May 14 2013 2 38 08 PM EDT Actions Landings by State by Sp Rerun query Species Landed BASS BLACK SEA Landings Year 2000 2001 2003 2002 Save as Revert to szvod Sanh a v Parameters Worsies options Select veloss for the follows parameters indicztes required eld Workskeoss ka a Atlante Coast Leniinss Sporas Trends Graph Species common names Sor niich to displey landings Aname Cost Lanting Select ons ce more rends Table Landings Year s 2000 2001 2002 2002 2004 2t of Landinga by Sats by Species OPTIONAL f e Your the lending was unloaded No selection ALL YEARS Landings by Stets md Yox Eos Crosstab PTools Lavost Format Stoplight Rons and Colsmm Pans L of 1 Pago Items Yer za v Pze PASS TATK SEA Uve bs Yy P gurrepos P isie Lancec Gul of Mence 1314620 1 111 623 re 1314629 1 111 623 vec Atertc 19 072 07 28 490 214 bos 185 029 382 283 Puo 1 301 788 2 781 286 Fre 9 282433 12 525 535 Pwr 272 373 7 572 387
24. d Trends Graph Select values for the following parameters Indicates required field rends Table Landings by State by Select one 2 a Speci pecies pecies Comparison to Confidential Totals Select one or more Landings by State and Year Landings Yeas __ Od OPTIONAL Year the landing was unloaded No selection ALL YEARS 5 HOW DO I SELECT PARAMETERS If you do not see a pop up that looks like Screenshot 7 Choosing Species Parameters see opposite page make sure you have enabled pop ups from ACCSP SPECIES You can find the species you need by typing a portion of the name in the Search for field and clicking on the Go button Since our example is to run a query for black sea bass we ve typed in bass and clicked the Go button A list of available results appears Atlantic Coastal Cooperative Statistics Program ACCSP We can highlight the particular species in our example we will click on Bass Black Sea we d like from the avail able results on the left and click the Move button to move the item from the available to the selected side You can also double click a species to move it from one list to another Then click one of the Select buttons far right in Screenshot 7 Choosing Species Parameters and the pop up will close DWUM Data Warehouse User Manual 14 Screenshot 7 Choosing Species Parameters Search and Select Species Landed This pa
25. e i g Landings by State by Species Landings Year s 2000 2001 2002 2003 2004 2 f Comparison to Confidential OPTIONAL Totals Year the landing was unloaded No selection ALL YEARS Landings by State and Year 6g y Crosstab Y Tools Layout Format Stoplight Rows and Columns Move State Landed DE Above Measure Go More Screenshot 20 Exporting File Formats Connect gt Workbooks gt Commercial Landings Dealer Reports Non Confidential Landings by State by Species gt Choose export type Use the drop down list to specify the export file format CSV Comma delimited csv CSV Comma delimited csv DIF Data Interchange Format dif Formatted Text Space delimited prn GIF Image P pepy ferences Exit Help Hyper Text Markup Language archived l rights reserved Microsoft Excel Workbook xls 1 1 6 0 Microsoft Excel Workbook with Pivot Table xls Oracle Reports XML xml PNG Image png Portable Document Format PDF pdf SYLK Symbolic Link slk Text Tab delimited txt Web Query for Microsoft Excel 2000 iqy WKS Lotus 1 2 3 wks Screenshot 21 Your Export is Ready Connect gt Workbooks gt Commercial Landings Dealer Reports Non Confidential Landings by State by Species gt Export Ready The export you requested is ready Please click the button below to open the exported document to view or save it
26. ecific workbook or result set Use the drop down menu to choose between Database and Scheduled Workbooks Search Al Workbooks JO d Result List Refresh Expand All Collapse All Focus Name Description Owner Last Modified Y Discoverer Workbooks A listing of ACCSP standard codes for use as a reference to what is ACCSP Codes available in ACCSP as well as the translations from other coding ACCSPTEST Monday May 24 2010 11 18 53 AME systems to ACCSP codes ACCSP Partners States Counties Ports Areas Fished Species Species s Fishing Gears Dispositions Distance From Shore Market Categories 11 Atlantic Coastal Cooperative Statistics Program ACCSP 4 HOW DO I QUERY THE DATA Now we ate ready to query data As an example we are going to look for black sea bass landings from 2000 2010 We are going to begin by using the workbook Commercial Landings Dealer Reports Non Confi dential Click on the blue arrow to the left of the title to view the 5 worksheets that exist in that workbook op posite page labeled Screenshot 5 Example of Workbook and Worksheets Next we ll click on the third worksheet in the list titled Landings by State by Species circled in Screenshot 5 Example of Workbook and Worksheets Once you decide which worksheet you want to extract data from you will come to a page that asks you to provide some parameters see opposite page labeled Screenshot 6 Choosing Parameters The f
27. er Manual 10 Screenshot 3 Data Warehouse Homepage ronnect gt Connected to publ Worksheet List Search Type in a search string to find a specific workbook or result set Use the drop down menu to choose between Database and Scheduled Workbooks Search All Workbooks Ge Result List Refresh Expand All Collapse All gt Focus Name Description Owner Last Modified Y Aiscoverer Workbooks A listing of ACCSP standard codes for use as a reference to what is b gt 1 Accsp Codes available in ACCSP as well as the translations from other coding systems ACCSPTEST Monday May 24 2010 11 18 53 AM EDT to ACCSP codes gt Commercial Landings Dealer Reports Non Confidential Commercial Landings by State Year and Species A guy d No Confidential Includes Atlantic Coast Landings Trends Table and Graph formats inio i eas aaa Commercial Landings amp Value by Month amp Summary Landings by Month and County for ACOE Non Confidential z pee CoWnty Non Confidential lanting Aom Commercial Dealer Reparts ACCSPTEST Thursday April 29 2010 11 57 30 AM ED Queries of Recreational catch and effort estimates based on MRIP data for P Recreational Estimates MIRIP 2004 to present Users can enter parameters species years etc foreach ACCSPTEST Tuesday April 03 2012 10 14 59 AM ED worksheet Screenshot 4 Codes Workbook and Worksheets Connect gt Connected to p Worksheet List Search Type in a search string to find a sp
28. ge enables you to select the parameter values Cancel Select Search To find the value select a filter in the drop down list and enter a word im the text field then click the go button To see a list of all values clear the search box and click the go button Search by Search for C Case Sensitive Results Available Selected BASS BANK SEA Art BASS LACK SEA Move All BASS LONGTAIL o PEPPERMINT Remove ROCK fe ROCK SEA v Remove All BASS ROUGHTONGUE Previous Next 25 Cancel Sele 5 HOW DO I SELECT PARAMETERS YEAR Click on the second flashlight found on Screenshot 6 Choosing Parameters page 12 to choose the landings year s for which you need data This will lead you to a new pop up that looked very similar to the species pop up see opposite page labeled Screenshot 9 Choosing Year Parameters This parameter is optional If you do not choose a year the query will default to all years You can use the Previous 25 and Next 25 buttons circled to move from through the years Our database goes back to 1950 As part of our example we ve highlighted the 2000 2012 If you click Move and then the Select button all 13 years will be chosen and displayed in the Landings Year field on the Parameters page see Screenshot 6 Choosing Parameters on page 12 for the initial view of this page with no parameters set Now that you h
29. heries WWW MTC State VAUS www ncfisheries net WWW ANT SC LOV www crd dnr state ga us WWW MY fWe com TABLE of CONTENTS TAMCOUCHON 2aa pendant steadi him akaes the aad os 1 Purpose Or iis Manta s6 cbeueues riria peida 2 About the ata bases oc s04csveearadeateacdewnead 3 Program Partner Implementation 4 Understanding Conhdentalty ivsscestsaesevaiss 3 PE A a AE aed 7 1 How do I access the Data Warehouse 2 How do I request an account I Jere Tie Ad spa dane hens denen eey aes 9 3 How do I navigate around the Data Warehouse 4 How do I query the data 5 How do I select parameters OP ter Alaeg dale BL eee ee eee ee eae ee eee 17 6 How can I change the display 7 How do I view more detailed data 8 How do I view less detailed data 9 How do I export files 10 How do I save files D Additonal Cats se rera e a a E eee PAi 11 Crosstab and Graph Options 12 Sharing your work 13 What do you think Prequently Asked Questions es rito seacgns nitra 30 Daa CAV CALS ee pce ag hs Sadek Go eee RS 34 List of Non confidential Woorkbooks and WOEKCHGC s E E eas bee ses a ony esas cae ees 36 Addio Materiales cata os obpuae adin easy a 37 Deor a POE reape a AR R E a 38 PCAC wWICAS CMC ine kari reiki rero Eidi 38 INTRODUCTION MISSION Produce dependable and timely marine fishery statistics for Atlantic coast fisheries that are collected processed and dis seminated according to comm
30. hot 18 Collapsing Data Up 100 Rows Down Rows 1 State Landed gt DE MD Pagelof2 Page Items Species BASS BLACKSEA Subregion Mid Atlantic Up 100Rows Down Rows 1 100 of 170 gt State gt MARYLAND State Landed DE MD PNJ PNY PVA gt State gt MARYLAND Live Lbs Value Live Lbs Value Year Month In Year gt 2000 139 643 209 753 139 643 209 753 gt 01 7 170 10 164 gt 02 7 170 10 164 ave PO gt 04 3 574 8 256 All HierarCKies gt P05 127 700 189 451 Drill to LEE j gt gt 06 gt 07 1 191 1 870 gt 04 3 574 3 256 a gt 05 127 700 189 451 gt 10 8 12 gt 06 gt 11 gt 12 gt 07 1 191 1 870 gt 2001 78 577 140 756 23 Atlantic Coastal Cooperative Statistics Program ACCSP 9 HOW DO I EXPORT FILES So far we have covered 1 how to query the data 2 ma nipulate the view 3 and drill to additional fields These skills enable you to produce a number of different tables The next step is to learn about what you can do once you have the table you want The most common task is to export your table Export is one of the items found in the Actions box circled on opposite page labeled Screenshshot 19 Export from Actions Menu Box in the upper left corner of the screen Click on the Export button in the Actions menu box The next window you will see is illustrated in Screen shot 20 Exporting File Formats This drop down menu is
31. l due to variations in historical reporting require ments and the differences between the actual weights pro vided by dealers and the estimated weights by fishermen RECREATIONAL DATA As of the publication of this document 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 Marine Recreational Information Program MRIP estima tion methodology released in February 2012 This includes both the public estimates and the advanced queries for bag limit analysis and directed trips BIOLOGICAL DATA Our database also incorporates biological data for some species To access these data you must submit a Custom Data Request Form which can be down loaded from Attp www acesp org Forms ACCS PCus tom_Data_Reguest_Form pdf See the Frequently Asked Questions section to learn more about submitting a custom data request DWUM Data Warehouse User Manual 4 PROGRAM PARTNER TIUPLEMENTATION It is important to remember that catch and effort data particularly useful if data are to be correctly interpreted from each program partner have been collected in accor As of January 2013 the commercial catch and effort dance with local needs and requirements and may differ data set is made up of data from all of the twenty three from other data sets for that reason partners in varying degrees of detail See the chart below for an illustration of
32. lashlight circled next to each field provides an easy way to enter the values you want Click on the flashlight next to the Select one or more species field Once you click on the flashlight to enter in your param eters a pop up box will appear on your screen DWUM Data Warehouse User Manual Screenshot 5 Example of Workbook and Worksheets connect gt Worksheet List Search Type im a search string to find a specific workbook or result set Use the drop down menu to choose between Database and Scheduled Workbooks Search ai Wertbooes vy Result List Expand All Collapse All Focus Name Y Discoverer Workbooks D gt ACCSP Codes V Commercial Landings Dealer Reports Non Confidential Atlantic Coast Landings Trends Graph LEELEE able Landings by State and Year Screenshot 6 Choosing Parameters Connect gt Workbooks gt Description Owner A listing of ACCSP standard codes for use as a reference to what is available in ACCSP as well as the translations from other coding ACCSPTEST Mon systems to ACCSP codes Non Confidential Commercial Landings by State Year and Species Includes Atlantic Coast Landings Trends Table and Graph formats ACCSPTEST Th Commercial Landings Dealer Reports Non Confidential L Last run Tuesday May 14 2013 2 32 02 PM EDT Species common name for which to display landings Worksheets Atlantic Coast Landings Parameters Neede
33. le and therefore cannot be supported by ACCSP Browsers must allow for pop ups from the ACCSP website when using the Data Warehouse Adobe Reader is required to view PDF and print worksheets The latest version of this program may be downloaded at hitp get adobe com reader ACKNOWLEDGEMENTS Images Page 2 19 Marine Photobank Page 3 South Carolina Department of Natural Re sources Page 9 Maine Department of Marine Resources Page 17 North Carolina Division of Marine Fisheries Page 13 Florida Fish and Wildlife Conservation Commission Page 21 Massachusetts Division of Marine Fisheries Page 27 Maine Department of Marine Resources ATLANTIC COASTAL COOPERATIVE STATISTICS PROGRAM 1050 N Highland Street Suite 200A N Arlington VA 22201 p 703 842 0780 f 703 842 0779 e info accsp org www dccsp org
34. ll Us More Take the Data Warehouse Exit Survey Screenshot 2a Ihe Public Data Warehouse Page Connect gt Worksheet List Search Type in a search string to find a specific workbook or result set Use the drop down menu to choose between Datab Search All Workbooks X Go Result List Refresh Expand All Collapse All Focus Name Y Discoverer Workbooks gt ACCSP Codes gt Commercial Landings Dealer Reports Non Confidential b gt Commercial Landings amp Value by Month amp County Non Confidential gt Recreational Estimates MRIP Description A listing of ACCSP standard codes for use as a re available in ACCSP as well as the translations fro systems to ACCSP codes Non Confidential Commercial Landings by State Includes Atlantic Coast Landings Trends Table Summary Landings by Month and County for A Non Confidential landings from Commercial De Queries of Recreational catch and effort estimate for 2004 to present Users can enter parameters each worksheet Screenshot 2b I he Login Data Warehouse Page Connect gt Enter connection details Enter your connection details below to connect directly to Oracle BI Discoverer Indicates required field Connect To Oracle BI Discoverer v User Name Password Database accsp world End User Layer discoverer_eul Locale ocale retrieved from browser v Copyright c 2000 2010 Oracle Corporation
35. n completion of reviewing the DWUM we hope you will be able to perform standard analytical functions and confidently explore Discoverer capa bilities on your own We intentionally left plenty of white space above and below the text on each of the pages in this manual for you to be able to write notes to yourself Please feel free to send comments and suggestions to info accsp org WHAT IS THE DATA WAREHOUSE The Data Warehouse is an online database popu lated with fisheries dependent data supplied by the program partners of the ACCSP The unique features of the Data Warehouse in clude 1 the ability to harmonize data recetved from program partners into one integrated set of codes for variables such as species gear and fishing area and 2 provides users with a flexible and intuitive interface to retrieve and download data About the DATABASE COMMERCIAL CATCH amp EFFORT DATA The commercial catch and effort module of the Data Warehouse is designed to capture and manage trip level commercial catch and effort data from program part ners Recent commercial catch and effort data in the Data Warehouse are derived from individual records of fishermen trips or dealer transactions See the chart on the opposite page for the most recent overview of com mercial catch and effort data Individual program partners have developed and imple mented ACCSP compliant data collections systems with local quality control procedures that send
36. ng 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 WHY DO I GET SO MANY ERRORS 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 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 supportWaccsp org Atlantic Coastal Cooperative Statistics Program ACCSP WHEN SHOULD I USE A CUSTOM DATA REQUEST If you have a unique question or cannot retrieve the data you desire from the Data Warehouse you can download a Custom Data Request From at hitp wm acesp org Forms ACCS PCustom_Data_Request_Form pdf A staff member from the Data Team will work with you to cre ate a custom data request WHAT DO I NEED TO KNOW TO SUBMIT A CUSTOM DATA REQUEST The Custom Data Request Form has a number of ques tions that can guide you through the details of a request The most important thing is to have a well defined ques tion 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 fi
37. ok You are the only person that can see or access this workbook Atlantic Coastal Cooperative Statistics Program ACCSP Screenshot 22 Actions Menu Box for Login Users Upper Left Hand Corner of Screen for All Actions Rerun query Save as Revert to saved Printable page Export Worksheet options Worksheets Atlantic Coast Landings Trends Graph Atlantic Coast Landings Trends Table Landings by State by Species Comparison to Confidential Totals Landings by State and Year DWUM Data Warehouse User Manual 26 Screenshot 23 Saving and Naming Tables Connect gt Workbooks gt Save Workbook As Choose a new name for this workbook Indicates required field Workbook Name MD Black Sea Bass Commercial Landings TIP The workbook will be saved in the root of the folder tree Preferences Exit Help Copyright c 2000 2010 Oracle Corporation All rights reserved About Oracle BI Discoverer Viewer Version 11 1 1 6 0 Oracle Technology Network Screenshot 24 Workbook Saved Ge itormation Commercial Landings Landings by State by Species Last run Tuesday June 04 2013 2 47 12 PM EDT Actions Landings by State by Species Rerun query Species Landed BASS BLACK SEA Landing Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Save Save as Revert to saved Printable page Export Worksheet options Select values for the following parame
38. om Shore Effort Estimates Atlantic Coastal Cooperative Statistics Program ACCSP ADDITIONAL MATERIALS The Data Warehouse User Manual is produced exclusively by the Atlantic Coastal Cooperative Sta tistics Program ACCSP It is instructive in nature and is intended only for users of the Data Warehouse Portions of this manual were excerpted from the following Oracle Discoverer Viewer publication Oracle Business Intelligence Discoverer Viewer Uset s Guide 11g Release 1 11 1 1 May 2009 Copyrighted Oracle Business Intelligence Discoverer User s Guide content is used with permission No citations have been made in order to preserve the continuity of this document Oracle JD Edwards PeopleSoft and Siebel are registered trademarks of Oracle Corporation and or its affiliates Users may wish to download the Oracle Discoverer Viewer Uset s Guide from Oracle s website at Attp www oracle com technology documentation discoverer html For more specific information on MRIP please see the MRIP website at Aitp wwm st nmfs gov st recre ational index html DWUM Data Warehouse User Manual usS ER SUPPORT For technical support you may call 703 842 0780 or email support accsp org during normal business hours 8 30 am 5 00 pm EST The Data Warehouse is compatible with Internet Explorer 11 and Mozilla Firefox 20 Internet Explorer 7 and 8 as well as Chrome plat forms are not supported by Orac
39. on standards agreed upon by all program partners Atlantic Coastal Cooperative Statistics Program ACCSP VISION To be the principal source of fisheries dependent information on the Atlantic coast through the cooperation of all program partners in the collection track ing and processing of common fisheries data and dissemination of the information for purposes of fisheries science and manage ment VALUES Accurate data are required for good fisheries management decisions Coordination and collaboration amongst the program partners are essential for success The Program must be responsive to the changing needs for fisheries data Processes must be open and transparent while confidential data is protected Data shall be accessible and easy to use Responsibilities should be matched with available resources DWUM Data Warehouse User Manual PuRPOSE of this MANUAL The purpose of this manual is to give you an op portunity to review the functions and capabilities of the Data Warehouse We intend for you to gain basic navigational and analysis skills by reading and following along with this self paced step by step Data Warehouse User Manual DWUM This manual will also provide some background into the software system we are currently using in the Data Warehouse Oracle Business Intelligence Viewer Discoverer software is the web based query analysis and reporting system that runs the Data Warehouse Upo
40. osstab yC rosstab Screenshot 15 Singe State Annual Landings Table Y Tools Layou isht Rows and Columns State Landed DE Above Measure Go More VY Tools Layout Format Stoplight Rows and Columns Move State Landed DE Above Measure Go More Move v Pagelofl l anaE mee Page lofl Page Items Species BASS BLACKSEA Subregion Mid Atlantic Tage LOr gt State Landed gt DE gt MD PNJ PNY PVA Page Items Species BASS BLACKSEA Subregion Mid Atlantic v aad uate gt State Landed gt DE MD gt NJ PNY PVA Live Los Value gt Year gt State gt MARYLAND gt 2000 139 643 209 753 LiveLbs Value gt 2001 78 577 140 756 gt 2002 196 786 316 716 139 643 209 753 gt 2003 192 035 354 037 78 577 140 756 2004 277 845 559 136 196 786 316 716 gt 2005 77 779 158 916 192035 354 037 gt 2006 43 104 117 502 sai terete gt 2007 28 140 85 383 gt 2008 50 526 149 558 i gt 2009 56 814 251 723 43 104 117 502 gt 2010 91 349 257 045 28 140 85 383 gt 2011 53 470 180 488 50 526 149 558 gt 2012 36 757 113 997 56 814 251 723 Year Total 1 322 825 2 895 009 91 349 257 045 1 322 825 2 895 009 Grand Total All Years 53 470 180 488 36 757 113 997 Year Total 1 322 825 2 895 009 Grand Total All Years 1 322 825 2 895 009 Screenshot 17 Sing e State Monthly Landings Table yCrosstab V Tools Layout Format Stoplight Rows and Columns Screens
41. rence to what is available in ACCSP as well as the transla This includes summary landings by month and county You will tions from other coding systems to ACCSP codes also find non confidential landings from commercial dealer reports Program Partners Landings amp Value by Year Month amp County States Landings amp Value by Year State amp County Counties Compatison to Confidential Totals Ports Areas Fished Recreational Estimates MRIP Species This includes queries of recreational catch and effort estimates Species Groups based on MRIP data Users can enter parameters species years Fishing Gears etc for each worksheet Dispositions Snapshot State Totals Distance From Shore Snapshot Species Group Totals Market Categories Snapshot Species Details Grade Categories Units of Measure Commercial Landings Dealer Reports Non Confidential This includes non confidential commercial landings by state year and species You will also fine Atlantic coast landings trends table and graph formats Atlantic Coast Landings Trends Graph Atlantic Coast Landings Trends Table Landings by State by Species Comparison to Confidential Totals Landings by State and Year Species Timeseries of Catch by State Table Species Timeseries of Catch by State Graph Species Percent of Catch by State Species Catch by Region and State Species Catch by Region amp State amp Mode Species Catch by Region amp State amp Distance Fr
42. rovided differently based upon partner You should query multiple fields to ensure complete information including fishing hours and soak time SPECIES Species should be chosen using the flashlight tool to the right of the parameter field since the queries find specific values Queries do allow the selection of more than one species Select the species you are interested in and then run the query Species do not have to be scientifically related by family They can be caught in the same gear or have the same ecological role 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 ERROR NOTIFICATION 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 supportaccsp org DWUM Data Warehouse User Manual 36 LIST of NON CONFZDVENTLIAL WORK BOOKS and WORKSHEETS ACCSP Codes Commercial Landings amp Value by Month amp This includes a listing of ACCSP standard codes for use as a County Non Confidential refe
43. s Screenshot 27 Crosstab left and Graph right Query 28 Page Items Species BASS BLACK SEA Subregion Mid Atlantic Page Items Species BASS BLACK SEA Subregion Mid Atlantic gt State Landed DE MD NJ PNY PVA 600K gt State gt MARYLAND LiveLbs Value Sane 500K gt 2000 139 643 209 753 gt 2001 78 577 140 756 00K WoE gt 2002 196 786 316 716 MD MARYLAND Live Lbs gt 2003 192 035 354 037 ey a AEA gt 2004 277 845 559 136 Hy gt 2005 77 779 158 916 mvs gt 2006 43 104 117 502 gt 2007 28 140 85 383 gt 2008 50 526 149 558 gt 2009 56 814 251 723 gt 2010 91 349 257 045 gt 2011 53 470 180 488 2012 36 757 113 997 Year Total 1 322 825 2 895 009 1 322 825 2 895 009 Grand Total All Years v 29 12 SHARING YOUR WORK If you think that all Data Warehouse users could benefit from your modified workbook email your workbook to support accsp org and request that your workbook features be incorporated into the standard workbooks available Please remember that ACCSP 1s only the stewards of the data Due to federal and state regulations that prohibit public disclosure of data that could lead to the identi fication of the contributing individual or individuals access to detailed data is limited to those users with confidential accounts Screenshot 32 Data Warehouse Exit Page Z ATLANTIC COASTAL COOPERATIVE STATISTICS PROGRAM 15 000 000 ae ae i 27 s
44. s displaying confidential data to which you have been granted access Non confidential data are summarized to abide by the rules of ACCSP acts as the on dentiality stewards of the data owned Those regulations laws and rules of the program partners pre by the program partners Therefore the confiden tality laws rules and vail when we release data This is why you will need to apply for access to the confi dential data through each program partner regulations of the program partner that collected the data apply and prevail to which you hope to review confidential data Each program partner is responsible for maintaining the confidentiality of the data they collect Program partners individually decide who has confidential access to those data The program partners identified confidential data in the Atlantic Coast Fisheries Data Collection Standards using the Rule of 3 for commercial catch and effort data The Rule of 3 is defined as any fisheries data that would identify a single fisheries entity Our policy for confidentiality requires that any data summary that is publicly disclosed must include landings from at least three dealers three harvesters and three vessels to be considered non confidential If confidential data are released ACCSP will immedi ately revoke data access and the security contacts of each program partner to which you have access will be notified Program partners will evaluate
45. s or partner year and species or year and species The most detailed average available is used DOLLARS The dollar values in the Data Warehouse are nominal You can use the Consumer Price Index CPI or Pro ducer Price Index PPI to convert to real values MONTHLY AND ANNUAL SUMMARIES 00 VALUES Depending upon the data source and year some data were 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 both 00 As reporting systems improve over time the amount of summarized data decreases However the 00 value can be found if the day or months are unknown or not reported REGIONS The two regions in the Data Warehouse are Northeast and Southeast The sub regions in the Northeast are North Atlantic and Mid Atlantic The sub regions in the Southeast are South Atlantic and Gulf of Mexico Florida landings fall into both Southeast sub regions If you would like Florida Atlantic or Florida Gulf Coast landings you should include the sub region level to sepa rate these landings Atlantic Coastal Cooperative Statistics Program ACCSP AREA CODES DEALER REPORTS Caution should be used when querying Dealer Reports by area This field is often not reported A query by a specific area may produce results that do not include all actual reported landings HOURS FISHED FISHERMEN TRIPS The hours fished information is p
46. shery can refer to harvest of a particular species with a specific gear ot 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 ate submitting a custom data request DWUM Data Warehouse User Manual DATA CAVEATS QUALITY ASSURANCE AND QUALITY CHECKS QA QC In addition to the error checking and QA QC done by the Data Team staff the data are checked at the partner level An annual review of commercial data takes place at the Commercial Technical Committee meeting each spring Recreational data are reviewed internally at NOAA Fish eries before they are provided to ACCSP REPORTED QUANTITY LANDED POUNDS AND LIVE POUNDS Reported quantity refers to what was landed and re ported 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 re ported 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 po
47. tate regulations that prohibit public disclosure of data that could lead to the identifica tion 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 HOW DO I ADJUST MY BROWSER TO WORK WITH THE DATA WAREHOUSE The Data Warehouse has been tested using Internet Explorer 11 and Mozilla Firefox 20 Internet Explorer 7 and 8 are not yet supported by Oracle Discoverer WHAT IS THE BEST TIME TO LOGIN The Data Warehouse is available at the same level of accessibility 24 hours a day and 7 days a week with the exception of scheduled back ups beginning Friday eve ning at 10 00 pm until Saturday morning at 3 00 am If you experience a variation in speed it may be due to your internet service provider Atlantic Coastal Cooperative Statistics Program ACCSP WHAT IS THE DIFFERENCE BETWEEN REPORTED QUANTITY LANDED POUNDS AND LIVE POUNDS Reported quantity refers to what was landed and re ported 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 ex
48. ters Indicates required field Select one or more BASS BLACK SEA L Atlantic Coast Landings Species Trends Graph Species common name for which to display landings Atlantic Coast Landings Select one or more Trends Table Landings Year s 2000 2001 2002 2003 2004 2 aS Landings by State by Species OPTIONAL Comparison to Confidential Year the landing was unloaded No selection ALL YEARS Totals Go Landin S b State and Year rE E E EEEE EEE ETE EEEE EEEE ee ee EL eee a a eee eee y Parameters Worksheets Screenshot 25 List of Available Workbooks Focus Name Description Y Discoverer Workbooks A listing of ACCSP standard codes for use as a reference to what is gt ACCSP Codes available in ACCSP as well as the translations from other coding systems to ACCSP codes gt Commercial Landings Dealer Reports Non Confidential Commercial Landings by State Year and Species Non Confidential Includes Atlantic Coast Landings Trends Table and Graph formats gt Commercial Landings amp Value by Month amp Summary Landings by Month and County for ACOE County Non Confidential Non Confidential landings from Commercial Dealer Reports on Confidential Commercial Landings by State Year and Species udes Atlantic Coast Landings Trends Table and Graph formats Queries of Recreational catch and effort estimates based on MRIP gt MD Black Sea Bass Commercial Landings
49. to the Login Data Warehouse page see opposite page labeled Screenshot 2b The Login Data Warehouse Page all of the fields except for your username and password will automatically be filled in for you These other fields include Connect To Database End User Layer and Locale The Login Data Warehouse re quires a username and password The information in the Login Data Warehouse is non confidential and confiden tial data depending on your level of access The benefit to a login for the Data Warehouse is that once you have an account you have the ability to save workbooks and queries and can return to them time and time again Once you have entered your username and password see arrow click the Go button circled Remember not to hit the enter key as it will give you an error message Atlantic Coastal Cooperative Statistics Program ACCSP 2 HOW DO I REQUEST AN ACCOUNT You can apply for non confidential or confidential data access directly from the ACCSP website From our home page www accsp org you will want to scroll over the Data Center menu item and click on the Data Warehouse On the right side bar you will see options titled Sze Up for a Non confidential Account Here and Sten Up for a Confidential Account Here A non confidential account is usually granted access within 48 business hours Confidential access takes a little longer to grant permission Remember each agency has its own confidenti
50. to your needs and 3 drill down creating a query with a unique level of detail for Atlantic coast fisheries How do you access the data in the Data Warehouse You can access the data in the Data Warehouse 1 publicly or 2 with a login Both ways provide you the ability to access valuable fishery dependent data from all of our partners along the Atlantic coast Public Login Data Warehouse Data Warehouse The Public Data Warehouse does not require a username and password like the Login Data Warehouse The information in the Public Data Warehouse is non confidential data Queries that you may use within the Public Data Warehouse may not be saved However you can export or The Login Data Warehouse requires a username and password To access this Login Data Warehouse you must apply for a non confidential or confidential account through ACCSP The information in the Login Data Warehouse is non confidential and confidential data depending on your level of ACCSP Home ai 20 if PENGA cm FONN er OE eee d Document Archives SS Contact Us Data Center MORE INFORMATION Sian Up for a Non confidential Account Here Sign Up for Confidental Account Here Status of Available Data Data Warehouse User Manual Atlantic Coast Fisheries Data Collection Standards FAQs for the Data Warehouse User Data Warehouse Caveats Understandin Confidentiali Fisheries of the US Metadata Directory Te
51. unds of live weight Shellfish are the exception and are converted to meat weights in this column DEALER REPORTS VS FISHERMEN TRIPS Dealer reports have true weights market and grade categories and price information but are generally not required to have detailed fishing area and gear informa tion Dealer reports are more complete for total land ings 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 infor mation 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 CONVERSIONS The unit of measure grade and market categories that are reported vary greatly by fishermen or dealer If land ed pounds live pounds and pounds are not also reported the ACCSP will populate these fields using standard conversion factors The primary conversion factor is the one associated with the Program Partner supplying the data If a partner has not provided a conversion factor for the species unit of measure market and grade category combination then the NOAA Fisheries conversion factor for this combina tion will be used PRICE DATA If price data have not been provided by the partner they are calculated based on averages by partner month and specie

User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents