Slide Menu
Jump to Section...
Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 6
View Report
ORR Metadata Library > Environmental Sensitivity Index > American Samoa, 2004 > American Samoa ESI: MGT (Management Area Polygo... >

SOC_DAT

Entity (ENT)  |  Office of Response and Restoration (ORR)
GUID: gov.noaa.nmfs.inport:42221  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: SOC_DAT
Short Name: 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: Research Planning, Inc.
Notes:

Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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
 TYPE VARCHAR Identifies the feature type | Description Source: Research Planning, Inc.
100
 NAME VARCHAR The feature name | Description Source: Research Planning, Inc.
100
 CONTACT VARCHAR Contact person or entity | Description Source: Research Planning, Inc.
100
 PHONE VARCHAR Contact telephone number | Description Source: Research Planning, Inc.
100
 G_SOURCE NUMBER Geographic source integer identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: Research Planning, Inc.
100
 A_SOURCE NUMBER Attribute source integer identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: Research Planning, Inc.

Attribute Details

HUNUM

CC ID: 538510
Seq. Order: 1
Data Storage Type: NUMBER
Required: No
Primary Key: No
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: 76000001 - 76000083

TYPE

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

Identifies the feature type | Description Source: Research Planning, Inc.
Allowed Values: AIRPORT: Airport | AQUACULTURE: Aquaculture Site | ARCHAEOLOGICAL SITE: Archaeological Site | BEACH: Beach | HISTORICAL SITE: Historical Site | MANAGEMENT AREA: Managment Area | MARINE SANCTUARY: Marine Sanctuary | NATIONAL LANDMARK: National Landmark | NATIONAL PARK: National Park | PARK: Park | SUBSISTENCE: Subsistence Collection Area | WILDLIFE REFUGE: Wildlife Refuge |

NAME

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

The feature name | Description Source: Research Planning, Inc.
Allowed Values: Any character: Free text |

CONTACT

CC ID: 538513
Seq. Order: 4
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Contact person or entity | Description Source: Research Planning, Inc.
Allowed Values: Any character: Free text |

PHONE

CC ID: 538514
Seq. Order: 5
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Contact telephone number | Description Source: Research Planning, Inc.
Allowed Values: Any character: Free text |

G_SOURCE

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

Geographic source integer identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: Research Planning, Inc.
Allowed Values: 1 - N

A_SOURCE

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

Attribute source integer identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: Research Planning, Inc.
Allowed Values: 1 - N

Catalog Details

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