Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
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
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.
ELEMENT
TEXT
Category of human use feature. (POLITICAL, MANAGED, RESOURCE, NAT_HAZARD, NAV_MARINE, SOCECON)
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
NAME
TEXT
The name of the mapped resource, such as park name, facility name, etc. | Description Source: NOAA ESI Guidelines
CONTACT
TEXT
Person (position or name) or agency responsible for the resource. | Description Source: NOAA ESI Guidelines
PHONE
TEXT
Contact telephone number. | Description Source: NOAA ESI Guidelines
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.
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
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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (ORR) for inquiries on this record.

Item Identification

Title: SOC_DAT
Status: Completed
Publication Date: 2023-08
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: 1266998
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: 21100001 - 21100404

MAPHUN

CC ID: 1267000
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 - 404

ELEMENT

CC ID: 1266996
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: 1267003
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: ACCESS: access| AIRPORT: airport | ANCHORAGE: anchorage| AQUACULTURE: aquaculture | ARTIFICIAL REEF: artificial reef| BEACH: beach | BOAT RAMP: boat ramp |COAST GUARD: coast guard| CRITICAL HABITAT: critical habitat| 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 | RECREATIONAL FISHING: recreational fishing | WATER INTAKE: water intake.

NAME

CC ID: 1267001
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: 1266995
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: 1267002
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: 1266999
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: 1266997
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: 21100101 - 21100118

A_SOURCE

CC ID: 1266994
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: 21100101 - 21100118

Catalog Details

Catalog Item ID: 70544
GUID: gov.noaa.nmfs.inport:70544
Metadata Record Created By: Katy R Beckham
Metadata Record Created: 2023-08-16 19:17+0000
Metadata Record Last Modified By: Adam Rotert
Metadata Record Last Modified: 2023-09-26 15:18+0000
Metadata Record Published: 2023-09-26
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