individual_fact
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36438 | Updated: June 6, 2024 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Individuals caught and measured on the bottom trawl survey
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
actual_station_design_dim$transect_station_longitude_dd
numeric |
high precision value of transect station longitude measured in decimal degrees |
standard_survey_dim$standard_survey_weight_indicator
varchar |
identifies if the individual is part of the Standard Weight Survey |
sampling_start_time_dim$minute
int2 |
number of minutes in the hour |
best_available_taxonomy_dim$phylum_20
varchar |
phylum name |
performance
varchar |
performance of the operation |
actual_station_design_dim$upper_right_latitude_whid
int4 |
upper right latitude warehouse identifier for a design type of grid |
date_dim$record_type
varchar |
date, month, or year record or reason record is unavailable |
actual_station_design_dim$lower_left_longitude_dd
numeric |
high precision value of lower left longitude of design type grid measured in decimal degrees |
best_available_taxonomy_dim$structure_source
varchar |
Source of the taxonomic structure |
best_available_taxonomy_dim$family_50
varchar |
family name |
actual_station_design_dim$upper_right_longitude_dd
numeric |
high precision value of upper right longitude of design type grid measured in decimal degrees |
actual_station_design_dim$upper_right_longitude_whid
int4 |
upper right longitude warehouse identifier for a design type of grid |
actual_station_design_dim$lower_left_latitude_whid
int4 |
lower left latitude warehouse identifier for a design type of grid |
best_available_taxonomy_dim$record_type
varchar |
record or reason record is unavailable |
width_observation_detail_dim$method_description
varchar |
description of how the observation was taken |
station_ur_lon_dd
numeric |
high precision value of upper right longitude of design type grid measured in decimal degrees |
most_recent_taxonomy_update_date_dim$day_of_month
int2 |
numeric representation of the day in month |
most_recent_age_update_date_dim$yyyymmdd
bpchar |
text representation of year month day |
individual_tracking_id
int8 |
Individual tracking id |
ovary_id
numeric |
Ovary sample number or barcode |
target_station_design_dim$stn_invalid_for_trawl_date_whid
int8 |
station design invalidation date warehouse identifier |
standard_survey_whid
int4 |
Warehouse identifier for standard survey |
operation_dim$scientist_1_person_whid
int4 |
person reference for the first scientist |
most_recent_maturity_update_date_whid
int8 |
Warehouse identifier for most recent maturity update date |
net_liftoff_time
time |
military time representation of the time |
actual_station_design_dim$variance_depth_m2
numeric |
high precision value of variance depth mesured in squared meters |
target_station_design_dim$variance_depth_m2
numeric |
high precision value of variance depth mesured in squared meters |
target_station_design_dim$min_depth_whid
int4 |
minimum depth warehouse identifier |
target_station_design_dim$transect_station_longitude_dd
numeric |
high precision value of transect station longitude measured in decimal degrees |
actual_station_design_dim$lower_left_longitude_whid
int4 |
lower left longitude warehouse identifier for a design type of grid |
field_identified_taxonomy_dim$itis_taxonomic_serial_no
int4 |
ITIS taxonomic identifier |
operation_dim$departure_port_whid
int4 |
port reference for the departure port |
haul_latitude_dim$record_type
varchar |
latitude record type or reason record is unavailable |
sex_whid
int2 |
Warehouse identifier to sex details |
target_station_design_whid
int4 |
warehouse identifier for target station design |
target_station_design_dim$max_latitude_whid
int4 |
maximum latitude warehouse identifier for a design type of transect |
actual_station_design_dim$upper_left_longitude_whid
int4 |
upper left longitude warehouse identifier for a design type of grid |
pass
int4 |
pass number of the survey |
sampling_end_time_dim$period
bpchar |
period of time |
operation_dim$scientist_3_person_whid
int4 |
person reference for the third scientist |
field_identified_taxonomy_dim$structure_source
varchar |
Source of the taxonomic structure |
width_cm
numeric |
Individual width measured in centimeters |
most_recent_taxon_update
timestamp |
full date value |
best_available_taxonomy_dim$abbreviated_name
varchar |
specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
operation_dim$operation_start_date_whid
int8 |
start date reference for the operation |
best_available_taxonomy_dim$observer_species_id
int4 |
species identifier used by the observer program |
project
varchar |
project name |
midtow_lat_named_parallel
varchar |
name of parallel, boundary, or commonly used geograpical location |
field_identified_taxonomy_dim$species_category
varchar |
upper-level taxonomic ranking |
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. |
sampling_start_time_dim$record_type
varchar |
time record or reason record is unavailable |
operation_dim$field_operation_seg_id
int8 |
operation segment id reference to the field operational segment table |
sampling_end_time_whid
int4 |
warehouse identifier for the sampling end time |
standard_survey_dim$record_type
varchar |
standard survey record or reason record is unavailable |
depth_m
numeric |
depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
target_station_design_dim$upper_right_longitude_whid
int4 |
upper right longitude warehouse identifier for a design type of grid |
target_station_design_dim$mean_depth_whid
int4 |
mean depth warehouse identifier |
stomach_id
numeric |
Stomach sample number or barcode |
target_station_design_dim$station_design_type
varchar |
type of design underlying the survey station set: Transect or Grid to date |
trawl_id
int8 |
identifier for a sampling operation |
station_ur_lat_dd
numeric |
high precision value of upper right latitude of design type grid measured in decimal degrees |
width_type
varchar |
describes how the measurement was calculated |
best_available_taxonomy_whid
int4 |
warehouse identifier to best available taxonomy |
statistical_partition_dim$record_type
varchar |
statistical partition record or reason record is unavailable |
species_category
varchar |
upper-level taxonomic ranking |
field_identified_taxonomy_dim$hookandline_species_id
int4 |
species identifier used by hook and line |
station_ll_lat_dd
numeric |
high precision value of lower left latitude of design type grid measured in decimal degrees |
best_available_taxonomy_dim$subphylum_22
varchar |
subphylum name |
field_identified_taxonomy_dim$record_type
varchar |
record or reason record is unavailable |
field_identified_taxonomy_dim$scientific_name_taxonomic_level
varchar |
name of the lowest taxonomic level used to define scientific name |
longitude_dd
numeric |
numeric representation of longitude in decimal degrees |
haul_longitude_dim$longitude_minute_units
int2 |
numeric representation of longitude that makes up the minute unit only |
program
varchar |
type of fram program |
width_observation_detail_dim$observation_type
varchar |
the type of observation |
field_identified_taxonomy_dim$superorder_38
varchar |
superorder name |
operation_dim$operation_end_time_whid
int8 |
end time reference for the operation |
target_station_design_dim$min_latitude_dd
numeric |
high precision value of minimum latitude measured in decimal degrees |
most_recent_maturity_update_date_dim$yyyymmdd
bpchar |
text representation of year month day |
most_recent_maturity_update_date_dim$month_name
varchar |
text representation of month |
operation_dim$operation_start_time_whid
int8 |
start time reference for the operation |
field_identified_taxonomy_dim$infraorder_44
varchar |
infraorder name |
standard_survey_dim$standard_survey_length_or_width_indicator
varchar |
identifies if the individual is part of the Standard Length Survey |
length_timestamp
timestamp |
Timestamp at the point the length is taken on an individual |
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 |
best_available_taxonomy_dim$pacfin_nom_spid
varchar |
PacFIN nominal species identifier |
actual_station_design_dim$station_design_type
varchar |
type of design underlying the survey station set: Transect or Grid to date |
field_identified_taxonomy_dim$worms_aphiaid
int4 |
WoRMS taxonomic identifier |
max_depth_m
numeric |
high precision value of maximum depth measured in meters |
field_identified_taxonomy_whid
int4 |
warehouse identifier to field identified taxonomy |
most_recent_age_update_date_dim$month_of_year
int2 |
numeric representation of month of year |
length_type
varchar |
describes how the measurement was calculated |
station_lr_lon_dd
numeric |
high precision value of lower right longitude of design type grid measured in decimal degrees |
haul_longitude_whid
int4 |
warehouse identifier for haul longitude |
date_dim$year
int4 |
numeric representation of year |
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. |
actual_station_design_whid
int4 |
warehouse identifier for station design |
operation_dim$coast_guard_number
varchar |
Coast Guard documentation number of vessel |
field_identified_taxonomy_dim$kingdom_10
varchar |
kingdom name |
most_recent_taxonomy_update_date_dim$record_type
varchar |
date, month, or year record or reason record is unavailable |
most_recent_age_update_date_dim$month_name
varchar |
text representation of month |
taxon_source
varchar |
name of primary source used to get the measurement |
field_identified_taxonomy_dim$acoustics_species_id
int4 |
Species ID used in the acoustics program |
sampling_end_time_dim$minute
int2 |
number of minutes in the hour |
date_yyyymmdd
bpchar |
text representation of year month day |
haul_latitude_dim$latitude_in_degree_minute_second
varchar |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
haul_latitude_dim$latitude_compass_direction
bpchar |
latitude compass direction |
year
int2 |
operation year |
most_recent_age_update_date_dim$record_type
varchar |
date, month, or year record or reason record is unavailable |
field_identified_taxonomy_dim$subfamily_52
varchar |
subfamily name |
sampling_start_time_dim$hour
int2 |
standard representation of the hour |
most_recent_maturity_update_date_dim$month_of_year
int2 |
numeric representation of month of year |
lab_maturity_detail_dim$functionally_mature_certain_indicator
varchar |
identifies the certainty of the functionally mature evaluation |
best_available_taxonomy_dim$subfamily_52
varchar |
subfamily name |
otosag_id
int4 |
Otolith barcode or sample number |
haul_latitude_dim$latitude_second_units
int2 |
numeric representation of latitude that makes up the second unit only |
date_whid
int8 |
warehouse identifier for date |
target_station_design_dim$min_latitude_whid
int4 |
minimum latitude warehouse identifier for a design type of transect |
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 |
operation_dim$departure_date_whid
int8 |
date reference that vessel departed for the defined leg or trip |
length_observation_detail_dim$observation_type
varchar |
the type of observation |
operation_dim$fpc_person_whid
int4 |
person reference for the FPC |
actual_station_design_dim$transect_latitude_whid
int4 |
latitude warehouse identifier for a design type of transect |
length_cm
numeric |
Individual length measured in centimeters |
target_station_design_dim$active_polygon_dd
polygon |
collection of vertices of the usuable area inside a station grid measured in decimal degrees |
operation_dim$operation_end_date_whid
int8 |
end date reference for the operation |
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 |
actual_station_design_dim$max_depth_whid
int4 |
maximum depth warehouse identifier |
actual_station_design_dim$min_depth_m
numeric |
high precision value of minimum depth measured in meters |
operation_dim$return_date_whid
int8 |
date reference that vessel returned for the defined leg or trip |
haul_longitude_dim$longitude_compass_direction
bpchar |
longitude compass direction |
target_station_design_dim$transect_latitude_whid
int4 |
latitude warehouse identifier for a design type of transect |
date_dim$full_date
timestamp |
full date value |
target_station_design_dim$upper_left_latitude_whid
int4 |
upper left latitude warehouse identifier for a design type of grid |
actual_station_design_dim$mean_depth_whid
int4 |
mean depth warehouse identifier |
min_depth_m
numeric |
high precision value of minimum depth measured in meters |
year_stn_invalid
int2 |
Survey year the station became invalid for trawl |
length_observation_detail_dim$record_type
varchar |
observation detail record type or reason record is unavailable |
target_station_design_dim$upper_left_longitude_whid
int4 |
upper left longitude warehouse identifier for a design type of grid |
station_code
varchar |
unique identifier for a station definition |
station_ul_lat_dd
numeric |
high precision value of upper left latitude of design type grid measured in decimal degrees |
station_ll_lon_dd
numeric |
high precision value of lower left longitude of design type grid measured in decimal degrees |
vessel
varchar |
name of the vessel used for the operation |
most_recent_taxonomy_update_date_dim$month_of_year
int2 |
numeric representation of month of year |
actual_station_design_dim$lower_left_latitude_dd
numeric |
high precision value of lower left latitude of design type grid measured in decimal degrees |
best_available_taxonomy_dim$superfamily_48
varchar |
superfamily name |
depth_ftm
numeric |
depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
actual_station_design_dim$transect_latitude_dd
numeric |
high precision value of transect latitude measured in decimal degrees |
weight_kg
numeric |
Individual weight measured in kilograms |
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 |
width_observation_detail_dim$source_primary
varchar |
name of primary source used to get the measurement |
target_station_design_dim$transect_station_longitude_whid
int4 |
longitude on transect warehouse identifier for a design type of transect |
actual_station_design_dim$station_grid_dd
polygon |
collection of vertices of grid points of a grid design measured in decimal degrees |
operation_dim$return_port_whid
int4 |
port reference for return port |
actual_station_design_dim$min_latitude_dd
numeric |
high precision value of minimum latitude measured in decimal degrees |
tow_end_timestamp
timestamp |
operation end date timestamp |
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 |
field_identified_taxonomy_dim$subphylum_22
varchar |
subphylum name |
operation_dim$captain_person_whid
int4 |
person reference for the vessel captain |
target_station_design_dim$lower_left_latitude_whid
int4 |
lower left latitude warehouse identifier for a design type of grid |
length_observation_detail_dim$method_description
varchar |
description of how the observation was taken |
best_available_taxonomy_dim$suborder_42
varchar |
suborder name |
most_recent_age_update_date_whid
int8 |
Warehouse identifier for most recent age update date |
field_identified_taxonomy_dim$phylum_20
varchar |
phylum name |
best_available_taxonomy_dim$superclass_28
varchar |
superclass name |
statistical_partition_whid
int4 |
warehouse identifier for statistical partition |
target_station_design_dim$upper_right_latitude_whid
int4 |
upper right latitude warehouse identifier for a design type of grid |
length_observation_detail_dim$measurement_procurement
varchar |
how the measurement was achieved |
length_observation_detail_whid
int4 |
Warehouse identifier to taxonomy observation detail |
field_identified_taxonomy_dim$pacfin_spid
varchar |
pacfin species id - many taxa may not have one of these |
operation_dim$ifq_account_number
varchar |
unique number assigned to user accounts in the Vessel Accounting Database |
best_available_taxonomy_dim$subspecies_82
varchar |
subspecies name |
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 |
width_observation_detail_dim$measurement_procurement
varchar |
how the measurement was achieved |
target_station_design_dim$area_hectares
numeric |
station area measured in hectares |
age_years
numeric |
Individual age measured in years |
sampling_start_hhmmss
bpchar |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
most_recent_taxonomy_update_date_dim$month_name
varchar |
text representation of month |
best_available_taxonomy_dim$hookandline_species_id
int4 |
species identifier used by hook and line |
best_available_taxonomy_observation_detail_dim$observation_type
varchar |
the type of observation |
field_identified_taxonomy_dim$genus_70
varchar |
genus name |
most_recent_taxonomy_update_date_dim$year
int4 |
numeric representation of year |
actual_station_design_dim$active_polygon_dd
polygon |
collection of vertices of the usuable area inside a station grid measured in decimal degrees |
field_identified_taxonomy_dim$abbreviated_name
varchar |
specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
operation_dim$scientist_4_person_whid
int4 |
person reference for the fourth scientist |
actual_station_design_dim$lower_right_longitude_whid
int4 |
lower right longitude warehouse identifier for a design type of grid |
target_station_design_dim$transect_latitude_dd
numeric |
high precision value of transect latitude measured in decimal degrees |
mean_seafloor_dep_boundary
varchar |
depth boundry indicator identifying ifp boundary marks |
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 |
sampling_start_time_dim$second
int2 |
number of seconds in the minute |
actual_station_design_dim$station_invalid_survey_year
int2 |
Survey year the station became invalid for trawl |
sampling_start_time_whid
int4 |
warehouse identifier for the sampling start time |
target_station_design_dim$lower_right_longitude_whid
int4 |
lower right longitude warehouse identifier for a design type of grid |
haul_longitude_dim$record_type
varchar |
longitude record type or reason record is unavailable |
tissue_id
numeric |
Tissue sample number or barcode |
actual_station_design_dim$transect_station_longitude_whid
int4 |
longitude on transect warehouse identifier for a design type of transect |
best_available_taxonomy_dim$tribe_60
varchar |
tribe name |
field_note
varchar |
Note made in the field about an individual |
sex_dim$sex
varchar |
biological sex of individual |
actual_station_design_dim$station_code
varchar |
unique identifier for a station definition |
latitude_dd
numeric |
numeric representation of latitude in degrees |
actual_station_design_dim$station_design_name
varchar |
name of the design for a collection of stations |
lab_maturity_detail_dim$biologically_mature_certain_indicator
varchar |
identifies the certainty of the biological maturity |
actual_station_design_dim$lower_right_latitude_whid
int4 |
lower right latitude warehouse identifier for a design type of grid |
haul_longitude_dim$longitude_degree_units
int2 |
numeric representation of longitude that makes up the degree unit only |
best_available_taxonomy_observation_detail_dim$means_of_calculation
varchar |
describes how the measurement was calculated |
most_recent_age_update
timestamp |
full date value |
actual_station_design_dim$area_hectares
numeric |
station area measured in hectares |
taxon_rank
varchar |
name of the lowest taxonomic level used to define scientific name |
best_available_taxonomy_observation_detail_dim$record_type
varchar |
observation detail record type or reason record is unavailable |
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. |
field_identified_taxonomy_dim$observer_species_id
int4 |
species identifier used by the observer program |
operation_dim_whid
int8 |
warehouse identifier for operation |
operation_dim$scientist_2_person_whid
int4 |
person reference for the second scientist |
most_recent_taxonomy_update_date_dim$yyyymmdd
bpchar |
text representation of year month day |
best_available_taxonomy_dim$genus_70
varchar |
genus name |
net_touchdown_time
time |
military time representation of the time |
best_available_taxonomy_dim$itis_taxonomic_serial_no
int4 |
ITIS taxonomic identifier |
operation_dim$vessel_id
int2 |
field database vessel id number |
left_pectoral_fin_id
int4 |
Left pectoral fin sample number or barcode |
best_available_taxonomy_dim$worms_aphiaid
int4 |
WoRMS taxonomic identifier |
lab_maturity_detail_dim$biologically_mature_indicator
varchar |
identifies biological maturity of the individual |
most_recent_taxonomy_update_date_whid
int8 |
Warehouse identifier for most recent taxonomy update date |
haul_latitude_whid
int4 |
warehouse identifier for haul latitude |
operation_dim$state_registration_number
varchar |
state registration number for the vessel |
actual_station_design_dim$upper_right_latitude_dd
numeric |
high precision value of upper right latitude of design type grid measured in decimal degrees |
date_dim$month_abbrev
bpchar |
three character representation of month in capital letters |
actual_station_design_dim$upper_left_longitude_dd
numeric |
high precision value of upper left longitude of design type grid measured in decimal degrees |
best_available_taxonomy_observation_detail_dim$method_description
varchar |
description of how the observation was taken |
width_observation_detail_whid
int4 |
Warehouse identifier to taxonomy observation detail |
haul_latitude_dim$latitude_degree_units
int2 |
numeric representation of latitude that makes up the degree unit only |
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 |
actual_station_design_dim$mean_depth_m
numeric |
high precision value of mean depth measured in meters |
field_identified_taxonomy_dim$pacfin_nom_spid
varchar |
PacFIN nominal species identifier |
field_identified_taxonomy_dim$superclass_28
varchar |
superclass name |
actual_station_design_dim$max_depth_m
numeric |
high precision value of maximum depth measured in meters |
field_identified_taxonomy_dim$superfamily_48
varchar |
superfamily name |
most_recent_age_update_date_dim$month_abbrev
bpchar |
three character representation of month in capital letters |
tow_start_timestamp
timestamp |
operation start date timestamp |
actual_station_design_dim$reason_station_invalid
varchar |
reason station was invalidated, multiple reasons are comma separated |
standard_survey_dim$standard_survey_maturity_indicator
varchar |
identifies if the individual is part of the Standard Maturity Survey |
station_lr_lat_dd
numeric |
high precision value of lower right latitude of design type grid measured in decimal degrees |
best_available_taxonomy_dim$infraclass_34
varchar |
infraclass name |
length_observation_detail_dim$source_primary
varchar |
name of primary source used to get the measurement |
target_station_design_dim$max_latitude_dd
numeric |
high precision value of maximum latitude measured in decimal degrees |
operation_dim$trip_id
int4 |
trip identifier number |
sampling_start_time_dim$period
bpchar |
period of time |
operation_dim$record_type
varchar |
operation record or reason record is unavailable |
sampling_end_hhmmss
bpchar |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
date_dim$month_name
varchar |
text representation of month |
target_station_design_dim$lower_left_longitude_whid
int4 |
lower left longitude warehouse identifier for a design type of grid |
target_station_design_dim$station_grid_dd
polygon |
collection of vertices of grid points of a grid design measured in decimal degrees |
most_recent_age_update_date_dim$day_of_month
int2 |
numeric representation of the day in month |
tow
int2 |
operation number of the survey |
actual_station_design_dim$stn_invalid_for_trawl_date_whid
int8 |
station design invalidation date warehouse identifier |
standard_survey_dim$standard_survey_age_indicator
varchar |
identifies if the individual is part of the Standard Age Survey |
width_observation_detail_dim$record_type
varchar |
observation detail record type or reason record is unavailable |
field_identified_taxonomy_dim$infraclass_34
varchar |
infraclass name |
most_recent_maturity_update_date_dim$record_type
varchar |
date, month, or year record or reason record is unavailable |
field_identified_taxonomy_dim$subspecies_82
varchar |
subspecies name |
best_available_taxonomy_dim$acoustics_species_id
int4 |
Species ID used in the acoustics program |
actual_station_design_dim$max_latitude_whid
int4 |
maximum latitude warehouse identifier for a design type of transect |
most_recent_age_update_date_dim$year
int4 |
numeric representation of year |
species_subcategory
varchar |
mid-level taxonomic ranking |
date_dim$day_of_month
int2 |
numeric representation of the day in month |
actual_station_design_dim$upper_left_latitude_dd
numeric |
high precision value of upper left latitude of design type grid measured in decimal degrees |
field_identified_taxonomy_dim$tribe_60
varchar |
tribe name |
leg
int2 |
leg number of the survey |
field_identified_taxonomy_dim$subclass_32
varchar |
subclass name |
best_available_taxonomy_observation_detail_whid
int4 |
warehouse identifier to best available taxonomy observation detail |
seafloor_depth_dim$record_type
varchar |
depth record or reason record is unavailable |
station_ul_lon_dd
numeric |
high precision value of upper left longitude of design type grid measured in decimal degrees |
most_recent_taxonomy_update_date_dim$month_abbrev
bpchar |
three character representation of month in capital letters |
field_identified_taxonomy_dim$class_30
varchar |
class name |
sampling_end_time_dim$hour
int2 |
standard representation of the hour |
actual_station_design_dim$upper_left_latitude_whid
int4 |
upper left latitude warehouse identifier for a design type of grid |
sampling_start_time_dim$military_hour
int2 |
military representation of the hour |
haul_longitude_dim$longitude_in_degree_minute_second
varchar |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
reason_stn_invalid
varchar |
reason station was invalidated, multiple reasons are comma separated |
sampling_end_time_dim$second
int2 |
number of seconds in the minute |
best_available_taxonomy_dim$superorder_38
varchar |
superorder name |
best_available_taxonomy_dim$kingdom_10
varchar |
kingdom name |
field_identified_taxonomy_dim$trawl_survey_species_id
int4 |
species identifier used by the trawl survey |
actual_station_design_dim$lower_right_latitude_dd
numeric |
high precision value of lower right latitude of design type grid measured in decimal degrees |
partition
varchar |
Refines the partition type |
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. |
field_identified_taxonomy_dim$suborder_42
varchar |
suborder name |
field_identified_taxonomy_dim$family_50
varchar |
family name |
sampling_end_time_dim$record_type
varchar |
time record or reason record is unavailable |
actual_station_design_dim$lower_right_longitude_dd
numeric |
high precision value of lower right longitude of design type grid measured in decimal degrees |
best_available_taxonomy_dim$class_30
varchar |
class name |
seafloor_depth_whid
int4 |
warehouse identifier for seafloor depth |
target_station_design_dim$mean_depth_m
numeric |
high precision value of mean depth measured in meters |
field_identified_taxonomy_dim$species_sub_category
varchar |
mid-level taxonomic ranking |
operation_dim$observer_program
varchar |
description of the observer program |
lab_maturity_detail_dim$functionally_mature_indicator
varchar |
identifies the functional maturity of the individual |
pacfin_spid
varchar |
pacfin species id - many taxa may not have one of these |
best_available_taxonomy_dim$infraorder_44
varchar |
infraorder name |
most_recent_maturity_update_date_dim$day_of_month
int2 |
numeric representation of the day in month |
statistical_partition_dim$statistical_partition_type
varchar |
Defines the partition type |
target_station_design_dim$record_type
varchar |
station design record or reason record is unavailable |
best_available_taxonomy_dim$order_40
varchar |
order name |
actual_station_design_dim$min_depth_whid
int4 |
minimum depth warehouse identifier |
actual_station_design_dim$max_latitude_dd
numeric |
high precision value of maximum latitude measured in decimal degrees |
field_identified_taxonomy_dim$order_40
varchar |
order name |
field_identified_taxonomy_dim$species_80
varchar |
species name |
sampling_end_time_dim$military_hour
int2 |
military representation of the hour |
lab_maturity_detail_dim$record_type
varchar |
lab maturity detail record or reason record is unavailable |
best_available_taxonomy_dim$species_80
varchar |
species name |
best_available_taxonomy_observation_detail_dim$measurement_procurement
varchar |
how the measurement was achieved |
target_station_design_dim$lower_right_latitude_whid
int4 |
lower right latitude warehouse identifier for a design type of grid |
operation_dim$operation_type
varchar |
type of operation |
haul_latitude_dim$latitude_minute_units
int2 |
numeric representation of latitude that makes up the minute unit only |
actual_station_design_dim$record_type
varchar |
station design record or reason record is unavailable |
target_station_design_dim$max_depth_whid
int4 |
maximum depth warehouse identifier |
best_available_taxonomy_dim$subclass_32
varchar |
subclass name |
haul_longitude_dim$longitude_second_units
int2 |
numeric representation of longitude that makes up the second unit only |
sex_dim$record_type
varchar |
latitude record type or reason record is unavailable |
actual_station_design_dim$min_latitude_whid
int4 |
minimum latitude warehouse identifier for a design type of transect |
date_dim$month_of_year
int2 |
numeric representation of month of year |
most_recent_maturity_update_date_dim$month_abbrev
bpchar |
three character representation of month in capital letters |
operation_dim$limited_entry_permit_number
bpchar |
federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California |
sex
bpchar |
|
target_station_design_dim$station_design_name
varchar |
name of the design for a collection of stations |
best_available_taxonomy_dim$trawl_survey_species_id
int4 |
species identifier used by the trawl survey |
lab_maturity_detail_whid
int2 |
Warehouse identifier for lab maturity details |
most_recent_maturity_update_date_dim$full_date
timestamp |
full date value |
most_recent_maturity_update_date_dim$year
int4 |
numeric representation of year |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NWFSC) for inquiries on this record.
Item Identification
Title: | individual_fact |
---|
Entity Information
Entity Type: | Data Table |
---|---|
Description: |
Individuals caught and measured on the bottom trawl survey |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
actual_station_design_dim$transect_station_longitude_dd | numeric | high precision value of transect station longitude measured in decimal degrees | |
100
|
standard_survey_dim$standard_survey_weight_indicator | varchar | identifies if the individual is part of the Standard Weight Survey | |
100
|
sampling_start_time_dim$minute | int2 | number of minutes in the hour | |
100
|
best_available_taxonomy_dim$phylum_20 | varchar | phylum name | |
100
|
performance | varchar | performance of the operation | |
100
|
actual_station_design_dim$upper_right_latitude_whid | int4 | upper right latitude warehouse identifier for a design type of grid | |
100
|
date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
100
|
actual_station_design_dim$lower_left_longitude_dd | numeric | high precision value of lower left longitude of design type grid measured in decimal degrees | |
100
|
best_available_taxonomy_dim$structure_source | varchar | Source of the taxonomic structure | |
100
|
best_available_taxonomy_dim$family_50 | varchar | family name | |
100
|
actual_station_design_dim$upper_right_longitude_dd | numeric | high precision value of upper right longitude of design type grid measured in decimal degrees | |
100
|
actual_station_design_dim$upper_right_longitude_whid | int4 | upper right longitude warehouse identifier for a design type of grid | |
100
|
actual_station_design_dim$lower_left_latitude_whid | int4 | lower left latitude warehouse identifier for a design type of grid | |
100
|
best_available_taxonomy_dim$record_type | varchar | record or reason record is unavailable | |
100
|
width_observation_detail_dim$method_description | varchar | description of how the observation was taken | |
100
|
station_ur_lon_dd | numeric | high precision value of upper right longitude of design type grid measured in decimal degrees | |
100
|
most_recent_taxonomy_update_date_dim$day_of_month | int2 | numeric representation of the day in month | |
100
|
most_recent_age_update_date_dim$yyyymmdd | bpchar | text representation of year month day | |
100
|
individual_tracking_id | int8 | Individual tracking id | |
100
|
ovary_id | numeric | Ovary sample number or barcode | |
100
|
target_station_design_dim$stn_invalid_for_trawl_date_whid | int8 | station design invalidation date warehouse identifier | |
100
|
standard_survey_whid | int4 | Warehouse identifier for standard survey | |
100
|
operation_dim$scientist_1_person_whid | int4 | person reference for the first scientist | |
100
|
most_recent_maturity_update_date_whid | int8 | Warehouse identifier for most recent maturity update date | |
100
|
net_liftoff_time | time | military time representation of the time | |
100
|
actual_station_design_dim$variance_depth_m2 | numeric | high precision value of variance depth mesured in squared meters | |
100
|
target_station_design_dim$variance_depth_m2 | numeric | high precision value of variance depth mesured in squared meters | |
100
|
target_station_design_dim$min_depth_whid | int4 | minimum depth warehouse identifier | |
100
|
target_station_design_dim$transect_station_longitude_dd | numeric | high precision value of transect station longitude measured in decimal degrees | |
100
|
actual_station_design_dim$lower_left_longitude_whid | int4 | lower left longitude warehouse identifier for a design type of grid | |
100
|
field_identified_taxonomy_dim$itis_taxonomic_serial_no | int4 | ITIS taxonomic identifier | |
100
|
operation_dim$departure_port_whid | int4 | port reference for the departure port | |
100
|
haul_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable | |
100
|
sex_whid | int2 | Warehouse identifier to sex details | |
100
|
target_station_design_whid | int4 | warehouse identifier for target station design | |
100
|
target_station_design_dim$max_latitude_whid | int4 | maximum latitude warehouse identifier for a design type of transect | |
100
|
actual_station_design_dim$upper_left_longitude_whid | int4 | upper left longitude warehouse identifier for a design type of grid | |
100
|
pass | int4 | pass number of the survey | |
100
|
sampling_end_time_dim$period | bpchar | period of time | |
100
|
operation_dim$scientist_3_person_whid | int4 | person reference for the third scientist | |
100
|
field_identified_taxonomy_dim$structure_source | varchar | Source of the taxonomic structure | |
100
|
width_cm | numeric | Individual width measured in centimeters | |
100
|
most_recent_taxon_update | timestamp | full date value | |
100
|
best_available_taxonomy_dim$abbreviated_name | varchar | specialized common name, generally for a well-known species of fish such as ATF, LST, SST | |
100
|
operation_dim$operation_start_date_whid | int8 | start date reference for the operation | |
100
|
best_available_taxonomy_dim$observer_species_id | int4 | species identifier used by the observer program | |
100
|
project | varchar | project name | |
100
|
midtow_lat_named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location | |
100
|
field_identified_taxonomy_dim$species_category | varchar | upper-level taxonomic ranking | |
100
|
centroid_id | numeric | eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons. | |
100
|
sampling_start_time_dim$record_type | varchar | time record or reason record is unavailable | |
100
|
operation_dim$field_operation_seg_id | int8 | operation segment id reference to the field operational segment table | |
100
|
sampling_end_time_whid | int4 | warehouse identifier for the sampling end time | |
100
|
standard_survey_dim$record_type | varchar | standard survey record or reason record is unavailable | |
100
|
depth_m | numeric | depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) | |
100
|
target_station_design_dim$upper_right_longitude_whid | int4 | upper right longitude warehouse identifier for a design type of grid | |
100
|
target_station_design_dim$mean_depth_whid | int4 | mean depth warehouse identifier | |
100
|
stomach_id | numeric | Stomach sample number or barcode | |
100
|
target_station_design_dim$station_design_type | varchar | type of design underlying the survey station set: Transect or Grid to date | |
100
|
trawl_id | int8 | identifier for a sampling operation | |
100
|
station_ur_lat_dd | numeric | high precision value of upper right latitude of design type grid measured in decimal degrees | |
100
|
width_type | varchar | describes how the measurement was calculated | |
100
|
best_available_taxonomy_whid | int4 | warehouse identifier to best available taxonomy | |
100
|
statistical_partition_dim$record_type | varchar | statistical partition record or reason record is unavailable | |
100
|
species_category | varchar | upper-level taxonomic ranking | |
100
|
field_identified_taxonomy_dim$hookandline_species_id | int4 | species identifier used by hook and line | |
100
|
station_ll_lat_dd | numeric | high precision value of lower left latitude of design type grid measured in decimal degrees | |
100
|
best_available_taxonomy_dim$subphylum_22 | varchar | subphylum name | |
100
|
field_identified_taxonomy_dim$record_type | varchar | record or reason record is unavailable | |
100
|
field_identified_taxonomy_dim$scientific_name_taxonomic_level | varchar | name of the lowest taxonomic level used to define scientific name | |
100
|
longitude_dd | numeric | numeric representation of longitude in decimal degrees | |
100
|
haul_longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only | |
100
|
program | varchar | type of fram program | |
100
|
width_observation_detail_dim$observation_type | varchar | the type of observation | |
100
|
field_identified_taxonomy_dim$superorder_38 | varchar | superorder name | |
100
|
operation_dim$operation_end_time_whid | int8 | end time reference for the operation | |
100
|
target_station_design_dim$min_latitude_dd | numeric | high precision value of minimum latitude measured in decimal degrees | |
100
|
most_recent_maturity_update_date_dim$yyyymmdd | bpchar | text representation of year month day | |
100
|
most_recent_maturity_update_date_dim$month_name | varchar | text representation of month | |
100
|
operation_dim$operation_start_time_whid | int8 | start time reference for the operation | |
100
|
field_identified_taxonomy_dim$infraorder_44 | varchar | infraorder name | |
100
|
standard_survey_dim$standard_survey_length_or_width_indicator | varchar | identifies if the individual is part of the Standard Length Survey | |
100
|
length_timestamp | timestamp | Timestamp at the point the length is taken on an individual | |
100
|
field_identified_taxonomy_dim$common_name | varchar | only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null | |
100
|
best_available_taxonomy_dim$pacfin_nom_spid | varchar | PacFIN nominal species identifier | |
100
|
actual_station_design_dim$station_design_type | varchar | type of design underlying the survey station set: Transect or Grid to date | |
100
|
field_identified_taxonomy_dim$worms_aphiaid | int4 | WoRMS taxonomic identifier | |
100
|
max_depth_m | numeric | high precision value of maximum depth measured in meters | |
100
|
field_identified_taxonomy_whid | int4 | warehouse identifier to field identified taxonomy | |
100
|
most_recent_age_update_date_dim$month_of_year | int2 | numeric representation of month of year | |
100
|
length_type | varchar | describes how the measurement was calculated | |
100
|
station_lr_lon_dd | numeric | high precision value of lower right longitude of design type grid measured in decimal degrees | |
100
|
haul_longitude_whid | int4 | warehouse identifier for haul longitude | |
100
|
date_dim$year | int4 | numeric representation of year | |
100
|
actual_station_design_dim$centroid_id | numeric | eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons. | |
100
|
actual_station_design_whid | int4 | warehouse identifier for station design | |
100
|
operation_dim$coast_guard_number | varchar | Coast Guard documentation number of vessel | |
100
|
field_identified_taxonomy_dim$kingdom_10 | varchar | kingdom name | |
100
|
most_recent_taxonomy_update_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
100
|
most_recent_age_update_date_dim$month_name | varchar | text representation of month | |
100
|
taxon_source | varchar | name of primary source used to get the measurement | |
100
|
field_identified_taxonomy_dim$acoustics_species_id | int4 | Species ID used in the acoustics program | |
100
|
sampling_end_time_dim$minute | int2 | number of minutes in the hour | |
100
|
date_yyyymmdd | bpchar | text representation of year month day | |
100
|
haul_latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" | |
100
|
haul_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction | |
100
|
year | int2 | operation year | |
100
|
most_recent_age_update_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
100
|
field_identified_taxonomy_dim$subfamily_52 | varchar | subfamily name | |
100
|
sampling_start_time_dim$hour | int2 | standard representation of the hour | |
100
|
most_recent_maturity_update_date_dim$month_of_year | int2 | numeric representation of month of year | |
100
|
lab_maturity_detail_dim$functionally_mature_certain_indicator | varchar | identifies the certainty of the functionally mature evaluation | |
100
|
best_available_taxonomy_dim$subfamily_52 | varchar | subfamily name | |
100
|
otosag_id | int4 | Otolith barcode or sample number | |
100
|
haul_latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only | |
100
|
date_whid | int8 | warehouse identifier for date | |
100
|
target_station_design_dim$min_latitude_whid | int4 | minimum latitude warehouse identifier for a design type of transect | |
100
|
field_identified_taxonomy_dim$grp_nonstandard_taxon_99 | varchar | a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design | |
100
|
operation_dim$departure_date_whid | int8 | date reference that vessel departed for the defined leg or trip | |
100
|
length_observation_detail_dim$observation_type | varchar | the type of observation | |
100
|
operation_dim$fpc_person_whid | int4 | person reference for the FPC | |
100
|
actual_station_design_dim$transect_latitude_whid | int4 | latitude warehouse identifier for a design type of transect | |
100
|
length_cm | numeric | Individual length measured in centimeters | |
100
|
target_station_design_dim$active_polygon_dd | polygon | collection of vertices of the usuable area inside a station grid measured in decimal degrees | |
100
|
operation_dim$operation_end_date_whid | int8 | end date reference for the operation | |
100
|
field_identified_taxonomy_dim$scientific_name | varchar | scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level | |
100
|
actual_station_design_dim$max_depth_whid | int4 | maximum depth warehouse identifier | |
100
|
actual_station_design_dim$min_depth_m | numeric | high precision value of minimum depth measured in meters | |
100
|
operation_dim$return_date_whid | int8 | date reference that vessel returned for the defined leg or trip | |
100
|
haul_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction | |
100
|
target_station_design_dim$transect_latitude_whid | int4 | latitude warehouse identifier for a design type of transect | |
100
|
date_dim$full_date | timestamp | full date value | |
100
|
target_station_design_dim$upper_left_latitude_whid | int4 | upper left latitude warehouse identifier for a design type of grid | |
100
|
actual_station_design_dim$mean_depth_whid | int4 | mean depth warehouse identifier | |
100
|
min_depth_m | numeric | high precision value of minimum depth measured in meters | |
100
|
year_stn_invalid | int2 | Survey year the station became invalid for trawl | |
100
|
length_observation_detail_dim$record_type | varchar | observation detail record type or reason record is unavailable | |
100
|
target_station_design_dim$upper_left_longitude_whid | int4 | upper left longitude warehouse identifier for a design type of grid | |
100
|
station_code | varchar | unique identifier for a station definition | |
100
|
station_ul_lat_dd | numeric | high precision value of upper left latitude of design type grid measured in decimal degrees | |
100
|
station_ll_lon_dd | numeric | high precision value of lower left longitude of design type grid measured in decimal degrees | |
100
|
vessel | varchar | name of the vessel used for the operation | |
100
|
most_recent_taxonomy_update_date_dim$month_of_year | int2 | numeric representation of month of year | |
100
|
actual_station_design_dim$lower_left_latitude_dd | numeric | high precision value of lower left latitude of design type grid measured in decimal degrees | |
100
|
best_available_taxonomy_dim$superfamily_48 | varchar | superfamily name | |
100
|
depth_ftm | numeric | depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries | |
100
|
actual_station_design_dim$transect_latitude_dd | numeric | high precision value of transect latitude measured in decimal degrees | |
100
|
weight_kg | numeric | Individual weight measured in kilograms | |
100
|
field_identified_taxonomy_dim$grp_reg_depth_category | varchar | management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf | |
100
|
width_observation_detail_dim$source_primary | varchar | name of primary source used to get the measurement | |
100
|
target_station_design_dim$transect_station_longitude_whid | int4 | longitude on transect warehouse identifier for a design type of transect | |
100
|
actual_station_design_dim$station_grid_dd | polygon | collection of vertices of grid points of a grid design measured in decimal degrees | |
100
|
operation_dim$return_port_whid | int4 | port reference for return port | |
100
|
actual_station_design_dim$min_latitude_dd | numeric | high precision value of minimum latitude measured in decimal degrees | |
100
|
tow_end_timestamp | timestamp | operation end date timestamp | |
100
|
best_available_taxonomy_dim$grp_reg_depth_category | varchar | management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf | |
100
|
field_identified_taxonomy_dim$subphylum_22 | varchar | subphylum name | |
100
|
operation_dim$captain_person_whid | int4 | person reference for the vessel captain | |
100
|
target_station_design_dim$lower_left_latitude_whid | int4 | lower left latitude warehouse identifier for a design type of grid | |
100
|
length_observation_detail_dim$method_description | varchar | description of how the observation was taken | |
100
|
best_available_taxonomy_dim$suborder_42 | varchar | suborder name | |
100
|
most_recent_age_update_date_whid | int8 | Warehouse identifier for most recent age update date | |
100
|
field_identified_taxonomy_dim$phylum_20 | varchar | phylum name | |
100
|
best_available_taxonomy_dim$superclass_28 | varchar | superclass name | |
100
|
statistical_partition_whid | int4 | warehouse identifier for statistical partition | |
100
|
target_station_design_dim$upper_right_latitude_whid | int4 | upper right latitude warehouse identifier for a design type of grid | |
100
|
length_observation_detail_dim$measurement_procurement | varchar | how the measurement was achieved | |
100
|
length_observation_detail_whid | int4 | Warehouse identifier to taxonomy observation detail | |
100
|
field_identified_taxonomy_dim$pacfin_spid | varchar | pacfin species id - many taxa may not have one of these | |
100
|
operation_dim$ifq_account_number | varchar | unique number assigned to user accounts in the Vessel Accounting Database | |
100
|
best_available_taxonomy_dim$subspecies_82 | varchar | subspecies name | |
100
|
scientific_name | varchar | scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level | |
100
|
width_observation_detail_dim$measurement_procurement | varchar | how the measurement was achieved | |
100
|
target_station_design_dim$area_hectares | numeric | station area measured in hectares | |
100
|
age_years | numeric | Individual age measured in years | |
100
|
sampling_start_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 | |
100
|
most_recent_taxonomy_update_date_dim$month_name | varchar | text representation of month | |
100
|
best_available_taxonomy_dim$hookandline_species_id | int4 | species identifier used by hook and line | |
100
|
best_available_taxonomy_observation_detail_dim$observation_type | varchar | the type of observation | |
100
|
field_identified_taxonomy_dim$genus_70 | varchar | genus name | |
100
|
most_recent_taxonomy_update_date_dim$year | int4 | numeric representation of year | |
100
|
actual_station_design_dim$active_polygon_dd | polygon | collection of vertices of the usuable area inside a station grid measured in decimal degrees | |
100
|
field_identified_taxonomy_dim$abbreviated_name | varchar | specialized common name, generally for a well-known species of fish such as ATF, LST, SST | |
100
|
operation_dim$scientist_4_person_whid | int4 | person reference for the fourth scientist | |
100
|
actual_station_design_dim$lower_right_longitude_whid | int4 | lower right longitude warehouse identifier for a design type of grid | |
100
|
target_station_design_dim$transect_latitude_dd | numeric | high precision value of transect latitude measured in decimal degrees | |
100
|
mean_seafloor_dep_boundary | varchar | depth boundry indicator identifying ifp boundary marks | |
100
|
best_available_taxonomy_dim$grp_nonstandard_taxon_99 | varchar | a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design | |
100
|
sampling_start_time_dim$second | int2 | number of seconds in the minute | |
100
|
actual_station_design_dim$station_invalid_survey_year | int2 | Survey year the station became invalid for trawl | |
100
|
sampling_start_time_whid | int4 | warehouse identifier for the sampling start time | |
100
|
target_station_design_dim$lower_right_longitude_whid | int4 | lower right longitude warehouse identifier for a design type of grid | |
100
|
haul_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable | |
100
|
tissue_id | numeric | Tissue sample number or barcode | |
100
|
actual_station_design_dim$transect_station_longitude_whid | int4 | longitude on transect warehouse identifier for a design type of transect | |
100
|
best_available_taxonomy_dim$tribe_60 | varchar | tribe name | |
100
|
field_note | varchar | Note made in the field about an individual | |
100
|
sex_dim$sex | varchar | biological sex of individual | |
100
|
actual_station_design_dim$station_code | varchar | unique identifier for a station definition | |
100
|
latitude_dd | numeric | numeric representation of latitude in degrees | |
100
|
actual_station_design_dim$station_design_name | varchar | name of the design for a collection of stations | |
100
|
lab_maturity_detail_dim$biologically_mature_certain_indicator | varchar | identifies the certainty of the biological maturity | |
100
|
actual_station_design_dim$lower_right_latitude_whid | int4 | lower right latitude warehouse identifier for a design type of grid | |
100
|
haul_longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only | |
100
|
best_available_taxonomy_observation_detail_dim$means_of_calculation | varchar | describes how the measurement was calculated | |
100
|
most_recent_age_update | timestamp | full date value | |
100
|
actual_station_design_dim$area_hectares | numeric | station area measured in hectares | |
100
|
taxon_rank | varchar | name of the lowest taxonomic level used to define scientific name | |
100
|
best_available_taxonomy_observation_detail_dim$record_type | varchar | observation detail record type or reason record is unavailable | |
100
|
best_available_taxonomy_dim$norpac_species_id | int4 | A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. | |
100
|
field_identified_taxonomy_dim$observer_species_id | int4 | species identifier used by the observer program | |
100
|
operation_dim_whid | int8 | warehouse identifier for operation | |
100
|
operation_dim$scientist_2_person_whid | int4 | person reference for the second scientist | |
100
|
most_recent_taxonomy_update_date_dim$yyyymmdd | bpchar | text representation of year month day | |
100
|
best_available_taxonomy_dim$genus_70 | varchar | genus name | |
100
|
net_touchdown_time | time | military time representation of the time | |
100
|
best_available_taxonomy_dim$itis_taxonomic_serial_no | int4 | ITIS taxonomic identifier | |
100
|
operation_dim$vessel_id | int2 | field database vessel id number | |
100
|
left_pectoral_fin_id | int4 | Left pectoral fin sample number or barcode | |
100
|
best_available_taxonomy_dim$worms_aphiaid | int4 | WoRMS taxonomic identifier | |
100
|
lab_maturity_detail_dim$biologically_mature_indicator | varchar | identifies biological maturity of the individual | |
100
|
most_recent_taxonomy_update_date_whid | int8 | Warehouse identifier for most recent taxonomy update date | |
100
|
haul_latitude_whid | int4 | warehouse identifier for haul latitude | |
100
|
operation_dim$state_registration_number | varchar | state registration number for the vessel | |
100
|
actual_station_design_dim$upper_right_latitude_dd | numeric | high precision value of upper right latitude of design type grid measured in decimal degrees | |
100
|
date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
100
|
actual_station_design_dim$upper_left_longitude_dd | numeric | high precision value of upper left longitude of design type grid measured in decimal degrees | |
100
|
best_available_taxonomy_observation_detail_dim$method_description | varchar | description of how the observation was taken | |
100
|
width_observation_detail_whid | int4 | Warehouse identifier to taxonomy observation detail | |
100
|
haul_latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only | |
100
|
common_name | varchar | only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null | |
100
|
actual_station_design_dim$mean_depth_m | numeric | high precision value of mean depth measured in meters | |
100
|
field_identified_taxonomy_dim$pacfin_nom_spid | varchar | PacFIN nominal species identifier | |
100
|
field_identified_taxonomy_dim$superclass_28 | varchar | superclass name | |
100
|
actual_station_design_dim$max_depth_m | numeric | high precision value of maximum depth measured in meters | |
100
|
field_identified_taxonomy_dim$superfamily_48 | varchar | superfamily name | |
100
|
most_recent_age_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
100
|
tow_start_timestamp | timestamp | operation start date timestamp | |
100
|
actual_station_design_dim$reason_station_invalid | varchar | reason station was invalidated, multiple reasons are comma separated | |
100
|
standard_survey_dim$standard_survey_maturity_indicator | varchar | identifies if the individual is part of the Standard Maturity Survey | |
100
|
station_lr_lat_dd | numeric | high precision value of lower right latitude of design type grid measured in decimal degrees | |
100
|
best_available_taxonomy_dim$infraclass_34 | varchar | infraclass name | |
100
|
length_observation_detail_dim$source_primary | varchar | name of primary source used to get the measurement | |
100
|
target_station_design_dim$max_latitude_dd | numeric | high precision value of maximum latitude measured in decimal degrees | |
100
|
operation_dim$trip_id | int4 | trip identifier number | |
100
|
sampling_start_time_dim$period | bpchar | period of time | |
100
|
operation_dim$record_type | varchar | operation record or reason record is unavailable | |
100
|
sampling_end_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 | |
100
|
date_dim$month_name | varchar | text representation of month | |
100
|
target_station_design_dim$lower_left_longitude_whid | int4 | lower left longitude warehouse identifier for a design type of grid | |
100
|
target_station_design_dim$station_grid_dd | polygon | collection of vertices of grid points of a grid design measured in decimal degrees | |
100
|
most_recent_age_update_date_dim$day_of_month | int2 | numeric representation of the day in month | |
100
|
tow | int2 | operation number of the survey | |
100
|
actual_station_design_dim$stn_invalid_for_trawl_date_whid | int8 | station design invalidation date warehouse identifier | |
100
|
standard_survey_dim$standard_survey_age_indicator | varchar | identifies if the individual is part of the Standard Age Survey | |
100
|
width_observation_detail_dim$record_type | varchar | observation detail record type or reason record is unavailable | |
100
|
field_identified_taxonomy_dim$infraclass_34 | varchar | infraclass name | |
100
|
most_recent_maturity_update_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
100
|
field_identified_taxonomy_dim$subspecies_82 | varchar | subspecies name | |
100
|
best_available_taxonomy_dim$acoustics_species_id | int4 | Species ID used in the acoustics program | |
100
|
actual_station_design_dim$max_latitude_whid | int4 | maximum latitude warehouse identifier for a design type of transect | |
100
|
most_recent_age_update_date_dim$year | int4 | numeric representation of year | |
100
|
species_subcategory | varchar | mid-level taxonomic ranking | |
100
|
date_dim$day_of_month | int2 | numeric representation of the day in month | |
100
|
actual_station_design_dim$upper_left_latitude_dd | numeric | high precision value of upper left latitude of design type grid measured in decimal degrees | |
100
|
field_identified_taxonomy_dim$tribe_60 | varchar | tribe name | |
100
|
leg | int2 | leg number of the survey | |
100
|
field_identified_taxonomy_dim$subclass_32 | varchar | subclass name | |
100
|
best_available_taxonomy_observation_detail_whid | int4 | warehouse identifier to best available taxonomy observation detail | |
100
|
seafloor_depth_dim$record_type | varchar | depth record or reason record is unavailable | |
100
|
station_ul_lon_dd | numeric | high precision value of upper left longitude of design type grid measured in decimal degrees | |
100
|
most_recent_taxonomy_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
100
|
field_identified_taxonomy_dim$class_30 | varchar | class name | |
100
|
sampling_end_time_dim$hour | int2 | standard representation of the hour | |
100
|
actual_station_design_dim$upper_left_latitude_whid | int4 | upper left latitude warehouse identifier for a design type of grid | |
100
|
sampling_start_time_dim$military_hour | int2 | military representation of the hour | |
100
|
haul_longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" | |
100
|
reason_stn_invalid | varchar | reason station was invalidated, multiple reasons are comma separated | |
100
|
sampling_end_time_dim$second | int2 | number of seconds in the minute | |
100
|
best_available_taxonomy_dim$superorder_38 | varchar | superorder name | |
100
|
best_available_taxonomy_dim$kingdom_10 | varchar | kingdom name | |
100
|
field_identified_taxonomy_dim$trawl_survey_species_id | int4 | species identifier used by the trawl survey | |
100
|
actual_station_design_dim$lower_right_latitude_dd | numeric | high precision value of lower right latitude of design type grid measured in decimal degrees | |
100
|
partition | varchar | Refines the partition type | |
100
|
field_identified_taxonomy_dim$norpac_species_id | int4 | A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. | |
100
|
field_identified_taxonomy_dim$suborder_42 | varchar | suborder name | |
100
|
field_identified_taxonomy_dim$family_50 | varchar | family name | |
100
|
sampling_end_time_dim$record_type | varchar | time record or reason record is unavailable | |
100
|
actual_station_design_dim$lower_right_longitude_dd | numeric | high precision value of lower right longitude of design type grid measured in decimal degrees | |
100
|
best_available_taxonomy_dim$class_30 | varchar | class name | |
100
|
seafloor_depth_whid | int4 | warehouse identifier for seafloor depth | |
100
|
target_station_design_dim$mean_depth_m | numeric | high precision value of mean depth measured in meters | |
100
|
field_identified_taxonomy_dim$species_sub_category | varchar | mid-level taxonomic ranking | |
100
|
operation_dim$observer_program | varchar | description of the observer program | |
100
|
lab_maturity_detail_dim$functionally_mature_indicator | varchar | identifies the functional maturity of the individual | |
100
|
pacfin_spid | varchar | pacfin species id - many taxa may not have one of these | |
100
|
best_available_taxonomy_dim$infraorder_44 | varchar | infraorder name | |
100
|
most_recent_maturity_update_date_dim$day_of_month | int2 | numeric representation of the day in month | |
100
|
statistical_partition_dim$statistical_partition_type | varchar | Defines the partition type | |
100
|
target_station_design_dim$record_type | varchar | station design record or reason record is unavailable | |
100
|
best_available_taxonomy_dim$order_40 | varchar | order name | |
100
|
actual_station_design_dim$min_depth_whid | int4 | minimum depth warehouse identifier | |
100
|
actual_station_design_dim$max_latitude_dd | numeric | high precision value of maximum latitude measured in decimal degrees | |
100
|
field_identified_taxonomy_dim$order_40 | varchar | order name | |
100
|
field_identified_taxonomy_dim$species_80 | varchar | species name | |
100
|
sampling_end_time_dim$military_hour | int2 | military representation of the hour | |
100
|
lab_maturity_detail_dim$record_type | varchar | lab maturity detail record or reason record is unavailable | |
100
|
best_available_taxonomy_dim$species_80 | varchar | species name | |
100
|
best_available_taxonomy_observation_detail_dim$measurement_procurement | varchar | how the measurement was achieved | |
100
|
target_station_design_dim$lower_right_latitude_whid | int4 | lower right latitude warehouse identifier for a design type of grid | |
100
|
operation_dim$operation_type | varchar | type of operation | |
100
|
haul_latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only | |
100
|
actual_station_design_dim$record_type | varchar | station design record or reason record is unavailable | |
100
|
target_station_design_dim$max_depth_whid | int4 | maximum depth warehouse identifier | |
100
|
best_available_taxonomy_dim$subclass_32 | varchar | subclass name | |
100
|
haul_longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only | |
100
|
sex_dim$record_type | varchar | latitude record type or reason record is unavailable | |
100
|
actual_station_design_dim$min_latitude_whid | int4 | minimum latitude warehouse identifier for a design type of transect | |
100
|
date_dim$month_of_year | int2 | numeric representation of month of year | |
100
|
most_recent_maturity_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
100
|
operation_dim$limited_entry_permit_number | bpchar | federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California | |
67
|
sex | bpchar | ||
100
|
target_station_design_dim$station_design_name | varchar | name of the design for a collection of stations | |
100
|
best_available_taxonomy_dim$trawl_survey_species_id | int4 | species identifier used by the trawl survey | |
100
|
lab_maturity_detail_whid | int2 | Warehouse identifier for lab maturity details | |
100
|
most_recent_maturity_update_date_dim$full_date | timestamp | full date value | |
100
|
most_recent_maturity_update_date_dim$year | int4 | numeric representation of year |
Attribute Details
actual_station_design_dim$transect_station_longitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of transect station longitude measured in decimal degrees |
Unit of Measure: | dd |
standard_survey_dim$standard_survey_weight_indicator
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
identifies if the individual is part of the Standard Weight Survey |
Allowed Values: | Standard Survey Weight, Not Standard Survey Weight, NA |
sampling_start_time_dim$minute
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
number of minutes in the hour |
Unit of Measure: | min |
Allowed Values: | 0-60 |
best_available_taxonomy_dim$phylum_20
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
phylum name |
performance
Data Storage Type: | varchar |
---|---|
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
performance of the operation |
Allowed Values: | Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] |
actual_station_design_dim$upper_right_latitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
upper right latitude warehouse identifier for a design type of grid |
date_dim$record_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
date, month, or year record or reason record is unavailable |
Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
actual_station_design_dim$lower_left_longitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of lower left longitude of design type grid measured in decimal degrees |
Unit of Measure: | dd |
best_available_taxonomy_dim$structure_source
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
Source of the taxonomic structure |
Unit of Measure: | unspecified |
Allowed Values: | Any |
best_available_taxonomy_dim$family_50
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
family name |
actual_station_design_dim$upper_right_longitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of upper right longitude of design type grid measured in decimal degrees |
Unit of Measure: | dd |
actual_station_design_dim$upper_right_longitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
upper right longitude warehouse identifier for a design type of grid |
actual_station_design_dim$lower_left_latitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
lower left latitude warehouse identifier for a design type of grid |
best_available_taxonomy_dim$record_type
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
record or reason record is unavailable |
Allowed Values: | Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
width_observation_detail_dim$method_description
Data Storage Type: | varchar |
---|---|
Max Length: | 500 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
description of how the observation was taken |
station_ur_lon_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of upper right longitude of design type grid measured in decimal degrees |
Unit of Measure: | dd |
most_recent_taxonomy_update_date_dim$day_of_month
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
numeric representation of the day in month |
Allowed Values: | 1-31 |
most_recent_age_update_date_dim$yyyymmdd
Data Storage Type: | bpchar |
---|---|
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
text representation of year month day |
individual_tracking_id
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
Individual tracking id |
ovary_id
Data Storage Type: | numeric |
---|---|
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Ovary sample number or barcode |
Unit of Measure: | unspecifid |
Allowed Values: | Any |
target_station_design_dim$stn_invalid_for_trawl_date_whid
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
station design invalidation date warehouse identifier |
standard_survey_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
Warehouse identifier for standard survey |
operation_dim$scientist_1_person_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
person reference for the first scientist |
most_recent_maturity_update_date_whid
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
Warehouse identifier for most recent maturity update date |
net_liftoff_time
Data Storage Type: | time |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
military time representation of the time |
actual_station_design_dim$variance_depth_m2
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Status: | Active |
Description: |
high precision value of variance depth mesured in squared meters |
Unit of Measure: | m2 |
target_station_design_dim$variance_depth_m2
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Status: | Active |
Description: |
high precision value of variance depth mesured in squared meters |
Unit of Measure: | m2 |
target_station_design_dim$min_depth_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
minimum depth warehouse identifier |
target_station_design_dim$transect_station_longitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of transect station longitude measured in decimal degrees |
Unit of Measure: | dd |
actual_station_design_dim$lower_left_longitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
lower left longitude warehouse identifier for a design type of grid |
Unit of Measure: | unspecified |
Allowed Values: | Any |
field_identified_taxonomy_dim$itis_taxonomic_serial_no
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
ITIS taxonomic identifier |
Unit of Measure: | unspecified |
Allowed Values: | Any |
operation_dim$departure_port_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
port reference for the departure port |
haul_latitude_dim$record_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
latitude record type or reason record is unavailable |
Unit of Measure: | NA |
Allowed Values: | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
sex_whid
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
Warehouse identifier to sex details |
target_station_design_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
warehouse identifier for target station design |
target_station_design_dim$max_latitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
maximum latitude warehouse identifier for a design type of transect |
actual_station_design_dim$upper_left_longitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
upper left longitude warehouse identifier for a design type of grid |
pass
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
pass number of the survey |
Allowed Values: | 1,2,3,4 |
sampling_end_time_dim$period
Data Storage Type: | bpchar |
---|---|
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
period of time |
Allowed Values: | AM, PM |
operation_dim$scientist_3_person_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
person reference for the third scientist |
field_identified_taxonomy_dim$structure_source
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
Source of the taxonomic structure |
Unit of Measure: | unspecified |
Allowed Values: | Any |
width_cm
Data Storage Type: | numeric |
---|---|
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Status: | Active |
Description: |
Individual width measured in centimeters |
Unit of Measure: | cm |
most_recent_taxon_update
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
full date value |
best_available_taxonomy_dim$abbreviated_name
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
operation_dim$operation_start_date_whid
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
start date reference for the operation |
best_available_taxonomy_dim$observer_species_id
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
species identifier used by the observer program |
project
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
project name |
Allowed Values: | Groundfish Shelf Survey, Groundfish Slope and Shelf Combination Survery, Groundfish Slope Survey, Groundfish Triennial Shelf Survery, Hypoxia Study, Santa Barbara Basin Study, Shelf Rockfish [2004-2015], Video Study |
midtow_lat_named_parallel
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
name of parallel, boundary, or commonly used geograpical location |
Unit of Measure: | NA |
Allowed Values: | any |
field_identified_taxonomy_dim$species_category
Data Storage Type: | varchar |
---|---|
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
upper-level taxonomic ranking |
Allowed Values: | fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA |
centroid_id
Data Storage Type: | numeric |
---|---|
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons. |
sampling_start_time_dim$record_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
time record or reason record is unavailable |
Allowed Values: | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
operation_dim$field_operation_seg_id
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
operation segment id reference to the field operational segment table |
sampling_end_time_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
warehouse identifier for the sampling end time |
standard_survey_dim$record_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
standard survey record or reason record is unavailable |
Allowed Values: | Standard Survey, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
depth_m
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Status: | Active |
Description: |
depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
Unit of Measure: | m |
Allowed Values: | 0-1500 |
target_station_design_dim$upper_right_longitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
upper right longitude warehouse identifier for a design type of grid |
target_station_design_dim$mean_depth_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
mean depth warehouse identifier |
stomach_id
Data Storage Type: | numeric |
---|---|
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Stomach sample number or barcode |
Unit of Measure: | unspecified |
Allowed Values: | Any |
target_station_design_dim$station_design_type
Data Storage Type: | varchar |
---|---|
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
type of design underlying the survey station set: Transect or Grid to date |
Allowed Values: | Transect, Grid |
trawl_id
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
identifier for a sampling operation |
station_ur_lat_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of upper right latitude of design type grid measured in decimal degrees |
Unit of Measure: | dd |
width_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
describes how the measurement was calculated |
Allowed Values: | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
best_available_taxonomy_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
warehouse identifier to best available taxonomy |
statistical_partition_dim$record_type
Data Storage Type: | varchar |
---|---|
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
statistical partition record or reason record is unavailable |
Allowed Values: | Statistical Partition, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
species_category
Data Storage Type: | varchar |
---|---|
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
upper-level taxonomic ranking |
Allowed Values: | fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA |
field_identified_taxonomy_dim$hookandline_species_id
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
species identifier used by hook and line |
station_ll_lat_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of lower left latitude of design type grid measured in decimal degrees |
Unit of Measure: | dd |
best_available_taxonomy_dim$subphylum_22
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
subphylum name |
field_identified_taxonomy_dim$record_type
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
record or reason record is unavailable |
Allowed Values: | Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
field_identified_taxonomy_dim$scientific_name_taxonomic_level
Data Storage Type: | varchar |
---|---|
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
name of the lowest taxonomic level used to define scientific name |
longitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
numeric representation of longitude in decimal degrees |
Unit of Measure: | dd |
Allowed Values: | -180 to 180 |
haul_longitude_dim$longitude_minute_units
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
numeric representation of longitude that makes up the minute unit only |
Unit of Measure: | min |
Allowed Values: | 0-59 |
program
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
type of fram program |
Allowed Values: | Bottom Trawl, Hook and Line |
width_observation_detail_dim$observation_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
the type of observation |
Allowed Values: | NA, width, length, total_catch_weight, taxonomy, etc |
field_identified_taxonomy_dim$superorder_38
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
superorder name |
operation_dim$operation_end_time_whid
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
end time reference for the operation |
target_station_design_dim$min_latitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of minimum latitude measured in decimal degrees |
Unit of Measure: | dd |
most_recent_maturity_update_date_dim$yyyymmdd
Data Storage Type: | bpchar |
---|---|
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
text representation of year month day |
most_recent_maturity_update_date_dim$month_name
Data Storage Type: | varchar |
---|---|
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
text representation of month |
Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
operation_dim$operation_start_time_whid
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
start time reference for the operation |
field_identified_taxonomy_dim$infraorder_44
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
infraorder name |
standard_survey_dim$standard_survey_length_or_width_indicator
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
identifies if the individual is part of the Standard Length Survey |
Allowed Values: | Standard Survey Length, Not Standard Survey Length, NA |
length_timestamp
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Timestamp at the point the length is taken on an individual |
field_identified_taxonomy_dim$common_name
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null |
best_available_taxonomy_dim$pacfin_nom_spid
Data Storage Type: | varchar |
---|---|
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
PacFIN nominal species identifier |
Unit of Measure: | unspecified |
Allowed Values: | Any |
actual_station_design_dim$station_design_type
Data Storage Type: | varchar |
---|---|
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
type of design underlying the survey station set: Transect or Grid to date |
Allowed Values: | Transect, Grid |
field_identified_taxonomy_dim$worms_aphiaid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
WoRMS taxonomic identifier |
Unit of Measure: | unspecified |
Allowed Values: | Any |
max_depth_m
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Status: | Active |
Description: |
high precision value of maximum depth measured in meters |
Unit of Measure: | m |
field_identified_taxonomy_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
warehouse identifier to field identified taxonomy |
most_recent_age_update_date_dim$month_of_year
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
numeric representation of month of year |
Allowed Values: | 1-12 |
length_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
describes how the measurement was calculated |
Allowed Values: | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
station_lr_lon_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of lower right longitude of design type grid measured in decimal degrees |
Unit of Measure: | dd |
haul_longitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
warehouse identifier for haul longitude |
date_dim$year
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
numeric representation of year |
Allowed Values: | 1978+ |
actual_station_design_dim$centroid_id
Data Storage Type: | numeric |
---|---|
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons. |
actual_station_design_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
warehouse identifier for station design |
operation_dim$coast_guard_number
Data Storage Type: | varchar |
---|---|
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Coast Guard documentation number of vessel |
field_identified_taxonomy_dim$kingdom_10
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
kingdom name |
most_recent_taxonomy_update_date_dim$record_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
date, month, or year record or reason record is unavailable |
Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
most_recent_age_update_date_dim$month_name
Data Storage Type: | varchar |
---|---|
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
text representation of month |
Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
taxon_source
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
name of primary source used to get the measurement |
Allowed Values: | Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism |
field_identified_taxonomy_dim$acoustics_species_id
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
Species ID used in the acoustics program |
Unit of Measure: | unspecified |
Allowed Values: | Any |
sampling_end_time_dim$minute
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
Data Storage Type: | bpchar |
---|---|
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
text representation of year month day |
haul_latitude_dim$latitude_in_degree_minute_second
Data Storage Type: | varchar |
---|---|
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
Unit of Measure: | NA |
Allowed Values: | any |
haul_latitude_dim$latitude_compass_direction
Data Storage Type: | bpchar |
---|---|
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
latitude compass direction |
Unit of Measure: | NA |
Allowed Values: | N, S |
year
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
operation year |
Unit of Measure: | year |
Allowed Values: | 2007+ |
most_recent_age_update_date_dim$record_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
date, month, or year record or reason record is unavailable |
Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
field_identified_taxonomy_dim$subfamily_52
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
subfamily name |
sampling_start_time_dim$hour
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
standard representation of the hour |
Unit of Measure: | hr |
Allowed Values: | 0-12 |
most_recent_maturity_update_date_dim$month_of_year
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
numeric representation of month of year |
Allowed Values: | 1-12 |
lab_maturity_detail_dim$functionally_mature_certain_indicator
Data Storage Type: | varchar |
---|---|
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
identifies the certainty of the functionally mature evaluation |
Allowed Values: | Functionally Mature Certain, Not Functionally Mature Certain, NA |
best_available_taxonomy_dim$subfamily_52
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
subfamily name |
otosag_id
Data Storage Type: | int4 |
---|---|
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Otolith barcode or sample number |
Unit of Measure: | unspecified |
Allowed Values: | Any |
haul_latitude_dim$latitude_second_units
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
numeric representation of latitude that makes up the second unit only |
Unit of Measure: | sec |
Allowed Values: | 0-60 |
date_whid
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
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
minimum latitude warehouse identifier for a design type of transect |
field_identified_taxonomy_dim$grp_nonstandard_taxon_99
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design |
operation_dim$departure_date_whid
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
date reference that vessel departed for the defined leg or trip |
length_observation_detail_dim$observation_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
the type of observation |
Allowed Values: | NA, width, length, total_catch_weight, taxonomy, etc |
operation_dim$fpc_person_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
person reference for the FPC |
actual_station_design_dim$transect_latitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
latitude warehouse identifier for a design type of transect |
length_cm
Data Storage Type: | numeric |
---|---|
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Status: | Active |
Description: |
Individual length measured in centimeters |
Unit of Measure: | cm |
target_station_design_dim$active_polygon_dd
Data Storage Type: | polygon |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
collection of vertices of the usuable area inside a station grid measured in decimal degrees |
Unit of Measure: | dd |
operation_dim$operation_end_date_whid
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
end date reference for the operation |
field_identified_taxonomy_dim$scientific_name
Data Storage Type: | varchar |
---|---|
Max Length: | 120 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level |
actual_station_design_dim$max_depth_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
maximum depth warehouse identifier |
actual_station_design_dim$min_depth_m
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Status: | Active |
Description: |
high precision value of minimum depth measured in meters |
Unit of Measure: | m |
operation_dim$return_date_whid
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
date reference that vessel returned for the defined leg or trip |
haul_longitude_dim$longitude_compass_direction
Data Storage Type: | bpchar |
---|---|
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
longitude compass direction |
Allowed Values: | E, W |
target_station_design_dim$transect_latitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
latitude warehouse identifier for a design type of transect |
date_dim$full_date
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
full date value |
target_station_design_dim$upper_left_latitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
upper left latitude warehouse identifier for a design type of grid |
actual_station_design_dim$mean_depth_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
mean depth warehouse identifier |
min_depth_m
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Status: | Active |
Description: |
high precision value of minimum depth measured in meters |
Unit of Measure: | m |
year_stn_invalid
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Survey year the station became invalid for trawl |
Unit of Measure: | year |
Allowed Values: | Any |
length_observation_detail_dim$record_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
observation detail record type or reason record is unavailable |
Allowed Values: | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
target_station_design_dim$upper_left_longitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
upper left longitude warehouse identifier for a design type of grid |
station_code
Data Storage Type: | varchar |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
unique identifier for a station definition |
station_ul_lat_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of upper left latitude of design type grid measured in decimal degrees |
Unit of Measure: | dd |
station_ll_lon_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of lower left longitude of design type grid measured in decimal degrees |
Unit of Measure: | dd |
vessel
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
name of the vessel used for the operation |
Allowed Values: | Aggressor, Amy Lynn, BJ Thomas, Blue Horizon, Captain Jack, Coast Pride, Excalibur, Last Straw, Limit Stalker, Mirage, Miss Leona, Morning Star, Ms. Julie, Noahs Ark, Pacific Sun IV, Raven, Sea Eagle, Toronado |
most_recent_taxonomy_update_date_dim$month_of_year
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
numeric representation of month of year |
Allowed Values: | 1-12 |
actual_station_design_dim$lower_left_latitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of lower left latitude of design type grid measured in decimal degrees |
Unit of Measure: | dd |
best_available_taxonomy_dim$superfamily_48
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
superfamily name |
depth_ftm
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Status: | Active |
Description: |
depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
Unit of Measure: | fth |
actual_station_design_dim$transect_latitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of transect latitude measured in decimal degrees |
Unit of Measure: | dd |
weight_kg
Data Storage Type: | numeric |
---|---|
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Status: | Active |
Description: |
Individual weight measured in kilograms |
Unit of Measure: | kg |
field_identified_taxonomy_dim$grp_reg_depth_category
Data Storage Type: | varchar |
---|---|
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf |
width_observation_detail_dim$source_primary
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
name of primary source used to get the measurement |
Allowed Values: | Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism |
target_station_design_dim$transect_station_longitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
longitude on transect warehouse identifier for a design type of transect |
actual_station_design_dim$station_grid_dd
Data Storage Type: | polygon |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
collection of vertices of grid points of a grid design measured in decimal degrees |
Unit of Measure: | dd |
operation_dim$return_port_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
port reference for return port |
actual_station_design_dim$min_latitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of minimum latitude measured in decimal degrees |
Unit of Measure: | dd |
tow_end_timestamp
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
operation end date timestamp |
best_available_taxonomy_dim$grp_reg_depth_category
Data Storage Type: | varchar |
---|---|
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf |
field_identified_taxonomy_dim$subphylum_22
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
subphylum name |
operation_dim$captain_person_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
person reference for the vessel captain |
target_station_design_dim$lower_left_latitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
lower left latitude warehouse identifier for a design type of grid |
length_observation_detail_dim$method_description
Data Storage Type: | varchar |
---|---|
Max Length: | 500 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
description of how the observation was taken |
best_available_taxonomy_dim$suborder_42
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
suborder name |
most_recent_age_update_date_whid
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
Warehouse identifier for most recent age update date |
field_identified_taxonomy_dim$phylum_20
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
phylum name |
best_available_taxonomy_dim$superclass_28
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
superclass name |
statistical_partition_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
warehouse identifier for statistical partition |
target_station_design_dim$upper_right_latitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
upper right latitude warehouse identifier for a design type of grid |
length_observation_detail_dim$measurement_procurement
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
how the measurement was achieved |
Allowed Values: | NA, Calculated, Estimated, Observed, Measured, Not Documented |
length_observation_detail_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
Warehouse identifier to taxonomy observation detail |
field_identified_taxonomy_dim$pacfin_spid
Data Storage Type: | varchar |
---|---|
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
pacfin species id - many taxa may not have one of these |
operation_dim$ifq_account_number
Data Storage Type: | varchar |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
unique number assigned to user accounts in the Vessel Accounting Database |
best_available_taxonomy_dim$subspecies_82
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
subspecies name |
scientific_name
Data Storage Type: | varchar |
---|---|
Max Length: | 120 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level |
width_observation_detail_dim$measurement_procurement
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
how the measurement was achieved |
Allowed Values: | NA, Calculated, Estimated, Observed, Measured, Not Documented |
target_station_design_dim$area_hectares
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
station area measured in hectares |
Unit of Measure: | hectares |
age_years
Data Storage Type: | numeric |
---|---|
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
Individual age measured in years |
Unit of Measure: | yrs |
sampling_start_hhmmss
Data Storage Type: | bpchar |
---|---|
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
most_recent_taxonomy_update_date_dim$month_name
Data Storage Type: | varchar |
---|---|
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
text representation of month |
Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
best_available_taxonomy_dim$hookandline_species_id
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
species identifier used by hook and line |
best_available_taxonomy_observation_detail_dim$observation_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
the type of observation |
Allowed Values: | NA, width, length, total_catch_weight, taxonomy, etc |
field_identified_taxonomy_dim$genus_70
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
genus name |
most_recent_taxonomy_update_date_dim$year
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
numeric representation of year |
Allowed Values: | 1978+ |
actual_station_design_dim$active_polygon_dd
Data Storage Type: | polygon |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
collection of vertices of the usuable area inside a station grid measured in decimal degrees |
Unit of Measure: | dd |
field_identified_taxonomy_dim$abbreviated_name
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
operation_dim$scientist_4_person_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
person reference for the fourth scientist |
actual_station_design_dim$lower_right_longitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
lower right longitude warehouse identifier for a design type of grid |
target_station_design_dim$transect_latitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of transect latitude measured in decimal degrees |
Unit of Measure: | dd |
mean_seafloor_dep_boundary
Data Storage Type: | varchar |
---|---|
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
depth boundry indicator identifying ifp boundary marks |
Allowed Values: | IFP Boundary Depth, Standard Contour Depth, NA |
best_available_taxonomy_dim$grp_nonstandard_taxon_99
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design |
sampling_start_time_dim$second
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
number of seconds in the minute |
Unit of Measure: | sec |
Allowed Values: | 0-60 |
actual_station_design_dim$station_invalid_survey_year
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Survey year the station became invalid for trawl |
Unit of Measure: | year |
Allowed Values: | Any |
sampling_start_time_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
warehouse identifier for the sampling start time |
target_station_design_dim$lower_right_longitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
lower right longitude warehouse identifier for a design type of grid |
haul_longitude_dim$record_type
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
longitude record type or reason record is unavailable |
Allowed Values: | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
tissue_id
Data Storage Type: | numeric |
---|---|
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Tissue sample number or barcode |
Unit of Measure: | unspecified |
Allowed Values: | Any |
actual_station_design_dim$transect_station_longitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
longitude on transect warehouse identifier for a design type of transect |
best_available_taxonomy_dim$tribe_60
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
tribe name |
field_note
Data Storage Type: | varchar |
---|---|
Max Length: | 1000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Note made in the field about an individual |
sex_dim$sex
Data Storage Type: | varchar |
---|---|
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
biological sex of individual |
Unit of Measure: | unspecified |
Allowed Values: | Any |
actual_station_design_dim$station_code
Data Storage Type: | varchar |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
unique identifier for a station definition |
latitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
numeric representation of latitude in degrees |
Unit of Measure: | dd |
Allowed Values: | -90 to 90 |
actual_station_design_dim$station_design_name
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
name of the design for a collection of stations |
lab_maturity_detail_dim$biologically_mature_certain_indicator
Data Storage Type: | varchar |
---|---|
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
identifies the certainty of the biological maturity |
Allowed Values: | Biologically Mature Certain, Not Biologically Mature Certain, NA |
actual_station_design_dim$lower_right_latitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
lower right latitude warehouse identifier for a design type of grid |
haul_longitude_dim$longitude_degree_units
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
numeric representation of longitude that makes up the degree unit only |
Unit of Measure: | deg |
Allowed Values: | -180 to 180 |
best_available_taxonomy_observation_detail_dim$means_of_calculation
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
describes how the measurement was calculated |
Allowed Values: | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
most_recent_age_update
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
full date value |
actual_station_design_dim$area_hectares
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
station area measured in hectares |
Unit of Measure: | hectares |
taxon_rank
Data Storage Type: | varchar |
---|---|
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
name of the lowest taxonomic level used to define scientific name |
best_available_taxonomy_observation_detail_dim$record_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
observation detail record type or reason record is unavailable |
Allowed Values: | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
best_available_taxonomy_dim$norpac_species_id
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. |
Unit of Measure: | unspecified |
Allowed Values: | Any |
field_identified_taxonomy_dim$observer_species_id
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
species identifier used by the observer program |
operation_dim_whid
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
warehouse identifier for operation |
operation_dim$scientist_2_person_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
person reference for the second scientist |
most_recent_taxonomy_update_date_dim$yyyymmdd
Data Storage Type: | bpchar |
---|---|
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
text representation of year month day |
best_available_taxonomy_dim$genus_70
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
genus name |
net_touchdown_time
Data Storage Type: | time |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
military time representation of the time |
best_available_taxonomy_dim$itis_taxonomic_serial_no
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
ITIS taxonomic identifier |
Unit of Measure: | unspecified |
Allowed Values: | Any |
operation_dim$vessel_id
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
field database vessel id number |
left_pectoral_fin_id
Data Storage Type: | int4 |
---|---|
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Left pectoral fin sample number or barcode |
Unit of Measure: | unspecified |
Allowed Values: | Any |
best_available_taxonomy_dim$worms_aphiaid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
WoRMS taxonomic identifier |
Unit of Measure: | unspecified |
Allowed Values: | Any |
lab_maturity_detail_dim$biologically_mature_indicator
Data Storage Type: | varchar |
---|---|
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
identifies biological maturity of the individual |
Allowed Values: | Biologically Mature, Not Biologically Mature, NA |
most_recent_taxonomy_update_date_whid
Data Storage Type: | int8 |
---|---|
Max Length: | 64 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
Warehouse identifier for most recent taxonomy update date |
haul_latitude_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
warehouse identifier for haul latitude |
operation_dim$state_registration_number
Data Storage Type: | varchar |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
state registration number for the vessel |
actual_station_design_dim$upper_right_latitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of upper right latitude of design type grid measured in decimal degrees |
Unit of Measure: | dd |
date_dim$month_abbrev
Data Storage Type: | bpchar |
---|---|
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
three character representation of month in capital letters |
Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
actual_station_design_dim$upper_left_longitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of upper left longitude of design type grid measured in decimal degrees |
Unit of Measure: | dd |
best_available_taxonomy_observation_detail_dim$method_description
Data Storage Type: | varchar |
---|---|
Max Length: | 500 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
description of how the observation was taken |
width_observation_detail_whid
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
Warehouse identifier to taxonomy observation detail |
haul_latitude_dim$latitude_degree_units
Data Storage Type: | int2 |
---|---|
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
numeric representation of latitude that makes up the degree unit only |
Unit of Measure: | deg |
Allowed Values: | -90 to 90 |
common_name
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null |
actual_station_design_dim$mean_depth_m
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Status: | Active |
Description: |
high precision value of mean depth measured in meters |
Unit of Measure: | m |
field_identified_taxonomy_dim$pacfin_nom_spid
Data Storage Type: | varchar |
---|---|
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
PacFIN nominal species identifier |
Unit of Measure: | unspecified |
Allowed Values: | Any |
field_identified_taxonomy_dim$superclass_28
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
superclass name |
actual_station_design_dim$max_depth_m
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Status: | Active |
Description: |
high precision value of maximum depth measured in meters |
Unit of Measure: | m |
field_identified_taxonomy_dim$superfamily_48
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
superfamily name |
most_recent_age_update_date_dim$month_abbrev
Data Storage Type: | bpchar |
---|---|
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
three character representation of month in capital letters |
Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
tow_start_timestamp
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
operation start date timestamp |
actual_station_design_dim$reason_station_invalid
Data Storage Type: | varchar |
---|---|
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
reason station was invalidated, multiple reasons are comma separated |
Allowed Values: | California State MPA, Cowcod Conservation Area, ENC Avoidance, Farallon Island Radioactive Waste Dump, ONMS MPA, ONMS Permit Exclusion, Outside Survey Extent, Mooring, San Clemente Is. Military test range |
standard_survey_dim$standard_survey_maturity_indicator
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
identifies if the individual is part of the Standard Maturity Survey |
Allowed Values: | Standard Survey Maturity, Not Standard Survey Maturity, NA |
station_lr_lat_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of lower right latitude of design type grid measured in decimal degrees |
Unit of Measure: | dd |
best_available_taxonomy_dim$infraclass_34
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
infraclass name |
length_observation_detail_dim$source_primary
Data Storage Type: | varchar |
---|---|
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
name of primary source used to get the measurement |
Allowed Values: | Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism |
target_station_design_dim$max_latitude_dd
Data Storage Type: | numeric |
---|---|
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Status: | Active |
Description: |
high precision value of maximum latitude measured in decimal degrees |
Unit of Measure: | dd |
operation_dim$trip_id
Data Storage Type: | int4 |
---|---|
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Precision: | 0 |
Status: | Active |
Description: |
trip identifier number |
sampling_start_time_dim$period
Data Storage Type: | bpchar |
---|---|
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
period of time |
Allowed Values: | AM, PM |
operation_dim$record_type
Data Storage Type: | varchar |
---|---|
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
operation record or reason record is unavailable |
Allowed Values: | Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
sampling_end_hhmmss
Data Storage Type: | bpchar |
---|---|
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
date_dim$month_name
Data Storage Type: | varchar |
---|---|
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
text representation of month |
Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
target_station_design_dim$lower_left_longitude_whid
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 |