Tutorial: How to Use GERS IDs in Wherobots for Geospatial Data Integration

In the world of geospatial data, entity matching and data integration are common challenges. In this blog post, we'll explore how to use the Overture Maps Foundation GERS IDs within Wherobots to link information about the same physical location across different datasets.

Wherobots, Sedona, and GeoPandas are better together

Discover the synergy of Wherobots, Sedona, and GeoPandas for geospatial data computation. This article details their execution differences, showcases the Sedona GeoPandas API, and highlights their combined potential for efficient large-dataset analysis.

Location Intelligence with Isochrones: A Complete Guide

Ditch intuition: Use data to optimize location decisions. Where you invest has a long-term impact on a location’s overall profitability. The mantra of “location, location, location” is absolutely still alive. But unlike 20 years ago, you now have the ability to let off-the-shelf data and modern geospatial engines like Wherobots tell you where the ideal physical locations are to invest in, across hundreds of thousands of options, using a few lines of SQL.

Building a Spatial Data Lakehouse

Explore how Apache Iceberg based Havasu redefines data management for geospatial data lakehouse architectures. Learn to optimize the storage, querying, and analysis of large-scale spatial datasets with high performance and cost efficiency.

Accelerating Vector and Raster Analysis at GeoPostcodes

How long is too long to wait for a data set to process? In the fast-paced world of data as a service, efficiency isn't just a nice-to-have; it's essential. But for GeoPostcodes, previous updates to the global population movement datasets took about 39 days. This was running on a headless QGIS instance in combination with PostGIS, combining population rasters with postal code boundaries.

Overture Data In Wherobots Spatial Data Catalog

Effortlessly access and analyze Overture Maps Foundation data with Wherobots. This guide details seamless integration, leveraging our Havasu Iceberg spatial catalog for optimized performance and insightful visualizations. Explore practical examples and unlock new possibilities in geospatial data analysis.

How to shift Apache Sedona on Spark workloads to WherobotsDB

Wherobots customers are realizing up to a 20x performance increase and significant cost savings by shifting their Apache Sedona workloads into Wherobots. This guide shows you how easy it is to migrate Apache Sedona workloads into WherobotsDB, and focuses on best practices for Apache Sedona migrations from Amazon EMR, AWS Glue, and Databricks.

Introducing kNN Join for Wherobots and Apache Sedona

We are excited to introduce the k-Nearest Neighbors Join (kNN Join) for WherobotsDB and Apache Sedona 1.7.0. With the kNN Join, you can efficiently find the closest entities to your points of interest from datasets at scale. We’ve released two types of kNN Joins: the Exact kNN Join and the Approximate kNN Join. With these two kNN Join options, you can efficiently find the closest entities to your points of interest from datasets at scale, and trade off performance versus accuracy needs.

Wherobots and PostgreSQL + PostGIS: A Synergy in Spatial Analysis

TL;DR Wherobots (powered by Apache Sedona) and PostgreSQL + PostGIS are complementary tools, not competitors. Use Wherobots for large-scale spatial ETL, processing speed, and distributed analytics. Use PostGIS for data persistence, transactional integrity, and long-term storage. Together, they form a complete spatial data pipeline. At scale, WherobotsDB is up to 317x faster than PostGIS on […]

Generate Global PMTiles in 26 Minutes: Processing 2.3B Overture Maps Data

Learn why WherobotsDB VTiles is the most scalable and performant solution for generating vector tiles. We will demonstrate this by generating vector tiles from a massive (>2 billion record) worldwide dataset in 26 minutes.

WherobotsAI Map Matching: Turn GPS Tracks into Road-Aligned Trip Insights at Scale

WherobotsAI Map Matching offers an advanced solution for this problem that's significantly more performant and 99% lower cost than Mapbox, Google Maps, or HERE maps alternatives. It performs map matching with high scale on millions or even billions of trips with ease and performance, ensuring that the GPS data aligns accurately with the actual paths most likely taken.

Quickly and Easily Create Vector Tiles with Wherobots and Overture Maps Foundation Data

Editor’s note: The Wherobots Spatial Data Catalog is now the Havasu Catalog. Generating map tiles can be challenging and expensive, especially when dealing with large datasets like those from the Overture Maps Foundation (Overture). It’s challenging and expensive because typical solutions are not scalable or performant, which forces you to build workarounds that waste your […]