{"id":15450,"date":"2023-02-14T20:23:00","date_gmt":"2023-02-14T19:23:00","guid":{"rendered":"https:\/\/www.opengis.ch\/?p=15450"},"modified":"2025-08-19T13:31:22","modified_gmt":"2025-08-19T11:31:22","slug":"postgis-with-qgis","status":"publish","type":"post","link":"https:\/\/www.opengis.ch\/de\/2023\/02\/14\/postgis-with-qgis\/","title":{"rendered":"PostGIS with QGIS (on request)"},"content":{"rendered":"\n<p><strong>Unlock the power of spatial databases in QGIS.<\/strong><br>This hands-on course dives into the integration of PostGIS and QGIS, enabling efficient, scalable, and collaborative geodata management. Ideal for GIS professionals, analysts, and developers, the course is designed to provide practical skills in working with spatial databases directly from QGIS.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-a89b3969 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-accent-background-color has-background wp-element-button\" href=\"mailto:sales@opengis.ch?subject=PostGIS%20Course%20Request\" target=\"_blank\" rel=\"noreferrer noopener\">Request quote<\/a><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>\ud83d\udcc5 Duration:<\/strong> On request (typically 2\u20133 days)<br><strong>\ud83c\udfaf Format:<\/strong> In-person or online<br><strong>\ud83d\udce6 Customisable:<\/strong> Tailored content and focus areas available on request<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83e\udde0 What You&#8217;ll Learn<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Getting Started with PostGIS<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Understanding spatial databases: why and when to use them<\/li>\n\n\n\n<li>Introduction to PostgreSQL and PostGIS<\/li>\n\n\n\n<li>Installing and configuring your spatial database environment<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Connecting QGIS to PostGIS<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Exploring PostGIS layers in QGIS<\/li>\n\n\n\n<li>Styling, labeling, and editing database layers<\/li>\n\n\n\n<li>Working with read\/write permissions and managing multiple users<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Managing Spatial Data<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Importing and exporting data between QGIS and PostGIS<\/li>\n\n\n\n<li>Understanding geometry types and coordinate systems<\/li>\n\n\n\n<li>Using spatial indexes and optimizing queries<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Spatial SQL for Everyday GIS<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Writing basic to advanced spatial queries<\/li>\n\n\n\n<li>Filtering and analyzing data with PostGIS functions (<code>ST_Intersects<\/code>, <code>ST_Buffer<\/code>, etc.)<\/li>\n\n\n\n<li>Automating workflows with SQL and expressions<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Advanced Integration &amp; Collaboration<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Using PostGIS for multi-user editing in QGIS<\/li>\n\n\n\n<li>Versioning and backup strategies<\/li>\n\n\n\n<li>Leveraging PostGIS in geospatial web services and apps<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\ude80 Who is it for?<\/h3>\n\n\n\n<p>This course is perfect for:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>GIS professionals wanting to transition from file-based to database workflows<\/li>\n\n\n\n<li>Organizations managing large or collaborative geospatial projects<\/li>\n\n\n\n<li>Anyone looking to improve performance and scalability in GIS data handling<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udcac Available on Request<\/h3>\n\n\n\n<p>We offer this training on request for teams, institutions, or individuals. Whether you need a full introductory workshop or an advanced deep dive into spatial SQL, we tailor the content to your needs and context.<\/p>\n\n\n\n<p>\ud83d\udc49 <strong>Get in touch to schedule a session or request a customized quote.<\/strong><\/p>\n\n\n\n<p>One instructor for 4 to 8 participants and two for 9 to 14 participants.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-a89b3969 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-accent-background-color has-background wp-element-button\" href=\"mailto:sales@opengis.ch?subject=PostGIS%20Course%20Request\" target=\"_blank\" rel=\"noreferrer noopener\">Request quote<\/a><\/div>\n<\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The course is aimed at PostgreSQL users who want to expand their knowledge. Various approaches will be explained to optimize the use of their databases and practiced through different examples.<\/p>\n","protected":false},"author":2,"featured_media":14906,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3,10],"tags":[],"class_list":["post-15450","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-courses","category-postgis-courses"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/08\/DALL%C2%B7E-2024-08-12-15.09.25-A-professional-and-educational-themed-image-for-a-PostgreSQL-administration-course.-The-image-should-feature-a-laptop-displaying-a-PostgreSQL-interfac.webp?fit=1024%2C1024&ssl=1","jetpack-related-posts":[{"id":1657,"url":"https:\/\/www.opengis.ch\/de\/2015\/06\/01\/qgis-quality-and-testing\/","url_meta":{"origin":15450,"position":0},"title":"QGIS Quality and Testing","author":"Matthias Kuhn","date":"1. Juni 2015","format":false,"excerpt":"I promised that I will write a bit about what I've been up to at the last QGIS developer meeting - apart from the social part we also got some work done there. So let me start with something that really matters to me and I think can make a\u2026","rel":"","context":"In &quot;Uncategorised&quot;","block_context":{"text":"Uncategorised","link":"https:\/\/www.opengis.ch\/de\/category\/uncategorised\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":15860,"url":"https:\/\/www.opengis.ch\/de\/2025\/07\/04\/qgis-and-postgis-expert\/","url_meta":{"origin":15450,"position":1},"title":"QGIS- &amp; PostGIS-Expert:in | 80\u2013100% (CH)","author":"Marco Bernasocchi","date":"4. Juli 2025","format":false,"excerpt":"Werde Teil unseres engagierten Teams bei OPENGIS.ch! Unterst\u00fctze Kunden bei QGIS- und PostGIS-Projekten, arbeite eigenverantwortlich und gestalte die Zukunft von Open-Source-Geodatenl\u00f6sungen aktiv mit. Wir bieten spannende Projekte, flexible Arbeitsbedingungen und ein starkes, kollaboratives Umfeld.","rel":"","context":"\u00c4hnlicher Beitrag","block_context":{"text":"\u00c4hnlicher Beitrag","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/07\/ChatGPT-Image-Jul-4-2025-09_22_43-PM.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/07\/ChatGPT-Image-Jul-4-2025-09_22_43-PM.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/07\/ChatGPT-Image-Jul-4-2025-09_22_43-PM.jpg?fit=1024%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/07\/ChatGPT-Image-Jul-4-2025-09_22_43-PM.jpg?fit=1024%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":15863,"url":"https:\/\/www.opengis.ch\/2025\/07\/04\/qgis-and-postgis-expert\/","url_meta":{"origin":15450,"position":2},"title":"QGIS- &amp; PostGIS-Expert:in | 80\u2013100% (CH)","author":"Marco Bernasocchi","date":"4. Juli 2025","format":false,"excerpt":"Werde Teil unseres engagierten Teams bei OPENGIS.ch! Unterst\u00fctze Kunden bei QGIS- und PostGIS-Projekten, arbeite eigenverantwortlich und gestalte die Zukunft von Open-Source-Geodatenl\u00f6sungen aktiv mit. Wir bieten spannende Projekte, flexible Arbeitsbedingungen und ein starkes, kollaboratives Umfeld.","rel":"","context":"\u00c4hnlicher Beitrag","block_context":{"text":"\u00c4hnlicher Beitrag","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/07\/ChatGPT-Image-Jul-4-2025-09_22_43-PM.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/07\/ChatGPT-Image-Jul-4-2025-09_22_43-PM.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/07\/ChatGPT-Image-Jul-4-2025-09_22_43-PM.jpg?fit=1024%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/07\/ChatGPT-Image-Jul-4-2025-09_22_43-PM.jpg?fit=1024%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":14202,"url":"https:\/\/www.opengis.ch\/it\/2023\/03\/06\/qgis-advanced\/","url_meta":{"origin":15450,"position":3},"title":"QGIS Avanzato","author":"Marco Bernasocchi","date":"6. M\u00e4rz 2023","format":false,"excerpt":"Dopo aver seguito questa formazione, i partecipanti saranno in grado di realizzare progetti complessi con QGIS. Conosceranno le caratteristiche di diversi formati di dati come PostGIS e GeoPackage, saranno capaci di configurare flussi di lavoro per l\u2019elaborazione dei geodati con strumenti di processing, creare stampe tramite layout, importare\/esportare dati Interlis\u2026","rel":"","context":"In &quot;Corsi QGIS&quot;","block_context":{"text":"Corsi QGIS","link":"https:\/\/www.opengis.ch\/it\/category\/corsi\/corsi-qgis\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2021\/11\/modelbaker_baked_project_with_form_wide2.png?fit=1200%2C677&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2021\/11\/modelbaker_baked_project_with_form_wide2.png?fit=1200%2C677&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2021\/11\/modelbaker_baked_project_with_form_wide2.png?fit=1200%2C677&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2021\/11\/modelbaker_baked_project_with_form_wide2.png?fit=1200%2C677&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2021\/11\/modelbaker_baked_project_with_form_wide2.png?fit=1200%2C677&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":15869,"url":"https:\/\/www.opengis.ch\/fr\/2025\/07\/04\/experte-qgis-et-postgis\/","url_meta":{"origin":15450,"position":4},"title":"Expert\u00b7e QGIS &amp; PostGIS | 80\u2013100% (CH)","author":"Marco Bernasocchi","date":"4. Juli 2025","format":false,"excerpt":"\ud83d\udcbb\ud83d\ude80 Rejoins notre \u00e9quipe engag\u00e9e chez OPENGIS.ch ! Assiste les clients dans leurs projets QGIS et PostGIS, travaille de mani\u00e8re autonome et contribue activement \u00e0 fa\u00e7onner l'avenir des solutions de g\u00e9odonn\u00e9es open source. Nous proposons des projets passionnants, des conditions de travail flexibles et un environnement fort et collaboratif.","rel":"","context":"\u00c4hnlicher Beitrag","block_context":{"text":"\u00c4hnlicher Beitrag","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/07\/ChatGPT-Image-Jul-4-2025-09_22_43-PM.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/07\/ChatGPT-Image-Jul-4-2025-09_22_43-PM.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/07\/ChatGPT-Image-Jul-4-2025-09_22_43-PM.jpg?fit=1024%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/07\/ChatGPT-Image-Jul-4-2025-09_22_43-PM.jpg?fit=1024%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":11942,"url":"https:\/\/www.opengis.ch\/it\/2021\/02\/04\/corso-qgis-avanzato-online-10-17-05-2021\/","url_meta":{"origin":15450,"position":5},"title":"Corso QGIS avanzato, Online 10\/17.05.2021","author":"Marco Bernasocchi","date":"4. Februar 2021","format":false,"excerpt":"Iscrizione CORSO ANNULLATO \u2013 Prossimo corso in Settembre 2021 Il corso dura 2 giorni (9:00 - 17:00) tramite Google Meet (non \u00e8 richiesto un account Google) e costa 850 CHF a persona.\u00a0Un insegnante per un massimo di 6 partecipanti e 2 insegnanti da 7 a 12 partecipanti. Descrizione Alla fine\u2026","rel":"","context":"In &quot;Non categorizzato&quot;","block_context":{"text":"Non categorizzato","link":"https:\/\/www.opengis.ch\/it\/category\/non-categorizzato\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2020\/04\/AdobeStock_305245557-scaled.jpeg?fit=1200%2C400&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2020\/04\/AdobeStock_305245557-scaled.jpeg?fit=1200%2C400&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2020\/04\/AdobeStock_305245557-scaled.jpeg?fit=1200%2C400&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2020\/04\/AdobeStock_305245557-scaled.jpeg?fit=1200%2C400&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2020\/04\/AdobeStock_305245557-scaled.jpeg?fit=1200%2C400&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_shortlink":"https:\/\/wp.me\/pbdBtI-41c","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/posts\/15450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/comments?post=15450"}],"version-history":[{"count":5,"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/posts\/15450\/revisions"}],"predecessor-version":[{"id":17763,"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/posts\/15450\/revisions\/17763"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/media\/14906"}],"wp:attachment":[{"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/media?parent=15450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/categories?post=15450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.opengis.ch\/de\/wp-json\/wp\/v2\/tags?post=15450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}