Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Sharks > Cooperative Gulf of Mexico Shark Pupping and Nu... > GULFSPAN Survey (longterm effort, catch, and en... >

Effort_Table.csv

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:36882 | Updated: October 3, 2024 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Support Roles

Distribution Info

Catalog Details

Abstract

A by set summary of environmental and sampling effort information.

Purpose

Contains a summarize by set of the sampling gear for all environmental, and effort (i.e. time of sampling) as it pertains to that set of the sampling gear.

Description

Effort Table

Entity Type
Data Table

Data Attribute / Type	Description
GEAR_COLLECTION_NUMBER Character	Generated Primary. Sometimes it has been a sequential number. Other times it has been a combination of the sampling year and a sequential number for that year
AREA_CODE Character	Mnemonic Code to indicate general area of where sampling took place.
AREA_DESCRIPTION Character	Longer Description Associated with the area_code
Latitude Numeric	Latitude value of where sampling was done
Longitude Numeric	Loogitude value of where sampling was done
MONTH Numeric	Month Of Data Collection
Day Numeric	Day portion of the Sampling Date
Year Numeric	Year Portion of the Sampling Date
SET_BEGIN_TIME Numeric	Time Set Began. (This is only and hours value. The part after decimal point is for a fraction of an hour)
SET_END_TIME Numeric	Time Set Ended This is only and hours value. The part after decimal point is for a fraction of an hour)
SALINITY Numeric	MID WATER SALINITY
WATER_TEMPERATURE Numeric	midwater Temperature of water at time of sampling
DEPTH Numeric	Mid water depth
TURBIDITY Numeric	mid water clarity
Dissolved_Oxygen Numeric	MID WATER DISSOLVED OXYGEN IN MG/L
BOTTOM_TYPE Character	BOTTOM TYPE SET OVER

Data Attribute / Type

Description

GEAR_COLLECTION_NUMBER
Character

Generated Primary. Sometimes it has been a sequential number. Other times it has been a combination of the sampling year and a sequential number for that year

AREA_CODE
Character

Mnemonic Code to indicate general area of where sampling took place.

AREA_DESCRIPTION
Character

Longer Description Associated with the area_code

Latitude
Numeric

Latitude value of where sampling was done

Longitude
Numeric

Loogitude value of where sampling was done

MONTH
Numeric

Month Of Data Collection

Day
Numeric

Day portion of the Sampling Date

Year
Numeric

Year Portion of the Sampling Date

SET_BEGIN_TIME
Numeric

Time Set Began. (This is only and hours value. The part after decimal point is for a fraction of an hour)

SET_END_TIME
Numeric

Time Set Ended This is only and hours value. The part after decimal point is for a fraction of an hour)

SALINITY
Numeric

MID WATER SALINITY

WATER_TEMPERATURE
Numeric

midwater Temperature of water at time of sampling

DEPTH
Numeric

Mid water depth

TURBIDITY
Numeric

mid water clarity

Dissolved_Oxygen
Numeric

MID WATER DISSOLVED OXYGEN IN MG/L

BOTTOM_TYPE
Character

BOTTOM TYPE SET OVER

Effort_table.csv

CSV - Comma Separated Values (Text), 202K

No Child Items for this record.

Distributor
NOAA National Centers for Environmental Information (NCEI)
ncei.info@noaa.gov
NCEI Contact Information

Title:	Effort_Table.csv
Status:	Completed
Publication Date:	2017
Abstract:	A by set summary of environmental and sampling effort information.
Purpose:	Contains a summarize by set of the sampling gear for all environmental, and effort (i.e. time of sampling) as it pertains to that set of the sampling gear.

Entity Type:	Data Table
Active Version?:	Yes
Description:	Effort Table

Attribute Summary

	Name	Type	Description
100	GEAR_COLLECTION_NUMBER	Character	Generated Primary. Sometimes it has been a sequential number. Other times it has been a combination of the sampling year and a sequential number for that year
100	AREA_CODE	Character	Mnemonic Code to indicate general area of where sampling took place.
100	AREA_DESCRIPTION	Character	Longer Description Associated with the area_code
100	Latitude	Numeric	Latitude value of where sampling was done
100	Longitude	Numeric	Loogitude value of where sampling was done
100	MONTH	Numeric	Month Of Data Collection
100	Day	Numeric	Day portion of the Sampling Date
100	Year	Numeric	Year Portion of the Sampling Date
100	SET_BEGIN_TIME	Numeric	Time Set Began. (This is only and hours value. The part after decimal point is for a fraction of an hour)
100	SET_END_TIME	Numeric	Time Set Ended This is only and hours value. The part after decimal point is for a fraction of an hour)
100	SALINITY	Numeric	MID WATER SALINITY
100	WATER_TEMPERATURE	Numeric	midwater Temperature of water at time of sampling
100	DEPTH	Numeric	Mid water depth
100	TURBIDITY	Numeric	mid water clarity
100	Dissolved_Oxygen	Numeric	MID WATER DISSOLVED OXYGEN IN MG/L
100	BOTTOM_TYPE	Character	BOTTOM TYPE SET OVER

Name

Type

Description

100

GEAR_COLLECTION_NUMBER

Character

Generated Primary. Sometimes it has been a sequential number. Other times it has been a combination of the sampling year and a sequential number for that year

100

AREA_CODE

Character

Mnemonic Code to indicate general area of where sampling took place.

100

AREA_DESCRIPTION

Character

Longer Description Associated with the area_code

100

Latitude

Numeric

Latitude value of where sampling was done

100

Longitude

Numeric

Loogitude value of where sampling was done

100

MONTH

Numeric

Month Of Data Collection

100

Day

Numeric

Day portion of the Sampling Date

100

Year

Numeric

Year Portion of the Sampling Date

100

SET_BEGIN_TIME

Numeric

Time Set Began. (This is only and hours value. The part after decimal point is for a fraction of an hour)

100

SET_END_TIME

Numeric

Time Set Ended This is only and hours value. The part after decimal point is for a fraction of an hour)

100

SALINITY

Numeric

MID WATER SALINITY

100

WATER_TEMPERATURE

Numeric

midwater Temperature of water at time of sampling

100

DEPTH

Numeric

Mid water depth

100

TURBIDITY

Numeric

mid water clarity

100

Dissolved_Oxygen

Numeric

MID WATER DISSOLVED OXYGEN IN MG/L

100

BOTTOM_TYPE

Character

BOTTOM TYPE SET OVER

Attribute Details

GEAR_COLLECTION_NUMBER

CC ID: 383478

Seq. Order:	10
Data Storage Type:	Character
Max Length:	17
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Generated Primary. Sometimes it has been a sequential number. Other times it has been a combination of the sampling year and a sequential number for that year

AREA_CODE

CC ID: 383479

Seq. Order:	20
Data Storage Type:	Character
Max Length:	15
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Mnemonic Code to indicate general area of where sampling took place.
Validation Rules:	Must match field Location_code in Location_Areas.csv

AREA_DESCRIPTION

CC ID: 383480

Seq. Order:	30
Data Storage Type:	Character
Max Length:	40
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Longer Description Associated with the area_code
Derivation:	Taken from the lookup table.

Latitude

CC ID: 383481

Seq. Order:	40
Data Storage Type:	Numeric
Required:	No
Primary Key:	No
Precision:	8
Scale:	5
Status:	Active
Description:	Latitude value of where sampling was done
Unit of Measure:	degrees
Display Example:	29.34567
Format Mask:	##.#####

Longitude

CC ID: 383482

Seq. Order:	50
Data Storage Type:	Numeric
Required:	No
Primary Key:	No
Precision:	9
Scale:	5
Status:	Active
Description:	Loogitude value of where sampling was done
Unit of Measure:	degrees
Display Example:	-85.67891
Format Mask:	###.#####

MONTH

CC ID: 383483

Seq. Order:	60
Data Storage Type:	Numeric
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Month Of Data Collection
Allowed Values:	1-12
Validation Rules:	Must be a valid numeric month. Month , day, Year Combination must be valid

Day

CC ID: 383484

Seq. Order:	70
Data Storage Type:	Numeric
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Day portion of the Sampling Date
Allowed Values:	1-31
Validation Rules:	Month , day, Year Combination must be valid

Year

CC ID: 383485

Seq. Order:	80
Data Storage Type:	Numeric
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Year Portion of the Sampling Date
Validation Rules:	Month , day, Year Combination must be valid

SET_BEGIN_TIME

CC ID: 383486

Seq. Order:	90
Data Storage Type:	Numeric
Required:	Yes
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Time Set Began. (This is only and hours value. The part after decimal point is for a fraction of an hour)
Unit of Measure:	hours
Display Example:	14.50 (2:30 PM)
Allowed Values:	Bust be less than 24

SET_END_TIME

CC ID: 383487

Seq. Order:	100
Data Storage Type:	Numeric
Required:	Yes
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Time Set Ended This is only and hours value. The part after decimal point is for a fraction of an hour)
Unit of Measure:	Hours
Display Example:	14.50 (2:30 PM)
Validation Rules:	Must be less than 24 and > SeT_begin_time

SALINITY

CC ID: 383489

Seq. Order:	110
Data Storage Type:	Numeric
Required:	No
Primary Key:	No
Precision:	6
Scale:	3
Status:	Active
Description:	MID WATER SALINITY
Unit of Measure:	Practical Salinity Units

WATER_TEMPERATURE

CC ID: 383488

Seq. Order:	120
Data Storage Type:	Numeric
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	midwater Temperature of water at time of sampling
Unit of Measure:	degrees celcius

DEPTH

CC ID: 383490

Seq. Order:	130
Data Storage Type:	Numeric
Required:	No
Primary Key:	No
Precision:	6
Scale:	3
Status:	Active
Description:	Mid water depth
Unit of Measure:	Meters

TURBIDITY

CC ID: 383491

Seq. Order:	140
Data Storage Type:	Numeric
Required:	No
Primary Key:	No
Precision:	6
Scale:	1
Status:	Active
Description:	mid water clarity
Unit of Measure:	cm

Dissolved_Oxygen

CC ID: 383492

Seq. Order:	150
Data Storage Type:	Numeric
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	MID WATER DISSOLVED OXYGEN IN MG/L
Unit of Measure:	mg/lit

BOTTOM_TYPE

CC ID: 383493

Seq. Order:	160
Data Storage Type:	Character
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	BOTTOM TYPE SET OVER
Allowed Values:	SAND, MUD, SEAGRASS and combinations thereof

Distributor

CC ID: 1195943

Date Effective From:	2017
Date Effective To:
Contact (Organization):	NOAA National Centers for Environmental Information (NCEI)
Email Address:	ncei.info@noaa.gov
URL:	NCEI Contact Information

Distribution 1

CC ID: 1195944

Start Date:	2017
End Date:	Present
Download URL:	https://www.ncei.noaa.gov/archive/accession/0162100/1.1/data/0-data/8544/Effort_Table.csv
Distributor:	NOAA National Centers for Environmental Information (NCEI) (2017 - Present)
File Name:	Effort_table.csv
File Date/Time:	2017-03-17 14:42:00
File Type (Deprecated):	tabular digital data (Microsoft Excel, CSV, or other tabular format)
Distribution Format:	CSV - Comma Separated Values (Text)
File Size:	202K

Catalog Item ID:	36882
GUID:	gov.noaa.nmfs.inport:36882
Metadata Record Created By:	Lee M Weinberger
Metadata Record Created:	2017-02-23 12:55+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2024-10-03 18:16+0000
Metadata Record Published:	2021-10-19
Owner Org:	SEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-10-19
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-10-19

Effort_Table.csv

Summary

Entity Information

Distribution Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

GEAR_COLLECTION_NUMBER

AREA_CODE

AREA_DESCRIPTION

Latitude

Longitude

MONTH

Day

Year

SET_BEGIN_TIME

SET_END_TIME

SALINITY

WATER_TEMPERATURE

DEPTH

TURBIDITY

Dissolved_Oxygen

BOTTOM_TYPE

Support Roles

Distributor

Distribution Information

Distribution 1

Catalog Details