{"id":1116,"date":"2023-10-11T05:55:05","date_gmt":"2023-10-11T05:55:05","guid":{"rendered":"https:\/\/gis.com.my\/training\/?page_id=1116"},"modified":"2024-09-06T02:49:47","modified_gmt":"2024-09-06T02:49:47","slug":"advanced-qgis-course-3-days","status":"publish","type":"page","link":"https:\/\/gis.com.my\/training\/advanced-qgis-course-3-days\/","title":{"rendered":"Advanced QGIS Course (3 days)"},"content":{"rendered":"\n\n\n\n\n\n\n\n\n<p [object NamedNodeMap]><span style=\"font-size:48px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><span style=\"color:#000000\"><strong>Advanced QGIS Course (3 days)<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Course Outline<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">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\u2019s 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. <\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><br>\n<span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">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.<br>\n<br>\nOverall, this integration streamlines data management, analysis and web publishing processes, providing a powerful and efficient solution for handling geospatial information. <\/span><\/span><\/span><br>\n&nbsp;<\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">By the end of the training program, attendees will have the skills to create web-based maps for online display.<\/span><\/span><\/span><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\">&nbsp;<span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Prerequisites<br><\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">Advanced GIS training using QGIS, integrated with PostGIS and GeoServer is for\nthose with IT and GIS background.<\/span><\/span><\/span><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><\/span><\/span><\/span><\/p>\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Class Attendees Learn How to:<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p><u><strong><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><\/span><\/span><\/span><\/strong><\/u><\/p>\n<p>&nbsp;<span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>QGIS<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<ul style=\"list-style-type:disc\">\n\t<\/ul><ul><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 1. Display data in a view.<\/span><\/span><\/span><\/li><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 2. Create and edit data.<\/span><\/span><\/span><\/li><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 3. Query a database.<\/span><\/span><\/span><\/li><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 4. Perform geocoding.<\/span><\/span><\/span><\/li><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 5. Create maps for presentation.<\/span><\/span><\/span><\/li><\/ul>\n\n\n\n<div><br><\/div>\n\n\n\n<p><u><strong><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><\/span><\/span><\/span><\/strong><\/u><\/p>\n<p>&nbsp;<span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>PostGIS<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<ul style=\"list-style-type:disc\">\n\t<\/ul><ul><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 1. Introduction to PostGIS and understanding spatial database.<\/span><\/span><\/span><\/li><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 2. Installing and configuring PostGIS.<\/span><\/span><\/span><\/li><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 3. Working with PostGIS \u2013 create and manage spatial databases.<\/span><\/span><\/span><\/li><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 4. Learn how to load spatial data.<\/span><\/span><\/span><\/li><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 5. An introduction in using basic SQL in PostGIS.<\/span><\/span><\/span><\/li><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 6. Real life examples using those techniques.<\/span><\/span><\/span><\/li><\/ul>\n\n\n\n<div><br><\/div>\n\n\n\n<p><u><strong><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><\/span><\/span><\/span><\/strong><\/u><\/p>\n<p>&nbsp;<span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>GeoServer<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<ul style=\"list-style-type:disc\">\n\t<\/ul><ul><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 1. Understanding web mapping and using GeoServer to serve geospatial data.<\/span><\/span><\/span><\/li><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 2. Learn about GeoServer Layers and how to add information to your map.<\/span><\/span><\/span><\/li><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 3. Learn about WebGIS Concepts (Protocols \u2013 WMS, WFS, WCS and TMS).<\/span><\/span><\/span><\/li><li><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 4. Create Map for online display (Web-based GIS).<\/span><\/span><\/span><\/li><\/ul>\n\n\n\n<div><br><\/div>\n\n\n\n<p><br><\/p>\n\n\n\n<p><strong><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">Topics covered\u00a0QGIS (2 days)<\/span><\/span><\/span><\/strong><\/p>\n\n\n\n<div><br><\/div>\n\n\n\n<span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Overview:<\/strong><\/span><\/span><\/span>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<ul>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 1. Capabilities and applications.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 2. Interacting with the QGIS GUI<\/span><\/span><\/span>.<\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 3. Projects and documents.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 4. Using QGIS online help.<\/span><\/span><\/span><\/li><\/ul>\n\n\n\n<div><br><\/div>\n\n\n\n<div><br><\/div>\n\n\n\n<span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>QGIS Views and Layers:<\/strong><\/span><\/span><\/span>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<ul>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 1. Creating views to display geo-graphic data (layers).<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 2. Creating layers from x, y coordinates.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 3. Setting a view\u2019s map projection.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 4. Manipulating the symbology and classification scheme for each layer.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 5. Labeling layers.<\/span><\/span><\/span><\/li><\/ul>\n\n\n\n<div><br><\/div>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>QGIS Tables:<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<ul>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 1. Creating an QGIS table from a variety of tabular data sources.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 2. Selecting from a table.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 3. Joining and linking multiple tables.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 4. Modifying the structure of a table.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 5. Editing values in a table.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 6. Creating a chart for presenting tabular data.<\/span><\/span><\/span><\/li><\/ul>\n\n\n\n<div><br><\/div>\n\n\n\n<p [object NamedNodeMap]><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Creating and Editing Layers:<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<ul>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 1. Using QGIS to create ShapeFiles.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 2. Adding and editing ShapeFile features.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 3. Updating attribute information.<\/span><\/span><\/span><\/li><\/ul>\n\n\n\n<div><br><\/div>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Spatial Query and Analysis:<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<ul>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 1. Selecting features based on relationships between multiple layers.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 2. Merging layer features.<\/span><\/span><\/span><\/li><\/ul>\n\n\n\n<div><br><\/div>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>QGIS Layouts:<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<ul>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 1. Creating a final map for presentation and printing.<\/span><\/span><\/span><\/li>\n\t<li style=\"text-align: justify;\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 2. Combining views, tables, charts, images, north arrows, logos, and scale bars to create a final map.<\/span><\/span><\/span><\/li><\/ul>\n\n\n\n<div><br><\/div>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Georeferencing with QGIS:<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp;&nbsp; 1. Referencing images has always been one of the critical tasks&nbsp; on a GIS platform. QGIS can make it easy job for you through its tools.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Adjusting Vectors with QGIS:<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp; 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.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Topology with QGIS:<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">&nbsp;&nbsp;&nbsp; 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.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<br>\n\n\n\n<p><strong><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">Topics covered\u00a0PostGIS (1\/2 day)<\/span><\/span><\/span><\/strong><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Section 1: Introduction to PostGIS<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">PostGIS provides a wide range of functions and operators for spatial data analysis,\nincluding spatial queries, spatial joins, and spatial aggregation. It also supports\nadvanced spatial analysis techniques, such as clustering, interpolation, and\ngeostatistics.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Section 2: Installation, different ways to Install PostGIS<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">PostGIS has many packaged installations and could be done in different\nways. However, the exact steps may vary depending on your operating system and\nversion of PostgreSQL. Learn from expert.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Section 3: Creating a Spatial Database<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">Learn to create a basic spatial database with the correct steps and commands.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Section 4: Loading spatial data with QGIS using DBManager<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">QGIS supports a wide range of data formats, so you can load data from various\nsources and use it for your spatial analysis and visualization tasks.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Section 5: Simple SQL techniques (demo)<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">PostGIS provides a rich set of spatial functions and operators that allow you to\nperform advanced spatial queries and analysis in SQL. Learn simple SQL\ntechniques in PostGIS that you can use to work with spatial data.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Section 6: Editing PostGIS data using QGIS<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">Geometry querying allows you to perform complex spatial analysis and data mining\ntasks using SQL. Users can combine geometry functions with other SQL operators\nand clauses to create powerful queries that filter, aggregate, and transform spatial\ndata.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Section 7 : Projecting Data<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">When working with spatial data in PostGIS, it is important to be aware of the\nprojection data and to ensure that all data sources are using the same projection.\nFailure to use the same projection can result in incorrect spatial analysis and\nvisualization, as well as data loss and inaccuracies.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<br>\n\n\n\n<p><strong><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">Topics covered\u00a0GeoServer (1\/2 day)<\/span><\/span><\/span><\/strong><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Section 1: Installing GeoServer<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">There are many ways to install GeoServer on your system. This section will discuss\nthe various installation paths available.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Section 2: GeoServer Interface\/Administration<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">The Web administration interface is a web-based tool for configuring all aspects of\nGeoServer, from adding data to changing service settings. In a default GeoServer\ninstallation, this interface is accessed via a web browser. Configuring user\nauthentication and authorization, securing services, and restricting access to data.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Section 3: Web GIS Concepts (Protocols)<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">Web GIS refers to the use of internet technologies and protocols to create, share,\nand consume geographic information through web-based interfaces. There are\nseveral protocols that are commonly used in web GIS applications such as\nWMS,WFS,WCS and TMS. We will dig more each protocol in this topic.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Section 4: Adding Layers<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">GeoServer layers refer to the geographic data that is served by the GeoServer\nsoftware. A layer in GeoServer represents a specific set of geographic features or\ndata that can be displayed on a map. These layers can be created from a variety of\ndata sources, including shapefiles, PostGIS databases, and remote web services.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Section 5: Styling Layers on GeoServer with QGIS<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">Each layer in GeoServer can be configured with a set of styling rules that determine\nhow the data is displayed on the map. This includes settings for the color, opacity,\nand labeling of the features within the layer.<\/span><\/span><\/span><\/p>\n\n\n\n<br>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong>Section 6: Final Project: From Zero to Hero &#8211; From Desktop GIS to Web GIS<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n<p><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\"><strong><\/strong><\/span><\/span><\/span><\/p>\n<p style=\"text-align:justify\"><span style=\"color:#000000\"><span style=\"font-size:16px\"><span style=\"font-family:Arial,Helvetica,sans-serif\">Create a simple project with GeoServer.<\/span><\/span><\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-1116","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Advanced QGIS Course (3 days) - Training<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/gis.com.my\/training\/advanced-qgis-course-3-days\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced QGIS Course (3 days) - Training\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gis.com.my\/training\/advanced-qgis-course-3-days\/\" \/>\n<meta property=\"og:site_name\" content=\"Training\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-06T02:49:47+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/gis.com.my\\\/training\\\/advanced-qgis-course-3-days\\\/\",\"url\":\"https:\\\/\\\/gis.com.my\\\/training\\\/advanced-qgis-course-3-days\\\/\",\"name\":\"Advanced QGIS Course (3 days) - Training\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gis.com.my\\\/training\\\/#website\"},\"datePublished\":\"2023-10-11T05:55:05+00:00\",\"dateModified\":\"2024-09-06T02:49:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/gis.com.my\\\/training\\\/advanced-qgis-course-3-days\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/gis.com.my\\\/training\\\/advanced-qgis-course-3-days\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/gis.com.my\\\/training\\\/advanced-qgis-course-3-days\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/gis.com.my\\\/training\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Advanced QGIS Course (3 days)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/gis.com.my\\\/training\\\/#website\",\"url\":\"https:\\\/\\\/gis.com.my\\\/training\\\/\",\"name\":\"Training\",\"description\":\"GIS Innovation Training Website\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/gis.com.my\\\/training\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Advanced QGIS Course (3 days) - Training","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/gis.com.my\/training\/advanced-qgis-course-3-days\/","og_locale":"en_US","og_type":"article","og_title":"Advanced QGIS Course (3 days) - Training","og_url":"https:\/\/gis.com.my\/training\/advanced-qgis-course-3-days\/","og_site_name":"Training","article_modified_time":"2024-09-06T02:49:47+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/gis.com.my\/training\/advanced-qgis-course-3-days\/","url":"https:\/\/gis.com.my\/training\/advanced-qgis-course-3-days\/","name":"Advanced QGIS Course (3 days) - Training","isPartOf":{"@id":"https:\/\/gis.com.my\/training\/#website"},"datePublished":"2023-10-11T05:55:05+00:00","dateModified":"2024-09-06T02:49:47+00:00","breadcrumb":{"@id":"https:\/\/gis.com.my\/training\/advanced-qgis-course-3-days\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gis.com.my\/training\/advanced-qgis-course-3-days\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/gis.com.my\/training\/advanced-qgis-course-3-days\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/gis.com.my\/training\/"},{"@type":"ListItem","position":2,"name":"Advanced QGIS Course (3 days)"}]},{"@type":"WebSite","@id":"https:\/\/gis.com.my\/training\/#website","url":"https:\/\/gis.com.my\/training\/","name":"Training","description":"GIS Innovation Training Website","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/gis.com.my\/training\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/gis.com.my\/training\/wp-json\/wp\/v2\/pages\/1116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gis.com.my\/training\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/gis.com.my\/training\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/gis.com.my\/training\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gis.com.my\/training\/wp-json\/wp\/v2\/comments?post=1116"}],"version-history":[{"count":5,"href":"https:\/\/gis.com.my\/training\/wp-json\/wp\/v2\/pages\/1116\/revisions"}],"predecessor-version":[{"id":1752,"href":"https:\/\/gis.com.my\/training\/wp-json\/wp\/v2\/pages\/1116\/revisions\/1752"}],"wp:attachment":[{"href":"https:\/\/gis.com.my\/training\/wp-json\/wp\/v2\/media?parent=1116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}