GIS Open Source Application as a Support to a Hospital Morbidity Database - Hospital GIS

Lia Duarte, Ana Cláudia Moreira Teodoro, Alberto Freitas


Geographical Information Systems (GIS) capabilities are increasing in health area. GIS have been used to investigate global health studies due to the huge capabilities to manipulation, storage, management, analysis, modelling and mapping of geographical data. A simple and intuitive graphic interface to represent spatially an administrative database information would be a great usefulness to the health community. In this work, an open source application was developed in Python language under a GIS open source software (QGIS). The application, incorporated in GIS software, is composed by two tabs: Symbology and Mapping. In order to test the developed application, a zone from Porto Metropolitan Area and a database with administrative data, hospital morbidity database, was considered. This data was previously added to PostGIS (an open source database) and automatically connected to the application. The difficulty of health professionals in the creation of multiple visualizations of tabular data defined by rigorous position, and the maps creation to later analysis and printing, can be overcome with this application. The large amount of data requires the connection to a free database in GIS environment enhancing the practical applicability, rapid, safe and efficient data representation.


  1. A linguagem SQL. Documentação do PostgreSQL 8.0.0. 2015. Accessed October 2015.
  2. Ayres-Sampaio, D., Teodoro, A.C., Sillero, N., Freitas, A., 2014. An investigation of the environmental determinants of asthma hospitalizations: An applied spatial approach. Applied Geography, 47:10-19.
  3. Bui, T.Q., Pahm, H.M., 2016. Web based GIS for spatial pattern detection: application to malaria incidence in Vietnam. SpringerPlus, 5, 1014.
  4. Duarte, L., Teodoro, A.C., Gonçalves, J.A., Guerner Dias, A.J., Espinha Marques, J., 2015. A dynamic map application for the assessment of groundwater vulnerability to pollution. Environmental Earth Sciences, 74(3), 2315-2327.
  5. Ferguson, W.J., Kemp, K., Kost, G., 2016. Using a geographical information system to enhance patient access to point-of-care diagnostics in a limited resource setting. International Journal of Health Geographics, 15:10.
  6. Fisher, R.P., Myers, B.A., 2011. Free and simple GIS as appropriate for health mapping in a low resource setting: a case study in eastern Indonesia. International Journal of Health Geographics, 10:15.
  7. GDAL. Geospatial Data Abstraction Library. 2015. Accessed September 2015.
  8. Gómez-Barroso, D., García-Pérez, J., López-Abente, G., Tamayo-Uria, I., Morales-Pia, A., Romaguera, E.P., Ramis, R., 2016. Agricultural crop exposure and risk of childhood cancer: new findings from a case-control study in Spain. International Journal of Health Geographics, 15:18.
  9. GRASS. The world's leading Free GIS software. 2015. Accessed September 2015.
  10. Inspire. Infrastructure for Spatial Information in the European Community. 2015. .eu/index.cfm/pageid/48. Accessed October 2015.
  11. Jeong, B., Joo, H.-T., Shin, H.-S., Lim, M.-H., Park, J.-C., 2016. Geographic information system analysis on the distribution of patients visiting the periodontology department at a dental college hospital. Journal of Periodontal and Implant Science, 46(3), 207-217.
  12. Kelen, P.T.V., Downs, J.A., Stark, L.M., Loraam, R.W., Anderson, J.H., Unnasch, T.R., 2012. Spatial epidemiology of eastern equine encephalitis in Florida. International Journal of Health Geographics, 11:47.
  13. Luan, H., Law, J., 2014. Web GIS-Based Public Health Surveillance Systems: A Systematic Review. ISPRS International Journal Geo-Information, 3, 481-506; Makanga, P.T., Schuurman, N., von Dadelszen, P., Firoz, T., 2016. A scoping review of geographic information systems in maternal health. International Journal of Gynecology and Obstetrics, 134, 13-17.
  14. Moncrieff, S., West, G., Cosford, J., Mullan, N., Jardine, A., 2014. An open source, server-side framework for analytical web mapping and its application to health. International Journal of Digital Earth, 7(4), 294-315.
  15. Munoz, M.E.S., Giovanni, R., Siqueira, M.F., Sutton, T., Brewer, P., Pereira, R.S., Canhos, D.A.L., Canhos, V.P., 2011. openModeller: a generic approach to species' potential distribution modelling. Geoinformatica, 15, 111-135.
  16. Panciera, R., Khan, A., Rizvi, S.J.R., Ahmed, S., Ahmed, T., Islam, R., Adam, A.M., 2016. The influence of travel time on emergency obstetric care seeking behaviour in the urban poor of Bangladesh: a GIS study. BMC Pregnancy and Childbirth, 16:240.
  17. Plugin: Plugin Builder. Plugin: Plugin Builder, QGIS Python Plugins Repository. 2015. https://plugins.qgis .org/plugins/pluginbuilder/. Accessed October 2015.
  18. Plugin Builder Documentation. QGIS Plugin Builder 2.8.1 documentation. 2015. Accessed October 2015.
  19. PostGIS. Spatial and Geographic objects for PostgreSQL. 2015. Accessed October 2015.
  20. PyQt4 API. PyQt Class Reference. 2015. http://pyqt. Accessed August 2015.
  21. Python. Python Programming Language. 2015. Accessed August 2015.
  22. QGIS API. Quantum GIS API Documentation. 2015. Accessed September 2015.
  23. QGIS. Quantum GIS Project. 2015. Accessed August 2015.
  24. R. The R Project for Statistical Computing. 2015. Accessed September 2015.
  25. Ruktanonchai, C.W., Pindolia, D.K., Striley, C.W., Odedina, F.T., Cottler, L.B., 2014. Utilizing spatial statistics to identify cancer hot spots: a surveillance strategy to inform community-engaged outreach efforts. International Journal of Health Geographics, 13:39.
  26. Sadler, R.C., 2016. Integrating expert knowledge in a GIS to optimize siting decisions for small-scale healthy food retail interventions. International Journal of Health Geographics, 15:19.
  27. SAGA. System for Automated Geoscientific Analyses. 2015. Accessed September 2015.
  28. SEXTANTE. The SEXTANTE framework. 2015. Accessed September 2015.
  29. Smith, C.M., Hayward, A.C., 2016. DotMapper: an open source tool for creating interactive disease point maps. BMC Infectious Diseases, 16:145.
  30. Snow, J., 1855. On the mode of communication of cholera. 2nd edition. London: Jonh Churchill.
  31. Spatial Reference. sr-org projection 7483 - epsg:3857 -- wgs84 web mercator (auxiliary sphere). 2015. Accessed October 2015.
  32. Spherical Mercator. EPSG:3857. 2015. http://wiki. Accessed October 2015.
  33. SQL. SQL Wikipedia. 2015. /SQL. Accessed October 2015.
  34. Stallman P. Why 'Open Source' misses the point of free software, GNU Operating System. 2007. Accessed February 2011. Accessed September 2015.
  35. Teodoro, A.C., Duarte, L., 2013. Forest Fire risk maps: a GIS open source application - a case study in Norwest of Portugal. International Journal of Geographic Information Science, 27(4), 699-720.
  36. Web Mercator. Web Mercator Wikipedia. 2015. Accessed October 2015.
  37. Zhang, Z., Manjourides, J., Cohen, T., Hu, Y., Jiang, Q. 2016. Spatial measurement errors in the field of spatial epidemiology. International Journal of Health Geographics, 15:21.

Paper Citation

in Harvard Style

Duarte L., Teodoro A. and Freitas A. (2017). GIS Open Source Application as a Support to a Hospital Morbidity Database - Hospital GIS . In Proceedings of the 3rd International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM, ISBN 978-989-758-252-3, pages 169-176. DOI: 10.5220/0006268901690176

in Bibtex Style

author={Lia Duarte and Ana Cláudia Moreira Teodoro and Alberto Freitas},
title={GIS Open Source Application as a Support to a Hospital Morbidity Database - Hospital GIS},
booktitle={Proceedings of the 3rd International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM,},

in EndNote Style

JO - Proceedings of the 3rd International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM,
TI - GIS Open Source Application as a Support to a Hospital Morbidity Database - Hospital GIS
SN - 978-989-758-252-3
AU - Duarte L.
AU - Teodoro A.
AU - Freitas A.
PY - 2017
SP - 169
EP - 176
DO - 10.5220/0006268901690176