INNOVATIVE USE OF THE EXCHANGE NETWORK FOR DISTRIBUTING LAB DATA ACCESS VARIOUS ENVIRONMENTAL PROGRA

1
INNOVATIVE USE OF THE EXCHANGE NETWORK FOR
DISTRIBUTING LAB DATA ACCESS VARIOUS
ENVIRONMENTAL PROGRAMS

• Sanwat Chaudhuri, Ph.D.
• Terry Forsgren, Robert Lo
• UDOH-PHL

Annual Conference 2009
2
Outline

• From an almost all manual to almost all
  electronic data exchange
• Lab bk. Ground
• Lab data exchange goals
• Activities accomplishments
• Challenges

3
Chemical Environmental Services (BCES)

• State Primacy Lab for EPAs DW program
• Level 2 Lab for CDC

• Clinical
• CDC/BT/CT
• emergency response
• EPHT
• Biomonitoring

• Environmental
• sample testing
• lab data reporting
• Emergency Response

Annual Conference 2009
4
UTAH PUBLIC HEALTH LABORATORY PARTNERS DATA
USERS
Annual Conference 2009
5
BUSINESS FLOW
Annual Conference 2009
6
Field Sample
Annual Conference 2009
7
Sample Kit
Annual Conference 2009
8
Pesticide Extraction
Annual Conference 2009
9
ICP-MS / Metals
Annual Conference 2009
10
GC / MS VOC ANALYSIS
Annual Conference 2009
11
GC / MS PESTICIDE ANALYSIS
Annual Conference 2009
12
NUTRIENT ANALYSIS
Annual Conference 2009
13
Micro-Lab
Annual Conference 2009
14
Radiation Lab
Annual Conference 2009
15
DATA TRANSFER TO CLIENTS (WQ, HAZ)
DATA SOURCES APPX / UNIX, MS ACCESS, MYSQL
Annual Conference 2009
16
DATA REPORT TO 300 DW CLIENTS
Annual Conference 2009
17
DATA EXCHANGE GOALS

• ELECTRONIC
• DATA ELEMENTS / FORMAT MEET EPA NEEDS (i.e.
  XML FORMAT)
• OTHER (nice to have)
• DEVELOP WEB APPLICATION TO ACCESS SAMPLE INFO

Annual Conference 2009
18
DATA EXCHANGE NETWORK DOH (LAB) - DEQ
Annual Conference 2009
19
DATA EXCHANGE DESIGN ACTIVITIES

• DATA MIGRATION
• DRINKING WATER CSV FILES TO XML FILES
• NON-DRINKING WATER, HAZADOUS WASTER DATA TO XML
  FILES
• LIMS / ORACLE DEVELOPMENT
• WEB DESIGN

Annual Conference 2009
20
LIMS DEVELOPMENT

• NETWORK HARDWARE UPGRADE, HIGH SPPED T1
  CONNECTION
• CLIENT APPLICATION - LABWARE
• DATA STORAGE - ORACLE DATABASE

21
DATA MIGRATION
LAB CHEMISTRY DATA
IBM RS6000 AIX (Unix), Lab Building
HP Proliant, SuSE Enterprise Linux, State
Health Dept.
Migration from AIX to Linux enables several
enhancements to lab functionality.

• Secure data access using SSH and SFTP.
• Increase the performance.
• Enhanced scripting and web services.
• Enhance Disaster Recovery.

Annual Conference 2009
22
DRINKING WATER DATA TRANSFER
DRINKING WATER CSV FILES UPLOADED TO DOH/DEQ
SHARED FOLDER
IN DEQ
Annual Conference 2009
23
NON-DRINK WATER, HAZADOUS DATA TRANSFER

• DATA FILES CREATED FROM APPX / LINUX AND XML
  FILES GENERATED
• FROM RHAPSODY SERVER.
• XML FILES TRANSFERED TO DEQ EXCHANGE-NODE
  AUTOMATICALLY.

Annual Conference 2009
24
WEB DESIGN

• DATA SOURCE APPX / LINUX
• CGI SCRIPTS MODLE
• DRINKING WATER, NON-DRINK
• WATER QUERY
• THE MODEL WILL CONTINUE TO BE UTILIZED AND
  ENHANCED TO MEET ON GOING REQUIREMENTS.

Annual Conference 2009
25
WEB FUNCTIONS
Annual Conference 2009
26
WEB DATA EXAMPLE
Current Page1 of 9     Total Records Found 264
Annual Conference 2009
27
CHALLENGES

• DOH, DEQ, DTS COORDINATION
• PROJECT PRIORITY
• COLLECTION OF NEW DATA
• STAFF LEAVING
• LIMS BUDGET

Annual Conference 2009
28
Monthly DOH-DEQ Program Meeting
29
DOH-DEQ-DTS Data Exchange Meeting