CAMEO 101CAMEO 101

CAMEO99 WorkshopCAMEO99 Workshop

Crowne Plaza HotelCrowne Plaza Hotel

Navajo (C&D) RoomNavajo (C&D) Room

May 25, 1999May 25, 1999

Course OverviewCourse Overview

Learn basic concepts and functions Learn basic concepts and functions of the CAMEO systemof the CAMEO system

Provide demonstration of basic Provide demonstration of basic search functions and overview of search functions and overview of CAMEO’s interaction with other CAMEO’s interaction with other programsprograms

ObjectivesObjectives

At the end of the CAMEO At the end of the CAMEO introductory course, you should be introductory course, you should be able to:able to:– Comfortably maneuver around CAMEOComfortably maneuver around CAMEO– Use the chemical database and be Use the chemical database and be

familiar with CAMEO’s modulesfamiliar with CAMEO’s modules– Use CAMEO’s search functionsUse CAMEO’s search functions– Understand relationship between Understand relationship between

CAMEO and other software applicationsCAMEO and other software applications

What is CAMEO?What is CAMEO?

CAMEOCAMEO is computer software is computer software primarily used:primarily used:– For chemical emergency planningFor chemical emergency planning– For chemical response; and For chemical response; and – For regulatory compliance (e.g., SARA For regulatory compliance (e.g., SARA

Title III (EPCRA), OPA, RCRA)Title III (EPCRA), OPA, RCRA)

CAMEO ComponentsCAMEO Components

The overall CAMEOThe overall CAMEO system is a system is a suite of three separate, integrated suite of three separate, integrated software applications:software applications:– CAMEOCAMEO®® – MARPLOTMARPLOT®®

– ALOHAALOHA®®

CAMEO Answers QuestionsCAMEO Answers Questions

What hazards are at this site?What hazards are at this site? Where is the hazard located?Where is the hazard located? What is the chemical?What is the chemical? What specific hazard(s) does it What specific hazard(s) does it

present?present? How can the hazard be mitigated?How can the hazard be mitigated?

Who Developed CAMEO?Who Developed CAMEO?

Developed by:Developed by:– EPA’s Chemical Emergency Preparedness EPA’s Chemical Emergency Preparedness

and Prevention Officeand Prevention Office– NOAA’s Hazardous Materials Response NOAA’s Hazardous Materials Response

and Assessment Divisionand Assessment Division In collaboration withIn collaboration with

– U.S. Department of Commerce’s Bureau U.S. Department of Commerce’s Bureau of the Censusof the Census

– U.S. Coast GuardU.S. Coast Guard

CAMEO was Developed CAMEO was Developed for:for:

SERCs, TERCs, and LEPCsSERCs, TERCs, and LEPCs Emergency respondersEmergency responders Emergency plannersEmergency planners Chemical facilitiesChemical facilities

Major Uses of CAMEOMajor Uses of CAMEO

0%

10%

20%

30%

40%

50%

60%

70%

80%

ForEmergency

Planning

ForEmergencyResponses

For Support ofLEPC

For ManagingFacility

ChemicalInventory Data

Types of Organizations Types of Organizations Using CAMEOUsing CAMEO

Fire Department

48%

Chemical Facility

6%

Other Organizations

14%Emergency Planning/Response

32%

Fire Department

EmergencyPlanning/ResponseChemical Facility

Other Organizations

CAMEO Windows Systems CAMEO Windows Systems RequirementsRequirements

40 MB hard drive space40 MB hard drive space At least 8 MB of RAM to run At least 8 MB of RAM to run

CAMEO, ALOHA, MARPLOT and the CAMEO, ALOHA, MARPLOT and the Site Plan Viewer simultaneouslySite Plan Viewer simultaneously

IBM compatible PC with at least IBM compatible PC with at least 486 processor486 processor

Microsoft Windows 3.1 or betterMicrosoft Windows 3.1 or better

CAMEO BasicsCAMEO Basics

Login and Windows navigationLogin and Windows navigation CAMEO databases and linkingCAMEO databases and linking Find, Find All, and Quick Chemical Find, Find All, and Quick Chemical

searchessearches Data entry and Tier II form inputData entry and Tier II form input CAMEO Suite ApplicationsCAMEO Suite Applications

Navigating CAMEONavigating CAMEO

1. Records

2. Navigation aids

3. Button bars

4. Mouse menus vs.. Function keys

Navigating CAMEO (Cont.)Navigating CAMEO (Cont.)

Chemical Database Detail Chemical Database Detail ScreenScreen

Chemical Database Screen Chemical Database Screen 22

Response Information Response Information Data Sheet (General Data Sheet (General

Information)Information)

Chemical PropertiesChemical Properties

Chemical Health HazardsChemical Health Hazards

First Aid InformationFirst Aid Information

Fire HazardsFire Hazards

Fire FightingFire Fighting

Protective ClothingProtective Clothing

Non-Fire ResponseNon-Fire Response

Sources of InformationSources of Information

CAMEO’s Chemical Database CAMEO’s Chemical Database sources:sources:– 49 Code Federal Regulations49 Code Federal Regulations– U.S. Department of Transportation U.S. Department of Transportation

(ERG)(ERG)– Association of American RailroadsAssociation of American Railroads– U.S. Coast Guard (CHRIS)U.S. Coast Guard (CHRIS)– Chemical Abstract Service RegistryChemical Abstract Service Registry

Sources of Information Sources of Information (Cont.)(Cont.)

CAMEO’s Chemical Database CAMEO’s Chemical Database sources (cont.):sources (cont.):– National Institute for Occupational National Institute for Occupational

Safety and Health (Pocket Guide)Safety and Health (Pocket Guide)– Title III (List of Lists)Title III (List of Lists)– National Toxicology ProgramNational Toxicology Program

CAMEOCAMEO

CAMEO has an extensive database CAMEO has an extensive database with specific emergency response with specific emergency response information for over 4,000 chemicals.information for over 4,000 chemicals.

LimitationsLimitations– Expand and update the chemical Expand and update the chemical

databasedatabase– Simplify and broaden the importing and Simplify and broaden the importing and

exporting of dataexporting of data

MARPLOTMARPLOT

General-purpose mapping General-purpose mapping application of objects and Census application of objects and Census datadata

Links objects on maps to data in Links objects on maps to data in CAMEO and other programsCAMEO and other programs

ALOHAALOHA

ALOHA is an air dispersion model ALOHA is an air dispersion model used to evaluate hazardous used to evaluate hazardous chemical release scenarioschemical release scenarios

ALOHA can work with CAMEO ALOHA can work with CAMEO information and MARPLOT information and MARPLOT mappingmapping

CAMEO ModulesCAMEO Modules

Chemical Chemical InformationInformation

FacilitiesFacilities Chemicals in Chemicals in

Inventory/TransitInventory/Transit Storage LocationsStorage Locations Screenings & Screenings &

ScenariosScenarios

Toxic Release Toxic Release InventoryInventory

IncidentsIncidents ContactsContacts Special LocationsSpecial Locations ResourcesResources RoutesRoutes Census DataCensus Data

Module RelationshipsModule RelationshipsToxic Release Inventory

Chemicals in Inventory/Transit

Storage Locations

Chemical Information

Facilities

Screening & Scenarios

Incidents

Special Locations

Contacts

Routes

Resources

Census Data

MenusMenus

FileFile EditEdit ViewView RecordRecord

UtilitiesUtilities WindowWindow HelpHelp SharingSharing

Menus (Cont.)Menus (Cont.)

File: Allows access to various File: Allows access to various modules, manages the printer and modules, manages the printer and exit CAMEOexit CAMEO

Edit: Performs basic editingEdit: Performs basic editing View: Views information in several View: Views information in several

fashionsfashions Record: Accesses various detail Record: Accesses various detail

records and functions in the opened records and functions in the opened modulemodule

Menus (Cont.)Menus (Cont.)

Utilities: Perform basic system-Utilities: Perform basic system-level administrative taskslevel administrative tasks

Window: Perform standard Window: Perform standard Windows’ manipulationWindows’ manipulation

Help: Retrieve help informationHelp: Retrieve help information Sharing: Access ALOHA, MARPLOT, Sharing: Access ALOHA, MARPLOT,

and CAMEO’s Site View Plannerand CAMEO’s Site View Planner

Site Plan ViewerSite Plan Viewer

The blueprint for the Green Valley Water Facility

CAMEO ToolbarCAMEO Toolbar

•First Detail Record

•Previous Detail Record

•Next Detail Record

•Last Detail Record

CAMEO Toolbar (Cont.)CAMEO Toolbar (Cont.)

•Add

•Edit

•Delete

•Find

•Browse

CAMEO Toolbar (Cont.)CAMEO Toolbar (Cont.)

•Query

•Find All

•Save

•Cancel Changes

•Close

CAMEO Toolbar (Cont.)CAMEO Toolbar (Cont.)

•Site Plan Viewer

•MARPLOT

•ALOHA

•RIDS

•Help

Facilities ModuleFacilities Module

Tracks basic information about facilities Tracks basic information about facilities – AddressAddress– ContactsContacts

Provides check list of relevant regulations Provides check list of relevant regulations Tracks information from other Tracks information from other

modules modules Marks locations of facilities on MARPLOT Marks locations of facilities on MARPLOT

mapsmaps

Facilities Module (Cont.)Facilities Module (Cont.)

Facilities Module (Cont.)Facilities Module (Cont.)

Storage LocationsStorage Locations

Screenings and ScenariosScreenings and Scenarios

Performs hazards analysis calculationsPerforms hazards analysis calculations Assesses hazards from accidental Assesses hazards from accidental

releases of hazardous chemicalsreleases of hazardous chemicals Estimates threat zone by using either:Estimates threat zone by using either:

– Screenings - based on worst case Screenings - based on worst case assumptionsassumptions

– Scenarios - based on actual conditions in Scenarios - based on actual conditions in the user’s areathe user’s area

ScreeningsScreenings

ScenariosScenarios

Vulnerable ZoneVulnerable Zone

Toxic Release Inventory Toxic Release Inventory (TRI) Module(TRI) Module

You can use the TRI module to:You can use the TRI module to:– Store information from annual toxic Store information from annual toxic

chemical release reports filed by chemical release reports filed by facilities in your area.facilities in your area.

– View facilities’ yearly estimates of their View facilities’ yearly estimates of their release of certain toxic chemicals.release of certain toxic chemicals.

– Track reports of releases filed by Track reports of releases filed by facilities subject to emergency facilities subject to emergency reporting provisions.reporting provisions.

Toxic Release Inventory Toxic Release Inventory (TRI) Module(TRI) Module

Incidents (Page 1)Incidents (Page 1)

Incidents (Page 2)Incidents (Page 2)

ContactsContacts

Special LocationsSpecial Locations

Resources ModuleResources Module

Routes ModuleRoutes Module

Census Data ModuleCensus Data Module

Use to characterize the population Use to characterize the population around facilities for emergency around facilities for emergency planning and response and planning and response and hazards analysis.hazards analysis.

Census Data ModuleCensus Data Module

Obtain Census DataObtain Census Data

To obtain a copy of LandViewTo obtain a copy of LandViewTMTM III CD-ROM III CD-ROM for your region, contact:for your region, contact:– National Safety Council (NSC): 1-800-National Safety Council (NSC): 1-800-

992-2636 (or FAX order to 202-293-0032) 992-2636 (or FAX order to 202-293-0032) or http://www.nsc.org/ehc/cameo.htmor http://www.nsc.org/ehc/cameo.htm

– Customer Service, U.S. Bureau of the Customer Service, U.S. Bureau of the Census, Washington, D.C. 20233: 301-Census, Washington, D.C. 20233: 301-457-4100 (or FAX order to 301-457-3842) 457-4100 (or FAX order to 301-457-3842) or http://www.census.govor http://www.census.gov

FindFind FindFind

– Available in all modulesAvailable in all modules– Search one field at a time (pick one of five Search one field at a time (pick one of five

choices)choices) Matches records beginning with the text you enterMatches records beginning with the text you enter

– First record foundFirst record found– No “clear” necessary - each search clears the No “clear” necessary - each search clears the

last onelast one

Find AllFind All Find AllFind All

– Available in all modulesAvailable in all modules– Search one field at a time (pick one of five Search one field at a time (pick one of five

choices)choices) Matches records beginning with the text you enterMatches records beginning with the text you enter

– Capture all records meeting criteriaCapture all records meeting criteria– Need to clear Find AllNeed to clear Find All

Quick ChemicalsQuick Chemicals

Quick ChemicalQuick Chemical– Search only Chemical Information Search only Chemical Information

modulemodule– Search several fields at onceSearch several fields at once– And/or capabilityAnd/or capability– Only matches characters beginning Only matches characters beginning

with the specified letterswith the specified letters

QueriesQueries

QueryQuery– Search any moduleSearch any module– Search several fields at onceSearch several fields at once– And/or capabilityAnd/or capability– Most flexible search (many search Most flexible search (many search

fields)fields)– Searches partially defined text/numbersSearches partially defined text/numbers– Stores search/outputsStores search/outputs

Computer ScreensComputer Screens

1. Main Screen

2. Browse Screens

a) List of records in given module and their alpha order

b) Letter search marker

c) Record number

d) Function keys

e) Chemical information summary screen

3. Option Menus

a) Access to next level of information

4. Detail Screens

a) Fields of information

b) View vs.. Add/Edit

c) Page numbers

Chemical Information Chemical Information ModuleModule

The Chemical Information Module The Chemical Information Module contains over 4,300 hazardous contains over 4,300 hazardous chemicals. Each record contains data on:chemicals. Each record contains data on:

Description of the chemical including chemical Description of the chemical including chemical name and synonymsname and synonyms

Trade namesTrade names Identification numbersIdentification numbers Regulatory informationRegulatory information Labeling information

Response Information Response Information Data Sheets (RIDS)Data Sheets (RIDS)

The response Data Information Data Sheets The response Data Information Data Sheets (RIDS) located under the Chemical Information (RIDS) located under the Chemical Information Modules contains data on:Modules contains data on:

Description of chemicalDescription of chemical Chemical physical propertiesChemical physical properties Fire and health hazardsFire and health hazards Fire fighting recommendationsFire fighting recommendations Protective clothing dataProtective clothing data First aid information

Other Database ModulesOther Database Modules FACILITIES MODULEFACILITIES MODULE CHEMICALS IN INVENTORY/TRANSIT MODULECHEMICALS IN INVENTORY/TRANSIT MODULE STORAGE LOCATIONS MODULESTORAGE LOCATIONS MODULE SCREENING & SCENARIOS MODULESCREENING & SCENARIOS MODULE TOXIC RELEASE INVENTORY (TRI) MODULETOXIC RELEASE INVENTORY (TRI) MODULE INCIDENTS MODULEINCIDENTS MODULE CONTACTS MODULECONTACTS MODULE SPECIAL LOCATIONS MODULESPECIAL LOCATIONS MODULE RESOUCRES MODULERESOUCRES MODULE ROUTES MODULEROUTES MODULE CENSUS DATA MODULE

Database SearchesDatabase Searches

FindFind Find AllFind All Quick ChemicalsQuick Chemicals Queries

ScreensScreens

Browse Screen - The first layer in each data module is a browse screen.

Useful for quick viewing and navigatingUseful for quick viewing and navigating Limited but quick search capability with <Ctrl>FLimited but quick search capability with <Ctrl>F

Detail Screen - Primary work area for data maintenance.

Allows data entry/editingAllows data entry/editing Displays detailed informationDisplays detailed information Function key options are limitedFunction key options are limited

Searching Problem SetSearching Problem Set

Find the UN number for “Azotic acid”. What is the common chemical name?

A truck contains a metal can labeled “Exolit 405”. What do you think it is?

What’s the flash point of kerosene? Find the lower explosive limit for “methyl hydride” What chemical is called “Spirit of Hartshorn”? Using Quick Chemicals, determine how many EHS

chemicals are in the Chemical Information Module. How many chemicals start with the letter “C” and are EHS

chemicals?

Problem Set (Cont.)Problem Set (Cont.) You’ve been told that the formula for a chemical

is C6H15NO2. What is it? How many chemicals have a NFPA flammability

rating of 3 or carry a Flammable label? What chemical is also known as dichloromethane

( a commonly used synonym)? If you are searching for a chemical and the only

information you have is the following UN number, 1086, where should you begin?

What is the common name of this chemical? How many chemicals in the database require

the DOT label, “Spontaneously Combustible”? What is the “Flash Point” for ethylene glycol? What would be the most appropriate protective

clothing to wear when responding to a release of sulfuric acid?

How many facilities are located in Haymarket?

Problem Set (Cont.)Problem Set (Cont.)

How many chemicals start with the letter “S” and are Extremely Hazardous Substances?

Looking at the list from the previous question, can you find out what the DOT label for sodium selenite says?

Problem Set (Cont.)Problem Set (Cont.)

In this exercise you will update the Facility Contact information for the Green Valley Water Facility. Imagine that you are an LEPC and you have received a telephone call from the Human Resources department at the Green Valley Water Facility. Green Valley has a new Senior Plant Manager and they wanted to make sure that you had the most current contact information. You need to include this new information in your records for the Green Valley Facility. You have been given the following information:

Name: Wong, AngelaOrganization: Green Valley Water FacilityTitle: Senior Plant ManagerWork Phone: (703) 232 - 5547Beeper: (703) 232 - 7554

Data Entry ExerciseData Entry Exercise

You receive a call form Angela Wong, she reports that Green Valley just received a new shipment of chlorine. You need to update your records for the Chemicals in Inventory at the Green Valley Facility. You have been given the following information:

Chemical: ChlorineAmount: (5) 150# cylindersStorage Location: Water HouseOther: Pure, gas, greater than ambient

pressure, reactive, acute, normal ambient temperature

Data Entry (Cont.)Data Entry (Cont.)

QueriesQueries Create a query in the Facility module that allows Create a query in the Facility module that allows

you to search on any facility name. For query you to search on any facility name. For query output, display name and one phone number for output, display name and one phone number for queried facilities. Use the query you created to queried facilities. Use the query you created to find the phone number for Abalone Press.find the phone number for Abalone Press.

Determine how many facilities are located in Determine how many facilities are located in either Apple Valley or Haymarket.either Apple Valley or Haymarket.

CAMEO Searching CAMEO Searching LimitationsLimitations

Searches that are entered incorrectly, i.e. misspelled words, will not produce the desired search outcome. Garbage In—Garbage Out.

Remember that CAMEO only contains approximately 4,700 chemicals. Therefor, it is possible that a chemical you are looking for is not included in CAMEO.

Search MythsSearch Myths

Do not make the mistake of thinking there will only be one match for a chemical search, there may be several.

The computer may not always find the correct chemical. If a search outcome is different than you expected, go back and check your entry.

“No match” is the final answer. Again, if you are suspicious of a search outcome, go back and check your answer.

Tips and Short CutsTips and Short Cuts Always clear the search criteria before beginning

a new search. Always search the name field first for word

searches. The name field contains the chemical’s proper name as well as any other trade names the chemical has.

Make your searches as specific as possible without getting too specific.

When searching for a number containing four digits, always search the UN number field first.

For numbers starting with 48 or 49 search the STCC field first.

A code starting with letters can probably be found in the RTECS or name field.

Tips and Short Cuts (Cont.)Tips and Short Cuts (Cont.) Numbers ending in 0000 can probably be found

in the RTECS field. NOAA numbers are unique to CAMEO and would

never appear on a chemical label. Remember to enter a search in the Formula field

alphabetically.

Q&A SessionQ&A Session

The EndThe End

Thank you.

Please fill out the program evaluation form and place it in the box at the back of the room.

Evaluation Form Information:Instructor Name: Steve O’Krepky

Session: CAMEO 101 (introductory class)Rooms: Navajo C&D

Time: 10-12