SOURCES
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:64926 | Updated: August 9, 2022 | Published / External
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
|
|
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. | |
|
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
| 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: | 18600001 - 18600321 |
ORIGINATOR
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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: | 64926 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:64926 |
| Metadata Record Created By: | Katy R Beckham |
| Metadata Record Created: | 2021-07-15 19:23+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2021-11-18 |
| Owner Org: | ORR |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2021-11-18 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2022-11-18 |