Calipseo is FAO web- based platform for national Fisheries Authorities to streamline management of fisheries data and the production, analysis and reporting of fishery statistics.
1
stars
0
forks
source link
[CALR-60] Extent vessel owners list to target companies #60
Issue migrated from JIRA: https://sdlc.review.fao.org/jira/browse/CALR-60
Creator/Reporter: Emmanuel Blondel @eblondel
Assignee: Brian Ojok @brianandy
Priority: Medium
Status: Done
Date of creation: 2022-03-17T12:34:35.000+0000
With the vessel multi-owner support, we can now have also a company owning a vessel, not only an individual. The SQL query we perform for now is limited to operate a JOIN over reg_entity_individuals. It should be extended (as sql UNION probably) to companies. In principle no R coding here, only an update of the SQL query for vessel owners.
Test case: vessel 'ARAVIS' from Suriname that is owned by a company; See reference queries:
SELECT * FROM surcalipseo.reg_vessel_owners WHERE REG_VESSEL_ID = 2252;
SELECT * FROM surcalipseo.reg_entity_companies WHERE REG_ENTITY_ID = 287;
With the vessel multi-owner support, we can now have also a company owning a vessel, not only an individual. The SQL query we perform for now is limited to operate a JOIN over reg_entity_individuals. It should be extended (as sql UNION probably) to companies. In principle no R coding here, only an update of the SQL query for vessel owners.
Test case: vessel 'ARAVIS' from Suriname that is owned by a company; See reference queries:
SELECT * FROM surcalipseo.reg_vessel_owners WHERE REG_VESSEL_ID = 2252;
SELECT * FROM surcalipseo.reg_entity_companies WHERE REG_ENTITY_ID = 287;