Metadata Rubric

100%

6 / 6

ORR Metadata Library > Environmental Sensitivity Index > Great Lakes - St.Lawrence River ESI, 2021 > GL_St_Lawrence_River_2021 ESI NAVIGATIONAL/MARI... >

SOC_DAT

Entity (ENT) | Office of Response and Restoration (ORR)
GUID: gov.noaa.nmfs.inport:65024 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	SOC_DAT
Status:	Completed
Publication Date:	2021-07
Abstract:	The data table SOC_DAT contains human-use attribute data, and fields for linking to the human-use spatial data layers and to the SOURCES data table. 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

Entity Information

Entity Type:	Data Table
Description:	The SOC_DAT table contains all attributes pertaining to the human-use features, as well as links to the SOURCES table with object-level source information.

Data Attributes

Attribute Summary

	Name	Type	Description
100	HUNUM	NUMBER	An 9-digit identifier that links records in the SOC_DAT data table to the feature records in the vector data tables. \| Description Source: NOAA ESI Guidelines
100	MAPHUN	NUMBER	An identifier that is used in map production for legibility. This number is the same as HUNUM without the atlas specific prefix. \| Description Source: Research Planning, Inc.
100	ELEMENT	TEXT	Category of human use feature. (POLITICAL, MANAGED, RESOURCE, NAT_HAZARD, NAV_MARINE, SOCECON)
100	TYPE	TEXT	The value of the abbreviated type found in the feature class attribute table. The human-use features depicted in the data set are those that could be impacted by an oil spill, could provide access for response operations, or may themselves pose a risk for an environmentally hazardous release. \| Description Source: NOAA ESI Guidelines
100	NAME	TEXT	The name of the mapped resource, such as park name, facility name, etc. \| Description Source: NOAA ESI Guidelines
100	CONTACT	TEXT	Person (position or name) or agency responsible for the resource. \| Description Source: NOAA ESI Guidelines
100	PHONE	TEXT	Contact telephone number. \| Description Source: NOAA ESI Guidelines
100	LINK	TEXT	Link to the resource web-page. A URL. Must be copied as is from the address bar and must be fully qualified (begin with http://, and contain no "<" or ">" characters.
100	G_SOURCE	NUMBER	An 8-digit identifier that links to the geographic source records in the SOURCES data table. Source values in the SOC_DAT table (prior to concatenation to the Atlas ID) are in the range of 101 - 300. This number is than added to the atlas number * 100,000 to generate a number unique across all ESI atlases. \| Description Source: NOAA ESI Guidelines
100	A_SOURCE	NUMBER	An 8-digit identifier that links to the geographic source records in the SOURCES data table. Source values in the SOC_DAT table (prior to concatenation to the Atlas ID) are in the range of 101 - 300. This number is than added to the atlas number * 100,000 to generate a number unique across all ESI atlases. \| Description Source: NOAA ESI Guideline

Name

Type

Description

100

HUNUM

NUMBER

An 9-digit identifier that links records in the SOC_DAT data table to the feature records in the vector data tables. | Description Source: NOAA ESI Guidelines

100

MAPHUN

NUMBER

An identifier that is used in map production for legibility. This number is the same as HUNUM without the atlas specific prefix. | Description Source: Research Planning, Inc.

100

ELEMENT

TEXT

Category of human use feature. (POLITICAL, MANAGED, RESOURCE, NAT_HAZARD, NAV_MARINE, SOCECON)

100

TYPE

TEXT

The value of the abbreviated type found in the feature class attribute table. The human-use features depicted in the data set are those that could be impacted by an oil spill, could provide access for response operations, or may themselves pose a risk for an environmentally hazardous release. | Description Source: NOAA ESI Guidelines

100

NAME

TEXT

The name of the mapped resource, such as park name, facility name, etc. | Description Source: NOAA ESI Guidelines

100

CONTACT

TEXT

Person (position or name) or agency responsible for the resource. | Description Source: NOAA ESI Guidelines

100

PHONE

TEXT

Contact telephone number. | Description Source: NOAA ESI Guidelines

100

LINK

TEXT

Link to the resource web-page. A URL. Must be copied as is from the address bar and must be fully qualified (begin with http://, and contain no "<" or ">" characters.

100

G_SOURCE

NUMBER

An 8-digit identifier that links to the geographic source records in the SOURCES data table. Source values in the SOC_DAT table (prior to concatenation to the Atlas ID) are in the range of 101 - 300. This number is than added to the atlas number * 100,000 to generate a number unique across all ESI atlases. | Description Source: NOAA ESI Guidelines

100

A_SOURCE

NUMBER

Attribute Details

HUNUM

CC ID: 1075203

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	9
Min Length:	9
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	An 9-digit identifier that links records in the SOC_DAT data table to the feature records in the vector data tables. \| Description Source: NOAA ESI Guidelines
Allowed Values:	18700001 - 18700254

MAPHUN

CC ID: 1075205

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	9
Min Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	An identifier that is used in map production for legibility. This number is the same as HUNUM without the atlas specific prefix. \| Description Source: Research Planning, Inc.
Allowed Values:	1 - 254

ELEMENT

CC ID: 1075201

Seq. Order:	3
Data Storage Type:	TEXT
Max Length:	10
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Category of human use feature. (POLITICAL, MANAGED, RESOURCE, NAT_HAZARD, NAV_MARINE, SOCECON)
Case Restriction:	Upper
Allowed Values:	POLITICAL: Political/Jurisdictional Management \| MANAGED: Parks/Managed Areas \| RESOURCE: Resource Management \| NAT_HAZARD: Natural Hazard \| NAV_MARINE: Navigation/Marine \| SOCECON: Other Socecon Features.

TYPE

CC ID: 1075208

Seq. Order:	4
Data Storage Type:	TEXT
Max Length:	35
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The value of the abbreviated type found in the feature class attribute table. The human-use features depicted in the data set are those that could be impacted by an oil spill, could provide access for response operations, or may themselves pose a risk for an environmentally hazardous release. \| Description Source: NOAA ESI Guidelines
Case Restriction:	Upper
Allowed Values:	ABANDONED VESSEL: abandoned vessel \|AIRPORT: airport \|ANCHORAGE: anchorage \| ARTIFICIAL REEF: artificial reef \| BEACH: beach \| BOAT RAMP: boat ramp \| ESSENTIAL HABITAT: essential habitat \|HELIPORT: heliport \| HISTORICAL SITE: historical site\| INTERNATIONAL BORDER: international border \| LOCK AND DAM: lock and dam \| MANAGEMENT AREA: management area \| MARINA: marina \| NATURE CONSERVANCY: nature conservancy\| PARK: park\| PIPELINE: pipeline \| PORT: port \| RECREATIONAL FISHING: recreational fishing \| TRIBAL LAND: tribal land \| WATER INTAKE: water intake.

NAME

CC ID: 1075206

Seq. Order:	5
Data Storage Type:	TEXT
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	The name of the mapped resource, such as park name, facility name, etc. \| Description Source: NOAA ESI Guidelines
Case Restriction:	Upper
Allowed Values:	Acceptable values change from atlas to atlas.

CONTACT

CC ID: 1075200

Seq. Order:	6
Data Storage Type:	TEXT
Max Length:	80
Required:	No
Primary Key:	No
Status:	Active
Description:	Person (position or name) or agency responsible for the resource. \| Description Source: NOAA ESI Guidelines
Case Restriction:	Upper
Allowed Values:	Acceptable values change from atlas to atlas.

PHONE

CC ID: 1075207

Seq. Order:	7
Data Storage Type:	TEXT
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	Contact telephone number. \| Description Source: NOAA ESI Guidelines
Allowed Values:	xxx-xxx-xxxx

LINK

CC ID: 1075204

Seq. Order:	8
Data Storage Type:	TEXT
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Link to the resource web-page. A URL. Must be copied as is from the address bar and must be fully qualified (begin with http://, and contain no "<" or ">" characters.
Case Restriction:	Mixed
Allowed Values:	Values vary from atlas to atlas.

G_SOURCE

CC ID: 1075202

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	8
Min Length:	8
Required:	Yes
Primary Key:	No
Status:	Active
Description:	An 8-digit identifier that links to the geographic source records in the SOURCES data table. Source values in the SOC_DAT table (prior to concatenation to the Atlas ID) are in the range of 101 - 300. This number is than added to the atlas number * 100,000 to generate a number unique across all ESI atlases. \| Description Source: NOAA ESI Guidelines
Allowed Values:	18700101 - 18700120

A_SOURCE

CC ID: 1075199

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	8
Min Length:	8
Required:	Yes
Primary Key:	No
Status:	Active
Description:	An 8-digit identifier that links to the geographic source records in the SOURCES data table. Source values in the SOC_DAT table (prior to concatenation to the Atlas ID) are in the range of 101 - 300. This number is than added to the atlas number * 100,000 to generate a number unique across all ESI atlases. \| Description Source: NOAA ESI Guideline
Allowed Values:	18700101 - 18700120

Catalog Details

Catalog Item ID:	65024
GUID:	gov.noaa.nmfs.inport:65024
Metadata Record Created By:	Katy R Beckham
Metadata Record Created:	2021-07-19 20:03+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2021-11-17
Owner Org:	ORR
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-11-17
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-11-17