Module 1: Foundations of Web GIS, PostgreSQL, and Spatial Data

• Overview of Web GIS and its applications

• Introduction to PostgreSQL and PostGIS: Features, capabilities, and setup

• Spatial data types and functions in PostGIS

• SQL basics: queries, joins, subqueries for spatial analysis

• Setting up the PostgreSQL/PostGIS environment

• Case Study: Setting up a local government GIS system

• Exercise: Install and configure PostgreSQL and PostGIS

Module 2: Web Mapping Technologies, Standards, and Design

• Principles of web mapping and GIS

• OGC standards: WMS, WFS, and WCS overview

• Web mapping components: HTML, XML, CSS, JavaScript basics

• Tiled web maps and interactive map design

• Creating analytical and real-time maps with open-source tools

• Case Studies:

  • Implementing a web map for a tourism site

  • Designing a real-time traffic data map

• Exercise: Use HTML/CSS/JavaScript to build a simple web map with interactive elements using Leaflet/OpenLayers

Module 3: Data Integration, Spatial Processing & Advanced Tools

• Integrating and converting data formats (Shapefile, XML, KML, GeoJSON)

• Geocoding and reverse geocoding techniques

• Using AJAX and Fusion Tables for data-driven maps

• Spatial data processing using QGIS, GDAL, and OGR

• Vector and raster geo-processing and projection handling

• Case Studies:

  • City infrastructure data integration

  • Environmental data analysis in QGIS

• Exercise: Convert and process data formats; use QGIS for spatial analysis

 Module 4: Web Map Services (WMS), Tiled Maps, and APIs

• WMS standards: styling, querying, and symbolization

• Dynamic vs static map services

• Serving tiled maps with GeoServer, Mapnik, TileMill, GeoWebCache

• Overlaying WMS and using tiled layers in OpenLayers

• Introduction to Google Maps API and customizations

• Case Studies:

  • National park web map using WMS

  • Interactive city tiled map

  • Business locator web map with OpenLayers and Google Maps

• Exercises:

  • Set up and test WMS

  • Build and serve tiles in a web app

  • Integrate APIs into a mapping project

Module 5: Interactive Web GIS and Map Publishing

• Drawing and editing vector layers (GeoJSON, KML) in web apps

• Client-side vector editing and styling with OpenLayers

• Using OpenStreetMap for open-data applications

• Installing and configuring GeoServer

• Publishing spatial layers and managing services via GeoServer

• Case Studies:

  • Community mapping tool with user-drawn inputs

  • Public portal for published GIS services

• Exercises:

  • Interactive vector editing in web maps

  • GeoServer deployment, data querying, and map publishing