a few days later , four more cases occurred among postal workers at the brentwood mail processing facility in the washington area . the appearance of new cases in different locations around the country suggested contamination with b. anthracis of several postal facilities . in each location , the population potentially exposed was large . public health , criminal investigation , and postal authorities at local , state and federal levels investigated the suspected bioterrorism event . within hours of the discovery of clusters of cases , the centers for disease control and prevention(cdc ) deployed teams to four different locations to support state and local investigations . four letters containing anthrax spores were known to have been postmarked and processed in the hamilton mail processing center ( hmpc ) located in hamilton township , a suburb of trenton , new jersey . the hmpc is part of a complicated network of stations and buildings designed to move millions of pieces of mail per day . it is not a typical post office , but a very large facility located in a 281,387 square foot building with many operations areas containing mechanized equipment . it was typically staffed by 250 employees per shift and visited by numerous others in the course of processing 2 million items per day . on october 19 , , , , , field investigation in trenton was initiated by a cdc team composed of an epidemiologist , environmental experts , occupational physicians , epidemic intelligence service ( eis ) officers , a public health informatics fellow , and support personnel . the team was headquartered in the new jersey department of health and senior services ( njdhss ) and had access to the local area network and computing environment of the department . this article describes the experience of the informatics fellow and the new jersey geographic information system(gis ) coordinator during the first two weeks of the investigation in assessing information system needs and organizing on - site computer support for the new jersey arm of the investigation . early in the investigation , the number of people exposed to anthrax was estimated to be large . the response team planned to sample for anthrax contamination in the facility ; identify the exposed population ; locate , culture , and give prophylactic antibiotics to those most likely to be exposed ; and monitor the exposed and treated persons over time for potential long - term effects . information on each person and sample was to be obtained , stored , analyzed , and augmented over time . for epidemiologic investigation and management purposes , summary reports had to be generated frequently . because of the large number of agencies involved and the rapid progress of events , a system of document management for the many drafts of guidelines and other communications was also needed . immediate needs for output included lists of employees , clients , visitors , and other potentially exposed persons . the lists were used by eis officers for individual follow - up and were linked to the map of floor plans of the postal facility and environmental sampling results to help identify persons with the greatest likelihood of exposure . investigators and managers needed summary information , including the percentage of exposed patients receiving medication and the distribution of exposed persons by county . the media relations ' officer of the team produced reports as often as twice a day for the public . information needs of the emergency response team in new jersey not all potential data sources were available during the investigation . the database system in the building was unavailable , as the computers had been turned off due to concern that fans in the computers might create air currents that would jeopardize safety or alter environmental sampling results . the list of employees in the facility computers was therefore unavailable to the investigators and had to be assembled from other sources . digital autocad drawing files of the facility were also stored on a workstation within the facility , and were likewise unavailable  a situation that complicated the production of accurate and representative floor - plan maps . laboratory results included cultures of both human and environmental samples performed by the new jersey state laboratory and cdc laboratories . managing reports from samples processed in different laboratories required linking of multiple unique identifiers . electronic documents that were produced or revised during the investigation included survey results , background documents , guidelines , antibiotic stockpile logistics , and press releases . frequent revisions made it necessary to identify and provide access to the latest documents and to track document revisions . the information system developed consisted of three main components : a database of possibly exposed persons , a gis of the physical plant and equipment , and a document repository . the exposed - person database required merging of files in multiple formats , manual data entry , rapid analysis , and frequent production of reports . gis work was done using floor plans produced in arcview gis 3.2a ( environmental systems research institute , inc . , redlands , ca ) by screen - digitizing scanned not - to - scale xerographic copies of autocad drawings of the postal building . documents were made available to the team by using web pages ( html ) on the new jersey department of health intranet to link to the latest copies of the files . building outlines , walls , work areas , equipment , furniture , the ventilation system and diffusers , and environmental sampling locations were digitized and stored as shapefiles , a format used by both the arcview gis and epi map software . the geographical features were then linked to environmental sampling data to specific locations in the building using epi map . a unique sample identification number was used as the key for linking the shapefile to the environmental sample database ( figure 1 ) . as the map creation process progressed over the 2-week period , additional , larger size paper drawings were provided to which a complete floor plan and heating , ventilation , and air conditioning systems components could be added . another version of the floor plan has been published and is available on the internet . ( environmental.png ) preliminary sampling at the mail facility 1 to support investigations in other facilities where the letters were manipulated , digitized floor plans of the carteret and west trenton post offices were produced from rudimentary sketches . since epi map is public domain software , it was installed on a number of computers without need for licensing making a gis tool freely available to the investigators . the document repository was created using html on an intranet site inside the firewall of the njdhss . the web page included up - to - date information such as press releases and a list of activities for the day . it was updated twice a day or more often when important information had to be communicated to the rest of the investigation team . each link was checked on a daily basis to ensure that the correct document was being accessed . early in the investigation , the number of people exposed to anthrax was estimated to be large . the response team planned to sample for anthrax contamination in the facility ; identify the exposed population ; locate , culture , and give prophylactic antibiotics to those most likely to be exposed ; and monitor the exposed and treated persons over time for potential long - term effects . information on each person and sample was to be obtained , stored , analyzed , and augmented over time . for epidemiologic investigation and management purposes , summary reports had to be generated frequently . because of the large number of agencies involved and the rapid progress of events , a system of document management for the many drafts of guidelines and other communications was also needed . immediate needs for output included lists of employees , clients , visitors , and other potentially exposed persons . the lists were used by eis officers for individual follow - up and were linked to the map of floor plans of the postal facility and environmental sampling results to help identify persons with the greatest likelihood of exposure . investigators and managers needed summary information , including the percentage of exposed patients receiving medication and the distribution of exposed persons by county . the media relations ' officer of the team produced reports as often as twice a day for the public . information needs of the emergency response team in new jersey not all potential data sources were available during the investigation . the database system in the building was unavailable , as the computers had been turned off due to concern that fans in the computers might create air currents that would jeopardize safety or alter environmental sampling results . the list of employees in the facility computers was therefore unavailable to the investigators and had to be assembled from other sources . digital autocad drawing files of the facility were also stored on a workstation within the facility , and were likewise unavailable  a situation that complicated the production of accurate and representative floor - plan maps . laboratory results included cultures of both human and environmental samples performed by the new jersey state laboratory and cdc laboratories . managing reports from samples processed in different laboratories required linking of multiple unique identifiers . electronic documents that were produced or revised during the investigation included survey results , background documents , guidelines , antibiotic stockpile logistics , and press releases . frequent revisions made it necessary to identify and provide access to the latest documents and to track document revisions . the information system developed consisted of three main components : a database of possibly exposed persons , a gis of the physical plant and equipment , and a document repository . the exposed - person database required merging of files in multiple formats , manual data entry , rapid analysis , and frequent production of reports . gis work was done using floor plans produced in arcview gis 3.2a ( environmental systems research institute , inc . , redlands , ca ) by screen - digitizing scanned not - to - scale xerographic copies of autocad drawings of the postal building . documents were made available to the team by using web pages ( html ) on the new jersey department of health intranet to link to the latest copies of the files . building outlines , walls , work areas , equipment , furniture , the ventilation system and diffusers , and environmental sampling locations were digitized and stored as shapefiles , a format used by both the arcview gis and epi map software . the geographical features were then linked to environmental sampling data to specific locations in the building using epi map . a unique sample identification number was used as the key for linking the shapefile to the environmental sample database ( figure 1 ) . as the map creation process progressed over the 2-week period , additional , larger size paper drawings were provided to which a complete floor plan and heating , ventilation , and air conditioning systems components could be added . another version of the floor plan has been published and is available on the internet . ( environmental.png ) preliminary sampling at the mail facility 1 to support investigations in other facilities where the letters were manipulated , digitized floor plans of the carteret and west trenton post offices were produced from rudimentary sketches . since epi map is public domain software , it was installed on a number of computers without need for licensing making a gis tool freely available to the investigators . the document repository was created using html on an intranet site inside the firewall of the njdhss . the web page included up - to - date information such as press releases and a list of activities for the day . it was updated twice a day or more often when important information had to be communicated to the rest of the investigation team . each link was checked on a daily basis to ensure that the correct document was being accessed . recent publications on informatics and bioterrorism have focused on detection of bioterrorist events . some have reviewed the informatics contribution to past emergencies and formulated proposals for various kinds of surveillance and/or response [ 6 - 10 ] . the goal of this paper is to present needs , difficulties , and solutions encountered in the first 2 weeks of a single field investigation . every epidemic investigation is unique , but a comprehensive review of activities carried out during an actual investigation may focus discussion on understanding and improving the informatics response in such events . at the beginning of this investigation , although the njdhss provided a secure computer environment in which to work , many elements of the system had to be designed and set up during the investigation . much of the base information did not exist ( e.g. , gis of the hamilton facility ) or had been made unavailable by the event under investigation ( e.g. , hamilton facility autocad digital drawing files and employee lists ) . as in most field investigations , both data sources and hypotheses shifted and evolved over the course of the investigation . during an investigation , information is critical for decision - making processes and for detection of cases , identification of risk factors , and managing prevention and control measures . in the first hours or days , the emergency response team is required to design and implement an information system capable of providing reliable , timely information . experience in developing such " emergency information systems " and with the software being used plays an important role in determining the time needed to complete the task . in this event , close collaboration between the epidemiologist and informaticians was supported by software designed for field investigation and for exchange of data with other commercial products . the presence of trained professionals from a gis center was an important element in being able to map the site of the investigation . use of industry standard shapefiles and microsoft access databases allowed working copies to be distributed and used in public domain software as needed . a database system was operational within two days of the beginning of operations , and the gis elements evolved over a two - week period as floor plans became available . potential problems identified initially included lags in entry of clinical data , lack of access to data sources because computer systems were disrupted or inaccessible , and the variety of formats and platforms that were designed for other purposes . at least one source produced data in different formats on different days . in field investigation , the informatics environment is defined by the agencies , networks , and individual computers from which data are obtained and with which exchange of data occurs . unless the entire investigation is internal to a single agency or company , each of the partners  state , county , health care facility , law enforcement agency , industry , or other entity  has its own informatics environment . the standards most likely to be common to all the partners are those of the computer industry , such as the internet , microsoft windows , and popular gis standards . those conducting the investigation must be prepared to adapt to the standards used by the data source partners rather than the reverse . in this investigation , existing database systems provided useful information , but the data items were available on paper , in excel files , in text files , in access files , and in arcview shapefiles . the informatician is responsible for merging and integrating elements stored in different database formats to make the information available to the emergency response team . the need for a speedy public health response is a challenge for informaticians because the steps that are typically time consuming , such as requirements generation , analysis , design , implementation , and testing of a new system , must be completed in hours rather than in weeks or months . in this experience , some parts of the system were functional within two days after arrival at the investigation site . epi info 2000   was used to set up databases for manual data entry and updating and for importing and merging data provided by collaborating sources in a variety of microsoft windows formats . the system developed took advantage of several features available in epi info   through its use of commercial component software and computer industry standards :  rapid development of a relational database , in which identifying information was localized to a single table for security purposes  importation of data from several of the 20 different file formats that can be read in epi info 2000  the ability to perform data management interactively but to preserve and replay the steps through automatically generated programs or scripts  the ability to link and display microsoft access data with arcview shapefiles to create maps  rapid development , with minimal coding , simplifying the testing and debugging process  the ability to add or delete variables from a database merely by revising a form on the screen . the availability of analytic output and epidemiologic statistics in the same program used for data management  interaction with high end gis programs and transition of database management to a commercial program through epi info 's incorporation of gis and windows standards  public domain status of the program allowed downloading the latest version from the internet and distributing it to any number of partners without licensing difficulties geographical and spatial analysis has gained importance in public health during the last few years . the availability of maps during the investigation can be attributed to the fact that the njdhss had made resources available from its gis center . the gis professional was able to create the shapefiles while the rest of the emergency response team ( ert ) focused on data collection and data management . once created , maps were widely available for use among all members of the team , and epi map 2000 could be used to link data in microsoft access files to the shapefiles of the building floor plans . the main use of gis in this investigation was to create a relatively detailed base map and to locate environmental sampling and provide spatial analysis and visual support to the investigation . we identified and located all samples taken in the different facilities . in a matter of days we connected the database system with the map files to provide up to date information regarding sample processing and results . the maps created provided a new perspective of the magnitude of contamination inside the facility and also identified non - contaminated areas . we extended the mapping capabilities to illustrate the area of coverage of the active and passive surveillance systems implemented in surrounding communities for the detection of new cases ( figure 2 ) . the surveillance system was originally restricted to nine counties and was latter extended to others . changes in the number of centers included in the surveillance system were reflected in different versions of the same map to document changes over time . ( surveillance.png ) surveillance of new cases in new jersey because of the diversity of the data sources during the investigation , the database system required frequent maintenance . we were able to automate most of the data management routines using epi info program ( scripting ) files and to produce automatic reports . laboratory results were available through the local area network in the new jersey state health department where the team worked . although we might have been able to connect to the laboratory system to obtain real - time updates , for security reasons , the laboratory results for the investigation were exported and became available to the emergency response team at the end of each day . there was therefore a modest , but significant delay in availability of laboratory information . during emergency field situations , any system intended for use by more than one group of people should be easy to use , compatible with other software , and well documented . the database was documented using entity relationship ( er ) diagrams ( figure 3 ) . epi info has a command to display the structure of a table , making it easy to document the system for the replacement team that arrived after two weeks . this second team preferred to work with microsoft access rather than epi info , but the fact that epi info 2000 stores data in generic access 97 tables facilitated the transition . ( databasemodel.eps ) example of the entity relationship diagram for the database system implemented document tracking and version control are important when geographically separated teams are working on the same set of problems . in this case each one of the field sites had a set of experts developing documents and recommendations that applied to the whole event and not only to the geographic area of investigation . it was important to keep the most recent set of recommendations available to all members of the emergency response team for decision - making and information dissemination . during the investigation , we were able to access the most recent documents with minimal effort , using links in a web page . a more sophisticated version could be developed to allow tracking changes in a document over time . emergency situations require rapid design and implementation of databases to provide reliable information in the field . having the ability to respond rapidly to emergency situations requires planning and preparedness . key elements in preparation are in paying sufficient attention to informatics support and having both staff and software that can adapt quickly to new situations and computing environments . the likelihood of success is greater if the same people and software provide support for more routine epidemic investigations in this field investigation , the informatics environment included excel spreadsheets , files in several other formats , paper questionnaires and computer printouts , an existing gis capability using arcview , and the need for frequent revisions in database structure , frequent summary reports , and protection of personal identifiers . software for field use must be flexible enough to interact with and unite numerous data sources and computing environments . investigators must be prepared for new situations , and be ready to adapt new techniques and software as the needs of an investigation unfold . the traditional steps in systems development of requirements gathering , analysis , design , implementation , and testing must be traversed in rapid sequence during the first few hours or days of an investigation and repeated again as the system evolves and capabilities are added . more formalized approach to systems development needs to be either extensively modified or compressed to account for the time - critical nature of the situation . the use of commercial software standards such as windows file formats , web pages , and mainstream gis programs facilitates the rapid implementation of systems in the field . the design of systems for emergencies should include methods for storing and maintaining version control of documents and images in addition to more structured data . a floor plan of the contaminated hamilton facility was available only as an incomplete and poor quality 8 1/2  11 inch photocopy of the original ' e ' sized autocad drawing . it was scanned as a tiff image , imported into arcview gis 3.2 software and used as a backdrop to create shapefiles of the building outline , walls , operational areas and equipment placements , and niosh and fbi sampling locations . shapefiles were developed using a scanned copy of the floor plan of each facility and digitized using arcview . the elements of information to be displayed were divided into several layers showing samples taken by different agencies and their location . after completion , the shapefiles were linked to the data using epi map 2000 , a component of epi info that is arcviewcompatible . elements of information stored in databases created in epi info 2000 were sent directly to epi map for displaying ( figure 1 ) . the process was automated by using scripts or programs . to obtain data on persons possibly exposed , a liaison between the u.s . he was able to obtain ms - excelfiles or computer printouts listing personnel for each of the facilities under investigation . additional information was added to those lists to record presence in the facility during the exposure period , sex of the employee , and post exposure prophylaxis ( pep ) . most of the clinical follow - up services , including pep , were provided by the local hospital . the informatics department of the hospital extracted relevant clinical data from the database system and made them available to the investigation team as excel tables on some days and comma delimited text files on other days . primary data items collected by eis officers and other staff were entered into epi info 2000 or into excel and then imported into epi info 2000 ( microsoft access 97 ) format . potentially exposed populations such as regular visitors and relatives of postal workers were identified and manually entered into the main database as the investigation proceeded . demographic characteristics of potentially exposed persons were assembled from various sources , including the local hospital where pep was administered . when pep was offered to a large group of people , tracking of different treatment protocols and their results became necessary . paper forms were designed not to become obsolete if protocols are modified during the follow up , and similar revisions in the database were expected . database management was done in epi info 2000 , the windows version of epi info . epi info 2000 was developed at cdc from commercial component software and visual basic and offers compatibility with microsoft access files and 20 other standard database formats . it includes a mapping program that uses the arcview compatible shapefile format and allows the display of data from access tables on shapefiles . most of the basic statistics needed for reporting and analysis are built in so that we did not have to spend time coding or debugging algorithms . the data collection and data management tools in epi info do not require expert database managers . the database system consisted of a central database designed and maintained in epi info 2000 . the unique key at first contained information ( was " intelligent " ) , but we designed a mechanism to replace intelligent keys by non - intelligent keys . the intelligent key contained facility code , deployment place ( nj ) exposed unique identifier , and postal facility involved . we included the deployment site in the key assuming that the information would be linked with other sites at a latter time . from the beginning of the operation , security was a concern . because of the complexity of the investigation we decided that all sensitive information  defined as information that would allow identification of specific individuals  would be handled separately from the rest of the database . we created a single flat table with all identifiers and related the table to the rest of the database system . with that structure identifiers were not sent to cdc headquarters in atlanta , for example , and sensitive data were protected by the security features of the njdhss computing environment . a commercial html editor ( microsoft front page 2000 ) was used for the maintenance of the document repository web page . web pages included in the system did not contain any special scripting that required an advanced web programming techniques . the level of html coding was basic , and mostly inserted automatically by front page . the document repository allowed coding and storing versions of documents during the progress of the investigation . the document check - in process included a simple computer - based form with the name of the document , the author , and a time stamp . the first two elements were used to create a catalog , and the timestamp was used for versioning control . a floor plan of the contaminated hamilton facility was available only as an incomplete and poor quality 8 1/2  11 inch photocopy of the original ' e ' sized autocad drawing . it was scanned as a tiff image , imported into arcview gis 3.2 software and used as a backdrop to create shapefiles of the building outline , walls , operational areas and equipment placements , and niosh and fbi sampling locations . shapefiles were developed using a scanned copy of the floor plan of each facility and digitized using arcview . the elements of information to be displayed were divided into several layers showing samples taken by different agencies and their location . after completion , the shapefiles were linked to the data using epi map 2000 , a component of epi info that is arcviewcompatible . elements of information stored in databases created in epi info 2000 were sent directly to epi map for displaying ( figure 1 ) . to obtain data on persons possibly exposed , a liaison between the u.s . postal service and the epidemiologic team he was able to obtain ms - excelfiles or computer printouts listing personnel for each of the facilities under investigation . additional information was added to those lists to record presence in the facility during the exposure period , sex of the employee , and post exposure prophylaxis ( pep ) . most of the clinical follow - up services , including pep , were provided by the local hospital . the informatics department of the hospital extracted relevant clinical data from the database system and made them available to the investigation team as excel tables on some days and comma delimited text files on other days . primary data items collected by eis officers and other staff were entered into epi info 2000 or into excel and then imported into epi info 2000 ( microsoft access 97 ) format . potentially exposed populations such as regular visitors and relatives of postal workers were identified and manually entered into the main database as the investigation proceeded . demographic characteristics of potentially exposed persons were assembled from various sources , including the local hospital where pep was administered . when pep was offered to a large group of people , paper forms were designed not to become obsolete if protocols are modified during the follow up , and similar revisions in the database were expected . database management was done in epi info 2000 , the windows version of epi info . epi info 2000 was developed at cdc from commercial component software and visual basic and offers compatibility with microsoft access files and 20 other standard database formats . it includes a mapping program that uses the arcview compatible shapefile format and allows the display of data from access tables on shapefiles . most of the basic statistics needed for reporting and analysis are built in so that we did not have to spend time coding or debugging algorithms . the data collection and data management tools in epi info do not require expert database managers . the database system consisted of a central database designed and maintained in epi info 2000 . the unique key at first contained information ( was " intelligent " ) , but we designed a mechanism to replace intelligent keys by non - intelligent keys . the intelligent key contained facility code , deployment place ( nj ) exposed unique identifier , and postal facility involved . we included the deployment site in the key assuming that the information would be linked with other sites at a latter time . from the beginning of the operation , security was a concern . because of the complexity of the investigation we decided that all sensitive information  defined as information that would allow identification of specific individuals  would be handled separately from the rest of the database . we created a single flat table with all identifiers and related the table to the rest of the database system . with that structure identifiers were not sent to cdc headquarters in atlanta , for example , and sensitive data were protected by the security features of the njdhss computing environment . a commercial html editor ( microsoft front page 2000 ) was used for the maintenance of the document repository web page . web pages included in the system did not contain any special scripting that required an advanced web programming techniques . the level of html coding was basic , and mostly inserted automatically by front page . the document repository allowed coding and storing versions of documents during the progress of the investigation . members of the team were instructed to check in documents on a regular basis . the document check - in process included a simple computer - based form with the name of the document , the author , and a time stamp . the first two elements were used to create a catalog , and the timestamp was used for versioning control . jz performed the analysis of informatics needs , set up the epi info portions of the field system and the document management system , and drafted the manuscript . rs developed the arcview gis system and shapefiles used in the investigation , and contributed to the manuscript . ad provided advice on the analysis of informatics needs and the development of the epi info applications through daily telephone conversations and wrote portions of the manuscript . esri ( environmental systems research institute ) provided a special license for the free distribution of mapobjects software within epiinfo / epimap 2000 .
backgroundthe investigation of potential exposure to anthrax spores in a trenton , new jersey , mail - processing facility required rapid assessment of informatics needs and adaptation of existing informatics tools to new physical and information - processing environments . because the affected building and its computers were closed down , data to list potentially exposed persons and map building floor plans were unavailable from the primary source.resultscontrolling the effects of anthrax contamination required identification and follow - up of potentially exposed persons . 
 risk of exposure had to be estimated from the geographic relationship between work history and environmental sample sites within the contaminated facility . to assist in establishing geographic relationships , floor plan maps of the postal facility 
 were constructed in arcview geographic information system ( gis ) software and linked to a database of personnel and visitors using epi info and epi map 2000 . 
 a repository for maintaining the latest versions of various documents was set up using web page hyperlinks.conclusionsduring public health emergencies , such as bioterrorist attacks and disease epidemics , computerized information systems for data management , analysis , and communication may be needed within hours of beginning the investigation . 
 available sources of data and output requirements of the system may be changed frequently during the course of the investigation . 
 integrating data from a variety of sources may require entering or importing data from a variety of digital and paper formats . 
 spatial representation of data is particularly valuable for assessing environmental exposure . 
 written documents , guidelines , and memos important to the epidemic were frequently revised . in this investigation , 
 a database was operational on the second day and the gis component during the second week of the investigation .