Open-Source Web GIS for Government

Building Government Web GIS Using Open-Source Technologies

Technology Stack: QGIS + PostGIS + GeoServer + VistaBridge

This course is the Rotten Grapes product-aligned version of the Web GIS & Government Dashboards course and is consistent with the Open-Source Web GIS course developed earlier.

1. Course Introduction

The training focuses on building government Web GIS solutions using open-source technologies and the VistaBridge integration layer.

Participants will learn the complete workflow from preparing government GIS data to database management, OGC service publishing, Web GIS configuration and integration with VistaBridge.

2. What Will You Learn?

• Open-source Government Web GIS
• GIS data preparation with QGIS
• PostGIS
• GeoServer
• OGC services
• Web map configuration
• VistaBridge integration
• Dataset management
• User/access concepts
• Government GIS portals
• Dashboard-oriented visualization

3. Course Objectives

Participants will learn to:

• Design an open-source government Web GIS workflow
• Prepare government datasets
• Store datasets in PostGIS
• Publish data using GeoServer
• Configure OGC services
• Build Web GIS maps
• Integrate services through VistaBridge
• Manage datasets and access concepts
• Build a complete government GIS portal

4. Course Modules

Module 1: Government GIS & Open-Source Web GIS

Topics Covered

• Government GIS requirements
• Web GIS architecture
• Open-source GIS
• Client-server architecture
• GIS data workflow

Module 2: Government GIS Data Preparation

Topics Covered

• QGIS
• Data cleaning
• CRS
• Attributes
• Government datasets

Practical: Prepare municipal/government datasets.

Module 3: Spatial Database with PostGIS

Topics Covered

• Database
• Schema
• Spatial tables
• Data loading
• Spatial indexes

Practical: Create and populate a government spatial database.

Module 4: GeoServer & OGC Services

Topics Covered

• GeoServer
• Data stores
• Layers
• WMS
• WFS
• Service configuration

Practical: Publish government GIS layers.

Module 5: Web Map Configuration

Topics Covered

• Interactive maps
• Layer configuration
• Queries
• Filters
• Visualization
• Map interaction

Module 6: VistaBridge Integration

Topics Covered

• VistaBridge
• GeoServer integration
• Public/private GIS services
• Dataset access concepts
• Web GIS integration

Module 7: Government GIS Portal

Practical: Build a complete government/municipal Web GIS portal.

5. Learn by Building

Raw Government Data → QGIS → PostGIS → GeoServer → OGC Services → VistaBridge → Web Map → Dataset Management → Government GIS Portal

6. Real-World Applications

• Municipal GIS portals
• Urban governance
• Government departments
• Infrastructure GIS
• Utility GIS
• Public GIS portals
• Administrative GIS
• Asset management portals

7. Who Is This Training For?

• Government GIS professionals
• Municipal GIS officers
• GIS developers
• GIS administrators
• IT professionals
• Spatial data managers
• Urban planners
• Government project teams

8. Prerequisites

• Basic GIS
• Raster/vector concepts
• CRS
• Basic Web GIS understanding desirable
• Basic database knowledge desirable

No prior experience with PostGIS, GeoServer or VistaBridge is required.

9. Software / Technical Environment

10. Duration

3 Days / 24 Hours

11. Training Modes

• Onsite
• Online
• Hybrid
• Customized institutional training

12. What You Will Be Able to Do

Participants will be able to:

• Prepare government GIS data
• Manage spatial databases
• Publish OGC services
• Configure Web GIS
• Integrate GeoServer through VistaBridge
• Manage government GIS datasets
• Develop an open-source government GIS portal

13. End-to-End Workflow

Government GIS Data → QGIS → PostGIS → GeoServer → OGC Services → VistaBridge → Web Map → Dataset Management → Government Web GIS Portal

14. Complete Practical Outcome

Build a complete open-source government Web GIS portal from raw government GIS datasets.