Advanced QGIS Course (3 days)
Course Outline
This three-day course provides a conceptual overview and hands-on experience using QGIS software, PostGIS and GeoServer. It teaches basic QGIS functionality and enables attendees to quickly take advantage of the software’s powerful display and analysis capabilities. Attendees are introduced to the QGIS GUI and use QGIS to create, edit, display, query, and analyze geographic and tabular data and create presentation-quality maps and charts.
On Day 3 of the training, attendees will be introduced to PostGIS and GeoServer. Integrating QGIS with PostGIS and GeoServer is a powerful combination that allows attendees to manage, analyze and publish spatial data efficiently.
Overall, this integration streamlines data management, analysis and web publishing processes, providing a powerful and efficient solution for handling geospatial information.
By the end of the training program, attendees will have the skills to create web-based maps for online display.
Prerequisites
Advanced GIS training using QGIS, integrated with PostGIS and GeoServer is for those with IT and GIS background.
Class Attendees Learn How to:
QGIS
- 1. Display data in a view.
- 2. Create and edit data.
- 3. Query a database.
- 4. Perform geocoding.
- 5. Create maps for presentation.
PostGIS
- 1. Introduction to PostGIS and understanding spatial database.
- 2. Installing and configuring PostGIS.
- 3. Working with PostGIS – create and manage spatial databases.
- 4. Learn how to load spatial data.
- 5. An introduction in using basic SQL in PostGIS.
- 6. Real life examples using those techniques.
GeoServer
- 1. Understanding web mapping and using GeoServer to serve geospatial data.
- 2. Learn about GeoServer Layers and how to add information to your map.
- 3. Learn about WebGIS Concepts (Protocols – WMS, WFS, WCS and TMS).
- 4. Create Map for online display (Web-based GIS).
Topics covered QGIS (2 days)
- 1. Capabilities and applications.
- 2. Interacting with the QGIS GUI.
- 3. Projects and documents.
- 4. Using QGIS online help.
- 1. Creating views to display geo-graphic data (layers).
- 2. Creating layers from x, y coordinates.
- 3. Setting a view’s map projection.
- 4. Manipulating the symbology and classification scheme for each layer.
- 5. Labeling layers.
QGIS Tables:
- 1. Creating an QGIS table from a variety of tabular data sources.
- 2. Selecting from a table.
- 3. Joining and linking multiple tables.
- 4. Modifying the structure of a table.
- 5. Editing values in a table.
- 6. Creating a chart for presenting tabular data.
Creating and Editing Layers:
- 1. Using QGIS to create ShapeFiles.
- 2. Adding and editing ShapeFile features.
- 3. Updating attribute information.
Spatial Query and Analysis:
- 1. Selecting features based on relationships between multiple layers.
- 2. Merging layer features.
QGIS Layouts:
- 1. Creating a final map for presentation and printing.
- 2. Combining views, tables, charts, images, north arrows, logos, and scale bars to create a final map.
Georeferencing with QGIS:
1. Referencing images has always been one of the critical tasks on a GIS platform. QGIS can make it easy job for you through its tools.
Adjusting Vectors with QGIS:
1. Adjusting vectors can be done through different ways, this includes shifting rotating and scaling the data. Of course such operation would be carried out using the affine transformation tools.
Topology with QGIS:
1. Cleaning the data is now easy with QGIS opensource software, we will look into how to find several errors on a map, then fix the errors with ease.
Topics covered PostGIS (1/2 day)
Section 1: Introduction to PostGIS
PostGIS provides a wide range of functions and operators for spatial data analysis, including spatial queries, spatial joins, and spatial aggregation. It also supports advanced spatial analysis techniques, such as clustering, interpolation, and geostatistics.
Section 2: Installation, different ways to Install PostGIS
PostGIS has many packaged installations and could be done in different ways. However, the exact steps may vary depending on your operating system and version of PostgreSQL. Learn from expert.
Section 3: Creating a Spatial Database
Learn to create a basic spatial database with the correct steps and commands.
Section 4: Loading spatial data with QGIS using DBManager
QGIS supports a wide range of data formats, so you can load data from various sources and use it for your spatial analysis and visualization tasks.
Section 5: Simple SQL techniques (demo)
PostGIS provides a rich set of spatial functions and operators that allow you to perform advanced spatial queries and analysis in SQL. Learn simple SQL techniques in PostGIS that you can use to work with spatial data.
Section 6: Editing PostGIS data using QGIS
Geometry querying allows you to perform complex spatial analysis and data mining tasks using SQL. Users can combine geometry functions with other SQL operators and clauses to create powerful queries that filter, aggregate, and transform spatial data.
Section 7 : Projecting Data
When working with spatial data in PostGIS, it is important to be aware of the projection data and to ensure that all data sources are using the same projection. Failure to use the same projection can result in incorrect spatial analysis and visualization, as well as data loss and inaccuracies.
Topics covered GeoServer (1/2 day)
Section 1: Installing GeoServer
There are many ways to install GeoServer on your system. This section will discuss the various installation paths available.
Section 2: GeoServer Interface/Administration
The Web administration interface is a web-based tool for configuring all aspects of GeoServer, from adding data to changing service settings. In a default GeoServer installation, this interface is accessed via a web browser. Configuring user authentication and authorization, securing services, and restricting access to data.
Section 3: Web GIS Concepts (Protocols)
Web GIS refers to the use of internet technologies and protocols to create, share, and consume geographic information through web-based interfaces. There are several protocols that are commonly used in web GIS applications such as WMS,WFS,WCS and TMS. We will dig more each protocol in this topic.
Section 4: Adding Layers
GeoServer layers refer to the geographic data that is served by the GeoServer software. A layer in GeoServer represents a specific set of geographic features or data that can be displayed on a map. These layers can be created from a variety of data sources, including shapefiles, PostGIS databases, and remote web services.
Section 5: Styling Layers on GeoServer with QGIS
Each layer in GeoServer can be configured with a set of styling rules that determine how the data is displayed on the map. This includes settings for the color, opacity, and labeling of the features within the layer.
Section 6: Final Project: From Zero to Hero - From Desktop GIS to Web GIS
Create a simple project with GeoServer.