Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: SOC_DAT
Status: Completed
Publication Date: 2019-09
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 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
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: 894443
Seq. Order: 1
Data Storage Type: NUMBER
Required: Yes
Primary Key: Yes
Status: Active
Description:

An 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: 20300001 – 20301459

ELEMENT

CC ID: 894441
Seq. Order: 2
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: 894447
Seq. Order: 3
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 | ACCESS: access| AIRPORT: airport |ANCHORAGE: anchorage | ARCHAEOLOGICAL SITE: archaeological site | ARMY CORPS OF ENGINEERS: army corps of engineers| ARTIFICIAL REEF: artificial reef | BEACH: beach | BOAT RAMP: boat ramp | CAMPGROUND: campground | CITY: city | COAST GUARD: coast guard | COUNTY: county | CRITICAL HABITAT: critical habitat | EPA FACILITY: epa facility | ESSENTIAL HABITAT: essential habitat | FEMA REGION: fema region | FERRY: ferry | FERRY ROUTE: ferry route | FISHERY AREA: fishery area | HELIPORT: heliport | HISTORICAL SITE: historical site| INVASIVE SPECIES: invasive species | LOCK AND DAM: lock and dam | MANAGEMENT AREA: management area | MARINA: marina | MARINE SANCTUARY: marine sanctuary | MILITARY: military | MINE SITE: mine site | NATIONAL FOREST: national forest | NATIONAL PARK: national park | NATURE CONSERVANCY: nature conservancy| PARK: park| PIPELINE: pipeline | PORT: port | RAIL ROUTE: rail route | RECREATIONAL FISHING: recreational fishing | RENEWABLE ENERGY: renewable energy | REPEATED MEASUREMENT SITE: repeated measurement site | ROAD: road | STATE PROTECTED AREA: state protected area | STORM SURGE INUNDATION AREA: storm surge inundation area | SUBSISTENCE: subsistence | TRIBAL LAND: tribal land | WATER INTAKE: water intake | WILDLIFE REFUGE: wildlife refuge.

NAME

CC ID: 894445
Seq. Order: 4
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: 894440
Seq. Order: 5
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: 894446
Seq. Order: 6
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: 894444
Seq. Order: 7
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: 894442
Seq. Order: 8
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: 20300001 – 20300803

A_SOURCE

CC ID: 894439
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 Guideline

Allowed Values: 20300001 – 20300803

Activity Log

Activity Log 1

CC ID: 894448
Activity Date/Time: 2018-10-17
Responsible Party: Tyler Christensen
Description:

Converted from FGDC/CSDGM via XSLT.

Catalog Details

Catalog Item ID: 58635
GUID: gov.noaa.nmfs.inport:58635
Metadata Record Created By: David Moe Nelson
Metadata Record Created: 2020-01-15 11:52+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2020-02-14
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2020-02-14
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2021-02-14