operation_hook_fact
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 36442
| Published / External
Created: 2017-01-25
|
Last Modified: 2022-08-09
Parent: Southern California Hook and Line Survey - 2020 Southern California Shelf Rockfish Hook and Line Survey
Data Set (DS) | ID: 18433
Data Set (DS) | ID: 18433
ID: 36442
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | operation_hook_fact |
|---|---|
| Short Name | |
| * Status | |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract | |
| * 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? | |
| Alias | |
| Schema Name | |
| » Description |
Operation details down to the hook level |
| Change Summary |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | No | No | vessel | varchar | name of the vessel used for the operation |
| 100 | No | No | net_touchdown_time | time | military time representation of the time |
| 100 | No | No | site_dim$distance_to_port_nm | numeric | distance from site to nearest port in nautical miles |
| 100 | No | No | ctd_drop_latitude_whid | int4 | warehouse identifier for CTD drop latitude |
| 100 | No | No | drop_sounder_depth_dim$depth_meters | numeric | depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
| 100 | No | No | angler_person_dim$full_name | varchar | full name in format of First and Last (Suffix) |
| 100 | No | No | ctd_drop_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction |
| 100 | No | No | ctd_on_bottom_measure_depth_dim$record_type | varchar | depth record or reason record is unavailable |
| 100 | No | No | sampling_end_time_dim$period | bpchar | period of time |
| 100 | No | No | tide_height_mid_ft | numeric | tide height at middle (third) drop for a site measured in feet |
| 100 | No | No | site_dim$site_number | int4 | site identifier number |
| 100 | No | No | drop_latitude_dim$named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location |
| 100 | No | No | operation_dim$state_registration_number | varchar | state registration number for the vessel |
| 100 | No | No | operation_dim$limited_entry_permit_number | bpchar | federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California |
| 100 | No | No | date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
| 100 | No | No | ctd_drop_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction |
| 100 | No | No | drop_longitude_dim$longitude_in_degrees | numeric | numeric representation of longitude in decimal degrees |
| 100 | No | No | ctd_on_bottom_salinity_psu | numeric | CTD on bottom salinity in practical salinity units (psu) |
| 100 | No | No | hook_dim$record_type | varchar | hook record or reason record is unavailable |
| 100 | No | No | ctd_drop_longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only |
| 100 | No | No | marine_reserve_indicator | varchar | identifier if the hook was inside a marine reserve |
| 100 | No | No | operation_dim$scientist_3_person_whid | int4 | person reference for the third scientist |
| 100 | No | No | hook_id | int4 | field database hook identifier |
| 100 | No | No | angler_person_whid | int4 | warehouse identifier for angler person |
| 100 | No | No | tide_height_first_ft | numeric | tide height at first drop for a site measured in feet |
| 100 | No | No | ctd_on_bottom_measure_depth_whid | int4 | warehouse identifier for CTD on bottom measure depth |
| 100 | No | No | ctd_on_bottom_measure_depth_dim$depth_fathoms | numeric | depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
| 100 | No | No | sunset_time_whid | int4 | warehouse identifier for the sunset time |
| 100 | No | No | site_whid | int4 | warehouse identifier for site |
| 100 | No | No | drop_sounder_depth_whid | int4 | warehouse identifier for drop sounder depth |
| 100 | No | No | drop_longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only |
| 100 | No | No | site_moon_tide_dim$tide_phase | varchar | tide phase |
| 100 | No | No | angler_person_dim$nick_name | varchar | nickname of person |
| 100 | No | No | sunrise_time_dim$minute | int2 | number of minutes in the hour |
| 100 | No | No | site_dim$tide_station_latitude_whid | int4 | warehouse identifier to latitude details for site's nearest tide station |
| 100 | No | No | operation_dim$operation_start_date_whid | int8 | start date reference for the operation |
| 100 | No | No | begin_retrieval_interval_sec | int4 | interval in seconds between gear deployment until gear retrieval began |
| 100 | No | No | program | varchar | type of fram program |
| 100 | No | No | date_dim$month_of_year | int2 | numeric representation of month of year |
| 100 | No | No | operation_dim$captain_person_whid | int4 | person reference for the vessel captain |
| 100 | No | No | tide_height_last_ft | numeric | tide height at last (fifth) drop for a site measured in feet |
| 100 | No | No | set_identifier | varchar | set identifier |
| 100 | No | No | inclusion_whid | int4 | warehouse identifier for what to include in analysis |
| 100 | No | No | operation_dim$fpc_person_whid | int4 | person reference for the FPC |
| 100 | No | No | operation_dim$record_type | varchar | operation record or reason record is unavailable |
| 100 | No | No | sampling_start_time_dim$military_hour | int2 | military representation of the hour |
| 100 | No | No | angler_person_dim$role | varchar | role taken during an operation |
| 100 | No | No | drop_latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
| 100 | No | No | ctd_drop_time_dim$period | bpchar | period of time |
| 100 | No | No | ctd_on_bottom_measure_depth_dim$depth_meters | numeric | depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
| 100 | No | No | operation_dim$operation_type | varchar | type of operation |
| 100 | No | No | swell_height_ft | numeric | swell height in feet |
| 100 | No | No | operation_dim$ifq_account_number | varchar | unique number assigned to user accounts in the Vessel Accounting Database |
| 100 | No | No | sunrise_time_dim$record_type | varchar | time record or reason record is unavailable |
| 100 | No | No | sampling_end_time_dim$hour | int2 | standard representation of the hour |
| 100 | No | No | inclusion_dim$record_type | varchar | inclusion record or reason record is unavailable |
| 100 | No | No | sinker_weight_lbs | int2 | sinker weights in pounds |
| 100 | No | No | inclusion_dim$site_inclusion_indicator | varchar | indicates if site should be included |
| 100 | No | No | operation_dim$operation_end_date_whid | int8 | end date reference for the operation |
| 100 | No | No | sampling_start_time_dim$second | int2 | number of seconds in the minute |
| 100 | No | No | site_dim$tide_station_noaa_id | varchar | tide station id according to NOAA's Tides and Currents site |
| 100 | No | No | tide_height_mid_m | numeric | tide height at middle (third) drop for a site measured in meters |
| 100 | No | No | sunset_time_dim$second | int2 | number of seconds in the minute |
| 100 | No | No | site_general_note | varchar | site general notes |
| 100 | No | No | drop_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction |
| 100 | No | No | wave_height_m | numeric | wave height in meters |
| 100 | No | No | hook_note | varchar | hook notes |
| 100 | No | No | site_moon_tide_dim$record_type | varchar | moon tide record or reason record is unavailable |
| 100 | No | No | operation_dim$scientist_4_person_whid | int4 | person reference for the fourth scientist |
| 100 | No | No | drop_average_sea_surface_temp_c | numeric | drop average sea surface temperature in degrees celcius |
| 100 | No | No | ctd_drop_time_whid | int4 | warehouse identifier for CTD drop time |
| 100 | No | No | tow_end_timestamp | timestamp | operation end date timestamp |
| 100 | No | No | site_dim$inactive_date_whid | int8 | warehouse identifier for the date when the site went inactive |
| 100 | No | No | tide_height_first_m | numeric | tide height at first drop for a site measured in meters |
| 100 | No | No | angler_person_dim$record_type | varchar | person record or reason record is unavailable |
| 100 | No | No | pass | int4 | pass number of the survey |
| 100 | No | No | tow_start_timestamp | timestamp | operation start date timestamp |
| 100 | No | No | ctd_on_bottom_measure_depth_dim$boundary_indicator | varchar | depth boundry indicator identifying ifp boundary marks |
| 100 | No | No | ctd_drop_time_dim$minute | int2 | number of minutes in the hour |
| 100 | No | No | sunrise_time_whid | int4 | warehouse identifier for the sunrise time |
| 100 | No | No | drop_time_dim$record_type | varchar | time record or reason record is unavailable |
| 100 | No | No | drop_latitude_dim$latitude_in_degrees | numeric | numeric representation of latitude in degrees |
| 100 | No | No | site_dim$cdfgblock | int4 | CDFG Block Numbers that the sites fall within |
| 100 | No | No | operation_dim$coast_guard_number | varchar | Coast Guard documentation number of vessel |
| 100 | No | No | operation_dim$operation_start_time_whid | int8 | start time reference for the operation |
| 100 | No | No | site_dim$area_name | varchar | name of area site is located in |
| 100 | No | No | time_to_first_bite_interval_sec | int4 | interval in seconds calculated from the difference between first bite and on bottom |
| 100 | No | No | date_dim$full_date | timestamp | full date value |
| 100 | No | No | sunrise_time_dim$hh24miss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| 100 | No | No | site_dim$site_longitude_whid | int4 | warehouse identifier to longitude details for site |
| 100 | No | No | site_dim$cowcod_conservation_area_indicator | varchar | indicates if site falls within the cowcod conservation area |
| 100 | No | No | hook_dim$gear_performance | varchar | Gear performance |
| 100 | No | No | inclusion_dim$drop_inclusion_indicator | varchar | indicates if drop should be included |
| 100 | No | No | sampling_end_time_dim$military_hour | int2 | military representation of the hour |
| 100 | No | No | fishing_time_interval_sec | int4 | interval in seconds calculated from the difference between begin retrieval and on bottomv |
| 100 | No | No | ctd_drop_longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only |
| 100 | No | No | sunset_time_dim$period | bpchar | period of time |
| 100 | No | No | hook_whid | int4 | warehouse identifier to hook details |
| 100 | No | No | swell_direction_mag | int2 | swell direction in magnetic degrees |
| 100 | No | No | net_liftoff_time | time | military time representation of the time |
| 100 | No | No | leg | int2 | leg number of the survey |
| 100 | No | No | hook_dim$hook_number | int2 | The hook number on the line |
| 100 | No | No | site_dim$site_longitude_dd | numeric | site longitude in decimal degrees |
| 100 | No | No | operation_dim$observer_program | varchar | description of the observer program |
| 100 | No | No | drop_timestamp | timestamp | drop timestamp |
| 100 | No | No | drop_sounder_depth_dim$boundary_indicator | varchar | depth boundry indicator identifying ifp boundary marks |
| 100 | No | No | drop_latitude_dd | numeric | drop latitude in decimal degrees |
| 100 | No | No | drop_time_dim$hour | int2 | standard representation of the hour |
| 100 | No | No | date_dim$month_name | varchar | text representation of month |
| 100 | No | No | sunset_time_dim$time | time | military time representation of the time |
| 100 | No | No | sampling_start_time_dim$hour | int2 | standard representation of the hour |
| 100 | No | No | drop_latitude_whid | int4 | warehouse identifier for drop latitude |
| 100 | No | No | ctd_drop_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable |
| 100 | No | No | ctd_drop_time_dim$second | int2 | number of seconds in the minute |
| 100 | No | No | drop_longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
| 100 | No | No | operation_dim_whid | int4 | warehouse identifier for operation |
| 100 | No | No | angler_position | varchar | position of angler on vessel |
| 100 | No | No | sunrise_time_dim$military_hour | int2 | military representation of the hour |
| 100 | No | No | sunrise_time_dim$second | int2 | number of seconds in the minute |
| 100 | No | No | performance | varchar | performance of the operation |
| 100 | No | No | ctd_sounder_depth_m | numeric | CTD sounder depth in meters |
| 100 | No | No | date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
| 100 | No | No | ctd_drop_longitude_whid | int4 | warehouse identifier for CTD drop longitude |
| 100 | No | No | drop_time_dim$hh24miss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| 100 | No | No | ctd_drop_latitude_dd | numeric | high precision value for CTD drop latitude in decimal degrees |
| 100 | No | No | site_ocean_weather_note | varchar | site's ocean and weather notes |
| 100 | No | No | drop_time_whid | int4 | warehouse identifier for the drop time |
| 100 | No | No | operation_dim$departure_port_whid | int4 | port reference for the departure port |
| 100 | No | No | angler_person_dim$first_name | varchar | first name of person |
| 100 | No | No | sampling_end_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| 100 | No | No | operation_dim$field_operation_seg_id | int8 | operation segment id reference to the field operational segment table |
| 100 | No | No | sampling_start_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| 100 | No | No | drop_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction |
| 100 | No | No | site_dim$record_type | varchar | site record or reason record is unavailable |
| 100 | No | No | swell_height_m | numeric | swell height in meters |
| 100 | No | No | ctd_drop_time_dim$hour | int2 | standard representation of the hour |
| 100 | No | No | date_dim$day_of_month | int2 | numeric representation of the day in month |
| 100 | No | No | sea_surface_temp_c | numeric | sea surface temperature in degrees celcius |
| 100 | No | No | operation_dim$scientist_2_person_whid | int4 | person reference for the second scientist |
| 100 | No | No | drop_latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only |
| 100 | No | No | drop_time_dim$second | int2 | number of seconds in the minute |
| 100 | No | No | fish_info_note | varchar | overall fish information note |
| 100 | No | No | date_yyyymmdd | bpchar | text representation of year month day |
| 100 | No | No | drop_time_dim$period | bpchar | period of time |
| 100 | No | No | ctd_drop_latitude_dim$named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location |
| 100 | No | No | site_moon_tide_dim$tide_type | varchar | tide type |
| 100 | No | No | date_dim$year | int4 | numeric representation of year |
| 100 | No | No | sunrise_time_dim$time | time | military time representation of the time |
| 100 | No | No | ctd_drop_latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only |
| 100 | No | No | site_dim$tide_station_longitude_whid | int4 | warehouse identifier to longitude details for site's nearest tide station |
| 100 | No | No | operation_dim$scientist_1_person_whid | int4 | person reference for the first scientist |
| 100 | No | No | sampling_end_time_dim$record_type | varchar | time record or reason record is unavailable |
| 100 | No | No | first_bite_interval_sec | int4 | interval in seconds between gear deployment until angler feels first bite |
| 100 | No | No | site_dim$tide_station_name | varchar | name of nearest tide station |
| 100 | No | No | angler_person_dim$middle_initial | bpchar | middle initial of person |
| 100 | No | No | drop_time_dim$military_hour | int2 | military representation of the hour |
| 100 | No | No | sunset_time_dim$record_type | varchar | time record or reason record is unavailable |
| 100 | No | No | ctd_drop_time_dim$time | time | military time representation of the time |
| 100 | No | No | ctd_on_bottom_disolved_oxygen_sbe43_ml_per_l | numeric | CTD SBE43 sensor on bottom disolved oxygen measured in milliliters per liter |
| 100 | No | No | at_surface_interval_sec | int4 | interval in seconds between gear deployment until gear reaches surface concluding the drop |
| 100 | No | No | ctd_drop_time_dim$military_hour | int2 | military representation of the hour |
| 100 | No | No | site_habitat_note | varchar | site habitat notes |
| 100 | No | No | drop_latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only |
| 100 | No | No | ctd_on_bottom_disolved_oxygen_aanderaa_ml_per_l | numeric | CTD aanderaa sensor on bottom disolved oxygen measured in milliliters per liter |
| 100 | No | No | wave_height_ft | numeric | wave height in feet |
| 100 | No | No | drop_longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only |
| 100 | No | No | ctd_sounder_depth_dim$depth_meters | numeric | depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
| 100 | No | No | ctd_drop_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable |
| 100 | No | No | sampling_start_time_dim$period | bpchar | period of time |
| 100 | No | No | drop_time_dim$time | time | military time representation of the time |
| 100 | No | No | angler_person_dim$last_name | varchar | last name of person |
| 100 | No | No | drop_latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only |
| 100 | No | No | ctd_on_bottom_temp_c | numeric | CTD on bottom temperature in degrees celcius |
| 100 | No | No | drop_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable |
| 100 | No | No | drop_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable |
| 100 | No | No | operation_dim$return_port_whid | int4 | port reference for return port |
| 100 | No | No | sunrise_time_dim$hour | int2 | standard representation of the hour |
| 100 | No | No | sampling_end_time_dim$minute | int2 | number of minutes in the hour |
| 100 | No | No | tide_height_last_m | numeric | tide height at last (fifth) drop for a site measured in meters |
| 100 | No | No | ctd_drop_time_dim$hh24miss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| 100 | No | No | operation_dim$trip_id | int4 | trip identifier number |
| 100 | No | No | project | varchar | project name |
| 100 | No | No | ctd_sounder_depth_dim$record_type | varchar | depth record or reason record is unavailable |
| 100 | No | No | ctd_drop_longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
| 100 | No | No | ctd_sounder_depth_dim$boundary_indicator | varchar | depth boundry indicator identifying ifp boundary marks |
| 100 | No | No | drop_sounder_depth_dim$record_type | varchar | depth record or reason record is unavailable |
| 100 | No | No | drop_longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only |
| 100 | No | No | tow | int2 | operation number of the survey |
| 100 | No | No | ctd_drop_longitude_dim$longitude_in_degrees | numeric | numeric representation of longitude in decimal degrees |
| 100 | No | No | ctd_drop_time_dim$record_type | varchar | time record or reason record is unavailable |
| 100 | No | No | date_whid | int4 | warehouse identifier for date |
| 100 | No | No | sunset_time_dim$military_hour | int2 | military representation of the hour |
| 100 | No | No | on_bottom_interval_sec | int4 | interval in seconds between gear deployment until it hits bottom |
| 100 | No | No | site_dim$site_latitude_dd | numeric | site latitude in decimal degrees |
| 100 | No | No | ctd_drop_longitude_dd | numeric | high precision value for CTD drop longitude in decimal degrees |
| 100 | No | No | ctd_sounder_depth_dim$depth_fathoms | numeric | depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
| 100 | No | No | drop_longitude_dd | numeric | drop longitude in decimal degrees |
| 100 | No | No | hook_dim$hook_result | varchar | The result of using the hook |
| 100 | No | No | operation_dim$operation_end_time_whid | int8 | end time reference for the operation |
| 100 | No | No | drop_sounder_depth_dim$depth_fathoms | numeric | depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
| 100 | No | No | sampling_end_time_dim$second | int2 | number of seconds in the minute |
| 100 | No | No | operation_dim$departure_date_whid | int8 | date reference that vessel departed for the defined leg or trip |
| 100 | No | No | sunset_time_dim$hour | int2 | standard representation of the hour |
| 100 | No | No | sampling_start_time_dim$record_type | varchar | time record or reason record is unavailable |
| 100 | No | No | sunset_time_dim$minute | int2 | number of minutes in the hour |
| 100 | No | No | ctd_drop_latitude_dim$latitude_in_degrees | numeric | numeric representation of latitude in degrees |
| 100 | No | No | site_dim$site_latitude_whid | int4 | warehouse identifier to latitude details for site |
| 100 | No | No | drop_detail_note | varchar | drop detail notes |
| 100 | No | No | sunset_time_dim$hh24miss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| 100 | No | No | drop_time_dim$minute | int2 | number of minutes in the hour |
| 100 | No | No | inclusion_dim$hook_inclusion_indicator | varchar | indicates if hook should be included |
| 100 | No | No | sunrise_time_dim$period | bpchar | period of time |
| 100 | No | No | ctd_drop_latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only |
| 100 | No | No | sampling_start_time_dim$minute | int2 | number of minutes in the hour |
| 100 | No | No | ctd_on_bottom_measure_depth_m | numeric | CTD on bottom measured depth in meters |
| 100 | No | No | operation_dim$vessel_id | int2 | field database vessel id number |
| 100 | No | No | drop_longitude_whid | int4 | warehouse identifier for drop latitude |
| 100 | No | No | operation_dim$return_date_whid | int8 | date reference that vessel returned for the defined leg or trip |
| 100 | No | No | ctd_drop_latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only |
| 100 | No | No | site_moon_tide_whid | int2 | warehouse identifier for site moon tide |
| 100 | No | No | site_moon_tide_dim$moon_phase | varchar | moon phase |
| 100 | No | No | ctd_sounder_depth_whid | int4 | warehouse identifier for CTD sounder depth |
| 100 | No | No | ctd_drop_longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only |
| 100 | No | No | site_fish_finder_note | varchar | site fish finder notes |
| 100 | No | No | year | int2 | operation year |
| 100 | No | No | ctd_drop_latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
| 100 | No | No | sampling_end_time_whid | int4 | warehouse identifier for the sampling end time |
| 100 | No | No | sampling_start_time_whid | int4 | warehouse identifier for the sampling start time |
| 100 | No | No | full_moon_pct | int2 | percent of full moon |
| 100 | No | No | trawl_id | int8 | identifier for a sampling operation |
Attribute Details
| Attribute Name | vessel |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 50 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
name of the vessel used for the operation |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Aggressor, Amy Lynn, BJ Thomas, Blue Horizon, Captain Jack, Coast Pride, Excalibur, Last Straw, Limit Stalker, Mirage, Miss Leona, Morning Star, Ms. Julie, Noahs Ark, Pacific Sun IV, Raven, Sea Eagle, Toronado |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | net_touchdown_time |
|---|---|
| Seq. Order | |
| Data Storage Type | time |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
military time representation of the time |
| General Data Type | |
| 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 | site_dim$distance_to_port_nm |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 1 |
| Scale | |
| Status | Active |
| Description |
distance from site to nearest port in nautical miles |
| General Data Type | |
| Unit of Measure | m |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_latitude_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for CTD drop latitude |
| General Data Type | |
| 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 | drop_sounder_depth_dim$depth_meters |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | |
| Status | Active |
| Description |
depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
| General Data Type | |
| Unit of Measure | m |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-1500 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | angler_person_dim$full_name |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 100 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
full name in format of First and Last (Suffix) |
| General Data Type | |
| 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 | ctd_drop_longitude_dim$longitude_compass_direction |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
longitude compass direction |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | E, W |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_on_bottom_measure_depth_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
depth record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sampling_end_time_dim$period |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
period of time |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | AM, PM |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | tide_height_mid_ft |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 1 |
| Scale | |
| Status | Active |
| Description |
tide height at middle (third) drop for a site measured in feet |
| General Data Type | |
| Unit of Measure | ft |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_dim$site_number |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
site identifier number |
| General Data Type | |
| 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 | drop_latitude_dim$named_parallel |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 50 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
name of parallel, boundary, or commonly used geograpical location |
| General Data Type | |
| Unit of Measure | NA |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | any |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | operation_dim$state_registration_number |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
state registration number for the vessel |
| General Data Type | |
| 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 | operation_dim$limited_entry_permit_number |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California |
| General Data Type | |
| 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_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
date, month, or year record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_latitude_dim$latitude_compass_direction |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
latitude compass direction |
| General Data Type | |
| Unit of Measure | NA |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | N, S |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_longitude_dim$longitude_in_degrees |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 8 |
| Scale | |
| Status | Active |
| Description |
numeric representation of longitude in decimal degrees |
| General Data Type | |
| Unit of Measure | dd |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | -180 to 180 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_on_bottom_salinity_psu |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 2 |
| Scale | |
| Status | Active |
| Description |
CTD on bottom salinity in practical salinity units (psu) |
| General Data Type | |
| Unit of Measure | psu |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | hook_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 25 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
hook record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Hook, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_longitude_dim$longitude_minute_units |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of longitude that makes up the minute unit only |
| General Data Type | |
| Unit of Measure | min |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-59 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | marine_reserve_indicator |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 20 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
identifier if the hook was inside a marine reserve |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Is Marine Reserve, Not Marine Reserve, NA |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | operation_dim$scientist_3_person_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
person reference for the third scientist |
| General Data Type | |
| 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 | hook_id |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
field database hook identifier |
| General Data Type | |
| 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 | angler_person_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for angler person |
| General Data Type | |
| 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 | tide_height_first_ft |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 1 |
| Scale | |
| Status | Active |
| Description |
tide height at first drop for a site measured in feet |
| General Data Type | |
| Unit of Measure | ft |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_on_bottom_measure_depth_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for CTD on bottom measure depth |
| General Data Type | |
| 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 | ctd_on_bottom_measure_depth_dim$depth_fathoms |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | |
| Status | Active |
| Description |
depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
| General Data Type | |
| Unit of Measure | fth |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sunset_time_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for the sunset time |
| General Data Type | |
| 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 | site_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for site |
| General Data Type | |
| 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 | drop_sounder_depth_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for drop sounder depth |
| General Data Type | |
| 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 | drop_longitude_dim$longitude_second_units |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of longitude that makes up the second unit only |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-59 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_moon_tide_dim$tide_phase |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 10 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
tide phase |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Ebb, Flood, Steady |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | angler_person_dim$nick_name |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
nickname of person |
| General Data Type | |
| 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 | sunrise_time_dim$minute |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
number of minutes in the hour |
| General Data Type | |
| Unit of Measure | min |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_dim$tide_station_latitude_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier to latitude details for site's nearest tide station |
| General Data Type | |
| 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 | operation_dim$operation_start_date_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int8 |
| Max Length | 64 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
start date reference for the operation |
| General Data Type | |
| 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 | begin_retrieval_interval_sec |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
interval in seconds between gear deployment until gear retrieval began |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | program |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 50 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
type of fram program |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Bottom Trawl, Hook and Line |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | date_dim$month_of_year |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of month of year |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1-12 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | operation_dim$captain_person_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
person reference for the vessel captain |
| General Data Type | |
| 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 | tide_height_last_ft |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 1 |
| Scale | |
| Status | Active |
| Description |
tide height at last (fifth) drop for a site measured in feet |
| General Data Type | |
| Unit of Measure | ft |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | set_identifier |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
set identifier |
| General Data Type | |
| 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 | inclusion_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for what to include in analysis |
| General Data Type | |
| 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 | operation_dim$fpc_person_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
person reference for the FPC |
| General Data Type | |
| 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 | operation_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
operation record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sampling_start_time_dim$military_hour |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
military representation of the hour |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-24 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | angler_person_dim$role |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
role taken during an operation |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Captain, 2nd Captain, FPC, Cook, Scientist, Deck Hand |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_latitude_dim$latitude_in_degree_minute_second |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 20 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
| General Data Type | |
| Unit of Measure | NA |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | any |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_time_dim$period |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
period of time |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | AM, PM |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_on_bottom_measure_depth_dim$depth_meters |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | |
| Status | Active |
| Description |
depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
| General Data Type | |
| Unit of Measure | m |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-1500 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | operation_dim$operation_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 20 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
type of operation |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null] |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | swell_height_ft |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 1 |
| Scale | |
| Status | Active |
| Description |
swell height in feet |
| General Data Type | |
| Unit of Measure | ft |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | operation_dim$ifq_account_number |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
unique number assigned to user accounts in the Vessel Accounting Database |
| General Data Type | |
| 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 | sunrise_time_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
time record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sampling_end_time_dim$hour |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
standard representation of the hour |
| General Data Type | |
| Unit of Measure | hr |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-12 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | inclusion_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 25 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
inclusion record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Inclusion, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sinker_weight_lbs |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
sinker weights in pounds |
| General Data Type | |
| Unit of Measure | lbs |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | inclusion_dim$site_inclusion_indicator |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 25 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
indicates if site should be included |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Include Site, Do Not Include Site, NA |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | operation_dim$operation_end_date_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int8 |
| Max Length | 64 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
end date reference for the operation |
| General Data Type | |
| 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 | sampling_start_time_dim$second |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
number of seconds in the minute |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_dim$tide_station_noaa_id |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 8 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
tide station id according to NOAA's Tides and Currents site |
| General Data Type | |
| 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 | tide_height_mid_m |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 8 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | |
| Status | Active |
| Description |
tide height at middle (third) drop for a site measured in meters |
| General Data Type | |
| Unit of Measure | m |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sunset_time_dim$second |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
number of seconds in the minute |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_general_note |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 1000 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
site general notes |
| General Data Type | |
| 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 | drop_longitude_dim$longitude_compass_direction |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
longitude compass direction |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | E, W |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | wave_height_m |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 8 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | |
| Status | Active |
| Description |
wave height in meters |
| General Data Type | |
| Unit of Measure | m |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | hook_note |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 1000 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
hook notes |
| General Data Type | |
| 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 | site_moon_tide_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 20 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
moon tide record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Moon_Tide, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | operation_dim$scientist_4_person_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
person reference for the fourth scientist |
| General Data Type | |
| 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 | drop_average_sea_surface_temp_c |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 1 |
| Scale | |
| Status | Active |
| Description |
drop average sea surface temperature in degrees celcius |
| General Data Type | |
| Unit of Measure | c |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_time_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for CTD drop time |
| General Data Type | |
| 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 | tow_end_timestamp |
|---|---|
| Seq. Order | |
| Data Storage Type | timestamp |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
operation end date timestamp |
| General Data Type | |
| 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 | site_dim$inactive_date_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int8 |
| Max Length | 64 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for the date when the site went inactive |
| General Data Type | |
| 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 | tide_height_first_m |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 8 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | |
| Status | Active |
| Description |
tide height at first drop for a site measured in meters |
| General Data Type | |
| Unit of Measure | m |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | angler_person_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 20 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
person record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Person, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | pass |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
pass number of the survey |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1,2,3,4 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | tow_start_timestamp |
|---|---|
| Seq. Order | |
| Data Storage Type | timestamp |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
operation start date timestamp |
| General Data Type | |
| 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 | ctd_on_bottom_measure_depth_dim$boundary_indicator |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 40 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
depth boundry indicator identifying ifp boundary marks |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | IFP Boundary Depth, Standard Contour Depth, NA |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_time_dim$minute |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
number of minutes in the hour |
| General Data Type | |
| Unit of Measure | min |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sunrise_time_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for the sunrise time |
| General Data Type | |
| 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 | drop_time_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
time record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_latitude_dim$latitude_in_degrees |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 8 |
| Scale | |
| Status | Active |
| Description |
numeric representation of latitude in degrees |
| General Data Type | |
| Unit of Measure | dd |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | -90 to 90 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_dim$cdfgblock |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
CDFG Block Numbers that the sites fall within |
| General Data Type | |
| 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 | operation_dim$coast_guard_number |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 10 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Coast Guard documentation number of vessel |
| General Data Type | |
| 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 | operation_dim$operation_start_time_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int8 |
| Max Length | 64 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
start time reference for the operation |
| General Data Type | |
| 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 | site_dim$area_name |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 50 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
name of area site is located in |
| General Data Type | |
| 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_to_first_bite_interval_sec |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
interval in seconds calculated from the difference between first bite and on bottom |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | date_dim$full_date |
|---|---|
| Seq. Order | |
| Data Storage Type | timestamp |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
full date value |
| General Data Type | |
| 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 | sunrise_time_dim$hh24miss |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| General Data Type | |
| 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 | site_dim$site_longitude_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier to longitude details for site |
| General Data Type | |
| 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 | site_dim$cowcod_conservation_area_indicator |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 40 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
indicates if site falls within the cowcod conservation area |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Inside_Cowcod_Conservancy_Area, Outside_Cowcod_Conservancy_Area. |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | hook_dim$gear_performance |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Gear performance |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No Problems, Lost Sinker, Minor Tangle, Major Tangle, Lost Gangion, Lost Hook(s), Missing Time, Multiple Hook, Gear Not Deployed |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | inclusion_dim$drop_inclusion_indicator |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 25 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
indicates if drop should be included |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Include Drop, Do Not Include Drop, NA |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sampling_end_time_dim$military_hour |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
military representation of the hour |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-24 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | fishing_time_interval_sec |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
interval in seconds calculated from the difference between begin retrieval and on bottomv |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_longitude_dim$longitude_second_units |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of longitude that makes up the second unit only |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-59 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sunset_time_dim$period |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
period of time |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | AM, PM |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | hook_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier to hook details |
| General Data Type | |
| 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 | swell_direction_mag |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
swell direction in magnetic degrees |
| General Data Type | |
| Unit of Measure | mag |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | net_liftoff_time |
|---|---|
| Seq. Order | |
| Data Storage Type | time |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
military time representation of the time |
| General Data Type | |
| 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 | leg |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
leg number of the survey |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1,2,3,4,5,6,7,8 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | hook_dim$hook_number |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
The hook number on the line |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1-5 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_dim$site_longitude_dd |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 6 |
| Scale | |
| Status | Active |
| Description |
site longitude in decimal degrees |
| General Data Type | |
| Unit of Measure | dd |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | operation_dim$observer_program |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
description of the observer program |
| General Data Type | |
| 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 | drop_timestamp |
|---|---|
| Seq. Order | |
| Data Storage Type | timestamp |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
drop timestamp |
| General Data Type | |
| 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 | drop_sounder_depth_dim$boundary_indicator |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 40 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
depth boundry indicator identifying ifp boundary marks |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | IFP Boundary Depth, Standard Contour Depth, NA |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_latitude_dd |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 6 |
| Scale | |
| Status | Active |
| Description |
drop latitude in decimal degrees |
| General Data Type | |
| Unit of Measure | dd |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_time_dim$hour |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
standard representation of the hour |
| General Data Type | |
| Unit of Measure | hr |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-12 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | date_dim$month_name |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 10 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
text representation of month |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sunset_time_dim$time |
|---|---|
| Seq. Order | |
| Data Storage Type | time |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
military time representation of the time |
| General Data Type | |
| 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 | sampling_start_time_dim$hour |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
standard representation of the hour |
| General Data Type | |
| Unit of Measure | hr |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-12 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_latitude_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for drop latitude |
| General Data Type | |
| 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 | ctd_drop_latitude_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
latitude record type or reason record is unavailable |
| General Data Type | |
| Unit of Measure | NA |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_time_dim$second |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
number of seconds in the minute |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_longitude_dim$longitude_in_degree_minute_second |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 20 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
| General Data Type | |
| 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 | operation_dim_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for operation |
| General Data Type | |
| 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 | angler_position |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 10 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
position of angler on vessel |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Bow (a), Mid-ship (b), Stern (c) |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sunrise_time_dim$military_hour |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
military representation of the hour |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-24 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sunrise_time_dim$second |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
number of seconds in the minute |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | performance |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 25 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
performance of the operation |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_sounder_depth_m |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | |
| Status | Active |
| Description |
CTD sounder depth in meters |
| General Data Type | |
| Unit of Measure | m |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | date_dim$month_abbrev |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 3 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
three character representation of month in capital letters |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_longitude_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for CTD drop longitude |
| General Data Type | |
| 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 | drop_time_dim$hh24miss |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| General Data Type | |
| 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 | ctd_drop_latitude_dd |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 6 |
| Scale | |
| Status | Active |
| Description |
high precision value for CTD drop latitude in decimal degrees |
| General Data Type | |
| Unit of Measure | dd |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_ocean_weather_note |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 1000 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
site's ocean and weather notes |
| General Data Type | |
| 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 | drop_time_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for the drop time |
| General Data Type | |
| 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 | operation_dim$departure_port_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
port reference for the departure port |
| General Data Type | |
| 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 | angler_person_dim$first_name |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
first name of person |
| General Data Type | |
| 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 | sampling_end_hhmmss |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| General Data Type | |
| 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 | operation_dim$field_operation_seg_id |
|---|---|
| Seq. Order | |
| Data Storage Type | int8 |
| Max Length | 64 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
operation segment id reference to the field operational segment table |
| General Data Type | |
| 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 | sampling_start_hhmmss |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| General Data Type | |
| 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 | drop_latitude_dim$latitude_compass_direction |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
latitude compass direction |
| General Data Type | |
| Unit of Measure | NA |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | N, S |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
site record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Site, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | swell_height_m |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 8 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | |
| Status | Active |
| Description |
swell height in meters |
| General Data Type | |
| Unit of Measure | m |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_time_dim$hour |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
standard representation of the hour |
| General Data Type | |
| Unit of Measure | hr |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-12 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | date_dim$day_of_month |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of the day in month |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1-31 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sea_surface_temp_c |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 2 |
| Scale | |
| Status | Active |
| Description |
sea surface temperature in degrees celcius |
| General Data Type | |
| Unit of Measure | c |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | operation_dim$scientist_2_person_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
person reference for the second scientist |
| General Data Type | |
| 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 | drop_latitude_dim$latitude_degree_units |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of latitude that makes up the degree unit only |
| General Data Type | |
| Unit of Measure | deg |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | -90 to 90 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_time_dim$second |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
number of seconds in the minute |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | fish_info_note |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 1000 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
overall fish information note |
| General Data Type | |
| 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_yyyymmdd |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 8 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
text representation of year month day |
| General Data Type | |
| 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 | drop_time_dim$period |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
period of time |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | AM, PM |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_latitude_dim$named_parallel |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 50 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
name of parallel, boundary, or commonly used geograpical location |
| General Data Type | |
| Unit of Measure | NA |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | any |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_moon_tide_dim$tide_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 10 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
tide type |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Spring, Neap, Neither |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | date_dim$year |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of year |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 1978+ |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sunrise_time_dim$time |
|---|---|
| Seq. Order | |
| Data Storage Type | time |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
military time representation of the time |
| General Data Type | |
| 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 | ctd_drop_latitude_dim$latitude_degree_units |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of latitude that makes up the degree unit only |
| General Data Type | |
| Unit of Measure | deg |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | -90 to 90 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_dim$tide_station_longitude_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier to longitude details for site's nearest tide station |
| General Data Type | |
| 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 | operation_dim$scientist_1_person_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
person reference for the first scientist |
| General Data Type | |
| 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 | sampling_end_time_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
time record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | first_bite_interval_sec |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
interval in seconds between gear deployment until angler feels first bite |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_dim$tide_station_name |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 60 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
name of nearest tide station |
| General Data Type | |
| 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 | angler_person_dim$middle_initial |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 1 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
middle initial of person |
| General Data Type | |
| 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 | drop_time_dim$military_hour |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
military representation of the hour |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-24 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sunset_time_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
time record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_time_dim$time |
|---|---|
| Seq. Order | |
| Data Storage Type | time |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
military time representation of the time |
| General Data Type | |
| 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 | ctd_on_bottom_disolved_oxygen_sbe43_ml_per_l |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 2 |
| Scale | |
| Status | Active |
| Description |
CTD SBE43 sensor on bottom disolved oxygen measured in milliliters per liter |
| General Data Type | |
| Unit of Measure | ml/l |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | at_surface_interval_sec |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
interval in seconds between gear deployment until gear reaches surface concluding the drop |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_time_dim$military_hour |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
military representation of the hour |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-24 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_habitat_note |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 1000 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
site habitat notes |
| General Data Type | |
| 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 | drop_latitude_dim$latitude_second_units |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of latitude that makes up the second unit only |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_on_bottom_disolved_oxygen_aanderaa_ml_per_l |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 2 |
| Scale | |
| Status | Active |
| Description |
CTD aanderaa sensor on bottom disolved oxygen measured in milliliters per liter |
| General Data Type | |
| Unit of Measure | ml/l |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | wave_height_ft |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 4 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 1 |
| Scale | |
| Status | Active |
| Description |
wave height in feet |
| General Data Type | |
| Unit of Measure | ft |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_longitude_dim$longitude_minute_units |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of longitude that makes up the minute unit only |
| General Data Type | |
| Unit of Measure | min |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-59 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_sounder_depth_dim$depth_meters |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | |
| Status | Active |
| Description |
depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
| General Data Type | |
| Unit of Measure | m |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-1500 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_longitude_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 50 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
longitude record type or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sampling_start_time_dim$period |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
period of time |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | AM, PM |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_time_dim$time |
|---|---|
| Seq. Order | |
| Data Storage Type | time |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
military time representation of the time |
| General Data Type | |
| 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 | angler_person_dim$last_name |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
last name of person |
| General Data Type | |
| 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 | drop_latitude_dim$latitude_minute_units |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of latitude that makes up the minute unit only |
| General Data Type | |
| Unit of Measure | min |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_on_bottom_temp_c |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 2 |
| Scale | |
| Status | Active |
| Description |
CTD on bottom temperature in degrees celcius |
| General Data Type | |
| Unit of Measure | c |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_latitude_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
latitude record type or reason record is unavailable |
| General Data Type | |
| Unit of Measure | NA |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_longitude_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 50 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
longitude record type or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | operation_dim$return_port_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
port reference for return port |
| General Data Type | |
| 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 | sunrise_time_dim$hour |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
standard representation of the hour |
| General Data Type | |
| Unit of Measure | hr |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-12 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sampling_end_time_dim$minute |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
number of minutes in the hour |
| General Data Type | |
| Unit of Measure | min |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | tide_height_last_m |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 8 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | |
| Status | Active |
| Description |
tide height at last (fifth) drop for a site measured in meters |
| General Data Type | |
| Unit of Measure | m |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_time_dim$hh24miss |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| General Data Type | |
| 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 | operation_dim$trip_id |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
trip identifier number |
| General Data Type | |
| 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 | project |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 50 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
project name |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Groundfish Shelf Survey, Groundfish Slope and Shelf Combination Survery, Groundfish Slope Survey, Groundfish Triennial Shelf Survery, Hypoxia Study, Santa Barbara Basin Study, Shelf Rockfish [2004-2015], Video Study |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_sounder_depth_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
depth record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_longitude_dim$longitude_in_degree_minute_second |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 20 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
| General Data Type | |
| 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 | ctd_sounder_depth_dim$boundary_indicator |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 40 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
depth boundry indicator identifying ifp boundary marks |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | IFP Boundary Depth, Standard Contour Depth, NA |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_sounder_depth_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
depth record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_longitude_dim$longitude_degree_units |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of longitude that makes up the degree unit only |
| General Data Type | |
| Unit of Measure | deg |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | -180 to 180 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | tow |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
operation number of the survey |
| General Data Type | |
| 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 | ctd_drop_longitude_dim$longitude_in_degrees |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 8 |
| Scale | |
| Status | Active |
| Description |
numeric representation of longitude in decimal degrees |
| General Data Type | |
| Unit of Measure | dd |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | -180 to 180 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_time_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
time record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | date_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for date |
| General Data Type | |
| 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 | sunset_time_dim$military_hour |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
military representation of the hour |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-24 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | on_bottom_interval_sec |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
interval in seconds between gear deployment until it hits bottom |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_dim$site_latitude_dd |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 6 |
| Scale | |
| Status | Active |
| Description |
site latitude in decimal degrees |
| General Data Type | |
| Unit of Measure | dd |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_longitude_dd |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 6 |
| Scale | |
| Status | Active |
| Description |
high precision value for CTD drop longitude in decimal degrees |
| General Data Type | |
| Unit of Measure | dd |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_sounder_depth_dim$depth_fathoms |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | |
| Status | Active |
| Description |
depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
| General Data Type | |
| Unit of Measure | fth |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | drop_longitude_dd |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 6 |
| Scale | |
| Status | Active |
| Description |
drop longitude in decimal degrees |
| General Data Type | |
| Unit of Measure | dd |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | hook_dim$hook_result |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 25 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
The result of using the hook |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | No Bait On Hook, Bait Back On Hook, No Hook, Multiple Hook, Fish, Angler Did Not Drop |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | operation_dim$operation_end_time_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int8 |
| Max Length | 64 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
end time reference for the operation |
| General Data Type | |
| 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 | drop_sounder_depth_dim$depth_fathoms |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | |
| Status | Active |
| Description |
depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
| General Data Type | |
| Unit of Measure | fth |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sampling_end_time_dim$second |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
number of seconds in the minute |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | operation_dim$departure_date_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int8 |
| Max Length | 64 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
date reference that vessel departed for the defined leg or trip |
| General Data Type | |
| 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 | sunset_time_dim$hour |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
standard representation of the hour |
| General Data Type | |
| Unit of Measure | hr |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-12 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sampling_start_time_dim$record_type |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
time record or reason record is unavailable |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sunset_time_dim$minute |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
number of minutes in the hour |
| General Data Type | |
| Unit of Measure | min |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_latitude_dim$latitude_in_degrees |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 8 |
| Scale | |
| Status | Active |
| Description |
numeric representation of latitude in degrees |
| General Data Type | |
| Unit of Measure | dd |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | -90 to 90 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_dim$site_latitude_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier to latitude details for site |
| General Data Type | |
| 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 | drop_detail_note |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 1000 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
drop detail notes |
| General Data Type | |
| 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 | sunset_time_dim$hh24miss |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 6 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| General Data Type | |
| 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 | drop_time_dim$minute |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
number of minutes in the hour |
| General Data Type | |
| Unit of Measure | min |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | inclusion_dim$hook_inclusion_indicator |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 25 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
indicates if hook should be included |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Include Hook, Do Not Include Hook, NA |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sunrise_time_dim$period |
|---|---|
| Seq. Order | |
| Data Storage Type | bpchar |
| Max Length | 2 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
period of time |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | AM, PM |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_latitude_dim$latitude_second_units |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of latitude that makes up the second unit only |
| General Data Type | |
| Unit of Measure | sec |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sampling_start_time_dim$minute |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
number of minutes in the hour |
| General Data Type | |
| Unit of Measure | min |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_on_bottom_measure_depth_m |
|---|---|
| Seq. Order | |
| Data Storage Type | numeric |
| Max Length | 12 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 4 |
| Scale | |
| Status | Active |
| Description |
CTD on bottom measured depth in meters |
| General Data Type | |
| Unit of Measure | m |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | operation_dim$vessel_id |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
field database vessel id number |
| General Data Type | |
| 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 | drop_longitude_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for drop latitude |
| General Data Type | |
| 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 | operation_dim$return_date_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int8 |
| Max Length | 64 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
date reference that vessel returned for the defined leg or trip |
| General Data Type | |
| 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 | ctd_drop_latitude_dim$latitude_minute_units |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of latitude that makes up the minute unit only |
| General Data Type | |
| Unit of Measure | min |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 0-60 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_moon_tide_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for site moon tide |
| General Data Type | |
| 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 | site_moon_tide_dim$moon_phase |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 15 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
moon phase |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | New Moon, Waxing Crescent, First Quarter, Waxing Gibbous, Waning Gibbous, Third Quarter, Waning Crescent, Full Moon |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_sounder_depth_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for CTD sounder depth |
| General Data Type | |
| 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 | ctd_drop_longitude_dim$longitude_degree_units |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
numeric representation of longitude that makes up the degree unit only |
| General Data Type | |
| Unit of Measure | deg |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | -180 to 180 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | site_fish_finder_note |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 1000 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
site fish finder notes |
| General Data Type | |
| 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 | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
operation year |
| General Data Type | |
| Unit of Measure | year |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | 2007+ |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ctd_drop_latitude_dim$latitude_in_degree_minute_second |
|---|---|
| Seq. Order | |
| Data Storage Type | varchar |
| Max Length | 20 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
| General Data Type | |
| Unit of Measure | NA |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | any |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | sampling_end_time_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for the sampling end time |
| General Data Type | |
| 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 | sampling_start_time_whid |
|---|---|
| Seq. Order | |
| Data Storage Type | int4 |
| Max Length | 32 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
warehouse identifier for the sampling start time |
| General Data Type | |
| 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 | full_moon_pct |
|---|---|
| Seq. Order | |
| Data Storage Type | int2 |
| Max Length | 16 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
percent of full moon |
| General Data Type | |
| 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 | trawl_id |
|---|---|
| Seq. Order | |
| Data Storage Type | int8 |
| Max Length | 64 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 0 |
| Scale | |
| Status | Active |
| Description |
identifier for a sampling operation |
| General Data Type | |
| 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 | 36442 |
|---|---|
| Metadata Record Created By | Jeffrey W Cowen |
| Metadata Record Created | 2017-01-25 13:19+0000 |
| Metadata Record Last Modified By | SysAdmin InPortAdmin |
| » Metadata Record Last Modified | 2022-08-09 17:11+0000 |
| Metadata Record Published | 2017-02-13 |
| Owner Org | NWFSC |
| Metadata Publication Status | Published Externally |
| Do Not Publish? | N |
| Metadata Workflow State | Published / External |
| Metadata Last Review Date | 2017-02-13 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2018-02-13 |
| Tags |
|---|