34433
bft_observation_sample
Entity
Published / External
26114
Southeast Region Finfish Age Database
Data Set
In Work
Data in this table include the steps from processing the age structure and assigning a physical location of the processed structure to a recording of the age reading. The age readings have three parts - the increment , or annuli, count, a description of the margin of the age structure following the last annulus formed, and a quality code for the sample. These data are recorded by fish ageing experts in the laboratory .
Data Table
Yes
Data in this table include the steps from processing the age structure and assigning a physical location of the processed structure to a recording of the age reading. The age readings have three parts - the increment , or annuli, count, a description of the margin of the age structure following the last annulus formed, and a quality code for the sample. These data are recorded by fish ageing experts in the laboratory .
1st_CALENDAR_AGE
Numeric
No
No
Active
Age of fish based on ring count, margin type, and month of year.
UNIT
Character
3
No
No
Active
Distance units used in measurements.
1st_MARGIN_TYPE
Character
No
No
Active
Amount of growth from the outer most annulus to the edge of the sample (1 through 4)
1st_READABILITY
Character
1
No
No
Active
Code to indicate Ease of determining ring count
A,B,C,D,E
1st_READER
Character
25
No
No
Active
Person who aged the sample
2nd_CALENDAR_AGE
Numeric
No
No
Active
Age of fish based on 2nd ring count, margin type, and month of year.
2nd_COUNT
Numeric
No
No
Active
Number of annuli counted on the sample for a second time. Can be same or different reader. Typically used for comparission with first reading
2nd_MARGIN TYPE
Numeric
No
No
Active
Amount of growth from the outer most annulus to the edge of the sample (1 through 4)
2nd_READABILITY
Character
1
No
No
Active
Code to indicate Ease of determining 2nd ring count
A,B,C,D,E
2nd_Reader
Character
25
No
No
Active
Person who aged the sample
AGE_ASSIGNED_BY
Character
10
No
No
Active
Agency that assigned the age
Age_Method
Numeric
1
No
No
Active
Describes Method used in ageing process
1= Ring count
2 = Radial measure
COMMENTS
Character
255
No
No
Active
Notes
CORE_TO_1ST_ANNULUS
Numeric
No
No
Active
Distance from the core to the first annulus of the sample. Column potenially to be eliminated and data moved to radial measures table.
CREATED_BY_USER_ID
Character
25
No
No
Active
Person who created the record in the BFT Inventory
CREATED_DATE
Date
No
No
Active
Date the record was created in the BFT Inventory
DATE_AGED
Date
No
No
Active
Date sample was aged
DRAWER_NO
Character
15
No
No
Active
Location of sample slide if no longer in a box. Generally no longer used.
DRAWER_ROW
Character
1
No
No
Active
Location of sample slide if no longer in a box. Generally no longer used.
INTERVIEW_ID
Character
6
Yes
No
Active
Tip Online interview id or Headboat (BioProfile) Collection Numer or NCDMF Control1 number, or FWRI Fish Collection Number or special collection ID.
ITIS
Character
Yes
No
Active
Fish codes from www.itis.gov used in Tip
Image
Character
No
No
Active
Photo location
Lab
Character
10
No
No
Active
LAB Lab that aged the sample. Default Beaufort, some state agencies have aged specific species.
MAGNIFICATION
Character
6
No
No
Active
Microscope Magnification
MODIFIED_BY_USER_ID
Character
25
No
No
Active
Person who modified the record in the BFT Inventory
OBSERVATION_ID
Numeric
10
No
No
Active
id from BFT_Observation table. DOES NOT CORRESPOND TO TIP ONLINE OBSERVATION ID.
PAIRED
Character
No
No
Active
Is there a pair of otoliths in the sample envelope?
POSITION
Character
1
No
No
Active
if more than one sample per slide this is a code for the location of the sample on the slide.
L =left,
M=middle,
R=right
PROCESSED
Character
No
No
Active
Has the sample been sectioned?
PROCESSED_DATE
Date
No
No
Active
Date sample was processed
RADIUS
Numeric
No
No
Active
Distance from the core to the edge of the sample. Column potenially to be eliminated and data moved to radial measures table.
SAMPLE_TYPE_ID
Character
No
No
Active
Tip sample type codes for otoliths, scales, and spines
SECTION
Character
No
No
Active
Will or has the sample been sectioned?
SLIDE_BOX_NO
Character
No
No
Active
Box Number the slide is in
SLIDE_NO
Numeric
3
No
No
Active
slide Number in the box
a Numeric between 1-100
TAG_Numeric
Character
11
Yes
No
Active
Tip Online tag Numeric or Headboat (sample) id, or NCDMF replicate&line number, or FWRI Auxilery Number. Note: Samples 1-9 have leading 0 in BFT Inventory that do not occur in TIP or BP databases
1st_COUNT
Numeric
No
No
Active
Numeric of annuli counted on the sample
gov.noaa.nmfs.inport:34433
Lee Weinberger
2016-08-24T19:40:10
SysAdmin InPortAdmin
2022-08-09T17:11:05
2022-06-03
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
2022-06-03
1 Year
2023-06-03