Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

Item Identification

Title: Column Definitions
Status: Completed
Abstract:

Meta Table which provides definitions for the columns in the data entities for this dataset

Purpose:

To define the columns of the data tables. Please use this information in conjunction with the descriptors provide for the columns as well as the abbreviations provided with the Galveston table

Entity Information

Entity Type: Data Table
Active Version?: Yes
Alias: Column Definitions
Description:

Meta Table which provides definitions for the columns in the data entities for this data set

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Original Variable Name Character The original variable name for which the data is supplied. This is the column name in the original_data.csv file
100
Revised Variable Name Character This is the normalized corrected variable name for which the data is supplied. This is the column name in the data table renamed_data_table.csv file (if the data table is instead renamed_data_sheet.csv it will correspond to columns in that table.
100
Data Description Character The descriptor/Column definition of the corresponding column
100
Data Type Character Indicates the data type (generally character or numeric ) of the corresponding data column
100
Data Length Numeric The length of the corresponding field in question
100
Number of Decimal Places Numeric Indicates the number of data places (for a numeric column) of the corresponding column in question. This will be blank if the corresponding column in question
100
Required? Character Indicates If it is required that this column be populated in the corresponding data table

Attribute Details

Original Variable Name

CC ID: 707701
Seq. Order: 20
Data Storage Type: Character
Max Length: 40
Required: Yes
Primary Key: No
Status: Active
Description:

The original variable name for which the data is supplied. This is the column name in the original_data.csv file

Revised Variable Name

CC ID: 707703
Seq. Order: 30
Data Storage Type: Character
Max Length: 40
Required: Yes
Primary Key: No
Status: Active
Description:

This is the normalized corrected variable name for which the data is supplied. This is the column name in the data table renamed_data_table.csv file (if the data table is instead renamed_data_sheet.csv it will correspond to columns in that table.

Data Description

CC ID: 707697
Seq. Order: 40
Data Storage Type: Character
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

The descriptor/Column definition of the corresponding column

Data Type

CC ID: 707699
Seq. Order: 50
Data Storage Type: Character
Max Length: 12
Required: Yes
Primary Key: No
Status: Active
Description:

Indicates the data type (generally character or numeric ) of the corresponding data column

Allowed Values: Character Number

Data Length

CC ID: 707698
Seq. Order: 60
Data Storage Type: Numeric
Max Length: 4
Required: Yes
Primary Key: No
Scale: 0
Status: Active
Description:

The length of the corresponding field in question

Number of Decimal Places

CC ID: 707700
Seq. Order: 70
Data Storage Type: Numeric
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Indicates the number of data places (for a numeric column) of the corresponding column in question. This will be blank if the corresponding column in question

Null Value Meaning:

I

Required?

CC ID: 707702
Seq. Order: 100
Data Storage Type: Character
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Indicates If it is required that this column be populated in the corresponding data table

Allowed Values: Yes No

Support Roles

Data Steward

CC ID: 707704
Date Effective From: 2017
Date Effective To:
Contact (Person): Higgins, Benjamin
Address: 4700 Avenue U
Galveston, TX 77551
Email Address: ben.higgins@noaa.gov
Phone: 409-766-3670
Contact Instructions:

Contact by email preferred.

Distributor

CC ID: 707705
Date Effective From: 2016-12
Date Effective To:
Contact (Organization): National Centers for Environmental Information - Silver Spring, Maryland (NCEI-MD)
Address: NOAA/NESDIS E/OC SSMC3, 4th Floor, 1351 East-West Highway
Silver Spring, MD 20910-3282
Phone: (301) 713-3277
Contact Instructions:

Contact by email preferred.

Metadata Contact

CC ID: 707706
Date Effective From: 2017
Date Effective To:
Contact (Person): Higgins, Benjamin
Address: 4700 Avenue U
Galveston, TX 77551
Email Address: ben.higgins@noaa.gov
Phone: 409-766-3670
Contact Instructions:

Contact by email preferred.

Point of Contact

CC ID: 707707
Date Effective From: 2017
Date Effective To:
Contact (Person): Baumer, Tim J
Address: 4700 Avenue U
Galveston, TX 77551
Email Address: tim.baumer@noaa.gov
Phone: 409-766-3784
Contact Instructions:

Contact by email preferred.

Distribution Information

Distribution 1

CC ID: 707708
Start Date: 2017
End Date: Present
Download URL: https://www.nodc.noaa.gov/archive/arc0102/0157625/2.2/data/0-data/Galveston_Turtle_Program/26904/CSV/Metadata_Table.csv
Distributor: National Centers for Environmental Information - Silver Spring, Maryland (NCEI-MD) (2016-12 - Present)
File Name: Metadata_Table.csv
Description:

Meta data table table giving column definition

File Type: csv (comma-separated values)
Compression: no compression applied
Review Status: Not Chked

Catalog Details

Catalog Item ID: 50965
GUID: gov.noaa.nmfs.inport:50965
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2018-01-02 15:23+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-04-29
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-04-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-04-29