individual_fact
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36438 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
actual_station_design_dim$transect_station_longitude_dd | numeric | high precision value of transect station longitude measured in decimal degrees | |
|
100
|
standard_survey_dim$standard_survey_weight_indicator | varchar | identifies if the individual is part of the Standard Weight Survey | |
|
100
|
sampling_start_time_dim$minute | int2 | number of minutes in the hour | |
|
100
|
best_available_taxonomy_dim$phylum_20 | varchar | phylum name | |
|
100
|
performance | varchar | performance of the operation | |
|
100
|
actual_station_design_dim$upper_right_latitude_whid | int4 | upper right latitude warehouse identifier for a design type of grid | |
|
100
|
date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
|
100
|
actual_station_design_dim$lower_left_longitude_dd | numeric | high precision value of lower left longitude of design type grid measured in decimal degrees | |
|
100
|
best_available_taxonomy_dim$structure_source | varchar | Source of the taxonomic structure | |
|
100
|
best_available_taxonomy_dim$family_50 | varchar | family name | |
|
100
|
actual_station_design_dim$upper_right_longitude_dd | numeric | high precision value of upper right longitude of design type grid measured in decimal degrees | |
|
100
|
actual_station_design_dim$upper_right_longitude_whid | int4 | upper right longitude warehouse identifier for a design type of grid | |
|
100
|
actual_station_design_dim$lower_left_latitude_whid | int4 | lower left latitude warehouse identifier for a design type of grid | |
|
100
|
best_available_taxonomy_dim$record_type | varchar | record or reason record is unavailable | |
|
100
|
width_observation_detail_dim$method_description | varchar | description of how the observation was taken | |
|
100
|
station_ur_lon_dd | numeric | high precision value of upper right longitude of design type grid measured in decimal degrees | |
|
100
|
most_recent_taxonomy_update_date_dim$day_of_month | int2 | numeric representation of the day in month | |
|
100
|
most_recent_age_update_date_dim$yyyymmdd | bpchar | text representation of year month day | |
|
100
|
individual_tracking_id | int8 | Individual tracking id | |
|
100
|
ovary_id | numeric | Ovary sample number or barcode | |
|
100
|
target_station_design_dim$stn_invalid_for_trawl_date_whid | int8 | station design invalidation date warehouse identifier | |
|
100
|
standard_survey_whid | int4 | Warehouse identifier for standard survey | |
|
100
|
operation_dim$scientist_1_person_whid | int4 | person reference for the first scientist | |
|
100
|
most_recent_maturity_update_date_whid | int8 | Warehouse identifier for most recent maturity update date | |
|
100
|
net_liftoff_time | time | military time representation of the time | |
|
100
|
actual_station_design_dim$variance_depth_m2 | numeric | high precision value of variance depth mesured in squared meters | |
|
100
|
target_station_design_dim$variance_depth_m2 | numeric | high precision value of variance depth mesured in squared meters | |
|
100
|
target_station_design_dim$min_depth_whid | int4 | minimum depth warehouse identifier | |
|
100
|
target_station_design_dim$transect_station_longitude_dd | numeric | high precision value of transect station longitude measured in decimal degrees | |
|
100
|
actual_station_design_dim$lower_left_longitude_whid | int4 | lower left longitude warehouse identifier for a design type of grid | |
|
100
|
field_identified_taxonomy_dim$itis_taxonomic_serial_no | int4 | ITIS taxonomic identifier | |
|
100
|
operation_dim$departure_port_whid | int4 | port reference for the departure port | |
|
100
|
haul_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable | |
|
100
|
sex_whid | int2 | Warehouse identifier to sex details | |
|
100
|
target_station_design_whid | int4 | warehouse identifier for target station design | |
|
100
|
target_station_design_dim$max_latitude_whid | int4 | maximum latitude warehouse identifier for a design type of transect | |
|
100
|
actual_station_design_dim$upper_left_longitude_whid | int4 | upper left longitude warehouse identifier for a design type of grid | |
|
100
|
pass | int4 | pass number of the survey | |
|
100
|
sampling_end_time_dim$period | bpchar | period of time | |
|
100
|
operation_dim$scientist_3_person_whid | int4 | person reference for the third scientist | |
|
100
|
field_identified_taxonomy_dim$structure_source | varchar | Source of the taxonomic structure | |
|
100
|
width_cm | numeric | Individual width measured in centimeters | |
|
100
|
most_recent_taxon_update | timestamp | full date value | |
|
100
|
best_available_taxonomy_dim$abbreviated_name | varchar | specialized common name, generally for a well-known species of fish such as ATF, LST, SST | |
|
100
|
operation_dim$operation_start_date_whid | int8 | start date reference for the operation | |
|
100
|
best_available_taxonomy_dim$observer_species_id | int4 | species identifier used by the observer program | |
|
100
|
project | varchar | project name | |
|
100
|
midtow_lat_named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location | |
|
100
|
field_identified_taxonomy_dim$species_category | varchar | upper-level taxonomic ranking | |
|
100
|
centroid_id | numeric | eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons. | |
|
100
|
sampling_start_time_dim$record_type | varchar | time record or reason record is unavailable | |
|
100
|
operation_dim$field_operation_seg_id | int8 | operation segment id reference to the field operational segment table | |
|
100
|
sampling_end_time_whid | int4 | warehouse identifier for the sampling end time | |
|
100
|
standard_survey_dim$record_type | varchar | standard survey record or reason record is unavailable | |
|
100
|
depth_m | numeric | depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) | |
|
100
|
target_station_design_dim$upper_right_longitude_whid | int4 | upper right longitude warehouse identifier for a design type of grid | |
|
100
|
target_station_design_dim$mean_depth_whid | int4 | mean depth warehouse identifier | |
|
100
|
stomach_id | numeric | Stomach sample number or barcode | |
|
100
|
target_station_design_dim$station_design_type | varchar | type of design underlying the survey station set: Transect or Grid to date | |
|
100
|
trawl_id | int8 | identifier for a sampling operation | |
|
100
|
station_ur_lat_dd | numeric | high precision value of upper right latitude of design type grid measured in decimal degrees | |
|
100
|
width_type | varchar | describes how the measurement was calculated | |
|
100
|
best_available_taxonomy_whid | int4 | warehouse identifier to best available taxonomy | |
|
100
|
statistical_partition_dim$record_type | varchar | statistical partition record or reason record is unavailable | |
|
100
|
species_category | varchar | upper-level taxonomic ranking | |
|
100
|
field_identified_taxonomy_dim$hookandline_species_id | int4 | species identifier used by hook and line | |
|
100
|
station_ll_lat_dd | numeric | high precision value of lower left latitude of design type grid measured in decimal degrees | |
|
100
|
best_available_taxonomy_dim$subphylum_22 | varchar | subphylum name | |
|
100
|
field_identified_taxonomy_dim$record_type | varchar | record or reason record is unavailable | |
|
100
|
field_identified_taxonomy_dim$scientific_name_taxonomic_level | varchar | name of the lowest taxonomic level used to define scientific name | |
|
100
|
longitude_dd | numeric | numeric representation of longitude in decimal degrees | |
|
100
|
haul_longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only | |
|
100
|
program | varchar | type of fram program | |
|
100
|
width_observation_detail_dim$observation_type | varchar | the type of observation | |
|
100
|
field_identified_taxonomy_dim$superorder_38 | varchar | superorder name | |
|
100
|
operation_dim$operation_end_time_whid | int8 | end time reference for the operation | |
|
100
|
target_station_design_dim$min_latitude_dd | numeric | high precision value of minimum latitude measured in decimal degrees | |
|
100
|
most_recent_maturity_update_date_dim$yyyymmdd | bpchar | text representation of year month day | |
|
100
|
most_recent_maturity_update_date_dim$month_name | varchar | text representation of month | |
|
100
|
operation_dim$operation_start_time_whid | int8 | start time reference for the operation | |
|
100
|
field_identified_taxonomy_dim$infraorder_44 | varchar | infraorder name | |
|
100
|
standard_survey_dim$standard_survey_length_or_width_indicator | varchar | identifies if the individual is part of the Standard Length Survey | |
|
100
|
length_timestamp | timestamp | Timestamp at the point the length is taken on an individual | |
|
100
|
field_identified_taxonomy_dim$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
|
best_available_taxonomy_dim$pacfin_nom_spid | varchar | PacFIN nominal species identifier | |
|
100
|
actual_station_design_dim$station_design_type | varchar | type of design underlying the survey station set: Transect or Grid to date | |
|
100
|
field_identified_taxonomy_dim$worms_aphiaid | int4 | WoRMS taxonomic identifier | |
|
100
|
max_depth_m | numeric | high precision value of maximum depth measured in meters | |
|
100
|
field_identified_taxonomy_whid | int4 | warehouse identifier to field identified taxonomy | |
|
100
|
most_recent_age_update_date_dim$month_of_year | int2 | numeric representation of month of year | |
|
100
|
length_type | varchar | describes how the measurement was calculated | |
|
100
|
station_lr_lon_dd | numeric | high precision value of lower right longitude of design type grid measured in decimal degrees | |
|
100
|
haul_longitude_whid | int4 | warehouse identifier for haul longitude | |
|
100
|
date_dim$year | int4 | numeric representation of year | |
|
100
|
actual_station_design_dim$centroid_id | numeric | eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons. | |
|
100
|
actual_station_design_whid | int4 | warehouse identifier for station design | |
|
100
|
operation_dim$coast_guard_number | varchar | Coast Guard documentation number of vessel | |
|
100
|
field_identified_taxonomy_dim$kingdom_10 | varchar | kingdom name | |
|
100
|
most_recent_taxonomy_update_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
|
100
|
most_recent_age_update_date_dim$month_name | varchar | text representation of month | |
|
100
|
taxon_source | varchar | name of primary source used to get the measurement | |
|
100
|
field_identified_taxonomy_dim$acoustics_species_id | int4 | Species ID used in the acoustics program | |
|
100
|
sampling_end_time_dim$minute | int2 | number of minutes in the hour | |
|
100
|
date_yyyymmdd | bpchar | text representation of year month day | |
|
100
|
haul_latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" | |
|
100
|
haul_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction | |
|
100
|
year | int2 | operation year | |
|
100
|
most_recent_age_update_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
|
100
|
field_identified_taxonomy_dim$subfamily_52 | varchar | subfamily name | |
|
100
|
sampling_start_time_dim$hour | int2 | standard representation of the hour | |
|
100
|
most_recent_maturity_update_date_dim$month_of_year | int2 | numeric representation of month of year | |
|
100
|
lab_maturity_detail_dim$functionally_mature_certain_indicator | varchar | identifies the certainty of the functionally mature evaluation | |
|
100
|
best_available_taxonomy_dim$subfamily_52 | varchar | subfamily name | |
|
100
|
otosag_id | int4 | Otolith barcode or sample number | |
|
100
|
haul_latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only | |
|
100
|
date_whid | int8 | warehouse identifier for date | |
|
100
|
target_station_design_dim$min_latitude_whid | int4 | minimum latitude warehouse identifier for a design type of transect | |
|
100
|
field_identified_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
|
operation_dim$departure_date_whid | int8 | date reference that vessel departed for the defined leg or trip | |
|
100
|
length_observation_detail_dim$observation_type | varchar | the type of observation | |
|
100
|
operation_dim$fpc_person_whid | int4 | person reference for the FPC | |
|
100
|
actual_station_design_dim$transect_latitude_whid | int4 | latitude warehouse identifier for a design type of transect | |
|
100
|
length_cm | numeric | Individual length measured in centimeters | |
|
100
|
target_station_design_dim$active_polygon_dd | polygon | collection of vertices of the usuable area inside a station grid measured in decimal degrees | |
|
100
|
operation_dim$operation_end_date_whid | int8 | end date reference for the operation | |
|
100
|
field_identified_taxonomy_dim$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
|
actual_station_design_dim$max_depth_whid | int4 | maximum depth warehouse identifier | |
|
100
|
actual_station_design_dim$min_depth_m | numeric | high precision value of minimum depth measured in meters | |
|
100
|
operation_dim$return_date_whid | int8 | date reference that vessel returned for the defined leg or trip | |
|
100
|
haul_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction | |
|
100
|
target_station_design_dim$transect_latitude_whid | int4 | latitude warehouse identifier for a design type of transect | |
|
100
|
date_dim$full_date | timestamp | full date value | |
|
100
|
target_station_design_dim$upper_left_latitude_whid | int4 | upper left latitude warehouse identifier for a design type of grid | |
|
100
|
actual_station_design_dim$mean_depth_whid | int4 | mean depth warehouse identifier | |
|
100
|
min_depth_m | numeric | high precision value of minimum depth measured in meters | |
|
100
|
year_stn_invalid | int2 | Survey year the station became invalid for trawl | |
|
100
|
length_observation_detail_dim$record_type | varchar | observation detail record type or reason record is unavailable | |
|
100
|
target_station_design_dim$upper_left_longitude_whid | int4 | upper left longitude warehouse identifier for a design type of grid | |
|
100
|
station_code | varchar | unique identifier for a station definition | |
|
100
|
station_ul_lat_dd | numeric | high precision value of upper left latitude of design type grid measured in decimal degrees | |
|
100
|
station_ll_lon_dd | numeric | high precision value of lower left longitude of design type grid measured in decimal degrees | |
|
100
|
vessel | varchar | name of the vessel used for the operation | |
|
100
|
most_recent_taxonomy_update_date_dim$month_of_year | int2 | numeric representation of month of year | |
|
100
|
actual_station_design_dim$lower_left_latitude_dd | numeric | high precision value of lower left latitude of design type grid measured in decimal degrees | |
|
100
|
best_available_taxonomy_dim$superfamily_48 | varchar | superfamily name | |
|
100
|
depth_ftm | numeric | depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries | |
|
100
|
actual_station_design_dim$transect_latitude_dd | numeric | high precision value of transect latitude measured in decimal degrees | |
|
100
|
weight_kg | numeric | Individual weight measured in kilograms | |
|
100
|
field_identified_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
|
width_observation_detail_dim$source_primary | varchar | name of primary source used to get the measurement | |
|
100
|
target_station_design_dim$transect_station_longitude_whid | int4 | longitude on transect warehouse identifier for a design type of transect | |
|
100
|
actual_station_design_dim$station_grid_dd | polygon | collection of vertices of grid points of a grid design measured in decimal degrees | |
|
100
|
operation_dim$return_port_whid | int4 | port reference for return port | |
|
100
|
actual_station_design_dim$min_latitude_dd | numeric | high precision value of minimum latitude measured in decimal degrees | |
|
100
|
tow_end_timestamp | timestamp | operation end date timestamp | |
|
100
|
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
|
field_identified_taxonomy_dim$subphylum_22 | varchar | subphylum name | |
|
100
|
operation_dim$captain_person_whid | int4 | person reference for the vessel captain | |
|
100
|
target_station_design_dim$lower_left_latitude_whid | int4 | lower left latitude warehouse identifier for a design type of grid | |
|
100
|
length_observation_detail_dim$method_description | varchar | description of how the observation was taken | |
|
100
|
best_available_taxonomy_dim$suborder_42 | varchar | suborder name | |
|
100
|
most_recent_age_update_date_whid | int8 | Warehouse identifier for most recent age update date | |
|
100
|
field_identified_taxonomy_dim$phylum_20 | varchar | phylum name | |
|
100
|
best_available_taxonomy_dim$superclass_28 | varchar | superclass name | |
|
100
|
statistical_partition_whid | int4 | warehouse identifier for statistical partition | |
|
100
|
target_station_design_dim$upper_right_latitude_whid | int4 | upper right latitude warehouse identifier for a design type of grid | |
|
100
|
length_observation_detail_dim$measurement_procurement | varchar | how the measurement was achieved | |
|
100
|
length_observation_detail_whid | int4 | Warehouse identifier to taxonomy observation detail | |
|
100
|
field_identified_taxonomy_dim$pacfin_spid | varchar | pacfin species id - many taxa may not have one of these | |
|
100
|
operation_dim$ifq_account_number | varchar | unique number assigned to user accounts in the Vessel Accounting Database | |
|
100
|
best_available_taxonomy_dim$subspecies_82 | varchar | subspecies name | |
|
100
|
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
|
width_observation_detail_dim$measurement_procurement | varchar | how the measurement was achieved | |
|
100
|
target_station_design_dim$area_hectares | numeric | station area measured in hectares | |
|
100
|
age_years | numeric | Individual age measured in years | |
|
100
|
sampling_start_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 | |
|
100
|
most_recent_taxonomy_update_date_dim$month_name | varchar | text representation of month | |
|
100
|
best_available_taxonomy_dim$hookandline_species_id | int4 | species identifier used by hook and line | |
|
100
|
best_available_taxonomy_observation_detail_dim$observation_type | varchar | the type of observation | |
|
100
|
field_identified_taxonomy_dim$genus_70 | varchar | genus name | |
|
100
|
most_recent_taxonomy_update_date_dim$year | int4 | numeric representation of year | |
|
100
|
actual_station_design_dim$active_polygon_dd | polygon | collection of vertices of the usuable area inside a station grid measured in decimal degrees | |
|
100
|
field_identified_taxonomy_dim$abbreviated_name | varchar | specialized common name, generally for a well-known species of fish such as ATF, LST, SST | |
|
100
|
operation_dim$scientist_4_person_whid | int4 | person reference for the fourth scientist | |
|
100
|
actual_station_design_dim$lower_right_longitude_whid | int4 | lower right longitude warehouse identifier for a design type of grid | |
|
100
|
target_station_design_dim$transect_latitude_dd | numeric | high precision value of transect latitude measured in decimal degrees | |
|
100
|
mean_seafloor_dep_boundary | varchar | depth boundry indicator identifying ifp boundary marks | |
|
100
|
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
|
sampling_start_time_dim$second | int2 | number of seconds in the minute | |
|
100
|
actual_station_design_dim$station_invalid_survey_year | int2 | Survey year the station became invalid for trawl | |
|
100
|
sampling_start_time_whid | int4 | warehouse identifier for the sampling start time | |
|
100
|
target_station_design_dim$lower_right_longitude_whid | int4 | lower right longitude warehouse identifier for a design type of grid | |
|
100
|
haul_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable | |
|
100
|
tissue_id | numeric | Tissue sample number or barcode | |
|
100
|
actual_station_design_dim$transect_station_longitude_whid | int4 | longitude on transect warehouse identifier for a design type of transect | |
|
100
|
best_available_taxonomy_dim$tribe_60 | varchar | tribe name | |
|
100
|
field_note | varchar | Note made in the field about an individual | |
|
67
|
sex_dim$sex | varchar | ||
|
100
|
actual_station_design_dim$station_code | varchar | unique identifier for a station definition | |
|
100
|
latitude_dd | numeric | numeric representation of latitude in degrees | |
|
100
|
actual_station_design_dim$station_design_name | varchar | name of the design for a collection of stations | |
|
100
|
lab_maturity_detail_dim$biologically_mature_certain_indicator | varchar | identifies the certainty of the biological maturity | |
|
100
|
actual_station_design_dim$lower_right_latitude_whid | int4 | lower right latitude warehouse identifier for a design type of grid | |
|
100
|
haul_longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only | |
|
100
|
best_available_taxonomy_observation_detail_dim$means_of_calculation | varchar | describes how the measurement was calculated | |
|
100
|
most_recent_age_update | timestamp | full date value | |
|
100
|
actual_station_design_dim$area_hectares | numeric | station area measured in hectares | |
|
100
|
taxon_rank | varchar | name of the lowest taxonomic level used to define scientific name | |
|
100
|
best_available_taxonomy_observation_detail_dim$record_type | varchar | observation detail record type or reason record is unavailable | |
|
100
|
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
|
field_identified_taxonomy_dim$observer_species_id | int4 | species identifier used by the observer program | |
|
100
|
operation_dim_whid | int8 | warehouse identifier for operation | |
|
100
|
operation_dim$scientist_2_person_whid | int4 | person reference for the second scientist | |
|
100
|
most_recent_taxonomy_update_date_dim$yyyymmdd | bpchar | text representation of year month day | |
|
100
|
best_available_taxonomy_dim$genus_70 | varchar | genus name | |
|
100
|
net_touchdown_time | time | military time representation of the time | |
|
100
|
best_available_taxonomy_dim$itis_taxonomic_serial_no | int4 | ITIS taxonomic identifier | |
|
100
|
operation_dim$vessel_id | int2 | field database vessel id number | |
|
100
|
left_pectoral_fin_id | int4 | Left pectoral fin sample number or barcode | |
|
100
|
best_available_taxonomy_dim$worms_aphiaid | int4 | WoRMS taxonomic identifier | |
|
100
|
lab_maturity_detail_dim$biologically_mature_indicator | varchar | identifies biological maturity of the individual | |
|
100
|
most_recent_taxonomy_update_date_whid | int8 | Warehouse identifier for most recent taxonomy update date | |
|
100
|
haul_latitude_whid | int4 | warehouse identifier for haul latitude | |
|
100
|
operation_dim$state_registration_number | varchar | state registration number for the vessel | |
|
100
|
actual_station_design_dim$upper_right_latitude_dd | numeric | high precision value of upper right latitude of design type grid measured in decimal degrees | |
|
100
|
date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
|
100
|
actual_station_design_dim$upper_left_longitude_dd | numeric | high precision value of upper left longitude of design type grid measured in decimal degrees | |
|
100
|
best_available_taxonomy_observation_detail_dim$method_description | varchar | description of how the observation was taken | |
|
100
|
width_observation_detail_whid | int4 | Warehouse identifier to taxonomy observation detail | |
|
100
|
haul_latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only | |
|
100
|
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
|
actual_station_design_dim$mean_depth_m | numeric | high precision value of mean depth measured in meters | |
|
100
|
field_identified_taxonomy_dim$pacfin_nom_spid | varchar | PacFIN nominal species identifier | |
|
100
|
field_identified_taxonomy_dim$superclass_28 | varchar | superclass name | |
|
100
|
actual_station_design_dim$max_depth_m | numeric | high precision value of maximum depth measured in meters | |
|
100
|
field_identified_taxonomy_dim$superfamily_48 | varchar | superfamily name | |
|
100
|
most_recent_age_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
|
100
|
tow_start_timestamp | timestamp | operation start date timestamp | |
|
100
|
actual_station_design_dim$reason_station_invalid | varchar | reason station was invalidated, multiple reasons are comma separated | |
|
100
|
standard_survey_dim$standard_survey_maturity_indicator | varchar | identifies if the individual is part of the Standard Maturity Survey | |
|
100
|
station_lr_lat_dd | numeric | high precision value of lower right latitude of design type grid measured in decimal degrees | |
|
100
|
best_available_taxonomy_dim$infraclass_34 | varchar | infraclass name | |
|
100
|
length_observation_detail_dim$source_primary | varchar | name of primary source used to get the measurement | |
|
100
|
target_station_design_dim$max_latitude_dd | numeric | high precision value of maximum latitude measured in decimal degrees | |
|
100
|
operation_dim$trip_id | int4 | trip identifier number | |
|
100
|
sampling_start_time_dim$period | bpchar | period of time | |
|
100
|
operation_dim$record_type | varchar | operation record or reason record is unavailable | |
|
100
|
sampling_end_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 | |
|
100
|
date_dim$month_name | varchar | text representation of month | |
|
100
|
target_station_design_dim$lower_left_longitude_whid | int4 | lower left longitude warehouse identifier for a design type of grid | |
|
100
|
target_station_design_dim$station_grid_dd | polygon | collection of vertices of grid points of a grid design measured in decimal degrees | |
|
100
|
most_recent_age_update_date_dim$day_of_month | int2 | numeric representation of the day in month | |
|
100
|
tow | int2 | operation number of the survey | |
|
100
|
actual_station_design_dim$stn_invalid_for_trawl_date_whid | int8 | station design invalidation date warehouse identifier | |
|
100
|
standard_survey_dim$standard_survey_age_indicator | varchar | identifies if the individual is part of the Standard Age Survey | |
|
100
|
width_observation_detail_dim$record_type | varchar | observation detail record type or reason record is unavailable | |
|
100
|
field_identified_taxonomy_dim$infraclass_34 | varchar | infraclass name | |
|
100
|
most_recent_maturity_update_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
|
100
|
field_identified_taxonomy_dim$subspecies_82 | varchar | subspecies name | |
|
100
|
best_available_taxonomy_dim$acoustics_species_id | int4 | Species ID used in the acoustics program | |
|
100
|
actual_station_design_dim$max_latitude_whid | int4 | maximum latitude warehouse identifier for a design type of transect | |
|
100
|
most_recent_age_update_date_dim$year | int4 | numeric representation of year | |
|
100
|
species_subcategory | varchar | mid-level taxonomic ranking | |
|
100
|
date_dim$day_of_month | int2 | numeric representation of the day in month | |
|
100
|
actual_station_design_dim$upper_left_latitude_dd | numeric | high precision value of upper left latitude of design type grid measured in decimal degrees | |
|
100
|
field_identified_taxonomy_dim$tribe_60 | varchar | tribe name | |
|
100
|
leg | int2 | leg number of the survey | |
|
100
|
field_identified_taxonomy_dim$subclass_32 | varchar | subclass name | |
|
100
|
best_available_taxonomy_observation_detail_whid | int4 | warehouse identifier to best available taxonomy observation detail | |
|
100
|
seafloor_depth_dim$record_type | varchar | depth record or reason record is unavailable | |
|
100
|
station_ul_lon_dd | numeric | high precision value of upper left longitude of design type grid measured in decimal degrees | |
|
100
|
most_recent_taxonomy_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
|
100
|
field_identified_taxonomy_dim$class_30 | varchar | class name | |
|
100
|
sampling_end_time_dim$hour | int2 | standard representation of the hour | |
|
100
|
actual_station_design_dim$upper_left_latitude_whid | int4 | upper left latitude warehouse identifier for a design type of grid | |
|
100
|
sampling_start_time_dim$military_hour | int2 | military representation of the hour | |
|
100
|
haul_longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" | |
|
100
|
reason_stn_invalid | varchar | reason station was invalidated, multiple reasons are comma separated | |
|
100
|
sampling_end_time_dim$second | int2 | number of seconds in the minute | |
|
100
|
best_available_taxonomy_dim$superorder_38 | varchar | superorder name | |
|
100
|
best_available_taxonomy_dim$kingdom_10 | varchar | kingdom name | |
|
100
|
field_identified_taxonomy_dim$trawl_survey_species_id | int4 | species identifier used by the trawl survey | |
|
100
|
actual_station_design_dim$lower_right_latitude_dd | numeric | high precision value of lower right latitude of design type grid measured in decimal degrees | |
|
100
|
partition | varchar | Refines the partition type | |
|
100
|
field_identified_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
|
field_identified_taxonomy_dim$suborder_42 | varchar | suborder name | |
|
100
|
field_identified_taxonomy_dim$family_50 | varchar | family name | |
|
100
|
sampling_end_time_dim$record_type | varchar | time record or reason record is unavailable | |
|
100
|
actual_station_design_dim$lower_right_longitude_dd | numeric | high precision value of lower right longitude of design type grid measured in decimal degrees | |
|
100
|
best_available_taxonomy_dim$class_30 | varchar | class name | |
|
100
|
seafloor_depth_whid | int4 | warehouse identifier for seafloor depth | |
|
100
|
target_station_design_dim$mean_depth_m | numeric | high precision value of mean depth measured in meters | |
|
100
|
field_identified_taxonomy_dim$species_sub_category | varchar | mid-level taxonomic ranking | |
|
100
|
operation_dim$observer_program | varchar | description of the observer program | |
|
100
|
lab_maturity_detail_dim$functionally_mature_indicator | varchar | identifies the functional maturity of the individual | |
|
100
|
pacfin_spid | varchar | pacfin species id - many taxa may not have one of these | |
|
100
|
best_available_taxonomy_dim$infraorder_44 | varchar | infraorder name | |
|
100
|
most_recent_maturity_update_date_dim$day_of_month | int2 | numeric representation of the day in month | |
|
100
|
statistical_partition_dim$statistical_partition_type | varchar | Defines the partition type | |
|
100
|
target_station_design_dim$record_type | varchar | station design record or reason record is unavailable | |
|
100
|
best_available_taxonomy_dim$order_40 | varchar | order name | |
|
100
|
actual_station_design_dim$min_depth_whid | int4 | minimum depth warehouse identifier | |
|
100
|
actual_station_design_dim$max_latitude_dd | numeric | high precision value of maximum latitude measured in decimal degrees | |
|
100
|
field_identified_taxonomy_dim$order_40 | varchar | order name | |
|
100
|
field_identified_taxonomy_dim$species_80 | varchar | species name | |
|
100
|
sampling_end_time_dim$military_hour | int2 | military representation of the hour | |
|
100
|
lab_maturity_detail_dim$record_type | varchar | lab maturity detail record or reason record is unavailable | |
|
100
|
best_available_taxonomy_dim$species_80 | varchar | species name | |
|
100
|
best_available_taxonomy_observation_detail_dim$measurement_procurement | varchar | how the measurement was achieved | |
|
100
|
target_station_design_dim$lower_right_latitude_whid | int4 | lower right latitude warehouse identifier for a design type of grid | |
|
100
|
operation_dim$operation_type | varchar | type of operation | |
|
100
|
haul_latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only | |
|
100
|
actual_station_design_dim$record_type | varchar | station design record or reason record is unavailable | |
|
100
|
target_station_design_dim$max_depth_whid | int4 | maximum depth warehouse identifier | |
|
100
|
best_available_taxonomy_dim$subclass_32 | varchar | subclass name | |
|
100
|
haul_longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only | |
|
100
|
sex_dim$record_type | varchar | latitude record type or reason record is unavailable | |
|
100
|
actual_station_design_dim$min_latitude_whid | int4 | minimum latitude warehouse identifier for a design type of transect | |
|
100
|
date_dim$month_of_year | int2 | numeric representation of month of year | |
|
100
|
most_recent_maturity_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
|
100
|
operation_dim$limited_entry_permit_number | bpchar | federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California | |
|
67
|
sex | bpchar | ||
|
100
|
target_station_design_dim$station_design_name | varchar | name of the design for a collection of stations | |
|
100
|
best_available_taxonomy_dim$trawl_survey_species_id | int4 | species identifier used by the trawl survey | |
|
100
|
lab_maturity_detail_whid | int2 | Warehouse identifier for lab maturity details | |
|
100
|
most_recent_maturity_update_date_dim$full_date | timestamp | full date value | |
|
100
|
most_recent_maturity_update_date_dim$year | int4 | numeric representation of year |
Attribute Details
actual_station_design_dim$transect_station_longitude_dd
CC ID: 376840
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of transect station longitude measured in decimal degrees |
| Unit of Measure: | dd |
standard_survey_dim$standard_survey_weight_indicator
CC ID: 376841
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
identifies if the individual is part of the Standard Weight Survey |
| Allowed Values: | Standard Survey Weight, Not Standard Survey Weight, NA |
sampling_start_time_dim$minute
CC ID: 376842
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of minutes in the hour |
| Unit of Measure: | min |
| Allowed Values: | 0-60 |
best_available_taxonomy_dim$phylum_20
CC ID: 376843
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
phylum name |
performance
CC ID: 376844
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
performance of the operation |
| Allowed Values: | Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] |
actual_station_design_dim$upper_right_latitude_whid
CC ID: 376845
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
upper right latitude warehouse identifier for a design type of grid |
date_dim$record_type
CC ID: 376846
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
actual_station_design_dim$lower_left_longitude_dd
CC ID: 376847
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of lower left longitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
best_available_taxonomy_dim$structure_source
CC ID: 376848
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Source of the taxonomic structure |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
best_available_taxonomy_dim$family_50
CC ID: 376849
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
family name |
actual_station_design_dim$upper_right_longitude_dd
CC ID: 376850
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of upper right longitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
actual_station_design_dim$upper_right_longitude_whid
CC ID: 376851
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
upper right longitude warehouse identifier for a design type of grid |
actual_station_design_dim$lower_left_latitude_whid
CC ID: 376852
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
lower left latitude warehouse identifier for a design type of grid |
best_available_taxonomy_dim$record_type
CC ID: 376853
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
record or reason record is unavailable |
| Allowed Values: | Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
width_observation_detail_dim$method_description
CC ID: 376854
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 500 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
description of how the observation was taken |
station_ur_lon_dd
CC ID: 376855
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of upper right longitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
most_recent_taxonomy_update_date_dim$day_of_month
CC ID: 376856
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
most_recent_age_update_date_dim$yyyymmdd
CC ID: 376857
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
individual_tracking_id
CC ID: 376858
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Individual tracking id |
ovary_id
CC ID: 376859
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Ovary sample number or barcode |
| Unit of Measure: | unspecifid |
| Allowed Values: | Any |
target_station_design_dim$stn_invalid_for_trawl_date_whid
CC ID: 376860
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
station design invalidation date warehouse identifier |
standard_survey_whid
CC ID: 376861
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for standard survey |
operation_dim$scientist_1_person_whid
CC ID: 376862
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the first scientist |
most_recent_maturity_update_date_whid
CC ID: 376863
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for most recent maturity update date |
net_liftoff_time
CC ID: 376864
| Data Storage Type: | time |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
military time representation of the time |
actual_station_design_dim$variance_depth_m2
CC ID: 376865
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
high precision value of variance depth mesured in squared meters |
| Unit of Measure: | m2 |
target_station_design_dim$variance_depth_m2
CC ID: 376866
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
high precision value of variance depth mesured in squared meters |
| Unit of Measure: | m2 |
target_station_design_dim$min_depth_whid
CC ID: 376867
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
minimum depth warehouse identifier |
target_station_design_dim$transect_station_longitude_dd
CC ID: 376868
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of transect station longitude measured in decimal degrees |
| Unit of Measure: | dd |
actual_station_design_dim$lower_left_longitude_whid
CC ID: 376869
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
lower left longitude warehouse identifier for a design type of grid |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
field_identified_taxonomy_dim$itis_taxonomic_serial_no
CC ID: 376870
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
ITIS taxonomic identifier |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
operation_dim$departure_port_whid
CC ID: 376871
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
port reference for the departure port |
haul_latitude_dim$record_type
CC ID: 376872
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
latitude record type or reason record is unavailable |
| Unit of Measure: | NA |
| Allowed Values: | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
sex_whid
CC ID: 376873
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to sex details |
target_station_design_whid
CC ID: 376874
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for target station design |
target_station_design_dim$max_latitude_whid
CC ID: 376875
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
maximum latitude warehouse identifier for a design type of transect |
actual_station_design_dim$upper_left_longitude_whid
CC ID: 376876
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
upper left longitude warehouse identifier for a design type of grid |
pass
CC ID: 376877
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
pass number of the survey |
| Allowed Values: | 1,2,3,4 |
sampling_end_time_dim$period
CC ID: 376878
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
period of time |
| Allowed Values: | AM, PM |
operation_dim$scientist_3_person_whid
CC ID: 376879
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the third scientist |
field_identified_taxonomy_dim$structure_source
CC ID: 376880
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Source of the taxonomic structure |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
width_cm
CC ID: 376881
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
Individual width measured in centimeters |
| Unit of Measure: | cm |
most_recent_taxon_update
CC ID: 376882
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
best_available_taxonomy_dim$abbreviated_name
CC ID: 376883
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
operation_dim$operation_start_date_whid
CC ID: 376884
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
start date reference for the operation |
best_available_taxonomy_dim$observer_species_id
CC ID: 376885
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by the observer program |
project
CC ID: 376886
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
project name |
| Allowed Values: | Groundfish Shelf Survey, Groundfish Slope and Shelf Combination Survery, Groundfish Slope Survey, Groundfish Triennial Shelf Survery, Hypoxia Study, Santa Barbara Basin Study, Shelf Rockfish [2004-2015], Video Study |
midtow_lat_named_parallel
CC ID: 376887
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of parallel, boundary, or commonly used geograpical location |
| Unit of Measure: | NA |
| Allowed Values: | any |
field_identified_taxonomy_dim$species_category
CC ID: 376888
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
upper-level taxonomic ranking |
| Allowed Values: | fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA |
centroid_id
CC ID: 376889
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons. |
sampling_start_time_dim$record_type
CC ID: 376890
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
time record or reason record is unavailable |
| Allowed Values: | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
operation_dim$field_operation_seg_id
CC ID: 376891
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
operation segment id reference to the field operational segment table |
sampling_end_time_whid
CC ID: 376892
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for the sampling end time |
standard_survey_dim$record_type
CC ID: 376893
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
standard survey record or reason record is unavailable |
| Allowed Values: | Standard Survey, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
depth_m
CC ID: 376894
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
| Unit of Measure: | m |
| Allowed Values: | 0-1500 |
target_station_design_dim$upper_right_longitude_whid
CC ID: 376895
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
upper right longitude warehouse identifier for a design type of grid |
target_station_design_dim$mean_depth_whid
CC ID: 376896
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
mean depth warehouse identifier |
stomach_id
CC ID: 376897
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Stomach sample number or barcode |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
target_station_design_dim$station_design_type
CC ID: 376898
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
type of design underlying the survey station set: Transect or Grid to date |
| Allowed Values: | Transect, Grid |
trawl_id
CC ID: 376899
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
identifier for a sampling operation |
station_ur_lat_dd
CC ID: 376900
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of upper right latitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
width_type
CC ID: 376901
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
describes how the measurement was calculated |
| Allowed Values: | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
best_available_taxonomy_whid
CC ID: 376902
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier to best available taxonomy |
statistical_partition_dim$record_type
CC ID: 376903
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
statistical partition record or reason record is unavailable |
| Allowed Values: | Statistical Partition, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
species_category
CC ID: 376904
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
upper-level taxonomic ranking |
| Allowed Values: | fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA |
field_identified_taxonomy_dim$hookandline_species_id
CC ID: 376905
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by hook and line |
station_ll_lat_dd
CC ID: 376906
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of lower left latitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
best_available_taxonomy_dim$subphylum_22
CC ID: 376907
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subphylum name |
field_identified_taxonomy_dim$record_type
CC ID: 376908
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
record or reason record is unavailable |
| Allowed Values: | Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
field_identified_taxonomy_dim$scientific_name_taxonomic_level
CC ID: 376909
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of the lowest taxonomic level used to define scientific name |
longitude_dd
CC ID: 376910
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
numeric representation of longitude in decimal degrees |
| Unit of Measure: | dd |
| Allowed Values: | -180 to 180 |
haul_longitude_dim$longitude_minute_units
CC ID: 376911
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of longitude that makes up the minute unit only |
| Unit of Measure: | min |
| Allowed Values: | 0-59 |
program
CC ID: 376912
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
type of fram program |
| Allowed Values: | Bottom Trawl, Hook and Line |
width_observation_detail_dim$observation_type
CC ID: 376913
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
the type of observation |
| Allowed Values: | NA, width, length, total_catch_weight, taxonomy, etc |
field_identified_taxonomy_dim$superorder_38
CC ID: 376914
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superorder name |
operation_dim$operation_end_time_whid
CC ID: 376915
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
end time reference for the operation |
target_station_design_dim$min_latitude_dd
CC ID: 376916
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of minimum latitude measured in decimal degrees |
| Unit of Measure: | dd |
most_recent_maturity_update_date_dim$yyyymmdd
CC ID: 376917
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
most_recent_maturity_update_date_dim$month_name
CC ID: 376918
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
operation_dim$operation_start_time_whid
CC ID: 376919
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
start time reference for the operation |
field_identified_taxonomy_dim$infraorder_44
CC ID: 376920
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
infraorder name |
standard_survey_dim$standard_survey_length_or_width_indicator
CC ID: 376921
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
identifies if the individual is part of the Standard Length Survey |
| Allowed Values: | Standard Survey Length, Not Standard Survey Length, NA |
length_timestamp
CC ID: 376922
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Timestamp at the point the length is taken on an individual |
field_identified_taxonomy_dim$common_name
CC ID: 376923
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| 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 |
best_available_taxonomy_dim$pacfin_nom_spid
CC ID: 376924
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
PacFIN nominal species identifier |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
actual_station_design_dim$station_design_type
CC ID: 376925
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
type of design underlying the survey station set: Transect or Grid to date |
| Allowed Values: | Transect, Grid |
field_identified_taxonomy_dim$worms_aphiaid
CC ID: 376926
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
WoRMS taxonomic identifier |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
max_depth_m
CC ID: 376927
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
high precision value of maximum depth measured in meters |
| Unit of Measure: | m |
field_identified_taxonomy_whid
CC ID: 376928
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier to field identified taxonomy |
most_recent_age_update_date_dim$month_of_year
CC ID: 376929
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
length_type
CC ID: 376930
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
describes how the measurement was calculated |
| Allowed Values: | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
station_lr_lon_dd
CC ID: 376931
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of lower right longitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
haul_longitude_whid
CC ID: 376932
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for haul longitude |
date_dim$year
CC ID: 376933
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
actual_station_design_dim$centroid_id
CC ID: 376934
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons. |
actual_station_design_whid
CC ID: 376935
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for station design |
operation_dim$coast_guard_number
CC ID: 376936
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Coast Guard documentation number of vessel |
field_identified_taxonomy_dim$kingdom_10
CC ID: 376937
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
kingdom name |
most_recent_taxonomy_update_date_dim$record_type
CC ID: 376938
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
most_recent_age_update_date_dim$month_name
CC ID: 376939
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
taxon_source
CC ID: 376940
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of primary source used to get the measurement |
| Allowed Values: | Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism |
field_identified_taxonomy_dim$acoustics_species_id
CC ID: 376941
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Species ID used in the acoustics program |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
sampling_end_time_dim$minute
CC ID: 376942
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of minutes in the hour |
| Unit of Measure: | min |
| Allowed Values: | 0-60 |
date_yyyymmdd
CC ID: 376943
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
haul_latitude_dim$latitude_in_degree_minute_second
CC ID: 376944
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
| Unit of Measure: | NA |
| Allowed Values: | any |
haul_latitude_dim$latitude_compass_direction
CC ID: 376945
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
latitude compass direction |
| Unit of Measure: | NA |
| Allowed Values: | N, S |
year
CC ID: 376946
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
operation year |
| Unit of Measure: | year |
| Allowed Values: | 2007+ |
most_recent_age_update_date_dim$record_type
CC ID: 376947
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
field_identified_taxonomy_dim$subfamily_52
CC ID: 376948
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subfamily name |
sampling_start_time_dim$hour
CC ID: 376949
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
standard representation of the hour |
| Unit of Measure: | hr |
| Allowed Values: | 0-12 |
most_recent_maturity_update_date_dim$month_of_year
CC ID: 376950
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
lab_maturity_detail_dim$functionally_mature_certain_indicator
CC ID: 376951
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
identifies the certainty of the functionally mature evaluation |
| Allowed Values: | Functionally Mature Certain, Not Functionally Mature Certain, NA |
best_available_taxonomy_dim$subfamily_52
CC ID: 376952
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subfamily name |
otosag_id
CC ID: 376953
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Otolith barcode or sample number |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
haul_latitude_dim$latitude_second_units
CC ID: 376954
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of latitude that makes up the second unit only |
| Unit of Measure: | sec |
| Allowed Values: | 0-60 |
date_whid
CC ID: 376955
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for date |
target_station_design_dim$min_latitude_whid
CC ID: 376956
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
minimum latitude warehouse identifier for a design type of transect |
field_identified_taxonomy_dim$grp_nonstandard_taxon_99
CC ID: 376957
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| 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 |
operation_dim$departure_date_whid
CC ID: 376958
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
date reference that vessel departed for the defined leg or trip |
length_observation_detail_dim$observation_type
CC ID: 376959
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
the type of observation |
| Allowed Values: | NA, width, length, total_catch_weight, taxonomy, etc |
operation_dim$fpc_person_whid
CC ID: 376960
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the FPC |
actual_station_design_dim$transect_latitude_whid
CC ID: 376961
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
latitude warehouse identifier for a design type of transect |
length_cm
CC ID: 376962
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
Individual length measured in centimeters |
| Unit of Measure: | cm |
target_station_design_dim$active_polygon_dd
CC ID: 376963
| Data Storage Type: | polygon |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
collection of vertices of the usuable area inside a station grid measured in decimal degrees |
| Unit of Measure: | dd |
operation_dim$operation_end_date_whid
CC ID: 376964
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
end date reference for the operation |
field_identified_taxonomy_dim$scientific_name
CC ID: 376965
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 120 |
| Required: | No |
| Primary Key: | No |
| 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 |
actual_station_design_dim$max_depth_whid
CC ID: 376966
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
maximum depth warehouse identifier |
actual_station_design_dim$min_depth_m
CC ID: 376967
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
high precision value of minimum depth measured in meters |
| Unit of Measure: | m |
operation_dim$return_date_whid
CC ID: 376968
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
date reference that vessel returned for the defined leg or trip |
haul_longitude_dim$longitude_compass_direction
CC ID: 376969
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
longitude compass direction |
| Allowed Values: | E, W |
target_station_design_dim$transect_latitude_whid
CC ID: 376970
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
latitude warehouse identifier for a design type of transect |
date_dim$full_date
CC ID: 376971
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
target_station_design_dim$upper_left_latitude_whid
CC ID: 376972
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
upper left latitude warehouse identifier for a design type of grid |
actual_station_design_dim$mean_depth_whid
CC ID: 376973
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
mean depth warehouse identifier |
min_depth_m
CC ID: 376974
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
high precision value of minimum depth measured in meters |
| Unit of Measure: | m |
year_stn_invalid
CC ID: 376975
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Survey year the station became invalid for trawl |
| Unit of Measure: | year |
| Allowed Values: | Any |
length_observation_detail_dim$record_type
CC ID: 376976
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
observation detail record type or reason record is unavailable |
| Allowed Values: | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
target_station_design_dim$upper_left_longitude_whid
CC ID: 376977
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
upper left longitude warehouse identifier for a design type of grid |
station_code
CC ID: 376978
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
unique identifier for a station definition |
station_ul_lat_dd
CC ID: 376979
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of upper left latitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
station_ll_lon_dd
CC ID: 376980
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of lower left longitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
vessel
CC ID: 376981
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of the vessel used for the operation |
| 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 |
most_recent_taxonomy_update_date_dim$month_of_year
CC ID: 376982
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
actual_station_design_dim$lower_left_latitude_dd
CC ID: 376983
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of lower left latitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
best_available_taxonomy_dim$superfamily_48
CC ID: 376984
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superfamily name |
depth_ftm
CC ID: 376985
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
| Unit of Measure: | fth |
actual_station_design_dim$transect_latitude_dd
CC ID: 376986
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of transect latitude measured in decimal degrees |
| Unit of Measure: | dd |
weight_kg
CC ID: 376987
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Individual weight measured in kilograms |
| Unit of Measure: | kg |
field_identified_taxonomy_dim$grp_reg_depth_category
CC ID: 376988
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| 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 |
width_observation_detail_dim$source_primary
CC ID: 376989
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of primary source used to get the measurement |
| Allowed Values: | Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism |
target_station_design_dim$transect_station_longitude_whid
CC ID: 376990
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
longitude on transect warehouse identifier for a design type of transect |
actual_station_design_dim$station_grid_dd
CC ID: 376991
| Data Storage Type: | polygon |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
collection of vertices of grid points of a grid design measured in decimal degrees |
| Unit of Measure: | dd |
operation_dim$return_port_whid
CC ID: 376992
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
port reference for return port |
actual_station_design_dim$min_latitude_dd
CC ID: 376993
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of minimum latitude measured in decimal degrees |
| Unit of Measure: | dd |
tow_end_timestamp
CC ID: 376994
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
operation end date timestamp |
best_available_taxonomy_dim$grp_reg_depth_category
CC ID: 376995
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| 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 |
field_identified_taxonomy_dim$subphylum_22
CC ID: 376996
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subphylum name |
operation_dim$captain_person_whid
CC ID: 376997
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the vessel captain |
target_station_design_dim$lower_left_latitude_whid
CC ID: 376998
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
lower left latitude warehouse identifier for a design type of grid |
length_observation_detail_dim$method_description
CC ID: 376999
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 500 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
description of how the observation was taken |
best_available_taxonomy_dim$suborder_42
CC ID: 377000
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
suborder name |
most_recent_age_update_date_whid
CC ID: 377001
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for most recent age update date |
field_identified_taxonomy_dim$phylum_20
CC ID: 377002
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
phylum name |
best_available_taxonomy_dim$superclass_28
CC ID: 377003
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superclass name |
statistical_partition_whid
CC ID: 377004
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for statistical partition |
target_station_design_dim$upper_right_latitude_whid
CC ID: 377005
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
upper right latitude warehouse identifier for a design type of grid |
length_observation_detail_dim$measurement_procurement
CC ID: 377006
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
how the measurement was achieved |
| Allowed Values: | NA, Calculated, Estimated, Observed, Measured, Not Documented |
length_observation_detail_whid
CC ID: 377007
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to taxonomy observation detail |
field_identified_taxonomy_dim$pacfin_spid
CC ID: 377008
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
pacfin species id - many taxa may not have one of these |
operation_dim$ifq_account_number
CC ID: 377009
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
unique number assigned to user accounts in the Vessel Accounting Database |
best_available_taxonomy_dim$subspecies_82
CC ID: 377010
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subspecies name |
scientific_name
CC ID: 377011
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 120 |
| Required: | No |
| Primary Key: | No |
| 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 |
width_observation_detail_dim$measurement_procurement
CC ID: 377012
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
how the measurement was achieved |
| Allowed Values: | NA, Calculated, Estimated, Observed, Measured, Not Documented |
target_station_design_dim$area_hectares
CC ID: 377013
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
station area measured in hectares |
| Unit of Measure: | hectares |
age_years
CC ID: 377014
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Individual age measured in years |
| Unit of Measure: | yrs |
sampling_start_hhmmss
CC ID: 377015
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
most_recent_taxonomy_update_date_dim$month_name
CC ID: 377016
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
best_available_taxonomy_dim$hookandline_species_id
CC ID: 377017
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by hook and line |
best_available_taxonomy_observation_detail_dim$observation_type
CC ID: 377018
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
the type of observation |
| Allowed Values: | NA, width, length, total_catch_weight, taxonomy, etc |
field_identified_taxonomy_dim$genus_70
CC ID: 377019
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
genus name |
most_recent_taxonomy_update_date_dim$year
CC ID: 377020
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
actual_station_design_dim$active_polygon_dd
CC ID: 377021
| Data Storage Type: | polygon |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
collection of vertices of the usuable area inside a station grid measured in decimal degrees |
| Unit of Measure: | dd |
field_identified_taxonomy_dim$abbreviated_name
CC ID: 377022
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
operation_dim$scientist_4_person_whid
CC ID: 377023
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the fourth scientist |
actual_station_design_dim$lower_right_longitude_whid
CC ID: 377024
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
lower right longitude warehouse identifier for a design type of grid |
target_station_design_dim$transect_latitude_dd
CC ID: 377025
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of transect latitude measured in decimal degrees |
| Unit of Measure: | dd |
mean_seafloor_dep_boundary
CC ID: 377026
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
depth boundry indicator identifying ifp boundary marks |
| Allowed Values: | IFP Boundary Depth, Standard Contour Depth, NA |
best_available_taxonomy_dim$grp_nonstandard_taxon_99
CC ID: 377027
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| 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 |
sampling_start_time_dim$second
CC ID: 377028
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of seconds in the minute |
| Unit of Measure: | sec |
| Allowed Values: | 0-60 |
actual_station_design_dim$station_invalid_survey_year
CC ID: 377029
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Survey year the station became invalid for trawl |
| Unit of Measure: | year |
| Allowed Values: | Any |
sampling_start_time_whid
CC ID: 377030
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for the sampling start time |
target_station_design_dim$lower_right_longitude_whid
CC ID: 377031
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
lower right longitude warehouse identifier for a design type of grid |
haul_longitude_dim$record_type
CC ID: 377032
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
longitude record type or reason record is unavailable |
| Allowed Values: | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
tissue_id
CC ID: 377033
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Tissue sample number or barcode |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
actual_station_design_dim$transect_station_longitude_whid
CC ID: 377034
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
longitude on transect warehouse identifier for a design type of transect |
best_available_taxonomy_dim$tribe_60
CC ID: 377035
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
tribe name |
field_note
CC ID: 377036
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 1000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Note made in the field about an individual |
sex_dim$sex
CC ID: 377037
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
actual_station_design_dim$station_code
CC ID: 377038
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
unique identifier for a station definition |
latitude_dd
CC ID: 377039
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
numeric representation of latitude in degrees |
| Unit of Measure: | dd |
| Allowed Values: | -90 to 90 |
actual_station_design_dim$station_design_name
CC ID: 377040
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of the design for a collection of stations |
lab_maturity_detail_dim$biologically_mature_certain_indicator
CC ID: 377041
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
identifies the certainty of the biological maturity |
| Allowed Values: | Biologically Mature Certain, Not Biologically Mature Certain, NA |
actual_station_design_dim$lower_right_latitude_whid
CC ID: 377042
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
lower right latitude warehouse identifier for a design type of grid |
haul_longitude_dim$longitude_degree_units
CC ID: 377043
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of longitude that makes up the degree unit only |
| Unit of Measure: | deg |
| Allowed Values: | -180 to 180 |
best_available_taxonomy_observation_detail_dim$means_of_calculation
CC ID: 377044
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
describes how the measurement was calculated |
| Allowed Values: | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
most_recent_age_update
CC ID: 377045
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
actual_station_design_dim$area_hectares
CC ID: 377046
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
station area measured in hectares |
| Unit of Measure: | hectares |
taxon_rank
CC ID: 377047
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of the lowest taxonomic level used to define scientific name |
best_available_taxonomy_observation_detail_dim$record_type
CC ID: 377048
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
observation detail record type or reason record is unavailable |
| Allowed Values: | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
best_available_taxonomy_dim$norpac_species_id
CC ID: 377049
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| 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. |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
field_identified_taxonomy_dim$observer_species_id
CC ID: 377050
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by the observer program |
operation_dim_whid
CC ID: 377051
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for operation |
operation_dim$scientist_2_person_whid
CC ID: 377052
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the second scientist |
most_recent_taxonomy_update_date_dim$yyyymmdd
CC ID: 377053
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
best_available_taxonomy_dim$genus_70
CC ID: 377054
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
genus name |
net_touchdown_time
CC ID: 377055
| Data Storage Type: | time |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
military time representation of the time |
best_available_taxonomy_dim$itis_taxonomic_serial_no
CC ID: 377056
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
ITIS taxonomic identifier |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
operation_dim$vessel_id
CC ID: 377057
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
field database vessel id number |
left_pectoral_fin_id
CC ID: 377058
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Left pectoral fin sample number or barcode |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
best_available_taxonomy_dim$worms_aphiaid
CC ID: 377059
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
WoRMS taxonomic identifier |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
lab_maturity_detail_dim$biologically_mature_indicator
CC ID: 377060
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
identifies biological maturity of the individual |
| Allowed Values: | Biologically Mature, Not Biologically Mature, NA |
most_recent_taxonomy_update_date_whid
CC ID: 377061
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for most recent taxonomy update date |
haul_latitude_whid
CC ID: 377062
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for haul latitude |
operation_dim$state_registration_number
CC ID: 377063
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
state registration number for the vessel |
actual_station_design_dim$upper_right_latitude_dd
CC ID: 377064
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of upper right latitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
date_dim$month_abbrev
CC ID: 377065
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
actual_station_design_dim$upper_left_longitude_dd
CC ID: 377066
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of upper left longitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
best_available_taxonomy_observation_detail_dim$method_description
CC ID: 377067
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 500 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
description of how the observation was taken |
width_observation_detail_whid
CC ID: 377068
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to taxonomy observation detail |
haul_latitude_dim$latitude_degree_units
CC ID: 377069
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of latitude that makes up the degree unit only |
| Unit of Measure: | deg |
| Allowed Values: | -90 to 90 |
common_name
CC ID: 377070
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| 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 |
actual_station_design_dim$mean_depth_m
CC ID: 377071
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
high precision value of mean depth measured in meters |
| Unit of Measure: | m |
field_identified_taxonomy_dim$pacfin_nom_spid
CC ID: 377072
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
PacFIN nominal species identifier |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
field_identified_taxonomy_dim$superclass_28
CC ID: 377073
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superclass name |
actual_station_design_dim$max_depth_m
CC ID: 377074
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
high precision value of maximum depth measured in meters |
| Unit of Measure: | m |
field_identified_taxonomy_dim$superfamily_48
CC ID: 377075
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superfamily name |
most_recent_age_update_date_dim$month_abbrev
CC ID: 377076
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
tow_start_timestamp
CC ID: 377077
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
operation start date timestamp |
actual_station_design_dim$reason_station_invalid
CC ID: 377078
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
reason station was invalidated, multiple reasons are comma separated |
| Allowed Values: | California State MPA, Cowcod Conservation Area, ENC Avoidance, Farallon Island Radioactive Waste Dump, ONMS MPA, ONMS Permit Exclusion, Outside Survey Extent, Mooring, San Clemente Is. Military test range |
standard_survey_dim$standard_survey_maturity_indicator
CC ID: 377079
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
identifies if the individual is part of the Standard Maturity Survey |
| Allowed Values: | Standard Survey Maturity, Not Standard Survey Maturity, NA |
station_lr_lat_dd
CC ID: 377080
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of lower right latitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
best_available_taxonomy_dim$infraclass_34
CC ID: 377081
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
infraclass name |
length_observation_detail_dim$source_primary
CC ID: 377082
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of primary source used to get the measurement |
| Allowed Values: | Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism |
target_station_design_dim$max_latitude_dd
CC ID: 377083
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of maximum latitude measured in decimal degrees |
| Unit of Measure: | dd |
operation_dim$trip_id
CC ID: 377084
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
trip identifier number |
sampling_start_time_dim$period
CC ID: 377085
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
period of time |
| Allowed Values: | AM, PM |
operation_dim$record_type
CC ID: 377086
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
operation record or reason record is unavailable |
| Allowed Values: | Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
sampling_end_hhmmss
CC ID: 377087
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
date_dim$month_name
CC ID: 377088
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
target_station_design_dim$lower_left_longitude_whid
CC ID: 377089
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
lower left longitude warehouse identifier for a design type of grid |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
target_station_design_dim$station_grid_dd
CC ID: 377090
| Data Storage Type: | polygon |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
collection of vertices of grid points of a grid design measured in decimal degrees |
| Unit of Measure: | dd |
most_recent_age_update_date_dim$day_of_month
CC ID: 377091
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
tow
CC ID: 377092
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
operation number of the survey |
actual_station_design_dim$stn_invalid_for_trawl_date_whid
CC ID: 377093
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
station design invalidation date warehouse identifier |
standard_survey_dim$standard_survey_age_indicator
CC ID: 377094
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
identifies if the individual is part of the Standard Age Survey |
| Allowed Values: | Standard Survey Age, Not Standard Survey Age, NA |
width_observation_detail_dim$record_type
CC ID: 377095
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
observation detail record type or reason record is unavailable |
| Allowed Values: | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
field_identified_taxonomy_dim$infraclass_34
CC ID: 377096
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
infraclass name |
most_recent_maturity_update_date_dim$record_type
CC ID: 377097
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
field_identified_taxonomy_dim$subspecies_82
CC ID: 377098
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subspecies name |
best_available_taxonomy_dim$acoustics_species_id
CC ID: 377099
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Species ID used in the acoustics program |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
actual_station_design_dim$max_latitude_whid
CC ID: 377100
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
maximum latitude warehouse identifier for a design type of transect |
most_recent_age_update_date_dim$year
CC ID: 377101
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
species_subcategory
CC ID: 377102
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
mid-level taxonomic ranking |
| Allowed Values: | rockfish, flatfish, shark, crab, NA |
date_dim$day_of_month
CC ID: 377103
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
actual_station_design_dim$upper_left_latitude_dd
CC ID: 377104
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of upper left latitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
field_identified_taxonomy_dim$tribe_60
CC ID: 377105
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
tribe name |
leg
CC ID: 377106
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
leg number of the survey |
| Allowed Values: | 1,2,3,4,5,6,7,8 |
field_identified_taxonomy_dim$subclass_32
CC ID: 377107
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subclass name |
best_available_taxonomy_observation_detail_whid
CC ID: 377108
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier to best available taxonomy observation detail |
seafloor_depth_dim$record_type
CC ID: 377109
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
depth record or reason record is unavailable |
| Allowed Values: | Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
station_ul_lon_dd
CC ID: 377110
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of upper left longitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
most_recent_taxonomy_update_date_dim$month_abbrev
CC ID: 377111
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
field_identified_taxonomy_dim$class_30
CC ID: 377112
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
class name |
sampling_end_time_dim$hour
CC ID: 377113
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
standard representation of the hour |
| Unit of Measure: | hr |
| Allowed Values: | 0-12 |
actual_station_design_dim$upper_left_latitude_whid
CC ID: 377114
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
upper left latitude warehouse identifier for a design type of grid |
sampling_start_time_dim$military_hour
CC ID: 377115
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
military representation of the hour |
| Allowed Values: | 0-24 |
haul_longitude_dim$longitude_in_degree_minute_second
CC ID: 377116
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
reason_stn_invalid
CC ID: 377117
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
reason station was invalidated, multiple reasons are comma separated |
| Allowed Values: | California State MPA, Cowcod Conservation Area, ENC Avoidance, Farallon Island Radioactive Waste Dump, ONMS MPA, ONMS Permit Exclusion, Outside Survey Extent, Mooring, San Clemente Is. Military test range |
sampling_end_time_dim$second
CC ID: 377118
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of seconds in the minute |
| Unit of Measure: | sec |
| Allowed Values: | 0-60 |
best_available_taxonomy_dim$superorder_38
CC ID: 377119
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superorder name |
best_available_taxonomy_dim$kingdom_10
CC ID: 377120
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
kingdom name |
field_identified_taxonomy_dim$trawl_survey_species_id
CC ID: 377121
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by the trawl survey |
actual_station_design_dim$lower_right_latitude_dd
CC ID: 377122
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of lower right latitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
partition
CC ID: 377123
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Refines the partition type |
| Allowed Values: | Life stage: YOY, larvae, eggs and egg cases, adult, subadult; Size: Large, Small, Unspecified; Gender: Male, Female |
field_identified_taxonomy_dim$norpac_species_id
CC ID: 377124
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| 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. |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
field_identified_taxonomy_dim$suborder_42
CC ID: 377125
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
suborder name |
field_identified_taxonomy_dim$family_50
CC ID: 377126
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
family name |
sampling_end_time_dim$record_type
CC ID: 377127
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
time record or reason record is unavailable |
| Allowed Values: | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
actual_station_design_dim$lower_right_longitude_dd
CC ID: 377128
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of lower right longitude of design type grid measured in decimal degrees |
| Unit of Measure: | dd |
best_available_taxonomy_dim$class_30
CC ID: 377129
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
class name |
seafloor_depth_whid
CC ID: 377130
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for seafloor depth |
target_station_design_dim$mean_depth_m
CC ID: 377131
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
high precision value of mean depth measured in meters |
| Unit of Measure: | m |
field_identified_taxonomy_dim$species_sub_category
CC ID: 377132
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
mid-level taxonomic ranking |
| Allowed Values: | rockfish, flatfish, shark, crab, NA |
operation_dim$observer_program
CC ID: 377133
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
description of the observer program |
lab_maturity_detail_dim$functionally_mature_indicator
CC ID: 377134
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
identifies the functional maturity of the individual |
| Allowed Values: | Functionally Mature, Not Functionally Mature, NA |
pacfin_spid
CC ID: 377135
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
pacfin species id - many taxa may not have one of these |
best_available_taxonomy_dim$infraorder_44
CC ID: 377136
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
infraorder name |
most_recent_maturity_update_date_dim$day_of_month
CC ID: 377137
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
statistical_partition_dim$statistical_partition_type
CC ID: 377138
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Defines the partition type |
| Allowed Values: | Life Stage, Size, Gender |
target_station_design_dim$record_type
CC ID: 377139
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
station design record or reason record is unavailable |
| Allowed Values: | Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
best_available_taxonomy_dim$order_40
CC ID: 377140
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
order name |
actual_station_design_dim$min_depth_whid
CC ID: 377141
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
minimum depth warehouse identifier |
actual_station_design_dim$max_latitude_dd
CC ID: 377142
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
high precision value of maximum latitude measured in decimal degrees |
| Unit of Measure: | dd |
field_identified_taxonomy_dim$order_40
CC ID: 377143
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
order name |
field_identified_taxonomy_dim$species_80
CC ID: 377144
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
species name |
sampling_end_time_dim$military_hour
CC ID: 377145
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
military representation of the hour |
| Allowed Values: | 0-24 |
lab_maturity_detail_dim$record_type
CC ID: 377146
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
lab maturity detail record or reason record is unavailable |
| Allowed Values: | Lab Maturity Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
best_available_taxonomy_dim$species_80
CC ID: 377147
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
species name |
best_available_taxonomy_observation_detail_dim$measurement_procurement
CC ID: 377148
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
how the measurement was achieved |
| Allowed Values: | NA, Calculated, Estimated, Observed, Measured, Not Documented |
target_station_design_dim$lower_right_latitude_whid
CC ID: 377149
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
lower right latitude warehouse identifier for a design type of grid |
operation_dim$operation_type
CC ID: 377150
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
type of operation |
| Allowed Values: | CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null] |
haul_latitude_dim$latitude_minute_units
CC ID: 377151
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of latitude that makes up the minute unit only |
| Unit of Measure: | min |
| Allowed Values: | 0-60 |
actual_station_design_dim$record_type
CC ID: 377152
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
station design record or reason record is unavailable |
| Allowed Values: | Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
target_station_design_dim$max_depth_whid
CC ID: 377153
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
maximum depth warehouse identifier |
best_available_taxonomy_dim$subclass_32
CC ID: 377154
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subclass name |
haul_longitude_dim$longitude_second_units
CC ID: 377155
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of longitude that makes up the second unit only |
| Unit of Measure: | sec |
| Allowed Values: | 0-59 |
sex_dim$record_type
CC ID: 377156
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
latitude record type or reason record is unavailable |
| Unit of Measure: | NA |
| Allowed Values: | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
actual_station_design_dim$min_latitude_whid
CC ID: 377157
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
minimum latitude warehouse identifier for a design type of transect |
date_dim$month_of_year
CC ID: 377158
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
most_recent_maturity_update_date_dim$month_abbrev
CC ID: 377159
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
operation_dim$limited_entry_permit_number
CC ID: 377160
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California |
sex
CC ID: 377161
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
target_station_design_dim$station_design_name
CC ID: 377162
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of the design for a collection of stations |
best_available_taxonomy_dim$trawl_survey_species_id
CC ID: 377163
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by the trawl survey |
lab_maturity_detail_whid
CC ID: 377164
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for lab maturity details |
most_recent_maturity_update_date_dim$full_date
CC ID: 377165
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
most_recent_maturity_update_date_dim$year
CC ID: 377166
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |