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.

Notes:

Loaded by FGDC Metadata Uploader, batch 10039, 09-25-2017 12:58

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: 892629
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: 20200001 - 20200803

ORIGINATOR

CC ID: 892624
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: 892622
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: 892631
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: 892621
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: 892627
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: 892626
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: 892623
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: 892625
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: 892628
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: 892630
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: 58476
GUID: gov.noaa.nmfs.inport:58476
Metadata Record Created By: David Moe Nelson
Metadata Record Created: 2020-01-09 15:20+0000
Metadata Record Last Modified By: Tyler Christensen
Metadata Record Last Modified: 2020-02-14 16:30+0000
Metadata Record Published: 2020-02-14
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-02-14