Data-Dictionary
Licensing Systems Data Dictionary
- CSV files - contains CSV files that can be opened in Excel spreadsheet, first line is column heading
- Single MySQL file - contains structure and data
- Single Postgres file - contains structure and data
- MySQL files - contains MySql .sql files separated into individual files
- Postgres files - contains Postgres .sql files separated into individual files
Sources
Listed below are the source of the standards as well as links to the actual data sources
- countries - Country Codes Github Repo https://github.com/datasets/country-codes/blob/master/data/country-codes.csv. Original sources are from ISO 3166 codes, ITU dialing codes, ISO 4217 currency codes, and many others , added fisheries specific information
- gear_type - FAO, International Standard Statistical Classification ftp://ftp.fao.org/docrep/fao/008/t0367t/t0367t01.pdf
- vessel_type - FAO, Based on the International Standard Statistical Classification of Fishery Vessels by Vessel Types (ISSCFV), based on the type of gear used by the vessels, approved by the CWP in 1984 ftp://ftp.fao.org/fi/DOCUMENT/cwp/handbook/annex/annexLII.pdf
- simplified_vessel_type - Simplified Classification of Fishing Vessels By Vessel Types - ftp://ftp.fao.org/FI/DOCUMENT/cwp/handbook/annex/ANNEX_LIII.pdf
- ports - UN, UN/LOCODE https://www.portconnect.co.nz/Docs/PortConnectStandardUNLocationCodes(Global).xls also see here (United Nations Code for Trade and Transport Locations)[ http://www.unece.org/cefact/locode/]
- species - FAO, information http://www.fao.org/fishery/collection/asfis/en... download ftp://ftp.fao.org/FI/STAT/DATA/ASFIS_sp.zip
- storage_method - Unknown but common across all forms, suspect FAO is source TBC
- authorised_fishing_area - Pacific Commission (SPC) http://www.spc.int/oceanfish/en/ofpsection/
- units_of_measure - THE UNIFIED CODE FOR UNITS OF MEASURE http://unitsofmeasure.org/ucum.html only taken a subset of units relevant for licensing.
Specifically these are:
kilolitres | volume | kl
gallon | volume | gal
meter | length | m
foot | length | ft
kilowatt | power | kW
horsepower | power | hp
pound per sqare inch | pressure | psi
Instrcutions
Exporting Data
SSH into server run the following at the command prompt to export data:
mysqldump -u root -p --databases master_data >master_data.sql
OR for Postgres
pg_dump master_data > master_data.sql