operation_haul_fact
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 36439
| Published / External
Created: 2017-01-25
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 18418
ID: 36439
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | operation_haul_fact |
---|---|
Short Name | |
* Status | |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract | |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description |
Operation details including dates, times, location, depths, tempuratures, etc |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | actual_station_design_dim$transect_station_longitude_dd | numeric | high precision value of transect station longitude measured in decimal degrees |
100 | No | No | operation_dim$return_port_whid | int4 | port reference for return port |
100 | No | No | 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 | No | No | performance | varchar | performance of the operation |
100 | No | No | actual_station_design_dim$upper_right_latitude_whid | int4 | upper right latitude warehouse identifier for a design type of grid |
100 | No | No | nonspecific_organics_weight_kg | numeric | Total non-specific organics weight in kilograms |
100 | No | No | gear_start_longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only |
100 | No | No | vessel_start_latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only |
100 | No | No | actual_station_design_dim$upper_right_longitude_whid | int4 | upper right longitude warehouse identifier for a design type of grid |
100 | No | No | 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 | No | No | sampling_end_time_dim$hour | int2 | standard representation of the hour |
100 | No | No | 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 | No | No | sampling_start_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
100 | No | No | gear_start_latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | gear_end_latitude_dd | numeric | Latitude at the gear when sampling ceases (net liftoff for trawling). |
100 | No | No | target_station_design_dim$stn_invalid_for_trawl_date_whid | int8 | station design invalidation date warehouse identifier |
100 | No | No | operation_dim$scientist_1_person_whid | int4 | person reference for the first scientist |
100 | No | No | mean_seafloor_dep_boundary | varchar | depth boundry indicator identifying ifp boundary marks |
100 | No | No | actual_station_design_dim$variance_depth_m2 | numeric | high precision value of variance depth mesured in squared meters |
100 | No | No | target_station_design_dim$variance_depth_m2 | numeric | high precision value of variance depth mesured in squared meters |
100 | No | No | vessel_start_latitude_whid | int4 | Warehouse identifier for vessel start latitude |
100 | No | No | target_station_design_dim$min_depth_whid | int4 | minimum depth warehouse identifier |
100 | No | No | gear_end_latitude_dim$latitude_in_degrees | numeric | numeric representation of latitude in degrees |
100 | No | No | 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 | No | No | target_station_design_dim$transect_station_longitude_dd | numeric | high precision value of transect station longitude measured in decimal degrees |
100 | No | No | station_ul_lon_dd | numeric | high precision value of upper left longitude of design type grid measured in decimal degrees |
100 | No | No | actual_station_design_dim$lower_right_latitude_whid | int4 | lower right latitude warehouse identifier for a design type of grid |
100 | No | No | actual_station_design_dim$max_latitude_dd | numeric | high precision value of maximum latitude measured in decimal degrees |
100 | No | No | target_station_design_dim$max_latitude_whid | int4 | maximum latitude warehouse identifier for a design type of transect |
100 | No | No | vessel_end_longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only |
100 | No | No | 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 | No | No | pass | int4 | pass number of the survey |
100 | No | No | sampling_end_time_dim$period | bpchar | period of time |
100 | No | No | actual_station_design_dim$reason_station_invalid | varchar | reason station was invalidated, multiple reasons are comma separated |
100 | No | No | gear_start_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction |
100 | No | No | vessel_start_latitude_dd | numeric | Latitude at the vessel when sampling commences (net touchdown for trawling). |
100 | No | No | date_whid | int8 | warehouse identifier for date |
100 | No | No | actual_station_design_dim$area_hectares | numeric | station area measured in hectares |
100 | No | No | gear_end_longitude_dim$longitude_in_degrees | numeric | numeric representation of longitude in decimal degrees |
100 | No | No | actual_station_design_dim$upper_left_latitude_whid | int4 | upper left latitude warehouse identifier for a design type of grid |
100 | No | No | midtow_position_type | varchar | Method used for deriving the haul latitude/longitude single point |
100 | No | No | target_station_design_dim$min_latitude_whid | int4 | minimum latitude warehouse identifier for a design type of transect |
100 | No | No | 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 | No | No | vessel_end_longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only |
100 | No | No | gear_end_longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only |
100 | No | No | operation_dim$field_operation_seg_id | int8 | operation segment id reference to the field operational segment table |
100 | No | No | vessel_end_latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only |
100 | No | No | latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only |
100 | No | No | depth_m | numeric | depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
100 | No | No | target_station_design_dim$upper_right_longitude_whid | int4 | upper right longitude warehouse identifier for a design type of grid |
100 | No | No | target_station_design_dim$mean_depth_whid | int4 | mean depth warehouse identifier |
100 | No | No | target_station_design_dim$station_design_type | varchar | type of design underlying the survey station set: Transect or Grid to date |
100 | No | No | gear_start_latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only |
100 | No | No | station_ur_lat_dd | numeric | high precision value of upper right latitude of design type grid measured in decimal degrees |
100 | No | No | gear_end_longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only |
100 | No | No | haul_longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only |
100 | No | No | haul_latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only |
100 | No | No | station_ll_lat_dd | numeric | high precision value of lower left latitude of design type grid measured in decimal degrees |
100 | No | No | gear_start_longitude_dim$longitude_in_degrees | numeric | numeric representation of longitude in decimal degrees |
100 | No | No | 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 | No | No | station_lr_lon_dd | numeric | high precision value of lower right longitude of design type grid measured in decimal degrees |
100 | No | No | sampling_end_time_dim$second | int2 | number of seconds in the minute |
100 | No | No | haul_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable |
100 | No | No | vessel_end_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable |
100 | No | No | latitude_dim$latitude_compass_direction | bpchar | latitude compass direction |
100 | No | No | gear_end_latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only |
100 | No | No | gear_end_latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | vessel_end_latitude_dd | numeric | Longitude at the vessel when sampling commences (net touchdown for trawling). |
100 | No | No | program | varchar | type of fram program |
100 | No | No | station_code | varchar | unique identifier for a station definition |
100 | No | No | target_station_design_dim$max_depth_whid | int4 | maximum depth warehouse identifier |
100 | No | No | 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 | No | No | vessel_end_longitude_dim$longitude_in_degrees | numeric | numeric representation of longitude in decimal degrees |
100 | No | No | operation_dim$state_registration_number | varchar | state registration number for the vessel |
100 | No | No | 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 | No | No | 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 | No | No | operation_dim$operation_start_time_whid | int8 | start time reference for the operation |
100 | No | No | vessel_end_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction |
100 | No | No | vessel_start_latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only |
100 | No | No | latitude_dim$record_type | varchar | latitude record type or reason record is unavailable |
100 | No | No | actual_station_design_dim$station_design_type | varchar | type of design underlying the survey station set: Transect or Grid to date |
100 | No | No | max_depth_m | numeric | high precision value of maximum depth measured in meters |
100 | No | No | actual_station_design_dim$transect_latitude_whid | int4 | latitude warehouse identifier for a design type of transect |
100 | No | No | operation_dim$observer_program | varchar | description of the observer program |
100 | No | No | vessel_start_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable |
100 | No | No | date_dim$year | int4 | numeric representation of year |
100 | No | No | 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 | No | No | operation_dim$coast_guard_number | varchar | Coast Guard documentation number of vessel |
100 | No | No | area_swept_ha_der | numeric | Product of the net width and fished distance (touchdown to liftoff distance) in hectares |
100 | No | No | target_station_design_dim$mean_depth_m | numeric | high precision value of mean depth measured in meters |
100 | No | No | target_station_design_dim$record_type | varchar | station design record or reason record is unavailable |
100 | No | No | date_yyyymmdd | bpchar | text representation of year month day |
100 | No | No | haul_latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | haul_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction |
100 | No | No | sampling_end_timestamp | timestamp | Date and time that sampling stopped; almost exclusively the net liftoff time. |
100 | No | No | gear_start_latitude_whid | int4 | Warehouse identifier for gear start latitude |
100 | No | No | vessel_end_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable |
100 | No | No | gear_end_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction |
100 | No | No | 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 | No | No | vessel_end_longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | longitude_dim$record_type | varchar | longitude record type or reason record is unavailable |
100 | No | No | vessel_start_latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | target_station_design_dim$upper_right_latitude_whid | int4 | upper right latitude warehouse identifier for a design type of grid |
100 | No | No | sampling_start_time_dim$record_type | varchar | time record or reason record is unavailable |
100 | No | No | operation_dim$departure_date_whid | int8 | date reference that vessel departed for the defined leg or trip |
100 | No | No | date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | vessel_end_longitude_whid | int4 | Warehouse identifier for vessel end longitude |
100 | No | No | vessel_start_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable |
100 | No | No | vessel_start_longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | vessel_start_longitude_dd | numeric | Latitude at the vessel when sampling ceases (net liftoff for trawling). |
100 | No | No | longitude_dd | numeric | numeric representation of longitude in decimal degrees |
100 | No | No | station_ur_lon_dd | numeric | high precision value of upper right longitude of design type grid measured in decimal degrees |
100 | No | No | operation_dim$operation_end_date_whid | int8 | end date reference for the operation |
100 | No | No | tow_end_timestamp | timestamp | operation end date timestamp |
100 | No | No | operation_dim$scientist_3_person_whid | int4 | person reference for the third scientist |
100 | No | No | vessel_start_latitude_dim$latitude_in_degrees | numeric | numeric representation of latitude in degrees |
100 | No | No | actual_station_design_dim$max_depth_whid | int4 | maximum depth warehouse identifier |
100 | No | No | longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | operation_dim$return_date_whid | int8 | date reference that vessel returned for the defined leg or trip |
100 | No | No | latitude_dim$named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location |
100 | No | No | haul_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction |
100 | No | No | year | int2 | operation year |
100 | No | No | target_station_design_dim$transect_latitude_whid | int4 | latitude warehouse identifier for a design type of transect |
100 | No | No | 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 | No | No | target_station_design_dim$upper_left_latitude_whid | int4 | upper left latitude warehouse identifier for a design type of grid |
100 | No | No | operation_dim$operation_end_time_whid | int8 | end time reference for the operation |
100 | No | No | min_depth_m | numeric | high precision value of minimum depth measured in meters |
100 | No | No | year_stn_invalid | int2 | Survey year the station became invalid for trawl |
100 | No | No | target_station_design_dim$upper_left_longitude_whid | int4 | upper left longitude warehouse identifier for a design type of grid |
100 | No | No | station_ul_lat_dd | numeric | high precision value of upper left latitude of design type grid measured in decimal degrees |
100 | No | No | 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 | No | No | vessel_start_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction |
100 | No | No | seafloor_depth_whid | int4 | warehouse identifier for seafloor depth |
100 | No | No | vessel | varchar | name of the vessel used for the operation |
100 | No | No | leg | int2 | leg number of the survey |
100 | No | No | gear_start_latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only |
100 | No | No | vessel_end_longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only |
100 | No | No | actual_station_design_dim$transect_latitude_dd | numeric | high precision value of transect latitude measured in decimal degrees |
100 | No | No | net_liftoff_time | time | military time representation of the time |
100 | No | No | 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 | No | No | target_station_design_dim$transect_station_longitude_whid | int4 | longitude on transect warehouse identifier for a design type of transect |
100 | No | No | actual_station_design_dim$station_grid_dd | polygon | collection of vertices of grid points of a grid design measured in decimal degrees |
100 | No | No | vessel_start_longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only |
100 | No | No | date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | 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 | No | No | operation_dim$captain_person_whid | int4 | person reference for the vessel captain |
100 | No | No | target_station_design_dim$lower_left_latitude_whid | int4 | lower left latitude warehouse identifier for a design type of grid |
100 | No | No | sample_duration_hr_der | numeric | Difference in hours between the net liftoff and touchdown times |
100 | No | No | longitude_dim$longitude_in_degrees | numeric | numeric representation of longitude in decimal degrees |
100 | No | No | vessel_start_longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only |
100 | No | No | date_dim$full_date | timestamp | full date value |
100 | No | No | operation_dim$ifq_account_number | varchar | unique number assigned to user accounts in the Vessel Accounting Database |
100 | No | No | gear_start_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable |
100 | No | No | vessel_end_latitude_whid | int4 | Warehouse identifier for vessel end latitude |
100 | No | No | station_ll_lon_dd | numeric | high precision value of lower left longitude of design type grid measured in decimal degrees |
100 | No | No | target_station_design_dim$area_hectares | numeric | station area measured in hectares |
100 | No | No | gear_end_latitude_dim$named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location |
100 | No | No | gear_end_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable |
100 | No | No | vessel_start_latitude_dim$named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location |
100 | No | No | gear_end_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction |
100 | No | No | target_station_design_dim$active_polygon_dd | polygon | collection of vertices of the usuable area inside a station grid measured in decimal degrees |
100 | No | No | actual_station_design_dim$active_polygon_dd | polygon | collection of vertices of the usuable area inside a station grid measured in decimal degrees |
100 | No | No | gear_start_longitude_dd | numeric | Longitude at the gear when sampling commences (net touchdown for trawling). |
100 | No | No | actual_station_design_dim$lower_right_longitude_whid | int4 | lower right longitude warehouse identifier for a design type of grid |
100 | No | No | 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 | No | No | target_station_design_dim$transect_latitude_dd | numeric | high precision value of transect latitude measured in decimal degrees |
100 | No | No | target_station_design_dim$lower_right_latitude_whid | int4 | lower right latitude warehouse identifier for a design type of grid |
100 | No | No | longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only |
100 | No | No | sampling_start_time_dim$second | int2 | number of seconds in the minute |
100 | No | No | actual_station_design_dim$station_invalid_survey_year | int2 | Survey year the station became invalid for trawl |
100 | No | No | sampling_start_time_whid | int8 | warehouse identifier for the sampling start time |
100 | No | No | target_station_design_dim$lower_right_longitude_whid | int4 | lower right longitude warehouse identifier for a design type of grid |
100 | No | No | vessel_start_latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only |
100 | No | No | mean_seafloor_dep_position_type | varchar | Method used for deriving the seafloor depth single point |
100 | No | No | target_station_design_whid | int4 | warehouse identifier for target station design |
100 | No | No | vessel_end_latitude_dim$named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location |
100 | No | No | longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only |
100 | No | No | actual_station_design_dim$transect_station_longitude_whid | int4 | longitude on transect warehouse identifier for a design type of transect |
100 | No | No | actual_station_design_dim$station_code | varchar | unique identifier for a station definition |
100 | No | No | latitude_dd | numeric | numeric representation of latitude in degrees |
100 | No | No | actual_station_design_dim$station_design_name | varchar | name of the design for a collection of stations |
100 | No | No | operation_dim$departure_port_whid | int4 | port reference for the departure port |
100 | No | No | haul_longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only |
100 | No | No | vessel_end_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction |
100 | No | No | vertebrate_weight_kg | numeric | Total catch vertebrate weight in kilograms |
100 | No | No | vessel_start_longitude_whid | int4 | Warehouse identifier for vessel start longitude |
100 | No | No | haul_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable |
100 | No | No | 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 | No | No | 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 | No | No | target_station_design_dim$lower_left_longitude_whid | int4 | lower left longitude warehouse identifier for a design type of grid |
100 | No | No | operation_dim$scientist_2_person_whid | int4 | person reference for the second scientist |
100 | No | No | 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 | No | No | 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 | No | No | net_touchdown_time | time | military time representation of the time |
100 | No | No | longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only |
100 | No | No | operation_dim$vessel_id | int2 | field database vessel id number |
100 | No | No | sampling_start_time_dim$period | bpchar | period of time |
100 | No | No | gear_start_latitude_dd | numeric | Latitude at the gear when sampling commences (net touchdown for trawling). |
100 | No | No | gear_end_longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only |
100 | No | No | gear_end_longitude_dd | numeric | Longitude at the gear when sampling ceases (net liftoff for trawling). |
100 | No | No | gear_start_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction |
100 | No | No | haul_latitude_whid | int4 | warehouse identifier for haul latitude |
100 | No | No | invertebrate_weight_kg | numeric | Total catch invertebrate weight in kilograms |
100 | No | No | trawl_id | int8 | identifier for a sampling operation |
100 | No | No | operation_dim$operation_start_date_whid | int8 | start date reference for the operation |
100 | No | No | target_station_design_dim$min_latitude_dd | numeric | high precision value of minimum latitude measured in decimal degrees |
100 | No | No | gear_start_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable |
100 | No | No | gear_start_longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only |
100 | No | No | gear_start_latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only |
100 | No | No | gear_start_longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only |
100 | No | No | haul_latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only |
100 | No | No | vessel_end_latitude_dim$latitude_in_degrees | numeric | numeric representation of latitude in degrees |
100 | No | No | sampling_start_time_dim$hour | int2 | standard representation of the hour |
100 | No | No | actual_station_design_dim$mean_depth_m | numeric | high precision value of mean depth measured in meters |
100 | No | No | gear_end_longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | actual_station_design_dim$max_depth_m | numeric | high precision value of maximum depth measured in meters |
100 | No | No | gear_end_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable |
100 | No | No | latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only |
100 | No | No | tow_start_timestamp | timestamp | operation start date timestamp |
100 | No | No | actual_station_design_dim$mean_depth_whid | int4 | mean depth warehouse identifier |
100 | No | No | 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 | No | No | station_lr_lat_dd | numeric | high precision value of lower right latitude of design type grid measured in decimal degrees |
100 | No | No | actual_station_design_dim$min_latitude_dd | numeric | high precision value of minimum latitude measured in decimal degrees |
100 | No | No | target_station_design_dim$max_latitude_dd | numeric | high precision value of maximum latitude measured in decimal degrees |
100 | No | No | sampling_end_time_whid | int8 | warehouse identifier for the sampling end time |
100 | No | No | 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 | No | No | operation_dim$record_type | varchar | operation record or reason record is unavailable |
100 | No | No | sampling_end_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
100 | No | No | date_dim$month_name | varchar | text representation of month |
100 | No | No | sampling_start_timestamp | timestamp | Date and time that sampling began; almost exclusively the net touchdown time. |
100 | No | No | operation_dim$fpc_person_whid | int4 | person reference for the FPC |
100 | No | No | operation_dim_whid | int4 | warehouse identifier for operation |
100 | No | No | target_station_design_dim$station_grid_dd | polygon | collection of vertices of grid points of a grid design measured in decimal degrees |
100 | No | No | sampling_end_time_dim$record_type | varchar | time record or reason record is unavailable |
100 | No | No | vessel_start_longitude_dim$longitude_in_degrees | numeric | numeric representation of longitude in decimal degrees |
100 | No | No | vessel_start_longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only |
100 | No | No | tow | int2 | operation number of the survey |
100 | No | No | actual_station_design_dim$stn_invalid_for_trawl_date_whid | int8 | station design invalidation date warehouse identifier |
100 | No | No | vessel_end_latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only |
100 | No | No | haul_longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only |
100 | No | No | actual_station_design_dim$max_latitude_whid | int4 | maximum latitude warehouse identifier for a design type of transect |
100 | No | No | vessel_start_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction |
100 | No | No | gear_start_longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | longitude_dim$longitude_compass_direction | bpchar | longitude compass direction |
100 | No | No | date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | latitude_dim$latitude_in_degrees | numeric | numeric representation of latitude in degrees |
100 | No | No | sampling_start_time_dim$minute | int2 | number of minutes in the hour |
100 | No | No | latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | gear_start_latitude_dim$named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location |
100 | No | No | seafloor_depth_dim$record_type | varchar | depth record or reason record is unavailable |
100 | No | No | actual_station_design_dim$lower_left_longitude_whid | int4 | lower left longitude warehouse identifier for a design type of grid |
100 | No | No | project | varchar | project name |
100 | No | No | sampling_start_time_dim$military_hour | int2 | military representation of the hour |
100 | No | No | reason_stn_invalid | varchar | reason station was invalidated, multiple reasons are comma separated |
100 | No | No | gear_end_latitude_whid | int4 | Warehouse identifier for gear end latitude |
100 | No | No | 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 | No | No | midtow_lat_named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location |
100 | No | No | haul_longitude_whid | int4 | warehouse identifier for haul longitude |
100 | No | No | sampling_end_time_dim$minute | int2 | number of minutes in the hour |
100 | No | No | vessel_end_latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | 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 | No | No | actual_station_design_dim$min_depth_m | numeric | high precision value of minimum depth measured in meters |
100 | No | No | gear_end_latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only |
100 | No | No | gear_end_longitude_whid | int4 | Warehouse identifier for gear end longitude |
100 | No | No | actual_station_design_dim$lower_left_latitude_whid | int4 | lower left latitude warehouse identifier for a design type of grid |
100 | No | No | 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 | No | No | operation_dim$scientist_4_person_whid | int4 | person reference for the fourth scientist |
100 | No | No | actual_station_design_dim$min_depth_whid | int4 | minimum depth warehouse identifier |
100 | No | No | sampling_end_time_dim$military_hour | int2 | military representation of the hour |
100 | No | No | actual_station_design_dim$min_latitude_whid | int4 | minimum latitude warehouse identifier for a design type of transect |
100 | No | No | vessel_end_longitude_dd | numeric | Longitude at the vessel when sampling ceases (net touchdown for trawling). |
100 | No | No | actual_station_design_whid | int4 | warehouse identifier for station design |
100 | No | No | operation_dim$operation_type | varchar | type of operation |
100 | No | No | haul_latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only |
100 | No | No | actual_station_design_dim$record_type | varchar | station design record or reason record is unavailable |
100 | No | No | actual_station_design_dim$upper_left_longitude_whid | int4 | upper left longitude warehouse identifier for a design type of grid |
100 | No | No | gear_end_latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only |
100 | No | No | haul_longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | vessel_end_latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only |
100 | No | No | 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 | No | No | operation_dim$limited_entry_permit_number | bpchar | federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California |
100 | No | No | operation_dim$trip_id | int4 | trip identifier number |
100 | No | No | target_station_design_dim$station_design_name | varchar | name of the design for a collection of stations |
100 | No | No | gear_start_longitude_whid | int4 | Warehouse identifier for gear start longitude |
100 | No | No | latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only |
100 | No | No | gear_start_latitude_dim$latitude_in_degrees | numeric | numeric representation of latitude in degrees |
Attribute Details
Attribute Name | actual_station_design_dim$transect_station_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of transect station longitude measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$return_port_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
port reference for return port |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | distance_hb2end_m_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | performance |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
performance of the operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$upper_right_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper right latitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | nonspecific_organics_weight_kg |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
Status | Active |
Description |
Total non-specific organics weight in kilograms |
General Data Type | |
Unit of Measure | kg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_longitude_dim$longitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_latitude_dim$latitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$upper_right_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper right longitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_depth_m_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$hour |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
standard representation of the hour |
General Data Type | |
Unit of Measure | hr |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | o2_at_gear_ml_per_l_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | ml/l |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_hhmmss |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_latitude_dim$latitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
Latitude at the gear when sampling ceases (net liftoff for trawling). |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$stn_invalid_for_trawl_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
station design invalidation date warehouse identifier |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$scientist_1_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the first scientist |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | mean_seafloor_dep_boundary |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
depth boundry indicator identifying ifp boundary marks |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | IFP Boundary Depth, Standard Contour Depth, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$variance_depth_m2 |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of variance depth mesured in squared meters |
General Data Type | |
Unit of Measure | m2 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$variance_depth_m2 |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of variance depth mesured in squared meters |
General Data Type | |
Unit of Measure | m2 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for vessel start latitude |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$min_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
minimum depth warehouse identifier |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_latitude_dim$latitude_in_degrees |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of latitude in degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | salinity_at_gear_psu_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | psu |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$transect_station_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of transect station longitude measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | station_ul_lon_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper left longitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$lower_right_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower right latitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$max_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of maximum latitude measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$max_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
maximum latitude warehouse identifier for a design type of transect |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_longitude_dim$longitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$upper_right_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper right latitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | pass |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
pass number of the survey |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1,2,3,4 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$period |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
period of time |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | AM, PM |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$reason_station_invalid |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
reason station was invalidated, multiple reasons are comma separated |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_longitude_dim$longitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude compass direction |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | E, W |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
Latitude at the vessel when sampling commences (net touchdown for trawling). |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier for date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$area_hectares |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
station area measured in hectares |
General Data Type | |
Unit of Measure | hectares |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_longitude_dim$longitude_in_degrees |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of longitude in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$upper_left_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper left latitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | midtow_position_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Method used for deriving the haul latitude/longitude single point |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$min_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
minimum latitude warehouse identifier for a design type of transect |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | centroid_id |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_longitude_dim$longitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_longitude_dim$longitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$field_operation_seg_id |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
operation segment id reference to the field operational segment table |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_latitude_dim$latitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | latitude_dim$latitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | depth_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-1500 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$upper_right_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper right longitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$mean_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
mean depth warehouse identifier |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$station_design_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
type of design underlying the survey station set: Transect or Grid to date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Transect, Grid |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_latitude_dim$latitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | station_ur_lat_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper right latitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_longitude_dim$longitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_longitude_dim$longitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_latitude_dim$latitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | station_ll_lat_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower left latitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_longitude_dim$longitude_in_degrees |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of longitude in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$upper_left_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper left longitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | station_lr_lon_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower right longitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$second |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of seconds in the minute |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_longitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_longitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | latitude_dim$latitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude compass direction |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N, S |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_latitude_dim$latitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_latitude_dim$latitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
Longitude at the vessel when sampling commences (net touchdown for trawling). |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | program |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
type of fram program |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Bottom Trawl, Hook and Line |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | station_code |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
unique identifier for a station definition |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$max_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
maximum depth warehouse identifier |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | depth_ftm |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
General Data Type | |
Unit of Measure | fth |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_longitude_dim$longitude_in_degrees |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of longitude in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$state_registration_number |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
state registration number for the vessel |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | temperature_at_surface_c_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | c |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | net_width_m_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$operation_start_time_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
start time reference for the operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_longitude_dim$longitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude compass direction |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | E, W |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_latitude_dim$latitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | latitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$station_design_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
type of design underlying the survey station set: Transect or Grid to date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Transect, Grid |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | max_depth_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of maximum depth measured in meters |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$transect_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
latitude warehouse identifier for a design type of transect |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$observer_program |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
description of the observer program |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_longitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$centroid_id |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$coast_guard_number |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Coast Guard documentation number of vessel |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | area_swept_ha_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 12 |
Scale | |
Status | Active |
Description |
Product of the net width and fished distance (touchdown to liftoff distance) in hectares |
General Data Type | |
Unit of Measure | ha |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$mean_depth_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of mean depth measured in meters |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
station design record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_latitude_dim$latitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_latitude_dim$latitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude compass direction |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N, S |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_timestamp |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time that sampling stopped; almost exclusively the net liftoff time. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for gear start latitude |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_latitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_longitude_dim$longitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude compass direction |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | E, W |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | temperature_at_gear_c_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | c |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_longitude_dim$longitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | longitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_latitude_dim$latitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$upper_right_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper right latitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
time record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$departure_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
date reference that vessel departed for the defined leg or trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for vessel end longitude |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_latitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_longitude_dim$longitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
Latitude at the vessel when sampling ceases (net liftoff for trawling). |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of longitude in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | station_ur_lon_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper right longitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$operation_end_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
end date reference for the operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | tow_end_timestamp |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
operation end date timestamp |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$scientist_3_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the third scientist |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_latitude_dim$latitude_in_degrees |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of latitude in degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$max_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
maximum depth warehouse identifier |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | longitude_dim$longitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$return_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
date reference that vessel returned for the defined leg or trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | latitude_dim$named_parallel |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of parallel, boundary, or commonly used geograpical location |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_longitude_dim$longitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude compass direction |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | E, W |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
operation year |
General Data Type | |
Unit of Measure | year |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 2007+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$transect_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
latitude warehouse identifier for a design type of transect |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | latitude_hi_prec_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
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 |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$upper_left_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper left latitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$operation_end_time_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
end time reference for the operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | min_depth_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of minimum depth measured in meters |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | year_stn_invalid |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Survey year the station became invalid for trawl |
General Data Type | |
Unit of Measure | year |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$upper_left_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper left longitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | station_ul_lat_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper left latitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | fluorescence_at_surface_mg_per_m3_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | mg/m3 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_longitude_dim$longitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude compass direction |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | E, W |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | seafloor_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier for seafloor depth |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of the vessel used for the operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | leg |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
leg number of the survey |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1,2,3,4,5,6,7,8 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_latitude_dim$latitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_longitude_dim$longitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$transect_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of transect latitude measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | net_liftoff_time |
---|---|
Seq. Order | |
Data Storage Type | time |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
military time representation of the time |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | depth_hi_prec_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$transect_station_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
longitude on transect warehouse identifier for a design type of transect |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$station_grid_dd |
---|---|
Seq. Order | |
Data Storage Type | polygon |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
collection of vertices of grid points of a grid design measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_longitude_dim$longitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$lower_left_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower left latitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$captain_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the vessel captain |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$lower_left_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower left latitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sample_duration_hr_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | |
Status | Active |
Description |
Difference in hours between the net liftoff and touchdown times |
General Data Type | |
Unit of Measure | hr |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | longitude_dim$longitude_in_degrees |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of longitude in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_longitude_dim$longitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$full_date |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$ifq_account_number |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
unique number assigned to user accounts in the Vessel Accounting Database |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_longitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for vessel end latitude |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | station_ll_lon_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower left longitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$area_hectares |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
station area measured in hectares |
General Data Type | |
Unit of Measure | hectares |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_latitude_dim$named_parallel |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of parallel, boundary, or commonly used geograpical location |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_latitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_latitude_dim$named_parallel |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of parallel, boundary, or commonly used geograpical location |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_latitude_dim$latitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude compass direction |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N, S |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$active_polygon_dd |
---|---|
Seq. Order | |
Data Storage Type | polygon |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
collection of vertices of the usuable area inside a station grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$active_polygon_dd |
---|---|
Seq. Order | |
Data Storage Type | polygon |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
collection of vertices of the usuable area inside a station grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
Longitude at the gear when sampling commences (net touchdown for trawling). |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$lower_right_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower right longitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | distance_start2hb_m_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$transect_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of transect latitude measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$lower_right_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower right latitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | longitude_dim$longitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$second |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of seconds in the minute |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$station_invalid_survey_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Survey year the station became invalid for trawl |
General Data Type | |
Unit of Measure | year |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier for the sampling start time |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$lower_right_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower right longitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_latitude_dim$latitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | mean_seafloor_dep_position_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Method used for deriving the seafloor depth single point |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Bottom Depth, Gross Operation Depth, Headrope Depth, Station-defined Midpoint |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier for target station design |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_latitude_dim$named_parallel |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of parallel, boundary, or commonly used geograpical location |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | longitude_dim$longitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$transect_station_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
longitude on transect warehouse identifier for a design type of transect |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$station_code |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
unique identifier for a station definition |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of latitude in degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$station_design_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of the design for a collection of stations |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$departure_port_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
port reference for the departure port |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_longitude_dim$longitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_latitude_dim$latitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude compass direction |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N, S |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vertebrate_weight_kg |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
Status | Active |
Description |
Total catch vertebrate weight in kilograms |
General Data Type | |
Unit of Measure | kg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for vessel start longitude |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_latitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$upper_left_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper left latitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | turbidity_ntu_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | ntu |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$lower_left_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower left longitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$scientist_2_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the second scientist |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$upper_right_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper right longitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$lower_left_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower left longitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | net_touchdown_time |
---|---|
Seq. Order | |
Data Storage Type | time |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
military time representation of the time |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | longitude_dim$longitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$vessel_id |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
field database vessel id number |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$period |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
period of time |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | AM, PM |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
Latitude at the gear when sampling commences (net touchdown for trawling). |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_longitude_dim$longitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
Longitude at the gear when sampling ceases (net liftoff for trawling). |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_latitude_dim$latitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude compass direction |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N, S |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier for haul latitude |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | invertebrate_weight_kg |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
Status | Active |
Description |
Total catch invertebrate weight in kilograms |
General Data Type | |
Unit of Measure | kg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | trawl_id |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
identifier for a sampling operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$operation_start_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
start date reference for the operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$min_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of minimum latitude measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_latitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_longitude_dim$longitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_latitude_dim$latitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_longitude_dim$longitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_latitude_dim$latitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_latitude_dim$latitude_in_degrees |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of latitude in degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$hour |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
standard representation of the hour |
General Data Type | |
Unit of Measure | hr |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$mean_depth_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of mean depth measured in meters |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_longitude_dim$longitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$max_depth_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of maximum depth measured in meters |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_longitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | latitude_dim$latitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | tow_start_timestamp |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
operation start date timestamp |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$mean_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
mean depth warehouse identifier |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | distance_start2end_m_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | station_lr_lat_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower right latitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$min_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of minimum latitude measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$max_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of maximum latitude measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier for the sampling end time |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | longitude_hi_prec_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
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 |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
operation record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_hhmmss |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_timestamp |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date and time that sampling began; almost exclusively the net touchdown time. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$fpc_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the FPC |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier for operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$station_grid_dd |
---|---|
Seq. Order | |
Data Storage Type | polygon |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
collection of vertices of grid points of a grid design measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
time record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_longitude_dim$longitude_in_degrees |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of longitude in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_longitude_dim$longitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | tow |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
operation number of the survey |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$stn_invalid_for_trawl_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
station design invalidation date warehouse identifier |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_latitude_dim$latitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_longitude_dim$longitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$max_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
maximum latitude warehouse identifier for a design type of transect |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_start_latitude_dim$latitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude compass direction |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N, S |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_longitude_dim$longitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | longitude_dim$longitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude compass direction |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | E, W |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | latitude_dim$latitude_in_degrees |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of latitude in degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$minute |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of minutes in the hour |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | latitude_dim$latitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_latitude_dim$named_parallel |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of parallel, boundary, or commonly used geograpical location |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | seafloor_depth_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
depth record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$lower_left_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower left longitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | project |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
project name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$military_hour |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
military representation of the hour |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-24 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | reason_stn_invalid |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
reason station was invalidated, multiple reasons are comma separated |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for gear end latitude |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$lower_right_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower right latitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | midtow_lat_named_parallel |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of parallel, boundary, or commonly used geograpical location |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier for haul longitude |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$minute |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of minutes in the hour |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_latitude_dim$latitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$lower_right_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower right longitude of design type grid measured in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$min_depth_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of minimum depth measured in meters |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_latitude_dim$latitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for gear end longitude |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$lower_left_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower left latitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | net_height_m_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$scientist_4_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the fourth scientist |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$min_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
minimum depth warehouse identifier |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$military_hour |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
military representation of the hour |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-24 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$min_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
minimum latitude warehouse identifier for a design type of transect |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
Longitude at the vessel when sampling ceases (net touchdown for trawling). |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier for station design |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$operation_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
type of operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null] |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_latitude_dim$latitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
station design record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | actual_station_design_dim$upper_left_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper left longitude warehouse identifier for a design type of grid |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_end_latitude_dim$latitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | haul_longitude_dim$longitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_end_latitude_dim$latitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | door_width_m_der |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
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 |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$limited_entry_permit_number |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$trip_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
trip identifier number |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$station_design_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of the design for a collection of stations |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for gear start longitude |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | latitude_dim$latitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | gear_start_latitude_dim$latitude_in_degrees |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of latitude in degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 36439 |
---|---|
Metadata Record Created By | Jeffrey W Cowen |
Metadata Record Created | 2017-01-25 13:15+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2017-02-13 |
Owner Org | NWFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2017-02-13 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2018-02-13 |
Tags |
---|