Geospatial Systems, Data, and Strange Machinery¶
Building production-scale systems at the intersection of geospatial data, cloud infrastructure, and distributed computing
Welcome¶
This is my technical studioβa curated collection of best practices, tutorials, and experiments from building production systems at Oak Ridge National Laboratory and beyond. Here you'll find deep dives into geospatial data engineering, distributed systems architecture, and the practical patterns that make complex systems reliable.
What to Expect
This site is organized into Best Practices (conceptual guides and patterns) and Tutorials (step-by-step implementations). Both are written for engineers who need production-ready solutions, not just examples.
Quick Navigation¶
π― Best Practices¶
Production-grade patterns, architectures, and methodologies for building reliable distributed systems.
Highlights: - System Resilience & Concurrency - Configuration Management - Release Management & Progressive Delivery - IAM & RBAC Governance
π Tutorials¶
Step-by-step guides with copy-paste examples for implementing key technologies and patterns.
Popular: - PostGIS Geometry Indexing - PostgreSQL Auditing with PgAudit - RKE2 on Raspberry Pi - ONNX Browser Inference
ποΈ Projects¶
Technical implementations, experiments, and creative explorations at the edge of what's possible.
Featured: - Final Fantasy Football (semantic learning) - Where I've Been (travel visualization) - This Is A Casino (trading platform) - Decentralized Content Reward System
π¨ Just for Fun¶
Creative, experimental, and occasionally absurd implementations β from generative art to MIDI-driven servers.
Recent: - Pi Sample Library Server - Recursive Cathedral Generator - Fractal Art Explorer - OSC + MQTT + SuperCollider
π Start Here¶
If you're new to this site, these foundational guides will give you the most value:
- ADR and Technical Decision Governance β How we make and document architectural decisions
- Configuration Management β Managing configs across multi-environment systems
- System Resilience & Concurrency β Patterns for building resilient distributed systems
- IAM & RBAC Governance β Identity and access management across heterogeneous stacks
Featured Deep Dives¶
Parquet & Data Warehouses¶
Fast queries & cheap storage β How to lay out partitions, size files and row groups, enable predicate pushdown & column pruning, serve efficiently over S3 byte-range, and wire up parquet_s3_fdw in Postgres for pushdown.
Geospatial Data Engineering¶
PostGIS Best Practices β Production patterns for spatial indexing, raster workflows, and large-scale geospatial data management.
Release Management¶
Release Management & Progressive Delivery β Safe deployment strategies for coordinating changes across applications, databases, data pipelines, and ML systems.
What I'm Working On¶
Currently focused on:
- Advanced geospatial data warehouse architectures using GeoParquet and PostGIS
- Real-time IoT tracking systems with Kafka, TimescaleDB, and geospatial processing
- Production-grade configuration management for multi-environment distributed systems
- ML model deployment pipelines with ONNX, MLflow, and progressive delivery
About This Site¶
This documentation represents years of building production systems, learning from failures, and refining patterns that actually work. Everything here is battle-tested in real environmentsβfrom air-gapped clusters to cloud-native architectures.
The content is organized to be immediately useful: copy-paste examples, production-ready configurations, and clear explanations of trade-offs. No fluff, no theory without practice.
Latest Updates¶
Feb 2026: - Recursive Cathedral Generator (Kotlin + Processing) β L-system generative architecture - Pi-Based Sample Library Server β WebAudio + SQLite + USB MIDI on a Raspberry Pi
2025: - Vibe β Agentic LLMs β Production agentic LLM architecture - IAM & RBAC Governance β Identity and access across heterogeneous stacks - Release Management & Progressive Delivery β Safe deployments at scale - ONNX Browser Inference β Run ML models client-side
Connect¶
- GitHub: @sempervent
- LinkedIn: Joshua N. Grant
- Email: jngrant@live.com
- Blog: Not Just a Datum