Table: MS_GEO_AREAS
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 18268
| Published / External
Created: 2013-02-12
|
Last Modified: 2022-10-20
Data Set (DS) | ID: 5680
ID: 18268
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: MS_GEO_AREAS |
---|---|
Short Name | MS_GEO_AREAS |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Each Geo Area is significant as a well defined geographic region or locale in which monk seal activity may occur. |
* Purpose | |
Notes |
Loaded by batch 4358, 02-12-2013 15:39 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
None | hawaiian monk seal |
None | hmsrp |
None | islands |
None | locations |
None | pifsc |
None | population assessment |
None | protected species |
None | psd |
None | sectors |
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | atoll |
None | hawaiian archipelago |
None | island |
None | islet |
None | pacific region |
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | Pacific Islands Fisheries Science Center |
---|---|
• » City | Honolulu |
• » State/Province | HI |
• Country | USA |
• » Location Description |
1601 Kapiolani Blvd Honolulu, HI |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | MSEAL |
» Description |
Each Geo Area is significant as a well defined geographic region or locale in which monk seal activity may occur. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | Yes | GEO_ID | RAW | System-generated primary key for geo areas |
100 | No | No | GEO_AREA_TYPE_CODE | VARCHAR2 | Foreign key pointing to the Geo Area Type of the Geo Area (e.g., Atoll) |
100 | No | No | IN_GEO_ID | RAW | Foreign key pointing to another Geo Area (e.g., Sector) which contains this Geo Area (e.g., beach) |
100 | No | No | GEO_AREA_CODE | NUMBER | Code number for the geographic area (example: atoll code, island code, sector, beach code) |
100 | No | No | GEO_AREA_NAME | VARCHAR2 | The name of the ATOLL (multi-island) or ISLAND (single island location). |
100 | No | No | LATITUDE | NUMBER | GPS coordinate stored as decimal |
100 | No | No | LONGITUDE | NUMBER | GPS coordinate stored as decimal |
100 | No | No | ATOLL_TAG_COLOR | VARCHAR2 | The color of the tag applied to seals at this location. |
100 | No | No | ATOLL_INITIALS | VARCHAR2 | A three character abbreviation of the ISLAND name |
100 | No | No | ATOLL_LTR_CODE | VARCHAR2 | A Two character abbreviation of the ISLAND name which is used as part of the PSEUDO-PERM ID. This code is concatenated to a two-digit year (ex: 09) to form the 4 character prefix of a pseudo-perm ID (temporary permid). These 4 characters are prepended to a 4 character "temp" created by left padding the user-entered "TEMP ID" with sufficient Zeros to 4 characters, thus creating the (required) 8 character PSEUDO-PERM ID. Example of a PSEUDO_PERM ID would be "MD0900K5", which represents a seal identified at Midway in 2009 by the temp id number K5. |
100 | No | No | ISLAND_NEED_FOR_ACOUNT | VARCHAR2 | Is a page for this islet (NOT SECTOR!) required for a complete Atoll Census Count? |
100 | No | No | SECTOR_CONT1 | NUMBER | The code of a sector contiguous with this sector. Up to 4 contiguous sectors are possible. Data are used for checks for non-contiguous sectors between associated seals in a survey. |
100 | No | No | SECTOR_CONT2 | NUMBER | The code of a sector contiguous with this sector. Up to 4 contiguous sectors are possible. Data are used for checks for non-contiguous sectors between associated seals in a survey. |
100 | No | No | SECTOR_CONT3 | NUMBER | The code of a sector contiguous with this sector. Up to 4 contiguous sectors are possible. Data are used for checks for non-contiguous sectors between associated seals in a survey. |
100 | No | No | SECTOR_CONT4 | NUMBER | The code of a sector contiguous with this sector. Up to 4 contiguous sectors are possible. Data are used for checks for non-contiguous sectors between associated seals in a survey. |
100 | No | No | BEACH_LOCATION_NAME | VARCHAR2 | A specific named place on a beach |
100 | No | No | CREATE_DTM | DATE | System date created |
100 | No | No | CREATED_BY | VARCHAR2 | Oracle user who created the record |
100 | No | No | LAST_MOD_DTM | DATE | System date of last modification |
100 | No | No | LAST_MOD_BY | VARCHAR2 | Oracle user who last modified the record |
Attribute Details
Attribute Name | GEO_ID |
---|---|
Seq. Order | 1 |
Data Storage Type | RAW |
Max Length | 16 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
System-generated primary key for geo areas |
General Data Type | RAW |
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 | GEO_AREA_TYPE_CODE |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Foreign key pointing to the Geo Area Type of the Geo Area (e.g., Atoll) |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
MSEAL.MS_GEO_AREA_TYPES |
Derivation | |
Validation Rules |
Attribute Name | IN_GEO_ID |
---|---|
Seq. Order | 3 |
Data Storage Type | RAW |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Foreign key pointing to another Geo Area (e.g., Sector) which contains this Geo Area (e.g., beach) |
General Data Type | RAW |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
MSEAL.MS_GEO_AREAS |
Derivation | |
Validation Rules |
Attribute Name | GEO_AREA_CODE |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Code number for the geographic area (example: atoll code, island code, sector, beach code) |
General Data Type | NUMBER |
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 | GEO_AREA_NAME |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The name of the ATOLL (multi-island) or ISLAND (single island location). |
General Data Type | VARCHAR2 |
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 | LATITUDE |
---|---|
Seq. Order | 6 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
GPS coordinate stored as decimal |
General Data Type | NUMBER |
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 | LONGITUDE |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
GPS coordinate stored as decimal |
General Data Type | NUMBER |
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 | ATOLL_TAG_COLOR |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The color of the tag applied to seals at this location. |
General Data Type | VARCHAR2 |
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 | ATOLL_INITIALS |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A three character abbreviation of the ISLAND name |
General Data Type | VARCHAR2 |
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 | ATOLL_LTR_CODE |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A Two character abbreviation of the ISLAND name which is used as part of the PSEUDO-PERM ID. This code is concatenated to a two-digit year (ex: 09) to form the 4 character prefix of a pseudo-perm ID (temporary permid). These 4 characters are prepended to a 4 character "temp" created by left padding the user-entered "TEMP ID" with sufficient Zeros to 4 characters, thus creating the (required) 8 character PSEUDO-PERM ID. Example of a PSEUDO_PERM ID would be "MD0900K5", which represents a seal identified at Midway in 2009 by the temp id number K5. |
General Data Type | VARCHAR2 |
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 | ISLAND_NEED_FOR_ACOUNT |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Is a page for this islet (NOT SECTOR!) required for a complete Atoll Census Count? |
General Data Type | VARCHAR2 |
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 | SECTOR_CONT1 |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
The code of a sector contiguous with this sector. Up to 4 contiguous sectors are possible. Data are used for checks for non-contiguous sectors between associated seals in a survey. |
General Data Type | NUMBER |
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 | SECTOR_CONT2 |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code of a sector contiguous with this sector. Up to 4 contiguous sectors are possible. Data are used for checks for non-contiguous sectors between associated seals in a survey. |
General Data Type | NUMBER |
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 | SECTOR_CONT3 |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
The code of a sector contiguous with this sector. Up to 4 contiguous sectors are possible. Data are used for checks for non-contiguous sectors between associated seals in a survey. |
General Data Type | NUMBER |
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 | SECTOR_CONT4 |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code of a sector contiguous with this sector. Up to 4 contiguous sectors are possible. Data are used for checks for non-contiguous sectors between associated seals in a survey. |
General Data Type | NUMBER |
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 | BEACH_LOCATION_NAME |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A specific named place on a beach |
General Data Type | VARCHAR2 |
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 | CREATE_DTM |
---|---|
Seq. Order | 17 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
System date created |
General Data Type | DATE |
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 | CREATED_BY |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Oracle user who created the record |
General Data Type | VARCHAR2 |
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 | LAST_MOD_DTM |
---|---|
Seq. Order | 19 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
System date of last modification |
General Data Type | DATE |
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 | LAST_MOD_BY |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Oracle user who last modified the record |
General Data Type | VARCHAR2 |
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 | |
---|---|
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 | Data Steward |
---|---|
* » Date Effective From | 2007-06-13 |
Date Effective To | |
Person | Johanos, Thea C |
Address |
1845 Wasp Blvd. Honolulu, HI 96818 USA |
Email Address | thea.johanos-kam@noaa.gov |
Phone | (808)725-5709 |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » Support Role | Originator |
---|---|
* » Date Effective From | 2007-06-13 |
Date Effective To | |
Organization | Pacific Islands Fisheries Science Center (PIFSC) |
Address |
1845 Wasp Blvd. Honolulu, HI 96818 USA |
Email Address | pifsc.info@noaa.gov |
Phone | 808-725-5360 |
Fax | |
Mobile | |
URL | https://www.pifsc.noaa.gov |
Business Hours | 8:00 a.m. - 4:30 p.m. |
Contact Instructions |
* » Support Role | Point of Contact |
---|---|
* » Date Effective From | 2007-06-13 |
Date Effective To | |
Person | Johanos, Thea C |
Address |
1845 Wasp Blvd. Honolulu, HI 96818 USA |
Email Address | thea.johanos-kam@noaa.gov |
Phone | (808)725-5709 |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » 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 | Ground Condition |
---|
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 1
* » Time Frame Type | Continuing |
---|---|
* » Start | 1982-12-31 |
End | |
Alternate Start As Of Info | |
Alternate End As Of Info | |
Description |
Access Information
* » Security Class | Unclassified |
---|---|
* Security Classification System | |
Security Handling Description | |
• Data Access Policy |
NMFS/PIFSC, Protected Species Division, Hawaiian Monk Seal Research Program Data Access, Sharing, and Dissemination Guidelines |
» Data Access Procedure |
Requestor will be asked to submit a request to Thea Johanos (thea.johanos-kam@noaa.gov) |
• » Data Access Constraints |
NMFS/PIFSC, Protected Species Division, Hawaiian Monk Seal Research Program Data Access, Sharing, and Dissemination Guidelines |
• Data Use Constraints |
Use of the data set must be cleared with NMFS/PIFSC, Protected Species Division. These data are PRELIMINARY and have not be completely screened for accuracy. NOAA can not be held liable for use of these data in a manner other than for perusal of preliminary data. The developers of these data are concerned with assuring its proper use. Before data are used to draw specific scientific conclusions, potential users are requested to contact NMFS/PIFSC, Protected Species Division for background on the data. Acknowledgement of the data should be cited. Different versions of the dataset may exist. The user must be sure to use the appropriate data set for the time period of interest. While efforts have been made to ensure that these data are accurate and reliable, NOAA cannot assume liablility for any damages or misrepresentation caused by any inaccuracies in the data or as a result of changes to the data caused by system transfers. |
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 | 18268 |
---|---|
Metadata Record Created By | Vikram Khurana |
Metadata Record Created | 2013-02-12 15:39+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-10-20 02:17+0000 |
Metadata Record Published | 2015-12-07 |
Owner Org | PIFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2015-12-07 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2016-12-07 |
Tags |
---|