Explore the powerful geospatial capabilities of PostgreSQL in this conference talk from NDC Oslo 2024. Discover three innovative features for handling geospatial time series data in unconventional ways. Learn how to leverage JSON types in PostgreSQL, utilize the PostGIS extension for geospatial data management, and harness the TimescaleDB extension to process continuous streams of geospatial information. Follow along as the speaker demonstrates these concepts using real-world marine traffic data from Norwegian waters, showcasing an application built to visualize and analyze this open dataset from the Norwegian Coastal Administration.