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. The source records link to the SOC_DAT table through the SOURCE_ID field in the SOURCES table, and the G_SOURCE and A_SOURCE fields in the SOC_DAT table. See the Entity_and_Attribute_Overview for a detailed description of how the primary attribute tables relate to the geographic data layers. Also 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

Notes:

Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Alias: SOURCES
Description:

The data table SOURCES contains the primary sources used to create the ESI data set. The source records link to the BIOFILE through the SOURCE_ID field in the SOURCES table, and the G_SOURCE and S_SOURCE fields in the BIOFILE. See the Entity_and_Attribute_Overview for a detailed description of how the primary attribute tables relate to the geographic data layers. Also 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
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 VARCHAR 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) Online computer resource URL. | Description Source: NOAA ESI Guidelines
100
SCALE Unknown 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: 582704
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 8
Min Length: 8
Required: No
Primary Key: No
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: 28300001 - 28300999

ORIGINATOR

CC ID: 582699
Seq. Order: 2
Data Storage Type: Text
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: 582697
Seq. Order: 3
Data Storage Type: VARCHAR
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: YYYYMM: YYYY for year and optionally MM for month |

TITLE

CC ID: 582706
Seq. Order: 4
Data Storage Type: Text
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: 582696
Seq. Order: 5
Data Storage Type: Text
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: 582702
Seq. Order: 6
Data Storage Type: Text
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: 582701
Seq. Order: 7
Data Storage Type: Text
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: 582700
Seq. Order: 8
Data Storage Type: Text
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: 582698
Seq. Order: 9
Data Storage Type: Text (URL)
Required: No
Primary Key: No
Status: Active
Description:

Online computer resource URL. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

SCALE

CC ID: 582703
Seq. Order: 10
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: Acceptable values change from atlas to atlas.

TIME_PERIOD

CC ID: 582705
Seq. Order: 11
Data Storage Type: VARCHAR
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: Acceptable values change from atlas to atlas.

Access Information

Security Class: Unclassified

Catalog Details

Catalog Item ID: 47276
GUID: gov.noaa.nmfs.inport:47276
Metadata Record Created By: David Moe Nelson
Metadata Record Created: 2017-09-07 17:43+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-28
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-28
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-28