Transcript Obsolete Pesticides Management System

Obsolete Pesticides
Management System
Training of Trainers
Rome
27 February to 2 March 2006
Welcome
Bienvenue
Start with some questions
•
•
•
•
•
Who has been involved in inventory?
Who has done the FAO inventory training?
Who has used the new inventory forms?
Who has used a computer database before
What does the Environmental Management Toolkit
do?
• Why are you here (let me answer this one!)
• Is anyone shy?
• Who wants to leave now (it’s your only chance!)
Aims of OPMS Training
• To introduce Obsolete Pesticide Management
System
• To understand its links with the new inventory
forms
• To understand its links with Environmental
Management Tookit
• To learn to use OPMS to enable you:
– To use it yourself for your inventory data
– To enable you to teach it to others in your team
• To get your feedback of the system
What will we be doing?
•
•
•
•
•
•
•
•
Using OPMS
Using OPMS
I’ll be lecturing as little as possible
Team working sessions
Group discussions
Individual presentations by you
Using OPMS
Hopefully enjoying the whole process
What we will give you
•
•
•
•
Copies of presentations at end of each day
Handouts
Files
CDs
What you will give us
•
•
•
•
•
Your undivided attention
Punctuality
A “phone free” environment
Feedback
Your ideas
Administration
• FAO is a no-smoking building
• Fire Exit
– Down the stairs to ground floor
– Out of building E, on the right
• Lavatories
• Breaks – Polish Bar in Foyer
• webmail – Dedicated PC with internet access.
– FAO forbids webmail on training PCs.
Agenda
Monday
13:30 to 17:00
Introduction and Overview of
OPMS
Tuesday
09:00 to 17:30
Entering Data into OPMS
Wednesday
09:00 to 17:30
Validation, Searching, Reports
Thursday
09:00 to 15:00
Prioritization and Strategy
Development
Introduction to the Workshop
Richard Thompson
• Waste Management
and Environmental
Consultant
• Cambridge University
Natural Sciences
• 20 years experience in
international waste
management
• 10 projects with UN
• Tel: 0039 3408768872
• Email: [email protected]
Introduction to the Workshop
• Mark Davis
• Coordinator & Chief
Technical Advisor
• FAO’s Obsolete
Pesticide Program
• PANUK
• Driving force behind
ASP
Introductions
• Jocelyne Mosseri-Cohen
• 10 years with the FAO Obsolete
Pesticides Team
• Has organized:– Ale
– Mark
– Kevin
• Translated OPMS French
Version and other guidelines
• Organized this course
Introductions
• Grazia Chiu
• 5 years with the FAO
Obsolete Pesticides
Team
• Has assisted:– Ale
– Mark
– Kevin
• Returns from maternity
leave 13th March
Introductions
• Maryse Finka
• Assisted with OPMS
French Version
• Organisation of this
course
And most importantly who are you?
• Take a sheet of flip chart paper
• Fill in your details
–
–
–
–
–
Name
Country
Ministry / Organization
job title / position
where you are based
• Come out and tell us all in your own words
• Include what you want to get out of this
training
Delegates
Name, Country
Organisation and Base
Role
Objectives for training
Cheikh Hamallah Sylla,
Mali
Min Environment,
DNACPN, Bamoko
Charge des Operations,
To understand OPMS
Jonathan Maluta
Mudzunga, South Africa
Ministry of Agriculture
Technical Advisor to the
Registry of Pesticides
To learn how OPMS feeds into CESA
Orlando Sosa, Belize
FAO, ROME
M&E Co-ordinator
To get a feel for OPMS and how it will
work with M&E
Samuel Msangi,
Tanzania
National Environment
Management Council, ASPPCT, Dar es Salaam
Field Manager, Principal
Environmental Officer
To understand how the OPMS
database works and how it links with
the Environmental Tool Kit
Lassina Traore, Mali
Min Environnement et
Assainissement,
DNACPN, Bamoko
Coordinateur
To understand OPMS well to be able
to train it to colleagues in Mali
Walid Dhouibi, Tunisie
Ministry of Environment and
Sustainable Development,
National Waste Management
Agency , ANGED-Tunis
National Coordinator of
Tunisian ASP, Principal
Engineer
To understand OPMS well to be able
to supervise the inventory and to
manage the data well.
Kamel Khalifa, Tunisie
Ministère de l’ Agriculture et les
Ressources Hydrauliques
DGPCQPA
Ingeniere Agronome,
Sous-Directeur des
Analyses et de la
normailisation
To be able to train the Tunisian
inventory team and learn more
Paul Kijazi, Tanzania
NEMC, ASP-PCT, Dar es
Salaam
Senior Env Officer, Field
Manager-ASP
To broarden knowledge of the
inventory processes
Abderrazak Marzouki,
Tunisie
Ministry of Environment and
Sustainable Development
Head of Recovery and
Recycling Dept
To learn how to use the database to
apply it to Tunisian inventory. To
Any questions?
Do we all now know why we are here?
The agenda for this afternoon
• Overview of inventory process
• Where does OPMS fit
– Paper-based Inventory system
– OPMS
– Environmental Management Toolkit
Before
With OPMS
Paper-based
inventory forms
Standardized
inventory forms
Excel Spreadsheet
or Word Table
Manual
Prioritization
OPMS
• Standardized and
simplified data
entry
• Automatic risk
calculations
• Integrated
prioritization
process
Strategy
Development
Strategy
Development
Manual calculation
of comparative risk
assessment
Break
15 minutes
New Inventory Forms
• Combined Site and Store folder/form
• Supplementary store form
• 7 Material forms
Combined Site and Store Form
• A3 format – form and folder
• For the first store at the site
• Site information
– Contact and emergency
information
– Logistics information
– Site plan
– Site photos
• Store information
– Dimensions
– Risk analysis
questionnaire
– Store plan
– Store photos
Supplementary Store Form
• A4 format
• For each of the other stores at the site
• Store information
– Dimensions
– Risk analysis
questionnaire
– Store plan
– Store photos
Material Form
• A4 format
• 7 designs for 7 material types
• Material types
–
–
–
–
–
Pesticides
Veterinary Products
Empty containers
Contaminated soil
Contaminated materials
(feed, seeds, fertilizer …)
– Contaminated building
materials
– Contaminated equipment
• Material information
– Pesticide product or
Pesticide contaminant
– Physical properties
– Condition
– Quantity
– Photos
– Samples
OPMS Structure
• Web application
– Server and database at FAO
– Access via internet with web browser (open it)
– Advantages
• Easy maintenance of the systems at FAO
• No complicated software for you to manage
• Data
– Data is your responsibility
– FAO just provide the tools
Data Structure
Site, Store
combination
1 Store Form
1 Risk Analysis
Multitude of
Material forms
Home Page
•
•
•
•
•
Language selection
Menu Bar
Log-in
Quick search
Outstanding actions
OPMS WorkFlow Process
DATA ENTRY
VALIDATION
REPORTING
PRIORITIZATION
DATA ENTRY
OPMS WorkFlow – Data Entry
Create 1 new
Site, store
Create Forms
for it
Data Entry in
its forms
Complete data
entry in a form
Finish the Site, Store
when data entry is
complete in ALL its forms
Log-in
• Explore home page
• Menu
• Language selection
• Have fun!
DATA ENTRY
Day 2
Data Entry
• Complete the one record as your country
• We’ll then enter data as Mali
– To build up sufficient data for demonstrating
OPMS reports
• Forms
– Store form (has site and store information)
– Risk analysis
– Material forms
Wizard
• Coloured Bars
– Shows you where you are
– Use to navigate forwards and backwards
– Colour coding used throughout (matches the
printed forms)
Mandatory Fields
• Immediately Mandatory Fields
– Required to be entered before you can advance
– Marked with *
• Necessary Fields
– Required before the form can be “completed”
Help
• Click on the field name in the wizard
• Hover over the menu items
Save & Session time-out
Save by:
• Move to next STEP in wizard
• For Products, click ADD or UPDATE
Session time-out
• Server disconnects after 60 minutes from previous
save
Store Data
• Admin areas
– Geopolitical areas
– Linked to maps in Prioritization Report
• Site and Store name
– Combination of Site, Store name, Country must be
unique, OPMS warns when it is duplicated
• Address
Store Data – for planning clean-up
• Services
• Contacts
• Logistics
GPS field
North +
West -
East +
South Latitude = degrees north (+ve) or south (-ve) of Equator
Longitude = degrees east (+ve) or west (-ve) of Greenwich meridian
GPS coordinate units
• It is easy to confuse Latitude with Longitude.
– It is therefore important that the inventory teams should include the
point of the compass when they record GPS co-ordinates
– Latitude should show N or S
– Longitude should show E or W
• OPMS uses Decimal Degrees to 4 decimal places
– +xxx.xxxx° or - xxx.xxxx°
– Decimal point “.” Not Decimal comma “,”
– 0.0001° = 11 metres on the world’s surface
• Accurate to specify a store
• Gazetteer can be used to look up coordinates of cities and
towns
OPMS may be re-designed to also
include N or S with latitudes, and E
or W with longitudes
Photos and scans
• Smallest file size suitable for use
• Scans – can be very large files, generally not
required
• Used a compressed format like .jpg or .gif
(NOT .bmp or RAW)
• Photos of labels – must be readable
– crop photo to the label
– compress to document quality 1.5MB » ~ 200kb
• General photos (drums, buildings, views)
– compress to web quality 1.5MB » ~ 50kb
Comment field
Inactive comment icon
Comment field is always open and visible
Active comment icon
Comment field only appears when icon is
clicked.
When a comment is saved, comment
closes and icon turns green.
Enter Risk Analysis Questionnaire
• Click with mouse
• Use:
– Tab to move
– Space-bar to select Y or N
Entering a material form
• Material type
• Pesticide look-up
–
–
–
–
In the OPMS list
Not in the OPMS list
Unknown
if 2 or more Active Ingredient, only the most toxic one is shown.
• Think of 50 pesticides that you’ll find in your inventory
– Look them up
– list any that are not there
• Hazards
• Physical condition
• Packaging
Entering a material form
• Quantity - 3 methods
– 27a based on the size of the containers
– 27b Estimate using the dimensions of a pile
– 27c Estimate using other units
• Photos
– Size considerations as before
• Comments
– Comments on the reverse of paper form
– Using the Comment icon
Modes
• Edit mode
– Wizard bars visible
– Fields editable and shown with white rectangles
• Review mode
– Overview bar visible
– Fields not editable or enterable
– Store form becomes one continuous document
Entering another stores on the same
site
• Edit mode
– At end of risk analysis form – “create another store
at this site” button
• Creates a new store with the same site information
• Enter each of the material types
• Enter similar batches of material with the
copy button
Samples
•
•
•
•
•
When do you need a sample?
Adding Samples
Sample number
Workflow of chasing sample
Sample results
– Excel or Word file
– Scanned paper report
Overview bar & Quick Search
• Overview bar
– Available in review mode
– Shows status of “site, store” and all its forms
• Quick search
– With field blank, Click to show all stores in your
country
– Type name of a “store” in field, then click to
show all stores that match what you typed.
Work flow Status during Data Entry
• The statuses:
– Data entry
– Form complete
– Store finished
• Changing status of form Data Entry to Form Complete
• Finish the Data entry for the whole store, and making it
available for checking
Practice entering further site/stores and materials
Users and Roles
• Country user
– Access to his own country’s data only
• Two roles
– Data Entry
• Enters data from paper forms
– Validator
•
•
•
•
Checks entered data
Evaluates information
Sets priorities
NB – can enter data exactly like Data Entry Role
User Name & Password
• Determines
– Country
– Role
• User name
– must be unique in the country
– can be any format
• Password
– combination of letters and numbers
– easy to remember
My Records
• seeing what needs to be done
– Forms to be completed
– Stores to be finished
– Samples to be chased
Day 3
• Finish Mali Data Entry
• Validation, Searching, Reports
Data Entry WorkFlow Process
DATA ENTRY
Create a new
Site, store
Create Forms
for it
Data Entry in
its forms
Complete data
entry in a form
Finish the Site, Store
when data entry is
complete in ALL its forms
VALIDATION
Data Entry blocked,
and forms “to be
checked”
Mali Data Entry
• Well done
– we have 13 stores in Mali
• Continue “Data Entry”
• “Complete” the forms
• “Finish” each store
Validation
• what do you need to check?
– In two groups, 15 mins
– Prepare a list to present on flip chart
Checking what’s been entered
Store form
• Is one form for the site
sufficient?
– Are risks analyses for all
areas of the site equal?
• Content
– Entered data matches paper
form (statistical check)
– Store name is relevant
– Admin areas are correct for
address
– Photos and plan match the
Risk Analysis
– GPS within the bounds of
the country
– Other fields entered
correctly
– Risk analysis is consistent
Materials
• Correct material has been
selected
• Data matches the photos
• Entered data matches paper
form (statistical check)
Usability
Do you know anything else about the site and materials that should be
entered?
OPMS WorkFlow Process
DATA ENTRY
Create 1 new
Site, store
Create Forms
for it
Data Entry in
its forms
Complete data
entry in a form
Fixed
Finish the Site, Store
when data entry is
complete in ALL its forms
amend
VALILATION
Data Entry blocked,
and forms “to be
checked”
Validate the Site, Store
when ALL its forms have
been checked
a form is
checked
Form is scrutinised
by the validator
Managing things that need to be
corrected
• Amend workflow
– a problem that Validator cannot immediately resolve himself.
– Validator selects AMEND
and enters what needs to be
done
– OPMS Allows a Data Entry user to edit that one record
– Data Entry users informed through My Records (and home
page)
– When issue resolved Data Entry user changes status to
FIXED
– Record is locked and Validator can check the record again
and verify that the problem is resolved satisfactorily
“Unfinish”
• A Data Entry user may press “finish” button
by mistake before they have entered all data.
– They can request the Validator to unblock the
Store, and reverting the whole store to be editable.
– To do this the Validator presses the UNFINISH
button.
Usability
• Assessing usability
– What are the criteria?
Usability
• Need for the product
– how much
– how soon
– what formulation
• Shelf life
• Quality
• tests required?
– Costs of tests, how long will they take
Check and Validate the stores and
materials – Practical exercise
• Check and Validate the stores that we have
created
– Hidden errors!
Example - Molodo
Situation at Molodo
• 1 single combined site, store form, with its single risk
analysis questionnaire has been used to record:
– 2 different areas of contaminated soil out in the open within
the compound; and
– 1 pesticide form for material in a store building
• The environmental risk factors for the contaminated
soil in the open are higher than those for the material
in the store building
• How should the inventory have been
recorded?
Quick search
•
•
•
•
with criteria
without criteria
ordering columns
detailed information at the click of the button
Search Menu
•
•
•
•
Search for stores
Search for materials
Complex searches
Practical exercise searching for information
– Reports export to excel
– Full listing
– Aggregations by Admin area
My Records
seeing what needs to be done
• Data Entry
– Forms to be completed
– Stores to be finished
– Samples to be chased
• Validation
– Forms to be checked
– Site, Stores to be validated
– Usable Products close to expiry date
Day 4
Reports
• Excel Exports
– “Listing” exports information on all “site, stores”
• Page of “Store Information”
– A row for every “site, store”
• Page of Material information
– A row for every material form
• A column for every field in OPMS
– Summary information, grouped by:
• Country (for FAO use)
• Admin 1
• Admin 2
Prioritization report
• The link to the Environmental Management
Toolkit
• Comparative Risk Assessment Evaluation
process
– Risk from the Environmental Conditions
– Risk from the hazards posed by materials
Risk Factor for the Environmental
Conditions
• EMTK sets out a scoring system for the
environmental conditions of the site,store
• The resulting Risk Factor is termed “Fe”
• The score is based on the questions in the
Risk Analysis form
– Each question has been weighted to give:
• Highest possible Fe for a store = 100
• Lowest possible Fe score = 0
• OPMS calculates Fe automatically
Fp  S p
Risk Factor from the Pesticides
• Each pesticide material in the site, store
poses a risk.
– The risk factor for the individual material is termed
Sp
– The total Pesticide Risk factor for the site, store is
termed Fp
Fp   S p
Calculating Sp
S p  3ST  SC Q
Where:
St = score for the toxicity of the material
Sc
=
score for the quality of its containment
Q
=
quantity in kg
Sp
• Sp is only calculated where material type =
– pesticide
– contaminated soil
– veterinary product (containing a pesticide AI)
• Sp is ZERO where material type =
–
–
–
–
–
empty containers
contaminated equipment
contaminated buildings
contaminated materials
veterinary products" (without an AI)
St
• St is a function of:
– LD50* (WHO class) of the material or formulation (not the
pure AI)
– Physical state (liquid or solid)
ST
16
Solid Materials
LD50*<5
Liquid Materials
LD50*<20
8
5<=LD50*<50
20<=LD50*<200
4
50<=LD50*<500
200<=LD50*<2000
2
500<=LD50*<2000
2000<=LD50*<3000
1
2000<=LD50*
3000<=LD50*
LD 50 100
LD 50 * 
Conc %
• LD50= smallest LD50 of all the AIs in the product; and
• Conc% = concentration (7) which should be (sum of concentrations
in % of all AIs in the product)
• If AI is "unknown" or "not in list" LD50= 4
Sc and Q
• Sc is a function of:
– How the material is contained
– Condition of container
Sc
Condition of container
16
Completely broken,
contents dispersed
8
leakage
2
surface damage,
no leaking
1
no damage
How contained
in-situ, in a pile,
no container
• Q = weight in kg:
– Calculated from 27a, b or c and default density
Icon to start the
prioritization report
EMTK/OPMS process
• Review VALIDATED “site, stores” only
• Review the distribution of Fe
– Investigate stores with very high or very low Fe
• Is it reasonable and valid on the basis of the data?
• Is the data correct?
• Review the distribution of Fp
– Investigate stores with very high or very low Fp
• Is it reasonable and valid on the basis of the data?
• Is the data correct?
EMTK/OPMS Risk Matrix
• Plot stores on a matrix of Fp* versus Fe
HIGH PESTICIDE
RISK ONLY
CRITICAL SITES
NON-PRIORITY SITES
HIGH ENVIRONMENTAL
RISK ONLY
0%
Fp* - normalised risk factor of the pesticide
100%
– Fp* = Fp of the store/highest Fp x 100%
0%
Fe - normalised environmental risk factor
100%
Store Prioritization
• Review stores in critical quadrant,
– OPMS lists them in in order of distance from top right corner
– The table above the matrix lists their characteristics
• If they pose such a risk that they should to be
prioritized for direct intervention
– In the table, select the “prioritize” box, and enter and save
the justification
• The store in the matrix will change to a black dot
• The geographical position of the prioritized and other
stores can be viewed in the map
• Review stores close to “prioritized” stores to
determine if they too should be prioritized.
– Clicking on a store in the map re-opens OPMS showing a
summary of the store and the nearest prioritized store
Colour coded Mali
stores on the risk
matrix
Regional Prioritization
• Determine whether to prioritize regionally based on
Admin 1 or Admin 2
• The matrix shows the regions plotted on the basis of
ΣFp* vs ΣFe* of their non prioritized stores
• Use the table above to determine the relative
prioritization of the regions.
– Set a level of priority for each area (1 to 5)
• View the map will show the regions colour coded
according to the prioritization and black dots for the
prioritized stores.
Map of Mali with:
2 prioritized stores;
Prioritized Admin1s
Strategy
• You have just determined the order in which OPMS
recommends that you prioritize your stores and
regions.
• There will be other factors that you should consider:
– Logistics
– Politics
• Ultimately, it is your responsibility to
determine/recommend your country’s strategy for
obsolete pesticide remediation.
• OPMS is a tool to help you with this decision.