Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: SOCECON.PAT
Short Name: SOCECON.PAT
Status: Completed
Abstract:

The SOCECON.PAT table contains attribute information for the vector points representing access points, aquaculture sites, airports, artificial reefs, boat ramps, coast guard stations, heliports, historical sites, lock and dam sites, marinas, and water intakes. Note that all attribute information is stored in a series of relational files, described below and in the Overview_Description section. See the Browse_Graphic section for a link to the entity-relationship diagram, which describes the relationships between attribute tables in the ESI data structure. | Description Source: NOAA ESI Guidelines

Notes:

Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TYPE VARCHAR The human-use features depicted on the maps are those that could be impacted by an oil spill or could prove useful for response operations. TYPE can be used as a quick identifier for socioeconomic point features and is the attribute that is used to symbolize the layer. Greater detail about the object is provided in the SOC_DAT table. | Description Source: NOAA ESI Guidelines
100
ID NUMBER An identifier that links vector objects in the human-use data layers to records in the SOC_LUT data table. ID is a concatenation of atlas number (213), element number (10), and record number. | Description Source: NOAA
100
HUNUM NUMBER An identifier that links directly to the SOC_DAT table. | Description Source: NOAA

Attribute Details

TYPE

CC ID: 561567
Seq. Order: 1
Data Storage Type: VARCHAR
Required: No
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 prove useful for response operations. TYPE can be used as a quick identifier for socioeconomic point features and is the attribute that is used to symbolize the layer. Greater detail about the object is provided in the SOC_DAT table. | Description Source: NOAA ESI Guidelines

Allowed Values: A: Airport | A2: Access | AQ: Aquaculture | AR: Artificial Reef | BR: Boat Ramp | CG: Coast Guard | HP: Heliport | HS: Historical Site | LD: Lock and Dam | M: Marina | WI: Water Intake |

ID

CC ID: 561568
Seq. Order: 2
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

An identifier that links vector objects in the human-use data layers to records in the SOC_LUT data table. ID is a concatenation of atlas number (213), element number (10), and record number. | Description Source: NOAA

Allowed Values: 2131000001 - 2131000447

HUNUM

CC ID: 561569
Seq. Order: 3
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

An identifier that links directly to the SOC_DAT table. | Description Source: NOAA

Allowed Values: 213000001 - 213000349

Catalog Details

Catalog Item ID: 45453
GUID: gov.noaa.nmfs.inport:45453
Metadata Record Created By: Tyler Christensen
Metadata Record Created: 2017-04-06 11:44+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-08-10
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-08-10
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-08-10