SOC_DAT
Office of Response and Restoration
Entity
(ENT)
| ID: 54951
| Published / External
Created: 2018-11-27
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 54949
ID: 54951
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | SOC_DAT |
---|---|
Short Name | |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » 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: NOAA ESI Guidelines |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description | |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | Yes | 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 | Yes | No | ELEMENT | VARCHAR | Category of the human-use features. | Description Source: NOAA ESI Guidelines |
100 | Yes | No | TYPE | VARCHAR | The human-use features depicted on the maps are those that could be impacted by an oil spill or could provide access for response operations. | Description Source: NOAA ESI Guidelines |
100 | No | No | NAME | VARCHAR | The feature name. | Description Source: NOAA ESI Guidelines |
100 | No | No | CONTACT | VARCHAR | Contact person or entity. | Description Source: NOAA ESI Guidelines |
100 | No | No | PHONE | VARCHAR | Contact telephone number. | Description Source: NOAA ESI Guidelines |
100 | No | No | LINK | VARCHAR | Link to the resource web-page. | Description Source: NOAA ESI Guidelines |
100 | Yes | No | G_SOURCE | NUMBER | Geographic source identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: NOAA ESI Guidelines |
100 | Yes | No | A_SOURCE | NUMBER | Attribute source identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: NOAA ESI Guidelines |
Attribute Details
Attribute Name | HUNUM |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 8 |
Min Length | 8 |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 28500001-28507014 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ELEMENT |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR |
Max Length | 10 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Category of the human-use features. | Description Source: NOAA ESI Guidelines |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | POLITICAL: Political/Jurisdictional management | MANAGED: Parks/Managed areas | RESOURCE: Resource management | NAT_HAZARD: Natural hazard | NAV_MARINE: Navigation/Marine - recreational/Maritime | SOCECON: Other socioeconomic features |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TYPE |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR |
Max Length | 35 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The human-use features depicted on the maps are those that could be impacted by an oil spill or could provide access for response operations. | Description Source: NOAA ESI Guidelines |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | A: Airport | ACE: Army Corps of Engineers | AN: Anchorage | AQ: Aquaculture | AR: Artificial Reef | AV: Abandoned Vessel | B: Beach | BR: Boat Ramp | CF: Commercial Fishing | CG: Coast Guard Station, District, or Sector | CH: Critical Habitat | CO: County Border | EH: Essential Habitat | EPA: EPA Regions | EPAF: EPA Facility | F: Ferry | FA: Fishery Area | FEMA: FEMA Region | HP: Heliport | HS: Historical Site or Area | LD: Lock and Dam | M: Marina | MA: Management Area | MI: Military | MO: Mooring | NC: Nature Conservancy | NERR: National Estuarine Research Reserve | NG: National Guard | NOAA: NOAA Facility | NP: National Park | P: Regional or State Park | PL: Pipeline | PT: Port | R: Road or Bridge | RF: Recreational Fishing | RMS: Repeated Measurement Site/Area | RR: Rail Route | SL: Shipping Lane | SPA: State Protected Area | ST: State | SW: State Waters | TL: Tribal Land | TU: Tunnel | WD: Waste Disposal | WI: Water Intake | WO: Wash Over | WR: Wildlife Refuge |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NAME |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The feature name. | Description Source: NOAA ESI Guidelines |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Acceptable values change from atlas to atlas. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CONTACT |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR |
Max Length | 80 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Contact person or entity. | Description Source: NOAA ESI Guidelines |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Acceptable values change from atlas to atlas. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PHONE |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Contact telephone number. | Description Source: NOAA ESI Guidelines |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | ###-###-#### |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINK |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Link to the resource web-page. | Description Source: NOAA ESI Guidelines |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | URL. Must be copied as is from the address bar & must be fully qualified (begin with http://) & contain no “<” or “>” characters |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | G_SOURCE |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMBER |
Max Length | 8 |
Min Length | 8 |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Geographic source identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: NOAA ESI Guidelines |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 28500101-28500807 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | A_SOURCE |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | 8 |
Min Length | 8 |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Attribute source identifier that links records in the SOC_DAT data table to records in the SOURCES data table. | Description Source: NOAA ESI Guidelines |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 28500101-28500807 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 54951 |
---|---|
Metadata Record Created By | Jill Petersen |
Metadata Record Created | 2018-11-27 14:53+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2019-02-14 |
Owner Org | ORR |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2019-02-14 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2020-02-14 |
Tags |
---|