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 An 8-digit 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: 818031
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 8
Min Length: 8
Required: Yes
Primary Key: Yes
Status: Active
Description:

An 8-digit 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: 22000001 - 22000443

ORIGINATOR

CC ID: 818026
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: 818024
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: 818033
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: 818023
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: 818029
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: 818028
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: 818027
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: 818025
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: 818030
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: 818032
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: 55485
GUID: gov.noaa.nmfs.inport:55485
Metadata Record Created By: David Moe Nelson
Metadata Record Created: 2019-02-04 14:58+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2019-02-15
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-02-16