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
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
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
Phone: 808-725-5300
URL: http://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
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: 2019-06-04 13:14+0000
Metadata Record Published: 2015-12-07
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2016-12-07