SOURCES
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:55255 | 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. | Description Source: NOAA ESI Guidelines |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
SOURCE_ID | NUMBER | 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 BIORES table; and SOURCE_ID and ESI_Source in the ESI and HYDRO data layers. | Description Source: NOAA ESI Guidelines |
|
100
|
ORIGINATOR | VARCHAR | 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 | VARCHAR | Title of source material or data. | Description Source: NOAA ESI Guidelines | |
|
100
|
DATA_FORMAT | VARCHAR | The format of the source material. | Description Source: NOAA ESI Guidelines | |
|
100
|
PUB_PLACE | VARCHAR | Publication place. | Description Source: NOAA ESI Guidelines | |
|
100
|
PUBLISHER | VARCHAR | Publisher. | Description Source: NOAA ESI Guidelines | |
|
100
|
PUBLICATION | VARCHAR | Additional citation information. | Description Source: NOAA ESI Guidelines | |
|
100
|
ONLINE_LINK | VARCHAR | URL to the data if internet-available or to the website of the data provider | Description Source: NOAA ESI Guidelines | |
|
100
|
SCALE | VARCHAR | 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
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 7 |
| Min Length: | 7 |
| Required: | Yes |
| Primary Key: | Yes |
| Status: | Active |
| Description: |
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 BIORES table; and SOURCE_ID and ESI_Source in the ESI and HYDRO data layers. | Description Source: NOAA ESI Guidelines |
| Allowed Values: | 8000002-8000611 |
ORIGINATOR
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR |
| Max Length: | 255 |
| 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
| 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. | Description Source: NOAA ESI Guidelines |
| Allowed Values: | YYYY, or YYYYMM, or YYYYMMDD, where Y=year, M=month, D=day |
TITLE
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR |
| Max Length: | 255 |
| 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
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR |
| Max Length: | 80 |
| 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
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR |
| Max Length: | 255 |
| 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
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR |
| Max Length: | 255 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Publisher. | Description Source: NOAA ESI Guidelines |
| Allowed Values: | Acceptable values change from atlas to atlas. |
PUBLICATION
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR |
| 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
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR |
| 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://) & contain no “<” or “>” characters |
SCALE
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR |
| 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
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR |
| 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. If date is not known or if the day is not of consequence, then it should be YYYYMM. The same is true if month is not known or is not of consequence, you would use YYYY. The beginning and ending date range is separated by a dash (-) |
Catalog Details
| Catalog Item ID: | 55255 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:55255 |
| Metadata Record Created By: | Jill Petersen |
| Metadata Record Created: | 2018-12-13 18:58+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2019-03-08 |
| Owner Org: | ORR |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2019-03-08 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2020-03-08 |