LEARN WITH BNHR

Geospatial Data
Management & Engineering

Presentations, workbooks, tools, and links to resources for BNHR's geospatial data management and engineering training.

Tools

Self-Assessment

Test your knowledge

Utilities

docker compose files & configs

Presentations

Presentation 00

Presentation 01

Storing Spatial Data and Spatial Databases

Presentation 02

Sharing Spatial Data (GeoServer and Beyond)

Presentation 03

Spatial Data Infrastructure & GeoNode

Presentation 04

Webmaps & Dashboards

Presentation 05

Cloud-native geospatial

Workbooks

Introduction to Databases and SQL PDF

Introduction to PostGIS & Spatial Databases PDF

Exercises - PostGIS DOC

Exercises - GeoServer DOC

Exercises - GeoNode DOC

Exercises - Webmaps & Dashboards DOC

Exercises - Cloud native geospatial DOC

Open Geospatial in Multi-user & Enterprise environments PDF

Examples

Single HTML webmap using Leaflet

Single HTML webmap using MapLibre

Loading a large geoJSON via WFS (bad)

Loading, Styling, and Filtering pmtiles in MapLibre

Single HTML webmap with more complex user interactions

Sample dashboard with streamlit

Sample dashboard with Observable Framework

Sample dashboard with Evidence

Links to Other Resources

PostGIS Documentation

Official reference for PostGIS functions, types, and usage.

Introduction to PostGIS

Hands-on workshop covering spatial queries, indexing, and geometry operations.

GeoServer User Manual

Complete guide to publishing, styling, and managing geospatial data with GeoServer.

GeoServer — Getting Started

Step-by-step guide to loading data and publishing your first WMS/WFS layer.

GeoNode Documentation

Official docs for installing, administering, and using the GeoNode spatial data platform.

DuckDB Documentation

Reference for DuckDB's SQL dialect, extensions, and in-process analytics engine.

DuckDB Spatial Extension

Geospatial types, functions, and format support inside DuckDB via the spatial extension.

Cloud Native Geospatial Foundation

Community hub for cloud-optimized geospatial formats, standards, and best practices.

Cloud Native Geo

Cloud Optimized GeoTIFF (COG)

Specification and tooling for GeoTIFFs optimized for HTTP range-request access.

COGCloud Native Geo

SpatioTemporal Asset Catalog (STAC)

Specification for describing and cataloging geospatial assets in a standardized, searchable way.

STACCloud Native Geo

STAC Specification (GitHub)

Source specification for STAC items, catalogs, and collections with full examples.

Specification for encoding vector geodata in Apache Parquet for cloud-native workflows.

GeoParquetCloud Native Geo

Single-file archive format for tiled map data, designed for serverless tile hosting.

PMTilesCloud Native Geo

Zero-config vector tile server from CrunchyData — serves MVT tiles directly from PostGIS.

pg_tileservPostGIS

Python-based OGC API server supporting Features, Tiles, Maps, and Records — the modern successor to WFS.

pygeoapiCloud Native Geo

QGIS Server Manual

Publish WMS and WFS services directly from a QGIS project file, with styles included.

Build vector tilesets from GeoJSON or other vector data — the standard tool for generating PMTiles and MBTiles.

tippecanoePMTiles

Lightweight JavaScript library for embedding interactive web maps — consumes WMS, WFS, and tile services.

Open-source WebGL-based mapping library — supports vector tiles, PMTiles, and JSON style specifications.

Web MappingPMTiles

Streamlit Documentation

Build and share interactive data apps in pure Python — no front-end experience required.

Collaborative JavaScript notebook platform for building and sharing live data visualizations.

Observable Framework

Static-site framework for building fast, self-contained data apps and dashboards from Markdown and JavaScript.

Code-driven BI tool — write SQL and Markdown to build polished data reports and dashboards.

Python library for creating, reading, and validating STAC catalogs, collections, and items.

Web-based browser for exploring STAC catalogs and previewing assets — works with any STAC-compliant API.

Get Started with Docker

Official introduction to Docker — installation, core concepts, and running your first container.

Dockerfile Reference

Complete reference for all Dockerfile instructions used to build container images.

Docker Compose Overview

Define and run multi-container applications with a single YAML file using Docker Compose.

Registry of public container images — find official images for PostGIS, GeoServer, GeoNode, and more.