PAINLESS GEOSPATIAL ANALYTICS USING MOTHERDUCK’S NATIVE INTEGRATION WITH GALILEO.WORLD

Galileo.world – GIS meets DuckDB

Traditionally, geospatial analysis meant spinning up a dedicated infrastructure: PostGIS databases, servers and scripts for data conversion. With DuckDB spatial extension, your device alone becomes a powerful spatial tool.

Galileo.world takes advantage of DuckDB-Wasm’s capabilities of running queries directly in the browser and MotherDuck’s infrastructure to leverage performance for bigger datasets. Its technology is mostly based on these foundations:

• DuckDB-Wasm: In-browser analytics engine for fast, serverless queries
• MotherDuck: Native integration for scale
• Deck.gl: GPU-accelerated layers for smooth, large maps

Therefore, most of the action occurs in your browser, which results not only in performance, but also privacy, since files and maps do not leave it, unless you decide to share them.

How regular GIS works:

How galileo.world works:

Galileo.world’s key features:

• Private by design: Everything runs in your browser — no data leaves unless you share.
• Simple file input: Load Parquet, GeoJSON, CSV, KML, SHP — directly in the browser
• MotherDuck native: Hassle free geospatial analytics with your MotherDuck datasets.
• Custom visualizations and analytics: Create responsive maps, charts and dashboards from geospatial data
• Simple sharing: Share public projects or keep them local
• Public data catalog: Add layers from a growing public data catalog to your projects

Working with big geospatial datasets – the pain points

When working with geospatial data, two things kill performance: high amount of and high complexity of geometries. It’s common to see the following issues related to them:

• Plotting everything causes memory bloat and UI stops responding
• Maps get excessively slow when zooming or panning
• Geometries overlap, creating more confusion than understanding

In practice, raw plotting of big datasets creates significant bottlenecks for real-time interactivity, turning exploration and analysis into a struggle.

The most common strategy for this case scenario is create tiles. A tile is simply a small piece of a bigger dataset, divided by predefined grids at each zoom level. Each tile contains a limited number of geometries and edges, usually defined when you create it. That limitation allows tiles to render faster while still visually convincing for bigger datasets.

Even though tiles work very well for visualization, they are not designed for analytical purposes, since they do not necessarily contain all the data from the original dataset. Therefore, performing calculations over tiles can provide misleading results due to incomplete data.

A more comprehensive guide to tiling can be found here.

Visualization + analytics for all sizes of geospatial data – the dual execution engine

In order to display big datasets and still maintain analytical fidelity to the original data, galileo.world adopts a dual execution engine. Taking advantage of DuckDB-Wasm and MotherDuck full capabilities, the app operates with multiple workers, orchestrating queries that’ll plot geometries on the map and those that will provide analytical outputs such as charts.

For visualization, the dataset goes through sampling and geometry simplification, which virtually eliminates any dataset size limitations and increases performance while dynamically zooming or panning.

For analytics, not only the data displayed on the map is used, but the entire original dataset, hence preventing misleading calculations and missing data.

Whether working with big or small geospatial data, the combination of MotherDuck and galileo.world is a powerful duo to make your data analysis, visualization and project sharing faster, simpler and more secure. Try it here to see what’s possible and join galileo.world’s slack community.