Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
ORR Metadata Library > Environmental Sensitivity Index > Great Lakes - Lake Ontario ESI, 2023 > GL_LAKE_ONTARIO_2023 ESI NAVIGATIONAL/MARINE Po... >

SOC_DAT

Entity (ENT)  |  Office of Response and Restoration (ORR)
GUID: gov.noaa.nmfs.inport:70544  |  Updated: September 26, 2023  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
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
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.
ELEMENT
TEXT 		Category of human use feature. (POLITICAL, MANAGED, RESOURCE, NAT_HAZARD, NAV_MARINE, SOCECON)
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
NAME
TEXT 		The name of the mapped resource, such as park name, facility name, etc. | Description Source: NOAA ESI Guidelines
CONTACT
TEXT 		Person (position or name) or agency responsible for the resource. | Description Source: NOAA ESI Guidelines
PHONE
TEXT 		Contact telephone number. | Description Source: NOAA ESI Guidelines
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.
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
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

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
Publication Date: 2023-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

Rubric Score Primary Key? Name Type Description
100
 Primary Key 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

CC ID: 1266998
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: 21100001 - 21100404

MAPHUN

CC ID: 1267000
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 - 404

ELEMENT

CC ID: 1266996
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

CC ID: 1267003
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| AIRPORT: airport | ANCHORAGE: anchorage| AQUACULTURE: aquaculture | ARTIFICIAL REEF: artificial reef| BEACH: beach | BOAT RAMP: boat ramp |COAST GUARD: coast guard| CRITICAL HABITAT: critical habitat| ESSENTIAL HABITAT: essential habitat |HELIPORT: heliport | HISTORICAL SITE: historical site| INTERNATIONAL BORDER: international border | LOCK AND DAM: lock and dam | MANAGEMENT AREA: management area | MARINA: marina | NATURE CONSERVANCY: nature conservancy| PARK: park| PIPELINE: pipeline | RECREATIONAL FISHING: recreational fishing | WATER INTAKE: water intake.

NAME

CC ID: 1267001
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

CC ID: 1266995
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

CC ID: 1267002
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

CC ID: 1266999
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

CC ID: 1266997
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: 21100101 - 21100118

A_SOURCE

CC ID: 1266994
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: 21100101 - 21100118

Catalog Details

Catalog Item ID: 70544
GUID: gov.noaa.nmfs.inport:70544
Metadata Record Created By: Katy R Beckham
Metadata Record Created: 2023-08-16 19:17+0000
Metadata Record Last Modified By: Adam Rotert
Metadata Record Last Modified: 2023-09-26 15:18+0000
Metadata Record Published: 2023-09-26
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