operation_haul_fact
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36439 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
actual_station_design_dim$transect_station_longitude_dd | numeric | high precision value of transect station longitude measured in decimal degrees | |
|
100
|
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 |