RV001AA3_RSCH_V
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 68938
| Published / External
Created: 2022-12-29
|
Last Modified: 2023-10-04
Parent: Occurrence of Birds, Aquatic Mammals, & Fish Schools Log data collected during research vessel cruises between 1950 and 1997
Data Set (DS) | ID: 5906
Data Set (DS) | ID: 5906
ID: 68938
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | RV001AA3_RSCH_V |
|---|---|
| Short Name | RV001AA3_RSCH_V |
| * Status | Completed |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract |
Occurrence of birds, aquatic mammals and fish schools log. |
| * Purpose | |
| Notes | |
| Other Citation Details | |
| • Supplemental Information | |
| DOI (Digital Object Identifier) | |
| DOI Registration Authority | |
| DOI Issue Date |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
Temporal Keywords
| Thesaurus | Keyword |
|---|---|
* Spatial Keywords
| Thesaurus | Keyword |
|---|---|
Stratum Keywords
| Thesaurus | Keyword |
|---|---|
Instrument Keywords
| Thesaurus | Keyword |
|---|---|
Platform Keywords
| Thesaurus | Keyword |
|---|---|
Physical Location
| • » Organization | |
|---|---|
| • » City | |
| • » State/Province | |
| • Country | |
| • » Location Description |
Entity Information
| Entity Type | Data Table |
|---|---|
| Active Version? | Y |
| Alias | |
| Schema Name | |
| » Description |
Occurrence of birds, aquatic mammals and fish schools log. |
| Change Summary |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | No | No | DATASET_CODE | VARCHAR2 | Source ID Code assigned by the data entry staff. |
| 100 | No | No | VERSION_CODE | VARCHAR2 | Code for the format version assigned by the data entry staff. |
| 100 | No | No | VESSEL_CODE | VARCHAR2 | Code for the vessel. |
| 100 | No | No | CRUISE_NUMBER | VARCHAR2 | Four digit incremental cruise number of the vessel, e.g., 0001, or the last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 7604. |
| 100 | No | No | YEAR | VARCHAR2 | Local year of sighting. |
| 100 | No | No | MONTH | VARCHAR2 | Local month of sighting. |
| 100 | No | No | DAY | VARCHAR2 | Local day of sighting. |
| 100 | No | No | TIME_ZONE_CODE | VARCHAR2 | Time zone code of sighting. |
| 100 | No | No | LOCAL_TIME | VARCHAR2 | Local time of sighting; the hour and minute fields were merged into one field. |
| 100 | No | No | OCTANT_FLOCK_SCHOOL | VARCHAR2 | Octant of the bird flock or fish school sighting. |
| 100 | No | No | LATITUDE_DEGREES_FLOCK_SCHOOL | VARCHAR2 | Latitude degrees when the bird flock or fish school was sighted. Units for values are degrees. |
| 100 | No | No | LATITUDE_MINUTES_FLOCK_SCHOOL | VARCHAR2 | Latitude minutes when the bird flock or fish school was sighted. Units for values are minutes. |
| 100 | No | No | LATITUDE_DIRECTION_FLOCK_SCHOOL | VARCHAR2 | Latitude direction when the bird flock or fish school was sighted. OCTANT used to determine LATITUDE_DIRECTION_FLOCK_SCHOOL (N/S). |
| 100 | No | No | LATITUDE_DD_FLOCK_SCHOOL | NUMBER | Computed latitude, in decimal degrees, when the bird flock or fish school was sighted. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
| 100 | No | No | LONGITUDE_DEGREES_FLOCK_SCHOOL | VARCHAR2 | Longitude degrees when the bird flock or fish school was sighted. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees. |
| 100 | No | No | LONGITUDE_MINUTES_FLOCK_SCHOOL | VARCHAR2 | Longitude minutes when the bird flock or fish school was sighted. Units for values are minutes. |
| 100 | No | No | LONGITUDE_DIRECTION_FLOCK_SCHOOL | VARCHAR2 | Longitude direction when the bird flock or fish school was sighted. OCTANT used to determine LONGITUDE_DIRECTION_FLOCK_SCHOOL (E/W). |
| 100 | No | No | LONGITUDE_DD_FLOCK_SCHOOL | NUMBER | Computed longitude, in decimal degrees, when the bird flock or fish school was sighted. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
| 100 | No | No | SIZE_FLOCK_CODE | VARCHAR2 | Code for the size of the bird flock. |
| 100 | No | No | SOOTY_TERN_PRESENT_CODE | VARCHAR2 | Code whether SOOTY TERN was present. Value could also be SIZE_FLOCK_CODE. |
| 100 | No | No | NODDY_TERN_PRESENT_CODE | VARCHAR2 | Code whether NOODY TERN was present. Value could also be SIZE_FLOCK_CODE. |
| 100 | No | No | WHITE_TERN_PRESENT_CODE | VARCHAR2 | Code whether WHITE TERN was present. Value could also be SIZE_FLOCK_CODE. |
| 100 | No | No | BOOBY_PRESENT_CODE | VARCHAR2 | Code whether BOOBY was present. Value could also be SIZE_FLOCK_CODE. |
| 100 | No | No | TROPIC_BIRD_PRESENT_CODE | VARCHAR2 | Code whether TROPIC BIRD was present. Value could also be SIZE_FLOCK_CODE. |
| 100 | No | No | FRIGATE_BIRD_PRESENT_CODE | VARCHAR2 | Code whether FRIGATE BIRD was present. Value could also be SIZE_FLOCK_CODE. |
| 100 | No | No | PETREL_SHEARWATER_PRESENT_CODE | VARCHAR2 | Code whether PETREL or SHEARWATER was present. Value could also be SIZE_FLOCK_CODE. |
| 100 | No | No | STORM_PETREL_PRESENT_CODE | VARCHAR2 | Code whether STORM PETREL was present. Value could also be SIZE_FLOCK_CODE. |
| 100 | No | No | ALBATROSS_PRESENT_CODE | VARCHAR2 | Code whether ALBATROSS was present. Value could also be SIZE_FLOCK_CODE. |
| 100 | No | No | OTHER_BIRDS_PRESENT_CODE | VARCHAR2 | Code whether OTHER BIRDS were present. Value could also be SIZE_FLOCK_CODE. |
| 100 | No | No | SPECIES_CODE_FLOCK_SCHOOL_2 | VARCHAR2 | Two-digit species code of the bird flock or fish school. |
| 100 | No | No | SPECIES_CODE_FLOCK_SCHOOL_5 | VARCHAR2 | Five-digit CZM species code of the bird flock or fish school. |
| 100 | No | No | SPECIES_CODE_FLOCK_SCHOOL | VARCHAR2 | Ten-digit CZM species code of the bird flock or fish school. Originally two-digit, five_digit or ten-digit species codes resided in the one column. They are now in separate columns, and there is a corresponding ten-digit code for each two-digit and five_digit species code. |
| 100 | No | No | AVERAGE_SIZE_FISH_KG | VARCHAR2 | Average fish weight, in kilograms. Units for values are kilograms. |
| 100 | No | No | AVERAGE_SIZE_FISH_LB | VARCHAR2 | Average fish weight, in pounds. Units for values are pounds. |
| 100 | No | No | SIZE_SCHOOL_CODE | VARCHAR2 | Code for the size of the fish school. |
| 100 | No | No | TIME_POSITION_TAKEN | VARCHAR2 | Time position taken; the hour field and minute field were merged into one field. |
| 100 | No | No | OCTANT_SCATTER | VARCHAR2 | Octant of the sighting of scattered species. |
| 100 | No | No | LATITUDE_DEGREES_SCATTER | VARCHAR2 | Latitude degrees when the scattered species was sighted. Units for values are degrees. |
| 100 | No | No | LATITUDE_MINUTES_SCATTER | VARCHAR2 | Latitude minutes when the scattered species was sighted. Units for values are minutes. |
| 100 | No | No | LATITUDE_DIRECTION_SCATTER | VARCHAR2 | Latitude direction when the scattered species was sighted. OCTANT used to determine LATITUDE_DIRECTION_SCATTER (N/S). |
| 100 | No | No | LATITUDE_DD_SCATTER | NUMBER | Computed latitude, in decimal degree, when the scattered species was sighted. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
| 100 | No | No | LONGITUDE_DEGREES_SCATTER | VARCHAR2 | Longitude degrees when the scattered species was sighted. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees. |
| 100 | No | No | LONGITUDE_MINUTES_SCATTER | VARCHAR2 | Longitude minutes when the scattered species was sighted. Units for values are minutes. |
| 100 | No | No | LONGITUDE_DIRECTION_SCATTER | VARCHAR2 | Longitude direction when the scattered species was sighted. OCTANT used to determine LONGITUDE_DIRECTION_SCATTER (E/W). |
| 100 | No | No | LONGITUDE_DD_SCATTER | NUMBER | Computed longitude, in decimal degrees, when the scattered species was sighted. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
| 100 | No | No | SOOTY_TERN_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered SOOTY TERN sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | NODDY_TERN_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered NODDY TERN sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | WHITE_TERN_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered WHITE TERN sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | BOOBY_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered BOOBY sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | TROPIC_BIRD_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered TROPIC BIRD TERN sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | FRIGATE_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered FRIGATE BIRD sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | PETREL_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered PETREL or SHEARWATER sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | STORM_PETREL_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered STORM PETREL sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | ALBATROSS_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered ALBATROSS sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | OTHER_BIRDS_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered OTHER BIRDS sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | WHALES_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered WHALES sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | PORPOISES_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered PORPOISES sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | SEALS_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered SEALS sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | SPECIES_CODE_OTHERS_SCATTER_2 | VARCHAR2 | Two-digit species code of scattered other species sighted. |
| 100 | No | No | SPECIES_CODE_OTHERS_SCATTER_5 | VARCHAR2 | Five-digit CZM species code of scattered other species sighted. |
| 100 | No | No | SPECIES_CODE_OTHERS_SCATTER | VARCHAR2 | Ten-digit CZM species code of scattered other species sighted. Originally two-digit, five_digit or ten-digit species codes resided in the one column. They are now in separate columns, and there is a corresponding ten-digit code for each two-digit and five_digit species code. |
| 100 | No | No | OTHERS_SCATTER_COUNT | VARCHAR2 | Count of scattered other species sighted. |
| 100 | No | No | OTHERS_SCATTER_COUNT_CODE | VARCHAR2 | Count code for scattered other species sighted. See SIZE_FLOCK_CODE. |
| 100 | No | No | NUMBER_HOURS_WATCHED_0800 | VARCHAR2 | Number of hours watched ending at 0800 or the time the position was taken (FIELD 36. |
| 100 | No | No | NUMBER_HOURS_WATCHED_1200 | VARCHAR2 | Number of hours watched ending at 1200 or the time the position was taken (FIELD 36). |
| 100 | No | No | NUMBER_HOURS_WATCHED_1600 | VARCHAR2 | Number of hours watched ending at 1600 or the time the position was taken (FIELD 36). |
| 100 | No | No | NUMBER_HOURS_WATCHED_2000 | VARCHAR2 | Number of hours watched ending a 2000 or the time the position was taken (FIELD 36). |
| 100 | No | No | JOB_NUMBER | VARCHAR2 | A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84109. |
| 100 | No | No | SEQUENCE_NUMBER | VARCHAR2 | A consecutive number assigned to each record for a block of data. |
| 100 | No | No | DATE_LOADED | DATE | Date when the record was loaded into Oracle or updated. |
Attribute Details
| Attribute Name | DATASET_CODE |
|---|---|
| Seq. Order | 1 |
| Data Storage Type | VARCHAR2 |
| Max Length | 5 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Source ID Code assigned by the data entry staff. |
| 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 | VERSION_CODE |
|---|---|
| Seq. Order | 2 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for the format version assigned by the data entry staff. |
| 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 | VESSEL_CODE |
|---|---|
| Seq. Order | 3 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for the vessel. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 001 = TOWNSEND CROMWELL; 004 = HUGH M SMITH; 005 = JOHN R MANNING; 007 = CHARLES H GILBERT; 025 = USC&GSS PIONEER |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CRUISE_NUMBER |
|---|---|
| Seq. Order | 4 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Four digit incremental cruise number of the vessel, e.g., 0001, or the last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 7604. |
| 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 | YEAR |
|---|---|
| Seq. Order | 5 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Local year of sighting. |
| 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 | MONTH |
|---|---|
| Seq. Order | 6 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Local month of sighting. |
| 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 | DAY |
|---|---|
| Seq. Order | 7 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Local day of sighting. |
| 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 | TIME_ZONE_CODE |
|---|---|
| Seq. Order | 8 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Time zone code of sighting. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | A = MINUS 1; B = MINUS 2; C = MINUS 3; D = MINUS 4; E = MINUS 5; F = MINUS 6; G = MINUS 7; H = MINUS 8; I = MINUS 9; K = MINUS 10; L = MINUS 11; M = MINUS 12; N = PLUS 1; O = PLUS 2; P = PLUS 3; Q = PLUS 4; R = PLUS 5; S = PLUS 6; T = PLUS 7; U = PLUS 8; V = PLUS 9; W = PLUS 10; X = PLUS 11; Y = PLUS 12; Z = 0 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LOCAL_TIME |
|---|---|
| Seq. Order | 9 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Local time of sighting; the hour and minute fields were merged into one field. |
| 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 | OCTANT_FLOCK_SCHOOL |
|---|---|
| Seq. Order | 10 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Octant of the bird flock or fish school sighting. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0 = NORTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 1 = NORTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 2 = NORTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 3 = NORTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE; 5 = SOUTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 6 = SOUTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 7 = SOUTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 8 = SOUTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE_DEGREES_FLOCK_SCHOOL |
|---|---|
| Seq. Order | 11 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Latitude degrees when the bird flock or fish school was sighted. Units for values are degrees. |
| General Data Type | VARCHAR2 |
| Unit of Measure | degrees |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE_MINUTES_FLOCK_SCHOOL |
|---|---|
| Seq. Order | 12 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Latitude minutes when the bird flock or fish school was sighted. Units for values are minutes. |
| General Data Type | VARCHAR2 |
| Unit of Measure | minutes |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE_DIRECTION_FLOCK_SCHOOL |
|---|---|
| Seq. Order | 13 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Latitude direction when the bird flock or fish school was sighted. OCTANT used to determine LATITUDE_DIRECTION_FLOCK_SCHOOL (N/S). |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | N = NORTH; S = SOUTH |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE_DD_FLOCK_SCHOOL |
|---|---|
| Seq. Order | 14 |
| Data Storage Type | NUMBER |
| Max Length | 42 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | 38 |
| Status | Active |
| Description |
Computed latitude, in decimal degrees, when the bird flock or fish school was sighted. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
| General Data Type | NUMBER |
| Unit of Measure | degrees |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE_DEGREES_FLOCK_SCHOOL |
|---|---|
| Seq. Order | 15 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Longitude degrees when the bird flock or fish school was sighted. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees. |
| General Data Type | VARCHAR2 |
| Unit of Measure | degrees |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE_MINUTES_FLOCK_SCHOOL |
|---|---|
| Seq. Order | 16 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Longitude minutes when the bird flock or fish school was sighted. Units for values are minutes. |
| General Data Type | VARCHAR2 |
| Unit of Measure | minutes |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE_DIRECTION_FLOCK_SCHOOL |
|---|---|
| Seq. Order | 17 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Longitude direction when the bird flock or fish school was sighted. OCTANT used to determine LONGITUDE_DIRECTION_FLOCK_SCHOOL (E/W). |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | E = EAST; W = WEST |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE_DD_FLOCK_SCHOOL |
|---|---|
| Seq. Order | 18 |
| Data Storage Type | NUMBER |
| Max Length | 41 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | 36 |
| Status | Active |
| Description |
Computed longitude, in decimal degrees, when the bird flock or fish school was sighted. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
| General Data Type | NUMBER |
| Unit of Measure | degrees |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SIZE_FLOCK_CODE |
|---|---|
| Seq. Order | 19 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for the size of the bird flock. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | FOR HUGH M. SMITH CRUISES, JOHN R. MANNING CRUISES, CHARLES H. GILBERT CRUISES <= 0115 AND TOWNSEND CROMWELL CRUISE <= 0043; 1 = 1; 2 = 2 - 5; 3 = 6 - 10; 4 = 11 - 25; 5 = 26 - 50; 6 = 51 - 100; 7 = 101 - 500; 8 = 501 - 1000; 9 = 1001 - 2000; 0 = > 2000; R-PUNCH = PRESENT BUT NUMBER NOT RECORDED; FOR CHARLES H. GILBERT CRUISES >= 0116 AND TOWNSEND CROMWELL CRUISES >= 0044; 1 = 1 - 5; 2 = 6 - 10; 3 = 11 - 25; 4 = 26 - 50; 5 = 51 - 100; 6 = 101 - 500; 7 = 501 - 1000; 8 = OVER 1000; 9 = PRESENT BUT NUMBERS NOT KNOWN; UNKNOWN CODES; J = UNKNOWN, COULD BE 1-OVERPUNCH; K = UNKNOWN, COULD BE 2-OVERPUNCH; L = UNKNOWN, COULD BE 3-OVERPUNCH; M = UNKNOWN, COULD BE 4-OVERPUNCH; N = UNKNOWN, COULD BE 5-OVERPUNCH; O = UNKNOWN, COULD BE 6-OVERPUNCH; P = UNKNOWN, COULD BE 7-OVERPUNCH; Q = UNKNOWN, COULD BE 8-OVERPUNCH; | = UNKNOWN |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SOOTY_TERN_PRESENT_CODE |
|---|---|
| Seq. Order | 20 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code whether SOOTY TERN was present. Value could also be SIZE_FLOCK_CODE. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1 = PRESENT; NULL = NOT PRESENT |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NODDY_TERN_PRESENT_CODE |
|---|---|
| Seq. Order | 21 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code whether NOODY TERN was present. Value could also be SIZE_FLOCK_CODE. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1 = PRESENT; NULL = NOT PRESENT |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | WHITE_TERN_PRESENT_CODE |
|---|---|
| Seq. Order | 22 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code whether WHITE TERN was present. Value could also be SIZE_FLOCK_CODE. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1 = PRESENT; NULL = NOT PRESENT |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | BOOBY_PRESENT_CODE |
|---|---|
| Seq. Order | 23 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code whether BOOBY was present. Value could also be SIZE_FLOCK_CODE. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1 = PRESENT; NULL = NOT PRESENT |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TROPIC_BIRD_PRESENT_CODE |
|---|---|
| Seq. Order | 24 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code whether TROPIC BIRD was present. Value could also be SIZE_FLOCK_CODE. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1 = PRESENT; NULL = NOT PRESENT |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FRIGATE_BIRD_PRESENT_CODE |
|---|---|
| Seq. Order | 25 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code whether FRIGATE BIRD was present. Value could also be SIZE_FLOCK_CODE. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1 = PRESENT; NULL = NOT PRESENT |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PETREL_SHEARWATER_PRESENT_CODE |
|---|---|
| Seq. Order | 26 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code whether PETREL or SHEARWATER was present. Value could also be SIZE_FLOCK_CODE. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1 = PRESENT; NULL = NOT PRESENT |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | STORM_PETREL_PRESENT_CODE |
|---|---|
| Seq. Order | 27 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code whether STORM PETREL was present. Value could also be SIZE_FLOCK_CODE. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1 = PRESENT; NULL = NOT PRESENT |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ALBATROSS_PRESENT_CODE |
|---|---|
| Seq. Order | 28 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code whether ALBATROSS was present. Value could also be SIZE_FLOCK_CODE. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1 = PRESENT; NULL = NOT PRESENT |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OTHER_BIRDS_PRESENT_CODE |
|---|---|
| Seq. Order | 29 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code whether OTHER BIRDS were present. Value could also be SIZE_FLOCK_CODE. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1 = PRESENT; NULL = NOT PRESENT |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SPECIES_CODE_FLOCK_SCHOOL_2 |
|---|---|
| Seq. Order | 30 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Two-digit species code of the bird flock or fish school. |
| 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 | SPECIES_CODE_FLOCK_SCHOOL_5 |
|---|---|
| Seq. Order | 31 |
| Data Storage Type | VARCHAR2 |
| Max Length | 5 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Five-digit CZM species code of the bird flock or fish school. |
| 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 | SPECIES_CODE_FLOCK_SCHOOL |
|---|---|
| Seq. Order | 32 |
| Data Storage Type | VARCHAR2 |
| Max Length | 10 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Ten-digit CZM species code of the bird flock or fish school. Originally two-digit, five_digit or ten-digit species codes resided in the one column. They are now in separate columns, and there is a corresponding ten-digit code for each two-digit and five_digit species code. |
| 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 | AVERAGE_SIZE_FISH_KG |
|---|---|
| Seq. Order | 33 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Average fish weight, in kilograms. Units for values are kilograms. |
| General Data Type | VARCHAR2 |
| Unit of Measure | kilograms |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | AVERAGE_SIZE_FISH_LB |
|---|---|
| Seq. Order | 34 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Average fish weight, in pounds. Units for values are pounds. |
| General Data Type | VARCHAR2 |
| Unit of Measure | pounds |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SIZE_SCHOOL_CODE |
|---|---|
| Seq. Order | 35 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Code for the size of the fish school. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | S = SMALL; M = MEDIUM; L = LARGE; 3 = 11 - 25 (ONE OCCURRENCE) |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TIME_POSITION_TAKEN |
|---|---|
| Seq. Order | 36 |
| Data Storage Type | VARCHAR2 |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Time position taken; the hour field and minute field were merged into one field. |
| 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 | OCTANT_SCATTER |
|---|---|
| Seq. Order | 37 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Octant of the sighting of scattered species. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0 = NORTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 1 = NORTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 2 = NORTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 3 = NORTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE; 5 = SOUTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 6 = SOUTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 7 = SOUTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 8 = SOUTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE_DEGREES_SCATTER |
|---|---|
| Seq. Order | 38 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Latitude degrees when the scattered species was sighted. Units for values are degrees. |
| General Data Type | VARCHAR2 |
| Unit of Measure | degrees |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE_MINUTES_SCATTER |
|---|---|
| Seq. Order | 39 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Latitude minutes when the scattered species was sighted. Units for values are minutes. |
| General Data Type | VARCHAR2 |
| Unit of Measure | minutes |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE_DIRECTION_SCATTER |
|---|---|
| Seq. Order | 40 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Latitude direction when the scattered species was sighted. OCTANT used to determine LATITUDE_DIRECTION_SCATTER (N/S). |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | N = NORTH; S = SOUTH |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE_DD_SCATTER |
|---|---|
| Seq. Order | 41 |
| Data Storage Type | NUMBER |
| Max Length | 42 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | 38 |
| Status | Active |
| Description |
Computed latitude, in decimal degree, when the scattered species was sighted. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
| General Data Type | NUMBER |
| Unit of Measure | degrees |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE_DEGREES_SCATTER |
|---|---|
| Seq. Order | 42 |
| Data Storage Type | VARCHAR2 |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Longitude degrees when the scattered species was sighted. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees. |
| General Data Type | VARCHAR2 |
| Unit of Measure | degrees |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE_MINUTES_SCATTER |
|---|---|
| Seq. Order | 43 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Longitude minutes when the scattered species was sighted. Units for values are minutes. |
| General Data Type | VARCHAR2 |
| Unit of Measure | minutes |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE_DIRECTION_SCATTER |
|---|---|
| Seq. Order | 44 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Longitude direction when the scattered species was sighted. OCTANT used to determine LONGITUDE_DIRECTION_SCATTER (E/W). |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | E = EAST; W = WEST |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE_DD_SCATTER |
|---|---|
| Seq. Order | 45 |
| Data Storage Type | NUMBER |
| Max Length | 41 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | 36 |
| Status | Active |
| Description |
Computed longitude, in decimal degrees, when the scattered species was sighted. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
| General Data Type | NUMBER |
| Unit of Measure | degrees |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SOOTY_TERN_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 46 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for the scattered SOOTY TERN sighted. See SIZE_FLOCK_CODE. |
| 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 | NODDY_TERN_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 47 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for the scattered NODDY TERN sighted. See SIZE_FLOCK_CODE. |
| 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 | WHITE_TERN_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 48 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for the scattered WHITE TERN sighted. See SIZE_FLOCK_CODE. |
| 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 | BOOBY_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 49 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for the scattered BOOBY sighted. See SIZE_FLOCK_CODE. |
| 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 | TROPIC_BIRD_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 50 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for the scattered TROPIC BIRD TERN sighted. See SIZE_FLOCK_CODE. |
| 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 | FRIGATE_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 51 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for the scattered FRIGATE BIRD sighted. See SIZE_FLOCK_CODE. |
| 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 | PETREL_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 52 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for the scattered PETREL or SHEARWATER sighted. See SIZE_FLOCK_CODE. |
| 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 | STORM_PETREL_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 53 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for the scattered STORM PETREL sighted. See SIZE_FLOCK_CODE. |
| General Data Type | VARCHAR2 |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1 = PRESENT; NULL = NOT PRESENT |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ALBATROSS_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 54 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for the scattered ALBATROSS sighted. See SIZE_FLOCK_CODE. |
| 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 | OTHER_BIRDS_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 55 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for the scattered OTHER BIRDS sighted. See SIZE_FLOCK_CODE. |
| 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 | WHALES_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 56 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for the scattered WHALES sighted. See SIZE_FLOCK_CODE. |
| 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 | PORPOISES_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 57 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for the scattered PORPOISES sighted. See SIZE_FLOCK_CODE. |
| 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 | SEALS_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 58 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for the scattered SEALS sighted. See SIZE_FLOCK_CODE. |
| 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 | SPECIES_CODE_OTHERS_SCATTER_2 |
|---|---|
| Seq. Order | 59 |
| Data Storage Type | VARCHAR2 |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Two-digit species code of scattered other species sighted. |
| 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 | SPECIES_CODE_OTHERS_SCATTER_5 |
|---|---|
| Seq. Order | 60 |
| Data Storage Type | VARCHAR2 |
| Max Length | 5 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Five-digit CZM species code of scattered other species sighted. |
| 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 | SPECIES_CODE_OTHERS_SCATTER |
|---|---|
| Seq. Order | 61 |
| Data Storage Type | VARCHAR2 |
| Max Length | 10 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Ten-digit CZM species code of scattered other species sighted. Originally two-digit, five_digit or ten-digit species codes resided in the one column. They are now in separate columns, and there is a corresponding ten-digit code for each two-digit and five_digit species code. |
| 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 | OTHERS_SCATTER_COUNT |
|---|---|
| Seq. Order | 62 |
| Data Storage Type | VARCHAR2 |
| Max Length | 5 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count of scattered other species sighted. |
| 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 | OTHERS_SCATTER_COUNT_CODE |
|---|---|
| Seq. Order | 63 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Count code for scattered other species sighted. See SIZE_FLOCK_CODE. |
| 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 | NUMBER_HOURS_WATCHED_0800 |
|---|---|
| Seq. Order | 64 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Number of hours watched ending at 0800 or the time the position was taken (FIELD 36. |
| 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 | NUMBER_HOURS_WATCHED_1200 |
|---|---|
| Seq. Order | 65 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Number of hours watched ending at 1200 or the time the position was taken (FIELD 36). |
| 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 | NUMBER_HOURS_WATCHED_1600 |
|---|---|
| Seq. Order | 66 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Number of hours watched ending at 1600 or the time the position was taken (FIELD 36). |
| 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 | NUMBER_HOURS_WATCHED_2000 |
|---|---|
| Seq. Order | 67 |
| Data Storage Type | VARCHAR2 |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Number of hours watched ending a 2000 or the time the position was taken (FIELD 36). |
| 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 | JOB_NUMBER |
|---|---|
| Seq. Order | 68 |
| Data Storage Type | VARCHAR2 |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84109. |
| 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 | SEQUENCE_NUMBER |
|---|---|
| Seq. Order | 69 |
| Data Storage Type | VARCHAR2 |
| Max Length | 8 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
A consecutive number assigned to each record for a block of data. |
| 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 | DATE_LOADED |
|---|---|
| Seq. Order | 70 |
| Data Storage Type | DATE |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Date when the record was loaded into Oracle or updated. |
| 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 | |
|---|---|
| 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
» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
| * » 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 |
|---|
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
| * » Time Frame Type | |
|---|---|
| * » Start | |
| End | |
| Alternate Start as of Info | |
| Alternate End as of Info | |
| Description |
Access Information
| * » Security Class | |
|---|---|
| * Security Classification System |
|
| Security Handling Description |
|
| • Data Access Policy |
|
| » Data Access Procedure |
|
| • » Data Access Constraints |
|
| • Data Use Constraints |
|
| 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 | 68938 |
|---|---|
| Metadata Record Created By | Brent M Miyamoto |
| Metadata Record Created | 2022-12-29 01:56+0000 |
| Metadata Record Last Modified By | Brent M Miyamoto |
| » Metadata Record Last Modified | 2023-10-04 02:42+0000 |
| Metadata Record Published | 2023-01-04 |
| Owner Org | PIFSC |
| Metadata Publication Status | Published Externally |
| Do Not Publish? | N |
| Metadata Workflow State | Published / External |
| Metadata Last Review Date | 2023-01-04 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2024-01-04 |
| Tags |
|---|