SOC_DAT
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:65005 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | SOC_DAT |
|---|---|
| Status: | Completed |
| Publication Date: | 2021-07 |
| 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
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
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
| 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: | 18600001 - 18600086 |
MAPHUN
| 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 - 86 |
ELEMENT
| 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
| 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: | ABANDONED VESSEL: abandoned vessel |AIRPORT: airport |ANCHORAGE: anchorage | AQUACULTURE: aquaculture | ARCHAEOLOGICAL SITE: archaeological site | ARTIFICIAL REEF: artificial reef | BEACH: beach | BOAT RAMP: boat ramp |COAST GUARD: coast guard | ESSENTIAL HABITAT: essential habitat | FERRY: ferry | HISTORICAL SITE: historical site| INTERNATIONAL BORDER; international border | LOCK AND DAM: lock and dam | MANAGEMENT AREA: management area | MARINA: marina | NATIONAL FOREST: national forest | NATURE CONSERVANCY: nature conservancy| PARK: park | PIPELINE: pipeline | RAIL ROUTE: rail route | RECREATIONAL FISHING: recreational fishing | SUBSISTENCE: subsistence | TRIBAL LAND: tribal land | WATER INTAKE: water intake. |
NAME
| 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
| 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
| 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
| 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
| 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: | 18600101 - 18600125 |
A_SOURCE
| 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: | 18600101 - 18600125 |
Catalog Details
| Catalog Item ID: | 65005 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:65005 |
| Metadata Record Created By: | Katy R Beckham |
| Metadata Record Created: | 2021-07-19 18:52+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2021-11-18 |
| Owner Org: | ORR |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2021-11-18 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2022-11-18 |