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

Summary

Abstract

The data table SOC_DAT contains both human-use attribute data and items necessary for linking the human-use spatial data layers 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

Data Attribute / Type Description
HUNUM
NUMBER
An identifier that links records in the SOC_DAT data table to records in the SOC_LUT data table. | Description Source: NOAA
ELEMENT
VARCHAR
Category of the human-use features. | Description Source: NOAA ESI Guidelines
TYPE
VARCHAR
The human-use features depicted on the maps are those that could be impacted by an oil spill or could provide access for response operations. | Description Source: NOAA ESI Guidelines
NAME
VARCHAR
The feature name. | Description Source: NOAA ESI Guidelines
CONTACT
VARCHAR
Contact person or entity. | Description Source: NOAA ESI Guidelines
PHONE
VARCHAR
Contact telephone number. | Description Source: NOAA ESI Guidelines
LINK
VARCHAR
Link to the resource web-page. | Description Source: NOAA ESI Guidelines
G_SOURCE
NUMBER
Geographic source identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: NOAA ESI Guidelines
A_SOURCE
NUMBER
Attribute source identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: NOAA ESI Guidelines

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
Abstract:

The data table SOC_DAT contains both human-use attribute data and items necessary for linking the human-use spatial data layers 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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key HUNUM NUMBER An identifier that links records in the SOC_DAT data table to records in the SOC_LUT data table. | Description Source: NOAA
100
ELEMENT VARCHAR Category of the human-use features. | Description Source: NOAA ESI Guidelines
100
TYPE VARCHAR The human-use features depicted on the maps are those that could be impacted by an oil spill or could provide access for response operations. | Description Source: NOAA ESI Guidelines
100
NAME VARCHAR The feature name. | Description Source: NOAA ESI Guidelines
100
CONTACT VARCHAR Contact person or entity. | Description Source: NOAA ESI Guidelines
100
PHONE VARCHAR Contact telephone number. | Description Source: NOAA ESI Guidelines
100
LINK VARCHAR Link to the resource web-page. | Description Source: NOAA ESI Guidelines
100
G_SOURCE NUMBER Geographic source identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: NOAA ESI Guidelines
100
A_SOURCE NUMBER Attribute source identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: NOAA ESI Guidelines

Attribute Details

HUNUM

CC ID: 805998
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 8
Min Length: 8
Required: Yes
Primary Key: Yes
Status: Active
Description:

An identifier that links records in the SOC_DAT data table to records in the SOC_LUT data table. | Description Source: NOAA

Allowed Values: 23600001-23600739

ELEMENT

CC ID: 805996
Seq. Order: 2
Data Storage Type: VARCHAR
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Category of the human-use features. | Description Source: NOAA ESI Guidelines

Allowed Values: POLITICAL: Political/Jurisdictional management | MANAGED: Parks/Managed areas | RESOURCE: Resource management | NAT_HAZARD: Natural hazard | NAV_MARINE: Navigation/Marine - recreational/Maritime | SOCECON: Other socioeconomic features

TYPE

CC ID: 806002
Seq. Order: 3
Data Storage Type: VARCHAR
Max Length: 35
Required: Yes
Primary Key: No
Status: Active
Description:

The human-use features depicted on the maps are those that could be impacted by an oil spill or could provide access for response operations. | Description Source: NOAA ESI Guidelines

Allowed Values: ABANDONED VESSEL: Abandoned Vessel | ACCESS: Access | AIRPORT: Airport | ANCHORAGE: Anchorage | ARMY CORPS OF ENGINEERS: Army Corps of Engineers | ARTIFICIAL REEF: Artificial Reef | BEACH: Beach | BOAT RAMP: Boat Ramp | COAST GUARD: Coast Guard Station, District, or Sector | COMMERCIAL FISHING: Commercial Fishing | COUNTY: County Border | CRITICAL HABITAT: Critical Habitat | EPA FACILITY: EPA Facility | EPA REGION: EPA Regions | FEMA REGION: FEMA Region | FISHERY AREA: Fishery Area | HELIPORT: Heliport | HISTORICAL SITE: Historical Site or Area | MANAGEMENT AREA: Management Area | MARINA: Marina | MARINE SANCTUARY: Marine Sanctuary | MILITARY: Military | NATIONAL ESTUARINE RESEARCH RESERVE: National Estuarine Research Reserve | NATIONAL GUARD: National Guard | NATIONAL PARK: National Park | NATURE CONSERVANCY: Nature Conservancy | PARK: Regional or State Park | PORT: Port | RAIL ROUTE: Rail Route | RECREATIONAL FISHING: Recreational Fishing | RENEWABLE ENERGY: Renewable Energy | REPEATED MEASUREMENT SITE: Repeated Measurement Site/Area | RIVER MILE: River Mile | SHIPPING LANE: Shipping Lane | WASH OVER: Wash Over | WASTE DISPOSAL: Waste Disposal | WATER INTAKE: Water Intake | WILDLIFE REFUGE: Wildlife Refuge

NAME

CC ID: 806000
Seq. Order: 4
Data Storage Type: VARCHAR
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The feature name. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

CONTACT

CC ID: 805995
Seq. Order: 5
Data Storage Type: VARCHAR
Max Length: 80
Required: No
Primary Key: No
Status: Active
Description:

Contact person or entity. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

PHONE

CC ID: 806001
Seq. Order: 6
Data Storage Type: VARCHAR
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Contact telephone number. | Description Source: NOAA ESI Guidelines

Allowed Values: ###-###-####

LINK

CC ID: 805999
Seq. Order: 7
Data Storage Type: VARCHAR
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Link to the resource web-page. | 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

G_SOURCE

CC ID: 805997
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 8
Min Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

Geographic source identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: NOAA ESI Guidelines

Allowed Values: 23600001-23600509

A_SOURCE

CC ID: 805994
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 8
Min Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

Attribute source identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: NOAA ESI Guidelines

Allowed Values: 23600001-23600509

Catalog Details

Catalog Item ID: 55128
GUID: gov.noaa.nmfs.inport:55128
Metadata Record Created By: Jill Petersen
Metadata Record Created: 2018-12-06 17:59+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-02-25
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-02-25
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-02-25