catch_hooknline_view
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 36440
| Published / External
Created: 2017-01-25
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 18433
ID: 36440
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | catch_hooknline_view |
---|---|
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 View |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description |
Detail and aggregate catch data given a date at a site and species caught |
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 | best_available_taxonomy_dim$structure_source | varchar | Source of the taxonomic structure |
100 | No | No | ctd_drop_time_dim$hour | int2 | standard representation of the hour |
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 | best_available_taxonomy_dim$genus_70 | varchar | genus name |
100 | No | No | ctd_drop_latitude_whid | int4 | warehouse identifier for CTD drop latitude |
100 | No | No | species_category | varchar | upper-level taxonomic ranking |
100 | No | No | best_available_taxonomy_dim$subfamily_52 | varchar | subfamily name |
100 | No | No | scientist_1_person_dim$full_name | varchar | full name in format of First and Last (Suffix) |
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 | fpc_person_whid | int4 | warehouse identifier for the FPC |
100 | No | No | site_dim$site_number | int4 | site identifier number |
100 | No | No | best_available_taxonomy_dim$itis_taxonomic_serial_no | int4 | ITIS taxonomic identifier |
100 | No | No | scientist_2_person_whid | int4 | warehouse identifier for the second scientist |
100 | No | No | best_available_taxonomy_dim$grp_nonstandard_taxon_99 | varchar | a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design |
100 | No | No | date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | tide_height_last_ft | numeric | tide height at last (fifth) drop for a site measured in feet |
100 | No | No | captain_person_dim$first_name | varchar | first name of person |
100 | No | No | ctd_drop_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction |
100 | No | No | best_available_taxonomy_dim$superfamily_48 | varchar | superfamily name |
100 | No | No | departure_port_dim$state_abbrev | bpchar | two letter state abbreviation |
100 | No | No | departure_port_dim$state_name | varchar | state name |
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 | best_available_taxonomy_dim$acoustics_species_id | int4 | Species ID used in the acoustics program |
100 | No | No | best_available_taxonomy_dim$worms_aphiaid | int4 | WoRMS taxonomic identifier |
100 | No | No | scientist_1_person_whid | int4 | warehouse identifier for the first scientist |
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 | fpc_person_dim$role | varchar | role taken during an operation |
100 | No | No | operation_type | varchar | type of operation |
100 | No | No | captain_person_dim$last_name | varchar | last name of person |
100 | No | No | fpc_person_dim$last_name | varchar | last name of person |
100 | No | No | total_catch_numbers | int8 | a count off the number of species caught at a site |
100 | No | No | scientist_2_person_dim$full_name | varchar | full name in format of First and Last (Suffix) |
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 | return_port_dim$state_abbrev | bpchar | two letter state abbreviation |
100 | No | No | departure_port_dim$port_group_name | varchar | port group name for observer program |
100 | No | No | fpc_person_dim$record_type | varchar | person record or reason record is unavailable |
100 | No | No | best_available_taxonomy_dim$record_type | varchar | record or reason record is unavailable |
100 | No | No | sunrise_time_dim$hour | int2 | standard representation of the hour |
100 | No | No | departure_port_whid | int4 | warehouse identifier for the departure port |
100 | No | No | ctd_sounder_depth_dim$record_type | varchar | depth record or reason record is unavailable |
100 | No | No | best_available_taxonomy_dim$family_50 | varchar | family name |
100 | No | No | set_identifier | varchar | set identifier |
100 | No | No | departure_port_dim$port_code | bpchar | port code for observer program |
100 | No | No | best_available_taxonomy_dim$kingdom_10 | varchar | kingdom name |
100 | No | No | best_available_taxonomy_dim$class_30 | varchar | class name |
100 | No | No | sampling_start_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
100 | No | No | sampling_start_time_dim$military_hour | int2 | military representation of the hour |
100 | No | No | departure_port_dim$port_name_caps | varchar | port name in all capitals format |
100 | No | No | pacfin_spid | varchar | pacfin species id - many taxa may not have one of these |
100 | No | No | leg | int2 | leg number for the survey |
100 | No | No | return_port_dim$record_type | varchar | port record or reason record is unavailable |
100 | No | No | return_port_dim$state_name | varchar | state name |
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 | ctd_on_bottom_salinity_psu | numeric | CTD on bottom salinity in practical salinity units (psu) |
100 | No | No | best_available_taxonomy_dim$observer_species_id | int4 | species identifier used by the observer program |
100 | No | No | scientist_2_person_dim$last_name | varchar | last name of person |
100 | No | No | sunrise_time_dim$record_type | varchar | time record or reason record is unavailable |
100 | No | No | sampling_end_time_dim$record_type | varchar | time record or reason record is unavailable |
100 | No | No | scientist_2_person_dim$record_type | varchar | person record or reason record is unavailable |
100 | No | No | departure_port_dim$record_type | varchar | port record or reason record is unavailable |
100 | No | No | sampling_start_time_dim$second | int2 | number of seconds in the minute |
100 | No | No | scientist_2_person_dim$middle_initial | bpchar | middle initial of person |
100 | No | No | tide_height_mid_ft | numeric | tide height at middle (third) drop for a site measured in feet |
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 | captain_person_dim$middle_initial | bpchar | middle initial of person |
100 | No | No | site_general_note | varchar | site general notes |
100 | No | No | captain_person_dim$role | varchar | role taken during an operation |
100 | No | No | ctd_sounder_depth_dim$boundary_indicator | varchar | depth boundry indicator identifying ifp boundary marks |
100 | No | No | sampling_end_time_whid | int4 | warehouse identifier for the sampling end time |
100 | No | No | ctd_drop_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction |
100 | No | No | best_available_taxonomy_dim$abbreviated_name | varchar | specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
100 | No | No | ctd_drop_time_whid | int4 | warehouse identifier for CTD drop time |
100 | No | No | site_dim$inactive_date_whid | int8 | warehouse identifier for the date when the site went inactive |
100 | No | No | scientist_2_person_dim$role | varchar | role taken during an operation |
100 | No | No | tide_height_first_m | numeric | tide height at first drop for a site measured in meters |
100 | No | No | return_port_dim$port_name_std | varchar | port name in standard format |
100 | No | No | ctd_drop_time_dim$minute | int2 | number of minutes in the hour |
100 | No | No | best_available_taxonomy_dim$superorder_38 | varchar | superorder name |
100 | No | No | sunrise_time_whid | int4 | Warehouse identifier for the sunrise time |
100 | No | No | best_available_taxonomy_dim$hookandline_species_id | int4 | species identifier used by hook and line |
100 | No | No | return_port_dim$port_group_code | bpchar | port group code for observer program |
100 | No | No | species_subcategory | varchar | mid-level taxonomic ranking |
100 | No | No | site_dim$cdfgblock | int4 | CDFG Block Numbers that the sites fall within |
100 | No | No | date_dim$month_name | varchar | text representation of month |
100 | No | No | sunrise_time_dim$military_hour | int2 | military representation of the hour |
100 | No | No | site_dim$area_name | varchar | name of area site is located in |
100 | No | No | date_dim$full_date | timestamp | full date value |
100 | No | No | swell_direction_mag | int2 | swell direction in magnetic degrees |
100 | No | No | site_dim$cowcod_conservation_area_indicator | varchar | indicates if site falls within the cowcod conservation area |
100 | No | No | fpc_person_dim$full_name | varchar | full name in format of First and Last (Suffix) |
100 | No | No | sampling_end_time_dim$military_hour | int2 | military representation of the hour |
100 | No | No | ctd_drop_latitude_dd | numeric | high precision value for CTD drop latitude in decimal degrees |
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 | best_available_taxonomy_dim$phylum_20 | varchar | phylum name |
100 | No | No | best_available_taxonomy_dim$suborder_42 | varchar | suborder name |
100 | No | No | net_liftoff_time | time | military time representation of the time |
100 | No | No | sampling_end_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
100 | No | No | ctd_drop_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable |
100 | No | No | cpue_normalized_catch_numbers | numeric | a derived number of species caught at a site based off the number of valid hooks deployed at the site |
100 | No | No | best_available_taxonomy_dim$tribe_60 | varchar | tribe name |
100 | No | No | vessel_id | int2 | field database vessel id number |
100 | No | No | site_dim$site_longitude_dd | numeric | site longitude in decimal degrees |
100 | No | No | best_available_taxonomy_dim$subclass_32 | varchar | subclass name |
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 | ctd_drop_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable |
100 | No | No | scientist_1_person_dim$role | varchar | role taken during an operation |
100 | No | No | departure_port_dim$port_group_code | bpchar | port group code for observer program |
100 | No | No | scientist_1_person_dim$middle_initial | bpchar | middle initial of person |
100 | No | No | site_whid | int4 | warehouse identifier to the site details |
100 | No | No | captain_person_whid | int4 | warehouse identifier for the vessel captain |
100 | No | No | best_available_taxonomy_dim$order_40 | varchar | order name |
100 | No | No | sunrise_time_dim$second | int2 | number of seconds in the minute |
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 | common_name | varchar | only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null |
100 | No | No | scientific_name | varchar | scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level |
100 | No | No | sampling_start_time_dim$period | bpchar | period of time |
100 | No | No | site_ocean_weather_note | varchar | site's ocean and weather notes |
100 | No | No | best_available_taxonomy_dim$norpac_species_id | int4 | A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. |
100 | No | No | total_catch_wt_kg | numeric | a sum of the measured weights of a species caught at a site |
100 | No | No | swell_height_ft | numeric | swell height in feet |
100 | No | No | best_available_taxonomy_dim$grp_reg_depth_category | varchar | management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf |
100 | No | No | scientist_1_person_dim$last_name | varchar | last name of person |
100 | No | No | site_dim$record_type | varchar | site record or reason record is unavailable |
100 | No | No | return_port_whid | int4 | warehouse identifier for return port |
100 | No | No | swell_height_m | numeric | swell height in meters |
100 | No | No | ctd_on_bottom_temp_c | numeric | CTD on bottom temperature in degrees celcius |
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 | departure_port_dim$port_name_std | varchar | port name in standard format |
100 | No | No | ctd_drop_time_dim$period | bpchar | period of time |
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 | 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 | site_valid_hooks | int8 | a count of the number of valid hooks deployed at a site |
100 | No | No | ctd_on_bottom_measure_depth_dim$boundary_indicator | varchar | depth boundry indicator identifying ifp boundary marks |
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 | fpc_person_dim$middle_initial | bpchar | middle initial of person |
100 | No | No | project_name | varchar | project name |
100 | No | No | ctd_sounder_depth_whid | int4 | warehouse identifier for CTD sounder depth |
100 | No | No | fram_program | varchar | type of fram program |
100 | No | No | sampling_end_time_dim$hour | int2 | standard representation of the hour |
100 | No | No | site_dim$tide_station_name | varchar | name of nearest tide station |
100 | No | No | scientist_2_person_dim$nick_name | varchar | nickname of person |
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 | taxon_rank | varchar | name of the lowest taxonomic level used to define scientific name |
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 | fpc_person_dim$first_name | varchar | first name of person |
100 | No | No | site_habitat_note | varchar | site habitat notes |
100 | No | No | scientist_1_person_dim$first_name | varchar | first name of person |
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 | fpc_person_dim$nick_name | varchar | nickname of person |
100 | No | No | best_available_taxonomy_dim$superclass_28 | varchar | superclass name |
100 | No | No | ctd_drop_longitude_dim$longitude_in_degrees | numeric | numeric representation of longitude in decimal degrees |
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 | site_dim$site_longitude_whid | int4 | warehouse identifier to longitude details for site |
100 | No | No | ctd_drop_time_dim$second | int2 | number of seconds in the minute |
100 | No | No | best_available_taxonomy_dim$infraclass_34 | varchar | infraclass name |
100 | No | No | best_available_taxonomy_dim$pacfin_nom_spid | varchar | PacFIN nominal species identifier |
100 | No | No | best_available_taxonomy_dim$subphylum_22 | varchar | subphylum name |
100 | No | No | scientist_1_person_dim$record_type | varchar | person record or reason record is unavailable |
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 | best_available_taxonomy_whid | int4 | warehouse identifier to best available taxonomy |
100 | No | No | ctd_drop_time_dim$military_hour | int2 | military representation of the hour |
100 | No | No | best_available_taxonomy_dim$trawl_survey_species_id | int4 | species identifier used by the trawl survey |
100 | No | No | wave_height_ft | numeric | wave height in feet |
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 | scientist_1_person_dim$nick_name | varchar | nickname of person |
100 | No | No | best_available_taxonomy_dim$infraorder_44 | varchar | infraorder name |
100 | No | No | return_port_dim$port_name_caps | varchar | port name in all capitals format |
100 | No | No | ctd_drop_time_dim$record_type | varchar | time record or reason record is unavailable |
100 | No | No | date_whid | int8 | warehouse identifier for date |
100 | No | No | site_dim$tide_station_noaa_id | varchar | tide station id according to NOAA's Tides and Currents site |
100 | No | No | sunset_time_dim$military_hour | int2 | military representation of the hour |
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 | best_available_taxonomy_dim$species_80 | varchar | species name |
100 | No | No | tide_height_first_ft | numeric | tide height at first drop for a site measured in feet |
100 | No | No | date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | sunset_time_whid | int4 | warehouse identifier for the sunset time |
100 | No | No | sampling_end_time_dim$second | int2 | number of seconds in the minute |
100 | No | No | sunrise_time_dim$hh24miss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
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 | captain_person_dim$nick_name | varchar | nickname of person |
100 | No | No | sunset_time_dim$hh24miss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
100 | No | No | return_port_dim$port_code | bpchar | port code for observer program |
100 | No | No | site_moon_tide_dim$tide_phase | varchar | tide phase |
100 | No | No | sunrise_time_dim$period | bpchar | period of time |
100 | No | No | return_port_dim$port_group_name | varchar | port group name for observer program |
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 | scientist_2_person_dim$first_name | varchar | first name of person |
100 | No | No | best_available_taxonomy_dim$subspecies_82 | varchar | subspecies name |
100 | No | No | captain_person_dim$record_type | varchar | person record or reason record is unavailable |
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_dim$tide_station_longitude_whid | int4 | warehouse identifier to longitude details for site's nearest tide station |
100 | No | No | captain_person_dim$full_name | varchar | full name in format of First and Last (Suffix) |
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 | wave_height_m | numeric | wave height in meters |
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 | 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 | site_moon_tide_dim$record_type | varchar | moon tide record or reason record is unavailable |
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 |
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 | best_available_taxonomy_dim$structure_source |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Source of the taxonomic structure |
General Data Type | |
Unit of Measure | unspecified |
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$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 | 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 | best_available_taxonomy_dim$genus_70 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
genus name |
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_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 | species_category |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
upper-level taxonomic ranking |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$subfamily_52 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
subfamily name |
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 | scientist_1_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_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 | 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 |
warehouse identifier 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 | 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 | best_available_taxonomy_dim$itis_taxonomic_serial_no |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
ITIS taxonomic identifier |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 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 |
warehouse identifier 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 | best_available_taxonomy_dim$grp_nonstandard_taxon_99 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design |
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 | 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 | captain_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 | 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 | best_available_taxonomy_dim$superfamily_48 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
superfamily name |
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 | departure_port_dim$state_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
two letter state abbreviation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | AK, CA, OR, WA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | departure_port_dim$state_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
state name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Alaska, California, Oregon, Washington |
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 | best_available_taxonomy_dim$acoustics_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Species ID used in the acoustics program |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$worms_aphiaid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
WoRMS taxonomic identifier |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 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 |
warehouse identifier 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 | 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 | fpc_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 | 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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | captain_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 | fpc_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 | total_catch_numbers |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
a count off the number of species caught at a 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 | scientist_2_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 | 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 | return_port_dim$state_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
two letter state abbreviation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | AK, CA, OR, WA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | departure_port_dim$port_group_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port group name for 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 | fpc_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 | best_available_taxonomy_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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 | Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
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 | 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 |
warehouse identifier 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 | 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 | best_available_taxonomy_dim$family_50 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
family name |
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 | 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 | departure_port_dim$port_code |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port code for 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 | best_available_taxonomy_dim$kingdom_10 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
kingdom name |
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 | best_available_taxonomy_dim$class_30 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
class name |
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 | 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 | departure_port_dim$port_name_caps |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port name in all capitals format |
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 | pacfin_spid |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
pacfin species id - many taxa may not have one of these |
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 for 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 | return_port_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port 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 | Port, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | return_port_dim$state_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
state name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Alaska, California, Oregon, Washington |
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 | 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 | best_available_taxonomy_dim$observer_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
species identifier used by 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 | scientist_2_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 | 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$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 | scientist_2_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 | departure_port_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port 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 | Port, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
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 | scientist_2_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 | 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 | 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 | captain_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 | 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 | captain_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 | 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 | 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 | 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 | best_available_taxonomy_dim$abbreviated_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
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_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 | 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 | scientist_2_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 | 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 | return_port_dim$port_name_std |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port name in standard format |
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_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 | best_available_taxonomy_dim$superorder_38 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
superorder name |
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_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 | best_available_taxonomy_dim$hookandline_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
species identifier used by hook and line |
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 | return_port_dim$port_group_code |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port group code for observer program |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | AK, AT, BB, CA, CB, CC, EA, FB, LA, MB, MT, NB, NP, SB, SF |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | species_subcategory |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
mid-level taxonomic ranking |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | rockfish, flatfish, shark, crab, NA |
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 | 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 | 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 | 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 | 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 | 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 | 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 | fpc_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 | 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 | 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 | 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 | best_available_taxonomy_dim$phylum_20 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
phylum name |
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 | best_available_taxonomy_dim$suborder_42 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
suborder name |
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 | 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 | 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 | 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 | cpue_normalized_catch_numbers |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
a derived number of species caught at a site based off the number of valid hooks deployed at the 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 | best_available_taxonomy_dim$tribe_60 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
tribe name |
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 | 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 | 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 | best_available_taxonomy_dim$subclass_32 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
subclass name |
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$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 | 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 | scientist_1_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 | departure_port_dim$port_group_code |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port group code for observer program |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | AK, AT, BB, CA, CB, CC, EA, FB, LA, MB, MT, NB, NP, SB, SF |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | scientist_1_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 | 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 to the site 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 | 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 |
warehouse identifier 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 | best_available_taxonomy_dim$order_40 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
order name |
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$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 | 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 | common_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null |
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 | scientific_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 120 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level |
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$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 | 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 | best_available_taxonomy_dim$norpac_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | total_catch_wt_kg |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
a sum of the measured weights of a species caught at a site |
General Data Type | |
Unit of Measure | kg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
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 | best_available_taxonomy_dim$grp_reg_depth_category |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf |
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 | scientist_1_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 | 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 | 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 |
warehouse identifier 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 | 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_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 | 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 | departure_port_dim$port_name_std |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port name in standard format |
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_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 | 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 | 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 | site_valid_hooks |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
a count of the number of valid hooks deployed at a 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 | 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 | 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 | fpc_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 | project_name |
---|---|
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 | |
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 | fram_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 | 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 | 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 | scientist_2_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 | 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 | taxon_rank |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of the lowest taxonomic level used to define scientific name |
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 | fpc_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 | 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 | scientist_1_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 | 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 | fpc_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 | best_available_taxonomy_dim$superclass_28 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
superclass name |
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_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 | 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 | 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 | best_available_taxonomy_dim$infraclass_34 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
infraclass name |
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 | best_available_taxonomy_dim$pacfin_nom_spid |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
PacFIN nominal species identifier |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$subphylum_22 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
subphylum name |
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 | scientist_1_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 | 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 | best_available_taxonomy_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 best available taxonomy |
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_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 | best_available_taxonomy_dim$trawl_survey_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
species identifier used by the trawl 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 | 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 | 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 | scientist_1_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 | best_available_taxonomy_dim$infraorder_44 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
infraorder name |
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 | return_port_dim$port_name_caps |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port name in all capitals format |
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_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 | int8 |
Max Length | 64 |
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 | 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 | 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 | 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 | best_available_taxonomy_dim$species_80 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
species name |
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 | 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 | 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 | 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 | 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 | 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 | captain_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 | 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 | return_port_dim$port_code |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port code for 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 | 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 | 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 | return_port_dim$port_group_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port group name for 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 | 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 | scientist_2_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 | best_available_taxonomy_dim$subspecies_82 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
subspecies name |
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 | captain_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 | 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_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 | captain_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 | 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 | 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 | 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 | 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 | 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 | 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 | |
---|---|
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
* » 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 | 36440 |
---|---|
Metadata Record Created By | Jeffrey W Cowen |
Metadata Record Created | 2017-01-25 13:18+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 |
---|