catch_fact
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36437 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
vessel | varchar | name of the vessel used for the operation | |
|
100
|
target_station_design_dim$station_design_name | varchar | name of the design for a collection of stations | |
|
100
|
best_available_taxonomy_dim$structure_source | varchar | Source of the taxonomic structure | |
|
100
|
min_depth_m | numeric | high precision value of minimum depth measured in meters | |
|
100
|
actual_station_design_dim$min_depth_whid | int4 | minimum depth warehouse identifier | |
|
100
|
net_touchdown_time | time | military time representation of the time | |
|
100
|
species_category | varchar | upper-level taxonomic ranking | |
|
100
|
year_stn_invalid | int2 | Survey year the station became invalid for trawl | |
|
100
|
best_available_taxonomy_dim$subfamily_52 | varchar | subfamily name | |
|
100
|
sampling_end_time_dim$period | bpchar | period of time | |
|
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
|
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$subphylum_22 | varchar | subphylum name | |
|
100
|
actual_station_design_dim$station_code | varchar | unique identifier for a station definition | |
|
100
|
catch_id | int8 | unique(legacy) identifier for the catch from a haul, sorted to taxonomic group or debris type. | |
|
100
|
best_available_taxonomy_dim$itis_taxonomic_serial_no | int4 | ITIS taxonomic identifier | |
|
100
|
field_identified_taxonomy_dim$species_80 | varchar | species name | |
|
100
|
field_identified_taxonomy_dim$subfamily_52 | varchar | subfamily name | |
|
100
|
haul_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable | |
|
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
|
operation_dim$limited_entry_permit_number | bpchar | federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California | |
|
100
|
field_identified_taxonomy_dim$superfamily_48 | varchar | superfamily name | |
|
100
|
date_dim$full_date | timestamp | full date value | |
|
100
|
actual_station_design_dim$station_invalid_survey_year | int2 | Survey year the station became invalid for trawl | |
|
100
|
actual_station_design_dim$lower_left_longitude_whid | int4 | lower left longitude warehouse identifier for a design type of grid | |
|
100
|
total_catch_wt_observation_detail_whid | int4 | warehouse identifier to total catch weight observation details | |
|
100
|
target_station_design_dim$transect_station_longitude_whid | int4 | longitude on transect warehouse identifier for a design type of transect | |
|
100
|
best_available_taxonomy_dim$superfamily_48 | varchar | superfamily name | |
|
100
|
field_identified_taxonomy_dim$superclass_28 | varchar | superclass name | |
|
100
|
haul_latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" | |
|
100
|
actual_station_design_dim$station_grid_dd | polygon | collection of vertices of grid points of a grid design measured in decimal degrees | |
|
100
|
field_identified_taxonomy_dim$infraclass_34 | varchar | infraclass name | |
|
100
|
best_available_taxonomy_dim$acoustics_species_id | int4 | Species ID used in the acoustics program | |
|
100
|
most_recent_taxon_update | timestamp | full date value | |
|
100
|
operation_dim$scientist_3_person_whid | int4 | person reference for the third scientist | |
|
100
|
target_station_design_dim$lower_left_latitude_whid | int4 | lower left latitude warehouse identifier for a design type of grid | |
|
100
|
actual_station_design_dim$area_hectares | numeric | station area measured in hectares | |
|
100
|
haul_longitude_whid | int4 | warehouse identifier for haul longitude | |
|
100
|
best_available_taxonomy_dim$worms_aphiaid | int4 | WoRMS taxonomic identifier | |
|
100
|
target_station_design_dim$max_depth_whid | int4 | maximum depth warehouse identifier | |
|
100
|
best_available_taxonomy_observation_detail_dim$record_type | varchar | observation detail record type or reason record is unavailable | |
|
100
|
field_identified_taxonomy_dim$order_40 | varchar | order name | |
|
100
|
most_recent_taxonomy_update_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
|
100
|
haul_longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only | |
|
100
|
actual_station_design_dim$min_latitude_whid | int4 | minimum latitude warehouse identifier for a design type of transect | |
|
100
|
pass | int4 | pass number of the survey | |
|
100
|
actual_station_design_dim$min_depth_m | numeric | high precision value of minimum depth measured in meters | |
|
100
|
station_ul_lat_dd | numeric | high precision value of upper left latitude of design type grid measured in decimal degrees | |
|
100
|
total_catch_numbers | int4 | numbers expansion for a taxonomic group within a haul. | |
|
100
|
max_depth_m | numeric | high precision value of maximum depth measured in meters | |
|
100
|
operation_dim$operation_start_time_whid | int8 | start time reference for the operation | |
|
100
|
best_available_taxonomy_dim$family_50 | varchar | family name | |
|
100
|
field_identified_taxonomy_dim$itis_taxonomic_serial_no | int4 | ITIS taxonomic identifier | |
|
100
|
program | varchar | type of fram program | |
|
100
|
best_available_taxonomy_dim$record_type | varchar | record or reason record is unavailable | |
|
100
|
operation_dim$captain_person_whid | int4 | person reference for the vessel captain | |
|
100
|
total_catch_wt_observation_detail_dim$source_primary | varchar | name of primary source used to get the measurement | |
|
100
|
total_catch_wt_observation_detail_dim$means_of_calculation | varchar | describes how the measurement was calculated | |
|
100
|
actual_station_design_dim$upper_left_latitude_whid | int4 | upper left latitude warehouse identifier for a design type of grid | |
|
100
|
target_station_design_dim$stn_invalid_for_trawl_date_whid | int8 | station design invalidation date warehouse identifier | |
|
100
|
mean_seafloor_dep_boundary | varchar | depth boundry indicator identifying ifp boundary marks | |
|
100
|
field_identified_taxonomy_dim$infraorder_44 | varchar | infraorder name | |
|
100
|
operation_dim$fpc_person_whid | int4 | person reference for the FPC | |
|
100
|
best_available_taxonomy_dim$order_40 | varchar | order name | |
|
100
|
haul_latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only | |
|
100
|
target_station_design_dim$max_latitude_dd | numeric | high precision value of maximum latitude measured in decimal degrees | |
|
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
|
sampling_start_time_dim$military_hour | int2 | military representation of the hour | |
|
100
|
actual_station_design_dim$station_design_name | varchar | name of the design for a collection of stations | |
|
100
|
pacfin_spid | varchar | pacfin species id - many taxa may not have one of these | |
|
100
|
leg | int2 | leg number of the survey | |
|
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
|
actual_station_design_dim$record_type | varchar | station design record or reason record is unavailable | |
|
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_type | varchar | type of operation | |
|
100
|
subsample_count | int4 | count of the subsample used for numbers expansion. This is usually either the counted fraction or the subsample that is measured for fish length. | |
|
100
|
best_available_taxonomy_dim$observer_species_id | int4 | species identifier used by the observer program | |
|
100
|
reason_stn_invalid | varchar | reason station was invalidated, multiple reasons are comma separated | |
|
100
|
actual_station_design_dim$transect_latitude_dd | numeric | high precision value of transect latitude measured in decimal degrees | |
|
100
|
operation_dim$ifq_account_number | varchar | unique number assigned to user accounts in the Vessel Accounting Database | |
|
100
|
field_identified_taxonomy_dim$hookandline_species_id | int4 | species identifier used by hook and line | |
|
100
|
target_station_design_dim$upper_right_longitude_whid | int4 | upper right longitude warehouse identifier for a design type of grid | |
|
100
|
actual_station_design_dim$min_latitude_dd | numeric | high precision value of minimum latitude measured in decimal degrees | |
|
100
|
station_ll_lat_dd | numeric | high precision value of lower left latitude of design type grid measured in decimal degrees | |
|
100
|
most_recent_taxonomy_update_date_dim$month_of_year | int2 | numeric representation of month of year | |
|
100
|
actual_station_design_dim$upper_right_latitude_whid | int4 | upper right latitude warehouse identifier for a design type of grid | |
|
100
|
operation_dim$operation_end_date_whid | int8 | end date reference for the operation | |
|
100
|
sampling_start_time_dim$second | int2 | number of seconds in the minute | |
|
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
|
best_available_taxonomy_dim$superclass_28 | varchar | superclass name | |
|
100
|
total_catch_wt_observation_detail_dim$record_type | varchar | observation detail record type or reason record is unavailable | |
|
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
|
best_available_taxonomy_dim$subspecies_82 | varchar | subspecies name | |
|
100
|
sampling_end_time_whid | int8 | warehouse identifier for the sampling end time | |
|
100
|
actual_station_design_dim$transect_station_longitude_dd | numeric | high precision value of transect station longitude measured in decimal degrees | |
|
100
|
operation_dim$scientist_4_person_whid | int4 | person reference for the fourth scientist | |
|
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
|
tow_end_timestamp | timestamp | operation end date timestamp | |
|
100
|
target_station_design_dim$area_hectares | numeric | station area measured in hectares | |
|
100
|
target_station_design_dim$mean_depth_m | numeric | high precision value of mean depth measured in meters | |
|
100
|
most_recent_taxonomy_update_date_dim$month_name | varchar | text representation of month | |
|
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
|
tow_start_timestamp | timestamp | operation start date timestamp | |
|
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$structure_source | varchar | Source of the taxonomic structure | |
|
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$hookandline_species_id | int4 | species identifier used by hook and line | |
|
100
|
operation_dim$trip_id | int4 | trip identifier number | |
|
100
|
field_identified_taxonomy_dim$family_50 | varchar | family name | |
|
100
|
species_subcategory | varchar | mid-level taxonomic ranking | |
|
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
|
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$coast_guard_number | varchar | Coast Guard documentation number of vessel | |
|
100
|
date_dim$month_name | varchar | text representation of month | |
|
100
|
operation_dim$record_type | varchar | operation record or reason record is unavailable | |
|
100
|
target_station_design_dim$lower_left_longitude_whid | int4 | lower left longitude warehouse identifier for a design type of grid | |
|
100
|
operation_dim$operation_end_time_whid | int8 | end time reference for the operation | |
|
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$transect_station_longitude_whid | int4 | longitude on transect warehouse identifier for a design type of transect | |
|
100
|
actual_station_design_dim$max_latitude_dd | numeric | high precision value of maximum latitude measured in decimal degrees | |
|
100
|
field_identified_taxonomy_dim$subspecies_82 | varchar | subspecies name | |
|
100
|
target_station_design_dim$mean_depth_whid | int4 | mean depth warehouse identifier | |
|
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
|
sampling_end_time_dim$military_hour | int2 | military representation of the hour | |
|
100
|
sampling_start_time_dim$period | bpchar | period of time | |
|
100
|
total_catch_wt_kg | numeric | total catch weight in kilograms is ordinarily the weight of a taxonomic group within a haul. It is usually the sum of all baskets weights collected for a taxonomic group within a haul, but may be derived as a linear expansion based on a weighed, sorted subsample pulled randomly from the weighed unsorted total within a haul. | |
|
100
|
best_available_taxonomy_dim$phylum_20 | varchar | phylum name | |
|
100
|
best_available_taxonomy_dim$suborder_42 | varchar | suborder name | |
|
100
|
net_liftoff_time | time | military time representation of the time | |
|
100
|
sampling_end_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 | |
|
100
|
most_recent_taxonomy_update_date_dim$day_of_month | int2 | numeric representation of the day in month | |
|
100
|
partition | varchar | Refines the partition type | |
|
100
|
best_available_taxonomy_dim$tribe_60 | varchar | tribe name | |
|
100
|
actual_station_design_dim$mean_depth_whid | int4 | mean depth warehouse identifier | |
|
100
|
sampling_start_time_dim$minute | int2 | number of minutes in the hour | |
|
100
|
target_station_design_dim$upper_left_longitude_whid | int4 | upper left longitude warehouse identifier for a design type of grid | |
|
100
|
field_identified_taxonomy_dim$worms_aphiaid | int4 | WoRMS taxonomic identifier | |
|
100
|
haul_longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" | |
|
100
|
station_ur_lon_dd | numeric | high precision value of upper right longitude of design type grid measured in decimal degrees | |
|
100
|
statistical_partition_dim$record_type | varchar | statistical partition record or reason record is unavailable | |
|
100
|
midtow_lat_named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location | |
|
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
|
most_recent_taxonomy_update_date_dim$yyyymmdd | bpchar | text representation of year month day | |
|
100
|
field_identified_taxonomy_dim$subclass_32 | varchar | subclass name | |
|
100
|
target_station_design_dim$station_grid_dd | polygon | collection of vertices of grid points of a grid design measured in decimal degrees | |
|
100
|
target_station_design_dim$transect_latitude_dd | numeric | high precision value of transect latitude measured in decimal degrees | |
|
100
|
target_station_design_whid | int4 | warehouse identifier for target station design | |
|
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
|
field_identified_taxonomy_dim$phylum_20 | varchar | phylum name | |
|
100
|
actual_station_design_dim$variance_depth_m2 | numeric | high precision value of variance depth mesured in squared meters | |
|
100
|
haul_latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only | |
|
100
|
operation_dim_whid | int8 | warehouse identifier for operation | |
|
100
|
field_identified_taxonomy_dim$species_category | varchar | upper-level taxonomic ranking | |
|
100
|
best_available_taxonomy_observation_detail_dim$measurement_procurement | varchar | how the measurement was achieved | |
|
100
|
total_catch_wt_observation_detail_dim$method_description | varchar | description of how the observation was taken | |
|
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
|
best_available_taxonomy_dim$class_30 | varchar | class name | |
|
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
|
performance | varchar | performance of the operation | |
|
100
|
date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
|
100
|
station_ll_lon_dd | numeric | high precision value of lower left longitude of design type grid measured in decimal degrees | |
|
100
|
seafloor_depth_whid | int4 | warehouse identifier for seafloor depth | |
|
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
|
field_identified_taxonomy_dim$scientific_name_taxonomic_level | varchar | name of the lowest taxonomic level used to define scientific name | |
|
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
|
target_station_design_dim$station_design_type | varchar | type of design underlying the survey station set: Transect or Grid to date | |
|
100
|
operation_dim$departure_port_whid | int4 | port reference for the departure port | |
|
100
|
haul_latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only | |
|
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
|
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
|
operation_dim$field_operation_seg_id | int8 | operation segment id reference to the field operational segment table | |
|
100
|
haul_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction | |
|
100
|
field_identified_taxonomy_dim$record_type | varchar | record or reason record is unavailable | |
|
100
|
station_lr_lon_dd | numeric | high precision value of lower right longitude of design type grid measured in decimal degrees | |
|
100
|
date_dim$day_of_month | int2 | numeric representation of the day in month | |
|
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
|
cpue_kg_per_ha_der | numeric | derivation of catch per unit effort in weight (kilograms) per hectare ordinarily estimated as the expanded haul catch weight divided by the area swept by the net. | |
|
100
|
field_identified_taxonomy_dim$species_sub_category | varchar | mid-level taxonomic ranking | |
|
100
|
field_note | varchar | notes made in the field about the catch | |
|
100
|
operation_dim$scientist_2_person_whid | int4 | person reference for the second scientist | |
|
100
|
actual_station_design_dim$max_depth_whid | int4 | maximum depth warehouse identifier | |
|
100
|
most_recent_taxonomy_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
|
100
|
target_station_design_dim$max_latitude_whid | int4 | maximum latitude warehouse identifier for a design type of transect | |
|
100
|
haul_longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only | |
|
100
|
date_dim$year | int4 | numeric representation of year | |
|
100
|
operation_dim$state_registration_number | varchar | state registration number for the vessel | |
|
100
|
best_available_taxonomy_dim$genus_70 | varchar | genus name | |
|
100
|
total_catch_wt_observation_detail_dim$observation_type | varchar | the type of observation | |
|
100
|
actual_station_design_dim$transect_latitude_whid | int4 | latitude warehouse identifier for a design type of transect | |
|
100
|
sampling_end_time_dim$hour | int2 | standard representation of the hour | |
|
100
|
target_station_design_dim$lower_right_latitude_whid | int4 | lower right latitude warehouse identifier for a design type of grid | |
|
100
|
field_identified_taxonomy_dim$pacfin_spid | varchar | pacfin species id - many taxa may not have one of these | |
|
100
|
latitude_dd | numeric | numeric representation of latitude in degrees | |
|
100
|
taxon_rank | varchar | name of the lowest taxonomic level used to define scientific name | |
|
100
|
haul_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable | |
|
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
|
actual_station_design_dim$reason_station_invalid | varchar | reason station was invalidated, multiple reasons are comma separated | |
|
100
|
target_station_design_dim$min_latitude_dd | numeric | high precision value of minimum latitude measured in decimal degrees | |
|
100
|
field_identified_taxonomy_dim$tribe_60 | varchar | tribe name | |
|
100
|
field_identified_taxonomy_dim$observer_species_id | int4 | species identifier used by the observer program | |
|
100
|
sampling_end_time_dim$record_type | varchar | time record or reason record is unavailable | |
|
100
|
target_station_design_dim$transect_station_longitude_dd | numeric | high precision value of transect station longitude measured in decimal degrees | |
|
100
|
most_recent_taxonomy_update_date_dim$year | int4 | numeric representation of year | |
|
100
|
target_station_design_dim$upper_left_latitude_whid | int4 | upper left latitude warehouse identifier for a design type of grid | |
|
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$mean_depth_m | numeric | high precision value of mean depth measured in meters | |
|
100
|
actual_station_design_dim$upper_left_longitude_whid | int4 | upper left longitude warehouse identifier for a design type of grid | |
|
100
|
field_identified_taxonomy_dim$class_30 | varchar | class name | |
|
100
|
statistical_partition_whid | int4 | warehouse identifier for statistical partition | |
|
100
|
best_available_taxonomy_dim$infraclass_34 | varchar | infraclass name | |
|
100
|
best_available_taxonomy_dim$pacfin_nom_spid | varchar | PacFIN nominal species identifier | |
|
100
|
best_available_taxonomy_dim$subphylum_22 | varchar | subphylum name | |
|
100
|
actual_station_design_dim$max_depth_m | numeric | high precision value of maximum depth measured in meters | |
|
100
|
best_available_taxonomy_observation_detail_dim$means_of_calculation | varchar | describes how the measurement was calculated | |
|
100
|
sampling_end_time_dim$minute | int2 | number of minutes in the hour | |
|
100
|
date_yyyymmdd | bpchar | text representation of year month day | |
|
100
|
best_available_taxonomy_whid | int4 | warehouse identifier to best available taxonomy | |
|
100
|
haul_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction | |
|
100
|
project | varchar | project name | |
|
100
|
best_available_taxonomy_dim$trawl_survey_species_id | int4 | species identifier used by the trawl survey | |
|
100
|
total_catch_wt_observation_detail_dim$measurement_procurement | varchar | how the measurement was achieved | |
|
100
|
station_ur_lat_dd | numeric | high precision value of upper right latitude of design type grid measured in decimal degrees | |
|
100
|
target_station_design_dim$transect_latitude_whid | int4 | latitude warehouse identifier for a design type of transect | |
|
100
|
best_available_taxonomy_dim$infraorder_44 | varchar | infraorder name | |
|
100
|
field_identified_taxonomy_dim$superorder_38 | varchar | superorder name | |
|
100
|
actual_station_design_dim$lower_right_latitude_whid | int4 | lower right latitude warehouse identifier for a design type of grid | |
|
100
|
operation_dim$observer_program | varchar | description of the observer program | |
|
100
|
actual_station_design_whid | int4 | warehouse identifier for station design | |
|
100
|
tow | int2 | operation number of the survey | |
|
100
|
actual_station_design_dim$lower_right_longitude_whid | int4 | lower right longitude warehouse identifier for a design type of grid | |
|
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
|
subsample_wt_kg | numeric | weight in kilograms of the subsample used for numbers expansion. This is usually either the counted fraction or the subsample that is measured for fish length. | |
|
100
|
operation_dim$return_port_whid | int4 | port reference for return port | |
|
100
|
field_identified_taxonomy_whid | int4 | warehouse identifier to field identified taxonomy | |
|
100
|
date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
|
100
|
most_recent_taxonomy_update_date_whid | int8 | warehouse identifier for most recent taxonomy update date | |
|
100
|
best_available_taxonomy_observation_detail_dim$observation_type | varchar | the type of observation | |
|
100
|
best_available_taxonomy_dim$species_80 | varchar | species name | |
|
100
|
taxon_source | varchar | name of primary source used to get the measurement | |
|
100
|
date_dim$month_of_year | int2 | numeric representation of month of year | |
|
100
|
field_identified_taxonomy_dim$kingdom_10 | varchar | kingdom name | |
|
100
|
sampling_end_time_dim$second | int2 | number of seconds in the minute | |
|
100
|
haul_latitude_whid | int4 | warehouse identifier for haul latitude | |
|
100
|
operation_dim$departure_date_whid | int8 | date reference that vessel departed for the defined leg or trip | |
|
100
|
actual_station_design_dim$max_latitude_whid | int4 | maximum latitude warehouse identifier for a design type of transect | |
|
100
|
sampling_start_time_dim$record_type | varchar | time record or reason record is unavailable | |
|
100
|
target_station_design_dim$variance_depth_m2 | numeric | high precision value of variance depth mesured in squared meters | |
|
100
|
field_identified_taxonomy_dim$acoustics_species_id | int4 | Species ID used in the acoustics program | |
|
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
|
depth_m | numeric | depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) | |
|
100
|
operation_dim$scientist_1_person_whid | int4 | person reference for the first scientist | |
|
100
|
target_station_design_dim$upper_right_latitude_whid | int4 | upper right latitude warehouse identifier for a design type of grid | |
|
100
|
best_available_taxonomy_dim$subclass_32 | varchar | subclass name | |
|
100
|
haul_longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only | |
|
100
|
target_station_design_dim$record_type | varchar | station design record or reason record is unavailable | |
|
100
|
field_identified_taxonomy_dim$trawl_survey_species_id | int4 | species identifier used by the trawl survey | |
|
100
|
cpue_numbers_per_ha_der | numeric | derivation of catch per unit effort in numbers of individuals per hectare ordinarily estimated as the expanded haul catch in numbers divided by the area swept by the net. | |
|
100
|
best_available_taxonomy_observation_detail_dim$method_description | varchar | description of how the observation was taken | |
|
100
|
sampling_start_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 | |
|
100
|
operation_dim$vessel_id | int2 | field database vessel id number | |
|
100
|
actual_station_design_dim$station_design_type | varchar | type of design underlying the survey station set: Transect or Grid to date | |
|
100
|
target_station_design_dim$min_depth_whid | int4 | minimum depth warehouse identifier | |
|
100
|
target_station_design_dim$lower_right_longitude_whid | int4 | lower right longitude warehouse identifier for a design type of grid | |
|
100
|
operation_dim$return_date_whid | int8 | date reference that vessel returned for the defined leg or trip | |
|
100
|
field_identified_taxonomy_dim$suborder_42 | varchar | suborder name | |
|
100
|
field_identified_taxonomy_dim$pacfin_nom_spid | varchar | PacFIN nominal species identifier | |
|
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
|
sampling_start_time_dim$hour | int2 | standard representation of the hour | |
|
100
|
year | int2 | operation year | |
|
100
|
actual_station_design_dim$stn_invalid_for_trawl_date_whid | int8 | station design invalidation date warehouse identifier | |
|
100
|
statistical_partition_dim$statistical_partition_type | varchar | Defines the partition type | |
|
100
|
operation_dim$operation_start_date_whid | int8 | start date reference for the operation | |
|
100
|
longitude_dd | numeric | numeric representation of longitude in decimal degrees | |
|
100
|
field_identified_taxonomy_dim$genus_70 | varchar | genus name | |
|
100
|
station_code | varchar | unique identifier for a station definition | |
|
100
|
station_ul_lon_dd | numeric | high precision value of upper left longitude of design type grid measured in decimal degrees | |
|
100
|
sampling_start_time_whid | int8 | warehouse identifier for the sampling start time | |
|
100
|
actual_station_design_dim$lower_left_latitude_whid | int4 | lower left latitude warehouse identifier for a design type of grid | |
|
100
|
trawl_id | int8 | identifier for a sampling operation |
Attribute Details
vessel
CC ID: 376558
| 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 |
target_station_design_dim$station_design_name
CC ID: 376559
| 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$structure_source
CC ID: 376560
| 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 |
min_depth_m
CC ID: 376561
| 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 |
actual_station_design_dim$min_depth_whid
CC ID: 376562
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
minimum depth warehouse identifier |
net_touchdown_time
CC ID: 376563
| Data Storage Type: | time |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
military time representation of the time |
species_category
CC ID: 376564
| 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 |
year_stn_invalid
CC ID: 376565
| 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 |
best_available_taxonomy_dim$subfamily_52
CC ID: 376566
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subfamily name |
sampling_end_time_dim$period
CC ID: 376567
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
period of time |
| Allowed Values: | AM, PM |
actual_station_design_dim$centroid_id
CC ID: 376568
| 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. |
field_identified_taxonomy_dim$norpac_species_id
CC ID: 376569
| 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$subphylum_22
CC ID: 376570
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subphylum name |
actual_station_design_dim$station_code
CC ID: 376571
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
unique identifier for a station definition |
catch_id
CC ID: 376572
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
unique(legacy) identifier for the catch from a haul, sorted to taxonomic group or debris type. |
best_available_taxonomy_dim$itis_taxonomic_serial_no
CC ID: 376573
| 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 |
field_identified_taxonomy_dim$species_80
CC ID: 376574
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
species name |
field_identified_taxonomy_dim$subfamily_52
CC ID: 376575
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subfamily name |
haul_latitude_dim$record_type
CC ID: 376576
| 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 |
best_available_taxonomy_dim$grp_nonstandard_taxon_99
CC ID: 376577
| 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$limited_entry_permit_number
CC ID: 376578
| 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 |
field_identified_taxonomy_dim$superfamily_48
CC ID: 376579
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superfamily name |
date_dim$full_date
CC ID: 376580
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
actual_station_design_dim$station_invalid_survey_year
CC ID: 376581
| 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 |
actual_station_design_dim$lower_left_longitude_whid
CC ID: 376582
| 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 |
total_catch_wt_observation_detail_whid
CC ID: 376583
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier to total catch weight observation details |
target_station_design_dim$transect_station_longitude_whid
CC ID: 376584
| 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$superfamily_48
CC ID: 376585
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superfamily name |
field_identified_taxonomy_dim$superclass_28
CC ID: 376586
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superclass name |
haul_latitude_dim$latitude_in_degree_minute_second
CC ID: 376587
| 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 |
actual_station_design_dim$station_grid_dd
CC ID: 376588
| 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 |
field_identified_taxonomy_dim$infraclass_34
CC ID: 376589
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
infraclass name |
best_available_taxonomy_dim$acoustics_species_id
CC ID: 376590
| 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 |
most_recent_taxon_update
CC ID: 376591
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
operation_dim$scientist_3_person_whid
CC ID: 376592
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the third scientist |
target_station_design_dim$lower_left_latitude_whid
CC ID: 376593
| 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 |
actual_station_design_dim$area_hectares
CC ID: 376594
| 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 |
haul_longitude_whid
CC ID: 376595
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for haul longitude |
best_available_taxonomy_dim$worms_aphiaid
CC ID: 376596
| 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 |
target_station_design_dim$max_depth_whid
CC ID: 376597
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
maximum depth warehouse identifier |
best_available_taxonomy_observation_detail_dim$record_type
CC ID: 376598
| 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$order_40
CC ID: 376599
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
order name |
most_recent_taxonomy_update_date_dim$record_type
CC ID: 376600
| 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 |
haul_longitude_dim$longitude_second_units
CC ID: 376601
| 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 |
actual_station_design_dim$min_latitude_whid
CC ID: 376602
| 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 |
pass
CC ID: 376603
| 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 |
actual_station_design_dim$min_depth_m
CC ID: 376604
| 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 |
station_ul_lat_dd
CC ID: 376605
| 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 |
total_catch_numbers
CC ID: 376606
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numbers expansion for a taxonomic group within a haul. |
max_depth_m
CC ID: 376607
| 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 |
operation_dim$operation_start_time_whid
CC ID: 376608
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
start time reference for the operation |
best_available_taxonomy_dim$family_50
CC ID: 376609
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
family name |
field_identified_taxonomy_dim$itis_taxonomic_serial_no
CC ID: 376610
| 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 |
program
CC ID: 376611
| 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 |
best_available_taxonomy_dim$record_type
CC ID: 376612
| 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 |
operation_dim$captain_person_whid
CC ID: 376613
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the vessel captain |
total_catch_wt_observation_detail_dim$source_primary
CC ID: 376614
| 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 |
total_catch_wt_observation_detail_dim$means_of_calculation
CC ID: 376615
| 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 |
actual_station_design_dim$upper_left_latitude_whid
CC ID: 376616
| 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 |
target_station_design_dim$stn_invalid_for_trawl_date_whid
CC ID: 376617
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
station design invalidation date warehouse identifier |
mean_seafloor_dep_boundary
CC ID: 376618
| 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 |
field_identified_taxonomy_dim$infraorder_44
CC ID: 376619
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
infraorder name |
operation_dim$fpc_person_whid
CC ID: 376620
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the FPC |
best_available_taxonomy_dim$order_40
CC ID: 376621
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
order name |
haul_latitude_dim$latitude_second_units
CC ID: 376622
| 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 |
target_station_design_dim$max_latitude_dd
CC ID: 376623
| 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 |
actual_station_design_dim$upper_left_latitude_dd
CC ID: 376624
| 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 |
sampling_start_time_dim$military_hour
CC ID: 376625
| 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 |
actual_station_design_dim$station_design_name
CC ID: 376626
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of the design for a collection of stations |
pacfin_spid
CC ID: 376627
| 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 |
leg
CC ID: 376628
| 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 |
actual_station_design_dim$lower_left_longitude_dd
CC ID: 376629
| 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 |
actual_station_design_dim$record_type
CC ID: 376630
| 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$active_polygon_dd
CC ID: 376631
| 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_type
CC ID: 376632
| 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] |
subsample_count
CC ID: 376633
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
count of the subsample used for numbers expansion. This is usually either the counted fraction or the subsample that is measured for fish length. |
best_available_taxonomy_dim$observer_species_id
CC ID: 376634
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by the observer program |
reason_stn_invalid
CC ID: 376635
| 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 |
actual_station_design_dim$transect_latitude_dd
CC ID: 376636
| 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 |
operation_dim$ifq_account_number
CC ID: 376637
| 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 |
field_identified_taxonomy_dim$hookandline_species_id
CC ID: 376638
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by hook and line |
target_station_design_dim$upper_right_longitude_whid
CC ID: 376639
| 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$min_latitude_dd
CC ID: 376640
| 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 |
station_ll_lat_dd
CC ID: 376641
| 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 |
most_recent_taxonomy_update_date_dim$month_of_year
CC ID: 376642
| 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$upper_right_latitude_whid
CC ID: 376643
| 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 |
operation_dim$operation_end_date_whid
CC ID: 376644
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
end date reference for the operation |
sampling_start_time_dim$second
CC ID: 376645
| 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 |
field_identified_taxonomy_dim$grp_reg_depth_category
CC ID: 376646
| 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 |
best_available_taxonomy_dim$superclass_28
CC ID: 376647
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superclass name |
total_catch_wt_observation_detail_dim$record_type
CC ID: 376648
| 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 |
common_name
CC ID: 376649
| 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$subspecies_82
CC ID: 376650
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subspecies name |
sampling_end_time_whid
CC ID: 376651
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for the sampling end time |
actual_station_design_dim$transect_station_longitude_dd
CC ID: 376652
| 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 |
operation_dim$scientist_4_person_whid
CC ID: 376653
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the fourth scientist |
best_available_taxonomy_dim$abbreviated_name
CC ID: 376654
| 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 |
tow_end_timestamp
CC ID: 376655
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
operation end date timestamp |
target_station_design_dim$area_hectares
CC ID: 376656
| 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 |
target_station_design_dim$mean_depth_m
CC ID: 376657
| 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 |
most_recent_taxonomy_update_date_dim$month_name
CC ID: 376658
| 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 |
actual_station_design_dim$lower_right_longitude_dd
CC ID: 376659
| 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 |
tow_start_timestamp
CC ID: 376660
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
operation start date timestamp |
best_available_taxonomy_dim$superorder_38
CC ID: 376661
| 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: 376662
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
kingdom name |
field_identified_taxonomy_dim$structure_source
CC ID: 376663
| 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 |
station_lr_lat_dd
CC ID: 376664
| 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$hookandline_species_id
CC ID: 376665
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by hook and line |
operation_dim$trip_id
CC ID: 376666
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
trip identifier number |
field_identified_taxonomy_dim$family_50
CC ID: 376667
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
family name |
species_subcategory
CC ID: 376668
| 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 |
actual_station_design_dim$upper_right_latitude_dd
CC ID: 376669
| 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 |
field_identified_taxonomy_dim$grp_nonstandard_taxon_99
CC ID: 376670
| 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$coast_guard_number
CC ID: 376671
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Coast Guard documentation number of vessel |
date_dim$month_name
CC ID: 376672
| 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$record_type
CC ID: 376673
| 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 |
target_station_design_dim$lower_left_longitude_whid
CC ID: 376674
| 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 |
operation_dim$operation_end_time_whid
CC ID: 376675
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
end time reference for the operation |
actual_station_design_dim$upper_right_longitude_whid
CC ID: 376676
| 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$transect_station_longitude_whid
CC ID: 376677
| 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$max_latitude_dd
CC ID: 376678
| 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$subspecies_82
CC ID: 376679
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subspecies name |
target_station_design_dim$mean_depth_whid
CC ID: 376680
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
mean depth warehouse identifier |
field_identified_taxonomy_dim$abbreviated_name
CC ID: 376681
| 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 |
sampling_end_time_dim$military_hour
CC ID: 376682
| 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 |
sampling_start_time_dim$period
CC ID: 376683
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
period of time |
| Allowed Values: | AM, PM |
total_catch_wt_kg
CC ID: 376684
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
total catch weight in kilograms is ordinarily the weight of a taxonomic group within a haul. It is usually the sum of all baskets weights collected for a taxonomic group within a haul, but may be derived as a linear expansion based on a weighed, sorted subsample pulled randomly from the weighed unsorted total within a haul. |
best_available_taxonomy_dim$phylum_20
CC ID: 376685
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
phylum name |
best_available_taxonomy_dim$suborder_42
CC ID: 376686
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
suborder name |
net_liftoff_time
CC ID: 376687
| Data Storage Type: | time |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
military time representation of the time |
sampling_end_hhmmss
CC ID: 376688
| 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$day_of_month
CC ID: 376689
| 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 |
partition
CC ID: 376690
| 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 |
best_available_taxonomy_dim$tribe_60
CC ID: 376691
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
tribe name |
actual_station_design_dim$mean_depth_whid
CC ID: 376692
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
mean depth warehouse identifier |
sampling_start_time_dim$minute
CC ID: 376693
| 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 |
target_station_design_dim$upper_left_longitude_whid
CC ID: 376694
| 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 |
field_identified_taxonomy_dim$worms_aphiaid
CC ID: 376695
| 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 |
haul_longitude_dim$longitude_in_degree_minute_second
CC ID: 376696
| 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" |
station_ur_lon_dd
CC ID: 376697
| 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 |
statistical_partition_dim$record_type
CC ID: 376698
| 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 |
midtow_lat_named_parallel
CC ID: 376699
| 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 |
centroid_id
CC ID: 376700
| 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. |
most_recent_taxonomy_update_date_dim$yyyymmdd
CC ID: 376701
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
field_identified_taxonomy_dim$subclass_32
CC ID: 376702
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subclass name |
target_station_design_dim$station_grid_dd
CC ID: 376703
| 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 |
target_station_design_dim$transect_latitude_dd
CC ID: 376704
| 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 |
target_station_design_whid
CC ID: 376705
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for target station design |
field_identified_taxonomy_dim$common_name
CC ID: 376706
| 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 |
field_identified_taxonomy_dim$phylum_20
CC ID: 376707
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
phylum name |
actual_station_design_dim$variance_depth_m2
CC ID: 376708
| 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 |
haul_latitude_dim$latitude_minute_units
CC ID: 376709
| 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 |
operation_dim_whid
CC ID: 376710
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for operation |
field_identified_taxonomy_dim$species_category
CC ID: 376711
| 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 |
best_available_taxonomy_observation_detail_dim$measurement_procurement
CC ID: 376712
| 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 |
total_catch_wt_observation_detail_dim$method_description
CC ID: 376713
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 500 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
description of how the observation was taken |
depth_ftm
CC ID: 376714
| 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 |
best_available_taxonomy_dim$class_30
CC ID: 376715
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
class name |
actual_station_design_dim$lower_left_latitude_dd
CC ID: 376716
| 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 |
performance
CC ID: 376717
| 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] |
date_dim$month_abbrev
CC ID: 376718
| 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 |
station_ll_lon_dd
CC ID: 376719
| 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 |
seafloor_depth_whid
CC ID: 376720
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for seafloor depth |
scientific_name
CC ID: 376721
| 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 |
field_identified_taxonomy_dim$scientific_name_taxonomic_level
CC ID: 376722
| 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_dim$norpac_species_id
CC ID: 376723
| 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 |
target_station_design_dim$station_design_type
CC ID: 376724
| 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 |
operation_dim$departure_port_whid
CC ID: 376725
| 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$latitude_degree_units
CC ID: 376726
| 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 |
actual_station_design_dim$lower_right_latitude_dd
CC ID: 376727
| 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$grp_reg_depth_category
CC ID: 376728
| 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 |
operation_dim$field_operation_seg_id
CC ID: 376729
| 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 |
haul_latitude_dim$latitude_compass_direction
CC ID: 376730
| 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 |
field_identified_taxonomy_dim$record_type
CC ID: 376731
| 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 |
station_lr_lon_dd
CC ID: 376732
| 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 |
date_dim$day_of_month
CC ID: 376733
| 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_longitude_dd
CC ID: 376734
| 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 |
cpue_kg_per_ha_der
CC ID: 376735
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 12 |
| Status: | Active |
| Description: |
derivation of catch per unit effort in weight (kilograms) per hectare ordinarily estimated as the expanded haul catch weight divided by the area swept by the net. |
| Unit of Measure: | kg/ha |
field_identified_taxonomy_dim$species_sub_category
CC ID: 376736
| 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 |
field_note
CC ID: 376737
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 1000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
notes made in the field about the catch |
operation_dim$scientist_2_person_whid
CC ID: 376738
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the second scientist |
actual_station_design_dim$max_depth_whid
CC ID: 376739
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
maximum depth warehouse identifier |
most_recent_taxonomy_update_date_dim$month_abbrev
CC ID: 376740
| 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 |
target_station_design_dim$max_latitude_whid
CC ID: 376741
| 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 |
haul_longitude_dim$longitude_minute_units
CC ID: 376742
| 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 |
date_dim$year
CC ID: 376743
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
operation_dim$state_registration_number
CC ID: 376744
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
state registration number for the vessel |
best_available_taxonomy_dim$genus_70
CC ID: 376745
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
genus name |
total_catch_wt_observation_detail_dim$observation_type
CC ID: 376746
| 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 |
actual_station_design_dim$transect_latitude_whid
CC ID: 376747
| 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 |
sampling_end_time_dim$hour
CC ID: 376748
| 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 |
target_station_design_dim$lower_right_latitude_whid
CC ID: 376749
| 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 |
field_identified_taxonomy_dim$pacfin_spid
CC ID: 376750
| 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 |
latitude_dd
CC ID: 376751
| 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 |
taxon_rank
CC ID: 376752
| 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 |
haul_longitude_dim$record_type
CC ID: 376753
| 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 |
actual_station_design_dim$active_polygon_dd
CC ID: 376754
| 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 |
actual_station_design_dim$reason_station_invalid
CC ID: 376755
| 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 |
target_station_design_dim$min_latitude_dd
CC ID: 376756
| 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 |
field_identified_taxonomy_dim$tribe_60
CC ID: 376757
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
tribe name |
field_identified_taxonomy_dim$observer_species_id
CC ID: 376758
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by the observer program |
sampling_end_time_dim$record_type
CC ID: 376759
| 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 |
target_station_design_dim$transect_station_longitude_dd
CC ID: 376760
| 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 |
most_recent_taxonomy_update_date_dim$year
CC ID: 376761
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
target_station_design_dim$upper_left_latitude_whid
CC ID: 376762
| 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 |
field_identified_taxonomy_dim$scientific_name
CC ID: 376763
| 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$mean_depth_m
CC ID: 376764
| 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 |
actual_station_design_dim$upper_left_longitude_whid
CC ID: 376765
| 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 |
field_identified_taxonomy_dim$class_30
CC ID: 376766
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
class name |
statistical_partition_whid
CC ID: 376767
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for statistical partition |
best_available_taxonomy_dim$infraclass_34
CC ID: 376768
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
infraclass name |
best_available_taxonomy_dim$pacfin_nom_spid
CC ID: 376769
| 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 |
best_available_taxonomy_dim$subphylum_22
CC ID: 376770
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subphylum name |
actual_station_design_dim$max_depth_m
CC ID: 376771
| 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 |
best_available_taxonomy_observation_detail_dim$means_of_calculation
CC ID: 376772
| 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 |
sampling_end_time_dim$minute
CC ID: 376773
| 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: 376774
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
best_available_taxonomy_whid
CC ID: 376775
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier to best available taxonomy |
haul_longitude_dim$longitude_compass_direction
CC ID: 376776
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
longitude compass direction |
| Allowed Values: | E, W |
project
CC ID: 376777
| 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 |
best_available_taxonomy_dim$trawl_survey_species_id
CC ID: 376778
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by the trawl survey |
total_catch_wt_observation_detail_dim$measurement_procurement
CC ID: 376779
| 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 |
station_ur_lat_dd
CC ID: 376780
| 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 |
target_station_design_dim$transect_latitude_whid
CC ID: 376781
| 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 |
best_available_taxonomy_dim$infraorder_44
CC ID: 376782
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
infraorder name |
field_identified_taxonomy_dim$superorder_38
CC ID: 376783
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
superorder name |
actual_station_design_dim$lower_right_latitude_whid
CC ID: 376784
| 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$observer_program
CC ID: 376785
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
description of the observer program |
actual_station_design_whid
CC ID: 376786
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for station design |
tow
CC ID: 376787
| 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$lower_right_longitude_whid
CC ID: 376788
| 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 |
date_whid
CC ID: 376789
| 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: 376790
| 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 |
subsample_wt_kg
CC ID: 376791
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
weight in kilograms of the subsample used for numbers expansion. This is usually either the counted fraction or the subsample that is measured for fish length. |
| Unit of Measure: | kg |
operation_dim$return_port_whid
CC ID: 376792
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
port reference for return port |
field_identified_taxonomy_whid
CC ID: 376793
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier to field identified taxonomy |
date_dim$record_type
CC ID: 376794
| 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_taxonomy_update_date_whid
CC ID: 376795
| 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 |
best_available_taxonomy_observation_detail_dim$observation_type
CC ID: 376796
| 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 |
best_available_taxonomy_dim$species_80
CC ID: 376797
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
species name |
taxon_source
CC ID: 376798
| 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 |
date_dim$month_of_year
CC ID: 376799
| 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 |
field_identified_taxonomy_dim$kingdom_10
CC ID: 376800
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
kingdom name |
sampling_end_time_dim$second
CC ID: 376801
| 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 |
haul_latitude_whid
CC ID: 376802
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for haul latitude |
operation_dim$departure_date_whid
CC ID: 376803
| 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 |
actual_station_design_dim$max_latitude_whid
CC ID: 376804
| 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 |
sampling_start_time_dim$record_type
CC ID: 376805
| 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 |
target_station_design_dim$variance_depth_m2
CC ID: 376806
| 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 |
field_identified_taxonomy_dim$acoustics_species_id
CC ID: 376807
| 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$upper_right_longitude_dd
CC ID: 376808
| 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 |
depth_m
CC ID: 376809
| 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 |
operation_dim$scientist_1_person_whid
CC ID: 376810
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the first scientist |
target_station_design_dim$upper_right_latitude_whid
CC ID: 376811
| 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 |
best_available_taxonomy_dim$subclass_32
CC ID: 376812
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
subclass name |
haul_longitude_dim$longitude_degree_units
CC ID: 376813
| 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 |
target_station_design_dim$record_type
CC ID: 376814
| 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 |
field_identified_taxonomy_dim$trawl_survey_species_id
CC ID: 376815
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
species identifier used by the trawl survey |
cpue_numbers_per_ha_der
CC ID: 376816
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 12 |
| Status: | Active |
| Description: |
derivation of catch per unit effort in numbers of individuals per hectare ordinarily estimated as the expanded haul catch in numbers divided by the area swept by the net. |
best_available_taxonomy_observation_detail_dim$method_description
CC ID: 376817
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 500 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
description of how the observation was taken |
sampling_start_hhmmss
CC ID: 376818
| 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 |
operation_dim$vessel_id
CC ID: 376819
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
field database vessel id number |
actual_station_design_dim$station_design_type
CC ID: 376820
| 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 |
target_station_design_dim$min_depth_whid
CC ID: 376821
| 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$lower_right_longitude_whid
CC ID: 376822
| 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 |
operation_dim$return_date_whid
CC ID: 376823
| 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 |
field_identified_taxonomy_dim$suborder_42
CC ID: 376824
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
suborder name |
field_identified_taxonomy_dim$pacfin_nom_spid
CC ID: 376825
| 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 |
best_available_taxonomy_observation_detail_whid
CC ID: 376826
| 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: 376827
| 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 |
sampling_start_time_dim$hour
CC ID: 376828
| 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 |
year
CC ID: 376829
| 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+ |
actual_station_design_dim$stn_invalid_for_trawl_date_whid
CC ID: 376830
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
station design invalidation date warehouse identifier |
statistical_partition_dim$statistical_partition_type
CC ID: 376831
| 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 |
operation_dim$operation_start_date_whid
CC ID: 376832
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
start date reference for the operation |
longitude_dd
CC ID: 376833
| 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 |
field_identified_taxonomy_dim$genus_70
CC ID: 376834
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
genus name |
station_code
CC ID: 376835
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
unique identifier for a station definition |
station_ul_lon_dd
CC ID: 376836
| 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 |
sampling_start_time_whid
CC ID: 376837
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
warehouse identifier for the sampling start time |
actual_station_design_dim$lower_left_latitude_whid
CC ID: 376838
| 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 |
trawl_id
CC ID: 376839
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
identifier for a sampling operation |