SOC_DAT
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:67712 | Updated: November 21, 2022 | Published / External
Item Identification
Title: | SOC_DAT |
---|---|
Status: | Completed |
Publication Date: | 2022-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
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
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
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: | 21700001 - 21700910 |
MAPHUN
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 - 910 |
ELEMENT
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
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| ANCHORAGE: anchorage| ARTIFICIAL REEF: artificial reef| BEACH: beach | BOAT RAMP: boat ramp |COAST GUARD: coast guard| CRITICAL HABITAT: critical habitat| ESSENTIAL HABITAT: essential habitat |FERRY: ferry| HELIPORT: heliport | HISTORICAL SITE: historical site| INTERNATIONAL BORDER: international border | LOCK AND DAM: lock and dam | MANAGEMENT AREA: management area | MARINA: marina | NATIONAL PARK: national park| NATURE CONSERVANCY: nature conservancy| PARK: park| PORT: port | RECREATIONAL FISHING: recreational fishing | STATE: state|TRIBAL LAND: tribal land | WATER INTAKE: water intake | WILDLIFE REFUGE: wildlife refuge. |
NAME
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
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
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
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
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: | 21700101 - 21700135 |
A_SOURCE
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: | 21700101 - 21700135 |
Catalog Details
Catalog Item ID: | 67712 |
---|---|
GUID: | gov.noaa.nmfs.inport:67712 |
Metadata Record Created By: | Katy R Beckham |
Metadata Record Created: | 2022-08-18 14:17+0000 |
Metadata Record Last Modified By: | Adam Rotert |
Metadata Record Last Modified: | 2022-11-21 20:16+0000 |
Metadata Record Published: | 2022-11-21 |
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 |