Data Catalog

TABLE
TABLE COMMENT
ROWS
 
vms_track_data Vessel tracks from FFA 66022
reference_seaports A reference list of seaports 14300
annual_catch_by_flag Annual tuna caught in the WCPFC by flag state 7071
reference_fee_type A reference list of the various fee types charged by fisheries agencies 8
reference_ffa_members A reference list of members of the Pacific Islands Forum Fisheries 17
reference_doc_type A reference list of fisheries documentation types 8
reference_event A reference list of events that should be monitored by fisheries agencies 14
reference_mcs_activity A reference list of MCS Activities that should be monitored by Fisheries Agencies 12
reference_fishing_areas A reference list of Fishing Areas within the WCPFC 54
reference_product_state 3
reference_currency A reference list of currencies 250
reference_species_tuna A reference list of tuna species 16
reference_license_type A reference list of the types of licenses that are issued 4
reference_country A database list of countries 250
reference_vessel_license A reference list of fishing licenses issued by NORMA 5801
reference_product_form 0
reference_gear_type A reference list of Gear Types 74
reference_activity_codes The activity codes for a purse seine vessel as it appears in the SPC / FFA Regional Purse-Seine Logsheet 8
purse_seine_catch Purse Seine Catches 15670
reference_wcpfc_rfv Record of Fishing vessel from the WCPFC 3502
reference_gear_type_attribute A reference list of Gear Type Attributes 43
reference_docs A reference list of fisheries documents that are issued by government agencies 13
regional_prosecutions A list of regional prosecutions scrapped from various legal / court databases from around the Pacific 153
reference_observer A reference list of observers at NORMA 55
reference_entity_type A reference list of entities / assets that should be monitored by fisheries agencies 9
reference_company A reference list of Companies from pulled the NORMA IMS Licensing system 0