Data collection systems for coastal fisheries and aquaculture

Data collection systems for coastal fisheries and aquaculture First Regional Technical Meeting for Coastal Fisheries and Aquaculture Noumea, 30 November 2017

Data collection systems Information needs Survey & form design Surveyor training Survey /data collection Data entry Data analysis Management decision

Data collection Wet environment

Data collection Dry environment

Survey forms

Data entry Field, hotel, office

Software architecture Front-end user interface Back-end data storage Desktop application Offline / local network Web application Online / local network Mobile application Online / offline Local database Offline Local server Local network Remote server Online

Front-end User Interface Desktop application • Large screen, keyboard & mouse • Requires a desktop & software installation • Requires OS compatibility (e. g. Windows, Mac OS, Linux) Web application • Large screen, keyboard & mouse (depending on device) • No installation • Limitations due to browser security • Requires browser compatibility (e. g. IE, Chrome, Firefox) Mobile application • Hand-held device often with integrated camera & GPS • Smaller screen, touch interface • Requires OS compatibility & installation (e. g. Android, IOS)

Back-end data services Local database • Full database available offline • Requires local DBMS installation • More difficult to synchronize & maintain • Data loss if device is not backed-up Local server • Full database available on the local network • Single DBMS installation & maintenance for a group of users • Only reachable from the local network or VPN Remote server • Single DBMS installation & maintenance • Requires Internet connection & sufficient bandwidth • Single point of failure

Existing regional applications Application Scope RFID / Reef. DB Underwater fish and invertebrate Desktop application surveys Socio-economic surveys Desktop application SEMCo. S Creel & Market Surveys CFP web site Field surveys CFP web site export permits TUFMAN 2 Creel and Market surveys Type Desktop application Available on microservers Y Y Y Coral, seagrass mangrove, coconut Web application crab field surveys Export permits per shipment Web application N Small scale artisanal catch Web application N Tails Mobile data entry for TUFMAN 2 Mobile app Not applicable Pac. Fish. ID Species identification Mobile app Not applicable Y

Development and maintenance Development • Standardize forms & survey methodologies (regional development) • Simplify forms (especially if mobile entry is envisaged) • Prioritize data collection (minimum dataset) Maintenance • Central back-end server, possibly a few remotely maintained servers • Standard regional applications

Discussion What are the challenges faced in your country with database systems and are there any workarounds. What are the country expectations in term of long-term maintenance of regional and country specific software and how to ensure funding to meet these expectations