{"id":1134,"date":"2023-10-11T07:12:05","date_gmt":"2023-10-11T07:12:05","guid":{"rendered":"https:\/\/gis.com.my\/training\/?page_id=1134"},"modified":"2024-09-06T03:02:49","modified_gmt":"2024-09-06T03:02:49","slug":"integrating-qgis-with-postgis-and-geoserver-course-1-day","status":"publish","type":"page","link":"https:\/\/gis.com.my\/training\/integrating-qgis-with-postgis-and-geoserver-course-1-day\/","title":{"rendered":"Integrating QGIS with PostGIS and GeoServer Course (1 Day)"},"content":{"rendered":"\n\n\n\n\n\n\n\n

Intergrating QGIS with PostGIS and GeoServer Course (1 Day)
<\/strong><\/span><\/span><\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n

Course Outline<\/strong><\/span><\/span><\/span><\/p>\n\n\n


<\/p>\n\n\n

This one-day course provides a conceptual overview and hands-on experience using PostGIS and GeoServer. Integrating QGIS with PostGIS and GeoServer is a powerful combination that allows participants to manage, analyze and publish spatial data efficiently.<\/span><\/span><\/span>
\n <\/p>\n

PostGIS is a spatial extension for PostgresSQL, enabling storage and management geographic data within a relational database while GeoServer serves as a geospatial data server, enabling the publication of data as web services using standard protocols like WMS and WFS.<\/span><\/span><\/span>
\n <\/p>\n

QGIS integrating with PostGIS : QGIS connects to the PostGIS database, allowing users to add, edit, and analyze spatial data using QGIS desktop application. GeoServer connects to PostGIS database and publishes spatial data as web services, making them accessible over the web. For data synchronization, changes made to PostGIS layers in QGIS are reflected in the underlying database. GeoServer accesses the updated data when requested through its web services.<\/span><\/span><\/span>
\n <\/p>\n

Overall, this integration streamlines data management, analysis and web publishing processes, providing a powerful and efficient solution for handling geospatial information.<\/span><\/span><\/span>
\n <\/p>\n

PostGIS training provides a strong foundation in spatial data management and analysis, which is essential for professionals working fields. By the end of GeoServer training program, attendees will have the skills to create web-based maps for online
\ndisplay.<\/span><\/span><\/span><\/p>\n\n\n


<\/p>\n\n\n


<\/p>\n\n\n

<\/span><\/span><\/span><\/p>\n

Prerequisites:<\/strong><\/span><\/span><\/span><\/p>\n\n\n

<\/strong><\/span><\/span><\/span><\/p>\n

Integrating QGIS with PostGIS and GeoServer training is for those with IT and GIS\nbackground.<\/span><\/span><\/span><\/p>\n\n\n


<\/p>\n\n\n


<\/p>\n\n\n

<\/span><\/span><\/span><\/p>\n

Class Attendees Learn How to:<\/strong><\/span><\/span><\/span><\/p>\n\n\n


<\/div>\n\n\n

<\/span><\/span><\/span><\/strong><\/u><\/p>\n

 PostGIS<\/strong><\/span><\/span><\/span><\/p>\n\n\n

<\/strong><\/span><\/span><\/span><\/p>\n

    \n\t<\/ul>
    •      1. Introduction to PostGIS and understanding spatial database.<\/span><\/span><\/span><\/li>
    •      2. Installing and configuring PostGIS.<\/span><\/span><\/span><\/li>
    •      3. Working with PostGIS \u2013 create and manage spatial databases.<\/span><\/span><\/span><\/li>
    •      4. Learn how to load spatial data.<\/span><\/span><\/span><\/li>
    •      5. An introduction in using basic SQL in PostGIS.<\/span><\/span><\/span><\/li>
    •      6. Real life examples using those techniques.<\/span><\/span><\/span><\/li><\/ul>\n\n\n

      <\/div>\n\n\n

      <\/span><\/span><\/span><\/strong><\/u><\/p>\n

       GeoServer<\/strong><\/span><\/span><\/span><\/p>\n\n\n

      <\/strong><\/span><\/span><\/span><\/p>\n

        \n\t<\/ul>
        •      1. Understanding web mapping and using GeoServer to serve geospatial data.<\/span><\/span><\/span><\/li>
        •      2. Learn about GeoServer Layers and how to add information to your map.<\/span><\/span><\/span><\/li>
        •      3. Learn about WebGIS Concepts (Protocols \u2013 WMS, WFS, WCS and TMS).<\/span><\/span><\/span><\/li>
        •      4. Create Map for online display (Web-based GIS).<\/span><\/span><\/span><\/li><\/ul>\n\n\n

          <\/div>\n\n\n

          <\/div>\n\n\n

          Topics covered\u00a0PostGIS (1\/2 day)<\/span><\/span><\/span><\/strong><\/p>\n\n\n
          \n\n\n

          Section 1: Introduction to PostGIS<\/strong><\/span><\/span><\/span><\/p>\n\n\n

          <\/strong><\/span><\/span><\/span><\/p>\n

          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\n\n

          Section 2: Installation, different ways to Install PostGIS<\/strong><\/span><\/span><\/span><\/p>\n\n\n

          <\/strong><\/span><\/span><\/span><\/p>\n

          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\n\n

          Section 3: Creating a Spatial Database<\/strong><\/span><\/span><\/span><\/p>\n\n\n

          <\/strong><\/span><\/span><\/span><\/p>\n

          Learn to create a basic spatial database with the correct steps and commands.<\/span><\/span><\/span><\/p>\n\n\n
          \n\n\n

          Section 4: Loading spatial data with QGIS using DBManager<\/strong><\/span><\/span><\/span><\/p>\n\n\n

          <\/strong><\/span><\/span><\/span><\/p>\n

          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\n\n

          Section 5: Simple SQL techniques (demo)<\/strong><\/span><\/span><\/span><\/p>\n\n\n

          <\/strong><\/span><\/span><\/span><\/p>\n

          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\n\n

          Section 6: Editing PostGIS data using QGIS<\/strong><\/span><\/span><\/span><\/p>\n\n\n

          <\/strong><\/span><\/span><\/span><\/p>\n

          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\n\n

          Section 7 : Projecting Data<\/strong><\/span><\/span><\/span><\/p>\n\n\n

          <\/strong><\/span><\/span><\/span><\/p>\n

          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\n\n
          \n\n\n

          Topics covered\u00a0GeoServer (1\/2 day)<\/span><\/span><\/span><\/strong><\/p>\n\n\n
          \n\n\n

          Section 1: Installing GeoServer<\/strong><\/span><\/span><\/span><\/p>\n\n\n

          <\/strong><\/span><\/span><\/span><\/p>\n

          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\n\n

          Section 2: GeoServer Interface\/Administration<\/strong><\/span><\/span><\/span><\/p>\n\n\n

          <\/strong><\/span><\/span><\/span><\/p>\n

          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\n\n

          Section 3: Web GIS Concepts (Protocols)<\/strong><\/span><\/span><\/span><\/p>\n\n\n

          <\/strong><\/span><\/span><\/span><\/p>\n

          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\n\n

          Section 4: Adding Layers<\/strong><\/span><\/span><\/span><\/p>\n\n\n

          <\/strong><\/span><\/span><\/span><\/p>\n

          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\n\n

          Section 5: Styling Layers on GeoServer with QGIS<\/strong><\/span><\/span><\/span><\/p>\n\n\n

          <\/strong><\/span><\/span><\/span><\/p>\n

          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\n\n

          Section 6: Final Project: From Zero to Hero – From Desktop GIS to Web GIS<\/strong><\/span><\/span><\/span><\/p>\n\n\n

          <\/strong><\/span><\/span><\/span><\/p>\n

          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","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-1134","page","type-page","status-publish","hentry"],"yoast_head":"\nIntegrating QGIS with PostGIS and GeoServer Course (1 Day) - 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\/integrating-qgis-with-postgis-and-geoserver-course-1-day\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Integrating QGIS with PostGIS and GeoServer Course (1 Day) - Training\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gis.com.my\/training\/integrating-qgis-with-postgis-and-geoserver-course-1-day\/\" \/>\n<meta property=\"og:site_name\" content=\"Training\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-06T03:02:49+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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/gis.com.my\\\/training\\\/integrating-qgis-with-postgis-and-geoserver-course-1-day\\\/\",\"url\":\"https:\\\/\\\/gis.com.my\\\/training\\\/integrating-qgis-with-postgis-and-geoserver-course-1-day\\\/\",\"name\":\"Integrating QGIS with PostGIS and GeoServer Course (1 Day) - Training\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gis.com.my\\\/training\\\/#website\"},\"datePublished\":\"2023-10-11T07:12:05+00:00\",\"dateModified\":\"2024-09-06T03:02:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/gis.com.my\\\/training\\\/integrating-qgis-with-postgis-and-geoserver-course-1-day\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/gis.com.my\\\/training\\\/integrating-qgis-with-postgis-and-geoserver-course-1-day\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/gis.com.my\\\/training\\\/integrating-qgis-with-postgis-and-geoserver-course-1-day\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/gis.com.my\\\/training\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Integrating QGIS with PostGIS and GeoServer Course (1 Day)\"}]},{\"@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":"Integrating QGIS with PostGIS and GeoServer Course (1 Day) - 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\/integrating-qgis-with-postgis-and-geoserver-course-1-day\/","og_locale":"en_US","og_type":"article","og_title":"Integrating QGIS with PostGIS and GeoServer Course (1 Day) - Training","og_url":"https:\/\/gis.com.my\/training\/integrating-qgis-with-postgis-and-geoserver-course-1-day\/","og_site_name":"Training","article_modified_time":"2024-09-06T03:02:49+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/gis.com.my\/training\/integrating-qgis-with-postgis-and-geoserver-course-1-day\/","url":"https:\/\/gis.com.my\/training\/integrating-qgis-with-postgis-and-geoserver-course-1-day\/","name":"Integrating QGIS with PostGIS and GeoServer Course (1 Day) - Training","isPartOf":{"@id":"https:\/\/gis.com.my\/training\/#website"},"datePublished":"2023-10-11T07:12:05+00:00","dateModified":"2024-09-06T03:02:49+00:00","breadcrumb":{"@id":"https:\/\/gis.com.my\/training\/integrating-qgis-with-postgis-and-geoserver-course-1-day\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gis.com.my\/training\/integrating-qgis-with-postgis-and-geoserver-course-1-day\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/gis.com.my\/training\/integrating-qgis-with-postgis-and-geoserver-course-1-day\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/gis.com.my\/training\/"},{"@type":"ListItem","position":2,"name":"Integrating QGIS with PostGIS and GeoServer Course (1 Day)"}]},{"@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\/1134","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=1134"}],"version-history":[{"count":5,"href":"https:\/\/gis.com.my\/training\/wp-json\/wp\/v2\/pages\/1134\/revisions"}],"predecessor-version":[{"id":1785,"href":"https:\/\/gis.com.my\/training\/wp-json\/wp\/v2\/pages\/1134\/revisions\/1785"}],"wp:attachment":[{"href":"https:\/\/gis.com.my\/training\/wp-json\/wp\/v2\/media?parent=1134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}