Surface WAter Scenario Help (SWASH)
Contents
1. freund Kom koc 1 724 substance Macro inform inform Koc Koc halflife halflife tref tref vap vap VpTemp VpTemp pf pf Alterra SWASH Techn Report 1 3 doc 19 expb tresp freund diffusion fstar fext candeg metabolites substances for new substances SubstanceCode IsParent Name Locked for all substances if not locked Name ExpFre Kom substance_Macro inform Koc halflife tref vap VpTemp pf expb tresp freund diffusion fstar convert first metaboliet of parent substances of parent MetSubCodel false false substances_PRZM of parent icombo3 second metaboliet of parent substances of parent MetSubCode2 substances_PRZM of parent icombo3 20 expb tresp freund diffusion 86400 fstat fext 1000 candeg metab name metab of inform inform freund koc 1 724 inform Koc halflife tref vap VpTemp pf expb tresp freund diffusion 86400 fstat convett name Alterra SWASH Techn Report 1 3 doc 3 5 3 Export substances to MACRO At the end of SWASH or when the user starts the MACRO shell all substances are exported to the MACRO database First all substances in the MACRO compound and metab table are removed The information MACRO needs of a compound is stored in the SW2. FOCUS Version Control Workgroup takes care of version control of the various tools The SWASH developer has made Installation and Communication requirements protocols for the various tools to which each model update should comply Appendix 4 5 and 6 SWASH is default installed at the directory C SWASH The user has the possibility to choose another drive However versions of PRZM MACRO and SWASH must be installed at a subdirectory of the choosen drive See Appendix 7 for details At that drive the next structure is created C SWASH SWASH applicationfiles DATA SWASH db mdb MAPS map files MACRO lt MACRO applicationfiles gt PRZM lt PRZM applicationfiles przm prj gt MET PROGS T3G WPIC lt chmdat dat chmnum dat gt TOXSWA lt TOXSWA applicationfiles gt Pictures lt Jpg gt Files between lt gt are not installed during the SWASH installation Installations of MACRO PRZM or TOXSWA take care of that SWASH requires a PC with a Windows version 98 or higher with MSAccess 97 or higher It needs 6 5 Mb for installation SWASH has been developed with the Delphi Development Environment Normally Delphi uses the BDE Borland Database Engine to communicate with databases However Borland did not update the BDE with drivers for MS Access 2000 databases New PCs with Win2000 and Office2000 cannot read the SWASH and MACRO databases Therefore SWASH uses ODBC instead of the BDE In Delphi ADO components are u
3. applns Pome stone fruit late applns Potatoes Soybeans Sugar beets Sunflowers Tobacco Vegetables bulb Vegetables fruiting Vegetables leafy Vegetables root 24 Cereals_spring Cereals_ winter Citrus Cotton Field beans Grass alfalfa Hops Legumes Maize Oil seed rape spring Oil seed rape winter Olives Pome stone fruit early applns Pome stone fruit late applns Potatoes Soybeans Sugar beets Sunflowers Tobacco Vegetables_bulb Vegetables_fruiting Vegetables_leafy Vegetables_root Alterra SWASH_Techn_ Report_1 3 doc Vines early applns Vines early applns Vines late applns Vines late applns 3 5 7 Scenarios For the scenarios or locations the next coding should be used LocationCode Weather station AAA D1 Lanna S DRAINAGE D2 Brimstone UK DRAINAGE D3 Vredepeel NL DRAINAGE D4 Skousbo DK DRAINAGE D5 La Jailliere F DRAINAGE D6 Thiva GR DRAINAGE R1 Weiherbach D RUNOFF R2 Porto P RUNOFF R3 Bologna 1 RUNOFF R4 Roujan F RUNOFF Alterra SWASH_Techn_ Report_1 3 doc 25 4 Creating projects In SWASH the user creates projects Each project is characterised by one substance table projects Therefore it has a link to the substances table with all the information about the substance Each project has one or more runs table runs This means for one substance several runs can be defined Each run is characterised by a location crop and waterbody type and has a specifi
4. is intended to explain to users how to use SWASH and next perform the Step 3 FOCUS Surface Water Scenarios runs At present SWASH version 1 9 the coupling SWASH PRZM has not yet been extensively tested This implies that specifications with respect to the PRZM model may change in the next version of this document Alterra SWASH_Techn_ Report_1 3 doc 7 Summary To carry out the EU FOCUS pesticide exposure assessment scenarios for surface waters a number of FOCUS tools and models have to be run in sequence Each of these tools and models have been developed separately targeting a specific aspect relevant to the assessment These are e Drift Calculator calculating pesticide transport through drift e PRZM 3 calculating pesticide transport through run off e MACRO calculating pesticide transport through drainage e TOXSWA calculating the fate of pesticides in surface waters To facilitate the calculation of exposure concentrations at Step 3 level a software tool has been developed SWASH acronym for Surface WAter Scenarios Help It is an overall user friendly shell encompassing a number of individual tools and models involved in Step 3 calculations The pesticide transport through drift is automatically calculated bij the Drift Calculator The Drift Calculator can be also used as a tool to calculate spray drift depositions for separate not standard FOCUS step 3 runs PRZM 3 is a model that uses binary files to store information
5. on substances These files are updated by SWASH MACRO is a run oriented model It uses a MSAccess database pest focus mdb to store information on substances and runs This database is updated by SWASH SWASH is project oriented The user defines a project for a substance In the project runs are created for the selected crops scenarios and waterbody types For each project SWASH can generate a report with an overview of all the runs In addition SWASH provides information on the FOCUS Surface Water Scenarios Finally SWASH proposes a directory structure for the various models and their input and output to enable a smooth and correct communication between the various tools After completing a SWASH session the user must manually perform simulations with the individual models PRZM MACRO and TOXSWA From SWASH it is possible to start the shells of these models and perform the simulations SWASH prepared the models to guide the user easily through the various runs for pesticide applications to various ctops and it defines projects and runs for MACRO PRZM and TOXSWA that can be selected for execution after starting the corresponding shells Alterra SWASH_Techn_ Report 1 3 doc 9 1 Introduction Spray drift drainage and run off are three major routes of pesticide entry into surface waters Using spray drift deposition tables and the MACRO PRZM and TOXSWA models the exposure concentrations in surface waters can be assessed Exposure
6. scenarios have been developed as part of the EU evaluation process under 91 414 EEC FOCUS 2001 To carry out the EU FOCUS pesticide exposure assessment scenatios for surface waters a number of FOCUS tools and models have to be run in sequence Each of these tools and models have been developed separately targeting a specific aspect relevant to the assessment These are between brackets the name of the contact person for each tool has been mentioned e Drift Calculator calculating pesticide transport through drift M Russell e PRZM 3 calculating pesticide transport through runoff M Russell e MACRO calculating pesticide transport through drainage N Jarvis e TOXSWA calculating the fate of pesticides in surface waters P Adriaanse To facilitate the calculation of exposure concentrations at step 3 level a software tool has been developed SWASH acronym for Surface WAter Scenatios Help It is an overall user friendly shell encompassing a number of individual tools and models involved in Step 3 calculations The main functions of SWASH are e Maintenance of a central pesticide properties database Updating MACRO database pest focus mdb and PRZM data files chmdat dat chmnum dat e Provision of an overview of all Step 3 FOCUS runs required for use of a specific pesticide on a specific crop Therefore a project is created containing all needed runs with unique runld s for all models e Calculation of spray drift deposition
7. the parent chemical en two parts for the metabolites In the SWASH database the field IsParent table substances indicates whether a substance is a parent true or a metabolite false Reading one record from the data file means importing 3 substances in SWASH Index i indicates parent 1 first metabolite Z or second metabolite 2 SWASH substances for new substances SubstanceCode IsParent Name Locked if not locked name KocSol SlbWatRef MolMass MolEntVap CofDifAirRef parent MetSubCodel MetSubCode2 substance_PRZM SubstanceCode pstnam icheck1 icheck2 icheck3 22 defaults PRZM pstnameli true parent or false metabolite pstnameli false pstnameli kdspli solub i mwehtli enpy i 1000 4 18 dair i 10000 pstname 2 pstname 3 pstnameli pstnameli icheck1 icheck2 icheck3 Alterra SWASH Techn Report 1 3 doc ifi 1 then icombo3 icombo3 else icombo3 0 icheck5 icheck5 iqfac iqfac kdtyp kdtyp i apptyp apptyp i apprel apprel i dknum dknum i napp napp i kdsp kdsp i dratela dratela 1 dratelc dratelc 1 drate2a drate2a 1 fextrc fextrc i 100 qlOfac qlOfac 1 gbase qbase i prtrn12 prttn12 prtrn13 prtrn13 prtrn23 prtrn23 dtr121a dtr121a dtr121b dtr121b dtr121c dtr121c dtr1
8. to be able to save the various output files for a specific modelling project The default path is C SWASHProjects but the user is able to select any other path The project name is always the name of the directory The following structure is created for project output files C SWASHProjects testproject MACRO cropl M2T crop M2T PRZM cropl VPZT L ozip pzm Alterra SWASH_Techn_ Report_1 3 doc 49 crop2 MP2 21p pzm NTOXSWAN txw The PRZM Model Developer ensures that the following conditions are fulfilled following completion of PRZM modelling The P2T output files should be placed at the correct output directory The name of this directory should match the records 21 100 projectpath of the przm prj file located at the main directory of the PRZM application For each crop an output directory is created All other output files should be also located in this same output directoty The przm pzm file for the selected crop of this project is also located at this directory The P2T output files are named 12345 C1 P2T 12345 C2 P2T or 12345 C3 P2T C1 refers to the parent compound and C2 and C3 to metabolites The number 12345 corresponds to the communal SWASH runid 3 Communication SWASH updates the PRZM data files chmdat dat and chmnum dat The PRZM Model developer ensures that the following conditions are fulfilled The structure of the PRZM data files chmdat dat and chmnum dat is not changed The ag
9. unused in INFOCUS PRZ 1 2 life days phase 2 transfer of parent degradation in soil phase 1 1 gt 3 unused in INFOCUS PRZ unused in INFOCUS PRZ transfer of parent degradation in soil phase 2 1 gt 3 transfer of parent degradation in soil phase 1 2 gt 3 unused in INFOCUS PRZ unused in INFOCUS PRZ transfer of parent degradation in soil phase 2 2 gt 3 Foliar Extraction Foliar Decay rate transfer of parent degradation on foliage al0 factor ql0 base temperature Flag for soil temperature moisture degradation correction 1 3 Soil Moisture correction factor exponent 1 3 Soil Moisture corrction factor lab moisture 1 3 Solubility 1 3 Molecular weight 1 3 Uptake Factor Vapor Pressure Moisture factor relative to FC or Moisture factor relative to FC or Moisture factor relative to FC or oo chemical 1 chemical 2 chemical 3 de oe Alterra SWASH Techn Report 1 3 doc ICHECK6 Flag soil moisture correction KDDAYS K 1 1 1 5 K 1 3 unused in INFOCUS PRZM KDFAC K I I 1 5 K 1 3 unused in INFOCUS PRZM ENPY K K 1 3 enthalpy of vaporisation of pesticide for chem K DIAR K K 1 3 diffusion coeff of pesticide in air for chem K Alterra SWASH Techn Report 1 3 doc 43 44 Alterra SWASH_Techn_ Report 1 3 doc Appendix 4 Protocol for installation and communication requirements of MACRO for SWASH Whenever the MAC
10. 22a dtr122a dtr131a dtr131a dtr131b dtr131b dtr131c dtr131c dtr132a dtr132a dtr231a dtr231a dtr231b dtt231b dtr231c dtr231c dtr232a dtr232a mseff mseff i mslab mslab i solub solub i mwght mwght i isetl isetl iset2 iset2 iset3 iset3 substance Macro candeg pldkrt i feurnd frndcf i vap vp i fstar uptkf 1 Alterra SWASH Techn Report 1 3 doc 23 3 5 5 Export substances to PRZM SWASH gets all parents from the substance table if necessary adds the infomation of the metabolites and writes this to the PRZM datafile chwdat dat The number of written records to the datafile is written in the other datafile chmnnm dat 3 5 6 Crop names Every model should use these crop names When SWASH creates a project see Chapter 4 a subdirectory is created for each crop in a project using the name of the crop As some characters cause problems these are replaced by underscore characters The names in the second column are used as directory names MACRO doesn t know early or late applications For MACRO this part of the crop name is omitted Appln aerial Appln hand crop lt 50 cm Appln hand crop gt 50 cm Cereals spring Cereals winter Citrus Cotton Field beans Grass alfalfa Hops Legumes Maize no drift incorp or seed trtmt Oil seed rape spring Oil seed tape winter Olives Pome stone fruit early
11. ACRO cropl M2T crop M2T PRZM crop WEBA Ts BZ ps pzm crop2 FEAT 22Z1p pzm TOXSWA txw Alterra SWASH Techn Report 1 3 doc 45 The MACRO Model Developer ensures that the following conditions are fulfilled following completion of MACRO modelling The M2T outputfiles should be placed at the correct output directory The name of this directory should match the field pathinout from the table run in the database pest_focus mdb For each crop an output directory is created Also the bin log and sum output files should be located in this same output directory The M2T output files are named macro12345_p M2T in case of a parent compound and macro12345_m M2T in case of a metabolite Notice that MACRO can handle only one metabolite at a time and so in case of multiple metabolites originating from one parent SWASH creates a second run with a next runid for MACRO The number 12345 corresponds to the communal SWASH runid which generally differs from the MACRO runid mentioned in the names of the bin log and sum output files of MACRO 3 Communication SWASH updates the MACRO database pest focus mdb Created substances in SWASH are exported to the tables compound and metab Created runs in SWASH are exported to the tables applications and run The MACRO Model developer ensures that the following conditions are fulfilled The structure and field names of the tables compound metab applications and ru
12. ASH table substance Macro So the contents of this SWASH table is copied into the MACRO table compound or metab All substances which are marked as parent go to table compound Substances not marked as parent or substances used as metabolite are exported to table metab In the MACRO table metab the field inform refers to the parent substance MACRO SWASH If Parent then Compound substance Macro name substanceCode Koc Koc halflife halflife tref tref vap vap VpTemp VpTemp pf pf expb expb tresp tresp freund freund diffusion diffusion 86400 fstat fstat fext fext 1000 candeg candeg substances inform name FOCUStest Locked If Parent Compound has metabolites then first metabolite Metab substances name MetSubCode1 inform SubstanceCode second metabolite Metab substances name MetSubCode2 inform SubstanceCode If not Parent Metab substance Macro name substanceCode Koc Koc Alterra SWASH_Techn_ Report_1 3 doc 21 halflife tref vap VpTemp am pf expb tresp freund diffusion fstar fconvert halflife tref vap VpTemp pf expb tresp freund diffusion 86400 fstat fconvert 3 5 4 Import substances from PRZM PRZM stores its substance data in a data file chmdat dat The record structure contains three parts see Appendix 3 One for
13. ATE1A 1 FRNDCF 1 DRATE1C 1 amp DRATE2A 1 FEXTRC 1 PLDKRT 1 PRTRN12 Q10FAC 1 OBASE 1 amp PSTNAM 2 KDTYP 2 APPTYP 2 APPREL 2 DKNUM 2 NAPP 2 amp KDSP 2 DRATE1A 2 FRNDCF 2 DRATE1C 2 DRATE2A 2 amp DTR121A DTR121B DTR121C DTR122A FEXTRC 2 PLDKRT 2 amp PRTRN13 010FAC 2 OBASE 2 8 PSTNAM 3 KDTYP 3 APPTYP 3 APPREL 3 DKNUM 3 NAPP 3 amp KDSP 3 DRATE1A 3 FRNDCF 3 DRATE1C 3 DRATE2A 3 DTR131A amp DTR131B DTR131C DTR132A DTR231A DTR231B DTR231C DTR232A amp FEXTRC 3 PLDKRT 3 PRTRN23 Q10FAC 3 OBASE 3 IOFAC MSEFF K K 1 3 MSLAB K K 1 3 SOLUB K K 1 3 amp MWGHT K K 1 3 UPTKF K K 1 3 VP K K 1 3 ISET1 ISET2 ISET3 amp ICHECK6 KDDAYS K I I 1 5 K 1 3 KDFAC K I I 1 5 K 1 3 amp ENPY K K 1 3 DAIR K K 1 3 CLOSE 21 IF ICHECK3 EQ 0 IQFAC 0 RETURN END SUBROUTINE GETCHM Variable Definitions Note 1 chemical 1 2 chemical 2 3 chemical 3 SUBCODE Substance Code PSTNAM 1 Pesticide name of chemical 1 ICHECK1 Flag for bi phase degradtion ICHECK2 Flag for Foliar applications ICHECK3 Flag for Freundlich isotherm non linear adsorption ICOMBO3 Parent Metabolite relation
14. ApplicationNr SchemelD Rate CAM Depi Perc Foliar SprayDrift PercOfRate Alterra SWASH_Techn_ Report_1 3 doc Applications ApplicationNr ApplicationSchemes SchemeID Applications Rate Applications CAM Applications Depi Applications Perc Applications Foliar 1 Calculated SprayDrift by Calculator 31 4 4 1 Default Simulationdates Scenario StartDate EndDate D1 01 Jan 1982 30 Apr 1983 D2 01 Jan 1986 30 Apr 1987 D3 01 Jan 1992 30 Apr 1993 D4 01 Jan 1985 30 Apr 1986 D5 01 Jan 1978 30 Apr 1979 D6 01 Jan 1986 30 Apr 1987 Scenario first day of application StartDate EndDate R1 March May 01 Mar 1984 28 Feb 1985 R1 June Sept 01 Jun 1978 31 May 1979 R1 Oct Feb 01 Oct 1978 30 Sep 1979 R2 March May 01 Mar 1977 28 Feb 1978 R2 June Sept 01 Jun 1989 31 May 1990 R2 Oct Feb 01 Oct 1977 30 Sep 1978 R3 March May 01 Mar 1980 28 Feb 1981 R3 June Sept 01 Jun 1975 31 May 1976 R3 Oct Feb 01 Oct 1980 30 Sep 1981 R4 March May 01 Mar 1984 28 Feb 1985 R4 June Sept 01 Jun 1985 31 May 1986 R4 Oct Feb 01 Oct 1979 30 Sep 1980 32 Alterra SWASH Techn Report 1 3 doc 5 Installation amp Software Requirements The installation procedure only includes the installation of SWASH Versions of MACRO PRZM or TOXSWA should be installed at subdirectories of SWASH The
15. RO Model Developer intends to release a new version of the FOCUS MACRO SW he should take care that this new version fulfills the agreed installation procedure under the SWASH tool as well as the requirements for communication between FOCUS MACRO SW and SWASH The installation and communication requirements are specified below 1 Installation When SWASH is installed the following directory structure is created by the installation software C SWASH SWASH application files MACRO MACRO application files PRZM PRZM application files przm prj MET PROGS T3G WPIC TOXSWA TOXSWA application files DATA SWASH db mdb MAPS map files Instead of C another drive can be selected e g D or E The MACRO Model Developer ensures that the following conditions are fulfilled during installation of MACRO The complete MACRO tool should be placed in the subdirectory MACRO The MACRO Model Developer is free to create new subdirectories in this directory The database pest_focus mdb and the executable MACRO Focus exe are placed at the directory MACRO and not in a subdirectory 2 Output SWASH needs a project path to be able to save the various output files for a specific modelling project The default path is C SWASHProjects but the user is able to select any other path The project name is always the name of the directory The following structure is created for project output files C SWASHProjects testproject M
16. SH database to prepare for TOXSWA When the user creates a project he has to enter a path for the project Default path is C SWASHProjects The directory is always the project name At this directory all input and output will be written The next structure is created in case of the default path name and a project called test with scenarios for 2 crops Files 1n italic are created by SWASH rest are model output files C NSWASHProjectsNtest MACRO test report txt cropl M2T crop2 M2T PRZM cropl PDT zip pzm crop2 PDT z3p pzm NTOXSWA UXW SWASH maintains for PRZM a file with a listing of all created projects This file przm prj is located at the main directory of the PRZM application It has the next record structure 1 20 Projectname EPPOA 21 100 Projectpath C SWASHprojects EPPOA 101 117 CreationDate 26 Nov 2001 09 49 28 Alterra SWASH Techn Report 1 3 doc 41 Project Report SWASH creates a report file lt projectname gt _report txt with a listing of all created runs and its application pattern The report also shows the Mean Deposition and Mass Loading from the drift calculation This report is a guideline for the user it gives an overview of all runs to be performed with the various models 4 2 Files for PRZM PRZM has only runs to do for the runoff scenarios For each crop in the project a pzm file is created It is located at the PRZM crop subdirectory This file
17. Surface WAter Scenario Help SWASH version 1 94 Confinanced by ECPA and DG SANCO Surface WAter Scenario Help SWASH version 1 94 Technical Report version 1 3 J A te Roller F van den Berg P I Adriaanse Alterra Rapport 508 Alterra Green World Research Wageningen 2002 ABSTRACT J A te Roller F van den Berg P I Adriaanse 2002 Surface W Ater Scenario Help SWASH version 1 9 Technical Documentation version 1 2 Wageningen Alterra Green World Research Alterra rapport 508 59 pp 1 figs 2 refs The user friendly shell SWASH acronym for Surface WAter Scenarios Help assists the user in calculating pesticide exposure concentrations in the EU FOCUS surface water scenarios SWASH encompasses four separate tools and models FOCUS Drift Calculator calculating pesticide entries through spray drift deposition ti PRZM 3 calculating pesticide entries through run off Gi MACRO calculating pesticide entries through drainage and iv TOXSWA calculating the behaviour of pesticides in small surface waters It maintains a central database with pesticide properties and also information on projects and runs created by the user This report gives a detailed description of the necessary flow of data between the various models to make them communicate smoothly with each other It also specifies the installation requirements for the MACRO PRZM and TOXSWA models The MACRO model uses an MS Access database to store its substance an
18. WA uses the same database as SWASH No transfer of data is necessary SWASH just updates some tables in the database that are used by TOXSWA SWASH updates the database of MACRO with information of the pesticides Pesticides created by MACRO are transferred back to SWASH Runs created in a SWASH project are exported to MACRO It s not possible to create runs in MACRO so no run information has to be exported from MACRO to SWASH SWASH updates the data files chmdat dat and chmnum dat of PRZM with information of the pesticides Pesticides created by PRZM are transferred back to SWASH Projects created by SWASH are stored in the file przm prj This file is used by PRMZ to locate the information of the runs in the projects Information of the runs needed for one crop is stored in pzm files Alterra SWASH_Techn_ Report 1 3 doc 13 14 Alterra SWASH_Techn_ Report 1 3 doc 3 Data Structure The central pesticide database SW ASH database stores information on physico chemical properties as well as the use patterns of the compound Data can be entered directly by the user using the SWASH shell or data can be uploaded from the chemical property databases of MACRO or PRZM After exiting SWASH or choosing to update the database during a SWASH session the information in the central database is written back into the databases of MACRO or in sets of input files for PRZM TOXSWA makes use of the SWASH database In this way SWASH ensures that identical
19. Waterbodies Ganzelmeier and Regression have data needed for the drift calculator 3 2 MACRO MACRO uses three MSAccess databases 1 crops mdb crop information 2 focus mdb soil information 3 pest focus mdb run and substance information SWASH only uses the pest focus mdb Appendix 2 shows the structure of this database It is located at the main MACRO directory SWASH MACRO The tables compound and metab have the substance information where as the tables run and applications hold the project information However MACRO doesn t define projects but just uses runs Each run is characterised by a substance compound location and crop 33 PRZM PRZM stores its information in data files The files chmdat dat and chmnum dat are used by SWASH These files contain the substance information chmdat dat the real information and chmnum dat the number of substances They are located at the subdirectory SWASH PRZM WPIC 34 TOXSWA TOXSWA uses the same database as SWASH In SWASH a project can contain just one substance In TOXSWA one project can contain several substances Therefore some extra tables are added to the SWASH database Toxswamap and MapxProject A Toxswa map exists of one or more SWASH projects So a TOXSWA map can contain one or more substances Alterra SWASH_Techn_ Report 1 3 doc 17 TOXSWA runs are linked to a Application scheme This scheme has one or more applications and can be used by one or more runs In SWASH ea
20. al to macro00030_p m2t R1 Pond Parent 00032p pa 00032 C1 p2t R1 Pond Metal 00032p_m1 00032_C2 p2t R1 Pond Meta2 00032p_m2 00032_C3 p2t R1 Stream Parent 00032s_pa 00032_C1 p2t R1 Stream Metal 00032s_m1 00032_C2 p2t R1 stream Meta2 00032s_m2 00032_C3 p2t needed Alterra SWASH_Techn_ Report 1 3 doc 27 Please note that macro00031_p m2t Please note that only one PRZM run is Example 2 fictitious crop at D4 and R1 for a parent and two consecutive metabolites one being formed from the first metabolite runid starting at 40 Scenario waterbody Parent metabolite Runid Runid MACRO or SWASH TOXSWA PRZM D4 Pond Parent 00040p pa Macro00040_p m2t D4 Pond Metal 00040p_m1 Macro00040_m m2t D4 Stream Parent 00040s_pa Macro00040_p m2t D4 Stream Metal 00040s_m1 Macro00040_m m2t Please note that MACRO cannot handle meta2 R1 Pond Parent 00041p pa 00041 C1 p2t R1 Pond Metal 00041p m1 00041 C2 p2t R1 Pond Meta2 00041p m2 00041 C3 p2t R1 Stream Parent 00041s pa 00041 C1 p2t R1 Stream Metal 00041s m1 00041 C2 p2t R1 stream Meta2 00041s m2 00041 C3 p2t Only one PRZM run needed One of the main functions of SWASH 1s the preparation of input for the MACRO PRZM and TOXSWA models This consist of three parts Creating a project report files required to run PRZM and preparing the MACRO database SWASH also updates some tables in the SWA
21. at the correct directory Exit MACRO and SWASH Alterra SWASH Techn Report 1 3 doc 47 48 Alterra SWASH_Techn_ Report 1 3 doc Appendix 5 Protocol for installation and communication requirements of PRZM for SWASH Whenever the PRZM Model Developers intends to release a new version of the FOCUS_PRZM_SW they should take care that this new version fulfills the agreed installation procedure under the SWASH tool as well as the requirements for communication between FOCUS_PRZM SW and SWASH The installation and communication requirements are specified below 1 Installation When SWASH is installed the following directory structure is created by the installation software C SWASH SWASH application files MACRO MACRO application files PRZM PRZM application files przm prj MET PROGS T3G WPIC TOXSWA TOXSWA application files DATA SWASH db mdb MAPS map files Instead of C another drive can be selected e g D or E The PRZM Model Developer ensures that the following conditions are fulfilled during installation of PRZM The complete PRZM tool should be placed in the subdirectory PRZM The PRZM Model Developer is free to create new subdirectories in this directory The file versionnum dat and the executable PFSW exe are placed at the directory PRZM and not in a subdirectory The files chmnum dat and chmdat dat are placed at the subdirectory PRZM WPIC 2 Output SWASH needs a project path
22. ch runs has its own applications These two points make it necessary that SWASH prepares the database for TOXSWA 3 5 Matching Data At the start of SWASH runs and substances are imported from the MACRO database and substances from PRZM PRZM doesn t store information of runs or projects At the end of a SWASH session substances are exported to the MACRO database and to the PRZM files When the user in SWASH has created a project and has selected the option to export FOCUS input runs are exported to the MACRO database This option also creates input files for PRZM Before the user starts the MACRO shell from SWASH runs and substances are exported to the MACRO database When the user quits MACRO and returns to SWASH substances created during the MACRO session are imported into the SWASH database Analogously run and substance information is exported to the PRZM data files przm pzm and chmdat dat chmnum dat when the user starts the PRZM shell When the user quits PRZM and returns to SWASH substances created during the PRZM session ate imported in the SWASH database TOXWA uses the SWASH database therefore no further matching of data for TOXSWA is necessary 3 5 1 Export runs to MACRO With the Export FOCUS input to MACRO PRZM and TOXSWA button in SWASH all runs are exported to the MACRO database This means adding or replacing the records in the runs and applications tables Just one run is created in MACRO for locations with m
23. d run information while PRZM makes use of separate data files TOXSWA uses the central SWASH database After completing a SWASH session the user should manually perform simulations with the three individual models Keywords FOCUS MACRO Pesticide PRZM Scenario Surface Water TOXSWA Substance Installation Database User friendly Shell Software Development ISSN 1566 7197 2002 Alterra Green World Research P O Box 47 NL 6700 AA Wageningen The Netherlands Phone 31 317 474700 fax 31 317 419000 e mail postkamer alterra wag ur nl No part of this publication may be reproduced or published in any form or by any means or stored in a data base or retrieval system without the written permission of Alterra Alterra assumes no liability for any losses resulting from the use of this document Alterra is the amalgamation of the Institute for Forestry and Nature Research IBN and the Winand Staring Centre for Integrated Land Soil and Water Research SC The metger took place on 1 January 2000 Project 11234 Alterra rapport 508 09 2002 Contents Preface Summary 1 Introduction 2 Dataflow between the models 3 Data Structure 3 1 SWASH database 3 1 1 Projects 3 1 2 Runs 3 1 3 Substances 3 1 4 Global information 3 2 MACRO 3 3 PRZM 34 TOXSWA 3 5 Matching Data 3 5 1 Export runs to MACRO 3 5 2 Import substances to MACRO 3 5 3 Export substances to MACRO 3 5 4 Import substances from PRZM 3 5 5 Export substanc
24. ed application scheme table applications SWASH searches for every possible combination of location crop and waterbody type For each combination SWASH creates a run for the parent substance If the parent substance has metabolites a run is created for cach metabolite Each run has a RunID which is unique for all models and has the format XXXXX DH XXXXX 5 digit number for maximally 99999 runs w indicates waterbody type d Ditch s Stream p Pond pm pa Parent substance m1 first metabolite m2 second metabolite NB if a parent substance has two parallel metabolites then for the second metabolite an extra run is created with a new number and an extra run for the parent substance This is needed to meet requirements of the MACRO model Below two examples are presented that illustrate how runid s are allocated to the various runs of the different models Example 1 fictitious crop in D2 and R1 for a parent and two parallel metabolites runid starting at 30 Scenario Waterbody Parent meta Runid SWASH Runid MACRO or PRZM D2 Ditch Parent 00030d_pa Macro00030_p m2t D2 Ditch Metal 00030d m1 Macro00030_m m2t D2 Ditch Parent 00031d_pa Macro00031_p m2t D2 Ditch Meta2 00031d_m1 Macro00031_m m2t D2 Stream Parent 00030s_pa Macro00030_p m2t D2 Stream Metal 00030s_m1 Macro00030 m m2t D2 Stream Parent 00031s pa Macro00031_p m2t D2 Stream Meta2 00031s_m1 Macro00031_m m2t exists but is Identic
25. es bulb Vegetables fruiting Vegetables leafy 54 Alterra SWASH_Techn_ Report 1 3 doc Vegetables root Vines early applns Vines late applns Locations D1 D2 D3 D4 D5 D6 R1 R2 R2 and R4 More details have been described in Roller J A te F van den Berg P I Adriaanse 2002 Surface WAter Scenarios Help SWASH version 1 9 Technical report version 1 2 Alterra rapport 508 Wageningen the Netherlands 4 Test project to go through by the TOXSWA Developers before sending the new FOCUS TOXSWA version to the FOCUS Version Control Working Group Replace the old TOXSWA version with the new one Start SWASH Check the new TOXSWA version numbers from the SWASH tab sheet information option versions Create a new substance in SWASH Create a project containing D scenarios in SWASH using the new substance Create a project containing R scenarios in SWASH using a FOCUS substance Start the MACRO shell from SWASH Run MACRO using the new substance and runs created in SWASH Check if the output files are created at the correct directory Exit the MACRO shell and enter SWASH Start the PRZM shell from SWASH Run PRZM using the FOCUS substance and runs created in SWASH Check if the output files are created at the correct directory Exit the PRZM shell and enter SWASH Start the TOXSWA shell from SWASH Run TOXSWA for a D scenario using the new substance and runs created in SWASH and check t
26. es to PRZM 3 5 6 Crop names 3 5 7 Scenarios 4 Creating projects 41 Project Report 4 2 Files for PRZM 4 3 Preparing MACRO database 4 4 Preparing TOXSWA database 4 4 1 Default Simulationdates 5 Installation amp Software Requirements References Appendix 1 SWASH TOXSWA database relationships 2 MACRO database relationships 3 PRZM datafile structure CHMDAT DAT 4 Protocol for installation and communication requirements of MACRO for SWASH 5 Protocol for installation and communication requirements of PRZM for SWASH 6 Protocol for installation and communication requirements of TOXSWA for SWASH 7 Read_me file for installation of the SWASH software package 11 13 15 15 15 15 16 LT 17 17 17 18 18 19 21 22 24 24 25 27 29 29 30 31 32 33 35 37 39 41 45 49 53 57 Preface End 1997 the FOCUS Surface Water Scenarios Working Group started her activities The Group developed a tiered approach to estimate pesticide exposure concentrations that will be used for aquatic risk asessment in the pesticide registration procedure at EU level In the proposed Step 3 calculations several tools and models need to be combined to calculate exposure concentrations in the various types of surface water bodies To promote an easy and consistent way of calculation the idea rose to develop an overall user friendly software shell to guide the user through the needed calculations and to maintain a central pesticide database Alte
27. file has the format 12345_Cx p2f in which 12345 the unique 5 digit number corresponding with the SWASH runid for the indicated run Cx Substance type C1 parent C2 first metabolite and C2 second metabolite parallel or consecutively formed PRZM can handle both metabolites in a single run p2t extension indicating this the PRZM output file with lateral entry fluxes for TOXSWA More details on the run identity numbering are given in the first section of Chapter 4 3 1 3 Substances A user can use default FOCUS substances but more likely he will use his own defined substance Information about the substances is located at the tables substances 16 Alterra SWASH_Techn_ Report 1 3 doc substance Macro and substance PRZM Table substance Macro contains information specific for the MACRO model Substance PRZM contains information specific for the PRZM model 3 1 4 Global information Data for projects and substances can be changed by the user Next to these data the database contains static data that is used by SWASH and contains information about crops locations occurrence of crops in locations pesticide properties use patterns of chemicals on crops and water body types of locations i e pond ditch stream The user can just view this information e g a list with crops for a specified scenario The tables substancexcropxlocation and cropsxlocations store some default values on the application pattern The tables
28. hat the correct M2T file is read into TOXSWA Run TOXSWA for a R scenario using the FOCUS substance and runs created in SWASH and check that the correct P2T file is read into TOXSWA Check if the output files are generated at the correct directory Exit TOXSWA and SWASH Alterra SWASH_Techn_ Report 1 3 doc 55 56 Alterra SWASH_Techn_ Report 1 3 doc Appendix 7 Read me file for installation of the SWASH software package SWASH Read me first file date 11 Oct 2002 version 1 This readme file contains information for SW ASH model shell vetsion 1 9 SWASH TOXSWA database version 2 1 11 October 2002 If you suffer from installation problems or problems in the use of SWASH send an e mail to j a teroller wisl nl Installation The complete installation of the SWASH software pacakage includes five steps We can only garantuee a proper functioning of the entire package if you install all applications on the default directory The default directory for SWASH is C SWASH You may also choose another drive for example D or F In case you select another drive than C the other applications should also be installed on that drive and as subdirectories of the SWASH directory For example if you installed SWASH on D SWASH the other applications should be installed at TOXSWA D SWASH TOXSWA MACRO D SWASH MACRO PRZM D SWASH PRZM Step 1 Regional settings for MACRO Check the regional settings on your pc t
29. hey should be set to a default national setting without making any changes i e do not select Swedish and then change the number format from the default decimal comma to the decimal point Select My computer Control panel Regional options Numbers to check Step 2 Installation of SWASH If necessary uninstall previous versions of the SWASH Copy the SWASH zip archive to your local machine Unzip SWASH zip Run the Setup exe program and follow on screen instructions Alterra SWASH_Techn_ Report_1 3 doc 57 SWASH can now be started from the Start menu Step 3 Installation of TOXSWA If necessary uninstall previous versions of the TOXSWA Copy the TOXSWA zip archive to your local machine Unzip TOXSWA zip Run the Setup exe program and follow on screen instructions TOXSWA can now be started from the Start menu Step 4 Installation of MACRO See read me MACRO txt Step 5 Installation of PRZM See read me PRZM txt Hard and software requirements Operating systems SWASH has been tested on Win2000 WinNT and WinXP SW ASH is likely to run on Win95 and Win 98 machines howevet this has not yet been tested Win2000 has been combined with MS Office Access97 and with MS office Access2000 without prior Access 97 installed WinNT has been tested with MS Office Access97 WinXp has been tested with MS Office AccessXP Remark On some versions of WinNT problems can occur with the ODBC drivers I
30. i 4 G yes 4 5 7 10 no 4 5 7 10 GS yes 2 4 no di 4 4 5 Preparing MACRO database Preparing the MACRO database means exporting the created runs in the project to the MACRO database See 3 5 1 Export runs to MACRO MACRO uses the same application methods as SWASH However in the MACRO database it is stored in the table un as a number in the app method field SWASH MACRO aerial appl air blast granular appl ground spray soil incorp Ss NH 30 Alterra SWASH_Techn_ Report 1 3 doc 44 Preparing TOXSWA database TOXSWA uses the SWASH database To prepare the database for TOXSWA some tables are updated Table ToxswaMap MapID cteate new id Name projects Name Desctiption projects Description ModificationDate Now Table ToxswaMap MapID create new id ProjectI D projects ProjectID Table SimulationParameters RunlD Runs RunID StartDate Default startdate simulation see 4 4 1 EndDate Default enddate simulation see 4 4 1 OpLatEntryModel 2 PRZM MACRO LatEntryFile MACRO M2T or PRZM P2T filename Table ApplwationSchemes ApplicationSchemeID 12345xy 12345 first part of RunID x value 1 Ditch 2 Pond 3 Stream y value 0 parent 1 first metabolite 2 second metabolite Name AppScheme_ aRun RunID EndDistanceDrift 100 i POND then 30 EndDistanceLatEntry 100 i POND then 30 RatioUpstreamBound 0 2 if STREAM Table ToxswaApplications
31. is read by PRZM and contains all information it needs to do a run The file is structured like a windows ini file and looks like this generalsettings ProjectName Eppoa SubstanceCode EPPOA Relationship 1 one two or no metabolites CropCode Legumes R1 00005 run ids R2 00006 R3 00007 R4 00008 Applications Application pattern is identical for all runs AppMethod ground spray NumberOfApp 1 Rate CAM Depi Foliar Perc 1 1 00 0 4 0 0 0 0 R1 FirstDayYrApp 91 first possible day in year of LastDayYrApp 121 last possible day in year of MinIntervalApps 1 minimum interval in days between R2 FirstDayYrApp 96 LastDayYrApp 126 MinIntervalApps 1 R3 FirstDayYrApp 97 LastDayYrApp 127 MinIntervalApps 1 R4 FirstDayYrApp 97 LastDayYrApp 127 MinIntervalApps 1 Alterra SWASH_Techn_ Report_1 3 doc 29 Corresponding application methods PRZM SWASH A arial appl AB arial blast G grannular appl GS ground spray S soil incorp For some application methods additional information is required in PRZM such as CAM values Chemical Application Method and Foliar CAM App Method Depth Perc top 2 cm 1 soil exponential A AB GS 2 foliar linear A AB GS 3 foliar exponential A AB GS 4 uniform G x 5 furrow G x 6 surface not in SWASH 7 T band G x x 8 shank not in SWASH Defaults values App method Foliar CAM Depth A yes 2 4 no al 4 AB yes 2 4 no d
32. n is not changed The agreed names for crops and locations are used in the tables i e Crops Cereals spring Cereals winter Citrus Cotton Field beans Grass alfalfa Hops Legumes Maize Oil seed rape spring Oil seed rape winter Olives Pome stone fruit early applns Pome stone fruit late applns Potatoes Soybeans Sugar beets Sunflowers Tobacco 46 Alterra SWASH_Techn_ Report 1 3 doc Vegetables bulb Vegetables fruiting Vegetables leafy Vegetables root Vines early applns Vines late applns Locations D1 D2 D3 D4 D5 and D6 More details have been described in Roller J A te F van den Berg P I Adriaanse 2002 Surface WAter Scenarios Help SWASH version 1 9 Technical report version 1 2 Alterra rapport 508 Wageningen the Netherlands 4 Test project to go through by the MACRO Developer before sending the new FOCUS MACRO SW version to the FOCUS Version Control Working Group Replace the old MACRO version with the new one Start SWASH Check the new MACRO version numbers from the SWASH tab sheet information option versions Create a new substance in SWASH Create a project in SWASH using the new substance Create a project in SWASH using a FOCUS substance Start the MACRO shell from SWASH Run MACRO using the new substance and runs created in SWASH Run MACRO using the FOCUS substance and runs created in SWASH Check if the output files are generated
33. n that case try to run MDAC MDAC Microsoft Data Access Components is a tool from Microsoft and you can download it for free from the Microsoft internet site www microsoft com Access rights On WinNT Win2000 and WinXP machines it is necessary to have Administrator rights Preinstalled software Windows version 98 or higher MSAccess 97 or higher Hard disk memory SWASH requires 6 5 Mb for installation TOXSWA requires 3 5 Mb for installation Display 58 Alterra SWASH_Techn_ Report_1 3 doc Monitor with at least 800x600 at 256 colors Processor The faster the better Literature Roller J A te F van den Berg P I Adriaanse 2002 SUrface WAter Scenarios Help SWASH version 1 9 Technical report version 1 2 Alterra rapport 508 Wageningen the Netherlands Berg F van den P I Adriaanse J A te Roller 2002 Surface WAter Scenarios Help SWASH version 1 9 User s Guide version 1 2 Alterra rapport 507 Wageningen the Netherlands Known bugs Alterra SWASH_Techn_ Report 1 3 doc 59
34. onto various receiving water bodies and e Preparation of input for the MACRO PRZM and TOXSWA models Exporting run information to the MACRO database Creating a przm prj file with run information for PRZM Updating the SWASH database to prepare for TOXSWA In addition SWASH provides information on the FOCUS Surface Water Scenarios Finally SWASH proposes and creates a directory structure for the various models and their input and output to enable a smooth and correct communication between the various tools After defining a project in SWASH the user can start from SWASH the other individual models PRZM MACRO and TOXSWA SWASH does not execute Alterra SWASH_Techn_ Report_1 3 doc 11 model runs but provides guidance it helps the user to determine which runs need to be performed for pesticide applications to various crops and it defines projects and runs for MACRO PRZM and TOXSWA that can be selected for execution after starting the corresponding shells 12 Alterra SWASH_Techn_ Report 1 3 doc 2 Dataflow between the models SWASH is responsible for the flow of data between the models Figure 2 1 shows a scheme of the dataflow Spray Drift Calculator SWASH TOXSWA swash db mdb MACRO PRZM pest focus mdb chmdat dat chmnum dat przm prj pzm Figure 2 1 Flow of data between the models SWASH gets input from the Drift Calculator The drift percentage is calculated and used by SWASH as input for TOXSWA TOXS
35. or consistent information on pesticide properties and pesticide use is introduced into the consecutive model runs The database holds among other data information about crops locations occurrence of crops in locations pesticide properties use patterns of chemicals on crops and water body types of locations i e pond ditch stream The SWASH application communicates with the database and interacts with the user on the type of assessment to be made The application allows the user to select a chemical a crop and a use pattern 3 1 SWASH database See Appendix 1 for the database structure of the SWASH database It is located at the SWASH DATA directory 3 1 1 Projects In SWASH the user creates projects Each project is characterised by one substance table projects Therefore it has a link to the substances table with all the information about the substance Each project has one or more runs table runs This means for one substance several runs can be defined Each run is characterised by a location crop and waterbody type and has a specified application scheme table applications 3 1 2 Runs In SWASH each run is characterised by a unique run identity number runid The SWASH runid has the format 12345w_pm in which 12345 a unique 5 digit number enabling a maximum of 99999 different runs to be distinguished w water body type p pond s stream and d ditch pm substance type pa parent ml metabolite 1 and Alte
36. ore than one watetbody type These are the matching fields in the MACRO and SWASH tables MACRO SWASH run Runs runid i e communal RunID without s p d and pa m1 m2 SWASH runID first day FirstDayYrApp last day LastDayYrApp num apps NumberOfApps min int MinIntervalApps app method AppMeth 18 Alterra SWASH Techn Report 1 3 doc compound Projects SubstanceCode ctopname CropCode location LocationCode text info Projects Description PathInOut Projects Path MACRO CropCode without illegal characters like space and amp projectname Projects Name projectid Projects ID applications Applications RunID RunID without s p d and pa m1 m2 ApplicationNr ApplicationNr Dose Rate 3 5 2 Import substances from MACRO At the beginning of SWASH or when the user returns from the MACRO shell to SWASH all substances table compound and metab are imported from the MACRO database New substances are added and the others are updated Default SWASH has some FOCUS substances These are read only and can not be changed The field Locked is set to true These are the matching table fields If there is no matching field SWASH creates default values Table names in bold SWASH defaults MACRO compounds substances compound for new substances SubstanceCode name IsParent true Locked false for all substances if not locked Name inform ExpFre
37. reed names for crops and locations are used in the tables i e Crops Cereals spring Cereals winter Citrus Cotton Field beans Grass alfalfa Hops Legumes Maize Oil seed rape spring Oil seed rape winter Olives Pome stone fruit early applns Pome stone fruit late applns Potatoes Soybeans Sugar beets Sunflowers Tobacco Vegetables bulb Vegetables fruiting 50 Alterra SWASH_Techn_ Report 1 3 doc Vegetables leafy Vegetables root Vines early applns Vines late applns Locations R1 R2 R3 and R4 More details have been described in Roller J A te F van den Berg P I Adriaanse 2002 Surface WAter Scenarios Help SWASH version 1 9 Technical report version 1 2 Alterra rapport 508 Wageningen the Netherlands 4 Test project to go through by the PRZM Developers before sending the new FOCUS PRZM_SW to the FOCUS Version Control Working Group Replace the old PRZM version with the new one Start SWASH Check the new PRZM version numbers from the SWASH tab sheet information option versions Create a new substance in SWASH Create a project in SWASH using the new substance Create a project in SWASH using a FOCUS substance Start the PRZM shell from SWASH Run PRZM using the new substance and runs created in SWASH Run PRZM using the FOCUS substance and runs created in SWASH Check if the output files are generated at the correct directory Exit PRZM and SWASH Alte
38. rra SWASH_Techn_ Report 1 3 doc 51 52 Alterra SWASH_Techn_ Report 1 3 doc Appendix 6 Protocol for installation and communication requirements of TOXSWA for SWASH Whenever the TOXSWA Model Developers intends to release a new version of the FOCUS MACRO SW they should take care that this new version fulfills the agreed installation procedure under the SWASH tool as well as the requirements for communication between FOCUS TOXSWA and SWASH The installation and communication requirements are specified below 1 Installation When SWASH is installed the following directory structure is created by the installation software C SWASH SWASH application files MACRO MACRO application files PRZM PRZM application files przm prj MET PROGS T3G WPIC TOXSWA TOXSWA application files DATA SWASH db mdb MAPS map files Instead of C another drive can be selected e g D or E The TOXSWA Model Developers ensure that the following conditions are fulfilled during installation of TOXSWA The complete TOXSWA tool should be placed in the subdirectory TOXSWA The TOXSWA Model Developers are free to create new subdirectories in this directory The executable TOXSWA_FOCUS exe is placed at the directory TOXSWA and not in a subdirectory The file versionnum dat with the version numbers is updated and also placed at the directory TOXSWA N B TOXSWA does not install aswash_db mdb This is done by SWASH 2 Outp
39. rra SWASH_Techn_ Report_1 3 doc 15 m2 metabolite 2 So a run id of 00010d_pa indicates run number 10 and relates to a parent substance in a ditch The TOXSWA model uses exactly the same runids as SWASH does However MACRO has another system to number runs and does not need to distuinguish between different water bodies Its input files and output files have names according to the format names 23 ext in which names specifies file name macro paren or metab 123 a unique 3 digit number enabling a maximum of 999 different runs to be distinguished ext specifies file extension e g par bin log or sum Only the m2t output file containing the water and pesticide fluxes entering the waterbody is named differently This output file has the format Macro12345_x m2t in which Macro specifies file name 12345 the unique 5 digit number corresponding with the SWASH runid for the indicated run N B Note that this 5 digit runid differs from the 3 digit runid of MACRO x Substance type p parent m metabolite MACRO can only handle one metabolite per parent run m2t extension indicating this the MACRO output file with lateral entry fluxes for TOXSWA The PRZM model does not use run identity numbers to identify input files and output files except the p2t file containing the water and pesticide fluxes for TOXSWA Like MACRO it does not need to be able to distinguish between the different water body types The p2t output
40. rra took the initiative to realise the user friendly shell and from September 1999 to end 2002 SWASH acronym for Surface Water Scenarios Help was developed by Erik van den Berg and Paulien Adriaanse from Alterra in cooperation with Daniel van Kraalingen and Johnny te Roller from WISL Wageningen Software Labs Nick Jarvis Swedish Univ Agric Sci S for MACRO and Mark Russell Dupont Crop Protection USA and Mark Cheplick Waterborne env USA for PRZM collaborated closely with them to realise the communication between the models and the SWASH database Denis Yon Dow Agrosciences UK and Mark Russell developed together the FOCUS drift calculator FOCUS 2002 and this instrument has also been included in SWASH SWASH has been financed by various sources In 2000 the ECPA European Crop Protection Agency procured 20 keuro and the Dutch Ministry for Agriculture Fisheries and Nature Management also allocated 41 kf about 19 keuro for SWASH In 2001 DG SanCO from the EU contributed 38 keuro and in 2002 the Dutch Ministry for Agriculture Fisheries and Nature Management financed the remaining 20 keuro to finalise SWASH The current document Alterra rapport 508 is a technical document explaining the technical design of the SWASH database and communication and installation procedures This document will be helpful for possible future extensions or updates Additionally an user s manual has been written F van den Berg ct al 2002 This
41. sed instead of the BDE components SWASH has been tested on Win2000 WinNT and WinXP SWASH is likely to run on Win95 and Win 98 machines however this has not yet been tested Win2000 has been combined with MS Office Access97 and with MS office Access2000 without prior Access 97 installed WinNT has been tested with MS Office Access97 Alterra SWASH_Techn_ Report_1 3 doc 33 WinXp has been tested with MS Office AccessXP References Berg F van den P I Adriaanse and J A te Roller 2002 Surface Water Scenarios Help SWASH version 1 9 User s Guide version 1 2 Alterra rapport 507 Wageningen the Netherlands FOCUS 2002 FOCUS Surface Water Scenarios in the EU Evaluation Process under 91 414 EEC Report of the FOCUS Working Group on Surface Water Scenarios EU Document Reference SANCO 4802 2002 rev 1 221 pp Alterra SWASH_Techn_ Report 1 3 doc 35 Appendix 1 SWASH TOXSWA database relationships Aap Project mf ID Substance Macro BubstanceCode inform Qc alflife ref hap NpTemp pf Bob kresp freund Hiffusion E xt Hain onvert Substance PRZM BubstanceCode pstnam checkt check2 check3 combo3 check5 da dtyp Epptyp Epprel knum Lo sp pratela Krateic Hrate2a festrc pldkrt alOfac hbase preni2 rtni3 pna tri21a pltri21b ptri2ic pltri22a ptri3ta ptri31b pltri3te pltri32a Ht231a ptr231b ptr231c Htr232a mseff mslab bolub mwght Lptkf tp set el set3 1 Substances bub
42. ship ICHECK5 Flag for volatilization IQFAC Flag for soil temperature moisture degradation correction KDTYP 1 Soil Partition type APPTYP 1 Application type APPREL 1 Application timing DKNUM 1 Second Phase 1 2 life beginning relative to lst application NAPP 1 of applications KDSP 1 Soil Partition value Alterra SWASH Techn Report 1 3 doc 41 D No NO PO EH EH y QANt 5 Ei pi Bd os 1 2 life days phase 1 Freundlich coefficient unused in INFOCUS PRZM 1 2 life days phase 2 Foliar Extraction Foliar Decay rate transfer of parent degradation on foliage al0 factor qi0 base temperature Pesticide name of chemical 2 Soil Partition type Application type Application timing Second Phase 1 2 life beginning relative to 1st application of applications Soil Partition value 1 2 life days phase 1 Freundlich coefficient unused in INFOCUS PRZM 1 2 life days phase 2 transfer of parent degradation in soil phase 1 unused in INFOCUS PRZM unused in INFOCUS PRZM transfer of parent degradation in soil phase 2 Foliar Extraction Foliar Decay rate transfer of parent degradation on foliage al0 factor ql0 base temperature Pesticide name of chemical 3 Soil Partition type Application type Application timing Second Phase 1 2 life beginning relative to 1st application of applications Soil Partition value 1 2 life days phase 1 Freundlich coefficient
43. stanceCode Alterra SWASH_Techn_ Report 1 3 doc Mz ons SubstancexCropxLocation SubstanceCode Def NumberOfapps DefMinInterval pps 37 SimulationParameters ApplicationCAMDefauls Hon CAMTypes ApplicationMethod AMnr Description ApplicationMethods z i WaterBodies DispersionLenath epSimHydrology Applicatiens oncentration RatioCrgaricMatSuspSolid DryWeightMacrephytes 4 HydrologyOptions bpsimHydrology HydrologyPond DistanceChangeReg Appendix 2 MACRO database relationships Relationships for pest_focus donderdag 26 september 2002 applications RunID Application projectname projectID Alterra SWASH_Techn_ Report_1 3 doc 39 Appendix 3 PRZM datafile structure CHMDAT DAT This part of a fortran subroutine shows the record structure of the data file chmdat dat SUBROUTINE GETCHM Gets values of chemical from database and puts them into dialog fields 200 FORMAT A20 A20 9 11 13 12 e10 4 9 F7 2 A20 3 11 13 12 e10 4 13 F7 2 8 A20 3 11 13 12 0e10 4 17 F7 2 I1 6 F7 3 3 E10 4 6 F7 3 3B E10 4 411 amp 1515 15F5 2 6F8 3 OPEN 21 FILE DRVLTR NSWASHNPRZMNWPICNCHMDAT DAT amp STATUS UNKNOWN amp ACCESS DIRECT amp FORM FORMATTED RECL 760 READ 21 200 REC NOPT1 SUBCODE amp PSTNAM 1 ICHECK1 ICHECK2 ICHECK3 ICOMBO3 amp ICHECK5 IQFAC KDTYP 1 APPTYP 1 APPREL 1 DKNUM 1 amp NAPP 1 KDSP 1 DR
44. ut SWASH needs a project path to be able to save the various output files for a specific modelling project The default path is C SWASHProjects but the user is able to select any other path The project name is always the name of the directory The following structure is created for project output files Alterra SWASH_Techn_ Report_1 3 doc 53 C SWASHProjects testpro ject MACRO cropl M2T crop2 M2T PRZM crop PZT Z1p pzm crop2 SPAT EZS pzm TOXSWA txw The TOXSWA Model Developers ensure that the following conditions are fulfilled following completion of TOXSWA modelling The M2T output files should be read from the correct MACRO crop directory The P2T output files should be read from the correct PRZM crop directory The txw files and TOXSWA output files should be placed at the TOXSWA directory 3 Communication SWASH and TOXSWA make use of the same database This implies that The TOXSWA Model Developers ensure that the following conditions are fulfilled The structure and field names of all tables of the SWASH db mdb are not changed The agreed names for crops and locations are used in the tables i e Crops Cereals spring Cereals winter Citrus Cotton Field beans Grass alfalfa Hops Legumes Maize Oil seed rape spring Oil seed rape winter Oltves Pome stone fruit early applns Pome stone fruit late applns Potatoes Soybeans Sugar beets Sunflowers Tobacco Vegetabl
Download Pdf Manuals
Related Search