Search Help Show/Hide Menu
Summary
Item Identification
Data Attributes
Catalog Details

Summary

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.

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
TYPE
VARCHAR
Identifies the feature type | Description Source: Research Planning, Inc.
NAME
VARCHAR
The feature name | Description Source: Research Planning, Inc.
CONTACT
VARCHAR
Contact person or entity | Description Source: Research Planning, Inc.
PHONE
VARCHAR
Contact telephone number | Description Source: Research Planning, Inc.
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.
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.

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
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: 559570
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: 74000003 - 74000032

TYPE

CC ID: 559571
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 | CRITICAL HABITAT: Designated Critical Habitat | MINE SITE: Mine Site | PARK: Park | SCENIC RIVER: Scenic River | WILDLIFE REFUGE: Wildlife Refuge |

NAME

CC ID: 559572
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: 559573
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: 559574
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: 559575
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: 559576
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: 45190
GUID: gov.noaa.nmfs.inport:45190
Metadata Record Created By: Tyler Christensen
Metadata Record Created: 2017-04-06 11:43+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-08-08
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-08-08
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-08-08