Slide Menu
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

Please remember that every column listed in this table is not found in every entity in this data set and the all of attributes of every entity in the data set are not necessarily found in this 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
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

Revised Variable Name

CC ID: 752817
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: 752811
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: 752813
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: 752812
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: 752814
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: 752816
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: 752818
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: 752819
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: 752820
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: 752821
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: 752822
Start Date: 2017
End Date: Present
Download URL: https://www.nodc.noaa.gov/archive/arc0100/0156880/1.1/data/0-data/26907/26907/26907/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: 52518
GUID: gov.noaa.nmfs.inport:52518
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2018-05-02 00:54+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-04-29 12:26+0000
Metadata Record Published: 2021-04-29
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-04-30