Risk assessment tool for target species in ships` ballast water
Contents
1. awe 2 PLEO PAE E mm mmmmmm mmmmmmmmmmm mmmmmmrmrmHmHHmmmmmmmmmmmm mmmmkmmmmmm mrmmmmmmmmmmmmmkmrmmmmmmmmmmmma0H 2 SN ME e r E E E E E E EA der gaineoaiatnnsson 3 SEAIN a aig PR EET 3 3 2 2 RISK Assessment Algorithmi TaD sereen EEE EE 3 3 2 3 All Species in the HELCOM OSPAR area tab ccccccccccccccccccccseeeesseeeecececcccccssseeeeeeeuaeeeessseeeeeecesesseeeess 4 3 2 4 Target Species in the HELCOM OSPAR area tab seessseseessssssrrrrrrrrrrrrereresssessrrrrrrrrrrrrreeeeesssrrrrrrerrrns 4 Ar CB AO i e AE E E ET RT 5 3 2 6 Additional Information S Help tab scrsictcpscccrdacsnsecesiaicespacacwaidantanwenduwnndededcudsspanwievadodeeantboaseseaodumsctawessict 6 POLON OIE e E A E E A E E AN 8 Data VIC WINS oea E E E E E E E E E E S 8 d T POR CAT r E E E E E O TO EEN E O S 8 4 2 Sampling Environment Conditions sssrin IRRAIRHIIGESAIR BHANR GIN GISAHAISA NA ELI S esc S Eua HEU EE 9 4 3 Sampling MethadolOBViusssexvrd usb tivp ei seT uo 6E aseo Ie Spur CORE RN ura dU TpESEE 9 aM SIUE m 10 Do ISIE UNG Sea CIN OO UO e OT 10 4 6 Adding and Removing Fields of choice for VICWING ccccsseccccessececeesececeeececceeeceeseusecessenecessuaeceesenes 12 AT Sie ME COTO i mmmmmmmmmmmmmmmmmmmrmmmmmmmrmrmrmrmrmrmmrmrmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmirmHHI ie 13 4 8 Selecting the number of records per page in a report 15 4 9 Format of the displayed report us2. are Hire Aevesenert 2 goriim AR Speces in he MELCOMOTFAS sre largest Species im Pw ELC OMPODFES ore hons Quality Cred Quality Check n this secton cumulative curves can be generated for each of the terent group of organsms sampled in each pot attached mabe ept suna tenthos fouling mosse epi auna pathogens phytoplarkton and 2oop ar ian wih the aim of evabueting f the number of samples taken represents the species present in the port where the curve becomes asymptotic Select please Y Data for species accumulation curves in this section accumulaton carves can be generated for each of the ferent qoup of organises sampled in each port attached mobile epfauna beethos fouling mobile epiauna pathogens prytoclenthion and zooplaekton Piense cetect the desired data from the search tool to generate the accurmation curves cf interest for further informato see the users guide 16 08 2013 Site 1608200 Stel 22080200 Sites 03032013 Ske2 0409200 Ste 0400200 5 05092013 Ste 05092010 Ge 060092000 5 10032013 5 11092013 Si 11092003 S 719032013 5 12092013 Si 4092307 5 1709 200 E 230092013 5i 260952013 Shes 03112013 Sie 08052013 Stei 00 05 2013 w men ee d C o Ro Wa ne NN fh 4 amp Ww h ww amp 3 2 6 Additional Information amp Help tab The Additional Information amp Help section contains links to the following information see screen shot below e The User Guide to the risk assessment to
3. Baltic Marine Environment Protection Commission USER GUIDE Risk assessment tool for target species in ships ballast water d A NN I N A i 4 b a 1 Li ha J i d t ms 4 D qu C 1 d Fad B 1 ife 8 f Ar M Y A bas 1 t P 4 k k x Full Title Report compiled by Funded by For bibliographic purposes this document should be cited as Authors Cover photo Layout BALSAM Risk Assessment Tool User Guide Baltic Sea Pilot Project BALSAM Work Package 4 European Commission DG Environment and project partners HELCOM 2015 BALSAM Project 2013 2015 BALSAM Risk Assessment Tool User Guide Marta Ruiz Sriram Sethuraman Maiju Lehtiniemi Johanna Laurila HELCOM This report does not necessarily represent the views of HELCOM HELCOM does not assume responsibility for the content of the report Information included in this publication or extracts thereof are free for citation on the condition that the complete reference of the publication is given as stated above Contents 1 2 3 5 GENERAL INFORMATION E 1 1 1 System OvervieW M 1 1 2 Organizauom ob the ii mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm mmmmmmmmmmmmmmm mmmmmm mmmmmmmmmmkaHmHH 1 NTEM UMMAR Y T OM Ue 1 ciuiuckavagp c
4. Pate aec torn fe se uch tool to range Te 1 ade fu raton o efecso he Meg optce n he Actors mens Vor further qtormation ues De oue cue 4 2 Sampling Environment Conditions This section provides information of the environmental conditions associated to each of the samples taken during the port surveys Users can search and view the desired data using the Search and Filter options See screen shot below Filters can be set at multiple levels Please see section 4 5 with different examples to understand how to use the different options e Sneton w ES 9 Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure nee on Exemptions under the Ballast Water Management Convention Cat bran cmt Rage Ad deo te MUC AT AR ms Tag Wows m P ELODO NIAE mm Bass heres omit toc Ow mg Erne Crion Sampling Environmental Conditions fa section PANNON Ue erp oremerty Cordon aboodled V each of Be tnit Laken A prote eese sect Yorn Pe search 806i lo ant amp Te prilis mtormabon of hed He Met ochon m fe Actoms Mere n Nee formate see De weer quee os ou E Sederert masty mod shona rocky Traps eet on 15 6 2212 and the lad one ietwved on JIA a 12 00 8 was retrieved by Geers 4 up Pad venen at poor beter c 8 Concrete sat of the bolor for preventing et ogee sit 3 33 og W wy Sota 32 2 33 99 22 3 3 9 5855 ewe y u 1 Sef sedesent team wes hard Bet o natie sub of Tw bota 4 wd 4 a amp 6 Sedaren
5. Risk Assessment in this section the risk of distribution of allen speces via shipping navigation from one port 1o another is evaluated depending on the presence of invasive alien speoes on both ports and ther salinity tolerance The outcomes of the assessment wil be High Medium and Low risk which will be used for the granting or not of an exemption to a ship sailing that route In cases of ships transang Io two ports within the HELCOM OSPAR area please carry out the rak assessment from port A to port B and subsequently from port B to port C final destination From Muuga vitio Gothenburg v Show more detali yes Show Diagram yes gs Risk assessment calculation details Presence of target species in harbours 1 GOT Amphibalanus mprovisus 2 GOT Cordyophora caspia 3 GOT Marenzellena viridis 4 GOT Moigula manhattenss 5 GOT Mya arenaria 6 GOT Neogobius melanostomus 7 MUU Amphibalanus improvisus 8 MUU Neogobius metanostomus Risk Assessment Decision low nek Risk Assessment decision path diagram Target species present in one or both ports 1 Page 28 of 28 www helcom fi
6. 7 7 p 7 7 p 7 F Mc gula manhattensis Moigula manhattensis Mytius eduks Mytius edulis Mytius euis Mytius eduks Mytius eduls Polysphonsa sp 11 21333333333333333333 3 3 3 Home RA Assessment Ajgoctm Al Specs n the HELCOMO SPAR ama Target Species in the HELCOMOSPAR area Fab Asses ment Quaity Check Data upper sce upper sce upper sie upper ade lower side upper sie lower side rope kwer sde lower side upper sce upper side lower side upper side n sample upper sie upper side lower side upper sie tower side upper side lover side lower side D O O O0 0 9 OP 0 O CO OO OQ O0 OO O CO Oo m Found in fragments in rope poer sid Page 25 of 28 BALSAM RISK Assessment Tool y zd Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure a on Exemptions under the Ballast Water Management Convention g Home Risk Assessment Aigorttes Al Species nthe HELCOMOSPAR arpa Mome gt View Data View Data Options 1 Port Characteristics 2 Sampling Environmental Conditions 3 Sampling Methodology View Data In this section details of the species found in the samples taken in the ports are provided nr 7 je lie eo Actors Parameter E Comments Comments 2 NININNINN INS NINSISINSIN IN INN INSIN IN IN NS INS IN iidiiiiliiiiliiliiiiili iiiiiiiiiiiiibbiigiiiio oBSsnusSnuBSR Once the report is saved users may want to download it Three
7. View Data Options 1 Port Characteristics 2 Sampling Environmental Conditions 3 Sampling Methodology View Dats in f section 3eiain of the peces found N Oe nimois tuber n Be ports are poes Fr i r 0311200 n 0311200 p 72111200 03112003 o gt 2210200 9112090 03 112013 03 11 2015 05 112013 03 11 2013 03112013 24909 2912 m0 00 2 092010 26 09 201 26 OF 2089 202010 209200 e mops 29 09 2013 mme 2092913 26 08 2003 3 23 00 mawy 28 09 01 23311131333131113331131331111 1111 EEEEEEEEIEELEL EL EE FI IE il p J 6 A F F 7 St P 7 G 9 9 y 9 S 7 FA r 4 dh 4 F Jp 7 fa FA i 4 1 Port Characteristics This section contains information gathered on ports characteristics such as abiotic conditions and port traffic Users can search and view the desired data using the Search and Filter options See screen shot below Filters can be set at multiple levels Please see section 4 5 with different examples to understand how to use the different options Page 8 of 28 BALSAM RISK Assessment Tool COMMISSION Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure prr T ma on Exemptions under the Ballast Water Management Convention we Pet Ava mart Aigh M Specs n fu MELCOMIO VA anm TB Speers fra LODO FAR mu sd Quay aea MeV we Dun Pat Cette Port Characteristics in tan section qiormaton on portu Aa scheretce wech ad aote condis anc port tafi a gae
8. i Species N MELCOM OSFAR ar ie Ger sector Moralo or al be pron eto La Aum Be mr ames te LALA d ee En mm re 3 2 4 Target Species in the HELCOM OSPAR area tab In this tab the list of target species in the HELCOM OSPAR area is provided These species agreed by HELCOM and OSPAR Commissions are considered to be of particular relevance in the context of the requirements of the BWM Convention and refer to species in other regions that may impair or damage the environment human health property and resources in the HELCOM OSPAR area Users can search and view the desired data using the Search and Filter options Filters can be set at multiple levels See screen shot below Please see section 4 5 with different examples to understand how to use the different options Page 4 of 28 BALSAM RISK Assessment Tool F 9 Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention dama Vra hemes aerem LA bala i o ima ferm Bo Tanta djamca no Pa HLS we Target species in the HELCOM OSPAR area Arnau Ali the epee oho poene Fa Deer od oa in diee POP ER mba 3 ee Anc oe on e epee DODACMLEM nee m Eee coded of dha eee ets of for asia ciere Wegener Coreen Bl Corssemor Pass Tras pa Cup of pec a he PL COLE Tanger apscesk i sch ans KRCEHI in Sior Cee hud IR apu ci CFRE Eee erov Dent Purus heal property and retour ness in the HTLCORLCISPAB ansa Feds inci inar tha search icol io arm an
9. samples taken is provided oM i e Qn x COMMISSION F Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure TTA wee e ore BW READER Logout res on Exemptions under the Ballast Water Management Convention Home Risk Assessment Algorithm y All Species in the HELCOMPOSPAR area Target Species in the HELCOWOSPAR ares Rink Assessment j Quality Check n EA Additional information amp Help View Data Options 1 Port Characteristics 2 Sampling Environmental Conditions 3 Sampling Methodology View Data In this section details of he species found in the samples taken in the ports are provided EE Aggregate Aggregation Average Parallel Samples v Function Average Column Parallel Samples M Cancel Delete Apply Ore Parameter Group Naantali 20 06 2012 i Amphibatanus improvisus count 62666665667 Upper side covered w Ulva algae detached prior to counting Mobile epifauna Mobile epifauna Mobile epifauna Mobile epifauna Mobile epifauna Mobile epifauna Mytilus trossulus observed Detatched epifauna 1 2 mm Naantali 20 06 2012 Gammarus tigrinus count 0444444444 Upper side 1 G gr counted Naantali 20 062012 Gammarus tignnus count 0444444444 y Upper side 1 G gr counted Naantali 20 06 2012 Gammarus tigrinus observed i Detatched epifauna Naantali 20 062012 Rhithropanopeus harrisi observed Detatched epifauna megalopa larvae Naantali 20 06 20
10. Default Developer Only it is the report initially displayed It cannot be renamed or deleted Alternative Report Developer Only it enables developers to create multiple report layouts They can save rename or delete them Public Report End user only the end user who created it can save rename or delete it whereas other users can only view and save the layout as another report Private Report End user only the end user who created the report can view save rename or delete it When saving customized reports a Reports selector displays in the Search bar to the left of the Rows selector if this feature is enabled see screen shots below Home gt View Data View Data Options 1 Port Characteristics 2 Sampling Environmental Conditions 3 Sampling Methodology View Data m x 47 OSPAR COMMISSION ES pn Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure cm pis cies on Exemptions under the Ballast Water Management Convention In this section details of the species found in the samples taken in the ports are prov 03 11 2013 03 11 2013 03 11 2013 03 112013 03 112013 03 11 2013 03 112013 03 112013 03 112013 03 112013 03 112013 26 09 2013 26 09 2013 26 09 2013 26 09 2013 26 09 2013 26 09 2013 26 09 2013 26 09 2013 26 09 2013 26 09 2013 26 09 2013 26 09 2013 26 09 2013 SAVE REDORT 7 7 7 2 A F 2 7 7 7 7 2 FA 7 7 F
11. different examples to understand how to use the different options Page 9 of 28 BALSAM RISK Assessment Tool bo hace ES Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure Seen on Exemptions under the Ballast Water Management Convention tee LIN d Aj pneus m Oe I 080380 48 am Tengi Lomems t Ao UL COMIS TAAA mms Ld Geral This Dats Noten e L stew Liwy e to es te dA Var veto Sampling Methodology wn Pha id s Npeo cason s or de vang Td CCN Kired the De TF EI ACT gqicep Of organum UGC afatecratds si ds bebo foci Tit e nra IPGL Qhitoparktun ant oopoaldoe m pea ffease sid oem The ice 106 15 ar ange The palitin eforrabor ox Che cui Be Help opbor m Be Actors reru for Sucher reformation we Be var qur Cummsala Meaowope Lene DU RE Quia HOR Sa 04 Charmber Gum 28 Sam bout of vet Came wat repeesertstve al TWU temples ai foogh hac some Fiyteplankitor sediment 156 an 3 Commenti i Meroscope Lexa OM IRB Oodar IWC f2 Suti Crammer cam Sedm Baled sample 10t ege sew 500 mi vet v Bates 104 ste 500 mi 6x Lees DU WB Dod HC ED 54 01 Chamber dure 2 Sedem Mesoscope Leva OM IRA Gomer HCK Seth Chamber dam 26 Sedem win Concert rei net semper 20 um ret Ore genres Magege Lex OM IRD Ouar HC T2 59704 Chamber Gur 29 Soan cai 208 fu oughout the water come Im vo s Gated sample 100 saepe sew 599 en Timan quat sample area 15 24cm tS 24cm Diman grab sampa area 15 240m 15 Dacre Eiman q
12. epee kara n eee seam in ha es eee n rn F is Te O Comm S ew Parer ae O O O O O S ie Sela earth Lon emna diui F ELETE IF L ELE UE 8112803 Tit F qma m 1128103 81112203 giai m mpi m mice xmi Mee P I Na id UN D 2s ee eee nr LE tiliiiiiiili 1113113313333 Tar sampling Methodology View Data In this section details of the species found in the samples taken in the ports are provided icone 05 02 2013 05 02 2013 05 03 2013 05 02 2013 05 09 2013 05 03 2013 05 03 2013 05 02 2013 01 08 2013 08 05 2013 08 05 2013 n8 05 2013 08 05 2013 08 05 2013 08 05 2013 02052013 2404 2013 24 na 2013 24 04 2013 2404 2013 24 04 2013 24042013 24 04 2013 2404 2013 24 04 2013 2404 2013 2404 2013 24 04 2013 2404 2013 24042013 Z4 04 2013 24 04 2013 24 04 2013 2404 2013 24 04 2013 24042013 in regard to tushas number n9514 in regard te frustule number in2527 in regard 16 frustule number n2523 5 ice 40 5049 cail 17 22 cel 22 27 6m cel 22 2749 1 cel 17 2269 3 cek 27 324 3 cel 27 324 cel 9 114pm cail 17 22dpm cel 22 27 49m cel 27 3249 ceil 17 224 m cell 22 2749 cel 27 324pm cel 50 604pm en 17 2249m cal 22 2749 cel 17 22 pm cet 22 27 4m cel 32 404pm cel 40 504pm esl 17 224 cel 22 27 49m cel 27 3249 cel 17 22 em cok 17 224 m cel 22 27 4pm NN INS INS INS INS IS NIS INSINS INS INS INS INS INQUIS INS INSISS INS NIG INS INS INN INS ISSN INS NS IN 134433 322722234
13. provided Harbour Datec Organisma A Comments Comments 2 Mame IECIT EELER 7 4 Z2 2 e 7 7 Z 2 27 Fa zi z Z4 vs 2 2 2 Z 2 7 7 wm Bia BiSin aisis Noa s 88 ie 888 ial alate EAE At AE ME Ar E ds DE Gt At At SE M SE ME ST Dr E At Ar SE Ee E DE SE Page 7 of 28 BALSAM RISK Assessment Tool 3 3 Log out Users can logout of the system by clicking the logout link right top corner as shown in the screen shot below F Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure mm on Exemptions under the Ballast Water Management Convention et Cement te di as ieoa ho ALOCO IF 0 cos eget Iom o e LOCAT IF OF eee Options 1 User Guide 2 Data Model 3 HELCOM OSPAR Guidelines 4 Ballast Water Management Convention 4 Data Viewing In this section the way how information is stored in the system is detailed so it can be easily visualized by the user The Data tab is to be accessed for that purpose where access to different types of data is available see screen shot below port characteristics sampling environmental conditions sampling methodology and species recorded in the port surveys S 9 Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention As East Ais Mr te Ad faeces P Te MELCOMIO OAS ama Tapa tae Ph IE CCR EPR im LORI od Pee View De
14. 100 2 INITCAP B IJINITCAP C 3 CASE WHEN A 10 THEN B C ELSE B END Function ABS ADD MONTHS CASE CEIL CHR COALESCE COS CURRENT DATE Zooplankton GoB GoF Free swimming Crustacea GoR K OL 1924 Established suspension feeder and 30 BP11 VL11 ambush predator Page 19 of 28 BALSAM RISK Assessment Tool BRACE oes s 9 Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention Me Jo SS so lesen m te HH GHAB6 wes met assa E itai Bee je Ai Doces o he eELCOV O0 AA pes All Species in HELCOM OSPAR area P PIE CDIA EFIA SF a 1 8 LOCA TONS 2064004 ADE CORN 1905 063 Ta SOME COVETED Dott Pane weer ToT Te ter c 100 8750 ne 9 3530 HATO 2 820 Of Pe toe OF ceci Te eo actor in fe Acton men ty Ute information bee me ae ge s Compettor xyacaAze New TRO COMPLI CONST sw BrE 5 Aggregate this option enables to perform mathematical computations against a column Aggregates display after each control break and at the end of the report within the column they are defined Options include e Aggregation it enables the selection of a previously defined aggregation to edit e Function to be performed for example SUM MIN e Column it is used to select the column to apply the mathematical function to Only numeric columns are displayed In the example see screen shots a new value showing the average number of parallel
15. 12 Palaemon elegans observed Detatched epifauna heads missing but chela like elegans Naantali 20 06 2012 Se Ne SN PS NN Mobile Naantali 20 06 2012 epifauna Cerastoderma glaucum observed i Detatched epifauna Page 20 of 28 BALSAM RISK Assessment Tool jointbumexempti ns org iu ug lwel spinna hotel n Da sl eee apinan agg eb vd apu san Mcisla ign pou 4 RE Liptels i ciis ae Listeis tau Uca eee i3 2813 epfauna MR mplay irer ummy F Brag ahy eund x gos paton laia in pepe m ze Feeling plates Ampthi anot ampere man en upper tias Mipit Figg uae AIO nS SHE ral z ya in h Dr 261 V chAg Buen Agedin oper i z ET METET ret F chna pli Carcisik ruled are 7 yai A karl ret Fosnng piser Can Sry cun 15 yE Upper phis Fac pia MRa PPL D uEpar dos I Geer purs ml 5 yas Hana uas ut Faning pomen hen aoe CUBE gt wet upper tica Faubna BAM MENS EDS Y Kendo i Fosby piku MESS aiki i d y upper uas Fowiny pis sr Mian aus com yan kes tiia Fgubna pirin Wh files aduis d y hearer nina i Foin puen P hzusnoria be io Fed n Rpr in ppi I Facing platen iinimrerrpgha shinana i 4 TH uppet is Foring pires Eriergrmerpha asineriana a EE ETH uide L Faging pier AID IE domu ah y Upper TiO L Pipghreg piale Aphia armo avprmiiur crear 2 i upp ihi C20 Fosknggim Chemglnta z y VD HOY Facing pialer Cheer pISpus uil t 73 UPEN THA Fosbnq phai Conde casia pros rl a t t k ri ih
16. 2353432323213533322323343332333343147142313131 Page 14 of 28 BALSAM RISK Assessment Tool 4 8 Selecting the number of records per page in a report Users can set the number of records to be viewed in each page of a report Users can then navigate to the remaining records next pages by clicking the gt Next at the bottom of the page see screen shot below 1 Click on the Actions button Click on Rows per page and choose the desired number of rows that you want to see per page de Risk Assessrmeni Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention eme a ee AU Species m HELC ON OSPAH area ie fasi Tuin Tr ia aca ars i ah piat cole ra ient Pe Fare eei ard i Hui faTi irori A ordner Popes mmer rem cem eee bpoi bp gv pexpa dem pop pt m qe enr pm s ck C Nus pasce pa cach mu ep pior gon oer ream Sum hra ig gap fum cope pu rna 2 Thereport is displayed with the chosen number of records per page 10 in the example provided Page 15 of 28 BALSAM RISK Assessment Tool 4 9 Format of the displayed report Users can customize the display of reports There are a set of different options available see the screen shoot T Home Al Species in the HELOOMOSPAR wes All Species in HELCOM OSPAR area In thus section Pie tS Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention Hor Risk As
17. TR ome Tue mm am B mm Te 4 10 Previous viewing of data A flashback duery enables the user to view the data as it existed at a previous point in time The default amount of time that users can flashback is three hours see the screen shoot as m Fa s Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure TELE on Exemptions under the Ballast Water Management Convention d ioe Pada him Bi Rowe n MLO ma Pas binme Viae Dum View Data Options 1 Part Characteristics 2 Sampling Environmental Conditions 3 Sampling Methodology View Data in Pin bichi Aia cd Iss pki fours is Pos Grape Lione in Ihe porte ane provided A E ITI aramaber Fhir Lammas a u3 917913 gx v1 2913 9112013 03 112013 112913 1112043 112003 21112013 Taian d 14 3043 26 082013 2809 2013 35092013 ob PRT 28 08 2011 26082043 26082013 z amp Us 2011 z26 D3 2013 36 002013 S ih Ti 38 m 2003 26082043 26032013 28 02 2012 i EEPILINE roren E a E RA E e AN Big AR A ARAA AAA E F Pd s F m s z p Fa Pd st Fa P F zZ J 7 zt Ed dl 7 F Pd matt Le aca ee tiii Page 24 of 28 BALSAM RISK Assessment Tool 4 11 Obtaining data report Users can save customized reports for a future use A name and optional description is to be provided The report can be accessible to all users Four types of interactive reports can be saved Primary
18. Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention B uam oe ue mlul2iMiiMIZiulsiziB a siHBN LL EXE 111121117211111113111111111 IILILLLLL LLL eeeeeeeen Page 11 of 28 Be Bink ieee Rete y Rd imir ie ee HILL CASO IPA ma tommenis Upper uw Upper we upper me upper wor kun uir popes won een bow rope Lu d Kerri bur Upp m s uppi duse bimi datas no die Utena bpa mae aint uaine upper gue keen patr Ups moe kms gata kom nai Four im bagmert in rope Lpp mee En oot BALSAM RISK Assessment Tool 4 6 Adding and Removing Fields of choice for viewing Users can choose the desired fields columns to be displayed in the report This can be done as follows 1 In the desired data tab for e g in this case All Species in the HELCOM OSPAR area tab click on Actions gt Select Columns as shown in the screen shot s Risk Asieiinient Tool ender the HELCOMSOS PAR Hanmeniied Procedure eee STe Sn Exempitienas under the Ballad Water Management Conantin LLL mmn LITIR iem dg ares e mw EL GL E gon Ad Species in FHELCDAULOSPAR 252 mma acer peamgeos nr jo ma aa noms S HRSCR OU Pe Det vum a permit Pian meann Pub mum cb ed Wee abe em do safe ir sin ue ipecdascs Cach Te jail los B T mora Pera Sai aes Arius m Hon amha saoil Ms ds iig uo pi m m c motn T Fun Laeta 244 Knit di eons AUR B e LS 2 Select the desired columns that you want to display b
19. ata or Modify data when needed 3 GETTING STARTED Getting Started section explains how to log in to the BALSAM Risk Assessment Tool The section also presents briefly the various tabs in the toil together with their purpose 3 1 Login Page In order to log in to the Risk Assessment Tool the following URL in the browser is to be typed http jointbwmexemptions org ballast water RA The credentials required to log in are provided in the screen See screen shot below Qus COMMISSION Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure wate ann on Exemptions under the Ballast Water Management Convention www ipu Joint decision support tool on alien species introductions via Ballast Water This deckgion suppert h up vas adopted in 2013 by fe coastal counties of ma Balke Sea and Norm East ABants regions as us pari chapter 5 of the jointh ici throm On gr nbng exempbons tom ballad water reabmen s Sone of foe Intsenationud Convenbon fer me Control and Mar nag nerd tot Ships Ballast I ater and Sedimenti P EM Corie ot Be inmate onal Martens Organisation MO The aioa compri TI vinto jo 0n observa bons ef alien ppa es and phys ical features in ports a lis stot large alien ipecoss a BH of a8 marine alien species obseneed sn polt ds nine region and an agreed rii Le La rm ode a tx nl ade adrminierabons and enip s neni to quickly odanbhy routes thar may quali re seen lo tha appi sation ol ballast wale H anno ran cs bpi i 3 and ma
20. bes 2 Sampung Davirenme Consens 3 ampling bbe mei iin m mE EI Ir mma EE FK Ik EI PI RE m IE SEH 52 mn ET EJ 33 58 DI 24 98 2011 mx ET D il HANI DEEE NLIS PLUS a NAE NS UO Risk Assessment Tool under the HELCOM OSPAR Hormonised Procedure en Exemptions uncer the Ballast Wolter Monagement Convention BM O a na e L a Fargmrisr IIIITITITITITTI III iHd m suas wo De MB ee Be 1113131312131113331333131113 Cmmi The system enables to perform a set of possible Actions These can be performed either to the whole set of data or to a search criteria applied See screen shot below and the subsequent sections in the guide where they are further detailed View Data Options 1 Port Characteristics 2 Sampling Environmental Conditions 3 Sampling Methodology View Data Bn Bg bihari Del idu ol Bhur pecu Patel p Pee aie BM i eec m PE Uair 03 102002 m 11200 m 200 031102003 0 112003 112005 j 0111290 03 112913 0112013 83115003 CERTE 1 2809 2003 2808 28605 2009 2003 2800 2083 28 08 2013 28082003 2809 2003 28 09 2002 28092003 28 08 2013 28 08 2002 28 09 2003 26008200 2408 2013 EI E P Jp sz A F Pad F Fa s ZZ p p J 7 P F F s F a balla ETT Fonie putes Fouleg putes Foulrg putes Foulng plates Fouling plates Fouling plates Fouling pubem Fouirg pub Fovieg put Fouis plates Ful putes Fouling putes Risk Assessment
21. creen shots the shipping route selected is from Muuga to Gothenburg and all information on the risk assessment is shown show more details amp diagram Page 27 of 28 BALSAM RISK Assessment Tool OSPAR COMMISSION Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention i Home Risk Assessment Algorithm Al Species in the HELCOMO SPAR area Target Species in the HELCOMIOSPAR area Risk Assessment Quality Check Home gt Risk Assessment Risk Assessment in this section the risk of distribution of alien species via shipping navigation from one port to another is evaluated depending on the presence of invasive alen species on both ports and their salinity tolerance The outcomes of the assessment will be High Medium and Low risk which wil be used for the granting or not of an exemption to a ship saling that route In cases of ships transiting to two ports within the HELCOM OSPAR area please carry out the risk assessment from port A to port B and subsequently from port B to port C final destination From Select start harbour V to Select finish harbour Y Show more details L yes Show Diagram L yes Go Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention Home Rink Assessmeet Algo j Al Species in te HELCOMO SPAR area Target Specs in tie HELCOMO SPAR area Home gt Pisa Ansesemert
22. different download formats options are available CSV HTML and e mail see screen shots below F 33 Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure ee on Exemptions under the Ballast Water Management Convention mee a LOMO m View Data Options 1 Port Characteristics 2 Sampling Environmental Conditions 3 Sampling Methodology View Data Oe ew ine misin of fe peup toured m om perpen Later n Bo ports me probed Commenta nnan 9o ais m1 713 172213 23112901 umo 2 11215 m ununu 335 pace 2013 20 anonn AANO 34609298 nonn 2309291 23020 94 00 2015 apns Me 20 21 3020 Jp 7 F p F F P4 7 F 7 F 7 F P4 7 F F 7 2 31131111311131311131111111311 Page 26 of 28 BALSAM RISK Assessment Tool A lt L 25550 ET S Rik Assessment Tool under the HELCOM OSPAR Harmanised Procedure SSS et on Exenmpltions winder the Ballast Wolter Management Convention tra LEID gu X iue gp Add rci To ane e Po ey Ee domed i mw r vw vam Ware Cats Ophonrt 1 Port Zharaeberistics 2 Lamping Erman Camsmasnt 3 Sampling Marotta View Data je Bom mier eriak ul Bom mpra Uu no Pe nega Leher r Bon purin ar Erse nri Gaireas renal 1 p mum S ELTE BIN W FELII F 33133311111311113 ii e e Pg P PL s DI In case the user wants to reset the report back to the default settings removing any customizations previousl
23. elonging to the different Forms in the system bacteria benthic and so on are shown separately using this format option tS pr Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure P on Exemptions under the Ballast Water Management Convention C Horne Rick Assenument Apoti MESITLLSN I T gine e P ens A ks n jui OREO t All Species in HELCOM OSPAR area In this section formation on all the speces whose presence has been recorded in the ports covered is presented Please select from the search tool to arrange the avaiable information on each of the species or check the help option in the Actions menu for further information see the user guide Control Break Column 1 Form 2 Select Column 3 Select Column 4 Select Column 5 Select Column amp Salinity Salinity Salinity Salinity HMex NMin RM GB Min K11 BP11 GoF GoR M BP It only in Gulf of Gdansk BP GoB5 GoF K OL LF11 KF11 GoF35 GoG36 BP Gob Go K BP11 OLII KFT Men K LFI GoF 12 USGS fact sheet hflp nas er usgs gov quenes Tactsheet aspx speciesid 95 GoF Page 17 of 28 BALSAM RISK Assessment Tool M EN ES READE M anis Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure ain Sons on Exemptions under the Ballast Water Management Convention Home Rak Assessment Algorthes AB Species in he HELCOMOSPAR ama Tanpi Species inthe HELCOMIOSPAR anna ith A
24. em The section presents briefly the system menu Data Viewing section provides a detailed description of how the system can be used to view specific data using Search amp Filter options Performing the Risk Assessment section describes how to use the risk assessment tool to determine if there is a high medium or low risk scenario of spreading alien species by ships on voyages within ports in the Baltic and OSPAR area 2 SYSTEM SUMMARY System Summary section provides a general overview of the system The uses of the system s software system s configuration and user access levels are outlined Page 1 of 28 BALSAM RISK Assessment Tool 2 1 System Configuration The system is hosted on a Windows 2008 Server in an Oracle XE Database The application has been built using APEX Software provided by Oracle For more information please refer to the Oracle APEX documentation 2 2 User Access Levels There are three different levels of access to the Risk Assessment Tool e Read only access For all end users to view the data available in the tool and also perform the Risk Assessment Credentials for this type of user are available in the login page of the system e Read and Write access This access is available for experts to modify or correct specific data in the tool e Read Write and Load Data access This type of access is available for advanced users such as Data Managers amp Data Administrators who will Load new D
25. esictiee eiim odbinaehosrt dcc Uim tobte hme nres oh ox eee atone vial upra tide 16 aA LO Previous VICW ING Ol Ca Ue euenire hautisdot eon Bh n EE haihna a esu e ene UMP IM sa NM PESE 24 1 DSSDUIBINS odia WOOF esi tedcutt atat tU redeundi Rubel tS God NN MEQUE Mp Eie 25 Pertermmibe tHe RISKASSBSSITIe DU deve dide tindumv Et uiito tb dacotiadiden i madsp pni quas starts didi easa mad es 27 BALSAM RISK Assessment Tool 1 GENERAL INFORMATION This user guide aims at explaining how to go through the risk assessment tool in order to conduct the risk assessment of transporting a selected list of target species in ballast water between ports of the HELCOM and OSPAR marine areas 1 1 System Overview The risk assessment tool was adopted in 2013 by the coastal countries of the Baltic Sea and North East Atlantic regions as part chapter 6 of the joint harmonized procedure on granting exemptions from ballast water treatment provisions of the International Convention for the Control and Management of Ships Ballast Water and Sediments BWM Convention of the International Maritime Organisation IMO The tool comprises a database on observations of alien species and physical features in ports a list of target alien species a list of all marine alien species observed in port surveys in the region and an agreed risk assessment model It will allow administrations and ship owners to quickly identify routes that may qualify for exemptions to the application
26. ge tha palkhi niente car 19 da Ese Pip apin n fe Ahora menu cor turttes infonmuadtos ges Eae LOL gels Goll Go G reo Pook hors America R D DE REI Wan Lamm c Supping unc 3 2 5 Quality Check The Port Survey Protocol as contained in the HELCOM OSPAR Joint Harmonized Procedure establishes that species effort accumulation curves e g Hayek and Buzas 20107 are to be presented with the results of each survey to provide proof of adequate sampling effort in terms of number of samples taken from each site In this tab of the tool cumulative curves can be generated for each of the different group of organisms sampled in each port attached mobile epifauna benthos fouling mobile epifauna pathogens phytoplankton and zooplankton with the aim of evaluating if the number of samples taken represents the species present in the port Users can search and view the desired data using the Search and Filter options Filters can be set at multiple levels See screen shot below Please see section 4 5 with different examples to understand how to use the different options Hayek L C amp M A Buzas 2010 Surveying Natural Populations Quantitative Tools for Assessing Biodiversity 2nd Edition Columbia University Press Page 5 of 28 BALSAM RISK Assessment Tool si 4 OSPAR COMMISSION Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure AA on Exemptions under the Ballast Water Management Convention
27. her informabon see the user guide Target Species in the HELCOMO SPAR arma Rish Assessment Quality Check Gata Additional information amp Help Staius Charactasisice Salinity Salinity Salinity Salinity MMas MM BMa BMin GoB K11 BP11 GoF 11 Page 16 of 28 BALSAM RISK Assessment Tool M tS X Ex Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention g Home d Fish Assessment Agoten Target Species in the HELCOMOSPAR sree Risk Assessment Quality Chwech lt Osa d Addtorulindoemation amp EW FEADER Logout Hore gt Al Species n the HELCOWOSPAR area All Species in HELCOM OSPAR area In this section mformaton on al the species whose presence has been recorded in the ports covered is presented Please select from the search tool to arrange the avaiable information on each of the species or check the help opbon in the Actions menu for further informabon see the user guide GoFS K OL LFH KF11 GoF35 G0636 BP GoB GB K BP11 OL11 KF 11 Mit GoF 12 USGS fact sheet http nas er usgs goviqueries factsheet aspx specesid 05 GoF GoF Subspecies of Corigerius maeoticus Pengo 1879 2 Control break this format option enables to create a break group on one or several columns criteria Thus columns are pulled out of the report and displayed as a master record In the example see screen shoots all registers b
28. i Fowkhrph bi Cordioochaia capia girai qui uppit dide SRIMZEND Fosbn puer Cerdipteita Cees t oF Y Heer dida Fowbre peg aorta cad po Cini z i i Hepa a uh dh ho Bh dh dh d we ag Re iu as ui ai as hm el Foaki piben QOammanugs dp Cont E qui hersi ihi F shrg piat Mater ropes giri 1 yi keH ne F sglre plan FhineophrytaEitedophota 7 a F F F sf Pa 7 S a P4 d r d Ju Pi t d au JS rd s F Jt Fd a F FA a Pd JP S F F 6 Chart users can define one chart per saved report Once defined the links below the Search bar enables to switch between the chart and report views Options include e Chart Type to select from horizontal bar vertical bar pie or line type of chart e Label it enables to select the column to be used as label e Axis Title for Label it is the title displayed on the axis associated to the column selected as Label This option is not available for pie charts e Value it enables to select the column to be used as value If the function is a COUNT a Value does not need to be selected e Axis Title for Value it is the title displayed on the axis associated to the column selected as Value This option is not available for pie charts e Function it is an optional function to be performed on the column selected as Value e Sort it allows sorting the result set In the example see screen shot a pie chart has been created for the Gothenburg port fil
29. ment when performed See screen shot below Page 3 of 28 BALSAM RISK Assessment Tool ES Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure E on Exemptions under the Ballast Water Management Convention M igrom ow HEL CORO IPAR awe Sang iecur o Pe MEL COMO IPAR awe Mea Aves md Quai Ont OSP COMMISSION Hea Mae Antec re Agree Risk Assessment Algorithm The ama figure represents INe sporis used by Pe rnb atoetssesent 100i 1o Geimemne f Phere im a hyh medurm oF iow tmb scen are of spreading of aem spece by dha 06 rage viue porh n Pe Batic and OSPAN mee The man Geomon ports e Ihe aice me bried on Ihe sindy m he reipeche ports on The saint Iot ance of lapel spears amd on Phe occurrence of Serent large speoe n Pe Airt and Geslnabce ports gt 3 2 3 All Species in the HELCOM OSPAR area tab In this section information all the species whose presence has been recorded in the HELCOM OSPAR area is presented Users can search and view the desired data using the Search and Filter options Filters can be set at multiple levels See screen shot below Please see section 4 5 with different examples to understand how to use the different options available P SACK ES 9 Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention LE ba didis A ee Tegi lonas ite l BC SPA ams As nd Co Cute Abera cron tm a af ipsos 4 78 O9 mas
30. nt Algorithm tab All Species in the HELCOM OSPAR area tab Target Species in the HELCOM OSPAR area tab Risk Assessment tab Quality Check tab Data tab Additional Information amp Help tab The tabs on data visualization and risk assessment performance in bold format in the previous list will be separately treated in dedicated chapters due to their relevance 3 2 1 Home tab The Home Page is divided into two sections Introduction and Administrative Process sections In the first one brief background information on the role of the risk assessment tool within the frame of the International Convention for the Control and Management of Ships Ballast Water and Sediments BWM Convention is provided Subsequently the Administrative Process to be conducted by all applications aiming for a BWM Convention A 4 exemption in the combined HELCOM and OSPAR marine area is detailed See screen shot below Qiu dor rh in i i Sin A s Risk Assessment Tool under the HELCOM OSPAR Harmaonisecd Procedure on Exemptions uncer the Ballast Water Management Convention is rrt mM ba ed SP ter 3 2 2 Risk Assessment Algorithm tab The figure representing the algorithm used by the risk assessment tool to determine if there is a high medium or low risk scenario of spreading of alien species by ships on voyages within ports in the Baltic and OSPAR area is shown This enables to understand the results from the risk assess
31. of ballast water management for ships regulation B 3 and those that are unlikely to The online tool is jointly administered by the HELCOM and OSPAR Secretariats It was originally developed with funding through the HELCOM ALIENS 2 ALIENS 3 and BALSAM projects by HELCOM Secretariat and Germany BSH Brockmann consult The aim of the tool is to provide a simple interface to conduct the risk assessment of transporting a selected list of target species in ballast water between ports The level of risk is determined based on the presence of such species in the ports their salinity tolerance and the salinity conditions in the ports Once the level of risk is categorized it is used to evaluate the possibility of granting exemptions to the International Convention for the Control and Management of Ships Ballast Water and Sediments BWM Convention Regulation A 4 in the HELCOM OSPAR area 1 2 Organization of the Manual The user s manual consists of five sections General Information System Summary Getting Started Data Viewing and Performing the Risk Assessment General Information section explains in general terms the system and the purpose for which it is intended System Summary section provides a general overview of the system The summary outlines the uses of the system s software system s configuration and user access levels Getting Started section explains how to log in to the BALSAM Risk Assessment tool and start using the syst
32. ol in pdf format e The structure of the BALSAM Data Model See screen shot below e The Risk Assessment Algorithm used for assessing the risk e The HELCOM OSPAR Harmonised Procedure on the granting of exemptions under the International Convention for the Control and Management of Ships Ballast Water and Sediments Regulation A 4 in pdf format e The BWM Convention in pdf format w pr Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention Horre Hist Assevement Algontter AR Species in the HELCOMOSPAR ares Target Species in the HELCOMOSPAR area Rab Assess Quality Check Home Addon Informaton amp Help Options 1 User Guide 2 Data Model 3 HELCOM OSPAR Guidelines 4 Ballast Water Management Convention Page 6 of 28 BALSAM RISK Assessment Tool Please be aware that access to the Oracle Help Tool is accessible through the help icon see screen shoot below Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention kee Rib d AN Species in the MELCOMO SPAR aes Target Species inthe HELCOMOSPAR am Risk Assessment Quality Check Home gt View Osta View Data Options 1 Port Characteristics 2 Sampling Environmental Conditions 3 Sampling Methodology View Data in ths section detais of the speoes found in the samples taken n the ports are
33. on to define the filter condition In the example see screen shot those phytoplankton species in the HELCOM OSPAR area are highlighted in yellow rows emi o D GH Be LOO dil All Species in HELCOM OSPAR area in thes section informaton on all the species whose presence has been recorded in the ports covered i presented Please select from the search tool to arrange the available information on each of the species oc check the help option in the actions menu for further information see the user guide A Go Actions gt Highlight Name Ptyjtoplantc forms n HELCOM OSP Sequence 1 Enabled Yes v Highlght Type Row Y Badiground Color SF FFFS9 i i yeBow green flue orange red Tex Color s99CCFF lyetow green biue orange fred Operator Expression pe a MI o v contans Page 18 of 28 BALSAM RISK Assessment Tool 4 Compute this format option enables users to add computed columns to the report displayed These can be mathematical computations for example NBR HOURS 24 or standard Oracle functions applied to existing columns Options include Computation it enables to select a previously defined computation to edit Column Heading of the new column Format Mask it is an Oracle format mask to be applied against the column for example S9999 Computation expression it is the computation to be performed Within the computation columns are referenced using the aliases displayed Below Compu
34. ons 1 Port Characteristics 2 Sampling Environmental Conditions 3 Sampling Methodology L View Data In this section details of the species found in the samples taken in the ports are provided it Group By Sort Column Direction Null Sorting 1 Organisms lt br gt Group _ Ascending Ascending Y Nulis Always Last Y y 2 Species Name v Ascending Ascending Y Nulis Aways Last v 3 Select Column v Ascending v Defaut v 4 Select Column Y Ascending 6 Select Column v Ascending Default oat O Cancel Apply Ej Edit Group By Organisms Count Organisms l p gt pecies Name p Count Species Name Count Conn Species Name fores Count Species Name Count eee sdasia Page 23 of 28 BALSAM RISK Assessment Tool Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention i Homa j Fein Agee O ME teeter ie tha HELCCAHO Hesg s Ue Dubs View Data Options 1 Port Characteristics 2 Sampling Environmental Conditions 1 Sampling Methodology View Data n thus Section delais of the epee found in The tapie babar in ffe port ane peed A l a mU ms E EM Group By Count Oroaniame Gmup BR our sa in E d s dA Ga Qu a u ES ian Boe ee oe ba om dA Biwi Bi ee ibo dA X am d FERE ALPE eee Ge ERIT a da Be ham bi mh mh ma CDD mm xo Pj mm U
35. r a malae yrik ly to The on ira foal is joints adreiniviered by the A and Oi dente ada vas eniginally devebsped with fundresg T wu neat 22 hick 3 and E pre HELCON Secretanal an Md GM BSH Bnsckr Tha fturmer development of Tre eol will be supported by me pint task group of fe Tia commirons on Ballast Viner Managemen HELCORNUCHSPAR TG BALLAST which i I low up th imple mantation o d he Harmonized Procedure in general T ented f app cabon use Iw reader as user name and balwar as passaoed and you wil have might accets To conum me available infermaban Legem in caise you require medication or upload of new port survey data please contact HELCOM Secretariat helcom secrishelcom fi and or DSPAR Secretarial secratanatzospar cg Please mode fhial detailed information on the speci EE COE dedi nie boo is provided through links to the following database Tuahis Information prijam en Aquaic naon ndgenogs specie EANIS European Hatwerk on krape Alien Species ASIE Duebvarinig Alem Invasive Species bieria ie Europa 5 Nom Sea Alien Species database MarLIN Marire Lite Infarmabon hetir lector GB Non natmes Factsheet Editor 5 World Register of Marne Species Taxon Search http www oracle com technetwork developer tools apex documentation index html ssSourceSiteld opn Page 2 of 28 BALSAM RISK Assessment Tool 3 2 System Menus The System is organized in eight tabs as follows Home tab Risk Assessme
36. reen shots a Group By report is created on the species found per group of organisms in all ports were data are available Subsequently data are organized in alphabetical order us ES Ea Risk Assessment Tool under the HELCOM O e on Exemptions under the Ballast Water Home gt View Data View Data Options 1 Port Characteristics 2 Sampling Environmental Conditions 3 Sampling Methodology View Data In this section details of the species found in the samples taken in the ports are provided vy Go y Group By Group By Column 1 Organisms Group v 2 Species Name v 3 Select Column Functions Column Format Mask 1 Count Organisms Group 2 Count Species Name 3 Count Select Column 2 Gothenbu Amphibalanus improvisus J Gothenburg 03 11 2013 Fouling plates Amphibalanus improvisus Page 22 of 28 BALSAM RISK Assessment Tool Risk Assessment Tool under the HELCOM OS on Exemptions under the Ballast Water Home gt View Data View Data Options 1 Port Characteristics 2 Sampling Environmental Conditions 3 Sampling Methodology L View Data In this section details of the species found in the samples taken in the ports are provided A dte GOW hi E Edit Group By I Count Organisms peci Group count speci count Species Name nus Count Species Name Count Risk Assessment Tool under the HELCOM O on Exemptions under the Ballast Water Home gt View Data View Data Opti
37. sey ment Algora information on all the species whose presence has been recorded in the ports covered i presented ase select from the search All Speces in hw HELCOMO SPAR amma tool to arrange the avaiable information on each of the species or check the help option in the Actions menu for further information see the user guide Target Specirs mthi HELCOMOSPAR ares Risk Assessmert j Qualty Cwch Data K LUFT KFH Amera divagans Click on the Actions button Click on Format and choose from the list 1 Sort used to change the columns criteria to organize the registers and to choose to do it in ascending or descending order How to handle nulls values can also be specified they are displayed last or first by default In the example provided data as contained in the First Observed Year column have been organized in descending order see screen shoots x het e Home gt Ad Species in the HELCOM OSPAR aren All Species in HELCOM OSPAR area dn this section infor de Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure mation on al the species Please select from the search tool to arr on Exemptions under the Ballast Water Management Convention BW READER Logs Home Rist Assessment Algort r AS Speces n the HELCOWO SPAR ama whose presence has been recorded in the ports covered i presented ange the avaiable information on each of the species or the help option in the Actions menu for furt
38. t was marty coal he foci n viec p coa tr acapor and wat covered wih t 25 Sedem wan banc modd Of OS a lot of ce gig mate Be reraea of Dvsafve or gas opod aei wood 1 t 1 Sedeveet wae abc fid ioca we Landi 2 lot of Ganc maS oorawatec of wrud pices of ood mange of insect haoo Weeds of bases or GINOO mary orgaec rema covered by 35 Ev posuere Hi 3 23 Sedenert wes sand mud coarse sand Boho emm concrete Ce ae irmana Sang very bh cargo doch ON terme Shores rocky IS bhionn N Roro comtemers Gul etc Sof bottom Rocky hass Hetanen 5 Romo contenen Sof sediment concrete docks 35 Eaa Bochy shores Conismer rra Becky shores m bard tube ate boton 4 3 Sampling Methodology In this section specifications on the sampling methodology followed for the different group of organisms sampled is provided The groups of organisms to be sampled are mobile epifauna benthos fouling pathogens phytoplankton and zooplankton Then a distinction is made between fouling species found in the fouling plates versus those found when materials are scrapped The same applies to phytoplankton where a distinction is made between the phytoplankton species found in water sampled pooled versus those found when the sample is taken using a net see the Port Survey Protocol for further clarification Users can search and view the desired data using the Search and Filter options Filters can be set at multiple levels Please see section 4 5 with
39. tandard Oracle operator z not in between and enter an expression to compare against Expressions are case sensitive Use 96 as a wild card for example SPECIES NAME like A96 In the example shown in the screen shot the species which are established in the HELCOM OSPAR area are shown pens a ia EALLA Leoni o Risk Assessment Tool under Ihe HELCOM OSPAR Harmonised Procedure a on Exemptions under the Ballast Walter Management Convention argus mms r ma ii i Ps Baa rama aay rae Fits dorm ee dee ima n Ad oarak A Toi MELODY arab i m Aii Species in HEL CMIOSPAR area ke Bg prion ore pr gll Bar geo char coe hag been pecorino comm m popped eee g im igre Ban ppp ih ed prr rep Bom sakshi irem lior ors mach of he eps qr LE he japi opine ie oe clan ree ioa ete inthe pen Bon a praje E LEE ECTI Zz Page 13 of 28 BALSAM RISK Assessment Tool b If filtering by row complex clauses can be created using column aliases and any Oracle functions or operators for example G VA or G CT where G is the alias for SPECIES NAME In the example shown in the screens shots the different individuals of the gender Thalassiosira found in the ports sampled in the HELCOM OSPAR area are shown Fem FH See Agee eA UG eri 0 aded peed i em PRICIOMPCUPUAA an 0 Fini Bee eg Ded n Vimw Data Gpntsens 1 Port Characteristics i Bampling Environmental Conditions 1 Sampling Methodology View Data ini da ee ces ee
40. tation expression under Columns epigraph columns in the query are displayed together with their associated alias By clicking on the column name or alias a column is included in the Computation expression There is a Keypad next to Columns which functions as a shortcut to commonly used keys And next to Columns there is a list of Functions to be chosen In the example see screen shots a new column showing the difference of native maximum and minimum salinity is created Home gt All Species in the HELCOM OSPAR area All Species in HELCOM OSPAR area w ES a Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention Home Risk Assessment Algorithm All Species in the HELCOMIO SPAR area Target Species in ti 47 OSPAR COMMISSIO In this section information on all the species whose presence has been recorded in the ports covered is presented Please select from the search tool to arrange the available information on each of the species or check the help option in the Actions menu for further information see the user guide vr E Compute Computation New Computation Y Column Heading SALINITY DIFFERENCE Format Mask Computation Expression 3k Columns Form Species Name Taxon Area Of Origin Sub Basins First Observed Year Status Characteristics B C D E F G H I Create a computation using column aliases Examples 1 B C
41. ter to be done first to show only data available from that port showing the number of different type of organisms mobile epifauna fouling plates and benthos found in the port E ua Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure dii on Exemptions under the Ballast Water Management Convention oot Horne Risk Assets timent Algorithm Al Species in the HELCOMIO SPAR area Target Specie e the HELCOMO SPAR aves Rak Assessment Qrastty Chech Home gt View Data View Data Options 1 Port Characteristics 2 Sampling Environmental Conditions 3 Sampling Methodology View Data in this section details of the species found in the samples taken in the ports are provided Se OO umm it Chart I came DIE Cap tie ie Label Organisms Group Vale Vale Function Count Sort Defaut Cancel Delete Apply a Vf Harbour Name Edt Chart Page 21 of 28 BALSAM RISK Assessment Tool 7 Group by user can define one Group By report per saved report Subsequently the links below the Search bar enables the user to switch between the Group By and the Report views To create a Group By report select e the columns criteria on which to group up to three columns can be selected e the columns criteria to aggregate along with the function to be performed i a average sum count e the columns criteria to use for sorting up to three columns can be selected along with direction and null sorting options In the example see sc
42. uib sarge area 15 24215 Doe 22 2 2 Very hart ts cbtam a tainfacacry sample ani sampe sce sas wal Career gab sample area 15 Deere 1 Daoa Eimon gab semple ies 15 DScrme tS Doerr 2221782 2 2 Very good taeples Smeiled Ihe crude of bed win si baa fheas grab tampi ea 14 24015 Daimi Teap Dos cat r 2 232 7 om covered with 2 concrete sab Tiap Gee maneo Terp Coe entm Trag Gee meon Trap Bos cab at Teap Dos rae ae Trap Gee mmoc Trap Gee mm Trap Gee reece Tea Gee reres Trap Do rab tat 4 4 View Data At the bottom of the Data tab details of the species found in the samples taken during the port surveys are provided Users can search and view the desired data using the Search and Filter options Filters can be set at multiple levels Please see section 4 5 with different examples to understand how to use the different options 4 5 Using the Searching option The search bar available at the upper part of those tabs where information is provided enables the user see screen shot below to identify which column criteria to search or all Search icon to enter case insensitive search criteria wild card characters are implied Test box to execute the search Go button to display alternate default and saved private or public reports View Report button to customize a report View Chart button Page 10 of 28 BALSAM RISK Assessment Tool LL 1 Wiw Dass Cipmasns 4 Pave Chitaetkhri
43. y made the option Reset is available see screen shot below Q iaon de Risk Assessment Tool under the HELCOM OSPAR Harmonised Procedure on Exemptions under the Ballast Water Management Convention cy Be bun bagate AU Yu ru or oa Te loma As UC SRA ens As bw et Ss 11 EREESRETI i3i3 Siil 313333 t sisi 2222822 7 6 7 F AK 7 3 6 Pi 9 7 s T 4 d Z a pb 6 F Mr F uwuswEWXXEWXWM 29223222232231 Tere eS eee ee ee 133113111131111 5 Performing the Risk Assessment Based on the risk assessment algorithm contained in the homonymous tab the risk of distribution of alien species via shipping navigation from one port to another in the HELCOM OSPAR area is evaluated depending on the presence of invasive alien species on both ports and their salinity tolerance The outcomes of the assessment will be High Medium and Low risk which will be used for the granting or not of an exemption to a ship sailing that route In cases of ships transiting to two ports within the HELCOM OSPAR area please carry out the risk assessment from port A to port B and subsequently from port B to port C final destination The user is to select from the list of ports available both the port of origin and the destination port Then it can select having a complete explanation of the reasoning behind the risk assessment or only the result of such assessment In the example see s
44. y using the Move symbol as shown in the screen shot and click Apply dun m m Risk Azcessiruent Tool under Ihe HELCOBN OSPAR Hormmonisecd Procedure Ru EACEA Lop on Exemptionsz under the Ballast Voter Monagement Convention i i aee j mi M e cnn Om id Nu 1e aaa ii E o i i Hry AE SES 5 HELDOMICIEEAR r s iri Wem pede ote sioe pe H un npa ee perweror hau hagr renege Pom pat praed o Lamh Fwd eT Pa rS a i t MEG HEP oh d IT4SR EE DONOR POP ob RT Pues ed Ra Pu ROUITTGUNDS Bd TU ims Shine Page 12 of 28 BALSAM RISK Assessment Tool 3 New Report with chosen additional column appears S Risk Assessment Tool under the HELCOMJ OSPFAR Harmonlsed Procedure a povu on Exermplions under the Ballast Waler Monagement Convention p ma ek seers pee BE irei E Fa EE RS A y Uan ur Tae a Pah FER roms acs sa ee mas il priii a HELCONOSPAR area gon miur m in num pr gi Bon memor ewer pres Far eere ene Ps ior morem d Tasa uris LUE Wins Ba wa ed he iiir Bop hla i rR p aai sd Bhan Again ia Rack a aspe tpi Ba Loan manna bua Ree aller nda Nos cias posa Inversely users can also remove the desired fields columns in the report by clicking the lt Remove option and then clicking the Apply button 4 7 Using the Filter option Users can apply filters either by column criteria or by row register a If filtering by column select a column it does not need to be one that is displayed select a s
45. ysesumeet j Quality Choch Oats Additional bormation amp eS Aes ee oe All Species in HELCOM OSPAR area In thes section mfosmation on af the speces whose presence has been recorded in the ports covered is presented Please select from the search tool to arrange the available information on each of the species ox check the help option in the Actions menu for further information see the user guide B Fom 9 x Form Bacteria Form Benthic Salinity Salinity Salinity Salinity Mex MH Mis 3 111 E Kn Kil BP11 BP GoB GoB K BP11 OL11 KF 11 Mun GoF Benthic deposit feeder GoF BP11 K11 Benthic depos feeder BP CL GoB QU GER OS DR Benthic suspension feeder K LF t1 KF 11 Benthic deposi feeder Corti 91 Temp range 0 34C Freshwater and can tolerate brief salinty increase Renten at gn Benthic deposit feeder Benthic deposit feeder 3 Highlight it enables user to define a filter Rows meeting the filter criteria are displayed as highlighted according to the characteristics associated with the filter which are e Name of the filter displayed e Sequence in which the rules are evaluated e Enabled or disabled go a rule e Highlight type identifies whether the row or cell should be highlighted If Cell is selected the column referenced in the Highlight Condition is highlighted e Background Color of the highlighted area e Text Color for the text in the highlighted area e Highlight Conditi
Download Pdf Manuals
Related Search