5455
Reference Tables Used In Waterbody Project
Reference Tables Used In Waterbody Project
Data Set
Published / External
5454
Standardization And Correction Of Waterbody Codes
Project
Completed
2013
Table of waterbofy cross refernces and time to standardize the waterbody codes within the landings system
To standardize Waterbody Codes within the landings system.
Theme
fishdep
Theme
fishery-dependent
Theme
standardization
Theme
waterbody codes
Spatial
SE region
Southeast Fisheries Science Center
Miami
FL
USA
75 Virginia Beach Drive
Miami, FL 33149
Data Set
Database
None Planned
Table (digital)
keyboard entry
Oracle
All commercial fishing gears for marine catch used in SE United States
5463
Table: ALS_WATERBODY_OLD_NEW_XREF
ALS_WATERBODY_OLD_NEW_XREF
Published / External
Completed
Lookup Table used to recode waterbody codes. Records are unique on the basis of fields alsstate, old water, begin date, end date, and region.
Loaded by batch 1727, 10-16-2007 09:13
Data Table
Yes
ALS
Lookup Table used to recode waterbody codes.
1
ALSSTATE
VARCHAR2
2
No
No
Active
NMFS State Code
VARCHAR2
2
OLD_WATER
VARCHAR2
4
No
No
Active
Old/Historical Water Body Code
VARCHAR2
3
NEW_WATER
VARCHAR2
4
No
No
Active
New/replacementl Water Body Code
VARCHAR2
4
DESCRIPTION
VARCHAR2
60
No
No
Active
Description Of Waterbody Code
VARCHAR2
5
BEGIN_DATE
DATE
7
No
No
Active
Beginning Date WHere this transformation Is to be done
DATE
6
END_DATE
DATE
7
No
No
Active
Ending Date where this transformation Is to be done. If transformation is still current it is null.
DATE
7
NEW_DESCRIPTION
VARCHAR2
60
No
No
Active
Descition Of New Waterbody Code
VARCHAR2
8
REGION
VARCHAR2
1
No
No
Active
Region Code
VARCHAR2
5464
Table: ALS_WATERBODY_VALID_ERRORS
ALS_WATERBODY_VALID_ERRORS
Published / External
Completed
Table that holds errors as a result of project to redo waterbody codes.
Loaded by batch 1727, 10-16-2007 09:13
Data Table
Yes
ALS
Table that holds errors as a result of project to redo waterbody codes.
1
ALSSTATE
VARCHAR2
2
No
No
Active
NMFS State Code
VARCHAR2
2
OLD_WATER
VARCHAR2
4
No
No
Active
Old/Historical Water Body Code
VARCHAR2
3
NEW_WATER
VARCHAR2
4
No
No
Active
New/replacementl Water Body Code
VARCHAR2
4
BEGIN_DATE
DATE
7
No
No
Active
Beginning Date WHere this transformation Is to be done
DATE
5
END_DATE
DATE
7
No
No
Active
Beginning Date WHere this transformation Is to be done
DATE
6
ERROR_TYPE
VARCHAR2
5
No
No
Active
Can be either "Error" or "Warn"
VARCHAR2
7
ERROR_MESSAGE
VARCHAR2
55
No
No
Active
Error message
VARCHAR2
8
REGION
VARCHAR2
1
No
No
Active
Region Code
VARCHAR2
Data Steward
2018
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
Data Steward
2003-01-01
2017
Person
Bennett, Joshua
Metadata Contact
2017
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
Metadata Contact
2015-12-30
2017
Person
Bennett, Joshua
Point of Contact
2017
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
Point of Contact
2015-12-30
2017
Person
Bennett, Joshua
Southeast US Coast out to 200 NM from NC through TX
Continuing
1962
Converts water coding to std gulf and south atlantic shrimp grid coding
Unclassified
Oral or written data request.
USERID, PASSWORD, Oracle DBA grants
Oracle Database
keyboard entry from hardcopy. Visual proofing.
Yes
Unknown
Yes
Yes
NOAA-SEFSC Miami
none
n/a
Other
none. This is a look-up table.
Userid, password, Oracle DBA grants
THis is a lookup table for unifying state dependent water coding.
5463
Entity
Table: ALS_WATERBODY_OLD_NEW_XREF
5464
Entity
Table: ALS_WATERBODY_VALID_ERRORS
gov.noaa.nmfs.inport:5455
Lee Weinberger
2007-10-16T08:31:59
Bryson Anderson
2023-01-27T17:10:03
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