1916
Commercial Landings Data monthly summaries (Dealers)
Monthly general canvass landings statistics
Data Set
Published / External
1905
Accumulative Landings System (ALS)
Project
In Work
This data set contains pounds and value for all seafood products that are landed and sold by established seafood dealers and brokers in the SE Region of the US mainland. In the US Caribbean, the landings are reported by permitted fishers. These types of data, referred to as the general canvass landings statistics, have been collected by the NOAA Fisheries Service, National Marine Fisheries Service and its predecessor agency, the Bureau of Commercial Fisheries. These data are available on computer since the mid 1920s. The quantities and values that are reported in this data set include monthly landings that were initiated in 1972. Between 1926 and 1971, data were collected annually and not monthly. Mixed annual and monthly data occur from 1972-1976 according to State and year. The general canvass landings include quantities and value for all commercially caught marine species and are identified by species or species group. These data are collected from or reported by every seafood dealer or broker that is licensed by each state in the Southeast Region (North Carolina through Texas). In addition, information on the gear and area of capture is available for most of the landings statistics in the data set except for Florida 1977-1996 and Louisiana 1992-1999. However, because these data are summaries, they do not contain information on the quantities of fishing effort or identifications of the fishermen or vessels that caught the fish or shellfish. In early years, these data were collected by field agents employed by the Southeast Fisheries Science Center and assigned to local fishing ports. These individuals would canvass the seafood dealers and record the quantity and value for each species or species category from the sales receipts maintained by the seafood dealers. Based on their detailed knowledge of the fishing activity in the area, the agents would estimate the type of fishing gear and area where the fishing was likely to have occurred. It should be noted that landings by gear and water body (fishing area) does not reside in the monthly landings data set for Florida for the years, 1977-1995, Louisiana 1990-1999, and Texas (for gear) from 1993 to present (this is subject to change for years 2008 and more recent). Annual landings by gear, water body and distance from shore are available in the Annual General Canvass data for Florida. More detailed information on the caveats associated with these data is provided in the Issues section. In more recent years, the states in the Southeast Region began to implement trip ticket programs that required the licensed seafood dealer/brokers to report the landings of all seafood products. A trip ticket program was initiated in Florida in 1985, in North Carolina in 1994, in Louisiana in 1999, in Alabama in 2000, and in Texas in 2007. In addition to the quantities of these landings, the states require dealers to report the price, the type of gear and the fishing area for each trip. Through cooperative agreements with each of the states, monthly summaries of the states trip ticket programs are provided to the Southeast Fisheries Science Center (SEFSC) and are included in the general canvass landings data set. In addition, summarized data are extracted from the NOAA-SEFSC Gulf Shrimp System for commercial landings of shrimp species that are landed at port in the coastal area of the Gulf of Mexico.
One of the original purposes for these data was to provide estimates of the quantities and value of the marine commercial fishing industries throughout the United States as part of the gross national product for the nation. As the fishing industry continued to grow, the importance of this time series became obvious as a method to monitor the trends in commercial fishing activity. Although the initial methods of collecting the general canvass statistics have been replaced with the states trip ticket programs, monthly summaries from the states programs are provided to the Southeast Fisheries Science Center in order to maintain the time series established by the general canvass data set.
Monthly summaries compiled by port agents from dealer reports
**The ALS.ALS_LANDINGS table may soon be combined with the tables from prior years so one table will have complete data from 1962-present.** The ALS.ALS_LANDINGS table contains data from GA,SC,and NC from 1972-present. Data from FL,AL,MS,LA,TX and the Gulf Shrimp System are present from 1977-present. Data from the South Atlantic Shrimp system are present for 1978-present (since 2001 only SC shrimp data are supplied through the SASS). These are fishery dependent data reported by industry. Please see 'Issues' for other notes and caveats.
Theme
commercial fisheries
Theme
fish
Theme
fishdep
Theme
fishery-dependent
Theme
seafood
Theme
seafood landings
Temporal
1962-present
Spatial
Gulf of Mexico
Spatial
Southeast United States Coast
Spatial
U.S. Southern Atlantic Coast
Stratum
distance from shore
Stratum
gear
Stratum
species
Stratum
waterbody
Southeast Fisheries Science Center
Miami
FL
USA
Location Of The Main Office Of The South East Fisheries Science Center
Data Set
Database
Monthly
Table (digital)
Data set contains information on year, month, state of landing, county of landing, dealer code (confidential), catch area or "waterbody" (exceptions noted in ISSUES), gear (exceptions in ISSUES), species, pounds(whole weight)**oysters and clams are pounds (meat)**, ex-vessel value (paid to the fishing vessel), price, distance from shore (exceptions noted in issues).
als_landings_describe.doc
5450
Table: ALS_LANDINGS
ALS_LANDINGS
Published / External
Completed
SEFSC.ALS_LANDINGS is the primary tableof the ALS systems.It contains the information on each of the landings records.
Data Table
Yes
ALS
SEFSC.ALS_LANDINGS is the primary tableof the ALS systems.It contains the information on each of the landings records.
1
MONTHLAND
VARCHAR2
2
No
No
Active
Two character month that the data was landed. Some historical data contains a '13' in the monthland field. This represents annual data.
VARCHAR2
2
YEARLAND
VARCHAR2
4
No
No
Active
Four digit year that the catch was landed.
VARCHAR2
3
ALSSTATE
VARCHAR2
2
No
No
Active
Two character NMFS State Code for the state of landing.
VARCHAR2
4
ALSCTYIN
VARCHAR2
3
No
No
Active
Three character NMFS County Code. This is simply the nmfscounty zero-padded to 3 characters instead of 2. It exists for reasons of extract formatting only. One day it may be used to expand the NMFS county code system.
VARCHAR2
5
NMFSCOUNTY
VARCHAR2
2
No
No
Active
2 chararacter NMFS County Code.
VARCHAR2
6
DEALER
VARCHAR2
9
No
No
Active
The Dealer Code. The ALS data do NOT show dealer codes for the following years and states:
• Alabama non-shrimp 1962-1978
• Alabama shrimp 1962-1973,1975,1979
• Georgia non-shrimp 1962-1979
• Florida non-shrimp 1962-1976
• Florida out-of-state (alsstate =’00’) 1998-2000
• Louisiana non-shrimp 1962-1978
• Mississippi non-shrimp 1962-1978
• Mississippi shrimp 1962-1973, 1975
• North Carolina non-shrimp 1962-1979
• South Carolina non-shrimp 1962-1979
• Texas non-shrimp 1962-1977, 1980-1988
The lookup table for the dealer codes is ALS.DEALER_CODE_ALS, valid from 1977 to 2013. It is then replaced by the Dealer Management System.
VARCHAR2
Yearland, whichone, alsstate, nmfscounty, dealer to ALS.DEALER_CODE_ALS.
7
WATERBODY
VARCHAR2
4
No
No
Active
Water Body Code. The water body (catch area) codes underwent significant changes in 2001. Previous state-dependent codes were replaced by US South Atlantic shrimp coding system and the Gulf of Mexico shrimp system codes. This created a unified water code system where the water codes were independent of the state and were unique within the SE Region.
VARCHAR2
8
NMFSGEAR
VARCHAR2
3
No
No
Active
NMFS Gear Code. This code is currently not not available for Texas non-shrimp data from 1993-2014. Florida non-shrimp monthly landings data do not have gear codes from 1986-1996; rather, the gear information, as well as water body (area fished), and distance data are in the annual Florida canvass table. Louisiana non-shrimp gear data are not available for the predominance of records from 1990-1999.
VARCHAR2
9
NMFS_CODE
VARCHAR2
4
No
No
Active
NMFS Species Code.
VARCHAR2
10
SHELLFIN
VARCHAR2
1
No
No
Active
Shellfin Code.
VARCHAR2
11
POUNDS
NUMBER
22
No
No
9
0
Active
These are round(whole) pounds except for FL from 1985 and prior which are as landed and molluscan shellfish which are POUNDS MEAT.
NUMBER
12
VALUE
NUMBER
22
No
No
9
0
Active
Value in dollars of the fish that was caught. In early 1998, it was discovered that FL prices were being mistakenly attached to the round (live) weight in pounds of catch. Data were corrected so that price would attach to the landed pounds. Major changes in value (decrease) resulted from this edit.
NUMBER
13
SECTION
VARCHAR2
1
No
No
Active
Section Code. There is not always meaningful data in this field.
– Code for portion of state catch landed in (ie. south,north,middle for NC). Except for details mentioned here, codes were filled with spaces, nulls, or ‘0’.
• North Carolina – from 1972 - still in use
• South Carolina – from 1972 - year 2000
• Georgia – from 1972 - year 2000
• Florida – Filled with REGION data (4 for SATL and 5 for GULF) 1972-1976. None since 1976. Place-holder data of ‘1’ in use since 1977.
• Alabama – occasional apparent typo entry 1979-1984. Filled with REGION data (5 for GULF) from 1984-1996. Place-holder data of ‘1’ since 1997.
• Mississippi – occasional apparent typo entry in 1983-86 and 1992. Placeholder data of ‘1’ from 1997-2015.
• Louisiana – from 1972-1989. Very spotty from 1990-1993. None since 1993.
• Louisiana Menhaden – (Whichone = ‘MN’) from 1994-1997.
• Texas – REGION code of 5 in 1977. None otherwise.
• Gulf Shrimp (Whichone = ‘GS’) None.
• North Carolina South Atlantic Shrimp (whichone =’SA’) – from 1978-1992.
• South Carolina South Atlantic Shrimp (whichone=’SA’) – from 1978-2000.
• Georgia South Atlantic Shrimp (whichone = ‘SA’) – from 1979-2000.
• Florida South Atlantic Shrimp (whichone =’SA’) – none
VARCHAR2
14
PRICE
NUMBER
22
No
No
7
3
Active
Average price per pound. The decimal point in this field is now real and is no longer implied.
NUMBER
15
DISTANCE
VARCHAR2
1
No
No
Active
The Distance From Shore Code. The perpendicular distance zone from the fishing grounds to the shoreline. Recently (2016) the states of Louisiana, Alabama, and Mississippi all extended their jurisdiction to 9 miles from shore to match those already established by Florida and Texas. Coding in this field is inconsistent.
• North Carolina – some apparent typos in 1964, in use from 1972-present. South Atlantic Shrimp has distance from 1978-1992.
• South Carolina – some apparent typos in 1964 and 1970. In use from 1972 – present. South Atlantic Shrimp have distance data from 1979-2000.
• Georgia – some apparent typos in 1964. In use from 1972 – present. South Atlantic shrimp have distance from 1978-2000.
• Florida – In Florida annual canvass data 1976-1996. In Florida South Atlantic shrimp from 1981-1992. No distance data after 1996.
• Alabama – some apparent typos in 1964. In use from 1973-2001.
• Mississippi – In use from 1973-2015
• Louisiana – In use from 1973-1993. Louisiana Menhaden (MN) from 1995-1997.
• Texas – From 1972-1977 and from 1984-1992.
• Gulf Shrimp (whichone=’GS’) None.
VARCHAR2
16
STATECAUGHT
VARCHAR2
2
No
No
Active
State that that fish was landed. There is not always meaningful data in this field. When a value of "00" is in this field, it means nothing, not anything else.
VARCHAR2
17
HOWFIGURED
VARCHAR2
2
No
No
Active
Indicates how the price was determined for historical Florida data. Prices were not always available for every record in the Florida data. Some prices needed to be calculated from the rest of the data. There were various levels of the price calculation. The coding proceeds in sequence from 05 to 40 for more to less precise. The records with null howfigured fields did not require price calculation. Howfigured = '05' means that a weighted average price was calculated for the same dealer, species, year and month. '10' means price calculated from species, state, county, year,and month. '20' referes to species, state, year, and month. '30' refers to species, state, and year. '40' means by species and year. This column contains some codes in addition to '05','10','20','30','40' which have no apparent meaning. Valid coding appears to exist from 1988 until 1996.
VARCHAR2
18
WHICHONE
VARCHAR2
2
No
No
Active
Gives the source of the data in alpha coding. Alpha codes are state abbreviations for the submitting partner except in the case of 'GS' (Gulf Shrimp System), 'SA' (South Atlantic Shrimp System), 'MN' (NMFS Menhaden data from Beaufort).
VARCHAR2
19
TXSTATE
VARCHAR2
2
No
No
Active
TPWD (Texas) State Code. Coding is intermittent. The code submitted by TPWD is 43. The ALS state code for Texas is 46. Recent years are coded as 46. Many years have null fields. This column basically is not used at all.
VARCHAR2
20
TXCOUNTY
NUMBER
22
No
No
3
0
Active
TPWD (Texas) County Code. This code is extremely useful as it allows the location of purchase to be recorded as opposed to the arbitrary coastal landing county assigned. Currently the NMFS county coding is being expanded to at least reflect all counties in East Texas.
NUMBER
21
TXWATER
VARCHAR2
3
No
No
Active
TPWD (Texas) Water Body Code. This 2 digit code matches up with the NMFS gulf grid system. It exists either by itself, or with a decimal attached indicating the Bay or Inshore area within the grid. These codes are referenced to the GSS sytem of coding (water body in als)by the table ALS.als_waterbody_old_new_xref. The Texas water body coding (including the bay code) is present in this column from 1993 through 2013.
VARCHAR2
22
TXBAY
VARCHAR2
2
No
No
Active
TPWD (Texas) Bay Code. It is represented by a decimal digit at the end of the TXWATER code. Code provides finer detail on inshore and Bay coding which is translated into the ALS Waterbody code.
VARCHAR2
23
TXSPECIES
NUMBER
22
No
No
5
0
Active
TPWD (Texas) Species Code. This is the species code generated by TPWD. It is cross-referenced to the NMFS species codes by the table ALS.species_code_texas. The coding is upto 5 digits and has more versatiity than the NMFS system.
NUMBER
24
LACOUNTY
VARCHAR2
2
No
No
Active
LDWF (Louisiana) county (parish) codes. These are 2 digit codes provided by the State of Louisiana. They are cross-referenced to the NMFS county code by the table sefsc.county_code_nmfs table.
VARCHAR2
25
LACONDITION
VARCHAR2
1
No
No
Active
Condition code for Louisiana landings. Described in SEFSC.condition_code_louisiana table. Also used for Alabama landings 1994 and more recent.
VARCHAR2
26
FDEP_COAST
VARCHAR2
1
No
No
Active
FDEP Coast Code. (Florida Data). This column is empty but it could be filled by cross-referencing existing county data. Do not recommend we drop it at this time.
VARCHAR2
27
FDEPCTY
VARCHAR2
2
No
No
Active
The County Code on data that comes from FDEP. (Florida Data). It is cross-referenced to the NMFS county code in the table sefsc.county_code_nmfs
VARCHAR2
28
FDEP_CODE
VARCHAR2
3
No
No
Active
FDEP Species Code. (Florida). This is the more detailed species code from the Florida Trip Ticket system (FTT). It contains some condition of catch information and also some units of measure for certain species. Recently the NMFS coding has been appended to include tropical aquarium species from FL.
VARCHAR2
29
FDEP_TRIPS
NUMBER
22
No
No
6
0
Active
Number of trips made. It was included in the historically formatted summary batch data provided by the FDEP up until 1997. The years data are present range from 1992-1996.
NUMBER
30
INSHORE
VARCHAR2
1
No
No
Active
Inshore code. (Y/N) Indicates if catch area is inshore. Present in 1994-2001 for Alabama, 1994-2005 for Mississippi, and 2000-date for Louisiana.
VARCHAR2
31
BLANK_1
VARCHAR2
1
No
No
Active
A filler field.
VARCHAR2
32
BATCHNUM
VARCHAR2
6
No
No
Active
Batch Number for data that comes from Florida. In data from 1991-date.
VARCHAR2
33
BLANK_2
VARCHAR2
1
No
No
Active
A filler field
VARCHAR2
34
CONVERSION
NUMBER
22
No
No
9
5
Active
For Records that come from Florida, this is the conversion factor used to convert the landing weight provided by Florida to Whole pounds. Present from 1991 to date. Some assumptions are made regarding the condition of the landed species. Most food finfish are presumed to be landed as gutted. Large pelagic fish such as swordfish, shark, and tuna are presumed to be landed as logs or tubes. Some fish are landed in numbers and converted to live pounds. The conversion factor is determined accordingly.
NUMBER
35
VAL_VAL
NUMBER
22
No
No
13
2
Active
Summed ex-vessel value for trips with a reported price for a species. (FDEP Data)
NUMBER
36
VAL_LBS
NUMBER
22
No
No
9
0
Active
Summed pounds for which price was reported for a species. (FDEP Data)
NUMBER
37
VAL_TRIPS
NUMBER
22
No
No
6
0
Active
Number of trips which reported prices for a species. (FDEP Data)
NUMBER
38
FL_COMMON
VARCHAR2
45
No
No
Active
Florida Common Name of the Species landed. It is used only for Florida data. It is filled by referencing the fdep_code_tripticket field of the FTT data for data from 1997 to 2013. For 1992-1996 it was filled by referencing the more general 'fdep_code'.
VARCHAR2
39
SUBGROUP
VARCHAR2
1
No
No
Active
Subgroup. Only for Florida and only for 1992-1996 (although column can be easily filled from the fdep_code_tripticket column for all recent years). It is entered in the data that arrives from FDEP. Indicates the general fishery type. '1' is for food finfish, '2' is for invertebrate non-shrimp species (not including aquarium species), '3' is for food shrimp species, '4' is for bait shrimp, '5' is for marine aquarium species (up until now not included in ALS but will be very soon).
VARCHAR2
40
FLEDIT
VARCHAR2
1
No
No
Active
Used for Florida data only. It may be "Y" for Edited data, or "N" for unedited data. Only present for years 1992-1996 although all batches currently show as edited.
VARCHAR2
41
PRINTSEQ
VARCHAR2
3
No
No
Active
For Florida years 1992-1996. Print Sequence for the species. Presents the species in print order by species and groups (ie, AMBERJACKS = 1, BAITFISH = 2, BALLYHOO = 3, ETC.).
VARCHAR2
42
UNFACTORED_WEIGHT_FDEP
NUMBER
22
No
No
9
0
Active
For Florida data. More appropriately titled 'UNFACTORED_QUANTITY' as column includes numbers of individuals landed for some species codes and pounds landed for others. A conversion (see 'CONVERSION' field description) is applied to this quantity to obtain pounds whole (aka round or live). Meat pounds are obtained for molluscan bivalve shellfish. Some assumptions are made regarding the condition of the landed species. Most food finfish are presumed to be landed as gutted. Large pelagic fish such as swordfish, shark, and tuna are presumed to be landed as logs or tubes. The conversion factor is determined accordingly.
NUMBER
43
FDEP_CODE_TRIPTICKET
VARCHAR2
3
No
No
Active
The species code entered onto the trip ticket. In addition to indicating the species, this code sometimes indicates condition of landing and/or units landed. The unfactored_weight_fdep and conversion fields reflects the quantity for the fdep_code_tripticket.
VARCHAR2
44
USERID
VARCHAR2
30
No
No
Active
Oracle Id Of The Person Loading The Data
VARCHAR2
45
SOURCE_FILE
VARCHAR2
50
No
No
Active
Source File used to load data. Recorded in the ALS.ALS_LANDINGS table for the following states and years: AL 2001-2016, FL 2014-2016, GS (Gulf Shrimp Data) 2000-2016, LA 2000-2016, MS 2002-2016, NC 1994-2016, TX 1994-1998 and 2001-2016. For records where source_file was not recorded in the ALS_LANDINGS table see the table ALS.ALS_LOAD_HISTORY. This table has information for other years and states: AL 1996-2017, FL 1995-2014,
GA 1995-2001, GS 1995-2017, LA 1995-2016, MN (Menhaden) 1995-2006,
MS 1995-2016, NC 1995-2016, PR (Puerto RIco) 1995-2016,
SA (South Atlantic Shrimp) 1995-2006, SC 1995-2010, and TX 1996-2016.
VARCHAR2
46
GSS_PORT
NUMBER
22
No
No
2
0
Active
For Records that originated in te gulf shrimp system, this is the port code from the GSS System
NUMBER
47
LOAD_DATE
DATE
7
No
No
Active
Date/Time Stamp of when record was loaded
DATE
48
OLD_WATERBODY
VARCHAR2
4
No
No
Active
Water Body code that had been on record before water body change project
VARCHAR2
49
REGION
VARCHAR2
2
No
No
Active
Region COde
VARCHAR2
50
LAST_CHANGE_DATE
DATE
7
No
No
Active
Date/Time Stamp of When Record Was Last changed
DATE
51
LAST_CHANGE_USERID
VARCHAR2
30
No
No
Active
Oracle Id Of The Person Loading The Data
VARCHAR2
52
OLD_DEALER
VARCHAR2
9
No
No
Active
The Dealer Code.
VARCHAR2
5451
Table: ALS_TEMP_LAND
ALS_TEMP_LAND
Published / External
Completed
Pre-validation Table to load Accumulative Landings Data
Loaded by batch 1726, 10-16-2007 08:22
Data Table
Yes
ALS
Pre-validation Table to load Accumulative Landings Data
1
UNIXID
VARCHAR2
8
No
No
Active
Id of the person loading data
VARCHAR2
2
RNUMBER
NUMBER
22
No
No
7
0
Active
Which Record Number In the data file that is loaded.
NUMBER
3
MONTHLAND
VARCHAR2
2
No
No
Active
Two character month that the data was landed.
VARCHAR2
4
YEARLAND
VARCHAR2
4
No
No
Active
Four digit year that the fish was landed.
VARCHAR2
5
ALSSTATE
VARCHAR2
2
No
No
Active
Two character NMFS State Code.
VARCHAR2
6
ALSCTYIN
VARCHAR2
3
No
No
Active
Three character NMFS County Code.
VARCHAR2
7
NMFSCOUNTY
VARCHAR2
2
No
No
Active
2 chararacter NMFS County Code.
VARCHAR2
8
DEALER
VARCHAR2
9
No
No
Active
The Dealer Code.
VARCHAR2
9
NMFSGEAR
VARCHAR2
3
No
No
Active
NMFS Gear Code.
VARCHAR2
10
NMFS_CODE
VARCHAR2
4
No
No
Active
NMFS Species Code.
VARCHAR2
11
SHELLFIN
VARCHAR2
1
No
No
Active
Shellfin Code.
VARCHAR2
12
POUNDS
NUMBER
22
No
No
9
0
Active
Weight (pounds) of the fish landed . (WHole Weight, heads on for shrimp is the ALS standard.)
NUMBER
13
VALUE
NUMBER
22
No
No
9
0
Active
Value in dollars of the fish that was caught.
NUMBER
14
SECTION
VARCHAR2
1
No
No
Active
Section Code. There is not always meaningful data in this field.
VARCHAR2
15
PRICE
NUMBER
22
No
No
7
3
Active
Average price per pound. The decimal point in this field is now real and is no longer implied.
NUMBER
16
DISTANCE
VARCHAR2
1
No
No
Active
The Distance From Shore Code.
VARCHAR2
17
STATECAUGHT
VARCHAR2
2
No
No
Active
State that that fish was landed. There is not always meaningful data in this field. When a value of "00" is in this field, it means nothing, not anything else.
VARCHAR2
18
HOWFIGURED
VARCHAR2
2
No
No
Active
Indicates how the price was determined for historical Florida data.
VARCHAR2
19
WHICHONE
VARCHAR2
2
No
No
Active
Gives the source of the data.
VARCHAR2
20
TXSTATE
VARCHAR2
2
No
No
Active
TPWD (Texas) State Code.
VARCHAR2
21
TXCOUNTY
NUMBER
22
No
No
3
0
Active
TPWD (Texas) County Code.
NUMBER
22
TXWATER
VARCHAR2
3
No
No
Active
TPWD (Texas) Water Body Code.
VARCHAR2
23
TXBAY
VARCHAR2
2
No
No
Active
TPWD (Texas) Bay Code.
VARCHAR2
24
TXSPECIES
NUMBER
22
No
No
5
0
Active
TPWD (Texas) Species Code.
NUMBER
25
LACOUNTY
VARCHAR2
2
No
No
Active
LDWF (Louisiana) county codes.
VARCHAR2
26
LACONDITION
VARCHAR2
1
No
No
Active
Condition code for Louisiana data.
VARCHAR2
27
FDEP_COAST
VARCHAR2
1
No
No
Active
FDEP Coast Code. (Florida Data)
VARCHAR2
28
FDEPCTY
VARCHAR2
2
No
No
Active
The County Code on data that comes from FDEP. (Florida Data)
VARCHAR2
29
FDEP_CODE
VARCHAR2
3
No
No
Active
FDEP Species Code. (Florida)
VARCHAR2
30
FDEP_TRIPS
NUMBER
22
No
No
6
0
Active
Number of trips made. It is entered on data that comes from FDEP.
NUMBER
31
INSHORE
VARCHAR2
1
No
No
Active
Inshore code.
VARCHAR2
32
BLANK_1
VARCHAR2
1
No
No
Active
A filler field.
VARCHAR2
33
BATCHNUM
VARCHAR2
6
No
No
Active
Batch Number for data that comes from Florida.
VARCHAR2
34
BLANK_2
VARCHAR2
1
No
No
Active
A filler field
VARCHAR2
35
CONVERSION
NUMBER
22
No
No
9
5
Active
For Records that come from Florida, this is the conversion factor used to convert the landing weight provided by Florida to Whole pounds.
NUMBER
36
VAL_VAL
NUMBER
22
No
No
13
2
Active
Summed ex-vessel value for trips with a reported price for a species. (FDEP Data)
NUMBER
37
VAL_LBS
NUMBER
22
No
No
9
0
Active
Summed pounds for which price was reported for a species. (FDEP Data)
NUMBER
38
VAL_TRIPS
NUMBER
22
No
No
6
0
Active
Number of trips which reported prices for a species. (FDEP Data)
NUMBER
39
FL_COMMON
VARCHAR2
45
No
No
Active
Florida Common Name of the Species landed. It is used only for Florida data.
VARCHAR2
40
SUBGROUP
VARCHAR2
1
No
No
Active
Subgroup. It is entered in the data that arrives from FDEP.
VARCHAR2
41
FLEDIT
VARCHAR2
1
No
No
Active
Used for Florida data only. It may be "Y" for Editted data, or "N" for uneditted data.
VARCHAR2
42
PRINTSEQ
VARCHAR2
3
No
No
Active
Print Sequence
VARCHAR2
43
UNFACTORED_WEIGHT_FDEP
NUMBER
22
No
No
9
0
Active
Unfactore Weight From Florida
NUMBER
44
FDEP_CODE_TRIPTICKET
VARCHAR2
3
No
No
Active
FDEP Code On The Trup Ticket
VARCHAR2
45
SOURCE_FILE
VARCHAR2
50
No
No
Active
Source File used to load data.
VARCHAR2
46
WATERBODY
VARCHAR2
4
No
No
Active
Water Body Code.
VARCHAR2
47
OLD_WATERBODY
VARCHAR2
4
No
No
Active
Water Body code that had been on record before water body change project
VARCHAR2
48
REGION
VARCHAR2
2
No
No
Active
Region Code
VARCHAR2
Data Steward
2010
Person
Chau, Jade
jade.chau@noaa.gov
263 13th Avenue South Room 201
St Petersburg
FL
33701
727-824-5373
8:00 AM - 4:30 PM EST/EDT
Contact by email preferred.
Data Steward
2006-06-30
2018
Person
Turner, Steve C
Distributor
1962
Organization
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center
About SEFSC
Online Resource
8:00 a.m. - 4:30 p.m. EST
Contact by email preferred.
Metadata Contact
2014
Person
Chau, Jade
jade.chau@noaa.gov
263 13th Avenue South Room 201
St Petersburg
FL
33701
727-824-5373
8:00 AM - 4:30 PM EST/EDT
Contact by email preferred.
Metadata Contact
1992
2017
Person
Bennett, Joshua
Point of Contact
2014
Person
Judge, Michael
Michael.Judge@noaa.gov
75 Virginia Beach Drive
Miami
FL
33149
305-361-4235
305-361-4562
Contact by email preferred.
Point of Contact
2006-06-30
Person
Gloeckner, David
David.Gloeckner@noaa.gov
75 Virginia Beach Drive
Miami
FL
33139
305-361-4257
305-361-4460
Call (252)728-8721 or
EMail david.gloeckner@noaa.gov
Point of Contact
2006-06-30
2017
Person
Bennett, Joshua
-98
-72
37
24
The Southern US Atlantic coastal waters from North Carolina to the Florida Keys (Monroe County) out to 200 nautical miles and the US Gulf of Mexico coastal waters from Monroe County, FL through Texas out to 200 nautical miles. The 200 mile limit is the outer boundary of the US Exclusive Economic Zone.
Continuing
1972
1977
1972-present for NC, SC, and GA. 1977-present for rest of SE US.
-100
-40
30
0
Gulf Of Mexico And South Atlantic Ocean
Continuing
1960
-100
-40
30
0
Gulf Of Mexico And South Atlantic Ocean
Continuing
1960
-100
-40
30
0
Gulf Of Mexico And South Atlantic Ocean
Continuing
1960
Sensitive
Rule of 3: Data summaries must include at least 3 dealers to be considered non-confidential. See:
NOAA FORM 58-5 (1-84) TRANSMITTAL 127,
National Oceanic and Atmospheric Administration
NOAA Administrative Order 216-100
NOAA ADMINISTRATIVE ORDER SERIES
Date of Issuance: July 26, 1994
User ID Password restricted. Confidential data may only be released to entities having a signed non disclosure agreement on file with the Director of the Information Resources Management Division (IRMD). Otherwise, confidentiality may be suppressed by the
See NOAA Administrative Order 216 100 NOAA ADMINISTRATIVE ORDER SERIES Date of Issuance July 26, 1994
These standards and procedures apply to all employees of the SEFSC that need access to confidential fisheries statistics. This includes full time or term employees, contractors, volunteers, and or other employees associated with the SEFSC, but not directl
Waiver Needed
Confidential data are not to be released in any publication, report, oral presentation, or other means to the public.
Non published Metadata access is restricted. Published Metadata is available to the public.
Only published metadata are to be used.
http://sedarweb.org/
South East Data Assessment and Review homepage. The SEDAR documents may be found here.
2008-01-17
Column Alteration
Bennett, Joshua
Changed width of DEALER column from 9 to 10. This was to accommodate new 10 digit codes from South Carolina. Changes were made to all ALS tables for uniformity.
2013-01-10
UPDATE
Bennett, Joshua
A change was made to the waterbody coding in Grid 2 - Dry Tortugas area. This change affects GULF(region 5) vs SOUTH ATLANTIC(region 4) jurisdiction. FL State Water code '0022' (Grid 2, Florida State Waters, South Atlantic) had been translating to water code '0020' (Grid 2 all waters). This situation was corrected today by updating the records to reflect the incoming code of '0022'. Updates mainly affect 2011-2012 data.
2013-02-22
Update
Bennett, Joshua
Edit inland freshwater body codes for Texas: code 7133 > 9182 (894 rows from 1994-98 for old_waterbody='0601'), 7133 > 9181 (146 rows for old_waterbody ='0702'). Edited Shellfish Harvesting area codes for FL West Coast: code 1601 > 0071 (2 records) and code 2232 > 0073 (2 records).
2013-02-22
Data Reload for Alabama
Bennett, Joshua
Data were reloaded from GSMFC-FIN for Alabama 2002-2012 over the last 2 days as there was an improper truncation of dealer codes for 2012 and 2006 had place holder '999...' data in the dealer fields. Program was fixed so improper truncation could not take place. Reload showed proper data for both years. Other years from 2002-2012 were reloaded as they may have updates.
2006-06-30
John Poffenberger
CAVEATS FOR SPECIES#2: Aquarium species and live rock landings are not included in the general canvass data. These data are available from the Florida Fish and Wildlife Conservation Commission, Institute of Marine Resources, St. Petersburg, Florida. **Plans are being made to include these in the future.**
2006-06-30
John Poffenberger
CAVEATS for SPECIES (NMFS_CODE): Some records are identified by generic categories, e.g., snappers, groupers, sharks, etc. and not by individual species. This is especially true for data collected in the earlier years. When long-term trends are required for individual species, adjustments or allocations of the landings for the generic categories need to be made. Examples of these types of analyses can be found in the Southeast Data, Assessment and Review (SEDAR) reports. See the address provided in the URLs section.
2006-06-30
Josh Bennett
CAVEATS for POUNDS: All landed quantities are converted to live or whole weight with the exceptions of oysters and clams, which are converted to pounds of meat. Florida data are reported and stored in landed weight until the end of 1985, after which they are converted to whole weight. Conversion factors are used by the data suppliers to convert landings to whole weight pounds. Generally, these follow standards established in a NMFS Memo `Conversion Factors¿ issued January 12, 1987; however, conversion factors from Texas and North Carolina may vary from the official NMFS factors. The Texas and North Carolina conversion factors for are available from the states. Care must be used when converting these data back to landed weight. If the original conversion factors are not employed the weight will vary from that of the data supplier. The State of Florida uses the NMFS standard set of factors but applies them according to the typical landed condition of the for most fish species. Florida collects a landed condition for shellfish and for some baitfish.
2006-06-30
Josh Bennett
CAVEATS for GEAR (NMFSGEAR) and CATCH AREA (WATERBODY) data: Landings by gear and water body do not reside in the monthly landings data set for Florida non-shrimp species for the years 1977-1996, nor for Louisiana non-shrimp species 1990-1999. Texas landings for non-shrimp species lack gear information from 1993 ¿ 2006. Annual landings by gear and water body are available in the Annual General Canvass data for Florida.
2006-06-30
Josh Bennett
NOTES on Catch Area (WATERBODY): 4. Please remember that catch area information is not present in this table for all states and years (see issue 1). Fishing area information is located in the `WATERBODY' column and is recorded as statistical grids (sometime referred as stat zones). The grids in the Atlantic are formed by the degrees of latitude and longitude. Thus, the statistical grids are approximately 60 miles by 60 miles or about 3,600 square miles. In the Gulf of Mexico the grids are more irregular, bordered by one or several degrees of latitude and longitude. Within the coastal grids there are usually many specific catch areas. Numeric codes of 4 digits are assigned to all catch areas. In the Atlantic the grid or stat zone indicator occupies the first 3 digits of the code while in the Gulf of Mexico the grid indicator occupies the 2 middle digits. Catch areas that occur within the grids are coded with the grid code along with additional coding in the 1st and 4th digit (Gulf) and in the 4th digit (Atlantic). There are also records with general catch areas such as `Gulf of Mexico¿, `Atlantic Ocean¿, `Unknown¿, and a few others. Users must be careful to query for the catch areas accordingly. There is a REGION code that identifies the catch area as Atlantic (4), Gulf (5), or Caribbean (9). These are useful in data retrieval of catch area data. Use the ALSSTATE and NMFSCOUNTY fields to retrieve landings for the area landed, and use the `REGION¿ and `WATERBODY' fields to retrieve landings by catch area. The validation table for water body codes contains the conversions and definition for each species. The table name is ALS.ALS_WATERBODY_OLD_NEW_XREF. Information on that table, maps, and historical documentation are provided under `Related Items'.
2006-06-30
Josh Bennett
NOTES on DATA SOURCES: 1.Shrimp: The NOAA-SEFSC Gulf Shrimp System (GSS) is the source of all food shrimp landings from the Gulf of Mexico States. The NOAA South Atlantic Shrimp System (SASS) supplied the food shrimp data from 1981-1992 for the Florida East Coast (after 1992 the the FLEC shrimp data were supplied by FMRI while the Florida West Coast shrimp data continued to be supplied by the GSS). The SASS also supplied the food shrimp data from 1978-2000 for Georgia, from 1979 to present for South Carolina, and from 1978-1992 for North Carolina. 2.Non-shrimp species: As stated previously, NOAA is the source for data prior to 1986 for Florida. For 1986 to-date, the Florida Marine Research Institute (FMRI) of the FWC is the source. Data from other states in the SE Region were supplied by the Cooperative Statistics Program state agency partners. Data are present for GA-NC from 1972 on. FL-TX data are present for 1977 on. For year 2000 and more recent, the Gulf States Marine Fisheries Commision (GSMFC) has supplied the non-shrimp data for Louisiana from the Fisheries Information Network database (FIN). The FIN is also the source of the non-shrimp data Alabama for the years 2002 and more recent. In the Atlantic, the Atlantic Coast Cooperative Statistics Program (ACCSP) currently supplies the data for Georgia and the Carolinas.
2006-07-05
Josh Bennett
NOTES on DATA Completeness: All data in the ALS rely on landings reported by industry. Batches of data are submitted in regular intervals as the reports are processed by the partner agencies. In many cases the data are incomplete for recent months since most agencies do not hold their data until the entire month is complete.
Oracle Database
Data provided by industry - seafood dealers - Canvass of landings of all species in SE US and US Caribbean, State or Federally Managed . These are raw data. Data quality parameters vary by individual species and are determined during Stock Assessment. They may be found in the Stock Assessment Reports.
Range checks and validation against historical distributions.
Yes
70
Yes
Yes
No
60
Confidentiality. This data is currently wavered under the current NOAA guidelines for relational databases.
To Be Determined
365
The data resides on a secure database server only accessible through the NMFS network requiring separate multi-factor authentication for both network and database access.
Dealers supply invoices, either mailed, or collected by port agent (historical) or electronically (current) to State partner agencies. States process data and submit either to NOAA-SEFSC directly or through GSMFC or ASMFC. Data are then checked by NOAA and posted.
1
Data are summarized trip level data data. Data are presented at the dealer and month level. Data are collected by states and made available to this system through the Gulf States Marine Fisheries Commission or through the Atlantic Coastal Cooperative Statistics Program. Data are summarized and loaded to the Accumulated Landings System at SEFSC.
5450
Entity
Table: ALS_LANDINGS
5451
Entity
Table: ALS_TEMP_LAND
1917
Data Set
Annual General Canvass Statistics
Cross Reference
The Annual general canvass statistics contain annually summarized data for the SE Region from 1962-1971 for all states in the region.
1918
Data Set
Florida annual general canvass statistics
Cross Reference
The Florida annual general canvass statistics contain annually summarized data from Florida for the years 1976-1996. These data are for non-shrimp species. **They duplicate the data in the ALS.ALS_LANDINGS (monthly landings) table**; however, this table contains information on gear, water body, and distance from shore (collected by port agent survey of dealers on an annual basis) that are not present for non-shrimp in the monthly landings table.
5447
Data Set
Gulf Shrimp Control Data Tables
Cross Reference
1919
Data Set
Puerto Rico Commercial Landings Statistics 1983 and more recent in Accumulated Landings System (ALS) Compatible Format
Cross Reference
Puerto Rico Landings.
2201
Data Set
Southeast Region 1972-1976 general canvass statistics
Cross Reference
Landings from 1972-1976 (except NC,SC,GA which are in ALS.ALS_LANDINGS.)
1920
Data Set
U.S. Virgin Islands Commercial Landings Statistics 1974 and more recent in compatible format with Accumulated Landings System (ALS) data
Cross Reference
US Virgin Islands Landings.
gov.noaa.nmfs.inport:1916
Lee Weinberger
2006-06-13T12:33:51
Bryson Anderson
2023-01-27T17:08:26
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06