Table: MS_GEO_AREAS

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

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

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

	Name	Type	Description
100	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

Name

Type

Description

100

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