Slide Menu
Search Help Show/Hide Menu

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 BIOFILE table; SOURCE_ID and ESI_SOURCE in the ESIP and ESIL data layers, and SOURCE_ID in the HYDROL data layer. | Description Source: NOAA ESI Guidelines
100
ORIGINATOR TEXT 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 TEXT Title of source material or data. | Description Source: NOAA ESI Guidelines
100
DATA_FORMAT TEXT The format of the source material. | Description Source: NOAA ESI Guidelines
100
PUB_PLACE TEXT Publication place. | Description Source: NOAA ESI Guidelines
100
PUBLISHER TEXT Publisher. | Description Source: NOAA ESI Guidelines
100
PUBLICATION TEXT Additional citation information. | Description Source: NOAA ESI Guidelines
100
ONLINE_LINK TEXT URL to the data if internet-available or to the website of the data provider | Description Source: NOAA ESI Guidelines
100
SCALE TEXT Description of the source scale. | Description Source: NOAA ESI Guidelines
100
TIME_PERIOD TEXT Date(s) of data collection that the source material is based upon. | Description Source: NOAA ESI Guidelines

Attribute Details

SOURCE_ID

CC ID: 817733
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 BIOFILE table; SOURCE_ID and ESI_SOURCE in the ESIP and ESIL data layers, and SOURCE_ID in the HYDROL data layer. | Description Source: NOAA ESI Guidelines

Allowed Values: 28500001 - 28500806

ORIGINATOR

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

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

Case Restriction: Upper
Allowed Values: Acceptable values change from atlas to atlas.

DATE_PUB

CC ID: 817726
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 8
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: 817735
Seq. Order: 4
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

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

Case Restriction: Upper
Allowed Values: Acceptable values change from atlas to atlas.

DATA_FORMAT

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

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

Case Restriction: Upper
Allowed Values: Acceptable values change from atlas to atlas. Examples include DOCUMENT, EXPERT KNOWLEDGE, VECTOR DIGITAL DATA...

PUB_PLACE

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

Publication place. | Description Source: NOAA ESI Guidelines

Case Restriction: Upper
Allowed Values: Acceptable values change from atlas to atlas.

PUBLISHER

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

Publisher. | Description Source: NOAA ESI Guidelines

Case Restriction: Upper
Allowed Values: Acceptable values change from atlas to atlas.

PUBLICATION

CC ID: 817729
Seq. Order: 8
Data Storage Type: TEXT
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: 817727
Seq. Order: 9
Data Storage Type: TEXT
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:// or https:// in LOWER CASE) & contain no “<” or “>” characters

SCALE

CC ID: 817732
Seq. Order: 10
Data Storage Type: TEXT
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: 817734
Seq. Order: 11
Data Storage Type: TEXT
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. The beginning and ending date range is separated by a dash (-)

Catalog Details

Catalog Item ID: 55451
GUID: gov.noaa.nmfs.inport:55451
Metadata Record Created By: David Moe Nelson
Metadata Record Created: 2019-02-04 10:50+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-02-14
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-02-14
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-02-14