Crunchy Bridge for Analytics

Accelerate Your Spatial Analytics

Crunchy Bridge for Analytics extends the power and familiarity of PostGIS with an optimized hybrid query engine to connect you to remote data stores of GeoParquet, Shapefiles, GeoJSON, and more.

Query the biggest spatial datasets on earth

Run quick summaries and rollups against large public or private datasets with ease.

Bring large spatial data sets into PostGIS

Import data with a simple URL and run the full range of PostGIS functions in moments.

Cost Efficient Spatial Data Management

Store, query, and analyze geospatial data at scale while benefiting from cost effect object storage such as S3.

Connect any geospatial data set to Postgres & PostGIS

Crunchy Bridge for Analytics empowers you to use PostGIS with a wide range of cloud native spatial data formats directly without the need to import them into local storage. Analyze and visualize GeoParquet, GeoJSON, KML, Shapefiles, and GeoPackages, all while keeping your data in its native environment. We automatically map columns and data types from a variety of source formats directly to your Postgres and PostGIS environment without manual intervention.

  • - Public datasets in S3 or https url
  • - Private datasets in S3

GeoParquet

Efficiently query GeoParquet files stored in S3 or other cloud storage, taking advantage of its columnar data structure for high-performance analytics on large datasets.

GeoJSON

Access and analyze GeoJSON files remotely, leveraging the flexibility of this lightweight format for web-based mapping and location-based services.

Shapefile

Perform queries on zipped shapefiles stored remotely, reducing data transfer overhead and enabling fast access to one of the most common geospatial formats used in GIS applications worldwide.

KML

Work with KML files directly from your remote storage locations, enabling easy integration with Google Earth and other GIS tools while maintaining full analytical capabilities.

GeoPackage

Utilize the rich feature set of GeoPackage files, a modern, open standard for geospatial information, directly from remote storage, combining the power of SQLite databases with the versatility of PostGIS for complex spatial queries.

CSV

Analyze spatial data stored in CSV files, including those with coordinate columns, directly from remote storage. This allows for easy integration of tabular data with geospatial coordinates into your PostGIS environment.

Simple and fast spatial analytics at your fingertips

Access a data store

Getting started is as easy as copying a URL or S3 location. no need No need for complicated data loading or ingest pipelines

Create tables

Create foreign tables to query data. Create local tables and views to work with data in PostGIS directly.

Build your projects

Import your data, create maps directly in QGIS, or run summary statistics on big spatial data.

PostGIS integrated with DuckDB

Hybrid Query Engine

By deeply integrating DuckDB into PostgreSQL, we delegate PostGIS functions and operators to DuckDB spatial where possible for fast queries on GeoParquet.

Simplified Data Management

Easily transfer data between S3 and Postgres / PostGIS Postgres, all without the need for complex ETL processes.

Capture analytics and data from Overture

Query Overture Directly

Crunchy Bridge for Analytics provides direct access to the Overture maps dataset, allowing you to execute complex queries and perform in-depth analyses on up-to-date, high-quality geospatial data. You can extract actionable data from Overture, enhancing your spatial applications without the need for cumbersome data transfers or manual processing.

Import from Overture

Integrate Overture data into PostGIS with an easy and efficient data import. Work with Overture data in PostGIS and leverage the powerful spatial functions, indexing capabilities, complex geospatial queries, and analysis. Effortlessly connect it to QGIS for advanced visualization and mapping.

Big Spatial Data Doesn't Have to be Complicated

Crunchy Bridge for Analytics offers a spatial analytics solution that significantly simplifies the process compared to traditional solutions. Unlike other platforms that require cumbersome data migration, complex setup procedures, and extensive manual configuration, Crunchy Bridge for Analytics provides a seamless, integrated experience for geospatial analytics. Our solution allows for direct querying of diverse spatial formats from remote storage, eliminating the need for tedious data imports and transformations.

Contact us