PG-Stack: Build Modern Geospatial Applications with PostgreSQL

PostGIS • pgRouting • pg_tileserv • pg_featureserv • PostgREST

Store. Analyze. Route. Serve. Build.

Modern geospatial applications don't always require a complex GIS infrastructure.

The PG-Stack brings together PostgreSQL and a powerful ecosystem of open-source extensions and services to create a complete foundation for modern spatial applications.

This advanced, hands-on training demonstrates how PostgreSQL + PostGIS can become the core of a geospatial application—supporting spatial analysis, routing, vector tiles, feature services and REST APIs.

Participants will learn how to move from a spatial database to a fully functional geospatial backend using lightweight, open-source technologies.

One Database. Multiple Geospatial Capabilities.

The PG-Stack brings together the capabilities required to build modern geospatial applications:

PostgreSQL + PostGIS
Spatial Data & Analysis

↓

pgRouting
Network & Routing Analysis

↓

pg_tileserv
Vector Tiles & Map Visualization

↓

pg_featureserv
OGC API – Features & Spatial Data Access

↓

PostgREST
REST APIs from PostgreSQL

Together, these technologies provide a powerful alternative architecture for building scalable, API-driven Web GIS applications.

What Will You Learn?

PostgreSQL & PostGIS — The Spatial Foundation

PostgreSQL database fundamentals
PostGIS architecture and capabilities
Geometry and Geography data types
Spatial Reference Systems
Spatial data management
Spatial SQL
Spatial relationships and predicates
Spatial joins
Buffer and overlay analysis
Distance and proximity analysis
Spatial indexing
Spatial query optimization

pg_tileserv — Serving Vector Tiles

Introduction to vector tiles
pg_tileserv architecture
Publishing PostGIS tables as tiles
Dynamic vector tile generation
Tile-based visualization
Styling and visualization concepts
Working with large spatial datasets
Connecting vector tiles to Web GIS clients
Integrating pg_tileserv with OpenLayers and other clients

pg_featureserv — Publishing Spatial Features

Introduction to feature services
pg_featureserv architecture
Publishing PostGIS tables and functions
Querying spatial features
Filtering and parameterized queries
OGC API – Features concepts
Accessing geospatial data through APIs
Integrating feature services with Web GIS applications

PostgREST — Turning PostgreSQL into REST APIs

Introduction to PostgREST
PostgREST architecture
Exposing PostgreSQL tables and views
RESTful API concepts
Filtering and querying data
Database functions as APIs
Authentication and authorization concepts
API security
Working with spatial data through REST APIs
Integrating APIs with Web and mobile applications

Learn by Building

Build an End-to-End Geospatial Backend

The training is centered around a practical project in which participants build a complete geospatial backend using the PG-Stack.

PostgreSQL + PostGIS + pgRouting + pg_tileserv + pg_featureserv + PostgREST

Participants will work with real-world spatial datasets and progressively build the application architecture.

Hands-on Workflow

Set up PostgreSQL and PostGIS
Create and manage spatial databases
Load and prepare real-world spatial datasets
Perform spatial analysis using PostGIS
Create a routable network using pgRouting
Perform shortest-path and network analysis
Publish spatial data through pg_tileserv
Publish feature data through pg_featureserv
Expose application data through PostgREST
Build REST-based spatial workflows
Integrate services with a Web GIS client
Build an end-to-end geospatial application backend

Build Without a Traditional GIS Server

One of the key concepts explored in this course is the database-centric Web GIS architecture.

Instead of routing every operation through a traditional GIS server, PostgreSQL/PostGIS becomes the central geospatial engine.

PostgreSQL/PostGIS
↓
Spatial Analysis | Routing | Vector Tiles | Feature APIs | REST APIs
↓
Web / Mobile / Enterprise Applications

This architecture can provide a lightweight and highly flexible foundation for modern API-driven geospatial applications.

What Can You Build?

The PG-Stack can be applied to a wide range of real-world applications, including:

Municipal GIS
Property and land information systems
Transportation and routing applications
Utility and infrastructure management
Asset management systems
Location-based services
Field data applications
Logistics and route optimization
Environmental applications
Agriculture and precision farming
Web GIS platforms
Spatial data APIs

Who Is This Training For?

This advanced course is designed for professionals who want to build modern, open-source and API-driven geospatial applications.

GIS Developers
Web GIS Developers
Software Engineers
Spatial Database Professionals
Backend Developers
GIS Professionals
Solution Architects
Data Engineers
DevOps & Platform Engineers
Advanced Engineering Students
Researchers

Prerequisites

Participants should have a basic understanding of:

GIS concepts and spatial data
PostgreSQL / SQL
Web GIS concepts

Prior experience with PostGIS is recommended.

Basic programming or API development experience will be an advantage.

Duration

4–5 Days

The duration can be customized based on the participant's experience and the depth of hands-on implementation required.

Training Modes

Online | Onsite | Corporate | Institutional

Customized programs can be designed for organizations looking to adopt open-source spatial databases, API-driven GIS architectures or PostgreSQL-based geospatial solutions.

What You Will Be Able to Do

By the end of this training, you will be able to:

✓ Build and manage a PostgreSQL/PostGIS spatial database
✓ Perform advanced spatial queries and analysis
✓ Build routing and network analysis workflows using pgRouting
✓ Publish dynamic vector tiles using pg_tileserv
✓ Expose spatial features through pg_featureserv
✓ Build REST APIs directly from PostgreSQL using PostgREST
✓ Design API-driven geospatial application architectures
✓ Integrate spatial services with Web GIS applications
✓ Build lightweight and scalable geospatial backends
✓ Combine database, routing, visualization and API capabilities into a single spatial technology stack

The Modern PostgreSQL Geospatial Stack

One spatial database. Multiple capabilities. Endless possibilities.

Learn how PostgreSQL and its geospatial ecosystem can power the database, analysis engine, routing engine, map services and APIs behind modern geospatial applications.

Ready to Build with the PG-Stack?

Learn. Integrate. Build modern geospatial applications.

[ Enquire About This Training ]

Duration: 5 days

Mode: Both Online & Offline