Geographical Information Systems (GIS) are being very commonly used in our daily lives. Location-based services with the help of location-aware devises are also on the rise. The need of GIS solutions are pretty much in demand in the local market. PostgreSQL provides a strong back-end GIS support with the help of an extension called PostGIS, that can be used to develop and deploy useful GIS solutions.

PostGIS has the ability to deal with spatial data (both vector and raster). In this session, we will take a look on working of PostGIS. How does spatial data is stored in PostgreSQL tables? What spatial functions are available in PostGIS which can be used in SQL to get interesting results? And finally how PostGIS can connect to well-know open source GIS & Visualisation desktop software such as QGIS.