Search Help Show/Hide Menu
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Abstract

The data table SOURCES contains the primary sources used to create the ESI data set. See the Browse_Graphic section for a link to the entity-relationship diagram, which describes the way this table relates to other attribute tables in the ESI data structure. | Description Source: NOAA ESI Guidelines

Entity Information

Data Attribute / Type Description
SOURCE_ID
NUMBER
Source identifier that links records in the SOURCES data table to the items G_SOURCE and A_SOURCE in the SOC_DAT table; G_SOURCE and S_SOURCE in the BIORES table; and SOURCE_ID and ESI_Source in the ESI and HYDRO data layers. | Description Source: NOAA ESI Guidelines
ORIGINATOR
VARCHAR
Author or developer of source material or data set. | Description Source: NOAA ESI Guidelines
DATE_PUB
NUMBER
Date of source material, publication, or date of personal communication with expert source. | Description Source: NOAA ESI Guidelines
TITLE
VARCHAR
Title of source material or data. | Description Source: NOAA ESI Guidelines
DATA_FORMAT
VARCHAR
The format of the source material. | Description Source: NOAA ESI Guidelines
PUB_PLACE
VARCHAR
Publication place. | Description Source: NOAA ESI Guidelines
PUBLISHER
VARCHAR
Publisher. | Description Source: NOAA ESI Guidelines
PUBLICATION
VARCHAR
Additional citation information. | Description Source: NOAA ESI Guidelines
ONLINE_LINK
VARCHAR
URL to the data if internet-available or to the website of the data provider | Description Source: NOAA ESI Guidelines
SCALE
VARCHAR
Description of the source scale. | Description Source: NOAA ESI Guidelines
TIME_PERIOD
VARCHAR
Date(s) of data collection that the source material is based upon. | Description Source: NOAA ESI Guidelines

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (ORR) for inquiries on this record.

Item Identification

Title: SOURCES
Status: Completed
Abstract:

The data table SOURCES contains the primary sources used to create the ESI data set. See the Browse_Graphic section for a link to the entity-relationship diagram, which describes the way this table relates to other attribute tables in the ESI data structure. | Description Source: NOAA ESI Guidelines

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SOURCE_ID NUMBER Source identifier that links records in the SOURCES data table to the items G_SOURCE and A_SOURCE in the SOC_DAT table; G_SOURCE and S_SOURCE in the BIORES table; and SOURCE_ID and ESI_Source in the ESI and HYDRO data layers. | Description Source: NOAA ESI Guidelines
100
ORIGINATOR VARCHAR Author or developer of source material or data set. | Description Source: NOAA ESI Guidelines
100
DATE_PUB NUMBER Date of source material, publication, or date of personal communication with expert source. | Description Source: NOAA ESI Guidelines
100
TITLE VARCHAR Title of source material or data. | Description Source: NOAA ESI Guidelines
100
DATA_FORMAT VARCHAR The format of the source material. | Description Source: NOAA ESI Guidelines
100
PUB_PLACE VARCHAR Publication place. | Description Source: NOAA ESI Guidelines
100
PUBLISHER VARCHAR Publisher. | Description Source: NOAA ESI Guidelines
100
PUBLICATION VARCHAR Additional citation information. | Description Source: NOAA ESI Guidelines
100
ONLINE_LINK VARCHAR URL to the data if internet-available or to the website of the data provider | Description Source: NOAA ESI Guidelines
100
SCALE VARCHAR Description of the source scale. | Description Source: NOAA ESI Guidelines
100
TIME_PERIOD VARCHAR Date(s) of data collection that the source material is based upon. | Description Source: NOAA ESI Guidelines

Attribute Details

SOURCE_ID

CC ID: 805839
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 8
Min Length: 8
Required: Yes
Primary Key: Yes
Status: Active
Description:

Source identifier that links records in the SOURCES data table to the items G_SOURCE and A_SOURCE in the SOC_DAT table; G_SOURCE and S_SOURCE in the BIORES table; and SOURCE_ID and ESI_Source in the ESI and HYDRO data layers. | Description Source: NOAA ESI Guidelines

Allowed Values: 23600001-23600509

ORIGINATOR

CC ID: 805834
Seq. Order: 2
Data Storage Type: VARCHAR
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Author or developer of source material or data set. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

DATE_PUB

CC ID: 805832
Seq. Order: 3
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Date of source material, publication, or date of personal communication with expert source. | Description Source: NOAA ESI Guidelines

Allowed Values: YYYY, or YYYYMM, or YYYYMMDD, where Y=year, M=month, D=day

TITLE

CC ID: 805841
Seq. Order: 4
Data Storage Type: VARCHAR
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Title of source material or data. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

DATA_FORMAT

CC ID: 805831
Seq. Order: 5
Data Storage Type: VARCHAR
Max Length: 80
Required: No
Primary Key: No
Status: Active
Description:

The format of the source material. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

PUB_PLACE

CC ID: 805837
Seq. Order: 6
Data Storage Type: VARCHAR
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Publication place. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

PUBLISHER

CC ID: 805836
Seq. Order: 7
Data Storage Type: VARCHAR
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Publisher. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

PUBLICATION

CC ID: 805835
Seq. Order: 8
Data Storage Type: VARCHAR
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Additional citation information. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

ONLINE_LINK

CC ID: 805833
Seq. Order: 9
Data Storage Type: VARCHAR
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

URL to the data if internet-available or to the website of the data provider | Description Source: NOAA ESI Guidelines

Allowed Values: URL. Must be copied as is from the address bar & must be fully qualified (begin with http://) & contain no “<” or “>” characters

SCALE

CC ID: 805838
Seq. Order: 10
Data Storage Type: VARCHAR
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Description of the source scale. | Description Source: NOAA ESI Guidelines

Allowed Values: Values may be numeric, such as 1:24000, or text, such as UNKNOWN (non-digital data only), or VARIES

TIME_PERIOD

CC ID: 805840
Seq. Order: 11
Data Storage Type: VARCHAR
Max Length: 34
Required: No
Primary Key: No
Status: Active
Description:

Date(s) of data collection that the source material is based upon. | Description Source: NOAA ESI Guidelines

Allowed Values: Date fields must be YYYY, or YYYYMM, or YYYYMMDD. If date is not known or if the day is not of consequence, then it should be YYYYMM. The same is true if month is not known or is not of consequence, you would use YYYY. The beginning and ending date range is separated by a dash (-)

Catalog Details

Catalog Item ID: 55115
GUID: gov.noaa.nmfs.inport:55115
Metadata Record Created By: Jill Petersen
Metadata Record Created: 2018-12-06 15:28+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-02-25
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-02-25
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-02-25