Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
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

Rubric Score Primary Key? Name Type Description
100
 Primary Key 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

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