Slide Menu
Search Help Show/Hide Menu

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: 1075123
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: 1075125
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: 1075121
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: 1075128
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: 1075126
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: 1075120
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: 1075127
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: 1075124
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: 1075122
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: 1075119
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: 65017
GUID: gov.noaa.nmfs.inport:65017
Metadata Record Created By: Katy R Beckham
Metadata Record Created: 2021-07-19 19:40+0000
Metadata Record Last Modified By: Brianna Key
Metadata Record Last Modified: 2021-11-17 21:57+0000
Metadata Record Published: 2021-11-17
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year