Competency Queries Competency Queries

GRSF Competency Queries

The Global Record of Stocks and Fisheries (GRSF) competency questions is a set of predefined queries that have been formulated based on the requirements that have been collected from the corresponding communities. These queries are formulated in such a way that they return information that is useful for the communities, and in the case of the GRSF competency question they return results that exploit the integrated data warehouse and in certain cases return results that could not be answered from the individual sources.


Fisheries And Resources Monitoring System

 

FIRMS Stock Queries
Fi.1.1 Retrieve all imported FIRMS Resources / Assessment Units.
Fi.1.2 Retrieve all stocks' related species.
Fi.1.3 Retrieve all stocks' related areas.
Fi.1.4 Retrieve all owners.
Fi.1.5 Retrieve all narrative states.
Fi.1.6 Retrieve all states.
Fi.1.7 Retrieve all scientific advices.
Fi.1.8 Retrieve all assessment methods.
Fi.1.9 Retrieve all reporting years.
Fi.1.10 Retrieve all indicator types.
Fi.1.11 Retrieve all abundance levels.
Fi.1.12 Retrieve all standard abundance levels.
Fi.1.13 Retrieve all fishing pressures.
Fi.1.14 Retrieve all standard fishing pressures.
Fi.1.15 Count all stocks.
Fi.1.16 Retrieve all information.
 
FIRMS Fisheries Queries  
Fi.2.1 Retrieve all imported Fisheries (Fishing Activities/Descriptions).
Fi.2.2 Retrieve all fisheries' related species.
Fi.2.3 Retrieve all fisheries' fishing areas.
Fi.2.4 Retrieve all catches.
Fi.2.5 Retrieve all landings.
Fi.2.6 Retrieve all management units.
Fi.2.7 Retrieve all fishing gears.
Fi.2.8 Retrieve all flag states.
Fi.2.9 Count all fisheries.
Fi.2.10 Retrieve all information.

 

Fishsource

 

FishSource Stock Queries  
Fs.1.1 Retrieve all imported Resources / Assessment Units.
Fs.1.2 Retrieve all stocks' related species.
Fs.1.3 Retrieve all stocks' related areas.
Fs.1.4 Retrieve all owners.
Fs.1.5 Retrieve all scientific advices.
Fs.1.6 Retrieve all abundance levels.
Fs.1.7 Retrieve all fishing pressures.
Fs.1.8 Count all stocks.

 

FishSource Fisheries Queries  
Fs.2.1 Retrieve all imported Fisheries.
Fs.2.2 Retrieve all fisheries' related species.
Fs.2.3 Retrieve all fisheries' fishing areas.
Fs.2.4 Retrieve all catches.
Fs.2.5 Retrieve all landings.
Fs.2.6 Retrieve all management units.
Fs.2.7 Retrieve all fishing gears.
Fs.2.8 Retrieve all flag states.
Fs.2.9 Count all fisheries.

 


RAM Legacy Stock Assessment Database

RAM Stock Queries  
R1.1 Retrieve all imported RAM Resources / Assessment Units.
R1.2 Retrieve all stocks' related species.
R1.3 Retrieve all stocks' related areas.
R1.4 Retrieve all assessment methods.
R1.5 Retrieve all abundance levels.
R1.6 Retrieve all fishing pressures.
R1.7 Count all stocks.

 


Global Record of Stocks and Fisheries

GRSF Queries
G1.1 List all GRSF Stock records SPARQL query
G1.2 List all GRSF Fishery records SPARQL query
G1.3 List all GRSF Stock records with type "Assessment Unit" SPARQL query
G1.4 List all GSRF Fishery records with the following fields Species Name / Area / Management Entity / Flag State / Fishing Gear SPARQL query
G1.5 List all GRSF Fishery records flagged for traceability purposes SPARQL query
G1.6 List all GRSF Fishery records from "Atlantic" SPARQL query
G1.7 List all GRSF Stock records for the genus "Thunnus" SPARQL query
G1.8 List all GRSF Stock records with their status SPARQL query
G1.9 List all GRSF Fishery records with their status SPARQL query
G1.10 Retrieve all (most) available information for stocks (without indicators). SPARQL query
G1.11 Retrieve all water areas and related records. SPARQL query
G1.12 Retrieve all species and related records. SPARQL query
G1.13 Count all waterareas. SPARQL query
G1.14 Count all species. SPARQL query
G1.15 Retrieve all management entities. SPARQL query
G1.16 Retrieve all gear types and related records. SPARQL query
G1.17 Retrieve all flag states and related records. SPARQL query
G1.18 Count all Stocks SPARQL query
G1.19 Count all Assessment Units SPARQL query
G1.20 Count all Marine Resources SPARQL query
G1.21 Count all Fisheries SPARQL query
G1.22 Count all Fishing activities SPARQL query
G1.23 Count all Fishing descriptions SPARQL query
G1.24  Count all records SPARQL query

 

GRSF Data Coverage Queries

G2.1 List all Stocks from FIRMS. Count   SPARQL query
G2.2 List all Stocks from FishSource. Count     SPARQL query
G2.3 List all Stocks from RAM. Count   SPARQL query
G2.4 List all Stocks from GRSF. Count   SPARQL query
G2.5 List all Fisheries from FIRMS. Count   SPARQL query
G2.6 List all Fisheries from FishSource Count   SPARQL query
G2.7 List all Fisheries from GRSF Count   SPARQL query
G2.8 List all Stocks records from GRSF per FAO major fishing area Count   SPARQL query
G2.9 List all Fishery records from GRSF per FAO major fishing area Count   SPARQL query
G2.10 List all Stocks records from GRSF with associated catch series Count   SPARQL query
G2.11 List all Fisheries from GRSF per EEZ Count   SPARQL query
G2.12 List all Fisheries from GRSF with associated catch series Count   SPARQL query
G2.13 List all Stocks from GRSF with their associated abundance level (limited) Count   SPARQL query
G2.14 List all Stocks from GRSF with their associated abundance level (FIRMS standard) (limited) Count   SPARQL query
G2.15 List all Stocks from GRSF with their associated fishing pressure (limited) Count   SPARQL query
G2.16 List all Stocks from GRSF with their associated fishing pressures (FIRMS standard) (limited) Count   SPARQL query
G2.17 List all Stocks from GRSF with their associated state and trend Count   SPARQL query
G2.18 List all Stocks from GRSF with their associated FAO stock status categories Count   SPARQL query
G2.19 List all Stocks from GRSF per reference year (most recent) .     SPARQL query
G2.20  20. List all Fisheries from GRSF per reference year (most recent).     SPARQL query

 

GRSF Geospatial Queries

G3.1 Get geographic information (polygons) for GRSF Stocks SPARQL query
G3.2 Get geographic information (polygons) for GRSF Stocks (in JSON format)  
G3.3 Get geographic information (polygons) for GRSF Fisheries SPARQL query
G3.4  Get geographic information (polygons) for GRSF Fisheries (in JSON format)  

 

GRSF Summary Queries

G4.1 List GRSF Stock records with their original IDs
G4.2 List GRSF Fishery records with their original IDs

 

GRSF Resources Queries 

G5.1 Species codes code types names
G5.2 Assessment / Fishing Areas codes code types names
G5.3 Fishing Gears codes code types names
G5.4 Countries/Flag States codes code types names
G5.5 Management Authorities codes names  
G5.6 FAO categories values    
G5.7 Abundance Level - FIRMS standard values    
G5.8 Fishing Pressure - FIRMS standard values    
G5.9 Assessment Methods values    

 

 

 

 

 

 

 

 

A publicly available SPQRQL endpoint for the GRSF KB can be found here


last updated: Dec 23, 2021