Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: operation_haul_fact

Entity Information

Entity Type: Data Table
Description:

Operation details including dates, times, location, depths, tempuratures, etc

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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
operation_dim$return_port_whid int4 port reference for return port
100
distance_hb2end_m_der numeric Estimate of the distance traveled by the trawl net during the period following the start of net haulback (start of haulback to net liftoff period) in meters. Expected to be estimated from a hierarchy of methods favoring the use of gear positions derived by the ITI or from its bearing and horizontal range traces, including input from some form of gyrocompass
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
nonspecific_organics_weight_kg numeric Total non-specific organics weight in kilograms
100
gear_start_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
100
vessel_start_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100
actual_station_design_dim$upper_right_longitude_whid int4 upper right longitude warehouse identifier for a design type of grid
100
gear_depth_m_der numeric Single point estimate for depth at the gear in meters for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration from the best depth sensor trace within the haul
100
sampling_end_time_dim$hour int2 standard representation of the hour
100
o2_at_gear_ml_per_l_der numeric Single point estimate for oxygen concentration in milliliters/Liter at the gear for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best oxygen concentration sensor trace within the haul
100
sampling_start_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
gear_start_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
gear_end_latitude_dd numeric Latitude at the gear when sampling ceases (net liftoff for trawling).
100
target_station_design_dim$stn_invalid_for_trawl_date_whid int8 station design invalidation date warehouse identifier
100
operation_dim$scientist_1_person_whid int4 person reference for the first scientist
100
mean_seafloor_dep_boundary varchar depth boundry indicator identifying ifp boundary marks
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
vessel_start_latitude_whid int4 Warehouse identifier for vessel start latitude
100
target_station_design_dim$min_depth_whid int4 minimum depth warehouse identifier
100
gear_end_latitude_dim$latitude_in_degrees numeric numeric representation of latitude in degrees
100
salinity_at_gear_psu_der numeric Single point estimate for salinity in degrees C at the gear for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best salinity sensor trace within the haul. This CTD sensor trace is ordinarily subjected to a skew filter followed by a weighted mean algorithm rather than a simple descriptive mean calculation
100
target_station_design_dim$transect_station_longitude_dd numeric high precision value of transect station longitude measured in decimal degrees
100
station_ul_lon_dd numeric high precision value of upper left longitude of design type grid measured in decimal degrees
100
actual_station_design_dim$lower_right_latitude_whid int4 lower right latitude warehouse identifier for a design type of grid
100
actual_station_design_dim$max_latitude_dd numeric high precision value of maximum latitude measured in decimal degrees
100
target_station_design_dim$max_latitude_whid int4 maximum latitude warehouse identifier for a design type of transect
100
vessel_end_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
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
pass int4 pass number of the survey
100
sampling_end_time_dim$period bpchar period of time
100
actual_station_design_dim$reason_station_invalid varchar reason station was invalidated, multiple reasons are comma separated
100
gear_start_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
vessel_start_latitude_dd numeric Latitude at the vessel when sampling commences (net touchdown for trawling).
100
date_whid int8 warehouse identifier for date
100
actual_station_design_dim$area_hectares numeric station area measured in hectares
100
gear_end_longitude_dim$longitude_in_degrees numeric numeric representation of longitude in decimal degrees
100
actual_station_design_dim$upper_left_latitude_whid int4 upper left latitude warehouse identifier for a design type of grid
100
midtow_position_type varchar Method used for deriving the haul latitude/longitude single point
100
target_station_design_dim$min_latitude_whid int4 minimum latitude warehouse identifier for a design type of transect
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
vessel_end_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
gear_end_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
100
operation_dim$field_operation_seg_id int8 operation segment id reference to the field operational segment table
100
vessel_end_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100
latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
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
target_station_design_dim$station_design_type varchar type of design underlying the survey station set: Transect or Grid to date
100
gear_start_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
100
station_ur_lat_dd numeric high precision value of upper right latitude of design type grid measured in decimal degrees
100
gear_end_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
haul_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
100
haul_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100
station_ll_lat_dd numeric high precision value of lower left latitude of design type grid measured in decimal degrees
100
gear_start_longitude_dim$longitude_in_degrees numeric numeric representation of longitude in decimal degrees
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
station_lr_lon_dd numeric high precision value of lower right longitude of design type grid measured in decimal degrees
100
sampling_end_time_dim$second int2 number of seconds in the minute
100
haul_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
vessel_end_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
latitude_dim$latitude_compass_direction bpchar latitude compass direction
100
gear_end_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
100
gear_end_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
vessel_end_latitude_dd numeric Longitude at the vessel when sampling commences (net touchdown for trawling).
100
program varchar type of fram program
100
station_code varchar unique identifier for a station definition
100
target_station_design_dim$max_depth_whid int4 maximum depth warehouse identifier
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
vessel_end_longitude_dim$longitude_in_degrees numeric numeric representation of longitude in decimal degrees
100
operation_dim$state_registration_number varchar state registration number for the vessel
100
temperature_at_surface_c_der numeric Single point estimate for surface temperature in degrees C for a haul. This has been collected in various ways over the course of the survey. It is likely that the PI-associated temperature sensor would be the most reliable; other sources would have to be evaluated for survey cycles preceding the introduction of this sensor unit. It is ordinarily expected that the depth represented by the temperature estimate be provided in association with the temperature estimate itself
100
net_width_m_der numeric Single point estimate for spread at the net wings in in meters for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best wingspread trace within the haul
100
operation_dim$operation_start_time_whid int8 start time reference for the operation
100
vessel_end_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
vessel_start_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
latitude_dim$record_type varchar latitude record type or reason record is unavailable
100
actual_station_design_dim$station_design_type varchar type of design underlying the survey station set: Transect or Grid to date
100
max_depth_m numeric high precision value of maximum depth measured in meters
100
actual_station_design_dim$transect_latitude_whid int4 latitude warehouse identifier for a design type of transect
100
operation_dim$observer_program varchar description of the observer program
100
vessel_start_longitude_dim$record_type varchar longitude record type or reason record is unavailable
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
operation_dim$coast_guard_number varchar Coast Guard documentation number of vessel
100
area_swept_ha_der numeric Product of the net width and fished distance (touchdown to liftoff distance) in hectares
100
target_station_design_dim$mean_depth_m numeric high precision value of mean depth measured in meters
100
target_station_design_dim$record_type varchar station design record or reason record is unavailable
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
sampling_end_timestamp timestamp Date and time that sampling stopped; almost exclusively the net liftoff time.
100
gear_start_latitude_whid int4 Warehouse identifier for gear start latitude
100
vessel_end_latitude_dim$record_type varchar latitude record type or reason record is unavailable
100
gear_end_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
temperature_at_gear_c_der numeric Single point estimate for temperature in degrees C at the gear for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best temperature sensor trace within the haul
100
vessel_end_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
vessel_start_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
target_station_design_dim$upper_right_latitude_whid int4 upper right latitude warehouse identifier for a design type of grid
100
sampling_start_time_dim$record_type varchar time record or reason record is unavailable
100
operation_dim$departure_date_whid int8 date reference that vessel departed for the defined leg or trip
100
date_dim$month_abbrev bpchar three character representation of month in capital letters
100
vessel_end_longitude_whid int4 Warehouse identifier for vessel end longitude
100
vessel_start_latitude_dim$record_type varchar latitude record type or reason record is unavailable
100
vessel_start_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
vessel_start_longitude_dd numeric Latitude at the vessel when sampling ceases (net liftoff for trawling).
100
longitude_dd numeric numeric representation of longitude in decimal degrees
100
station_ur_lon_dd numeric high precision value of upper right longitude of design type grid measured in decimal degrees
100
operation_dim$operation_end_date_whid int8 end date reference for the operation
100
tow_end_timestamp timestamp operation end date timestamp
100
operation_dim$scientist_3_person_whid int4 person reference for the third scientist
100
vessel_start_latitude_dim$latitude_in_degrees numeric numeric representation of latitude in degrees
100
actual_station_design_dim$max_depth_whid int4 maximum depth warehouse identifier
100
longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
operation_dim$return_date_whid int8 date reference that vessel returned for the defined leg or trip
100
latitude_dim$named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
haul_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
year int2 operation year
100
target_station_design_dim$transect_latitude_whid int4 latitude warehouse identifier for a design type of transect
100
latitude_hi_prec_dd numeric The latitude portion of a derived single point position for a haul in decimal degrees. Expected to be used generally for making spatial decisions about a haul or mapping it as a single point
100
target_station_design_dim$upper_left_latitude_whid int4 upper left latitude warehouse identifier for a design type of grid
100
operation_dim$operation_end_time_whid int8 end time reference for the operation
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
target_station_design_dim$upper_left_longitude_whid int4 upper left longitude warehouse identifier for a design type of grid
100
station_ul_lat_dd numeric high precision value of upper left latitude of design type grid measured in decimal degrees
100
fluorescence_at_surface_mg_per_m3_der numeric Single point fluorescence estimate for a haul in micrograms of chlorophyll per liter. This estimate has not been computed to date; it is unknow what the best estimator would be, but likely a simple mean would be appropriate
100
vessel_start_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
seafloor_depth_whid int4 warehouse identifier for seafloor depth
100
vessel varchar name of the vessel used for the operation
100
leg int2 leg number of the survey
100
gear_start_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
vessel_end_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
actual_station_design_dim$transect_latitude_dd numeric high precision value of transect latitude measured in decimal degrees
100
net_liftoff_time time military time representation of the time
100
depth_hi_prec_m numeric Single point estimate for seafloor depth representing the overall seafloor depth in meters for the haul. The standard up through present has been the single point estimate of gear depth summed with the single point estimate of net height in meters
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
vessel_start_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
date_dim$record_type varchar date, month, or year record or reason record is unavailable
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
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
sample_duration_hr_der numeric Difference in hours between the net liftoff and touchdown times
100
longitude_dim$longitude_in_degrees numeric numeric representation of longitude in decimal degrees
100
vessel_start_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
date_dim$full_date timestamp full date value
100
operation_dim$ifq_account_number varchar unique number assigned to user accounts in the Vessel Accounting Database
100
gear_start_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
vessel_end_latitude_whid int4 Warehouse identifier for vessel end latitude
100
station_ll_lon_dd numeric high precision value of lower left longitude of design type grid measured in decimal degrees
100
target_station_design_dim$area_hectares numeric station area measured in hectares
100
gear_end_latitude_dim$named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
gear_end_latitude_dim$record_type varchar latitude record type or reason record is unavailable
100
vessel_start_latitude_dim$named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
gear_end_latitude_dim$latitude_compass_direction bpchar latitude compass direction
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
actual_station_design_dim$active_polygon_dd polygon collection of vertices of the usuable area inside a station grid measured in decimal degrees
100
gear_start_longitude_dd numeric Longitude at the gear when sampling commences (net touchdown for trawling).
100
actual_station_design_dim$lower_right_longitude_whid int4 lower right longitude warehouse identifier for a design type of grid
100
distance_start2hb_m_der numeric Estimate of the distance traveled by the trawl net during the period preceeding the start of net haulback (net touchdown to start of haulback period) in meters. Expected to be estimated from a hierarchy of methods favoring the use of gear positions derived by the ITI or from its bearing and horizontal range traces
100
target_station_design_dim$transect_latitude_dd numeric high precision value of transect latitude measured in decimal degrees
100
target_station_design_dim$lower_right_latitude_whid int4 lower right latitude warehouse identifier for a design type of grid
100
longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
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 int8 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
vessel_start_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
100
mean_seafloor_dep_position_type varchar Method used for deriving the seafloor depth single point
100
target_station_design_whid int4 warehouse identifier for target station design
100
vessel_end_latitude_dim$named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
actual_station_design_dim$transect_station_longitude_whid int4 longitude on transect warehouse identifier for a design type of transect
100
actual_station_design_dim$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
operation_dim$departure_port_whid int4 port reference for the departure port
100
haul_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
vessel_end_latitude_dim$latitude_compass_direction bpchar latitude compass direction
100
vertebrate_weight_kg numeric Total catch vertebrate weight in kilograms
100
vessel_start_longitude_whid int4 Warehouse identifier for vessel start longitude
100
haul_latitude_dim$record_type varchar latitude record type or reason record is unavailable
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
turbidity_ntu_der numeric Single point turbidity estimate for a haul in ntu (nephelometric turbidity units). This estimate has not been computed to date; it is unknow what the best estimator would be
100
target_station_design_dim$lower_left_longitude_whid int4 lower left longitude warehouse identifier for a design type of grid
100
operation_dim$scientist_2_person_whid int4 person reference for the second scientist
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$lower_left_longitude_dd numeric high precision value of lower left longitude of design type grid measured in decimal degrees
100
net_touchdown_time time military time representation of the time
100
longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
operation_dim$vessel_id int2 field database vessel id number
100
sampling_start_time_dim$period bpchar period of time
100
gear_start_latitude_dd numeric Latitude at the gear when sampling commences (net touchdown for trawling).
100
gear_end_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
gear_end_longitude_dd numeric Longitude at the gear when sampling ceases (net liftoff for trawling).
100
gear_start_latitude_dim$latitude_compass_direction bpchar latitude compass direction
100
haul_latitude_whid int4 warehouse identifier for haul latitude
100
invertebrate_weight_kg numeric Total catch invertebrate weight in kilograms
100
trawl_id int8 identifier for a sampling operation
100
operation_dim$operation_start_date_whid int8 start date reference for the operation
100
target_station_design_dim$min_latitude_dd numeric high precision value of minimum latitude measured in decimal degrees
100
gear_start_latitude_dim$record_type varchar latitude record type or reason record is unavailable
100
gear_start_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
gear_start_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100
gear_start_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
haul_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
100
vessel_end_latitude_dim$latitude_in_degrees numeric numeric representation of latitude in degrees
100
sampling_start_time_dim$hour int2 standard representation of the hour
100
actual_station_design_dim$mean_depth_m numeric high precision value of mean depth measured in meters
100
gear_end_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
actual_station_design_dim$max_depth_m numeric high precision value of maximum depth measured in meters
100
gear_end_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
tow_start_timestamp timestamp operation start date timestamp
100
actual_station_design_dim$mean_depth_whid int4 mean depth warehouse identifier
100
distance_start2end_m_der numeric Estimate of the distance traveled by the trawl net during the period it was fully in contact with the seafloor (net touchdown to liftoff period) in meters. Expected to be estimated from a hierarchy of methods favoring the use of gear positions derived by the ITI or from its bearing and horizontal range traces
100
station_lr_lat_dd numeric high precision value of lower right latitude of design type grid measured in decimal degrees
100
actual_station_design_dim$min_latitude_dd numeric high precision value of minimum latitude measured in decimal degrees
100
target_station_design_dim$max_latitude_dd numeric high precision value of maximum latitude measured in decimal degrees
100
sampling_end_time_whid int8 warehouse identifier for the sampling end time
100
longitude_hi_prec_dd numeric The longitude portion of a derived single point position for a haul in decimal degrees. Expected to be used generally for making spatial decisions about a haul or mapping it as a single point
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
sampling_start_timestamp timestamp Date and time that sampling began; almost exclusively the net touchdown time.
100
operation_dim$fpc_person_whid int4 person reference for the FPC
100
operation_dim_whid int4 warehouse identifier for operation
100
target_station_design_dim$station_grid_dd polygon collection of vertices of grid points of a grid design measured in decimal degrees
100
sampling_end_time_dim$record_type varchar time record or reason record is unavailable
100
vessel_start_longitude_dim$longitude_in_degrees numeric numeric representation of longitude in decimal degrees
100
vessel_start_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
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
vessel_end_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
100
haul_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
actual_station_design_dim$max_latitude_whid int4 maximum latitude warehouse identifier for a design type of transect
100
vessel_start_latitude_dim$latitude_compass_direction bpchar latitude compass direction
100
gear_start_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
date_dim$day_of_month int2 numeric representation of the day in month
100
latitude_dim$latitude_in_degrees numeric numeric representation of latitude in degrees
100
sampling_start_time_dim$minute int2 number of minutes in the hour
100
latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
gear_start_latitude_dim$named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
seafloor_depth_dim$record_type varchar depth record or reason record is unavailable
100
actual_station_design_dim$lower_left_longitude_whid int4 lower left longitude warehouse identifier for a design type of grid
100
project varchar project name
100
sampling_start_time_dim$military_hour int2 military representation of the hour
100
reason_stn_invalid varchar reason station was invalidated, multiple reasons are comma separated
100
gear_end_latitude_whid int4 Warehouse identifier for gear end latitude
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
midtow_lat_named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
haul_longitude_whid int4 warehouse identifier for haul longitude
100
sampling_end_time_dim$minute int2 number of minutes in the hour
100
vessel_end_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
actual_station_design_dim$lower_right_longitude_dd numeric high precision value of lower right longitude of design type grid measured in decimal degrees
100
actual_station_design_dim$min_depth_m numeric high precision value of minimum depth measured in meters
100
gear_end_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100
gear_end_longitude_whid int4 Warehouse identifier for gear end longitude
100
actual_station_design_dim$lower_left_latitude_whid int4 lower left latitude warehouse identifier for a design type of grid
100
net_height_m_der numeric Single point estimate for net height at the net wings in in meters for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best height trace within the haul. It should be noted that the candidate traces for this estimate are the ITI headrope to footrope height and the PI headrope to bottom height sensor traces
100
operation_dim$scientist_4_person_whid int4 person reference for the fourth scientist
100
actual_station_design_dim$min_depth_whid int4 minimum depth warehouse identifier
100
sampling_end_time_dim$military_hour int2 military representation of the hour
100
actual_station_design_dim$min_latitude_whid int4 minimum latitude warehouse identifier for a design type of transect
100
vessel_end_longitude_dd numeric Longitude at the vessel when sampling ceases (net touchdown for trawling).
100
actual_station_design_whid int4 warehouse identifier for station design
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
actual_station_design_dim$upper_left_longitude_whid int4 upper left longitude warehouse identifier for a design type of grid
100
gear_end_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
haul_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
date_dim$month_of_year int2 numeric representation of month of year
100
vessel_end_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
door_width_m_der numeric Single point estimate for spread at the doors in meters for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best (only, to date) doorspread trace within the haul
100
operation_dim$limited_entry_permit_number bpchar federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California
100
operation_dim$trip_id int4 trip identifier number
100
target_station_design_dim$station_design_name varchar name of the design for a collection of stations
100
gear_start_longitude_whid int4 Warehouse identifier for gear start longitude
100
latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100
gear_start_latitude_dim$latitude_in_degrees numeric numeric representation of latitude in degrees

Attribute Details

actual_station_design_dim$transect_station_longitude_dd

CC ID: 377167
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

high precision value of transect station longitude measured in decimal degrees

Unit of Measure: dd

operation_dim$return_port_whid

CC ID: 377168
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

port reference for return port

distance_hb2end_m_der

CC ID: 377169
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Estimate of the distance traveled by the trawl net during the period following the start of net haulback (start of haulback to net liftoff period) in meters. Expected to be estimated from a hierarchy of methods favoring the use of gear positions derived by the ITI or from its bearing and horizontal range traces, including input from some form of gyrocompass

Unit of Measure: m

performance

CC ID: 377170
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

performance of the operation

Allowed Values: Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null]

actual_station_design_dim$upper_right_latitude_whid

CC ID: 377171
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

nonspecific_organics_weight_kg

CC ID: 377172
Data Storage Type: numeric
Max Length: 16
Required: No
Primary Key: No
Precision: 3
Status: Active
Description:

Total non-specific organics weight in kilograms

Unit of Measure: kg

gear_start_longitude_dim$longitude_minute_units

CC ID: 377173
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

vessel_start_latitude_dim$latitude_second_units

CC ID: 377174
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

actual_station_design_dim$upper_right_longitude_whid

CC ID: 377175
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

gear_depth_m_der

CC ID: 377176
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Single point estimate for depth at the gear in meters for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration from the best depth sensor trace within the haul

Unit of Measure: m

sampling_end_time_dim$hour

CC ID: 377177
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

o2_at_gear_ml_per_l_der

CC ID: 377178
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Single point estimate for oxygen concentration in milliliters/Liter at the gear for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best oxygen concentration sensor trace within the haul

Unit of Measure: ml/l

sampling_start_hhmmss

CC ID: 377179
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

gear_start_latitude_dim$latitude_in_degree_minute_second

CC ID: 377180
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

gear_end_latitude_dd

CC ID: 377181
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

Latitude at the gear when sampling ceases (net liftoff for trawling).

Unit of Measure: dd

target_station_design_dim$stn_invalid_for_trawl_date_whid

CC ID: 377182
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

station design invalidation date warehouse identifier

operation_dim$scientist_1_person_whid

CC ID: 377183
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the first scientist

mean_seafloor_dep_boundary

CC ID: 377184
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

actual_station_design_dim$variance_depth_m2

CC ID: 377185
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

high precision value of variance depth mesured in squared meters

Unit of Measure: m2

target_station_design_dim$variance_depth_m2

CC ID: 377186
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

vessel_start_latitude_whid

CC ID: 377187
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for vessel start latitude

target_station_design_dim$min_depth_whid

CC ID: 377188
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

minimum depth warehouse identifier

gear_end_latitude_dim$latitude_in_degrees

CC ID: 377189
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

salinity_at_gear_psu_der

CC ID: 377190
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Single point estimate for salinity in degrees C at the gear for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best salinity sensor trace within the haul. This CTD sensor trace is ordinarily subjected to a skew filter followed by a weighted mean algorithm rather than a simple descriptive mean calculation

Unit of Measure: psu

target_station_design_dim$transect_station_longitude_dd

CC ID: 377191
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

station_ul_lon_dd

CC ID: 377192
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

actual_station_design_dim$lower_right_latitude_whid

CC ID: 377193
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

actual_station_design_dim$max_latitude_dd

CC ID: 377194
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

target_station_design_dim$max_latitude_whid

CC ID: 377195
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

vessel_end_longitude_dim$longitude_minute_units

CC ID: 377196
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

actual_station_design_dim$upper_right_latitude_dd

CC ID: 377197
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

pass

CC ID: 377198
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

pass number of the survey

Allowed Values: 1,2,3,4

sampling_end_time_dim$period

CC ID: 377199
Data Storage Type: bpchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time

Allowed Values: AM, PM

actual_station_design_dim$reason_station_invalid

CC ID: 377200
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

gear_start_longitude_dim$longitude_compass_direction

CC ID: 377201
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

longitude compass direction

Allowed Values: E, W

vessel_start_latitude_dd

CC ID: 377202
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

Latitude at the vessel when sampling commences (net touchdown for trawling).

Unit of Measure: dd

date_whid

CC ID: 377203
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for date

actual_station_design_dim$area_hectares

CC ID: 377204
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

gear_end_longitude_dim$longitude_in_degrees

CC ID: 377205
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

actual_station_design_dim$upper_left_latitude_whid

CC ID: 377206
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

midtow_position_type

CC ID: 377207
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Method used for deriving the haul latitude/longitude single point

Allowed Values: Gear Net Touchdown, Gear Start Haulback, Gear Track Midpoint, Station-defined Midpoint, Vessel Abort, Vessel Net Touchdown, Vessel Operation End, Vessel Operation Start, Vessel Start Haulback, Vessel Track Midpoint

target_station_design_dim$min_latitude_whid

CC ID: 377208
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

centroid_id

CC ID: 377209
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.

vessel_end_longitude_dim$longitude_degree_units

CC ID: 377210
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

gear_end_longitude_dim$longitude_minute_units

CC ID: 377211
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

operation_dim$field_operation_seg_id

CC ID: 377212
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

vessel_end_latitude_dim$latitude_second_units

CC ID: 377213
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

latitude_dim$latitude_degree_units

CC ID: 377214
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

depth_m

CC ID: 377215
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)

Unit of Measure: m
Allowed Values: 0-1500

target_station_design_dim$upper_right_longitude_whid

CC ID: 377216
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

upper right longitude warehouse identifier for a design type of grid

target_station_design_dim$mean_depth_whid

CC ID: 377217
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

mean depth warehouse identifier

target_station_design_dim$station_design_type

CC ID: 377218
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

gear_start_latitude_dim$latitude_degree_units

CC ID: 377219
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

station_ur_lat_dd

CC ID: 377220
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

gear_end_longitude_dim$longitude_second_units

CC ID: 377221
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the second unit only

Unit of Measure: sec
Allowed Values: 0-59

haul_longitude_dim$longitude_minute_units

CC ID: 377222
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

haul_latitude_dim$latitude_second_units

CC ID: 377223
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

station_ll_lat_dd

CC ID: 377224
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

gear_start_longitude_dim$longitude_in_degrees

CC ID: 377225
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

actual_station_design_dim$upper_left_longitude_dd

CC ID: 377226
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

station_lr_lon_dd

CC ID: 377227
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

sampling_end_time_dim$second

CC ID: 377228
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of seconds in the minute

Unit of Measure: sec
Allowed Values: 0-60

haul_longitude_dim$record_type

CC ID: 377229
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

vessel_end_longitude_dim$record_type

CC ID: 377230
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

latitude_dim$latitude_compass_direction

CC ID: 377231
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

gear_end_latitude_dim$latitude_degree_units

CC ID: 377232
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

gear_end_latitude_dim$latitude_in_degree_minute_second

CC ID: 377233
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

vessel_end_latitude_dd

CC ID: 377234
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

Longitude at the vessel when sampling commences (net touchdown for trawling).

Unit of Measure: dd

program

CC ID: 377235
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

station_code

CC ID: 377236
Data Storage Type: varchar
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

unique identifier for a station definition

target_station_design_dim$max_depth_whid

CC ID: 377237
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

maximum depth warehouse identifier

depth_ftm

CC ID: 377238
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

vessel_end_longitude_dim$longitude_in_degrees

CC ID: 377239
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

operation_dim$state_registration_number

CC ID: 377240
Data Storage Type: varchar
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

state registration number for the vessel

temperature_at_surface_c_der

CC ID: 377241
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Single point estimate for surface temperature in degrees C for a haul. This has been collected in various ways over the course of the survey. It is likely that the PI-associated temperature sensor would be the most reliable; other sources would have to be evaluated for survey cycles preceding the introduction of this sensor unit. It is ordinarily expected that the depth represented by the temperature estimate be provided in association with the temperature estimate itself

Unit of Measure: c

net_width_m_der

CC ID: 377242
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Single point estimate for spread at the net wings in in meters for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best wingspread trace within the haul

Unit of Measure: m

operation_dim$operation_start_time_whid

CC ID: 377243
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

start time reference for the operation

vessel_end_longitude_dim$longitude_compass_direction

CC ID: 377244
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

longitude compass direction

Allowed Values: E, W

vessel_start_latitude_dim$latitude_minute_units

CC ID: 377245
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the minute unit only

Unit of Measure: min
Allowed Values: 0-60

latitude_dim$record_type

CC ID: 377246
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

latitude record type or reason record is unavailable

Unit of Measure: NA
Allowed Values: Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

actual_station_design_dim$station_design_type

CC ID: 377247
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

max_depth_m

CC ID: 377248
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

actual_station_design_dim$transect_latitude_whid

CC ID: 377249
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

operation_dim$observer_program

CC ID: 377250
Data Storage Type: varchar
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

description of the observer program

vessel_start_longitude_dim$record_type

CC ID: 377251
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

date_dim$year

CC ID: 377252
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

Allowed Values: 1978+

actual_station_design_dim$centroid_id

CC ID: 377253
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.

operation_dim$coast_guard_number

CC ID: 377254
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Coast Guard documentation number of vessel

area_swept_ha_der

CC ID: 377255
Data Storage Type: numeric
Max Length: 16
Required: No
Primary Key: No
Precision: 12
Status: Active
Description:

Product of the net width and fished distance (touchdown to liftoff distance) in hectares

Unit of Measure: ha

target_station_design_dim$mean_depth_m

CC ID: 377256
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

target_station_design_dim$record_type

CC ID: 377257
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

station design record or reason record is unavailable

Allowed Values: Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

date_yyyymmdd

CC ID: 377258
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

haul_latitude_dim$latitude_in_degree_minute_second

CC ID: 377259
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of latitude in degrees, minutes, and seconds for example 4525'01"

Unit of Measure: NA
Allowed Values: any

haul_latitude_dim$latitude_compass_direction

CC ID: 377260
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

sampling_end_timestamp

CC ID: 377261
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

Date and time that sampling stopped; almost exclusively the net liftoff time.

gear_start_latitude_whid

CC ID: 377262
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for gear start latitude

vessel_end_latitude_dim$record_type

CC ID: 377263
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

gear_end_longitude_dim$longitude_compass_direction

CC ID: 377264
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

longitude compass direction

Allowed Values: E, W

temperature_at_gear_c_der

CC ID: 377265
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Single point estimate for temperature in degrees C at the gear for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best temperature sensor trace within the haul

Unit of Measure: c

vessel_end_longitude_dim$longitude_in_degree_minute_second

CC ID: 377266
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of longitude in degrees, minutes, and seconds for example 4525'01"

longitude_dim$record_type

CC ID: 377267
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

vessel_start_latitude_dim$latitude_in_degree_minute_second

CC ID: 377268
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

target_station_design_dim$upper_right_latitude_whid

CC ID: 377269
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

sampling_start_time_dim$record_type

CC ID: 377270
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$departure_date_whid

CC ID: 377271
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

date_dim$month_abbrev

CC ID: 377272
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

vessel_end_longitude_whid

CC ID: 377273
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for vessel end longitude

vessel_start_latitude_dim$record_type

CC ID: 377274
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

vessel_start_longitude_dim$longitude_in_degree_minute_second

CC ID: 377275
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of longitude in degrees, minutes, and seconds for example 4525'01"

vessel_start_longitude_dd

CC ID: 377276
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

Latitude at the vessel when sampling ceases (net liftoff for trawling).

Unit of Measure: dd

longitude_dd

CC ID: 377277
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

station_ur_lon_dd

CC ID: 377278
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

operation_dim$operation_end_date_whid

CC ID: 377279
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

end date reference for the operation

tow_end_timestamp

CC ID: 377280
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

operation end date timestamp

operation_dim$scientist_3_person_whid

CC ID: 377281
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the third scientist

vessel_start_latitude_dim$latitude_in_degrees

CC ID: 377282
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$max_depth_whid

CC ID: 377283
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

maximum depth warehouse identifier

longitude_dim$longitude_in_degree_minute_second

CC ID: 377284
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of longitude in degrees, minutes, and seconds for example 4525'01"

operation_dim$return_date_whid

CC ID: 377285
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

latitude_dim$named_parallel

CC ID: 377286
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

haul_longitude_dim$longitude_compass_direction

CC ID: 377287
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

longitude compass direction

Allowed Values: E, W

year

CC ID: 377288
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+

target_station_design_dim$transect_latitude_whid

CC ID: 377289
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

latitude_hi_prec_dd

CC ID: 377290
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

The latitude portion of a derived single point position for a haul in decimal degrees. Expected to be used generally for making spatial decisions about a haul or mapping it as a single point

Unit of Measure: dd

target_station_design_dim$upper_left_latitude_whid

CC ID: 377291
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

operation_dim$operation_end_time_whid

CC ID: 377292
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

end time reference for the operation

min_depth_m

CC ID: 377293
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

high precision value of minimum depth measured in meters

Unit of Measure: m

year_stn_invalid

CC ID: 377294
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

target_station_design_dim$upper_left_longitude_whid

CC ID: 377295
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_ul_lat_dd

CC ID: 377296
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

fluorescence_at_surface_mg_per_m3_der

CC ID: 377297
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Single point fluorescence estimate for a haul in micrograms of chlorophyll per liter. This estimate has not been computed to date; it is unknow what the best estimator would be, but likely a simple mean would be appropriate

Unit of Measure: mg/m3

vessel_start_longitude_dim$longitude_compass_direction

CC ID: 377298
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

longitude compass direction

Allowed Values: E, W

seafloor_depth_whid

CC ID: 377299
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for seafloor depth

vessel

CC ID: 377300
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

leg

CC ID: 377301
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

leg number of the survey

Allowed Values: 1,2,3,4,5,6,7,8

gear_start_latitude_dim$latitude_minute_units

CC ID: 377302
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the minute unit only

Unit of Measure: min
Allowed Values: 0-60

vessel_end_longitude_dim$longitude_second_units

CC ID: 377303
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the second unit only

Unit of Measure: sec
Allowed Values: 0-59

actual_station_design_dim$transect_latitude_dd

CC ID: 377304
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

net_liftoff_time

CC ID: 377305
Data Storage Type: time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

depth_hi_prec_m

CC ID: 377306
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Single point estimate for seafloor depth representing the overall seafloor depth in meters for the haul. The standard up through present has been the single point estimate of gear depth summed with the single point estimate of net height in meters

Unit of Measure: m

target_station_design_dim$transect_station_longitude_whid

CC ID: 377307
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

longitude on transect warehouse identifier for a design type of transect

actual_station_design_dim$station_grid_dd

CC ID: 377308
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

vessel_start_longitude_dim$longitude_degree_units

CC ID: 377309
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

date_dim$record_type

CC ID: 377310
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_latitude_dd

CC ID: 377311
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

operation_dim$captain_person_whid

CC ID: 377312
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the vessel captain

target_station_design_dim$lower_left_latitude_whid

CC ID: 377313
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

sample_duration_hr_der

CC ID: 377314
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 6
Status: Active
Description:

Difference in hours between the net liftoff and touchdown times

Unit of Measure: hr

longitude_dim$longitude_in_degrees

CC ID: 377315
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

vessel_start_longitude_dim$longitude_second_units

CC ID: 377316
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the second unit only

Unit of Measure: sec
Allowed Values: 0-59

date_dim$full_date

CC ID: 377317
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

operation_dim$ifq_account_number

CC ID: 377318
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

gear_start_longitude_dim$record_type

CC ID: 377319
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

vessel_end_latitude_whid

CC ID: 377320
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for vessel end latitude

station_ll_lon_dd

CC ID: 377321
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

target_station_design_dim$area_hectares

CC ID: 377322
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

gear_end_latitude_dim$named_parallel

CC ID: 377323
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

gear_end_latitude_dim$record_type

CC ID: 377324
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

vessel_start_latitude_dim$named_parallel

CC ID: 377325
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

gear_end_latitude_dim$latitude_compass_direction

CC ID: 377326
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

target_station_design_dim$active_polygon_dd

CC ID: 377327
Data Storage Type: polygon
Required: No
Primary Key: No
Status: Active
Description:

collection of vertices of the usuable area inside a station grid measured in decimal degrees

Unit of Measure: dd

actual_station_design_dim$active_polygon_dd

CC ID: 377328
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

gear_start_longitude_dd

CC ID: 377329
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

Longitude at the gear when sampling commences (net touchdown for trawling).

Unit of Measure: dd

actual_station_design_dim$lower_right_longitude_whid

CC ID: 377330
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

distance_start2hb_m_der

CC ID: 377331
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Estimate of the distance traveled by the trawl net during the period preceeding the start of net haulback (net touchdown to start of haulback period) in meters. Expected to be estimated from a hierarchy of methods favoring the use of gear positions derived by the ITI or from its bearing and horizontal range traces

Unit of Measure: m

target_station_design_dim$transect_latitude_dd

CC ID: 377332
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

high precision value of transect latitude measured in decimal degrees

Unit of Measure: dd

target_station_design_dim$lower_right_latitude_whid

CC ID: 377333
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

longitude_dim$longitude_minute_units

CC ID: 377334
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

sampling_start_time_dim$second

CC ID: 377335
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of seconds in the minute

Unit of Measure: sec
Allowed Values: 0-60

actual_station_design_dim$station_invalid_survey_year

CC ID: 377336
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Survey year the station became invalid for trawl

Unit of Measure: year
Allowed Values: Any

sampling_start_time_whid

CC ID: 377337
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for the sampling start time

target_station_design_dim$lower_right_longitude_whid

CC ID: 377338
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

vessel_start_latitude_dim$latitude_degree_units

CC ID: 377339
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

mean_seafloor_dep_position_type

CC ID: 377340
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Method used for deriving the seafloor depth single point

Allowed Values: Bottom Depth, Gross Operation Depth, Headrope Depth, Station-defined Midpoint

target_station_design_whid

CC ID: 377341
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for target station design

vessel_end_latitude_dim$named_parallel

CC ID: 377342
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

longitude_dim$longitude_second_units

CC ID: 377343
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the second unit only

Unit of Measure: sec
Allowed Values: 0-59

actual_station_design_dim$transect_station_longitude_whid

CC ID: 377344
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_code

CC ID: 377345
Data Storage Type: varchar
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

unique identifier for a station definition

latitude_dd

CC ID: 377346
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

numeric representation of latitude in degrees

Unit of Measure: dd
Allowed Values: -90 to 90

actual_station_design_dim$station_design_name

CC ID: 377347
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

name of the design for a collection of stations

operation_dim$departure_port_whid

CC ID: 377348
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

port reference for the departure port

haul_longitude_dim$longitude_degree_units

CC ID: 377349
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

vessel_end_latitude_dim$latitude_compass_direction

CC ID: 377350
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

vertebrate_weight_kg

CC ID: 377351
Data Storage Type: numeric
Max Length: 16
Required: No
Primary Key: No
Precision: 3
Status: Active
Description:

Total catch vertebrate weight in kilograms

Unit of Measure: kg

vessel_start_longitude_whid

CC ID: 377352
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for vessel start longitude

haul_latitude_dim$record_type

CC ID: 377353
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

latitude record type or reason record is unavailable

Unit of Measure: NA
Allowed Values: Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

actual_station_design_dim$upper_left_latitude_dd

CC ID: 377354
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

turbidity_ntu_der

CC ID: 377355
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Single point turbidity estimate for a haul in ntu (nephelometric turbidity units). This estimate has not been computed to date; it is unknow what the best estimator would be

Unit of Measure: ntu

target_station_design_dim$lower_left_longitude_whid

CC ID: 377356
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

lower left longitude warehouse identifier for a design type of grid

Unit of Measure: unspecified
Allowed Values: Any

operation_dim$scientist_2_person_whid

CC ID: 377357
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the second scientist

actual_station_design_dim$upper_right_longitude_dd

CC ID: 377358
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$lower_left_longitude_dd

CC ID: 377359
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

net_touchdown_time

CC ID: 377360
Data Storage Type: time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

longitude_dim$longitude_degree_units

CC ID: 377361
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

operation_dim$vessel_id

CC ID: 377362
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

field database vessel id number

sampling_start_time_dim$period

CC ID: 377363
Data Storage Type: bpchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time

Allowed Values: AM, PM

gear_start_latitude_dd

CC ID: 377364
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

Latitude at the gear when sampling commences (net touchdown for trawling).

Unit of Measure: dd

gear_end_longitude_dim$longitude_degree_units

CC ID: 377365
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

gear_end_longitude_dd

CC ID: 377366
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

Longitude at the gear when sampling ceases (net liftoff for trawling).

Unit of Measure: dd

gear_start_latitude_dim$latitude_compass_direction

CC ID: 377367
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

haul_latitude_whid

CC ID: 377368
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for haul latitude

invertebrate_weight_kg

CC ID: 377369
Data Storage Type: numeric
Max Length: 16
Required: No
Primary Key: No
Precision: 3
Status: Active
Description:

Total catch invertebrate weight in kilograms

Unit of Measure: kg

trawl_id

CC ID: 377370
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

identifier for a sampling operation

operation_dim$operation_start_date_whid

CC ID: 377371
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

start date reference for the operation

target_station_design_dim$min_latitude_dd

CC ID: 377372
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

gear_start_latitude_dim$record_type

CC ID: 377373
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

gear_start_longitude_dim$longitude_degree_units

CC ID: 377374
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

gear_start_latitude_dim$latitude_second_units

CC ID: 377375
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

gear_start_longitude_dim$longitude_second_units

CC ID: 377376
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the second unit only

Unit of Measure: sec
Allowed Values: 0-59

haul_latitude_dim$latitude_degree_units

CC ID: 377377
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

vessel_end_latitude_dim$latitude_in_degrees

CC ID: 377378
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

sampling_start_time_dim$hour

CC ID: 377379
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

standard representation of the hour

Unit of Measure: hr
Allowed Values: 0-12

actual_station_design_dim$mean_depth_m

CC ID: 377380
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

gear_end_longitude_dim$longitude_in_degree_minute_second

CC ID: 377381
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of longitude in degrees, minutes, and seconds for example 4525'01"

actual_station_design_dim$max_depth_m

CC ID: 377382
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

gear_end_longitude_dim$record_type

CC ID: 377383
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

latitude_dim$latitude_minute_units

CC ID: 377384
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the minute unit only

Unit of Measure: min
Allowed Values: 0-60

tow_start_timestamp

CC ID: 377385
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

operation start date timestamp

actual_station_design_dim$mean_depth_whid

CC ID: 377386
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

mean depth warehouse identifier

distance_start2end_m_der

CC ID: 377387
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Estimate of the distance traveled by the trawl net during the period it was fully in contact with the seafloor (net touchdown to liftoff period) in meters. Expected to be estimated from a hierarchy of methods favoring the use of gear positions derived by the ITI or from its bearing and horizontal range traces

Unit of Measure: m

station_lr_lat_dd

CC ID: 377388
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

actual_station_design_dim$min_latitude_dd

CC ID: 377389
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

target_station_design_dim$max_latitude_dd

CC ID: 377390
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

sampling_end_time_whid

CC ID: 377391
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for the sampling end time

longitude_hi_prec_dd

CC ID: 377392
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

The longitude portion of a derived single point position for a haul in decimal degrees. Expected to be used generally for making spatial decisions about a haul or mapping it as a single point

Unit of Measure: dd

operation_dim$record_type

CC ID: 377393
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

operation record or reason record is unavailable

Allowed Values: Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

sampling_end_hhmmss

CC ID: 377394
Data Storage Type: bpchar
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

concatenation of military hour, minute, second, example 230415 equates to 23:04:15

date_dim$month_name

CC ID: 377395
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

sampling_start_timestamp

CC ID: 377396
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

Date and time that sampling began; almost exclusively the net touchdown time.

operation_dim$fpc_person_whid

CC ID: 377397
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the FPC

operation_dim_whid

CC ID: 377398
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for operation

target_station_design_dim$station_grid_dd

CC ID: 377399
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

sampling_end_time_dim$record_type

CC ID: 377400
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

vessel_start_longitude_dim$longitude_in_degrees

CC ID: 377401
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

vessel_start_longitude_dim$longitude_minute_units

CC ID: 377402
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

tow

CC ID: 377403
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

operation number of the survey

actual_station_design_dim$stn_invalid_for_trawl_date_whid

CC ID: 377404
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

station design invalidation date warehouse identifier

vessel_end_latitude_dim$latitude_degree_units

CC ID: 377405
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

haul_longitude_dim$longitude_second_units

CC ID: 377406
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the second unit only

Unit of Measure: sec
Allowed Values: 0-59

actual_station_design_dim$max_latitude_whid

CC ID: 377407
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

vessel_start_latitude_dim$latitude_compass_direction

CC ID: 377408
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

gear_start_longitude_dim$longitude_in_degree_minute_second

CC ID: 377409
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of longitude in degrees, minutes, and seconds for example 4525'01"

longitude_dim$longitude_compass_direction

CC ID: 377410
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

longitude compass direction

Allowed Values: E, W

date_dim$day_of_month

CC ID: 377411
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

latitude_dim$latitude_in_degrees

CC ID: 377412
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

sampling_start_time_dim$minute

CC ID: 377413
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

latitude_dim$latitude_in_degree_minute_second

CC ID: 377414
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

gear_start_latitude_dim$named_parallel

CC ID: 377415
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

seafloor_depth_dim$record_type

CC ID: 377416
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

depth record or reason record is unavailable

Allowed Values: Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

actual_station_design_dim$lower_left_longitude_whid

CC ID: 377417
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

project

CC ID: 377418
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

sampling_start_time_dim$military_hour

CC ID: 377419
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

military representation of the hour

Allowed Values: 0-24

reason_stn_invalid

CC ID: 377420
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

gear_end_latitude_whid

CC ID: 377421
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for gear end latitude

actual_station_design_dim$lower_right_latitude_dd

CC ID: 377422
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

midtow_lat_named_parallel

CC ID: 377423
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

haul_longitude_whid

CC ID: 377424
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for haul longitude

sampling_end_time_dim$minute

CC ID: 377425
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

vessel_end_latitude_dim$latitude_in_degree_minute_second

CC ID: 377426
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of latitude in degrees, minutes, and seconds for example 4525'01"

Unit of Measure: NA
Allowed Values: any

actual_station_design_dim$lower_right_longitude_dd

CC ID: 377427
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

actual_station_design_dim$min_depth_m

CC ID: 377428
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

gear_end_latitude_dim$latitude_second_units

CC ID: 377429
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

gear_end_longitude_whid

CC ID: 377430
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for gear end longitude

actual_station_design_dim$lower_left_latitude_whid

CC ID: 377431
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

net_height_m_der

CC ID: 377432
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Single point estimate for net height at the net wings in in meters for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best height trace within the haul. It should be noted that the candidate traces for this estimate are the ITI headrope to footrope height and the PI headrope to bottom height sensor traces

Unit of Measure: m

operation_dim$scientist_4_person_whid

CC ID: 377433
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$min_depth_whid

CC ID: 377434
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

minimum depth warehouse identifier

sampling_end_time_dim$military_hour

CC ID: 377435
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

military representation of the hour

Allowed Values: 0-24

actual_station_design_dim$min_latitude_whid

CC ID: 377436
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

vessel_end_longitude_dd

CC ID: 377437
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

Longitude at the vessel when sampling ceases (net touchdown for trawling).

Unit of Measure: dd

actual_station_design_whid

CC ID: 377438
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for station design

operation_dim$operation_type

CC ID: 377439
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

type of operation

Allowed Values: CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null]

haul_latitude_dim$latitude_minute_units

CC ID: 377440
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the minute unit only

Unit of Measure: min
Allowed Values: 0-60

actual_station_design_dim$record_type

CC ID: 377441
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

station design record or reason record is unavailable

Allowed Values: Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

actual_station_design_dim$upper_left_longitude_whid

CC ID: 377442
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

gear_end_latitude_dim$latitude_minute_units

CC ID: 377443
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the minute unit only

Unit of Measure: min
Allowed Values: 0-60

haul_longitude_dim$longitude_in_degree_minute_second

CC ID: 377444
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of longitude in degrees, minutes, and seconds for example 4525'01"

date_dim$month_of_year

CC ID: 377445
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

vessel_end_latitude_dim$latitude_minute_units

CC ID: 377446
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the minute unit only

Unit of Measure: min
Allowed Values: 0-60

door_width_m_der

CC ID: 377447
Data Storage Type: numeric
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Single point estimate for spread at the doors in meters for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best (only, to date) doorspread trace within the haul

Unit of Measure: m

operation_dim$limited_entry_permit_number

CC ID: 377448
Data Storage Type: bpchar
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California

operation_dim$trip_id

CC ID: 377449
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

trip identifier number

target_station_design_dim$station_design_name

CC ID: 377450
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

name of the design for a collection of stations

gear_start_longitude_whid

CC ID: 377451
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for gear start longitude

latitude_dim$latitude_second_units

CC ID: 377452
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

gear_start_latitude_dim$latitude_in_degrees

CC ID: 377453
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

Catalog Details

Catalog Item ID: 36439
GUID: gov.noaa.nmfs.inport:36439
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-01-25 13:15+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-02-13
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-02-14