navigating spatial data management and analysis in
TRANSCRIPT
![Page 1: Navigating spatial data management and analysis in](https://reader031.vdocuments.us/reader031/viewer/2022012513/618c80f1c3e0174e74089ba4/html5/thumbnails/1.jpg)
Navigating spatial data management and analysis in sustainable
fisheries using a combined R – Python approach
Annette Scheffer, Francis Neat, Peter Hair, Marcus Nelson, Robert Lefebure, Ashleigh Arton, Catherine S. Longo
useR! conference, Toulouse 9 - 12 July 2019
![Page 2: Navigating spatial data management and analysis in](https://reader031.vdocuments.us/reader031/viewer/2022012513/618c80f1c3e0174e74089ba4/html5/thumbnails/2.jpg)
Marine Stewardship Council
2
Worldwide sustainable fisheries certification since 1997
Safeguard seafood for this & future generations
Use market demand for ecolabel to incentivise sustainable fishing
![Page 3: Navigating spatial data management and analysis in](https://reader031.vdocuments.us/reader031/viewer/2022012513/618c80f1c3e0174e74089ba4/html5/thumbnails/3.jpg)
Marine Stewardship Council – Data collection
3
Auditor
Certification Report
MSC
![Page 4: Navigating spatial data management and analysis in](https://reader031.vdocuments.us/reader031/viewer/2022012513/618c80f1c3e0174e74089ba4/html5/thumbnails/4.jpg)
Marine Stewardship Council – Data collection
4
Auditor
Certification Report
MSC
Certification dataData warehouse
Spatial dataSpatial database
![Page 5: Navigating spatial data management and analysis in](https://reader031.vdocuments.us/reader031/viewer/2022012513/618c80f1c3e0174e74089ba4/html5/thumbnails/5.jpg)
MSC spatial data – point locations
5
![Page 6: Navigating spatial data management and analysis in](https://reader031.vdocuments.us/reader031/viewer/2022012513/618c80f1c3e0174e74089ba4/html5/thumbnails/6.jpg)
MSC spatial data – fishing & stock areas
6
Certificate holder locationswith species, gear andcatch amount
Stock distribution for target species
Fishing areas associated with certificates
![Page 7: Navigating spatial data management and analysis in](https://reader031.vdocuments.us/reader031/viewer/2022012513/618c80f1c3e0174e74089ba4/html5/thumbnails/7.jpg)
User groups at MSC
7
Science & Standards
Chain of Custody Licencing Outreach
Strategic research teamR coding – beginner / intermed.
Data & analysis team R & Python coding
Other teamsSoftware use
MSC organisation – multiple departments – different software / coding proficiency
![Page 8: Navigating spatial data management and analysis in](https://reader031.vdocuments.us/reader031/viewer/2022012513/618c80f1c3e0174e74089ba4/html5/thumbnails/8.jpg)
Spatial database – data input
8
1 – data inputMSC data warehouse
R
R - Python
SQL Server
PostgreSQL
![Page 9: Navigating spatial data management and analysis in](https://reader031.vdocuments.us/reader031/viewer/2022012513/618c80f1c3e0174e74089ba4/html5/thumbnails/9.jpg)
Spatial database – user interactions
9
1 – data inputMSC data warehouse
R
2 – user interactions
Built-in qGIS
functions
Custom R scripts stored + called in qGIS
Custom qGIS
plugins
qGIS
R
R - Python
SQL Server
PostgreSQL
Python@ qGISplugin builder
![Page 10: Navigating spatial data management and analysis in](https://reader031.vdocuments.us/reader031/viewer/2022012513/618c80f1c3e0174e74089ba4/html5/thumbnails/10.jpg)
Spatial database – user interactions
10
1 – data inputMSC data warehouse
R
2 – user interactions
Built-in qGIS
functions
Custom R scripts stored + called in qGIS
R scripting by
users
Custom qGIS
plugins
qGIS
R
R - Python
SQL Server
PostgreSQL
Python@ qGISplugin builder
R or Python called through R @RQGIS package
![Page 11: Navigating spatial data management and analysis in](https://reader031.vdocuments.us/reader031/viewer/2022012513/618c80f1c3e0174e74089ba4/html5/thumbnails/11.jpg)
Spatial database - organisation
11
1 – data inputMSC data warehouse
R
R - Python
SQL Server
PostgreSQLRPython
RQGIS package
Access qGIS Python geoprocessing functionalities from R
Execute R scripts in qGIS:Statistical analyses (without qGIS geoprocessing functionalities)
qGIS
![Page 12: Navigating spatial data management and analysis in](https://reader031.vdocuments.us/reader031/viewer/2022012513/618c80f1c3e0174e74089ba4/html5/thumbnails/12.jpg)
Spatial database - organisation
12
1 – data inputMSC data warehouse
R
R - Python
SQL Server
PostgreSQLRPython
RQGIS package
Access qGIS Python geoprocessing functionalities from R
Execute R scripts in qGIS:Statistical analyses (without qGIS geoprocessing functionalities)
qGISplugin builder
Python scripting in qGIS plugin builder
qGIS
-qGIS Dissolve→ “Developing Word” layer
![Page 13: Navigating spatial data management and analysis in](https://reader031.vdocuments.us/reader031/viewer/2022012513/618c80f1c3e0174e74089ba4/html5/thumbnails/13.jpg)
Spatial database – automated processes examples – qGIS plugins through Python programming
13
UN FAO Major Fishing Areas Large Marine Ecosystems
• match fishing areas + attributes with external spatial layers• fishing areas & companies per FAO area, per stock etc• calculate stocks (number & areas) untouched by MSC fisheries • overlay MSC developing countries layer • create buffers