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
Global Record of Stocks and Fisheries
GRSF Data Coverage Queries
GRSF Geospatial Queries
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
A publicly available SPQRQL endpoint for the GRSF KB can be found here