View: VS_FISH_TDS_SIGHTINGS
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:45813 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | View: VS_FISH_TDS_SIGHTINGS |
---|---|
Short Name: | VS_FISH_TDS_SIGHTINGS |
Status: | Completed |
Abstract: |
Spatial view of sightings data from fish towed-diver surveys. |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | GISDAT |
Description: |
Spatial view of sightings data from fish towed-diver surveys. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
OBJECTID | NUMBER | Primary key for the data table. | |
100
|
MISSIONID | VARCHAR2 | Mission identifier: NOAA Ship, 2-digit federal fiscal year, 2-digit mission number for the fiscal year. HA/HI = NOAA Ship Hi'ialakai OES = NOAA Ship Oscar Elton Sette TC = NOAA Ship Townsend Cromwell Shore = shore-based survey launch | |
100
|
REGION_NAME | VARCHAR2 | The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. | |
100
|
ISLAND | NVARCHAR2 | Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). | |
100
|
OBS_YEAR | NUMBER | 4-digit year the survey was conducted (DATE_). | |
100
|
DATE_ | DATE | Date of the tow survey. dd-MMM-yy | |
100
|
TOW_TYPE | NVARCHAR2 | Normal = standard towed diver survey (not a calibration survey). | |
100
|
REEF_ZONE | NVARCHAR2 | The reef zone for the given towed diver segment (Forereef, Backreef, Lagoon, unspecified). Forereef: The sloping bottom underlying the wave break zone, extending seaward from the reef crest. Comprehensive surveys of forereef habitats remain the priority for towed-diver operations. Backreef: The shallow strip of reef sheltered from breaking waves by the reef crest, situated between the reef crest and the lagoon floor. Lagoon: The zone sheltered from the waves by the reef crest, and separated from the reef crest by the back reef. Usually deeper than the back reef and covered in unconsolidated sediment, this term describes both an atoll's interior and the expanse situated between the back reef and shore of any islands present. Unspecified: these are other areas surveyed using towed-diver methods, which include bank (a submerged platform reef, often occurring either as an isolated feature atop a seamount or as a plateau situated between the fore reef and a deeper slope) and channel (a submerged transition between forereef and backreef zones created by a gap in the reef crest). | |
100
|
TOWKEY | NUMBER | Unique key for the given tow (DIVEID). | |
100
|
DIVEID | NUMBER | Unique ID representing 4-digit year, 2-digit month, 2-digit day, and tow number of day (1-6). | |
100
|
SEGMENTID | NUMBER | Unique ID representing 4-digit year, 2-digit month, 2-digit day, tow number of day (1-6), and SEGMENT number (01-10). | |
100
|
SEGMENT | NUMBER | Segment number for a given tow. Segments represent 5-minute increments and there are typically, but not always, 10 segments per tow. | |
100
|
DEPTH | NUMBER | Mean depth in meters of the towed diver during the 5-min observation (SEGMENT). May be null if the SEABIRD failed or if the instrument data could not be synced with the GPS or observation data. | |
100
|
TEMPERATURE | NUMBER | Mean temperature in degrees Celsius during the 5-min observation (SEGMENT). May be null if the SEABIRD failed or if the instrument data could not be synced with the GPS or observation data. | |
100
|
STARTLOCALTIME | DATETIME | Local starting date and time of the 5-min observation (dd-MMM-yy hh:mm:ss). Start and stop time is not consistently provided. | |
100
|
ENDLOCALTIME | DATETIME | Local ending date and time of the 5-min observation (dd-MMM-yy hh:mm:ss). Start and stop time is not consistently provided. | |
100
|
CENTROIDLAT | NUMBER | Latitude in decimal degrees, WGS84, for the midpoint of the given 5-min SEGMENT. | |
100
|
CENTROIDLON | NUMBER | Longitude in decimal degrees, WGS84 for the midpoint of the given 5-min SEGMENT. | |
100
|
PROJECTEDLENGTH | NUMBER | Calculated length of SEGMENT in meters using GIS. | |
100
|
TAXONCODE | TEXT | 4-letter code for TAXONNAME. | |
100
|
TAXONNAME | TEXT | Scientific name of observed organism to the finest taxonomic resolution that divers can identify. | |
100
|
COUNT | NUMBER | Number of organisms observed for the given SEGMENT. | |
100
|
SIZE_CM | NUMBER | Length of organism, reported in centimeters. In some cases the size of exceptionally large (i.e., whales) or partially hidden (i.e., eels) organisms may not be provided. | |
100
|
PHYLUM | NVARCHAR2 | Taxonomic classification: Phylum of observed organism (TAXONNAME). | |
100
|
CLASS | NVARCHAR2 | Taxonomic classification: Class of observed organism (TAXONNAME). | |
100
|
ORDER | NVARCHAR2 | Taxonomic classification: Order of observed organism (TAXONNAME). | |
100
|
FAMILY | NVARCHAR2 | Taxonomic classification: Family of observed organism (TAXONNAME). | |
100
|
COMMONFAMILYALL | NVARCHAR2 | Common name given for the FAMILY (used for grouping purposes during data analysis). For example, Dolphin, Monk Seal, and Turtle, among others. | |
100
|
SCIENTIFIC_NAME | VARCHAR2 | Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level. | |
100
|
COMMONNAME | NVARCHAR2 | Common name of the organism (TAXONNAME). If NULL, organism not identified to species taxonomic level. |
Attribute Details
OBJECTID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Scale: | 0 |
Status: | Active |
Description: |
Primary key for the data table. |
General Data Type: | NUMBER |
MISSIONID
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Mission identifier: NOAA Ship, 2-digit federal fiscal year, 2-digit mission number for the fiscal year. HA/HI = NOAA Ship Hi'ialakai OES = NOAA Ship Oscar Elton Sette TC = NOAA Ship Townsend Cromwell Shore = shore-based survey launch |
General Data Type: | VARCHAR2 |
REGION_NAME
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. |
General Data Type: | VARCHAR2 |
ISLAND
Seq. Order: | 6 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 90 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME). |
General Data Type: | NVARCHAR2 |
OBS_YEAR
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
4-digit year the survey was conducted (DATE_). |
General Data Type: | NUMBER |
DATE_
Seq. Order: | 12 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date of the tow survey. dd-MMM-yy |
General Data Type: | DATE |
TOW_TYPE
Seq. Order: | 12 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 60 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Normal = standard towed diver survey (not a calibration survey). |
General Data Type: | NVARCHAR2 |
REEF_ZONE
Seq. Order: | 13 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The reef zone for the given towed diver segment (Forereef, Backreef, Lagoon, unspecified). Forereef: The sloping bottom underlying the wave break zone, extending seaward from the reef crest. Comprehensive surveys of forereef habitats remain the priority for towed-diver operations. Backreef: The shallow strip of reef sheltered from breaking waves by the reef crest, situated between the reef crest and the lagoon floor. Lagoon: The zone sheltered from the waves by the reef crest, and separated from the reef crest by the back reef. Usually deeper than the back reef and covered in unconsolidated sediment, this term describes both an atoll's interior and the expanse situated between the back reef and shore of any islands present. Unspecified: these are other areas surveyed using towed-diver methods, which include bank (a submerged platform reef, often occurring either as an isolated feature atop a seamount or as a plateau situated between the fore reef and a deeper slope) and channel (a submerged transition between forereef and backreef zones created by a gap in the reef crest). |
General Data Type: | NVARCHAR2 |
TOWKEY
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Unique key for the given tow (DIVEID). |
General Data Type: | NUMBER |
DIVEID
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique ID representing 4-digit year, 2-digit month, 2-digit day, and tow number of day (1-6). |
General Data Type: | NUMBER |
SEGMENTID
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique ID representing 4-digit year, 2-digit month, 2-digit day, tow number of day (1-6), and SEGMENT number (01-10). |
General Data Type: | NUMBER |
SEGMENT
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Segment number for a given tow. Segments represent 5-minute increments and there are typically, but not always, 10 segments per tow. |
General Data Type: | NUMBER |
DEPTH
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Mean depth in meters of the towed diver during the 5-min observation (SEGMENT). May be null if the SEABIRD failed or if the instrument data could not be synced with the GPS or observation data. |
General Data Type: | NUMBER |
TEMPERATURE
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Mean temperature in degrees Celsius during the 5-min observation (SEGMENT). May be null if the SEABIRD failed or if the instrument data could not be synced with the GPS or observation data. |
STARTLOCALTIME
Seq. Order: | 21 |
---|---|
Data Storage Type: | DATETIME |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local starting date and time of the 5-min observation (dd-MMM-yy hh:mm:ss). Start and stop time is not consistently provided. |
General Data Type: | DATETIME |
ENDLOCALTIME
Seq. Order: | 22 |
---|---|
Data Storage Type: | DATETIME |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local ending date and time of the 5-min observation (dd-MMM-yy hh:mm:ss). Start and stop time is not consistently provided. |
CENTROIDLAT
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Latitude in decimal degrees, WGS84, for the midpoint of the given 5-min SEGMENT. |
General Data Type: | NUMBER |
CENTROIDLON
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Longitude in decimal degrees, WGS84 for the midpoint of the given 5-min SEGMENT. |
General Data Type: | NUMBER |
PROJECTEDLENGTH
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Calculated length of SEGMENT in meters using GIS. |
TAXONCODE
Seq. Order: | 25 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4-letter code for TAXONNAME. |
TAXONNAME
Seq. Order: | 26 |
---|---|
Data Storage Type: | TEXT |
Max Length: | 765 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Scientific name of observed organism to the finest taxonomic resolution that divers can identify. |
COUNT
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Number of organisms observed for the given SEGMENT. |
General Data Type: | NUMBER |
SIZE_CM
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Length of organism, reported in centimeters. In some cases the size of exceptionally large (i.e., whales) or partially hidden (i.e., eels) organisms may not be provided. |
General Data Type: | NUMBER |
PHYLUM
Seq. Order: | 31 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Phylum of observed organism (TAXONNAME). |
General Data Type: | NVARCHAR2 |
CLASS
Seq. Order: | 32 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Class of observed organism (TAXONNAME). |
General Data Type: | NVARCHAR2 |
ORDER
Seq. Order: | 33 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Order of observed organism (TAXONNAME). |
General Data Type: | NVARCHAR2 |
FAMILY
Seq. Order: | 34 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Family of observed organism (TAXONNAME). |
General Data Type: | NVARCHAR2 |
COMMONFAMILYALL
Seq. Order: | 35 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common name given for the FAMILY (used for grouping purposes during data analysis). For example, Dolphin, Monk Seal, and Turtle, among others. |
General Data Type: | NVARCHAR2 |
SCIENTIFIC_NAME
Seq. Order: | 36 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level. |
General Data Type: | VARCHAR2 |
COMMONNAME
Seq. Order: | 37 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common name of the organism (TAXONNAME). If NULL, organism not identified to species taxonomic level. |
General Data Type: | NVARCHAR2 |
Catalog Details
Catalog Item ID: | 45813 |
---|---|
GUID: | gov.noaa.nmfs.inport:45813 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2017-04-20 17:54+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2019-05-03 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2019-05-03 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2020-05-03 |