SOC_DAT
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:55135 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
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
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
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
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
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
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
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
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
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
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: | 55135 |
---|---|
GUID: | gov.noaa.nmfs.inport:55135 |
Metadata Record Created By: | Jill Petersen |
Metadata Record Created: | 2018-12-07 18:05+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 |