it is estimated that today 4.74 million people are hiv+ in south africa and the south african medical research council ( mrc ) projected that without appropriate treatment to prevent the development of aids , the number of aids deaths within the next decade would be more than double the number of deaths due to all other causes , resulting in 6 to 7 million cumulative aids deaths in south africa in 2010 . the pandemic entails both a medical and a logistical challenge . leaving the medical challenge to the medical profession to overcome , engineers can contribute to the logistical challenge , which is based on managing health care using technology . the main challenges for the efficient and effective management of hiv / aids in south africa are the inadequate physical infrastructure and the lack of reliable statistics on the disease . the data available are either estimates or projections and therefore range between educated guesses and wild speculation . the south african government believes that the provision and supply of antiretroviral drugs to hiv / aids patients might be ineffective given the scale of the pandemic and its intersection with poverty and other epidemics such as tuberculosis and malaria . the lack of health centres , infrastructure and amenities ( e.g. electricity and water ) as well as low levels of treatment literacy are additional concerns for the required medication adherence rate of 95% ( orrell 2002  personal communication ) . due to the limited resources of the country and in attempting to address the ' hot spots ' first , there is a need to establish areas with the highest hiv / aids prevalence . some of the data that is required to address the pandemic relates to :  location of high hiv / aids prevalence  level of infrastructure available to communities  infection rates of hiv / aids  status quo of medical care within communities . municipalities will have data relating to the levels of infrastructure and the status quo of medical care . doctors in the hospitals know how many patients with hiv / aids enter the clinic on a daily base and when and how these patients were infected . the design of a system that combines this information needs to address the following two issues : firstly combining data that is being managed by various authorities in a number of systems and secondly combining data that is spatial and non - spatial in nature . the system should function as an information system containing accurate hiv / aids and infrastructure data and support decision - making and management . the easy integration of the system into existing gis environments that are established within the governmental structures such as the electricity department , the surveyor general 's office , the deeds office and others is essential . the information obtained will then be turned into knowledge for use in efficient planning , evaluation and policy - making . the belief is that any system based on geographic or spatial information system technology will provide a tremendous opportunity in hiv / aids patients ' health informatics in south africa . whilst spatial information system ( sis ) can not solve the hiv / aids pandemic , it should be seen as an information - gathering tool that can be employed in the mobilization and response to the disease . the project aimed to establish parameters and benchmarks relating to the use of sis to administer and manage patient data . gugulethu is situated about 20 km from cape town and is arguably one of the oldest and fastest developing black townships in south africa . gugulethu is home to approximately 325,000 people ( bekker 2003  personal communication ) , generally poor as indicated by the averaged monthly income of r1126 . the current hiv prevalence rate in the gugulethu community is 27% ( bekker 2003  personal communication ) . this translates into 88,000 hiv / aids people and predominantly claims the lives of adults aged 19 to 40 leaving behind children and aging parents . the scale of the pandemic in the township is continuing to expand and as a result , the number of patients visiting the clinic is increasing ( matoti 2003  personal communication ) . one of the main challenges in most of the township - based clinics is the paper - based management system of hiv / aids patients . each patient visiting the clinic has a folder comprising of personal information including name , address , next of kin . clinical information for example height , weight , blood group , type of disease are also recorded . at each visit , respective folders for the patients are retrieved and entries are made in the patients ' file by either the administrative clerk or the nurse . since the registration , consultation and dispensing processes are carried out manually , human errors such as misplacing or losing the folders are bound to occur . in addition , it is common that patients , who feel they are not benefiting from the health care and service that is being provided , will opt to go to another health centre . several cases of patients transferring to other health centres or even patients from elsewhere coming for treatment at the gugulethu community clinic have been registered . the main drawback in such cases is that the patients ' health history is unknown and this is particularly dangerous in the case of antiretroviral treatment , since the history of the patients plays a major role in deciding on the treatment . another concern expressed by the staff is that as gugulethu is a township , it is regarded as being a neglected and underprivileged area . health officials and managers rarely access the township and are therefore unaware of the situation on the ground . matoti ( 2003  personal communication ) reasoned that for the gugulethu community clinic to undergo any upgrading to the infrastructure , it must first and foremost be visible on the south africa health centres map . he further stated that health officials and managers must be made aware that over 27% of the inhabitants in gugulethu are hiv+ , that the people are struggling with the pandemic in the context of extreme poverty and that the poor existing infrastructure at the clinic hinder the delivery of efficient health care and service . gugulethu is situated about 20 km from cape town and is arguably one of the oldest and fastest developing black townships in south africa . gugulethu is home to approximately 325,000 people ( bekker 2003  personal communication ) , generally poor as indicated by the averaged monthly income of r1126 . the current hiv prevalence rate in the gugulethu community is 27% ( bekker 2003  personal communication ) . this translates into 88,000 hiv / aids people and predominantly claims the lives of adults aged 19 to 40 leaving behind children and aging parents . the scale of the pandemic in the township is continuing to expand and as a result , the number of patients visiting the clinic is increasing ( matoti 2003  personal communication ) . one of the main challenges in most of the township - based clinics is the paper - based management system of hiv / aids patients . each patient visiting the clinic has a folder comprising of personal information including name , address , next of kin . clinical information for example height , weight , blood group , type of disease are also recorded . at each visit , respective folders for the patients are retrieved and entries are made in the patients ' file by either the administrative clerk or the nurse . since the registration , consultation and dispensing processes are carried out manually , human errors such as misplacing or losing the folders are bound to occur . in addition , it is common that patients , who feel they are not benefiting from the health care and service that is being provided , will opt to go to another health centre . several cases of patients transferring to other health centres or even patients from elsewhere coming for treatment at the gugulethu community clinic have been registered . the main drawback in such cases is that the patients ' health history is unknown and this is particularly dangerous in the case of antiretroviral treatment , since the history of the patients plays a major role in deciding on the treatment . another concern expressed by the staff is that as gugulethu is a township , it is regarded as being a neglected and underprivileged area . health officials and managers rarely access the township and are therefore unaware of the situation on the ground . matoti ( 2003  personal communication ) reasoned that for the gugulethu community clinic to undergo any upgrading to the infrastructure , it must first and foremost be visible on the south africa health centres map . he further stated that health officials and managers must be made aware that over 27% of the inhabitants in gugulethu are hiv+ , that the people are struggling with the pandemic in the context of extreme poverty and that the poor existing infrastructure at the clinic hinder the delivery of efficient health care and service . the hiv / aids database was established to facilitate the management of hiv / aids patient data at the gugulethu community clinic . the various menus in the hiv / aids database record information concerning the patient 's health , the medication , the adherence patterns as well as possible need for appointments , what allergies and symptoms they are experiencing and how severe these are . microsoft access was chosen to design the database , since it allowed drawing conclusions with regard to the success and functionality of the design in the small - scale pilot project . however , for a nationwide integrated database , other database platform might be more appropriate . the information within the database can be viewed , sorted , manipulated , retrieved and printed in various ways and gives users the flexibility to obtain data in multiple formats . figure 1 is an output of the design of the hiv / aids database showing the relationships between the different entities and their attributes . , not all users see the world through the same eyes and for the system to be effective , it must have the confidence of all users . since most of the users will not be concerned with how the database works , the system should be designed such that it meets the interests , skills and needs of the individual user . in view of increasing the potential benefits of the system , well - designed and user - friendly interfaces are developed to reduce the need to memorise commands and to provide visual feedback . the design of the data input screens as shown in figure 3 standardises data collection and ensures accurate data entry . user display of the hiv / aids database data input screen of the hiv / aids database other functions within the hiv / aids database allow users to find and update the records . the results of queries and reports help the users to focus , examine and abstract the resources without the need to understand the intricacies of the individual tables . the aim is to make it easy for the users to find out the types of data , which exist and provide the tools for appropriate information editing and retrieval that will help them with the maintenance of the patient - medication related documentation . the spatial information management system ( sims ) is conceptualised as a series of layers of information including :  the health districts  the location of health centres : clinics , government hospitals and private hospitals  the location of roads and streets  the location of main transport routes : taxi and bus  the basic amenities : water , telephone , sanitation and fuel for lighting . the data in shapefile format was obtained from the cape metropolitan council ( cmc ) of cape town and the software chosen for the design of the sims was arcgis 8.2 . figure 4 shows the conceptual design of the sims whereby the spatial data and the non - spatial data ( hiv / aids database ) are integrated in the sims geodatabase in arcgis . the software allows for inputting , updating and analysing the data while maintaining the spatial integrity of each data collection . the technology also supports the spatial display of data , map layouts and handles queries and reports . the geocoding functionality within arcgis is used to support and facilitate the integration of data records by location . the geocoding wizard within arcmap supported the geographical location of the hiv patients and the therapeutic counsellors . the overlay of the quantitative graphics provides the ability to realize the spatial distribution of the hiv patients in the gugulethu region in a clear manner . the display depicts ground reality : the red triangles represent the location of the hiv patients while the purple pentagons locate the therapeutic counsellors . the strong point of the system is the ability to identify and access information about any particular patient on the map as shown in figure 5 . the hiv / aids database was established to facilitate the management of hiv / aids patient data at the gugulethu community clinic . the various menus in the hiv / aids database record information concerning the patient 's health , the medication , the adherence patterns as well as possible need for appointments , what allergies and symptoms they are experiencing and how severe these are . microsoft access was chosen to design the database , since it allowed drawing conclusions with regard to the success and functionality of the design in the small - scale pilot project . however , for a nationwide integrated database , other database platform might be more appropriate . the information within the database can be viewed , sorted , manipulated , retrieved and printed in various ways and gives users the flexibility to obtain data in multiple formats . figure 1 is an output of the design of the hiv / aids database showing the relationships between the different entities and their attributes . , not all users see the world through the same eyes and for the system to be effective , it must have the confidence of all users . since most of the users will not be concerned with how the database works , the system should be designed such that it meets the interests , skills and needs of the individual user . in view of increasing the potential benefits of the system , well - designed and user - friendly interfaces are developed to reduce the need to memorise commands and to provide visual feedback . the design of the data input screens as shown in figure 3 standardises data collection and ensures accurate data entry . user display of the hiv / aids database data input screen of the hiv / aids database other functions within the hiv / aids database allow users to find and update the records . the results of queries and reports help the users to focus , examine and abstract the resources without the need to understand the intricacies of the individual tables . the aim is to make it easy for the users to find out the types of data , which exist and provide the tools for appropriate information editing and retrieval that will help them with the maintenance of the patient - medication related documentation . the spatial information management system ( sims ) is conceptualised as a series of layers of information including :  the health districts  the location of health centres : clinics , government hospitals and private hospitals  the location of roads and streets  the location of main transport routes : taxi and bus  the basic amenities : water , telephone , sanitation and fuel for lighting . the data in shapefile format was obtained from the cape metropolitan council ( cmc ) of cape town and the software chosen for the design of the sims was arcgis 8.2 . figure 4 shows the conceptual design of the sims whereby the spatial data and the non - spatial data ( hiv / aids database ) are integrated in the sims geodatabase in arcgis . the software allows for inputting , updating and analysing the data while maintaining the spatial integrity of each data collection . the technology also supports the spatial display of data , map layouts and handles queries and reports . the geocoding functionality within arcgis is used to support and facilitate the integration of data records by location . the geocoding wizard within arcmap supported the geographical location of the hiv patients and the therapeutic counsellors . the overlay of the quantitative graphics provides the ability to realize the spatial distribution of the hiv patients in the gugulethu region in a clear manner . the display depicts ground reality : the red triangles represent the location of the hiv patients while the purple pentagons locate the therapeutic counsellors . the strong point of the system is the ability to identify and access information about any particular patient on the map as shown in figure 5 . the sims delivers the complete requirements for a data - driven information system , which features the following functionalities :  the visualisation of the hiv / aids distribution . the spatial distribution provides a clear representation of hiv / aids people .  the identification of areas , which are more prone to the pandemic . the ' hot spots ' are earmarked and health professionals can initiate strategies as to how to curb the further spread of the disease . the display of the existing infrastructure provides an insight into the lifestyles of the hiv infected patients in terms of availability of basic amenities and means of transport . comparisons and relationships relating to the spatial distribution of hiv / aids patients can be drawn between areas with infrastructure and other areas with non - adequate infrastructure . in addition , decisions can be made concerning the allocation of resources in underprivileged regions . the spatial distribution of the population in relation to health centre positions assesses the accessibility to appropriate health services . health officials can utilise this information to site additional health centres with the aim of minimising the distances that patients need to travel to obtain care and services . the distance that the therapeutic counsellors need to travel for their regular house visits can also be calculated . this information is useful in coordinating the roles and responsibilities of the therapeutic counsellors so that they counsel patients living in the same vicinity rather than miles away . it is a powerful management and decision - making support system that enables decision - makers to identify and prioritise population health needs , configure health care delivery systems , and evaluate service utilization and health outcomes . last but not least , sims can be regarded as a virtual information bank that allow focused , long - term and cost effective hiv / aids management thus contributing to health development . the evaluation involved a presentation to the prospective users of the sims namely : the physicians , the health managers and the data manager . the main concerns of the users were :  the transition from paper - based management system to a computerised management system would be difficult . the users believed that if the system were to be implemented throughout south africa , the most difficult phase would be the transition from the paper - based system to the computerised one . by designing a system that is intuitively and easy to use and adds real value to the work of the health professionals , it can be expected that the response will be positive . since the system can be maintained by nurses or administrators , medical doctors might want to use it , but will not be forced to maintain it . the users felt that access to the system has to be restricted in order for privacy of patients to be protected . the system must ensure that information is used appropriately and confidentially otherwise people will avoid using it . the confidential information should be shared only among authorized people and some balance must be struck between an individual 's right to keep information confidential and the benefits that can be accrued if the information is made public . in addition , the records must have adequate security in terms of encryption measures such that personal information about patients is not divulged broadly . the evaluation involved a presentation to the prospective users of the sims namely : the physicians , the health managers and the data manager . the main concerns of the users were :  the transition from paper - based management system to a computerised management system would be difficult . the users believed that if the system were to be implemented throughout south africa , the most difficult phase would be the transition from the paper - based system to the computerised one . by designing a system that is intuitively and easy to use and adds real value to the work of the health professionals , it can be expected that the response will be positive . since the system can be maintained by nurses or administrators , medical doctors might want to use it , but will not be forced to maintain it . the users felt that access to the system has to be restricted in order for privacy of patients to be protected . the system must ensure that information is used appropriately and confidentially otherwise people will avoid using it . the confidential information should be shared only among authorized people and some balance must be struck between an individual 's right to keep information confidential and the benefits that can be accrued if the information is made public . in addition , the records must have adequate security in terms of encryption measures such that personal information about patients is not divulged broadly . this study focused on the design and development of an hiv / aids database and sims , which could be used as an information gathering and management tool in south africa for the management of hiv / aids . as the necessary physical infrastructure is not yet in place for effective management of hiv / aids in south africa , the research was motivated by the need to provide a " virtual " infrastructure of support . in essence , the sims was designed to administer and retrieve the patient - medication related data , locate the hiv / aids patients and the existing infrastructure , contribute to decision - making and policy development in view of providing a spur to improve health care service and delivery . based on the findings of this study , it can be noted that implementing the sims to manage hiv / aids across south africa is a long - term undertaking . sims can not solve the hiv / aids pandemic but is seen as an information - gathering tool that can be employed in the mobilization and response to the disease . the sims can perform several functions , fulfill many roles and may provide tremendous opportunities in hiv / aids patients ' health care service and delivery . the technology is regarded as a vehicle for facilitating public health planning and contributing to community - based decision - making and policy development . this study has addressed a sims for the management of hiv / aids in south africa but there are certain areas that could be investigated and developed further . firstly , complete medical records of patients are very valuable information and can open new dimensions of research . instead of the hiv / aids database standing alone , other databases such as tuberculosis , malaria etc can be integrated into the sims . in this regard , the hiv / aids , tuberculosis and malaria patients can all be mapped spatially , enabling physicians and health officials to visualise the three different patterns and to draw comparisons among the three most important diseases in south africa . the overlay of the hiv / aids , tuberculosis and malaria distribution can also identify critical " hot spots " where additional support is needed . the different databases residing in the sims can provide a powerful management and decision - making support system that enables decision - makers to identify population health needs and prioritise these needs , configure health care delivery systems , and evaluate service utilization and health outcomes . in addition , collaborative projects and data access , distribution and sharing among the country 's health centres can ensure a continuous and current understanding of disease profiles in south africa . aids acquired immune deficiency syndrome gis geographic information systems hiv human immuno - deficiency virus sims spatial information management system sis spatial information systems this paper was completed by kb as part of the requirements for her master of science ( msc ) of engineering in geomatics . the authors would like to thank the cape metropolitan council for providing the spatial data and the uct lung institute for contributing to the hiv / aids data . sincere thanks goes to dr catherine orrell , dr kwezi matoti and dr linda - gail bekker for their input . the financial support from the national research foundation and the vodacom foundation of south africa is also gratefully acknowledged .
backgroundsouth africa is experiencing an hiv / aids pandemic of shattering dimensions . 
 the availability and provision of antiretroviral ( arv ) drugs could bring relief to the situation , but the treatment is unfortunately complex with each patient being assigned a different antiretroviral therapy varying in diet - medication regiment . 
 the context of south africa , its variety of urban and rural settings adds to the challenge of administering and monitoring the hiv+ person throughout the treatment , which will last for the rest of their lives . 
 the lack of physical infrastructure , reliable statistics and adequate resources hinder the efficient management of hiv / aids.resultsthe collection of reliable data will be a first step to assess the status of hiv / aids in communities . 
 a number of hospitals have started this process using the conventional approach to collect information about their patients using a paper - based system . 
 since time is of essence in the fight against the pandemic , data exchange between various hospitals , municipalities and decision - making bodies is becoming more and more important . 
 the logical response to such a need is a computerised system , which will collect and administer hiv / aids related information within the local context and allow a monitored access to the data from a number of stakeholders.conclusionsthe purpose of this study was to design and develop an hiv / aids database , which is embedded in a spatial information management system . 
 the pilot study area is the gugulethu township in cape town where more than 27% of the 325 000 residents are hiv+ . 
 it is shown that the implementation of the hiv / aids database and the spatial information management system can play a critical role in determining where and when to intervene , improving the quality of care for hiv+ patients , increasing accessibility of service and delivering a cost - effective mode of information .