Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Support Roles
Distribution Info
Catalog Details

Summary

Abstract

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

Description

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

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
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
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.
Data Description
Character
The descriptor/Column definition of the corresponding column
Data Type
Character
Indicates the data type (generally character or numeric ) of the corresponding data column
Data Length
Numeric
The length of the corresponding field in question
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
Required?
Character
Indicates If it is required that this column be populated in the corresponding data table

Distribution Information

  • CSV - Comma Separated Values (Text), 6.7K

    Meta data table table giving column definition for all columns in CAP2005.csv to CAP2016.csv

Child Items

No Child Items for this record.

Contact Information

Distributor
National Centers for Environmental Information - Silver Spring, Maryland (NCEI-MD)
(301) 713-3277

Item Identification

Title: CAP_Metadata_Table.csv
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: 767259
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: 767261
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: 767255
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: 767257
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: 767256
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: 767258
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: 767260
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

Distributor

CC ID: 767263
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.

Distribution Information

Distribution 1

CC ID: 767266
Start Date: 2016
End Date: Present
Download URL: https://www.ncei.noaa.gov/archive/accession/0156869/2.2/data/0-data/26906/CSV/CAP_Metadata_Table.csv
Distributor: National Centers for Environmental Information - Silver Spring, Maryland (NCEI-MD) (2016-12 - Present)
File Name: CAP_Metadata_table.csv
Description:

Meta data table table giving column definition for all columns in CAP2005.csv to CAP2016.csv

File Date/Time: 2016-10-17 15:18:00
File Type (Deprecated): csv (comma-separated values)
Distribution Format: CSV - Comma Separated Values (Text)
File Size: 6.7K
Compression: Uncompressed
Review Status: Chked Viruses Inapp Content

Catalog Details

Catalog Item ID: 53285
GUID: gov.noaa.nmfs.inport:53285
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2018-08-07 11:32+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2023-10-17 16:12+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