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.

Entity Information

Entity Type: Data Table
Description:

All ESI feature classes – the biology, socioeconomic, and the base ESI and HYDRO layers, share the SOURCES table. This is where feature and attribute specific metadata resides. In addition to providing citations for the ESI data, the SOURCES table can help users identify regional experts.

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.
100
DATE_PUB NUMBER Date of source material, publication, or date of personal communication with expert source.
100
TITLE TEXT Title of source material or data.
100
DATA_FORMAT TEXT The format of the source material.
100
PUB_PLACE TEXT Publication place.
100
PUBLISHER TEXT Publisher.
100
ONLINE_LINK TEXT Online resource URL.
100
PUBLICATION TEXT Additional citation information.
100
SCALE TEXT Description of the source scale.
100
TIME_PERIOD TEXT Date(s) of data collection that the source material is based upon.

Attribute Details

SOURCE_ID

CC ID: 1074292
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: 18700001 - 18700339

ORIGINATOR

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

Allowed Values: Acceptable values change from atlas to atlas.

DATE_PUB

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

Allowed Values: YYYY, YYYYMM, YYYYMMDD

TITLE

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

Title of source material or data.

Allowed Values: Acceptable values change from atlas to atlas.

DATA_FORMAT

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

The format of the source material.

Allowed Values: Acceptable values change from atlas to atlas.

PUB_PLACE

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

Publication place.

Allowed Values: Acceptable values change from atlas to atlas.

PUBLISHER

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

Publisher.

Allowed Values: Acceptable values change from atlas to atlas.

ONLINE_LINK

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

Online resource URL.

Allowed Values: Acceptable values change from atlas to atlas.

PUBLICATION

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

Additional citation information.

Allowed Values: Acceptable values change from atlas to atlas.

SCALE

CC ID: 1074291
Seq. Order: 9
Data Storage Type: TEXT
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Description of the source scale.

Allowed Values: Acceptable values change from atlas to atlas.

TIME_PERIOD

CC ID: 1074293
Seq. Order: 10
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.

Allowed Values: Acceptable values change from atlas to atlas.

Catalog Details

Catalog Item ID: 64981
GUID: gov.noaa.nmfs.inport:64981
Metadata Record Created By: Katy R Beckham
Metadata Record Created: 2021-07-19 15:14+0000
Metadata Record Last Modified By: Brianna Key
Metadata Record Last Modified: 2021-11-17 21:59+0000
Metadata Record Published: 2021-11-17
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year