Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Protected Species Division (PSD) Metadata... > PSD Hawaiian Monk Seal Research Program (HMSRP)... > HMSRP Hawaiian Monk Seal Population Assessment... > HMSRP Hawaiian Monk Seal Population Assessment... > HMSRP Hawaiian Monk Seal Island/Sector Location... >

Table: MS_GEO_AREAS

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:18268  |  Updated: October 20, 2022  |  Published / External 
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Extents
Access Info
Catalog Details

Summary

Abstract

Each Geo Area is significant as a well defined geographic region or locale in which monk seal activity may occur.

Description

Each Geo Area is significant as a well defined geographic region or locale in which monk seal activity may occur.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
GEO_ID
RAW 		System-generated primary key for geo areas
GEO_AREA_TYPE_CODE
VARCHAR2 		Foreign key pointing to the Geo Area Type of the Geo Area (e.g., Atoll)
IN_GEO_ID
RAW 		Foreign key pointing to another Geo Area (e.g., Sector) which contains this Geo Area (e.g., beach)
GEO_AREA_CODE
NUMBER 		Code number for the geographic area (example: atoll code, island code, sector, beach code)
GEO_AREA_NAME
VARCHAR2 		The name of the ATOLL (multi-island) or ISLAND (single island location).
LATITUDE
NUMBER 		GPS coordinate stored as decimal
LONGITUDE
NUMBER 		GPS coordinate stored as decimal
ATOLL_TAG_COLOR
VARCHAR2 		The color of the tag applied to seals at this location.
ATOLL_INITIALS
VARCHAR2 		A three character abbreviation of the ISLAND name
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.
ISLAND_NEED_FOR_ACOUNT
VARCHAR2 		Is a page for this islet (NOT SECTOR!) required for a complete Atoll Census Count?
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.
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.
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.
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.
BEACH_LOCATION_NAME
VARCHAR2 		A specific named place on a beach
CREATE_DTM
DATE 		System date created
CREATED_BY
VARCHAR2 		Oracle user who created the record
LAST_MOD_DTM
DATE 		System date of last modification
LAST_MOD_BY
VARCHAR2 		Oracle user who last modified the record

Child Items

No Child Items for this record.

Contact Information

Point of Contact
Thea C Johanos
thea.johanos-kam@noaa.gov
(808)725-5709

Extents

Time Frame 1
1982-12-31 - Present

Item Identification

Title: Table: MS_GEO_AREAS
Short Name: MS_GEO_AREAS
Status: Completed
Abstract:

Each Geo Area is significant as a well defined geographic region or locale in which monk seal activity may occur.
Notes:

Loaded by batch 4358, 02-12-2013 15:39

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None hawaiian monk seal
None hmsrp
None islands
None locations
None pifsc
None population assessment
None protected species
None psd
None sectors

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None atoll
None hawaiian archipelago
None island
None islet
None pacific region

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?: Yes
Schema Name: MSEAL
Description:

Each Geo Area is significant as a well defined geographic region or locale in which monk seal activity may occur.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key GEO_ID RAW System-generated primary key for geo areas
100
 GEO_AREA_TYPE_CODE VARCHAR2 Foreign key pointing to the Geo Area Type of the Geo Area (e.g., Atoll)
100
 IN_GEO_ID RAW Foreign key pointing to another Geo Area (e.g., Sector) which contains this Geo Area (e.g., beach)
100
 GEO_AREA_CODE NUMBER Code number for the geographic area (example: atoll code, island code, sector, beach code)
100
 GEO_AREA_NAME VARCHAR2 The name of the ATOLL (multi-island) or ISLAND (single island location).
100
 LATITUDE NUMBER GPS coordinate stored as decimal
100
 LONGITUDE NUMBER GPS coordinate stored as decimal
100
 ATOLL_TAG_COLOR VARCHAR2 The color of the tag applied to seals at this location.
100
 ATOLL_INITIALS VARCHAR2 A three character abbreviation of the ISLAND name
100
 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
 ISLAND_NEED_FOR_ACOUNT VARCHAR2 Is a page for this islet (NOT SECTOR!) required for a complete Atoll Census Count?
100
 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
 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
 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
 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
 BEACH_LOCATION_NAME VARCHAR2 A specific named place on a beach
100
 CREATE_DTM DATE System date created
100
 CREATED_BY VARCHAR2 Oracle user who created the record
100
 LAST_MOD_DTM DATE System date of last modification
100
 LAST_MOD_BY VARCHAR2 Oracle user who last modified the record

Attribute Details

GEO_ID

CC ID: 95252
Seq. Order: 1
Data Storage Type: RAW
Max Length: 16
Required: Yes
Primary Key: Yes
Status: Active
Description:

System-generated primary key for geo areas
General Data Type: RAW

GEO_AREA_TYPE_CODE

CC ID: 95271
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Foreign key pointing to the Geo Area Type of the Geo Area (e.g., Atoll)
General Data Type: VARCHAR2
Foreign Key Relations:

MSEAL.MS_GEO_AREA_TYPES

IN_GEO_ID

CC ID: 95270
Seq. Order: 3
Data Storage Type: RAW
Max Length: 16
Required: No
Primary Key: No
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
Foreign Key Relations:

MSEAL.MS_GEO_AREAS

GEO_AREA_CODE

CC ID: 95253
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Code number for the geographic area (example: atoll code, island code, sector, beach code)
General Data Type: NUMBER

GEO_AREA_NAME

CC ID: 95254
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The name of the ATOLL (multi-island) or ISLAND (single island location).
General Data Type: VARCHAR2

LATITUDE

CC ID: 95255
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

GPS coordinate stored as decimal
General Data Type: NUMBER

LONGITUDE

CC ID: 95256
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

GPS coordinate stored as decimal
General Data Type: NUMBER

ATOLL_TAG_COLOR

CC ID: 95257
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

The color of the tag applied to seals at this location.
General Data Type: VARCHAR2

ATOLL_INITIALS

CC ID: 95258
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

A three character abbreviation of the ISLAND name

General Data Type: VARCHAR2

ATOLL_LTR_CODE

CC ID: 95259
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
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

ISLAND_NEED_FOR_ACOUNT

CC ID: 95260
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Is a page for this islet (NOT SECTOR!) required for a complete Atoll Census Count?
General Data Type: VARCHAR2

SECTOR_CONT1

CC ID: 95261
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

SECTOR_CONT2

CC ID: 95262
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
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

SECTOR_CONT3

CC ID: 95263
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

SECTOR_CONT4

CC ID: 95264
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
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

BEACH_LOCATION_NAME

CC ID: 95265
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

A specific named place on a beach
General Data Type: VARCHAR2

CREATE_DTM

CC ID: 95266
Seq. Order: 17
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

System date created
General Data Type: DATE

CREATED_BY

CC ID: 95267
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Oracle user who created the record
General Data Type: VARCHAR2

LAST_MOD_DTM

CC ID: 95268
Seq. Order: 19
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

System date of last modification
General Data Type: DATE

LAST_MOD_BY

CC ID: 95269
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Oracle user who last modified the record
General Data Type: VARCHAR2

Support Roles

Data Steward

CC ID: 102679
Date Effective From: 2007-06-13
Date Effective To:
Contact (Person): Johanos, Thea C
Address: 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Email Address: thea.johanos-kam@noaa.gov
Phone: (808)725-5709

Originator

CC ID: 102680
Date Effective From: 2007-06-13
Date Effective To:
Contact (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
URL: https://www.pifsc.noaa.gov
Business Hours: 8:00 a.m. - 4:30 p.m.

Point of Contact

CC ID: 102678
Date Effective From: 2007-06-13
Date Effective To:
Contact (Person): Johanos, Thea C
Address: 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Email Address: thea.johanos-kam@noaa.gov
Phone: (808)725-5709

Extents

Currentness Reference: Ground Condition

Extent Group 1

Extent Group 1 / Time Frame 1

CC ID: 102681
Time Frame Type: Continuing
Start: 1982-12-31

Access Information

Security Class: Unclassified
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.

Catalog Details

Catalog Item ID: 18268
GUID: gov.noaa.nmfs.inport: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 Last Review Date: 2015-12-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2016-12-07