Development of a spatial database and web-GIS for the climate of Greece

  • Michail Vaitis
  • Haralambos Feidas
  • Panagiotis Symeonidis
  • Vasilis Kopsachilis
  • Dimitris Dalaperas
  • Nikoletta Koukourouvli
  • Dimitris Simos
  • Symeon Taskaris
Methodology Article


Climate information is important for scientific research and decision making. Nowadays web-based cartography technologies provide the means for wide dissemination of such information. This paper describes the design and implementation of a spatial database and a web-GIS application that allow the management, visualization and analysis of data that are directly or indirectly related to climate and its future projections in Greece. Emphasis is given to the design decisions made in order to fulfill the requirements of flexible data querying and reporting, and of maintenance cost minimization. Cartographic layers for climatic and other parameters are dynamically produced through database views and geographic web services. The web-GIS provides user-friendly cartographic operations for visualizing and manipulating thematic maps, as well as reporting services for selecting, displaying and downloading climatic values for selected areas.


Spatial database Web-GIS Climate Greece 



This research has been co-financed by the European Union (European Regional Development Fund) and Greek national funds, through the Operational Program “Competitiveness and Entrepreneurship” of the National Strategic Reference Framework (NSRF) – Research Funding Program COOPERATION 2009 (no 09SYN-31-1094, Title “Development of a Geographic Climate Information System”).


  1. Alder JR, Hostetler SW (2015) Web based visualization of large climate data sets. Environ Model Softw 68:175–180CrossRefGoogle Scholar
  2. Alexandersson H (1986) A homogeneity test applied to precipitation data. J Climatol 6:661–675CrossRefGoogle Scholar
  3. Antolović I, Mihajlović V, Rančić D, Mihić D, Djurdjević V (2013) Digital climate atlas of the Carpathian region. Advanced Science Research 10:107–111CrossRefGoogle Scholar
  4. Bao Y-W, Yu M-X, Wu W (2011) Design and implementation of database for a web-GIS-based rice diseases and pests system. Procedia Environ Sci 10:535–540. CrossRefGoogle Scholar
  5. Camarillo-Naranjo JM, Álvarez-Francoso JI, Limones-Rodríguezb N, Pita-López MF, Aguilar-Alba M (2018) The global climate monitor system: from climate data-handling to knowledge dissemination. Int J Digital Earth.
  6. Carrera-Hernández JJ, Gaskin SJ (2008) The basin of Mexico hydrogeological database (BMHDB): implementation, queries and interaction with open source software. Environ Model Softw 23:1271–1279CrossRefGoogle Scholar
  7. Daly C, Gibson W, Doggett M, Smith J, Taylor G (2004) Up-to-date monthly climate maps for the conterminous United States. In: Proceedings 14th AMS Conference on applied climatology, 84th AMS Annual Meeting Combined Preprints, american meteorological society, Seattle, WA, January 13–16, p P5.1Google Scholar
  8. Daly C, Halbleib MD, Smith JI, Gibson WP, Doggett MK, Taylor GH et al (2008) Physiographically-sensitive mapping of temperature and precipitation across the conterminous United States. Int J Climatol 28:2031–2064CrossRefGoogle Scholar
  9. Daly C, Smith JI, Olson KV (2015) Mapping atmospheric moisture climatologies across the conterminous United States. PLoS One 10(10):e0141140. CrossRefGoogle Scholar
  10. Eguiarte AF, Hidalgo JZ, Centeno RR (2010) Digital Climatic Atlas of Mexico. In: Proceeding 3rd International Conference on Cartography and GIS, 15–20 June, Nessebar, BulgariaGoogle Scholar
  11. Elmasri R, Navathe SB (1994) Fundamentals of database systems, The Benjamin/Cummings Publishing Company, IncGoogle Scholar
  12. ESRI (2004) Understanding ArcSDE: ArcGIS 9. ESRI PressGoogle Scholar
  13. Feidas H, Zanis P, Melas D, Vaitis M, Anadranistakis E, Symeonidis P, Pantelopoulos S (2012a) The geographic climate information system project (GEOCLIMA): overview and preliminary results. Geophysical research abstracts, vol 14, EGU2012–4442Google Scholar
  14. Feidas H, Karagiannidis A, Keppas S, Marougianni G, Vaitis M, Kontos Th, Kioutsioukis I, Melas D, Zanis P, Anadranistakis Ε (2012b) Relating climatic variables to geographic features in Greece. In: Helmis CG, Nastos P (eds) Advances in meteorology, climatology and atmospheric physics, Springer, vol 1, pp 429–436Google Scholar
  15. Feidas H, Karagiannidis A, Keppas S, Vaitis M, Kontos T, Zanis P, Melas D, Anadranistakis E (2014) Modeling and mapping temperature and precipitation climate data in Greece using topographical and geographical parameters. Theor Appl Climatol 118:133–146. CrossRefGoogle Scholar
  16. Girvetz EH, Zganjar C, Raber GT, Maurer EP, Kareiva P, Lawler JJ (2009) Applied climate-change analysis: the climate wizard tool. PLoS One 4(12):e8320. CrossRefGoogle Scholar
  17. Golhani K, Rao AS, Dagar JC (2015) Utilization of Open-Source Web GIS to Strengthen Climate Change Informatics for Agriculture. In: Anil Kumar Singh et al (eds) Climate ChangeModelling, Planning and Policy for Agriculture, Springer, IndiaGoogle Scholar
  18. Gordova Y, Martynova Y, Shulgina T (2014) Usage of web-GIS platform climate to prepare specialists in climate changes modeling and analysis. Geophysical research abstracts, vol 16, EGU2014–3288-1Google Scholar
  19. Hongjie X, Zhou X, Vivoni ER, Hendrickx JMH, Small EE (2005) GIS-based NEXRAD stage III pericpitation database: automated approaches for data processing and visualization. Comput Geosci 31:65–76. CrossRefGoogle Scholar
  20. Lobel L, Brust A, Forte S (2008) Programming Microsoft SQL server 2008. Microsoft PressGoogle Scholar
  21. MacDonald A (2001) Building a geodatabase. ESRI PressGoogle Scholar
  22. Marougianni G, Melas D, Kioutsioukis I, Feidas H, Zanis P, Anadranistakis E (2012) Trend analysis for climatic time series for Greece. In: Helmis CG, Nastos P (eds) Advances in meteorology, climatology and atmospheric physics, Springer, vol 1, pp 583–589Google Scholar
  23. Mystakidis S, Zanis P, Dogras C, Katragkou E, Pytharoulis I, Melas D, Anadranistakis E, Feidas H (2012) Optimization of a regional climate model for high resolution simulations over Greece. In: Helmis CG, Nastos P (eds) Advances in meteorology, climatology and atmospheric physics, Springer, vol 1, pp 623–629Google Scholar
  24. Naiburg EJ, Maksimchuk RA (2001) UML for database design. Addison WesleyGoogle Scholar
  25. Neset TS, Opach T, Lion P, Lilja A, Johansson J (2016) Map-based web tools supporting climate change adaptation. Prof Geogr 68(1):103–114CrossRefGoogle Scholar
  26. Nocke T, Sterzel T, Böttinger M, Wrobel M (2008) Visualization of climate and climate change Data: An Overview, in Ehlers et al. (eds.): Digital Earth Summit on Geoinformatics, Tools for Global Change Research, Wichmann, Heidelberg, 226–232Google Scholar
  27. Parsons MA (2011) Making data useful for modelers to understand complex earth systems. Earth Sci Inf 4(4):197–223CrossRefGoogle Scholar
  28. Perry M, Hollis D (2005) The generation of monthly gridded datasets for a range of climatic variables over the UK. Int J Climatol 25:1041–1054. CrossRefGoogle Scholar
  29. Rigaux P, Scholl M, Voisard A (2002) Spatial databases with applications to GIS. Morgan Kaufmann PublishersGoogle Scholar
  30. Robinson AH, Morrison JL, Muehrcke PC, Kimerling AJ, Guptill SC (1995) Elements of cartography. WileyGoogle Scholar
  31. Singh PS, Chutia D, Sudhakar S (2012) Development of a web based GIS application for spatial natural resources information system using effective open source software and standards. J Geogr Inf Syst 4:261–266Google Scholar
  32. Song X, Kono Y, Shibayama M (2005) Environmental Cambodia: an open source GIS approach to web mapping. Int J Geoinform 1(1):63–70Google Scholar
  33. Souza CM Jr, Pereira K, Lins V, Haiashy S, Souza D (2009) Web-oriented GIS system for monitoring, conservation and law enforcement of the Brazilian Amazon. Earth Sci Inf 2:205–215CrossRefGoogle Scholar
  34. Tveito OE, Wegehenkel M, van der Wel F, Dobesch H. (2008) COST Action 719 — The Use of Geographic Inf Syst in Climatology and Meteorology. Final Report. Office for Official Publications of the European Communities, LuxemburgGoogle Scholar
  35. Wang T, Hamann A, Spittlehouse D, Murdock T (2012) ClimateWNA—High-Resolution Spatial Climate Data for Western North America. J Appl Meteor Climatol 51:16–29. CrossRefGoogle Scholar

Copyright information

© Springer-Verlag GmbH Germany, part of Springer Nature 2018

Authors and Affiliations

  • Michail Vaitis
    • 1
  • Haralambos Feidas
    • 2
  • Panagiotis Symeonidis
    • 3
  • Vasilis Kopsachilis
    • 1
  • Dimitris Dalaperas
    • 4
  • Nikoletta Koukourouvli
    • 1
  • Dimitris Simos
    • 1
  • Symeon Taskaris
    • 3
  1. 1.Department of GeographyUniversity of the Aegean, University HillMytileneGreece
  2. 2.School of Geology, Department of Meteorology and ClimatologyAristotle University of ThessalonikiThessalonikiGreece
  3. 3.Geospatial Enabling Technologies S.A.ThessalonikiGreece
  4. 4.UBITECH LtdAthensGreece

Personalised recommendations